MFEh2o / db

**Contains the main issue tracker for the MFE DB!** Functions for interacting with the MFE database, in script format. (See also MFEUtilities, which is an R package that includes many/most of the same functions).
1 stars 0 forks source link

Add Chelsea's bluegill data to the database #93

Closed kaijagahm closed 3 years ago

kaijagahm commented 3 years ago

Two main sheets:

  1. NotoriousBLG: this is the main sites/samples/data sheet. Need to check whether this info is already in the database or not. Randi may have done some processing in the past.

  2. Meristics: fish measurements. We'll create a new table for this. Can play around with long vs. wide formats.

kaijagahm commented 3 years ago
  1. All sites are already included in SITES. Most fish are already included in FISH_INFO, but not all. Have to figure out why. Have not yet looked into FISH_SAMPLES.
kaijagahm commented 3 years ago

All checked and ready to go, in script chelseaDataEnter_FISH_INFO_cleanup_gh92_gh29_gh93R. Combined with #29 and #92 to reduce the number of database updates necessary.

Ready for db update after writing out files etc.

kaijagahm commented 3 years ago

Got the OK on the FISH_MORPHOMETRICS data from Chris and Stuart in meeting today.

kaijagahm commented 3 years ago

Added an explanatory note to the bluegill metadata document to describe the protocol for measurement error in the morphometric measurements (Chelsea re-measured 30 fish from each of two lakes four times each).

kaijagahm commented 3 years ago

Finished in v 4.1.0