# EVALIDATOR_CHANGES

CHANGE:
Added EVALIDATOR_CHANGES table to database to record changes to EVALIDator program.


CHANGE:
Added CN field to POP_EVAL_TYP table and modified POP_EVAL_TYP import specification to reflect this change.


# ref_attribute_access

ATTRIBUTE_DESCR:
Harvest removals (and resulting non-utilized mortality) of all live on forestland (cuft per year)

VBA_SUMFROMWHERE:
SUM(TREE.FREMVCFAL*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.FREMVCFAL IS NOT NULL and 
 (NZ(tree.statuscd,0)=3 or (NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80)) and


ATTRIBUTE_DESCR:
IPCC forest carbon pool 2: live belowground (oven-dry metric tonnes)

VBA_SUMFROMWHERE:
SUM(0.90718474*COND.CONDPROP_UNADJ *
           ( NZ(COND.CARBON_UNDERSTORY_BG, 0) ) *
           IIF(COND.PROP_BASIS="MACR",PPP.ADJ_FACTOR_MACR,PPP.ADJ_FACTOR_SUBP) +
           nz(tree_bg(cond.plt_cn,cond.condid,ppp.adj_factor_micr, 
           ppp.adj_factor_subp, ppp.adj_factor_macr,plot.MACRO_BREAKPOINT_DIA),0)) AS "ESTIMATED_VALUE"
  FROM COND
 INNER JOIN((POP_PLOT_STRATUM_ASSGN
 INNER JOIN POP_STRATUM PPP
    ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
 INNER JOIN PLOT
    ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
 WHERE ((COND.COND_STATUS_CD) = 1)
   AND (COND.CONDPROP_UNADJ IS NOT NULL) AND


ATTRIBUTE_DESCR:
IPCC forest carbon pool 3: dead wood (oven-dry metric tonnes)

VBA_SUMFROMWHERE:
SUM(0.90718474*COND.CONDPROP_UNADJ *
           (NZ(COND.CARBON_STANDING_DEAD,0)+NZ(COND.CARBON_DOWN_DEAD,0)) *
           iif(COND.PROP_BASIS="MACR",PPP.ADJ_FACTOR_MACR,PPP.ADJ_FACTOR_SUBP)) AS ESTIMATED_VALUE
  FROM COND
 INNER JOIN((POP_PLOT_STRATUM_ASSGN
 INNER JOIN POP_STRATUM PPP
    ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
 INNER JOIN PLOT
    ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
 WHERE ((COND.COND_STATUS_CD) = 1)
   AND (COND.CONDPROP_UNADJ IS NOT NULL) AND


ATTRIBUTE_DESCR:
IPCC forest carbon pool 4: litter IPCC (oven-dry metric tonnes)

VBA_SUMFROMWHERE:
SUM(0.90718474*COND.CONDPROP_UNADJ *
           NZ(COND.CARBON_LITTER,0) *
           iif(COND.PROP_BASIS="MACR",PPP.ADJ_FACTOR_MACR,PPP.ADJ_FACTOR_SUBP) ) AS ESTIMATED_VALUE
  FROM COND
 INNER JOIN((POP_PLOT_STRATUM_ASSGN
 INNER JOIN POP_STRATUM PPP
    ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
 INNER JOIN PLOT
    ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
 WHERE ((COND.COND_STATUS_CD) = 1)
   AND (COND.CONDPROP_UNADJ IS NOT NULL) AND


ATTRIBUTE_DESCR:
IPCC forest carbon pool 5: soil organic (oven-dry metric tonnes)

VBA_SUMFROMWHERE:
SUM(0.90718474*COND.CONDPROP_UNADJ *
           NZ(COND.CARBON_SOIL_ORG,0) *
           iif(COND.PROP_BASIS="MACR",PPP.ADJ_FACTOR_MACR,PPP.ADJ_FACTOR_SUBP)) AS ESTIMATED_VALUE
  FROM COND
 INNER JOIN((POP_PLOT_STRATUM_ASSGN
 INNER JOIN POP_STRATUM PPP
    ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
 INNER JOIN PLOT
    ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
 WHERE ((COND.COND_STATUS_CD) = 1)
   AND (COND.CONDPROP_UNADJ IS NOT NULL) AND


ATTRIBUTE_DESCR:
Harvest removals (and resulting non-utilized mortality) of growing stock on forestland (cuft per year)

VBA_SUMFROMWHERE:
SUM(TREE.FREMVCFGS*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE"
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.FREMVCFAL IS NOT NULL and 
 (NZ(tree.statuscd,0)=3 or (NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80)) and


ATTRIBUTE_DESCR:
Harvest removals (and resulting non-utilized mortality) of sawtimber on forestland (bdft per year)

VBA_SUMFROMWHERE:
SUM(TREE.FREMVBFSL*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE"
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.FREMVBFSL IS NOT NULL and 
 (NZ(tree.statuscd,0)=3 or (NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80)) and


ATTRIBUTE_DESCR:
Harvest removals (and resulting non-utilized mortality) of all live on timberland (cuft per year)

VBA_SUMFROMWHERE:
SUM(TREE.REMVCFAL*TREE.TPAREMV_UNADJ* 
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE"
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.REMVCFAL IS NOT NULL and 
 (NZ(tree.statuscd,0)=3 or (NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80)) and


ATTRIBUTE_DESCR:
Harvest removals (and resulting non-utilized mortality) of growing-stock on timberland (cuft per year)

VBA_SUMFROMWHERE:
SUM(TREE.REMVCFGS*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.REMVCFGS IS NOT NULL and 
 (NZ(tree.statuscd,0)=3 or (NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80)) and


ATTRIBUTE_DESCR:
Harvest removals (and resulting non-utilized mortality) of sawtimber on timberland (bdft per year)

VBA_SUMFROMWHERE:
SUM(TREE.REMVBFSL*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.REMVBFSL IS NOT NULL and 
 (NZ(tree.statuscd,0)=3 or (NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80)) and


ATTRIBUTE_DESCR:
Other removals (due to land-use reclassification)of all live on forestland (cuft per year)

VBA_SUMFROMWHERE:
SUM(TREE.FREMVCFAL*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE"
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.FREMVCFAL IS NOT NULL and 
 not(NZ(tree.statuscd,0)=3) and not(NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80) and


ATTRIBUTE_DESCR:
Other removals (due to land-use reclassification) of growing stock on forestland (cuft per year)

VBA_SUMFROMWHERE:
SUM(TREE.FREMVCFGS*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.FREMVCFGS IS NOT NULL and 
 not(NZ(tree.statuscd,0)=3) and not(NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80) and


ATTRIBUTE_DESCR:
Other removals (due to land-use reclassification) of sawtimber on forestland (bdft per year)

VBA_SUMFROMWHERE:
SUM(TREE.FREMVBFSL*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.FREMVBFSL IS NOT NULL and 
 not(NZ(tree.statuscd,0)=3) and not(NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80) and


ATTRIBUTE_DESCR:
Other removals (due to land-use reclassification) of all live on timberland (cuft per year)

VBA_SUMFROMWHERE:
SUM(TREE.REMVCFAL*TREE.TPAREMV_UNADJ* 
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.REMVCFAL IS NOT NULL and 
 not(NZ(tree.statuscd,0)=3) and not(NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80) and


ATTRIBUTE_DESCR:
Other removals (due to land-use reclassification) of growing-stock on timberland (cuft per year)

VBA_SUMFROMWHERE:
SUM(TREE.REMVCFGS*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.REMVCFGS IS NOT NULL and 
 not(NZ(tree.statuscd,0)=3) and not(NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80) and


ATTRIBUTE_DESCR:
Other removals (due to land-use reclassification) of sawtimber on timberland (bdft per year)

VBA_SUMFROMWHERE:
SUM(TREE.REMVBFSL*TREE.TPAREMV_UNADJ*
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 TREE.TPAREMV_UNADJ IS NOT NULL AND TREE.REMVBFSL IS NOT NULL and 
 not(NZ(tree.statuscd,0)=3) and not(NZ(tree.statuscd,0)=2 and NZ(tree.agentcd,0)=80) and


ATTRIBUTE_DESCR:
Volume of standing dead trees on forestland (cuft)

VBA_SUMFROMWHERE:
SUM(TREE.TPA_UNADJ*TREE.VOLCFNET* 
            IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR)))) 
   AS "ESTIMATED_VALUE" 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=2) AND (TREE.STANDING_DEAD_CD=1) AND TREE.CONDID=COND.CONDID AND ((COND.COND_STATUS_CD)=1) AND 
 TREE.TPA_UNADJ IS NOT NULL AND TREE.VOLCFNET IS NOT NULL AND


ATTRIBUTE_DESCR:
Aboveground bark biomass on forestland (oven-dry short tons)

VBA_SUMFROMWHERE:
SUM(TREE.TPA_UNADJ *
(BARK_VOL_PCT / (100 + BARK_VOL_PCT) * BARK_SPGR_GREENVOL_DRYWT) /
((1 - (BARK_VOL_PCT / (100 + BARK_VOL_PCT))) * WOOD_SPGR_GREENVOL_DRYWT)*
           (NZ(TREE.DRYBIO_BOLE, 0) + NZ(TREE.DRYBIO_TOP, 0) +
           NZ(TREE.DRYBIO_STUMP, 0) + NZ(TREE.DRYBIO_SAPLING, 0) +
           NZ(TREE.DRYBIO_WDLD_SPP, 0)) *
           IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR))))
                                      / 2000 AS "ESTIMATED_VALUE"
  FROM (TREE INNER JOIN(COND INNER JOIN((POP_PLOT_STRATUM_ASSGN INNER JOIN
                              POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
                              PPP.CN) INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN =
                             PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON
        TREE.PLT_CN = PLOT.CN)
 INNER JOIN REF_SPECIES ON TREE.SPCD = REF_SPECIES.SPCD
 WHERE ((TREE.STATUSCD) = 1)
   AND ((COND.COND_STATUS_CD) = 1)
   AND TREE.CONDID = COND.CONDID
   AND TREE.TPA_UNADJ IS NOT NULL
   AND (TREE.DRYBIO_BOLE IS NOT NULL OR TREE.DRYBIO_TOP IS NOT NULL OR
       TREE.DRYBIO_STUMP IS NOT NULL OR TREE.DRYBIO_SAPLING IS NOT NULL OR
       TREE.DRYBIO_WDLD_SPP IS NOT NULL) 
AND


ATTRIBUTE_DESCR:
All live tree and sapling aboveground biomass on forestland (green short tons)

VBA_SUMFROMWHERE:
SUM(TREE.TPA_UNADJ*((1.0+MC_PCT_GREEN_WOOD*.01)*(BARK_VOL_PCT/(100+BARK_VOL_PCT)*WOOD_SPGR_GREENVOL_DRYWT)  
+ (1.0+MC_PCT_GREEN_BARK*.01)*(1-(BARK_VOL_PCT/(100+BARK_VOL_PCT))*BARK_SPGR_GREENVOL_DRYWT))*(NZ(TREE.DRYBIO_BOLE,0)+NZ(TREE.DRYBIO_TOP,0)+NZ(TREE.DRYBIO_STUMP,0)+NZ(TREE.DRYBIO_SAPLING,0)+NZ(TREE.DRYBIO_WDLD_SPP,0))*
IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR))))
                                            /2000  
   AS "ESTIMATED_VALUE" 
 FROM 
 REF_SPECIES INNER JOIN(
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 ) ON TREE.SPCD=REF_SPECIES.SPCD
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) AND TREE.CONDID=COND.CONDID AND 
 TREE.TPA_UNADJ IS NOT NULL AND 
 (TREE.DRYBIO_BOLE IS NOT NULL OR
  TREE.DRYBIO_TOP IS NOT NULL OR
  TREE.DRYBIO_STUMP IS NOT NULL OR
  TREE.DRYBIO_SAPLING IS NOT NULL OR
  TREE.DRYBIO_WDLD_SPP IS NOT NULL) 
 AND


ATTRIBUTE_DESCR:
Standing dead tree aboveground biomass on forestland (oven-dry short tons)

VBA_SUMFROMWHERE:
SUM(TREE.TPA_UNADJ*(NZ(TREE.DRYBIO_BOLE,0)+NZ(TREE.DRYBIO_TOP,0)+NZ(TREE.DRYBIO_STUMP,0)+NZ(TREE.DRYBIO_SAPLING,0)+NZ(TREE.DRYBIO_WDLD_SPP,0))*
IIF(ISNULL(TREE.DIA),PPP.ADJ_FACTOR_SUBP,
                              IIF(TREE.DIA<5,
                                     PPP.ADJ_FACTOR_MICR,
                                     IIF(TREE.DIA<NZ(PLOT.MACRO_BREAKPOINT_DIA,9999),PPP.ADJ_FACTOR_SUBP,PPP.ADJ_FACTOR_MACR))))
                                            /2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=2) AND (TREE.STANDING_DEAD_CD=1) AND ((COND.COND_STATUS_CD)=1) AND TREE.CONDID=COND.CONDID AND 
 TREE.TPA_UNADJ IS NOT NULL AND 
 (TREE.DRYBIO_BOLE IS NOT NULL OR
  TREE.DRYBIO_TOP IS NOT NULL OR
  TREE.DRYBIO_STUMP IS NOT NULL OR
  TREE.DRYBIO_SAPLING IS NOT NULL OR
  TREE.DRYBIO_WDLD_SPP IS NOT NULL) 
 AND


ATTRIBUTE_DESCR:
Total forest land carbon (oven-dry short tons)

VBA_SUMFROMWHERE:
SUM(COND.CONDPROP_UNADJ *
           (NZ(COND.CARBON_DOWN_DEAD, 0) + 
           NZ(COND.CARBON_LITTER, 0) +
           NZ(COND.CARBON_SOIL_ORG, 0) +
           NZ(COND.CARBON_STANDING_DEAD, 0) +
           NZ(COND.CARBON_UNDERSTORY_AG, 0) +
           NZ(COND.CARBON_UNDERSTORY_BG, 0)) *           
           IIF(COND.PROP_BASIS="MACR",PPP.ADJ_FACTOR_MACR,PPP.ADJ_FACTOR_SUBP) +
           nz(tree_ag_bg_english(cond.plt_cn,cond.condid,ppp.adj_factor_micr, 
           ppp.adj_factor_subp, ppp.adj_factor_macr,plot.MACRO_BREAKPOINT_DIA),0)) AS "ESTIMATED_VALUE"
  FROM COND
 INNER JOIN((POP_PLOT_STRATUM_ASSGN
 INNER JOIN POP_STRATUM PPP
    ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
 INNER JOIN PLOT
    ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
 WHERE ((COND.COND_STATUS_CD) = 1)
   AND (COND.CONDPROP_UNADJ IS NOT NULL) AND


VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj*IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1) and  (COND.CONDPROP_UNADJ IS NOT NULL) AND


VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj*IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.RESERVCD) = 0)
    AND ((COND.SITECLCD) = 1 Or (COND.SITECLCD) = 2 Or (COND.SITECLCD) = 3 Or
 (COND.SITECLCD) = 4 Or (COND.SITECLCD) = 5 Or (COND.SITECLCD) = 6)
    AND ((COND.COND_STATUS_CD) = 1) and (COND.CONDPROP_UNADJ IS NOT NULL) AND


ATTRIBUTE_DESCR:
Number of all live trees on forestland(trees)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Number of standing dead trees 5""+ dbh on forestland(trees)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.STATUSCD=2 AND TREE.DIA>=5 AND TREE.STANDING_DEAD_CD=1 and ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Number of all live trees on timberland(trees)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.RESERVCD)=0) 
      AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) 
      AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND TREE.DIA>=1.0 AND
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Number of standing dead trees 5""+ dbh on timberland(trees)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.STATUSCD=2 AND TREE.DIA>=5 AND TREE.STANDING_DEAD_CD=1 and TREE.CONDID=COND.CONDID 
 and COND.COND_STATUS_CD=1 and COND.RESERVCD = 0 
    AND ((COND.SITECLCD) = 1 Or (COND.SITECLCD) = 2 Or (COND.SITECLCD) = 3 Or 
 (COND.SITECLCD) = 4 Or (COND.SITECLCD) = 5 Or (COND.SITECLCD) = 6) and 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live merchantable biomass on forestland oven-dry(tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.drybio_bole* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and tree.drybio_bole is not null and


ATTRIBUTE_DESCR:
All live tree and sapling aboveground biomass on timberland oven-dry (tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_bole,0)+nz(tree.drybio_top,0)+nz(tree.drybio_stump,0)+nz(tree.drybio_sapling,0)+nz(tree.drybio_wdld_spp,0))*   
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 ((COND.RESERVCD)=0) 
 AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Volume of growing-stock on forestland(cuft)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volcfnet* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) and tree.treeclcd=2 and TREE.CONDID=COND.CONDID AND ((COND.COND_STATUS_CD)=1) AND 
 tree.TPA_UNADJ is not null and tree.volcfnet is not null and


ATTRIBUTE_DESCR:
Volume of growing-stock on timberland(cuft)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volcfnet* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1)  
      AND ((TREE.TREECLCD)=2) 
      AND ((COND.RESERVCD)=0) 
      AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) 
      AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and tree.volcfnet is not null and TREE.VOLCFNET>0 AND


ATTRIBUTE_DESCR:
Volume of sawlog portion on timberland(cuft)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volcsnet* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) and tree.treeclcd=2 and TREE.CONDID=COND.CONDID and 
      ((COND.RESERVCD)=0) 
      AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) 
      AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and tree.volcsnet is not null and


VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volbfnet* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1)  
      AND ((TREE.TREECLCD)=2) 
      AND ((COND.RESERVCD)=0) 
      AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) 
      AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and tree.volbfnet is not null and


