SELECT create_if_not_exists($$ALTER TABLE "REF_HABTYP_DESCRIPTION" ADD CONSTRAINT "REF_HABTYP_DESCRIPTION.unique" UNIQUE ("*HABTYPCD", "*HABTYP_PUB_CD")$$);

row_num,*SUBPLOT-row_num,,

PLT_CN,*SUBPLOT-PLT_CN,,

PREV_SBP_CN,*SUBPLOT-PREV_SBP_CN,,

INVYR,*INVYR,,

STATECD,*STATECD,,

UNITCD,*UNITCD,,

COUNTYCD,*COUNTYCD,,

SUBP_STATUS_CD,*SUBPLOT-SUBP_STATUS_CD,,

POINT_NONSAMPLE_REASN_CD,*SUBPLOT-POINT_NONSAMPLE_REASN_CD,,

MICRCOND,*SUBPLOT-MICRCOND,,

SUBPCOND,*SUBPLOT-SUBPCOND,,

MACRCOND,*SUBPLOT-MACRCOND,,

CONDLIST,*SUBPLOT-CONDLIST,,

SLOPE,*SUBPLOT-SLOPE,,

ASPECT,*SUBPLOT-ASPECT,,

WATERDEP,*SUBPLOT-WATERDEP,,

P2A_GRM_FLG,*SUBPLOT-P2A_GRM_FLG,,

CREATED_BY,*SUBPLOT-CREATED_BY,,

CREATED_DATE,*SUBPLOT-CREATED_DATE,,

CREATED_IN_INSTANCE,*SUBPLOT-CREATED_IN_INSTANCE,,

MODIFIED_BY,*SUBPLOT-MODIFIED_BY,,

MODIFIED_DATE,*SUBPLOT-MODIFIED_DATE,,

MODIFIED_IN_INSTANCE,*SUBPLOT-MODIFIED_IN_INSTANCE,,

CYCLE,*SUBPLOT-CYCLE,,

SUBCYCLE,*SUBPLOT-SUBCYCLE,,

ROOT_DIS_SEV_CD_PNWRS,*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,,

NF_SUBP_STATUS_CD,*SUBPLOT-NF_SUBP_STATUS_CD,,

NF_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,,

P2VEG_SUBP_STATUS_CD,*SUBPLOT-P2VEG_SUBP_STATUS_CD,,

P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,,

INVASIVE_SUBP_STATUS_CD,*SUBPLOT-INVASIVE_SUBP_STATUS_CD,,

INVASIVE_NONSAMPLE_REASN_CD,*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,,

*SUBPLOT-row_num

*SUBPLOT-PLT_CN

*SUBPLOT-PREV_SBP_CN

*INVYR

*STATECD

*UNITCD

*COUNTYCD

*SUBPLOT-SUBP_STATUS_CD

*SUBPLOT-POINT_NONSAMPLE_REASN_CD

*SUBPLOT-MICRCOND

*SUBPLOT-SUBPCOND

*SUBPLOT-MACRCOND

*SUBPLOT-CONDLIST

*SUBPLOT-SLOPE

*SUBPLOT-ASPECT

*SUBPLOT-WATERDEP

*SUBPLOT-P2A_GRM_FLG

*SUBPLOT-CREATED_BY

*SUBPLOT-CREATED_DATE

*SUBPLOT-CREATED_IN_INSTANCE

*SUBPLOT-MODIFIED_BY

*SUBPLOT-MODIFIED_DATE

*SUBPLOT-MODIFIED_IN_INSTANCE

*SUBPLOT-CYCLE

*SUBPLOT-SUBCYCLE

*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS

*SUBPLOT-NF_SUBP_STATUS_CD

*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD

*SUBPLOT-P2VEG_SUBP_STATUS_CD

*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD

*SUBPLOT-INVASIVE_SUBP_STATUS_CD

*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD

row_num,*REF_RESEARCH_STATION-row_num,,

RSCD,*REF_RESEARCH_STATION-RSCD,,

RS,*REF_RESEARCH_STATION-RS,,

STATE_ABBR,*REF_RESEARCH_STATION-STATE_ABBR,,

CREATED_BY,*REF_RESEARCH_STATION-CREATED_BY,,

CREATED_DATE,*REF_RESEARCH_STATION-CREATED_DATE,,

CREATED_IN_INSTANCE,*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,,

MODIFIED_BY,*REF_RESEARCH_STATION-MODIFIED_BY,,

MODIFIED_DATE,*REF_RESEARCH_STATION-MODIFIED_DATE,,

MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,,

  ('*STATECD', 'integer')

, ('*UNITCD', 'integer')

, ('*COUNTYCD', 'integer')

, ('*INVYR', 'integer')

, ('*SPCD', 'integer')

-- ("*STATECD", "*UNITCD", "*COUNTYCD", "locationName", "*INVYR", "authorEventCode", "subplot", "*TREE", "*STATUSCD") is not ID

SELECT create_if_not_exists($$CREATE INDEX "TREE.parent" ON "TREE" ("*STATECD", "*UNITCD", "*COUNTYCD", "locationName", "*INVYR", "authorEventCode", "subplot")$$);

*TREE-row_num

*TREE-PLT_CN

*TREE-PREV_TRE_CN

*INVYR

*STATECD

*UNITCD

*COUNTYCD

*TREE-AZIMUTH

*TREE-DIST

*TREE-PREVCOND

*TREE-STATUSCD

*SPCD

*TREE-SPGRPCD

*TREE-DIAHTCD

*TREE-HTCD

*TREE-ACTUALHT

*TREE-TREECLCD

*TREE-CR

*TREE-CCLCD

*TREE-TREEGRCD

*TREE-AGENTCD

*TREE-CULL

*TREE-DAMLOC1

*TREE-DAMTYP1

*TREE-DAMSEV1

*TREE-DAMLOC2

*TREE-DAMTYP2

*TREE-DAMSEV2

*TREE-DECAYCD

*TREE-STOCKING

*TREE-WDLDSTEM

*TREE-VOLCFNET

*TREE-VOLCFGRS

*TREE-VOLCSNET

*TREE-VOLCSGRS

*TREE-VOLBFNET

*TREE-VOLBFGRS

*TREE-VOLCFSND

*TREE-GROWCFGS

*TREE-GROWBFSL

*TREE-GROWCFAL

*TREE-MORTCFGS

*TREE-MORTBFSL

*TREE-MORTCFAL

*TREE-REMVCFGS

*TREE-REMVBFSL

*TREE-REMVCFAL

*TREE-DIACHECK

*TREE-MORTYR

*TREE-SALVCD

*TREE-UNCRCD

*TREE-CPOSCD

*TREE-CLIGHTCD

*TREE-CVIGORCD

*TREE-CDENCD

*TREE-CDIEBKCD

*TREE-TRANSCD

*TREE-TREEHISTCD

*TREE-DIACALC

*TREE-BHAGE

*TREE-TOTAGE

*TREE-CULLDEAD

*TREE-CULLFORM

*TREE-CULLMSTOP

*TREE-CULLBF

*TREE-CULLCF

*TREE-BFSND

*TREE-CFSND

*TREE-SAWHT

*BOLEHT

*TREE-FORMCL

*TREE-HTCALC

*TREE-HRDWD_CLUMP_CD

*TREE-SITREE

*TREE-CREATED_BY

*TREE-CREATED_DATE

*TREE-CREATED_IN_INSTANCE

*TREE-MODIFIED_BY

*TREE-MODIFIED_DATE

*TREE-MODIFIED_IN_INSTANCE

*TREE-MORTCD

*TREE-HTDMP

*TREE-ROUGHCULL

*TREE-MIST_CL_CD

*TREE-CULL_FLD

*TREE-RECONCILECD

*TREE-PREVDIA

*TREE-FGROWCFGS

*TREE-FGROWBFSL

*TREE-FGROWCFAL

*TREE-FMORTCFGS

*TREE-FMORTBFSL

*TREE-FMORTCFAL

*TREE-FREMVCFGS

*TREE-FREMVBFSL

*TREE-FREMVCFAL

*TREE-P2A_GRM_FLG

*TREE-TREECLCD_NERS

*TREE-TREECLCD_SRS

*TREE-TREECLCD_NCRS

*TREE-TREECLCD_RMRS

*TREE-STANDING_DEAD_CD

*TREE-PREV_STATUS_CD

*TREE-PREV_WDLDSTEM

*TREE-TPA_UNADJ

*TREE-TPAMORT_UNADJ

*TREE-TPAREMV_UNADJ

*TREE-TPAGROW_UNADJ

*TREE-DRYBIO_BOLE

*TREE-DRYBIO_TOP

*TREE-DRYBIO_STUMP

*TREE-DRYBIO_SAPLING

*TREE-DRYBIO_WDLD_SPP

*TREE-DRYBIO_BG

*TREE-CARBON_AG

*TREE-CARBON_BG

*TREE-CYCLE

*TREE-SUBCYCLE

*TREE-BORED_CD_PNWRS

*TREE-DAMLOC1_PNWRS

*TREE-DAMLOC2_PNWRS

*TREE-DIACHECK_PNWRS

*TREE-DMG_AGENT1_CD_PNWRS

*TREE-DMG_AGENT2_CD_PNWRS

*TREE-DMG_AGENT3_CD_PNWRS

*TREE-MIST_CL_CD_PNWRS

*TREE-SEVERITY1_CD_PNWRS

*TREE-SEVERITY1A_CD_PNWRS

*TREE-SEVERITY1B_CD_PNWRS

*TREE-SEVERITY2_CD_PNWRS

*TREE-SEVERITY2A_CD_PNWRS

*TREE-SEVERITY2B_CD_PNWRS

*TREE-SEVERITY3_CD_PNWRS

*TREE-UNKNOWN_DAMTYP1_PNWRS

*TREE-UNKNOWN_DAMTYP2_PNWRS

*TREE-PREV_PNTN_SRS

*TREE-DISEASE_SRS

*TREE-DIEBACK_SEVERITY_SRS

*STATECD,**STATECD,,

*REF_RESEARCH_STATION-row_num,**REF_RESEARCH_STATION-row_num,,

*REF_RESEARCH_STATION-RSCD,**REF_RESEARCH_STATION-RSCD,,

*REF_RESEARCH_STATION-RS,**REF_RESEARCH_STATION-RS,,

*REF_RESEARCH_STATION-STATE_ABBR,**REF_RESEARCH_STATION-STATE_ABBR,,

*REF_RESEARCH_STATION-CREATED_BY,**REF_RESEARCH_STATION-CREATED_BY,,

*REF_RESEARCH_STATION-CREATED_DATE,**REF_RESEARCH_STATION-CREATED_DATE,,

*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,**REF_RESEARCH_STATION-CREATED_IN_INSTANCE,,

*REF_RESEARCH_STATION-MODIFIED_BY,**REF_RESEARCH_STATION-MODIFIED_BY,,

*REF_RESEARCH_STATION-MODIFIED_DATE,**REF_RESEARCH_STATION-MODIFIED_DATE,,

*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,**REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,,

*UNITCD,**UNITCD,,

*REF_UNIT-row_num,**REF_UNIT-row_num,,

*REF_UNIT-MEANING,**REF_UNIT-MEANING,,

*REF_UNIT-CREATED_BY,**REF_UNIT-CREATED_BY,,

*REF_UNIT-CREATED_DATE,**REF_UNIT-CREATED_DATE,,

*REF_UNIT-CREATED_IN_INSTANCE,**REF_UNIT-CREATED_IN_INSTANCE,,

*REF_UNIT-MODIFIED_BY,**REF_UNIT-MODIFIED_BY,,

*REF_UNIT-MODIFIED_DATE,**REF_UNIT-MODIFIED_DATE,,

*REF_UNIT-MODIFIED_IN_INSTANCE,**REF_UNIT-MODIFIED_IN_INSTANCE,,

*COUNTYCD,**COUNTYCD,,

*COUNTY-row_num,**COUNTY-row_num,,

*COUNTY-CN,**COUNTY-CN,,

*COUNTY-CREATED_BY,**COUNTY-CREATED_BY,,

*COUNTY-CREATED_DATE,**COUNTY-CREATED_DATE,,

*COUNTY-CREATED_IN_INSTANCE,**COUNTY-CREATED_IN_INSTANCE,,

*COUNTY-MODIFIED_BY,**COUNTY-MODIFIED_BY,,

*COUNTY-MODIFIED_DATE,**COUNTY-MODIFIED_DATE,,

