Map of Minyip 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.
.sqliteAbout SpatiaLite
Map of Minyip in SpatiaLite: 321 buildings, 44 km of roads, 26 points of interest, 72% 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
- Buildings
- Water
- Greenery
- Points of interest
Geometry by layer
- Roads — lines (LineString) with OpenStreetMap tags
- Buildings — polygons (Polygon) with OpenStreetMap tags
- Water — waterbody polygons and watercourse lines with tags
- Greenery — green-zone polygons with tags
- Points of interest — points (Point) with names and tags
What the file carries
The SpatiaLite file for Minyip: 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 Minyip is about 810 KB; 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 Minyip
- 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 Minyip
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.
