USDA Forest Service
 

Pacific Southwest Region

Remote Sensing Lab
3237 Peacekeeper Way
Suite 209
McClellan, CA 95652

United States Department of Agriculture Forest Service.

Vegetation Cover Output Format for a FSVEG_VXPT_V MSAccess table

Format of Output from FSVEG version 1.5

Codes in Record Type Columns

  • X = Required entry
  • O = Optional entry
  • Blank = Not applicable for record type
  • # = Filled in with the field abbreviation

Vegetation Record Types (Lifeform)

  • C = Conifer
  • H = Hardwood
  • B = Brush (Shrub)
  • G = Grass
  • E = Forbs
  • Z = Other Ground Cover
  • K = Special Features
For Vegetation Records
Spreadsheet
Column
FSVeg Description Record Type R5 (Access Database)
FSVeg
Field Name
FSVeg
Table Name
Field Type C H B G E Z K R5 Abbrev.
Field Name
Data Type Field Size Sort
Number
A forest_admin nrv_setting_measurements VARCHAR2(2) Forest X X X X X X X FOREST Text 2 1
B setting_id(3,1) nrv_setting_measurements VARCHAR2(1) Planning Unit X X X X X X X PLAN Text 1 2
C stratum nrv_setting_measurements VARCHAR2(6) Stratum X X X X X X X STRA Text 6 3
D setting_id(10,1) nrv_setting_measurements VARCHAR2(1) Condition X X X X X X X SPLT Text 1 4
E level_1_id nrv_setting_measurements VARCHAR2(10) Plot X X X X X X X PLOT Text 10 5
F district_no nrv_setting_measurements VARCHAR2(2) District X X X X X X X DIST Text 2  
G compartment_no nrv_setting_measurements VARCHAR2(10) Compartment X X X X X X X COMP Text 10  
H       Stand X X X X X X X STAN Text 4  
I measurement_date nrv_setting_measurements DATE Date (MMYYYY) X X X X X X X DDATE Text 6  
J purpose_code nrv_setting_measurements VARCHAR2(4) Inventory Type X X X X X X X INVT Text 4  
K site_index_method & site_index nrv_site_indexes VARCHAR2(2) & VARCHAR2(4,1) R5 Dunning Site Class X X X X X X X SITE Text 42  
L aspect nrv_fia_mapped_conditions NUMBER(3) Aspect X X X X X X X ASPC Text 3  
M slope nrv_fia_mapped_conditions NUMBER(3) Slope X X X X X X X SLOP Text 3  
N elevation nrv_setting_measurements NUMBER(6,1) Elevation X X X X X X X ELEV Number Decimal(6,1)  
O structure nrv_setting_measurements VARCHAR2(2) Stand Structure X X X X X X X STRC Text 2  
P hist fsveg_hist_v VARCHAR2(6) Stand History X X X X X X X HIST Text 6  
Q hsdt fsveg_hist_v DATE History Date X X X X X X X HSDT Text 4  
R accr fsveg_hist_v VARCHAR2(5) Estimated # # # # # # # DACC Text 5  
S pv_code nrv_setting_measurements VARCHAR2(10) Ecosystem Type O O O O O O O ECOT Text 10  
T lifeform_code nrv_cover_measurements VARCHAR2(2) Lifeform X X X X X X X LFRM Text 2  
U data_code_2 nrv_cover_measurements VARCHAR2(10) Veg Record Type X X X X X X X TRID Text 10  
V level_2_id nrv_setting_measurements VARCHAR2(10) Point X X X X X X X POIN Text 10 6
W item_count nrv_cover_measurements NUMBER(3) Number of Stems O O O O O     NCNT Number Decimal(3,0)  
X sample_expansion_factor nrv_sample_designs NUMBER(9,4) Factor (BAF/Size) X X X X X X X FACT Number Decimal(9,4)  
Y species_symbol nrv_cover_measurements VARCHAR2(8) Species X X X X X     SPEC Text 8  
Z surface_cover_code nrv_cover_measurements VARCHAR2(4) Surface Cover           X   SRFC Text 4  
AA growth_form nrv_cover_measurements VARCHAR2(2) Growth Form X X           GFRM Text 2  
AB data_code_1 nrv_cover_measurements VARCHAR2(10) Special Features             X SPFE Text 10  
AC layer_code_local nrv_cover_measurements VARCHAR2(2) Cover layer (1-6) X X X X X X X R5TC Text 2  
AD subgroup_code nrv_cover_measurements VARCHAR2(4) Optional Veg Class O O O O O     OPTC Text 4  
AE cover_percent nrv_cover_measurements NUMBER(6,3) Percent Cover X X X X X X   COVR Number Decimal(6,3)  
AF height nrv_cover_measurements NUMBER(7,4) Height in Feet X X X X X X   HEIG Number Decimal(7,4)  
AG spa_equiv nrv_cover_measurements NUMBER(10,5) Number of Trees Per Acre O O O O O     NTPA Number Decimal(10,5)  
AH plots_installed fsveg_plotcnts_v VARCHAR2(30) Points Per Condition Plot X X X X X X X PCLU Number Double  
AI plots_installed fsveg_plotcnts_v VARCHAR2(30) Points Per Stand X X X X X X X PSTA Number Double  
AJ plots_installed fsveg_plotcnts_v VARCHAR2(30) Points Per Stratum X X X X X X X PSTR Number Double  
AK plots_installed fsveg_plotcnts_v VARCHAR2(30) Condition Plots Per Stratum X X X X X X X CSTR Number Double  
AL gis_link nrv_setting_measurements VARCHAR2(26) Unique ID Between FSVeg Settings and GIS Layer Plot Location X X X X X X X GIS_LINK Text 26  
AM project_name nrv_setting_measurements VARCHAR2(25) Inventory Project X X X X X X X PROJECT_NAME Text 25  
AN       Unique ID X X X X X X X FLD_ID Number Long Integer  


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:55 EDT


USDA logo which links to the department's national site. Forest Service logo which links to the agency's national site.