Revision 528
Added by Aaron Marcuse-Kubitza almost 13 years ago
| test/accepted_output/SALVIAS.organisms.VegBIEN.xml | ||
|---|---|---|
| 85 | 85 |
</definedvalue> |
| 86 | 86 |
<originaldetermination>true</originaldetermination> |
| 87 | 87 |
<determinationdate>epoch</determinationdate> |
| 88 |
<plantname_id> |
|
| 89 |
<plantname> |
|
| 90 |
<plantname>Inga indet</plantname> |
|
| 91 |
</plantname> |
|
| 92 |
</plantname_id> |
|
| 88 |
<plantconcept_id> |
|
| 89 |
<plantconcept> |
|
| 90 |
<reference_id> |
|
| 91 |
<reference/> |
|
| 92 |
</reference_id> |
|
| 93 |
<plantname_id> |
|
| 94 |
<plantname> |
|
| 95 |
<plantname>Inga indet</plantname> |
|
| 96 |
</plantname> |
|
| 97 |
</plantname_id> |
|
| 98 |
</plantconcept> |
|
| 99 |
</plantconcept_id> |
|
| 93 | 100 |
</taxondetermination> |
| 94 | 101 |
<taxondetermination> |
| 95 | 102 |
<role_id> |
| ... | ... | |
| 124 | 131 |
<party_id> |
| 125 | 132 |
<party/> |
| 126 | 133 |
</party_id> |
| 127 |
<plantname_id> |
|
| 128 |
<plantname> |
|
| 129 |
<plantname>Fabaceae</plantname> |
|
| 130 |
</plantname> |
|
| 131 |
</plantname_id> |
|
| 132 | 134 |
</taxondetermination> |
| 133 | 135 |
<taxondetermination> |
| 134 | 136 |
<role_id> |
| ... | ... | |
| 163 | 165 |
<party_id> |
| 164 | 166 |
<party/> |
| 165 | 167 |
</party_id> |
| 166 |
<plantname_id> |
|
| 167 |
<plantname> |
|
| 168 |
<plantname>Inga</plantname> |
|
| 169 |
</plantname> |
|
| 170 |
</plantname_id> |
|
| 171 | 168 |
</taxondetermination> |
| 172 | 169 |
<taxondetermination> |
| 173 | 170 |
<role_id> |
| ... | ... | |
| 202 | 199 |
<party_id> |
| 203 | 200 |
<party/> |
| 204 | 201 |
</party_id> |
| 205 |
<plantname_id> |
|
| 206 |
<plantname> |
|
| 207 |
<plantname>indet</plantname> |
|
| 208 |
</plantname> |
|
| 209 |
</plantname_id> |
|
| 210 | 202 |
</taxondetermination> |
| 211 | 203 |
<taxondetermination> |
| 212 | 204 |
<role_id> |
| ... | ... | |
| 241 | 233 |
<party_id> |
| 242 | 234 |
<party/> |
| 243 | 235 |
</party_id> |
| 244 |
<plantname_id> |
|
| 245 |
<plantname> |
|
| 246 |
<plantname>Fabaceae</plantname> |
|
| 247 |
</plantname> |
|
| 248 |
</plantname_id> |
|
| 249 | 236 |
</taxondetermination> |
| 250 | 237 |
<taxondetermination> |
| 251 | 238 |
<role_id> |
| ... | ... | |
| 280 | 267 |
<party_id> |
| 281 | 268 |
<party/> |
| 282 | 269 |
</party_id> |
| 283 |
<plantname_id> |
|
| 284 |
<plantname> |
|
| 285 |
<plantname>Inga indet</plantname> |
|
| 286 |
</plantname> |
|
| 287 |
</plantname_id> |
|
| 288 | 270 |
</taxondetermination> |
| 289 | 271 |
</taxonoccurrence> |
| 290 | 272 |
<taxonoccurrence id="1"> |
| ... | ... | |
| 372 | 354 |
</definedvalue> |
| 373 | 355 |
<originaldetermination>true</originaldetermination> |
| 374 | 356 |
<determinationdate>epoch</determinationdate> |
| 375 |
<plantname_id> |
|
| 376 |
<plantname> |
|
| 377 |
<plantname>Virola pavonis</plantname> |
|
| 378 |
</plantname> |
|
| 379 |
</plantname_id> |
|
| 357 |
<plantconcept_id> |
|
| 358 |
<plantconcept> |
|
| 359 |
<reference_id> |
|
| 360 |
<reference/> |
|
| 361 |
</reference_id> |
|
| 362 |
<plantname_id> |
|
| 363 |
<plantname> |
|
| 364 |
<plantname>Virola pavonis</plantname> |
|
| 365 |
</plantname> |
|
| 366 |
</plantname_id> |
|
| 367 |
</plantconcept> |
|
| 368 |
</plantconcept_id> |
|
| 380 | 369 |
</taxondetermination> |
| 381 | 370 |
<taxondetermination> |
| 382 | 371 |
<role_id> |
| ... | ... | |
| 411 | 400 |
<party_id> |
| 412 | 401 |
<party/> |
| 413 | 402 |
</party_id> |
| 414 |
<plantname_id> |
|
| 415 |
<plantname> |
|
| 416 |
<plantname>Myristicaceae</plantname> |
|
| 417 |
</plantname> |
|
| 418 |
</plantname_id> |
|
| 419 | 403 |
</taxondetermination> |
| 420 | 404 |
<taxondetermination> |
| 421 | 405 |
<role_id> |
| ... | ... | |
| 450 | 434 |
<party_id> |
| 451 | 435 |
<party/> |
| 452 | 436 |
</party_id> |
| 453 |
<plantname_id> |
|
| 454 |
<plantname> |
|
| 455 |
<plantname>Virola</plantname> |
|
| 456 |
</plantname> |
|
| 457 |
</plantname_id> |
|
| 458 | 437 |
</taxondetermination> |
| 459 | 438 |
<taxondetermination> |
| 460 | 439 |
<role_id> |
| ... | ... | |
| 489 | 468 |
<party_id> |
| 490 | 469 |
<party/> |
| 491 | 470 |
</party_id> |
| 492 |
<plantname_id> |
|
| 493 |
<plantname> |
|
| 494 |
<plantname>pavonis</plantname> |
|
| 495 |
</plantname> |
|
| 496 |
</plantname_id> |
|
| 497 | 471 |
</taxondetermination> |
| 498 | 472 |
<taxondetermination> |
| 499 | 473 |
<role_id> |
| ... | ... | |
| 528 | 502 |
<party_id> |
| 529 | 503 |
<party/> |
| 530 | 504 |
</party_id> |
| 531 |
<plantname_id> |
|
| 532 |
<plantname> |
|
| 533 |
<plantname>Myristicaceae</plantname> |
|
| 534 |
</plantname> |
|
| 535 |
</plantname_id> |
|
| 536 | 505 |
</taxondetermination> |
| 537 | 506 |
<taxondetermination> |
| 538 | 507 |
<role_id> |
| ... | ... | |
| 567 | 536 |
<party_id> |
| 568 | 537 |
<party/> |
| 569 | 538 |
</party_id> |
| 570 |
<plantname_id> |
|
| 571 |
<plantname> |
|
| 572 |
<plantname>Virola pavonis</plantname> |
|
| 573 |
</plantname> |
|
| 574 |
</plantname_id> |
|
| 575 | 539 |
</taxondetermination> |
| 576 | 540 |
</taxonoccurrence> |
| 577 | 541 |
</VegBIEN> |
| test/accepted_output/SALVIAS_db.organisms.VegBIEN.xml | ||
|---|---|---|
| 78 | 78 |
</definedvalue> |
| 79 | 79 |
<originaldetermination>true</originaldetermination> |
| 80 | 80 |
<determinationdate>epoch</determinationdate> |
| 81 |
<plantname_id> |
|
| 82 |
<plantname> |
|
| 83 |
<plantname>seleri</plantname> |
|
| 84 |
</plantname> |
|
| 85 |
</plantname_id> |
|
| 81 |
<plantconcept_id> |
|
| 82 |
<plantconcept> |
|
| 83 |
<reference_id> |
|
| 84 |
<reference/> |
|
| 85 |
</reference_id> |
|
| 86 |
<plantname_id> |
|
| 87 |
<plantname> |
|
| 88 |
<plantname>seleri</plantname> |
|
| 89 |
</plantname> |
|
| 90 |
</plantname_id> |
|
| 91 |
</plantconcept> |
|
| 92 |
</plantconcept_id> |
|
| 86 | 93 |
</taxondetermination> |
| 87 | 94 |
<taxondetermination> |
| 88 | 95 |
<role_id> |
| ... | ... | |
| 117 | 124 |
<party_id> |
| 118 | 125 |
<party/> |
| 119 | 126 |
</party_id> |
| 120 |
<plantname_id> |
|
| 121 |
<plantname> |
|
| 122 |
<plantname>Arecaceae</plantname> |
|
| 123 |
</plantname> |
|
| 124 |
</plantname_id> |
|
| 125 | 127 |
</taxondetermination> |
| 126 | 128 |
<taxondetermination> |
| 127 | 129 |
<role_id> |
| ... | ... | |
| 156 | 158 |
<party_id> |
| 157 | 159 |
<party/> |
| 158 | 160 |
</party_id> |
| 159 |
<plantname_id> |
|
| 160 |
<plantname> |
|
| 161 |
<plantname>Geonoma</plantname> |
|
| 162 |
</plantname> |
|
| 163 |
</plantname_id> |
|
| 164 | 161 |
</taxondetermination> |
| 165 | 162 |
<taxondetermination> |
| 166 | 163 |
<role_id> |
| ... | ... | |
| 178 | 175 |
<party/> |
| 179 | 176 |
</party_id> |
| 180 | 177 |
</plantstatus> |
| 178 |
<reference_id> |
|
| 179 |
<reference> |
|
| 180 |
<shortname>Burret</shortname> |
|
| 181 |
</reference> |
|
| 182 |
</reference_id> |
|
| 181 | 183 |
<plantname_id> |
| 182 | 184 |
<plantname> |
| 183 |
<reference_id> |
|
| 184 |
<reference> |
|
| 185 |
<shortname>Burret</shortname> |
|
| 186 |
</reference> |
|
| 187 |
</reference_id> |
|
| 188 | 185 |
<plantname>seleri</plantname> |
| 189 | 186 |
</plantname> |
| 190 | 187 |
</plantname_id> |
| 191 |
<reference_id> |
|
| 192 |
<reference/> |
|
| 193 |
</reference_id> |
|
| 194 | 188 |
</plantconcept> |
| 195 | 189 |
</plantconcept_id> |
| 196 | 190 |
<determinationtype>Computer (automated)</determinationtype> |
| ... | ... | |
| 200 | 194 |
<party_id> |
| 201 | 195 |
<party/> |
| 202 | 196 |
</party_id> |
| 203 |
<plantname_id> |
|
| 204 |
<plantname> |
|
| 205 |
<plantname>seleri</plantname> |
|
| 206 |
</plantname> |
|
| 207 |
</plantname_id> |
|
| 208 | 197 |
</taxondetermination> |
| 209 | 198 |
<taxondetermination> |
| 210 | 199 |
<role_id> |
| ... | ... | |
| 239 | 228 |
<party_id> |
| 240 | 229 |
<party/> |
| 241 | 230 |
</party_id> |
| 242 |
<plantname_id> |
|
| 243 |
<plantname> |
|
| 244 |
<plantname>Arecaceae</plantname> |
|
| 245 |
</plantname> |
|
| 246 |
</plantname_id> |
|
| 247 | 231 |
</taxondetermination> |
| 248 | 232 |
<taxondetermination> |
| 249 | 233 |
<role_id> |
| ... | ... | |
| 278 | 262 |
<party_id> |
| 279 | 263 |
<party/> |
| 280 | 264 |
</party_id> |
| 281 |
<plantname_id> |
|
| 282 |
<plantname> |
|
| 283 |
<plantname>seleri</plantname> |
|
| 284 |
</plantname> |
|
| 285 |
</plantname_id> |
|
| 286 | 265 |
</taxondetermination> |
| 287 | 266 |
</taxonoccurrence> |
| 288 | 267 |
<taxonoccurrence id="1"> |
| ... | ... | |
| 363 | 342 |
</definedvalue> |
| 364 | 343 |
<originaldetermination>true</originaldetermination> |
| 365 | 344 |
<determinationdate>epoch</determinationdate> |
| 366 |
<plantname_id> |
|
| 367 |
<plantname> |
|
| 368 |
<plantname>allenii</plantname> |
|
| 369 |
</plantname> |
|
| 370 |
</plantname_id> |
|
| 345 |
<plantconcept_id> |
|
| 346 |
<plantconcept> |
|
| 347 |
<reference_id> |
|
| 348 |
<reference/> |
|
| 349 |
</reference_id> |
|
| 350 |
<plantname_id> |
|
| 351 |
<plantname> |
|
| 352 |
<plantname>allenii</plantname> |
|
| 353 |
</plantname> |
|
| 354 |
</plantname_id> |
|
| 355 |
</plantconcept> |
|
| 356 |
</plantconcept_id> |
|
| 371 | 357 |
</taxondetermination> |
| 372 | 358 |
<taxondetermination> |
| 373 | 359 |
<role_id> |
| ... | ... | |
| 402 | 388 |
<party_id> |
| 403 | 389 |
<party/> |
| 404 | 390 |
</party_id> |
| 405 |
<plantname_id> |
|
| 406 |
<plantname> |
|
| 407 |
<plantname>Clusiaceae</plantname> |
|
| 408 |
</plantname> |
|
| 409 |
</plantname_id> |
|
| 410 | 391 |
</taxondetermination> |
| 411 | 392 |
<taxondetermination> |
| 412 | 393 |
<role_id> |
| ... | ... | |
| 441 | 422 |
<party_id> |
| 442 | 423 |
<party/> |
| 443 | 424 |
</party_id> |
| 444 |
<plantname_id> |
|
| 445 |
<plantname> |
|
| 446 |
<plantname>Tovomitopsis</plantname> |
|
| 447 |
</plantname> |
|
| 448 |
</plantname_id> |
|
| 449 | 425 |
</taxondetermination> |
| 450 | 426 |
<taxondetermination> |
| 451 | 427 |
<role_id> |
| ... | ... | |
| 463 | 439 |
<party/> |
| 464 | 440 |
</party_id> |
| 465 | 441 |
</plantstatus> |
| 442 |
<reference_id> |
|
| 443 |
<reference> |
|
| 444 |
<shortname>Maguire</shortname> |
|
| 445 |
</reference> |
|
| 446 |
</reference_id> |
|
| 466 | 447 |
<plantname_id> |
| 467 | 448 |
<plantname> |
| 468 |
<reference_id> |
|
| 469 |
<reference> |
|
| 470 |
<shortname>Maguire</shortname> |
|
| 471 |
</reference> |
|
| 472 |
</reference_id> |
|
| 473 | 449 |
<plantname>allenii</plantname> |
| 474 | 450 |
</plantname> |
| 475 | 451 |
</plantname_id> |
| 476 |
<reference_id> |
|
| 477 |
<reference/> |
|
| 478 |
</reference_id> |
|
| 479 | 452 |
</plantconcept> |
| 480 | 453 |
</plantconcept_id> |
| 481 | 454 |
<determinationtype>Computer (automated)</determinationtype> |
| ... | ... | |
| 485 | 458 |
<party_id> |
| 486 | 459 |
<party/> |
| 487 | 460 |
</party_id> |
| 488 |
<plantname_id> |
|
| 489 |
<plantname> |
|
| 490 |
<plantname>allenii</plantname> |
|
| 491 |
</plantname> |
|
| 492 |
</plantname_id> |
|
| 493 | 461 |
</taxondetermination> |
| 494 | 462 |
<taxondetermination> |
| 495 | 463 |
<role_id> |
| ... | ... | |
| 524 | 492 |
<party_id> |
| 525 | 493 |
<party/> |
| 526 | 494 |
</party_id> |
| 527 |
<plantname_id> |
|
| 528 |
<plantname> |
|
| 529 |
<plantname>Clusiaceae</plantname> |
|
| 530 |
</plantname> |
|
| 531 |
</plantname_id> |
|
| 532 | 495 |
</taxondetermination> |
| 533 | 496 |
<taxondetermination> |
| 534 | 497 |
<role_id> |
| ... | ... | |
| 563 | 526 |
<party_id> |
| 564 | 527 |
<party/> |
| 565 | 528 |
</party_id> |
| 566 |
<plantname_id> |
|
| 567 |
<plantname> |
|
| 568 |
<plantname>allenii</plantname> |
|
| 569 |
</plantname> |
|
| 570 |
</plantname_id> |
|
| 571 | 529 |
</taxondetermination> |
| 572 | 530 |
</taxonoccurrence> |
| 573 | 531 |
</VegBIEN> |
| test/accepted_output/NYBG.organisms.VegBIEN.xml | ||
|---|---|---|
| 93 | 93 |
<taxondetermination> |
| 94 | 94 |
<role_id> |
| 95 | 95 |
<aux_role> |
| 96 |
<rolecode>collector</rolecode> |
|
| 97 |
</aux_role> |
|
| 98 |
</role_id> |
|
| 99 |
<determinationtype>Author</determinationtype> |
|
| 100 |
<originaldetermination>true</originaldetermination> |
|
| 101 |
<currentdetermination>true</currentdetermination> |
|
| 102 |
<determinationdate>epoch</determinationdate> |
|
| 103 |
<party_id> |
|
| 104 |
<party/> |
|
| 105 |
</party_id> |
|
| 106 |
<plantconcept_id> |
|
| 107 |
<plantconcept> |
|
| 108 |
<reference_id> |
|
| 109 |
<reference/> |
|
| 110 |
</reference_id> |
|
| 111 |
<plantname_id> |
|
| 112 |
<plantname> |
|
| 113 |
<plantname>Cariniana estrellensis (Raddi) Kuntze</plantname> |
|
| 114 |
</plantname> |
|
| 115 |
</plantname_id> |
|
| 116 |
</plantconcept> |
|
| 117 |
</plantconcept_id> |
|
| 118 |
</taxondetermination> |
|
| 119 |
<taxondetermination> |
|
| 120 |
<role_id> |
|
| 121 |
<aux_role> |
|
| 96 | 122 |
<rolecode>identifier</rolecode> |
| 97 | 123 |
</aux_role> |
| 98 | 124 |
</role_id> |
| ... | ... | |
| 123 | 149 |
<party_id> |
| 124 | 150 |
<party/> |
| 125 | 151 |
</party_id> |
| 126 |
<plantname_id> |
|
| 127 |
<plantname> |
|
| 128 |
<plantname>Lecythidaceae</plantname> |
|
| 129 |
</plantname> |
|
| 130 |
</plantname_id> |
|
| 131 | 152 |
</taxondetermination> |
| 132 | 153 |
<taxondetermination> |
| 133 | 154 |
<role_id> |
| ... | ... | |
| 162 | 183 |
<party_id> |
| 163 | 184 |
<party/> |
| 164 | 185 |
</party_id> |
| 165 |
<plantname_id> |
|
| 166 |
<plantname> |
|
| 167 |
<plantname>Cariniana</plantname> |
|
| 168 |
</plantname> |
|
| 169 |
</plantname_id> |
|
| 170 | 186 |
</taxondetermination> |
| 171 | 187 |
<taxondetermination> |
| 172 | 188 |
<role_id> |
| ... | ... | |
| 201 | 217 |
<party_id> |
| 202 | 218 |
<party/> |
| 203 | 219 |
</party_id> |
| 204 |
<plantname_id> |
|
| 205 |
<plantname> |
|
| 206 |
<plantname>Plantae</plantname> |
|
| 207 |
</plantname> |
|
| 208 |
</plantname_id> |
|
| 209 | 220 |
</taxondetermination> |
| 210 | 221 |
<taxondetermination> |
| 211 | 222 |
<role_id> |
| ... | ... | |
| 249 | 260 |
<party_id> |
| 250 | 261 |
<party/> |
| 251 | 262 |
</party_id> |
| 252 |
<plantname_id> |
|
| 253 |
<plantname> |
|
| 254 |
<plantname>estrellensis</plantname> |
|
| 255 |
</plantname> |
|
| 256 |
</plantname_id> |
|
| 257 | 263 |
</taxondetermination> |
| 258 | 264 |
<taxondetermination> |
| 259 | 265 |
<role_id> |
| ... | ... | |
| 288 | 294 |
<party_id> |
| 289 | 295 |
<party/> |
| 290 | 296 |
</party_id> |
| 291 |
<plantname_id> |
|
| 292 |
<plantname> |
|
| 293 |
<plantname>Magnoliophyta (flowering plants)</plantname> |
|
| 294 |
</plantname> |
|
| 295 |
</plantname_id> |
|
| 296 | 297 |
</taxondetermination> |
| 297 |
<taxondetermination> |
|
| 298 |
<role_id> |
|
| 299 |
<aux_role> |
|
| 300 |
<rolecode>collector</rolecode> |
|
| 301 |
</aux_role> |
|
| 302 |
</role_id> |
|
| 303 |
<determinationtype>Author</determinationtype> |
|
| 304 |
<originaldetermination>true</originaldetermination> |
|
| 305 |
<currentdetermination>true</currentdetermination> |
|
| 306 |
<determinationdate>epoch</determinationdate> |
|
| 307 |
<party_id> |
|
| 308 |
<party/> |
|
| 309 |
</party_id> |
|
| 310 |
<plantname_id> |
|
| 311 |
<plantname> |
|
| 312 |
<plantname>Cariniana estrellensis (Raddi) Kuntze</plantname> |
|
| 313 |
</plantname> |
|
| 314 |
</plantname_id> |
|
| 315 |
</taxondetermination> |
|
| 316 |
<taxondetermination> |
|
| 317 |
<role_id> |
|
| 318 |
<aux_role> |
|
| 319 |
<rolecode>identifier</rolecode> |
|
| 320 |
</aux_role> |
|
| 321 |
</role_id> |
|
| 322 |
<determinationtype>Author</determinationtype> |
|
| 323 |
<originaldetermination>true</originaldetermination> |
|
| 324 |
<currentdetermination>true</currentdetermination> |
|
| 325 |
<determinationdate>epoch</determinationdate> |
|
| 326 |
<party_id> |
|
| 327 |
<party/> |
|
| 328 |
</party_id> |
|
| 329 |
<plantname_id> |
|
| 330 |
<plantname> |
|
| 331 |
<plantname>Cariniana estrellensis (Raddi) Kuntze</plantname> |
|
| 332 |
</plantname> |
|
| 333 |
</plantname_id> |
|
| 334 |
</taxondetermination> |
|
| 335 | 298 |
</taxonoccurrence> |
| 336 | 299 |
<taxonoccurrence id="1"> |
| 337 | 300 |
<locationevent_id> |
| ... | ... | |
| 396 | 359 |
<taxondetermination> |
| 397 | 360 |
<role_id> |
| 398 | 361 |
<aux_role> |
| 362 |
<rolecode>collector</rolecode> |
|
| 363 |
</aux_role> |
|
| 364 |
</role_id> |
|
| 365 |
<determinationtype>Author</determinationtype> |
|
| 366 |
<originaldetermination>true</originaldetermination> |
|
| 367 |
<currentdetermination>true</currentdetermination> |
|
| 368 |
<determinationdate>epoch</determinationdate> |
|
| 369 |
<party_id> |
|
| 370 |
<party/> |
|
| 371 |
</party_id> |
|
| 372 |
<plantconcept_id> |
|
| 373 |
<plantconcept> |
|
| 374 |
<reference_id> |
|
| 375 |
<reference/> |
|
| 376 |
</reference_id> |
|
| 377 |
<plantname_id> |
|
| 378 |
<plantname> |
|
| 379 |
<plantname>Scrophulariaceae</plantname> |
|
| 380 |
</plantname> |
|
| 381 |
</plantname_id> |
|
| 382 |
</plantconcept> |
|
| 383 |
</plantconcept_id> |
|
| 384 |
</taxondetermination> |
|
| 385 |
<taxondetermination> |
|
| 386 |
<role_id> |
|
| 387 |
<aux_role> |
|
| 399 | 388 |
<rolecode>identifier</rolecode> |
| 400 | 389 |
</aux_role> |
| 401 | 390 |
</role_id> |
| ... | ... | |
| 426 | 415 |
<party_id> |
| 427 | 416 |
<party/> |
| 428 | 417 |
</party_id> |
| 429 |
<plantname_id> |
|
| 430 |
<plantname> |
|
| 431 |
<plantname>Scrophulariaceae</plantname> |
|
| 432 |
</plantname> |
|
| 433 |
</plantname_id> |
|
| 434 | 418 |
</taxondetermination> |
| 435 | 419 |
<taxondetermination> |
| 436 | 420 |
<role_id> |
| ... | ... | |
| 465 | 449 |
<party_id> |
| 466 | 450 |
<party/> |
| 467 | 451 |
</party_id> |
| 468 |
<plantname_id> |
|
| 469 |
<plantname> |
|
| 470 |
<plantname>Plantae</plantname> |
|
| 471 |
</plantname> |
|
| 472 |
</plantname_id> |
|
| 473 | 452 |
</taxondetermination> |
| 474 | 453 |
<taxondetermination> |
| 475 | 454 |
<role_id> |
| ... | ... | |
| 504 | 483 |
<party_id> |
| 505 | 484 |
<party/> |
| 506 | 485 |
</party_id> |
| 507 |
<plantname_id> |
|
| 508 |
<plantname> |
|
| 509 |
<plantname>Magnoliophyta (flowering plants)</plantname> |
|
| 510 |
</plantname> |
|
| 511 |
</plantname_id> |
|
| 512 | 486 |
</taxondetermination> |
| 513 |
<taxondetermination> |
|
| 514 |
<role_id> |
|
| 515 |
<aux_role> |
|
| 516 |
<rolecode>collector</rolecode> |
|
| 517 |
</aux_role> |
|
| 518 |
</role_id> |
|
| 519 |
<determinationtype>Author</determinationtype> |
|
| 520 |
<originaldetermination>true</originaldetermination> |
|
| 521 |
<currentdetermination>true</currentdetermination> |
|
| 522 |
<determinationdate>epoch</determinationdate> |
|
| 523 |
<party_id> |
|
| 524 |
<party/> |
|
| 525 |
</party_id> |
|
| 526 |
<plantname_id> |
|
| 527 |
<plantname> |
|
| 528 |
<plantname>Scrophulariaceae</plantname> |
|
| 529 |
</plantname> |
|
| 530 |
</plantname_id> |
|
| 531 |
</taxondetermination> |
|
| 532 |
<taxondetermination> |
|
| 533 |
<role_id> |
|
| 534 |
<aux_role> |
|
| 535 |
<rolecode>identifier</rolecode> |
|
| 536 |
</aux_role> |
|
| 537 |
</role_id> |
|
| 538 |
<determinationtype>Author</determinationtype> |
|
| 539 |
<originaldetermination>true</originaldetermination> |
|
| 540 |
<currentdetermination>true</currentdetermination> |
|
| 541 |
<determinationdate>epoch</determinationdate> |
|
| 542 |
<party_id> |
|
| 543 |
<party/> |
|
| 544 |
</party_id> |
|
| 545 |
<plantname_id> |
|
| 546 |
<plantname> |
|
| 547 |
<plantname>Scrophulariaceae</plantname> |
|
| 548 |
</plantname> |
|
| 549 |
</plantname_id> |
|
| 550 |
</taxondetermination> |
|
| 551 | 487 |
</taxonoccurrence> |
| 552 | 488 |
</VegBIEN> |
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 1 |
SALVIAS:plotMetadata,VegBIEN:/plotevent,Comments |
|
| 1 |
SALVIAS:plotMetadata,VegBIEN:/locationevent,Comments |
|
| 2 |
plot_area_ha,/*_id/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed" |
|
| 3 |
Elev,/*_id/location/elevation/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
|
| 4 |
Country,"/*_id/location/place(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
|
| 5 |
PolDiv1,"/*_id/location/place(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince |
|
| 6 |
MajorGeo,/*_id/location/place(/*_id/namedplace[placesystem=continent])/placename, |
|
| 7 |
pol2,/*_id/location/place(/*_id/namedplace[placesystem=county])/placename,Brad: No pol2=countyParish |
|
| 8 |
Locality_Description,/*_id/location/place/*_id/namedplace/placedescription,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX" |
|
| 9 |
LatDec,/*_id/location/reallatitude, |
|
| 10 |
LongDec,/*_id/location/reallongitude, |
|
| 11 |
slope_aspect,/*_id/location/slopeaspect, |
|
| 12 |
slope_gradient,/*_id/location/slopegradient, |
|
| 13 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
|
| 14 |
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
|
| 15 |
project_id,/*_id/project/projectname, |
|
| 16 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
|
| 17 |
life_zone,/commclass/commdetermination/*_id/commconcept/commdescription, |
|
| 18 |
Precip,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 19 |
Temp,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=temperatureC]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 20 |
PlotMethod,/methodnarrative, |
|
| 21 |
date_finish,/obsenddate/_date/date, |
|
| 22 |
date_start,/obsstartdate/_date/date, |
|
| 23 |
soil_acidity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 24 |
soil_base,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 25 |
soil_Ca,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 26 |
soil_C,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCarbon]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 27 |
soil_cation_cap,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCationCap]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 28 |
soil_conductivity,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilConductivity]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 29 |
soil_Mg,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilMagnesium]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 30 |
soil_N,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilNitrogen]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 31 |
soil_P,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPhosphorus]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 32 |
soil_K,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilPotassium]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 33 |
soil_Na,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilSodium]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue", |
|
| 34 |
clay_percent,/soilobs:[soilhorizon=unknown]/soilclay, |
|
| 35 |
organic_percent,/soilobs:[soilhorizon=unknown]/soilorganic, |
|
| 36 |
pH,/soilobs:[soilhorizon=unknown]/soilph,"Brad: For all these soil variables, how do we store information on method, units. Seems like an ontological structure would be more appropriate (measurementName, measurementValue, measurementUnits, measurementMethod). Same as BIEN traits table. Something to discuss." |
|
| 37 |
sand_percent,/soilobs:[soilhorizon=unknown]/soilsand, |
|
| 38 |
silt_percent,/soilobs:[soilhorizon=unknown]/soilsilt, |
|
| 39 |
soil_texture,/soilobs:[soilhorizon=unknown]/soiltexture, |
|
| 40 |
PlotID,/sourceid/_alt/1,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata." |
|
| 41 |
SiteCode,"/{*_id/location:[confidentialitystatus=0]/sourceid/_alt/2,sourceid/_alt/2}",Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
|
|
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 20 | 20 |
Habit,"/taxondetermination[role_id/aux_role/rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=habit]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 21 | 21 |
Ind,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=individualCode]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 22 | 22 |
Notes,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/notes", |
| 23 |
Family,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 24 |
Genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 25 |
auth,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
|
|
| 26 |
Species,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 27 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname/_name/last,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/last}",
|
|
| 29 |
OrigFamily,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 30 |
OrigSpecies,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}}",Brad: OMIT
|
|
| 23 |
Family,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 24 |
Genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 25 |
auth,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/reference/shortname",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. |
|
| 26 |
Species,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 27 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/_name/last",
|
|
| 29 |
OrigFamily,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",Brad: OMIT
|
|
| 30 |
OrigSpecies,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 31 | 31 |
PlotObsID,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen:[*_id/reference]/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/sourceid/_alt/3}","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.sql | ||
|---|---|---|
| 2510 | 2510 |
CREATE TABLE taxondetermination ( |
| 2511 | 2511 |
taxondetermination_id integer NOT NULL, |
| 2512 | 2512 |
taxonoccurrence_id integer NOT NULL, |
| 2513 |
plantconcept_id integer, |
|
| 2514 |
plantname_id integer NOT NULL,
|
|
| 2513 |
plantconcept_id integer NOT NULL,
|
|
| 2514 |
plantname_id integer, |
|
| 2515 | 2515 |
party_id integer NOT NULL, |
| 2516 | 2516 |
role_id integer NOT NULL, |
| 2517 | 2517 |
determinationtype character varying(30), |
| mappings/SALVIAS_db-VegBIEN.organisms.csv | ||
|---|---|---|
| 20 | 20 |
Habit,"/taxondetermination[role_id/aux_role/rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=habit]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 21 | 21 |
Ind,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=individualCode]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 22 | 22 |
Notes,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/notes", |
| 23 |
Family,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 24 |
Genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 25 |
auth,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
|
|
| 26 |
Species,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 27 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname/_name/last,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/last}",
|
|
| 29 |
OrigFamily,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 30 |
OrigSpecies,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}}",Brad: OMIT
|
|
| 23 |
Family,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 24 |
Genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 25 |
auth,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/reference/shortname",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. |
|
| 26 |
Species,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 27 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/_name/last",
|
|
| 29 |
OrigFamily,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",Brad: OMIT
|
|
| 30 |
OrigSpecies,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 31 | 31 |
PlotObsID,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen:[*_id/reference]/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/sourceid/_alt/3}","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 | ||
|---|---|---|
| 101 | 101 |
/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value,"/taxondetermination[role_id/aux_role/rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue" |
| 102 | 102 |
/simpleUserdefined[name=individualCode]/value,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=individualCode]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue" |
| 103 | 103 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/notes" |
| 104 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 105 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 106 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname" |
|
| 107 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 108 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first}"
|
|
| 109 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname/_name/last,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/last}"
|
|
| 104 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/1" |
|
| 105 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname" |
|
| 106 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname" |
|
| 107 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/reference/shortname" |
|
| 108 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname" |
|
| 109 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Rank","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/_name/first}"
|
|
| 110 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=TaxonomicRankBelowSubspeciesEnum])/Name","/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/_name/last" |
|
| 110 | 111 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day" |
| 111 | 112 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month" |
| 112 | 113 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/year" |
| 113 | 114 |
"/*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[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,originaldetermination=false,currentdetermination=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
|
| 114 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 115 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 116 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 117 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 118 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 115 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname"
|
|
| 116 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname"
|
|
| 117 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname"
|
|
| 118 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname"
|
|
| 119 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname"
|
|
| 119 | 120 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/AccordingTo/Simple","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/reference/referencecontributor/*_id/referenceparty/{givenname,surname}"
|
| 120 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 121 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 122 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname/_alt/1,taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname}"
|
|
| 123 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}}"
|
|
| 121 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname" |
|
| 122 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname" |
|
| 123 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}"
|
|
| 124 | 124 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen:[*_id/reference]/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/sourceid/_alt/3}"
|
| mappings/NYBG-VegBIEN.organisms.csv | ||
|---|---|---|
| 24 | 24 |
Vegetation,"/aggregateoccurrence/individualplant/stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?" |
| 25 | 25 |
Sex,"/taxondetermination[role_id/aux_role/rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| 26 | 26 |
Notes,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/notes","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes" |
| 27 |
ScientificName,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/1","Brad: Bob, Nick, please is this mapping OK?" |
|
| 27 | 28 |
DayIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day", |
| 28 | 29 |
MonthIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month", |
| 29 | 30 |
YearIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/year", |
| 30 | 31 |
IdentifiedBy,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,originaldetermination=false,currentdetermination=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?
|
| 31 |
Class,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 32 |
Family,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 33 |
Genus,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 34 |
Kingdom,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 35 |
Order,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 32 |
Class,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 33 |
Family,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 34 |
Genus,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 35 |
Kingdom,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 36 |
Order,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 36 | 37 |
ScientificNameAuthor,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/reference/referencecontributor/*_id/referenceparty/{givenname,surname}","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"
|
| 37 |
Phylum,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 38 |
Subspecies,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 39 |
ScientificName,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname/_alt/1,taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname}","Brad: Bob, Nick, please is this mapping OK?"
|
|
| 40 |
Species,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}}",
|
|
| 38 |
Phylum,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname", |
|
| 39 |
Subspecies,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname", |
|
| 40 |
Species,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 41 | 41 |
UniqueNYInternalRecordNumber,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen:[*_id/reference]/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/sourceid/_alt/3}","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/for_review/SALVIAS_db-VegBIEN.organisms.csv | ||
|---|---|---|
| 20 | 20 |
Habit,"/taxondetermination[rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=habit]]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 21 | 21 |
Ind,"/taxondetermination[rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=individualCode]]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 22 | 22 |
Notes,/taxondetermination[rolecode=collector]/notes, |
| 23 |
Family,"/taxondetermination[rolecode=computer,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 24 |
Genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 25 |
auth,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
|
|
| 26 |
Species,"/taxondetermination[rolecode=computer,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 27 |
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/*_id/*/plantname/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/last,*_id/plantconcept/*_id/*/plantname/_name/last}",
|
|
| 29 |
OrigFamily,"/taxondetermination[rolecode=identifier,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
|
|
| 30 |
OrigSpecies,"/{taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2,taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}}",Brad: OMIT
|
|
| 23 |
Family,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",
|
|
| 24 |
Genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",
|
|
| 25 |
auth,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/reference/shortname",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. |
|
| 26 |
Species,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",
|
|
| 27 |
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/_name/last",
|
|
| 29 |
OrigFamily,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
|
|
| 30 |
OrigSpecies,"/{taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
|
|
| 31 | 31 |
PlotObsID,"/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location/sourceid/_alt/3}","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/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 101 | 101 |
//individualOrganism/simpleUserdefined[name=sex]/value,"/taxondetermination[rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]/definedvalue" |
| 102 | 102 |
/simpleUserdefined[name=individualCode]/value,"/taxondetermination[rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=individualCode]]/definedvalue" |
| 103 | 103 |
//note/text,/taxondetermination[rolecode=collector]/notes |
| 104 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=computer,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 105 |
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=computer,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 106 |
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname" |
|
| 107 |
//*s/taxonConcept[@code=sp]/Name,"/taxondetermination[rolecode=computer,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 108 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/*_id/*/plantname/_name/first}"
|
|
| 109 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/last,*_id/plantconcept/*_id/*/plantname/_name/last}"
|
|
| 104 |
//taxonName/Simple,/taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/1 |
|
| 105 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname" |
|
| 106 |
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname" |
|
| 107 |
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/reference/shortname" |
|
| 108 |
//*s/taxonConcept[@code=sp]/Name,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname" |
|
| 109 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/_name/first}"
|
|
| 110 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/_name/last" |
|
| 110 | 111 |
//*s/taxonDetermination[role=identifier]/date/_date/day,/taxondetermination[rolecode=identifier]/determinationdate/_date/day |
| 111 | 112 |
//*s/taxonDetermination[role=identifier]/date/_date/month,/taxondetermination[rolecode=identifier]/determinationdate/_date/month |
| 112 | 113 |
//*s/taxonDetermination[role=identifier]/date/_date/year,/taxondetermination[rolecode=identifier]/determinationdate/_date/year |
| 113 | 114 |
"//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[rolecode=identifier]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
|
| 114 |
//*s/taxonConcept[@code=cl]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Class]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 115 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 116 |
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 117 |
//*s/taxonConcept[@code=reg]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 118 |
//*s/taxonConcept[@code=ord]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Order]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 115 |
//*s/taxonConcept[@code=cl]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Class]/*_id/plantconcept/*_id/*/plantname"
|
|
| 116 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname"
|
|
| 117 |
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname"
|
|
| 118 |
//*s/taxonConcept[@code=reg]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/*_id/plantconcept/*_id/*/plantname"
|
|
| 119 |
//*s/taxonConcept[@code=ord]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Order]/*_id/plantconcept/*_id/*/plantname"
|
|
| 119 | 120 |
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/reference/referencecontributor/*_id/referenceparty/{givenname,surname}"
|
| 120 |
//*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 121 |
//*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 122 |
//taxonName/Simple,"/{taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/1,taxondetermination[rolecode=identifier]/*_id/*/plantname}"
|
|
| 123 |
//*s/taxonConcept[@code=sp]/Name,"/{taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2,taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}}"
|
|
| 121 |
//*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname" |
|
| 122 |
//*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname" |
|
| 123 |
//*s/taxonConcept[@code=sp]/Name,"/{taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname}"
|
|
| 124 | 124 |
//taxonNameUsageConcept/voucher,"/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location/sourceid/_alt/3}"
|
| mappings/for_review/NYBG-VegBIEN.organisms.csv | ||
|---|---|---|
| 24 | 24 |
Vegetation,"//stem/definedvalue[*_id/userdefined[tablename=stem,userdefinedname=vegetation]]/definedvalue","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Habitat'. Bob, Nick: keep as user defined or create special element?" |
| 25 | 25 |
Sex,"/taxondetermination[rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| 26 | 26 |
Notes,/taxondetermination[rolecode=collector]/notes,"Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes" |
| 27 |
ScientificName,/taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/1,"Brad: Bob, Nick, please is this mapping OK?" |
|
| 27 | 28 |
DayIdentified,/taxondetermination[rolecode=identifier]/determinationdate/_date/day, |
| 28 | 29 |
MonthIdentified,/taxondetermination[rolecode=identifier]/determinationdate/_date/month, |
| 29 | 30 |
YearIdentified,/taxondetermination[rolecode=identifier]/determinationdate/_date/year, |
| 30 | 31 |
IdentifiedBy,"/taxondetermination[rolecode=identifier]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?
|
| 31 |
Class,"/taxondetermination[rolecode=identifier,plantlevel=Class]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 32 |
Family,"/taxondetermination[rolecode=identifier,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 33 |
Genus,"/taxondetermination[rolecode=identifier,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 34 |
Kingdom,"/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 35 |
Order,"/taxondetermination[rolecode=identifier,plantlevel=Order]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 32 |
Class,"/taxondetermination[rolecode=identifier,plantlevel=Class]/*_id/plantconcept/*_id/*/plantname",
|
|
| 33 |
Family,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",
|
|
| 34 |
Genus,"/taxondetermination[rolecode=identifier,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",
|
|
| 35 |
Kingdom,"/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/*_id/plantconcept/*_id/*/plantname",
|
|
| 36 |
Order,"/taxondetermination[rolecode=identifier,plantlevel=Order]/*_id/plantconcept/*_id/*/plantname",
|
|
| 36 | 37 |
ScientificNameAuthor,"/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/reference/referencecontributor/*_id/referenceparty/{givenname,surname}","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"
|
| 37 |
Phylum,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 38 |
Subspecies,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 39 |
ScientificName,"/{taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/1,taxondetermination[rolecode=identifier]/*_id/*/plantname}","Brad: Bob, Nick, please is this mapping OK?"
|
|
| 40 |
Species,"/{taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2,taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}}",
|
|
| 38 |
Phylum,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname", |
|
| 39 |
Subspecies,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname", |
|
| 40 |
Species,"/{taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname}",
|
|
| 41 | 41 |
UniqueNYInternalRecordNumber,"/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location/sourceid/_alt/3}","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/for_review/SALVIAS-VegBIEN.organisms.csv | ||
|---|---|---|
| 29 | 29 |
habit,"/taxondetermination[rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=habit]]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 30 | 30 |
individual_code,"/taxondetermination[rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=individualCode]]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 31 | 31 |
notes,/taxondetermination[rolecode=collector]/notes, |
| 32 |
family,"/taxondetermination[rolecode=computer,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 33 |
genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 34 |
specific_authority,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
|
|
| 35 |
specific_epithet,"/taxondetermination[rolecode=computer,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 36 |
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/*_id/*/plantname/_name/first}",
|
|
| 37 |
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/last,*_id/plantconcept/*_id/*/plantname/_name/last}",
|
|
| 38 |
orig_family,"/taxondetermination[rolecode=identifier,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
|
|
| 39 |
orig_species,"/{taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2,taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}}",Brad: OMIT
|
|
| 32 |
family,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",
|
|
| 33 |
genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",
|
|
| 34 |
specific_authority,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/reference/shortname",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. |
|
| 35 |
specific_epithet,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",
|
|
| 36 |
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/_name/first}",
|
|
| 37 |
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/_name/last",
|
|
| 38 |
orig_family,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
|
|
| 39 |
orig_species,"/{taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
|
|
| 40 | 40 |
OBSERVATION_ID,"/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location/sourceid/_alt/3}","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/SALVIAS-VegBIEN.organisms.csv | ||
|---|---|---|
| 29 | 29 |
habit,"/taxondetermination[role_id/aux_role/rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=habit]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Incorrect for VegBank, correct for VegX. This is growth form (tree, shrub, herb, etc.). It is an observation of a trait." |
| 30 | 30 |
individual_code,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=individualCode]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot." |
| 31 | 31 |
notes,"/taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=false,currentdetermination=true,*_id/party]/notes", |
| 32 |
family,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 33 |
genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 34 |
specific_authority,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname",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.
|
|
| 35 |
specific_epithet,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",
|
|
| 36 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first}",
|
|
| 37 |
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname/_name/last,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/last}",
|
|
| 38 |
orig_family,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 39 |
orig_species,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}}",Brad: OMIT
|
|
| 32 |
family,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 33 |
genus,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 34 |
specific_authority,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]/*_id/plantconcept/*_id/reference/shortname",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. |
|
| 35 |
specific_epithet,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 36 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/_name/first}",
|
|
| 37 |
infra_ep_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",originaldetermination=false,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/_name/last",
|
|
| 38 |
orig_family,"/taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",Brad: OMIT
|
|
| 39 |
orig_species,"/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/aux_role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 40 | 40 |
OBSERVATION_ID,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/sourceid,aggregateoccurrence/individualplant/specimen:[*_id/reference]/sourceaccessionnumber,*_id/locationevent/sourceid/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/sourceid/_alt/3}","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
VegBIEN: Made taxondetermination.plantconcept_id required and plantname_id optional