Map of Moscow 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

Area2 563 km²
Buildings222 650
Roads24 654 km
Points of interest151 090

What this map contains by default

This is how the map is built as-is — every setting can be changed in the constructor.

FormatPostGIS SQL .sql
LayersRoads, Buildings, Water, Greenery, Points of interest change
Stylestandard change
Detailauto change
House numbersnot visible at this scale change
Points of interestmajor objects only change
Coordinate systemWGS 84 (auto) change
Sheet sizeauto change
Relief & gridoff change

About PostGIS SQL

Map of Moscow 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:

Coordinate systems

WGS 84 (EPSG:4326), selectable in the wizard

Compatibility

PostgreSQL/PostGISpsqlpgAdminDBeaverDataGrip

Units

Meters (projected in the chosen coordinate system)

CategoryGIS
File extension.sql
TierFree

What's in the PostGIS SQL map of Moscow

222,650 buildings (63,897 residential, 12,575 commercial, 8,202 industrial, 645 religious), 24,653.7 km of roads, 151,090 points of interest, 50 landmarks.

The area covers 2,563 km², with about 87 buildings per km².

Mostly service roads 14,719.1 km, residential streets 2,942.8 km, tertiary roads 1,785.1 km.

23.8% of the area is green space.

The map marks 543 parks and 810 water bodies.

Key amenities: kindergartens — 2,886, pharmacies — 4,668, supermarkets — 3,668.

Public transport: 12,276 bus stops, 1,913 tram stops, 271 metro stations, 186 rail stations.

Main streets: Варшавское шоссе, Северо-Восточная хорда, Третье транспортное кольцо, Юго-Восточная хорда, Боровское шоссе

Landmarks: Центральный пограничный музей ФСБ России, Музейный комплекс "Бункер Сталина", Музей искусства народов Востока, Русские валенки, Музей шоколада

How to use PostGIS SQL for Moscow

  1. Select the Moscow map area on the main page
  2. Choose PostGIS SQL format and configure export settings
  3. Click Export and wait for processing
  4. Download the file and use in your application

Programs that open PostGIS SQL

PostgreSQL/PostGISpsqlpgAdminDBeaverDataGrip

Other formats for Moscow

All 128 formats for Moscow →

PostGIS SQL for nearby places

All formats for Moscow