Timber
Stand Management Record System (TSMRS)
The
STANDS Table
The Timber Stand Management Record System (TSMRS)
provides managers at all levels in the Region with the information they need to
manage the timber resource.
The forest stand (as defined in Winters, Robert K.
(Ed.) 1977. Terminology of forest
science, technology, practice, and product.
2d ed. Society of American
Foresters, Wash. D.C. 349 p.), is the
basic unit that shall be used for record keeping. Other forest subdivisions are not acceptable for referencing
data. Stand size and shape may change,
but every stand number is unique. A new
stand can either be delineated where none was previously recognized or can be
defined as a smaller part of an existing stand or stands. By Regional definition, a stand cannot cross
State, congressional district, county, forest, district, compartment,
subcompartment, or deferred and reserved timber land use boundaries.
The automated portion of the stand record system is an Oracle database. It will allow access of past and present stand information. The following stands table consists of the Oracle field name, the Dbase view field name (DBF Name), whether or not the field must contain a value, and the type and size of the field. The DBF Name must be a maximum of ten characters in length in order to use it in creating a DBF file of a subset of the STANDS data.
NOTE: ‘ncm’ in the DBF Name field means ‘Not Currently Maintained’
MAIN TSMRS TABLE
stands (fsdba.tsmrs_fs_stands)
Name
DBF Name Null? Type
------------------------ ----------- -------- ------------
STAND_ID
STANDID NOT NULL VARCHAR2(8)
DISTRICT_NO ncm
NUMBER(1)
COMPARTMENT ncm NUMBER(2)
SUBCOMPARTMENT ncm NUMBER(2)
STAND ncm NUMBER(3)
FOREST_NO
FORESTNO NOT NULL NUMBER(2)
STATE_CODE
STATECODE NUMBER(2)
CONG_DIST_NO
CONGDIST NUMBER(1)
COUNTY_CODE
COUNTY NUMBER(3)
STAND_ACRES
ACRES NUMBER(4)
PERCENT_CAP_GROW
PCTCAPGROW NUMBER(3)
FOREST_TYPE_CODE
FORESTYPE VARCHAR2(3)
LANDTYPE_CODE
LANDTYPE VARCHAR2(5)
SPECIFIC_SOILS_CODE
SPECSOILS VARCHAR2(5)
GENERAL_SOILS_CODE
GENSOILS NUMBER(2)
SLOPE_PERCENT
SLOPEPCT NUMBER(2)
ASPECT_CODE
ASPECT VARCHAR2(2)
ELEVATION
ELEVATION NUMBER(3)
HABITAT_TYPE_CODE
HABTYPE NUMBER(3)
PROD_CLASS_CODE
PRODCLASS NUMBER(1)
LOGGING_SYSTEM_CODE ncm NUMBER(1)
SPEC_UNIT_KIND_CODE SPCUNITKND NUMBER(3)
SPEC_UNIT_CODE
SPCUNIT NUMBER(4)
CAPABILITY_AREA_CODE
CAPABAREA VARCHAR2(6)
LAND_CLASS_CODE
LANDCLASS NUMBER(3)
MANAGEMENT_AREA_CODE
MGTAREA VARCHAR2(5)
CONDITION_CLASS_CODE ncm NUMBER(1)
GROUND_STRATUM ncm VARCHAR2(6)
VISUAL_QUAL_OBJ_CODE
VISUALQUAL VARCHAR2(2)
TREATMENT_NEEDS_CODE
TREATNEEDS NUMBER(2)
SIZE_CLASS_CODE ncm VARCHAR2(4)
SIZE_CLASS_ORIGIN_YEAR ncm NUMBER(4)
FUEL_LOAD
FUELLOAD NUMBER(5)
WATERSHED_CODE ncm VARCHAR2(18)
SPECIAL_USE_CODE ncm NUMBER(2)
PI_STRATUM
PISTRATUM VARCHAR2(6)
PI_HABITAT_TYPE_CODE
PIHABITAT NUMBER(3)
PI_CROWN_CLOSURE
PICRNCLOSR NUMBER(2)
PI_ANNUAL_PRECIP ncm NUMBER(2)
PI_HARDWD_PERCENT ncm NUMBER(2)
PI_NONSTK_ROCK_PERCENT ncm NUMBER(2)
PI_HARV_METH_CODE ncm NUMBER(1)
PI_TOPO_POSITION_CODE ncm NUMBER(1)
PI_TRUE_UNDRSTRY_CODE ncm NUMBER(1)
PI_CONTOUR_CURV_CODE ncm NUMBER(1)
PI_EXAM_YEAR
PIEXAMYEAR NUMBER(4)
PI_OREG_SPECIES_CODE ncm VARCHAR2(2)
PI_OREG_CROWN_DIAM
PICRWNDIAM NUMBER(2)
PI_OREG_HEIGHT
PIHEIGHT NUMBER(3)
PI_OREG_TEXTURE_CODE ncm NUMBER(1)
PI_OREG_ORIGIN_YEAR ncm NUMBER(4)
PI_UREG_SPECIES_CODE ncm VARCHAR2(2)
PI_UREG_CROWN_DIAM ncm NUMBER(2)
PI_UREG_HEIGHT ncm NUMBER(3)
PI_UREG_TEXTURE_CODE ncm NUMBER(1)
PI_UREG_ORIGIN_YEAR ncm NUMBER(4)
TOWNSHIP
TOWNSHIP VARCHAR2(5)
RANGE
RANGE VARCHAR2(5)
SECTION
SECTION VARCHAR2(3)
OWNERSHIP
OWNER NOT NULL VARCHAR2(3)
UPDATE_DATE
UPDATEDATE DATE
In the following explanatory section, each field is
identified by its field name, followed by the DBF Name, and then explanatory
remarks. Links to additional
information are provided where inclusion of long code lists would make this
document to long and unwieldy.
Name
DBF Name
------------------------ -----------
STAND_ID
STANDID
The stand identification uniquely identifies
each record in the data base. The
concatenated eight-digit number is composed of District, Compartment, Subcompartment, and Stand
Number.
Example: 10203004
Code Element
1 District
02 Compartment
03 Subcompartment
004 Stand Number
CLEARWATER DISTRICT CODES:
Code District
---- --------
1 Pierce
2 Palouse
3 North Fork
5 Lochsa
6 Powell
COMPARTMENT ncm
The compartment the stand is located in.
Values 1-99.
SUBCOMPARTMENT ncm
The subcompartment the stand is located in.
Values 1-99.
STAND ncm
The number identifying the
individual stand within the compartment and
subcompartment. Values 1-999.
FOREST_NO
FORESTNO
The code for the National
Forest (administrative boundary) where the
stand is located.
Code Forest
02 Beaverhead
(Bvhd.) Note: The Beaverhead and Deerlodge
03 Bitterroot
(Btr.) National Forests
have been
04 Idaho Panhandle
(INPF) administratively
combined.
05 Clearwater
(Clr.) Forest numbers
currently
08 Custer (Cus.) remain the same. (2/2/96)
09 Deerlodge (Drlg.)
10 Flathead (Flt.)
11 Gallatin (Gal.)
12 Helena (Hlna.)
14 Kootenai (Koot.)
15 Lewis & Clark
(L&C)
16 Lolo (Lolo)
17 Nez Perce (Nez.)
STATE_CODE
STATECODE
The standard numeric code
for the State in which the stand is located.
Code State
16 Idaho
30 Montana
46 South Dakota
53 Washington
CONG_DIST_NO
CONGDIST
The standard code for the
congressional district in which the stand is
located. See a congressional district map for the
appropriate code.
Stands in Eastern Montana
should continue to be coded as congressional
district 2, even though
Montana currently has only one congressional
district.
Code Congressional District
---- ----------------------
1 Idaho
1 Montana (W)
2 Montana (E)
2 South Dakota
5 Washington
COUNTY_CODE
COUNTY Additional Info
The standard code for the
county in which the stand is located.
IDAHO
Code County Code
County
---- ----------- ---- ---------
009 Benewah 055
Kootenai
017 Bonner 057
Latah
021 Boundary 061 Lewis
035 Clearwater 069 Nez
Perce
049 Idaho 079
Shoshone
STAND_ACRES
ACRES
The total acres for the stand.
PERCENT_CAP_GROW
PCTCAPGROW Additional Info
Percent capable growing area is an estimate
of the percent of the stand area that is capable of growing trees. Exclude areas such as roads, creeks, swamps,
rock outcrops, and so forth. Area
exclusions of 1 acre or larger must be mapped on a stand diagram. In the case of mottled or mosaic exclusions
of less than an acre, enter your best estimate of the area capable of growing
trees. Use your professional judgment.
FOREST_TYPE_CODE
FORESTYPE Additional Info
The standard forest type
is based on plurality of tree numbers up to 5.0
inches dbh and on basal
area over 5.0 inches dbh. The average
dbh is
derived from the total
live component. The 0-1 dbh class is
not used in
the calculation of average
dbh for the total live component. If an
area
is nonstocked, enter the
forest type anticipated for the area in the
prescription. If there is no prescription, enter the last
forest type
which occupied the area.
LANDTYPE_CODE
LANDTYPE Additional
Info
Landtypes are map units on
soil maps. Each landtype has a unique
symbol and name. Forests supply their own codes for this field.
SPECIFIC_SOILS_CODE
SPECSOILS Additional Info
First digit: Order/suborder (1-character alpha code)
Second digit: Great group (1-character alpha code)
Third and fourth
digits: Subgroup (2-digit numeric code)
Fifth digit: Family (1-character alpha code)
GENERAL_SOILS_CODE
GENSOILS
The general soils code
that describes the depth and texture of the soil.
Code General Soils
---- ------------------------------
10 Soil depth more
than 18 inches
11 Silt or loam
12 Sandy
13 Gravelly
14 Rocky
20 Soil depth less than 18 inches
21 Silt or loam
22 Sandy
23 Gravelly
24 Rocky
SLOPE_PERCENT
SLOPEPCT
The average slope of the
major portion of the stand.
ASPECT_CODE
ASPECT
The average direction
toward which the stand slopes.
Code Aspect
---- -----------------
N North
NE Northeast
E East
SE Southeast
S South
SW Southwest
W West
NW Northwest
LR Level or Rolling
G Generic (Only use
when there is no predominant or average aspect.)
ELEVATION
ELEVATION
The elevation of the midpoint of the stand
expressed to the nearest 100 feet.
Code Actual Elevation
111 11,100 feet
065 6,500 feet
HABITAT_TYPE_CODE
HABTYPE Additional Info
The predominant habitat
type for the stand, as determined by the plurality of sample point habitat
types.
PROD_CLASS_CODE
PRODCLASS
Site trees and trees
identified as tree class 1 in the R1-Edit are used to calculate the
productivity class. Productivity class
is not applicable when the forest type is nonforest.
Code Productivity Class (Potential growth
expressed in
cu. ft./acre/year.)
1 225+
2 165-224
3 120-164
4 85-119
5 50- 84
6 20- 49
7 19 and less
LOGGING_SYSTEM_CODE
SPCUNITKND
Logging System is a
Regional expression of yarding feasible for the stand, based on allowable
practices or constraints as called for in the Forest Plan. The hierarchy is from the least restrictive
(all yarding methods satisfactory) to the most constraining.
Code Description
1 No restriction
2 Groundbase
3 Groundlead Cable
4 Short-span Skyline
(less than 2000 feet)
5 Long-span Skyline
(greater than or equal to 2000 feet)
6 Aerial
SPEC_UNIT_KIND_CODE
SPCUNIT Additional Info
This field identifies
timber land use data and timber resource data for areas that are managed for
special purposes, such as wilderness, national recreation areas, geological
areas, and so forth. Each Forest's
Forest Plan identifies the special unit kind for a given area.
SPEC_UNIT_CODE
ncm Additional Info
This field specifically
identifies which wilderness area, primitive area, national recreation area, and
so forth, the stand is located in.
CAPABILITY_AREA_CODE
CAPABAREA
Capability area represents
the geographic delineations used to describe characteristics of the land and
resources in integrated forest planning. Lands are delineated in capability
areas for the purpose of estimating their response to various management
practices, resource values, output
coefficients, and
multi-resource or joint projection functions. Capability areas may be
synonymous with ecological land units, ecosystems, habitats, stands, or land
response units.
LAND_CLASS_CODE
LANDCLASS Additional Info
Determining and reporting
of lands that are capable, suitable, and available is a requirement of the 1976
National Forest Management Act (36 CFR 219).
Present Forest Plan
outputs and land management activities are based on these land suitability
classifications.
This field serves two
purposes. An important part of future
land and resource management planning (Forest Plan) is to identify lands that
are tentatively suitable, not suitable or available, or not as a fixed input to
forest planning models to establish benchmarks and alternatives.
This field, in conjunction
with management area, allows each Forest to fulfill their National requirements
to report land suitability acres to the Chief and Congress. This is accomplished through the land
suitability class file in the Timber Activity Control System (TRACS) which is
part of the Timber Management Information System (TMIS). It also forms the basis for the land
classification table which appears in the Forest Plan appendix. Land Suitability Classification and
Management Area must be looked at together when running queries and reports for
suitable land.
(TRACS was formerly the
TMIS data base. TMIS will now consist
of all timber data bases such as TRACS, STARS (Sales Tracking and Reporting
System), TSA (Timber Sale Accounting), plus any new timber data bases developed.)
Management Area
definitions are located in each Forest Plan.
The Forest Plan Management Area is a numeric number on the Management
Area Map, and the map is in the Plan itself.
For Timber Management purposes, Management Area will be an alpha
code. This code describes the
management area direction, objective, goal(s), and prescriptions.
CONDITION_CLASS_CODE
ncm
Condition class is based
on Forest Survey classification in which desirable tree stocking is compared to
total stocking. (Stocking tables are
located in FSH 2409.17, Silvicultural Practices Handbook, Chapter 9.)
Condition class is a
classification of commercial forest land based upon stocking of desirable trees
and other conditions affecting current and prospective timber growth. It is the condition of the stockable area.
For example, a stand can be 15 percent nonstockable and still be a
condition class 1. (FSH 4809.11, Forest Survey Handbook,
Chapter 20.)
Code Condition Class Description
1 Areas fully stocked
with desirable trees and not overstocked.
2 Areas fully stocked
with desirable trees, but overstocked with
all live trees.
3 Areas medium to
fully stocked with desirable trees, and with
less than 30 percent of the area controlled by other
trees
and/or inhibiting vegetation or surface conditions that
will
prevent occupancy by desirable trees.
4 Areas medium to fully
stocked with desirable trees and with 30
percent or more of the area controlled by other trees
and/or
conditions that ordinarily prevent occupancy by desirable
trees.
5 Areas poorly
stocked with desirable trees, but fully stocked
with growing trees.
6 Areas poorly
stocked with desirable trees, but medium to full
stocking of growing stock trees.
7 Areas poorly
stocked with desirable trees, and poorly stocked
with growing stock trees.
(Growing stock trees are
defined as: live trees of commercial
species that meet specified standards for sawtimber or will likely meet such
standards when they reach sawtimber size and would be included in the allowable
sale quantity calculation. This
includes desirable and
acceptable crop trees.)
GROUND_STRATUM ncm
Ground truth stratum is the true stratum of the stand. If a field review reveals that the photo interpretation (PI) stratum was incorrectl identified, the Forest developed code for the true stratum is the entered in this field. The PI stratum code is never changed once it is identified, unless the entire area is restratified. See PI Stratum for the minimum strata requirements.
VISUAL_QUAL_OBJ_CODE
VISUALQUAL
See Agriculture Handbook
No. 462 for description of codes.
Code Visual Quality Objective
---- ------------------------
P Preservation
R Retention
PR Partial Retention
M Modification
MM Maximum
Modification
RH Rehabilitation
E Enhancement
TREATMENT_NEEDS_CODE
TREATNEEDS Additional Info
Stand treatment needs are determined during the diagnosis phase of the prescription process. When a stand examination is completed on forest land, a diagnosis should be done at the time Table 10 of the R1-Edit stand tables is checked (prior to crossing the stand over to the database). Stand treatment needs should be entered when the stand is crossed over to the data base. The stand treatment needs do not change until another examination is completed and a stand diagnosis is prepared. (See silvicultural prescription process, R-1 supplement to FSH 2409.17, Silvicultural Practices Handbook, Chapter 8. Diagnosis is no longer a separate activity, but it is required for activity 4334, Silviculture Prescription, credit.)
SIZE_CLASS_CODE
ncm Additional Info
A classification of forest lands based on
live trees in the stockable portion of the stand. The basic stand size classification can be further defined using
descriptive adjectives as shown under the acceptable code list.
SIZE_CLASS_ORIGIN_YEAR ncm
Birth date of the stand (year of stand
origin) or the stand component recognized in the stand size class element. For example, if a stand was planted in 1980,
1980 is entered as the stand size class year of origin and SEED is the stand
size class. When the stand size class
changes to SAPL in approximately 1994, stand size class year of origin remains
as 1980.
FUEL_LOAD
FUELLOAD
The first two digits of
the code are the actual tons per acre of fuel less than 3 inches in
diameter. The last three digits are the
actual tons per acre of fuel greater than 3 inches in diameter.
Code Description
05012 Means a total fuel load of 17 tons per
acre with 5 tons per acre
less than 3 inches in diameter and 12 tons per acre
greater than
3 inches in diameter.
WATERSHED_CODE ncm
Watershed codes must be formatted according
to the Water Resources Council (WRC) coding (See FSM 2513.2). Additional space is provided so Forests can
make a further breakdown or refinement of the watersheds. A copy of the Forest watershed codes must be
sent to Forest and Rangeland Management in the Regional Office.
SPECIAL_USE_CODE ncm
This field is used to recognize stands
identified for special management purposes.
Record the most significant "special use" identified for the
stand. (Old growth coding is generally
considered the most significant special use.)
PI_STRATUM
PISTRATUM Additional
Info
Each Forest will develop
their own strata that can be aggregated into the following categories. To maintain stratification consistency,
individual stand PI stratum should not be changed without reviewing the
stratification of the entire compartment.
Minimum Strata Requirements
Non-Forest| Forested
----------|----------------------------------------------------------
Water |Capable of
Producing Industrial |Not capable of
Producing
Land |Products, No
irreversible damage,|Industrial Products,
|and can be restocked within 5 |Irreversible Damage,
|years |or Not Restockable in 5
| Nonstocked |Years.
| Seedling and Saplings (.0-4.9") |
| Poles (5"-8.9") |
| Sawtimber (9"+) |
PI_HABITAT_TYPE_CODE
PIHABITAT
The habitat type
identified during photo interpretation, from habitat type maps, or from
discriminate analysis. Use the same
codes as shown with habitat type in the Basic Stand Data form.
PI_CROWN_CLOSURE
PICRNCLOSR
Crown closure is the
progressive reduction of space between crowns as they spread laterally,
increasing the canopy density.
PI_ANNUAL_PRECIP ncm
The inches of annual
precipitation for the stand, as identified on state-published precipitation
maps.
PI_HARDWD_PERCENT ncm
The photo interpreted percentage of the stand
area that is occupied by hardwoods.
PI_NONSTK_ROCK_PERCENT ncm
The photo interpreted percentage of the stand
area which is nonstocked because of rock.
PI_HARV_METH_CODE ncm
If the stand has been
harvested, the photo interpreted silviculture
harvest method (or the
actual harvest method if known).
Code Description
---- --------------------
1 Clearcut
2 Seed Tree Cut
3 Shelterwood Cut
4 Selection Cut
5 Commercial Thinning
PI_TOPO_POSITION_CODE ncm
The photo interpreted
topographic position of the stand.
Code Description
---- ----------------
1 Valley Bottom
2 Midslope Drain
3 Midslope
4 Midslope Ridge
5 Ridgetop
PI_TRUE_UNDRSTRY_CODE ncm
Enter a '1' if the stand truly has an
understory. Enter a '2' if the main
stand which is described by crown characteristics and so forth, has a scattered
overstory above the main stand.
PI_CONTOUR_CURV_CODE ncm
The photo interpreted
contour curvature of the stand.
PI_EXAM_YEAR
PIEXAMYEAR
The year of the photo interpretation exam.
PI_OREG_SPECIES_CODE ncm
The standard, alphabetic
species code for the overstory component.
The standard codes are listed with the major species field with the
stand component information. Two
additional codes that may be used are MC for mixed conifer, and HW for
unidentified or mixed hardwood.
PI_OREG_CROWN_DIAM
PICRWNDIAM
The photo interpreted mean crown diameter, in
feet.
PI_OREG_HEIGHT
PIHEIGHT
The photo estimated overstory height, in
feet.
PI_OREG_TEXTURE_CODE ncm
The photo estimated
texture of the overstory component.
Code Description
---- -------------
1 Fine
2 Medium Fine
3 Medium Coarse
4 Coarse
PI_OREG_ORIGIN_YEAR ncm
The calendar year of origin for the overstory
component. Year of origin may be know
from fire or treatment history.
`
PI_UREG_SPECIES_CODE ncm
The standard, alphabetic species code for the
understory component. The standard
codes are listed with the major species field with the stand component
data. Five additional codes may be
used: BR - brush, GR - grass, HW -
unknown or mixed hardwood, MC - mixed conifer, RK - Rock.
PI_UREG_CROWN_DIAM ncm
The photo estimated mean crown diameter in
feet for the understory component.
PI_UREG_HEIGHT ncm
The photo estimated understory height in
feet.
PI_UREG_TEXTURE_CODE ncm
The photo estimated
texture of the understory component.
Code Description
---- --------------
1 Fine
2 Medium Fine
3 Medium Coarse
4 Coarse
PI_UREG_ORIGIN_YEAR ncm
The calendar year of origin for the understory
component. Year of origin may be known
from fire or treatment history.
TOWNSHIP
TOWNSHIP
The township where the
stand is located. Example: T32N
RANGE
RANGE
The range where the stand
is located. Example: R26W
SECTION
SECTION
The section the stand is
located in. Example: S07, S15
OWNERSHIP
OWNER Additional Info
The ownership of the land where the stand is
located. FS (Forest Service) is
automatically entered for stands in the FS tables.
UPDATE_DATE
UPDATEDATE
Date this record was
updated.