Name: Observations

Display Field: objectid

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 1000

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: sqlTypeGUID, length: 38, nullable: false, editable: false)
• PlantCommon (type: esriFieldTypeString, alias: Name of plant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Acorn squash [Cucurbita pepo var. turbinata]: Acorn squash [Cucurbita pepo var. turbinata]], [African daisy (species unknown) [Osteospermum sp.]: African daisy (species unknown) [Osteospermum sp.]], [Afro-Australian daisy (species unknown) [Dimorphotheca sp.]: Afro-Australian daisy (species unknown) [Dimorphotheca sp.]], ... 983 more ...)
• PlantSci (type: esriFieldTypeString, alias: Scientific name of plant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PlantFreeText (type: esriFieldTypeString, alias: If your plant is not in the dropdown list above, enter it here:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FloralResources (type: esriFieldTypeInteger, alias: Approximate number of flowers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BeesObserved (type: esriFieldTypeString, alias: Did you see any bees, flies, or wasps on this plant?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• BeeType (type: esriFieldTypeString, alias: Bee type(s) observed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HoneyBees (type: esriFieldTypeInteger, alias: Number of honeybees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BumbleBees (type: esriFieldTypeInteger, alias: Number of bumble bees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HairyLegBees (type: esriFieldTypeInteger, alias: Number of hairy leg bees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GreenMetallicBees (type: esriFieldTypeInteger, alias: Number of green metallic bees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StripedSweatBees (type: esriFieldTypeInteger, alias: Number of striped sweat bees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TinyDarkBees (type: esriFieldTypeInteger, alias: Number of tiny dark bees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HairyBellyBees (type: esriFieldTypeInteger, alias: Number of hairy belly bees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CuckooBees (type: esriFieldTypeInteger, alias: Number of cuckoo bees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SyrphidFlies (type: esriFieldTypeInteger, alias: Number of syrphid flies, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BeeFlies (type: esriFieldTypeInteger, alias: Number of bee flies, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BeeInteraction (type: esriFieldTypeString, alias: Did you observe any bee interactions?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• BeeInteractionObserved (type: esriFieldTypeString, alias: Bee interaction observed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CompInteractionObserved (type: esriFieldTypeInteger, alias: Competition Observed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ShdRsrcInteractionObserved (type: esriFieldTypeInteger, alias: Shared Resources Observed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CompetitionObserved (type: esriFieldTypeString, alias: Competition observed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Comp_Honey_Honey (type: esriFieldTypeInteger, alias: Comp_Honey_Honey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comp_Honey_Native (type: esriFieldTypeInteger, alias: Comp_Honey_Native, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comp_Native_Native (type: esriFieldTypeInteger, alias: Comp_Native_Native, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SharedResourcesObserved (type: esriFieldTypeString, alias: Shared resources observed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SR_Honey_Honey (type: esriFieldTypeInteger, alias: SR_Honey_Honey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SR_Honey_Native (type: esriFieldTypeInteger, alias: SR_Honey_Native, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SR_Native_Native (type: esriFieldTypeInteger, alias: SR_Native_Native, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pic1 (type: esriFieldTypeString, alias: Do you have pictures of this observation to share?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Image1Bees (type: esriFieldTypeString, alias: What type(s) of insect is in this picture?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType1 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType2 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType3 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType4 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType5 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType6 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType7 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType8 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType9 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1BeeType10 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Family1 (type: esriFieldTypeString, alias: Family, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Genus1 (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Species1 (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image1Lat (type: esriFieldTypeDouble, alias: Image1Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Image1Lon (type: esriFieldTypeDouble, alias: Image1Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Image1Alt (type: esriFieldTypeDouble, alias: Image1Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pic2 (type: esriFieldTypeString, alias: Do you have a second picture of this observation to share?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• Image2Bees (type: esriFieldTypeString, alias: What type(s) of insect is in this picture?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType1 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType2 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType3 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType4 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType5 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType6 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType7 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType8 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType9 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType10 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Family2 (type: esriFieldTypeString, alias: Family, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Genus2 (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Species2 (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2Lat (type: esriFieldTypeDouble, alias: Image2Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Image2Lon (type: esriFieldTypeDouble, alias: Image2Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Image2Alt (type: esriFieldTypeDouble, alias: Image2Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObsComment (type: esriFieldTypeString, alias: Comments about this observation (optional), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, 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)
• PlantScientific (type: esriFieldTypeString, alias: Scientific name of plant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Common yarrow: Achillea millefolium], [Paprika yarrow: Achillea millefolium 'Paprika'], [Island pink yarrow: Achillea millefolium 'Island Pink'], ... 519 more ...)
• PlantCom (type: esriFieldTypeString, alias: Common name of plant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wasps (type: esriFieldTypeInteger, alias: Number of wasps, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Image1BeeType11 (type: esriFieldTypeString, alias: Image 1 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Image2BeeType11 (type: esriFieldTypeString, alias: Image 2 Bee Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:

• test_Native_Bee_Watch_Survey_2022_Observations (1) -- Related To: test_Native_Bee_Watch_Survey_2022 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/13/2025 8:20:49 PM

Schema Last Edit Date: 5/13/2025 8:20:49 PM

Data Last Edit Date: 5/13/2025 7:38:40 PM

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