search

OpenEugene / fire-refuge

helping folks find temporary refuge from fire impacted zones
MIT License
2 stars 1 forks source link

sync Airtable with ArcGIS #19

Open markdav-is opened 4 years ago

markdav-is commented 4 years ago

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 commented 4 years ago

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

markdav-is commented 4 years ago

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

markdav-is commented 4 years ago

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

thomasfiorelli commented 4 years ago

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 commented 4 years ago

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

thomasfiorelli commented 4 years ago

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

markdav-is commented 4 years ago

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 commented 4 years ago

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

markdav-is commented 4 years ago

might be the blank row.

thomasfiorelli commented 4 years ago

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 commented 4 years ago

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

thomasfiorelli commented 4 years ago

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.