*COUNTY-MODIFIED_IN_INSTANCE,**COUNTY-MODIFIED_IN_INSTANCE,,

*INVYR,**INVYR,,

*PLOT-row_num,**PLOT-row_num,,

*PLOT-SRV_CN,**PLOT-SRV_CN,,

*PLOT-CTY_CN,**PLOT-CTY_CN,,

*PLOT-PREV_PLT_CN,**PLOT-PREV_PLT_CN,,

*PLOT-PLOT_STATUS_CD,**PLOT-PLOT_STATUS_CD,,

*PLOT-PLOT_NONSAMPLE_REASN_CD,**PLOT-PLOT_NONSAMPLE_REASN_CD,,

*PLOT-REMPER,**PLOT-REMPER,,

*PLOT-KINDCD,**PLOT-KINDCD,,

*PLOT-DESIGNCD,**PLOT-DESIGNCD,,

*PLOT-RDDISTCD,**PLOT-RDDISTCD,,

*PLOT-WATERCD,**PLOT-WATERCD,,

*PLOT-GROW_TYP_CD,**PLOT-GROW_TYP_CD,,

*PLOT-MORT_TYP_CD,**PLOT-MORT_TYP_CD,,

*PLOT-P2PANEL,**PLOT-P2PANEL,,

*PLOT-P3PANEL,**PLOT-P3PANEL,,

*PLOT-ECOSUBCD,**PLOT-ECOSUBCD,,

*PLOT-CONGCD,**PLOT-CONGCD,,

*PLOT-MANUAL,**PLOT-MANUAL,,

*PLOT-SUBPANEL,**PLOT-SUBPANEL,,

*PLOT-KINDCD_NC,**PLOT-KINDCD_NC,,

*PLOT-QA_STATUS,**PLOT-QA_STATUS,,

*PLOT-CREATED_BY,**PLOT-CREATED_BY,,

*PLOT-CREATED_DATE,**PLOT-CREATED_DATE,,

*PLOT-CREATED_IN_INSTANCE,**PLOT-CREATED_IN_INSTANCE,,

*PLOT-MODIFIED_BY,**PLOT-MODIFIED_BY,,

*PLOT-MODIFIED_DATE,**PLOT-MODIFIED_DATE,,

*PLOT-MODIFIED_IN_INSTANCE,**PLOT-MODIFIED_IN_INSTANCE,,

*PLOT-MICROPLOT_LOC,**PLOT-MICROPLOT_LOC,,

*PLOT-DECLINATION,**PLOT-DECLINATION,,

*PLOT-EMAP_HEX,**PLOT-EMAP_HEX,,

*PLOT-SAMP_METHOD_CD,**PLOT-SAMP_METHOD_CD,,

*PLOT-SUBP_EXAMINE_CD,**PLOT-SUBP_EXAMINE_CD,,

*PLOT-MACRO_BREAKPOINT_DIA,**PLOT-MACRO_BREAKPOINT_DIA,,

*PLOT-INTENSITY,**PLOT-INTENSITY,,

*PLOT-CYCLE,**PLOT-CYCLE,,

*PLOT-SUBCYCLE,**PLOT-SUBCYCLE,,

*PLOT-ECO_UNIT_PNW,**PLOT-ECO_UNIT_PNW,,

*PLOT-TOPO_POSITION_PNW,**PLOT-TOPO_POSITION_PNW,,

*PLOT-NF_SAMPLING_STATUS_CD,**PLOT-NF_SAMPLING_STATUS_CD,,

*PLOT-NF_PLOT_STATUS_CD,**PLOT-NF_PLOT_STATUS_CD,,

*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,**PLOT-NF_PLOT_NONSAMPLE_REASN_CD,,

*PLOT-P2VEG_SAMPLING_STATUS_CD,**PLOT-P2VEG_SAMPLING_STATUS_CD,,

*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,**PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,,

*PLOT-INVASIVE_SAMPLING_STATUS_CD,**PLOT-INVASIVE_SAMPLING_STATUS_CD,,

*PLOT-INVASIVE_SPECIMEN_RULE_CD,**PLOT-INVASIVE_SPECIMEN_RULE_CD,,

*PLOT-DESIGNCD_P2A,**PLOT-DESIGNCD_P2A,,

*HABTYPCD,**HABTYPCD,,

*HABTYP_PUB_CD,**HABTYP_PUB_CD,,

*COND-row_num,**COND-row_num,,

*COND-CN,**COND-CN,,

*COND-PLT_CN,**COND-PLT_CN,,

*COND-COND_STATUS_CD,**COND-COND_STATUS_CD,,

*COND-COND_NONSAMPLE_REASN_CD,**COND-COND_NONSAMPLE_REASN_CD,,

*COND-RESERVCD,**COND-RESERVCD,,

*COND-OWNCD,**COND-OWNCD,,

*COND-OWNGRPCD,**COND-OWNGRPCD,,

*COND-FORINDCD,**COND-FORINDCD,,

*COND-ADFORCD,**COND-ADFORCD,,

*COND-FORTYPCD,**COND-FORTYPCD,,

*COND-FLDTYPCD,**COND-FLDTYPCD,,

*COND-MAPDEN,**COND-MAPDEN,,

*COND-STDAGE,**COND-STDAGE,,

*COND-STDSZCD,**COND-STDSZCD,,

*COND-FLDSZCD,**COND-FLDSZCD,,

*COND-SITECLCD,**COND-SITECLCD,,

*COND-SICOND,**COND-SICOND,,

*COND-SIBASE,**COND-SIBASE,,

*COND-SISP,**COND-SISP,,

*COND-STDORGCD,**COND-STDORGCD,,

*COND-STDORGSP,**COND-STDORGSP,,

*COND-PROP_BASIS,**COND-PROP_BASIS,,

*COND-CONDPROP_UNADJ,**COND-CONDPROP_UNADJ,,

*COND-MICRPROP_UNADJ,**COND-MICRPROP_UNADJ,,

*COND-SUBPPROP_UNADJ,**COND-SUBPPROP_UNADJ,,

*COND-MACRPROP_UNADJ,**COND-MACRPROP_UNADJ,,

*COND-PHYSCLCD,**COND-PHYSCLCD,,

*COND-GSSTKCD,**COND-GSSTKCD,,

*COND-ALSTKCD,**COND-ALSTKCD,,

