GIS + Automation Projects

Municipal GIS Partners

Emergency Vehicle Preemption Dashboard

Designed and delivered a real-time ArcGIS Online dashboard and Experience that consolidates preemption device status, location, and component health into a single, operational view—giving teams the clarity to monitor system readiness, coordinate faster, and act before issues become incidents.

ArcGIS Online Dashboard Real-time

Result: A "single pane of glass" for situational awareness and proactive maintenance, improving response efficiency without adding headcount.

Municipal GIS Partners

Sustainability StoryMap (ArcGIS Online)

Translated sustainability metrics into a narrative StoryMap with interactive charts and maps for Northbrook—turning siloed datasets into a clear, public-facing experience that's easy to maintain and effortless to understand.

ArcGIS StoryMaps Data Visualization Public Engagement

Result: Stronger transparency and community engagement, with a flexible framework the organization can update as programs evolve.

Municipal GIS Partners

Water Service Card Modernization (100-Year Legacy → Digital + AI-Ready)

Replaced a century-old, image-based workflow with a structured Survey123 data model and automated record linking—creating a searchable system of record and a migration path to analytics. I'm also exploring a locally run LLM to digitize historical cards securely and at scale.

Survey123 AI/LLM Data Migration

Result: Faster field operations, discoverable records, and an innovation pathway that modernizes an outdated process without sacrificing governance.

Municipal GIS Partners

Pond Ownership Inventory Dashboard

Automated the discovery of every pond inside municipal boundaries with Google Earth Engine, refined the dataset in ArcGIS Pro, and deployed an ArcGIS Experience Builder workspace so staff could co-manage ownership verification without leaving the browser.

Google Earth Engine ArcGIS Pro Experience Builder

Result: A trusted ownership inventory enriched with flood-risk zones and surface area metrics, giving teams clarity, faster decisions, and higher-quality collaboration.

Municipal GIS Partners

Supply Inventory Tracking System

Designed a supply inventory tracking system for the Village of Northbrook that allows staff to log supply usage through a simple QR-based form. Built an automated ArcGIS Online notebook to process submissions, update inventory levels, and maintain a detailed audit trail, creating transparency, accountability, and real-time visibility into supply trends.

QR Codes ArcGIS Notebooks Automation

Result: A streamlined, self-maintaining workflow that replaces manual tracking with automated, data-driven reporting, empowering operations and finance staff to make quicker, more confident decisions about restocking and budgeting.

Municipal GIS Partners

Fiber Line Linking & Depth/DFP Pilot

Standardized drawing sets and linked each fiber segment in GIS to its authoritative PDF source, then piloted depth and distance-from-pavement values at ~20-foot intervals in ArcGIS Online—bringing field crews precise, click-through access to the data they need.

Utilities PDF Linking Field Operations

Result: Safer excavations, faster lookups, and a scalable blueprint for integrating engineering records with operational GIS.

Automation

Automation — Utility Atlas Requests (Python + Power Automate)

Built a Python/ArcPy exporter and an email-driven Power Automate flow to geocode addresses, toggle the right layers, and generate Water/Storm/Sanitary PDFs—cutting manual requests from minutes to near hands-off execution with consistent outputs and file naming.

Python ArcPy Power Automate

Result: Significant time savings during high-volume periods and better service consistency with automated auditability.

Automation

Automation — Zoning Variance Updates (Survey123 → SDE)

Engineered a Survey123 → Power Automate (cloud & desktop) → ArcPy pipeline that geocodes, parcel-matches, inserts into SDE, deduplicates, and logs each transaction—turning a manual back-office task into a near real-time, reliable update.

Survey123 Power Automate ArcPy

Result: Less manual entry, quicker decisions, and cleaner parcel linkage across the enterprise GIS.

Municipal GIS Partners

Water Service Card Reviewer

Deployed Qwen2.5-VL to read 100-year-old water service cards full of cursive annotations, smudges, and typewriter ink. A Python pipeline normalizes the model output, enforces the utility schema, and bulk-loads validated attributes into enterprise GIS feature classes—bringing field histories into a searchable system without manual transcription.

Qwen2.5-VL Vision-Language AI Python GIS Automation

Result: Achieved >95% model accuracy on damaged handwriting, eliminating days of re-keying per batch while keeping analysts in the validation loop.

Municipal GIS Partners

Computer Vision Spatial Data Pipeline (SAM3 + ZED 2i) - In Progress

