Revision 10930
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/FIA/occurrence_all/header.csv | ||
|---|---|---|
| 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 |
|
| 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 |
|
| inputs/FIA/occurrence_all/postprocess.sql | ||
|---|---|---|
| 4 | 4 |
SELECT "*TREE-row_num" AS "occurrence_all-row_num", * |
| 5 | 5 |
/* directional joins ensure that the PostgreSQL query planner always joins |
| 6 | 6 |
starting with the TREE table */ |
| 7 |
FROM ("REF_RESEARCH_STATION"
|
|
| 8 |
NATURAL RIGHT JOIN ("REF_UNIT"
|
|
| 9 |
NATURAL RIGHT JOIN ("COUNTY"
|
|
| 10 |
NATURAL RIGHT JOIN ("PLOT"
|
|
| 11 |
NATURAL RIGHT JOIN ("COND"
|
|
| 12 |
NATURAL LEFT JOIN "REF_HABTYP_DESCRIPTION" |
|
| 13 |
NATURAL RIGHT JOIN ("SUBPLOT"
|
|
| 14 |
NATURAL RIGHT JOIN ("TREE"
|
|
| 15 |
NATURAL LEFT JOIN "REF_SPECIES" |
|
| 16 |
NATURAL LEFT JOIN "REF_PLANT_DICTIONARY" |
|
| 17 |
))))))) |
|
| 7 |
FROM "TREE" |
|
| 8 |
NATURAL LEFT JOIN "REF_SPECIES" |
|
| 9 |
NATURAL LEFT JOIN "REF_PLANT_DICTIONARY" |
|
| 10 |
NATURAL LEFT JOIN "SUBPLOT" |
|
| 11 |
NATURAL LEFT JOIN "COND" |
|
| 12 |
NATURAL LEFT JOIN "REF_HABTYP_DESCRIPTION" |
|
| 13 |
NATURAL LEFT JOIN "PLOT" |
|
| 14 |
NATURAL LEFT JOIN "COUNTY" |
|
| 15 |
NATURAL LEFT JOIN "REF_UNIT" |
|
| 16 |
NATURAL LEFT JOIN "REF_RESEARCH_STATION" |
|
| 18 | 17 |
$$); |
| 19 | 18 |
|
| 20 | 19 |
SELECT mk_subset_by_row_num_func('"occurrence_all"', 'occurrence_all-row_num');
|
| inputs/FIA/occurrence_all/map.csv | ||
|---|---|---|
| 1 | 1 |
FIA,VegCore,Filter,Comments |
| 2 | 2 |
occurrence_all-row_num,occurrence_all-row_num,, |
| 3 | 3 |
*STATECD,*STATECD,, |
| 4 |
*REF_RESEARCH_STATION-row_num,*REF_RESEARCH_STATION-row_num,, |
|
| 5 |
*REF_RESEARCH_STATION-RSCD,*REF_RESEARCH_STATION-RSCD,, |
|
| 6 |
*REF_RESEARCH_STATION-RS,*REF_RESEARCH_STATION-RS,, |
|
| 7 |
stateProvince,stateProvince,, |
|
| 8 |
*REF_RESEARCH_STATION-STATE_ABBR,*REF_RESEARCH_STATION-STATE_ABBR,, |
|
| 9 |
*REF_RESEARCH_STATION-CREATED_BY,*REF_RESEARCH_STATION-CREATED_BY,, |
|
| 10 |
*REF_RESEARCH_STATION-CREATED_DATE,*REF_RESEARCH_STATION-CREATED_DATE,, |
|
| 11 |
*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,, |
|
| 12 |
*REF_RESEARCH_STATION-MODIFIED_BY,*REF_RESEARCH_STATION-MODIFIED_BY,, |
|
| 13 |
*REF_RESEARCH_STATION-MODIFIED_DATE,*REF_RESEARCH_STATION-MODIFIED_DATE,, |
|
| 14 |
*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,, |
|
| 15 | 4 |
*UNITCD,*UNITCD,, |
| 16 |
*REF_UNIT-row_num,*REF_UNIT-row_num,, |
|
| 17 |
*REF_UNIT-MEANING,*REF_UNIT-MEANING,, |
|
| 18 |
*REF_UNIT-CREATED_BY,*REF_UNIT-CREATED_BY,, |
|
| 19 |
*REF_UNIT-CREATED_DATE,*REF_UNIT-CREATED_DATE,, |
|
| 20 |
*REF_UNIT-CREATED_IN_INSTANCE,*REF_UNIT-CREATED_IN_INSTANCE,, |
|
| 21 |
*REF_UNIT-MODIFIED_BY,*REF_UNIT-MODIFIED_BY,, |
|
| 22 |
*REF_UNIT-MODIFIED_DATE,*REF_UNIT-MODIFIED_DATE,, |
|
| 23 |
*REF_UNIT-MODIFIED_IN_INSTANCE,*REF_UNIT-MODIFIED_IN_INSTANCE,, |
|
| 24 | 5 |
*COUNTYCD,*COUNTYCD,, |
| 25 |
*COUNTY-row_num,*COUNTY-row_num,, |
|
| 26 |
county,county,, |
|
| 27 |
*COUNTY-CN,*COUNTY-CN,, |
|
| 28 |
*COUNTY-CREATED_BY,*COUNTY-CREATED_BY,, |
|
| 29 |
*COUNTY-CREATED_DATE,*COUNTY-CREATED_DATE,, |
|
| 30 |
*COUNTY-CREATED_IN_INSTANCE,*COUNTY-CREATED_IN_INSTANCE,, |
|
| 31 |
*COUNTY-MODIFIED_BY,*COUNTY-MODIFIED_BY,, |
|
| 32 |
*COUNTY-MODIFIED_DATE,*COUNTY-MODIFIED_DATE,, |
|
| 33 |
*COUNTY-MODIFIED_IN_INSTANCE,*COUNTY-MODIFIED_IN_INSTANCE,, |
|
| 34 | 6 |
*INVYR,*INVYR,, |
| 35 | 7 |
locationName,locationName,, |
| 36 |
*PLOT-row_num,*PLOT-row_num,, |
|
| 37 |
locationID,locationID,, |
|
| 38 |
*PLOT-SRV_CN,*PLOT-SRV_CN,, |
|
| 39 |
*PLOT-CTY_CN,*PLOT-CTY_CN,, |
|
| 40 |
*PLOT-PREV_PLT_CN,*PLOT-PREV_PLT_CN,, |
|
| 41 |
*PLOT-PLOT_STATUS_CD,*PLOT-PLOT_STATUS_CD,, |
|
| 42 |
*PLOT-PLOT_NONSAMPLE_REASN_CD,*PLOT-PLOT_NONSAMPLE_REASN_CD,, |
|
| 43 |
year,year,, |
|
| 44 |
month,month,, |
|
| 45 |
day,day,, |
|
| 46 |
*PLOT-REMPER,*PLOT-REMPER,, |
|
| 47 |
*PLOT-KINDCD,*PLOT-KINDCD,, |
|
| 48 |
*PLOT-DESIGNCD,*PLOT-DESIGNCD,, |
|
| 49 |
*PLOT-RDDISTCD,*PLOT-RDDISTCD,, |
|
| 50 |
*PLOT-WATERCD,*PLOT-WATERCD,, |
|
| 51 |
decimalLatitude,decimalLatitude,, |
|
| 52 |
decimalLongitude,decimalLongitude,, |
|
| 53 |
elevation_ft,elevation_ft,, |
|
| 54 |
*PLOT-GROW_TYP_CD,*PLOT-GROW_TYP_CD,, |
|
| 55 |
*PLOT-MORT_TYP_CD,*PLOT-MORT_TYP_CD,, |
|
| 56 |
*PLOT-P2PANEL,*PLOT-P2PANEL,, |
|
| 57 |
*PLOT-P3PANEL,*PLOT-P3PANEL,, |
|
| 58 |
*PLOT-ECOSUBCD,*PLOT-ECOSUBCD,, |
|
| 59 |
*PLOT-CONGCD,*PLOT-CONGCD,, |
|
| 60 |
*PLOT-MANUAL,*PLOT-MANUAL,, |
|
| 61 |
*PLOT-SUBPANEL,*PLOT-SUBPANEL,, |
|
| 62 |
*PLOT-KINDCD_NC,*PLOT-KINDCD_NC,, |
|
| 63 |
*PLOT-QA_STATUS,*PLOT-QA_STATUS,, |
|
| 64 |
*PLOT-CREATED_BY,*PLOT-CREATED_BY,, |
|
| 65 |
*PLOT-CREATED_DATE,*PLOT-CREATED_DATE,, |
|
| 66 |
*PLOT-CREATED_IN_INSTANCE,*PLOT-CREATED_IN_INSTANCE,, |
|
| 67 |
*PLOT-MODIFIED_BY,*PLOT-MODIFIED_BY,, |
|
| 68 |
*PLOT-MODIFIED_DATE,*PLOT-MODIFIED_DATE,, |
|
| 69 |
*PLOT-MODIFIED_IN_INSTANCE,*PLOT-MODIFIED_IN_INSTANCE,, |
|
| 70 |
*PLOT-MICROPLOT_LOC,*PLOT-MICROPLOT_LOC,, |
|
| 71 |
*PLOT-DECLINATION,*PLOT-DECLINATION,, |
|
| 72 |
*PLOT-EMAP_HEX,*PLOT-EMAP_HEX,, |
|
| 73 |
*PLOT-SAMP_METHOD_CD,*PLOT-SAMP_METHOD_CD,, |
|
| 74 |
*PLOT-SUBP_EXAMINE_CD,*PLOT-SUBP_EXAMINE_CD,, |
|
| 75 |
*PLOT-MACRO_BREAKPOINT_DIA,*PLOT-MACRO_BREAKPOINT_DIA,, |
|
| 76 |
*PLOT-INTENSITY,*PLOT-INTENSITY,, |
|
| 77 |
*PLOT-CYCLE,*PLOT-CYCLE,, |
|
| 78 |
*PLOT-SUBCYCLE,*PLOT-SUBCYCLE,, |
|
| 79 |
*PLOT-ECO_UNIT_PNW,*PLOT-ECO_UNIT_PNW,, |
|
| 80 |
*PLOT-TOPO_POSITION_PNW,*PLOT-TOPO_POSITION_PNW,, |
|
| 81 |
*PLOT-NF_SAMPLING_STATUS_CD,*PLOT-NF_SAMPLING_STATUS_CD,, |
|
| 82 |
*PLOT-NF_PLOT_STATUS_CD,*PLOT-NF_PLOT_STATUS_CD,, |
|
| 83 |
*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,, |
|
| 84 |
*PLOT-P2VEG_SAMPLING_STATUS_CD,*PLOT-P2VEG_SAMPLING_STATUS_CD,, |
|
| 85 |
*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,, |
|
| 86 |
*PLOT-INVASIVE_SAMPLING_STATUS_CD,*PLOT-INVASIVE_SAMPLING_STATUS_CD,, |
|
| 87 |
*PLOT-INVASIVE_SPECIMEN_RULE_CD,*PLOT-INVASIVE_SPECIMEN_RULE_CD,, |
|
| 88 |
*PLOT-DESIGNCD_P2A,*PLOT-DESIGNCD_P2A,, |
|
| 89 |
authorEventCode,authorEventCode,, |
|
| 90 | 8 |
*HABTYPCD,*HABTYPCD,, |
| 91 | 9 |
*HABTYP_PUB_CD,*HABTYP_PUB_CD,, |
| 92 |
*COND-row_num,*COND-row_num,, |
|
| 93 |
*COND-CN,*COND-CN,, |
|
| 94 |
*COND-PLT_CN,*COND-PLT_CN,, |
|
| 95 |
*COND-COND_STATUS_CD,*COND-COND_STATUS_CD,, |
|
| 96 |
*COND-COND_NONSAMPLE_REASN_CD,*COND-COND_NONSAMPLE_REASN_CD,, |
|
| 97 |
*COND-RESERVCD,*COND-RESERVCD,, |
|
| 98 |
*COND-OWNCD,*COND-OWNCD,, |
|
| 99 |
*COND-OWNGRPCD,*COND-OWNGRPCD,, |
|
| 100 |
*COND-FORINDCD,*COND-FORINDCD,, |
|
| 101 |
*COND-ADFORCD,*COND-ADFORCD,, |
|
| 102 |
*COND-FORTYPCD,*COND-FORTYPCD,, |
|
| 103 |
*COND-FLDTYPCD,*COND-FLDTYPCD,, |
|
| 104 |
*COND-MAPDEN,*COND-MAPDEN,, |
|
| 105 |
*COND-STDAGE,*COND-STDAGE,, |
|
| 106 |
*COND-STDSZCD,*COND-STDSZCD,, |
|
| 107 |
*COND-FLDSZCD,*COND-FLDSZCD,, |
|
| 108 |
*COND-SITECLCD,*COND-SITECLCD,, |
|
| 109 |
*COND-SICOND,*COND-SICOND,, |
|
| 110 |
*COND-SIBASE,*COND-SIBASE,, |
|
| 111 |
*COND-SISP,*COND-SISP,, |
|
| 112 |
*COND-STDORGCD,*COND-STDORGCD,, |
|
| 113 |
*COND-STDORGSP,*COND-STDORGSP,, |
|
| 114 |
*COND-PROP_BASIS,*COND-PROP_BASIS,, |
|
| 115 |
*COND-CONDPROP_UNADJ,*COND-CONDPROP_UNADJ,, |
|
| 116 |
*COND-MICRPROP_UNADJ,*COND-MICRPROP_UNADJ,, |
|
| 117 |
*COND-SUBPPROP_UNADJ,*COND-SUBPPROP_UNADJ,, |
|
| 118 |
*COND-MACRPROP_UNADJ,*COND-MACRPROP_UNADJ,, |
|
| 119 |
slopeGradient,slopeGradient,, |
|
| 120 |
slopeAspect,slopeAspect,, |
|
| 121 |
*COND-PHYSCLCD,*COND-PHYSCLCD,, |
|
| 122 |
*COND-GSSTKCD,*COND-GSSTKCD,, |
|
| 123 |
*COND-ALSTKCD,*COND-ALSTKCD,, |
|
| 124 |
*COND-DSTRBCD1,*COND-DSTRBCD1,, |
|
| 125 |
*COND-DSTRBYR1,*COND-DSTRBYR1,, |
|
| 126 |
*COND-DSTRBCD2,*COND-DSTRBCD2,, |
|
| 127 |
*COND-DSTRBYR2,*COND-DSTRBYR2,, |
|
| 128 |
*COND-DSTRBCD3,*COND-DSTRBCD3,, |
|
| 129 |
*COND-DSTRBYR3,*COND-DSTRBYR3,, |
|
| 130 |
*COND-TRTCD1,*COND-TRTCD1,, |
|
| 131 |
*COND-TRTYR1,*COND-TRTYR1,, |
|
| 132 |
*COND-TRTCD2,*COND-TRTCD2,, |
|
| 133 |
*COND-TRTYR2,*COND-TRTYR2,, |
|
| 134 |
*COND-TRTCD3,*COND-TRTCD3,, |
|
| 135 |
*COND-TRTYR3,*COND-TRTYR3,, |
|
| 136 |
*COND-PRESNFCD,*COND-PRESNFCD,, |
|
| 137 |
*COND-BALIVE,*COND-BALIVE,, |
|
| 138 |
*COND-FLDAGE,*COND-FLDAGE,, |
|
| 139 |
*COND-ALSTK,*COND-ALSTK,, |
|
| 140 |
*COND-GSSTK,*COND-GSSTK,, |
|
| 141 |
*COND-FORTYPCDCALC,*COND-FORTYPCDCALC,, |
|
| 142 |
*COND-HABTYPCD1_DESCR_PUB_CD,*COND-HABTYPCD1_DESCR_PUB_CD,, |
|
| 143 |
*COND-HABTYPCD2,*COND-HABTYPCD2,, |
|
| 144 |
*COND-HABTYPCD2_PUB_CD,*COND-HABTYPCD2_PUB_CD,, |
|
| 145 |
*COND-HABTYPCD2_DESCR_PUB_CD,*COND-HABTYPCD2_DESCR_PUB_CD,, |
|
| 146 |
*COND-MIXEDCONFCD,*COND-MIXEDCONFCD,, |
|
| 147 |
*COND-VOL_LOC_GRP,*COND-VOL_LOC_GRP,, |
|
| 148 |
*COND-SITECLCDEST,*COND-SITECLCDEST,, |
|
| 149 |
*COND-SITETREE_TREE,*COND-SITETREE_TREE,, |
|
| 150 |
*COND-SITECL_METHOD,*COND-SITECL_METHOD,, |
|
| 151 |
*COND-CARBON_DOWN_DEAD,*COND-CARBON_DOWN_DEAD,, |
|
| 152 |
*COND-CARBON_LITTER,*COND-CARBON_LITTER,, |
|
| 153 |
*COND-CARBON_SOIL_ORG,*COND-CARBON_SOIL_ORG,, |
|
| 154 |
*COND-CARBON_STANDING_DEAD,*COND-CARBON_STANDING_DEAD,, |
|
| 155 |
*COND-CARBON_UNDERSTORY_AG,*COND-CARBON_UNDERSTORY_AG,, |
|
| 156 |
*COND-CARBON_UNDERSTORY_BG,*COND-CARBON_UNDERSTORY_BG,, |
|
| 157 |
*COND-CREATED_BY,*COND-CREATED_BY,, |
|
| 158 |
*COND-CREATED_DATE,*COND-CREATED_DATE,, |
|
| 159 |
*COND-CREATED_IN_INSTANCE,*COND-CREATED_IN_INSTANCE,, |
|
| 160 |
*COND-MODIFIED_BY,*COND-MODIFIED_BY,, |
|
| 161 |
*COND-MODIFIED_DATE,*COND-MODIFIED_DATE,, |
|
| 162 |
*COND-MODIFIED_IN_INSTANCE,*COND-MODIFIED_IN_INSTANCE,, |
|
| 163 |
*COND-CYCLE,*COND-CYCLE,, |
|
| 164 |
*COND-SUBCYCLE,*COND-SUBCYCLE,, |
|
| 165 |
*COND-SOIL_ROOTING_DEPTH_PNW,*COND-SOIL_ROOTING_DEPTH_PNW,, |
|
| 166 |
*COND-GROUND_LAND_CLASS_PNW,*COND-GROUND_LAND_CLASS_PNW,, |
|
| 167 |
*COND-PLANT_STOCKABILITY_FACTOR_PNW,*COND-PLANT_STOCKABILITY_FACTOR_PNW,, |
|
| 168 |
*COND-STND_COND_CD_PNWRS,*COND-STND_COND_CD_PNWRS,, |
|
| 169 |
*COND-STND_STRUC_CD_PNWRS,*COND-STND_STRUC_CD_PNWRS,, |
|
| 170 |
*COND-STUMP_CD_PNWRS,*COND-STUMP_CD_PNWRS,, |
|
| 171 |
*COND-FIRE_SRS,*COND-FIRE_SRS,, |
|
| 172 |
*COND-GRAZING_SRS,*COND-GRAZING_SRS,, |
|
| 173 |
*COND-HARVEST_TYPE1_SRS,*COND-HARVEST_TYPE1_SRS,, |
|
| 174 |
*COND-HARVEST_TYPE2_SRS,*COND-HARVEST_TYPE2_SRS,, |
|
| 175 |
*COND-HARVEST_TYPE3_SRS,*COND-HARVEST_TYPE3_SRS,, |
|
| 176 |
*COND-LAND_USE_SRS,*COND-LAND_USE_SRS,, |
|
| 177 |
*COND-OPERABILITY_SRS,*COND-OPERABILITY_SRS,, |
|
| 178 |
*COND-STAND_STRUCTURE_SRS,*COND-STAND_STRUCTURE_SRS,, |
|
| 179 |
*COND-NF_COND_STATUS_CD,*COND-NF_COND_STATUS_CD,, |
|
| 180 |
*COND-NF_COND_NONSAMPLE_REASN_CD,*COND-NF_COND_NONSAMPLE_REASN_CD,, |
|
| 181 |
*COND-CANOPY_CVR_SAMPLE_METHOD_CD,*COND-CANOPY_CVR_SAMPLE_METHOD_CD,, |
|
| 182 |
*COND-LIVE_CANOPY_CVR_PCT,*COND-LIVE_CANOPY_CVR_PCT,, |
|
| 183 |
*COND-LIVE_MISSING_CANOPY_CVR_PCT,*COND-LIVE_MISSING_CANOPY_CVR_PCT,, |
|
| 184 |
*COND-NBR_LIVE_STEMS,*COND-NBR_LIVE_STEMS,, |
|
| 185 |
*COND-OWNSUBCD,*COND-OWNSUBCD,, |
|
| 186 |
*COND-INDUSTRIALCD_FIADB,*COND-INDUSTRIALCD_FIADB,, |
|
| 187 |
*COND-RESERVCD_FLD,*COND-RESERVCD_FLD,, |
|
| 188 |
*COND-ADMIN_WITHDRAWN_CD,*COND-ADMIN_WITHDRAWN_CD,, |
|
| 189 |
oldGrowth,oldGrowth,, |
|
| 190 |
cultivated,cultivated,, |
|
| 191 |
*REF_HABTYP_DESCRIPTION-row_num,*REF_HABTYP_DESCRIPTION-row_num,, |
|
| 192 |
communityID,communityID,, |
|
| 193 |
*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,, |
|
| 194 |
communityName,communityName,, |
|
| 195 |
*REF_HABTYP_DESCRIPTION-VALID,*REF_HABTYP_DESCRIPTION-VALID,, |
|
| 196 |
*REF_HABTYP_DESCRIPTION-CREATED_BY,*REF_HABTYP_DESCRIPTION-CREATED_BY,, |
|
| 197 |
*REF_HABTYP_DESCRIPTION-CREATED_DATE,*REF_HABTYP_DESCRIPTION-CREATED_DATE,, |
|
| 198 |
*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,, |
|
| 199 |
*REF_HABTYP_DESCRIPTION-MODIFIED_BY,*REF_HABTYP_DESCRIPTION-MODIFIED_BY,, |
|
| 200 |
*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,, |
|
| 201 |
*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,, |
|
| 10 |
authorEventCode,authorEventCode,, |
|
| 202 | 11 |
subplot,subplot,, |
| 203 |
*SUBPLOT-row_num,*SUBPLOT-row_num,, |
|
| 204 |
subplotID,subplotID,, |
|
| 205 |
*SUBPLOT-PLT_CN,*SUBPLOT-PLT_CN,, |
|
| 206 |
*SUBPLOT-PREV_SBP_CN,*SUBPLOT-PREV_SBP_CN,, |
|
| 207 |
*SUBPLOT-SUBP_STATUS_CD,*SUBPLOT-SUBP_STATUS_CD,, |
|
| 208 |
*SUBPLOT-POINT_NONSAMPLE_REASN_CD,*SUBPLOT-POINT_NONSAMPLE_REASN_CD,, |
|
| 209 |
*SUBPLOT-MICRCOND,*SUBPLOT-MICRCOND,, |
|
| 210 |
*SUBPLOT-SUBPCOND,*SUBPLOT-SUBPCOND,, |
|
| 211 |
*SUBPLOT-MACRCOND,*SUBPLOT-MACRCOND,, |
|
| 212 |
*SUBPLOT-CONDLIST,*SUBPLOT-CONDLIST,, |
|
| 213 |
*SUBPLOT-SLOPE,*SUBPLOT-SLOPE,, |
|
| 214 |
*SUBPLOT-ASPECT,*SUBPLOT-ASPECT,, |
|
| 215 |
*SUBPLOT-WATERDEP,*SUBPLOT-WATERDEP,, |
|
| 216 |
*SUBPLOT-P2A_GRM_FLG,*SUBPLOT-P2A_GRM_FLG,, |
|
| 217 |
*SUBPLOT-CREATED_BY,*SUBPLOT-CREATED_BY,, |
|
| 218 |
*SUBPLOT-CREATED_DATE,*SUBPLOT-CREATED_DATE,, |
|
| 219 |
*SUBPLOT-CREATED_IN_INSTANCE,*SUBPLOT-CREATED_IN_INSTANCE,, |
|
| 220 |
*SUBPLOT-MODIFIED_BY,*SUBPLOT-MODIFIED_BY,, |
|
| 221 |
*SUBPLOT-MODIFIED_DATE,*SUBPLOT-MODIFIED_DATE,, |
|
| 222 |
*SUBPLOT-MODIFIED_IN_INSTANCE,*SUBPLOT-MODIFIED_IN_INSTANCE,, |
|
| 223 |
*SUBPLOT-CYCLE,*SUBPLOT-CYCLE,, |
|
| 224 |
*SUBPLOT-SUBCYCLE,*SUBPLOT-SUBCYCLE,, |
|
| 225 |
*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,, |
|
| 226 |
*SUBPLOT-NF_SUBP_STATUS_CD,*SUBPLOT-NF_SUBP_STATUS_CD,, |
|
| 227 |
*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,, |
|
| 228 |
*SUBPLOT-P2VEG_SUBP_STATUS_CD,*SUBPLOT-P2VEG_SUBP_STATUS_CD,, |
|
| 229 |
*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,, |
|
| 230 |
*SUBPLOT-INVASIVE_SUBP_STATUS_CD,*SUBPLOT-INVASIVE_SUBP_STATUS_CD,, |
|
| 231 |
*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,, |
|
| 232 | 12 |
*PLANT_SYMBOL,*PLANT_SYMBOL,, |
| 233 | 13 |
*PLANT_SYMBOL_TYPE,*PLANT_SYMBOL_TYPE,, |
| 234 | 14 |
*SPCD,*SPCD,, |
| ... | ... | |
| 484 | 264 |
*REF_PLANT_DICTIONARY-MODIFIED_BY,*REF_PLANT_DICTIONARY-MODIFIED_BY,, |
| 485 | 265 |
*REF_PLANT_DICTIONARY-MODIFIED_DATE,*REF_PLANT_DICTIONARY-MODIFIED_DATE,, |
| 486 | 266 |
*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE,*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE,, |
| 267 |
*SUBPLOT-row_num,*SUBPLOT-row_num,, |
|
| 268 |
subplotID,subplotID,, |
|
| 269 |
*SUBPLOT-PLT_CN,*SUBPLOT-PLT_CN,, |
|
| 270 |
*SUBPLOT-PREV_SBP_CN,*SUBPLOT-PREV_SBP_CN,, |
|
| 271 |
*SUBPLOT-SUBP_STATUS_CD,*SUBPLOT-SUBP_STATUS_CD,, |
|
| 272 |
*SUBPLOT-POINT_NONSAMPLE_REASN_CD,*SUBPLOT-POINT_NONSAMPLE_REASN_CD,, |
|
| 273 |
*SUBPLOT-MICRCOND,*SUBPLOT-MICRCOND,, |
|
| 274 |
*SUBPLOT-SUBPCOND,*SUBPLOT-SUBPCOND,, |
|
| 275 |
*SUBPLOT-MACRCOND,*SUBPLOT-MACRCOND,, |
|
| 276 |
*SUBPLOT-CONDLIST,*SUBPLOT-CONDLIST,, |
|
| 277 |
*SUBPLOT-SLOPE,*SUBPLOT-SLOPE,, |
|
| 278 |
*SUBPLOT-ASPECT,*SUBPLOT-ASPECT,, |
|
| 279 |
*SUBPLOT-WATERDEP,*SUBPLOT-WATERDEP,, |
|
| 280 |
*SUBPLOT-P2A_GRM_FLG,*SUBPLOT-P2A_GRM_FLG,, |
|
| 281 |
*SUBPLOT-CREATED_BY,*SUBPLOT-CREATED_BY,, |
|
| 282 |
*SUBPLOT-CREATED_DATE,*SUBPLOT-CREATED_DATE,, |
|
| 283 |
*SUBPLOT-CREATED_IN_INSTANCE,*SUBPLOT-CREATED_IN_INSTANCE,, |
|
| 284 |
*SUBPLOT-MODIFIED_BY,*SUBPLOT-MODIFIED_BY,, |
|
| 285 |
*SUBPLOT-MODIFIED_DATE,*SUBPLOT-MODIFIED_DATE,, |
|
| 286 |
*SUBPLOT-MODIFIED_IN_INSTANCE,*SUBPLOT-MODIFIED_IN_INSTANCE,, |
|
| 287 |
*SUBPLOT-CYCLE,*SUBPLOT-CYCLE,, |
|
| 288 |
*SUBPLOT-SUBCYCLE,*SUBPLOT-SUBCYCLE,, |
|
| 289 |
*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,, |
|
| 290 |
*SUBPLOT-NF_SUBP_STATUS_CD,*SUBPLOT-NF_SUBP_STATUS_CD,, |
|
| 291 |
*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,, |
|
| 292 |
*SUBPLOT-P2VEG_SUBP_STATUS_CD,*SUBPLOT-P2VEG_SUBP_STATUS_CD,, |
|
| 293 |
*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,, |
|
| 294 |
*SUBPLOT-INVASIVE_SUBP_STATUS_CD,*SUBPLOT-INVASIVE_SUBP_STATUS_CD,, |
|
| 295 |
*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,, |
|
| 296 |
*COND-row_num,*COND-row_num,, |
|
| 297 |
*COND-CN,*COND-CN,, |
|
| 298 |
*COND-PLT_CN,*COND-PLT_CN,, |
|
| 299 |
*COND-COND_STATUS_CD,*COND-COND_STATUS_CD,, |
|
| 300 |
*COND-COND_NONSAMPLE_REASN_CD,*COND-COND_NONSAMPLE_REASN_CD,, |
|
| 301 |
*COND-RESERVCD,*COND-RESERVCD,, |
|
| 302 |
*COND-OWNCD,*COND-OWNCD,, |
|
| 303 |
*COND-OWNGRPCD,*COND-OWNGRPCD,, |
|
| 304 |
*COND-FORINDCD,*COND-FORINDCD,, |
|
| 305 |
*COND-ADFORCD,*COND-ADFORCD,, |
|
| 306 |
*COND-FORTYPCD,*COND-FORTYPCD,, |
|
| 307 |
*COND-FLDTYPCD,*COND-FLDTYPCD,, |
|
| 308 |
*COND-MAPDEN,*COND-MAPDEN,, |
|
| 309 |
*COND-STDAGE,*COND-STDAGE,, |
|
| 310 |
*COND-STDSZCD,*COND-STDSZCD,, |
|
| 311 |
*COND-FLDSZCD,*COND-FLDSZCD,, |
|
| 312 |
*COND-SITECLCD,*COND-SITECLCD,, |
|
| 313 |
*COND-SICOND,*COND-SICOND,, |
|
| 314 |
*COND-SIBASE,*COND-SIBASE,, |
|
| 315 |
*COND-SISP,*COND-SISP,, |
|
| 316 |
*COND-STDORGCD,*COND-STDORGCD,, |
|
| 317 |
*COND-STDORGSP,*COND-STDORGSP,, |
|
| 318 |
*COND-PROP_BASIS,*COND-PROP_BASIS,, |
|
| 319 |
*COND-CONDPROP_UNADJ,*COND-CONDPROP_UNADJ,, |
|
| 320 |
*COND-MICRPROP_UNADJ,*COND-MICRPROP_UNADJ,, |
|
| 321 |
*COND-SUBPPROP_UNADJ,*COND-SUBPPROP_UNADJ,, |
|
| 322 |
*COND-MACRPROP_UNADJ,*COND-MACRPROP_UNADJ,, |
|
| 323 |
slopeGradient,slopeGradient,, |
|
| 324 |
slopeAspect,slopeAspect,, |
|
| 325 |
*COND-PHYSCLCD,*COND-PHYSCLCD,, |
|
| 326 |
*COND-GSSTKCD,*COND-GSSTKCD,, |
|
| 327 |
*COND-ALSTKCD,*COND-ALSTKCD,, |
|
| 328 |
*COND-DSTRBCD1,*COND-DSTRBCD1,, |
|
| 329 |
*COND-DSTRBYR1,*COND-DSTRBYR1,, |
|
| 330 |
*COND-DSTRBCD2,*COND-DSTRBCD2,, |
|
| 331 |
*COND-DSTRBYR2,*COND-DSTRBYR2,, |
|
| 332 |
*COND-DSTRBCD3,*COND-DSTRBCD3,, |
|
| 333 |
*COND-DSTRBYR3,*COND-DSTRBYR3,, |
|
| 334 |
*COND-TRTCD1,*COND-TRTCD1,, |
|
| 335 |
*COND-TRTYR1,*COND-TRTYR1,, |
|
| 336 |
*COND-TRTCD2,*COND-TRTCD2,, |
|
| 337 |
*COND-TRTYR2,*COND-TRTYR2,, |
|
| 338 |
*COND-TRTCD3,*COND-TRTCD3,, |
|
| 339 |
*COND-TRTYR3,*COND-TRTYR3,, |
|
| 340 |
*COND-PRESNFCD,*COND-PRESNFCD,, |
|
| 341 |
*COND-BALIVE,*COND-BALIVE,, |
|
| 342 |
*COND-FLDAGE,*COND-FLDAGE,, |
|
| 343 |
*COND-ALSTK,*COND-ALSTK,, |
|
| 344 |
*COND-GSSTK,*COND-GSSTK,, |
|
| 345 |
*COND-FORTYPCDCALC,*COND-FORTYPCDCALC,, |
|
| 346 |
*COND-HABTYPCD1_DESCR_PUB_CD,*COND-HABTYPCD1_DESCR_PUB_CD,, |
|
| 347 |
*COND-HABTYPCD2,*COND-HABTYPCD2,, |
|
| 348 |
*COND-HABTYPCD2_PUB_CD,*COND-HABTYPCD2_PUB_CD,, |
|
| 349 |
*COND-HABTYPCD2_DESCR_PUB_CD,*COND-HABTYPCD2_DESCR_PUB_CD,, |
|
| 350 |
*COND-MIXEDCONFCD,*COND-MIXEDCONFCD,, |
|
| 351 |
*COND-VOL_LOC_GRP,*COND-VOL_LOC_GRP,, |
|
| 352 |
*COND-SITECLCDEST,*COND-SITECLCDEST,, |
|
| 353 |
*COND-SITETREE_TREE,*COND-SITETREE_TREE,, |
|
| 354 |
*COND-SITECL_METHOD,*COND-SITECL_METHOD,, |
|
| 355 |
*COND-CARBON_DOWN_DEAD,*COND-CARBON_DOWN_DEAD,, |
|
| 356 |
*COND-CARBON_LITTER,*COND-CARBON_LITTER,, |
|
| 357 |
*COND-CARBON_SOIL_ORG,*COND-CARBON_SOIL_ORG,, |
|
| 358 |
*COND-CARBON_STANDING_DEAD,*COND-CARBON_STANDING_DEAD,, |
|
| 359 |
*COND-CARBON_UNDERSTORY_AG,*COND-CARBON_UNDERSTORY_AG,, |
|
| 360 |
*COND-CARBON_UNDERSTORY_BG,*COND-CARBON_UNDERSTORY_BG,, |
|
| 361 |
*COND-CREATED_BY,*COND-CREATED_BY,, |
|
| 362 |
*COND-CREATED_DATE,*COND-CREATED_DATE,, |
|
| 363 |
*COND-CREATED_IN_INSTANCE,*COND-CREATED_IN_INSTANCE,, |
|
| 364 |
*COND-MODIFIED_BY,*COND-MODIFIED_BY,, |
|
| 365 |
*COND-MODIFIED_DATE,*COND-MODIFIED_DATE,, |
|
| 366 |
*COND-MODIFIED_IN_INSTANCE,*COND-MODIFIED_IN_INSTANCE,, |
|
| 367 |
*COND-CYCLE,*COND-CYCLE,, |
|
| 368 |
*COND-SUBCYCLE,*COND-SUBCYCLE,, |
|
| 369 |
*COND-SOIL_ROOTING_DEPTH_PNW,*COND-SOIL_ROOTING_DEPTH_PNW,, |
|
| 370 |
*COND-GROUND_LAND_CLASS_PNW,*COND-GROUND_LAND_CLASS_PNW,, |
|
| 371 |
*COND-PLANT_STOCKABILITY_FACTOR_PNW,*COND-PLANT_STOCKABILITY_FACTOR_PNW,, |
|
| 372 |
*COND-STND_COND_CD_PNWRS,*COND-STND_COND_CD_PNWRS,, |
|
| 373 |
*COND-STND_STRUC_CD_PNWRS,*COND-STND_STRUC_CD_PNWRS,, |
|
| 374 |
*COND-STUMP_CD_PNWRS,*COND-STUMP_CD_PNWRS,, |
|
| 375 |
*COND-FIRE_SRS,*COND-FIRE_SRS,, |
|
| 376 |
*COND-GRAZING_SRS,*COND-GRAZING_SRS,, |
|
| 377 |
*COND-HARVEST_TYPE1_SRS,*COND-HARVEST_TYPE1_SRS,, |
|
| 378 |
*COND-HARVEST_TYPE2_SRS,*COND-HARVEST_TYPE2_SRS,, |
|
| 379 |
*COND-HARVEST_TYPE3_SRS,*COND-HARVEST_TYPE3_SRS,, |
|
| 380 |
*COND-LAND_USE_SRS,*COND-LAND_USE_SRS,, |
|
| 381 |
*COND-OPERABILITY_SRS,*COND-OPERABILITY_SRS,, |
|
| 382 |
*COND-STAND_STRUCTURE_SRS,*COND-STAND_STRUCTURE_SRS,, |
|
| 383 |
*COND-NF_COND_STATUS_CD,*COND-NF_COND_STATUS_CD,, |
|
| 384 |
*COND-NF_COND_NONSAMPLE_REASN_CD,*COND-NF_COND_NONSAMPLE_REASN_CD,, |
|
| 385 |
*COND-CANOPY_CVR_SAMPLE_METHOD_CD,*COND-CANOPY_CVR_SAMPLE_METHOD_CD,, |
|
| 386 |
*COND-LIVE_CANOPY_CVR_PCT,*COND-LIVE_CANOPY_CVR_PCT,, |
|
| 387 |
*COND-LIVE_MISSING_CANOPY_CVR_PCT,*COND-LIVE_MISSING_CANOPY_CVR_PCT,, |
|
| 388 |
*COND-NBR_LIVE_STEMS,*COND-NBR_LIVE_STEMS,, |
|
| 389 |
*COND-OWNSUBCD,*COND-OWNSUBCD,, |
|
| 390 |
*COND-INDUSTRIALCD_FIADB,*COND-INDUSTRIALCD_FIADB,, |
|
| 391 |
*COND-RESERVCD_FLD,*COND-RESERVCD_FLD,, |
|
| 392 |
*COND-ADMIN_WITHDRAWN_CD,*COND-ADMIN_WITHDRAWN_CD,, |
|
| 393 |
oldGrowth,oldGrowth,, |
|
| 394 |
cultivated,cultivated,, |
|
| 395 |
*REF_HABTYP_DESCRIPTION-row_num,*REF_HABTYP_DESCRIPTION-row_num,, |
|
| 396 |
communityID,communityID,, |
|
| 397 |
*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,, |
|
| 398 |
communityName,communityName,, |
|
| 399 |
*REF_HABTYP_DESCRIPTION-VALID,*REF_HABTYP_DESCRIPTION-VALID,, |
|
| 400 |
*REF_HABTYP_DESCRIPTION-CREATED_BY,*REF_HABTYP_DESCRIPTION-CREATED_BY,, |
|
| 401 |
*REF_HABTYP_DESCRIPTION-CREATED_DATE,*REF_HABTYP_DESCRIPTION-CREATED_DATE,, |
|
| 402 |
*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,, |
|
| 403 |
*REF_HABTYP_DESCRIPTION-MODIFIED_BY,*REF_HABTYP_DESCRIPTION-MODIFIED_BY,, |
|
| 404 |
*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,, |
|
| 405 |
*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,, |
|
| 406 |
*PLOT-row_num,*PLOT-row_num,, |
|
| 407 |
locationID,locationID,, |
|
| 408 |
*PLOT-SRV_CN,*PLOT-SRV_CN,, |
|
| 409 |
*PLOT-CTY_CN,*PLOT-CTY_CN,, |
|
| 410 |
*PLOT-PREV_PLT_CN,*PLOT-PREV_PLT_CN,, |
|
| 411 |
*PLOT-PLOT_STATUS_CD,*PLOT-PLOT_STATUS_CD,, |
|
| 412 |
*PLOT-PLOT_NONSAMPLE_REASN_CD,*PLOT-PLOT_NONSAMPLE_REASN_CD,, |
|
| 413 |
year,year,, |
|
| 414 |
month,month,, |
|
| 415 |
day,day,, |
|
| 416 |
*PLOT-REMPER,*PLOT-REMPER,, |
|
| 417 |
*PLOT-KINDCD,*PLOT-KINDCD,, |
|
| 418 |
*PLOT-DESIGNCD,*PLOT-DESIGNCD,, |
|
| 419 |
*PLOT-RDDISTCD,*PLOT-RDDISTCD,, |
|
| 420 |
*PLOT-WATERCD,*PLOT-WATERCD,, |
|
| 421 |
decimalLatitude,decimalLatitude,, |
|
| 422 |
decimalLongitude,decimalLongitude,, |
|
| 423 |
elevation_ft,elevation_ft,, |
|
| 424 |
*PLOT-GROW_TYP_CD,*PLOT-GROW_TYP_CD,, |
|
| 425 |
*PLOT-MORT_TYP_CD,*PLOT-MORT_TYP_CD,, |
|
| 426 |
*PLOT-P2PANEL,*PLOT-P2PANEL,, |
|
| 427 |
*PLOT-P3PANEL,*PLOT-P3PANEL,, |
|
| 428 |
*PLOT-ECOSUBCD,*PLOT-ECOSUBCD,, |
|
| 429 |
*PLOT-CONGCD,*PLOT-CONGCD,, |
|
| 430 |
*PLOT-MANUAL,*PLOT-MANUAL,, |
|
| 431 |
*PLOT-SUBPANEL,*PLOT-SUBPANEL,, |
|
| 432 |
*PLOT-KINDCD_NC,*PLOT-KINDCD_NC,, |
|
| 433 |
*PLOT-QA_STATUS,*PLOT-QA_STATUS,, |
|
| 434 |
*PLOT-CREATED_BY,*PLOT-CREATED_BY,, |
|
| 435 |
*PLOT-CREATED_DATE,*PLOT-CREATED_DATE,, |
|
| 436 |
*PLOT-CREATED_IN_INSTANCE,*PLOT-CREATED_IN_INSTANCE,, |
|
| 437 |
*PLOT-MODIFIED_BY,*PLOT-MODIFIED_BY,, |
|
| 438 |
*PLOT-MODIFIED_DATE,*PLOT-MODIFIED_DATE,, |
|
| 439 |
*PLOT-MODIFIED_IN_INSTANCE,*PLOT-MODIFIED_IN_INSTANCE,, |
|
| 440 |
*PLOT-MICROPLOT_LOC,*PLOT-MICROPLOT_LOC,, |
|
| 441 |
*PLOT-DECLINATION,*PLOT-DECLINATION,, |
|
| 442 |
*PLOT-EMAP_HEX,*PLOT-EMAP_HEX,, |
|
| 443 |
*PLOT-SAMP_METHOD_CD,*PLOT-SAMP_METHOD_CD,, |
|
| 444 |
*PLOT-SUBP_EXAMINE_CD,*PLOT-SUBP_EXAMINE_CD,, |
|
| 445 |
*PLOT-MACRO_BREAKPOINT_DIA,*PLOT-MACRO_BREAKPOINT_DIA,, |
|
| 446 |
*PLOT-INTENSITY,*PLOT-INTENSITY,, |
|
| 447 |
*PLOT-CYCLE,*PLOT-CYCLE,, |
|
| 448 |
*PLOT-SUBCYCLE,*PLOT-SUBCYCLE,, |
|
| 449 |
*PLOT-ECO_UNIT_PNW,*PLOT-ECO_UNIT_PNW,, |
|
| 450 |
*PLOT-TOPO_POSITION_PNW,*PLOT-TOPO_POSITION_PNW,, |
|
| 451 |
*PLOT-NF_SAMPLING_STATUS_CD,*PLOT-NF_SAMPLING_STATUS_CD,, |
|
| 452 |
*PLOT-NF_PLOT_STATUS_CD,*PLOT-NF_PLOT_STATUS_CD,, |
|
| 453 |
*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,, |
|
| 454 |
*PLOT-P2VEG_SAMPLING_STATUS_CD,*PLOT-P2VEG_SAMPLING_STATUS_CD,, |
|
| 455 |
*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,, |
|
| 456 |
*PLOT-INVASIVE_SAMPLING_STATUS_CD,*PLOT-INVASIVE_SAMPLING_STATUS_CD,, |
|
| 457 |
*PLOT-INVASIVE_SPECIMEN_RULE_CD,*PLOT-INVASIVE_SPECIMEN_RULE_CD,, |
|
| 458 |
*PLOT-DESIGNCD_P2A,*PLOT-DESIGNCD_P2A,, |
|
| 459 |
*COUNTY-row_num,*COUNTY-row_num,, |
|
| 460 |
county,county,, |
|
| 461 |
*COUNTY-CN,*COUNTY-CN,, |
|
| 462 |
*COUNTY-CREATED_BY,*COUNTY-CREATED_BY,, |
|
| 463 |
*COUNTY-CREATED_DATE,*COUNTY-CREATED_DATE,, |
|
| 464 |
*COUNTY-CREATED_IN_INSTANCE,*COUNTY-CREATED_IN_INSTANCE,, |
|
| 465 |
*COUNTY-MODIFIED_BY,*COUNTY-MODIFIED_BY,, |
|
| 466 |
*COUNTY-MODIFIED_DATE,*COUNTY-MODIFIED_DATE,, |
|
| 467 |
*COUNTY-MODIFIED_IN_INSTANCE,*COUNTY-MODIFIED_IN_INSTANCE,, |
|
| 468 |
*REF_UNIT-row_num,*REF_UNIT-row_num,, |
|
| 469 |
*REF_UNIT-MEANING,*REF_UNIT-MEANING,, |
|
| 470 |
*REF_UNIT-CREATED_BY,*REF_UNIT-CREATED_BY,, |
|
| 471 |
*REF_UNIT-CREATED_DATE,*REF_UNIT-CREATED_DATE,, |
|
| 472 |
*REF_UNIT-CREATED_IN_INSTANCE,*REF_UNIT-CREATED_IN_INSTANCE,, |
|
| 473 |
*REF_UNIT-MODIFIED_BY,*REF_UNIT-MODIFIED_BY,, |
|
| 474 |
*REF_UNIT-MODIFIED_DATE,*REF_UNIT-MODIFIED_DATE,, |
|
| 475 |
*REF_UNIT-MODIFIED_IN_INSTANCE,*REF_UNIT-MODIFIED_IN_INSTANCE,, |
|
| 476 |
*REF_RESEARCH_STATION-row_num,*REF_RESEARCH_STATION-row_num,, |
|
| 477 |
*REF_RESEARCH_STATION-RSCD,*REF_RESEARCH_STATION-RSCD,, |
|
| 478 |
*REF_RESEARCH_STATION-RS,*REF_RESEARCH_STATION-RS,, |
|
| 479 |
stateProvince,stateProvince,, |
|
| 480 |
*REF_RESEARCH_STATION-STATE_ABBR,*REF_RESEARCH_STATION-STATE_ABBR,, |
|
| 481 |
*REF_RESEARCH_STATION-CREATED_BY,*REF_RESEARCH_STATION-CREATED_BY,, |
|
| 482 |
*REF_RESEARCH_STATION-CREATED_DATE,*REF_RESEARCH_STATION-CREATED_DATE,, |
|
| 483 |
*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,, |
|
| 484 |
*REF_RESEARCH_STATION-MODIFIED_BY,*REF_RESEARCH_STATION-MODIFIED_BY,, |
|
| 485 |
*REF_RESEARCH_STATION-MODIFIED_DATE,*REF_RESEARCH_STATION-MODIFIED_DATE,, |
|
| 486 |
*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,, |
|
| inputs/FIA/occurrence_all/unmapped_terms.csv | ||
|---|---|---|
| 1 | 1 |
occurrence_all-row_num |
| 2 | 2 |
*STATECD |
| 3 |
*REF_RESEARCH_STATION-row_num |
|
| 4 |
*REF_RESEARCH_STATION-RSCD |
|
| 5 |
*REF_RESEARCH_STATION-RS |
|
| 6 |
*REF_RESEARCH_STATION-STATE_ABBR |
|
| 7 |
*REF_RESEARCH_STATION-CREATED_BY |
|
| 8 |
*REF_RESEARCH_STATION-CREATED_DATE |
|
| 9 |
*REF_RESEARCH_STATION-CREATED_IN_INSTANCE |
|
| 10 |
*REF_RESEARCH_STATION-MODIFIED_BY |
|
| 11 |
*REF_RESEARCH_STATION-MODIFIED_DATE |
|
| 12 |
*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE |
|
| 13 | 3 |
*UNITCD |
| 14 |
*REF_UNIT-row_num |
|
| 15 |
*REF_UNIT-MEANING |
|
| 16 |
*REF_UNIT-CREATED_BY |
|
| 17 |
*REF_UNIT-CREATED_DATE |
|
| 18 |
*REF_UNIT-CREATED_IN_INSTANCE |
|
| 19 |
*REF_UNIT-MODIFIED_BY |
|
| 20 |
*REF_UNIT-MODIFIED_DATE |
|
| 21 |
*REF_UNIT-MODIFIED_IN_INSTANCE |
|
| 22 | 4 |
*COUNTYCD |
| 23 |
*COUNTY-row_num |
|
| 24 |
*COUNTY-CN |
|
| 25 |
*COUNTY-CREATED_BY |
|
| 26 |
*COUNTY-CREATED_DATE |
|
| 27 |
*COUNTY-CREATED_IN_INSTANCE |
|
| 28 |
*COUNTY-MODIFIED_BY |
|
| 29 |
*COUNTY-MODIFIED_DATE |
|
| 30 |
*COUNTY-MODIFIED_IN_INSTANCE |
|
| 31 | 5 |
*INVYR |
| 32 |
*PLOT-row_num |
|
| 33 |
*PLOT-SRV_CN |
|
| 34 |
*PLOT-CTY_CN |
|
| 35 |
*PLOT-PREV_PLT_CN |
|
| 36 |
*PLOT-PLOT_STATUS_CD |
|
| 37 |
*PLOT-PLOT_NONSAMPLE_REASN_CD |
|
| 38 |
year |
|
| 39 |
month |
|
| 40 |
day |
|
| 41 |
*PLOT-REMPER |
|
| 42 |
*PLOT-KINDCD |
|
| 43 |
*PLOT-DESIGNCD |
|
| 44 |
*PLOT-RDDISTCD |
|
| 45 |
*PLOT-WATERCD |
|
| 46 |
elevation_ft |
|
| 47 |
*PLOT-GROW_TYP_CD |
|
| 48 |
*PLOT-MORT_TYP_CD |
|
| 49 |
*PLOT-P2PANEL |
|
| 50 |
*PLOT-P3PANEL |
|
| 51 |
*PLOT-ECOSUBCD |
|
| 52 |
*PLOT-CONGCD |
|
| 53 |
*PLOT-MANUAL |
|
| 54 |
*PLOT-SUBPANEL |
|
| 55 |
*PLOT-KINDCD_NC |
|
| 56 |
*PLOT-QA_STATUS |
|
| 57 |
*PLOT-CREATED_BY |
|
| 58 |
*PLOT-CREATED_DATE |
|
| 59 |
*PLOT-CREATED_IN_INSTANCE |
|
| 60 |
*PLOT-MODIFIED_BY |
|
| 61 |
*PLOT-MODIFIED_DATE |
|
| 62 |
*PLOT-MODIFIED_IN_INSTANCE |
|
| 63 |
*PLOT-MICROPLOT_LOC |
|
| 64 |
*PLOT-DECLINATION |
|
| 65 |
*PLOT-EMAP_HEX |
|
| 66 |
*PLOT-SAMP_METHOD_CD |
|
| 67 |
*PLOT-SUBP_EXAMINE_CD |
|
| 68 |
*PLOT-MACRO_BREAKPOINT_DIA |
|
| 69 |
*PLOT-INTENSITY |
|
| 70 |
*PLOT-CYCLE |
|
| 71 |
*PLOT-SUBCYCLE |
|
| 72 |
*PLOT-ECO_UNIT_PNW |
|
| 73 |
*PLOT-TOPO_POSITION_PNW |
|
| 74 |
*PLOT-NF_SAMPLING_STATUS_CD |
|
| 75 |
*PLOT-NF_PLOT_STATUS_CD |
|
| 76 |
*PLOT-NF_PLOT_NONSAMPLE_REASN_CD |
|
| 77 |
*PLOT-P2VEG_SAMPLING_STATUS_CD |
|
| 78 |
*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD |
|
| 79 |
*PLOT-INVASIVE_SAMPLING_STATUS_CD |
|
| 80 |
*PLOT-INVASIVE_SPECIMEN_RULE_CD |
|
| 81 |
*PLOT-DESIGNCD_P2A |
|
| 82 | 6 |
*HABTYPCD |
| 83 | 7 |
*HABTYP_PUB_CD |
| 84 |
*COND-row_num |
|
| 85 |
*COND-CN |
|
| 86 |
*COND-PLT_CN |
|
| 87 |
*COND-COND_STATUS_CD |
|
| 88 |
*COND-COND_NONSAMPLE_REASN_CD |
|
| 89 |
*COND-RESERVCD |
|
| 90 |
*COND-OWNCD |
|
| 91 |
*COND-OWNGRPCD |
|
| 92 |
*COND-FORINDCD |
|
| 93 |
*COND-ADFORCD |
|
| 94 |
*COND-FORTYPCD |
|
| 95 |
*COND-FLDTYPCD |
|
| 96 |
*COND-MAPDEN |
|
| 97 |
*COND-STDAGE |
|
| 98 |
*COND-STDSZCD |
|
| 99 |
*COND-FLDSZCD |
|
| 100 |
*COND-SITECLCD |
|
| 101 |
*COND-SICOND |
|
| 102 |
*COND-SIBASE |
|
| 103 |
*COND-SISP |
|
| 104 |
*COND-STDORGCD |
|
| 105 |
*COND-STDORGSP |
|
| 106 |
*COND-PROP_BASIS |
|
| 107 |
*COND-CONDPROP_UNADJ |
|
| 108 |
*COND-MICRPROP_UNADJ |
|
| 109 |
*COND-SUBPPROP_UNADJ |
|
| 110 |
*COND-MACRPROP_UNADJ |
|
| 111 |
*COND-PHYSCLCD |
|
| 112 |
*COND-GSSTKCD |
|
| 113 |
*COND-ALSTKCD |
|
| 114 |
*COND-DSTRBCD1 |
|
| 115 |
*COND-DSTRBYR1 |
|
| 116 |
*COND-DSTRBCD2 |
|
| 117 |
*COND-DSTRBYR2 |
|
| 118 |
*COND-DSTRBCD3 |
|
| 119 |
*COND-DSTRBYR3 |
|
| 120 |
*COND-TRTCD1 |
|
| 121 |
*COND-TRTYR1 |
|
| 122 |
*COND-TRTCD2 |
|
| 123 |
*COND-TRTYR2 |
|
| 124 |
*COND-TRTCD3 |
|
| 125 |
*COND-TRTYR3 |
|
| 126 |
*COND-PRESNFCD |
|
| 127 |
*COND-BALIVE |
|
| 128 |
*COND-FLDAGE |
|
| 129 |
*COND-ALSTK |
|
| 130 |
*COND-GSSTK |
|
| 131 |
*COND-FORTYPCDCALC |
|
| 132 |
*COND-HABTYPCD1_DESCR_PUB_CD |
|
| 133 |
*COND-HABTYPCD2 |
|
| 134 |
*COND-HABTYPCD2_PUB_CD |
|
| 135 |
*COND-HABTYPCD2_DESCR_PUB_CD |
|
| 136 |
*COND-MIXEDCONFCD |
|
| 137 |
*COND-VOL_LOC_GRP |
|
| 138 |
*COND-SITECLCDEST |
|
| 139 |
*COND-SITETREE_TREE |
|
| 140 |
*COND-SITECL_METHOD |
|
| 141 |
*COND-CARBON_DOWN_DEAD |
|
| 142 |
*COND-CARBON_LITTER |
|
| 143 |
*COND-CARBON_SOIL_ORG |
|
| 144 |
*COND-CARBON_STANDING_DEAD |
|
| 145 |
*COND-CARBON_UNDERSTORY_AG |
|
| 146 |
*COND-CARBON_UNDERSTORY_BG |
|
| 147 |
*COND-CREATED_BY |
|
| 148 |
*COND-CREATED_DATE |
|
| 149 |
*COND-CREATED_IN_INSTANCE |
|
| 150 |
*COND-MODIFIED_BY |
|
| 151 |
*COND-MODIFIED_DATE |
|
| 152 |
*COND-MODIFIED_IN_INSTANCE |
|
| 153 |
*COND-CYCLE |
|
| 154 |
*COND-SUBCYCLE |
|
| 155 |
*COND-SOIL_ROOTING_DEPTH_PNW |
|
| 156 |
*COND-GROUND_LAND_CLASS_PNW |
|
| 157 |
*COND-PLANT_STOCKABILITY_FACTOR_PNW |
|
| 158 |
*COND-STND_COND_CD_PNWRS |
|
| 159 |
*COND-STND_STRUC_CD_PNWRS |
|
| 160 |
*COND-STUMP_CD_PNWRS |
|
| 161 |
*COND-FIRE_SRS |
|
| 162 |
*COND-GRAZING_SRS |
|
| 163 |
*COND-HARVEST_TYPE1_SRS |
|
| 164 |
*COND-HARVEST_TYPE2_SRS |
|
| 165 |
*COND-HARVEST_TYPE3_SRS |
|
| 166 |
*COND-LAND_USE_SRS |
|
| 167 |
*COND-OPERABILITY_SRS |
|
| 168 |
*COND-STAND_STRUCTURE_SRS |
|
| 169 |
*COND-NF_COND_STATUS_CD |
|
| 170 |
*COND-NF_COND_NONSAMPLE_REASN_CD |
|
| 171 |
*COND-CANOPY_CVR_SAMPLE_METHOD_CD |
|
| 172 |
*COND-LIVE_CANOPY_CVR_PCT |
|
| 173 |
*COND-LIVE_MISSING_CANOPY_CVR_PCT |
|
| 174 |
*COND-NBR_LIVE_STEMS |
|
| 175 |
*COND-OWNSUBCD |
|
| 176 |
*COND-INDUSTRIALCD_FIADB |
|
| 177 |
*COND-RESERVCD_FLD |
|
| 178 |
*COND-ADMIN_WITHDRAWN_CD |
|
| 179 |
*REF_HABTYP_DESCRIPTION-row_num |
|
| 180 |
*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME |
|
| 181 |
*REF_HABTYP_DESCRIPTION-VALID |
|
| 182 |
*REF_HABTYP_DESCRIPTION-CREATED_BY |
|
| 183 |
*REF_HABTYP_DESCRIPTION-CREATED_DATE |
|
| 184 |
*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE |
|
| 185 |
*REF_HABTYP_DESCRIPTION-MODIFIED_BY |
|
| 186 |
*REF_HABTYP_DESCRIPTION-MODIFIED_DATE |
|
| 187 |
*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE |
|
| 188 |
*SUBPLOT-row_num |
|
| 189 |
*SUBPLOT-PLT_CN |
|
| 190 |
*SUBPLOT-PREV_SBP_CN |
|
| 191 |
*SUBPLOT-SUBP_STATUS_CD |
|
| 192 |
*SUBPLOT-POINT_NONSAMPLE_REASN_CD |
|
| 193 |
*SUBPLOT-MICRCOND |
|
| 194 |
*SUBPLOT-SUBPCOND |
|
| 195 |
*SUBPLOT-MACRCOND |
|
| 196 |
*SUBPLOT-CONDLIST |
|
| 197 |
*SUBPLOT-SLOPE |
|
| 198 |
*SUBPLOT-ASPECT |
|
| 199 |
*SUBPLOT-WATERDEP |
|
| 200 |
*SUBPLOT-P2A_GRM_FLG |
|
| 201 |
*SUBPLOT-CREATED_BY |
|
| 202 |
*SUBPLOT-CREATED_DATE |
|
| 203 |
*SUBPLOT-CREATED_IN_INSTANCE |
|
| 204 |
*SUBPLOT-MODIFIED_BY |
|
| 205 |
*SUBPLOT-MODIFIED_DATE |
|
| 206 |
*SUBPLOT-MODIFIED_IN_INSTANCE |
|
| 207 |
*SUBPLOT-CYCLE |
|
| 208 |
*SUBPLOT-SUBCYCLE |
|
| 209 |
*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS |
|
| 210 |
*SUBPLOT-NF_SUBP_STATUS_CD |
|
| 211 |
*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD |
|
| 212 |
*SUBPLOT-P2VEG_SUBP_STATUS_CD |
|
| 213 |
*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD |
|
| 214 |
*SUBPLOT-INVASIVE_SUBP_STATUS_CD |
|
| 215 |
*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD |
|
| 216 | 8 |
*PLANT_SYMBOL |
| 217 | 9 |
*PLANT_SYMBOL_TYPE |
| 218 | 10 |
*SPCD |
| ... | ... | |
| 456 | 248 |
*REF_PLANT_DICTIONARY-MODIFIED_BY |
| 457 | 249 |
*REF_PLANT_DICTIONARY-MODIFIED_DATE |
| 458 | 250 |
*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE |
| 251 |
*SUBPLOT-row_num |
|
| 252 |
*SUBPLOT-PLT_CN |
|
| 253 |
*SUBPLOT-PREV_SBP_CN |
|
| 254 |
*SUBPLOT-SUBP_STATUS_CD |
|
| 255 |
*SUBPLOT-POINT_NONSAMPLE_REASN_CD |
|
| 256 |
*SUBPLOT-MICRCOND |
|
| 257 |
*SUBPLOT-SUBPCOND |
|
| 258 |
*SUBPLOT-MACRCOND |
|
| 259 |
*SUBPLOT-CONDLIST |
|
| 260 |
*SUBPLOT-SLOPE |
|
| 261 |
*SUBPLOT-ASPECT |
|
| 262 |
*SUBPLOT-WATERDEP |
|
| 263 |
*SUBPLOT-P2A_GRM_FLG |
|
| 264 |
*SUBPLOT-CREATED_BY |
|
| 265 |
*SUBPLOT-CREATED_DATE |
|
| 266 |
*SUBPLOT-CREATED_IN_INSTANCE |
|
| 267 |
*SUBPLOT-MODIFIED_BY |
|
| 268 |
*SUBPLOT-MODIFIED_DATE |
|
| 269 |
*SUBPLOT-MODIFIED_IN_INSTANCE |
|
| 270 |
*SUBPLOT-CYCLE |
|
| 271 |
*SUBPLOT-SUBCYCLE |
|
| 272 |
*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS |
|
| 273 |
*SUBPLOT-NF_SUBP_STATUS_CD |
|
| 274 |
*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD |
|
| 275 |
*SUBPLOT-P2VEG_SUBP_STATUS_CD |
|
| 276 |
*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD |
|
| 277 |
*SUBPLOT-INVASIVE_SUBP_STATUS_CD |
|
| 278 |
*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD |
|
| 279 |
*COND-row_num |
|
| 280 |
*COND-CN |
|
| 281 |
*COND-PLT_CN |
|
| 282 |
*COND-COND_STATUS_CD |
|
| 283 |
*COND-COND_NONSAMPLE_REASN_CD |
|
| 284 |
*COND-RESERVCD |
|
| 285 |
*COND-OWNCD |
|
| 286 |
*COND-OWNGRPCD |
|
| 287 |
*COND-FORINDCD |
|
| 288 |
*COND-ADFORCD |
|
| 289 |
*COND-FORTYPCD |
|
| 290 |
*COND-FLDTYPCD |
|
| 291 |
*COND-MAPDEN |
|
| 292 |
*COND-STDAGE |
|
| 293 |
*COND-STDSZCD |
|
| 294 |
*COND-FLDSZCD |
|
| 295 |
*COND-SITECLCD |
|
| 296 |
*COND-SICOND |
|
| 297 |
*COND-SIBASE |
|
| 298 |
*COND-SISP |
|
| 299 |
*COND-STDORGCD |
|
| 300 |
*COND-STDORGSP |
|
| 301 |
*COND-PROP_BASIS |
|
| 302 |
*COND-CONDPROP_UNADJ |
|
| 303 |
*COND-MICRPROP_UNADJ |
|
| 304 |
*COND-SUBPPROP_UNADJ |
|
| 305 |
*COND-MACRPROP_UNADJ |
|
| 306 |
*COND-PHYSCLCD |
|
| 307 |
*COND-GSSTKCD |
|
| 308 |
*COND-ALSTKCD |
|
| 309 |
*COND-DSTRBCD1 |
|
| 310 |
*COND-DSTRBYR1 |
|
| 311 |
*COND-DSTRBCD2 |
|
| 312 |
*COND-DSTRBYR2 |
|
| 313 |
*COND-DSTRBCD3 |
|
| 314 |
*COND-DSTRBYR3 |
|
| 315 |
*COND-TRTCD1 |
|
| 316 |
*COND-TRTYR1 |
|
| 317 |
*COND-TRTCD2 |
|
| 318 |
*COND-TRTYR2 |
|
| 319 |
*COND-TRTCD3 |
|
| 320 |
*COND-TRTYR3 |
|
| 321 |
*COND-PRESNFCD |
|
| 322 |
*COND-BALIVE |
|
| 323 |
*COND-FLDAGE |
|
| 324 |
*COND-ALSTK |
|
| 325 |
*COND-GSSTK |
|
| 326 |
*COND-FORTYPCDCALC |
|
| 327 |
*COND-HABTYPCD1_DESCR_PUB_CD |
|
| 328 |
*COND-HABTYPCD2 |
|
| 329 |
*COND-HABTYPCD2_PUB_CD |
|
| 330 |
*COND-HABTYPCD2_DESCR_PUB_CD |
|
| 331 |
*COND-MIXEDCONFCD |
|
| 332 |
*COND-VOL_LOC_GRP |
|
| 333 |
*COND-SITECLCDEST |
|
| 334 |
*COND-SITETREE_TREE |
|
| 335 |
*COND-SITECL_METHOD |
|
| 336 |
*COND-CARBON_DOWN_DEAD |
|
| 337 |
*COND-CARBON_LITTER |
|
| 338 |
*COND-CARBON_SOIL_ORG |
|
| 339 |
*COND-CARBON_STANDING_DEAD |
|
| 340 |
*COND-CARBON_UNDERSTORY_AG |
|
| 341 |
*COND-CARBON_UNDERSTORY_BG |
|
| 342 |
*COND-CREATED_BY |
|
| 343 |
*COND-CREATED_DATE |
|
| 344 |
*COND-CREATED_IN_INSTANCE |
|
| 345 |
*COND-MODIFIED_BY |
|
| 346 |
*COND-MODIFIED_DATE |
|
| 347 |
*COND-MODIFIED_IN_INSTANCE |
|
| 348 |
*COND-CYCLE |
|
| 349 |
*COND-SUBCYCLE |
|
| 350 |
*COND-SOIL_ROOTING_DEPTH_PNW |
|
| 351 |
*COND-GROUND_LAND_CLASS_PNW |
|
| 352 |
*COND-PLANT_STOCKABILITY_FACTOR_PNW |
|
| 353 |
*COND-STND_COND_CD_PNWRS |
|
| 354 |
*COND-STND_STRUC_CD_PNWRS |
|
| 355 |
*COND-STUMP_CD_PNWRS |
|
| 356 |
*COND-FIRE_SRS |
|
| 357 |
*COND-GRAZING_SRS |
|
| 358 |
*COND-HARVEST_TYPE1_SRS |
|
| 359 |
*COND-HARVEST_TYPE2_SRS |
|
| 360 |
*COND-HARVEST_TYPE3_SRS |
|
| 361 |
*COND-LAND_USE_SRS |
|
| 362 |
*COND-OPERABILITY_SRS |
|
| 363 |
*COND-STAND_STRUCTURE_SRS |
|
| 364 |
*COND-NF_COND_STATUS_CD |
|
| 365 |
*COND-NF_COND_NONSAMPLE_REASN_CD |
|
| 366 |
*COND-CANOPY_CVR_SAMPLE_METHOD_CD |
|
| 367 |
*COND-LIVE_CANOPY_CVR_PCT |
|
| 368 |
*COND-LIVE_MISSING_CANOPY_CVR_PCT |
|
| 369 |
*COND-NBR_LIVE_STEMS |
|
| 370 |
*COND-OWNSUBCD |
|
| 371 |
*COND-INDUSTRIALCD_FIADB |
|
| 372 |
*COND-RESERVCD_FLD |
|
| 373 |
*COND-ADMIN_WITHDRAWN_CD |
|
| 374 |
*REF_HABTYP_DESCRIPTION-row_num |
|
| 375 |
*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME |
|
| 376 |
*REF_HABTYP_DESCRIPTION-VALID |
|
| 377 |
*REF_HABTYP_DESCRIPTION-CREATED_BY |
|
| 378 |
*REF_HABTYP_DESCRIPTION-CREATED_DATE |
|
| 379 |
*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE |
|
| 380 |
*REF_HABTYP_DESCRIPTION-MODIFIED_BY |
|
| 381 |
*REF_HABTYP_DESCRIPTION-MODIFIED_DATE |
|
| 382 |
*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE |
|
| 383 |
*PLOT-row_num |
|
| 384 |
*PLOT-SRV_CN |
|
| 385 |
*PLOT-CTY_CN |
|
| 386 |
*PLOT-PREV_PLT_CN |
|
| 387 |
*PLOT-PLOT_STATUS_CD |
|
| 388 |
*PLOT-PLOT_NONSAMPLE_REASN_CD |
|
| 389 |
year |
|
| 390 |
month |
|
| 391 |
day |
|
| 392 |
*PLOT-REMPER |
|
| 393 |
*PLOT-KINDCD |
|
| 394 |
*PLOT-DESIGNCD |
|
| 395 |
*PLOT-RDDISTCD |
|
| 396 |
*PLOT-WATERCD |
|
| 397 |
elevation_ft |
|
| 398 |
*PLOT-GROW_TYP_CD |
|
| 399 |
*PLOT-MORT_TYP_CD |
|
| 400 |
*PLOT-P2PANEL |
|
| 401 |
*PLOT-P3PANEL |
|
| 402 |
*PLOT-ECOSUBCD |
|
| 403 |
*PLOT-CONGCD |
|
| 404 |
*PLOT-MANUAL |
|
| 405 |
*PLOT-SUBPANEL |
|
| 406 |
*PLOT-KINDCD_NC |
|
| 407 |
*PLOT-QA_STATUS |
|
| 408 |
*PLOT-CREATED_BY |
|
| 409 |
*PLOT-CREATED_DATE |
|
| 410 |
*PLOT-CREATED_IN_INSTANCE |
|
| 411 |
*PLOT-MODIFIED_BY |
|
| 412 |
*PLOT-MODIFIED_DATE |
|
| 413 |
*PLOT-MODIFIED_IN_INSTANCE |
|
| 414 |
*PLOT-MICROPLOT_LOC |
|
| 415 |
*PLOT-DECLINATION |
|
| 416 |
*PLOT-EMAP_HEX |
|
| 417 |
*PLOT-SAMP_METHOD_CD |
|
| 418 |
*PLOT-SUBP_EXAMINE_CD |
|
| 419 |
*PLOT-MACRO_BREAKPOINT_DIA |
|
| 420 |
*PLOT-INTENSITY |
|
| 421 |
*PLOT-CYCLE |
|
| 422 |
*PLOT-SUBCYCLE |
|
| 423 |
*PLOT-ECO_UNIT_PNW |
|
| 424 |
*PLOT-TOPO_POSITION_PNW |
|
| 425 |
*PLOT-NF_SAMPLING_STATUS_CD |
|
| 426 |
*PLOT-NF_PLOT_STATUS_CD |
|
| 427 |
*PLOT-NF_PLOT_NONSAMPLE_REASN_CD |
|
| 428 |
*PLOT-P2VEG_SAMPLING_STATUS_CD |
|
| 429 |
*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD |
|
| 430 |
*PLOT-INVASIVE_SAMPLING_STATUS_CD |
|
| 431 |
*PLOT-INVASIVE_SPECIMEN_RULE_CD |
|
| 432 |
*PLOT-DESIGNCD_P2A |
|
| 433 |
*COUNTY-row_num |
|
| 434 |
*COUNTY-CN |
|
| 435 |
*COUNTY-CREATED_BY |
|
| 436 |
*COUNTY-CREATED_DATE |
|
| 437 |
*COUNTY-CREATED_IN_INSTANCE |
|
| 438 |
*COUNTY-MODIFIED_BY |
|
| 439 |
*COUNTY-MODIFIED_DATE |
|
| 440 |
*COUNTY-MODIFIED_IN_INSTANCE |
|
| 441 |
*REF_UNIT-row_num |
|
| 442 |
*REF_UNIT-MEANING |
|
| 443 |
*REF_UNIT-CREATED_BY |
|
| 444 |
*REF_UNIT-CREATED_DATE |
|
| 445 |
*REF_UNIT-CREATED_IN_INSTANCE |
|
| 446 |
*REF_UNIT-MODIFIED_BY |
|
| 447 |
*REF_UNIT-MODIFIED_DATE |
|
| 448 |
*REF_UNIT-MODIFIED_IN_INSTANCE |
|
| 449 |
*REF_RESEARCH_STATION-row_num |
|
| 450 |
*REF_RESEARCH_STATION-RSCD |
|
| 451 |
*REF_RESEARCH_STATION-RS |
|
| 452 |
*REF_RESEARCH_STATION-STATE_ABBR |
|
| 453 |
*REF_RESEARCH_STATION-CREATED_BY |
|
| 454 |
*REF_RESEARCH_STATION-CREATED_DATE |
|
| 455 |
*REF_RESEARCH_STATION-CREATED_IN_INSTANCE |
|
| 456 |
*REF_RESEARCH_STATION-MODIFIED_BY |
|
| 457 |
*REF_RESEARCH_STATION-MODIFIED_DATE |
|
| 458 |
*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE |
|
Also available in: Unified diff
inputs/FIA/occurrence_all/postprocess.sql: use much simpler LEFT JOINs instead of nested RIGHT JOINs, which required lots of () to get them to happen in the right order. note that the columns are now provided in reverse instead of forwards path order, but this is still much clearer than the nested mess of RIGHT JOINs. this approach can also be used to simplify VegBank's joins.