workshop
Overture Data Workshop
Resources
| Name | Description |
|---|---|
| Overture Explore Page | Easiest place to get an overview of Overture data in an X-Ray map view |
| Overture Documentation | Schema definition and examples of how to access and work with Overture data |
| DuckDB | A fast in-process database system for analytics and data manipulation |
| Fused.io | A cloud-based analytics platform with User Defined Functions and embedded map visualization. |
Workshop Pages
1. What is Overture Maps?
2. Exploring Overture Maps Data
3. Accessing Overture Maps GeoParquet with DuckDB
4. Global Entity Reference System (GERS)
5. Base Theme
Workshop Setup
This workshop can be run either locally with DuckDB and a local Jupyter Notebook environment or in the cloud with Github codespaces (instructions below).
DuckDB Tip! When launching DuckDB, be sure to specify a database, such as duckdb workshop.dbb. You can now save tables and views that will persist in a future session.
Experimental: Attach the following database in DuckDB to access the latest Overture data:
LOAD spatial;
ATTACH 'https://labs.overturemaps.org/data/latest.dbb' as overture;
-- Now you can just reference `overture.place` for type=place features
SELECT count(1) from overture.place;
┌─────────────────┐
│ count(1) │
│ int64 │
├─────────────────┤
│ 66044470 │
│ (66.04 million) │
└─────────────────┘
1. Github Codespaces
Create a new codespace from the workshop repository in 3 clicks:
2. Launch JupyterLab
Once your codespace is active, you can open it in JupyterLab to easily run interactive notebooks
