Smart Mapping with Google Sheets

485
1
10-04-2019 07:27 AM
JohnnyHarley2
New Contributor

I am tasked with a very interesting project. I have a google sheets document that contains non spatial data. I have a custom ArcGIS Javascript API map that has a states shapefile from AGOL. I want this google sheets doc to be "live" in the map. I have read ESRI documents about uploading a CSV into AGOL but it needs a spatial which this does not have. I have looked at several different scenerios. One would be a python script using Pygsheets or using another cloud based storage system to reference the spreadsheet. Sorry if that was confusing but some advice would be greatly appreciated!

Tags (1)
0 Kudos
1 Reply
Noah-Sager
Esri Regular Contributor

If the google sheets document contains non-spatial data, does it contain any fields in common with the states shapefile from AGOL? If so, you could try to join the date together.

Join Features—ArcGIS Online Help | Documentation 

0 Kudos