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:

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)
• 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: Interview Time, 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_port_of_gold_beach: Port of Gold Beach], [angling_location_lexs: Lex's Landing], [angling_location_island: Island], ... 12 more ...)
• angling_location_other (type: esriFieldTypeString, alias: Other angling location:, 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 bank 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_no: No], [steelhead_yes: Yes])
• license_type (type: esriFieldTypeString, alias: What license type do you have?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [annual: Annual], [one_day: One Day], [two_day: 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: Not a Resident of Oregon])
• els_paper (type: esriFieldTypeString, alias: Are you using paper tags or your phone when tagging fish?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [els_paper_paper: Paper Tags], [els_paper_els: ELS (phone app)])
• 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)
• new_steelhead_yes_no (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 license type were these steeelhead harvested with?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [annual: Annual], [one_day: One Day], [two_day: 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_resident: Resident of Oregon], [repeat_resident_non: Not a resident of Oregon])
• repeat_els_tagging (type: esriFieldTypeString, alias: Are you using paper tags or your phone when tagging fish?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [repeat_els_tagging_paper: Paper Tags], [repeat_els_tagging_els: ELS (phone app)])
• 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)
• repeat_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)
• 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)
• other_fish_yes (type: esriFieldTypeString, alias: Fish Comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• other_fish_no (type: esriFieldTypeString, alias: Fish Comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:

• _2023_2024_Rogue_StW_Creel_interview_questions (1) -- Related To: _2023_2024_Rogue_StW_Creel (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

Data Last Edit Date: 7/16/2025 10:55:10 PM

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