{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Pavement Maintenance", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102679, "latestWkid": 2246, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120428400, "falseY": -95345400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "maintenance_suggestion", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 56, 168, 0, 255 ], "width": 2 }, "value": "Defer Maintenance", "label": "Defer Maintenance" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 2 }, "value": "Preventive Maintenance", "label": "Preventive Maintenance" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 2 }, "value": "Rehabilitation", "label": "Rehabilitation" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 170, 0, 255 ], "width": 2 }, "value": "Reclamation", "label": "Reclamation" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 40, 158, 144, 255 ], "toColor": [ 40, 158, 144, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 90, 46, 201, 255 ], "toColor": [ 90, 46, 201, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 196, 70, 51, 255 ], "toColor": [ 196, 70, 51, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 175, 194, 50, 255 ], "toColor": [ 175, 194, 50, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 199, 64, 152, 255 ], "toColor": [ 199, 64, 152, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 46, 102, 176, 255 ], "toColor": [ 46, 102, 176, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 153, 121, 61, 255 ], "toColor": [ 153, 121, 61, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 35, 168, 75, 255 ], "toColor": [ 35, 168, 75, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 153, 43, 72, 255 ], "toColor": [ 153, 43, 72, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 171, 39, 186, 255 ], "toColor": [ 171, 39, 186, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 42, 72, 181, 255 ], "toColor": [ 42, 72, 181, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 44, 133, 163, 255 ], "toColor": [ 44, 133, 163, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 52, 201, 46, 255 ], "toColor": [ 52, 201, 46, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -86.29887459345815, "ymin": 37.994868635562334, "xmax": -85.31532603118471, "ymax": 38.56203058023731, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "streetname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "streetname", "type": "esriFieldTypeString", "alias": "Street Name", "length": 50, "domain": null }, { "name": "fromstreetname", "type": "esriFieldTypeString", "alias": "From Street Name", "length": 50, "domain": null }, { "name": "tostreetname", "type": "esriFieldTypeString", "alias": "To Street Name", "length": 50, "domain": null }, { "name": "pci", "type": "esriFieldTypeSmallInteger", "alias": "PCI", "domain": null }, { "name": "maintenance_suggestion", "type": "esriFieldTypeString", "alias": "Maintenance Suggestion", "length": 50, "domain": null }, { "name": "estimated_cost", "type": "esriFieldTypeInteger", "alias": "Estimate Cost ($)", "domain": null }, { "name": "repair_priority", "type": "esriFieldTypeDouble", "alias": "Repair Priority", "domain": null }, { "name": "functional_class", "type": "esriFieldTypeString", "alias": "Functional Class", "length": 50, "domain": null }, { "name": "functional_class_id", "type": "esriFieldTypeSmallInteger", "alias": "Functional Class ID", "domain": null }, { "name": "surface_type", "type": "esriFieldTypeString", "alias": "Surface Type", "length": 50, "domain": null }, { "name": "survey_date", "type": "esriFieldTypeString", "alias": "Survey Date", "length": 50, "domain": null }, { "name": "width_ft", "type": "esriFieldTypeDouble", "alias": "Width (ft)", "domain": null }, { "name": "length_ft", "type": "esriFieldTypeInteger", "alias": "Length (ft)", "domain": null }, { "name": "area_sy", "type": "esriFieldTypeDouble", "alias": "Area (sy)", "domain": null }, { "name": "last_repair_method", "type": "esriFieldTypeString", "alias": "Last Repair Method", "length": 50, "domain": null }, { "name": "last_repair_cost", "type": "esriFieldTypeInteger", "alias": "Last Repair Cost", "domain": null }, { "name": "last_repair_date", "type": "esriFieldTypeDate", "alias": "Last Repair Date", "length": 8, "domain": null }, { "name": "future_event", "type": "esriFieldTypeString", "alias": "Future Event", "length": 50, "domain": null }, { "name": "future_event_date", "type": "esriFieldTypeDate", "alias": "Future Event Date", "length": 8, "domain": null }, { "name": "editor_note", "type": "esriFieldTypeString", "alias": "Editor Notes", "length": 100, "domain": null }, { "name": "editor_name", "type": "esriFieldTypeString", "alias": "Editor Name", "length": 50, "domain": null }, { "name": "editor_id", "type": "esriFieldTypeInteger", "alias": "Editor ID", "domain": null }, { "name": "last_edit", "type": "esriFieldTypeDate", "alias": "Last Edit", "length": 8, "domain": null }, { "name": "ss_id", "type": "esriFieldTypeInteger", "alias": "SS ID", "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "rwcompkey", "type": "esriFieldTypeInteger", "alias": "RWCOMPKEY", "domain": null }, { "name": "main_dist", "type": "esriFieldTypeString", "alias": "MAIN_DIST", "length": 10, "domain": null }, { "name": "owner_name", "type": "esriFieldTypeString", "alias": "OWNER_NAME", "length": 40, "domain": null }, { "name": "main_resp", "type": "esriFieldTypeString", "alias": "MAIN_RESP", "length": 14, "domain": null }, { "name": "pci2015", "type": "esriFieldTypeDouble", "alias": "PCI2015", "domain": null }, { "name": "pci2013", "type": "esriFieldTypeInteger", "alias": "PCI2013", "domain": null }, { "name": "council_district", "type": "esriFieldTypeString", "alias": "Council District", "length": 50, "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null }, { "name": "st_length(shape)", "type": "esriFieldTypeDouble", "alias": "st_length(shape)", "domain": null }, { "name": "management_section", "type": "esriFieldTypeSmallInteger", "alias": "managament section", "domain": null }, { "name": "start_date_ss", "type": "esriFieldTypeDate", "alias": "start_date_ss", "length": 8, "domain": null }, { "name": "end_date_ss", "type": "esriFieldTypeDate", "alias": "end_date_ss", "length": 8, "domain": null }, { "name": "objectid_slx", "type": "esriFieldTypeInteger", "alias": "objectid_slx", "domain": null }, { "name": "clx_uid", "type": "esriFieldTypeInteger", "alias": "clx_uid", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape" }, "indexes": [ { "name": "pavement_evaluation_loc_clx_uid_key", "fields": "clx_uid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "pavement_evaluation_loc_ss_id_2025_07_01_unique", "fields": "ss_id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "r40_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a25_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "st_length(shape)", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "Sidewalk Maintenance", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102679, "latestWkid": 2246, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120428400, "falseY": -95345400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "maintenance_suggestion", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 38, 115, 0, 255 ], "width": 1.7 }, "value": "Defer Maintenance", "label": "Defer Maintenance" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 197, 255, 255 ], "width": 1.7 }, "value": "Brick Paver Reset", "label": "Paver Reset (Brick)" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 92, 230, 255 ], "width": 1.7 }, "value": "Partial Replacement", "label": "Partial Replacement (Concrete)" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 169, 0, 230, 255 ], "width": 1.7 }, "value": "Grinding", "label": "Grinding (Concrete)" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 76, 0, 255 ], "width": 1.7 }, "value": "Patch Repair", "label": "Patch Repair (Asphalt)" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 250, 52, 17, 255 ], "width": 1.7 }, "value": "Reconstruction", "label": "Reconstruction" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 76, 0, 115, 255 ], "width": 1.7 }, "value": "Other", "label": "Other" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 0, 115, 10, 255 ], "toColor": [ 244, 255, 43, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 244, 255, 43, 255 ], "toColor": [ 255, 63, 15, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -85.91121059160263, "ymin": 38.051605822035064, "xmax": -85.40671239774899, "ymax": 38.34251241461247, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "streetname", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "streetname", "type": "esriFieldTypeString", "alias": "Street Name", "length": 50, "domain": null }, { "name": "fromstreetname", "type": "esriFieldTypeString", "alias": "From Street Name", "length": 50, "domain": null }, { "name": "tostreetname", "type": "esriFieldTypeString", "alias": "To Street Name", "length": 50, "domain": null }, { "name": "sci", "type": "esriFieldTypeSmallInteger", "alias": "SCI", "domain": null }, { "name": "maintenance_suggestion", "type": "esriFieldTypeString", "alias": "Maintenance Suggestion", "length": 50, "domain": null }, { "name": "estimated_cost", "type": "esriFieldTypeInteger", "alias": "Estimated Cost ", "domain": null }, { "name": "repair_priority", "type": "esriFieldTypeDouble", "alias": "Repair Priority", "domain": null }, { "name": "functional_class", "type": "esriFieldTypeString", "alias": "Functional Class", "length": 50, "domain": null }, { "name": "functional_class_id", "type": "esriFieldTypeSmallInteger", "alias": "Functional Class ID", "domain": null }, { "name": "surface_type", "type": "esriFieldTypeString", "alias": "Surface Type", "length": 50, "domain": null }, { "name": "width_ft", "type": "esriFieldTypeDouble", "alias": "Width (ft)", "domain": null }, { "name": "length_ft", "type": "esriFieldTypeInteger", "alias": "Length (ft)", "domain": null }, { "name": "notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 150, "domain": null }, { "name": "survey_date", "type": "esriFieldTypeDate", "alias": "Survey Date", "length": 8, "domain": null }, { "name": "video", "type": "esriFieldTypeString", "alias": "Video", "length": 250, "domain": null }, { "name": "last_repair_method", "type": "esriFieldTypeString", "alias": "Last Repair Method", "length": 50, "domain": null }, { "name": "last_repair_cost", "type": "esriFieldTypeInteger", "alias": "Last Repair Cost", "domain": null }, { "name": "last_repair_date", "type": "esriFieldTypeDate", "alias": "Last Repair Date", "length": 8, "domain": null }, { "name": "council_district", "type": "esriFieldTypeString", "alias": "Council District", "length": 5, "domain": null }, { "name": "future_event", "type": "esriFieldTypeString", "alias": "Future Event", "length": 50, "domain": null }, { "name": "future_event_date", "type": "esriFieldTypeDate", "alias": "Future Event Date", "length": 8, "domain": null }, { "name": "editor_note", "type": "esriFieldTypeString", "alias": "Editor Note", "length": 100, "domain": null }, { "name": "editor_name", "type": "esriFieldTypeString", "alias": "Editor Name", "length": 50, "domain": null }, { "name": "editor_id", "type": "esriFieldTypeInteger", "alias": "Editor ID", "domain": null }, { "name": "last_edit", "type": "esriFieldTypeDate", "alias": "Last Edit", "length": 8, "domain": null }, { "name": "ss_id", "type": "esriFieldTypeInteger", "alias": "SS_ID", "domain": null }, { "name": "file", "type": "esriFieldTypeString", "alias": "File", "length": 6, "domain": null }, { "name": "max_max_roughn", "type": "esriFieldTypeDouble", "alias": "Max Segment Roughness", "domain": null }, { "name": "max_max_runnin", "type": "esriFieldTypeDouble", "alias": "Max Segment Running Slope", "domain": null }, { "name": "max_max_cross_", "type": "esriFieldTypeDouble", "alias": "Max Segment Cross Slope", "domain": null }, { "name": "max_max_trips_", "type": "esriFieldTypeDouble", "alias": "Max Segment Trip Height", "domain": null }, { "name": "max_num_trips", "type": "esriFieldTypeDouble", "alias": "Max Segment Trips", "domain": null }, { "name": "mean_run_rai", "type": "esriFieldTypeDouble", "alias": "Average Run RAI", "domain": null }, { "name": "sum_total_disp", "type": "esriFieldTypeDouble", "alias": "Total Height of Displacements", "domain": null }, { "name": "sum_total_trip", "type": "esriFieldTypeDouble", "alias": "Total Height of Trips", "domain": null }, { "name": "mean_segment_ra", "type": "esriFieldTypeDouble", "alias": "Average Segment RAI", "domain": null }, { "name": "mean_segment__1", "type": "esriFieldTypeDouble", "alias": "Average Segment 1", "domain": null }, { "name": "max_run_rai_lm", "type": "esriFieldTypeDouble", "alias": "Max Run RAI", "domain": null }, { "name": "max_max_dep_in", "type": "esriFieldTypeDouble", "alias": "Max Depth", "domain": null }, { "name": "sum_num_dep", "type": "esriFieldTypeDouble", "alias": "Number of Depressions", "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape", "domain": null }, { "name": "st_length(shape)", "type": "esriFieldTypeDouble", "alias": "st_length(shape)", "domain": null }, { "name": "start_date_ss", "type": "esriFieldTypeDate", "alias": "start_date_ss", "length": 8, "domain": null }, { "name": "end_date_ss", "type": "esriFieldTypeDate", "alias": "end_date_ss", "length": 8, "domain": null }, { "name": "objectid_slx", "type": "esriFieldTypeInteger", "alias": "objectid_slx", "domain": null }, { "name": "sw_id", "type": "esriFieldTypeInteger", "alias": "sw_id", "domain": null }, { "name": "clx_uid", "type": "esriFieldTypeInteger", "alias": "clx_uid", "domain": null }, { "name": "area_sy", "type": "esriFieldTypeDouble", "alias": "area_sy", "domain": null }, { "name": "zip", "type": "esriFieldTypeString", "alias": "zip", "length": 1073741822, "domain": null }, { "name": "management_section", "type": "esriFieldTypeSmallInteger", "alias": "Management Section Id", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "shape" }, "indexes": [ { "name": "r32_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "sidewalk_evaluation_loc_clx_uid_key", "fields": "clx_uid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "sidewalk_evaluation_loc_sw_id_2025_02_10_unique", "fields": "sw_id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a17_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "st_length(shape)", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Management Sections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "editor_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "id", "type": "esriFieldTypeOID", "alias": "id", "domain": null }, { "name": "ms_id", "type": "esriFieldTypeInteger", "alias": "ms_id", "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 60000, "domain": null }, { "name": "asset", "type": "esriFieldTypeString", "alias": "asset", "length": 255, "domain": null }, { "name": "surface_type", "type": "esriFieldTypeString", "alias": "surface_type", "length": 255, "domain": null }, { "name": "functional_class", "type": "esriFieldTypeString", "alias": "functional_class", "length": 255, "domain": null }, { "name": "object_ids", "type": "esriFieldTypeString", "alias": "object_ids", "length": 60000, "domain": null }, { "name": "total_length", "type": "esriFieldTypeInteger", "alias": "total_length", "domain": null }, { "name": "average_width", "type": "esriFieldTypeInteger", "alias": "average_width", "domain": null }, { "name": "blended_ci", "type": "esriFieldTypeSmallInteger", "alias": "blended_ci", "domain": null }, { "name": "estimated_cost", "type": "esriFieldTypeInteger", "alias": "estimated_cost", "domain": null }, { "name": "repair_priority", "type": "esriFieldTypeDouble", "alias": "repair_priority", "domain": null }, { "name": "editor_id", "type": "esriFieldTypeInteger", "alias": "editor_id", "domain": null }, { "name": "editor_name", "type": "esriFieldTypeString", "alias": "editor_name", "length": 255, "domain": null }, { "name": "created_at", "type": "esriFieldTypeDate", "alias": "created_at", "length": 8, "domain": null }, { "name": "updated_at", "type": "esriFieldTypeDate", "alias": "updated_at", "length": 8, "domain": null } ], "indexes": [ { "name": "management_sections_loc_pkey", "fields": "id", "isAscending": true, "isUnique": true, "description": "" }, { "name": "msl_asset", "fields": "asset", "isAscending": true, "isUnique": false, "description": "" }, { "name": "msl_functional_class", "fields": "functional_class", "isAscending": true, "isUnique": false, "description": "" }, { "name": "msl_surface_type", "fields": "surface_type", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_id", "fields": "id", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }