Project

General

Profile

« Previous | Next » 

Revision 10950

inputs/FIA/occurrence_all/: renamed to taxon_observation.** to clarify what an occurrence is. taxon_observation has the same meaning as in VegCore, where each taxon_determination is considered a separate taxon_observation of the associated specimen or vouchered plant (vegpath.org/VegCore/ERD/). (note that having multiple taxon_determinations only makes sense when there is something to reobserve.) the .** is SQL dotpath syntax (wiki.vegpath.org/SQL_dotpaths) for the recursive expansion of all tables to which taxon_observation has forward fkeys (i.e. "the left-join").

View differences:

inputs/FIA/occurrence_all/map.csv
1
FIA,VegCore,Filter,Comments
2
row_num,row_num,,
3
*STATECD,*STATECD,,
4
*UNITCD,*UNITCD,,
5
*COUNTYCD,*COUNTYCD,,
6
*INVYR,*INVYR,,
7
locationName,locationName,,
8
*HABTYPCD,*HABTYPCD,,
9
*HABTYP_PUB_CD,*HABTYP_PUB_CD,,
10
authorEventCode,authorEventCode,,
11
subplot,subplot,,
12
*PLANT_SYMBOL,*PLANT_SYMBOL,,
13
*PLANT_SYMBOL_TYPE,*PLANT_SYMBOL_TYPE,,
14
*SPCD,*SPCD,,
15
*TREE--row_num,*TREE--row_num,,
16
individualObservationID,individualObservationID,,
17
*TREE--PLT_CN,*TREE--PLT_CN,,
18
*TREE--PREV_TRE_CN,*TREE--PREV_TRE_CN,,
19
individualCode,individualCode,,
20
*TREE--AZIMUTH,*TREE--AZIMUTH,,
21
*TREE--DIST,*TREE--DIST,,
22
*TREE--PREVCOND,*TREE--PREVCOND,,
23
*TREE--STATUSCD,*TREE--STATUSCD,,
24
*TREE--SPGRPCD,*TREE--SPGRPCD,,
25
diameterBreastHeight_in,diameterBreastHeight_in,,
26
*TREE--DIAHTCD,*TREE--DIAHTCD,,
27
height_ft,height_ft,,
28
*TREE--HTCD,*TREE--HTCD,,
29
*TREE--ACTUALHT,*TREE--ACTUALHT,,
30
*TREE--TREECLCD,*TREE--TREECLCD,,
31
*TREE--CR,*TREE--CR,,
32
*TREE--CCLCD,*TREE--CCLCD,,
33
*TREE--TREEGRCD,*TREE--TREEGRCD,,
34
*TREE--AGENTCD,*TREE--AGENTCD,,
35
*TREE--CULL,*TREE--CULL,,
36
*TREE--DAMLOC1,*TREE--DAMLOC1,,
37
*TREE--DAMTYP1,*TREE--DAMTYP1,,
38
*TREE--DAMSEV1,*TREE--DAMSEV1,,
39
*TREE--DAMLOC2,*TREE--DAMLOC2,,
40
*TREE--DAMTYP2,*TREE--DAMTYP2,,
41
*TREE--DAMSEV2,*TREE--DAMSEV2,,
42
*TREE--DECAYCD,*TREE--DECAYCD,,
43
*TREE--STOCKING,*TREE--STOCKING,,
44
*TREE--WDLDSTEM,*TREE--WDLDSTEM,,
45
*TREE--VOLCFNET,*TREE--VOLCFNET,,
46
*TREE--VOLCFGRS,*TREE--VOLCFGRS,,
47
*TREE--VOLCSNET,*TREE--VOLCSNET,,
48
*TREE--VOLCSGRS,*TREE--VOLCSGRS,,
49
*TREE--VOLBFNET,*TREE--VOLBFNET,,
50
*TREE--VOLBFGRS,*TREE--VOLBFGRS,,
51
*TREE--VOLCFSND,*TREE--VOLCFSND,,
52
*TREE--GROWCFGS,*TREE--GROWCFGS,,
53
*TREE--GROWBFSL,*TREE--GROWBFSL,,
54
*TREE--GROWCFAL,*TREE--GROWCFAL,,
55
*TREE--MORTCFGS,*TREE--MORTCFGS,,
56
*TREE--MORTBFSL,*TREE--MORTBFSL,,
57
*TREE--MORTCFAL,*TREE--MORTCFAL,,
58
*TREE--REMVCFGS,*TREE--REMVCFGS,,
59
*TREE--REMVBFSL,*TREE--REMVBFSL,,
60
*TREE--REMVCFAL,*TREE--REMVCFAL,,
61
*TREE--DIACHECK,*TREE--DIACHECK,,
62
*TREE--MORTYR,*TREE--MORTYR,,
63
*TREE--SALVCD,*TREE--SALVCD,,
64
*TREE--UNCRCD,*TREE--UNCRCD,,
65
*TREE--CPOSCD,*TREE--CPOSCD,,
66
*TREE--CLIGHTCD,*TREE--CLIGHTCD,,
67
*TREE--CVIGORCD,*TREE--CVIGORCD,,
68
*TREE--CDENCD,*TREE--CDENCD,,
69
*TREE--CDIEBKCD,*TREE--CDIEBKCD,,
70
*TREE--TRANSCD,*TREE--TRANSCD,,
71
*TREE--TREEHISTCD,*TREE--TREEHISTCD,,
72
*TREE--DIACALC,*TREE--DIACALC,,
73
*TREE--BHAGE,*TREE--BHAGE,,
74
*TREE--TOTAGE,*TREE--TOTAGE,,
75
*TREE--CULLDEAD,*TREE--CULLDEAD,,
76
*TREE--CULLFORM,*TREE--CULLFORM,,
77
*TREE--CULLMSTOP,*TREE--CULLMSTOP,,
78
*TREE--CULLBF,*TREE--CULLBF,,
79
*TREE--CULLCF,*TREE--CULLCF,,
80
*TREE--BFSND,*TREE--BFSND,,
81
*TREE--CFSND,*TREE--CFSND,,
82
*TREE--SAWHT,*TREE--SAWHT,,
83
*BOLEHT,*BOLEHT,,
84
*TREE--FORMCL,*TREE--FORMCL,,
85
*TREE--HTCALC,*TREE--HTCALC,,
86
*TREE--HRDWD_CLUMP_CD,*TREE--HRDWD_CLUMP_CD,,
87
*TREE--SITREE,*TREE--SITREE,,
88
*TREE--CREATED_BY,*TREE--CREATED_BY,,
89
*TREE--CREATED_DATE,*TREE--CREATED_DATE,,
90
*TREE--CREATED_IN_INSTANCE,*TREE--CREATED_IN_INSTANCE,,
91
*TREE--MODIFIED_BY,*TREE--MODIFIED_BY,,
92
*TREE--MODIFIED_DATE,*TREE--MODIFIED_DATE,,
93
*TREE--MODIFIED_IN_INSTANCE,*TREE--MODIFIED_IN_INSTANCE,,
94
*TREE--MORTCD,*TREE--MORTCD,,
95
*TREE--HTDMP,*TREE--HTDMP,,
96
*TREE--ROUGHCULL,*TREE--ROUGHCULL,,
97
*TREE--MIST_CL_CD,*TREE--MIST_CL_CD,,
98
*TREE--CULL_FLD,*TREE--CULL_FLD,,
99
*TREE--RECONCILECD,*TREE--RECONCILECD,,
100
*TREE--PREVDIA,*TREE--PREVDIA,,
101
*TREE--FGROWCFGS,*TREE--FGROWCFGS,,
102
*TREE--FGROWBFSL,*TREE--FGROWBFSL,,
103
*TREE--FGROWCFAL,*TREE--FGROWCFAL,,
104
*TREE--FMORTCFGS,*TREE--FMORTCFGS,,
105
*TREE--FMORTBFSL,*TREE--FMORTBFSL,,
106
*TREE--FMORTCFAL,*TREE--FMORTCFAL,,
107
*TREE--FREMVCFGS,*TREE--FREMVCFGS,,
108
*TREE--FREMVBFSL,*TREE--FREMVBFSL,,
109
*TREE--FREMVCFAL,*TREE--FREMVCFAL,,
110
*TREE--P2A_GRM_FLG,*TREE--P2A_GRM_FLG,,
111
*TREE--TREECLCD_NERS,*TREE--TREECLCD_NERS,,
112
*TREE--TREECLCD_SRS,*TREE--TREECLCD_SRS,,
113
*TREE--TREECLCD_NCRS,*TREE--TREECLCD_NCRS,,
114
*TREE--TREECLCD_RMRS,*TREE--TREECLCD_RMRS,,
115
*TREE--STANDING_DEAD_CD,*TREE--STANDING_DEAD_CD,,
116
*TREE--PREV_STATUS_CD,*TREE--PREV_STATUS_CD,,
117
*TREE--PREV_WDLDSTEM,*TREE--PREV_WDLDSTEM,,
118
*TREE--TPA_UNADJ,*TREE--TPA_UNADJ,,
119
*TREE--TPAMORT_UNADJ,*TREE--TPAMORT_UNADJ,,
120
*TREE--TPAREMV_UNADJ,*TREE--TPAREMV_UNADJ,,
121
*TREE--TPAGROW_UNADJ,*TREE--TPAGROW_UNADJ,,
122
*TREE--DRYBIO_BOLE,*TREE--DRYBIO_BOLE,,
123
*TREE--DRYBIO_TOP,*TREE--DRYBIO_TOP,,
124
*TREE--DRYBIO_STUMP,*TREE--DRYBIO_STUMP,,
125
*TREE--DRYBIO_SAPLING,*TREE--DRYBIO_SAPLING,,
126
*TREE--DRYBIO_WDLD_SPP,*TREE--DRYBIO_WDLD_SPP,,
127
*TREE--DRYBIO_BG,*TREE--DRYBIO_BG,,
128
*TREE--CARBON_AG,*TREE--CARBON_AG,,
129
*TREE--CARBON_BG,*TREE--CARBON_BG,,
130
*TREE--CYCLE,*TREE--CYCLE,,
131
*TREE--SUBCYCLE,*TREE--SUBCYCLE,,
132
*TREE--BORED_CD_PNWRS,*TREE--BORED_CD_PNWRS,,
133
*TREE--DAMLOC1_PNWRS,*TREE--DAMLOC1_PNWRS,,
134
*TREE--DAMLOC2_PNWRS,*TREE--DAMLOC2_PNWRS,,
135
*TREE--DIACHECK_PNWRS,*TREE--DIACHECK_PNWRS,,
136
*TREE--DMG_AGENT1_CD_PNWRS,*TREE--DMG_AGENT1_CD_PNWRS,,
137
*TREE--DMG_AGENT2_CD_PNWRS,*TREE--DMG_AGENT2_CD_PNWRS,,
138
*TREE--DMG_AGENT3_CD_PNWRS,*TREE--DMG_AGENT3_CD_PNWRS,,
139
*TREE--MIST_CL_CD_PNWRS,*TREE--MIST_CL_CD_PNWRS,,
140
*TREE--SEVERITY1_CD_PNWRS,*TREE--SEVERITY1_CD_PNWRS,,
141
*TREE--SEVERITY1A_CD_PNWRS,*TREE--SEVERITY1A_CD_PNWRS,,
142
*TREE--SEVERITY1B_CD_PNWRS,*TREE--SEVERITY1B_CD_PNWRS,,
143
*TREE--SEVERITY2_CD_PNWRS,*TREE--SEVERITY2_CD_PNWRS,,
144
*TREE--SEVERITY2A_CD_PNWRS,*TREE--SEVERITY2A_CD_PNWRS,,
145
*TREE--SEVERITY2B_CD_PNWRS,*TREE--SEVERITY2B_CD_PNWRS,,
146
*TREE--SEVERITY3_CD_PNWRS,*TREE--SEVERITY3_CD_PNWRS,,
147
*TREE--UNKNOWN_DAMTYP1_PNWRS,*TREE--UNKNOWN_DAMTYP1_PNWRS,,
148
*TREE--UNKNOWN_DAMTYP2_PNWRS,*TREE--UNKNOWN_DAMTYP2_PNWRS,,
149
*TREE--PREV_PNTN_SRS,*TREE--PREV_PNTN_SRS,,
150
*TREE--DISEASE_SRS,*TREE--DISEASE_SRS,,
151
*TREE--DIEBACK_SEVERITY_SRS,*TREE--DIEBACK_SEVERITY_SRS,,
152
*REF_SPECIES--row_num,*REF_SPECIES--row_num,,
153
*REF_SPECIES--COMMON_NAME,*REF_SPECIES--COMMON_NAME,,
154
*REF_SPECIES--GENUS,*REF_SPECIES--GENUS,,
155
*REF_SPECIES--SPECIES,*REF_SPECIES--SPECIES,,
156
*REF_SPECIES--VARIETY,*REF_SPECIES--VARIETY,,
157
*REF_SPECIES--SUBSPECIES,*REF_SPECIES--SUBSPECIES,,
158
*REF_SPECIES--E_SPGRPCD,*REF_SPECIES--E_SPGRPCD,,
159
*REF_SPECIES--W_SPGRPCD,*REF_SPECIES--W_SPGRPCD,,
160
*REF_SPECIES--C_SPGRPCD,*REF_SPECIES--C_SPGRPCD,,
161
*REF_SPECIES--P_SPGRPCD,*REF_SPECIES--P_SPGRPCD,,
162
*REF_SPECIES--MAJOR_SPGRPCD,*REF_SPECIES--MAJOR_SPGRPCD,,
163
*REF_SPECIES--STOCKING_SPGRPCD,*REF_SPECIES--STOCKING_SPGRPCD,,
164
*REF_SPECIES--FOREST_TYPE_SPGRPCD,*REF_SPECIES--FOREST_TYPE_SPGRPCD,,
165
*REF_SPECIES--EXISTS_IN_NCRS,*REF_SPECIES--EXISTS_IN_NCRS,,
166
*REF_SPECIES--EXISTS_IN_NERS,*REF_SPECIES--EXISTS_IN_NERS,,
167
*REF_SPECIES--EXISTS_IN_PNWRS,*REF_SPECIES--EXISTS_IN_PNWRS,,
168
*REF_SPECIES--EXISTS_IN_RMRS,*REF_SPECIES--EXISTS_IN_RMRS,,
169
*REF_SPECIES--EXISTS_IN_SRS,*REF_SPECIES--EXISTS_IN_SRS,,
170
*REF_SPECIES--SITETREE,*REF_SPECIES--SITETREE,,
171
*REF_SPECIES--SFTWD_HRDWD,*REF_SPECIES--SFTWD_HRDWD,,
172
*REF_SPECIES--ST_EXISTS_IN_NCRS,*REF_SPECIES--ST_EXISTS_IN_NCRS,,
173
*REF_SPECIES--ST_EXISTS_IN_NERS,*REF_SPECIES--ST_EXISTS_IN_NERS,,
174
*REF_SPECIES--ST_EXISTS_IN_PNWRS,*REF_SPECIES--ST_EXISTS_IN_PNWRS,,
175
*REF_SPECIES--ST_EXISTS_IN_RMRS,*REF_SPECIES--ST_EXISTS_IN_RMRS,,
176
*REF_SPECIES--ST_EXISTS_IN_SRS,*REF_SPECIES--ST_EXISTS_IN_SRS,,
177
*REF_SPECIES--CORE,*REF_SPECIES--CORE,,
178
*REF_SPECIES--EAST,*REF_SPECIES--EAST,,
179
*REF_SPECIES--WEST,*REF_SPECIES--WEST,,
180
*REF_SPECIES--CARIBBEAN,*REF_SPECIES--CARIBBEAN,,
181
*REF_SPECIES--PACIFIC,*REF_SPECIES--PACIFIC,,
182
*REF_SPECIES--WOODLAND,*REF_SPECIES--WOODLAND,,
183
*REF_SPECIES--MANUAL_START,*REF_SPECIES--MANUAL_START,,
184
*REF_SPECIES--MANUAL_END,*REF_SPECIES--MANUAL_END,,
185
*REF_SPECIES--JENKINS_SPGRPCD,*REF_SPECIES--JENKINS_SPGRPCD,,
186
*REF_SPECIES--JENKINS_TOTAL_B1,*REF_SPECIES--JENKINS_TOTAL_B1,,
187
*REF_SPECIES--JENKINS_TOTAL_B2,*REF_SPECIES--JENKINS_TOTAL_B2,,
188
*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B1,*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B1,,
189
*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B2,*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B2,,
190
*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B1,*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B1,,
191
*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B2,*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B2,,
192
*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B1,*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B1,,
193
*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B2,*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B2,,
194
*REF_SPECIES--JENKINS_ROOT_RATIO_B1,*REF_SPECIES--JENKINS_ROOT_RATIO_B1,,
195
*REF_SPECIES--JENKINS_ROOT_RATIO_B2,*REF_SPECIES--JENKINS_ROOT_RATIO_B2,,
196
*REF_SPECIES--JENKINS_SAPLING_ADJUSTMENT,*REF_SPECIES--JENKINS_SAPLING_ADJUSTMENT,,
197
*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT,*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT,,
198
*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT_CIT,,
199
*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT,*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT,,
200
*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT_CIT,*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT_CIT,,
201
*REF_SPECIES--MC_PCT_GREEN_BARK,*REF_SPECIES--MC_PCT_GREEN_BARK,,
202
*REF_SPECIES--MC_PCT_GREEN_BARK_CIT,*REF_SPECIES--MC_PCT_GREEN_BARK_CIT,,
203
*REF_SPECIES--MC_PCT_GREEN_WOOD,*REF_SPECIES--MC_PCT_GREEN_WOOD,,
204
*REF_SPECIES--MC_PCT_GREEN_WOOD_CIT,*REF_SPECIES--MC_PCT_GREEN_WOOD_CIT,,
205
*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT,*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT,,
206
*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT_CIT,*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT_CIT,,
207
*REF_SPECIES--BARK_VOL_PCT,*REF_SPECIES--BARK_VOL_PCT,,
208
*REF_SPECIES--BARK_VOL_PCT_CIT,*REF_SPECIES--BARK_VOL_PCT_CIT,,
209
*REF_SPECIES--RAILE_STUMP_DOB_B1,*REF_SPECIES--RAILE_STUMP_DOB_B1,,
210
*REF_SPECIES--RAILE_STUMP_DIB_B1,*REF_SPECIES--RAILE_STUMP_DIB_B1,,
211
*REF_SPECIES--RAILE_STUMP_DIB_B2,*REF_SPECIES--RAILE_STUMP_DIB_B2,,
212
*REF_SPECIES--CWD_DECAY_RATIO1,*REF_SPECIES--CWD_DECAY_RATIO1,,
213
*REF_SPECIES--CWD_DECAY_RATIO2,*REF_SPECIES--CWD_DECAY_RATIO2,,
214
*REF_SPECIES--CWD_DECAY_RATIO3,*REF_SPECIES--CWD_DECAY_RATIO3,,
215
*REF_SPECIES--CWD_DECAY_RATIO4,*REF_SPECIES--CWD_DECAY_RATIO4,,
216
*REF_SPECIES--CWD_DECAY_RATIO5,*REF_SPECIES--CWD_DECAY_RATIO5,,
217
*REF_SPECIES--DWM_CARBON_RATIO,*REF_SPECIES--DWM_CARBON_RATIO,,
218
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO1,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO1,,
219
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO2,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO2,,
220
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO3,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO3,,
221
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO4,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO4,,
222
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO5,*REF_SPECIES--STANDING_DEAD_DECAY_RATIO5,,
223
*REF_SPECIES--CREATED_BY,*REF_SPECIES--CREATED_BY,,
224
*REF_SPECIES--CREATED_DATE,*REF_SPECIES--CREATED_DATE,,
225
*REF_SPECIES--CREATED_IN_INSTANCE,*REF_SPECIES--CREATED_IN_INSTANCE,,
226
*REF_SPECIES--MODIFIED_BY,*REF_SPECIES--MODIFIED_BY,,
227
*REF_SPECIES--MODIFIED_DATE,*REF_SPECIES--MODIFIED_DATE,,
228
*REF_SPECIES--MODIFIED_IN_INSTANCE,*REF_SPECIES--MODIFIED_IN_INSTANCE,,
229
*REF_PLANT_DICTIONARY--row_num,*REF_PLANT_DICTIONARY--row_num,,
230
*REF_PLANT_DICTIONARY--CN,*REF_PLANT_DICTIONARY--CN,,
231
taxonName,taxonName,,
232
*REF_PLANT_DICTIONARY--NEW_SYMBOL,*REF_PLANT_DICTIONARY--NEW_SYMBOL,,
233
*REF_PLANT_DICTIONARY--NEW_SCIENTIFIC_NAME,*REF_PLANT_DICTIONARY--NEW_SCIENTIFIC_NAME,,
234
vernacularName,vernacularName,,
235
*REF_PLANT_DICTIONARY--CATEGORY,*REF_PLANT_DICTIONARY--CATEGORY,,
236
family,family,,
237
taxonGrowthForm,taxonGrowthForm,,
238
*REF_PLANT_DICTIONARY--DURATION,*REF_PLANT_DICTIONARY--DURATION,,
239
*REF_PLANT_DICTIONARY--US_NATIVITY,*REF_PLANT_DICTIONARY--US_NATIVITY,,
240
*REF_PLANT_DICTIONARY--STATE_DISTRIBUTION,*REF_PLANT_DICTIONARY--STATE_DISTRIBUTION,,
241
*REF_PLANT_DICTIONARY--STATE_AND_PROVINCE,*REF_PLANT_DICTIONARY--STATE_AND_PROVINCE,,
242
scientificName,scientificName,,
243
*GENERA_BINOMIAL_AUTHOR,*GENERA_BINOMIAL_AUTHOR,,
244
*TRINOMIAL_AUTHOR,*TRINOMIAL_AUTHOR,,
245
*QUADRINOMIAL_AUTHOR,*QUADRINOMIAL_AUTHOR,,
246
*XGENUS,*XGENUS,,
247
genus,genus,,
248
*XSPECIES,*XSPECIES,,
249
specificEpithet,specificEpithet,,
250
*SSP_PREFIX,*SSP_PREFIX,,
251
*XSUBSPECIES,*XSUBSPECIES,,
252
subspecies,subspecies,,
253
*VAR_PREFIX,*VAR_PREFIX,,
254
*XVARIETY,*XVARIETY,,
255
variety,variety,,
256
*SUBVAR,*SUBVAR,,
257
*SUBVARIETY,*SUBVARIETY,,
258
*F_PREFIX,*F_PREFIX,,
259
forma,forma,,
260
*REF_PLANT_DICTIONARY--NOTES,*REF_PLANT_DICTIONARY--NOTES,,
261
*REF_PLANT_DICTIONARY--CREATED_BY,*REF_PLANT_DICTIONARY--CREATED_BY,,
262
*REF_PLANT_DICTIONARY--CREATED_DATE,*REF_PLANT_DICTIONARY--CREATED_DATE,,
263
*REF_PLANT_DICTIONARY--CREATED_IN_INSTANCE,*REF_PLANT_DICTIONARY--CREATED_IN_INSTANCE,,
264
*REF_PLANT_DICTIONARY--MODIFIED_BY,*REF_PLANT_DICTIONARY--MODIFIED_BY,,
265
*REF_PLANT_DICTIONARY--MODIFIED_DATE,*REF_PLANT_DICTIONARY--MODIFIED_DATE,,
266
*REF_PLANT_DICTIONARY--MODIFIED_IN_INSTANCE,*REF_PLANT_DICTIONARY--MODIFIED_IN_INSTANCE,,
267
*SUBPLOT--row_num,*SUBPLOT--row_num,,
268
subplotID,subplotID,,
269
*SUBPLOT--PLT_CN,*SUBPLOT--PLT_CN,,
270
*SUBPLOT--PREV_SBP_CN,*SUBPLOT--PREV_SBP_CN,,
271
*SUBPLOT--SUBP_STATUS_CD,*SUBPLOT--SUBP_STATUS_CD,,
272
*SUBPLOT--POINT_NONSAMPLE_REASN_CD,*SUBPLOT--POINT_NONSAMPLE_REASN_CD,,
273
*SUBPLOT--MICRCOND,*SUBPLOT--MICRCOND,,
274
*SUBPLOT--SUBPCOND,*SUBPLOT--SUBPCOND,,
275
*SUBPLOT--MACRCOND,*SUBPLOT--MACRCOND,,
276
*SUBPLOT--CONDLIST,*SUBPLOT--CONDLIST,,
277
*SUBPLOT--SLOPE,*SUBPLOT--SLOPE,,
278
*SUBPLOT--ASPECT,*SUBPLOT--ASPECT,,
279
*SUBPLOT--WATERDEP,*SUBPLOT--WATERDEP,,
280
*SUBPLOT--P2A_GRM_FLG,*SUBPLOT--P2A_GRM_FLG,,
281
*SUBPLOT--CREATED_BY,*SUBPLOT--CREATED_BY,,
282
*SUBPLOT--CREATED_DATE,*SUBPLOT--CREATED_DATE,,
283
*SUBPLOT--CREATED_IN_INSTANCE,*SUBPLOT--CREATED_IN_INSTANCE,,
284
*SUBPLOT--MODIFIED_BY,*SUBPLOT--MODIFIED_BY,,
285
*SUBPLOT--MODIFIED_DATE,*SUBPLOT--MODIFIED_DATE,,
286
*SUBPLOT--MODIFIED_IN_INSTANCE,*SUBPLOT--MODIFIED_IN_INSTANCE,,
287
*SUBPLOT--CYCLE,*SUBPLOT--CYCLE,,
288
*SUBPLOT--SUBCYCLE,*SUBPLOT--SUBCYCLE,,
289
*SUBPLOT--ROOT_DIS_SEV_CD_PNWRS,*SUBPLOT--ROOT_DIS_SEV_CD_PNWRS,,
290
*SUBPLOT--NF_SUBP_STATUS_CD,*SUBPLOT--NF_SUBP_STATUS_CD,,
291
*SUBPLOT--NF_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT--NF_SUBP_NONSAMPLE_REASN_CD,,
292
*SUBPLOT--P2VEG_SUBP_STATUS_CD,*SUBPLOT--P2VEG_SUBP_STATUS_CD,,
293
*SUBPLOT--P2VEG_SUBP_NONSAMPLE_REASN_CD,*SUBPLOT--P2VEG_SUBP_NONSAMPLE_REASN_CD,,
294
*SUBPLOT--INVASIVE_SUBP_STATUS_CD,*SUBPLOT--INVASIVE_SUBP_STATUS_CD,,
295
*SUBPLOT--INVASIVE_NONSAMPLE_REASN_CD,*SUBPLOT--INVASIVE_NONSAMPLE_REASN_CD,,
296
*COND--row_num,*COND--row_num,,
297
*COND--CN,*COND--CN,,
298
*COND--PLT_CN,*COND--PLT_CN,,
299
*COND--COND_STATUS_CD,*COND--COND_STATUS_CD,,
300
*COND--COND_NONSAMPLE_REASN_CD,*COND--COND_NONSAMPLE_REASN_CD,,
301
*COND--RESERVCD,*COND--RESERVCD,,
302
*COND--OWNCD,*COND--OWNCD,,
303
*COND--OWNGRPCD,*COND--OWNGRPCD,,
304
*COND--FORINDCD,*COND--FORINDCD,,
305
*COND--ADFORCD,*COND--ADFORCD,,
306
*COND--FORTYPCD,*COND--FORTYPCD,,
307
*COND--FLDTYPCD,*COND--FLDTYPCD,,
308
*COND--MAPDEN,*COND--MAPDEN,,
309
*COND--STDAGE,*COND--STDAGE,,
310
*COND--STDSZCD,*COND--STDSZCD,,
311
*COND--FLDSZCD,*COND--FLDSZCD,,
312
*COND--SITECLCD,*COND--SITECLCD,,
313
*COND--SICOND,*COND--SICOND,,
314
*COND--SIBASE,*COND--SIBASE,,
315
*COND--SISP,*COND--SISP,,
316
*COND--STDORGCD,*COND--STDORGCD,,
317
*COND--STDORGSP,*COND--STDORGSP,,
318
*COND--PROP_BASIS,*COND--PROP_BASIS,,
319
*COND--CONDPROP_UNADJ,*COND--CONDPROP_UNADJ,,
320
*COND--MICRPROP_UNADJ,*COND--MICRPROP_UNADJ,,
321
*COND--SUBPPROP_UNADJ,*COND--SUBPPROP_UNADJ,,
322
*COND--MACRPROP_UNADJ,*COND--MACRPROP_UNADJ,,
323
slopeGradient,slopeGradient,,
324
slopeAspect,slopeAspect,,
325
*COND--PHYSCLCD,*COND--PHYSCLCD,,
326
*COND--GSSTKCD,*COND--GSSTKCD,,
327
*COND--ALSTKCD,*COND--ALSTKCD,,
328
*COND--DSTRBCD1,*COND--DSTRBCD1,,
329
*COND--DSTRBYR1,*COND--DSTRBYR1,,
330
*COND--DSTRBCD2,*COND--DSTRBCD2,,
331
*COND--DSTRBYR2,*COND--DSTRBYR2,,
332
*COND--DSTRBCD3,*COND--DSTRBCD3,,
333
*COND--DSTRBYR3,*COND--DSTRBYR3,,
334
*COND--TRTCD1,*COND--TRTCD1,,
335
*COND--TRTYR1,*COND--TRTYR1,,
336
*COND--TRTCD2,*COND--TRTCD2,,
337
*COND--TRTYR2,*COND--TRTYR2,,
338
*COND--TRTCD3,*COND--TRTCD3,,
339
*COND--TRTYR3,*COND--TRTYR3,,
340
*COND--PRESNFCD,*COND--PRESNFCD,,
341
*COND--BALIVE,*COND--BALIVE,,
342
*COND--FLDAGE,*COND--FLDAGE,,
343
*COND--ALSTK,*COND--ALSTK,,
344
*COND--GSSTK,*COND--GSSTK,,
345
*COND--FORTYPCDCALC,*COND--FORTYPCDCALC,,
346
*COND--HABTYPCD1_DESCR_PUB_CD,*COND--HABTYPCD1_DESCR_PUB_CD,,
347
*COND--HABTYPCD2,*COND--HABTYPCD2,,
348
*COND--HABTYPCD2_PUB_CD,*COND--HABTYPCD2_PUB_CD,,
349
*COND--HABTYPCD2_DESCR_PUB_CD,*COND--HABTYPCD2_DESCR_PUB_CD,,
350
*COND--MIXEDCONFCD,*COND--MIXEDCONFCD,,
351
*COND--VOL_LOC_GRP,*COND--VOL_LOC_GRP,,
352
*COND--SITECLCDEST,*COND--SITECLCDEST,,
353
*COND--SITETREE_TREE,*COND--SITETREE_TREE,,
354
*COND--SITECL_METHOD,*COND--SITECL_METHOD,,
355
*COND--CARBON_DOWN_DEAD,*COND--CARBON_DOWN_DEAD,,
356
*COND--CARBON_LITTER,*COND--CARBON_LITTER,,
357
*COND--CARBON_SOIL_ORG,*COND--CARBON_SOIL_ORG,,
358
*COND--CARBON_STANDING_DEAD,*COND--CARBON_STANDING_DEAD,,
359
*COND--CARBON_UNDERSTORY_AG,*COND--CARBON_UNDERSTORY_AG,,
360
*COND--CARBON_UNDERSTORY_BG,*COND--CARBON_UNDERSTORY_BG,,
361
*COND--CREATED_BY,*COND--CREATED_BY,,
362
*COND--CREATED_DATE,*COND--CREATED_DATE,,
363
*COND--CREATED_IN_INSTANCE,*COND--CREATED_IN_INSTANCE,,
364
*COND--MODIFIED_BY,*COND--MODIFIED_BY,,
365
*COND--MODIFIED_DATE,*COND--MODIFIED_DATE,,
366
*COND--MODIFIED_IN_INSTANCE,*COND--MODIFIED_IN_INSTANCE,,
367
*COND--CYCLE,*COND--CYCLE,,
368
*COND--SUBCYCLE,*COND--SUBCYCLE,,
369
*COND--SOIL_ROOTING_DEPTH_PNW,*COND--SOIL_ROOTING_DEPTH_PNW,,
370
*COND--GROUND_LAND_CLASS_PNW,*COND--GROUND_LAND_CLASS_PNW,,
371
*COND--PLANT_STOCKABILITY_FACTOR_PNW,*COND--PLANT_STOCKABILITY_FACTOR_PNW,,
372
*COND--STND_COND_CD_PNWRS,*COND--STND_COND_CD_PNWRS,,
373
*COND--STND_STRUC_CD_PNWRS,*COND--STND_STRUC_CD_PNWRS,,
374
*COND--STUMP_CD_PNWRS,*COND--STUMP_CD_PNWRS,,
375
*COND--FIRE_SRS,*COND--FIRE_SRS,,
376
*COND--GRAZING_SRS,*COND--GRAZING_SRS,,
377
*COND--HARVEST_TYPE1_SRS,*COND--HARVEST_TYPE1_SRS,,
378
*COND--HARVEST_TYPE2_SRS,*COND--HARVEST_TYPE2_SRS,,
379
*COND--HARVEST_TYPE3_SRS,*COND--HARVEST_TYPE3_SRS,,
380
*COND--LAND_USE_SRS,*COND--LAND_USE_SRS,,
381
*COND--OPERABILITY_SRS,*COND--OPERABILITY_SRS,,
382
*COND--STAND_STRUCTURE_SRS,*COND--STAND_STRUCTURE_SRS,,
383
*COND--NF_COND_STATUS_CD,*COND--NF_COND_STATUS_CD,,
384
*COND--NF_COND_NONSAMPLE_REASN_CD,*COND--NF_COND_NONSAMPLE_REASN_CD,,
385
*COND--CANOPY_CVR_SAMPLE_METHOD_CD,*COND--CANOPY_CVR_SAMPLE_METHOD_CD,,
386
*COND--LIVE_CANOPY_CVR_PCT,*COND--LIVE_CANOPY_CVR_PCT,,
387
*COND--LIVE_MISSING_CANOPY_CVR_PCT,*COND--LIVE_MISSING_CANOPY_CVR_PCT,,
388
*COND--NBR_LIVE_STEMS,*COND--NBR_LIVE_STEMS,,
389
*COND--OWNSUBCD,*COND--OWNSUBCD,,
390
*COND--INDUSTRIALCD_FIADB,*COND--INDUSTRIALCD_FIADB,,
391
*COND--RESERVCD_FLD,*COND--RESERVCD_FLD,,
392
*COND--ADMIN_WITHDRAWN_CD,*COND--ADMIN_WITHDRAWN_CD,,
393
oldGrowth,oldGrowth,,
394
cultivated,cultivated,,
395
*REF_HABTYP_DESCRIPTION--row_num,*REF_HABTYP_DESCRIPTION--row_num,,
396
communityID,communityID,,
397
*REF_HABTYP_DESCRIPTION--SCIENTIFIC_NAME,*REF_HABTYP_DESCRIPTION--SCIENTIFIC_NAME,,
398
communityName,communityName,,
399
*REF_HABTYP_DESCRIPTION--VALID,*REF_HABTYP_DESCRIPTION--VALID,,
400
*REF_HABTYP_DESCRIPTION--CREATED_BY,*REF_HABTYP_DESCRIPTION--CREATED_BY,,
401
*REF_HABTYP_DESCRIPTION--CREATED_DATE,*REF_HABTYP_DESCRIPTION--CREATED_DATE,,
402
*REF_HABTYP_DESCRIPTION--CREATED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION--CREATED_IN_INSTANCE,,
403
*REF_HABTYP_DESCRIPTION--MODIFIED_BY,*REF_HABTYP_DESCRIPTION--MODIFIED_BY,,
404
*REF_HABTYP_DESCRIPTION--MODIFIED_DATE,*REF_HABTYP_DESCRIPTION--MODIFIED_DATE,,
405
*REF_HABTYP_DESCRIPTION--MODIFIED_IN_INSTANCE,*REF_HABTYP_DESCRIPTION--MODIFIED_IN_INSTANCE,,
406
*PLOT--row_num,*PLOT--row_num,,
407
locationID,locationID,,
408
*PLOT--SRV_CN,*PLOT--SRV_CN,,
409
*PLOT--CTY_CN,*PLOT--CTY_CN,,
410
*PLOT--PREV_PLT_CN,*PLOT--PREV_PLT_CN,,
411
*PLOT--PLOT_STATUS_CD,*PLOT--PLOT_STATUS_CD,,
412
*PLOT--PLOT_NONSAMPLE_REASN_CD,*PLOT--PLOT_NONSAMPLE_REASN_CD,,
413
year,year,,
414
month,month,,
415
day,day,,
416
*PLOT--REMPER,*PLOT--REMPER,,
417
*PLOT--KINDCD,*PLOT--KINDCD,,
418
*PLOT--DESIGNCD,*PLOT--DESIGNCD,,
419
*PLOT--RDDISTCD,*PLOT--RDDISTCD,,
420
*PLOT--WATERCD,*PLOT--WATERCD,,
421
decimalLatitude,decimalLatitude,,
422
decimalLongitude,decimalLongitude,,
423
elevation_ft,elevation_ft,,
424
*PLOT--GROW_TYP_CD,*PLOT--GROW_TYP_CD,,
425
*PLOT--MORT_TYP_CD,*PLOT--MORT_TYP_CD,,
426
*PLOT--P2PANEL,*PLOT--P2PANEL,,
427
*PLOT--P3PANEL,*PLOT--P3PANEL,,
428
*PLOT--ECOSUBCD,*PLOT--ECOSUBCD,,
429
*PLOT--CONGCD,*PLOT--CONGCD,,
430
*PLOT--MANUAL,*PLOT--MANUAL,,
431
*PLOT--SUBPANEL,*PLOT--SUBPANEL,,
432
*PLOT--KINDCD_NC,*PLOT--KINDCD_NC,,
433
*PLOT--QA_STATUS,*PLOT--QA_STATUS,,
434
*PLOT--CREATED_BY,*PLOT--CREATED_BY,,
435
*PLOT--CREATED_DATE,*PLOT--CREATED_DATE,,
436
*PLOT--CREATED_IN_INSTANCE,*PLOT--CREATED_IN_INSTANCE,,
437
*PLOT--MODIFIED_BY,*PLOT--MODIFIED_BY,,
438
*PLOT--MODIFIED_DATE,*PLOT--MODIFIED_DATE,,
439
*PLOT--MODIFIED_IN_INSTANCE,*PLOT--MODIFIED_IN_INSTANCE,,
440
*PLOT--MICROPLOT_LOC,*PLOT--MICROPLOT_LOC,,
441
*PLOT--DECLINATION,*PLOT--DECLINATION,,
442
*PLOT--EMAP_HEX,*PLOT--EMAP_HEX,,
443
*PLOT--SAMP_METHOD_CD,*PLOT--SAMP_METHOD_CD,,
444
*PLOT--SUBP_EXAMINE_CD,*PLOT--SUBP_EXAMINE_CD,,
445
*PLOT--MACRO_BREAKPOINT_DIA,*PLOT--MACRO_BREAKPOINT_DIA,,
446
*PLOT--INTENSITY,*PLOT--INTENSITY,,
447
*PLOT--CYCLE,*PLOT--CYCLE,,
448
*PLOT--SUBCYCLE,*PLOT--SUBCYCLE,,
449
*PLOT--ECO_UNIT_PNW,*PLOT--ECO_UNIT_PNW,,
450
*PLOT--TOPO_POSITION_PNW,*PLOT--TOPO_POSITION_PNW,,
451
*PLOT--NF_SAMPLING_STATUS_CD,*PLOT--NF_SAMPLING_STATUS_CD,,
452
*PLOT--NF_PLOT_STATUS_CD,*PLOT--NF_PLOT_STATUS_CD,,
453
*PLOT--NF_PLOT_NONSAMPLE_REASN_CD,*PLOT--NF_PLOT_NONSAMPLE_REASN_CD,,
454
*PLOT--P2VEG_SAMPLING_STATUS_CD,*PLOT--P2VEG_SAMPLING_STATUS_CD,,
455
*PLOT--P2VEG_SAMPLING_LEVEL_DETAIL_CD,*PLOT--P2VEG_SAMPLING_LEVEL_DETAIL_CD,,
456
*PLOT--INVASIVE_SAMPLING_STATUS_CD,*PLOT--INVASIVE_SAMPLING_STATUS_CD,,
457
*PLOT--INVASIVE_SPECIMEN_RULE_CD,*PLOT--INVASIVE_SPECIMEN_RULE_CD,,
458
*PLOT--DESIGNCD_P2A,*PLOT--DESIGNCD_P2A,,
459
*COUNTY--row_num,*COUNTY--row_num,,
460
county,county,,
461
*COUNTY--CN,*COUNTY--CN,,
462
*COUNTY--CREATED_BY,*COUNTY--CREATED_BY,,
463
*COUNTY--CREATED_DATE,*COUNTY--CREATED_DATE,,
464
*COUNTY--CREATED_IN_INSTANCE,*COUNTY--CREATED_IN_INSTANCE,,
465
*COUNTY--MODIFIED_BY,*COUNTY--MODIFIED_BY,,
466
*COUNTY--MODIFIED_DATE,*COUNTY--MODIFIED_DATE,,
467
*COUNTY--MODIFIED_IN_INSTANCE,*COUNTY--MODIFIED_IN_INSTANCE,,
468
*REF_UNIT--row_num,*REF_UNIT--row_num,,
469
*REF_UNIT--MEANING,*REF_UNIT--MEANING,,
470
*REF_UNIT--CREATED_BY,*REF_UNIT--CREATED_BY,,
471
*REF_UNIT--CREATED_DATE,*REF_UNIT--CREATED_DATE,,
472
*REF_UNIT--CREATED_IN_INSTANCE,*REF_UNIT--CREATED_IN_INSTANCE,,
473
*REF_UNIT--MODIFIED_BY,*REF_UNIT--MODIFIED_BY,,
474
*REF_UNIT--MODIFIED_DATE,*REF_UNIT--MODIFIED_DATE,,
475
*REF_UNIT--MODIFIED_IN_INSTANCE,*REF_UNIT--MODIFIED_IN_INSTANCE,,
476
*REF_RESEARCH_STATION--row_num,*REF_RESEARCH_STATION--row_num,,
477
*REF_RESEARCH_STATION--RSCD,*REF_RESEARCH_STATION--RSCD,,
478
*REF_RESEARCH_STATION--RS,*REF_RESEARCH_STATION--RS,,
479
stateProvince,stateProvince,,
480
*REF_RESEARCH_STATION--STATE_ABBR,*REF_RESEARCH_STATION--STATE_ABBR,,
481
*REF_RESEARCH_STATION--CREATED_BY,*REF_RESEARCH_STATION--CREATED_BY,,
482
*REF_RESEARCH_STATION--CREATED_DATE,*REF_RESEARCH_STATION--CREATED_DATE,,
483
*REF_RESEARCH_STATION--CREATED_IN_INSTANCE,*REF_RESEARCH_STATION--CREATED_IN_INSTANCE,,
484
*REF_RESEARCH_STATION--MODIFIED_BY,*REF_RESEARCH_STATION--MODIFIED_BY,,
485
*REF_RESEARCH_STATION--MODIFIED_DATE,*REF_RESEARCH_STATION--MODIFIED_DATE,,
486
*REF_RESEARCH_STATION--MODIFIED_IN_INSTANCE,*REF_RESEARCH_STATION--MODIFIED_IN_INSTANCE,,
inputs/FIA/occurrence_all/test.xml.ref
1
Put template:
2
<VegBIEN>
3
    <_setDefault id="-1">
4
        <source_id><source><shortname>FIA.new</shortname></source></source_id>
5
        <path>
6
            <_simplifyPath>
7
                <next>parent_id</next>
8
                <path>
9
                    <location>
10
                        <parent_id>
11
                            <location>
12
                                <authorlocationcode>$locationName</authorlocationcode>
13
                                <sourceaccessioncode>$locationID</sourceaccessioncode>
14
                            </location>
15
                        </parent_id>
16
                        <authorlocationcode>$subplot</authorlocationcode>
17
                        <locationevent>
18
                            <parent_id>
19
                                <locationevent>
20
                                    <location_id>
21
                                        <location>
22
                                            <authorlocationcode>
23
                                                <_if name="if subplot">
24
                                                    <cond>$subplotID</cond>
25
                                                    <then>$locationName</then>
26
                                                </_if>
27
                                            </authorlocationcode>
28
                                            <sourceaccessioncode>
29
                                                <_if name="if subplot">
30
                                                    <cond>$subplotID</cond>
31
                                                    <then>$locationID</then>
32
                                                </_if>
33
                                            </sourceaccessioncode>
34
                                        </location>
35
                                    </location_id>
36
                                    <authoreventcode>$authorEventCode</authoreventcode>
37
                                </locationevent>
38
                            </parent_id>
39
                            <commclass>
40
                                <commdetermination>
41
                                    <commconcept_id>
42
                                        <commconcept>
43
                                            <commname_id><commname><commname>$communityID</commname></commname></commname_id>
44
                                            <commdescription>$communityName</commdescription>
45
                                        </commconcept>
46
                                    </commconcept_id>
47
                                </commdetermination>
48
                            </commclass>
49
                            <taxonoccurrence>
50
                                <aggregateoccurrence>
51
                                    <plantobservation>
52
                                        <authorplantcode>$individualCode</authorplantcode>
53
                                        <sourceaccessioncode>$individualObservationID</sourceaccessioncode>
54
                                        <stemobservation>
55
                                            <diameterbreastheight_m><_in_to_m><value>$diameterBreastHeight_in</value></_in_to_m></diameterbreastheight_m>
56
                                            <height_m><_ft_to_m><value>$height_ft</value></_ft_to_m></height_m>
57
                                        </stemobservation>
58
                                    </plantobservation>
59
                                </aggregateoccurrence>
60
                                <authortaxoncode>$individualCode</authortaxoncode>
61
                                <iscultivated>$cultivated</iscultivated>
62
                                <sourceaccessioncode>$individualObservationID</sourceaccessioncode>
63
                                <taxondetermination>
