Sonra: OpenStreetMap United Kingdom (UK)

Location data for United Kingdom (UK)

Description:
ABOUT
=====

This data set includes all of the OpenStreetMap location data for United Kingdom.

It contains all of the features and coordinates for Nodes, Ways, Relations for United Kingdom.

Full documentation: https://sonra.io/wp-content/uploads/2020/08/OpenStreetMap_-_Snowflake_Data_Marketplace_Documentation.pdf

USE CASES
=========

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/
Administrative Boundaries
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
Waterways
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

DOCUMENTATION
===============

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

TABLES
=======

CORE TABLES
——————–

The data set contains the three core OpenStreetMap objects as tables.

V_OSM_UK_NODE
V_OSM_UK_WAY
V_OSM_UK_RELATION

FEATURE 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

ATTRIBUTION
==========

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 liberates data from data siloes and complex data structures.
Automatically convert industry data standards (HL7, ACORD, FpML, ISO 20022 etc.) to a relational model on Snowflake with Flexter, our data warehouse automation solution for XML and JSON.

Visit the provider’s website for more information

*The Data Marketplace is not yet available in GCP.

Get access to the Sonra: OpenStreetMap United Kingdom (UK) Dataset in Snowflake

Sign up for a free trial

Already a Snowflake customer?
Access this dataset directly from your Snowflake account*