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 FVS Out interface with FICS for ht and actualht #292

Closed lbross closed 1 year ago

lbross commented 1 year ago
  1. On initial load set ht = FVSCutList.ht and actualht = FVSCutList.ht
  2. Run second pass to update records where FvsCreatedTree_YN = 'N' if tree.actualht < tree.ht then ht = FVSCutList.estht Note: actualht is already FVSCutList.ht from the initial load
lbross commented 1 year ago
  1. The FVSOut process starts with a select on the FVS_CutList table. In this select we will set FICS.ht = FVSCutList.ht and FICS.actualht = FVSCutList.ht

  2. For FIA trees: IF MASTER.TREE.ACTUALHT <> MASTER.TREE.HT THEN FICS.actualht = (FVS_CutList.HT - master.tree.HT) + MASTER.TREE.ACTUALHT. (The else statement will have already been covered)

lbross commented 1 year ago

Per @sebbusby: seems to be working as expected