biomass.sql

insert into ag_biomass({treeID},
			{standID},
			{Year},
			boleKG,
			barkKG,
			branchKG,
			biomassKG)
	with foo as (select fvs.Species FIA_code,
             	    	    xw.Species as CARB_code,
       			    {DBH},
       			    {Ht},
       			    wt.Common_name,
       			    wood_type,
       			    Specific_gravity,
       			    Wood_density,
       			    {treeID},
       			    {standID},
       			    {Year},
       			    cvts({Ht},{DBH},xw.Species) cvtscft -- python function
		from FVS_TreeList fvs
 		join woodtype wt on wt.FIA_code = fvs.Species 
 		join species_xwalk xw on fvs.Species = xw.FIA_Code 
 		join arb_eqns eq on fvs.Species = eq.FIA_code limit 5000000),
	bar as (select {treeID},
                       {standID},
                       {DBH},
                       {Ht},
                       Year,
                       CARB_code,
                       bmKG(cvtscft, Wood_density) boleKG, -- python function
                       barkBio({DBH}, {Ht}, CARB_code) barkKG, -- python function
                       branchBio({DBH}, {Ht}, CARB_code) branchKG -- python function
                       from foo)
	select {treeID},
	       {standID},
	       {Year},
	       boleKG,
	       barkKG,
	       branchKG,
	       boleKG+barkKG+branchKG biomassKG
	       from bar;