| 1 |
|
occurrence_all-row_num,*STATECD,*REF_RESEARCH_STATION-row_num,*REF_RESEARCH_STATION-RSCD,*REF_RESEARCH_STATION-RS,stateProvince,*REF_RESEARCH_STATION-STATE_ABBR,*REF_RESEARCH_STATION-CREATED_BY,*REF_RESEARCH_STATION-CREATED_DATE,*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,*REF_RESEARCH_STATION-MODIFIED_BY,*REF_RESEARCH_STATION-MODIFIED_DATE,*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,*UNITCD,*REF_UNIT-row_num,*REF_UNIT-MEANING,*REF_UNIT-CREATED_BY,*REF_UNIT-CREATED_DATE,*REF_UNIT-CREATED_IN_INSTANCE,*REF_UNIT-MODIFIED_BY,*REF_UNIT-MODIFIED_DATE,*REF_UNIT-MODIFIED_IN_INSTANCE,*COUNTYCD,*COUNTY-row_num,county,*COUNTY-CN,*COUNTY-CREATED_BY,*COUNTY-CREATED_DATE,*COUNTY-CREATED_IN_INSTANCE,*COUNTY-MODIFIED_BY,*COUNTY-MODIFIED_DATE,*COUNTY-MODIFIED_IN_INSTANCE,*INVYR,locationName,*PLOT-row_num,locationID,*PLOT-SRV_CN,*PLOT-CTY_CN,*PLOT-PREV_PLT_CN,*PLOT-PLOT_STATUS_CD,*PLOT-PLOT_NONSAMPLE_REASN_CD,year,month,day,*PLOT-REMPER,*PLOT-KINDCD,*PLOT-DESIGNCD,*PLOT-RDDISTCD,*PLOT-WATERCD,decimalLatitude,decimalLongitude,elevation_ft,*PLOT-GROW_TYP_CD,*PLOT-MORT_TYP_CD,*PLOT-P2PANEL,*PLOT-P3PANEL,*PLOT-ECOSUBCD,*PLOT-CONGCD,*PLOT-MANUAL,*PLOT-SUBPANEL,*PLOT-KINDCD_NC,*PLOT-QA_STATUS,*PLOT-CREATED_BY,*PLOT-CREATED_DATE,*PLOT-CREATED_IN_INSTANCE,*PLOT-MODIFIED_BY,*PLOT-MODIFIED_DATE,*PLOT-MODIFIED_IN_INSTANCE,*PLOT-MICROPLOT_LOC,*PLOT-DECLINATION,*PLOT-EMAP_HEX,*PLOT-SAMP_METHOD_CD,*PLOT-SUBP_EXAMINE_CD,*PLOT-MACRO_BREAKPOINT_DIA,*PLOT-INTENSITY,*PLOT-CYCLE,*PLOT-SUBCYCLE,*PLOT-ECO_UNIT_PNW,*PLOT-TOPO_POSITION_PNW,*PLOT-NF_SAMPLING_STATUS_CD,*PLOT-NF_PLOT_STATUS_CD,*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,*PLOT-P2VEG_SAMPLING_STATUS_CD,*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT-INVASIVE_SAMPLING_STATUS_CD,*PLOT-INVASIVE_SPECIMEN_RULE_CD,*PLOT-DESIGNCD_P2A,authorEventCode,*HABTYPCD,*HABTYP_PUB_CD,*COND-row_num,*COND-CN,*COND-PLT_CN,*COND-COND_STATUS_CD,*COND-COND_NONSAMPLE_REASN_CD,*COND-RESERVCD,*COND-OWNCD,*COND-OWNGRPCD,*COND-FORINDCD,*COND-ADFORCD,*COND-FORTYPCD,*COND-FLDTYPCD,*COND-MAPDEN,*COND-STDAGE,*COND-STDSZCD,*COND-FLDSZCD,*COND-SITECLCD,*COND-SICOND,*COND-SIBASE,*COND-SISP,*COND-STDORGCD,*COND-STDORGSP,*COND-PROP_BASIS,*COND-CONDPROP_UNADJ,*COND-MICRPROP_UNADJ,*COND-SUBPPROP_UNADJ,*COND-MACRPROP_UNADJ,slopeGradient,slopeAspect,*COND-PHYSCLCD,*COND-GSSTKCD,*COND-ALSTKCD,*COND-DSTRBCD1,*COND-DSTRBYR1,*COND-DSTRBCD2,*COND-DSTRBYR2,*COND-DSTRBCD3,*COND-DSTRBYR3,*COND-TRTCD1,*COND-TRTYR1,*COND-TRTCD2,*COND-TRTYR2,*COND-TRTCD3,*COND-TRTYR3,*COND-PRESNFCD,*COND-BALIVE,*COND-FLDAGE,*COND-ALSTK,*COND-GSSTK,*COND-FORTYPCDCALC,*COND-HABTYPCD1_DESCR_PUB_CD,*COND-HABTYPCD2,*COND-HABTYPCD2_PUB_CD,*COND-HABTYPCD2_DESCR_PUB_CD,*COND-MIXEDCONFCD,*COND-VOL_LOC_GRP,*COND-SITECLCDEST,*COND-SITETREE_TREE,*COND-SITECL_METHOD,*COND-CARBON_DOWN_DEAD,*COND-CARBON_LITTER,*COND-CARBON_SOIL_ORG,*COND-CARBON_STANDING_DEAD,*COND-CARBON_UNDERSTORY_AG,*COND-CARBON_UNDERSTORY_BG,*COND-CREATED_BY,*COND-CREATED_DATE,*COND-CREATED_IN_INSTANCE,*COND-MODIFIED_BY,*COND-MODIFIED_DATE,*COND-MODIFIED_IN_INSTANCE,*COND-CYCLE,*COND-SUBCYCLE,*COND-SOIL_ROOTING_DEPTH_PNW,*COND-GROUND_LAND_CLASS_PNW,*COND-PLANT_STOCKABILITY_FACTOR_PNW,*COND-STND_COND_CD_PNWRS,*COND-STND_STRUC_CD_PNWRS,*COND-STUMP_CD_PNWRS,*COND-FIRE_SRS,*COND-GRAZING_SRS,*COND-HARVEST_TYPE1_SRS,*COND-HARVEST_TYPE2_SRS,*COND-HARVEST_TYPE3_SRS,*COND-LAND_USE_SRS,*COND-OPERABILITY_SRS,*COND-STAND_STRUCTURE_SRS,*COND-NF_COND_STATUS_CD,*COND-NF_COND_NONSAMPLE_REASN_CD,*COND-CANOPY_CVR_SAMPLE_METHOD_CD,*COND-LIVE_CANOPY_CVR_PCT,*COND-LIVE_MISSING_CANOPY_CVR_PCT,*COND-NBR_LIVE_STEMS,*COND-OWNSUBCD,*COND-INDUSTRIALCD_FIADB,*COND-RESERVCD_FLD,*COND-ADMIN_WITHDRAWN_CD,oldGrowth,cultivated,*REF_HABTYP_DESCRIPTION-row_num,communityID,*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,communityName,*REF_HABTYP_DESCRIPTION-VALID,*REF_HABTYP_DESCRIPTION-CREATED_BY,*REF_HABTYP_DESCRIPTION-CREATED_DATE,*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-MODIFIED_BY,*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,subplot,*SUBPLOT-row_num,subplotID,*SUBPLOT-PLT_CN,*SUBPLOT-PREV_SBP_CN,*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,*PLANT_SYMBOL,*SPCD,*TREE-row_num,individualObservationID,*TREE-PLT_CN,*TREE-PREV_TRE_CN,individualCode,*TREE-AZIMUTH,*TREE-DIST,*TREE-PREVCOND,*TREE-STATUSCD,*TREE-SPGRPCD,diameterBreastHeight_in,*TREE-DIAHTCD,height_ft,*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,*REF_SPECIES-row_num,*REF_SPECIES-COMMON_NAME,*REF_SPECIES-GENUS,*REF_SPECIES-SPECIES,*REF_SPECIES-VARIETY,*REF_SPECIES-SUBSPECIES,*REF_SPECIES-E_SPGRPCD,*REF_SPECIES-W_SPGRPCD,*REF_SPECIES-C_SPGRPCD,*REF_SPECIES-P_SPGRPCD,*REF_SPECIES-MAJOR_SPGRPCD,*REF_SPECIES-STOCKING_SPGRPCD,*REF_SPECIES-FOREST_TYPE_SPGRPCD,*REF_SPECIES-EXISTS_IN_NCRS,*REF_SPECIES-EXISTS_IN_NERS,*REF_SPECIES-EXISTS_IN_PNWRS,*REF_SPECIES-EXISTS_IN_RMRS,*REF_SPECIES-EXISTS_IN_SRS,*REF_SPECIES-SITETREE,*REF_SPECIES-SFTWD_HRDWD,*REF_SPECIES-ST_EXISTS_IN_NCRS,*REF_SPECIES-ST_EXISTS_IN_NERS,*REF_SPECIES-ST_EXISTS_IN_PNWRS,*REF_SPECIES-ST_EXISTS_IN_RMRS,*REF_SPECIES-ST_EXISTS_IN_SRS,*REF_SPECIES-CORE,*REF_SPECIES-EAST,*REF_SPECIES-WEST,*REF_SPECIES-CARIBBEAN,*REF_SPECIES-PACIFIC,*REF_SPECIES-WOODLAND,*REF_SPECIES-MANUAL_START,*REF_SPECIES-MANUAL_END,*REF_SPECIES-JENKINS_SPGRPCD,*REF_SPECIES-JENKINS_TOTAL_B1,*REF_SPECIES-JENKINS_TOTAL_B2,*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1,*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2,*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1,*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2,*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1,*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2,*REF_SPECIES-JENKINS_ROOT_RATIO_B1,*REF_SPECIES-JENKINS_ROOT_RATIO_B2,*REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT,*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT,*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT,*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES-MC_PCT_GREEN_BARK,*REF_SPECIES-MC_PCT_GREEN_BARK_CIT,*REF_SPECIES-MC_PCT_GREEN_WOOD,*REF_SPECIES-MC_PCT_GREEN_WOOD_CIT,*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT,*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT,*REF_SPECIES-BARK_VOL_PCT,*REF_SPECIES-BARK_VOL_PCT_CIT,*REF_SPECIES-RAILE_STUMP_DOB_B1,*REF_SPECIES-RAILE_STUMP_DIB_B1,*REF_SPECIES-RAILE_STUMP_DIB_B2,*REF_SPECIES-CWD_DECAY_RATIO1,*REF_SPECIES-CWD_DECAY_RATIO2,*REF_SPECIES-CWD_DECAY_RATIO3,*REF_SPECIES-CWD_DECAY_RATIO4,*REF_SPECIES-CWD_DECAY_RATIO5,*REF_SPECIES-DWM_CARBON_RATIO,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO1,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO2,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO3,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO4,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO5,*REF_SPECIES-CREATED_BY,*REF_SPECIES-CREATED_DATE,*REF_SPECIES-CREATED_IN_INSTANCE,*REF_SPECIES-MODIFIED_BY,*REF_SPECIES-MODIFIED_DATE,*REF_SPECIES-MODIFIED_IN_INSTANCE,PLANT_SYMBOL_TYPE,*REF_PLANT_DICTIONARY-row_num,*REF_PLANT_DICTIONARY-CN,*PLANT_SYMBOL_TYPE,taxonName,*REF_PLANT_DICTIONARY-NEW_SYMBOL,*REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME,vernacularName,*REF_PLANT_DICTIONARY-CATEGORY,family,taxonGrowthForm,*REF_PLANT_DICTIONARY-DURATION,*REF_PLANT_DICTIONARY-US_NATIVITY,*REF_PLANT_DICTIONARY-STATE_DISTRIBUTION,*REF_PLANT_DICTIONARY-STATE_AND_PROVINCE,scientificName,*GENERA_BINOMIAL_AUTHOR,*TRINOMIAL_AUTHOR,*QUADRINOMIAL_AUTHOR,*XGENUS,genus,*XSPECIES,specificEpithet,*SSP_PREFIX,*XSUBSPECIES,subspecies,*VAR_PREFIX,*XVARIETY,variety,*SUBVAR,*SUBVARIETY,*F_PREFIX,forma,*REF_PLANT_DICTIONARY-NOTES,*REF_PLANT_DICTIONARY-CREATED_BY,*REF_PLANT_DICTIONARY-CREATED_DATE,*REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE,*REF_PLANT_DICTIONARY-MODIFIED_BY,*REF_PLANT_DICTIONARY-MODIFIED_DATE,*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE
|
|
1 |
occurrence_all-row_num,*STATECD,*REF_RESEARCH_STATION-row_num,*REF_RESEARCH_STATION-RSCD,*REF_RESEARCH_STATION-RS,stateProvince,*REF_RESEARCH_STATION-STATE_ABBR,*REF_RESEARCH_STATION-CREATED_BY,*REF_RESEARCH_STATION-CREATED_DATE,*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,*REF_RESEARCH_STATION-MODIFIED_BY,*REF_RESEARCH_STATION-MODIFIED_DATE,*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,*UNITCD,*REF_UNIT-row_num,*REF_UNIT-MEANING,*REF_UNIT-CREATED_BY,*REF_UNIT-CREATED_DATE,*REF_UNIT-CREATED_IN_INSTANCE,*REF_UNIT-MODIFIED_BY,*REF_UNIT-MODIFIED_DATE,*REF_UNIT-MODIFIED_IN_INSTANCE,*COUNTYCD,*COUNTY-row_num,county,*COUNTY-CN,*COUNTY-CREATED_BY,*COUNTY-CREATED_DATE,*COUNTY-CREATED_IN_INSTANCE,*COUNTY-MODIFIED_BY,*COUNTY-MODIFIED_DATE,*COUNTY-MODIFIED_IN_INSTANCE,*INVYR,locationName,*PLOT-row_num,locationID,*PLOT-SRV_CN,*PLOT-CTY_CN,*PLOT-PREV_PLT_CN,*PLOT-PLOT_STATUS_CD,*PLOT-PLOT_NONSAMPLE_REASN_CD,year,month,day,*PLOT-REMPER,*PLOT-KINDCD,*PLOT-DESIGNCD,*PLOT-RDDISTCD,*PLOT-WATERCD,decimalLatitude,decimalLongitude,elevation_ft,*PLOT-GROW_TYP_CD,*PLOT-MORT_TYP_CD,*PLOT-P2PANEL,*PLOT-P3PANEL,*PLOT-ECOSUBCD,*PLOT-CONGCD,*PLOT-MANUAL,*PLOT-SUBPANEL,*PLOT-KINDCD_NC,*PLOT-QA_STATUS,*PLOT-CREATED_BY,*PLOT-CREATED_DATE,*PLOT-CREATED_IN_INSTANCE,*PLOT-MODIFIED_BY,*PLOT-MODIFIED_DATE,*PLOT-MODIFIED_IN_INSTANCE,*PLOT-MICROPLOT_LOC,*PLOT-DECLINATION,*PLOT-EMAP_HEX,*PLOT-SAMP_METHOD_CD,*PLOT-SUBP_EXAMINE_CD,*PLOT-MACRO_BREAKPOINT_DIA,*PLOT-INTENSITY,*PLOT-CYCLE,*PLOT-SUBCYCLE,*PLOT-ECO_UNIT_PNW,*PLOT-TOPO_POSITION_PNW,*PLOT-NF_SAMPLING_STATUS_CD,*PLOT-NF_PLOT_STATUS_CD,*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,*PLOT-P2VEG_SAMPLING_STATUS_CD,*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT-INVASIVE_SAMPLING_STATUS_CD,*PLOT-INVASIVE_SPECIMEN_RULE_CD,*PLOT-DESIGNCD_P2A,authorEventCode,*HABTYPCD,*HABTYP_PUB_CD,*COND-row_num,*COND-CN,*COND-PLT_CN,*COND-COND_STATUS_CD,*COND-COND_NONSAMPLE_REASN_CD,*COND-RESERVCD,*COND-OWNCD,*COND-OWNGRPCD,*COND-FORINDCD,*COND-ADFORCD,*COND-FORTYPCD,*COND-FLDTYPCD,*COND-MAPDEN,*COND-STDAGE,*COND-STDSZCD,*COND-FLDSZCD,*COND-SITECLCD,*COND-SICOND,*COND-SIBASE,*COND-SISP,*COND-STDORGCD,*COND-STDORGSP,*COND-PROP_BASIS,*COND-CONDPROP_UNADJ,*COND-MICRPROP_UNADJ,*COND-SUBPPROP_UNADJ,*COND-MACRPROP_UNADJ,slopeGradient,slopeAspect,*COND-PHYSCLCD,*COND-GSSTKCD,*COND-ALSTKCD,*COND-DSTRBCD1,*COND-DSTRBYR1,*COND-DSTRBCD2,*COND-DSTRBYR2,*COND-DSTRBCD3,*COND-DSTRBYR3,*COND-TRTCD1,*COND-TRTYR1,*COND-TRTCD2,*COND-TRTYR2,*COND-TRTCD3,*COND-TRTYR3,*COND-PRESNFCD,*COND-BALIVE,*COND-FLDAGE,*COND-ALSTK,*COND-GSSTK,*COND-FORTYPCDCALC,*COND-HABTYPCD1_DESCR_PUB_CD,*COND-HABTYPCD2,*COND-HABTYPCD2_PUB_CD,*COND-HABTYPCD2_DESCR_PUB_CD,*COND-MIXEDCONFCD,*COND-VOL_LOC_GRP,*COND-SITECLCDEST,*COND-SITETREE_TREE,*COND-SITECL_METHOD,*COND-CARBON_DOWN_DEAD,*COND-CARBON_LITTER,*COND-CARBON_SOIL_ORG,*COND-CARBON_STANDING_DEAD,*COND-CARBON_UNDERSTORY_AG,*COND-CARBON_UNDERSTORY_BG,*COND-CREATED_BY,*COND-CREATED_DATE,*COND-CREATED_IN_INSTANCE,*COND-MODIFIED_BY,*COND-MODIFIED_DATE,*COND-MODIFIED_IN_INSTANCE,*COND-CYCLE,*COND-SUBCYCLE,*COND-SOIL_ROOTING_DEPTH_PNW,*COND-GROUND_LAND_CLASS_PNW,*COND-PLANT_STOCKABILITY_FACTOR_PNW,*COND-STND_COND_CD_PNWRS,*COND-STND_STRUC_CD_PNWRS,*COND-STUMP_CD_PNWRS,*COND-FIRE_SRS,*COND-GRAZING_SRS,*COND-HARVEST_TYPE1_SRS,*COND-HARVEST_TYPE2_SRS,*COND-HARVEST_TYPE3_SRS,*COND-LAND_USE_SRS,*COND-OPERABILITY_SRS,*COND-STAND_STRUCTURE_SRS,*COND-NF_COND_STATUS_CD,*COND-NF_COND_NONSAMPLE_REASN_CD,*COND-CANOPY_CVR_SAMPLE_METHOD_CD,*COND-LIVE_CANOPY_CVR_PCT,*COND-LIVE_MISSING_CANOPY_CVR_PCT,*COND-NBR_LIVE_STEMS,*COND-OWNSUBCD,*COND-INDUSTRIALCD_FIADB,*COND-RESERVCD_FLD,*COND-ADMIN_WITHDRAWN_CD,oldGrowth,cultivated,*REF_HABTYP_DESCRIPTION-row_num,communityID,*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,communityName,*REF_HABTYP_DESCRIPTION-VALID,*REF_HABTYP_DESCRIPTION-CREATED_BY,*REF_HABTYP_DESCRIPTION-CREATED_DATE,*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-MODIFIED_BY,*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,subplot,*SUBPLOT-row_num,subplotID,*SUBPLOT-PLT_CN,*SUBPLOT-PREV_SBP_CN,*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,*PLANT_SYMBOL,*PLANT_SYMBOL_TYPE,*SPCD,*TREE-row_num,individualObservationID,*TREE-PLT_CN,*TREE-PREV_TRE_CN,individualCode,*TREE-AZIMUTH,*TREE-DIST,*TREE-PREVCOND,*TREE-STATUSCD,*TREE-SPGRPCD,diameterBreastHeight_in,*TREE-DIAHTCD,height_ft,*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,*REF_SPECIES-row_num,*REF_SPECIES-COMMON_NAME,*REF_SPECIES-GENUS,*REF_SPECIES-SPECIES,*REF_SPECIES-VARIETY,*REF_SPECIES-SUBSPECIES,*REF_SPECIES-E_SPGRPCD,*REF_SPECIES-W_SPGRPCD,*REF_SPECIES-C_SPGRPCD,*REF_SPECIES-P_SPGRPCD,*REF_SPECIES-MAJOR_SPGRPCD,*REF_SPECIES-STOCKING_SPGRPCD,*REF_SPECIES-FOREST_TYPE_SPGRPCD,*REF_SPECIES-EXISTS_IN_NCRS,*REF_SPECIES-EXISTS_IN_NERS,*REF_SPECIES-EXISTS_IN_PNWRS,*REF_SPECIES-EXISTS_IN_RMRS,*REF_SPECIES-EXISTS_IN_SRS,*REF_SPECIES-SITETREE,*REF_SPECIES-SFTWD_HRDWD,*REF_SPECIES-ST_EXISTS_IN_NCRS,*REF_SPECIES-ST_EXISTS_IN_NERS,*REF_SPECIES-ST_EXISTS_IN_PNWRS,*REF_SPECIES-ST_EXISTS_IN_RMRS,*REF_SPECIES-ST_EXISTS_IN_SRS,*REF_SPECIES-CORE,*REF_SPECIES-EAST,*REF_SPECIES-WEST,*REF_SPECIES-CARIBBEAN,*REF_SPECIES-PACIFIC,*REF_SPECIES-WOODLAND,*REF_SPECIES-MANUAL_START,*REF_SPECIES-MANUAL_END,*REF_SPECIES-JENKINS_SPGRPCD,*REF_SPECIES-JENKINS_TOTAL_B1,*REF_SPECIES-JENKINS_TOTAL_B2,*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1,*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2,*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1,*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2,*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1,*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2,*REF_SPECIES-JENKINS_ROOT_RATIO_B1,*REF_SPECIES-JENKINS_ROOT_RATIO_B2,*REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT,*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT,*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT,*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES-MC_PCT_GREEN_BARK,*REF_SPECIES-MC_PCT_GREEN_BARK_CIT,*REF_SPECIES-MC_PCT_GREEN_WOOD,*REF_SPECIES-MC_PCT_GREEN_WOOD_CIT,*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT,*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT,*REF_SPECIES-BARK_VOL_PCT,*REF_SPECIES-BARK_VOL_PCT_CIT,*REF_SPECIES-RAILE_STUMP_DOB_B1,*REF_SPECIES-RAILE_STUMP_DIB_B1,*REF_SPECIES-RAILE_STUMP_DIB_B2,*REF_SPECIES-CWD_DECAY_RATIO1,*REF_SPECIES-CWD_DECAY_RATIO2,*REF_SPECIES-CWD_DECAY_RATIO3,*REF_SPECIES-CWD_DECAY_RATIO4,*REF_SPECIES-CWD_DECAY_RATIO5,*REF_SPECIES-DWM_CARBON_RATIO,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO1,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO2,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO3,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO4,*REF_SPECIES-STANDING_DEAD_DECAY_RATIO5,*REF_SPECIES-CREATED_BY,*REF_SPECIES-CREATED_DATE,*REF_SPECIES-CREATED_IN_INSTANCE,*REF_SPECIES-MODIFIED_BY,*REF_SPECIES-MODIFIED_DATE,*REF_SPECIES-MODIFIED_IN_INSTANCE,*REF_PLANT_DICTIONARY-row_num,*REF_PLANT_DICTIONARY-CN,taxonName,*REF_PLANT_DICTIONARY-NEW_SYMBOL,*REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME,vernacularName,*REF_PLANT_DICTIONARY-CATEGORY,family,taxonGrowthForm,*REF_PLANT_DICTIONARY-DURATION,*REF_PLANT_DICTIONARY-US_NATIVITY,*REF_PLANT_DICTIONARY-STATE_DISTRIBUTION,*REF_PLANT_DICTIONARY-STATE_AND_PROVINCE,scientificName,*GENERA_BINOMIAL_AUTHOR,*TRINOMIAL_AUTHOR,*QUADRINOMIAL_AUTHOR,*XGENUS,genus,*XSPECIES,specificEpithet,*SSP_PREFIX,*XSUBSPECIES,subspecies,*VAR_PREFIX,*XVARIETY,variety,*SUBVAR,*SUBVARIETY,*F_PREFIX,forma,*REF_PLANT_DICTIONARY-NOTES,*REF_PLANT_DICTIONARY-CREATED_BY,*REF_PLANT_DICTIONARY-CREATED_DATE,*REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE,*REF_PLANT_DICTIONARY-MODIFIED_BY,*REF_PLANT_DICTIONARY-MODIFIED_DATE,*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE
|
bugfix: inputs/FIA/REF_SPECIES/import: PLANT_SYMBOL_TYPE: prepended * since it's a datasource column, and needs to match up with *PLANT_SYMBOL_TYPE in other table for joins