Name: TreeFailure_12Feb19_Mod21x

Display Field: AGOL_Username

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: Feature layer for creating a complete set of tree failure attributes from final ITFD attribute corrections and additions for Survey123 forms. Mod21x on 22Feb19. Production dataframe and feature layer. Added expanded tree species domain.

Copyright Text: CTFRP, ITFD, USDA FS, Forest Health, Western Tree Failure Database, Dudley R. Hartel, Jim Blodgett

Min. Scale: 10000000

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9385466.547
YMin: 3996574.8754
XMax: -9381555.7497
YMax: 3998863.23860001
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"2390f0a4b012fe3286d1abf70c2378c1","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAINJREFUKJG9kEsKg0AQRJ8y6BniXYIbXWQhOZC6CATv48ILeBg9w0CcdjXYEfwQgrWrqn5QtGGlxxCnIeTed4mtdG/WQBTYuxNKFe0DR/oNKAbEB06+D3QH8euiSWFArSalQOa97j5CbwDaG28fPkdwsgC6A/uPtwoOmE4DbUIDNFvADH+IIWXdlpr/AAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"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)
• ITFD_FormBeginTime (type: esriFieldTypeDate, alias: Cooperator Starts Failure Report (Date/Time), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ArboristCooperator (type: esriFieldTypeString, alias: Failure Reported By (Initials, name, or e-mail), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ArboristCooperatorEmail (type: esriFieldTypeString, alias: e-Mail for Echo of Data Entered (ITFD), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• AGOL_Username (type: esriFieldTypeString, alias: AGOL Obtained Username (ITFD), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• AGOL_Email (type: esriFieldTypeString, alias: AGOL Obtained e-Mail of Cooperator (ITFD), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• DateOfReport (type: esriFieldTypeDate, alias: Report Date and Time (ITFD), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TreeGenusSpecies (type: esriFieldTypeString, alias: Select Genus or Species, SQL Type: sqlTypeOther, length: 6, nullable: false, editable: true, Coded Values: [Note1: Genus level cankers/fungi/tree will use "genus" in the common name or "spp." in the Latin name.], [Note2: Domain codes with the "x" suffix will prompt user in the Survey123 form for the species.], [Note3: In the Survey123 Excel workbook for the form, delete the genus level rows in the choices worksheet not needed.], ... 401 more ...)
• TreeSpeciesCultivar (type: esriFieldTypeString, alias: Species and Cultivar for Spp and Other, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• TreeDBH (type: esriFieldTypeDouble, alias: Tree Diameter (DBH), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreeHeight (type: esriFieldTypeDouble, alias: Tree Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreeAge (type: esriFieldTypeSmallInteger, alias: Age of Tree (Known), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SiteTreeOwnership (type: esriFieldTypeString, alias: Tree or Site Ownership Class, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [COUNTY: County/Parish], [FNBIA: Fed./Nat. (BIA)], [FNBLM: Fed./Nat. (BLM)], ... 11 more ...)
• SiteFederalType (type: esriFieldTypeString, alias: Specific Federal Ownership (CTFRP), SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• SiteAddressName (type: esriFieldTypeString, alias: Address/Site Details, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• TreeFailureType (type: esriFieldTypeString, alias: Type of Tree Failure, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [RF: Root Failure], [TF: Trunk Failure], [BF: Branch Failure])
• RootFailureType (type: esriFieldTypeString, alias: Type of Root Failure, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [BROK: Root Broken], [CUT: Root Cut], [PLATE: Root Plate Lifted], ... 1 more ...)
• RootBrokenDiameter (type: esriFieldTypeDouble, alias: Diameter of Largest Broken Root (OB), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootBrokenDistance (type: esriFieldTypeDouble, alias: Distance from Trunk to Root Break, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootBrokenCondition (type: esriFieldTypeString, alias: Condition of Broken Root (At Failure), SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [DEADND: Dead - No Decay], [DEADD: Dead - Decay], [LIVEND: Live - No Decay], ... 3 more ...)
• RootCutDiameter (type: esriFieldTypeDouble, alias: Diameter of Largest Cut Root (OB), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootCutDistance (type: esriFieldTypeDouble, alias: Distance from Trunk to Cut Root, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootCutPercent (type: esriFieldTypeSmallInteger, alias: % of Rooting Area Affected by Cut(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootCutNumber (type: esriFieldTypeSmallInteger, alias: Number of Roots Cut (CTFRP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootPlateRadius (type: esriFieldTypeDouble, alias: Root Plate Radius (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootPlateDepth (type: esriFieldTypeDouble, alias: Root Plate Depth (Average at midpoint), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootRestrictedCause (type: esriFieldTypeString, alias: Cause of Root Restriction, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [CON: Container], [NAT: Natural Feature], [OTHR: Other], ... 3 more ...)
• RootRestrictedDistance (type: esriFieldTypeDouble, alias: Distance from Trunk to Root Restriction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootRestrictedPercent (type: esriFieldTypeSmallInteger, alias: % of Rooting Area Affected by Restriction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootCollarStatus (type: esriFieldTypeString, alias: Root Collar Status, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NGIRD: Not Girdled], [GIRDMN: Girdled (Minimal Effect)], [GIRD25: Girdled (≤25% Circumference)], ... 4 more ...)
• RootGirdlingCircum (type: esriFieldTypeSmallInteger, alias: % of Circumference affected by Root Girdling (CTFRP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• GotSoil (type: esriFieldTypeString, alias: Do you have soil info to enter?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [XFS: Excluded from Subset])
• SoilTexture (type: esriFieldTypeString, alias: Predominant Soil Texture, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [CLAY: Clay], [LOAM: Loam], [ROCK: Rock or Gravel], ... 4 more ...)
• SoilMoisture (type: esriFieldTypeString, alias: Soil Moisture at Failure Time, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [DRY: Dry], [FLOOD: Flooded], [MOIST: Moist], ... 3 more ...)
• SoilRestrictedDepthCause (type: esriFieldTypeString, alias: Cause of Restricted Rooting Depth, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: Not Depth Restricted], [BEDR: Bedrock], [COMP: Compacted Soil], ... 5 more ...)
• SoilSiteConditionsOther (type: esriFieldTypeString, alias: Other Soil Related Site Conditions [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: None], [COMP: Compaction], [FILLTx: Fill at Trunk (Root Collar)], ... 7 more ...)
• SoilFillDepth (type: esriFieldTypeDouble, alias: Depth of Excess Fill Soil at Trunk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ITFD_SoilsNRCS (type: esriFieldTypeString, alias: General Soil Map Units (ITFD), SQL Type: sqlTypeOther, length: 72, nullable: true, editable: true)
• RootDefects (type: esriFieldTypeString, alias: Root Defects Associated with Failure [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: None Observed], [CRAK: Cracks - Lower Stem or Buttress Roots], [GIRRO: Girdling (Roots)], ... 11 more ...)
• RootTrenchDistance (type: esriFieldTypeDouble, alias: Distance from Trunk to Trench (CTFRP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootDecayPercent (type: esriFieldTypeSmallInteger, alias: % of Buttress Roots Decayed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootDecayClass (type: esriFieldTypeString, alias: Root Decay Type, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [BRWN: Brown Rot], [CANK: Canker Rot], [WHIT: White Rot], ... 2 more ...)
• RootFungusStatus (type: esriFieldTypeString, alias: Root Fungus Signs, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: None Observed], [AMAN: Destroying Angel (Amanita spp.)], [AMANx: Destroying Angel (Amanita spp.)], ... 59 more ...)
• RootFungusSpecies (type: esriFieldTypeString, alias: Root Fungus Species for Spp and Other, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• RootDecaySoundThickness (type: esriFieldTypeDouble, alias: Average Sound Wood Thickness at Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RootSurfaceTreatment (type: esriFieldTypeString, alias: Root Surface Treatment [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BARE: Bare Soil], [GRNDC: Goundcover (Maintained)], [ROCK: Gravel or Rock (Crushed)], ... 7 more ...)
• RootIrrigation (type: esriFieldTypeString, alias: Tree/Landscape Irrigation, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: Never], [FREQ: Frequently (Manual)], [INFREQ: Infrequently (Manual)], ... 3 more ...)
• TrunkFailureHeight (type: esriFieldTypeDouble, alias: Height Above Grade of Trunk Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrunkFailureDiameter (type: esriFieldTypeDouble, alias: Trunk Diameter at Failure (IB), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrunkDefects (type: esriFieldTypeString, alias: Trunk Defects Associated with Failure [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: None], [BOW: Bow], [CANK: Canker], ... 24 more ...)
• TrunkCankerSpecies (type: esriFieldTypeString, alias: Trunk Canker Genus/Species (Common or Latin), SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [None: None Observed], [BORI: Botryosphaeria Canker (Botryosphaeria ribis)], [BOTR: Botryodiplodia Canker (Botryodiplodia spp.)], ... 27 more ...)
• TrunkCankerOther (type: esriFieldTypeString, alias: TrunkCankerOther, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• TrunkCankerOpenStatus (type: esriFieldTypeString, alias: Trunk Canker Opening Status, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Note1: Confirgurable drop-down list for canker wound classes (% circumference as integer NOT used)], [NWND: No Canker], [CNMIN: Canker (Minimal)], ... 16 more ...)
• TrunkCankerCircum (type: esriFieldTypeSmallInteger, alias: Trunk Canker Circumference as %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrunkDecayLocation (type: esriFieldTypeString, alias: Trunk Decay Location, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [HEART: Heartwood], [SAP: Sapwood], [BOTH: Heartwood and Sapwood], ... 1 more ...)
• TrunkSoundWood (type: esriFieldTypeDouble, alias: Average Thickness of Trunk Sound Wood, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrunkOpeningStatus (type: esriFieldTypeString, alias: Open Cavity at Trunk Failure, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Note1: Confirgurable drop-down list for open cavity classes (% circumference as integer NOT used)], [NCAVTY: No Open Cavity], [Note2: ITFD 25% classes (as an example)], ... 13 more ...)
• TrunkOpeningCircum (type: esriFieldTypeSmallInteger, alias: Trunk Opening as % of Circumference (CTFRP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrunkSapwoodDepth (type: esriFieldTypeDouble, alias: Average Depth of Sapwood Decay, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrunkSapwoodCircum (type: esriFieldTypeSmallInteger, alias: Sapwood Decayed as a % of Circumference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrunkFungusStatus (type: esriFieldTypeString, alias: Trunk Fungus Signs, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: None Observed], [AGTU: Crown Gall (Agrobacterium tumefaciens)], [ARME: Honey Fungus (Armillaria mellea)], ... 61 more ...)
• TrunkFungusSpecies (type: esriFieldTypeString, alias: Trunk Fungus Species for Spp and Other, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• TrunkDecayClass (type: esriFieldTypeString, alias: Trunk Decay Type, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [BRWN: Brown Rot], [CANK: Canker Rot], [WHIT: White Rot], ... 2 more ...)
• TrunkConkDistance (type: esriFieldTypeDouble, alias: Distance from Conk to Trunk Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrunkHardware (type: esriFieldTypeString, alias: Identify Trunk Hardware [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: None], [BRACF: Brace/Bolt - Failed], [BRACI: Brace/Bolt - Intact], ... 9 more ...)
• BranchBreakDiameter (type: esriFieldTypeDouble, alias: Branch Break Diameter (IB), SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchLength (type: esriFieldTypeDouble, alias: Total Length of Failed Branch, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchBreakAtAttachment (type: esriFieldTypeString, alias: Branch Break at Attachment, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [XFS: Excluded from Subset])
• BranchBreakAttachmentDistance (type: esriFieldTypeDouble, alias: Distance from Attachment to Break, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchDefects (type: esriFieldTypeString, alias: Branch Defects Associated with Failure [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: None], [CANK: Canker or Gall], [CAVT: Cavity (At Failure)], ... 18 more ...)
• BranchCankerSpecies (type: esriFieldTypeString, alias: Branch Canker Genus/Species (Common or Latin), SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Note1: Genus level cankers will use "genus" in the common name or "spp." in the Latin name.], [Note2: Domain codes with the "x" suffix will prompt user in the Survey123 form for the species.], [APMO: Black Knot (Apiosporina morbosa)], ... 18 more ...)
• BranchCankerOther (type: esriFieldTypeString, alias: BranchCankerOther, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• BranchCankerOpenStatus (type: esriFieldTypeString, alias: Branch Canker Opening Status, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Note1: Confirgurable drop-down list for canker wound classes (% circumference as integer NOT used)], [NWND: No Canker], [CNMIN: Canker (Minimal)], ... 16 more ...)
• BranchCankerCircum (type: esriFieldTypeSmallInteger, alias: Branch Canker Circumference as %, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchDecayLocation (type: esriFieldTypeString, alias: Branch Decay Location, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [HEART: Heartwood], [SAP: Sapwood], [BOTH: Heartwood and Sapwood], ... 1 more ...)
• BranchSoundThickness (type: esriFieldTypeDouble, alias: Average Sound Wood Thickness, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchOpeningStatus (type: esriFieldTypeString, alias: Open Cavity at Branch Failure, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Note1: Confirgurable drop-down list for open cavity classes (% circumference as integer NOT used)], [NCAVTY: No Open Cavity], [Note2: ITFD 25% classes (as an example)], ... 13 more ...)
• BranchOpeningCircum (type: esriFieldTypeSmallInteger, alias: Branch Opening as % of Circumference (CTFRP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchSapwoodDepth (type: esriFieldTypeDouble, alias: Average Depth of Sapwood Decay, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchSapwoodCircum (type: esriFieldTypeSmallInteger, alias: Sapwood Decay as % of Circumference, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchFungusStatus (type: esriFieldTypeString, alias: Branch Fungus Signs, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Note1: Domain codes with the "x" suffix will prompt user in the Survey123 form for the species for genus level entries.], [Note2: Select genus level cankers with the "x" if you want users to enter the species.], [NONE: None Observed], ... 12 more ...)
• BranchFungusSpecies (type: esriFieldTypeString, alias: Branch Fungus Species for Spp and Other, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• BranchDecayClass (type: esriFieldTypeString, alias: Branch Decay Type, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [BRWN: Brown Rot], [CANK: Canker Rot], [WHIT: White Rot], ... 2 more ...)
• BranchConkDistance (type: esriFieldTypeDouble, alias: Distance from Conk to Branch Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BranchHardware (type: esriFieldTypeString, alias: Identify Branch Hardware [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: None], [BRACF: Brace/Bolt - Failed], [BRACI: Brace/Bolt - Intact], ... 9 more ...)
• GotHistory (type: esriFieldTypeString, alias: Do you have tree/site history to enter?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [XFS: Excluded from Subset])
• TreeDefectVisible (type: esriFieldTypeString, alias: Failure Defect Visible Before Failure, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKN: Unknown], ... 1 more ...)
• TreeStatusAtFailure (type: esriFieldTypeString, alias: Tree Condition at Failure, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Note1: Configurable drop-down list for tree condition as failure classes], [Note2: ITFD Tree Failure Reporting Form (~2006)], [ALIVE: Alive], ... 13 more ...)
• TreeAreaConstruction (type: esriFieldTypeString, alias: Recent Construction Around Tree, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: None Evident], [YES1: Yes - <1 Year Ago], [YES15: Yes - 1 to 5 Years Ago], ... 2 more ...)
• ConstructionWhen (type: esriFieldTypeSmallInteger, alias: Years Since Construction (CTFRP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreePruningHistory (type: esriFieldTypeString, alias: Pruning History of Failed Tree [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: No Pruning History], [CLEAN: Cleaned], [CRWNR: Crown Raised], ... 10 more ...)
• TreeCrownRaisedPercent (type: esriFieldTypeSmallInteger, alias: Crown Raised as % of Tree Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreeToppedDiameter (type: esriFieldTypeDouble, alias: Diameter of Largest Stub from Topping, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GotHabitat (type: esriFieldTypeString, alias: Do you have site info to enter?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [XFS: Excluded from Subset])
• TreesRecentlyRemoved (type: esriFieldTypeString, alias: Trees Recently Removed in Vicinity, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKN: Unknown], ... 1 more ...)
• SiteHistory (type: esriFieldTypeString, alias: History of Prior Failures at this Site, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKN: Unknown], ... 1 more ...)
• SiteSetting (type: esriFieldTypeString, alias: Use of Area (Setting), SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [BOAT: Boat Launch], [CAMP: Campground], [UNIV: Campus (Educational)], ... 20 more ...)
• SiteCampgroundUnit (type: esriFieldTypeString, alias: Campground or Picnic (Site) Unit (USDA FS), SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• SiteSettingOther (type: esriFieldTypeString, alias: Describe Setting with 2 or 3 Words, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• SiteAspect (type: esriFieldTypeString, alias: Site Aspect, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: No Aspect/Flat], [NORTH: North], [NE: Northeast], ... 7 more ...)
• SiteSlope (type: esriFieldTypeString, alias: Site Slope, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: No Slope (Flat)], [LT5: ≤5°], [FIFT: >5° and ≤15°], ... 4 more ...)
• DateSeasonChoice (type: esriFieldTypeString, alias: What type of date/time is known for this failure?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [TIMEKN: Date/Time], [DATEKN: Date], [YRMNKN: Year/Month], ... 6 more ...)
• DateFailureYear (type: esriFieldTypeDate, alias: Select Year of Failure, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateFailureSeason (type: esriFieldTypeString, alias: Select Season of Failure, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [WINTER: Winter], [SPRING: Spring], [SUMMR: Summer], ... 2 more ...)
• DateFailure (type: esriFieldTypeDate, alias: Select Failure Date (Month, Day, Year), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateTimeFailure (type: esriFieldTypeDate, alias: Select Failure Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MonthFailure (type: esriFieldTypeString, alias: Month of failure from dates provided (ITFD), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [JAN: January], [FEB: February], [MAR: March], ... 11 more ...)
• GotWeather (type: esriFieldTypeString, alias: Do you have weather info to enter?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [XFS: Excluded from Subset])
• SiteWindSpeed (type: esriFieldTypeSmallInteger, alias: Wind Speed at Failure or Maximum During Storm, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SiteWindStatus (type: esriFieldTypeString, alias: Wind Speed Above Average (USDA FS), SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [UNKN: Unknown], ... 1 more ...)
• SiteTemperature (type: esriFieldTypeSmallInteger, alias: Temperature at Time of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SitePrecipitation (type: esriFieldTypeString, alias: Precipitation at Time of Failure, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: None], [ICE: Ice], [RAIN: Rain], ... 3 more ...)
• GotResults (type: esriFieldTypeString, alias: Do you have failure results to enter?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [XFS: Excluded from Subset])
• WhyTreeFailed (type: esriFieldTypeString, alias: Why Did This Tree Fail, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• TreeFailureResult (type: esriFieldTypeString, alias: Resulting Damage from Failure [MS], SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: None (Other Than Failure)], [FIRE: Fire], [LOSL: Loss or Damage of Landscape], ... 8 more ...)
• DamagePropertyEstimated (type: esriFieldTypeInteger, alias: Estimate of Property Damage ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DamageCleanUpCosts (type: esriFieldTypeInteger, alias: Estimate of Cleanup Costs ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ArboristNotes (type: esriFieldTypeString, alias: Arborist Notes, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• MeasuresEstimated (type: esriFieldTypeString, alias: Identify Measurements Estimated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NONE: All Values Measured], [AGE: Tree Age], [DBH: Tree Diameter], ... 8 more ...)
• ITFD_MetricFlag (type: esriFieldTypeString, alias: Metric Units Used (Default = NO), SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No], [XFS: Excluded from Subset])
• ITFD_UTC_Offset (type: esriFieldTypeSmallInteger, alias: Offset (in hours) from UTC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ITFD_LocDesc (type: esriFieldTypeString, alias: Location Description (CTFRP), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ITFD_ReportID (type: esriFieldTypeString, alias: Report ID (CTFRP), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ITFD_SurveyVersion (type: esriFieldTypeString, alias: Version (i.e. subset) of Survey123 (ITFD), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ITFD_ProcessStatus (type: esriFieldTypeString, alias: Processing Status (ITFD), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ITFD_Echo (type: esriFieldTypeString, alias: Would you like a copy of this tree failure report?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [NONE: No copy needed], [DNOW: Send a copy of this report today], [DALL: Send this report and all pending data today], ... 3 more ...)
• ITFD_Latitude_Y (type: esriFieldTypeDouble, alias: GPS Latitude (CTFRP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ITFD_Longitude_X (type: esriFieldTypeDouble, alias: GPS Longitude (CTFRP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ITFD_Country (type: esriFieldTypeString, alias: Country (CTFRP), SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• ITFD_ProvinceState (type: esriFieldTypeString, alias: Province or State (CTFRP), SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• ITFD_ParishCounty (type: esriFieldTypeString, alias: Parish or County (CTFRP), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ITFD_City (type: esriFieldTypeString, alias: City or Municipal Area (CTFRP), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ITFD_PostalCode (type: esriFieldTypeString, alias: Country Postal Code (Zipcode), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ITFD_Park (type: esriFieldTypeString, alias: Park (Local, State, National) (CTFRP), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ITFD_FS_Region (type: esriFieldTypeString, alias: USFS Region (CTFRP), SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• ITFD_FS_Forest (type: esriFieldTypeString, alias: USFS National Forest (CTFRP), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ITFD_FS_RangerDistrict (type: esriFieldTypeString, alias: USFS Ranger District (CTFRP), SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ITFD_Campground (type: esriFieldTypeString, alias: Campground (CTFRP), SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• ITFD_FormEndTime (type: esriFieldTypeDate, alias: Cooperator Ends Failure Report (Date/Time), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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: TreeFailure_01Feb19_Mod21x
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• MeasuresEstimated: NONE
• TreeGenusSpecies:
• GotSoil: NO
• GotHabitat: NO
• GotWeather: NO
• GotResults: NO
• ITFD_MetricFlag: NO
• ITFD_Echo: NONE

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/12/2019 11:45:15 PM

Schema Last Edit Date: 2/12/2019 11:45:15 PM

Data Last Edit Date: 2/12/2019 11:45:15 PM

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