{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_BaseUpdateLog", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "from_project": "", "date_ran": -2209161600000, "status": "" } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_BaseUpdateLog", "displayField": "date_ran", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "date_ran", "length": 29, "alias": "Date_Ran", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "status", "length": 10, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "from_project", "length": 100, "alias": "From Project", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "i1532created_dat", "isUnique": false, "description": "", "fields": "created_date", "isAscending": true }, { "name": "i1532created_use", "isUnique": false, "description": "", "fields": "created_user", "isAscending": true }, { "name": "i1532last_edited", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i1532last_edited_1", "isUnique": false, "description": "", "fields": "last_edited_user", "isAscending": true }, { "name": "r914_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_914", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "streets_guid", "role": "esriRelRoleDestination", "composite": false, "name": "", "relatedTableId": 0, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "projectid", "role": "esriRelRoleDestination", "composite": true, "name": "", "relatedTableId": 7, "id": 7, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Degradation_Curves_By_Year", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "year": 0, "treatment_recommended": "", "paser": 0, "streets_guid": null, "treatment_completed": "", "projectid": "", "projects_guid": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Degradation_Curves_By_Year", "displayField": "year", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streets_guid", "length": 38, "alias": "Streets_GUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projects_guid", "length": 38, "alias": "Projects_GUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "year", "alias": "Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "paser", "alias": "PASER", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_recommended", "length": 3, "alias": "Treatment Recommended", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_completed", "length": 3, "alias": "Treatment_Completed", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "g1533projectid", "isUnique": false, "description": "", "fields": "projectid", "isAscending": true }, { "name": "i1533creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1533creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1533editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1533editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "i1533streets_gui", "isUnique": false, "description": "", "fields": "streets_guid", "isAscending": true }, { "name": "i1533year10", "isUnique": false, "description": "", "fields": "year,paser", "isAscending": true }, { "name": "r915_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_915", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "streets_guid", "role": "esriRelRoleDestination", "composite": false, "name": "", "relatedTableId": 0, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Field_PASER", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "notes": "", "paser": 0, "fielddate": -2209161600000, "year_": 0, "streets_guid": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Field_PASER", "displayField": "paser", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streets_guid", "length": 38, "alias": "Streets GUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "paser", "alias": "PASER", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "notes", "length": 1500, "alias": "Notes", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "year_", "alias": "Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "fielddate", "length": 29, "alias": "Field Date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "g1531streets_gui", "isUnique": false, "description": "", "fields": "streets_guid", "isAscending": true }, { "name": "i1531created_dat", "isUnique": false, "description": "", "fields": "created_date", "isAscending": true }, { "name": "i1531created_use", "isUnique": false, "description": "", "fields": "created_user", "isAscending": true }, { "name": "i1531last_edited", "isUnique": false, "description": "", "fields": "last_edited_user", "isAscending": true }, { "name": "i1531last_edited_1", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i1531last_edited_2", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "r913_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_913", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "projectid", "role": "esriRelRoleDestination", "composite": true, "name": "", "relatedTableId": 7, "id": 8, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Override_Treatments", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "implementyear": 0, "projectguid": null, "notes": "", "streetguid": null, "beginholdyear": 0, "projectid": "", "treatmentid": "" } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Override_Treatments", "displayField": "treatmentid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Tretments", "description": "", "type": "codedValue", "codedValues": [ { "code": "R1", "name": "Slurry Seal" }, { "code": "R2", "name": "Crack Seal" }, { "code": "R3", "name": "Crack Seal & Slurry Seal" }, { "code": "R4", "name": "Crack Seal & Slurry Seal" }, { "code": "R5", "name": "Mill and Fill" }, { "code": "R6", "name": "Crack Seal" }, { "code": "R7", "name": "Crack Seal & Slurry Seal" }, { "code": "0", "name": "FDR with Cement Stabilization" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "treatmentid", "length": 50, "alias": "TreatmentID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "beginholdyear", "alias": "BeginHoldYear", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "implementyear", "alias": "ImplementYear", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "notes", "length": 1500, "alias": "Notes", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectguid", "length": 38, "alias": "ProjectGUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streetguid", "length": 38, "alias": "StreetGUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "g1536projectid", "isUnique": false, "description": "", "fields": "projectid", "isAscending": true }, { "name": "i1536created_dat", "isUnique": false, "description": "", "fields": "created_date", "isAscending": true }, { "name": "i1536created_use", "isUnique": false, "description": "", "fields": "created_user", "isAscending": true }, { "name": "i1536last_edited", "isUnique": false, "description": "", "fields": "last_edited_user", "isAscending": true }, { "name": "i1536last_edited_1", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i1536last_edited_2", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i1536last_edited_3", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "r918_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_918", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "projectid", "role": "esriRelRoleOrigin", "composite": true, "name": "", "relatedTableId": 4, "id": 7, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "projectid", "role": "esriRelRoleOrigin", "composite": true, "name": "", "relatedTableId": 1, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "projectid", "role": "esriRelRoleOrigin", "composite": true, "name": "", "relatedTableId": 2, "id": 6, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "projectid", "role": "esriRelRoleOrigin", "composite": true, "name": "", "relatedTableId": 8, "id": 9, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "projectid", "role": "esriRelRoleOrigin", "composite": true, "name": "", "relatedTableId": 6, "id": 8, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Projects", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "last_edited_user": "", "created_user": "", "year": 0, "author": "", "description": "", "last_edited_date": -2209161600000, "created_date": -2209161600000, "numberofyears": 0, "projectid": "", "inflation": 0, "budget": 0 } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Projects", "displayField": "author", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "author", "length": 120, "alias": "Author", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "year", "alias": "Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "description", "length": 500, "alias": "Description", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "budget", "alias": "Budget", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "numberofyears", "alias": "NumberOfYears", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "inflation", "alias": "Inflation", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "g1538projectid", "isUnique": false, "description": "", "fields": "projectid", "isAscending": true }, { "name": "i1538creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1538creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1538editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1538editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "r920_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_920", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "projectid", "role": "esriRelRoleDestination", "composite": true, "name": "", "relatedTableId": 7, "id": 9, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "streets_globalid", "role": "esriRelRoleDestination", "composite": false, "name": "", "relatedTableId": 0, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Recommended_Treatment", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "recommended_treatment_code": "", "streets_globalid": null, "treatment_cost": 0, "treatment_linear_unit_cost": 0, "year": 0, "treatment_area_unit": "", "project_globalid": null, "post_treatment_paser_rating": 0, "treatment_area_unit_cost": 0, "treatment_linear_unit": "", "projectid": "" } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Recommended_Treatment", "displayField": "year", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "year", "alias": "Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streets_globalid", "length": 38, "alias": "Streets_GlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Tretments", "description": "", "type": "codedValue", "codedValues": [ { "code": "R1", "name": "Slurry Seal" }, { "code": "R2", "name": "Crack Seal" }, { "code": "R3", "name": "Crack Seal & Slurry Seal" }, { "code": "R4", "name": "Crack Seal & Slurry Seal" }, { "code": "R5", "name": "Mill and Fill" }, { "code": "R6", "name": "Crack Seal" }, { "code": "R7", "name": "Crack Seal & Slurry Seal" }, { "code": "0", "name": "FDR with Cement Stabilization" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "recommended_treatment_code", "length": 50, "alias": "Recommended Treatment Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "post_treatment_paser_rating", "alias": "Post Treatment PASER Rating", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "treatment_cost", "alias": "Treatment Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "treatment_linear_unit_cost", "alias": "Treatment Linear Unit Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_linear_unit", "length": 50, "alias": "Treatment Linear Unit", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "treatment_area_unit_cost", "alias": "Treatment Area Unit Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_area_unit", "length": 50, "alias": "Treatment Area Unit", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_globalid", "length": 38, "alias": "Project_GlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "g1537projectid", "isUnique": false, "description": "", "fields": "projectid", "isAscending": true }, { "name": "i1537creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1537creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1537editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1537editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "i1537streets_glo", "isUnique": false, "description": "", "fields": "streets_globalid", "isAscending": true }, { "name": "r919_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_919", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "street_guid", "role": "esriRelRoleDestination", "composite": false, "name": "", "relatedTableId": 0, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 9, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Street_History", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "last_treatment": "", "date": -2209161600000, "street_guid": null, "paser": 0 } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Street_History", "displayField": "date", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "street_guid", "length": 38, "alias": "Street_GUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "date", "length": 29, "alias": "Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "paser", "alias": "PASER", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Recommended Treatment Streets_Recommended_Treatment_Code_5ee288c68e8a44fcac6e3c1137446716", "description": "", "type": "codedValue", "codedValues": [ { "code": "R1", "name": "Slurry Seal - Year 1" }, { "code": "R2", "name": "Crack Seal - Year 2" }, { "code": "R3", "name": "Crack Seal & Slurry Seal - Year 6" }, { "code": "R4", "name": "Crack Seal & Slurry Seal - Year 12" }, { "code": "R5", "name": "Mill and Fill - Year 16" }, { "code": "R6", "name": "Crack Seal - Year 18" }, { "code": "R7", "name": "Crack Seal & Slurry Seal - Year 23" }, { "code": "0", "name": "FDR with Cement Stabilization - Year 40" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "last_treatment", "length": 10, "alias": "Last Treatment", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "i1535created_dat", "isUnique": false, "description": "", "fields": "created_date", "isAscending": true }, { "name": "i1535created_use", "isUnique": false, "description": "", "fields": "created_user", "isAscending": true }, { "name": "i1535last_edited", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i1535last_edited_1", "isUnique": false, "description": "", "fields": "last_edited_user", "isAscending": true }, { "name": "i1535street_guid", "isUnique": false, "description": "", "fields": "street_guid", "isAscending": true }, { "name": "r917_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_917", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 10, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Treatment_Guidelines", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "last_treatment_code": "", "recommended_treatment_code": "", "override_exclusion": "", "created_user": "", "paser_1": 0, "paser_2": 0, "reduction_in_apparent_age_year": "", "last_edited_user": "", "age_2": 0, "age_1": 0, "last_edited_date": -2209161600000, "resulting_paser": 0, "created_date": -2209161600000, "family": "", "new_aparent_age": 0 } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Treatment_Guidelines", "displayField": "family", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "family", "length": 255, "alias": "Family", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "last_treatment_code", "length": 255, "alias": "Last Treatment Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "paser_1", "alias": "PASER_1", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "paser_2", "alias": "PASER_2", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "override_exclusion", "length": 255, "alias": "Override Exclusion", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "recommended_treatment_code", "length": 255, "alias": "Recommended Treatment Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "reduction_in_apparent_age_year", "length": 255, "alias": "Reduction_in_Apparent_Age_Year", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "resulting_paser", "alias": "Resulting PASER", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "age_1", "alias": "AGE_1", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "age_2", "alias": "AGE_2", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "new_aparent_age", "alias": "New_Aparent_Age", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "i1534creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1534creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1534editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1534editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "r916_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_916", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 11, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Treatment_Lookup", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "linear_cost": 0, "treatment": "", "last_edited_user": "", "linear_units": "", "treatment_code": "", "created_user": "", "area_cost": 0, "last_edited_date": -2209161600000, "created_date": -2209161600000, "area_units": "", "family": "" } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Treatment_Lookup", "displayField": "family", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "family", "length": 255, "alias": "Family", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment", "length": 255, "alias": "Treatment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_code", "length": 255, "alias": "Treatment Code", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "linear_cost", "alias": "Linear Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "linear_units", "length": 50, "alias": "Linear Units", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "area_cost", "alias": "Area Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "area_units", "length": 50, "alias": "Area Units", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "i1539creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1539creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1539editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1539editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "r921_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_921", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "streets_guid", "role": "esriRelRoleDestination", "composite": false, "name": "", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 12, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Treatment_Records", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "treatmentdate": -2209161600000, "cost": 0, "treatment_notes": "", "treatment_type": "", "post_treatment_paser": 0, "year_": 0, "pre_treatment_paser": 0, "streets_guid": null, "status": "" } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Treatment_Records", "displayField": "treatment_type", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streets_guid", "length": 38, "alias": "Streets GUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Tretments", "description": "", "type": "codedValue", "codedValues": [ { "code": "R1", "name": "Slurry Seal" }, { "code": "R2", "name": "Crack Seal" }, { "code": "R3", "name": "Crack Seal & Slurry Seal" }, { "code": "R4", "name": "Crack Seal & Slurry Seal" }, { "code": "R5", "name": "Mill and Fill" }, { "code": "R6", "name": "Crack Seal" }, { "code": "R7", "name": "Crack Seal & Slurry Seal" }, { "code": "0", "name": "FDR with Cement Stabilization" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "treatment_type", "length": 50, "alias": "Treatment Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "cost", "alias": "Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PAVEMENT Treatment Records_Status_29cd0110-c55c-472b-84e1-e4300184d060", "description": "", "type": "codedValue", "codedValues": [ { "code": "Planned", "name": "Planned" }, { "code": "In Progress", "name": "In Progress" }, { "code": "Complete", "name": "Complete" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "length": 50, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "pre_treatment_paser", "alias": "Pre Treatment PASER", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "post_treatment_paser", "alias": "Post Treatment PASER", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_notes", "length": 2000, "alias": "Treatment Notes", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "year_", "alias": "Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "treatmentdate", "length": 29, "alias": "Treatment Date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "g1540streets_gui", "isUnique": false, "description": "", "fields": "streets_guid", "isAscending": true }, { "name": "i1540created_dat", "isUnique": false, "description": "", "fields": "created_date", "isAscending": true }, { "name": "i1540created_use", "isUnique": false, "description": "", "fields": "created_user", "isAscending": true }, { "name": "i1540last_edited", "isUnique": false, "description": "", "fields": "last_edited_user", "isAscending": true }, { "name": "i1540last_edited_1", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "i1540last_edited_2", "isUnique": false, "description": "", "fields": "last_edited_date", "isAscending": true }, { "name": "r922_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_922", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 13, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PAVEMENT_Yearly_Summary", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "year": 0, "mean_paser": 0, "frequency": 0 } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.1, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PAVEMENT_Yearly_Summary", "displayField": "year", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "year", "alias": "Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "frequency", "alias": "FREQUENCY", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "mean_paser", "alias": "MEAN_PASER", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "indexes": [ { "name": "i1541creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1541creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1541editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1541editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "r923_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_923", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 7205573.901927486, "xmin": 1609442.7422751635, "ymax": 7223074.470600814, "xmax": 1625835.4936103225, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "", "relatedTableId": 12, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "", "relatedTableId": 8, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "", "relatedTableId": 5, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "", "relatedTableId": 4, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "", "relatedTableId": 9, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "supportsReturningGeometryProperties": true, "templates": [ { "name": "Street_Centerlines", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "beginstreet": "", "cost": 0, "streetfamily": "", "paser_rating": null, "length": 0, "last_treat": "", "cost_treat": 0, "year_constructed_range": "", "surfwidth": 0, "areayards": 0, "func_class": "", "surftype": "", "year_constructed_confidence": null, "speed": 0, "uid": 0, "surf_area": 0, "streettype": "", "treatment_code": "", "current_paser": 0, "fullname": "", "endstreet": "", "last_treat_date": 0 } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.1, "hasZ": false, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Street_Centerlines", "allowTrueCurvesUpdates": false, "displayField": "fullname", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "fullname", "length": 50, "alias": "Full Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "streettype", "length": 4, "alias": "Street Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "speed", "alias": "Speed", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "surftype", "length": 30, "alias": "Surface Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "surfwidth", "alias": "Surface Width", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "func_class", "length": 20, "alias": "Functional Class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "last_treat", "length": 15, "alias": "Last Treatment", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "last_treat_date", "alias": "Last Treatment Date", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "surf_area", "alias": "Surface Area", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "cost_treat", "alias": "Unit Treatment Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "cost", "alias": "Total Treatment Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "length", "alias": "Length (ft)", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "year_constructed_range", "length": 50, "alias": "Year Constructed Range", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Confidence", "description": "", "type": "codedValue", "codedValues": [ { "code": "Spot On", "name": "Spot On" }, { "code": "Educated Guess", "name": "Educated Guess" }, { "code": "Stab in the Dark", "name": "Stab in the Dark" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "year_constructed_confidence", "length": 50, "alias": "Year Constructed Confidence", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "beginstreet", "length": 500, "alias": "Begin Street", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "endstreet", "length": 500, "alias": "End Street", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Streets_Paser_Rating_2cff980d-a28f-4416-825e-a2f8091464b3", "description": "", "type": "codedValue", "codedValues": [ { "code": "0", "name": "0" }, { "code": "1", "name": "1" }, { "code": "2", "name": "2" }, { "code": "3", "name": "3" }, { "code": "4", "name": "4" }, { "code": "5", "name": "5" }, { "code": "6", "name": "6" }, { "code": "7", "name": "7" }, { "code": "8", "name": "8" }, { "code": "9", "name": "9" }, { "code": "10", "name": "10" }, { "code": "99", "name": "99" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "paser_rating", "length": 256, "alias": "PASER Rating", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "uid", "alias": "UID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "streetfamily", "length": 50, "alias": "Functional Class", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Tretments", "description": "", "type": "codedValue", "codedValues": [ { "code": "R1", "name": "Slurry Seal" }, { "code": "R2", "name": "Crack Seal" }, { "code": "R3", "name": "Crack Seal & Slurry Seal" }, { "code": "R4", "name": "Crack Seal & Slurry Seal" }, { "code": "R5", "name": "Mill and Fill" }, { "code": "R6", "name": "Crack Seal" }, { "code": "R7", "name": "Crack Seal & Slurry Seal" }, { "code": "0", "name": "FDR with Cement Stabilization" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "treatment_code", "length": 50, "alias": "Last Treatment Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "current_paser", "alias": "Current PASER", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "areayards", "alias": "Area in SQ Yards", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": -100000, "xyTolerance": 0.00328083333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.00609601219, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "globalIdField": "globalid", "description": "Street_Centerlines", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "i1528creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1528creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1528editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1528editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "i1528last_treat", "isUnique": false, "description": "", "fields": "last_treat", "isAscending": true }, { "name": "i1528year_constr", "isUnique": false, "description": "", "fields": "year_constructed_range", "isAscending": true }, { "name": "r910_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_910", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a480_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "color": [ 36, 153, 38, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "SHAPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 7205573.901927486, "xmin": 1609442.7422751635, "ymax": 7223074.470600814, "xmax": 1625835.4936103225, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "projectid", "role": "esriRelRoleDestination", "composite": true, "name": "", "relatedTableId": 7, "id": 5, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "supportsReturningGeometryProperties": true, "templates": [ { "name": "Recommended_Treatment_Streets", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "recommended_treatment_code": "", "treatment_linear_unit_cost": 0, "year": 0, "creationdate_1": -2209161600000, "creator_1": "", "streets_globalid": null, "treatment_cost": 0, "editor_1": "", "treatment_area_unit": "", "project_globalid": null, "post_treatment_paser_rating": 0, "treatment_area_unit_cost": 0, "treatment_linear_unit": "", "projectid": "", "editdate_1": -2209161600000 } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.1, "hasZ": false, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Recommended_Treatment_Streets", "allowTrueCurvesUpdates": false, "displayField": "year", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "year", "alias": "Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streets_globalid", "length": 38, "alias": "Streets_GlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Recommended Treatment Streets_Recommended_Treatment_Code_5ee288c68e8a44fcac6e3c1137446716", "description": "", "type": "codedValue", "codedValues": [ { "code": "R1", "name": "Slurry Seal - Year 1" }, { "code": "R2", "name": "Crack Seal - Year 2" }, { "code": "R3", "name": "Crack Seal & Slurry Seal - Year 6" }, { "code": "R4", "name": "Crack Seal & Slurry Seal - Year 12" }, { "code": "R5", "name": "Mill and Fill - Year 16" }, { "code": "R6", "name": "Crack Seal - Year 18" }, { "code": "R7", "name": "Crack Seal & Slurry Seal - Year 23" }, { "code": "0", "name": "FDR with Cement Stabilization - Year 40" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "recommended_treatment_code", "length": 50, "alias": "Recommended Treatment Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "post_treatment_paser_rating", "alias": "Post Treatment PASER Rating", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "treatment_cost", "alias": "Treatment Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "treatment_linear_unit_cost", "alias": "Treatment Linear Unit Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_linear_unit", "length": 50, "alias": "Treatment Linear Unit", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "treatment_area_unit_cost", "alias": "Treatment Area Unit Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_area_unit", "length": 50, "alias": "Treatment Area Unit", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_globalid", "length": 38, "alias": "Project_GlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "creationdate_1", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "creator_1", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "editdate_1", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "editor_1", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": -100000, "xyTolerance": 0.00328083333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.00609601219, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "globalIdField": "globalid", "description": "Recommended_Treatment_Streets", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "g1529projectid", "isUnique": false, "description": "", "fields": "projectid", "isAscending": true }, { "name": "i1529creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1529creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1529editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1529editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "r911_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_911", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a481_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "color": [ 43, 150, 56, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "SHAPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 7205573.901927486, "xmin": 1609442.7422751635, "ymax": 7223074.470600814, "xmax": 1625835.4936103225, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "projectid", "role": "esriRelRoleDestination", "composite": true, "name": "", "relatedTableId": 7, "id": 6, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": true, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "supportsReturningGeometryProperties": true, "templates": [ { "name": "Degredation_Curves_Streets", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "creator_1": "", "year": 0, "treatment_recommended": "", "editor_1": "", "paser": 0, "creationdate_1": -2209161600000, "streets_guid": null, "treatment_completed": "", "projectid": "", "projects_guid": null, "editdate_1": -2209161600000 } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.1, "hasZ": false, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Degredation_Curves_Streets", "allowTrueCurvesUpdates": false, "displayField": "year", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streets_guid", "length": 38, "alias": "Streets_GUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projects_guid", "length": 38, "alias": "Projects_GUID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "year", "alias": "Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": 0, "domain": null, "name": "paser", "alias": "PASER", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_recommended", "length": 3, "alias": "Treatment Recommended", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "treatment_completed", "length": 3, "alias": "Treatment_Completed", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "projectid", "length": 50, "alias": "ProjectID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "creator", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": -2209161600000, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": "", "domain": null, "name": "editor", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "creationdate_1", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "creator_1", "length": 128, "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": -2209161600000, "domain": null, "name": "editdate_1", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": "", "domain": null, "name": "editor_1", "length": 128, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": -100000, "xyTolerance": 0.00328083333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.00609601219, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "globalIdField": "globalid", "description": "Degredation_Curves_Streets", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "g1530projectid", "isUnique": false, "description": "", "fields": "projectid", "isAscending": true }, { "name": "i1530creationdat", "isUnique": false, "description": "", "fields": "creationdate", "isAscending": true }, { "name": "i1530creator", "isUnique": false, "description": "", "fields": "creator", "isAscending": true }, { "name": "i1530editdate", "isUnique": false, "description": "", "fields": "editdate", "isAscending": true }, { "name": "i1530editor", "isUnique": false, "description": "", "fields": "editor", "isAscending": true }, { "name": "r912_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_912", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a482_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "432ff9f5012544dcbde87a5aaa24cd48", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Query,Update,Uploads,Delete,Sync,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "color": [ 175, 85, 66, 255 ], "width": 1, "style": "esriSLSSolid", "type": "esriSLS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "SHAPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline", "supportsLayerOverrides": true } ] }