ATTRIBUTE_DESCR:
All live gross volume on forestland(cuft)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volcfgrs* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) and TREE.CONDID=COND.CONDID AND ((COND.COND_STATUS_CD)=1) AND 
 tree.TPA_UNADJ is not null and tree.volcfgrs is not null and


ATTRIBUTE_DESCR:
Net growth of growing stock on forestland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FGROWCFGS*TREE.TPAGROW_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAGROW_UNADJ is not null and tree.FGROWCFGS is not null and


ATTRIBUTE_DESCR:
Net growth of growing-stock on timberland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.GROWCFGS*TREE.TPAGROW_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAGROW_UNADJ is not null and tree.GROWCFGS is not null and


ATTRIBUTE_DESCR:
Mortality of all live on forestland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FMORTCFAL*TREE.TPAMORT_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAMORT_UNADJ is not null and tree.FMORTCFAL is not null and


ATTRIBUTE_DESCR:
Mortality of growing-stock on forestland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FMORTCFGS*TREE.TPAMORT_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAMORT_UNADJ is not null and tree.FMORTCFGS is not null and


ATTRIBUTE_DESCR:
Mortality of all live on timberland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.MORTCFAL*TREE.TPAMORT_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAMORT_UNADJ is not null and tree.MORTCFAL is not null and


