Name: GSP Forest Monitoring Understory Info

Display Field: LT_COMMON_NAME

Type: Table

Description: This table includes cover abundance, field notes and data management notes for understory plant species. Each row represents an individual species 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 the table to the species names table. Originally, the monitoring protocol used categorical cover-abundance scales based on the Braun-Blanquet cover-class method, with the percentage cover later calculated using the mid-point of the cover class. Eventually the protocol was revised to specify that surveyors estimate precise visual estimates of cover-abundance to the nearest 1%. For mapping mid-point values to the corresponding cover class, see the cover class key.

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)
• COVER (type: esriFieldTypeDouble, alias: Percent Cover, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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 Understory Info
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• DPR.GSP_FM_Visit_Info_RT (1) -- 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