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