GenButtNekkid OP t1_jeh5jd7 wrote on March 31, 2023 at 11:59 PM

Reply to comment by I-Pop-Bubbles in [OC] Visualization of progress on the San Francisco Sewer System Improvement Project by GenButtNekkid

My best guess is that project timeline estimates were extended due to the COVID pandemic

GenButtNekkid OP t1_jebdqaf wrote on March 30, 2023 at 7:54 PM

Reply to [OC] Visualization of progress on the San Francisco Sewer System Improvement Project by GenButtNekkid

As a passion project of mine many years ago when i left college i started tracking the city's SSIP project with data visualization. It was mostly for me to keep up on my excel (actually, google sheets) skills.

All of this data was collecting directly from quarterly and annual reports published by the SF SSIP.

Has been a kitsch way to keep up on the city's accountability of their budget allocation.

edit: it seems my last graph is missing its legend/key.
the below legend is only for the last two graphs
blue is total amount of pre construction projects
red is projects in design stage
yellow is projects in the planning stage
green is projects in the bid/award stage.