About this Dataset

National Bridge Inventory

The National Bridge Inventory dataset is as of June 27, 2024 from the Federal Highway Administration (FHWA) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The data describes more than 615,000 of the Nation's bridges located on public roads, including Interstate Highways, U.S. highways, State and county roads, as well as publicly-accessible bridges on Federal and Tribal lands. The inventory data present a complete picture of the location, description, classification, and general condition data for each bridge. The element data present a breakdown of the condition of each structural and bridge management element for each bridge on the National Highway System (NHS). The Recording and Coding Guide for the Structure Inventory and Appraisal of the Nation's Bridges contains a detailed description of each data element including coding instructions and attribute definitions. The Coding Guide is available at: https://doi.org/10.21949/1519105.
Organization: Federal Geographic Data Committee
Last updated: 2025-06-30T16:06:22.253744
Tags: ngda-fgdc-gda-transportation

Tables

Table 1

@usgov.fgdc_gov_national_bridge_inventory_abd5a.table_1

73.77 MB
623218 rows
130 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "state_code_001" BIGINT,
  "structure_number_008" VARCHAR,
  "record_type_005a" BIGINT,
  "route_prefix_005b" BIGINT,
  "service_level_005c" BIGINT,
  "route_number_005d" VARCHAR,
  "direction_005e" BIGINT,
  "highway_district_002" VARCHAR,
  "county_code_003" BIGINT,
  "place_code_004" BIGINT,
  "features_desc_006a" VARCHAR,
  "critical_facility_006b" VARCHAR,
  "facility_carried_007" VARCHAR,
  "location_009" VARCHAR,
  "min_vert_clr_010" DOUBLE,
  "kilopoint_011" DOUBLE,
  "base_hwy_network_012" DOUBLE,
  "lrs_inv_route_013a" VARCHAR,
  "subroute_no_013b" DOUBLE,
  "lat_016" DOUBLE,
  "long_017" DOUBLE,
  "detour_kilos_019" BIGINT,
  "toll_020" BIGINT,
  "maintenance_021" BIGINT,
  "owner_022" BIGINT,
  "functional_class_026" BIGINT,
  "year_built_027" BIGINT,
  "traffic_lanes_on_028a" BIGINT,
  "traffic_lanes_und_028b" BIGINT,
  "adt_029" BIGINT,
  "year_adt_030" BIGINT,
  "design_load_031" VARCHAR,
  "appr_width_mt_032" DOUBLE,
  "median_code_033" BIGINT,
  "degrees_skew_034" BIGINT,
  "structure_flared_035" BIGINT,
  "railings_036a" VARCHAR,
  "transitions_036b" VARCHAR,
  "appr_rail_036c" VARCHAR,
  "appr_rail_end_036d" VARCHAR,
  "history_037" BIGINT,
  "navigation_038" VARCHAR,
  "nav_vert_clr_mt_039" DOUBLE,
  "nav_horr_clr_mt_040" DOUBLE,
  "open_closed_posted_041" VARCHAR,
  "service_on_042a" BIGINT,
  "service_und_042b" BIGINT,
  "structure_kind_043a" BIGINT,
  "structure_type_043b" BIGINT,
  "appr_kind_044a" BIGINT,
  "appr_type_044b" BIGINT,
  "main_unit_spans_045" BIGINT,
  "appr_spans_046" BIGINT,
  "horr_clr_mt_047" DOUBLE,
  "max_span_len_mt_048" DOUBLE,
  "structure_len_mt_049" DOUBLE,
  "left_curb_mt_050a" DOUBLE,
  "right_curb_mt_050b" DOUBLE,
  "roadway_width_mt_051" DOUBLE,
  "deck_width_mt_052" DOUBLE,
  "vert_clr_over_mt_053" DOUBLE,
  "vert_clr_und_ref_054a" VARCHAR,
  "vert_clr_und_054b" DOUBLE,
  "lat_und_ref_055a" VARCHAR,
  "lat_und_mt_055b" DOUBLE,
  "left_lat_und_mt_056" DOUBLE,
  "deck_cond_058" VARCHAR,
  "superstructure_cond_059" VARCHAR,
  "substructure_cond_060" VARCHAR,
  "channel_cond_061" VARCHAR,
  "culvert_cond_062" VARCHAR,
  "opr_rating_meth_063" VARCHAR,
  "operating_rating_064" DOUBLE,
  "inv_rating_meth_065" VARCHAR,
  "inventory_rating_066" DOUBLE,
  "structural_eval_067" VARCHAR,
  "deck_geometry_eval_068" VARCHAR,
  "undclrence_eval_069" VARCHAR,
  "posting_eval_070" DOUBLE,
  "waterway_eval_071" VARCHAR,
  "appr_road_eval_072" BIGINT,
  "work_proposed_075a" DOUBLE,
  "work_done_by_075b" DOUBLE,
  "imp_len_mt_076" DOUBLE,
  "date_of_inspect_090" DOUBLE,
  "inspect_freq_months_091" BIGINT,
  "fracture_092a" VARCHAR,
  "undwater_look_see_092b" VARCHAR,
  "spec_inspect_092c" VARCHAR,
  "fracture_last_date_093a" DOUBLE,
  "undwater_last_date_093b" DOUBLE,
  "spec_last_date_093c" DOUBLE,
  "bridge_imp_cost_094" DOUBLE,
  "roadway_imp_cost_095" DOUBLE,
  "total_imp_cost_096" DOUBLE,
  "year_of_imp_097" DOUBLE,
  "other_state_code_098a" VARCHAR,
  "other_state_pcnt_098b" DOUBLE,
  "othr_state_struc_no_099" VARCHAR
);