Spatial Database Optimization for GIS Analysts
Optimize GIS databases for municipal spatial queries and indexing performance
What You Can Do
You can analyze GIS database execution plans to identify performance bottlenecks in spatial queries, implement optimal indexing strategies for geometry columns and topology analysis, and refactor queries to leverage spatial operators efficiently. Claude helps you benchmark improvements on municipal datasets (parcels, utilities, infrastructure), design partitioning schemes for tables with millions of features, and create documentation that justifies infrastructure investments to stakeholders.
Features
identify bottlenecks in spatial operations on 1M+ row tables
GIST, BRIN, and BTREE index recommendations for PostGIS and enterprise geodatabases
rewrite slow intersection, proximity, and network queries for subsecond performance
partitioning and clustering strategies for competing departmental workloads (planning, utilities, transportation)
optimize geocoding, topology validation, and overlap analysis workflows
configure databases for permit tracking and asset management systems requiring <1s responses
before/after metrics and reporting formats for stakeholder communication
transition strategies from file-based GIS (shapefiles, personal geodatabases) to enterprise PostGIS
Example Output
Query Optimization Example:
- Original query: 45 seconds on utility buffer analysis (1.2M line segments)
- Issue identified: Missing spatial index on geometry column, unnecessary table scan
- Optimized query: 2.3 seconds using GIST index + spatial operator precedence
- Recommendation: Add
CREATE INDEX idx_utility_geom ON utilities USING GIST(geom);
Schema Refactoring Example:
- Problem: 6 departments querying shared zoning/parcel tables causing lock contention
- Solution: Table partitioning by administrative district + read-only views per department
- Result: Query times reduced 60%, write operations no longer blocked reads
Batch Processing Example:
- Task: Intersect 500K new development permits with 2M zoning parcels
- Original method: ArcGIS analysis took 8 hours
- Optimized approach: PostGIS ST_Intersects with spatial join on indexed geometry, parallel processing
- Outcome: 12 minutes total runtime with detailed overlap reports
What's Included
- SKILL.md instruction file with systematic optimization methodology:
- Spatial index implementation checklist for PostGIS and enterprise geodatabases:
- Query refactoring template with before/after execution plans:
- Schema partitioning framework for multi-department municipal systems:
- Performance benchmarking worksheet and stakeholder reporting template:
Who It's For
- GIS Analysts managing municipal spatial databases for planning and utilities
- Database administrators supporting geospatial applications in government agencies
- Urban planners implementing enterprise GIS infrastructure
- IT teams migrating legacy file-based GIS to PostGIS systems
- Geospatial data engineers building real-time permit and asset management platforms
Best For
- Diagnosing slow spatial queries on municipal datasets (1M+ features)
- Implementing GIST/BRIN indexes on geometry columns
- Refactoring intersection, proximity, and topology analysis queries
- Designing databases for multi-department shared infrastructure access
- Planning PostGIS or geodatabase migrations from file-based systems
- Optimizing batch geocoding and overlay analysis workflows
- Creating performance improvement documentation for infrastructure budgets
You might also like
You can evaluate competing corridor alignments for new transit lines (BRT, light rail, streetcar), prepare feasibility studies and alternatives analysis documents, assess upgrade or expansion potential for existing corridors, identify transit readiness in growth areas, and quantify equity impacts. This skill structures your analysis to be analytically rigorous, stakeholder-responsive, and aligned with adopted comprehensive plans and transit master plans.
by tchr-dev
You can identify slow spatial queries, analyze PostGIS execution plans, design optimal spatial indexes (GIST, BRIN, SP-GIST), and restructure database schemas for efficient land use analysis, zoning verification, and infrastructure mapping. This skill helps you troubleshoot why intersection queries timeout, optimize buffer operations on large feature classes, and accelerate web mapping service delivery without requiring application code changes.
You can systematically evaluate existing and planned active transportation networks using structured assessment frameworks. This skill helps you identify missing links, connectivity gaps, and equity disparities in walking and cycling infrastructure—then translate those findings into compelling, data-driven recommendations that justify funding requests and guide master planning priorities.
by tchr-dev
You can conduct comprehensive multimodal corridor evaluations that integrate travel demand, infrastructure capacity, land use context, and equity considerations into a single analysis. This framework helps you identify trade-offs between competing planning objectives, synthesize disparate data sources into coherent recommendations, and produce documentation that withstands scrutiny from planning commissions, city councils, and state/federal reviewers. You'll generate defensible long-range plan recommendations grounded in systematic evaluation rather than political preference.
by tchr-dev