🪵

DuckDB Spatial Database

Open Beta

.duckdb · application/vnd.duckdb

DuckDB is an embedded analytical database its CWI Amsterdam authors call "SQLite for analytics": a single `.duckdb` file, columnar storage, a vectorized engine, and the `ST_*` spatial function set via the spatial extension. Our exporter writes the selected OSM area into a `.duckdb` container where each map layer becomes its own table. To set expectations honestly: geometry is stored as WKT TEXT in a `geom_wkt` column rather than a native GEOMETRY type — to get real geometry you simply call `ST_GeomFromText(geom_wkt)` after `LOAD spatial`. Coordinates stay in WGS84 (EPSG:4326); spatial indexes and Hilbert sorting are not created — those are left to you.

Exportar DuckDB agora ✨ Beta Aberta — gratuito, sem limites

Principais características

✓Single `.duckdb` file — one table per map layer (polygons, lines, points, roads)

✓Geometry in a `geom_wkt` (WKT) column, read via `ST_GeomFromText` after `LOAD spatial`

✓OSM attributes preserved as separate columns; export metadata in a `_metadata` table

✓Coordinates in WGS84 (EPSG:4326), up to 500,000 features per layer

✓Opens via the `duckdb file.duckdb` CLI or `import duckdb` in Python/R

Que programa abre ficheiros DuckDB

Os seguintes programas e aplicações podem abrir, editar e trabalhar com ficheiros DuckDB Spatial Database (.duckdb) exportados do OSM2CDR:

💻DuckDB CLI 💻Python (pip install duckdb) 📐R (install.packages duckdb) 💻DBeaver 💻JupyterLab

Format specifications

Proprietary format
2D only
Lossless (no quality loss)
Stores feature attributes
Output: 1 file
A single .duckdb file, one table per layer; geometry stored as WKT TEXT in geom_wkt (read via ST_GeomFromText after LOAD spatial), WGS84, no spatial index.

Quem utiliza mapas DuckDB

🏗

Ad-hoc spatial analytics in Jupyter without spinning up a PostgreSQL/PostGIS server

💻

ETL pipelines: read, join and aggregate OSM data in plain SQL with zero infrastructure

📊

dbt models and notebook-driven workflows where `.duckdb` is a portable team artifact

🎨

Prototyping queries before migrating to Snowflake/BigQuery

Como exportar para DuckDB

Selecionar área

Desenhe um retângulo ou polígono no mapa interativo em osm2cdr.ru

Escolher DuckDB

Selecione DuckDB Spatial Database na lista de 127 formatos de exportação disponíveis

Exportar

Clique em Exportar e receba o seu ficheiro .duckdb em 1-5 minutos

Descarregar

Descarregue o ficheiro DuckDB pronto e abra-o no DuckDB CLI

Mapas populares em DuckDB

Free

Obtenha exportações de mapas em DuckDB Spatial Database

Descarregue mapas profissionais em DuckDB a partir do OpenStreetMap. Geração instantânea, qualquer área.

Gratuito / exportação

Exportar DuckDB agora →

Perguntas frequentes

Is geometry stored as a native GEOMETRY type? ▼

How does DuckDB differ from SQLite/GeoPackage? ▼

Are spatial indexes created? ▼

What projection is the data in? ▼

Formatos relacionados

Frequentemente exportados em conjunto

DuckDB+💻GeoJSON 🌎Shapefile 🌍KML

format

DuckDB Spatial — Embedded Analytical Database from CWI Amsterdam for GIS

DuckDB is an in-process OLAP database ("SQLite for analytics") from CWI Amsterdam (Mark Raasveldt, Hannes Mühleisen, MIT