Project

General

Profile

« Previous | Next » 

Revision 1316

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegBIEN mappings: Map namedplaces using new rank field

View differences:

inputs/NYBG/test/VegBIEN.specimens.xml.ref
10 10 
                                <locationdetermination>
11 11 
                                    <namedplace_id>
12 12 
                                        <namedplace>
13 
                                            <placesystem>area|country|territory</placesystem>
13 
                                            <rank>country</rank>
14 14 
                                            <placename>Peru</placename>
15 15 
                                        </namedplace>
16 16 
                                    </namedplace_id>
......
18 18 
                                <locationdetermination>
19 19 
                                    <namedplace_id>
20 20 
                                        <namedplace>
21 
                                            <placesystem>region|state|province</placesystem>
22 
                                            <placename>Madre de Dios</placename>
21 
                                            <rank>county</rank>
22 
                                            <placename>Man&#250;</placename>
23 23 
                                        </namedplace>
24 24 
                                    </namedplace_id>
25 25 
                                </locationdetermination>
26 26 
                                <locationdetermination>
27 27 
                                    <namedplace_id>
28 28 
                                        <namedplace>
29 
                                            <placesystem>county</placesystem>
30 
                                            <placename>Man&#250;</placename>
29 
                                            <rank>stateProvince</rank>
30 
                                            <placename>Madre de Dios</placename>
31 31 
                                        </namedplace>
32 32 
                                    </namedplace_id>
33 33 
                                </locationdetermination>
......
177 177 
                                <locationdetermination>
178 178 
                                    <namedplace_id>
179 179 
                                        <namedplace>
180 
                                            <placesystem>area|country|territory</placesystem>
180 
                                            <rank>country</rank>
181 181 
                                            <placename>Belize</placename>
182 182 
                                        </namedplace>
183 183 
                                    </namedplace_id>
......
185 185 
                                <locationdetermination>
186 186 
                                    <namedplace_id>
187 187 
                                        <namedplace>
188 
                                            <placesystem>region|state|province</placesystem>
188 
                                            <rank>stateProvince</rank>
189 189 
                                            <placename>Belize District</placename>
190 190 
                                        </namedplace>
191 191 
                                    </namedplace_id>
inputs/NYBG/maps/VegBIEN.specimens.csv
1 1 
NYBG[DwC]:nybg_raw,VegBIEN:/specimenreplicate,Comments,Order
2 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
3 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
4 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
5 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
6 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
7 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
2 
Country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
3 
country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
4 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
5 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
6 
StateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
7 
stateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
8 8 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
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
inputs/SALVIAS/test/VegBIEN.plots.xml.ref
8 8 
                <locationdetermination>
9 9 
                    <namedplace_id>
10 10 
                        <namedplace>
11 
                            <placesystem>area|country|territory</placesystem>
12 
                            <placename>Ecuador</placename>
11 
                            <rank>continent</rank>
12 
                            <placename>South America</placename>
13 13 
                        </namedplace>
14 14 
                    </namedplace_id>
15 15 
                </locationdetermination>
16 16 
                <locationdetermination>
17 17 
                    <namedplace_id>
18 18 
                        <namedplace>
19 
                            <placesystem>continent</placesystem>
20 
                            <placename>South America</placename>
19 
                            <rank>country</rank>
20 
                            <placename>Ecuador</placename>
21 21 
                        </namedplace>
22 22 
                    </namedplace_id>
23 23 
                </locationdetermination>
......
59 59 
                <locationdetermination>
60 60 
                    <namedplace_id>
61 61 
                        <namedplace>
62 
                            <placesystem>area|country|territory</placesystem>
63 
                            <placename>Germany</placename>
62 
                            <rank>continent</rank>
63 
                            <placename>Europe</placename>
64 64 
                        </namedplace>
65 65 
                    </namedplace_id>
66 66 
                </locationdetermination>
67 67 
                <locationdetermination>
68 68 
                    <namedplace_id>
69 69 
                        <namedplace>
70 
                            <placesystem>continent</placesystem>
71 
                            <placename>Europe</placename>
70 
                            <rank>country</rank>
71 
                            <placename>Germany</placename>
72 72 
                        </namedplace>
73 73 
                    </namedplace_id>
74 74 
                </locationdetermination>
