Project

General

Profile

« Previous | Next » 

Revision 1207

Added by Aaron Marcuse-Kubitza over 12 years ago

DwC mappings: Fixed user-defined field mappings according to Brad Boyle's changes

View differences:

inputs/NYBG/test/import.specimens.out.ref
1 
Inserted 65 new rows into database
1 
Inserted 60 new rows into database
inputs/NYBG/test/VegBIEN.specimens.xml.ref
31 31 
                                        </namedplace>
32 32 
                                    </namedplace_id>
33 33 
                                </locationdetermination>
34 
                                <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station</locationnarrative>
34 
                                <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station; habitat: Floodplain forest</locationnarrative>
35 35 
                                <elevation>350.0</elevation>
36 36 
                                <elevationrange>0.0</elevationrange>
37 37 
                                <locationdetermination>
......
42 42 
                                <centerlongitude>-71.40000000</centerlongitude>
43 43 
                            </location>
44 44 
                        </location_id>
45 
                        <commclass><commdetermination><commconcept_id><commconcept><commname_id><commname><commname>Floodplain forest</commname></commname></commname_id></commconcept></commconcept_id></commdetermination></commclass>
46 45 
                        <obsstartdate>1984-08-20</obsstartdate>
47 46 
                    </locationevent>
48 47 
                </locationevent_id>
inputs/NYBG/maps/DwC.specimens.csv
3 3 
"InstitutionCode",,"Map to nothing so it doesn't overwrite the auto-generated institutionCode"
4 4 
"IdentifiedDate",,
5 5 
"CollectedDate",,
6 
"Locality","Locality/_merge/1",
6 7 
"MinimumElevation","MinimumElevation/_nullIf:[null=.]/value",
7 8 
"Notes","Notes/_merge/1",
8 
"Habitat","habitat/_merge/1",
9 
"Habitat","habitat",
9 10 
"PlantFungusDescription","Notes/_merge/2/_label[label=""plant fungus""]/value",
10 
"Substrate","bien.substrate",
11 
"Vegetation","habitat/_merge/2",
11 
"Substrate","Locality/_merge/2/_label[label=""substrate""]/value",
12 
"Vegetation","Locality/_merge/3/_label[label=""vegetation""]/value",
12 13 
"UniqueNYInternalRecordNumber","occurrenceID",
inputs/NYBG/maps/DwC.specimens.full.csv
21 21 
JulianDay,JulianDay
22 22 
Kingdom,Kingdom
23 23 
Latitude,Latitude
24 
Locality,Locality
24 
Locality,Locality/_merge/1,
25 
Substrate,"Locality/_merge/2/_label[label=""substrate""]/value",
26 
Vegetation,"Locality/_merge/3/_label[label=""vegetation""]/value",
25 27 
Longitude,Longitude
26 28 
MaximumDepth,MaximumDepth
27 29 
MaximumElevation,MaximumElevation
......
57 59 
basisOfRecord,basisOfRecord
58 60 
bed,bed
59 61 
behavior,behavior
60 
Substrate,bien.substrate,
61 
bien.substrate,bien.substrate
62 62 
catalogNumber,catalogNumber
63 63 
class,class
64 64 
collectionCode,collectionCode
......
114 114 
georeferencedBy,georeferencedBy
115 115 
georeferencedDate,georeferencedDate
116 116 
group,group
117 
Habitat,habitat,
117 118 
habitat,habitat
118 
Habitat,habitat/_merge/1,
119 
Vegetation,habitat/_merge/2,
120 119 
higherClassification,higherClassification
121 120 
higherGeography,higherGeography
122 121 
higherGeographyID,higherGeographyID
inputs/NYBG/maps/VegBIEN.specimens.csv
9 9 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
10 10 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
11 11 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
12 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/1,,68
13 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
14 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
12 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
13 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
14 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/1,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
15 
Substrate,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/2/_label[label=""substrate""]/value","Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
16 
Vegetation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/3/_label[label=""vegetation""]/value","Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
17 
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
18 
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
15 19 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
16 20 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
17 21 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
......
22 26 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
23 27 
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
24 28 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
25 
habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
26 
Habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/1,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
27 
Vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/2,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
28 
Substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
29 
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
30 29 
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44
31 30 
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44
32 31 
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44
inputs/NYBG-CSV/test/import.specimens.out.ref
1 
Inserted 65 new rows into database
1 
Inserted 60 new rows into database
inputs/NYBG-CSV/test/VegBIEN.specimens.xml.ref
31 31 
                                        </namedplace>
32 32 
                                    </namedplace_id>
33 33 
                                </locationdetermination>
34 
                                <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station</locationnarrative>
34 
                                <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station; habitat: Floodplain forest</locationnarrative>
35 35 
                                <elevation>350.0</elevation>
36 36 
                                <elevationrange>0.0</elevationrange>
37 37 
                                <locationdetermination>
......
42 42 
                                <centerlongitude>-71.40</centerlongitude>
43 43 
                            </location>
44 44 
                        </location_id>
45 
                        <commclass><commdetermination><commconcept_id><commconcept><commname_id><commname><commname>Floodplain forest</commname></commname></commname_id></commconcept></commconcept_id></commdetermination></commclass>
46 45 
                        <obsstartdate>1984-08-20</obsstartdate>
47 46 
                    </locationevent>
48 47 
                </locationevent_id>
