Map of Kano State 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 Kano State 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 Kano State
409,314 buildings (3,781 residential, 102 commercial, 149 industrial, 31 religious), 36,014.0 km of roads, 2,037 points of interest, 15 landmarks.
The area covers 20,354 km², with about 20 buildings per km².
Mostly unclassified roads 15,612.8 km, residential streets 13,304.4 km, tertiary roads 3,798.5 km.
The map marks 5 parks and 7 water bodies.
Key amenities: schools — 274, hospitals — 145, pharmacies — 78.
Public transport: 2 bus stops, 3 rail stations.
Main streets: Rahama to Kafin Mayaki Road, Kano-Gumel Road, Kunya to Niger Border Road, Rano - Sumaila road, Wudil - Potiskum Federal Road
Landmarks: National Museum Gidan Makama Kano, Kano Emir's Palace, Kano Emir's Palace Main Gate (Kofar Kudu), Kano Emir's Palace, Kano Emir's Palace
How to use PostGIS SQL for Kano State
- Select the Kano State 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
