Revision 8177
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/FIA/SUBPLOT/new_terms.csv | ||
|---|---|---|
| 1 |
row_num,*SUBPLOT.row_num,, |
|
| 1 |
row_num,"SUBPLOT |
|
| 2 |
row_num",, |
|
| 2 | 3 |
CN,subplotID,, |
| 3 |
PLT_CN,*SUBPLOT.PLT_CN,, |
|
| 4 |
PREV_SBP_CN,*SUBPLOT.PREV_SBP_CN,, |
|
| 4 |
PLT_CN,"SUBPLOT |
|
| 5 |
PLT_CN",, |
|
| 6 |
PREV_SBP_CN,"SUBPLOT |
|
| 7 |
PREV_SBP_CN",, |
|
| 5 | 8 |
PLOT,locationName,, |
| 6 | 9 |
SUBP,subplot,, |
| 7 |
SUBP_STATUS_CD,*SUBPLOT.SUBP_STATUS_CD,, |
|
| 8 |
POINT_NONSAMPLE_REASN_CD,*SUBPLOT.POINT_NONSAMPLE_REASN_CD,, |
|
| 9 |
MICRCOND,*SUBPLOT.MICRCOND,, |
|
| 10 |
SUBPCOND,*SUBPLOT.SUBPCOND,, |
|
| 11 |
MACRCOND,*SUBPLOT.MACRCOND,, |
|
| 12 |
CONDLIST,*SUBPLOT.CONDLIST,, |
|
| 13 |
SLOPE,*SUBPLOT.SLOPE,, |
|
| 14 |
ASPECT,*SUBPLOT.ASPECT,, |
|
| 15 |
WATERDEP,*SUBPLOT.WATERDEP,, |
|
| 16 |
P2A_GRM_FLG,*SUBPLOT.P2A_GRM_FLG,, |
|
| 17 |
CREATED_BY,*SUBPLOT.CREATED_BY,, |
|
| 18 |
CREATED_DATE,*SUBPLOT.CREATED_DATE,, |
|
| 19 |
CREATED_IN_INSTANCE,*SUBPLOT.CREATED_IN_INSTANCE,, |
|
| 20 |
MODIFIED_BY,*SUBPLOT.MODIFIED_BY,, |
|
| 21 |
MODIFIED_DATE,*SUBPLOT.MODIFIED_DATE,, |
|
| 22 |
MODIFIED_IN_INSTANCE,*SUBPLOT.MODIFIED_IN_INSTANCE,, |
|
| 23 |
CYCLE,*SUBPLOT.CYCLE,, |
|
| 24 |
SUBCYCLE,*SUBPLOT.SUBCYCLE,, |
|
| 25 |
ROOT_DIS_SEV_CD_PNWRS,*SUBPLOT.ROOT_DIS_SEV_CD_PNWRS,, |
|
| 26 |
NF_SUBP_STATUS_CD,*SUBPLOT.NF_SUBP_STATUS_CD,, |
|
| 27 |
NF_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT.NF_SUBP_NONSAMPLE_REASN_CD,, |
|
| 28 |
P2VEG_SUBP_STATUS_CD,*SUBPLOT.P2VEG_SUBP_STATUS_CD,, |
|
| 29 |
P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT.P2VEG_SUBP_NONSAMPLE_REASN_CD,, |
|
| 30 |
INVASIVE_SUBP_STATUS_CD,*SUBPLOT.INVASIVE_SUBP_STATUS_CD,, |
|
| 31 |
INVASIVE_NONSAMPLE_REASN_CD,*SUBPLOT.INVASIVE_NONSAMPLE_REASN_CD,, |
|
| 10 |
SUBP_STATUS_CD,"SUBPLOT |
|
| 11 |
SUBP_STATUS_CD",, |
|
| 12 |
POINT_NONSAMPLE_REASN_CD,"SUBPLOT |
|
| 13 |
POINT_NONSAMPLE_REASN_CD",, |
|
| 14 |
MICRCOND,"SUBPLOT |
|
| 15 |
MICRCOND",, |
|
| 16 |
SUBPCOND,"SUBPLOT |
|
| 17 |
SUBPCOND",, |
|
| 18 |
MACRCOND,"SUBPLOT |
|
| 19 |
MACRCOND",, |
|
| 20 |
CONDLIST,"SUBPLOT |
|
| 21 |
CONDLIST",, |
|
| 22 |
SLOPE,"SUBPLOT |
|
| 23 |
SLOPE",, |
|
| 24 |
ASPECT,"SUBPLOT |
|
| 25 |
ASPECT",, |
|
| 26 |
WATERDEP,"SUBPLOT |
|
| 27 |
WATERDEP",, |
|
| 28 |
P2A_GRM_FLG,"SUBPLOT |
|
| 29 |
P2A_GRM_FLG",, |
|
| 30 |
CREATED_BY,"SUBPLOT |
|
| 31 |
CREATED_BY",, |
|
| 32 |
CREATED_DATE,"SUBPLOT |
|
| 33 |
CREATED_DATE",, |
|
| 34 |
CREATED_IN_INSTANCE,"SUBPLOT |
|
| 35 |
CREATED_IN_INSTANCE",, |
|
| 36 |
MODIFIED_BY,"SUBPLOT |
|
| 37 |
MODIFIED_BY",, |
|
| 38 |
MODIFIED_DATE,"SUBPLOT |
|
| 39 |
MODIFIED_DATE",, |
|
| 40 |
MODIFIED_IN_INSTANCE,"SUBPLOT |
|
| 41 |
MODIFIED_IN_INSTANCE",, |
|
| 42 |
CYCLE,"SUBPLOT |
|
| 43 |
CYCLE",, |
|
| 44 |
SUBCYCLE,"SUBPLOT |
|
| 45 |
SUBCYCLE",, |
|
| 46 |
ROOT_DIS_SEV_CD_PNWRS,"SUBPLOT |
|
| 47 |
ROOT_DIS_SEV_CD_PNWRS",, |
|
| 48 |
NF_SUBP_STATUS_CD,"SUBPLOT |
|
| 49 |
NF_SUBP_STATUS_CD",, |
|
| 50 |
NF_SUBP_NONSAMPLE_REASN_CD,"SUBPLOT |
|
| 51 |
NF_SUBP_NONSAMPLE_REASN_CD",, |
|
| 52 |
P2VEG_SUBP_STATUS_CD,"SUBPLOT |
|
| 53 |
P2VEG_SUBP_STATUS_CD",, |
|
| 54 |
P2VEG_SUBP_NONSAMPLE_REASN_CD,"SUBPLOT |
|
| 55 |
P2VEG_SUBP_NONSAMPLE_REASN_CD",, |
|
| 56 |
INVASIVE_SUBP_STATUS_CD,"SUBPLOT |
|
| 57 |
INVASIVE_SUBP_STATUS_CD",, |
|
| 58 |
INVASIVE_NONSAMPLE_REASN_CD,"SUBPLOT |
|
| 59 |
INVASIVE_NONSAMPLE_REASN_CD",, |
|
| inputs/FIA/REF_RESEARCH_STATION/new_terms.csv | ||
|---|---|---|
| 1 |
row_num,*REF_RESEARCH_STATION.row_num,, |
|
| 2 |
RSCD,*REF_RESEARCH_STATION.RSCD,, |
|
| 3 |
RS,*REF_RESEARCH_STATION.RS,, |
|
| 1 |
row_num,"REF_RESEARCH_STATION |
|
| 2 |
row_num",, |
|
| 3 |
RSCD,"REF_RESEARCH_STATION |
|
| 4 |
RSCD",, |
|
| 5 |
RS,"REF_RESEARCH_STATION |
|
| 6 |
RS",, |
|
| 4 | 7 |
STATE_NAME,stateProvince,, |
| 5 |
STATE_ABBR,*REF_RESEARCH_STATION.STATE_ABBR,, |
|
| 6 |
CREATED_BY,*REF_RESEARCH_STATION.CREATED_BY,, |
|
| 7 |
CREATED_DATE,*REF_RESEARCH_STATION.CREATED_DATE,, |
|
| 8 |
CREATED_IN_INSTANCE,*REF_RESEARCH_STATION.CREATED_IN_INSTANCE,, |
|
| 9 |
MODIFIED_BY,*REF_RESEARCH_STATION.MODIFIED_BY,, |
|
| 10 |
MODIFIED_DATE,*REF_RESEARCH_STATION.MODIFIED_DATE,, |
|
| 11 |
MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION.MODIFIED_IN_INSTANCE,, |
|
| 8 |
STATE_ABBR,"REF_RESEARCH_STATION |
|
| 9 |
STATE_ABBR",, |
|
| 10 |
CREATED_BY,"REF_RESEARCH_STATION |
|
| 11 |
CREATED_BY",, |
|
| 12 |
CREATED_DATE,"REF_RESEARCH_STATION |
|
| 13 |
CREATED_DATE",, |
|
| 14 |
CREATED_IN_INSTANCE,"REF_RESEARCH_STATION |
|
| 15 |
CREATED_IN_INSTANCE",, |
|
| 16 |
MODIFIED_BY,"REF_RESEARCH_STATION |
|
| 17 |
MODIFIED_BY",, |
|
| 18 |
MODIFIED_DATE,"REF_RESEARCH_STATION |
|
| 19 |
MODIFIED_DATE",, |
|
| 20 |
MODIFIED_IN_INSTANCE,"REF_RESEARCH_STATION |
|
| 21 |
MODIFIED_IN_INSTANCE",, |
|
| inputs/FIA/TREE/new_terms.csv | ||
|---|---|---|
| 1 |
row_num,*TREE.row_num,, |
|
| 1 |
row_num,"TREE |
|
| 2 |
row_num",, |
|
| 2 | 3 |
CN,individualObservationID,, |
| 3 |
PLT_CN,*TREE.PLT_CN,, |
|
| 4 |
PREV_TRE_CN,*TREE.PREV_TRE_CN,, |
|
| 4 |
PLT_CN,"TREE |
|
| 5 |
PLT_CN",, |
|
| 6 |
PREV_TRE_CN,"TREE |
|
| 7 |
PREV_TRE_CN",, |
|
| 5 | 8 |
PLOT,locationName,, |
| 6 | 9 |
SUBP,subplot,, |
| 7 | 10 |
TREE,individualCode,, |
| 8 | 11 |
CONDID,authorEventCode,, |
| 9 |
AZIMUTH,*TREE.AZIMUTH,, |
|
| 10 |
DIST,*TREE.DIST,, |
|
| 11 |
PREVCOND,*TREE.PREVCOND,, |
|
| 12 |
STATUSCD,*TREE.STATUSCD,, |
|
| 13 |
SPGRPCD,*TREE.SPGRPCD,, |
|
| 12 |
AZIMUTH,"TREE |
|
| 13 |
AZIMUTH",, |
|
| 14 |
DIST,"TREE |
|
| 15 |
DIST",, |
|
| 16 |
PREVCOND,"TREE |
|
| 17 |
PREVCOND",, |
|
| 18 |
STATUSCD,"TREE |
|
| 19 |
STATUSCD",, |
|
| 20 |
SPGRPCD,"TREE |
|
| 21 |
SPGRPCD",, |
|
| 14 | 22 |
DIA,diameterBreastHeight_in,,"""dbh in inches (convert to cm) IF DIAHTCD=1. Otherwise, measured at ground level (see DIAHTCD)."" (bboyle@email.arizona.edu/Brad_Boyle.2013-2-8.[FIA+tables+and+columns+to+import+to+BIEN.docx])" |
| 15 |
DIAHTCD,*TREE.DIAHTCD,,"""DIAHTCD=1: DIA measured at breast height (=dbh); DIAHTCD=1: DIA measured at root crown (basically, near ground). We should discuss where to put these measurements."" (bboyle@email.arizona.edu/Brad_Boyle.2013-2-8.[FIA+tables+and+columns+to+import+to+BIEN.docx])" |
|
| 23 |
DIAHTCD,"TREE |
|
| 24 |
DIAHTCD",,"""DIAHTCD=1: DIA measured at breast height (=dbh); DIAHTCD=1: DIA measured at root crown (basically, near ground). We should discuss where to put these measurements."" (bboyle@email.arizona.edu/Brad_Boyle.2013-2-8.[FIA+tables+and+columns+to+import+to+BIEN.docx])" |
|
| 16 | 25 |
HT,height_ft,,"""height in ft. Convert to m."" (bboyle@email.arizona.edu/Brad_Boyle.2013-2-8.[FIA+tables+and+columns+to+import+to+BIEN.docx])" |
| 17 |
HTCD,*TREE.HTCD,, |
|
| 18 |
ACTUALHT,*TREE.ACTUALHT,, |
|
| 19 |
TREECLCD,*TREE.TREECLCD,, |
|
| 20 |
CR,*TREE.CR,, |
|
| 21 |
CCLCD,*TREE.CCLCD,, |
|
| 22 |
TREEGRCD,*TREE.TREEGRCD,, |
|
| 23 |
AGENTCD,*TREE.AGENTCD,, |
|
| 24 |
CULL,*TREE.CULL,, |
|
| 25 |
DAMLOC1,*TREE.DAMLOC1,, |
|
| 26 |
DAMTYP1,*TREE.DAMTYP1,, |
|
| 27 |
DAMSEV1,*TREE.DAMSEV1,, |
|
| 28 |
DAMLOC2,*TREE.DAMLOC2,, |
|
| 29 |
DAMTYP2,*TREE.DAMTYP2,, |
|
| 30 |
DAMSEV2,*TREE.DAMSEV2,, |
|
| 31 |
DECAYCD,*TREE.DECAYCD,, |
|
| 32 |
STOCKING,*TREE.STOCKING,, |
|
| 33 |
WDLDSTEM,*TREE.WDLDSTEM,, |
|
| 34 |
VOLCFNET,*TREE.VOLCFNET,, |
|
| 35 |
VOLCFGRS,*TREE.VOLCFGRS,, |
|
| 36 |
VOLCSNET,*TREE.VOLCSNET,, |
|
| 37 |
VOLCSGRS,*TREE.VOLCSGRS,, |
|
| 38 |
VOLBFNET,*TREE.VOLBFNET,, |
|
| 39 |
VOLBFGRS,*TREE.VOLBFGRS,, |
|
| 40 |
VOLCFSND,*TREE.VOLCFSND,, |
|
| 41 |
GROWCFGS,*TREE.GROWCFGS,, |
|
| 42 |
GROWBFSL,*TREE.GROWBFSL,, |
|
| 43 |
GROWCFAL,*TREE.GROWCFAL,, |
|
| 44 |
MORTCFGS,*TREE.MORTCFGS,, |
|
| 45 |
MORTBFSL,*TREE.MORTBFSL,, |
|
| 46 |
MORTCFAL,*TREE.MORTCFAL,, |
|
| 47 |
REMVCFGS,*TREE.REMVCFGS,, |
|
| 48 |
REMVBFSL,*TREE.REMVBFSL,, |
|
| 49 |
REMVCFAL,*TREE.REMVCFAL,, |
|
| 50 |
DIACHECK,*TREE.DIACHECK,, |
|
| 51 |
MORTYR,*TREE.MORTYR,, |
|
| 52 |
SALVCD,*TREE.SALVCD,, |
|
| 53 |
UNCRCD,*TREE.UNCRCD,, |
|
| 54 |
CPOSCD,*TREE.CPOSCD,, |
|
| 55 |
CLIGHTCD,*TREE.CLIGHTCD,, |
|
| 56 |
CVIGORCD,*TREE.CVIGORCD,, |
|
| 57 |
CDENCD,*TREE.CDENCD,, |
|
| 58 |
CDIEBKCD,*TREE.CDIEBKCD,, |
|
| 59 |
TRANSCD,*TREE.TRANSCD,, |
|
| 60 |
TREEHISTCD,*TREE.TREEHISTCD,, |
|
| 61 |
DIACALC,*TREE.DIACALC,, |
|
| 62 |
BHAGE,*TREE.BHAGE,, |
|
| 63 |
TOTAGE,*TREE.TOTAGE,, |
|
| 64 |
CULLDEAD,*TREE.CULLDEAD,, |
|
| 65 |
CULLFORM,*TREE.CULLFORM,, |
|
| 66 |
CULLMSTOP,*TREE.CULLMSTOP,, |
|
| 67 |
CULLBF,*TREE.CULLBF,, |
|
| 68 |
CULLCF,*TREE.CULLCF,, |
|
| 69 |
BFSND,*TREE.BFSND,, |
|
| 70 |
CFSND,*TREE.CFSND,, |
|
| 71 |
SAWHT,*TREE.SAWHT,, |
|
| 72 |
FORMCL,*TREE.FORMCL,, |
|
| 73 |
HTCALC,*TREE.HTCALC,, |
|
| 74 |
HRDWD_CLUMP_CD,*TREE.HRDWD_CLUMP_CD,, |
|
| 75 |
SITREE,*TREE.SITREE,, |
|
| 76 |
CREATED_BY,*TREE.CREATED_BY,, |
|
| 77 |
CREATED_DATE,*TREE.CREATED_DATE,, |
|
| 78 |
CREATED_IN_INSTANCE,*TREE.CREATED_IN_INSTANCE,, |
|
| 79 |
MODIFIED_BY,*TREE.MODIFIED_BY,, |
|
| 80 |
MODIFIED_DATE,*TREE.MODIFIED_DATE,, |
|
| 81 |
MODIFIED_IN_INSTANCE,*TREE.MODIFIED_IN_INSTANCE,, |
|
| 82 |
MORTCD,*TREE.MORTCD,, |
|
| 83 |
HTDMP,*TREE.HTDMP,, |
|
| 84 |
ROUGHCULL,*TREE.ROUGHCULL,, |
|
| 85 |
MIST_CL_CD,*TREE.MIST_CL_CD,, |
|
| 86 |
CULL_FLD,*TREE.CULL_FLD,, |
|
| 87 |
RECONCILECD,*TREE.RECONCILECD,, |
|
| 88 |
PREVDIA,*TREE.PREVDIA,, |
|
| 89 |
FGROWCFGS,*TREE.FGROWCFGS,, |
|
| 90 |
FGROWBFSL,*TREE.FGROWBFSL,, |
|
| 91 |
FGROWCFAL,*TREE.FGROWCFAL,, |
|
| 92 |
FMORTCFGS,*TREE.FMORTCFGS,, |
|
| 93 |
FMORTBFSL,*TREE.FMORTBFSL,, |
|
| 94 |
FMORTCFAL,*TREE.FMORTCFAL,, |
|
| 95 |
FREMVCFGS,*TREE.FREMVCFGS,, |
|
| 96 |
FREMVBFSL,*TREE.FREMVBFSL,, |
|
| 97 |
FREMVCFAL,*TREE.FREMVCFAL,, |
|
| 98 |
P2A_GRM_FLG,*TREE.P2A_GRM_FLG,, |
|
| 99 |
TREECLCD_NERS,*TREE.TREECLCD_NERS,, |
|
| 100 |
TREECLCD_SRS,*TREE.TREECLCD_SRS,, |
|
| 101 |
TREECLCD_NCRS,*TREE.TREECLCD_NCRS,, |
|
| 102 |
TREECLCD_RMRS,*TREE.TREECLCD_RMRS,, |
|
| 103 |
STANDING_DEAD_CD,*TREE.STANDING_DEAD_CD,, |
|
| 104 |
PREV_STATUS_CD,*TREE.PREV_STATUS_CD,, |
|
| 105 |
PREV_WDLDSTEM,*TREE.PREV_WDLDSTEM,, |
|
| 106 |
TPA_UNADJ,*TREE.TPA_UNADJ,, |
|
| 107 |
TPAMORT_UNADJ,*TREE.TPAMORT_UNADJ,, |
|
| 108 |
TPAREMV_UNADJ,*TREE.TPAREMV_UNADJ,, |
|
| 109 |
TPAGROW_UNADJ,*TREE.TPAGROW_UNADJ,, |
|
| 110 |
DRYBIO_BOLE,*TREE.DRYBIO_BOLE,, |
|
| 111 |
DRYBIO_TOP,*TREE.DRYBIO_TOP,, |
|
| 112 |
DRYBIO_STUMP,*TREE.DRYBIO_STUMP,, |
|
| 113 |
DRYBIO_SAPLING,*TREE.DRYBIO_SAPLING,, |
|
| 114 |
DRYBIO_WDLD_SPP,*TREE.DRYBIO_WDLD_SPP,, |
|
| 115 |
DRYBIO_BG,*TREE.DRYBIO_BG,, |
|
| 116 |
CARBON_AG,*TREE.CARBON_AG,, |
|
| 117 |
CARBON_BG,*TREE.CARBON_BG,, |
|
| 118 |
CYCLE,*TREE.CYCLE,, |
|
| 119 |
SUBCYCLE,*TREE.SUBCYCLE,, |
|
| 120 |
BORED_CD_PNWRS,*TREE.BORED_CD_PNWRS,, |
|
| 121 |
DAMLOC1_PNWRS,*TREE.DAMLOC1_PNWRS,, |
|
| 122 |
DAMLOC2_PNWRS,*TREE.DAMLOC2_PNWRS,, |
|
| 123 |
DIACHECK_PNWRS,*TREE.DIACHECK_PNWRS,, |
|
| 124 |
DMG_AGENT1_CD_PNWRS,*TREE.DMG_AGENT1_CD_PNWRS,, |
|
| 125 |
DMG_AGENT2_CD_PNWRS,*TREE.DMG_AGENT2_CD_PNWRS,, |
|
| 126 |
DMG_AGENT3_CD_PNWRS,*TREE.DMG_AGENT3_CD_PNWRS,, |
|
| 127 |
MIST_CL_CD_PNWRS,*TREE.MIST_CL_CD_PNWRS,, |
|
| 128 |
SEVERITY1_CD_PNWRS,*TREE.SEVERITY1_CD_PNWRS,, |
|
| 129 |
SEVERITY1A_CD_PNWRS,*TREE.SEVERITY1A_CD_PNWRS,, |
|
| 130 |
SEVERITY1B_CD_PNWRS,*TREE.SEVERITY1B_CD_PNWRS,, |
|
| 131 |
SEVERITY2_CD_PNWRS,*TREE.SEVERITY2_CD_PNWRS,, |
|
| 132 |
SEVERITY2A_CD_PNWRS,*TREE.SEVERITY2A_CD_PNWRS,, |
|
| 133 |
SEVERITY2B_CD_PNWRS,*TREE.SEVERITY2B_CD_PNWRS,, |
|
| 134 |
SEVERITY3_CD_PNWRS,*TREE.SEVERITY3_CD_PNWRS,, |
|
| 135 |
UNKNOWN_DAMTYP1_PNWRS,*TREE.UNKNOWN_DAMTYP1_PNWRS,, |
|
| 136 |
UNKNOWN_DAMTYP2_PNWRS,*TREE.UNKNOWN_DAMTYP2_PNWRS,, |
|
| 137 |
PREV_PNTN_SRS,*TREE.PREV_PNTN_SRS,, |
|
| 138 |
DISEASE_SRS,*TREE.DISEASE_SRS,, |
|
| 139 |
DIEBACK_SEVERITY_SRS,*TREE.DIEBACK_SEVERITY_SRS,, |
|
| 26 |
HTCD,"TREE |
|
| 27 |
HTCD",, |
|
| 28 |
ACTUALHT,"TREE |
|
| 29 |
ACTUALHT",, |
|
| 30 |
TREECLCD,"TREE |
|
| 31 |
TREECLCD",, |
|
| 32 |
CR,"TREE |
|
| 33 |
CR",, |
|
| 34 |
CCLCD,"TREE |
|
| 35 |
CCLCD",, |
|
| 36 |
TREEGRCD,"TREE |
|
| 37 |
TREEGRCD",, |
|
| 38 |
AGENTCD,"TREE |
|
| 39 |
AGENTCD",, |
|
| 40 |
CULL,"TREE |
|
| 41 |
CULL",, |
|
| 42 |
DAMLOC1,"TREE |
|
| 43 |
DAMLOC1",, |
|
| 44 |
DAMTYP1,"TREE |
|
| 45 |
DAMTYP1",, |
|
| 46 |
DAMSEV1,"TREE |
|
| 47 |
DAMSEV1",, |
|
| 48 |
DAMLOC2,"TREE |
|
| 49 |
DAMLOC2",, |
|
| 50 |
DAMTYP2,"TREE |
|
| 51 |
DAMTYP2",, |
|
| 52 |
DAMSEV2,"TREE |
|
| 53 |
DAMSEV2",, |
|
| 54 |
DECAYCD,"TREE |
|
| 55 |
DECAYCD",, |
|
| 56 |
STOCKING,"TREE |
|
| 57 |
STOCKING",, |
|
| 58 |
WDLDSTEM,"TREE |
|
| 59 |
WDLDSTEM",, |
|
| 60 |
VOLCFNET,"TREE |
|
| 61 |
VOLCFNET",, |
|
| 62 |
VOLCFGRS,"TREE |
|
| 63 |
VOLCFGRS",, |
|
| 64 |
VOLCSNET,"TREE |
|
| 65 |
VOLCSNET",, |
|
| 66 |
VOLCSGRS,"TREE |
|
| 67 |
VOLCSGRS",, |
|
| 68 |
VOLBFNET,"TREE |
|
| 69 |
VOLBFNET",, |
|
| 70 |
VOLBFGRS,"TREE |
|
| 71 |
VOLBFGRS",, |
|
| 72 |
VOLCFSND,"TREE |
|
| 73 |
VOLCFSND",, |
|
| 74 |
GROWCFGS,"TREE |
|
| 75 |
GROWCFGS",, |
|
| 76 |
GROWBFSL,"TREE |
|
| 77 |
GROWBFSL",, |
|
| 78 |
GROWCFAL,"TREE |
|
| 79 |
GROWCFAL",, |
|
| 80 |
MORTCFGS,"TREE |
|
| 81 |
MORTCFGS",, |
|
| 82 |
MORTBFSL,"TREE |
|
| 83 |
MORTBFSL",, |
|
| 84 |
MORTCFAL,"TREE |
|
| 85 |
MORTCFAL",, |
|
| 86 |
REMVCFGS,"TREE |
|
| 87 |
REMVCFGS",, |
|
| 88 |
REMVBFSL,"TREE |
|
| 89 |
REMVBFSL",, |
|
| 90 |
REMVCFAL,"TREE |
|
| 91 |
REMVCFAL",, |
|
| 92 |
DIACHECK,"TREE |
|
| 93 |
DIACHECK",, |
|
| 94 |
MORTYR,"TREE |
|
| 95 |
MORTYR",, |
|
| 96 |
SALVCD,"TREE |
|
| 97 |
SALVCD",, |
|
| 98 |
UNCRCD,"TREE |
|
| 99 |
UNCRCD",, |
|
| 100 |
CPOSCD,"TREE |
|
| 101 |
CPOSCD",, |
|
| 102 |
CLIGHTCD,"TREE |
|
| 103 |
CLIGHTCD",, |
|
| 104 |
CVIGORCD,"TREE |
|
| 105 |
CVIGORCD",, |
|
| 106 |
CDENCD,"TREE |
|
| 107 |
CDENCD",, |
|
| 108 |
CDIEBKCD,"TREE |
|
| 109 |
CDIEBKCD",, |
|
| 110 |
TRANSCD,"TREE |
|
| 111 |
TRANSCD",, |
|
| 112 |
TREEHISTCD,"TREE |
|
| 113 |
TREEHISTCD",, |
|
| 114 |
DIACALC,"TREE |
|
| 115 |
DIACALC",, |
|
| 116 |
BHAGE,"TREE |
|
| 117 |
BHAGE",, |
|
| 118 |
TOTAGE,"TREE |
|
| 119 |
TOTAGE",, |
|
| 120 |
CULLDEAD,"TREE |
|
| 121 |
CULLDEAD",, |
|
| 122 |
CULLFORM,"TREE |
|
| 123 |
CULLFORM",, |
|
| 124 |
CULLMSTOP,"TREE |
|
| 125 |
CULLMSTOP",, |
|
| 126 |
CULLBF,"TREE |
|
| 127 |
CULLBF",, |
|
| 128 |
CULLCF,"TREE |
|
| 129 |
CULLCF",, |
|
| 130 |
BFSND,"TREE |
|
| 131 |
BFSND",, |
|
| 132 |
CFSND,"TREE |
|
| 133 |
CFSND",, |
|
| 134 |
SAWHT,"TREE |
|
| 135 |
SAWHT",, |
|
| 136 |
FORMCL,"TREE |
|
| 137 |
FORMCL",, |
|
| 138 |
HTCALC,"TREE |
|
| 139 |
HTCALC",, |
|
| 140 |
HRDWD_CLUMP_CD,"TREE |
|
| 141 |
HRDWD_CLUMP_CD",, |
|
| 142 |
SITREE,"TREE |
|
| 143 |
SITREE",, |
|
| 144 |
CREATED_BY,"TREE |
|
| 145 |
CREATED_BY",, |
|
| 146 |
CREATED_DATE,"TREE |
|
| 147 |
CREATED_DATE",, |
|
| 148 |
CREATED_IN_INSTANCE,"TREE |
|
| 149 |
CREATED_IN_INSTANCE",, |
|
| 150 |
MODIFIED_BY,"TREE |
|
| 151 |
MODIFIED_BY",, |
|
| 152 |
MODIFIED_DATE,"TREE |
|
| 153 |
MODIFIED_DATE",, |
|
| 154 |
MODIFIED_IN_INSTANCE,"TREE |
|
| 155 |
MODIFIED_IN_INSTANCE",, |
|
| 156 |
MORTCD,"TREE |
|
| 157 |
MORTCD",, |
|
| 158 |
HTDMP,"TREE |
|
| 159 |
HTDMP",, |
|
| 160 |
ROUGHCULL,"TREE |
|
| 161 |
ROUGHCULL",, |
|
| 162 |
MIST_CL_CD,"TREE |
|
| 163 |
MIST_CL_CD",, |
|
| 164 |
CULL_FLD,"TREE |
|
| 165 |
CULL_FLD",, |
|
| 166 |
RECONCILECD,"TREE |
|
| 167 |
RECONCILECD",, |
|
| 168 |
PREVDIA,"TREE |
|
| 169 |
PREVDIA",, |
|
| 170 |
FGROWCFGS,"TREE |
|
| 171 |
FGROWCFGS",, |
|
| 172 |
FGROWBFSL,"TREE |
|
| 173 |
FGROWBFSL",, |
|
| 174 |
FGROWCFAL,"TREE |
|
| 175 |
FGROWCFAL",, |
|
| 176 |
FMORTCFGS,"TREE |
|
| 177 |
FMORTCFGS",, |
|
| 178 |
FMORTBFSL,"TREE |
|
| 179 |
FMORTBFSL",, |
|
| 180 |
FMORTCFAL,"TREE |
|
| 181 |
FMORTCFAL",, |
|
| 182 |
FREMVCFGS,"TREE |
|
| 183 |
FREMVCFGS",, |
|
| 184 |
FREMVBFSL,"TREE |
|
| 185 |
FREMVBFSL",, |
|
| 186 |
FREMVCFAL,"TREE |
|
| 187 |
FREMVCFAL",, |
|
| 188 |
P2A_GRM_FLG,"TREE |
|
| 189 |
P2A_GRM_FLG",, |
|
| 190 |
TREECLCD_NERS,"TREE |
|
| 191 |
TREECLCD_NERS",, |
|
| 192 |
TREECLCD_SRS,"TREE |
|
| 193 |
TREECLCD_SRS",, |
|
| 194 |
TREECLCD_NCRS,"TREE |
|
| 195 |
TREECLCD_NCRS",, |
|
| 196 |
TREECLCD_RMRS,"TREE |
|
| 197 |
TREECLCD_RMRS",, |
|
| 198 |
STANDING_DEAD_CD,"TREE |
|
| 199 |
STANDING_DEAD_CD",, |
|
| 200 |
PREV_STATUS_CD,"TREE |
|
| 201 |
PREV_STATUS_CD",, |
|
| 202 |
PREV_WDLDSTEM,"TREE |
|
| 203 |
PREV_WDLDSTEM",, |
|
| 204 |
TPA_UNADJ,"TREE |
|
| 205 |
TPA_UNADJ",, |
|
| 206 |
TPAMORT_UNADJ,"TREE |
|
| 207 |
TPAMORT_UNADJ",, |
|
| 208 |
TPAREMV_UNADJ,"TREE |
|
| 209 |
TPAREMV_UNADJ",, |
|
| 210 |
TPAGROW_UNADJ,"TREE |
|
| 211 |
TPAGROW_UNADJ",, |
|
| 212 |
DRYBIO_BOLE,"TREE |
|
| 213 |
DRYBIO_BOLE",, |
|
| 214 |
DRYBIO_TOP,"TREE |
|
| 215 |
DRYBIO_TOP",, |
|
| 216 |
DRYBIO_STUMP,"TREE |
|
| 217 |
DRYBIO_STUMP",, |
|
| 218 |
DRYBIO_SAPLING,"TREE |
|
| 219 |
DRYBIO_SAPLING",, |
|
| 220 |
DRYBIO_WDLD_SPP,"TREE |
|
| 221 |
DRYBIO_WDLD_SPP",, |
|
| 222 |
DRYBIO_BG,"TREE |
|
| 223 |
DRYBIO_BG",, |
|
| 224 |
CARBON_AG,"TREE |
|
| 225 |
CARBON_AG",, |
|
| 226 |
CARBON_BG,"TREE |
|
| 227 |
CARBON_BG",, |
|
| 228 |
CYCLE,"TREE |
|
| 229 |
CYCLE",, |
|
| 230 |
SUBCYCLE,"TREE |
|
| 231 |
SUBCYCLE",, |
|
| 232 |
BORED_CD_PNWRS,"TREE |
|
| 233 |
BORED_CD_PNWRS",, |
|
| 234 |
DAMLOC1_PNWRS,"TREE |
|
| 235 |
DAMLOC1_PNWRS",, |
|
| 236 |
DAMLOC2_PNWRS,"TREE |
|
| 237 |
DAMLOC2_PNWRS",, |
|
| 238 |
DIACHECK_PNWRS,"TREE |
|
| 239 |
DIACHECK_PNWRS",, |
|
| 240 |
DMG_AGENT1_CD_PNWRS,"TREE |
|
| 241 |
DMG_AGENT1_CD_PNWRS",, |
|
| 242 |
DMG_AGENT2_CD_PNWRS,"TREE |
|
| 243 |
DMG_AGENT2_CD_PNWRS",, |
|
| 244 |
DMG_AGENT3_CD_PNWRS,"TREE |
|
| 245 |
DMG_AGENT3_CD_PNWRS",, |
|
| 246 |
MIST_CL_CD_PNWRS,"TREE |
|
| 247 |
MIST_CL_CD_PNWRS",, |
|
| 248 |
SEVERITY1_CD_PNWRS,"TREE |
|
| 249 |
SEVERITY1_CD_PNWRS",, |
|
| 250 |
SEVERITY1A_CD_PNWRS,"TREE |
|
| 251 |
SEVERITY1A_CD_PNWRS",, |
|
| 252 |
SEVERITY1B_CD_PNWRS,"TREE |
|
| 253 |
SEVERITY1B_CD_PNWRS",, |
|
| 254 |
SEVERITY2_CD_PNWRS,"TREE |
|
| 255 |
SEVERITY2_CD_PNWRS",, |
|
| 256 |
SEVERITY2A_CD_PNWRS,"TREE |
|
| 257 |
SEVERITY2A_CD_PNWRS",, |
|
| 258 |
SEVERITY2B_CD_PNWRS,"TREE |
|
| 259 |
SEVERITY2B_CD_PNWRS",, |
|
| 260 |
SEVERITY3_CD_PNWRS,"TREE |
|
| 261 |
SEVERITY3_CD_PNWRS",, |
|
| 262 |
UNKNOWN_DAMTYP1_PNWRS,"TREE |
|
| 263 |
UNKNOWN_DAMTYP1_PNWRS",, |
|
| 264 |
UNKNOWN_DAMTYP2_PNWRS,"TREE |
|
| 265 |
UNKNOWN_DAMTYP2_PNWRS",, |
|
| 266 |
PREV_PNTN_SRS,"TREE |
|
| 267 |
PREV_PNTN_SRS",, |
|
| 268 |
DISEASE_SRS,"TREE |
|
| 269 |
DISEASE_SRS",, |
|
| 270 |
DIEBACK_SEVERITY_SRS,"TREE |
|
| 271 |
DIEBACK_SEVERITY_SRS",, |
|
| inputs/FIA/COND_unique/map.csv | ||
|---|---|---|
| 1 | 1 |
FIA,VegCore,Filter,Comments |
| 2 |
row_num,*row_num,,
|
|
| 3 |
CN,*CN,,
|
|
| 2 |
row_num,row_num,, |
|
| 3 |
CN,CN,, |
|
| 4 | 4 |
PLT_CN,locationID,, |
| 5 |
INVYR,*INVYR,,
|
|
| 6 |
STATECD,*STATECD,,
|
|
| 7 |
UNITCD,*UNITCD,,
|
|
| 8 |
COUNTYCD,*COUNTYCD,,
|
|
| 9 |
PLOT,*PLOT,,
|
|
| 10 |
CONDID,*CONDID,,
|
|
| 11 |
COND_STATUS_CD,*COND_STATUS_CD,,
|
|
| 12 |
COND_NONSAMPLE_REASN_CD,*COND_NONSAMPLE_REASN_CD,,
|
|
| 13 |
RESERVCD,*RESERVCD,,
|
|
| 14 |
OWNCD,*OWNCD,,
|
|
| 15 |
OWNGRPCD,*OWNGRPCD,,
|
|
| 16 |
FORINDCD,*FORINDCD,,
|
|
| 17 |
ADFORCD,*ADFORCD,,
|
|
| 18 |
FORTYPCD,*FORTYPCD,,
|
|
| 19 |
FLDTYPCD,*FLDTYPCD,,
|
|
| 20 |
MAPDEN,*MAPDEN,,
|
|
| 21 |
STDAGE,*STDAGE,,
|
|
| 22 |
STDSZCD,*STDSZCD,,
|
|
| 23 |
FLDSZCD,*FLDSZCD,,
|
|
| 24 |
SITECLCD,*SITECLCD,,
|
|
| 25 |
SICOND,*SICOND,,
|
|
| 26 |
SIBASE,*SIBASE,,
|
|
| 27 |
SISP,*SISP,,
|
|
| 28 |
STDORGCD,*STDORGCD,,
|
|
| 29 |
STDORGSP,*STDORGSP,,
|
|
| 30 |
PROP_BASIS,*PROP_BASIS,,
|
|
| 31 |
CONDPROP_UNADJ,*CONDPROP_UNADJ,,
|
|
| 32 |
MICRPROP_UNADJ,*MICRPROP_UNADJ,,
|
|
| 33 |
SUBPPROP_UNADJ,*SUBPPROP_UNADJ,,
|
|
| 34 |
MACRPROP_UNADJ,*MACRPROP_UNADJ,,
|
|
| 35 |
SLOPE,*SLOPE,,
|
|
| 36 |
ASPECT,*ASPECT,,
|
|
| 37 |
PHYSCLCD,*PHYSCLCD,,
|
|
| 38 |
GSSTKCD,*GSSTKCD,,
|
|
| 39 |
ALSTKCD,*ALSTKCD,,
|
|
| 40 |
DSTRBCD1,*DSTRBCD1,,
|
|
| 41 |
DSTRBYR1,*DSTRBYR1,,
|
|
| 42 |
DSTRBCD2,*DSTRBCD2,,
|
|
| 43 |
DSTRBYR2,*DSTRBYR2,,
|
|
| 44 |
DSTRBCD3,*DSTRBCD3,,
|
|
| 45 |
DSTRBYR3,*DSTRBYR3,,
|
|
| 46 |
TRTCD1,*TRTCD1,,
|
|
| 47 |
TRTYR1,*TRTYR1,,
|
|
| 48 |
TRTCD2,*TRTCD2,,
|
|
| 49 |
TRTYR2,*TRTYR2,,
|
|
| 50 |
TRTCD3,*TRTCD3,,
|
|
| 51 |
TRTYR3,*TRTYR3,,
|
|
| 52 |
PRESNFCD,*PRESNFCD,,
|
|
| 53 |
BALIVE,*BALIVE,,
|
|
| 54 |
FLDAGE,*FLDAGE,,
|
|
| 55 |
ALSTK,*ALSTK,,
|
|
| 56 |
GSSTK,*GSSTK,,
|
|
| 57 |
FORTYPCDCALC,*FORTYPCDCALC,,
|
|
| 58 |
HABTYPCD1,*HABTYPCD1,,
|
|
| 59 |
HABTYPCD1_PUB_CD,*HABTYPCD1_PUB_CD,,
|
|
| 60 |
HABTYPCD1_DESCR_PUB_CD,*HABTYPCD1_DESCR_PUB_CD,,
|
|
| 61 |
HABTYPCD2,*HABTYPCD2,,
|
|
| 62 |
HABTYPCD2_PUB_CD,*HABTYPCD2_PUB_CD,,
|
|
| 63 |
HABTYPCD2_DESCR_PUB_CD,*HABTYPCD2_DESCR_PUB_CD,,
|
|
| 64 |
MIXEDCONFCD,*MIXEDCONFCD,,
|
|
| 65 |
VOL_LOC_GRP,*VOL_LOC_GRP,,
|
|
| 66 |
SITECLCDEST,*SITECLCDEST,,
|
|
| 67 |
SITETREE_TREE,*SITETREE_TREE,,
|
|
| 68 |
SITECL_METHOD,*SITECL_METHOD,,
|
|
| 69 |
CARBON_DOWN_DEAD,*CARBON_DOWN_DEAD,,
|
|
| 70 |
CARBON_LITTER,*CARBON_LITTER,,
|
|
| 71 |
CARBON_SOIL_ORG,*CARBON_SOIL_ORG,,
|
|
| 72 |
CARBON_STANDING_DEAD,*CARBON_STANDING_DEAD,,
|
|
| 73 |
CARBON_UNDERSTORY_AG,*CARBON_UNDERSTORY_AG,,
|
|
| 74 |
CARBON_UNDERSTORY_BG,*CARBON_UNDERSTORY_BG,,
|
|
| 75 |
CREATED_BY,*CREATED_BY,,
|
|
| 76 |
CREATED_DATE,*CREATED_DATE,,
|
|
| 77 |
CREATED_IN_INSTANCE,*CREATED_IN_INSTANCE,,
|
|
| 78 |
MODIFIED_BY,*MODIFIED_BY,,
|
|
| 79 |
MODIFIED_DATE,*MODIFIED_DATE,,
|
|
| 80 |
MODIFIED_IN_INSTANCE,*MODIFIED_IN_INSTANCE,,
|
|
| 81 |
CYCLE,*CYCLE,,
|
|
| 82 |
SUBCYCLE,*SUBCYCLE,,
|
|
| 83 |
SOIL_ROOTING_DEPTH_PNW,*SOIL_ROOTING_DEPTH_PNW,,
|
|
| 84 |
GROUND_LAND_CLASS_PNW,*GROUND_LAND_CLASS_PNW,,
|
|
| 85 |
PLANT_STOCKABILITY_FACTOR_PNW,*PLANT_STOCKABILITY_FACTOR_PNW,,
|
|
| 86 |
STND_COND_CD_PNWRS,*STND_COND_CD_PNWRS,,
|
|
| 87 |
STND_STRUC_CD_PNWRS,*STND_STRUC_CD_PNWRS,,
|
|
| 88 |
STUMP_CD_PNWRS,*STUMP_CD_PNWRS,,
|
|
| 89 |
FIRE_SRS,*FIRE_SRS,,
|
|
| 90 |
GRAZING_SRS,*GRAZING_SRS,,
|
|
| 91 |
HARVEST_TYPE1_SRS,*HARVEST_TYPE1_SRS,,
|
|
| 92 |
HARVEST_TYPE2_SRS,*HARVEST_TYPE2_SRS,,
|
|
| 93 |
HARVEST_TYPE3_SRS,*HARVEST_TYPE3_SRS,,
|
|
| 94 |
LAND_USE_SRS,*LAND_USE_SRS,,
|
|
| 95 |
OPERABILITY_SRS,*OPERABILITY_SRS,,
|
|
| 96 |
STAND_STRUCTURE_SRS,*STAND_STRUCTURE_SRS,,
|
|
| 97 |
NF_COND_STATUS_CD,*NF_COND_STATUS_CD,,
|
|
| 98 |
NF_COND_NONSAMPLE_REASN_CD,*NF_COND_NONSAMPLE_REASN_CD,,
|
|
| 99 |
CANOPY_CVR_SAMPLE_METHOD_CD,*CANOPY_CVR_SAMPLE_METHOD_CD,,
|
|
| 100 |
LIVE_CANOPY_CVR_PCT,*LIVE_CANOPY_CVR_PCT,,
|
|
| 101 |
LIVE_MISSING_CANOPY_CVR_PCT,*LIVE_MISSING_CANOPY_CVR_PCT,,
|
|
| 102 |
NBR_LIVE_STEMS,*NBR_LIVE_STEMS,,
|
|
| 103 |
OWNSUBCD,*OWNSUBCD,,
|
|
| 104 |
INDUSTRIALCD_FIADB,*INDUSTRIALCD_FIADB,,
|
|
| 105 |
RESERVCD_FLD,*RESERVCD_FLD,,
|
|
| 106 |
ADMIN_WITHDRAWN_CD,*ADMIN_WITHDRAWN_CD,,
|
|
| 5 |
INVYR,INVYR,, |
|
| 6 |
STATECD,STATECD,, |
|
| 7 |
UNITCD,UNITCD,, |
|
| 8 |
COUNTYCD,COUNTYCD,, |
|
| 9 |
PLOT,locationName,,
|
|
| 10 |
CONDID,authorEventCode,,
|
|
| 11 |
COND_STATUS_CD,COND_STATUS_CD,, |
|
| 12 |
COND_NONSAMPLE_REASN_CD,COND_NONSAMPLE_REASN_CD,, |
|
| 13 |
RESERVCD,RESERVCD,, |
|
| 14 |
OWNCD,OWNCD,, |
|
| 15 |
OWNGRPCD,OWNGRPCD,, |
|
| 16 |
FORINDCD,FORINDCD,, |
|
| 17 |
ADFORCD,ADFORCD,, |
|
| 18 |
FORTYPCD,FORTYPCD,, |
|
| 19 |
FLDTYPCD,FLDTYPCD,, |
|
| 20 |
MAPDEN,MAPDEN,, |
|
| 21 |
STDAGE,STDAGE,, |
|
| 22 |
STDSZCD,STDSZCD,, |
|
| 23 |
FLDSZCD,FLDSZCD,, |
|
| 24 |
SITECLCD,SITECLCD,, |
|
| 25 |
SICOND,SICOND,, |
|
| 26 |
SIBASE,SIBASE,, |
|
| 27 |
SISP,SISP,, |
|
| 28 |
STDORGCD,STDORGCD,, |
|
| 29 |
STDORGSP,STDORGSP,, |
|
| 30 |
PROP_BASIS,PROP_BASIS,, |
|
| 31 |
CONDPROP_UNADJ,CONDPROP_UNADJ,, |
|
| 32 |
MICRPROP_UNADJ,MICRPROP_UNADJ,, |
|
| 33 |
SUBPPROP_UNADJ,SUBPPROP_UNADJ,, |
|
| 34 |
MACRPROP_UNADJ,MACRPROP_UNADJ,, |
|
| 35 |
SLOPE,SLOPE,, |
|
| 36 |
ASPECT,ASPECT,, |
|
| 37 |
PHYSCLCD,PHYSCLCD,, |
|
| 38 |
GSSTKCD,GSSTKCD,, |
|
| 39 |
ALSTKCD,ALSTKCD,, |
|
| 40 |
DSTRBCD1,DSTRBCD1,, |
|
| 41 |
DSTRBYR1,DSTRBYR1,, |
|
| 42 |
DSTRBCD2,DSTRBCD2,, |
|
| 43 |
DSTRBYR2,DSTRBYR2,, |
|
| 44 |
DSTRBCD3,DSTRBCD3,, |
|
| 45 |
DSTRBYR3,DSTRBYR3,, |
|
| 46 |
TRTCD1,TRTCD1,, |
|
| 47 |
TRTYR1,TRTYR1,, |
|
| 48 |
TRTCD2,TRTCD2,, |
|
| 49 |
TRTYR2,TRTYR2,, |
|
| 50 |
TRTCD3,TRTCD3,, |
|
| 51 |
TRTYR3,TRTYR3,, |
|
| 52 |
PRESNFCD,PRESNFCD,, |
|
| 53 |
BALIVE,BALIVE,, |
|
| 54 |
FLDAGE,FLDAGE,, |
|
| 55 |
ALSTK,ALSTK,, |
|
| 56 |
GSSTK,GSSTK,, |
|
| 57 |
FORTYPCDCALC,FORTYPCDCALC,, |
|
| 58 |
HABTYPCD1,HABTYPCD1,, |
|
| 59 |
HABTYPCD1_PUB_CD,HABTYPCD1_PUB_CD,, |
|
| 60 |
HABTYPCD1_DESCR_PUB_CD,HABTYPCD1_DESCR_PUB_CD,, |
|
| 61 |
HABTYPCD2,HABTYPCD2,, |
|
| 62 |
HABTYPCD2_PUB_CD,HABTYPCD2_PUB_CD,, |
|
| 63 |
HABTYPCD2_DESCR_PUB_CD,HABTYPCD2_DESCR_PUB_CD,, |
|
| 64 |
MIXEDCONFCD,MIXEDCONFCD,, |
|
| 65 |
VOL_LOC_GRP,VOL_LOC_GRP,, |
|
| 66 |
SITECLCDEST,SITECLCDEST,, |
|
| 67 |
SITETREE_TREE,SITETREE_TREE,, |
|
| 68 |
SITECL_METHOD,SITECL_METHOD,, |
|
| 69 |
CARBON_DOWN_DEAD,CARBON_DOWN_DEAD,, |
|
| 70 |
CARBON_LITTER,CARBON_LITTER,, |
|
| 71 |
CARBON_SOIL_ORG,CARBON_SOIL_ORG,, |
|
| 72 |
CARBON_STANDING_DEAD,CARBON_STANDING_DEAD,, |
|
| 73 |
CARBON_UNDERSTORY_AG,CARBON_UNDERSTORY_AG,, |
|
| 74 |
CARBON_UNDERSTORY_BG,CARBON_UNDERSTORY_BG,, |
|
| 75 |
CREATED_BY,CREATED_BY,, |
|
| 76 |
CREATED_DATE,CREATED_DATE,, |
|
| 77 |
CREATED_IN_INSTANCE,CREATED_IN_INSTANCE,, |
|
| 78 |
MODIFIED_BY,MODIFIED_BY,, |
|
| 79 |
MODIFIED_DATE,MODIFIED_DATE,, |
|
| 80 |
MODIFIED_IN_INSTANCE,MODIFIED_IN_INSTANCE,, |
|
| 81 |
CYCLE,CYCLE,, |
|
| 82 |
SUBCYCLE,SUBCYCLE,, |
|
| 83 |
SOIL_ROOTING_DEPTH_PNW,SOIL_ROOTING_DEPTH_PNW,, |
|
| 84 |
GROUND_LAND_CLASS_PNW,GROUND_LAND_CLASS_PNW,, |
|
| 85 |
PLANT_STOCKABILITY_FACTOR_PNW,PLANT_STOCKABILITY_FACTOR_PNW,, |
|
| 86 |
STND_COND_CD_PNWRS,STND_COND_CD_PNWRS,, |
|
| 87 |
STND_STRUC_CD_PNWRS,STND_STRUC_CD_PNWRS,, |
|
| 88 |
STUMP_CD_PNWRS,STUMP_CD_PNWRS,, |
|
| 89 |
FIRE_SRS,FIRE_SRS,, |
|
| 90 |
GRAZING_SRS,GRAZING_SRS,, |
|
| 91 |
HARVEST_TYPE1_SRS,HARVEST_TYPE1_SRS,, |
|
| 92 |
HARVEST_TYPE2_SRS,HARVEST_TYPE2_SRS,, |
|
| 93 |
HARVEST_TYPE3_SRS,HARVEST_TYPE3_SRS,, |
|
| 94 |
LAND_USE_SRS,LAND_USE_SRS,, |
|
| 95 |
OPERABILITY_SRS,OPERABILITY_SRS,, |
|
| 96 |
STAND_STRUCTURE_SRS,STAND_STRUCTURE_SRS,, |
|
| 97 |
NF_COND_STATUS_CD,NF_COND_STATUS_CD,, |
|
| 98 |
NF_COND_NONSAMPLE_REASN_CD,NF_COND_NONSAMPLE_REASN_CD,, |
|
| 99 |
CANOPY_CVR_SAMPLE_METHOD_CD,CANOPY_CVR_SAMPLE_METHOD_CD,, |
|
| 100 |
LIVE_CANOPY_CVR_PCT,LIVE_CANOPY_CVR_PCT,, |
|
| 101 |
LIVE_MISSING_CANOPY_CVR_PCT,LIVE_MISSING_CANOPY_CVR_PCT,, |
|
| 102 |
NBR_LIVE_STEMS,NBR_LIVE_STEMS,, |
|
| 103 |
OWNSUBCD,OWNSUBCD,, |
|
| 104 |
INDUSTRIALCD_FIADB,INDUSTRIALCD_FIADB,, |
|
| 105 |
RESERVCD_FLD,RESERVCD_FLD,, |
|
| 106 |
ADMIN_WITHDRAWN_CD,ADMIN_WITHDRAWN_CD,, |
|
| 107 | 107 |
oldgrowth,oldGrowth,, |
| inputs/FIA/COND_unique/unmapped_terms.csv | ||
|---|---|---|
| 4 | 4 |
*STATECD |
| 5 | 5 |
*UNITCD |
| 6 | 6 |
*COUNTYCD |
| 7 |
*PLOT |
|
| 8 |
*CONDID |
|
| 9 | 7 |
*COND_STATUS_CD |
| 10 | 8 |
*COND_NONSAMPLE_REASN_CD |
| 11 | 9 |
*RESERVCD |
| inputs/FIA/REF_HABTYP_DESCRIPTION/new_terms.csv | ||
|---|---|---|
| 1 |
row_num,*REF_HABTYP_DESCRIPTION.row_num,, |
|
| 1 |
row_num,"REF_HABTYP_DESCRIPTION |
|
| 2 |
row_num",, |
|
| 2 | 3 |
CN,communityID,, |
| 3 | 4 |
PUB_CD,HABTYP_PUB_CD,, |
| 4 | 5 |
COMMON_NAME,communityName,, |
| 5 |
VALID,*REF_HABTYP_DESCRIPTION.VALID,, |
|
| 6 |
CREATED_BY,*REF_HABTYP_DESCRIPTION.CREATED_BY,, |
|
| 7 |
CREATED_DATE,*REF_HABTYP_DESCRIPTION.CREATED_DATE,, |
|
| 8 |
CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION.CREATED_IN_INSTANCE,, |
|
| 9 |
MODIFIED_BY,*REF_HABTYP_DESCRIPTION.MODIFIED_BY,, |
|
| 10 |
MODIFIED_DATE,*REF_HABTYP_DESCRIPTION.MODIFIED_DATE,, |
|
| 11 |
MODIFIED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION.MODIFIED_IN_INSTANCE,, |
|
| 6 |
VALID,"REF_HABTYP_DESCRIPTION |
|
| 7 |
VALID",, |
|
| 8 |
CREATED_BY,"REF_HABTYP_DESCRIPTION |
|
| 9 |
CREATED_BY",, |
|
| 10 |
CREATED_DATE,"REF_HABTYP_DESCRIPTION |
|
| 11 |
CREATED_DATE",, |
|
| 12 |
CREATED_IN_INSTANCE,"REF_HABTYP_DESCRIPTION |
|
| 13 |
CREATED_IN_INSTANCE",, |
|
| 14 |
MODIFIED_BY,"REF_HABTYP_DESCRIPTION |
|
| 15 |
MODIFIED_BY",, |
|
| 16 |
MODIFIED_DATE,"REF_HABTYP_DESCRIPTION |
|
| 17 |
MODIFIED_DATE",, |
|
| 18 |
MODIFIED_IN_INSTANCE,"REF_HABTYP_DESCRIPTION |
|
| 19 |
MODIFIED_IN_INSTANCE",, |
|
| inputs/FIA/SUBPLOT/map.csv | ||
|---|---|---|
| 1 | 1 |
FIA,VegCore,Filter,Comments |
| 2 |
row_num,*SUBPLOT.row_num,, |
|
| 2 |
row_num,"SUBPLOT |
|
| 3 |
row_num",, |
|
| 3 | 4 |
CN,subplotID,, |
| 4 |
PLT_CN,*SUBPLOT.PLT_CN,, |
|
| 5 |
PREV_SBP_CN,*SUBPLOT.PREV_SBP_CN,, |
|
| 5 |
PLT_CN,"SUBPLOT |
|
| 6 |
PLT_CN",, |
|
| 7 |
PREV_SBP_CN,"SUBPLOT |
|
| 8 |
PREV_SBP_CN",, |
|
| 6 | 9 |
INVYR,INVYR,, |
| 7 | 10 |
STATECD,STATECD,, |
| 8 | 11 |
UNITCD,UNITCD,, |
| 9 | 12 |
COUNTYCD,COUNTYCD,, |
| 10 | 13 |
PLOT,locationName,, |
| 11 | 14 |
SUBP,subplot,, |
| 12 |
SUBP_STATUS_CD,*SUBPLOT.SUBP_STATUS_CD,, |
|
| 13 |
POINT_NONSAMPLE_REASN_CD,*SUBPLOT.POINT_NONSAMPLE_REASN_CD,, |
|
| 14 |
MICRCOND,*SUBPLOT.MICRCOND,, |
|
| 15 |
SUBPCOND,*SUBPLOT.SUBPCOND,, |
|
| 16 |
MACRCOND,*SUBPLOT.MACRCOND,, |
|
| 17 |
CONDLIST,*SUBPLOT.CONDLIST,, |
|
| 18 |
SLOPE,*SUBPLOT.SLOPE,, |
|
| 19 |
ASPECT,*SUBPLOT.ASPECT,, |
|
| 20 |
WATERDEP,*SUBPLOT.WATERDEP,, |
|
| 21 |
P2A_GRM_FLG,*SUBPLOT.P2A_GRM_FLG,, |
|
| 22 |
CREATED_BY,*SUBPLOT.CREATED_BY,, |
|
| 23 |
CREATED_DATE,*SUBPLOT.CREATED_DATE,, |
|
| 24 |
CREATED_IN_INSTANCE,*SUBPLOT.CREATED_IN_INSTANCE,, |
|
| 25 |
MODIFIED_BY,*SUBPLOT.MODIFIED_BY,, |
|
| 26 |
MODIFIED_DATE,*SUBPLOT.MODIFIED_DATE,, |
|
| 27 |
MODIFIED_IN_INSTANCE,*SUBPLOT.MODIFIED_IN_INSTANCE,, |
|
| 28 |
CYCLE,*SUBPLOT.CYCLE,, |
|
| 29 |
SUBCYCLE,*SUBPLOT.SUBCYCLE,, |
|
| 30 |
ROOT_DIS_SEV_CD_PNWRS,*SUBPLOT.ROOT_DIS_SEV_CD_PNWRS,, |
|
| 31 |
NF_SUBP_STATUS_CD,*SUBPLOT.NF_SUBP_STATUS_CD,, |
|
| 32 |
NF_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT.NF_SUBP_NONSAMPLE_REASN_CD,, |
|
| 33 |
P2VEG_SUBP_STATUS_CD,*SUBPLOT.P2VEG_SUBP_STATUS_CD,, |
|
| 34 |
P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT.P2VEG_SUBP_NONSAMPLE_REASN_CD,, |
|
| 35 |
INVASIVE_SUBP_STATUS_CD,*SUBPLOT.INVASIVE_SUBP_STATUS_CD,, |
|
| 36 |
INVASIVE_NONSAMPLE_REASN_CD,*SUBPLOT.INVASIVE_NONSAMPLE_REASN_CD,, |
|
| 15 |
SUBP_STATUS_CD,"SUBPLOT |
|
| 16 |
SUBP_STATUS_CD",, |
|
| 17 |
POINT_NONSAMPLE_REASN_CD,"SUBPLOT |
|
| 18 |
POINT_NONSAMPLE_REASN_CD",, |
|
| 19 |
MICRCOND,"SUBPLOT |
|
| 20 |
MICRCOND",, |
|
| 21 |
SUBPCOND,"SUBPLOT |
|
| 22 |
SUBPCOND",, |
|
| 23 |
MACRCOND,"SUBPLOT |
|
| 24 |
MACRCOND",, |
|
| 25 |
CONDLIST,"SUBPLOT |
|
| 26 |
CONDLIST",, |
|
| 27 |
SLOPE,"SUBPLOT |
|
| 28 |
SLOPE",, |
|
| 29 |
ASPECT,"SUBPLOT |
|
| 30 |
ASPECT",, |
|
| 31 |
WATERDEP,"SUBPLOT |
|
| 32 |
WATERDEP",, |
|
| 33 |
P2A_GRM_FLG,"SUBPLOT |
|
| 34 |
P2A_GRM_FLG",, |
|
| 35 |
CREATED_BY,"SUBPLOT |
|
| 36 |
CREATED_BY",, |
|
| 37 |
CREATED_DATE,"SUBPLOT |
|
| 38 |
CREATED_DATE",, |
|
| 39 |
CREATED_IN_INSTANCE,"SUBPLOT |
|
| 40 |
CREATED_IN_INSTANCE",, |
|
| 41 |
MODIFIED_BY,"SUBPLOT |
|
| 42 |
MODIFIED_BY",, |
|
| 43 |
MODIFIED_DATE,"SUBPLOT |
|
| 44 |
MODIFIED_DATE",, |
|
| 45 |
MODIFIED_IN_INSTANCE,"SUBPLOT |
|
| 46 |
MODIFIED_IN_INSTANCE",, |
|
| 47 |
CYCLE,"SUBPLOT |
|
| 48 |
CYCLE",, |
|
| 49 |
SUBCYCLE,"SUBPLOT |
|
| 50 |
SUBCYCLE",, |
|
| 51 |
ROOT_DIS_SEV_CD_PNWRS,"SUBPLOT |
|
| 52 |
ROOT_DIS_SEV_CD_PNWRS",, |
|
| 53 |
NF_SUBP_STATUS_CD,"SUBPLOT |
|
| 54 |
NF_SUBP_STATUS_CD",, |
|
| 55 |
NF_SUBP_NONSAMPLE_REASN_CD,"SUBPLOT |
|
| 56 |
NF_SUBP_NONSAMPLE_REASN_CD",, |
|
| 57 |
P2VEG_SUBP_STATUS_CD,"SUBPLOT |
|
| 58 |
P2VEG_SUBP_STATUS_CD",, |
|
| 59 |
P2VEG_SUBP_NONSAMPLE_REASN_CD,"SUBPLOT |
|
| 60 |
P2VEG_SUBP_NONSAMPLE_REASN_CD",, |
|
| 61 |
INVASIVE_SUBP_STATUS_CD,"SUBPLOT |
|
| 62 |
INVASIVE_SUBP_STATUS_CD",, |
|
| 63 |
INVASIVE_NONSAMPLE_REASN_CD,"SUBPLOT |
|
| 64 |
INVASIVE_NONSAMPLE_REASN_CD",, |
|
| inputs/FIA/REF_RESEARCH_STATION/map.csv | ||
|---|---|---|
| 1 | 1 |
FIA,VegCore,Filter,Comments |
| 2 |
row_num,*REF_RESEARCH_STATION.row_num,, |
|
| 2 |
row_num,"REF_RESEARCH_STATION |
|
| 3 |
row_num",, |
|
| 3 | 4 |
STATECD,STATECD,, |
| 4 |
RSCD,*REF_RESEARCH_STATION.RSCD,, |
|
| 5 |
RS,*REF_RESEARCH_STATION.RS,, |
|
| 5 |
RSCD,"REF_RESEARCH_STATION |
|
| 6 |
RSCD",, |
|
| 7 |
RS,"REF_RESEARCH_STATION |
|
| 8 |
RS",, |
|
| 6 | 9 |
STATE_NAME,stateProvince,, |
| 7 |
STATE_ABBR,*REF_RESEARCH_STATION.STATE_ABBR,, |
|
| 8 |
CREATED_BY,*REF_RESEARCH_STATION.CREATED_BY,, |
|
| 9 |
CREATED_DATE,*REF_RESEARCH_STATION.CREATED_DATE,, |
|
| 10 |
CREATED_IN_INSTANCE,*REF_RESEARCH_STATION.CREATED_IN_INSTANCE,, |
|
| 11 |
MODIFIED_BY,*REF_RESEARCH_STATION.MODIFIED_BY,, |
|
| 12 |
MODIFIED_DATE,*REF_RESEARCH_STATION.MODIFIED_DATE,, |
|
| 13 |
MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION.MODIFIED_IN_INSTANCE,, |
|
| 10 |
STATE_ABBR,"REF_RESEARCH_STATION |
|
| 11 |
STATE_ABBR",, |
|
| 12 |
CREATED_BY,"REF_RESEARCH_STATION |
|
| 13 |
CREATED_BY",, |
|
| 14 |
CREATED_DATE,"REF_RESEARCH_STATION |
|
| 15 |
CREATED_DATE",, |
|
| 16 |
CREATED_IN_INSTANCE,"REF_RESEARCH_STATION |
|
| 17 |
CREATED_IN_INSTANCE",, |
|
| 18 |
MODIFIED_BY,"REF_RESEARCH_STATION |
|
| 19 |
MODIFIED_BY",, |
|
| 20 |
MODIFIED_DATE,"REF_RESEARCH_STATION |
|
| 21 |
MODIFIED_DATE",, |
|
| 22 |
MODIFIED_IN_INSTANCE,"REF_RESEARCH_STATION |
|
| 23 |
MODIFIED_IN_INSTANCE",, |
|
| inputs/FIA/PLOT/map.csv | ||
|---|---|---|
| 1 | 1 |
FIA,VegCore,Filter,Comments |
| 2 |
row_num,*PLOT.row_num,, |
|
| 2 |
row_num,"PLOT |
|
| 3 |
row_num",, |
|
| 3 | 4 |
CN,locationID,, |
| 4 |
SRV_CN,*PLOT.SRV_CN,, |
|
| 5 |
CTY_CN,*PLOT.CTY_CN,, |
|
| 6 |
PREV_PLT_CN,*PLOT.PREV_PLT_CN,, |
|
| 5 |
SRV_CN,"PLOT |
|
| 6 |
SRV_CN",, |
|
| 7 |
CTY_CN,"PLOT |
|
| 8 |
CTY_CN",, |
|
| 9 |
PREV_PLT_CN,"PLOT |
|
| 10 |
PREV_PLT_CN",, |
|
| 7 | 11 |
INVYR,INVYR,, |
| 8 | 12 |
STATECD,STATECD,, |
| 9 | 13 |
UNITCD,UNITCD,, |
| 10 | 14 |
COUNTYCD,COUNTYCD,, |
| 11 | 15 |
PLOT,locationName,, |
| 12 |
PLOT_STATUS_CD,*PLOT.PLOT_STATUS_CD,, |
|
| 13 |
PLOT_NONSAMPLE_REASN_CD,*PLOT.PLOT_NONSAMPLE_REASN_CD,, |
|
| 16 |
PLOT_STATUS_CD,"PLOT |
|
| 17 |
PLOT_STATUS_CD",, |
|
| 18 |
PLOT_NONSAMPLE_REASN_CD,"PLOT |
|
| 19 |
PLOT_NONSAMPLE_REASN_CD",, |
|
| 14 | 20 |
MEASYEAR,year,, |
| 15 | 21 |
MEASMON,month,, |
| 16 | 22 |
MEASDAY,day,, |
| 17 |
REMPER,*PLOT.REMPER,, |
|
| 18 |
KINDCD,*PLOT.KINDCD,, |
|
| 19 |
DESIGNCD,*PLOT.DESIGNCD,, |
|
| 20 |
RDDISTCD,*PLOT.RDDISTCD,, |
|
| 21 |
WATERCD,*PLOT.WATERCD,, |
|
| 23 |
REMPER,"PLOT |
|
| 24 |
REMPER",, |
|
| 25 |
KINDCD,"PLOT |
|
| 26 |
KINDCD",, |
|
| 27 |
DESIGNCD,"PLOT |
|
| 28 |
DESIGNCD",, |
|
| 29 |
RDDISTCD,"PLOT |
|
| 30 |
RDDISTCD",, |
|
| 31 |
WATERCD,"PLOT |
|
| 32 |
WATERCD",, |
|
| 22 | 33 |
LAT,decimalLatitude,, |
| 23 | 34 |
LON,decimalLongitude,, |
| 24 | 35 |
ELEV,elevationInMeters,,Assuming units based on the range and precision of values |
| 25 |
GROW_TYP_CD,*PLOT.GROW_TYP_CD,, |
|
| 26 |
MORT_TYP_CD,*PLOT.MORT_TYP_CD,, |
|
| 27 |
P2PANEL,*PLOT.P2PANEL,, |
|
| 28 |
P3PANEL,*PLOT.P3PANEL,, |
|
| 29 |
ECOSUBCD,*PLOT.ECOSUBCD,, |
|
| 30 |
CONGCD,*PLOT.CONGCD,, |
|
| 31 |
MANUAL,*PLOT.MANUAL,, |
|
| 32 |
SUBPANEL,*PLOT.SUBPANEL,, |
|
| 33 |
KINDCD_NC,*PLOT.KINDCD_NC,, |
|
| 34 |
QA_STATUS,*PLOT.QA_STATUS,, |
|
| 35 |
CREATED_BY,*PLOT.CREATED_BY,, |
|
| 36 |
CREATED_DATE,*PLOT.CREATED_DATE,, |
|
| 37 |
CREATED_IN_INSTANCE,*PLOT.CREATED_IN_INSTANCE,, |
|
| 38 |
MODIFIED_BY,*PLOT.MODIFIED_BY,, |
|
| 39 |
MODIFIED_DATE,*PLOT.MODIFIED_DATE,, |
|
| 40 |
MODIFIED_IN_INSTANCE,*PLOT.MODIFIED_IN_INSTANCE,, |
|
| 41 |
MICROPLOT_LOC,*PLOT.MICROPLOT_LOC,, |
|
| 42 |
DECLINATION,*PLOT.DECLINATION,, |
|
| 43 |
EMAP_HEX,*PLOT.EMAP_HEX,, |
|
| 44 |
SAMP_METHOD_CD,*PLOT.SAMP_METHOD_CD,, |
|
| 45 |
SUBP_EXAMINE_CD,*PLOT.SUBP_EXAMINE_CD,, |
|
| 46 |
MACRO_BREAKPOINT_DIA,*PLOT.MACRO_BREAKPOINT_DIA,, |
|
| 47 |
INTENSITY,*PLOT.INTENSITY,, |
|
| 48 |
CYCLE,*PLOT.CYCLE,, |
|
| 49 |
SUBCYCLE,*PLOT.SUBCYCLE,, |
|
| 50 |
ECO_UNIT_PNW,*PLOT.ECO_UNIT_PNW,, |
|
| 51 |
TOPO_POSITION_PNW,*PLOT.TOPO_POSITION_PNW,, |
|
| 52 |
NF_SAMPLING_STATUS_CD,*PLOT.NF_SAMPLING_STATUS_CD,, |
|
| 53 |
NF_PLOT_STATUS_CD,*PLOT.NF_PLOT_STATUS_CD,, |
|
| 54 |
NF_PLOT_NONSAMPLE_REASN_CD,*PLOT.NF_PLOT_NONSAMPLE_REASN_CD,, |
|
| 55 |
P2VEG_SAMPLING_STATUS_CD,*PLOT.P2VEG_SAMPLING_STATUS_CD,, |
|
| 56 |
P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT.P2VEG_SAMPLING_LEVEL_DETAIL_CD,, |
|
| 57 |
INVASIVE_SAMPLING_STATUS_CD,*PLOT.INVASIVE_SAMPLING_STATUS_CD,, |
|
| 58 |
INVASIVE_SPECIMEN_RULE_CD,*PLOT.INVASIVE_SPECIMEN_RULE_CD,, |
|
| 59 |
DESIGNCD_P2A,*PLOT.DESIGNCD_P2A,, |
|
| 36 |
GROW_TYP_CD,"PLOT |
|
| 37 |
GROW_TYP_CD",, |
|
| 38 |
MORT_TYP_CD,"PLOT |
|
| 39 |
MORT_TYP_CD",, |
|
| 40 |
P2PANEL,"PLOT |
|
| 41 |
P2PANEL",, |
|
| 42 |
P3PANEL,"PLOT |
|
| 43 |
P3PANEL",, |
|
| 44 |
ECOSUBCD,"PLOT |
|
| 45 |
ECOSUBCD",, |
|
| 46 |
CONGCD,"PLOT |
|
| 47 |
CONGCD",, |
|
| 48 |
MANUAL,"PLOT |
|
| 49 |
MANUAL",, |
|
| 50 |
SUBPANEL,"PLOT |
|
| 51 |
SUBPANEL",, |
|
| 52 |
KINDCD_NC,"PLOT |
|
| 53 |
KINDCD_NC",, |
|
| 54 |
QA_STATUS,"PLOT |
|
| 55 |
QA_STATUS",, |
|
| 56 |
CREATED_BY,"PLOT |
|
| 57 |
CREATED_BY",, |
|
| 58 |
CREATED_DATE,"PLOT |
|
| 59 |
CREATED_DATE",, |
|
| 60 |
CREATED_IN_INSTANCE,"PLOT |
|
| 61 |
CREATED_IN_INSTANCE",, |
|
| 62 |
MODIFIED_BY,"PLOT |
|
| 63 |
MODIFIED_BY",, |
|
| 64 |
MODIFIED_DATE,"PLOT |
|
| 65 |
MODIFIED_DATE",, |
|
| 66 |
MODIFIED_IN_INSTANCE,"PLOT |
|
| 67 |
MODIFIED_IN_INSTANCE",, |
|
| 68 |
MICROPLOT_LOC,"PLOT |
|
| 69 |
MICROPLOT_LOC",, |
|
| 70 |
DECLINATION,"PLOT |
|
| 71 |
DECLINATION",, |
|
| 72 |
EMAP_HEX,"PLOT |
|
| 73 |
EMAP_HEX",, |
|
| 74 |
SAMP_METHOD_CD,"PLOT |
|
| 75 |
SAMP_METHOD_CD",, |
|
| 76 |
SUBP_EXAMINE_CD,"PLOT |
|
| 77 |
SUBP_EXAMINE_CD",, |
|
| 78 |
MACRO_BREAKPOINT_DIA,"PLOT |
|
| 79 |
MACRO_BREAKPOINT_DIA",, |
|
| 80 |
INTENSITY,"PLOT |
|
| 81 |
INTENSITY",, |
|
| 82 |
CYCLE,"PLOT |
|
| 83 |
CYCLE",, |
|
| 84 |
SUBCYCLE,"PLOT |
|
| 85 |
SUBCYCLE",, |
|
| 86 |
ECO_UNIT_PNW,"PLOT |
|
| 87 |
ECO_UNIT_PNW",, |
|
| 88 |
TOPO_POSITION_PNW,"PLOT |
|
| 89 |
TOPO_POSITION_PNW",, |
|
| 90 |
NF_SAMPLING_STATUS_CD,"PLOT |
|
| 91 |
NF_SAMPLING_STATUS_CD",, |
|
| 92 |
NF_PLOT_STATUS_CD,"PLOT |
|
| 93 |
NF_PLOT_STATUS_CD",, |
|
| 94 |
NF_PLOT_NONSAMPLE_REASN_CD,"PLOT |
|
| 95 |
NF_PLOT_NONSAMPLE_REASN_CD",, |
|
| 96 |
P2VEG_SAMPLING_STATUS_CD,"PLOT |
|
| 97 |
P2VEG_SAMPLING_STATUS_CD",, |
|
| 98 |
P2VEG_SAMPLING_LEVEL_DETAIL_CD,"PLOT |
|
| 99 |
P2VEG_SAMPLING_LEVEL_DETAIL_CD",, |
|
| 100 |
INVASIVE_SAMPLING_STATUS_CD,"PLOT |
|
| 101 |
INVASIVE_SAMPLING_STATUS_CD",, |
|
| 102 |
INVASIVE_SPECIMEN_RULE_CD,"PLOT |
|
| 103 |
INVASIVE_SPECIMEN_RULE_CD",, |
|
| 104 |
DESIGNCD_P2A,"PLOT |
|
| 105 |
DESIGNCD_P2A",, |
|
| inputs/FIA/PLOT/new_terms.csv | ||
|---|---|---|
| 1 |
row_num,*PLOT.row_num,, |
|
| 1 |
row_num,"PLOT |
|
| 2 |
row_num",, |
|
| 2 | 3 |
CN,locationID,, |
| 3 |
SRV_CN,*PLOT.SRV_CN,, |
|
| 4 |
CTY_CN,*PLOT.CTY_CN,, |
|
| 5 |
PREV_PLT_CN,*PLOT.PREV_PLT_CN,, |
|
| 4 |
SRV_CN,"PLOT |
|
| 5 |
SRV_CN",, |
|
| 6 |
CTY_CN,"PLOT |
|
| 7 |
CTY_CN",, |
|
| 8 |
PREV_PLT_CN,"PLOT |
|
| 9 |
PREV_PLT_CN",, |
|
| 6 | 10 |
PLOT,locationName,, |
| 7 |
PLOT_STATUS_CD,*PLOT.PLOT_STATUS_CD,, |
|
| 8 |
PLOT_NONSAMPLE_REASN_CD,*PLOT.PLOT_NONSAMPLE_REASN_CD,, |
|
| 11 |
PLOT_STATUS_CD,"PLOT |
|
| 12 |
PLOT_STATUS_CD",, |
|
| 13 |
PLOT_NONSAMPLE_REASN_CD,"PLOT |
|
| 14 |
PLOT_NONSAMPLE_REASN_CD",, |
|
| 9 | 15 |
MEASYEAR,year,, |
| 10 | 16 |
MEASMON,month,, |
| 11 | 17 |
MEASDAY,day,, |
| 12 |
REMPER,*PLOT.REMPER,, |
|
| 13 |
KINDCD,*PLOT.KINDCD,, |
|
| 14 |
DESIGNCD,*PLOT.DESIGNCD,, |
|
| 15 |
RDDISTCD,*PLOT.RDDISTCD,, |
|
| 16 |
WATERCD,*PLOT.WATERCD,, |
|
| 18 |
REMPER,"PLOT |
|
| 19 |
REMPER",, |
|
| 20 |
KINDCD,"PLOT |
|
| 21 |
KINDCD",, |
|
| 22 |
DESIGNCD,"PLOT |
|
| 23 |
DESIGNCD",, |
|
| 24 |
RDDISTCD,"PLOT |
|
| 25 |
RDDISTCD",, |
|
| 26 |
WATERCD,"PLOT |
|
| 27 |
WATERCD",, |
|
| 17 | 28 |
LAT,decimalLatitude,, |
| 18 | 29 |
LON,decimalLongitude,, |
| 19 | 30 |
ELEV,elevationInMeters,,Assuming units based on the range and precision of values |
| 20 |
GROW_TYP_CD,*PLOT.GROW_TYP_CD,, |
|
| 21 |
MORT_TYP_CD,*PLOT.MORT_TYP_CD,, |
|
| 22 |
P2PANEL,*PLOT.P2PANEL,, |
|
| 23 |
P3PANEL,*PLOT.P3PANEL,, |
|
| 24 |
ECOSUBCD,*PLOT.ECOSUBCD,, |
|
| 25 |
CONGCD,*PLOT.CONGCD,, |
|
| 26 |
MANUAL,*PLOT.MANUAL,, |
|
| 27 |
SUBPANEL,*PLOT.SUBPANEL,, |
|
| 28 |
KINDCD_NC,*PLOT.KINDCD_NC,, |
|
| 29 |
QA_STATUS,*PLOT.QA_STATUS,, |
|
| 30 |
CREATED_BY,*PLOT.CREATED_BY,, |
|
| 31 |
CREATED_DATE,*PLOT.CREATED_DATE,, |
|
| 32 |
CREATED_IN_INSTANCE,*PLOT.CREATED_IN_INSTANCE,, |
|
| 33 |
MODIFIED_BY,*PLOT.MODIFIED_BY,, |
|
| 34 |
MODIFIED_DATE,*PLOT.MODIFIED_DATE,, |
|
| 35 |
MODIFIED_IN_INSTANCE,*PLOT.MODIFIED_IN_INSTANCE,, |
|
| 36 |
MICROPLOT_LOC,*PLOT.MICROPLOT_LOC,, |
|
| 37 |
DECLINATION,*PLOT.DECLINATION,, |
|
| 38 |
EMAP_HEX,*PLOT.EMAP_HEX,, |
|
| 39 |
SAMP_METHOD_CD,*PLOT.SAMP_METHOD_CD,, |
|
| 40 |
SUBP_EXAMINE_CD,*PLOT.SUBP_EXAMINE_CD,, |
|
| 41 |
MACRO_BREAKPOINT_DIA,*PLOT.MACRO_BREAKPOINT_DIA,, |
|
| 42 |
INTENSITY,*PLOT.INTENSITY,, |
|
| 43 |
CYCLE,*PLOT.CYCLE,, |
|
| 44 |
SUBCYCLE,*PLOT.SUBCYCLE,, |
|
| 45 |
ECO_UNIT_PNW,*PLOT.ECO_UNIT_PNW,, |
|
| 46 |
TOPO_POSITION_PNW,*PLOT.TOPO_POSITION_PNW,, |
|
| 47 |
NF_SAMPLING_STATUS_CD,*PLOT.NF_SAMPLING_STATUS_CD,, |
|
| 48 |
NF_PLOT_STATUS_CD,*PLOT.NF_PLOT_STATUS_CD,, |
|
| 49 |
NF_PLOT_NONSAMPLE_REASN_CD,*PLOT.NF_PLOT_NONSAMPLE_REASN_CD,, |
|
| 50 |
P2VEG_SAMPLING_STATUS_CD,*PLOT.P2VEG_SAMPLING_STATUS_CD,, |
|
| 51 |
P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT.P2VEG_SAMPLING_LEVEL_DETAIL_CD,, |
|
| 52 |
INVASIVE_SAMPLING_STATUS_CD,*PLOT.INVASIVE_SAMPLING_STATUS_CD,, |
|
| 53 |
INVASIVE_SPECIMEN_RULE_CD,*PLOT.INVASIVE_SPECIMEN_RULE_CD,, |
|
| 54 |
DESIGNCD_P2A,*PLOT.DESIGNCD_P2A,, |
|
| 31 |
GROW_TYP_CD,"PLOT |
|
| 32 |
GROW_TYP_CD",, |
|
| 33 |
MORT_TYP_CD,"PLOT |
|
| 34 |
MORT_TYP_CD",, |
|
| 35 |
P2PANEL,"PLOT |
|
| 36 |
P2PANEL",, |
|
| 37 |
P3PANEL,"PLOT |
|
| 38 |
P3PANEL",, |
|
| 39 |
ECOSUBCD,"PLOT |
|
| 40 |
ECOSUBCD",, |
|
| 41 |
CONGCD,"PLOT |
|
| 42 |
CONGCD",, |
|
| 43 |
MANUAL,"PLOT |
|
| 44 |
MANUAL",, |
|
| 45 |
SUBPANEL,"PLOT |
|
| 46 |
SUBPANEL",, |
|
| 47 |
KINDCD_NC,"PLOT |
|
| 48 |
KINDCD_NC",, |
|
| 49 |
QA_STATUS,"PLOT |
|
| 50 |
QA_STATUS",, |
|
| 51 |
CREATED_BY,"PLOT |
|
| 52 |
CREATED_BY",, |
|
| 53 |
CREATED_DATE,"PLOT |
|
| 54 |
CREATED_DATE",, |
|
| 55 |
CREATED_IN_INSTANCE,"PLOT |
|
| 56 |
CREATED_IN_INSTANCE",, |
|
| 57 |
MODIFIED_BY,"PLOT |
|
| 58 |
MODIFIED_BY",, |
|
| 59 |
MODIFIED_DATE,"PLOT |
|
| 60 |
MODIFIED_DATE",, |
|
| 61 |
MODIFIED_IN_INSTANCE,"PLOT |
|
| 62 |
MODIFIED_IN_INSTANCE",, |
|
| 63 |
MICROPLOT_LOC,"PLOT |
|
| 64 |
MICROPLOT_LOC",, |
|
| 65 |
DECLINATION,"PLOT |
|
| 66 |
DECLINATION",, |
|
| 67 |
EMAP_HEX,"PLOT |
|
| 68 |
EMAP_HEX",, |
|
| 69 |
SAMP_METHOD_CD,"PLOT |
|
| 70 |
SAMP_METHOD_CD",, |
|
| 71 |
SUBP_EXAMINE_CD,"PLOT |
|
| 72 |
SUBP_EXAMINE_CD",, |
|
| 73 |
MACRO_BREAKPOINT_DIA,"PLOT |
|
| 74 |
MACRO_BREAKPOINT_DIA",, |
|
| 75 |
INTENSITY,"PLOT |
|
| 76 |
INTENSITY",, |
|
| 77 |
CYCLE,"PLOT |
|
| 78 |
CYCLE",, |
|
| 79 |
SUBCYCLE,"PLOT |
|
| 80 |
SUBCYCLE",, |
|
| 81 |
ECO_UNIT_PNW,"PLOT |
|
| 82 |
ECO_UNIT_PNW",, |
|
| 83 |
TOPO_POSITION_PNW,"PLOT |
|
| 84 |
TOPO_POSITION_PNW",, |
|
| 85 |
NF_SAMPLING_STATUS_CD,"PLOT |
|
| 86 |
NF_SAMPLING_STATUS_CD",, |
|
| 87 |
NF_PLOT_STATUS_CD,"PLOT |
|
| 88 |
NF_PLOT_STATUS_CD",, |
|
| 89 |
NF_PLOT_NONSAMPLE_REASN_CD,"PLOT |
|
| 90 |
NF_PLOT_NONSAMPLE_REASN_CD",, |
|
| 91 |
P2VEG_SAMPLING_STATUS_CD,"PLOT |
|
| 92 |
P2VEG_SAMPLING_STATUS_CD",, |
|
| 93 |
P2VEG_SAMPLING_LEVEL_DETAIL_CD,"PLOT |
|
| 94 |
P2VEG_SAMPLING_LEVEL_DETAIL_CD",, |
|
| 95 |
INVASIVE_SAMPLING_STATUS_CD,"PLOT |
|
| 96 |
INVASIVE_SAMPLING_STATUS_CD",, |
|
| 97 |
INVASIVE_SPECIMEN_RULE_CD,"PLOT |
|
| 98 |
INVASIVE_SPECIMEN_RULE_CD",, |
|
| 99 |
DESIGNCD_P2A,"PLOT |
|
| 100 |
DESIGNCD_P2A",, |
|
| inputs/FIA/PLOT/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*PLOT.row_num |
|
| 2 |
*PLOT.SRV_CN |
|
| 3 |
*PLOT.CTY_CN |
|
| 4 |
*PLOT.PREV_PLT_CN |
|
| 1 |
"PLOT |
|
| 2 |
row_num" |
|
| 3 |
"PLOT |
|
| 4 |
SRV_CN" |
|
| 5 |
"PLOT |
|
| 6 |
CTY_CN" |
|
| 7 |
"PLOT |
|
| 8 |
PREV_PLT_CN" |
|
| 5 | 9 |
INVYR |
| 6 | 10 |
STATECD |
| 7 | 11 |
UNITCD |
| 8 | 12 |
COUNTYCD |
| 9 |
*PLOT.PLOT_STATUS_CD |
|
| 10 |
*PLOT.PLOT_NONSAMPLE_REASN_CD |
|
| 13 |
"PLOT |
|
| 14 |
PLOT_STATUS_CD" |
|
| 15 |
"PLOT |
|
| 16 |
PLOT_NONSAMPLE_REASN_CD" |
|
| 11 | 17 |
year |
| 12 | 18 |
month |
| 13 | 19 |
day |
| 14 |
*PLOT.REMPER |
|
| 15 |
*PLOT.KINDCD |
|
| 16 |
*PLOT.DESIGNCD |
|
| 17 |
*PLOT.RDDISTCD |
|
| 18 |
*PLOT.WATERCD |
|
| 19 |
*PLOT.GROW_TYP_CD |
|
| 20 |
*PLOT.MORT_TYP_CD |
|
| 21 |
*PLOT.P2PANEL |
|
| 22 |
*PLOT.P3PANEL |
|
| 23 |
*PLOT.ECOSUBCD |
|
| 24 |
*PLOT.CONGCD |
|
| 25 |
*PLOT.MANUAL |
|
| 26 |
*PLOT.SUBPANEL |
|
| 27 |
*PLOT.KINDCD_NC |
|
| 28 |
*PLOT.QA_STATUS |
|
| 29 |
*PLOT.CREATED_BY |
|
| 30 |
*PLOT.CREATED_DATE |
|
| 31 |
*PLOT.CREATED_IN_INSTANCE |
|
| 32 |
*PLOT.MODIFIED_BY |
|
| 33 |
*PLOT.MODIFIED_DATE |
|
| 34 |
*PLOT.MODIFIED_IN_INSTANCE |
|
| 35 |
*PLOT.MICROPLOT_LOC |
|
| 36 |
*PLOT.DECLINATION |
|
| 37 |
*PLOT.EMAP_HEX |
|
| 38 |
*PLOT.SAMP_METHOD_CD |
|
| 39 |
*PLOT.SUBP_EXAMINE_CD |
|
| 40 |
*PLOT.MACRO_BREAKPOINT_DIA |
|
| 41 |
*PLOT.INTENSITY |
|
| 42 |
*PLOT.CYCLE |
|
| 43 |
*PLOT.SUBCYCLE |
|
| 44 |
*PLOT.ECO_UNIT_PNW |
|
| 45 |
*PLOT.TOPO_POSITION_PNW |
|
| 46 |
*PLOT.NF_SAMPLING_STATUS_CD |
|
| 47 |
*PLOT.NF_PLOT_STATUS_CD |
|
| 48 |
*PLOT.NF_PLOT_NONSAMPLE_REASN_CD |
|
| 49 |
*PLOT.P2VEG_SAMPLING_STATUS_CD |
|
| 50 |
*PLOT.P2VEG_SAMPLING_LEVEL_DETAIL_CD |
|
| 51 |
*PLOT.INVASIVE_SAMPLING_STATUS_CD |
|
| 52 |
*PLOT.INVASIVE_SPECIMEN_RULE_CD |
|
| 53 |
*PLOT.DESIGNCD_P2A |
|
| 20 |
"PLOT |
|
| 21 |
REMPER" |
|
| 22 |
"PLOT |
|
| 23 |
KINDCD" |
|
| 24 |
"PLOT |
|
| 25 |
DESIGNCD" |
|
| 26 |
"PLOT |
|
| 27 |
RDDISTCD" |
|
| 28 |
"PLOT |
|
| 29 |
WATERCD" |
|
| 30 |
"PLOT |
|
| 31 |
GROW_TYP_CD" |
|
| 32 |
"PLOT |
|
| 33 |
MORT_TYP_CD" |
|
| 34 |
"PLOT |
|
| 35 |
P2PANEL" |
|
| 36 |
"PLOT |
|
| 37 |
P3PANEL" |
|
| 38 |
"PLOT |
|
| 39 |
ECOSUBCD" |
|
| 40 |
"PLOT |
|
| 41 |
CONGCD" |
|
| 42 |
"PLOT |
|
| 43 |
MANUAL" |
|
| 44 |
"PLOT |
|
| 45 |
SUBPANEL" |
|
| 46 |
"PLOT |
|
| 47 |
KINDCD_NC" |
|
| 48 |
"PLOT |
|
| 49 |
QA_STATUS" |
|
| 50 |
"PLOT |
|
| 51 |
CREATED_BY" |
|
| 52 |
"PLOT |
|
| 53 |
CREATED_DATE" |
|
| 54 |
"PLOT |
|
| 55 |
CREATED_IN_INSTANCE" |
|
| 56 |
"PLOT |
|
| 57 |
MODIFIED_BY" |
|
| 58 |
"PLOT |
|
| 59 |
MODIFIED_DATE" |
|
| 60 |
"PLOT |
|
| 61 |
MODIFIED_IN_INSTANCE" |
|
| 62 |
"PLOT |
|
| 63 |
MICROPLOT_LOC" |
|
| 64 |
"PLOT |
|
| 65 |
DECLINATION" |
|
| 66 |
"PLOT |
|
| 67 |
EMAP_HEX" |
|
| 68 |
"PLOT |
|
| 69 |
SAMP_METHOD_CD" |
|
| 70 |
"PLOT |
|
| 71 |
SUBP_EXAMINE_CD" |
|
| 72 |
"PLOT |
|
| 73 |
MACRO_BREAKPOINT_DIA" |
|
| 74 |
"PLOT |
|
| 75 |
INTENSITY" |
|
| 76 |
"PLOT |
|
| 77 |
CYCLE" |
|
| 78 |
"PLOT |
|
| 79 |
SUBCYCLE" |
|
| 80 |
"PLOT |
|
| 81 |
ECO_UNIT_PNW" |
|
| 82 |
"PLOT |
|
| 83 |
TOPO_POSITION_PNW" |
|
| 84 |
"PLOT |
|
| 85 |
NF_SAMPLING_STATUS_CD" |
|
| 86 |
"PLOT |
|
| 87 |
NF_PLOT_STATUS_CD" |
|
| 88 |
"PLOT |
|
| 89 |
NF_PLOT_NONSAMPLE_REASN_CD" |
|
| 90 |
"PLOT |
|
| 91 |
P2VEG_SAMPLING_STATUS_CD" |
|
| 92 |
"PLOT |
|
| 93 |
P2VEG_SAMPLING_LEVEL_DETAIL_CD" |
|
| 94 |
"PLOT |
|
| 95 |
INVASIVE_SAMPLING_STATUS_CD" |
|
| 96 |
"PLOT |
|
| 97 |
INVASIVE_SPECIMEN_RULE_CD" |
|
| 98 |
"PLOT |
|
| 99 |
DESIGNCD_P2A" |
|
| inputs/FIA/Organism/map.csv | ||
|---|---|---|
| 11 | 11 |
StateProvince,stateProvince,, |
| 12 | 12 |
County,county,, |
| 13 | 13 |
DBH,diameterBreastHeight_in,,Assuming units based on the range and precision of values and location inside the U.S. |
| 14 |
HOM,*HOM,,
|
|
| 14 |
HOM,HOM,, |
|
| 15 | 15 |
BasalDiameter,basalDiameter_in,,Assuming units are the same as for DBH because the values are similar and they measure the same dimension |
| 16 | 16 |
Height,height_ft,,"Assuming units based on the range of values, the height of the tallest tree [1], and location inside the U.S. |
| 17 | 17 |
|
| inputs/FIA/COUNTY/map.csv | ||
|---|---|---|
| 1 | 1 |
FIA,VegCore,Filter,Comments |
| 2 |
row_num,*COUNTY.row_num,, |
|
| 2 |
row_num,"COUNTY |
|
| 3 |
row_num",, |
|
| 3 | 4 |
STATECD,STATECD,, |
| 4 | 5 |
UNITCD,UNITCD,, |
| 5 | 6 |
COUNTYCD,COUNTYCD,, |
| 6 | 7 |
COUNTYNM,county,, |
| 7 |
CN,*COUNTY.CN,, |
|
| 8 |
CREATED_BY,*COUNTY.CREATED_BY,, |
|
| 9 |
CREATED_DATE,*COUNTY.CREATED_DATE,, |
|
| 10 |
CREATED_IN_INSTANCE,*COUNTY.CREATED_IN_INSTANCE,, |
|
| 11 |
MODIFIED_BY,*COUNTY.MODIFIED_BY,, |
|
| 12 |
MODIFIED_DATE,*COUNTY.MODIFIED_DATE,, |
|
| 13 |
MODIFIED_IN_INSTANCE,*COUNTY.MODIFIED_IN_INSTANCE,, |
|
| 8 |
CN,"COUNTY |
|
| 9 |
CN",, |
|
| 10 |
CREATED_BY,"COUNTY |
|
| 11 |
CREATED_BY",, |
|
| 12 |
CREATED_DATE,"COUNTY |
|
| 13 |
CREATED_DATE",, |
|
| 14 |
CREATED_IN_INSTANCE,"COUNTY |
|
| 15 |
CREATED_IN_INSTANCE",, |
|
| 16 |
MODIFIED_BY,"COUNTY |
|
| 17 |
MODIFIED_BY",, |
|
| 18 |
MODIFIED_DATE,"COUNTY |
|
| 19 |
MODIFIED_DATE",, |
|
| 20 |
MODIFIED_IN_INSTANCE,"COUNTY |
|
| 21 |
MODIFIED_IN_INSTANCE",, |
|
| inputs/FIA/COUNTY/import | ||
|---|---|---|
| 11 | 11 |
, ('COUNTYCD', 'integer')
|
| 12 | 12 |
]::functions.col_cast[]); |
| 13 | 13 |
|
| 14 |
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID" UNIQUE ("*COUNTY.CN")$$);
|
|
| 14 |
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID" UNIQUE ("COUNTY
|
|
| 15 |
CN")$$); |
|
| 15 | 16 |
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD")$$);
|
| inputs/FIA/COUNTY/new_terms.csv | ||
|---|---|---|
| 1 |
row_num,*COUNTY.row_num,, |
|
| 1 |
row_num,"COUNTY |
|
| 2 |
row_num",, |
|
| 2 | 3 |
COUNTYNM,county,, |
| 3 |
CN,*COUNTY.CN,, |
|
| 4 |
CREATED_BY,*COUNTY.CREATED_BY,, |
|
| 5 |
CREATED_DATE,*COUNTY.CREATED_DATE,, |
|
| 6 |
CREATED_IN_INSTANCE,*COUNTY.CREATED_IN_INSTANCE,, |
|
| 7 |
MODIFIED_BY,*COUNTY.MODIFIED_BY,, |
|
| 8 |
MODIFIED_DATE,*COUNTY.MODIFIED_DATE,, |
|
| 9 |
MODIFIED_IN_INSTANCE,*COUNTY.MODIFIED_IN_INSTANCE,, |
|
| 4 |
CN,"COUNTY |
|
| 5 |
CN",, |
|
| 6 |
CREATED_BY,"COUNTY |
|
| 7 |
CREATED_BY",, |
|
| 8 |
CREATED_DATE,"COUNTY |
|
| 9 |
CREATED_DATE",, |
|
| 10 |
CREATED_IN_INSTANCE,"COUNTY |
|
| 11 |
CREATED_IN_INSTANCE",, |
|
| 12 |
MODIFIED_BY,"COUNTY |
|
| 13 |
MODIFIED_BY",, |
|
| 14 |
MODIFIED_DATE,"COUNTY |
|
| 15 |
MODIFIED_DATE",, |
|
| 16 |
MODIFIED_IN_INSTANCE,"COUNTY |
|
| 17 |
MODIFIED_IN_INSTANCE",, |
|
| inputs/FIA/COUNTY/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*COUNTY.row_num |
|
| 1 |
"COUNTY |
|
| 2 |
row_num" |
|
| 2 | 3 |
STATECD |
| 3 | 4 |
UNITCD |
| 4 | 5 |
COUNTYCD |
| 5 |
*COUNTY.CN |
|
| 6 |
*COUNTY.CREATED_BY |
|
| 7 |
*COUNTY.CREATED_DATE |
|
| 8 |
*COUNTY.CREATED_IN_INSTANCE |
|
| 9 |
*COUNTY.MODIFIED_BY |
|
| 10 |
*COUNTY.MODIFIED_DATE |
|
| 11 |
*COUNTY.MODIFIED_IN_INSTANCE |
|
| 6 |
"COUNTY |
|
| 7 |
CN" |
|
| 8 |
"COUNTY |
|
| 9 |
CREATED_BY" |
|
Also available in: Unified diff
inputs/FIA/*/map.csv: Replaced . between table and column name with newline, so that table viewers like pgAdmin will display both the table and column name at the left edge of the header cell, rather than displaying only the table name because the column name doesn't fit. This fixes the problem of seeing a bunch of columns whose names all start with a table name, and not knowing what each of them is. It also preserves the ability to see at a glance which table a column is in, which helps in navigating wide tables. Removed * before unmapped terms, because whether a term is mapped is generally obvious from the table name itself.