Map of Prague in PostGIS SQL format
A map built from OpenStreetMap data, ready to download
Customize the map
Open this place's area in the constructor and adjust everything to your needs
Open in constructor →Map passport
What this map contains by default
This is how the map is built as-is — every setting can be changed in the constructor.
.sql
About PostGIS SQL
Map of Prague in PostGIS SQL — an export of real OpenStreetMap data for the selected area.
PostGIS SQL is a geodata dump as an SQL script for PostgreSQL/PostGIS. CREATE TABLE + INSERT with geometry for direct database import.
Which layers are in the file
This file for the selected area contains:
- Roads
- Buildings
- Water
- Greenery
- Points of interest
Coordinate systems
WGS 84 (EPSG:4326), selectable in the wizard
Compatibility
Units
Meters (projected in the chosen coordinate system)
| Category | GIS |
| File extension | .sql |
| Tier | Open Beta |
What's in the PostGIS SQL map of Prague
174,054 buildings (100,530 residential, 2,050 commercial, 4,075 industrial, 230 religious), 5,689.7 km of roads, 45,860 points of interest, 15 landmarks.
The area covers 496 km², with about 351 buildings per km².
Mostly residential streets 1,955.2 km, service roads 1,727.9 km, tertiary roads 524.6 km.
24.3% of the area is green space.
The map marks 5 parks and 10 water bodies.
Key amenities: convenience stores — 853, restaurants — 2,471, cafes — 1,026.
Public transport: 2,929 bus stops, 849 tram stops, 355 metro stations, 108 rail stations.
Main streets: Evropská, Jeremiášova, Českobrodská, K Barrandovu, Strakonická
Landmarks: Lumia Gallery, Poštovní muzeum, Film Legends Museum, Síň slávy českého hokeje, Geosvět
How to use PostGIS SQL for Prague
- Select the Prague map area on the main page
- Choose PostGIS SQL format and configure export settings
- Click Export and wait for processing
- Download the file and use in your application
