Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Model output that simulates the effects of thinning on forest sturcture throughout Oregon, Washington and northwestern California from 2004 to 2146
Short Name: Vegetation Simulation Results
Status: Planned
Abstract:

This is the FVS model output. It provides information for each tree in each plot in each stand for each year of the simulation. See FVS user guide at https://www.fs.fed.us/fmsc/fvs/ for model manuals.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: PARR
Description:

This is the FVS model output. It provides information for each tree in each plot in each stand for each year of the simulation. See FVS user guide at https://www.fs.fed.us/fmsc/fvs/ for model manuals.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Id Number Row identification number see FVS manual for details at https://www.fs.fed.us/fmsc/ftp/fvs/docs/gtr/DBSUserGuide.pdf.
100
CaseID Number Case identification number- based on stand and treatment (thinning) type. Assigned by FVS model in this db, 7 stands x 4 treatments = 28 cases.
100
StandID Text Required - Should match Stand_ID in FVS_StandInit table. Not read by FVS, but may be used for querying purposes. See FVS manual for details.
100
Year Number Simulation year See FVS manual for details.
100
PrdLen Number Length of time between simulation year intervals (e.g. 10) See FVS manual for details.
100
TreeId Text Tree Identification Code. Should be unique to each plot but can be repeated for trees in different plots.See FVS manual for details.
100
TreeIndex Number Tree index See FVS manual for details at https://www.fs.fed.us/fmsc/ftp/fvs/docs/gtr/DBSUserGuide.pdf.
100
Species Text Required - Tree Species Code, can be the FVS alpha code, FIA code or USDA plant symbol. Refer to the Variant Overview for species and codes recognized. USFS standard abbreviations for latin binomials (e.g. PSME for Douglas-fir).
100
TreeVal Number Tree Value Class Code 1 for desirable, 2 for acceptable, 8 for non-stockable and any other number represents a live cull See FVS manual for details.
100
SSCD Number Special tree code-not applicable for this simulation. See FVS manual for details.
100
PtIndex Number Point (or plot) index See FVS manual for details at https://www.fs.fed.us/fmsc/ftp/fvs/docs/gtr/DBSUserGuide.pdf.
100
TPA Number Trees Per Acre See FVS manual for details.
100
MortPA Number Mortality Trees Per Acre See FVS manual for details.
100
DBH Number Diameter Breast Height (inches) See FVS manual for details.
100
DG Number Dbh Growth in inches (not tenths of inches). Used for large tree diameter growth calibration when minimum number of sample trees are included for the species.
100
Ht Number Total height in feetSee FVS manual for details.
100
HtG Number Height Growth in feet. May be used for small tree height growth calibration.See FVS manual for details.
100
PctCr Number Percent crown depth relative to height of tree (e.g. 30% on a 100 foot tall treee = 30 foot high crown) See FVS manual for details.
100
CrWidth Number Crown Width rating code See FVS manual for details.
100
MistCD Number Mistletoe rating code See FVS manual for details.
100
BAPctile Number Basal area percentile See FVS manual for details.
100
PtBAL Number Point-level basal area in larger trees See FVS manual for details.
100
TCuFt Number Total cubic feet See FVS manual for details.
100
MCuFt Number Merchantable cubic feet See FVS manual for details.
100
BdFt Number Board Feet.
100
MDefect Number Defect percent on MCuFt.
100
BDefect Number Defect percent on BdFt.
100
TruncHt Number Truncated Height in feet.
100
EstHt Number Estimated Height in feet.
100
ActPt Number Actual point (or plot) number from input.

Attribute Details

Id

CC ID: 793194
Seq. Order: 1
Data Storage Type: Number
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Row identification number see FVS manual for details at https://www.fs.fed.us/fmsc/ftp/fvs/docs/gtr/DBSUserGuide.pdf.

General Data Type: Number

CaseID

CC ID: 793195
Seq. Order: 2
Data Storage Type: Number
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Case identification number- based on stand and treatment (thinning) type. Assigned by FVS model in this db, 7 stands x 4 treatments = 28 cases.

General Data Type: Number

StandID

CC ID: 793196
Seq. Order: 3
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Required - Should match Stand_ID in FVS_StandInit table. Not read by FVS, but may be used for querying purposes. See FVS manual for details.

General Data Type: Text

Year

CC ID: 793197
Seq. Order: 4
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Simulation year See FVS manual for details.

