pavement condition in Sac City, part 2

I started wondering about other variables that might affect pavement condition index (PCI) in the council districts, so here is a little more exploration. See the previous post: pavement condition in Sac City.

First, the council district map, for those who may not be familiar with boundaries.

I wondered about the relationship between population density (people per square mile) and PCI. There isn’t any correlation, though again, the district 1 and 8 outliers may be interesting. I did not realize that district 8 has the highest population density of the districts.

I wondered about the relationship between lanes miles and PCI. There is a weak correlation.

And finally, here is my current data table, in case you want to play with data or suggest insights. Note that the population of each district is roughly the same, as it should be. The unfunded column is the amount (millions of dollars) of backlog, to bring roadways up to PCI 75, but it does not include the ongoing yearly expense of maintaining them at that level.

Author: Dan Allison

Dan Allison is a Safe Routes to School Coordinator in the Sacramento area. Dan dances and backpacks, as much as possible.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s