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 |
|
 |
|
Subplot Setting Output Format for a FSVEG_CFRM_V MSAccess table
Format of Output from FSVEG version 1.5
| Spreadsheet Column |
FSVeg | Description | R5 (Access Database) | Source Documentation for Internal Use |
||||
|---|---|---|---|---|---|---|---|---|
| FSVeg Field Name |
FSVeg Table Name |
Field Type | R5 Abbrev. | Data Type | Field Size | |||
| A | Unique ID | FLD_ID | Number | Long Integer | Assigned in Access | |||
| B | project_name | nrv_setting_measurements | VARCHAR2(25) | Inventory Project | PROJECT_NAME | Text | 25 | User assigned by project area, inventory type, and year |
| C | purpose_code | nrv_setting_measurements | VARCHAR2(4) | Inventory Type | INVT | Text | 4 | User assigned to all cluster plots by project kind |
| D | data_code_2 | nrv_setting_measurements | VARCHAR2(16) | Existing Vegetation Map Source | MAP_INFO | Text | 16 | User assigned by project area, map version, and year |
| E | gis_link | nrv_setting_measurements | VARCHAR2(26) | Unique ID Between FSVeg Settings and GIS Layer Plot Location | GIS_LINK | Text | 26 | Inventory plot layer |
| F | state | nrv_setting_measurements | VARCHAR2(2) | 2 character abbreviation | STATE | Text | 2 | Get from NIMS project in FSVEG |
| G | county | nrv_setting_measurements | VARCHAR2(3) | 3-digit code | COUNTY | Text | 3 | Get from NIMS project in FSVEG |
| H | forest_admin | nrv_setting_measurements | VARCHAR2(2) | Forest | FOREST | Text | 2 | Inventory plot layer and tree files must match |
| I | data_num_2 | nrv_setting_measurements | NUMBER(7,2) | Availability for harvest | AVAIL_CLASS | Number | Decimal(7,2) | Wilderness and WSR layers |
| J | level_1_id | nrv_setting_measurements | VARCHAR2(10) | Plot | PLOT | Text | 10 | Inventory plot layer and tree files must match |
| K | setting_id(10,1) | nrv_setting_measurements | VARCHAR2(1) | Condition | SPLT | Text | 1 | Calculated based on unique map labels |
| L | site_index_method & site_index | nrv_site_indexes | VARCHAR2(2) & VARCHAR2(4,1) | R5 Dunning Site Class | SITE_CLASS | Text | 42 | Calculated from tree files or assigned by editor |
| M | setting_id(3,1) | nrv_setting_measurements | VARCHAR2(1) | Planning Unit | PLAN | Text | 1 | PU layer & calculation |
| N | stratum | nrv_setting_measurements | VARCHAR2(6) | Stratum | STRA | Text | 6 | Calculated based on stratification logic and software |
| O | level_2_id | nrv_setting_measurements | VARCHAR2(10) | Point | POIN | Text | 10 | Cluster plot / point numbers from tree files |
| P | data_code_1_definition(1,1) | nrv_setting_measurements | VARCHAR2(1) | Anderson Land Use Land Cover | USGS_ANDERSON_1 | Text | 1 | Existing veg map |
| Q | data_code_1_definition(3,1) | nrv_setting_measurements | VARCHAR2(1) | FGDC Physiognomic Division | PHYSIOGNOMIC_DIVISION | Text | 1 | Existing veg map |
| R | data_code_1_definition(5,1) | nrv_setting_measurements | VARCHAR2(1) | FGDC Physiognomic Order | PHYSIOGNOMIC_ORDER | Text | 1 | Existing veg map |
| S | data_code_1_definition(7,2) | nrv_setting_measurements | VARCHAR2(2) | FGDC Physiognomic Class | PHYSIOGNOMIC_CLASS | Text | 2 | Existing veg map |
| T | data_code_1_definition(10,2) | nrv_setting_measurements | VARCHAR2(2) | FGDC Physiognomic Subclass | PHYSIOGNOMIC_SUBCLASS | Text | 2 | Existing veg map |
| U | data_code_1_definition(13,2) | nrv_setting_measurements | VARCHAR2(2) | Primary Calveg Type | REGIONAL_DOMINANCE_TYPE_1 | Text | 2 | Existing veg map |
| V | data_code_1_definition(16,2) | nrv_setting_measurements | VARCHAR2(2) | Total cover from above | TREE_CFA_CLASS_1 | Text | 2 | Existing veg map |
| W | data_code_1_definition(19,2) | nrv_setting_measurements | VARCHAR2(2) | Overstory Tree Diameter Class 1 | OS_TREE_DIAMETER_1 | Text | 2 | Existing veg map |
| X | data_code_1_definition(22,4) | nrv_setting_measurements | VARCHAR2(4) | Stand Origin | ORIGIN_YEAR | Text | 4 | Existing veg map |
| Y | data_code_1_definition(27,2) | nrv_setting_measurements | VARCHAR2(2) | Reforestation Status | REFORESTATION_STATUS | Text | 2 | Existing veg map |
| Z | data_code_1_definition(30,1) | nrv_setting_measurements | VARCHAR2(1) | Forestland Productivity | PROD | Text | 1 | Existing veg map |
| AA | data_code_1_definition(32,2) | nrv_setting_measurements | VARCHAR2(2) | Secondary Calveg Type | REGIONAL_DOMINANCE_TYPE_2 | Text | 2 | Existing veg map |
| AB | data_code_1_definition(35,2) | nrv_setting_measurements | VARCHAR2(2) | Overstory Tree Diameter Class 2 | OS_TREE_DIAMETER_2 | Text | 2 | Existing veg map |
| AC | data_code_1_definition(38,3) | nrv_setting_measurements | VARCHAR2(3) | Lifeform | COVERTYPE | Text | 3 | Existing veg map |
| AD | data_code_1_definition(42,2) | nrv_setting_measurements | VARCHAR2(2) | Conifer Cover From Above | CON_CFA | Text | 2 | Existing veg map |
| AE | data_code_1_definition(45,2) | nrv_setting_measurements | VARCHAR2(2) | Hardwood Cover From Above | HDW_CFA | Text | 2 | Existing veg map |
| EF | data_code_1_definition(48,2) | nrv_setting_measurements | VARCHAR2(2) | Shrub Cover From Above | SHB_CFA | Text | 2 | Existing veg map |
| EG | data_code_1_definition(51,2) | nrv_setting_measurements | VARCHAR2(2) | Herbaceous Cover From Above | HEB_CFA | Text | 2 | Existing veg map |
| AH | data_code_1_definition(54,3) | nrv_setting_measurements | VARCHAR2(3) | WHR Vegetation Type | WHRTYPE | Text | 3 | Existing veg map |
| AI | data_code_1_definition(58,1) | nrv_setting_measurements | VARCHAR2(1) | WHR Tree Size | WHRSIZE | Text | 1 | Existing veg map |
| AJ | data_code_1_definition(60,1) | nrv_setting_measurements | VARCHAR2(1) | WHR Tree Density | WHRDENSITY | Text | 1 | Existing veg map |
| AK | data_code_1_definition(62,2) | nrv_setting_measurements | VARCHAR2(2) | Northwest Structure | NWSTRUCT | Text | 2 | Existing veg map |
| AL | data_code_1_definition(65,4) | nrv_setting_measurements | VARCHAR2(4) | CALVEG mapping tile | CALVEG_TILE | Text | 4 | Existing veg map |
| AM | data_code_1_definition(70,5) | nrv_setting_measurements | VARCHAR2(5) | Bailey's Ecological Section | ECOREGION_SECTION | Text | 5 | Existing veg map |
| AN | data_code_1_definition(76,1) | nrv_setting_measurements | VARCHAR2(1) | CALVEG classification zone | CALVEGZONE | Text | 1 | Existing veg map |
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:52 EDT