Revision 4079
Added by Aaron Marcuse-Kubitza over 12 years ago
| mappings/DwC.cs-VegBIEN.specimens.csv | ||
|---|---|---|
| 71 | 71 |
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 72 | 72 |
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 73 | 73 |
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2, |
| 74 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 74 | 75 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value", |
| 75 | 76 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 76 | 77 |
individualID,/location/locationevent/taxonoccurrence/sourceaccessioncode, |
| ... | ... | |
| 101 | 102 |
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit, |
| 102 | 103 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 103 | 104 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 105 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 104 | 106 |
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 105 | 107 |
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 106 | 108 |
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| inputs/XAL/test/import.specimens.xml.ref | ||
|---|---|---|
| 256 | 256 |
</specimenreplicate> |
| 257 | 257 |
</plantobservation> |
| 258 | 258 |
</aggregateoccurrence> |
| 259 |
<authortaxoncode>$CollectorNumber</authortaxoncode> |
|
| 259 |
<authortaxoncode> |
|
| 260 |
<_alt> |
|
| 261 |
<1>$CollectorNumber</1> |
|
| 262 |
<2>$ScientificName</2> |
|
| 263 |
</_alt> |
|
| 264 |
</authortaxoncode> |
|
| 260 | 265 |
<taxondetermination> |
| 261 | 266 |
<isoriginal>true</isoriginal> |
| 262 | 267 |
<role>identifier</role> |
| ... | ... | |
| 372 | 377 |
</determinationdate> |
| 373 | 378 |
</taxondetermination> |
| 374 | 379 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
| 380 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 375 | 381 |
</taxonoccurrence> |
| 376 | 382 |
<waterdepth> |
| 377 | 383 |
<_avg> |
| inputs/XAL/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 32 | 32 |
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/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 |
| 33 | 33 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 34 | 34 |
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 35 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 35 | 36 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 36 | 37 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle, |
| 37 | 38 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last, |
| ... | ... | |
| 49 | 50 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value", |
| 50 | 51 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value", |
| 51 | 52 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 53 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 52 | 54 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 53 | 55 |
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 54 | 56 |
Locality,/location/locationnarrative/_merge/1, |
| inputs/NY/test/import.specimens.xml.ref | ||
|---|---|---|
| 294 | 294 |
</aggregateoccurrence> |
| 295 | 295 |
<authortaxoncode> |
| 296 | 296 |
<_alt> |
| 297 |
<1>$CollectorNumber</1> |
|
| 298 |
<2>$FieldNumber</2> |
|
| 297 |
<1> |
|
| 298 |
<_alt> |
|
| 299 |
<1>$CollectorNumber</1> |
|
| 300 |
<2>$FieldNumber</2> |
|
| 301 |
</_alt> |
|
| 302 |
</1> |
|
| 303 |
<2>$ScientificName</2> |
|
| 299 | 304 |
</_alt> |
| 300 | 305 |
</authortaxoncode> |
| 301 | 306 |
<taxondetermination> |
| ... | ... | |
| 413 | 418 |
</determinationdate> |
| 414 | 419 |
</taxondetermination> |
| 415 | 420 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
| 421 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 416 | 422 |
</taxonoccurrence> |
| 417 | 423 |
<waterdepth> |
| 418 | 424 |
<_avg> |
| inputs/NY/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 37 | 37 |
UniqueNYInternalRecordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 38 | 38 |
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 39 | 39 |
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,Usage inconsistent with DwC definition |
| 40 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 40 | 41 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 41 | 42 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle, |
| 42 | 43 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last, |
| ... | ... | |
| 54 | 55 |
MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value", |
| 55 | 56 |
YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value", |
| 56 | 57 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 58 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 57 | 59 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 58 | 60 |
MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 59 | 61 |
Locality,/location/locationnarrative/_merge/1/_merge/1, |
| inputs/UNCC/test/import.specimens.xml.ref | ||
|---|---|---|
| 165 | 165 |
</specimenreplicate> |
| 166 | 166 |
</plantobservation> |
| 167 | 167 |
</aggregateoccurrence> |
| 168 |
<authortaxoncode>$collectno</authortaxoncode> |
|
| 168 |
<authortaxoncode> |
|
| 169 |
<_alt> |
|
| 170 |
<1>$collectno</1> |
|
| 171 |
<2>$SciName</2> |
|
| 172 |
</_alt> |
|
| 173 |
</authortaxoncode> |
|
| 169 | 174 |
<iscultivated> |
| 170 | 175 |
<_map> |
| 171 | 176 |
<cultivated>t</cultivated> |
| inputs/UNCC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 24 | 24 |
herbarium,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 25 | 25 |
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 26 | 26 |
collectno,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 27 |
SciName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 27 | 28 |
cultivated,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values |
| 28 | 29 |
cultivated,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Y=cultivated,N=wild,*=]/value",Ignore other values |
| 29 | 30 |
SciName,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname", |
| inputs/ACAD/test/import.specimens.xml.ref | ||
|---|---|---|
| 90 | 90 |
</specimenreplicate> |
| 91 | 91 |
</plantobservation> |
| 92 | 92 |
</aggregateoccurrence> |
| 93 |
<authortaxoncode>$recordNumber</authortaxoncode> |
|
| 93 |
<authortaxoncode> |
|
| 94 |
<_alt> |
|
| 95 |
<1>$recordNumber</1> |
|
| 96 |
<2>$scientificName</2> |
|
| 97 |
</_alt> |
|
| 98 |
</authortaxoncode> |
|
| 94 | 99 |
<taxondetermination> |
| 95 | 100 |
<isoriginal>true</isoriginal> |
| 96 | 101 |
<role>identifier</role> |
| ... | ... | |
| 174 | 179 |
<determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate> |
| 175 | 180 |
</taxondetermination> |
| 176 | 181 |
<verbatimcollectorname>$recordedBy</verbatimcollectorname> |
| 182 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 177 | 183 |
</taxonoccurrence> |
| 178 | 184 |
</locationevent> |
| 179 | 185 |
<locationnarrative> |
| inputs/ACAD/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 20 | 20 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 21 | 21 |
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 22 | 22 |
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2, |
| 23 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 23 | 24 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 24 | 25 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle, |
| 25 | 26 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last, |
| ... | ... | |
| 35 | 36 |
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname", |
| 36 | 37 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/2, |
| 37 | 38 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 39 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 38 | 40 |
locality,/location/locationnarrative/_merge/1, |
| 39 | 41 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 40 | 42 |
basisOfRecord,,** No non-empty join mapping for basisOfRecord ** |
| inputs/U/test/import.specimens.xml.ref | ||
|---|---|---|
| 232 | 232 |
<2>$Addcoll</2> |
| 233 | 233 |
</_merge> |
| 234 | 234 |
</verbatimcollectorname> |
| 235 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 235 | 236 |
</taxonoccurrence> |
| 236 | 237 |
</locationevent> |
| 237 | 238 |
<locationnarrative> |
| inputs/U/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 27 | 27 |
cf,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit, |
| 28 | 28 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/1, |
| 29 | 29 |
Addcoll,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/2, |
| 30 |
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 30 | 31 |
Gazetteer,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/1", |
| 31 | 32 |
Newgazett,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row |
| 32 | 33 |
Locnotes,/location/locationnarrative/_merge/2/_merge/2, |
| inputs/ARIZ/test/import.specimens.xml.ref | ||
|---|---|---|
| 316 | 316 |
</aggregateoccurrence> |
| 317 | 317 |
<authortaxoncode> |
| 318 | 318 |
<_alt> |
| 319 |
<1>$CollectorNumber</1> |
|
| 320 |
<2>$FieldNumber</2> |
|
| 319 |
<1> |
|
| 320 |
<_alt> |
|
| 321 |
<1>$CollectorNumber</1> |
|
| 322 |
<2>$FieldNumber</2> |
|
| 323 |
</_alt> |
|
| 324 |
</1> |
|
| 325 |
<2> |
|
| 326 |
<_alt> |
|
| 327 |
<1>$ScientificNameAuthor</1> |
|
| 328 |
<2>$ScientificName</2> |
|
| 329 |
</_alt> |
|
| 330 |
</2> |
|
| 321 | 331 |
</_alt> |
| 322 | 332 |
</authortaxoncode> |
| 323 | 333 |
<taxondetermination> |
| ... | ... | |
| 441 | 451 |
<taxonfit>$IdentificationModifier</taxonfit> |
| 442 | 452 |
</taxondetermination> |
| 443 | 453 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
| 454 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 444 | 455 |
</taxonoccurrence> |
| 445 | 456 |
<waterdepth> |
| 446 | 457 |
<_avg> |
| inputs/ARIZ/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 42 | 42 |
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 43 | 43 |
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 44 | 44 |
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,Usage inconsistent with DwC definition |
| 45 |
ScientificNameAuthor,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/1,Contains the binomial in addition to the authority |
|
| 46 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2, |
|
| 45 | 47 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 46 | 48 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle, |
| 47 | 49 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last, |
| ... | ... | |
| 61 | 63 |
Remarks,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/notes, |
| 62 | 64 |
IdentificationModifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit, |
| 63 | 65 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 66 |
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 64 | 67 |
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 65 | 68 |
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 66 | 69 |
Locality,/location/locationnarrative/_merge/1, |
| inputs/GBIF/test/import.specimens.xml.ref | ||
|---|---|---|
| 166 | 166 |
</specimenreplicate> |
| 167 | 167 |
</plantobservation> |
| 168 | 168 |
</aggregateoccurrence> |
| 169 |
<authortaxoncode>$ScientificName</authortaxoncode> |
|
| 169 | 170 |
<taxondetermination> |
| 170 | 171 |
<isoriginal>true</isoriginal> |
| 171 | 172 |
<role>identifier</role> |
| ... | ... | |
| 224 | 225 |
</plantconcept_id> |
| 225 | 226 |
</taxondetermination> |
| 226 | 227 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
| 228 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 227 | 229 |
</taxonoccurrence> |
| 228 | 230 |
</locationevent> |
| 229 | 231 |
<locationnarrative>$Locality</locationnarrative> |
| inputs/GBIF/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 20 | 20 |
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 21 | 21 |
CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/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 |
| 22 | 22 |
InstitutionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 23 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 23 | 24 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 24 | 25 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle, |
| 25 | 26 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last, |
| ... | ... | |
| 30 | 31 |
Genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname", |
| 31 | 32 |
Family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
| 32 | 33 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 34 |
CatalogNO,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 33 | 35 |
Locality,/location/locationnarrative/_merge/1, |
| 34 | 36 |
GBIFFamilyOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations |
| 35 | 37 |
GBIFGenusOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations |
| inputs/NCU-NCSC/test/import.specimens.xml.ref | ||
|---|---|---|
| 83 | 83 |
</specimenreplicate> |
| 84 | 84 |
</plantobservation> |
| 85 | 85 |
</aggregateoccurrence> |
| 86 |
<authortaxoncode>$Full Taxon Name</authortaxoncode> |
|
| 86 | 87 |
<iscultivated> |
| 87 | 88 |
<_map> |
| 88 | 89 |
<cultivated>t</cultivated> |
| ... | ... | |
| 131 | 132 |
</plantconcept> |
| 132 | 133 |
</plantconcept_id> |
| 133 | 134 |
</taxondetermination> |
| 135 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 134 | 136 |
</taxonoccurrence> |
| 135 | 137 |
</locationevent> |
| 136 | 138 |
</location> |
| inputs/NCU-NCSC/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 15 | 15 |
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 16 | 16 |
SeriesName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/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 |
| 17 | 17 |
Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 18 |
Full Taxon Name,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 18 | 19 |
Cultivated?,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value/_map:[Yes=cultivated,No=wild]/value", |
| 19 | 20 |
Cultivated?,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value/_map:[Yes=cultivated,No=wild]/value", |
| 20 | 21 |
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname", |
| 22 |
Barcode,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 21 | 23 |
Alt E/W,,** No input mapping for Alt E/W ** |
| 22 | 24 |
Alt N/S,,** No input mapping for Alt N/S ** |
| 23 | 25 |
FIPS,,FIPS county code |
| inputs/SpeciesLink/test/import.specimens.xml.ref | ||
|---|---|---|
| 452 | 452 |
<_alt> |
| 453 | 453 |
<1> |
| 454 | 454 |
<_alt> |
| 455 |
<0>$dwc_curatorial_CollectorNumber</0> |
|
| 456 |
<1>$conceptual_darwin_2003_1_0_CollectorNumber</1> |
|
| 455 |
<1> |
|
| 456 |
<_alt> |
|
| 457 |
<0>$dwc_curatorial_CollectorNumber</0> |
|
| 458 |
<1>$conceptual_darwin_2003_1_0_CollectorNumber</1> |
|
| 459 |
</_alt> |
|
| 460 |
</1> |
|
| 461 |
<2>$dwc_terms_recordNumber</2> |
|
| 457 | 462 |
</_alt> |
| 458 | 463 |
</1> |
| 459 |
<2>$dwc_terms_recordNumber</2> |
|
| 464 |
<2> |
|
| 465 |
<_alt> |
|
| 466 |
<0>$dwc_dwcore_ScientificName</0> |
|
| 467 |
<1>$conceptual_darwin_2003_1_0_ScientificName</1> |
|
| 468 |
<2>$dwc_terms_scientificName</2> |
|
| 469 |
</_alt> |
|
| 470 |
</2> |
|
| 460 | 471 |
</_alt> |
| 461 | 472 |
</authortaxoncode> |
| 462 | 473 |
<taxondetermination> |
| ... | ... | |
| 676 | 687 |
<2>$dwc_terms_recordedBy</2> |
| 677 | 688 |
</_alt> |
| 678 | 689 |
</verbatimcollectorname> |
| 690 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 679 | 691 |
</taxonoccurrence> |
| 680 | 692 |
<waterdepth> |
| 681 | 693 |
<_avg> |
| inputs/SpeciesLink/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 72 | 72 |
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 73 | 73 |
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 74 | 74 |
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2, |
| 75 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 76 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 75 | 77 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 76 | 78 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 77 | 79 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle, |
| ... | ... | |
| 108 | 110 |
Remarks,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/notes, |
| 109 | 111 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 110 | 112 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 113 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 114 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 111 | 115 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 112 | 116 |
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 113 | 117 |
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| inputs/MO/test/import.specimens.xml.ref | ||
|---|---|---|
| 245 | 245 |
</specimenreplicate> |
| 246 | 246 |
</plantobservation> |
| 247 | 247 |
</aggregateoccurrence> |
| 248 |
<authortaxoncode>$CollectorNumber</authortaxoncode> |
|
| 248 |
<authortaxoncode> |
|
| 249 |
<_alt> |
|
| 250 |
<1>$CollectorNumber</1> |
|
| 251 |
<2>$ScientificName</2> |
|
| 252 |
</_alt> |
|
| 253 |
</authortaxoncode> |
|
| 249 | 254 |
<taxondetermination> |
| 250 | 255 |
<isoriginal>true</isoriginal> |
| 251 | 256 |
<role>identifier</role> |
| ... | ... | |
| 325 | 330 |
</plantconcept_id> |
| 326 | 331 |
</taxondetermination> |
| 327 | 332 |
<verbatimcollectorname>$Collector</verbatimcollectorname> |
| 333 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 328 | 334 |
</taxonoccurrence> |
| 329 | 335 |
</locationevent> |
| 330 | 336 |
<locationnarrative>$Locality</locationnarrative> |
| inputs/MO/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 29 | 29 |
CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/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 |
| 30 | 30 |
InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 31 | 31 |
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 32 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 32 | 33 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 33 | 34 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle, |
| 34 | 35 |
IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last, |
| ... | ... | |
| 40 | 41 |
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname", |
| 41 | 42 |
Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname", |
| 42 | 43 |
Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 44 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 43 | 45 |
Locality,/location/locationnarrative/_merge/1, |
| 44 | 46 |
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord ** |
| 45 | 47 |
DateLastModified,,** No non-empty join mapping for DateLastModified ** |
| inputs/QMOR/test/import.specimens.xml.ref | ||
|---|---|---|
| 210 | 210 |
</specimenreplicate> |
| 211 | 211 |
</plantobservation> |
| 212 | 212 |
</aggregateoccurrence> |
| 213 |
<authortaxoncode>$scientificName</authortaxoncode> |
|
| 213 | 214 |
<taxondetermination> |
| 214 | 215 |
<isoriginal>true</isoriginal> |
| 215 | 216 |
<role>identifier</role> |
| ... | ... | |
| 294 | 295 |
<taxonfit>$identificationQualifier</taxonfit> |
| 295 | 296 |
</taxondetermination> |
| 296 | 297 |
<verbatimcollectorname>$recordedBy</verbatimcollectorname> |
| 298 |
<voucher><specimenreplicate_id><specimenreplicate><catalognumber_dwc/></specimenreplicate></specimenreplicate_id></voucher> |
|
| 297 | 299 |
</taxonoccurrence> |
| 298 | 300 |
</locationevent> |
| 299 | 301 |
<locationnarrative> |
| inputs/QMOR/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 30 | 30 |
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_merge/2, |
| 31 | 31 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 32 | 32 |
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 33 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 33 | 34 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/givenname/_namePart/first, |
| 34 | 35 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/middlename/_namePart/middle, |
| 35 | 36 |
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/party/surname/_namePart/last, |
| ... | ... | |
| 46 | 47 |
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/determinationdate/_*/date/_dateRangeStart/value/_alt/2, |
| 47 | 48 |
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit, |
| 48 | 49 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 50 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 49 | 51 |
locality,/location/locationnarrative/_merge/1, |
| 50 | 52 |
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?" |
| 51 | 53 |
acceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage ** |
| mappings/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 39 | 39 |
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 40 | 40 |
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| 41 | 41 |
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1, |
| 42 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 42 | 43 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value", |
| 43 | 44 |
establishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| 44 | 45 |
individualID,/location/locationevent/taxonoccurrence/sourceaccessioncode, |
| ... | ... | |
| 59 | 60 |
taxonRemarks,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/notes, |
| 60 | 61 |
identificationQualifier,/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/taxonfit, |
| 61 | 62 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 63 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 62 | 64 |
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 63 | 65 |
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 64 | 66 |
locality,/location/locationnarrative/_merge/1, |
| mappings/for_review/DwC2-VegBIEN.specimens.csv | ||
|---|---|---|
| 39 | 39 |
institutionCode,//party/organizationname, |
| 40 | 40 |
occurrenceID,//specimenreplicate/sourceaccessioncode, |
| 41 | 41 |
recordNumber,//taxonoccurrence/authortaxoncode, |
| 42 |
scientificName,//taxonoccurrence/authortaxoncode, |
|
| 42 | 43 |
establishmentMeans,//taxonoccurrence/iscultivated, |
| 43 | 44 |
establishmentMeans,//taxonoccurrence/isnative, |
| 44 | 45 |
individualID,//taxonoccurrence/sourceaccessioncode, |
| ... | ... | |
| 59 | 60 |
taxonRemarks,//taxonoccurrence/taxondetermination[role=identifier]/notes, |
| 60 | 61 |
identificationQualifier,//taxonoccurrence/taxondetermination[role=identifier]/taxonfit, |
| 61 | 62 |
recordedBy,//taxonoccurrence/verbatimcollectorname, |
| 63 |
catalogNumber,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 62 | 64 |
maximumDepthInMeters,//locationevent/waterdepth, |
| 63 | 65 |
minimumDepthInMeters,//locationevent/waterdepth, |
| 64 | 66 |
locality,//location/locationnarrative, |
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 143 | 143 |
collectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1, |
| 144 | 144 |
RecordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2, |
| 145 | 145 |
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2, |
| 146 |
ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 147 |
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2, |
|
| 146 | 148 |
EstablishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value", |
| 147 | 149 |
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_map:[cultivated=t,wild=f,*=]/value", |
| 148 | 150 |
EstablishmentMeans,"/location/locationevent/taxonoccurrence/isnative/_map:[native=t,exotic=f,*=]/value", |
| ... | ... | |
| 203 | 205 |
RecordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 204 | 206 |
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 205 | 207 |
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname, |
| 208 |
CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 209 |
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then", |
|
| 206 | 210 |
MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 207 | 211 |
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
| 208 | 212 |
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value", |
Also available in: Unified diff
mappings/DwC2-VegBIEN.specimens.csv: catalogNumber: Added additional VegCSV mappings for mergability. taxonoccurrence.authortaxoncode: Added alternative mappings from VegCSV for mergability.