Project

General

Profile

« Previous | Next » 

Revision 1453

inputs/MO: Switched to using flat files instead of DB

View differences:

inputs/MO/test/DwC.specimens.xml.ref
10 10
        <ContinentOcean>America</ContinentOcean>
11 11
        <Country>Ecuador</Country>
12 12
        <DateLastModified>2008-05-27 22:02:17.713000000</DateLastModified>
13
        <DayCollected>0</DayCollected>
14
        <Family>Thelypteridaceae</Family>
15
        <Genus>Thelypteris</Genus>
16 13
        <InstitutionCode>MO</InstitutionCode>
17 14
        <Kingdom>Plant</Kingdom>
18
        <MonthCollected>0</MonthCollected>
19 15
        <ScientificName>Thelypteris minutula C.V. Morton</ScientificName>
20 16
        <ScientificNameAuthor>C.V. Morton</ScientificNameAuthor>
21
        <Species>minutula</Species>
22 17
        <StateProvince>Carchi</StateProvince>
23
        <YearCollected>0</YearCollected>
18
        <family>Thelypteridaceae</family>
19
        <genus>Thelypteris</genus>
20
        <species>minutula</species>
24 21
    </list>
25 22
    <list id="1">
26 23
        <institutionID>MO</institutionID>
27 24
        <BasisOfRecord>S</BasisOfRecord>
28 25
        <CatalogNumber>2</CatalogNumber>
29
        <CollectedDate>1985-10-29</CollectedDate>
30 26
        <CollectionCode>Tropicos</CollectionCode>
31 27
        <Collector>J.D. &amp; E.G. Chapman</Collector>
32 28
        <CollectorNumber>6723</CollectorNumber>
......
34 30
        <Country>Malawi</Country>
35 31
        <DateLastModified>2008-05-27 22:02:17.713000000</DateLastModified>
36 32
        <DayCollected>29</DayCollected>
37
        <Family>Polypodiaceae</Family>
38
        <Genus>Polypodium</Genus>
39 33
        <IndividualCount>1</IndividualCount>
40 34
        <InstitutionCode>MO</InstitutionCode>
41 35
        <Kingdom>Plant</Kingdom>
......
44 38
        <MonthCollected>10</MonthCollected>
45 39
        <ScientificName>Polypodium polypodioides subsp. ecklonii (Kunze) Schelpe</ScientificName>
46 40
        <ScientificNameAuthor>(Kunze) Schelpe</ScientificNameAuthor>
47
        <Species>polypodioides</Species>
48 41
        <StateProvince>Southern</StateProvince>
49 42
        <Subspecies>ecklonii</Subspecies>
50 43
        <YearCollected>1985</YearCollected>
44
        <family>Polypodiaceae</family>
45
        <genus>Polypodium</genus>
46
        <species>polypodioides</species>
51 47
    </list>
52 48
</DwC>
inputs/MO/test/VegBIEN.specimens.xml.ref
23 23
                                </locationdetermination>
24 24
                            </location>
25 25
                        </location_id>
26
                        <obsstartdate/>
27
                        <obsenddate/>
28 26
                    </locationevent>
29 27
                </locationevent_id>
30 28
                <taxondetermination>
