Project

General

Profile

« Previous | Next » 

Revision 632

VegBIEN: Renamed taxondetermination.*determination to is*

View differences:

test/accepted_output/SALVIAS.organisms.VegBIEN.xml
80 80
                </plantconcept>
81 81
            </plantconcept_id>
82 82
            <determinationtype>Computer (automated)</determinationtype>
83
            <currentdetermination>true</currentdetermination>
83
            <iscurrent>true</iscurrent>
84 84
        </taxondetermination>
85 85
        <taxondetermination>
86 86
            <role_id>
......
101 101
                </plantconcept>
102 102
            </plantconcept_id>
103 103
            <determinationtype>Computer (automated)</determinationtype>
104
            <currentdetermination>true</currentdetermination>
104
            <iscurrent>true</iscurrent>
105 105
        </taxondetermination>
106 106
        <taxondetermination>
107 107
            <role_id>
......
122 122
                </plantconcept>
123 123
            </plantconcept_id>
124 124
            <determinationtype>Computer (automated)</determinationtype>
125
            <currentdetermination>true</currentdetermination>
125
            <iscurrent>true</iscurrent>
126 126
        </taxondetermination>
127 127
        <taxondetermination>
128 128
            <role_id>
......
143 143
                </plantconcept>
144 144
            </plantconcept_id>
145 145
            <determinationtype>Author</determinationtype>
146
            <originaldetermination>true</originaldetermination>
147
            <currentdetermination>true</currentdetermination>
146
            <isoriginal>true</isoriginal>
147
            <iscurrent>true</iscurrent>
148 148
        </taxondetermination>
149 149
        <taxondetermination>
150 150
            <role_id>
......
165 165
                </plantconcept>
166 166
            </plantconcept_id>
167 167
            <determinationtype>Author</determinationtype>
168
            <originaldetermination>true</originaldetermination>
169
            <currentdetermination>true</currentdetermination>
168
            <isoriginal>true</isoriginal>
169
            <iscurrent>true</iscurrent>
170 170
        </taxondetermination>
171 171
    </taxonoccurrence>
172 172
    <taxonoccurrence id="1">
......
249 249
                </plantconcept>
250 250
            </plantconcept_id>
251 251
            <determinationtype>Computer (automated)</determinationtype>
252
            <currentdetermination>true</currentdetermination>
252
            <iscurrent>true</iscurrent>
253 253
        </taxondetermination>
254 254
        <taxondetermination>
255 255
            <role_id>
......
270 270
                </plantconcept>
271 271
            </plantconcept_id>
272 272
            <determinationtype>Computer (automated)</determinationtype>
273
            <currentdetermination>true</currentdetermination>
273
            <iscurrent>true</iscurrent>
274 274
        </taxondetermination>
275 275
        <taxondetermination>
276 276
            <role_id>
......
291 291
                </plantconcept>
292 292
            </plantconcept_id>
293 293
            <determinationtype>Computer (automated)</determinationtype>
294
            <currentdetermination>true</currentdetermination>
294
            <iscurrent>true</iscurrent>
295 295
        </taxondetermination>
296 296
        <taxondetermination>
297 297
            <role_id>
......
312 312
                </plantconcept>
313 313
            </plantconcept_id>
314 314
            <determinationtype>Author</determinationtype>
315
            <originaldetermination>true</originaldetermination>
316
            <currentdetermination>true</currentdetermination>
315
            <isoriginal>true</isoriginal>
316
            <iscurrent>true</iscurrent>
317 317
        </taxondetermination>
318 318
        <taxondetermination>
319 319
            <role_id>
......
334 334
                </plantconcept>
335 335
            </plantconcept_id>
336 336
            <determinationtype>Author</determinationtype>
337
            <originaldetermination>true</originaldetermination>
338
            <currentdetermination>true</currentdetermination>
337
            <isoriginal>true</isoriginal>
338
            <iscurrent>true</iscurrent>
339 339
        </taxondetermination>
340 340
    </taxonoccurrence>
341 341
</VegBIEN>
test/accepted_output/SALVIAS_db.organisms.VegBIEN.xml
67 67
                </plantconcept>
68 68
            </plantconcept_id>
69 69
            <determinationtype>Computer (automated)</determinationtype>
70
            <currentdetermination>true</currentdetermination>
70
            <iscurrent>true</iscurrent>
71 71
        </taxondetermination>
72 72
        <taxondetermination>
73 73
            <role_id>
......
88 88
                </plantconcept>
89 89
            </plantconcept_id>
90 90
            <determinationtype>Computer (automated)</determinationtype>
91
            <currentdetermination>true</currentdetermination>
91
            <iscurrent>true</iscurrent>
92 92
        </taxondetermination>
93 93
        <taxondetermination>
94 94
            <role_id>
......
109 109
                </plantconcept>
110 110
            </plantconcept_id>
111 111
            <determinationtype>Computer (automated)</determinationtype>
112
            <currentdetermination>true</currentdetermination>
112
            <iscurrent>true</iscurrent>
113 113
        </taxondetermination>
114 114
        <taxondetermination>
115 115
            <role_id>
......
130 130
                </plantconcept>
131 131
            </plantconcept_id>
132 132
            <determinationtype>Computer (automated)</determinationtype>
133
            <currentdetermination>true</currentdetermination>
133
            <iscurrent>true</iscurrent>
134 134
        </taxondetermination>
135 135
        <taxondetermination>
136 136
            <role_id>
......
151 151
                </plantconcept>
152 152
            </plantconcept_id>
153 153
            <determinationtype>Author</determinationtype>
154
            <originaldetermination>true</originaldetermination>
155
            <currentdetermination>true</currentdetermination>
154
            <isoriginal>true</isoriginal>
155
            <iscurrent>true</iscurrent>
156 156
        </taxondetermination>
157 157
        <taxondetermination>
158 158
            <role_id>
......
173 173
                </plantconcept>
174 174
            </plantconcept_id>
175 175
            <determinationtype>Author</determinationtype>
176
            <originaldetermination>true</originaldetermination>
177
            <currentdetermination>true</currentdetermination>
176
            <isoriginal>true</isoriginal>
177
            <iscurrent>true</iscurrent>
178 178
        </taxondetermination>
179 179
        <specimen>
180 180
            <reference_id>
......
250 250
                </plantconcept>
251 251
            </plantconcept_id>
252 252
            <determinationtype>Computer (automated)</determinationtype>
253
            <currentdetermination>true</currentdetermination>
253
            <iscurrent>true</iscurrent>
254 254
        </taxondetermination>
255 255
        <taxondetermination>
256 256
            <role_id>
......
271 271
                </plantconcept>
272 272
            </plantconcept_id>
273 273
            <determinationtype>Computer (automated)</determinationtype>
274
            <currentdetermination>true</currentdetermination>
274
            <iscurrent>true</iscurrent>
275 275
        </taxondetermination>
276 276
        <taxondetermination>
277 277
            <role_id>
......
292 292
                </plantconcept>
293 293
            </plantconcept_id>
294 294
            <determinationtype>Computer (automated)</determinationtype>
295
            <currentdetermination>true</currentdetermination>
295
            <iscurrent>true</iscurrent>
296 296
        </taxondetermination>
297 297
        <taxondetermination>
298 298
            <role_id>
......
313 313
                </plantconcept>
314 314
            </plantconcept_id>
315 315
            <determinationtype>Computer (automated)</determinationtype>
316
            <currentdetermination>true</currentdetermination>
316
            <iscurrent>true</iscurrent>
317 317
        </taxondetermination>
318 318
        <taxondetermination>
319 319
            <role_id>
......
334 334
                </plantconcept>
335 335
            </plantconcept_id>
336 336
            <determinationtype>Author</determinationtype>
337
            <originaldetermination>true</originaldetermination>
338
            <currentdetermination>true</currentdetermination>
337
            <isoriginal>true</isoriginal>
338
            <iscurrent>true</iscurrent>
339 339
        </taxondetermination>
340 340
        <taxondetermination>
341 341
            <role_id>
......
356 356
                </plantconcept>
