Name: GSP Forest Monitoring Trees Info

Display Field: LT_COMMON_NAME

Type: Table

Description: This table includes the physical dimensions, miscellaneous observations, field notes and data management notes for trees, snags, and coarse woody debris. Each row represents an individual tree, snag or piece of coarse woody debris observed during a plot visit. The table can be related to other tables using the plot ID or visit ID. The species code can be used to relate this table to the species names table.Originally, the monitoring protocol did not require heights or diameters to be measured for regenerating trees when the tier 1 monitoring protocol was used; instead, they were tallied by species. Eventually the protocol was revised to specify that surveyors measure heights and diameter for all trees regardless of the protocol tier. Note that missing values were imputed for these metrics during the QAQC procedure.

Copyright Text: Seattle Parks and Recreation Green Seattle Partnership Urban Forestry

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)
• PLOT_ID (type: esriFieldTypeInteger, alias: Plot ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLOT_ID_OLD (type: esriFieldTypeString, alias: Old Plot ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• VISIT_ID (type: esriFieldTypeString, alias: Visit ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VISIT_ID_OLD (type: esriFieldTypeString, alias: Old Visit ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CODE (type: esriFieldTypeString, alias: Species Code, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [_algae: Algae (algae)], [_building: Building (building)], [_cobble: Cobble (cobble)], ... 929 more ...)
• LT_COMMON_NAME (type: esriFieldTypeString, alias: Common Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LT_SCIENTIFIC_NAME (type: esriFieldTypeString, alias: Scientific Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LT_CATEGORY (type: esriFieldTypeString, alias: Category Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LT_GROWTH_FORM (type: esriFieldTypeString, alias: Growth Form, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [A: Aquatic], [G: Graminoid], [S: Shrub], ... 3 more ...)
• LT_CANOPY_TYPE (type: esriFieldTypeString, alias: Canopy Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LT_NATIVE (type: esriFieldTypeString, alias: Native Species, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• LT_NOTES (type: esriFieldTypeString, alias: Notes (Lookup Table), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HEIGHT (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VINES (type: esriFieldTypeString, alias: Presence of Invasive Vines, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• DECAY_CLASS (type: esriFieldTypeString, alias: Decay Class, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Recently Dead: Recently Dead], [Intermediate Decay: Intermediate Decay], [Advanced Decay: Advanced Decay])
• HEALTH (type: esriFieldTypeString, alias: Health Status of Tree, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Healthy: Healthy], [Stressed: Stressed])
• FIELD_NOTES (type: esriFieldTypeString, alias: Field Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• QAQC_NOTES (type: esriFieldTypeString, alias: QA/QC Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• GUID_KEY (type: esriFieldTypeGUID, alias: GUID Key, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GUID_VISIT (type: esriFieldTypeGUID, alias: GUID_VISIT, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CREATED_USER (type: esriFieldTypeString, alias: CREATED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LAST_EDITED_USER (type: esriFieldTypeString, alias: LAST_EDITED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: LAST_EDITED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: GSP Forest Monitoring Trees Info
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• DPR.GSP_FM_Visit_Info_RT (2) -- Related To: GSP Forest Monitoring Visit Info (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/3/2026 8:30:25 PM

Schema Last Edit Date: 8/3/2026 8:30:25 PM

Data Last Edit Date: 8/3/2026 8:30:25 PM

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