Name: Visit

Display Field: SurveyorName

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ObjectID_1 (type: esriFieldTypeInteger, alias: ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalIDOriginal (type: esriFieldTypeString, alias: GlobalIDOriginal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Survey123ObjectID (type: esriFieldTypeInteger, alias: Survey123ObjectID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParentGlobalID (type: esriFieldTypeString, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: created_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)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• SurveyorName (type: esriFieldTypeString, alias: SurveyorName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SurveyorAgency (type: esriFieldTypeString, alias: SurveyorAgency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SurveyDate (type: esriFieldTypeDate, alias: SurveyDate , SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MOBSigns (type: esriFieldTypeString, alias: MOBSigns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no: no], [yes: yes], [maybe: maybe])
• WhatSignsPresent (type: esriFieldTypeString, alias: WhatSignsPresent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [frass: frass], [galleries: galleries], [tiny entrance holes: tiny entrance holes], ... 1 more ...)
• TreeCanopyDiebackClass (type: esriFieldTypeString, alias: TreeCanopyDiebackClass, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Healthy: Healthy normal tree canopy], [10%: 10% of tree canopy has died, 90% of tree canopy is healthy], [30%: 30% of tree canopy has died, 70% of tree canopy is healthy], ... 5 more ...)
• SampleCollected (type: esriFieldTypeString, alias: SampleCollected, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: yes], [no: no])
• SampleSubmittedToODA (type: esriFieldTypeString, alias: SampleSubmittedToODA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: yes], [no: no])
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 284, nullable: true, editable: true)
• SampleID (type: esriFieldTypeString, alias: SampleID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• x (type: esriFieldTypeDouble, alias: x, SQL Type: sqlTypeOther, nullable: true, editable: true)
• y (type: esriFieldTypeDouble, alias: y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParentGUID (type: esriFieldTypeGUID, alias: ParentGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• ESRI_UserName (type: esriFieldTypeString, alias: ESRI Username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ParentSiteTreeStatus (type: esriFieldTypeString, alias: Site Tree Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TreeRemoved (type: esriFieldTypeString, alias: Tree Removed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• TreeRemovalDate (type: esriFieldTypeDate, alias: Tree Removal Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CanopyClass (type: esriFieldTypeString, alias: Canopy Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Full sun: Full sun], [Partial sun: Partial sun], [Shade: Shade], ... 1 more ...)
• CrownRatio (type: esriFieldTypeString, alias: Crown Ratio, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Out of season: Out of season], [Ninety percent: Ninety percent], [Seventy percent: Seventy percent], ... 3 more ...)
• EpicormicShoots (type: esriFieldTypeString, alias: Epicormic Shoots, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• TreeDamage (type: esriFieldTypeString, alias: Tree Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [storm damage/breakage: storm damage/breakage], [adjacent construction, road, driveway, etc.: adjacent construction, road, driveway, etc.], ... 1 more ...)
• FungalSigns (type: esriFieldTypeString, alias: Fungal Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [signs of root or butt rot: signs of root or butt rot], [exterior fungal conks: exterior fungal conks], [other: other])
• FungalSignsSpeciesOther (type: esriFieldTypeString, alias: Fungal Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Mistletoe (type: esriFieldTypeString, alias: Mistletoe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: 0 Plants], [1-10: 1-10 Plants], [11-30: 11-30 Plants], ... 1 more ...)
• DeadBranches (type: esriFieldTypeString, alias: Dead Branches, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [multiple minor branches are dead: multiple minor branches are dead], [1 major branch is dead: 1 major branch is dead], [>1 major branch is dead: >1 major branch is dead], ... 2 more ...)
• ODASampleConfirmationResults (type: esriFieldTypeString, alias: ODA Sample Confirmation Results, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [In process: In process], [Yes: Yes, confirmed MOB], [No: No, not MOB])
• PesticideTreatment (type: esriFieldTypeString, alias: Pesticide Treatment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ParentDBH (type: esriFieldTypeInteger, alias: Parent DBH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParentStreetAddress (type: esriFieldTypeString, alias: Parent Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PesticideTreatmentDate (type: esriFieldTypeDate, alias: Pesticide Treatment Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HotlineReportNumber (type: esriFieldTypeString, alias: Hotline Report #, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TreeStressSigns (type: esriFieldTypeString, alias: Tree Stress Signs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [breakage or scarring: breakage or scarring], [fungi: fungi], [mistletoe: mistletoe], ... 4 more ...)
• OtherTreeStressSigns (type: esriFieldTypeString, alias: Other Signs of Tree Stress, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PesticideName (type: esriFieldTypeString, alias: Pesticide Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PesticideApplicatorCompanyNam (type: esriFieldTypeString, alias: Pesticide Applicator Company Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ParentObjectID (type: esriFieldTypeString, alias: Parent Object ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ThinningCrown (type: esriFieldTypeString, alias: Thinning Tree Crown, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Signs_Frass (type: esriFieldTypeString, alias: Frass, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Signs_Tiny_Holes (type: esriFieldTypeString, alias: Tiny Holes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Signs_Galleries (type: esriFieldTypeString, alias: Galleries, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Signs_Beetles (type: esriFieldTypeString, alias: Beetles, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Signs_Wood_Dust (type: esriFieldTypeString, alias: Wood Dust, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Parent_Is_Oak (type: esriFieldTypeString, alias: Parent Is Oak, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parent_Oak_Species (type: esriFieldTypeString, alias: Parent Oak Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parent_Adjacent_Oaks (type: esriFieldTypeString, alias: Parent Adjacent Oaks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parent_DBH_Class (type: esriFieldTypeString, alias: Parent DBH Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Visit
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• Site_Tree (0) -- Related To: Site_Tree (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/17/2025 8:15:10 PM

Schema Last Edit Date: 7/17/2025 8:15:10 PM

Data Last Edit Date: 7/17/2025 8:15:10 PM

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