{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "Work Orders", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CreateDate", "creatorField": "CreateBy", "editDateField": "EditDate", "editorField": "EditBy" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Tree", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Tree_ID", "composite": false } ], "isDataVersioned": true, "isDataArchived": true, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1712829197000 }, "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 }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "CallerName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "Priority", "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Low", "modelName": "PRIORITY" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "WOTYPE_2", "description": "Tree Work Order Type", "codedValues": [ { "name": "Elevating/Deadwood Pruning", "code": "Elevating/Deadwood Pruning" }, { "name": "Removal", "code": "Removal" }, { "name": "Ash Reduction", "code": "Ash Reduction" }, { "name": "Hanger/Branch Down", "code": "Hanger/Branch Down" }, { "name": "Structure/Training Pruning", "code": "Structure/Training Pruning" }, { "name": "Emerald Ash Borer Treatment", "code": "Emerald Ash Borer Treatment" }, { "name": "Site Inspection", "code": "Site Inspection" }, { "name": "Tree Planting", "code": "Tree Planting" }, { "name": "Other", "code": "Other" }, { "name": "Hornet/Wasp Nest", "code": "Hornet/Wasp Nest" }, { "name": "Sucker/Water Spout Pruning", "code": "Sucker/Water Spout Pruning" }, { "name": "Stump Grinding", "code": "Stump Grinding" }, { "name": "Nuisance Tree", "code": "Nuisance Tree" }, { "name": "Emergency Not Reviewed", "code": "Emergency Not Reviewed" }, { "name": "Emergency Reviewed", "code": "Emergency Reviewed" }, { "name": "Test", "code": "Test" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TYPE" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Open", "modelName": "STATUS" }, { "name": "aNOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 265, "defaultValue": null, "modelName": "aNOTES" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude" }, { "name": "DateClosed", "type": "esriFieldTypeDate", "alias": "DateClosed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateClosed" }, { "name": "CreateBy", "type": "esriFieldTypeString", "alias": "CreateBy", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CreateBy" }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreateDate" }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EditBy" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "CallerName", "type": "esriFieldTypeString", "alias": "Caller Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CallerName" }, { "name": "CallerPhone", "type": "esriFieldTypeString", "alias": "Caller Phone", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CallerPhone" }, { "name": "GUID_WO_A", "type": "esriFieldTypeString", "alias": "GUID_WO_A", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GUID_WO_A" }, { "name": "Address_WO_Table", "type": "esriFieldTypeString", "alias": "Address WO Table", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address_WO_Table" }, { "name": "Pruning_Info", "type": "esriFieldTypeString", "alias": "Pruning Info", "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" }, { "name": "Prune only during leaf on", "code": "Prune only during leaf on" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Pruning_Info" }, { "name": "Removal_Info1", "type": "esriFieldTypeString", "alias": "Removal Info 1", "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": "Wire Drop - Service", "code": "Wire Drop - Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Removal_Info1" }, { "name": "Removal_Info2", "type": "esriFieldTypeString", "alias": "Removal Info 2", "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": "Wire Drop - Service", "code": "Wire Drop - Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Removal_Info2" }, { "name": "No_Parking_Posted", "type": "esriFieldTypeString", "alias": "No Parking Posted?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "No_Parking_Posted" }, { "name": "Inspection_Notes", "type": "esriFieldTypeString", "alias": "Inspection Notes", "domain": null, "editable": true, "nullable": true, "length": 264, "defaultValue": null, "modelName": "Inspection_Notes" }, { "name": "Leaf_Status", "type": "esriFieldTypeString", "alias": "When should this be completed?", "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Leaf_Status" }, { "name": "Tree_ID", "type": "esriFieldTypeString", "alias": "Tree_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Tree_ID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Work Orders", "description": "", "prototype": { "attributes": { "Tree_ID": null, "Leaf_Status": null, "PRIORITY": "Low", "TYPE": null, "STATUS": "Open", "aNOTES": null, "Longitude": null, "Latitude": null, "DateClosed": null, "Inspection_Notes": null, "No_Parking_Posted": null, "Removal_Info2": null, "Removal_Info1": null, "CallerName": null, "CallerPhone": null, "GUID_WO_A": null, "Address_WO_Table": null, "Pruning_Info": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "75c9e3a803c64dc5b9a8eadb7491f814" }