OpenStreetMap Netherlands

ABOUT
=====

This data set includes all of the OpenStreetMap location data for Netherlands.

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

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_NL_NODE
V_OSM_NL_WAY
V_OSM_NL_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)

数据集说明
=====
本数据集包含荷兰全境的开放街道地图（OpenStreetMap）位置数据，收录了荷兰境内节点（Nodes）、路径（Ways）、关系（Relations）的全部要素与坐标信息。
完整文档：https://sonra.io/wp-content/uploads/2020/08/OpenStreetMap_-_Snowflake_Data_Marketplace_Documentation.pdf

应用场景
=========
反向地理编码：https://sonra.io/2020/12/24/reverse-geocoding-on-snowflake/
位置分析：https://sonra.io/2021/02/19/snowflake-location-analytics-on-snowflake-with-openstreetmap-us-property-data-and-our-ready-made-geography-dimension/
行政边界管理；
公共交通场景，例如公交站、火车站点位，公交路线、铁路线路等；
最短路径分析；
旅游场景，例如景点点位查询；
街道与道路相关应用，例如地址验证；
商业名录检索，例如查询某城市、区域、郡内的超市数量；
规划分析，例如识别人口密度较高但超市供给不足的区域；
水路交通场景；
利用位置要素优化预测模型，以及更多应用场景。
如需了解可用位置要素的完整说明，请参考开放街道地图官方文档：https://wiki.openstreetmap.org/wiki/Map_Features

文档说明
===============
本数据集配套了一份全面的官方文档，涵盖数据集内所有数据表与字段的说明、示例查询语句，以及开放街道地图核心对象的入门介绍。
您可通过以下链接查阅该文档：https://sonra.io/wp-content/uploads/2020/08/OpenStreetMap_-_Snowflake_Data_Marketplace_Documentation.pdf

数据表结构
=======
核心数据表
--------------------
本数据集以数据表形式收录了开放街道地图的三类核心对象：
V_OSM_NL_NODE、V_OSM_NL_WAY、V_OSM_NL_RELATION

要素数据表
-------------------------
本数据集同时提供额外的要素数据表，已将键值对转换为数据表字段形式。我们将持续新增要素数据表，详细信息请查阅配套文档。

版权声明
==========
开放街道地图数据由开放街道地图基金会（OpenStreetMap Foundation，https://wiki.osmfoundation.org/wiki/Main_Page）提供，采用开放数据共同体开放数据库许可（Open Data Commons Open Database License，ODbL）进行授权。