search

nutnetadmin / nutnet-data-tracker

Track bugs, changes and updates in NutNet data
2 stars 0 forks source link

Species specific biomass #469

Open nutnetadmin opened 10 months ago

nutnetadmin commented 10 months ago

A handful of sites sort biomass to species. Typically we have aggregated this data down to functional group during upload (i.e. species data is not stored in SQL). Recently there has been more interest in using these data.

PW's idea for this is to add site_taxon_ID to the biomass table WITH a category_ID (functional group). I think views would still operate normally since they already sum by year-plot-functional group as is, but this should be monitored.

Known sites with species specific biomass:

Iceland (ahth.is, amlr.is, thth.is, tmlr.is) bynb.cn cdcr.us (2018 onward) cbgb.us (2009-2014) konz.us (they aggregate before sending, but Kim Komatsu verified they have it on their end) yarra.au (all years) azitwo.cn (all years)

Sevielleta uses allometry, but since this is based on cover I don't think we should use it for this database.

nutnetadmin commented 9 months ago

On 2023-12-18 PW and IS altered the biomass table to allow site_taxon_IDs. This was entered for cdcr.us 2022 data as a test run.

As of now there is no view for outputting this but should be a relatively straight forward modification of the full-biomass view where tables 'taxon' and 'site_taxon' are merged in, a column for taxon name is added to the select column list, group by is changed from 'category' to 'site_taxon_ID', and a 'where/and site_taxon_ID is not null' is added to the any filters. At least that is how it works in PWs head...