inputs/NYBG-CSV/maps/DwC.specimens.csv
1 1 
"NYBG-CSV[DwC]","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionCode=$/_ignore/inLabel]/","Comments"
2 2 
"key",,
3 3 
"InstitutionCode",,"Map to nothing so it doesn't overwrite the auto-generated institutionCode"
4 
"Locality","Locality/_merge/1",
4 5 
"MinimumElevation","MinimumElevation/_nullIf:[null=.]/value",
5 6 
"Notes","Notes/_merge/1",
6 
"Habitat","habitat/_merge/1",
7 
"Habitat","habitat",
7 8 
"PlantFungusDescription","Notes/_merge/2/_label[label=""plant fungus""]/value",
8 
"Substrate","bien.substrate",
9 
"Vegetation","habitat/_merge/2",
9 
"Substrate","Locality/_merge/2/_label[label=""substrate""]/value",
10 
"Vegetation","Locality/_merge/3/_label[label=""vegetation""]/value",
10 11 
"UniqueNYInternalRecordNumber","occurrenceID",
inputs/NYBG-CSV/maps/DwC.specimens.full.csv
21 21 
JulianDay,JulianDay
22 22 
Kingdom,Kingdom
23 23 
Latitude,Latitude
24 
Locality,Locality
24 
Locality,Locality/_merge/1,
25 
Substrate,"Locality/_merge/2/_label[label=""substrate""]/value",
26 
Vegetation,"Locality/_merge/3/_label[label=""vegetation""]/value",
25 27 
Longitude,Longitude
26 28 
MaximumDepth,MaximumDepth
27 29 
MaximumElevation,MaximumElevation
......
57 59 
basisOfRecord,basisOfRecord
58 60 
bed,bed
59 61 
behavior,behavior
60 
Substrate,bien.substrate,
61 
bien.substrate,bien.substrate
62 62 
catalogNumber,catalogNumber
63 63 
class,class
64 64 
collectionCode,collectionCode
......
114 114 
georeferencedBy,georeferencedBy
115 115 
georeferencedDate,georeferencedDate
116 116 
group,group
117 
Habitat,habitat,
117 118 
habitat,habitat
118 
Habitat,habitat/_merge/1,
119 
Vegetation,habitat/_merge/2,
120 119 
higherClassification,higherClassification
121 120 
higherGeography,higherGeography
122 121 
higherGeographyID,higherGeographyID
inputs/NYBG-CSV/maps/VegBIEN.specimens.csv
9 9 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
10 10 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
11 11 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
12 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/1,,68
13 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
14 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
12 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
13 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
14 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/1,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
15 
Substrate,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/2/_label[label=""substrate""]/value","Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
16 
Vegetation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2/_merge/3/_label[label=""vegetation""]/value","Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
17 
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
18 
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
15 19 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
16 20 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
17 21 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
......
22 26 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
23 27 
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
24 28 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
25 
habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
26 
Habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/1,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
27 
Vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/2,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
28 
Substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
29 
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
30 29 
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44
31 30 
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44
32 31 
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44
mappings/DwC.self.specimens.csv
12 12 
locality,locality
13 13 
Locality,Locality
14 14 
verbatimLocality,verbatimLocality
15 
habitat,habitat
15 16 
MaximumElevation,MaximumElevation
16 17 
maximumElevationInMeters,maximumElevationInMeters
17 18 
MinimumElevation,MinimumElevation
......
22 23 
decimalLongitude,decimalLongitude
23 24 
Longitude,Longitude
24 25 
verbatimLongitude,verbatimLongitude
25 
habitat,habitat
26 
bien.substrate,bien.substrate
27 26 
eventDate,eventDate
28 27 
DayCollected,DayCollected
29 28 
MonthCollected,MonthCollected
mappings/for_review/DwC2-VegBIEN.specimens.csv
4 4 
county,//*_id/namedplace[placesystem=county]/placename,,66
5 5 
coordinatePrecision,//location/locationdetermination[]/coordsaccuracy/_noCV/value,,89
6 6 
footprintWKT,//location/locationdetermination[]/footprintgeometry_dwc,,91
7 
locality,//location/locationnarrative/_alt/1,,68
8 
verbatimLocality,//location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
7 
locality,//location/locationnarrative/_merge/1,,68
8 
verbatimLocality,//location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
9 
habitat,"//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
9 10 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
10 11 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
11 12 
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[]/latitude,centerlatitude}/_alt/1/_nullIf/value",,85
12 13 
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[]/latitude,centerlatitude}/_alt/2/_nullIf/value",,81
13 14 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[]/longitude,centerlongitude}/_alt/1/_nullIf/value",,86
14 15 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[]/longitude,centerlongitude}/_alt/2/_nullIf/value",,82
15 
habitat,//*/commname,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
16 
bien.substrate,//locationevent/landscapenarrative,,
17 16 
eventDate,//locationevent/obsstartdate,,44
18 17 
maximumDepthInMeters,//waterdepth/max,,75
19 18 
minimumDepthInMeters,//waterdepth/min,,74
mappings/DwC-VegBIEN.specimens.csv
9 9 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
10 10 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
11 11 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
12 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/1,,68
13 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
14 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
12 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
13 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
14 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
15 
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
15 16 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
16 17 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
17 18 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
......
22 23 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
23 24 
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
24 25 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
25 
habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
26 
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
27 26 
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44
28 27 
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/day,,44
29 28 
MonthCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_date/month,,44
mappings/DwC2-VegBIEN.specimens.csv
4 4 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
5 5 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
6 6 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
7 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/1,,68
8 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
7 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
8 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
9 
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
9 10 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
10 11 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
11 12 
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
12 13 
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
13 14 
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
14 15 
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
15 
habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52
16 
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
17 16 
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44
18 17 
maximumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/max,,75
19 18 
minimumDepthInMeters,/*_id/taxonoccurrence/*_id/locationevent/waterdepth/min,,74

Also available in: Unified diff