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

View as Slideshow

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