My Work For

• King County's GIS Center
  • Districts and Development Conditions Report
  • Usage Reporting
  • Road Assets Editor
• Accelerate Networks
  • Phone Numbers in Bulk
  • Number Search
• Kitsap County IT
  • Parcel Details
  • Plat Search

Districts and Development Conditions Report

• Aggregate data for more than 700k parcels in King County
• Average page load time of less than 1000ms for an uncached lookup
• Blends seemlessly with the UX of the 2024 King County website

Built to replace an existing web app of the same name from the mid-2000’s, this report has every piece of data about your parcel tracked by King County. Thanks to clever data management, spatial SQL queries, and caching it takes less than a second to lookup a property.

My Posts About the Districts Report

ESRI Usage Report

• Collects and displays quarterly usage stats for King County's GIS efforts
• Handle ArcMap, ArcGIS Pro, and ArcGIS Online usage data
• Stores and reports on historical usage data by year

Built to replace an excel spreadsheet generated from a few SQL queries and a rather complex Access database the Usage reporting web app is an internal only product of the King County GIS Center that allows us to show our customers how much value they’re getting from our ESRI licensed apps like ArcMap, ArcGIS Online, and ArcGIS Pro. A quarterly report is produced from this app that KC employes can review on the King County State of GIS website.

My Posts About the Usage Report

Road Assets Editor

• Replaces prior web app built using Microsoft's Silverlight technology
• Handles millions of road assets in King County
• A modern interactive web mapping app

Built to support the Roads department at King County, the Road Assets Editor, is an interactive mapping and asset management web app. It allows you to see every road asset in King County, create new assets, and update the properties of existing assets like road signs, curbs, and crosswalks. This app is used everyday to manage the process of improving the County’s road system.

My Posts About the Road Assets Editor

Phone Numbers in Bulk

• Investigate the portablity of Local, Tollfree, and Wireless numbers
• Validate Phone Number ownership
• Handles up to 350 Phone Numbers in 20 seconds

When large organizations switch VOIP phone service providers often they bring their existing phone numbers with them. I built this tool that accepts phone numbers in groups of up to a few hundred and investigates each of them to verify that they can be ported to our network. It also shows the user the current ownership of each number so that they can verify and audit the numbers that they are submitting to us before we begin the complex process of bringing them over to our network. Our customers love this tool. 🥰

Number Search

• ~700k Entries Ingested Daily
• Web App Supports HTTP/2
• Average Page Load Time of 340ms

In support of my brother's company, I wrote a console application that scrapes phone numbers that are available for purchase from a pair of SOAP APIs and a few REST API, and then aggregates them into a locally hosted database. You can review the results of the ingest process and quickly lookup available phone numbers on the Accelerate Networks website.

My Posts About Number Search

Kitsap County Parcel Details

• 28.1K Users a Month
• ~50% of Users on IE 11 or Below
• Average Page Load Time of 765ms

My primary responsibility at Kitsap County was maintaining the public parcel information system. Parcel Details is a web app that allows anyone to look up a tax parcel in Kitsap County. Parcel Details was originally an ASP.NET 4 WebForms project; In the summer of 2018 I rebuilt Parcel Details as an ASP.NET Core MVC project. What I'm most proud of is getting the average page weight down from 6 MBs to less than 200 KBs.

My Posts About Parcel Details

Plats Search

• 1.5K Users a Month
• 25.35ms Server Response Time
• Average Page Load Time of 516ms

Plats Search is web app that allows you to look up survey and plat documents related to a tax parcel. Getting a hold of Plat Records from most Counties in Washington requires going through the formal records request process. Plats Search circumvents this process by allowing people to search for Plats related to a tax parcel and directly download scans of those source documents.

My Posts About Plats Search