topic Re: Proper ESRI format for a JSON file in Python Questions

Proper ESRI format for a JSON file

JustinBridwell2 — Wed, 17 Oct 2018 19:57:25 GMT

I keep getting a 001558: Error parsing .json file. According to ESRI documentation for that error, "the JSON must have at least the geometryType, spatialReference, fields, and features (with geometry and attributes) property."

I checked my .json file and it appeared to have all that but I want to see an example of a proper format. Can anyone give me a proper example of hwo ESRI want a file to look. Below is what my .json file looks like:

{"displayFieldName": "CSLF_ID","fieldAliases": {...},"geometryType": "esriGeometryPolygon","spatialReference": {  "wkid": 102100,  "latestWkid": 3857},"fields": [...],"features": [  {"attributes": {...},   "geometry": {...}  },...]}

Re: Proper ESRI format for a JSON file

JoshuaBixby — Wed, 17 Oct 2018 20:24:04 GMT

What tool is generating the error and how are you calling it?

Re: Proper ESRI format for a JSON file

JustinBridwell2 — Wed, 17 Oct 2018 21:18:10 GMT

I've tried this in both my Python script using:

arcpy.env.workspace = directory + "/gdb"
path = "<filepath for json file>"
fc = arcpy.JSONToFeatures_conversion(path, os.path.join("cslf.gdb", "cslf_{}".format(today)))

As well as using the manual JSONToFeatures tool in my toolbox in ArcMap (under Conversions) just using the same file. Both give me the exact same error.

Re: Proper ESRI format for a JSON file

JoshuaBixby — Wed, 17 Oct 2018 22:16:04 GMT

I think An overview of the JSON toolset—Help | ArcGIS for Desktop is out of date. I thought "fieldAliases" was deprecated back around 10.0. Try removing that element and see if it works.

FeatureSet object—Common Data Types | ArcGIS for Developers

Re: Proper ESRI format for a JSON file

JustinBridwell2 — Wed, 17 Oct 2018 22:59:34 GMT

The only difference that I can see in my JSON data is that the geometry comes after the attributes in features. But this was working up until yesterday.

Re: Proper ESRI format for a JSON file

JoshuaBixby — Thu, 18 Oct 2018 12:45:39 GMT

If it was working up until yesterday, then I am at a loss for why is stopped working. Did you install any new Esri software, patches, or updates? Have you tried rebooting the machine?