Back to fileView metadata
Schema
National Bridge Inventory (NBI) / national-bridge-inventory-nbi / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
128 columns
Features
624,193
Geometry
Point
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| STATE_CODE_001 | string | No | 0 | — | — Range: —Length: 2 | Examples: 02, 01, 01, 01, 02 Values: 01, 02 |
| STRUCTURE_NUMBER_008 | string | No | 0 | — | — Range: —Length: 15 | Examples: 0842, 004024, 005615, 005203, 1458 Values: — |
| RECORD_TYPE_005A | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 1, 1 Values: 1 |
| ROUTE_PREFIX_005B | string | No | 0 | — | — Range: —Length: 1 | Examples: 3, 4, 3, 4, 3 Values: 1, 2, 3, 4, 5, 6, 7, 8 |
| SERVICE_LEVEL_005C | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 0, 1 Values: 0, 1, 2, 3, 4, 7, 8 |
| ROUTE_NUMBER_005D | string | No | 0 | — | — Range: —Length: 5 | Examples: 00786, 01009, 00102, 00026, 00929 Values: — |
| DIRECTION_005E | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 1, 2, 3, 4 |
| HIGHWAY_DISTRICT_002 | string | No | 0 | — | — Range: —Length: 2 | Examples: 02, 05, 10, 02, 03 Values: 0, 00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 1, 10, 2, 3, CN, N, SE |
| COUNTY_CODE_003 | string | No | 0 | — | — Range: —Length: 3 | Examples: 240, 119, 057, 083, 198 Values: — |
| PLACE_CODE_004 | string | No | 0 | — | — Range: —Length: 5 | Examples: 20380, 90801, 00000, 92817, 77140 Values: — |
| FEATURES_DESC_006A | string | No | 0 | — | — Range: —Length: 24 | Examples: AMERICAN CREEK NO 2, CO RT 1009 STREAM, North River, ELK RIVER, RIO BEAVER Values: — |
| CRITICAL_FACILITY_006B | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| FACILITY_CARRIED_007 | string | No | 0 | — | — Range: —Length: 18 | Examples: TAYLOR HIGHWAY, ROADWAY, AL-102, ELK RIV MILLS RD*, THORNE BAY ROAD Values: — |
| LOCATION_009 | string | No | 0 | — | — Range: —Length: 25 | Examples: MILE POINT 150.4, 0.7 MI S US HWY 80, 3.5 MI W Walker Co Line, SEC25 T2S R6W, MILE POINT 7.3 Values: — |
| MIN_VERT_CLR_010 | float | No | 0 | — | — Range: 0 to 99.99Length: — | Examples: 99.99, 99.99, 99.99, 99.99, 99.99 Values: — |
| KILOPOINT_011 | float | No | 0 | — | — Range: 0 to 1178.091Length: — | Examples: 242.021, 0.0, 22.574, 0.01, 11.774 Values: — |
| BASE_HWY_NETWORK_012 | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 1, 0, 0 Values: , 0, 1 |
| LRS_INV_ROUTE_013A | string | No | 0 | — | — Range: —Length: 10 | Examples: 0025000000, 000CO10090, 000AL01020, 000CO00260, Values: — |
| SUBROUTE_NO_013B | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, Values: , 0 |
| LAT_016 | string | No | 0 | — | — Range: —Length: 8 | Examples: 64415800, 32252187, 33481980, 34505142, 55411400 Values: — |
| LONG_017 | string | No | 0 | — | — Range: —Length: 9 | Examples: 141185200, 088221941, 087350168, 087070458, 132434600 Values: — |
| DETOUR_KILOS_019 | integer | No | 0 | — | — Range: 0 to 999Length: — | Examples: 199, 21, 23, 26, 199 Values: — |
| TOLL_020 | string | No | 0 | — | — Range: —Length: 1 | Examples: 3, 3, 3, 3, 3 Values: 2, 3 |
| MAINTENANCE_021 | string | No | 0 | — | — Range: —Length: 2 | Examples: 01, 02, 01, 02, 01 Values: 01, 02, 03, 04, 11, 21, 25, 26, 27, 61, 62, 63, 64, 66, 67, 68, 70, 72, 74 |
| OWNER_022 | string | No | 0 | — | — Range: —Length: 2 | Examples: 01, 02, 01, 02, 01 Values: 01, 02, 04, 11, 21, 25, 27, 61, 62, 63, 64, 66, 67, 68, 70, 72, 74 |
| FUNCTIONAL_CLASS_026 | string | No | 0 | — | — Range: —Length: 2 | Examples: 07, 08, 06, 08, 07 Values: 01, 02, 06, 07, 08, 09, 11, 12, 14, 16, 17, 19 |
| YEAR_BUILT_027 | integer | No | 0 | — | — Range: 1898 to 2024Length: — | Examples: 1988, 1951, 1956, 1955, 1975 Values: — |
| TRAFFIC_LANES_ON_028A | string | No | 0 | — | — Range: —Length: 1 | Examples: 2, 2, 2, 2, 2 Values: 1, 2, 3, 4, 5, 6, 7, 8, 9 |
| TRAFFIC_LANES_UND_028B | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 2, 3, 4, 5, 6, 8, 9 |
| ADT_029 | integer | No | 0 | — | — Range: 0 to 62647Length: — | Examples: 20, 1024, 839, 2380, 190 Values: — |
| YEAR_ADT_030 | integer | No | 0 | — | — Range: 0 to 2025Length: — | Examples: 2020, 2020, 2020, 2010, 2020 Values: — |
| DESIGN_LOAD_031 | string | No | 0 | — | — Range: —Length: 1 | Examples: 5, 2, 2, 2, 5 Values: 0, 1, 2, 3, 4, 5, 6, 9, A, B, C |
| APPR_WIDTH_MT_032 | float | No | 0 | — | — Range: 0.6 to 48.2Length: — | Examples: 8.5, 10.4, 9.4, 7.3, 8.8 Values: — |
| MEDIAN_CODE_033 | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 1, 2, 3 |
| DEGREES_SKEW_034 | integer | No | 0 | — | — Range: 0 to 99Length: — | Examples: 30, 0, 0, 0, 0 Values: — |
| STRUCTURE_FLARED_035 | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 1 |
| RAILINGS_036A | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 1, N, 0, 1 Values: 0, 1, N |
| TRANSITIONS_036B | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, N, 1, 1 Values: 0, 1, N |
| APPR_RAIL_036C | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, N, 1, 1 Values: 0, 1, N |
| APPR_RAIL_END_036D | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 1, N, 0, 1 Values: 0, 1, N |
| HISTORY_037 | string | No | 0 | — | — Range: —Length: 1 | Examples: 5, 5, 5, 5, 5 Values: 1, 2, 3, 4, 5 |
| NAVIGATION_038 | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 1, 0 Values: 0, 1, N |
| NAV_VERT_CLR_MT_039 | float | No | 0 | — | — Range: 0 to 30.5Length: — | Examples: 0.0, 0.0, 0.0, 8.2, 0.0 Values: — |
| NAV_HORR_CLR_MT_040 | float | No | 0 | — | — Range: 0 to 137.1Length: — | Examples: 0.0, 0.0, 0.0, 36.6, 0.0 Values: — |
| OPEN_CLOSED_POSTED_041 | string | No | 0 | — | — Range: —Length: 1 | Examples: A, A, A, P, A Values: A, B, D, E, G, K, P, R |
| SERVICE_ON_042A | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 1, 1 Values: 1, 4, 5, 6 |
| SERVICE_UND_042B | string | No | 0 | — | — Range: —Length: 1 | Examples: 5, 5, 5, 5, 5 Values: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
| STRUCTURE_KIND_043A | string | No | 0 | — | — Range: —Length: 1 | Examples: 5, 1, 1, 4, 4 Values: 1, 2, 3, 4, 5, 6, 7, 8, 9 |
| STRUCTURE_TYPE_043B | string | No | 0 | — | — Range: —Length: 2 | Examples: 04, 04, 19, 02, 03 Values: 00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 14, 19, 21, 22 |
| APPR_KIND_044A | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 1, 0 Values: 0, 1, 2, 3, 4, 5, 6, 7 |
| APPR_TYPE_044B | string | No | 0 | — | — Range: —Length: 2 | Examples: 00, 00, 00, 04, 00 Values: 00, 01, 02, 03, 04, 05, 06, 09, 10, 11, 12, 19, 20, 22 |
| MAIN_UNIT_SPANS_045 | integer | No | 0 | — | — Range: 1 to 200Length: — | Examples: 1, 5, 2, 3, 3 Values: — |
| APPR_SPANS_046 | integer | No | 0 | — | — Range: 0 to 1888Length: — | Examples: 0, 0, 0, 2, 0 Values: — |
| HORR_CLR_MT_047 | float | No | 0 | — | — Range: 0 to 99.9Length: — | Examples: 8.5, 6.6, 10.7, 6.6, 7.2 Values: — |
| MAX_SPAN_LEN_MT_048 | float | No | 0 | — | — Range: 0 to 189Length: — | Examples: 33.2, 11.0, 3.0, 39.9, 38.4 Values: — |
| STRUCTURE_LEN_MT_049 | float | No | 0 | — | — Range: 6.1 to 1981.2Length: — | Examples: 33.5, 54.9, 6.4, 154.8, 46.0 Values: — |
| LEFT_CURB_MT_050A | float | No | 0 | — | — Range: 0 to 7.2Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| RIGHT_CURB_MT_050B | float | No | 0 | — | — Range: 0 to 7.2Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| ROADWAY_WIDTH_MT_051 | float | No | 0 | — | — Range: 0 to 49.2Length: — | Examples: 8.6, 6.6, 0.0, 6.6, 7.3 Values: — |
| DECK_WIDTH_MT_052 | float | No | 0 | — | — Range: 0 to 67.7Length: — | Examples: 8.9, 7.7, 0.0, 7.3, 7.4 Values: — |
| VERT_CLR_OVER_MT_053 | float | No | 0 | — | — Range: 0 to 99.99Length: — | Examples: 99.99, 99.99, 99.99, 99.99, 99.99 Values: — |
| VERT_CLR_UND_REF_054A | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: H, N, R |
| VERT_CLR_UND_054B | float | No | 0 | — | — Range: 0 to 99.99Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| LAT_UND_REF_055A | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: H, N, R |
| LAT_UND_MT_055B | float | No | 0 | — | — Range: 0 to 99.9Length: — | Examples: 99.9, 0.0, 0.0, 99.9, 99.9 Values: — |
| LEFT_LAT_UND_MT_056 | float | No | 0 | — | — Range: 0 to 99.8Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| DECK_COND_058 | string | No | 0 | — | — Range: —Length: 1 | Examples: 8, 7, N, 7, 8 Values: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, N |
| SUPERSTRUCTURE_COND_059 | string | No | 0 | — | — Range: —Length: 1 | Examples: 7, 7, N, 7, 6 Values: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, N |
| SUBSTRUCTURE_COND_060 | string | No | 0 | — | — Range: —Length: 1 | Examples: 6, 7, N, 5, 6 Values: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, N |
| CHANNEL_COND_061 | string | No | 0 | — | — Range: —Length: 1 | Examples: 6, 6, 5, 7, 6 Values: 1, 2, 3, 4, 5, 6, 7, 8, 9, N |
| CULVERT_COND_062 | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, 6, N, N Values: 3, 4, 5, 6, 7, 8, 9, N |
| OPR_RATING_METH_063 | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 1, 1 Values: 0, 1, 2, 3, 4, 5, 7, 8, A |
| OPERATING_RATING_064 | float | Yes | 3 | — | — Range: 0 to 99.9Length: — | Examples: 42.3, 63.2, 99.9, 99.9, 88.9 Values: — |
| INV_RATING_METH_065 | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 1, 1, 1, 1 Values: 0, 1, 2, 3, 4, 5, 7, 8, A |
| INVENTORY_RATING_066 | float | Yes | 3 | — | — Range: 0 to 99.9Length: — | Examples: 25.3, 37.9, 61.6, 48.6, 64.9 Values: — |
| STRUCTURAL_EVAL_067 | string | No | 0 | — | — Range: —Length: 1 | Examples: 6, 6, 6, 5, 6 Values: *, 0, 2, 3, 4, 5, 6, 7, 8, 9 |
| DECK_GEOMETRY_EVAL_068 | string | No | 0 | — | — Range: —Length: 1 | Examples: 7, 2, N, 2, 5 Values: 0, 2, 3, 4, 5, 6, 7, 8, 9, N |
| UNDCLRENCE_EVAL_069 | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: 0, 2, 3, 4, 5, 6, 7, 8, 9, N |
| POSTING_EVAL_070 | string | No | 0 | — | — Range: —Length: 1 | Examples: 5, 5, 5, 3, 5 Values: 0, 1, 2, 3, 4, 5 |
| WATERWAY_EVAL_071 | string | No | 0 | — | — Range: —Length: 1 | Examples: 9, 8, 6, 8, 8 Values: 0, 2, 3, 4, 5, 6, 7, 8, 9, N |
| APPR_ROAD_EVAL_072 | string | No | 0 | — | — Range: —Length: 1 | Examples: 7, 9, 8, 6, 6 Values: 0, 2, 3, 4, 5, 6, 7, 8, 9 |
| WORK_PROPOSED_075A | string | No | 0 | — | — Range: —Length: 2 | Examples: , 35, , 35, Values: , 31, 33, 34, 35, 36, 38 |
| WORK_DONE_BY_075B | string | No | 0 | — | — Range: —Length: 1 | Examples: , 1, , 1, Values: , 1, 2 |
| IMP_LEN_MT_076 | string | Yes | 1,148 | — | — Range: —Length: 6 | Examples: 19.7, 20.5, 215, 18.4, 12.6 Values: — |
| DATE_OF_INSPECT_090 | string | No | 0 | — | — Range: —Length: 4 | Examples: 723, 424, 1223, 1024, 723 Values: — |
| INSPECT_FREQ_MONTHS_091 | integer | No | 0 | — | — Range: 6 to 48Length: — | Examples: 24, 24, 24, 24, 24 Values: — |
| FRACTURE_092A | string | No | 0 | — | — Range: —Length: 3 | Examples: N, N, N, N, Y24 Values: N, Y01, Y03, Y06, Y12, Y24 |
| UNDWATER_LOOK_SEE_092B | string | No | 0 | — | — Range: —Length: 3 | Examples: N, N, N, Y48, N Values: N, Y12, Y24, Y48, Y60 |
| SPEC_INSPECT_092C | string | No | 0 | — | — Range: —Length: 3 | Examples: N, N, N, Y12, N Values: N, Y01, Y03, Y06, Y12, Y24, Y48, Y60, Y99 |
| FRACTURE_LAST_DATE_093A | string | No | 0 | — | — Range: —Length: 4 | Examples: , , , , 0523 Values: — |
| UNDWATER_LAST_DATE_093B | string | No | 0 | — | — Range: —Length: 4 | Examples: , , , 0922, Values: — |
| SPEC_LAST_DATE_093C | string | No | 0 | — | — Range: —Length: 4 | Examples: , , , 1024, Values: — |
| BRIDGE_IMP_COST_094 | string | Yes | 1,441 | — | — Range: —Length: 5 | Examples: 1306, 232, 393, 50, 650 Values: — |
| ROADWAY_IMP_COST_095 | string | Yes | 1,452 | — | — Range: —Length: 4 | Examples: 24, 29, 91, 16, 102 Values: — |
| TOTAL_IMP_COST_096 | string | Yes | 1,451 | — | — Range: —Length: 5 | Examples: 529, 1009, 537, 446, 553 Values: — |
| YEAR_OF_IMP_097 | string | Yes | 1,613 | — | — Range: —Length: 4 | Examples: 2025, 2025, 2025, 2025, 2025 Values: 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2025 |
| OTHER_STATE_CODE_098A | string | No | 0 | — | — Range: —Length: 3 | Examples: , , , , Values: , 020 |
| OTHER_STATE_PCNT_098B | string | No | 0 | — | — Range: —Length: 1 | Examples: , 0, 0, 0, Values: , 0 |
| OTHR_STATE_STRUC_NO_099 | string | No | 0 | — | — Range: —Length: 4 | Examples: , , , , Values: , 2198, NO |
| STRAHNET_HIGHWAY_100 | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 1, 2 |
| PARALLEL_STRUCTURE_101 | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: L, N, R |
| TRAFFIC_DIRECTION_102 | string | No | 0 | — | — Range: —Length: 1 | Examples: 2, 2, 2, 2, 2 Values: 0, 1, 2, 3 |
| TEMP_STRUCTURE_103 | string | No | 0 | — | — Range: —Length: 1 | Examples: , , , , Values: , T |
| HIGHWAY_SYSTEM_104 | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 1 |
| FEDERAL_LANDS_105 | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 1, 2, 3, 4 |
| YEAR_RECONSTRUCTED_106 | float | Yes | 25 | — | — Range: 0 to 2024Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 1992.0 Values: — |
| DECK_STRUCTURE_TYPE_107 | string | No | 0 | — | — Range: —Length: 1 | Examples: 9, 1, N, 1, 8 Values: 1, 2, 3, 4, 5, 6, 8, 9, N |
| SURFACE_TYPE_108A | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, 0, N, 0, 6 Values: 0, 1, 2, 3, 5, 6, 7, 8, 9, N |
| MEMBRANE_TYPE_108B | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, N, 0, 2 Values: 0, 1, 2, 3, 8, 9, N |
| DECK_PROTECTION_108C | string | No | 0 | — | — Range: —Length: 1 | Examples: 8, 0, N, 0, 0 Values: 0, 1, 2, 3, 4, 6, 7, 8, 9, N |
| PERCENT_ADT_TRUCK_109 | float | Yes | 500 | — | — Range: 0 to 90Length: — | Examples: 7.0, 27.0, 1.0, 34.0, 10.0 Values: — |
| NATIONAL_NETWORK_110 | string | No | 0 | — | — Range: —Length: 1 | Examples: 0, 0, 0, 0, 0 Values: 0, 1 |
| PIER_PROTECTION_111 | string | No | 0 | — | — Range: —Length: 1 | Examples: 1, , , 1, 1 Values: , 1, 2, 3, 4, 5 |
| BRIDGE_LEN_IND_112 | string | No | 0 | — | — Range: —Length: 1 | Examples: Y, Y, Y, Y, Y Values: Y |
| SCOUR_CRITICAL_113 | string | No | 0 | — | — Range: —Length: 1 | Examples: 8, 8, 8, 5, 8 Values: 1, 2, 3, 4, 5, 6, 7, 8, 9, N, T, U |
| FUTURE_ADT_114 | integer | No | 0 | — | — Range: 0 to 102654Length: — | Examples: 30, 1522, 956, 3540, 230 Values: — |
| YEAR_OF_FUTURE_ADT_115 | integer | No | 0 | — | — Range: 100 to 2045Length: — | Examples: 2039, 2038, 2040, 2030, 2039 Values: — |
| MIN_NAV_CLR_MT_116 | float | Yes | 198 | — | — Range: 0 to 30.4Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| FED_AGENCY | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: N, Y |
| SUBMITTED_BY | string | No | 0 | — | — Range: —Length: 2 | Examples: 02, 01, 01, 01, 02 Values: 01, 02, 61, 62, 63, 64, 66, 67, 68, 70, 72, 74 |
| BRIDGE_CONDITION | string | No | 0 | — | — Range: —Length: 1 | Examples: F, G, F, F, F Values: F, G, P |
| LOWEST_RATING | integer | No | 0 | — | — Range: 0 to 9Length: — | Examples: 6, 7, 6, 5, 6 Values: — |
| DECK_AREA | float | No | 0 | — | — Range: 5.2 to 22239.88Length: — | Examples: 298.15, 422.73, 60.16, 1130.04, 340.4 Values: — |
| STATUS | string | No | 0 | — | — Range: —Length: 2 | Examples: AM, ST, AM, ST, ST Values: AM, MM, ST |
| DATE | string | No | 0 | — | — Range: —Length: 4 | Examples: 1202, 0825, 1202, 0825, 0825 Values: 0203, 0303, 0403, 0503, 0825, 1202 |
| LATDD | float | No | 0 | — | — Range: 30.252947 to 70.21645Length: — | Examples: 64.703561, 32.422742, 33.805533, 34.847617, 55.687222 Values: — |
| LONGDD | float | No | 0 | — | — Range: -174.182281 to -84.977219Length: — | Examples: -141.312189, -88.372058, -87.583814, -87.117939, -132.729444 Values: — |
Invalid geometry count: 0
Columns hash: 65c1176fcadcbdb58626cc84f079d9a55d73557a805dc0dbe4e26de338b100e3