| Abnormal stem termination |
ABNORMAL_STEM_TERMINATION attribute. Code for this attribute indicates whether or not a tree stem has an abnormal termination (broken top). |
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 |
Afforestation code. A value of 0 is used to indicate No/False, and a value of 1 is used to indicate Yes/True. |
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 |
The REF_BOLE_STUMP_REMOVED table stores reference data for the BOLE_STUMP_REMOVED attribute. Code for this attribute indicates if a tree bole and/or stump was removed since a 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 REF_CANOPY_COVER_SAMPLE_METHOD table stores reference data for the CANOPY_CVR_SAMPLE_METHOD_CD attribute. Code for this attribute indicates the method employed to estimate the canopy cover on a given plot visit. |
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 REF_CAUSE_OF_DEATH table stores reference data for the CAUSE_OF_DEATH attribute. Code for this attribute indicates the cause of death for a sample tree that was alive at a previous inventory and observed to be dead or removed at a subsequent 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 |
The REF_CONDITION_SAMPLING_STATUS table stores reference data for the COND_STATUS_CD attribute. Code for this attribute defines the sampling status of a condition. |
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 |
COVER_CLASS attribute is used to classify land cover on sampled conditions. Replaces the retired LAND_COVER_CLASS_CD attribute. |
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 REF_CROWN_CLASS table stores reference data for the CROWN_CLASS_CD attribute. Code for this attribute indicates the crown class of a tree. |
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 |
Damage type - bark inclusion. A code indicating whether or not there is a trunk or bark inclusion 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. The included bark does not have the structural strength of wood and can be very weak. |
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 |
Damage type - excessive mulching. A code indicating whether or not excessive mulching is present. Excessive mulching occurs when mulch is piled high around the steam at a depth greater than 3 inches. |
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 |
Damage type - improper planting. A code indicating whether or not improper planting is observed. Improper planting occurs when burlap, twine, or root ball wire was not removed prior to planting. |
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 |
Damage type - overhead wires. A code indicating whether or not there is conflict between the tree crown and overhead wires. Conflict with overhead wires occurs when tree crowns are within 5 feet of any utility wires. |
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 |
Damage type - sidewalk-root conflict. A code indicating whether or not sidewalk/root conflict damage is present. Sidewalk/root conflict occurs when roots cause direct damage to sidewalk, driveway, road, or other hard landscape features. |
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 |
Damage type - stem girdling. A code indicating whether or not root/stem girdling damage is present. Root/stem girdling occurs when roots begin to grow around the main stem of the tree and cut off or restrict the movement of water. |
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 |
Damage type - topping or pruning. A code indicating whether or not topping or pruning damage is present. 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 |
MAPDEN attribute indicates the relative density of tree stocking between two land conditions. These codes are primarily used to distinguish between two land conditions when the only difference is the relative density of trees populating the land. |
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 |
Diameter check code. A code indicating 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 |
None |
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 |
LAND_COVER_CLASS_CD attribute is used to classify land cover on sampled conditions. |
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 |
IS_MAINTAINED_AREA attribute in the ID_SEEDLING table indicates whether or not a group of seedlings is located within a maintained area. |
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 |
CROWN_DIEBACK_CD attribute. Code for this attribute is used to describe a discretized range of percentages. |
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 REF_CROWN_LIGHT_EXPOSURE table stores reference data for the CROWN_LIGHT_EXPOSURE attribute. Code for this attribute indicates the amount of tree crown that is exposed to light. |
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) |
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) |
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 |
Diameter check code. A code indicating 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 |
Tree common name from REF_SPECIES table |
mtre.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlabel(mtre.spcd) |
| Mtree Species group code |
Species group code from REF_SPECIES_GROUP table |
mtre.spgrpcd |
fs_fiadb_urban.NUTS_FUNCTIONS.SPGRPCDLABEL(mtre.spgrpcd, mtre.statecd, mtre.spcd) |
| Mtree Species scientific name |
Species scientific name from REF_SPECIES table |
mtre.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlatinlabel(mtre.spcd) |
| Mtree Tree planted |
IS_PLANTED attribute indicates whether or not a tree was 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 |
STATUSCD attribute indicates the status of a 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 |
None. |
xxx.none |
case 1 when 1 then '`0001 None`' else '`0001 None`' end |
| Nonsampled reason |
PLOT_NONSAMPLE_REASN_CD attribute. Code for this attribute identifies the reason for a nonsampled 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 |
Owner group code indicates 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 |
PHYSCLCD attribute. Code for this attribute indicates the physiographic classification of a land condition. |
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 |
Sample kind code. A code indicating 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 |
PLOT_STATUS_CD attribute. Code for this attribute describes the sampling status of a plot visit. The sampling status indicates the result of an attempt to visit a given plot for sampling. |
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 |
SUBP attribute. Code for this attribute identifies the type of footprint element (subplot or microplot) on which a boundary was delineated, or on which a field measurement was recorded, if applicable. |
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 REF_CONDITION_NONSAMPLE_REASON table stores reference data for the COND_NONSAMPLE_REASN_CD attribute. Code for this attribute identifies 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 |
RESERVCD attribute. Code for this attribute indicates the reserved status of a land condition. These codes are supported by an FIA definition of reserved land. For further details, refer to the Urban FIA Field Guide. |
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 REF_HORIZ_DIST_IMPRVD_ROAD table stores reference data for the ROAD_DIST_CD attribute. Code for this attribute indicates the horizontal distance from a plot visit to an improved road. |
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 |
Species common name from REF_SPECIES table |
sdl.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlabel(sdl.spcd) |
| Seedling Species group code |
Species group code from REF_SPECIES_GROUP table |
sdl.spgrpcd |
fs_fiadb_urban.NUTS_FUNCTIONS.SPGRPCDLABEL(sdl.spgrpcd, sdl.statecd, sdl.spcd) |
| Seedling Species scientific name |
Species scientific name from REF_SPECIES table |
sdl.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlatinlabel(sdl.spcd) |
| Seedling regeneration |
IS_PLANTED attribute in the ID_SEEDLING table indicates if a group of seedlings has been planted or has been established by natural mechanisms. |
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 |
COND_SITECLASS_FLD attribute indicates the site class of a land condition. These codes are ordinal and classify productivity 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 |
Productivity status attribute. Code for this attribute is used to classify the productivity of a land condition. |
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 |
Species common name from REF_SPECIES table |
tre.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlabel(tre.spcd) |
| Species group code |
Species group code from REF_SPECIES_GROUP table |
tre.spgrpcd |
fs_fiadb_urban.NUTS_FUNCTIONS.SPGRPCDLABEL(tre.spgrpcd, tre.statecd, tre.spcd) |
| Species scientific name |
Species scientific name from REF_SPECIES table |
tre.spcd |
fs_fiadb_urban.NUTS_FUNCTIONS.spcdlatinlabel(tre.spcd) |
| Stand disturbance code 1 |
Describes disturbance code 1 on sampled conditions. |
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 |
Describes disturbance code 2 on sampled conditions. |
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 |
Describes disturbance code 3 on sampled conditions. |
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 |
xxx |
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 |
Describes disturbance code 2 on sampled conditions. |
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 |
Describes disturbance code 3 on sampled conditions. |
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 |
STDORGCD attribute. Code for this attribute indicates the regeneration status of a stand of trees. |
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 |
TREATMENT_CD1 attribute describes silvicultural treatments applied to a land condition |
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 |
TREATMENT_CD2 attribute describes silvicultural treatments applied to a land condition |
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 |
TREATMENT_CD3 attribute describes silvicultural treatments applied to a land condition |
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 |
FLDSZCD attribute indicates the size class for a stand of trees. These codes form an ordinal set of ascending tree size within the stand. |
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 |
IS_STREET_TREE attribute indicates whether or not the tree is considered to be a street tree. |
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 |
TREECLCD attribute indicates the general quality of a tree. |
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 REF_LENGTH_METHOD table stores reference data for the HTCD attribute. Code for this attribute indicates the method used to measure the length of a tree. |
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 |
IS_MAINTAINED_AREA attribute indicates whether or not the ground occupied by the tree is maintained. |
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 |
IS_RIPARIAN attribute indicates whether or not the tree is considered to be in a riparian zone. |
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 |
STATUSCD attribute indicates the status of a 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 |
WATER_CD attribute is used to describe the presence and type of water encountered at a plot location. |
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 REF_ITREE_LANDUSE table stores reference data for the ITREE_LANDUSE attribute. Code for this attribute defines land uses based on a code set developed for the i-Tree inventory program. |
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 |
