GIS + Automation Projects

I build practical GIS and automation solutions for municipal partners and Scouting America—combining ArcGIS, data modeling, and Python/Power Automate to turn legacy workflows into fast, transparent, and measurable results.

Showing 16 of 16 projects

Emergency Vehicle Preemption Dashboard 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.
Sustainability StoryMap 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.
Water Service Card Modernization 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.
Pond Ownership Inventory Dashboard 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.
Supply Inventory Tracking System 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.
Fiber Line Linking and Depth/DFP Pilot 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 for Utility Atlas Requests 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 for Zoning Variance Updates 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.
Utility As-Built Autopilot Feature Extractor Municipal GIS Partners

Utility As-Built Autopilot

Built a CV/ML production line that turns scanned utility as-built drawings into GIS-ready features. Analysts label drawings in CVAT, PyTorch models (DeepLab for linework, YOLOv5 for symbols) detect infrastructure, and a Vision AI feature extractor web app lets reviewers crop PDFs, run GPT-4o or local Qwen2.5-VL extractions, georeference results on Leaflet, and export CSV/JSON/GeoJSON for ArcGIS.

PyTorch DeepLab YOLOv5 GPT-4o Qwen2.5-VL
Result: Early pilots cut manual digitizing time by ~60% while preserving analyst oversight through schema mapping, fuzzy matching, and GIS-ready exports.
Water Service Card Reviewer 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.
Bivariate Market Share 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.
Heat Map of Scouts 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.
TAY in TRLZ 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.
Total Cub Scout Market Share 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.
Total Scouts BSA by Population 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.