topic Creating a formatted JSON feed in ArcGIS API for Python Questions

Creating a formatted JSON feed

Anonymous User — Sun, 12 Dec 2021 16:54:33 GMT

Hello, I am trying to create a JSON feed from a layer stored in AGO however the coordinates come in as Web Mercator and I need them as WGS84. Using the project function works but is excruciatingly slow

Is there any other way to achieve this?

import json
import time
from arcgis.gis import GIS
from arcgis.geometry import project
gis = GIS(
 profile = "AGOL")#credentials stored in windows identity manager
fc = gis.content.get('LayerID')#layer ID
flayer = fc.layers[0]
fset = flayer.query()

for f in fset.features:
    if f.attributes['GPS_Time'] != None:
        geom=f.geometry['paths'][0] 
        geomarray = []
        for coord in geom:
            geomarray.append({'x':coord[0],'y':coord[1]})
            projectgeom = project(geometries=geomarray, in_sr=3857, out_sr=4326) 
            data={"UploadRequest": {"Projection": 1, "DataLayer": 4, "Issues": [{"Locations": [{"Geometry": projectgeom,"Description": f.attributes['Condition']}],
 "Type": 1,
 "Priority": 3,
 "SourceId": "API-TEST:1",
 "StartTime": f.attributes['GPS_Time'],
 "Url": "https://www.google.com",
 "Description": "This is a test"
 }
 ]
 }
}

Re: Creating a formatted JSON feed

simoxu — Sun, 12 Dec 2021 08:48:18 GMT

Hi Joel,

You don't have to explicitly project all the coordinates. the query function can do it for you when you specify out_sr parameter.

Are you trying to get a JSON representation of the layer? I am asking because you didn't specify the out_fields, the default value is "*" which returns all fields. if this is what you want, it's straightforward to get the JSON representation:

fset = flayer.query(out_sr=4326)
josn_fset = fset.tojson‍‍

If you only want to cherry-pick some information from features in the layer, then get the dict representation and manipulate the dict before converting it to the json format

import json
dict_fset = fset.to_dict()
# do something on the dict_fset
josn.dumps(dict_fset)‍‍‍‍

Also, you can format the code in your post and make it easy to read, that will increase the change for you to get a correct answer. As we all know, indentation in Python is like { and } in some other languages like Javascript, C/C#, Java etc, formatting (white spaces) is actually essential.

In you code, it seems you performing a projection for every coordinates (you can have tens of thousands of coordinates if polygon or polylines are involved), that's why it's excruciatingly slow.

Re: Creating a formatted JSON feed

Anonymous User — Thu, 07 Mar 2019 19:13:19 GMT

Thank you, that is exactly the answer I was looking for. I knew re-projecting each feature was a slow was of doing it but I didn't see another way. I'm just getting started with the API so it's great to know I can bring it in differently.

Thanks again.

Joel

Re: Creating a formatted JSON feed

simoxu — Fri, 08 Mar 2019 00:42:39 GMT

No worries Joel, I am glad it helped.

could you please promote the answer by marking it as the correct answer so that it might also help others with the same question.Cheers.