Map of Nigeria 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.
About PostGIS SQL
Map of Nigeria 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 Nigeria
2,399,788 buildings (54,888 residential, 2,721 commercial, 1,073 industrial, 322 religious), 769,793.6 km of roads, 40,232 points of interest, 200 landmarks.
The area covers 927,826 km², with about 3 buildings per km².
Mostly unclassified roads 400,629.6 km, residential streets 236,206.8 km, tertiary roads 57,587.4 km.
The map marks 229 parks and 1,009 water bodies.
Key amenities: schools — 3,486, hospitals — 4,266, pharmacies — 1,468.
Public transport: 413 bus stops, 65 tram stops, 5 metro stations, 167 rail stations.
Main streets: Federal Road F215 Owo - Tegina, Gombi - Baromari Road, Takum - Bukuru Federal Road, Wudil - Potiskum Federal Road, Gudau - Sabon Birni Road
Landmarks: Slave History Museum, Igbo-Ukwu Museum, Lasu Museum, National Museum, Lokoja National Museum
How to use PostGIS SQL for Nigeria
- Select the Nigeria 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