ATTRIBUTE_DESCR:
Mortality of growing-stock on timberland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.MORTCFGS*TREE.TPAMORT_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAMORT_UNADJ is not null and tree.MORTCFGS is not null and


ATTRIBUTE_DESCR:
Mortality of sawtimber on timberland(bdft per year)

VBA_SUMFROMWHERE:
Sum(TREE.MORTBFSL*TREE.TPAMORT_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAMORT_UNADJ is not null and tree.MORTBFSL is not null and


ATTRIBUTE_DESCR:
Removals of all live on forestland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FREMVCFAL*TREE.TPAREMV_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAREMV_UNADJ is not null and tree.FREMVCFAL is not null and


ATTRIBUTE_DESCR:
Removals of growing stock on forestland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FREMVCFGS*TREE.TPAREMV_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAREMV_UNADJ is not null and tree.FREMVCFGS is not null and


ATTRIBUTE_DESCR:
Removals of growing-stock on timberland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.REMVCFGS*TREE.TPAREMV_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAREMV_UNADJ is not null and tree.REMVCFGS is not null and


VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volcfnet* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) and TREE.CONDID=COND.CONDID AND ((COND.COND_STATUS_CD)=1) AND 
 tree.TPA_UNADJ is not null and tree.volcfnet is not null and


ATTRIBUTE_DESCR:
All live gross sawtimber volume on forestland(bdft)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volbfgrs* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) and tree.treeclcd=2 and TREE.CONDID=COND.CONDID AND ((COND.COND_STATUS_CD)=1) AND 
 tree.TPA_UNADJ is not null and tree.volbfgrs is not null and


ATTRIBUTE_DESCR:
Removals of sawtimber on forestland(bdft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FREMVBFSL*TREE.TPAREMV_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAREMV_UNADJ is not null and tree.FREMVBFSL is not null and


ATTRIBUTE_DESCR:
Number of growing-stock trees on forestland(trees)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND (TREE.TREECLCD=2) and ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Number of growing-stock trees on timberland(trees)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1)  
      AND ((TREE.TREECLCD)=2) 
      AND ((COND.RESERVCD)=0) 
      AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) 
      AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND TREE.DIA>=1.0 AND
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live tree and sapling aboveground biomass on forestland oven-dry(tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_bole,0)+nz(tree.drybio_top,0)+nz(tree.drybio_stump,0)+nz(tree.drybio_sapling,0)+nz(tree.drybio_wdld_spp,0))*      
 IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr,       
 IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,       
 IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and 
 (tree.drybio_bole is not null or
  tree.drybio_top is not null or
  tree.drybio_stump is not null or
  tree.drybio_sapling is not null or
  tree.drybio_wdld_spp is not null) 
 and


ATTRIBUTE_DESCR:
All live merchantable biomass on timberland oven-dry(tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.drybio_bole* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 ((COND.RESERVCD)=0) 
 AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 tree.TPA_UNADJ is not null and tree.drybio_bole is not null and


ATTRIBUTE_DESCR:
Volume of sawlog portion on forestland(cuft)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volcsnet* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) and tree.treeclcd=2 and TREE.CONDID=COND.CONDID and ((COND.COND_STATUS_CD)=1) AND 
 tree.TPA_UNADJ is not null and tree.volcsnet is not null and


VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volbfnet* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) and tree.treeclcd=2 and TREE.CONDID=COND.CONDID AND ((COND.COND_STATUS_CD)=1) AND 
 tree.TPA_UNADJ is not null and tree.volbfnet is not null and


ATTRIBUTE_DESCR:
All live sound volume on forestland(cuft)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volcfsnd* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) and TREE.CONDID=COND.CONDID AND ((COND.COND_STATUS_CD)=1) AND 
 tree.TPA_UNADJ is not null and tree.volcfsnd is not null and


ATTRIBUTE_DESCR:
Net growth of sawtimber on forestland(bdft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FGROWBFSL*TREE.TPAGROW_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAGROW_UNADJ is not null and tree.FGROWBFSL is not null and


ATTRIBUTE_DESCR:
Net growth of all live on timberland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.GROWCFAL*TREE.TPAGROW_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAGROW_UNADJ is not null and tree.GROWCFAL is not null and


ATTRIBUTE_DESCR:
Net growth of sawtimber on timberland(bdft per year)

VBA_SUMFROMWHERE:
Sum(TREE.GROWBFSL*TREE.TPAGROW_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAGROW_UNADJ is not null and tree.GROWBFSL is not null and


ATTRIBUTE_DESCR:
Mortality of all live trees on forestland(trees per year)

VBA_SUMFROMWHERE:
Sum(TREE.TPAMORT_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAMORT_UNADJ is not null and


ATTRIBUTE_DESCR:
Mortality of sawtimber on forestland(bdft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FMORTBFSL*TREE.TPAMORT_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAMORT_UNADJ is not null and tree.FMORTBFSL is not null and


ATTRIBUTE_DESCR:
Mortality of all live trees on timberland(trees per year)


ATTRIBUTE_DESCR:
Removals of all live on timberland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.REMVCFAL*TREE.TPAREMV_UNADJ* IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAREMV_UNADJ is not null and tree.REMVCFAL is not null and


ATTRIBUTE_DESCR:
Removals of sawtimber on timberland(bdft per year)

VBA_SUMFROMWHERE:
Sum(TREE.REMVBFSL*TREE.TPAREMV_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAREMV_UNADJ is not null and tree.REMVBFSL is not null and


VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*tree.volcfnet* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(plot.MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(tree.dia<plot.MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.RESERVCD)=0) 
      AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) 
      AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and tree.volcfnet is not null and


ATTRIBUTE_DESCR:
Net growth of all live on forestland(cuft per year)

VBA_SUMFROMWHERE:
Sum(TREE.FGROWCFAL*TREE.TPAGROW_UNADJ*
 IIf(IsNull(TREE.dia),PPP.adj_factor_subp,IIf(TREE.dia<5,PPP.adj_factor_micr,IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp,
 IIf(TREE.dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,PPP.adj_factor_macr)))))   
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE TREE.CONDID=COND.CONDID AND 
 tree.TPAGROW_UNADJ is not null and tree.FGROWCFAL is not null and


ATTRIBUTE_DESCR:
Carbon in understory belowground on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_UNDERSTORY_BG  *IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1) and  (COND.CONDPROP_UNADJ IS NOT NULL) AND
  COND.CARBON_UNDERSTORY_BG is not null and


ATTRIBUTE_DESCR:
Carbon in down dead on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_DOWN_DEAD*IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1) and  (COND.CONDPROP_UNADJ IS NOT NULL) AND
  COND.CARBON_DOWN_DEAD is not null and


ATTRIBUTE_DESCR:
Soil organic carbon on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj *COND.CARBON_SOIL_ORG*IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1) and  (COND.CONDPROP_UNADJ IS NOT NULL) AND
  COND.CARBON_SOIL_ORG is not null and


ATTRIBUTE_DESCR:
Carbon in live trees and saplings aboveground on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.carbon_ag,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Carbon in live trees and saplings above and belowground on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.carbon_ag,0)+nz(tree.carbon_bg,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live top and limb biomass on forestland oven-dry(short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_top,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live stump (ground to 12 inches) biomass on forestland oven-dry(short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_stump,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live belowground tree and sapling biomass on forestland oven-dry(short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_bg,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Carbon in understory belowground on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_UNDERSTORY_BG  *
IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1)  AND COND.RESERVCD=0 
  AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
  Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
  (COND.CONDPROP_UNADJ IS NOT NULL) AND COND.CARBON_UNDERSTORY_BG IS NOT NULL AND


ATTRIBUTE_DESCR:
Carbon in down dead on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_DOWN_DEAD*
IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1)  
  AND COND.RESERVCD=0
  AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
  Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
  (COND.CONDPROP_UNADJ IS NOT NULL) AND COND.CARBON_DOWN_DEAD IS NOT NULL AND


ATTRIBUTE_DESCR:
Soil organic carbon on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj *COND.CARBON_SOIL_ORG*
IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1)  
  AND COND.RESERVCD=0
  AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
  Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
  (COND.CONDPROP_UNADJ IS NOT NULL) AND COND.CARBON_SOIL_ORG IS NOT NULL AND


ATTRIBUTE_DESCR:
Carbon in live trees belowground on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.carbon_bg,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1)  
 AND COND.RESERVCD=0 
 AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Carbon in standing dead trees on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_STANDING_DEAD *IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1) and  (COND.CONDPROP_UNADJ IS NOT NULL)
  and COND.CARBON_STANDING_DEAD is not null and


ATTRIBUTE_DESCR:
Carbon in understory aboveground on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_UNDERSTORY_AG  *IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1) and  (COND.CONDPROP_UNADJ IS NOT NULL) AND
  COND.CARBON_UNDERSTORY_AG is not null and


