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
|