| SAMPLE_ID | SAMPLE_DATE | RELEASE_SEQ | DEVICE_NUM | DEPLOY_DATETIME | VESSEL | DEPLOY_LAT | DEPLOY_LONG | RECOVER_DATETIME | RECOVER_LAT | RECOVER_LONG | TRIGGER_DATETIME | FISH_STATUS | TRIGGER_LAT | TRIGGER_LONG | TRIGGER_GPS_DATETIME | TRIGGER_DIFF | TIMER | BITE_MARKS | WEEDS | ROCKS | EDDY | TANGLED | TEMPERATURE | DISSOLVED_OXYGEN | SPC | SALINITY | PH | TURBIDITY | SECCHI_DEPTH | TRIGGERED | velocity_fal | sac_fpt | sjr_vns | klx | sunset | moon_fraction | moon_position | outflow | DEVICE_NAME | COMMENTS |
---|
Column Name: | ID
| sample_date
| release_sequence
| edb_number
| time_dep
| vessel
| latitude_dep
| longitude_dep
| time_rec
| latitude_rec
| longitude_rec
| trigger_time
| fish_status
| latitude_trig
| longitude_trig
| trigger_time_gps
| trig_diff
| timer
| bite_marks
| weeds
| rocks
| eddy
| tangled
| temperature
| dissolved_oxygen
| spc
| salinity
| ph
| turbidity
| secchi_depth
| triggered
| velocity_fal
| sac_fpt
| sjr_vns
| klx
| sunset
| moon_fraction
| moon_position
| outflow
| device_name
| comments
|
Definition: | Unique identifier for sample. Concatenation of SAMPLE_DATE, RELEASE_SEQ, and DEVICE_NUM separated by periods. | Date of sample collection | Order of release for groups deployed throughout a sampling period. Decimal numbers are used to indicate redeployment within a given release. | ID number for PER device. | Date and time that device was deployed. | Name of boat/vessel deploying a set of devices. | Latitude of deployment location (as recorded by tablet). | Longitude of deployment location (as recorded by tablet). | Date and time that device was recovered. | Latitude of recovery location (as recorded by tablet). | Longitude of recovery location | Date and time that timer was triggered. | Fish status at time of recovery: alive, dead, gone. | Approximate latitude where timer was triggered. | Approximate longitude where timer was triggered. | Date and time of GPS location used for TRIGGER_LAT and TRIGGER_LONG. Selected GPS location has shortest time from TRIGGER_DATETIME. | Absolute difference between TRIGGER_DATETIME and TRIGGER_GPS_DATETIME, in seconds. | Time since timer was triggered, in seconds. Value of 0 indicates that timer was not triggered. | Boolean code to indicate if bait fish had bite marks at time of recovery. 0 = no; 1 = yes. | Boolean code to indicate if device was recovered in weeds or covered in weeds. 0 = no; 1 = yes. | Boolean code to indicate if device was recovered against rocky boundary (e.g., levee wall). 0 = no; 1 = yes. | Boolean code to indicate if device was recovered in an eddy. 0 = no; 1 = yes. | Boolean code to indicate if leader and/or magnet lines were tangled. 0 = no; 1 = yes. | Water temperature at the time of deployment, in Celsius. | Dissolved oxygen at the time of deployment, in mgL. | Specific conductivity at the time of deployment | Salinity, as calculated from specific conductance | pH of water at the time of deployment. | Turbidity of the water at the time of deployment, in NTU. | Depth at which Secchi disk is no longer visible at the time of deployment, in cm. | Boolean code to indicate if timer was triggered and fish was gone. 0 = no; 1 = yes. | water velocity in False River | Sacramento River flow at Freeport | San Joaquin River flow at Vernalis | kiloLux, a measurement of ambient light at the point of predation | Time the sun set | Fraction of the moon visible. | Angle of the moon from the hoizon | Net Delta outflow in cubic feet per second (cfs) at Chipps Island. Data from WY 1975-2021 is from Dayflow. The values for October through November 2021 are estimated by data from the USBR Delta Outflow Computation reports. | Concatenation of "PER" and DEVICE_NUM separated by a space. | Comments recorded during field sampling. |
Storage Type: | string
| dateTime
| float
| float
| dateTime
| string
| float
| float
| dateTime
| float
| float
| dateTime
| string
| float
| float
| dateTime
| float
| float
| string
| string
| string
| string
| string
| float
| float
| float
| float
| float
| float
| float
| string
| float
| float
| float
| float
| dateTime
| float
| float
| float
| string
| string
|
Measurement Type: | nominal | dateTime | ratio | ratio | dateTime | nominal | ratio | ratio | dateTime | ratio | ratio | dateTime | nominal | ratio | ratio | dateTime | ratio | ratio | nominal | nominal | nominal | nominal | nominal | ratio | ratio | ratio | ratio | ratio | ratio | ratio | nominal | ratio | ratio | ratio | ratio | dateTime | ratio | ratio | ratio | nominal | nominal |
Measurement Values Domain: | | Format | YYYY-MM-DD | Precision | |
| Unit | dimensionless | Type | real |
| Unit | dimensionless | Type | integer |
| Format | YYYY-MM-DD hh:mm | Precision | |
| | | | Format | YYYY-MM-DD hh:mm | Precision | |
| | | Format | YYYY-MM-DD hh:mm | Precision | |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | alive | Definition | Fish was recovered alive | Source | |
| Code Definition | Code | dead | Definition | Fish was recovered dead | Source | |
| Code Definition | Code | gone | Definition | Fish was missing | Source | |
|
|
| | | Format | YYYY-MM-DD hh:mm | Precision | |
| | | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | No bite marks | Source | |
| Code Definition | Code | 1 | Definition | Fish had bite marks on recovery | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | No weeds | Source | |
| Code Definition | Code | 1 | Definition | Device was recovered in weeds or covered in weeds | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | No rocks | Source | |
| Code Definition | Code | 1 | Definition | Device recovered against rocks | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | No eddy | Source | |
| Code Definition | Code | 1 | Definition | device recovered in an eddy | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | No tangles | Source | |
| Code Definition | Code | 1 | Definition | Lines were tangled | Source | |
|
|
| | Unit | milligramPerLiter | Type | real |
| Unit | microSiemensperCentimeter | Type | real |
| | Unit | dimensionless | Type | real |
| Unit | NephelometricTurbidityUnits | Type | real |
| | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 0 | Definition | Not triggered | Source | |
| Code Definition | Code | 1 | Definition | Timer was triggered and fish was gone. | Source | |
|
|
| Unit | meterPerSecond | Type | real |
| Unit | footCubedPerSecond | Type | real |
| Unit | footCubedPerSecond | Type | real |
| | Format | YYYY-MM-DD hh:mm | Precision | |
| Unit | dimensionless | Type | real |
| | Unit | footCubedPerSecond | Type | real |
| | |
Missing Value Code: | | Code | NA | Expl | device was lost |
| | | Code | NA | Expl | device was lost |
| | | | Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | Device was lost |
| Code | NA | Expl | data not collected |
| Code | NA | Expl | data not collected |
| Code | NA | Expl | data not available |
| Code | NA | Expl | data not collected |
| Code | NA | Expl | data not collected |
| Code | NA | Expl | data not collected |
| | Code | NA | Expl | data not collected |
| Code | NA | Expl | data not available |
| Code | NA | Expl | data not available |
| Code | NA | Expl | data not collected |
| | | | | | |
Accuracy Report: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Accuracy Assessment: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Coverage: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Methods: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |