Revision 5650
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/Madidi/Organism/VegBIEN.csv | ||
|---|---|---|
| 55 | 55 |
Qualifier,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 56 | 56 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
| 57 | 57 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus,Often = Genera |
| 58 |
Field family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 59 |
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2,Often = Genera |
|
| 58 | 60 |
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, |
| 59 | 61 |
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 |
| 60 | 62 |
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 |
| inputs/Madidi/Organism/test.xml.ref | ||
|---|---|---|
| 182 | 182 |
<taxonlabel> |
| 183 | 183 |
<family>$Field family</family> |
| 184 | 184 |
<genus>$Field name</genus> |
| 185 |
<identifyingtaxonomicname> |
|
| 186 |
<_join_words> |
|
| 187 |
<1>$Field family</1> |
|
| 188 |
<2>$Field name</2> |
|
| 189 |
</_join_words> |
|
| 190 |
</identifyingtaxonomicname> |
|
| 185 | 191 |
<matched_label_id> |
| 186 | 192 |
<taxonlabel> |
| 187 | 193 |
<creator_id> |
| ... | ... | |
| 249 | 255 |
</path> |
| 250 | 256 |
</_simplifyPath> |
| 251 | 257 |
</VegBIEN> |
| 252 |
Inserted 36 new rows into database |
|
| 258 |
Inserted 38 new rows into database |
|
| inputs/SALVIAS-CSV/Organism/VegBIEN.csv | ||
|---|---|---|
| 92 | 92 |
infra_rank_1,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonlabel/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 | 94 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family,Brad: OMIT |
| 95 |
orig_family,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
|
| 96 |
orig_species,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
|
| 95 | 97 |
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 |
| 96 | 98 |
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 |
| 97 | 99 |
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 |
| inputs/SALVIAS-CSV/Organism/test.xml.ref | ||
|---|---|---|
| 263 | 263 |
<taxonlabel_id> |
| 264 | 264 |
<taxonlabel> |
| 265 | 265 |
<family>$orig_family</family> |
| 266 |
<identifyingtaxonomicname> |
|
| 267 |
<_join_words> |
|
| 268 |
<1>$orig_family</1> |
|
| 269 |
<3>$orig_species</3> |
|
| 270 |
</_join_words> |
|
| 271 |
</identifyingtaxonomicname> |
|
| 266 | 272 |
<matched_label_id> |
| 267 | 273 |
<taxonlabel> |
| 268 | 274 |
<creator_id> |
| inputs/SALVIAS/plotObservations/VegBIEN.csv | ||
|---|---|---|
| 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 | 87 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family,Brad: OMIT |
| 88 | 88 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
| 89 |
OrigFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1,Brad: OMIT |
|
| 90 |
OrigGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 91 |
OrigSpecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3,Brad: OMIT |
|
| 89 | 92 |
OrigFamily,/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 |
| 90 | 93 |
OrigGenus,/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, |
| 91 | 94 |
OrigSpecies,/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 |
| inputs/SALVIAS/plotObservations/test.xml.ref | ||
|---|---|---|
| 235 | 235 |
<taxonlabel> |
| 236 | 236 |
<family>$OrigFamily</family> |
| 237 | 237 |
<genus>$OrigGenus</genus> |
| 238 |
<identifyingtaxonomicname> |
|
| 239 |
<_join_words> |
|
| 240 |
<1>$OrigFamily</1> |
|
| 241 |
<2>$OrigGenus</2> |
|
| 242 |
<3>$OrigSpecies</3> |
|
| 243 |
</_join_words> |
|
| 244 |
</identifyingtaxonomicname> |
|
| 238 | 245 |
<matched_label_id> |
| 239 | 246 |
<taxonlabel> |
| 240 | 247 |
<creator_id> |
| ... | ... | |
| 332 | 339 |
</path> |
| 333 | 340 |
</_simplifyPath> |
| 334 | 341 |
</VegBIEN> |
| 335 |
Inserted 43 new rows into database |
|
| 342 |
Inserted 45 new rows into database |
|
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 41 | 41 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial, |
| 42 | 42 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
| 43 | 43 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
| 44 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 45 |
GBIFFamilyOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 46 |
GBIFGenusOriginal,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 44 | 47 |
ScientificNameOriginal,/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/1, |
| 45 | 48 |
GBIFFamilyOriginal,/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, |
| 46 | 49 |
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, |
| inputs/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 159 | 159 |
<binomial>$ScientificNameOriginal</binomial> |
| 160 | 160 |
<family>$GBIFFamilyOriginal</family> |
| 161 | 161 |
<genus>$GBIFGenusOriginal</genus> |
| 162 |
<identifyingtaxonomicname> |
|
| 163 |
<_alt> |
|
| 164 |
<1>$ScientificNameOriginal</1> |
|
| 165 |
<2> |
|
| 166 |
<_join_words> |
|
| 167 |
<1>$GBIFFamilyOriginal</1> |
|
| 168 |
<2>$GBIFGenusOriginal</2> |
|
| 169 |
</_join_words> |
|
| 170 |
</2> |
|
| 171 |
</_alt> |
|
| 172 |
</identifyingtaxonomicname> |
|
| 162 | 173 |
<matched_label_id> |
| 163 | 174 |
<taxonlabel> |
| 164 | 175 |
<creator_id> |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 38 | 38 |
interpretationdate,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value, |
| 39 | 39 |
taxonfit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit, |
| 40 | 40 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial, |
| 41 |
authorplantname,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 41 | 42 |
authorplantname,/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/1, |
| 42 | 43 |
museumaccessionnumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 43 | 44 |
Division,,** No join mapping for *Division ** |
| inputs/VegBank/taxonobservation_/test.xml.ref | ||
|---|---|---|
| 150 | 150 |
<taxonlabel_id> |
| 151 | 151 |
<taxonlabel> |
| 152 | 152 |
<binomial>$authorplantname</binomial> |
| 153 |
<identifyingtaxonomicname>$authorplantname</identifyingtaxonomicname> |
|
| 153 | 154 |
<matched_label_id> |
| 154 | 155 |
<taxonlabel> |
| 155 | 156 |
<creator_id> |
| mappings/VegCore-VegBIEN.csv | ||
|---|---|---|
| 261 | 261 |
originalBinomial,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial, |
| 262 | 262 |
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
| 263 | 263 |
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
| 264 |
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/1, |
|
| 265 |
originalBinomial,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/1, |
|
| 266 |
originalFamily,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/1, |
|
| 267 |
originalGenus,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/2, |
|
| 268 |
originalSpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/3, |
|
| 269 |
originalSubspecies,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/4, |
|
| 270 |
originalInfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond", |
|
| 271 |
originalTaxonRank,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/then", |
|
| 272 |
originalInfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2, |
|
| 273 |
originalVariety,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/6/_join_words:[1=""var. ""]/2", |
|
| 274 |
originalForma,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/7/_join_words:[1=""fm. ""]/2", |
|
| 275 |
originalCultivar,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/1/_alt/2/_join_words/8/_join_words:[1=""cult. ""]/2", |
|
| 276 |
originalScientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname/_alt/2/_join_words/2, |
|
| 264 | 277 |
originalScientificName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel:[creator_id/party:[creator_id=0]/organizationname=TNRS]/identifyingtaxonomicname/_alt/1, |
| 265 | 278 |
originalBinomial,/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/1, |
| 266 | 279 |
originalFamily,/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, |
| mappings/for_review/VegCore-VegBIEN.csv | ||
|---|---|---|
| 261 | 261 |
originalBinomial,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/binomial, |
| 262 | 262 |
originalFamily,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/family, |
| 263 | 263 |
originalGenus,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/genus, |
| 264 |
originalScientificName,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 265 |
originalBinomial,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 266 |
originalFamily,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 267 |
originalGenus,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 268 |
originalSpecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 269 |
originalSubspecies,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 270 |
originalInfraspecificEpithet,"//taxonlabel/identifyingtaxonomicname/_if[@name=""if has infraspecificEpithet""]/cond", |
|
| 271 |
originalTaxonRank,"//taxonlabel/identifyingtaxonomicname/_if[@name=""if has infraspecificEpithet""]/then", |
|
| 272 |
originalInfraspecificEpithet,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 273 |
originalVariety,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 274 |
originalForma,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 275 |
originalCultivar,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 276 |
originalScientificNameAuthorship,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/identifyingtaxonomicname, |
|
| 264 | 277 |
originalScientificName,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel/identifyingtaxonomicname, |
| 265 | 278 |
originalBinomial,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel/identifyingtaxonomicname, |
| 266 | 279 |
originalFamily,//taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonlabel/matched_label_id/taxonlabel/identifyingtaxonomicname, |
Also available in: Unified diff
mappings/VegCore-VegBIEN.csv: Also generate the identifyingtaxonomicname for the original* taxondetermination's taxonlabel