{"links":{"self":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/national-bridge-inventory-nbi/files/national-bridge-inventory-nbi","dataset":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/national-bridge-inventory-nbi","collection":"https://hifld.publicenvirodata.org/api/collections/hifld"},"collection":{"slug":"hifld","description":"HIFLD (Homeland Infrastructure Foundation-Level Data) datasets","id":1,"created_at":"2026-02-13T02:52:43.921817","updated_at":"2026-02-13T02:52:43.921841","name":"HIFLD"},"dataset":{"slug":"national-bridge-inventory-nbi","name":"National Bridge Inventory (NBI)","id":3182,"description":"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.","collection_id":1,"tags":{"inventory_name":"national-bridge-inventory-nbi","categories":["Transportation Ground"]},"created_at":"2026-02-15T06:52:04.807803","updated_at":"2026-02-15T06:52:04.807823"},"file":{"slug":"national-bridge-inventory-nbi","layer_name":null,"file_metadata":null,"updated_at":"2026-05-19T22:03:19.258081","id":4431,"name":"national-bridge-inventory-nbi","dataset_id":3182,"description":"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.","source_file_path":null,"created_at":"2026-05-19T22:03:19.258057","formats":[{"format":{"description":"ESRI File Geodatabase format for geospatial data storage","format_type":"file_geodatabase","created_at":"2026-02-15T03:18:57.882712","id":7,"name":"File Geodatabase","mime_type":"application/x-esri-shape","updated_at":"2026-02-15T03:18:57.882736"},"file_format":{"id":18465,"format_id":7,"created_at":"2026-05-19T22:03:19.463606","file_id":4431,"updated_at":"2026-05-19T22:03:19.463627"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T05:02:25.699278","id":19151,"file_format_id":18465,"created_at":"2026-05-19T22:03:19.636755","location":{"type":"file","version":"v1","path":"national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/file_geodatabase/national-bridge-inventory-nbi-file_geodatabase.zip"},"source_metadata":{"version":"v1","description":null,"size_bytes":84369265,"mime_type":null,"feature_count":624193,"bounds":[-174.182281,0,0,70.21645],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"65c1176fcadcbdb58626cc84f079d9a55d73557a805dc0dbe4e26de338b100e3","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"STATE_CODE_001","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02"]},{"name":"STRUCTURE_NUMBER_008","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0842","004024","005615","005203","1458"],"min":null,"max":null,"length":15,"possible_values":null},{"name":"RECORD_TYPE_005A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1"]},{"name":"ROUTE_PREFIX_005B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","4","3","4","3"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8"]},{"name":"SERVICE_LEVEL_005C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","7","8"]},{"name":"ROUTE_NUMBER_005D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00786","01009","00102","00026","00929"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"DIRECTION_005E","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"HIGHWAY_DISTRICT_002","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","05","10","02","03"],"min":null,"max":null,"length":2,"possible_values":["0","00","01","02","03","04","05","06","07","08","09","1","10","2","3","CN","N","SE"]},{"name":"COUNTY_CODE_003","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["240","119","057","083","198"],"min":null,"max":null,"length":3,"possible_values":null},{"name":"PLACE_CODE_004","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20380","90801","00000","92817","77140"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FEATURES_DESC_006A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AMERICAN CREEK NO 2","CO RT 1009 STREAM","North River","ELK RIVER","RIO BEAVER"],"min":null,"max":null,"length":24,"possible_values":null},{"name":"CRITICAL_FACILITY_006B","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FACILITY_CARRIED_007","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["TAYLOR HIGHWAY","ROADWAY","AL-102","ELK RIV MILLS RD*","THORNE BAY ROAD"],"min":null,"max":null,"length":18,"possible_values":null},{"name":"LOCATION_009","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["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"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"MIN_VERT_CLR_010","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"KILOPOINT_011","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["242.021","0.0","22.574","0.01","11.774"],"min":0,"max":1178.091,"length":null,"possible_values":null},{"name":"BASE_HWY_NETWORK_012","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","1","0","0"],"min":null,"max":null,"length":1,"possible_values":["","0","1"]},{"name":"LRS_INV_ROUTE_013A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0025000000","000CO10090","000AL01020","000CO00260",""],"min":null,"max":null,"length":10,"possible_values":null},{"name":"SUBROUTE_NO_013B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"LAT_016","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64415800","32252187","33481980","34505142","55411400"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"LONG_017","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["141185200","088221941","087350168","087070458","132434600"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"DETOUR_KILOS_019","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["199","21","23","26","199"],"min":0,"max":999,"length":null,"possible_values":null},{"name":"TOLL_020","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","3","3","3","3"],"min":null,"max":null,"length":1,"possible_values":["2","3"]},{"name":"MAINTENANCE_021","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","11","21","25","26","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"OWNER_022","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","04","11","21","25","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"FUNCTIONAL_CLASS_026","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["07","08","06","08","07"],"min":null,"max":null,"length":2,"possible_values":["01","02","06","07","08","09","11","12","14","16","17","19"]},{"name":"YEAR_BUILT_027","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1988","1951","1956","1955","1975"],"min":1898,"max":2024,"length":null,"possible_values":null},{"name":"TRAFFIC_LANES_ON_028A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"TRAFFIC_LANES_UND_028B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","8","9"]},{"name":"ADT_029","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20","1024","839","2380","190"],"min":0,"max":62647,"length":null,"possible_values":null},{"name":"YEAR_ADT_030","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2020","2020","2020","2010","2020"],"min":0,"max":2025,"length":null,"possible_values":null},{"name":"DESIGN_LOAD_031","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","2","2","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","9","A","B","C"]},{"name":"APPR_WIDTH_MT_032","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","10.4","9.4","7.3","8.8"],"min":0.6,"max":48.2,"length":null,"possible_values":null},{"name":"MEDIAN_CODE_033","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"DEGREES_SKEW_034","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","0","0","0","0"],"min":0,"max":99,"length":null,"possible_values":null},{"name":"STRUCTURE_FLARED_035","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"RAILINGS_036A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"TRANSITIONS_036B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_036C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_END_036D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"HISTORY_037","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5"]},{"name":"NAVIGATION_038","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"NAV_VERT_CLR_MT_039","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","8.2","0.0"],"min":0,"max":30.5,"length":null,"possible_values":null},{"name":"NAV_HORR_CLR_MT_040","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","36.6","0.0"],"min":0,"max":137.1,"length":null,"possible_values":null},{"name":"OPEN_CLOSED_POSTED_041","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["A","A","A","P","A"],"min":null,"max":null,"length":1,"possible_values":["A","B","D","E","G","K","P","R"]},{"name":"SERVICE_ON_042A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1","4","5","6"]},{"name":"SERVICE_UND_042B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_KIND_043A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","1","1","4","4"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_TYPE_043B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["04","04","19","02","03"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","07","08","09","10","11","12","14","19","21","22"]},{"name":"APPR_KIND_044A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7"]},{"name":"APPR_TYPE_044B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00","00","00","04","00"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","09","10","11","12","19","20","22"]},{"name":"MAIN_UNIT_SPANS_045","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","5","2","3","3"],"min":1,"max":200,"length":null,"possible_values":null},{"name":"APPR_SPANS_046","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","2","0"],"min":0,"max":1888,"length":null,"possible_values":null},{"name":"HORR_CLR_MT_047","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","6.6","10.7","6.6","7.2"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"MAX_SPAN_LEN_MT_048","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.2","11.0","3.0","39.9","38.4"],"min":0,"max":189,"length":null,"possible_values":null},{"name":"STRUCTURE_LEN_MT_049","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.5","54.9","6.4","154.8","46.0"],"min":6.1,"max":1981.2,"length":null,"possible_values":null},{"name":"LEFT_CURB_MT_050A","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"RIGHT_CURB_MT_050B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"ROADWAY_WIDTH_MT_051","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.6","6.6","0.0","6.6","7.3"],"min":0,"max":49.2,"length":null,"possible_values":null},{"name":"DECK_WIDTH_MT_052","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.9","7.7","0.0","7.3","7.4"],"min":0,"max":67.7,"length":null,"possible_values":null},{"name":"VERT_CLR_OVER_MT_053","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"VERT_CLR_UND_REF_054A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"VERT_CLR_UND_054B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"LAT_UND_REF_055A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"LAT_UND_MT_055B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.9","0.0","0.0","99.9","99.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"LEFT_LAT_UND_MT_056","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.8,"length":null,"possible_values":null},{"name":"DECK_COND_058","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","7","N","7","8"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUPERSTRUCTURE_COND_059","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","7","N","7","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUBSTRUCTURE_COND_060","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","N","5","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"CHANNEL_COND_061","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","5","7","6"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N"]},{"name":"CULVERT_COND_062","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","6","N","N"],"min":null,"max":null,"length":1,"possible_values":["3","4","5","6","7","8","9","N"]},{"name":"OPR_RATING_METH_063","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"OPERATING_RATING_064","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["42.3","63.2","99.9","99.9","88.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"INV_RATING_METH_065","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"INVENTORY_RATING_066","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["25.3","37.9","61.6","48.6","64.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"STRUCTURAL_EVAL_067","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","6","5","6"],"min":null,"max":null,"length":1,"possible_values":["*","0","2","3","4","5","6","7","8","9"]},{"name":"DECK_GEOMETRY_EVAL_068","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","2","N","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"UNDCLRENCE_EVAL_069","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"POSTING_EVAL_070","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","3","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5"]},{"name":"WATERWAY_EVAL_071","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","8","6","8","8"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"APPR_ROAD_EVAL_072","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","9","8","6","6"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9"]},{"name":"WORK_PROPOSED_075A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","35","","35",""],"min":null,"max":null,"length":2,"possible_values":["","31","33","34","35","36","38"]},{"name":"WORK_DONE_BY_075B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","1","","1",""],"min":null,"max":null,"length":1,"possible_values":["","1","2"]},{"name":"IMP_LEN_MT_076","type":"string","description":null,"nullable":true,"num_null_values":1148,"num_unique_values":null,"example_values":["19.7","20.5","215","18.4","12.6"],"min":null,"max":null,"length":6,"possible_values":null},{"name":"DATE_OF_INSPECT_090","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["723","424","1223","1024","723"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"INSPECT_FREQ_MONTHS_091","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["24","24","24","24","24"],"min":6,"max":48,"length":null,"possible_values":null},{"name":"FRACTURE_092A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","Y24"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24"]},{"name":"UNDWATER_LOOK_SEE_092B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y48","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y12","Y24","Y48","Y60"]},{"name":"SPEC_INSPECT_092C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y12","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24","Y48","Y60","Y99"]},{"name":"FRACTURE_LAST_DATE_093A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","","0523"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"UNDWATER_LAST_DATE_093B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","0922",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"SPEC_LAST_DATE_093C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","1024",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"BRIDGE_IMP_COST_094","type":"string","description":null,"nullable":true,"num_null_values":1441,"num_unique_values":null,"example_values":["1306","232","393","50","650"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"ROADWAY_IMP_COST_095","type":"string","description":null,"nullable":true,"num_null_values":1452,"num_unique_values":null,"example_values":["24","29","91","16","102"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"TOTAL_IMP_COST_096","type":"string","description":null,"nullable":true,"num_null_values":1451,"num_unique_values":null,"example_values":["529","1009","537","446","553"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"YEAR_OF_IMP_097","type":"string","description":null,"nullable":true,"num_null_values":1613,"num_unique_values":null,"example_values":["2025","2025","2025","2025","2025"],"min":null,"max":null,"length":4,"possible_values":["2017","2018","2019","2020","2021","2022","2023","2024","2025"]},{"name":"OTHER_STATE_CODE_098A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":3,"possible_values":["","020"]},{"name":"OTHER_STATE_PCNT_098B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"OTHR_STATE_STRUC_NO_099","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":4,"possible_values":["","2198","NO"]},{"name":"STRAHNET_HIGHWAY_100","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2"]},{"name":"PARALLEL_STRUCTURE_101","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["L","N","R"]},{"name":"TRAFFIC_DIRECTION_102","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"TEMP_STRUCTURE_103","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":1,"possible_values":["","T"]},{"name":"HIGHWAY_SYSTEM_104","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"FEDERAL_LANDS_105","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"YEAR_RECONSTRUCTED_106","type":"float","description":null,"nullable":true,"num_null_values":25,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","1992.0"],"min":0,"max":2024,"length":null,"possible_values":null},{"name":"DECK_STRUCTURE_TYPE_107","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","1","N","1","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","8","9","N"]},{"name":"SURFACE_TYPE_108A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","0","N","0","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","5","6","7","8","9","N"]},{"name":"MEMBRANE_TYPE_108B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","N","0","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","8","9","N"]},{"name":"DECK_PROTECTION_108C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","0","N","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","6","7","8","9","N"]},{"name":"PERCENT_ADT_TRUCK_109","type":"float","description":null,"nullable":true,"num_null_values":500,"num_unique_values":null,"example_values":["7.0","27.0","1.0","34.0","10.0"],"min":0,"max":90,"length":null,"possible_values":null},{"name":"NATIONAL_NETWORK_110","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"PIER_PROTECTION_111","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","","","1","1"],"min":null,"max":null,"length":1,"possible_values":["","1","2","3","4","5"]},{"name":"BRIDGE_LEN_IND_112","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"SCOUR_CRITICAL_113","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","8","8","5","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N","T","U"]},{"name":"FUTURE_ADT_114","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","1522","956","3540","230"],"min":0,"max":102654,"length":null,"possible_values":null},{"name":"YEAR_OF_FUTURE_ADT_115","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2039","2038","2040","2030","2039"],"min":100,"max":2045,"length":null,"possible_values":null},{"name":"MIN_NAV_CLR_MT_116","type":"float","description":null,"nullable":true,"num_null_values":198,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":30.4,"length":null,"possible_values":null},{"name":"FED_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"SUBMITTED_BY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02","61","62","63","64","66","67","68","70","72","74"]},{"name":"BRIDGE_CONDITION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["F","G","F","F","F"],"min":null,"max":null,"length":1,"possible_values":["F","G","P"]},{"name":"LOWEST_RATING","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","6","5","6"],"min":0,"max":9,"length":null,"possible_values":null},{"name":"DECK_AREA","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["298.15","422.73","60.16","1130.04","340.4"],"min":5.2,"max":22239.88,"length":null,"possible_values":null},{"name":"STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AM","ST","AM","ST","ST"],"min":null,"max":null,"length":2,"possible_values":["AM","MM","ST"]},{"name":"DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1202","0825","1202","0825","0825"],"min":null,"max":null,"length":4,"possible_values":["0203","0303","0403","0503","0825","1202"]},{"name":"LATDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64.703561","32.422742","33.805533","34.847617","55.687222"],"min":30.252947,"max":70.21645,"length":null,"possible_values":null},{"name":"LONGDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-141.312189","-88.372058","-87.583814","-87.117939","-132.729444"],"min":-174.182281,"max":-84.977219,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/file_geodatabase/national-bridge-inventory-nbi-file_geodatabase.zip","storage_uri":"gs://hifld-next-datasets-prod/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/file_geodatabase/national-bridge-inventory-nbi-file_geodatabase.zip","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/national-bridge-inventory-nbi/files/national-bridge-inventory-nbi/sources/19151/download-zip"}}]},{"format":{"description":"GeoJSON format for encoding geographic data structures","format_type":"geojson","created_at":"2026-02-15T03:18:57.713811","id":6,"name":"GeoJSON","mime_type":"application/geo+json","updated_at":"2026-02-15T03:18:57.713833"},"file_format":{"id":18466,"format_id":6,"created_at":"2026-05-19T22:03:19.954551","file_id":4431,"updated_at":"2026-05-19T22:03:19.954580"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T05:02:25.744400","id":19152,"file_format_id":18466,"created_at":"2026-05-19T22:03:20.126994","location":{"type":"file","version":"v1","path":"national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geojson/national-bridge-inventory-nbi-geojson.geojson"},"source_metadata":{"version":"v1","description":null,"size_bytes":2206493746,"mime_type":null,"feature_count":624193,"bounds":[-174.182281,0,0,70.21645],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"65c1176fcadcbdb58626cc84f079d9a55d73557a805dc0dbe4e26de338b100e3","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"STATE_CODE_001","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02"]},{"name":"STRUCTURE_NUMBER_008","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0842","004024","005615","005203","1458"],"min":null,"max":null,"length":15,"possible_values":null},{"name":"RECORD_TYPE_005A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1"]},{"name":"ROUTE_PREFIX_005B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","4","3","4","3"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8"]},{"name":"SERVICE_LEVEL_005C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","7","8"]},{"name":"ROUTE_NUMBER_005D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00786","01009","00102","00026","00929"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"DIRECTION_005E","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"HIGHWAY_DISTRICT_002","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","05","10","02","03"],"min":null,"max":null,"length":2,"possible_values":["0","00","01","02","03","04","05","06","07","08","09","1","10","2","3","CN","N","SE"]},{"name":"COUNTY_CODE_003","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["240","119","057","083","198"],"min":null,"max":null,"length":3,"possible_values":null},{"name":"PLACE_CODE_004","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20380","90801","00000","92817","77140"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FEATURES_DESC_006A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AMERICAN CREEK NO 2","CO RT 1009 STREAM","North River","ELK RIVER","RIO BEAVER"],"min":null,"max":null,"length":24,"possible_values":null},{"name":"CRITICAL_FACILITY_006B","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FACILITY_CARRIED_007","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["TAYLOR HIGHWAY","ROADWAY","AL-102","ELK RIV MILLS RD*","THORNE BAY ROAD"],"min":null,"max":null,"length":18,"possible_values":null},{"name":"LOCATION_009","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["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"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"MIN_VERT_CLR_010","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"KILOPOINT_011","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["242.021","0.0","22.574","0.01","11.774"],"min":0,"max":1178.091,"length":null,"possible_values":null},{"name":"BASE_HWY_NETWORK_012","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","1","0","0"],"min":null,"max":null,"length":1,"possible_values":["","0","1"]},{"name":"LRS_INV_ROUTE_013A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0025000000","000CO10090","000AL01020","000CO00260",""],"min":null,"max":null,"length":10,"possible_values":null},{"name":"SUBROUTE_NO_013B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"LAT_016","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64415800","32252187","33481980","34505142","55411400"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"LONG_017","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["141185200","088221941","087350168","087070458","132434600"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"DETOUR_KILOS_019","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["199","21","23","26","199"],"min":0,"max":999,"length":null,"possible_values":null},{"name":"TOLL_020","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","3","3","3","3"],"min":null,"max":null,"length":1,"possible_values":["2","3"]},{"name":"MAINTENANCE_021","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","11","21","25","26","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"OWNER_022","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","04","11","21","25","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"FUNCTIONAL_CLASS_026","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["07","08","06","08","07"],"min":null,"max":null,"length":2,"possible_values":["01","02","06","07","08","09","11","12","14","16","17","19"]},{"name":"YEAR_BUILT_027","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1988","1951","1956","1955","1975"],"min":1898,"max":2024,"length":null,"possible_values":null},{"name":"TRAFFIC_LANES_ON_028A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"TRAFFIC_LANES_UND_028B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","8","9"]},{"name":"ADT_029","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20","1024","839","2380","190"],"min":0,"max":62647,"length":null,"possible_values":null},{"name":"YEAR_ADT_030","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2020","2020","2020","2010","2020"],"min":0,"max":2025,"length":null,"possible_values":null},{"name":"DESIGN_LOAD_031","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","2","2","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","9","A","B","C"]},{"name":"APPR_WIDTH_MT_032","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","10.4","9.4","7.3","8.8"],"min":0.6,"max":48.2,"length":null,"possible_values":null},{"name":"MEDIAN_CODE_033","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"DEGREES_SKEW_034","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","0","0","0","0"],"min":0,"max":99,"length":null,"possible_values":null},{"name":"STRUCTURE_FLARED_035","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"RAILINGS_036A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"TRANSITIONS_036B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_036C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_END_036D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"HISTORY_037","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5"]},{"name":"NAVIGATION_038","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"NAV_VERT_CLR_MT_039","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","8.2","0.0"],"min":0,"max":30.5,"length":null,"possible_values":null},{"name":"NAV_HORR_CLR_MT_040","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","36.6","0.0"],"min":0,"max":137.1,"length":null,"possible_values":null},{"name":"OPEN_CLOSED_POSTED_041","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["A","A","A","P","A"],"min":null,"max":null,"length":1,"possible_values":["A","B","D","E","G","K","P","R"]},{"name":"SERVICE_ON_042A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1","4","5","6"]},{"name":"SERVICE_UND_042B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_KIND_043A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","1","1","4","4"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_TYPE_043B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["04","04","19","02","03"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","07","08","09","10","11","12","14","19","21","22"]},{"name":"APPR_KIND_044A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7"]},{"name":"APPR_TYPE_044B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00","00","00","04","00"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","09","10","11","12","19","20","22"]},{"name":"MAIN_UNIT_SPANS_045","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","5","2","3","3"],"min":1,"max":200,"length":null,"possible_values":null},{"name":"APPR_SPANS_046","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","2","0"],"min":0,"max":1888,"length":null,"possible_values":null},{"name":"HORR_CLR_MT_047","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","6.6","10.7","6.6","7.2"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"MAX_SPAN_LEN_MT_048","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.2","11.0","3.0","39.9","38.4"],"min":0,"max":189,"length":null,"possible_values":null},{"name":"STRUCTURE_LEN_MT_049","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.5","54.9","6.4","154.8","46.0"],"min":6.1,"max":1981.2,"length":null,"possible_values":null},{"name":"LEFT_CURB_MT_050A","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"RIGHT_CURB_MT_050B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"ROADWAY_WIDTH_MT_051","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.6","6.6","0.0","6.6","7.3"],"min":0,"max":49.2,"length":null,"possible_values":null},{"name":"DECK_WIDTH_MT_052","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.9","7.7","0.0","7.3","7.4"],"min":0,"max":67.7,"length":null,"possible_values":null},{"name":"VERT_CLR_OVER_MT_053","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"VERT_CLR_UND_REF_054A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"VERT_CLR_UND_054B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"LAT_UND_REF_055A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"LAT_UND_MT_055B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.9","0.0","0.0","99.9","99.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"LEFT_LAT_UND_MT_056","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.8,"length":null,"possible_values":null},{"name":"DECK_COND_058","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","7","N","7","8"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUPERSTRUCTURE_COND_059","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","7","N","7","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUBSTRUCTURE_COND_060","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","N","5","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"CHANNEL_COND_061","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","5","7","6"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N"]},{"name":"CULVERT_COND_062","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","6","N","N"],"min":null,"max":null,"length":1,"possible_values":["3","4","5","6","7","8","9","N"]},{"name":"OPR_RATING_METH_063","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"OPERATING_RATING_064","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["42.3","63.2","99.9","99.9","88.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"INV_RATING_METH_065","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"INVENTORY_RATING_066","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["25.3","37.9","61.6","48.6","64.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"STRUCTURAL_EVAL_067","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","6","5","6"],"min":null,"max":null,"length":1,"possible_values":["*","0","2","3","4","5","6","7","8","9"]},{"name":"DECK_GEOMETRY_EVAL_068","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","2","N","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"UNDCLRENCE_EVAL_069","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"POSTING_EVAL_070","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","3","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5"]},{"name":"WATERWAY_EVAL_071","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","8","6","8","8"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"APPR_ROAD_EVAL_072","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","9","8","6","6"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9"]},{"name":"WORK_PROPOSED_075A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","35","","35",""],"min":null,"max":null,"length":2,"possible_values":["","31","33","34","35","36","38"]},{"name":"WORK_DONE_BY_075B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","1","","1",""],"min":null,"max":null,"length":1,"possible_values":["","1","2"]},{"name":"IMP_LEN_MT_076","type":"string","description":null,"nullable":true,"num_null_values":1148,"num_unique_values":null,"example_values":["19.7","20.5","215","18.4","12.6"],"min":null,"max":null,"length":6,"possible_values":null},{"name":"DATE_OF_INSPECT_090","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["723","424","1223","1024","723"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"INSPECT_FREQ_MONTHS_091","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["24","24","24","24","24"],"min":6,"max":48,"length":null,"possible_values":null},{"name":"FRACTURE_092A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","Y24"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24"]},{"name":"UNDWATER_LOOK_SEE_092B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y48","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y12","Y24","Y48","Y60"]},{"name":"SPEC_INSPECT_092C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y12","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24","Y48","Y60","Y99"]},{"name":"FRACTURE_LAST_DATE_093A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","","0523"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"UNDWATER_LAST_DATE_093B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","0922",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"SPEC_LAST_DATE_093C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","1024",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"BRIDGE_IMP_COST_094","type":"string","description":null,"nullable":true,"num_null_values":1441,"num_unique_values":null,"example_values":["1306","232","393","50","650"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"ROADWAY_IMP_COST_095","type":"string","description":null,"nullable":true,"num_null_values":1452,"num_unique_values":null,"example_values":["24","29","91","16","102"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"TOTAL_IMP_COST_096","type":"string","description":null,"nullable":true,"num_null_values":1451,"num_unique_values":null,"example_values":["529","1009","537","446","553"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"YEAR_OF_IMP_097","type":"string","description":null,"nullable":true,"num_null_values":1613,"num_unique_values":null,"example_values":["2025","2025","2025","2025","2025"],"min":null,"max":null,"length":4,"possible_values":["2017","2018","2019","2020","2021","2022","2023","2024","2025"]},{"name":"OTHER_STATE_CODE_098A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":3,"possible_values":["","020"]},{"name":"OTHER_STATE_PCNT_098B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"OTHR_STATE_STRUC_NO_099","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":4,"possible_values":["","2198","NO"]},{"name":"STRAHNET_HIGHWAY_100","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2"]},{"name":"PARALLEL_STRUCTURE_101","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["L","N","R"]},{"name":"TRAFFIC_DIRECTION_102","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"TEMP_STRUCTURE_103","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":1,"possible_values":["","T"]},{"name":"HIGHWAY_SYSTEM_104","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"FEDERAL_LANDS_105","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"YEAR_RECONSTRUCTED_106","type":"float","description":null,"nullable":true,"num_null_values":25,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","1992.0"],"min":0,"max":2024,"length":null,"possible_values":null},{"name":"DECK_STRUCTURE_TYPE_107","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","1","N","1","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","8","9","N"]},{"name":"SURFACE_TYPE_108A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","0","N","0","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","5","6","7","8","9","N"]},{"name":"MEMBRANE_TYPE_108B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","N","0","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","8","9","N"]},{"name":"DECK_PROTECTION_108C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","0","N","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","6","7","8","9","N"]},{"name":"PERCENT_ADT_TRUCK_109","type":"float","description":null,"nullable":true,"num_null_values":500,"num_unique_values":null,"example_values":["7.0","27.0","1.0","34.0","10.0"],"min":0,"max":90,"length":null,"possible_values":null},{"name":"NATIONAL_NETWORK_110","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"PIER_PROTECTION_111","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","","","1","1"],"min":null,"max":null,"length":1,"possible_values":["","1","2","3","4","5"]},{"name":"BRIDGE_LEN_IND_112","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"SCOUR_CRITICAL_113","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","8","8","5","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N","T","U"]},{"name":"FUTURE_ADT_114","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","1522","956","3540","230"],"min":0,"max":102654,"length":null,"possible_values":null},{"name":"YEAR_OF_FUTURE_ADT_115","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2039","2038","2040","2030","2039"],"min":100,"max":2045,"length":null,"possible_values":null},{"name":"MIN_NAV_CLR_MT_116","type":"float","description":null,"nullable":true,"num_null_values":198,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":30.4,"length":null,"possible_values":null},{"name":"FED_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"SUBMITTED_BY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02","61","62","63","64","66","67","68","70","72","74"]},{"name":"BRIDGE_CONDITION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["F","G","F","F","F"],"min":null,"max":null,"length":1,"possible_values":["F","G","P"]},{"name":"LOWEST_RATING","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","6","5","6"],"min":0,"max":9,"length":null,"possible_values":null},{"name":"DECK_AREA","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["298.15","422.73","60.16","1130.04","340.4"],"min":5.2,"max":22239.88,"length":null,"possible_values":null},{"name":"STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AM","ST","AM","ST","ST"],"min":null,"max":null,"length":2,"possible_values":["AM","MM","ST"]},{"name":"DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1202","0825","1202","0825","0825"],"min":null,"max":null,"length":4,"possible_values":["0203","0303","0403","0503","0825","1202"]},{"name":"LATDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64.703561","32.422742","33.805533","34.847617","55.687222"],"min":30.252947,"max":70.21645,"length":null,"possible_values":null},{"name":"LONGDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-141.312189","-88.372058","-87.583814","-87.117939","-132.729444"],"min":-174.182281,"max":-84.977219,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geojson/national-bridge-inventory-nbi-geojson.geojson","storage_uri":"gs://hifld-next-datasets-prod/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geojson/national-bridge-inventory-nbi-geojson.geojson","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/national-bridge-inventory-nbi/files/national-bridge-inventory-nbi/sources/19152/download-zip"}}]},{"format":{"description":"GeoPackage format for geospatial data storage and exchange","format_type":"geopackage","created_at":"2026-02-15T03:18:57.332771","id":4,"name":"GeoPackage","mime_type":"application/geopackage+sqlite3","updated_at":"2026-02-15T03:18:57.332796"},"file_format":{"id":18467,"format_id":4,"created_at":"2026-05-19T22:03:20.389551","file_id":4431,"updated_at":"2026-05-19T22:03:20.389579"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T05:02:25.798956","id":19153,"file_format_id":18467,"created_at":"2026-05-19T22:03:20.561174","location":{"type":"file","version":"v1","path":"national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geopackage/national-bridge-inventory-nbi-geopackage.gpkg"},"source_metadata":{"version":"v1","description":null,"size_bytes":347340800,"mime_type":null,"feature_count":624193,"bounds":[-174.182281,0,0,70.21645],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"65c1176fcadcbdb58626cc84f079d9a55d73557a805dc0dbe4e26de338b100e3","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"STATE_CODE_001","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02"]},{"name":"STRUCTURE_NUMBER_008","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0842","004024","005615","005203","1458"],"min":null,"max":null,"length":15,"possible_values":null},{"name":"RECORD_TYPE_005A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1"]},{"name":"ROUTE_PREFIX_005B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","4","3","4","3"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8"]},{"name":"SERVICE_LEVEL_005C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","7","8"]},{"name":"ROUTE_NUMBER_005D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00786","01009","00102","00026","00929"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"DIRECTION_005E","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"HIGHWAY_DISTRICT_002","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","05","10","02","03"],"min":null,"max":null,"length":2,"possible_values":["0","00","01","02","03","04","05","06","07","08","09","1","10","2","3","CN","N","SE"]},{"name":"COUNTY_CODE_003","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["240","119","057","083","198"],"min":null,"max":null,"length":3,"possible_values":null},{"name":"PLACE_CODE_004","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20380","90801","00000","92817","77140"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FEATURES_DESC_006A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AMERICAN CREEK NO 2","CO RT 1009 STREAM","North River","ELK RIVER","RIO BEAVER"],"min":null,"max":null,"length":24,"possible_values":null},{"name":"CRITICAL_FACILITY_006B","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FACILITY_CARRIED_007","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["TAYLOR HIGHWAY","ROADWAY","AL-102","ELK RIV MILLS RD*","THORNE BAY ROAD"],"min":null,"max":null,"length":18,"possible_values":null},{"name":"LOCATION_009","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["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"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"MIN_VERT_CLR_010","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"KILOPOINT_011","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["242.021","0.0","22.574","0.01","11.774"],"min":0,"max":1178.091,"length":null,"possible_values":null},{"name":"BASE_HWY_NETWORK_012","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","1","0","0"],"min":null,"max":null,"length":1,"possible_values":["","0","1"]},{"name":"LRS_INV_ROUTE_013A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0025000000","000CO10090","000AL01020","000CO00260",""],"min":null,"max":null,"length":10,"possible_values":null},{"name":"SUBROUTE_NO_013B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"LAT_016","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64415800","32252187","33481980","34505142","55411400"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"LONG_017","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["141185200","088221941","087350168","087070458","132434600"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"DETOUR_KILOS_019","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["199","21","23","26","199"],"min":0,"max":999,"length":null,"possible_values":null},{"name":"TOLL_020","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","3","3","3","3"],"min":null,"max":null,"length":1,"possible_values":["2","3"]},{"name":"MAINTENANCE_021","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","11","21","25","26","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"OWNER_022","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","04","11","21","25","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"FUNCTIONAL_CLASS_026","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["07","08","06","08","07"],"min":null,"max":null,"length":2,"possible_values":["01","02","06","07","08","09","11","12","14","16","17","19"]},{"name":"YEAR_BUILT_027","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1988","1951","1956","1955","1975"],"min":1898,"max":2024,"length":null,"possible_values":null},{"name":"TRAFFIC_LANES_ON_028A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"TRAFFIC_LANES_UND_028B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","8","9"]},{"name":"ADT_029","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20","1024","839","2380","190"],"min":0,"max":62647,"length":null,"possible_values":null},{"name":"YEAR_ADT_030","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2020","2020","2020","2010","2020"],"min":0,"max":2025,"length":null,"possible_values":null},{"name":"DESIGN_LOAD_031","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","2","2","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","9","A","B","C"]},{"name":"APPR_WIDTH_MT_032","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","10.4","9.4","7.3","8.8"],"min":0.6,"max":48.2,"length":null,"possible_values":null},{"name":"MEDIAN_CODE_033","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"DEGREES_SKEW_034","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","0","0","0","0"],"min":0,"max":99,"length":null,"possible_values":null},{"name":"STRUCTURE_FLARED_035","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"RAILINGS_036A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"TRANSITIONS_036B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_036C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_END_036D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"HISTORY_037","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5"]},{"name":"NAVIGATION_038","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"NAV_VERT_CLR_MT_039","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","8.2","0.0"],"min":0,"max":30.5,"length":null,"possible_values":null},{"name":"NAV_HORR_CLR_MT_040","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","36.6","0.0"],"min":0,"max":137.1,"length":null,"possible_values":null},{"name":"OPEN_CLOSED_POSTED_041","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["A","A","A","P","A"],"min":null,"max":null,"length":1,"possible_values":["A","B","D","E","G","K","P","R"]},{"name":"SERVICE_ON_042A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1","4","5","6"]},{"name":"SERVICE_UND_042B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_KIND_043A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","1","1","4","4"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_TYPE_043B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["04","04","19","02","03"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","07","08","09","10","11","12","14","19","21","22"]},{"name":"APPR_KIND_044A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7"]},{"name":"APPR_TYPE_044B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00","00","00","04","00"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","09","10","11","12","19","20","22"]},{"name":"MAIN_UNIT_SPANS_045","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","5","2","3","3"],"min":1,"max":200,"length":null,"possible_values":null},{"name":"APPR_SPANS_046","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","2","0"],"min":0,"max":1888,"length":null,"possible_values":null},{"name":"HORR_CLR_MT_047","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","6.6","10.7","6.6","7.2"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"MAX_SPAN_LEN_MT_048","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.2","11.0","3.0","39.9","38.4"],"min":0,"max":189,"length":null,"possible_values":null},{"name":"STRUCTURE_LEN_MT_049","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.5","54.9","6.4","154.8","46.0"],"min":6.1,"max":1981.2,"length":null,"possible_values":null},{"name":"LEFT_CURB_MT_050A","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"RIGHT_CURB_MT_050B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"ROADWAY_WIDTH_MT_051","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.6","6.6","0.0","6.6","7.3"],"min":0,"max":49.2,"length":null,"possible_values":null},{"name":"DECK_WIDTH_MT_052","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.9","7.7","0.0","7.3","7.4"],"min":0,"max":67.7,"length":null,"possible_values":null},{"name":"VERT_CLR_OVER_MT_053","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"VERT_CLR_UND_REF_054A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"VERT_CLR_UND_054B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"LAT_UND_REF_055A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"LAT_UND_MT_055B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.9","0.0","0.0","99.9","99.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"LEFT_LAT_UND_MT_056","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.8,"length":null,"possible_values":null},{"name":"DECK_COND_058","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","7","N","7","8"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUPERSTRUCTURE_COND_059","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","7","N","7","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUBSTRUCTURE_COND_060","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","N","5","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"CHANNEL_COND_061","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","5","7","6"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N"]},{"name":"CULVERT_COND_062","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","6","N","N"],"min":null,"max":null,"length":1,"possible_values":["3","4","5","6","7","8","9","N"]},{"name":"OPR_RATING_METH_063","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"OPERATING_RATING_064","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["42.3","63.2","99.9","99.9","88.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"INV_RATING_METH_065","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"INVENTORY_RATING_066","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["25.3","37.9","61.6","48.6","64.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"STRUCTURAL_EVAL_067","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","6","5","6"],"min":null,"max":null,"length":1,"possible_values":["*","0","2","3","4","5","6","7","8","9"]},{"name":"DECK_GEOMETRY_EVAL_068","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","2","N","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"UNDCLRENCE_EVAL_069","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"POSTING_EVAL_070","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","3","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5"]},{"name":"WATERWAY_EVAL_071","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","8","6","8","8"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"APPR_ROAD_EVAL_072","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","9","8","6","6"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9"]},{"name":"WORK_PROPOSED_075A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","35","","35",""],"min":null,"max":null,"length":2,"possible_values":["","31","33","34","35","36","38"]},{"name":"WORK_DONE_BY_075B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","1","","1",""],"min":null,"max":null,"length":1,"possible_values":["","1","2"]},{"name":"IMP_LEN_MT_076","type":"string","description":null,"nullable":true,"num_null_values":1148,"num_unique_values":null,"example_values":["19.7","20.5","215","18.4","12.6"],"min":null,"max":null,"length":6,"possible_values":null},{"name":"DATE_OF_INSPECT_090","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["723","424","1223","1024","723"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"INSPECT_FREQ_MONTHS_091","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["24","24","24","24","24"],"min":6,"max":48,"length":null,"possible_values":null},{"name":"FRACTURE_092A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","Y24"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24"]},{"name":"UNDWATER_LOOK_SEE_092B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y48","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y12","Y24","Y48","Y60"]},{"name":"SPEC_INSPECT_092C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y12","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24","Y48","Y60","Y99"]},{"name":"FRACTURE_LAST_DATE_093A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","","0523"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"UNDWATER_LAST_DATE_093B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","0922",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"SPEC_LAST_DATE_093C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","1024",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"BRIDGE_IMP_COST_094","type":"string","description":null,"nullable":true,"num_null_values":1441,"num_unique_values":null,"example_values":["1306","232","393","50","650"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"ROADWAY_IMP_COST_095","type":"string","description":null,"nullable":true,"num_null_values":1452,"num_unique_values":null,"example_values":["24","29","91","16","102"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"TOTAL_IMP_COST_096","type":"string","description":null,"nullable":true,"num_null_values":1451,"num_unique_values":null,"example_values":["529","1009","537","446","553"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"YEAR_OF_IMP_097","type":"string","description":null,"nullable":true,"num_null_values":1613,"num_unique_values":null,"example_values":["2025","2025","2025","2025","2025"],"min":null,"max":null,"length":4,"possible_values":["2017","2018","2019","2020","2021","2022","2023","2024","2025"]},{"name":"OTHER_STATE_CODE_098A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":3,"possible_values":["","020"]},{"name":"OTHER_STATE_PCNT_098B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"OTHR_STATE_STRUC_NO_099","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":4,"possible_values":["","2198","NO"]},{"name":"STRAHNET_HIGHWAY_100","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2"]},{"name":"PARALLEL_STRUCTURE_101","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["L","N","R"]},{"name":"TRAFFIC_DIRECTION_102","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"TEMP_STRUCTURE_103","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":1,"possible_values":["","T"]},{"name":"HIGHWAY_SYSTEM_104","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"FEDERAL_LANDS_105","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"YEAR_RECONSTRUCTED_106","type":"float","description":null,"nullable":true,"num_null_values":25,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","1992.0"],"min":0,"max":2024,"length":null,"possible_values":null},{"name":"DECK_STRUCTURE_TYPE_107","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","1","N","1","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","8","9","N"]},{"name":"SURFACE_TYPE_108A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","0","N","0","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","5","6","7","8","9","N"]},{"name":"MEMBRANE_TYPE_108B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","N","0","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","8","9","N"]},{"name":"DECK_PROTECTION_108C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","0","N","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","6","7","8","9","N"]},{"name":"PERCENT_ADT_TRUCK_109","type":"float","description":null,"nullable":true,"num_null_values":500,"num_unique_values":null,"example_values":["7.0","27.0","1.0","34.0","10.0"],"min":0,"max":90,"length":null,"possible_values":null},{"name":"NATIONAL_NETWORK_110","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"PIER_PROTECTION_111","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","","","1","1"],"min":null,"max":null,"length":1,"possible_values":["","1","2","3","4","5"]},{"name":"BRIDGE_LEN_IND_112","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"SCOUR_CRITICAL_113","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","8","8","5","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N","T","U"]},{"name":"FUTURE_ADT_114","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","1522","956","3540","230"],"min":0,"max":102654,"length":null,"possible_values":null},{"name":"YEAR_OF_FUTURE_ADT_115","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2039","2038","2040","2030","2039"],"min":100,"max":2045,"length":null,"possible_values":null},{"name":"MIN_NAV_CLR_MT_116","type":"float","description":null,"nullable":true,"num_null_values":198,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":30.4,"length":null,"possible_values":null},{"name":"FED_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"SUBMITTED_BY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02","61","62","63","64","66","67","68","70","72","74"]},{"name":"BRIDGE_CONDITION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["F","G","F","F","F"],"min":null,"max":null,"length":1,"possible_values":["F","G","P"]},{"name":"LOWEST_RATING","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","6","5","6"],"min":0,"max":9,"length":null,"possible_values":null},{"name":"DECK_AREA","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["298.15","422.73","60.16","1130.04","340.4"],"min":5.2,"max":22239.88,"length":null,"possible_values":null},{"name":"STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AM","ST","AM","ST","ST"],"min":null,"max":null,"length":2,"possible_values":["AM","MM","ST"]},{"name":"DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1202","0825","1202","0825","0825"],"min":null,"max":null,"length":4,"possible_values":["0203","0303","0403","0503","0825","1202"]},{"name":"LATDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64.703561","32.422742","33.805533","34.847617","55.687222"],"min":30.252947,"max":70.21645,"length":null,"possible_values":null},{"name":"LONGDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-141.312189","-88.372058","-87.583814","-87.117939","-132.729444"],"min":-174.182281,"max":-84.977219,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geopackage/national-bridge-inventory-nbi-geopackage.gpkg","storage_uri":"gs://hifld-next-datasets-prod/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geopackage/national-bridge-inventory-nbi-geopackage.gpkg","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/national-bridge-inventory-nbi/files/national-bridge-inventory-nbi/sources/19153/download-zip"}}]},{"format":{"description":"GeoParquet format for efficient spatial data storage and analysis","format_type":"geoparquet","created_at":"2026-02-13T02:36:11.179416","id":1,"name":"GeoParquet","mime_type":"application/parquet","updated_at":"2026-02-13T02:36:11.179441"},"file_format":{"id":18468,"format_id":1,"created_at":"2026-05-19T22:03:20.824627","file_id":4431,"updated_at":"2026-05-19T22:03:20.824649"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T05:02:25.859867","id":19154,"file_format_id":18468,"created_at":"2026-05-19T22:03:20.998275","location":{"type":"file","version":"v1","path":"national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geoparquet/national-bridge-inventory-nbi.parquet"},"source_metadata":{"version":"v1","description":null,"size_bytes":73028021,"mime_type":null,"feature_count":624193,"bounds":[-174.182281,0,0,70.21645],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"65c1176fcadcbdb58626cc84f079d9a55d73557a805dc0dbe4e26de338b100e3","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"STATE_CODE_001","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02"]},{"name":"STRUCTURE_NUMBER_008","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0842","004024","005615","005203","1458"],"min":null,"max":null,"length":15,"possible_values":null},{"name":"RECORD_TYPE_005A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1"]},{"name":"ROUTE_PREFIX_005B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","4","3","4","3"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8"]},{"name":"SERVICE_LEVEL_005C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","7","8"]},{"name":"ROUTE_NUMBER_005D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00786","01009","00102","00026","00929"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"DIRECTION_005E","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"HIGHWAY_DISTRICT_002","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","05","10","02","03"],"min":null,"max":null,"length":2,"possible_values":["0","00","01","02","03","04","05","06","07","08","09","1","10","2","3","CN","N","SE"]},{"name":"COUNTY_CODE_003","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["240","119","057","083","198"],"min":null,"max":null,"length":3,"possible_values":null},{"name":"PLACE_CODE_004","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20380","90801","00000","92817","77140"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FEATURES_DESC_006A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AMERICAN CREEK NO 2","CO RT 1009 STREAM","North River","ELK RIVER","RIO BEAVER"],"min":null,"max":null,"length":24,"possible_values":null},{"name":"CRITICAL_FACILITY_006B","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FACILITY_CARRIED_007","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["TAYLOR HIGHWAY","ROADWAY","AL-102","ELK RIV MILLS RD*","THORNE BAY ROAD"],"min":null,"max":null,"length":18,"possible_values":null},{"name":"LOCATION_009","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["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"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"MIN_VERT_CLR_010","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"KILOPOINT_011","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["242.021","0.0","22.574","0.01","11.774"],"min":0,"max":1178.091,"length":null,"possible_values":null},{"name":"BASE_HWY_NETWORK_012","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","1","0","0"],"min":null,"max":null,"length":1,"possible_values":["","0","1"]},{"name":"LRS_INV_ROUTE_013A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0025000000","000CO10090","000AL01020","000CO00260",""],"min":null,"max":null,"length":10,"possible_values":null},{"name":"SUBROUTE_NO_013B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"LAT_016","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64415800","32252187","33481980","34505142","55411400"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"LONG_017","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["141185200","088221941","087350168","087070458","132434600"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"DETOUR_KILOS_019","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["199","21","23","26","199"],"min":0,"max":999,"length":null,"possible_values":null},{"name":"TOLL_020","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","3","3","3","3"],"min":null,"max":null,"length":1,"possible_values":["2","3"]},{"name":"MAINTENANCE_021","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","11","21","25","26","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"OWNER_022","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","04","11","21","25","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"FUNCTIONAL_CLASS_026","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["07","08","06","08","07"],"min":null,"max":null,"length":2,"possible_values":["01","02","06","07","08","09","11","12","14","16","17","19"]},{"name":"YEAR_BUILT_027","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1988","1951","1956","1955","1975"],"min":1898,"max":2024,"length":null,"possible_values":null},{"name":"TRAFFIC_LANES_ON_028A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"TRAFFIC_LANES_UND_028B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","8","9"]},{"name":"ADT_029","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20","1024","839","2380","190"],"min":0,"max":62647,"length":null,"possible_values":null},{"name":"YEAR_ADT_030","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2020","2020","2020","2010","2020"],"min":0,"max":2025,"length":null,"possible_values":null},{"name":"DESIGN_LOAD_031","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","2","2","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","9","A","B","C"]},{"name":"APPR_WIDTH_MT_032","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","10.4","9.4","7.3","8.8"],"min":0.6,"max":48.2,"length":null,"possible_values":null},{"name":"MEDIAN_CODE_033","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"DEGREES_SKEW_034","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","0","0","0","0"],"min":0,"max":99,"length":null,"possible_values":null},{"name":"STRUCTURE_FLARED_035","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"RAILINGS_036A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"TRANSITIONS_036B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_036C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_END_036D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"HISTORY_037","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5"]},{"name":"NAVIGATION_038","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"NAV_VERT_CLR_MT_039","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","8.2","0.0"],"min":0,"max":30.5,"length":null,"possible_values":null},{"name":"NAV_HORR_CLR_MT_040","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","36.6","0.0"],"min":0,"max":137.1,"length":null,"possible_values":null},{"name":"OPEN_CLOSED_POSTED_041","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["A","A","A","P","A"],"min":null,"max":null,"length":1,"possible_values":["A","B","D","E","G","K","P","R"]},{"name":"SERVICE_ON_042A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1","4","5","6"]},{"name":"SERVICE_UND_042B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_KIND_043A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","1","1","4","4"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_TYPE_043B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["04","04","19","02","03"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","07","08","09","10","11","12","14","19","21","22"]},{"name":"APPR_KIND_044A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7"]},{"name":"APPR_TYPE_044B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00","00","00","04","00"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","09","10","11","12","19","20","22"]},{"name":"MAIN_UNIT_SPANS_045","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","5","2","3","3"],"min":1,"max":200,"length":null,"possible_values":null},{"name":"APPR_SPANS_046","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","2","0"],"min":0,"max":1888,"length":null,"possible_values":null},{"name":"HORR_CLR_MT_047","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","6.6","10.7","6.6","7.2"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"MAX_SPAN_LEN_MT_048","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.2","11.0","3.0","39.9","38.4"],"min":0,"max":189,"length":null,"possible_values":null},{"name":"STRUCTURE_LEN_MT_049","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.5","54.9","6.4","154.8","46.0"],"min":6.1,"max":1981.2,"length":null,"possible_values":null},{"name":"LEFT_CURB_MT_050A","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"RIGHT_CURB_MT_050B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"ROADWAY_WIDTH_MT_051","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.6","6.6","0.0","6.6","7.3"],"min":0,"max":49.2,"length":null,"possible_values":null},{"name":"DECK_WIDTH_MT_052","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.9","7.7","0.0","7.3","7.4"],"min":0,"max":67.7,"length":null,"possible_values":null},{"name":"VERT_CLR_OVER_MT_053","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"VERT_CLR_UND_REF_054A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"VERT_CLR_UND_054B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"LAT_UND_REF_055A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"LAT_UND_MT_055B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.9","0.0","0.0","99.9","99.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"LEFT_LAT_UND_MT_056","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.8,"length":null,"possible_values":null},{"name":"DECK_COND_058","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","7","N","7","8"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUPERSTRUCTURE_COND_059","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","7","N","7","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUBSTRUCTURE_COND_060","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","N","5","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"CHANNEL_COND_061","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","5","7","6"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N"]},{"name":"CULVERT_COND_062","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","6","N","N"],"min":null,"max":null,"length":1,"possible_values":["3","4","5","6","7","8","9","N"]},{"name":"OPR_RATING_METH_063","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"OPERATING_RATING_064","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["42.3","63.2","99.9","99.9","88.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"INV_RATING_METH_065","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"INVENTORY_RATING_066","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["25.3","37.9","61.6","48.6","64.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"STRUCTURAL_EVAL_067","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","6","5","6"],"min":null,"max":null,"length":1,"possible_values":["*","0","2","3","4","5","6","7","8","9"]},{"name":"DECK_GEOMETRY_EVAL_068","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","2","N","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"UNDCLRENCE_EVAL_069","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"POSTING_EVAL_070","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","3","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5"]},{"name":"WATERWAY_EVAL_071","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","8","6","8","8"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"APPR_ROAD_EVAL_072","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","9","8","6","6"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9"]},{"name":"WORK_PROPOSED_075A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","35","","35",""],"min":null,"max":null,"length":2,"possible_values":["","31","33","34","35","36","38"]},{"name":"WORK_DONE_BY_075B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","1","","1",""],"min":null,"max":null,"length":1,"possible_values":["","1","2"]},{"name":"IMP_LEN_MT_076","type":"string","description":null,"nullable":true,"num_null_values":1148,"num_unique_values":null,"example_values":["19.7","20.5","215","18.4","12.6"],"min":null,"max":null,"length":6,"possible_values":null},{"name":"DATE_OF_INSPECT_090","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["723","424","1223","1024","723"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"INSPECT_FREQ_MONTHS_091","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["24","24","24","24","24"],"min":6,"max":48,"length":null,"possible_values":null},{"name":"FRACTURE_092A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","Y24"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24"]},{"name":"UNDWATER_LOOK_SEE_092B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y48","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y12","Y24","Y48","Y60"]},{"name":"SPEC_INSPECT_092C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y12","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24","Y48","Y60","Y99"]},{"name":"FRACTURE_LAST_DATE_093A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","","0523"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"UNDWATER_LAST_DATE_093B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","0922",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"SPEC_LAST_DATE_093C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","1024",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"BRIDGE_IMP_COST_094","type":"string","description":null,"nullable":true,"num_null_values":1441,"num_unique_values":null,"example_values":["1306","232","393","50","650"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"ROADWAY_IMP_COST_095","type":"string","description":null,"nullable":true,"num_null_values":1452,"num_unique_values":null,"example_values":["24","29","91","16","102"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"TOTAL_IMP_COST_096","type":"string","description":null,"nullable":true,"num_null_values":1451,"num_unique_values":null,"example_values":["529","1009","537","446","553"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"YEAR_OF_IMP_097","type":"string","description":null,"nullable":true,"num_null_values":1613,"num_unique_values":null,"example_values":["2025","2025","2025","2025","2025"],"min":null,"max":null,"length":4,"possible_values":["2017","2018","2019","2020","2021","2022","2023","2024","2025"]},{"name":"OTHER_STATE_CODE_098A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":3,"possible_values":["","020"]},{"name":"OTHER_STATE_PCNT_098B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"OTHR_STATE_STRUC_NO_099","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":4,"possible_values":["","2198","NO"]},{"name":"STRAHNET_HIGHWAY_100","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2"]},{"name":"PARALLEL_STRUCTURE_101","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["L","N","R"]},{"name":"TRAFFIC_DIRECTION_102","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"TEMP_STRUCTURE_103","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":1,"possible_values":["","T"]},{"name":"HIGHWAY_SYSTEM_104","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"FEDERAL_LANDS_105","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"YEAR_RECONSTRUCTED_106","type":"float","description":null,"nullable":true,"num_null_values":25,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","1992.0"],"min":0,"max":2024,"length":null,"possible_values":null},{"name":"DECK_STRUCTURE_TYPE_107","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","1","N","1","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","8","9","N"]},{"name":"SURFACE_TYPE_108A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","0","N","0","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","5","6","7","8","9","N"]},{"name":"MEMBRANE_TYPE_108B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","N","0","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","8","9","N"]},{"name":"DECK_PROTECTION_108C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","0","N","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","6","7","8","9","N"]},{"name":"PERCENT_ADT_TRUCK_109","type":"float","description":null,"nullable":true,"num_null_values":500,"num_unique_values":null,"example_values":["7.0","27.0","1.0","34.0","10.0"],"min":0,"max":90,"length":null,"possible_values":null},{"name":"NATIONAL_NETWORK_110","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"PIER_PROTECTION_111","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","","","1","1"],"min":null,"max":null,"length":1,"possible_values":["","1","2","3","4","5"]},{"name":"BRIDGE_LEN_IND_112","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"SCOUR_CRITICAL_113","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","8","8","5","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N","T","U"]},{"name":"FUTURE_ADT_114","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","1522","956","3540","230"],"min":0,"max":102654,"length":null,"possible_values":null},{"name":"YEAR_OF_FUTURE_ADT_115","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2039","2038","2040","2030","2039"],"min":100,"max":2045,"length":null,"possible_values":null},{"name":"MIN_NAV_CLR_MT_116","type":"float","description":null,"nullable":true,"num_null_values":198,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":30.4,"length":null,"possible_values":null},{"name":"FED_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"SUBMITTED_BY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02","61","62","63","64","66","67","68","70","72","74"]},{"name":"BRIDGE_CONDITION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["F","G","F","F","F"],"min":null,"max":null,"length":1,"possible_values":["F","G","P"]},{"name":"LOWEST_RATING","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","6","5","6"],"min":0,"max":9,"length":null,"possible_values":null},{"name":"DECK_AREA","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["298.15","422.73","60.16","1130.04","340.4"],"min":5.2,"max":22239.88,"length":null,"possible_values":null},{"name":"STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AM","ST","AM","ST","ST"],"min":null,"max":null,"length":2,"possible_values":["AM","MM","ST"]},{"name":"DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1202","0825","1202","0825","0825"],"min":null,"max":null,"length":4,"possible_values":["0203","0303","0403","0503","0825","1202"]},{"name":"LATDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64.703561","32.422742","33.805533","34.847617","55.687222"],"min":30.252947,"max":70.21645,"length":null,"possible_values":null},{"name":"LONGDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-141.312189","-88.372058","-87.583814","-87.117939","-132.729444"],"min":-174.182281,"max":-84.977219,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geoparquet/national-bridge-inventory-nbi.parquet","storage_uri":"gs://hifld-next-datasets-prod/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/geoparquet/national-bridge-inventory-nbi.parquet","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/national-bridge-inventory-nbi/files/national-bridge-inventory-nbi/sources/19154/download-zip"}}]},{"format":{"description":"PMTiles format for tile serving and web mapping","format_type":"pmtiles","created_at":"2026-02-13T02:36:11.357073","id":2,"name":"PMTiles","mime_type":"application/x-protobuf","updated_at":"2026-02-13T02:36:11.357095"},"file_format":{"id":18469,"format_id":2,"created_at":"2026-05-19T22:03:21.260687","file_id":4431,"updated_at":"2026-05-19T22:03:21.260713"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T05:02:25.916466","id":19155,"file_format_id":18469,"created_at":"2026-05-19T22:03:21.430263","location":{"type":"file","version":"v1","path":"national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/pmtiles/national-bridge-inventory-nbi.pmtiles"},"source_metadata":{"version":"v1","description":null,"size_bytes":314433936,"mime_type":null,"feature_count":624193,"bounds":[-174.182281,0,0,70.21645],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"65c1176fcadcbdb58626cc84f079d9a55d73557a805dc0dbe4e26de338b100e3","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"STATE_CODE_001","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02"]},{"name":"STRUCTURE_NUMBER_008","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0842","004024","005615","005203","1458"],"min":null,"max":null,"length":15,"possible_values":null},{"name":"RECORD_TYPE_005A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1"]},{"name":"ROUTE_PREFIX_005B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","4","3","4","3"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8"]},{"name":"SERVICE_LEVEL_005C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","7","8"]},{"name":"ROUTE_NUMBER_005D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00786","01009","00102","00026","00929"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"DIRECTION_005E","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"HIGHWAY_DISTRICT_002","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","05","10","02","03"],"min":null,"max":null,"length":2,"possible_values":["0","00","01","02","03","04","05","06","07","08","09","1","10","2","3","CN","N","SE"]},{"name":"COUNTY_CODE_003","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["240","119","057","083","198"],"min":null,"max":null,"length":3,"possible_values":null},{"name":"PLACE_CODE_004","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20380","90801","00000","92817","77140"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"FEATURES_DESC_006A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AMERICAN CREEK NO 2","CO RT 1009 STREAM","North River","ELK RIVER","RIO BEAVER"],"min":null,"max":null,"length":24,"possible_values":null},{"name":"CRITICAL_FACILITY_006B","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FACILITY_CARRIED_007","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["TAYLOR HIGHWAY","ROADWAY","AL-102","ELK RIV MILLS RD*","THORNE BAY ROAD"],"min":null,"max":null,"length":18,"possible_values":null},{"name":"LOCATION_009","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["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"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"MIN_VERT_CLR_010","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"KILOPOINT_011","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["242.021","0.0","22.574","0.01","11.774"],"min":0,"max":1178.091,"length":null,"possible_values":null},{"name":"BASE_HWY_NETWORK_012","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","1","0","0"],"min":null,"max":null,"length":1,"possible_values":["","0","1"]},{"name":"LRS_INV_ROUTE_013A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0025000000","000CO10090","000AL01020","000CO00260",""],"min":null,"max":null,"length":10,"possible_values":null},{"name":"SUBROUTE_NO_013B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"LAT_016","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64415800","32252187","33481980","34505142","55411400"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"LONG_017","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["141185200","088221941","087350168","087070458","132434600"],"min":null,"max":null,"length":9,"possible_values":null},{"name":"DETOUR_KILOS_019","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["199","21","23","26","199"],"min":0,"max":999,"length":null,"possible_values":null},{"name":"TOLL_020","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["3","3","3","3","3"],"min":null,"max":null,"length":1,"possible_values":["2","3"]},{"name":"MAINTENANCE_021","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","11","21","25","26","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"OWNER_022","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["01","02","01","02","01"],"min":null,"max":null,"length":2,"possible_values":["01","02","04","11","21","25","27","61","62","63","64","66","67","68","70","72","74"]},{"name":"FUNCTIONAL_CLASS_026","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["07","08","06","08","07"],"min":null,"max":null,"length":2,"possible_values":["01","02","06","07","08","09","11","12","14","16","17","19"]},{"name":"YEAR_BUILT_027","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1988","1951","1956","1955","1975"],"min":1898,"max":2024,"length":null,"possible_values":null},{"name":"TRAFFIC_LANES_ON_028A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"TRAFFIC_LANES_UND_028B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","8","9"]},{"name":"ADT_029","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["20","1024","839","2380","190"],"min":0,"max":62647,"length":null,"possible_values":null},{"name":"YEAR_ADT_030","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2020","2020","2020","2010","2020"],"min":0,"max":2025,"length":null,"possible_values":null},{"name":"DESIGN_LOAD_031","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","2","2","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","9","A","B","C"]},{"name":"APPR_WIDTH_MT_032","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","10.4","9.4","7.3","8.8"],"min":0.6,"max":48.2,"length":null,"possible_values":null},{"name":"MEDIAN_CODE_033","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"DEGREES_SKEW_034","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","0","0","0","0"],"min":0,"max":99,"length":null,"possible_values":null},{"name":"STRUCTURE_FLARED_035","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"RAILINGS_036A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"TRANSITIONS_036B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_036C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","N","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"APPR_RAIL_END_036D","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","1","N","0","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"HISTORY_037","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5"]},{"name":"NAVIGATION_038","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","N"]},{"name":"NAV_VERT_CLR_MT_039","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","8.2","0.0"],"min":0,"max":30.5,"length":null,"possible_values":null},{"name":"NAV_HORR_CLR_MT_040","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","36.6","0.0"],"min":0,"max":137.1,"length":null,"possible_values":null},{"name":"OPEN_CLOSED_POSTED_041","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["A","A","A","P","A"],"min":null,"max":null,"length":1,"possible_values":["A","B","D","E","G","K","P","R"]},{"name":"SERVICE_ON_042A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["1","4","5","6"]},{"name":"SERVICE_UND_042B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","5","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_KIND_043A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","1","1","4","4"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9"]},{"name":"STRUCTURE_TYPE_043B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["04","04","19","02","03"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","07","08","09","10","11","12","14","19","21","22"]},{"name":"APPR_KIND_044A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","1","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7"]},{"name":"APPR_TYPE_044B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["00","00","00","04","00"],"min":null,"max":null,"length":2,"possible_values":["00","01","02","03","04","05","06","09","10","11","12","19","20","22"]},{"name":"MAIN_UNIT_SPANS_045","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","5","2","3","3"],"min":1,"max":200,"length":null,"possible_values":null},{"name":"APPR_SPANS_046","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","2","0"],"min":0,"max":1888,"length":null,"possible_values":null},{"name":"HORR_CLR_MT_047","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.5","6.6","10.7","6.6","7.2"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"MAX_SPAN_LEN_MT_048","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.2","11.0","3.0","39.9","38.4"],"min":0,"max":189,"length":null,"possible_values":null},{"name":"STRUCTURE_LEN_MT_049","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.5","54.9","6.4","154.8","46.0"],"min":6.1,"max":1981.2,"length":null,"possible_values":null},{"name":"LEFT_CURB_MT_050A","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"RIGHT_CURB_MT_050B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":7.2,"length":null,"possible_values":null},{"name":"ROADWAY_WIDTH_MT_051","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.6","6.6","0.0","6.6","7.3"],"min":0,"max":49.2,"length":null,"possible_values":null},{"name":"DECK_WIDTH_MT_052","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8.9","7.7","0.0","7.3","7.4"],"min":0,"max":67.7,"length":null,"possible_values":null},{"name":"VERT_CLR_OVER_MT_053","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.99","99.99","99.99","99.99","99.99"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"VERT_CLR_UND_REF_054A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"VERT_CLR_UND_054B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.99,"length":null,"possible_values":null},{"name":"LAT_UND_REF_055A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["H","N","R"]},{"name":"LAT_UND_MT_055B","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["99.9","0.0","0.0","99.9","99.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"LEFT_LAT_UND_MT_056","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":99.8,"length":null,"possible_values":null},{"name":"DECK_COND_058","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","7","N","7","8"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUPERSTRUCTURE_COND_059","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","7","N","7","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"SUBSTRUCTURE_COND_060","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","N","5","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","6","7","8","9","N"]},{"name":"CHANNEL_COND_061","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","5","7","6"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N"]},{"name":"CULVERT_COND_062","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","6","N","N"],"min":null,"max":null,"length":1,"possible_values":["3","4","5","6","7","8","9","N"]},{"name":"OPR_RATING_METH_063","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"OPERATING_RATING_064","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["42.3","63.2","99.9","99.9","88.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"INV_RATING_METH_065","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","1","1","1","1"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5","7","8","A"]},{"name":"INVENTORY_RATING_066","type":"float","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["25.3","37.9","61.6","48.6","64.9"],"min":0,"max":99.9,"length":null,"possible_values":null},{"name":"STRUCTURAL_EVAL_067","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","6","6","5","6"],"min":null,"max":null,"length":1,"possible_values":["*","0","2","3","4","5","6","7","8","9"]},{"name":"DECK_GEOMETRY_EVAL_068","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","2","N","2","5"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"UNDCLRENCE_EVAL_069","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"POSTING_EVAL_070","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["5","5","5","3","5"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","5"]},{"name":"WATERWAY_EVAL_071","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","8","6","8","8"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9","N"]},{"name":"APPR_ROAD_EVAL_072","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["7","9","8","6","6"],"min":null,"max":null,"length":1,"possible_values":["0","2","3","4","5","6","7","8","9"]},{"name":"WORK_PROPOSED_075A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","35","","35",""],"min":null,"max":null,"length":2,"possible_values":["","31","33","34","35","36","38"]},{"name":"WORK_DONE_BY_075B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","1","","1",""],"min":null,"max":null,"length":1,"possible_values":["","1","2"]},{"name":"IMP_LEN_MT_076","type":"string","description":null,"nullable":true,"num_null_values":1148,"num_unique_values":null,"example_values":["19.7","20.5","215","18.4","12.6"],"min":null,"max":null,"length":6,"possible_values":null},{"name":"DATE_OF_INSPECT_090","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["723","424","1223","1024","723"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"INSPECT_FREQ_MONTHS_091","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["24","24","24","24","24"],"min":6,"max":48,"length":null,"possible_values":null},{"name":"FRACTURE_092A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","Y24"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24"]},{"name":"UNDWATER_LOOK_SEE_092B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y48","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y12","Y24","Y48","Y60"]},{"name":"SPEC_INSPECT_092C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","Y12","N"],"min":null,"max":null,"length":3,"possible_values":["N","Y01","Y03","Y06","Y12","Y24","Y48","Y60","Y99"]},{"name":"FRACTURE_LAST_DATE_093A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","","0523"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"UNDWATER_LAST_DATE_093B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","0922",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"SPEC_LAST_DATE_093C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","1024",""],"min":null,"max":null,"length":4,"possible_values":null},{"name":"BRIDGE_IMP_COST_094","type":"string","description":null,"nullable":true,"num_null_values":1441,"num_unique_values":null,"example_values":["1306","232","393","50","650"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"ROADWAY_IMP_COST_095","type":"string","description":null,"nullable":true,"num_null_values":1452,"num_unique_values":null,"example_values":["24","29","91","16","102"],"min":null,"max":null,"length":4,"possible_values":null},{"name":"TOTAL_IMP_COST_096","type":"string","description":null,"nullable":true,"num_null_values":1451,"num_unique_values":null,"example_values":["529","1009","537","446","553"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"YEAR_OF_IMP_097","type":"string","description":null,"nullable":true,"num_null_values":1613,"num_unique_values":null,"example_values":["2025","2025","2025","2025","2025"],"min":null,"max":null,"length":4,"possible_values":["2017","2018","2019","2020","2021","2022","2023","2024","2025"]},{"name":"OTHER_STATE_CODE_098A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":3,"possible_values":["","020"]},{"name":"OTHER_STATE_PCNT_098B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","0","0","0",""],"min":null,"max":null,"length":1,"possible_values":["","0"]},{"name":"OTHR_STATE_STRUC_NO_099","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":4,"possible_values":["","2198","NO"]},{"name":"STRAHNET_HIGHWAY_100","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2"]},{"name":"PARALLEL_STRUCTURE_101","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["L","N","R"]},{"name":"TRAFFIC_DIRECTION_102","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2","2","2","2","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3"]},{"name":"TEMP_STRUCTURE_103","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["","","","",""],"min":null,"max":null,"length":1,"possible_values":["","T"]},{"name":"HIGHWAY_SYSTEM_104","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"FEDERAL_LANDS_105","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4"]},{"name":"YEAR_RECONSTRUCTED_106","type":"float","description":null,"nullable":true,"num_null_values":25,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","1992.0"],"min":0,"max":2024,"length":null,"possible_values":null},{"name":"DECK_STRUCTURE_TYPE_107","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["9","1","N","1","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","8","9","N"]},{"name":"SURFACE_TYPE_108A","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","0","N","0","6"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","5","6","7","8","9","N"]},{"name":"MEMBRANE_TYPE_108B","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","N","0","2"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","8","9","N"]},{"name":"DECK_PROTECTION_108C","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","0","N","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1","2","3","4","6","7","8","9","N"]},{"name":"PERCENT_ADT_TRUCK_109","type":"float","description":null,"nullable":true,"num_null_values":500,"num_unique_values":null,"example_values":["7.0","27.0","1.0","34.0","10.0"],"min":0,"max":90,"length":null,"possible_values":null},{"name":"NATIONAL_NETWORK_110","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["0","0","0","0","0"],"min":null,"max":null,"length":1,"possible_values":["0","1"]},{"name":"PIER_PROTECTION_111","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1","","","1","1"],"min":null,"max":null,"length":1,"possible_values":["","1","2","3","4","5"]},{"name":"BRIDGE_LEN_IND_112","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"SCOUR_CRITICAL_113","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["8","8","8","5","8"],"min":null,"max":null,"length":1,"possible_values":["1","2","3","4","5","6","7","8","9","N","T","U"]},{"name":"FUTURE_ADT_114","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["30","1522","956","3540","230"],"min":0,"max":102654,"length":null,"possible_values":null},{"name":"YEAR_OF_FUTURE_ADT_115","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2039","2038","2040","2030","2039"],"min":100,"max":2045,"length":null,"possible_values":null},{"name":"MIN_NAV_CLR_MT_116","type":"float","description":null,"nullable":true,"num_null_values":198,"num_unique_values":null,"example_values":["0.0","0.0","0.0","0.0","0.0"],"min":0,"max":30.4,"length":null,"possible_values":null},{"name":"FED_AGENCY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["N","N","N","N","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"SUBMITTED_BY","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["02","01","01","01","02"],"min":null,"max":null,"length":2,"possible_values":["01","02","61","62","63","64","66","67","68","70","72","74"]},{"name":"BRIDGE_CONDITION","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["F","G","F","F","F"],"min":null,"max":null,"length":1,"possible_values":["F","G","P"]},{"name":"LOWEST_RATING","type":"integer","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["6","7","6","5","6"],"min":0,"max":9,"length":null,"possible_values":null},{"name":"DECK_AREA","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["298.15","422.73","60.16","1130.04","340.4"],"min":5.2,"max":22239.88,"length":null,"possible_values":null},{"name":"STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["AM","ST","AM","ST","ST"],"min":null,"max":null,"length":2,"possible_values":["AM","MM","ST"]},{"name":"DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["1202","0825","1202","0825","0825"],"min":null,"max":null,"length":4,"possible_values":["0203","0303","0403","0503","0825","1202"]},{"name":"LATDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["64.703561","32.422742","33.805533","34.847617","55.687222"],"min":30.252947,"max":70.21645,"length":null,"possible_values":null},{"name":"LONGDD","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-141.312189","-88.372058","-87.583814","-87.117939","-132.729444"],"min":-174.182281,"max":-84.977219,"length":null,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/pmtiles/national-bridge-inventory-nbi.pmtiles","storage_uri":"gs://hifld-next-datasets-prod/national-bridge-inventory-nbi/national-bridge-inventory-nbi/v1.0.0/pmtiles/national-bridge-inventory-nbi.pmtiles","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/national-bridge-inventory-nbi/files/national-bridge-inventory-nbi/sources/19155/download-zip"}}]}]}}