inputs/SALVIAS/maps/VegBIEN.plots.csv
1 1 
SALVIAS:plotMetadata,VegBIEN:/locationevent,Comments
2 2 
plot_area_ha,/*_id/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
3 3 
Elev,/*_id/location/elevation/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
4 
Country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",
5 
PolDiv1,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince
6 
MajorGeo,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename,
7 
pol2,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,Brad: No pol2=countyParish
4 
MajorGeo,/*_id/location/locationdetermination(/*_id/namedplace[rank=continent])/placename,
5 
Country,/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,
6 
pol2,/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,Brad: No pol2=countyParish
7 
PolDiv1,/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,Brad: No; pol1=stateProvince
8 8 
Locality_Description,/*_id/location/locationnarrative,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
9 9 
slope_aspect,/*_id/location/slopeaspect,
10 10 
slope_gradient,/*_id/location/slopegradient,
inputs/NYBG-CSV/test/VegBIEN.specimens.xml.ref
10 10 
                                <locationdetermination>
11 11 
                                    <namedplace_id>
12 12 
                                        <namedplace>
13 
                                            <placesystem>area|country|territory</placesystem>
13 
                                            <rank>country</rank>
14 14 
                                            <placename>Peru</placename>
15 15 
                                        </namedplace>
16 16 
                                    </namedplace_id>
......
18 18 
                                <locationdetermination>
19 19 
                                    <namedplace_id>
20 20 
                                        <namedplace>
21 
                                            <placesystem>region|state|province</placesystem>
22 
                                            <placename>Madre de Dios</placename>
21 
                                            <rank>county</rank>
22 
                                            <placename>Man&#250;</placename>
23 23 
                                        </namedplace>
24 24 
                                    </namedplace_id>
25 25 
                                </locationdetermination>
26 26 
                                <locationdetermination>
27 27 
                                    <namedplace_id>
28 28 
                                        <namedplace>
29 
                                            <placesystem>county</placesystem>
30 
                                            <placename>Man&#250;</placename>
29 
                                            <rank>stateProvince</rank>
30 
                                            <placename>Madre de Dios</placename>
31 31 
                                        </namedplace>
32 32 
                                    </namedplace_id>
33 33 
                                </locationdetermination>
......
177 177 
                                <locationdetermination>
178 178 
                                    <namedplace_id>
179 179 
                                        <namedplace>
180 
                                            <placesystem>area|country|territory</placesystem>
180 
                                            <rank>country</rank>
181 181 
                                            <placename>Belize</placename>
182 182 
                                        </namedplace>
183 183 
                                    </namedplace_id>
......
185 185 
                                <locationdetermination>
186 186 
                                    <namedplace_id>
187 187 
                                        <namedplace>
188 
                                            <placesystem>region|state|province</placesystem>
188 
                                            <rank>stateProvince</rank>
189 189 
                                            <placename>Belize District</placename>
190 190 
                                        </namedplace>
191 191 
                                    </namedplace_id>
inputs/NYBG-CSV/maps/VegBIEN.specimens.csv
1 1 
NYBG-CSV[DwC],VegBIEN:/specimenreplicate,Comments,Order
2 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
3 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
4 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
5 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
6 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
7 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
2 
Country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
3 
country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
4 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
5 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
6 
StateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
7 
stateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
8 8 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
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
inputs/UArizona/test/VegBIEN.specimens.xml.ref
10 10 
                                <locationdetermination>
11 11 
                                    <namedplace_id>
12 12 
                                        <namedplace>
13 
                                            <placesystem>area|country|territory</placesystem>
13 
                                            <rank>country</rank>
14 14 
                                            <placename>Mexico</placename>
15 15 
                                        </namedplace>
16 16 
                                    </namedplace_id>
......
18 18 
                                <locationdetermination>
19 19 
                                    <namedplace_id>
20 20 
                                        <namedplace>
21 
                                            <placesystem>region|state|province</placesystem>
21 
                                            <rank>stateProvince</rank>
22 22 
                                            <placename>Guerrero</placename>
23 23 
                                        </namedplace>
24 24 
                                    </namedplace_id>
......
168 168 
                                <locationdetermination>
169 169 
                                    <namedplace_id>
170 170 
                                        <namedplace>
171 
                                            <placesystem>area|country|territory</placesystem>
171 
                                            <rank>country</rank>
172 172 
                                            <placename>Afghanistan</placename>
173 173 
                                        </namedplace>
174 174 
                                    </namedplace_id>
inputs/UArizona/maps/VegBIEN.specimens.csv
1 1 
UArizona[DwC]:ariz_raw,VegBIEN:/specimenreplicate,Comments,Order
2 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
3 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
4 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
5 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
6 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
7 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
2 
Country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
3 
country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
4 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
5 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
6 
StateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
7 
stateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
8 8 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
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
inputs/SALVIAS-CSV/test/VegBIEN.plots.xml.ref
8 8 
                <locationdetermination>
9 9 
                    <namedplace_id>
10 10 
                        <namedplace>
11 
                            <placesystem>area|country|territory</placesystem>
12 
                            <placename>Peru</placename>
11 
                            <rank>continent</rank>
12 
                            <placename>South America</placename>
13 13 
                        </namedplace>
14 14 
                    </namedplace_id>
15 15 
                </locationdetermination>
16 16 
                <locationdetermination>
17 17 
                    <namedplace_id>
18 18 
                        <namedplace>
19 
                            <placesystem>region|state|province</placesystem>
20 
                            <placename>Loreto</placename>
19 
                            <rank>country</rank>
20 
                            <placename>Peru</placename>
21 21 
                        </namedplace>
22 22 
                    </namedplace_id>
23 23 
                </locationdetermination>
24 24 
                <locationdetermination>
25 25 
                    <namedplace_id>
26 26 
                        <namedplace>
27 
                            <placesystem>continent</placesystem>
28 
                            <placename>South America</placename>
27 
                            <rank>stateProvince</rank>
28 
                            <placename>Loreto</placename>
29 29 
                        </namedplace>
30 30 
                    </namedplace_id>
31 31 
                </locationdetermination>
......
58 58 
                <locationdetermination>
59 59 
                    <namedplace_id>
60 60 
                        <namedplace>
61 
                            <placesystem>area|country|territory</placesystem>
62 
                            <placename>Peru</placename>
61 
                            <rank>continent</rank>
62 
                            <placename>South America</placename>
63 63 
                        </namedplace>
64 64 
                    </namedplace_id>
65 65 
                </locationdetermination>
66 66 
                <locationdetermination>
67 67 
                    <namedplace_id>
68 68 
                        <namedplace>
69 
                            <placesystem>region|state|province</placesystem>
70 
                            <placename>Loreto</placename>
69 
                            <rank>country</rank>
70 
                            <placename>Peru</placename>
71 71 
                        </namedplace>
72 72 
                    </namedplace_id>
73 73 
                </locationdetermination>
74 74 
                <locationdetermination>
75 75 
                    <namedplace_id>
76 76 
                        <namedplace>
77 
                            <placesystem>continent</placesystem>
78 
                            <placename>South America</placename>
77 
                            <rank>stateProvince</rank>
78 
                            <placename>Loreto</placename>
79 79 
                        </namedplace>
80 80 
                    </namedplace_id>
81 81 
                </locationdetermination>
inputs/SALVIAS-CSV/test/import.plots.out.ref
1 
Inserted 20 new rows into database
1 
Inserted 14 new rows into database
inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv
1 1 
SALVIAS-CSV,VegBIEN:/locationevent,Comments
2 2 
plot_area_ha,/*_id/location/area,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
3 3 
elev_m,/*_id/location/elevation/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
4 
country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",
5 
pol1,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince
6 
major_geo,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename,
7 
pol2,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,Brad: No pol2=countyParish
4 
major_geo,/*_id/location/locationdetermination(/*_id/namedplace[rank=continent])/placename,
5 
country,/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,
6 
pol2,/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,Brad: No pol2=countyParish
7 
pol1,/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,Brad: No; pol1=stateProvince
8 8 
locality_description,/*_id/location/locationnarrative,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
9 9 
slope_aspect,/*_id/location/slopeaspect,
10 10 
slope_gradient,/*_id/location/slopegradient,
mappings/VegX-VegBIEN.plots.csv
1 1 
VegX:/*s/plotObservation,VegBIEN:/locationevent,Comments
2 2 
/*UniqueIdentifierID->/*s/plot/area,/*_id/location/area,
3 3 
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/location/elevation/_alt/1,
4 
/*UniqueIdentifierID->/*s/plot/country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",
5 
/*UniqueIdentifierID->/*s/plot/state,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",
6 
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename,
7 
/*UniqueIdentifierID->/*s/plot/county,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,
4 
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_id/location/locationdetermination(/*_id/namedplace[rank=continent])/placename,
5 
/*UniqueIdentifierID->/*s/plot/country,/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,
6 
/*UniqueIdentifierID->/*s/plot/county,/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,
7 
/*UniqueIdentifierID->/*s/plot/state,/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,
8 8 
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy,
9 9 
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,
10 10 
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/location/locationnarrative,
mappings/VegX-VegBIEN.organisms.csv
1 1 
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonoccurrence,Comments
2 2 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area,/*_id/locationevent/*_id/location/area,
3 3 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/locationevent/*_id/location/elevation/_alt/1,
4 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country,"/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",
5 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state,"/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",
6 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename,
7 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,
4 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=continent])/placename,
5 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,
6 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,
7 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,
8 8 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy,
9 9 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,
10 10 
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/locationevent/*_id/location/locationnarrative,
mappings/DwC.self.specimens.csv
1 1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/"
2 2 
Country,Country
3 3 
country,country
4 
County,County
5 
county,county
4 6 
StateProvince,StateProvince
5 7 
stateProvince,stateProvince
6 
County,County
7 
county,county
8 8 
CoordinatePrecision,CoordinatePrecision
9 9 
coordinatePrecision,coordinatePrecision
10 10 
BoundingBox,BoundingBox
mappings/DwC2.ci-VegBIEN.specimens.csv
1 1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order
2 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
3 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
4 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
5 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
6 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
7 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
2 
Country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
3 
country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
4 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
5 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
6 
StateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
7 
stateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
8 8 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
9 9 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
10 10 
FootprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
mappings/DwC2-VegBIEN.specimens.csv
1 1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order
2 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
3 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
4 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
2 
country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
3 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
4 
stateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
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 7 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_merge/1,,68
mappings/for_review/VegX-VegBIEN.plots.csv
1 1 
VegX:/*s/plotObservation,VegBIEN:/locationevent,Comments
2 2 
//plot/area,//location/area,
3 3 
//geospatial/verbatimElevation,//location/elevation/_alt/1,
4 
//plot/country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename",
5 
//plot/state,"//*_id/namedplace[placesystem=""region|state|province""]/placename",
6 
//plot/simpleUserdefined[name=majorGeo]/value,//*_id/namedplace[placesystem=continent]/placename,
7 
//plot/county,//*_id/namedplace[placesystem=county]/placename,
4 
//plot/simpleUserdefined[name=majorGeo]/value,//*_id/namedplace[rank=continent]/placename,
5 
//plot/country,//*_id/namedplace[rank=country]/placename,
6 
//plot/county,//*_id/namedplace[rank=county]/placename,
7 
//plot/state,//*_id/namedplace[rank=stateProvince]/placename,
8 8 
//geospatial/CoordinateUncertaintyInMeters,//location/locationdetermination[]/coordsaccuracy,
9 9 
//geospatial/FootprintWKT,//location/locationdetermination[]/footprintgeometry_dwc,
10 10 
//plot/simpleUserdefined[name=localityDescription]/value,//location/locationnarrative,
mappings/for_review/VegX-VegBIEN.organisms.csv
1 1 
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonoccurrence,Comments
2 2 
//plot/area,//location/area,
3 3 
//geospatial/verbatimElevation,//location/elevation/_alt/1,
4 
//plot/country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename",
5 
//plot/state,"//*_id/namedplace[placesystem=""region|state|province""]/placename",
6 
//plot/simpleUserdefined[name=majorGeo]/value,//*_id/namedplace[placesystem=continent]/placename,
7 
//plot/county,//*_id/namedplace[placesystem=county]/placename,
4 
//plot/simpleUserdefined[name=majorGeo]/value,//*_id/namedplace[rank=continent]/placename,
5 
//plot/country,//*_id/namedplace[rank=country]/placename,
6 
//plot/county,//*_id/namedplace[rank=county]/placename,
7 
//plot/state,//*_id/namedplace[rank=stateProvince]/placename,
8 8 
//geospatial/CoordinateUncertaintyInMeters,//location/locationdetermination[]/coordsaccuracy,
9 9 
//geospatial/FootprintWKT,//location/locationdetermination[]/footprintgeometry_dwc,
10 10 
//plot/simpleUserdefined[name=localityDescription]/value,//location/locationnarrative,
mappings/for_review/DwC2-VegBIEN.specimens.csv
1 1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order
2 
country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename",Brad: Required; reject record if this field NULL,63
3 
stateProvince,"//*_id/namedplace[placesystem=""region|state|province""]/placename",,65
4 
county,//*_id/namedplace[placesystem=county]/placename,,66
2 
country,//*_id/namedplace[rank=country]/placename,Brad: Required; reject record if this field NULL,63
3 
county,//*_id/namedplace[rank=county]/placename,,66
4 
stateProvince,//*_id/namedplace[rank=stateProvince]/placename,,65
5 5 
coordinatePrecision,//location/locationdetermination[]/coordsaccuracy/_noCV/value,,89
6 6 
footprintWKT,//location/locationdetermination[]/footprintgeometry_dwc,,91
7 7 
locality,//location/locationnarrative/_merge/1,,68
mappings/DwC-VegBIEN.specimens.csv
1 1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[institutionID=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order
2 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
3 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
4 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
5 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
6 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
7 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
2 
Country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
3 
country,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=country])/placename,Brad: Required; reject record if this field NULL,63
4 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
5 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=county])/placename,,66
6 
StateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
7 
stateProvince,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[rank=stateProvince])/placename,,65
8 8 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
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

Also available in: Unified diff