topic Re: Table join to json data? in Python Questions

Table join to json data?

RowanWinsemius — Fri, 14 Nov 2014 02:20:26 GMT

Hi there,

I've often used the standard join tool to join spatial data with a table however Im wondering if its possible to setup a join to json data which represents a table? The scenario is I have a google sheet (like an excel but in the cloud), within ArcGIS desktop I'd like to be able to run my join on to this data which I can I can access via json... Can anyone suggest any ideas as to how this might be feasible?

Cheers,

Rowan

PS I can't find a regular ArcGIS Desktop forum so I'm posting here sorry..

Re: Table join to json data?

TimGowner — Fri, 14 Nov 2014 12:57:07 GMT

Perhaps it would be helpful to first import the JSON into a spreadsheet as well then match them up in the same spreadsheet. You can use a tool like https://json-csv.com‌ to convert the JSON.

Re: Table join to json data?

XanderBakker — Sat, 15 Nov 2014 03:06:25 GMT

You could use some Python code to retrieve the JSON from Google Docs and join it using python (arcpy) to a featureclass.

And yes, you should probably move this to a different place, since installation support has nothing to do with your question.

Kind regards, Xander

Re: Table join to json data?

RowanWinsemius — Sun, 16 Nov 2014 21:56:11 GMT

Thanks for the suggestion Tim but I was hoping to be able to have it as a live join rather than converting it to a static data source like a csv.

Cheers

Re: Table join to json data?

XanderBakker — Mon, 17 Nov 2014 02:06:06 GMT

Maybe you find the necessary information in this website:

Python Example - Google Cloud Storage — Google Cloud Platform

Kind regards, Xander