Revision 5596
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 15 | 15 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 16 | 16 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 17 | 17 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 18 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 19 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 18 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 19 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 20 | 20 |
locality,/location/locationnarrative/_merge/1, |
| 21 | 21 |
continent,/location/locationplace/*_id/placepath/continent, |
| 22 | 22 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
| inputs/MT/Specimen/test.xml.ref | ||
|---|---|---|
| 80 | 80 |
<parent_id> |
| 81 | 81 |
<taxonconcept> |
| 82 | 82 |
<rank>genus</rank> |
| 83 |
<taxonname>$genus</taxonname>
|
|
| 83 |
<taxonepithet>$genus</taxonepithet>
|
|
| 84 | 84 |
<parent_id> |
| 85 | 85 |
<taxonconcept> |
| 86 | 86 |
<rank>family</rank> |
| 87 |
<taxonname>$family</taxonname>
|
|
| 87 |
<taxonepithet>$family</taxonepithet>
|
|
| 88 | 88 |
</taxonconcept> |
| 89 | 89 |
</parent_id> |
| 90 | 90 |
</taxonconcept> |
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 35 | 35 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 36 | 36 |
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 37 | 37 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 38 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
|
|
| 39 |
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 40 |
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 41 |
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 42 |
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 43 |
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 44 |
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
|
|
| 45 |
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 38 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
|
|
| 39 |
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 40 |
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 41 |
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 42 |
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 43 |
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 44 |
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
|
|
| 45 |
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 46 | 46 |
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 47 | 47 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 48 | 48 |
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 25 | 25 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 26 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 27 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 28 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 29 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 30 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 28 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 29 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 30 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 31 | 31 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 32 | 32 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 33 | 33 |
Comments,,** No join mapping for *Comments ** |
| inputs/TEAM/VL/test.xml.ref | ||
|---|---|---|
| 80 | 80 |
<parent_id> |
| 81 | 81 |
<taxonconcept> |
| 82 | 82 |
<rank>species</rank> |
| 83 |
<taxonname>$Species</taxonname>
|
|
| 83 |
<taxonepithet>$Species</taxonepithet>
|
|
| 84 | 84 |
<parent_id> |
| 85 | 85 |
<taxonconcept> |
| 86 | 86 |
<rank>genus</rank> |
| 87 |
<taxonname>$Genus</taxonname>
|
|
| 87 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 88 | 88 |
<parent_id> |
| 89 | 89 |
<taxonconcept> |
| 90 | 90 |
<rank>family</rank> |
| 91 |
<taxonname>$Family</taxonname>
|
|
| 91 |
<taxonepithet>$Family</taxonepithet>
|
|
| 92 | 92 |
</taxonconcept> |
| 93 | 93 |
</parent_id> |
| 94 | 94 |
</taxonconcept> |
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 25 | 25 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 26 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 27 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 28 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 29 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 30 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 28 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 29 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 30 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 31 | 31 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 32 | 32 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 33 | 33 |
Comments,,** No join mapping for *Comments ** |
| inputs/TEAM/VT/test.xml.ref | ||
|---|---|---|
| 80 | 80 |
<parent_id> |
| 81 | 81 |
<taxonconcept> |
| 82 | 82 |
<rank>species</rank> |
| 83 |
<taxonname>$Species</taxonname>
|
|
| 83 |
<taxonepithet>$Species</taxonepithet>
|
|
| 84 | 84 |
<parent_id> |
| 85 | 85 |
<taxonconcept> |
| 86 | 86 |
<rank>genus</rank> |
| 87 |
<taxonname>$Genus</taxonname>
|
|
| 87 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 88 | 88 |
<parent_id> |
| 89 | 89 |
<taxonconcept> |
| 90 | 90 |
<rank>family</rank> |
| 91 |
<taxonname>$Family</taxonname>
|
|
| 91 |
<taxonepithet>$Family</taxonepithet>
|
|
| 92 | 92 |
</taxonconcept> |
| 93 | 93 |
</parent_id> |
| 94 | 94 |
</taxonconcept> |
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 40 | 40 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 41 | 41 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 42 | 42 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 43 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
|
|
| 44 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 45 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 46 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 47 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 48 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 49 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
|
|
| 50 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 43 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
|
|
| 44 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 45 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 46 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 47 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 48 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 49 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
|
|
| 50 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 51 | 51 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 52 | 52 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 53 | 53 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
|
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 172 | 172 |
<parent_id> |
| 173 | 173 |
<taxonconcept> |
| 174 | 174 |
<rank>subspecies</rank> |
| 175 |
<taxonname>$Subspecies</taxonname>
|
|
| 175 |
<taxonepithet>$Subspecies</taxonepithet>
|
|
| 176 | 176 |
<parent_id> |
| 177 | 177 |
<taxonconcept> |
| 178 | 178 |
<rank>species</rank> |
| 179 |
<taxonname>$Species</taxonname>
|
|
| 179 |
<taxonepithet>$Species</taxonepithet>
|
|
| 180 | 180 |
<parent_id> |
| 181 | 181 |
<taxonconcept> |
| 182 | 182 |
<rank>genus</rank> |
| 183 |
<taxonname>$Genus</taxonname>
|
|
| 183 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 184 | 184 |
<parent_id> |
| 185 | 185 |
<taxonconcept> |
| 186 | 186 |
<rank>family</rank> |
| 187 |
<taxonname>$Family</taxonname>
|
|
| 187 |
<taxonepithet>$Family</taxonepithet>
|
|
| 188 | 188 |
<parent_id> |
| 189 | 189 |
<taxonconcept> |
| 190 | 190 |
<rank>order</rank> |
| 191 |
<taxonname>$Order</taxonname>
|
|
| 191 |
<taxonepithet>$Order</taxonepithet>
|
|
| 192 | 192 |
<parent_id> |
| 193 | 193 |
<taxonconcept> |
| 194 | 194 |
<rank>class</rank> |
| 195 |
<taxonname>$Class</taxonname>
|
|
| 195 |
<taxonepithet>$Class</taxonepithet>
|
|
| 196 | 196 |
<parent_id> |
| 197 | 197 |
<taxonconcept> |
| 198 | 198 |
<rank>phylum</rank> |
| 199 |
<taxonname>$Phylum</taxonname>
|
|
| 199 |
<taxonepithet>$Phylum</taxonepithet>
|
|
| 200 | 200 |
<parent_id> |
| 201 | 201 |
<taxonconcept> |
| 202 | 202 |
<rank>kingdom</rank> |
| 203 |
<taxonname>$Kingdom</taxonname>
|
|
| 203 |
<taxonepithet>$Kingdom</taxonepithet>
|
|
| 204 | 204 |
</taxonconcept> |
| 205 | 205 |
</parent_id> |
| 206 | 206 |
</taxonconcept> |
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 44 | 44 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 45 | 45 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 46 | 46 |
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 47 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 48 |
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 49 |
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 47 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 48 |
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 49 |
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 50 | 50 |
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 51 | 51 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname,"Contains less than ""Specie+autor""" |
| 52 | 52 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor, |
| ... | ... | |
| 55 | 55 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/genus,Often = Genera |
| 56 | 56 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 57 | 57 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera |
| 58 |
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",Often = Genera
|
|
| 59 |
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 58 |
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",Often = Genera
|
|
| 59 |
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 60 | 60 |
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 61 | 61 |
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 62 | 62 |
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate" |
| inputs/Madidi/Organism/test.xml.ref | ||
|---|---|---|
| 134 | 134 |
<parent_id> |
| 135 | 135 |
<taxonconcept> |
| 136 | 136 |
<rank>species</rank> |
| 137 |
<taxonname>$Specific epithet</taxonname>
|
|
| 137 |
<taxonepithet>$Specific epithet</taxonepithet>
|
|
| 138 | 138 |
<parent_id> |
| 139 | 139 |
<taxonconcept> |
| 140 | 140 |
<rank>genus</rank> |
| 141 |
<taxonname>$Genera</taxonname>
|
|
| 141 |
<taxonepithet>$Genera</taxonepithet>
|
|
| 142 | 142 |
<parent_id> |
| 143 | 143 |
<taxonconcept> |
| 144 | 144 |
<rank>family</rank> |
| 145 |
<taxonname>$Family (revised)</taxonname>
|
|
| 145 |
<taxonepithet>$Family (revised)</taxonepithet>
|
|
| 146 | 146 |
</taxonconcept> |
| 147 | 147 |
</parent_id> |
| 148 | 148 |
</taxonconcept> |
| ... | ... | |
| 208 | 208 |
<parent_id> |
| 209 | 209 |
<taxonconcept> |
| 210 | 210 |
<rank>genus</rank> |
| 211 |
<taxonname>$Field name</taxonname>
|
|
| 211 |
<taxonepithet>$Field name</taxonepithet>
|
|
| 212 | 212 |
<parent_id> |
| 213 | 213 |
<taxonconcept> |
| 214 | 214 |
<rank>family</rank> |
| 215 |
<taxonname>$Field family</taxonname>
|
|
| 215 |
<taxonepithet>$Field family</taxonepithet>
|
|
| 216 | 216 |
</taxonconcept> |
| 217 | 217 |
</parent_id> |
| 218 | 218 |
</taxonconcept> |
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 58 | 58 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank/_alt/2", |
| 59 | 59 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/1", |
| 60 | 60 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/2", |
| 61 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 62 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 63 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 64 |
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 61 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 62 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 63 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 64 |
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 65 | 65 |
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank/_alt/1, |
| 66 | 66 |
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank/_alt/2, |
| 67 | 67 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 147 | 147 |
<parent_id> |
| 148 | 148 |
<taxonconcept> |
| 149 | 149 |
<rank>species</rank> |
| 150 |
<taxonname>$species</taxonname>
|
|
| 150 |
<taxonepithet>$species</taxonepithet>
|
|
| 151 | 151 |
<parent_id> |
| 152 | 152 |
<taxonconcept> |
| 153 | 153 |
<rank>genus</rank> |
| 154 |
<taxonname>$genus</taxonname>
|
|
| 154 |
<taxonepithet>$genus</taxonepithet>
|
|
| 155 | 155 |
<parent_id> |
| 156 | 156 |
<taxonconcept> |
| 157 | 157 |
<rank>family</rank> |
| 158 |
<taxonname>$family</taxonname>
|
|
| 158 |
<taxonepithet>$family</taxonepithet>
|
|
| 159 | 159 |
</taxonconcept> |
| 160 | 160 |
</parent_id> |
| 161 | 161 |
</taxonconcept> |
| ... | ... | |
| 170 | 170 |
</parent_id> |
| 171 | 171 |
</taxonconcept> |
| 172 | 172 |
</parent_id> |
| 173 |
<taxonname>$infraname</taxonname>
|
|
| 173 |
<taxonepithet>$infraname</taxonepithet>
|
|
| 174 | 174 |
</taxonconcept> |
| 175 | 175 |
</parent_id> |
| 176 | 176 |
<rank> |
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 38 | 38 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 39 | 39 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank", |
| 40 | 40 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank", |
| 41 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 42 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 43 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 44 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 45 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 46 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
|
|
| 47 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 48 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 41 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 42 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 43 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 44 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 45 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 46 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
|
|
| 47 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 48 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 49 | 49 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 50 | 50 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 51 | 51 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor, |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 147 | 147 |
<parent_id> |
| 148 | 148 |
<taxonconcept> |
| 149 | 149 |
<rank>species</rank> |
| 150 |
<taxonname>$specificEpithet</taxonname>
|
|
| 150 |
<taxonepithet>$specificEpithet</taxonepithet>
|
|
| 151 | 151 |
<parent_id> |
| 152 | 152 |
<taxonconcept> |
| 153 | 153 |
<rank>genus</rank> |
| 154 |
<taxonname>$genus</taxonname>
|
|
| 154 |
<taxonepithet>$genus</taxonepithet>
|
|
| 155 | 155 |
<parent_id> |
| 156 | 156 |
<taxonconcept> |
| 157 | 157 |
<rank>family</rank> |
| 158 |
<taxonname>$family</taxonname>
|
|
| 158 |
<taxonepithet>$family</taxonepithet>
|
|
| 159 | 159 |
<parent_id> |
| 160 | 160 |
<taxonconcept> |
| 161 | 161 |
<rank>order</rank> |
| 162 |
<taxonname>$order</taxonname>
|
|
| 162 |
<taxonepithet>$order</taxonepithet>
|
|
| 163 | 163 |
<parent_id> |
| 164 | 164 |
<taxonconcept> |
| 165 | 165 |
<rank>class</rank> |
| 166 |
<taxonname>$class</taxonname>
|
|
| 166 |
<taxonepithet>$class</taxonepithet>
|
|
| 167 | 167 |
<parent_id> |
| 168 | 168 |
<taxonconcept> |
| 169 | 169 |
<rank>phylum</rank> |
| 170 |
<taxonname>$phylum</taxonname>
|
|
| 170 |
<taxonepithet>$phylum</taxonepithet>
|
|
| 171 | 171 |
<parent_id> |
| 172 | 172 |
<taxonconcept> |
| 173 | 173 |
<rank>kingdom</rank> |
| 174 |
<taxonname>$kingdom</taxonname>
|
|
| 174 |
<taxonepithet>$kingdom</taxonepithet>
|
|
| 175 | 175 |
</taxonconcept> |
| 176 | 176 |
</parent_id> |
| 177 | 177 |
</taxonconcept> |
| ... | ... | |
| 194 | 194 |
</parent_id> |
| 195 | 195 |
</taxonconcept> |
| 196 | 196 |
</parent_id> |
| 197 |
<taxonname>$infraspecificEpithet</taxonname>
|
|
| 197 |
<taxonepithet>$infraspecificEpithet</taxonepithet>
|
|
| 198 | 198 |
</taxonconcept> |
| 199 | 199 |
</parent_id> |
| 200 | 200 |
<rank>$taxonRank</rank> |
| inputs/.NCBI/higher_taxa/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank", |
| 9 | 9 |
rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 10 | 10 |
tax_id,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/sourceaccessioncode, |
| 11 |
name_txt,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname,
|
|
| 11 |
name_txt,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonepithet,
|
|
| 12 | 12 |
rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank, |
| 13 | 13 |
4,,** No join mapping for *4 ** |
| 14 | 14 |
5,,** No join mapping for *5 ** |
| inputs/.NCBI/higher_taxa/test.xml.ref | ||
|---|---|---|
| 12 | 12 |
<_taxonconcept_set_parent_id><parent_id><taxonconcept><sourceaccessioncode>$parent tax_id</sourceaccessioncode></taxonconcept></parent_id></_taxonconcept_set_parent_id> |
| 13 | 13 |
<rank>$rank</rank> |
| 14 | 14 |
<sourceaccessioncode>$tax_id</sourceaccessioncode> |
| 15 |
<taxonname>$name_txt</taxonname>
|
|
| 15 |
<taxonepithet>$name_txt</taxonepithet>
|
|
| 16 | 16 |
<verbatimrank>$rank</verbatimrank> |
| 17 | 17 |
</taxonconcept> |
| 18 | 18 |
</taxonconcept_id> |
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 76 | 76 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 77 | 77 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank", |
| 78 | 78 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank", |
| 79 |
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 80 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 81 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 82 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 79 |
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 80 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 81 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 82 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 83 | 83 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 84 | 84 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 85 | 85 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank, |
| ... | ... | |
| 87 | 87 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family,Brad: OMIT |
| 88 | 88 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
| 89 | 89 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
| 90 |
orig_species,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",Brad: OMIT
|
|
| 91 |
orig_family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Brad: OMIT
|
|
| 90 |
orig_species,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",Brad: OMIT
|
|
| 91 |
orig_family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",Brad: OMIT
|
|
| 92 | 92 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/species,Brad: OMIT |
| 93 | 93 |
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above |
| 94 | 94 |
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 | ||
|---|---|---|
| 202 | 202 |
<parent_id> |
| 203 | 203 |
<taxonconcept> |
| 204 | 204 |
<rank>species</rank> |
| 205 |
<taxonname>$specific_epithet</taxonname>
|
|
| 205 |
<taxonepithet>$specific_epithet</taxonepithet>
|
|
| 206 | 206 |
<parent_id> |
| 207 | 207 |
<taxonconcept> |
| 208 | 208 |
<rank>genus</rank> |
| 209 |
<taxonname>$genus</taxonname>
|
|
| 209 |
<taxonepithet>$genus</taxonepithet>
|
|
| 210 | 210 |
<parent_id> |
| 211 | 211 |
<taxonconcept> |
| 212 | 212 |
<rank>family</rank> |
| 213 |
<taxonname>$family</taxonname>
|
|
| 213 |
<taxonepithet>$family</taxonepithet>
|
|
| 214 | 214 |
</taxonconcept> |
| 215 | 215 |
</parent_id> |
| 216 | 216 |
</taxonconcept> |
| ... | ... | |
| 225 | 225 |
</parent_id> |
| 226 | 226 |
</taxonconcept> |
| 227 | 227 |
</parent_id> |
| 228 |
<taxonname>$infra_ep_1</taxonname>
|
|
| 228 |
<taxonepithet>$infra_ep_1</taxonepithet>
|
|
| 229 | 229 |
</taxonconcept> |
| 230 | 230 |
</parent_id> |
| 231 | 231 |
<rank>$infra_rank_1</rank> |
| ... | ... | |
| 273 | 273 |
<parent_id> |
| 274 | 274 |
<taxonconcept> |
| 275 | 275 |
<rank>species</rank> |
| 276 |
<taxonname>$orig_species</taxonname>
|
|
| 276 |
<taxonepithet>$orig_species</taxonepithet>
|
|
| 277 | 277 |
<parent_id> |
| 278 | 278 |
<taxonconcept> |
| 279 | 279 |
<rank>genus</rank> |
| 280 | 280 |
<parent_id> |
| 281 | 281 |
<taxonconcept> |
| 282 | 282 |
<rank>family</rank> |
| 283 |
<taxonname>$orig_family</taxonname>
|
|
| 283 |
<taxonepithet>$orig_family</taxonepithet>
|
|
| 284 | 284 |
</taxonconcept> |
| 285 | 285 |
</parent_id> |
| 286 | 286 |
</taxonconcept> |
| inputs/REMIB/Specimen/VegBIEN.csv | ||
|---|---|---|
| 38 | 38 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 39 | 39 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 40 | 40 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 41 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 42 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 43 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 41 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 42 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 43 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 44 | 44 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 45 | 45 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 46 | 46 |
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 | ||
|---|---|---|
| 100 | 100 |
<parent_id> |
| 101 | 101 |
<taxonconcept> |
| 102 | 102 |
<rank>species</rank> |
| 103 |
<taxonname>$specificEpithet</taxonname>
|
|
| 103 |
<taxonepithet>$specificEpithet</taxonepithet>
|
|
| 104 | 104 |
<parent_id> |
| 105 | 105 |
<taxonconcept> |
| 106 | 106 |
<rank>genus</rank> |
| 107 |
<taxonname>$genus</taxonname>
|
|
| 107 |
<taxonepithet>$genus</taxonepithet>
|
|
| 108 | 108 |
<parent_id> |
| 109 | 109 |
<taxonconcept> |
| 110 | 110 |
<rank>family</rank> |
| 111 |
<taxonname>$family</taxonname>
|
|
| 111 |
<taxonepithet>$family</taxonepithet>
|
|
| 112 | 112 |
</taxonconcept> |
| 113 | 113 |
</parent_id> |
| 114 | 114 |
</taxonconcept> |
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 29 | 29 |
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author, |
| 30 | 30 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 31 | 31 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 32 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
|
|
| 33 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 34 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 35 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 32 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
|
|
| 33 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 34 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 35 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 36 | 36 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 37 | 37 |
Description,,** No join mapping for *Description ** |
| 38 | 38 |
ExactDate,,** No join mapping for *ExactDate ** |
| inputs/CTFS/StemObservation/test.xml.ref | ||
|---|---|---|
| 81 | 81 |
<parent_id> |
| 82 | 82 |
<taxonconcept> |
| 83 | 83 |
<rank>subspecies</rank> |
| 84 |
<taxonname>$SubSpeciesName</taxonname>
|
|
| 84 |
<taxonepithet>$SubSpeciesName</taxonepithet>
|
|
| 85 | 85 |
<parent_id> |
| 86 | 86 |
<taxonconcept> |
| 87 | 87 |
<rank>species</rank> |
| 88 |
<taxonname>$SpeciesName</taxonname>
|
|
| 88 |
<taxonepithet>$SpeciesName</taxonepithet>
|
|
| 89 | 89 |
<parent_id> |
| 90 | 90 |
<taxonconcept> |
| 91 | 91 |
<rank>genus</rank> |
| 92 |
<taxonname>$Genus</taxonname>
|
|
| 92 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 93 | 93 |
<parent_id> |
| 94 | 94 |
<taxonconcept> |
| 95 | 95 |
<rank>family</rank> |
| 96 |
<taxonname>$Family</taxonname>
|
|
| 96 |
<taxonepithet>$Family</taxonepithet>
|
|
| 97 | 97 |
</taxonconcept> |
| 98 | 98 |
</parent_id> |
| 99 | 99 |
</taxonconcept> |
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 15 | 15 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
| 16 | 16 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 17 | 17 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 18 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
|
|
| 19 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 20 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 21 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 18 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
|
|
| 19 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 20 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 21 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 22 | 22 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 23 | 23 |
Description,,** No join mapping for *Description ** |
| 24 | 24 |
FamilyID,,** No join mapping for *FamilyID ** |
| inputs/CTFS/TaxonOccurrence/test.xml.ref | ||
|---|---|---|
| 46 | 46 |
<parent_id> |
| 47 | 47 |
<taxonconcept> |
| 48 | 48 |
<rank>subspecies</rank> |
| 49 |
<taxonname>$SubSpeciesName</taxonname>
|
|
| 49 |
<taxonepithet>$SubSpeciesName</taxonepithet>
|
|
| 50 | 50 |
<parent_id> |
| 51 | 51 |
<taxonconcept> |
| 52 | 52 |
<rank>species</rank> |
| 53 |
<taxonname>$SpeciesName</taxonname>
|
|
| 53 |
<taxonepithet>$SpeciesName</taxonepithet>
|
|
| 54 | 54 |
<parent_id> |
| 55 | 55 |
<taxonconcept> |
| 56 | 56 |
<rank>genus</rank> |
| 57 |
<taxonname>$Genus</taxonname>
|
|
| 57 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 58 | 58 |
<parent_id> |
| 59 | 59 |
<taxonconcept> |
| 60 | 60 |
<rank>family</rank> |
| 61 |
<taxonname>$Family</taxonname>
|
|
| 61 |
<taxonepithet>$Family</taxonepithet>
|
|
| 62 | 62 |
</taxonconcept> |
| 63 | 63 |
</parent_id> |
| 64 | 64 |
</taxonconcept> |
| inputs/FIA/Organism/test.xml.ref | ||
|---|---|---|
| 96 | 96 |
<parent_id> |
| 97 | 97 |
<taxonconcept> |
| 98 | 98 |
<rank>species</rank> |
| 99 |
<taxonname>$SpecificEpithet</taxonname>
|
|
| 99 |
<taxonepithet>$SpecificEpithet</taxonepithet>
|
|
| 100 | 100 |
<parent_id> |
| 101 | 101 |
<taxonconcept> |
| 102 | 102 |
<rank>genus</rank> |
| 103 |
<taxonname>$Genus</taxonname>
|
|
| 103 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 104 | 104 |
</taxonconcept> |
| 105 | 105 |
</parent_id> |
| 106 | 106 |
</taxonconcept> |
| inputs/SALVIAS/plotObservations/test.xml.ref | ||
|---|---|---|
| 173 | 173 |
<parent_id> |
| 174 | 174 |
<taxonconcept> |
| 175 | 175 |
<rank>species</rank> |
| 176 |
<taxonname>$Species</taxonname>
|
|
| 176 |
<taxonepithet>$Species</taxonepithet>
|
|
| 177 | 177 |
<parent_id> |
| 178 | 178 |
<taxonconcept> |
| 179 | 179 |
<rank>genus</rank> |
| 180 |
<taxonname>$Genus</taxonname>
|
|
| 180 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 181 | 181 |
<parent_id> |
| 182 | 182 |
<taxonconcept> |
| 183 | 183 |
<rank>family</rank> |
| 184 |
<taxonname>$Family</taxonname>
|
|
| 184 |
<taxonepithet>$Family</taxonepithet>
|
|
| 185 | 185 |
</taxonconcept> |
| 186 | 186 |
</parent_id> |
| 187 | 187 |
</taxonconcept> |
| ... | ... | |
| 196 | 196 |
</parent_id> |
| 197 | 197 |
</taxonconcept> |
| 198 | 198 |
</parent_id> |
| 199 |
<taxonname>$infra_ep_1</taxonname>
|
|
| 199 |
<taxonepithet>$infra_ep_1</taxonepithet>
|
|
| 200 | 200 |
</taxonconcept> |
| 201 | 201 |
</parent_id> |
| 202 | 202 |
<rank>$infra_rank_1</rank> |
| ... | ... | |
| 246 | 246 |
<parent_id> |
| 247 | 247 |
<taxonconcept> |
| 248 | 248 |
<rank>species</rank> |
| 249 |
<taxonname>$OrigSpecies</taxonname>
|
|
| 249 |
<taxonepithet>$OrigSpecies</taxonepithet>
|
|
| 250 | 250 |
<parent_id> |
| 251 | 251 |
<taxonconcept> |
| 252 | 252 |
<rank>genus</rank> |
| 253 |
<taxonname>$OrigGenus</taxonname>
|
|
| 253 |
<taxonepithet>$OrigGenus</taxonepithet>
|
|
| 254 | 254 |
<parent_id> |
| 255 | 255 |
<taxonconcept> |
| 256 | 256 |
<rank>family</rank> |
| 257 |
<taxonname>$OrigFamily</taxonname>
|
|
| 257 |
<taxonepithet>$OrigFamily</taxonepithet>
|
|
| 258 | 258 |
</taxonconcept> |
| 259 | 259 |
</parent_id> |
| 260 | 260 |
</taxonconcept> |
| inputs/.TNRS/tnrs/test.xml.ref | ||
|---|---|---|
| 85 | 85 |
</party> |
| 86 | 86 |
</creator_id> |
| 87 | 87 |
<rank>family</rank> |
| 88 |
<taxonname>$Accepted_name_family</taxonname>
|
|
| 88 |
<taxonepithet>$Accepted_name_family</taxonepithet>
|
|
| 89 | 89 |
</taxonconcept> |
| 90 | 90 |
</matched_concept_id> |
| 91 |
<taxonname>$Accepted_name_family</taxonname>
|
|
| 91 |
<taxonepithet>$Accepted_name_family</taxonepithet>
|
|
| 92 | 92 |
</taxonconcept> |
| 93 | 93 |
</parent_id> |
| 94 | 94 |
</taxonconcept> |
| ... | ... | |
| 135 | 135 |
<parent_id> |
| 136 | 136 |
<taxonconcept> |
| 137 | 137 |
<rank>species</rank> |
| 138 |
<taxonname>$Specific_epithet_matched</taxonname>
|
|
| 138 |
<taxonepithet>$Specific_epithet_matched</taxonepithet>
|
|
| 139 | 139 |
<parent_id> |
| 140 | 140 |
<taxonconcept> |
| 141 | 141 |
<rank>genus</rank> |
| 142 |
<taxonname>$Genus_matched</taxonname>
|
|
| 142 |
<taxonepithet>$Genus_matched</taxonepithet>
|
|
| 143 | 143 |
<parent_id> |
| 144 | 144 |
<taxonconcept> |
| 145 | 145 |
<rank>family</rank> |
| 146 |
<taxonname>$Name_matched_accepted_family</taxonname>
|
|
| 146 |
<taxonepithet>$Name_matched_accepted_family</taxonepithet>
|
|
| 147 | 147 |
</taxonconcept> |
| 148 | 148 |
</parent_id> |
| 149 | 149 |
</taxonconcept> |
| ... | ... | |
| 158 | 158 |
</parent_id> |
| 159 | 159 |
</taxonconcept> |
| 160 | 160 |
</parent_id> |
| 161 |
<taxonname>$Infraspecific_epithet_matched</taxonname>
|
|
| 161 |
<taxonepithet>$Infraspecific_epithet_matched</taxonepithet>
|
|
| 162 | 162 |
</taxonconcept> |
| 163 | 163 |
</parent_id> |
| 164 | 164 |
<rank>$Name_matched_rank</rank> |
| ... | ... | |
| 177 | 177 |
</_max> |
| 178 | 178 |
</matched_concept_fit_fraction> |
| 179 | 179 |
<species>$Specific_epithet_matched</species> |
| 180 |
<taxonname>$Unmatched_terms</taxonname>
|
|
| 180 |
<taxonepithet>$Unmatched_terms</taxonepithet>
|
|
| 181 | 181 |
<taxonomicname>$Name_matched</taxonomicname> |
| 182 | 182 |
<verbatimrank>$Infraspecific_rank</verbatimrank> |
| 183 | 183 |
</taxonconcept> |
| inputs/U/Specimen/test.xml.ref | ||
|---|---|---|
| 124 | 124 |
<parent_id> |
| 125 | 125 |
<taxonconcept> |
| 126 | 126 |
<rank>genus</rank> |
| 127 |
<taxonname>$Genus</taxonname>
|
|
| 127 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 128 | 128 |
<parent_id> |
| 129 | 129 |
<taxonconcept> |
| 130 | 130 |
<rank>family</rank> |
| 131 |
<taxonname>$Family</taxonname>
|
|
| 131 |
<taxonepithet>$Family</taxonepithet>
|
|
| 132 | 132 |
</taxonconcept> |
| 133 | 133 |
</parent_id> |
| 134 | 134 |
</taxonconcept> |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 29 | 29 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 30 | 30 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 31 | 31 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 32 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 33 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 34 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 35 |
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 32 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 33 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 34 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 35 |
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 36 | 36 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 37 | 37 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 38 | 38 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/family, |
| ... | ... | |
| 40 | 40 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 41 | 41 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 42 | 42 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 43 |
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 44 |
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 43 |
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 44 |
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 45 | 45 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/taxonomicname, |
| 46 | 46 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 47 | 47 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 395 | 395 |
<parent_id> |
| 396 | 396 |
<taxonconcept> |
| 397 | 397 |
<rank>subspecies</rank> |
| 398 |
<taxonname>$conceptual_darwin_2003_1_0_Subspecies</taxonname>
|
|
| 398 |
<taxonepithet>$conceptual_darwin_2003_1_0_Subspecies</taxonepithet>
|
|
| 399 | 399 |
<parent_id> |
| 400 | 400 |
<taxonconcept> |
| 401 | 401 |
<rank>species</rank> |
| 402 |
<taxonname>
|
|
| 402 |
<taxonepithet>
|
|
| 403 | 403 |
<_alt> |
| 404 | 404 |
<0>$conceptual_darwin_2003_1_0_Species</0> |
| 405 | 405 |
<1>$dwc_dwcore_SpecificEpithet</1> |
| 406 | 406 |
<2>$dwc_terms_specificEpithet</2> |
| 407 | 407 |
</_alt> |
| 408 |
</taxonname>
|
|
| 408 |
</taxonepithet>
|
|
| 409 | 409 |
<parent_id> |
| 410 | 410 |
<taxonconcept> |
| 411 | 411 |
<rank>genus</rank> |
| 412 |
<taxonname>
|
|
| 412 |
<taxonepithet>
|
|
| 413 | 413 |
<_alt> |
| 414 | 414 |
<0>$conceptual_darwin_2003_1_0_Genus</0> |
| 415 | 415 |
<1>$dwc_dwcore_Genus</1> |
| 416 | 416 |
<2>$dwc_terms_genus</2> |
| 417 | 417 |
</_alt> |
| 418 |
</taxonname>
|
|
| 418 |
</taxonepithet>
|
|
| 419 | 419 |
<parent_id> |
| 420 | 420 |
<taxonconcept> |
| 421 | 421 |
<rank>family</rank> |
| 422 |
<taxonname>
|
|
| 422 |
<taxonepithet>
|
|
| 423 | 423 |
<_alt> |
| 424 | 424 |
<0>$conceptual_darwin_2003_1_0_Family</0> |
| 425 | 425 |
<1>$dwc_dwcore_Family</1> |
| 426 | 426 |
<2>$dwc_terms_family</2> |
| 427 | 427 |
</_alt> |
| 428 |
</taxonname>
|
|
| 428 |
</taxonepithet>
|
|
| 429 | 429 |
<parent_id> |
| 430 | 430 |
<taxonconcept> |
| 431 | 431 |
<rank>order</rank> |
| 432 |
<taxonname>
|
|
| 432 |
<taxonepithet>
|
|
| 433 | 433 |
<_alt> |
| 434 | 434 |
<0>$conceptual_darwin_2003_1_0_Order</0> |
| 435 | 435 |
<1>$dwc_dwcore_Order</1> |
| 436 | 436 |
<2>$dwc_terms_order</2> |
| 437 | 437 |
</_alt> |
| 438 |
</taxonname>
|
|
| 438 |
</taxonepithet>
|
|
| 439 | 439 |
<parent_id> |
| 440 | 440 |
<taxonconcept> |
| 441 | 441 |
<rank>class</rank> |
| 442 |
<taxonname>
|
|
| 442 |
<taxonepithet>
|
|
| 443 | 443 |
<_alt> |
| 444 | 444 |
<0>$conceptual_darwin_2003_1_0_Class</0> |
| 445 | 445 |
<1>$dwc_dwcore_Class</1> |
| 446 | 446 |
<2>$dwc_terms_class</2> |
| 447 | 447 |
</_alt> |
| 448 |
</taxonname>
|
|
| 448 |
</taxonepithet>
|
|
| 449 | 449 |
<parent_id> |
| 450 | 450 |
<taxonconcept> |
| 451 | 451 |
<rank>phylum</rank> |
| 452 |
<taxonname>
|
|
| 452 |
<taxonepithet>
|
|
| 453 | 453 |
<_alt> |
| 454 | 454 |
<0>$conceptual_darwin_2003_1_0_Phylum</0> |
| 455 | 455 |
<1>$dwc_dwcore_Phylum</1> |
| 456 | 456 |
<2>$dwc_terms_phylum</2> |
| 457 | 457 |
</_alt> |
| 458 |
</taxonname>
|
|
| 458 |
</taxonepithet>
|
|
| 459 | 459 |
<parent_id> |
| 460 | 460 |
<taxonconcept> |
| 461 | 461 |
<rank>kingdom</rank> |
| 462 |
<taxonname>
|
|
| 462 |
<taxonepithet>
|
|
| 463 | 463 |
<_alt> |
| 464 | 464 |
<0>$conceptual_darwin_2003_1_0_Kingdom</0> |
| 465 | 465 |
<1>$dwc_dwcore_Kingdom</1> |
| 466 | 466 |
<2>$dwc_terms_kingdom</2> |
| 467 | 467 |
</_alt> |
| 468 |
</taxonname>
|
|
| 468 |
</taxonepithet>
|
|
| 469 | 469 |
</taxonconcept> |
| 470 | 470 |
</parent_id> |
| 471 | 471 |
</taxonconcept> |
| ... | ... | |
| 488 | 488 |
</parent_id> |
| 489 | 489 |
</taxonconcept> |
| 490 | 490 |
</parent_id> |
| 491 |
<taxonname>
|
|
| 491 |
<taxonepithet>
|
|
| 492 | 492 |
<_alt> |
| 493 | 493 |
<0>$dwc_dwcore_InfraspecificEpithet</0> |
| 494 | 494 |
<1>$dwc_terms_infraspecificEpithet</1> |
| 495 | 495 |
</_alt> |
| 496 |
</taxonname>
|
|
| 496 |
</taxonepithet>
|
|
| 497 | 497 |
</taxonconcept> |
| 498 | 498 |
</parent_id> |
| 499 | 499 |
<species> |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 18 | 18 |
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""fm. ""]/2",
|
| 19 | 19 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 20 | 20 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 21 |
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname",
|
|
| 22 |
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname",
|
|
| 23 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
|
|
| 24 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 25 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 26 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 27 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 28 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 29 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 21 |
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonepithet",
|
|
| 22 |
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonepithet",
|
|
| 23 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
|
|
| 24 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 25 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 26 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 27 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 28 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 29 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 30 | 30 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 31 | 31 |
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 32 | 32 |
interpretationdate,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/1/_*/date/_dateRangeStart/value",
|
| inputs/FIA/Organism/VegBIEN.csv | ||
|---|---|---|
| 19 | 19 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 20 | 20 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has explicit parent""]/else/_if[@name=""if has verbatim name""]/{then/.,else/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 21 | 21 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 22 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 23 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 22 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 23 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 24 | 24 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 25 | 25 |
County,/location/locationplace/*_id/placepath/county, |
| 26 | 26 |
StateProvince,/location/locationplace/*_id/placepath/stateprovince, |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 69 | 69 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 70 | 70 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank", |
| 71 | 71 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank", |
| 72 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 73 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 74 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 75 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 72 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 73 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 74 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 75 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 76 | 76 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 77 | 77 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 78 | 78 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank, |
| ... | ... | |
| 82 | 82 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
| 83 | 83 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 84 | 84 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
| 85 |
OrigSpecies,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",Brad: OMIT
|
|
| 86 |
OrigGenus,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 87 |
OrigFamily,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Brad: OMIT
|
|
| 85 |
OrigSpecies,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",Brad: OMIT
|
|
| 86 |
OrigGenus,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 87 |
OrigFamily,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",Brad: OMIT
|
|
| 88 | 88 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/species,Brad: OMIT |
| 89 | 89 |
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above |
| 90 | 90 |
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/.TNRS/tnrs/VegBIEN.csv | ||
|---|---|---|
| 16 | 16 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 17 | 17 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 18 | 18 |
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/identifyingtaxonomicname/_alt/2/_join_words/2, |
| 19 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=NCBI,rank=family]/taxonname",
|
|
| 20 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 19 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/matched_concept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=NCBI,rank=family]/taxonepithet",
|
|
| 20 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 21 | 21 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/rank, |
| 22 | 22 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/parent_id/taxonconcept/verbatimrank, |
| 23 | 23 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_taxonconcept_set_matched_concept_id/matched_concept_id/taxonconcept/rank, |
| ... | ... | |
| 28 | 28 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 29 | 29 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank", |
| 30 | 30 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank", |
| 31 |
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 32 |
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 33 |
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",Contains family based on matched name
|
|
| 34 |
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 31 |
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 32 |
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 33 |
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",Contains family based on matched name
|
|
| 34 |
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 35 | 35 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 36 | 36 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 37 | 37 |
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/author,Contains author in original string |
| ... | ... | |
| 43 | 43 |
Specific_epithet_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/matched_concept_fit_fraction/_max/3, |
| 44 | 44 |
Overall_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/matched_concept_fit_fraction/_max/4,Assuming is a fraction based on the range of values |
| 45 | 45 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/species, |
| 46 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/taxonname/_if[@name=""if has verbatim name""]/cond/_exists",
|
|
| 47 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/taxonname/_if[@name=""if has verbatim name""]/then",
|
|
| 46 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/taxonepithet/_if[@name=""if has verbatim name""]/cond/_exists",
|
|
| 47 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/taxonepithet/_if[@name=""if has verbatim name""]/then",
|
|
| 48 | 48 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/taxonomicname, |
| 49 | 49 |
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=matched_concept_id]/verbatimrank, |
| 50 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_if[@name=""if has verbatim name""]/cond/_exists",
|
|
| 51 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_if[@name=""if has verbatim name""]/else",
|
|
| 50 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonepithet/_if[@name=""if has verbatim name""]/cond/_exists",
|
|
| 51 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonepithet/_if[@name=""if has verbatim name""]/else",
|
|
| 52 | 52 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 53 | 53 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/verbatimrank, |
| 54 | 54 |
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid ** |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 24 | 24 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 25 | 25 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 26 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 27 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 26 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 27 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 28 | 28 |
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 29 | 29 |
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/{determinationdate,*_id/taxonconcept/creationdate}/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
|
| 30 | 30 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1, |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 43 | 43 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 44 | 44 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 45 | 45 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 46 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
|
|
| 47 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 48 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 49 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 50 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 51 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 52 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
|
|
| 53 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 46 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
|
|
| 47 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 48 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 49 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 50 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 51 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 52 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
|
|
| 53 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 54 | 54 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 55 | 55 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 56 | 56 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicnamewithauthor,Contains the binomial in addition to the authority |
| inputs/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 115 | 115 |
<parent_id> |
| 116 | 116 |
<taxonconcept> |
| 117 | 117 |
<rank>species</rank> |
| 118 |
<taxonname>$SpecificEpithet</taxonname>
|
|
| 118 |
<taxonepithet>$SpecificEpithet</taxonepithet>
|
|
| 119 | 119 |
<parent_id> |
| 120 | 120 |
<taxonconcept> |
| 121 | 121 |
<rank>genus</rank> |
| 122 |
<taxonname>$Genus</taxonname>
|
|
| 122 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 123 | 123 |
<parent_id> |
| 124 | 124 |
<taxonconcept> |
| 125 | 125 |
<rank>family</rank> |
| 126 |
<taxonname>$Family</taxonname>
|
|
| 126 |
<taxonepithet>$Family</taxonepithet>
|
|
| 127 | 127 |
</taxonconcept> |
| 128 | 128 |
</parent_id> |
| 129 | 129 |
</taxonconcept> |
| ... | ... | |
| 138 | 138 |
</parent_id> |
| 139 | 139 |
</taxonconcept> |
| 140 | 140 |
</parent_id> |
| 141 |
<taxonname>$InfraspecificEpithet</taxonname>
|
|
| 141 |
<taxonepithet>$InfraspecificEpithet</taxonepithet>
|
|
| 142 | 142 |
</taxonconcept> |
| 143 | 143 |
</parent_id> |
| 144 | 144 |
<species>$SpecificEpithet</species> |
| ... | ... | |
| 193 | 193 |
<parent_id> |
| 194 | 194 |
<taxonconcept> |
| 195 | 195 |
<rank>genus</rank> |
| 196 |
<taxonname>$GBIFGenusOriginal</taxonname>
|
|
| 196 |
<taxonepithet>$GBIFGenusOriginal</taxonepithet>
|
|
| 197 | 197 |
<parent_id> |
| 198 | 198 |
<taxonconcept> |
| 199 | 199 |
<rank>family</rank> |
| 200 |
<taxonname>$GBIFFamilyOriginal</taxonname>
|
|
| 200 |
<taxonepithet>$GBIFFamilyOriginal</taxonepithet>
|
|
| 201 | 201 |
</taxonconcept> |
| 202 | 202 |
</parent_id> |
| 203 | 203 |
</taxonconcept> |
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 34 | 34 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 35 | 35 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 36 | 36 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 37 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
|
|
| 38 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 39 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 40 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 41 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 37 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
|
|
| 38 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 39 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 40 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 41 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 42 | 42 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 43 | 43 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| 44 | 44 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| schemas/vegbien.my.sql | ||
|---|---|---|
| 203 | 203 |
matched_concept_id int(11), |
| 204 | 204 |
matched_concept_fit_fraction double precision, |
| 205 | 205 |
parent_id int(11), |
| 206 |
taxonname text,
|
|
| 206 |
taxonepithet text,
|
|
| 207 | 207 |
rank text, |
| 208 | 208 |
verbatimrank text, |
| 209 | 209 |
identifyingtaxonomicname text, |
| ... | ... | |
| 275 | 275 |
|
| 276 | 276 |
|
| 277 | 277 |
-- |
| 278 |
-- Name: COLUMN taxonconcept.taxonname; Type: COMMENT; Schema: public; Owner: -
|
|
| 278 |
-- Name: COLUMN taxonconcept.taxonepithet; Type: COMMENT; Schema: public; Owner: -
|
|
| 279 | 279 |
-- |
| 280 | 280 |
|
| 281 | 281 |
|
| ... | ... | |
| 1062 | 1062 |
-- |
| 1063 | 1063 |
|
| 1064 | 1064 |
CREATE VIEW analytical_db_view AS |
| 1065 |
SELECT datasource.organizationname AS `dataSourceName`, accepted_taxonconcept.family, accepted_taxonconcept.genus, accepted_taxonconcept.species, COALESCE(accepted_taxonconcept.taxonomicnamewithauthor, accepted_taxonconcept.taxonomicname) AS taxon, accepted_taxonconcept.author AS `taxonAuthor`, accepted_taxonconcept.taxonname AS `taxonMorphospecies`, placepath.country, placepath.stateprovince AS `stateProvince`, placepath.county AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, functions._m2_to_ha(location.area_m2) AS `plotAreaHa`, method.name AS `plotMethod`, locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, _fraction_to_percent(aggregateoccurrence.cover_fraction) AS `pctCover` FROM ((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonconcept datasource_taxonconcept USING (taxonconcept_id)) JOIN taxonconcept accepted_taxonconcept ON ((accepted_taxonconcept.taxonconcept_id = datasource_taxonconcept.accepted_concept_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 1065 |
SELECT datasource.organizationname AS `dataSourceName`, accepted_taxonconcept.family, accepted_taxonconcept.genus, accepted_taxonconcept.species, COALESCE(accepted_taxonconcept.taxonomicnamewithauthor, accepted_taxonconcept.taxonomicname) AS taxon, accepted_taxonconcept.author AS `taxonAuthor`, accepted_taxonconcept.taxonepithet AS `taxonMorphospecies`, placepath.country, placepath.stateprovince AS `stateProvince`, placepath.county AS `countyParish`, taxonoccurrence.verbatimcollectorname AS collector, plantobservation.collectionnumber AS `collectionNumber`, array_to_string(ARRAY[identifiedby.givenname, identifiedby.middlename, identifiedby.surname], CAST(' ' AS text)) AS `identifiedBy`, aggregateoccurrence.collectiondate AS `observationDate`, location.authorlocationcode AS `plotCode`, functions._m2_to_ha(location.area_m2) AS `plotAreaHa`, method.name AS `plotMethod`, locationcoords.latitude_deg AS latitude, locationcoords.longitude_deg AS longitude, location.elevation_m, taxonoccurrence.iscultivated AS `isCultivated`, taxonoccurrence.cultivatedbasis AS `isCultivatedReason`, _fraction_to_percent(aggregateoccurrence.cover_fraction) AS `pctCover` FROM ((((((((((((((location JOIN party datasource ON (((datasource.party_id = location.creator_id) AND (datasource.organizationname IS NOT NULL)))) LEFT JOIN locationcoords USING (location_id)) LEFT JOIN locationplace USING (location_id)) LEFT JOIN placepath USING (placepath_id)) JOIN locationevent USING (location_id)) LEFT JOIN method USING (method_id)) JOIN taxonoccurrence USING (locationevent_id)) JOIN taxondetermination USING (taxonoccurrence_id)) LEFT JOIN party identifiedby ON ((identifiedby.party_id = taxondetermination.party_id))) JOIN taxonconcept datasource_taxonconcept USING (taxonconcept_id)) JOIN taxonconcept accepted_taxonconcept ON ((accepted_taxonconcept.taxonconcept_id = datasource_taxonconcept.accepted_concept_id))) LEFT JOIN aggregateoccurrence USING (taxonoccurrence_id)) LEFT JOIN plantobservation USING (aggregateoccurrence_id)) LEFT JOIN specimenreplicate USING (plantobservation_id));
|
|
| 1066 | 1066 |
|
| 1067 | 1067 |
|
| 1068 | 1068 |
-- |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 166 | 166 |
acceptedForma,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/identifyingtaxonomicname, |
| 167 | 167 |
acceptedCultivar,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/identifyingtaxonomicname, |
| 168 | 168 |
acceptedScientificNameAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/identifyingtaxonomicname, |
| 169 |
acceptedCultivar,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=cultivar]/taxonname,
|
|
| 170 |
acceptedForma,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=forma]/taxonname,
|
|
| 171 |
acceptedVariety,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=variety]/taxonname,
|
|
| 172 |
acceptedSubspecies,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=subspecies]/taxonname,
|
|
| 173 |
acceptedSpecificEpithet,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=species]/taxonname,
|
|
| 174 |
acceptedGenus,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=genus]/taxonname,
|
|
| 175 |
acceptedFamily,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=family]/matched_concept_id/taxonconcept/taxonname,
|
|
| 176 |
acceptedFamily,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=family]/taxonname,
|
|
| 177 |
acceptedOrder,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=order]/taxonname,
|
|
| 178 |
acceptedClass,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=class]/taxonname,
|
|
| 179 |
acceptedPhylum,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=phylum]/taxonname,
|
|
| 180 |
acceptedKingdom,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=kingdom]/taxonname,
|
|
| 169 |
acceptedCultivar,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=cultivar]/taxonepithet,
|
|
| 170 |
acceptedForma,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=forma]/taxonepithet,
|
|
| 171 |
acceptedVariety,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=variety]/taxonepithet,
|
|
| 172 |
acceptedSubspecies,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=subspecies]/taxonepithet,
|
|
| 173 |
acceptedSpecificEpithet,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=species]/taxonepithet,
|
|
| 174 |
acceptedGenus,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=genus]/taxonepithet,
|
|
| 175 |
acceptedFamily,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=family]/matched_concept_id/taxonconcept/taxonepithet,
|
|
| 176 |
acceptedFamily,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=family]/taxonepithet,
|
|
| 177 |
acceptedOrder,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=order]/taxonepithet,
|
|
| 178 |
acceptedClass,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=class]/taxonepithet,
|
|
| 179 |
acceptedPhylum,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=phylum]/taxonepithet,
|
|
| 180 |
acceptedKingdom,//*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/parent_id[rank=kingdom]/taxonepithet,
|
|
| 181 | 181 |
acceptedTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/rank, |
| 182 |
acceptedInfraspecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 182 |
acceptedInfraspecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 183 | 183 |
acceptedTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/parent_id/taxonconcept/verbatimrank, |
| 184 | 184 |
acceptedTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/rank, |
| 185 | 185 |
acceptedSpecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/species, |
| ... | ... | |
| 199 | 199 |
parentTaxonID,"//parent_id/taxonconcept/_if[@name=""if has explicit parent""]/cond/_exists", |
| 200 | 200 |
taxonRank,"//parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank", |
| 201 | 201 |
taxonRank,"//parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank", |
| 202 |
cultivar,//taxonconcept/parent_id[rank=cultivar]/taxonname,
|
|
| 203 |
forma,//taxonconcept/parent_id[rank=forma]/taxonname,
|
|
| 204 |
variety,//taxonconcept/parent_id[rank=variety]/taxonname,
|
|
| 205 |
subspecies,//taxonconcept/parent_id[rank=subspecies]/taxonname,
|
|
| 206 |
specificEpithet,//taxonconcept/parent_id[rank=species]/taxonname,
|
|
| 207 |
genus,//taxonconcept/parent_id[rank=genus]/taxonname,
|
|
| 208 |
family,//taxonconcept/parent_id[rank=family]/taxonname,
|
|
| 209 |
order,//taxonconcept/parent_id[rank=order]/taxonname,
|
|
| 210 |
class,//taxonconcept/parent_id[rank=class]/taxonname,
|
|
| 211 |
phylum,//taxonconcept/parent_id[rank=phylum]/taxonname,
|
|
| 212 |
kingdom,//taxonconcept/parent_id[rank=kingdom]/taxonname,
|
|
| 213 |
infraspecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 202 |
cultivar,//taxonconcept/parent_id[rank=cultivar]/taxonepithet,
|
|
| 203 |
forma,//taxonconcept/parent_id[rank=forma]/taxonepithet,
|
|
| 204 |
variety,//taxonconcept/parent_id[rank=variety]/taxonepithet,
|
|
| 205 |
subspecies,//taxonconcept/parent_id[rank=subspecies]/taxonepithet,
|
|
| 206 |
specificEpithet,//taxonconcept/parent_id[rank=species]/taxonepithet,
|
|
| 207 |
genus,//taxonconcept/parent_id[rank=genus]/taxonepithet,
|
|
| 208 |
family,//taxonconcept/parent_id[rank=family]/taxonepithet,
|
|
| 209 |
order,//taxonconcept/parent_id[rank=order]/taxonepithet,
|
|
| 210 |
class,//taxonconcept/parent_id[rank=class]/taxonepithet,
|
|
| 211 |
phylum,//taxonconcept/parent_id[rank=phylum]/taxonepithet,
|
|
| 212 |
kingdom,//taxonconcept/parent_id[rank=kingdom]/taxonepithet,
|
|
| 213 |
infraspecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 214 | 214 |
taxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/rank, |
| 215 | 215 |
scientificNameID,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/sourceaccessioncode, |
| 216 | 216 |
taxonConceptID,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/sourceaccessioncode, |
| ... | ... | |
| 225 | 225 |
matchedSpeciesFit_fraction,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/matched_concept_fit_fraction, |
| 226 | 226 |
matchedTaxonFit_fraction,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/matched_concept_fit_fraction, |
| 227 | 227 |
verbatimSpecificEpithet,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/species, |
| 228 |
verbatimScientificNameWithAuthorship,"//taxonconcept/taxonname/_if[@name=""if has verbatim name""]/cond/_exists",
|
|
| 229 |
morphospecies,"//taxonconcept/taxonname/_if[@name=""if has verbatim name""]/then",
|
|
| 228 |
verbatimScientificNameWithAuthorship,"//taxonconcept/taxonepithet/_if[@name=""if has verbatim name""]/cond/_exists",
|
|
| 229 |
morphospecies,"//taxonconcept/taxonepithet/_if[@name=""if has verbatim name""]/then",
|
|
| 230 | 230 |
verbatimScientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/taxonomicname, |
| 231 | 231 |
verbatimTaxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonconcept/verbatimrank, |
| 232 |
taxonName,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonname,
|
|
| 233 |
verbatimScientificNameWithAuthorship,"//taxonconcept/taxonname/_if[@name=""if has verbatim name""]/cond/_exists",
|
|
| 234 |
morphospecies,"//taxonconcept/taxonname/_if[@name=""if has verbatim name""]/else",
|
|
| 232 |
taxonName,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonepithet,
|
|
| 233 |
verbatimScientificNameWithAuthorship,"//taxonconcept/taxonepithet/_if[@name=""if has verbatim name""]/cond/_exists",
|
|
| 234 |
morphospecies,"//taxonconcept/taxonepithet/_if[@name=""if has verbatim name""]/else",
|
|
| 235 | 235 |
scientificName,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonomicname, |
| 236 | 236 |
scientificNameWithAuthorship,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/taxonomicnamewithauthor, |
| 237 | 237 |
taxonRank,//taxonoccurrence/taxondetermination[]/*_id/taxonconcept/verbatimrank, |
| ... | ... | |
| 257 | 257 |
originalForma,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname, |
| 258 | 258 |
originalCultivar,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname, |
| 259 | 259 |
originalScientificNameAuthorship,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/matched_concept_id/taxonconcept/identifyingtaxonomicname, |
| 260 |
originalCultivar,//taxonconcept/parent_id[rank=cultivar]/taxonname,
|
|
| 261 |
originalForma,//taxonconcept/parent_id[rank=forma]/taxonname,
|
|
| 262 |
originalVariety,//taxonconcept/parent_id[rank=variety]/taxonname,
|
|
| 263 |
originalSubspecies,//taxonconcept/parent_id[rank=subspecies]/taxonname,
|
|
| 264 |
originalSpecificEpithet,//taxonconcept/parent_id[rank=species]/taxonname,
|
|
| 265 |
originalGenus,//taxonconcept/parent_id[rank=genus]/taxonname,
|
|
| 266 |
originalFamily,//taxonconcept/parent_id[rank=family]/taxonname,
|
|
| 267 |
originalOrder,//taxonconcept/parent_id[rank=order]/taxonname,
|
|
| 268 |
originalClass,//taxonconcept/parent_id[rank=class]/taxonname,
|
|
| 269 |
originalPhylum,//taxonconcept/parent_id[rank=phylum]/taxonname,
|
|
| 270 |
originalKingdom,//taxonconcept/parent_id[rank=kingdom]/taxonname,
|
|
| 260 |
originalCultivar,//taxonconcept/parent_id[rank=cultivar]/taxonepithet,
|
|
| 261 |
originalForma,//taxonconcept/parent_id[rank=forma]/taxonepithet,
|
|
| 262 |
originalVariety,//taxonconcept/parent_id[rank=variety]/taxonepithet,
|
|
| 263 |
originalSubspecies,//taxonconcept/parent_id[rank=subspecies]/taxonepithet,
|
|
| 264 |
originalSpecificEpithet,//taxonconcept/parent_id[rank=species]/taxonepithet,
|
|
| 265 |
originalGenus,//taxonconcept/parent_id[rank=genus]/taxonepithet,
|
|
| 266 |
originalFamily,//taxonconcept/parent_id[rank=family]/taxonepithet,
|
|
| 267 |
originalOrder,//taxonconcept/parent_id[rank=order]/taxonepithet,
|
|
| 268 |
originalClass,//taxonconcept/parent_id[rank=class]/taxonepithet,
|
|
| 269 |
originalPhylum,//taxonconcept/parent_id[rank=phylum]/taxonepithet,
|
|
| 270 |
originalKingdom,//taxonconcept/parent_id[rank=kingdom]/taxonepithet,
|
|
| 271 | 271 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/rank, |
| 272 |
originalInfraspecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 272 |
originalInfraspecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 273 | 273 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/parent_id/taxonconcept/verbatimrank, |
| 274 | 274 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/rank, |
| 275 | 275 |
originalSpecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonconcept/species, |
| inputs/ARIZ/Specimen/test.xml.ref | ||
|---|---|---|
| 171 | 171 |
<parent_id> |
| 172 | 172 |
<taxonconcept> |
| 173 | 173 |
<rank>subspecies</rank> |
| 174 |
<taxonname>$Subspecies</taxonname>
|
|
| 174 |
<taxonepithet>$Subspecies</taxonepithet>
|
|
| 175 | 175 |
<parent_id> |
| 176 | 176 |
<taxonconcept> |
| 177 | 177 |
<rank>species</rank> |
| 178 |
<taxonname>$Species</taxonname>
|
|
| 178 |
<taxonepithet>$Species</taxonepithet>
|
|
| 179 | 179 |
<parent_id> |
| 180 | 180 |
<taxonconcept> |
| 181 | 181 |
<rank>genus</rank> |
| 182 |
<taxonname>$Genus</taxonname>
|
|
| 182 |
<taxonepithet>$Genus</taxonepithet>
|
|
| 183 | 183 |
<parent_id> |
| 184 | 184 |
<taxonconcept> |
| 185 | 185 |
<rank>family</rank> |
| 186 |
<taxonname>$Family</taxonname>
|
|
| 186 |
<taxonepithet>$Family</taxonepithet>
|
|
| 187 | 187 |
<parent_id> |
| 188 | 188 |
<taxonconcept> |
| 189 | 189 |
<rank>order</rank> |
| 190 |
<taxonname>$Order</taxonname>
|
|
| 190 |
<taxonepithet>$Order</taxonepithet>
|
|
| 191 | 191 |
<parent_id> |
| 192 | 192 |
<taxonconcept> |
| 193 | 193 |
<rank>class</rank> |
| 194 |
<taxonname>$Class</taxonname>
|
|
| 194 |
<taxonepithet>$Class</taxonepithet>
|
|
| 195 | 195 |
<parent_id> |
| 196 | 196 |
<taxonconcept> |
| 197 | 197 |
<rank>phylum</rank> |
| 198 |
<taxonname>$Phylum</taxonname>
|
|
| 198 |
<taxonepithet>$Phylum</taxonepithet>
|
|
| 199 | 199 |
<parent_id> |
| 200 | 200 |
<taxonconcept> |
| 201 | 201 |
<rank>kingdom</rank> |
| 202 |
<taxonname>$Kingdom</taxonname>
|
|
| 202 |
<taxonepithet>$Kingdom</taxonepithet>
|
|
| 203 | 203 |
</taxonconcept> |
| 204 | 204 |
</parent_id> |
| 205 | 205 |
</taxonconcept> |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 140 | 140 |
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 141 | 141 |
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 142 | 142 |
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 143 |
conceptual_darwin_2003_1_0_Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname",
|
|
| 144 |
conceptual_darwin_2003_1_0_Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 145 |
dwc_dwcore_SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 146 |
dwc_terms_specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 147 |
conceptual_darwin_2003_1_0_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 148 |
dwc_dwcore_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 149 |
dwc_terms_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 150 |
conceptual_darwin_2003_1_0_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 151 |
dwc_dwcore_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 152 |
dwc_terms_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 153 |
conceptual_darwin_2003_1_0_Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 154 |
dwc_dwcore_Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 155 |
dwc_terms_order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 156 |
conceptual_darwin_2003_1_0_Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 157 |
dwc_dwcore_Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 158 |
dwc_terms_class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 159 |
conceptual_darwin_2003_1_0_Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
|
|
| 160 |
dwc_dwcore_Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
|
|
| 161 |
dwc_terms_phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
|
|
| 162 |
conceptual_darwin_2003_1_0_Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 163 |
dwc_dwcore_Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 164 |
dwc_terms_kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 165 |
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 166 |
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 143 |
conceptual_darwin_2003_1_0_Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonepithet",
|
|
| 144 |
conceptual_darwin_2003_1_0_Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 145 |
dwc_dwcore_SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 146 |
dwc_terms_specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 147 |
conceptual_darwin_2003_1_0_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 148 |
dwc_dwcore_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 149 |
dwc_terms_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 150 |
conceptual_darwin_2003_1_0_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 151 |
dwc_dwcore_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 152 |
dwc_terms_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 153 |
conceptual_darwin_2003_1_0_Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 154 |
dwc_dwcore_Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 155 |
dwc_terms_order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 156 |
conceptual_darwin_2003_1_0_Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 157 |
dwc_dwcore_Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 158 |
dwc_terms_class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 159 |
conceptual_darwin_2003_1_0_Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
|
|
| 160 |
dwc_dwcore_Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
|
|
| 161 |
dwc_terms_phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
|
|
| 162 |
conceptual_darwin_2003_1_0_Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 163 |
dwc_dwcore_Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 164 |
dwc_terms_kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 165 |
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 166 |
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 167 | 167 |
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 168 | 168 |
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 169 | 169 |
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| inputs/MO/Specimen/test.xml.ref | ||
|---|---|---|
| 144 | 144 |
<parent_id> |
| 145 | 145 |
<taxonconcept> |
| 146 | 146 |
<rank>subspecies</rank> |
| 147 |
<taxonname>$Subspecies</taxonname>
|
|
| 147 |
<taxonepithet>$Subspecies</taxonepithet>
|
|
| 148 | 148 |
<parent_id> |
| 149 | 149 |
<taxonconcept> |
| 150 | 150 |
<rank>species</rank> |
| 151 |
<taxonname>$species</taxonname>
|
|
| 151 |
<taxonepithet>$species</taxonepithet>
|
|
| 152 | 152 |
<parent_id> |
| 153 | 153 |
<taxonconcept> |
| 154 | 154 |
<rank>genus</rank> |
| 155 |
<taxonname>$genus</taxonname>
|
|
| 155 |
<taxonepithet>$genus</taxonepithet>
|
|
| 156 | 156 |
<parent_id> |
| 157 | 157 |
<taxonconcept> |
| 158 | 158 |
<rank>family</rank> |
| 159 |
<taxonname>$family</taxonname>
|
|
| 159 |
<taxonepithet>$family</taxonepithet>
|
|
| 160 | 160 |
<parent_id> |
| 161 | 161 |
<taxonconcept> |
| 162 | 162 |
<rank>order</rank> |
| ... | ... | |
| 169 | 169 |
<parent_id> |
| 170 | 170 |
<taxonconcept> |
| 171 | 171 |
<rank>kingdom</rank> |
| 172 |
<taxonname>$Kingdom</taxonname>
|
|
| 172 |
<taxonepithet>$Kingdom</taxonepithet>
|
|
| 173 | 173 |
</taxonconcept> |
| 174 | 174 |
</parent_id> |
| 175 | 175 |
</taxonconcept> |
| inputs/QMOR/Specimen/VegBIEN.csv | ||
|---|---|---|
| 45 | 45 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 46 | 46 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/rank", |
| 47 | 47 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/_if[@name=""if has explicit parent""]/else/verbatimrank", |
| 48 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname",
|
|
| 49 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname",
|
|
| 50 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname",
|
|
| 51 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname",
|
|
| 52 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname",
|
|
| 53 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname",
|
|
| 54 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname",
|
|
| 55 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonname,
|
|
| 48 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonepithet",
|
|
| 49 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonepithet",
|
|
| 50 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonepithet",
|
|
| 51 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonepithet",
|
|
| 52 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonepithet",
|
|
| 53 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonepithet",
|
|
| 54 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonepithet",
|
|
| 55 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/taxonconcept/taxonepithet,
|
|
| 56 | 56 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 57 | 57 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 58 | 58 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| schemas/vegbien.sql | ||
|---|---|---|
| 502 | 502 |
matched_concept_id integer, |
| 503 | 503 |
matched_concept_fit_fraction double precision, |
| 504 | 504 |
parent_id integer, |
| 505 |
taxonname text,
|
|
| 505 |
taxonepithet text,
|
|
| 506 | 506 |
rank taxonrank, |
| 507 | 507 |
verbatimrank text, |
| 508 | 508 |
identifyingtaxonomicname text, |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Renamed taxonname to taxonepithet for clarity and to be consistent with TCS's use of "epithet" to denote what the taxonname was intended to be (http://www.tdwg.org/standards/117/download/#/UserGuidev_1.3.pdf)