Revision 5138
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/ARIZ/Specimen/test.xml.ref | ||
|---|---|---|
| 116 | 116 |
</party_id> |
| 117 | 117 |
<taxonpath_id> |
| 118 | 118 |
<taxonpath> |
| 119 |
<class>$Class</class> |
|
| 120 |
<family>$Family</family> |
|
| 121 |
<genus>$Genus</genus> |
|
| 122 |
<identifyingtaxonomicname> |
|
| 123 |
<_alt> |
|
| 124 |
<1>$ScientificNameAuthor</1> |
|
| 125 |
<2> |
|
| 119 |
<canon_taxonpath_id> |
|
| 120 |
<taxonpath> |
|
| 121 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 122 |
<identifyingtaxonomicname> |
|
| 126 | 123 |
<_alt> |
| 127 |
<1>$ScientificName</1> |
|
| 124 |
<1>$ScientificNameAuthor</1>
|
|
| 128 | 125 |
<2> |
| 129 |
<_join_words> |
|
| 130 |
<1>$Family</1> |
|
| 131 |
<2>$Genus</2> |
|
| 132 |
<3>$Species</3> |
|
| 133 |
<4>$Subspecies</4> |
|
| 134 |
</_join_words> |
|
| 126 |
<_alt> |
|
| 127 |
<1>$ScientificName</1> |
|
| 128 |
<2> |
|
| 129 |
<_join_words> |
|
| 130 |
<1>$Family</1> |
|
| 131 |
<2>$Genus</2> |
|
| 132 |
<3>$Species</3> |
|
| 133 |
<4>$Subspecies</4> |
|
| 134 |
</_join_words> |
|
| 135 |
</2> |
|
| 136 |
</_alt> |
|
| 135 | 137 |
</2> |
| 136 | 138 |
</_alt> |
| 137 |
</2> |
|
| 138 |
</_alt> |
|
| 139 |
</identifyingtaxonomicname> |
|
| 139 |
</identifyingtaxonomicname> |
|
| 140 |
</taxonpath> |
|
| 141 |
</canon_taxonpath_id> |
|
| 142 |
<class>$Class</class> |
|
| 143 |
<family>$Family</family> |
|
| 144 |
<genus>$Genus</genus> |
|
| 140 | 145 |
<kingdom>$Kingdom</kingdom> |
| 141 | 146 |
<order>$Order</order> |
| 142 | 147 |
<phylum>$Phylum</phylum> |
| ... | ... | |
| 198 | 203 |
</path> |
| 199 | 204 |
</_simplifyPath> |
| 200 | 205 |
</VegBIEN> |
| 201 |
Inserted 27 new rows into database |
|
| 206 |
Inserted 30 new rows into database |
|
| inputs/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
Full Taxon Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_if[@name=""if is taxonpath only""]/else/_first/3", |
| 15 | 15 |
Cultivated?,/location/locationevent/taxonoccurrence/iscultivated/_alt/1, |
| 16 | 16 |
Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 17 |
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
|
|
| 17 |
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
|
| 18 | 18 |
Full Taxon Name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname, |
| 19 | 19 |
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 20 | 20 |
Country,/location/locationplace/*_id/placepath/country, |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 272 | 272 |
</party_id> |
| 273 | 273 |
<taxonpath_id> |
| 274 | 274 |
<taxonpath> |
| 275 |
<canon_taxonpath_id> |
|
| 276 |
<taxonpath> |
|
| 277 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 278 |
<identifyingtaxonomicname> |
|
| 279 |
<_join_words> |
|
| 280 |
<1> |
|
| 281 |
<_alt> |
|
| 282 |
<1> |
|
| 283 |
<_alt> |
|
| 284 |
<0>$conceptual_darwin_2003_1_0_ScientificName</0> |
|
| 285 |
<1>$dwc_dwcore_ScientificName</1> |
|
| 286 |
<2>$dwc_terms_scientificName</2> |
|
| 287 |
</_alt> |
|
| 288 |
</1> |
|
| 289 |
<2> |
|
| 290 |
<_join_words> |
|
| 291 |
<1> |
|
| 292 |
<_alt> |
|
| 293 |
<0>$conceptual_darwin_2003_1_0_Family</0> |
|
| 294 |
<1>$dwc_dwcore_Family</1> |
|
| 295 |
<2>$dwc_terms_family</2> |
|
| 296 |
</_alt> |
|
| 297 |
</1> |
|
| 298 |
<2> |
|
| 299 |
<_alt> |
|
| 300 |
<0>$conceptual_darwin_2003_1_0_Genus</0> |
|
| 301 |
<1>$dwc_dwcore_Genus</1> |
|
| 302 |
<2>$dwc_terms_genus</2> |
|
| 303 |
</_alt> |
|
| 304 |
</2> |
|
| 305 |
<3> |
|
| 306 |
<_alt> |
|
| 307 |
<0>$conceptual_darwin_2003_1_0_Species</0> |
|
| 308 |
<1>$dwc_dwcore_SpecificEpithet</1> |
|
| 309 |
<2>$dwc_terms_specificEpithet</2> |
|
| 310 |
</_alt> |
|
| 311 |
</3> |
|
| 312 |
<4>$conceptual_darwin_2003_1_0_Subspecies</4> |
|
| 313 |
<5> |
|
| 314 |
<_alt> |
|
| 315 |
<0>$dwc_dwcore_InfraspecificEpithet</0> |
|
| 316 |
<1>$dwc_terms_infraspecificEpithet</1> |
|
| 317 |
</_alt> |
|
| 318 |
</5> |
|
| 319 |
</_join_words> |
|
| 320 |
</2> |
|
| 321 |
</_alt> |
|
| 322 |
</1> |
|
| 323 |
<2> |
|
| 324 |
<_alt> |
|
| 325 |
<1>$dwc_terms_scientificNameAuthorship</1> |
|
| 326 |
<2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2> |
|
| 327 |
<3>$dwc_dwcore_AuthorYearOfScientificName</3> |
|
| 328 |
</_alt> |
|
| 329 |
</2> |
|
| 330 |
</_join_words> |
|
| 331 |
</identifyingtaxonomicname> |
|
| 332 |
</taxonpath> |
|
| 333 |
</canon_taxonpath_id> |
|
| 275 | 334 |
<author> |
| 276 | 335 |
<_alt> |
| 277 | 336 |
<1>$dwc_terms_scientificNameAuthorship</1> |
| ... | ... | |
| 300 | 359 |
<2>$dwc_terms_genus</2> |
| 301 | 360 |
</_alt> |
| 302 | 361 |
</genus> |
| 303 |
<identifyingtaxonomicname> |
|
| 304 |
<_join_words> |
|
| 305 |
<1> |
|
| 306 |
<_alt> |
|
| 307 |
<1> |
|
| 308 |
<_alt> |
|
| 309 |
<0>$conceptual_darwin_2003_1_0_ScientificName</0> |
|
| 310 |
<1>$dwc_dwcore_ScientificName</1> |
|
| 311 |
<2>$dwc_terms_scientificName</2> |
|
| 312 |
</_alt> |
|
| 313 |
</1> |
|
| 314 |
<2> |
|
| 315 |
<_join_words> |
|
| 316 |
<1> |
|
| 317 |
<_alt> |
|
| 318 |
<0>$conceptual_darwin_2003_1_0_Family</0> |
|
| 319 |
<1>$dwc_dwcore_Family</1> |
|
| 320 |
<2>$dwc_terms_family</2> |
|
| 321 |
</_alt> |
|
| 322 |
</1> |
|
| 323 |
<2> |
|
| 324 |
<_alt> |
|
| 325 |
<0>$conceptual_darwin_2003_1_0_Genus</0> |
|
| 326 |
<1>$dwc_dwcore_Genus</1> |
|
| 327 |
<2>$dwc_terms_genus</2> |
|
| 328 |
</_alt> |
|
| 329 |
</2> |
|
| 330 |
<3> |
|
| 331 |
<_alt> |
|
| 332 |
<0>$conceptual_darwin_2003_1_0_Species</0> |
|
| 333 |
<1>$dwc_dwcore_SpecificEpithet</1> |
|
| 334 |
<2>$dwc_terms_specificEpithet</2> |
|
| 335 |
</_alt> |
|
| 336 |
</3> |
|
| 337 |
<4>$conceptual_darwin_2003_1_0_Subspecies</4> |
|
| 338 |
<5> |
|
| 339 |
<_alt> |
|
| 340 |
<0>$dwc_dwcore_InfraspecificEpithet</0> |
|
| 341 |
<1>$dwc_terms_infraspecificEpithet</1> |
|
| 342 |
</_alt> |
|
| 343 |
</5> |
|
| 344 |
</_join_words> |
|
| 345 |
</2> |
|
| 346 |
</_alt> |
|
| 347 |
</1> |
|
| 348 |
<2> |
|
| 349 |
<_alt> |
|
| 350 |
<1>$dwc_terms_scientificNameAuthorship</1> |
|
| 351 |
<2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2> |
|
| 352 |
<3>$dwc_dwcore_AuthorYearOfScientificName</3> |
|
| 353 |
</_alt> |
|
| 354 |
</2> |
|
| 355 |
</_join_words> |
|
| 356 |
</identifyingtaxonomicname> |
|
| 357 | 362 |
<kingdom> |
| 358 | 363 |
<_alt> |
| 359 | 364 |
<0>$conceptual_darwin_2003_1_0_Kingdom</0> |
| ... | ... | |
| 506 | 511 |
</path> |
| 507 | 512 |
</_simplifyPath> |
| 508 | 513 |
</VegBIEN> |
| 509 |
Inserted 29 new rows into database |
|
| 514 |
Inserted 32 new rows into database |
|
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value", |
| 12 | 12 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 13 | 13 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 14 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 15 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 14 | 16 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 15 | 17 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 16 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 17 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 18 | 18 |
locality,/location/locationnarrative/_merge/1, |
| 19 | 19 |
continent,/location/locationplace/*_id/placepath/continent, |
| 20 | 20 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
| inputs/MT/Specimen/test.xml.ref | ||
|---|---|---|
| 42 | 42 |
<taxondetermination> |
| 43 | 43 |
<taxonpath_id> |
| 44 | 44 |
<taxonpath> |
| 45 |
<canon_taxonpath_id> |
|
| 46 |
<taxonpath> |
|
| 47 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 48 |
<identifyingtaxonomicname> |
|
| 49 |
<_join_words> |
|
| 50 |
<1>$family</1> |
|
| 51 |
<2>$genus</2> |
|
| 52 |
</_join_words> |
|
| 53 |
</identifyingtaxonomicname> |
|
| 54 |
</taxonpath> |
|
| 55 |
</canon_taxonpath_id> |
|
| 45 | 56 |
<family>$family</family> |
| 46 | 57 |
<genus>$genus</genus> |
| 47 |
<identifyingtaxonomicname> |
|
| 48 |
<_join_words> |
|
| 49 |
<1>$family</1> |
|
| 50 |
<2>$genus</2> |
|
| 51 |
</_join_words> |
|
| 52 |
</identifyingtaxonomicname> |
|
| 53 | 58 |
</taxonpath> |
| 54 | 59 |
</taxonpath_id> |
| 55 | 60 |
</taxondetermination> |
| ... | ... | |
| 61 | 66 |
</path> |
| 62 | 67 |
</_simplifyPath> |
| 63 | 68 |
</VegBIEN> |
| 64 |
Inserted 20 new rows into database |
|
| 69 |
Inserted 22 new rows into database |
|
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 24 | 24 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 25 | 25 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 26 |
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
|
| 27 |
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 28 |
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 29 |
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 30 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
|
| 31 |
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
|
| 26 | 32 |
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author, |
| 27 | 33 |
darwin:Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class, |
| 28 | 34 |
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 29 | 35 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 30 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 31 |
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 32 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 33 |
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 34 |
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4, |
|
| 35 |
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2, |
|
| 36 | 36 |
darwin:Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom, |
| 37 | 37 |
darwin:Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order, |
| 38 | 38 |
darwin:Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum, |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists", |
| 21 | 21 |
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then", |
| 22 | 22 |
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 23 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 25 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 23 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 24 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 25 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 26 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 27 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 28 | 28 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 29 | 29 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 30 | 30 |
Comments,,** No join mapping for *Comments ** |
| inputs/TEAM/VL/test.xml.ref | ||
|---|---|---|
| 44 | 44 |
<taxondetermination> |
| 45 | 45 |
<taxonpath_id> |
| 46 | 46 |
<taxonpath> |
| 47 |
<canon_taxonpath_id> |
|
| 48 |
<taxonpath> |
|
| 49 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 50 |
<identifyingtaxonomicname> |
|
| 51 |
<_join_words> |
|
| 52 |
<1>$Family</1> |
|
| 53 |
<2>$Genus</2> |
|
| 54 |
<3>$Species</3> |
|
| 55 |
</_join_words> |
|
| 56 |
</identifyingtaxonomicname> |
|
| 57 |
</taxonpath> |
|
| 58 |
</canon_taxonpath_id> |
|
| 47 | 59 |
<family>$Family</family> |
| 48 | 60 |
<genus>$Genus</genus> |
| 49 |
<identifyingtaxonomicname> |
|
| 50 |
<_join_words> |
|
| 51 |
<1>$Family</1> |
|
| 52 |
<2>$Genus</2> |
|
| 53 |
<3>$Species</3> |
|
| 54 |
</_join_words> |
|
| 55 |
</identifyingtaxonomicname> |
|
| 56 | 61 |
<species>$Species</species> |
| 57 | 62 |
</taxonpath> |
| 58 | 63 |
</taxonpath_id> |
| ... | ... | |
| 64 | 69 |
</path> |
| 65 | 70 |
</_simplifyPath> |
| 66 | 71 |
</VegBIEN> |
| 67 |
Inserted 23 new rows into database |
|
| 72 |
Inserted 26 new rows into database |
|
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists", |
| 21 | 21 |
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then", |
| 22 | 22 |
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 23 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 25 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 23 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 24 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 25 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 26 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 27 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 28 | 28 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 29 | 29 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 30 | 30 |
Comments,,** No join mapping for *Comments ** |
| inputs/TEAM/VT/test.xml.ref | ||
|---|---|---|
| 44 | 44 |
<taxondetermination> |
| 45 | 45 |
<taxonpath_id> |
| 46 | 46 |
<taxonpath> |
| 47 |
<canon_taxonpath_id> |
|
| 48 |
<taxonpath> |
|
| 49 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 50 |
<identifyingtaxonomicname> |
|
| 51 |
<_join_words> |
|
| 52 |
<1>$Family</1> |
|
| 53 |
<2>$Genus</2> |
|
| 54 |
<3>$Species</3> |
|
| 55 |
</_join_words> |
|
| 56 |
</identifyingtaxonomicname> |
|
| 57 |
</taxonpath> |
|
| 58 |
</canon_taxonpath_id> |
|
| 47 | 59 |
<family>$Family</family> |
| 48 | 60 |
<genus>$Genus</genus> |
| 49 |
<identifyingtaxonomicname> |
|
| 50 |
<_join_words> |
|
| 51 |
<1>$Family</1> |
|
| 52 |
<2>$Genus</2> |
|
| 53 |
<3>$Species</3> |
|
| 54 |
</_join_words> |
|
| 55 |
</identifyingtaxonomicname> |
|
| 56 | 61 |
<species>$Species</species> |
| 57 | 62 |
</taxonpath> |
| 58 | 63 |
</taxonpath_id> |
| ... | ... | |
| 64 | 69 |
</path> |
| 65 | 70 |
</_simplifyPath> |
| 66 | 71 |
</VegBIEN> |
| 67 |
Inserted 20 new rows into database |
|
| 72 |
Inserted 23 new rows into database |
|
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 29 | 29 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 30 | 30 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 31 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
|
| 32 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 33 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 34 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 35 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
|
| 36 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
|
| 31 | 37 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author, |
| 32 | 38 |
Class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class, |
| 33 | 39 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 34 | 40 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 35 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 36 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 37 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 38 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 39 |
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4, |
|
| 40 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2, |
|
| 41 | 41 |
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom, |
| 42 | 42 |
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order, |
| 43 | 43 |
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum, |
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 116 | 116 |
</party_id> |
| 117 | 117 |
<taxonpath_id> |
| 118 | 118 |
<taxonpath> |
| 119 |
<canon_taxonpath_id> |
|
| 120 |
<taxonpath> |
|
| 121 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 122 |
<identifyingtaxonomicname> |
|
| 123 |
<_join_words> |
|
| 124 |
<1> |
|
| 125 |
<_alt> |
|
| 126 |
<1>$ScientificName</1> |
|
| 127 |
<2> |
|
| 128 |
<_join_words> |
|
| 129 |
<1>$Family</1> |
|
| 130 |
<2>$Genus</2> |
|
| 131 |
<3>$Species</3> |
|
| 132 |
<4>$Subspecies</4> |
|
| 133 |
</_join_words> |
|
| 134 |
</2> |
|
| 135 |
</_alt> |
|
| 136 |
</1> |
|
| 137 |
<2>$ScientificNameAuthor</2> |
|
| 138 |
</_join_words> |
|
| 139 |
</identifyingtaxonomicname> |
|
| 140 |
</taxonpath> |
|
| 141 |
</canon_taxonpath_id> |
|
| 119 | 142 |
<author>$ScientificNameAuthor</author> |
| 120 | 143 |
<class>$Class</class> |
| 121 | 144 |
<family>$Family</family> |
| 122 | 145 |
<genus>$Genus</genus> |
| 123 |
<identifyingtaxonomicname> |
|
| 124 |
<_join_words> |
|
| 125 |
<1> |
|
| 126 |
<_alt> |
|
| 127 |
<1>$ScientificName</1> |
|
| 128 |
<2> |
|
| 129 |
<_join_words> |
|
| 130 |
<1>$Family</1> |
|
| 131 |
<2>$Genus</2> |
|
| 132 |
<3>$Species</3> |
|
| 133 |
<4>$Subspecies</4> |
|
| 134 |
</_join_words> |
|
| 135 |
</2> |
|
| 136 |
</_alt> |
|
| 137 |
</1> |
|
| 138 |
<2>$ScientificNameAuthor</2> |
|
| 139 |
</_join_words> |
|
| 140 |
</identifyingtaxonomicname> |
|
| 141 | 146 |
<kingdom>$Kingdom</kingdom> |
| 142 | 147 |
<order>$Order</order> |
| 143 | 148 |
<phylum>$Phylum</phylum> |
| ... | ... | |
| 222 | 227 |
</path> |
| 223 | 228 |
</_simplifyPath> |
| 224 | 229 |
</VegBIEN> |
| 225 |
Inserted 26 new rows into database |
|
| 230 |
Inserted 29 new rows into database |
|
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 33 | 33 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 34 | 34 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 35 | 35 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 36 |
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
|
|
| 37 |
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
|
|
| 38 |
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 39 |
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 40 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 41 |
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
|
| 36 | 42 |
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author, |
| 37 | 43 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 38 | 44 |
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 39 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/1, |
|
| 40 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,"Contains less than ""Specie+autor""" |
|
| 41 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 42 |
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 43 |
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 44 |
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2, |
|
| 45 | 45 |
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 46 | 46 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,"Contains less than ""Specie+autor""" |
| 47 | 47 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicnamewithauthor, |
| 48 | 48 |
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 49 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 50 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera |
|
| 49 | 51 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family, |
| 50 | 52 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,Often = Genera |
| 51 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 52 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera |
|
| 53 | 53 |
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 54 | 54 |
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 55 | 55 |
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate" |
| inputs/Madidi/Organism/test.xml.ref | ||
|---|---|---|
| 70 | 70 |
</party_id> |
| 71 | 71 |
<taxonpath_id> |
| 72 | 72 |
<taxonpath> |
| 73 |
<canon_taxonpath_id> |
|
| 74 |
<taxonpath> |
|
| 75 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 76 |
<identifyingtaxonomicname> |
|
| 77 |
<_alt> |
|
| 78 |
<1>$Specie+autor</1> |
|
| 79 |
<2> |
|
| 80 |
<_join_words> |
|
| 81 |
<1> |
|
| 82 |
<_alt> |
|
| 83 |
<1>$Species and morphotypes</1> |
|
| 84 |
<2> |
|
| 85 |
<_join_words> |
|
| 86 |
<1>$Family (revised)</1> |
|
| 87 |
<2>$Genera</2> |
|
| 88 |
<3>$Specific epithet</3> |
|
| 89 |
</_join_words> |
|
| 90 |
</2> |
|
| 91 |
</_alt> |
|
| 92 |
</1> |
|
| 93 |
<2>$Autor (revised)</2> |
|
| 94 |
</_join_words> |
|
| 95 |
</2> |
|
| 96 |
</_alt> |
|
| 97 |
</identifyingtaxonomicname> |
|
| 98 |
</taxonpath> |
|
| 99 |
</canon_taxonpath_id> |
|
| 73 | 100 |
<author>$Autor (revised)</author> |
| 74 | 101 |
<family>$Family (revised)</family> |
| 75 | 102 |
<genus>$Genera</genus> |
| 76 |
<identifyingtaxonomicname> |
|
| 77 |
<_alt> |
|
| 78 |
<1>$Specie+autor</1> |
|
| 79 |
<2> |
|
| 80 |
<_join_words> |
|
| 81 |
<1> |
|
| 82 |
<_alt> |
|
| 83 |
<1>$Species and morphotypes</1> |
|
| 84 |
<2> |
|
| 85 |
<_join_words> |
|
| 86 |
<1>$Family (revised)</1> |
|
| 87 |
<2>$Genera</2> |
|
| 88 |
<3>$Specific epithet</3> |
|
| 89 |
</_join_words> |
|
| 90 |
</2> |
|
| 91 |
</_alt> |
|
| 92 |
</1> |
|
| 93 |
<2>$Autor (revised)</2> |
|
| 94 |
</_join_words> |
|
| 95 |
</2> |
|
| 96 |
</_alt> |
|
| 97 |
</identifyingtaxonomicname> |
|
| 98 | 103 |
<species>$Specific epithet</species> |
| 99 | 104 |
<taxonomicname>$Species and morphotypes</taxonomicname> |
| 100 | 105 |
<taxonomicnamewithauthor>$Specie+autor</taxonomicnamewithauthor> |
| ... | ... | |
| 106 | 111 |
<isoriginal>true</isoriginal> |
| 107 | 112 |
<taxonpath_id> |
| 108 | 113 |
<taxonpath> |
| 114 |
<canon_taxonpath_id> |
|
| 115 |
<taxonpath> |
|
| 116 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 117 |
<identifyingtaxonomicname> |
|
| 118 |
<_join_words> |
|
| 119 |
<1>$Field family</1> |
|
| 120 |
<2>$Field name</2> |
|
| 121 |
</_join_words> |
|
| 122 |
</identifyingtaxonomicname> |
|
| 123 |
</taxonpath> |
|
| 124 |
</canon_taxonpath_id> |
|
| 109 | 125 |
<family>$Field family</family> |
| 110 | 126 |
<genus>$Field name</genus> |
| 111 |
<identifyingtaxonomicname> |
|
| 112 |
<_join_words> |
|
| 113 |
<1>$Field family</1> |
|
| 114 |
<2>$Field name</2> |
|
| 115 |
</_join_words> |
|
| 116 |
</identifyingtaxonomicname> |
|
| 117 | 127 |
</taxonpath> |
| 118 | 128 |
</taxonpath_id> |
| 119 | 129 |
</taxondetermination> |
| ... | ... | |
| 124 | 134 |
</path> |
| 125 | 135 |
</_simplifyPath> |
| 126 | 136 |
</VegBIEN> |
| 127 |
Inserted 27 new rows into database |
|
| 137 |
Inserted 32 new rows into database |
|
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 42 | 42 |
GROUP BY herbarium, accession |
| 43 | 43 |
HAVING count(*) > 1 |
| 44 | 44 |
-----" |
| 45 |
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
|
| 46 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 47 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 48 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 49 |
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
|
|
| 50 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1",
|
|
| 51 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2",
|
|
| 52 |
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
|
|
| 53 |
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
|
| 45 | 54 |
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author, |
| 46 | 55 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 47 | 56 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 48 |
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 49 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 50 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 51 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 52 |
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
|
| 53 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1", |
|
| 54 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2", |
|
| 55 |
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
|
| 56 |
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2, |
|
| 57 | 57 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 58 | 58 |
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
| 59 | 59 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/1", |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 73 | 73 |
<taxondetermination> |
| 74 | 74 |
<taxonpath_id> |
| 75 | 75 |
<taxonpath> |
| 76 |
<canon_taxonpath_id> |
|
| 77 |
<taxonpath> |
|
| 78 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 79 |
<identifyingtaxonomicname> |
|
| 80 |
<_join_words> |
|
| 81 |
<1> |
|
| 82 |
<_alt> |
|
| 83 |
<1>$SciName</1> |
|
| 84 |
<2> |
|
| 85 |
<_join_words> |
|
| 86 |
<1>$family</1> |
|
| 87 |
<2>$genus</2> |
|
| 88 |
<3>$species</3> |
|
| 89 |
<5> |
|
| 90 |
<_join_words> |
|
| 91 |
<1> |
|
| 92 |
<_if name="if has infraspecificEpithet"> |
|
| 93 |
<cond>$infraname</cond> |
|
| 94 |
<then> |
|
| 95 |
<_alt> |
|
| 96 |
<1>$usdaRank</1> |
|
| 97 |
<2>$infrarank</2> |
|
| 98 |
</_alt> |
|
| 99 |
</then> |
|
| 100 |
</_if> |
|
| 101 |
</1> |
|
| 102 |
<2>$infraname</2> |
|
| 103 |
</_join_words> |
|
| 104 |
</5> |
|
| 105 |
</_join_words> |
|
| 106 |
</2> |
|
| 107 |
</_alt> |
|
| 108 |
</1> |
|
| 109 |
<2>$authors</2> |
|
| 110 |
</_join_words> |
|
| 111 |
</identifyingtaxonomicname> |
|
| 112 |
</taxonpath> |
|
| 113 |
</canon_taxonpath_id> |
|
| 76 | 114 |
<author>$authors</author> |
| 77 | 115 |
<family>$family</family> |
| 78 | 116 |
<genus>$genus</genus> |
| 79 |
<identifyingtaxonomicname> |
|
| 80 |
<_join_words> |
|
| 81 |
<1> |
|
| 82 |
<_alt> |
|
| 83 |
<1>$SciName</1> |
|
| 84 |
<2> |
|
| 85 |
<_join_words> |
|
| 86 |
<1>$family</1> |
|
| 87 |
<2>$genus</2> |
|
| 88 |
<3>$species</3> |
|
| 89 |
<5> |
|
| 90 |
<_join_words> |
|
| 91 |
<1> |
|
| 92 |
<_if name="if has infraspecificEpithet"> |
|
| 93 |
<cond>$infraname</cond> |
|
| 94 |
<then> |
|
| 95 |
<_alt> |
|
| 96 |
<1>$usdaRank</1> |
|
| 97 |
<2>$infrarank</2> |
|
| 98 |
</_alt> |
|
| 99 |
</then> |
|
| 100 |
</_if> |
|
| 101 |
</1> |
|
| 102 |
<2>$infraname</2> |
|
| 103 |
</_join_words> |
|
| 104 |
</5> |
|
| 105 |
</_join_words> |
|
| 106 |
</2> |
|
| 107 |
</_alt> |
|
| 108 |
</1> |
|
| 109 |
<2>$authors</2> |
|
| 110 |
</_join_words> |
|
| 111 |
</identifyingtaxonomicname> |
|
| 112 | 117 |
<species>$species</species> |
| 113 | 118 |
<subspecies> |
| 114 | 119 |
<_join_words> |
| ... | ... | |
| 164 | 169 |
</path> |
| 165 | 170 |
</_simplifyPath> |
| 166 | 171 |
</VegBIEN> |
| 167 |
Inserted 20 new rows into database |
|
| 172 |
Inserted 22 new rows into database |
|
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 24 | 24 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 25 | 25 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 26 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
|
|
| 27 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 28 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 29 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 30 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
|
|
| 31 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
|
|
| 32 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
|
|
| 33 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
|
| 26 | 34 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author, |
| 27 | 35 |
class,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/class, |
| 28 | 36 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 29 | 37 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 30 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/1, |
|
| 31 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 32 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 33 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 34 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
|
| 35 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
|
| 36 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
|
| 37 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2, |
|
| 38 | 38 |
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/kingdom, |
| 39 | 39 |
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/order, |
| 40 | 40 |
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/phylum, |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 76 | 76 |
</party_id> |
| 77 | 77 |
<taxonpath_id> |
| 78 | 78 |
<taxonpath> |
| 79 |
<canon_taxonpath_id> |
|
| 80 |
<taxonpath> |
|
| 81 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 82 |
<identifyingtaxonomicname> |
|
| 83 |
<_alt> |
|
| 84 |
<1>$scientificName</1> |
|
| 85 |
<2> |
|
| 86 |
<_join_words> |
|
| 87 |
<1> |
|
| 88 |
<_join_words> |
|
| 89 |
<1>$family</1> |
|
| 90 |
<2>$genus</2> |
|
| 91 |
<3>$specificEpithet</3> |
|
| 92 |
<5> |
|
| 93 |
<_join_words> |
|
| 94 |
<1> |
|
| 95 |
<_if name="if has infraspecificEpithet"> |
|
| 96 |
<cond>$infraspecificEpithet</cond> |
|
| 97 |
<then>$taxonRank</then> |
|
| 98 |
</_if> |
|
| 99 |
</1> |
|
| 100 |
<2>$infraspecificEpithet</2> |
|
| 101 |
</_join_words> |
|
| 102 |
</5> |
|
| 103 |
</_join_words> |
|
| 104 |
</1> |
|
| 105 |
<2>$scientificNameAuthorship</2> |
|
| 106 |
</_join_words> |
|
| 107 |
</2> |
|
| 108 |
</_alt> |
|
| 109 |
</identifyingtaxonomicname> |
|
| 110 |
</taxonpath> |
|
| 111 |
</canon_taxonpath_id> |
|
| 79 | 112 |
<author>$scientificNameAuthorship</author> |
| 80 | 113 |
<class>$class</class> |
| 81 | 114 |
<family>$family</family> |
| 82 | 115 |
<genus>$genus</genus> |
| 83 |
<identifyingtaxonomicname> |
|
| 84 |
<_alt> |
|
| 85 |
<1>$scientificName</1> |
|
| 86 |
<2> |
|
| 87 |
<_join_words> |
|
| 88 |
<1> |
|
| 89 |
<_join_words> |
|
| 90 |
<1>$family</1> |
|
| 91 |
<2>$genus</2> |
|
| 92 |
<3>$specificEpithet</3> |
|
| 93 |
<5> |
|
| 94 |
<_join_words> |
|
| 95 |
<1> |
|
| 96 |
<_if name="if has infraspecificEpithet"> |
|
| 97 |
<cond>$infraspecificEpithet</cond> |
|
| 98 |
<then>$taxonRank</then> |
|
| 99 |
</_if> |
|
| 100 |
</1> |
|
| 101 |
<2>$infraspecificEpithet</2> |
|
| 102 |
</_join_words> |
|
| 103 |
</5> |
|
| 104 |
</_join_words> |
|
| 105 |
</1> |
|
| 106 |
<2>$scientificNameAuthorship</2> |
|
| 107 |
</_join_words> |
|
| 108 |
</2> |
|
| 109 |
</_alt> |
|
| 110 |
</identifyingtaxonomicname> |
|
| 111 | 116 |
<kingdom>$kingdom</kingdom> |
| 112 | 117 |
<order>$order</order> |
| 113 | 118 |
<phylum>$phylum</phylum> |
| ... | ... | |
| 157 | 162 |
</path> |
| 158 | 163 |
</_simplifyPath> |
| 159 | 164 |
</VegBIEN> |
| 160 |
Inserted 24 new rows into database |
|
| 165 |
Inserted 27 new rows into database |
|
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 64 | 64 |
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then/_alt/2/_alt/2","The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
| 65 | 65 |
habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""HemiepÃfito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
|
| 66 | 66 |
OBSERVATION_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","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." |
| 67 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 68 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 69 |
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 70 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
|
|
| 71 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then",
|
|
| 72 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
|
|
| 73 |
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName.
|
|
| 67 | 74 |
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author,Brad: This is the author of the scientificName. |
| 68 | 75 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 69 | 76 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 70 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 71 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 72 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 73 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
|
| 74 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
|
| 75 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
|
| 76 |
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2,Brad: This is the author of the scientificName. |
|
| 77 | 77 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 78 | 78 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
| 79 | 79 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 80 | 80 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2, |
| 81 | 81 |
cf_aff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank." |
| 82 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
|
| 83 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
|
| 82 | 84 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family,Brad: OMIT |
| 83 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
|
| 84 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
|
| 85 | 85 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/species,Brad: OMIT |
| 86 | 86 |
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above |
| 87 | 87 |
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 147 | 147 |
<taxondetermination> |
| 148 | 148 |
<taxonpath_id> |
| 149 | 149 |
<taxonpath> |
| 150 |
<author>$specific_authority</author> |
|
| 151 |
<family>$family</family> |
|
| 152 |
<genus>$genus</genus> |
|
| 153 |
<identifyingtaxonomicname> |
|
| 154 |
<_join_words> |
|
| 155 |
<1> |
|
| 150 |
<canon_taxonpath_id> |
|
| 151 |
<taxonpath> |
|
| 152 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 153 |
<identifyingtaxonomicname> |
|
| 156 | 154 |
<_join_words> |
| 157 |
<1>$family</1> |
|
| 158 |
<2>$genus</2> |
|
| 159 |
<3>$specific_epithet</3> |
|
| 160 |
<5> |
|
| 155 |
<1> |
|
| 161 | 156 |
<_join_words> |
| 162 |
<1> |
|
| 163 |
<_if name="if has infraspecificEpithet"> |
|
| 164 |
<cond>$infra_ep_1</cond> |
|
| 165 |
<then>$infra_rank_1</then> |
|
| 166 |
</_if> |
|
| 167 |
</1> |
|
| 168 |
<2>$infra_ep_1</2> |
|
| 157 |
<1>$family</1> |
|
| 158 |
<2>$genus</2> |
|
| 159 |
<3>$specific_epithet</3> |
|
| 160 |
<5> |
|
| 161 |
<_join_words> |
|
| 162 |
<1> |
|
| 163 |
<_if name="if has infraspecificEpithet"> |
|
| 164 |
<cond>$infra_ep_1</cond> |
|
| 165 |
<then>$infra_rank_1</then> |
|
| 166 |
</_if> |
|
| 167 |
</1> |
|
| 168 |
<2>$infra_ep_1</2> |
|
| 169 |
</_join_words> |
|
| 170 |
</5> |
|
| 169 | 171 |
</_join_words> |
| 170 |
</5> |
|
| 172 |
</1> |
|
| 173 |
<2>$specific_authority</2> |
|
| 171 | 174 |
</_join_words> |
| 172 |
</1> |
|
| 173 |
<2>$specific_authority</2> |
|
| 174 |
</_join_words> |
|
| 175 |
</identifyingtaxonomicname> |
|
| 175 |
</identifyingtaxonomicname> |
|
| 176 |
</taxonpath> |
|
| 177 |
</canon_taxonpath_id> |
|
| 178 |
<author>$specific_authority</author> |
|
| 179 |
<family>$family</family> |
|
| 180 |
<genus>$genus</genus> |
|
| 176 | 181 |
<species>$specific_epithet</species> |
| 177 | 182 |
<subspecies> |
| 178 | 183 |
<_join_words> |
| ... | ... | |
| 193 | 198 |
<isoriginal>true</isoriginal> |
| 194 | 199 |
<taxonpath_id> |
| 195 | 200 |
<taxonpath> |
| 201 |
<canon_taxonpath_id> |
|
| 202 |
<taxonpath> |
|
| 203 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 204 |
<identifyingtaxonomicname> |
|
| 205 |
<_join_words> |
|
| 206 |
<1>$orig_family</1> |
|
| 207 |
<3>$orig_species</3> |
|
| 208 |
</_join_words> |
|
| 209 |
</identifyingtaxonomicname> |
|
| 210 |
</taxonpath> |
|
| 211 |
</canon_taxonpath_id> |
|
| 196 | 212 |
<family>$orig_family</family> |
| 197 |
<identifyingtaxonomicname> |
|
| 198 |
<_join_words> |
|
| 199 |
<1>$orig_family</1> |
|
| 200 |
<3>$orig_species</3> |
|
| 201 |
</_join_words> |
|
| 202 |
</identifyingtaxonomicname> |
|
| 203 | 213 |
<species>$orig_species</species> |
| 204 | 214 |
</taxonpath> |
| 205 | 215 |
</taxonpath_id> |
| ... | ... | |
| 238 | 248 |
</path> |
| 239 | 249 |
</_simplifyPath> |
| 240 | 250 |
</VegBIEN> |
| 241 |
Inserted 37 new rows into database |
|
| 251 |
Inserted 42 new rows into database |
|
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
obsStartDate,/location/locationevent/obsstartdate/_*/date/_alt/1, |
| 10 | 10 |
%cover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value, |
| 11 | 11 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/2/_if[@name=""if is taxonpath only""]/else/_first/3", |
| 12 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,
|
|
| 12 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
|
| 13 | 13 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname, |
| 14 | 14 |
county,/location/locationplace/*_id/placepath/county, |
| 15 | 15 |
state,/location/locationplace/*_id/placepath/stateprovince, |
| inputs/CVS/Organism/test.xml.ref | ||
|---|---|---|
| 31 | 31 |
<taxondetermination> |
| 32 | 32 |
<taxonpath_id> |
| 33 | 33 |
<taxonpath> |
| 34 |
<identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname> |
|
| 34 |
<canon_taxonpath_id> |
|
| 35 |
<taxonpath> |
|
| 36 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 37 |
<identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname> |
|
| 38 |
</taxonpath> |
|
| 39 |
</canon_taxonpath_id> |
|
| 35 | 40 |
<taxonomicname>$currentTaxonName sec Weakley 2006</taxonomicname> |
| 36 | 41 |
</taxonpath> |
| 37 | 42 |
</taxonpath_id> |
| ... | ... | |
| 50 | 55 |
</path> |
| 51 | 56 |
</_simplifyPath> |
| 52 | 57 |
</VegBIEN> |
| 53 |
Inserted 14 new rows into database |
|
| 58 |
Inserted 17 new rows into database |
|
| inputs/REMIB/Specimen/VegBIEN.csv | ||
|---|---|---|
| 33 | 33 |
HAVING count(*) > 1 |
| 34 | 34 |
-----" |
| 35 | 35 |
acronym,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 36 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 37 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 38 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 36 | 39 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 37 | 40 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 38 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 39 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 40 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 41 | 41 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 42 | 42 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 43 | 43 |
accession_number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then","Not globally unique, only (usually) unique within the institution providing the data (""acronym""). Note that there are nevertheless 11,869 rows where an accession_number appears multiple times within the same institution. [1]
|
| inputs/REMIB/Specimen/test.xml.ref | ||
|---|---|---|
| 64 | 64 |
<taxondetermination> |
| 65 | 65 |
<taxonpath_id> |
| 66 | 66 |
<taxonpath> |
| 67 |
<canon_taxonpath_id> |
|
| 68 |
<taxonpath> |
|
| 69 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 70 |
<identifyingtaxonomicname> |
|
| 71 |
<_join_words> |
|
| 72 |
<1>$family</1> |
|
| 73 |
<2>$genus</2> |
|
| 74 |
<3>$specificEpithet</3> |
|
| 75 |
</_join_words> |
|
| 76 |
</identifyingtaxonomicname> |
|
| 77 |
</taxonpath> |
|
| 78 |
</canon_taxonpath_id> |
|
| 67 | 79 |
<family>$family</family> |
| 68 | 80 |
<genus>$genus</genus> |
| 69 |
<identifyingtaxonomicname> |
|
| 70 |
<_join_words> |
|
| 71 |
<1>$family</1> |
|
| 72 |
<2>$genus</2> |
|
| 73 |
<3>$specificEpithet</3> |
|
| 74 |
</_join_words> |
|
| 75 |
</identifyingtaxonomicname> |
|
| 76 | 81 |
<species>$specificEpithet</species> |
| 77 | 82 |
</taxonpath> |
| 78 | 83 |
</taxonpath_id> |
| ... | ... | |
| 104 | 109 |
</path> |
| 105 | 110 |
</_simplifyPath> |
| 106 | 111 |
</VegBIEN> |
| 107 |
Inserted 23 new rows into database |
|
| 112 |
Inserted 25 new rows into database |
|
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
StemTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then", |
| 21 | 21 |
Tag,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/then", |
| 22 | 22 |
MeasureID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else", |
| 23 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 25 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 26 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
|
| 27 |
SpeciesAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
|
| 23 | 28 |
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author, |
| 24 | 29 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 25 | 30 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 28 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 29 |
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4, |
|
| 30 |
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2, |
|
| 31 | 31 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 32 | 32 |
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1, |
| 33 | 33 |
Description,,** No join mapping for *Description ** |
| inputs/CTFS/StemObservation/test.xml.ref | ||
|---|---|---|
| 41 | 41 |
<taxondetermination> |
| 42 | 42 |
<taxonpath_id> |
| 43 | 43 |
<taxonpath> |
| 44 |
<canon_taxonpath_id> |
|
| 45 |
<taxonpath> |
|
| 46 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 47 |
<identifyingtaxonomicname> |
|
| 48 |
<_join_words> |
|
| 49 |
<1> |
|
| 50 |
<_join_words> |
|
| 51 |
<1>$Family</1> |
|
| 52 |
<2>$Genus</2> |
|
| 53 |
<3>$SpeciesName</3> |
|
| 54 |
<4>$SubSpeciesName</4> |
|
| 55 |
</_join_words> |
|
| 56 |
</1> |
|
| 57 |
<2>$SpeciesAuthority</2> |
|
| 58 |
</_join_words> |
|
| 59 |
</identifyingtaxonomicname> |
|
| 60 |
</taxonpath> |
|
| 61 |
</canon_taxonpath_id> |
|
| 44 | 62 |
<author>$SpeciesAuthority</author> |
| 45 | 63 |
<family>$Family</family> |
| 46 | 64 |
<genus>$Genus</genus> |
| 47 |
<identifyingtaxonomicname> |
|
| 48 |
<_join_words> |
|
| 49 |
<1> |
|
| 50 |
<_join_words> |
|
| 51 |
<1>$Family</1> |
|
| 52 |
<2>$Genus</2> |
|
| 53 |
<3>$SpeciesName</3> |
|
| 54 |
<4>$SubSpeciesName</4> |
|
| 55 |
</_join_words> |
|
| 56 |
</1> |
|
| 57 |
<2>$SpeciesAuthority</2> |
|
| 58 |
</_join_words> |
|
| 59 |
</identifyingtaxonomicname> |
|
| 60 | 65 |
<species>$SpeciesName</species> |
| 61 | 66 |
<subspecies>$SubSpeciesName</subspecies> |
| 62 | 67 |
</taxonpath> |
| ... | ... | |
| 68 | 73 |
</path> |
| 69 | 74 |
</_simplifyPath> |
| 70 | 75 |
</VegBIEN> |
| 71 |
Inserted 13 new rows into database |
|
| 76 |
Inserted 15 new rows into database |
|
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
CensusID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 9 | 9 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists", |
| 10 | 10 |
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 11 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 12 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 13 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 14 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
|
| 11 | 15 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 12 | 16 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 13 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 14 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 15 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 16 |
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4, |
|
| 17 | 17 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 18 | 18 |
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1, |
| 19 | 19 |
Description,,** No join mapping for *Description ** |
| inputs/CTFS/TaxonOccurrence/test.xml.ref | ||
|---|---|---|
| 12 | 12 |
<taxondetermination> |
| 13 | 13 |
<taxonpath_id> |
| 14 | 14 |
<taxonpath> |
| 15 |
<canon_taxonpath_id> |
|
| 16 |
<taxonpath> |
|
| 17 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 18 |
<identifyingtaxonomicname> |
|
| 19 |
<_join_words> |
|
| 20 |
<1>$Family</1> |
|
| 21 |
<2>$Genus</2> |
|
| 22 |
<3>$SpeciesName</3> |
|
| 23 |
<4>$SubSpeciesName</4> |
|
| 24 |
</_join_words> |
|
| 25 |
</identifyingtaxonomicname> |
|
| 26 |
</taxonpath> |
|
| 27 |
</canon_taxonpath_id> |
|
| 15 | 28 |
<family>$Family</family> |
| 16 | 29 |
<genus>$Genus</genus> |
| 17 |
<identifyingtaxonomicname> |
|
| 18 |
<_join_words> |
|
| 19 |
<1>$Family</1> |
|
| 20 |
<2>$Genus</2> |
|
| 21 |
<3>$SpeciesName</3> |
|
| 22 |
<4>$SubSpeciesName</4> |
|
| 23 |
</_join_words> |
|
| 24 |
</identifyingtaxonomicname> |
|
| 25 | 30 |
<species>$SpeciesName</species> |
| 26 | 31 |
<subspecies>$SubSpeciesName</subspecies> |
| 27 | 32 |
</taxonpath> |
| ... | ... | |
| 33 | 38 |
</path> |
| 34 | 39 |
</_simplifyPath> |
| 35 | 40 |
</VegBIEN> |
| 36 |
Inserted 9 new rows into database |
|
| 41 |
Inserted 12 new rows into database |
|
| inputs/FIA/Organism/test.xml.ref | ||
|---|---|---|
| 62 | 62 |
<taxondetermination> |
| 63 | 63 |
<taxonpath_id> |
| 64 | 64 |
<taxonpath> |
| 65 |
<canon_taxonpath_id> |
|
| 66 |
<taxonpath> |
|
| 67 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 68 |
<identifyingtaxonomicname> |
|
| 69 |
<_join_words> |
|
| 70 |
<2>$Genus</2> |
|
| 71 |
<3>$SpecificEpithet</3> |
|
| 72 |
</_join_words> |
|
| 73 |
</identifyingtaxonomicname> |
|
| 74 |
</taxonpath> |
|
| 75 |
</canon_taxonpath_id> |
|
| 65 | 76 |
<genus>$Genus</genus> |
| 66 |
<identifyingtaxonomicname> |
|
| 67 |
<_join_words> |
|
| 68 |
<2>$Genus</2> |
|
| 69 |
<3>$SpecificEpithet</3> |
|
| 70 |
</_join_words> |
|
| 71 |
</identifyingtaxonomicname> |
|
| 72 | 77 |
<species>$SpecificEpithet</species> |
| 73 | 78 |
</taxonpath> |
| 74 | 79 |
</taxonpath_id> |
| ... | ... | |
| 87 | 92 |
</path> |
| 88 | 93 |
</_simplifyPath> |
| 89 | 94 |
</VegBIEN> |
| 90 |
Inserted 17 new rows into database |
|
| 95 |
Inserted 19 new rows into database |
|
| inputs/SALVIAS/plotObservations/test.xml.ref | ||
|---|---|---|
| 118 | 118 |
<taxondetermination> |
| 119 | 119 |
<taxonpath_id> |
| 120 | 120 |
<taxonpath> |
| 121 |
<author>$auth</author> |
|
| 122 |
<family>$Family</family> |
|
| 123 |
<genus>$Genus</genus> |
|
| 124 |
<identifyingtaxonomicname> |
|
| 125 |
<_join_words> |
|
| 126 |
<1> |
|
| 121 |
<canon_taxonpath_id> |
|
| 122 |
<taxonpath> |
|
| 123 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 124 |
<identifyingtaxonomicname> |
|
| 127 | 125 |
<_join_words> |
| 128 |
<1>$Family</1> |
|
| 129 |
<2>$Genus</2> |
|
| 130 |
<3>$Species</3> |
|
| 131 |
<5> |
|
| 126 |
<1> |
|
| 132 | 127 |
<_join_words> |
| 133 |
<1> |
|
| 134 |
<_if name="if has infraspecificEpithet"> |
|
| 135 |
<cond>$infra_ep_1</cond> |
|
| 136 |
<then>$infra_rank_1</then> |
|
| 137 |
</_if> |
|
| 138 |
</1> |
|
| 139 |
<2>$infra_ep_1</2> |
|
| 128 |
<1>$Family</1> |
|
| 129 |
<2>$Genus</2> |
|
| 130 |
<3>$Species</3> |
|
| 131 |
<5> |
|
| 132 |
<_join_words> |
|
| 133 |
<1> |
|
| 134 |
<_if name="if has infraspecificEpithet"> |
|
| 135 |
<cond>$infra_ep_1</cond> |
|
| 136 |
<then>$infra_rank_1</then> |
|
| 137 |
</_if> |
|
| 138 |
</1> |
|
| 139 |
<2>$infra_ep_1</2> |
|
| 140 |
</_join_words> |
|
| 141 |
</5> |
|
| 140 | 142 |
</_join_words> |
| 141 |
</5> |
|
| 143 |
</1> |
|
| 144 |
<2>$auth</2> |
|
| 142 | 145 |
</_join_words> |
| 143 |
</1> |
|
| 144 |
<2>$auth</2> |
|
| 145 |
</_join_words> |
|
| 146 |
</identifyingtaxonomicname> |
|
| 146 |
</identifyingtaxonomicname> |
|
| 147 |
</taxonpath> |
|
| 148 |
</canon_taxonpath_id> |
|
| 149 |
<author>$auth</author> |
|
| 150 |
<family>$Family</family> |
|
| 151 |
<genus>$Genus</genus> |
|
| 147 | 152 |
<species>$Species</species> |
| 148 | 153 |
<subspecies> |
| 149 | 154 |
<_join_words> |
| ... | ... | |
| 164 | 169 |
<isoriginal>true</isoriginal> |
| 165 | 170 |
<taxonpath_id> |
| 166 | 171 |
<taxonpath> |
| 172 |
<canon_taxonpath_id> |
|
| 173 |
<taxonpath> |
|
| 174 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 175 |
<identifyingtaxonomicname> |
|
| 176 |
<_join_words> |
|
| 177 |
<1>$OrigFamily</1> |
|
| 178 |
<2>$OrigGenus</2> |
|
| 179 |
<3>$OrigSpecies</3> |
|
| 180 |
</_join_words> |
|
| 181 |
</identifyingtaxonomicname> |
|
| 182 |
</taxonpath> |
|
| 183 |
</canon_taxonpath_id> |
|
| 167 | 184 |
<family>$OrigFamily</family> |
| 168 | 185 |
<genus>$OrigGenus</genus> |
| 169 |
<identifyingtaxonomicname> |
|
| 170 |
<_join_words> |
|
| 171 |
<1>$OrigFamily</1> |
|
| 172 |
<2>$OrigGenus</2> |
|
| 173 |
<3>$OrigSpecies</3> |
|
| 174 |
</_join_words> |
|
| 175 |
</identifyingtaxonomicname> |
|
| 176 | 186 |
<species>$OrigSpecies</species> |
| 177 | 187 |
</taxonpath> |
| 178 | 188 |
</taxonpath_id> |
| ... | ... | |
| 211 | 221 |
</path> |
| 212 | 222 |
</_simplifyPath> |
| 213 | 223 |
</VegBIEN> |
| 214 |
Inserted 34 new rows into database |
|
| 224 |
Inserted 39 new rows into database |
|
| inputs/.TNRS/tnrs/test.xml.ref | ||
|---|---|---|
| 9 | 9 |
<taxondetermination> |
| 10 | 10 |
<taxonpath_id> |
| 11 | 11 |
<taxonpath> |
| 12 |
<author>$Name_matched_author</author> |
|
| 13 |
<canon_taxonpath_id> |
|
| 14 |
<taxonpath> |
|
| 15 |
<canon_taxonpath_id>0</canon_taxonpath_id> |
|
| 16 |
<author>$Accepted_name_author</author> |
|
| 17 |
<family>$Accepted_name_family</family> |
|
| 18 |
<identifyingtaxonomicname> |
|
| 19 |
<_join_words> |
|
| 20 |
<1> |
|
| 21 |
<_alt> |
|
| 22 |
<1>$Accepted_name</1> |
|
| 23 |
<2>$Accepted_name_family</2> |
|
| 24 |
</_alt> |
|
| 25 |
</1> |
|
| 26 |
<2>$Accepted_name_author</2> |
|
| 27 |
</_join_words> |
|
| 28 |
</identifyingtaxonomicname> |
|
| 29 |
<taxonomicname>$Accepted_name</taxonomicname> |
|
| 30 |
</taxonpath> |
|
| 31 |
</canon_taxonpath_id> |
|
| 32 |
<family>$Family_matched</family> |
|
| 33 |
<genus>$Genus_matched</genus> |
|
| 34 | 12 |
<identifyingtaxonomicname> |
| 35 | 13 |
<_alt> |
| 36 | 14 |
<1>$Name_submitted</1> |
| ... | ... | |
| 68 | 46 |
</2> |
| 69 | 47 |
</_alt> |
| 70 | 48 |
</identifyingtaxonomicname> |
| 49 |
<author>$Name_matched_author</author> |
|
| 50 |
<canon_taxonpath_id> |
|
| 51 |
<taxonpath> |
|
| 52 |
<canon_taxonpath_id>0</canon_taxonpath_id> |
|
| 53 |
<author>$Accepted_name_author</author> |
|
| 54 |
<family>$Accepted_name_family</family> |
|
| 55 |
<identifyingtaxonomicname> |
|
| 56 |
<_join_words> |
|
| 57 |
<1> |
|
| 58 |
<_alt> |
|
| 59 |
<1>$Accepted_name</1> |
|
| 60 |
<2>$Accepted_name_family</2> |
|
| 61 |
</_alt> |
|
| 62 |
</1> |
|
| 63 |
<2>$Accepted_name_author</2> |
|
| 64 |
</_join_words> |
|
| 65 |
</identifyingtaxonomicname> |
|
| 66 |
<taxonomicname>$Accepted_name</taxonomicname> |
|
| 67 |
</taxonpath> |
|
| 68 |
</canon_taxonpath_id> |
|
| 69 |
<family>$Family_matched</family> |
|
| 70 |
<genus>$Genus_matched</genus> |
|
| 71 | 71 |
<subspecies> |
| 72 | 72 |
<_join_words> |
| 73 | 73 |
<1> |
| inputs/U/Specimen/test.xml.ref | ||
|---|---|---|
| 75 | 75 |
</party_id> |
| 76 | 76 |
<taxonpath_id> |
| 77 | 77 |
<taxonpath> |
| 78 |
<canon_taxonpath_id> |
|
| 79 |
<taxonpath> |
|
| 80 |
<datasource_id><party><organizationname>TNRS</organizationname></party></datasource_id> |
|
| 81 |
<identifyingtaxonomicname> |
|
| 82 |
<_join_words> |
|
| 83 |
<1>$Family</1> |
|
| 84 |
<2>$Genus</2> |
|
| 85 |
</_join_words> |
|
| 86 |
</identifyingtaxonomicname> |
|
| 87 |
</taxonpath> |
|
| 88 |
</canon_taxonpath_id> |
|
| 78 | 89 |
<family>$Family</family> |
| 79 | 90 |
<genus>$Genus</genus> |
| 80 |
<identifyingtaxonomicname> |
|
| 81 |
<_join_words> |
|
| 82 |
<1>$Family</1> |
|
| 83 |
<2>$Genus</2> |
|
| 84 |
</_join_words> |
|
| 85 |
</identifyingtaxonomicname> |
|
| 86 | 91 |
</taxonpath> |
| 87 | 92 |
</taxonpath_id> |
| 88 | 93 |
<determinationdate> |
| ... | ... | |
| 137 | 142 |
</path> |
| 138 | 143 |
</_simplifyPath> |
| 139 | 144 |
</VegBIEN> |
| 140 |
Inserted 23 new rows into database |
|
| 145 |
Inserted 26 new rows into database |
|
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 16 | 16 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 17 | 17 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 18 | 18 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 19 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
|
| 20 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
|
| 21 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
|
| 22 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3",
|
|
| 23 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
|
|
| 24 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2",
|
|
| 25 |
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/_if[@name=""if has accepted name""]/{then/.,else/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/2",
|
|
| 19 | 26 |
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/author, |
| 20 | 27 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/family, |
| 21 | 28 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus, |
| 22 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 23 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 24 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 25 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 26 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
|
| 27 |
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
|
| 28 |
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/2, |
|
| 29 | 29 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species, |
| 30 | 30 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
| 31 | 31 |
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/2/_join_words/2, |
| 32 | 32 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname, |
| 33 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 34 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 35 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/canon_taxonpath_id/taxonpath:[datasource_id/party/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 33 | 36 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/family, |
| 34 | 37 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus, |
| 35 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 36 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 37 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 38 | 38 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/taxonomicname, |
| 39 | 39 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 40 | 40 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| inputs/NCU-NCSC/Specimen/test.xml.ref | ||
|---|---|---|
| 67 | 67 |
<taxondetermination> |
| 68 | 68 |
<taxonpath_id> |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: non-TNRS taxonpaths: Store the concatenated identifyingtaxonomicname in a separate taxonpath owned by the TNRS datasource, so that it will match up with (and create a link to) the corresponding submitted TNRS name's taxonpath. This in turn is linked to the TNRS-determined accepted name, thus creating a three-level hierarchy of datasource name -> concatenated name -> accepted name.