Managing Public Works for a City is a perpetual endeavor, and in some ways is one of those tasks wherein when you do it correctly nobody notices that you’ve done anything at all.
Even a small city of ~42,000 people, such as Klamath Falls Oregon, has hundreds of miles of streets, most of which have not one but two sidewalk segments to go along with them. These sidewalk segments wear and sustain damage and must be repaired and/or replaced as time moves forward.
In the Fall of 2020 I took a Raster Data GIS course at OIT and our major project of the term was to take data on the state of repair(or lack thereof) of every sidewalk segment in the city and figure out where the city needs to send the repair crews first.
Using the provided data, I ultimately devised the following workflow: