Revision 1262
Added by Aaron Marcuse-Kubitza almost 13 years ago
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
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