Name: Trees_maintenance_5f7aa1c394824711a3c14cda9b859405

Display Field: mainttype

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: true

Sources

Description: AttributeJoin

Copyright Text:

Max Record Count: 2000

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:

• 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 ...)
• startdate (type: esriFieldTypeDate, alias: Start date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• maintdate (type: esriFieldTypeDate, alias: Date finished, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [In Progress: In Progress], [Completed: Completed], [Paused: Paused], ... 1 more ...)
• notes (type: esriFieldTypeString, alias: Maintenance notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• assetglobalid (type: esriFieldTypeGUID, alias: Tree GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• plantingareaglobalid (type: esriFieldTypeGUID, alias: Planting Area GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• assetid (type: esriFieldTypeString, alias: Tree identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fulladdr (type: esriFieldTypeString, alias: Nearest address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• district (type: esriFieldTypeString, alias: District or neighborhood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• family (type: esriFieldTypeString, alias: Family, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Adoxaceae: Adoxaceae], [Altingiaceae: Altingiaceae], [Anacardiaceae: Anacardiaceae], ... 43 more ...)
• genus (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abies: Abies], [Acer: Acer], [Aesculus: Aesculus], ... 102 more ...)
• species (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abies: Abies], [Acerifolia: Acerifolia], [Actinophyllum: Actinophyllum], ... 256 more ...)
• cultivar (type: esriFieldTypeString, alias: Cultivar, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Princeton: Princeton], [Valley Forge: Valley Forge])
• commonname (type: esriFieldTypeString, alias: Common name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Alaska Willow: Alaska Willow], [Alaska-Cedar: Alaska-Cedar], [Allegheny Chinkapin: Allegheny Chinkapin], ... 333 more ...)
• diameter (type: esriFieldTypeDouble, alias: Diameter at breast height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• height_units (type: esriFieldTypeString, alias: Height Units, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Feet: Feet], [Meters: Meters])
• installdate (type: esriFieldTypeDate, alias: Date planted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• treewires (type: esriFieldTypeString, alias: Tree wires present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• treeguard (type: esriFieldTypeString, alias: Tree guard present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• designation (type: esriFieldTypeString, alias: Special designation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Memorial: Memorial], [Dedication: Dedication], [Heritage: Heritage])
• overheadutilities (type: esriFieldTypeString, alias: Overhead utilities, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• warranty (type: esriFieldTypeString, alias: Warranty, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• warrantydate (type: esriFieldTypeDate, alias: Warranty date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• waterthroughdate (type: esriFieldTypeDate, alias: Water through date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• treenotes (type: esriFieldTypeString, alias: Tree notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• retiredate (type: esriFieldTypeDate, alias: Date retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• spaceid (type: esriFieldTypeString, alias: Planting space identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• spacestatus (type: esriFieldTypeString, alias: Planting space status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Available: Available], [Planted: Planted], [Stump: Stump], ... 2 more ...)
• spacetype (type: esriFieldTypeString, alias: Planting space type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bark: Bark], [Brick: Brick], [Grass: Grass], ... 6 more ...)
• sitetype (type: esriFieldTypeString, alias: Site type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Circle: Traffic circle], [Curb: Curb], [Island: Traffic island], ... 4 more ...)
• spacewidth (type: esriFieldTypeDouble, alias: Planting space width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spacelength (type: esriFieldTypeDouble, alias: Planting space length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spacenotes (type: esriFieldTypeString, alias: Planting space notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• collectedby (type: esriFieldTypeSmallInteger, alias: Collected by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• publicview (type: esriFieldTypeString, alias: Publicly Visibile, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• stormwater (type: esriFieldTypeDouble, alias: Stormwater intercepted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• energy (type: esriFieldTypeDouble, alias: Energy conserved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pollutants (type: esriFieldTypeDouble, alias: Air pollutants removed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• co2 (type: esriFieldTypeDouble, alias: Carbon dioxide reduced, SQL Type: sqlTypeOther, nullable: true, editable: true)
• propvalue (type: esriFieldTypeDouble, alias: Increased property value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• benefits (type: esriFieldTypeDouble, alias: Total value of benefits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adoptionstatus (type: esriFieldTypeString, alias: Adoption Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Available: Available], [Adopted: Adopted])
• adoptedby (type: esriFieldTypeString, alias: Adopted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• adoptedon (type: esriFieldTypeDate, alias: Adopted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• nickname (type: esriFieldTypeString, alias: Nickname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid_1685049166104 (type: esriFieldTypeGUID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user_1685049166104 (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date_1685049166104 (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user_1685049166104 (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date_1685049166104 (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/15/2025 9:46:10 PM

Schema Last Edit Date: 6/14/2023 3:03:39 PM

Data Last Edit Date: 6/14/2023 3:03:39 PM

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