357 357
            </plantconcept_id>
358 358
            <determinationtype>Author</determinationtype>
359
            <originaldetermination>true</originaldetermination>
360
            <currentdetermination>true</currentdetermination>
359
            <isoriginal>true</isoriginal>
360
            <iscurrent>true</iscurrent>
361 361
        </taxondetermination>
362 362
        <specimen>
363 363
            <reference_id>
test/accepted_output/NYBG.organisms.VegBIEN.xml
85 85
                </role>
86 86
            </role_id>
87 87
            <determinationtype>Author</determinationtype>
88
            <originaldetermination>true</originaldetermination>
89
            <currentdetermination>true</currentdetermination>
88
            <isoriginal>true</isoriginal>
89
            <iscurrent>true</iscurrent>
90 90
            <plantconcept_id>
91 91
                <plantconcept>
92 92
                    <plantname_id>
......
116 116
                </plantconcept>
117 117
            </plantconcept_id>
118 118
            <determinationtype>Author</determinationtype>
119
            <originaldetermination>true</originaldetermination>
120
            <currentdetermination>true</currentdetermination>
119
            <isoriginal>true</isoriginal>
120
            <iscurrent>true</iscurrent>
121 121
        </taxondetermination>
122 122
        <taxondetermination>
123 123
            <role_id>
......
138 138
                </plantconcept>
139 139
            </plantconcept_id>
140 140
            <determinationtype>Author</determinationtype>
141
            <originaldetermination>true</originaldetermination>
142
            <currentdetermination>true</currentdetermination>
141
            <isoriginal>true</isoriginal>
142
            <iscurrent>true</iscurrent>
143 143
        </taxondetermination>
144 144
        <taxondetermination>
145 145
            <role_id>
......
160 160
                </plantconcept>
161 161
            </plantconcept_id>
162 162
            <determinationtype>Author</determinationtype>
163
            <originaldetermination>true</originaldetermination>
164
            <currentdetermination>true</currentdetermination>
163
            <isoriginal>true</isoriginal>
164
            <iscurrent>true</iscurrent>
165 165
        </taxondetermination>
166 166
        <taxondetermination>
167 167
            <role_id>
......
182 182
                </plantconcept>
183 183
            </plantconcept_id>
184 184
            <determinationtype>Author</determinationtype>
185
            <originaldetermination>true</originaldetermination>
186
            <currentdetermination>true</currentdetermination>
185
            <isoriginal>true</isoriginal>
186
            <iscurrent>true</iscurrent>
187 187
        </taxondetermination>
188 188
        <taxondetermination>
189 189
            <role_id>
......
204 204
                </plantconcept>
205 205
            </plantconcept_id>
206 206
            <determinationtype>Author</determinationtype>
207
            <originaldetermination>true</originaldetermination>
208
            <currentdetermination>true</currentdetermination>
207
            <isoriginal>true</isoriginal>
208
            <iscurrent>true</iscurrent>
209 209
        </taxondetermination>
210 210
        <taxondetermination>
211 211
            <role_id>
......
226 226
                </plantconcept>
227 227
            </plantconcept_id>
228 228
            <determinationtype>Author</determinationtype>
229
            <originaldetermination>true</originaldetermination>
230
            <currentdetermination>true</currentdetermination>
229
            <isoriginal>true</isoriginal>
230
            <iscurrent>true</iscurrent>
231 231
        </taxondetermination>
232 232
    </taxonoccurrence>
233 233
    <taxonoccurrence id="1">
......
282 282
                </role>
283 283
            </role_id>
284 284
            <determinationtype>Author</determinationtype>
285
            <originaldetermination>true</originaldetermination>
286
            <currentdetermination>true</currentdetermination>
285
            <isoriginal>true</isoriginal>
286
            <iscurrent>true</iscurrent>
287 287
            <plantconcept_id>
288 288
                <plantconcept>
289 289
                    <plantname_id>
......
313 313
                </plantconcept>
314 314
            </plantconcept_id>
315 315
            <determinationtype>Author</determinationtype>
316
            <originaldetermination>true</originaldetermination>
317
            <currentdetermination>true</currentdetermination>
316
            <isoriginal>true</isoriginal>
317
            <iscurrent>true</iscurrent>
318 318
        </taxondetermination>
319 319
        <taxondetermination>
320 320
            <role_id>
......
335 335
                </plantconcept>
336 336
            </plantconcept_id>
337 337
            <determinationtype>Author</determinationtype>
338
            <originaldetermination>true</originaldetermination>
339
            <currentdetermination>true</currentdetermination>
338
            <isoriginal>true</isoriginal>
339
            <iscurrent>true</iscurrent>
340 340
        </taxondetermination>
341 341
        <taxondetermination>
342 342
            <role_id>
......
357 357
                </plantconcept>
358 358
            </plantconcept_id>
359 359
            <determinationtype>Author</determinationtype>
360
            <originaldetermination>true</originaldetermination>
361
            <currentdetermination>true</currentdetermination>
360
            <isoriginal>true</isoriginal>
361
            <iscurrent>true</iscurrent>
362 362
        </taxondetermination>
363 363
        <aggregateoccurrence>
364 364
            <individualplant>
inputs/SALVIAS/test/VegBIEN.xml.ref
190 190
                </plantconcept>
191 191
            </plantconcept_id>
192 192
            <determinationtype>Computer (automated)</determinationtype>
193
            <currentdetermination>true</currentdetermination>
193
            <iscurrent>true</iscurrent>
194 194
        </taxondetermination>
195 195
        <taxondetermination>
196 196
            <role_id>
......
211 211
                </plantconcept>
212 212
            </plantconcept_id>
213 213
            <determinationtype>Computer (automated)</determinationtype>
214
            <currentdetermination>true</currentdetermination>
214
            <iscurrent>true</iscurrent>
215 215
        </taxondetermination>
216 216
        <taxondetermination>
217 217
            <role_id>
......
232 232
                </plantconcept>
233 233
            </plantconcept_id>
234 234
            <determinationtype>Computer (automated)</determinationtype>
235
            <currentdetermination>true</currentdetermination>
235
            <iscurrent>true</iscurrent>
236 236
        </taxondetermination>
237 237
        <taxondetermination>
238 238
            <role_id>
......
253 253
                </plantconcept>
254 254
            </plantconcept_id>
255 255
            <determinationtype>Computer (automated)</determinationtype>
256
            <currentdetermination>true</currentdetermination>
256
            <iscurrent>true</iscurrent>
257 257
        </taxondetermination>
258 258
        <taxondetermination>
259 259
            <role_id>
......
274 274
                </plantconcept>
275 275
            </plantconcept_id>
276 276
            <determinationtype>Author</determinationtype>
277
            <originaldetermination>true</originaldetermination>
278
            <currentdetermination>true</currentdetermination>
277
            <isoriginal>true</isoriginal>
278
            <iscurrent>true</iscurrent>
279 279
        </taxondetermination>
280 280
        <taxondetermination>
281 281
            <role_id>
......
296 296
                </plantconcept>
297 297
            </plantconcept_id>
298 298
            <determinationtype>Author</determinationtype>
299
            <originaldetermination>true</originaldetermination>
300
            <currentdetermination>true</currentdetermination>
299
            <isoriginal>true</isoriginal>
300
            <iscurrent>true</iscurrent>
301 301
        </taxondetermination>
302 302
        <specimen>
303 303
            <reference_id>
......
373 373
                </plantconcept>
374 374
            </plantconcept_id>
375 375
            <determinationtype>Computer (automated)</determinationtype>
376
            <currentdetermination>true</currentdetermination>
376
            <iscurrent>true</iscurrent>
377 377
        </taxondetermination>
378 378
        <taxondetermination>
379 379
            <role_id>
......
394 394
                </plantconcept>
395 395
            </plantconcept_id>
396 396
            <determinationtype>Computer (automated)</determinationtype>
397
            <currentdetermination>true</currentdetermination>
397
            <iscurrent>true</iscurrent>
398 398
        </taxondetermination>
399 399
        <taxondetermination>
400 400
            <role_id>
......
415 415
                </plantconcept>
416 416
            </plantconcept_id>
417 417
            <determinationtype>Computer (automated)</determinationtype>
418
            <currentdetermination>true</currentdetermination>
418
            <iscurrent>true</iscurrent>
419 419
        </taxondetermination>
420 420
        <taxondetermination>
421 421
            <role_id>
......
436 436
                </plantconcept>
437 437
            </plantconcept_id>
438 438
            <determinationtype>Computer (automated)</determinationtype>
439
            <currentdetermination>true</currentdetermination>
439
            <iscurrent>true</iscurrent>
440 440
        </taxondetermination>
441 441
        <taxondetermination>
442 442
            <role_id>
......
457 457
                </plantconcept>
458 458
            </plantconcept_id>
459 459
            <determinationtype>Author</determinationtype>
460
            <originaldetermination>true</originaldetermination>
461
            <currentdetermination>true</currentdetermination>
460
            <isoriginal>true</isoriginal>
461
            <iscurrent>true</iscurrent>
462 462
        </taxondetermination>
463 463
        <taxondetermination>
464 464
            <role_id>
......
479 479
                </plantconcept>
480 480
            </plantconcept_id>
481 481
            <determinationtype>Author</determinationtype>
482
            <originaldetermination>true</originaldetermination>
483
            <currentdetermination>true</currentdetermination>
482
            <isoriginal>true</isoriginal>
483
            <iscurrent>true</iscurrent>
484 484
        </taxondetermination>
485 485
        <specimen>
486 486
            <reference_id>
inputs/SALVIAS/maps/VegBIEN.organisms.csv
18 18
census_date,/specimen:[*_id/reference]/collectiondate/_*/date,
19 19
coll_firstname,/specimen:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
20 20
coll_lastname,/specimen:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
21
auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
22
Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
23
Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
24
Species,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
21
auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
22
Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
23
Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
24
Species,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
25 25
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/_name/first",
26
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/_name/last",
26
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/_name/last",
27 27
cfaff,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=cfAff]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
28
Notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/notes",
29
OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
30
OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
28
Notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/notes",
29
OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
30
OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
31 31
PlotObsID,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
schemas/vegbien.for_ERD.my.sql
331 331
  role_id int(11) NOT NULL,
332 332
  determinationtype character varying(30),
333 333
  reference_id int(11),
334
  originaldetermination int(1) NOT NULL DEFAULT false,
335
  currentdetermination int(1) NOT NULL DEFAULT false,
334
  isoriginal int(1) NOT NULL DEFAULT false,
335
  iscurrent int(1) NOT NULL DEFAULT false,
336 336
  taxonfit character varying(50),
337 337
  taxonconfidence character varying(50),
338 338
  grouptype character varying(20),
schemas/vegbien.for_wiki.sql
123 123
  role_id integer NOT NULL,
124 124
  determinationtype character varying(30),
125 125
  reference_id integer,
126
  originaldetermination boolean NOT NULL DEFAULT false,
127
  currentdetermination boolean NOT NULL DEFAULT false,
126
  isoriginal boolean NOT NULL DEFAULT false,
127
  iscurrent boolean NOT NULL DEFAULT false,
128 128
  taxonfit character varying(50),
129 129
  taxonconfidence character varying(50),
130 130
  grouptype character varying(20),
schemas/vegbien.for_ERD.sql
331 331
  role_id integer NOT NULL,
332 332
  determinationtype character varying(30),
333 333
  reference_id integer,
334
  originaldetermination boolean NOT NULL DEFAULT false,
335
  currentdetermination boolean NOT NULL DEFAULT false,
334
  isoriginal boolean NOT NULL DEFAULT false,
335
  iscurrent boolean NOT NULL DEFAULT false,
336 336
  taxonfit character varying(50),
337 337
  taxonconfidence character varying(50),
338 338
  grouptype character varying(20),
schemas/vegbien.sql
2520 2520
    role_id integer NOT NULL,
2521 2521
    determinationtype character varying(30),
2522 2522
    reference_id integer,
2523
    originaldetermination boolean DEFAULT false NOT NULL,
