Revision 4567
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/GBIF/Specimen/VegBIEN.csv | ||
|---|---|---|
| 14 | 14 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 15 | 15 |
stateProvince,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 16 | 16 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| 17 |
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/2,
|
|
| 17 |
LatestDateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
|
| 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, |
| inputs/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 9 | 9 |
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename", |
| 10 | 10 |
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename", |
| 11 | 11 |
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename", |
| 12 |
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/3,
|
|
| 12 |
Collect Date,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
|
| 13 | 13 |
Barcode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 14 | 14 |
SeriesName,/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 |
| 15 | 15 |
Accession Number,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode, |
| inputs/VegBank/taxonobservation_/VegBIEN.csv | ||
|---|---|---|
| 3 | 3 |
observation_id,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode", |
| 4 | 4 |
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/cond/_exists/_first/1", |
| 5 | 5 |
observation_id,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if event""]/then/parent_id/locationevent/sourceaccessioncode", |
| 6 |
collectiondate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/3,
|
|
| 6 |
collectiondate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
|
| 7 | 7 |
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes, |
| 8 | 8 |
museumaccessionnumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else", |
| 9 | 9 |
authorplantname,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/1, |
| mappings/Veg+-VegBIEN.csv | ||
|---|---|---|
| 112 | 112 |
silt,/location/locationevent/soilobs/silt, |
| 113 | 113 |
sodium,/location/locationevent/soilobs/sodium, |
| 114 | 114 |
texture,/location/locationevent/soilobs/texture, |
| 115 |
dateCollected/_alt,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt, |
|
| 116 |
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/2, |
|
| 117 |
collectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date/_alt/3, |
|
| 115 |
collectedDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
|
| 116 |
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
|
| 118 | 117 |
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value", |
| 119 | 118 |
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value", |
| 120 | 119 |
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value", |
| mappings/for_review/Veg+-VegCore.csv | ||
|---|---|---|
| 1 | 1 |
Veg+,Veg+,Comments |
| 2 | 2 |
continentOcean,continent, |
| 3 | 3 |
CountryName,country, |
| 4 |
dateCollected/_alt,dateCollected/_alt, |
|
| 5 |
dateCollected,dateCollected, |
|
| 6 | 4 |
collectedDate,dateCollected, |
| 7 | 5 |
identifiedDate,dateIdentified, |
| 8 | 6 |
julianDay,day, |
| mappings/Veg+-VegCore.to_self.csv | ||
|---|---|---|
| 1 | 1 |
Veg+,Veg+,Comments |
| 2 | 2 |
continentOcean,continent, |
| 3 | 3 |
CountryName,country, |
| 4 |
dateCollected/_alt,dateCollected/_alt, |
|
| 5 |
dateCollected,dateCollected/_alt/2, |
|
| 6 |
collectedDate,dateCollected/_alt/3, |
|
| 4 |
collectedDate,dateCollected, |
|
| 7 | 5 |
identifiedDate,dateIdentified, |
| 8 | 6 |
julianDay,day, |
| 9 | 7 |
accessRights,dcterms:accessRights, |
| mappings/Veg+.self.csv | ||
|---|---|---|
| 47 | 47 |
coverPercent,coverPercent |
| 48 | 48 |
cultivated,cultivated |
| 49 | 49 |
dateCollected,dateCollected |
| 50 |
dateCollected/_alt,dateCollected/_alt |
|
| 51 | 50 |
dateIdentified,dateIdentified |
| 52 | 51 |
dayCollected,dayCollected |
| 53 | 52 |
dayIdentified,dayIdentified |
| mappings/Veg+-VegCore.csv | ||
|---|---|---|
| 1 | 1 |
Veg+,Veg+,Comments |
| 2 | 2 |
continentOcean,continent, |
| 3 | 3 |
CountryName,country, |
| 4 |
dateCollected/_alt,dateCollected/_alt, |
|
| 5 |
dateCollected,dateCollected/_alt/2, |
|
| 6 |
collectedDate,dateCollected/_alt/3, |
|
| 4 |
collectedDate,dateCollected, |
|
| 7 | 5 |
identifiedDate,dateIdentified, |
| 8 | 6 |
julianDay,day, |
| 9 | 7 |
accessRights,dcterms:accessRights, |
Also available in: Unified diff
mappings/Veg+-VegCore.csv: Removed dateCollected/_alt and dateCollected redirection mappings, which were only needed when multiple dateCollected fields were being combined in Veg+-VegCore.csv