{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 9, "name": "GIS.TreeTask", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "TreeSite", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "TREESITE_GUID", "composite": false, "catalogID": "{FF524A13-3792-4252-A224-39AA7D6A20FD}" }, { "id": 7, "name": "TreeSite", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "TREESITE_GUID", "composite": false, "catalogID": "{FF524A13-3792-4252-A224-39AA7D6A20FD}" }, { "id": 13, "name": "TreeSite", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "TREESITE_GUID", "composite": false, "catalogID": "{FF524A13-3792-4252-A224-39AA7D6A20FD}" }, { "id": 19, "name": "TreeSite", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "TREESITE_GUID", "composite": false, "catalogID": "{FF524A13-3792-4252-A224-39AA7D6A20FD}" }, { "id": 25, "name": "TreeSite", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "TREESITE_GUID", "composite": false, "catalogID": "{FF524A13-3792-4252-A224-39AA7D6A20FD}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "INSPECTOR", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TASKID", "type": "esriFieldTypeDouble", "alias": "TASKID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TASKID" }, { "name": "PARENTID", "type": "esriFieldTypeDouble", "alias": "PARENTID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PARENTID" }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "CREATEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATEDDATE" }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "INSPECTOR", "domain": { "type": "codedValue", "name": "Pk_TreeInspector", "description": "Can be used for both the TreeCreator and TreeInspector Fields", "codedValues": [ { "name": "A Mott", "code": "AMOTT" }, { "name": "B Purves", "code": "BPURVES" }, { "name": "D Rezeli", "code": "DREZELI" }, { "name": "G Houghton", "code": "GHOUGHTON" }, { "name": "J Labar", "code": "JLABAR" }, { "name": "J Vetere", "code": "JVETERE" }, { "name": "L Jenkins", "code": "LJENKINS" }, { "name": "N Etherington", "code": "NETHERINGTON" }, { "name": "P Smith", "code": "PSMITH" }, { "name": "T Sherbo", "code": "TSHERBO" }, { "name": "W Vandaele", "code": "WVANDAELE" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "S Cook", "code": "SCOOK" }, { "name": "K Johnston", "code": "KJOHNSTON" }, { "name": "J Schooling", "code": "JSCHOOLING" }, { "name": "N Camphaug", "code": "NCAMPHAUG" }, { "name": "T Cossentine", "code": "TCOSSENTINE" }, { "name": "J Byette", "code": "JBYETTE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INSPECTOR" }, { "name": "TASK", "type": "esriFieldTypeString", "alias": "TASK", "domain": { "type": "codedValue", "name": "Pk_TreeTask", "description": "", "codedValues": [ { "name": "Bolt", "code": "BOLT" }, { "name": "Brace", "code": "BRACE" }, { "name": "Cable/Brace", "code": "CABLE/BRACE" }, { "name": "Disease Treatment", "code": "DISEASE TREATMENT" }, { "name": "Failure", "code": "FAILURE" }, { "name": "Fertilize", "code": "FERTILIZE" }, { "name": "Insect Treatment", "code": "INSECT TREATMENT" }, { "name": "Inspect", "code": "INSPECT" }, { "name": "Monitor Inspect", "code": "MONITOR INSPECT" }, { "name": "Plant", "code": "PLANT" }, { "name": "Prune", "code": "PRUNE" }, { "name": "Remove", "code": "REMOVE" }, { "name": "Water", "code": "WATER" }, { "name": "Tree Grate", "code": "TREE GRATE" }, { "name": "Stump Removal", "code": "STUMP REMOVAL" }, { "name": "Stake Removal", "code": "STAKE REMOVAL" }, { "name": "Stump Treatment", "code": "STUMP TREATMENT" }, { "name": "Unknown", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TASK" }, { "name": "TASKDETAIL", "type": "esriFieldTypeString", "alias": "TASKDETAIL", "domain": { "type": "codedValue", "name": "Pk_TreeTaskDetail", "description": "", "codedValues": [ { "name": "Arbor Day", "code": "ARBOR DAY" }, { "name": "Boulevard", "code": "BOULEVARD" }, { "name": "Branch Failure", "code": "BRANCH FAILURE" }, { "name": "Crown Clear", "code": "CROWN CLEAR" }, { "name": "Damaged", "code": "DAMAGED" }, { "name": "Dead", "code": "DEAD" }, { "name": "Dead Wood", "code": "DEAD WOOD" }, { "name": "Dedication", "code": "DEDICATION" }, { "name": "Diseased", "code": "DISEASED" }, { "name": "Hanger", "code": "HANGER" }, { "name": "Hazard", "code": "HAZARD" }, { "name": "Lane", "code": "LANE" }, { "name": "Memorial", "code": "MEMORIAL" }, { "name": "New", "code": "NEW" }, { "name": "Park", "code": "PARK" }, { "name": "Pest", "code": "PEST" }, { "name": "Petitioned", "code": "PETITIONED" }, { "name": "Pine Beetle", "code": "PINE BEETLE" }, { "name": "Raise", "code": "RAISE" }, { "name": "Replacement", "code": "REPLACEMENT" }, { "name": "Reviewed", "code": "REVIEWED" }, { "name": "Root Failure", "code": "ROOT FAILURE" }, { "name": "Routine", "code": "ROUTINE" }, { "name": "Sidewalk", "code": "SIDEWALK" }, { "name": "Sign Clear", "code": "SIGN CLEAR" }, { "name": "Spray Stump", "code": "SPRAY STUMP" }, { "name": "Staked", "code": "STAKED" }, { "name": "Stem Failure", "code": "STEM FAILURE" }, { "name": "Subbordinate", "code": "SUBBORDINATE" }, { "name": "Thin", "code": "THIN" }, { "name": "Traffic Vis", "code": "TRAFFIC VIS" }, { "name": "Training", "code": "TRAINING" }, { "name": "Trunk Failure", "code": "TRUNK FAILURE" }, { "name": "Vandalism", "code": "VANDALISM" }, { "name": "Watersprouts", "code": "WATERSPROUTS" }, { "name": "Young Tree", "code": "YOUNG TREE" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "Line Clearance", "code": "LINE CLEARANCE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TASKDETAIL" }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "domain": { "type": "codedValue", "name": "Pk_TreeTaskPriority", "description": "", "codedValues": [ { "name": "Standards", "code": "STANDARD" }, { "name": "Immediate Action", "code": "IMMEDIATE ACTION" }, { "name": "Unknown", "code": "UNKNOWN" }, { "name": "High Priority", "code": "HIGH PRIORITY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PRIORITY" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": { "type": "codedValue", "name": "Pk_TreeTaskStatus", "description": "", "codedValues": [ { "name": "Planned", "code": "PLANNED" }, { "name": "Complete", "code": "COMPLETE" }, { "name": "Unknown", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "ASSIGNED", "type": "esriFieldTypeDate", "alias": "ASSIGNED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ASSIGNED" }, { "name": "WORKORDERID", "type": "esriFieldTypeDouble", "alias": "WORKORDERID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WORKORDERID" }, { "name": "COMPLETEDDATE", "type": "esriFieldTypeDate", "alias": "COMPLETEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COMPLETEDDATE" }, { "name": "SERVREQ", "type": "esriFieldTypeDouble", "alias": "SERVREQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SERVREQ" }, { "name": "COMPLETEDBY", "type": "esriFieldTypeString", "alias": "COMPLETEDBY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMPLETEDBY" }, { "name": "UPDATEID", "type": "esriFieldTypeDouble", "alias": "UPDATEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPDATEID" }, { "name": "MODIFIEDBY", "type": "esriFieldTypeString", "alias": "MODIFIEDBY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODIFIEDBY" }, { "name": "MODIFIEDDATE", "type": "esriFieldTypeDate", "alias": "MODIFIEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MODIFIEDDATE" }, { "name": "REMOVALID", "type": "esriFieldTypeDouble", "alias": "REMOVALID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REMOVALID" }, { "name": "DURATIONMINUTES", "type": "esriFieldTypeDouble", "alias": "DURATIONMINUTES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DURATIONMINUTES" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "TREESITE_GUID", "type": "esriFieldTypeGUID", "alias": "TREESITE_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "TREESITE_GUID" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" } ], "indexes": [ { "name": "G3959PARENTID", "fields": "PARENTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3959TREESITE_GU", "fields": "TREESITE_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1977_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1977", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1977", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GIS.TreeTask", "description": "", "prototype": { "attributes": { "TREESITE_GUID": null, "COMMENTS": null, "TASKID": null, "PARENTID": null, "CREATEDDATE": null, "INSPECTOR": null, "TASK": null, "TASKDETAIL": null, "PRIORITY": null, "STATUS": null, "ASSIGNED": null, "WORKORDERID": null, "COMPLETEDDATE": null, "SERVREQ": null, "COMPLETEDBY": null, "UPDATEID": null, "MODIFIEDBY": null, "MODIFIEDDATE": null, "REMOVALID": null, "DURATIONMINUTES": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "41d06790fc98465a9016761675230740" }