Download Lerdo 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.
.sqliteAbout SpatiaLite
Map of Lerdo in SpatiaLite: 872 buildings, 1 767 km of roads, 1 015 points of interest — 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 Lerdo: 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 Lerdo is about 8.8 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 many times SpatiaLite was built in the last 90 days
- Lerdo
- 0
- Durango
- 0
- Whole site
- 7
- Median file size
- 10.6 MB
- Median build time
- 5.2 s
Medians are based on all builds on the site
How to use SpatiaLite for Lerdo
- 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 Lerdo
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.
Other formats for Lerdo
All 128 formats for Lerdo →
SpatiaLite for nearby places
Maps other customers made in this format (SpatiaLite)
Novopokrovka
★★★★★