Revision 1025
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/NYBG/test/import.specimens.out.ref | ||
|---|---|---|
| 1 |
Inserted 81 new rows into database |
|
| 1 |
Inserted 83 new rows into database |
|
| inputs/NYBG/test/VegBIEN.specimens.xml.ref | ||
|---|---|---|
| 7 | 7 |
<locationevent> |
| 8 | 8 |
<location_id> |
| 9 | 9 |
<location> |
| 10 |
<centerlatitude>-11.80000000</centerlatitude> |
|
| 11 |
<centerlongitude>-71.40000000</centerlongitude> |
|
| 12 | 10 |
<locationdetermination> |
| 13 | 11 |
<namedplace_id> |
| 14 | 12 |
<namedplace> |
| ... | ... | |
| 33 | 31 |
</namedplace> |
| 34 | 32 |
</namedplace_id> |
| 35 | 33 |
</locationdetermination> |
| 34 |
<locationdetermination> |
|
| 35 |
<latitude>-11.80000000</latitude> |
|
| 36 |
<longitude>-71.40000000</longitude> |
|
| 37 |
</locationdetermination> |
|
| 36 | 38 |
<locationnarrative>Parque Nacional del Manu. Río Manu: Cocha Casha Station</locationnarrative> |
| 37 | 39 |
<elevation>350.0</elevation> |
| 38 | 40 |
<elevationrange>0.0</elevationrange> |
| ... | ... | |
| 156 | 158 |
<locationevent> |
| 157 | 159 |
<location_id> |
| 158 | 160 |
<location> |
| 159 |
<centerlatitude>17.40000000</centerlatitude> |
|
| 160 |
<centerlongitude>-88.50000000</centerlongitude> |
|
| 161 | 161 |
<locationdetermination> |
| 162 | 162 |
<namedplace_id> |
| 163 | 163 |
<namedplace> |
| ... | ... | |
| 174 | 174 |
</namedplace> |
| 175 | 175 |
</namedplace_id> |
| 176 | 176 |
</locationdetermination> |
| 177 |
<locationdetermination> |
|
| 178 |
<latitude>17.40000000</latitude> |
|
| 179 |
<longitude>-88.50000000</longitude> |
|
| 180 |
</locationdetermination> |
|
| 177 | 181 |
<locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative> |
| 178 | 182 |
<elevation>15.0</elevation> |
| 179 | 183 |
<elevationrange>0.0</elevationrange> |
| inputs/NYBG/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
NYBG:nybg_raw,VegBIEN:/specimenreplicate,Comments,Order |
| 2 |
Latitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/centerlatitude/_alt/2,,81 |
|
| 3 |
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/centerlongitude/_alt/2,,82 |
|
| 4 |
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/dsgpoly,,91 |
|
| 5 |
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationaccuracy/_noCV/value,,89 |
|
| 6 | 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 |
| 7 | 3 |
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65 |
| 8 | 4 |
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66 |
| 5 |
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 | 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 | 10 |
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| 11 | 11 |
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
|
| inputs/SALVIAS/test/VegBIEN.plots.xml.ref | ||
|---|---|---|
| 5 | 5 |
<location> |
| 6 | 6 |
<area>0.06</area> |
| 7 | 7 |
<authorlocationcode>ACHUPALL</authorlocationcode> |
| 8 |
<centerlatitude>-3.45</centerlatitude> |
|
| 9 |
<centerlongitude>-78.3667</centerlongitude> |
|
| 10 | 8 |
<elevation>2100.0</elevation> |
| 11 | 9 |
<locationdetermination> |
| 12 | 10 |
<namedplace_id> |
| ... | ... | |
| 24 | 22 |
</namedplace> |
| 25 | 23 |
</namedplace_id> |
| 26 | 24 |
</locationdetermination> |
| 25 |
<locationdetermination> |
|
| 26 |
<latitude>-3.45</latitude> |
|
| 27 |
<longitude>-78.3667</longitude> |
|
| 28 |
</locationdetermination> |
|
| 27 | 29 |
<reference_id><reference><shortname>SALVIAS</shortname></reference></reference_id> |
| 28 | 30 |
</location> |
| 29 | 31 |
</location_id> |
| ... | ... | |
| 55 | 57 |
<location> |
| 56 | 58 |
<area>0.1</area> |
| 57 | 59 |
<authorlocationcode>ALLACHER</authorlocationcode> |
| 58 |
<centerlatitude>48.0667</centerlatitude> |
|
| 59 |
<centerlongitude>11.5</centerlongitude> |
|
| 60 | 60 |
<elevation>530.0</elevation> |
| 61 | 61 |
<locationdetermination> |
| 62 | 62 |
<namedplace_id> |
| ... | ... | |
| 74 | 74 |
</namedplace> |
| 75 | 75 |
</namedplace_id> |
| 76 | 76 |
</locationdetermination> |
| 77 |
<locationdetermination> |
|
| 78 |
<latitude>48.0667</latitude> |
|
| 79 |
<longitude>11.5</longitude> |
|
| 80 |
</locationdetermination> |
|
| 77 | 81 |
<reference_id><reference><shortname>SALVIAS</shortname></reference></reference_id> |
| 78 | 82 |
</location> |
| 79 | 83 |
</location_id> |
| inputs/SALVIAS/test/import.plots.out.ref | ||
|---|---|---|
| 1 |
Inserted 30 new rows into database |
|
| 1 |
Inserted 32 new rows into database |
|
| 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 |
SiteCode,/*_id/location/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| 4 |
LatDec,/*_id/location/centerlatitude, |
|
| 5 |
LongDec,/*_id/location/centerlongitude, |
|
| 6 | 4 |
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. |
| 7 | 5 |
Country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
| 8 | 6 |
PolDiv1,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince |
| 9 | 7 |
MajorGeo,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename, |
| 10 | 8 |
pol2,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,Brad: No pol2=countyParish |
| 11 |
Locality_Description,/*_id/location/locationdetermination/*_id/namedplace/placedescription,"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 |
LatDec,/*_id/location/locationdetermination[!namedplace_id]/latitude, |
|
| 10 |
LongDec,/*_id/location/locationdetermination[!namedplace_id]/longitude, |
|
| 11 |
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" |
|
| 12 | 12 |
slope_aspect,/*_id/location/slopeaspect, |
| 13 | 13 |
slope_gradient,/*_id/location/slopegradient, |
| 14 | 14 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| inputs/NYBG-CSV/test/import.specimens.out.ref | ||
|---|---|---|
| 1 |
Inserted 81 new rows into database |
|
| 1 |
Inserted 83 new rows into database |
|
| inputs/NYBG-CSV/test/VegBIEN.specimens.xml.ref | ||
|---|---|---|
| 7 | 7 |
<locationevent> |
| 8 | 8 |
<location_id> |
| 9 | 9 |
<location> |
| 10 |
<centerlatitude>-11.80</centerlatitude> |
|
| 11 |
<centerlongitude>-71.40</centerlongitude> |
|
| 12 | 10 |
<locationdetermination> |
| 13 | 11 |
<namedplace_id> |
| 14 | 12 |
<namedplace> |
| ... | ... | |
| 33 | 31 |
</namedplace> |
| 34 | 32 |
</namedplace_id> |
| 35 | 33 |
</locationdetermination> |
| 34 |
<locationdetermination> |
|
| 35 |
<latitude>-11.80</latitude> |
|
| 36 |
<longitude>-71.40</longitude> |
|
| 37 |
</locationdetermination> |
|
| 36 | 38 |
<locationnarrative>Parque Nacional del Manu. Río Manu: Cocha Casha Station</locationnarrative> |
| 37 | 39 |
<elevation>350.0</elevation> |
| 38 | 40 |
<elevationrange>0.0</elevationrange> |
| ... | ... | |
| 156 | 158 |
<locationevent> |
| 157 | 159 |
<location_id> |
| 158 | 160 |
<location> |
| 159 |
<centerlatitude>17.40</centerlatitude> |
|
| 160 |
<centerlongitude>-88.50</centerlongitude> |
|
| 161 | 161 |
<locationdetermination> |
| 162 | 162 |
<namedplace_id> |
| 163 | 163 |
<namedplace> |
| ... | ... | |
| 174 | 174 |
</namedplace> |
| 175 | 175 |
</namedplace_id> |
| 176 | 176 |
</locationdetermination> |
| 177 |
<locationdetermination> |
|
| 178 |
<latitude>17.40</latitude> |
|
| 179 |
<longitude>-88.50</longitude> |
|
| 180 |
</locationdetermination> |
|
| 177 | 181 |
<locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative> |
| 178 | 182 |
<elevation>15.0</elevation> |
| 179 | 183 |
<elevationrange>0.0</elevationrange> |
| inputs/NYBG-CSV/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
NYBG,VegBIEN:/specimenreplicate,Comments,Order |
| 2 |
Latitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/centerlatitude/_alt/2,,81 |
|
| 3 |
Longitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/centerlongitude/_alt/2,,82 |
|
| 4 |
BoundingBox,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/dsgpoly,,91 |
|
| 5 |
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationaccuracy,,89 |
|
| 6 | 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 |
| 7 | 3 |
StateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65 |
| 8 | 4 |
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66 |
| 5 |
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 | 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 | 10 |
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| 11 | 11 |
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
|
| inputs/SALVIAS-CSV/test/VegBIEN.plots.xml.ref | ||
|---|---|---|
| 5 | 5 |
<location> |
| 6 | 6 |
<area>0.44</area> |
| 7 | 7 |
<authorlocationcode>ALP-11</authorlocationcode> |
| 8 |
<centerlatitude>-3.95</centerlatitude> |
|
| 9 |
<centerlongitude>-73.4333</centerlongitude> |
|
| 10 | 8 |
<elevation>200</elevation> |
| 11 | 9 |
<locationdetermination> |
| 12 | 10 |
<namedplace_id> |
| ... | ... | |
| 29 | 27 |
<namedplace> |
| 30 | 28 |
<placesystem>continent</placesystem> |
| 31 | 29 |
<placename>South America</placename> |
| 32 |
<placedescription>pre-Holocene; clay</placedescription> |
|
| 33 | 30 |
</namedplace> |
| 34 | 31 |
</namedplace_id> |
| 35 | 32 |
</locationdetermination> |
| 33 |
<locationdetermination> |
|
| 34 |
<latitude>-3.95</latitude> |
|
| 35 |
<longitude>-73.4333</longitude> |
|
| 36 |
</locationdetermination> |
|
| 37 |
<locationnarrative>pre-Holocene; clay</locationnarrative> |
|
| 36 | 38 |
<reference_id><reference><shortname>SALVIAS</shortname></reference></reference_id> |
| 37 | 39 |
</location> |
| 38 | 40 |
</location_id> |
| ... | ... | |
| 46 | 48 |
<location> |
| 47 | 49 |
<area>0.4</area> |
| 48 | 50 |
<authorlocationcode>ALP-12</authorlocationcode> |
| 49 |
<centerlatitude>-3.95</centerlatitude> |
|
| 50 |
<centerlongitude>-73.4333</centerlongitude> |
|
| 51 | 51 |
<elevation>200</elevation> |
| 52 | 52 |
<locationdetermination> |
| 53 | 53 |
<namedplace_id> |
| ... | ... | |
| 70 | 70 |
<namedplace> |
| 71 | 71 |
<placesystem>continent</placesystem> |
| 72 | 72 |
<placename>South America</placename> |
| 73 |
<placedescription>pre-Holocene; white and brown sand</placedescription> |
|
| 74 | 73 |
</namedplace> |
| 75 | 74 |
</namedplace_id> |
| 76 | 75 |
</locationdetermination> |
| 76 |
<locationdetermination> |
|
| 77 |
<latitude>-3.95</latitude> |
|
| 78 |
<longitude>-73.4333</longitude> |
|
| 79 |
</locationdetermination> |
|
| 80 |
<locationnarrative>pre-Holocene; white and brown sand</locationnarrative> |
|
| 77 | 81 |
<reference_id><reference><shortname>SALVIAS</shortname></reference></reference_id> |
| 78 | 82 |
</location> |
| 79 | 83 |
</location_id> |
| inputs/SALVIAS-CSV/test/import.plots.out.ref | ||
|---|---|---|
| 1 |
Inserted 17 new rows into database |
|
| 1 |
Inserted 19 new rows into database |
|
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,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 |
plot_code,/*_id/location/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
| 4 |
lat_decimal,/*_id/location/centerlatitude, |
|
| 5 |
long_decimal,/*_id/location/centerlongitude, |
|
| 6 | 4 |
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. |
| 7 | 5 |
country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
| 8 | 6 |
pol1,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince |
| 9 | 7 |
major_geo,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename, |
| 10 | 8 |
pol2,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,Brad: No pol2=countyParish |
| 11 |
locality_description,/*_id/location/locationdetermination/*_id/namedplace/placedescription,"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 |
lat_decimal,/*_id/location/locationdetermination[!namedplace_id]/latitude, |
|
| 10 |
long_decimal,/*_id/location/locationdetermination[!namedplace_id]/longitude, |
|
| 11 |
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" |
|
| 12 | 12 |
slope_aspect,/*_id/location/slopeaspect, |
| 13 | 13 |
slope_gradient,/*_id/location/slopegradient, |
| 14 | 14 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| mappings/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 2 | 2 |
/partyWithRole/*ID->/parties/party/organizationName,"/""""/*_id/location/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings |
| 3 | 3 |
/*UniqueIdentifierID->/*s/plot/area,/*_id/location/area, |
| 4 | 4 |
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/location/authorlocationcode, |
| 5 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/location/centerlatitude, |
|
| 6 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/location/centerlongitude, |
|
| 7 |
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/location/dsgpoly, |
|
| 8 | 5 |
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/location/elevation/_alt/1, |
| 9 |
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/location/locationaccuracy, |
|
| 10 | 6 |
/*UniqueIdentifierID->/*s/plot/country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
| 11 | 7 |
/*UniqueIdentifierID->/*s/plot/state,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename", |
| 12 | 8 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename, |
| 13 | 9 |
/*UniqueIdentifierID->/*s/plot/county,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename, |
| 14 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/location/locationdetermination/*_id/namedplace/placedescription, |
|
| 10 |
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy, |
|
| 11 |
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc, |
|
| 12 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/location/locationdetermination[!namedplace_id]/latitude, |
|
| 13 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/location/locationdetermination[!namedplace_id]/longitude, |
|
| 14 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/location/locationnarrative, |
|
| 15 | 15 |
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/location/parent_id/location/authorlocationcode, |
| 16 | 16 |
/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_id/location/slopeaspect, |
| 17 | 17 |
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/location/slopegradient, |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 2 | 2 |
/*ID->/*s/plotObservation/partyWithRole/*ID->/parties/party/organizationName,"/*_id/locationevent/""""/*_id/location/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings |
| 3 | 3 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area,/*_id/locationevent/*_id/location/area, |
| 4 | 4 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/*_id/location/authorlocationcode, |
| 5 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/locationevent/*_id/location/centerlatitude, |
|
| 6 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/locationevent/*_id/location/centerlongitude, |
|
| 7 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/locationevent/*_id/location/dsgpoly, |
|
| 8 | 5 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/locationevent/*_id/location/elevation/_alt/1, |
| 9 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationaccuracy, |
|
| 10 | 6 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country,"/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
| 11 | 7 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state,"/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename", |
| 12 | 8 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=majorGeo]/value,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename, |
| 13 | 9 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename, |
| 14 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/locationevent/*_id/location/locationdetermination/*_id/namedplace/placedescription, |
|
| 10 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy, |
|
| 11 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc, |
|
| 12 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/latitude, |
|
| 13 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude, |
|
| 14 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/locationevent/*_id/location/locationnarrative, |
|
| 15 | 15 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/*_id/location/parent_id/location/authorlocationcode, |
| 16 | 16 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_id/locationevent/*_id/location/slopeaspect, |
| 17 | 17 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/locationevent/*_id/location/slopegradient, |
| mappings/for_review/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 2 | 2 |
//party/organizationName,"/""""/*_id/location/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings |
| 3 | 3 |
//plot/area,//location/area, |
| 4 | 4 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
| 5 |
//geospatial/DecimalLatitude,//location/centerlatitude, |
|
| 6 |
//geospatial/DecimalLongitude,//location/centerlongitude, |
|
| 7 |
//geospatial/FootprintWKT,//location/dsgpoly, |
|
| 8 | 5 |
//geospatial/verbatimElevation,//location/elevation/_alt/1, |
| 9 |
//geospatial/CoordinateUncertaintyInMeters,//location/locationaccuracy, |
|
| 10 | 6 |
//plot/country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename", |
| 11 | 7 |
//plot/state,"//*_id/namedplace[placesystem=""region|state|province""]/placename", |
| 12 | 8 |
//plot/simpleUserdefined[name=majorGeo]/value,//*_id/namedplace[placesystem=continent]/placename, |
| 13 | 9 |
//plot/county,//*_id/namedplace[placesystem=county]/placename, |
| 14 |
//plot/simpleUserdefined[name=localityDescription]/value,//namedplace/placedescription, |
|
| 10 |
//geospatial/CoordinateUncertaintyInMeters,//location/locationdetermination[]/coordsaccuracy, |
|
| 11 |
//geospatial/FootprintWKT,//location/locationdetermination[]/footprintgeometry_dwc, |
|
| 12 |
//geospatial/DecimalLatitude,//location/locationdetermination[]/latitude, |
|
| 13 |
//geospatial/DecimalLongitude,//location/locationdetermination[]/longitude, |
|
| 14 |
//plot/simpleUserdefined[name=localityDescription]/value,//location/locationnarrative, |
|
| 15 | 15 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
| 16 | 16 |
//plot/slopeAspect,//location/slopeaspect, |
| 17 | 17 |
//plot/slopeGradient,//location/slopegradient, |
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 2 | 2 |
//party/organizationName,"/*_id/locationevent/""""/*_id/location/*_id/reference/shortname/_alt/1",Quotes sort this before other mappings |
| 3 | 3 |
//plot/area,//location/area, |
| 4 | 4 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
| 5 |
//geospatial/DecimalLatitude,//location/centerlatitude, |
|
| 6 |
//geospatial/DecimalLongitude,//location/centerlongitude, |
|
| 7 |
//geospatial/FootprintWKT,//location/dsgpoly, |
|
| 8 | 5 |
//geospatial/verbatimElevation,//location/elevation/_alt/1, |
| 9 |
//geospatial/CoordinateUncertaintyInMeters,//location/locationaccuracy, |
|
| 10 | 6 |
//plot/country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename", |
| 11 | 7 |
//plot/state,"//*_id/namedplace[placesystem=""region|state|province""]/placename", |
| 12 | 8 |
//plot/simpleUserdefined[name=majorGeo]/value,//*_id/namedplace[placesystem=continent]/placename, |
| 13 | 9 |
//plot/county,//*_id/namedplace[placesystem=county]/placename, |
| 14 |
//plot/simpleUserdefined[name=localityDescription]/value,//namedplace/placedescription, |
|
| 10 |
//geospatial/CoordinateUncertaintyInMeters,//location/locationdetermination[]/coordsaccuracy, |
|
| 11 |
//geospatial/FootprintWKT,//location/locationdetermination[]/footprintgeometry_dwc, |
|
| 12 |
//geospatial/DecimalLatitude,//location/locationdetermination[]/latitude, |
|
| 13 |
//geospatial/DecimalLongitude,//location/locationdetermination[]/longitude, |
|
| 14 |
//plot/simpleUserdefined[name=localityDescription]/value,//location/locationnarrative, |
|
| 15 | 15 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
| 16 | 16 |
//plot/slopeAspect,//location/slopeaspect, |
| 17 | 17 |
//plot/slopeGradient,//location/slopegradient, |
| mappings/for_review/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list/",VegBIEN:/specimenreplicate,Comments,Order |
| 2 |
decimalLatitude,//location/centerlatitude/_alt/1,,85 |
|
| 3 |
verbatimLatitude,//location/centerlatitude/_alt/2,,81 |
|
| 4 |
decimalLongitude,//location/centerlongitude/_alt/1,,86 |
|
| 5 |
verbatimLongitude,//location/centerlongitude/_alt/2,,82 |
|
| 6 |
footprintWKT,//location/dsgpoly,,91 |
|
| 7 |
coordinatePrecision,//location/locationaccuracy,,89 |
|
| 8 |
coordinatePrecision/_noCV/value,//location/locationaccuracy/_noCV/value,,89 |
|
| 9 | 2 |
country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename",Brad: Required; reject record if this field NULL,63 |
| 10 | 3 |
stateProvince,"//*_id/namedplace[placesystem=""region|state|province""]/placename",,65 |
| 11 | 4 |
county,//*_id/namedplace[placesystem=county]/placename,,66 |
| 5 |
coordinatePrecision,//location/locationdetermination[]/coordsaccuracy,,89 |
|
| 6 |
coordinatePrecision/_noCV/value,//location/locationdetermination[]/coordsaccuracy/_noCV/value,,89 |
|
| 7 |
footprintWKT,//location/locationdetermination[]/footprintgeometry_dwc,,91 |
|
| 8 |
decimalLatitude,//location/locationdetermination[]/latitude/_alt/1,,85 |
|
| 9 |
verbatimLatitude,//location/locationdetermination[]/latitude/_alt/2,,81 |
|
| 10 |
decimalLongitude,//location/locationdetermination[]/longitude/_alt/1,,86 |
|
| 11 |
verbatimLongitude,//location/locationdetermination[]/longitude/_alt/2,,82 |
|
| 12 | 12 |
locality,//location/locationnarrative/_alt/1,,68 |
| 13 | 13 |
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 | 14 |
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 1 | 1 |
"DwC::[@xmlns:dcterms=""http://purl.org/dc/terms/""]/list/",VegBIEN:/specimenreplicate,Comments,Order |
| 2 |
decimalLatitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/centerlatitude/_alt/1,,85 |
|
| 3 |
verbatimLatitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/centerlatitude/_alt/2,,81 |
|
| 4 |
decimalLongitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/centerlongitude/_alt/1,,86 |
|
| 5 |
verbatimLongitude,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/centerlongitude/_alt/2,,82 |
|
| 6 |
footprintWKT,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/dsgpoly,,91 |
|
| 7 |
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationaccuracy,,89 |
|
| 8 |
coordinatePrecision/_noCV/value,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationaccuracy/_noCV/value,,89 |
|
| 9 | 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 |
| 10 | 3 |
stateProvince,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",,65 |
| 11 | 4 |
county,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66 |
| 5 |
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy,,89 |
|
| 6 |
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 | 12 |
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/1,,68 |
| 13 | 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 | 14 |
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
Also available in: Unified diff
VegBIEN mappings: Remap to new locationdetermination fields