GIS Portfolio

Pangborn-Herndon 1931 Flight

City of Wenatchee  |  ArcGIS Story Maps

This story map documents the historic 1931 transpacific flight by Clyde Pangborn and Hugh Herndon Jr. - the first non-stop crossing of the Pacific Ocean, from Misawa, Japan to Wenatchee, Washington. Pangborn was a native of Bridgeport, about 50 miles northeast of Wenatchee.

As part of the City of Wenatchee GIS Internship, interns are assigned a story map on any topic connected to the Wenatchee Valley. I considered a few topics before landing on the history behind Pangborn Memorial Airport, and it was a natural fit given my interest in aviation. I completed the story map before leaving the internship early to take a position in the Tri-Cities.

South Columbia Basin Irrigation District Web Map

Franklin County  |  ArcGIS Web AppBuilder

The South Columbia Basin Irrigation District (SCBID) web map was originally developed through collaboration between my predecessor and the County GIS Manager. By the time I joined Franklin County, that staff member had departed and the application required significant redevelopment and stabilization within the existing ArcGIS Enterprise environment.

I was responsible for rebuilding the application from the ground up, re-establishing service configuration, restructuring layer behavior across scale ranges, and restoring a functional public-facing interface for district stakeholders. This work included resolving performance issues, reconfiguring service dependencies, and ensuring the application aligned with operational requirements across multiple user groups.

The map uses a zoom-based visibility system to manage a large number of layers at different scales. This was one of my first large projects using ArcGIS Pro and ArcGIS Enterprise in a production environment. Working through the obstacles on this project gave me a solid foundation in the ArcGIS platform that carried through the rest of my time at the County.

Originally developed and maintained while working for Franklin County. The application has since been migrated to a different platform and may deviate from the version shown here.

Culvert Inspection Field Map

Franklin County  |  ArcGIS Field Maps

Franklin County maintains over 1,000 culverts under county roadways. Inspections had historically been done on paper forms in the field, then manually entered back at the office. I was tasked with digitizing the process using ArcGIS Field Maps.

The form splits the original culverts layer into a point layer for pipe measurements and a related inspection records table, linked by a common Culvert ID. Smart Forms logic auto-calculates date fields and shows or hides field groups based on whether a culvert is new or existing. Color-coded map symbology lets the crew track inspection status in the field in real time.

I went out with the maintenance crew in December 2023 to run the first live inspection using the app, noted areas for improvement, and iterated from there. Inspections using Field Maps took just over a month to complete. I presented the project at the Local GIS Network meeting in Kennewick in January 2024.

Gravel Road Maintenance Dashboard

Franklin County  |  ArcGIS Dashboards / Experience Builder

A public-facing tracking tool for gravel road blading and Magnesium Chloride (MgCl) application across Franklin County. The original version was built in ArcGIS Dashboards in 2023; I rebuilt it in ArcGIS Experience Builder for the 2024 season with two key improvements: the data layer was switched from a map image to a feature service (allowing in-place edits without republishing), and I added a related Blading Records table to log every maintenance event per road segment.

Weekly updates involved coordinating scheduled roads with crew supervisors and tracking completed work through the County's WinCAMS timecard system. The Experience Builder version also added a more capable search feature and click-through pop-ups from both the map and the list panels. I also built out a Solid Waste recycling sites map as an additional page before leaving the County.