Map of Blantyre 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
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.
درباره PostGIS SQL
Map of Blantyre 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)
| دستهبندی | GIS |
| پسوند فایل | .sql |
| سطح | Free |
What's in the PostGIS SQL map of Blantyre
246,230 buildings (2,913 residential, 103 commercial, 116 industrial, 20 religious), 4,853.5 km of roads, 495 points of interest, 15 landmarks.
Mostly residential streets 2,752.8 km, unclassified roads 1,369.5 km, tertiary roads 304.3 km.
25% of the area is green space.
Among the objects: waste disposal — 85, schools — 75, fuel stations — 39.
Main streets: Chigwaya Road T409, Midima Road, Michiru Road, Kapeni Road, Nkolokoti Road
Landmarks: Mandala House, Malawi Stock Exchange, Museum of Malawi, mizenje, Crafters market
How to use PostGIS SQL for Blantyre
- Select the Blantyre 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