*COND-DSTRBCD1,**COND-DSTRBCD1,,

*COND-DSTRBYR1,**COND-DSTRBYR1,,

*COND-DSTRBCD2,**COND-DSTRBCD2,,

*COND-DSTRBYR2,**COND-DSTRBYR2,,

*COND-DSTRBCD3,**COND-DSTRBCD3,,

*COND-DSTRBYR3,**COND-DSTRBYR3,,

*COND-TRTCD1,**COND-TRTCD1,,

*COND-TRTYR1,**COND-TRTYR1,,

*COND-TRTCD2,**COND-TRTCD2,,

*COND-TRTYR2,**COND-TRTYR2,,

*COND-TRTCD3,**COND-TRTCD3,,

*COND-TRTYR3,**COND-TRTYR3,,

*COND-PRESNFCD,**COND-PRESNFCD,,

*COND-BALIVE,**COND-BALIVE,,

*COND-FLDAGE,**COND-FLDAGE,,

*COND-ALSTK,**COND-ALSTK,,

*COND-GSSTK,**COND-GSSTK,,

*COND-FORTYPCDCALC,**COND-FORTYPCDCALC,,

*COND-HABTYPCD1_DESCR_PUB_CD,**COND-HABTYPCD1_DESCR_PUB_CD,,

*COND-HABTYPCD2,**COND-HABTYPCD2,,

*COND-HABTYPCD2_PUB_CD,**COND-HABTYPCD2_PUB_CD,,

*COND-HABTYPCD2_DESCR_PUB_CD,**COND-HABTYPCD2_DESCR_PUB_CD,,

*COND-MIXEDCONFCD,**COND-MIXEDCONFCD,,

*COND-VOL_LOC_GRP,**COND-VOL_LOC_GRP,,

*COND-SITECLCDEST,**COND-SITECLCDEST,,

*COND-SITETREE_TREE,**COND-SITETREE_TREE,,

*COND-SITECL_METHOD,**COND-SITECL_METHOD,,

*COND-CARBON_DOWN_DEAD,**COND-CARBON_DOWN_DEAD,,

*COND-CARBON_LITTER,**COND-CARBON_LITTER,,

*COND-CARBON_SOIL_ORG,**COND-CARBON_SOIL_ORG,,

*COND-CARBON_STANDING_DEAD,**COND-CARBON_STANDING_DEAD,,

*COND-CARBON_UNDERSTORY_AG,**COND-CARBON_UNDERSTORY_AG,,

*COND-CARBON_UNDERSTORY_BG,**COND-CARBON_UNDERSTORY_BG,,

*COND-CREATED_BY,**COND-CREATED_BY,,

*COND-CREATED_DATE,**COND-CREATED_DATE,,

*COND-CREATED_IN_INSTANCE,**COND-CREATED_IN_INSTANCE,,

*COND-MODIFIED_BY,**COND-MODIFIED_BY,,

*COND-MODIFIED_DATE,**COND-MODIFIED_DATE,,

*COND-MODIFIED_IN_INSTANCE,**COND-MODIFIED_IN_INSTANCE,,

*COND-CYCLE,**COND-CYCLE,,

*COND-SUBCYCLE,**COND-SUBCYCLE,,

*COND-SOIL_ROOTING_DEPTH_PNW,**COND-SOIL_ROOTING_DEPTH_PNW,,

*COND-GROUND_LAND_CLASS_PNW,**COND-GROUND_LAND_CLASS_PNW,,

*COND-PLANT_STOCKABILITY_FACTOR_PNW,**COND-PLANT_STOCKABILITY_FACTOR_PNW,,

*COND-STND_COND_CD_PNWRS,**COND-STND_COND_CD_PNWRS,,

*COND-STND_STRUC_CD_PNWRS,**COND-STND_STRUC_CD_PNWRS,,

*COND-STUMP_CD_PNWRS,**COND-STUMP_CD_PNWRS,,

*COND-FIRE_SRS,**COND-FIRE_SRS,,

*COND-GRAZING_SRS,**COND-GRAZING_SRS,,

*COND-HARVEST_TYPE1_SRS,**COND-HARVEST_TYPE1_SRS,,

*COND-HARVEST_TYPE2_SRS,**COND-HARVEST_TYPE2_SRS,,

*COND-HARVEST_TYPE3_SRS,**COND-HARVEST_TYPE3_SRS,,

*COND-LAND_USE_SRS,**COND-LAND_USE_SRS,,

*COND-OPERABILITY_SRS,**COND-OPERABILITY_SRS,,

*COND-STAND_STRUCTURE_SRS,**COND-STAND_STRUCTURE_SRS,,

*COND-NF_COND_STATUS_CD,**COND-NF_COND_STATUS_CD,,

*COND-NF_COND_NONSAMPLE_REASN_CD,**COND-NF_COND_NONSAMPLE_REASN_CD,,

*COND-CANOPY_CVR_SAMPLE_METHOD_CD,**COND-CANOPY_CVR_SAMPLE_METHOD_CD,,

*COND-LIVE_CANOPY_CVR_PCT,**COND-LIVE_CANOPY_CVR_PCT,,

*COND-LIVE_MISSING_CANOPY_CVR_PCT,**COND-LIVE_MISSING_CANOPY_CVR_PCT,,

*COND-NBR_LIVE_STEMS,**COND-NBR_LIVE_STEMS,,

*COND-OWNSUBCD,**COND-OWNSUBCD,,

*COND-INDUSTRIALCD_FIADB,**COND-INDUSTRIALCD_FIADB,,

*COND-RESERVCD_FLD,**COND-RESERVCD_FLD,,

*COND-ADMIN_WITHDRAWN_CD,**COND-ADMIN_WITHDRAWN_CD,,

*REF_HABTYP_DESCRIPTION-row_num,**REF_HABTYP_DESCRIPTION-row_num,,

*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,**REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,,

*REF_HABTYP_DESCRIPTION-VALID,**REF_HABTYP_DESCRIPTION-VALID,,

*REF_HABTYP_DESCRIPTION-CREATED_BY,**REF_HABTYP_DESCRIPTION-CREATED_BY,,

*REF_HABTYP_DESCRIPTION-CREATED_DATE,**REF_HABTYP_DESCRIPTION-CREATED_DATE,,

*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,**REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,,

