OpenStreetMap Switzerland

ABOUT
=====

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

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_CHE_NODE
V_OSM_CHE_WAY
V_OSM_CHE_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地理位置信息，包含节点、路径和关系等核心要素及其坐标数据，适用于地理编码、交通分析、旅游规划等多种应用场景。所有数据遵循ODbL许可协议，并附有详细的文档说明。