| 1 |
|
occurrence_all--row_num,*STATECD,*UNITCD,*COUNTYCD,*INVYR,locationName,*HABTYPCD,*HABTYP_PUB_CD,authorEventCode,subplot,*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,*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,*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,*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,*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,*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,*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
|
|
1 |
row_num,*STATECD,*UNITCD,*COUNTYCD,*INVYR,locationName,*HABTYPCD,*HABTYP_PUB_CD,authorEventCode,subplot,*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,*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,*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,*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,*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,*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,*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
|
inputs/FIA/occurrence_all/postprocess.sql: renamed occurrence_all--row_num to just row_num because this is for the entire view, rather than a specific table in it, and thus does not need a disambiguating table prefix. this also avoids embedding the view name in its own columns.