sync Airtable with ArcGIS

[markdav-is]

As part of the build process read the AirTable and create a static CSV file.
Host that file as a static resource here http://FireRefuge.com/data/Shelter.csv
Then @thomasfiorelli can point to that for the his layer data.

[markdav-is]

@thomasfiorelli try this: https://raw.githubusercontent.com/OpenEugene/fire-refuge/master/static/data/shelter.csv

[markdav-is]

I'm looking into airtable apps https://airtable.com/marketplace

[markdav-is]

@thomasfiorelli when you are setting up the URL for CSV download can you set the interval. like every X hours?

[thomasfiorelli]

yes, that is correct. Once I add the the CSV to the ESRI server on my end, I have the ability to change the refresh interval directly from the Web Map. Once changed, that setting will carry forward to the Web App we see in the online link.

[markdav-is]

@thomasfiorelli I'll have a service up and running today. please verify that you can consume this style of csv (attached)
response.zip

[thomasfiorelli]

The .csv imports properly and the coordinates are displaying on the map.

[markdav-is]

here's a valid service link you can try hosted on the Open Eugene CfA Azure: https://cachetable.azurewebsites.net/csv/FireRefuge/Shelters

I'll move this to MVP studio soon. Please test that link and let me know if it works.
I'm guessing refreshing every few hours would be a fine interval.

[thomasfiorelli]

While the data imports, I am warned of the following:

[markdav-is]

might be the blank row.

[thomasfiorelli]

This warning may be trivial. Looking through the attribute table on the GIS web map, I can see there are 8 attributes, which appears to match the number of records in the .csv. All fields appear to be showing.

[markdav-is]

this is great news! I'll show you how to configure other tables and views. Here's some quick drawings:

[thomasfiorelli]

Thank you for the run down! The Airtable API and the ability to customize and dispaly different views for different purposes from the same dataset are incredilbly useful.