Project

General

Profile

« Previous | Next » 

Revision 1043

Added by Aaron Marcuse-Kubitza almost 13 years ago

DwC-VegBIEN mapping: Added datasource name to location.reference using /_ignore/inLabel

View differences:

inputs/NYBG/test/import.specimens.out.ref
1 
Inserted 83 new rows into database
1 
Inserted 85 new rows into database
inputs/NYBG/test/DwC.specimens.xml.ref
1 1 
<?xml version="1.0" ?>
2 2 
<DwC xmlns:dcterms="http://purl.org/dc/terms/">
3 3 
    <list id="0">
4 
        <bien.datasource>NYBG</bien.datasource>
4 5 
        <dcterms:modified>2005-2-22T14:47:32.000EST</dcterms:modified>
5 6 
        <institutionCode>NY</institutionCode>
6 7 
        <collectionCode>Herbarium</collectionCode>
......
31 32 
        <occurrenceID>816590</occurrenceID>
32 33 
    </list>
33 34 
    <list id="1">
35 
        <bien.datasource>NYBG</bien.datasource>
34 36 
        <dcterms:modified>2004-1-13T00:00EST</dcterms:modified>
35 37 
        <institutionCode>NY</institutionCode>
36 38 
        <collectionCode>Herbarium</collectionCode>
inputs/NYBG/test/VegBIEN.specimens.xml.ref
7 7 
                    <locationevent>
8 8 
                        <location_id>
9 9 
                            <location>
10 
                                <elevation>350.0</elevation>
11 
                                <elevationrange>0.0</elevationrange>
12 
                                <reference_id><reference><shortname>NYBG</shortname></reference></reference_id>
10 13 
                                <locationdetermination>
11 14 
                                    <namedplace_id>
12 15 
                                        <namedplace>
......
36 39 
                                    <longitude>-71.40000000</longitude>
37 40 
                                </locationdetermination>
38 41 
                                <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station</locationnarrative>
39 
                                <elevation>350.0</elevation>
40 
                                <elevationrange>0.0</elevationrange>
41 42 
                            </location>
42 43 
                        </location_id>
43 44 
                        <obsstartdate>1984-08-20</obsstartdate>
......
158 159 
                    <locationevent>
159 160 
                        <location_id>
160 161 
                            <location>
162 
                                <elevation>15.0</elevation>
163 
                                <elevationrange>0.0</elevationrange>
164 
                                <reference_id><reference><shortname>NYBG</shortname></reference></reference_id>
161 165 
                                <locationdetermination>
162 166 
                                    <namedplace_id>
163 167 
                                        <namedplace>
......
179 183 
                                    <longitude>-88.50000000</longitude>
180 184 
                                </locationdetermination>
181 185 
                                <locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative>
182 
                                <elevation>15.0</elevation>
183 
                                <elevationrange>0.0</elevationrange>
184 186 
                            </location>
185 187 
                        </location_id>
186 188 
                        <obsstartdate>1994-01-17</obsstartdate>
inputs/NYBG/maps/DwC.specimens.csv
1 
"NYBG:nybg_raw","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list/","Comments"
1 
"NYBG:nybg_raw","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[bien.datasource=$/_ignore/inLabel]/","Comments"
2 2 
"key",,
3 3 
"DateLastModified","dcterms:modified",
4 4 
"InstitutionCode","institutionCode",
inputs/NYBG/maps/VegBIEN.specimens.csv
1 1 
NYBG: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 
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
5 2 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
6 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
7 
Latitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/latitude/_alt/2,,81
8 
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude/_alt/2,,82
9 
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
10 3 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
11 4 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
5 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
6 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
7 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
8 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
9 
Latitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/latitude/_alt/2,,81
10 
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/longitude/_alt/2,,82
11 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
12 12 
Vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,,
13 13 
Substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
14 14 
CollectedDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/1/_*/date,,44
inputs/NYBG-CSV/test/import.specimens.out.ref
1 
Inserted 83 new rows into database
1 
Inserted 85 new rows into database
inputs/NYBG-CSV/test/DwC.specimens.xml.ref
1 1 
<?xml version="1.0" ?>
2 2 
<DwC xmlns:dcterms="http://purl.org/dc/terms/">
3 3 
    <list id="0">
4 
        <bien.datasource>NYBG</bien.datasource>
4 5 
        <dcterms:modified>2005-2-22T14:47:32.000EST</dcterms:modified>
5 6 
        <institutionCode>NY</institutionCode>
6 7 
        <collectionCode>Herbarium</collectionCode>
......
31 32 
        <occurrenceID>816590</occurrenceID>
32 33 
    </list>
33 34 
    <list id="1">
35 
        <bien.datasource>NYBG</bien.datasource>
34 36 
        <dcterms:modified>2004-1-13T00:00EST</dcterms:modified>
35 37 
        <institutionCode>NY</institutionCode>
36 38 
        <collectionCode>Herbarium</collectionCode>
inputs/NYBG-CSV/test/VegBIEN.specimens.xml.ref
7 7 
                    <locationevent>
8 8 
                        <location_id>
9 9 
                            <location>
10 
                                <elevation>350.0</elevation>
11 
                                <elevationrange>0.0</elevationrange>
12 
                                <reference_id><reference><shortname>NYBG</shortname></reference></reference_id>
10 13 
                                <locationdetermination>
11 14 
                                    <namedplace_id>
