(2026.08.12 -- Andy Carter) This workflow documents how to convert bridge data from ORNL's bridge extraction methodolgy across Texas into databases and supporting files for the FAST (Flood Assesment System for TxDOT) application. File index for the ORNL bridge conversion pipeline. Statewide inputs are shared across all districts. Remote inputs and outputs change with the selected district.
Pipeline overview
Scripts
Statewide inputs
input/
| File | Info | Source |
|---|---|---|
| nbi_bridges_texas_4326.parquet | Bridge thickness rubric | TxDOT Bridge Division (Trent Ellis) |
| demDerived_reaches_split_filtered_addedAttributes_crosswalked_3081.fgb | Streamlines from the Texas 3 m HAND hydrofabric | ORNL — Texas (Dr. Yan Liu) |
| snbi_from_TxDOT_20260806_pnt_4326.fgb | SNBI bridge points; fills missing NBI numbers | TxDOT Bridges SNBI ↗ |
| t_nextgen_to_nwm.parquet | Crosswalk: NWM streamlines → Texas 3 m HAND streams | ORNL — Texas (Dr. Yan Liu) |
| hydroTable_rp_bf_lmtdischarge_cda.parquet | HAND rating curves per Texas 3 m HAND | ORNL — Texas (Dr. Yan Liu) |
Statewide outputs · all districts
| File | Info |
|---|---|
| json_bridges_20260810.zip | Per-bridge cross-section JSON records — all districts (zip) |
| output_20260807/merged_07_02_s_bridge_pnt_4326.fgb | Statewide merged bridge points (all districts) |
Remote inputs · per district
| File | Info |
|---|
Outputs · per district
| File | Info |
|---|