Hi Marianne




Yüklə 113.06 Kb.
tarix26.04.2016
ölçüsü113.06 Kb.
Hi Marianne:
I must apologize for taking so long to get back to you. As per our conversation of Friday, September 4, here is the list of Weldwood’s PGS Plots (and associated TRENDS installation numbers) where data needs to be transformed to be entered into the NIVMA TRENDS database.



WC


Plot


TRENDS Install. No.


WC


Plot


TRENDS Install. No.

1

111

6

1

112

7

3-13

116

10

3-13

117

11

5

299

9

3

474

12

3

475

8

2

549

2

2

550

1

2

568

3

2

569

4

2

662

5

The following is a description of the transformations that need to be applied to the data so that they can be downloaded into the TRENDS database. The reference numbers correspond to the cell numbers on the Stand Description form (Quatro Pro file: Stand.wb1 separate attachment).




  1. Quad Number: This information is not available from the PGS form. A blank should be left in the data file for this entry.




  1. Tree Number: The TRENDS format for tree numbers is an “S” followed by zeros and the tree number to a maximum of 4 cells. Please add S’s and pad with zeros to fill 4 cells.




  1. Species: Please use the following table to convert Alberta species codes to BC codes.



Code Definition


Acceptable Codes


Tree Species Common Name


Tree Species Latin Name and Reference1


Code

Black cottonwood

Populus trichocarpa Torr. & A. Gray


Act

Balsam poplar

Populus balsamifera L.


Acb

Trembling aspen

Populus tremuloides Michx.


At

Amabilis fir

Abies amabilis (Dougl. ex Loud.) Dougl. ex J. Forbes


Ba

Balsam fir

Abies balsamea (L.) Mill.


Bb

Grand fir

Abies grandis (Dougl. ex D. Don) Lindl.


Bg

Subalpine fir

Abies lasiocarpa (Hook.) Nutt.


Bl

Noble fir

Abies procera Rehd.


Bn

Western red cedar

Thuja plicata Donn ex D. Don


Cw

Red alder

Alnus rubra Bong.


Dr

Speckled alder

Alnus incana ssp. rugosa (Du Roi) J. Clausen


Ds

Sitka alder

Alnus viridis ssp. sinuata (Regel) Á. Löve & D. Löve


Dv

Green alder

Alnus viridis ssp. crispa (Ait.) Turrill


Dg

Siberian alder

Alnus viridis ssp. fruticosa (Rupr.) Nym.


Df

Paper birch

Betula papyrifera Marsh.


Ep

Douglas-fir - interior variety

Pseudotsuga menziesii var. glauca (Beissn.) Franco


Fdi

Douglas-fir - coastal variety

Pseudotsuga menziesii (Mirb.) Franco var. menziesii


Fdc

Mountain hemlock

Tsuga mertensiana (Bong.) Carrière


Hm

Western hemlock

Tsuga heterophylla (Raf.) Sarg.


Hw

Alpine larch

Larix lyallii Parl.


La

Tamarack

Larix laricina (Du Roi) K. Koch


Lt

Western Larch

Larix occidentalis Nutt.


Lw

Whitebark pine

Pinus albicaulis Engelm.


Pa

Limber pine

Pinus flexilis James


Pf

Jack pine

Pinus banksiana Lamb.


Pj

Lodgepole pine - interior variety

Pinus contorta Dougl. ex Loud. var. latifolia Engelm.


Pli


Lodgepole pine - coastal variety


Pinus contorta Dougl. ex Loud. var. contorta


Plc

Western white pine

Pinus monticola Dougl. ex D. Don


Pw

Ponderosa pine/ Yellow pine

Pinus ponderosa P. Laws. ex C. Laws.


Py

Black spruce

Picea mariana (Mill.) BSP


Sb

Sitka spruce

Picea sitchensis (Bong.) Carrière


Ss

Engelmann spruce



For Alberta only

Picea engelmannii Parry ex Engelm.


Se

White spruce



For Alberta only

Picea glauca (Moench) Voss


Sw

Interior spruce = white, Engelmann and hybrids



For BC only

Sx

Willow

Salix sp.


W

Yellow cedar

Chamaecyparis nootkatensis (D. Don) Spach


