DuckDB 🪵

DuckDB Spatial Database

Price before payment
.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.

OpenStreetMap data as of 26 October 2026 · 25 days ago

এখনই DuckDB এক্সপোর্ট করুন ✨ ওপেন বেটা — বিনামূল্যে, কোনো সীমা নেই

মূল বৈশিষ্ট্য

✓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

DuckDB ফরম্যাট সম্পর্কে

DuckDB is an analytical database that lives in a single file and needs no server. It is often called the SQLite of analytics: columnar storage and a vectorized engine give fast aggregations and joins over millions of rows right on a laptop, while the spatial extension adds the familiar ST_ functions.

A map is exported to DuckDB when you need SQL but do not want to raise PostgreSQL with PostGIS: a one-off analysis in a notebook, an ETL script, a model in dbt, a prototype query before moving it into a big warehouse. The file can simply be handed to a colleague — they will open it with a single command.

The output is a single .duckdb file, where every map layer has become a separate table and OSM attributes have become columns; the export parameters lie in the service table _metadata. The geometry is written as WKT text into the geom_wkt column: that way the file reads even without the spatial extension, and real geometry is obtained by calling ST_GeomFromText after LOAD spatial. The coordinates are WGS84; spatial indexes are not created, that decision is left to you.

কোন প্রোগ্রাম DuckDB ফাইল খোলে

নিম্নলিখিত প্রোগ্রাম ও অ্যাপ্লিকেশনগুলি OSM2CDR থেকে এক্সপোর্ট করা DuckDB Spatial Database (.duckdb) ফাইল খুলতে, সম্পাদনা করতে ও এর সাথে কাজ করতে পারে:

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

Format specifications

কারা DuckDB মানচিত্র ব্যবহার করেন

🏗
Ad-hoc spatial analytics in Jupyter without spinning up a PostgreSQL/PostGIS server
A one-off spatial analysis in a notebook — without installing and configuring a database server.
💻
ETL pipelines: read, join and aggregate OSM data in plain SQL with zero infrastructure
Reading, joining and aggregating OSM data with a single SQL statement inside an ETL script.
📊
dbt models and notebook-driven workflows where `.duckdb` is a portable team artifact
A portable artifact for the team: the file goes into the repository and opens the same way for everyone.
🎨
Prototyping queries before migrating to Snowflake/BigQuery
A rough run-in of queries before moving the logic into a big cloud warehouse.

কীভাবে DuckDB এক্সপোর্ট করবেন

1
এলাকা নির্বাচন করুন
osm2cdr.com-এর ইন্টারঅ্যাক্টিভ মানচিত্রে একটি আয়তক্ষেত্র বা বহুভুজ আঁকুন
2
DuckDB বেছে নিন
১২৭টি উপলব্ধ এক্সপোর্ট ফরম্যাটের তালিকা থেকে DuckDB Spatial Database নির্বাচন করুন
3
এক্সপোর্ট
এক্সপোর্টে ক্লিক করুন এবং ১-৫ মিনিটের মধ্যে আপনার .duckdb ফাইল পান
4
ডাউনলোড
প্রস্তুত DuckDB ফাইল ডাউনলোড করুন এবং DuckDB CLI-এ এটি খুলুন

এক্সপোর্টের পর কীভাবে খুলবেন

ফ্রি

DuckDB Spatial Database মানচিত্র এক্সপোর্ট পান

OpenStreetMap থেকে পেশাদার মানের DuckDB মানচিত্র ডাউনলোড করুন। যেকোনো এলাকার জন্য তাৎক্ষণিক প্রস্তুতি।

বিনামূল্যে / এক্সপোর্ট
এখনই DuckDB এক্সপোর্ট করুন →

প্রায়শই জিজ্ঞাসিত প্রশ্ন

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? ▼
What tables are inside the file? ▼
How do I turn the export into GeoParquet or GeoJSON? ▼
Do I have to install anything to open the file? ▼

What people who already downloaded say

Finally, maps can be downloaded as vectors. Thanks to the author!
Ilyas, September 2026

Map: Ufa, AI

everything is really cool, I didn't expect I'd just come and download a piece of the map! thanks!!!
Sergey, September 2026

Map: Nizhny Novgorod, PMTiles

HUGE THANKS!!! A VERY GOOD PROGRAM!!! I was looking for a vector map where 3 countries meet - it helped a lot!!
Andrey, September 2026

Map: Kazakhstan and Altai, PDF

Well done! You've done a big and much-needed job!
Artem, September 2026

Map: Roshchino, Leningrad Region, GeoTIFF

Ivan, thank you so much! Not just a man - a Great Man!
Konstantin, September 2026

Map: Saratov Region, GeoJSON

ivan, you're simply a wonder. Thank you for an incredibly cool service
Architecture student, September 2026

Map: Bogashevo near Tomsk, DXF

সব রিভিউ

সম্পর্কিত ফরম্যাট

প্রায়ই একসাথে এক্সপোর্ট করা হয়

Related Articles