Name: Tree Hazard & Health

Display Field: AssessmentDate

Type: Table

Description: The Tree Hazard & Health table contains the fields necessary for performing a tree hazard and health assessment. It is closely related to the Plant Center point feature class meaning that any Plant Center feature may have one or more assessment records associated with it.It is recommended that health and hazard data be collected by a certified arborist. Once all data has been collected the Calculate Condition Rating Field and Calculate Hazard Rating Field tools in the Public Garden Tools toolbox can be run to produce condition and hazard ratings for all assessed trees.

Copyright Text:

Max Record Count: 10000

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)
• FeatureID (type: esriFieldTypeInteger, alias: FeatureID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssessmentDate (type: esriFieldTypeDate, alias: Assessment Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AssessmentUserName (type: esriFieldTypeString, alias: Assessment User Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DBH (type: esriFieldTypeSingle, alias: DBH (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height (type: esriFieldTypeSingle, alias: Height (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReducedHeight (type: esriFieldTypeSmallInteger, alias: Reduced Height, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• UnbalancedCrown (type: esriFieldTypeSmallInteger, alias: Unbalanced Crown, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• WeakFoliage (type: esriFieldTypeSmallInteger, alias: Weak Foliage, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• Defoliation (type: esriFieldTypeSmallInteger, alias: Defoliation, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• BrokenBranches (type: esriFieldTypeSmallInteger, alias: Broken Branches, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• BranchAttachment (type: esriFieldTypeSmallInteger, alias: Branch Attachment, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• Lean (type: esriFieldTypeSmallInteger, alias: Lean, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• PruningScars (type: esriFieldTypeSmallInteger, alias: Pruning Scars, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• TrunkScars (type: esriFieldTypeSmallInteger, alias: Trunk Scars, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• Conks (type: esriFieldTypeSmallInteger, alias: Conks, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Present])
• BranchRotCavities (type: esriFieldTypeSmallInteger, alias: Branch Rot/Cavity, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• TrunkRotCavities (type: esriFieldTypeSmallInteger, alias: Trunk Rot/Cavity, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• Cracks (type: esriFieldTypeSmallInteger, alias: Cracks, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• ConfinedSpace (type: esriFieldTypeSmallInteger, alias: Confined Space, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• RootTrenching (type: esriFieldTypeSmallInteger, alias: Root Trenching, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• GirdlingRoots (type: esriFieldTypeSmallInteger, alias: Girdling Roots, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• FailurePotential (type: esriFieldTypeSmallInteger, alias: Failure Potential, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Low], [2: Medium], [3: High], ... 1 more ...)
• FailurePartSize (type: esriFieldTypeSmallInteger, alias: Failure Part Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: < 15cm], [2: 15 - 45cm], [3: 45 - 75cm], ... 1 more ...)
• TargetRating (type: esriFieldTypeSmallInteger, alias: Target Rating, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Occasional Use], [2: Intermittent Use], [3: Frequent Use], ... 1 more ...)
• InsectOrder1 (type: esriFieldTypeString, alias: Insect Order 1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Acari: Acari], [Coleoptera: Coleoptera], ... 4 more ...)
• InsectFamily1 (type: esriFieldTypeString, alias: Insect Family 1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Aleyrodidae: Aleyrodidae], [Aphididae: Aphididae], ... 13 more ...)
• InsectGenus1 (type: esriFieldTypeString, alias: Insect Genus 1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Andricus: Andricus], [Antron: Antron], ... 16 more ...)
• InsectSpecies1 (type: esriFieldTypeString, alias: Insect Species 1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [axyridis: axyridis], [brimblecombei: brimblecombei], ... 15 more ...)
• InsectCommonName1 (type: esriFieldTypeString, alias: Insect Common Name 1, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Ant species: Ant species], [Aphid species: Aphid species], ... 31 more ...)
• InsectSeverity1 (type: esriFieldTypeSmallInteger, alias: Insect Severity 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• InsectOrder2 (type: esriFieldTypeString, alias: Insect Order 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Acari: Acari], [Coleoptera: Coleoptera], ... 4 more ...)
• InsectFamily2 (type: esriFieldTypeString, alias: Insect Family 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Aleyrodidae: Aleyrodidae], [Aphididae: Aphididae], ... 13 more ...)
• InsectGenus2 (type: esriFieldTypeString, alias: Insect Genus 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Andricus: Andricus], [Antron: Antron], ... 16 more ...)
• InsectSpecies2 (type: esriFieldTypeString, alias: Insect Species 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [axyridis: axyridis], [brimblecombei: brimblecombei], ... 15 more ...)
• InsectCommonName2 (type: esriFieldTypeString, alias: Insect Common Name 2, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Ant species: Ant species], [Aphid species: Aphid species], ... 31 more ...)
• InsectSeverity2 (type: esriFieldTypeSmallInteger, alias: Insect Severity 2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• InsectOrder3 (type: esriFieldTypeString, alias: Insect Order 3, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Acari: Acari], [Coleoptera: Coleoptera], ... 4 more ...)
• InsectFamily3 (type: esriFieldTypeString, alias: Insect Family 3, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Aleyrodidae: Aleyrodidae], [Aphididae: Aphididae], ... 13 more ...)
• InsectGenus3 (type: esriFieldTypeString, alias: Insect Genus 3, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Andricus: Andricus], [Antron: Antron], ... 16 more ...)
• InsectSpecies3 (type: esriFieldTypeString, alias: Insect Species 3, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [axyridis: axyridis], [brimblecombei: brimblecombei], ... 15 more ...)
• InsectCommonName3 (type: esriFieldTypeString, alias: Insect Common Name 3, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Ant species: Ant species], [Aphid species: Aphid species], ... 31 more ...)
• InsectSeverity3 (type: esriFieldTypeSmallInteger, alias: Insect Severity 3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• PathogenName (type: esriFieldTypeString, alias: Pathogen Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Agrobacterium tumefaciens: Agrobacterium tumefaciens], [Anthracnose: Anthracnose], ... 21 more ...)
• PathogenSeverity (type: esriFieldTypeSmallInteger, alias: Pathogen Severity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Minor], [2: Moderate], ... 1 more ...)
• ConditionRating (type: esriFieldTypeSmallInteger, alias: Condition Rating, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Excellent], [2: Good to Excellent], [3: Good], ... 5 more ...)
• HazardRating (type: esriFieldTypeSmallInteger, alias: Hazard Rating, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Very Low], [2: Very Low], ... 10 more ...)
• ReferenceDocumentURL (type: esriFieldTypeString, alias: Reference Document URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• PlantCenterID (type: esriFieldTypeString, alias: Plant Center ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Guid (type: esriFieldTypeGUID, alias: Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• OBJECTID1 (type: esriFieldTypeDouble, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreeID (type: esriFieldTypeDouble, alias: TreeID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DBH1 (type: esriFieldTypeDouble, alias: DBH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crown_DIA_ (type: esriFieldTypeDouble, alias: Crown_DIA_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height_m_1 (type: esriFieldTypeDouble, alias: Height_m_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreeID_SQ (type: esriFieldTypeDouble, alias: TreeID_SQ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID1 (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Tree Hazard & Health
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• TrunkScars: 0
• TrunkRotCavities: 0
• Defoliation: 0
• TreeConflict:
• BranchAttachment: 0
• Cracks: 0
• SidewalkConflict:
• GirdlingRoots: 0
• SignConflict:
• AssessmentUserName: UNKNOWN
• Lean: 0
• ConfinedSpace: 0
• PruningScars: 0
• RootTrenching: 0
• WeakFoliage: 0
• Conks: 0
• ReducedHeight: 0
• WireConflict:
• UnbalancedCrown: 0
• BrokenBranches: 0
• StuctureConflict:
• BranchRotCavities: 0

Relationships:

• PlantCenter (1) -- Related To: Plant Center (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/7/2022 7:38:52 PM

Schema Last Edit Date: 11/7/2022 7:38:52 PM

Data Last Edit Date: 11/7/2022 7:38:52 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat