Data Table | Table Structure |
---|
Object Name: | feather_catch_current_year.csv | Size: | 3214275 bytes | Authentication: | 585ceb169a644ecbfc277851d83f6dff
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \n |
Orientation: | column |
Simple Delimited: | |
|
|
|
Table Column Descriptions |
---|
| | | catch | catch | catch | catch | catch | catch | catch | catch | catch | catch | catch | catch | catch | catch | catch | catch |
---|
Column Name: | ProjectDescriptionID
| trapVisitID
| visitTime
| siteName
| subSiteName
| visitType
| catchRawID
| commonName
| run
| fishOrigin
| lifeStage
| forkLength
| totalLength
| n
| actualCount
| releaseID
| Definition: | Foreign key to the CAMP ProjectDescription table. All data associated with this package will have a ProjectDescriptionID = 2 | Foreign key to the CAMP TrapVisit table | Date and time of day associated with the trap visit. | Name of the sampling site. Levels = c("Eye Riffle", "Live Oak", "Herringer Riffle") | Name of the trap or trap location. Levels = c("Eye riffle_north", "Live Oak", "Herringer_west", "Herringer_east", "Eye riffle_Side Channel") | Work that was done during visit to trap. Levels = c("Continue trapping", "Start trap & begin trapping", "End trapping", "Unplanned restart") | Primary key in the CAMP CatchRaw table | Common name of species. Levels = c("Chinook salmon", "Prickly sculpin", "Steelhead / rainbow trout", "Bluegill", "Golden shiner", "Wakasagi / Japanese smelt", "Pacific lamprey", "White crappie", "Unknown lamprey (Entosphenus or Lampetra)", "Tule perch", "Redear sunfish", "Largemouth bass", "Warmouth", "Sacramento pikeminnow", "Unknown bony fish", "Green sunfish" ,"Western mosquitofish", "Black crappie", "Threadfin shad", "Unknown sculpin (Cottus)", "Riffle sculpin" ,"Bigscale logperch" ,"Sacramento sucker", "River lamprey", "Common carp", "Smallmouth bass", "Splittail", "Redeye bass", "Hitch", "Unknown bass (Micropterus)", "Brown bullhead", "Hardhead", "Spotted bass", "Speckled dace", "Unknown sunfish (Lepomis)", "Unknown minnow", "Brook trout", "American shad", "Unknown catfish or bullhead", "Mosquitofish", "Pumpkinseed", "Black bullhead", "Channel catfish") | Run designation as determined in the field or as assigned at a later date. Levels = c("Not recorded", "Spring", "Fall", "Late fall", "Winter") | Origin/production type of the fish. Levels = c("Hatchery", "Natural", "Unknown") | Life stage of the fish. Levels = c("Not recorded", "Smolt", "Parr", "Fry", "Button-up fry", "Silvery parr", "Adult", "Juvenile", "Ammocoete", "Yearling", "Yolk sac fry (alevin)") | Fork length of the fish measured in millimeters | Total length of the fish measured in millimeters | Number of fish actually handled/counted | Whether the count (n) is an actual count or estimate. Levels = c("Yes", "No") | Foreign Key to the CAMP Release table | Storage Type: | | | | | | | | | | | | | | | | | Measurement Type: | ordinal | ordinal | dateTime | nominal | nominal | nominal | ordinal | nominal | nominal | nominal | nominal | ratio | ratio | ratio | nominal | ordinal | Measurement Values Domain: | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 2 | Definition | Feather River RST program | Source | |
|
|
| Definition | Foreign key to the CAMP TrapVisit table |
| Format | YYYY-MM-DD hh:mm:ss | Precision | |
| Definition | Name of the sampling site. Levels = c("Eye Riffle", "Live Oak", "Herringer Riffle") |
| Definition | Name of the trap or trap location. Levels = c("Eye riffle_north", "Live Oak", "Herringer_west", "Herringer_east", "Eye riffle_Side Channel") |
| Definition | Work that was done during visit to trap. Levels = c("Continue trapping", "Start trap & begin trapping", "End trapping", "Unplanned restart") |
| Definition | Primary key in the CAMP CatchRaw table |
| Definition | Common name of species. Levels = c("Chinook salmon", "Prickly sculpin", "Steelhead / rainbow trout", "Bluegill", "Golden shiner", "Wakasagi / Japanese smelt", "Pacific lamprey", "White crappie", "Unknown lamprey (Entosphenus or Lampetra)", "Tule perch", "Redear sunfish", "Largemouth bass", "Warmouth", "Sacramento pikeminnow", "Unknown bony fish", "Green sunfish" ,"Western mosquitofish", "Black crappie", "Threadfin shad", "Unknown sculpin (Cottus)", "Riffle sculpin" ,"Bigscale logperch" ,"Sacramento sucker", "River lamprey", "Common carp", "Smallmouth bass", "Splittail", "Redeye bass", "Hitch", "Unknown bass (Micropterus)", "Brown bullhead", "Hardhead", "Spotted bass", "Speckled dace", "Unknown sunfish (Lepomis)", "Unknown minnow", "Brook trout", "American shad", "Unknown catfish or bullhead", "Mosquitofish", "Pumpkinseed", "Black bullhead", "Channel catfish") |
| Definition | Run designation as determined in the field or as assigned at a later date. Levels = c("Not recorded", "Spring", "Fall", "Late fall", "Winter") |
| Definition | Origin/production type of the fish. Levels = c("Hatchery", "Natural", "Unknown") |
| Definition | Life stage of the fish. Levels = c("Not recorded", "Smolt", "Parr", "Fry", "Button-up fry", "Silvery parr", "Adult", "Juvenile", "Ammocoete", "Yearling", "Yolk sac fry (alevin)") |
| Unit | millimeter | Type | real | Min | 0 | Max | 3835 |
| Unit | millimeter | Type | whole | Min | 0 | Max | 750 |
| Unit | number of fish | Type | real | Min | 0 | Max | 123556 |
| Definition | Whether the count (n) is an actual count or estimate. Levels = c("Yes", "No") |
| Definition | Foreign Key to the CAMP Release table |
| Missing Value Code: | | | | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | | | | |
|
Data Table | Table Structure |
---|
Object Name: | feather_recapture_current_year.csv | Size: | 394684 bytes | Authentication: | 3428e6c1223a3a60523e5fb82ba315c6
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \n |
Orientation: | column |
Simple Delimited: | |
|
|
|
Table Column Descriptions |
---|
| | | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture | recapture |
---|
Column Name: | ProjectDescriptionID
| catchRawID
| trapVisitID
| commonName
| releaseID
| run
| fishOrigin
| lifeStage
| forkLength
| n
| visitTime
| visitType
| siteName
| subSiteName
| markType
| markColor
| markPosition
| markCode
| Definition: | Foreign key to the CAMP ProjectDescription table. All data associated with this package will have a ProjectDescriptionID = 2 | Primary key in the CAMP CatchRaw table | Foreign key to the CAMP TrapVisit table | Common name of species. Levels = "Chinook salmon" | Foreign Key to the CAMP Release table | Run as assigned at the time of the capture. Levels = c("Not recorded", "Fall", "Spring") | Origin/production type of the fish. Levels = c("Hatchery", "Natural", "Unknown") | Life stage of the fish. Levels = c("Not recorded", "Smolt", "Parr", "Fry", "Button-up fry", "Silvery parr", "Adult", "Juvenile", "Ammocoete", "Yearling", "Yolk sac fry (alevin)") | Fork length of the fish measured in millimeters | Number of fish actually handled/counted | Date and time of day associated with the trap visit. | Work that was done during visit to trap. Levels = c("Continue trapping", "Start trap & begin trapping", "End trapping", "Unplanned restart", "Not applicable (n/a)", "Service/adjust/clean trap") | Name of the sampling site. Levels = c("Eye Riffle", "Herringer Riffle", "Steep Riffle", "Sunset Pumps", "Gateway Riffle", "Live Oak") | Name of the trap or trap location. Levels = c("Eye riffle_north", "Herringer_west", "Herringer_east", "#Steep Riffle_RST", "Sunset West bank", "Sunset East bank", "Gateway_main1", "Live Oak", "Eye riffle_Side Channel", "Herringer_Upper_west", "Steep Riffle_10' ext", "Gateway Main 400' Up River", "Gateway_Rootball") | type of mark on fish. Levels = c("Elastomer", "Pigment / dye", "Fin clip") | color of mark on fish. Levels = c("White", "Brown", "Orange", "Green", "Red", "Blue", "yellow", "Purple / Violet", "Pink", "Not applicable (n/a)", "Fluorescent red", "Fluorescent blue") | position of mark on body of fish. Levels = c("Nose", "Wholte body", "Adipose fin", "Not recorded") | Code associated with tag | Storage Type: | | | | | | | | | | | | | | | | | | | Measurement Type: | ordinal | ordinal | ordinal | nominal | ordinal | nominal | nominal | nominal | ratio | ratio | dateTime | nominal | nominal | nominal | nominal | nominal | nominal | nominal | Measurement Values Domain: | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 2 | Definition | Feather River RST program | Source | |
|
|
| Definition | Primary key in the CAMP CatchRaw table |
| Definition | Foreign key to the CAMP TrapVisit table |
| Definition | Common name of species. Levels = "Chinook salmon" |
| Definition | Foreign Key to the CAMP Release table |
| Definition | Run as assigned at the time of the capture. Levels = c("Not recorded", "Fall", "Spring") |
| Definition | Origin/production type of the fish. Levels = c("Hatchery", "Natural", "Unknown") |
| Definition | Life stage of the fish. Levels = c("Not recorded", "Smolt", "Parr", "Fry", "Button-up fry", "Silvery parr", "Adult", "Juvenile", "Ammocoete", "Yearling", "Yolk sac fry (alevin)") |
| Unit | millimeter | Type | real | Min | 1 | Max | 1 |
| Unit | number of fish | Type | whole | Min | 0 | Max | 349 |
| Format | YYYY-MM-DD hh:mm:ss | Precision | |
| Definition | Work that was done during visit to trap. Levels = c("Continue trapping", "Start trap & begin trapping", "End trapping", "Unplanned restart", "Not applicable (n/a)", "Service/adjust/clean trap") |
| Definition | Name of the sampling site. Levels = c("Eye Riffle", "Herringer Riffle", "Steep Riffle", "Sunset Pumps", "Gateway Riffle", "Live Oak") |
| Definition | Name of the trap or trap location. Levels = c("Eye riffle_north", "Herringer_west", "Herringer_east", "#Steep Riffle_RST", "Sunset West bank", "Sunset East bank", "Gateway_main1", "Live Oak", "Eye riffle_Side Channel", "Herringer_Upper_west", "Steep Riffle_10' ext", "Gateway Main 400' Up River", "Gateway_Rootball") |
| Definition | type of mark on fish. Levels = c("Elastomer", "Pigment / dye", "Fin clip") |
| Definition | color of mark on fish. Levels = c("White", "Brown", "Orange", "Green", "Red", "Blue", "yellow", "Purple / Violet", "Pink", "Not applicable (n/a)", "Fluorescent red", "Fluorescent blue") |
| Definition | position of mark on body of fish. Levels = c("Nose", "Wholte body", "Adipose fin", "Not recorded") |
| Definition | Code associated with tag |
| Missing Value Code: | | | | | | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | | | | | | |
|
Data Table | Table Structure |
---|
Object Name: | feather_release_current_year.csv | Size: | 67382 bytes | Authentication: | 31a44e49c16050443582854f71ce46dc
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \n |
Orientation: | column |
Simple Delimited: | |
|
|
|
Table Column Descriptions |
---|
| | | release | release | release | release | release | release | release | release | release | release | release | release | release | release | release | release |
---|
Column Name: | projectDescriptionID
| releaseID
| releaseTime
| commonName
| markedRun
| markedFishOrigin
| sourceOfFishSite
| releaseSite
| releaseSubSite
| nReleased
| testDays
| appliedMarkType
| appliedMarkColor
| appliedMarkPosition
| appliedMarkCode
| IncludeInAnalysis
| Definition: | Foreign key to the CAMP ProjectDescription table | Primary key that in combination with projectDescriptionID is unique (across other programs using CAMP) | Date and time of release | Common name of marked species. Levels = "Chinook salmon" | Run of fish marked. Levels = c("Fall", "Not recorded", "Spring") | Origin or production type of fish marked. Levels = c("Unknown", "Not applicable (n/a)", "Mixed", "Natural", "Hatchery") | Site where fish used for release were from. Levels = c("Not recorded", "Not applicable", "Steep Riffle", "Gateway Riffle", "Herringer Riffle", "Eye Riffle") | Site where fish were released. Levels = c("Eye riffle_release site", "Not applicable", "Steep Riffle_release site", "Herringer_release site", "Gateway_release site", "Gateway Riffle") | Subsite (within site) where fish were released. Corresponds to a trap location. Levels = c("Eye Pool Left & Right RM 60.5", "NA", "Not applicable (n/a)", "Herringer Release boxes", "next to Gateway release boxes", "Gateway release boxesw", "next to Herringer Release boxes", "gateway release_RL & RR", "Steep release_RR & RL", "Below Weir Riffle", "half mile above trap RM") | Number of fish released that were alive with mark intact | Number of days this trap test is considered valid | Mark type that was applied to the release group. Levels = c("Fin clip", "Pigment / dye", "Elastomer") | Color of mark that was applied to the release group. Levels = c("Not applicable (n/a)", "Brown", "Red", "Green", "Yellow", "White", "Pink", "Blue", "Orange", "Purple / Violet") | Position of the mark that was applied to the mark group. Levels = c("Adipose fin", Whole body", "Nose") | Code for mark/tag applied to release group | Levels = c("No", "Yes") | Storage Type: | | | | | | | | | | | | | | | | | Measurement Type: | ordinal | ordinal | dateTime | nominal | nominal | nominal | nominal | nominal | nominal | ratio | ratio | nominal | nominal | nominal | nominal | nominal | Measurement Values Domain: | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | 2 | Definition | Feather River RST program | Source | |
|
|
| Definition | Primary key that in combination with projectDescriptionID is unique (across other programs using CAMP) |
| Format | YYYY-MM-DD hh:mm:ss | Precision | |
| Definition | Common name of marked species. Levels = "Chinook salmon" |
| Definition | Run of fish marked. Levels = c("Fall", "Not recorded", "Spring") |
| Definition | Origin or production type of fish marked. Levels = c("Unknown", "Not applicable (n/a)", "Mixed", "Natural", "Hatchery") |
| Definition | Site where fish used for release were from. Levels = c("Not recorded", "Not applicable", "Steep Riffle", "Gateway Riffle", "Herringer Riffle", "Eye Riffle") |
| Definition | Site where fish were released. Levels = c("Eye riffle_release site", "Not applicable", "Steep Riffle_release site", "Herringer_release site", "Gateway_release site", "Gateway Riffle") |
| Definition | Subsite (within site) where fish were released. Corresponds to a trap location. Levels = c("Eye Pool Left & Right RM 60.5", "NA", "Not applicable (n/a)", "Herringer Release boxes", "next to Gateway release boxes", "Gateway release boxesw", "next to Herringer Release boxes", "gateway release_RL & RR", "Steep release_RR & RL", "Below Weir Riffle", "half mile above trap RM") |
| Unit | number of fish | Type | whole | Min | 0 | Max | 3181 |
| Unit | days | Type | whole | Min | 0 | Max | 29 |
| Definition | Mark type that was applied to the release group. Levels = c("Fin clip", "Pigment / dye", "Elastomer") |
| Definition | Color of mark that was applied to the release group. Levels = c("Not applicable (n/a)", "Brown", "Red", "Green", "Yellow", "White", "Pink", "Blue", "Orange", "Purple / Violet") |
| Definition | Position of the mark that was applied to the mark group. Levels = c("Adipose fin", Whole body", "Nose") |
| Definition | Code for mark/tag applied to release group |
| Definition | Levels = c("No", "Yes") |
| Missing Value Code: | | | | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | | | | |
|
Data Table | Table Structure |
---|
Object Name: | feather_trap_current_year.csv | Size: | 1686495 bytes | Authentication: | 9443581903ed79a5c16eb279cf55c818
Calculated By MD5 | Text Format: |
Number of Header Lines: | 1 |
Record Delimiter: | \n |
Orientation: | column |
Simple Delimited: | |
|
|
|
Table Column Descriptions |
---|
| | | trap | trap | trap | trap | trap | trap | trap | trap | trap | trap | trap | trap | trap | trap |
---|
Column Name: | projectDescriptionID
| trapVisitID
| visitTime
| siteName
| subSiteName
| visitType
| fishProcessed
| trapFunctioning
| counterAtEnd
| rpmRevolutionsAtStart
| rpmRevolutionsAtEnd
| includeCatch
| waterTemp
| turbidity
| 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 | Storage Type: | | | | | | | | | | | | | | | Measurement Type: | ordinal | ordinal | dateTime | nominal | ordinal | nominal | nominal | nominal | ratio | ratio | ratio | nominal | ratio | ratio | 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 |
| Missing Value Code: | | | | | | | | | | | | | | | Accuracy Report: | | | | | | | | | | | | | | | Accuracy Assessment: | | | | | | | | | | | | | | | Coverage: | | | | | | | | | | | | | | | Methods: | | | | | | | | | | | | | | |
|
|