| SampleDate | SampleTime | StudyRowID | MinutesPumping | SampleTimeLength | PrimaryDepth | PrimaryFlow | Catch.OrganismCode | Count | luOrganisms.OrganismCode | CommonName | BuildingCode | AdiposeClip | Sex | AccidentallyEuthanized | ForkLength | LengthFrequency | BayPump1 | BayPump2 | BayPump3 | BayPump4 | BayPump5 | Salvage |
---|
Column Name: | SampleDate
| SampleTime
| StudyRowID
| MinutesPumping
| SampleTimeLength
| PrimaryDepth
| PrimaryFlow
| OrganismCode
| Count
| Scientific Name
| CommonName
| BuildingCode
| AdiposeClip
| Sex
| AccidentallyEuthanized
| ForkLength
| LengthFrequency
| BayPump1
| BayPump2
| BayPump3
| BayPump4
| BayPump5
| Salvage
|
Definition: | Date of Sample | Time when fish were counted. | Code to identify salvage, predator removal or special study. | Minutes the pumping plant exported water | Minutes of count | Primary Channel depth (feet) | Primary Channel flow (cfs) | Unique codes that correspond to individual species. | Number of fish per count from catch table in Access database | Organism scientific Name | Common name of fish from catch table in Access database | NS for new building and OS is for old building at Skinner Fish Facility; F is federal building referring to Tracy Fish Facility | Presence or absence of an adipose fin clip. | Sex | Indicates if fish were accidentally euthanized. | Lengths for each species at each count time | Length frequency for each length at each count time | 21 feet for both *SWP and *CVP | 21 feet for both *SWP and *CVP | 43 feet for both *SWP and *CVP | 43 feet for both *SWP and *CVP | 21 feet for both SWP only (CVP only has 4 bays) | Calculated number of fish captured by the fish facility at a particular time (expanded by pumping minutes and length count). |
Storage Type: | dateTime
| dateTime
| string
| float
| float
| float
| float
| string
| float
| string
| string
| string
| string
| string
| string
| float
| float
| string
| string
| string
| string
| string
| float
|
Measurement Type: | dateTime | dateTime | nominal | ratio | ratio | ratio | ratio | nominal | ratio | nominal | nominal | nominal | nominal | nominal | nominal | ratio | ratio | nominal | nominal | nominal | nominal | nominal | ratio |
Measurement Values Domain: | Format | YYYY-MM-DD | Precision | |
| | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | Regular Salvage | Source | |
| Code Definition | Code | 9999 | Definition | Predator removal | Source | |
| Code Definition | Code | 7777 | Definition | Crab screen data | Source | |
| Code Definition | Code | 8888 | Definition | Special study | Source | |
|
|
| | | | Unit | Cubic feet per second | Type | real |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 1 | Definition | Organism Code | Source | |
| Code Definition | Code | 10 | Definition | Organism Code | Source | |
| Code Definition | Code | 11 | Definition | Organism Code | Source | |
| Code Definition | Code | 117 | Definition | Organism Code | Source | |
| Code Definition | Code | 12 | Definition | Organism Code | Source | |
| Code Definition | Code | 13 | Definition | Organism Code | Source | |
| Code Definition | Code | 14 | Definition | Organism Code | Source | |
| Code Definition | Code | 15 | Definition | Organism Code | Source | |
| Code Definition | Code | 158 | Definition | Organism Code | Source | |
| Code Definition | Code | 17 | Definition | Organism Code | Source | |
| Code Definition | Code | 18 | Definition | Organism Code | Source | |
| Code Definition | Code | 19 | Definition | Organism Code | Source | |
| Code Definition | Code | 2 | Definition | Organism Code | Source | |
| Code Definition | Code | 20 | Definition | Organism Code | Source | |
| Code Definition | Code | 208 | Definition | Organism Code | Source | |
| Code Definition | Code | 21 | Definition | Organism Code | Source | |
| Code Definition | Code | 22 | Definition | Organism Code | Source | |
| Code Definition | Code | 23 | Definition | Organism Code | Source | |
| Code Definition | Code | 24 | Definition | Organism Code | Source | |
| Code Definition | Code | 25 | Definition | Organism Code | Source | |
| Code Definition | Code | 26 | Definition | Organism Code | Source | |
| Code Definition | Code | 27 | Definition | Organism Code | Source | |
| Code Definition | Code | 29 | Definition | Organism Code | Source | |
| Code Definition | Code | 3 | Definition | Organism Code | Source | |
| Code Definition | Code | 30 | Definition | Organism Code | Source | |
| Code Definition | Code | 31 | Definition | Organism Code | Source | |
| Code Definition | Code | 32 | Definition | Organism Code | Source | |
| Code Definition | Code | 33 | Definition | Organism Code | Source | |
| Code Definition | Code | 34 | Definition | Organism Code | Source | |
| Code Definition | Code | 4 | Definition | Organism Code | Source | |
| Code Definition | Code | 41 | Definition | Organism Code | Source | |
| Code Definition | Code | 44 | Definition | Organism Code | Source | |
| Code Definition | Code | 49 | Definition | Organism Code | Source | |
| Code Definition | Code | 5 | Definition | Organism Code | Source | |
| Code Definition | Code | 50 | Definition | Organism Code | Source | |
| Code Definition | Code | 51 | Definition | Organism Code | Source | |
| Code Definition | Code | 54 | Definition | Organism Code | Source | |
| Code Definition | Code | 55 | Definition | Organism Code | Source | |
| Code Definition | Code | 6 | Definition | Organism Code | Source | |
| Code Definition | Code | 64 | Definition | Organism Code | Source | |
| Code Definition | Code | 65 | Definition | Organism Code | Source | |
| Code Definition | Code | 66 | Definition | Organism Code | Source | |
| Code Definition | Code | 67 | Definition | Organism Code | Source | |
| Code Definition | Code | 69 | Definition | Organism Code | Source | |
| Code Definition | Code | 7 | Definition | Organism Code | Source | |
| Code Definition | Code | 8 | Definition | Organism Code | Source | |
| Code Definition | Code | 9 | Definition | Organism Code | Source | |
| Code Definition | Code | 98 | Definition | Organism Code | Source | |
|
|
| Unit | Number of fish | Type | real |
| | | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | F | Definition | F is federal building referring to Tracy Fish Facility | Source | |
| Code Definition | Code | NS | Definition | NS for new building at Skinner Fish Facility | Source | |
| Code Definition | Code | OS | Definition | OS is for old building at Skinner Fish Facility | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | Not clipped. | Source | |
| Code Definition | Code | 1 | Definition | Clipped. | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | m | Definition | Male | Source | |
| Code Definition | Code | f | Definition | Female | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | Not accidentally euthanized. | Source | |
| Code Definition | Code | 1 | Definition | Accidentally euthanized. | Source | |
|
|
| Unit | millimeter | Type | integer |
| | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | False | Definition | Closed | Source | |
| Code Definition | Code | True | Definition | Open | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | False | Definition | Closed | Source | |
| Code Definition | Code | True | Definition | open | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | False | Definition | Closed | Source | |
| Code Definition | Code | True | Definition | open | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | False | Definition | Closed | Source | |
| Code Definition | Code | True | Definition | Open | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | False | Definition | Closed | Source | |
| Code Definition | Code | True | Definition | Open | Source | |
|
|
| |
Missing Value Code: | | | | | | | | Code | NA | Expl | Not available or blank. |
| Code | NA | Expl | Not available or blank. |
| Code | NA | Expl | Not available or blank. |
| Code | NA | Expl | Not available or blank. |
| | Code | NA | Expl | No data available |
| Code | NA | Expl | No data available |
| Code | NA | Expl | No data available. |
| | Code | NA | Expl | Not available or blank. |
| | | | | | Code | NA | Expl | Not available or blank. |
|
Accuracy Report: | | | | | | | | | | | | | | | | | | | | | | | |
Accuracy Assessment: | | | | | | | | | | | | | | | | | | | | | | | |
Coverage: | | | | | | | | | | | | | | | | | | | | | | | |
Methods: | | | | | | | | | | | | | | | | | | | | | | | |