4 files

Panel Data Preparation and Ordered Probit Models for Social Equity of Bridge Management

Download all (201 MB)


NBI_Census_Climate_J40_Panel_min3_100yrs_small_avg_50_60: Resulting panel of spatially matched NBI structure, demographic, and climate data from panel preparation script.

 Panel_Prep_NBI_Census_Climate_Gandy_08252022:  This R script requires downloaded and unzipped 1992-2020 NBI ASCII files, downloaded secondary climate attributes, and a U.S. Census Bureau API key to create a panel of spatially matched NBI structure, demographic, and climate data. 

Models_PGLM_NBI_Census_Climate_Gandy2022: R script specifying ordered probit models to produce main analysis from "Social Equity of Bridge Management." Input is the panel of NBI, census, and climate data. Requires R packages PGLM and texreg. 

Key Resources:

Federal Highway Administration. (2021). National Bridge Inventory ASCII Files. Retrieved February 1, 2022, from https://www.fhwa.dot.gov/bridge/nbi/ascii.cfm

Liao, T., Kepley, P., Kumar, I., & Labi, S. (2020). Revisiting the secondary climate attributes for transportation infrastructure management: A Redux and Update for 2020, 1(765).

Croissant, Y., & Millo, G. (2018). Panel Data Econometrics with R. Panel Data Econometrics with R. Hoboken, NJ: Wiley.

Leifeld, P. (2013). Texreg: Conversion of statistical model output in R to LATEX and HTML tables. Journal of Statistical Software, 55(8). https://doi.org/10.18637/jss.v055.i08