Revision 421
Added by Aaron Marcuse-Kubitza about 13 years ago
| test/accepted_output/SALVIAS.organisms.VegBIEN.xml | ||
|---|---|---|
| 70 | 70 |
</userdefined_id> |
| 71 | 71 |
<definedvalue>10</definedvalue> |
| 72 | 72 |
</definedvalue> |
| 73 |
<plantconcept_id> |
|
| 74 |
<plantconcept> |
|
| 75 |
<plantname_id> |
|
| 76 |
<plantname> |
|
| 77 |
<plantname>Inga indet</plantname> |
|
| 78 |
</plantname> |
|
| 79 |
</plantname_id> |
|
| 80 |
<reference_id> |
|
| 81 |
<reference/> |
|
| 82 |
</reference_id> |
|
| 83 |
</plantconcept> |
|
| 84 |
</plantconcept_id> |
|
| 73 |
<plantname_id> |
|
| 74 |
<plantname> |
|
| 75 |
<plantname>Inga indet</plantname> |
|
| 76 |
</plantname> |
|
| 77 |
</plantname_id> |
|
| 85 | 78 |
<determinationtype>Author</determinationtype> |
| 86 | 79 |
<originaldetermination>true</originaldetermination> |
| 87 | 80 |
<currentdetermination>false</currentdetermination> |
| ... | ... | |
| 124 | 117 |
<party_id> |
| 125 | 118 |
<party/> |
| 126 | 119 |
</party_id> |
| 120 |
<plantname_id> |
|
| 121 |
<plantname> |
|
| 122 |
<plantname>Fabaceae</plantname> |
|
| 123 |
</plantname> |
|
| 124 |
</plantname_id> |
|
| 127 | 125 |
</taxondetermination> |
| 128 | 126 |
<taxondetermination> |
| 129 | 127 |
<role_id> |
| ... | ... | |
| 158 | 156 |
<party_id> |
| 159 | 157 |
<party/> |
| 160 | 158 |
</party_id> |
| 159 |
<plantname_id> |
|
| 160 |
<plantname> |
|
| 161 |
<plantname>Inga</plantname> |
|
| 162 |
</plantname> |
|
| 163 |
</plantname_id> |
|
| 161 | 164 |
</taxondetermination> |
| 162 | 165 |
<taxondetermination> |
| 163 | 166 |
<role_id> |
| ... | ... | |
| 192 | 195 |
<party_id> |
| 193 | 196 |
<party/> |
| 194 | 197 |
</party_id> |
| 198 |
<plantname_id> |
|
| 199 |
<plantname> |
|
| 200 |
<plantname>indet</plantname> |
|
| 201 |
</plantname> |
|
| 202 |
</plantname_id> |
|
| 195 | 203 |
</taxondetermination> |
| 196 | 204 |
<taxondetermination> |
| 197 | 205 |
<role_id> |
| ... | ... | |
| 226 | 234 |
<party_id> |
| 227 | 235 |
<party/> |
| 228 | 236 |
</party_id> |
| 237 |
<plantname_id> |
|
| 238 |
<plantname> |
|
| 239 |
<plantname>Fabaceae</plantname> |
|
| 240 |
</plantname> |
|
| 241 |
</plantname_id> |
|
| 229 | 242 |
</taxondetermination> |
| 230 | 243 |
<taxondetermination> |
| 231 | 244 |
<role_id> |
| ... | ... | |
| 260 | 273 |
<party_id> |
| 261 | 274 |
<party/> |
| 262 | 275 |
</party_id> |
| 276 |
<plantname_id> |
|
| 277 |
<plantname> |
|
| 278 |
<plantname>Inga indet</plantname> |
|
| 279 |
</plantname> |
|
| 280 |
</plantname_id> |
|
| 263 | 281 |
</taxondetermination> |
| 264 | 282 |
</taxonoccurrence> |
| 265 | 283 |
<taxonoccurrence id="1"> |
| ... | ... | |
| 332 | 350 |
</userdefined_id> |
| 333 | 351 |
<definedvalue>100</definedvalue> |
| 334 | 352 |
</definedvalue> |
| 335 |
<plantconcept_id> |
|
| 336 |
<plantconcept> |
|
| 337 |
<plantname_id> |
|
| 338 |
<plantname> |
|
| 339 |
<plantname>Virola pavonis</plantname> |
|
| 340 |
</plantname> |
|
| 341 |
</plantname_id> |
|
| 342 |
<reference_id> |
|
| 343 |
<reference/> |
|
| 344 |
</reference_id> |
|
| 345 |
</plantconcept> |
|
| 346 |
</plantconcept_id> |
|
| 353 |
<plantname_id> |
|
| 354 |
<plantname> |
|
| 355 |
<plantname>Virola pavonis</plantname> |
|
| 356 |
</plantname> |
|
| 357 |
</plantname_id> |
|
| 347 | 358 |
<determinationtype>Author</determinationtype> |
| 348 | 359 |
<originaldetermination>true</originaldetermination> |
| 349 | 360 |
<currentdetermination>false</currentdetermination> |
| ... | ... | |
| 386 | 397 |
<party_id> |
| 387 | 398 |
<party/> |
| 388 | 399 |
</party_id> |
| 400 |
<plantname_id> |
|
| 401 |
<plantname> |
|
| 402 |
<plantname>Myristicaceae</plantname> |
|
| 403 |
</plantname> |
|
| 404 |
</plantname_id> |
|
| 389 | 405 |
</taxondetermination> |
| 390 | 406 |
<taxondetermination> |
| 391 | 407 |
<role_id> |
| ... | ... | |
| 420 | 436 |
<party_id> |
| 421 | 437 |
<party/> |
| 422 | 438 |
</party_id> |
| 439 |
<plantname_id> |
|
| 440 |
<plantname> |
|
| 441 |
<plantname>Virola</plantname> |
|
| 442 |
</plantname> |
|
| 443 |
</plantname_id> |
|
| 423 | 444 |
</taxondetermination> |
| 424 | 445 |
<taxondetermination> |
| 425 | 446 |
<role_id> |
| ... | ... | |
| 454 | 475 |
<party_id> |
| 455 | 476 |
<party/> |
| 456 | 477 |
</party_id> |
| 478 |
<plantname_id> |
|
| 479 |
<plantname> |
|
| 480 |
<plantname>pavonis</plantname> |
|
| 481 |
</plantname> |
|
| 482 |
</plantname_id> |
|
| 457 | 483 |
</taxondetermination> |
| 458 | 484 |
<taxondetermination> |
| 459 | 485 |
<role_id> |
| ... | ... | |
| 488 | 514 |
<party_id> |
| 489 | 515 |
<party/> |
| 490 | 516 |
</party_id> |
| 517 |
<plantname_id> |
|
| 518 |
<plantname> |
|
| 519 |
<plantname>Myristicaceae</plantname> |
|
| 520 |
</plantname> |
|
| 521 |
</plantname_id> |
|
| 491 | 522 |
</taxondetermination> |
| 492 | 523 |
<taxondetermination> |
| 493 | 524 |
<role_id> |
| ... | ... | |
| 522 | 553 |
<party_id> |
| 523 | 554 |
<party/> |
| 524 | 555 |
</party_id> |
| 556 |
<plantname_id> |
|
| 557 |
<plantname> |
|
| 558 |
<plantname>Virola pavonis</plantname> |
|
| 559 |
</plantname> |
|
| 560 |
</plantname_id> |
|
| 525 | 561 |
</taxondetermination> |
| 526 | 562 |
</taxonoccurrence> |
| 527 | 563 |
</VegBIEN> |
| test/accepted_output/SALVIAS_db.organisms.VegBIEN.xml | ||
|---|---|---|
| 61 | 61 |
</userdefined_id> |
| 62 | 62 |
<definedvalue>1</definedvalue> |
| 63 | 63 |
</definedvalue> |
| 64 |
<plantconcept_id> |
|
| 65 |
<plantconcept> |
|
| 66 |
<plantname_id> |
|
| 67 |
<plantname> |
|
| 68 |
<plantname>seleri</plantname> |
|
| 69 |
</plantname> |
|
| 70 |
</plantname_id> |
|
| 71 |
<reference_id> |
|
| 72 |
<reference/> |
|
| 73 |
</reference_id> |
|
| 74 |
</plantconcept> |
|
| 75 |
</plantconcept_id> |
|
| 64 |
<plantname_id> |
|
| 65 |
<plantname> |
|
| 66 |
<plantname>seleri</plantname> |
|
| 67 |
</plantname> |
|
| 68 |
</plantname_id> |
|
| 76 | 69 |
<determinationtype>Author</determinationtype> |
| 77 | 70 |
<originaldetermination>true</originaldetermination> |
| 78 | 71 |
<currentdetermination>false</currentdetermination> |
| ... | ... | |
| 115 | 108 |
<party_id> |
| 116 | 109 |
<party/> |
| 117 | 110 |
</party_id> |
| 111 |
<plantname_id> |
|
| 112 |
<plantname> |
|
| 113 |
<plantname>Arecaceae</plantname> |
|
| 114 |
</plantname> |
|
| 115 |
</plantname_id> |
|
| 118 | 116 |
</taxondetermination> |
| 119 | 117 |
<taxondetermination> |
| 120 | 118 |
<role_id> |
| ... | ... | |
| 149 | 147 |
<party_id> |
| 150 | 148 |
<party/> |
| 151 | 149 |
</party_id> |
| 150 |
<plantname_id> |
|
| 151 |
<plantname> |
|
| 152 |
<plantname>Geonoma</plantname> |
|
| 153 |
</plantname> |
|
| 154 |
</plantname_id> |
|
| 152 | 155 |
</taxondetermination> |
| 153 | 156 |
<taxondetermination> |
| 154 | 157 |
<role_id> |
| ... | ... | |
| 188 | 191 |
<party_id> |
| 189 | 192 |
<party/> |
| 190 | 193 |
</party_id> |
| 194 |
<plantname_id> |
|
| 195 |
<plantname> |
|
| 196 |
<plantname>seleri</plantname> |
|
| 197 |
</plantname> |
|
| 198 |
</plantname_id> |
|
| 191 | 199 |
</taxondetermination> |
| 192 | 200 |
<taxondetermination> |
| 193 | 201 |
<role_id> |
| ... | ... | |
| 222 | 230 |
<party_id> |
| 223 | 231 |
<party/> |
| 224 | 232 |
</party_id> |
| 233 |
<plantname_id> |
|
| 234 |
<plantname> |
|
| 235 |
<plantname>Arecaceae</plantname> |
|
| 236 |
</plantname> |
|
| 237 |
</plantname_id> |
|
| 225 | 238 |
</taxondetermination> |
| 226 | 239 |
<taxondetermination> |
| 227 | 240 |
<role_id> |
| ... | ... | |
| 256 | 269 |
<party_id> |
| 257 | 270 |
<party/> |
| 258 | 271 |
</party_id> |
| 272 |
<plantname_id> |
|
| 273 |
<plantname> |
|
| 274 |
<plantname>seleri</plantname> |
|
| 275 |
</plantname> |
|
| 276 |
</plantname_id> |
|
| 259 | 277 |
</taxondetermination> |
| 260 | 278 |
</taxonoccurrence> |
| 261 | 279 |
<taxonoccurrence id="1"> |
| ... | ... | |
| 319 | 337 |
</userdefined_id> |
| 320 | 338 |
<definedvalue>2</definedvalue> |
| 321 | 339 |
</definedvalue> |
| 322 |
<plantconcept_id> |
|
| 323 |
<plantconcept> |
|
| 324 |
<plantname_id> |
|
| 325 |
<plantname> |
|
| 326 |
<plantname>allenii</plantname> |
|
| 327 |
</plantname> |
|
| 328 |
</plantname_id> |
|
| 329 |
<reference_id> |
|
| 330 |
<reference/> |
|
| 331 |
</reference_id> |
|
| 332 |
</plantconcept> |
|
| 333 |
</plantconcept_id> |
|
| 340 |
<plantname_id> |
|
| 341 |
<plantname> |
|
| 342 |
<plantname>allenii</plantname> |
|
| 343 |
</plantname> |
|
| 344 |
</plantname_id> |
|
| 334 | 345 |
<determinationtype>Author</determinationtype> |
| 335 | 346 |
<originaldetermination>true</originaldetermination> |
| 336 | 347 |
<currentdetermination>false</currentdetermination> |
| ... | ... | |
| 373 | 384 |
<party_id> |
| 374 | 385 |
<party/> |
| 375 | 386 |
</party_id> |
| 387 |
<plantname_id> |
|
| 388 |
<plantname> |
|
| 389 |
<plantname>Clusiaceae</plantname> |
|
| 390 |
</plantname> |
|
| 391 |
</plantname_id> |
|
| 376 | 392 |
</taxondetermination> |
| 377 | 393 |
<taxondetermination> |
| 378 | 394 |
<role_id> |
| ... | ... | |
| 407 | 423 |
<party_id> |
| 408 | 424 |
<party/> |
| 409 | 425 |
</party_id> |
| 426 |
<plantname_id> |
|
| 427 |
<plantname> |
|
| 428 |
<plantname>Tovomitopsis</plantname> |
|
| 429 |
</plantname> |
|
| 430 |
</plantname_id> |
|
| 410 | 431 |
</taxondetermination> |
| 411 | 432 |
<taxondetermination> |
| 412 | 433 |
<role_id> |
| ... | ... | |
| 446 | 467 |
<party_id> |
| 447 | 468 |
<party/> |
| 448 | 469 |
</party_id> |
| 470 |
<plantname_id> |
|
| 471 |
<plantname> |
|
| 472 |
<plantname>allenii</plantname> |
|
| 473 |
</plantname> |
|
| 474 |
</plantname_id> |
|
| 449 | 475 |
</taxondetermination> |
| 450 | 476 |
<taxondetermination> |
| 451 | 477 |
<role_id> |
| ... | ... | |
| 480 | 506 |
<party_id> |
| 481 | 507 |
<party/> |
| 482 | 508 |
</party_id> |
| 509 |
<plantname_id> |
|
| 510 |
<plantname> |
|
| 511 |
<plantname>Clusiaceae</plantname> |
|
| 512 |
</plantname> |
|
| 513 |
</plantname_id> |
|
| 483 | 514 |
</taxondetermination> |
| 484 | 515 |
<taxondetermination> |
| 485 | 516 |
<role_id> |
| ... | ... | |
| 514 | 545 |
<party_id> |
| 515 | 546 |
<party/> |
| 516 | 547 |
</party_id> |
| 548 |
<plantname_id> |
|
| 549 |
<plantname> |
|
| 550 |
<plantname>allenii</plantname> |
|
| 551 |
</plantname> |
|
| 552 |
</plantname_id> |
|
| 517 | 553 |
</taxondetermination> |
| 518 | 554 |
</taxonoccurrence> |
| 519 | 555 |
</VegBIEN> |
| test/accepted_output/NYBG.organisms.VegBIEN.xml | ||
|---|---|---|
| 88 | 88 |
<organizationname>NY Herbarium</organizationname> |
| 89 | 89 |
</party> |
| 90 | 90 |
</museum_id> |
| 91 |
<plantconcept_id> |
|
| 92 |
<plantconcept> |
|
| 93 |
<reference_id> |
|
| 94 |
<reference/> |
|
| 95 |
</reference_id> |
|
| 96 |
<plantname_id> |
|
| 97 |
<plantname> |
|
| 98 |
<plantname>Cariniana estrellensis (Raddi) Kuntze</plantname> |
|
| 99 |
</plantname> |
|
| 100 |
</plantname_id> |
|
| 101 |
</plantconcept> |
|
| 102 |
</plantconcept_id> |
|
| 91 |
<plantname_id> |
|
| 92 |
<plantname> |
|
| 93 |
<plantname>Cariniana estrellensis (Raddi) Kuntze</plantname> |
|
| 94 |
</plantname> |
|
| 95 |
</plantname_id> |
|
| 103 | 96 |
<determinationtype>Author</determinationtype> |
| 104 | 97 |
<originaldetermination>true</originaldetermination> |
| 105 | 98 |
<currentdetermination>false</currentdetermination> |
| ... | ... | |
| 142 | 135 |
<party_id> |
| 143 | 136 |
<party/> |
| 144 | 137 |
</party_id> |
| 138 |
<plantname_id> |
|
| 139 |
<plantname> |
|
| 140 |
<plantname>Lecythidaceae</plantname> |
|
| 141 |
</plantname> |
|
| 142 |
</plantname_id> |
|
| 145 | 143 |
</taxondetermination> |
| 146 | 144 |
<taxondetermination> |
| 147 | 145 |
<role_id> |
| ... | ... | |
| 176 | 174 |
<party_id> |
| 177 | 175 |
<party/> |
| 178 | 176 |
</party_id> |
| 177 |
<plantname_id> |
|
| 178 |
<plantname> |
|
| 179 |
<plantname>Cariniana</plantname> |
|
| 180 |
</plantname> |
|
| 181 |
</plantname_id> |
|
| 179 | 182 |
</taxondetermination> |
| 180 | 183 |
<taxondetermination> |
| 181 | 184 |
<role_id> |
| ... | ... | |
| 210 | 213 |
<party_id> |
| 211 | 214 |
<party/> |
| 212 | 215 |
</party_id> |
| 216 |
<plantname_id> |
|
| 217 |
<plantname> |
|
| 218 |
<plantname>Plantae</plantname> |
|
| 219 |
</plantname> |
|
| 220 |
</plantname_id> |
|
| 213 | 221 |
</taxondetermination> |
| 214 | 222 |
<taxondetermination> |
| 215 | 223 |
<role_id> |
| ... | ... | |
| 253 | 261 |
<party_id> |
| 254 | 262 |
<party/> |
| 255 | 263 |
</party_id> |
| 264 |
<plantname_id> |
|
| 265 |
<plantname> |
|
| 266 |
<plantname>estrellensis</plantname> |
|
| 267 |
</plantname> |
|
| 268 |
</plantname_id> |
|
| 256 | 269 |
</taxondetermination> |
| 257 | 270 |
<taxondetermination> |
| 258 | 271 |
<role_id> |
| ... | ... | |
| 287 | 300 |
<party_id> |
| 288 | 301 |
<party/> |
| 289 | 302 |
</party_id> |
| 303 |
<plantname_id> |
|
| 304 |
<plantname> |
|
| 305 |
<plantname>Magnoliophyta (flowering plants)</plantname> |
|
| 306 |
</plantname> |
|
| 307 |
</plantname_id> |
|
| 290 | 308 |
</taxondetermination> |
| 291 | 309 |
<taxondetermination> |
| 292 | 310 |
<role_id> |
| ... | ... | |
| 301 | 319 |
<party_id> |
| 302 | 320 |
<party/> |
| 303 | 321 |
</party_id> |
| 304 |
<plantconcept_id> |
|
| 305 |
<plantconcept> |
|
| 306 |
<reference_id> |
|
| 307 |
<reference/> |
|
| 308 |
</reference_id> |
|
| 309 |
<plantname_id> |
|
| 310 |
<plantname> |
|
| 311 |
<plantname>Cariniana estrellensis (Raddi) Kuntze</plantname> |
|
| 312 |
</plantname> |
|
| 313 |
</plantname_id> |
|
| 314 |
</plantconcept> |
|
| 315 |
</plantconcept_id> |
|
| 322 |
<plantname_id> |
|
| 323 |
<plantname> |
|
| 324 |
<plantname>Cariniana estrellensis (Raddi) Kuntze</plantname> |
|
| 325 |
</plantname> |
|
| 326 |
</plantname_id> |
|
| 316 | 327 |
</taxondetermination> |
| 317 | 328 |
</taxonoccurrence> |
| 318 | 329 |
<taxonoccurrence id="1"> |
| ... | ... | |
| 368 | 379 |
<organizationname>NY Herbarium</organizationname> |
| 369 | 380 |
</party> |
| 370 | 381 |
</museum_id> |
| 371 |
<plantconcept_id> |
|
| 372 |
<plantconcept> |
|
| 373 |
<reference_id> |
|
| 374 |
<reference/> |
|
| 375 |
</reference_id> |
|
| 376 |
<plantname_id> |
|
| 377 |
<plantname> |
|
| 378 |
<plantname>Scrophulariaceae</plantname> |
|
| 379 |
</plantname> |
|
| 380 |
</plantname_id> |
|
| 381 |
</plantconcept> |
|
| 382 |
</plantconcept_id> |
|
| 382 |
<plantname_id> |
|
| 383 |
<plantname> |
|
| 384 |
<plantname>Scrophulariaceae</plantname> |
|
| 385 |
</plantname> |
|
| 386 |
</plantname_id> |
|
| 383 | 387 |
<determinationtype>Author</determinationtype> |
| 384 | 388 |
<originaldetermination>true</originaldetermination> |
| 385 | 389 |
<currentdetermination>false</currentdetermination> |
| ... | ... | |
| 422 | 426 |
<party_id> |
| 423 | 427 |
<party/> |
| 424 | 428 |
</party_id> |
| 429 |
<plantname_id> |
|
| 430 |
<plantname> |
|
| 431 |
<plantname>Scrophulariaceae</plantname> |
|
| 432 |
</plantname> |
|
| 433 |
</plantname_id> |
|
| 425 | 434 |
</taxondetermination> |
| 426 | 435 |
<taxondetermination> |
| 427 | 436 |
<role_id> |
| ... | ... | |
| 456 | 465 |
<party_id> |
| 457 | 466 |
<party/> |
| 458 | 467 |
</party_id> |
| 468 |
<plantname_id> |
|
| 469 |
<plantname> |
|
| 470 |
<plantname>Plantae</plantname> |
|
| 471 |
</plantname> |
|
| 472 |
</plantname_id> |
|
| 459 | 473 |
</taxondetermination> |
| 460 | 474 |
<taxondetermination> |
| 461 | 475 |
<role_id> |
| ... | ... | |
| 490 | 504 |
<party_id> |
| 491 | 505 |
<party/> |
| 492 | 506 |
</party_id> |
| 507 |
<plantname_id> |
|
| 508 |
<plantname> |
|
| 509 |
<plantname>Magnoliophyta (flowering plants)</plantname> |
|
| 510 |
</plantname> |
|
| 511 |
</plantname_id> |
|
| 493 | 512 |
</taxondetermination> |
| 494 | 513 |
<taxondetermination> |
| 495 | 514 |
<role_id> |
| ... | ... | |
| 504 | 523 |
<party_id> |
| 505 | 524 |
<party/> |
| 506 | 525 |
</party_id> |
| 507 |
<plantconcept_id> |
|
| 508 |
<plantconcept> |
|
| 509 |
<reference_id> |
|
| 510 |
<reference/> |
|
| 511 |
</reference_id> |
|
| 512 |
<plantname_id> |
|
| 513 |
<plantname> |
|
| 514 |
<plantname>Scrophulariaceae</plantname> |
|
| 515 |
</plantname> |
|
| 516 |
</plantname_id> |
|
| 517 |
</plantconcept> |
|
| 518 |
</plantconcept_id> |
|
| 526 |
<plantname_id> |
|
| 527 |
<plantname> |
|
| 528 |
<plantname>Scrophulariaceae</plantname> |
|
| 529 |
</plantname> |
|
| 530 |
</plantname_id> |
|
| 519 | 531 |
</taxondetermination> |
| 520 | 532 |
<collectiveobservation> |
| 521 | 533 |
<count>1</count> |
| inputs/SALVIAS/map.VegBIEN.organisms.csv | ||
|---|---|---|
| 21 | 21 |
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." |
| 22 | 22 |
Ind,"/taxondetermination[role_id/aux_role/rolecode=collector]/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." |
| 23 | 23 |
Notes,/taxondetermination[role_id/aux_role/rolecode=collector]/notes, |
| 24 |
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",
|
|
| 25 |
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",
|
|
| 24 |
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}",
|
|
| 25 |
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}",
|
|
| 26 | 26 |
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. |
| 27 |
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", |
|
| 28 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first", |
|
| 29 |
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]/*_id/*/plantname/_name/last", |
|
| 30 |
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 |
|
| 31 |
OrigSpecies,"/{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,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 32 |
PlotObsID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/plantconcept:[*_id/reference],*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_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."
|
|
| 27 |
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}",
|
|
| 28 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/first",
|
|
| 29 |
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,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/last",
|
|
| 30 |
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
|
|
| 31 |
OrigSpecies,"/{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},taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 32 |
PlotObsID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_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."
|
|
| inputs/SALVIAS/test.organisms.ref | ||
|---|---|---|
| 1 |
Inserted 57 rows |
|
| 1 |
Inserted 55 rows |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2386 | 2386 |
taxonoccurrence_id integer NOT NULL, |
| 2387 | 2387 |
stemobservation_id integer, |
| 2388 | 2388 |
plantconcept_id integer, |
| 2389 |
plantname_id integer, |
|
| 2389 |
plantname_id integer NOT NULL,
|
|
| 2390 | 2390 |
party_id integer NOT NULL, |
| 2391 | 2391 |
role_id integer NOT NULL, |
| 2392 | 2392 |
determinationtype character varying(30), |
| mappings/SALVIAS_db-VegBIEN.organisms.csv | ||
|---|---|---|
| 21 | 21 |
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." |
| 22 | 22 |
Ind,"/taxondetermination[role_id/aux_role/rolecode=collector]/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." |
| 23 | 23 |
Notes,/taxondetermination[role_id/aux_role/rolecode=collector]/notes, |
| 24 |
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",
|
|
| 25 |
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",
|
|
| 24 |
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}",
|
|
| 25 |
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}",
|
|
| 26 | 26 |
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. |
| 27 |
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", |
|
| 28 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first", |
|
| 29 |
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]/*_id/*/plantname/_name/last", |
|
| 30 |
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 |
|
| 31 |
OrigSpecies,"/{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,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 32 |
PlotObsID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/plantconcept:[*_id/reference],*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_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."
|
|
| 27 |
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}",
|
|
| 28 |
infra_rank_1,"/taxondetermination[role_id/aux_role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/first",
|
|
| 29 |
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,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/last",
|
|
| 30 |
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
|
|
| 31 |
OrigSpecies,"/{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},taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 32 |
PlotObsID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_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 | ||
|---|---|---|
| 87 | 87 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/first,/taxondetermination[role_id/aux_role/rolecode=collector]/museum_id/party/organizationname/_name/first |
| 88 | 88 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/partyWithRole/*ID->/parties/party/organizationName/_name/last,/taxondetermination[role_id/aux_role/rolecode=collector]/museum_id/party/organizationname/_name/last |
| 89 | 89 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,/taxondetermination[role_id/aux_role/rolecode=collector]/notes |
| 90 |
"/*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"
|
|
| 91 |
"/*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"
|
|
| 90 |
"/*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}"
|
|
| 91 |
"/*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}"
|
|
| 92 | 92 |
"/*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" |
| 93 |
"/*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"
|
|
| 94 |
"/*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/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname/_name/first"
|
|
| 95 |
"/*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]/*_id/*/plantname/_name/last"
|
|
| 96 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept/plantstatus]/determinationdate/_date/day"
|
|
| 97 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept/plantstatus]/determinationdate/_date/month"
|
|
| 98 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept/plantstatus]/determinationdate/_date/year"
|
|
| 99 |
"/*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/plantstatus]:[determinationtype=Author,originaldetermination=false,currentdetermination=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
|
|
| 100 |
"/*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"
|
|
| 101 |
"/*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"
|
|
| 102 |
"/*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"
|
|
| 103 |
"/*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"
|
|
| 104 |
"/*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"
|
|
| 93 |
"/*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}"
|
|
| 94 |
"/*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,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/first"
|
|
| 95 |
"/*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,*_id/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname}/_name/last"
|
|
| 96 |
"/*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" |
|
| 97 |
"/*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" |
|
| 98 |
"/*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" |
|
| 99 |
"/*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}"
|
|
| 100 |
"/*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}"
|
|
| 101 |
"/*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}"
|
|
| 102 |
"/*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}"
|
|
| 103 |
"/*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}"
|
|
| 104 |
"/*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}"
|
|
| 105 | 105 |
"/*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}"
|
| 106 |
"/*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" |
|
| 107 |
"/*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" |
|
| 108 |
"/*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=identifier,!*_id/plantconcept/plantstatus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/1}"
|
|
| 109 |
"/*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=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,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}"
|
|
| 110 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/plantconcept:[*_id/reference],*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_alt/3}"
|
|
| 106 |
"/*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}"
|
|
| 107 |
"/*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}"
|
|
| 108 |
"/*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=identifier,!*_id/plantconcept]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/1}"
|
|
| 109 |
"/*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=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},taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/2}"
|
|
| 110 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_alt/3}"
|
|
| mappings/NYBG-VegBIEN.organisms.csv | ||
|---|---|---|
| 24 | 24 |
InstitutionCode,/taxondetermination[role_id/aux_role/rolecode=collector]/museum_id/party/organizationname/_name/first, |
| 25 | 25 |
CollectionCode,/taxondetermination[role_id/aux_role/rolecode=collector]/museum_id/party/organizationname/_name/last,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| 26 | 26 |
Notes,/taxondetermination[role_id/aux_role/rolecode=collector]/notes,"Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes" |
| 27 |
DayIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept/plantstatus]/determinationdate/_date/day",
|
|
| 28 |
MonthIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept/plantstatus]/determinationdate/_date/month",
|
|
| 29 |
YearIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept/plantstatus]/determinationdate/_date/year",
|
|
| 30 |
IdentifiedBy,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept/plantstatus]:[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/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/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/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/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/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",
|
|
| 27 |
DayIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day", |
|
| 28 |
MonthIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month", |
|
| 29 |
YearIdentified,"/taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/year", |
|
| 30 |
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}",
|
|
| 36 | 36 |
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/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/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname", |
|
| 39 |
ScientificName,"/{taxondetermination[role_id/aux_role/rolecode=identifier,!*_id/plantconcept/plantstatus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/1}","Brad: Bob, Nick, please is this mapping OK?"
|
|
| 40 |
Species,"/{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,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}",
|
|
| 41 |
UniqueNYInternalRecordNumber,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/plantconcept:[*_id/reference],*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_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"
|
|
| 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=identifier,!*_id/plantconcept]:[determinationtype=Author,originaldetermination=true,currentdetermination=true,determinationdate=epoch,*_id/party]/*_id/*/plantname,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/1}","Brad: Bob, Nick, please is this mapping OK?"
|
|
| 40 |
Species,"/{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},taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/2}",
|
|
| 41 |
UniqueNYInternalRecordNumber,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_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 | ||
|---|---|---|
| 21 | 21 |
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." |
| 22 | 22 |
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." |
| 23 | 23 |
Notes,/taxondetermination[rolecode=collector]/notes, |
| 24 |
Family,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",
|
|
| 25 |
Genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",
|
|
| 24 |
Family,"/taxondetermination[rolecode=computer,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 25 |
Genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 26 | 26 |
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. |
| 27 |
Species,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname",
|
|
| 28 |
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
|
|
| 29 |
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/last",
|
|
| 30 |
OrigFamily,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
|
|
| 31 |
OrigSpecies,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname,taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 27 |
Species,"/taxondetermination[rolecode=computer,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",
|
|
| 28 |
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/first",
|
|
| 29 |
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/last",
|
|
| 30 |
OrigFamily,"/taxondetermination[rolecode=identifier,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
|
|
| 31 |
OrigSpecies,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname},taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 32 | 32 |
PlotObsID,"/{taxondetermination[rolecode=collector]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot/authorcode/_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 | ||
|---|---|---|
| 87 | 87 |
//party/organizationName/_name/first,/taxondetermination[rolecode=collector]/museum_id/party/organizationname/_name/first |
| 88 | 88 |
//party/organizationName/_name/last,/taxondetermination[rolecode=collector]/museum_id/party/organizationname/_name/last |
| 89 | 89 |
//note/text,/taxondetermination[rolecode=collector]/notes |
| 90 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=computer,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname"
|
|
| 91 |
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname"
|
|
| 90 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=computer,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 91 |
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=computer,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 92 | 92 |
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/plantname/reference_id/reference/shortname" |
| 93 |
//*s/taxonConcept[@code=sp]/Name,"/taxondetermination[rolecode=computer,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname"
|
|
| 94 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first"
|
|
| 95 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/last"
|
|
| 93 |
//*s/taxonConcept[@code=sp]/Name,"/taxondetermination[rolecode=computer,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 94 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/first"
|
|
| 95 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}/_name/last"
|
|
| 96 | 96 |
//*s/taxonDetermination[role=identifier]/date/_date/day,/taxondetermination[rolecode=identifier]/determinationdate/_date/day |
| 97 | 97 |
//*s/taxonDetermination[role=identifier]/date/_date/month,/taxondetermination[rolecode=identifier]/determinationdate/_date/month |
| 98 | 98 |
//*s/taxonDetermination[role=identifier]/date/_date/year,/taxondetermination[rolecode=identifier]/determinationdate/_date/year |
| 99 | 99 |
"//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[rolecode=identifier]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
|
| 100 |
//*s/taxonConcept[@code=cl]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Class]/*_id/plantconcept/*_id/*/plantname"
|
|
| 101 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname"
|
|
| 102 |
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname"
|
|
| 103 |
//*s/taxonConcept[@code=reg]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/*_id/plantconcept/*_id/*/plantname"
|
|
| 104 |
//*s/taxonConcept[@code=ord]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Order]/*_id/plantconcept/*_id/*/plantname"
|
|
| 100 |
//*s/taxonConcept[@code=cl]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Class]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 101 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Family]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 102 |
//*s/taxonConcept[@code=gen]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Genus]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 103 |
//*s/taxonConcept[@code=reg]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 104 |
//*s/taxonConcept[@code=ord]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Order]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 105 | 105 |
//*s/taxonConcept[@code=sp]/AccordingTo/Simple,"/taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/reference/referencecontributor/*_id/referenceparty/{givenname,surname}"
|
| 106 |
//*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/*_id/plantconcept/*_id/*/plantname"
|
|
| 107 |
//*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname"
|
|
| 108 |
//taxonName/Simple,"/{taxondetermination[rolecode=identifier]/*_id/plantconcept/*_id/*/plantname,taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/1}"
|
|
| 109 |
//*s/taxonConcept[@code=sp]/Name,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname,taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}"
|
|
| 106 |
//*s/taxonConcept[@code=phyl_div]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subkingdom]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 107 |
//*s/taxonConcept[@code=ssp]/Name,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname}"
|
|
| 108 |
//taxonName/Simple,"/{taxondetermination[rolecode=identifier]/*_id/*/plantname,taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/1}"
|
|
| 109 |
//*s/taxonConcept[@code=sp]/Name,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname},taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2}"
|
|
| 110 | 110 |
//taxonNameUsageConcept/voucher,"/{taxondetermination[rolecode=collector]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot/authorcode/_alt/3}"
|
| mappings/for_review/NYBG-VegBIEN.organisms.csv | ||
|---|---|---|
| 28 | 28 |
MonthIdentified,/taxondetermination[rolecode=identifier]/determinationdate/_date/month, |
| 29 | 29 |
YearIdentified,/taxondetermination[rolecode=identifier]/determinationdate/_date/year, |
| 30 | 30 |
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/plantconcept/*_id/*/plantname",
|
|
| 32 |
Family,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",
|
|
| 33 |
Genus,"/taxondetermination[rolecode=identifier,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",
|
|
| 34 |
Kingdom,"/taxondetermination[rolecode=identifier,plantlevel=Kingdom]/*_id/plantconcept/*_id/*/plantname",
|
|
| 35 |
Order,"/taxondetermination[rolecode=identifier,plantlevel=Order]/*_id/plantconcept/*_id/*/plantname",
|
|
| 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}",
|
|
| 36 | 36 |
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/plantconcept/*_id/*/plantname",
|
|
| 38 |
Subspecies,"/taxondetermination[rolecode=identifier,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname",
|
|
| 39 |
ScientificName,"/{taxondetermination[rolecode=identifier]/*_id/plantconcept/*_id/*/plantname,taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/1}","Brad: Bob, Nick, please is this mapping OK?"
|
|
| 40 |
Species,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname,taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}",
|
|
| 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=identifier]/*_id/*/plantname,taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/1}","Brad: Bob, Nick, please is this mapping OK?"
|
|
| 40 |
Species,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname},taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2}",
|
|
| 41 | 41 |
UniqueNYInternalRecordNumber,"/{taxondetermination[rolecode=collector]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot/authorcode/_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/plantconcept/*_id/*/plantname",
|
|
| 33 |
genus,"/taxondetermination[rolecode=computer,plantlevel=Genus]/*_id/plantconcept/*_id/*/plantname",
|
|
| 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 | 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/plantconcept/*_id/*/plantname",
|
|
| 36 |
infra_rank_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/first",
|
|
| 37 |
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname/_name/last",
|
|
| 38 |
orig_family,"/taxondetermination[rolecode=identifier,plantlevel=Family]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT
|
|
| 39 |
orig_species,"/{taxondetermination[rolecode=identifier,plantlevel=Species]/*_id/plantconcept/*_id/*/plantname,taxondetermination[rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 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,*_id/plantconcept/*_id/*/plantname}/_name/first",
|
|
| 37 |
infra_ep_1,"/taxondetermination[rolecode=computer,plantlevel=Subspecies]/{*_id/*/plantname,*_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=identifier,plantlevel=Species]/{*_id/*/plantname,*_id/plantconcept/*_id/*/plantname},taxondetermination[rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 40 | 40 |
OBSERVATION_ID,"/{taxondetermination[rolecode=collector]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot/authorcode/_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]/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]/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/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",
|
|
| 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 | 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/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/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/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/plantconcept:[plantstatus:[plantconceptstatus=accepted,startdate=epoch,*_id/party],*_id/reference]/*_id/*/plantname",Brad: OMIT |
|
| 39 |
orig_species,"/{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,taxondetermination[role_id/aux_role/rolecode=collector]/*_id/plantconcept/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 40 |
OBSERVATION_ID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/plantconcept:[*_id/reference],*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_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."
|
|
| 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,*_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,*_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=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},taxondetermination[role_id/aux_role/rolecode=collector]/*_id/*/plantname/_alt/2}",Brad: OMIT
|
|
| 40 |
OBSERVATION_ID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[role_id/aux_role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=false,determinationdate=epoch,*_id/party]/museumaccessionnumber,*_id/plotevent/authorcode/_alt/2,*_id/plotevent/*_id/plot:[confidentialitystatus=0]/authorcode/_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.plantname_id required