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.