{ "layers": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 0, "name": "vector_pub.DBO.Streets_Maintenance_Plan", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "vector_pub.DBO.PAVEMENT_StreetHistory", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{E20E2AEB-9EC3-4806-BD33-1EFC3190D3FF}" }, { "id": 1, "name": "PAVEMENT_FieldPASER", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{17A9A8FE-F1C2-4EF8-A9F7-C8182EA5F244}" }, { "id": 2, "name": "PAVEMENT_TreatmentRecords", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{C461EDAE-8CCD-4CD7-AD31-D0CB25F70440}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 68, 65, 130, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "STREETNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "REVIEWED", "type": "esriFieldTypeString", "alias": "REVIEWED", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "REVIEWED" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "STREET NAME", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "STREETNAME" }, { "name": "FROMSTREET", "type": "esriFieldTypeString", "alias": "FROM STREET", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FROMSTREET" }, { "name": "TOSTREET", "type": "esriFieldTypeString", "alias": "TO STREET", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "TOSTREET" }, { "name": "STREETFAMILY", "type": "esriFieldTypeString", "alias": "STREET FAMILY", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "STREETFAMILY" }, { "name": "WIDTH", "type": "esriFieldTypeDouble", "alias": "WIDTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WIDTH" }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LENGTH" }, { "name": "AREAYARDS", "type": "esriFieldTypeDouble", "alias": "AREA SQ YARDS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AREAYARDS" }, { "name": "LST", "type": "esriFieldTypeString", "alias": "LST", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LST" }, { "name": "LSTYEAR", "type": "esriFieldTypeString", "alias": "LST YEAR", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LSTYEAR" }, { "name": "CONSTRUCTYEAR", "type": "esriFieldTypeString", "alias": "CONSTRUCT YEAR", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONSTRUCTYEAR" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "REGION", "type": "esriFieldTypeString", "alias": "REGION", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "REGION" }, { "name": "SEGMENTS90", "type": "esriFieldTypeString", "alias": "90 SEGMENTS", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SEGMENTS90" }, { "name": "SEGMENTS15", "type": "esriFieldTypeString", "alias": "15 SEGMENTS", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SEGMENTS15" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "STATUS" }, { "name": "DESIGNED_FLOW", "type": "esriFieldTypeString", "alias": "DESIGNED_FLOW", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "DESIGNED_FLOW" }, { "name": "SIMPLENAME", "type": "esriFieldTypeString", "alias": "SIMPLENAME", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SIMPLENAME" }, { "name": "FLYDATE", "type": "esriFieldTypeDate", "alias": "FLYDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FLYDATE" }, { "name": "CURRENT_PASER", "type": "esriFieldTypeDouble", "alias": "CURRENT_PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CURRENT_PASER" }, { "name": "TREATMENT_CODE", "type": "esriFieldTypeString", "alias": "TREATMENT_CODE", "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" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "TREATMENT_CODE" }, { "name": "YearLastUpdated", "type": "esriFieldTypeInteger", "alias": "YEAR_LAST_UPDATED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YearLastUpdated" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "FULLNAME", "type": "esriFieldTypeString", "alias": "Full Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FULLNAME" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "vector_pub.DBO.Streets_Maintenance_Plan", "description": "", "prototype": { "attributes": { "TREATMENT_CODE": null, "REVIEWED": null, "YearLastUpdated": null, "STREETNAME": null, "FROMSTREET": null, "TOSTREET": null, "STREETFAMILY": null, "WIDTH": null, "LENGTH": null, "AREAYARDS": null, "LST": null, "LSTYEAR": null, "CONSTRUCTYEAR": null, "FULLNAME": null, "REGION": null, "SEGMENTS90": null, "SEGMENTS15": null, "STATUS": null, "DESIGNED_FLOW": null, "SIMPLENAME": null, "FLYDATE": null, "CURRENT_PASER": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ProjectID", "composite": true, "catalogID": "{7D2C59D3-7124-48D1-AE4F-C4D9F528C095}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 119, 63, 135, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Year", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "Streets_GlobalID", "type": "esriFieldTypeGUID", "alias": "Streets_GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Streets_GlobalID" }, { "name": "Recommended_Treatment_Code", "type": "esriFieldTypeString", "alias": "Recommended Treatment Code", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Recommended_Treatment_Code" }, { "name": "Post_Treatment_PASER_Rating", "type": "esriFieldTypeDouble", "alias": "Post Treatment PASER Rating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Post_Treatment_PASER_Rating" }, { "name": "Treatment_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Treatment_Cost" }, { "name": "Treatment_Linear_Unit_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Linear Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Treatment_Linear_Unit_Cost" }, { "name": "Treatment_Linear_Unit", "type": "esriFieldTypeString", "alias": "Treatment Linear Unit", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Treatment_Linear_Unit" }, { "name": "Treatment_Area_Unit_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Area Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Treatment_Area_Unit_Cost" }, { "name": "Treatment_Area_Unit", "type": "esriFieldTypeString", "alias": "Treatment Area Unit", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Treatment_Area_Unit" }, { "name": "Project_GlobalID", "type": "esriFieldTypeGUID", "alias": "Project_GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Project_GlobalID" }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "COMPLETED", "type": "esriFieldTypeString", "alias": "Completed?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "COMPLETED" }, { "name": "STREETFAMILY", "type": "esriFieldTypeString", "alias": "Street Family", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "STREETFAMILY" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS", "description": "", "prototype": { "attributes": { "COMPLETED": null, "STREETFAMILY": null, "Year": null, "Streets_GlobalID": null, "Recommended_Treatment_Code": null, "Post_Treatment_PASER_Rating": null, "Treatment_Cost": null, "Treatment_Linear_Unit_Cost": null, "Treatment_Linear_Unit": null, "Treatment_Area_Unit_Cost": null, "Treatment_Area_Unit": null, "Project_GlobalID": null, "ProjectID": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ProjectID", "composite": true, "catalogID": "{37710214-C39D-4D32-8ED6-42B256A60349}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 135, 99, 43, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Year", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Streets_GUID", "type": "esriFieldTypeGUID", "alias": "Streets_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Streets_GUID" }, { "name": "Projects_GUID", "type": "esriFieldTypeGUID", "alias": "Projects_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Projects_GUID" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "PASER", "type": "esriFieldTypeDouble", "alias": "PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PASER" }, { "name": "Treatment_Recommended", "type": "esriFieldTypeString", "alias": "Treatment Recommended", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Treatment_Recommended" }, { "name": "Treatment_Completed", "type": "esriFieldTypeString", "alias": "Treatment_Completed", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Treatment_Completed" }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS", "description": "", "prototype": { "attributes": { "Treatment_Completed": null, "ProjectID": null, "Streets_GUID": null, "Projects_GUID": null, "Year": null, "PASER": null, "Treatment_Recommended": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" } ], "tables": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 3, "name": "PAVEMENT Base Update Log", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Date_Ran", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Date_Ran", "type": "esriFieldTypeDate", "alias": "Date_Ran", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Ran" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Status" }, { "name": "From_Project", "type": "esriFieldTypeString", "alias": "From Project", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "From_Project" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R518_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_518", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PAVEMENT Base Update Log", "description": "", "prototype": { "attributes": { "From_Project": null, "Status": null, "Date_Ran": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 4, "name": "DegradationCurvesByYear", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 5, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ProjectID", "composite": true, "catalogID": "{9C647D67-3F86-4A19-9F1B-24219B2140B7}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Year", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Streets_GUID", "type": "esriFieldTypeGUID", "alias": "Streets_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Streets_GUID" }, { "name": "Projects_GUID", "type": "esriFieldTypeGUID", "alias": "Projects_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Projects_GUID" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "PASER", "type": "esriFieldTypeDouble", "alias": "PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PASER" }, { "name": "Treatment_Recommended", "type": "esriFieldTypeString", "alias": "Treatment Recommended", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Treatment_Recommended" }, { "name": "Treatment_Completed", "type": "esriFieldTypeString", "alias": "Treatment_Completed", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Treatment_Completed" }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectID" } ], "indexes": [ { "name": "R452_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1062_Project", "fields": "ProjectID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "DegradationCurvesByYear", "description": "", "prototype": { "attributes": { "Treatment_Completed": null, "ProjectID": null, "Streets_GUID": null, "Projects_GUID": null, "Year": null, "PASER": null, "Treatment_Recommended": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 5, "name": "PAVEMENT Field PASER", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "Streets_Maintenance_Plan", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Streets_GUID", "composite": false, "catalogID": "{17A9A8FE-F1C2-4EF8-A9F7-C8182EA5F244}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PASER", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Streets_GUID", "type": "esriFieldTypeGUID", "alias": "Streets GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Streets_GUID" }, { "name": "PASER", "type": "esriFieldTypeInteger", "alias": "PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PASER" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 1500, "defaultValue": null, "modelName": "Notes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Year_", "type": "esriFieldTypeInteger", "alias": "Year_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year_" }, { "name": "FieldDate", "type": "esriFieldTypeDate", "alias": "Field Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FieldDate" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PAVEMENT Field PASER", "description": "", "prototype": { "attributes": { "Year_": null, "FieldDate": null, "Streets_GUID": null, "PASER": null, "Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 6, "name": "vector_pub.DBO.PAVEMENT_OverrideTreatments", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ProjectID", "composite": true, "catalogID": "{A6F985DB-83B5-4B29-8294-D8EAFBF7894C}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "TreatmentID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TreatmentID", "type": "esriFieldTypeString", "alias": "TreatmentID", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TreatmentID" }, { "name": "BeginHoldYear", "type": "esriFieldTypeInteger", "alias": "BeginHoldYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BeginHoldYear" }, { "name": "ImplementYear", "type": "esriFieldTypeInteger", "alias": "ImplementYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ImplementYear" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 1500, "defaultValue": null, "modelName": "Notes" }, { "name": "ProjectGUID", "type": "esriFieldTypeGUID", "alias": "ProjectGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "ProjectGUID" }, { "name": "StreetGUID", "type": "esriFieldTypeGUID", "alias": "StreetGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "StreetGUID" }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "vector_pub.DBO.PAVEMENT_OverrideTreatments", "description": "", "prototype": { "attributes": { "ProjectID": null, "StreetGUID": null, "TreatmentID": null, "BeginHoldYear": null, "ImplementYear": null, "Notes": null, "ProjectGUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 7, "name": "Projects", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 5, "name": "vector_pub.DBO.PAVEMENTDegradationCurvesByYear", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ProjectID", "composite": true, "catalogID": "{9C647D67-3F86-4A19-9F1B-24219B2140B7}" }, { "id": 3, "name": "vector_pub.DBO.PAVEMENT_RECOMMENDED_TREATMENT_STREETS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ProjectID", "composite": true, "catalogID": "{7D2C59D3-7124-48D1-AE4F-C4D9F528C095}" }, { "id": 6, "name": "vector_pub.DBO.PAVEMENT_OverrideTreatments", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ProjectID", "composite": true, "catalogID": "{A6F985DB-83B5-4B29-8294-D8EAFBF7894C}" }, { "id": 4, "name": "vector_pub.DBO.PAVEMENT_DEGRADATION_CURVE_STREETS", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ProjectID", "composite": true, "catalogID": "{37710214-C39D-4D32-8ED6-42B256A60349}" }, { "id": 7, "name": "vector_pub.DBO.PAVEMENTRecommendedTreatments", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "ProjectID", "composite": true, "catalogID": "{48489083-329A-4A7F-8CC3-D00E3F495BC6}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Author", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Author", "type": "esriFieldTypeString", "alias": "Author", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "Author" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Description" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Budget", "type": "esriFieldTypeDouble", "alias": "Budget", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Budget" }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectID" }, { "name": "NumberOfYears", "type": "esriFieldTypeInteger", "alias": "NumberOfYears", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumberOfYears" }, { "name": "Inflation", "type": "esriFieldTypeDouble", "alias": "Inflation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Inflation" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Projects", "description": "", "prototype": { "attributes": { "NumberOfYears": null, "ProjectID": null, "Author": null, "Year": null, "Description": null, "Inflation": null, "Budget": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 8, "name": "RecommendedTreatments", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 7, "name": "vector_pub.DBO.PAVEMENTProjects", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ProjectID", "composite": true, "catalogID": "{48489083-329A-4A7F-8CC3-D00E3F495BC6}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Year", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "Streets_GlobalID", "type": "esriFieldTypeGUID", "alias": "Streets_GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Streets_GlobalID" }, { "name": "Recommended_Treatment_Code", "type": "esriFieldTypeString", "alias": "Recommended Treatment Code", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Recommended_Treatment_Code" }, { "name": "Post_Treatment_PASER_Rating", "type": "esriFieldTypeDouble", "alias": "Post Treatment PASER Rating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Post_Treatment_PASER_Rating" }, { "name": "Treatment_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Treatment_Cost" }, { "name": "Treatment_Linear_Unit_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Linear Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Treatment_Linear_Unit_Cost" }, { "name": "Treatment_Linear_Unit", "type": "esriFieldTypeString", "alias": "Treatment Linear Unit", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Treatment_Linear_Unit" }, { "name": "Treatment_Area_Unit_Cost", "type": "esriFieldTypeDouble", "alias": "Treatment Area Unit Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Treatment_Area_Unit_Cost" }, { "name": "Treatment_Area_Unit", "type": "esriFieldTypeString", "alias": "Treatment Area Unit", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Treatment_Area_Unit" }, { "name": "Project_GlobalID", "type": "esriFieldTypeGUID", "alias": "Project_GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Project_GlobalID" }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProjectID" } ], "indexes": [ { "name": "R454_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1064_Project", "fields": "ProjectID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "RecommendedTreatments", "description": "", "prototype": { "attributes": { "Project_GlobalID": null, "ProjectID": null, "Year": null, "Streets_GlobalID": null, "Recommended_Treatment_Code": null, "Post_Treatment_PASER_Rating": null, "Treatment_Cost": null, "Treatment_Linear_Unit_Cost": null, "Treatment_Linear_Unit": null, "Treatment_Area_Unit_Cost": null, "Treatment_Area_Unit": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 9, "name": "Street History", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "vector_pub.DBO.Streets_Maintenance_Plan", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Street_GUID", "composite": false, "catalogID": "{E20E2AEB-9EC3-4806-BD33-1EFC3190D3FF}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Street_GUID", "type": "esriFieldTypeGUID", "alias": "Street_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Street_GUID" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "PASER", "type": "esriFieldTypeDouble", "alias": "PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PASER" }, { "name": "Last_Treatment", "type": "esriFieldTypeString", "alias": "Last Treatment", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Last_Treatment" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Year_", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year_" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Street History", "description": "", "prototype": { "attributes": { "Last_Treatment": null, "Year_": null, "Street_GUID": null, "Date": null, "PASER": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 10, "name": "vector_pub.DBO.PAVEMENTTreatmentGuidelines", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Family", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Family", "type": "esriFieldTypeString", "alias": "Family", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Family" }, { "name": "Last_Treatment_Code", "type": "esriFieldTypeString", "alias": "Last Treatment Code", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Last_Treatment_Code" }, { "name": "PASER_1", "type": "esriFieldTypeDouble", "alias": "PASER_1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PASER_1" }, { "name": "PASER_2", "type": "esriFieldTypeDouble", "alias": "PASER_2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PASER_2" }, { "name": "Override_Exclusion", "type": "esriFieldTypeString", "alias": "Override Exclusion", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Override_Exclusion" }, { "name": "Recommended_Treatment_Code", "type": "esriFieldTypeString", "alias": "Recommended Treatment Code", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Recommended_Treatment_Code" }, { "name": "Reduction_in_Apparent_Age_Year", "type": "esriFieldTypeString", "alias": "Reduction_in_Apparent_Age_Year", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Reduction_in_Apparent_Age_Year" }, { "name": "Resulting_PASER", "type": "esriFieldTypeDouble", "alias": "Resulting PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Resulting_PASER" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "AGE_1", "type": "esriFieldTypeDouble", "alias": "AGE_1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AGE_1" }, { "name": "AGE_2", "type": "esriFieldTypeDouble", "alias": "AGE_2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AGE_2" }, { "name": "New_Apparent_Age", "type": "esriFieldTypeDouble", "alias": "New Apparent Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_Apparent_Age" } ], "indexes": [ { "name": "R455_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_455", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "vector_pub.DBO.PAVEMENTTreatmentGuidelines", "description": "", "prototype": { "attributes": { "AGE_2": null, "AGE_1": null, "Family": null, "Last_Treatment_Code": null, "PASER_1": null, "PASER_2": null, "Override_Exclusion": null, "Recommended_Treatment_Code": null, "Reduction_in_Apparent_Age_Year": null, "Resulting_PASER": null, "New_Apparent_Age": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 11, "name": "vector_pub.DBO.PAVEMENTTreatmentLookup", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Family", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Family", "type": "esriFieldTypeString", "alias": "Family", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Family" }, { "name": "Treatment", "type": "esriFieldTypeString", "alias": "Treatment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Treatment" }, { "name": "Treatment_Code", "type": "esriFieldTypeString", "alias": "Treatment Code", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Treatment_Code" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Linear_Cost", "type": "esriFieldTypeDouble", "alias": "Linear Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Linear_Cost" }, { "name": "Linear_Units", "type": "esriFieldTypeString", "alias": "Linear Units", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Linear_Units" }, { "name": "Area_Cost", "type": "esriFieldTypeDouble", "alias": "Area Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Area_Cost" }, { "name": "Area_Units", "type": "esriFieldTypeString", "alias": "Area Units", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Area_Units" } ], "indexes": [ { "name": "R466_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_466", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "vector_pub.DBO.PAVEMENTTreatmentLookup", "description": "", "prototype": { "attributes": { "Area_Cost": null, "Linear_Units": null, "Family": null, "Treatment": null, "Treatment_Code": null, "Area_Units": null, "Linear_Cost": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 12, "name": "Treatment Records", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "Streets_Maintenance_Plan", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Streets_GUID", "composite": false, "catalogID": "{C461EDAE-8CCD-4CD7-AD31-D0CB25F70440}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Treatment_Type", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Streets_GUID", "type": "esriFieldTypeGUID", "alias": "Streets GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Streets_GUID" }, { "name": "Treatment_Type", "type": "esriFieldTypeString", "alias": "Treatment Type", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Treatment_Type" }, { "name": "Cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Cost" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "Pre_Treatment_PASER", "type": "esriFieldTypeDouble", "alias": "Pre Treatment PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Pre_Treatment_PASER" }, { "name": "Post_Treatment_PASER", "type": "esriFieldTypeDouble", "alias": "Post Treatment PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Post_Treatment_PASER" }, { "name": "Treatment_Notes", "type": "esriFieldTypeString", "alias": "Treatment Notes", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "Treatment_Notes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Year_", "type": "esriFieldTypeInteger", "alias": "Year_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year_" }, { "name": "TreatmentDate", "type": "esriFieldTypeDate", "alias": "Treatment Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TreatmentDate" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Treatment Records", "description": "", "prototype": { "attributes": { "Year_": null, "TreatmentDate": null, "Streets_GUID": null, "Treatment_Type": null, "Cost": null, "Status": null, "Pre_Treatment_PASER": null, "Post_Treatment_PASER": null, "Treatment_Notes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 13, "name": "vector_pub.DBO.PAVEMENTYearlySummary", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Year", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Year" }, { "name": "FREQUENCY", "type": "esriFieldTypeInteger", "alias": "FREQUENCY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FREQUENCY" }, { "name": "MEAN_PASER", "type": "esriFieldTypeDouble", "alias": "MEAN_PASER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MEAN_PASER" } ], "indexes": [ { "name": "R458_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "vector_pub.DBO.PAVEMENTYearlySummary", "description": "", "prototype": { "attributes": { "FREQUENCY": null, "MEAN_PASER": null, "Year": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1, "serviceItemId": "1258ca5b8d614846a56bdddb5f2e7aba" } ] }