*REF_HABTYP_DESCRIPTION-MODIFIED_BY,**REF_HABTYP_DESCRIPTION-MODIFIED_BY,,

*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,**REF_HABTYP_DESCRIPTION-MODIFIED_DATE,,

*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,**REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,,

*SUBPLOT-row_num,**SUBPLOT-row_num,,

*SUBPLOT-PLT_CN,**SUBPLOT-PLT_CN,,

*SUBPLOT-PREV_SBP_CN,**SUBPLOT-PREV_SBP_CN,,

*SUBPLOT-SUBP_STATUS_CD,**SUBPLOT-SUBP_STATUS_CD,,

*SUBPLOT-POINT_NONSAMPLE_REASN_CD,**SUBPLOT-POINT_NONSAMPLE_REASN_CD,,

*SUBPLOT-MICRCOND,**SUBPLOT-MICRCOND,,

*SUBPLOT-SUBPCOND,**SUBPLOT-SUBPCOND,,

*SUBPLOT-MACRCOND,**SUBPLOT-MACRCOND,,

*SUBPLOT-CONDLIST,**SUBPLOT-CONDLIST,,

*SUBPLOT-SLOPE,**SUBPLOT-SLOPE,,

*SUBPLOT-ASPECT,**SUBPLOT-ASPECT,,

*SUBPLOT-WATERDEP,**SUBPLOT-WATERDEP,,

*SUBPLOT-P2A_GRM_FLG,**SUBPLOT-P2A_GRM_FLG,,

*SUBPLOT-CREATED_BY,**SUBPLOT-CREATED_BY,,

*SUBPLOT-CREATED_DATE,**SUBPLOT-CREATED_DATE,,

*SUBPLOT-CREATED_IN_INSTANCE,**SUBPLOT-CREATED_IN_INSTANCE,,

*SUBPLOT-MODIFIED_BY,**SUBPLOT-MODIFIED_BY,,

*SUBPLOT-MODIFIED_DATE,**SUBPLOT-MODIFIED_DATE,,

*SUBPLOT-MODIFIED_IN_INSTANCE,**SUBPLOT-MODIFIED_IN_INSTANCE,,

*SUBPLOT-CYCLE,**SUBPLOT-CYCLE,,

*SUBPLOT-SUBCYCLE,**SUBPLOT-SUBCYCLE,,

*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,**SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,,

*SUBPLOT-NF_SUBP_STATUS_CD,**SUBPLOT-NF_SUBP_STATUS_CD,,

*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,**SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,,

*SUBPLOT-P2VEG_SUBP_STATUS_CD,**SUBPLOT-P2VEG_SUBP_STATUS_CD,,

*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,**SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,,

*SUBPLOT-INVASIVE_SUBP_STATUS_CD,**SUBPLOT-INVASIVE_SUBP_STATUS_CD,,

*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,**SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,,

*PLANT_SYMBOL,**PLANT_SYMBOL,,

*SPCD,**SPCD,,

*TREE-row_num,**TREE-row_num,,

*TREE-PLT_CN,**TREE-PLT_CN,,

*TREE-PREV_TRE_CN,**TREE-PREV_TRE_CN,,

*TREE-AZIMUTH,**TREE-AZIMUTH,,

*TREE-DIST,**TREE-DIST,,

*TREE-PREVCOND,**TREE-PREVCOND,,

*TREE-STATUSCD,**TREE-STATUSCD,,

*TREE-SPGRPCD,**TREE-SPGRPCD,,

*TREE-DIAHTCD,**TREE-DIAHTCD,,

*TREE-HTCD,**TREE-HTCD,,

*TREE-ACTUALHT,**TREE-ACTUALHT,,

*TREE-TREECLCD,**TREE-TREECLCD,,

*TREE-CR,**TREE-CR,,

*TREE-CCLCD,**TREE-CCLCD,,

*TREE-TREEGRCD,**TREE-TREEGRCD,,

*TREE-AGENTCD,**TREE-AGENTCD,,

*TREE-CULL,**TREE-CULL,,

*TREE-DAMLOC1,**TREE-DAMLOC1,,

*TREE-DAMTYP1,**TREE-DAMTYP1,,

*TREE-DAMSEV1,**TREE-DAMSEV1,,

*TREE-DAMLOC2,**TREE-DAMLOC2,,

*TREE-DAMTYP2,**TREE-DAMTYP2,,

*TREE-DAMSEV2,**TREE-DAMSEV2,,

*TREE-DECAYCD,**TREE-DECAYCD,,

*TREE-STOCKING,**TREE-STOCKING,,

*TREE-WDLDSTEM,**TREE-WDLDSTEM,,

*TREE-VOLCFNET,**TREE-VOLCFNET,,

*TREE-VOLCFGRS,**TREE-VOLCFGRS,,

*TREE-VOLCSNET,**TREE-VOLCSNET,,

*TREE-VOLCSGRS,**TREE-VOLCSGRS,,

*TREE-VOLBFNET,**TREE-VOLBFNET,,

*TREE-VOLBFGRS,**TREE-VOLBFGRS,,

*TREE-VOLCFSND,**TREE-VOLCFSND,,

*TREE-GROWCFGS,**TREE-GROWCFGS,,

*TREE-GROWBFSL,**TREE-GROWBFSL,,

*TREE-GROWCFAL,**TREE-GROWCFAL,,

*TREE-MORTCFGS,**TREE-MORTCFGS,,

*TREE-MORTBFSL,**TREE-MORTBFSL,,

*TREE-MORTCFAL,**TREE-MORTCFAL,,

*TREE-REMVCFGS,**TREE-REMVCFGS,,

*TREE-REMVBFSL,**TREE-REMVBFSL,,

*TREE-REMVCFAL,**TREE-REMVCFAL,,

*TREE-DIACHECK,**TREE-DIACHECK,,

*TREE-MORTYR,**TREE-MORTYR,,

*TREE-SALVCD,**TREE-SALVCD,,

*TREE-UNCRCD,**TREE-UNCRCD,,

*TREE-CPOSCD,**TREE-CPOSCD,,

*TREE-CLIGHTCD,**TREE-CLIGHTCD,,

*TREE-CVIGORCD,**TREE-CVIGORCD,,

*TREE-CDENCD,**TREE-CDENCD,,

*TREE-CDIEBKCD,**TREE-CDIEBKCD,,

