Skip to content

README.md

Latest commit

 

History

History
55 lines (33 loc) · 1.86 KB

README.md

File metadata and controls

55 lines (33 loc) · 1.86 KB

Overture Maps 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 Lessons

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.ddb' as overture;

-- Now you can just reference `overture.place` for type=place features
SELECT count(1) from overture.place;

Github Codespaces

Create a new codespace from the workshop repository in 3 clicks:

Codespace

Launch JupyterLab

Once your codespace is active, you can open it in JupyterLab to easily run interactive notebooks Jupyter Lab