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

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. <br> To replicate panel preparation from raw data, call Panel_Prep.R to initialize the function and call the function with the following arguments: panel_prep(input_wd, output_wd, api_key, cejst_file, climate_file) Where: "input_wd" is the file path to the downloaded and unzipped input files for NBI, CEJST, and Climate "output_wd" is the file path to an output folder "api_key" is the user's Census API Key "cejst_file" is the CEJST CSV file name "climate_file" is the Climate CSV file name For example: panel_prep("/Documents/input","/Documents/output","abcdefg", "cejst.csv","climate.csv")<br> 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. <br> 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 <br> Liao, T., Kepley, P., Kumar, I., &amp; Labi, S. (2020). Revisiting the secondary climate attributes for transportation infrastructure management: A Redux and Update for 2020, 1(765). <br> Croissant, Y., &amp; Millo, G. (2018). Panel Data Econometrics with R. Panel Data Econometrics with R. Hoboken, NJ: Wiley. <br> 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

NBI_Census_Climate_J40_Panel_min3_100yrs_small_avg_50_60：通过面板构建脚本生成的空间匹配版国家桥梁清单（National Bridge Inventory，NBI）、人口统计与气候数据面板。
若需从原始数据复现该面板的构建流程，请调用Panel_Prep.R脚本初始化函数，并以如下参数调用该函数：panel_prep(input_wd, output_wd, api_key, cejst_file, climate_file)。各参数含义如下："input_wd"为已下载并解压的NBI、CEJST与气候原始输入文件的存储路径；"output_wd"为输出文件夹的存储路径；"api_key"为用户的美国人口普查API密钥；"cejst_file"为CEJST格式CSV文件的文件名；"climate_file"为气候数据CSV文件的文件名。示例如下：panel_prep("/Documents/input","/Documents/output","abcdefg", "cejst.csv","climate.csv")
Models_PGLM_NBI_Census_Climate_Gandy2022：该R脚本用于指定有序Probit模型，以从《桥梁管理的社会公平性》研究中生成核心分析结果，输入数据为NBI、人口普查与气候数据面板。需依赖R语言扩展包PGLM与texreg。
关键参考资源：
1. 美国联邦公路管理局（Federal Highway Administration，FHWA）. (2021). 国家桥梁清单ASCII文件. 2022年2月1日检索自：https://www.fhwa.dot.gov/bridge/nbi/ascii.cfm
2. Liao, T., Kepley, P., Kumar, I., & Labi, S. (2020). 重新审视交通基础设施管理的次生气候属性：2020年回顾与更新，1(765).
3. Croissant, Y., & Millo, G. (2018). 《基于R的面板数据计量经济学》. 新泽西州霍博肯：Wiley出版社.
4. Leifeld, P. (2013). Texreg：将R语言统计模型输出转换为LaTeX与HTML表格. 《统计软件期刊》，55(8). https://doi.org/10.18637/jss.v055.i08