*TREE-TRANSCD,**TREE-TRANSCD,,

*TREE-TREEHISTCD,**TREE-TREEHISTCD,,

*TREE-DIACALC,**TREE-DIACALC,,

*TREE-BHAGE,**TREE-BHAGE,,

*TREE-TOTAGE,**TREE-TOTAGE,,

*TREE-CULLDEAD,**TREE-CULLDEAD,,

*TREE-CULLFORM,**TREE-CULLFORM,,

*TREE-CULLMSTOP,**TREE-CULLMSTOP,,

*TREE-CULLBF,**TREE-CULLBF,,

*TREE-CULLCF,**TREE-CULLCF,,

*TREE-BFSND,**TREE-BFSND,,

*TREE-CFSND,**TREE-CFSND,,

*TREE-SAWHT,**TREE-SAWHT,,

*BOLEHT,**BOLEHT,,

*TREE-FORMCL,**TREE-FORMCL,,

*TREE-HTCALC,**TREE-HTCALC,,

*TREE-HRDWD_CLUMP_CD,**TREE-HRDWD_CLUMP_CD,,

*TREE-SITREE,**TREE-SITREE,,

*TREE-CREATED_BY,**TREE-CREATED_BY,,

*TREE-CREATED_DATE,**TREE-CREATED_DATE,,

*TREE-CREATED_IN_INSTANCE,**TREE-CREATED_IN_INSTANCE,,

*TREE-MODIFIED_BY,**TREE-MODIFIED_BY,,

*TREE-MODIFIED_DATE,**TREE-MODIFIED_DATE,,

*TREE-MODIFIED_IN_INSTANCE,**TREE-MODIFIED_IN_INSTANCE,,

*TREE-MORTCD,**TREE-MORTCD,,

*TREE-HTDMP,**TREE-HTDMP,,

*TREE-ROUGHCULL,**TREE-ROUGHCULL,,

*TREE-MIST_CL_CD,**TREE-MIST_CL_CD,,

*TREE-CULL_FLD,**TREE-CULL_FLD,,

*TREE-RECONCILECD,**TREE-RECONCILECD,,

*TREE-PREVDIA,**TREE-PREVDIA,,

*TREE-FGROWCFGS,**TREE-FGROWCFGS,,

*TREE-FGROWBFSL,**TREE-FGROWBFSL,,

*TREE-FGROWCFAL,**TREE-FGROWCFAL,,

*TREE-FMORTCFGS,**TREE-FMORTCFGS,,

*TREE-FMORTBFSL,**TREE-FMORTBFSL,,

*TREE-FMORTCFAL,**TREE-FMORTCFAL,,

*TREE-FREMVCFGS,**TREE-FREMVCFGS,,

*TREE-FREMVBFSL,**TREE-FREMVBFSL,,

*TREE-FREMVCFAL,**TREE-FREMVCFAL,,

*TREE-P2A_GRM_FLG,**TREE-P2A_GRM_FLG,,

*TREE-TREECLCD_NERS,**TREE-TREECLCD_NERS,,

*TREE-TREECLCD_SRS,**TREE-TREECLCD_SRS,,

*TREE-TREECLCD_NCRS,**TREE-TREECLCD_NCRS,,

*TREE-TREECLCD_RMRS,**TREE-TREECLCD_RMRS,,

*TREE-STANDING_DEAD_CD,**TREE-STANDING_DEAD_CD,,

*TREE-PREV_STATUS_CD,**TREE-PREV_STATUS_CD,,

*TREE-PREV_WDLDSTEM,**TREE-PREV_WDLDSTEM,,

*TREE-TPA_UNADJ,**TREE-TPA_UNADJ,,

*TREE-TPAMORT_UNADJ,**TREE-TPAMORT_UNADJ,,

*TREE-TPAREMV_UNADJ,**TREE-TPAREMV_UNADJ,,

*TREE-TPAGROW_UNADJ,**TREE-TPAGROW_UNADJ,,

*TREE-DRYBIO_BOLE,**TREE-DRYBIO_BOLE,,

*TREE-DRYBIO_TOP,**TREE-DRYBIO_TOP,,

*TREE-DRYBIO_STUMP,**TREE-DRYBIO_STUMP,,

*TREE-DRYBIO_SAPLING,**TREE-DRYBIO_SAPLING,,

*TREE-DRYBIO_WDLD_SPP,**TREE-DRYBIO_WDLD_SPP,,

*TREE-DRYBIO_BG,**TREE-DRYBIO_BG,,

*TREE-CARBON_AG,**TREE-CARBON_AG,,

*TREE-CARBON_BG,**TREE-CARBON_BG,,

*TREE-CYCLE,**TREE-CYCLE,,

*TREE-SUBCYCLE,**TREE-SUBCYCLE,,

*TREE-BORED_CD_PNWRS,**TREE-BORED_CD_PNWRS,,

*TREE-DAMLOC1_PNWRS,**TREE-DAMLOC1_PNWRS,,

*TREE-DAMLOC2_PNWRS,**TREE-DAMLOC2_PNWRS,,

*TREE-DIACHECK_PNWRS,**TREE-DIACHECK_PNWRS,,

*TREE-DMG_AGENT1_CD_PNWRS,**TREE-DMG_AGENT1_CD_PNWRS,,

*TREE-DMG_AGENT2_CD_PNWRS,**TREE-DMG_AGENT2_CD_PNWRS,,

*TREE-DMG_AGENT3_CD_PNWRS,**TREE-DMG_AGENT3_CD_PNWRS,,

*TREE-MIST_CL_CD_PNWRS,**TREE-MIST_CL_CD_PNWRS,,

*TREE-SEVERITY1_CD_PNWRS,**TREE-SEVERITY1_CD_PNWRS,,

*TREE-SEVERITY1A_CD_PNWRS,**TREE-SEVERITY1A_CD_PNWRS,,

*TREE-SEVERITY1B_CD_PNWRS,**TREE-SEVERITY1B_CD_PNWRS,,

*TREE-SEVERITY2_CD_PNWRS,**TREE-SEVERITY2_CD_PNWRS,,

*TREE-SEVERITY2A_CD_PNWRS,**TREE-SEVERITY2A_CD_PNWRS,,

*TREE-SEVERITY2B_CD_PNWRS,**TREE-SEVERITY2B_CD_PNWRS,,

