Sonra: OpenStreetMap Switzerland
Location data from OpenStreetMap for Switzerland
This data set includes all of the OpenStreetMap location data for Switzerland.
It contains all of the features and coordinates for Nodes, Ways, Relations for Switzerland.
Full documentation: https://sonra.io/wp-content/uploads/2020/08/OpenStreetMap_-_Snowflake_Data_Marketplace_Documentation.pdf
Reverse geocoding: https://sonra.io/2020/12/24/reverse-geocoding-on-snowflake/
Location analytics: https://sonra.io/2021/02/19/snowflake-location-analytics-on-snowflake-with-openstreetmap-us-property-data-and-our-ready-made-geography-dimension/
Public transport, e.g. location of bus stops, train stations, bus routes, railways etc.
Shortest path analysis
Tourism, e.g. location of sights
Streets and roads, e.g. address validation
Business listings, e.g. find the number of supermarkets in a city, region, county etc.
Planning, e.g. what are areas with a high population density with a low number of supermarkets
Use the location features to improve predictive models.
And much more.
For a full description of the available location features refer to the OpenStreetMap documentation: https://wiki.openstreetmap.org/wiki/Map_Features
We have put together a comprehensive documentation which includes a description of all of the tables and columns in the data set, sample queries, and an introduction to the core OpenStreetMap objects
You can view the documentation here: https://sonra.io/wp-content/uploads/2020/08/OpenStreetMap_-_Snowflake_Data_Marketplace_Documentation.pdf
The data set contains the three core OpenStreetMap objects as tables.
The data set also contains additional feature tables where we have pivoted the key/value pairs to columns in tables. We constantly add feature tables. Refer to the documentation for details
OpenStreetMap data by OpenStreetMap Foundation https://wiki.osmfoundation.org/wiki/Main_Page is licensed under Open Data Commons Open Database License (ODbL)
About the Provider:
Sonra offers products and services in data management and data analytics.
Flexter is our flagship product. It automates the conversion of industry data standards, XML, JSON to a relational model on Snowflake, relational databases, and big data formats
Sonra provides Snowflake various professional services, e.g. migration services, quickstarts.
Sonra provides data advisory services, e.g. data architecture and strategy.