2524
    currentdetermination boolean DEFAULT false NOT NULL,
2523
    isoriginal boolean DEFAULT false NOT NULL,
2524
    iscurrent boolean DEFAULT false NOT NULL,
2525 2525
    taxonfit character varying(50),
2526 2526
    taxonconfidence character varying(50),
2527 2527
    grouptype character varying(20),
mappings/SALVIAS_db-VegBIEN.organisms.csv
18 18
census_date,/specimen:[*_id/reference]/collectiondate/_*/date,
19 19
coll_firstname,/specimen:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
20 20
coll_lastname,/specimen:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
21
auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
22
Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
23
Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
24
Species,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
21
auth,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
22
Family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
23
Genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
24
Species,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
25 25
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/_name/first",
26
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/_name/last",
26
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/_name/last",
27 27
cfaff,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=cfAff]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
28
Notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/notes",
29
OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
30
OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
28
Notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/notes",
29
OrigFamily,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
30
OrigSpecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
31 31
PlotObsID,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
mappings/VegX-VegBIEN.organisms.csv
99 99
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName,"/specimen:[*_id/reference]/{museum_id/party/organizationname,collectioncode_dwc/_namePart/last}"
100 100
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first,/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/first}
101 101
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last,"/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}"
102
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
103
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
104
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
105
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
102
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
103
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
104
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
105
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
106 106
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/_name/first"
107
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/_name/last"
107
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/_name/last"
108 108
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/note","/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=cfAff]]:[@fkey=tableRecord_ID]/definedvalue"
109 109
/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue"
110 110
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day"
111 111
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month"
112 112
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/year"
113
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
114
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/notes"
115
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/1"
116
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
117
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
118
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
119
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
120
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
121
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
122
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
123
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname"
113
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/partyWithRole/*ID->/parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
114
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/notes"
115
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_alt/1"
116
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
117
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
118
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
119
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
120
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
121
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
122
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
123
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname"
124 124
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname"
125 125
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}"
mappings/NYBG-VegBIEN.organisms.csv
27 27
DayIdentified,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day",
28 28
MonthIdentified,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month",
29 29
YearIdentified,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/year",
30
IdentifiedBy,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?
31
Notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/notes","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes"
32
ScientificName,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/1","Brad: Bob, Nick, please is this mapping OK?"
33
ScientificNameAuthor,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author"
34
Class,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
35
Family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
36
Genus,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
37
Kingdom,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
38
Order,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
39
Species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
40
Phylum,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
30
IdentifiedBy,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?
31
Notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/notes","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes"
32
ScientificName,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname/_alt/1","Brad: Bob, Nick, please is this mapping OK?"
33
ScientificNameAuthor,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author"
34
Class,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
35
Family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
36
Genus,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
37
Kingdom,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
38
Order,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
39
Species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
40
Phylum,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
41 41
Subspecies,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",
42 42
UniqueNYInternalRecordNumber,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key"
mappings/SALVIAS-VegBIEN.organisms.csv
27 27
coll_number,/specimen:[*_id/reference]/catalognumber_dwc,Brad: Incorrect. Map instead as for voucher_string
28 28
coll_firstname,/specimen:[*_id/reference]/verbatimcollectorname/_name/first,Brad: See comment above
29 29
coll_lastname,/specimen:[*_id/reference]/verbatimcollectorname/_name/last,"Brad: Correct for VegBank. This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
30
specific_authority,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
31
family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
32
genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
33
specific_epithet,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",
30
specific_authority,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
31
family,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
32
genus,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
33
specific_epithet,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/*_id/*/plantname",
34 34
infra_rank_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/_name/first",
35
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/_name/last",
35
infra_ep_1,"/taxondetermination[*_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",iscurrent=true]/*_id/plantconcept/_name/last",
36 36
cf_aff,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=cfAff]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
37
notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/notes",
38
orig_family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
39
orig_species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
37
notes,"/taxondetermination[*_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,iscurrent=true]/notes",
38
orig_family,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
39
orig_species,"/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
40 40
OBSERVATION_ID,"/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."

Also available in: Unified diff