| All live stocking |
C.ALSTKCD |
All live stocking code. A code indicating the stocking of the condition by live trees,\nincluding seedlings.<br>\nCode Description<br>\n1 Overstocked (100+ %)<br>\n2 Fully stocked (60 to 99%)<br>\n3 Medium stocked(35 to 59%)<br>\n4 Poorly stocked(10 to 34%)<br>\n5 Nonstocked(0 to 9%)<br>\nStocking: The degree of occupancy of land by trees, measured by basal area or number of trees by size and spacing, or both, compared to a stocking standard; that is, the basal area or number of trees, or both, required to fully utilize the growth potential of the land.<br> |
N |
case coalesce(cond.alstkcd,-1) when 1 then '`0001 Overstocked' when 2 then '`0002 Fully stocked' when 3 then '`0003 Medium stocked' when 4 then '`0004 Poorly stocked' when 5 then '`0005 Nonstocked' when -1 then '`0006 Unavailable' else '`0007 Other' end |
| AppalachianRegionARC |
P.COUNTYCD |
Appalachian Regional Commission Regions (1 Central, 2 North Central, 3 Northern, 4 South Central, 5 Southern)\nconsist of counties found in the following States:<br>\nAlabama,Georgia,Kentucky,Maryland,Missisippi,New York,North Carolina,Ohio,Pennsylvania,South Carolina,Tennessee,Virginia,West Virginia<br>\nAppalachian Regions can be identified by the State/County FIPS codes:<br>\ndecode(decode(plot.statecd*1000+plot.countycd,21001,1,21011,1,21013,1,21019,1,21025,1,21043,1,21045,1,21049,1,21051,1,21053,1,21057,\n1,21061,1,21063,1,21065,1,21069,1,21071,1,21079,1,21087,1,21089,1,21095,1,21099,1,21109,1,21115,1,21119,1,21121,1,21125,1,21127,1,21129,\n1,21131,1,21133,1,21135,1,21137,1,21147,1,21151,1,21153,1,21159,1,21165,1,21169,1,21171,1,21173,1,21175,1,21181,1,21189,1,21193,1,21195,\n1,21197,1,21199,1,21201,1,21203,1,21205,1,21207,1,21231,1,21235,1,21237,1,47001,1,47013,1,\n47025,1,47027,1,47049,1,\n47057,1,47067,1,47087,\n1,47111,1,47129,1,47133,1,47137,1,47151,1,47173,1,51027,1,51051,1,51105,1,51167,1,51169,1,51185,1,51195,1,54005,1,54043,1,54045,1,54047,\n1,54059,1,54099,1,54109,1,39001,2,39009,2,39015,2,39025,2,39053,2,39071,2,39073,2,39079,2,39087,2,39105,2,39111,2,39115,2,39121,2,39127,\n2,39131,2,39141,2,39145,2,39163,2,39167,2,54001,2,54003,2,54007,2,54011,2,54013,2,54015,2,54017,2,54019,2,54021,2,54023,2,54025,2,54027,\n2,54031,2,54033,2,54035,2,54037,2,54039,2,54041,2,54049,2,54053,2,54055,2,54057,2,54061,2,54063,2,54065,2,54067,2,54071,2,54073,2,54075,\n2,54077,2,54079,2,54081,2,54083,2,54085,2,54087,2,54089,2,54091,2,54093,2,54095,2,54097,2,54101,2,54103,2,54105,2,54107,2,24001,3,24023,\n3,24043,3,36003,3,36007,3,36009,3,36013,3,36015,3,36017,3,36023,3,36025,3,36077,3,36095,3,36097,3,36101,3,36107,3,36109,3,39007,3,39013,\n3,\n39019,3,39029,3,39031,3,39059,3,39067,3,39075,3,39081,3,39099,\n3,39119,3,39155,3,39157,3,42003,3,42005,3,42007,3,42009,3,42013,3,42015,\n3,42019,3,42021,3,42023,3,42025,3,42027,3,42031,3,42033,3,42035,3,42037,3,42039,3,42047,3,42049,3,42051,3,42053,3,42057,3,42059,3\n,42061,\n3,42063,3,42065,3,42067,3,42069,3,42073,3,42079,3,42081,3,42083,3,42085,3,42087,3,42089,3,42093,3,42097,3,42099,3,42103,3,42105,3,42107,\n3,42109,3,42111,3,42113,3,42115,3,42117,3,42119,3,42121,3,42123,3,42125,3,42127,3,42129,3,42131,3,54009,3,54029,3,54051,3,54069,3,37003,\n4,37005,4,37009,4,37011,4,37021,4,37023,4,37027,4,37039,4,37043,4,37059,4,37067,4,37075,4,37087,4,37089,4,37099,4,37111,4,37113,4,37115,\n4,37121,4,37149,4,37161,4,37169,4,37171,4,37173,4,37175,4,37189,4,37193,4,37197,4,37199,4,47007,4,47009,4,47011,4,47015,4,47019,4,47029,\n4,47031,4,47035,4,47041,4,47051,4,47059,4,47061,4,\n47063,4,47065,4,47073,4,47089,4,47091,4,47093,4,47099,4,47101,4,47105,4,47107,4,47115,\n4,47121,4,\n47123,4,47139,4,47141,4,47143,4,47145,4,47153,4,47155,4,47159,4,47163,4,47171,4,47175,4,47177,4,47179,4,47185,4,51017,4,51021,\n4,51023,4,51045,4,51063,4,51071,4,51077,4,51091,4,51141,4,51155,4,51173,4,51197,4,51005,4,51035,4,51089,4,51121,4,51163,4,51191,4,01007,\n5,01009,5,01015,5,01017,5,01019,5,01021,5,01027,5,01029,5,01033,5,01037,5,01043,5,01049,5,01051,5,01055,5,01057,5,01059,5,01065,5,01071,\n5,01073,5,01075,5,01077,5,01079,5,01083,5,01087,5,01089,5,01093,5,01095,5,01103,5,01107,5,01111,5,01115,5,01117,5,01121,5,01123,5,01125,\n5,01127,5,01133,5,13011,5,13013,5,13015,5,13045,5,13047,5,13055,5,13057,5,13083,5,13085,5,13097,5,13105,5,13111,5,13115,5,13117,5,13119,\n5,13123,5,13129,5,13135,5,13137,5,13139,5,13143,5,13147,5,13149,5,13157,5,13187,5,13195,5,13213,5,13223,5,13227,5,\n13233,5,13241,5,13257,\n5,13281,5,13291,5,13295,5,13311,5,13313,5,28003,5,28009,5,28013,5,28017,5,28019,5,28025,5,28057,5,28069,5,28081,\n5,28087,5,28093,5,28095,\n5,28097,5,28103,5,28105,5,28107,5,28115,5,28117,5,28139,5,28141,5,28145,5,28155,5,28159,5,28161,5,45007,5,45021,5,45045,5,45073,5,45077,\n5,45083,5,6),1,'`0001 Central',2,'`0002 North Central',3,'`0003 Northern',4,'`0004 South Central',5,'`0005 Southern',6,'`0006 Other') |
N |
decode(decode(plot.statecd*1000+plot.countycd,21001,1,21011,1,21013,1,21019,1,21025,1,21043,1,21045,1,21049,1,21051,1,21053,1,21057,1,21061,1,21063,1,21065,1,21069,1,21071,1,21079,1,21087,1,21089,1,21095,1,21099,1,21109,1,21115,1,21119,1,21121,1,21125,1,21127,1,21129,1,21131,1,21133,1,21135,1,21137,1,21147,1,21151,1,21153,1,21159,1,21165,1,21169,1,21171,1,21173,1,21175,1,21181,1,21189,1,21193,1,21195,1,21197,1,21199,1,21201,1,21203,1,21205,1,21207,1,21231,1,21235,1,21237,1,47001,1,47013,1,47025,1,47027,1,47049,1,47057,1,47067,1,47087,1,47111,1,47129,1,47133,1,47137,1,47151,1,47173,1,51027,1,51051,1,51105,1,51167,1,51169,1,51185,1,51195,1,54005,1,54043,1,54045,1,54047,1,54059,1,54099,1,54109,1,39001,2,39009,2,39015,2,39025,2,39053,2,39071,2,39073,2,39079,2,39087,2,39105,2,39111,2,39115,2,39121,2,39127,2,39131,2,39141,2,39145,2,39163,2,39167,2,54001,2,54003,2,54007,2,54011,2,54013,2,54015,2,54017,2,54019,2,54021,2,54023,2,54025,2,54027,2,54031,2,54033,2,54035,2,54037,2,54039,2,\n54041,2,54049,2,54053,\n2,54055,2,54057,2,54061,2,54063,2,54065,2,54067,2,54071,2,54073\n,2,54075,2,54077,2,54079,2,54081,2,54083,2,54085,2,54087,2,54089,2,54091,2,54093,2,54095,2,54097,2,54101,2,54103,2,54105,2,54107,2,24001,3,24023,3,24043,3,36003,3,36007,3,36009,3,36013,3,36015,3,36017,3,36023,3,36025,3,36077,3,36095,3,36097,3,36101,3,36107,3,36109,3,39007,3,39013,3,39019,3,39029,3,39031,3,39059,3,39067,3,39075,3,39081,3,39099,3,39119,3,39155,3,39157,3,42003,3,42005,3,42007,3,42009,3,42013,3,42015,3,42019,3,42021,3,42023,3,42025,3,42027,3,42031,3,42033,3,42035,3,42037,3,42039,3,42047,3,42049,3,42051,3,42053,3,42057,3,42059,3,42061,3,42063,3,42065,3,42067,3,42069,3,42073,3,42079,3,42081,3,42083,3,42085,3,42087,3,42089,3,42093,3,42097,3,42099,3,42103,3,42105,3,42107,3,42109,3,42111,3,42113,3,42115,3,42117,3,42119,3,42121,3,42123,3,42125,3,42127,3,42129,3,42131,3,54009,3,54029,3,54051,3,54069,3,37003,4,37005,4,37009,4,37011,4,37021,4,37023,4,37027,4,37039,\n4,37043,4,37059,4,37067,4,37075,4,37087,4,37089,4,37099,4,37111,4,37113,4,\n37115,4,37121,4,37149,4,37161,4,37169,4,37171,4,37173,4,37175,4,37189,4,37193,4,37197,4,37199,4,47007,4,47009,4,47011,4,47015,4,47019,4,47029,4,47031,4,47035,4,47041,4,47051,4,47059,4,47061,4,47063,4,47065,4,47073,4,47089,4,47091,4,47093,4,47099,4,47101,4,47105,4,47107,4,47115,4,47121,4,47123,4,47139,4,47141,\n4,47143,4,47145,4,47153,4,47155,4,47159,4,47163,4,47171,4,47175,4,47177,4,47179,4,47185,4,51017,4,51021,4,51023,4,51045,4,51063,4,51071,4,51077,4,51091,4,51141,4,51155,4,51173,4,51197,4,51005,4,51035,4,51089,4,51121,4,51163,4,51191,4,01007,5,01009,5,01015,5,01017,5,01019,5,01021,5,01027,5,01029,5,01033,5,01037,5,01043,5,01049,5,01051,5,01055,5,01057,5,01059,5,01065,5,01071,5,01073,5,01075,5,01077,5,01079,5,01083,5,01087,5,01089,5,01093,5,01095,5,01103,5,01107,5,01111,5,01115,5,01117,5,01121,5,01123,5,01125,5,01127,5,01133,5,13011,5,13013,5,13015,5,13045,5,13047,5,13055,5,\n13057,5,13083,5,13085,5,13097,5,13105,5,13111,5,13115,5,13117,5,13119,5,13123,5,13129,5,13135,5,13137,5,13139,5,13143,5,13147,5,13149,\n5,13157,5,13187,5,13195,5,13213,5,13223,5,13227,5,13233,5,13241,5,13257,5,13281,5,13291,5,13295,5,13311,5,13313,5,28003,5,28009,5,28013,5,28017,5,28019,5,28025,5,28057,5,28069,5,28081,5,28087,5,28093,5,28095,5,28097,5,28103,5,28105,5,28107,5,28115,5,28117,5,28139,5,28141,5,28145,5,28155,5,28159,5,28161,5,45007,5,45021,5,45045,5,45073,5,45077,5,45083,5,6),1,'`0001 Central'\n,2,'`0002 North Central',3,'`0003 Northern',4,'`0004 South Central',5,'`0005 Southern',6,'`0006 Other') |
| Artificial regen species |
C.STDORGSP |
The predominant artificially regenerated species (only available for stands that were established by planting or artificial seeding). |
N |
FS_FIADB.EVALIDATORFUNCTIONS.spcdlabel(cast(cond.stdorgsp as integer)) |
| Aspect |
C.ASPECT |
Aspect. The direction of slope, (measured to the nearest degree) for most of the condition.<br>\nNorth is from 316 to 360 degrees and 0 to 45 degrees<br>\nEast is from 46 to 135 degrees<br>\nSouth is from 136 to 225 degrees<br>\nWest is from 226 to 315 degrees<br> |
Y |
case coalesce(cond.aspect,-1) when 0 then '`0005 No slope' when -1 then '`0006 Not measured' when least(cond.aspect,45) then '`0001 North' when least(cond.aspect,135) then '`0002 East' when least(cond.aspect,225) then '`0003 South' when least(cond.aspect,315) then '`0004 West' when least(cond.aspect,360) then '`0001 North' else '`0007 Other' end |
| Basal area all live |
C.BALIVE |
Basal area of live trees. Basal area in square feet per acre of all live trees over 1 inch DBH/DRC sampled in the condition.<br> |
Y |
case coalesce(cond.balive,-1) when -1 then '`0005 not measured' when least(cond.balive,40) then '`0001 0-40 sqft/ac' when least(cond.balive,80) then '`0002 41-80 sqft/ac' when least(cond.balive,120) then '`0003 81-120 sqft/ac' when least(cond.balive,99999999) then '`0004 120+ sqft/ac' else '`0006 other' end |
| Cause of death |
T.AGENTCD |
Cause of death (agent) code. (Core: all remeasured plots when the tree was alive at the previous visit and at revisit is dead or removed OR \nthe tree is standing dead in the current inventory and the tree is ingrowth, through growth, or a missed live tree; \nCore optional: all initial plot visits when tree qualifies as a mortality tree.) When PLOT.MANUAL >=1.0, this variable \nwas collected on only dead and cut trees. When PLOT.MANUAL <1.0, this variable was collected on all trees (live, dead, \nand cut). Cause of damage was recorded for live trees if the presence of damage or pathogen activity was serious enough \nto reduce the quality or vigor of the tree. When a tree was damaged by more than one agent, the most severe damage was \ncoded. When no damage was observed on a live tree,\n00 was recorded. Damage recorded for dead trees was the cause of death. \nWhen the cause of death could not be\ndetermined for a tree, 99 was recorded. Each FIA program records specific codes that \nmay differ from one State to the next. These codes fall within the ranges listed below. For the specific codes used in a \nparticular State, contact the FIA work unit responsible for that State (table 6). \n<table>\n<tr><td>Code</td><td>Description</td><tr>\n<tr><td>00</td><td>No agent recorded (only allowed on live trees in data prior to 1999)</td><tr>\n<tr><td>10</td><td>Insect</td><tr>\n<tr><td>20</td><td>Disease</td><tr>\n<tr><td>30</td><td>Fire</td><tr>\n<tr><td>40</td><td>Animal</td><tr>\n<tr><td>50</td><td>Weather</td><tr>\n<tr><td>60</td><td>Vegetation (e.g., suppression, competition,\nvines/kudzu)</td><tr>\n<tr><td>70</td><td>Unknown/not sure/other - includes death from human activity not related to silvicultural or landclearing\nactivity (accidental, random, etc.) TREE NOTES required.</td><tr>\n<tr><td>80</td><td>Silvicultural or landclearing activity (death caused by harvesting or other silvicultural activity, including girdling, chaining, etc., or to landclearing activity).</td><tr>\n<tr><td><table> |
N |
case coalesce(tree.agentcd,-1) when -1 then '`0011 Not available' when least(tree.agentcd, 0) then '`0001 No serious damage' when least(tree.agentcd, 19) then '`0002 Insect' when least(tree.agentcd, 29) then '`0003 Disease' when least(tree.agentcd, 39) then '`0004 Fire' when least(tree.agentcd, 49) then '`0005 Animal' when least(tree.agentcd, 59) then '`0006 Weather' when least(tree.agentcd, 69) then '`0007 Vegetation' when least(tree.agentcd, 79) then '`0008 Unknown/other' when least(tree.agentcd, 89) then '`0009 Logging/human' when least(tree.agentcd, 99) then '`0010 Physical' end |
| Condition number |
C.CONDID |
Condition class number. Unique identifying number assigned to each condition on a plot. A condition is initially defined by condition class status. Differences in reserved status, owner group, forest type, stand-size class, regeneration status, and stand density further define condition for forest land. Mapped nonforest conditions are also assigned numbers. At the time of the plot establishment, the condition class at plot center (the center of subplot 1) is usually designated as condition class 1. Other condition classes are assigned numbers sequentially at the time each condition class is delineated. On a plot, each sampled condition class must have a unique number that can change at remeasurement to reflect new conditions on the plot. |
N |
case cond.condid when 1 then '`0001 Condition 1' when 2 then '`0002 Condition 2' when 3 then '`0003 Condition 3' when 4 then '`0004 Condition 4' when 5 then '`0005 Condition 5' when 6 then '`0006 Condition 6' when 7 then '`0007 Condition 7' when 8 then '`0008 Condition 8' when 9 then '`0009 Condition 9' when -1 then '`0010 Not available' else '`0011 Other' end |
| Condition proportion |
C.CONDPROP_UNADJ |
Condition proportion- |
Y |
case coalesce(cond.condprop_unadj,-1) when -1 then '`0012 Not available' when least(cond.condprop_unadj,.1) then '`0001 0 - 10%' when least(cond.condprop_unadj,.2) then '`0002 10- 20%' when least(cond.condprop_unadj,.3) then '`0003 20 - 30%' when least(cond.condprop_unadj,.4) then '`0004 30 - 40%' when least(cond.condprop_unadj,.5) then '`0005 40 - 50%' when least(cond.condprop_unadj,.6) then '`0006 50 - 60%' when least(cond.condprop_unadj,.7) then '`0007 60 - 70%' when least(cond.condprop_unadj,.8) then '`0008 70 - 80%' when least(cond.condprop_unadj,.9) then '`0009 80 - 90%' when least(cond.condprop_unadj,.99) then '`0010 90 - 99%' when least(cond.condprop_unadj,1.0) then '`0011 100%' else '`0013 other' end |
| Congressional District |
PG.CONGCD |
Congressional district code. A territorial division of a State from which a member of the U.S. House of Representatives is elected. The congressional district code assigned to a plot (regardless of when it was measured) is for the most recent Congress (112th Congress in 2011-2012); the assignment is made based on the plot's approximate coordinates. CONGCD is a four-digit number. The first two digits are the State FIPS code and the last two digits are the congressional district number. If a State has only one congressional district, the congressional district number is 00. If a plot's congressional district assignment falls in a State other than the plot's actual State due to using the approximate coordinates,\nthe congressional district code will be for the nearest congressional district in the correct State. This attribute is coded for\nthe coterminous States and Alaska, and is left blank (null) in all other instances.<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plotgeom.congcd) |
| County code and name |
P.COUNTYCD |
County code and name. The identification number for a county, parish, watershed, borough, or similar governmental unit in a State. FIPS codes from the Bureau of the Census are used.<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.CountycdLabel(cond.statecd,cond.countycd) |
| CountyGroup |
C.COUNTYCD |
CountyGroup- |
N |
FS_FIADB.EVALIDATORFUNCTIONS.COUNTYGRPLABEL(plot.statecd,plot.unitcd,plot.countycd) |
| Crown class |
T.CCLCD |
Crown class code. A code indicating the amount of sunlight received and the crown position within the canopy.\n<table>\n<tr><td>Code</td><td>Description<td></tr>\n<tr><td>1</td><td>Open grown - Trees with crowns that have received full light from above and from all sides\nthroughout all or most of their life, particularly during early development.<td></tr>\n<tr><td>2</td><td>Dominant - Trees with crowns extending above the general level of the canopy and receiving full light from above and partly from the sides; larger than the average trees in the stand, and with crowns well developed, but possibly somewhat crowded on the sides.<td></tr>\n<tr><td>3</td><td>Codominant - Trees with crowns forming part of the general level of the crown cover and receiving full light from above,\nbut comparatively little from the side. Usually with medium crowns more or less crowded on the sides.<td></tr>\n<tr><td>4</td><td>Intermediate - Trees shorter than those in the preceding two classes, with crowns either below or extending into the canopy formed by the dominant and codominant trees, receiving little direct light from above, and none from the sides; usually with small crowns very crowded on the sides.<td></tr>\n<tr><td>5</td><td>Overtopped - Trees with crowns entirely below the general canopy level and receiving no direct light either from above or the sides.<td></tr></table>\n<br> |
N |
case coalesce(tree.cclcd,-1) when 1 then '`0001 Open grown' when 2 then '`0002 Dominant' when 3 then '`0003 Codominant' when 4 then '`0004 Intermediate' when 5 then '`0005 Overtopped' when -1 then '`0006 Not available' else '`0007 Other' end |
| Crown ratio |
T.CR |
Compacted crown ratio. The percent of the tree bole supporting live, healthy foliage (the crown is ocularly compacted to fill in gaps) when compared to actual length (ACTUALHT). When PLOT.MANUAL <1.0 the variable may have been a code, which was converted to the midpoint of the ranges represented by the codes, and is stored as a percentage.<br> |
Y |
case coalesce(tree.cr,-1) when -1 then '`0011 Not available' when least(tree.cr,10) then '`0001 0 - 10%' when least(tree.cr,20) then '`0002 10- 20%' when least(tree.cr,30) then '`0003 20 - 30%' when least(tree.cr,40) then '`0004 30 - 40%' when least(tree.cr,50) then '`0005 40 - 50%' when least(tree.cr,60) then '`0006 50 - 60%' when least(tree.cr,70) then '`0007 60 - 70%' when least(tree.cr,80) then '`0008 70 - 80%' when least(tree.cr,90) then '`0009 80 - 90' when least(tree.cr,100) then '`0010 90 - 100' else '`0012 other' end |
| Damage location 1 |
T.DAMLOC1 |
Damage location 1. (Core where PLOT.MANUAL = 1.0 through 1.6; Core optional beginning with PLOT.MANUAL = 1.7.) A code indicating where damage (meeting or exceeding a severity threshold, as defined in the field guide) is present on the tree. \n<table>\n<tr><td>Code</td><td>Description<td></tr>\n<tr><td>0</td><td>No damage<td></tr>\n<tr><td>1</td><td>Roots (exposed) and stump (up to 12 inches from ground level)<td></tr>\n<tr><td>2</td><td>Roots, stump,\nand lower bole<td></tr>\n<tr><td>3</td><td>Lower bole (lower half of bole between stump and base of live crown)<td></tr>\n<tr><td>4</td><td>Lower and upper bole<td></tr>\n<tr><td>5</td><td>Upper bole (upper half of bole between stump and base of live crown)<td></tr>\n<tr><td>6</td><td>Crownstem (main stem within the live crown)<td></tr>\n<tr><td>7</td><td>Branches (>1 inch diameter at junction with main stem and within the live crown)<td></tr>\n<tr><td>8</td><td>Buds and shoots of current year<td></tr>\n<tr><td>9</td><td>Foliage<td></tr>\n</table>br>\n |
N |
case coalesce(tree.damloc1,-1) when 0 then '`0001 No damage' when 1 then '`0002 Roots and stump' when 2 then '`0003 Roots stump and lower bole' when 3 then '`0004 Lower bole' when 4 then '`0005 Lower and upper bole' when 5 then '`0006 Upper bole' when 6 then '`0007 Crown stem' when 7 then '`0008 Branches' when 8 then '`0009 Buds and shoots' when 9 then '`0010 Foliage' when -1 then '`0011 Not available' else '`0012 Other' end |
| Damage location 2 |
T.DAMLOC2 |
Damage location 2. (Core where PLOT.MANUAL = 1.0 through 1.6; Core optional beginning with PLOT.MANUAL = 1.7.) A code indicating where damage (meeting or exceeding a severity threshold, as defined in the field guide) is present on the tree. \n<table>\n<tr><td>Code</td><td>Description<td></tr>\n<tr><td>0</td><td>No damage<td></tr>\n<tr><td>1</td><td>Roots (exposed) and stump (up to 12 inches from ground level)<td></tr>\n<tr><td>2</td><td>Roots, stump,\nand lower bole<td></tr>\n<tr><td>3</td><td>Lower bole (lower half of bole between stump and base of live crown)<td></tr>\n<tr><td>4</td><td>Lower and upper bole<td></tr>\n<tr><td>5</td><td>Upper bole (upper half of bole between stump and base of live crown)<td></tr>\n<tr><td>6</td><td>Crownstem (main stem within the live crown)<td></tr>\n<tr><td>7</td><td>Branches (>1 inch diameter at junction with main stem and within the live crown)<td></tr>\n<tr><td>8</td><td>Buds and shoots of current year<td></tr>\n<tr><td>9</td><td>Foliage<td></tr>\n</table>br> |
N |
case coalesce(tree.damloc2,-1) when 0 then '`0001 No damage' when 1 then '`0002 Roots and stump' when 2 then '`0003 Roots stump and lower bole' when 3 then '`0004 Lower bole' when 4 then '`0005 Lower and upper bole' when 5 then '`0006 Upper bole' when 6 then '`0007 Crown stem' when 7 then '`0008 Branches' when 8 then '`0009 Buds and shoots' when 9 then '`0010 Foliage' when -1 then '`0011 Not available' else '`0012 Other' end |
| Damage severity 1 |
T.DAMSEV1 |
Damage severity 1. (Core where PLOT.MANUAL = 1.0 through 1.6; Core optional beginning with PLOT.MANUAL = 1.7.) A code indicating how much of the tree is affected. Valid severity codes vary by damage type and damage location and must exceed a threshold value,\nas defined in the field guide.\n<table>\n<tr><td>\n<tr><td>Code</td><td>Description</td><tr>\n<tr><td>0</td><td>01 to 09% of location affected</td><tr>\n<tr><td>1</td><td>10 to 19% of location affected</td><tr>\n<tr><td>2</td><td>20 to 29% of location affected</td><tr>\n<tr><td>3</td><td>30 to 39% of location affected</td><tr>\n<tr><td>4</td><td>40 to 49% of location affected</td><tr>\n<tr><td>5</td><td>50 to 59% of location affected</td><tr>\n<tr><td>6</td><td>60 to 69% of location affected</td><tr>\n<tr><td>7</td><td>70 to 79% of location affected</td><tr>\n<tr><td>8</td><td>80 to 89% of location affected</td><tr>\n<tr><td>9</td><td>90 to 99% of location affected</td><tr>\n</table><br> |
N |
case coalesce(tree.damsev1,-1) when -1 then '`0011 Not available' when least(tree.damsev1,0) then '`0001 0 - 9%' when least(tree.damsev1,1) then '`0002 10- 19%' when least(tree.damsev1,2) then '`0003 20 - 29%' when least(tree.damsev1,3) then '`0004 30 - 39%' when least(tree.damsev1,4) then '`0005 40 - 49%' when least(tree.damsev1,5) then '`0006 50 - 59%' when least(tree.damsev1,6) then '`0007 60 - 69%' when least(tree.damsev1,7) then '`0008 70 - 79%' when least(tree.damsev1,8) then '`0009 80 - 89' when least(tree.damsev1,9) then '`0010 90 - 99' else '`0012 other' end |
| Damage severity 2 |
T.DAMSEV2 |
Damage severity 2. (Core where PLOT.MANUAL = 1.0 through 1.6; Core optional beginning with PLOT.MANUAL = 1.7.) A code indicating how much of the tree is affected by the secondary damage. Valid severity codes vary by damage type and damage location and must exceed a threshold value,\nas defined in the field guide.\n<table>\n<tr><td>\n<tr><td>Code</td><td>Description</td><tr>\n<tr><td>0</td><td>01 to 09% of location affected</td><tr>\n<tr><td>1</td><td>10 to 19% of location affected</td><tr>\n<tr><td>2</td><td>20 to 29% of location affected</td><tr>\n<tr><td>3</td><td>30 to 39% of location affected</td><tr>\n<tr><td>4</td><td>40 to 49% of location affected</td><tr>\n<tr><td>5</td><td>50 to 59% of location affected</td><tr>\n<tr><td>6</td><td>60 to 69% of location affected</td><tr>\n<tr><td>7</td><td>70 to 79% of location\naffected</td><tr>\n<tr><td>8</td><td>80 to 89% of location affected</td><tr>\n<tr><td>9</td><td>90 to 99% of location affected</td><tr>\n</table><br> |
N |
case coalesce(tree.damsev2,-1) when -1 then '`0011 Not available' when least(tree.damsev2,0) then '`0001 0 - 9%' when least(tree.damsev2,1) then '`0002 10- 19%' when least(tree.damsev2,2) then '`0003 20 - 29%' when least(tree.damsev2,3) then '`0004 30 - 39%' when least(tree.damsev2,4) then '`0005 40 - 49%' when least(tree.damsev2,5) then '`0006 50 - 59%' when least(tree.damsev2,6) then '`0007 60 - 69%' when least(tree.damsev2,7) then '`0008 70 - 79%' when least(tree.damsev2,8) then '`0009 80 - 89' when least(tree.damsev2,9) then '`0010 90 - 99' else '`0012 other' end |
| Damage type 1 |
T.DAMTYP1 |
Damage type 1. (Core where PLOT.MANUAL = 1.0 through 1.6; Core optional beginning with PLOT.MANUAL = 1.7.) A code indicating the kind of damage (meeting or exceeding a severity threshold, as defined in the field guide) present.\n<table>\n<tr><td>Code</TD><TD>Description</TD></TR>\n<tr><td>01</TD><TD>Canker, gall</TD></TR>\n<tr><td>02</TD><TD>Conk, fruiting body,\nor sign of advanced decay</TD></TR>\n<tr><td>03</TD><TD>Open wound</TD></TR>\n<tr><td>04</TD><TD>Resinosis or gumosis</TD></TR>\n<tr><td>05</TD><TD>Crack or seam</TD></TR>\n<tr><td>11</TD><TD>Broken bole or broken root within 3 feet of bole</TD></TR>\n<tr><td>12</TD><TD>Broom on root or bole</TD></TR>\n<tr><td>13</TD><TD>Broken or dead root further than 3 feet from bole</TD></TR>\n<tr><td>20</TD><TD>Vines in the crown</TD></TR>\n<tr><td>21</TD><TD>Loss of apical\ndominance, dead terminal</TD></TR>\n<tr><td>22</TD><TD>Broken or dead branches</TD></TR>\n<tr><td>23</TD><TD>Excessive branching or brooms within the live crown</TD></TR>\n<tr><td>24</TD><TD>Damaged shoots, buds,\nor foliage</TD></TR>\n<tr><td>25</TD><TD>Discoloration of foliage</TD></TR>\n<tr><td>31</TD><TD>Other</TD></TR>\n</table><br> |
N |
case coalesce(tree.damtyp1,-1) when 1 then '`0001 Canker or gall' when 2 then '`0002 Conk/fruiting body/advanced decay' when 3 then '`0003 Open wound' when 4 then '`0004 Resinosis or gumosis' when 5 then '`0005 Crack or seam' when 11 then '`0006 Broken bole or broken root within 3 feet of bole' when 12 then '`0007 Broom on root or bole' when 13 then '`0008 Broken or dead root further than 3 feet from bole' when 20 then '`0009 Vines in the crown' when 21 then '`0010 Loss of apical dominance-dead terminal' when 22 then '`0011 Broken or dead branches' when 23 then '`0012 Excessive branching or brooms within the live crown' when 24 then '`0013 Damaged shoots buds or foliage' when 25 then '`0014 Discoloration of foliage' when 31 then '`0015 Other' when -1 then '`0016 Not available' else '`0017 Other' end |
| Damage type 2 |
T.DAMTYP2 |
Damage type 2. (Core where PLOT.MANUAL = 1.0 through 1.6; Core optional beginning with PLOT.MANUAL = 1.7.) A code indicating the kind of secondary damage (meeting or exceeding a severity threshold, as defined in the field guide) present.\n<table>\n<tr><td>Code</TD><TD>Description</TD></TR>\n<tr><td>Code</TD><TD>Description</TD></TR>\n<tr><td>01</TD><TD>Canker, gall</TD></TR>\n<tr><td>02</TD><TD>Conk, fruiting body,\nor sign of advanced decay</TD></TR>\n<tr><td>03</TD><TD>Open wound</TD></TR>\n<tr><td>04</TD><TD>Resinosis or gumosis</TD></TR>\n<tr><td>05</TD><TD>Crack or seam</TD></TR>\n<tr><td>11</TD><TD>Broken bole or broken root within 3 feet of bole</TD></TR>\n<tr><td>12</TD><TD>Broom on root or bole</TD></TR>\n<tr><td>13</TD><TD>Broken or dead root further than 3 feet from bole</TD></TR>\n<tr><td>20</TD><TD>Vines in\nthe crown</TD></TR>\n<tr><td>21</TD><TD>Loss of apical dominance, dead terminal</TD></TR>\n<tr><td>22</TD><TD>Broken or dead branches</TD></TR>\n<tr><td>23</TD><TD>Excessive branching or brooms within the live crown</TD></TR>\n<tr><td>24</TD><TD>Damaged shoots, buds,\nor foliage</TD></TR>\n<tr><td>25</TD><TD>Discoloration of foliage</TD></TR>\n<tr><td>31</TD><TD>Other</TD></TR>\n</table><br> |
N |
case coalesce(tree.damtyp2,-1) when 1 then '`0001 Canker or gall' when 2 then '`0002 Conk/fruiting body/advanced decay' when 3 then '`0003 Open wound' when 4 then '`0004 Resinosis or gumosis' when 5 then '`0005 Crack or seam' when 11 then '`0006 Broken bole or broken root within 3 feet of bole' when 12 then '`0007 Broom on root or bole' when 13 then '`0008 Broken or dead root further than 3 feet from bole' when 20 then '`0009 Vines in the crown' when 21 then '`0010 Loss of apical dominance-dead terminal' when 22 then '`0011 Broken or dead branches' when 23 then '`0012 Excessive branching or brooms within the live crown' when 24 then '`0013 Damaged shoots buds or foliage' when 25 then '`0014 Discoloration of foliage' when 31 then '`0015 Other' when -1 then '`0016 Not available' else '`0017 Other' end |
| Dead tree decay |
T.DECAYCD |
Decay class code. A code indicating the stage of decay in a standing dead tree. Populated where PLOT.MANUAL >=1.0\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>1</td><td>All limbs and branches are present; the top of the crown is still present; all bark remains; sapwood is intact,\nwith minimal decay; heartwood is sound and hard</td></tr>\n<tr><td>2</td><td>There are few limbs and no fine branches; the top may be broken; a variable amount of bark remains; sapwood is sloughing with advanced decay; heartwood is sound at base but beginning to decay in the outer part of the upper bole</td></tr>\n<tr><td>3</td><td>Only limb stubs exist; the top is broken; a variable amount of bark remains; sapwood is sloughing; heartwood has advanced decay in upper bole and is beginning at the base</td></tr>\n<tr><td>4</td><td>Few or no limb stubs remain; the top is broken; a variable amount of bark remains; sapwood is sloughing; heartwood has advanced decay at the base and is sloughing in the upper bole</td></tr>\n<tr><td>5</td><td>No evidence of branches remains; the top is broken; <20 percent of the bark remains; sapwood is gone; heartwood is sloughing throughout</td<></tr>\n</table><br> |
N |
case coalesce(tree.decaycd,-1) when 1 then '`0001 All limbs and branches present' when 2 then '`0002 Few limbs and no fine branches' when 3 then '`0003 Only limb stubs present' when 4 then '`0004 Few or no limb stubs remain' when 5 then '`0005 No evidence of branches remain' when -1 then '`0006 Not available' else '`0007 Other' end |
| Diameter class: 2 inch class to 29 |
T.DIA |
Current diameter. The current diameter (in inches) of the sample tree at the point of diameter measurement. Most trees are measured at d.b.h.,\nwoodland species are measured at d.r.c. DIA for live trees contains the measured value. DIA for cut and dead trees presents problems associated with\nuncertainty of when the tree was cut or died as well as structural deterioration of dead trees. Consult individual FIA work units for explanations of how DIA is collected for dead and cut trees.<br> |
Y |
case when coalesce(tree.dia,-1) = -1 then '`0013 Not available' when tree.dia = 0 then '`0013 not measured' when tree.dia is null then '`0013 not measured' when tree.dia = least(tree.dia,2.99) then '`0001 1.0-2.9' when tree.dia = least(tree.dia,4.99) then '`0002 3.0-4.9' when tree.dia = least(tree.dia,6.99) then '`0003 5.0-6.9' when tree.dia = least(tree.dia,8.99) then '`0004 7.0-8.9' when tree.dia = least(tree.dia,10.99) then '`0005 9.0-10.9' when tree.dia = least(tree.dia,12.99) then '`0006 11.0-12.9' when tree.dia = least(tree.dia,14.99) then '`0007 13.0-14.9' when tree.dia = least(tree.dia,16.99) then '`0008 15.0-16.9' when tree.dia = least(tree.dia,18.99) then '`0009 17.0-18.9' when tree.dia = least(tree.dia,20.99) then '`0010 19.0-20.9' when tree.dia = least(tree.dia,28.99) then '`0011 21.0-28.9' else '`0012 29.0+' end |
| Diameter class: 2 inch class to 41 |
T.DIA |
Current diameter. The current diameter (in inches) of the sample tree at the point of diameter measurement. Most trees are measured at d.b.h., woodland species are measured at d.r.c. DIA for live trees contains the measured value. DIA for cut and dead trees presents problems associated with uncertainty of when the tree was cut or died as well as structural deterioration of dead trees. Consult individual FIA work units for explanations of how DIA is collected for dead and cut trees.<br> |
N |
case when coalesce(tree.dia,-1) = -1 then '`0022 Not available' when tree.dia = 0 then '`0022 not measured' when tree.dia is null then '`0022 not measured' when tree.dia = least(tree.dia,2.99) then '`0001 1.0-2.9' when tree.dia = least(tree.dia,4.99) then '`0002 3.0-4.9' when tree.dia = least(tree.dia,6.99) then '`0003 5.0-6.9' when tree.dia = least(tree.dia,8.99) then '`0004 7.0-8.9' when tree.dia = least(tree.dia,10.99) then '`0005 9.0-10.9' when tree.dia = least(tree.dia,12.99) then '`0006 11.0-12.9' when tree.dia = least(tree.dia,14.99) then '`0007 13.0-14.9' when tree.dia = least(tree.dia,16.99) then '`0008 15.0-16.9' when tree.dia = least(tree.dia,18.99) then '`0009 17.0-18.9' when tree.dia = least(tree.dia,20.99) then '`0010 19.0-20.9' when tree.dia = least(tree.dia,22.99) then '`0011 21.0-22.9' when tree.dia = least(tree.dia,24.99) then '`0012 23.0-24.9' when tree.dia = least(tree.dia,26.99) then '`0013 25.0-26.9' when tree.dia = least(tree.dia,28.99) then '`0014 27.0-28.9' when tree.dia = least(tree.dia,30.99) then '`0015 29.0-30.9' when tree.dia = least(tree.dia,32.99) then '`0016 31.0-32.9' when tree.dia = least(tree.dia,34.99) then '`0017 33.0-34.9' when tree.dia = least(tree.dia,36.99) then '`0018 35.0-36.9' when tree.dia = least(tree.dia,38.99) then '`0019 37.0-38.9' when tree.dia = least(tree.dia,40.99) then '`0020 39.0-40.9' else '`0021 41.0+' end |
| Diameter class: current |
T.DIA |
Current diameter. The current diameter (in inches) of the sample tree at the point of diameter measurement. Most trees are measured at d.b.h.,\nwoodland species are measured at d.r.c. DIA for live trees contains the measured value. DIA for cut and dead trees presents problems associated with\nuncertainty of when the tree was cut or died as well as structural deterioration of dead trees. Consult individual FIA work units for explanations of how DIA is collected for dead and cut trees.<br> |
N |
case when coalesce(tree.dia,-1) = -1 then '`0013 Not available' when tree.dia = 0 then '`0013 not measured' when tree.dia is null then '`0013 not measured' when tree.dia = least(tree.dia,2.99) then '`0001 1.0-2.9' when tree.dia = least(tree.dia,4.99) then '`0002 3.0-4.9' when tree.dia = least(tree.dia,6.99) then '`0003 5.0-6.9' when tree.dia = least(tree.dia,8.99) then '`0004 7.0-8.9' when tree.dia = least(tree.dia,10.99) then '`0005 9.0-10.9' when tree.dia = least(tree.dia,12.99) then '`0006 11.0-12.9' when tree.dia = least(tree.dia,14.99) then '`0007 13.0-14.9' when tree.dia = least(tree.dia,16.99) then '`0008 15.0-16.9' when tree.dia = least(tree.dia,18.99) then '`0009 17.0-18.9' when tree.dia = least(tree.dia,20.99) then '`0010 19.0-20.9' when tree.dia = least(tree.dia,28.99) then '`0011 21.0-28.9' else '`0012 29.0+' end |
| Distance to road |
P.RDDISTCD |
Horizontal distance to improved road code. The straight-line distance from plot center to the nearest improved road, which is a road of any width that is maintained as evidenced by pavement, gravel, grading, ditching, and/or other improvements. Populated for all forested plots using the National Field Guide protocols (MANUAL =1.0) and populated by some FIA work units for inventory plots collected where MANUAL <1.0.<br> |
N |
case coalesce(plot.rddistcd,-1) when 1 then '`0001 100 ft or less' when 2 then '`0002 101-300 ft' when 3 then '`0003 301-500 ft' when 4 then '`0004 501-1000 ft' when 5 then '`0005 1001 ft to 1/2 mile' when 6 then '`0006 1/2 to 1 mile' when 7 then '`0007 1 to 3 miles' when 8 then '`0008 3 to 5 miles' when 9 then '`0009 Greater than 5 miles' when -1 then '`0010 Not available' else '`0011 Other' end |
| Disturbance 1 |
C.DSTRBCD1 |
Disturbance 1 code. A code indicating the kind of disturbance occurring since the last measurement or within the last 5 years for new plots. The area affected by the disturbance must be at least 1 acre in size. A significant level of disturbance (mortality or damage to 25 percent of the trees in the condition) is required. Populated for all forested conditions using the National Field Guide protocols (PLOT.MANUAL >=1.0) and populated by some FIA work units where PLOT.MANUAL <1.0. Codes 11, 12, 21, and 22 are valid where PLOT. MANUAL >=2.0.\n<table>\n<tr><td>Code</td><td>Description</td</tr>\n<tr><td>0</td><td>No visible disturbance</td</tr>\n<tr><td>10</td><td>Insect Damage</td</tr>\n<tr><td>11</td><td>Insect damage to understory vegetation</td</tr>\n<tr><td>12</td><td>Insect damage to trees,\nincluding seedlings and saplings</td</tr>\n<tr><td>20</td><td>Disease Damage</td</tr>\n<tr><td>21</td><td>Disease damage to understory vegetation</td</tr>\n<tr><td>22</td><td>Disease damage to trees, including seedlings and saplings</td</tr>\n<tr><td>30</td><td>Fire damage (from crown and ground fire,\neither prescribed or natural)</td</tr>\n<tr><td>31</td><td>Ground fire damage</td</tr>\n<tr><td>32</td><td>Crown fire damage</td</tr>\n<tr><td>40</td><td>Animal Damage</td</tr>\n<tr><td>41</td><td>Beaver (includes flooding caused by beaver)</td</tr>\n<tr><td>42</td><td>Porcupine</td</tr>\n<tr><td>43</td><td>Deer/ungulate</td</tr>\n<tr><td>44</td><td>Bear (CORE OPTIONAL)</td</tr>\n<tr><td>45</td><td>Rabbit (CORE OPTIONAL)</td</tr>\n<tr><td>46</td><td>Domestic animal/livestock (includes grazing)</td</tr>\n<tr><td>50</td><td>Weather Damage</td</tr>\n<tr><td>51</td><td>Ice</td</tr>\n<tr><td>52</td><td>Wind (includes hurricane,\ntornado)</td</tr>\n<tr><td>53</td><td>Flooding (weather induced)</td</tr>\n<tr><td>54</td><td>Drought</td</tr>\n<tr><td>60</td><td>Vegetation (suppression, competition, vines)</td</tr>\n<tr><td>70</td><td>Unknown / not sure / other (include in NOTES)</td</tr>\n<tr><td>80</td><td>Human-caused damage - any significant threshold of human-caused damage not described in the DISTURBANCE codes or in the TREATMENT codes.</td</tr>\n<tr><td>90</td><td>Geologic disturbances</td</tr>\n<tr><td>91</td><td>Landslide</td</tr>\n<tr><td>92</td><td>Avalanche track</td</tr>\n<tr><td>93</td><td>Volcanic blast zone</td</tr>\n<tr><td>94</td><td>Other geologic event</td</tr>\n<tr><td>95</td><td>Earth movement / avalanches</td</tr>\n</table> |
N |
case coalesce(cond.dstrbcd1,-1) when 0 then '`0001 No visible disturbance' when 10 then '`0002 Insect damage' when 11 then '`0003 Insect damage to understory vegetation' when 12 then '`0004 Insect damage to trees including seedlings and saplings' when 20 then '`0005 Disease damage' when 21 then '`0006 Disease damage to understory vegetation' when 22 then '`0007 Disease damage to trees, including seedlings and saplings' when 30 then '`0008 Fire (from crown and ground fire, either prescribed or natural)' when 31 then '`0009 Ground fire damage' when 32 then '`0010 Crown fire damage' when 40 then '`0011 Animal damage' when 41 then '`0012 Beaver (includes flooding caused by beaver)' when 42 then '`0013 Porcupine' when 43 then '`0014 Deer/ungulate' when 44 then '`0015 Bear' when 45 then '`0016 Rabbit' when 46 then '`0017 Domestic animal/livestock (includes grazing)' when 50 then '`0018 Weather damage' when 51 then '`0019 Ice' when 52 then '`0020 Wind (includes hurricane, tornado)' when 53 then '`0021 Flooding (weather induced)' when 54 then '`0022 Drought' when 60 then '`0023 Vegetation (suppression,competetion,vines)' when 70 then '`0024 Unknown/not sure/other' when 80 then '`0025 Human-caused damage' when 90 then '`0026 Geologic disturbance' when 91 then '`0027 Landslide' when 92 then '`0028 Avalanche track' when 93 then '`0029 Volcanic blast zone' when 94 then '`0030 Other geologic event' when 95 then '`0031 Earth movement/avalanches' when -1 then '`0032 Not available' else '`0032 Other' end |
| Disturbance 2 |
C.DSTRBCD2 |
Disturbance 2 code. A code indicating the kind of secondary disturbance occurring since the last measurement or within the last 5 years for new plots. The area affected by the disturbance must be at least 1 acre in size. A significant level of disturbance (mortality or damage to 25 percent of the trees in the condition) is required. Populated for all forested conditions using the National Field Guide protocols (PLOT.MANUAL >=1.0) and populated by some FIA work units where PLOT.MANUAL <1.0. Codes 11, 12, 21, and 22 are valid where PLOT. MANUAL >=2.0.\n<table>\n<tr><td>Code</td><td>Description</td</tr>\n<tr><td>0</td><td>No visible disturbance</td</tr>\n<tr><td>10</td><td>Insect Damage</td</tr>\n<tr><td>11</td><td>Insect damage to understory vegetation</td</tr>\n<tr><td>12</td><td>Insect damage to trees,\nincluding seedlings and saplings</td</tr>\n<tr><td>20</td><td>Disease Damage</td</tr>\n<tr><td>21</td><td>Disease damage to understory vegetation</td</tr>\n<tr><td>22</td><td>Disease damage to trees, including seedlings and saplings</td</tr>\n<tr><td>30</td><td>Fire damage (from crown and ground fire,\neither prescribed or natural)</td</tr>\n<tr><td>31</td><td>Ground fire damage</td</tr>\n<tr><td>32</td><td>Crown fire damage</td</tr>\n<tr><td>40</td><td>Animal Damage</td</tr>\n<tr><td>41</td><td>Beaver (includes flooding caused by beaver)</td</tr>\n<tr><td>42</td><td>Porcupine</td</tr>\n<tr><td>43</td><td>Deer/ungulate</td</tr>\n<tr><td>44</td><td>Bear (CORE OPTIONAL)</td</tr>\n<tr><td>45</td><td>Rabbit (CORE OPTIONAL)</td</tr>\n<tr><td>46</td><td>Domestic animal/livestock (includes grazing)</td</tr>\n<tr><td>50</td><td>Weather Damage</td</tr>\n<tr><td>51</td><td>Ice</td</tr>\n<tr><td>52</td><td>Wind (includes hurricane,\ntornado)</td</tr>\n<tr><td>53</td><td>Flooding (weather induced)</td</tr>\n<tr><td>54</td><td>Drought</td</tr>\n<tr><td>60</td><td>Vegetation (suppression, competition, vines)</td</tr>\n<tr><td>70</td><td>Unknown / not sure / other (include in NOTES)</td</tr>\n<tr><td>80</td><td>Human-caused damage - any significant threshold of human-caused damage not described in the DISTURBANCE codes or in the TREATMENT codes.</td</tr>\n<tr><td>90</td><td>Geologic disturbances</td</tr>\n<tr><td>91</td><td>Landslide</td</tr>\n<tr><td>92</td><td>Avalanche track</td</tr>\n<tr><td>93</td><td>Volcanic blast zone</td</tr>\n<tr><td>94</td><td>Other geologic event</td</tr>\n<tr><td>95</td><td>Earth movement / avalanches</td</tr>\n</table> |
N |
case coalesce(cond.dstrbcd2,-1) when 0 then '`0001 No visible disturbance' when 10 then '`0002 Insect damage' when 11 then '`0003 Insect damage to understory vegetation' when 12 then '`0004 Insect damage to trees including seedlings and saplings' when 20 then '`0005 Disease damage' when 21 then '`0006 Disease damage to understory vegetation' when 22 then '`0007 Disease damage to trees, including seedlings and saplings' when 30 then '`0008 Fire (from crown and ground fire, either prescribed or natural)' when 31 then '`0009 Ground fire damage' when 32 then '`0010 Crown fire damage' when 40 then '`0011 Animal damage' when 41 then '`0012 Beaver (includes flooding caused by beaver)' when 42 then '`0013 Porcupine' when 43 then '`0014 Deer/ungulate' when 44 then '`0015 Bear' when 45 then '`0016 Rabbit' when 46 then '`0017 Domestic animal/livestock (includes grazing)' when 50 then '`0018 Weather damage' when 51 then '`0019 Ice' when 52 then '`0020 Wind (includes hurricane, tornado)' when 53 then '`0021 Flooding (weather induced)' when 54 then '`0022 Drought' when 60 then '`0023 Vegetation (suppression,competetion,vines)' when 70 then '`0024 Unknown/not sure/other' when 80 then '`0025 Human-caused damage' when 90 then '`0026 Geologic disturbance' when 91 then '`0027 Landslide' when 92 then '`0028 Avalanche track' when 93 then '`0029 Volcanic blast zone' when 94 then '`0030 Other geologic event' when 95 then '`0031 Earth movement/avalanches' when -1 then '`0032 Not available' else '`0032 Other' end |
| Disturbance 3 |
C.DSTRBCD3 |
Disturbance 3 code. A code indicating the tertiary kind of disturbance occurring since the last measurement or within the last 5 years for new plots. The area affected by the disturbance must be at least 1 acre in size. A significant level of disturbance (mortality or damage to 25 percent of the trees in the condition) is required. Populated for all forested conditions using the National Field Guide protocols (PLOT.MANUAL >=1.0) and populated by some FIA work units where PLOT.MANUAL <1.0. Codes 11, 12, 21, and 22 are valid where PLOT. MANUAL >=2.0.\n<table>\n<tr><td>Code</td><td>Description</td</tr>\n<tr><td>0</td><td>No visible disturbance</td</tr>\n<tr><td>10</td><td>Insect Damage</td</tr>\n<tr><td>11</td><td>Insect damage to understory vegetation</td</tr>\n<tr><td>12</td><td>Insect damage to trees,\nincluding seedlings and saplings</td</tr>\n<tr><td>20</td><td>Disease Damage</td</tr>\n<tr><td>21</td><td>Disease damage to understory vegetation</td</tr>\n<tr><td>22</td><td>Disease damage to trees, including seedlings and saplings</td</tr>\n<tr><td>30</td><td>Fire damage (from crown and ground fire,\neither prescribed or natural)</td</tr>\n<tr><td>31</td><td>Ground fire damage</td</tr>\n<tr><td>32</td><td>Crown fire damage</td</tr>\n<tr><td>40</td><td>Animal Damage</td</tr>\n<tr><td>41</td><td>Beaver (includes flooding caused by beaver)</td</tr>\n<tr><td>42</td><td>Porcupine</td</tr>\n<tr><td>43</td><td>Deer/ungulate</td</tr>\n<tr><td>44</td><td>Bear (CORE OPTIONAL)</td</tr>\n<tr><td>45</td><td>Rabbit (CORE OPTIONAL)</td</tr>\n<tr><td>46</td><td>Domestic animal/livestock (includes grazing)</td</tr>\n<tr><td>50</td><td>Weather Damage</td</tr>\n<tr><td>51</td><td>Ice</td</tr>\n<tr><td>52</td><td>Wind (includes hurricane,\ntornado)</td</tr>\n<tr><td>53</td><td>Flooding (weather induced)</td</tr>\n<tr><td>54</td><td>Drought</td</tr>\n<tr><td>60</td><td>Vegetation (suppression, competition, vines)</td</tr>\n<tr><td>70</td><td>Unknown / not sure / other (include in NOTES)</td</tr>\n<tr><td>80</td><td>Human-caused damage - any significant threshold of human-caused damage not described in the DISTURBANCE codes or in the TREATMENT codes.</td</tr>\n<tr><td>90</td><td>Geologic disturbances</td</tr>\n<tr><td>91</td><td>Landslide</td</tr>\n<tr><td>92</td><td>Avalanche track</td</tr>\n<tr><td>93</td><td>Volcanic blast zone</td</tr>\n<tr><td>94</td><td>Other geologic event</td</tr>\n<tr><td>95</td><td>Earth movement / avalanches</td</tr>\n</table> |
N |
case coalesce(cond.dstrbcd3,-1) when 0 then '`0001 No visible disturbance' when 10 then '`0002 Insect damage' when 11 then '`0003 Insect damage to understory vegetation' when 12 then '`0004 Insect damage to trees including seedlings and saplings' when 20 then '`0005 Disease damage' when 21 then '`0006 Disease damage to understory vegetation' when 22 then '`0007 Disease damage to trees, including seedlings and saplings' when 30 then '`0008 Fire (from crown and ground fire, either prescribed or natural)' when 31 then '`0009 Ground fire damage' when 32 then '`0010 Crown fire damage' when 40 then '`0011 Animal damage' when 41 then '`0012 Beaver (includes flooding caused by beaver)' when 42 then '`0013 Porcupine' when 43 then '`0014 Deer/ungulate' when 44 then '`0015 Bear' when 45 then '`0016 Rabbit' when 46 then '`0017 Domestic animal/livestock (includes grazing)' when 50 then '`0018 Weather damage' when 51 then '`0019 Ice' when 52 then '`0020 Wind (includes hurricane, tornado)' when 53 then '`0021 Flooding (weather induced)' when 54 then '`0022 Drought' when 60 then '`0023 Vegetation (suppression,competetion,vines)' when 70 then '`0024 Unknown/not sure/other' when 80 then '`0025 Human-caused damage' when 90 then '`0026 Geologic disturbance' when 91 then '`0027 Landslide' when 92 then '`0028 Avalanche track' when 93 then '`0029 Volcanic blast zone' when 94 then '`0030 Other geologic event' when 95 then '`0031 Earth movement/avalanches' when -1 then '`0032 Not available' else '`0032 Other' end |
| EMAPHEX |
PG.EMAPHEX |
EMAP hexagon. The identifier for the approximately 160,000 acre Environmental Monitoring and Assessment Program (EMAP) hexagon in which the plot is located. EMAP hexagons are available to the public, cover the coterminous United States, and have been used in summarizing and aggregating data about numerous natural resources. Populated for annual inventory and may be populated for periodic inventory.<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.EMAPHEXlabel(cast(plotgeom.emap_hex as integer)) |
| EVALID |
P.EVALID |
Evaluation ID |
N |
EVALID hardcoded |
| Ecoregion section |
PG.ECOSUBCD |
<dt><em>Identification_Information:</em> \n<dd>\n<dl>\n<dt><em>Citation:</em> \n<dd>\n<dl>\n<dt><em>Citation_Information:</em> \n<dd>\n<dl>\n<dt><em>Originator:</em> USDA - Forest Service ECOMAP Team</dt>\n<dt><em>Publication_Date:</em> 2005</dt>\n\n<dt><em>Title:</em> \n<dd>\n\nEcological Subregions: Sections and Subsections for the Conterminous United States\n\n</dd>\n<dt><em>Geospatial_Data_Presentation_Form:</em> vector digital data</dt>\n<dt><em>Publication_Information:</em> \n<dd>\n<dl>\n<dt><em>Publication_Place:</em> Washington,\nDC</dt>\n\n<dt><em>Publisher:</em> USDA - Forest Service</dt>\n</dl>\n</dd>\n<dt><em>Online_Linkage:</em> \n<dd>\n\n\\LT97SLOAN\c\alyssa\ecomap\larryleefers_08_17_05_with_metadata\ecoregions\n\n</dd>\n</dl>\n</dd>\n</dl>\n</dd>\n<dt><em>Description:</em> \n\n<dd>\n<dl>\n<dt><em>Abstract:</em> \n<dd>\n\nThis data set includes polygons for ecological sections and subsections within Subregions within the conterminous United States. This data set contains regional geographic delineations for analysis of ecological relationships across ecological units.\n\n</dd>\n<dt><em>Purpose:</em> \n<dd>\n\nBaseline map of the ecological boundaries. Ecological analysis of resource distribution patterns and associations among\ndifferent ecological land units.\n\n</dd>\n</dl>\n</dd>\n<dt><em>Time_Period_of_Content:</em> \n\n<dd>\n<dl>\n<dt><em>Time_Period_Information:</em> \n<dd>\n<dl>\n<dt><em>Single_Date/Time:</em> \n<dd>\n<dl>\n<dt><em>Calendar_Date:</em> August 11,\n2005</dt>\n</dl>\n</dd>\n</dl>\n\n</dd>\n<dt><em>Currentness_Reference:</em> ground condition</dt>\n</dl>\n</dd>\n<dt><em>Status:</em> \n<dd>\n<dl>\n<dt><em>Progress:</em> REQUIRED: The state of the data set.</dt>\n<dt><em>Maintenance_and_Update_Frequency:</em> \n\n<dd>\n\nREQUIRED: The\nfrequency with which changes and additions are made to the data set after the initial data set is completed.\n\n</dd>\n</dl>\n</dd>\n<dt><em>Spatial_Domain:</em> \n<dd>\n<dl>\n<dt><em>Bounding_Coordinates:</em> \n<dd>\n<dl>\n<dt><em>West_Bounding_Coordinate:</em> -127\n.841705</dt>\n\n<dt><em>East_Bounding_Coordinate:</em> -65.287817</dt>\n<dt><em>North_Bounding_Coordinate:</em> 51.540198</dt>\n<dt><em>South_Bounding_Coordinate:</em> 22.869666</dt>\n</dl>\n</dd>\n</dl>\n</dd>\n<dt><em>Keywords:</em> \n\n<dd>\n<dl>\n<dt><em>Theme:</em> \n<dd>\n<dl>\n<dt><em>Theme_Keyword:</em> ecoregion</dt>\n<dt><em>Theme_Keyword:</em> ecomap</dt>\n<dt><em>Theme_Keyword:</em> province</dt>\n\n<dt><em>Theme_Keyword:</em> section</dt>\n<dt><em>Theme_Keyword:</em> subsection</dt>\n</dl>\n</dd>\n<dt><em>Place:</em> \n<dd>\n<dl>\n<dt><em>Place_Keyword:</em> Unite\nd States</dt>\n\n</dl>\n</dd>\n</dl>\n</dd>\n<dt><em>Access_Constraints:</em> None</dt>\n<dt><em>Use_Constraints:</em> None</dt>\n<dt><em>Point_of_Contact:</em> \n<dd>\n<dl>\n<dt><em>Contact_Information:</em> \n\n<dd>\n<dl>\n<dt><em>Contact_Person_Primary:</em> \n<dd>\n<dl>\n<dt><em>Contact_Person:</em>\nDavid T. Cleland</dt>\n<dt><em>Contact_Organization:</em> USDA Forest Service</dt>\n</dl>\n</dd>\n<dt><em>Contact_Address:</em> \n\n<dd>\n<dl>\n<dt><em>Address_Type:</em> mailing address</dt>\n<dt><em>Address:</em> Eastern Regional Office and Southern Research Stat\nion</dt>\n<dt><em>Address:</em> Federal Building, 68 S. Stevens Street</dt>\n<dt><em>City:</em> Rhinelander</dt>\n\n<dt><em>State_or_Province:</em> WI</dt>\n<dt><em>Postal_Code:</em> 54501-9128</dt>\n<dt><em>Country:</em> United States</dt>\n</dl>\n</dd>\n<dt><em>Contact_Voice_Telephone:</em> (715) 365-1003</dt>\n\n<dt><em>Contact_Facsimile_Telephone:</em> (715) 362-1359</dt>\n<dt><em>Contact_Electronic_Mail_Address:</em>\ndcleland@fs.fed.us</dt>\n</dl>\n</dd>\n</dl>\n</dd>\n<dt><em>Native_Data_Set_Environment:</em> \n<dd>\n\nMicrosoft Windows 2000 Version 5.0 (Build 2195) Service Pack 4; ESRI ArcCatalog 9.0.0.535\n</dd>\n<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.ecosectionLabel(plotgeom.ecosubcd) |
| Ecoregion subsection |
PG.ECOSUBCD |
<dt><em>Identification_Information:</em> \n<dd>\n<dl>\n<dt><em>Citation:</em> \n<dd>\n<dl>\n<dt><em>Citation_Information:</em> \n<dd>\n<dl>\n<dt><em>Originator:</em> USDA - Forest Service ECOMAP Team</dt>\n<dt><em>Publication_Date:</em> 2005</dt>\n\n<dt><em>Title:</em> \n<dd>\n\nEcological Subregions: Sections and Subsections for the Conterminous United States\n\n</dd>\n<dt><em>Geospatial_Data_Presentation_Form:</em> vector digital data</dt>\n<dt><em>Publication_Information:</em> \n<dd>\n<dl>\n<dt><em>Publication_Place:</em> Washington,\nDC</dt>\n\n<dt><em>Publisher:</em> USDA - Forest Service</dt>\n</dl>\n</dd>\n<dt><em>Online_Linkage:</em> \n<dd>\n\n\\LT97SLOAN\c\alyssa\ecomap\larryleefers_08_17_05_with_metadata\ecoregions\n\n</dd>\n</dl>\n</dd>\n</dl>\n</dd>\n<dt><em>Description:</em> \n\n<dd>\n<dl>\n<dt><em>Abstract:</em> \n<dd>\n\nThis data set includes polygons for ecological sections and subsections within Subregions within the conterminous United States. This data set contains regional geographic delineations for analysis of ecological relationships across ecological units.\n\n</dd>\n<dt><em>Purpose:</em> \n<dd>\n\nBaseline map of the ecological boundaries. Ecological analysis of resource distribution patterns and associations among\ndifferent ecological land units.\n\n</dd>\n</dl>\n</dd>\n<dt><em>Time_Period_of_Content:</em> \n\n<dd>\n<dl>\n<dt><em>Time_Period_Information:</em> \n<dd>\n<dl>\n<dt><em>Single_Date/Time:</em> \n<dd>\n<dl>\n<dt><em>Calendar_Date:</em> August 11,\n2005</dt>\n</dl>\n</dd>\n</dl>\n\n</dd>\n<dt><em>Currentness_Reference:</em> ground condition</dt>\n</dl>\n</dd>\n<dt><em>Status:</em> \n<dd>\n<dl>\n<dt><em>Progress:</em> REQUIRED: The state of the data set.</dt>\n<dt><em>Maintenance_and_Update_Frequency:</em> \n\n<dd>\n\nREQUIRED: The\nfrequency with which changes and additions are made to the data set after the initial data set is completed.\n\n</dd>\n</dl>\n</dd>\n<dt><em>Spatial_Domain:</em> \n<dd>\n<dl>\n<dt><em>Bounding_Coordinates:</em> \n<dd>\n<dl>\n<dt><em>West_Bounding_Coordinate:</em> -127\n.841705</dt>\n\n<dt><em>East_Bounding_Coordinate:</em> -65.287817</dt>\n<dt><em>North_Bounding_Coordinate:</em> 51.540198</dt>\n<dt><em>South_Bounding_Coordinate:</em> 22.869666</dt>\n</dl>\n</dd>\n</dl>\n</dd>\n<dt><em>Keywords:</em> \n\n<dd>\n<dl>\n<dt><em>Theme:</em> \n<dd>\n<dl>\n<dt><em>Theme_Keyword:</em> ecoregion</dt>\n<dt><em>Theme_Keyword:</em> ecomap</dt>\n<dt><em>Theme_Keyword:</em> province</dt>\n\n<dt><em>Theme_Keyword:</em> section</dt>\n<dt><em>Theme_Keyword:</em> subsection</dt>\n</dl>\n</dd>\n<dt><em>Place:</em> \n<dd>\n<dl>\n<dt><em>Place_Keyword:</em> Unite\nd States</dt>\n\n</dl>\n</dd>\n</dl>\n</dd>\n<dt><em>Access_Constraints:</em> None</dt>\n<dt><em>Use_Constraints:</em> None</dt>\n<dt><em>Point_of_Contact:</em> \n<dd>\n<dl>\n<dt><em>Contact_Information:</em> \n\n<dd>\n<dl>\n<dt><em>Contact_Person_Primary:</em> \n<dd>\n<dl>\n<dt><em>Contact_Person:</em>\nDavid T. Cleland</dt>\n<dt><em>Contact_Organization:</em> USDA Forest Service</dt>\n</dl>\n</dd>\n<dt><em>Contact_Address:</em> \n\n<dd>\n<dl>\n<dt><em>Address_Type:</em> mailing address</dt>\n<dt><em>Address:</em> Eastern Regional Office and Southern Research Stat\nion</dt>\n<dt><em>Address:</em> Federal Building, 68 S. Stevens Street</dt>\n<dt><em>City:</em> Rhinelander</dt>\n\n<dt><em>State_or_Province:</em> WI</dt>\n<dt><em>Postal_Code:</em> 54501-9128</dt>\n<dt><em>Country:</em> United States</dt>\n</dl>\n</dd>\n<dt><em>Contact_Voice_Telephone:</em> (715) 365-1003</dt>\n\n<dt><em>Contact_Facsimile_Telephone:</em> (715) 362-1359</dt>\n<dt><em>Contact_Electronic_Mail_Address:</em>\ndcleland@fs.fed.us</dt>\n</dl>\n</dd>\n</dl>\n</dd>\n<dt><em>Native_Data_Set_Environment:</em> \n<dd>\n\nMicrosoft Windows 2000 Version 5.0 (Build 2195) Service Pack 4; ESRI ArcCatalog 9.0.0.535\n</dd>\n<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.ecosubcdLabel(plotgeom.ecosubcd) |
| Elevation |
P.ELEV |
Elevation. The distance the plot is located above sea level, recorded in feet (NAD 83 datum). Negative values indicate distance below sea level.<br> |
N |
case coalesce(plot.ELEV,-999) when -999 then '`0013 Not available' when least(plot.ELEV,1000) then '`0001 less than 1001 feet' when least(plot.ELEV,2000) then '`0002 1001-2000 feet' when least(plot.ELEV,3000) then '`0003 2001-3000 feet' when least(plot.ELEV,4000) then '`0004 3001-4000 feet' when least(plot.ELEV,5000) then '`0005 4001-5000 feet' when least(plot.ELEV,6000) then '`0006 5001-6000 feet' when least(plot.ELEV,7000) then '`0007 6001-7000 feet' when least(plot.ELEV,8000) then '`0008 7001-8000 feet' when least(plot.ELEV,9000) then '`0009 8001-9000 feet' when least(plot.ELEV,10000) then '`0010 9001-10000 feet' when least(plot.ELEV,20000) then '`0011 10001-20000 feet' else '`0012 Other' end |
| Forest Service Region |
C.ADFORCD |
Forest Service Regions<br>\nNorthern Region (R1)<br>\nRocky Mountain Region (R2)<br>\nSouthwestern Region (R3)<br>\nIntermountain Region (R4)<br>\nPacific Southwest Region (R5)<br>\nPacific Northwest Region (R6) <br>\nSouthern Region (R8)<br>\nEastern Region (R9)<br>\nAlaska Region (R10)<br>\n<a href="http://www.fs.fed.us/contactus/regions.shtml" title="Forest Service Regions">Forest Service Regions</a><br> |
N |
case coalesce(cond.adforcd,-1) when least(cond.adforcd,99) then '`0001 Not National Forest' when least(cond.adforcd,199) then '`0002 Region 1' when least(cond.adforcd,299) then '`0003 Region 2' when least(cond.adforcd,399) then '`0004 Region 3' when least(cond.adforcd,499) then '`0005 Region 4' when least(cond.adforcd,599) then '`0006 Region 5' when least(cond.adforcd,699) then '`0007 Region 6' when least(cond.adforcd,799) then '`0008 Region 7' when least(cond.adforcd,899) then '`0009 Region 8' when least(cond.adforcd,999) then '`0010 Region 9' when least(cond.adforcd,1099) then '`0011 Region 10' else '`0012 Other' end |
| Forest Type MnDNR |
C.FORTYPCD |
Minnesota DNR Forest type groups are formed from combining FIADB forest types into groups:<br>\n<table>\n<tr><td>FIADB forest type codes</td><td>FIADB forest type names</td><td>MN DNR forest type names</td></tr>\n<tr><td>100</td><td>White-red-jack pine group</td><td>White-Red-Jack Pine Group</td></tr>\n<tr><td>101</td><td>Jack pine</td><td>Jack pine</td></tr>\n<tr><td>102</td><td>Red pine</td><td>Red pine</td></tr>\n<tr><td>400</td><td>Oak-pine group</td><td>Red pine</td></tr>\n<tr><td>409</td><td>Other pine-hardwood</td><td>Red pine</td></tr>\n<tr><td>103</td><td>Eastern white pine</td><td>Eastern white pine</td></tr>\n<tr><td>401</td><td>Eastern white pine-northern red oak-white ash</td><td>Eastern white pine</td></tr>\n<tr><td>120</td><td>Spruce-fir group</td><td>Spruce-Fir Group</td></tr>\n<tr><td>121</td><td>B\nalsam\nfir</td><td>Balsam fir</td></tr>\n<tr><td>122</td><td>White spruce</td><td>White spruce</td></tr>\n<tr><td>125</td><td>Black spruce</td><td>Black spruce</td></tr>\n<tr><td>126</td><td>Tamarack</td><td>Tamarack</td></tr>\n<tr><td>127</td><td>Northern white-cedar</td><td>Northern white-cedar</td></tr>\n<tr><td>181</td><td>retired (Eastern redcedar)</td><td>Eastern redcedar</td></tr>\n<tr><td>402</td><td>Eastern redcedar-hardwood</td><td>Eastern redcedar</td></tr>\n<tr><td>380</td><td>Exotic softwoods group</td><td>Other softwoods</td></tr>\n<tr><td>381</td><td>Scotch pine</td><td>Other softwoods</td></tr>\n<tr><td>500</td><td>Oak-hickory group</td><td>Oak</td></tr>\n<tr><td>503</td><td>White oak-red oak-hickory</td><td>Oak</td></tr>\n<tr><td>504</td><td>White oak</td><td>Oak</td></tr>\n<tr\n><td>505</td><td>Northern\nred oak</td><td>Oak</td></tr>\n<tr><td>509</td><td>Bur oak</td><td>Oak</td></tr>\n<tr><td>519</td><td>Red maple-oak</td><td>Northern hardwoods</td></tr>\n<tr><td>520</td><td>Mixed upland hardwoods</td><td>Northern hardwoods</td></tr>\n<tr><td>800</td><td>Maple-beech-birch group</td><td>Northern hardwoods</td></tr>\n<tr><td>801</td><td>Sugar maple-beech-yellow birch</td><td>Northern hardwoods</td></tr>\n<tr><td>805</td><td>Hard maple-basswood</td><td>Northern hardwoods</td></tr>\n<tr><td>807</td><td>retired (Elm-ash-locust)</td><td>Northern hardwoods</td></tr>\n<tr><td>809</td><td>Red maple-upland</td><td>Northern hardwoods</td></tr>\n<tr><td>700</td><td>Elm-ash-cottonwood group</td><td>Lowland hardwoods</td></tr>\n<tr><td>701</td><td>Black ash-American elm-red maple</td><td>Lowland hardwoods</td><\n/tr>\n<tr><td>705</td><td>Sycamore-pecan-American\nelm</td><td>Lowland hardwoods</td></tr>\n<tr><td>706</td><td>Sugarberry-hackberry-elm-green ash</td><td>Lowland hardwoods</td></tr>\n<tr><td>707</td><td>Silver maple-American elm</td><td>Lowland hardwoods</td></tr>\n<tr><td>708</td><td>Red maple-lowland</td><td>Lowland hardwoods</td></tr>\n<tr><td>703</td><td>Cottonwood</td><td>Cottonwood-Willow</td></tr>\n<tr><td>704</td><td>Willow</td><td>Cottonwood-Willow</td></tr>\n<tr><td>709</td><td>Cottonwood-willow</td><td>Cottonwood-Willow</td></tr>\n<tr><td>900</td><td>Aspen-birch group</td><td>Aspen</td></tr>\n<tr><td>901</td><td>Aspen</td><td>Aspen</td></tr>\n<tr><td>702</td><td>River birch-sycamore</td><td>Birch</td></tr>\n<tr><td>902</td><td>Paper birch</td><td>Birch</td></tr>\n<tr><td>904</td><td\n>Balsam poplar</td><td>Balsam poplar</td></tr>\n<tr><td>999</td><td>Nonstocked</td><td>Non stocked</td></tr>\n<tr><td>other codes</td><td></td><td>Other</td></tr>\n</table><br> |
N |
case cond.fortypcd when 100 then '`0001 White / Red / Jack Pine Group' when 101 then '`0002 Jack pine' when 102 then '`0003 Red pine' when 400 then '`0003 Red pine' when 409 then '`0003 Red pine' when 103 then '`0004 Eastern white pine' when 401 then '`0004 Eastern white pine' when 120 then '`0005 Spruce / Fir Group' when 121 then '`0006 Balsam fir' when 122 then '`0007 White spruce' when 125 then '`0008 Black spruce' when 126 then '`0009 Tamarack' when 127 then '`0010 Northern white-cedar' when 181 then '`0011 Eastern redcedar' when 402 then '`0011 Eastern redcedar' when 380 then '`0012 Other softwoods' when 381 then '`0012 Other softwoods' when 500 then '`0013 Oak' when 503 then '`0013 Oak' when 504 then '`0013 Oak' when 505 then '`0013 Oak' when 509 then '`0013 Oak' when 519 then '`0014 Northern hardwoods' when 520 then '`0014 Northern hardwoods' when 800 then '`0014 Northern hardwoods' when 801 then '`0014 Northern hardwoods' when 805 then '`0014 Northern hardwoods' when 807 then '`0014 Northern hardwoods' when 809 then '`0014 Northern hardwoods' when 700 then '`0015 Lowland hardwoods' when 701 then '`0015 Lowland hardwoods' when 705 then '`0015 Lowland hardwoods' when 706 then '`0015 Lowland hardwoods' when 707 then '`0015 Lowland hardwoods' when 708 then '`0015 Lowland hardwoods' when 703 then '`0016 Cottonwood / Willow' when 704 then '`0016 Cottonwood / Willow' when 709 then '`0016 Cottonwood / Willow' when 900 then '`0017 Aspen' when 901 then '`0017 Aspen' when 902 then '`0018 Birch' when 702 then '`0018 Birch' when 904 then '`0019 Balsam poplar' when 999 then '`0020 Non stocked' when 707 then '`0021 Other' when -1 then '`0021 Other' else '`0021 Other' end |
| Forest type |
C.FORTYPCD |
Forest-type: A classification of forest land based on the species presently forming a plurality of the live-tree stocking. If softwoods predominate (50 percent or more), then the forest-type will be one of the softwood types and vice versa for hardwoods. Forest type is primarily derived using a computer algorithm, except when less than 25 percent of the plot samples a particular forest condition.<br>\nUsually, FORTYPCD equals FORTYPCDCALC. In certain situations, however, the result from the algorithm (FORTYPCDCALC) is overridden by the field call. The field-recorded forest type code (FLDTYPCD) is stored in this attribute when less than 25 percent of the plot samples the forested condition (CONDPROP_UNADJ <0.25).<br>\nIn most cases,\nFORTYPCD is the same as the field-recorded forest type\n(FLDTYPCD). However, situations of under sampling may cause this attribute to differ from FLDTYPCD.<br>\nNonstocked forest land is land that currently has less than 10 percent stocking but formerly met the definition of forest land. Forest conditions meeting this definition have few, if any, trees sampled. In these instances, the algorithm cannot assign a specific forest type and the resulting forest type code is 999, meaning nonstocked.<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.fortypcdLabel(cond.fortypcd) |
| Forest type field call |
C.FLDTYPCD |
Forest-type: A classification of forest land based on the species presently forming a plurality of the live-tree stocking. If softwoods predominate (50 percent or more), then the forest-type will be one of the softwood types and vice versa for hardwoods. Forest type is primarily derived using a computer algorithm, except when less than 25 percent of the plot samples a particular forest condition.<br>\nUsually, FORTYPCD equals FORTYPCDCALC. In certain situations, however, the result from the algorithm (FORTYPCDCALC) is overridden by the field call. The field-recorded forest type code (FLDTYPCD) is stored in this attribute when less than 25 percent of the plot samples the forested condition (CONDPROP_UNADJ <0.25).<br>\nIn most cases,\nFORTYPCD is the same as the field-recorded forest type\n(FLDTYPCD). However, situations of under sampling may cause this attribute to differ from FLDTYPCD.<br>\nNonstocked forest land is land that currently has less than 10 percent stocking but formerly met the definition of forest land. Forest conditions meeting this definition have few, if any, trees sampled. In these instances, the algorithm cannot assign a specific forest type and the resulting forest type code is 999, meaning nonstocked.<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.fortypcdLabel(cond.fldtypcd) |
| Forest type group |
C.FORTYPCD |
Forest-type: A classification of forest land based on the species presently forming a plurality of the live-tree stocking. If softwoods predominate (50 percent or more), then the forest-type will be one of the softwood types and vice versa for hardwoods. Forest type is primarily derived using a computer algorithm, except when less than 25 percent of the plot samples a particular forest condition.<br>\nUsually, FORTYPCD equals FORTYPCDCALC. In certain situations, however, the result from the algorithm (FORTYPCDCALC) is overridden by the field call. The field-recorded forest type code (FLDTYPCD) is stored in this attribute when less than 25 percent of the plot samples the forested condition (CONDPROP_UNADJ <0.25).<br>\nIn most cases, FORTYPCD is the same as the field-recorded forest type (FLDTYPCD). However,\nsituations of under sampling may cause this attribute to differ from FLDTYPCD.<br>\nNonstocked forest land is land that currently has less than 10\npercent stocking but formerly met the definition of forest land. Forest conditions meeting this definition have few, if any, trees sampled. In these instances, the algorithm cannot assign a specific forest type and the resulting forest type code is 999,\nmeaning nonstocked. \nForest type groups are formed from combining forest types into groups:<br>\n\n<table>\n<tr><td>Forest type group code</td><td>Forest type group name</td></tr>\n<tr><td>100</td><td>White / red / jack pine group</td></tr>\n<tr><td>120</td><td>Spruce / fir group</td></tr>\n<tr><td>140</td><td>Longleaf / slash pine group</td></tr>\n<tr><td>150</td><td>Tropical softwoods group</td></tr>\n<tr><td>160</td><td>Loblolly / shortleaf pine group</td></tr>\n<tr><td>170</td><td>Other eastern softwoods group</td></tr>\n<tr><td>180</td><td>Pinyon / juniper group</td></tr>\n<tr><td>200</td><td>Douglas-fir group</td></tr>\n<tr><td>220</td><td>Ponderosa pine group</td></tr>\n<tr><td>240</td><td>Western white pine group</td></tr>\n<tr><td>260</td><td>Fir / spruc\ne / mountain hemlock group</td></tr>\n<tr><td>280</td><td>Lodgepole pine group</td></tr>\n<tr><td>300</td><td>Hemlock / Sitka spruce group</td></tr>\n<tr><td>320</td><td>Western larch group</td></tr>\n<tr><td>340</td><td>Redwood group</td></tr>\n<tr><td>360</td><td>Other western softwoods group</td></tr>\n<tr><td>370</td><td>California mixed conifer group</td></tr>\n<tr><td>380</td><td>Exotic softwoods group</td></tr>\n<tr><td>390</td><td>Other softwoods group</td></tr>\n<tr><td>400</td><td>Oak / pine group</td></tr>\n<tr><td>500</td><td>Oak / hickory group</td></tr>\n<tr><td>600</td><td>Oak / gum /\ncypress group</td></tr>\n<tr><td>700</td><td>Elm / ash / cottonwood group</td></tr>\n<tr><td>800</td><td>Maple / beech / birch group</td></tr>\n<tr><td>900</td><td>Asp\nen / birch group</td></tr>\n<tr><td>910</td><td>Alder / maple group</td></tr>\n<tr><td>920</td><td>Western oak group</td></tr>\n<tr><td>940</td><td>Tanoak / laurel group</td></tr>\n<tr><td>950</td><td>retired (Other western hardwoods group)</td></tr>\n<tr><td>960</td><td>Other hardwoods group</td></tr>\n<tr><td>970</td><td>Woodland hardwoods group</td></tr>\n<tr><td>980</td><td>Tropical hardwoods group</td></tr>\n<tr><td>990</td><td>Exotic hardwoods group</td></tr>\n<tr><td>999</td><td>Nonstocked</td></tr>\n</table><br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.fortypgrpcdLabel(cond.fortypcd) |
| Forest type group abbr |
C.FORTYPCD |
Forest-type: A classification of forest land based on the species presently forming a plurality of the live-tree stocking. If softwoods predominate (50 percent or more), then the forest-type will be one of the softwood types and vice versa for hardwoods. Forest type is primarily derived using a computer algorithm, except when less than 25 percent of the plot samples a particular forest condition.<br>\nUsually, FORTYPCD equals FORTYPCDCALC. In certain situations, however, the result from the algorithm (FORTYPCDCALC) is overridden by the field call. The field-recorded forest type code (FLDTYPCD) is stored in this attribute when less than 25 percent of the plot samples the forested condition (CONDPROP_UNADJ <0.25).<br>\nIn most cases, FORTYPCD is the same as the field-recorded forest type (FLDTYPCD). However,\nsituations of under sampling may cause this attribute to differ from FLDTYPCD.<br>\nNonstocked forest land is land that currently has less than 10\npercent stocking but formerly met the definition of forest land. Forest conditions meeting this definition have few, if any, trees sampled. In these instances, the algorithm cannot assign a specific forest type and the resulting forest type code is 999,\nmeaning nonstocked. \nForest type groups are formed from combining forest types into groups:<br>\n\n<table>\n<tr><td>Forest type group code</td><td>Forest type group name</td></tr>\n<tr><td>100</td><td>White / red / jack pine group</td></tr>\n<tr><td>120</td><td>Spruce / fir group</td></tr>\n<tr><td>140</td><td>Longleaf / slash pine group</td></tr>\n<tr><td>150</td><td>Tropical softwoods group</td></tr>\n<tr><td>160</td><td>Loblolly / shortleaf pine group</td></tr>\n<tr><td>170</td><td>Other eastern softwoods group</td></tr>\n<tr><td>180</td><td>Pinyon / juniper group</td></tr>\n<tr><td>200</td><td>Douglas-fir group</td></tr>\n<tr><td>220</td><td>Ponderosa pine group</td></tr>\n<tr><td>240</td><td>Western white pine group</td></tr>\n<tr><td>260</td><td>Fir / spruc\ne / mountain hemlock group</td></tr>\n<tr><td>280</td><td>Lodgepole pine group</td></tr>\n<tr><td>300</td><td>Hemlock / Sitka spruce group</td></tr>\n<tr><td>320</td><td>Western larch group</td></tr>\n<tr><td>340</td><td>Redwood group</td></tr>\n<tr><td>360</td><td>Other western softwoods group</td></tr>\n<tr><td>370</td><td>California mixed conifer group</td></tr>\n<tr><td>380</td><td>Exotic softwoods group</td></tr>\n<tr><td>390</td><td>Other softwoods group</td></tr>\n<tr><td>400</td><td>Oak / pine group</td></tr>\n<tr><td>500</td><td>Oak / hickory group</td></tr>\n<tr><td>600</td><td>Oak / gum /\ncypress group</td></tr>\n<tr><td>700</td><td>Elm / ash / cottonwood group</td></tr>\n<tr><td>800</td><td>Maple / beech / birch group</td></tr>\n<tr><td>900</td><td>Asp\nen / birch group</td></tr>\n<tr><td>910</td><td>Alder / maple group</td></tr>\n<tr><td>920</td><td>Western oak group</td></tr>\n<tr><td>940</td><td>Tanoak / laurel group</td></tr>\n<tr><td>950</td><td>retired (Other western hardwoods group)</td></tr>\n<tr><td>960</td><td>Other hardwoods group</td></tr>\n<tr><td>970</td><td>Woodland hardwoods group</td></tr>\n<tr><td>980</td><td>Tropical hardwoods group</td></tr>\n<tr><td>990</td><td>Exotic hardwoods group</td></tr>\n<tr><td>999</td><td>Nonstocked</td></tr>\n</table><br> |
N |
decode(cond.fortypcd,100,'`0001 WRJP',101,'`0001 WRJP',102,'`0001 WRJP',103,'`0001 WRJP',104,'`0001 WRJP',105,'`0001 WRJP',120,'`0002 SpFir',121,'`0002 SpFir',122,'`0002 SpFir',123,'`0002 SpFir',124,'`0002 SpFir',125,'`0002 SpFir',126,'`0002 SpFir',127,'`0002 SpFir',128,'`0002 SpFir',129,'`0002 SpFir',140,'`0003 LngSl',141,'`0003 LngSl',142,'`0003 LngSl',150,'`0004 TropSw',151,'`0004 TropSw',160,'`0005 LobSh',161,'`0005 LobSh',162,'`0005 LobSh',163,'`0005 LobSh',164,'`0005 LobSh',165,'`0005 LobSh',166,'`0005 LobSh',167,'`0005 LobSh',168,'`0005 LobSh',170,'`0006 OthESw'\n,171,'`0006 OthESw',172,'`0006 OthESw',180,'`0007 PJ',181,'`0007 PJ',182,'`0007 PJ',183,'`0007 PJ',184,'`0007 PJ',185,'`0007 PJ',200,'`0008 DF',201,'`0008 DF',202,'`0008 DF',203,'`0008 DF',220,'`0009 PP',221,'`0009 PP',222,'`0009 PP',223,'`0009 PP',224,'`0009 PP',225,'`0009 PP',226,'`0009 PP',240,\n'`0010 WWP',241,'`0010 WWP',\n260,'`0011 FirSpr',261,'`0011 FirSpr',262,'`0011 FirSpr',263,'`0011 FirSpr',264,'`0011 FirSpr',265,'`0011 FirSpr',266,'`0011 FirSpr',267,'`0011 FirSpr',268,'`0011 FirSpr',269,'`0011 FirSpr',270,'`0011 FirSpr',271,'`0011 FirSpr',280,'`0012 LodP',281,'`0012 LodP',300,'`0013 HemSit',301,'`0013 HemSit',304,'`0013 HemSit',305,'`0013 HemSit',320,'`0014 WLar',321,'`0014 WLar',340,'`0015 RedW',341,'`0015 RedW',342,'`0015 RedW',360,'`0016 OtWSw',361,'`0016 OtWSw',362,'`0016 OtWSw',363,'`0016 OtWSw',364,'`0016 OtWSw',365,'`0016 OtWSw',366,'`0016 OtWSw',367,'`0016 OtWSw',368,'`0016 OtWSw',369,'`0016 OtWSw',370,'`0017 CalMxCon',371,'`0017 CalMxCon',380,'`0018 ExSw',381,'`0018 ExSw',382,'`0018 ExSw',383,'`0018 ExSw',384,'`0018 ExSw',385,'`0018 ExSw',390,'`0019 OtSw',391,'`0019 OtSw',400,'`0020 OkP',401,'`0020 OkP',402,'`0020 OkP',403,'`0020 OkP',404,\n'`0020 OkP',405,'`0020 OkP',406,'`0020 OkP',407,'`0020 OkP',\n409,'`0020 OkP',500,'`0021 OkH',501,'`0021 OkH',502,'`0021 OkH',503,'`0021 OkH',504,'`0021 OkH',505,'`0021 OkH',506,'`0021 OkH',507,'`0021 OkH',508,'`0021 OkH',509,'`0021 OkH',510,'`0021 OkH',511,'`0021 OkH',512,'`0021 OkH',513,'`0021 OkH',514,'`0021 OkH',515,'`0021 OkH',516,'`0021 OkH',\n517,'`0021 OkH',519,'`0021 OkH',520,'`0021 OkH',600,'`0022 OkGC',601,'`0022 OkGC',602,'`0022 OkGC',605,'`0022 OkGC',606,'`0022 OkGC',607,'`0022 OkGC',608,'`0022 OkGC',609,'`0022 OkGC',700,'`0023 EAC',701,'`0023 EAC',702,'`0023 EAC',703,'`0023 EAC',704,'`0023 EAC',705,'`0023 EAC',706,'`0023 EAC',707,'`0023 EAC',708,'`0023 EAC',709,'`0023 EAC',722,'`0023 EAC',800,'`0024 MapBB',801,'`0024 MapBB',802,'`0024 MapBB',803,'`0024 MapBB',805,'`0024 MapBB',807,'`0024 MapBB',809,'`0024 MapBB',900,'`0025 AsBir',901,\n'`0025 AsBir',902,'`0025 AsBir',903,'`0025 AsBir',904,'`0025 AsBir',905\n,'`0025 AsBir',910,'`0026 AlMap',\n911,'`0026 AlMap',912,'`0026 AlMap',920,'`0027 WOk',921,'`0027 WOk',922,'`0027 WOk',923,'`0027 WOk',924,'`0027 WOk',925,'`0027 WOk',926,'`0027 WOk',931,'`0027 WOk',932,'`0027 WOk',933,'`0027 WOk',934,'`0027 WOk',935,'`0027 WOk',940,'`0028 TanoakL',941,'`0028 TanoakL',942,'`0028 TanoakL',943,'`0028 TanoakL',960,'`0029 OtHw',961,'`0029 OtHw',962,'`0029 OtHw',970,'`0030 WdldHw',971,'`0030 WdldHw',972,'`0030 WdldHw',973,'`0030 WdldHw',974,'`0030 WdldHw',975,'`0030 WdldHw',976,'`0030 WdldHw',980,'`0031 TropHw',981,'`0031 TropHw',982,'`0031 TropHw',983,'`0031 TropHw',989,'`0031 TropHw',990,'`0032 ExHd',991,'`0032 ExHd',992,'`0032 ExHd',993,'`0032 ExHd',995,'`0032 ExHd',999,'`0033 Nons','`0034 Other') |
| Growing-stock stocking |
C.GSSTKCD |
Growing-stock stocking code. A code indicating the stocking of the condition by growing-stock trees, including seedlings. Growing-stock trees are those where tree class (TREE.TREECLCD) equals 2 or,\nfor seedlings that do not have tree class assigned where species group (TREE.SPGRPCD) is not equal to\n23 (western woodland softwoods), 43 (eastern noncommercial hardwoods), and 48 (western woodland hardwoods). Populated for all forest annual plots, all forest periodic plots, and all NCRS periodic plots that were measured as "nonforest with trees" (e.g., wooded pasture, windbreaks).<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>1</td><td>Overstocked (100+ %)</td></tr>\n<tr><td>2</td><td>Fully stocked (60-99%)</td></tr>\n<tr><td>3</td><td>Medium stocked (35-59%)</td></tr>\n<tr><td>4</td><td>Poorly stocked (10-34%)</td></tr>\n<tr><td>5</td><td>Nonstocked (0-9%)</td></tr>\n</table><br> |
N |
case cond.gsstkcd when 1 then '`0001 Overstocked' when 2 then '`0002 Fully stocked' when 3 then '`0003 Medium stocked' when 4 then '`0004 Poorly stocked' when 5 then '`0005 Nonstocked' when -1 then '`0006 Unavailable' else '`0007 Other' end |
| Height |
T.HT |
Total height. (Core Phase 2: =5.0-inch DBH/DRC live trees; Core optional Phase 2: 1.0-4.9-inch DBH/DRC live trees and =5.0-inch DBH/DRC standing dead trees. Core Phase 3: =1.0-inch DBH/DRC live trees; Core optional Phase 3: =5.0 inch DBH/DRC standing dead trees.) The total length (height) of a sample tree (in feet) from the ground to the tip of the apical meristem. The total length of a tree is not always its actual length. If the main stem is broken,\nthe actual length is measured or estimated and the missing piece is added to the actual length to estimate total length. The amount added is determined by measuring the broken\npiece if it can be located on the ground; otherwise it is estimated. The minimum height for timber species is 5 feet and for woodland species is 1 foot.<br> |
N |
case coalesce(tree.ht,-1) when -1 then '`0012 Not available' when least(tree.ht,10) then '`0001 0-10 feet' when least(tree.ht,20) then '`0002 10-20 feet' when least(tree.ht,30) then '`0003 20-30 feet' when least(tree.ht,40) then '`0004 30-40 feet' when least(tree.ht,50) then '`0005 40-50 feet' when least(tree.ht,60) then '`0006 50-60 feet' when least(tree.ht,70) then '`0007 60-70 feet' when least(tree.ht,80) then '`0008 70-80 feet' when least(tree.ht,90) then '`0009 80-90 feet' when least(tree.ht,100) then '`0010 90-100 feet' else '`0011 100+ feet' end |
| HeightFAA |
T.HT |
HeightFAA- |
N |
case coalesce(tree.ht,-1) when -1 then '`0010 Not available' when least(tree.ht,50) then '`0001 0-50 feet' when least(tree.ht,100) then '`0002 50-100 feet' when least(tree.ht,150) then '`0003 100-150 feet' when least(tree.ht,200) then '`0004 150-200 feet' when least(tree.ht,250) then '`0005 200-250 feet' when least(tree.ht,300) then '`0006 250-300 feet' when least(tree.ht,350) then '`0007 300-350 feet' when least(tree.ht,400) then '`0008 350-400 feet' else '`0009 400+ feet' end |
| Hydrological Unit Code 8 |
PG.HUC |
Hydrological Unit Code 8. The United States is divided and sub-divided into successively smaller hydrologic units which are classified into four levels: regions, sub-regions, accounting units, and cataloging units. The hydrologic units are arranged within each other, from the smallest (cataloging units) to the largest (regions). Each hydrologic unit is identified by a unique hydrologic unit code (HUC) consisting of two to eight digits based on the four levels of classification in the hydrologic unit system.<br>\nThe fourth level of classification is the cataloging unit (HUC8), the smallest element in the hierarchy of hydrologic units. A cataloging unit is a geographic area representing part of all of a surface drainage basin, a combination of drainage basins,\nor a distinct hydrologic feature. These units subdivide the subregions and\naccounting units into smaller areas. There are 2264 Cataloging Units in the Nation. Cataloging Units sometimes are called watersheds.<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.hucLabel(cast(plotgeom.huc as integer)) |
| Inventory subcycle number |
C.SUBCYCLE |
Inventory subcycle number. For an annual inventory that takes n years to measure all plots, subcycle shows in which of the n years of the cycle the data were measured. Subcycle is 0 for a periodic inventory. Subcycle 99 may be used for plots that are not included in the estimation process. |
N |
case cond.subcycle when 1 then '`0001 Subcycle 1' when 2 then '`0002 Subcycle 2' when 3 then '`0003 Subcycle 3' when 4 then '`0004 Subcycle 4' when 5 then '`0005 Subcycle 5' when 6 then '`0006 Subcycle 6' when 7 then '`0007 Subcycle 7' when 8 then '`0008 Subcycle 8' when 9 then '`0009 Subcycle 9' when 10 then '`0010 Subcycle 10' else '`0011 Other' end |
| Inventory year |
C.INVYR |
Inventory year |
N |
case coalesce(cond.invyr, 0)when 2030 then '0001 2030' when 2029 then '0002 2029' when 2028 then '0003 2028' when 2027 then '0004 2027' when 2026 then '0005 2026'when 2025 then '0006 2025' when 2024 then '0007 2024' when 2023 then '0008 2023' when 2022 then '0009 2022' when 2021 then '0010 2021'when 2020 then '0011 2020' when 2019 then '0012 2019' when 2018 then '0013 2018' when 2017 then '0014 2017' when 2016 then '0015 2016'when 2015 then '0016 2015' when 2014 then '0017 2014' when 2013 then '0018 2013' when 2012 then '0019 2012' when 2011 then '0020 2011'when 2010 then '0021 2010' when 2009 then '0022 2009' when 2008 then '0023 2008' when 2007 then '0024 2007' when 2006 then '0025 2006'when 2005 then '0026 2005' when 2004 then '0027 2004' when 2003 then '0028 2003' when 2002 then '0029 2002' when 2001 then '0030 2001'when 2000 then '0031 2000' when 1999 then '0032 1999' when 1998 then '0033 1998' when 1997 then '0034 1997' when 1996 then '0035 1996'when 1995 then '0036 1995' when 1994 then '0037 1994' when 1993 then '0038 1993' when 1992 then '0039 1992' when 1991 then '0040 1991'when 1990 then '0041 1990' when 1989 then '0042 1989' when 1988 then '0043 1988' when 1987 then '0044 1987' when 1986 then '0045 1986'when 1985 then '0046 1985' when 1984 then '0047 1984' when 1983 then '0048 1983' when 1982 then '0049 1982' when 1981 then '0050 1981'when 1980 then '0051 1980' else '0023 Other' end |
| Land Use - Major |
C.MLU |
Land use - Major is based on condition status code, reserve code, and site class code.<br>\nCondition status code. A code indicating the basic land cover.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>1</td><td>Forest land - Land with at least 10 percent cover (or equivalent stocking) by live trees of any size, including land that formerly had such tree cover and that will be naturally or artificially regenerated. To qualify, the area must be at least 1.0 acre in size and 120.0 feet wide. Forest land includes transition zones, such as areas between forest and nonforest\nlands that have at least 10 percent cover (or equivalent stocking) with live trees and forest areas adjacent to urban and built-up lands. Roadside, streamside, and shelterbelt strips of trees must have a width of at least 120 feet and continuous length of at least 363 feet to qualify as forest land. Unimproved roads and trails,\nstreams, and clearings in\nforest areas are classified as forest if they are <120 feet wide or an acre in size. Tree-covered areas in agricultural production settings, such as fruit orchards, or tree-covered areas in urban settings, such as city parks, are not considered forest land.</td></tr>\n<tr><td>2</td><td>Nonforest land - Any land within the sample that does not meet the definition of accessible forest land or any of the other types of basic land covers. To qualify, the area must be at least 1.0 acre in size and 120.0 feet wide, with some exceptions that are described in the document "Forest inventory and analysis\nnational core field guide, volume 1: field data collection procedures for Phase 2 plots,\nversion 4.0." (http://www.fia.fs.fed.us/library/field-guides-methods-proc/.) Evidence of "possible" or future development\nor conversion is not considered. A nonforest land condition will remain in the sample and will be examined at the next occasion to see if it has become forest land. </td></tr>\n<tr><td>3</td><td>Noncensus water - Lakes, reservoirs, ponds, and similar bodies of water 1.0 acre to 4.5 acre in size. Rivers, streams, canals, etc., 30.0 feet to 200 feet wide (1990 U.S. Census definition - U.S. Census Bureau 1994). This definition was used in the 1990 census and applied when the data became available. Earlier inventories defined noncensus water differently.</td></tr>\n<tr><td>4</td><td>Census water - Lakes, reservoirs, ponds, and similar bodies of water 4.5 acre in size and larger; and rivers, streams, canals, etc.,\nmore than 200 feet wide (1990 U.S. Census definition; U.S. Census Bureau 1994).</td></tr>\n<tr><td>5</td><td>Nonsampled - Any portion of a plot within accessible forest land that cannot be sampled is delineated as a separate condition. There is no minimum size requirement. The reason the condition was not sampled is provided in COND_NONSAMPLE_REASN_CD.</td></tr>\n</table><br>\nReserved status code.\nReserved land is land that is withdrawn by law(s) prohibiting the management of the land for the production of wood products. \n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>0</td><td>Not reserved</td></tr>\n<tr><td>1</td><td>Reserved</td></tr>\n</table><br>\nSite productivity class code. A classification of forest land in terms of inherent capacity to grow crops of industrial wood. Identifies the\npotential growth in cubic feet\n/acre/year and is based on the culmination of mean annual increment of fully stocked natural stands.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>1</td><td>225+ cubic feet/acre/year</td></tr>\n<tr><td>2</td><td>165-224 cubic feet/acre/year</td></tr>\n<tr><td>3</td><td>120-164 cubic feet/acre/year</td></tr>\n<tr><td>4</td><td>85-119 cubic feet/acre/year</td></tr>\n<tr><td>5</td><td>50-84 cubic feet/acre/year</td></tr>\n<tr><td>6</td><td>20-49 cubic feet/acre/year</td></tr>\n<tr><td>7</td><td>0-19 cubic feet/acre/year</td></tr>\n</table><br> |
N |
case cond.cond_status_cd*100+coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0) when 101 then '`0001 Timberland' when 102 then '`0001 Timberland' when 103 then '`0001 Timberland' when 104 then '`0001 Timberland' when 105 then '`0001 Timberland' when 106 then '`0001 Timberland' when 107 then '`0003 Other forestland' when 111 then '`0002 Reserved Forestland' when 112 then '`0002 Reserved Forestland' when 113 then '`0002 Reserved Forestland' when 114 then '`0002 Reserved Forestland' when 115 then '`0002 Reserved Forestland' when 116 then '`0002 Reserved Forestland' when 117 then '`0002 Reserved Forestland' when least(cond.cond_status_cd*100 +coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0),199) then '`0011 Forest (bad reservcd or siteclcd)' when least(cond.cond_status_cd*100 +coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0),299) then '`0004 Nonforest' when least(cond.cond_status_cd*100 +coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0),399)\nthen '`0005 Non-Census water' when least(cond.cond_status_cd*100 +coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0),499) then '`0006 Census water' else case cond.cond_nonsample_reasn_cd when 1 then '`0007 Outside U.S. boundary' when 2 then '`0008 Denied access' when 3 then '`0009 Hazardous' else '`0010 Other' end end |
| Land class |
C.COND_STATUS_CD |
Condition status code. A code indicating the basic land cover.\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>1</td><td>Forest land - Land with at least 10 percent cover (or equivalent stocking) by live trees of any size, including land that formerly had such tree cover and that will be naturally or artificially regenerated. To qualify, the area must be at least 1.0 acre in size and 120.0 feet wide. Forest land includes transition zones, such as areas between forest and nonforest lands that have at least 10 percent cover (or equivalent stocking) with live trees and forest areas adjacent to urban and built-up lands. Roadside, streamside, and shelterbelt strips of trees must have a width of at least 120 feet and continuous length of at least 363 feet to qualify as forest land. Unimproved roads and trails, streams,\nand clearings in forest areas are classified as forest if they are <120 feet wide or an acre in size. Tree-covered areas in\nagricultural production settings, such as fruit orchards, or tree-covered areas in urban settings, such as city parks, are not considered forest land. For data collected prior to annual inventory (PLOT.MANUAL <1.0), the definition for forest land may have been slightly different (for example, in the past some FIA work units used 5 percent cover rather than 10 percent.)</td></tr>\n<tr><td>2</td><td>Nonforest land - Any land within the sample that does\nnot meet the definition of accessible forest land or any of the other types of basic land covers. To qualify, the area must be at least 1.0 acre in size and 120.0 feet wide, with some exceptions that are described in the document "Forest inventory and analysis national core field guide, volume 1: field data collection procedures for Phase 2 plots,\nversion 4.0." (http://www.fia.fs.fed.us/library/field-guides-methods-proc/.) Evidence of "possible" or future development or conversion is not considered. A nonforest land condition will remain in the\nsample and will be examined at the next occasion to see if it has become forest land. </td></tr>\n<tr><td>3</td><td>Noncensus water - Lakes, reservoirs, ponds, and similar bodies of water 1.0 acre to 4.5 acre in size. Rivers, streams, canals, etc., 30.0 feet to 200 feet wide (1990 U.S. Census definition - U.S. Census Bureau 1994). This definition was used in the 1990 census and applied when the data became available. Earlier inventories defined noncensus water differently.</td></tr>\n<tr><td>4</td><td>Census water - Lakes, reservoirs, ponds, and similar bodies of water 4.5 acre in size and larger; and rivers, streams, canals, etc.,\nmore than 200 feet wide (1990 U.S. Census definition; U.S. Census Bureau 1994).</td></tr>\n<tr><td>5</td><td>Nonsampled - Any portion of a plot within accessible forest land that cannot be sampled is delineated as a separate condition. There is no minimum size requirement. The reason the condition was not sampled is provided in\nCOND_NONSAMPLE_REASN_CD.</td></tr>\n</table><br> |
N |
case coalesce(cond.cond_status_cd,-1) when 1 then '`0001 Accessible forest' when 2 then '`0002 Nonforest' when 3 then '`0003 Noncensus water' when 4 then '`0004 Census water' when 5 then '`0005 Denied access' when 6 then '`0006 Hazardous' when 7 then '`0007 Not in sample' when -1 then '`0008 Not available' else '`0009 Other' end |
| Land use |
C.MLU |
Land use is based on condition status code, reserve code, and site class code.<br>\nCondition status code. A code indicating the basic land cover.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>1</td><td>Forest land - Land with at least 10 percent cover (or equivalent stocking) by live trees of any size, including land that formerly had such tree cover and that will be naturally or artificially regenerated. To qualify, the area must be at least\n1.0 acre in size and 120.0 feet wide. Forest land includes transition zones, such as areas between forest and nonforest lands that have at least 10 percent cover (or equivalent stocking) with live trees and forest areas adjacent to urban and built-up lands. Roadside, streamside, and shelterbelt strips of trees must have a width of at least 120 feet and continuous length of at least 363 feet to qualify as forest land. Unimproved roads and trails, streams,\nand clearings in forest\nareas are classified as forest if they are <120 feet wide or an acre in size. Tree-covered areas in agricultural production settings, such as fruit orchards, or tree-covered areas in urban settings, such as city parks, are not considered forest land.</td></tr>\n<tr><td>2</td><td>Nonforest land - Any land within the sample that does not meet the definition of accessible forest land or any of the other types of basic land covers. To qualify, the area must be at\nleast 1.0 acre in size and 120.0 feet wide, with some exceptions that are described in the document "Forest\ninventory and analysis national core field guide\n, volume 1: field data collection procedures for Phase 2 plots,\nversion 4.0." (http://www.fia.fs.fed.us/library/field-guides-methods-proc/.) Evidence of "possible" or future development or conversion is not considered. A nonforest land condition will remain in the sample and will be examined at the next occasion to see if it has become forest land. </td></tr>\n<tr><td>3</td><td>Noncensus water - Lakes, reservoirs, ponds, and similar bodies of water 1.0 acre to 4.5 acre in size. Rivers, streams, canals, etc., 30.0 feet to 200 feet wide (1990 U.S. Census definition - U.S. Census Bureau 1994). This definition was used in the 1990 census and applied when the data became available. Earlier inventories defined noncensus water differently.</td></tr>\n<tr><td>4</td><td>Census water - Lakes, reservoirs, ponds, and similar bodies of water 4.5 acre in size and larger; and rivers, streams, canals, etc.,\nmore than 200 feet wide (1990 U.S. Census definition; U.S. Census Bureau 1994).</td></tr>\n<tr><td>5</td><td>Nonsampled - Any portion of a plot within accessible forest land that cannot be sampled is delineated as a separate condition. There is no minimum size requirement. The reason the condition was not sampled is provided in COND_NONSAMPLE_REASN_CD.</td></tr>\n</table><br>\nReserved status code.\nReserved land is land that is withdrawn by law(s) prohibiting the management of the land for the production of wood products. \n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>0</td><td>Not reserved</td></tr>\n<tr><td>1</td><td>Reserved</td></tr>\n</table><br>\nSite productivity class code. A classification of forest land in terms of inherent capacity to grow crops of industrial wood. Identifies the potential growth in cubic feet\n/acre/year and is based on the culmination of mean annual increment of fully stocked natural stands.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>1</td><td>225+ cubic feet/acre/year</td></tr>\n<tr><td>2</td><td>165-224 cubic feet/acre/year</td></tr>\n<tr><td>3</td><td>120-164 cubic feet/acre/year</td></tr>\n<tr><td>4</td><td>85-119 cubic feet/acre/year</td></tr>\n<tr><td>5</td><td>50-84 cubic feet/acre/year</td></tr>\n<tr><td>6</td><td>20-49 cubic feet/acre/year</td></tr>\n<tr><td>7</td><td>0-19 cubic feet/acre/year</td></tr>\n</table><br> |
N |
case cond.cond_status_cd*100+coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0) when 101 then '`0001 Timberland' when 102 then '`0001 Timberland' when 103 then '`0001 Timberland' when 104 then '`0001 Timberland' when 105 then '`0001 Timberland' when 106 then '`0001 Timberland' when 107 then '`0002 Other forestland' when 108 then '`0002 Other forestland' when 111 then '`0003 Reserved productive forestland' when 112 then '`0003 Reserved productive forestland' when 113 then '`0003 Reserved productive forestland' when 114 then '`0003 Reserved productive forestland' when 115 then '`0003 Reserved productive forestland' when 116 then '`0003 Reserved productive forestland' when 117 then '`0004 Reserved other forestland' when least(cond.cond_status_cd*100+coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0),199) then '`0012 Forest (bad reservcd or siteclcd)' when least(cond.cond_status_cd*100 +coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0),299)\nthen '`0005 Nonforest' when least(cond.cond_status_cd*100 +coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0),399) then '`0006 Non-Census water' when least(cond.cond_status_cd*100 +coalesce(cond.reservcd,0)*10+coalesce(cond.siteclcd,0),499) then '`0007 Census water' else case cond.cond_nonsample_reasn_cd when 1 then '`0008 Outside U.S. boundary' when 2 then '`0009 Denied access' when 3 then '`0010 Hazardous' else '`0011 Other' end end |
| Major region |
C.REGIONCD |
Major region-\n<table>\n<tr><td>REGION</td><td>STATECD</td></tr>\n<tr><td>Interior Alaska</td><td>Alaska</td></tr>\n<tr><td>North</td><td>Connecticut</td></tr>\n<tr><td>North</td><td>Delaware</td></tr>\n<tr><td>North</td><td>Illinois</td></tr>\n<tr><td>North</td><td>Indiana</td></tr>\n<tr><td>North</td><td>Iowa</td></tr>\n<tr><td>North</td><td>Maine</td></tr>\n<tr><td>North</td><td>Maryland</td></tr>\n<tr><td>North</td><td>Massachusetts</td></tr>\n<tr><td>North</td><td>Michigan</td></tr>\n<tr><td>North</td><td>Minnesota</td></tr>\n<tr><td>North</td><td>Missouri</td></tr>\n<tr><td>North</td><td>New Hampshire</td></tr>\n<tr><td>North</td><td>New Jersey</td></tr>\n<tr><td>North</td><td>New York</td></tr>\n<tr><td>N\north</td><td>Ohio</td></tr>\n<tr><td>North</td><td>Pennsylvania</td></tr>\n<tr><td>North</td><td>Rhode Island</td></tr>\n<tr><td>North</td><td>Vermont</td></tr>\n<tr><td>North</td><td>West Virginia</td></tr>\n<tr><td>North</td><td>Wisconsin</td></tr>\n<tr><td>Pacific Coast</td><td>California</td></tr>\n<tr><td>Pacific Coast</td><td>Hawaii</td></tr>\n<tr><td>Pacific Coast</td><td>Oregon</td></tr>\n<tr><td>Pacific Coast</td><td>Washington</td></tr>\n<tr><td>Rocky Mountain</td><td>Arizona</td></tr>\n<tr><td>Rocky Mountain</td><td>Colorado</td></tr>\n<tr><td>Rocky Mountain</td><td>Idaho</td></tr>\n<tr><td>Rocky Mountain</td><td>Kansas</td></tr>\n<tr><td>Rocky Mountain</td><td>Montana</td></tr>\n<tr><td>Rocky Mountain</td><td>Nebraska</td></tr>\n<tr><td>R\nocky Mountain</td><td>Nevada</td></tr>\n<tr><td>Rocky Mountain</td><td>New Mexico</td></tr>\n<tr><td>Rocky Mountain</td><td>North Dakota</td></tr>\n<tr><td>Rocky Mountain</td><td>South Dakota</td></tr>\n<tr><td>Rocky Mountain</td><td>Utah</td></tr>\n<tr><td>Rocky Mountain</td><td>Wyoming</td></tr>\n<tr><td>South</td><td>Alabama</td></tr>\n<tr><td>South</td><td>Arkansas</td></tr>\n<tr><td>South</td><td>Florida</td></tr>\n<tr><td>South</td><td>Georgia</td></tr>\n<tr><td>South</td><td>Kentucky</td></tr>\n<tr><td>South</td><td>Louisiana</td></tr>\n<tr><td>South</td><td>Mississippi</td></tr>\n<tr><td>South</td><td>North Carolina</td></tr>\n<tr><td>South</td><td>Oklahoma</td></tr>\n<tr><td>South</td><td>South Carolina</td></tr>\n<tr><td>South</td><td>Tenne\nssee</td></tr>\n<tr><td>South</td><td>Texas</td></tr>\n<tr><td>South</td><td>Virginia</td></tr>\n</table><br> |
N |
case COND.STATECD WHEN 1 THEN '0002 South' WHEN 2 THEN '0005 Interior Alaska' WHEN 4 THEN '0003 Rocky Mountain' WHEN 5 THEN '0002 South' WHEN 6 THEN '0004 Pacific Coast' WHEN 8 THEN '0003 Rocky Mountain' WHEN 9 THEN '0001 North' WHEN 10 THEN '0001 North' WHEN 12 THEN '0002 South' WHEN 13 THEN '0002 South' WHEN 15 THEN '0004 Pacific Coast' WHEN 16 THEN '0003 Rocky Mountain' WHEN 17 THEN '0001 North' WHEN 18 THEN '0001 North' WHEN 19 THEN '0001 North' WHEN 20 THEN '0003 Rocky Mountain' WHEN 21 THEN '0002 South' WHEN 22 THEN '0002 South' WHEN 23 THEN '0001 North' WHEN 24 THEN '0001 North' WHEN 25 THEN '0001 North' WHEN 26 THEN '0001 North' WHEN 27 THEN '0001 North' WHEN 28 THEN '0002 South' WHEN 29 THEN '0001 North' WHEN 30 THEN '0003 Rocky Mountain' WHEN 31 THEN '0003 Rocky Mountain' WHEN 32 THEN '0003 Rocky Mountain' WHEN 33 THEN '0001 North' WHEN 34 THEN '0001 North' WHEN 35 THEN '0003 Rocky Mountain' WHEN 36 THEN '0001 North' WHEN 37 THEN '0002 South' WHEN 38 THEN '0003 Rocky Mountain' WHEN 39 THEN '0001 North' WHEN 40 THEN '0002 South' WHEN 41 THEN '0004 Pacific Coast' WHEN 42 THEN '0001 North' WHEN 44 THEN '0001 North' WHEN 45 THEN '0002 South' WHEN 46 THEN '0003 Rocky Mountain' WHEN 47 THEN '0002 South' WHEN 48 THEN '0002 South' WHEN 49 THEN '0003 Rocky Mountain' WHEN 50 THEN '0001 North' WHEN 51 THEN '0002 South' WHEN 53 THEN '0004 Pacific Coast' WHEN 54 THEN '0001 North' WHEN 55 THEN '0001 North' WHEN 56 THEN '0003 Rocky Mountain' ELSE '`0006 Other' END |
| NFS Region ALP |
PG.ALP_ADFORCD |
NFS Region as derived from ALP layer. Administrative forest code. Identifies the administrative unit (Forest Service Region and National Forest) in which the plot center is located. The first two digits of the four digit code are for the region number and the last two digits are for the Administrative National Forest number. based solely on the most recent ALP layers (BASICOWNERSHIP and ADMINISTRATIVEFOREST) and the exact plot location. A plot can be assigned an ADFORCD irrespective of the plot's OWNCD value(s). |
N |
case trunc(PLOTGEOM.alp_adforcd/100) when 1 then '`0001 R01' when 2 then '`0002 R02' when 3 then '`0003 R03' when 4 then '`0004 R04' when 5 then '`0005 R05' when 6 then '`0006 R06' when 7 then '`0007 R07' when 8 then '`0008 R08' when 9 then '`0009 R09' when 10 then '`0010 R10 SE Alaska' else '`0011 Other' end |
| National Forests |
C.ADFORCD |
Administrative Forest: FIA. Administrative forest code. Identifies the administrative unit (Forest Service Region and National Forest) in which the condition is located. The first two digits of the four digit code are for the\nregion number and the last two digits are for the Administrative National Forest number. This value is based on field crew data collected at the time of plot measurement.<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.adforcdLabel(cond.adforcd) |
| National Forests: ALP |
PG.ALP_ADFORCD |
Administrative forest code. Identifies the administrative unit (Forest Service Region and National Forest) in which the plot center is located. The first two digits of the four digit code are for the region number and the last two digits are for the Administrative National Forest number. based solely on the most recent ALP layers (BASICOWNERSHIP and ADMINISTRATIVEFOREST) and the exact plot location. A plot can be assigned an ADFORCD irrespective of the plot's OWNCD value(s). |
N |
FS_FIADB.EVALIDATORFUNCTIONS.alp_adforcdLabel(cast(plotgeom.alp_adforcd as integer)) |
| Net cubic foot volume in tree |
T.VOLCFNET |
Net cubic-foot volume. For timber species (trees where the diameter is measured at breast height [DBH]), this is the net volume of wood in the central stem of a sample tree =5.0 inches in diameter, from a 1-foot stump to a minimum 4-inch top diameter,\nor to where the central stem breaks into limbs all of which are <4.0 inches in diameter. For woodland species (trees where the diameter is measured at\nroot collar [DRC]), VOLCFNET is the net volume of wood and bark from the DRC measurement point(s) to a 1 ? -inch top diameter; includes branches that are at least 1? inches in diameter along the length of the branch.<br> |
Y |
case coalesce(tree.volcfnet,-1) when -1 then '`0013 Not available' when least(tree.volcfnet,5.0) then '`0001 0-5' when least(tree.volcfnet,10.0) then '`0002 5-10' when least(tree.volcfnet,20) then '`0003 10-20' when least(tree.volcfnet,30) then '`0004 20-30' when least(tree.volcfnet,40) then '`0005 30-40' when least(tree.volcfnet,50) then '`0006 40-50' when least(tree.volcfnet,100) then '`0007 50-100' when least(tree.volcfnet,200) then '`0008 100-200' when least(tree.volcfnet,300) then '`0009 200-300' when least(tree.volcfnet,400) then '`0010 300-400' when least(tree.volcfnet,500) then '`0011 400-500' else '`0012 500+' end |
| Ownership all classes |
C.OWNCD |
Owner class code. (Core for all accessible forestland; Core optional for other sampled land.) A code indicating the class in which the landowner (at the time of the inventory) belongs. When PLOT.DESIGNCD = 999, OWNCD may be blank (null).<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>11</td><td>National Forest</td></tr>\n<tr><td>12</td><td>National Forest</td></tr>\n<tr><td>13</td><td>National Forest</td></tr>\n<tr><td>21</td><td>National Park Service</td></tr>\n<tr><td>22</td><td>Bureau of Land Management</td></tr>\n<tr><td>23</td><td>Fish and Wildlife Service</td></tr>\n<tr><td>24</td><td>Department of Defense/Energy</td></tr>\n<tr><td>25</td><td>Other federal</td></tr>\n<tr><td>31</td><td>State</td></tr>\n<tr><td>32</td><td>Local (County, Municipal,\netc)</td></tr>\n<tr><td>33</td><td>Other non-federal public</td></tr>\n<tr><td>46</td><td>Undifferentiated private</td></tr>\n<table><br> |
N |
case cond.owncd when 11 then '`0001 National Forest' when 12 then '`0001 National Forest' when 13 then '`0001 National Forest' when 21 then '`0002 National Park Service' when 22 then '`0003 Bureau of Land Mgmt' when 23 then '`0004 Fish and Wildlife Service' when 24 then '`0005 Dept of Defense' when 25 then '`0006 Other federal' when 31 then '`0007 State' when 32 then '`0008 County and Municipal' when 33 then '`0009 Other local govt' when 41 then '`0010 Private' when 42 then '`0010 Private' when 43 then '`0010 Private' when 44 then '`0010 Private' when 45 then '`0010 Private' when 46 then '`0010 Private' when -1 then '`0011 Unavailable' else '`0012 Other' end |
| Ownership class |
C.OWNCD |
Owner class code. (Core for all accessible forestland; Core optional for other sampled land.) A code indicating the class in which the landowner (at the time of the inventory) belongs. When PLOT.DESIGNCD = 999, OWNCD may be blank (null).<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>11</td><td>National Forest</td></tr>\n<tr><td>12</td><td>National Forest</td></tr>\n<tr><td>13</td><td>National Forest</td></tr>\n<tr><td>21</td><td>National Park Service</td></tr>\n<tr><td>22</td><td>Bureau of Land Management</td></tr>\n<tr><td>23</td><td>Fish and Wildlife Service</td></tr>\n<tr><td>24</td><td>Department of Defense/Energy</td></tr>\n<tr><td>25</td><td>Other federal</td></tr>\n<tr><td>31</td><td>State</td></tr>\n<tr><td>32</td><td>Local (County, Municipal,\netc)</td></tr>\n<tr><td>33</td><td>Other non-federal public</td></tr>\n<tr><td>46</td><td>Undifferentiated private</td></tr>\n<table><br> |
N |
case cond.owncd when 11 then '`0001 National Forest' when 12 then '`0001 National Forest' when 13 then '`0001 National Forest' when 21 then '`0002 National Park Service' when 22 then '`0003 Bureau of Land Mgmt' when 23 then '`0004 Fish and Wildlife Service' when 24 then '`0005 Dept of Defense' when 25 then '`0006 Other federal' when 31 then '`0007 State' when 32 then '`0008 County and Municipal' when 33 then '`0009 Other local govt' when 41 then '`0010 Private' when 42 then '`0010 Private' when 43 then '`0010 Private' when 44 then '`0010 Private' when 45 then '`0010 Private' when 46 then '`0010 Private' when -1 then '`0011 Unavailable' else '`0012 Other' end |
| Ownership group |
C.OWNGRPCD |
Owner group code. (Core for all accessible forestland; Core optional for other sampled land.) A broader group of landowner classes. When PLOT.DESIGNCD = 999, OWNGRPCD may be blank (null). <br>\n<table>\n<tr><td>Code</td><td>Description<td></tr>\n<tr><td>10</td><td>Forest Service (OWNCD 11, 12,\n13)<td></tr>\n<tr><td>20</td><td>Other federal (OWNCD 21, 22, 23, 24, 25)<td></tr>\n<tr><td>30</td><td>State and local government (OWNCD 31, 32, 33)<td></tr>\n<tr><td>40</td><td>Private (OWNCD 41, 42, 43, 44, 45, 46)<td></tr>\n<table><br> |
N |
case coalesce(cond.owngrpcd,-1) when 10 then '`0001 National Forest' when 20 then '`0002 Other federal' when 30 then '`0003 State and local' when 40 then '`0004 Private' when -1 then '`0005 Not available' else '`0006 Other' end |
| Ownership group - Major |
C.OWNGRPCD |
Owner group major - ownership codes are collapsed into Public and Private categories. |
N |
case coalesce(cond.owngrpcd,-1) WHEN 10 THEN '`0001 Public' WHEN 20 THEN '`0001 Public' WHEN 30 THEN '`0001 Public' WHEN 40 THEN '`0002 Private' \nwhen -1 then '`0003 Not available' ELSE '`0004 Unknown' END |
| Ownership group - NFS and other |
C.OWNGRPCD |
Owner group NFS and other |
N |
case coalesce(cond.owngrpcd,-1) when 10 then '`0001 National Forest' else '`0002 Other' end |
| Ownership with all FS classes |
C..OWNCD |
Ownership all classes. (Core for all accessible forestland; Core optional for other sampled land.) A code indicating the class in which the landowner (at the time of the inventory) belongs. When PLOT.DESIGNCD = 999, OWNCD may be blank (null).<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>11</td><td>National Forest System</td></tr>\n<tr><td>12</td><td>National Grassland</td></tr>\n<tr><td>13</td><td>Other Forest Service</td></tr>\n<tr><td>21</td><td>National Park Service</td></tr>\n<tr><td>22</td><td>Bureau of Land Management</td></tr>\n<tr><td>23</td><td>Fish and Wildlife Service</td></tr>\n<tr><td>24</td><td>Department of Defense/Energy</td></tr>\n<tr><td>25</td><td>Other federal</td></tr>\n<tr><td>31</td><td>State</td></tr>\n<tr><td>32</td><td>Local (County, Municipal,\netc)</td></tr>\n<tr><td>33</td><td>Other non-federal public</td></tr>\n<tr><td>46</td><td>Undifferentiated private</td></tr>\n<table><br> |
N |
case coalesce(cond.owncd,-1) when 11 then '`0001 National Forest System' when 12 then '`0002 National Forest Grassland' when 13 then '`0003 Other Forest Service' when 21 then '`0004 National Park Service' when 22 then '`0005 Bureau of Land Mgmt' when 23 then '`0006 Fish and Wildlife Service' when 24 then '`0007 Dept of Defense' when 25 then '`0008 Other federal' when 31 then '`0009 State' when 32 then '`0010 County and Municipal' when 33 then '`0011 Other Local Govt' when 41 then '`0012 Private' when 42 then '`0012 Private' when 43 then '`0012 Private' when 44 then '`0012 Private' when 45 then '`0012 Private' when 46 then '`0012 Private' when -1 then '`0013 Not available' else '`0014 Other' end |
| Physiographic class |
C.PHYSCLCD |
Physiographic class code. The general effect of land form, topographical position, and soil on moisture available to trees. These codes are new in annual inventory; older inventories have been updated to these codes when possible. Also\npopulated for the NCRS periodic plots that were measured as "nonforest with trees" (e.g., wooded pasture, windbreaks).<br><td></tr>\n<tr><td>Code</td><td>Description<td></tr>\n<tr><td></td><td>Xeric sites (normally low or deficient in available moisture) codes 11-19<br><td></tr>\n<tr><td></td><td>Mesic sites\n(normally moderate but adequate available moisture) codes 21-29,\nbr><td></tr>\n<tr><td></td><td>Hydric sites (normally abundant or overabundant moisture all year) codes 31-39<br><td></tr>\n<tr><td><table></td><td><td></tr>\n<tr><td>11</td><td>Dry Tops - Ridge tops with thin rock outcrops and considerable exposure to sun and wind.<td></tr>\n<tr><td>12</td><td>Dry Slopes - Slopes with thin rock outcrops and considerable exposure to sun and wind. Includes most mountain/steep slopes with a southern or western exposure.<td></tr>\n<tr><td>13</td><td>Deep Sands - Sites with a deep, sandy\nsurface subject to rapid loss of moisture following precipitation. Typical examples include sand hills, ridges, and flats in the South,\nsites along the beach and shores of lakes and streams.<td></tr>\n<tr><td>19</td><td>Other Xeric - All dry physiographic sites not described above.<td></tr>\n<tr><td>21</td><td>Flatwoods - Flat or fairly level sites outside of flood plains. Excludes deep sands and wet, swampy sites.<td></tr>\n<tr><td>22</td><td>Rolling Uplands - Hills and gently rolling, undulating terrain and associated small streams. Excludes deep sands, all hydric sites, and streams with associated flood plains.<td></tr>\n<tr><td>23</td><td>Moist Slopes and Coves - Moist slopes and coves with relatively deep,\nfertile soils. Often these sites have a northern or eastern exposure and are partially shielded from wind and sun. Includes moist mountain tops and saddles.<td></tr>\n<tr><td>24</td><td>Narrow flood plains/Bottomlands -\nFlood plains and bottomlands less than 1/4-mile in width along rivers and streams. These sites are normally well drained but are subjected to occasional flooding during periods of heavy or extended precipitation. Includes associated levees, benches, and terraces within a 1/4 mile limit. Excludes swamps, sloughs, and bogs.<td></tr>\n<tr><td>25</td><td>Broad Floodplains/Bottomlands - Floodplains and bottomlands ? mile or wider along rivers and streams. These sites are normally well drained but are subjected to occasional flooding during periods of heavy or extended precipitation. Includes associated levees, benches, and terraces. Excludes swamps, sloughs,\nand bogs with year-round water problems.<td></tr>\n<tr><td>29</td><td>Other Mesic - All moderately moist physiographic sites not described above.<td></tr>\n<tr><td>31</td><td>Swamps/Bogs - Low, wet, flat, forested areas usually quite extensive that are flooded for long periods except during periods of extreme\ndrought. Excludes cypress ponds and small drains.<td></tr>\n<tr><td>32</td><td>Small Drains - Narrow, stream-like, wet strands of forest land often without a well-defined stream channel. These areas are poorly drained or flooded throughout most of the year and drain the adjacent higher ground.<td></tr>\n<tr><td>33</td><td>Bays and wet pocosins - Low, wet,\nboggy sites characterized by peaty or organic soils. May be somewhat dry during periods of extended drought. Examples include sites in the Carolina bays in the Southeast United States.<td></tr>\n<tr><td>34</td><td>Beaver ponds.<td></tr>\n<tr><td>35</td><td>Cypress ponds.<td></tr>\n<tr><td>39</td><td>Other hydric - All other hydric physiographic sites.<td></tr>\n<table><br> |
N |
case coalesce(cond.physclcd,-1) when 11 then '`0001 Dry tops' when 12 then '`0002 Dry slopes' when 13 then '`0003 Deep sands' when 19 then '`0004 Other xeric' when 21 then '`0005 Flatwoods' when 22 then '`0006 Rolling uplands' when 23 then '`0007 Moist slopes and coves' when 24 then '`0008 Narrow floodplains/bottomlands' when 25 then '`0009 Broad floodplains/bottomlands' when 29 then '`0010 Other mesic' when 31 then '`0011 Swamps/bogs' when 32 then '`0012 Small drains' when 33 then '`0013 Bays and wet pocosins' when 34 then '`0014 Beaver ponds' when 35 then '`0015 Cypress ponds' when 39 then '`0016 Other hydric' when -1 then '`0017 Not available' else '`0018 Other' end |
| Present nonforest code remeasurement plots |
C.PRESNFCD |
Present nonforest code. (Core for remeasured conditions that were forest before and are now nonforest; Core optional for all conditions where current condition class status is nonforest, regardless of the previous condition.) A code indicating the current nonforest land use for conditions that were previously classified as forest but are now classified as nonforest. This attribute can be optionally recorded for all nonforest conditions,\nregardless of either past land status or whether the condition has a previous measurement. May be populated when PLOT.MANUAL <1.0. |
N |
case coalesce(cond.presnfcd,-1) when 10 then '`0001 Agricultural land' when 11 then '`0002 Cropland' when 12 then '`0003 Pasture (improved through cultural practices)' when 13 then '`0004 Idle farmland' when 14 then '`0005 Orchard' when 15 then '`0006 Christmas tree plantation' when 16 then '`0007 Maintained wildlife opening' when 17 then '`0008 Windbreak/Shelterbelt' when 20 then '`0009 Rangeland' when 30 then '`0010 Developed' when 31 then '`0011 Cultural (business, residential, other intense human activity)' when 32 then '`0012 Rights-of-way (improved road, railway, power line)' when 33 then '`0013 Recreation (park, golf course, ski run)' when 34 then '`0014 Mining' when 40 then '`0015 Other (undeveloped beach, marsh, bog,snow, ice)' when 41 then '`0016 Nonvegetated' when 42 then '`0017 Wetland' when 43 then '`0018 Beach' when 45 then '`0019 Nonforest' when -1 then case cond.cond_status_cd when 01 then '`0020 Forest (presnfcd is null)' when 02 then '`0021 Nonforest (presnfcd is null)' when 03 then '`0022 Noncensus water (presnfcd is null)' when 04 then '`0023 Census water (presnfcd is null)' when 05 then '`0024 Nonsampled (presnfcd is null)' else '`0025 Other' end end |
| Primary disturbance |
C.DSTRBCD1 |
Primary disturbance 1 code. A code indicating the kind of disturbance occurring since the last measurement or within the last 5 years for new plots. The area affected by the disturbance must be at least 1 acre in size. A significant level of disturbance\n(mortality or damage to 25 percent of the trees in the condition) is required. Populated for all forested conditions using the National Field Guide protocols (PLOT.MANUAL >=1.0) and populated by some FIA work units where PLOT.MANUAL <1.0. Codes 11, 12, 21,\nand 22 are valid where PLOT. MANUAL >=2.0.\n<table>\n<tr><td>Code</td><td>Description</td</tr>\n<tr><td>0</td><td>No visible disturbance</td</tr>\n<tr><td>10</td><td>Insect Damage</td</tr>\n<tr><td>11</td><td>Insect Damage</td</tr>\n<tr><td>12</td><td>Insect damage</td</tr>\n<tr><td>20</td><td>Disease Damage</td</tr>\n<tr><td>21</td><td>Disease damage</td</tr>\n<tr><td>22</td><td>Disease damage</td</tr>\n<tr><td>30</td><td>Fire damage</td</tr>\n<tr><td>31</td><td>Fire damage</td</tr>\n<tr><td>32</td><td>Fire damage</td</tr>\n<tr><td>40</td><td>Animal Damage</td</tr>\n<tr><td>41</td><td>Animal Damage</td</tr>\n<tr><td>42</td><td>Animal Damage</td</tr>\n<tr><td>43</td><td>Animal Damage</td</tr>\n<tr><td>44</td><td>Animal Damage</td</tr>\n<tr><td>45</td><td>Animal Damage</td</tr>\n<tr><td>46</td><td>Animal Damage</td</tr>\n<tr><td>50</td><td>Weather Damage</td</tr>\n<tr><td>51</td><td>Weather Damage</td</tr>\n<tr><td>52</td><td>Weather Damage</td</tr>\n<tr><td>53</td><td>Weather Damage</td</tr>\n<tr><td>54</td><td>Weather Damage</td</tr>\n<tr><td>60</td><td>Other</td</tr>\n<tr><td>70</td><td>Other</td</tr>\n<tr><td>80</td><td>Human-caused damage - any significant threshold of human-caused damage not described in the DISTURBANCE codes or in the TREATMENT codes.</td</tr>\n<tr><td>90</td><td>Other</td</tr>\n<tr><td>91</td><td>Other</td</tr>\n<tr><td>92</td><td>Other</td</tr>\n<tr><td>93</td><td>Other</td</tr>\n<tr><td>94</td><td>Other</td</tr>\n<tr><td>95</td><td>Other</td</tr>\n</table> |
N |
case coalesce(cond.dstrbcd1,-1) when 0 then '`0001 None' when 10 then '`0002 Insects' when 11 then '`0002 Insects' when 12 then '`0002 Insects' when 20 then '`0003 Disease' when 21 then '`0003 Disease' when 22 then '`0003 Disease' when 30 then '`0004 Fire' when 31 then '`0004 Fire' when 32 then '`0004 Fire' when 40 then '`0005 Animal' when 41 then '`0005 Animal' when 42 then '`0005 Animal' when 43 then '`0005 Animal' when 44 then '`0005 Animal' when 45 then '`0005 Animal' when 46 then '`0005 Animal' when 50 then '`0006 Weather' when 51 then '`0006 Weather' when 52 then '`0006 Weather' when 53 then '`0006 Weather' when 54 then '`0006 Weather' when 55 then '`0007 Other' when 60 then '`0007 Other' when 70 then '`0007 Other' when 80 then '`0008 Human' when -1 then '`0009 Not available' else '`0010 Other' end |
| RPA Subregion |
C.STATECD |
RPA Subregion |
N |
case plot.statecd when 1 then '`0004 South Central ' when 2 then '`0007 Alaska ' when 4 then '`0006 Intermountain ' when 5 then '`0004 South Central ' when 6 then '`0009 Pacific Southwest ' when 8 then '`0006 Intermountain ' when 9 then '`0001 Northeast ' when 10 then '`0001 Northeast ' when 11 then '`0001 Northeast ' when 12 then '`0003 Southeast ' when 13 then '`0003 Southeast ' when 15 then '`0009 Pacific Southwest ' when 16 then '`0006 Intermountain ' when 17 then '`0002 North Central ' when 18 then '`0002 North Central ' when 19 then '`0002 North Central ' when 20 then '`0005 Great Plains ' when 21 then '`0004 South Central ' when 22 then '`0004 South Central ' when 23 then '`0001 Northeast ' when 24 then '`0001 Northeast ' when 25 then '`0001 Northeast ' when 26 then '`0002 North Central ' when 27 then '`0002 North Central ' when 28 then '`0004 South Central ' when 29 then '`0002 North Central ' when 30 then '`0006 Intermountain ' when 31 then '`0005 Great Plains ' when 32 then '`0006 Intermountain ' when 33 then '`0001 Northeast ' when 34 then '`0001 Northeast ' when 35 then '`0006 Intermountain ' when 36 then '`0001 Northeast ' when 37 then '`0003 Southeast ' when 38 then '`0005 Great Plains ' when 39 then '`0002 North Central ' when 40 then '`0004 South Central ' when 41 then '`0008 Pacific Northwest ' when 42 then '`0001 Northeast ' when 44 then '`0001 Northeast ' when 45 then '`0003 Southeast ' when 46 then '`0005 Great Plains ' when 47 then '`0004 South Central ' when 48 then '`0004 South Central ' when 49 then '`0006 Intermountain ' when 50 then '`0001 Northeast ' when 51 then '`0003 Southeast ' when 53 then '`0008 Pacific Northwest ' when 54 then '`0001 Northeast ' when 55 then '`0002 North Central ' when 56 then '`0006 Intermountain ' else '`0010 other' end |
| RPA Subregion State |
P.RPA_SUBREG_STATE |
RPA Subregion State:\n<table>\n<tr><td>State</td><td>RPA SubregionState</td></tr>\n<tr><td>Alabama</td><td>South Central: Alabama</td></tr>\n<tr><td>Alaska</td><td>Alaska: Alaska</td></tr>\n<tr><td>Arizona</td><td>Intermountain: Arizona</td></tr>\n<tr><td>Arkansas</td><td>South Central: Arkansas</td></tr>\n<tr><td>California</td><td>Pacific Southwest:California</td></tr>\n<tr><td>Colorado</td><td>Intermountain: Colorado</td></tr>\n<tr><td>Connecticut</td><td>Northeast: Connecticut</td></tr>\n<tr><td>Delaware</td><td>Northeast: Delaware</td></tr>\n<tr><td>Florida</td><td>Southeast: Florida</td></tr>\n<tr><td>Georgia</td><td>Southeast: Georgia</td></tr>\n<tr><td>Hawaii</td><td>Pacific Southwest:Hawaii</td></tr>\n<tr><td>Ida\nho</td><td>Intermountain: Idaho</td></tr>\n<tr><td>Illinois</td><td>North Central: Illinois</td></tr>\n<tr><td>Indiana</td><td>North Central: Indiana</td></tr>\n<tr><td>Iowa</td><td>North Central: Iowa</td></tr>\n<tr><td>Kansas</td><td>Great Plains: Kansas</td></tr>\n<tr><td>Kentucky</td><td>South Central: Kentucky</td></tr>\n<tr><td>Louisiana</td><td>South Central: Louisiana</td></tr>\n<tr><td>Maine</td><td>Northeast: Maine</td></tr>\n<tr><td>Maryland</td><td>Northeast: Maryland</td></tr>\n<tr><td>Massachusetts</td><td>Northeast: Massachusetts</td></tr>\n<tr><td>Michigan</td><td>North Central: Michigan</td></tr>\n<tr><td>Minnesota</td><td>North Central: Minnesota</td></tr>\n<tr><td>Mississippi</td><td>South Central: Mississippi</td></tr>\n<tr\n><td>Missouri</td><td>North Central: Missouri</td></tr>\n<tr><td>Montana</td><td>Intermountain: Montana</td></tr>\n<tr><td>Nebraska</td><td>Great Plains: Nebraska</td></tr>\n<tr><td>Nevada</td><td>Intermountain: Nevada</td></tr>\n<tr><td>New Hampshire</td><td>Northeast: New Hampshire</td></tr>\n<tr><td>New Jersey</td><td>Northeast: New Jersey</td></tr>\n<tr><td>New Mexico</td><td>Intermountain: New Mexico</td></tr>\n<tr><td>New York</td><td>Northeast: New York</td></tr>\n<tr><td>North Carolina</td><td>Southeast: North Carolina</td></tr>\n<tr><td>North Dakota</td><td>Great Plains: North Dakota</td></tr>\n<tr><td>Ohio</td><td>North Central: Ohio</td></tr>\n<tr><td>Oklahoma</td><td>South Central: Oklahoma</td></tr>\n<tr><td>Oregon</td><td>Pacific Northwest:Or\negon</td></tr>\n<tr><td>Pennsylvania</td><td>Northeast: Pennsylvania</td></tr>\n<tr><td>Rhode Island</td><td>Northeast: Rhode Island</td></tr>\n<tr><td>South Carolina</td><td>Southeast: South Carolina</td></tr>\n<tr><td>South Dakota</td><td>Great Plains: South Dakota</td></tr>\n<tr><td>Tennessee</td><td>South Central: Tennessee</td></tr>\n<tr><td>Texas</td><td>South Central: Texas</td></tr>\n<tr><td>Utah</td><td>Intermountain: Utah</td></tr>\n<tr><td>Vermont</td><td>Northeast: Vermont</td></tr>\n<tr><td>Virginia</td><td>Southeast: Virginia</td></tr>\n<tr><td>Washington</td><td>Pacific Northwest:Washington</td></tr>\n<tr><td>West Virginia</td><td>Northeast: West Virginia</td></tr>\n<tr><td>Wisconsin</td><td>North Central: Wisconsin</td></tr>\n<tr><td>Wyoming</td><td>Intermountain: Wyoming</td></tr>\n</table><br> |
N |
case plot.statecd when 9 then '`0001 Northeast: Connecticut' when 10 then '`0002 Northeast: Delaware' when 23 then '`0003 Northeast: Maine' when 24 then '`0004 Northeast: Maryland' when 25 then '`0005 Northeast: Massachusetts' when 33 then '`0006 Northeast: New Hampshire' when 34 then '`0007 Northeast: New Jersey' when 36 then '`0008 Northeast: New York' when 42 then '`0009 Northeast: Pennsylvania' when 44 then '`0010 Northeast: Rhode Island' when 50 then '`0011 Northeast: Vermont' when 54 then '`0012 Northeast: West Virginia' when 17 then '`0013 North Central: Illinois' when 18 then '`0014 North Central:Indiana' when 19 then '`0015 North Central: Iowa' when 26 then '`0016 North Central: Michigan' when 27 then '`0017 North Central: Minnesota' when 29 then '`0018 North Central: Missouri' when 39 then '`0019 North Central: Ohio' when 55 then '`0020 North Central:\nWisconsin' when 12 then '`0021 Southeast: Florida' when 13 then '`0022 Southeast: Georgia' when 37 then '`0023 Southeast: North Carolina' when 45 then '`0024 Southeast: South Carolina' when 51 then '`0025 Southeast: Virginia' when 1 then '`0026 South Central: Alabama' when 5 then '`0027 South Central: Arkansas' when 21 then '`0028 South Central: Kentucky' when 22 then '`0029 South Central: Louisiana' when 28 then '`0030 South Central:Mississippi' when 40 then '`0031 South Central: Oklahoma' when 47 then '`0032 South Central: Tennessee' when 48 then '`0033 South Central: Texas' when 20 then '`0034 Great Plains: Kansas' when 31 then '`0035 Great Plains: Nebraska' when 38 then '`0036 Great Plains: North Dakota' when 46 then '`0037 Great Plains: South Dakota' when 4 then '`0038 Intermountain: Arizona' when 8 then '`0039 Intermountain: Colorado' when 16 then '`0040\nIntermountain: Idaho' when 30 then '`0041 Intermountain: Montana' when 32 then '`0042 Intermountain: Nevada' when 35 then '`0043 Intermountain: New Mexico' when 49 then '`0044 Intermountain: Utah' when 56 then '`0045 Intermountain: Wyoming' when 2 then '`0046 Alaska: Alaska' when 41 then '`0047 Pacific Northwest: Oregon' when 53 then '`0048 Pacific Northwest: Washington' when 6 then '`0049 Pacific Southwest: California' when 15 then '`0050 Pacific Southwest: Hawaii' else '`0051 Other' end |
| Reserved status class |
C.RESERVCD |
Reserved status code. Reserved land is land that is withdrawn by law(s) prohibiting the management of the land for the production of wood products. \n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>0</td><td>Not reserved</td></tr>\n<tr><td>1</td><td>Reserved</td></tr>\n</table><br> |
N |
case coalesce(cond.reservcd,-1) when 0 then '`0001 Not reserved' when 1 then '`0002 Reserved' when -1 then '`0003 Not available' else '`0004 Other' end |
| Rotten and missing cull |
T.CULL |
Rotten and missing cull. The percent of the cubic-foot volume in a live or dead tally tree that is rotten or missing. This is a calculated value that includes field-recorded cull (CULL_FLD) and any additional cull due to broken top.<br> |
N |
case coalesce(tree.cull,-1) when -1 then '`0011 Not available' when least(tree.cull,10) then '`0001 0 - 10%' when least(tree.cull,20) then '`0002 10- 20%' when least(tree.cull,30) then '`0003 20 - 30%' when least(tree.cull,40) then '`0004 30 - 40%' when least(tree.cull,50) then '`0005 40 - 50%' when least(tree.cull,60) then '`0006 50 - 60%' when least(tree.cull,70) then '`0007 60 - 70%' when least(tree.cull,80) then '`0008 70 - 80%' when least(tree.cull,90) then '`0009 80 - 90' when least(tree.cull,100) then '`0010 90 - 100' else '`0012 other' end |
| Site index |
C.SICOND |
Site index:\nSite index for the condition. This represents the average total length in feet that dominant and co-dominant trees are expected to attain in well-stocked,\neven-aged stands at the specified base age (SIBASE). Site index is estimated for the\ncondition by either using an individual tree or by averaging site index values that have been calculated for individual site trees (see SITETREE.SITREE) of the same species (SISP).<br> |
Y |
case coalesce(cond.sicond,-1) when -1 then '`0011 Not available' when least(cond.sicond,10) then '`0001 0 - 10' when least(cond.sicond,20) then '`0002 10- 20' when least(cond.sicond,30) then '`0003 20 - 30' when least(cond.sicond,40) then '`0004 30 - 40' when least(cond.sicond,50) then '`0005 40 - 50' when least(cond.sicond,60) then '`0006 50 - 60' when least(cond.sicond,70) then '`0007 60 - 70' when least(cond.sicond,80) then '`0008 70 - 80' when least(cond.sicond,90) then '`0009 80 - 90' when least(cond.sicond,200) then '`0010 90+' else '`0012 other' end |
| Site productivity class |
C.SITECLCD |
Site productivity class is a classification of forest land in terms of inherent capacity to grow crops of industrial wood. Identifies the potential growth in cubic feet/acre/year and is based on the\nculmination of mean annual increment of fully stocked natural stands. For data stored in the database that were processed outside of NIMS, this variable may be assigned based on the site productivity determined with the site trees, or from some other source, but the actual source of the site productivity class code is not known. For data processed with NIMS, this variable may either be assigned based on the site trees available for the plot, or, if no valid site trees are available, this variable is set equal to SITECLCDEST, a default value that is either an estimated or predicted site productivity class. If SITECLCDEST is used to populate SITECLCD,\nthe variable SITECL_METHOD is set to 6.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>1</td><td>225+ cubic feet/acre/year</td></tr>\n<tr><td>2</td><td>165-224 cubic feet/acre/year</td></tr>\n<tr><td>3</td><td>120-164 cubic feet/acre/year</td></tr>\n<tr><td>4</td><td>85-119 cubic feet/acre/year</td></tr>\n<tr><td>5</td><td>50-84 cubic feet/acre/year</td></tr>\n<tr><td>6</td><td>20-49 cubic feet/acre/year</td></tr>\n<tr><td>7</td><td>0-19 cubic feet/acre/year</td></tr>\n</table><br> |
N |
case coalesce(cond.siteclcd,-1) when 1 then '`0001 225+' when 2 then '`0002 165-224' when 3 then '`0003 120-164' when 4 then '`0004 85-119' when 5 then '`0005 50-84' when 6 then '`0006 20-49' when 7 then '`0007 0-19' when -1 then '`0008 Not available' else '`0009 Other' end |
| Slope |
C.SLOPE |
Slope. The angle of slope, in percent, of the condition. Valid values are 000 through 155 for data collected when PLOT.MANUAL =1.0, and 000 through 200 on data collected when PLOT.MANUAL <1.0. When PLOT.MANUAL <1.0, the field crew measured condition slope by sighting along the average incline or decline of the condition. When PLOT.MANUAL =1.0, slope is collected on subplots but no longer collected for conditions. When PLOT.MANUAL =1.0, the slope from the subplot representing the greatest percentage of the condition is assigned as a surrogate. In the event that two or more subplots represent the same amount of area in the condition,\nthe slope from the lower numbered subplot is used. Populated for all forest annual plots, all forest periodic plots, and all NCRS\nperiodic plots that were measured as "nonforest with trees" (e.g., wooded pasture, windbreaks).<br> |
Y |
case coalesce(cond.slope,-1) when -1 then '`0007 Not available' when least(cond.slope,20) then '`0001 0-20 percent' when least(cond.slope,40) then '`0002 21-40 percent' when least(cond.slope,60) then '`0003 41-60 percent' when least(cond.slope,80) then '`0004 61-80 percent' when least(cond.slope,100) then '`0005 81-100 percent' when least(cond.slope,9999) then '`0006 100+ percent' else '`0008 other' end |
| SoForFuturesSubReg |
P.COUNTYCD |
SoForFuturesSubReg- |
N |
FS_FIADB.EVALIDATORFUNCTIONS.SFFPSUBREGLabel(PLOT.statecd,PLOT.countycd) |
| Species |
T.SPCD |
Species- common names for tree species. |
N |
FS_FIADB.EVALIDATORFUNCTIONS.spcdLabel(cast(tree.spcd as integer)) |
| Species (seedling) |
S.SEEDLING |
Species (seedling)- common names for tree species. |
N |
FS_FIADB.EVALIDATORFUNCTIONS.spcdLabel(cast(coalesce(seedling.spcd,0) as integer)) |
| Species group |
T.SPGRPCD |
Species group code. A code assigned to each tree species in order to group them for reporting purposes on presentation tables. Codes and their associated names:<br>\n\n<table>\n\n<tr><td>Species group name</td><td>Code</td></tr>\n\n<tr><td>Longleaf and slash pines</td><td>1</td></tr>\n\n<tr><td>Loblolly and shortleaf pines</td><td>2</td></tr>\n\n<tr><td>Other yellow pines</td><td>3</td></tr>\n\n<tr><td>Eastern white and red pines</td><td>4</td></tr>\n\n<tr><td>Jack pine</td><td>5</td></tr>\n\n<tr><td>Spruce and balsam fir</td><td>6</td></tr>\n\n<tr><td>Eastern hemlock</td><td>7</td></tr>\n\n<tr><td>Cypress</td><td>8</td></tr>\n\n<tr><td>Other eastern so\nftwoods</td><td>9</td></tr>\n\n<tr><td>Douglas-fir</td><td>10</td></tr>\n\n<tr><td>Ponderosa and Jeffrey pines</td><td>11</td></tr>\n\n<tr><td>True\n\nfir</td><td>12</td></tr>\n\n<tr><td>Western hemlock</td><td>13</td></tr>\n\n<tr><td>Sugar pine</td><td>14</td></tr>\n\n<tr><td>Western white pine</td><td>15</td></tr>\n\n<tr><td>Redwood</td><td>16</td></tr>\n\n<tr><td>Sitka spruce</td><td>17</td></tr>\n\n<tr><td>Engelmann and other spruces</td><td>18</td></tr>\n\n<tr><td>Western larch</td><td>19</td></tr>\n\n<tr><td>Incense-cedar</td><td>20</td></tr>\n\n<tr><td>Lodgepole pine</td><td>21</td></tr>\n\n<tr><td>Western redcedar</td><td>22</td></tr>\n\n<tr><td>Western woodland softwoods</td><td>23</td></tr>\n\n<tr><td>Other western softwoods</td><td>24</td><td></td></tr>\n\n<tr><td>Select white oaks</td><td>25</td></tr>\n\n<tr><td>Select red oaks</td><td>26</td></tr>\n\n<tr><td>Other white oaks</td><td>27</td></tr>\n\n<tr><td>Other red\n\noaks</td><td>28</td></tr>\n\n<tr><td>Hickory</td><td>29</td></tr>\n\n<tr><td>Yellow birch</td><td>30</td></tr>\n\n<tr><td>Hard maple</td><td>31</td></tr>\n\n<tr><td>Soft maple</td><td>32</td></tr>\n\n<tr><td>Beech</td><td>33</td></tr>\n\n<tr><t\nd>Sweetgum</td><td>34</td></tr>\n\n<tr><td>Tupelo and blackgum</td><td>35</td></tr>\n\n<tr><td>Ash</td><td>36</td></tr>\n\n<tr><td>Cottonwood and aspen</td><td>37</td></tr>\n\n<tr><td>Basswood</td><td>38</td></tr>\n\n<tr><td>Yellow-poplar</td><td>39</td></tr>\n\n<tr><td>Black walnut</td><td>40</td></tr>\n\n<tr><td>Other eastern soft hardwoods</td><td>41</td></tr>\n\n<tr><td>Other eastern hard hardwoods</td><td>42</td></tr>\n\n<tr><td>Eastern noncommercial hardwoods</td><td>43</td></tr>\n\n<tr><td>Cottonwood and aspen</td><td>44</td></tr>\n\n<tr><td>Red alder</td><td>45</td></tr>\n\n<tr><td>Oak</td><td>46</td></tr>\n\n<td>Other western hardwoods</td><td>47</td></tr>\n\n<td>Western woodland hardwoods</td><td>48</td></tr>\n\n<tr><td>Tropical and subtropical pines</td><td>51</td></tr>\n\n<tr><td>Other tropical and subtropical softwoods</td><td>52</td></tr>\n\n<tr><td>Tropical and subtropical palms</td><td>53</td></tr>\n\n<tr><td>Tropical and subtropical hardwoods</td><td>54</td></tr>\n\n</table><br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.spgrpcdLabel(tree.spgrpcd, tree.statecd, cast(tree.spcd as integer)) |
| Species group (seedling) |
S.SPGRPCD |
Species group (seedling)-A code assigned to each tree species in order to group them for reporting purposes on presentation tables. Codes and their associated names:<br>\n<table>\n<tr><td>Species group name</td><td>Code</td></tr>\n<tr><td>Longleaf and slash pines</td><td>1</td></tr>\n<tr><td>Loblolly and shortleaf pines</td><td>2</td></tr>\n<tr><td>Other yellow pines</td><td>3</td></tr>\n<tr><td>Eastern white and red pines</td><td>4</td></tr>\n<tr><td>Jack pine</td><td>5</td></tr>\n<tr><td>Spruce and balsam fir</td><td>6</td></tr>\n<tr><td>Eastern hemlock</td><td>7</td></tr>\n<tr><td>Cypress</td><td>8</td></tr>\n<tr><td>Other eastern softwoods</td><td>9</td></tr>\n<tr><td>Douglas-fir</td><td>10</td></tr>\n<tr><td>Ponderosa and Jeffrey pines</td><td>11</td></tr>\n<tr><td>\nTrue fir</td><td>12</td></tr>\n<tr><td>Western hemlock</td><td>13</td></tr>\n<tr><td>Sugar pine</td><td>14</td></tr>\n<tr><td>Western white pine</td><td>15</td></tr>\n<tr><td>Redwood</td><td>16</td></tr>\n<tr><td>Sitka spruce</td><td>17</td></tr>\n<tr><td>Engelmann and other spruces</td><td>18</td></tr>\n<tr><td>Western larch</td><td>19</td></tr>\n<tr><td>Incense-cedar</td><td>20</td></tr>\n<tr><td>Lodgepole pine</td><td>21</td></tr>\n<tr><td>Western redcedar</td><td>22</td></tr>\n<tr><td>Western woodland softwoods</td><td>23</td></tr>\n<tr><td>Other western softwoods</td><td>24</td><td></td></tr>\n<tr><td>Select white oaks</td><td>25</td></tr>\n<tr><td>Select red oaks</td><td>26</td></tr>\n<tr><td>Other white oaks</td><td>27</td></tr>\n<tr><td>Other\nred oaks</td><td>28</td></tr>\n<tr><td>Hickory</td><td>29</td></tr>\n<tr><td>Yellow birch</td><td>30</td></tr>\n<tr><td>Hard maple</td><td>31</td></tr>\n<tr><td>Soft maple</td><td>32</td></tr>\n<tr><td>Beech</td><td>33</td></tr>\n<tr><td>Sweetgum</td><td>34</td></tr>\n<tr><td>Tupelo and blackgum</td><td>35</td></tr>\n<tr><td>Ash</td><td>36</td></tr>\n<tr><td>Cottonwood and aspen</td><td>37</td></tr>\n<tr><td>Basswood</td><td>38</td></tr>\n<tr><td>Yellow-poplar</td><td>39</td></tr>\n<tr><td>Black walnut</td><td>40</td></tr>\n<tr><td>Other eastern soft hardwoods</td><td>41</td></tr>\n<tr><td>Other eastern hard hardwoods</td><td>42</td></tr>\n<tr><td>Eastern noncommercial hardwoods</td><td>43</td></tr>\n<tr><td>Cottonwood and\naspen</td>\n<td>44</td></tr>\n<tr><td>Red alder</td><td>45</td></tr>\n<tr><td>Oak</td><td>46</td></tr>\n<tr><td></td><td></td><td>Other western hardwoods</td><td>47</td></tr>\n<tr><td></td><td></td><td>Western woodland hardwoods</td><td>48</td></tr>\n</table><br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.spgrpcdLabel(coalesce(seedling.spgrpcd,0), seedling.statecd, cast(coalesce(seedling.spcd,0) as integer)) |
| Species group - Major |
T.SPCD |
Species group - Major:<br>\nSoftwood: A coniferous tree, usually evergreen, having needles or scale-like leaves.<br>\nHardwood: A dicotyledonous tree, usually broad-leaved and deciduous.<br>\nTrees with a spcd>999 will be classed as Other (typically tropical species)<br> |
N |
case coalesce(tree.spgrpcd,-1) when -1 then '`0004 Not available' when least(tree.spgrpcd,24) then '`0001 Softwoods' when least(tree.spgrpcd,48) then '`0002 Hardwoods' when least(tree.spgrpcd,50) then '`0003 other' when least(tree.spgrpcd,52) then '`0001 Softwoods' when least(tree.spgrpcd,54) then '`0002 Hardwoods' else '`0003 Other' end |
| Species group - MajorGroup |
T.SPCD |
Species group - MajorGroup:<br>\nHardwood: A dicotyledonous tree, usually broad-leaved and deciduous.<br> \nSoft hardwoods: A category of hardwood species with wood generally of low specific gravity (less than 0.5). Notable examples include red maple, paper birch, quaking aspen, and American elm.<br>\nHard hardwoods: A category of hardwood species with wood generally of high specific gravity (greater than 0.5). Notable examples include sugar maple, yellow birch, black walnut, and oaks.<br>\nSoftwood: A coniferous tree, usually evergreen, having needles or scale-like leaves.<br>\nPines: any evergreen resinous coniferous tree of the genus Pinus<br>\nOther softwoods: all other softwoods not of the genus Pinus<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.MAJORSPGRPlabel(cast(tree.spcd as integer)) |
| Species scientific name |
T.SPCD |
Species- scientific names for tree species. |
N |
FS_FIADB.EVALIDATORFUNCTIONS.spcdlatinLabel(cast(tree.spcd as integer)) |
| Stand age 10 yr classes |
C.STDAGE |
Stand age. For annual inventories (PLOT.MANUAL =1.0), stand age is equal to the field-recorded stand age (FLDAGE) with some exceptions. One exception is if FLDAGE = 999, then stand age is computed. When FLDAGE = 998, STDAGE is blank (null) because no trees were cored in the field. Another exception is that RMRS always computes stand age using field-recorded tree ages from trees in the calculated stand-size class. If no tree ages are available, then RMRS sets this attribute equal to FLDAGE. For all inventories, nonstocked stands have STDAGE set to 0. In periodic inventories, stand age is determined using local procedures. Annual inventory data will contain stand ages assigned to the nearest year. For some older inventories, stand age was set to 10-year classes for stands <100 years old, 20-year age classes for stands between 100 and 200 years, and 100-year age classes if older than 200 years. These classes were converted to store the midpoint of the age class in years. Blank (null) values in theperiodic data (PLOT.MANUAL <1.0) indicate that the stand was recorded as mixed age on forested condition classes. Age is difficult to measure and therefore STDAGE may have large measurement errors.<br> |
Y |
case when cond.stdage is null then '`0023 Not available' when cond.stdage = -999 then '`0022 Mixed (only used in Northeastern States for periodic inventories)' when cond.stdage = -1 then '`0023 not measured' when cond.stdage = least(cond.stdage,10) then '`0001 0-10 years' when cond.stdage = least(cond.stdage,20) then '`0002 11-20 years' when cond.stdage = least(cond.stdage,30) then '`0003 21-30 years' when cond.stdage = least(cond.stdage,40) then '`0004 31-40 years' when cond.stdage = least(cond.stdage,50) then '`0005 41-50 years' when cond.stdage = least(cond.stdage,60) then '`0006 51-60 years' when cond.stdage = least(cond.stdage,70) then '`0007 61-70 years' when cond.stdage = least(cond.stdage,80) then '`0008 71-80 years' when cond.stdage = least(cond.stdage,90) then '`0009 81-90 years' when cond.stdage = least(cond.stdage,100) then '`0010 91-100 years' when cond.stdage = least(cond.stdage,110) then '`0011 101-110 years' when cond.stdage = least(cond.stdage,120) then '`0012 111-120 years' when cond.stdage = least(cond.stdage,130) then '`0013 121-130 years' when cond.stdage = least(cond.stdage,140) then '`0014 131-140 years' when cond.stdage = least(cond.stdage,150) then '`0015 141-150 years' when cond.stdage = least(cond.stdage,160) then '`0016 151-160 years' when cond.stdage = least(cond.stdage,170) then '`0017 161-170 years' when cond.stdage = least(cond.stdage,180) then '`0018 171-180 years' when cond.stdage = least(cond.stdage,190) then '`0019 181-190 years' when cond.stdage = least(cond.stdage,200) then '`0020 191-200 years' when cond.stdage = least(cond.stdage,9999) then '`0021 200+ years' else '`0024 Other' end |
| Stand age 20 yr classes (0 to 100 plus) |
C.STDAGE |
Stand age. For annual inventories (PLOT.MANUAL =1.0), stand age is equal to the field-recorded stand age (FLDAGE) with some exceptions. One exception is if FLDAGE = 999, then stand age is computed. When FLDAGE = 998, STDAGE is blank (null) because no trees were cored in the field. Another exception is that RMRS always computes stand age using field-recorded tree ages from trees in the calculated stand-size class. If no tree ages are available, then RMRS sets this attribute equal to FLDAGE. For all inventories, nonstocked stands have STDAGE set to 0. In periodic inventories, stand age is determined using local procedures. Annual inventory data will contain stand ages assigned to the nearest year. For some older inventories, stand age was set to 10-year classes for stands <100 years old, 20-year age classes for stands between 100 and 200 years,\nand 100-year age classes if older than 200 years. These classes were converted to store the midpoint of the age class in years. Blank (null) values in the\nperiodic data (PLOT.MANUAL <1.0) indicate that the stand was recorded as mixed age on forested condition classes. Age is difficult to measure and therefore STDAGE may have large measurement errors.<br> |
Y |
case when cond.stdage is null then '`0008 Not available' when cond.stdage = -999 then '`0007 Mixed (only used in Northeastern States for periodic inventories)' when cond.stdage = -1 then '`0008 not measured' when cond.stdage = least(cond.stdage,20) then '`0001 0-20 years' when cond.stdage = least(cond.stdage,40) then '`0002 21-40 years' when cond.stdage = least(cond.stdage,60) then '`0003 41-60 years' when cond.stdage = least(cond.stdage,80) then '`0004 61-80 years' when cond.stdage = least(cond.stdage,100) then '`0005 81-100 years' when cond.stdage = least(cond.stdage,9999) then '`0006 100+ years' else '`0009 Other' end |
| Stand age 20 yr classes (0 to 100) |
C.STDAGE |
Stand age. For annual inventories (PLOT.MANUAL =1.0), stand age is equal to the field-recorded stand age (FLDAGE) with some exceptions. One exception is if FLDAGE = 999, then stand age is computed. When FLDAGE = 998, STDAGE is blank (null) because no trees were cored in the field. Another exception is that RMRS always computes stand age using field-recorded tree ages from trees in the calculated stand-size class. If no tree ages are available, then RMRS sets this attribute equal to FLDAGE. For all inventories, nonstocked stands have STDAGE set to 0. In periodic inventories, stand age is determined using local procedures. Annual inventory data will contain stand ages assigned to the nearest year. For some older inventories, stand age was set to 10-year classes for stands <100 years old, 20-year age classes for stands between 100 and 200 years,and 100-year age classes if older than 200 years. These classes were converted to store the midpoint of the age class in years. Blank (null) values in theperiodic data (PLOT.MANUAL <1.0) indicate that the stand was recorded as mixed age on forested condition classes. Age is difficult to measure and therefore STDAGE may have large measurement errors.<br> |
Y |
case when cond.stdage is null then '`0008 Not available' when cond.stdage = -999 then '`0007 Mixed (only used in Northeastern States for periodic inventories)' when cond.stdage = -1 then '`0008 not measured' when cond.stdage = least(cond.stdage,20) then '`0001 0-20 years' when cond.stdage = least(cond.stdage,40) then '`0002 21-40 years' when cond.stdage = least(cond.stdage,60) then '`0003 41-60 years' when cond.stdage = least(cond.stdage,80) then '`0004 61-80 years' when cond.stdage = least(cond.stdage,100) then '`0005 81-100 years' when cond.stdage = least(cond.stdage,9999) then '`0006 100+ years' else '`0009 Other' end |
| Stand age 20 yr classes (0 to 500 plus) |
C.STDAGE |
Stand age. For annual inventories (PLOT.MANUAL =1.0), stand age is equal to the field-recorded stand age (FLDAGE) with some exceptions. One exception is if FLDAGE = 999, then stand age is computed. When FLDAGE = 998, STDAGE is blank (null) because no trees were cored in the field. Another exception is that RMRS always computes stand age using field-recorded tree ages from trees in the calculated stand-size class. If no tree ages are available, then RMRS sets this attribute equal to FLDAGE. For all inventories, nonstocked stands have STDAGE set to 0. In periodic inventories, stand age is determined using local procedures. Annual inventory data will contain stand ages assigned to the nearest year. For some older inventories, stand age was set to 10-year classes for stands <100 years old, 20-year age classes for stands between 100 and 200 years,\nand 100-year age classes if older than 200 years. These classes were converted to store the midpoint of the age class in years. Blank (null) values in the\nperiodic data (PLOT.MANUAL <1.0) indicate that the stand was recorded as mixed age on forested condition classes. Age is difficult to measure and therefore STDAGE may have large measurement errors.<br> |
N |
case when cond.stdage is null then '`0028 Not available' when cond.stdage = -999 then '`0027 Mixed (only used in Northeastern States for periodic inventories)' when cond.stdage = -1 then '`0028 not measured' when cond.stdage = least(cond.stdage,20) then '`0001 0-20 years' when cond.stdage = least(cond.stdage,40) then '`0002 21-40 years' when cond.stdage = least(cond.stdage,60) then '`0003 41-60 years' when cond.stdage = least(cond.stdage,80) then '`0004 61-80 years' when cond.stdage = least(cond.stdage,100) then '`0005 81-100 years' when cond.stdage = least(cond.stdage,120) then '`0006 100-120 years' when cond.stdage = least(cond.stdage,140) then '`0007 121-140 years' when cond.stdage = least(cond.stdage,160) then '`0008 141-160 years' when cond.stdage = least(cond.stdage,180) then '`0009 161-180 years' when cond.stdage = least(cond.stdage,200) then '`0010 181-200 years' when cond.stdage = least(cond.stdage,220) then '`0011 200-220 years' when cond.stdage = least(cond.stdage,240) then '`0012 221-240 years' when cond.stdage = least(cond.stdage,260) then '`0013 241-260 years' when cond.stdage = least(cond.stdage,280) then '`0014 261-280 years' when cond.stdage = least(cond.stdage,300) then '`0015 281-300 years' when cond.stdage = least(cond.stdage,320) then '`0016 300-320 years' when cond.stdage = least(cond.stdage,340) then '`0017 321-340 years' when cond.stdage = least(cond.stdage,360) then '`0018 341-360 years' when cond.stdage = least(cond.stdage,380) then '`0019 361-380 years' when cond.stdage = least(cond.stdage,400) then '`0020 381-400 years' when cond.stdage = least(cond.stdage,420) then '`0021 400-420 years' when cond.stdage = least(cond.stdage,440) then '`0022 421-440 years' when cond.stdage = least(cond.stdage,460) then '`0023 441-460 years' when cond.stdage = least(cond.stdage,480) then '`0024 461-480 years' when cond.stdage = least(cond.stdage,500) then '`0025 481-500 years' when cond.stdage = least(cond.stdage,9999) then '`0026 500+ years' else '`0029 Other' end |
| Stand age 5 yr classes |
C.STDAGE |
Stand age. For annual inventories (PLOT.MANUAL =1.0), stand age is equal to the field-recorded stand age (FLDAGE) with some exceptions. One exception is if FLDAGE = 999, then stand age is computed. When FLDAGE = 998, STDAGE is blank (null) because no trees were cored in the field. Another exception is that RMRS always computes stand age using field-recorded tree ages from trees in the calculated stand-size class. If no tree ages are available, then RMRS sets this attribute equal to FLDAGE. For all inventories, nonstocked stands have STDAGE set to 0. In periodic inventories, stand age is determined using local procedures. Annual inventory data will contain stand ages assigned to the nearest year. For some older inventories, stand age was set to 10-year classes for stands <100 years old, 20-year age classes for stands between 100 and 200 years,\nand 100-year age classes if older than 200 years. These classes were converted to store the midpoint of the age class in years. Blank (null) values in the\nperiodic data (PLOT.MANUAL <1.0) indicate that the stand was recorded as mixed age on forested condition classes. Age is difficult to measure and therefore STDAGE may have large measurement errors.<br> |
Y |
case when cond.stdage is null then '`0023 Not available' when cond.stdage = -999 then '`0022 Mixed (only used in Northeastern States for periodic inventories)' when cond.stdage = -1 then '`0023 not measured' when cond.stdage = least(cond.stdage,5) then '`0001 0-5 years' when cond.stdage = least(cond.stdage,10) then '`0002 6-10 years' when cond.stdage = least(cond.stdage,15) then '`0003 11-15 years' when cond.stdage = least(cond.stdage,20) then '`0004 16-20 years' when cond.stdage = least(cond.stdage,25) then '`0005 21-25 years' when cond.stdage = least(cond.stdage,30) then '`0006 26-30 years' when cond.stdage = least(cond.stdage,35) then '`0007 31-35 years' when cond.stdage = least(cond.stdage,40) then '`0008 36-40 years' when cond.stdage = least(cond.stdage,45) then '`0009 41-45 years' when cond.stdage = least(cond.stdage,50) then '`0010 46-50 years' when cond.stdage = least(cond.stdage,55) then '`0011 51-55 years' when cond.stdage = least(cond.stdage,60) then '`0012 56-60 years' when cond.stdage = least(cond.stdage,65) then '`0013 61-65 years' when cond.stdage = least(cond.stdage,70) then '`0014 66-70 years' when cond.stdage = least(cond.stdage,75) then '`0015 71-75 years' when cond.stdage = least(cond.stdage,80) then '`0016 76-80 years' when cond.stdage = least(cond.stdage,85) then '`0017 81-85 years' when cond.stdage = least(cond.stdage,90) then '`0018 86-90 years' when cond.stdage = least(cond.stdage,95) then '`0019 91-95 years' when cond.stdage = least(cond.stdage,100) then '`0020 96-100 years' when cond.stdage = least(cond.stdage,9999) then '`0021 100+ years' else '`0024 Other' end |
| Stand age 5 yr classes to 200 |
C.STDAGE |
Stand age. For annual inventories (PLOT.MANUAL =1.0), stand age is equal to the field-recorded stand age (FLDAGE) with some exceptions. One exception is if FLDAGE = 999, then stand age is computed. When FLDAGE = 998, STDAGE is blank (null) because no trees were cored in the field. Another exception is that RMRS always computes stand age using field-recorded tree ages from trees in the calculated stand-size class. If no tree ages are available, then RMRS sets this attribute equal to FLDAGE. For all inventories, nonstocked stands have STDAGE set to 0. In periodic inventories, stand age is determined using local procedures. Annual inventory data will contain stand ages assigned to the nearest year. For some older inventories, stand age was set to 10-year classes for stands <100 years old, 20-year age classes for stands between 100 and 200 years,and 100-year age classes if older than 200 years. These classes were converted to store the midpoint of the age class in years. Blank (null) values in theperiodic data (PLOT.MANUAL <1.0) indicate that the stand was recorded as mixed age on forested condition classes. Age is difficult to measure and therefore STDAGE may have large measurement errors.<br> |
Y |
case when cond.stdage is null then\n '`0043 Not available'\nwhen cond.stdage = -999 then\n '`0022 Mixed (only used in Northeastern States for periodic inventories)'\nwhen cond.stdage = -1 then\n '`0043 not measured'\nwhen cond.stdage = least(cond.stdage, 5) then\n '`0001 0-5 years'\nwhen cond.stdage = least(cond.stdage, 10) then\n '`0002 6-10 years'\nwhen cond.stdage = least(cond.stdage, 15) then\n '`0003 11-15 years'\nwhen cond.stdage = least(cond.stdage, 20) then\n '`0004 16-20 years'\nwhen cond.stdage = least(cond.stdage, 25) then\n '`0005 21-25 years'\nwhen cond.stdage = least(cond.stdage, 30) then\n '`0006 26-30 years'\nwhen cond.stdage = least(cond.stdage, 35) then\n '`0007 31-35 years'\nwhen cond.stdage = least(cond.stdage, 40) then\n '`0008 36-40 years'\nwhen cond.stdage = least(cond.stdage, 45) then\n '`0009 41-45 years'\nwhen cond.stdage = least(cond.stdage, 50) then\n '`0010 46-50 years'\nwhen cond.stdage = least(cond.stdage, 55) then\n '`0011 51-55 years'\nwhen cond.stdage = least(cond.stdage, 60) then\n '`0012 56-60 years'\nwhen cond.stdage = least(cond.stdage, 65) then\n '`0013 61-65 years'\nwhen cond.stdage = least(cond.stdage, 70) then\n '`0014 66-70 years'\nwhen cond.stdage = least(cond.stdage, 75) then\n '`0015 71-75 years'\nwhen cond.stdage = least(cond.stdage, 80) then\n '`0016 76-80 years'\nwhen cond.stdage = least(cond.stdage, 85) then\n '`0017 81-85 years'\nwhen cond.stdage = least(cond.stdage, 90) then\n '`0018 86-90 years'\nwhen cond.stdage = least(cond.stdage, 95) then\n '`0019 91-95 years'\nwhen cond.stdage = least(cond.stdage, 100) then\n '`0020 96-100 years'\nwhen cond.stdage = least(cond.stdage, 105) then\n '`0021 100-105 years'\nwhen cond.stdage = least(cond.stdage, 110) then\n '`0022 106-110 years'\nwhen cond.stdage = least(cond.stdage, 115) then\n '`0023 111-115 years'\nwhen cond.stdage = least(cond.stdage, 120) then\n '`0024 116-120 years'\nwhen cond.stdage = least(cond.stdage, 125) then\n '`0025 121-125 years'\nwhen cond.stdage = least(cond.stdage, 130) then\n '`0026 126-130 years'\nwhen cond.stdage = least(cond.stdage, 135) then\n '`0027 131-135 years'\nwhen cond.stdage = least(cond.stdage, 140) then\n '`0028 136-140 years'\nwhen cond.stdage = least(cond.stdage, 145) then\n '`0029 141-145 years'\nwhen cond.stdage = least(cond.stdage, 150) then\n '`0030 146-150 years'\nwhen cond.stdage = least(cond.stdage, 155) then\n '`0031 151-155 years'\nwhen cond.stdage = least(cond.stdage, 160) then\n '`0032 156-160 years'\nwhen cond.stdage = least(cond.stdage, 165) then\n '`0033 161-165 years'\nwhen cond.stdage = least(cond.stdage, 170) then\n '`0034 166-170 years'\nwhen cond.stdage = least(cond.stdage, 175) then\n '`0035 171-175 years'\nwhen cond.stdage = least(cond.stdage, 180) then\n '`0036 176-180 years'\nwhen cond.stdage = least(cond.stdage, 185) then\n '`0037 181-185 years'\nwhen cond.stdage = least(cond.stdage, 190) then\n '`0038 186-190 years'\nwhen cond.stdage = least(cond.stdage, 195) then\n '`0039 191-195 years'\nwhen cond.stdage = least(cond.stdage, 200) then\n '`0040 196-200 years' \nwhen cond.stdage = least(cond.stdage, 9999) then\n '`0041 200+ years'\nelse\n '`0044 Other'\nend |
| Stand origin |
C.STDORGCD |
Stand origin. Method of stand regeneration for the trees in the condition. An artificially regenerated stand is established by planting or artificial seeding. Populated for all forest annual plots, all forest periodic plots, and all NCRS periodic plots that were measured as "nonforest with trees" (e.g., wooded pasture, windbreaks).<br>\nThe stand origin is either "Natural" or "Clear evidence of artificial regeneration"<br> |
N |
case coalesce(cond.stdorgcd,-1) when 0 then '`0001 Natural stands' when 1 then '`0002 Clear evidence of artificial regeneration' when -1 then '`0003 Not available' else '`0004 Other' end |
| Stand origin species |
C.STDORGSP |
Stand origin species code. The species code for the predominant artificially regenerated species (only when STDORGCD = 1). See appendix F. May not be populated for some FIA work units when PLOT.MANUAL <1.0. |
N |
FS_FIADB.EVALIDATORFUNCTIONS.spcdLabel(cond.stdorgsp) |
| Stand treatment 1 |
C.TRTCD1 |
Treatment code 1. A code indicating the type of stand treatment that has occurred since the last measurement or within the last 5 years for new plots. The area affected by the treatment must be at least 1 acre in size. Populated for all forested conditions using the National Field Guide protocols (PLOT.MANUAL >=1.0) and populated by some FIA work units where PLOT.MANUAL <1.0. When PLOT.MANUAL <1.0, inventories may record treatments occurring within the last 20 years for new plots.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>00</td><td>No observable treatment.</td></tr>\n<tr><td>10</td><td>Cutting - The removal of one or more trees from a stand.</td></tr>\n<tr><td>20</td><td>Site preparation - Clearing, slash burning, chopping, disking, bedding,\nor other practices clearly intended to prepare a site for either natural or artificial regeneration.</td></tr>\n<tr><td>30</td><td>Artificial\nregeneration - Following a disturbance or treatment (usually cutting), a new stand where at least 50 percent of the live trees present resulted from planting or direct seeding.</td></tr>\n<tr><td>40</td><td>Natural regeneration - Following a disturbance or treatment (usually cutting), a new stand where at least 50 percent of the live trees present (of any size) were established through the growth of existing trees and/or natural seeding or sprouting.</td></tr>\n<tr><td>50</td><td>Other silvicultural treatment - The use of fertilizers, herbicides, girdling, pruning, or other activities (not covered by codes 10-40) designed to improve the commercial value of the residual stand, or chaining,\nwhich is a practice used on western woodlands to encourage wildlife forage.</td></tr>\n</table><br> |
N |
case coalesce(cond.trtcd1,-1) when 0 then '`0001 No observable treatment' when 10 then '`0002 Cutting' when 20 then '`0003 Site preparation' when 30 then '`0004 Artificial regeneration' when 40 then '`0005 Natural regeneration' when 50 then '`0006 Other silvicultural treatment' when -1 then '`0007 Not available' else '`0008 Other' end |
| Stand treatment 2 |
C.TRTCD2 |
Treatment code 2. A code indicating the secondary type of stand treatment that has occurred since the last measurement or within the last 5 years for new plots. The area affected by the treatment must be at least 1 acre in size. Populated for all forested conditions using the National Field Guide protocols (PLOT.MANUAL >=1.0) and populated by some FIA work units where PLOT.MANUAL <1.0. When PLOT.MANUAL <1.0, inventories may record treatments occurring within the last 20 years for new plots.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>00</td><td>No observable treatment.</td></tr>\n<tr><td>10</td><td>Cutting - The removal of one or more trees from a stand.</td></tr>\n<tr><td>20</td><td>Site preparation - Clearing, slash burning, chopping, disking, bedding,\nor other practices clearly intended to prepare a site for either natural or artificial regeneration.</td></tr>\n<tr><td>30</td><td>Artificial regeneration - Following a disturbance or treatment (usually cutting), a new stand where at least 50 percent of the live trees present resulted from planting or direct seeding.</td></tr>\n<tr><td>40</td><td>Natural regeneration - Following a disturbance or treatment (usually cutting), a new stand where at least 50 percent of the live trees present (of any size) were established through the growth of existing trees and/or natural seeding or sprouting.</td></tr>\n<tr><td>50</td><td>Other silvicultural treatment - The use of fertilizers, herbicides, girdling, pruning, or other activities (not covered by codes 10-40) designed to improve the commercial value of the residual stand, or chaining,\nwhich is a practice used on western woodlands to encourage wildlife forage.</td></tr>\n</table><br> |
N |
case coalesce(cond.trtcd2,-1) when 0 then '`0001 No observable treatment' when 10 then '`0002 Cutting' when 20 then '`0003 Site preparation' when 30 then '`0004 Artificial regeneration' when 40 then '`0005 Natural regeneration' when 50 then '`0006 Other silvicultural treatment' when -1 then '`0007 Not available' else '`0008 Other' end |
| Stand treatment 3 |
C.TRTCD3 |
Treatment code 3. A code indicating the secondary type of stand treatment that has occurred since the last measurement or within the last 5 years for new plots. The area affected by the treatment must be at least 1 acre in size. Populated for all forested conditions using the National Field Guide protocols (PLOT.MANUAL >=1.0) and populated by some FIA work units where PLOT.MANUAL <1.0. When PLOT.MANUAL <1.0, inventories may record treatments occurring within the last 20 years for new plots.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>00</td><td>No observable treatment.</td></tr>\n<tr><td>10</td><td>Cutting - The removal of one or more trees from a stand.</td></tr>\n<tr><td>20</td><td>Site preparation - Clearing, slash burning, chopping, disking, bedding,\nor other practices clearly intended to prepare a site for either natural or artificial regeneration.</td></tr>\n<tr><td>30</td><td>Artificial regeneration - Following a disturbance or treatment (usually cutting), a new stand where at least 50 percent of the live trees present resulted from planting or direct seeding.</td></tr>\n<tr><td>40</td><td>Natural regeneration - Following a disturbance or treatment (usually cutting), a new stand where at least 50 percent of the live trees present (of any size) were established through the growth of existing trees and/or natural seeding or sprouting.</td></tr>\n<tr><td>50</td><td>Other silvicultural treatment - The use of fertilizers, herbicides, girdling, pruning, or other activities (not covered by codes 10-40) designed to improve the commercial value of the residual stand, or chaining,\nwhich is a practice used on western woodlands to encourage wildlife forage.</td></tr>\n</table><br> |
N |
case coalesce(cond.trtcd3,-1) when 0 then '`0001 No observable treatment' when 10 then '`0002 Cutting' when 20 then '`0003 Site preparation' when 30 then '`0004 Artificial regeneration' when 40 then '`0005 Natural regeneration' when 50 then '`0006 Other silvicultural treatment' when -1 then '`0007 Not available' else '`0008 Other' end |
| Stand-size class |
C.STDSZCD |
Stand-size class: A classification of forest land based on the size class of live trees in the area. The classes are as follows:<br>\nNonstocked: Forest land stocked with less than 10 percent of full stocking with live trees. Examples are recently cutover areas or recently reverted agricultural fields.<br>\nSeedling-sapling: Forest land stocked with at least 10 percent of full stocking with live trees with half or more of such stocking in seedlings or saplings or both.<br>\nPoletimber: Forest land\nstocked with at least 10 percent of full stocking with live trees with half or more of such stocking in poletimber or sawtimber trees or both, and in which the stocking of poletimber exceeds that of sawtimber.<br>\nSawtimber: Forest land stocked with at least 10 percent of full stocking with live trees with half or more of such stocking in poletimber or sawtimber trees or both,\nand in which the stocking of sawtimber is at least equal to that of poletimber.<br> |
N |
case coalesce(cond.stdszcd,-1) when 1 then '`0001 Large diameter' when 2 then '`0002 Medium diameter' when 3 then '`0003 Small diameter' when 5 then '`0004 Nonstocked' when -1 then '`0005 Not available' else '`0006 Other' end |
| Stand-size(field call) |
C.FLDSZCD |
Stand-size class: A classification of forest land based on the size class of live trees in the area. The classes are as follows:<br>\nNonstocked: Forest land stocked with less than 10 percent of full stocking with live trees. Examples are recently cutover areas or recently reverted agricultural fields.<br>\nSeedling-sapling: Forest land stocked with at least 10 percent of full stocking with live trees with half or more of such stocking in seedlings or saplings or both.<br>\nPoletimber: Forest land stocked with at least 10 percent of full stocking with live trees with half or more of such stocking in poletimber or sawtimber trees or both,\nand in which the stocking of poletimber exceeds that of sawtimber.<br>\nSawtimber: Forest land stocked with at least 10 percent of full stocking with live\ntrees with half or more of such stocking in poletimber or sawtimber trees or both, and in which the stocking of sawtimber is at least equal to that of poletimber.<br> |
N |
case coalesce(cond.fldszcd,-1) when 5 then '`0001 Large diametercase coalesce(tree.treegrcd,-1)' when 4 then '`0002 Large diameter(20.0 to 39.9 inches)' when 3 then '`0003 Large diameter(sfwd 9 to 19.9;hdwd 11 to 19.9 inches)' when 2 then '`0004 Medium diameter(sfwd 5 to 8.9;hdwd 5 to 10.9 inches)' when 1 then '`0005 Small diameter(0.1 to 4.9 inches)' when 0 then '`0006 Nonstocked' when 6 then '`0007 Cover trees' when -1 then '`0008 Not available' else '`0009 Other' end |
| State code |
P.STATECD |
State name |
N |
FS_FIADB.EVALIDATORFUNCTIONS.STATECDLABEL(PLOT.STATECD) |
| Tree class |
T.TREECLCD |
Tree class indicates the general quality of the tree. In annual inventory, this is the tree class for both live and dead trees at the time of current measurement. In periodic inventory, for cut and dead trees, this is the tree class of the tree at the time it died or was cut. Therefore, cut and dead trees collected in periodic inventory can be coded as growing-stock. There are three tree classes:<br>\nGrowing-stock - All live trees of commercial species that meet minimum merchantability standards. In general, these trees have at least one solid 8-foot section, are reasonably free of form defect on the merchantable bole, and at least 34 percent or more of the volume is merchantable. For the California, Oregon, and Washington inventories, a 26 percent or more merchantable volume standard is applied, rather than 34 percent or more. Excludes rough or rotten cull trees.<br>\nRough cull - All live trees that do not now, or prospectively,\nhave at least one solid 8-foot\nsection, reasonably free of form defect on the merchantable bole, or have 67 percent or more of the merchantable volume cull; and more than half of this cull is due to sound dead wood cubic-foot loss or severe form defect volume loss. For the California, Oregon, and Washington inventories, 75 percent or more cull, rather than 67 percent or more cull, applies. This class also contains all trees of noncommercial species, or those species where SPGRPCD equals 23 (western woodland softwoods), 43 (eastern noncommercial hardwoods), or 48 (western woodland hardwoods). Refer to appendix F to find the species that have these SPGRPCD codes. For dead trees, this code indicates that the tree is salvable (sound).<br>\nRotten cull - All live trees with 67 percent or more of the merchantable volume cull, and more than half of this cull is due to rotten or missing cubic-foot volume loss. California, Oregon,\nand Washington inventories use a 75 percent cutoff. For dead trees, this code indicates that the tree\nis nonsalvable (not sound).<br>\n |
N |
case coalesce(tree.treeclcd,-1) when 2 then '`0001 Growing stock' when 3 then '`0002 Rough cull' when 4 then '`0003 Rotten cull' when -1 then '`0004 Not available' else '`0005 Other' end |
| Tree grade |
T.TREEGRCD |
Tree grade code. A code indicating the quality of\nsawtimber-sized trees. This attribute is populated for live, growing-stock, sawtimber size trees on subplots 1-4 on national manual plots that are in a forest condition class. This attribute may be populated for other tree records that do not meet the above criteria. For example, it may be populated with the previous tree grade on dead and cut trees. Standards for tree grading are specific to species and differ slightly by research station. Only collected by certain FIA work units (SURVEY.RSCD = 23, 24, or 33). Tree grade codes range from 1 to 5. |
N |
case coalesce(tree.treegrcd,-1) when 1 then '`0001 Grade 1' when 2 then '`0002 Grade 2' when 3 then '`0003 Grade 3' when 4 then '`0004 Gradeable log but does not meet grade 3 standards' when 5 then '`0005 Graded but does not contain gradeable log' when 0 then '`0006 Too small to grade' when -1 then '`0007 Not available' else '`0008 Other' end |
| Tree size class |
T.DIA |
Tree size:<br>\nSaplings: Live trees 1.0 inch through 4.9 inches d.b.h.<br>\nPoletimber trees: Live trees at least 5.0 inches in d.b.h. but smaller than sawtimber trees.<br>\nSawtimber tree: A live tree of commercial species containing at least a 12-foot saw log or two noncontiguous saw logs 8 feet or longer, and meeting regional specifications for freedom from defect. Softwoods must be at least 9.0 inches d.b.h. Hardwoods must be at least 11.0 inches d.b.h.<br> |
N |
case when tree.dia is null then '`0004 Other' when tree.dia = -1 then '`0004 Other' else case least(tree.dia, 4.99) when 4.99 then case case tree.spgrpcd when 1 then 1 when 2 then 1 when 3 then 1 when 4 then 1 when 5 then 1 when 6 then 1 when 7 then 1 when 8 then 1 when 9 then 1 when 10 then 1 when 11 then 1 when 12 then 1 when 13 then 1 when 14 then 1 when 15 then 1 when 16 then 1 when 17 then 1 when 18 then 1 when 19 then 1 when 20 then 1 when 21 then 1 when 22 then 1 when 23 then 1 when 24 then 1 when 51 then 1 when 52 then 1 else 2 end when 2 then case least(tree.dia, 10.99) when 10.99 then '`0001 Sawtimber-size' else '`0002 Poletimber-size' end else case least(tree.dia,8.99) when 8.99 then '`0001 Sawtimber-size' else '`0002 Poletimber-size' end end else '`0003 Sapling-size' end end |
| Tree status |
T.STATUSCD |
Tree status indicates whether a tree is live, cut, or dead at the time of measurement.<br>\n<table>\n<tr><td>Code</td><td>Description</td></tr>\n<tr><td>0</td><td>No status - Tree is not presently in the sample (remeasurement plots only). Tree was incorrectly tallied at the previous inventory, currently not tallied due to definition or procedural change, or is not tallied due to natural causes. RECONCILECD = 5-9 required for remeasured annual inventory data but not for periodic inventory data.</td></tr>\n<tr><td>1</td><td>Live tree</td></tr>\n<tr><td>2</td><td>Dead tree</td></tr>\n<tr><td>3</td><td>Removed - Cut and removed by direct human activity related to harvesting, silviculture or land clearing. This tree is assumed to be utilized.</td></tr>\n</table><br> |
N |
case coalesce(tree.statuscd,-1) when 1 then '`0001 Live' when 2 then case coalesce(tree.agentcd,0) when least(coalesce(tree.agentcd,0),0) then '`0002 Dead - cause not recorded' when least(tree.agentcd,19) then '`0003 Dead - insect' when least(tree.agentcd,29) then '`0004 Dead - disease' when least(tree.agentcd,39) then '`0005 Dead - fire' when least(tree.agentcd,49) then '`0006 Dead - animal' when least(tree.agentcd,59) then '`0007 Dead - weather' when least(tree.agentcd,69) then '`0008 Dead - vegetation' when least(tree.agentcd,79) then '`0009 Dead - unknown/other' when least(tree.agentcd,89) then '`0010 Dead - logging/human' when least(tree.agentcd,99) then '`0011 Dead - physical' end when 3 then '`0012 Cut and assumed utilized' when 4 then '`0013 Missed live tree' when 5 then '`0014 Missed mortality tree' when 6 then '`0015 Missed dead tree' when 7 then '`0016 No history' when -1 then '`0017 Not available' else '`0018 Other' end |
| USNVC Macrogroup |
c.nvcs_level_5_cd |
Level 5 code of the NVCS. The NVCS code describing the vegetative community of the\ncondition at the fifth level of the NVCS hierarchy. For more information on the vegetation classification,\nrefer to the Data Standard web page on the USNVC website (available at web address: http://usnvc.org/data-standard/) |
N |
case\nwhen cond.nvcs_level_5_cd LIKE '1.A.1.Ea.M134' then '`0001 1.A.1.Ea.M134'\nwhen cond.nvcs_level_5_cd LIKE '1.A.4.Ed.M005' then '`0002 1.A.4.Ed.M005'\nwhen cond.nvcs_level_5_cd LIKE '1.A.4.Ed.M617' then '`0003 1.A.4.Ed.M617'\nwhen cond.nvcs_level_5_cd LIKE '1.B.1.Na.M007' then '`0004 1.B.1.Na.M007'\nwhen cond.nvcs_level_5_cd LIKE '1.B.1.Na.M008' then '`0005 1.B.1.Na.M008'\nwhen cond.nvcs_level_5_cd LIKE '1.B.1.Na.M305' then '`0006 1.B.1.Na.M305'\nwhen cond.nvcs_level_5_cd LIKE '1.B.1.Na.M885' then '`0007 1.B.1.Na.M885'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Na.M012' then '`0008 1.B.2.Na.M012'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Na.M013' then '`0009 1.B.2.Na.M013'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Na.M014' then '`0010 1.B.2.Na.M014'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Na.M016' then '`0011 1.B.2.Na.M016'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Na.M159' then '`0012 1.B.2.Na.M159'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Na.M502' then '`0013 1.B.2.Na.M502'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Na.M882' then '`0014 1.B.2.Na.M882'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Na.M883' then '`0015 1.B.2.Na.M883'\nwhen cond.nvcs_level_5_cd LIKE '1.B.2.Ne.M151' then '`0016 1.B.2.Ne.M151'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Na.M029' then '`0017 1.B.3.Na.M029'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Na.M302' then '`0018 1.B.3.Na.M302'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Na.M503' then '`0019 1.B.3.Na.M503'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Na.M504' then '`0020 1.B.3.Na.M504'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Nb.M031' then '`0021 1.B.3.Nb.M031'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Nb.M032' then '`0022 1.B.3.Nb.M032'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Nb.M154' then '`0023 1.B.3.Nb.M154'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Nb.M161' then '`0024 1.B.3.Nb.M161'\nwhen cond.nvcs_level_5_cd LIKE '1.B.3.Nb.M310' then '`0025 1.B.3.Nb.M310'\nwhen cond.nvcs_level_5_cd LIKE '1.B.5.Na.M299' then '`0026 1.B.5.Na.M299'\nwhen cond.nvcs_level_5_cd LIKE '7.A.2.1.2' then '`0027 7.A.2.1.2'\nwhen cond.nvcs_level_5_cd LIKE '-1.-1.-1.-1.-1' then '`0091 -1.-1.-1.-1.-1'\nwhen cond.nvcs_level_5_cd LIKE '-2.-2.-2.-2.-2' then '`0092 -2.-2.-2.-2.-2'\nelse '`0999 Other/NoData' end |
| Unit code |
P.UNITCD |
Survey unit code. Forest Inventory and Analysis survey unit identification number. Survey units are usually groups of counties within each State. For periodic inventories, Survey units may be made up of lands of particular owners.<br> |
N |
FS_FIADB.EVALIDATORFUNCTIONS.unitcdLabel(cond.statecd,cond.unitcd) |