Name: MeasurementRepeat

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)
• sppSizeNote (type: esriFieldTypeString, alias: -, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TrapSite (type: esriFieldTypeString, alias: TrapSite, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cascade: Cascade Creek], [EF Lobster: E.F. Lobster Creek], [SiletzMill: Siletz - Mill Creek], ... 5 more ...)
• siteCode (type: esriFieldTypeString, alias: siteCode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [smoltTrap: Smolt Trap], [adultTrap: Adult Trap], [1-2015: 1-2015], ... 25 more ...)
• CaptureLocation (type: esriFieldTypeString, alias: CaptureLocation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CaptureDate (type: esriFieldTypeDate, alias: CaptureDate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Species (type: esriFieldTypeString, alias: SpeciesOut, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Brook Lamprey: Brook Lamprey], [Chinook: Chinook], [Chum: Chum], ... 12 more ...)
• SizeClass (type: esriFieldTypeString, alias: SizeClass, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Smolt: Smolt], [Fry: Fry], [Juvenile: Juvenile], ... 8 more ...)
• ForkLength (type: esriFieldTypeInteger, alias: Fork Length (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Weight (type: esriFieldTypeDouble, alias: Weight (g), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LengthFreq (type: esriFieldTypeString, alias: Length Frequency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Silvered (type: esriFieldTypeString, alias: Silver appearance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [S: Yes], [N: No], [P: Partial])
• Sex (type: esriFieldTypeString, alias: Sex, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [M: Male], [F: Female], [UNKNOWN: Unknown])
• Mark (type: esriFieldTypeString, alias: Mark, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [N: None], [UC: UC], [TERE: Trap Efficiency RE], ... 7 more ...)
• PITtagNum (type: esriFieldTypeString, alias: PIT tag code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vie (type: esriFieldTypeString, alias: VIE color, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Orange: Orange], [Red: Red], [Green: Green], ... 6 more ...)
• ScaleID (type: esriFieldTypeInteger, alias: Scale card number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TissueID (type: esriFieldTypeString, alias: Genetic Sample, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FloyTagColor (type: esriFieldTypeString, alias: FLOY tag color, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Orange: Orange], [Red: Red], [Green: Green], ... 6 more ...)
• FloyTagNum1 (type: esriFieldTypeInteger, alias: FLOY tag number (1), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FloyTagNum2 (type: esriFieldTypeInteger, alias: FLOY tag number (2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECFloyTagColor (type: esriFieldTypeString, alias: Recoverd FLOY color, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Orange: Orange], [Red: Red], [Green: Green], ... 6 more ...)
• RECTag1 (type: esriFieldTypeInteger, alias: Recovered FLOY number (1), SQL Type: sqlTypeOther, nullable: true, editable: true)
• RECTag2 (type: esriFieldTypeInteger, alias: Recoverd FLOY number (2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status of captured fish, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Passed: Passed], [Mortality unintentional: Mortality unintentional], [Removed: Removed], ... 6 more ...)
• Code1 (type: esriFieldTypeString, alias: Comment code 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BS: Broodstock], [CE: Carcass Enrichment], [CR: CCRMP Recovery], ... 20 more ...)
• Code2 (type: esriFieldTypeString, alias: Comment code 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BS: Broodstock], [CE: Carcass Enrichment], [CR: CCRMP Recovery], ... 20 more ...)
• Code3 (type: esriFieldTypeString, alias: Comment code 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BS: Broodstock], [CE: Carcass Enrichment], [CR: CCRMP Recovery], ... 20 more ...)
• Mort (type: esriFieldTypeString, alias: Unintentional Mortality, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Comments (type: esriFieldTypeString, alias: Additional comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UnitNumber (type: esriFieldTypeInteger, alias: Unit number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TagEvent (type: esriFieldTypeString, alias: TagOut, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Tagger (type: esriFieldTypeString, alias: TaggerOut, 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:

• LCM_Fish_Handling_Data_2_2_MeasurementRepeat (2) -- Related To: LCM_Fish_Handling_Data_2_2 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/2/2022 12:55:55 AM

Schema Last Edit Date: 5/2/2022 12:55:55 AM

Data Last Edit Date: 5/2/2022 12:55:55 AM

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