20260325
16383000
1.0
FALSE
OZARKNF_STANDS
002
365011.859700
721758.226900
3827736.784900
4009731.562400
1
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_UTM_Zone_15N
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.5.0'><WKT>PROJCS["NAD_1983_UTM_Zone_15N",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-93.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26915]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>26915</WKID><LatestWKID>26915</LatestWKID></ProjectedCoordinateSystem>
20260312
09415100
20260312
09415100
ISO 19139 Metadata Implementation Specification
150000000
5000
FGDC
Esri ArcGIS 13.5.2.57366
OZARKNF_STANDS
2014-04-02T00:00:00
USDA Forest Service, Ozark-St. Francis NFs
USDA Forest Service
Tammy Hocut
GIS Coordinator
605 West Main Street
Russellville
AR
72801
thocut@fs.fed.us
US
479-964-7211
479-964-7285
0800-1630
USDA Forest Service
USDA Forest Service
1
-94.501933
-90.533277
36.232455
34.567496
publication date
2014-04-02
Ozark-St. Francis NFs use these existing vegetation areas for inventory and management the land and timber resources.
Vegetation polygons support Forest Service vegetation data management and analysis. Vegetation data is critical in support of land management; whether it be for wildlife habitat analysis, fire and fuels management, watershed management, or timber production. A vegetation polygon is a logical sampling unit; a logical area of land on which to describe vegetation conditions. Over time, data is collected for some or all of these polygons. Data such as canopy cover or forest type may be derived for each polygon via satellite image processing or photo interpretation. Field crews may be sent to a selection of polygons to collect detailed data where individual trees are measured or down woody material is measured along transects. The amount and currency of data describing each vegetation polygon varies widely since it is cost-prohibitive to maintain detailed and current data for all polygons at any point in time. Data for some polygons may be more than 10 years old, while data for other polygons may have been collected yesterday. Typically where active project work or landscape analysis is occurring, better data is available since there is a need for good data for that area at that point in time. Data for polygons within the NRIS_VegPoly feature class is changing on a daily basis as data is updated by Forest Service staff. This feature class is a "working" dataset; that is, it supports day-to-day Forest Service land management.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Ozark - St. Francis National Forests stand inventory data for vegetation, maintained in polygon format. Polygon boundaries that provide areas to be rotated for entry of timber inventory and management. Stand is defined as a spatially continuous group of trees and associated vegetation having similar structures and growing under similar soil and climatic conditions.</SPAN></P><P><SPAN>Vegetation polygons support Forest Service vegetation data management and analysis. Vegetation data is critical in support of land management; whether it be for wildlife habitat analysis, fire and fuels management, watershed management, or timber production. A vegetation polygon is a logical sampling unit; a logical area of land on which to describe vegetation conditions. Over time, data is collected for some or all of these polygons. Data such as canopy cover or forest type may be derived for each polygon via satellite image processing or photo interpretation. Field crews may be sent to a selection of polygons to collect detailed data where individual trees are measured or down woody material is measured along transects. The amount and currency of data describing each vegetation polygon varies widely since it is cost-prohibitive to maintain detailed and current data for all polygons at any point in time. Data for some polygons may be more than 10 years old, while data for other polygons may have been collected yesterday. Typically where active project work or landscape analysis is occurring, better data is available since there is a need for good data for that area at that point in time. Data for polygons within the NRIS_VegPoly feature class is changing on a daily basis as data is updated by Forest Service staff. This feature class is a "working" dataset; that is, it supports day-to-day Forest Service land management.</SPAN></P><P><SPAN /><SPAN /></P></DIV></DIV></DIV>
Tree
Wood
All Forest Service lands
Inventory
Vegetation
Stand
Land cover
United States Department of Agriculture (USDA) - Forest Service (FS), National Forest System (NFS)
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN><SPAN>Data is typically intended for analysis and use at scales of 1:24,000 or smaller and in contextual conjunction with other thematic spatial and tabular data from other sources and sensors. These sources and sensors include: hydrography, elevation, aerial photos, satellite imagery, surface land ownership, etc. collected for use at comparable scales.</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV>
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN><SPAN>No formal tests or sampling procedures for detecting erroneous data have been applied. </SPAN></SPAN></P><P><SPAN /><SPAN /></P><P><SPAN><SPAN>Proclaimed forest boundaries were established by Congress. Within those boundaries, vegetation polygons will be delineated for all forest service administered lands and some private lands, because the private lands are intermingled with forest service land. Locations represent collections of these delineated polygons. Within each location, there will be no gaps; all land within each location falls within a delineated vegetation polygon. Note that vegetation polygons, as well as other features managed by FSVeg Spatial, are not meant to represent official or legal land boundaries. The features managed by FSVeg Spatial are meant to support vegetation management exercises; that is, data analysis of the landscape. To that extent, it is not important that the polygons represent exact ownership boundaries or exclude or include all private lands. Other feature classes can be brought in or overlaid to clip analysis areas to needed boundaries if necessary.</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV>
Enterprise Geodatabase Feature Class
ArcGIS
dataset
EPSG
6.11(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
OZARKNF_STANDS
Feature Class
0
Stand Vegetation Layer
Southern Region Silviculture Examination and Prescription Field Book and http://www.fs.fed.us/emc/nris/ftp/fsveg/cse_user_guides/R8_appendix.doc - for attribute definitions
OBJECTID
objectid
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
SPATIAL_ID
SPATIAL_ID
String
255
0
0
Internal Feature number
ESRI
STAND_ID
STAND_ID
String
255
0
0
POLY_ID
POLY_ID
Integer
4
10
0
REGION_ADMIN
REGION_ADMIN
String
255
0
0
FOREST_ADMIN
FOREST_ADMIN
String
255
0
0
DISTRICT_NO
DISTRICT_NO
String
255
0
0
REGION_PROC
REGION_PROC
String
255
0
0
FOREST_PROC
FOREST_PROC
String
255
0
0
LOCATION
LOCATION
String
255
0
0
SETTING_ID
SETTING_ID
String
255
0
0
NUM_EXAMS
NUM_EXAMS
Integer
4
10
0
USGS_ANDERSON_1
USGS_ANDERSON_1
String
255
0
0
USGS_ANDERSON_2
USGS_ANDERSON_2
String
255
0
0
ACRES_MANUAL
ACRES_MANUAL
Double
8
38
8
ACRES
ACRES
Double
8
38
8
AGENCY
AGENCY
String
255
0
0
SLOPE_POSITION
SLOPE_POSITION
String
255
0
0
SLOPE_SHAPE_VERT
SLOPE_SHAPE_VERT
String
255
0
0
TREE_HEIGHT_AVG
TREE_HEIGHT_AVG
Double
8
38
8
CANOPY_CLOSURE_TREES
CANOPY_CLOSURE_TREES
Integer
4
10
0
STAND_CONDITION_REF
STAND_CONDITION_REF
String
255
0
0
STAND_CONDITION_CODE
STAND_CONDITION_CODE
String
255
0
0
STAND_COND_DESC
STAND_COND_DESC
String
255
0
0
SAMPLE_DATE
SAMPLE_DATE
Date
8
0
0
EV_REF_CODE
EV_REF_CODE
String
255
0
0
EV_CODE
EV_CODE
String
255
0
0
EV_NAME
EV_NAME
String
255
0
0
PV_REF_CODE
PV_REF_CODE
String
255
0
0
PV_CODE
PV_CODE
String
255
0
0
PV_NAME
PV_NAME
String
255
0
0
PAG_REF
PAG_REF
String
255
0
0
PAG_CODE
PAG_CODE
String
255
0
0
SITE_INDEX_SPP
SITE_INDEX_SPP
String
255
0
0
SITE_INDEX
SITE_INDEX
Double
8
38
8
YEAR_OF_ORIGIN
YEAR_OF_ORIGIN
Integer
4
10
0
STAND_AGE
STAND_AGE
Double
8
38
8
NFS_LAND_CLASS
NFS_LAND_CLASS
String
255
0
0
DBH
DBH
Double
8
38
8
TPA
TPA
Double
8
38
8
SETTING_ORIGIN
SETTING_ORIGIN
String
255
0
0
SETTING_ORIGIN_DESC
SETTING_ORIGIN_DESC
String
255
0
0
TREE_LAYER_STRUCTURE
TREE_LAYER_STRUCTURE
String
255
0
0
STOCKING_PERCENT
STOCKING_PERCENT
Integer
4
10
0
MANAGEMENT_PRODUCTIVITY
MANAGEMENT_PRODUCTIVITY
Integer
4
10
0
PURPOSE_CODE
PURPOSE_CODE
String
255
0
0
MERCH_CUBIC_GROSS
MERCH_CUBIC_GROSS
Double
8
38
8
EXAM_SAMPLE_AGE
EXAM_SAMPLE_AGE
Double
8
38
8
BA_HP
BA_HP
Double
8
38
8
BA_HS
BA_HS
Double
8
38
8
BA_PP
BA_PP
Double
8
38
8
BA_PS
BA_PS
Double
8
38
8
SUBPOP_BA_TOTAL
SUBPOP_BA_TOTAL
Double
8
38
8
STAND_BA
STAND_BA
Double
8
38
8
DBH_HP
DBH_HP
Double
8
38
8
DBH_HS
DBH_HS
Double
8
38
8
DBH_PP
DBH_PP
Double
8
38
8
DBH_PS
DBH_PS
Double
8
38
8
FIRE_REGIME
FIRE_REGIME
Integer
4
10
0
CONDITION_CLASS
CONDITION_CLASS
Integer
4
10
0
CROWNING_INDEX
CROWNING_INDEX
Integer
4
10
0
CROWN_FIRE
CROWN_FIRE
String
255
0
0
DOWN_WOODY
DOWN_WOODY
Double
8
38
8
DUFF_LITTER_DEPTH
DUFF_LITTER_DEPTH
Double
8
38
8
FUEL_DEPTH
FUEL_DEPTH
Double
8
38
8
FUEL_PHOTO_REFERENCE
FUEL_PHOTO_REFERENCE
String
255
0
0
RESIDUE_DESC_CODE
RESIDUE_DESC_CODE
String
255
0
0
HAZ_RATING
HAZ_RATING
String
255
0
0
ELEVATION_FEET
ELEVATION_FEET
Integer
4
10
0
SLOPE_PERCENT
SLOPE_PERCENT
Integer
4
10
0
REMARKS
REMARKS
String
255
0
0
SAMPLE_RECORDER
SAMPLE_RECORDER
String
255
0
0
BA_YEAR
BA_YEAR
Double
8
38
8
LAND_CLASS_LOCAL_QUAL
LAND_CLASS_LOCAL_QUAL
String
255
0
0
OLD_GROWTH
OLD_GROWTH
String
255
0
0
PREV_FOR_TYPE
PREV_FOR_TYPE
String
255
0
0
UEAM
UEAM
String
255
0
0
FOR_TYPE
FOR_TYPE
String
255
0
0
RX_AREA
RX_AREA
String
255
0
0
WORKING_GROUP
WORKING_GROUP
String
255
0
0
POLY_TO_FSVEG
POLY_TO_FSVEG
String
255
0
0
MODIFIED_DATE
MODIFIED_DATE
Date
8
0
0
st_area(shape)
st_area(shape)
Double
0
0
0
st_length(shape)
st_length(shape)
Double
0
0
0
20260312
Geospatial Interface Visualization: HelpId: 690
DistributedIndicator: N
ProcessId: c2a0e888-237a-40bf-9792-4ff248aa7f85
ProcessName: FSVeg-Sp R08 Extract Vegetation Polygons RSW
OwnerName: R8_REGION 8
Registry: REGION 08
ProcessType: Visualization
Purpose: Extracts a local copy of the vegetation polygons and includes associated vegetation data of interest to Region 8.
Edited 22 Feb 2012 to reflect changes in underlying tables, and further edited on 28 Feb 2012 to remove duplicate records caused by unarchived inventory polygons.
Edited 14 Nov 2013 to add Subpop_BA_Total column that sums BA of four subpopulations.
Contact: NRM FSVeg Spatial Staff
Author: Delvin Bunton (built based on R8 requirements)
PreRequisites: None. Works off of FSVeg Spatial data that should exist for every R8 forest.
Results: A local copy of veg polys with the following data attached. The name is parenthesis identifies the approved source view. Note that data from the Nris_VegSubpopulations table is denormalized and place in the main output table along with other vegetation data of interest to R8.
spatial_id (vegpoly)
stand_id (calc from vegpoly)
poly_id (vegpoly)
region_admin (vegpoly)
forest_admin (vegpoly)
district_no (vegpoly)
region_proc (vegpoly)
forest_proc (vegpoly)
location (vegpoly)
setting_id (vegpoly)
num_exams (vegpoly)
USGS_anderson_1 (vegpoly)
USGS_anderson_2 (vegpoly)
acres_manual (vegpoly)
acres (vegpoly)
agency (vegpoly)
slope_position (vegcharacterizations)
slope_shape_vert (vegcharacterizations)
tree_height_avg (vegcharacterizations)
canopy_closure_trees (vegcharacterizations)
stand_condition_ref (vegcharacterizations)
stand_condition_code (vegcharacterizations)
stand_cond_desc (vegcharacterizations)
sample_date (vegpoly)
ev_ref_code (vegpoly)
ev_code (vegpoly)
ev_name (nrv_ev_cover_types)
pv_ref_code (vegpoly)
pv_code (vegpoly)
pv_name (nrv_pv_cover_types)
pag_ref (vegcharacterizations)
pag_code (vegcharacterizations)
site_index_spp (vegcharacterizations)
site_index (vegcharacterizations)
year_of_origin (vegcharacterizations)
stand_age (calc from vegcharacterizations)
nfs_land_class (vegcharacterizations)
dbh (vegcharacterizations)
tpa (vegcharacterizations)
tree_layer_structure (vegcharacterizations)
stocking_percent (vegcharacterizations)
management_productivity (vegcharacterizations)
purpose_code (vegpoly)
merch_cubic_gross (vegcharacterizations)
exam_sample_age (calc from vegpoly)
ba_hp (vegsubpopulations)
ba_hs (vegsubpopulations)
ba_pp (vegsubpopulations)
ba_ps (vegsubpopulations)
subpop_ba_total (vegsubpopulations)
stand_ba (vegcharacterizations)
dbh_hp (vegsubpopulations)
dbh_hs (vegsubpopulations)
dbh_pp (vegsubpopulations)
dbh_ps (vegsubpopulations)
fire_regime (vegcharacterizations)
condition_class (vegcharacterizations)
crowning_index (vegcharacterizations)
crown_fire (vegcharacterizations)
down_woody (vegcharacterizations)
duff_litter_depth (vegcharacterizations)
fuel_depth (vegcharacterizations)
fuel_photo_reference (vegcharacterizations)
residue_desc_code (vegcharacterizations)
haz_rating (vegcharacterizations)
aspect_degrees (veggiscalcs)
elevation_feet (veggiscalcs)
slope_percent (veggiscalcs)
remarks (vegcharacterizations)
BA_YEAR (vegpolylocal)
LAND_CLASS_LOCAL_QUAL (vegpolylocal)
OLD_GROWTH (vegpolylocal)
PREV_FOR_TYPE (vegpolylocal)
UEAM (vegpolylocal)
working_group (calc from vegpoly)
Poly_to_FSVeg (setting_measurements)
modified_date (vegpoly)
DetailsUrl: http://fsweb.nris.fs.fed.us/products/FSVeg_Spatial/documentation.shtml
StandardsUrl: Contact: R8_REGION 8
CreatedBy: CreatedDate: 9/21/2009 12:51:17 PM
ModifiedBy: DBUNTON
ModifiedDate: 11/14/2013 4:06:32 PM
Assigned Keywords: Timber
Vegetation
FSVeg-Sp R08 Extract Vegetation Polygons RSW
publication date
2014-04-02
Each Forest-extent could consist of spatial features captured from a variety of sources, including but not limited to: aerial photographs, digital orthophotography, multi-spectral satellite imagery, global positioning system coordinates, digitized polygons from hardcopy maps, etc
Process Step for FSVeg-Sp R08 Extract Vegetation Polygons RSW: Step Name: FSVeg-Sp R08 Extract Vegetation Polygons
Step Type: RSW
Sequence: 1
Required: True
Minimum Inputs: 2
Is Distributed: N
Help ID: 290
Output Feature Template: FSVegSpR08ExtractVegetationPolygonsRSW
Do not prompt user for selection: True
Each run has own output: False
Input Feature Template: FSVeg-Sp Vegetation Polygons
Feature Include Fields: (None)
Feature Join Field: SPATIAL_ID
Query Join Field: SPATIAL_ID
Dyn Seg Mode: None
Join Cardinality: OneToMany
Is Outer Join: False
Rt Bmp: Rt Emp: Query Name: R8_REGION 8 qryRswFSVegSpR08ExtractVegetationPolygons
SQL: select vp.spatial_id,
vu.region_admin || vu.forest_admin || vp.district_no || vp.location ||
lpad(to_char(vp.poly_id), 3, '0') stand_id,
vp.poly_id,
vu.region_admin,
vu.forest_admin,
vp.district_no,
vp.region_proc,
vp.forest_proc,
vp.location,
vp.setting_id,
vp.num_exams,
vp.Usgs_anderson_1,
vp.Usgs_anderson_2,
vp.acres_manual,
vp.acres,
vp.agency,
vc.slope_position,
vc.slope_shape_vert,
vc.tree_height_avg,
vc.canopy_closure_trees,
vc.stand_condition_ref,
vc.stand_condition_code,
sd.stand_cond_desc,
vp.sample_date,
vc.ev_ref_code,
vc.ev_code,
ev.common_name ev_name,
vc.pv_ref_code,
vc.pv_code,
pv.common_name pv_name,
vc.pag_ref,
vc.pag_code,
vc.site_index_spp,
vc.site_index,
vc.year_of_origin,
to_number(to_char(sysdate, 'YYYY')) - vc.year_of_origin stand_age,
vc.nfs_land_class,
vc.dbh,
vc.tpa,
vc.setting_origin,
case vc.setting_origin
when null then 'Unknown'
when '1' then 'Nat veg-no artif regen'
when '2' then 'Artif regen < 40 pct'
when '3' then 'Artif regen 40 pct+'
when '4' then 'Recent harvest-no regen'
when '5' then 'Artif regen-pct not est'
when '7' then 'Forest encroachment'
else 'Undefined' end setting_origin_desc,
vc.tree_layer_structure,
vc.stocking_percent,
vc.management_productivity,
vp.purpose_code,
vc.merch_cubic_gross,
case
when vp.sample_date is not null and
(to_number(to_char(sysdate, 'YYYY')) -
to_number(to_char(vp.sample_date, 'YYYY')) >= 0) then
to_number(to_char(sysdate, 'YYYY')) -
to_number(to_char(vp.sample_date, 'YYYY'))
else
null
end exam_sample_age,
vsp.ba_hp,
vsp.ba_hs,
vsp.ba_pp,
vsp.ba_ps,
vsp.subpop_ba_total,
vc.basal_area stand_ba,
vsp.dbh_hp,
vsp.dbh_hs,
vsp.dbh_pp,
vsp.dbh_ps,
vc.fire_regime,
vc.condition_class,
vc.crowning_index,
vc.crown_fire,
vc.down_woody,
vc.duff_litter_depth,
vc.fuel_depth,
vc.fuel_photo_reference,
vc.residue_desc_code,
vc.haz_rating,
vgc.elevation_feet,
vgc.slope_percent,
substr(vc.remarks, 1, 254) remarks,
vp.sample_recorder,
vpl.BA_YEAR,
vpl.LAND_CLASS_LOCAL_QUAL,
vpl.OLD_GROWTH,
vpl.PREV_FOR_TYPE,
vpl.UEAM,
vpl.FOR_TYPE,
vpl.RX_AREA,
case
when vc.ev_code < 3 then 'Non_forest'
when vc.ev_code between 3 and 7 then 'Pine'
when vc.ev_code between 8 and 20 then 'Pine_Hardwood'
when vc.ev_code between 21 and 39 then 'Pine'
when vc.ev_code between 40 and 49 then 'Hardwood_Pine'
when vc.ev_code between 50 and 89 then 'Hardwood'
when vc.ev_code = 90 then 'Non_forest'
when vc.ev_code between 91 and 99 then 'Hardwood'
else 'No_Data' end working_group,
case
when sm.setting_id is not null then 'Linked'
else 'Not Linked' end "Poly_to_FSVeg",
trunc(nvl(vp.modified_date,vp.created_date)) modified_date
from (select substr(p.value, 1, 2) region_admin, substr(p.value, 3, 2) forest_admin
from gi$currentSchema$.nris_veggdbinfo p where p.name = 'VpdUnitId') vu,
gi$currentSchema$.nris_vegpoly_aprv vp
left outer join gi$currentSchema$.nris_vegcharacterizations_aprv vc
on vp.spatial_id = vc.spatial_id
/*left outer join gi$currentSchema$.nris_vegpolylinks_aprv vpk
on vp.spatial_id = vpk.spatial_id */
left outer join gi$currentSchema$.nris_vegpolylocal_aprv vpl
on vp.spatial_id = vpl.SPATIAL_ID
left outer join gi$currentSchema$.nris_veggiscalcs_aprv vgc
on vp.spatial_id = vgc.spatial_id
left outer join (select distinct sm1.setting_id
from nrv_setting_measurements sm1
where sm1.setmeas_cn_of is null
and sm1.vpdunit_id =
(select substr(p2.value, 1, 4) vpdunit_id
from gi$currentSchema$.nris_veggdbinfo p2
where p2.name = 'VpdUnitId')
order by 1) sm
on vp.SETTING_ID = sm.setting_id
left outer join (select vpa.SPATIAL_ID,
vsphp.BASAL_AREA ba_hp,
vsphs.BASAL_AREA ba_hs,
vsppp.BASAL_AREA ba_pp,
vspps.BASAL_AREA ba_ps,
(nvl(vsphp.BASAL_AREA, 0) + nvl(vsphs.BASAL_AREA, 0) +
nvl(vsppp.BASAL_AREA, 0) + nvl(vspps.BASAL_AREA, 0)) subpop_ba_total, vsphp.diameter dbh_hp,
vsphs.diameter dbh_hs,
vsppp.diameter dbh_pp,
vspps.diameter dbh_ps
from gi$currentSchema$.nris_vegpoly_aprv vpa,
GI_GUI_SELECTION,
(select vhp.spatial_id, vhp.basal_area, vhp.diameter
from gi$currentSchema$.nris_vegsubpopulations_aprv vhp
where vhp.SUBGROUP_1 = 'R8 HARDWOOD POLE') vsphp,
(select vhs.spatial_id, vhs.basal_area, vhs.diameter
from gi$currentSchema$.nris_vegsubpopulations_aprv vhs
where vhs.SUBGROUP_1 = 'R8 HARDWOOD SAW') vsphs,
(select vpp.spatial_id, vpp.basal_area, vpp.diameter
from gi$currentSchema$.nris_vegsubpopulations_aprv vpp
where vpp.SUBGROUP_1 = 'R8 PINE POLE') vsppp,
(select vps.spatial_id, vps.basal_area, vps.diameter
from gi$currentSchema$.nris_vegsubpopulations_aprv vps
where vps.SUBGROUP_1 = 'R8 PINE SAW') vspps
where vpa.spatial_id = vsphp.spatial_id(+)
and vpa.spatial_id = vsphs.spatial_id(+)
and vpa.spatial_id = vsppp.spatial_id(+)
and vpa.spatial_id = vspps.spatial_id(+)
and gi_gui_selection.feature_cn = vpa.spatial_id
and runtime_layer_id = ?) vsp on vp.spatial_id = vsp.spatial_id
left outer join nrv_ev_cover_types ev
on (vc.ev_ref_code = ev.ref_code and vc.ev_code = ev.ev_code)
left outer join nrv_pv_cover_types pv
on (vc.pv_ref_code = pv.ref_code and vc.pv_code = pv.pv_code)
left outer join (select ref_code,domain_value stand_cond_code, value_description stand_cond_desc
from nrv_spatial_domain_vm where spatial_usage = 'STAND_CONDITION_REF' and code_column_name = 'STAND_CONDITION_CODE') sd
on (vc.stand_condition_ref = sd.ref_code and
vc.stand_condition_code = sd.stand_cond_code)
where 1 = 1
ORDER BY vp.spatial_id
Parameters (0):
2014-04-02T00:00:00
USDA Forest Service
Tammy Hocut
GIS Coordinator
605 West Main Street
Russellville
AR
72801
thocut@fs.fed.us
US
479-964-7211
479-964-7285
0800-1630
FSVeg-Sp R08 Extract Vegetation Polygons RSW
2014-04-15T00:00:00
FSVeg-Sp Vegetation Polygons
SERVER=iwebdb;INSTANCE=sde:oracle11g:iwebdb:sde_nris_veg;DBCLIENT=oracle;USER=FS_PUBLIC_READ;VERSION=NRV_SPATIAL_APP_USER.NRV_APPROVED_0810\S_R08_OZF.NRIS_Veg\S_R08_OZF.NRIS_VegPoly
publication date
2014-04-02
Resolved Query SQL: select vp.spatial_id, vu.region_admin || vu.forest_admin || vp.district_no || vp.location || lpad(to_char(vp.poly_id), 3, '0') stand_id, vp.poly_id, vu.region_admin, vu.forest_admin, vp.district_no, vp.region_proc, vp.forest_proc, vp.location, vp.setting_id, vp.num_exams, vp.Usgs_anderson_1, vp.Usgs_anderson_2, vp.acres_manual, vp.acres, vp.agency, vc.slope_position, vc.slope_shape_vert, vc.tree_height_avg, vc.canopy_closure_trees, vc.stand_condition_ref, vc.stand_condition_code, sd.stand_cond_desc, vp.sample_date, vc.ev_ref_code, vc.ev_code, ev.common_name ev_name, vc.pv_ref_code, vc.pv_code, pv.common_name pv_name, vc.pag_ref, vc.pag_code, vc.site_index_spp, vc.site_index, vc.year_of_origin, to_number(to_char(sysdate, 'YYYY')) - vc.year_of_origin stand_age, vc.nfs_land_class, vc.dbh, vc.tpa, vc.setting_origin, case vc.setting_origin when null then 'Unknown' when '1' then 'Nat veg-no artif regen' when '2' then 'Artif regen < 40 pct' when '3' then 'Artif regen 40 pct+' when '4' then 'Recent harvest-no regen' when '5' then 'Artif regen-pct not est' when '7' then 'Forest encroachment' else 'Undefined' end setting_origin_desc, vc.tree_layer_structure, vc.stocking_percent, vc.management_productivity, vp.purpose_code, vc.merch_cubic_gross, case when vp.sample_date is not null and (to_number(to_char(sysdate, 'YYYY')) - to_number(to_char(vp.sample_date, 'YYYY')) >= 0) then to_number(to_char(sysdate, 'YYYY')) - to_number(to_char(vp.sample_date, 'YYYY')) else null end exam_sample_age, vsp.ba_hp, vsp.ba_hs, vsp.ba_pp, vsp.ba_ps, vsp.subpop_ba_total, vc.basal_area stand_ba, vsp.dbh_hp, vsp.dbh_hs, vsp.dbh_pp, vsp.dbh_ps, vc.fire_regime, vc.condition_class, vc.crowning_index, vc.crown_fire, vc.down_woody, vc.duff_litter_depth, vc.fuel_depth, vc.fuel_photo_reference, vc.residue_desc_code, vc.haz_rating, vgc.elevation_feet, vgc.slope_percent, substr(vc.remarks, 1, 254) remarks, vp.sample_recorder, vpl.BA_YEAR, vpl.LAND_CLASS_LOCAL_QUAL, vpl.OLD_GROWTH, vpl.PREV_FOR_TYPE, vpl.UEAM, vpl.FOR_TYPE, vpl.RX_AREA, case when vc.ev_code < 3 then 'Non_forest' when vc.ev_code between 3 and 7 then 'Pine' when vc.ev_code between 8 and 20 then 'Pine_Hardwood' when vc.ev_code between 21 and 39 then 'Pine' when vc.ev_code between 40 and 49 then 'Hardwood_Pine' when vc.ev_code between 50 and 89 then 'Hardwood' when vc.ev_code = 90 then 'Non_forest' when vc.ev_code between 91 and 99 then 'Hardwood' else 'No_Data' end working_group, case when sm.setting_id is not null then 'Linked' else 'Not Linked' end "Poly_to_FSVeg", trunc(nvl(vp.modified_date,vp.created_date)) modified_date from (select substr(p.value, 1, 2) region_admin, substr(p.value, 3, 2) forest_admin from S_R08_OZF.nris_veggdbinfo p where p.name = 'VpdUnitId') vu, S_R08_OZF.nris_vegpoly_aprv vp left outer join S_R08_OZF.nris_vegcharacterizations_aprv vc on vp.spatial_id = vc.spatial_id /*left outer join S_R08_OZF.nris_vegpolylinks_aprv vpk on vp.spatial_id = vpk.spatial_id */ left outer join S_R08_OZF.nris_vegpolylocal_aprv vpl on vp.spatial_id = vpl.SPATIAL_ID left outer join S_R08_OZF.nris_veggiscalcs_aprv vgc on vp.spatial_id = vgc.spatial_id left outer join (select distinct sm1.setting_id from nrv_setting_measurements sm1 where sm1.setmeas_cn_of is null and sm1.vpdunit_id = (select substr(p2.value, 1, 4) vpdunit_id from S_R08_OZF.nris_veggdbinfo p2 where p2.name = 'VpdUnitId') order by 1) sm on vp.SETTING_ID = sm.setting_id left outer join (select vpa.SPATIAL_ID, vsphp.BASAL_AREA ba_hp, vsphs.BASAL_AREA ba_hs, vsppp.BASAL_AREA ba_pp, vspps.BASAL_AREA ba_ps, (nvl(vsphp.BASAL_AREA, 0) + nvl(vsphs.BASAL_AREA, 0) + nvl(vsppp.BASAL_AREA, 0) + nvl(vspps.BASAL_AREA, 0)) subpop_ba_total, vsphp.diameter dbh_hp, vsphs.diameter dbh_hs, vsppp.diameter dbh_pp, vspps.diameter dbh_ps from S_R08_OZF.nris_vegpoly_aprv vpa, GI_GUI_SELECTION, (select vhp.spatial_id, vhp.basal_area, vhp.diameter from S_R08_OZF.nris_vegsubpopulations_aprv vhp where vhp.SUBGROUP_1 = 'R8 HARDWOOD POLE') vsphp, (select vhs.spatial_id, vhs.basal_area, vhs.diameter from S_R08_OZF.nris_vegsubpopulations_aprv vhs where vhs.SUBGROUP_1 = 'R8 HARDWOOD SAW') vsphs, (select vpp.spatial_id, vpp.basal_area, vpp.diameter from S_R08_OZF.nris_vegsubpopulations_aprv vpp where vpp.SUBGROUP_1 = 'R8 PINE POLE') vsppp, (select vps.spatial_id, vps.basal_area, vps.diameter from S_R08_OZF.nris_vegsubpopulations_aprv vps where vps.SUBGROUP_1 = 'R8 PINE SAW') vspps where vpa.spatial_id = vsphp.spatial_id(+) and vpa.spatial_id = vsphs.spatial_id(+) and vpa.spatial_id = vsppp.spatial_id(+) and vpa.spatial_id = vspps.spatial_id(+) and gi_gui_selection.feature_cn = vpa.spatial_id and RUNTIME_LAYER_ID = '459812488') vsp on vp.spatial_id = vsp.spatial_id left outer join nrv_ev_cover_types ev on (vc.ev_ref_code = ev.ref_code and vc.ev_code = ev.ev_code) left outer join nrv_pv_cover_types pv on (vc.pv_ref_code = pv.ref_code and vc.pv_code = pv.pv_code) left outer join (select ref_code,domain_value stand_cond_code, value_description stand_cond_desc from nrv_spatial_domain_vm where spatial_usage = 'STAND_CONDITION_REF' and code_column_name = 'STAND_CONDITION_CODE') sd on (vc.stand_condition_ref = sd.ref_code and vc.stand_condition_code = sd.stand_cond_code) where 1 = 1 ORDER BY vp.spatial_id
R8_REGION 8 qryRswFSVegSpR08ExtractVegetationPolygons
publication date
2014-04-02
withheld
Tammy Hocut
USDA Forest Service, Ozark-St. Francis NFs
GIS Coordinator
605 West Main Street
Russellville
AR
72801
thocut@fs.fed.us
US
479-964-7211
479-964-7285
<DIV STYLE="text-align:Left;"><P STYLE="font-size:16ptmargin:7 0 7 0;"><SPAN><SPAN>Data is typically intended for analysis and use at scales of 1:24,000 or smaller and in contextual conjunction with other thematic spatial and tabular data from other sources and sensors. These sources and sensors include: hydrography, elevation, aerial photos, satellite imagery, surface land ownership, etc. collected for use at comparable scales.</SPAN></SPAN></P><DIV><P><SPAN /></P></DIV></DIV>