Map of Nigeria in PostGIS SQL format

Download Nigeria map in PostGIS SQL format. OpenStreetMap data, instant generation.

Map generation
Map of Nigeria in PostGIS SQL format

Map passport

Area927 826 km²
Buildings2 399 788
Roads769 794 km
Points of interest40 232
ProjectionWGS-84 (EPSG:4326)
LicenseODbL
Data sourceOpenStreetMap

About PostGIS SQL

PostGIS SQL is a geodata dump as an SQL script for PostgreSQL/PostGIS. CREATE TABLE + INSERT with geometry for direct database import.

Use cases

CategoryGIS
File extension.sql
TierFree

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.

Mostly unclassified roads 400,629.6 km, residential streets 236,206.8 km, tertiary roads 57,587.4 km.

Among the objects: place_of_worship — 6,675, hospital — 4,266, schools — 3,486.

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

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

All formats for Nigeria