Revision 1173
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/NYBG/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 28 | 28 |
Substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,, |
| 29 | 29 |
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,, |
| 30 | 30 |
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44 |
| 31 |
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/day,,44
|
|
| 32 |
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/month,,44
|
|
| 33 |
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/year,,44
|
|
| 31 |
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44 |
|
| 32 |
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44 |
|
| 33 |
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/year,,44 |
|
| 34 | 34 |
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75 |
| 35 | 35 |
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75 |
| 36 | 36 |
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74 |
| ... | ... | |
| 40 | 40 |
Sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| 41 | 41 |
sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| 42 | 42 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate",,120 |
| 43 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/day",,120
|
|
| 44 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/month",,120
|
|
| 45 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/year",,120
|
|
| 43 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/day",,120 |
|
| 44 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/month",,120 |
|
| 45 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/year",,120 |
|
| 46 | 46 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
| 47 | 47 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
| 48 | 48 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134 |
| inputs/NYBG-CSV/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 28 | 28 |
Substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,, |
| 29 | 29 |
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,, |
| 30 | 30 |
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44 |
| 31 |
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/day,,44
|
|
| 32 |
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/month,,44
|
|
| 33 |
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/year,,44
|
|
| 31 |
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44 |
|
| 32 |
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44 |
|
| 33 |
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/year,,44 |
|
| 34 | 34 |
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75 |
| 35 | 35 |
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75 |
| 36 | 36 |
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74 |
| ... | ... | |
| 40 | 40 |
Sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| 41 | 41 |
sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| 42 | 42 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate",,120 |
| 43 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/day",,120
|
|
| 44 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/month",,120
|
|
| 45 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/year",,120
|
|
| 43 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/day",,120 |
|
| 44 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/month",,120 |
|
| 45 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/year",,120 |
|
| 46 | 46 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
| 47 | 47 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
| 48 | 48 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134 |
| mappings/for_review/DwC1-DwC2.specimens.csv | ||
|---|---|---|
| 7 | 7 |
CoordinatePrecision,coordinatePrecision, |
| 8 | 8 |
Country,country, |
| 9 | 9 |
County,county, |
| 10 |
DayIdentified,dateIdentified/_alt/2/_date/day,
|
|
| 11 |
MonthIdentified,dateIdentified/_alt/2/_date/month,
|
|
| 12 |
YearIdentified,dateIdentified/_alt/2/_date/year,
|
|
| 10 |
DayIdentified,dateIdentified/_date/day, |
|
| 11 |
MonthIdentified,dateIdentified/_date/month, |
|
| 12 |
YearIdentified,dateIdentified/_date/year, |
|
| 13 | 13 |
JulianDay,day, |
| 14 | 14 |
DateLastModified,dcterms:modified, |
| 15 |
DayCollected,eventDate/_alt/2/_date/day,
|
|
| 16 |
MonthCollected,eventDate/_alt/2/_date/month,
|
|
| 17 |
YearCollected,eventDate/_alt/2/_date/year,
|
|
| 15 |
DayCollected,eventDate/_date/day, |
|
| 16 |
MonthCollected,eventDate/_date/month, |
|
| 17 |
YearCollected,eventDate/_date/year, |
|
| 18 | 18 |
TimeOfDay,eventTime, |
| 19 | 19 |
Family,family, |
| 20 | 20 |
Notes,fieldNotes/_merge/1, |
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 25 | 25 |
habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 26 | 26 |
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,, |
| 27 | 27 |
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44 |
| 28 |
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/day,,44
|
|
| 29 |
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/month,,44
|
|
| 30 |
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/year,,44
|
|
| 28 |
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44 |
|
| 29 |
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44 |
|
| 30 |
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/year,,44 |
|
| 31 | 31 |
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75 |
| 32 | 32 |
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75 |
| 33 | 33 |
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74 |
| ... | ... | |
| 37 | 37 |
Sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| 38 | 38 |
sex,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/definedvalue[*_id/userdefined[tablename=taxondetermination,userdefinedname=sex]]:[@fkey=tableRecord_ID]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections",26 |
| 39 | 39 |
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate",,120 |
| 40 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/day",,120
|
|
| 41 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/month",,120
|
|
| 42 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2/_date/year",,120
|
|
| 40 |
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/day",,120 |
|
| 41 |
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/month",,120 |
|
| 42 |
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/year",,120 |
|
| 43 | 43 |
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
| 44 | 44 |
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
|
| 45 | 45 |
ScientificName,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Bob, Nick, please is this mapping OK?",134 |
| mappings/DwC1-DwC2.specimens.csv | ||
|---|---|---|
| 7 | 7 |
CoordinatePrecision,coordinatePrecision, |
| 8 | 8 |
Country,country, |
| 9 | 9 |
County,county, |
| 10 |
DayIdentified,dateIdentified/_alt/2/_date/day,
|
|
| 11 |
MonthIdentified,dateIdentified/_alt/2/_date/month,
|
|
| 12 |
YearIdentified,dateIdentified/_alt/2/_date/year,
|
|
| 10 |
DayIdentified,dateIdentified/_date/day, |
|
| 11 |
MonthIdentified,dateIdentified/_date/month, |
|
| 12 |
YearIdentified,dateIdentified/_date/year, |
|
| 13 | 13 |
JulianDay,day, |
| 14 | 14 |
DateLastModified,dcterms:modified, |
| 15 |
DayCollected,eventDate/_alt/2/_date/day,
|
|
| 16 |
MonthCollected,eventDate/_alt/2/_date/month,
|
|
| 17 |
YearCollected,eventDate/_alt/2/_date/year,
|
|
| 15 |
DayCollected,eventDate/_date/day, |
|
| 16 |
MonthCollected,eventDate/_date/month, |
|
| 17 |
YearCollected,eventDate/_date/year, |
|
| 18 | 18 |
TimeOfDay,eventTime, |
| 19 | 19 |
Family,family, |
| 20 | 20 |
Notes,fieldNotes/_merge/1, |
Also available in: Unified diff
DwC1-DwC2.specimens.csv: Removed no longer needed /_alt/2 XML func from date mappings (you will only ever map either the full date or the year/month/day)