ArcGIS REST Service

[openbrewerydb]

ArcGIS REST Service

[pjdohertygis]

Ok I can export any feedback I get using the Survey123 Form. Most of the feedback will be based on the older dataset I used, but I have a few people using the app and will do a data dump when I get a couple more.

[pjdohertygis]

I have ArcGIS Online and am willing to host the service as ArcGIS REST, just need a little help setting up a live feed methodology. Python / Jupyter ArcGIS Notebooks might be an option. For now a .csv with x and y coordinates would work to get something started.

[chrisjm]

@pjdohertygis It's not very clean, but check out https://raw.githubusercontent.com/openbrewerydb/openbrewerydb/master/breweries.csv

I know very little about ArcGIS, but I do know about Python and Jupyter notebooks.

I can update the build script to include a CSV of any format, so just let me know what columns/schema you want, and maybe Github can host a breweries-arcgis.csv for those projects. Would that work for your use-case?

[pjdohertygis]

Thank you I'll check into this tonight. So far the format looks good, however I see a number of features / rows without latitude longitude. Do you know how these are being derived? Are you geocoding the data (extracting the x,y from addresses) yourself or are they coming in from another source?

[chrisjm]

@pjdohertygis Yes, the lat/long was derived by a script. Probably Google Maps, but I don't remember. Worth another pass, so I'll look into that unless you have other suggestions. I'm sure some of those breweries without lat/long probably also don't have valid addresses so they might just be dropped.

[pjdohertygis]

@chrisjm ok that sounds about right to me. We might be able to recruit volunteers from the GISCorps (giscorps.org) or similar if you need help with that!

[pjdohertygis]

Ok here is early progress.

1. Nearby App - I've added the Open Brewery DB layer to this web mapping application so you can search for nearest breweries from both Open Brewery DB and POI Factor. https://www.arcgis.com/apps/instant/nearby/index.html?appid=97c038a5294c483d9d849e04783fb7d0

2. Layer - Please let me know if you are happy with the attribution here, we can add more links to drive people to your site as needed. https://www.arcgis.com/home/item.html?id=89addde0389a4b0393dff7e440c517a1#overview

[chrisjm]

Awesome! Thanks so much, @pjdohertygis !

Not super important, but OBDB is more of a community than a "team" :) Feel free to join us on Discord if that's of interest to you. I think we have a couple of GIS fans there. 🗺️

[pjdohertygis]

I was able to geocode an additional ~2,000 breweries from Open Brewery DB and have added to the map here https://www.arcgis.com/apps/instant/nearby/index.html?appid=97c038a5294c483d9d849e04783fb7d0

Let me know if you'd like an export of the data so you can fill out the rest of the x,y fields.

[chrisjm]

@pjdohertygis Very nice! Yes, we'll take an export and look into matching up the data. Thank you!

[pjdohertygis]

You should be able to download from this website (it is a the item property page for the "feature layer" https://pjdohertymaps.maps.arcgis.com/home/item.html?id=89addde0389a4b0393dff7e440c517a1#overview

[pjdohertygis]

If that does not work, please try from this website, it is a static and time stamped export as a .csv file https://pjdohertymaps.maps.arcgis.com/home/item.html?id=d086f466d0ea48cd8d2aeb6a9112e30b

[pjdohertygis]

@pjdohertygis Very nice! Yes, we'll take an export and look into matching up the data. Thank you!

I think you can probably discard the x,y for any features that do not include an address, as these are just the centroid for the city or zip code provided. Have you considered crowd/brewer sourcing to fill in some info-gaps? Here is a prototype I had started using a while back https://survey123.arcgis.com/share/0b7b05d7b47f4a24a159d94f84742cf8

[chrisjm]

Cool, thanks @pjdohertygis ! We are crowdsourcing through this repository. In the past OBDB has been mostly used by developers so the workflow has been mostly fine. But, the audience seems to be changing so we're working on alternate methods and getting it into a roadmap. 🍻

[chrisjm]

This is an old discussion. Any new REST services should be created into new projects since this repo is mostly about updating and maintaining the dataset. We will still need more geocoding, but that's not this issue. 😄