Revision 4583
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/GBIF/Specimen/map.csv | ||
|---|---|---|
| 4 | 4 |
CollectionCD,CollectionCode, |
| 5 | 5 |
CatalogNO,CatalogNumber, |
| 6 | 6 |
LastDateModified,DateLastModified, |
| 7 |
ScientificNameOriginal,originalNameUsage/_alt/1,DwC doesn't fully support taxonomic redeterminations
|
|
| 7 |
ScientificNameOriginal,verbatimScientificName,
|
|
| 8 | 8 |
AuthorOfScientificName,ScientificNameAuthor, |
| 9 |
GBIFFamilyOriginal,originalNameUsage/_alt/2/_name/first,DwC doesn't fully support taxonomic redeterminations
|
|
| 10 |
GBIFGenusOriginal,originalNameUsage/_alt/2/_name/middle,DwC doesn't fully support taxonomic redeterminations
|
|
| 9 |
GBIFFamilyOriginal,verbatimFamily,
|
|
| 10 |
GBIFGenusOriginal,verbatimGenus,
|
|
| 11 | 11 |
MinimumElevationInMeter,MinimumElevationInMeters, |
| 12 | 12 |
MaximumElevationInMeter,MaximumElevationInMeters, |
| inputs/GBIF/Specimen/map.full.csv | ||
|---|---|---|
| 17 | 17 |
identifiedBy,identifiedBy |
| 18 | 18 |
infraspecificEpithet,infraspecificEpithet |
| 19 | 19 |
locality,locality |
| 20 |
ScientificNameOriginal,originalNameUsage/_alt/1,DwC doesn't fully support taxonomic redeterminations |
|
| 21 |
GBIFFamilyOriginal,originalNameUsage/_alt/2/_name/first,DwC doesn't fully support taxonomic redeterminations |
|
| 22 |
GBIFGenusOriginal,originalNameUsage/_alt/2/_name/middle,DwC doesn't fully support taxonomic redeterminations |
|
| 23 | 20 |
scientificName,scientificName |
| 24 | 21 |
specificEpithet,specificEpithet |
| 25 | 22 |
stateProvince,stateProvince |
| 23 |
GBIFFamilyOriginal,verbatimFamily, |
|
| 24 |
GBIFGenusOriginal,verbatimGenus, |
|
| 26 | 25 |
verbatimLatitude,verbatimLatitude |
| 27 | 26 |
verbatimLongitude,verbatimLongitude |
| 27 |
ScientificNameOriginal,verbatimScientificName, |
|
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 18 | 18 |
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 19 | 19 |
CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name |
| 20 | 20 |
InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 21 |
ScientificNameOriginal,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/1, |
|
| 21 | 22 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
| 22 | 23 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first, |
| 23 | 24 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle, |
| ... | ... | |
| 28 | 29 |
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname", |
| 29 | 30 |
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
| 30 | 31 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
| 32 |
ScientificNameOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname", |
|
| 33 |
GBIFGenusOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
|
| 34 |
GBIFFamilyOriginal,"/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=parent_id]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
|
| 31 | 35 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 32 | 36 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
| 33 | 37 |
locality,/location/locationnarrative/_merge/1, |
| 34 |
GBIFFamilyOriginal,,** No join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations |
|
| 35 |
GBIFGenusOriginal,,** No join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations |
|
| 36 | 38 |
LastDateModified,,** No join mapping for DateLastModified ** |
| 37 |
ScientificNameOriginal,,** No join mapping for originalNameUsage/_alt/1 ** DwC doesn't fully support taxonomic redeterminations |
|
| inputs/GBIF/Specimen/test.xml.ref | ||
|---|---|---|
| 164 | 164 |
</specimenreplicate> |
| 165 | 165 |
</plantobservation> |
| 166 | 166 |
</aggregateoccurrence> |
| 167 |
<authortaxoncode>$ScientificName</authortaxoncode> |
|
| 167 |
<authortaxoncode> |
|
| 168 |
<_alt> |
|
| 169 |
<1>$ScientificNameOriginal</1> |
|
| 170 |
<2>$ScientificName</2> |
|
| 171 |
</_alt> |
|
| 172 |
</authortaxoncode> |
|
| 168 | 173 |
<taxondetermination> |
| 169 | 174 |
<party_id> |
| 170 | 175 |
<party> |
| ... | ... | |
| 219 | 224 |
</plantconcept> |
| 220 | 225 |
</plantconcept_id> |
| 221 | 226 |
</taxondetermination> |
| 227 |
<taxondetermination> |
|
| 228 |
<isoriginal>true</isoriginal> |
|
| 229 |
<plantconcept_id> |
|
| 230 |
<plantconcept> |
|
| 231 |
<plantname_id> |
|
| 232 |
<_simplifyPath> |
|
| 233 |
<next>parent_id</next> |
|
| 234 |
<path> |
|
| 235 |
<plantname> |
|
| 236 |
<rank>binomial</rank> |
|
| 237 |
<plantname>$ScientificNameOriginal</plantname> |
|
| 238 |
<parent_id> |
|
| 239 |
<plantname> |
|
| 240 |
<rank>authority</rank> |
|
| 241 |
<parent_id> |
|
| 242 |
<plantname> |
|
| 243 |
<rank>subspecies</rank> |
|
| 244 |
<parent_id> |
|
| 245 |
<plantname> |
|
| 246 |
<rank>species</rank> |
|
| 247 |
<parent_id> |
|
| 248 |
<plantname> |
|
| 249 |
<rank>genus</rank> |
|
| 250 |
<plantname>$GBIFGenusOriginal</plantname> |
|
| 251 |
<parent_id> |
|
| 252 |
<plantname> |
|
| 253 |
<rank>family</rank> |
|
| 254 |
<plantname>$GBIFFamilyOriginal</plantname> |
|
| 255 |
</plantname> |
|
| 256 |
</parent_id> |
|
| 257 |
</plantname> |
|
| 258 |
</parent_id> |
|
| 259 |
</plantname> |
|
| 260 |
</parent_id> |
|
| 261 |
</plantname> |
|
| 262 |
</parent_id> |
|
| 263 |
</plantname> |
|
| 264 |
</parent_id> |
|
| 265 |
</plantname> |
|
| 266 |
</path> |
|
| 267 |
</_simplifyPath> |
|
| 268 |
</plantname_id> |
|
| 269 |
</plantconcept> |
|
| 270 |
</plantconcept_id> |
|
| 271 |
</taxondetermination> |
|
| 222 | 272 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
| 223 | 273 |
</taxonoccurrence> |
| 224 | 274 |
</locationevent> |
| 225 | 275 |
<locationnarrative>$Locality</locationnarrative> |
| 226 | 276 |
</location> |
| 227 | 277 |
</VegBIEN> |
| 228 |
Inserted 31 new rows into database |
|
| 278 |
Inserted 37 new rows into database |
|
Also available in: Unified diff
inputs/GBIF/Specimen/map.csv: Remapped Original fields to new verbatim taxonomic terms