{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "Work Orders", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CallerName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "Priority", "length": 255, "domain": { "type": "codedValue", "name": "TREE_WO_Priority", "description": "Priority for tree workorders", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" }, { "name": "Hold", "code": "Hold" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "WOTYPE_2", "description": "Tree Work Order Type", "codedValues": [ { "name": "Branch Down", "code": "Branch Down" }, { "name": "Clearance & Deadwood Pruning", "code": "Clearance & Deadwood Pruning" }, { "name": "Emerald Ash Borer Treatment", "code": "Emerald Ash Borer Treatment" }, { "name": "Hanger", "code": "Hanger" }, { "name": "Hornet/Wasp Nest", "code": "Hornet/Wasp Nest" }, { "name": "Nuisance Tree", "code": "Nuisance Tree" }, { "name": "Reduction Pruning", "code": "Reduction Pruning" }, { "name": "Removal", "code": "Removal" }, { "name": "Site Inspection", "code": "Site Inspection" }, { "name": "Stump Grinding", "code": "Stump Grinding" }, { "name": "Sucker Pruning", "code": "Sucker Pruning" }, { "name": "Training Pruning", "code": "Training Pruning" }, { "name": "Tree Planting", "code": "Tree Planting" }, { "name": "Blocked Traffic Sign", "code": "Blocked Traffic Sign" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "TREE_WO_Status", "description": "Status for Tree Workorders", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aNOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 265, "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "DateClosed", "type": "esriFieldTypeDate", "alias": "DateClosed", "length": 8, "domain": null }, { "name": "CreateBy", "type": "esriFieldTypeString", "alias": "CreateBy", "length": 255, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "length": 255, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "CallerName", "type": "esriFieldTypeString", "alias": "Caller Name", "length": 255, "domain": null }, { "name": "CallerPhone", "type": "esriFieldTypeString", "alias": "Caller Phone", "length": 255, "domain": null }, { "name": "GUID_WO_A", "type": "esriFieldTypeString", "alias": "GUID_WO_A", "length": 255, "domain": null }, { "name": "Address_WO_Table", "type": "esriFieldTypeString", "alias": "Address WO Table", "length": 255, "domain": null }, { "name": "Pruning_Info", "type": "esriFieldTypeString", "alias": "Pruning Info", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Pruning_Info", "description": "Additional information that may be needed for a tree workorder.", "codedValues": [ { "name": "Pole Saw", "code": "Pole Saw" }, { "name": "Big Bucket Truck Needed", "code": "Big Bucket Truck Needed" }, { "name": "Wires Present", "code": "Wires Present" }, { "name": "Traffic Concerns", "code": "Traffic Concerns" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Removal_Info1", "type": "esriFieldTypeString", "alias": "Removal Info 1", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Removal_Info", "description": "", "codedValues": [ { "name": "Simple, Small, Quick Removal", "code": "Simple, Small, Quick Removal" }, { "name": "Bucket Truck Needed", "code": "Bucket Truck Needed" }, { "name": "Traffic Concerns", "code": "Traffic Concerns" }, { "name": "Press Release Required", "code": "Press Release Required" }, { "name": "Wire Drop - Street Light", "code": "Wire Drop - Street Light" }, { "name": "Wires Present", "code": "Wires Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Removal_Info2", "type": "esriFieldTypeString", "alias": "Removal Info 2", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Removal_Info", "description": "", "codedValues": [ { "name": "Simple, Small, Quick Removal", "code": "Simple, Small, Quick Removal" }, { "name": "Bucket Truck Needed", "code": "Bucket Truck Needed" }, { "name": "Traffic Concerns", "code": "Traffic Concerns" }, { "name": "Press Release Required", "code": "Press Release Required" }, { "name": "Wire Drop - Street Light", "code": "Wire Drop - Street Light" }, { "name": "Wires Present", "code": "Wires Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "No_Parking_Posted", "type": "esriFieldTypeString", "alias": "No Parking Posted?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection_Notes", "type": "esriFieldTypeString", "alias": "Inspection Notes", "length": 264, "domain": null }, { "name": "Leaf_Status", "type": "esriFieldTypeString", "alias": "When should this be completed?", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Pruning_Season", "description": "When should a tree workorder be completed.", "codedValues": [ { "name": "Leaf On", "code": "Leaf On" }, { "name": "Leaf Off", "code": "Leaf Off" }, { "name": "Contracted Out", "code": "Contracted Out" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Tree_ID", "type": "esriFieldTypeString", "alias": "Tree_ID", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R503_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_503", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_503", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9487_Tree_ID", "fields": "Tree_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Tree", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Tree_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1712829197000 }, "serviceItemId": "792ef0346a7c44a3ae8ebb45f6957aa5" }