AnsweredAssumed Answered

How to add JSON layer into ArcGIS Online?

Question asked by afiolitakis on Aug 31, 2015
Latest reply on Sep 2, 2015 by bharold-esristaff

Hi, I am trying to find a way to get a feed of species observation data from the NatureWatch NZ database into ArcGIS Online using the iNat API

http://naturewatch.org.nz/pages/api+reference  The data needs to be refreshed automatically with new observations from the NatureWatch database, so uploading a static file from drive is not an option.

 

I am looking at a specific NatureWatch project called "Piwauwau NZ Rock Wren monitoring" which can be accessed in JSON or CSV format via the following urls:

http://www.inaturalist.org/observations/project/piwauwau-nz-rock-wren-national-count.json

http://www.inaturalist.org/observations/project/piwauwau-nz-rock-wren-national-count.csv

(these only return the first page of results - I haven't yet figured out how to get all pages)

 

The data can also be accessed in KML and Atom formats, which I have been able to add directly as web layers into ArcGIS Online, however these formats do not contain all of the original attribute columns.

 

I have tried adding the CSV version as a web layer, however this returns the following error, which I suspect might be because there are spaces in some of the column names.:

Does anyone know a way of getting the JSON feed from the iNat API into ArcGIS Online as a layer?

Outcomes