Name: presentSpecies

Display Field:

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• SppID (type: esriFieldTypeInteger, alias: Species ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• timeLengthSearched (type: esriFieldTypeInteger, alias: Time Searched, SQL Type: sqlTypeOther, nullable: true, editable: true)
• presenceComments (type: esriFieldTypeString, alias: Presence Record Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• numberFound (type: esriFieldTypeInteger, alias: Number Found, SQL Type: sqlTypeOther, nullable: true, editable: true)
• devaluationTypeId (type: esriFieldTypeInteger, alias: Evaluation Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Casual/Incidental finding], [4: Monitoring, untreated and no treatment planned], [2: Assessing before treatment], ... 1 more ...)
• followUp (type: esriFieldTypeInteger, alias: Follow-Up, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• invasiveImpact (type: esriFieldTypeString, alias: Impact of Invasive, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dbioagentSpeciesId (type: esriFieldTypeInteger, alias: Biocontrol Species Found, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [11: Agapeta zoegana (moth)], [5: Apthona lacertosa (beetle)], [4: Apthona nigriscutis (beetle)], ... 14 more ...)
• biocontrolSpeciesFoundComments (type: esriFieldTypeString, alias: Biocontrol Species Found Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• foundAliveInd (type: esriFieldTypeString, alias: Found Alive, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• jinvasiveEvidences (type: esriFieldTypeString, alias: Evidence of Invasive, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• danimalDistributionId (type: esriFieldTypeInteger, alias: Distribution, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Single individual or small group], [2: Scattered individuals or groups], [3: Densely Populated], ... 1 more ...)
• InsectInfestSev (type: esriFieldTypeInteger, alias: Infestation Severity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Low], [2: Medium], [3: High])
• eggCount (type: esriFieldTypeInteger, alias: Egg Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• larvaCount (type: esriFieldTypeInteger, alias: Larva Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• plantsAffectedCount (type: esriFieldTypeInteger, alias: Plants Affected Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adultCount (type: esriFieldTypeInteger, alias: Adult Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• jinsectLifeStages (type: esriFieldTypeString, alias: Insect Life Stage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• jinsectLocationFounds (type: esriFieldTypeInteger, alias: Location(s) Found, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Human structure], [2: On Vegetation], [3: In Soil], ... 1 more ...)
• janimalLocationUses (type: esriFieldTypeString, alias: Location Use(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dplantDistributionId (type: esriFieldTypeInteger, alias: Distribution, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Trace (Single plant/clump)], [2: Sparse (Scattered plants/clumps)], [5: Dense plants/clumps], ... 2 more ...)
• percCoverType (type: esriFieldTypeString, alias: Select how to display percent cover, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [percent: Enter Percent Cover], [class: Select Percent Cover Class])
• dcoverClassId (type: esriFieldTypeInteger, alias: Percent Cover, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: less than 5%], [1: 5% - 25%], [2: 26% - 50%], ... 2 more ...)
• percentCover (type: esriFieldTypeInteger, alias: Percent Cover, SQL Type: sqlTypeOther, nullable: true, editable: true)
• jphenologies (type: esriFieldTypeString, alias: Phenologies, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dwoodyPlantMaturityId (type: esriFieldTypeInteger, alias: Age of Woody Plants, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Seedlings], [2: Mature], [3: Both seedling and mature present])
• intentionalPlantingInd (type: esriFieldTypeString, alias: Intentional Planting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• juvenileCount (type: esriFieldTypeInteger, alias: Juvenile Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adultCountOther (type: esriFieldTypeInteger, alias: Adult Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• maleCount (type: esriFieldTypeInteger, alias: Male Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• femaleCount (type: esriFieldTypeInteger, alias: Female Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• animalTraitComments (type: esriFieldTypeString, alias: Animal Trait Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• janimalLocationUsesOther (type: esriFieldTypeString, alias: Location Use(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• Presences_presentSpecies (6) -- Related To: Presences (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/7/2023 5:01:27 PM

Schema Last Edit Date: 11/7/2023 4:55:31 PM

Data Last Edit Date: 11/7/2023 5:01:27 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat