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.

Many of these graphs lack a legend describing what each color/line is. Also, many of the Y axes are missing units labels. We can infer that it's %progress from the context of the post, but you should always label your axes.

Other than, interesting post.

Also, how the heck did we lose progress towards completion? Did someone make a big oopsie that accidentally destroyed a bunch of stuff?

[removed]

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