FIADB-API v2.0.3 - View Report

Estimate Parameters

Numerator attribute number and description: 0201 Average annual net growth of sound bole volume of trees (at least 5 inches d.b.h./d.r.c.), in cubic feet, on forest land

Denominator attribute number and description: 0225 Average annual removals of sound bole volume of trees (at least 5 inches d.b.h./d.r.c.), in cubic feet, on forest land

FIADEF as the forest land definition

State/EVAL_GRP(s):

Georgia 132020

Row variable: Congressional District (based on values from the Current inventory).

Column variable: Ownership group - Major (based on values from the Current inventory).

Filtering clause(s) applied to numerator and demoninator: None

CONGRESSIONAL DISTRICT OWNERSHIP GROUP - MAJOR RATIO ESTIMATE RATIO SE PERCENT NUMERATOR ESTIMATE NUMERATOR PLOT COUNT DENOMINATOR ESTIMATE DENOMINATOR PLOT COUNT
Total Total 1.4927 4.104 2,095,640,439 4,796 1,403,891,829 1,212
Georgia District 1 (Carter, Buddy) Total 1.4134 9.938 331,093,220 656 234,258,936 189
Georgia District 2 (Bishop Jr., Sanford D.) Total 1.0630 10.326 226,508,908 697 213,092,240 216
Georgia District 3 (Ferguson, A. Drew) Total 1.8323 17.505 165,320,012 331 90,224,025 81
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) Total 0.7806 55.407 6,632,507 28 8,496,823 7
Georgia District 5 (Lewis, John) Total 7.1134 103.793 3,775,953 10 530,820 1
Georgia District 6 (McBath, Lucy) Total 0.0000 0.000 3,277,485 6 0 0
Georgia District 7 (Woodall, Robert) Total 0.7620 70.702 7,723,124 18 10,135,615 5
Georgia District 8 (Scott, Austin) Total 1.5242 10.467 297,307,102 674 195,059,562 196
Georgia District 9 (Collins, Doug) Total 3.2479 22.427 163,475,339 615 50,332,952 52
Georgia District 10 (Hice, Jody) Total 1.3457 9.769 342,138,270 652 254,240,126 188
Georgia District 11 (Loudermilk, Barry) Total 2.4786 40.593 35,071,915 63 14,149,884 15
Georgia District 12 (Allen, Rick) Total 1.3864 9.545 385,156,051 682 277,815,785 208
Georgia District 13 (Scott, David) Total 1.8894 53.153 21,243,189 47 11,243,503 8
Georgia District 14 (Graves, Tom) Total 2.4129 21.881 106,917,365 317 44,311,558 46
Total Public 3.2143 22.553 146,502,126 697 45,577,890 43
Total Private 1.5926 4.384 1,938,992,028 4,057 1,217,525,513 1,023
Total Not available 0.0721 13.074 10,146,285 178 140,788,426 175
Georgia District 1 (Carter, Buddy) Public 1.8837 32.889 39,890,238 101 21,176,249 15
Georgia District 1 (Carter, Buddy) Private 1.4396 10.597 289,628,824 550 201,184,495 164
Georgia District 1 (Carter, Buddy) Not available 0.1323 6.324 1,574,158 15 11,898,192 15
Georgia District 2 (Bishop Jr., Sanford D.) Public 1.3763 116.275 5,128,214 49 3,726,170 4
Georgia District 2 (Bishop Jr., Sanford D.) Private 1.1234 10.571 220,604,053 642 196,376,658 194
Georgia District 2 (Bishop Jr., Sanford D.) Not available 0.0598 22.270 776,641 22 12,989,413 20
Georgia District 3 (Ferguson, A. Drew) Public 12.3209 70.531 8,320,970 21 675,354 3
Georgia District 3 (Ferguson, A. Drew) Private 1.9770 19.386 156,152,031 308 78,986,074 64
Georgia District 3 (Ferguson, A. Drew) Not available 0.0802 25.674 847,010 16 10,562,597 16
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) Public 0.0000 0.000 2,216,073 3 0 0
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) Private 17.7272 86.625 4,289,034 21 241,947 1
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) Not available 0.0154 31.655 127,400 6 8,254,877 6
Georgia District 5 (Lewis, John) Public 0.0000 0.000 -209,813 1 0 0
Georgia District 5 (Lewis, John) Private 0.0000 0.000 3,962,146 9 0 0
Georgia District 5 (Lewis, John) Not available 0.0445 0.000 23,619 1 530,820 1
Georgia District 6 (McBath, Lucy) Private 0.0000 0.000 3,277,485 6 0 0
Georgia District 7 (Woodall, Robert) Public 0.0000 0.000 2,186,421 3 0 0
Georgia District 7 (Woodall, Robert) Private 5.3844 87.855 5,799,256 13 1,077,050 2
Georgia District 7 (Woodall, Robert) Not available -0.0290 -328.413 -262,554 3 9,058,565 3
Georgia District 8 (Scott, Austin) Public 3.2565 57.788 8,498,432 28 2,609,678 4
Georgia District 8 (Scott, Austin) Private 1.6233 11.143 287,649,220 634 177,197,809 165
Georgia District 8 (Scott, Austin) Not available 0.0760 26.507 1,159,451 32 15,252,075 33
Georgia District 9 (Collins, Doug) Public 88.6522 77.216 45,382,630 302 511,917 3
Georgia District 9 (Collins, Doug) Private 3.3221 28.432 117,221,522 316 35,284,909 32
Georgia District 9 (Collins, Doug) Not available 0.0599 28.217 871,187 20 14,536,125 20
Georgia District 10 (Hice, Jody) Public 1.4628 59.665 15,247,071 77 10,423,093 6
Georgia District 10 (Hice, Jody) Private 1.4867 10.207 324,492,593 571 218,263,912 166
Georgia District 10 (Hice, Jody) Not available 0.0939 16.105 2,398,606 19 25,553,121 19
Georgia District 11 (Loudermilk, Barry) Public 0.0000 0.000 2,136,865 4 0 0
Georgia District 11 (Loudermilk, Barry) Private 2.6494 44.206 33,095,872 58 12,491,774 12
Georgia District 11 (Loudermilk, Barry) Not available -0.0970 -140.852 -160,823 4 1,658,109 3
Georgia District 12 (Allen, Rick) Public 2.1157 102.144 7,114,085 26 3,362,469 1
Georgia District 12 (Allen, Rick) Private 1.4610 9.923 376,084,955 649 257,419,297 192
Georgia District 12 (Allen, Rick) Not available 0.1149 23.818 1,957,011 20 17,034,018 19
Georgia District 13 (Scott, David) Public 0.0000 0.000 892,646 4 0 0
Georgia District 13 (Scott, David) Private 3.1882 72.601 20,271,352 42 6,358,299 3
Georgia District 13 (Scott, David) Not available 0.0162 212.561 79,191 5 4,885,205 5
Georgia District 14 (Graves, Tom) Public 3.1356 58.854 9,698,294 78 3,092,960 7
Georgia District 14 (Graves, Tom) Private 2.9551 26.239 96,463,684 238 32,643,289 28
Georgia District 14 (Graves, Tom) Not available 0.0881 31.459 755,387 15 8,575,309 15

Metadata

Numerator Estimate Description

Denominator Estimate Description

Average annual sound cubic-foot removals on forest land. Trees that were live and on forest land at the time of the previous inventory and were removed from forest land by the time of the current inventory.
Footnote: Removals are cut and utilized trees, trees killed as a result of harvest operations but not utilized, and live trees associated with land-use reclassifications.
Tree: A woody plant usually having one or more erect perennial stems, a stem diameter at breast height of at least 3.0 inches, a more or less definitely formed crown of foliage, and a height of at least 15 feet at maturity.
Forest land: Land at least 10-percent canopy cover by trees of any size, including land that formerly had such tree cover and that will be naturally or artificially regenerated. Forest land includes transition zones, such as areas between heavily forested and nonforested lands that are at least 10-percent canopy cover with trees and forest areas adjacent to urban and builtup lands. Also included are pinyon-juniper and chaparral areas in the West and afforested areas. The minimum area for classification of forest land is 1 acre and 120 feet wide measured stem-to-stem from the outer-most edge. Unimproved roads and trails, streams, and clearings in forest areas are classified as forest if less than 120 feet wide.

Row classification variable description

Row variable=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, the congressional district code will be for the nearest congressional district in the correct State. This attribute is coded for the coterminous States and Alaska, and is left blank (null) in all other instances.

Column classification variable description

Column variable=Owner group major - ownership codes are collapsed into Public and Private categories.

Sampling design/estimation method: post-stratification, as described in:

Bechtold, W.A.; Patterson, P.L., eds. 2005. The Enhanced Forest Inventory and Analysis Program - National Sampling Design and Estimation Procedures. Gen. Tech. Rep. SRS - 80. Asheville, NC: U.S. Department of Agriculture, Forest Service, Southern Research Station. 85 p.

Web citation