inputs/MO/maps/src.join.specimens.csv
1
MO[DwC]:mo_raw,VegBIEN:/specimenreplicate,Comments,Order
1
MO[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 2
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 3
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4 4
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
5 5
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6 6
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
7 7
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8
boundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8 9
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9 10
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
10 11
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
......
20 21
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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?",52
21 22
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
22 23
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24
minimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
23 25
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24 26
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
25 27
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
28
maximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
26 29
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
27 30
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
28 31
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
29 32
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
30 33
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
34
latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
31 35
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32 36
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
33 37
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
34 38
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
35 39
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
40
longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
36 41
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
37 42
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
38 43
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
44
maximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
39 45
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
40 46
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
41 47
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
48
minimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
42 49
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
43
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
50
EventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
44 51
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
45 52
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
53
dayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
46 54
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
55
monthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
47 56
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
57
yearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
58
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
48 59
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
49 60
CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
50
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
61
collectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
62
DateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
51 63
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
52 64
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
65
dayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
53 66
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
67
monthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
54 68
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
69
yearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
70
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
55 71
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
56 72
IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
73
identifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
57 74
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
58 75
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
59 76
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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","Brad: Bob, Nick, please is this mapping OK?",134
60 77
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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","Brad: Bob, Nick, please is this mapping OK?",134
61 78
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/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
62 79
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/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
80
scientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/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
63 81
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/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
64 82
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
65 83
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
66 84
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
85
subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
67 86
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
68 87
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
88
species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
69 89
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
70 90
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,147
71 91
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,147
......
81 101
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,142
82 102
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
83 103
RecordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
104
collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
84 105
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
85 106
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
86 107
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
......
89 110
FieldNotes,/description/_merge/1,,
90 111
Notes,/description/_merge/1,,
91 112
fieldNotes,/description/_merge/1,,
113
notes,/description/_merge/1,,
92 114
Remarks,/description/_merge/2,,158
93 115
TaxonRemarks,/description/_merge/2,,158
116
remarks,/description/_merge/2,,158
94 117
taxonRemarks,/description/_merge/2,,158
95 118
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
96 119
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
97 120
GlobalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
98 121
OccurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
122
globalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
99 123
occurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
100 124
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
101 125
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
126
collectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
102 127
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
103 128
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
104 129
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
......
108 133
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
109 134
BasisOfRecord,,** No join mapping for BasisOfRecord ** 
110 135
ContinentOcean,,** No join mapping for ContinentOcean ** 
111
ConvertedNotes,,
112 136
DateLastModified,,** No join mapping for DateLastModified ** 
113 137
IndividualCount,,** No join mapping for IndividualCount ** 
114 138
InstitutionCode,,** No join mapping for InstitutionCode ** 
115 139
TypeStatus,,** No join mapping for TypeStatus ** 
140
convertednotes,,
inputs/MO/maps/src.specimens.csv
1
"MO[DwC]:mo_raw"
1
"MO[DwC]"
2 2
"CatalogNumber"
3 3
"DateLastModified"
4 4
"InstitutionCode"
......
6 6
"ScientificName"
7 7
"BasisOfRecord"
8 8
"Kingdom"
9
"Family"
10
"Genus"
11
"Species"
9
"family"
10
"genus"
11
"species"
12 12
"Subspecies"
13 13
"ScientificNameAuthor"
14 14
"IdentifiedBy"
......
16 16
"CollectorNumber"
17 17
"Collector"
18 18
"DayCollected"
19
"CollectedDate"
20 19
"MonthCollected"
21 20
"YearCollected"
22 21
"ContinentOcean"
......
24 23
"StateProvince"
25 24
"County"
26 25
"Locality"
27
"VerbatimLongitude"
28
"VerbatimLatitude"
26
"longitude"
27
"latitude"
29 28
"MinimumElevation"
30 29
"MaximumElevation"
31 30
"IndividualCount"
32
"Notes"
33
"ConvertedNotes"
31
"notes"
32
"convertednotes"
inputs/MO/maps/DwC.specimens.csv
1
"MO[DwC]:mo_raw","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/","Comments"
2
"ConvertedNotes",,
1
"MO[DwC]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/","Comments"
2
"convertednotes",,
inputs/MO/maps/DwC.specimens.full.csv
1
MO[DwC]:mo_raw,"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
1
MO[DwC],"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",Comments
2 2
AcceptedNameUsage,AcceptedNameUsage
3 3
AcceptedNameUsageID,AcceptedNameUsageID
4 4
AssociatedMedia,AssociatedMedia
......
28 28
DatasetID,DatasetID
29 29
DatasetName,DatasetName
30 30
DateIdentified,DateIdentified
31
DateIdentified/_alt,DateIdentified/_alt
31 32
DateLastModified,DateLastModified
32 33
Day,Day
33 34
DayCollected,DayCollected
......
52 53
EndDayOfYear,EndDayOfYear
53 54
EstablishmentMeans,EstablishmentMeans
54 55
EventDate,EventDate
56
EventDate/_alt,EventDate/_alt
55 57
EventID,EventID
56 58
EventRemarks,EventRemarks
57 59
EventTime,EventTime
......
215 217
basisOfRecord,basisOfRecord
216 218
bed,bed
217 219
behavior,behavior
220
boundingBox,boundingBox
218 221
catalogNumber,catalogNumber
219 222
class,class
223
collectedDate,collectedDate
220 224
collectionCode,collectionCode
221 225
collectionID,collectionID
226
collector,collector
227
collectorNumber,collectorNumber
222 228
continent,continent
229
continentOcean,continentOcean
223 230
coordinatePrecision,coordinatePrecision
224 231
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
225 232
country,country
......
230 237
datasetName,datasetName
231 238
dateIdentified,dateIdentified
232 239
dateIdentified/_alt,dateIdentified/_alt
240
dateLastModified,dateLastModified
233 241
day,day
242
dayCollected,dayCollected
243
dayIdentified,dayIdentified
234 244
dcterms:accessRights,dcterms:accessRights
235 245
dcterms:bibliographicCitation,dcterms:bibliographicCitation
236 246
dcterms:language,dcterms:language
......
271 281
georeferenceVerificationStatus,georeferenceVerificationStatus
272 282
georeferencedBy,georeferencedBy
273 283
georeferencedDate,georeferencedDate
284
globalUniqueIdentifier,globalUniqueIdentifier
274 285
group,group
275 286
habitat,habitat
276 287
higherClassification,higherClassification
......
283 294
identificationRemarks,identificationRemarks
284 295
identificationVerificationStatus,identificationVerificationStatus
285 296
identifiedBy,identifiedBy
297
identifiedDate,identifiedDate
286 298
individualCount,individualCount
287 299
individualID,individualID
288 300
informationWithheld,informationWithheld
......
291 303
institutionID,institutionID
292 304
island,island
293 305
islandGroup,islandGroup
306
julianDay,julianDay
294 307
kingdom,kingdom
295 308
latestAgeOrHighestStage,latestAgeOrHighestStage
296 309
latestEonOrHighestEonothem,latestEonOrHighestEonothem
297 310
latestEpochOrHighestSeries,latestEpochOrHighestSeries
298 311
latestEraOrHighestErathem,latestEraOrHighestErathem
299 312
latestPeriodOrHighestSystem,latestPeriodOrHighestSystem
313
latitude,latitude
300 314
lifeStage,lifeStage
301 315
lithostratigraphicTerms,lithostratigraphicTerms
302 316
locality,locality
303 317
locationAccordingTo,locationAccordingTo
304 318
locationID,locationID
305 319
locationRemarks,locationRemarks
320
longitude,longitude
306 321
lowestBiostratigraphicZone,lowestBiostratigraphicZone
322
maximumDepth,maximumDepth
307 323
maximumDepthInMeters,maximumDepthInMeters
308 324
maximumDistanceAboveSurfaceInMeters,maximumDistanceAboveSurfaceInMeters
325
maximumElevation,maximumElevation
309 326
maximumElevationInMeters,maximumElevationInMeters
310 327
measurementAccuracy,measurementAccuracy
311 328
measurementDeterminedBy,measurementDeterminedBy
......
317 334
measurementUnit,measurementUnit
318 335
measurementValue,measurementValue
319 336
member,member
337
minimumDepth,minimumDepth
320 338
minimumDepthInMeters,minimumDepthInMeters
321 339
minimumDistanceAboveSurfaceInMeters,minimumDistanceAboveSurfaceInMeters
340
minimumElevation,minimumElevation
322 341
minimumElevationInMeters,minimumElevationInMeters
323 342
month,month
343
monthCollected,monthCollected
344
monthIdentified,monthIdentified
324 345
municipality,municipality
325 346
nameAccordingTo,nameAccordingTo
326 347
nameAccordingToID,nameAccordingToID
......
329 350
namePublishedInYear,namePublishedInYear
330 351
nomenclaturalCode,nomenclaturalCode
331 352
nomenclaturalStatus,nomenclaturalStatus
353
notes,notes
332 354
occurrenceID,occurrenceID
333 355
occurrenceRemarks,occurrenceRemarks
334 356
occurrenceStatus,occurrenceStatus
......
341 363
parentNameUsageID,parentNameUsageID
342 364
phylum,phylum
343 365
pointRadiusSpatialFit,pointRadiusSpatialFit
366
preparationType,preparationType
344 367
preparations,preparations
368
previousCatalogNumber,previousCatalogNumber
345 369
previousIdentifications,previousIdentifications
346 370
recordNumber,recordNumber
347 371
recordedBy,recordedBy
372
relatedCatalogItem,relatedCatalogItem
348 373
relatedResourceID,relatedResourceID
349 374
relationshipAccordingTo,relationshipAccordingTo
350 375
relationshipEstablishedDate,relationshipEstablishedDate
351 376
relationshipOfResource,relationshipOfResource
352 377
relationshipRemarks,relationshipRemarks
378
relationshipType,relationshipType
379
remarks,remarks
353 380
reproductiveCondition,reproductiveCondition
354 381
resourceID,resourceID
355 382
resourceRelationshipID,resourceRelationshipID
356 383
samplingEffort,samplingEffort
357 384
samplingProtocol,samplingProtocol
358 385
scientificName,scientificName
386
scientificNameAuthor,scientificNameAuthor
359 387
scientificNameAuthorship,scientificNameAuthorship
360 388
scientificNameID,scientificNameID
361 389
sex,sex
390
species,species
362 391
specificEpithet,specificEpithet
363 392
startDayOfYear,startDayOfYear
364 393
stateProvince,stateProvince
365 394
subgenus,subgenus
395
subspecies,subspecies
366 396
taxonConceptID,taxonConceptID
367 397
taxonID,taxonID
368 398
taxonRank,taxonRank
369 399
taxonRemarks,taxonRemarks
370 400
taxonomicStatus,taxonomicStatus
401
timeOfDay,timeOfDay
371 402
typeStatus,typeStatus
372 403
verbatimCoordinateSystem,verbatimCoordinateSystem
373 404
verbatimCoordinates,verbatimCoordinates
......
382 413
vernacularName,vernacularName
383 414
waterBody,waterBody
384 415
year,year
385
ConvertedNotes,,
416
yearCollected,yearCollected
417
yearIdentified,yearIdentified
418
convertednotes,,
inputs/MO/maps/VegBIEN.specimens.csv
1
MO[DwC]:mo_raw,VegBIEN:/specimenreplicate,Comments,Order
1
MO[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 2
CoordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
3 3
coordinateUncertaintyInMeters,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,,88
4 4
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
5 5
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,,89
6 6
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
7 7
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8
boundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
8 9
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/footprintgeometry_dwc,,91
9 10
County,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
10 11
county,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",,66
......
20 21
habitat,"/*_id/taxonoccurrence/*_id/locationevent/*_id/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?",52
21 22
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
22 23
MinimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24
minimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
23 25
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{./{elevation/_alt/2/_avg/min,elevationrange/_range/from}/_rangeStart/value,elevationrange/_range/to/_alt/2/_rangeEnd/value}",,71
24 26
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
25 27
MaximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
28
maximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
26 29
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to/_alt/1}",,72
27 30
DecimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
28 31
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
29 32
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
30 33
VerbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
34
latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
31 35
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
32 36
DecimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
33 37
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
34 38
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
35 39
VerbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
40
longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
36 41
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
37 42
MaximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
38 43
MaximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
44
maximumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
39 45
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/max,,75
40 46
MinimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
41 47
MinimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
48
minimumDepth,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
42 49
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/_avg/min,,74
43
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value",,44
50
EventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
44 51
eventDate/_alt,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt",Allow datasource to define custom eventDate mappings that don't pass through the default eventDate mapping,44
45 52
DayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
53
dayCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,44
46 54
MonthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
55
monthCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,44
47 56
YearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
57
yearCollected,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,44
58
EventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
48 59
eventDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/2",,44
49 60
CollectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
50
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value,,120
61
collectedDate,"/*_id/taxonoccurrence/*_id/locationevent/{obsstartdate/_*/date/_dateRangeStart,obsenddate/_*/date/_dateRangeEnd}/value/_alt/3",,44
62
DateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
51 63
dateIdentified/_alt,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt,Allow datasource to define custom dateIdentified mappings that don't pass through the default dateIdentified mapping,120
52 64
DayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
65
dayIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/day/_nullIf:[null=0,type=float]/value",,120
53 66
MonthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
67
monthIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/month/_nullIf:[null=0,type=float]/value",,120
54 68
YearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
69
yearIdentified,"/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/1/_date/year/_nullIf:[null=0,type=float]/value",,120
70
DateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
55 71
dateIdentified,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/2,,120
56 72
IdentifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
73
identifiedDate,/*_id/taxonoccurrence/taxondetermination[role=identifier]/determinationdate/_*/date/_dateRangeStart/value/_alt/3,,120
57 74
IdentifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
58 75
identifiedBy,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[iscurrent=true]/*_id/party/{givenname/_namePart/first,middlename/_namePart/middle,surname/_namePart/last}",Brad: Bob: does this look correct for VegBank?,119
59 76
ScientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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","Brad: Bob, Nick, please is this mapping OK?",134
60 77
scientificName,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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","Brad: Bob, Nick, please is this mapping OK?",134
61 78
ScientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/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
62 79
ScientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/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
80
scientificNameAuthor,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/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
63 81
scientificNameAuthorship,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/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
64 82
InfraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
65 83
Subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
66 84
infraspecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
85
subspecies,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname",,150
67 86
Species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
68 87
SpecificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
88
species,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
69 89
specificEpithet,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",,149
70 90
Genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,147
71 91
genus,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,147
......
81 101
kingdom,"/*_id/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true,iscurrent=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",,142
82 102
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
83 103
RecordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
104
collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
84 105
recordedBy,/*_id/taxonoccurrence/verbatimcollectorname,,23
85 106
CollectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
86 107
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
......
89 110
FieldNotes,/description/_merge/1,,
90 111
Notes,/description/_merge/1,,
91 112
fieldNotes,/description/_merge/1,,
113
notes,/description/_merge/1,,
92 114
Remarks,/description/_merge/2,,158
93 115
TaxonRemarks,/description/_merge/2,,158
116
remarks,/description/_merge/2,,158
94 117
taxonRemarks,/description/_merge/2,,158
95 118
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
96 119
catalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
97 120
GlobalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
98 121
OccurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
122
globalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
99 123
occurrenceID,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
100 124
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
101 125
RecordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
126
collectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
102 127
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1,,22
103 128
CollectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
104 129
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
......
118 143
Behavior,,,29
119 144
Continent,,Brad: OMIT,59
120 145
ContinentOcean,,Brad: OMIT,59
121
ConvertedNotes,,
122 146
CountryCode,,,64
123 147
DataGeneralizations,,,17
124 148
DatasetID,,,10
......
260 284
bed,,,117
261 285
behavior,,,29
262 286
continent,,Brad: OMIT,59
287
continentOcean,,Brad: OMIT,59
288
convertednotes,,
263 289
countryCode,,,64
264 290
dataGeneralizations,,,17
265 291
datasetID,,,10
266 292
datasetName,,,13
293
dateLastModified,,"Brad: Mapping to VegX is incorrect. I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified. Probably we should omit this field, although might be useful for updating changed records from this source.",1
267 294
day,,Brad: OMIT,50
268 295
dcterms:accessRights,,,5
269 296
dcterms:bibliographicCitation,,,6
......
312 339
institutionCode,,,
313 340
island,,,62
314 341
islandGroup,,,61
342
julianDay,,Brad: OMIT,50
315 343
latestAgeOrHighestStage,,,110
316 344
latestEonOrHighestEonothem,,,102
317 345
latestEpochOrHighestSeries,,,108
......
353 381
parentNameUsage,,,136
354 382
parentNameUsageID,,,129
355 383
pointRadiusSpatialFit,,,90
384
preparationType,,Brad: OMIT,32
356 385
preparations,,Brad: OMIT,32
386
previousCatalogNumber,,?; Brad: OMIT,35
357 387
previousIdentifications,,Brad: OMIT,35
388
relatedCatalogItem,,Brad: OMIT,161
358 389
relatedResourceID,,Brad: OMIT,161
359 390
relationshipAccordingTo,,,163
360 391
relationshipEstablishedDate,,,164
361 392
relationshipOfResource,,Brad: OMIT,162
362 393
relationshipRemarks,,,165
394
relationshipType,,Brad: OMIT,162
363 395
reproductiveCondition,,,28
364 396
resourceID,,,160
365 397
resourceRelationshipID,,,159
......
372 404
taxonID,,,126
373 405
taxonRank,,,151
374 406
taxonomicStatus,,,156
407
timeOfDay,,Brad: OMIT,45
375 408
typeStatus,,Brad: OMIT (?). Indicates whether this specimen served as type for taxon name. Probably not relevant for BIEN,125
376 409
verbatimCoordinateSystem,,,83
377 410
verbatimCoordinates,,,80

Also available in: Unified diff