topic Re: batch load in ArcGIS Explorer Online Questions

batch load

alvisebattistuz — Wed, 11 Jan 2012 14:10:01 GMT

hello, i am using arcgis explorer online. i have a question for you.

it is possible to load data on a map, with a batch process?

thank you

Re: batch load

alvisebattistuz — Thu, 12 Jan 2012 07:41:57 GMT

for example... i want load data (turnover for the regions of italy) every month.
the data are stored on a DB, which can save it on a excel file, or CSV.

it is possible to schedule the load of data with a batch process??

there is someone can help me??

Re: batch load

MikeRudden — Thu, 12 Jan 2012 08:03:42 GMT

Hi,

First a question... Is turnover for regions of Italy point or polygon data?

If it's polygons then i'm afraid I don't have any helpful suggestions. If it's points and contains the location as x/y coordinates then the following should work for you -

1. Load your CSV data into a Google Fusion Table
2. Create a url for the table, based on its unique ID. For example - http://www.google.com/fusiontables/api/query?sql=SELECT * FROM 703548
3. Import the CSV and choose By Url.
4. Save the map

Everytime the map is opened the CSV will be imported directly from the fusion table. Whenever you update your table, the changes will be reflected in the map.

Hope that helps

Mike

Re: batch load

alvisebattistuz — Mon, 16 Jan 2012 08:52:22 GMT

hi, thank you for your support.

the turnover was an example... generally i have data for region or city or province. and my purpose is to show it on the map, in addict to have a batch load scheduled (for example every morning at 8 am).

but, with your process, i will need latitude and longitude, in addict to the name and the postal zip of the places?

i will try with your suggestion!

thank you so much.