64
                                    <taxonverbatim_id>
65
                                        <taxonverbatim>
66
                                            <taxonlabel_id>
67
                                                <taxonlabel>
68
                                                    <parent_id>
69
                                                        <taxonlabel>
70
                                                            <parent_id>
71
                                                                <taxonlabel>
72
                                                                    <rank>cultivar</rank>
73
                                                                    <parent_id>
74
                                                                        <taxonlabel>
75
                                                                            <rank>forma</rank>
76
                                                                            <taxonepithet>$forma</taxonepithet>
77
                                                                            <parent_id>
78
                                                                                <taxonlabel>
79
                                                                                    <rank>variety</rank>
80
                                                                                    <taxonepithet>$variety</taxonepithet>
81
                                                                                    <parent_id>
82
                                                                                        <taxonlabel>
83
                                                                                            <rank>subspecies</rank>
84
                                                                                            <taxonepithet>$subspecies</taxonepithet>
85
                                                                                            <parent_id>
86
                                                                                                <taxonlabel>
87
                                                                                                    <rank>species</rank>
88
                                                                                                    <taxonepithet>$specificEpithet</taxonepithet>
89
                                                                                                    <parent_id>
90
                                                                                                        <taxonlabel>
91
                                                                                                            <rank>genus</rank>
92
                                                                                                            <taxonepithet>$genus</taxonepithet>
93
                                                                                                            <parent_id>
94
                                                                                                                <taxonlabel>
95
                                                                                                                    <rank>family</rank>
96
                                                                                                                    <taxonepithet>$family</taxonepithet>
97
                                                                                                                </taxonlabel>
98
                                                                                                            </parent_id>
99
                                                                                                        </taxonlabel>
100
                                                                                                    </parent_id>
101
                                                                                                </taxonlabel>
102
                                                                                            </parent_id>
103
                                                                                        </taxonlabel>
104
                                                                                    </parent_id>
105
                                                                                </taxonlabel>
106
                                                                            </parent_id>
107
                                                                        </taxonlabel>
108
                                                                    </parent_id>
109
                                                                </taxonlabel>
110
                                                            </parent_id>
111
                                                        </taxonlabel>
112
                                                    </parent_id>
113
                                                    <taxonomicname>
114
                                                        <_merge_prefix>
115
                                                            <prefix><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></prefix>
116
                                                            <value>
117
                                                                <_alt>
118
                                                                    <1>$scientificName</1>
119
                                                                    <2>
120
                                                                        <_alt>
121
                                                                            <1>$taxonName</1>
122
                                                                            <2>
123
                                                                                <_join_words>
124
                                                                                    <2><_filter_genus><value>$genus</value></_filter_genus></2>
125
                                                                                    <3>$specificEpithet</3>
126
                                                                                    <4>$subspecies</4>
127
                                                                                    <6>
128
                                                                                        <_join_words>
129
                                                                                            <1>var. </1>
130
                                                                                            <2>$variety</2>
131
                                                                                        </_join_words>
132
                                                                                    </6>
133
                                                                                    <7>
134
                                                                                        <_join_words>
135
                                                                                            <1>fm. </1>
136
                                                                                            <2>$forma</2>
137
                                                                                        </_join_words>
138
                                                                                    </7>
139
                                                                                </_join_words>
140
                                                                            </2>
141
                                                                        </_alt>
142
                                                                    </2>
143
                                                                </_alt>
144
                                                            </value>
145
                                                        </_merge_prefix>
146
                                                    </taxonomicname>
147
                                                </taxonlabel>
148
                                            </taxonlabel_id>
149
                                            <family>$family</family>
150
                                            <genus>$genus</genus>
151
                                            <specific_epithet>$specificEpithet</specific_epithet>
152
                                            <taxonname>$taxonName</taxonname>
153
                                            <taxonomicname>$scientificName</taxonomicname>
154
                                        </taxonverbatim>
155
                                    </taxonverbatim_id>
156
                                </taxondetermination>
157
                            </taxonoccurrence>
158
                        </locationevent>
159
                        <locationplace>
160
                            <place_id>
161
                                <place>
162
                                    <coordinates_id>
163
                                        <coordinates>
164
                                            <latitude_deg>
165
                                                <_nullIf>
166
                                                    <null>0</null>
167
                                                    <type>float</type>
168
                                                    <value>$decimalLatitude</value>
169
                                                </_nullIf>
170
                                            </latitude_deg>
171
                                            <longitude_deg>
172
                                                <_nullIf>
173
                                                    <null>0</null>
174
                                                    <type>float</type>
175
                                                    <value>$decimalLongitude</value>
176
                                                </_nullIf>
177
                                            </longitude_deg>
178
                                        </coordinates>
179
                                    </coordinates_id>
180
                                    <county>$county</county>
181
                                    <matched_place_id>
182
                                        <place>
183
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
184
                                            <coordinates_id>
185
                                                <coordinates>
186
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
187
                                                    <latitude_deg>
188
                                                        <_nullIf>
189
                                                            <null>0</null>
190
                                                            <type>float</type>
191
                                                            <value>$decimalLatitude</value>
192
                                                        </_nullIf>
193
                                                    </latitude_deg>
194
                                                    <longitude_deg>
195
                                                        <_nullIf>
196
                                                            <null>0</null>
197
                                                            <type>float</type>
198
                                                            <value>$decimalLongitude</value>
199
                                                        </_nullIf>
200
                                                    </longitude_deg>
201
                                                </coordinates>
202
                                            </coordinates_id>
203
                                            <county>$county</county>
204
                                            <stateprovince>$stateProvince</stateprovince>
205
                                        </place>
206
                                    </matched_place_id>
207
                                    <stateprovince>$stateProvince</stateprovince>
208
                                </place>
209
                            </place_id>
210
                        </locationplace>
211
                        <slopeaspect_deg><_compass><value>$slopeAspect</value></_compass></slopeaspect_deg>
212
                        <slopegradient_fraction>$slopeGradient</slopegradient_fraction>
213
                        <sourceaccessioncode>$subplotID</sourceaccessioncode>
214
                    </location>
215
                </path>
216
            </_simplifyPath>
217
        </path>
218
    </_setDefault>
