This software package contains the reproducibility code used to construct and validate the dataset of inter-county distances along the real-world highway and railway networks in the contiguous United States. The workflow implements the QGIS–RStudio crosswalk described in the accompanying study, integrating geographic information system processing with network-based analysis to transform transportation infrastructure shapefiles into spatial networks, select representative network nodes for counties, and compute shortest-path distances between counties.The QGIS–RStudio crosswalk follows four sequential steps: (1) preprocessing of transportation shapefiles in QGIS; (2) construction of highway and railway networks in RStudio; (3) centroid computation and network-node assignment in QGIS; and (4) representative-node selection and shortest-path distance computation in RStudio. The highway and railway line features are transformed into undirected weighted network graphs, with segment lengths used as edge weights. Adjusted geometric centroids are used as spatial references for selecting representative network nodes within counties, while the inter-county shortest-path distances are computed between the selected representative network nodes rather than between county centroids directly.The software package also includes code for the principal Technical Validation analyses reported in the accompanying study. These include FAF-scale empirical comparisons using Freight Analysis Framework Version 5.7.1, evaluation under alternative centroid choices and representative-node selections, county-level sensitivity analyses of centroid choice and representative-node selection, and independent county-level comparisons with external highway and railway routing systems. Population-weighted centroids and second-nearest qualifying network nodes are used as alternative specifications in the sensitivity analyses.For the independent external validation, 150 origin–destination county pairs are sampled for each transportation mode using stratified random sampling across the four U.S. Census regions and three mode-specific distance strata. Highway routing distances are obtained using the HERE Routing API v8 with truck transport mode and short routing mode. Railway routing distances are obtained using OpenRailRouting with the non_tgv routing profile. Routes are calculated in both the origin-to-destination and destination-to-origin directions and averaged for comparison with the symmetric inter-county distances generated from the undirected network graphs.Detailed instructions for required input data, QGIS processing, RStudio-based network construction, representative-node selection, shortest-path distance computation, expected outputs, checkpoint reuse, and validation procedures are provided in the included README.md. The workflow was implemented using QGIS (version 4.2.1) and R (version 4.6.0), consistent with the accompanying manuscript.The associated dataset is available separately on Figshare at DOI: 10.6084/m9.figshare.32211066.
Yongxin Cai, Xinyan Li, Deniz Karakoç· Figshare· 0 citations
This software package contains the reproducibility code used to construct and validate the dataset of inter-county distances along the real-world highway and railway networks in the contiguous United States. The workflow implements the QGIS–RStudio crosswalk described in the accompanying study, integrating geographic information system processing with network-based analysis to transform transportation infrastructure shapefiles into spatial networks, select representative network nodes for counties, and compute shortest-path distances between counties.The QGIS–RStudio crosswalk follows four sequential steps: (1) preprocessing of transportation shapefiles in QGIS; (2) construction of highway and railway networks in RStudio; (3) centroid computation and network-node assignment in QGIS; and (4) representative-node selection and shortest-path distance computation in RStudio. The highway and railway line features are transformed into undirected weighted network graphs, with segment lengths used as edge weights. Adjusted geometric centroids are used as spatial references for selecting representative network nodes within counties, while the inter-county shortest-path distances are computed between the selected representative network nodes rather than between county centroids directly.The software package also includes code for the principal Technical Validation analyses reported in the accompanying study. These include FAF-scale empirical comparisons using Freight Analysis Framework Version 5.7.1, evaluation under alternative centroid choices and representative-node selections, county-level sensitivity analyses of centroid choice and representative-node selection, and independent county-level comparisons with external highway and railway routing systems. Population-weighted centroids and second-nearest qualifying network nodes are used as alternative specifications in the sensitivity analyses.For the independent external validation, 150 origin–destination county pairs are sampled for each transportation mode using stratified random sampling across the four U.S. Census regions and three mode-specific distance strata. Highway routing distances are obtained using the HERE Routing API v8 with truck transport mode and short routing mode. Railway routing distances are obtained using OpenRailRouting with the non_tgv routing profile. Routes are calculated in both the origin-to-destination and destination-to-origin directions and averaged for comparison with the symmetric inter-county distances generated from the undirected network graphs.Detailed instructions for required input data, QGIS processing, RStudio-based network construction, representative-node selection, shortest-path distance computation, expected outputs, checkpoint reuse, and validation procedures are provided in the included README.md. The workflow was implemented using QGIS (version 4.2.1) and R (version 4.6.0), consistent with the accompanying manuscript.The associated dataset is available separately on Figshare at DOI: 10.6084/m9.figshare.32211066.
Yongxin Cai, Xinyan Li, Deniz Karakoç· Figshare· 0 citations
This dataset provides transportation mode-specific inter-county shortest-path distances along the real-world highway and railway networks in the contiguous United States. The dataset was generated using a QGIS–RStudio crosswalk that integrates geographic information system processing with network-based analysis to transform transportation infrastructure shapefiles into spatial networks and compute shortest-path distances between counties.The released dataset contains 15,213,970 origin–destination records across the two transportation modes. Among the 3,109 counties in the study area, 2,863 counties have an available representative network node on the highway network and 2,649 counties have an available representative network node on the railway network. Accordingly, the dataset contains 8,196,769 highway records and 7,017,201 railway records. For each transportation mode, the dataset contains all ordered origin–destination combinations among counties with available representative network nodes, including same-county records. Because the highway and railway network graphs are undirected, the reported inter-county distances are symmetric, although both origin–destination directions are retained as separate records.In the construction procedure, the adjusted geometric centroid of each county is used as the spatial reference for representative-node selection. Only network nodes assigned to the same county GEOID and belonging to the largest connected component of the corresponding transportation network are retained as qualifying network nodes. The qualifying node nearest to the adjusted geometric centroid is selected as the representative network node for that county. The adjusted geometric centroid itself is not used directly as an origin or destination in the shortest-path calculation. Instead, inter-county shortest-path distances are computed between the selected representative network nodes using edge-length weights along the corresponding real-world highway or railway network.Each record contains the origin county GEOID (ori_geoid), origin county and state name (ori_name), origin adjusted geometric centroid latitude and longitude (ori_centroid_lat, ori_centroid_lon), origin mode-specific representative network-node latitude and longitude (ori_node_lat, ori_node_lon), destination county GEOID (des_geoid), destination county and state name (des_name), destination adjusted geometric centroid latitude and longitude (des_centroid_lat, des_centroid_lon), destination mode-specific representative network-node latitude and longitude (des_node_lat, des_node_lon), transportation mode (mode), and inter-county shortest-path distance in miles (distance). All latitude and longitude coordinates are reported in WGS 84 (EPSG:4326).The highway network is constructed from highway features classified as Classes 1–2–3, corresponding to freeways, primary highways, and secondary highways or municipal arterials, respectively. The railway network is constructed from railway features categorized as M, I, or O, corresponding to the main sub-network, major industrial leads, and other tracks (minor industrial leads), respectively. The transportation infrastructure data are obtained from datasets maintained by the U.S. Department of Transportation Bureau of Transportation Statistics.The dataset can support applications in transportation planning, infrastructure investment, freight transportation, and supply chain and logistics analysis. The accompanying reproducibility code is available separately as a Figshare Software item at DOI: 10.6084/m9.figshare.33936526.
Yongxin Cai, Xinyan Li, Deniz Karakoç· Figshare· 0 citations
We use cookies to run the site and, with your consent, for analytics and to show ads.
See our Cookie Policy.
