{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "National Bridge Inventory Element Data", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "cs1": null, "cs3": null, "cs2": null, "cs4": null, "totalqty": null, "strucnum": null, "en": null, "state": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "National Bridge Inventory Element Data", "displayField": "strucnum", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 4, "alias": "STATE", "type": "esriFieldTypeString" }, { "modelName": "strucnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "strucnum", "length": 30, "alias": "STRUCNUM", "type": "esriFieldTypeString" }, { "modelName": "en", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "en", "alias": "EN", "type": "esriFieldTypeInteger" }, { "modelName": "totalqty", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "totalqty", "alias": "TOTALQTY", "type": "esriFieldTypeInteger" }, { "modelName": "cs1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cs1", "alias": "CS1", "type": "esriFieldTypeInteger" }, { "modelName": "cs2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cs2", "alias": "CS2", "type": "esriFieldTypeInteger" }, { "modelName": "cs3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cs3", "alias": "CS3", "type": "esriFieldTypeInteger" }, { "modelName": "cs4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cs4", "alias": "CS4", "type": "esriFieldTypeInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r5028_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "286fdd2afb634681a5470f193eba5268", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 0, "xmin": -1.93898828261E7, "ymax": 1.11395333578E7, "xmax": 1.61213062452E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "National Bridge Inventory", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "max_span_len_mt_048": null, "scour_critical_113": null, "deck_width_mt_052": null, "other_state_pcnt_098b": null, "service_level_005c": null, "vert_clr_over_mt_053": null, "median_code_033": null, "structure_kind_043a": null, "left_curb_mt_050a": null, "lrs_inv_route_013a": null, "undwater_look_see_092b": null, "channel_cond_061": null, "fracture_last_date_093a": null, "deck_cond_058": null, "structural_eval_067": null, "location_009": null, "transitions_036b": null, "imp_len_mt_076": null, "appr_rail_end_036d": null, "service_und_042b": null, "appr_kind_044a": null, "lowest_rating": null, "culvert_cond_062": null, "structure_number_008": null, "vert_clr_und_054b": null, "route_prefix_005b": null, "route_number_005d": null, "toll_020": null, "undclrence_eval_069": null, "other_state_code_098a": null, "deck_structure_type_107": null, "roadway_imp_cost_095": null, "functional_class_026": null, "maintenance_021": null, "structure_type_043b": null, "opr_rating_meth_063": null, "right_curb_mt_050b": null, "status": null, "latdd": null, "detour_kilos_019": null, "nav_vert_clr_mt_039": null, "membrane_type_108b": null, "appr_type_044b": null, "long_017": null, "bridge_imp_cost_094": null, "work_proposed_075a": null, "traffic_direction_102": null, "state_code_001": null, "min_nav_clr_mt_116": null, "deck_geometry_eval_068": null, "longdd": null, "structure_len_mt_049": null, "undwater_last_date_093b": null, "appr_rail_036c": null, "appr_spans_046": null, "year_of_imp_097": null, "structure_flared_035": null, "work_done_by_075b": null, "percent_adt_truck_109": null, "county_code_003": null, "deck_protection_108c": null, "base_hwy_network_012": null, "lat_016": null, "date": null, "appr_width_mt_032": null, "year_adt_030": null, "horr_clr_mt_047": null, "adt_029": null, "features_desc_006a": null, "national_network_110": null, "fracture_092a": null, "main_unit_spans_045": null, "nav_horr_clr_mt_040": null, "history_037": null, "parallel_structure_101": null, "substructure_cond_060": null, "service_on_042a": null, "superstructure_cond_059": null, "traffic_lanes_on_028a": null, "place_code_004": null, "total_imp_cost_096": null, "bridge_condition": null, "traffic_lanes_und_028b": null, "roadway_width_mt_051": null, "temp_structure_103": null, "lat_und_mt_055b": null, "facility_carried_007": null, "degrees_skew_034": null, "waterway_eval_071": null, "spec_inspect_092c": null, "subroute_no_013b": null, "spec_last_date_093c": null, "direction_005e": null, "left_lat_und_mt_056": null, "inspect_freq_months_091": null, "bridge_len_ind_112": null, "vert_clr_und_ref_054a": null, "operating_rating_064": null, "othr_state_struc_no_099": null, "min_vert_clr_010": null, "kilopoint_011": null, "navigation_038": null, "year_built_027": null, "lat_und_ref_055a": null, "inventory_rating_066": null, "record_type_005a": null, "posting_eval_070": null, "federal_lands_105": null, "year_reconstructed_106": null, "date_of_inspect_090": null, "critical_facility_006b": null, "submitted_by": null, "highway_district_002": null, "inv_rating_meth_065": null, "surface_type_108a": null, "open_closed_posted_041": null, "future_adt_114": null, "owner_022": null, "fed_agency": null, "strahnet_highway_100": null, "deck_area": null, "design_load_031": null, "appr_road_eval_072": null, "highway_system_104": null, "year_of_future_adt_115": null, "railings_036a": null, "pier_protection_111": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.1, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "National Bridge Inventory", "allowTrueCurvesUpdates": false, "displayField": "state_code_001", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "state_code_001", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_code_001", "length": 4, "alias": "STATE_CODE_001", "type": "esriFieldTypeString" }, { "modelName": "structure_number_008", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure_number_008", "length": 30, "alias": "STRUCTURE_NUMBER_008", "type": "esriFieldTypeString" }, { "modelName": "record_type_005a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "record_type_005a", "length": 2, "alias": "RECORD_TYPE_005A", "type": "esriFieldTypeString" }, { "modelName": "route_prefix_005b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "route_prefix_005b", "length": 2, "alias": "ROUTE_PREFIX_005B", "type": "esriFieldTypeString" }, { "modelName": "service_level_005c", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_level_005c", "length": 2, "alias": "SERVICE_LEVEL_005C", "type": "esriFieldTypeString" }, { "modelName": "route_number_005d", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "route_number_005d", "length": 10, "alias": "ROUTE_NUMBER_005D", "type": "esriFieldTypeString" }, { "modelName": "direction_005e", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direction_005e", "length": 2, "alias": "DIRECTION_005E", "type": "esriFieldTypeString" }, { "modelName": "highway_district_002", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "highway_district_002", "length": 4, "alias": "HIGHWAY_DISTRICT_002", "type": "esriFieldTypeString" }, { "modelName": "county_code_003", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county_code_003", "length": 6, "alias": "COUNTY_CODE_003", "type": "esriFieldTypeString" }, { "modelName": "place_code_004", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "place_code_004", "length": 10, "alias": "PLACE_CODE_004", "type": "esriFieldTypeString" }, { "modelName": "features_desc_006a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "features_desc_006a", "length": 48, "alias": "FEATURES_DESC_006A", "type": "esriFieldTypeString" }, { "modelName": "critical_facility_006b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "critical_facility_006b", "alias": "CRITICAL_FACILITY_006B", "type": "esriFieldTypeDouble" }, { "modelName": "facility_carried_007", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facility_carried_007", "length": 36, "alias": "FACILITY_CARRIED_007", "type": "esriFieldTypeString" }, { "modelName": "location_009", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location_009", "length": 50, "alias": "LOCATION_009", "type": "esriFieldTypeString" }, { "modelName": "min_vert_clr_010", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "min_vert_clr_010", "alias": "MIN_VERT_CLR_010", "type": "esriFieldTypeDouble" }, { "modelName": "kilopoint_011", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "kilopoint_011", "alias": "KILOPOINT_011", "type": "esriFieldTypeDouble" }, { "modelName": "base_hwy_network_012", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "base_hwy_network_012", "length": 2, "alias": "BASE_HWY_NETWORK_012", "type": "esriFieldTypeString" }, { "modelName": "lrs_inv_route_013a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lrs_inv_route_013a", "length": 20, "alias": "LRS_INV_ROUTE_013A", "type": "esriFieldTypeString" }, { "modelName": "subroute_no_013b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subroute_no_013b", "length": 4, "alias": "SUBROUTE_NO_013B", "type": "esriFieldTypeString" }, { "modelName": "lat_016", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat_016", "length": 16, "alias": "LAT_016", "type": "esriFieldTypeString" }, { "modelName": "long_017", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "long_017", "length": 18, "alias": "LONG_017", "type": "esriFieldTypeString" }, { "modelName": "detour_kilos_019", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "detour_kilos_019", "alias": "DETOUR_KILOS_019", "type": "esriFieldTypeInteger" }, { "modelName": "toll_020", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "toll_020", "length": 2, "alias": "TOLL_020", "type": "esriFieldTypeString" }, { "modelName": "maintenance_021", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maintenance_021", "length": 4, "alias": "MAINTENANCE_021", "type": "esriFieldTypeString" }, { "modelName": "owner_022", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_022", "length": 4, "alias": "OWNER_022", "type": "esriFieldTypeString" }, { "modelName": "functional_class_026", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "functional_class_026", "length": 4, "alias": "FUNCTIONAL_CLASS_026", "type": "esriFieldTypeString" }, { "modelName": "year_built_027", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_built_027", "alias": "YEAR_BUILT_027", "type": "esriFieldTypeInteger" }, { "modelName": "traffic_lanes_on_028a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "traffic_lanes_on_028a", "length": 4, "alias": "TRAFFIC_LANES_ON_028A", "type": "esriFieldTypeString" }, { "modelName": "traffic_lanes_und_028b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "traffic_lanes_und_028b", "length": 4, "alias": "TRAFFIC_LANES_UND_028B", "type": "esriFieldTypeString" }, { "modelName": "adt_029", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adt_029", "alias": "ADT_029", "type": "esriFieldTypeInteger" }, { "modelName": "year_adt_030", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_adt_030", "alias": "YEAR_ADT_030", "type": "esriFieldTypeInteger" }, { "modelName": "design_load_031", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "design_load_031", "length": 2, "alias": "DESIGN_LOAD_031", "type": "esriFieldTypeString" }, { "modelName": "appr_width_mt_032", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appr_width_mt_032", "alias": "APPR_WIDTH_MT_032", "type": "esriFieldTypeDouble" }, { "modelName": "median_code_033", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "median_code_033", "length": 2, "alias": "MEDIAN_CODE_033", "type": "esriFieldTypeString" }, { "modelName": "degrees_skew_034", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "degrees_skew_034", "alias": "DEGREES_SKEW_034", "type": "esriFieldTypeInteger" }, { "modelName": "structure_flared_035", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure_flared_035", "length": 2, "alias": "STRUCTURE_FLARED_035", "type": "esriFieldTypeString" }, { "modelName": "railings_036a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "railings_036a", "length": 2, "alias": "RAILINGS_036A", "type": "esriFieldTypeString" }, { "modelName": "transitions_036b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transitions_036b", "length": 2, "alias": "TRANSITIONS_036B", "type": "esriFieldTypeString" }, { "modelName": "appr_rail_036c", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appr_rail_036c", "length": 2, "alias": "APPR_RAIL_036C", "type": "esriFieldTypeString" }, { "modelName": "appr_rail_end_036d", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appr_rail_end_036d", "length": 2, "alias": "APPR_RAIL_END_036D", "type": "esriFieldTypeString" }, { "modelName": "history_037", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "history_037", "length": 2, "alias": "HISTORY_037", "type": "esriFieldTypeString" }, { "modelName": "navigation_038", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "navigation_038", "length": 2, "alias": "NAVIGATION_038", "type": "esriFieldTypeString" }, { "modelName": "nav_vert_clr_mt_039", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nav_vert_clr_mt_039", "alias": "NAV_VERT_CLR_MT_039", "type": "esriFieldTypeDouble" }, { "modelName": "nav_horr_clr_mt_040", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nav_horr_clr_mt_040", "alias": "NAV_HORR_CLR_MT_040", "type": "esriFieldTypeDouble" }, { "modelName": "open_closed_posted_041", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "open_closed_posted_041", "length": 2, "alias": "OPEN_CLOSED_POSTED_041", "type": "esriFieldTypeString" }, { "modelName": "service_on_042a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_on_042a", "length": 2, "alias": "SERVICE_ON_042A", "type": "esriFieldTypeString" }, { "modelName": "service_und_042b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_und_042b", "length": 2, "alias": "SERVICE_UND_042B", "type": "esriFieldTypeString" }, { "modelName": "structure_kind_043a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure_kind_043a", "length": 2, "alias": "STRUCTURE_KIND_043A", "type": "esriFieldTypeString" }, { "modelName": "structure_type_043b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure_type_043b", "length": 4, "alias": "STRUCTURE_TYPE_043B", "type": "esriFieldTypeString" }, { "modelName": "appr_kind_044a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appr_kind_044a", "length": 2, "alias": "APPR_KIND_044A", "type": "esriFieldTypeString" }, { "modelName": "appr_type_044b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appr_type_044b", "length": 4, "alias": "APPR_TYPE_044B", "type": "esriFieldTypeString" }, { "modelName": "main_unit_spans_045", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "main_unit_spans_045", "alias": "MAIN_UNIT_SPANS_045", "type": "esriFieldTypeInteger" }, { "modelName": "appr_spans_046", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appr_spans_046", "alias": "APPR_SPANS_046", "type": "esriFieldTypeInteger" }, { "modelName": "horr_clr_mt_047", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "horr_clr_mt_047", "alias": "HORR_CLR_MT_047", "type": "esriFieldTypeDouble" }, { "modelName": "max_span_len_mt_048", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "max_span_len_mt_048", "alias": "MAX_SPAN_LEN_MT_048", "type": "esriFieldTypeDouble" }, { "modelName": "structure_len_mt_049", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure_len_mt_049", "alias": "STRUCTURE_LEN_MT_049", "type": "esriFieldTypeDouble" }, { "modelName": "left_curb_mt_050a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "left_curb_mt_050a", "alias": "LEFT_CURB_MT_050A", "type": "esriFieldTypeDouble" }, { "modelName": "right_curb_mt_050b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "right_curb_mt_050b", "alias": "RIGHT_CURB_MT_050B", "type": "esriFieldTypeDouble" }, { "modelName": "roadway_width_mt_051", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadway_width_mt_051", "alias": "ROADWAY_WIDTH_MT_051", "type": "esriFieldTypeDouble" }, { "modelName": "deck_width_mt_052", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deck_width_mt_052", "alias": "DECK_WIDTH_MT_052", "type": "esriFieldTypeDouble" }, { "modelName": "vert_clr_over_mt_053", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "vert_clr_over_mt_053", "alias": "VERT_CLR_OVER_MT_053", "type": "esriFieldTypeDouble" }, { "modelName": "vert_clr_und_ref_054a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "vert_clr_und_ref_054a", "length": 2, "alias": "VERT_CLR_UND_REF_054A", "type": "esriFieldTypeString" }, { "modelName": "vert_clr_und_054b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "vert_clr_und_054b", "alias": "VERT_CLR_UND_054B", "type": "esriFieldTypeDouble" }, { "modelName": "lat_und_ref_055a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat_und_ref_055a", "length": 2, "alias": "LAT_UND_REF_055A", "type": "esriFieldTypeString" }, { "modelName": "lat_und_mt_055b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lat_und_mt_055b", "alias": "LAT_UND_MT_055B", "type": "esriFieldTypeDouble" }, { "modelName": "left_lat_und_mt_056", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "left_lat_und_mt_056", "alias": "LEFT_LAT_UND_MT_056", "type": "esriFieldTypeDouble" }, { "modelName": "deck_cond_058", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deck_cond_058", "length": 2, "alias": "DECK_COND_058", "type": "esriFieldTypeString" }, { "modelName": "superstructure_cond_059", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "superstructure_cond_059", "length": 2, "alias": "SUPERSTRUCTURE_COND_059", "type": "esriFieldTypeString" }, { "modelName": "substructure_cond_060", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "substructure_cond_060", "length": 2, "alias": "SUBSTRUCTURE_COND_060", "type": "esriFieldTypeString" }, { "modelName": "channel_cond_061", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "channel_cond_061", "length": 2, "alias": "CHANNEL_COND_061", "type": "esriFieldTypeString" }, { "modelName": "culvert_cond_062", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "culvert_cond_062", "length": 2, "alias": "CULVERT_COND_062", "type": "esriFieldTypeString" }, { "modelName": "opr_rating_meth_063", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "opr_rating_meth_063", "length": 2, "alias": "OPR_RATING_METH_063", "type": "esriFieldTypeString" }, { "modelName": "operating_rating_064", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operating_rating_064", "alias": "OPERATING_RATING_064", "type": "esriFieldTypeDouble" }, { "modelName": "inv_rating_meth_065", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inv_rating_meth_065", "length": 2, "alias": "INV_RATING_METH_065", "type": "esriFieldTypeString" }, { "modelName": "inventory_rating_066", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inventory_rating_066", "alias": "INVENTORY_RATING_066", "type": "esriFieldTypeDouble" }, { "modelName": "structural_eval_067", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structural_eval_067", "length": 2, "alias": "STRUCTURAL_EVAL_067", "type": "esriFieldTypeString" }, { "modelName": "deck_geometry_eval_068", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deck_geometry_eval_068", "length": 2, "alias": "DECK_GEOMETRY_EVAL_068", "type": "esriFieldTypeString" }, { "modelName": "undclrence_eval_069", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "undclrence_eval_069", "length": 2, "alias": "UNDCLRENCE_EVAL_069", "type": "esriFieldTypeString" }, { "modelName": "posting_eval_070", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "posting_eval_070", "length": 2, "alias": "POSTING_EVAL_070", "type": "esriFieldTypeString" }, { "modelName": "waterway_eval_071", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterway_eval_071", "length": 2, "alias": "WATERWAY_EVAL_071", "type": "esriFieldTypeString" }, { "modelName": "appr_road_eval_072", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appr_road_eval_072", "length": 2, "alias": "APPR_ROAD_EVAL_072", "type": "esriFieldTypeString" }, { "modelName": "work_proposed_075a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_proposed_075a", "length": 4, "alias": "WORK_PROPOSED_075A", "type": "esriFieldTypeString" }, { "modelName": "work_done_by_075b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "work_done_by_075b", "length": 2, "alias": "WORK_DONE_BY_075B", "type": "esriFieldTypeString" }, { "modelName": "imp_len_mt_076", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imp_len_mt_076", "alias": "IMP_LEN_MT_076", "type": "esriFieldTypeDouble" }, { "modelName": "date_of_inspect_090", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "date_of_inspect_090", "length": 8, "alias": "DATE_OF_INSPECT_090", "type": "esriFieldTypeString" }, { "modelName": "inspect_freq_months_091", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspect_freq_months_091", "alias": "INSPECT_FREQ_MONTHS_091", "type": "esriFieldTypeInteger" }, { "modelName": "fracture_092a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fracture_092a", "length": 6, "alias": "FRACTURE_092A", "type": "esriFieldTypeString" }, { "modelName": "undwater_look_see_092b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "undwater_look_see_092b", "length": 6, "alias": "UNDWATER_LOOK_SEE_092B", "type": "esriFieldTypeString" }, { "modelName": "spec_inspect_092c", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spec_inspect_092c", "length": 6, "alias": "SPEC_INSPECT_092C", "type": "esriFieldTypeString" }, { "modelName": "fracture_last_date_093a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fracture_last_date_093a", "length": 8, "alias": "FRACTURE_LAST_DATE_093A", "type": "esriFieldTypeString" }, { "modelName": "undwater_last_date_093b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "undwater_last_date_093b", "length": 8, "alias": "UNDWATER_LAST_DATE_093B", "type": "esriFieldTypeString" }, { "modelName": "spec_last_date_093c", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spec_last_date_093c", "length": 8, "alias": "SPEC_LAST_DATE_093C", "type": "esriFieldTypeString" }, { "modelName": "bridge_imp_cost_094", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bridge_imp_cost_094", "alias": "BRIDGE_IMP_COST_094", "type": "esriFieldTypeInteger" }, { "modelName": "roadway_imp_cost_095", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadway_imp_cost_095", "alias": "ROADWAY_IMP_COST_095", "type": "esriFieldTypeInteger" }, { "modelName": "total_imp_cost_096", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_imp_cost_096", "alias": "TOTAL_IMP_COST_096", "type": "esriFieldTypeInteger" }, { "modelName": "year_of_imp_097", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_of_imp_097", "alias": "YEAR_OF_IMP_097", "type": "esriFieldTypeInteger" }, { "modelName": "other_state_code_098a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_state_code_098a", "length": 6, "alias": "OTHER_STATE_CODE_098A", "type": "esriFieldTypeString" }, { "modelName": "other_state_pcnt_098b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_state_pcnt_098b", "length": 4, "alias": "OTHER_STATE_PCNT_098B", "type": "esriFieldTypeString" }, { "modelName": "othr_state_struc_no_099", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "othr_state_struc_no_099", "length": 30, "alias": "OTHR_STATE_STRUC_NO_099", "type": "esriFieldTypeString" }, { "modelName": "strahnet_highway_100", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "strahnet_highway_100", "length": 2, "alias": "STRAHNET_HIGHWAY_100", "type": "esriFieldTypeString" }, { "modelName": "parallel_structure_101", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parallel_structure_101", "length": 2, "alias": "PARALLEL_STRUCTURE_101", "type": "esriFieldTypeString" }, { "modelName": "traffic_direction_102", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "traffic_direction_102", "length": 2, "alias": "TRAFFIC_DIRECTION_102", "type": "esriFieldTypeString" }, { "modelName": "temp_structure_103", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "temp_structure_103", "length": 2, "alias": "TEMP_STRUCTURE_103", "type": "esriFieldTypeString" }, { "modelName": "highway_system_104", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "highway_system_104", "length": 2, "alias": "HIGHWAY_SYSTEM_104", "type": "esriFieldTypeString" }, { "modelName": "federal_lands_105", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "federal_lands_105", "length": 2, "alias": "FEDERAL_LANDS_105", "type": "esriFieldTypeString" }, { "modelName": "year_reconstructed_106", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_reconstructed_106", "alias": "YEAR_RECONSTRUCTED_106", "type": "esriFieldTypeInteger" }, { "modelName": "deck_structure_type_107", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deck_structure_type_107", "length": 2, "alias": "DECK_STRUCTURE_TYPE_107", "type": "esriFieldTypeString" }, { "modelName": "surface_type_108a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surface_type_108a", "length": 2, "alias": "SURFACE_TYPE_108A", "type": "esriFieldTypeString" }, { "modelName": "membrane_type_108b", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "membrane_type_108b", "length": 2, "alias": "MEMBRANE_TYPE_108B", "type": "esriFieldTypeString" }, { "modelName": "deck_protection_108c", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deck_protection_108c", "length": 2, "alias": "DECK_PROTECTION_108C", "type": "esriFieldTypeString" }, { "modelName": "percent_adt_truck_109", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "percent_adt_truck_109", "alias": "PERCENT_ADT_TRUCK_109", "type": "esriFieldTypeInteger" }, { "modelName": "national_network_110", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "national_network_110", "length": 2, "alias": "NATIONAL_NETWORK_110", "type": "esriFieldTypeString" }, { "modelName": "pier_protection_111", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pier_protection_111", "length": 2, "alias": "PIER_PROTECTION_111", "type": "esriFieldTypeString" }, { "modelName": "bridge_len_ind_112", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bridge_len_ind_112", "length": 2, "alias": "BRIDGE_LEN_IND_112", "type": "esriFieldTypeString" }, { "modelName": "scour_critical_113", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scour_critical_113", "length": 2, "alias": "SCOUR_CRITICAL_113", "type": "esriFieldTypeString" }, { "modelName": "future_adt_114", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "future_adt_114", "alias": "FUTURE_ADT_114", "type": "esriFieldTypeInteger" }, { "modelName": "year_of_future_adt_115", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_of_future_adt_115", "alias": "YEAR_OF_FUTURE_ADT_115", "type": "esriFieldTypeInteger" }, { "modelName": "min_nav_clr_mt_116", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "min_nav_clr_mt_116", "alias": "MIN_NAV_CLR_MT_116", "type": "esriFieldTypeDouble" }, { "modelName": "fed_agency", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fed_agency", "length": 2, "alias": "FED_AGENCY", "type": "esriFieldTypeString" }, { "modelName": "submitted_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "submitted_by", "length": 4, "alias": "SUBMITTED_BY", "type": "esriFieldTypeString" }, { "modelName": "bridge_condition", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bridge_condition", "length": 2, "alias": "BRIDGE_CONDITION", "type": "esriFieldTypeString" }, { "modelName": "lowest_rating", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lowest_rating", "alias": "LOWEST_RATING", "type": "esriFieldTypeInteger" }, { "modelName": "deck_area", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deck_area", "alias": "DECK_AREA", "type": "esriFieldTypeDouble" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 4, "alias": "STATUS", "type": "esriFieldTypeString" }, { "modelName": "date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "date", "length": 8, "alias": "DATE", "type": "esriFieldTypeString" }, { "modelName": "latdd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latdd", "alias": "LATDD", "type": "esriFieldTypeDouble" }, { "modelName": "longdd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longdd", "alias": "LONGDD", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "The National Bridge Inventory dataset is as of June 15, 2023 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.", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r5027_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4545_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true }, { "name": "idx_9a697dd1_ae26_4c93_bc63_c07cc8a0a07a", "isUnique": false, "description": "", "fields": "service_level_005c", "isAscending": true }, { "name": "idx_ac53b241_c05d_4e2c_83f8_3d1700c8249f", "isUnique": false, "description": "", "fields": "base_hwy_network_012", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "286fdd2afb634681a5470f193eba5268", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 158, 134, 58, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "NTAD datasets are intended for public usage and are not for sale/resale", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }