Name: Resistant_Tree_Visit_with_TreeID

Display Field: TreeVisitDate

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

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:

Fields:

• TreeVisitDate (type: esriFieldTypeDate, alias: TreeVisitDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PriorityID (type: esriFieldTypeString, alias: Caging Priority, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [High: High], [Med: Medium], [Low: Low], ... 1 more ...)
• MPB (type: esriFieldTypeInteger, alias: MPB, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Present (don't use: old category)], [2: Low (0-20)], ... 2 more ...)
• DBH (type: esriFieldTypeDouble, alias: DBH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreeHeight (type: esriFieldTypeDouble, alias: TreeHeight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BlisterRust (type: esriFieldTypeString, alias: BlisterRust, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• MPBProtectionID (type: esriFieldTypeString, alias: MPBProtectionID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [GLV: Verbenone and Green Leaf Volatiles], [NO: None], [VB: Verbenone], ... 1 more ...)
• ConeCount (type: esriFieldTypeInteger, alias: ConeCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StatusUpdate (type: esriFieldTypeInteger, alias: StatusUpdate, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1. Appears Resistant: Caging Potential], [4: 4. Monitor Resistance], [3: 3. New MPB Strike. Last chance to harvest.], ... 3 more ...)
• HealthNotes (type: esriFieldTypeString, alias: HealthNotes, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• HistoricCankerCount (type: esriFieldTypeInteger, alias: HistoricCankerCount, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [9: 1-9], [20: 10-20], ... 1 more ...)
• Chewing (type: esriFieldTypeInteger, alias: Chewing, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [-1: Yes])
• Flagging (type: esriFieldTypeInteger, alias: Flagging, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [-1: Yes])
• RoughBark (type: esriFieldTypeInteger, alias: RoughBark, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [-1: Yes])
• Sap (type: esriFieldTypeInteger, alias: Sap, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [-1: Yes])
• Swelling (type: esriFieldTypeInteger, alias: Swelling, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [-1: Yes])
• TreeGUID (type: esriFieldTypeGUID, alias: TreeGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• TreeID (type: esriFieldTypeString, alias: TreeID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SectionID (type: esriFieldTypeInteger, alias: SectionID, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0. JNP Not Part of any Stand], [33: 33. Adolphus Cabin], [32: 32. Adolphus Lake], ... 143 more ...)
• AlternateTreeIDs (type: esriFieldTypeString, alias: AlternateTreeIDs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TagNumber (type: esriFieldTypeInteger, alias: TagNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PineType (type: esriFieldTypeString, alias: PineType, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [WBP: WBP], [LP: Limber])
• DateDiscovered (type: esriFieldTypeDate, alias: DateDiscovered, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• VisitStatus (type: esriFieldTypeInteger, alias: VisitStatus, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not in Resistant Study], [1: Resistant Study], [2: Removed from Study], ... 3 more ...)
• StatusReason (type: esriFieldTypeString, alias: StatusReason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DiscoveryMethod (type: esriFieldTypeString, alias: DiscoveryMethod, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [HTS: 100 Tree Survey], [OBS: Observation], [TRA: Health Transect], ... 2 more ...)
• Survey100Trees (type: esriFieldTypeString, alias: Survey100Trees, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• EastingUTM11N (type: esriFieldTypeDouble, alias: EastingUTM11N, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NorthingUTM11N (type: esriFieldTypeDouble, alias: NorthingUTM11N, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Directions (type: esriFieldTypeString, alias: Directions, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• Comments100Trees (type: esriFieldTypeString, alias: Comments100Trees, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• Aspect (type: esriFieldTypeInteger, alias: Aspect, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: N], [2: NE], [3: E], ... 5 more ...)
• SurveyStartEnd (type: esriFieldTypeString, alias: SurveyStartEnd, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [S: First Survey Tree], [E: Last Survey Tree])
• InitialMPB (type: esriFieldTypeInteger, alias: InitialMPB, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• ConeCount_1681311733854 (type: esriFieldTypeInteger, alias: ConeCount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CankerCount (type: esriFieldTypeInteger, alias: CankerCount, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [9: 1-9], [20: 10-20], ... 1 more ...)
• DBH_cm (type: esriFieldTypeDouble, alias: DBH_cm, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InitialStatus (type: esriFieldTypeInteger, alias: InitialStatus, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1. Appears Resistant: Caging Potential], [4: 4. Monitor Resistance], [3: 3. New MPB Strike. Last chance to harvest.], ... 3 more ...)
• BlisterRust_1681311733854 (type: esriFieldTypeString, alias: BlisterRust, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• OtherInfection (type: esriFieldTypeString, alias: OtherInfection, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• HistoricCankerCount_1681311733854 (type: esriFieldTypeInteger, alias: HistoricCankerCount, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0], [9: 1-9], [20: 10-20], ... 1 more ...)
• PrismLocation (type: esriFieldTypeInteger, alias: Prism Location, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 100 m N of 1st tree], [25: 100 m N of 25th (approx) tree], [50: 100 m N of 50th (approx) tree], ... 2 more ...)
• PrismSweep (type: esriFieldTypeInteger, alias: Prism Sweep, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SiteType (type: esriFieldTypeInteger, alias: SiteType, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Ridge Top], [2: Slope], [3: Bench], ... 1 more ...)
• DeadAlive (type: esriFieldTypeString, alias: Dead or Alive, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Alive: Alive], [Dead: Dead])
• ClimbMethodID (type: esriFieldTypeString, alias: ClimbMethodID, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [FG: From Ground], [LL: Ladder and Lanyards], [LO: Lanyards only], ... 2 more ...)
• ClimbNotes (type: esriFieldTypeString, alias: ClimbNotes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LocationArea (type: esriFieldTypeString, alias: LocationArea, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [BNP: BNP], [GNP: GNP], [JNP: JNP], ... 5 more ...)
• TreeGUID_1681311733854 (type: esriFieldTypeGUID, alias: TreeGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID_1681311733854 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/17/2024 2:49:43 PM

Schema Last Edit Date: 4/12/2023 2:58:59 PM

Data Last Edit Date: 4/12/2023 2:58:59 PM

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