*TREE-SEVERITY3_CD_PNWRS,**TREE-SEVERITY3_CD_PNWRS,,

*TREE-UNKNOWN_DAMTYP1_PNWRS,**TREE-UNKNOWN_DAMTYP1_PNWRS,,

*TREE-UNKNOWN_DAMTYP2_PNWRS,**TREE-UNKNOWN_DAMTYP2_PNWRS,,

*TREE-PREV_PNTN_SRS,**TREE-PREV_PNTN_SRS,,

*TREE-DISEASE_SRS,**TREE-DISEASE_SRS,,

*TREE-DIEBACK_SEVERITY_SRS,**TREE-DIEBACK_SEVERITY_SRS,,

*REF_SPECIES-row_num,**REF_SPECIES-row_num,,

*REF_SPECIES-COMMON_NAME,**REF_SPECIES-COMMON_NAME,,

*REF_SPECIES-GENUS,**REF_SPECIES-GENUS,,

*REF_SPECIES-SPECIES,**REF_SPECIES-SPECIES,,

*REF_SPECIES-VARIETY,**REF_SPECIES-VARIETY,,

*REF_SPECIES-SUBSPECIES,**REF_SPECIES-SUBSPECIES,,

*REF_SPECIES-E_SPGRPCD,**REF_SPECIES-E_SPGRPCD,,

*REF_SPECIES-W_SPGRPCD,**REF_SPECIES-W_SPGRPCD,,

*REF_SPECIES-C_SPGRPCD,**REF_SPECIES-C_SPGRPCD,,

*REF_SPECIES-P_SPGRPCD,**REF_SPECIES-P_SPGRPCD,,

*REF_SPECIES-MAJOR_SPGRPCD,**REF_SPECIES-MAJOR_SPGRPCD,,

*REF_SPECIES-STOCKING_SPGRPCD,**REF_SPECIES-STOCKING_SPGRPCD,,

*REF_SPECIES-FOREST_TYPE_SPGRPCD,**REF_SPECIES-FOREST_TYPE_SPGRPCD,,

*REF_SPECIES-EXISTS_IN_NCRS,**REF_SPECIES-EXISTS_IN_NCRS,,

*REF_SPECIES-EXISTS_IN_NERS,**REF_SPECIES-EXISTS_IN_NERS,,

*REF_SPECIES-EXISTS_IN_PNWRS,**REF_SPECIES-EXISTS_IN_PNWRS,,

*REF_SPECIES-EXISTS_IN_RMRS,**REF_SPECIES-EXISTS_IN_RMRS,,

*REF_SPECIES-EXISTS_IN_SRS,**REF_SPECIES-EXISTS_IN_SRS,,

*REF_SPECIES-SITETREE,**REF_SPECIES-SITETREE,,

*REF_SPECIES-SFTWD_HRDWD,**REF_SPECIES-SFTWD_HRDWD,,

*REF_SPECIES-ST_EXISTS_IN_NCRS,**REF_SPECIES-ST_EXISTS_IN_NCRS,,

*REF_SPECIES-ST_EXISTS_IN_NERS,**REF_SPECIES-ST_EXISTS_IN_NERS,,

*REF_SPECIES-ST_EXISTS_IN_PNWRS,**REF_SPECIES-ST_EXISTS_IN_PNWRS,,

*REF_SPECIES-ST_EXISTS_IN_RMRS,**REF_SPECIES-ST_EXISTS_IN_RMRS,,

*REF_SPECIES-ST_EXISTS_IN_SRS,**REF_SPECIES-ST_EXISTS_IN_SRS,,

*REF_SPECIES-CORE,**REF_SPECIES-CORE,,

*REF_SPECIES-EAST,**REF_SPECIES-EAST,,

*REF_SPECIES-WEST,**REF_SPECIES-WEST,,

*REF_SPECIES-CARIBBEAN,**REF_SPECIES-CARIBBEAN,,

*REF_SPECIES-PACIFIC,**REF_SPECIES-PACIFIC,,

*REF_SPECIES-WOODLAND,**REF_SPECIES-WOODLAND,,

*REF_SPECIES-MANUAL_START,**REF_SPECIES-MANUAL_START,,

*REF_SPECIES-MANUAL_END,**REF_SPECIES-MANUAL_END,,

*REF_SPECIES-JENKINS_SPGRPCD,**REF_SPECIES-JENKINS_SPGRPCD,,

*REF_SPECIES-JENKINS_TOTAL_B1,**REF_SPECIES-JENKINS_TOTAL_B1,,

*REF_SPECIES-JENKINS_TOTAL_B2,**REF_SPECIES-JENKINS_TOTAL_B2,,

*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1,**REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1,,

*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2,**REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2,,

*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1,**REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1,,

*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2,**REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2,,

*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1,**REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1,,

*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2,**REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2,,

*REF_SPECIES-JENKINS_ROOT_RATIO_B1,**REF_SPECIES-JENKINS_ROOT_RATIO_B1,,

*REF_SPECIES-JENKINS_ROOT_RATIO_B2,**REF_SPECIES-JENKINS_ROOT_RATIO_B2,,

*REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT,**REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT,,

*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT,**REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT,,

*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT,**REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT,,

*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT,**REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT,,

*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT,**REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT,,

*REF_SPECIES-MC_PCT_GREEN_BARK,**REF_SPECIES-MC_PCT_GREEN_BARK,,

*REF_SPECIES-MC_PCT_GREEN_BARK_CIT,**REF_SPECIES-MC_PCT_GREEN_BARK_CIT,,

*REF_SPECIES-MC_PCT_GREEN_WOOD,**REF_SPECIES-MC_PCT_GREEN_WOOD,,

*REF_SPECIES-MC_PCT_GREEN_WOOD_CIT,**REF_SPECIES-MC_PCT_GREEN_WOOD_CIT,,

*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT,**REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT,,

*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT,**REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT,,

*REF_SPECIES-BARK_VOL_PCT,**REF_SPECIES-BARK_VOL_PCT,,

*REF_SPECIES-BARK_VOL_PCT_CIT,**REF_SPECIES-BARK_VOL_PCT_CIT,,

*REF_SPECIES-RAILE_STUMP_DOB_B1,**REF_SPECIES-RAILE_STUMP_DOB_B1,,

