Revision 5655
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/.TNRS/tnrs/test.xml.ref | ||
|---|---|---|
| 12 | 12 |
<_taxonlabel_set_matched_label_id> |
| 13 | 13 |
<matched_label_id> |
| 14 | 14 |
<taxonlabel> |
| 15 |
<author>$Accepted_name_author</author> |
|
| 16 |
<binomial>$Accepted_name</binomial> |
|
| 17 |
<family>$Accepted_name_family</family> |
|
| 18 | 15 |
<identifyingtaxonomicname> |
| 19 | 16 |
<_join_words> |
| 20 | 17 |
<1> |
| ... | ... | |
| 77 | 74 |
</taxonlabel> |
| 78 | 75 |
</parent_id> |
| 79 | 76 |
<rank>$Accepted_name_rank</rank> |
| 80 |
<verbatimrank>$Accepted_name_rank</verbatimrank>
|
|
| 77 |
<taxonverbatim><verbatimrank>$Accepted_name_rank</verbatimrank></taxonverbatim>
|
|
| 81 | 78 |
</taxonlabel> |
| 82 | 79 |
</parent_id> |
| 83 | 80 |
<rank>$Accepted_name_rank</rank> |
| 84 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
|
| 81 |
<taxonverbatim> |
|
| 82 |
<author>$Accepted_name_author</author> |
|
| 83 |
<binomial>$Accepted_name</binomial> |
|
| 84 |
<family>$Accepted_name_family</family> |
|
| 85 |
<verbatimrank>$Accepted_name_rank</verbatimrank> |
|
| 86 |
</taxonverbatim> |
|
| 85 | 87 |
</taxonlabel> |
| 86 | 88 |
</matched_label_id> |
| 87 | 89 |
</_taxonlabel_set_matched_label_id> |
| 88 |
<author>$Name_matched_author</author> |
|
| 89 |
<binomial>$Name_matched</binomial> |
|
| 90 |
<family>$Name_matched_accepted_family</family> |
|
| 91 |
<genus>$Genus_matched</genus> |
|
| 92 | 90 |
<identifyingtaxonomicname> |
| 93 | 91 |
<_join_words> |
| 94 | 92 |
<1> |
| ... | ... | |
| 120 | 118 |
<parent_id> |
| 121 | 119 |
<taxonlabel> |
| 122 | 120 |
<rank>$Name_matched_rank</rank> |
| 123 |
<verbatimrank>$Name_matched_rank</verbatimrank>
|
|
| 121 |
<taxonverbatim><verbatimrank>$Name_matched_rank</verbatimrank></taxonverbatim>
|
|
| 124 | 122 |
<parent_id> |
| 125 | 123 |
<taxonlabel> |
| 126 | 124 |
<rank>cultivar</rank> |
| ... | ... | |
| 164 | 162 |
</parent_id> |
| 165 | 163 |
<rank>$Name_matched_rank</rank> |
| 166 | 164 |
<sourceaccessioncode>$Name_matched_url</sourceaccessioncode> |
| 167 |
<species>$Specific_epithet_matched</species> |
|
| 168 | 165 |
<taxonlabel fkey="matched_label_id"> |
| 169 |
<author>$Author_matched</author> |
|
| 170 |
<binomial>$Name_matched</binomial> |
|
| 171 |
<family>$Family_matched</family> |
|
| 172 |
<genus>$Genus_matched</genus> |
|
| 173 | 166 |
<identifyingtaxonomicname>$Name_submitted</identifyingtaxonomicname> |
| 174 | 167 |
<matched_label_fit_fraction> |
| 175 | 168 |
<_max> |
| ... | ... | |
| 179 | 172 |
<4>$Overall_score</4> |
| 180 | 173 |
</_max> |
| 181 | 174 |
</matched_label_fit_fraction> |
| 182 |
<morphospecies>$Unmatched_terms</morphospecies> |
|
| 183 |
<species>$Specific_epithet_matched</species> |
|
| 184 |
<verbatimrank>$Infraspecific_rank</verbatimrank> |
|
| 175 |
<taxonverbatim> |
|
| 176 |
<author>$Author_matched</author> |
|
| 177 |
<binomial>$Name_matched</binomial> |
|
| 178 |
<family>$Family_matched</family> |
|
| 179 |
<genus>$Genus_matched</genus> |
|
| 180 |
<morphospecies>$Unmatched_terms</morphospecies> |
|
| 181 |
<species>$Specific_epithet_matched</species> |
|
| 182 |
<verbatimrank>$Infraspecific_rank</verbatimrank> |
|
| 183 |
</taxonverbatim> |
|
| 185 | 184 |
</taxonlabel> |
| 186 | 185 |
<taxonstatus>$Taxonomic_status</taxonstatus> |
| 187 |
<verbatimrank>$Name_matched_rank</verbatimrank> |
|
| 186 |
<taxonverbatim> |
|
| 187 |
<author>$Name_matched_author</author> |
|
| 188 |
<binomial>$Name_matched</binomial> |
|
| 189 |
<family>$Name_matched_accepted_family</family> |
|
| 190 |
<genus>$Genus_matched</genus> |
|
| 191 |
<species>$Specific_epithet_matched</species> |
|
| 192 |
<verbatimrank>$Name_matched_rank</verbatimrank> |
|
| 193 |
</taxonverbatim> |
|
| 188 | 194 |
</taxonlabel> |
| 189 | 195 |
</taxonlabel_id> |
| 190 | 196 |
</taxondetermination> |
| ... | ... | |
| 194 | 200 |
</path> |
| 195 | 201 |
</_simplifyPath> |
| 196 | 202 |
</VegBIEN> |
| 197 |
Inserted 11 new rows into database |
|
| 203 |
Inserted 16 new rows into database |
|
| inputs/ARIZ/Specimen/VegBIEN.csv | ||
|---|---|---|
| 36 | 36 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2", |
| 37 | 37 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 38 | 38 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4", |
| 39 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 40 | 39 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 41 | 40 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 42 | 41 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 43 | 42 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 44 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 45 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 46 | 43 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1,Contains the binomial in addition to the authority |
| 47 | 44 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 48 | 45 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| ... | ... | |
| 57 | 54 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet", |
| 58 | 55 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet", |
| 59 | 56 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 60 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 61 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname,Contains the binomial in addition to the authority |
|
| 57 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 58 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 59 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 60 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 61 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/taxonomicname,Contains the binomial in addition to the authority |
|
| 62 | 62 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 63 | 63 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 64 | 64 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 77 | 77 |
</identifyingtaxonomicname> |
| 78 | 78 |
</taxonlabel> |
| 79 | 79 |
</matched_label_id> |
| 80 |
<author>$AuthorOfScientificName</author> |
|
| 81 |
<binomial>$ScientificName</binomial> |
|
| 82 | 80 |
<creator_id> |
| 83 | 81 |
<_simplifyPath> |
| 84 | 82 |
<next>creator_id</next> |
| 85 | 83 |
<path><party><fullname>$IdentifiedBy</fullname></party></path> |
| 86 | 84 |
</_simplifyPath> |
| 87 | 85 |
</creator_id> |
| 88 |
<family>$Family</family> |
|
| 89 |
<genus>$Genus</genus> |
|
| 90 | 86 |
<identifyingtaxonomicname> |
| 91 | 87 |
<_join_words> |
| 92 | 88 |
<1> |
| ... | ... | |
| 148 | 144 |
<taxonepithet>$InfraspecificEpithet</taxonepithet> |
| 149 | 145 |
</taxonlabel> |
| 150 | 146 |
</parent_id> |
| 151 |
<species>$SpecificEpithet</species> |
|
| 147 |
<taxonverbatim> |
|
| 148 |
<author>$AuthorOfScientificName</author> |
|
| 149 |
<binomial>$ScientificName</binomial> |
|
| 150 |
<family>$Family</family> |
|
| 151 |
<genus>$Genus</genus> |
|
| 152 |
<species>$SpecificEpithet</species> |
|
| 153 |
</taxonverbatim> |
|
| 152 | 154 |
</taxonlabel> |
| 153 | 155 |
</taxonlabel_id> |
| 154 | 156 |
</taxondetermination> |
| ... | ... | |
| 156 | 158 |
<isoriginal>true</isoriginal> |
| 157 | 159 |
<taxonlabel_id> |
| 158 | 160 |
<taxonlabel> |
| 159 |
<binomial>$ScientificNameOriginal</binomial> |
|
| 160 |
<family>$GBIFFamilyOriginal</family> |
|
| 161 |
<genus>$GBIFGenusOriginal</genus> |
|
| 162 | 161 |
<identifyingtaxonomicname> |
| 163 | 162 |
<_alt> |
| 164 | 163 |
<1>$ScientificNameOriginal</1> |
| ... | ... | |
| 232 | 231 |
</parent_id> |
| 233 | 232 |
</taxonlabel> |
| 234 | 233 |
</parent_id> |
| 234 |
<taxonverbatim> |
|
| 235 |
<binomial>$ScientificNameOriginal</binomial> |
|
| 236 |
<family>$GBIFFamilyOriginal</family> |
|
| 237 |
<genus>$GBIFGenusOriginal</genus> |
|
| 238 |
</taxonverbatim> |
|
| 235 | 239 |
</taxonlabel> |
| 236 | 240 |
</taxonlabel_id> |
| 237 | 241 |
</taxondetermination> |
| ... | ... | |
| 252 | 256 |
</path> |
| 253 | 257 |
</_simplifyPath> |
| 254 | 258 |
</VegBIEN> |
| 255 |
Inserted 39 new rows into database |
|
| 259 |
Inserted 43 new rows into database |
|
| inputs/MT/Specimen/VegBIEN.csv | ||
|---|---|---|
| 13 | 13 |
id,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3, |
| 14 | 14 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1", |
| 15 | 15 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2", |
| 16 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 17 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 18 | 16 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 19 | 17 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 20 | 18 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 21 | 19 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 20 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 21 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 22 | 22 |
locality,/location/locationnarrative/_merge/1, |
| 23 | 23 |
continent,/location/locationplace/*_id/placepath/continent, |
| 24 | 24 |
basisOfRecord,,** No join mapping for basisOfRecord ** |
| inputs/MT/Specimen/test.xml.ref | ||
|---|---|---|
| 58 | 58 |
</identifyingtaxonomicname> |
| 59 | 59 |
</taxonlabel> |
| 60 | 60 |
</matched_label_id> |
| 61 |
<family>$family</family> |
|
| 62 |
<genus>$genus</genus> |
|
| 63 | 61 |
<identifyingtaxonomicname> |
| 64 | 62 |
<_join_words> |
| 65 | 63 |
<1>$family</1> |
| ... | ... | |
| 107 | 105 |
</parent_id> |
| 108 | 106 |
</taxonlabel> |
| 109 | 107 |
</parent_id> |
| 108 |
<taxonverbatim> |
|
| 109 |
<family>$family</family> |
|
| 110 |
<genus>$genus</genus> |
|
| 111 |
</taxonverbatim> |
|
| 110 | 112 |
</taxonlabel> |
| 111 | 113 |
</taxonlabel_id> |
| 112 | 114 |
</taxondetermination> |
| ... | ... | |
| 118 | 120 |
</path> |
| 119 | 121 |
</_simplifyPath> |
| 120 | 122 |
</VegBIEN> |
| 121 |
Inserted 24 new rows into database |
|
| 123 |
Inserted 25 new rows into database |
|
| inputs/test_taxonomic_names/Taxon/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
test_taxonomic_names,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 3 | 3 |
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1", |
| 4 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 5 | 4 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 6 | 5 |
scientificNameID,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode, |
| 6 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| inputs/test_taxonomic_names/Taxon/test.xml.ref | ||
|---|---|---|
| 20 | 20 |
<identifyingtaxonomicname>$scientificName</identifyingtaxonomicname> |
| 21 | 21 |
</taxonlabel> |
| 22 | 22 |
</matched_label_id> |
| 23 |
<binomial>$scientificName</binomial> |
|
| 24 | 23 |
<identifyingtaxonomicname>$scientificName</identifyingtaxonomicname> |
| 25 | 24 |
<sourceaccessioncode>$scientificNameID</sourceaccessioncode> |
| 25 |
<taxonverbatim><binomial>$scientificName</binomial></taxonverbatim> |
|
| 26 | 26 |
</taxonlabel> |
| 27 | 27 |
</taxonlabel_id> |
| 28 | 28 |
</taxondetermination> |
| ... | ... | |
| 32 | 32 |
</path> |
| 33 | 33 |
</_simplifyPath> |
| 34 | 34 |
</VegBIEN> |
| 35 |
Inserted 9 new rows into database |
|
| 35 |
Inserted 11 new rows into database |
|
| inputs/XAL/Specimen/VegBIEN.csv | ||
|---|---|---|
| 27 | 27 |
darwin:Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 28 | 28 |
darwin:Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4", |
| 29 | 29 |
darwin:ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2", |
| 30 |
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
|
| 31 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 32 | 30 |
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 33 | 31 |
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 34 | 32 |
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 35 | 33 |
darwin:IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 36 |
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 37 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 38 | 34 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 39 | 35 |
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 40 | 36 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| ... | ... | |
| 49 | 45 |
darwin:Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet", |
| 50 | 46 |
darwin:Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet", |
| 51 | 47 |
darwin:Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 52 |
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 48 |
darwin:ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author, |
|
| 49 |
darwin:ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 50 |
darwin:Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 51 |
darwin:Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 52 |
darwin:Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 53 | 53 |
darwin:DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 54 | 54 |
darwin:MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 55 | 55 |
darwin:YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/TEAM/VL/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1", |
| 24 | 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2", |
| 25 | 25 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 28 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 29 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 30 | 28 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| 31 | 29 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 32 | 30 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 33 | 31 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 34 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 32 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 33 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 34 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 35 | 35 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 36 | 36 |
Comments,,** No join mapping for *Comments ** |
| 37 | 37 |
Condition Codes,,** No join mapping for *Condition Codes ** |
| inputs/TEAM/VL/test.xml.ref | ||
|---|---|---|
| 61 | 61 |
</identifyingtaxonomicname> |
| 62 | 62 |
</taxonlabel> |
| 63 | 63 |
</matched_label_id> |
| 64 |
<family>$Family</family> |
|
| 65 |
<genus>$Genus</genus> |
|
| 66 | 64 |
<identifyingtaxonomicname> |
| 67 | 65 |
<_join_words> |
| 68 | 66 |
<1>$Family</1> |
| ... | ... | |
| 112 | 110 |
</parent_id> |
| 113 | 111 |
</taxonlabel> |
| 114 | 112 |
</parent_id> |
| 115 |
<species>$Species</species> |
|
| 113 |
<taxonverbatim> |
|
| 114 |
<family>$Family</family> |
|
| 115 |
<genus>$Genus</genus> |
|
| 116 |
<species>$Species</species> |
|
| 117 |
</taxonverbatim> |
|
| 116 | 118 |
</taxonlabel> |
| 117 | 119 |
</taxonlabel_id> |
| 118 | 120 |
</taxondetermination> |
| ... | ... | |
| 123 | 125 |
</path> |
| 124 | 126 |
</_simplifyPath> |
| 125 | 127 |
</VegBIEN> |
| 126 |
Inserted 32 new rows into database |
|
| 128 |
Inserted 34 new rows into database |
|
| inputs/TEAM/VT/VegBIEN.csv | ||
|---|---|---|
| 23 | 23 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1", |
| 24 | 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2", |
| 25 | 25 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 28 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 29 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 30 | 28 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| 31 | 29 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 32 | 30 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 33 | 31 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 34 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 32 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 33 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 34 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 35 | 35 |
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 36 | 36 |
Comments,,** No join mapping for *Comments ** |
| 37 | 37 |
Condition Codes,,** No join mapping for *Condition Codes ** |
| inputs/TEAM/VT/test.xml.ref | ||
|---|---|---|
| 61 | 61 |
</identifyingtaxonomicname> |
| 62 | 62 |
</taxonlabel> |
| 63 | 63 |
</matched_label_id> |
| 64 |
<family>$Family</family> |
|
| 65 |
<genus>$Genus</genus> |
|
| 66 | 64 |
<identifyingtaxonomicname> |
| 67 | 65 |
<_join_words> |
| 68 | 66 |
<1>$Family</1> |
| ... | ... | |
| 112 | 110 |
</parent_id> |
| 113 | 111 |
</taxonlabel> |
| 114 | 112 |
</parent_id> |
| 115 |
<species>$Species</species> |
|
| 113 |
<taxonverbatim> |
|
| 114 |
<family>$Family</family> |
|
| 115 |
<genus>$Genus</genus> |
|
| 116 |
<species>$Species</species> |
|
| 117 |
</taxonverbatim> |
|
| 116 | 118 |
</taxonlabel> |
| 117 | 119 |
</taxonlabel_id> |
| 118 | 120 |
</taxondetermination> |
| ... | ... | |
| 123 | 125 |
</path> |
| 124 | 126 |
</_simplifyPath> |
| 125 | 127 |
</VegBIEN> |
| 126 |
Inserted 29 new rows into database |
|
| 128 |
Inserted 31 new rows into database |
|
| inputs/NY/Specimen/VegBIEN.csv | ||
|---|---|---|
| 32 | 32 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 33 | 33 |
Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4", |
| 34 | 34 |
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2", |
| 35 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
|
| 36 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 37 | 35 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 38 | 36 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 39 | 37 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| 40 | 38 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 41 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 42 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 43 | 39 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 44 | 40 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 45 | 41 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| ... | ... | |
| 54 | 50 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=class]/taxonepithet", |
| 55 | 51 |
Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=phylum]/taxonepithet", |
| 56 | 52 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 57 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 53 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author, |
|
| 54 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 55 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 56 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 57 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 58 | 58 |
DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 59 | 59 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 60 | 60 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| inputs/NY/Specimen/test.xml.ref | ||
|---|---|---|
| 137 | 137 |
</identifyingtaxonomicname> |
| 138 | 138 |
</taxonlabel> |
| 139 | 139 |
</matched_label_id> |
| 140 |
<author>$ScientificNameAuthor</author> |
|
| 141 |
<binomial>$ScientificName</binomial> |
|
| 142 | 140 |
<creationdate> |
| 143 | 141 |
<_date> |
| 144 | 142 |
<day> |
| ... | ... | |
| 170 | 168 |
<path><party><fullname>$IdentifiedBy</fullname></party></path> |
| 171 | 169 |
</_simplifyPath> |
| 172 | 170 |
</creator_id> |
| 173 |
<family>$Family</family> |
|
| 174 |
<genus>$Genus</genus> |
|
| 175 | 171 |
<identifyingtaxonomicname> |
| 176 | 172 |
<_join_words> |
| 177 | 173 |
<1> |
| ... | ... | |
| 257 | 253 |
</parent_id> |
| 258 | 254 |
</taxonlabel> |
| 259 | 255 |
</parent_id> |
| 260 |
<species>$Species</species> |
|
| 256 |
<taxonverbatim> |
|
| 257 |
<author>$ScientificNameAuthor</author> |
|
| 258 |
<binomial>$ScientificName</binomial> |
|
| 259 |
<family>$Family</family> |
|
| 260 |
<genus>$Genus</genus> |
|
| 261 |
<species>$Species</species> |
|
| 262 |
</taxonverbatim> |
|
| 261 | 263 |
</taxonlabel> |
| 262 | 264 |
</taxonlabel_id> |
| 263 | 265 |
<determinationdate> |
| ... | ... | |
| 336 | 338 |
</path> |
| 337 | 339 |
</_simplifyPath> |
| 338 | 340 |
</VegBIEN> |
| 339 |
Inserted 35 new rows into database |
|
| 341 |
Inserted 37 new rows into database |
|
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 36 | 36 |
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2", |
| 37 | 37 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 38 | 38 |
Autor (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2", |
| 39 |
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
|
| 40 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial,"Contains less than ""Specie+autor""" |
|
| 41 | 39 |
Determined by,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 42 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 43 |
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 44 | 40 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1, |
| 45 | 41 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1,"Contains less than ""Specie+autor""" |
| 46 | 42 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| ... | ... | |
| 50 | 46 |
Specific epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 51 | 47 |
Genera,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 52 | 48 |
Family (revised),"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 53 |
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 54 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 49 |
Autor (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author, |
|
| 50 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial,"Contains less than ""Specie+autor""" |
|
| 51 |
Family (revised),/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 52 |
Genera,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 53 |
Specific epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 54 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/taxonomicname, |
|
| 55 | 55 |
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 56 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
|
| 57 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus,Often = Genera |
|
| 58 | 56 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 59 | 57 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera |
| 60 | 58 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 61 | 59 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera |
| 62 | 60 |
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",Often = Genera |
| 63 | 61 |
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 62 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/family, |
|
| 63 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/genus,Often = Genera |
|
| 64 | 64 |
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 65 | 65 |
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 66 | 66 |
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate" |
| inputs/Madidi/Organism/test.xml.ref | ||
|---|---|---|
| 96 | 96 |
</identifyingtaxonomicname> |
| 97 | 97 |
</taxonlabel> |
| 98 | 98 |
</matched_label_id> |
| 99 |
<author>$Autor (revised)</author> |
|
| 100 |
<binomial>$Species and morphotypes</binomial> |
|
| 101 | 99 |
<creator_id> |
| 102 | 100 |
<_simplifyPath> |
| 103 | 101 |
<next>creator_id</next> |
| 104 | 102 |
<path><party><fullname>$Determined by</fullname></party></path> |
| 105 | 103 |
</_simplifyPath> |
| 106 | 104 |
</creator_id> |
| 107 |
<family>$Family (revised)</family> |
|
| 108 |
<genus>$Genera</genus> |
|
| 109 | 105 |
<identifyingtaxonomicname> |
| 110 | 106 |
<_alt> |
| 111 | 107 |
<1>$Specie+autor</1> |
| ... | ... | |
| 170 | 166 |
</parent_id> |
| 171 | 167 |
</taxonlabel> |
| 172 | 168 |
</parent_id> |
| 173 |
<species>$Specific epithet</species> |
|
| 174 |
<taxonomicname>$Specie+autor</taxonomicname> |
|
| 169 |
<taxonverbatim> |
|
| 170 |
<author>$Autor (revised)</author> |
|
| 171 |
<binomial>$Species and morphotypes</binomial> |
|
| 172 |
<family>$Family (revised)</family> |
|
| 173 |
<genus>$Genera</genus> |
|
| 174 |
<species>$Specific epithet</species> |
|
| 175 |
<taxonomicname>$Specie+autor</taxonomicname> |
|
| 176 |
</taxonverbatim> |
|
| 175 | 177 |
</taxonlabel> |
| 176 | 178 |
</taxonlabel_id> |
| 177 | 179 |
<taxonfit>$Qualifier</taxonfit> |
| ... | ... | |
| 180 | 182 |
<isoriginal>true</isoriginal> |
| 181 | 183 |
<taxonlabel_id> |
| 182 | 184 |
<taxonlabel> |
| 183 |
<family>$Field family</family> |
|
| 184 |
<genus>$Field name</genus> |
|
| 185 | 185 |
<identifyingtaxonomicname> |
| 186 | 186 |
<_join_words> |
| 187 | 187 |
<1>$Field family</1> |
| ... | ... | |
| 245 | 245 |
</parent_id> |
| 246 | 246 |
</taxonlabel> |
| 247 | 247 |
</parent_id> |
| 248 |
<taxonverbatim> |
|
| 249 |
<family>$Field family</family> |
|
| 250 |
<genus>$Field name</genus> |
|
| 251 |
</taxonverbatim> |
|
| 248 | 252 |
</taxonlabel> |
| 249 | 253 |
</taxonlabel_id> |
| 250 | 254 |
</taxondetermination> |
| ... | ... | |
| 255 | 259 |
</path> |
| 256 | 260 |
</_simplifyPath> |
| 257 | 261 |
</VegBIEN> |
| 258 |
Inserted 38 new rows into database |
|
| 262 |
Inserted 42 new rows into database |
|
| inputs/UNCC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 51 | 51 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then/_alt/2", |
| 52 | 52 |
infraname,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 53 | 53 |
authors,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2", |
| 54 |
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
|
| 55 |
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 56 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 57 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 58 | 54 |
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 59 | 55 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 60 | 56 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| ... | ... | |
| 66 | 62 |
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2, |
| 67 | 63 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/1", |
| 68 | 64 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank/_alt/2", |
| 69 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/1", |
|
| 70 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank/_alt/2", |
|
| 65 |
usdaRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank/_alt/1",
|
|
| 66 |
infrarank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank/_alt/2",
|
|
| 71 | 67 |
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 72 | 68 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 73 | 69 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 74 | 70 |
infraname,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 75 | 71 |
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank/_alt/1, |
| 76 | 72 |
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank/_alt/2, |
| 77 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 78 |
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank/_alt/1, |
|
| 79 |
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank/_alt/2, |
|
| 73 |
authors,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author, |
|
| 74 |
SciName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 75 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 76 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 77 |
species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 78 |
usdaRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank/_alt/1, |
|
| 79 |
infrarank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank/_alt/2, |
|
| 80 | 80 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/1, |
| 81 | 81 |
collector1,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/2, |
| 82 | 82 |
collector2,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join/3, |
| inputs/UNCC/Specimen/test.xml.ref | ||
|---|---|---|
| 115 | 115 |
</identifyingtaxonomicname> |
| 116 | 116 |
</taxonlabel> |
| 117 | 117 |
</matched_label_id> |
| 118 |
<author>$authors</author> |
|
| 119 |
<binomial>$SciName</binomial> |
|
| 120 |
<family>$family</family> |
|
| 121 |
<genus>$genus</genus> |
|
| 122 | 118 |
<identifyingtaxonomicname> |
| 123 | 119 |
<_join_words> |
| 124 | 120 |
<1> |
| ... | ... | |
| 160 | 156 |
<2>$infrarank</2> |
| 161 | 157 |
</_alt> |
| 162 | 158 |
</rank> |
| 163 |
<verbatimrank> |
|
| 164 |
<_alt> |
|
| 165 |
<1>$usdaRank</1> |
|
| 166 |
<2>$infrarank</2> |
|
| 167 |
</_alt> |
|
| 168 |
</verbatimrank> |
|
| 159 |
<taxonverbatim> |
|
| 160 |
<verbatimrank> |
|
| 161 |
<_alt> |
|
| 162 |
<1>$usdaRank</1> |
|
| 163 |
<2>$infrarank</2> |
|
| 164 |
</_alt> |
|
| 165 |
</verbatimrank> |
|
| 166 |
</taxonverbatim> |
|
| 169 | 167 |
<parent_id> |
| 170 | 168 |
<taxonlabel> |
| 171 | 169 |
<rank>cultivar</rank> |
| ... | ... | |
| 213 | 211 |
<2>$infrarank</2> |
| 214 | 212 |
</_alt> |
| 215 | 213 |
</rank> |
| 216 |
<species>$species</species> |
|
| 217 |
<verbatimrank> |
|
| 218 |
<_alt> |
|
| 219 |
<1>$usdaRank</1> |
|
| 220 |
<2>$infrarank</2> |
|
| 221 |
</_alt> |
|
| 222 |
</verbatimrank> |
|
| 214 |
<taxonverbatim> |
|
| 215 |
<author>$authors</author> |
|
| 216 |
<binomial>$SciName</binomial> |
|
| 217 |
<family>$family</family> |
|
| 218 |
<genus>$genus</genus> |
|
| 219 |
<species>$species</species> |
|
| 220 |
<verbatimrank> |
|
| 221 |
<_alt> |
|
| 222 |
<1>$usdaRank</1> |
|
| 223 |
<2>$infrarank</2> |
|
| 224 |
</_alt> |
|
| 225 |
</verbatimrank> |
|
| 226 |
</taxonverbatim> |
|
| 223 | 227 |
</taxonlabel> |
| 224 | 228 |
</taxonlabel_id> |
| 225 | 229 |
</taxondetermination> |
| ... | ... | |
| 257 | 261 |
</path> |
| 258 | 262 |
</_simplifyPath> |
| 259 | 263 |
</VegBIEN> |
| 260 |
Inserted 23 new rows into database |
|
| 264 |
Inserted 25 new rows into database |
|
| inputs/ACAD/Specimen/VegBIEN.csv | ||
|---|---|---|
| 28 | 28 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 29 | 29 |
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 30 | 30 |
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2", |
| 31 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
|
| 32 | 31 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/1/_*/date/_dateRangeStart/value, |
| 33 | 32 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 34 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 35 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 36 | 33 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1, |
| 37 | 34 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 38 | 35 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| ... | ... | |
| 42 | 39 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
| 43 | 40 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2, |
| 44 | 41 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 45 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank", |
|
| 42 |
taxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
|
|
| 46 | 43 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 47 | 44 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 48 | 45 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| ... | ... | |
| 52 | 49 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 53 | 50 |
infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 54 | 51 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank, |
| 55 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 56 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonomicname, |
|
| 57 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank, |
|
| 52 |
scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author, |
|
| 53 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 54 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 55 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 56 |
scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/taxonomicname, |
|
| 57 |
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank, |
|
| 58 | 58 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
| 59 | 59 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 60 | 60 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| inputs/ACAD/Specimen/test.xml.ref | ||
|---|---|---|
| 107 | 107 |
</identifyingtaxonomicname> |
| 108 | 108 |
</taxonlabel> |
| 109 | 109 |
</matched_label_id> |
| 110 |
<author>$scientificNameAuthorship</author> |
|
| 111 | 110 |
<creationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></creationdate> |
| 112 | 111 |
<creator_id> |
| 113 | 112 |
<_simplifyPath> |
| ... | ... | |
| 115 | 114 |
<path><party><fullname>$identifiedBy</fullname></party></path> |
| 116 | 115 |
</_simplifyPath> |
| 117 | 116 |
</creator_id> |
| 118 |
<family>$family</family> |
|
| 119 |
<genus>$genus</genus> |
|
| 120 | 117 |
<identifyingtaxonomicname> |
| 121 | 118 |
<_alt> |
| 122 | 119 |
<1>$scientificName</1> |
| ... | ... | |
| 148 | 145 |
<parent_id> |
| 149 | 146 |
<taxonlabel> |
| 150 | 147 |
<rank>$taxonRank</rank> |
| 151 |
<verbatimrank>$taxonRank</verbatimrank>
|
|
| 148 |
<taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim>
|
|
| 152 | 149 |
<parent_id> |
| 153 | 150 |
<taxonlabel> |
| 154 | 151 |
<rank>cultivar</rank> |
| ... | ... | |
| 215 | 212 |
</taxonlabel> |
| 216 | 213 |
</parent_id> |
| 217 | 214 |
<rank>$taxonRank</rank> |
| 218 |
<species>$specificEpithet</species> |
|
| 219 |
<taxonomicname>$scientificName</taxonomicname> |
|
| 220 |
<verbatimrank>$taxonRank</verbatimrank> |
|
| 215 |
<taxonverbatim> |
|
| 216 |
<author>$scientificNameAuthorship</author> |
|
| 217 |
<family>$family</family> |
|
| 218 |
<genus>$genus</genus> |
|
| 219 |
<species>$specificEpithet</species> |
|
| 220 |
<taxonomicname>$scientificName</taxonomicname> |
|
| 221 |
<verbatimrank>$taxonRank</verbatimrank> |
|
| 222 |
</taxonverbatim> |
|
| 221 | 223 |
</taxonlabel> |
| 222 | 224 |
</taxonlabel_id> |
| 223 | 225 |
<determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate> |
| ... | ... | |
| 251 | 253 |
</path> |
| 252 | 254 |
</_simplifyPath> |
| 253 | 255 |
</VegBIEN> |
| 254 |
Inserted 35 new rows into database |
|
| 256 |
Inserted 39 new rows into database |
|
| inputs/.NCBI/higher_taxa/VegBIEN.csv | ||
|---|---|---|
| 6 | 6 |
name_txt,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6, |
| 7 | 7 |
parent tax_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/cond/_exists", |
| 8 | 8 |
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 9 |
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank", |
|
| 9 |
rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
|
|
| 10 | 10 |
rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank, |
| 11 | 11 |
tax_id,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode, |
| 12 | 12 |
name_txt,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonepithet, |
| 13 |
rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank, |
|
| 13 |
rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank,
|
|
| 14 | 14 |
4,,** No join mapping for *4 ** |
| 15 | 15 |
5,,** No join mapping for *5 ** |
| 16 | 16 |
6,,** No join mapping for *6 ** |
| inputs/CTFS/StemObservation/VegBIEN.csv | ||
|---|---|---|
| 26 | 26 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 27 | 27 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4", |
| 28 | 28 |
SpeciesAuthority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2", |
| 29 |
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
|
| 30 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 31 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 32 | 29 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 33 | 30 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 34 | 31 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| ... | ... | |
| 38 | 35 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 39 | 36 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 40 | 37 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 41 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 38 |
SpeciesAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author, |
|
| 39 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 40 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 41 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 42 | 42 |
Description,,** No join mapping for *Description ** |
| 43 | 43 |
ExactDate,,** No join mapping for *ExactDate ** |
| 44 | 44 |
FamilyID,,** No join mapping for *FamilyID ** |
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 13 | 13 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2", |
| 14 | 14 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 15 | 15 |
SubSpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4", |
| 16 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 17 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 18 | 16 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 19 | 17 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 20 | 18 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| ... | ... | |
| 23 | 21 |
SpeciesName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 24 | 22 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 25 | 23 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 26 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 24 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 25 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 26 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 27 | 27 |
Description,,** No join mapping for *Description ** |
| 28 | 28 |
FamilyID,,** No join mapping for *FamilyID ** |
| 29 | 29 |
FieldFamily,,** No join mapping for *FieldFamily ** |
| inputs/FIA/Organism/VegBIEN.csv | ||
|---|---|---|
| 18 | 18 |
TreeTag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/2", |
| 19 | 19 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2", |
| 20 | 20 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 21 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 22 | 21 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 23 | 22 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| 24 | 23 |
SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 25 | 24 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 26 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 25 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 26 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 27 | 27 |
County,/location/locationplace/*_id/placepath/county, |
| 28 | 28 |
StateProvince,/location/locationplace/*_id/placepath/stateprovince, |
| 29 | 29 |
HOM,,** No join mapping for *HOM ** |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 64 | 64 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 65 | 65 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 66 | 66 |
auth,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName. |
| 67 |
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,Brad: This is the author of the scientificName. |
|
| 68 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 69 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 70 | 67 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 71 | 68 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 72 | 69 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| ... | ... | |
| 75 | 72 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
| 76 | 73 |
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,Brad: This is the author of the scientificName. |
| 77 | 74 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 78 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank", |
|
| 75 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
|
|
| 79 | 76 |
Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 80 | 77 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 81 | 78 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 82 | 79 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 83 | 80 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank, |
| 84 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 85 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank, |
|
| 81 |
auth,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,Brad: This is the author of the scientificName. |
|
| 82 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 83 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 84 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 85 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank, |
|
| 86 | 86 |
cfaff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank." |
| 87 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family,Brad: OMIT |
|
| 88 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
|
| 89 | 87 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
| 90 | 88 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 91 | 89 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
| ... | ... | |
| 95 | 93 |
OrigSpecies,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",Brad: OMIT |
| 96 | 94 |
OrigGenus,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 97 | 95 |
OrigFamily,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",Brad: OMIT |
| 98 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/species,Brad: OMIT |
|
| 96 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/family,Brad: OMIT |
|
| 97 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 98 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/species,Brad: OMIT |
|
| 99 | 99 |
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above |
| 100 | 100 |
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| 101 | 101 |
DetType,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
| inputs/.TNRS/tnrs/VegBIEN.csv | ||
|---|---|---|
| 10 | 10 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 11 | 11 |
Infraspecific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 12 | 12 |
Name_matched_author,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",Contains author based on matched name |
| 13 |
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/author, |
|
| 14 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/binomial, |
|
| 15 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/family, |
|
| 16 | 13 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 17 | 14 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 18 | 15 |
Accepted_name_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| ... | ... | |
| 20 | 17 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=NCBI,rank=family]/taxonepithet", |
| 21 | 18 |
Accepted_name_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 22 | 19 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/parent_id/taxonlabel/rank, |
| 23 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/parent_id/taxonlabel/verbatimrank, |
|
| 20 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/parent_id/taxonlabel/taxonverbatim/verbatimrank,
|
|
| 24 | 21 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/rank, |
| 25 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/verbatimrank, |
|
| 26 |
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,Contains author based on matched name |
|
| 27 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 28 |
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family,Contains family based on matched name |
|
| 29 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 22 |
Accepted_name_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/author, |
|
| 23 |
Accepted_name,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/binomial, |
|
| 24 |
Accepted_name_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/family, |
|
| 25 |
Accepted_name_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_taxonlabel_set_matched_label_id/matched_label_id/taxonlabel/taxonverbatim/verbatimrank, |
|
| 30 | 26 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 31 | 27 |
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Contains family based on matched name |
| 32 | 28 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| ... | ... | |
| 37 | 33 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 38 | 34 |
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
| 39 | 35 |
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,Contains author based on matched name |
| 40 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 41 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/morphospecies/_if[@name=""if has verbatim name""]/else", |
|
| 42 | 36 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 43 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank", |
|
| 37 |
Name_matched_rank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
|
|
| 44 | 38 |
Specific_epithet_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 45 | 39 |
Genus_matched,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 46 | 40 |
Name_matched_accepted_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",Contains family based on matched name |
| 47 | 41 |
Infraspecific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 48 | 42 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank, |
| 49 | 43 |
Name_matched_url,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/sourceaccessioncode, |
| 50 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 51 |
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/author,Contains author in original string |
|
| 52 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/binomial, |
|
| 53 |
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/family,Contains family in original string (uncommon) |
|
| 54 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/genus, |
|
| 55 | 44 |
Name_submitted,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/identifyingtaxonomicname, |
| 56 | 45 |
Family_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/1, |
| 57 | 46 |
Genus_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/2, |
| 58 | 47 |
Specific_epithet_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/3, |
| 59 | 48 |
Overall_score,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_max/4,Assuming is a fraction based on the range of values |
| 60 |
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies, |
|
| 61 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 62 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/species, |
|
| 63 |
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/verbatimrank, |
|
| 49 |
Author_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/author,Contains author in original string |
|
| 50 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/binomial, |
|
| 51 |
Family_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/family,Contains family in original string (uncommon) |
|
| 52 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/genus, |
|
| 53 |
Unmatched_terms,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies, |
|
| 54 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 55 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/species, |
|
| 56 |
Infraspecific_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/taxonverbatim/verbatimrank, |
|
| 64 | 57 |
Taxonomic_status,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonstatus, |
| 65 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank, |
|
| 58 |
Name_matched_author,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,Contains author based on matched name |
|
| 59 |
Name_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 60 |
Name_matched_accepted_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family,Contains family based on matched name |
|
| 61 |
Genus_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 62 |
Name_submitted,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/cond/_exists", |
|
| 63 |
Unmatched_terms,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/morphospecies/_if[@name=""if has verbatim name""]/else", |
|
| 64 |
Specific_epithet_matched,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 65 |
Name_matched_rank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank, |
|
| 66 | 66 |
Accepted_name_lsid,,** No join mapping for *Accepted_name_lsid ** |
| 67 | 67 |
Accepted_name_species,,** No join mapping for *Accepted_name_species ** Also contains genus. Omitted because Accepted_name contains more info. |
| 68 | 68 |
Accepted_name_url,,** No join mapping for *Accepted_name_url ** |
| inputs/U/Specimen/test.xml.ref | ||
|---|---|---|
| 101 | 101 |
<path><party><fullname>$Detby</fullname></party></path> |
| 102 | 102 |
</_simplifyPath> |
| 103 | 103 |
</creator_id> |
| 104 |
<family>$Family</family> |
|
| 105 |
<genus>$Genus</genus> |
|
| 106 | 104 |
<identifyingtaxonomicname> |
| 107 | 105 |
<_join_words> |
| 108 | 106 |
<1>$Family</1> |
| ... | ... | |
| 150 | 148 |
</parent_id> |
| 151 | 149 |
</taxonlabel> |
| 152 | 150 |
</parent_id> |
| 151 |
<taxonverbatim> |
|
| 152 |
<family>$Family</family> |
|
| 153 |
<genus>$Genus</genus> |
|
| 154 |
</taxonverbatim> |
|
| 153 | 155 |
</taxonlabel> |
| 154 | 156 |
</taxonlabel_id> |
| 155 | 157 |
<determinationdate> |
| ... | ... | |
| 204 | 206 |
</path> |
| 205 | 207 |
</_simplifyPath> |
| 206 | 208 |
</VegBIEN> |
| 207 |
Inserted 30 new rows into database |
|
| 209 |
Inserted 32 new rows into database |
|
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 21 | 21 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
| 22 | 22 |
InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 23 | 23 |
AuthorOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2", |
| 24 |
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author, |
|
| 25 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 26 | 24 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 27 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 28 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 29 | 25 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 30 | 26 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 31 | 27 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| ... | ... | |
| 37 | 33 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 38 | 34 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 39 | 35 |
InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 40 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 41 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial, |
|
| 42 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
|
| 43 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
|
| 36 |
AuthorOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author, |
|
| 37 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 38 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 39 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 40 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 44 | 41 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 45 | 42 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 46 | 43 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| ... | ... | |
| 49 | 46 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 50 | 47 |
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 51 | 48 |
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 49 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 50 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/family, |
|
| 51 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 52 | 52 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 53 | 53 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 54 | 54 |
Locality,/location/locationnarrative/_merge/1, |
| inputs/SpeciesLink/Specimen/VegBIEN.csv | ||
|---|---|---|
| 116 | 116 |
dwc_terms_scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/1", |
| 117 | 117 |
conceptual_darwin_2003_1_0_ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/2", |
| 118 | 118 |
dwc_dwcore_AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2/_alt/3", |
| 119 |
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/1, |
|
| 120 |
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/2, |
|
| 121 |
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author/_alt/3, |
|
| 122 |
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 123 |
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 124 |
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 125 | 119 |
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/1/_*/date/_dateRangeStart/value, |
| 126 | 120 |
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 127 | 121 |
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| ... | ... | |
| 129 | 123 |
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 130 | 124 |
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 131 | 125 |
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/creator_id/_simplifyPath:[next=creator_id]/path/party/fullname/_alt/2, |
| 132 |
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 133 |
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 134 |
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 135 |
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 136 |
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 137 |
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 138 | 126 |
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 139 | 127 |
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 140 | 128 |
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| ... | ... | |
| 179 | 167 |
dwc_terms_kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,order,class,phylum,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=kingdom]/taxonepithet", |
| 180 | 168 |
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 181 | 169 |
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 182 |
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 183 |
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 184 |
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 170 |
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author/_alt/1, |
|
| 171 |
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author/_alt/2, |
|
| 172 |
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author/_alt/3, |
|
| 173 |
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 174 |
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 175 |
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 176 |
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 177 |
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 178 |
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 179 |
conceptual_darwin_2003_1_0_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 180 |
dwc_dwcore_Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 181 |
dwc_terms_genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 182 |
conceptual_darwin_2003_1_0_Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 183 |
dwc_dwcore_SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 184 |
dwc_terms_specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 185 | 185 |
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
| 186 | 186 |
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 187 | 187 |
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| inputs/NCU-NCSC/Specimen/test.xml.ref | ||
|---|---|---|
| 77 | 77 |
<identifyingtaxonomicname>$Full Taxon Name</identifyingtaxonomicname> |
| 78 | 78 |
</taxonlabel> |
| 79 | 79 |
</matched_label_id> |
| 80 |
<binomial>$Full Taxon Name</binomial> |
|
| 81 | 80 |
<identifyingtaxonomicname>$Full Taxon Name</identifyingtaxonomicname> |
| 81 |
<taxonverbatim><binomial>$Full Taxon Name</binomial></taxonverbatim> |
|
| 82 | 82 |
</taxonlabel> |
| 83 | 83 |
</taxonlabel_id> |
| 84 | 84 |
</taxondetermination> |
| ... | ... | |
| 98 | 98 |
</path> |
| 99 | 99 |
</_simplifyPath> |
| 100 | 100 |
</VegBIEN> |
| 101 |
Inserted 26 new rows into database |
|
| 101 |
Inserted 28 new rows into database |
|
| inputs/.NCBI/higher_taxa/test.xml.ref | ||
|---|---|---|
| 25 | 25 |
<rank>$rank</rank> |
| 26 | 26 |
<sourceaccessioncode>$tax_id</sourceaccessioncode> |
| 27 | 27 |
<taxonepithet>$name_txt</taxonepithet> |
| 28 |
<verbatimrank>$rank</verbatimrank>
|
|
| 28 |
<taxonverbatim><verbatimrank>$rank</verbatimrank></taxonverbatim>
|
|
| 29 | 29 |
</taxonlabel> |
| 30 | 30 |
</taxonlabel_id> |
| 31 | 31 |
</taxondetermination> |
| ... | ... | |
| 35 | 35 |
</path> |
| 36 | 36 |
</_simplifyPath> |
| 37 | 37 |
</VegBIEN> |
| 38 |
Inserted 9 new rows into database |
|
| 38 |
Inserted 11 new rows into database |
|
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 71 | 71 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
| 72 | 72 |
infra_ep_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2", |
| 73 | 73 |
specific_authority,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/2",Brad: This is the author of the scientificName. |
| 74 |
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/author,Brad: This is the author of the scientificName. |
|
| 75 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 76 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 77 | 74 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 78 | 75 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 79 | 76 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| ... | ... | |
| 82 | 79 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
| 83 | 80 |
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2,Brad: This is the author of the scientificName. |
| 84 | 81 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank", |
| 85 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/verbatimrank", |
|
| 82 |
infra_rank_1,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/taxonverbatim/verbatimrank",
|
|
| 86 | 83 |
specific_epithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 87 | 84 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 88 | 85 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 89 | 86 |
infra_ep_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
| 90 | 87 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/rank, |
| 91 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 92 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/verbatimrank, |
|
| 88 |
specific_authority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/author,Brad: This is the author of the scientificName. |
|
| 89 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 90 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 91 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 92 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/verbatimrank, |
|
| 93 | 93 |
cf_aff,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank." |
| 94 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family,Brad: OMIT |
|
| 95 | 94 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
| 96 | 95 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
| 97 | 96 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
| 98 | 97 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
| 99 | 98 |
orig_species,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",Brad: OMIT |
| 100 | 99 |
orig_family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",Brad: OMIT |
| 101 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/species,Brad: OMIT |
|
| 100 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/family,Brad: OMIT |
|
| 101 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/taxonverbatim/species,Brad: OMIT |
|
| 102 | 102 |
coll_firstname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/1,Brad: See comment above |
| 103 | 103 |
coll_lastname,/location/locationevent/taxonoccurrence/verbatimcollectorname/_join_words/2,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick." |
| 104 | 104 |
det_type,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 180 | 180 |
</identifyingtaxonomicname> |
| 181 | 181 |
</taxonlabel> |
| 182 | 182 |
</matched_label_id> |
| 183 |
<author>$specific_authority</author> |
|
| 184 |
<family>$family</family> |
|
| 185 |
<genus>$genus</genus> |
|
| 186 | 183 |
<identifyingtaxonomicname> |
| 187 | 184 |
<_join_words> |
| 188 | 185 |
<1> |
| ... | ... | |
| 209 | 206 |
<parent_id> |
| 210 | 207 |
<taxonlabel> |
| 211 | 208 |
<rank>$infra_rank_1</rank> |
| 212 |
<verbatimrank>$infra_rank_1</verbatimrank>
|
|
| 209 |
<taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim>
|
|
| 213 | 210 |
<parent_id> |
| 214 | 211 |
<taxonlabel> |
| 215 | 212 |
<rank>cultivar</rank> |
| ... | ... | |
| 252 | 249 |
</taxonlabel> |
| 253 | 250 |
</parent_id> |
| 254 | 251 |
<rank>$infra_rank_1</rank> |
| 255 |
<species>$specific_epithet</species> |
|
| 256 |
<verbatimrank>$infra_rank_1</verbatimrank> |
|
| 252 |
<taxonverbatim> |
|
| 253 |
<author>$specific_authority</author> |
|
| 254 |
<family>$family</family> |
|
| 255 |
<genus>$genus</genus> |
|
| 256 |
<species>$specific_epithet</species> |
|
| 257 |
<verbatimrank>$infra_rank_1</verbatimrank> |
|
| 258 |
</taxonverbatim> |
|
| 257 | 259 |
</taxonlabel> |
| 258 | 260 |
</taxonlabel_id> |
| 259 | 261 |
<taxonfit>$cf_aff</taxonfit> |
| ... | ... | |
| 262 | 264 |
<isoriginal>true</isoriginal> |
| 263 | 265 |
<taxonlabel_id> |
| 264 | 266 |
<taxonlabel> |
| 265 |
<family>$orig_family</family> |
|
| 266 | 267 |
<identifyingtaxonomicname> |
| 267 | 268 |
<_join_words> |
| 268 | 269 |
<1>$orig_family</1> |
| ... | ... | |
| 326 | 327 |
</parent_id> |
| 327 | 328 |
</taxonlabel> |
| 328 | 329 |
</parent_id> |
| 329 |
<species>$orig_species</species> |
|
| 330 |
<taxonverbatim> |
|
| 331 |
<family>$orig_family</family> |
|
| 332 |
<species>$orig_species</species> |
|
| 333 |
</taxonverbatim> |
|
| 330 | 334 |
</taxonlabel> |
| 331 | 335 |
</taxonlabel_id> |
| 332 | 336 |
</taxondetermination> |
| ... | ... | |
| 364 | 368 |
</path> |
| 365 | 369 |
</_simplifyPath> |
| 366 | 370 |
</VegBIEN> |
| 367 |
Inserted 48 new rows into database |
|
| 371 |
Inserted 52 new rows into database |
|
| inputs/CVS/Organism/VegBIEN.csv | ||
|---|---|---|
| 11 | 11 |
authorObsCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 12 | 12 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
| 13 | 13 |
currentTaxonName sec Weakley 2006,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1", |
| 14 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/binomial, |
|
| 15 | 14 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
| 15 |
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/binomial, |
|
| 16 | 16 |
county,/location/locationplace/*_id/placepath/county, |
| 17 | 17 |
state,/location/locationplace/*_id/placepath/stateprovince, |
| 18 | 18 |
confidentialityStatus,,** No join mapping for *confidentialityStatus ** |
| inputs/CVS/Organism/test.xml.ref | ||
|---|---|---|
| 42 | 42 |
<identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname> |
| 43 | 43 |
</taxonlabel> |
| 44 | 44 |
</matched_label_id> |
| 45 |
<binomial>$currentTaxonName sec Weakley 2006</binomial> |
|
| 46 | 45 |
<identifyingtaxonomicname>$currentTaxonName sec Weakley 2006</identifyingtaxonomicname> |
| 46 |
<taxonverbatim><binomial>$currentTaxonName sec Weakley 2006</binomial></taxonverbatim> |
|
| 47 | 47 |
</taxonlabel> |
| 48 | 48 |
</taxonlabel_id> |
| 49 | 49 |
</taxondetermination> |
| ... | ... | |
| 61 | 61 |
</path> |
| 62 | 62 |
</_simplifyPath> |
| 63 | 63 |
</VegBIEN> |
| 64 |
Inserted 17 new rows into database |
|
| 64 |
Inserted 19 new rows into database |
|
| inputs/REMIB/Specimen/VegBIEN.csv | ||
|---|---|---|
| 36 | 36 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1", |
| 37 | 37 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2", |
| 38 | 38 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1", |
| 39 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/family, |
|
| 40 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/genus, |
|
| 41 | 39 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
| 42 | 40 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 43 | 41 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| 44 | 42 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
| 45 | 43 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 46 | 44 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet", |
| 47 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/species, |
|
| 45 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/family, |
|
| 46 |
genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/genus, |
|
| 47 |
specificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/taxonverbatim/species, |
|
| 48 | 48 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 49 | 49 |
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]
|
| 50 | 50 |
|
| inputs/REMIB/Specimen/test.xml.ref | ||
|---|---|---|
| 81 | 81 |
</identifyingtaxonomicname> |
| 82 | 82 |
</taxonlabel> |
| 83 | 83 |
</matched_label_id> |
| 84 |
<family>$family</family> |
|
| 85 |
<genus>$genus</genus> |
|
| 86 | 84 |
<identifyingtaxonomicname> |
| 87 | 85 |
<_join_words> |
| 88 | 86 |
<1>$family</1> |
| ... | ... | |
| 132 | 130 |
</parent_id> |
| 133 | 131 |
</taxonlabel> |
| 134 | 132 |
</parent_id> |
| 135 |
<species>$specificEpithet</species> |
|
| 133 |
<taxonverbatim> |
|
| 134 |
<family>$family</family> |
|
| 135 |
<genus>$genus</genus> |
|
| 136 |
<species>$specificEpithet</species> |
|
| 137 |
</taxonverbatim> |
|
| 136 | 138 |
</taxonlabel> |
| 137 | 139 |
</taxonlabel_id> |
| 138 | 140 |
</taxondetermination> |
| ... | ... | |
| 163 | 165 |
</path> |
| 164 | 166 |
</_simplifyPath> |
| 165 | 167 |
</VegBIEN> |
| 166 |
Inserted 26 new rows into database |
|
| 168 |
Inserted 27 new rows into database |
|
| inputs/CTFS/StemObservation/test.xml.ref | ||
|---|---|---|
| 64 | 64 |
</identifyingtaxonomicname> |
| 65 | 65 |
</taxonlabel> |
| 66 | 66 |
</matched_label_id> |
| 67 |
<author>$SpeciesAuthority</author> |
|
| 68 |
<family>$Family</family> |
|
| 69 |
<genus>$Genus</genus> |
|
| 70 | 67 |
<identifyingtaxonomicname> |
| 71 | 68 |
<_join_words> |
| 72 | 69 |
<1> |
| ... | ... | |
| 123 | 120 |
</parent_id> |
| 124 | 121 |
</taxonlabel> |
| 125 | 122 |
</parent_id> |
| 126 |
<species>$SpeciesName</species> |
|
| 123 |
<taxonverbatim> |
|
| 124 |
<author>$SpeciesAuthority</author> |
|
| 125 |
<family>$Family</family> |
|
| 126 |
<genus>$Genus</genus> |
|
| 127 |
<species>$SpeciesName</species> |
|
| 128 |
</taxonverbatim> |
|
| 127 | 129 |
</taxonlabel> |
| 128 | 130 |
</taxonlabel_id> |
| 129 | 131 |
</taxondetermination> |
| ... | ... | |
| 133 | 135 |
</path> |
| 134 | 136 |
</_simplifyPath> |
| 135 | 137 |
</VegBIEN> |
| 136 |
Inserted 19 new rows into database |
|
| 138 |
Inserted 20 new rows into database |
|
| inputs/CTFS/TaxonOccurrence/test.xml.ref | ||
|---|---|---|
| 30 | 30 |
</identifyingtaxonomicname> |
| 31 | 31 |
</taxonlabel> |
| 32 | 32 |
</matched_label_id> |
| 33 |
<family>$Family</family> |
|
| 34 |
<genus>$Genus</genus> |
|
| 35 | 33 |
<identifyingtaxonomicname> |
| 36 | 34 |
<_join_words> |
| 37 | 35 |
<1>$Family</1> |
| ... | ... | |
| 83 | 81 |
</parent_id> |
| 84 | 82 |
</taxonlabel> |
| 85 | 83 |
</parent_id> |
| 86 |
<species>$SpeciesName</species> |
|
| 84 |
<taxonverbatim> |
|
| 85 |
<family>$Family</family> |
|
| 86 |
<genus>$Genus</genus> |
|
| 87 |
<species>$SpeciesName</species> |
|
| 88 |
</taxonverbatim> |
|
| 87 | 89 |
</taxonlabel> |
| 88 | 90 |
</taxonlabel_id> |
| 89 | 91 |
</taxondetermination> |
| ... | ... | |
| 93 | 95 |
</path> |
| 94 | 96 |
</_simplifyPath> |
| 95 | 97 |
</VegBIEN> |
| 96 |
Inserted 18 new rows into database |
|
| 98 |
Inserted 20 new rows into database |
|
| inputs/FIA/Organism/test.xml.ref | ||
|---|---|---|
| 78 | 78 |
</identifyingtaxonomicname> |
| 79 | 79 |
</taxonlabel> |
| 80 | 80 |
</matched_label_id> |
| 81 |
<genus>$Genus</genus> |
|
| 82 | 81 |
<identifyingtaxonomicname> |
| 83 | 82 |
<_join_words> |
| 84 | 83 |
<2>$Genus</2> |
| ... | ... | |
| 121 | 120 |
</parent_id> |
| 122 | 121 |
</taxonlabel> |
| 123 | 122 |
</parent_id> |
| 124 |
<species>$SpecificEpithet</species> |
|
| 123 |
<taxonverbatim> |
|
| 124 |
<genus>$Genus</genus> |
|
| 125 |
<species>$SpecificEpithet</species> |
|
| 126 |
</taxonverbatim> |
|
| 125 | 127 |
</taxonlabel> |
| 126 | 128 |
</taxonlabel_id> |
| 127 | 129 |
</taxondetermination> |
| ... | ... | |
| 139 | 141 |
</path> |
| 140 | 142 |
</_simplifyPath> |
| 141 | 143 |
</VegBIEN> |
| 142 |
Inserted 25 new rows into database |
|
| 144 |
Inserted 27 new rows into database |
|
| inputs/SALVIAS/plotObservations/test.xml.ref | ||
|---|---|---|
| 151 | 151 |
</identifyingtaxonomicname> |
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel: Moved non-scoping fields to new taxonverbatim subclass table, which contains the component parts of the taxonlabel