Ownership group - Major | |||
---|---|---|---|
Congressional District | Total | Public | Private |
Total | 1.6423 | 5.1771 | 1.5612 |
Georgia District 1 (Carter, Buddy) | 1.2436 | 2.1074 | 1.1937 |
Georgia District 2 (Bishop Jr., Sanford D.) | 1.3960 | 7.3030 | 1.3497 |
Georgia District 3 (Ferguson, A. Drew) | 1.6203 | 12.1421 | 1.5577 |
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) | 3.7244 | - | 2.0229 |
Georgia District 5 (Lewis, John) | - | - | - |
Georgia District 6 (McBath, Lucy) | - | - | - |
Georgia District 7 (Woodall, Robert) | 7.5562 | - | 5.4893 |
Georgia District 8 (Scott, Austin) | 1.5641 | 5.2149 | 1.5330 |
Georgia District 9 (Collins, Doug) | 4.7185 | 73.0507 | 3.4454 |
Georgia District 10 (Hice, Jody) | 2.1208 | 4.6602 | 2.0528 |
Georgia District 11 (Loudermilk, Barry) | 2.0327 | - | 1.9014 |
Georgia District 12 (Allen, Rick) | 1.3817 | 1.9530 | 1.3736 |
Georgia District 13 (Scott, David) | 3.4613 | - | 3.1511 |
Georgia District 14 (Graves, Tom) | 2.5390 | 6.8085 | 2.3477 |
Ownership group - Major | |||
---|---|---|---|
Congressional District | Total | Public | Private |
Total | 2,036,202,634 | 144,074,646 | 1,892,127,988 |
Georgia District 1 (Carter, Buddy) | 327,131,522 | 30,278,811 | 296,852,711 |
Georgia District 2 (Bishop Jr., Sanford D.) | 264,617,391 | 10,765,524 | 253,851,867 |
Georgia District 3 (Ferguson, A. Drew) | 145,955,664 | 6,467,798 | 139,487,866 |
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) | 3,645,452 | 1,665,456 | 1,979,996 |
Georgia District 5 (Lewis, John) | 3,265,232 | -208,599 | 3,473,830 |
Georgia District 6 (McBath, Lucy) | 1,761,080 | - | 1,761,080 |
Georgia District 7 (Woodall, Robert) | 7,246,693 | 1,982,244 | 5,264,449 |
Georgia District 8 (Scott, Austin) | 301,821,980 | 8,489,038 | 293,332,943 |
Georgia District 9 (Collins, Doug) | 161,063,012 | 45,609,213 | 115,453,800 |
Georgia District 10 (Hice, Jody) | 335,980,986 | 19,264,981 | 316,716,005 |
Georgia District 11 (Loudermilk, Barry) | 22,025,725 | 1,422,731 | 20,602,994 |
Georgia District 12 (Allen, Rick) | 360,480,022 | 7,160,020 | 353,320,002 |
Georgia District 13 (Scott, David) | 18,171,770 | 1,628,484 | 16,543,286 |
Georgia District 14 (Graves, Tom) | 83,036,106 | 9,548,946 | 73,487,160 |
Ownership group - Major | |||
---|---|---|---|
Congressional District | Total | Public | Private |
Total | 1,239,820,901 | 27,829,433 | 1,211,991,468 |
Georgia District 1 (Carter, Buddy) | 263,045,632 | 14,367,820 | 248,677,812 |
Georgia District 2 (Bishop Jr., Sanford D.) | 189,550,179 | 1,474,115 | 188,076,065 |
Georgia District 3 (Ferguson, A. Drew) | 90,079,112 | 532,674 | 89,546,439 |
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) | 978,803 | - | 978,803 |
Georgia District 5 (Lewis, John) | - | - | - |
Georgia District 6 (McBath, Lucy) | - | - | - |
Georgia District 7 (Woodall, Robert) | 959,037 | - | 959,037 |
Georgia District 8 (Scott, Austin) | 192,968,239 | 1,627,839 | 191,340,400 |
Georgia District 9 (Collins, Doug) | 34,134,208 | 624,350 | 33,509,858 |
Georgia District 10 (Hice, Jody) | 158,420,788 | 4,133,938 | 154,286,851 |
Georgia District 11 (Loudermilk, Barry) | 10,835,932 | - | 10,835,932 |
Georgia District 12 (Allen, Rick) | 260,894,248 | 3,666,190 | 257,228,058 |
Georgia District 13 (Scott, David) | 5,250,011 | - | 5,250,011 |
Georgia District 14 (Graves, Tom) | 32,704,711 | 1,402,507 | 31,302,204 |
Ownership group - Major | |||
---|---|---|---|
Congressional District | Total | Public | Private |
Total | 4.28 | 26.68 | 4.34 |
Georgia District 1 (Carter, Buddy) | 9.93 | 38.70 | 10.22 |
Georgia District 2 (Bishop Jr., Sanford D.) | 9.93 | 75.01 | 9.97 |
Georgia District 3 (Ferguson, A. Drew) | 18.12 | 77.23 | 18.25 |
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) | 89.10 | - | 112.41 |
Georgia District 5 (Lewis, John) | - | - | - |
Georgia District 6 (McBath, Lucy) | - | - | - |
Georgia District 7 (Woodall, Robert) | 97.62 | - | 97.72 |
Georgia District 8 (Scott, Austin) | 10.55 | 73.43 | 10.63 |
Georgia District 9 (Collins, Doug) | 23.32 | 78.65 | 23.79 |
Georgia District 10 (Hice, Jody) | 11.02 | 76.08 | 11.08 |
Georgia District 11 (Loudermilk, Barry) | 39.83 | - | 39.37 |
Georgia District 12 (Allen, Rick) | 9.77 | 95.58 | 9.82 |
Georgia District 13 (Scott, David) | 81.55 | - | 81.23 |
Georgia District 14 (Graves, Tom) | 24.81 | 65.31 | 25.83 |
Ownership group - Major | |||
---|---|---|---|
Congressional District | Total | Public | Private |
Total | 4,627 | 605 | 4,042 |
Georgia District 1 (Carter, Buddy) | 655 | 94 | 562 |
Georgia District 2 (Bishop Jr., Sanford D.) | 678 | 47 | 633 |
Georgia District 3 (Ferguson, A. Drew) | 324 | 21 | 304 |
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) | 26 | 3 | 23 |
Georgia District 5 (Lewis, John) | 10 | 1 | 9 |
Georgia District 6 (McBath, Lucy) | 6 | - | 6 |
Georgia District 7 (Woodall, Robert) | 16 | 3 | 13 |
Georgia District 8 (Scott, Austin) | 656 | 27 | 630 |
Georgia District 9 (Collins, Doug) | 552 | 245 | 316 |
Georgia District 10 (Hice, Jody) | 632 | 67 | 567 |
Georgia District 11 (Loudermilk, Barry) | 61 | 3 | 59 |
Georgia District 12 (Allen, Rick) | 671 | 25 | 646 |
Georgia District 13 (Scott, David) | 45 | 4 | 41 |
Georgia District 14 (Graves, Tom) | 295 | 65 | 233 |
Ownership group - Major | |||
---|---|---|---|
Congressional District | Total | Public | Private |
Total | 1,120 | 31 | 1,089 |
Georgia District 1 (Carter, Buddy) | 200 | 11 | 189 |
Georgia District 2 (Bishop Jr., Sanford D.) | 201 | 2 | 199 |
Georgia District 3 (Ferguson, A. Drew) | 73 | 3 | 70 |
Georgia District 4 (Johnson, Henry C. "Hank" Jr.) | 4 | - | 4 |
Georgia District 5 (Lewis, John) | - | - | - |
Georgia District 6 (McBath, Lucy) | - | - | - |
Georgia District 7 (Woodall, Robert) | 2 | - | 2 |
Georgia District 8 (Scott, Austin) | 195 | 2 | 193 |
Georgia District 9 (Collins, Doug) | 37 | 3 | 34 |
Georgia District 10 (Hice, Jody) | 157 | 4 | 153 |
Georgia District 11 (Loudermilk, Barry) | 12 | - | 12 |
Georgia District 12 (Allen, Rick) | 196 | 1 | 195 |
Georgia District 13 (Scott, David) | 3 | - | 3 |
Georgia District 14 (Graves, Tom) | 40 | 5 | 35 |
This SQL script can be used to derive estimates from FIA Data Base (FIADB) |
SELECT pagestr, rowstr, colstr, sum(case den when 0 then 0 else num / den end) ratio,sum(num),sum(den) From (SELECT pagestr, rowstr, colstr, sum(ESTIMATED_VALUE) num, sum(Denom) den From ( select coalesce(pagestr,'`0000 Total') pagestr, coalesce(rowstr,'`0000 Total') rowstr, coalesce(colstr,'`0000 Total') colstr, sum(estimated_value) estimated_value,sum(denom) denom from (SELECT case 1 when 1 then '`0001 None`' end as pagestr, FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plot.congcd) as rowstr, 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 as colstr, 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))*POP_STRATUM.EXPNS) AS ESTIMATED_VALUE, 0 as denom 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 tree.prevcond=PCOND.condid and PCOND.cond_status_cd=1 and cond.cond_status_cd=1 AND ((pop_stratum.rscd=33 and pop_stratum.evalid=131803)) and 1=1 GROUP BY case 1 when 1 then '`0001 None`' end,FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plot.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 ) tmpxxx group by cube(pagestr,rowstr,colstr) Union select coalesce(pagestr,'`0000 Total') pagestr, coalesce(rowstr,'`0000 Total') rowstr, coalesce(colstr,'`0000 Total') colstr, sum(estimated_value) estimated_value,sum(denom) denom from (SELECT case 1 when 1 then '`0001 None`' end as pagestr, FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plot.congcd) as rowstr, 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 as colstr, SUM(0) AS ESTIMATED_VALUE, SUM(POP_STRATUM.EXPNS*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 DENOM 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 tree.prevcond=PCOND.condid and PCOND.cond_status_cd=1 and cond.cond_status_cd=1 AND ((pop_stratum.rscd=33 and pop_stratum.evalid=131803)) and 1=1 GROUP BY case 1 when 1 then '`0001 None`' end,FS_FIADB.EVALIDATORFUNCTIONS.congcdLabel(plot.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 ) tmpyyy group by cube(pagestr,rowstr,colstr)) tmptable GROUP BY pagestr, rowstr, colstr) tmp2table group by pagestr, rowstr, colstr order by pagestr, rowstr, colstr |
This RESTful Web Service call can be used to generate estimates directly from browser address line |
https://apps.fs.usda.gov/Evalidator/rest/Evalidator/fullreport?reptype=State&lat=0&lon=0&radius=0&snum=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&sdenom=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&wc=132018&pselected=None&rselected=Congressional District&cselected=Ownership group - Major&ptime=Current&rtime=Current&ctime=Current&wf=&wnum=&wnumdenom=&FIAorRPA=FIADEF&outputFormat=HTML&estOnly=N&schemaName=FS_FIADB. |