Project

General

Profile

« Previous | Next » 

Revision 1262

mappings/DwC1-DwC2.specimens.csv: Map eventDate,dateIdentified using /_alt/2 and year/month/day using /_alt/1 so that inputs with both a date and date parts will select between the two

View differences:

inputs/NYBG/maps/VegBIEN.specimens.csv
26 26
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
27 27
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
28 28
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
29
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44
30
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44
31
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44
32
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/year,,44
29
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/day,,44
30
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/month,,44
31
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/year,,44
32
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2,,44
33 33
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
34 34
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
35 35
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
36 36
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
37 37
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
38 38
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
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/_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
39
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/day",,120
40
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/month",,120
41
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/year",,120
42
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2",,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
inputs/NYBG-CSV/maps/VegBIEN.specimens.csv
26 26
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
27 27
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
28 28
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
29
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44
30
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44
31
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44
32
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/year,,44
29
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/day,,44
30
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/month,,44
31
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/year,,44
32
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2,,44
33 33
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
34 34
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
35 35
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
36 36
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
37 37
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
38 38
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
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/_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
39
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/day",,120
40
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/month",,120
41
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/year",,120
42
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2",,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/DwC.self.specimens.csv
23 23
decimalLongitude,decimalLongitude
24 24
Longitude,Longitude
25 25
verbatimLongitude,verbatimLongitude
26
eventDate,eventDate
27 26
DayCollected,DayCollected
28 27
MonthCollected,MonthCollected
29 28
YearCollected,YearCollected
29
eventDate,eventDate
30 30
MaximumDepth,MaximumDepth
31 31
maximumDepthInMeters,maximumDepthInMeters
32 32
MinimumDepth,MinimumDepth
33 33
minimumDepthInMeters,minimumDepthInMeters
34 34
ScientificNameAuthor,ScientificNameAuthor
35 35
scientificNameAuthorship,scientificNameAuthorship
36
dateIdentified,dateIdentified
37 36
DayIdentified,DayIdentified
38 37
MonthIdentified,MonthIdentified
39 38
YearIdentified,YearIdentified
39
dateIdentified,dateIdentified
40 40
IdentifiedBy,IdentifiedBy
41 41
identifiedBy,identifiedBy
42 42
ScientificName,ScientificName
mappings/for_review/DwC1-DwC2.specimens.csv
7 7
CoordinatePrecision,coordinatePrecision,
8 8
Country,country,
9 9
County,county,
10
DayIdentified,dateIdentified/_date/day,
11
MonthIdentified,dateIdentified/_date/month,
12
YearIdentified,dateIdentified/_date/year,
10
DayIdentified,dateIdentified/_alt/1/_date/day,
11
MonthIdentified,dateIdentified/_alt/1/_date/month,
12
YearIdentified,dateIdentified/_alt/1/_date/year,
13
dateIdentified,dateIdentified/_alt/2,
13 14
JulianDay,day,
14 15
DateLastModified,dcterms:modified,
15
DayCollected,eventDate/_date/day,
16
MonthCollected,eventDate/_date/month,
17
YearCollected,eventDate/_date/year,
16
DayCollected,eventDate/_alt/1/_date/day,
17
MonthCollected,eventDate/_alt/1/_date/month,
18
YearCollected,eventDate/_alt/1/_date/year,
19
eventDate,eventDate/_alt/2,
18 20
TimeOfDay,eventTime,
19 21
Family,family,
20 22
Notes,fieldNotes,
mappings/DwC-VegBIEN.specimens.csv
23 23
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
24 24
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
25 25
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
26
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44
27
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44
28
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44
29
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/year,,44
26
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/day,,44
27
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/month,,44
28
YearCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_date/year,,44
29
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2,,44
30 30
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
31 31
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
32 32
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
33 33
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74
34 34
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
35 35
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Authority]:[determinationtype=Author,isoriginal=true,iscurrent=true]/*_id/plantconcept/*_id/*/plantname","Brad: Mapping probably incorrect. This DwC element refers to scientific name author; does not correspond to the VegBank and VegX elements you have listed (Bob, Nick�where does name author belong in VegBank and VegX?); Aaron: The mapped VegX element is the author linked to the taxon name, so it seems like this is the scientific name author",153
36
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate",,120
37
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/day",,120
38
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/month",,120
39
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_date/year",,120
36
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/day",,120
37
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/month",,120
38
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/1/_date/year",,120
39
dateIdentified,"/*_id/taxonoccurrence/taxondetermination[*_id/role/rolecode=identifier,*_id/plantconcept/*_id/plantname/rank=Binomial]/determinationdate/_alt/2",,120
40 40
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
41 41
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
42 42
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/_date/day,
11
MonthIdentified,dateIdentified/_date/month,
12
YearIdentified,dateIdentified/_date/year,
10
DayIdentified,dateIdentified/_alt/1/_date/day,
11
MonthIdentified,dateIdentified/_alt/1/_date/month,
12
YearIdentified,dateIdentified/_alt/1/_date/year,
13
dateIdentified,dateIdentified/_alt/2,
13 14
JulianDay,day,
14 15
DateLastModified,dcterms:modified,
15
DayCollected,eventDate/_date/day,
16
MonthCollected,eventDate/_date/month,
17
YearCollected,eventDate/_date/year,
16
DayCollected,eventDate/_alt/1/_date/day,
17
MonthCollected,eventDate/_alt/1/_date/month,
18
YearCollected,eventDate/_alt/1/_date/year,
19
eventDate,eventDate/_alt/2,
18 20
TimeOfDay,eventTime,
19 21
Family,family,
20 22
Notes,fieldNotes,

Also available in: Unified diff