Definition: | Foreign key to the CAMP ProjectDescription table | Primary key that defines record in table. | Date and time of day associated with the trap visit. Definition varies based on visitType (For visitTypeID=1, 5, or 6 this is the date and the time of day of arrival at the trap. For visitTypeID=2, 3, or 4 this is the date and the time of day the trap was emptied.) | Name of the sampling site. Levels = c("Eye Riffle", "Live Oak", "Herringer Riffle", "Steep Riffle", "Sunset Pumps", "Shawn's Beach", "Gateway Riffle") | Position of trap within the site. Levels = c("Eye riffle_north", "Live Oak", "Herringer_west”,” Herringer_east”, "Eye riffle_Side Channel”, “#Steep Riffle_RST”, “Sunset West bank”, "Sunset East bank”,” Shawns_west", "Shawns_east”, “Gateway_main1”, “Herringer_Upper_west”, “Steep Riffle_10' ext”, “Gateway Main 400' Up River”, “Gateway_Rootball”, “Steep Side Channel", “Gateway_Rootball_River_Left") | Work that was done during visit to trap (luVisitType) | Describing if fish processed during trap visit. Levels = c("Not applicable", "Processed fish", "No fish were caught", "No catch data; fish released", "No catch data; fish left in live box") | Code for description of how well trap is functioning when visit to trap began. Levels = c("Trap not in service", "Not recorded", "Trap functioning normally", "Trap stopped functioning", "Trap functioning, but not normally") | Reading on the rotation counter at the end of the trap visit but before resetting | Number of revolutions per minute before cleaning the trap | Number of revolutions per minute before cleaning the trap | Code for whether this record is considered of high enough quality to include in analysis. Levels = c("Yes", "No") | Water temperature measured at trap | Turbidity measured at trap |
Measurement Values Domain: | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 2 | Definition | Feather River RST program | Source | |
|
|
| Definition | Primary key that defines record in table. |
| Format | YYYY-MM-DD hh:mm:ss | Precision | |
| Definition | Name of the sampling site. Levels = c("Eye Riffle", "Live Oak", "Herringer Riffle", "Steep Riffle", "Sunset Pumps", "Shawn's Beach", "Gateway Riffle") |
| Definition | Position of trap within the site. Levels = c("Eye riffle_north", "Live Oak", "Herringer_west”,” Herringer_east”, "Eye riffle_Side Channel”, “#Steep Riffle_RST”, “Sunset West bank”, "Sunset East bank”,” Shawns_west", "Shawns_east”, “Gateway_main1”, “Herringer_Upper_west”, “Steep Riffle_10' ext”, “Gateway Main 400' Up River”, “Gateway_Rootball”, “Steep Side Channel", “Gateway_Rootball_River_Left") |
| Definition | Work that was done during visit to trap (luVisitType) |
| Definition | Describing if fish processed during trap visit. Levels = c("Not applicable", "Processed fish", "No fish were caught", "No catch data; fish released", "No catch data; fish left in live box") |
| Definition | Code for description of how well trap is functioning when visit to trap began. Levels = c("Trap not in service", "Not recorded", "Trap functioning normally", "Trap stopped functioning", "Trap functioning, but not normally") |
| Unit | number of rotations | Type | real | Min | 0 | Max | 51775 |
| Unit | revolutions per minute | Type | real | Min | 0 | Max | 1777 |
| Unit | revolutions per minute | Type | real | Min | 0 | Max | 6317 |
| Definition | Code for whether this record is considered of high enough quality to include in analysis. Levels = c("Yes", "No") |
| Unit | celsius | Type | real | Min | 0 | Max | 24 |
| Unit | NTU | Type | real | Min | 0 | Max | 82.5 |
|