Bug #2099: allow more stems in stemClasses (25 instead of 15) - VegBank - Ecoinformatics Redmine

Custom queries

Tasks-hierarchical
Tickets grouped by Target version

Actions

Copy link

Bug #2099

closed

allow more stems in stemClasses (25 instead of 15)

Added by Michael Lee over 19 years ago. Updated over 19 years ago.

Status:

Resolved

Priority:

Normal

Assignee:

Michael Lee

Category:

vegbranch

Target version:

UnMilestoned

Start date:

06/02/2005

Due date:

% Done:

Estimated time:

Bugzilla-Id:

2099

History
Notes

Actions

Copy link

Updated by Michael Lee over 19 years ago

edit qry: move_E2_to_E_tallies

Actions

Copy link

Updated by Michael Lee over 19 years ago

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;

Actions

Copy link