Name: SPR Trees

Display Field: PARK

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: DPR.Trees_PT is a feature class containing location and attribute data of individual trees inventoried in Seattle parks. Attribute data collected in DPR's tree inventory includes tree ID, species/common name, park name, plant date, watering year, etc. Each inventoried tree has routine maintenance activities recorded over time, and these maintenance logs/inspections are managed within DPR.Tree_Work_RT (related table). Tree inventory data is maintained by Seattle Parks & Recreation's Urban Forestry administration.

Copyright Text: Seattle Parks Urban Forestry

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1245914.31648648
YMin: 156168.471581385
XMax: 1408825.24624139
YMax: 271424.248615295
Spatial Reference: 2926 (2926)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[192,255,162,255],"size":8.25,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[35,112,69,255],"width":0.9}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• TREE_ID (type: esriFieldTypeInteger, alias: Tree ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PARK (type: esriFieldTypeString, alias: Park Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PMA_ID (type: esriFieldTypeString, alias: PMA ID, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• COMMON (type: esriFieldTypeString, alias: Tree Common Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Accolade Cherry: Accolade Cherry], [Afterburner Tupelo: Afterburner Tupelo], [Akebono Yoshino Cherry: Akebono Yoshino Cherry], ... 454 more ...)
• SPECIES (type: esriFieldTypeString, alias: Tree Species, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Abies amabilis: Abies amabilis], [Abies balsamea: Abies balsamea], [Abies concolor: Abies concolor], ... 454 more ...)
• DBH_WL (type: esriFieldTypeDouble, alias: DSH (Tree Work Log), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEIGHT_WL (type: esriFieldTypeDouble, alias: Height (Tree Work Log), SQL Type: sqlTypeOther, nullable: true, editable: true)
• GIS_CREATE_DT (type: esriFieldTypeDate, alias: Date Inventoried, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• STATUS (type: esriFieldTypeString, alias: Current Tree Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Existing: Existing], [Removed: Removed], [Snag: Snag])
• TYPE (type: esriFieldTypeString, alias: Tree Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Conifer: Conifer], [Deciduous: Deciduous], [Deciduous Conifer: Deciduous Conifer], ... 2 more ...)
• OWNERSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PARK: Parks and Recreation], [PRIV: Property Owner], [SCL: Seattle City Light], ... 5 more ...)
• GSI_TREE (type: esriFieldTypeString, alias: GSI Contributing Tree , SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PIL (type: esriFieldTypeString, alias: Payment In Lieu, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• EXCEPTIONAL_WL (type: esriFieldTypeString, alias: Exceptional (Tree Work Log), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GIS_CREATOR (type: esriFieldTypeString, alias: GIS_CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• GIS_EDITOR (type: esriFieldTypeString, alias: GIS_EDITOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• GIS_EDT_DT (type: esriFieldTypeDate, alias: GIS_EDT_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• SE_ANNO_CAD_DATA (type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: SPR Trees
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• STATUS: Existing
• GSI_TREE: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/11/2025 6:27:43 PM

Schema Last Edit Date: 8/11/2025 6:27:43 PM

Data Last Edit Date: 8/11/2025 6:27:43 PM

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