Skip to main content
Question

FME Ingesting AGOL json

geckosolutions
Contributor
Forum|alt.badge.img+4

Hi Everyone,

 

I have this “open” dataset provided by the City of Toronto.  I am using a few from the city that are provided in this manner.  The only way to bring it into ArcPro and then extract it to a geodatabase is to use the json address and add by url, then use the ‘feature to point’ geoprocessing tool to extract the data to points in gdb format, then use as needed.  

I need to get this layer into FME from the live feed so I can analyze it and then push it out via other format(s), one of which is AGOL feature layer.

For some reason I have been unable to bring it into my FME script via any JSON reader or HTTP caller and I’m wondering if anyone else here will have more luck.

The link I am working with is as follows:

https://gis.toronto.ca/arcgis/rest/services/cot_geospatial2/MapServer/64

The json link is:

https://gis.toronto.ca/arcgis/rest/services/cot_geospatial2/MapServer/64?f=pjson

 

If anyone has the steps to bring the content into FME (geometry and attributes) to have it available for further analysis, that would be great.

I’m not good with JSON so I have to admin, that could be a large reason for this trouble.

Thanks,

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

The service is acting… special. But with a generic FeatureReader FME is able to read it.

  • Start FME Desktop.
  • Add a Creater transformer.
  • Connect a FeatureReader transformer.
  • Click ... Feature Types to Read and select “Road Restriction Point”.
  • Under Output Ports, select Single Output Port.
  • Close FeatureReader with FeatureCaching on.
  • Run workspace.
  • Attach AttributeExposer to Generic outputport and import, select from feature cache.

Sample workspace attached.

1 Attachments
geckosolutions
1 person upvoted this
  • geckosolutions
    geckosolutions
geckosolutions
Contributor
Forum|alt.badge.img+4

Thanks for the help, I had an colleague working the problem as well and they came up with the same solution, but for some reason my system cannot connect via the script that works for them.  I have IT working on the issue to see if there is something there.  I am able to put the link in a browser and resolve the content/layers there just fine, but in FME feature reader it will not connect.

 

This is something I tried months ago and gave up quickly as I did not have time to troubleshoot, very frustrating to think it ‘should’ have worked and could have made my processes much simpler over the last few months.

Reply


Helpful Members This Week

Community Stats

31,082
Posts
117,842
Replies
38,837
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.