Name: MaintenanceRecords

Display Field: scheduled

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 5000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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)
• treenumber (type: esriFieldTypeGUID, alias: Tree Number, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• date (type: esriFieldTypeDate, alias: MaintenanceDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• scheduled (type: esriFieldTypeString, alias: Scheduled, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• worktype (type: esriFieldTypeString, alias: Type of Work, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Inspection: Inspection], [Pesticide: Pesticide], [Fertilize: Fertilize], ... 6 more ...)
• maintenancetype (type: esriFieldTypeString, alias: Contractor or In House Maintenance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Contractor: Contractor], [In House: In House])
• damage (type: esriFieldTypeString, alias: Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• damagetype (type: esriFieldTypeString, alias: DamageType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• treeremoved (type: esriFieldTypeString, alias: Tree Removed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Dead: Dead], [Storm: Storm], [Pest or Disease: Pest or Disease], ... 3 more ...)
• treereplaced (type: esriFieldTypeString, alias: Tree Replaced, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• stumpremoved (type: esriFieldTypeString, alias: Stump Removed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• dbh (type: esriFieldTypeSmallInteger, alias: DBH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: globalid, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• pestdisease (type: esriFieldTypeString, alias: Pest or Disease, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cost (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: MaintenanceRecords
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• damage: No
• damagetype: N/A
• treereplaced: No
• stumpremoved: No

Relationships:

• From Trees to Maintenance (0) -- Related To: Tree Points (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/20/2026 5:34:53 PM

Schema Last Edit Date: 5/28/2026 10:31:10 PM

Data Last Edit Date: 5/29/2026 8:28:19 PM

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