Revision 600
Added by Aaron Marcuse-Kubitza almost 13 years ago
| test/accepted_output/SALVIAS.organisms.VegBIEN.xml | ||
|---|---|---|
| 82 | 82 |
<originaldetermination>true</originaldetermination> |
| 83 | 83 |
<plantconcept_id> |
| 84 | 84 |
<plantconcept> |
| 85 |
<reference_id> |
|
| 86 |
<reference/> |
|
| 87 |
</reference_id> |
|
| 88 | 85 |
<plantname_id> |
| 89 | 86 |
<plantname> |
| 90 | 87 |
<plantname>Inga indet</plantname> |
| ... | ... | |
| 104 | 101 |
<plantstatus> |
| 105 | 102 |
<plantlevel>Family</plantlevel> |
| 106 | 103 |
</plantstatus> |
| 107 |
<reference_id> |
|
| 108 |
<reference/> |
|
| 109 |
</reference_id> |
|
| 110 | 104 |
<plantname_id> |
| 111 | 105 |
<plantname> |
| 112 | 106 |
<plantname>Fabaceae</plantname> |
| ... | ... | |
| 128 | 122 |
<plantstatus> |
| 129 | 123 |
<plantlevel>Genus</plantlevel> |
| 130 | 124 |
</plantstatus> |
| 131 |
<reference_id> |
|
| 132 |
<reference/> |
|
| 133 |
</reference_id> |
|
| 134 | 125 |
<plantname_id> |
| 135 | 126 |
<plantname> |
| 136 | 127 |
<plantname>Inga</plantname> |
| ... | ... | |
| 152 | 143 |
<plantstatus> |
| 153 | 144 |
<plantlevel>Species</plantlevel> |
| 154 | 145 |
</plantstatus> |
| 155 |
<reference_id> |
|
| 156 |
<reference/> |
|
| 157 |
</reference_id> |
|
| 158 | 146 |
<plantname_id> |
| 159 | 147 |
<plantname> |
| 160 | 148 |
<plantname>indet</plantname> |
| ... | ... | |
| 176 | 164 |
<plantstatus> |
| 177 | 165 |
<plantlevel>Family</plantlevel> |
| 178 | 166 |
</plantstatus> |
| 179 |
<reference_id> |
|
| 180 |
<reference/> |
|
| 181 |
</reference_id> |
|
| 182 | 167 |
<plantname_id> |
| 183 | 168 |
<plantname> |
| 184 | 169 |
<plantname>Fabaceae</plantname> |
| ... | ... | |
| 201 | 186 |
<plantstatus> |
| 202 | 187 |
<plantlevel>Species</plantlevel> |
| 203 | 188 |
</plantstatus> |
| 204 |
<reference_id> |
|
| 205 |
<reference/> |
|
| 206 |
</reference_id> |
|
| 207 | 189 |
<plantname_id> |
| 208 | 190 |
<plantname> |
| 209 | 191 |
<plantname>Inga indet</plantname> |
| ... | ... | |
| 298 | 280 |
<originaldetermination>true</originaldetermination> |
| 299 | 281 |
<plantconcept_id> |
| 300 | 282 |
<plantconcept> |
| 301 |
<reference_id> |
|
| 302 |
<reference/> |
|
| 303 |
</reference_id> |
|
| 304 | 283 |
<plantname_id> |
| 305 | 284 |
<plantname> |
| 306 | 285 |
<plantname>Virola pavonis</plantname> |
| ... | ... | |
| 320 | 299 |
<plantstatus> |
| 321 | 300 |
<plantlevel>Family</plantlevel> |
| 322 | 301 |
</plantstatus> |
| 323 |
<reference_id> |
|
| 324 |
<reference/> |
|
| 325 |
</reference_id> |
|
| 326 | 302 |
<plantname_id> |
| 327 | 303 |
<plantname> |
| 328 | 304 |
<plantname>Myristicaceae</plantname> |
| ... | ... | |
| 344 | 320 |
<plantstatus> |
| 345 | 321 |
<plantlevel>Genus</plantlevel> |
| 346 | 322 |
</plantstatus> |
| 347 |
<reference_id> |
|
| 348 |
<reference/> |
|
| 349 |
</reference_id> |
|
| 350 | 323 |
<plantname_id> |
| 351 | 324 |
<plantname> |
| 352 | 325 |
<plantname>Virola</plantname> |
| ... | ... | |
| 368 | 341 |
<plantstatus> |
| 369 | 342 |
<plantlevel>Species</plantlevel> |
| 370 | 343 |
</plantstatus> |
| 371 |
<reference_id> |
|
| 372 |
<reference/> |
|
| 373 |
</reference_id> |
|
| 374 | 344 |
<plantname_id> |
| 375 | 345 |
<plantname> |
| 376 | 346 |
<plantname>pavonis</plantname> |
| ... | ... | |
| 392 | 362 |
<plantstatus> |
| 393 | 363 |
<plantlevel>Family</plantlevel> |
| 394 | 364 |
</plantstatus> |
| 395 |
<reference_id> |
|
| 396 |
<reference/> |
|
| 397 |
</reference_id> |
|
| 398 | 365 |
<plantname_id> |
| 399 | 366 |
<plantname> |
| 400 | 367 |
<plantname>Myristicaceae</plantname> |
| ... | ... | |
| 417 | 384 |
<plantstatus> |
| 418 | 385 |
<plantlevel>Species</plantlevel> |
| 419 | 386 |
</plantstatus> |
| 420 |
<reference_id> |
|
| 421 |
<reference/> |
|
| 422 |
</reference_id> |
|
| 423 | 387 |
<plantname_id> |
| 424 | 388 |
<plantname> |
| 425 | 389 |
<plantname>Virola pavonis</plantname> |
| test/accepted_output/SALVIAS_db.organisms.VegBIEN.xml | ||
|---|---|---|
| 69 | 69 |
<originaldetermination>true</originaldetermination> |
| 70 | 70 |
<plantconcept_id> |
| 71 | 71 |
<plantconcept> |
| 72 |
<reference_id> |
|
| 73 |
<reference/> |
|
| 74 |
</reference_id> |
|
| 75 | 72 |
<plantname_id> |
| 76 | 73 |
<plantname> |
| 77 | 74 |
<plantname>seleri</plantname> |
| ... | ... | |
| 91 | 88 |
<plantstatus> |
| 92 | 89 |
<plantlevel>Authority</plantlevel> |
| 93 | 90 |
</plantstatus> |
| 94 |
<reference_id> |
|
| 95 |
<reference/> |
|
| 96 |
</reference_id> |
|
| 97 | 91 |
<plantname_id> |
| 98 | 92 |
<plantname> |
| 99 | 93 |
<plantname>Burret</plantname> |
| ... | ... | |
| 115 | 109 |
<plantstatus> |
| 116 | 110 |
<plantlevel>Family</plantlevel> |
| 117 | 111 |
</plantstatus> |
| 118 |
<reference_id> |
|
| 119 |
<reference/> |
|
| 120 |
</reference_id> |
|
| 121 | 112 |
<plantname_id> |
| 122 | 113 |
<plantname> |
| 123 | 114 |
<plantname>Arecaceae</plantname> |
| ... | ... | |
| 139 | 130 |
<plantstatus> |
| 140 | 131 |
<plantlevel>Genus</plantlevel> |
| 141 | 132 |
</plantstatus> |
| 142 |
<reference_id> |
|
| 143 |
<reference/> |
|
| 144 |
</reference_id> |
|
| 145 | 133 |
<plantname_id> |
| 146 | 134 |
<plantname> |
| 147 | 135 |
<plantname>Geonoma</plantname> |
| ... | ... | |
| 163 | 151 |
<plantstatus> |
| 164 | 152 |
<plantlevel>Species</plantlevel> |
| 165 | 153 |
</plantstatus> |
| 166 |
<reference_id> |
|
| 167 |
<reference/> |
|
| 168 |
</reference_id> |
|
| 169 | 154 |
<plantname_id> |
| 170 | 155 |
<plantname> |
| 171 | 156 |
<plantname>seleri</plantname> |
| ... | ... | |
| 187 | 172 |
<plantstatus> |
| 188 | 173 |
<plantlevel>Family</plantlevel> |
| 189 | 174 |
</plantstatus> |
| 190 |
<reference_id> |
|
| 191 |
<reference/> |
|
| 192 |
</reference_id> |
|
| 193 | 175 |
<plantname_id> |
| 194 | 176 |
<plantname> |
| 195 | 177 |
<plantname>Arecaceae</plantname> |
| ... | ... | |
| 212 | 194 |
<plantstatus> |
| 213 | 195 |
<plantlevel>Species</plantlevel> |
| 214 | 196 |
</plantstatus> |
| 215 |
<reference_id> |
|
| 216 |
<reference/> |
|
| 217 |
</reference_id> |
|
| 218 | 197 |
<plantname_id> |
| 219 | 198 |
<plantname> |
| 220 | 199 |
<plantname>seleri</plantname> |
| ... | ... | |
| 302 | 281 |
<originaldetermination>true</originaldetermination> |
| 303 | 282 |
<plantconcept_id> |
| 304 | 283 |
<plantconcept> |
| 305 |
<reference_id> |
|
| 306 |
<reference/> |
|
| 307 |
</reference_id> |
|
| 308 | 284 |
<plantname_id> |
| 309 | 285 |
<plantname> |
| 310 | 286 |
<plantname>allenii</plantname> |
| ... | ... | |
| 324 | 300 |
<plantstatus> |
| 325 | 301 |
<plantlevel>Authority</plantlevel> |
| 326 | 302 |
</plantstatus> |
| 327 |
<reference_id> |
|
| 328 |
<reference/> |
|
| 329 |
</reference_id> |
|
| 330 | 303 |
<plantname_id> |
| 331 | 304 |
<plantname> |
| 332 | 305 |
<plantname>Maguire</plantname> |
| ... | ... | |
| 348 | 321 |
<plantstatus> |
| 349 | 322 |
<plantlevel>Family</plantlevel> |
| 350 | 323 |
</plantstatus> |
| 351 |
<reference_id> |
|
| 352 |
<reference/> |
|
| 353 |
</reference_id> |
|
| 354 | 324 |
<plantname_id> |
| 355 | 325 |
<plantname> |
| 356 | 326 |
<plantname>Clusiaceae</plantname> |
| ... | ... | |
| 372 | 342 |
<plantstatus> |
| 373 | 343 |
<plantlevel>Genus</plantlevel> |
| 374 | 344 |
</plantstatus> |
| 375 |
<reference_id> |
|
| 376 |
<reference/> |
|
| 377 |
</reference_id> |
|
| 378 | 345 |
<plantname_id> |
| 379 | 346 |
<plantname> |
| 380 | 347 |
<plantname>Tovomitopsis</plantname> |
| ... | ... | |
| 396 | 363 |
<plantstatus> |
| 397 | 364 |
<plantlevel>Species</plantlevel> |
| 398 | 365 |
</plantstatus> |
| 399 |
<reference_id> |
|
| 400 |
<reference/> |
|
| 401 |
</reference_id> |
|
| 402 | 366 |
<plantname_id> |
| 403 | 367 |
<plantname> |
| 404 | 368 |
<plantname>allenii</plantname> |
| ... | ... | |
| 420 | 384 |
<plantstatus> |
| 421 | 385 |
<plantlevel>Family</plantlevel> |
| 422 | 386 |
</plantstatus> |
| 423 |
<reference_id> |
|
| 424 |
<reference/> |
|
| 425 |
</reference_id> |
|
| 426 | 387 |
<plantname_id> |
| 427 | 388 |
<plantname> |
| 428 | 389 |
<plantname>Clusiaceae</plantname> |
| ... | ... | |
| 445 | 406 |
<plantstatus> |
| 446 | 407 |
<plantlevel>Species</plantlevel> |
| 447 | 408 |
</plantstatus> |
| 448 |
<reference_id> |
|
| 449 |
<reference/> |
|
| 450 |
</reference_id> |
|
| 451 | 409 |
<plantname_id> |
| 452 | 410 |
<plantname> |
| 453 | 411 |
<plantname>allenii</plantname> |
| test/accepted_output/NYBG.organisms.VegBIEN.xml | ||
|---|---|---|
| 101 | 101 |
<currentdetermination>true</currentdetermination> |
| 102 | 102 |
<plantconcept_id> |
| 103 | 103 |
<plantconcept> |
| 104 |
<reference_id> |
|
| 105 |
<reference/> |
|
| 106 |
</reference_id> |
|
| 107 | 104 |
<plantname_id> |
| 108 | 105 |
<plantname> |
| 109 | 106 |
<plantname>Cariniana estrellensis (Raddi) Kuntze</plantname> |
| ... | ... | |
| 123 | 120 |
<plantstatus> |
| 124 | 121 |
<plantlevel>Authority</plantlevel> |
| 125 | 122 |
</plantstatus> |
| 126 |
<reference_id> |
|
| 127 |
<reference/> |
|
| 128 |
</reference_id> |
|
| 129 | 123 |
<plantname_id> |
| 130 | 124 |
<plantname> |
| 131 | 125 |
<plantname>(Raddi) Kuntze</plantname> |
| ... | ... | |
| 148 | 142 |
<plantstatus> |
| 149 | 143 |
<plantlevel>Family</plantlevel> |
| 150 | 144 |
</plantstatus> |
| 151 |
<reference_id> |
|
| 152 |
<reference/> |
|
| 153 |
</reference_id> |
|
| 154 | 145 |
<plantname_id> |
| 155 | 146 |
<plantname> |
| 156 | 147 |
<plantname>Lecythidaceae</plantname> |
| ... | ... | |
| 173 | 164 |
<plantstatus> |
| 174 | 165 |
<plantlevel>Genus</plantlevel> |
| 175 | 166 |
</plantstatus> |
| 176 |
<reference_id> |
|
| 177 |
<reference/> |
|
| 178 |
</reference_id> |
|
| 179 | 167 |
<plantname_id> |
| 180 | 168 |
<plantname> |
| 181 | 169 |
<plantname>Cariniana</plantname> |
| ... | ... | |
| 198 | 186 |
<plantstatus> |
| 199 | 187 |
<plantlevel>Kingdom</plantlevel> |
| 200 | 188 |
</plantstatus> |
| 201 |
<reference_id> |
|
| 202 |
<reference/> |
|
| 203 |
</reference_id> |
|
| 204 | 189 |
<plantname_id> |
| 205 | 190 |
<plantname> |
| 206 | 191 |
<plantname>Plantae</plantname> |
| ... | ... | |
| 223 | 208 |
<plantstatus> |
| 224 | 209 |
<plantlevel>Subkingdom</plantlevel> |
| 225 | 210 |
</plantstatus> |
| 226 |
<reference_id> |
|
| 227 |
<reference/> |
|
| 228 |
</reference_id> |
|
| 229 | 211 |
<plantname_id> |
| 230 | 212 |
<plantname> |
| 231 | 213 |
<plantname>Magnoliophyta (flowering plants)</plantname> |
| ... | ... | |
| 248 | 230 |
<plantstatus> |
| 249 | 231 |
<plantlevel>Species</plantlevel> |
| 250 | 232 |
</plantstatus> |
| 251 |
<reference_id> |
|
| 252 |
<reference/> |
|
| 253 |
</reference_id> |
|
| 254 | 233 |
<plantname_id> |
| 255 | 234 |
<plantname> |
| 256 | 235 |
<plantname>estrellensis</plantname> |
| ... | ... | |
| 328 | 307 |
<currentdetermination>true</currentdetermination> |
| 329 | 308 |
<plantconcept_id> |
| 330 | 309 |
<plantconcept> |
| 331 |
<reference_id> |
|
| 332 |
<reference/> |
|
| 333 |
</reference_id> |
|
| 334 | 310 |
<plantname_id> |
| 335 | 311 |
<plantname> |
| 336 | 312 |
<plantname>Scrophulariaceae</plantname> |
| ... | ... | |
| 350 | 326 |
<plantstatus> |
| 351 | 327 |
<plantlevel>Family</plantlevel> |
| 352 | 328 |
</plantstatus> |
| 353 |
<reference_id> |
|
| 354 |
<reference/> |
|
| 355 |
</reference_id> |
|
| 356 | 329 |
<plantname_id> |
| 357 | 330 |
<plantname> |
| 358 | 331 |
<plantname>Scrophulariaceae</plantname> |
| ... | ... | |
| 375 | 348 |
<plantstatus> |
| 376 | 349 |
<plantlevel>Kingdom</plantlevel> |
| 377 | 350 |
</plantstatus> |
| 378 |
<reference_id> |
|
| 379 |
<reference/> |
|
| 380 |
</reference_id> |
|
| 381 | 351 |
<plantname_id> |
| 382 | 352 |
<plantname> |
| 383 | 353 |
<plantname>Plantae</plantname> |
| ... | ... | |
| 400 | 370 |
<plantstatus> |
| 401 | 371 |
<plantlevel>Subkingdom</plantlevel> |
| 402 | 372 |
</plantstatus> |
| 403 |
<reference_id> |
|
| 404 |
<reference/> |
|
| 405 |
</reference_id> |
|
| 406 | 373 |
<plantname_id> |
| 407 | 374 |
<plantname> |
| 408 | 375 |
<plantname>Magnoliophyta (flowering plants)</plantname> |
| inputs/SALVIAS/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 20 | 20 |
Habit,"/taxondetermination[role_id/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/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/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/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/notes", |
| 23 |
auth,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
|
|
| 24 |
Family,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 25 |
Genus,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 26 |
Species,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 27 |
infra_rank_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[*_id/reference]/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/_name/last",
|
|
| 29 |
OrigFamily,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",Brad: OMIT
|
|
| 30 |
OrigSpecies,"/{taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 23 |
auth,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss. |
|
| 24 |
Family,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 25 |
Genus,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 26 |
Species,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 27 |
infra_rank_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/_name/last", |
|
| 29 |
OrigFamily,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT |
|
| 30 |
OrigSpecies,"/{taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
|
|
| 31 | 31 |
PlotObsID,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode,*_id/locationevent/authoreventcode/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/authorlocationcode/_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.organisms.csv | ||
|---|---|---|
| 20 | 20 |
Habit,"/taxondetermination[role_id/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/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/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/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/notes", |
| 23 |
auth,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
|
|
| 24 |
Family,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 25 |
Genus,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 26 |
Species,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 27 |
infra_rank_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[*_id/reference]/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/_name/last",
|
|
| 29 |
OrigFamily,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",Brad: OMIT
|
|
| 30 |
OrigSpecies,"/{taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 23 |
auth,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss. |
|
| 24 |
Family,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 25 |
Genus,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 26 |
Species,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 27 |
infra_rank_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/_name/first}",
|
|
| 28 |
infra_ep_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/_name/last", |
|
| 29 |
OrigFamily,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT |
|
| 30 |
OrigSpecies,"/{taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
|
|
| 31 | 31 |
PlotObsID,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode,*_id/locationevent/authoreventcode/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/authorlocationcode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
|
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 102 | 102 |
/*ID->/*s/individualOrganism/simpleUserdefined[name=sex]/value,"/taxondetermination[role_id/role/rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue" |
| 103 | 103 |
/simpleUserdefined[name=individualCode]/value,"/taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=individualCode]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue" |
| 104 | 104 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/note/text,"/taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/notes" |
| 105 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/1"
|
|
| 106 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 107 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 108 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 109 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=sp])/Name","/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 110 |
"/*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/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[*_id/reference]/_name/first}"
|
|
| 111 |
"/*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/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/_name/last"
|
|
| 105 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonName)/Simple","/taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/1" |
|
| 106 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=computer]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 107 |
"/*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/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 108 |
"/*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/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 109 |
"/*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/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 110 |
"/*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/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/_name/first}"
|
|
| 111 |
"/*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/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/_name/last" |
|
| 112 | 112 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/day","/taxondetermination[role_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day" |
| 113 | 113 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/month","/taxondetermination[role_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month" |
| 114 | 114 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/date/_date/year","/taxondetermination[role_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/year" |
| 115 | 115 |
"/*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/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}"
|
| 116 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 117 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 118 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 119 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 120 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 121 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 122 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 123 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname"
|
|
| 124 |
"/*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/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname}"
|
|
| 116 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=auth])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 117 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=cl])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 118 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=fam])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 119 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=gen])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 120 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=reg])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 121 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ord])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 122 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=phyl_div])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname" |
|
| 123 |
"/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept->/*s/taxonDetermination[*ID,partyWithRole/role=identifier]/*s/taxonRelationshipAssertion(/assertion/*ID->/*s/taxonConcept[Rank/@code=ssp])/Name","/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname" |
|
| 124 |
"/*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/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname}"
|
|
| 125 | 125 |
/*ID->/*s/individualOrganism/*sID->/*s/taxonNameUsageConcept/voucher,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode,*_id/locationevent/authoreventcode/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/authorlocationcode/_alt/3}"
|
| mappings/NYBG-VegBIEN.organisms.csv | ||
|---|---|---|
| 25 | 25 |
CollectionCode,"/specimen:[*_id/reference]/{museum_id/party/organizationname/_name/last,collectioncode_dwc}",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 |
Sex,"/taxondetermination[role_id/role/rolecode=collector]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]:[userdefinedtype=varchar]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections" |
| 27 | 27 |
Notes,"/taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/notes","Brad: mapping OK; NY appears to be using this field for almost anything, but mostly internal collections notes" |
| 28 |
ScientificName,"/taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/1","Brad: Bob, Nick, please is this mapping OK?"
|
|
| 28 |
ScientificName,"/taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/1","Brad: Bob, Nick, please is this mapping OK?" |
|
| 29 | 29 |
DayIdentified,"/taxondetermination[role_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/day", |
| 30 | 30 |
MonthIdentified,"/taxondetermination[role_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/month", |
| 31 | 31 |
YearIdentified,"/taxondetermination[role_id/role/rolecode=identifier,!*_id/plantconcept]/determinationdate/_date/year", |
| 32 | 32 |
IdentifiedBy,"/taxondetermination[role_id/role/rolecode=identifier,!*_id/plantconcept]:[determinationtype=Author,currentdetermination=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?
|
| 33 |
ScientificNameAuthor,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author"
|
|
| 34 |
Class,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 35 |
Family,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 36 |
Genus,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 37 |
Kingdom,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 38 |
Order,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 39 |
Phylum,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 40 |
Subspecies,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 41 |
Species,"/{taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname}",
|
|
| 33 |
ScientificNameAuthor,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author" |
|
| 34 |
Class,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Class]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 35 |
Family,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 36 |
Genus,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 37 |
Kingdom,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Kingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 38 |
Order,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Order]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 39 |
Phylum,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subkingdom]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 40 |
Subspecies,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/*_id/plantconcept/*_id/*/plantname", |
|
| 41 |
Species,"/{taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname}",
|
|
| 42 | 42 |
UniqueNYInternalRecordNumber,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode,*_id/locationevent/authoreventcode/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/authorlocationcode/_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/SALVIAS-VegBIEN.organisms.csv | ||
|---|---|---|
| 29 | 29 |
habit,"/taxondetermination[role_id/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/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/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/role/rolecode=collector]:[determinationtype=Author,currentdetermination=true]/notes", |
| 32 |
specific_authority,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss.
|
|
| 33 |
family,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 34 |
genus,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 35 |
specific_epithet,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",
|
|
| 36 |
infra_rank_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept:[*_id/reference]/_name/first}",
|
|
| 37 |
infra_ep_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept:[*_id/reference]/_name/last",
|
|
| 38 |
orig_family,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname",Brad: OMIT
|
|
| 39 |
orig_species,"/{taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept:[*_id/reference]/*_id/*/plantname}",Brad: OMIT
|
|
| 32 |
specific_authority,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Authority]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: Incorrect. This is the author of the scientificName. The should be a place for this in the taxonomic name elements of VegB and VegX. Let's discuss. |
|
| 33 |
family,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 34 |
genus,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Genus]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 35 |
specific_epithet,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/*_id/*/plantname", |
|
| 36 |
infra_rank_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]/{*_id/*/plantname/_name/first,*_id/plantconcept/_name/first}",
|
|
| 37 |
infra_ep_1,"/taxondetermination[role_id/role/rolecode=computer,*_id/plantconcept/plantstatus/plantlevel=Subspecies]:[determinationtype=""Computer (automated)"",currentdetermination=true]/*_id/plantconcept/_name/last", |
|
| 38 |
orig_family,"/taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Family]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname",Brad: OMIT |
|
| 39 |
orig_species,"/{taxondetermination[role_id/role/rolecode=collector]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname/_alt/2,taxondetermination[role_id/role/rolecode=identifier,*_id/plantconcept/plantstatus/plantlevel=Species]:[determinationtype=Author,originaldetermination=true,currentdetermination=true]/*_id/plantconcept/*_id/*/plantname}",Brad: OMIT
|
|
| 40 | 40 |
OBSERVATION_ID,":[aggregateoccurrence/count/_alt/2=1]/{aggregateoccurrence/individualplant/authorplantcode,specimen:[*_id/reference]/sourceaccessioncode,*_id/locationevent/authoreventcode/_alt/2,*_id/locationevent/*_id/location:[confidentialitystatus=0]/authorlocationcode/_alt/3}","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later."
|
Also available in: Unified diff
VegX-VegBIEN mappings: Took advantage of plantconcept.reference_id becoming optional