12 15 
                                        <namedplace>
......
36 39 
                                    <longitude>-71.40</longitude>
37 40 
                                </locationdetermination>
38 41 
                                <locationnarrative>Parque Nacional del Manu. R&#237;o Manu: Cocha Casha Station</locationnarrative>
39 
                                <elevation>350.0</elevation>
40 
                                <elevationrange>0.0</elevationrange>
41 42 
                            </location>
42 43 
                        </location_id>
43 44 
                        <obsstartdate>1984-08-20</obsstartdate>
......
158 159 
                    <locationevent>
159 160 
                        <location_id>
160 161 
                            <location>
162 
                                <elevation>15.0</elevation>
163 
                                <elevationrange>0.0</elevationrange>
164 
                                <reference_id><reference><shortname>NYBG</shortname></reference></reference_id>
161 165 
                                <locationdetermination>
162 166 
                                    <namedplace_id>
163 167 
                                        <namedplace>
......
179 183 
                                    <longitude>-88.50</longitude>
180 184 
                                </locationdetermination>
181 185 
                                <locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative>
182 
                                <elevation>15.0</elevation>
183 
                                <elevationrange>0.0</elevationrange>
184 186 
                            </location>
185 187 
                        </location_id>
186 188 
                        <obsstartdate>1994-01-17</obsstartdate>
inputs/NYBG-CSV/maps/DwC.specimens.csv
1 
"NYBG","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list/","Comments"
1 
"NYBG","DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[bien.datasource=$/_ignore/inLabel]/","Comments"
2 2 
"key",,
3 3 
"DateLastModified","dcterms:modified",
4 4 
"InstitutionCode","institutionCode",
inputs/NYBG-CSV/maps/VegBIEN.specimens.csv
1 1 
NYBG,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
5 2 
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy,,89
6 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
7 
Latitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/latitude/_alt/2,,81
8 
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude/_alt/2,,82
9 
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
10 3 
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
11 4 
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
5 
Country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
6 
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
7 
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
8 
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
9 
Latitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/latitude/_alt/2,,81
10 
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/longitude/_alt/2,,82
11 
Locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
12 12 
Vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,,
13 13 
Substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
14 14 
DayCollected,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate/_alt/2/_date/day,,44
mappings/for_review/DwC-VegBIEN.specimens.csv
1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list/",VegBIEN:/specimenreplicate,Comments,Order
1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[bien.datasource=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order
2 
coordinatePrecision,//location/locationdetermination[]/coordsaccuracy,,89
3 
coordinatePrecision/_noCV/value,//location/locationdetermination[]/coordsaccuracy/_noCV/value,,89
4 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
5 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
6 
bien.datasource,//reference/shortname/_alt/1,,
2 7 
country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename",Brad: Required; reject record if this field NULL,63
3 8 
stateProvince,"//*_id/namedplace[placesystem=""region|state|province""]/placename",,65
4 9 
county,//*_id/namedplace[placesystem=county]/placename,,66
5 
coordinatePrecision,//location/locationdetermination[]/coordsaccuracy,,89
6 
coordinatePrecision/_noCV/value,//location/locationdetermination[]/coordsaccuracy/_noCV/value,,89
7 10 
footprintWKT,//location/locationdetermination[]/footprintgeometry_dwc,,91
8 11 
decimalLatitude,//location/locationdetermination[]/latitude/_alt/1,,85
9 12 
verbatimLatitude,//location/locationdetermination[]/latitude/_alt/2,,81
......
11 14 
verbatimLongitude,//location/locationdetermination[]/longitude/_alt/2,,82
12 15 
locality,//location/locationnarrative/_alt/1,,68
13 16 
verbatimLocality,//location/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
14 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
15 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
16 17 
bien.vegetation,//*/commname,,
17 18 
bien.substrate,//locationevent/landscapenarrative,,
18 19 
eventDate,//locationevent/obsstartdate,,44
mappings/DwC-VegBIEN.specimens.csv
1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list/",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
1 
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list:[bien.datasource=$/_ignore/inLabel]/",VegBIEN:/specimenreplicate,Comments,Order
5 2 
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy,,89
6 3 
coordinatePrecision/_noCV/value,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89
7 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
8 
decimalLatitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/latitude/_alt/1,,85
9 
verbatimLatitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/latitude/_alt/2,,81
10 
decimalLongitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude/_alt/1,,86
11 
verbatimLongitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude/_alt/2,,82
12 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/1,,68
13 
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
14 4 
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
15 5 
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
6 
bien.datasource,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/*_id/reference/shortname/_alt/1,,
7 
country,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename",Brad: Required; reject record if this field NULL,63
8 
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65
9 
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66
10 
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/footprintgeometry_dwc,,91
11 
decimalLatitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/latitude/_alt/1,,85
12 
verbatimLatitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/latitude/_alt/2,,81
13 
decimalLongitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/longitude/_alt/1,,86
14 
verbatimLongitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationdetermination[!namedplace_id]/longitude/_alt/2,,82
15 
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationnarrative/_alt/1,,68
16 
verbatimLocality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location:[*_id/reference/shortname/_alt/2=$/_ignore/inLabel]/locationnarrative/_alt/2,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one.",69
16 17 
bien.vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,,
17 18 
bien.substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,,
18 19 
eventDate,/*_id/taxonoccurrence/*_id/locationevent/obsstartdate,,44

Also available in: Unified diff