Name: Collection_Repeat

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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)
• coll_type (type: esriFieldTypeString, alias: Type of Collection:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Trap: Adult Trap], [Water: Water])
• date_set (type: esriFieldTypeDate, alias: Trap Set / Date of Larval and Pupal Collection:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_setright (type: esriFieldTypeString, alias: date_setright, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• time_set (type: esriFieldTypeString, alias: Trap set time of day:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Morning: Morning], [Afternoon: Afternoon], [Evening: Evening])
• trap_type (type: esriFieldTypeString, alias: Kind of Trap:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ABC_Trap: ABC Trap], [BGS_Trap: BGS Trap], [EVS_Trap: EVS Trap], ... 6 more ...)
• coll_method_other_adult (type: esriFieldTypeString, alias: Other Collection Method:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• attract_types (type: esriFieldTypeString, alias: Select Attractants Used:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CO2: CO2], [CO2_Octenol: CO2 and Octenol], [CO2_Lure: CO2 and Lure], ... 10 more ...)
• other_attract (type: esriFieldTypeString, alias: Other Attractants:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• success (type: esriFieldTypeString, alias: Was trap collection successful?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• fail_reason (type: esriFieldTypeString, alias: Reason for failure?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NoMosquitoesCaught: No Mosquitoes Caught], [Trap_Failed: Trap Failed], [Weather: Weather], ... 2 more ...)
• fail_reason_other (type: esriFieldTypeString, alias: Other reason:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_pickup (type: esriFieldTypeDate, alias: Trap pickup date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_pickupright (type: esriFieldTypeString, alias: date_pickupright, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• time_pickup (type: esriFieldTypeString, alias: Trap pickup time of day:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Morning: Morning], [Afternoon: Afternoon], [Evening: Evening])
• coll_method (type: esriFieldTypeString, alias: Collection Method:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Ovicup/Ovitrap: Ovicup/Ovitrap], [Larval/Pupal: Larval/Pupal Collection], [AGOTrap: Autocidal Gravid Ovitrap], ... 1 more ...)
• coll_method_other_water (type: esriFieldTypeString, alias: Other Collection Method:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Sample (type: esriFieldTypeString, alias: Type of Sample Device:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Mosquito_dipper: Mosquito dipper], [Turkey_baster: Turkey baster], [Ladle: Ladle], ... 1 more ...)
• other_sample (type: esriFieldTypeString, alias: Other:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SizeWater (type: esriFieldTypeString, alias: Size of water sample:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dips: dips (1 or more)], [Other: Other])
• other_size (type: esriFieldTypeString, alias: Other:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_larvae (type: esriFieldTypeString, alias: Number of larvae taken from sample (0 or more):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0], [>0: >0])
• water_source (type: esriFieldTypeString, alias: Water Source:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Tire: Tire], [Flowerpot_vase: Flower Pot/Vase], [Small_misc_container: Small misc. empty container], ... 8 more ...)
• other_watersource (type: esriFieldTypeString, alias: Other Water Source:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• text_hoursinplace (type: esriFieldTypeString, alias: Number of hours Trap was in Place:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• text_minsinplace (type: esriFieldTypeString, alias: Number of minutes Trap was in Place:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• text_technotes (type: esriFieldTypeString, alias: Technician's Notes:, 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)

Relationships:

• GeoSWAT_2019_Collection_Repeat (1) -- Related To: GeoSWAT_2019 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/16/2019 6:08:36 PM

Schema Last Edit Date: 4/16/2019 6:08:36 PM

Data Last Edit Date: 4/16/2019 6:08:36 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