USDA Forest Service, Forest Inventory and Analysis Program, Tue, 04 Oct 2022 16:56:19 GMT. Forest Inventory EVALIDator web-application Version 1.8.0.01. St. Paul, MN: U.S. Department of Agriculture, Forest Service, Northern Research Station. [Available only on internet: http://apps.fs.usda.gov/Evalidator/evalidator.jsp]

SQL Script

This SQL script can be used to derive estimates from FIA Data Base (FIADB)
SELECT num.GRP1, num.GRP2, num.ESTIMATE/den.ESTIMATE RATIO_ESTIMATED_VALUE, num.ESTIMATE NUM_ESTIMATED_VALUE, den.ESTIMATE DEN_ESTIMATED_VALUE FROM (SELECT GRP1, GRP2, sum(ESTIMATED_VALUE * EXPNS) ESTIMATE FROM (SELECT FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plotgeom.congcd) GRP1,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' when -1 then '`0003 Not available' ELSE '`0004 Unknown' END GRP2, plot.cn, plot.prev_plt_cn, plot.lat, plot.lon, pop_stratum.expns EXPNS, SUM(GRM.TPAGROW_UNADJ * (CASE WHEN COALESCE(GRM.SUBPTYP_GRM,0) = 0 THEN (0) WHEN GRM.SUBPTYP_GRM = 1 THEN POP_STRATUM.ADJ_FACTOR_SUBP WHEN GRM.SUBPTYP_GRM = 2 THEN POP_STRATUM.ADJ_FACTOR_MICR WHEN GRM.SUBPTYP_GRM = 3 THEN POP_STRATUM.ADJ_FACTOR_MACR ELSE (0) END) * (CASE WHEN BE.ONEORTWO = 2 THEN (CASE WHEN (GRM.COMPONENT = 'SURVIVOR' OR GRM.COMPONENT = 'INGROWTH' OR GRM.COMPONENT LIKE 'REVERSION%') THEN (TREE.VOLCFSND/PLOT.REMPER) WHEN (GRM.COMPONENT LIKE 'CUT%' OR GRM.COMPONENT LIKE 'DIVERSION%') THEN (TRE_MIDPT.VOLCFSND/PLOT.REMPER) ELSE (0) END) ELSE (CASE WHEN (GRM.COMPONENT = 'SURVIVOR' OR GRM.COMPONENT = 'CUT1' OR GRM.COMPONENT = 'DIVERSION1' OR GRM.COMPONENT = 'MORTALITY1') THEN CASE WHEN TRE_BEGIN.TRE_CN IS NOT NULL THEN -(TRE_BEGIN.VOLCFSND/PLOT.REMPER) ELSE -(PTREE.VOLCFSND/PLOT.REMPER) END ELSE (0) END) END)) AS ESTIMATED_VALUE FROM FS_FIADB.BEGINEND BE, FS_FIADB.POP_STRATUM POP_STRATUM JOIN FS_FIADB.POP_PLOT_STRATUM_ASSGN POP_PLOT_STRATUM_ASSGN ON (POP_STRATUM.CN = POP_PLOT_STRATUM_ASSGN.STRATUM_CN) JOIN FS_FIADB.PLOT PLOT ON (POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) JOIN FS_FIADB.PLOTGEOM PLOTGEOM ON (PLOT.CN = PLOTGEOM.CN) JOIN FS_FIADB.PLOT PPLOT ON (PLOT.PREV_PLT_CN = PPLOT.CN) JOIN FS_FIADB.COND PCOND ON (PLOT.PREV_PLT_CN = PCOND.PLT_CN) JOIN FS_FIADB.COND COND ON (PLOT.CN = COND.PLT_CN) JOIN FS_FIADB.TREE TREE ON (TREE.CONDID = COND.CONDID AND TREE.PLT_CN = PLOT.CN AND TREE.PREVCOND = PCOND.CONDID) LEFT OUTER JOIN FS_FIADB.TREE PTREE ON (TREE.PREV_TRE_CN = PTREE.CN) LEFT OUTER JOIN FS_FIADB.TREE_GRM_BEGIN TRE_BEGIN ON (TREE.CN = TRE_BEGIN.TRE_CN) LEFT OUTER JOIN FS_FIADB.TREE_GRM_MIDPT TRE_MIDPT ON (TREE.CN = TRE_MIDPT.TRE_CN) LEFT OUTER JOIN (SELECT TRE_CN, DIA_BEGIN, DIA_MIDPT, DIA_END, SUBP_COMPONENT_AL_FOREST AS COMPONENT, SUBP_SUBPTYP_GRM_AL_FOREST AS SUBPTYP_GRM, SUBP_TPAGROW_UNADJ_AL_FOREST AS TPAGROW_UNADJ FROM FS_FIADB.TREE_GRM_COMPONENT) GRM ON (TREE.CN = GRM.TRE_CN) WHERE 1=1 AND (((pop_stratum.rscd=33 and pop_stratum.evalid=132003))) and (1=1) and (1=1) GROUP BY pop_stratum.estn_unit_cn, pop_stratum.cn, plot.cn, plot.prev_plt_cn, plot.lat, plot.lon, pop_stratum.expns, FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plotgeom.congcd), 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' when -1 then '`0003 Not available' ELSE '`0004 Unknown' END) GROUP BY GRP1, GRP2 ORDER BY GRP1, GRP2) num join (SELECT GRP1, GRP2, sum(ESTIMATED_VALUE * EXPNS) ESTIMATE FROM (SELECT FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plotgeom.congcd) GRP1,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' when -1 then '`0003 Not available' ELSE '`0004 Unknown' END GRP2, plot.cn, plot.prev_plt_cn, plot.lat, plot.lon, pop_stratum.expns EXPNS, SUM(GRM.TPAREMV_UNADJ * (CASE WHEN COALESCE(GRM.SUBPTYP_GRM, 0) = 0 THEN (0) WHEN GRM.SUBPTYP_GRM = 1 THEN POP_STRATUM.ADJ_FACTOR_SUBP WHEN GRM.SUBPTYP_GRM = 2 THEN POP_STRATUM.ADJ_FACTOR_MICR WHEN GRM.SUBPTYP_GRM = 3 THEN POP_STRATUM.ADJ_FACTOR_MACR ELSE (0) END) * (CASE WHEN (GRM.COMPONENT LIKE 'CUT%' OR GRM.COMPONENT LIKE 'DIVERSION%') THEN TRE_MIDPT.VOLCFSND ELSE (0) END)) AS ESTIMATED_VALUE FROM FS_FIADB.POP_STRATUM POP_STRATUM JOIN FS_FIADB.POP_PLOT_STRATUM_ASSGN POP_PLOT_STRATUM_ASSGN ON (POP_STRATUM.CN = POP_PLOT_STRATUM_ASSGN.STRATUM_CN) JOIN FS_FIADB.PLOT PLOT ON (POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) JOIN FS_FIADB.PLOTGEOM PLOTGEOM ON (PLOT.CN = PLOTGEOM.CN) JOIN FS_FIADB.COND COND ON (PLOT.CN = COND.PLT_CN) JOIN (SELECT P.PREV_PLT_CN, T.* FROM FS_FIADB.PLOT P, FS_FIADB.TREE T WHERE P.CN = T.PLT_CN) TREE ON ((TREE.CONDID = COND.CONDID) AND (TREE.PLT_CN = COND.PLT_CN)) LEFT OUTER JOIN FS_FIADB.PLOT PPLOT ON (PLOT.PREV_PLT_CN = PPLOT.CN) LEFT OUTER JOIN FS_FIADB.COND PCOND ON ((TREE.PREVCOND = PCOND.CONDID) AND (TREE.PREV_PLT_CN = PCOND.PLT_CN)) LEFT OUTER JOIN FS_FIADB.TREE PTREE ON (TREE.PREV_TRE_CN = PTREE.CN) LEFT OUTER JOIN FS_FIADB.TREE_GRM_BEGIN TRE_BEGIN ON (TREE.CN = TRE_BEGIN.TRE_CN) LEFT OUTER JOIN FS_FIADB.TREE_GRM_MIDPT TRE_MIDPT ON (TREE.CN = TRE_MIDPT.TRE_CN) LEFT OUTER JOIN (SELECT TRE_CN, DIA_BEGIN, DIA_MIDPT, DIA_END, SUBP_COMPONENT_AL_FOREST AS COMPONENT, SUBP_SUBPTYP_GRM_AL_FOREST AS SUBPTYP_GRM, SUBP_TPAREMV_UNADJ_AL_FOREST AS TPAREMV_UNADJ FROM FS_FIADB.TREE_GRM_COMPONENT) GRM ON (TREE.CN = GRM.TRE_CN) WHERE 1=1 AND (((pop_stratum.rscd=33 and pop_stratum.evalid=132003))) and (1=1) and (1=1) GROUP BY pop_stratum.estn_unit_cn, pop_stratum.cn, plot.cn, plot.prev_plt_cn, plot.lat, plot.lon, pop_stratum.expns, FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plotgeom.congcd), 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' when -1 then '`0003 Not available' ELSE '`0004 Unknown' END) GROUP BY GRP1, GRP2 ORDER BY GRP1, GRP2) den ON num.GRP1=den.GRP1 AND num.GRP2=den.GRP2

Start time Tue, 04 Oct 2022 16:56:19 GMT

End time Tue, 04 Oct 2022 16:56:28 GMT

Email issues or comments to: SM.FS.FIA.Digital@usda.gov