community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Geospatial Datasets

Alteryx Partner

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

 

  1. industry specific data and
  2. 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)

Highlighted
Alteryx Partner

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.

Alteryx Partner

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

 

FindNearest_71x71.png

 

 

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...

 

1.png

 

2.png

 

3.png

 


4.png

 

 

Alteryx Partner

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...

Alteryx Partner

Exactly! you may be aware there are some spatial data set for alteryx around 15K -20K USD/year, pretty expensive for an SME(small medium enterprise)...

 

With this data plus some contribution from Alteryx people to the openstreetmaps

we can not only cover North America, Canada and Europe but the World...

 

Great opportunity...

 

Alteryx Partner

I can whip up a tutorial in the weekend, just be prepared for extremely long waiting times (I mean days or more) on large datasets, IIRC Italy took me around 3 days to convert.

 

The good side is that OSM potentially has thousands of features for a single point, the bad side is that any point will have usually up to a couple dozen actually populated.

Pulsar
Pulsar

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

Alteryx Partner

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!

Alteryx Partner

Interesting, crosstab seems to get issues at around 600-650 fields.

It looses track of already created ones and detects non-existing duplicates, which is an issue.

Alteryx Partner

I work with over 1000 columns as well and that happens... Great point to raise to the support teams...

Labels