DuckDB Spatial Database
Open BetaDuckDB 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.
ಪ್ರಮುಖ ವೈಶಿಷ್ಟ್ಯಗಳು
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) ಫೈಲ್ಗಳನ್ನು ಈ ಕೆಳಗಿನ ಪ್ರೋಗ್ರಾಮ್ಗಳು ಮತ್ತು ಅಪ್ಲಿಕೇಶನ್ಗಳು ತೆರೆಯಬಹುದು, ಸಂಪಾದಿಸಬಹುದು ಮತ್ತು ಬಳಸಬಹುದು:
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.
DuckDB ನಕ್ಷೆಗಳನ್ನು ಯಾರು ಬಳಸುತ್ತಾರೆ
DuckDB ಅನ್ನು ಹೇಗೆ ಎಕ್ಸ್ಪೋರ್ಟ್ ಮಾಡುವುದು
ರಫ್ತಿನ ನಂತರ ಹೇಗೆ ತೆರೆಯುವುದು
- DuckDB CLI — run duckdb map.duckdb and look around: SHOW TABLES lists the layers, DESCRIBE lists the columns of a particular table.
- Python — import duckdb, then con.execute("INSTALL spatial; LOAD spatial;") and ordinary queries; the result comes straight into pandas.
- Geometry — wrap the column in ST_GeomFromText(geom_wkt), otherwise it stays text: spatial functions do not work with text.
- Exporting further — COPY (SELECT ...) TO 'out.parquet' or 'out.geojson' converts a selection into another format right from SQL, with no intermediate tools.
- DBeaver — connects to the file as to an ordinary database, if you find a graphical client more convenient.
DuckDB ನಲ್ಲಿ ಜನಪ್ರಿಯ ನಕ್ಷೆಗಳು
DuckDB Spatial Database ನಕ್ಷೆ ಎಕ್ಸ್ಪೋರ್ಟ್ಗಳನ್ನು ಪಡೆಯಿರಿ
OpenStreetMap ನಿಂದ ವೃತ್ತಿಪರ DuckDB ನಕ್ಷೆಗಳನ್ನು ಡೌನ್ಲೋಡ್ ಮಾಡಿ. ತಕ್ಷಣದ ರಚನೆ, ಯಾವುದೇ ಪ್ರದೇಶ.
ಪದೇ ಪದೇ ಕೇಳಲಾಗುವ ಪ್ರಶ್ನೆಗಳು
What people who already downloaded say
Reviews are quoted in the language their authors wrote them in.
Наконец-то карты можно скачать в векторе. Автору спасибо!
всё очень круто, не ожидал что просто приду и скачаю кусочек карты! спасибо!!!
ОГРОМНОЕ СПАСИБО!!! ОЧЕНЬ ХОРОШАЯ ПРОГРАММА!!! Искал карту в векторе на стыке 3 стран - очень помогло!!
Ты - молодец! Сделал большое и нужное дело!
Иван, спасибо огромное! Не просто человек - Человечище!
иван, вы просто чудо. Спасибо за неимоверно крутой сервис
Относительно быстро и качественно собирает карты, самое приятно что бесплатно. удобно выбирать области