Developing and validating a vision-first workflow that turns real-world imagery into GIS-ready spatial data. SAM3 segmentation extracts precise outlines and relationships, while ZED 2i stereo depth captures metric measurements and 3D point clouds for spatially anchored assets.

SAM3 ZED 2i Segmentation 3D Point Clouds GIS Accuracy

Result: A validated pipeline that treats vision models as data generators, producing measurable polygons and depth-aware features aligned to municipal workflows.

Municipal GIS Partners

ATLAS ArcGIS Online MCP - In Progress

Developing an MCP server for agentic interactions that reimagines ArcGIS Online workflows, enabling AI agents to execute GIS operations, orchestrate tasks, and automate spatial analysis with structured, auditable actions.

MCP Server Agentic AI ArcGIS Online GIS Automation

Result: A foundation for agent-driven GIS workflows that reduces manual steps while keeping governance and reproducibility front and center.

Municipal GIS Partners

USPS Address Validator

Built an internal validation tool that verifies thousands of municipal address records against the official USPS database—identifying correct, partially correct, and invalid entries before system migrations or data cleanup projects. Staff upload spreadsheets, monitor progress through an interactive dashboard with map visualization, and export corrected data to ensure clean records enter their new systems.

USPS API Data Validation System Migration Bulk Processing

Result: Supports large-scale municipal migrations (BS&A to BS&A Cloud) by validating up to 60 addresses per hour, with pause/resume capability for multi-day jobs—ensuring data quality before records move to production systems.

Municipal GIS Partners

Utility Document Extractor (AI-Powered GIS Asset Rule Extraction)

Engineered an AI-powered React platform that transforms decades of unstructured utility as-built drawings and permits into structured GIS asset rules. Vision-capable models (Azure AI Foundry or local Ollama) extract asset types, field names, and default values from scanned PDFs—validated through a human-in-the-loop review interface before exporting to ArcGIS-compatible CSV and engineering documentation.

React 19 TypeScript Azure AI Foundry Ollama Vision Power Apps

Result: Achieved >90% extraction accuracy with dual-deployment flexibility (cloud or air-gapped), reducing manual digitization bottlenecks and unlocking institutional knowledge trapped in legacy documents for modern GIS workflows.

Scouting America

Bivariate Market Share Analysis

This analysis explores the relationship between Cub Scout and Scouts BSA membership density across ZIP codes within the Pathway to Adventure Council. The objective is to evaluate whether areas with higher Cub Scout participation are associated with stronger Scouts BSA membership, providing insight into long-term recruitment trends.

Spatial Analysis Bivariate Mapping Demographics

Result: Strong positive correlation between Cub Scout and Scouts BSA membership levels, suggesting that strengthening Cub Scout programs in underrepresented areas may lead to increased retention and progression into Scouts BSA.

Scouting America

Heat Map of Scouts

This heat map visualizes the density of Scouting members within the Trailblazer District, where I was responsible for membership growth and engagement. It charts unit meeting locations, school locations, and Scout residences, providing a comprehensive view of membership distribution.

Heat Mapping Density Analysis Recruitment

Result: Identified recruitment opportunities and strategically targeted underrepresented areas, ensuring a more balanced and effective outreach effort.

Scouting America

Total Available Youth (TAY) in Trailblazer District

This map visualizes the Total Available Youth (TAY) by zip code within the Trailblazer District, providing a data-driven perspective on recruitment potential. TAY is a key metric used by Scouting America to estimate the total number of Scout-age youth who are eligible to be recruited into the program.

Demographics ZIP Code Analysis Recruitment Planning

Result: Developed targeted recruitment initiatives, strengthened community engagement, and contributed to the long-term growth of Scouting within the district.

Scouting America

Total Cub Scout Market Share

This analysis examines the overall market share of Cub Scouts in relation to the total youth population, providing valuable insight into membership trends and recruitment potential. By comparing Cub Scout participation with broader demographic data, it identifies areas where Scouting is well-established and where there are opportunities for growth.

Market Analysis Demographics Trend Analysis

Result: Refined recruitment strategies by highlighting underserved communities and ensuring outreach efforts are inclusive and effective.

Scouting America

Total Scouts BSA by Population

This analysis compares population density with Scouts BSA membership numbers to identify trends and opportunities for growth. By mapping membership data against demographic distribution, it highlights areas where Scouting is underrepresented and where recruitment efforts should be prioritized.

Population Density Membership Analysis Growth Strategy

Result: High-density areas with low membership indicate opportunities for new troop development, while strong participation in certain regions helps refine successful engagement strategies.