Import Data into ArcMap

MattWithAHat · 2018-08-03T14:52:01.000Z

Hello,

I have downloaded a GeoJSON file of public transportation stops in a specific region and want to import it to ArcMap as a feature layer. I tried the JSON To Features tool. Unfortunately this gives me this error code:

ERROR 001558: Error parsing json file 'D:\Eigene Dokumente\ArcGIS\Datensätze\GIS I\GIS Projekt\public-transportation\public-transport-stops.json'. Expected to find comma, colon or start of array; state : Empty; buffer : <?xml version="1.0" encoding="UTF-8"?>
<osm versio
Failed to execute (JSONToFeatures).

Looking up the error, it tells me the following:

Description
The JSON structure does not conform to ESRI-JSON standard for feature sets.

Solution
Review the JSON structure in the input file. The JSON must have at least the geometryType, spatialReference, fields, and features (with geometry and attributes) property.

So, I guess it has to be in a different format. I didn’t find a way to import my data yet. I’m sure a lot of people use ArcMap with Openstreetmap data, how do you import coordinates?

Gertjan_Idema · 2018-08-03T20:13:55.000Z

Your file is an xml file. You should either use an xml parser or find a json file with the same data.

mboeringa · 2018-08-04T00:15:15.000Z

For ArcMap, I would really recommend you to download a Geofabrik bzipped XML file, or create an OSM XML file with any of the Open Source tools like Overpass Turbo, and then use the ArcGIS Editor For OpenStreetMap toolbox to import the XML file:

https://www.esri.com/arcgis-blog/products/arcgis-desktop/uncategorized/arcgis-editor-for-openstreetmap-10-6-now-available/

You can use both the Load OSM File and the OSM File Loader (Load Only) import tools, both of which create a File Geodatabase with Point, Line and Polygon feature classes for the data in the XML file. The latter tool has advantages for very big files, as it can run on multiple cores if you set the Geoprocessing “Parallel Processing” environment variable. The former is needed if you want to create a Network Dataset with the tool included in that toolbox for that purpose (I haven’t actually done this ever, and some people have reported issues trying to create such Network Dataset. Normal imports using the tools should be fine though).