| Abnormal stem termination |
Indication of whether or not the tree length was unnaturally terminated. |
tre.abnormal_stem_termination |
case coalesce(tre.abnormal_stem_termination,-1) when 0 then '`0001 Not abnormal' when 1 then '`0002 Abnormal (broken top)' when -1 then '`0003 Not available'else '`0004 Other'end |
| Afforested |
Indication that a condition has no evidence of prior forest, but it does have evidence suggesting deliberate afforestation attempts (planted or prepared to promote tree establishment) to convert to forest in the current inventory cycle or since the last measurement. |
cnd.afforestation_cd |
case coalesce(cnd.AFFORESTATION_CD,-1) when 0 then '`0001 No' when 1 then '`0002 Yes' when -1 then '`0003 Not available' else '`0004 Other' end |
| Bole stump removed |
Indication of whether or not the bole and stump have been removed from the site since the previous measurement. |
tre.bole_stump_removed |
case coalesce(tre.bole_stump_removed,-1) when 0 then '`0001 Bole removed' when 1 then '`0002 Bole and stump removed' when -1 then '`0003 Not available'else '`0004 Other'end |
| Canopy cover method |
The canopy cover sample method used to determine live canopy cover percent, live missing canopy cover percent, and number of live stems. |
cnd.canopy_cvr_sample_method_cd |
case coalesce(cnd.canopy_cvr_sample_method_cd,-1) when 1 then '`0001 Ocular' when 2 then '`0002 Sub-acre' when 3 then '`0003 Acre' when -1 then '`0004 Not available'else '`0005 Other'end |
| Cause of death |
The cause of death for all trees that have died or have been cut since the previous inventory. |
tre.cause_of_death |
case coalesce(tre.cause_of_death,-1) when 10 then '`0001 Insect ' when 20 then '`0002 Disease ' when 30 then '`0003 Fire ' when 40 then '`0004 Animal ' when 50 then '`0005 Weather ' when 60 then '`0006 Vegetation' when 70 then '`0007 Unknown ' when 80 then '`0008 Silvicultural' when -1 then '`0009 Not available' else '`0010 Other'end |
| Condition status |
Description of the sampling status of the condition class. |
cnd.cond_sampling_status |
case coalesce(cnd.cond_status_cd,-1) when 1 then '`0001 Forest' when 2 then '`0002 Nonforest' when 3 then '`0003 Noncensus water' when 4 then '`0004 Census water' when 5 then '`0005 Nonsampled' when -1 then '`0006 Not available' else '`0007 Other'end |
| Cover class |
The classification of land cover on sampled conditions. |
cnd.cover_class |
case coalesce(cnd.cover_class, -1) when 1 then '`0001 Tree Cover' when 2 then '`0002 Shrub Cover' when 3 then '`0003 Herbaceous Cover' when 4 then '`0004 Non-vascular Vegetation Cover' when 5 then '`0005 Mixed Vegetation Cover' when 8 then '`0006 Barren' when 9 then '`0007 Impervious' when 10 then '`0008 Water' when -1 then '`0009 Not available' else '`0010 Unknown' end |
| Crown class |
The relative crown position of the tree within the stand. |
tre.crown_class_cd |
case coalesce(tre.crown_class_cd,-1) when 1 then '`0001 Open Grown' when 2 then '`0002 Dominant' when 3 then '`0003 Co-dominant' when 4 then '`0004 Intermediate' when 5 then '`0005 Overtopped' when -1 then '`0006 Not available' else '`0007 Other' end |
| Damage type - bark inclusion |
Indication of whether or not a trunk-bark inclusion is present. An inclusion occurs when branches are not strongly attached to the tree. A weak union occurs when two or more branches grow so closely together that bark grows between the branches and inside the union. |
tre.dmg_trunk_bark_inclusion |
case coalesce(tre.dmg_trunk_bark_inclusion,-1) when 0 then '`0001 Absent' when 1 then '`0002 Present' when -1 then '`0003 Not available'else '`0004 Other'end |
| Damage type - excessive mulching |
Indication of whether or not excessive mulching is present. Excessive mulching occurs when mulch is piled high around the stem at a depth greater than 3 inches. Mulch can take the form of many different materials and is not limited to wood chips. |
tre.dmg_excess_mulch |
case coalesce(tre.dmg_excess_mulch,-1) when 0 then '`0001 Absent' when 1 then '`0002 Present' when -1 then '`0003 Not available'else '`0004 Other'end |
| Damage type - improper planting |
Indication of whether or not improper planted is observed. Improper planting occurs when burlap, twine, or root ball wires are not removed prior to planting, or when the tree root flare is buried. |
tre.dmg_improper_planting |
case coalesce(tre.dmg_improper_planting,-1) when 0 then '`0001 Absent' when 1 then '`0002 Present' when -1 then '`0003 Not available'else '`0004 Other'end |
| Damage type - overhead wires |
Indication of whether or not a conflict with overhead utility wires is present. Conflict occurs when utility wires of any type (e.g., electric, telephone, cable) are within 5 feet of tree branches, foliage, or boles. |
tre.dmg_overhead_wires |
case coalesce(tre.dmg_overhead_wires,-1) when 0 then '`0001 Absent' when 1 then '`0002 Present' when -1 then '`0003 Not available'else '`0004 Other'end |
| Damage type - sidewalk-root conflict |
Indication of whether or not a conflict with roots is present. Conflict occurs when roots cause direct damage to infrastructures such as sidewalks, curbs, driveways, roads, or other hardscapes. |
tre.dmg_sidewalk_root_conflict |
case coalesce(tre.dmg_sidewalk_root_conflict,-1) when 0 then '`0001 Absent' when 1 then '`0002 Present' when -1 then '`0003 Not available'else '`0004 Other'end |
| Damage type - stem girdling |
Indication of whether or not stem damage from girdling root is present. Stem girdling occurs when roots begin to grow around the main stem of the tree and cut off or restrict the movement of water, plant nutrients, and stored food reserved. Certain trees are more prone to this problem than others. Lindens, magnolias, pines, and maples (other than silver maple) are susceptible to root girdling. |
tre.dmg_root_stem_girdling |
case coalesce(tre.dmg_root_stem_girdling,-1) when 0 then '`0001 Absent' when 1 then '`0002 Present' when -1 then '`0003 Not available'else '`0004 Other'end |
| Damage type - topping or pruning |
Indication of whether or not severe topping or poor pruning damage is present. Severe topping is the cutting of branches down to stubs or reducing the stem height by 25 percent or more. Poor pruning includes leaving stubs outside the branch collar, or cutting into the branch collar. Topping is usually done to reduce the total height of the tree, while pruning is done to reduce the over form or volume of the crown. |
tre.dmg_topping_pruning |
case coalesce(tre.dmg_topping_pruning,-1) when 0 then '`0001 Absent' when 1 then '`0002 Present' when -1 then '`0003 Not available'else '`0004 Other'end |
| Density class |
The relative tree density of the condition. This classification is based on the number of stems/unit area, basal area, tree cover, or stocking of all live trees, seedlings, and saplings in the condition that are not overtopped. Any density other than Initial Density is used as an indication that a significant difference in tree density is the only factor causing another condition to be recognized on the plot. |
cnd.mapden |
case coalesce(cnd.mapden,-1) when 1 then '`0001 Initial Density Class' when 2 then '`0002 Density Class 2' when 3 then '`0003 Density Class 3' when -1 then '`0004 Not available' else '`0005 Other' end |
| Diameter check |
The accuracy of the current diameter measurement. |
tre.diacheck |
case coalesce(tre.diacheck,-1) when 0 then '`0001 Measured' when 1 then '`0002 Estimated' when 2 then '`0003 Moved measurement pointr' when -1 then '`0004 Not available' else '`0005 Other'end |
| FIA land use |
The current land use for a condition. |
cnd.fia_landuse |
case coalesce(cnd.fia_landuse, -1) when 10 then '`0001 Forest land' when 11 then '`0002 Agriculture' when 12 then '`0003 Rangeland/Chaparral' when 13 then '`0004 Commercial/Industrial' when 14 then '`0005 Residential' when 15 then '`0006 Multi-family Residential' when 16 then '`0007 Recreation/Cemetery' when 17 then '`0008 Rights-of-Way' when 18 then '`0009 Other Nonforest' when 19 then '`0010 Water' when 20 then '`0011 Nonsampled' when -1 then '`0012 Not available' else '`0013 Other' end |
| Land cover class |
RETIRED. The classification of land cover on sampled conditions. These classes are no longer used and have been replaced by COVER CLASS in order to remove all aspects of land use and, rather, focus on land cover. |
cnd.land_cover_class_cd |
case coalesce(cnd.land_cover_class_cd,-1) when 1 then '`0001 Treeland' when 2 then '`0002 Shrubland' when 3 then '`0003 Grassland' when 4 then '`0004 Non-vascular Vegetation' when 5 then '`0005 Mixed Vegetation' when 6 then '`0006 Agricultural Vegetation' when 7 then '`0007 Developed-Vegetated' when 8 then '`0008 Barren' when 9 then '`0009 Developed' when 10 then '`0010 Water' when -1 then '`0011 Not available' else '`0012 Other' end |
| Maintained area for seedlings |
Indication of whether or not at least half of the seedling count for an individual species is located within a maintained area (seedling bole must be partially or fully contained within the maintained area to qualify). Maintained areas are defined as those which are consistently being impacted by mowing, weeding, brushing, herbiciding, landscaping, etc. Examples include, but are not limited to, lawns, maintained shrub beds, rights-of-way, and manicured park areas. Examples of unmaintained areas are overgrown lots, small wooded areas, and riverbanks. |
sdl.is_maintained_area |
case coalesce(sdl.is_maintained_area,'-1') when '0' then '`0001 No' when '1' then '`0002 Yes' when '-1' then '`0003 Not available' else '`0004 Other' end |
| Mtree Crown dieback |
The approximate percentage of dieback in the crown for the mother tree. Values are divided into ranges of 5 percent. |
mtre.crown_dieback_cd |
case coalesce(mtre.crown_dieback_cd,-1) when 0 then '`0001 0' when 5 then '`0002 1-5%' when 10 then '`0003 6-10%' when 15 then '`0004 11-15%' when 20 then '`0005 16-20%' when 25 then '`0006 21-25%' when 30 then '`0007 26-30%' when 35 then '`0008 31-35%' when 40 then '`0009 36-40%' when 45 then '`0010 41-45%' when 50 then '`0011 46-50%' when 55 then '`0012 51-55%' when 60 then '`0013 56-60%' when 65 then '`0014 61-65%' when 70 then '`0015 66-70%' when 75 then '`0016 71-75%' when 80 then '`0017 76-80%' when 85 then '`0018 81-85%' when 90 then '`0019 86-90%' when 95 then '`0020 91-95%' when 99 then '`0021 96-100%' when -1 then '`0022 Not available' else '`0023 Other' end |
| Mtree Crown exposed to light |
The number of sides of the crown for the mother tree that are exposed to direct sunlight. |
mtre.crown_light_exposure |
case coalesce(mtre.crown_light_exposure,-1) when 0 then '`0001 No Light' when 1 then '`0002 Top or 1 Side' when 2 then '`0003 Top and 1 Side' when 3 then '`0004 Top and 2 Sides' when 4 then '`0005 Top and 3 Sides' when 5 then '`0006 Top and 4 Sides' when -1 then '`0007 Not available' else '`0008 Other' end |
| Mtree Diameter (2-inch classes) |
Mother tree diameter binned in fifteen 2-inch classes, with the largest bin containing diameters 29 inches and greater. |
mtre.dia |
case when coalesce(mtre.dia,-1) = -1 then '`0016 Not available' when mtre.dia = 0 then '`0016 not measured' when mtre.dia is null then '`0016 not measured' when mtre.dia = least(mtre.dia,2.99) then '`0001 1.0-2.9' when mtre.dia = least(mtre.dia,4.99) then '`0002 3.0-4.9' when mtre.dia = least(mtre.dia,6.99) then '`0003 5.0-6.9' when mtre.dia = least(mtre.dia,8.99) then '`0004 7.0-8.9' when mtre.dia = least(mtre.dia,10.99) then '`0005 9.0-10.9' when mtre.dia = least(mtre.dia,12.99) then '`0006 11.0-12.9' when mtre.dia = least(mtre.dia,14.99) then '`0007 13.0-14.9' when mtre.dia = least(mtre.dia,16.99) then '`0008 15.0-16.9' when mtre.dia = least(mtre.dia,18.99) then '`0009 17.0-18.9' when mtre.dia = least(mtre.dia,20.99) then '`0010 19.0-20.9' when mtre.dia = least(mtre.dia,22.99) then '`0011 21.0-22.9' when mtre.dia = least(mtre.dia,24.99) then '`0012 23.0-24.9' when mtre.dia = least(mtre.dia,26.99) then '`0013 25.0-26.9' when mtre.dia = least(mtre.dia,28.99) then '`0014 27.0-28.9' else '`0015 29.0+' end |
| Mtree Diameter (5-inch classes) |
Mother tree diameter binned in 3 classes: 1-4.9 inch; 5-10.9 inch; 11 inches and greater. |
mtre.dia |
case when coalesce(mtre.dia,-1) = -1 then '`0004 Not available' when mtre.dia = 0 then '`0004 Not measured' when mtre.dia is null then '`0004 Not measured' when mtre.dia = least(mtre.dia,4.99) then '`0001 1.0-4.9' when mtre.dia = least(mtre.dia,10.99) then '`0002 5.0-10.9' else '`0003 11.0+' end |
| Mtree Diameter check |
The accuracy of the current diameter measurement. |
mtre.diacheck |
case coalesce(mtre.diacheck,-1) when 0 then '`0001 Measured' when 1 then '`0002 Estimated' when 2 then '`0003 Moved measurement pointr' when -1 then '`0004 Not available' else '`0005 Other'end |
| Mtree Species common name |
An FIA numeric code and common name identifying the tree species. |
mtre.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlabel(mtre.spcd) |
| Mtree Species group code |
The general grouping of similar tree species for the purposes of organization and reporting. |
mtre.spgrpcd |
fs_fiadb_urban.NUTS_FUNCTIONS.SPGRPCDLABEL(mtre.spgrpcd, mtre.statecd, mtre.spcd) |
| Mtree Species scientific name |
An FIA numeric code and scientific name identifying the tree species. |
mtre.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlatinlabel(mtre.spcd) |
| Mtree Tree planted |
Indication of whether or not the mother tree shows evidence of being planted. |
mtre.is_planted |
case coalesce(mtre.is_planted,'-1') when '1' then '`0001 Planted' when '2' then '`0002 Natural' when '3' then '`0003 Not Sure' when '-1' then '`0004 Not available' else '`0005 Other' end |
| Mtree Tree status |
The status of the mother tree at the time of measurement. |
mtre.statuscd |
case coalesce(mtre.statuscd,-1) when 0 then '`0001 No status' when 1 then '`0002 Live' when 2 then '`0003 Dead' when 3 then '`0004 Cut and utilized' when 4 then '`0005 Removed' when -1 then '`0006 Not available' else '`0007 Other' end |
| None |
The grouping variable for selected estimates without a grouping variable. |
xxx.none |
case 1 when 1 then '`0001 None`' else '`0001 None`' end |
| Nonsampled reason |
The reason a plot was entirely nonsampled for the plot visit. |
cnd.cond_nonsample_reasn_cd |
case coalesce(cnd.cond_nonsample_reasn_cd,-1) when 1 then '`0001 Out of boundary' when 2 then '`0002 Denied access' when 3 then '`0003 Hazardous' when 5 then '`0004 Lost data' when 6 then '`0005 Lost plot' when 7 then '`0006 Wrong location' when 8 then '`0007 Skipped visit' when 9 then '`0008 Dropped intensified plot' when 10 then '`0009 Other reason' when 11 then '`0010 Ocean' when -1 then '`0011 Not available' else '`0012 Other' end |
| Ownership group |
The ownership group of the land for the condition. |
cnd.owngrpcd |
case coalesce(cnd.owngrpcd,-1) when 10 then '`0001 ForestService' when 20 then '`0002 OtherFederal' when 30 then '`0003 StateLocal' when 40 then '`0004 Private' when -1 then '`0005 Not available' else '`0006 Other' end |
| Physiographic class |
The physiographic class of the condition within the plot area. Individual physiographic classes are based on the general effect of land form, topographic position, and soil on moisture available to trees. |
cnd.physclcd |
case coalesce(cnd.physclcd,-1) when 11 then '`0001 DryTops' when 12 then '`0002 DrySlopes' when 13 then '`0003 DeepSands' when 19 then '`0004 OtherXeric' when 21 then '`0005 Flatwoods' when 22 then '`0006 RollingUplands' when 23 then '`0007 MoistSlopes' when 24 then '`0008 NarrowFloodPlains' when 25 then '`0009 BroadFloodPlains' when 29 then '`0010 OtherMesic' when 31 then '`0011 SwampBog' when 32 then '`0012 SmallDrain' when 33 then '`0013 Bay' when 34 then '`0014 BeaverPond' when 35 then '`0015 CypressPond' when 39 then '`0016 OtherHydric' when -1 then '`0017 Not available' else '`0018 Other' end |
| Plot sample kind |
The type of installation for the plot visit. |
plt.kindcd |
case coalesce(plt.kindcd,-1) when 1 then '`0001 InitialEstablishment' when 2 then '`0002 Remeasurement' when 3 then '`0003 Replacement' when -1 then '`0004 Not available' else '`0005 Other' end |
| Plot status |
The sampling status of a plot visit. |
plt.plot_status_cd |
case coalesce(plt.plot_status_cd,-1) when 1 then '`0001 Sampled: Forest' when 2 then '`0002 Sampled: Nonforest' when 3 then '`0003 Sampled: Water' when 4 then '`0004 Nonsampled' when -1 then '`0005 Not available' else '`0006 Other' end |
| Plot type |
The identity of the subplot or microplot. The national Urban protocol has one subplot and four microplots. |
sbp.subp |
case coalesce(sbp.subp,-1) when 1 then '`0001 Subplot' when -1 then '`0003 Not available' else '`0002 Microplot' end |
| Reason condition not sampled |
The reason a condition was not sampled. |
cnd.cond_nonsample_reasn_cd |
case coalesce(cnd.cond_nonsample_reasn_cd,-1) when 1 then '`0001 Out Of Boundary' when 2 then '`0002 Denied Access' when 3 then '`0003 Hazardous' when 5 then '`0004 Lost Data' when 6 then '`0005 Lost Plot' when 7 then '`0006 Wrong Location' when 8 then '`0007 Skipped Visit' when 9 then '`0008 Dropped Intensified Plot' when 10 then '`0009 Other Reason' when 11 then '`0010 Ocean' when -1 then '`0011 Not available' else '`0012 Other'end |
| Reserved status |
The reserved status of the condition on publicly owned land. Management of land for the production of wood products is prohibited by law on reserved land. |
cnd.reservcd |
case coalesce(cnd.reservcd,-1) when 0 then '`0001 Not Reserved' when 1 then '`0002 Reserved' when -1 then '`0003 Not available' else '`0004 Other' end |
| Road distance |
The straight-line distance from plot center to the nearest improved road. An improved road is a road of any width that is maintained as evidence by pavement, gravel, grading, ditching, and/or other improvements. |
plt.road_dist_cd |
case coalesce(plt.road_dist_cd,-1)when 1 then '`0001 0-100 feet' when 2 then '`0002 101-300 feet' when 3 then '`0003 301-500 feet' when 4 then '`0004 501-1000 feet' when 5 then '`0005 1001-1/2 Mile' when 6 then '`0006 1/2 Mile - 1 Mile' when 7 then '`0007 1 Mile - 3 Miles' when 8 then '`0008 3 Miles - 5 Miles' when 9 then '`0009 > 5 Miles' when -1 then '`0010 Not available'else '`0011 Other' end |
| Seedling Species common name |
An FIA numeric code and common name identifying the tree species. |
sdl.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlabel(sdl.spcd) |
| Seedling Species group code |
The general grouping of similar tree species for the purposes of organization and reporting. |
sdl.spgrpcd |
fs_fiadb_urban.NUTS_FUNCTIONS.SPGRPCDLABEL(sdl.spgrpcd, sdl.statecd, sdl.spcd) |
| Seedling Species scientific name |
An FIA numeric code and scientific name identifying the tree species. |
sdl.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlatinlabel(sdl.spcd) |
| Seedling regeneration |
Indication of whether or not the seedling count for an individual species shows some evidence of being planted. |
sdl.is_planted |
case coalesce(sdl.is_planted,'-1') when '1' then '`0001 Planted' when '2' then '`0002 Natural' when '3' then '`0003 Not Sure' when '-1' then '`0004 Not available' else '`0005 Other' end |
| Site productivity |
The estimated productivity for the condition in terms of cubic feet per acre per year. |
cnd.cond_siteclass_fld |
case coalesce(cnd.cond_siteclass_fld,-1) when 1 then '`0001 225+ cuft/ac/yr' when 2 then '`0002 165-224 cuft/ac/yr' when 3 then '`0003 120-164 cuft/ac/yr' when 4 then '`0004 85-119 cuft/ac/yr' when 5 then '`0005 50-84 cuft/ac/yr' when 6 then '`0006 20-49 cuft/ac/yr' when 7 then '`0007 0-19 cuft/ac/yr' when -1 then '`0008 Not available' else '`0009 Other' end |
| Site productivity status |
The classification of whether or not a forested condition is considered productive. |
cnd.productivity_status |
case coalesce(cnd.productivity_status,-1) when 0 then '`0001 Unproductive' when 1 then '`0002 Productive' when -1 then '`0003 Not available' else '`0004 Other' end |
| Species common name |
An FIA numeric code and common name identifying the tree species. |
tre.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlabel(tre.spcd) |
| Species group code |
The general grouping of similar tree species for the purposes of organization and reporting. |
tre.spgrpcd |
fs_fiadb_urban.NUTS_FUNCTIONS.SPGRPCDLABEL(tre.spgrpcd, tre.statecd, tre.spcd) |
| Species scientific name |
An FIA numeric code and scientific name identifying the tree species. |
tre.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlatinlabel(tre.spcd) |
| Stand disturbance code 1 |
The first disturbance present in the condition occurring since the last measurement or within the last 5 years. |
cnd.disturbance_cd1 |
case coalesce(cnd.disturbance_cd1,-1)when 00 then '`0001 None - no observable disturbance' when 10 then '`0002 Insect damage (to both understory vegetation and trees)' 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 (to both understory vegetation and trees)' when 21 then '`0006 Vegetat' 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' when 32 then '`0010 crown fire' when 40 then '`0011 Animal damage (other than listed below)' 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 (CORE OPTIONAL)' when 45 then '`0016 rabbit (CORE OPTIONAL)' when 46 then '`0017 domestic animal/livestock (includes grazing)' when 50 then '`0018 Weather damage (other than listed below)' 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, competition, vines)' when 70 then '`0024 Unknown/not sure/other' when 80 then '`0025 Human-caused damage' when 90 then '`0026 Geologic disturbances' 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 '`0033 Other'end |
| Stand disturbance code 2 |
The second disturbance present in the condition occurring since the last measurement or within the last 5 years. |
cnd.disturbance_cd2 |
case coalesce(cnd.disturbance_cd2,-1)when 00 then '`0001 None - no observable disturbance' when 10 then '`0002 Insect damage (to both understory vegetation and trees)' 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 (to both understory vegetation and trees)' when 21 then '`0006 Vegetat' 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' when 32 then '`0010 crown fire' when 40 then '`0011 Animal damage (other than listed below)' 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 (CORE OPTIONAL)' when 45 then '`0016 rabbit (CORE OPTIONAL)' when 46 then '`0017 domestic animal/livestock (includes grazing)' when 50 then '`0018 Weather damage (other than listed below)' 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, competition, vines)' when 70 then '`0024 Unknown/not sure/other' when 80 then '`0025 Human-caused damage' when 90 then '`0026 Geologic disturbances' 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 '`0033 Other'end |
| Stand disturbance code 3 |
The third disturbance present in the condition occurring since the last measurement or within the last 5 years. |
cnd.disturbance_cd3 |
case coalesce(cnd.disturbance_cd3,-1)when 00 then '`0001 None - no observable disturbance' when 10 then '`0002 Insect damage (to both understory vegetation and trees)' 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 (to both understory vegetation and trees)' when 21 then '`0006 Vegetat' 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' when 32 then '`0010 crown fire' when 40 then '`0011 Animal damage (other than listed below)' 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 (CORE OPTIONAL)' when 45 then '`0016 rabbit (CORE OPTIONAL)' when 46 then '`0017 domestic animal/livestock (includes grazing)' when 50 then '`0018 Weather damage (other than listed below)' 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, competition, vines)' when 70 then '`0024 Unknown/not sure/other' when 80 then '`0025 Human-caused damage' when 90 then '`0026 Geologic disturbances' 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 '`0033 Other'end |
| Stand disturbance group code 1 |
The first disturbance group present in the condition occurring since the last measurement or within the last 5 years. Disturbance groups include Animal, Disease, Fire, Geologic, Human, Insect, Vegetation, Weather, None, Unknown. |
cnd.disturbance_cd1 |
case when coalesce(cnd.disturbance_cd1,-1) =-1 then '`0011 Not available' when cnd.disturbance_cd1 <10 then '`0001 None' when cnd.disturbance_cd1 <20 then '`0002 Insect' when cnd.disturbance_cd1 <30 then '`0003 Disease' when cnd.disturbance_cd1 <40 then '`0004 Fire' when cnd.disturbance_cd1 <50 then '`0005 Animal' when cnd.disturbance_cd1 <60 then '`0006 Weather' when cnd.disturbance_cd1 <70 then '`0007 Vegetation' when cnd.disturbance_cd1 <80 then '`0008 Unknown' when cnd.disturbance_cd1 <90 then '`0009 Human' when cnd.disturbance_cd1 <100 then '`0010 Geologic'else '`0012 Other'end |
| Stand disturbance group code 2 |
The second disturbance group present in the condition occurring since the last measurement or within the last 5 years. Disturbance groups include Animal, Disease, Fire, Geologic, Human, Insect, Vegetation, Weather, None, Unknown. |
cnd.disturbance_cd2 |
case when coalesce(cnd.disturbance_cd2,-1) =-1 then '`0011 Not available' when cnd.disturbance_cd2 <10 then '`0001 None' when cnd.disturbance_cd2 <20 then '`0002 Insect' when cnd.disturbance_cd2 <30 then '`0003 Disease' when cnd.disturbance_cd2 <40 then '`0004 Fire' when cnd.disturbance_cd2 <50 then '`0005 Animal' when cnd.disturbance_cd2 <60 then '`0006 Weather' when cnd.disturbance_cd2 <70 then '`0007 Vegetation' when cnd.disturbance_cd2 <80 then '`0008 Unknown' when cnd.disturbance_cd2 <90 then '`0009 Human' when cnd.disturbance_cd2 <100 then '`0010 Geologic'else '`0012 Other'end |
| Stand disturbance group code 3 |
The third disturbance group present in the condition occurring since the last measurement or within the last 5 years. Disturbance groups include Animal, Disease, Fire, Geologic, Human, Insect, Vegetation, Weather, None, Unknown. |
cnd.disturbance_cd3 |
case when coalesce(cnd.disturbance_cd3,-1) =-1 then '`0011 Not available' ||\n ' when cnd.disturbance_cd3 <10 then '`0001 None' when cnd.disturbance_cd3 <20 then '`0002 Insect' when cnd.disturbance_cd3 <30 then '`0003 Disease' when cnd.disturbance_cd3 <40 then '`0004 Fire' when cnd.disturbance_cd3 <50 then '`0005 Animal' when cnd.disturbance_cd3 <60 then '`0006 Weather' when cnd.disturbance_cd3 <70 then '`0007 Vegetation' when cnd.disturbance_cd3 <80 then '`0008 Unknown' when cnd.disturbance_cd3 <90 then '`0009 Human' when cnd.disturbance_cd3 <100 then '`0010 Geologic'else '`0012 Other'end |
| Stand origin |
The method of stand regeneration for trees in the condition. An artificially regenerated stand is established by planting or artificial seeding. |
cnd.stdorgcd |
case coalesce(cnd.stdorgcd,-1) when 0 then '`0001 Natural' when 1 then '`0002 Artificial' when -1 then '`0003 Not available' else '`0004 Other' end |
| Stand treatment code 1 |
The first treatment present in the condition occurring since the last measurement or within the last 5 years for new plot visits. The term treatment implies that a silvicultural application has been prescribed. |
cnd.treatment_cd1 |
case coalesce(cnd.treatment_cd1,-1) when 0 then '`0001 None' 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' when -1 then '`0007 Not available' else '`0008 Other' end |
| Stand treatment code 2 |
The second treatment present in the condition occurring since the last measurement or within the last 5 years for new plot visits. The term treatment implies that a silvicultural application has been prescribed. |
cnd.treatment_cd2 |
case coalesce(cnd.treatment_cd2,-1) when 0 then '`0001 None' 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' when -1 then '`0007 Not available' else '`0008 Other' end |
| Stand treatment code 3 |
The third treatment present in the condition occurring since the last measurement or within the last 5 years for new plot isits. The term treatment implies that a silvicultural application has been prescribed. |
cnd.treatment_cd3 |
case coalesce(cnd.treatment_cd3,-1) when 0 then '`0001 None' when 10 then '`0002 Cutting' when 20 then '`0003 Site Preparation' when 30 then ' ||\n '`0004 Artificial Regeneration' when 40 then '`0005 Natural Regeneration' when 50 then '`0006 Other' when -1 then '`0007 Not available' else '`0008 Other' end |
| Stand-size field call |
The field-assigned classification of the predominant diameter class of live trees within the condition. |
cnd.fldszcd |
case coalesce(cnd.fldszcd ,-1) when 0 then '`0001 Nonstocked' when 1 then '`0002 0 - 4.9 inches' when 2 then '`0003 5.0 - 8.9 inches' when 3 then '`0004 9.0 - 19.9 inches' when 4 then '`0005 20.0 - 39.9 inches' when 5 then '`0006 > 40.0 inches' when -1 then '`0007 Not available' else '`0008 Other' end |
| Street tree |
Indication of whether or not the mother tree qualifies as a street tree. A street tree is defined as a maintained-area tree, natural or planted, that is located within 8 feet of the edge of a maintained surfaced road. Street trees also include all trees located in the space between the edge of the road and sidewalk, or within a median strip between roads. A "clover leaf" interchange is not considered part of a median. Therefore, tree growing within a "clover leaf" interchange would only be considered a street tree if they were within 8 feet of the maintained road. In general, street trees provide shade, aesthetic values, or serve as a physical barrier between the street and adjacent property. These trees will generally have a visible, physical interaction with the street via its root system, overhanging branches, or proximity of the trunk. |
mtre.is_street_tree |
case coalesce(mtre.is_street_tree,'-1') when '1' then '`0001 Tree is a street tree' when '0' then '`0002 Tree is not a street tree' when '-1' then '`0003 Not available' else '`0004 Other' end |
| Tree Diameter (2-inch classes) |
Tree diameter binned in fifteen 2-inch classes, with the largest bin containing diameters 29 inches and greater. |
tre.dia |
case when coalesce(tre.dia,-1) = -1 then '`0016 Not available' when tre.dia = 0 then '`0016 not measured' when tre.dia is null then '`0016 not measured' when tre.dia = least(tre.dia,2.99) then '`0001 1.0-2.9' when tre.dia = least(tre.dia,4.99) then '`0002 3.0-4.9' when tre.dia = least(tre.dia,6.99) then '`0003 5.0-6.9' when tre.dia = least(tre.dia,8.99) then '`0004 7.0-8.9' when tre.dia = least(tre.dia,10.99) then '`0005 9.0-10.9' when tre.dia = least(tre.dia,12.99) then '`0006 11.0-12.9' when tre.dia = least(tre.dia,14.99) then '`0007 13.0-14.9' when tre.dia = least(tre.dia,16.99) then '`0008 15.0-16.9' when tre.dia = least(tre.dia,18.99) then '`0009 17.0-18.9' when tre.dia = least(tre.dia,20.99) then '`0010 19.0-20.9' when tre.dia = least(tre.dia,22.99) then '`0011 21.0-22.9' when tre.dia = least(tre.dia,24.99) then '`0012 23.0-24.9' when tre.dia = least(tre.dia,26.99) then '`0013 25.0-26.9' when tre.dia = least(tre.dia,28.99) then '`0014 27.0-28.9' else '`0015 29.0+' end |
| Tree class |
The general quality of the tree at the time of measurement. |
tre.treeclcd |
case coalesce(tre.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 height method |
The method used to determine tree length (height). |
tre.htcd |
case coalesce(tre.htcd,-1) when 1 then '`0001 Total & Actual Measured' when 2 then '`0002 Total Estimated/Actual Measure' when 3 then '`0003 Total & Actual Estimated' when -1 then '`0004 Not available' else '`0005 Other' end |
| Tree maintained |
Indication of whether or not the mother tree is located within a maintained area. Maintained areas are defined as those which are consistently being impacted by mowing, weeding, brushing, herbiciding, landscaping, etc. Examples include, but are not limited to, lawns, maintained shrub beds, rights-of-way, and manicured park areas. Examples of unmaintained areas are overgrown lots, small wooded areas, and riverbanks. |
mtre.is_maintained_area |
case coalesce(mtre.is_maintained_area,'-1') when '1' then '`0001 Tree is in a maintained area' when '0' then '`0002 Tree is not in a maintained area' when '-1' then '`0003 Not available' else '`0004 Other' end |
| Tree riparian |
Indication of whether or not the mother tree qualifies as a riparian river/stream tree. Such a tree is one that falls within 30 feet of the edge (mean high-water mark) of a stream or river. If a stream is intermittent, or no water is running at the time of plot measurement, the stream must have a naturally developed stream bottom to be recognized as a stream. Lakes, ponds, holding basins, and wet lands are not classified as riparian zones. Man-made ditches and canals used to funnel storm water during periods of high rainfall are not considered streams. However, some stream segments, especially in urban areas, may occasionally have cement sides and bottoms, and these segments, that are generally part of a larger stream network, are considered to be a stream. |
mtre.is_riparian |
case coalesce(mtre.is_riparian,'-1') when '1' then '`0001 Tree is in a riparian area' when '0' then '`0002 Tree is not in a riparian area' when '-1' then '`0003 Not available' else '`0004 Other' end |
| Tree status |
The status of the tree at the time of measurement. |
tre.statuscd |
case coalesce(tre.statuscd,-1) when 0 then '`0001 No status' when 1 then '`0002 Live' when 2 then '`0003 Dead' when 3 then '`0004 Cut and utilized' when 4 then '`0005 Removed' when -1 then '`0006 Not available' else '`0007 Other' end |
| Type of water |
The water body <1 acre in size or a stream <30 feet wide that has the greatest impact on the area within the accessible forest/nonforest land portion of the plot. Recorded waterbodies are listed in order from large permanent water to temporary water. This attribute is not recorded for water that is already defined as a separate noncensus or census water condition. |
plt.water_cd |
case coalesce(plt.water_cd,-1)when 0 then '`0001 None' when 1 then '`0002 Stream pond' when 2 then '`0003 Swamp bog marsh' when 3 then '`0004 Ditch canal' when 4 then '`0005 Temporary stream' when 5 then '`0006 Flood zone' when 9 then '`0007 Other water' when -1 then '`0008 Not available' else '`0009 Other' end |
| i-Tree land use |
The land use of the condition using categories developed for the i-Tree urban inventory. |
cnd.itree_landuse |
case coalesce(cnd.itree_landuse, -1) when 1 then '`0001 Agriculture' when 2 then '`0002 Institutional/Commercial' when 3 then '`0003 Residential' when 4 then '`0004 Multi-family' when 5 then '`0005 Cemetery/Park/Golf' when 6 then '`0006 Transportation/Utility' when 7 then '`0007 Water' when 8 then '`0008 Unused/Other' when -1 then '`0009 Not available' else '`0010 Other' end |
