Iowa Department of Transportation Bridges

Author

Manjul Balayar

Published

July 11, 2024

Brief Description

The Iowa DOT Bridges dataset includes information on total bridges, obsolete bridges, and deficient bridges. It also contains derived measures such as the proportion of obsolete and deficient bridges and the number of bridges per acre per county.

Source: Iowa Department of Transportation

Measures

Initially, there were three separate datasets: total bridges, obsolete bridges, and deficient bridges, each including the respective counts. After merging all these datasets, the new measures were:

  1. Proportion_Obsolete_Deficient: Calculated by adding total sum of obsolete and deffiecient bridges divided by total bridges.
  2. Bridges_Per_Acre: Calculated by total bridge count divided by county’s total acre per county.
final_merge['Proportion_Obsolete_Deficient'] = (final_merge['Obsolete_Count'] + final_merge['Deficient_Count']) / final_merge['Bridges_Count']
final_merge['Bridges_Per_Acre'] = final_merge['Bridges_Count'] / final_merge['county_area']