*REF_SPECIES-RAILE_STUMP_DIB_B1,**REF_SPECIES-RAILE_STUMP_DIB_B1,,

*REF_SPECIES-RAILE_STUMP_DIB_B2,**REF_SPECIES-RAILE_STUMP_DIB_B2,,

*REF_SPECIES-CWD_DECAY_RATIO1,**REF_SPECIES-CWD_DECAY_RATIO1,,

*REF_SPECIES-CWD_DECAY_RATIO2,**REF_SPECIES-CWD_DECAY_RATIO2,,

*REF_SPECIES-CWD_DECAY_RATIO3,**REF_SPECIES-CWD_DECAY_RATIO3,,

*REF_SPECIES-CWD_DECAY_RATIO4,**REF_SPECIES-CWD_DECAY_RATIO4,,

*REF_SPECIES-CWD_DECAY_RATIO5,**REF_SPECIES-CWD_DECAY_RATIO5,,

*REF_SPECIES-DWM_CARBON_RATIO,**REF_SPECIES-DWM_CARBON_RATIO,,

*REF_SPECIES-STANDING_DEAD_DECAY_RATIO1,**REF_SPECIES-STANDING_DEAD_DECAY_RATIO1,,

*REF_SPECIES-STANDING_DEAD_DECAY_RATIO2,**REF_SPECIES-STANDING_DEAD_DECAY_RATIO2,,

*REF_SPECIES-STANDING_DEAD_DECAY_RATIO3,**REF_SPECIES-STANDING_DEAD_DECAY_RATIO3,,

*REF_SPECIES-STANDING_DEAD_DECAY_RATIO4,**REF_SPECIES-STANDING_DEAD_DECAY_RATIO4,,

*REF_SPECIES-STANDING_DEAD_DECAY_RATIO5,**REF_SPECIES-STANDING_DEAD_DECAY_RATIO5,,

*REF_SPECIES-CREATED_BY,**REF_SPECIES-CREATED_BY,,

*REF_SPECIES-CREATED_DATE,**REF_SPECIES-CREATED_DATE,,

*REF_SPECIES-CREATED_IN_INSTANCE,**REF_SPECIES-CREATED_IN_INSTANCE,,

*REF_SPECIES-MODIFIED_BY,**REF_SPECIES-MODIFIED_BY,,

*REF_SPECIES-MODIFIED_DATE,**REF_SPECIES-MODIFIED_DATE,,

*REF_SPECIES-MODIFIED_IN_INSTANCE,**REF_SPECIES-MODIFIED_IN_INSTANCE,,

PLANT_SYMBOL_TYPE,*PLANT_SYMBOL_TYPE,,

*REF_PLANT_DICTIONARY-row_num,**REF_PLANT_DICTIONARY-row_num,,

*REF_PLANT_DICTIONARY-CN,**REF_PLANT_DICTIONARY-CN,,

*PLANT_SYMBOL_TYPE,**PLANT_SYMBOL_TYPE,,

*REF_PLANT_DICTIONARY-NEW_SYMBOL,**REF_PLANT_DICTIONARY-NEW_SYMBOL,,

*REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME,**REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME,,

*REF_PLANT_DICTIONARY-CATEGORY,**REF_PLANT_DICTIONARY-CATEGORY,,

*REF_PLANT_DICTIONARY-DURATION,**REF_PLANT_DICTIONARY-DURATION,,

*REF_PLANT_DICTIONARY-US_NATIVITY,**REF_PLANT_DICTIONARY-US_NATIVITY,,

*REF_PLANT_DICTIONARY-STATE_DISTRIBUTION,**REF_PLANT_DICTIONARY-STATE_DISTRIBUTION,,

*REF_PLANT_DICTIONARY-STATE_AND_PROVINCE,**REF_PLANT_DICTIONARY-STATE_AND_PROVINCE,,

*GENERA_BINOMIAL_AUTHOR,**GENERA_BINOMIAL_AUTHOR,,

*TRINOMIAL_AUTHOR,**TRINOMIAL_AUTHOR,,

*QUADRINOMIAL_AUTHOR,**QUADRINOMIAL_AUTHOR,,

*XGENUS,**XGENUS,,

*XSPECIES,**XSPECIES,,

*SSP_PREFIX,**SSP_PREFIX,,

*XSUBSPECIES,**XSUBSPECIES,,

*VAR_PREFIX,**VAR_PREFIX,,

*XVARIETY,**XVARIETY,,

*SUBVAR,**SUBVAR,,

*SUBVARIETY,**SUBVARIETY,,

*F_PREFIX,**F_PREFIX,,

*REF_PLANT_DICTIONARY-NOTES,**REF_PLANT_DICTIONARY-NOTES,,

*REF_PLANT_DICTIONARY-CREATED_BY,**REF_PLANT_DICTIONARY-CREATED_BY,,

*REF_PLANT_DICTIONARY-CREATED_DATE,**REF_PLANT_DICTIONARY-CREATED_DATE,,

*REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE,**REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE,,

*REF_PLANT_DICTIONARY-MODIFIED_BY,**REF_PLANT_DICTIONARY-MODIFIED_BY,,

*REF_PLANT_DICTIONARY-MODIFIED_DATE,**REF_PLANT_DICTIONARY-MODIFIED_DATE,,

*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE,**REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE,,

SELECT "*TREE-row_num" AS "occurrence_all-row_num", *

row_num,*REF_HABTYP_DESCRIPTION-row_num,,

HABTYPCD,*HABTYPCD,,

PUB_CD,*HABTYP_PUB_CD,,

SCIENTIFIC_NAME,*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,,

VALID,*REF_HABTYP_DESCRIPTION-VALID,,

CREATED_BY,*REF_HABTYP_DESCRIPTION-CREATED_BY,,

CREATED_DATE,*REF_HABTYP_DESCRIPTION-CREATED_DATE,,

CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,,

MODIFIED_BY,*REF_HABTYP_DESCRIPTION-MODIFIED_BY,,

MODIFIED_DATE,*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,,

MODIFIED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,,

*REF_HABTYP_DESCRIPTION-row_num

*HABTYPCD

*HABTYP_PUB_CD

*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME

*REF_HABTYP_DESCRIPTION-VALID

*REF_HABTYP_DESCRIPTION-CREATED_BY