PostGIS SQL 💾

PostGIS SQL Dump

Price before payment
.sql · application/sql

PostGIS SQL is a text SQL script that creates a table with a geometry column and fills it with data, ready to load into any PostgreSQL database with the PostGIS extension. It is a convenient way to hand an OSM selection to a team already on the PostgreSQL stack: apply the script and you immediately have a geometry table for queries through ST_* functions. Our exporter generates a self-contained .sql: CREATE TABLE with a geom column and attributes, then one INSERT per feature where geometry is given via ST_GeomFromText(WKT, SRID) (SRID 4326 by default). Multiple layers become separate tables, and values are escaped (SQL-injection safe). Honestly: this is a simple human-readable dump via ST_GeomFromText, not a binary pg_dump archive and not the full osm2pgsql schema with planet_osm tables and spatial indexes.

OpenStreetMap data as of 26 October 2026 · 26 days ago

PostGIS SQL қазір экспорттау ✨ Ашық бета — тегін, шектеусіз

Негізгі мүмкіндіктер

✓Self-contained .sql: CREATE TABLE + INSERT, applied via psql -f
✓Geometry via ST_GeomFromText(WKT, SRID), SRID 4326 by default
✓Attribute types mapped to PostgreSQL types (TEXT, DOUBLE PRECISION, INTEGER)
✓Multiple layers — separate tables in one script
✓Values are escaped — SQL-injection safe

PostGIS SQL форматы туралы

PostGIS SQL is not a binary dump but an ordinary text script: create a table with a geometry column and fill it with rows. It can be read by eye, put into version control and applied with a single psql command on any PostgreSQL database with the PostGIS extension.

The format is convenient when data is handed to a team already living on PostgreSQL: analytics, backend, portal developers. Apply the script — and you immediately have a table that ST functions work on: intersections, buffers, distances, aggregates over the area.

The script is self-contained: it enables the PostGIS extension if it is not there yet, creates a table for each layer with a geom column and attributes, inserts objects through ST_GeomFromText with the coordinate system specified (EPSG:4326 by default) and at the end creates a GiST spatial index on geom. Values are escaped and field types are mapped onto PostgreSQL types.

Two details it is better to know in advance. Before creating a table the script runs DROP TABLE IF EXISTS with a cascade — if the schema already contains a table with the same name, it will be deleted along with the dependent objects, so apply the script into a separate schema or check the names. And the volume: up to 500,000 objects are carried over per table, beyond that the export is truncated — for large territories take GeoPackage or FlatGeobuf and load them through ogr2ogr.

PostGIS SQL файлдарын қандай бағдарлама ашады

Келесі бағдарламалар мен қосымшалар OSM2CDR-дан экспортталған PostGIS SQL Dump (.sql) файлдарын ашып, өңдеп, олармен жұмыс істей алады:

💻PostgreSQL + PostGIS 💻psql 🌎QGIS 💻GeoServer 💻DBeaver

Format specifications

PostGIS SQL карталарын кім пайдаланады

🏗
Loading an OSM selection into your PostgreSQL/PostGIS database with one script
The selection is deployed into your database with one command — and the data is ready for ST queries right away.
💻
Handing data to a GIS team already on the PostgreSQL stack
A convenient way to hand data to a team already working on PostgreSQL: the script is readable by eye and stored in a repository.
📊
Preparing a layer for GeoServer or QGIS via a PostGIS connection
A layer for publishing in GeoServer or connecting to QGIS through the database, with no file exchange.
🎨
Embedding geodata into a SQL pipeline or CI/CD through psql -f
A pipeline or build step: the script is applied automatically through psql -f along with the rest of the migrations.

PostGIS SQL форматын қалай экспорттауға болады

1
Аумақты таңдаңыз
osm2cdr.com сайтындағы интерактивті картада тіктөртбұрыш немесе көпбұрыш салыңыз
2
PostGIS SQL таңдаңыз
127 қолжетімді экспорт форматының тізімінен PostGIS SQL Dump таңдаңыз
3
Экспорт
Экспорт түймесін басып, .sql файлыңызды 1–5 минутта алыңыз
4
Жүктеп алу
Дайын PostGIS SQL файлын жүктеп алып, оны PostgreSQL + PostGIS бағдарламасында ашыңыз

Экспорттан кейін қалай ашу керек

Тегін

PostGIS SQL Dump карта экспорттарын алыңыз

OpenStreetMap-тан кәсіби PostGIS SQL карталарын жүктеп алыңыз. Лезде жасалады, кез келген аумақ.

Тегін / экспорт
PostGIS SQL қазір экспорттау →

Жиі қойылатын сұрақтар

Is this a pg_dump dump? ▼
Will this be the osm2pgsql schema with planet_osm tables? ▼
How do I apply the script? ▼
Which coordinate system is the geometry in? ▼
Are indexes created? ▼
Will the script delete my existing tables? ▼

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

All reviews

Қатысты форматтар

Жиі бірге экспортталады

Related Articles