General Data Type: Number

PrdLen

CC ID: 793198
Seq. Order: 5
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Length of time between simulation year intervals (e.g. 10) See FVS manual for details.

General Data Type: Number

TreeId

CC ID: 793199
Seq. Order: 6
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Tree Identification Code. Should be unique to each plot but can be repeated for trees in different plots.See FVS manual for details.

General Data Type: Text

TreeIndex

CC ID: 793200
Seq. Order: 7
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Tree index See FVS manual for details at https://www.fs.fed.us/fmsc/ftp/fvs/docs/gtr/DBSUserGuide.pdf.

General Data Type: Number

Species

CC ID: 793201
Seq. Order: 8
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Required - Tree Species Code, can be the FVS alpha code, FIA code or USDA plant symbol. Refer to the Variant Overview for species and codes recognized. USFS standard abbreviations for latin binomials (e.g. PSME for Douglas-fir).

General Data Type: Text

TreeVal

CC ID: 793202
Seq. Order: 9
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Tree Value Class Code 1 for desirable, 2 for acceptable, 8 for non-stockable and any other number represents a live cull See FVS manual for details.

General Data Type: Number

SSCD

CC ID: 793203
Seq. Order: 10
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Special tree code-not applicable for this simulation. See FVS manual for details.

General Data Type: Number

PtIndex

CC ID: 793204
Seq. Order: 11
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Point (or plot) index See FVS manual for details at https://www.fs.fed.us/fmsc/ftp/fvs/docs/gtr/DBSUserGuide.pdf.

General Data Type: Number

TPA

CC ID: 793205
Seq. Order: 12
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Trees Per Acre See FVS manual for details.

General Data Type: Number

MortPA

CC ID: 793206
Seq. Order: 13
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Mortality Trees Per Acre See FVS manual for details.

General Data Type: Number

DBH

CC ID: 793207
Seq. Order: 14
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Diameter Breast Height (inches) See FVS manual for details.

General Data Type: Number

DG

CC ID: 793208
Seq. Order: 15
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Dbh Growth in inches (not tenths of inches). Used for large tree diameter growth calibration when minimum number of sample trees are included for the species.

General Data Type: Number

Ht

CC ID: 793209
Seq. Order: 16
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total height in feetSee FVS manual for details.

General Data Type: Number

HtG

CC ID: 793210
Seq. Order: 17
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Height Growth in feet. May be used for small tree height growth calibration.See FVS manual for details.

General Data Type: Number

PctCr

CC ID: 793211
Seq. Order: 18
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Percent crown depth relative to height of tree (e.g. 30% on a 100 foot tall treee = 30 foot high crown) See FVS manual for details.

General Data Type: Number

CrWidth

CC ID: 793212
Seq. Order: 19
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Crown Width rating code See FVS manual for details.

General Data Type: Number

MistCD

CC ID: 793213
Seq. Order: 20
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Mistletoe rating code See FVS manual for details.

General Data Type: Number

BAPctile

CC ID: 793214
Seq. Order: 21
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Basal area percentile See FVS manual for details.

General Data Type: Number

PtBAL

CC ID: 793215
Seq. Order: 22
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Point-level basal area in larger trees See FVS manual for details.

General Data Type: Number

TCuFt

CC ID: 793216
Seq. Order: 23
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total cubic feet See FVS manual for details.

General Data Type: Number

MCuFt

CC ID: 793217
Seq. Order: 24
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Merchantable cubic feet See FVS manual for details.

General Data Type: Number

BdFt

CC ID: 793218
Seq. Order: 25
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Board Feet.

General Data Type: Number

MDefect

CC ID: 793219
Seq. Order: 26
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Defect percent on MCuFt.

General Data Type: Number

BDefect

CC ID: 793220
Seq. Order: 27
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Defect percent on BdFt.

General Data Type: Number

TruncHt

CC ID: 793221
Seq. Order: 28
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Truncated Height in feet.

General Data Type: Number

EstHt

CC ID: 793222
Seq. Order: 29
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Estimated Height in feet.

General Data Type: Number

ActPt

CC ID: 793223
Seq. Order: 30
Data Storage Type: Number
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Actual point (or plot) number from input.

General Data Type: Number

Catalog Details

Catalog Item ID: 54426
GUID: gov.noaa.nmfs.inport:54426
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2018-10-25 14:08+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-10-25
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-10-25
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-10-25