{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 26, "name": "GIS.TreeTask", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPECTOR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TASKID", "type": "esriFieldTypeDouble", "alias": "TASKID", "domain": null }, { "name": "PARENTID", "type": "esriFieldTypeDouble", "alias": "PARENTID", "domain": null }, { "name": "CREATEDDATE", "type": "esriFieldTypeDate", "alias": "CREATEDDATE", "length": 8, "domain": null }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "INSPECTOR", "length": 255, "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" } }, { "name": "TASK", "type": "esriFieldTypeString", "alias": "TASK", "length": 255, "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" } }, { "name": "TASKDETAIL", "type": "esriFieldTypeString", "alias": "TASKDETAIL", "length": 255, "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" } }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "length": 255, "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" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 255, "domain": { "type": "codedValue", "name": "Pk_TreeTaskStatus", "description": "", "codedValues": [ { "name": "Planned", "code": "PLANNED" }, { "name": "Complete", "code": "COMPLETE" }, { "name": "Unknown", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSIGNED", "type": "esriFieldTypeDate", "alias": "ASSIGNED", "length": 8, "domain": null }, { "name": "WORKORDERID", "type": "esriFieldTypeDouble", "alias": "WORKORDERID", "domain": null }, { "name": "COMPLETEDDATE", "type": "esriFieldTypeDate", "alias": "COMPLETEDDATE", "length": 8, "domain": null }, { "name": "SERVREQ", "type": "esriFieldTypeDouble", "alias": "SERVREQ", "domain": null }, { "name": "COMPLETEDBY", "type": "esriFieldTypeString", "alias": "COMPLETEDBY", "length": 255, "domain": null }, { "name": "UPDATEID", "type": "esriFieldTypeDouble", "alias": "UPDATEID", "domain": null }, { "name": "MODIFIEDBY", "type": "esriFieldTypeString", "alias": "MODIFIEDBY", "length": 255, "domain": null }, { "name": "MODIFIEDDATE", "type": "esriFieldTypeDate", "alias": "MODIFIEDDATE", "length": 8, "domain": null }, { "name": "REMOVALID", "type": "esriFieldTypeDouble", "alias": "REMOVALID", "domain": null }, { "name": "DURATIONMINUTES", "type": "esriFieldTypeDouble", "alias": "DURATIONMINUTES", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "TREESITE_GUID", "type": "esriFieldTypeGUID", "alias": "TREESITE_GUID", "length": 38, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GLOBALID", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G149TREESITE_GUI", "fields": "TREESITE_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G149PARENTID", "fields": "PARENTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "TreeSite", "relatedTableId": 16, "role": "esriRelRoleDestination", "keyField": "TREESITE_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B1912A81-3160-4935-87EB-58C638127956}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "4052f90d867f43878e7c1aecf0620a27" }