Name: Tree Sites

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: This point feature layer represents all recorded, publicly maintained active trees, vacant tree sites, and archived tree sites. Note that the dataset within parks and open space areas is incomplete.

Copyright Text: City of Marysville Parks and Recreation Department, Division of Urban Forestry

Min. Scale: 144448

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9285118.75420237
YMin: 4895181.15949637
XMax: -9273591.09222817
YMax: 4905833.11731666
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"status","uniqueValueInfos":[{"value":"active","symbol":{"color":[76,115,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Active"},{"value":"vacant","symbol":{"color":[230,230,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Vacant"},{"value":"archived","symbol":{"color":[153,153,153,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Archived"}]},"transparency":0}

HasZ: true

HasM: false

Time Info:

Start Time Field: null
End Time Field: null
Track ID Field: null
Time Extent: null

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

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: status

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [active: Active], [vacant: Vacant], [archived: Archived])
• maintenance_status (type: esriFieldTypeString, alias: Maintenance Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [none: None], [plant_pending: Planting - Plant Pending], [warranty_work: Planting - Warranty Work], ... 11 more ...)
• site_type (type: esriFieldTypeString, alias: Site Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [memorial: Memorial], [private: Private], [other_public: Other Public], ... 3 more ...)
• plant_space_width (type: esriFieldTypeInteger, alias: Plant Space Width, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: 02-04 ft (Very Small)], [5: 04-06 ft (Small)], [7: 06-08 ft (Medium)], ... 3 more ...)
• overhead_conductors (type: esriFieldTypeString, alias: Overhead Conductors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no_conductors: No Conductors], [communication: Communication], [service: Service], ... 2 more ...)
• comments_notes (type: esriFieldTypeString, alias: Comments & Notes, SQL Type: sqlTypeOther, length: 3000, nullable: true, editable: true)
• location_category (type: esriFieldTypeString, alias: Location Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [other: Other], [behind_sidewalk: Behind Sidewalk], [no_sidewalk: No Sidewalk], ... 3 more ...)
• tree_street (type: esriFieldTypeString, alias: Tree Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nearest_address (type: esriFieldTypeString, alias: Nearest Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• park_name (type: esriFieldTypeString, alias: Park Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [aldersgate_park: Aldersgate Park], [bark_park: Bark Park], [barr_park: Barr Park], ... 25 more ...)
• common_name (type: esriFieldTypeString, alias: Common Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latin_genus (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latin_specific_epithet (type: esriFieldTypeString, alias: Specific Epithet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• variety (type: esriFieldTypeString, alias: Variety, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dbh_class (type: esriFieldTypeDouble, alias: DBH Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1.5: 00 - 03 in], [4.5: 03 - 06 in], [9: 06 - 12 in], ... 7 more ...)
• height_class (type: esriFieldTypeInteger, alias: Height Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: 00-10 ft], [15: 10-20 ft], [25: 20-30 ft], ... 8 more ...)
• tree_condition (type: esriFieldTypeInteger, alias: Tree Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Dead], [1: Very Poor], [2: Poor], ... 3 more ...)
• sidewalk_displacement (type: esriFieldTypeInteger, alias: Sidewalk Displacement, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No Deflection], [1: < .75" Deflection], [2: .75"-1.5" Deflection], ... 1 more ...)
• monitor (type: esriFieldTypeString, alias: Monitor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• other_project (type: esriFieldTypeString, alias: Other Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• planting_project (type: esriFieldTypeString, alias: Planting Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pruning_project (type: esriFieldTypeString, alias: Pruning Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• removal_project (type: esriFieldTypeString, alias: Removal Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_planted (type: esriFieldTypeDate, alias: Date Planted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• date_removed (type: esriFieldTypeDate, alias: Date Removed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• plant_priority_score (type: esriFieldTypeDouble, alias: Plant Priority Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• removal_priority_score (type: esriFieldTypeDouble, alias: Removal Priority Score, SQL Type: sqlTypeOther, 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)
• last_survey (type: esriFieldTypeDate, alias: Last Survey, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Stump_Project (type: esriFieldTypeString, alias: Stump Project, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• activity_completed (type: esriFieldTypeString, alias: Activity Completed, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [accident_inspection: Accident Assessment], [condition_note: Condition Note], [damage_inspection: General Damage Assessment], ... 22 more ...)
• Tree_Age (type: esriFieldTypeDouble, alias: Tree Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Reproduction_Cost (type: esriFieldTypeDouble, alias: Reproduction Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height_to_DBH_Ratio (type: esriFieldTypeDouble, alias: Height to DBH Ratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MultiStemmed (type: esriFieldTypeString, alias: Multi-Stemmed?, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [no: No], [yes: Yes])
• Overall_Crown_Condition (type: esriFieldTypeInteger, alias: Overall Crown Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Dead], [1: Very Poor], [2: Poor], ... 3 more ...)
• Overall_Structural_Condition (type: esriFieldTypeInteger, alias: Overall Structural Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Dead], [1: Very Poor], [2: Poor], ... 3 more ...)
• Removal_Cost (type: esriFieldTypeDouble, alias: Removal Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• removal_reason (type: esriFieldTypeString, alias: Removal Reason, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [poor_dead_condition: Poor/Dead Condition], [accident_damage: Accident Damage], [storm_damage: Storm Damage], ... 11 more ...)
• dbh_stem_1 (type: esriFieldTypeDouble, alias: DBH Stem 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 60])
• dbh_stem_2 (type: esriFieldTypeDouble, alias: DBH Stem 2, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 60])
• dbh_stem_3 (type: esriFieldTypeDouble, alias: DBH Stem 3, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 60])
• dbh_stem_4 (type: esriFieldTypeDouble, alias: DBH Stem 4, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 60])
• LastActivityDate (type: esriFieldTypeDate, alias: Last Activity Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Planting_Type (type: esriFieldTypeString, alias: Planting Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [City_Replacement: City - Replacement], [Residential_Development: Residential Development], [Commercial_Development: Commercial Development], ... 7 more ...)
• Planting_Contractor (type: esriFieldTypeString, alias: Planting Contractor, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• planting_date_status (type: esriFieldTypeString, alias: Planting Date Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [observed: Observed at planting], [estimated: Estimated by ring count], [unknown_date: Unknown date])
• PHC_Project (type: esriFieldTypeString, alias: PHC Project, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• survey_project (type: esriFieldTypeString, alias: Survey Project, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• survey_collection (type: esriFieldTypeString, alias: Survey collection?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [yes: Yes, surveying], [no: No, not surveying])
• DBH_Class_Simplified (type: esriFieldTypeInteger, alias: DBH Class Simplified, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: 00 - 06 in], [9: 06 - 12 in], [15: 12 - 18 in], ... 6 more ...)
• Trade_Name (type: esriFieldTypeString, alias: Trade Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• FormValidationCheck (type: esriFieldTypeString, alias: Form Validation Check, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• tra_risk_date (type: esriFieldTypeDate, alias: Date Risk Assessed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• tra_risk_to_person (type: esriFieldTypeString, alias: Risk to Person, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [no_level_2_3: No Level 2+ Initiated], [low: Low], [moderate: Moderate], ... 2 more ...)
• tra_risk_to_property (type: esriFieldTypeString, alias: Risk to Property, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [no_level_2_3: No Level 2+ Initiated], [low: Low], [moderate: Moderate], ... 2 more ...)
• tra_risk_to_infrastructure (type: esriFieldTypeString, alias: Risk to Infrastructure, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [no_level_2_3: No Level 2+ Initiated], [low: Low], [moderate: Moderate], ... 2 more ...)
• tra_overall_risk_rating (type: esriFieldTypeString, alias: Overall Risk Rating, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [no_level_2_3: No Level 2+ Initiated], [low: Low], [moderate: Moderate], ... 2 more ...)
• tra_date_mitigated (type: esriFieldTypeDate, alias: Date of Risk Mitigation, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• site_id (type: esriFieldTypeString, alias: Site ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latin_family (type: esriFieldTypeString, alias: Family, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BasalArea_SqIn (type: esriFieldTypeDouble, alias: Basal Area (Sq In), SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: active
Name: Active
Domains:

Templates:

Name: Active
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• status: active

---

ID: vacant
Name: Vacant
Domains:

Templates:

Name: Vacant
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• status: vacant

---

ID: archived
Name: Archived
Domains:

Templates:

Name: Archived
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• status: archived

---

Relationships:

• tree_sites_tree_activity (0) -- Related To: Tree Activity (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/29/2026 6:36:19 PM

Schema Last Edit Date: 9/29/2026 6:36:07 PM

Data Last Edit Date: 9/29/2026 6:36: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