Pacific Southwest Region
 |
Resource Management Home |
|
Vegetation Mapping Tiles |
|
Change Detection |
|
Geospatial Data |
|
Publications |
|
Threat of Deforested Conditions |
|
Vegetation Inventory |
|
Vegetation Mapping & Classification |
| Remote Sensing Lab 3237 Peacekeeper Way Suite 209 McClellan, CA 95652 |
|
 |
|
FVS Table Format
The following table lists the fields that are in the FVS Table
Note: In some cases the order of columns in our table in the Access database is different from this documentation.
Table Key
| Cell Color | What the color means in relation to the data |
|---|---|
| Yellow Highlight | Shows the fields in which we have entered data |
| Green Highlight | Shows columns that we added to the table |
FVS_StandInitTableStructure
| Column Name | Data type | Description |
|---|---|---|
| Stand_CN 1 | Char(40) | Required - Database control number |
| Stand_ID 1 | Integer or Char(26) | Required - Stand Identification Code |
| Variant 1 | Char(2) | Required - The 2 character variant identification code |
| Inv_Year 1 | Integer | Required - The stand’s inventory year corresponding to IY(1) in FVS |
| Groups 1 | Char(50) | Region 5 stratum (forest-plan-stra) ; A list of Grouping Codes, also separated by spaces, tabs, carriage returns, or newlines |
| AddFiles | Char(50) | A list of Addfile names (.kcp), separated by tabs, carriage returns, or newlines, which will be inserted into simulation file as one or more components |
| FVSKeywords | Char(50) | A list of FVS keywords, separated by spaces, tabs, carriage returns, or newlines, which define the FVS run |
| Latitude | Float | Latitude in degrees of the stands location |
| Longitude | Float | Longitude in degrees of the stands location |
| Region 1 | Integer | National Forest Region 5 |
| Forest 1 | Integer | National Forest |
| District 1 | Integer | District code within National Forest |
| Compartment | Integer | Compartment code within National Forest or District (3 char code) |
| Ecoregion | Char(6) | Bailey’s Ecoregion code (not yet used). |
| Location | Integer | Location Code representing the Region and Forest codes and corresponds to KODFOR in FVS. When specified, Location takes precedence over Region, Forest, District, and Compartment. |
| Habitat | Integer or Char(10) | PV_Code identifies the potential vegetation. It is often the Habitat type or Plant association code. The two names shown are synonymous. |
| Age | Integer | Stand age in years |
| Aspect 1 | Float | Aspect in degrees |
| Slope 1 | Float | Slope in percent |
| Elevation | Float | Stand elevation represented in 100’s of feet for all variants except AK were it is elevation in 10’s of feet. |
| ElevFt 1 | Float | Elevation in feet. When specified, ElevFt takes precedence over Elevation. |
| Basal_Area_Factor | Float | Basal area factor corresponding to BAF in FVS |
| Inv_Plot_Size 1 | Float | The inverse of the fixed plot size in acres. This is always "1" for Region 5 data |
| Brk_DBH 1 | Float | Breakpoint DBH in inches |
| Num_Plots 1 | Integer | Number of plots represented in FVS |
| NonStk_Plots | Integer | Number of non-stockable plots |
| Sam_Wt | Float | Sampling Weight used to compute the average yield tables and other weighted averages |
| Stk_Pcnt | Float | Stockable percent |
| DG_Trans 1 | Integer | Diameter growth translation code |
| DG_Measure 1 | Integer | Diameter growth measurement period |
| HTG_Trans 1 | Integer | Height growth translation code |
| HTG_Measure 1 | Integer | Height growth measurement period |
| Mort_Measure 1 | Integer | Mortality measurement period |
| Max_BA | Float | Maximum Basal Area |
| Max_SDI | Float | Maximum Stand Density Index |
| Site_Species | Integer or Char(8) | Site Species Code |
| Site_Index 1 | Integer | Site index - For Region 5 it is Dunning |
| Model_Type | Integer | Model Type Code |
| Physio_Region | Integer | Physiographic Region Code |
| Forest_Type | Integer | Forest Type Code |
| State 1 | Integer | FIA State Code |
| County 1 | Integer | FIA County Code |
| Fuel_Model | Integer | Fire behavior fuel model |
| Fuel_0_25 | Float | Initial tons per acre of 0 to 0.25 inch fuel |
| Fuel_25_1 | Float | Initial tons per acre of 0.25 to 1 inch fuel |
| Fuel_0_1 1 | Float | Initial tons per acre of 0 to 1 inch fuel |
| Fuel_1_3 1 | Float | Initial tons per acre of 1 to 3 inch fuel |
| Fuel_3_6 1 | Float | Initial tons per acre of 3 to 6 inch fuel |
| Fuel_6_12 1 | Float | Initial tons per acre of 6 to 12 inch fuel |
| Fuel_gt_12 1 | Float | Initial tons per acre of greater than 12 inch fuel. |
| Fuel_Litter 1 | Float | Initial tons per acre of litter |
| Fuel_Duff 1 | Float | Initial tons per acre of duff |
| Photo_Ref | Integer | Photo series reference number (1 – 32, see FFE documentation) |
| Photo_Code | Char(13) | Photo code (appropriate character strings depend on the photo series reference number, see FFE documentation) |
| GIS_LINK 2 | Char(26) | ProjectName and Plot Number to link to GIS layer |
| PROJECT_NAME 2 | Char(25) | ProjectName |
FVS_TreeInitTableStructure
| Column Name | Data type | Description |
|---|---|---|
| TREE_CN 2 | Integer | Unique tree record identification |
| STAND_CN 1 | Char(50) | Condition Class Plot identification |
| Stand_ID 1 | Integer or Char(26) | Same as Stand_ID in FVS_StandInit table. Not read by FVS, but may be used for querying purposes. |
| Tree_ID 1 | Integer | Tree Identification Code |
| Plot_ID 1 | Integer | Plot Identification -- (SUBPLOT identification) |
| Tree_Count 1 | Float | Tree Count |
| History 1 | Integer | History Code 0-5 are live trees, 6 and 7 died during mortality observation, 8 and 9 died before mortality observation period |
| Species 1 | Char(8) | Tree Species Code, can be the NRCS plant symbol |
| Diameter 1 | Float | Diameter in inches. Diameter is an alias for DBH in this version. |
| DG 1 | Float | DBH Growth in inches (not tenths of inches) |
| DIAMETER_HT 1 | Float | Height at which the Diameter was taken |
| Ht 1 | Float | Height in feet |
| HtG 1 | Float | Height Growth in feet |
| HtTopK | Float | Height to top kill is the height to the point of the tree of top kill in feet |
| CrRatio 1 | Integer | If the number is 0-9 then it is considered a crown ratio code, according to the FVS documentation. If the number is 10-99 the value is considered a percent live crown. |
| Damage1 1 | Integer | For Region 5 - Mistletoe by Species; Damage Code, see the FVS documentation for details |
| Severity1 1 | Integer | For Region 5 - Hawksworth Mistletoe Severity Code corresponding to damage code 1 |
| Damage2 | Integer | Second damage code |
| Severity2 | Integer | Second severity code |
| Damage3 | Integer | Third damage code |
| Severity3 | Integer | Third severity code |
| TreeValue 1 | Integer | Tree Value Class |
| Prescription | Integer | Prescription code where anything other than a 1 or 0 marks the tree for removal |
| Age 1 | Float | Age of tree |
| Slope 1 | Integer | Slope Percentage on the plot where the tree was located |
| Aspect 1 | Integer | Aspect in degrees on the plot where the tree was located |
| Habitat | Integer or Char(10) | The potential vegetation code on the plot where the tree was located (see notes in table 11 for the stand). |
| TopoCode | Integer | Topography Code 1=bottom, 2=lower, 3=mid slope, 4=upper slope, and 5=ridge top, on the plot where the tree was located |
| SitePrep | Integer | Site Preparation code 1=none, 2=mechanical, 3=burn, and 4=road cuts/road fills/stockable road beds, on the plot where the tree was located |
For more information about the Inventory Data contact Kama Kennedy at (916) 640-1253 or kkennedy@fs.fed.us
USDA Forest Service - Pacific Southwest Region
Last Modified: Friday, 13 April 2012 at 13:21:57 EDT