Revision 7169
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/NCU/Specimen/VegBIEN.csv | ||
|---|---|---|
| 40 | 40 |
CurrentScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1, |
| 41 | 41 |
CurrentScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname, |
| 42 | 42 |
CurrentScientificNameWithAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname, |
| 43 |
OriginalTaxonLabel,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1, |
|
| 44 | 43 |
OriginalTaxonLabel,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonomicname, |
| 45 | 44 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 46 | 45 |
VerbatimLocality,/location/locationnarrative/_merge/2/_alt/1, |
| inputs/NCU/Specimen/test.xml.ref | ||
|---|---|---|
| 99 | 99 |
</taxondetermination> |
| 100 | 100 |
<taxondetermination> |
| 101 | 101 |
<isoriginal>true</isoriginal> |
| 102 |
<taxonverbatim_id> |
|
| 103 |
<taxonverbatim> |
|
| 104 |
<taxonlabel_id><taxonlabel><taxonomicname>$OriginalTaxonLabel</taxonomicname></taxonlabel></taxonlabel_id> |
|
| 105 |
<taxonomicname>$OriginalTaxonLabel</taxonomicname> |
|
| 106 |
</taxonverbatim> |
|
| 107 |
</taxonverbatim_id> |
|
| 102 |
<taxonverbatim_id><taxonverbatim><taxonomicname>$OriginalTaxonLabel</taxonomicname></taxonverbatim></taxonverbatim_id> |
|
| 108 | 103 |
</taxondetermination> |
| 109 | 104 |
</taxonoccurrence> |
| 110 | 105 |
</locationevent> |
| ... | ... | |
| 176 | 171 |
</path> |
| 177 | 172 |
</_setDefault> |
| 178 | 173 |
</VegBIEN> |
| 179 |
Inserted 36 new rows into database |
|
| 174 |
Inserted 32 new rows into database |
|
| inputs/CTFS/TaxonOccurrence/VegBIEN.csv | ||
|---|---|---|
| 17 | 17 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
| 18 | 18 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/_if[@name=""if is canonical name""]/then/matched_label_id/taxonlabel:[source_id/source/shortname=NCBI]/taxonomicname", |
| 19 | 19 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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 |
SpeciesInvID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 21 | 20 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
| 22 | 21 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 23 | 22 |
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 119 | 119 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 120 | 120 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| 121 | 121 |
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." |
| 122 |
OrigSpecies,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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 |
|
| 123 |
OrigGenus,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
|
| 124 |
OrigFamily,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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 |
|
| 125 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,Brad: OMIT |
|
| 126 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 127 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
|
| 128 | 122 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/family,Brad: OMIT |
| 129 | 123 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/genus, |
| 130 | 124 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/specific_epithet,Brad: OMIT |
| inputs/SALVIAS/plotObservations/test.xml.ref | ||
|---|---|---|
| 243 | 243 |
<isoriginal>true</isoriginal> |
| 244 | 244 |
<taxonverbatim_id> |
| 245 | 245 |
<taxonverbatim> |
| 246 |
<taxonlabel_id> |
|
| 247 |
<taxonlabel> |
|
| 248 |
<parent_id> |
|
| 249 |
<taxonlabel> |
|
| 250 |
<parent_id> |
|
| 251 |
<taxonlabel> |
|
| 252 |
<rank>cultivar</rank> |
|
| 253 |
<parent_id> |
|
| 254 |
<taxonlabel> |
|
| 255 |
<rank>forma</rank> |
|
| 256 |
<parent_id> |
|
| 257 |
<taxonlabel> |
|
| 258 |
<rank>variety</rank> |
|
| 259 |
<parent_id> |
|
| 260 |
<taxonlabel> |
|
| 261 |
<rank>subspecies</rank> |
|
| 262 |
<parent_id> |
|
| 263 |
<taxonlabel> |
|
| 264 |
<rank>species</rank> |
|
| 265 |
<taxonepithet>$OrigSpecies</taxonepithet> |
|
| 266 |
<parent_id> |
|
| 267 |
<taxonlabel> |
|
| 268 |
<rank>genus</rank> |
|
| 269 |
<taxonepithet>$OrigGenus</taxonepithet> |
|
| 270 |
<parent_id> |
|
| 271 |
<taxonlabel> |
|
| 272 |
<rank>family</rank> |
|
| 273 |
<taxonepithet>$OrigFamily</taxonepithet> |
|
| 274 |
</taxonlabel> |
|
| 275 |
</parent_id> |
|
| 276 |
</taxonlabel> |
|
| 277 |
</parent_id> |
|
| 278 |
</taxonlabel> |
|
| 279 |
</parent_id> |
|
| 280 |
</taxonlabel> |
|
| 281 |
</parent_id> |
|
| 282 |
</taxonlabel> |
|
| 283 |
</parent_id> |
|
| 284 |
</taxonlabel> |
|
| 285 |
</parent_id> |
|
| 286 |
</taxonlabel> |
|
| 287 |
</parent_id> |
|
| 288 |
</taxonlabel> |
|
| 289 |
</parent_id> |
|
| 290 |
<taxonomicname> |
|
| 291 |
<_merge_prefix> |
|
| 292 |
<prefix><_taxon_family_require_std><family>$OrigFamily</family></_taxon_family_require_std></prefix> |
|
| 293 |
<value> |
|
| 294 |
<_join_words> |
|
| 295 |
<2>$OrigGenus</2> |
|
| 296 |
<3>$OrigSpecies</3> |
|
| 297 |
</_join_words> |
|
| 298 |
</value> |
|
| 299 |
</_merge_prefix> |
|
| 300 |
</taxonomicname> |
|
| 301 |
</taxonlabel> |
|
| 302 |
</taxonlabel_id> |
|
| 303 | 246 |
<family>$OrigFamily</family> |
| 304 | 247 |
<genus>$OrigGenus</genus> |
| 305 | 248 |
<specific_epithet>$OrigSpecies</specific_epithet> |
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 37 | 37 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/genus, |
| 38 | 38 |
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 39 | 39 |
ScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname, |
| 40 |
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
|
| 41 |
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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", |
|
| 42 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
|
| 43 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1, |
|
| 44 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 45 | 40 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/family, |
| 46 | 41 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/genus, |
| 47 | 42 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname, |
| inputs/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 131 | 131 |
<isoriginal>true</isoriginal> |
| 132 | 132 |
<taxonverbatim_id> |
| 133 | 133 |
<taxonverbatim> |
| 134 |
<taxonlabel_id> |
|
| 135 |
<taxonlabel> |
|
| 136 |
<parent_id> |
|
| 137 |
<taxonlabel> |
|
| 138 |
<parent_id> |
|
| 139 |
<taxonlabel> |
|
| 140 |
<rank>cultivar</rank> |
|
| 141 |
<parent_id> |
|
| 142 |
<taxonlabel> |
|
| 143 |
<rank>forma</rank> |
|
| 144 |
<parent_id> |
|
| 145 |
<taxonlabel> |
|
| 146 |
<rank>variety</rank> |
|
| 147 |
<parent_id> |
|
| 148 |
<taxonlabel> |
|
| 149 |
<rank>subspecies</rank> |
|
| 150 |
<parent_id> |
|
| 151 |
<taxonlabel> |
|
| 152 |
<rank>species</rank> |
|
| 153 |
<parent_id> |
|
| 154 |
<taxonlabel> |
|
| 155 |
<rank>genus</rank> |
|
| 156 |
<taxonepithet>$GBIFGenusOriginal</taxonepithet> |
|
| 157 |
<parent_id> |
|
| 158 |
<taxonlabel> |
|
| 159 |
<rank>family</rank> |
|
| 160 |
<taxonepithet>$GBIFFamilyOriginal</taxonepithet> |
|
| 161 |
</taxonlabel> |
|
| 162 |
</parent_id> |
|
| 163 |
</taxonlabel> |
|
| 164 |
</parent_id> |
|
| 165 |
</taxonlabel> |
|
| 166 |
</parent_id> |
|
| 167 |
</taxonlabel> |
|
| 168 |
</parent_id> |
|
| 169 |
</taxonlabel> |
|
| 170 |
</parent_id> |
|
| 171 |
</taxonlabel> |
|
| 172 |
</parent_id> |
|
| 173 |
</taxonlabel> |
|
| 174 |
</parent_id> |
|
| 175 |
</taxonlabel> |
|
| 176 |
</parent_id> |
|
| 177 |
<taxonomicname> |
|
| 178 |
<_merge_prefix> |
|
| 179 |
<prefix><_taxon_family_require_std><family>$GBIFFamilyOriginal</family></_taxon_family_require_std></prefix> |
|
| 180 |
<value> |
|
| 181 |
<_alt> |
|
| 182 |
<1>$ScientificNameOriginal</1> |
|
| 183 |
<2>$GBIFGenusOriginal</2> |
|
| 184 |
</_alt> |
|
| 185 |
</value> |
|
| 186 |
</_merge_prefix> |
|
| 187 |
</taxonomicname> |
|
| 188 |
</taxonlabel> |
|
| 189 |
</taxonlabel_id> |
|
| 190 | 134 |
<family>$GBIFFamilyOriginal</family> |
| 191 | 135 |
<genus>$GBIFGenusOriginal</genus> |
| 192 | 136 |
<taxonname>$ScientificNameOriginal</taxonname> |
| ... | ... | |
| 256 | 200 |
</path> |
| 257 | 201 |
</_setDefault> |
| 258 | 202 |
</VegBIEN> |
| 259 |
Inserted 42 new rows into database |
|
| 203 |
Inserted 36 new rows into database |
|
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 56 | 56 |
Species and morphotypes,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonname,"Contains less than ""Specie+autor""" |
| 57 | 57 |
Specie+autor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/taxonomicname, |
| 58 | 58 |
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 59 |
Field name,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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 |
|
| 60 |
Field family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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", |
|
| 61 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
|
| 62 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera |
|
| 63 | 59 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/family, |
| 64 | 60 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/genus,Often = Genera |
| 65 | 61 |
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| inputs/Madidi/Organism/test.xml.ref | ||
|---|---|---|
| 148 | 148 |
<isoriginal>true</isoriginal> |
| 149 | 149 |
<taxonverbatim_id> |
| 150 | 150 |
<taxonverbatim> |
| 151 |
<taxonlabel_id> |
|
| 152 |
<taxonlabel> |
|
| 153 |
<parent_id> |
|
| 154 |
<taxonlabel> |
|
| 155 |
<parent_id> |
|
| 156 |
<taxonlabel> |
|
| 157 |
<rank>cultivar</rank> |
|
| 158 |
<parent_id> |
|
| 159 |
<taxonlabel> |
|
| 160 |
<rank>forma</rank> |
|
| 161 |
<parent_id> |
|
| 162 |
<taxonlabel> |
|
| 163 |
<rank>variety</rank> |
|
| 164 |
<parent_id> |
|
| 165 |
<taxonlabel> |
|
| 166 |
<rank>subspecies</rank> |
|
| 167 |
<parent_id> |
|
| 168 |
<taxonlabel> |
|
| 169 |
<rank>species</rank> |
|
| 170 |
<parent_id> |
|
| 171 |
<taxonlabel> |
|
| 172 |
<rank>genus</rank> |
|
| 173 |
<taxonepithet>$Field name</taxonepithet> |
|
| 174 |
<parent_id> |
|
| 175 |
<taxonlabel> |
|
| 176 |
<rank>family</rank> |
|
| 177 |
<taxonepithet>$Field family</taxonepithet> |
|
| 178 |
</taxonlabel> |
|
| 179 |
</parent_id> |
|
| 180 |
</taxonlabel> |
|
| 181 |
</parent_id> |
|
| 182 |
</taxonlabel> |
|
| 183 |
</parent_id> |
|
| 184 |
</taxonlabel> |
|
| 185 |
</parent_id> |
|
| 186 |
</taxonlabel> |
|
| 187 |
</parent_id> |
|
| 188 |
</taxonlabel> |
|
| 189 |
</parent_id> |
|
| 190 |
</taxonlabel> |
|
| 191 |
</parent_id> |
|
| 192 |
</taxonlabel> |
|
| 193 |
</parent_id> |
|
| 194 |
<taxonomicname> |
|
| 195 |
<_merge_prefix> |
|
| 196 |
<prefix><_taxon_family_require_std><family>$Field family</family></_taxon_family_require_std></prefix> |
|
| 197 |
<value>$Field name</value> |
|
| 198 |
</_merge_prefix> |
|
| 199 |
</taxonomicname> |
|
| 200 |
</taxonlabel> |
|
| 201 |
</taxonlabel_id> |
|
| 202 | 151 |
<family>$Field family</family> |
| 203 | 152 |
<genus>$Field name</genus> |
| 204 | 153 |
</taxonverbatim> |
| ... | ... | |
| 218 | 167 |
</path> |
| 219 | 168 |
</_setDefault> |
| 220 | 169 |
</VegBIEN> |
| 221 |
Inserted 38 new rows into database |
|
| 170 |
Inserted 32 new rows into database |
|
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 125 | 125 |
specific_epithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/specific_epithet, |
| 126 | 126 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank, |
| 127 | 127 |
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." |
| 128 |
orig_species,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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 |
|
| 129 |
orig_family,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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 |
|
| 130 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family,Brad: OMIT |
|
| 131 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
|
| 132 | 128 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/family,Brad: OMIT |
| 133 | 129 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/specific_epithet,Brad: OMIT |
| 134 | 130 |
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 | ||
|---|---|---|
| 271 | 271 |
<isoriginal>true</isoriginal> |
| 272 | 272 |
<taxonverbatim_id> |
| 273 | 273 |
<taxonverbatim> |
| 274 |
<taxonlabel_id> |
|
| 275 |
<taxonlabel> |
|
| 276 |
<parent_id> |
|
| 277 |
<taxonlabel> |
|
| 278 |
<parent_id> |
|
| 279 |
<taxonlabel> |
|
| 280 |
<rank>cultivar</rank> |
|
| 281 |
<parent_id> |
|
| 282 |
<taxonlabel> |
|
| 283 |
<rank>forma</rank> |
|
| 284 |
<parent_id> |
|
| 285 |
<taxonlabel> |
|
| 286 |
<rank>variety</rank> |
|
| 287 |
<parent_id> |
|
| 288 |
<taxonlabel> |
|
| 289 |
<rank>subspecies</rank> |
|
| 290 |
<parent_id> |
|
| 291 |
<taxonlabel> |
|
| 292 |
<rank>species</rank> |
|
| 293 |
<taxonepithet>$orig_species</taxonepithet> |
|
| 294 |
<parent_id> |
|
| 295 |
<taxonlabel> |
|
| 296 |
<rank>genus</rank> |
|
| 297 |
<parent_id> |
|
| 298 |
<taxonlabel> |
|
| 299 |
<rank>family</rank> |
|
| 300 |
<taxonepithet>$orig_family</taxonepithet> |
|
| 301 |
</taxonlabel> |
|
| 302 |
</parent_id> |
|
| 303 |
</taxonlabel> |
|
| 304 |
</parent_id> |
|
| 305 |
</taxonlabel> |
|
| 306 |
</parent_id> |
|
| 307 |
</taxonlabel> |
|
| 308 |
</parent_id> |
|
| 309 |
</taxonlabel> |
|
| 310 |
</parent_id> |
|
| 311 |
</taxonlabel> |
|
| 312 |
</parent_id> |
|
| 313 |
</taxonlabel> |
|
| 314 |
</parent_id> |
|
| 315 |
</taxonlabel> |
|
| 316 |
</parent_id> |
|
| 317 |
<taxonomicname> |
|
| 318 |
<_merge_prefix> |
|
| 319 |
<prefix><_taxon_family_require_std><family>$orig_family</family></_taxon_family_require_std></prefix> |
|
| 320 |
<value>$orig_species</value> |
|
| 321 |
</_merge_prefix> |
|
| 322 |
</taxonomicname> |
|
| 323 |
</taxonlabel> |
|
| 324 |
</taxonlabel_id> |
|
| 325 | 274 |
<family>$orig_family</family> |
| 326 | 275 |
<specific_epithet>$orig_species</specific_epithet> |
| 327 | 276 |
</taxonverbatim> |
| ... | ... | |
| 363 | 312 |
</path> |
| 364 | 313 |
</_setDefault> |
| 365 | 314 |
</VegBIEN> |
| 366 |
Inserted 45 new rows into database |
|
| 315 |
Inserted 41 new rows into database |
|
| inputs/CVS/stemCount_/VegBIEN.csv | ||
|---|---|---|
| 8 | 8 |
taxonObservation_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
| 9 | 9 |
taxonObservation_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1, |
| 10 | 10 |
STEMCOUNT_ID,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists", |
| 11 |
taxonObservation_ID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 12 | 11 |
taxonObservation_ID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
| 13 | 12 |
basalArea,,** No join mapping for *basalarea ** |
| 14 | 13 |
biomass,,** No join mapping for *biomass ** |
| inputs/CVS/taxonObservation_/VegBIEN.csv | ||
|---|---|---|
| 43 | 43 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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/_alt/2", |
| 44 | 44 |
taxonLevel,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank, |
| 45 | 45 |
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonepithet/_if[@name=""if taxonomic name is epithet""]/cond/_alt:[2=true]/1/_taxonomic_name_is_epithet/rank", |
| 46 |
TAXONOBSERVATION_ID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 47 | 46 |
denorm_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_alt/1, |
| 48 | 47 |
family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family/_alt/2, |
| 49 | 48 |
plantNameWithAuthority,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1, |
| ... | ... | |
| 67 | 66 |
TAXONOBSERVATION_ID,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
| 68 | 67 |
interpretationDate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value, |
| 69 | 68 |
taxonFit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 70 |
authorPlantName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1, |
|
| 71 | 69 |
authorPlantName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname, |
| 72 | 70 |
museumAccessionNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 73 | 71 |
Division,,** No join mapping for *Division/_alt/2 ** |
| inputs/CVS/taxonObservation_/test.xml.ref | ||
|---|---|---|
| 202 | 202 |
</taxondetermination> |
| 203 | 203 |
<taxondetermination> |
| 204 | 204 |
<isoriginal>true</isoriginal> |
| 205 |
<taxonverbatim_id> |
|
| 206 |
<taxonverbatim> |
|
| 207 |
<taxonlabel_id><taxonlabel><taxonomicname>$authorPlantName</taxonomicname></taxonlabel></taxonlabel_id> |
|
| 208 |
<taxonname>$authorPlantName</taxonname> |
|
| 209 |
</taxonverbatim> |
|
| 210 |
</taxonverbatim_id> |
|
| 205 |
<taxonverbatim_id><taxonverbatim><taxonname>$authorPlantName</taxonname></taxonverbatim></taxonverbatim_id> |
|
| 211 | 206 |
</taxondetermination> |
| 212 | 207 |
</taxonoccurrence> |
| 213 | 208 |
</locationevent> |
| ... | ... | |
| 217 | 212 |
</path> |
| 218 | 213 |
</_setDefault> |
| 219 | 214 |
</VegBIEN> |
| 220 |
Inserted 27 new rows into database |
|
| 215 |
Inserted 23 new rows into database |
|
| inputs/VegBank/stemcount_/VegBIEN.csv | ||
|---|---|---|
| 32 | 32 |
HAVING count(distinct taxonimportance_id) > 1 |
| 33 | 33 |
-----" |
| 34 | 34 |
stemcount_id,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/2/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists", |
| 35 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists","Note that taxonimportance is not 1:1 with taxonobservation [1]. |
|
| 36 |
|
|
| 37 |
[1] The following query returns rows: |
|
| 38 |
----- |
|
| 39 |
SELECT taxonobservation_id, count(distinct taxonimportance_id) |
|
| 40 |
FROM ""VegBank"".taxonimportance |
|
| 41 |
GROUP BY taxonobservation_id |
|
| 42 |
HAVING count(distinct taxonimportance_id) > 1 |
|
| 43 |
-----" |
|
| 44 | 35 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists","Note that taxonimportance is not 1:1 with taxonobservation [1]. |
| 45 | 36 |
|
| 46 | 37 |
[1] The following query returns rows: |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 31 | 31 |
Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet", |
| 32 | 32 |
Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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", |
| 33 | 33 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_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", |
| 34 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel:[@fkey=matched_label_id]/matched_label_fit_fraction/_if[@name=""if has taxondetermination""]/cond/_exists", |
|
| 35 | 34 |
Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
| 36 | 35 |
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
| 37 | 36 |
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3/_join_words/1, |
| ... | ... | |
| 44 | 43 |
taxonobservation_id,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/_if[@name=""if has taxondetermination""]/cond/_exists", |
| 45 | 44 |
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_dateRangeStart/value, |
| 46 | 45 |
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 47 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1, |
|
| 48 | 46 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname, |
| 49 | 47 |
museumaccessionnumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 50 | 48 |
Division,,** No join mapping for *Division ** |
| inputs/VegBank/taxonobservation_/test.xml.ref | ||
|---|---|---|
| 137 | 137 |
</taxondetermination> |
| 138 | 138 |
<taxondetermination> |
| 139 | 139 |
<isoriginal>true</isoriginal> |
| 140 |
<taxonverbatim_id> |
|
| 141 |
<taxonverbatim> |
|
| 142 |
<taxonlabel_id><taxonlabel><taxonomicname>$authorplantname</taxonomicname></taxonlabel></taxonlabel_id> |
|
| 143 |
<taxonname>$authorplantname</taxonname> |
|
| 144 |
</taxonverbatim> |
|
| 145 |
</taxonverbatim_id> |
|
| 140 |
<taxonverbatim_id><taxonverbatim><taxonname>$authorplantname</taxonname></taxonverbatim></taxonverbatim_id> |
|
| 146 | 141 |
</taxondetermination> |
| 147 | 142 |
</taxonoccurrence> |
| 148 | 143 |
</locationevent> |
| ... | ... | |
| 152 | 147 |
</path> |
| 153 | 148 |
</_setDefault> |
| 154 | 149 |
</VegBIEN> |
| 155 |
Inserted 20 new rows into database |
|
| 150 |
Inserted 14 new rows into database |
|
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 250 | 250 |
identificationType,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationtype, |
| 251 | 251 |
taxonRemarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes, |
| 252 | 252 |
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 253 |
originalCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=cultivar]/taxonepithet", |
|
| 254 |
originalForma,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=forma]/taxonepithet", |
|
| 255 |
originalVariety,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet", |
|
| 256 |
originalSubspecies,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=subspecies]/taxonepithet", |
|
| 257 |
originalSpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet", |
|
| 258 |
originalGenus,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet", |
|
| 259 |
originalFamily,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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", |
|
| 260 |
originalOrder,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,family,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=order]/taxonepithet", |
|
| 261 |
originalClass,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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", |
|
| 262 |
originalPhylum,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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", |
|
| 263 |
originalKingdom,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_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", |
|
| 264 |
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/rank, |
|
| 265 |
originalInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
|
| 266 |
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonverbatim/verbatimrank, |
|
| 267 |
originalTaxonRank,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/rank, |
|
| 268 |
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/prefix/_taxon_family_require_std/family, |
|
| 269 |
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/1, |
|
| 270 |
originalTaxonName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/1, |
|
| 271 |
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 272 |
originalSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 273 |
originalSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/4, |
|
| 274 |
originalInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
|
| 275 |
originalTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
|
| 276 |
originalInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
|
| 277 |
originalVariety,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2", |
|
| 278 |
originalForma,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2", |
|
| 279 |
originalCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2", |
|
| 280 |
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2, |
|
| 281 | 253 |
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/author, |
| 282 | 254 |
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/family, |
| 283 | 255 |
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/genus, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 250 | 250 |
identificationType,//taxonoccurrence/taxondetermination[]/determinationtype, |
| 251 | 251 |
taxonRemarks,//taxonoccurrence/taxondetermination[]/notes, |
| 252 | 252 |
identificationQualifier,//taxonoccurrence/taxondetermination[]/taxonfit, |
| 253 |
originalCultivar,//taxonlabel/parent_id[rank=cultivar]/taxonepithet, |
|
| 254 |
originalForma,//taxonlabel/parent_id[rank=forma]/taxonepithet, |
|
| 255 |
originalVariety,//taxonlabel/parent_id[rank=variety]/taxonepithet, |
|
| 256 |
originalSubspecies,//taxonlabel/parent_id[rank=subspecies]/taxonepithet, |
|
| 257 |
originalSpecificEpithet,//taxonlabel/parent_id[rank=species]/taxonepithet, |
|
| 258 |
originalGenus,//taxonlabel/parent_id[rank=genus]/taxonepithet, |
|
| 259 |
originalFamily,//taxonlabel/parent_id[rank=family]/taxonepithet, |
|
| 260 |
originalOrder,//taxonlabel/parent_id[rank=order]/taxonepithet, |
|
| 261 |
originalClass,//taxonlabel/parent_id[rank=class]/taxonepithet, |
|
| 262 |
originalPhylum,//taxonlabel/parent_id[rank=phylum]/taxonepithet, |
|
| 263 |
originalKingdom,//taxonlabel/parent_id[rank=kingdom]/taxonepithet, |
|
| 264 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/rank, |
|
| 265 |
originalInfraspecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonepithet, |
|
| 266 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/taxonverbatim/verbatimrank, |
|
| 267 |
originalTaxonRank,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/rank, |
|
| 268 |
originalFamily,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 269 |
originalScientificName,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 270 |
originalTaxonName,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 271 |
originalGenus,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 272 |
originalSpecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 273 |
originalSubspecies,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 274 |
originalInfraspecificEpithet,"//taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/cond", |
|
| 275 |
originalTaxonRank,"//taxonlabel/taxonomicname/_if[@name=""if has infraspecificEpithet""]/then", |
|
| 276 |
originalInfraspecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 277 |
originalVariety,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 278 |
originalForma,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 279 |
originalCultivar,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 280 |
originalScientificNameAuthorship,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname, |
|
| 281 | 253 |
originalScientificNameAuthorship,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/author, |
| 282 | 254 |
originalFamily,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/family, |
| 283 | 255 |
originalGenus,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/genus, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Removed taxonlabel for original taxondetermination, because the original taxondetermination is not scrubbed by scrub.make (only the most current taxondetermination gets scrubbed, because only a single scrubbed determination is added by scrub.make). This still leaves the original taxondetermination's taxonverbatim, which stores the taxonomic information for historical purposes.