Layer: interview_questions (ID:1)

Name: interview_questions

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: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

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)
interviewed_yes_no (type: esriFieldTypeString, alias: Have you been interviewed yet today about your angling efforts?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [interviewed_no: No], [interviewed_yes: Yes])
interview_time (type: esriFieldTypeString, alias: Time at Interview, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
angling_location (type: esriFieldTypeString, alias: Where is the angler fishing?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [angling_location_at_rivers_edge: At River's Edge RV Resort/Morrison Hole], [angling_location_tide_rock: Tide Rock], [angling_location_hwi: Harbor Water Intake], ... 14 more ...)
angling_location_other (type: esriFieldTypeString, alias: Other angling location not listed:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
interview_comment (type: esriFieldTypeString, alias: Description of angler:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
boat_bank (type: esriFieldTypeString, alias: Is the angler fishing from the shore or from a boat?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [boat_bank_bank: Bank Angler], [boat_bank_boat: Boat Angler])
steelhead_yes_no (type: esriFieldTypeString, alias: Have you caught any ADULT STEELHEAD today?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [steelhead_yes_no_yes: Yes, I caught an adult Steelhead.], [steelhead_yes_no_no: No, I have not yet caught an adult steelhead.])
license_type (type: esriFieldTypeString, alias: What type of license do you have?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [license_type_annual: Annual], [license_type_one: One-Day], [license_type_two: Two-Day], ... 6 more ...)
resident_non (type: esriFieldTypeString, alias: Are you a resident or non-resident of Oregon?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [resident_resident: Resident of Oregon], [resident_non: Non-Resident])
tag_type (type: esriFieldTypeString, alias: Do you have a paper tag or are you using electronic tagging on your phone?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [tag_type_paper: Paper Tagging], [tag_type_els: Electronic Tagging on Phone/ELS])
rsp_validation (type: esriFieldTypeString, alias: Do you have your Rogue South Coast Multispecies Conservation and Management Plan Steelhead validation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [rsp_validation_yes: Yes, I have the rsp validation], [rsp_validation_no: No, I don't have the rsp validation; Anglers need this Dec 1-April 30 to fish in RSP zone to fish for steelhead; Anglers need to stop fishing until they purchase this $2/$4 validation.])
wild_card (type: esriFieldTypeString, alias: Do you have a Rogue South Coast Multispecies Conservation and Management Plan wild Steelhead harvest card?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [wild_card_yes: Yes, I have the rsp harvest card; so I can harvest wild steelhead.], [wild_card_no: No, I don't have the rsp harvest card; I only catch and release wilds])
wild_harvest (type: esriFieldTypeInteger, alias: How many WILD adult Steelhead have you kept?, SQL Type: sqlTypeOther, nullable: true, editable: true)
wild_release (type: esriFieldTypeInteger, alias: How many WILD adult Steelhead have you released?, SQL Type: sqlTypeOther, nullable: true, editable: true)
hatchery_harvest (type: esriFieldTypeInteger, alias: How many HATCHERY adult Steelhead have you kept?, SQL Type: sqlTypeOther, nullable: true, editable: true)
hatchery_release (type: esriFieldTypeInteger, alias: How many HATCHERY adult Steelhead have you released?, SQL Type: sqlTypeOther, nullable: true, editable: true)
unk_release (type: esriFieldTypeInteger, alias: Did you release any unkown origin fish? How many?, SQL Type: sqlTypeOther, nullable: true, editable: true)
other_fish_yes (type: esriFieldTypeString, alias: Fish Comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
new_steelhead (type: esriFieldTypeString, alias: Have you caught any NEW adult steelhead since we last spoke?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new_steelhead_yes: Yes], [new_steelhead_no: No])
repeat_license_type (type: esriFieldTypeString, alias: What type of license do you have?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repeat_license_type_annual: Annual], [repeat_license_type_one: One-Day], [repeat_license_type_two: Two-Day], ... 6 more ...)
repeat_resident_non (type: esriFieldTypeString, alias: Are you a resident or non-resident of Oregon?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repeat_resident_non_resident: Resident of Oregon], [repeat_resident_non_non: Non-Resident])
repeat_tag_type (type: esriFieldTypeString, alias: Do you have a paper tag or are you using electronic tagging on your phone?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repeat_tag_type_paper: Paper Tagging], [repeat_tag_type_els: Electronic Tagging on Phone/ELS])
repeat_wild_harvest (type: esriFieldTypeInteger, alias: How many new adult WILD steelhead did you keep?, SQL Type: sqlTypeOther, nullable: true, editable: true)
repeat_wild_release (type: esriFieldTypeInteger, alias: How many new adult WILD steelhead did you release?, SQL Type: sqlTypeOther, nullable: true, editable: true)
repeat_hatchery_harvest (type: esriFieldTypeInteger, alias: How many new HATCHERY adult steelhead did you keep?, SQL Type: sqlTypeOther, nullable: true, editable: true)
repreat_hatchery_release (type: esriFieldTypeInteger, alias: How many new HATCHERY steelhead did you release?, SQL Type: sqlTypeOther, nullable: true, editable: true)
repeat_unk_release (type: esriFieldTypeInteger, alias: Did you release any unkown origin fish? How many?, SQL Type: sqlTypeOther, nullable: true, editable: true)
repeat_other_fish_no (type: esriFieldTypeString, alias: Fish Comments:, 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:

_2024_2025_Chetco_Winter_Steelhead_Creel_interview_questions (1) -- Related To: _2024_2025_Chetco_Winter_Steelhead_Creel (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/16/2025 10:56:30 PM

Schema Last Edit Date: 7/16/2025 10:56:30 PM

Data Last Edit Date: 7/16/2025 10:56:23 PM

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