search

nutnetadmin / nutnet-data-tracker

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

upload new sampling data: koffler.ca 2021-2022 (year 11-12) #412

Closed nutnetadmin closed 1 year ago

nutnetadmin commented 2 years ago

biomass in g/0.2m2

nutnetadmin commented 1 year ago

Uploaded with 'import-koffler-2021-2022.sql'

Carlos Alberto Arnillas said that one plot's woody biomas was not reported in 2022, so waiting for that to close.

nutnetadmin commented 1 year ago

woody biomass insertion appended to above script at biomass entry point:

insert into biomass (subplot_ID, year, date, mass, biomass_category_ID) select distinct subplot_ID, 2022, '2022-08-27', 1955 * 5, biomass_category_id from biomass_temp a left join plot on (plot.site_ID = @siteid and plot.plot = 2) left join subplot on (plot.plot_ID = subplot.plot_ID and subplot.subplot = 'A') left join biomass_category on (category='WOODY') group by a.site, a.block, a.plot, a.subplot, biomass_category_ID, date ;