{ "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 Tunnel Inventory Element Data", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "condition_state_1": null, "epn": null, "total_quantity": null, "tunnel_number": null, "id": null, "state": null, "element_number": null, "condition_state_4": null, "condition_state_3": null, "condition_state_2": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "National Tunnel Inventory Element Data", "displayField": "tunnel_number", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id", "alias": "id", "type": "esriFieldTypeDouble" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 4, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "tunnel_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tunnel_number", "length": 30, "alias": "tunnel_number", "type": "esriFieldTypeString" }, { "modelName": "element_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "element_number", "alias": "element_number", "type": "esriFieldTypeDouble" }, { "modelName": "epn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "epn", "alias": "epn", "type": "esriFieldTypeInteger" }, { "modelName": "total_quantity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_quantity", "alias": "total_quantity", "type": "esriFieldTypeDouble" }, { "modelName": "condition_state_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_state_1", "alias": "condition_state_1", "type": "esriFieldTypeDouble" }, { "modelName": "condition_state_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_state_2", "alias": "condition_state_2", "type": "esriFieldTypeDouble" }, { "modelName": "condition_state_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_state_3", "alias": "condition_state_3", "type": "esriFieldTypeDouble" }, { "modelName": "condition_state_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_state_4", "alias": "condition_state_4", "type": "esriFieldTypeDouble" } ], "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": "r5034_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": "4f573fd47b44455a9bd3544b432192e3", "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": 2038589.0128000006, "xmin": -1.75724248012E7, "ymax": 8576772.7689, "xmax": -7333016.8332, "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 Tunnel Inventory", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "portal_shapes_s3": null, "border_financial_resp_i16": null, "hazardous_material_restriction_": null, "border_state_i15": null, "damage_inspection_d5": null, "in_depth_inspection_d4": null, "total_number_of_lanes_a3": null, "posting_load_type_3_l7": null, "border_inspection_resp_i18": null, "height_restriction_l10": null, "detour_length_a7": null, "year_built_a1": null, "portal_latitude_i13": null, "owner_c1": null, "routine_inspection_target_date_": null, "border_tunnel_number_i17": null, "direction_of_traffic_c3": null, "urban_code_c8": null, "tunnel_number_i1": null, "right_sidewalk_width_g5": null, "posting_load_type_33_l9": null, "nhs_designation_c5": null, "adtt_a5": null, "facility_carried_i10": null, "complex_s5": null, "highway_district_i6": null, "strahnet_designation_c6": null, "actual_routine_inspection_date_": null, "state_code_i3": null, "roadway_width_curb_to_curb_g3": null, "year_rehabilitated_a2": null, "tunnel_or_portal_island_protect": null, "route_number_i7": null, "portal_longitude_i14": null, "operator_c2": null, "year_of_average_daily_traffic_a": null, "special_inspection_d6": null, "load_rating_method_l1": null, "ground_conditions_s4": null, "inventory_load_rating_factor_l2": null, "operating_load_rating_factor_l3": null, "tunnel_name_i2": null, "lrs_mile_point_i12": null, "place_code_i5": null, "other_restrictions_l12": null, "left_sidewalk_width_g4": null, "tunnel_length_g1": null, "number_of_bores_s1": null, "min_vert_clearance_over_tunnel_": null, "county_code_i4": null, "lrs_route_id_i11": null, "toll_c4": null, "tunnel_shape_s2": null, "under_navigable_waterway_n1": null, "posting_load_gross_l5": null, "service_in_tunnel_a8": null, "navigable_waterway_clearance_n2": null, "tunnel_load_posting_status_l4": null, "posting_load_type_3s2_l8": null, "routine_inspection_interval_d3": null, "route_direction_i8": null, "adt_a4": null, "route_type_i9": null, "functional_classification_c7": null, "posting_load_axle_l6": 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 Tunnel Inventory", "allowTrueCurvesUpdates": false, "displayField": "tunnel_name_i2", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "tunnel_number_i1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tunnel_number_i1", "length": 30, "alias": "tunnel_number_i1", "type": "esriFieldTypeString" }, { "modelName": "tunnel_name_i2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tunnel_name_i2", "length": 102, "alias": "tunnel_name_i2", "type": "esriFieldTypeString" }, { "modelName": "state_code_i3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state_code_i3", "length": 4, "alias": "state_code_i3", "type": "esriFieldTypeString" }, { "modelName": "county_code_i4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county_code_i4", "length": 6, "alias": "county_code_i4", "type": "esriFieldTypeString" }, { "modelName": "place_code_i5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "place_code_i5", "length": 10, "alias": "place_code_i5", "type": "esriFieldTypeString" }, { "modelName": "highway_district_i6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "highway_district_i6", "length": 4, "alias": "highway_district_i6", "type": "esriFieldTypeString" }, { "modelName": "route_number_i7", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "route_number_i7", "length": 10, "alias": "route_number_i7", "type": "esriFieldTypeString" }, { "modelName": "route_direction_i8", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "route_direction_i8", "length": 2, "alias": "route_direction_i8", "type": "esriFieldTypeString" }, { "modelName": "route_type_i9", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "route_type_i9", "length": 2, "alias": "route_type_i9", "type": "esriFieldTypeString" }, { "modelName": "facility_carried_i10", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "facility_carried_i10", "length": 124, "alias": "facility_carried_i10", "type": "esriFieldTypeString" }, { "modelName": "lrs_route_id_i11", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lrs_route_id_i11", "length": 54, "alias": "lrs_route_id_i11", "type": "esriFieldTypeString" }, { "modelName": "lrs_mile_point_i12", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lrs_mile_point_i12", "alias": "lrs_mile_point_i12", "type": "esriFieldTypeDouble" }, { "modelName": "portal_latitude_i13", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portal_latitude_i13", "alias": "portal_latitude_i13", "type": "esriFieldTypeDouble" }, { "modelName": "portal_longitude_i14", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portal_longitude_i14", "alias": "portal_longitude_i14", "type": "esriFieldTypeDouble" }, { "modelName": "border_state_i15", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "border_state_i15", "length": 4, "alias": "border_state_i15", "type": "esriFieldTypeString" }, { "modelName": "border_financial_resp_i16", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "border_financial_resp_i16", "alias": "border_financial_resp_i16", "type": "esriFieldTypeDouble" }, { "modelName": "border_tunnel_number_i17", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "border_tunnel_number_i17", "length": 30, "alias": "border_tunnel_number_i17", "type": "esriFieldTypeString" }, { "modelName": "border_inspection_resp_i18", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "border_inspection_resp_i18", "length": 2, "alias": "border_inspection_resp_i18", "type": "esriFieldTypeString" }, { "modelName": "year_built_a1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_built_a1", "alias": "year_built_a1", "type": "esriFieldTypeDouble" }, { "modelName": "year_rehabilitated_a2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_rehabilitated_a2", "alias": "year_rehabilitated_a2", "type": "esriFieldTypeDouble" }, { "modelName": "total_number_of_lanes_a3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_number_of_lanes_a3", "alias": "total_number_of_lanes_a3", "type": "esriFieldTypeDouble" }, { "modelName": "adt_a4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adt_a4", "alias": "adt_a4", "type": "esriFieldTypeDouble" }, { "modelName": "adtt_a5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "adtt_a5", "alias": "adtt_a5", "type": "esriFieldTypeDouble" }, { "modelName": "year_of_average_daily_traffic_a", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "year_of_average_daily_traffic_a", "alias": "year_of_average_daily_traffic_a6", "type": "esriFieldTypeDouble" }, { "modelName": "detour_length_a7", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "detour_length_a7", "alias": "detour_length_a7", "type": "esriFieldTypeDouble" }, { "modelName": "service_in_tunnel_a8", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_in_tunnel_a8", "alias": "service_in_tunnel_a8", "type": "esriFieldTypeDouble" }, { "modelName": "owner_c1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owner_c1", "alias": "owner_c1", "type": "esriFieldTypeDouble" }, { "modelName": "operator_c2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operator_c2", "alias": "operator_c2", "type": "esriFieldTypeDouble" }, { "modelName": "direction_of_traffic_c3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "direction_of_traffic_c3", "alias": "direction_of_traffic_c3", "type": "esriFieldTypeDouble" }, { "modelName": "toll_c4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "toll_c4", "alias": "toll_c4", "type": "esriFieldTypeDouble" }, { "modelName": "nhs_designation_c5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nhs_designation_c5", "alias": "nhs_designation_c5", "type": "esriFieldTypeDouble" }, { "modelName": "strahnet_designation_c6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "strahnet_designation_c6", "alias": "strahnet_designation_c6", "type": "esriFieldTypeDouble" }, { "modelName": "functional_classification_c7", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "functional_classification_c7", "alias": "functional_classification_c7", "type": "esriFieldTypeDouble" }, { "modelName": "urban_code_c8", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "urban_code_c8", "alias": "urban_code_c8", "type": "esriFieldTypeDouble" }, { "modelName": "tunnel_length_g1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tunnel_length_g1", "alias": "tunnel_length_g1", "type": "esriFieldTypeDouble" }, { "modelName": "min_vert_clearance_over_tunnel_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "min_vert_clearance_over_tunnel_", "alias": "min_vert_clearance_over_tunnel_roadway_g2", "type": "esriFieldTypeDouble" }, { "modelName": "roadway_width_curb_to_curb_g3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roadway_width_curb_to_curb_g3", "alias": "roadway_width_curb_to_curb_g3", "type": "esriFieldTypeDouble" }, { "modelName": "left_sidewalk_width_g4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "left_sidewalk_width_g4", "alias": "left_sidewalk_width_g4", "type": "esriFieldTypeDouble" }, { "modelName": "right_sidewalk_width_g5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "right_sidewalk_width_g5", "alias": "right_sidewalk_width_g5", "type": "esriFieldTypeDouble" }, { "modelName": "routine_inspection_target_date_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "routine_inspection_target_date_", "length": 29, "alias": "routine_inspection_target_date_d1", "type": "esriFieldTypeDate" }, { "modelName": "actual_routine_inspection_date_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_routine_inspection_date_", "length": 29, "alias": "actual_routine_inspection_date_d2", "type": "esriFieldTypeDate" }, { "modelName": "routine_inspection_interval_d3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "routine_inspection_interval_d3", "alias": "routine_inspection_interval_d3", "type": "esriFieldTypeDouble" }, { "modelName": "in_depth_inspection_d4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "in_depth_inspection_d4", "alias": "in_depth_inspection_d4", "type": "esriFieldTypeInteger" }, { "modelName": "damage_inspection_d5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "damage_inspection_d5", "alias": "damage_inspection_d5", "type": "esriFieldTypeDouble" }, { "modelName": "special_inspection_d6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "special_inspection_d6", "alias": "special_inspection_d6", "type": "esriFieldTypeDouble" }, { "modelName": "load_rating_method_l1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "load_rating_method_l1", "length": 2, "alias": "load_rating_method_l1", "type": "esriFieldTypeString" }, { "modelName": "inventory_load_rating_factor_l2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inventory_load_rating_factor_l2", "alias": "inventory_load_rating_factor_l2", "type": "esriFieldTypeDouble" }, { "modelName": "operating_load_rating_factor_l3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "operating_load_rating_factor_l3", "alias": "operating_load_rating_factor_l3", "type": "esriFieldTypeDouble" }, { "modelName": "tunnel_load_posting_status_l4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tunnel_load_posting_status_l4", "length": 2, "alias": "tunnel_load_posting_status_l4", "type": "esriFieldTypeString" }, { "modelName": "posting_load_gross_l5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "posting_load_gross_l5", "alias": "posting_load_gross_l5", "type": "esriFieldTypeDouble" }, { "modelName": "posting_load_axle_l6", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "posting_load_axle_l6", "alias": "posting_load_axle_l6", "type": "esriFieldTypeDouble" }, { "modelName": "posting_load_type_3_l7", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "posting_load_type_3_l7", "alias": "posting_load_type_3_l7", "type": "esriFieldTypeDouble" }, { "modelName": "posting_load_type_3s2_l8", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "posting_load_type_3s2_l8", "alias": "posting_load_type_3S2_l8", "type": "esriFieldTypeDouble" }, { "modelName": "posting_load_type_33_l9", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "posting_load_type_33_l9", "alias": "posting_load_type_33_l9", "type": "esriFieldTypeDouble" }, { "modelName": "height_restriction_l10", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "height_restriction_l10", "alias": "height_restriction_l10", "type": "esriFieldTypeDouble" }, { "modelName": "hazardous_material_restriction_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hazardous_material_restriction_", "alias": "hazardous_material_restriction_l11", "type": "esriFieldTypeDouble" }, { "modelName": "other_restrictions_l12", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "other_restrictions_l12", "alias": "other_restrictions_l12", "type": "esriFieldTypeDouble" }, { "modelName": "under_navigable_waterway_n1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "under_navigable_waterway_n1", "alias": "under_navigable_waterway_n1", "type": "esriFieldTypeDouble" }, { "modelName": "navigable_waterway_clearance_n2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "navigable_waterway_clearance_n2", "alias": "navigable_waterway_clearance_n2", "type": "esriFieldTypeDouble" }, { "modelName": "tunnel_or_portal_island_protect", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tunnel_or_portal_island_protect", "alias": "tunnel_or_portal_island_protection_from_navigation_n3", "type": "esriFieldTypeInteger" }, { "modelName": "number_of_bores_s1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "number_of_bores_s1", "alias": "number_of_bores_s1", "type": "esriFieldTypeDouble" }, { "modelName": "tunnel_shape_s2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tunnel_shape_s2", "alias": "tunnel_shape_s2", "type": "esriFieldTypeDouble" }, { "modelName": "portal_shapes_s3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "portal_shapes_s3", "alias": "portal_shapes_s3", "type": "esriFieldTypeDouble" }, { "modelName": "ground_conditions_s4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ground_conditions_s4", "alias": "ground_conditions_s4", "type": "esriFieldTypeDouble" }, { "modelName": "complex_s5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "complex_s5", "alias": "complex_s5", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "The National Tunnel Inventory dataset was compiled on June 15, 2023 and published on June 30, 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 National Tunnel Inventory (NTI) is a collection of information (database) describing the more than 500 of the Nation's tunnels located on public roads, including Interstate Highways, U.S. highways, State and county roads, as well as publicly-accessible tunnels on Federal lands. The inventory data present a complete picture of the location, description, and classification data for each tunnel, as well as any load rating and inspection information. The element data present a breakdown of the condition of each structural and civil element for each tunnel on the National Highway System (NHS). The Specifications for the National Tunnel Inventory (SNTI) contains a detailed description of each data element including coding instructions and attribute definitions. The Coding Manual is published for each year of data collection; the manual is available at: https://doi.org/10.21949/1519104.", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r5033_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a4550_ix1", "isUnique": false, "description": "", "fields": "shape", "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": "4f573fd47b44455a9bd3544b432192e3", "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": [ 127, 56, 70, 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 } ] }