Yc





  1. DBH: Straight transfer, no changes required.




  1. Estimated Height: Please enter your Actual Heights. We will be developing a program to deal with the difference between actual and estimated heights.




  1. Percent Live Crown: You will need to convert your Height to Live Crown (HTL) to a percentage of live crown using the following formula (or something else that gives the same results) %LC = (Ht. - HTL)/Ht. X 100. Please note that where this cell is blank on the PGS plot forms because a tree is dead, a “0" must be entered for the TRENDS database.




  1. Radial Crown Width: Please round to the nearest tenth of a meter. As for HTL, where this cell is blank on the PGS plot forms because a tree is dead, a “0" must be entered for the TRENDS database.

...2


Page 2


  1. Vigor: Please use the following conversion table:





WWHIN Codes


TRENDS Codes

0 - Live

If “Dam 1” is blank - 3

If “Dam 1” is not blank - 2


1 - snag - no broken top


1

2 - stub - broken top

1 + “BT” under Damage Agent (cell 17)


3 - stub - sawn off


delete record


4 - log on ground


delete record


5 - lost

delete record

6 - site tree


3

8 - first measurement

If “Dam 1” is blank - 3

If “Dam 1” is not blank - 2





  1. Acceptability: Leave blank.




  1. Plot Radius: Please convert your per acre/hectare plot size to a radius in meters of a circle of equivalent area.




  1. Damaging Agents: The TRENDS crew has been advised to collect damaging agent information in future plots using the TRENDS codes. This should mean that this conversion of Alberta to BC damaging agent and severity codes should only happen for this 1997 data. For this reason, I will only make conversions for the damaging agents that were noted on the 1997 data forms. Please refer to the following table to convert damaging agent and severity codes.





Alberta Codes


BC Codes


Dam


Sev


DamAg 1


Sev 1


DamAg 2


Sev 2

A-E

A-D

none required*








PC

0-3

R







PL

0-3

DT



NL



PD

0-3

DT







PS

0-3









UK

0-3









PF

0-3

F







DM

1

DM

1





DM

2

DM

2





DM

3

DM

3





PM

0-3

BT







HM

0-3









AS

0-3

WS







PB

0-3

L







WC

0-3

AFC







DW

1

DSG

BC





DW

2

DSG

SC





DW

3

DSG

TK





DC

0-3

DD







PR

0-3

DD







*Note: When no severity code is required by TRENDS, please make this cell blank. When the severity code is left blank in the above table, there is no severity code required. When there is no entry for BC codes in the above table, it is to signify that we are disregarding this damaging agent.


Note: A code of “BM” was noticed on the forms for plot 568 in WC 2. There is no such acceptable code. I have decided to disregard this damaging agent record.
Steve Monai, our TRENDS Database Steward, provided the following format in which the data must be received to be run through our data checking program and loaded into the database:


Data Record Type


Comma Delimited Format

D1 - Installation Plot Radius


“D1",Timbermark, CP, Block, Install, YYYY, MM, DD, Harvest, Radius


D2 - Individual Tree Information


“D2",Timbermark, CP, Block, Install, YYYY, MM, DD, Harvest, Quad, Tree, Species, DBH, EstHeight, %LiveCr, RadialCrown, Vigour, Accept


D3 - Damage Agents and Severity codes on individual trees.


“D3", Timbermark, CP, Block, Install, YYYY, MM, DD, Harvest, Tree, DamageAgent, Severity, DamAg, Sev, DamAg, Sev, DamAg, Sev, DamAg, Sev


Where: Timbermark = WWHIN

CP = 1997

Block = 0

Install = Refer to this first table in this document to match PGS plot numbers with TRENDS installation numbers.

YYYY = Year of measurement

MM = Month of measurement

DD = Day of measurement (enter “15" if actual date is unknown)

Tree = Tree number

Harvest = “Pre” (to signify ‘pre-harvest’)

DamAg - Damage Agents are repeated five times to allow for five different damaging agents and their severity codes on each tree. If there are less than five damaging agents, just leave the remaining cells blank.
Although Weldwood did not complete any new TRENDS installations this year, we hope that they will continue to add new installations in the future. Stand Description data on any new installations that they establish will have to be transferred to us in this same manner (except for the damaging agents).
I hope that this is all fairly clear, by I expect that you will have some questions. Please direct any sampling methodology or code-type questions to either me or Andrea Eastham at Industrial Forestry Service Ltd. (IFS) at (250)564-4115. Any questions regarding our database structure or the actual transfer of data should be directed to Steve Monai, also at IFS.
I look forward to working with you to complete this project.
Sincerely,

Naomi Donat




1 Farrar, J.L. 1995. Trees in Canada. Fitzhenry & Whiteside Limited. Markham, Ontario.



Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©azrefs.org 2016
rəhbərliyinə müraciət

    Ana səhifə