[5pt] Empty threshold data columns in bridge data

[RobHanna-NOAA]

In our osm bridge centroid csv's, we have some possible bad data. Of the total 1,223,788 combined total records, some show zero in one or more the columns of "threshold_hand_ft", "threshold_hand_75_ft", "threshold_discharge_cfs", and "bp.threshold_discharge_75_cfs"

2,200 recs are showing values of zero for at least one of those columns and appx 1,900 have all of those four columns showing zero.

Examples:
osmid, name, huc8, featureid, branch_id,
1225523247 "None" "01010004" "0" 804823
1073917976 "None" "01010005" "0" 816977
1077542881 "4" "01010006" "0" 1010003126
33218594 "7e Rang" "01010008" "0" 1010000436
1233327286 "Autoroute Claude-Béchard" "01010008" "1010000055" 1010001440
1233327288 "Autoroute Claude-Béchard" "01010008" "1010000055" 1010001440

Question as well: in flow calcs in HV, we use the two discharge columns so of course, they should not be zero (I think), but is zero values on the two "feet" (elev) columns matter?

[ZahraGhahremani]

The src/heal_bridges_osm.py filters out only some invalid data, but keeps threshold_hand values that are zero:

inundation-mapping/src/heal_bridges_osm.py

Line 160 in 86a6bcc

osm_gdf = osm_gdf.loc[osm_gdf.threshold_hand >= 0]