Development & ETL
Development and automation:
- Structure Inspection Data Pipeline
Professional work. Automating flight-track processing and structure inspection data updates in enterprise GIS.
- SQL Server to ArcGIS Online
Professional work · Modernized GIS tool. Prepare SQL spatial data for new private ArcGIS Online snapshots, with reviewable contracts, desktop publishing tools, and a separate ArcGIS Server path.
- Work Order Mapping and GIS Integration
Geospatial data engineering · Work-order reporting. Reconcile Cityworks work orders with point and line GIS assets, then present maintenance activity through shared SQL reporting data and ArcGIS Pro layers.
- Python Scripts & Notebooks
Professional work. Automating repetitive GIS tasks with Python, FME, and SQL.
- Impervious Surface Update & Recovery
Geospatial data engineering · Update and recovery workflow. A Python and ArcGIS workflow for updating enterprise and hosted impervious-surface datasets, with verified backups, staged validation, controlled updates, and recovery reporting.
- SQL Server and GIS Data Integration
Geospatial data engineering · Reconstructed workflows. Synthetic reconstruction of SQL data-preparation workflows for address and parcel matching, spatial document indexing, and controlled reporting refreshes.
- Road Network Building with PostGIS and pgRouting
Geospatial data engineering · Routing prototype. A PostGIS and pgRouting prototype that builds a directed road graph and tests shortest paths and time-budget reachability using synthetic data.
- Automated Parcel Integration and Publishing
Professional work. Two county data sources, recurring spatial checks, and a shared municipal GIS publishing workflow.
- Web AppBuilder Migration Assistant
Independent prototype. A Python prototype that prepares reviewable ArcGIS Experience Builder candidates from Web AppBuilder and classic Story Map Series applications.