FPS V699 vs V701 Database Structure

From Free State Drivers
Revision as of 15:07, 15 January 2015 by Cvopicka (talk | contribs) (Created page with "This is an attempt to show he relationship between version 6.99 and version 7.01 FPS databases. This have not yet been verified. There are some relationships that are not li...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This is an attempt to show he relationship between version 6.99 and version 7.01 FPS databases. This have not yet been verified. There are some relationships that are not listed here because they are not just a 1:1 relationship.

Use this guide at your own risk!

Comparison Structure

FPS 6.99           -> FPS 7.01

Admin

ADMIN.STD_ID       -> ADMIN.STD_ID
ADMIN.VEG_LBL      -> ADMIN.VEG_LBL
ADMIN.RPT_YR       -> ADMIN.RPT_YR
ADMIN.MSMT_YR      -> ADMIN.MSMT_YR
ADMIN.GIS_ID       -> ADMIN.GIS_ID
ADMIN.GIS_LBL      -> ADMIN.GIS_LBL
ADMIN.FLAG         -> ADMIN.FLAG
ADMIN.OWNER        -> ADMIN.OWNER
ADMIN.STATE        -> ADMIN.STATE
ADMIN.COUNTY       -> ADMIN.COUNTY
ADMIN.TOWNSHIP     -> ADMIN.TOWNSHIP
ADMIN.RANGE        -> ADMIN.RANGE
ADMIN.SECTION      -> ADMIN.SECTION
ADMIN.TRACT        -> ADMIN.TRACT
ADMIN.REGION       -> ADMIN.REGION
ADMIN.AREA_RPT     -> ADMIN.AREA_RPT
ADMIN.AREA_GIS     -> ADMIN.AREA_GIS
ADMIN.AREA_NET     -> ADMIN.AREA_NET
ADMIN.AREA_LGL     -> ADMIN.AREA_BUF
ADMIN.HAB_CLS      -> ADMIN.HAB_CLS
ADMIN.HAB_GRP      -> ADMIN.HAB_GRP
ADMIN.REGIME       -> ADMIN.REGIME
ADMIN.PLAN_YR      -> ADMIN.PLAN_YR
ADMIN.SITE_PHY     -> ADMIN.SITE_PHY
ADMIN.SITE_SHP     -> ADMIN.SITE_SHP
ADMIN.SITE_IND     -> ADMIN.SITE_IND
ADMIN.SITE_SPP     -> ADMIN.SITE_SPP
ADMIN.ELEV         -> ADMIN.ELEV
ADMIN.ASPECT       -> ADMIN.ASPECT
ADMIN.SLOPE        -> ADMIN.SLOPE
ADMIN.SOLAR        -> 
                   -> ADMIN.GDAY
ADMIN.PRECIP       -> ADMIN.PRECIP
ADMIN.ROOT_DEP     -> ADMIN.Root_Dep
                   -> ADMIN.STOCK
ADMIN.LOG_SYS      -> ADMIN.LOG_SYS
ADMIN.HAUL_LEN     -> ADMIN.HAUL_LEN
ADMIN.Xgis         -> ADMIN.Xgis
ADMIN.Ygis         -> ADMIN.Ygis
ADMIN.Org_Lbl      -> ADMIN.Org_Lbl
ADMIN.Grp_Lbl      -> ADMIN.Grp_Lbl
ADMIN.Hab_Lbl      -> ADMIN.Hab_Lbl
ADMIN.OldSite      -> ADMIN.OldSite
ADMIN.OldFlag      -> ADMIN.OldFlag
ADMIN.Basin        -> ADMIN.Basin
ADMIN.Access       -> ADMIN.Access
ADMIN.LandUse      -> ADMIN.LandUse
ADMIN.Birth        -> ADMIN.Birth
ADMIN.Forest       -> ADMIN.Basis
                   -> ADMIN.Origin
ADMIN.Strata       -> 

Basin

                   -> BASIN.Basin
                   -> BASIN.Index
                   -> BASIN.Rpt_Yr
                   -> BASIN.GrsArea
                   -> BASIN.Class
                   -> BASIN.Diversity
                   -> BASIN.Comment

CashFlow

CASHFLOW.Std_ID    -> CASHFLOW.Std_ID
CASHFLOW.Rpt_Yr    -> CASHFLOW.Rpt_Yr
CASHFLOW.Regime    -> CASHFLOW.Regime
CASHFLOW.Treat     -> CASHFLOW.Treat
CASHFLOW.Cost      -> CASHFLOW.Cost

Class

CLASS.Forest       -> CLASS.Basis
CLASS.Label        -> CLASS.Label
CLASS.Code         -> CLASS.Code
CLASS.Min          -> CLASS.Min
CLASS.Max          -> CLASS.Max
CLASS.Comment      -> CLASS.Comment

Cruise

CRUISE.STD_ID      -> CRUISE.STD_ID
CRUISE.M_DATE      -> CRUISE.M_DATE
CRUISE.MSMT_YR     -> CRUISE.MSMT_YR
CRUISE.CRUISER     -> CRUISE.CRUISER
CRUISE.BAF         -> CRUISE.BAF
CRUISE.BAF_DBH     -> CRUISE.BAF_DBH
CRUISE.PLOT_AREA   -> CRUISE.PLOT_AREA
CRUISE.VEG_AREA    -> CRUISE.VEG_AREA
CRUISE.TRANSECT    -> CRUISE.TRANSECT
CRUISE.PLOTS       -> CRUISE.PLOTS
CRUISE.TPH_ERR     -> CRUISE.TPH_ERR
CRUISE.BA_ERR      -> CRUISE.BA_ERR
                   -> CRUISE.CCF_ERR
CRUISE.CUB_ERR     -> CRUISE.CUB_ERR
CRUISE.BRD_ERR     -> CRUISE.BRD_ERR

DBHCls

DBHCLS.STD_ID      -> DBHCLS.STD_ID
DBHCLS.VEG_LBL     -> 
DBHCLS.RPT_YR      -> DBHCLS.RPT_YR
DBHCLS.SPECIES     -> DBHCLS.SPECIES
DBHCLS.GROUP       -> DBHCLS.GRP
DBHCLS.DbhKey      -> DBHCLS.PlotTree
DBHCLS.AGE         -> DBHCLS.Age
DBHCLS.TREES       -> DBHCLS.TREES
DBHCLS.DBH         -> DBHCLS.DBH
DBHCLS.BASAL       -> DBHCLS.BASAL
DBHCLS.HEIGHT      -> DBHCLS.HEIGHT
DBHCLS.BOLEHT      -> DBHCLS.BOLEHT
DBHCLS.TAPER       -> DBHCLS.TAPER
DBHCLS.CROWN       -> DBHCLS.CROWN
DBHCLS.CUBIC_DT    -> 
DBHCLS.CUB1_DM     -> 
DBHCLS.CUB1_DN     -> 
DBHCLS.BRD1_DM     -> 
DBHCLS.BRD1_DN     -> 
DBHCLS.CUB2_DM     -> 
DBHCLS.CUB2_DN     -> 
DBHCLS.BRD2_DM     -> 
DBHCLS.BRD2_DN     -> 
DBHCLS.CUB3_DM     -> 
DBHCLS.CUB3_DN     -> 
DBHCLS.BRD3_DM     -> 
DBHCLS.BRD3_DN     -> 
                   -> DBHCLS.Vigor
                   -> DBHCLS.CubicTot
                   -> DBHCLS.CubicGrs
                   -> DBHCLS.CubicNet
                   -> DBHCLS.BoardGrs
                   -> DBHCLS.BoardNet
                   -> DBHCLS.ValueGrs
DBHCLS.DEFECT_B    -> DBHCLS.DEFECT_B
DBHCLS.DEFECT_M    -> DBHCLS.DEFECT_M
DBHCLS.DEFECT_T    -> DBHCLS.DEFECT_T
DBHCLS.DBHCLS      -> DBHCLS.DBHCLS
DBHCLS.Cords       -> DBHCLS.Cords
DBHCLS.StemDry     -> DBHCLS.StemDry
DBHCLS.StemWet     -> DBHCLS.StemWet
DBHCLS.BoleDry     -> DBHCLS.BoleDry
DBHCLS.BoleWet     -> DBHCLS.BoleWet
DBHCLS.BarkDry     -> DBHCLS.BarkDry
DBHCLS.BarkWet     -> 
DBHCLS.CrwnDry     -> DBHCLS.CrwnDry
DBHCLS.CrwnWet     -> 
                   -> DBHCLS.RootDry
DBHCLS.CarbonTree  -> DBHCLS.CarbTree
DBHCLS.CarbonBole  -> DBHCLS.CarbBole
                   -> DBHCLS.CO2Tree
                   -> DBHCLS.CO2Bole

DIBCls

DIBCLS.Std_ID      -> DIBCLS.Std_ID
DIBCLS.Rpt_Yr      -> DIBCLS.Rpt_Yr
DIBCLS.Species     -> DIBCLS.Species
DIBCLS.Group       -> DIBCLS.Grp
DIBCLS.PlotTree    -> DIBCLS.PlotTree
DIBCLS.DibKey      -> DIBCLS.DibKey
DIBCLS.Grade       -> DIBCLS.Grade
DIBCLS.Logs        -> DIBCLS.Logs
DIBCLS.TDib        -> DIBCLS.TDib
DIBCLS.BDib        -> DIBCLS.BDib
DIBCLS.Length      -> DIBCLS.Length
DIBCLS.DibCls      -> DIBCLS.DibCls
DIBCLS.LenCls      -> DIBCLS.LenCls
DIBCLS.GrsCub      -> DIBCLS.CubicGrs
DIBCLS.NetCub      -> DIBCLS.CubicNet
DIBCLS.GrsBrd      -> DIBCLS.BoardGrs
DIBCLS.NetBrd      -> DIBCLS.BoardNet
DIBCLS.Value       -> DIBCLS.ValueGrs
DIBCLS.WgtDry      -> DIBCLS.BoleDry
DIBCLS.WgtGrn      -> DIBCLS.BoleWet
                   -> DIBCLS.BarkDry
                   -> DIBCLS.CarbBole
                   -> DIBCLS.CO2Bole
DIBCLS.LogsGrn     -> 
DIBCLS.LogsDry     -> 
DIBCLS.Cubic_LM    -> 
DIBCLS.Cubic_LN    -> 
DIBCLS.Board_LM    -> 
DIBCLS.Board_LN    -> 
DIBCLS.Pct_Brd     -> 
DIBCLS.Value_LM    -> 
DIBCLS.TWgtGrn     -> 
DIBCLS.TWgtDry     -> 
DIBCLS.TGrsCub     -> 
DIBCLS.TNetCub     -> 
DIBCLS.TGrsBrd     -> 
DIBCLS.TNetBrd     -> 
DIBCLS.TValue      -> 

DWood

DWOOD.Std_ID       -> DWOOD.Std_ID
DWOOD.Rpt_Yr       -> DWOOD.Rpt_Yr
                   -> DWOOD.Regime
DWOOD.Species      -> DWOOD.Species
DWOOD.DobKey       -> DWOOD.DobKey
DWOOD.Logs         -> DWOOD.Logs
DWOOD.Dob          -> DWOOD.Dob
DWOOD.Length       -> DWOOD.Length
DWOOD.Decay        -> DWOOD.Decay
DWOOD.Cubic        -> DWOOD.CubicNet
DWOOD.Board        -> DWOOD.BoardNet
DWOOD.Weight       -> DWOOD.StemDry
DWOOD.Defect       -> DWOOD.Defect
                   -> DWOOD.CarbTree
                   -> DWOOD.CO2Tree

GISLink

GISLINK.Tag_ID     -> GISLINK.Tag_ID
GISLINK.Old_ID     -> GISLINK.Old_ID
GISLINK.New_ID     -> GISLINK.New_ID
GISLINK.Area       -> GISLINK.Area
GISLINK.Old_lbl    -> GISLINK.Old_lbl
GISLINK.New_lbl    -> GISLINK.New_lbl

HabDens

HABDENS.Std_ID     -> HABDENS.Std_ID
HABDENS.Rpt_Yr     -> HABDENS.Rpt_Yr
HABDENS.Regime     -> HABDENS.Regime
HABDENS.Code       -> HABDENS.Code
HABDENS.Age        -> HABDENS.Age
HABDENS.Stems      -> HABDENS.Stems
HABDENS.Qdbh       -> HABDENS.Qdbh
HABDENS.Basal      -> HABDENS.Basal
HABDENS.CCF        -> HABDENS.CCF
HABDENS.RelD       -> HABDENS.RelD

Habitat

HABITAT.Std_ID     -> HABITAT.Std_ID
HABITAT.Rpt_Yr     -> HABITAT.Rpt_Yr
HABITAT.Veg_Lbl    -> HABITAT.Hab_Lbl
HABITAT.Hab_Cls    -> HABITAT.Hab_Cls
HABITAT.HCV        -> HABITAT.Htt_Div
HABITAT.DCV        -> HABITAT.Dbh_Div
HABITAT.Sun        -> 
HABITAT.Tbr_Lbl    -> HABITAT.Tbr_Lbl
HABITAT.Size       -> HABITAT.SizeCls
HABITAT.Density    -> HABITAT.DensCls
HABITAT.Patch      -> 
HABITAT.AgeCls     -> HABITAT.AgeCls
HABITAT.SiteCls    -> HABITAT.SiteCls
HABITAT.Wet        -> HABITAT.RainCls
                   -> HABITAT.SoilCls
                   -> HABITAT.ElevCls
                   -> HABITAT.AspCls
                   -> HABITAT.DayCls

HabRule

HABRULE.Forest     -> HABRULE.Basis
HABRULE.Code       -> HABRULE.Code
HABRULE.Circle     -> HABRULE.Circle
HABRULE.Radius     -> HABRULE.Radius
HABRULE.MinPct     -> HABRULE.MinPct
HABRULE.MinArea    -> HABRULE.MinArea
HABRULE.MinDbh     -> HABRULE.MinDbh
HABRULE.MinDen     -> HABRULE.MinDen

HabSpp

HABSPP.Region      -> HABSPP.Region
HABSPP.Hab_Cls     -> HABSPP.Hab_Cls
                   -> HABSPP.Form
HABSPP.Spp01       -> HABSPP.Spp01
HABSPP.Spp02       -> HABSPP.Spp02
HABSPP.Spp03       -> HABSPP.Spp03
HABSPP.Spp04       -> HABSPP.Spp04
HABSPP.Spp05       -> HABSPP.Spp05

Harvest

HARVEST.Forest     -> HARVEST.Basis
HARVEST.COST_COD   -> 
HARVEST.COEF_1     -> 
HARVEST.COEF_2     -> 
HARVEST.COEF_3     -> 
                   -> HARVEST.COST
                   -> HARVEST.CODE
                   -> HARVEST.COEF

History

HISTORY.Std_ID     -> HISTORY.Std_ID
HISTORY.Day        -> HISTORY.Day
HISTORY.Hour       -> HISTORY.Hour
HISTORY.Action     -> HISTORY.Action
HISTORY.BaseYr     -> HISTORY.BaseYr
HISTORY.Old_ID     -> HISTORY.Old_ID
HISTORY.Area       -> HISTORY.Area
HISTORY.Silvics    -> HISTORY.Silvics
HISTORY.Notes      -> HISTORY.Notes

NestArea

NESTAREA.Forest    -> 
NESTAREA.Circle    -> NESTAREA.Circle
NESTAREA.Nest_ID   -> NESTAREA.Nest_ID
NESTAREA.Std_ID    -> NESTAREA.Std_ID

NestSite

NESTSITE.Forest    -> 
NESTSITE.Code      -> NESTSITE.Code
NESTSITE.NEST_ID   -> NESTSITE.NEST_ID
NESTSITE.Xgis      -> NESTSITE.Xgis
NESTSITE.Ygis      -> NESTSITE.Ygis
NESTSITE.PCT1      -> NESTSITE.PCT1
NESTSITE.PCT2      -> NESTSITE.PCT2
NESTSITE.PCT3      -> NESTSITE.PCT3

PlanCut

STANDCUT.STD_ID    -> PLANCUT.STD_ID
STANDCUT.VEG_LBL   -> 
STANDCUT.RPT_YR    -> PLANCUT.RPT_YR
STANDCUT.REGIME    -> PLANCUT.REGIME
                   -> PLANCUT.Status
STANDCUT.TBR_LBL   -> PLANCUT.TBR_LBL
STANDCUT.FLAG_YR   -> PLANCUT.Flag_Yr
STANDCUT.TOT_AGE   -> PLANCUT.Tot_Age
STANDCUT.STEMS     -> PLANCUT.Trees
STANDCUT.QDBH      -> PLANCUT.QDBH
STANDCUT.BASAL     -> PLANCUT.BASAL
STANDCUT.TOP_HT    -> PLANCUT.TOP_HT
STANDCUT.CCF       -> PLANCUT.CCF
STANDCUT.RELD      -> PLANCUT.RELD
STANDCUT.CLUMP     -> PLANCUT.Clump
                   -> PLANCUT.Origin
STANDCUT.CUBIC_ST  -> PLANCUT.CubicTot
STANDCUT.CUBIC_SM  -> PLANCUT.CubicGrs
STANDCUT.CUBIC_SN  -> PLANCUT.CubicNet
STANDCUT.BOARD_SM  -> PLANCUT.BoardGrs
STANDCUT.BOARD_SN  -> PLANCUT.BoardNet
STANDCUT.VALUE_SM  -> PLANCUT.ValueGrs
STANDCUT.COST_SM   -> PLANCUT.CostGrs
STANDCUT.NPV_AM    -> PLANCUT.ValueNPV
                   -> PLANCUT.ValueSEV
                   -> PLANCUT.ValueIRR
STANDCUT.APCS      -> PLANCUT.APCS
STANDCUT.ADIB      -> PLANCUT.ADIB
STANDCUT.MStems    -> PLANCUT.MStems
STANDCUT.MDbh      -> PLANCUT.MDbh
STANDCUT.MBasal    -> PLANCUT.MBasal
STANDCUT.MAge      -> PLANCUT.MAge
STANDCUT.MCCF      -> PLANCUT.MCCF
STANDCUT.MRelD     -> PLANCUT.MRelD
STANDCUT.Cords_SM  -> PLANCUT.Cords
                   -> PLANCUT.StemDry
STANDCUT.Green_ST  -> PLANCUT.StemWet
                   -> PLANCUT.BoleDry
STANDCUT.Green_SM  -> PLANCUT.BoleWet
STANDCUT.Bark_ST   -> PLANCUT.BarkDry
STANDCUT.Crwn_ST   -> PLANCUT.CrwnDry
                   -> PLANCUT.RootDry
                   -> PLANCUT.VegDry
STANDCUT.Carbon_ST -> PLANCUT.CarbTree
STANDCUT.Carbon_SM -> PLANCUT.CarbBole
                   -> PLANCUT.CO2Tree
                   -> PLANCUT.CO2Bole
STANDCUT.AREA_RPT  -> PLANCUT.AreaRpt
STANDCUT.CUBIC_AT  -> 
STANDCUT.Green_AT  -> 
STANDCUT.Bark_AT   -> 
STANDCUT.Crwn_AT   -> 
STANDCUT.Carbon_AT -> 
STANDCUT.Green_AM  -> 
STANDCUT.Cords_AM  -> 
STANDCUT.Carbon_AM -> 
STANDCUT.CUB1_AM   -> 
STANDCUT.CUB1_AN   -> 
STANDCUT.BRD1_AM   -> 
STANDCUT.BRD1_AN   -> 
STANDCUT.CUB2_AM   -> 
STANDCUT.CUB2_AN   -> 
STANDCUT.BRD2_AM   -> 
STANDCUT.BRD2_AN   -> 
STANDCUT.CUB3_AM   -> 
STANDCUT.CUB3_AN   -> 
STANDCUT.BRD3_AM   -> 
STANDCUT.BRD3_AN   -> 
STANDCUT.VALUE_AM  -> 
STANDCUT.COST_AM   -> 

PlanRes

STANDRES.STD_ID    -> PLANRES.STD_ID
STANDRES.VEG_LBL   -> 
STANDRES.RPT_YR    -> PLANRES.RPT_YR
STANDRES.REGIME    -> PLANRES.REGIME
                   -> PLANRES.Status
STANDRES.TBR_LBL   -> PLANRES.TBR_LBL
STANDRES.FLAG_YR   -> PLANRES.Flag_Yr
STANDRES.TOT_AGE   -> PLANRES.Tot_Age
STANDRES.STEMS     -> PLANRES.Trees
STANDRES.QDBH      -> PLANRES.QDBH
STANDRES.BASAL     -> PLANRES.BASAL
STANDRES.TOP_HT    -> PLANRES.TOP_HT
STANDRES.CCF       -> PLANRES.CCF
STANDRES.RELD      -> PLANRES.RELD
STANDRES.CLUMP     -> PLANRES.Clump
                   -> PLANRES.Origin
STANDRES.CUBIC_ST  -> PLANRES.CubicTot
STANDRES.CUBIC_SM  -> PLANRES.CubicGrs
STANDRES.CUBIC_SN  -> PLANRES.CubicNet
STANDRES.BOARD_SM  -> PLANRES.BoardGrs
STANDRES.BOARD_SN  -> PLANRES.BoardNet
STANDRES.VALUE_SM  -> PLANRES.ValueGrs
STANDRES.COST_SM   -> PLANRES.CostGrs
STANDRES.NPV_AM    -> PLANRES.ValueNPV
                   -> PLANRES.ValueSEV
                   -> PLANRES.ValueIRR
STANDRES.APCS      -> PLANRES.APCS
STANDRES.ADIB      -> PLANRES.ADIB
STANDRES.MStems    -> PLANRES.MStems
STANDRES.MDbh      -> PLANRES.MDbh
STANDRES.MBasal    -> PLANRES.MBasal
STANDRES.MAge      -> PLANRES.MAge
STANDRES.MCCF      -> PLANRES.MCCF
STANDRES.MRelD     -> PLANRES.MRelD
STANDRES.Cords_SM  -> PLANRES.Cords
                   -> PLANRES.StemDry
STANDRES.Green_ST  -> PLANRES.StemWet
                   -> PLANRES.BoleDry
STANDRES.Green_SM  -> PLANRES.BoleWet
STANDRES.Bark_AT   -> PLANRES.BarkDry
STANDRES.Crwn_AT   -> PLANRES.CrwnDry
                   -> PLANRES.RootDry
                   -> PLANRES.VegDry
STANDRES.Carbon_ST -> PLANRES.CarbTree
STANDRES.Carbon_SM -> PLANRES.CarbBole
                   -> PLANRES.CO2Tree
                   -> PLANRES.CO2Bole
STANDRES.AREA_RPT  -> PLANRES.AreaRpt
STANDRES.Bark_ST   -> 
STANDRES.Crwn_ST   -> 
STANDRES.CUBIC_AT  -> 
STANDRES.Green_AT  -> 
STANDRES.Carbon_AT -> 
STANDRES.Green_AM  -> 
STANDRES.Cords_AM  -> 
STANDRES.Carbon_AM -> 
STANDRES.CUB1_AM   -> 
STANDRES.CUB1_AN   -> 
STANDRES.BRD1_AM   -> 
STANDRES.BRD1_AN   -> 
STANDRES.CUB2_AM   -> 
STANDRES.CUB2_AN   -> 
STANDRES.BRD2_AM   -> 
STANDRES.BRD2_AN   -> 
STANDRES.CUB3_AM   -> 
STANDRES.CUB3_AN   -> 
STANDRES.BRD3_AM   -> 
STANDRES.BRD3_AN   -> 
STANDRES.VALUE_AM  -> 
STANDRES.COST_AM   -> 

PlanSrt

                   -> PLANSRT.Std_ID
                   -> PLANSRT.Rpt_Yr
                   -> PLANSRT.Regime
                   -> PLANSRT.Flag
                   -> PLANSRT.Species
                   -> PLANSRT.Grp
                   -> PLANSRT.Sort
                   -> PLANSRT.CubicGrs
                   -> PLANSRT.CubicNet
                   -> PLANSRT.BoardGrs
                   -> PLANSRT.BoardNet
                   -> PLANSRT.ValueGrs
                   -> PLANSRT.BoleDry
                   -> PLANSRT.BoleWet
                   -> PLANSRT.BarkDry
                   -> PLANSRT.CarbBole
                   -> PLANSRT.CO2Bole
                   -> PLANSRT.AreaRpt

Plogs

PLOGS.Std_ID       -> PLOGS.Std_ID
PLOGS.Msmt         -> PLOGS.Msmt
PLOGS.Plot         -> PLOGS.Plot
PLOGS.Tree         -> PLOGS.Tree
PLOGS.Piece        -> PLOGS.Piece
PLOGS.Length       -> PLOGS.Length
PLOGS.Grade        -> PLOGS.Grade
PLOGS.Deduct       -> PLOGS.Deduct
PLOGS.Code         -> PLOGS.Code

Plots

PLOTS.STD_ID       -> PLOTS.STD_ID
PLOTS.PLOT         -> PLOTS.PLOT
PLOTS.TREE         -> PLOTS.TREE
PLOTS.SPECIES      -> PLOTS.SPECIES
PLOTS.GROUP        -> PLOTS.GRP
PLOTS.X_ARC        -> PLOTS.X_ARC
PLOTS.Y_DIST       -> PLOTS.Y_DIST
PLOTS.MSMT         -> PLOTS.MSMT
PLOTS.DBH          -> PLOTS.DBH
PLOTS.TREES        -> PLOTS.TREES
PLOTS.HEIGHT       -> PLOTS.HEIGHT
PLOTS.HT_CODE      -> PLOTS.HT_CODE
PLOTS.TAP_DIA      -> PLOTS.TAP_DIA
PLOTS.TAP_HT       -> PLOTS.TAP_HT
PLOTS.TAP_CODE     -> PLOTS.TAP_CODE
PLOTS.AGE          -> PLOTS.AGE
PLOTS.AGE_CODE     -> PLOTS.AGE_CODE
PLOTS.CROWN        -> PLOTS.CROWN
PLOTS.CRN_CODE     -> PLOTS.CRN_CODE
PLOTS.CRN_CLS      -> PLOTS.CRN_CLS
                   -> PLOTS.VIGOR
PLOTS.STATUS       -> PLOTS.STATUS
PLOTS.DAMAGE       -> PLOTS.DAMAGE
PLOTS.DEFECT1      -> PLOTS.DEFECT_B
PLOTS.DEFECT2      -> PLOTS.DEFECT_M
PLOTS.DEFECT3      -> PLOTS.DEFECT_T
                   -> PLOTS.DEF_CODE
PLOTS.CSI          -> PLOTS.CSI

Schedule

SCHEDULE.Forest    -> SCHEDULE.Basis
SCHEDULE.PLAN_YR   -> SCHEDULE.PLAN_YR
SCHEDULE.BRD_MIN   -> SCHEDULE.BRD_MIN
SCHEDULE.CUB_MIN   -> SCHEDULE.CUB_MIN
SCHEDULE.VAL_MIN   -> SCHEDULE.VAL_MIN
SCHEDULE.AREA_MIN  -> SCHEDULE.AREA_MIN
SCHEDULE.AREA_MAX  -> SCHEDULE.AREA_MAX
SCHEDULE.AGE_MIN   -> SCHEDULE.AGE_MIN
SCHEDULE.AGE_MAX   -> SCHEDULE.AGE_MAX
SCHEDULE.BA_MIN    -> 
SCHEDULE.BRD_GOAL  -> SCHEDULE.BRD_GOAL
SCHEDULE.CUB_GOAL  -> SCHEDULE.CUB_GOAL
SCHEDULE.VAL_GOAL  -> SCHEDULE.VAL_GOAL

Silvics

SILVICS.Forest     -> SILVICS.Basis
SILVICS.REGIME     -> SILVICS.REGIME
SILVICS.GROUP      -> SILVICS.GRP
SILVICS.TRT_NBR    -> SILVICS.TRT_NBR
SILVICS.SITEPREP   -> 
                   -> SILVICS.Regen
                   -> SILVICS.PctHt
                   -> SILVICS.PctSur
SILVICS.TRT_Key    -> SILVICS.TRT_Key
SILVICS.TRT_Val    -> SILVICS.TRT_Val
SILVICS.THIN_METH  -> SILVICS.THIN_METH
SILVICS.THIN_MV    -> SILVICS.THIN_MV
SILVICS.THIN_LVL   -> SILVICS.THIN_LVL
SILVICS.THIN_LVLV  -> SILVICS.THIN_LVLV
SILVICS.THIN_SP    -> SILVICS.THIN_SP
SILVICS.FERT_RATE  -> SILVICS.FERT_RATE
SILVICS.TRT_COST   -> SILVICS.COST
SILVICS.THIN_MIN   -> SILVICS.THIN_MIN
SILVICS.FILL_PLT   -> SILVICS.FILL_PLT

Snags

SNAGS.STD_ID       -> SNAGS.STD_ID
SNAGS.RPT_YR       -> SNAGS.RPT_YR
                   -> SNAGS.Regime
SNAGS.SPECIES      -> SNAGS.SPECIES
SNAGS.DbhKey       -> SNAGS.DbhKey
SNAGS.TREES        -> SNAGS.TREES
SNAGS.DBH          -> SNAGS.DBH
SNAGS.HEIGHT       -> SNAGS.HEIGHT
SNAGS.DECAY        -> SNAGS.DECAY
SNAGS.CUBIC        -> SNAGS.CubicNet
SNAGS.BOARD        -> SNAGS.BoardNet
SNAGS.WEIGHT       -> SNAGS.StemDry
SNAGS.DEFECT       -> SNAGS.DEFECT
                   -> SNAGS.CarbTree
                   -> SNAGS.CO2Tree

Sorts

SORTS.Forest       -> SORTS.Basis
SORTS.Species      -> SORTS.Species
SORTS.Sort         -> 
SORTS.Grade        -> 
                   -> SORTS.Grade
SORTS.Label        -> SORTS.Label
SORTS.Rank         -> SORTS.Rpt_Grp
SORTS.Value        -> SORTS.Value
SORTS.Flag         -> SORTS.Flag
SORTS.MinDib       -> SORTS.MinDib
SORTS.MinDbh       -> SORTS.MinDbh
SORTS.MinLen       -> SORTS.MinLen
SORTS.MaxDef       -> SORTS.MaxDef
SORTS.MaxSeg       -> SORTS.MaxSeg
SORTS.MinVol       -> SORTS.MinVol

Species

SPECIES.Forest     -> SPECIES.Basis
SPECIES.SPECIES    -> SPECIES.SPECIES
SPECIES.SPNAME     -> SPECIES.SPNAME
                   -> SPECIES.USFS
SPECIES.RPT_GRP    -> SPECIES.RPT_GRP
SPECIES.STUMP      -> SPECIES.STUMP
SPECIES.LOG_SIZE   -> SPECIES.LOG_SIZE
SPECIES.LOG_MIN    -> SPECIES.LOG_MIN
SPECIES.LOG_DIB    -> SPECIES.LOG_DIB
SPECIES.LOG_DBH    -> SPECIES.LOG_DBH
SPECIES.DEFECT     -> SPECIES.DEFECT
SPECIES.RULE       -> SPECIES.RULE
                   -> SPECIES.TRK_DIB
                   -> SPECIES.CORDS
SPECIES.SRT1_DIB   -> 
SPECIES.SRT1_LEN   -> 
SPECIES.SRT1_VAL   -> 
SPECIES.SRT1_BAS   -> 
SPECIES.SRT2_DIB   -> 
SPECIES.SRT2_LEN   -> 
SPECIES.SRT2_VAL   -> 
SPECIES.SRT2_BAS   -> 
SPECIES.SRT3_DIB   -> 
SPECIES.SRT3_LEN   -> 
SPECIES.SRT3_VAL   -> 
SPECIES.SRT3_BAS   -> 
SPECIES.GREEN      -> 
SPECIES.CORDS      -> 

Stand

STAND.STD_ID       -> STAND.STD_ID
STAND.VEG_LBL      -> 
STAND.RPT_YR       -> STAND.RPT_YR
STAND.REGIME       -> STAND.REGIME
                   -> STAND.Status
STAND.TBR_LBL      -> STAND.TBR_LBL
STAND.FLAG_YR      -> STAND.Flag_Yr
STAND.TOT_AGE      -> STAND.Tot_Age
STAND.STEMS        -> STAND.Trees
STAND.QDBH         -> STAND.QDBH
STAND.BASAL        -> STAND.BASAL
STAND.TOP_HT       -> STAND.TOP_HT
STAND.CCF          -> STAND.CCF
STAND.RELD         -> STAND.RELD
STAND.CLUMP        -> STAND.Clump
STAND.Cubic_ST     -> STAND.CubicTot
STAND.CUBIC_SM     -> STAND.CubicGrs
STAND.CUBIC_SN     -> STAND.CubicNet
STAND.BOARD_SM     -> STAND.BoardGrs
STAND.BOARD_SN     -> STAND.BoardNet
STAND.VALUE_AM     -> STAND.ValueGrs
STAND.COST_AM      -> STAND.CostGrs
STAND.NPV_AM       -> STAND.ValueNPV
STAND.SEV_AM       -> STAND.ValueSEV
STAND.IRR_AM       -> STAND.ValueIRR
STAND.APCS         -> STAND.APCS
STAND.ADIB         -> STAND.ADIB
STAND.MStems       -> STAND.MStems
STAND.MDbh         -> STAND.MDbh
STAND.MBasal       -> STAND.MBasal
STAND.MAge         -> STAND.MAge
STAND.MCCF         -> STAND.MCCF
STAND.MRelD        -> STAND.MRelD
STAND.Cords_AM     -> STAND.Cords
                   -> STAND.StemDry
STAND.Green_ST     -> STAND.StemWet
                   -> STAND.BoleDry
                   -> STAND.BoleWet
STAND.Bark_ST      -> STAND.BarkDry
STAND.Crwn_ST      -> STAND.CrwnDry
                   -> STAND.RootDry
                   -> STAND.VegDry
STAND.Carbon_ST    -> STAND.CarbTree
STAND.Carbon_AM    -> STAND.CarbBole
                   -> STAND.CO2Tree
                   -> STAND.CO2Bole
STAND.Green_SM     -> 
STAND.Cords_SM     -> 
STAND.Carbon_SM    -> 
STAND.VALUE_SM     -> 
STAND.COST_SM      -> 
STAND.AREA_RPT     -> 
STAND.CUBIC_AT     -> 
STAND.Green_AT     -> 
STAND.Bark_AT      -> 
STAND.Crwn_AT      -> 
STAND.Carbon_AT    -> 
STAND.Green_AM     -> 
STAND.CUB1_AM      -> 
STAND.CUB1_AN      -> 
STAND.BRD1_AM      -> 
STAND.BRD1_AN      -> 
STAND.CUB2_AM      -> 
STAND.CUB2_AN      -> 
STAND.BRD2_AM      -> 
STAND.BRD2_AN      -> 
STAND.CUB3_AM      -> 
STAND.CUB3_AN      -> 
STAND.BRD3_AM      -> 
STAND.BRD3_AN      -> 
STAND.AreaRpt      -> 

StandSrt

STANDSRT.Std_ID    -> STANDSRT.Std_ID
STANDSRT.Rpt_Yr    -> STANDSRT.Rpt_Yr
STANDSRT.Regime    -> STANDSRT.Regime
STANDSRT.Flag      -> STANDSRT.Flag
STANDSRT.Spp       -> STANDSRT.Species
STANDSRT.Grp       -> STANDSRT.Grp
STANDSRT.Srt       -> STANDSRT.Sort
                   -> STANDSRT.CubicGrs
                   -> STANDSRT.CubicNet
                   -> STANDSRT.BoardGrs
                   -> STANDSRT.BoardNet
                   -> STANDSRT.ValueGrs
                   -> STANDSRT.BoleDry
                   -> STANDSRT.BoleWet
                   -> STANDSRT.BarkDry
                   -> STANDSRT.CarbBole
                   -> STANDSRT.CO2Bole
STANDSRT.PctCub    -> 
STANDSRT.PctBrd    -> 
STANDSRT.PctWgt    -> 
STANDSRT.PctCar    -> 

Title

TITLES.Forest      -> TITLES.Basis
TITLES.T_CODE      -> TITLES.T_CODE
TITLES.T_LBL       -> TITLES.T_LBL
TITLES.TITLE       -> TITLES.TITLE

VegCls

VEGCLS.Std_ID      -> VEGCLS.Std_ID
VEGCLS.Rpt_Yr      -> VEGCLS.Rpt_Yr
                   -> VEGCLS.Regime
VEGCLS.Species     -> VEGCLS.Species
VEGCLS.Form        -> VEGCLS.Form
VEGCLS.Pct         -> VEGCLS.Pct
VEGCLS.Height      -> VEGCLS.Height
                   -> VEGCLS.VegDry
                   -> VEGCLS.CarbTree
                   -> VEGCLS.CO2Tree

Yield

YIELD.Forest       -> YIELD.Basis
YIELD.REGION       -> YIELD.REGION
YIELD.HAB_GRP      -> YIELD.HAB_GRP
YIELD.SITE_CLS     -> YIELD.SITE_CLS
YIELD.RPT_YR       -> YIELD.RPT_YR
YIELD.REGIME       -> YIELD.REGIME
                   -> YIELD.Status
YIELD.TBR_LBL      -> YIELD.TBR_LBL
YIELD.FLAG_YR      -> YIELD.Flag_Yr
YIELD.TOT_AGE      -> YIELD.Tot_Age
YIELD.STEMS        -> YIELD.Trees
YIELD.QDBH         -> YIELD.QDBH
YIELD.BASAL        -> YIELD.BASAL
YIELD.TOP_HT       -> YIELD.TOP_HT
YIELD.CCF          -> YIELD.CCF
YIELD.RELD         -> YIELD.RELD
YIELD.CLUMP        -> YIELD.Clump
                   -> YIELD.Stock
                   -> YIELD.Origin
YIELD.CUBIC_ST     -> YIELD.CubicTot
YIELD.CUBIC_SM     -> YIELD.CubicGrs
YIELD.CUBIC_SN     -> YIELD.CubicNet
YIELD.BOARD_SM     -> YIELD.BoardGrs
YIELD.BOARD_SN     -> YIELD.BoardNet
YIELD.VALUE_SM     -> YIELD.ValueGrs
YIELD.COST_SM      -> YIELD.CostGrs
YIELD.NPV_AM       -> YIELD.ValueNPV
YIELD.SEV_AM       -> YIELD.ValueSEV
YIELD.IRR_AM       -> YIELD.ValueIRR
YIELD.APCS         -> YIELD.Apcs
YIELD.ADIB         -> YIELD.ADib
YIELD.MStems       -> YIELD.MStems
YIELD.MDbh         -> YIELD.MDbh
YIELD.MBasal       -> YIELD.MBasal
YIELD.MAge         -> YIELD.MAge
YIELD.MCCF         -> YIELD.MCCF
YIELD.MRelD        -> YIELD.MRelD
YIELD.Cords_AM     -> YIELD.Cords
                   -> YIELD.StemDry
YIELD.Green_AM     -> YIELD.StemWet
YIELD.Bark_AT      -> YIELD.BarkDry
YIELD.Crwn_ST      -> YIELD.CrwnDry
                   -> YIELD.RootDry
                   -> YIELD.BoleDry
                   -> YIELD.BoleWet
                   -> YIELD.VegDry
YIELD.Carbon_ST    -> YIELD.CarbTree
YIELD.Carbon_SM    -> YIELD.CarbBole
                   -> YIELD.CO2Tree
                   -> YIELD.CO2Bole
YIELD.Green_ST     -> 
YIELD.Bark_ST      -> 
YIELD.Green_SM     -> 
YIELD.Cords_SM     -> 
YIELD.AREA_RPT     -> 
YIELD.CUBIC_AT     -> 
YIELD.Green_AT     -> 
YIELD.Crwn_AT      -> 
YIELD.Carbon_AT    -> 
YIELD.Carbon_AM    -> 
YIELD.CUB1_AM      -> 
YIELD.CUB1_AN      -> 
YIELD.BRD1_AM      -> 
YIELD.BRD1_AN      -> 
YIELD.CUB2_AM      -> 
YIELD.CUB2_AN      -> 
YIELD.BRD2_AM      -> 
YIELD.BRD2_AN      -> 
YIELD.CUB3_AM      -> 
YIELD.CUB3_AN      -> 
YIELD.BRD3_AM      -> 
YIELD.BRD3_AN      -> 
YIELD.VALUE_AM     -> 
YIELD.COST_AM      -> 

YlDens

YLDENS.Forest      -> 
YLDENS.Std_ID      -> 
                   -> YLDENS.Region
                   -> YLDENS.Hab_Grp
                   -> YLDENS.Site_Cls
YLDENS.Rpt_Yr      -> YLDENS.Rpt_Yr
YLDENS.Regime      -> YLDENS.Regime
YLDENS.Code        -> YLDENS.Code
YLDENS.Age         -> YLDENS.Age
YLDENS.Stems       -> YLDENS.Stems
YLDENS.Qdbh        -> YLDENS.Qdbh
YLDENS.Basal       -> YLDENS.Basal
YLDENS.CCF         -> YLDENS.CCF
YLDENS.RelD        -> YLDENS.RelD

YldSpp

YLDSPP.Forest      -> YLDSPP.Basis
YLDSPP.Region      -> YLDSPP.Region
YLDSPP.Hab_Grp     -> YLDSPP.Hab_Grp
YLDSPP.Site_Cls    -> YLDSPP.Site_Cls
YLDSPP.Species     -> YLDSPP.Species
YLDSPP.Dbh         -> YLDSPP.Dbh
YLDSPP.Height      -> YLDSPP.Height
YLDSPP.Stems       -> YLDSPP.Stems

YldSrt

                   -> YLDSRT.Basis
                   -> YLDSRT.Region
                   -> YLDSRT.Hab_Grp
                   -> YLDSRT.Site_Cls
                   -> YLDSRT.Rpt_Yr
                   -> YLDSRT.Regime
                   -> YLDSRT.Flag
                   -> YLDSRT.Species
                   -> YLDSRT.Grp
                   -> YLDSRT.Sort
                   -> YLDSRT.CubicGrs
                   -> YLDSRT.CubicNet
                   -> YLDSRT.BoardGrs
                   -> YLDSRT.BoardNet
                   -> YLDSRT.ValueGrs
                   -> YLDSRT.BoleDry
                   -> YLDSRT.BoleWet
                   -> YLDSRT.BarkDry
                   -> YLDSRT.CarbBole
                   -> YLDSRT.CO2Bole