219
</VegBIEN>
220
Inserted 27 new rows into database
inputs/FIA/occurrence_all/VegBIEN.csv
1
FIA,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Filter; Comments,Comments
2
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",
3
subplotID,"/location/_if[@name=""if subplot""]/cond/_exists",
4
locationName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1",
5
locationID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists",
6
authorEventCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/else",
7
locationID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode",
8
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
9
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
10
subplot,/location/authorlocationcode,
11
individualObservationID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
12
cultivated,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_first/1",
13
oldGrowth,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/else/_first/2/_not/value",
14
subplot,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
15
subplotID,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
16
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
17
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
18
subplotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/1",
19
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/cond/_first/2",
20
locationName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then",
21
subplotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/1",
22
subplot,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/cond/_first/2",
23
locationID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then",
24
authorEventCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/authoreventcode",
25
communityID,/location/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
26
communityName,/location/locationevent/commclass/commdetermination/*_id/commconcept/commdescription,
27
individualCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,
28
individualObservationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode/_first/1,
29
diameterBreastHeight_in,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_in_to_m/value,
30
height_ft,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m/_ft_to_m/value,
31
authorEventCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
32
locationID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
33
locationName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
34
individualObservationID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",
35
individualCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1",
36
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
37
taxonName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
38
individualObservationID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
39
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_first/1",
40
oldGrowth,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/then/_first/2/_not/value",
41
individualObservationID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else/_first/1",
42
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet",
43
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet",
44
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet",
45
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
46
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
47
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
48
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,
49
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1,
50
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1,
51
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2/_filter_genus/value,
52
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1,
53
subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4,
54
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2",
55
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2",
56
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
57
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus,
58
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet,
59
taxonName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,
60
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname,
61
decimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
62
decimalLongitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value",
63
county,/location/locationplace/*_id/place/county,
64
decimalLatitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/latitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
65
decimalLongitude,"/location/locationplace/*_id/place/matched_place_id/place:[.,source_id/source/shortname=geoscrub]/*_id/coordinates:[source_id/source/shortname=geoscrub]/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value",""".,"" sorts it with other coordinates mappings"
66
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
67
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
68
stateProvince,/location/locationplace/*_id/place/stateprovince,
69
slopeAspect,/location/slopeaspect_deg/_alt/1/_compass/value,
70
slopeGradient,/location/slopegradient_fraction/_alt/1,
71
subplotID,/location/sourceaccessioncode/_first/1,
72
locationID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists",
73
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
74
locationID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
75
subplot,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
76
*BOLEHT,,** No join mapping for *BOLEHT ** 
77
*COND-ADFORCD,,** No join mapping for *COND-ADFORCD ** 
78
*COND-ADMIN_WITHDRAWN_CD,,** No join mapping for *COND-ADMIN_WITHDRAWN_CD ** 
79
*COND-ALSTK,,** No join mapping for *COND-ALSTK ** 
80
*COND-ALSTKCD,,** No join mapping for *COND-ALSTKCD ** 
81
*COND-BALIVE,,** No join mapping for *COND-BALIVE ** 
82
*COND-CANOPY_CVR_SAMPLE_METHOD_CD,,** No join mapping for *COND-CANOPY_CVR_SAMPLE_METHOD_CD ** 
83
*COND-CARBON_DOWN_DEAD,,** No join mapping for *COND-CARBON_DOWN_DEAD ** 
84
*COND-CARBON_LITTER,,** No join mapping for *COND-CARBON_LITTER ** 
85
*COND-CARBON_SOIL_ORG,,** No join mapping for *COND-CARBON_SOIL_ORG ** 
86
*COND-CARBON_STANDING_DEAD,,** No join mapping for *COND-CARBON_STANDING_DEAD ** 
87
*COND-CARBON_UNDERSTORY_AG,,** No join mapping for *COND-CARBON_UNDERSTORY_AG ** 
88
*COND-CARBON_UNDERSTORY_BG,,** No join mapping for *COND-CARBON_UNDERSTORY_BG ** 
89
*COND-CN,,** No join mapping for *COND-CN ** 
90
*COND-CONDPROP_UNADJ,,** No join mapping for *COND-CONDPROP_UNADJ ** 
91
*COND-COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND-COND_NONSAMPLE_REASN_CD ** 
92
*COND-COND_STATUS_CD,,** No join mapping for *COND-COND_STATUS_CD ** 
93
*COND-CREATED_BY,,** No join mapping for *COND-CREATED_BY ** 
94
*COND-CREATED_DATE,,** No join mapping for *COND-CREATED_DATE ** 
95
*COND-CREATED_IN_INSTANCE,,** No join mapping for *COND-CREATED_IN_INSTANCE ** 
96
*COND-CYCLE,,** No join mapping for *COND-CYCLE ** 
97
*COND-DSTRBCD1,,** No join mapping for *COND-DSTRBCD1 ** 
98
*COND-DSTRBCD2,,** No join mapping for *COND-DSTRBCD2 ** 
99
*COND-DSTRBCD3,,** No join mapping for *COND-DSTRBCD3 ** 
100
*COND-DSTRBYR1,,** No join mapping for *COND-DSTRBYR1 ** 
101
*COND-DSTRBYR2,,** No join mapping for *COND-DSTRBYR2 ** 
102
*COND-DSTRBYR3,,** No join mapping for *COND-DSTRBYR3 ** 
103
*COND-FIRE_SRS,,** No join mapping for *COND-FIRE_SRS ** 
104
*COND-FLDAGE,,** No join mapping for *COND-FLDAGE ** 
105
*COND-FLDSZCD,,** No join mapping for *COND-FLDSZCD ** 
106
*COND-FLDTYPCD,,** No join mapping for *COND-FLDTYPCD ** 
107
*COND-FORINDCD,,** No join mapping for *COND-FORINDCD ** 
108
*COND-FORTYPCD,,** No join mapping for *COND-FORTYPCD ** 
109
*COND-FORTYPCDCALC,,** No join mapping for *COND-FORTYPCDCALC ** 
110
*COND-GRAZING_SRS,,** No join mapping for *COND-GRAZING_SRS ** 
111
*COND-GROUND_LAND_CLASS_PNW,,** No join mapping for *COND-GROUND_LAND_CLASS_PNW ** 
112
*COND-GSSTK,,** No join mapping for *COND-GSSTK ** 
113
*COND-GSSTKCD,,** No join mapping for *COND-GSSTKCD ** 
114
*COND-HABTYPCD1_DESCR_PUB_CD,,** No join mapping for *COND-HABTYPCD1_DESCR_PUB_CD ** 
115
*COND-HABTYPCD2,,** No join mapping for *COND-HABTYPCD2 ** 
116
*COND-HABTYPCD2_DESCR_PUB_CD,,** No join mapping for *COND-HABTYPCD2_DESCR_PUB_CD ** 
117
*COND-HABTYPCD2_PUB_CD,,** No join mapping for *COND-HABTYPCD2_PUB_CD ** 
118
*COND-HARVEST_TYPE1_SRS,,** No join mapping for *COND-HARVEST_TYPE1_SRS ** 
119
*COND-HARVEST_TYPE2_SRS,,** No join mapping for *COND-HARVEST_TYPE2_SRS ** 
120
*COND-HARVEST_TYPE3_SRS,,** No join mapping for *COND-HARVEST_TYPE3_SRS ** 
121
*COND-INDUSTRIALCD_FIADB,,** No join mapping for *COND-INDUSTRIALCD_FIADB ** 
122
*COND-LAND_USE_SRS,,** No join mapping for *COND-LAND_USE_SRS ** 
123
*COND-LIVE_CANOPY_CVR_PCT,,** No join mapping for *COND-LIVE_CANOPY_CVR_PCT ** 
124
*COND-LIVE_MISSING_CANOPY_CVR_PCT,,** No join mapping for *COND-LIVE_MISSING_CANOPY_CVR_PCT ** 
125
*COND-MACRPROP_UNADJ,,** No join mapping for *COND-MACRPROP_UNADJ ** 
126
*COND-MAPDEN,,** No join mapping for *COND-MAPDEN ** 
127
*COND-MICRPROP_UNADJ,,** No join mapping for *COND-MICRPROP_UNADJ ** 
128
*COND-MIXEDCONFCD,,** No join mapping for *COND-MIXEDCONFCD ** 
129
*COND-MODIFIED_BY,,** No join mapping for *COND-MODIFIED_BY ** 
130
*COND-MODIFIED_DATE,,** No join mapping for *COND-MODIFIED_DATE ** 
131
*COND-MODIFIED_IN_INSTANCE,,** No join mapping for *COND-MODIFIED_IN_INSTANCE ** 
132
*COND-NBR_LIVE_STEMS,,** No join mapping for *COND-NBR_LIVE_STEMS ** 
133
*COND-NF_COND_NONSAMPLE_REASN_CD,,** No join mapping for *COND-NF_COND_NONSAMPLE_REASN_CD ** 
134
*COND-NF_COND_STATUS_CD,,** No join mapping for *COND-NF_COND_STATUS_CD ** 
135
*COND-OPERABILITY_SRS,,** No join mapping for *COND-OPERABILITY_SRS ** 
136
*COND-OWNCD,,** No join mapping for *COND-OWNCD ** 
137
*COND-OWNGRPCD,,** No join mapping for *COND-OWNGRPCD ** 
138
*COND-OWNSUBCD,,** No join mapping for *COND-OWNSUBCD ** 
139
*COND-PHYSCLCD,,** No join mapping for *COND-PHYSCLCD ** 
140
*COND-PLANT_STOCKABILITY_FACTOR_PNW,,** No join mapping for *COND-PLANT_STOCKABILITY_FACTOR_PNW ** 
141
*COND-PLT_CN,,** No join mapping for *COND-PLT_CN ** 
142
*COND-PRESNFCD,,** No join mapping for *COND-PRESNFCD ** 
143
*COND-PROP_BASIS,,** No join mapping for *COND-PROP_BASIS ** 
144
*COND-RESERVCD,,** No join mapping for *COND-RESERVCD ** 
145
*COND-RESERVCD_FLD,,** No join mapping for *COND-RESERVCD_FLD ** 
146
*COND-SIBASE,,** No join mapping for *COND-SIBASE ** 
147
*COND-SICOND,,** No join mapping for *COND-SICOND ** 
148
*COND-SISP,,** No join mapping for *COND-SISP ** 
149
*COND-SITECLCD,,** No join mapping for *COND-SITECLCD ** 
150
*COND-SITECLCDEST,,** No join mapping for *COND-SITECLCDEST ** 
151
*COND-SITECL_METHOD,,** No join mapping for *COND-SITECL_METHOD ** 
152
*COND-SITETREE_TREE,,** No join mapping for *COND-SITETREE_TREE ** 
153
*COND-SOIL_ROOTING_DEPTH_PNW,,** No join mapping for *COND-SOIL_ROOTING_DEPTH_PNW ** 
154
*COND-STAND_STRUCTURE_SRS,,** No join mapping for *COND-STAND_STRUCTURE_SRS ** 
155
*COND-STDAGE,,** No join mapping for *COND-STDAGE ** 
156
*COND-STDORGCD,,** No join mapping for *COND-STDORGCD ** 
157
*COND-STDORGSP,,** No join mapping for *COND-STDORGSP ** 
158
*COND-STDSZCD,,** No join mapping for *COND-STDSZCD ** 
159
*COND-STND_COND_CD_PNWRS,,** No join mapping for *COND-STND_COND_CD_PNWRS ** 
160
*COND-STND_STRUC_CD_PNWRS,,** No join mapping for *COND-STND_STRUC_CD_PNWRS ** 
161
*COND-STUMP_CD_PNWRS,,** No join mapping for *COND-STUMP_CD_PNWRS ** 
162
*COND-SUBCYCLE,,** No join mapping for *COND-SUBCYCLE ** 
163
*COND-SUBPPROP_UNADJ,,** No join mapping for *COND-SUBPPROP_UNADJ ** 
164
*COND-TRTCD1,,** No join mapping for *COND-TRTCD1 ** 
165
*COND-TRTCD2,,** No join mapping for *COND-TRTCD2 ** 
166
*COND-TRTCD3,,** No join mapping for *COND-TRTCD3 ** 
167
*COND-TRTYR1,,** No join mapping for *COND-TRTYR1 ** 
168
*COND-TRTYR2,,** No join mapping for *COND-TRTYR2 ** 
169
*COND-TRTYR3,,** No join mapping for *COND-TRTYR3 ** 
170
*COND-VOL_LOC_GRP,,** No join mapping for *COND-VOL_LOC_GRP ** 
171
*COND-row_num,,** No join mapping for *COND-row_num ** 
172
*COUNTY-CN,,** No join mapping for *COUNTY-CN ** 
173
*COUNTY-CREATED_BY,,** No join mapping for *COUNTY-CREATED_BY ** 
174
*COUNTY-CREATED_DATE,,** No join mapping for *COUNTY-CREATED_DATE ** 
175
*COUNTY-CREATED_IN_INSTANCE,,** No join mapping for *COUNTY-CREATED_IN_INSTANCE ** 
176
*COUNTY-MODIFIED_BY,,** No join mapping for *COUNTY-MODIFIED_BY ** 
177
*COUNTY-MODIFIED_DATE,,** No join mapping for *COUNTY-MODIFIED_DATE ** 
178
*COUNTY-MODIFIED_IN_INSTANCE,,** No join mapping for *COUNTY-MODIFIED_IN_INSTANCE ** 
179
*COUNTY-row_num,,** No join mapping for *COUNTY-row_num ** 
180
*COUNTYCD,,** No join mapping for *COUNTYCD ** 
181
*F_PREFIX,,** No join mapping for *F_PREFIX ** 
182
*GENERA_BINOMIAL_AUTHOR,,** No join mapping for *GENERA_BINOMIAL_AUTHOR ** 
183
*HABTYPCD,,** No join mapping for *HABTYPCD ** 
184
*HABTYP_PUB_CD,,** No join mapping for *HABTYP_PUB_CD ** 
185
*INVYR,,** No join mapping for *INVYR ** 
186
*PLANT_SYMBOL,,** No join mapping for *PLANT_SYMBOL ** 
187
*PLANT_SYMBOL_TYPE,,** No join mapping for *PLANT_SYMBOL_TYPE ** 
188
*PLOT-CONGCD,,** No join mapping for *PLOT-CONGCD ** 
189
*PLOT-CREATED_BY,,** No join mapping for *PLOT-CREATED_BY ** 
190
*PLOT-CREATED_DATE,,** No join mapping for *PLOT-CREATED_DATE ** 
191
*PLOT-CREATED_IN_INSTANCE,,** No join mapping for *PLOT-CREATED_IN_INSTANCE ** 
192
*PLOT-CTY_CN,,** No join mapping for *PLOT-CTY_CN ** 
193
*PLOT-CYCLE,,** No join mapping for *PLOT-CYCLE ** 
194
*PLOT-DECLINATION,,** No join mapping for *PLOT-DECLINATION ** 
195
*PLOT-DESIGNCD,,** No join mapping for *PLOT-DESIGNCD ** 
196
*PLOT-DESIGNCD_P2A,,** No join mapping for *PLOT-DESIGNCD_P2A ** 
197
*PLOT-ECOSUBCD,,** No join mapping for *PLOT-ECOSUBCD ** 
198
*PLOT-ECO_UNIT_PNW,,** No join mapping for *PLOT-ECO_UNIT_PNW ** 
199
*PLOT-EMAP_HEX,,** No join mapping for *PLOT-EMAP_HEX ** 
200
*PLOT-GROW_TYP_CD,,** No join mapping for *PLOT-GROW_TYP_CD ** 
201
*PLOT-INTENSITY,,** No join mapping for *PLOT-INTENSITY ** 
202
*PLOT-INVASIVE_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-INVASIVE_SAMPLING_STATUS_CD ** 
203
*PLOT-INVASIVE_SPECIMEN_RULE_CD,,** No join mapping for *PLOT-INVASIVE_SPECIMEN_RULE_CD ** 
204
*PLOT-KINDCD,,** No join mapping for *PLOT-KINDCD ** 
205
*PLOT-KINDCD_NC,,** No join mapping for *PLOT-KINDCD_NC ** 
206
*PLOT-MACRO_BREAKPOINT_DIA,,** No join mapping for *PLOT-MACRO_BREAKPOINT_DIA ** 
207
*PLOT-MANUAL,,** No join mapping for *PLOT-MANUAL ** 
208
*PLOT-MICROPLOT_LOC,,** No join mapping for *PLOT-MICROPLOT_LOC ** 
209
*PLOT-MODIFIED_BY,,** No join mapping for *PLOT-MODIFIED_BY ** 
210
*PLOT-MODIFIED_DATE,,** No join mapping for *PLOT-MODIFIED_DATE ** 
211
*PLOT-MODIFIED_IN_INSTANCE,,** No join mapping for *PLOT-MODIFIED_IN_INSTANCE ** 
212
*PLOT-MORT_TYP_CD,,** No join mapping for *PLOT-MORT_TYP_CD ** 
213
*PLOT-NF_PLOT_NONSAMPLE_REASN_CD,,** No join mapping for *PLOT-NF_PLOT_NONSAMPLE_REASN_CD ** 
214
*PLOT-NF_PLOT_STATUS_CD,,** No join mapping for *PLOT-NF_PLOT_STATUS_CD ** 
215
*PLOT-NF_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-NF_SAMPLING_STATUS_CD ** 
216
*PLOT-P2PANEL,,** No join mapping for *PLOT-P2PANEL ** 
217
*PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD,,** No join mapping for *PLOT-P2VEG_SAMPLING_LEVEL_DETAIL_CD ** 
218
*PLOT-P2VEG_SAMPLING_STATUS_CD,,** No join mapping for *PLOT-P2VEG_SAMPLING_STATUS_CD ** 
219
*PLOT-P3PANEL,,** No join mapping for *PLOT-P3PANEL ** 
220
*PLOT-PLOT_NONSAMPLE_REASN_CD,,** No join mapping for *PLOT-PLOT_NONSAMPLE_REASN_CD ** 
221
*PLOT-PLOT_STATUS_CD,,** No join mapping for *PLOT-PLOT_STATUS_CD ** 
222
*PLOT-PREV_PLT_CN,,** No join mapping for *PLOT-PREV_PLT_CN ** 
223
*PLOT-QA_STATUS,,** No join mapping for *PLOT-QA_STATUS ** 
224
*PLOT-RDDISTCD,,** No join mapping for *PLOT-RDDISTCD ** 
225
*PLOT-REMPER,,** No join mapping for *PLOT-REMPER ** 
226
*PLOT-SAMP_METHOD_CD,,** No join mapping for *PLOT-SAMP_METHOD_CD ** 
227
*PLOT-SRV_CN,,** No join mapping for *PLOT-SRV_CN ** 
228
*PLOT-SUBCYCLE,,** No join mapping for *PLOT-SUBCYCLE ** 
229
*PLOT-SUBPANEL,,** No join mapping for *PLOT-SUBPANEL ** 
230
*PLOT-SUBP_EXAMINE_CD,,** No join mapping for *PLOT-SUBP_EXAMINE_CD ** 
231
*PLOT-TOPO_POSITION_PNW,,** No join mapping for *PLOT-TOPO_POSITION_PNW ** 
232
*PLOT-WATERCD,,** No join mapping for *PLOT-WATERCD ** 
233
*PLOT-row_num,,** No join mapping for *PLOT-row_num ** 
234
*QUADRINOMIAL_AUTHOR,,** No join mapping for *QUADRINOMIAL_AUTHOR ** 
235
*REF_HABTYP_DESCRIPTION-CREATED_BY,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_BY ** 
236
*REF_HABTYP_DESCRIPTION-CREATED_DATE,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_DATE ** 
237
*REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE,,** No join mapping for *REF_HABTYP_DESCRIPTION-CREATED_IN_INSTANCE ** 
238
*REF_HABTYP_DESCRIPTION-MODIFIED_BY,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_BY ** 
239
*REF_HABTYP_DESCRIPTION-MODIFIED_DATE,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_DATE ** 
240
*REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_HABTYP_DESCRIPTION-MODIFIED_IN_INSTANCE ** 
241
*REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME,,** No join mapping for *REF_HABTYP_DESCRIPTION-SCIENTIFIC_NAME ** 
242
*REF_HABTYP_DESCRIPTION-VALID,,** No join mapping for *REF_HABTYP_DESCRIPTION-VALID ** 
243
*REF_HABTYP_DESCRIPTION-row_num,,** No join mapping for *REF_HABTYP_DESCRIPTION-row_num ** 
244
*REF_PLANT_DICTIONARY-CATEGORY,,** No join mapping for *REF_PLANT_DICTIONARY-CATEGORY ** 
245
*REF_PLANT_DICTIONARY-CN,,** No join mapping for *REF_PLANT_DICTIONARY-CN ** 
246
*REF_PLANT_DICTIONARY-CREATED_BY,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_BY ** 
247
*REF_PLANT_DICTIONARY-CREATED_DATE,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_DATE ** 
248
*REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE,,** No join mapping for *REF_PLANT_DICTIONARY-CREATED_IN_INSTANCE ** 
249
*REF_PLANT_DICTIONARY-DURATION,,** No join mapping for *REF_PLANT_DICTIONARY-DURATION ** 
250
*REF_PLANT_DICTIONARY-MODIFIED_BY,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_BY ** 
251
*REF_PLANT_DICTIONARY-MODIFIED_DATE,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_DATE ** 
252
*REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_PLANT_DICTIONARY-MODIFIED_IN_INSTANCE ** 
253
*REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME,,** No join mapping for *REF_PLANT_DICTIONARY-NEW_SCIENTIFIC_NAME ** 
254
*REF_PLANT_DICTIONARY-NEW_SYMBOL,,** No join mapping for *REF_PLANT_DICTIONARY-NEW_SYMBOL ** 
255
*REF_PLANT_DICTIONARY-NOTES,,** No join mapping for *REF_PLANT_DICTIONARY-NOTES ** 
256
*REF_PLANT_DICTIONARY-STATE_AND_PROVINCE,,** No join mapping for *REF_PLANT_DICTIONARY-STATE_AND_PROVINCE ** 
257
*REF_PLANT_DICTIONARY-STATE_DISTRIBUTION,,** No join mapping for *REF_PLANT_DICTIONARY-STATE_DISTRIBUTION ** 
258
*REF_PLANT_DICTIONARY-US_NATIVITY,,** No join mapping for *REF_PLANT_DICTIONARY-US_NATIVITY ** 
259
*REF_PLANT_DICTIONARY-row_num,,** No join mapping for *REF_PLANT_DICTIONARY-row_num ** 
260
*REF_RESEARCH_STATION-CREATED_BY,,** No join mapping for *REF_RESEARCH_STATION-CREATED_BY ** 
261
*REF_RESEARCH_STATION-CREATED_DATE,,** No join mapping for *REF_RESEARCH_STATION-CREATED_DATE ** 
262
*REF_RESEARCH_STATION-CREATED_IN_INSTANCE,,** No join mapping for *REF_RESEARCH_STATION-CREATED_IN_INSTANCE ** 
263
*REF_RESEARCH_STATION-MODIFIED_BY,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_BY ** 
264
*REF_RESEARCH_STATION-MODIFIED_DATE,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_DATE ** 
265
*REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_RESEARCH_STATION-MODIFIED_IN_INSTANCE ** 
266
*REF_RESEARCH_STATION-RS,,** No join mapping for *REF_RESEARCH_STATION-RS ** 
267
*REF_RESEARCH_STATION-RSCD,,** No join mapping for *REF_RESEARCH_STATION-RSCD ** 
268
*REF_RESEARCH_STATION-STATE_ABBR,,** No join mapping for *REF_RESEARCH_STATION-STATE_ABBR ** 
269
*REF_RESEARCH_STATION-row_num,,** No join mapping for *REF_RESEARCH_STATION-row_num ** 
270
*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT,,** No join mapping for *REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT ** 
271
*REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-BARK_SPGR_GREENVOL_DRYWT_CIT ** 
272
*REF_SPECIES-BARK_VOL_PCT,,** No join mapping for *REF_SPECIES-BARK_VOL_PCT ** 
273
*REF_SPECIES-BARK_VOL_PCT_CIT,,** No join mapping for *REF_SPECIES-BARK_VOL_PCT_CIT ** 
274
*REF_SPECIES-CARIBBEAN,,** No join mapping for *REF_SPECIES-CARIBBEAN ** 
275
*REF_SPECIES-COMMON_NAME,,** No join mapping for *REF_SPECIES-COMMON_NAME ** 
276
*REF_SPECIES-CORE,,** No join mapping for *REF_SPECIES-CORE ** 
277
*REF_SPECIES-CREATED_BY,,** No join mapping for *REF_SPECIES-CREATED_BY ** 
278
*REF_SPECIES-CREATED_DATE,,** No join mapping for *REF_SPECIES-CREATED_DATE ** 
279
*REF_SPECIES-CREATED_IN_INSTANCE,,** No join mapping for *REF_SPECIES-CREATED_IN_INSTANCE ** 
280
*REF_SPECIES-CWD_DECAY_RATIO1,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO1 ** 
281
*REF_SPECIES-CWD_DECAY_RATIO2,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO2 ** 
282
*REF_SPECIES-CWD_DECAY_RATIO3,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO3 ** 
283
*REF_SPECIES-CWD_DECAY_RATIO4,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO4 ** 
284
*REF_SPECIES-CWD_DECAY_RATIO5,,** No join mapping for *REF_SPECIES-CWD_DECAY_RATIO5 ** 
285
*REF_SPECIES-C_SPGRPCD,,** No join mapping for *REF_SPECIES-C_SPGRPCD ** 
286
*REF_SPECIES-DWM_CARBON_RATIO,,** No join mapping for *REF_SPECIES-DWM_CARBON_RATIO ** 
287
*REF_SPECIES-EAST,,** No join mapping for *REF_SPECIES-EAST ** 
288
*REF_SPECIES-EXISTS_IN_NCRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_NCRS ** 
289
*REF_SPECIES-EXISTS_IN_NERS,,** No join mapping for *REF_SPECIES-EXISTS_IN_NERS ** 
290
*REF_SPECIES-EXISTS_IN_PNWRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_PNWRS ** 
291
*REF_SPECIES-EXISTS_IN_RMRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_RMRS ** 
292
*REF_SPECIES-EXISTS_IN_SRS,,** No join mapping for *REF_SPECIES-EXISTS_IN_SRS ** 
293
*REF_SPECIES-E_SPGRPCD,,** No join mapping for *REF_SPECIES-E_SPGRPCD ** 
294
*REF_SPECIES-FOREST_TYPE_SPGRPCD,,** No join mapping for *REF_SPECIES-FOREST_TYPE_SPGRPCD ** 
295
*REF_SPECIES-GENUS,,** No join mapping for *REF_SPECIES-GENUS ** 
296
*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_FOLIAGE_RATIO_B1 ** 
297
*REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_FOLIAGE_RATIO_B2 ** 
298
*REF_SPECIES-JENKINS_ROOT_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_ROOT_RATIO_B1 ** 
299
*REF_SPECIES-JENKINS_ROOT_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_ROOT_RATIO_B2 ** 
300
*REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT,,** No join mapping for *REF_SPECIES-JENKINS_SAPLING_ADJUSTMENT ** 
301
*REF_SPECIES-JENKINS_SPGRPCD,,** No join mapping for *REF_SPECIES-JENKINS_SPGRPCD ** 
302
*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_STEM_BARK_RATIO_B1 ** 
303
*REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_STEM_BARK_RATIO_B2 ** 
304
*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1,,** No join mapping for *REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B1 ** 
305
*REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2,,** No join mapping for *REF_SPECIES-JENKINS_STEM_WOOD_RATIO_B2 ** 
306
*REF_SPECIES-JENKINS_TOTAL_B1,,** No join mapping for *REF_SPECIES-JENKINS_TOTAL_B1 ** 
307
*REF_SPECIES-JENKINS_TOTAL_B2,,** No join mapping for *REF_SPECIES-JENKINS_TOTAL_B2 ** 
308
*REF_SPECIES-MAJOR_SPGRPCD,,** No join mapping for *REF_SPECIES-MAJOR_SPGRPCD ** 
309
*REF_SPECIES-MANUAL_END,,** No join mapping for *REF_SPECIES-MANUAL_END ** 
310
*REF_SPECIES-MANUAL_START,,** No join mapping for *REF_SPECIES-MANUAL_START ** 
311
*REF_SPECIES-MC_PCT_GREEN_BARK,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_BARK ** 
312
*REF_SPECIES-MC_PCT_GREEN_BARK_CIT,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_BARK_CIT ** 
313
*REF_SPECIES-MC_PCT_GREEN_WOOD,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_WOOD ** 
314
*REF_SPECIES-MC_PCT_GREEN_WOOD_CIT,,** No join mapping for *REF_SPECIES-MC_PCT_GREEN_WOOD_CIT ** 
315
*REF_SPECIES-MODIFIED_BY,,** No join mapping for *REF_SPECIES-MODIFIED_BY ** 
316
*REF_SPECIES-MODIFIED_DATE,,** No join mapping for *REF_SPECIES-MODIFIED_DATE ** 
317
*REF_SPECIES-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_SPECIES-MODIFIED_IN_INSTANCE ** 
318
*REF_SPECIES-PACIFIC,,** No join mapping for *REF_SPECIES-PACIFIC ** 
319
*REF_SPECIES-P_SPGRPCD,,** No join mapping for *REF_SPECIES-P_SPGRPCD ** 
320
*REF_SPECIES-RAILE_STUMP_DIB_B1,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DIB_B1 ** 
321
*REF_SPECIES-RAILE_STUMP_DIB_B2,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DIB_B2 ** 
322
*REF_SPECIES-RAILE_STUMP_DOB_B1,,** No join mapping for *REF_SPECIES-RAILE_STUMP_DOB_B1 ** 
323
*REF_SPECIES-SFTWD_HRDWD,,** No join mapping for *REF_SPECIES-SFTWD_HRDWD ** 
324
*REF_SPECIES-SITETREE,,** No join mapping for *REF_SPECIES-SITETREE ** 
325
*REF_SPECIES-SPECIES,,** No join mapping for *REF_SPECIES-SPECIES ** 
326
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO1,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO1 ** 
327
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO2,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO2 ** 
328
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO3,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO3 ** 
329
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO4,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO4 ** 
330
*REF_SPECIES-STANDING_DEAD_DECAY_RATIO5,,** No join mapping for *REF_SPECIES-STANDING_DEAD_DECAY_RATIO5 ** 
331
*REF_SPECIES-STOCKING_SPGRPCD,,** No join mapping for *REF_SPECIES-STOCKING_SPGRPCD ** 
332
*REF_SPECIES-ST_EXISTS_IN_NCRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_NCRS ** 
333
*REF_SPECIES-ST_EXISTS_IN_NERS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_NERS ** 
334
*REF_SPECIES-ST_EXISTS_IN_PNWRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_PNWRS ** 
335
*REF_SPECIES-ST_EXISTS_IN_RMRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_RMRS ** 
336
*REF_SPECIES-ST_EXISTS_IN_SRS,,** No join mapping for *REF_SPECIES-ST_EXISTS_IN_SRS ** 
337
*REF_SPECIES-SUBSPECIES,,** No join mapping for *REF_SPECIES-SUBSPECIES ** 
338
*REF_SPECIES-VARIETY,,** No join mapping for *REF_SPECIES-VARIETY ** 
339
*REF_SPECIES-WEST,,** No join mapping for *REF_SPECIES-WEST ** 
340
*REF_SPECIES-WOODLAND,,** No join mapping for *REF_SPECIES-WOODLAND ** 
341
*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT ** 
342
*REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_GREENVOL_DRYWT_CIT ** 
343
*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT ** 
344
*REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT,,** No join mapping for *REF_SPECIES-WOOD_SPGR_MC12VOL_DRYWT_CIT ** 
345
*REF_SPECIES-W_SPGRPCD,,** No join mapping for *REF_SPECIES-W_SPGRPCD ** 
346
*REF_SPECIES-row_num,,** No join mapping for *REF_SPECIES-row_num ** 
347
*REF_UNIT-CREATED_BY,,** No join mapping for *REF_UNIT-CREATED_BY ** 
348
*REF_UNIT-CREATED_DATE,,** No join mapping for *REF_UNIT-CREATED_DATE ** 
349
*REF_UNIT-CREATED_IN_INSTANCE,,** No join mapping for *REF_UNIT-CREATED_IN_INSTANCE ** 
350
*REF_UNIT-MEANING,,** No join mapping for *REF_UNIT-MEANING ** 
351
*REF_UNIT-MODIFIED_BY,,** No join mapping for *REF_UNIT-MODIFIED_BY ** 
352
*REF_UNIT-MODIFIED_DATE,,** No join mapping for *REF_UNIT-MODIFIED_DATE ** 
353
*REF_UNIT-MODIFIED_IN_INSTANCE,,** No join mapping for *REF_UNIT-MODIFIED_IN_INSTANCE ** 
354
*REF_UNIT-row_num,,** No join mapping for *REF_UNIT-row_num ** 
355
*SPCD,,** No join mapping for *SPCD ** 
356
*SSP_PREFIX,,** No join mapping for *SSP_PREFIX ** 
357
*STATECD,,** No join mapping for *STATECD ** 
358
*SUBPLOT-ASPECT,,** No join mapping for *SUBPLOT-ASPECT ** 
359
*SUBPLOT-CONDLIST,,** No join mapping for *SUBPLOT-CONDLIST ** 
360
*SUBPLOT-CREATED_BY,,** No join mapping for *SUBPLOT-CREATED_BY ** 
361
*SUBPLOT-CREATED_DATE,,** No join mapping for *SUBPLOT-CREATED_DATE ** 
362
*SUBPLOT-CREATED_IN_INSTANCE,,** No join mapping for *SUBPLOT-CREATED_IN_INSTANCE ** 
363
*SUBPLOT-CYCLE,,** No join mapping for *SUBPLOT-CYCLE ** 
364
*SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-INVASIVE_NONSAMPLE_REASN_CD ** 
365
*SUBPLOT-INVASIVE_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-INVASIVE_SUBP_STATUS_CD ** 
366
*SUBPLOT-MACRCOND,,** No join mapping for *SUBPLOT-MACRCOND ** 
367
*SUBPLOT-MICRCOND,,** No join mapping for *SUBPLOT-MICRCOND ** 
368
*SUBPLOT-MODIFIED_BY,,** No join mapping for *SUBPLOT-MODIFIED_BY ** 
369
*SUBPLOT-MODIFIED_DATE,,** No join mapping for *SUBPLOT-MODIFIED_DATE ** 
370
*SUBPLOT-MODIFIED_IN_INSTANCE,,** No join mapping for *SUBPLOT-MODIFIED_IN_INSTANCE ** 
371
*SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-NF_SUBP_NONSAMPLE_REASN_CD ** 
372
*SUBPLOT-NF_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-NF_SUBP_STATUS_CD ** 
373
*SUBPLOT-P2A_GRM_FLG,,** No join mapping for *SUBPLOT-P2A_GRM_FLG ** 
374
*SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-P2VEG_SUBP_NONSAMPLE_REASN_CD ** 
375
*SUBPLOT-P2VEG_SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-P2VEG_SUBP_STATUS_CD ** 
376
*SUBPLOT-PLT_CN,,** No join mapping for *SUBPLOT-PLT_CN ** 
377
*SUBPLOT-POINT_NONSAMPLE_REASN_CD,,** No join mapping for *SUBPLOT-POINT_NONSAMPLE_REASN_CD ** 
378
*SUBPLOT-PREV_SBP_CN,,** No join mapping for *SUBPLOT-PREV_SBP_CN ** 
379
*SUBPLOT-ROOT_DIS_SEV_CD_PNWRS,,** No join mapping for *SUBPLOT-ROOT_DIS_SEV_CD_PNWRS ** 
380
*SUBPLOT-SLOPE,,** No join mapping for *SUBPLOT-SLOPE ** 
381
*SUBPLOT-SUBCYCLE,,** No join mapping for *SUBPLOT-SUBCYCLE ** 
382
*SUBPLOT-SUBPCOND,,** No join mapping for *SUBPLOT-SUBPCOND ** 
383
*SUBPLOT-SUBP_STATUS_CD,,** No join mapping for *SUBPLOT-SUBP_STATUS_CD ** 
384
*SUBPLOT-WATERDEP,,** No join mapping for *SUBPLOT-WATERDEP ** 
385
*SUBPLOT-row_num,,** No join mapping for *SUBPLOT-row_num ** 
386
*SUBVAR,,** No join mapping for *SUBVAR ** 
387
*SUBVARIETY,,** No join mapping for *SUBVARIETY ** 
388
*TREE-ACTUALHT,,** No join mapping for *TREE-ACTUALHT ** 
389
*TREE-AGENTCD,,** No join mapping for *TREE-AGENTCD ** 
390
*TREE-AZIMUTH,,** No join mapping for *TREE-AZIMUTH ** 
391
*TREE-BFSND,,** No join mapping for *TREE-BFSND ** 
392
*TREE-BHAGE,,** No join mapping for *TREE-BHAGE ** 
393
*TREE-BORED_CD_PNWRS,,** No join mapping for *TREE-BORED_CD_PNWRS ** 
394
*TREE-CARBON_AG,,** No join mapping for *TREE-CARBON_AG ** 
395
*TREE-CARBON_BG,,** No join mapping for *TREE-CARBON_BG ** 
396
*TREE-CCLCD,,** No join mapping for *TREE-CCLCD ** 
397
*TREE-CDENCD,,** No join mapping for *TREE-CDENCD ** 
398
*TREE-CDIEBKCD,,** No join mapping for *TREE-CDIEBKCD ** 
399
*TREE-CFSND,,** No join mapping for *TREE-CFSND ** 
400
*TREE-CLIGHTCD,,** No join mapping for *TREE-CLIGHTCD ** 
401
*TREE-CPOSCD,,** No join mapping for *TREE-CPOSCD ** 
402
*TREE-CR,,** No join mapping for *TREE-CR ** 
403
*TREE-CREATED_BY,,** No join mapping for *TREE-CREATED_BY ** 
404
*TREE-CREATED_DATE,,** No join mapping for *TREE-CREATED_DATE ** 
405
*TREE-CREATED_IN_INSTANCE,,** No join mapping for *TREE-CREATED_IN_INSTANCE ** 
406
*TREE-CULL,,** No join mapping for *TREE-CULL ** 
407
*TREE-CULLBF,,** No join mapping for *TREE-CULLBF ** 
408
*TREE-CULLCF,,** No join mapping for *TREE-CULLCF ** 
409
*TREE-CULLDEAD,,** No join mapping for *TREE-CULLDEAD ** 
410
*TREE-CULLFORM,,** No join mapping for *TREE-CULLFORM ** 
411
*TREE-CULLMSTOP,,** No join mapping for *TREE-CULLMSTOP ** 
412
*TREE-CULL_FLD,,** No join mapping for *TREE-CULL_FLD ** 
413
*TREE-CVIGORCD,,** No join mapping for *TREE-CVIGORCD ** 
414
*TREE-CYCLE,,** No join mapping for *TREE-CYCLE ** 
415
*TREE-DAMLOC1,,** No join mapping for *TREE-DAMLOC1 ** 
416
*TREE-DAMLOC1_PNWRS,,** No join mapping for *TREE-DAMLOC1_PNWRS ** 
417
*TREE-DAMLOC2,,** No join mapping for *TREE-DAMLOC2 ** 
418
*TREE-DAMLOC2_PNWRS,,** No join mapping for *TREE-DAMLOC2_PNWRS ** 
419
*TREE-DAMSEV1,,** No join mapping for *TREE-DAMSEV1 ** 
420
*TREE-DAMSEV2,,** No join mapping for *TREE-DAMSEV2 ** 
421
*TREE-DAMTYP1,,** No join mapping for *TREE-DAMTYP1 ** 
422
*TREE-DAMTYP2,,** No join mapping for *TREE-DAMTYP2 ** 
423
*TREE-DECAYCD,,** No join mapping for *TREE-DECAYCD ** 
424
*TREE-DIACALC,,** No join mapping for *TREE-DIACALC ** 
425
*TREE-DIACHECK,,** No join mapping for *TREE-DIACHECK ** 
426
*TREE-DIACHECK_PNWRS,,** No join mapping for *TREE-DIACHECK_PNWRS ** 
427
*TREE-DIAHTCD,,** No join mapping for *TREE-DIAHTCD ** 
428
*TREE-DIEBACK_SEVERITY_SRS,,** No join mapping for *TREE-DIEBACK_SEVERITY_SRS ** 
429
*TREE-DISEASE_SRS,,** No join mapping for *TREE-DISEASE_SRS ** 
430
*TREE-DIST,,** No join mapping for *TREE-DIST ** 
431
*TREE-DMG_AGENT1_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT1_CD_PNWRS ** 
432
*TREE-DMG_AGENT2_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT2_CD_PNWRS ** 
433
*TREE-DMG_AGENT3_CD_PNWRS,,** No join mapping for *TREE-DMG_AGENT3_CD_PNWRS ** 
434
*TREE-DRYBIO_BG,,** No join mapping for *TREE-DRYBIO_BG ** 
435
*TREE-DRYBIO_BOLE,,** No join mapping for *TREE-DRYBIO_BOLE ** 
436
*TREE-DRYBIO_SAPLING,,** No join mapping for *TREE-DRYBIO_SAPLING ** 
437
*TREE-DRYBIO_STUMP,,** No join mapping for *TREE-DRYBIO_STUMP ** 
438
*TREE-DRYBIO_TOP,,** No join mapping for *TREE-DRYBIO_TOP ** 
439
*TREE-DRYBIO_WDLD_SPP,,** No join mapping for *TREE-DRYBIO_WDLD_SPP ** 
440
*TREE-FGROWBFSL,,** No join mapping for *TREE-FGROWBFSL ** 
441
*TREE-FGROWCFAL,,** No join mapping for *TREE-FGROWCFAL ** 
442
*TREE-FGROWCFGS,,** No join mapping for *TREE-FGROWCFGS ** 
443
*TREE-FMORTBFSL,,** No join mapping for *TREE-FMORTBFSL ** 
444
*TREE-FMORTCFAL,,** No join mapping for *TREE-FMORTCFAL ** 
445
*TREE-FMORTCFGS,,** No join mapping for *TREE-FMORTCFGS ** 
446
*TREE-FORMCL,,** No join mapping for *TREE-FORMCL ** 
447
*TREE-FREMVBFSL,,** No join mapping for *TREE-FREMVBFSL ** 
448
*TREE-FREMVCFAL,,** No join mapping for *TREE-FREMVCFAL ** 
449
*TREE-FREMVCFGS,,** No join mapping for *TREE-FREMVCFGS ** 
450
*TREE-GROWBFSL,,** No join mapping for *TREE-GROWBFSL ** 
451
*TREE-GROWCFAL,,** No join mapping for *TREE-GROWCFAL ** 
452
*TREE-GROWCFGS,,** No join mapping for *TREE-GROWCFGS ** 
453
*TREE-HRDWD_CLUMP_CD,,** No join mapping for *TREE-HRDWD_CLUMP_CD ** 
454
*TREE-HTCALC,,** No join mapping for *TREE-HTCALC ** 
455
*TREE-HTCD,,** No join mapping for *TREE-HTCD ** 
456
*TREE-HTDMP,,** No join mapping for *TREE-HTDMP ** 
457
*TREE-MIST_CL_CD,,** No join mapping for *TREE-MIST_CL_CD ** 
458
*TREE-MIST_CL_CD_PNWRS,,** No join mapping for *TREE-MIST_CL_CD_PNWRS ** 
459
*TREE-MODIFIED_BY,,** No join mapping for *TREE-MODIFIED_BY ** 
460
*TREE-MODIFIED_DATE,,** No join mapping for *TREE-MODIFIED_DATE ** 
461
*TREE-MODIFIED_IN_INSTANCE,,** No join mapping for *TREE-MODIFIED_IN_INSTANCE ** 
462
*TREE-MORTBFSL,,** No join mapping for *TREE-MORTBFSL ** 
463
*TREE-MORTCD,,** No join mapping for *TREE-MORTCD ** 
464
*TREE-MORTCFAL,,** No join mapping for *TREE-MORTCFAL ** 
465
*TREE-MORTCFGS,,** No join mapping for *TREE-MORTCFGS ** 
466
*TREE-MORTYR,,** No join mapping for *TREE-MORTYR ** 
467
*TREE-P2A_GRM_FLG,,** No join mapping for *TREE-P2A_GRM_FLG ** 
468
*TREE-PLT_CN,,** No join mapping for *TREE-PLT_CN ** 
469
*TREE-PREVCOND,,** No join mapping for *TREE-PREVCOND ** 
470
*TREE-PREVDIA,,** No join mapping for *TREE-PREVDIA ** 
471
*TREE-PREV_PNTN_SRS,,** No join mapping for *TREE-PREV_PNTN_SRS ** 
472
*TREE-PREV_STATUS_CD,,** No join mapping for *TREE-PREV_STATUS_CD ** 
473
*TREE-PREV_TRE_CN,,** No join mapping for *TREE-PREV_TRE_CN ** 
474
*TREE-PREV_WDLDSTEM,,** No join mapping for *TREE-PREV_WDLDSTEM ** 
475
*TREE-RECONCILECD,,** No join mapping for *TREE-RECONCILECD ** 
476
*TREE-REMVBFSL,,** No join mapping for *TREE-REMVBFSL ** 
477
*TREE-REMVCFAL,,** No join mapping for *TREE-REMVCFAL ** 
478
*TREE-REMVCFGS,,** No join mapping for *TREE-REMVCFGS ** 
479
*TREE-ROUGHCULL,,** No join mapping for *TREE-ROUGHCULL ** 
480
*TREE-SALVCD,,** No join mapping for *TREE-SALVCD ** 
481
*TREE-SAWHT,,** No join mapping for *TREE-SAWHT ** 
482
*TREE-SEVERITY1A_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1A_CD_PNWRS ** 
483
*TREE-SEVERITY1B_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1B_CD_PNWRS ** 
484
*TREE-SEVERITY1_CD_PNWRS,,** No join mapping for *TREE-SEVERITY1_CD_PNWRS ** 
485
*TREE-SEVERITY2A_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2A_CD_PNWRS ** 
486
*TREE-SEVERITY2B_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2B_CD_PNWRS ** 
487
*TREE-SEVERITY2_CD_PNWRS,,** No join mapping for *TREE-SEVERITY2_CD_PNWRS ** 
488
*TREE-SEVERITY3_CD_PNWRS,,** No join mapping for *TREE-SEVERITY3_CD_PNWRS ** 
489
*TREE-SITREE,,** No join mapping for *TREE-SITREE ** 
490
*TREE-SPGRPCD,,** No join mapping for *TREE-SPGRPCD ** 
491
*TREE-STANDING_DEAD_CD,,** No join mapping for *TREE-STANDING_DEAD_CD ** 
492
*TREE-STATUSCD,,** No join mapping for *TREE-STATUSCD ** 
493
*TREE-STOCKING,,** No join mapping for *TREE-STOCKING ** 
494
*TREE-SUBCYCLE,,** No join mapping for *TREE-SUBCYCLE ** 
495
*TREE-TOTAGE,,** No join mapping for *TREE-TOTAGE ** 
496
*TREE-TPAGROW_UNADJ,,** No join mapping for *TREE-TPAGROW_UNADJ ** 
497
*TREE-TPAMORT_UNADJ,,** No join mapping for *TREE-TPAMORT_UNADJ ** 
498
*TREE-TPAREMV_UNADJ,,** No join mapping for *TREE-TPAREMV_UNADJ ** 
499
*TREE-TPA_UNADJ,,** No join mapping for *TREE-TPA_UNADJ ** 
500
*TREE-TRANSCD,,** No join mapping for *TREE-TRANSCD ** 
501
*TREE-TREECLCD,,** No join mapping for *TREE-TREECLCD ** 
502
*TREE-TREECLCD_NCRS,,** No join mapping for *TREE-TREECLCD_NCRS ** 
503
*TREE-TREECLCD_NERS,,** No join mapping for *TREE-TREECLCD_NERS ** 
504
*TREE-TREECLCD_RMRS,,** No join mapping for *TREE-TREECLCD_RMRS ** 
505
*TREE-TREECLCD_SRS,,** No join mapping for *TREE-TREECLCD_SRS ** 
506
*TREE-TREEGRCD,,** No join mapping for *TREE-TREEGRCD ** 
507
*TREE-TREEHISTCD,,** No join mapping for *TREE-TREEHISTCD ** 
508
*TREE-UNCRCD,,** No join mapping for *TREE-UNCRCD ** 
509
*TREE-UNKNOWN_DAMTYP1_PNWRS,,** No join mapping for *TREE-UNKNOWN_DAMTYP1_PNWRS ** 
510
*TREE-UNKNOWN_DAMTYP2_PNWRS,,** No join mapping for *TREE-UNKNOWN_DAMTYP2_PNWRS ** 
511
*TREE-VOLBFGRS,,** No join mapping for *TREE-VOLBFGRS ** 
512
*TREE-VOLBFNET,,** No join mapping for *TREE-VOLBFNET ** 
513
*TREE-VOLCFGRS,,** No join mapping for *TREE-VOLCFGRS ** 
514
*TREE-VOLCFNET,,** No join mapping for *TREE-VOLCFNET ** 
515
*TREE-VOLCFSND,,** No join mapping for *TREE-VOLCFSND ** 
516
*TREE-VOLCSGRS,,** No join mapping for *TREE-VOLCSGRS ** 
517
*TREE-VOLCSNET,,** No join mapping for *TREE-VOLCSNET ** 
518
*TREE-WDLDSTEM,,** No join mapping for *TREE-WDLDSTEM ** 
519
*TREE-row_num,,** No join mapping for *TREE-row_num ** 
520
*TRINOMIAL_AUTHOR,,** No join mapping for *TRINOMIAL_AUTHOR ** 
521
*UNITCD,,** No join mapping for *UNITCD ** 
522
*VAR_PREFIX,,** No join mapping for *VAR_PREFIX ** 
523
*XGENUS,,** No join mapping for *XGENUS ** 
524
*XSPECIES,,** No join mapping for *XSPECIES ** 
525
*XSUBSPECIES,,** No join mapping for *XSUBSPECIES ** 
526
*XVARIETY,,** No join mapping for *XVARIETY ** 
527
day,,** No join mapping for day ** 
528
elevation_ft,,** No join mapping for elevation_ft ** 
529
month,,** No join mapping for month ** 
530
occurrence_all-row_num,,** No join mapping for occurrence_all-row_num ** 
531
taxonGrowthForm,,** No join mapping for taxonGrowthForm ** 
532
vernacularName,,** No join mapping for vernacularName ** 
533
year,,** No join mapping for year ** 
inputs/FIA/occurrence_all/unmapped_terms.csv
1
row_num
2
*STATECD
3
*UNITCD
4
*COUNTYCD
5
*INVYR
6
*HABTYPCD
7
*HABTYP_PUB_CD
8
*PLANT_SYMBOL
9
*PLANT_SYMBOL_TYPE
10
*SPCD
11
*TREE--row_num
12
*TREE--PLT_CN
13
*TREE--PREV_TRE_CN
14
*TREE--AZIMUTH
15
*TREE--DIST
16
*TREE--PREVCOND
17
*TREE--STATUSCD
18
*TREE--SPGRPCD
19
*TREE--DIAHTCD
20
*TREE--HTCD
21
*TREE--ACTUALHT
22
*TREE--TREECLCD
23
*TREE--CR
24
*TREE--CCLCD
25
*TREE--TREEGRCD
26
*TREE--AGENTCD
27
*TREE--CULL
28
*TREE--DAMLOC1
29
*TREE--DAMTYP1
30
*TREE--DAMSEV1
31
*TREE--DAMLOC2
32
*TREE--DAMTYP2
33
*TREE--DAMSEV2
34
*TREE--DECAYCD
35
*TREE--STOCKING
36
*TREE--WDLDSTEM
37
*TREE--VOLCFNET
38
*TREE--VOLCFGRS
39
*TREE--VOLCSNET
40
*TREE--VOLCSGRS
41
*TREE--VOLBFNET
42
*TREE--VOLBFGRS
43
*TREE--VOLCFSND
44
*TREE--GROWCFGS
45
*TREE--GROWBFSL
46
*TREE--GROWCFAL
47
*TREE--MORTCFGS
48
*TREE--MORTBFSL
49
*TREE--MORTCFAL
50
*TREE--REMVCFGS
51
*TREE--REMVBFSL
52
*TREE--REMVCFAL
53
*TREE--DIACHECK
54
*TREE--MORTYR
55
*TREE--SALVCD
56
*TREE--UNCRCD
57
*TREE--CPOSCD
58
*TREE--CLIGHTCD
59
*TREE--CVIGORCD
60
*TREE--CDENCD
61
*TREE--CDIEBKCD
62
*TREE--TRANSCD
63
*TREE--TREEHISTCD
64
*TREE--DIACALC
65
*TREE--BHAGE
66
*TREE--TOTAGE
67
*TREE--CULLDEAD
68
*TREE--CULLFORM
69
*TREE--CULLMSTOP
70
*TREE--CULLBF
71
*TREE--CULLCF
72
*TREE--BFSND
73
*TREE--CFSND
74
*TREE--SAWHT
75
*BOLEHT
76
*TREE--FORMCL
77
*TREE--HTCALC
78
*TREE--HRDWD_CLUMP_CD
79
*TREE--SITREE
80
*TREE--CREATED_BY
81
*TREE--CREATED_DATE
82
*TREE--CREATED_IN_INSTANCE
83
*TREE--MODIFIED_BY
84
*TREE--MODIFIED_DATE
85
*TREE--MODIFIED_IN_INSTANCE
86
*TREE--MORTCD
87
*TREE--HTDMP
88
*TREE--ROUGHCULL
89
*TREE--MIST_CL_CD
90
*TREE--CULL_FLD
91
*TREE--RECONCILECD
92
*TREE--PREVDIA
93
*TREE--FGROWCFGS
94
*TREE--FGROWBFSL
95
*TREE--FGROWCFAL
96
*TREE--FMORTCFGS
97
*TREE--FMORTBFSL
98
*TREE--FMORTCFAL
99
*TREE--FREMVCFGS
100
*TREE--FREMVBFSL
101
*TREE--FREMVCFAL
102
*TREE--P2A_GRM_FLG
103
*TREE--TREECLCD_NERS
104
*TREE--TREECLCD_SRS
105
*TREE--TREECLCD_NCRS
106
*TREE--TREECLCD_RMRS
107
*TREE--STANDING_DEAD_CD
108
*TREE--PREV_STATUS_CD
109
*TREE--PREV_WDLDSTEM
110
*TREE--TPA_UNADJ
111
*TREE--TPAMORT_UNADJ
112
*TREE--TPAREMV_UNADJ
113
*TREE--TPAGROW_UNADJ
114
*TREE--DRYBIO_BOLE
115
*TREE--DRYBIO_TOP
116
*TREE--DRYBIO_STUMP
117
*TREE--DRYBIO_SAPLING
118
*TREE--DRYBIO_WDLD_SPP
119
*TREE--DRYBIO_BG
120
*TREE--CARBON_AG
121
*TREE--CARBON_BG
122
*TREE--CYCLE
123
*TREE--SUBCYCLE
124
*TREE--BORED_CD_PNWRS
125
*TREE--DAMLOC1_PNWRS
126
*TREE--DAMLOC2_PNWRS
127
*TREE--DIACHECK_PNWRS
128
*TREE--DMG_AGENT1_CD_PNWRS
129
*TREE--DMG_AGENT2_CD_PNWRS
130
*TREE--DMG_AGENT3_CD_PNWRS
131
*TREE--MIST_CL_CD_PNWRS
132
*TREE--SEVERITY1_CD_PNWRS
133
*TREE--SEVERITY1A_CD_PNWRS
134
*TREE--SEVERITY1B_CD_PNWRS
135
*TREE--SEVERITY2_CD_PNWRS
136
*TREE--SEVERITY2A_CD_PNWRS
137
*TREE--SEVERITY2B_CD_PNWRS
138
*TREE--SEVERITY3_CD_PNWRS
139
*TREE--UNKNOWN_DAMTYP1_PNWRS
140
*TREE--UNKNOWN_DAMTYP2_PNWRS
141
*TREE--PREV_PNTN_SRS
142
*TREE--DISEASE_SRS
143
*TREE--DIEBACK_SEVERITY_SRS
144
*REF_SPECIES--row_num
145
*REF_SPECIES--COMMON_NAME
146
*REF_SPECIES--GENUS
147
*REF_SPECIES--SPECIES
148
*REF_SPECIES--VARIETY
149
*REF_SPECIES--SUBSPECIES
150
*REF_SPECIES--E_SPGRPCD
151
*REF_SPECIES--W_SPGRPCD
152
*REF_SPECIES--C_SPGRPCD
153
*REF_SPECIES--P_SPGRPCD
154
*REF_SPECIES--MAJOR_SPGRPCD
155
*REF_SPECIES--STOCKING_SPGRPCD
156
*REF_SPECIES--FOREST_TYPE_SPGRPCD
157
*REF_SPECIES--EXISTS_IN_NCRS
158
*REF_SPECIES--EXISTS_IN_NERS
159
*REF_SPECIES--EXISTS_IN_PNWRS
160
*REF_SPECIES--EXISTS_IN_RMRS
161
*REF_SPECIES--EXISTS_IN_SRS
162
*REF_SPECIES--SITETREE
163
*REF_SPECIES--SFTWD_HRDWD
164
*REF_SPECIES--ST_EXISTS_IN_NCRS
165
*REF_SPECIES--ST_EXISTS_IN_NERS
166
*REF_SPECIES--ST_EXISTS_IN_PNWRS
167
*REF_SPECIES--ST_EXISTS_IN_RMRS
168
*REF_SPECIES--ST_EXISTS_IN_SRS
169
*REF_SPECIES--CORE
170
*REF_SPECIES--EAST
171
*REF_SPECIES--WEST
172
*REF_SPECIES--CARIBBEAN
173
*REF_SPECIES--PACIFIC
174
*REF_SPECIES--WOODLAND
175
*REF_SPECIES--MANUAL_START
176
*REF_SPECIES--MANUAL_END
177
*REF_SPECIES--JENKINS_SPGRPCD
178
*REF_SPECIES--JENKINS_TOTAL_B1
179
*REF_SPECIES--JENKINS_TOTAL_B2
180
*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B1
181
*REF_SPECIES--JENKINS_STEM_WOOD_RATIO_B2
182
*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B1
183
*REF_SPECIES--JENKINS_STEM_BARK_RATIO_B2
184
*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B1
185
*REF_SPECIES--JENKINS_FOLIAGE_RATIO_B2
186
*REF_SPECIES--JENKINS_ROOT_RATIO_B1
187
*REF_SPECIES--JENKINS_ROOT_RATIO_B2
188
*REF_SPECIES--JENKINS_SAPLING_ADJUSTMENT
189
*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT
190
*REF_SPECIES--WOOD_SPGR_GREENVOL_DRYWT_CIT
191
*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT
192
*REF_SPECIES--BARK_SPGR_GREENVOL_DRYWT_CIT
193
*REF_SPECIES--MC_PCT_GREEN_BARK
194
*REF_SPECIES--MC_PCT_GREEN_BARK_CIT
195
*REF_SPECIES--MC_PCT_GREEN_WOOD
196
*REF_SPECIES--MC_PCT_GREEN_WOOD_CIT
197
*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT
198
*REF_SPECIES--WOOD_SPGR_MC12VOL_DRYWT_CIT
199
*REF_SPECIES--BARK_VOL_PCT
200
*REF_SPECIES--BARK_VOL_PCT_CIT
201
*REF_SPECIES--RAILE_STUMP_DOB_B1
202
*REF_SPECIES--RAILE_STUMP_DIB_B1
203
*REF_SPECIES--RAILE_STUMP_DIB_B2
204
*REF_SPECIES--CWD_DECAY_RATIO1
205
*REF_SPECIES--CWD_DECAY_RATIO2
206
*REF_SPECIES--CWD_DECAY_RATIO3
207
*REF_SPECIES--CWD_DECAY_RATIO4
208
*REF_SPECIES--CWD_DECAY_RATIO5
209
*REF_SPECIES--DWM_CARBON_RATIO
210
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO1
211
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO2
212
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO3
213
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO4
214
*REF_SPECIES--STANDING_DEAD_DECAY_RATIO5
215
*REF_SPECIES--CREATED_BY
216
*REF_SPECIES--CREATED_DATE
217
*REF_SPECIES--CREATED_IN_INSTANCE
218
*REF_SPECIES--MODIFIED_BY
219
*REF_SPECIES--MODIFIED_DATE
220
*REF_SPECIES--MODIFIED_IN_INSTANCE
221
*REF_PLANT_DICTIONARY--row_num
222
*REF_PLANT_DICTIONARY--CN
223
*REF_PLANT_DICTIONARY--NEW_SYMBOL
224
*REF_PLANT_DICTIONARY--NEW_SCIENTIFIC_NAME
225
vernacularName
226
*REF_PLANT_DICTIONARY--CATEGORY
227
taxonGrowthForm
228
*REF_PLANT_DICTIONARY--DURATION
229
*REF_PLANT_DICTIONARY--US_NATIVITY
230
*REF_PLANT_DICTIONARY--STATE_DISTRIBUTION
231
*REF_PLANT_DICTIONARY--STATE_AND_PROVINCE
232
*GENERA_BINOMIAL_AUTHOR
233
*TRINOMIAL_AUTHOR
234
*QUADRINOMIAL_AUTHOR
235
*XGENUS
236
*XSPECIES
237
*SSP_PREFIX
238
*XSUBSPECIES
239
*VAR_PREFIX
240
*XVARIETY
241
*SUBVAR
242
*SUBVARIETY
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff