Revision 394
Added by Aaron Marcuse-Kubitza about 13 years ago
| test/accepted_output/SALVIAS.organisms.VegBIEN.xml | ||
|---|---|---|
| 82 | 82 |
</reference_ID> |
| 83 | 83 |
</plantConcept> |
| 84 | 84 |
</plantConcept_ID> |
| 85 |
<interpretationType>Author</interpretationType>
|
|
| 86 |
<originalInterpretation>true</originalInterpretation>
|
|
| 87 |
<currentInterpretation>false</currentInterpretation>
|
|
| 88 |
<interpretationDate>epoch</interpretationDate>
|
|
| 85 |
<determinationType>Author</determinationType>
|
|
| 86 |
<originaldetermination>true</originaldetermination>
|
|
| 87 |
<currentdetermination>false</currentdetermination>
|
|
| 88 |
<determinationDate>epoch</determinationDate>
|
|
| 89 | 89 |
<party_ID> |
| 90 | 90 |
<party/> |
| 91 | 91 |
</party_ID> |
| ... | ... | |
| 117 | 117 |
</plantName_ID> |
| 118 | 118 |
</plantConcept> |
| 119 | 119 |
</plantConcept_ID> |
| 120 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 121 |
<originalInterpretation>false</originalInterpretation>
|
|
| 122 |
<currentInterpretation>true</currentInterpretation>
|
|
| 123 |
<interpretationDate>epoch</interpretationDate>
|
|
| 120 |
<determinationType>Computer (automated)</determinationType>
|
|
| 121 |
<originaldetermination>false</originaldetermination>
|
|
| 122 |
<currentdetermination>true</currentdetermination>
|
|
| 123 |
<determinationDate>epoch</determinationDate>
|
|
| 124 | 124 |
<party_ID> |
| 125 | 125 |
<party/> |
| 126 | 126 |
</party_ID> |
| ... | ... | |
| 151 | 151 |
</plantName_ID> |
| 152 | 152 |
</plantConcept> |
| 153 | 153 |
</plantConcept_ID> |
| 154 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 155 |
<originalInterpretation>false</originalInterpretation>
|
|
| 156 |
<currentInterpretation>true</currentInterpretation>
|
|
| 157 |
<interpretationDate>epoch</interpretationDate>
|
|
| 154 |
<determinationType>Computer (automated)</determinationType>
|
|
| 155 |
<originaldetermination>false</originaldetermination>
|
|
| 156 |
<currentdetermination>true</currentdetermination>
|
|
| 157 |
<determinationDate>epoch</determinationDate>
|
|
| 158 | 158 |
<party_ID> |
| 159 | 159 |
<party/> |
| 160 | 160 |
</party_ID> |
| ... | ... | |
| 185 | 185 |
</plantName_ID> |
| 186 | 186 |
</plantConcept> |
| 187 | 187 |
</plantConcept_ID> |
| 188 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 189 |
<originalInterpretation>false</originalInterpretation>
|
|
| 190 |
<currentInterpretation>true</currentInterpretation>
|
|
| 191 |
<interpretationDate>epoch</interpretationDate>
|
|
| 188 |
<determinationType>Computer (automated)</determinationType>
|
|
| 189 |
<originaldetermination>false</originaldetermination>
|
|
| 190 |
<currentdetermination>true</currentdetermination>
|
|
| 191 |
<determinationDate>epoch</determinationDate>
|
|
| 192 | 192 |
<party_ID> |
| 193 | 193 |
<party/> |
| 194 | 194 |
</party_ID> |
| ... | ... | |
| 219 | 219 |
</plantName_ID> |
| 220 | 220 |
</plantConcept> |
| 221 | 221 |
</plantConcept_ID> |
| 222 |
<interpretationType>Author</interpretationType>
|
|
| 223 |
<originalInterpretation>true</originalInterpretation>
|
|
| 224 |
<currentInterpretation>true</currentInterpretation>
|
|
| 225 |
<interpretationDate>epoch</interpretationDate>
|
|
| 222 |
<determinationType>Author</determinationType>
|
|
| 223 |
<originaldetermination>true</originaldetermination>
|
|
| 224 |
<currentdetermination>true</currentdetermination>
|
|
| 225 |
<determinationDate>epoch</determinationDate>
|
|
| 226 | 226 |
<party_ID> |
| 227 | 227 |
<party/> |
| 228 | 228 |
</party_ID> |
| ... | ... | |
| 253 | 253 |
</plantName_ID> |
| 254 | 254 |
</plantConcept> |
| 255 | 255 |
</plantConcept_ID> |
| 256 |
<interpretationType>Author</interpretationType>
|
|
| 257 |
<originalInterpretation>true</originalInterpretation>
|
|
| 258 |
<currentInterpretation>true</currentInterpretation>
|
|
| 259 |
<interpretationDate>epoch</interpretationDate>
|
|
| 256 |
<determinationType>Author</determinationType>
|
|
| 257 |
<originaldetermination>true</originaldetermination>
|
|
| 258 |
<currentdetermination>true</currentdetermination>
|
|
| 259 |
<determinationDate>epoch</determinationDate>
|
|
| 260 | 260 |
<party_ID> |
| 261 | 261 |
<party/> |
| 262 | 262 |
</party_ID> |
| ... | ... | |
| 344 | 344 |
</reference_ID> |
| 345 | 345 |
</plantConcept> |
| 346 | 346 |
</plantConcept_ID> |
| 347 |
<interpretationType>Author</interpretationType>
|
|
| 348 |
<originalInterpretation>true</originalInterpretation>
|
|
| 349 |
<currentInterpretation>false</currentInterpretation>
|
|
| 350 |
<interpretationDate>epoch</interpretationDate>
|
|
| 347 |
<determinationType>Author</determinationType>
|
|
| 348 |
<originaldetermination>true</originaldetermination>
|
|
| 349 |
<currentdetermination>false</currentdetermination>
|
|
| 350 |
<determinationDate>epoch</determinationDate>
|
|
| 351 | 351 |
<party_ID> |
| 352 | 352 |
<party/> |
| 353 | 353 |
</party_ID> |
| ... | ... | |
| 379 | 379 |
</plantName_ID> |
| 380 | 380 |
</plantConcept> |
| 381 | 381 |
</plantConcept_ID> |
| 382 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 383 |
<originalInterpretation>false</originalInterpretation>
|
|
| 384 |
<currentInterpretation>true</currentInterpretation>
|
|
| 385 |
<interpretationDate>epoch</interpretationDate>
|
|
| 382 |
<determinationType>Computer (automated)</determinationType>
|
|
| 383 |
<originaldetermination>false</originaldetermination>
|
|
| 384 |
<currentdetermination>true</currentdetermination>
|
|
| 385 |
<determinationDate>epoch</determinationDate>
|
|
| 386 | 386 |
<party_ID> |
| 387 | 387 |
<party/> |
| 388 | 388 |
</party_ID> |
| ... | ... | |
| 413 | 413 |
</plantName_ID> |
| 414 | 414 |
</plantConcept> |
| 415 | 415 |
</plantConcept_ID> |
| 416 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 417 |
<originalInterpretation>false</originalInterpretation>
|
|
| 418 |
<currentInterpretation>true</currentInterpretation>
|
|
| 419 |
<interpretationDate>epoch</interpretationDate>
|
|
| 416 |
<determinationType>Computer (automated)</determinationType>
|
|
| 417 |
<originaldetermination>false</originaldetermination>
|
|
| 418 |
<currentdetermination>true</currentdetermination>
|
|
| 419 |
<determinationDate>epoch</determinationDate>
|
|
| 420 | 420 |
<party_ID> |
| 421 | 421 |
<party/> |
| 422 | 422 |
</party_ID> |
| ... | ... | |
| 447 | 447 |
</plantName_ID> |
| 448 | 448 |
</plantConcept> |
| 449 | 449 |
</plantConcept_ID> |
| 450 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 451 |
<originalInterpretation>false</originalInterpretation>
|
|
| 452 |
<currentInterpretation>true</currentInterpretation>
|
|
| 453 |
<interpretationDate>epoch</interpretationDate>
|
|
| 450 |
<determinationType>Computer (automated)</determinationType>
|
|
| 451 |
<originaldetermination>false</originaldetermination>
|
|
| 452 |
<currentdetermination>true</currentdetermination>
|
|
| 453 |
<determinationDate>epoch</determinationDate>
|
|
| 454 | 454 |
<party_ID> |
| 455 | 455 |
<party/> |
| 456 | 456 |
</party_ID> |
| ... | ... | |
| 481 | 481 |
</plantName_ID> |
| 482 | 482 |
</plantConcept> |
| 483 | 483 |
</plantConcept_ID> |
| 484 |
<interpretationType>Author</interpretationType>
|
|
| 485 |
<originalInterpretation>true</originalInterpretation>
|
|
| 486 |
<currentInterpretation>true</currentInterpretation>
|
|
| 487 |
<interpretationDate>epoch</interpretationDate>
|
|
| 484 |
<determinationType>Author</determinationType>
|
|
| 485 |
<originaldetermination>true</originaldetermination>
|
|
| 486 |
<currentdetermination>true</currentdetermination>
|
|
| 487 |
<determinationDate>epoch</determinationDate>
|
|
| 488 | 488 |
<party_ID> |
| 489 | 489 |
<party/> |
| 490 | 490 |
</party_ID> |
| ... | ... | |
| 515 | 515 |
</plantName_ID> |
| 516 | 516 |
</plantConcept> |
| 517 | 517 |
</plantConcept_ID> |
| 518 |
<interpretationType>Author</interpretationType>
|
|
| 519 |
<originalInterpretation>true</originalInterpretation>
|
|
| 520 |
<currentInterpretation>true</currentInterpretation>
|
|
| 521 |
<interpretationDate>epoch</interpretationDate>
|
|
| 518 |
<determinationType>Author</determinationType>
|
|
| 519 |
<originaldetermination>true</originaldetermination>
|
|
| 520 |
<currentdetermination>true</currentdetermination>
|
|
| 521 |
<determinationDate>epoch</determinationDate>
|
|
| 522 | 522 |
<party_ID> |
| 523 | 523 |
<party/> |
| 524 | 524 |
</party_ID> |
| test/accepted_output/SALVIAS_db.plots.VegBIEN.xml | ||
|---|---|---|
| 33 | 33 |
</project> |
| 34 | 34 |
</project_ID> |
| 35 | 35 |
<commClass> |
| 36 |
<commInterpretation>
|
|
| 36 |
<commdetermination>
|
|
| 37 | 37 |
<commConcept_ID> |
| 38 | 38 |
<commConcept> |
| 39 | 39 |
<commName_ID> |
| ... | ... | |
| 44 | 44 |
<commDescription>Tropical lower montane wet forest</commDescription> |
| 45 | 45 |
</commConcept> |
| 46 | 46 |
</commConcept_ID> |
| 47 |
</commInterpretation>
|
|
| 47 |
</commdetermination>
|
|
| 48 | 48 |
</commClass> |
| 49 | 49 |
<definedValue fkey="tableRecord_ID"> |
| 50 | 50 |
<userDefined_ID> |
| ... | ... | |
| 92 | 92 |
</project> |
| 93 | 93 |
</project_ID> |
| 94 | 94 |
<commClass> |
| 95 |
<commInterpretation>
|
|
| 95 |
<commdetermination>
|
|
| 96 | 96 |
<commConcept_ID> |
| 97 | 97 |
<commConcept> |
| 98 | 98 |
<commName_ID> |
| ... | ... | |
| 103 | 103 |
<commDescription>Cool temperate moist forest</commDescription> |
| 104 | 104 |
</commConcept> |
| 105 | 105 |
</commConcept_ID> |
| 106 |
</commInterpretation>
|
|
| 106 |
</commdetermination>
|
|
| 107 | 107 |
</commClass> |
| 108 | 108 |
<definedValue fkey="tableRecord_ID"> |
| 109 | 109 |
<userDefined_ID> |
| test/accepted_output/SALVIAS_db.organisms.VegBIEN.xml | ||
|---|---|---|
| 73 | 73 |
</reference_ID> |
| 74 | 74 |
</plantConcept> |
| 75 | 75 |
</plantConcept_ID> |
| 76 |
<interpretationType>Author</interpretationType>
|
|
| 77 |
<originalInterpretation>true</originalInterpretation>
|
|
| 78 |
<currentInterpretation>false</currentInterpretation>
|
|
| 79 |
<interpretationDate>epoch</interpretationDate>
|
|
| 76 |
<determinationType>Author</determinationType>
|
|
| 77 |
<originaldetermination>true</originaldetermination>
|
|
| 78 |
<currentdetermination>false</currentdetermination>
|
|
| 79 |
<determinationDate>epoch</determinationDate>
|
|
| 80 | 80 |
<party_ID> |
| 81 | 81 |
<party/> |
| 82 | 82 |
</party_ID> |
| ... | ... | |
| 108 | 108 |
</plantName_ID> |
| 109 | 109 |
</plantConcept> |
| 110 | 110 |
</plantConcept_ID> |
| 111 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 112 |
<originalInterpretation>false</originalInterpretation>
|
|
| 113 |
<currentInterpretation>true</currentInterpretation>
|
|
| 114 |
<interpretationDate>epoch</interpretationDate>
|
|
| 111 |
<determinationType>Computer (automated)</determinationType>
|
|
| 112 |
<originaldetermination>false</originaldetermination>
|
|
| 113 |
<currentdetermination>true</currentdetermination>
|
|
| 114 |
<determinationDate>epoch</determinationDate>
|
|
| 115 | 115 |
<party_ID> |
| 116 | 116 |
<party/> |
| 117 | 117 |
</party_ID> |
| ... | ... | |
| 142 | 142 |
</plantName_ID> |
| 143 | 143 |
</plantConcept> |
| 144 | 144 |
</plantConcept_ID> |
| 145 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 146 |
<originalInterpretation>false</originalInterpretation>
|
|
| 147 |
<currentInterpretation>true</currentInterpretation>
|
|
| 148 |
<interpretationDate>epoch</interpretationDate>
|
|
| 145 |
<determinationType>Computer (automated)</determinationType>
|
|
| 146 |
<originaldetermination>false</originaldetermination>
|
|
| 147 |
<currentdetermination>true</currentdetermination>
|
|
| 148 |
<determinationDate>epoch</determinationDate>
|
|
| 149 | 149 |
<party_ID> |
| 150 | 150 |
<party/> |
| 151 | 151 |
</party_ID> |
| ... | ... | |
| 181 | 181 |
</reference_ID> |
| 182 | 182 |
</plantConcept> |
| 183 | 183 |
</plantConcept_ID> |
| 184 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 185 |
<originalInterpretation>false</originalInterpretation>
|
|
| 186 |
<currentInterpretation>true</currentInterpretation>
|
|
| 187 |
<interpretationDate>epoch</interpretationDate>
|
|
| 184 |
<determinationType>Computer (automated)</determinationType>
|
|
| 185 |
<originaldetermination>false</originaldetermination>
|
|
| 186 |
<currentdetermination>true</currentdetermination>
|
|
| 187 |
<determinationDate>epoch</determinationDate>
|
|
| 188 | 188 |
<party_ID> |
| 189 | 189 |
<party/> |
| 190 | 190 |
</party_ID> |
| ... | ... | |
| 215 | 215 |
</plantName_ID> |
| 216 | 216 |
</plantConcept> |
| 217 | 217 |
</plantConcept_ID> |
| 218 |
<interpretationType>Author</interpretationType>
|
|
| 219 |
<originalInterpretation>true</originalInterpretation>
|
|
| 220 |
<currentInterpretation>true</currentInterpretation>
|
|
| 221 |
<interpretationDate>epoch</interpretationDate>
|
|
| 218 |
<determinationType>Author</determinationType>
|
|
| 219 |
<originaldetermination>true</originaldetermination>
|
|
| 220 |
<currentdetermination>true</currentdetermination>
|
|
| 221 |
<determinationDate>epoch</determinationDate>
|
|
| 222 | 222 |
<party_ID> |
| 223 | 223 |
<party/> |
| 224 | 224 |
</party_ID> |
| ... | ... | |
| 249 | 249 |
</plantName_ID> |
| 250 | 250 |
</plantConcept> |
| 251 | 251 |
</plantConcept_ID> |
| 252 |
<interpretationType>Author</interpretationType>
|
|
| 253 |
<originalInterpretation>true</originalInterpretation>
|
|
| 254 |
<currentInterpretation>true</currentInterpretation>
|
|
| 255 |
<interpretationDate>epoch</interpretationDate>
|
|
| 252 |
<determinationType>Author</determinationType>
|
|
| 253 |
<originaldetermination>true</originaldetermination>
|
|
| 254 |
<currentdetermination>true</currentdetermination>
|
|
| 255 |
<determinationDate>epoch</determinationDate>
|
|
| 256 | 256 |
<party_ID> |
| 257 | 257 |
<party/> |
| 258 | 258 |
</party_ID> |
| ... | ... | |
| 331 | 331 |
</reference_ID> |
| 332 | 332 |
</plantConcept> |
| 333 | 333 |
</plantConcept_ID> |
| 334 |
<interpretationType>Author</interpretationType>
|
|
| 335 |
<originalInterpretation>true</originalInterpretation>
|
|
| 336 |
<currentInterpretation>false</currentInterpretation>
|
|
| 337 |
<interpretationDate>epoch</interpretationDate>
|
|
| 334 |
<determinationType>Author</determinationType>
|
|
| 335 |
<originaldetermination>true</originaldetermination>
|
|
| 336 |
<currentdetermination>false</currentdetermination>
|
|
| 337 |
<determinationDate>epoch</determinationDate>
|
|
| 338 | 338 |
<party_ID> |
| 339 | 339 |
<party/> |
| 340 | 340 |
</party_ID> |
| ... | ... | |
| 366 | 366 |
</plantName_ID> |
| 367 | 367 |
</plantConcept> |
| 368 | 368 |
</plantConcept_ID> |
| 369 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 370 |
<originalInterpretation>false</originalInterpretation>
|
|
| 371 |
<currentInterpretation>true</currentInterpretation>
|
|
| 372 |
<interpretationDate>epoch</interpretationDate>
|
|
| 369 |
<determinationType>Computer (automated)</determinationType>
|
|
| 370 |
<originaldetermination>false</originaldetermination>
|
|
| 371 |
<currentdetermination>true</currentdetermination>
|
|
| 372 |
<determinationDate>epoch</determinationDate>
|
|
| 373 | 373 |
<party_ID> |
| 374 | 374 |
<party/> |
| 375 | 375 |
</party_ID> |
| ... | ... | |
| 400 | 400 |
</plantName_ID> |
| 401 | 401 |
</plantConcept> |
| 402 | 402 |
</plantConcept_ID> |
| 403 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 404 |
<originalInterpretation>false</originalInterpretation>
|
|
| 405 |
<currentInterpretation>true</currentInterpretation>
|
|
| 406 |
<interpretationDate>epoch</interpretationDate>
|
|
| 403 |
<determinationType>Computer (automated)</determinationType>
|
|
| 404 |
<originaldetermination>false</originaldetermination>
|
|
| 405 |
<currentdetermination>true</currentdetermination>
|
|
| 406 |
<determinationDate>epoch</determinationDate>
|
|
| 407 | 407 |
<party_ID> |
| 408 | 408 |
<party/> |
| 409 | 409 |
</party_ID> |
| ... | ... | |
| 439 | 439 |
</reference_ID> |
| 440 | 440 |
</plantConcept> |
| 441 | 441 |
</plantConcept_ID> |
| 442 |
<interpretationType>Computer (automated)</interpretationType>
|
|
| 443 |
<originalInterpretation>false</originalInterpretation>
|
|
| 444 |
<currentInterpretation>true</currentInterpretation>
|
|
| 445 |
<interpretationDate>epoch</interpretationDate>
|
|
| 442 |
<determinationType>Computer (automated)</determinationType>
|
|
| 443 |
<originaldetermination>false</originaldetermination>
|
|
| 444 |
<currentdetermination>true</currentdetermination>
|
|
| 445 |
<determinationDate>epoch</determinationDate>
|
|
| 446 | 446 |
<party_ID> |
| 447 | 447 |
<party/> |
| 448 | 448 |
</party_ID> |
| ... | ... | |
| 473 | 473 |
</plantName_ID> |
| 474 | 474 |
</plantConcept> |
| 475 | 475 |
</plantConcept_ID> |
| 476 |
<interpretationType>Author</interpretationType>
|
|
| 477 |
<originalInterpretation>true</originalInterpretation>
|
|
| 478 |
<currentInterpretation>true</currentInterpretation>
|
|
| 479 |
<interpretationDate>epoch</interpretationDate>
|
|
| 476 |
<determinationType>Author</determinationType>
|
|
| 477 |
<originaldetermination>true</originaldetermination>
|
|
| 478 |
<currentdetermination>true</currentdetermination>
|
|
| 479 |
<determinationDate>epoch</determinationDate>
|
|
| 480 | 480 |
<party_ID> |
| 481 | 481 |
<party/> |
| 482 | 482 |
</party_ID> |
| ... | ... | |
| 507 | 507 |
</plantName_ID> |
| 508 | 508 |
</plantConcept> |
| 509 | 509 |
</plantConcept_ID> |
| 510 |
<interpretationType>Author</interpretationType>
|
|
| 511 |
<originalInterpretation>true</originalInterpretation>
|
|
| 512 |
<currentInterpretation>true</currentInterpretation>
|
|
| 513 |
<interpretationDate>epoch</interpretationDate>
|
|
| 510 |
<determinationType>Author</determinationType>
|
|
| 511 |
<originaldetermination>true</originaldetermination>
|
|
| 512 |
<currentdetermination>true</currentdetermination>
|
|
| 513 |
<determinationDate>epoch</determinationDate>
|
|
| 514 | 514 |
<party_ID> |
| 515 | 515 |
<party/> |
| 516 | 516 |
</party_ID> |
| test/accepted_output/NYBG.organisms.VegBIEN.xml | ||
|---|---|---|
| 99 | 99 |
</plantName_ID> |
| 100 | 100 |
</plantConcept> |
| 101 | 101 |
</plantConcept_ID> |
| 102 |
<interpretationType>Author</interpretationType>
|
|
| 103 |
<originalInterpretation>true</originalInterpretation>
|
|
| 104 |
<currentInterpretation>false</currentInterpretation>
|
|
| 105 |
<interpretationDate>epoch</interpretationDate>
|
|
| 102 |
<determinationType>Author</determinationType>
|
|
| 103 |
<originaldetermination>true</originaldetermination>
|
|
| 104 |
<currentdetermination>false</currentdetermination>
|
|
| 105 |
<determinationDate>epoch</determinationDate>
|
|
| 106 | 106 |
<party_ID> |
| 107 | 107 |
<party/> |
| 108 | 108 |
</party_ID> |
| ... | ... | |
| 134 | 134 |
</plantName_ID> |
| 135 | 135 |
</plantConcept> |
| 136 | 136 |
</plantConcept_ID> |
| 137 |
<interpretationType>Author</interpretationType>
|
|
| 138 |
<originalInterpretation>true</originalInterpretation>
|
|
| 139 |
<currentInterpretation>true</currentInterpretation>
|
|
| 140 |
<interpretationDate>epoch</interpretationDate>
|
|
| 137 |
<determinationType>Author</determinationType>
|
|
| 138 |
<originaldetermination>true</originaldetermination>
|
|
| 139 |
<currentdetermination>true</currentdetermination>
|
|
| 140 |
<determinationDate>epoch</determinationDate>
|
|
| 141 | 141 |
<party_ID> |
| 142 | 142 |
<party/> |
| 143 | 143 |
</party_ID> |
| ... | ... | |
| 168 | 168 |
</plantName_ID> |
| 169 | 169 |
</plantConcept> |
| 170 | 170 |
</plantConcept_ID> |
| 171 |
<interpretationType>Author</interpretationType>
|
|
| 172 |
<originalInterpretation>true</originalInterpretation>
|
|
| 173 |
<currentInterpretation>true</currentInterpretation>
|
|
| 174 |
<interpretationDate>epoch</interpretationDate>
|
|
| 171 |
<determinationType>Author</determinationType>
|
|
| 172 |
<originaldetermination>true</originaldetermination>
|
|
| 173 |
<currentdetermination>true</currentdetermination>
|
|
| 174 |
<determinationDate>epoch</determinationDate>
|
|
| 175 | 175 |
<party_ID> |
| 176 | 176 |
<party/> |
| 177 | 177 |
</party_ID> |
| ... | ... | |
| 202 | 202 |
</plantName_ID> |
| 203 | 203 |
</plantConcept> |
| 204 | 204 |
</plantConcept_ID> |
| 205 |
<interpretationType>Author</interpretationType>
|
|
| 206 |
<originalInterpretation>true</originalInterpretation>
|
|
| 207 |
<currentInterpretation>true</currentInterpretation>
|
|
| 208 |
<interpretationDate>epoch</interpretationDate>
|
|
| 205 |
<determinationType>Author</determinationType>
|
|
| 206 |
<originaldetermination>true</originaldetermination>
|
|
| 207 |
<currentdetermination>true</currentdetermination>
|
|
| 208 |
<determinationDate>epoch</determinationDate>
|
|
| 209 | 209 |
<party_ID> |
| 210 | 210 |
<party/> |
| 211 | 211 |
</party_ID> |
| ... | ... | |
| 245 | 245 |
</plantName_ID> |
| 246 | 246 |
</plantConcept> |
| 247 | 247 |
</plantConcept_ID> |
| 248 |
<interpretationType>Author</interpretationType>
|
|
| 249 |
<originalInterpretation>true</originalInterpretation>
|
|
| 250 |
<currentInterpretation>true</currentInterpretation>
|
|
| 251 |
<interpretationDate>epoch</interpretationDate>
|
|
| 248 |
<determinationType>Author</determinationType>
|
|
| 249 |
<originaldetermination>true</originaldetermination>
|
|
| 250 |
<currentdetermination>true</currentdetermination>
|
|
| 251 |
<determinationDate>epoch</determinationDate>
|
|
| 252 | 252 |
<party_ID> |
| 253 | 253 |
<party/> |
| 254 | 254 |
</party_ID> |
| ... | ... | |
| 279 | 279 |
</plantName_ID> |
| 280 | 280 |
</plantConcept> |
| 281 | 281 |
</plantConcept_ID> |
| 282 |
<interpretationType>Author</interpretationType>
|
|
| 283 |
<originalInterpretation>true</originalInterpretation>
|
|
| 284 |
<currentInterpretation>true</currentInterpretation>
|
|
| 285 |
<interpretationDate>epoch</interpretationDate>
|
|
| 282 |
<determinationType>Author</determinationType>
|
|
| 283 |
<originaldetermination>true</originaldetermination>
|
|
| 284 |
<currentdetermination>true</currentdetermination>
|
|
| 285 |
<determinationDate>epoch</determinationDate>
|
|
| 286 | 286 |
<party_ID> |
| 287 | 287 |
<party/> |
| 288 | 288 |
</party_ID> |
| ... | ... | |
| 293 | 293 |
<roleCode>identifier</roleCode> |
| 294 | 294 |
</aux_Role> |
| 295 | 295 |
</ROLE_ID> |
| 296 |
<interpretationType>Author</interpretationType>
|
|
| 297 |
<originalInterpretation>true</originalInterpretation>
|
|
| 298 |
<currentInterpretation>true</currentInterpretation>
|
|
| 299 |
<interpretationDate>epoch</interpretationDate>
|
|
| 296 |
<determinationType>Author</determinationType>
|
|
| 297 |
<originaldetermination>true</originaldetermination>
|
|
| 298 |
<currentdetermination>true</currentdetermination>
|
|
| 299 |
<determinationDate>epoch</determinationDate>
|
|
| 300 | 300 |
<party_ID> |
| 301 | 301 |
<party/> |
| 302 | 302 |
</party_ID> |
| ... | ... | |
| 378 | 378 |
</plantName_ID> |
| 379 | 379 |
</plantConcept> |
| 380 | 380 |
</plantConcept_ID> |
| 381 |
<interpretationType>Author</interpretationType>
|
|
| 382 |
<originalInterpretation>true</originalInterpretation>
|
|
| 383 |
<currentInterpretation>false</currentInterpretation>
|
|
| 384 |
<interpretationDate>epoch</interpretationDate>
|
|
| 381 |
<determinationType>Author</determinationType>
|
|
| 382 |
<originaldetermination>true</originaldetermination>
|
|
| 383 |
<currentdetermination>false</currentdetermination>
|
|
| 384 |
<determinationDate>epoch</determinationDate>
|
|
| 385 | 385 |
<party_ID> |
| 386 | 386 |
<party/> |
| 387 | 387 |
</party_ID> |
| ... | ... | |
| 413 | 413 |
</plantName_ID> |
| 414 | 414 |
</plantConcept> |
| 415 | 415 |
</plantConcept_ID> |
| 416 |
<interpretationType>Author</interpretationType>
|
|
| 417 |
<originalInterpretation>true</originalInterpretation>
|
|
| 418 |
<currentInterpretation>true</currentInterpretation>
|
|
| 419 |
<interpretationDate>epoch</interpretationDate>
|
|
| 416 |
<determinationType>Author</determinationType>
|
|
| 417 |
<originaldetermination>true</originaldetermination>
|
|
| 418 |
<currentdetermination>true</currentdetermination>
|
|
| 419 |
<determinationDate>epoch</determinationDate>
|
|
| 420 | 420 |
<party_ID> |
| 421 | 421 |
<party/> |
| 422 | 422 |
</party_ID> |
| ... | ... | |
| 447 | 447 |
</plantName_ID> |
| 448 | 448 |
</plantConcept> |
| 449 | 449 |
</plantConcept_ID> |
| 450 |
<interpretationType>Author</interpretationType>
|
|
| 451 |
<originalInterpretation>true</originalInterpretation>
|
|
| 452 |
<currentInterpretation>true</currentInterpretation>
|
|
| 453 |
<interpretationDate>epoch</interpretationDate>
|
|
| 450 |
<determinationType>Author</determinationType>
|
|
| 451 |
<originaldetermination>true</originaldetermination>
|
|
| 452 |
<currentdetermination>true</currentdetermination>
|
|
| 453 |
<determinationDate>epoch</determinationDate>
|
|
| 454 | 454 |
<party_ID> |
| 455 | 455 |
<party/> |
| 456 | 456 |
</party_ID> |
| ... | ... | |
| 481 | 481 |
</plantName_ID> |
| 482 | 482 |
</plantConcept> |
| 483 | 483 |
</plantConcept_ID> |
| 484 |
<interpretationType>Author</interpretationType>
|
|
| 485 |
<originalInterpretation>true</originalInterpretation>
|
|
| 486 |
<currentInterpretation>true</currentInterpretation>
|
|
| 487 |
<interpretationDate>epoch</interpretationDate>
|
|
| 484 |
<determinationType>Author</determinationType>
|
|
| 485 |
<originaldetermination>true</originaldetermination>
|
|
| 486 |
<currentdetermination>true</currentdetermination>
|
|
| 487 |
<determinationDate>epoch</determinationDate>
|
|
| 488 | 488 |
<party_ID> |
| 489 | 489 |
<party/> |
| 490 | 490 |
</party_ID> |
| ... | ... | |
| 495 | 495 |
<roleCode>identifier</roleCode> |
| 496 | 496 |
</aux_Role> |
| 497 | 497 |
</ROLE_ID> |
| 498 |
<interpretationType>Author</interpretationType>
|
|
| 499 |
<originalInterpretation>true</originalInterpretation>
|
|
| 500 |
<currentInterpretation>true</currentInterpretation>
|
|
| 501 |
<interpretationDate>epoch</interpretationDate>
|
|
| 498 |
<determinationType>Author</determinationType>
|
|
| 499 |
<originaldetermination>true</originaldetermination>
|
|
| 500 |
<currentdetermination>true</currentdetermination>
|
|
| 501 |
<determinationDate>epoch</determinationDate>
|
|
| 502 | 502 |
<party_ID> |
| 503 | 503 |
<party/> |
| 504 | 504 |
</party_ID> |
| inputs/SALVIAS/map.VegBIEN.0.plots.csv | ||
|---|---|---|
| 13 | 13 |
elev_max_m,"/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}",
|
| 14 | 14 |
elev_min_m,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}",
|
| 15 | 15 |
project_id,/*_ID/project/projectName, |
| 16 |
life_zone_code,/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName,
|
|
| 17 |
life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription,
|
|
| 16 |
life_zone_code,/commClass/commdetermination/*_ID/commConcept/*_ID/*/commName,
|
|
| 17 |
life_zone,/commClass/commdetermination/*_ID/commConcept/commDescription,
|
|
| 18 | 18 |
Precip,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue", |
| 19 | 19 |
Temp,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue", |
| 20 | 20 |
PlotMethod,/methodNarrative, |
| inputs/SALVIAS/map.VegBIEN.1.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]/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]/notes, |
| 23 |
Family,"/taxondetermination[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",
|
|
| 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 | 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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",
|
|
| 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 | 27 |
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", |
| 28 |
infra_ep_1,"/taxondetermination[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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
|
|
| 31 |
PlotObsID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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."
|
|
| 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]/*_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/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",Brad: OMIT |
|
| 30 |
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
|
|
| 31 |
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/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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_empty.sql | ||
|---|---|---|
| 6 | 6 |
TRUNCATE commclass CASCADE; |
| 7 | 7 |
TRUNCATE commconcept CASCADE; |
| 8 | 8 |
TRUNCATE commcorrelation CASCADE; |
| 9 |
TRUNCATE comminterpretation CASCADE;
|
|
| 9 |
TRUNCATE commdetermination CASCADE;
|
|
| 10 | 10 |
TRUNCATE commlineage CASCADE; |
| 11 | 11 |
TRUNCATE commname CASCADE; |
| 12 | 12 |
TRUNCATE commstatus CASCADE; |
| schemas/vegbien.sql | ||
|---|---|---|
| 297 | 297 |
|
| 298 | 298 |
|
| 299 | 299 |
-- |
| 300 |
-- Name: comminterpretation; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 300 |
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
|
|
| 301 | 301 |
-- |
| 302 | 302 |
|
| 303 |
CREATE TABLE comminterpretation (
|
|
| 304 |
comminterpretation_id integer NOT NULL,
|
|
| 303 |
CREATE TABLE commdetermination (
|
|
| 304 |
commdetermination_id integer NOT NULL,
|
|
| 305 | 305 |
commclass_id integer NOT NULL, |
| 306 | 306 |
commconcept_id integer, |
| 307 | 307 |
commcode character varying(34), |
| ... | ... | |
| 312 | 312 |
notes text, |
| 313 | 313 |
type boolean, |
| 314 | 314 |
nomenclaturaltype boolean, |
| 315 |
emb_comminterpretation integer
|
|
| 315 |
emb_commdetermination integer
|
|
| 316 | 316 |
); |
| 317 | 317 |
|
| 318 | 318 |
|
| 319 | 319 |
-- |
| 320 |
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 320 |
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 321 | 321 |
-- |
| 322 | 322 |
|
| 323 |
CREATE SEQUENCE comminterpretation_comminterpretation_id_seq
|
|
| 323 |
CREATE SEQUENCE commdetermination_commdetermination_id_seq
|
|
| 324 | 324 |
START WITH 1 |
| 325 | 325 |
INCREMENT BY 1 |
| 326 | 326 |
NO MINVALUE |
| ... | ... | |
| 329 | 329 |
|
| 330 | 330 |
|
| 331 | 331 |
-- |
| 332 |
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 332 |
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 333 | 333 |
-- |
| 334 | 334 |
|
| 335 |
ALTER SEQUENCE comminterpretation_comminterpretation_id_seq OWNED BY comminterpretation.comminterpretation_id;
|
|
| 335 |
ALTER SEQUENCE commdetermination_commdetermination_id_seq OWNED BY commdetermination.commdetermination_id;
|
|
| 336 | 336 |
|
| 337 | 337 |
|
| 338 | 338 |
-- |
| ... | ... | |
| 2387 | 2387 |
plantname_id integer, |
| 2388 | 2388 |
party_id integer NOT NULL, |
| 2389 | 2389 |
role_id integer NOT NULL, |
| 2390 |
interpretationtype character varying(30),
|
|
| 2390 |
determinationtype character varying(30),
|
|
| 2391 | 2391 |
reference_id integer, |
| 2392 |
originalinterpretation boolean NOT NULL,
|
|
| 2393 |
currentinterpretation boolean NOT NULL,
|
|
| 2392 |
originaldetermination boolean NOT NULL,
|
|
| 2393 |
currentdetermination boolean NOT NULL,
|
|
| 2394 | 2394 |
taxonfit character varying(50), |
| 2395 | 2395 |
taxonconfidence character varying(50), |
| 2396 | 2396 |
collector_id integer, |
| ... | ... | |
| 2402 | 2402 |
notespublic boolean, |
| 2403 | 2403 |
notesmgt boolean, |
| 2404 | 2404 |
revisions boolean, |
| 2405 |
interpretationdate timestamp with time zone NOT NULL,
|
|
| 2405 |
determinationdate timestamp with time zone NOT NULL,
|
|
| 2406 | 2406 |
collectiondate timestamp with time zone, |
| 2407 |
emb_taxoninterpretation integer,
|
|
| 2407 |
emb_taxondetermination integer,
|
|
| 2408 | 2408 |
accessioncode character varying(255) |
| 2409 | 2409 |
); |
| 2410 | 2410 |
|
| 2411 | 2411 |
|
| 2412 | 2412 |
-- |
| 2413 |
-- Name: taxonimportance_taxonimportance_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2413 |
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2414 | 2414 |
-- |
| 2415 | 2415 |
|
| 2416 |
CREATE SEQUENCE taxonimportance_taxonimportance_id_seq
|
|
| 2416 |
CREATE SEQUENCE taxondetermination_taxondetermination_id_seq
|
|
| 2417 | 2417 |
START WITH 1 |
| 2418 | 2418 |
INCREMENT BY 1 |
| 2419 | 2419 |
NO MINVALUE |
| ... | ... | |
| 2422 | 2422 |
|
| 2423 | 2423 |
|
| 2424 | 2424 |
-- |
| 2425 |
-- Name: taxonimportance_taxonimportance_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2425 |
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2426 | 2426 |
-- |
| 2427 | 2427 |
|
| 2428 |
ALTER SEQUENCE taxonimportance_taxonimportance_id_seq OWNED BY collectiveobservation.collectiveobservation_id;
|
|
| 2428 |
ALTER SEQUENCE taxondetermination_taxondetermination_id_seq OWNED BY taxondetermination.taxondetermination_id;
|
|
| 2429 | 2429 |
|
| 2430 | 2430 |
|
| 2431 | 2431 |
-- |
| 2432 |
-- Name: taxoninterpretation_taxoninterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2432 |
-- Name: taxonimportance_taxonimportance_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
|
| 2433 | 2433 |
-- |
| 2434 | 2434 |
|
| 2435 |
CREATE SEQUENCE taxoninterpretation_taxoninterpretation_id_seq
|
|
| 2435 |
CREATE SEQUENCE taxonimportance_taxonimportance_id_seq
|
|
| 2436 | 2436 |
START WITH 1 |
| 2437 | 2437 |
INCREMENT BY 1 |
| 2438 | 2438 |
NO MINVALUE |
| ... | ... | |
| 2441 | 2441 |
|
| 2442 | 2442 |
|
| 2443 | 2443 |
-- |
| 2444 |
-- Name: taxoninterpretation_taxoninterpretation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2444 |
-- Name: taxonimportance_taxonimportance_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
|
| 2445 | 2445 |
-- |
| 2446 | 2446 |
|
| 2447 |
ALTER SEQUENCE taxoninterpretation_taxoninterpretation_id_seq OWNED BY taxondetermination.taxondetermination_id;
|
|
| 2447 |
ALTER SEQUENCE taxonimportance_taxonimportance_id_seq OWNED BY collectiveobservation.collectiveobservation_id;
|
|
| 2448 | 2448 |
|
| 2449 | 2449 |
|
| 2450 | 2450 |
-- |
| ... | ... | |
| 3064 | 3064 |
|
| 3065 | 3065 |
|
| 3066 | 3066 |
-- |
| 3067 |
-- Name: comminterpretation_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3067 |
-- Name: commdetermination_id; Type: DEFAULT; Schema: public; Owner: -
|
|
| 3068 | 3068 |
-- |
| 3069 | 3069 |
|
| 3070 |
ALTER TABLE comminterpretation ALTER COLUMN comminterpretation_id SET DEFAULT nextval('comminterpretation_comminterpretation_id_seq'::regclass);
|
|
| 3070 |
ALTER TABLE commdetermination ALTER COLUMN commdetermination_id SET DEFAULT nextval('commdetermination_commdetermination_id_seq'::regclass);
|
|
| 3071 | 3071 |
|
| 3072 | 3072 |
|
| 3073 | 3073 |
-- |
| ... | ... | |
| 3445 | 3445 |
-- Name: taxondetermination_id; Type: DEFAULT; Schema: public; Owner: - |
| 3446 | 3446 |
-- |
| 3447 | 3447 |
|
| 3448 |
ALTER TABLE taxondetermination ALTER COLUMN taxondetermination_id SET DEFAULT nextval('taxoninterpretation_taxoninterpretation_id_seq'::regclass);
|
|
| 3448 |
ALTER TABLE taxondetermination ALTER COLUMN taxondetermination_id SET DEFAULT nextval('taxondetermination_taxondetermination_id_seq'::regclass);
|
|
| 3449 | 3449 |
|
| 3450 | 3450 |
|
| 3451 | 3451 |
-- |
| ... | ... | |
| 3610 | 3610 |
|
| 3611 | 3611 |
|
| 3612 | 3612 |
-- |
| 3613 |
-- Name: comminterpretation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 3613 |
-- Name: commdetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 3614 | 3614 |
-- |
| 3615 | 3615 |
|
| 3616 |
ALTER TABLE ONLY comminterpretation
|
|
| 3617 |
ADD CONSTRAINT comminterpretation_pkey PRIMARY KEY (comminterpretation_id);
|
|
| 3616 |
ALTER TABLE ONLY commdetermination
|
|
| 3617 |
ADD CONSTRAINT commdetermination_pkey PRIMARY KEY (commdetermination_id);
|
|
| 3618 | 3618 |
|
| 3619 | 3619 |
|
| 3620 | 3620 |
-- |
| ... | ... | |
| 4050 | 4050 |
|
| 4051 | 4051 |
|
| 4052 | 4052 |
-- |
| 4053 |
-- Name: taxonimportance_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4053 |
-- Name: taxondetermination_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4054 | 4054 |
-- |
| 4055 | 4055 |
|
| 4056 |
ALTER TABLE ONLY collectiveobservation
|
|
| 4057 |
ADD CONSTRAINT taxonimportance_pkey PRIMARY KEY (collectiveobservation_id);
|
|
| 4056 |
ALTER TABLE ONLY taxondetermination
|
|
| 4057 |
ADD CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id);
|
|
| 4058 | 4058 |
|
| 4059 | 4059 |
|
| 4060 | 4060 |
-- |
| 4061 |
-- Name: taxoninterpretation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4061 |
-- Name: taxonimportance_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 4062 | 4062 |
-- |
| 4063 | 4063 |
|
| 4064 |
ALTER TABLE ONLY taxondetermination
|
|
| 4065 |
ADD CONSTRAINT taxoninterpretation_pkey PRIMARY KEY (taxondetermination_id);
|
|
| 4064 |
ALTER TABLE ONLY collectiveobservation
|
|
| 4065 |
ADD CONSTRAINT taxonimportance_pkey PRIMARY KEY (collectiveobservation_id);
|
|
| 4066 | 4066 |
|
| 4067 | 4067 |
|
| 4068 | 4068 |
-- |
| ... | ... | |
| 4299 | 4299 |
|
| 4300 | 4300 |
|
| 4301 | 4301 |
-- |
| 4302 |
-- Name: comminterpretation_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4302 |
-- Name: commdetermination_commauthority_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4303 | 4303 |
-- |
| 4304 | 4304 |
|
| 4305 |
CREATE INDEX comminterpretation_commauthority_id_x ON comminterpretation USING btree (commauthority_id);
|
|
| 4305 |
CREATE INDEX commdetermination_commauthority_id_x ON commdetermination USING btree (commauthority_id);
|
|
| 4306 | 4306 |
|
| 4307 | 4307 |
|
| 4308 | 4308 |
-- |
| 4309 |
-- Name: comminterpretation_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4309 |
-- Name: commdetermination_commclass_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4310 | 4310 |
-- |
| 4311 | 4311 |
|
| 4312 |
CREATE INDEX comminterpretation_commclass_id_x ON comminterpretation USING btree (commclass_id);
|
|
| 4312 |
CREATE INDEX commdetermination_commclass_id_x ON commdetermination USING btree (commclass_id);
|
|
| 4313 | 4313 |
|
| 4314 | 4314 |
|
| 4315 | 4315 |
-- |
| 4316 |
-- Name: comminterpretation_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4316 |
-- Name: commdetermination_commconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4317 | 4317 |
-- |
| 4318 | 4318 |
|
| 4319 |
CREATE INDEX comminterpretation_commconcept_id_x ON comminterpretation USING btree (commconcept_id);
|
|
| 4319 |
CREATE INDEX commdetermination_commconcept_id_x ON commdetermination USING btree (commconcept_id);
|
|
| 4320 | 4320 |
|
| 4321 | 4321 |
|
| 4322 | 4322 |
-- |
| ... | ... | |
| 4481 | 4481 |
|
| 4482 | 4482 |
|
| 4483 | 4483 |
-- |
| 4484 |
-- Name: emb_comminterpretation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4484 |
-- Name: emb_commdetermination_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4485 | 4485 |
-- |
| 4486 | 4486 |
|
| 4487 |
CREATE INDEX emb_comminterpretation_idx ON comminterpretation USING btree (emb_comminterpretation);
|
|
| 4487 |
CREATE INDEX emb_commdetermination_idx ON commdetermination USING btree (emb_commdetermination);
|
|
| 4488 | 4488 |
|
| 4489 | 4489 |
|
| 4490 | 4490 |
-- |
| ... | ... | |
| 4537 | 4537 |
|
| 4538 | 4538 |
|
| 4539 | 4539 |
-- |
| 4540 |
-- Name: emb_taxonimportance_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4540 |
-- Name: emb_taxondetermination_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4541 | 4541 |
-- |
| 4542 | 4542 |
|
| 4543 |
CREATE INDEX emb_taxonimportance_idx ON collectiveobservation USING btree (emb_taxonimportance);
|
|
| 4543 |
CREATE INDEX emb_taxondetermination_idx ON taxondetermination USING btree (emb_taxondetermination);
|
|
| 4544 | 4544 |
|
| 4545 | 4545 |
|
| 4546 | 4546 |
-- |
| 4547 |
-- Name: emb_taxoninterpretation_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4547 |
-- Name: emb_taxonimportance_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4548 | 4548 |
-- |
| 4549 | 4549 |
|
| 4550 |
CREATE INDEX emb_taxoninterpretation_idx ON taxondetermination USING btree (emb_taxoninterpretation);
|
|
| 4550 |
CREATE INDEX emb_taxonimportance_idx ON collectiveobservation USING btree (emb_taxonimportance);
|
|
| 4551 | 4551 |
|
| 4552 | 4552 |
|
| 4553 | 4553 |
-- |
| ... | ... | |
| 5132 | 5132 |
|
| 5133 | 5133 |
|
| 5134 | 5134 |
-- |
| 5135 |
-- Name: taxonalt_taxoninterpretation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5135 |
-- Name: taxonalt_taxondetermination_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5136 | 5136 |
-- |
| 5137 | 5137 |
|
| 5138 |
CREATE INDEX taxonalt_taxoninterpretation_id_x ON taxonalt USING btree (taxondetermination_id);
|
|
| 5138 |
CREATE INDEX taxonalt_taxondetermination_id_x ON taxonalt USING btree (taxondetermination_id);
|
|
| 5139 | 5139 |
|
| 5140 | 5140 |
|
| 5141 | 5141 |
-- |
| 5142 |
-- Name: taxonimportance_stratum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5142 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5143 | 5143 |
-- |
| 5144 | 5144 |
|
| 5145 |
CREATE INDEX taxonimportance_stratum_id_x ON collectiveobservation USING btree (stratum_id);
|
|
| 5145 |
CREATE UNIQUE INDEX taxondetermination_accessioncode_index ON taxondetermination USING btree (accessioncode);
|
|
| 5146 | 5146 |
|
| 5147 | 5147 |
|
| 5148 | 5148 |
-- |
| 5149 |
-- Name: taxonimportance_taxonobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5149 |
-- Name: taxondetermination_collector_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5150 | 5150 |
-- |
| 5151 | 5151 |
|
| 5152 |
CREATE INDEX taxonimportance_taxonobservation_id_x ON collectiveobservation USING btree (taxonoccurrence_id);
|
|
| 5152 |
CREATE INDEX taxondetermination_collector_id_x ON taxondetermination USING btree (collector_id);
|
|
| 5153 | 5153 |
|
| 5154 | 5154 |
|
| 5155 | 5155 |
-- |
| 5156 |
-- Name: taxoninterpretation_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5156 |
-- Name: taxondetermination_museum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5157 | 5157 |
-- |
| 5158 | 5158 |
|
| 5159 |
CREATE UNIQUE INDEX taxoninterpretation_accessioncode_index ON taxondetermination USING btree (accessioncode);
|
|
| 5159 |
CREATE INDEX taxondetermination_museum_id_x ON taxondetermination USING btree (museum_id);
|
|
| 5160 | 5160 |
|
| 5161 | 5161 |
|
| 5162 | 5162 |
-- |
| 5163 |
-- Name: taxoninterpretation_collector_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5163 |
-- Name: taxondetermination_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5164 | 5164 |
-- |
| 5165 | 5165 |
|
| 5166 |
CREATE INDEX taxoninterpretation_collector_id_x ON taxondetermination USING btree (collector_id);
|
|
| 5166 |
CREATE INDEX taxondetermination_party_id_x ON taxondetermination USING btree (party_id);
|
|
| 5167 | 5167 |
|
| 5168 | 5168 |
|
| 5169 | 5169 |
-- |
| 5170 |
-- Name: taxoninterpretation_museum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5170 |
-- Name: taxondetermination_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5171 | 5171 |
-- |
| 5172 | 5172 |
|
| 5173 |
CREATE INDEX taxoninterpretation_museum_id_x ON taxondetermination USING btree (museum_id);
|
|
| 5173 |
CREATE INDEX taxondetermination_plantconcept_id_x ON taxondetermination USING btree (plantconcept_id);
|
|
| 5174 | 5174 |
|
| 5175 | 5175 |
|
| 5176 | 5176 |
-- |
| 5177 |
-- Name: taxoninterpretation_party_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5177 |
-- Name: taxondetermination_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5178 | 5178 |
-- |
| 5179 | 5179 |
|
| 5180 |
CREATE INDEX taxoninterpretation_party_id_x ON taxondetermination USING btree (party_id);
|
|
| 5180 |
CREATE INDEX taxondetermination_plantname_id_x ON taxondetermination USING btree (plantname_id);
|
|
| 5181 | 5181 |
|
| 5182 | 5182 |
|
| 5183 | 5183 |
-- |
| 5184 |
-- Name: taxoninterpretation_plantconcept_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5184 |
-- Name: taxondetermination_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5185 | 5185 |
-- |
| 5186 | 5186 |
|
| 5187 |
CREATE INDEX taxoninterpretation_plantconcept_id_x ON taxondetermination USING btree (plantconcept_id);
|
|
| 5187 |
CREATE INDEX taxondetermination_reference_id_x ON taxondetermination USING btree (reference_id);
|
|
| 5188 | 5188 |
|
| 5189 | 5189 |
|
| 5190 | 5190 |
-- |
| 5191 |
-- Name: taxoninterpretation_plantname_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5191 |
-- Name: taxondetermination_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5192 | 5192 |
-- |
| 5193 | 5193 |
|
| 5194 |
CREATE INDEX taxoninterpretation_plantname_id_x ON taxondetermination USING btree (plantname_id);
|
|
| 5194 |
CREATE INDEX taxondetermination_role_id_x ON taxondetermination USING btree (role_id);
|
|
| 5195 | 5195 |
|
| 5196 | 5196 |
|
| 5197 | 5197 |
-- |
| 5198 |
-- Name: taxoninterpretation_reference_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5198 |
-- Name: taxondetermination_stemlocation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5199 | 5199 |
-- |
| 5200 | 5200 |
|
| 5201 |
CREATE INDEX taxoninterpretation_reference_id_x ON taxondetermination USING btree (reference_id);
|
|
| 5201 |
CREATE INDEX taxondetermination_stemlocation_id_x ON taxondetermination USING btree (stemobservation_id);
|
|
| 5202 | 5202 |
|
| 5203 | 5203 |
|
| 5204 | 5204 |
-- |
| 5205 |
-- Name: taxoninterpretation_role_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5205 |
-- Name: taxondetermination_taxonobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5206 | 5206 |
-- |
| 5207 | 5207 |
|
| 5208 |
CREATE INDEX taxoninterpretation_role_id_x ON taxondetermination USING btree (role_id);
|
|
| 5208 |
CREATE INDEX taxondetermination_taxonobservation_id_x ON taxondetermination USING btree (taxonoccurrence_id);
|
|
| 5209 | 5209 |
|
| 5210 | 5210 |
|
| 5211 | 5211 |
-- |
| 5212 |
-- Name: taxoninterpretation_stemlocation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5212 |
-- Name: taxonimportance_stratum_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5213 | 5213 |
-- |
| 5214 | 5214 |
|
| 5215 |
CREATE INDEX taxoninterpretation_stemlocation_id_x ON taxondetermination USING btree (stemobservation_id);
|
|
| 5215 |
CREATE INDEX taxonimportance_stratum_id_x ON collectiveobservation USING btree (stratum_id);
|
|
| 5216 | 5216 |
|
| 5217 | 5217 |
|
| 5218 | 5218 |
-- |
| 5219 |
-- Name: taxoninterpretation_taxonobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5219 |
-- Name: taxonimportance_taxonobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 5220 | 5220 |
-- |
| 5221 | 5221 |
|
| 5222 |
CREATE INDEX taxoninterpretation_taxonobservation_id_x ON taxondetermination USING btree (taxonoccurrence_id);
|
|
| 5222 |
CREATE INDEX taxonimportance_taxonobservation_id_x ON collectiveobservation USING btree (taxonoccurrence_id);
|
|
| 5223 | 5223 |
|
| 5224 | 5224 |
|
| 5225 | 5225 |
-- |
| ... | ... | |
| 5425 | 5425 |
|
| 5426 | 5426 |
|
| 5427 | 5427 |
-- |
| 5428 |
-- Name: r1comminterpretation_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5428 |
-- Name: r1commdetermination_commclass_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5429 | 5429 |
-- |
| 5430 | 5430 |
|
| 5431 |
ALTER TABLE ONLY comminterpretation
|
|
| 5432 |
ADD CONSTRAINT r1comminterpretation_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id);
|
|
| 5431 |
ALTER TABLE ONLY commdetermination
|
|
| 5432 |
ADD CONSTRAINT r1commdetermination_commclass_id FOREIGN KEY (commclass_id) REFERENCES commclass(commclass_id);
|
|
| 5433 | 5433 |
|
| 5434 | 5434 |
|
| 5435 | 5435 |
-- |
| ... | ... | |
| 5745 | 5745 |
|
| 5746 | 5746 |
|
| 5747 | 5747 |
-- |
| 5748 |
-- Name: r1taxonalt_taxoninterpretation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5748 |
-- Name: r1taxonalt_taxondetermination_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5749 | 5749 |
-- |
| 5750 | 5750 |
|
| 5751 | 5751 |
ALTER TABLE ONLY taxonalt |
| 5752 |
ADD CONSTRAINT r1taxonalt_taxoninterpretation_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id);
|
|
| 5752 |
ADD CONSTRAINT r1taxonalt_taxondetermination_id FOREIGN KEY (taxondetermination_id) REFERENCES taxondetermination(taxondetermination_id);
|
|
| 5753 | 5753 |
|
| 5754 | 5754 |
|
| 5755 | 5755 |
-- |
| 5756 |
-- Name: r1taxonimportance_taxonobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5756 |
-- Name: r1taxondetermination_taxonobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5757 | 5757 |
-- |
| 5758 | 5758 |
|
| 5759 |
ALTER TABLE ONLY collectiveobservation
|
|
| 5760 |
ADD CONSTRAINT r1taxonimportance_taxonobservation_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id);
|
|
| 5759 |
ALTER TABLE ONLY taxondetermination
|
|
| 5760 |
ADD CONSTRAINT r1taxondetermination_taxonobservation_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id);
|
|
| 5761 | 5761 |
|
| 5762 | 5762 |
|
| 5763 | 5763 |
-- |
| 5764 |
-- Name: r1taxoninterpretation_taxonobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5764 |
-- Name: r1taxonimportance_taxonobservation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5765 | 5765 |
-- |
| 5766 | 5766 |
|
| 5767 |
ALTER TABLE ONLY taxondetermination
|
|
| 5768 |
ADD CONSTRAINT r1taxoninterpretation_taxonobservation_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id);
|
|
| 5767 |
ALTER TABLE ONLY collectiveobservation
|
|
| 5768 |
ADD CONSTRAINT r1taxonimportance_taxonobservation_id FOREIGN KEY (taxonoccurrence_id) REFERENCES taxonoccurrence(taxonoccurrence_id);
|
|
| 5769 | 5769 |
|
| 5770 | 5770 |
|
| 5771 | 5771 |
-- |
| ... | ... | |
| 5905 | 5905 |
|
| 5906 | 5906 |
|
| 5907 | 5907 |
-- |
| 5908 |
-- Name: r2comminterpretation_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5908 |
-- Name: r2commdetermination_commconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5909 | 5909 |
-- |
| 5910 | 5910 |
|
| 5911 |
ALTER TABLE ONLY comminterpretation
|
|
| 5912 |
ADD CONSTRAINT r2comminterpretation_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id);
|
|
| 5911 |
ALTER TABLE ONLY commdetermination
|
|
| 5912 |
ADD CONSTRAINT r2commdetermination_commconcept_id FOREIGN KEY (commconcept_id) REFERENCES commconcept(commconcept_id);
|
|
| 5913 | 5913 |
|
| 5914 | 5914 |
|
| 5915 | 5915 |
-- |
| ... | ... | |
| 6073 | 6073 |
|
| 6074 | 6074 |
|
| 6075 | 6075 |
-- |
| 6076 |
-- Name: r2taxonimportance_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6076 |
-- Name: r2taxondetermination_stemlocation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6077 | 6077 |
-- |
| 6078 | 6078 |
|
| 6079 |
ALTER TABLE ONLY collectiveobservation
|
|
| 6080 |
ADD CONSTRAINT r2taxonimportance_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id);
|
|
| 6079 |
ALTER TABLE ONLY taxondetermination
|
|
| 6080 |
ADD CONSTRAINT r2taxondetermination_stemlocation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id);
|
|
| 6081 | 6081 |
|
| 6082 | 6082 |
|
| 6083 | 6083 |
-- |
| 6084 |
-- Name: r2taxoninterpretation_stemlocation_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6084 |
-- Name: r2taxonimportance_stratum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6085 | 6085 |
-- |
| 6086 | 6086 |
|
| 6087 |
ALTER TABLE ONLY taxondetermination
|
|
| 6088 |
ADD CONSTRAINT r2taxoninterpretation_stemlocation_id FOREIGN KEY (stemobservation_id) REFERENCES stemobservation(stemobservation_id);
|
|
| 6087 |
ALTER TABLE ONLY collectiveobservation
|
|
| 6088 |
ADD CONSTRAINT r2taxonimportance_stratum_id FOREIGN KEY (stratum_id) REFERENCES stratum(stratum_id);
|
|
| 6089 | 6089 |
|
| 6090 | 6090 |
|
| 6091 | 6091 |
-- |
| ... | ... | |
| 6113 | 6113 |
|
| 6114 | 6114 |
|
| 6115 | 6115 |
-- |
| 6116 |
-- Name: r3comminterpretation_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6116 |
-- Name: r3commdetermination_commauthority_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6117 | 6117 |
-- |
| 6118 | 6118 |
|
| 6119 |
ALTER TABLE ONLY comminterpretation
|
|
| 6120 |
ADD CONSTRAINT r3comminterpretation_commauthority_id FOREIGN KEY (commauthority_id) REFERENCES reference(reference_id);
|
|
| 6119 |
ALTER TABLE ONLY commdetermination
|
|
| 6120 |
ADD CONSTRAINT r3commdetermination_commauthority_id FOREIGN KEY (commauthority_id) REFERENCES reference(reference_id);
|
|
| 6121 | 6121 |
|
| 6122 | 6122 |
|
| 6123 | 6123 |
-- |
| ... | ... | |
| 6209 | 6209 |
|
| 6210 | 6210 |
|
| 6211 | 6211 |
-- |
| 6212 |
-- Name: r3taxoninterpretation_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6212 |
-- Name: r3taxondetermination_plantconcept_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6213 | 6213 |
-- |
| 6214 | 6214 |
|
| 6215 | 6215 |
ALTER TABLE ONLY taxondetermination |
| 6216 |
ADD CONSTRAINT r3taxoninterpretation_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id);
|
|
| 6216 |
ADD CONSTRAINT r3taxondetermination_plantconcept_id FOREIGN KEY (plantconcept_id) REFERENCES plantconcept(plantconcept_id);
|
|
| 6217 | 6217 |
|
| 6218 | 6218 |
|
| 6219 | 6219 |
-- |
| ... | ... | |
| 6265 | 6265 |
|
| 6266 | 6266 |
|
| 6267 | 6267 |
-- |
| 6268 |
-- Name: r4taxoninterpretation_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6268 |
-- Name: r4taxondetermination_plantname_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6269 | 6269 |
-- |
| 6270 | 6270 |
|
| 6271 | 6271 |
ALTER TABLE ONLY taxondetermination |
| 6272 |
ADD CONSTRAINT r4taxoninterpretation_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id);
|
|
| 6272 |
ADD CONSTRAINT r4taxondetermination_plantname_id FOREIGN KEY (plantname_id) REFERENCES plantname(plantname_id);
|
|
| 6273 | 6273 |
|
| 6274 | 6274 |
|
| 6275 | 6275 |
-- |
| ... | ... | |
| 6281 | 6281 |
|
| 6282 | 6282 |
|
| 6283 | 6283 |
-- |
| 6284 |
-- Name: r5taxoninterpretation_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6284 |
-- Name: r5taxondetermination_party_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6285 | 6285 |
-- |
| 6286 | 6286 |
|
| 6287 | 6287 |
ALTER TABLE ONLY taxondetermination |
| 6288 |
ADD CONSTRAINT r5taxoninterpretation_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);
|
|
| 6288 |
ADD CONSTRAINT r5taxondetermination_party_id FOREIGN KEY (party_id) REFERENCES party(party_id);
|
|
| 6289 | 6289 |
|
| 6290 | 6290 |
|
| 6291 | 6291 |
-- |
| ... | ... | |
| 6297 | 6297 |
|
| 6298 | 6298 |
|
| 6299 | 6299 |
-- |
| 6300 |
-- Name: r6taxoninterpretation_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6300 |
-- Name: r6taxondetermination_role_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6301 | 6301 |
-- |
| 6302 | 6302 |
|
| 6303 | 6303 |
ALTER TABLE ONLY taxondetermination |
| 6304 |
ADD CONSTRAINT r6taxoninterpretation_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);
|
|
| 6304 |
ADD CONSTRAINT r6taxondetermination_role_id FOREIGN KEY (role_id) REFERENCES aux_role(role_id);
|
|
| 6305 | 6305 |
|
| 6306 | 6306 |
|
| 6307 | 6307 |
-- |
| 6308 |
-- Name: r7taxoninterpretation_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6308 |
-- Name: r7taxondetermination_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6309 | 6309 |
-- |
| 6310 | 6310 |
|
| 6311 | 6311 |
ALTER TABLE ONLY taxondetermination |
| 6312 |
ADD CONSTRAINT r7taxoninterpretation_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);
|
|
| 6312 |
ADD CONSTRAINT r7taxondetermination_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id);
|
|
| 6313 | 6313 |
|
| 6314 | 6314 |
|
| 6315 | 6315 |
-- |
| 6316 |
-- Name: r8taxoninterpretation_collector_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6316 |
-- Name: r8taxondetermination_collector_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6317 | 6317 |
-- |
| 6318 | 6318 |
|
| 6319 | 6319 |
ALTER TABLE ONLY taxondetermination |
| 6320 |
ADD CONSTRAINT r8taxoninterpretation_collector_id FOREIGN KEY (collector_id) REFERENCES party(party_id);
|
|
| 6320 |
ADD CONSTRAINT r8taxondetermination_collector_id FOREIGN KEY (collector_id) REFERENCES party(party_id);
|
|
| 6321 | 6321 |
|
| 6322 | 6322 |
|
| 6323 | 6323 |
-- |
| 6324 |
-- Name: r9taxoninterpretation_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6324 |
-- Name: r9taxondetermination_museum_id; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6325 | 6325 |
-- |
| 6326 | 6326 |
|
| 6327 | 6327 |
ALTER TABLE ONLY taxondetermination |
| 6328 |
ADD CONSTRAINT r9taxoninterpretation_museum_id FOREIGN KEY (museum_id) REFERENCES party(party_id);
|
|
| 6328 |
ADD CONSTRAINT r9taxondetermination_museum_id FOREIGN KEY (museum_id) REFERENCES party(party_id);
|
|
| 6329 | 6329 |
|
| 6330 | 6330 |
|
| 6331 | 6331 |
-- |
| 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]/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]/notes, |
| 23 |
Family,"/taxondetermination[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Family]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",
|
|
| 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 | 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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",
|
|
| 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 | 27 |
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", |
| 28 |
infra_ep_1,"/taxondetermination[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Subspecies]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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=identifier,*_ID/plantConcept/plantStatus/plantLevel=Species]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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
|
|
| 31 |
PlotObsID,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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."
|
|
| 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]/*_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/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",Brad: OMIT |
|
| 30 |
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
|
|
| 31 |
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/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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.plots.csv | ||
|---|---|---|
| 17 | 17 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
|
| 18 | 18 |
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
|
| 19 | 19 |
/*ID->/*s/project/title,/*_ID/project/projectName |
| 20 |
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
|
|
| 21 |
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/commClass/commInterpretation/*_ID/commConcept/commDescription
|
|
| 20 |
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commClass/commdetermination/*_ID/commConcept/*_ID/*/commName
|
|
| 21 |
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/commClass/commdetermination/*_ID/commConcept/commDescription
|
|
| 22 | 22 |
/simpleUserdefined[name=precipMm]/value,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue" |
| 23 | 23 |
/temperature,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue" |
| 24 | 24 |
/simpleUserdefined[name=plotMethodology]/value,/methodNarrative |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 17 | 17 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_ID/plotevent/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}"
|
| 18 | 18 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_ID/plotevent/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}"
|
| 19 | 19 |
/*ID->/*s/plotObservation/*ID->/*s/project/title,/*_ID/plotevent/*_ID/project/projectName |
| 20 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/*_ID/plotevent/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName
|
|
| 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/*_ID/plotevent/commClass/commInterpretation/*_ID/commConcept/commDescription
|
|
| 20 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/*_ID/plotevent/commClass/commdetermination/*_ID/commConcept/*_ID/*/commName
|
|
| 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/name,/*_ID/plotevent/commClass/commdetermination/*_ID/commConcept/commDescription
|
|
| 22 | 22 |
/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value,"/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue" |
| 23 | 23 |
/*ID->/*s/plotObservation/temperature,"/*_ID/plotevent/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue" |
| 24 | 24 |
/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value,/*_ID/plotevent/methodNarrative |
| ... | ... | |
| 86 | 86 |
/*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 |
| 87 | 87 |
/*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 |
| 88 | 88 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,/taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/notes |
| 89 |
"/*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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=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=gen])/Name","/taxondetermination[ROLE_ID/aux_Role/roleCode=computer,*_ID/plantConcept/plantStatus/plantLevel=Genus]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
|
|
| 89 |
"/*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"
|
|
| 90 |
"/*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"
|
|
| 91 | 91 |
"/*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" |
| 92 |
"/*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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
|
|
| 92 |
"/*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"
|
|
| 93 | 93 |
"/*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" |
| 94 |
"/*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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName/_name/last"
|
|
| 95 |
"/*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]/interpretationDate/_date/day"
|
|
| 96 |
"/*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]/interpretationDate/_date/month"
|
|
| 97 |
"/*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]/interpretationDate/_date/year"
|
|
| 98 |
"/*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]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=true]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
|
|
| 99 |
"/*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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName"
|
|
| 100 |
"/*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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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=gen])/Name","/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Genus]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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=reg])/Name","/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Kingdom]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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=ord])/Name","/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,*_ID/plantConcept/plantStatus/plantLevel=Order]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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])/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"
|
|
| 95 |
"/*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"
|
|
| 96 |
"/*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"
|
|
| 97 |
"/*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"
|
|
| 98 |
"/*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}"
|
|
| 99 |
"/*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"
|
|
| 100 |
"/*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"
|
|
| 101 |
"/*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"
|
|
| 102 |
"/*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"
|
|
| 103 |
"/*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"
|
|
| 104 | 104 |
"/*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}"
|
| 105 |
"/*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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_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=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"
|
|
| 106 | 106 |
"/*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" |
| 107 |
"/*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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName,taxondetermination[ROLE_ID/aux_Role/roleCode=collector]/*_ID/plantConcept:[*_ID/reference]/*_ID/*/plantName/_alt/1}"
|
|
| 108 |
"/*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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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}"
|
|
| 109 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,":[collectiveobservation/count/_alt/2=1]/{taxondetermination[ROLE_ID/aux_Role/roleCode=collector]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_alt/3}"
|
|
| 107 |
"/*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}"
|
|
| 108 |
"/*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}"
|
|
| 109 |
/*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/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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]/interpretationDate/_date/day",
|
|
| 28 |
MonthIdentified,"/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/month",
|
|
| 29 |
YearIdentified,"/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]/interpretationDate/_date/year",
|
|
| 30 |
IdentifiedBy,"/taxondetermination[ROLE_ID/aux_Role/roleCode=identifier,!*_ID/plantConcept/plantStatus]:[interpretationType=Author,originalInterpretation=false,currentInterpretation=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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/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",
|
|
| 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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",
|
|
| 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 | 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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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"
|
|
| 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/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 92 | 92 |
//*s/taxonConcept[@code=sp]/Name,"/taxondetermination[roleCode=computer,plantLevel=Species]/*_ID/plantConcept/*_ID/*/plantName" |
| 93 | 93 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Rank,"/taxondetermination[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/first" |
| 94 | 94 |
//*s/taxonConcept[@code=TaxonomicRankBelowSubspeciesEnum]/Name,"/taxondetermination[roleCode=computer,plantLevel=Subspecies]/*_ID/plantConcept/*_ID/*/plantName/_name/last" |
| 95 |
//*s/taxonDetermination[role=identifier]/date/_date/day,/taxondetermination[roleCode=identifier]/interpretationDate/_date/day
|
|
| 96 |
//*s/taxonDetermination[role=identifier]/date/_date/month,/taxondetermination[roleCode=identifier]/interpretationDate/_date/month
|
|
| 97 |
//*s/taxonDetermination[role=identifier]/date/_date/year,/taxondetermination[roleCode=identifier]/interpretationDate/_date/year
|
|
| 95 |
//*s/taxonDetermination[role=identifier]/date/_date/day,/taxondetermination[roleCode=identifier]/determinationDate/_date/day
|
|
| 96 |
//*s/taxonDetermination[role=identifier]/date/_date/month,/taxondetermination[roleCode=identifier]/determinationDate/_date/month
|
|
| 97 |
//*s/taxonDetermination[role=identifier]/date/_date/year,/taxondetermination[roleCode=identifier]/determinationDate/_date/year
|
|
| 98 | 98 |
"//parties/party/individualName/{givenName/_namePart/{first,middle},surName/_namePart/last}","/taxondetermination[roleCode=identifier]/*_ID/party/{givenName/_namePart/first,middleName/_namePart/middle,surName/_namePart/last}"
|
| 99 | 99 |
//*s/taxonConcept[@code=cl]/Name,"/taxondetermination[roleCode=identifier,plantLevel=Class]/*_ID/plantConcept/*_ID/*/plantName" |
| 100 | 100 |
//*s/taxonConcept[@code=fam]/Name,"/taxondetermination[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName" |
| mappings/for_review/NYBG-VegBIEN.organisms.csv | ||
|---|---|---|
| 24 | 24 |
InstitutionCode,/taxondetermination[roleCode=collector]/museum_ID/party/OrganizationName/_name/first, |
| 25 | 25 |
CollectionCode,/taxondetermination[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[roleCode=collector]/notes,"Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes" |
| 27 |
DayIdentified,/taxondetermination[roleCode=identifier]/interpretationDate/_date/day,
|
|
| 28 |
MonthIdentified,/taxondetermination[roleCode=identifier]/interpretationDate/_date/month,
|
|
| 29 |
YearIdentified,/taxondetermination[roleCode=identifier]/interpretationDate/_date/year,
|
|
| 27 |
DayIdentified,/taxondetermination[roleCode=identifier]/determinationDate/_date/day,
|
|
| 28 |
MonthIdentified,/taxondetermination[roleCode=identifier]/determinationDate/_date/month,
|
|
| 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 | 31 |
Class,"/taxondetermination[roleCode=identifier,plantLevel=Class]/*_ID/plantConcept/*_ID/*/plantName", |
| 32 | 32 |
Family,"/taxondetermination[roleCode=identifier,plantLevel=Family]/*_ID/plantConcept/*_ID/*/plantName", |
| mappings/SALVIAS-VegBIEN.plots.csv | ||
|---|---|---|
| 13 | 13 |
elev_max_m,"/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}",
|
| 14 | 14 |
elev_min_m,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}",
|
| 15 | 15 |
project,/*_ID/project/projectName, |
| 16 |
life_zone_code,/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName,
|
|
| 17 |
holdridge_life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription,
|
|
| 16 |
life_zone_code,/commClass/commdetermination/*_ID/commConcept/*_ID/*/commName,
|
|
| 17 |
holdridge_life_zone,/commClass/commdetermination/*_ID/commConcept/commDescription,
|
|
| 18 | 18 |
precip_mm,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue", |
| 19 | 19 |
temp_c,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue", |
| 20 | 20 |
plot_methodology,/methodNarrative, |
| 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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=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/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 | 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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=epoch,*_ID/party]/*_ID/plantConcept:[plantStatus:[plantConceptStatus=accepted,startDate=epoch,*_ID/party],*_ID/reference]/*_ID/*/plantName",
|
|
| 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 | 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]:[interpretationType=""Computer (automated)"",originalInterpretation=false,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=true,interpretationDate=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]:[interpretationType=Author,originalInterpretation=true,currentInterpretation=false,interpretationDate=epoch,*_ID/plantConcept:[*_ID/reference],*_ID/party]/museumAccessionNumber,*_ID/plotevent/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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."
|
|
| 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/*_ID/plot:[confidentialityStatus=0]/authorPlotCode/_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_db-VegBIEN.plots.csv | ||
|---|---|---|
| 13 | 13 |
elev_max_m,"/*_ID/plot/{elevation/_avg/max,elevationRange/_range/to}",
|
| 14 | 14 |
elev_min_m,"/*_ID/plot/{elevation/_avg/min,elevationRange/_range/from}",
|
| 15 | 15 |
project_id,/*_ID/project/projectName, |
| 16 |
life_zone_code,/commClass/commInterpretation/*_ID/commConcept/*_ID/*/commName,
|
|
| 17 |
life_zone,/commClass/commInterpretation/*_ID/commConcept/commDescription,
|
|
| 16 |
life_zone_code,/commClass/commdetermination/*_ID/commConcept/*_ID/*/commName,
|
|
| 17 |
life_zone,/commClass/commdetermination/*_ID/commConcept/commDescription,
|
|
| 18 | 18 |
Precip,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=precipitationMm]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue", |
| 19 | 19 |
Temp,"/definedValue[*_ID/userDefined[tableName=plotevent,userDefinedName=temperatureC]:[userDefinedType=varchar]]:[@fkey=tableRecord_ID]/definedValue", |
| 20 | 20 |
PlotMethod,/methodNarrative, |
Also available in: Unified diff
vegbien db: Renamed all occurrences of interpretation to determination