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

Area35 km²
Buildings2 250
Roads234 km
Points of interest120

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 numbersall change
Points of interestall but cafés, shops and services — the editor adds those change
Coordinate systemWGS 84 (auto) change
Sheet sizeauto change
Relief & gridoff change

About PostGIS SQL

Map of Mapleton 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
TierOpen Beta

What's in the PostGIS SQL map of Mapleton

2,250 buildings (337 residential, 2 industrial, 3 religious), 233.5 km of roads, 120 points of interest, 8 landmarks.

The area covers 35 km², with about 65 buildings per km².

Mostly residential streets 121.4 km, service roads 53.7 km, tertiary roads 22.5 km.

The map marks 8 parks and 6 water bodies.

Key amenities: schools — 6, dentists — 1, museums — 1.

Main streets: 1600 West, State Road, 1600 North, Main Street, 1200 North

Landmarks: Mapleton Heritage Museum, Mapleton Junior High Seminary, The Church of Jesus Christ of Latter-day Saints, The Church of Jesus Christ of Latter-day Saints, The Church of Jesus Christ of Latter-day Saints

How to use PostGIS SQL for Mapleton

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

All 128 formats for Mapleton →

PostGIS SQL for nearby places

All formats for Mapleton