Importing INE Shapefiles into a Spatialite Database
In this post, we’ll walk through the process of importing Mexico’s National Electoral Institute (INE) shapefiles into a Spatialite database. We’ll be using macOS and QGIS for this tutorial. Setting Up Spatialite First, let’s install Spatialite using Homebrew: brew install spatialite-tools Once installed, create a new Spatialite database by running: spatialite ine.db You should see output indicating the Spatialite version and supported extensions. SpatiaLite version ..: 5.1.0 Supported Extensions: - 'VirtualShape' [direct Shapefile access] - 'VirtualDbf' [direct DBF access] - 'VirtualText' [direct CSV/TXT access] - 'VirtualGeoJSON' [direct GeoJSON access] - 'VirtualXL' [direct XLS access] - 'VirtualNetwork' [Dijkstra shortest path - obsolete] - 'RTree' [Spatial Index - R*Tree] - 'MbrCache' [Spatial Index - MBR cache] - 'VirtualFDO' [FDO-OGR interoperability] - 'VirtualBBox' [BoundingBox tables] - 'VirtualSpatialIndex' [R*Tree metahandler] - 'VirtualElementary' [ElemGeoms metahandler] - 'VirtualRouting' [Dijkstra shortest path - advanced] - 'VirtualKNN2' [K-Nearest Neighbors metahandler] - 'VirtualGPKG' [OGC GeoPackage interoperability] - 'VirtualXPath' [XML Path Language - XPath] - 'SpatiaLite' [Spatial SQL - OGC] PROJ version ........: Rel. 9.4.0, March 1st, 2024 GEOS version ........: 3.12.1-CAPI-1.18.1 RTTOPO version ......: 1.1.0 TARGET CPU ..........: x86_64-apple-darwin23.0.0 the SPATIAL_REF_SYS table already contains some row(s) SQLite version ......: 3.45.3 Enter ".help" for instructions SQLite version 3.45.3 2024-04-15 13:34:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" Downloading INE Shapefiles Visit the INE transparency portal: https://pautas.ine.mx/transparencia/mapas/ ...