Name: Tree Work Orders

Display Field: AssetID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MaintenanceBy (type: esriFieldTypeString, alias: Maintenance By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Barrett Tree East: Barrett Tree East], [Marquis Tree Service: Marquis Tree Service], [Arbor Care Tree Service: Arbor Care Tree Service], ... 5 more ...)
• MaintDate (type: esriFieldTypeDate, alias: Maintenance Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MaintType (type: esriFieldTypeString, alias: Maintenance Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Debris Removal: Debris Removal], [Hazard Removal: Hazard Removal], [Pest & Disease Treatment: Pest & Disease Treatment], ... 8 more ...)
• Completed (type: esriFieldTypeString, alias: Completed, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• Deferred_ (type: esriFieldTypeString, alias: Deferred, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• CB_PrimaryWire (type: esriFieldTypeString, alias: Cut back from Primary Wire (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• CB_SecWire (type: esriFieldTypeString, alias: Cut back from Secondary Wire (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• WireClearance (type: esriFieldTypeString, alias: Wire Clearance (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• Deadwood (type: esriFieldTypeString, alias: Deadwood (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• LimbRemoval (type: esriFieldTypeString, alias: Limb Removal (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• Stubs (type: esriFieldTypeString, alias: Remove Stubs (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• CB_Fence (type: esriFieldTypeString, alias: Cut back from Fence (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• CB_House (type: esriFieldTypeString, alias: Cut back from House (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• CB_lawn (type: esriFieldTypeString, alias: Cut back from Lawn (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• CB_Property (type: esriFieldTypeString, alias: Cut back from Property (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• CB_Roof (type: esriFieldTypeString, alias: Cut back from Roof (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• CB_Tree (type: esriFieldTypeString, alias: Cut back from Tree (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• Sucker (type: esriFieldTypeString, alias: Sucker Removal (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• ThinCrown (type: esriFieldTypeString, alias: Thin Crown (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• UpBranch (type: esriFieldTypeString, alias: Up Branch (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• MaintStatus (type: esriFieldTypeString, alias: Maintenance Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Submitted: Submitted], [Received: Received], [Planned: Planned], ... 4 more ...)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• TreeGuid (type: esriFieldTypeGUID, alias: Tree Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• TreeSpaceGuid (type: esriFieldTypeGUID, alias: Tree Space Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Tree Work Orders
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceBy: Tree Supervisor
• MaintType: Pruning & Canopy Reduction
• Completed: No
• Deferred_: No
• CB_PrimaryWire: No
• CB_SecWire: No
• WireClearance: No
• Deadwood: No
• LimbRemoval: No
• Stubs: No
• CB_Fence: No
• CB_House: No
• CB_lawn: No
• CB_Property: No
• CB_Roof: No
• CB_Tree: No
• Sucker: No
• ThinCrown: No
• UpBranch: No
• MaintStatus: Submitted

Relationships:

• GIS.TREE_PT (1) -- Related To: Public Shade Trees (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/5/2026 7:36:16 PM

Schema Last Edit Date: 6/5/2026 7:36:16 PM

Data Last Edit Date: 6/5/2026 7:36:16 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat