*****************************************
100 Mile House Type 2 Resultants
*****************************************

- resultants are found in 2 Access Geodatabases
1) phase6.mdb
2) phase8.res.mdb
- spatial resultants were built from coverages then imported into Geodatabases

- one coverage is the merged 100 Mile House vri tiles
1) vri_el.e00

--------------------
phase6.mdb
--------------------
- there is 1 spatial dataset called phase6 and 1 table called phase6_impact
a) phase6
- this spatial dataset has the merchantablility analysis information
b) phase6_impact
- this table has the beetle and road impact information

--------------------
phase8_res.mdb
--------------------
- there is 1 spatial dataset called phase8_rese and 1 table called ident14
a) phase8_rese
- this spatial dataset indentifies the THLB as well as all modeling fields
- use this data to link back to VRI data
b) ident14
- relates spatial processing of various coverage to phase8_rese

Below is an SQL query that can be used to relate the all datasets and tables:

SELECT phase6.NETDOWN, ident14.WATERSHED_GROUP_, phase6_impact.roadpc_cur, phase6_impact.roadpc_fut, phase6_impact.PL_m3, phase6_impact.lumber_0, phase6_impact.chips_0, phase6_impact.osb_0, phase6_impact.pellets_0, phase6_impact.bioenergy_0, Sum(phase8_rese.Shape_Area) AS SumOfShape_Area
FROM (phase8_rese LEFT JOIN (phase6_impact LEFT JOIN phase6 ON (phase6_impact.phase6_OID = phase6.OBJECTID) AND (phase6_impact.WATERSHED_ID = phase6.WATERSHED_ID) AND (phase6_impact.VRI_EL_ = phase6.VRI_EL_)) ON phase8_rese.FID_PHASE6 = phase6_impact.phase6_OID) LEFT JOIN ident14 ON phase8_rese.FID_IDENT14 = ident14.OBJECTID_1
GROUP BY phase6.NETDOWN, ident14.WATERSHED_GROUP_, phase6_impact.roadpc_cur, phase6_impact.roadpc_fut, phase6_impact.PL_m3, phase6_impact.lumber_0, phase6_impact.chips_0, phase6_impact.osb_0, phase6_impact.pellets_0, phase6_impact.bioenergy_0;