ATTRIBUTE_DESCR:
Carbon in litter on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_LITTER*IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1) and  (COND.CONDPROP_UNADJ IS NOT NULL) AND
  COND.CARBON_LITTER is not null and


ATTRIBUTE_DESCR:
Carbon in live trees and saplings belowground on forestland (short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.carbon_bg,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live sapling biomass on forestland oven-dry(short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_sapling,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Carbon in standing dead trees on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_STANDING_DEAD *IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1) AND COND.RESERVCD=0
  AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
  (COND.CONDPROP_UNADJ IS NOT NULL) AND COND.CARBON_STANDING_DEAD IS NOT NULL AND


ATTRIBUTE_DESCR:
Carbon in understory aboveground on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_UNDERSTORY_AG  *
IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1)  AND 
  COND.RESERVCD=0 AND
  ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
  Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
  (COND.CONDPROP_UNADJ IS NOT NULL) AND COND.CARBON_UNDERSTORY_AG IS NOT NULL AND


ATTRIBUTE_DESCR:
All live top and limb biomass on timberland oven-dry(short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_top,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1)  
 AND COND.RESERVCD=0
 AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live stump (ground to 12 inches) biomass on timberland oven-dry(short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_stump,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1)
 AND COND.RESERVCD=0 
 AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live belowground tree and sapling biomass on timberland oven-dry(short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_bg,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) 
 AND COND.RESERVCD=0 
 AND ((COND.COND_STATUS_CD)=1)  AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Carbon in live trees and saplings aboveground on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.carbon_ag,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1)  
 AND COND.RESERVCD=0 
 AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Carbon in live trees above and belowground on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.carbon_ag,0)+nz(tree.carbon_bg,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1)  
 AND COND.RESERVCD=0 
 AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live sapling biomass on timberland oven-dry(short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_sapling,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1)
 AND COND.RESERVCD=0
 AND ((COND.COND_STATUS_CD)=1)  AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
 TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj*IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE (COND.CONDPROP_UNADJ IS NOT NULL) AND COND.COND_STATUS_CD<5 AND


ATTRIBUTE_DESCR:
Carbon in litter on timberland (short tons)

VBA_SUMFROMWHERE:
SUM(cond.condprop_unadj * COND.CARBON_LITTER*
IIf(COND.prop_basis= "MACR", ppp.adj_factor_macr, ppp.adj_factor_subp)) AS ESTIMATED_VALUE
   FROM COND
  INNER JOIN((POP_PLOT_STRATUM_ASSGN
  INNER JOIN POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN =
       PPP.CN)
  INNER JOIN PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
  WHERE  ((COND.COND_STATUS_CD) = 1)  
  AND COND.RESERVCD=0
  AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
  Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) and 
  (COND.CONDPROP_UNADJ IS NOT NULL) AND COND.CARBON_LITTER IS NOT NULL AND


