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 |
|
 |
|
Tree Output Format for a FSVEG_TXPT_V MSAccess table
Format of Output from FSVEG version 1.5
| Spreadsheet Column |
FSVeg | Description | R5 (Access Database) | |||||
|---|---|---|---|---|---|---|---|---|
| FSVeg Field Name |
FSVeg Table Name |
Field Type | R5 Abbrev. Field Name |
Data Type | Field Size | Sort Number |
||
| A | forest_admin | nrv_setting_measurements | VARCHAR2(2) | Forest | FOREST | Text | 2 | 1 |
| B | setting_id(3,1) | nrv_setting_measurements | VARCHAR2(1) | Planning Unit | PLAN | Text | 1 | 2 |
| C | stratum | nrv_setting_measurements | VARCHAR2(6) | Stratum | STRA | Text | 6 | 3 |
| D | setting_id(10,1) | nrv_setting_measurements | VARCHAR2(1) | Condition | SPLT | Text | 1 | 4 |
| E | level_1_id | nrv_setting_measurements | VARCHAR2(10) | Plot | PLOT | Text | 10 | 5 |
| F | district_no | nrv_setting_measurements | VARCHAR2(2) | District | DIST | Text | 2 | |
| G | compartment_no | nrv_setting_measurements | VARCHAR2(10) | Compartment | COMP | Text | 10 | |
| H | Stand | STAN | Text | 4 | ||||
| I | measurement_date | nrv_setting_measurements | DATE | Date (MMYYYY) | DDATE | Text | 6 | |
| J | purpose_code | nrv_setting_measurements | VARCHAR2(4) | Inventory Type | INVT | Text | 4 | |
| K | site_index_method & site_index | nrv_site_indexes | VARCHAR2(2) & VARCHAR2(4,1) | R5 Dunning Site Class | SITE | Text | 42 | |
| L | aspect | nrv_fia_mapped_conditions | NUMBER(3) | Aspect | ASPC | Text | 3 | |
| M | slope | nrv_fia_mapped_conditions | NUMBER(3) | Slope | SLOP | Text | 3 | |
| N | elevation | nrv_setting_measurements | NUMBER(6,1) | Elevation | ELEV | Number | Decimal(6,1) | |
| O | structure | nrv_setting_measurements | VARCHAR2(2) | Stand Structure | STRC | Text | 2 | |
| P | hist | fsveg_hist_v | VARCHAR2(6) | Stand History | HIST | Text | 6 | |
| Q | hsdt | fsveg_hist_v | DATE | History Date (YYYY) | HSDT | Text | 4 | |
| R | accr | fsveg_hist_v | VARCHAR2(5) | Estimated | DACC | Text | 5 | |
| S | pv_code | nrv_setting_measurements | VARCHAR2(10) | Ecosystem Type | ECOT | Text | 10 | |
| T | growth_sample_tree_flag | nrv_tree_measurements | VARCHAR2(1) | Indication (Y) of Tree Measured for Growth | TRID | Text | 1 | |
| U | level_2_id | nrv_setting_measurements | VARCHAR2(10) | Point | POIN | Text | 10 | 6 |
| V | tag_id | nrv_tree_measurements | VARCHAR2(5) | Unique Tree Number Per Point | TREE | Text | 5 | |
| W | tree_count | nrv_tree_measurements | NUMBER(4) | Tree Count | TCNT | Number | Double(4) | |
| X | selection_method_type | nrv_sample_designs | VARCHAR2(3) | Selection Type Method | FTYP | Text | 3 | |
| Y | sample_expansion_factor | nrv_sample_designs | NUMBER(9,4) | Factor (BAF/Size) | FACT | Number | Decimal(9,4) | |
| Z | species_symbol | nrv_tree_measurements | VARCHAR2(8) | Species | SPEC | Text | 8 | |
| AA | growth_form | nrv_tree_measurements | VARCHAR2(2) | Growth Form | GFRM | Text | 2 | |
| AB | lifeform_code | nrv_tree_measurements | VARCHAR2(2) | Lifeform | LFRM | Text | 2 | |
| AC | crown_class | nrv_tree_measurements | VARCHAR2(2) | Position | POSI | Text | 2 | |
| AD | crown_ratio | nrv_tree_measurements | NUMBER(3) | Crown Ratio Percent | CROW | Number | Double | |
| AE | category_code & severity_rating_code | nrv_tree_disturbances | VARCHAR2(2) & VARCHAR2(6) | Mistletoe | MIST | Text | 8 | |
| AF | category_code | nrv_tree_disturbances | VARCHAR2(2) | Disturbance Category | CTCD | Text | 2 | |
| AG | agent_code | nrv_tree_disturbances | VARCHAR2(3) | Agent | AGCD | Text | 3 | |
| AH | severity_rating_code | nrv_tree_disturbances | VARCHAR2(6) | Severity Rating | SRCD | Text | 6 | |
| AI | tree_part_code | nrv_tree_disturbances | VARCHAR2(2) | Tree Part | TPCD | Text | 2 | |
| AJ | log_decay_class | nrv_tree_measurements | VARCHAR2(2) | Log Decay | LDCL | Text | 2 | |
| AK | snag_decay_class | nrv_tree_measurements | VARCHAR2(2) | Snag Decay | SDCL | Text | 2 | |
| AL | live_dead | nrv_tree_measurements | VARCHAR2(1) | Live/Dead | LVDD | Text | 1 | |
| AM | data_code_2 | nrv_tree_measurements | VARCHAR2(10) | Death-defect, Decay | DEFE | Text | 10 | |
| AN | tree_class | nrv_tree_measurements | VARCHAR2(2) | R-5 Tree Class | R5TC | Text | 2 | |
| AO | recent_mortality_flag | nrv_tree_measurements | VARCHAR2(1) | Recent Mortality Flag | MRFL | Text | 1 | |
| AP | subgroup_code | nrv_tree_measurements | VARCHAR2(4) | Optional Tree Class | OPTC | Text | 4 | |
| AQ | diameter | nrv_tree_measurements | NUMBER(6,3) | Diameter | DBHI | Number | Double | |
| AR | diameter_height | nrv_tree_measurements | NUMBER(6,3) | Diameter Height | DIHT | Number | Double | |
| AS | height | nrv_tree_measurements | NUMBER(7,4) | Height in Feet, Log Length | HEIG | Number | Double | |
| AT | age | nrv_tree_measurements | NUMBER(4) | Age (Bored) | AGES | Number | Double | |
| AU | radial_growth_2 | nrv_tree_measurements | NUMBER(7,4) | 5 Yr. Diam. Growth in 10ths Inches | GRO1 | Number | Double | |
| AV | radial_growth | nrv_tree_measurements | NUMBER(7,4) | 10 Yr. Diam. Growth in 10ths Inches | GRO2 | Number | Double | |
| AW | height_growth | nrv_tree_measurements | NUMBER(7,4) | 5 Yr. Ht. Growth (DBH < 3 Inches) | HGRO | Number | Double | |
| AX | data_num_1 | nrv_tree_measurements | NUMBER(7,2) | Past DBH (10-Yr) | DBHP | Number | Double | |
| AY | data_num_2 | nrv_tree_measurements | NUMBER(7,2) | Predicted Past Height (10-Yr) | PAHT | Number | Double | |
| AZ | height | nrv_tree_measurements | NUMBER(7,4) | Predicted Current Height | PRHT | Number | Double | |
| BA | basal_area_equiv | nrv_tree_measurements | NUMBER(8,4) | Basal Area Per Acre | BASA | Number | Double | |
| BB | tpa_equiv | nrv_tree_measurements | NUMBER(10,5) | Number of Trees, Snags, or Logs Per Acre | NTPA | Number | Double | |
| BC | data_num_4 | nrv_tree_measurements | NUMBER(7,2) | BAG/A 10 Years | BAG2 | Number | Double | |
| BD | plots_installed | fsveg_plotcnts_v | VARCHAR2(30) | Points Per Condition Plot | PCLU | Number | Double | |
| BE | plots_installed | fsveg_plotcnts_v | VARCHAR2(30) | Points Per Stand | PSTA | Number | Double | |
| BF | plots_installed | fsveg_plotcnts_v | VARCHAR2(30) | Points Per Stratum | PSTR | Number | Double | |
| BG | plots_installed | fsveg_plotcnts_v | VARCHAR2(30) | Condition Plots Per Stratum | CSTR | Number | Double | |
| BH | data_num_3 | nrv_tree_measurements | NUMBER(7,2) | (Non MEAS+MEAS)/(MEAS) Trees | MEAS | Number | Double | |
| BI | industrial_flag | nrv_tree_measurements | VARCHAR2(1) | Industrial/NonIndustrial Flag | INDS | Text | 1 | |
| BJ | crown_width | nrv_tree_measurements | NUMBER(5,2) | Maximum Crown Width in Feet | CRWI | Number | Double | |
| BK | crown_length | nrv_tree_measurements | NUMBER(6,3) | Crown Length in Feet | CRLN | Number | Double | |
| BL | cullrough | nrv_tree_expansion_factors | NUMBER(2) | Percent Volume Loss Due to Missing Parts | CULLROUGH | Number | Decimal(2,0) | |
| BM | cullfld | nrv_tree_expansion_factors | NUMBER(2) | Percent Volume Loss Due to Rot | CULLFLD | Number | Decimal(2,0) | |
| BN | gis_link | nrv_setting_measurements | VARCHAR2(26) | Unique ID Between FSVeg Settings and GIS Layer Plot Location | GIS_LINK | Text | 26 | |
| BO | project_name | nrv_setting_measurements | VARCHAR2(25) | Inventory Project | PROJECT_NAME | Text | 25 | |
| BP | Unique ID | 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:53 EDT