Name: efish_entry_repeat

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)
• SEQ_NUMB (type: esriFieldTypeInteger, alias: Sequence # (order in which channel units are sampled), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAB_UNIT (type: esriFieldTypeInteger, alias: Unit Number (if known), SQL Type: sqlTypeOther, nullable: true, editable: true)
• EFISH_HAB_TYPE (type: esriFieldTypeString, alias: Unit Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [FAST_WATER: Fast Water], [POOLS: Pools], [SPECIAL_CASE: Special Case Unit], ... 2 more ...)
• UNIT_WIDTH (type: esriFieldTypeDouble, alias: Unit Width (Average), SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNIT_DEPTH (type: esriFieldTypeString, alias: Depth (max in pools and modal in fastwater), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - Dry], [0.01: 0.01], [0.02: 0.02], ... 61 more ...)
• UNT_LENGTH (type: esriFieldTypeDouble, alias: Unit Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE1 (type: esriFieldTypeString, alias: 1) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_1 (type: esriFieldTypeString, alias: 1) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_1 (type: esriFieldTypeInteger, alias: 1) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE2 (type: esriFieldTypeString, alias: 2) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_2 (type: esriFieldTypeString, alias: 2) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_2 (type: esriFieldTypeInteger, alias: 2) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE3 (type: esriFieldTypeString, alias: 3) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_3 (type: esriFieldTypeString, alias: 3) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_3 (type: esriFieldTypeInteger, alias: 3) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE4 (type: esriFieldTypeString, alias: 4) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_4 (type: esriFieldTypeString, alias: 4) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_4 (type: esriFieldTypeInteger, alias: 4) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE5 (type: esriFieldTypeString, alias: 5) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_5 (type: esriFieldTypeString, alias: 5) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_5 (type: esriFieldTypeInteger, alias: 5) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE6 (type: esriFieldTypeString, alias: 6) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_6 (type: esriFieldTypeString, alias: 6) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_6 (type: esriFieldTypeInteger, alias: 6) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE7 (type: esriFieldTypeString, alias: 7) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_7 (type: esriFieldTypeString, alias: 7) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_7 (type: esriFieldTypeInteger, alias: 7) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE8 (type: esriFieldTypeString, alias: 8) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_8 (type: esriFieldTypeString, alias: 8) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_8 (type: esriFieldTypeInteger, alias: 8) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPP_CODE9 (type: esriFieldTypeString, alias: 9) Species Captured, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [X: No Fish Found], [TF: 0+ Trout], [US: Unknown Salmonid], ... 19 more ...)
• SIZE_9 (type: esriFieldTypeString, alias: 9) Species Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: 0 - No Fish], [3-5.9: 3-5.9 cm], [6-8.9: 6-8.9 cm], ... 12 more ...)
• NUMBER_9 (type: esriFieldTypeInteger, alias: 9) Species Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FISH_NOTE_Entry (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FISH_NOTE (type: esriFieldTypeString, alias: FISH_NOTE, 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_AQI_Survey_Entry_efish_entry_repeat (6) -- Related To: _2024_AQI_Survey_Entry (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/17/2024 3:28:42 PM

Schema Last Edit Date: 10/14/2024 6:34:45 PM

Data Last Edit Date: 10/17/2024 3:28:42 PM

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