Name: _2023_24_OASIS_SGS_Form

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"2023-24 OASIS SGS Form","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• crew (type: esriFieldTypeString, alias: Crew, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Alsea: Alsea], [Astoria: Astoria], [ChumProject: ChumProject], ... 35 more ...)
• surveyor_ID (type: esriFieldTypeString, alias: Surveyor ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [2: 2 - Sounhein], [4: 4 - Brown], [5: 5 - Emig], ... 84 more ...)
• survey_IDNum (type: esriFieldTypeString, alias: Survey Select, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• deviceid (type: esriFieldTypeString, alias: deviceid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_title (type: esriFieldTypeString, alias: Survey Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_STW (type: esriFieldTypeString, alias: STW Survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_Ch (type: esriFieldTypeString, alias: Ch Survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_tagging (type: esriFieldTypeString, alias: Tagging Survey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tagging_title (type: esriFieldTypeString, alias: tagging_title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• label_STW (type: esriFieldTypeString, alias: STEELHEAD SURVEY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_desc (type: esriFieldTypeString, alias: Survey Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• survey_inst (type: esriFieldTypeString, alias: Specific Instructions, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• survey_directions (type: esriFieldTypeString, alias: Survey Directions, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• survey_length (type: esriFieldTypeString, alias: Survey Length, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• survey_date (type: esriFieldTypeDate, alias: Survey Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_convert (type: esriFieldTypeString, alias: date_convert, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [C: Clear], [F: Foggy], [O: Overcast], ... 3 more ...)
• flow (type: esriFieldTypeString, alias: Flows, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [L: Low or Dry], [M: Moderate], [H: High], ... 1 more ...)
• visibility (type: esriFieldTypeString, alias: Visibility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1 - Can see bottom of riffles and pools], [2: 2 - Can see bottom of riffles], [3: 3 - Cannot see bottom of riffles and pools])
• Redds (type: esriFieldTypeInteger, alias: Salmon Redds Tally, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LPRedds (type: esriFieldTypeInteger, alias: Pac. Lamp. Redds Tally, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BKLampRedds (type: esriFieldTypeInteger, alias: Brk. Lamp. Redds Tally, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CTRedds (type: esriFieldTypeInteger, alias: Cutthroat Redds Tally, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnMA (type: esriFieldTypeInteger, alias: Live Unmarked Coho, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MkA (type: esriFieldTypeInteger, alias: Live Adipose Clipped Coho, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnKA (type: esriFieldTypeInteger, alias: Live Clip Unknown Coho, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COLJ (type: esriFieldTypeInteger, alias: Live Jack Coho, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnMA2T (type: esriFieldTypeInteger, alias: Coho Unmarked - 2T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnMA1T (type: esriFieldTypeInteger, alias: Coho Unmarked - 1T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnMAUT (type: esriFieldTypeInteger, alias: Coho Unmarked - ?T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UnMATagUnk (type: esriFieldTypeInteger, alias: Coho Unmarked - Unknown Tag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Jack2T (type: esriFieldTypeInteger, alias: Jack Coho Unmarked - 2T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Jack1T (type: esriFieldTypeInteger, alias: Jack Coho Unmarked - 1T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JackUT (type: esriFieldTypeInteger, alias: Jack Coho Unmarked - ?T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JackTagUnk (type: esriFieldTypeInteger, alias: Jack Coho Unmarked - Unknown Tag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CODM (type: esriFieldTypeInteger, alias: Coho Male Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CODF (type: esriFieldTypeInteger, alias: Coho Female Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CODJ (type: esriFieldTypeInteger, alias: Coho Jack Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CODU (type: esriFieldTypeInteger, alias: Coho Sex Unknown Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHA (type: esriFieldTypeInteger, alias: Coho PHA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHJ (type: esriFieldTypeInteger, alias: Coho PHJ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• coho_activity (type: esriFieldTypeString, alias: Coho Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [16: Most fish actively spawning], [14: Most fish holding in pools (prior to spawning)], [15: Most fish migrating through survey area], ... 2 more ...)
• coho_activity_sum (type: esriFieldTypeString, alias: coho_activity_sum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• coho_activity_sum_tagged (type: esriFieldTypeString, alias: coho_activity_sum_tagged, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CHUnMA (type: esriFieldTypeInteger, alias: Live Unmarked Chinook, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHMkA (type: esriFieldTypeInteger, alias: Live Adipose Clipped Chinook, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHUnKA (type: esriFieldTypeInteger, alias: Live Clip Unknown Chinook, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHLJ (type: esriFieldTypeInteger, alias: Live Jack Chinook, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHDM (type: esriFieldTypeInteger, alias: Chinook Male Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHDF (type: esriFieldTypeInteger, alias: Chinook Female Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHDJ (type: esriFieldTypeInteger, alias: Chinook Jack Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHDU (type: esriFieldTypeInteger, alias: Chinook Sex Unknown Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHAChA (type: esriFieldTypeInteger, alias: Chinook PHA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHAChJ (type: esriFieldTypeInteger, alias: Chinook PHJ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• chinook_activity (type: esriFieldTypeString, alias: Chinook Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [16: Most fish actively spawning], [14: Most fish holding in pools (prior to spawning)], [15: Most fish migrating through survey area], ... 2 more ...)
• chinook_activity_sum (type: esriFieldTypeString, alias: chinook_activity_sum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CMLA (type: esriFieldTypeInteger, alias: Live Chum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CMLAtagged (type: esriFieldTypeInteger, alias: Live Tagged Chum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CMDM (type: esriFieldTypeInteger, alias: Chum Male Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CMDF (type: esriFieldTypeInteger, alias: Chum Female Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CMDU (type: esriFieldTypeInteger, alias: Chum Sex Unknown Carcass, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHACM (type: esriFieldTypeInteger, alias: Chum PHA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• chum_activity (type: esriFieldTypeString, alias: Chum Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [16: Most fish actively spawning], [14: Most fish holding in pools (prior to spawning)], [15: Most fish migrating through survey area], ... 2 more ...)
• chum_activity_sum (type: esriFieldTypeString, alias: chum_activity_sum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STUnMA (type: esriFieldTypeInteger, alias: Live Unmarked Steelhead, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STMkA (type: esriFieldTypeInteger, alias: Live Ad-Clipped Steelhead, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STUnKA (type: esriFieldTypeInteger, alias: Live Clip Unknown Steelhead, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STUnMA2T (type: esriFieldTypeInteger, alias: STW Unmarked - 2T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STUnMA1T (type: esriFieldTypeInteger, alias: STW Unmarked - 1T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STUnMAUT (type: esriFieldTypeInteger, alias: STW Unmarked - ?T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STUnMATagUnk (type: esriFieldTypeInteger, alias: STW Unmarked - Unknown Tag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• steelhead_activity (type: esriFieldTypeString, alias: Steelhead Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [16: Most fish actively spawning], [14: Most fish holding in pools (prior to spawning)], [15: Most fish migrating through survey area], ... 2 more ...)
• steelhead_activity_sum (type: esriFieldTypeString, alias: steelhead_activity_sum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LPLA (type: esriFieldTypeInteger, alias: Pacific Lamprey Live Adults, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BKLampLA (type: esriFieldTypeInteger, alias: Brook Lamprey Live Adults, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CTLA (type: esriFieldTypeInteger, alias: Cutthroat Live Adults, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sockeye (type: esriFieldTypeInteger, alias: Sockeye Salmon Live Adults, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pink (type: esriFieldTypeInteger, alias: Pink Salmon Live Adults, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lamprey_activity (type: esriFieldTypeString, alias: Lamprey Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [16: Most fish actively spawning], [14: Most fish holding in pools (prior to spawning)], [15: Most fish migrating through survey area], ... 2 more ...)
• lamprey_activity_sum (type: esriFieldTypeString, alias: lamprey_activity_sum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cutthroat_activiey (type: esriFieldTypeString, alias: Cutthroat Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [16: Most fish actively spawning], [14: Most fish holding in pools (prior to spawning)], [15: Most fish migrating through survey area], ... 2 more ...)
• GenC1 (type: esriFieldTypeString, alias: Comment Code 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 00-None], [01: 01-Includes tributary to index], [02: 02- Holes not surveyed], ... 26 more ...)
• GenC2 (type: esriFieldTypeString, alias: Comment Code 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 00-None], [01: 01-Includes tributary to index], [02: 02- Holes not surveyed], ... 26 more ...)
• GenC3 (type: esriFieldTypeString, alias: Comment Code 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 00-None], [01: 01-Includes tributary to index], [02: 02- Holes not surveyed], ... 26 more ...)
• DataEntryComments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, 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)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• _2023_24_OASIS_SGS_Form_GPS_record (1) -- Related To: GPS_record (1)
• _2023_24_OASIS_SGS_Form_BSF_carcass (2) -- Related To: BSF_carcass (3)
• _2023_24_OASIS_SGS_Form_redd_longevity (3) -- Related To: redd_longevity (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/15/2024 11:56:44 PM

Schema Last Edit Date: 11/15/2024 11:56:44 PM

Data Last Edit Date: 11/15/2024 11:56:44 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat