search

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

ZAB missing biomass measurements #141

Open kaijagahm opened 3 years ago

kaijagahm commented 3 years ago

For several sampleID's in 2016 and 2017, for non-chaoborus zoops that DO have a meanMass recorded, there is for some reason no biomass recorded, even though it should be calculatable.

sampleID's are: [1] "EL_DeepHole_20160505_1000_tow_10_zoopCounts.20181114" [2] "EL_DeepHole_20160510_1000_tow_10_zoopCounts.20181114" [3] "EL_DeepHole_20160517_1000_tow_10_zoopCounts.20181114" [4] "EL_DeepHole_20160524_1000_tow_10_zoopCounts.20181114" [5] "EL_DeepHole_20160531_1000_tow_10_zoopCounts.20181114" [6] "EL_DeepHole_20160607_1000_tow_8_zoopCounts.20181114" [7] "EL_DeepHole_20160614_1000_tow_8_zoopCounts.20181114" [8] "EL_DeepHole_20160620_1000_tow_8_zoopCounts.20181114" [9] "EL_DeepHole_20160628_1000_tow_8_zoopCounts.20181114" [10] "EL_DeepHole_20160712_1000_tow_8_zoopCounts.20181114" [11] "EL_DeepHole_20160719_1000_tow_8_zoopCounts.20181114" [12] "EL_DeepHole_20160802_1000_tow_8_zoopCounts.20181114" [13] "EL_DeepHole_20160809_1000_tow_8_zoopCounts.20181114" [14] "EL_DeepHole_20160816_1000_tow_8_zoopCounts.20181114" [15] "EL_DeepHole_20160830_1000_tow_8_zoopCounts.20181114" [16] "EL_DeepHole_20160913_1000_tow_8_zoopCounts.20181114" [17] "EL_DeepHole_20170512_1000_tow_8_zoopCounts.20181114" [18] "EL_DeepHole_20170523_1000_tow_10_zoopCounts.20181114" [19] "EL_DeepHole_20170530_1000_tow_10_zoopCounts.20181114" [20] "EL_DeepHole_20170613_1000_tow_10_zoopCounts.20181114" [21] "EL_DeepHole_20170620_1000_tow_10_zoopCounts.20181114" [22] "EL_DeepHole_20170627_1000_tow_10_zoopCounts.20181114" [23] "EL_DeepHole_20170718_1000_tow_10_zoopCounts.20181114" [24] "EL_DeepHole_20170725_1000_tow_10_zoopCounts.20181114" [25] "EL_DeepHole_20170801_1000_tow_10_zoopCounts.20181114" [26] "EL_DeepHole_20170808_1000_tow_8_zoopCounts.20181114" [27] "EL_DeepHole_20170815_1000_tow_8_zoopCounts.20181114" [28] "EL_DeepHole_20170822_1000_tow_8_zoopCounts.20181114" [29] "EL_DeepHole_20170829_1000_tow_8_zoopCounts.20181114" [30] "EL_DeepHole_20170928_1000_tow_8_zoopCounts.20181114" [31] "WL_DeepHole_20160510_0830_tow_10_zoopCounts.20181114" [32] "WL_DeepHole_20160524_0830_tow_8_zoopCounts.20181114" [33] "WL_DeepHole_20160531_0830_tow_10_zoopCounts.20181114" [34] "WL_DeepHole_20160607_0830_tow_8_zoopCounts.20181114" [35] "WL_DeepHole_20160614_0830_tow_8_zoopCounts.20181114" [36] "WL_DeepHole_20160620_0830_tow_8_zoopCounts.20181114" [37] "WL_DeepHole_20160705_0830_tow_8_zoopCounts.20181114" [38] "WL_DeepHole_20160712_0830_tow_8_zoopCounts.20181114" [39] "WL_DeepHole_20160719_0830_tow_8_zoopCounts.20181114" [40] "WL_DeepHole_20160802_0830_tow_8_zoopCounts.20181114" [41] "WL_DeepHole_20160809_0830_tow_8_zoopCounts.20181114" [42] "WL_DeepHole_20160816_0830_tow_8_zoopCounts.20181114" [43] "WL_DeepHole_20160830_0830_tow_8_zoopCounts.20181114" [44] "WL_DeepHole_20160913_0830_tow_8_zoopCounts.20181114" [45] "WL_DeepHole_20170512_0000_tow_8_zoopCounts.20181114" [46] "WL_DeepHole_20170523_0830_tow_10_zoopCounts.20181114" [47] "WL_DeepHole_20170530_0830_tow_10_zoopCounts.20181114" [48] "WL_DeepHole_20170613_0830_tow_10_zoopCounts.20181114" [49] "WL_DeepHole_20170620_0830_tow_8_zoopCounts.20181114" [50] "WL_DeepHole_20170627_0830_tow_10_zoopCounts.20181114" [51] "WL_DeepHole_20170711_0830_tow_8_zoopCounts.20181114" [52] "WL_DeepHole_20170718_0830_tow_10_zoopCounts.20181114" [53] "WL_DeepHole_20170725_0830_tow_8_zoopCounts.20181114" [54] "WL_DeepHole_20170801_0830_tow_10_zoopCounts.20181114" [55] "WL_DeepHole_20170808_0830_tow_8_zoopCounts.20181114" [56] "WL_DeepHole_20170815_0830_tow_8_zoopCounts.20181114" [57] "WL_DeepHole_20170822_0830_tow_8_zoopCounts.20181114" [58] "WL_DeepHole_20170829_0830_tow_8_zoopCounts.20181114" [59] "WL_DeepHole_20170928_0830_tow_8_zoopCounts.20181114"

Code:

zab %>% filter(is.na(biomass_gDryMass_m3)) %>% filter(!taxa == "chaoborus") %>% filter(!is.na(meanMass_ug)) %>% arrange(sampleID)
kaijagahm commented 3 years ago

Have to wait on this one until #99 is finalized and the database updated, since it relies on having unique primary key rows in ZOOPS_ABUND_BIOMASS.

kaijagahm commented 3 years ago

This issue has a script started. See 'gh1431_zoopBiomassCalc.R' in my archive.

joneslabND commented 2 years ago

Some (perhaps many) of these are missing length measurements and therefore we may not be able to calculate abundance. I'm not sure if the measurements were never made or if they can be found. I did find some 2016 lengths, but the dates don't match all of these dates...