Water Line Identification Tracker

This Dashboard shows the subdivisions that have water service lines of as yet unknown material, from the Lead Service Line Inventory. It uses custom Arcade expressions to create the lists and pop-ups. I wrote a Python script to keep the total “unknowns” by subdivision updated, so the transparency of the subdivision polygons would automatically update.

Pavement Marking Dashboard

A Dashboard to view and quantify pavement markings. This dashboard is used to help with bidding re-painting the pavement markings.

Pavement Moratorium Search

This is a simple Instant App to search by address, to see if it is on a street with new pavement; there is a moratorium on the use of heavy equipment for 5 years on new pavement.

Snow Plow Maps

For snow plowing routes, a full-city map to show zone locations when 8 trucks are used. I created 7 full-city maps and 5 map series for 96 total pdf maps. One page of the 8 route map series with one zone per page. Different numbers of trucks are used for different snowfall amounts.

Utilities Mapping

Two pages from a map series I created showing storm, sanitary utilities and surface water basins along a railroad line in the city, to show where culverts cross the railroad.

World Avocado Harvest

In 2022, the US temporarily blocked all imports of avocados from Mexico after a verbal threat was made to U.S. safety inspectors working in the country. Mexico supplies about 80 percent of the avocados eaten in the United States. I was curious which other countries grow a large volume of avocados, and where else the …