Mexico

Transparency Law Consulting Navigate Mexico’s transparency landscape with expert guidance under the Ley General de Transparencia and proven strategies. 🏛️ What I Offer Access to Information Strategy Request Drafting: Craft precise, effective access to information requests Legal Analysis: Navigate LGT, LFTAIP, and local transparency laws Recurso de Revisión: Handle denials and administrative appeals Timeline Management: Optimize request timing and follow-up within legal deadlines Data Analysis & Visualization Public Data Mining: Extract insights from government databases Statistical Analysis: Identify patterns and anomalies in public spending Interactive Dashboards: Create compelling visualizations Report Generation: Professional analysis reports Government Accountability Research Contract Analysis: Examine public procurement processes Budget Transparency: Analyze government spending patterns Compliance Monitoring: Track transparency law adherence Comparative Studies: Benchmark across different entities Training & Workshops Access Training: Educate teams on effective information request strategies Legal Workshops: Understanding your rights under Mexican transparency law Data Literacy: How to interpret government data and public accounts Advocacy Strategy: Building effective transparency campaigns within legal framework 📈 My Track Record Successful Cases 108 Million Investigation - Exposed communication spending in Sonora ...

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/ ...