search

helendallas / FRC_FBIS

Freshwater research Centre FBIS Data Consolidation Management
0 stars 0 forks source link

Shelton et al 2018 fish data - correction needed #165

Closed jeremyshelton closed 1 year ago

jeremyshelton commented 3 years ago

@aneriswanepoel there is an issue with the Shelton et al 2018 fish data from the upper Berg River. The fish data for the uppermost site is actually meant to be from the lowermost site, and so on.

Screen Shot 2021-08-06 at 8 50 37 AM

I think the easiest way to fix this is (1) to delete all fish data from this study, but to not delete the sites and then (2) create and upload a revised version of this spreadsheet with FBIS site codes, dates and coords inverted (i.e. replace codes for records at top with codes for records at bottom). I think new UUIDs will be needed.

Here is a csv spreadsheet from these sites: WRC 2337 - revision needed.xlsx

The other data from that study, in the Amandel River, are correct and do not need adjusting.

jeremyshelton commented 3 years ago

@aneriswanepoel fixed csv file for this is called Shelton et al 2018.csv in 'Data ready for ingestion'