After the intense interest shown to the community topic Available "Big data sets" over the internet... (since ‎22-11-2015) 57REPLIES20829VIEWS I'm now trying to split that into more meaningful, more focued sections. So that people can get an understanding of * industry specific data and * business problems that can be solved easily with Alteryx... This specific section is on #Geospatial datasources, maps, road network data, traffic data, footfall data, points of Interest, DEM (digital elevation maps)

Geospatial Datasets

After the intense interest shown to the community topic Available "Big data sets" over the internet... (since ‎22-11-2015)

57REPLIES

20829VIEWS

I'm now trying to split that into more meaningful, more focued sections. So that people can get an understanding of

industry specific data and
business problems that can be solved easily with Alteryx...

This specific section is on #Geospatial datasources, maps, road network data, traffic data, footfall data, points of Interest, DEM (digital elevation maps)

Datasets

Accepted answers

Atabarezz

POI datasets are extremely useful to enrich your customer databases with the help of Find Nearest Neighbors tool.

But these datasets are not easy to find and they may be expensive if you cover a vast geography.

osm

The openstreetmap community is going great;

http://poi-osm.ekibox.net/

Here is an address for you to download POI in KML format...

marco_zara

That info is pretty old (2014!), we can do better with Alteryx!

I successfully managed to extract all OpenStreetMap features from their XML files on a centroid basis (but we can easily rely on geofrabrik datasets for polygons), if you're interested I can dig up the workflows...

estherb47

Here is some interesting information on US geospatial: https://catalog.data.gov/dataset?tags=cities

And, while I haven't used it yet, this looks promising! https://github.com/kelvins/US-Cities-Database

Cheers!

Esther

marco_zara

I managed to recreate my OSM feature extraction datasets, however on larger areas I think the sheer number of columns breaks the crosstab tool...

Base file is here: https://download.geofabrik.de/europe/italy/nord-ovest-latest.osm.bz2

Unzip it and run the two workflows, any feedback is extremely welcome!

Barring a few small issues this can be used along with OSM shapefiles to obtain some extremely powerful geographical profiling.

With a few community refinements we might turn this into something useful!

OSM.zip

Atabarezz

Let me share with you another great geospatial datasource that I came accross recently;

https://hub.arcgis.com/pages/open-data

All comments

r4upadhye

Hey, Im interested in geospatial data analysis, I had a mini module for analyzing predefined boundaries and polyshapes for one of our client. It was for a Polish Railway Company though.

Would be interested in contributing to your version too.

Atabarezz

POI datasets are extremely useful to enrich your customer databases with the help of Find Nearest Neighbors tool.

But these datasets are not easy to find and they may be expensive if you cover a vast geography.

osm

The openstreetmap community is going great;

http://poi-osm.ekibox.net/

Here is an address for you to download POI in KML format...

marco_zara

That info is pretty old (2014!), we can do better with Alteryx!

estherb47

Here is some interesting information on US geospatial: https://catalog.data.gov/dataset?tags=cities

And, while I haven't used it yet, this looks promising! https://github.com/kelvins/US-Cities-Database

Cheers!

Esther

Atabarezz

Let me share with you another great geospatial datasource that I came accross recently;

https://hub.arcgis.com/pages/open-data

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703