Project

General

Profile

« Previous | Next » 

Revision 8318

inputs/FIA/occurrence_all/: Updated header.csv for new column order

View differences:

inputs/FIA/occurrence_all/header.csv
1
PLANT_SYMBOL,PLANT_SYMBOL_TYPE,SPCD,STATECD,UNITCD,COUNTYCD,INVYR,locationName,authorEventCode,subplot,HABTYPCD,HABTYP_PUB_CD,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,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,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,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,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-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,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
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
inputs/FIA/occurrence_all/map.csv
1 1
FIA,VegCore,Filter,Comments
2
PLANT_SYMBOL,*PLANT_SYMBOL,,
3
PLANT_SYMBOL_TYPE,*PLANT_SYMBOL_TYPE,,
4
SPCD,*SPCD,,
5 2
STATECD,*STATECD,,
6
UNITCD,*UNITCD,,
7
COUNTYCD,*COUNTYCD,,
8
INVYR,*INVYR,,
9
locationName,locationName,,
10
authorEventCode,authorEventCode,,
11
subplot,subplot,,
12
HABTYPCD,*HABTYPCD,,
13
HABTYP_PUB_CD,*HABTYP_PUB_CD,,
14 3
REF_RESEARCH_STATION-row_num,*REF_RESEARCH_STATION-row_num,,
15 4
REF_RESEARCH_STATION-RSCD,*REF_RESEARCH_STATION-RSCD,,
16 5
REF_RESEARCH_STATION-RS,*REF_RESEARCH_STATION-RS,,
......
22 11
REF_RESEARCH_STATION-MODIFIED_BY,*REF_RESEARCH_STATION-MODIFIED_BY,,
23 12
REF_RESEARCH_STATION-MODIFIED_DATE,*REF_RESEARCH_STATION-MODIFIED_DATE,,
24 13
REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,,
14
UNITCD,*UNITCD,,
25 15
REF_UNIT-row_num,*REF_UNIT-row_num,,
26 16
REF_UNIT-MEANING,*REF_UNIT-MEANING,,
27 17
REF_UNIT-CREATED_BY,*REF_UNIT-CREATED_BY,,
......
30 20
REF_UNIT-MODIFIED_BY,*REF_UNIT-MODIFIED_BY,,
31 21
REF_UNIT-MODIFIED_DATE,*REF_UNIT-MODIFIED_DATE,,
32 22
REF_UNIT-MODIFIED_IN_INSTANCE,*REF_UNIT-MODIFIED_IN_INSTANCE,,
23
COUNTYCD,*COUNTYCD,,
33 24
COUNTY-row_num,*COUNTY-row_num,,
34 25
county,county,,
35 26
COUNTY-CN,*COUNTY-CN,,
......
39 30
COUNTY-MODIFIED_BY,*COUNTY-MODIFIED_BY,,
40 31
COUNTY-MODIFIED_DATE,*COUNTY-MODIFIED_DATE,,
41 32
COUNTY-MODIFIED_IN_INSTANCE,*COUNTY-MODIFIED_IN_INSTANCE,,
33
INVYR,*INVYR,,
34
locationName,locationName,,
42 35
PLOT-row_num,*PLOT-row_num,,
43 36
locationID,locationID,,
44 37
PLOT-SRV_CN,*PLOT-SRV_CN,,
......
92 85
PLOT-INVASIVE_SAMPLING_STATUS_CD,*PLOT-INVASIVE_SAMPLING_STATUS_CD,,
93 86
PLOT-INVASIVE_SPECIMEN_RULE_CD,*PLOT-INVASIVE_SPECIMEN_RULE_CD,,
94 87
PLOT-DESIGNCD_P2A,*PLOT-DESIGNCD_P2A,,
88
authorEventCode,authorEventCode,,
89
HABTYPCD,*HABTYPCD,,
90
HABTYP_PUB_CD,*HABTYP_PUB_CD,,
95 91
COND-row_num,*COND-row_num,,
96 92
COND-CN,*COND-CN,,
97 93
COND-PLT_CN,*COND-PLT_CN,,
......
202 198
REF_HABTYP_DESCRIPTION-MODIFIED_BY,*REF_HABTYP_DESCRIPTION-MODIFIED_BY,,
203 199
REF_HABTYP_DESCRIPTION-MODIFIED_DATE,*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,,
204 200
REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,,
201
subplot,subplot,,
205 202
SUBPLOT-row_num,*SUBPLOT-row_num,,
206 203
subplotID,subplotID,,
207 204
SUBPLOT-PLT_CN,*SUBPLOT-PLT_CN,,
......
231 228
SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,,
232 229
SUBPLOT-INVASIVE_SUBP_STATUS_CD,*SUBPLOT-INVASIVE_SUBP_STATUS_CD,,
233 230
SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,,
231
PLANT_SYMBOL,*PLANT_SYMBOL,,
232
PLANT_SYMBOL_TYPE,*PLANT_SYMBOL_TYPE,,
233
SPCD,*SPCD,,
234 234
TREE-row_num,*TREE-row_num,,
235 235
individualObservationID,individualObservationID,,
236 236
TREE-PLT_CN,*TREE-PLT_CN,,
inputs/FIA/occurrence_all/test.xml.ref
222 222
        </path>
223 223
    </_setDefault>
224 224
</VegBIEN>
225
Inserted 27 new rows into database
225
Inserted 32 new rows into database
inputs/FIA/occurrence_all/unmapped_terms.csv
1
*PLANT_SYMBOL
2
*PLANT_SYMBOL_TYPE
3
*SPCD
4 1
*STATECD
5
*UNITCD
6
*COUNTYCD
7
*INVYR
8
*HABTYPCD
9
*HABTYP_PUB_CD
10 2
*REF_RESEARCH_STATION-row_num
11 3
*REF_RESEARCH_STATION-RSCD
12 4
*REF_RESEARCH_STATION-RS
......
17 9
*REF_RESEARCH_STATION-MODIFIED_BY
18 10
*REF_RESEARCH_STATION-MODIFIED_DATE
19 11
*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE
12
*UNITCD
20 13
*REF_UNIT-row_num
21 14
*REF_UNIT-MEANING
22 15
*REF_UNIT-CREATED_BY
......
25 18
*REF_UNIT-MODIFIED_BY
26 19
*REF_UNIT-MODIFIED_DATE
27 20
*REF_UNIT-MODIFIED_IN_INSTANCE
21
*COUNTYCD
28 22
*COUNTY-row_num
29 23
*COUNTY-CN
30 24
*COUNTY-CREATED_BY
......
33 27
*COUNTY-MODIFIED_BY
34 28
*COUNTY-MODIFIED_DATE
35 29
*COUNTY-MODIFIED_IN_INSTANCE
30
*INVYR
36 31
*PLOT-row_num
37 32
*PLOT-SRV_CN
38 33
*PLOT-CTY_CN
......
83 78
*PLOT-INVASIVE_SAMPLING_STATUS_CD
84 79
*PLOT-INVASIVE_SPECIMEN_RULE_CD
85 80
*PLOT-DESIGNCD_P2A
81
*HABTYPCD
82
*HABTYP_PUB_CD
86 83
*COND-row_num
87 84
*COND-CN
88 85
*COND-PLT_CN
......
215 212
*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD
216 213
*SUBPLOT-INVASIVE_SUBP_STATUS_CD
217 214
*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD
215
*PLANT_SYMBOL
216
*PLANT_SYMBOL_TYPE
217
*SPCD
218 218
*TREE-row_num
219 219
*TREE-PLT_CN
220 220
*TREE-PREV_TRE_CN

Also available in: Unified diff