Apps

Public-facing and internal web applications for the Unified Government of Wyandotte County and Kansas City, KS

Community Project App

Developed a public-facing web application for the Public Works department to share capital projects.Built a spatial database and interactive map with project details, a request form, and an informational page on project prioritization.Enhanced transparency and communication between residents and Public Works staff.

Asset Risk Scoring App

Developed an internal tool for the Public Works department to identify infrastructure at high risk of failure.Applied risk scoring algorithms across stormwater, wastewater, and ditching systems and built interactive ArcGIS dashboards for visualization.Enabled data-driven maintenance prioritization and resource allocation amid constrained funding.

Stormwater

Wastewater

Ditching

Residential Trash Day Lookup

Developed a public-facing web application for residents of Wyandotte County to find their trash day.

Reports and Dashboards

Internal dashboards and reports for the Unified Government of Wyandotte County & Kansas City, KS

Power BI Reports

System Summary and Insights

Pump Station Inspections

GIS Dashboards

Collection System Release Events

Untelevised Gravity Sewer Mains

Developed an internal tool for the Public Works department to identify untelevised gravity sewer mains and filter by various attributes.

What I'm working on now...

Projects in progress for the Unified Government of Wyandotte County & Kansas City, KS

Educational Webpage

Developing a public-facing webpage for the Public Works department to share Consent Decree and IOCP information.Intended to inform and educated the public, elected officials, and internal staff.

Pavement Preservation Python Script

Developing a script that automates the pavement preservation prioritization process.