Project

General

Profile

« Previous | Next » 

Revision 8164

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/FIA/*/import: Use map_table to set column names based on the contents of map.csv, instead of using functions.to_global_col_names() and functions.rename_if_exists(). Added map.csv for all tables.

View differences:

inputs/FIA/REF_SPECIES/unmapped_terms.csv
1 
*REF_SPECIES.row_num
2 
.SPCD
3 
*REF_SPECIES.COMMON_NAME
4 
*REF_SPECIES.GENUS
5 
*REF_SPECIES.SPECIES
6 
*REF_SPECIES.VARIETY
7 
*REF_SPECIES.SUBSPECIES
8 
.SYMBOL
9 
*REF_SPECIES.E_SPGRPCD
10 
*REF_SPECIES.W_SPGRPCD
11 
*REF_SPECIES.C_SPGRPCD
12 
*REF_SPECIES.P_SPGRPCD
13 
*REF_SPECIES.MAJOR_SPGRPCD
14 
*REF_SPECIES.STOCKING_SPGRPCD
15 
*REF_SPECIES.FOREST_TYPE_SPGRPCD
16 
*REF_SPECIES.EXISTS_IN_NCRS
17 
*REF_SPECIES.EXISTS_IN_NERS
18 
*REF_SPECIES.EXISTS_IN_PNWRS
19 
*REF_SPECIES.EXISTS_IN_RMRS
20 
*REF_SPECIES.EXISTS_IN_SRS
21 
*REF_SPECIES.SITETREE
22 
*REF_SPECIES.SFTWD_HRDWD
23 
*REF_SPECIES.ST_EXISTS_IN_NCRS
24 
*REF_SPECIES.ST_EXISTS_IN_NERS
25 
*REF_SPECIES.ST_EXISTS_IN_PNWRS
26 
*REF_SPECIES.ST_EXISTS_IN_RMRS
27 
*REF_SPECIES.ST_EXISTS_IN_SRS
28 
*REF_SPECIES.CORE
29 
*REF_SPECIES.EAST
30 
*REF_SPECIES.WEST
31 
*REF_SPECIES.CARIBBEAN
32 
*REF_SPECIES.PACIFIC
33 
*REF_SPECIES.WOODLAND
34 
*REF_SPECIES.MANUAL_START
35 
*REF_SPECIES.MANUAL_END
36 
*REF_SPECIES.JENKINS_SPGRPCD
37 
*REF_SPECIES.JENKINS_TOTAL_B1
38 
*REF_SPECIES.JENKINS_TOTAL_B2
39 
*REF_SPECIES.JENKINS_STEM_WOOD_RATIO_B1
40 
*REF_SPECIES.JENKINS_STEM_WOOD_RATIO_B2
41 
*REF_SPECIES.JENKINS_STEM_BARK_RATIO_B1
42 
*REF_SPECIES.JENKINS_STEM_BARK_RATIO_B2
43 
*REF_SPECIES.JENKINS_FOLIAGE_RATIO_B1
44 
*REF_SPECIES.JENKINS_FOLIAGE_RATIO_B2
45 
*REF_SPECIES.JENKINS_ROOT_RATIO_B1
46 
*REF_SPECIES.JENKINS_ROOT_RATIO_B2
47 
*REF_SPECIES.JENKINS_SAPLING_ADJUSTMENT
48 
*REF_SPECIES.WOOD_SPGR_GREENVOL_DRYWT
49 
*REF_SPECIES.WOOD_SPGR_GREENVOL_DRYWT_CIT
50 
*REF_SPECIES.BARK_SPGR_GREENVOL_DRYWT
51 
*REF_SPECIES.BARK_SPGR_GREENVOL_DRYWT_CIT
52 
*REF_SPECIES.MC_PCT_GREEN_BARK
53 
*REF_SPECIES.MC_PCT_GREEN_BARK_CIT
54 
*REF_SPECIES.MC_PCT_GREEN_WOOD
55 
*REF_SPECIES.MC_PCT_GREEN_WOOD_CIT
56 
*REF_SPECIES.WOOD_SPGR_MC12VOL_DRYWT
57 
*REF_SPECIES.WOOD_SPGR_MC12VOL_DRYWT_CIT
58 
*REF_SPECIES.BARK_VOL_PCT
59 
*REF_SPECIES.BARK_VOL_PCT_CIT
60 
*REF_SPECIES.RAILE_STUMP_DOB_B1
61 
*REF_SPECIES.RAILE_STUMP_DIB_B1
62 
*REF_SPECIES.RAILE_STUMP_DIB_B2
63 
*REF_SPECIES.CWD_DECAY_RATIO1
64 
*REF_SPECIES.CWD_DECAY_RATIO2
65 
*REF_SPECIES.CWD_DECAY_RATIO3
66 
*REF_SPECIES.CWD_DECAY_RATIO4
67 
*REF_SPECIES.CWD_DECAY_RATIO5
68 
*REF_SPECIES.DWM_CARBON_RATIO
69 
*REF_SPECIES.STANDING_DEAD_DECAY_RATIO1
70 
*REF_SPECIES.STANDING_DEAD_DECAY_RATIO2
71 
*REF_SPECIES.STANDING_DEAD_DECAY_RATIO3
72 
*REF_SPECIES.STANDING_DEAD_DECAY_RATIO4
73 
*REF_SPECIES.STANDING_DEAD_DECAY_RATIO5
74 
*REF_SPECIES.CREATED_BY
75 
*REF_SPECIES.CREATED_DATE
76 
*REF_SPECIES.CREATED_IN_INSTANCE
77 
*REF_SPECIES.MODIFIED_BY
78 
*REF_SPECIES.MODIFIED_DATE
79 
*REF_SPECIES.MODIFIED_IN_INSTANCE
inputs/FIA/TREE/map.csv
1 
FIA,VegCore,Filter,Comments
2 
row_num,*TREE.row_num,,
3 
CN,*TREE.CN,,
4 
PLT_CN,*TREE.PLT_CN,,
5 
PREV_TRE_CN,*TREE.PREV_TRE_CN,,
6 
INVYR,.INVYR,,
7 
STATECD,.STATECD,,
8 
UNITCD,.UNITCD,,
9 
COUNTYCD,.COUNTYCD,,
10 
PLOT,.PLOT,,
11 
SUBP,.SUBP,,
12 
TREE,*TREE.TREE,,
13 
CONDID,.CONDID,,
14 
AZIMUTH,*TREE.AZIMUTH,,
15 
DIST,*TREE.DIST,,
16 
PREVCOND,*TREE.PREVCOND,,
17 
STATUSCD,*TREE.STATUSCD,,
18 
SPCD,.SPCD,,
19 
SPGRPCD,*TREE.SPGRPCD,,
20 
DIA,*TREE.DIA,,
21 
DIAHTCD,*TREE.DIAHTCD,,
22 
HT,*TREE.HT,,
23 
HTCD,*TREE.HTCD,,
24 
ACTUALHT,*TREE.ACTUALHT,,
25 
TREECLCD,*TREE.TREECLCD,,
26 
CR,*TREE.CR,,
27 
CCLCD,*TREE.CCLCD,,
28 
TREEGRCD,*TREE.TREEGRCD,,
29 
AGENTCD,*TREE.AGENTCD,,
30 
CULL,*TREE.CULL,,
31 
DAMLOC1,*TREE.DAMLOC1,,
32 
DAMTYP1,*TREE.DAMTYP1,,
33 
DAMSEV1,*TREE.DAMSEV1,,
34 
DAMLOC2,*TREE.DAMLOC2,,
35 
DAMTYP2,*TREE.DAMTYP2,,
36 
DAMSEV2,*TREE.DAMSEV2,,
37 
DECAYCD,*TREE.DECAYCD,,
38 
STOCKING,*TREE.STOCKING,,
39 
WDLDSTEM,*TREE.WDLDSTEM,,
40 
VOLCFNET,*TREE.VOLCFNET,,
41 
VOLCFGRS,*TREE.VOLCFGRS,,
42 
VOLCSNET,*TREE.VOLCSNET,,
43 
VOLCSGRS,*TREE.VOLCSGRS,,
44 
VOLBFNET,*TREE.VOLBFNET,,
45 
VOLBFGRS,*TREE.VOLBFGRS,,
46 
VOLCFSND,*TREE.VOLCFSND,,
47 
GROWCFGS,*TREE.GROWCFGS,,
48 
GROWBFSL,*TREE.GROWBFSL,,
49 
GROWCFAL,*TREE.GROWCFAL,,
50 
MORTCFGS,*TREE.MORTCFGS,,
51 
MORTBFSL,*TREE.MORTBFSL,,
52 
MORTCFAL,*TREE.MORTCFAL,,
53 
REMVCFGS,*TREE.REMVCFGS,,
54 
REMVBFSL,*TREE.REMVBFSL,,
55 
REMVCFAL,*TREE.REMVCFAL,,
56 
DIACHECK,*TREE.DIACHECK,,
57 
MORTYR,*TREE.MORTYR,,
58 
SALVCD,*TREE.SALVCD,,
59 
UNCRCD,*TREE.UNCRCD,,
60 
CPOSCD,*TREE.CPOSCD,,
61 
CLIGHTCD,*TREE.CLIGHTCD,,
62 
CVIGORCD,*TREE.CVIGORCD,,
63 
CDENCD,*TREE.CDENCD,,
64 
CDIEBKCD,*TREE.CDIEBKCD,,
65 
TRANSCD,*TREE.TRANSCD,,
66 
TREEHISTCD,*TREE.TREEHISTCD,,
67 
DIACALC,*TREE.DIACALC,,
68 
BHAGE,*TREE.BHAGE,,
69 
TOTAGE,*TREE.TOTAGE,,
70 
CULLDEAD,*TREE.CULLDEAD,,
71 
CULLFORM,*TREE.CULLFORM,,
72 
CULLMSTOP,*TREE.CULLMSTOP,,
73 
CULLBF,*TREE.CULLBF,,
74 
CULLCF,*TREE.CULLCF,,
75 
BFSND,*TREE.BFSND,,
76 
CFSND,*TREE.CFSND,,
77 
SAWHT,*TREE.SAWHT,,
78 
BOLEHT,*TREE.BOLEHT,,
79 
FORMCL,*TREE.FORMCL,,
80 
HTCALC,*TREE.HTCALC,,
81 
HRDWD_CLUMP_CD,*TREE.HRDWD_CLUMP_CD,,
82 
SITREE,*TREE.SITREE,,
83 
CREATED_BY,*TREE.CREATED_BY,,
84 
CREATED_DATE,*TREE.CREATED_DATE,,
85 
CREATED_IN_INSTANCE,*TREE.CREATED_IN_INSTANCE,,
86 
MODIFIED_BY,*TREE.MODIFIED_BY,,
87 
MODIFIED_DATE,*TREE.MODIFIED_DATE,,
88 
MODIFIED_IN_INSTANCE,*TREE.MODIFIED_IN_INSTANCE,,
89 
MORTCD,*TREE.MORTCD,,
90 
HTDMP,*TREE.HTDMP,,
91 
ROUGHCULL,*TREE.ROUGHCULL,,
92 
MIST_CL_CD,*TREE.MIST_CL_CD,,
93 
CULL_FLD,*TREE.CULL_FLD,,
94 
RECONCILECD,*TREE.RECONCILECD,,
95 
PREVDIA,*TREE.PREVDIA,,
96 
FGROWCFGS,*TREE.FGROWCFGS,,
97 
FGROWBFSL,*TREE.FGROWBFSL,,
98 
FGROWCFAL,*TREE.FGROWCFAL,,
99 
FMORTCFGS,*TREE.FMORTCFGS,,
100 
FMORTBFSL,*TREE.FMORTBFSL,,
101 
FMORTCFAL,*TREE.FMORTCFAL,,
102 
FREMVCFGS,*TREE.FREMVCFGS,,
103 
FREMVBFSL,*TREE.FREMVBFSL,,
104 
FREMVCFAL,*TREE.FREMVCFAL,,
105 
P2A_GRM_FLG,*TREE.P2A_GRM_FLG,,
106 
TREECLCD_NERS,*TREE.TREECLCD_NERS,,
107 
TREECLCD_SRS,*TREE.TREECLCD_SRS,,
108 
TREECLCD_NCRS,*TREE.TREECLCD_NCRS,,
109 
TREECLCD_RMRS,*TREE.TREECLCD_RMRS,,
110 
STANDING_DEAD_CD,*TREE.STANDING_DEAD_CD,,
111 
PREV_STATUS_CD,*TREE.PREV_STATUS_CD,,
112 
PREV_WDLDSTEM,*TREE.PREV_WDLDSTEM,,
113 
TPA_UNADJ,*TREE.TPA_UNADJ,,
114 
TPAMORT_UNADJ,*TREE.TPAMORT_UNADJ,,
115 
TPAREMV_UNADJ,*TREE.TPAREMV_UNADJ,,
116 
TPAGROW_UNADJ,*TREE.TPAGROW_UNADJ,,
117 
DRYBIO_BOLE,*TREE.DRYBIO_BOLE,,
118 
DRYBIO_TOP,*TREE.DRYBIO_TOP,,
119 
DRYBIO_STUMP,*TREE.DRYBIO_STUMP,,
120 
DRYBIO_SAPLING,*TREE.DRYBIO_SAPLING,,
121 
DRYBIO_WDLD_SPP,*TREE.DRYBIO_WDLD_SPP,,
122 
DRYBIO_BG,*TREE.DRYBIO_BG,,
123 
CARBON_AG,*TREE.CARBON_AG,,
124 
CARBON_BG,*TREE.CARBON_BG,,
125 
CYCLE,*TREE.CYCLE,,
126 
SUBCYCLE,*TREE.SUBCYCLE,,
127 
BORED_CD_PNWRS,*TREE.BORED_CD_PNWRS,,
128 
DAMLOC1_PNWRS,*TREE.DAMLOC1_PNWRS,,
129 
DAMLOC2_PNWRS,*TREE.DAMLOC2_PNWRS,,
130 
DIACHECK_PNWRS,*TREE.DIACHECK_PNWRS,,
131 
DMG_AGENT1_CD_PNWRS,*TREE.DMG_AGENT1_CD_PNWRS,,
132 
DMG_AGENT2_CD_PNWRS,*TREE.DMG_AGENT2_CD_PNWRS,,
133 
DMG_AGENT3_CD_PNWRS,*TREE.DMG_AGENT3_CD_PNWRS,,
134 
MIST_CL_CD_PNWRS,*TREE.MIST_CL_CD_PNWRS,,
135 
SEVERITY1_CD_PNWRS,*TREE.SEVERITY1_CD_PNWRS,,
136 
SEVERITY1A_CD_PNWRS,*TREE.SEVERITY1A_CD_PNWRS,,
137 
SEVERITY1B_CD_PNWRS,*TREE.SEVERITY1B_CD_PNWRS,,
138 
SEVERITY2_CD_PNWRS,*TREE.SEVERITY2_CD_PNWRS,,
139 
SEVERITY2A_CD_PNWRS,*TREE.SEVERITY2A_CD_PNWRS,,
140 
SEVERITY2B_CD_PNWRS,*TREE.SEVERITY2B_CD_PNWRS,,
141 
SEVERITY3_CD_PNWRS,*TREE.SEVERITY3_CD_PNWRS,,
142 
UNKNOWN_DAMTYP1_PNWRS,*TREE.UNKNOWN_DAMTYP1_PNWRS,,
143 
UNKNOWN_DAMTYP2_PNWRS,*TREE.UNKNOWN_DAMTYP2_PNWRS,,
144 
PREV_PNTN_SRS,*TREE.PREV_PNTN_SRS,,
145 
DISEASE_SRS,*TREE.DISEASE_SRS,,
146 
DIEBACK_SEVERITY_SRS,*TREE.DIEBACK_SEVERITY_SRS,,
inputs/FIA/TREE/unmapped_terms.csv
1 
*TREE.row_num
2 
*TREE.CN
3 
*TREE.PLT_CN
4 
*TREE.PREV_TRE_CN
5 
.INVYR
6 
.STATECD
7 
.UNITCD
8 
.COUNTYCD
9 
.PLOT
10 
.SUBP
11 
*TREE.TREE
12 
.CONDID
13 
*TREE.AZIMUTH
14 
*TREE.DIST
15 
*TREE.PREVCOND
16 
*TREE.STATUSCD
17 
.SPCD
18 
*TREE.SPGRPCD
19 
*TREE.DIA
20 
*TREE.DIAHTCD
21 
*TREE.HT
22 
*TREE.HTCD
23 
*TREE.ACTUALHT
24 
*TREE.TREECLCD
25 
*TREE.CR
26 
*TREE.CCLCD
27 
*TREE.TREEGRCD
28 
*TREE.AGENTCD
29 
*TREE.CULL
30 
*TREE.DAMLOC1
31 
*TREE.DAMTYP1
32 
*TREE.DAMSEV1
33 
*TREE.DAMLOC2
34 
*TREE.DAMTYP2
35 
*TREE.DAMSEV2
36 
*TREE.DECAYCD
37 
*TREE.STOCKING
38 
*TREE.WDLDSTEM
39 
*TREE.VOLCFNET
40 
*TREE.VOLCFGRS
41 
*TREE.VOLCSNET
42 
*TREE.VOLCSGRS
43 
*TREE.VOLBFNET
44 
*TREE.VOLBFGRS
45 
*TREE.VOLCFSND
46 
*TREE.GROWCFGS
47 
*TREE.GROWBFSL
48 
*TREE.GROWCFAL
49 
*TREE.MORTCFGS
50 
*TREE.MORTBFSL
51 
*TREE.MORTCFAL
52 
*TREE.REMVCFGS
53 
*TREE.REMVBFSL
54 
*TREE.REMVCFAL
55 
*TREE.DIACHECK
56 
*TREE.MORTYR
57 
*TREE.SALVCD
58 
*TREE.UNCRCD
59 
*TREE.CPOSCD
60 
*TREE.CLIGHTCD
61 
*TREE.CVIGORCD
62 
*TREE.CDENCD
63 
*TREE.CDIEBKCD
64 
*TREE.TRANSCD
65 
*TREE.TREEHISTCD
66 
*TREE.DIACALC
67 
*TREE.BHAGE
68 
*TREE.TOTAGE
69 
*TREE.CULLDEAD
70 
*TREE.CULLFORM
71 
*TREE.CULLMSTOP
72 
*TREE.CULLBF
73 
*TREE.CULLCF
74 
*TREE.BFSND
75 
*TREE.CFSND
76 
*TREE.SAWHT
77 
*TREE.BOLEHT
78 
*TREE.FORMCL
79 
*TREE.HTCALC
80 
*TREE.HRDWD_CLUMP_CD
81 
*TREE.SITREE
82 
*TREE.CREATED_BY
83 
*TREE.CREATED_DATE
84 
*TREE.CREATED_IN_INSTANCE
85 
*TREE.MODIFIED_BY
86 
*TREE.MODIFIED_DATE
87 
*TREE.MODIFIED_IN_INSTANCE
88 
*TREE.MORTCD
89 
*TREE.HTDMP
90 
*TREE.ROUGHCULL
91 
*TREE.MIST_CL_CD
92 
*TREE.CULL_FLD
93 
*TREE.RECONCILECD
94 
*TREE.PREVDIA
95 
*TREE.FGROWCFGS
96 
*TREE.FGROWBFSL
97 
*TREE.FGROWCFAL
98 
*TREE.FMORTCFGS
99 
*TREE.FMORTBFSL
100 
*TREE.FMORTCFAL
101 
*TREE.FREMVCFGS
102 
*TREE.FREMVBFSL
103 
*TREE.FREMVCFAL
104 
*TREE.P2A_GRM_FLG
105 
*TREE.TREECLCD_NERS
106 
*TREE.TREECLCD_SRS
107 
*TREE.TREECLCD_NCRS
108 
*TREE.TREECLCD_RMRS
109 
*TREE.STANDING_DEAD_CD
110 
*TREE.PREV_STATUS_CD
111 
*TREE.PREV_WDLDSTEM
112 
*TREE.TPA_UNADJ
113 
*TREE.TPAMORT_UNADJ
114 
*TREE.TPAREMV_UNADJ
115 
*TREE.TPAGROW_UNADJ
116 
*TREE.DRYBIO_BOLE
117 
*TREE.DRYBIO_TOP
118 
*TREE.DRYBIO_STUMP
119 
*TREE.DRYBIO_SAPLING
120 
*TREE.DRYBIO_WDLD_SPP
121 
*TREE.DRYBIO_BG
122 
*TREE.CARBON_AG
123 
*TREE.CARBON_BG
124 
*TREE.CYCLE
125 
*TREE.SUBCYCLE
126 
*TREE.BORED_CD_PNWRS
127 
*TREE.DAMLOC1_PNWRS
128 
*TREE.DAMLOC2_PNWRS
129 
*TREE.DIACHECK_PNWRS
130 
*TREE.DMG_AGENT1_CD_PNWRS
131 
*TREE.DMG_AGENT2_CD_PNWRS
132 
*TREE.DMG_AGENT3_CD_PNWRS
133 
*TREE.MIST_CL_CD_PNWRS
134 
*TREE.SEVERITY1_CD_PNWRS
135 
*TREE.SEVERITY1A_CD_PNWRS
136 
*TREE.SEVERITY1B_CD_PNWRS
137 
*TREE.SEVERITY2_CD_PNWRS
138 
*TREE.SEVERITY2A_CD_PNWRS
139 
*TREE.SEVERITY2B_CD_PNWRS
140 
*TREE.SEVERITY3_CD_PNWRS
141 
*TREE.UNKNOWN_DAMTYP1_PNWRS
142 
*TREE.UNKNOWN_DAMTYP2_PNWRS
143 
*TREE.PREV_PNTN_SRS
144 
*TREE.DISEASE_SRS
145 
*TREE.DIEBACK_SEVERITY_SRS
inputs/FIA/REF_HABTYP_DESCRIPTION/map.csv
1 
FIA,VegCore,Filter,Comments
2 
row_num,*REF_HABTYP_DESCRIPTION.row_num,,
3 
CN,*REF_HABTYP_DESCRIPTION.CN,,
4 
HABTYPCD,.HABTYPCD,,
5 
PUB_CD,.HABTYP_PUB_CD,,
6 
SCIENTIFIC_NAME,*REF_HABTYP_DESCRIPTION.SCIENTIFIC_NAME,,
7 
COMMON_NAME,*REF_HABTYP_DESCRIPTION.COMMON_NAME,,
8 
VALID,*REF_HABTYP_DESCRIPTION.VALID,,
9 
CREATED_BY,*REF_HABTYP_DESCRIPTION.CREATED_BY,,
10 
CREATED_DATE,*REF_HABTYP_DESCRIPTION.CREATED_DATE,,
11 
CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION.CREATED_IN_INSTANCE,,
12 
MODIFIED_BY,*REF_HABTYP_DESCRIPTION.MODIFIED_BY,,
13 
MODIFIED_DATE,*REF_HABTYP_DESCRIPTION.MODIFIED_DATE,,
14 
MODIFIED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION.MODIFIED_IN_INSTANCE,,
inputs/FIA/COND/map.csv
1 
FIA,VegCore,Filter,Comments
2 
row_num,*COND.row_num,,
3 
CN,*COND.CN,,
4 
PLT_CN,*COND.PLT_CN,,
5 
INVYR,.INVYR,,
6 
STATECD,.STATECD,,
7 
UNITCD,.UNITCD,,
8 
COUNTYCD,.COUNTYCD,,
9 
PLOT,.PLOT,,
10 
CONDID,.CONDID,,
11 
COND_STATUS_CD,*COND.COND_STATUS_CD,,
12 
COND_NONSAMPLE_REASN_CD,*COND.COND_NONSAMPLE_REASN_CD,,
13 
RESERVCD,*COND.RESERVCD,,
14 
OWNCD,*COND.OWNCD,,
15 
OWNGRPCD,*COND.OWNGRPCD,,
16 
FORINDCD,*COND.FORINDCD,,
17 
ADFORCD,*COND.ADFORCD,,
18 
FORTYPCD,*COND.FORTYPCD,,
19 
FLDTYPCD,*COND.FLDTYPCD,,
20 
MAPDEN,*COND.MAPDEN,,
21 
STDAGE,*COND.STDAGE,,
22 
STDSZCD,*COND.STDSZCD,,
23 
FLDSZCD,*COND.FLDSZCD,,
24 
SITECLCD,*COND.SITECLCD,,
25 
SICOND,*COND.SICOND,,
26 
SIBASE,*COND.SIBASE,,
27 
SISP,*COND.SISP,,
28 
STDORGCD,*COND.STDORGCD,,
29 
STDORGSP,*COND.STDORGSP,,
30 
PROP_BASIS,*COND.PROP_BASIS,,
31 
CONDPROP_UNADJ,*COND.CONDPROP_UNADJ,,
32 
MICRPROP_UNADJ,*COND.MICRPROP_UNADJ,,
33 
SUBPPROP_UNADJ,*COND.SUBPPROP_UNADJ,,
34 
MACRPROP_UNADJ,*COND.MACRPROP_UNADJ,,
35 
SLOPE,*COND.SLOPE,,
36 
ASPECT,*COND.ASPECT,,
37 
PHYSCLCD,*COND.PHYSCLCD,,
38 
GSSTKCD,*COND.GSSTKCD,,
39 
ALSTKCD,*COND.ALSTKCD,,
40 
DSTRBCD1,*COND.DSTRBCD1,,
41 
DSTRBYR1,*COND.DSTRBYR1,,
42 
DSTRBCD2,*COND.DSTRBCD2,,
43 
DSTRBYR2,*COND.DSTRBYR2,,
44 
DSTRBCD3,*COND.DSTRBCD3,,
45 
DSTRBYR3,*COND.DSTRBYR3,,
46 
TRTCD1,*COND.TRTCD1,,
47 
TRTYR1,*COND.TRTYR1,,
48 
TRTCD2,*COND.TRTCD2,,
49 
TRTYR2,*COND.TRTYR2,,
50 
TRTCD3,*COND.TRTCD3,,
51 
TRTYR3,*COND.TRTYR3,,
52 
PRESNFCD,*COND.PRESNFCD,,
53 
BALIVE,*COND.BALIVE,,
54 
FLDAGE,*COND.FLDAGE,,
55 
ALSTK,*COND.ALSTK,,
56 
GSSTK,*COND.GSSTK,,
57 
FORTYPCDCALC,*COND.FORTYPCDCALC,,
58 
HABTYPCD1,.HABTYPCD,,
59 
HABTYPCD1_PUB_CD,.HABTYP_PUB_CD,,
60 
HABTYPCD1_DESCR_PUB_CD,*COND.HABTYPCD1_DESCR_PUB_CD,,
61 
HABTYPCD2,*COND.HABTYPCD2,,
62 
HABTYPCD2_PUB_CD,*COND.HABTYPCD2_PUB_CD,,
63 
HABTYPCD2_DESCR_PUB_CD,*COND.HABTYPCD2_DESCR_PUB_CD,,
64 
MIXEDCONFCD,*COND.MIXEDCONFCD,,
65 
VOL_LOC_GRP,*COND.VOL_LOC_GRP,,
66 
SITECLCDEST,*COND.SITECLCDEST,,
67 
SITETREE_TREE,*COND.SITETREE_TREE,,
68 
SITECL_METHOD,*COND.SITECL_METHOD,,
69 
CARBON_DOWN_DEAD,*COND.CARBON_DOWN_DEAD,,
70 
CARBON_LITTER,*COND.CARBON_LITTER,,
71 
CARBON_SOIL_ORG,*COND.CARBON_SOIL_ORG,,
72 
CARBON_STANDING_DEAD,*COND.CARBON_STANDING_DEAD,,
73 
CARBON_UNDERSTORY_AG,*COND.CARBON_UNDERSTORY_AG,,
74 
CARBON_UNDERSTORY_BG,*COND.CARBON_UNDERSTORY_BG,,
75 
CREATED_BY,*COND.CREATED_BY,,
76 
CREATED_DATE,*COND.CREATED_DATE,,
77 
CREATED_IN_INSTANCE,*COND.CREATED_IN_INSTANCE,,
78 
MODIFIED_BY,*COND.MODIFIED_BY,,
79 
MODIFIED_DATE,*COND.MODIFIED_DATE,,
80 
MODIFIED_IN_INSTANCE,*COND.MODIFIED_IN_INSTANCE,,
81 
CYCLE,*COND.CYCLE,,
82 
SUBCYCLE,*COND.SUBCYCLE,,
83 
SOIL_ROOTING_DEPTH_PNW,*COND.SOIL_ROOTING_DEPTH_PNW,,
84 
GROUND_LAND_CLASS_PNW,*COND.GROUND_LAND_CLASS_PNW,,
85 
PLANT_STOCKABILITY_FACTOR_PNW,*COND.PLANT_STOCKABILITY_FACTOR_PNW,,
86 
STND_COND_CD_PNWRS,*COND.STND_COND_CD_PNWRS,,
87 
STND_STRUC_CD_PNWRS,*COND.STND_STRUC_CD_PNWRS,,
88 
STUMP_CD_PNWRS,*COND.STUMP_CD_PNWRS,,
89 
FIRE_SRS,*COND.FIRE_SRS,,
90 
GRAZING_SRS,*COND.GRAZING_SRS,,
91 
HARVEST_TYPE1_SRS,*COND.HARVEST_TYPE1_SRS,,
92 
HARVEST_TYPE2_SRS,*COND.HARVEST_TYPE2_SRS,,
93 
HARVEST_TYPE3_SRS,*COND.HARVEST_TYPE3_SRS,,
94 
LAND_USE_SRS,*COND.LAND_USE_SRS,,
95 
OPERABILITY_SRS,*COND.OPERABILITY_SRS,,
96 
STAND_STRUCTURE_SRS,*COND.STAND_STRUCTURE_SRS,,
97 
NF_COND_STATUS_CD,*COND.NF_COND_STATUS_CD,,
98 
NF_COND_NONSAMPLE_REASN_CD,*COND.NF_COND_NONSAMPLE_REASN_CD,,
99 
CANOPY_CVR_SAMPLE_METHOD_CD,*COND.CANOPY_CVR_SAMPLE_METHOD_CD,,
100 
LIVE_CANOPY_CVR_PCT,*COND.LIVE_CANOPY_CVR_PCT,,
101 
LIVE_MISSING_CANOPY_CVR_PCT,*COND.LIVE_MISSING_CANOPY_CVR_PCT,,
102 
NBR_LIVE_STEMS,*COND.NBR_LIVE_STEMS,,
103 
OWNSUBCD,*COND.OWNSUBCD,,
104 
INDUSTRIALCD_FIADB,*COND.INDUSTRIALCD_FIADB,,
105 
RESERVCD_FLD,*COND.RESERVCD_FLD,,
106 
ADMIN_WITHDRAWN_CD,*COND.ADMIN_WITHDRAWN_CD,,
inputs/FIA/COND/new_terms.csv
1 
row_num,*COND.row_num,,
2 
CN,*COND.CN,,
3 
PLT_CN,*COND.PLT_CN,,
4 
COND_STATUS_CD,*COND.COND_STATUS_CD,,
5 
COND_NONSAMPLE_REASN_CD,*COND.COND_NONSAMPLE_REASN_CD,,
6 
RESERVCD,*COND.RESERVCD,,
7 
OWNCD,*COND.OWNCD,,
8 
OWNGRPCD,*COND.OWNGRPCD,,
9 
FORINDCD,*COND.FORINDCD,,
10 
ADFORCD,*COND.ADFORCD,,
11 
FORTYPCD,*COND.FORTYPCD,,
12 
FLDTYPCD,*COND.FLDTYPCD,,
13 
MAPDEN,*COND.MAPDEN,,
14 
STDAGE,*COND.STDAGE,,
15 
STDSZCD,*COND.STDSZCD,,
16 
FLDSZCD,*COND.FLDSZCD,,
17 
SITECLCD,*COND.SITECLCD,,
18 
SICOND,*COND.SICOND,,
19 
SIBASE,*COND.SIBASE,,
20 
SISP,*COND.SISP,,
21 
STDORGCD,*COND.STDORGCD,,
22 
STDORGSP,*COND.STDORGSP,,
23 
PROP_BASIS,*COND.PROP_BASIS,,
24 
CONDPROP_UNADJ,*COND.CONDPROP_UNADJ,,
25 
MICRPROP_UNADJ,*COND.MICRPROP_UNADJ,,
26 
SUBPPROP_UNADJ,*COND.SUBPPROP_UNADJ,,
27 
MACRPROP_UNADJ,*COND.MACRPROP_UNADJ,,
28 
SLOPE,*COND.SLOPE,,
29 
ASPECT,*COND.ASPECT,,
30 
PHYSCLCD,*COND.PHYSCLCD,,
31 
GSSTKCD,*COND.GSSTKCD,,
32 
ALSTKCD,*COND.ALSTKCD,,
33 
DSTRBCD1,*COND.DSTRBCD1,,
34 
DSTRBYR1,*COND.DSTRBYR1,,
35 
DSTRBCD2,*COND.DSTRBCD2,,
36 
DSTRBYR2,*COND.DSTRBYR2,,
37 
DSTRBCD3,*COND.DSTRBCD3,,
38 
DSTRBYR3,*COND.DSTRBYR3,,
39 
TRTCD1,*COND.TRTCD1,,
40 
TRTYR1,*COND.TRTYR1,,
41 
TRTCD2,*COND.TRTCD2,,
42 
TRTYR2,*COND.TRTYR2,,
43 
TRTCD3,*COND.TRTCD3,,
44 
TRTYR3,*COND.TRTYR3,,
45 
PRESNFCD,*COND.PRESNFCD,,
46 
BALIVE,*COND.BALIVE,,
47 
FLDAGE,*COND.FLDAGE,,
48 
ALSTK,*COND.ALSTK,,
49 
GSSTK,*COND.GSSTK,,
50 
FORTYPCDCALC,*COND.FORTYPCDCALC,,
51 
HABTYPCD1,.HABTYPCD,,
52 
HABTYPCD1_PUB_CD,.HABTYP_PUB_CD,,
53 
HABTYPCD1_DESCR_PUB_CD,*COND.HABTYPCD1_DESCR_PUB_CD,,
54 
HABTYPCD2,*COND.HABTYPCD2,,
55 
HABTYPCD2_PUB_CD,*COND.HABTYPCD2_PUB_CD,,
56 
HABTYPCD2_DESCR_PUB_CD,*COND.HABTYPCD2_DESCR_PUB_CD,,
57 
MIXEDCONFCD,*COND.MIXEDCONFCD,,
58 
VOL_LOC_GRP,*COND.VOL_LOC_GRP,,
59 
SITECLCDEST,*COND.SITECLCDEST,,
60 
SITETREE_TREE,*COND.SITETREE_TREE,,
61 
SITECL_METHOD,*COND.SITECL_METHOD,,
62 
CARBON_DOWN_DEAD,*COND.CARBON_DOWN_DEAD,,
63 
CARBON_LITTER,*COND.CARBON_LITTER,,
64 
CARBON_SOIL_ORG,*COND.CARBON_SOIL_ORG,,
65 
CARBON_STANDING_DEAD,*COND.CARBON_STANDING_DEAD,,
66 
CARBON_UNDERSTORY_AG,*COND.CARBON_UNDERSTORY_AG,,
67 
CARBON_UNDERSTORY_BG,*COND.CARBON_UNDERSTORY_BG,,
68 
CREATED_BY,*COND.CREATED_BY,,
69 
CREATED_DATE,*COND.CREATED_DATE,,
70 
CREATED_IN_INSTANCE,*COND.CREATED_IN_INSTANCE,,
71 
MODIFIED_BY,*COND.MODIFIED_BY,,
72 
MODIFIED_DATE,*COND.MODIFIED_DATE,,
73 
MODIFIED_IN_INSTANCE,*COND.MODIFIED_IN_INSTANCE,,
74 
CYCLE,*COND.CYCLE,,
75 
SUBCYCLE,*COND.SUBCYCLE,,
76 
SOIL_ROOTING_DEPTH_PNW,*COND.SOIL_ROOTING_DEPTH_PNW,,
77 
GROUND_LAND_CLASS_PNW,*COND.GROUND_LAND_CLASS_PNW,,
78 
PLANT_STOCKABILITY_FACTOR_PNW,*COND.PLANT_STOCKABILITY_FACTOR_PNW,,
79 
STND_COND_CD_PNWRS,*COND.STND_COND_CD_PNWRS,,
80 
STND_STRUC_CD_PNWRS,*COND.STND_STRUC_CD_PNWRS,,
81 
STUMP_CD_PNWRS,*COND.STUMP_CD_PNWRS,,
82 
FIRE_SRS,*COND.FIRE_SRS,,
83 
GRAZING_SRS,*COND.GRAZING_SRS,,
84 
HARVEST_TYPE1_SRS,*COND.HARVEST_TYPE1_SRS,,
85 
HARVEST_TYPE2_SRS,*COND.HARVEST_TYPE2_SRS,,
86 
HARVEST_TYPE3_SRS,*COND.HARVEST_TYPE3_SRS,,
87 
LAND_USE_SRS,*COND.LAND_USE_SRS,,
88 
OPERABILITY_SRS,*COND.OPERABILITY_SRS,,
89 
STAND_STRUCTURE_SRS,*COND.STAND_STRUCTURE_SRS,,
90 
NF_COND_STATUS_CD,*COND.NF_COND_STATUS_CD,,
91 
NF_COND_NONSAMPLE_REASN_CD,*COND.NF_COND_NONSAMPLE_REASN_CD,,
92 
CANOPY_CVR_SAMPLE_METHOD_CD,*COND.CANOPY_CVR_SAMPLE_METHOD_CD,,
93 
LIVE_CANOPY_CVR_PCT,*COND.LIVE_CANOPY_CVR_PCT,,
94 
LIVE_MISSING_CANOPY_CVR_PCT,*COND.LIVE_MISSING_CANOPY_CVR_PCT,,
95 
NBR_LIVE_STEMS,*COND.NBR_LIVE_STEMS,,
96 
OWNSUBCD,*COND.OWNSUBCD,,
97 
INDUSTRIALCD_FIADB,*COND.INDUSTRIALCD_FIADB,,
98 
RESERVCD_FLD,*COND.RESERVCD_FLD,,
99 
ADMIN_WITHDRAWN_CD,*COND.ADMIN_WITHDRAWN_CD,,
inputs/FIA/REF_SPECIES/map.csv
1 
FIA,VegCore,Filter,Comments
2 
row_num,*REF_SPECIES.row_num,,
3 
SPCD,.SPCD,,
4 
COMMON_NAME,*REF_SPECIES.COMMON_NAME,,
5 
GENUS,*REF_SPECIES.GENUS,,
6 
SPECIES,*REF_SPECIES.SPECIES,,
7 
VARIETY,*REF_SPECIES.VARIETY,,
8 
SUBSPECIES,*REF_SPECIES.SUBSPECIES,,
9 
SPECIES_SYMBOL,.SYMBOL,,
10 
E_SPGRPCD,*REF_SPECIES.E_SPGRPCD,,
11 
W_SPGRPCD,*REF_SPECIES.W_SPGRPCD,,
12 
C_SPGRPCD,*REF_SPECIES.C_SPGRPCD,,
13 
P_SPGRPCD,*REF_SPECIES.P_SPGRPCD,,
14 
MAJOR_SPGRPCD,*REF_SPECIES.MAJOR_SPGRPCD,,
15 
STOCKING_SPGRPCD,*REF_SPECIES.STOCKING_SPGRPCD,,
16 
FOREST_TYPE_SPGRPCD,*REF_SPECIES.FOREST_TYPE_SPGRPCD,,
17 
EXISTS_IN_NCRS,*REF_SPECIES.EXISTS_IN_NCRS,,
18 
EXISTS_IN_NERS,*REF_SPECIES.EXISTS_IN_NERS,,
19 
EXISTS_IN_PNWRS,*REF_SPECIES.EXISTS_IN_PNWRS,,
20 
EXISTS_IN_RMRS,*REF_SPECIES.EXISTS_IN_RMRS,,
21 
EXISTS_IN_SRS,*REF_SPECIES.EXISTS_IN_SRS,,
22 
SITETREE,*REF_SPECIES.SITETREE,,
23 
SFTWD_HRDWD,*REF_SPECIES.SFTWD_HRDWD,,
24 
ST_EXISTS_IN_NCRS,*REF_SPECIES.ST_EXISTS_IN_NCRS,,
25 
ST_EXISTS_IN_NERS,*REF_SPECIES.ST_EXISTS_IN_NERS,,
26 
ST_EXISTS_IN_PNWRS,*REF_SPECIES.ST_EXISTS_IN_PNWRS,,
27 
ST_EXISTS_IN_RMRS,*REF_SPECIES.ST_EXISTS_IN_RMRS,,
28 
ST_EXISTS_IN_SRS,*REF_SPECIES.ST_EXISTS_IN_SRS,,
29 
CORE,*REF_SPECIES.CORE,,
30 
EAST,*REF_SPECIES.EAST,,
31 
WEST,*REF_SPECIES.WEST,,
32 
CARIBBEAN,*REF_SPECIES.CARIBBEAN,,
33 
PACIFIC,*REF_SPECIES.PACIFIC,,
34 
WOODLAND,*REF_SPECIES.WOODLAND,,
35 
MANUAL_START,*REF_SPECIES.MANUAL_START,,
36 
MANUAL_END,*REF_SPECIES.MANUAL_END,,
37 
JENKINS_SPGRPCD,*REF_SPECIES.JENKINS_SPGRPCD,,
38 
JENKINS_TOTAL_B1,*REF_SPECIES.JENKINS_TOTAL_B1,,
39 
JENKINS_TOTAL_B2,*REF_SPECIES.JENKINS_TOTAL_B2,,
40 
JENKINS_STEM_WOOD_RATIO_B1,*REF_SPECIES.JENKINS_STEM_WOOD_RATIO_B1,,
41 
JENKINS_STEM_WOOD_RATIO_B2,*REF_SPECIES.JENKINS_STEM_WOOD_RATIO_B2,,
42 
JENKINS_STEM_BARK_RATIO_B1,*REF_SPECIES.JENKINS_STEM_BARK_RATIO_B1,,
43 
JENKINS_STEM_BARK_RATIO_B2,*REF_SPECIES.JENKINS_STEM_BARK_RATIO_B2,,
44 
JENKINS_FOLIAGE_RATIO_B1,*REF_SPECIES.JENKINS_FOLIAGE_RATIO_B1,,
45 
JENKINS_FOLIAGE_RATIO_B2,*REF_SPECIES.JENKINS_FOLIAGE_RATIO_B2,,
46 
JENKINS_ROOT_RATIO_B1,*REF_SPECIES.JENKINS_ROOT_RATIO_B1,,
47 
JENKINS_ROOT_RATIO_B2,*REF_SPECIES.JENKINS_ROOT_RATIO_B2,,
48 
JENKINS_SAPLING_ADJUSTMENT,*REF_SPECIES.JENKINS_SAPLING_ADJUSTMENT,,
49 
WOOD_SPGR_GREENVOL_DRYWT,*REF_SPECIES.WOOD_SPGR_GREENVOL_DRYWT,,
50 
WOOD_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES.WOOD_SPGR_GREENVOL_DRYWT_CIT,,
51 
BARK_SPGR_GREENVOL_DRYWT,*REF_SPECIES.BARK_SPGR_GREENVOL_DRYWT,,
52 
BARK_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES.BARK_SPGR_GREENVOL_DRYWT_CIT,,
53 
MC_PCT_GREEN_BARK,*REF_SPECIES.MC_PCT_GREEN_BARK,,
54 
MC_PCT_GREEN_BARK_CIT,*REF_SPECIES.MC_PCT_GREEN_BARK_CIT,,
55 
MC_PCT_GREEN_WOOD,*REF_SPECIES.MC_PCT_GREEN_WOOD,,
56 
MC_PCT_GREEN_WOOD_CIT,*REF_SPECIES.MC_PCT_GREEN_WOOD_CIT,,
57 
WOOD_SPGR_MC12VOL_DRYWT,*REF_SPECIES.WOOD_SPGR_MC12VOL_DRYWT,,
58 
WOOD_SPGR_MC12VOL_DRYWT_CIT,*REF_SPECIES.WOOD_SPGR_MC12VOL_DRYWT_CIT,,
59 
BARK_VOL_PCT,*REF_SPECIES.BARK_VOL_PCT,,
60 
BARK_VOL_PCT_CIT,*REF_SPECIES.BARK_VOL_PCT_CIT,,
61 
RAILE_STUMP_DOB_B1,*REF_SPECIES.RAILE_STUMP_DOB_B1,,
62 
RAILE_STUMP_DIB_B1,*REF_SPECIES.RAILE_STUMP_DIB_B1,,
63 
RAILE_STUMP_DIB_B2,*REF_SPECIES.RAILE_STUMP_DIB_B2,,
64 
CWD_DECAY_RATIO1,*REF_SPECIES.CWD_DECAY_RATIO1,,
65 
CWD_DECAY_RATIO2,*REF_SPECIES.CWD_DECAY_RATIO2,,
66 
CWD_DECAY_RATIO3,*REF_SPECIES.CWD_DECAY_RATIO3,,
67 
CWD_DECAY_RATIO4,*REF_SPECIES.CWD_DECAY_RATIO4,,
68 
CWD_DECAY_RATIO5,*REF_SPECIES.CWD_DECAY_RATIO5,,
69 
DWM_CARBON_RATIO,*REF_SPECIES.DWM_CARBON_RATIO,,
70 
STANDING_DEAD_DECAY_RATIO1,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO1,,
71 
STANDING_DEAD_DECAY_RATIO2,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO2,,
72 
STANDING_DEAD_DECAY_RATIO3,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO3,,
73 
STANDING_DEAD_DECAY_RATIO4,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO4,,
74 
STANDING_DEAD_DECAY_RATIO5,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO5,,
75 
CREATED_BY,*REF_SPECIES.CREATED_BY,,
76 
CREATED_DATE,*REF_SPECIES.CREATED_DATE,,
77 
CREATED_IN_INSTANCE,*REF_SPECIES.CREATED_IN_INSTANCE,,
78 
MODIFIED_BY,*REF_SPECIES.MODIFIED_BY,,
79 
MODIFIED_DATE,*REF_SPECIES.MODIFIED_DATE,,
80 
MODIFIED_IN_INSTANCE,*REF_SPECIES.MODIFIED_IN_INSTANCE,,
inputs/FIA/REF_SPECIES/new_terms.csv
1 
row_num,*REF_SPECIES.row_num,,
2 
COMMON_NAME,*REF_SPECIES.COMMON_NAME,,
3 
SPECIES_SYMBOL,.SYMBOL,,
4 
E_SPGRPCD,*REF_SPECIES.E_SPGRPCD,,
5 
W_SPGRPCD,*REF_SPECIES.W_SPGRPCD,,
6 
C_SPGRPCD,*REF_SPECIES.C_SPGRPCD,,
7 
P_SPGRPCD,*REF_SPECIES.P_SPGRPCD,,
8 
MAJOR_SPGRPCD,*REF_SPECIES.MAJOR_SPGRPCD,,
9 
STOCKING_SPGRPCD,*REF_SPECIES.STOCKING_SPGRPCD,,
10 
FOREST_TYPE_SPGRPCD,*REF_SPECIES.FOREST_TYPE_SPGRPCD,,
11 
EXISTS_IN_NCRS,*REF_SPECIES.EXISTS_IN_NCRS,,
12 
EXISTS_IN_NERS,*REF_SPECIES.EXISTS_IN_NERS,,
13 
EXISTS_IN_PNWRS,*REF_SPECIES.EXISTS_IN_PNWRS,,
14 
EXISTS_IN_RMRS,*REF_SPECIES.EXISTS_IN_RMRS,,
15 
EXISTS_IN_SRS,*REF_SPECIES.EXISTS_IN_SRS,,
16 
SITETREE,*REF_SPECIES.SITETREE,,
17 
SFTWD_HRDWD,*REF_SPECIES.SFTWD_HRDWD,,
18 
ST_EXISTS_IN_NCRS,*REF_SPECIES.ST_EXISTS_IN_NCRS,,
19 
ST_EXISTS_IN_NERS,*REF_SPECIES.ST_EXISTS_IN_NERS,,
20 
ST_EXISTS_IN_PNWRS,*REF_SPECIES.ST_EXISTS_IN_PNWRS,,
21 
ST_EXISTS_IN_RMRS,*REF_SPECIES.ST_EXISTS_IN_RMRS,,
22 
ST_EXISTS_IN_SRS,*REF_SPECIES.ST_EXISTS_IN_SRS,,
23 
CORE,*REF_SPECIES.CORE,,
24 
EAST,*REF_SPECIES.EAST,,
25 
WEST,*REF_SPECIES.WEST,,
26 
CARIBBEAN,*REF_SPECIES.CARIBBEAN,,
27 
PACIFIC,*REF_SPECIES.PACIFIC,,
28 
WOODLAND,*REF_SPECIES.WOODLAND,,
29 
MANUAL_START,*REF_SPECIES.MANUAL_START,,
30 
MANUAL_END,*REF_SPECIES.MANUAL_END,,
31 
JENKINS_SPGRPCD,*REF_SPECIES.JENKINS_SPGRPCD,,
32 
JENKINS_TOTAL_B1,*REF_SPECIES.JENKINS_TOTAL_B1,,
33 
JENKINS_TOTAL_B2,*REF_SPECIES.JENKINS_TOTAL_B2,,
34 
JENKINS_STEM_WOOD_RATIO_B1,*REF_SPECIES.JENKINS_STEM_WOOD_RATIO_B1,,
35 
JENKINS_STEM_WOOD_RATIO_B2,*REF_SPECIES.JENKINS_STEM_WOOD_RATIO_B2,,
36 
JENKINS_STEM_BARK_RATIO_B1,*REF_SPECIES.JENKINS_STEM_BARK_RATIO_B1,,
37 
JENKINS_STEM_BARK_RATIO_B2,*REF_SPECIES.JENKINS_STEM_BARK_RATIO_B2,,
38 
JENKINS_FOLIAGE_RATIO_B1,*REF_SPECIES.JENKINS_FOLIAGE_RATIO_B1,,
39 
JENKINS_FOLIAGE_RATIO_B2,*REF_SPECIES.JENKINS_FOLIAGE_RATIO_B2,,
40 
JENKINS_ROOT_RATIO_B1,*REF_SPECIES.JENKINS_ROOT_RATIO_B1,,
41 
JENKINS_ROOT_RATIO_B2,*REF_SPECIES.JENKINS_ROOT_RATIO_B2,,
42 
JENKINS_SAPLING_ADJUSTMENT,*REF_SPECIES.JENKINS_SAPLING_ADJUSTMENT,,
43 
WOOD_SPGR_GREENVOL_DRYWT,*REF_SPECIES.WOOD_SPGR_GREENVOL_DRYWT,,
44 
WOOD_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES.WOOD_SPGR_GREENVOL_DRYWT_CIT,,
45 
BARK_SPGR_GREENVOL_DRYWT,*REF_SPECIES.BARK_SPGR_GREENVOL_DRYWT,,
46 
BARK_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES.BARK_SPGR_GREENVOL_DRYWT_CIT,,
47 
MC_PCT_GREEN_BARK,*REF_SPECIES.MC_PCT_GREEN_BARK,,
48 
MC_PCT_GREEN_BARK_CIT,*REF_SPECIES.MC_PCT_GREEN_BARK_CIT,,
49 
MC_PCT_GREEN_WOOD,*REF_SPECIES.MC_PCT_GREEN_WOOD,,
50 
MC_PCT_GREEN_WOOD_CIT,*REF_SPECIES.MC_PCT_GREEN_WOOD_CIT,,
51 
WOOD_SPGR_MC12VOL_DRYWT,*REF_SPECIES.WOOD_SPGR_MC12VOL_DRYWT,,
52 
WOOD_SPGR_MC12VOL_DRYWT_CIT,*REF_SPECIES.WOOD_SPGR_MC12VOL_DRYWT_CIT,,
53 
BARK_VOL_PCT,*REF_SPECIES.BARK_VOL_PCT,,
54 
BARK_VOL_PCT_CIT,*REF_SPECIES.BARK_VOL_PCT_CIT,,
55 
RAILE_STUMP_DOB_B1,*REF_SPECIES.RAILE_STUMP_DOB_B1,,
56 
RAILE_STUMP_DIB_B1,*REF_SPECIES.RAILE_STUMP_DIB_B1,,
57 
RAILE_STUMP_DIB_B2,*REF_SPECIES.RAILE_STUMP_DIB_B2,,
58 
CWD_DECAY_RATIO1,*REF_SPECIES.CWD_DECAY_RATIO1,,
59 
CWD_DECAY_RATIO2,*REF_SPECIES.CWD_DECAY_RATIO2,,
60 
CWD_DECAY_RATIO3,*REF_SPECIES.CWD_DECAY_RATIO3,,
61 
CWD_DECAY_RATIO4,*REF_SPECIES.CWD_DECAY_RATIO4,,
62 
CWD_DECAY_RATIO5,*REF_SPECIES.CWD_DECAY_RATIO5,,
63 
DWM_CARBON_RATIO,*REF_SPECIES.DWM_CARBON_RATIO,,
64 
STANDING_DEAD_DECAY_RATIO1,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO1,,
65 
STANDING_DEAD_DECAY_RATIO2,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO2,,
66 
STANDING_DEAD_DECAY_RATIO3,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO3,,
67 
STANDING_DEAD_DECAY_RATIO4,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO4,,
68 
STANDING_DEAD_DECAY_RATIO5,*REF_SPECIES.STANDING_DEAD_DECAY_RATIO5,,
69 
CREATED_BY,*REF_SPECIES.CREATED_BY,,
70 
CREATED_DATE,*REF_SPECIES.CREATED_DATE,,
71 
CREATED_IN_INSTANCE,*REF_SPECIES.CREATED_IN_INSTANCE,,
72 
MODIFIED_BY,*REF_SPECIES.MODIFIED_BY,,
73 
MODIFIED_DATE,*REF_SPECIES.MODIFIED_DATE,,
74 
MODIFIED_IN_INSTANCE,*REF_SPECIES.MODIFIED_IN_INSTANCE,,
inputs/FIA/TREE/header.csv
1 
row_num,CN,PLT_CN,PREV_TRE_CN,INVYR,STATECD,UNITCD,COUNTYCD,PLOT,SUBP,TREE,CONDID,AZIMUTH,DIST,PREVCOND,STATUSCD,SPCD,SPGRPCD,DIA,DIAHTCD,HT,HTCD,ACTUALHT,TREECLCD,CR,CCLCD,TREEGRCD,AGENTCD,CULL,DAMLOC1,DAMTYP1,DAMSEV1,DAMLOC2,DAMTYP2,DAMSEV2,DECAYCD,STOCKING,WDLDSTEM,VOLCFNET,VOLCFGRS,VOLCSNET,VOLCSGRS,VOLBFNET,VOLBFGRS,VOLCFSND,GROWCFGS,GROWBFSL,GROWCFAL,MORTCFGS,MORTBFSL,MORTCFAL,REMVCFGS,REMVBFSL,REMVCFAL,DIACHECK,MORTYR,SALVCD,UNCRCD,CPOSCD,CLIGHTCD,CVIGORCD,CDENCD,CDIEBKCD,TRANSCD,TREEHISTCD,DIACALC,BHAGE,TOTAGE,CULLDEAD,CULLFORM,CULLMSTOP,CULLBF,CULLCF,BFSND,CFSND,SAWHT,BOLEHT,FORMCL,HTCALC,HRDWD_CLUMP_CD,SITREE,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE,MORTCD,HTDMP,ROUGHCULL,MIST_CL_CD,CULL_FLD,RECONCILECD,PREVDIA,FGROWCFGS,FGROWBFSL,FGROWCFAL,FMORTCFGS,FMORTBFSL,FMORTCFAL,FREMVCFGS,FREMVBFSL,FREMVCFAL,P2A_GRM_FLG,TREECLCD_NERS,TREECLCD_SRS,TREECLCD_NCRS,TREECLCD_RMRS,STANDING_DEAD_CD,PREV_STATUS_CD,PREV_WDLDSTEM,TPA_UNADJ,TPAMORT_UNADJ,TPAREMV_UNADJ,TPAGROW_UNADJ,DRYBIO_BOLE,DRYBIO_TOP,DRYBIO_STUMP,DRYBIO_SAPLING,DRYBIO_WDLD_SPP,DRYBIO_BG,CARBON_AG,CARBON_BG,CYCLE,SUBCYCLE,BORED_CD_PNWRS,DAMLOC1_PNWRS,DAMLOC2_PNWRS,DIACHECK_PNWRS,DMG_AGENT1_CD_PNWRS,DMG_AGENT2_CD_PNWRS,DMG_AGENT3_CD_PNWRS,MIST_CL_CD_PNWRS,SEVERITY1_CD_PNWRS,SEVERITY1A_CD_PNWRS,SEVERITY1B_CD_PNWRS,SEVERITY2_CD_PNWRS,SEVERITY2A_CD_PNWRS,SEVERITY2B_CD_PNWRS,SEVERITY3_CD_PNWRS,UNKNOWN_DAMTYP1_PNWRS,UNKNOWN_DAMTYP2_PNWRS,PREV_PNTN_SRS,DISEASE_SRS,DIEBACK_SEVERITY_SRS
inputs/FIA/TREE/new_terms.csv
1 
row_num,*TREE.row_num,,
2 
CN,*TREE.CN,,
3 
PLT_CN,*TREE.PLT_CN,,
4 
PREV_TRE_CN,*TREE.PREV_TRE_CN,,
5 
TREE,*TREE.TREE,,
6 
AZIMUTH,*TREE.AZIMUTH,,
7 
DIST,*TREE.DIST,,
8 
PREVCOND,*TREE.PREVCOND,,
9 
STATUSCD,*TREE.STATUSCD,,
10 
SPGRPCD,*TREE.SPGRPCD,,
11 
DIA,*TREE.DIA,,
12 
DIAHTCD,*TREE.DIAHTCD,,
13 
HT,*TREE.HT,,
14 
HTCD,*TREE.HTCD,,
15 
ACTUALHT,*TREE.ACTUALHT,,
16 
TREECLCD,*TREE.TREECLCD,,
17 
CR,*TREE.CR,,
18 
CCLCD,*TREE.CCLCD,,
19 
TREEGRCD,*TREE.TREEGRCD,,
20 
AGENTCD,*TREE.AGENTCD,,
21 
CULL,*TREE.CULL,,
22 
DAMLOC1,*TREE.DAMLOC1,,
23 
DAMTYP1,*TREE.DAMTYP1,,
24 
DAMSEV1,*TREE.DAMSEV1,,
25 
DAMLOC2,*TREE.DAMLOC2,,
26 
DAMTYP2,*TREE.DAMTYP2,,
27 
DAMSEV2,*TREE.DAMSEV2,,
28 
DECAYCD,*TREE.DECAYCD,,
29 
STOCKING,*TREE.STOCKING,,
30 
WDLDSTEM,*TREE.WDLDSTEM,,
31 
VOLCFNET,*TREE.VOLCFNET,,
32 
VOLCFGRS,*TREE.VOLCFGRS,,
33 
VOLCSNET,*TREE.VOLCSNET,,
34 
VOLCSGRS,*TREE.VOLCSGRS,,
35 
VOLBFNET,*TREE.VOLBFNET,,
36 
VOLBFGRS,*TREE.VOLBFGRS,,
37 
VOLCFSND,*TREE.VOLCFSND,,
38 
GROWCFGS,*TREE.GROWCFGS,,
39 
GROWBFSL,*TREE.GROWBFSL,,
40 
GROWCFAL,*TREE.GROWCFAL,,
41 
MORTCFGS,*TREE.MORTCFGS,,
42 
MORTBFSL,*TREE.MORTBFSL,,
43 
MORTCFAL,*TREE.MORTCFAL,,
44 
REMVCFGS,*TREE.REMVCFGS,,
45 
REMVBFSL,*TREE.REMVBFSL,,
46 
REMVCFAL,*TREE.REMVCFAL,,
47 
DIACHECK,*TREE.DIACHECK,,
48 
MORTYR,*TREE.MORTYR,,
49 
SALVCD,*TREE.SALVCD,,
50 
UNCRCD,*TREE.UNCRCD,,
51 
CPOSCD,*TREE.CPOSCD,,
52 
CLIGHTCD,*TREE.CLIGHTCD,,
53 
CVIGORCD,*TREE.CVIGORCD,,
54 
CDENCD,*TREE.CDENCD,,
55 
CDIEBKCD,*TREE.CDIEBKCD,,
56 
TRANSCD,*TREE.TRANSCD,,
57 
TREEHISTCD,*TREE.TREEHISTCD,,
58 
DIACALC,*TREE.DIACALC,,
59 
BHAGE,*TREE.BHAGE,,
60 
TOTAGE,*TREE.TOTAGE,,
61 
CULLDEAD,*TREE.CULLDEAD,,
62 
CULLFORM,*TREE.CULLFORM,,
63 
CULLMSTOP,*TREE.CULLMSTOP,,
64 
CULLBF,*TREE.CULLBF,,
65 
CULLCF,*TREE.CULLCF,,
66 
BFSND,*TREE.BFSND,,
67 
CFSND,*TREE.CFSND,,
68 
SAWHT,*TREE.SAWHT,,
69 
BOLEHT,*TREE.BOLEHT,,
70 
FORMCL,*TREE.FORMCL,,
71 
HTCALC,*TREE.HTCALC,,
72 
HRDWD_CLUMP_CD,*TREE.HRDWD_CLUMP_CD,,
73 
SITREE,*TREE.SITREE,,
74 
CREATED_BY,*TREE.CREATED_BY,,
75 
CREATED_DATE,*TREE.CREATED_DATE,,
76 
CREATED_IN_INSTANCE,*TREE.CREATED_IN_INSTANCE,,
77 
MODIFIED_BY,*TREE.MODIFIED_BY,,
78 
MODIFIED_DATE,*TREE.MODIFIED_DATE,,
79 
MODIFIED_IN_INSTANCE,*TREE.MODIFIED_IN_INSTANCE,,
80 
MORTCD,*TREE.MORTCD,,
81 
HTDMP,*TREE.HTDMP,,
82 
ROUGHCULL,*TREE.ROUGHCULL,,
83 
MIST_CL_CD,*TREE.MIST_CL_CD,,
84 
CULL_FLD,*TREE.CULL_FLD,,
85 
RECONCILECD,*TREE.RECONCILECD,,
86 
PREVDIA,*TREE.PREVDIA,,
87 
FGROWCFGS,*TREE.FGROWCFGS,,
88 
FGROWBFSL,*TREE.FGROWBFSL,,
89 
FGROWCFAL,*TREE.FGROWCFAL,,
90 
FMORTCFGS,*TREE.FMORTCFGS,,
91 
FMORTBFSL,*TREE.FMORTBFSL,,
92 
FMORTCFAL,*TREE.FMORTCFAL,,
93 
FREMVCFGS,*TREE.FREMVCFGS,,
94 
FREMVBFSL,*TREE.FREMVBFSL,,
95 
FREMVCFAL,*TREE.FREMVCFAL,,
96 
P2A_GRM_FLG,*TREE.P2A_GRM_FLG,,
97 
TREECLCD_NERS,*TREE.TREECLCD_NERS,,
98 
TREECLCD_SRS,*TREE.TREECLCD_SRS,,
99 
TREECLCD_NCRS,*TREE.TREECLCD_NCRS,,
100 
TREECLCD_RMRS,*TREE.TREECLCD_RMRS,,
101 
STANDING_DEAD_CD,*TREE.STANDING_DEAD_CD,,
102 
PREV_STATUS_CD,*TREE.PREV_STATUS_CD,,
103 
PREV_WDLDSTEM,*TREE.PREV_WDLDSTEM,,
104 
TPA_UNADJ,*TREE.TPA_UNADJ,,
105 
TPAMORT_UNADJ,*TREE.TPAMORT_UNADJ,,
106 
TPAREMV_UNADJ,*TREE.TPAREMV_UNADJ,,
107 
TPAGROW_UNADJ,*TREE.TPAGROW_UNADJ,,
108 
DRYBIO_BOLE,*TREE.DRYBIO_BOLE,,
109 
DRYBIO_TOP,*TREE.DRYBIO_TOP,,
110 
DRYBIO_STUMP,*TREE.DRYBIO_STUMP,,
111 
DRYBIO_SAPLING,*TREE.DRYBIO_SAPLING,,
112 
DRYBIO_WDLD_SPP,*TREE.DRYBIO_WDLD_SPP,,
113 
DRYBIO_BG,*TREE.DRYBIO_BG,,
114 
CARBON_AG,*TREE.CARBON_AG,,
115 
CARBON_BG,*TREE.CARBON_BG,,
116 
CYCLE,*TREE.CYCLE,,
117 
SUBCYCLE,*TREE.SUBCYCLE,,
118 
BORED_CD_PNWRS,*TREE.BORED_CD_PNWRS,,
119 
DAMLOC1_PNWRS,*TREE.DAMLOC1_PNWRS,,
120 
DAMLOC2_PNWRS,*TREE.DAMLOC2_PNWRS,,
121 
DIACHECK_PNWRS,*TREE.DIACHECK_PNWRS,,
122 
DMG_AGENT1_CD_PNWRS,*TREE.DMG_AGENT1_CD_PNWRS,,
123 
DMG_AGENT2_CD_PNWRS,*TREE.DMG_AGENT2_CD_PNWRS,,
124 
DMG_AGENT3_CD_PNWRS,*TREE.DMG_AGENT3_CD_PNWRS,,
125 
MIST_CL_CD_PNWRS,*TREE.MIST_CL_CD_PNWRS,,
126 
SEVERITY1_CD_PNWRS,*TREE.SEVERITY1_CD_PNWRS,,
127 
SEVERITY1A_CD_PNWRS,*TREE.SEVERITY1A_CD_PNWRS,,
128 
SEVERITY1B_CD_PNWRS,*TREE.SEVERITY1B_CD_PNWRS,,
129 
SEVERITY2_CD_PNWRS,*TREE.SEVERITY2_CD_PNWRS,,
130 
SEVERITY2A_CD_PNWRS,*TREE.SEVERITY2A_CD_PNWRS,,
131 
SEVERITY2B_CD_PNWRS,*TREE.SEVERITY2B_CD_PNWRS,,
132 
SEVERITY3_CD_PNWRS,*TREE.SEVERITY3_CD_PNWRS,,
133 
UNKNOWN_DAMTYP1_PNWRS,*TREE.UNKNOWN_DAMTYP1_PNWRS,,
134 
UNKNOWN_DAMTYP2_PNWRS,*TREE.UNKNOWN_DAMTYP2_PNWRS,,
135 
PREV_PNTN_SRS,*TREE.PREV_PNTN_SRS,,
136 
DISEASE_SRS,*TREE.DISEASE_SRS,,
137 
DIEBACK_SEVERITY_SRS,*TREE.DIEBACK_SEVERITY_SRS,,
inputs/FIA/REF_HABTYP_DESCRIPTION/header.csv
1 
row_num,CN,HABTYPCD,PUB_CD,SCIENTIFIC_NAME,COMMON_NAME,VALID,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE
inputs/FIA/PLOT/header.csv
1 
row_num,CN,SRV_CN,CTY_CN,PREV_PLT_CN,INVYR,STATECD,UNITCD,COUNTYCD,PLOT,PLOT_STATUS_CD,PLOT_NONSAMPLE_REASN_CD,MEASYEAR,MEASMON,MEASDAY,REMPER,KINDCD,DESIGNCD,RDDISTCD,WATERCD,LAT,LON,ELEV,GROW_TYP_CD,MORT_TYP_CD,P2PANEL,P3PANEL,ECOSUBCD,CONGCD,MANUAL,SUBPANEL,KINDCD_NC,QA_STATUS,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE,MICROPLOT_LOC,DECLINATION,EMAP_HEX,SAMP_METHOD_CD,SUBP_EXAMINE_CD,MACRO_BREAKPOINT_DIA,INTENSITY,CYCLE,SUBCYCLE,ECO_UNIT_PNW,TOPO_POSITION_PNW,NF_SAMPLING_STATUS_CD,NF_PLOT_STATUS_CD,NF_PLOT_NONSAMPLE_REASN_CD,P2VEG_SAMPLING_STATUS_CD,P2VEG_SAMPLING_LEVEL_DETAIL_CD,INVASIVE_SAMPLING_STATUS_CD,INVASIVE_SPECIMEN_RULE_CD,DESIGNCD_P2A
inputs/FIA/PLOT/map.csv
1 
FIA,VegCore,Filter,Comments
2 
row_num,*PLOT.row_num,,
3 
CN,*PLOT.CN,,
4 
SRV_CN,*PLOT.SRV_CN,,
5 
CTY_CN,*PLOT.CTY_CN,,
6 
PREV_PLT_CN,*PLOT.PREV_PLT_CN,,
7 
INVYR,.INVYR,,
8 
STATECD,.STATECD,,
9 
UNITCD,.UNITCD,,
10 
COUNTYCD,.COUNTYCD,,
11 
PLOT,.PLOT,,
12 
PLOT_STATUS_CD,*PLOT.PLOT_STATUS_CD,,
13 
PLOT_NONSAMPLE_REASN_CD,*PLOT.PLOT_NONSAMPLE_REASN_CD,,
14 
MEASYEAR,*PLOT.MEASYEAR,,
15 
MEASMON,*PLOT.MEASMON,,
16 
MEASDAY,*PLOT.MEASDAY,,
17 
REMPER,*PLOT.REMPER,,
18 
KINDCD,*PLOT.KINDCD,,
19 
DESIGNCD,*PLOT.DESIGNCD,,
20 
RDDISTCD,*PLOT.RDDISTCD,,
21 
WATERCD,*PLOT.WATERCD,,
22 
LAT,*PLOT.LAT,,
23 
LON,*PLOT.LON,,
24 
ELEV,*PLOT.ELEV,,
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,,
inputs/FIA/PLOT/import
3 3 
cd "$(dirname "$0")"
4 4 
. ../../../lib/import.sh
5 5 

  		




  
  6
  
    
map_table


  		




  6
  7
  
    
psql <<'EOF'


  		




  7
  
  
    
SELECT functions.to_global_col_names('"PLOT"');


  		




  8
  
  
    

  		




  9
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.STATECD"  TO ".STATECD" $$);


  		




  10
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.UNITCD"   TO ".UNITCD"  $$);


  		




  11
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.COUNTYCD" TO ".COUNTYCD"$$);


  		




  12
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.PLOT"     TO ".PLOT"    $$);


  		




  13
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.INVYR"    TO ".INVYR"   $$);


  		




  14
  
  
    

  		




  15
  8
  
    
SELECT functions.set_col_types('"PLOT"', ARRAY[


  		




  16
  9
  
    
  ('.STATECD' , 'integer')


  		




  17
  10
  
    
, ('.UNITCD'  , 'integer')


  		












  

    
      inputs/FIA/PLOT/new_terms.csv
    
  





  
  1
  
    
row_num,*PLOT.row_num,,


  		




  
  2
  
    
CN,*PLOT.CN,,


  		




  
  3
  
    
SRV_CN,*PLOT.SRV_CN,,


  		




  
  4
  
    
CTY_CN,*PLOT.CTY_CN,,


  		




  
  5
  
    
PREV_PLT_CN,*PLOT.PREV_PLT_CN,,


  		




  
  6
  
    
PLOT_STATUS_CD,*PLOT.PLOT_STATUS_CD,,


  		




  
  7
  
    
PLOT_NONSAMPLE_REASN_CD,*PLOT.PLOT_NONSAMPLE_REASN_CD,,


  		




  
  8
  
    
MEASYEAR,*PLOT.MEASYEAR,,


  		




  
  9
  
    
MEASMON,*PLOT.MEASMON,,


  		




  
  10
  
    
MEASDAY,*PLOT.MEASDAY,,


  		




  
  11
  
    
REMPER,*PLOT.REMPER,,


  		




  
  12
  
    
KINDCD,*PLOT.KINDCD,,


  		




  
  13
  
    
DESIGNCD,*PLOT.DESIGNCD,,


  		




  
  14
  
    
RDDISTCD,*PLOT.RDDISTCD,,


  		




  
  15
  
    
WATERCD,*PLOT.WATERCD,,


  		




  
  16
  
    
LAT,*PLOT.LAT,,


  		




  
  17
  
    
LON,*PLOT.LON,,


  		




  
  18
  
    
ELEV,*PLOT.ELEV,,


  		




  
  19
  
    
GROW_TYP_CD,*PLOT.GROW_TYP_CD,,


  		




  
  20
  
    
MORT_TYP_CD,*PLOT.MORT_TYP_CD,,


  		




  
  21
  
    
P2PANEL,*PLOT.P2PANEL,,


  		




  
  22
  
    
P3PANEL,*PLOT.P3PANEL,,


  		




  
  23
  
    
ECOSUBCD,*PLOT.ECOSUBCD,,


  		




  
  24
  
    
CONGCD,*PLOT.CONGCD,,


  		




  
  25
  
    
MANUAL,*PLOT.MANUAL,,


  		




  
  26
  
    
SUBPANEL,*PLOT.SUBPANEL,,


  		




  
  27
  
    
KINDCD_NC,*PLOT.KINDCD_NC,,


  		




  
  28
  
    
QA_STATUS,*PLOT.QA_STATUS,,


  		




  
  29
  
    
CREATED_BY,*PLOT.CREATED_BY,,


  		




  
  30
  
    
CREATED_DATE,*PLOT.CREATED_DATE,,


  		




  
  31
  
    
CREATED_IN_INSTANCE,*PLOT.CREATED_IN_INSTANCE,,


  		




  
  32
  
    
MODIFIED_BY,*PLOT.MODIFIED_BY,,


  		




  
  33
  
    
MODIFIED_DATE,*PLOT.MODIFIED_DATE,,


  		




  
  34
  
    
MODIFIED_IN_INSTANCE,*PLOT.MODIFIED_IN_INSTANCE,,


  		




  
  35
  
    
MICROPLOT_LOC,*PLOT.MICROPLOT_LOC,,


  		




  
  36
  
    
DECLINATION,*PLOT.DECLINATION,,


  		




  
  37
  
    
EMAP_HEX,*PLOT.EMAP_HEX,,


  		




  
  38
  
    
SAMP_METHOD_CD,*PLOT.SAMP_METHOD_CD,,


  		




  
  39
  
    
SUBP_EXAMINE_CD,*PLOT.SUBP_EXAMINE_CD,,


  		




  
  40
  
    
MACRO_BREAKPOINT_DIA,*PLOT.MACRO_BREAKPOINT_DIA,,


  		




  
  41
  
    
INTENSITY,*PLOT.INTENSITY,,


  		




  
  42
  
    
CYCLE,*PLOT.CYCLE,,


  		




  
  43
  
    
SUBCYCLE,*PLOT.SUBCYCLE,,


  		




  
  44
  
    
ECO_UNIT_PNW,*PLOT.ECO_UNIT_PNW,,


  		




  
  45
  
    
TOPO_POSITION_PNW,*PLOT.TOPO_POSITION_PNW,,


  		




  
  46
  
    
NF_SAMPLING_STATUS_CD,*PLOT.NF_SAMPLING_STATUS_CD,,


  		




  
  47
  
    
NF_PLOT_STATUS_CD,*PLOT.NF_PLOT_STATUS_CD,,


  		




  
  48
  
    
NF_PLOT_NONSAMPLE_REASN_CD,*PLOT.NF_PLOT_NONSAMPLE_REASN_CD,,


  		




  
  49
  
    
P2VEG_SAMPLING_STATUS_CD,*PLOT.P2VEG_SAMPLING_STATUS_CD,,


  		




  
  50
  
    
P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT.P2VEG_SAMPLING_LEVEL_DETAIL_CD,,


  		




  
  51
  
    
INVASIVE_SAMPLING_STATUS_CD,*PLOT.INVASIVE_SAMPLING_STATUS_CD,,


  		




  
  52
  
    
INVASIVE_SPECIMEN_RULE_CD,*PLOT.INVASIVE_SPECIMEN_RULE_CD,,


  		




  
  53
  
    
DESIGNCD_P2A,*PLOT.DESIGNCD_P2A,,


  		












  

    
      inputs/FIA/PLOT/unmapped_terms.csv
    
  





  
  1
  
    
*PLOT.row_num


  		




  
  2
  
    
*PLOT.CN


  		




  
  3
  
    
*PLOT.SRV_CN


  		




  
  4
  
    
*PLOT.CTY_CN


  		




  
  5
  
    
*PLOT.PREV_PLT_CN


  		




  
  6
  
    
.INVYR


  		




  
  7
  
    
.STATECD


  		




  
  8
  
    
.UNITCD


  		




  
  9
  
    
.COUNTYCD


  		




  
  10
  
    
.PLOT


  		




  
  11
  
    
*PLOT.PLOT_STATUS_CD


  		




  
  12
  
    
*PLOT.PLOT_NONSAMPLE_REASN_CD


  		




  
  13
  
    
*PLOT.MEASYEAR


  		




  
  14
  
    
*PLOT.MEASMON


  		




  
  15
  
    
*PLOT.MEASDAY


  		




  
  16
  
    
*PLOT.REMPER


  		




  
  17
  
    
*PLOT.KINDCD


  		




  
  18
  
    
*PLOT.DESIGNCD


  		




  
  19
  
    
*PLOT.RDDISTCD


  		




  
  20
  
    
*PLOT.WATERCD


  		




  
  21
  
    
*PLOT.LAT


  		




  
  22
  
    
*PLOT.LON


  		




  
  23
  
    
*PLOT.ELEV


  		




  
  24
  
    
*PLOT.GROW_TYP_CD


  		




  
  25
  
    
*PLOT.MORT_TYP_CD


  		




  
  26
  
    
*PLOT.P2PANEL


  		




  
  27
  
    
*PLOT.P3PANEL


  		




  
  28
  
    
*PLOT.ECOSUBCD


  		




  
  29
  
    
*PLOT.CONGCD


  		




  
  30
  
    
*PLOT.MANUAL


  		




  
  31
  
    
*PLOT.SUBPANEL


  		




  
  32
  
    
*PLOT.KINDCD_NC


  		




  
  33
  
    
*PLOT.QA_STATUS


  		




  
  34
  
    
*PLOT.CREATED_BY


  		




  
  35
  
    
*PLOT.CREATED_DATE


  		




  
  36
  
    
*PLOT.CREATED_IN_INSTANCE


  		




  
  37
  
    
*PLOT.MODIFIED_BY


  		




  
  38
  
    
*PLOT.MODIFIED_DATE


  		




  
  39
  
    
*PLOT.MODIFIED_IN_INSTANCE


  		




  
  40
  
    
*PLOT.MICROPLOT_LOC


  		




  
  41
  
    
*PLOT.DECLINATION


  		




  
  42
  
    
*PLOT.EMAP_HEX


  		




  
  43
  
    
*PLOT.SAMP_METHOD_CD


  		




  
  44
  
    
*PLOT.SUBP_EXAMINE_CD


  		




  
  45
  
    
*PLOT.MACRO_BREAKPOINT_DIA


  		




  
  46
  
    
*PLOT.INTENSITY


  		




  
  47
  
    
*PLOT.CYCLE


  		




  
  48
  
    
*PLOT.SUBCYCLE


  		




  
  49
  
    
*PLOT.ECO_UNIT_PNW


  		




  
  50
  
    
*PLOT.TOPO_POSITION_PNW


  		




  
  51
  
    
*PLOT.NF_SAMPLING_STATUS_CD


  		




  
  52
  
    
*PLOT.NF_PLOT_STATUS_CD


  		




  
  53
  
    
*PLOT.NF_PLOT_NONSAMPLE_REASN_CD


  		




  
  54
  
    
*PLOT.P2VEG_SAMPLING_STATUS_CD


  		




  
  55
  
    
*PLOT.P2VEG_SAMPLING_LEVEL_DETAIL_CD


  		




  
  56
  
    
*PLOT.INVASIVE_SAMPLING_STATUS_CD


  		




  
  57
  
    
*PLOT.INVASIVE_SPECIMEN_RULE_CD


  		




  
  58
  
    
*PLOT.DESIGNCD_P2A


  		












  

    
      inputs/FIA/COUNTY/header.csv
    
  





  
  1
  
    
row_num,STATECD,UNITCD,COUNTYCD,COUNTYNM,CN,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE


  		












  

    
      inputs/FIA/COUNTY/map.csv
    
  





  
  1
  
    
FIA,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*COUNTY.row_num,,


  		




  
  3
  
    
STATECD,.STATECD,,


  		




  
  4
  
    
UNITCD,.UNITCD,,


  		




  
  5
  
    
COUNTYCD,.COUNTYCD,,


  		




  
  6
  
    
COUNTYNM,*COUNTY.COUNTYNM,,


  		




  
  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,,


  		












  

    
      inputs/FIA/COUNTY/import
    
  





  3
  3
  
    
cd "$(dirname "$0")"


  		




  4
  4
  
    
. ../../../lib/import.sh


  		




  5
  5
  
    

  		




  
  6
  
    
map_table


  		




  6
  7
  
    
psql <<'EOF'


  		




  7
  
  
    
SELECT functions.to_global_col_names('"COUNTY"');


  		




  8
  
  
    

  		




  9
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COUNTY" RENAME "COUNTY.STATECD"  TO ".STATECD" $$);


  		




  10
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COUNTY" RENAME "COUNTY.UNITCD"   TO ".UNITCD"  $$);


  		




  11
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COUNTY" RENAME "COUNTY.COUNTYCD" TO ".COUNTYCD"$$);


  		




  12
  
  
    

  		




  13
  8
  
    
SELECT functions.set_col_types('"COUNTY"', ARRAY[


  		




  14
  9
  
    
  ('.STATECD' , 'integer')


  		




  15
  10
  
    
, ('.UNITCD'  , 'integer')


  		












  

    
      inputs/FIA/COUNTY/unmapped_terms.csv
    
  





  
  1
  
    
*COUNTY.row_num


  		




  
  2
  
    
.STATECD


  		




  
  3
  
    
.UNITCD


  		




  
  4
  
    
.COUNTYCD


  		




  
  5
  
    
*COUNTY.COUNTYNM


  		




  
  6
  
    
*COUNTY.CN


  		




  
  7
  
    
*COUNTY.CREATED_BY


  		




  
  8
  
    
*COUNTY.CREATED_DATE


  		




  
  9
  
    
*COUNTY.CREATED_IN_INSTANCE


  		




  
  10
  
    
*COUNTY.MODIFIED_BY


  		




  
  11
  
    
*COUNTY.MODIFIED_DATE


  		




  
  12
  
    
*COUNTY.MODIFIED_IN_INSTANCE


  		












  

    
      inputs/FIA/COUNTY/new_terms.csv
    
  





  
  1
  
    
row_num,*COUNTY.row_num,,


  		




  
  2
  
    
COUNTYNM,*COUNTY.COUNTYNM,,


  		




  
  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,,


  		












  

    
      inputs/FIA/REF_PLANT_DICTIONARY/header.csv
    
  





  
  1
  
    
row_num,CN,SYMBOL_TYPE,SYMBOL,SCIENTIFIC_NAME,NEW_SYMBOL,NEW_SCIENTIFIC_NAME,COMMON_NAME,CATEGORY,FAMILY,GROWTH_HABIT,DURATION,US_NATIVITY,STATE_DISTRIBUTION,STATE_AND_PROVINCE,SCIENTIFIC_NAME_W_AUTHOR,GENERA_BINOMIAL_AUTHOR,TRINOMIAL_AUTHOR,QUADRINOMIAL_AUTHOR,XGENUS,GENUS,XSPECIES,SPECIES,SSP,XSUBSPECIES,SUBSPECIES,VAR,XVARIETY,VARIETY,SUBVAR,SUBVARIETY,F,FORMA,NOTES,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE


  		












  

    
      inputs/FIA/REF_PLANT_DICTIONARY/map.csv
    
  





  
  1
  
    
FIA,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*REF_PLANT_DICTIONARY.row_num,,


  		




  
  3
  
    
CN,*REF_PLANT_DICTIONARY.CN,,


  		




  
  4
  
    
SYMBOL_TYPE,.SYMBOL_TYPE,,


  		




  
  5
  
    
SYMBOL,.SYMBOL,,


  		




  
  6
  
    
SCIENTIFIC_NAME,*REF_PLANT_DICTIONARY.SCIENTIFIC_NAME,,


  		




  
  7
  
    
NEW_SYMBOL,*REF_PLANT_DICTIONARY.NEW_SYMBOL,,


  		




  
  8
  
    
NEW_SCIENTIFIC_NAME,*REF_PLANT_DICTIONARY.NEW_SCIENTIFIC_NAME,,


  		




  
  9
  
    
COMMON_NAME,*REF_PLANT_DICTIONARY.COMMON_NAME,,


  		




  
  10
  
    
CATEGORY,*REF_PLANT_DICTIONARY.CATEGORY,,


  		




  
  11
  
    
FAMILY,*REF_PLANT_DICTIONARY.FAMILY,,


  		




  
  12
  
    
GROWTH_HABIT,*REF_PLANT_DICTIONARY.GROWTH_HABIT,,


  		




  
  13
  
    
DURATION,*REF_PLANT_DICTIONARY.DURATION,,


  		




  
  14
  
    
US_NATIVITY,*REF_PLANT_DICTIONARY.US_NATIVITY,,


  		




  
  15
  
    
STATE_DISTRIBUTION,*REF_PLANT_DICTIONARY.STATE_DISTRIBUTION,,


  		




  
  16
  
    
STATE_AND_PROVINCE,*REF_PLANT_DICTIONARY.STATE_AND_PROVINCE,,


  		




  
  17
  
    
SCIENTIFIC_NAME_W_AUTHOR,*REF_PLANT_DICTIONARY.SCIENTIFIC_NAME_W_AUTHOR,,


  		




  
  18
  
    
GENERA_BINOMIAL_AUTHOR,*REF_PLANT_DICTIONARY.GENERA_BINOMIAL_AUTHOR,,


  		




  
  19
  
    
TRINOMIAL_AUTHOR,*REF_PLANT_DICTIONARY.TRINOMIAL_AUTHOR,,


  		




  
  20
  
    
QUADRINOMIAL_AUTHOR,*REF_PLANT_DICTIONARY.QUADRINOMIAL_AUTHOR,,


  		




  
  21
  
    
XGENUS,*REF_PLANT_DICTIONARY.XGENUS,,


  		




  
  22
  
    
GENUS,*REF_PLANT_DICTIONARY.GENUS,,


  		




  
  23
  
    
XSPECIES,*REF_PLANT_DICTIONARY.XSPECIES,,


  		




  
  24
  
    
SPECIES,*REF_PLANT_DICTIONARY.SPECIES,,


  		




  
  25
  
    
SSP,*REF_PLANT_DICTIONARY.SSP,,


  		




  
  26
  
    
XSUBSPECIES,*REF_PLANT_DICTIONARY.XSUBSPECIES,,


  		




  
  27
  
    
SUBSPECIES,*REF_PLANT_DICTIONARY.SUBSPECIES,,


  		




  
  28
  
    
VAR,*REF_PLANT_DICTIONARY.VAR,,


  		




  
  29
  
    
XVARIETY,*REF_PLANT_DICTIONARY.XVARIETY,,


  		




  
  30
  
    
VARIETY,*REF_PLANT_DICTIONARY.VARIETY,,


  		




  
  31
  
    
SUBVAR,*REF_PLANT_DICTIONARY.SUBVAR,,


  		




  
  32
  
    
SUBVARIETY,*REF_PLANT_DICTIONARY.SUBVARIETY,,


  		




  
  33
  
    
F,*REF_PLANT_DICTIONARY.F,,


  		




  
  34
  
    
FORMA,*REF_PLANT_DICTIONARY.FORMA,,


  		




  
  35
  
    
NOTES,*REF_PLANT_DICTIONARY.NOTES,,


  		




  
  36
  
    
CREATED_BY,*REF_PLANT_DICTIONARY.CREATED_BY,,


  		




  
  37
  
    
CREATED_DATE,*REF_PLANT_DICTIONARY.CREATED_DATE,,


  		




  
  38
  
    
CREATED_IN_INSTANCE,*REF_PLANT_DICTIONARY.CREATED_IN_INSTANCE,,


  		




  
  39
  
    
MODIFIED_BY,*REF_PLANT_DICTIONARY.MODIFIED_BY,,


  		




  
  40
  
    
MODIFIED_DATE,*REF_PLANT_DICTIONARY.MODIFIED_DATE,,


  		




  
  41
  
    
MODIFIED_IN_INSTANCE,*REF_PLANT_DICTIONARY.MODIFIED_IN_INSTANCE,,


  		












  

    
      inputs/FIA/REF_PLANT_DICTIONARY/import
    
  





  3
  3
  
    
cd "$(dirname "$0")"


  		




  4
  4
  
    
. ../../../lib/import.sh


  		




  5
  5
  
    

  		




  
  6
  
    
map_table


  		




  6
  7
  
    
psql <<'EOF'


  		




  7
  
  
    
SELECT functions.to_global_col_names('"REF_PLANT_DICTIONARY"');


  		




  8
  
  
    

  		




  9
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "REF_PLANT_DICTIONARY" RENAME "REF_PLANT_DICTIONARY.SYMBOL_TYPE" TO ".SYMBOL_TYPE"$$);


  		




  10
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "REF_PLANT_DICTIONARY" RENAME "REF_PLANT_DICTIONARY.SYMBOL"      TO ".SYMBOL"     $$);


  		




  11
  
  
    

  		




  12
  8
  
    
-- Remove 56 duplicate symbols of type 'Old' (these are ambiguous)


  		




  13
  9
  
    
DELETE FROM "REF_PLANT_DICTIONARY"


  		




  14
  10
  
    
WHERE ".SYMBOL" IN (


  		












  

    
      inputs/FIA/REF_PLANT_DICTIONARY/unmapped_terms.csv
    
  





  
  1
  
    
*REF_PLANT_DICTIONARY.row_num


  		




  
  2
  
    
*REF_PLANT_DICTIONARY.CN


  		




  
  3
  
    
.SYMBOL_TYPE


  		




  
  4
  
    
.SYMBOL


  		




  
  5
  
    
*REF_PLANT_DICTIONARY.SCIENTIFIC_NAME


  		




  
  6
  
    
*REF_PLANT_DICTIONARY.NEW_SYMBOL


  		




  
  7
  
    
*REF_PLANT_DICTIONARY.NEW_SCIENTIFIC_NAME


  		




  
  8
  
    
*REF_PLANT_DICTIONARY.COMMON_NAME


  		




  
  9
  
    
*REF_PLANT_DICTIONARY.CATEGORY


  		




  
  10
  
    
*REF_PLANT_DICTIONARY.FAMILY


  		




  
  11
  
    
*REF_PLANT_DICTIONARY.GROWTH_HABIT


  		




  
  12
  
    
*REF_PLANT_DICTIONARY.DURATION


  		




  
  13
  
    
*REF_PLANT_DICTIONARY.US_NATIVITY


  		




  
  14
  
    
*REF_PLANT_DICTIONARY.STATE_DISTRIBUTION


  		




  
  15
  
    
*REF_PLANT_DICTIONARY.STATE_AND_PROVINCE


  		




  
  16
  
    
*REF_PLANT_DICTIONARY.SCIENTIFIC_NAME_W_AUTHOR


  		




  
  17
  
    
*REF_PLANT_DICTIONARY.GENERA_BINOMIAL_AUTHOR


  		




  
  18
  
    
*REF_PLANT_DICTIONARY.TRINOMIAL_AUTHOR


  		




  
  19
  
    
*REF_PLANT_DICTIONARY.QUADRINOMIAL_AUTHOR


  		




  
  20
  
    
*REF_PLANT_DICTIONARY.XGENUS


  		




  
  21
  
    
*REF_PLANT_DICTIONARY.GENUS


  		




  
  22
  
    
*REF_PLANT_DICTIONARY.XSPECIES


  		




  
  23
  
    
*REF_PLANT_DICTIONARY.SPECIES


  		




  
  24
  
    
*REF_PLANT_DICTIONARY.SSP


  		




  
  25
  
    
*REF_PLANT_DICTIONARY.XSUBSPECIES


  		




  
  26
  
    
*REF_PLANT_DICTIONARY.SUBSPECIES


  		




  
  27
  
    
*REF_PLANT_DICTIONARY.VAR


  		




  
  28
  
    
*REF_PLANT_DICTIONARY.XVARIETY


  		




  
  29
  
    
*REF_PLANT_DICTIONARY.VARIETY


  		




  
  30
  
    
*REF_PLANT_DICTIONARY.SUBVAR


  		




  
  31
  
    
*REF_PLANT_DICTIONARY.SUBVARIETY


  		




  
  32
  
    
*REF_PLANT_DICTIONARY.F


  		




  
  33
  
    
*REF_PLANT_DICTIONARY.FORMA


  		




  
  34
  
    
*REF_PLANT_DICTIONARY.NOTES


  		




  
  35
  
    
*REF_PLANT_DICTIONARY.CREATED_BY


  		




  
  36
  
    
*REF_PLANT_DICTIONARY.CREATED_DATE


  		




  
  37
  
    
*REF_PLANT_DICTIONARY.CREATED_IN_INSTANCE


  		




  
  38
  
    
*REF_PLANT_DICTIONARY.MODIFIED_BY


  		




  
  39
  
    
*REF_PLANT_DICTIONARY.MODIFIED_DATE


  		




  
  40
  
    
*REF_PLANT_DICTIONARY.MODIFIED_IN_INSTANCE


  		












  

    
      inputs/FIA/REF_PLANT_DICTIONARY/new_terms.csv
    
  





  
  1
  
    
row_num,*REF_PLANT_DICTIONARY.row_num,,


  		




  
  2
  
    
CN,*REF_PLANT_DICTIONARY.CN,,


  		




  
  3
  
    
NEW_SYMBOL,*REF_PLANT_DICTIONARY.NEW_SYMBOL,,


  		




  
  4
  
    
NEW_SCIENTIFIC_NAME,*REF_PLANT_DICTIONARY.NEW_SCIENTIFIC_NAME,,


  		




  
  5
  
    
COMMON_NAME,*REF_PLANT_DICTIONARY.COMMON_NAME,,


  		




  
  6
  
    
CATEGORY,*REF_PLANT_DICTIONARY.CATEGORY,,


  		




  
  7
  
    
GROWTH_HABIT,*REF_PLANT_DICTIONARY.GROWTH_HABIT,,


  		




  
  8
  
    
DURATION,*REF_PLANT_DICTIONARY.DURATION,,


  		




  
  9
  
    
US_NATIVITY,*REF_PLANT_DICTIONARY.US_NATIVITY,,


  		




  
  10
  
    
STATE_DISTRIBUTION,*REF_PLANT_DICTIONARY.STATE_DISTRIBUTION,,


  		




  
  11
  
    
STATE_AND_PROVINCE,*REF_PLANT_DICTIONARY.STATE_AND_PROVINCE,,


  		




  
  12
  
    
SCIENTIFIC_NAME_W_AUTHOR,*REF_PLANT_DICTIONARY.SCIENTIFIC_NAME_W_AUTHOR,,


  		




  
  13
  
    
GENERA_BINOMIAL_AUTHOR,*REF_PLANT_DICTIONARY.GENERA_BINOMIAL_AUTHOR,,


  		




  
  14
  
    
TRINOMIAL_AUTHOR,*REF_PLANT_DICTIONARY.TRINOMIAL_AUTHOR,,


  		




  
  15
  
    
QUADRINOMIAL_AUTHOR,*REF_PLANT_DICTIONARY.QUADRINOMIAL_AUTHOR,,


  		




  
  16
  
    
XGENUS,*REF_PLANT_DICTIONARY.XGENUS,,


  		




  
  17
  
    
XSPECIES,*REF_PLANT_DICTIONARY.XSPECIES,,


  		




  
  18
  
    
XSUBSPECIES,*REF_PLANT_DICTIONARY.XSUBSPECIES,,


  		




  
  19
  
    
XVARIETY,*REF_PLANT_DICTIONARY.XVARIETY,,


  		




  
  20
  
    
SUBVAR,*REF_PLANT_DICTIONARY.SUBVAR,,


  		




  
  21
  
    
SUBVARIETY,*REF_PLANT_DICTIONARY.SUBVARIETY,,


  		




  
  22
  
    
F,*REF_PLANT_DICTIONARY.F,,


  		




  
  23
  
    
CREATED_BY,*REF_PLANT_DICTIONARY.CREATED_BY,,


  		




  
  24
  
    
CREATED_DATE,*REF_PLANT_DICTIONARY.CREATED_DATE,,


  		




  
  25
  
    
CREATED_IN_INSTANCE,*REF_PLANT_DICTIONARY.CREATED_IN_INSTANCE,,


  		




  
  26
  
    
MODIFIED_BY,*REF_PLANT_DICTIONARY.MODIFIED_BY,,


  		




  
  27
  
    
MODIFIED_DATE,*REF_PLANT_DICTIONARY.MODIFIED_DATE,,


  		




  
  28
  
    
MODIFIED_IN_INSTANCE,*REF_PLANT_DICTIONARY.MODIFIED_IN_INSTANCE,,


  		












  

    
      inputs/FIA/REF_UNIT/header.csv
    
  





  
  1
  
    
row_num,STATECD,VALUE,MEANING,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE


  		












  

    
      inputs/FIA/REF_UNIT/map.csv
    
  





  
  1
  
    
FIA,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*REF_UNIT.row_num,,


  		




  
  3
  
    
STATECD,.STATECD,,


  		




  
  4
  
    
VALUE,.UNITCD,,


  		




  
  5
  
    
MEANING,*REF_UNIT.MEANING,,


  		




  
  6
  
    
CREATED_BY,*REF_UNIT.CREATED_BY,,


  		




  
  7
  
    
CREATED_DATE,*REF_UNIT.CREATED_DATE,,


  		




  
  8
  
    
CREATED_IN_INSTANCE,*REF_UNIT.CREATED_IN_INSTANCE,,


  		




  
  9
  
    
MODIFIED_BY,*REF_UNIT.MODIFIED_BY,,


  		




  
  10
  
    
MODIFIED_DATE,*REF_UNIT.MODIFIED_DATE,,


  		




  
  11
  
    
MODIFIED_IN_INSTANCE,*REF_UNIT.MODIFIED_IN_INSTANCE,,


  		












  

    
      inputs/FIA/REF_UNIT/import
    
  





  3
  3
  
    
cd "$(dirname "$0")"


  		




  4
  4
  
    
. ../../../lib/import.sh


  		




  5
  5
  
    

  		




  
  6
  
    
map_table


  		




  6
  7
  
    
psql <<'EOF'


  		




  7
  
  
    
SELECT functions.to_global_col_names('"REF_UNIT"');


  		




  8
  
  
    

  		




  9
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "REF_UNIT" RENAME "REF_UNIT.STATECD" TO ".STATECD"$$);


  		




  10
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "REF_UNIT" RENAME "REF_UNIT.VALUE"   TO ".UNITCD" $$);


  		




  11
  
  
    

  		




  12
  8
  
    
SELECT functions.set_col_types('"REF_UNIT"', ARRAY[


  		




  13
  9
  
    
  ('.STATECD' , 'integer')


  		




  14
  10
  
    
, ('.UNITCD' , 'integer')


  		












  

    
      inputs/FIA/REF_UNIT/unmapped_terms.csv
    
  





  
  1
  
    
*REF_UNIT.row_num


  		




  
  2
  
    
.STATECD


  		




  
  3
  
    
.UNITCD


  		




  
  4
  
    
*REF_UNIT.MEANING


  		




  
  5
  
    
*REF_UNIT.CREATED_BY


  		




  
  6
  
    
*REF_UNIT.CREATED_DATE


  		




  
  7
  
    
*REF_UNIT.CREATED_IN_INSTANCE


  		




  
  8
  
    
*REF_UNIT.MODIFIED_BY


  		




  
  9
  
    
*REF_UNIT.MODIFIED_DATE


  		




  
  10
  
    
*REF_UNIT.MODIFIED_IN_INSTANCE


  		












  

    
      inputs/FIA/REF_UNIT/new_terms.csv
    
  





  
  1
  
    
row_num,*REF_UNIT.row_num,,


  		




  
  2
  
    
VALUE,.UNITCD,,


  		




  
  3
  
    
MEANING,*REF_UNIT.MEANING,,


  		




  
  4
  
    
CREATED_BY,*REF_UNIT.CREATED_BY,,


  		




  
  5
  
    
CREATED_DATE,*REF_UNIT.CREATED_DATE,,


  		




  
  6
  
    
CREATED_IN_INSTANCE,*REF_UNIT.CREATED_IN_INSTANCE,,


  		




  
  7
  
    
MODIFIED_BY,*REF_UNIT.MODIFIED_BY,,


  		




  
  8
  
    
MODIFIED_DATE,*REF_UNIT.MODIFIED_DATE,,


  		




  
  9
  
    
MODIFIED_IN_INSTANCE,*REF_UNIT.MODIFIED_IN_INSTANCE,,


  		












  

    
      inputs/FIA/COND/header.csv
    
  





  
  1
  
    
row_num,CN,PLT_CN,INVYR,STATECD,UNITCD,COUNTYCD,PLOT,CONDID,COND_STATUS_CD,COND_NONSAMPLE_REASN_CD,RESERVCD,OWNCD,OWNGRPCD,FORINDCD,ADFORCD,FORTYPCD,FLDTYPCD,MAPDEN,STDAGE,STDSZCD,FLDSZCD,SITECLCD,SICOND,SIBASE,SISP,STDORGCD,STDORGSP,PROP_BASIS,CONDPROP_UNADJ,MICRPROP_UNADJ,SUBPPROP_UNADJ,MACRPROP_UNADJ,SLOPE,ASPECT,PHYSCLCD,GSSTKCD,ALSTKCD,DSTRBCD1,DSTRBYR1,DSTRBCD2,DSTRBYR2,DSTRBCD3,DSTRBYR3,TRTCD1,TRTYR1,TRTCD2,TRTYR2,TRTCD3,TRTYR3,PRESNFCD,BALIVE,FLDAGE,ALSTK,GSSTK,FORTYPCDCALC,HABTYPCD1,HABTYPCD1_PUB_CD,HABTYPCD1_DESCR_PUB_CD,HABTYPCD2,HABTYPCD2_PUB_CD,HABTYPCD2_DESCR_PUB_CD,MIXEDCONFCD,VOL_LOC_GRP,SITECLCDEST,SITETREE_TREE,SITECL_METHOD,CARBON_DOWN_DEAD,CARBON_LITTER,CARBON_SOIL_ORG,CARBON_STANDING_DEAD,CARBON_UNDERSTORY_AG,CARBON_UNDERSTORY_BG,CREATED_BY,CREATED_DATE,CREATED_IN_INSTANCE,MODIFIED_BY,MODIFIED_DATE,MODIFIED_IN_INSTANCE,CYCLE,SUBCYCLE,SOIL_ROOTING_DEPTH_PNW,GROUND_LAND_CLASS_PNW,PLANT_STOCKABILITY_FACTOR_PNW,STND_COND_CD_PNWRS,STND_STRUC_CD_PNWRS,STUMP_CD_PNWRS,FIRE_SRS,GRAZING_SRS,HARVEST_TYPE1_SRS,HARVEST_TYPE2_SRS,HARVEST_TYPE3_SRS,LAND_USE_SRS,OPERABILITY_SRS,STAND_STRUCTURE_SRS,NF_COND_STATUS_CD,NF_COND_NONSAMPLE_REASN_CD,CANOPY_CVR_SAMPLE_METHOD_CD,LIVE_CANOPY_CVR_PCT,LIVE_MISSING_CANOPY_CVR_PCT,NBR_LIVE_STEMS,OWNSUBCD,INDUSTRIALCD_FIADB,RESERVCD_FLD,ADMIN_WITHDRAWN_CD


  		












  

    
      inputs/FIA/COND/import
    
  





  3
  3
  
    
cd "$(dirname "$0")"


  		




  4
  4
  
    
. ../../../lib/import.sh


  		




  5
  5
  
    

  		




  
  6
  
    
map_table


  		




  6
  7
  
    
psql <<'EOF'


  		




  7
  
  
    
SELECT functions.to_global_col_names('"COND"');


  		




  8
  
  
    

  		




  9
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.STATECD"          TO ".STATECD"      $$);


  		




  10
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.UNITCD"           TO ".UNITCD"       $$);


  		




  11
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.COUNTYCD"         TO ".COUNTYCD"     $$);


  		




  12
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.PLOT"             TO ".PLOT"         $$);


  		




  13
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.INVYR"            TO ".INVYR"        $$);


  		




  14
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.CONDID"           TO ".CONDID"       $$);


  		




  15
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.HABTYPCD1"        TO ".HABTYPCD"     $$);


  		




  16
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.HABTYPCD1_PUB_CD" TO ".HABTYP_PUB_CD"$$);


  		




  17
  
  
    

  		




  18
  8
  
    
SELECT functions.set_col_types('"COND"', ARRAY[


  		




  19
  9
  
    
  ('.STATECD' , 'integer')


  		




  20
  10
  
    
, ('.UNITCD'  , 'integer')


  		












  

    
      inputs/FIA/COND/unmapped_terms.csv
    
  





  
  1
  
    
*COND.row_num


  		




  
  2
  
    
*COND.CN


  		




  
  3
  
    
*COND.PLT_CN


  		




  
  4
  
    
.INVYR


  		




  
  5
  
    
.STATECD


  		




  
  6
  
    
.UNITCD


  		




  
  7
  
    
.COUNTYCD


  		




  
  8
  
    
.PLOT


  		




  
  9
  
    
.CONDID


  		




  
  10
  
    
*COND.COND_STATUS_CD


  		




  
  11
  
    
*COND.COND_NONSAMPLE_REASN_CD


  		




  
  12
  
    
*COND.RESERVCD


  		




  
  13
  
    
*COND.OWNCD


  		




  
  14
  
    
*COND.OWNGRPCD


  		




  
  15
  
    
*COND.FORINDCD


  		




  
  16
  
    
*COND.ADFORCD


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff