| 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 | DEVICE_NAME | COMMENTS | TRIGGERED | PERIOD | QC_COMMENTS |
---|
Column Name: | 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
| DEVICE_NAME
| COMMENTS
| TRIGGERED
| PERIOD
| QC_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. | Concatenation of "PER" and DEVICE_NUM separated by a space. | Comments recorded during field sampling. | Boolean code to indicate if timer was triggered and fish was gone. 0 = no; 1 = yes. | Time period relative to construction: Pre construction, Construction, Post Construction | Comments made during checking of data. |
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
| string
| string
| 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 | nominal | nominal | nominal | nominal |
Measurement Values Domain: | Definition | Unique identifier for sample. Concatenation of SAMPLE_DATE, RELEASE_SEQ, and DEVICE_NUM separated by periods. |
| Format | YYYY-MM-DD | Precision | |
| Unit | dimensionless | Type | real |
| Unit | dimensionless | Type | integer |
| Format | YYYY-MM-DDThh:mm:ss | Precision | |
| Definition | Name of boat/vessel deploying a set of devices. |
| | | Format | YYYY-MM-DDThh:mm:ss | Precision | |
| | | Format | YYYY-MM-DDThh:mm:ss | Precision | |
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | nan | Definition | Device was lost | Source | |
| 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-DDThh:mm:ss | 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 |
| | Definition | Concatenation of "PER" and DEVICE_NUM separated by a space. |
| Definition | Comments recorded during field sampling. |
| 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 | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | Construction | Definition | During construction | Source | |
| Code Definition | Code | Post construction | Definition | After construction was complete | Source | |
| Code Definition | Code | Pre construction | Definition | Before construction started | Source | |
|
|
| Definition | Comments made during checking of data. |
|
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 | 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 collected |
| | | | | |
Accuracy Report: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Accuracy Assessment: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Coverage: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Methods: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |