USFS-PNW / Fia-Biosum-Manager

User interface and main code repository for Biosum
http://biosum.info/
Other
3 stars 3 forks source link

FVS: Update line FVSIn logic that sets ht and httopk to 0 for htcd 4 #259

Closed lbross closed 2 years ago

lbross commented 2 years ago

//If Htcd not in {1,2,3} then set the Ht and HtTopK to 0 strSQL = Queries.FVS.FVSInput.TreeInit.DeleteHtAndHtTopKForNonMeasuredHeights(strTreeInitWorkTable);

jsfried commented 2 years ago

Might be better to just add a "4" into the list in case Htcd (and HT) are null for some reason ( so that we give FVS a chance to calculate ht if there is no height).

lbross commented 2 years ago

Use this query after linking master.tree to the fvs input database to validate fix: SELECT htcd, FVS_TreeInit.ht as ht, HtTopK FROM FVS_TreeInit INNER JOIN tree ON (FVS_TreeInit.Tree_ID = val(tree.fvs_tree_id)) AND (FVS_TreeInit.Stand_ID = tree.biosum_cond_id) where htcd = 4

jsfried commented 2 years ago

The heights are coming into TREEINIT beautifully for htcd 4 cases.