| SampleDate | StudyRowID | MinutesPumping | SampleTimeLength | PrimaryDepth | PrimaryFlow | Catch.OrganismCode | Count | luOrganisms.OrganismCode | CommonName | BuildingCode | ForkLength | LengthFrequency | BayPump1 | BayPump2 | BayPump3 | BayPump4 | BayPump5 | Salvage |
---|
Column Name: | SampleDate
| StudyRowID
| MinutesPumping
| SampleTimeLength
| PrimaryDepth
| PrimaryFlow
| OrganismCode
| Count
| Scientific Name
| CommonName
| BuildingCode
| ForkLength
| LengthFrequency
| BayPump1
| BayPump2
| BayPump3
| BayPump4
| BayPump5
| Salvage
|
Definition: | Date of Sample | 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 | 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
| string
| float
| float
| float
| float
| string
| float
| string
| string
| string
| float
| float
| string
| string
| string
| string
| string
| float
|
Measurement Type: | dateTime | nominal | ratio | ratio | ratio | ratio | nominal | ratio | 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 | 8888 | Definition | Special study | Source | |
|
|
| | | | Unit | footCubedPerSecond | Type | real |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 1 | Definition | Organism Code | Source | |
| Code Definition | Code | 2 | Definition | Organism Code | Source | |
| Code Definition | Code | 3 | 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 | |
|
|
| 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 | Not available or blank. |
| | | | | | Code | NA | Expl | Not available or blank. |
|
Accuracy Report: | | | | | | | | | | | | | | | | | | | |
Accuracy Assessment: | | | | | | | | | | | | | | | | | | | |
Coverage: | | | | | | | | | | | | | | | | | | | |
Methods: | | | | | | | | | | | | | | | | | | | |