Map of Saint Mark in PostGIS SQL format

A map built from OpenStreetMap data, ready to download

Map of Saint Mark in PostGIS SQL format

Map passport

Area23 km²
Buildings1 997
Roads34 km
Points of interest27

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, Greenery, Points of interest change
Stylestandard change
Detailauto change
House numbersall change
Points of interestall categories change
Coordinate systemWGS 84 (auto) change
Sheet sizeauto change
Relief & gridoff change

About PostGIS SQL

Map of Saint Mark 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 Saint Mark

1,997 buildings (37 residential), 34.4 km of roads, 27 points of interest, 5 landmarks.

Mostly residential streets 19.6 km, primary roads 11.8 km, service roads 1.6 km.

100% of the area is green space.

Among the objects: schools — 3, places of worship — 3, bars — 2.

Main streets: Western Road, Fountain Road, Diego Piece Road, Bonair Road, Resource Road

Landmarks: The Duquesne Petroglyphs, Amerindian Petroglyphs, Victoria Seventh-Day Adventist Church, St Mark's Catholic Church, St. Mark's Anglican Church

How to use PostGIS SQL for Saint Mark

  1. Select the Saint Mark 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

Interactive map of the area

Other formats for Saint Mark

All 126 formats for Saint Mark →

PostGIS SQL for nearby places

All formats for Saint Mark