Revision 5294
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 98 | 98 |
</creator_id> |
| 99 | 99 |
<family>$Family</family> |
| 100 | 100 |
<genus>$Genus</genus> |
| 101 |
<parent_id> |
|
| 102 |
<taxonconcept> |
|
| 103 |
<rank>cultivar</rank> |
|
| 104 |
<parent_id> |
|
| 105 |
<taxonconcept> |
|
| 106 |
<rank>forma</rank> |
|
| 107 |
<parent_id> |
|
| 108 |
<taxonconcept> |
|
| 109 |
<rank>variety</rank> |
|
| 110 |
<parent_id> |
|
| 111 |
<taxonconcept> |
|
| 112 |
<rank>subspecies</rank> |
|
| 113 |
<parent_id> |
|
| 114 |
<taxonconcept> |
|
| 115 |
<rank>species</rank> |
|
| 116 |
<taxonname>$SpecificEpithet</taxonname> |
|
| 117 |
<parent_id> |
|
| 118 |
<taxonconcept> |
|
| 119 |
<rank>genus</rank> |
|
| 120 |
<taxonname>$Genus</taxonname> |
|
| 121 |
<parent_id> |
|
| 122 |
<taxonconcept> |
|
| 123 |
<rank>family</rank> |
|
| 124 |
<taxonname>$Family</taxonname> |
|
| 125 |
</taxonconcept> |
|
| 126 |
</parent_id> |
|
| 127 |
</taxonconcept> |
|
| 128 |
</parent_id> |
|
| 129 |
</taxonconcept> |
|
| 130 |
</parent_id> |
|
| 131 |
</taxonconcept> |
|
| 132 |
</parent_id> |
|
| 133 |
</taxonconcept> |
|
| 134 |
</parent_id> |
|
| 135 |
</taxonconcept> |
|
| 136 |
</parent_id> |
|
| 137 |
</taxonconcept> |
|
| 138 |
</parent_id> |
|
| 101 | 139 |
<species>$SpecificEpithet</species> |
| 102 | 140 |
<taxonname>$InfraspecificEpithet</taxonname> |
| 103 | 141 |
<taxonomicname>$ScientificName</taxonomicname> |
| ... | ... | |
| 152 | 190 |
</path> |
| 153 | 191 |
</_simplifyPath> |
| 154 | 192 |
</VegBIEN> |
| 155 |
Inserted 33 new rows into database |
|
| 193 |
Inserted 37 new rows into database |
|
| inputs/MO/Specimen/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 23 | 23 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 24 | 24 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 25 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 26 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 27 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 28 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 29 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
|
| 30 | 25 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 31 | 26 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 32 | 27 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| ... | ... | |
| 40 | 35 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 41 | 36 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 42 | 37 |
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom, |
| 38 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 39 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 40 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 41 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 42 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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 | 43 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 44 | 44 |
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies, |
| 45 | 45 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| inputs/VegBank/taxonobservation_/test.xml.ref | ||
|---|---|---|
| 54 | 54 |
<genus>$Genus</genus> |
| 55 | 55 |
<kingdom>$Kingdom</kingdom> |
| 56 | 56 |
<order>$Order</order> |
| 57 |
<parent_id> |
|
| 58 |
<taxonconcept> |
|
| 59 |
<rank>cultivar</rank> |
|
| 60 |
<parent_id> |
|
| 61 |
<taxonconcept> |
|
| 62 |
<rank>forma</rank> |
|
| 63 |
<taxonname>$Forma</taxonname> |
|
| 64 |
<parent_id> |
|
| 65 |
<taxonconcept> |
|
| 66 |
<rank>variety</rank> |
|
| 67 |
<taxonname>$Variety</taxonname> |
|
| 68 |
<parent_id> |
|
| 69 |
<taxonconcept> |
|
| 70 |
<rank>subspecies</rank> |
|
| 71 |
<taxonname>$Subspecies</taxonname> |
|
| 72 |
<parent_id> |
|
| 73 |
<taxonconcept> |
|
| 74 |
<rank>species</rank> |
|
| 75 |
<taxonname>$Species</taxonname> |
|
| 76 |
<parent_id> |
|
| 77 |
<taxonconcept> |
|
| 78 |
<rank>genus</rank> |
|
| 79 |
<taxonname>$Genus</taxonname> |
|
| 80 |
<parent_id> |
|
| 81 |
<taxonconcept> |
|
| 82 |
<rank>family</rank> |
|
| 83 |
<taxonname>$Family</taxonname> |
|
| 84 |
<parent_id> |
|
| 85 |
<taxonconcept> |
|
| 86 |
<rank>order</rank> |
|
| 87 |
<taxonname>$Order</taxonname> |
|
| 88 |
<parent_id> |
|
| 89 |
<taxonconcept> |
|
| 90 |
<rank>class</rank> |
|
| 91 |
<taxonname>$Class</taxonname> |
|
| 92 |
<parent_id> |
|
| 93 |
<taxonconcept> |
|
| 94 |
<rank>phylum</rank> |
|
| 95 |
<parent_id> |
|
| 96 |
<taxonconcept> |
|
| 97 |
<rank>kingdom</rank> |
|
| 98 |
<taxonname>$Kingdom</taxonname> |
|
| 99 |
</taxonconcept> |
|
| 100 |
</parent_id> |
|
| 101 |
</taxonconcept> |
|
| 102 |
</parent_id> |
|
| 103 |
</taxonconcept> |
|
| 104 |
</parent_id> |
|
| 105 |
</taxonconcept> |
|
| 106 |
</parent_id> |
|
| 107 |
</taxonconcept> |
|
| 108 |
</parent_id> |
|
| 109 |
</taxonconcept> |
|
| 110 |
</parent_id> |
|
| 111 |
</taxonconcept> |
|
| 112 |
</parent_id> |
|
| 113 |
</taxonconcept> |
|
| 114 |
</parent_id> |
|
| 115 |
</taxonconcept> |
|
| 116 |
</parent_id> |
|
| 117 |
</taxonconcept> |
|
| 118 |
</parent_id> |
|
| 119 |
</taxonconcept> |
|
| 120 |
</parent_id> |
|
| 57 | 121 |
<species>$Species</species> |
| 58 | 122 |
<subspecies>$Subspecies</subspecies> |
| 59 | 123 |
<variety>$Variety</variety> |
| ... | ... | |
| 87 | 151 |
</path> |
| 88 | 152 |
</_simplifyPath> |
| 89 | 153 |
</VegBIEN> |
| 90 |
Inserted 23 new rows into database |
|
| 154 |
Inserted 34 new rows into database |
|
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value", |
| 12 | 12 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 13 | 13 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 14 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 15 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 16 | 14 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 17 | 15 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 18 | 16 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 19 | 17 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 18 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 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 | ||
|---|---|---|
| 60 | 60 |
</canon_taxonconcept_id> |
| 61 | 61 |
<family>$family</family> |
| 62 | 62 |
<genus>$genus</genus> |
| 63 |
<parent_id> |
|
| 64 |
<taxonconcept> |
|
| 65 |
<rank>cultivar</rank> |
|
| 66 |
<parent_id> |
|
| 67 |
<taxonconcept> |
|
| 68 |
<rank>forma</rank> |
|
| 69 |
<parent_id> |
|
| 70 |
<taxonconcept> |
|
| 71 |
<rank>variety</rank> |
|
| 72 |
<parent_id> |
|
| 73 |
<taxonconcept> |
|
| 74 |
<rank>subspecies</rank> |
|
| 75 |
<parent_id> |
|
| 76 |
<taxonconcept> |
|
| 77 |
<rank>species</rank> |
|
| 78 |
<parent_id> |
|
| 79 |
<taxonconcept> |
|
| 80 |
<rank>genus</rank> |
|
| 81 |
<taxonname>$genus</taxonname> |
|
| 82 |
<parent_id> |
|
| 83 |
<taxonconcept> |
|
| 84 |
<rank>family</rank> |
|
| 85 |
<taxonname>$family</taxonname> |
|
| 86 |
</taxonconcept> |
|
| 87 |
</parent_id> |
|
| 88 |
</taxonconcept> |
|
| 89 |
</parent_id> |
|
| 90 |
</taxonconcept> |
|
| 91 |
</parent_id> |
|
| 92 |
</taxonconcept> |
|
| 93 |
</parent_id> |
|
| 94 |
</taxonconcept> |
|
| 95 |
</parent_id> |
|
| 96 |
</taxonconcept> |
|
| 97 |
</parent_id> |
|
| 98 |
</taxonconcept> |
|
| 99 |
</parent_id> |
|
| 63 | 100 |
</taxonconcept> |
| 64 | 101 |
</taxonconcept_id> |
| 65 | 102 |
</taxondetermination> |
| ... | ... | |
| 71 | 108 |
</path> |
| 72 | 109 |
</_simplifyPath> |
| 73 | 110 |
</VegBIEN> |
| 74 |
Inserted 22 new rows into database |
|
| 111 |
Inserted 24 new rows into database |
|
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 24 | 24 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 25 | 25 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 26 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 27 |
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 28 |
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 29 |
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 30 |
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 31 |
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 32 |
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname", |
|
| 33 |
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
|
| 34 | 26 |
darwin:ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 35 | 27 |
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 36 | 28 |
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| ... | ... | |
| 46 | 38 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 47 | 39 |
darwin:Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom, |
| 48 | 40 |
darwin:Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order, |
| 41 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 42 |
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 43 |
darwin:Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 44 |
darwin:Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 45 |
darwin:Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 46 |
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 47 |
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 48 |
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 49 | 49 |
darwin:Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/phylum, |
| 50 | 50 |
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 51 | 51 |
darwin:Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies, |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 21 | 21 |
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 22 | 22 |
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 23 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 25 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 26 | 23 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 27 | 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 28 | 25 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 29 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 30 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 28 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 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 | ||
|---|---|---|
| 63 | 63 |
</canon_taxonconcept_id> |
| 64 | 64 |
<family>$Family</family> |
| 65 | 65 |
<genus>$Genus</genus> |
| 66 |
<parent_id> |
|
| 67 |
<taxonconcept> |
|
| 68 |
<rank>cultivar</rank> |
|
| 69 |
<parent_id> |
|
| 70 |
<taxonconcept> |
|
| 71 |
<rank>forma</rank> |
|
| 72 |
<parent_id> |
|
| 73 |
<taxonconcept> |
|
| 74 |
<rank>variety</rank> |
|
| 75 |
<parent_id> |
|
| 76 |
<taxonconcept> |
|
| 77 |
<rank>subspecies</rank> |
|
| 78 |
<parent_id> |
|
| 79 |
<taxonconcept> |
|
| 80 |
<rank>species</rank> |
|
| 81 |
<taxonname>$Species</taxonname> |
|
| 82 |
<parent_id> |
|
| 83 |
<taxonconcept> |
|
| 84 |
<rank>genus</rank> |
|
| 85 |
<taxonname>$Genus</taxonname> |
|
| 86 |
<parent_id> |
|
| 87 |
<taxonconcept> |
|
| 88 |
<rank>family</rank> |
|
| 89 |
<taxonname>$Family</taxonname> |
|
| 90 |
</taxonconcept> |
|
| 91 |
</parent_id> |
|
| 92 |
</taxonconcept> |
|
| 93 |
</parent_id> |
|
| 94 |
</taxonconcept> |
|
| 95 |
</parent_id> |
|
| 96 |
</taxonconcept> |
|
| 97 |
</parent_id> |
|
| 98 |
</taxonconcept> |
|
| 99 |
</parent_id> |
|
| 100 |
</taxonconcept> |
|
| 101 |
</parent_id> |
|
| 102 |
</taxonconcept> |
|
| 103 |
</parent_id> |
|
| 66 | 104 |
<species>$Species</species> |
| 67 | 105 |
</taxonconcept> |
| 68 | 106 |
</taxonconcept_id> |
| ... | ... | |
| 74 | 112 |
</path> |
| 75 | 113 |
</_simplifyPath> |
| 76 | 114 |
</VegBIEN> |
| 77 |
Inserted 26 new rows into database |
|
| 115 |
Inserted 32 new rows into database |
|
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 20 | 20 |
1ha Plot Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 21 | 21 |
Tree Number,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 22 | 22 |
Id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 23 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 25 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 26 | 23 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 27 | 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 28 | 25 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 29 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 30 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 28 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 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 | ||
|---|---|---|
| 63 | 63 |
</canon_taxonconcept_id> |
| 64 | 64 |
<family>$Family</family> |
| 65 | 65 |
<genus>$Genus</genus> |
| 66 |
<parent_id> |
|
| 67 |
<taxonconcept> |
|
| 68 |
<rank>cultivar</rank> |
|
| 69 |
<parent_id> |
|
| 70 |
<taxonconcept> |
|
| 71 |
<rank>forma</rank> |
|
| 72 |
<parent_id> |
|
| 73 |
<taxonconcept> |
|
| 74 |
<rank>variety</rank> |
|
| 75 |
<parent_id> |
|
| 76 |
<taxonconcept> |
|
| 77 |
<rank>subspecies</rank> |
|
| 78 |
<parent_id> |
|
| 79 |
<taxonconcept> |
|
| 80 |
<rank>species</rank> |
|
| 81 |
<taxonname>$Species</taxonname> |
|
| 82 |
<parent_id> |
|
| 83 |
<taxonconcept> |
|
| 84 |
<rank>genus</rank> |
|
| 85 |
<taxonname>$Genus</taxonname> |
|
| 86 |
<parent_id> |
|
| 87 |
<taxonconcept> |
|
| 88 |
<rank>family</rank> |
|
| 89 |
<taxonname>$Family</taxonname> |
|
| 90 |
</taxonconcept> |
|
| 91 |
</parent_id> |
|
| 92 |
</taxonconcept> |
|
| 93 |
</parent_id> |
|
| 94 |
</taxonconcept> |
|
| 95 |
</parent_id> |
|
| 96 |
</taxonconcept> |
|
| 97 |
</parent_id> |
|
| 98 |
</taxonconcept> |
|
| 99 |
</parent_id> |
|
| 100 |
</taxonconcept> |
|
| 101 |
</parent_id> |
|
| 102 |
</taxonconcept> |
|
| 103 |
</parent_id> |
|
| 66 | 104 |
<species>$Species</species> |
| 67 | 105 |
</taxonconcept> |
| 68 | 106 |
</taxonconcept_id> |
| ... | ... | |
| 74 | 112 |
</path> |
| 75 | 113 |
</_simplifyPath> |
| 76 | 114 |
</VegBIEN> |
| 77 |
Inserted 23 new rows into database |
|
| 115 |
Inserted 29 new rows into database |
|
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 29 | 29 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 30 | 30 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 31 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 32 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/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/_if[@name=""if has verbatim name""]/then/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/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 35 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 36 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 37 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname", |
|
| 38 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
|
| 39 | 31 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 40 | 32 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 41 | 33 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| ... | ... | |
| 51 | 43 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 52 | 44 |
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom, |
| 53 | 45 |
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order, |
| 46 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_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/_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/_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/_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
|
| 54 | 54 |
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/phylum, |
| 55 | 55 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 56 | 56 |
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies, |
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 161 | 161 |
<genus>$Genus</genus> |
| 162 | 162 |
<kingdom>$Kingdom</kingdom> |
| 163 | 163 |
<order>$Order</order> |
| 164 |
<parent_id> |
|
| 165 |
<taxonconcept> |
|
| 166 |
<rank>cultivar</rank> |
|
| 167 |
<parent_id> |
|
| 168 |
<taxonconcept> |
|
| 169 |
<rank>forma</rank> |
|
| 170 |
<parent_id> |
|
| 171 |
<taxonconcept> |
|
| 172 |
<rank>variety</rank> |
|
| 173 |
<parent_id> |
|
| 174 |
<taxonconcept> |
|
| 175 |
<rank>subspecies</rank> |
|
| 176 |
<taxonname>$Subspecies</taxonname> |
|
| 177 |
<parent_id> |
|
| 178 |
<taxonconcept> |
|
| 179 |
<rank>species</rank> |
|
| 180 |
<taxonname>$Species</taxonname> |
|
| 181 |
<parent_id> |
|
| 182 |
<taxonconcept> |
|
| 183 |
<rank>genus</rank> |
|
| 184 |
<taxonname>$Genus</taxonname> |
|
| 185 |
<parent_id> |
|
| 186 |
<taxonconcept> |
|
| 187 |
<rank>family</rank> |
|
| 188 |
<taxonname>$Family</taxonname> |
|
| 189 |
<parent_id> |
|
| 190 |
<taxonconcept> |
|
| 191 |
<rank>order</rank> |
|
| 192 |
<taxonname>$Order</taxonname> |
|
| 193 |
<parent_id> |
|
| 194 |
<taxonconcept> |
|
| 195 |
<rank>class</rank> |
|
| 196 |
<taxonname>$Class</taxonname> |
|
| 197 |
<parent_id> |
|
| 198 |
<taxonconcept> |
|
| 199 |
<rank>phylum</rank> |
|
| 200 |
<taxonname>$Phylum</taxonname> |
|
| 201 |
<parent_id> |
|
| 202 |
<taxonconcept> |
|
| 203 |
<rank>kingdom</rank> |
|
| 204 |
<taxonname>$Kingdom</taxonname> |
|
| 205 |
</taxonconcept> |
|
| 206 |
</parent_id> |
|
| 207 |
</taxonconcept> |
|
| 208 |
</parent_id> |
|
| 209 |
</taxonconcept> |
|
| 210 |
</parent_id> |
|
| 211 |
</taxonconcept> |
|
| 212 |
</parent_id> |
|
| 213 |
</taxonconcept> |
|
| 214 |
</parent_id> |
|
| 215 |
</taxonconcept> |
|
| 216 |
</parent_id> |
|
| 217 |
</taxonconcept> |
|
| 218 |
</parent_id> |
|
| 219 |
</taxonconcept> |
|
| 220 |
</parent_id> |
|
| 221 |
</taxonconcept> |
|
| 222 |
</parent_id> |
|
| 223 |
</taxonconcept> |
|
| 224 |
</parent_id> |
|
| 225 |
</taxonconcept> |
|
| 226 |
</parent_id> |
|
| 164 | 227 |
<phylum>$Phylum</phylum> |
| 165 | 228 |
<species>$Species</species> |
| 166 | 229 |
<subspecies>$Subspecies</subspecies> |
| ... | ... | |
| 243 | 306 |
</path> |
| 244 | 307 |
</_simplifyPath> |
| 245 | 308 |
</VegBIEN> |
| 246 |
Inserted 29 new rows into database |
|
| 309 |
Inserted 35 new rows into database |
|
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 32 | 32 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 33 | 33 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 34 | 34 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 35 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 36 |
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 37 |
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 38 | 35 |
Specie+autor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
|
| 39 | 36 |
Species and morphotypes,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1","Contains less than ""Specie+autor"""
|
| 40 | 37 |
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| ... | ... | |
| 47 | 44 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 48 | 45 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 49 | 46 |
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 47 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 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, |
| inputs/Madidi/Organism/test.xml.ref | ||
|---|---|---|
| 117 | 117 |
</creator_id> |
| 118 | 118 |
<family>$Family (revised)</family> |
| 119 | 119 |
<genus>$Genera</genus> |
| 120 |
<parent_id> |
|
| 121 |
<taxonconcept> |
|
| 122 |
<rank>cultivar</rank> |
|
| 123 |
<parent_id> |
|
| 124 |
<taxonconcept> |
|
| 125 |
<rank>forma</rank> |
|
| 126 |
<parent_id> |
|
| 127 |
<taxonconcept> |
|
| 128 |
<rank>variety</rank> |
|
| 129 |
<parent_id> |
|
| 130 |
<taxonconcept> |
|
| 131 |
<rank>subspecies</rank> |
|
| 132 |
<parent_id> |
|
| 133 |
<taxonconcept> |
|
| 134 |
<rank>species</rank> |
|
| 135 |
<taxonname>$Specific epithet</taxonname> |
|
| 136 |
<parent_id> |
|
| 137 |
<taxonconcept> |
|
| 138 |
<rank>genus</rank> |
|
| 139 |
<taxonname>$Genera</taxonname> |
|
| 140 |
<parent_id> |
|
| 141 |
<taxonconcept> |
|
| 142 |
<rank>family</rank> |
|
| 143 |
<taxonname>$Family (revised)</taxonname> |
|
| 144 |
</taxonconcept> |
|
| 145 |
</parent_id> |
|
| 146 |
</taxonconcept> |
|
| 147 |
</parent_id> |
|
| 148 |
</taxonconcept> |
|
| 149 |
</parent_id> |
|
| 150 |
</taxonconcept> |
|
| 151 |
</parent_id> |
|
| 152 |
</taxonconcept> |
|
| 153 |
</parent_id> |
|
| 154 |
</taxonconcept> |
|
| 155 |
</parent_id> |
|
| 156 |
</taxonconcept> |
|
| 157 |
</parent_id> |
|
| 120 | 158 |
<species>$Specific epithet</species> |
| 121 | 159 |
<taxonomicname>$Species and morphotypes</taxonomicname> |
| 122 | 160 |
<taxonomicnamewithauthor>$Specie+autor</taxonomicnamewithauthor> |
| ... | ... | |
| 156 | 194 |
</path> |
| 157 | 195 |
</_simplifyPath> |
| 158 | 196 |
</VegBIEN> |
| 159 |
Inserted 32 new rows into database |
|
| 197 |
Inserted 38 new rows into database |
|
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 42 | 42 |
GROUP BY herbarium, accession |
| 43 | 43 |
HAVING count(*) > 1 |
| 44 | 44 |
-----" |
| 45 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 46 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 47 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 48 | 45 |
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 49 | 46 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 50 | 47 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| ... | ... | |
| 57 | 54 |
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author, |
| 58 | 55 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 59 | 56 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 57 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 58 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 59 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 60 | 60 |
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank/_alt/1, |
| 61 | 61 |
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank/_alt/2, |
| 62 | 62 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 118 | 118 |
<author>$authors</author> |
| 119 | 119 |
<family>$family</family> |
| 120 | 120 |
<genus>$genus</genus> |
| 121 |
<parent_id> |
|
| 122 |
<taxonconcept> |
|
| 123 |
<rank>cultivar</rank> |
|
| 124 |
<parent_id> |
|
| 125 |
<taxonconcept> |
|
| 126 |
<rank>forma</rank> |
|
| 127 |
<parent_id> |
|
| 128 |
<taxonconcept> |
|
| 129 |
<rank>variety</rank> |
|
| 130 |
<parent_id> |
|
| 131 |
<taxonconcept> |
|
| 132 |
<rank>subspecies</rank> |
|
| 133 |
<parent_id> |
|
| 134 |
<taxonconcept> |
|
| 135 |
<rank>species</rank> |
|
| 136 |
<taxonname>$species</taxonname> |
|
| 137 |
<parent_id> |
|
| 138 |
<taxonconcept> |
|
| 139 |
<rank>genus</rank> |
|
| 140 |
<taxonname>$genus</taxonname> |
|
| 141 |
<parent_id> |
|
| 142 |
<taxonconcept> |
|
| 143 |
<rank>family</rank> |
|
| 144 |
<taxonname>$family</taxonname> |
|
| 145 |
</taxonconcept> |
|
| 146 |
</parent_id> |
|
| 147 |
</taxonconcept> |
|
| 148 |
</parent_id> |
|
| 149 |
</taxonconcept> |
|
| 150 |
</parent_id> |
|
| 151 |
</taxonconcept> |
|
| 152 |
</parent_id> |
|
| 153 |
</taxonconcept> |
|
| 154 |
</parent_id> |
|
| 155 |
</taxonconcept> |
|
| 156 |
</parent_id> |
|
| 157 |
</taxonconcept> |
|
| 158 |
</parent_id> |
|
| 121 | 159 |
<rank> |
| 122 | 160 |
<_alt> |
| 123 | 161 |
<1>$usdaRank</1> |
| ... | ... | |
| 170 | 208 |
</path> |
| 171 | 209 |
</_simplifyPath> |
| 172 | 210 |
</VegBIEN> |
| 173 |
Inserted 22 new rows into database |
|
| 211 |
Inserted 23 new rows into database |
|
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 22 | 22 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 23 | 23 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 24 | 24 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 25 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 26 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/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/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 28 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 29 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 30 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname", |
|
| 31 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
|
| 32 | 25 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
|
| 33 | 26 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 34 | 27 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| ... | ... | |
| 46 | 39 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 47 | 40 |
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom, |
| 48 | 41 |
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order, |
| 42 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 43 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 44 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 45 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 46 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 47 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 48 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 49 | 49 |
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/phylum, |
| 50 | 50 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 51 | 51 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 131 | 131 |
<genus>$genus</genus> |
| 132 | 132 |
<kingdom>$kingdom</kingdom> |
| 133 | 133 |
<order>$order</order> |
| 134 |
<parent_id> |
|
| 135 |
<taxonconcept> |
|
| 136 |
<rank>cultivar</rank> |
|
| 137 |
<parent_id> |
|
| 138 |
<taxonconcept> |
|
| 139 |
<rank>forma</rank> |
|
| 140 |
<parent_id> |
|
| 141 |
<taxonconcept> |
|
| 142 |
<rank>variety</rank> |
|
| 143 |
<parent_id> |
|
| 144 |
<taxonconcept> |
|
| 145 |
<rank>subspecies</rank> |
|
| 146 |
<parent_id> |
|
| 147 |
<taxonconcept> |
|
| 148 |
<rank>species</rank> |
|
| 149 |
<taxonname>$specificEpithet</taxonname> |
|
| 150 |
<parent_id> |
|
| 151 |
<taxonconcept> |
|
| 152 |
<rank>genus</rank> |
|
| 153 |
<taxonname>$genus</taxonname> |
|
| 154 |
<parent_id> |
|
| 155 |
<taxonconcept> |
|
| 156 |
<rank>family</rank> |
|
| 157 |
<taxonname>$family</taxonname> |
|
| 158 |
<parent_id> |
|
| 159 |
<taxonconcept> |
|
| 160 |
<rank>order</rank> |
|
| 161 |
<taxonname>$order</taxonname> |
|
| 162 |
<parent_id> |
|
| 163 |
<taxonconcept> |
|
| 164 |
<rank>class</rank> |
|
| 165 |
<taxonname>$class</taxonname> |
|
| 166 |
<parent_id> |
|
| 167 |
<taxonconcept> |
|
| 168 |
<rank>phylum</rank> |
|
| 169 |
<taxonname>$phylum</taxonname> |
|
| 170 |
<parent_id> |
|
| 171 |
<taxonconcept> |
|
| 172 |
<rank>kingdom</rank> |
|
| 173 |
<taxonname>$kingdom</taxonname> |
|
| 174 |
</taxonconcept> |
|
| 175 |
</parent_id> |
|
| 176 |
</taxonconcept> |
|
| 177 |
</parent_id> |
|
| 178 |
</taxonconcept> |
|
| 179 |
</parent_id> |
|
| 180 |
</taxonconcept> |
|
| 181 |
</parent_id> |
|
| 182 |
</taxonconcept> |
|
| 183 |
</parent_id> |
|
| 184 |
</taxonconcept> |
|
| 185 |
</parent_id> |
|
| 186 |
</taxonconcept> |
|
| 187 |
</parent_id> |
|
| 188 |
</taxonconcept> |
|
| 189 |
</parent_id> |
|
| 190 |
</taxonconcept> |
|
| 191 |
</parent_id> |
|
| 192 |
</taxonconcept> |
|
| 193 |
</parent_id> |
|
| 194 |
</taxonconcept> |
|
| 195 |
</parent_id> |
|
| 134 | 196 |
<phylum>$phylum</phylum> |
| 135 | 197 |
<rank>$taxonRank</rank> |
| 136 | 198 |
<species>$specificEpithet</species> |
| ... | ... | |
| 170 | 232 |
</path> |
| 171 | 233 |
</_simplifyPath> |
| 172 | 234 |
</VegBIEN> |
| 173 |
Inserted 27 new rows into database |
|
| 235 |
Inserted 34 new rows into database |
|
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 64 | 64 |
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_alt/2/_alt/2","The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
| 65 | 65 |
habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""HemiepÃfito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
|
| 66 | 66 |
OBSERVATION_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 67 |
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 68 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 69 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 70 | 67 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 71 | 68 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 72 | 69 |
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| ... | ... | |
| 77 | 74 |
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Brad: This is the author of the scientificName. |
| 78 | 75 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 79 | 76 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 77 |
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 78 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 79 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 80 | 80 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 81 | 81 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 82 | 82 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1, |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 183 | 183 |
<author>$specific_authority</author> |
| 184 | 184 |
<family>$family</family> |
| 185 | 185 |
<genus>$genus</genus> |
| 186 |
<parent_id> |
|
| 187 |
<taxonconcept> |
|
| 188 |
<rank>cultivar</rank> |
|
| 189 |
<parent_id> |
|
| 190 |
<taxonconcept> |
|
| 191 |
<rank>forma</rank> |
|
| 192 |
<parent_id> |
|
| 193 |
<taxonconcept> |
|
| 194 |
<rank>variety</rank> |
|
| 195 |
<parent_id> |
|
| 196 |
<taxonconcept> |
|
| 197 |
<rank>subspecies</rank> |
|
| 198 |
<parent_id> |
|
| 199 |
<taxonconcept> |
|
| 200 |
<rank>species</rank> |
|
| 201 |
<taxonname>$specific_epithet</taxonname> |
|
| 202 |
<parent_id> |
|
| 203 |
<taxonconcept> |
|
| 204 |
<rank>genus</rank> |
|
| 205 |
<taxonname>$genus</taxonname> |
|
| 206 |
<parent_id> |
|
| 207 |
<taxonconcept> |
|
| 208 |
<rank>family</rank> |
|
| 209 |
<taxonname>$family</taxonname> |
|
| 210 |
</taxonconcept> |
|
| 211 |
</parent_id> |
|
| 212 |
</taxonconcept> |
|
| 213 |
</parent_id> |
|
| 214 |
</taxonconcept> |
|
| 215 |
</parent_id> |
|
| 216 |
</taxonconcept> |
|
| 217 |
</parent_id> |
|
| 218 |
</taxonconcept> |
|
| 219 |
</parent_id> |
|
| 220 |
</taxonconcept> |
|
| 221 |
</parent_id> |
|
| 222 |
</taxonconcept> |
|
| 223 |
</parent_id> |
|
| 186 | 224 |
<rank>$infra_rank_1</rank> |
| 187 | 225 |
<species>$specific_epithet</species> |
| 188 | 226 |
<taxonname>$infra_ep_1</taxonname> |
| ... | ... | |
| 250 | 288 |
</path> |
| 251 | 289 |
</_simplifyPath> |
| 252 | 290 |
</VegBIEN> |
| 253 |
Inserted 42 new rows into database |
|
| 291 |
Inserted 48 new rows into database |
|
| inputs/REMIB/Specimen/VegBIEN.csv | ||
|---|---|---|
| 33 | 33 |
HAVING count(*) > 1 |
| 34 | 34 |
-----" |
| 35 | 35 |
acronym,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 36 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 37 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 38 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 39 | 36 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 40 | 37 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 41 | 38 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 42 | 39 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 43 | 40 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 41 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 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 | ||
|---|---|---|
| 83 | 83 |
</canon_taxonconcept_id> |
| 84 | 84 |
<family>$family</family> |
| 85 | 85 |
<genus>$genus</genus> |
| 86 |
<parent_id> |
|
| 87 |
<taxonconcept> |
|
| 88 |
<rank>cultivar</rank> |
|
| 89 |
<parent_id> |
|
| 90 |
<taxonconcept> |
|
| 91 |
<rank>forma</rank> |
|
| 92 |
<parent_id> |
|
| 93 |
<taxonconcept> |
|
| 94 |
<rank>variety</rank> |
|
| 95 |
<parent_id> |
|
| 96 |
<taxonconcept> |
|
| 97 |
<rank>subspecies</rank> |
|
| 98 |
<parent_id> |
|
| 99 |
<taxonconcept> |
|
| 100 |
<rank>species</rank> |
|
| 101 |
<taxonname>$specificEpithet</taxonname> |
|
| 102 |
<parent_id> |
|
| 103 |
<taxonconcept> |
|
| 104 |
<rank>genus</rank> |
|
| 105 |
<taxonname>$genus</taxonname> |
|
| 106 |
<parent_id> |
|
| 107 |
<taxonconcept> |
|
| 108 |
<rank>family</rank> |
|
| 109 |
<taxonname>$family</taxonname> |
|
| 110 |
</taxonconcept> |
|
| 111 |
</parent_id> |
|
| 112 |
</taxonconcept> |
|
| 113 |
</parent_id> |
|
| 114 |
</taxonconcept> |
|
| 115 |
</parent_id> |
|
| 116 |
</taxonconcept> |
|
| 117 |
</parent_id> |
|
| 118 |
</taxonconcept> |
|
| 119 |
</parent_id> |
|
| 120 |
</taxonconcept> |
|
| 121 |
</parent_id> |
|
| 122 |
</taxonconcept> |
|
| 123 |
</parent_id> |
|
| 86 | 124 |
<species>$specificEpithet</species> |
| 87 | 125 |
</taxonconcept> |
| 88 | 126 |
</taxonconcept_id> |
| ... | ... | |
| 114 | 152 |
</path> |
| 115 | 153 |
</_simplifyPath> |
| 116 | 154 |
</VegBIEN> |
| 117 |
Inserted 25 new rows into database |
|
| 155 |
Inserted 26 new rows into database |
|
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 21 | 21 |
StemTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 22 | 22 |
Tag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 23 | 23 |
MeasureID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else", |
| 24 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 25 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 26 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/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/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 28 | 24 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 29 | 25 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 30 | 26 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| ... | ... | |
| 33 | 29 |
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author, |
| 34 | 30 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 35 | 31 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 32 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 36 | 36 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 37 | 37 |
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies, |
| 38 | 38 |
Description,,** No join mapping for *Description ** |
| inputs/CTFS/StemObservation/test.xml.ref | ||
|---|---|---|
| 67 | 67 |
<author>$SpeciesAuthority</author> |
| 68 | 68 |
<family>$Family</family> |
| 69 | 69 |
<genus>$Genus</genus> |
| 70 |
<parent_id> |
|
| 71 |
<taxonconcept> |
|
| 72 |
<rank>cultivar</rank> |
|
| 73 |
<parent_id> |
|
| 74 |
<taxonconcept> |
|
| 75 |
<rank>forma</rank> |
|
| 76 |
<parent_id> |
|
| 77 |
<taxonconcept> |
|
| 78 |
<rank>variety</rank> |
|
| 79 |
<parent_id> |
|
| 80 |
<taxonconcept> |
|
| 81 |
<rank>subspecies</rank> |
|
| 82 |
<taxonname>$SubSpeciesName</taxonname> |
|
| 83 |
<parent_id> |
|
| 84 |
<taxonconcept> |
|
| 85 |
<rank>species</rank> |
|
| 86 |
<taxonname>$SpeciesName</taxonname> |
|
| 87 |
<parent_id> |
|
| 88 |
<taxonconcept> |
|
| 89 |
<rank>genus</rank> |
|
| 90 |
<taxonname>$Genus</taxonname> |
|
| 91 |
<parent_id> |
|
| 92 |
<taxonconcept> |
|
| 93 |
<rank>family</rank> |
|
| 94 |
<taxonname>$Family</taxonname> |
|
| 95 |
</taxonconcept> |
|
| 96 |
</parent_id> |
|
| 97 |
</taxonconcept> |
|
| 98 |
</parent_id> |
|
| 99 |
</taxonconcept> |
|
| 100 |
</parent_id> |
|
| 101 |
</taxonconcept> |
|
| 102 |
</parent_id> |
|
| 103 |
</taxonconcept> |
|
| 104 |
</parent_id> |
|
| 105 |
</taxonconcept> |
|
| 106 |
</parent_id> |
|
| 107 |
</taxonconcept> |
|
| 108 |
</parent_id> |
|
| 70 | 109 |
<species>$SpeciesName</species> |
| 71 | 110 |
<subspecies>$SubSpeciesName</subspecies> |
| 72 | 111 |
</taxonconcept> |
| ... | ... | |
| 78 | 117 |
</path> |
| 79 | 118 |
</_simplifyPath> |
| 80 | 119 |
</VegBIEN> |
| 81 |
Inserted 15 new rows into database |
|
| 120 |
Inserted 19 new rows into database |
|
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
CensusID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 10 | 10 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 11 | 11 |
SpeciesInvID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 12 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 13 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 14 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 15 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 16 | 12 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 17 | 13 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 18 | 14 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| 19 | 15 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4",
|
| 20 | 16 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 21 | 17 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 18 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 22 | 22 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 23 | 23 |
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies, |
| 24 | 24 |
Description,,** No join mapping for *Description ** |
| inputs/CTFS/TaxonOccurrence/test.xml.ref | ||
|---|---|---|
| 32 | 32 |
</canon_taxonconcept_id> |
| 33 | 33 |
<family>$Family</family> |
| 34 | 34 |
<genus>$Genus</genus> |
| 35 |
<parent_id> |
|
| 36 |
<taxonconcept> |
|
| 37 |
<rank>cultivar</rank> |
|
| 38 |
<parent_id> |
|
| 39 |
<taxonconcept> |
|
| 40 |
<rank>forma</rank> |
|
| 41 |
<parent_id> |
|
| 42 |
<taxonconcept> |
|
| 43 |
<rank>variety</rank> |
|
| 44 |
<parent_id> |
|
| 45 |
<taxonconcept> |
|
| 46 |
<rank>subspecies</rank> |
|
| 47 |
<taxonname>$SubSpeciesName</taxonname> |
|
| 48 |
<parent_id> |
|
| 49 |
<taxonconcept> |
|
| 50 |
<rank>species</rank> |
|
| 51 |
<taxonname>$SpeciesName</taxonname> |
|
| 52 |
<parent_id> |
|
| 53 |
<taxonconcept> |
|
| 54 |
<rank>genus</rank> |
|
| 55 |
<taxonname>$Genus</taxonname> |
|
| 56 |
<parent_id> |
|
| 57 |
<taxonconcept> |
|
| 58 |
<rank>family</rank> |
|
| 59 |
<taxonname>$Family</taxonname> |
|
| 60 |
</taxonconcept> |
|
| 61 |
</parent_id> |
|
| 62 |
</taxonconcept> |
|
| 63 |
</parent_id> |
|
| 64 |
</taxonconcept> |
|
| 65 |
</parent_id> |
|
| 66 |
</taxonconcept> |
|
| 67 |
</parent_id> |
|
| 68 |
</taxonconcept> |
|
| 69 |
</parent_id> |
|
| 70 |
</taxonconcept> |
|
| 71 |
</parent_id> |
|
| 72 |
</taxonconcept> |
|
| 73 |
</parent_id> |
|
| 35 | 74 |
<species>$SpeciesName</species> |
| 36 | 75 |
<subspecies>$SubSpeciesName</subspecies> |
| 37 | 76 |
</taxonconcept> |
| ... | ... | |
| 43 | 82 |
</path> |
| 44 | 83 |
</_simplifyPath> |
| 45 | 84 |
</VegBIEN> |
| 46 |
Inserted 12 new rows into database |
|
| 85 |
Inserted 18 new rows into database |
|
| inputs/FIA/Organism/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
TreeTag,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/tag, |
| 15 | 15 |
PlotCD,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 16 | 16 |
TreeTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 17 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 18 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 19 | 17 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 20 | 18 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_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 | 19 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 20 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 21 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 22 | 22 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 23 | 23 |
County,/location/locationplace/*_id/placepath/county, |
| 24 | 24 |
StateProvince,/location/locationplace/*_id/placepath/stateprovince, |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 57 | 57 |
tag1,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2/_alt/2","The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once." |
| 58 | 58 |
Habit,"/location/locationevent/taxonoccurrence/growthform/_map:[./{T,Arbol,palm}=tree,./{H,""HemiepÃfito""}=hemiepiphyte,./{L,l,""L?"",Liana}=liana,E=epiphyte,S=shrub,Hb=herb,""vine-herbaceous""=vine,graminoid=grass,rosette=forb,*=*]/value","Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait.; According to <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data.habit>, <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/SALVIAS#Habit>"
|
| 59 | 59 |
PlotObsID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/else","Brad: Neither is correct; this is just an internal ID for table plotObservations. However, it has the important property of uniquely identifying an ""observation"", which is an individual tree, in the case of an individual observation, or a records of a species with an associated count of individuals or measurement of percent cover, in the case of aggregate observations. Not sure where to store this. Main point is that it is not part of the original data, but an auto_increment added later." |
| 60 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 61 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 62 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 63 | 60 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 64 | 61 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 65 | 62 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| ... | ... | |
| 70 | 67 |
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Brad: This is the author of the scientificName. |
| 71 | 68 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 72 | 69 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 70 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 71 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 72 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 73 | 73 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 74 | 74 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 75 | 75 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1, |
| inputs/.TNRS/tnrs/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
TNRS,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
Name_matched,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 3 | 3 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/cond/_exists", |
| 4 |
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 5 |
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 6 |
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/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 |
|
| 7 | 4 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2",
|
| 8 | 5 |
Name_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 9 | 6 |
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",Contains family based on matched name
|
| ... | ... | |
| 25 | 22 |
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/author,Contains author based on matched name |
| 26 | 23 |
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family,Contains family based on matched name |
| 27 | 24 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 25 |
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 26 |
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 27 |
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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 |
|
| 28 | 28 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 29 | 29 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 30 | 30 |
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonconcept:[@fkey=canon_taxonconcept_id]/author,Contains author in original string |
| inputs/U/Specimen/VegBIEN.csv | ||
|---|---|---|
| 16 | 16 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 17 | 17 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 18 | 18 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 19 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 20 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 21 | 19 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 22 | 20 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 23 | 21 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/givenname/_namePart/first, |
| ... | ... | |
| 25 | 23 |
Detby,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 26 | 24 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 27 | 25 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 26 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 28 | 28 |
Detyy,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 29 | 29 |
cf,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 30 | 30 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1, |
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 32 | 32 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 33 | 33 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 34 | 34 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 35 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 36 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 37 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 38 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 39 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 40 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 41 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname", |
|
| 42 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/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 | 35 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",Contains the binomial in addition to the authority
|
| 44 | 36 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 45 | 37 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| ... | ... | |
| 54 | 46 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 55 | 47 |
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom, |
| 56 | 48 |
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order, |
| 49 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 50 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 51 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 52 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 53 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 54 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 55 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 56 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 57 | 57 |
Phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/phylum, |
| 58 | 58 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 59 | 59 |
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies, |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 16 | 16 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 17 | 17 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 18 | 18 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 19 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/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/_if[@name=""if has verbatim name""]/then/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/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 22 | 19 |
ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| 23 | 20 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 24 | 21 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| ... | ... | |
| 32 | 29 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/creator_id/_simplifyPath:[next=creator_id]/path/party/surname/_namePart/last, |
| 33 | 30 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/family, |
| 34 | 31 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 32 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 35 | 35 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 36 | 36 |
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonname/_alt/1, |
| 37 | 37 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/taxonomicname, |
| inputs/SpeciesLink/Specimen/test.xml.ref | ||
|---|---|---|
| 402 | 402 |
<2>$dwc_terms_order</2> |
| 403 | 403 |
</_alt> |
| 404 | 404 |
</order> |
| 405 |
<parent_id> |
|
| 406 |
<taxonconcept> |
|
| 407 |
<rank>cultivar</rank> |
|
| 408 |
<parent_id> |
|
| 409 |
<taxonconcept> |
|
| 410 |
<rank>forma</rank> |
|
| 411 |
<parent_id> |
|
| 412 |
<taxonconcept> |
|
| 413 |
<rank>variety</rank> |
|
| 414 |
<parent_id> |
|
| 415 |
<taxonconcept> |
|
| 416 |
<rank>subspecies</rank> |
|
| 417 |
<taxonname>$conceptual_darwin_2003_1_0_Subspecies</taxonname> |
|
| 418 |
<parent_id> |
|
| 419 |
<taxonconcept> |
|
| 420 |
<rank>species</rank> |
|
| 421 |
<taxonname> |
|
| 422 |
<_alt> |
|
| 423 |
<0>$conceptual_darwin_2003_1_0_Species</0> |
|
| 424 |
<1>$dwc_dwcore_SpecificEpithet</1> |
|
| 425 |
<2>$dwc_terms_specificEpithet</2> |
|
| 426 |
</_alt> |
|
| 427 |
</taxonname> |
|
| 428 |
<parent_id> |
|
| 429 |
<taxonconcept> |
|
| 430 |
<rank>genus</rank> |
|
| 431 |
<taxonname> |
|
| 432 |
<_alt> |
|
| 433 |
<0>$conceptual_darwin_2003_1_0_Genus</0> |
|
| 434 |
<1>$dwc_dwcore_Genus</1> |
|
| 435 |
<2>$dwc_terms_genus</2> |
|
| 436 |
</_alt> |
|
| 437 |
</taxonname> |
|
| 438 |
<parent_id> |
|
| 439 |
<taxonconcept> |
|
| 440 |
<rank>family</rank> |
|
| 441 |
<taxonname> |
|
| 442 |
<_alt> |
|
| 443 |
<0>$conceptual_darwin_2003_1_0_Family</0> |
|
| 444 |
<1>$dwc_dwcore_Family</1> |
|
| 445 |
<2>$dwc_terms_family</2> |
|
| 446 |
</_alt> |
|
| 447 |
</taxonname> |
|
| 448 |
<parent_id> |
|
| 449 |
<taxonconcept> |
|
| 450 |
<rank>order</rank> |
|
| 451 |
<taxonname> |
|
| 452 |
<_alt> |
|
| 453 |
<0>$conceptual_darwin_2003_1_0_Order</0> |
|
| 454 |
<1>$dwc_dwcore_Order</1> |
|
| 455 |
<2>$dwc_terms_order</2> |
|
| 456 |
</_alt> |
|
| 457 |
</taxonname> |
|
| 458 |
<parent_id> |
|
| 459 |
<taxonconcept> |
|
| 460 |
<rank>class</rank> |
|
| 461 |
<taxonname> |
|
| 462 |
<_alt> |
|
| 463 |
<0>$conceptual_darwin_2003_1_0_Class</0> |
|
| 464 |
<1>$dwc_dwcore_Class</1> |
|
| 465 |
<2>$dwc_terms_class</2> |
|
| 466 |
</_alt> |
|
| 467 |
</taxonname> |
|
| 468 |
<parent_id> |
|
| 469 |
<taxonconcept> |
|
| 470 |
<rank>phylum</rank> |
|
| 471 |
<taxonname> |
|
| 472 |
<_alt> |
|
| 473 |
<0>$conceptual_darwin_2003_1_0_Phylum</0> |
|
| 474 |
<1>$dwc_dwcore_Phylum</1> |
|
| 475 |
<2>$dwc_terms_phylum</2> |
|
| 476 |
</_alt> |
|
| 477 |
</taxonname> |
|
| 478 |
<parent_id> |
|
| 479 |
<taxonconcept> |
|
| 480 |
<rank>kingdom</rank> |
|
| 481 |
<taxonname> |
|
| 482 |
<_alt> |
|
| 483 |
<0>$conceptual_darwin_2003_1_0_Kingdom</0> |
|
| 484 |
<1>$dwc_dwcore_Kingdom</1> |
|
| 485 |
<2>$dwc_terms_kingdom</2> |
|
| 486 |
</_alt> |
|
| 487 |
</taxonname> |
|
| 488 |
</taxonconcept> |
|
| 489 |
</parent_id> |
|
| 490 |
</taxonconcept> |
|
| 491 |
</parent_id> |
|
| 492 |
</taxonconcept> |
|
| 493 |
</parent_id> |
|
| 494 |
</taxonconcept> |
|
| 495 |
</parent_id> |
|
| 496 |
</taxonconcept> |
|
| 497 |
</parent_id> |
|
| 498 |
</taxonconcept> |
|
| 499 |
</parent_id> |
|
| 500 |
</taxonconcept> |
|
| 501 |
</parent_id> |
|
| 502 |
</taxonconcept> |
|
| 503 |
</parent_id> |
|
| 504 |
</taxonconcept> |
|
| 505 |
</parent_id> |
|
| 506 |
</taxonconcept> |
|
| 507 |
</parent_id> |
|
| 508 |
</taxonconcept> |
|
| 509 |
</parent_id> |
|
| 405 | 510 |
<phylum> |
| 406 | 511 |
<_alt> |
| 407 | 512 |
<0>$conceptual_darwin_2003_1_0_Phylum</0> |
| ... | ... | |
| 536 | 641 |
</path> |
| 537 | 642 |
</_simplifyPath> |
| 538 | 643 |
</VegBIEN> |
| 539 |
Inserted 32 new rows into database |
|
| 644 |
Inserted 37 new rows into database |
|
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
observation_id,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 11 | 11 |
authorplantname,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1", |
| 12 | 12 |
taxonobservation_id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 13 |
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname", |
|
| 14 |
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname", |
|
| 15 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 16 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 17 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 18 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 19 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 20 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 21 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
|
| 22 | 13 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1",
|
| 23 | 14 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2",
|
| 24 | 15 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1",
|
| ... | ... | |
| 31 | 22 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 32 | 23 |
Kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom, |
| 33 | 24 |
Order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order, |
| 25 |
Forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname", |
|
| 26 |
Variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname", |
|
| 27 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 28 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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/_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/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 31 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 32 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 33 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 34 | 34 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| 35 | 35 |
Subspecies,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/subspecies, |
| 36 | 36 |
Variety,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/variety, |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 131 | 131 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| 132 | 132 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last, |
| 133 | 133 |
verbatimScientificNameWithAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/cond/_exists", |
| 134 |
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=cultivar]/taxonname", |
|
| 135 |
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname", |
|
| 136 |
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname", |
|
| 137 |
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 138 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 139 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 140 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 141 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 142 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 143 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=phylum]/taxonname", |
|
| 144 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/then/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=kingdom]/taxonname", |
|
| 145 | 134 |
morphospecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/2",
|
| 146 | 135 |
scientificNameWithAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/1",
|
| 147 | 136 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/_if[@name=""if has verbatim name""]/{then/.,else/canon_taxonconcept_id/taxonconcept:[creator_id/party:[creator_id=0]/organizationname=TNRS]}/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1",
|
| ... | ... | |
| 196 | 185 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/genus, |
| 197 | 186 |
kingdom,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/kingdom, |
| 198 | 187 |
order,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/order, |
| 188 |
cultivar,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=cultivar]/taxonname", |
|
| 189 |
forma,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=forma]/taxonname", |
|
| 190 |
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=variety]/taxonname", |
|
| 191 |
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=subspecies]/taxonname", |
|
| 192 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=species]/taxonname", |
|
| 193 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=genus]/taxonname", |
|
| 194 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=family]/taxonname", |
|
| 195 |
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=order]/taxonname", |
|
| 196 |
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonconcept[rank=_val]/parent_id""]/taxonconcept[rank=class]/taxonname", |
|
| 197 |
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 198 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_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", |
|
| 199 | 199 |
phylum,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/phylum, |
| 200 | 200 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/rank, |
| 201 | 201 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonconcept/species, |
| inputs/FIA/Organism/test.xml.ref | ||
|---|---|---|
| 79 | 79 |
</taxonconcept> |
| 80 | 80 |
</canon_taxonconcept_id> |
| 81 | 81 |
<genus>$Genus</genus> |
| 82 |
<parent_id> |
|
| 83 |
<taxonconcept> |
|
| 84 |
<rank>cultivar</rank> |
|
| 85 |
<parent_id> |
|
| 86 |
<taxonconcept> |
|
| 87 |
<rank>forma</rank> |
|
| 88 |
<parent_id> |
|
| 89 |
<taxonconcept> |
|
| 90 |
<rank>variety</rank> |
|
| 91 |
<parent_id> |
|
| 92 |
<taxonconcept> |
|
| 93 |
<rank>subspecies</rank> |
|
| 94 |
<parent_id> |
|
| 95 |
<taxonconcept> |
|
| 96 |
<rank>species</rank> |
|
| 97 |
<taxonname>$SpecificEpithet</taxonname> |
|
| 98 |
<parent_id> |
|
| 99 |
<taxonconcept> |
|
| 100 |
<rank>genus</rank> |
|
| 101 |
<taxonname>$Genus</taxonname> |
|
| 102 |
</taxonconcept> |
|
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: taxonconcepts: Also create the taxonconcept tree if datasource provided separated components of the taxonomic name and/or its own tree of life with higher classifications. This enables storing the datasource's own tree of life to supplement any official tree (TROPICOS, USDA, etc.).