We followed Receive GeoJSON on a REST Endpoint to send weather data to ArcGIS as feature data. Unfortunately, the data is parsed they way we hope or expect. We've tried to have features updated or created when the data is received, and also just converted to csv in a file.
Here's what we're sending:
{
"type": "FeatureCollection",
"features": [
{
"type": "Feature",
"geometry": {
"type": "Point",
"coordinates": [
-93.265,
44.9778
]
},
"properties": {
"loc": {
"lat": 44.9778,
"long": -93.265
},
"place": {
"name": "minneapolis",
"state": "mn",
"country": "us"
},
"periods": [
{
"timestamp": 1608324300,
"dateTimeISO": "2020-12-18T14:45:00-06:00",
"tempC": 5.44,
"tempF": 41.79,
"feelslikeC": 4.31,
"feelslikeF": 39.77,
"dewpointC": -0.59,
"dewpointF": 30.93,
"humidity": 65,
"pressureMB": 1014,
"pressureIN": 29.94,
"windDir": "SSW",
"windDirDEG": 194,
"windSpeedKTS": 3.5,
"windSpeedKPH": 6.48,
"windSpeedMPH": 4.03,
"windGustKTS": 12.12,
"windGustKPH": 22.45,
"windGustMPH": 13.95,
"precipMM": 0,
"precipIN": 0,
"snowCM": 0,
"snowIN": 0,
"visibilityKM": 24.135,
"visibilityMI": 14.997,
"sky": 100,
"cloudsCoded": "OV",
"weather": "Cloudy",
"weatherCoded": "::OV",
"weatherPrimary": "Cloudy",
"weatherPrimaryCoded": "::OV",
"icon": "cloudy.png",
"solradWM2": 49,
"uvi": 0,
"isDay": true
}
],
"profile": {
"tz": "America/Chicago",
"tzname": "CST",
"tzoffset": -21600,
"isDST": false,
"elevFT": null,
"elevM": null
}
}
}
]
}
Here are the fields that got created the first time that we sent a post to the endpoint:
Unfortunately, only Geometry actually gets populated with data when a post is sent. The data is the lat and long, in quotes, separated by commas. None of the other fields shown above show any data. Do we need to define fields manually (using the "New Field" button in the screen capture above), perhaps whatever of the subfields in the geoJSON we want, e.g., tempF in the periods array? I'm now also noticing the Tags column in the above, but don't know what they mean.
The geoJSON as shown above is coming from another API, unaltered, so not having to process/reformat it ourselves before sending it on to ArcGIS would make everything simpler, though we can do that, if necessary.