Map of Ghana 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 Ghana 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 | Free |
What's in the PostGIS SQL map of Ghana
497,619 buildings (11,802 residential, 974 commercial, 566 industrial, 966 religious), 136,456.2 km of roads, 31,103 points of interest, 100 landmarks.
The area covers 251,064 km², with about 2 buildings per km².
Mostly residential streets 54,622.4 km, unclassified roads 49,032.6 km, tertiary roads 13,964.5 km.
The map marks 92 parks and 329 water bodies.
Key amenities: schools — 4,444, pharmacies — 1,169, convenience stores — 1,259.
Public transport: 3,862 bus stops, 20 tram stops, 46 rail stations.
Main streets: Enchi - Tarkwa, Sampa - Wenchi, Daboase - Twifo Praso, International Road, Bibiani - Nyinahin - Kumasi Road
Landmarks: Despite Automobile Museum, W.E.B Du Bois Center, Museum of Archaelogy, Ghana Armed Forces Museum, Opoku Ware II Museum
How to use PostGIS SQL for Ghana
- Select the Ghana 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
