{ "layers": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 0, "name": "vector_pub.DBO.Streets_Maintenance_Plan", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102743, "latestWkid": 3566, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 68, 65, 130, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -119796900, "ymin": -89212200, "xmax": 1627500.1769606918, "ymax": 7239472.051650688, "spatialReference": { "wkid": 102743, "latestWkid": 3566, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "xyUnits": 3048.0060960121914, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STREETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "REVIEWED", "type": "esriFieldTypeString", "alias": "REVIEWED", "length": 255, "domain": { "type": "codedValue", "name": "GEN-YESNOTEXT", "description": "Gen - Yes/No/Unk Text", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "STREET NAME", "length": 100, "domain": null }, { "name": "FROMSTREET", "type": "esriFieldTypeString", "alias": "FROM STREET", "length": 100, "domain": null }, { "name": "TOSTREET", "type": "esriFieldTypeString", "alias": "TO STREET", "length": 100, "domain": null }, { "name": "STREETFAMILY", "type": "esriFieldTypeString", "alias": "STREET FAMILY", "length": 100, "domain": null }, { "name": "WIDTH", "type": "esriFieldTypeDouble", "alias": "WIDTH", "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null }, { "name": "AREAYARDS", "type": "esriFieldTypeDouble", "alias": "AREA SQ YARDS", "domain": null }, { "name": "LST", "type": "esriFieldTypeString", "alias": "LST", "length": 50, "domain": null }, { "name": "LSTYEAR", "type": "esriFieldTypeString", "alias": "LST YEAR", "length": 50, "domain": null }, { "name": "CONSTRUCTYEAR", "type": "esriFieldTypeString", "alias": "CONSTRUCT YEAR", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "REGION", "type": "esriFieldTypeString", "alias": "REGION", "length": 50, "domain": null }, { "name": "SEGMENTS90", "type": "esriFieldTypeString", "alias": "90 SEGMENTS", "length": 30, "domain": null }, { "name": "SEGMENTS15", "type": "esriFieldTypeString", "alias": "15 SEGMENTS", "length": 30, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 30, "domain": null }, { "name": "DESIGNED_FLOW", "type": "esriFieldTypeString", "alias": "DESIGNED_FLOW", "length": 30, "domain": null }, { "name": "SIMPLENAME", "type": "esriFieldTypeString", "alias": "SIMPLENAME", "length": 20, "domain": null }, { "name": "FLYDATE", "type": "esriFieldTypeDate", "alias": "FLYDATE", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CURRENT_PASER", "type": "esriFieldTypeDouble", "alias": "CURRENT_PASER", "domain": null }, { "name": "TREATMENT_CODE", "type": "esriFieldTypeString", "alias": "TREATMENT_CODE", "length": 5, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "YearLastUpdated", "type": "esriFieldTypeInteger", "alias": "YEAR_LAST_UPDATED", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "FULLNAME", "type": "esriFieldTypeString", "alias": "Full Name", "length": 100, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R265_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_265", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S234_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "vector_pub.DBO.PAVEMENT_StreetHistory", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E20E2AEB-9EC3-4806-BD33-1EFC3190D3FF}" }, { "id": 1, "name": "PAVEMENT_FieldPASER", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{17A9A8FE-F1C2-4EF8-A9F7-C8182EA5F244}" }, { "id": 2, "name": "PAVEMENT_TreatmentRecords", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C461EDAE-8CCD-4CD7-AD31-D0CB25F70440}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "maxSelectionCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102743, "latestWkid": 3566, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 119, 63, 135, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1595553.5764838904, "ymin": 7216888.922604397, "xmax": 1627500.1769606322, "ymax": 7239472.051650643, "spatialReference": { "wkid": 102743, "latestWkid": 3566, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "xyUnits": 3048.0060960121914, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Year", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Streets_GlobalID", "type": "esriFieldTypeGUID", "alias": "Streets_GlobalID", "length": 38, "domain": null }, { "name": "Recommended_Treatment_Code", "type": "esriFieldTypeString", "alias": "Recommended Treatment Code", "length": 50, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Post_Treatment_PASER_Rating", "type": "esriFieldTypeDouble", "alias": "Post Treatment PASER Rating", "domain": null }, { "name": "Treatment_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Cost", "domain": null }, { "name": "Treatment_Linear_Unit_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Linear Unit Cost", "domain": null }, { "name": "Treatment_Linear_Unit", "type": "esriFieldTypeString", "alias": "Treatment Linear Unit", "length": 50, "domain": null }, { "name": "Treatment_Area_Unit_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Area Unit Cost", "domain": null }, { "name": "Treatment_Area_Unit", "type": "esriFieldTypeString", "alias": "Treatment Area Unit", "length": 50, "domain": null }, { "name": "Project_GlobalID", "type": "esriFieldTypeGUID", "alias": "Project_GlobalID", "length": 38, "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "COMPLETED", "type": "esriFieldTypeString", "alias": "Completed?", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STREETFAMILY", "type": "esriFieldTypeString", "alias": "Street Family", "length": 20, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R512_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_512", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S464_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7D2C59D3-7124-48D1-AE4F-C4D9F528C095}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "maxSelectionCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102743, "latestWkid": 3566, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 135, 99, 43, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1595553.5764838904, "ymin": 7216888.922604397, "xmax": 1627500.1769606322, "ymax": 7239472.051650643, "spatialReference": { "wkid": 102743, "latestWkid": 3566, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "xyUnits": 3048.0060960121914, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Year", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Streets_GUID", "type": "esriFieldTypeGUID", "alias": "Streets_GUID", "length": 38, "domain": null }, { "name": "Projects_GUID", "type": "esriFieldTypeGUID", "alias": "Projects_GUID", "length": 38, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "PASER", "type": "esriFieldTypeDouble", "alias": "PASER", "domain": null }, { "name": "Treatment_Recommended", "type": "esriFieldTypeString", "alias": "Treatment Recommended", "length": 3, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Treatment_Completed", "type": "esriFieldTypeString", "alias": "Treatment_Completed", "length": 3, "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R513_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_513", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S465_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{37710214-C39D-4D32-8ED6-42B256A60349}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "maxSelectionCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" } ], "tables": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 3, "name": "PAVEMENT Base Update Log", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Date_Ran", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Date_Ran", "type": "esriFieldTypeDate", "alias": "Date_Ran", "length": 8, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": null }, { "name": "From_Project", "type": "esriFieldTypeString", "alias": "From Project", "length": 100, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R518_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_518", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 4, "name": "DegradationCurvesByYear", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Year", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Streets_GUID", "type": "esriFieldTypeGUID", "alias": "Streets_GUID", "length": 38, "domain": null }, { "name": "Projects_GUID", "type": "esriFieldTypeGUID", "alias": "Projects_GUID", "length": 38, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "PASER", "type": "esriFieldTypeDouble", "alias": "PASER", "domain": null }, { "name": "Treatment_Recommended", "type": "esriFieldTypeString", "alias": "Treatment Recommended", "length": 3, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Treatment_Completed", "type": "esriFieldTypeString", "alias": "Treatment_Completed", "length": 3, "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "length": 255, "domain": null } ], "indexes": [ { "name": "R452_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1062_Project", "fields": "ProjectID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{9C647D67-3F86-4A19-9F1B-24219B2140B7}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 5, "name": "PAVEMENT Field PASER", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PASER", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Streets_GUID", "type": "esriFieldTypeGUID", "alias": "Streets GUID", "length": 38, "domain": null }, { "name": "PASER", "type": "esriFieldTypeInteger", "alias": "PASER", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 1500, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Year_", "type": "esriFieldTypeInteger", "alias": "Year_", "domain": null }, { "name": "FieldDate", "type": "esriFieldTypeDate", "alias": "Field Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R509_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_509", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1580Streets_GUI", "fields": "Streets_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Streets_Maintenance_Plan", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Streets_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{17A9A8FE-F1C2-4EF8-A9F7-C8182EA5F244}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 6, "name": "vector_pub.DBO.PAVEMENT_OverrideTreatments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TreatmentID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TreatmentID", "type": "esriFieldTypeString", "alias": "TreatmentID", "length": 50, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BeginHoldYear", "type": "esriFieldTypeInteger", "alias": "BeginHoldYear", "domain": null }, { "name": "ImplementYear", "type": "esriFieldTypeInteger", "alias": "ImplementYear", "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 1500, "domain": null }, { "name": "ProjectGUID", "type": "esriFieldTypeGUID", "alias": "ProjectGUID", "length": 38, "domain": null }, { "name": "StreetGUID", "type": "esriFieldTypeGUID", "alias": "StreetGUID", "length": 38, "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R508_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_508", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1575_Project", "fields": "ProjectID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{A6F985DB-83B5-4B29-8294-D8EAFBF7894C}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 7, "name": "Projects", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Author", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Author", "type": "esriFieldTypeString", "alias": "Author", "length": 120, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 500, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Budget", "type": "esriFieldTypeDouble", "alias": "Budget", "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "length": 255, "domain": null }, { "name": "NumberOfYears", "type": "esriFieldTypeInteger", "alias": "NumberOfYears", "domain": null }, { "name": "Inflation", "type": "esriFieldTypeDouble", "alias": "Inflation", "domain": null } ], "indexes": [ { "name": "R453_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_453", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_1063_Project", "fields": "ProjectID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "vector_pub.DBO.PAVEMENTDegradationCurvesByYear", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{9C647D67-3F86-4A19-9F1B-24219B2140B7}" }, { "id": 3, "name": "vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7D2C59D3-7124-48D1-AE4F-C4D9F528C095}" }, { "id": 6, "name": "vector_pub.DBO.PAVEMENT_OverrideTreatments", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{A6F985DB-83B5-4B29-8294-D8EAFBF7894C}" }, { "id": 4, "name": "vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{37710214-C39D-4D32-8ED6-42B256A60349}" }, { "id": 7, "name": "vector_pub.DBO.PAVEMENTRecommendedTreatments", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{48489083-329A-4A7F-8CC3-D00E3F495BC6}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 8, "name": "RecommendedTreatments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Year", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Streets_GlobalID", "type": "esriFieldTypeGUID", "alias": "Streets_GlobalID", "length": 38, "domain": null }, { "name": "Recommended_Treatment_Code", "type": "esriFieldTypeString", "alias": "Recommended Treatment Code", "length": 50, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Post_Treatment_PASER_Rating", "type": "esriFieldTypeDouble", "alias": "Post Treatment PASER Rating", "domain": null }, { "name": "Treatment_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Cost", "domain": null }, { "name": "Treatment_Linear_Unit_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Linear Unit Cost", "domain": null }, { "name": "Treatment_Linear_Unit", "type": "esriFieldTypeString", "alias": "Treatment Linear Unit", "length": 50, "domain": null }, { "name": "Treatment_Area_Unit_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Area Unit Cost", "domain": null }, { "name": "Treatment_Area_Unit", "type": "esriFieldTypeString", "alias": "Treatment Area Unit", "length": 50, "domain": null }, { "name": "Project_GlobalID", "type": "esriFieldTypeGUID", "alias": "Project_GlobalID", "length": 38, "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "length": 255, "domain": null } ], "indexes": [ { "name": "R454_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1064_Project", "fields": "ProjectID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ProjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{48489083-329A-4A7F-8CC3-D00E3F495BC6}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 9, "name": "Street History", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Street_GUID", "type": "esriFieldTypeGUID", "alias": "Street_GUID", "length": 38, "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "PASER", "type": "esriFieldTypeDouble", "alias": "PASER", "domain": null }, { "name": "Last_Treatment", "type": "esriFieldTypeString", "alias": "Last Treatment", "length": 10, "domain": { "type": "codedValue", "name": "Recommended Treatment Streets_Recommended_Treatment_Code_5ee288c68e8a44fcac6e3c1137446716", "description": "", "codedValues": [ { "name": "Slurry Seal - Year 1", "code": "R1" }, { "name": "Crack Seal - Year 2", "code": "R2" }, { "name": "Crack Seal & Slurry Seal - Year 6", "code": "R3" }, { "name": "Crack Seal & Slurry Seal - Year 12", "code": "R4" }, { "name": "Mill and Fill - Year 16", "code": "R5" }, { "name": "Crack Seal - Year 18", "code": "R6" }, { "name": "Crack Seal & Slurry Seal - Year 23", "code": "R7" }, { "name": "FDR with Cement Stabilization - Year 40", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Year_", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null } ], "indexes": [ { "name": "R519_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_519", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1598_Street_", "fields": "Street_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "vector_pub.DBO.Streets_Maintenance_Plan", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Street_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E20E2AEB-9EC3-4806-BD33-1EFC3190D3FF}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 10, "name": "vector_pub.DBO.PAVEMENTTreatmentGuidelines", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Family", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Family", "type": "esriFieldTypeString", "alias": "Family", "length": 255, "domain": null }, { "name": "Last_Treatment_Code", "type": "esriFieldTypeString", "alias": "Last Treatment Code", "length": 255, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PASER_1", "type": "esriFieldTypeDouble", "alias": "PASER_1", "domain": null }, { "name": "PASER_2", "type": "esriFieldTypeDouble", "alias": "PASER_2", "domain": null }, { "name": "Override_Exclusion", "type": "esriFieldTypeString", "alias": "Override Exclusion", "length": 255, "domain": null }, { "name": "Recommended_Treatment_Code", "type": "esriFieldTypeString", "alias": "Recommended Treatment Code", "length": 255, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Reduction_in_Apparent_Age_Year", "type": "esriFieldTypeString", "alias": "Reduction_in_Apparent_Age_Year", "length": 255, "domain": null }, { "name": "Resulting_PASER", "type": "esriFieldTypeDouble", "alias": "Resulting PASER", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "AGE_1", "type": "esriFieldTypeDouble", "alias": "AGE_1", "domain": null }, { "name": "AGE_2", "type": "esriFieldTypeDouble", "alias": "AGE_2", "domain": null }, { "name": "New_Apparent_Age", "type": "esriFieldTypeDouble", "alias": "New Apparent Age", "domain": null } ], "indexes": [ { "name": "R455_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_455", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 11, "name": "vector_pub.DBO.PAVEMENTTreatmentLookup", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Family", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Family", "type": "esriFieldTypeString", "alias": "Family", "length": 255, "domain": null }, { "name": "Treatment", "type": "esriFieldTypeString", "alias": "Treatment", "length": 255, "domain": null }, { "name": "Treatment_Code", "type": "esriFieldTypeString", "alias": "Treatment Code", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Linear_Cost", "type": "esriFieldTypeDouble", "alias": "Linear Cost", "domain": null }, { "name": "Linear_Units", "type": "esriFieldTypeString", "alias": "Linear Units", "length": 50, "domain": null }, { "name": "Area_Cost", "type": "esriFieldTypeDouble", "alias": "Area Cost", "domain": null }, { "name": "Area_Units", "type": "esriFieldTypeString", "alias": "Area Units", "length": 50, "domain": null } ], "indexes": [ { "name": "R466_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_466", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 12, "name": "Treatment Records", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Treatment_Type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Streets_GUID", "type": "esriFieldTypeGUID", "alias": "Streets GUID", "length": 38, "domain": null }, { "name": "Treatment_Type", "type": "esriFieldTypeString", "alias": "Treatment Type", "length": 50, "domain": { "type": "codedValue", "name": "PAVEMENT_TREATMENT", "description": "PAVEMENT TREATMENT", "codedValues": [ { "name": "Commercial Crack seal at yr 4", "code": "C1" }, { "name": "Commercial Crack seal and chip seal at yr 8", "code": "C2" }, { "name": "Commercial Crack seal at yr 15", "code": "C3" }, { "name": "Commercial Mill and fill at yr 25", "code": "C4" }, { "name": "Commercial Crack seal and chip seal at yr 37", "code": "C5" }, { "name": "Minor Collector Crack Seal and Micro Type III at yr 7", "code": "MC2" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 13", "code": "MC3" }, { "name": "Minor Collector Crack seal and Micro Type III at yr 19", "code": "MC4" }, { "name": "Residential Crack seal at yr 3", "code": "R1" }, { "name": "Residential Crack seal and microsurface at yr 7", "code": "R2" }, { "name": "Residential Crack seal and microsurface at yr 14", "code": "R3" }, { "name": "Residential Crack seal and microsurface at yr 21", "code": "R4" }, { "name": "Residential Crack seal and microsurface at yr 35", "code": "R6" }, { "name": "Reconstruct", "code": "0" }, { "name": "Minor Collector Crack seal at yr 3", "code": "MC1" }, { "name": "Mill and fill at yr 28", "code": "R5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "Pre_Treatment_PASER", "type": "esriFieldTypeDouble", "alias": "Pre Treatment PASER", "domain": null }, { "name": "Post_Treatment_PASER", "type": "esriFieldTypeDouble", "alias": "Post Treatment PASER", "domain": null }, { "name": "Treatment_Notes", "type": "esriFieldTypeString", "alias": "Treatment Notes", "length": 2000, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Year_", "type": "esriFieldTypeInteger", "alias": "Year_", "domain": null }, { "name": "TreatmentDate", "type": "esriFieldTypeDate", "alias": "Treatment Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R511_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_511", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1582Streets_GUI", "fields": "Streets_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Streets_Maintenance_Plan", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Streets_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C461EDAE-8CCD-4CD7-AD31-D0CB25F70440}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 13, "name": "vector_pub.DBO.PAVEMENTYearlySummary", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Year", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "FREQUENCY", "type": "esriFieldTypeInteger", "alias": "FREQUENCY", "domain": null }, { "name": "MEAN_PASER", "type": "esriFieldTypeDouble", "alias": "MEAN_PASER", "domain": null } ], "indexes": [ { "name": "R458_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "90b47a73209f47e3a28b2415f81eb656" } ] }