ATTRIBUTE_DESCR:
All live woodland species biomass on forestland oven-dry (short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_wdld_spp,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
All live woodland species biomass on timberland oven-dry (short tons)

VBA_SUMFROMWHERE:
SUM(tree.TPA_UNADJ*(nz(tree.drybio_wdld_spp,0))* 
      IIf(IsNull(tree.dia),PPP.adj_factor_subp,IIf(tree.dia<5,PPP.adj_factor_micr, 
      IIf(IsNull(MACRO_BREAKPOINT_DIA),PPP.adj_factor_subp, 
      IIf(dia<MACRO_BREAKPOINT_DIA,PPP.adj_factor_subp,adj_factor_macr)))))/2000  
   AS ESTIMATED_VALUE 
 FROM 
 TREE INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON TREE.PLT_CN = PLOT.CN 
 WHERE ((TREE.STATUSCD)=1) AND ((COND.COND_STATUS_CD)=1) and (COND.RESERVCD=0) 
 AND ((COND.SITECLCD)=1 Or (COND.SITECLCD)=2 Or (COND.SITECLCD)=3 
 Or (COND.SITECLCD)=4 Or (COND.SITECLCD)=5 Or (COND.SITECLCD)=6) 
 and TREE.CONDID=COND.CONDID AND 
 tree.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
IPCC forest carbon total: all 5 pools (oven-dry metric tonnes)

VBA_SUMFROMWHERE:
SUM(0.90718474*COND.CONDPROP_UNADJ *
           (NZ(COND.CARBON_DOWN_DEAD, 0) + 
           NZ(COND.CARBON_LITTER, 0) +
           NZ(COND.CARBON_SOIL_ORG, 0) +
           NZ(COND.CARBON_STANDING_DEAD, 0) +
           NZ(COND.CARBON_UNDERSTORY_AG, 0) +
           NZ(COND.CARBON_UNDERSTORY_BG, 0)) *           
           IIF(COND.PROP_BASIS="MACR",PPP.ADJ_FACTOR_MACR,PPP.ADJ_FACTOR_SUBP) +
           nz(tree_ag_bg(cond.plt_cn,cond.condid,ppp.adj_factor_micr, 
           ppp.adj_factor_subp, ppp.adj_factor_macr,plot.MACRO_BREAKPOINT_DIA),0)) AS "ESTIMATED_VALUE"
  FROM COND
 INNER JOIN((POP_PLOT_STRATUM_ASSGN
 INNER JOIN POP_STRATUM PPP
    ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
 INNER JOIN PLOT
    ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
 WHERE ((COND.COND_STATUS_CD) = 1)
   AND (COND.CONDPROP_UNADJ IS NOT NULL) AND


ATTRIBUTE_DESCR:
IPCC forest carbon pool 1: live aboveground (oven-dry metric tonnes)

VBA_SUMFROMWHERE:
SUM(0.90718474*COND.CONDPROP_UNADJ *
           ( NZ(COND.CARBON_UNDERSTORY_AG, 0) ) *
           IIF(COND.PROP_BASIS="MACR",PPP.ADJ_FACTOR_MACR,PPP.ADJ_FACTOR_SUBP) +
           nz(tree_ag(cond.plt_cn,cond.condid,ppp.adj_factor_micr, 
           ppp.adj_factor_subp, ppp.adj_factor_macr,plot.MACRO_BREAKPOINT_DIA),0)) AS "ESTIMATED_VALUE"
  FROM COND
 INNER JOIN((POP_PLOT_STRATUM_ASSGN
 INNER JOIN POP_STRATUM PPP
    ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN)
 INNER JOIN PLOT
    ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN
 WHERE ((COND.COND_STATUS_CD) = 1)
   AND (COND.CONDPROP_UNADJ IS NOT NULL) AND


ATTRIBUTE_DESCR:
Number of live seedlings on forestland(seedlings)

VBA_SUMFROMWHERE:
SUM(SEEDLING.TPA_UNADJ* PPP.adj_factor_micr) 
   AS ESTIMATED_VALUE 
 FROM 
 SEEDLING INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON SEEDLING.PLT_CN = PLOT.CN 
 WHERE ((COND.COND_STATUS_CD)=1) and SEEDLING.CONDID=COND.CONDID AND 
 SEEDLING.TPA_UNADJ is not null and


ATTRIBUTE_DESCR:
Number of live seedlings on timberland(seedlings)

VBA_SUMFROMWHERE:
SUM(SEEDLING.TPA_UNADJ* PPP.adj_factor_micr) 
   AS ESTIMATED_VALUE 
 FROM 
 SEEDLING INNER JOIN ( 
 COND INNER JOIN (( 
 POP_PLOT_STRATUM_ASSGN 
 INNER JOIN 
 POP_STRATUM as PPP ON POP_PLOT_STRATUM_ASSGN.STRATUM_CN = PPP.CN) 
 INNER JOIN 
 PLOT ON POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN) ON COND.PLT_CN = PLOT.CN) ON SEEDLING.PLT_CN = PLOT.CN 
 WHERE ((COND.COND_STATUS_CD)=1) and SEEDLING.CONDID=COND.CONDID AND 
 (COND.COND_STATUS_CD=1 AND COND.RESERVCD=0 AND (COND.SITECLCD=1 Or COND.SITECLCD=2 Or COND.SITECLCD=3 Or COND.SITECLCD=4 Or COND.SITECLCD=5 Or COND.SITECLCD=6)) AND 
 SEEDLING.TPA_UNADJ is not null and


# REF_PRC

FUNCTIONNM:
(select stctyLabel from ref_stcty where stcty=plot.statecd*1000+plot.countycd)


FUNCTIONNM:
(select rscdEvalidLabel from ref_rscdEvalid where rscdEvalid=POP_PLOT_STRATUM_ASSGN.rscd*1000000+POP_PLOT_STRATUM_ASSGN.evalid)


# ref_stcty

STCTYLABEL:
0086 Prince of Wales-Outer Ketchikan Census Area


# TempEstnUnitDescrLU

rscdEvalidEsntUnitLabel:
0048 24090800000002 Inland Census Water Cnty. Grp. 3


rscdEvalidEsntUnitLabel:
0049 24090800000003 Inland Census Water Cnty. Grp. 5


rscdEvalidEsntUnitLabel:
0064 24090801000002 Inland Census Water Cnty. Grp. 3


rscdEvalidEsntUnitLabel:
0065 24090801000003 Inland Census Water Cnty. Grp. 5


rscdEvalidEsntUnitLabel:
0079 24090803000001 Inland Census Water Public Cnty. Grp. 3, 5, 15...


