VegBank

edit qry: move_E2_to_E_tallies

ADD the following to move_E2_to_E_pre1:
------------------------

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally16 AS stemCount, minHt_tally16 AS minHt,
maxHt_tally16 AS maxHt, minDBH_tally16 AS minDBH, maxDBH_tally16 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally16>0 ;

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally17 AS stemCount, minHt_tally17 AS minHt,
maxHt_tally17 AS maxHt, minDBH_tally17 AS minDBH, maxDBH_tally17 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally17>0 ;

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally18 AS stemCount, minHt_tally18 AS minHt,
maxHt_tally18 AS maxHt, minDBH_tally18 AS minDBH, maxDBH_tally18 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally18>0 ;

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally19 AS stemCount, minHt_tally19 AS minHt,
maxHt_tally19 AS maxHt, minDBH_tally19 AS minDBH, maxDBH_tally19 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally19>0 ;

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally20 AS stemCount, minHt_tally20 AS minHt,
maxHt_tally20 AS maxHt, minDBH_tally20 AS minDBH, maxDBH_tally20 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally20>0 ;

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally21 AS stemCount, minHt_tally21 AS minHt,
maxHt_tally21 AS maxHt, minDBH_tally21 AS minDBH, maxDBH_tally21 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally21>0 ;

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally22 AS stemCount, minHt_tally22 AS minHt,
maxHt_tally22 AS maxHt, minDBH_tally22 AS minDBH, maxDBH_tally22 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally22>0 ;

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally23 AS stemCount, minHt_tally23 AS minHt,
maxHt_tally23 AS maxHt, minDBH_tally23 AS minDBH, maxDBH_tally23 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally23>0 ;

union all SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally24 AS stemCount, minHt_tally24 AS minHt,
maxHt_tally24 AS maxHt, minDBH_tally24 AS minDBH, maxDBH_tally24 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally24>0 ;

UNION ALL SELECT Z_USER_E2_stemClasses_data_alldefn.AuthorPlotCode,
Z_USER_E2_stemClasses_data_alldefn.PLANTCode,
Z_USER_E2_stemClasses_data_alldefn.stratumIndex,
Z_USER_E2_stemClasses_data_alldefn.stemTaxonArea,
Z_USER_E2_stemClasses_data_alldefn.stemHealth,
Z_USER_E2_stemClasses_data_alldefn.tally25 AS stemCount, minHt_tally25 AS minHt,
maxHt_tally25 AS maxHt, minDBH_tally25 AS minDBH, maxDBH_tally25 AS maxDBH
FROM Z_USER_E2_stemClasses_data_alldefn WHERE tally25>0;

edit move_E2_to_E_getTallyDefns and related queries

import queries from Peet Rockies VegBranch DB modified on or after 6/2/05 @ 11:45am

done in NPS-PLOTS entry version

Original Bugzilla ID was 2099