Download Bauchi State map in SpatiaLite 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 SpatiaLite
Map of Bauchi State in SpatiaLite: 40 488 km of roads, 11% green areas — in the WGS 84 coordinate system, units are meters.
Which layers are in the file
This file for the selected area contains:
- Roads
- Water
- Greenery
Geometry by layer
- Roads — lines (LineString) with OpenStreetMap tags
- Water — waterbody polygons and watercourse lines with tags
- Greenery — green-zone polygons with tags
What the file carries
The SpatiaLite file for Bauchi State: the whole map comes as a single file, the file is binary — it is opened by a program, not by an editor, layers live inside the file as named entities, OpenStreetMap tags are kept as feature attributes.
File size
The expected size of the SpatiaLite file for Bauchi State is about 13.9 MB; the exact size depends on the chosen layers and area.
Coordinate systems
WGS 84 (EPSG:4326), selectable in the wizard
Units
Meters (projected in the chosen coordinate system)
| Category | GIS |
| File extension | .sqlite |
| Tier | Open Beta |
How to use SpatiaLite for Bauchi State
- QGIS — drag the file into the program window or add it through the Data Source Manager; the tables will appear as ordinary layers.
- DB Browser for SQLite — look through the tables and run a query; for spatial functions load the mod_spatialite module.
- spatialite-gui and the console spatialite — the project's own tools: queries with spatial functions work out of the box.
Programs that open SpatiaLite
FAQ: SpatiaLite for Bauchi State
How is SpatiaLite different from GeoPackage?
SpatiaLite is a full spatial database with SQL queries. GeoPackage is a simplified container for data exchange.
Can I open SpatiaLite in QGIS?
Yes, QGIS works great with SpatiaLite -- just drag and drop the file.
Which tables will be in the database?
One per exported layer: roads, buildings, water, green zones and the rest that were present in your area. Each table has a geometry column and the OpenStreetMap attributes.
Which coordinate system is the geometry stored in?
WGS84 (EPSG:4326) — latitude and longitude. To compute lengths and areas in meters, either reproject the geometry right in the query or use the geodesic functions of SpatiaLite.
Do I need to install anything to open the file?
For QGIS — nothing, support is built in. For queries in third-party tools you need the mod_spatialite module: on Linux it is installed as a package, on Windows it is placed next to the program.
