Revision 1071
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/NYBG/test/VegBIEN.specimens.xml.ref | ||
|---|---|---|
| 31 | 31 |
</namedplace> |
| 32 | 32 |
</namedplace_id> |
| 33 | 33 |
</locationdetermination> |
| 34 |
<locationnarrative>Parque Nacional del Manu. Río Manu: Cocha Casha Station</locationnarrative> |
|
| 35 |
<elevation>350.0</elevation> |
|
| 36 |
<elevationrange>0.0</elevationrange> |
|
| 34 | 37 |
<locationdetermination> |
| 35 | 38 |
<latitude>-11.80000000</latitude> |
| 36 | 39 |
<longitude>-71.40000000</longitude> |
| 37 | 40 |
</locationdetermination> |
| 38 |
<locationnarrative>Parque Nacional del Manu. Río Manu: Cocha Casha Station</locationnarrative> |
|
| 39 |
<elevation>350.0</elevation> |
|
| 40 |
<elevationrange>0.0</elevationrange> |
|
| 41 |
<centerlatitude>-11.80000000</centerlatitude> |
|
| 42 |
<centerlongitude>-71.40000000</centerlongitude> |
|
| 41 | 43 |
</location> |
| 42 | 44 |
</location_id> |
| 43 | 45 |
<commclass><commdetermination><commconcept_id><commconcept><commname_id><commname><commname>Floodplain forest</commname></commname></commname_id></commconcept></commconcept_id></commdetermination></commclass> |
| ... | ... | |
| 157 | 159 |
</namedplace> |
| 158 | 160 |
</namedplace_id> |
| 159 | 161 |
</locationdetermination> |
| 162 |
<locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative> |
|
| 163 |
<elevation>15.0</elevation> |
|
| 164 |
<elevationrange>0.0</elevationrange> |
|
| 160 | 165 |
<locationdetermination> |
| 161 | 166 |
<latitude>17.40000000</latitude> |
| 162 | 167 |
<longitude>-88.50000000</longitude> |
| 163 | 168 |
</locationdetermination> |
| 164 |
<locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative> |
|
| 165 |
<elevation>15.0</elevation> |
|
| 166 |
<elevationrange>0.0</elevationrange> |
|
| 169 |
<centerlatitude>17.40000000</centerlatitude> |
|
| 170 |
<centerlongitude>-88.50000000</centerlongitude> |
|
| 167 | 171 |
</location> |
| 168 | 172 |
</location_id> |
| 169 | 173 |
<obsstartdate>1994-01-17</obsstartdate> |
| inputs/NYBG/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 4 | 4 |
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66 |
| 5 | 5 |
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89 |
| 6 | 6 |
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/_nullIf:[null=0,type=float]/value",,81 |
|
| 8 |
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude/_alt/2/_nullIf:[null=0,type=float]/value",,82 |
|
| 9 | 7 |
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 | 8 |
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| 11 | 9 |
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
|
| 10 |
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
|
|
| 11 |
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
|
|
| 12 | 12 |
Habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/1,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 13 | 13 |
Vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/2,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 14 | 14 |
Substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,, |
| inputs/SALVIAS/test/VegBIEN.plots.xml.ref | ||
|---|---|---|
| 26 | 26 |
<latitude>-3.45</latitude> |
| 27 | 27 |
<longitude>-78.3667</longitude> |
| 28 | 28 |
</locationdetermination> |
| 29 |
<centerlatitude>-3.45</centerlatitude> |
|
| 30 |
<centerlongitude>-78.3667</centerlongitude> |
|
| 29 | 31 |
</location> |
| 30 | 32 |
</location_id> |
| 31 | 33 |
<plotmethod_id><plotmethod><name>0.1 ha transect, stems >= 2.5 cm dbh</name></plotmethod></plotmethod_id> |
| ... | ... | |
| 78 | 80 |
<latitude>48.0667</latitude> |
| 79 | 81 |
<longitude>11.5</longitude> |
| 80 | 82 |
</locationdetermination> |
| 83 |
<centerlatitude>48.0667</centerlatitude> |
|
| 84 |
<centerlongitude>11.5</centerlongitude> |
|
| 81 | 85 |
</location> |
| 82 | 86 |
</location_id> |
| 83 | 87 |
<plotmethod_id><plotmethod><name>0.1 ha transect, stems >= 2.5 cm dbh</name></plotmethod></plotmethod_id> |
| inputs/SALVIAS/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 6 | 6 |
PolDiv1,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince |
| 7 | 7 |
MajorGeo,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename, |
| 8 | 8 |
pol2,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,Brad: No pol2=countyParish |
| 9 |
LatDec,/*_id/location/locationdetermination[!namedplace_id]/latitude, |
|
| 10 |
LongDec,/*_id/location/locationdetermination[!namedplace_id]/longitude, |
|
| 11 | 9 |
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 | 10 |
slope_aspect,/*_id/location/slopeaspect, |
| 13 | 11 |
slope_gradient,/*_id/location/slopegradient, |
| 14 | 12 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 15 | 13 |
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 14 |
LatDec,"/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}",
|
|
| 15 |
LongDec,"/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}",
|
|
| 16 | 16 |
PlotMethod,/*_id/plotmethod/name, |
| 17 | 17 |
project_id,/*_id/project/projectname, |
| 18 | 18 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| inputs/NYBG-CSV/test/VegBIEN.specimens.xml.ref | ||
|---|---|---|
| 31 | 31 |
</namedplace> |
| 32 | 32 |
</namedplace_id> |
| 33 | 33 |
</locationdetermination> |
| 34 |
<locationnarrative>Parque Nacional del Manu. Río Manu: Cocha Casha Station</locationnarrative> |
|
| 35 |
<elevation>350.0</elevation> |
|
| 36 |
<elevationrange>0.0</elevationrange> |
|
| 34 | 37 |
<locationdetermination> |
| 35 | 38 |
<latitude>-11.80</latitude> |
| 36 | 39 |
<longitude>-71.40</longitude> |
| 37 | 40 |
</locationdetermination> |
| 38 |
<locationnarrative>Parque Nacional del Manu. Río Manu: Cocha Casha Station</locationnarrative> |
|
| 39 |
<elevation>350.0</elevation> |
|
| 40 |
<elevationrange>0.0</elevationrange> |
|
| 41 |
<centerlatitude>-11.80</centerlatitude> |
|
| 42 |
<centerlongitude>-71.40</centerlongitude> |
|
| 41 | 43 |
</location> |
| 42 | 44 |
</location_id> |
| 43 | 45 |
<commclass><commdetermination><commconcept_id><commconcept><commname_id><commname><commname>Floodplain forest</commname></commname></commname_id></commconcept></commconcept_id></commdetermination></commclass> |
| ... | ... | |
| 157 | 159 |
</namedplace> |
| 158 | 160 |
</namedplace_id> |
| 159 | 161 |
</locationdetermination> |
| 162 |
<locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative> |
|
| 163 |
<elevation>15.0</elevation> |
|
| 164 |
<elevationrange>0.0</elevationrange> |
|
| 160 | 165 |
<locationdetermination> |
| 161 | 166 |
<latitude>17.40</latitude> |
| 162 | 167 |
<longitude>-88.50</longitude> |
| 163 | 168 |
</locationdetermination> |
| 164 |
<locationnarrative>Belize Zoo, in savanna plot immediately behind zoo. Mile 31 on Western Highway</locationnarrative> |
|
| 165 |
<elevation>15.0</elevation> |
|
| 166 |
<elevationrange>0.0</elevationrange> |
|
| 169 |
<centerlatitude>17.40</centerlatitude> |
|
| 170 |
<centerlongitude>-88.50</centerlongitude> |
|
| 167 | 171 |
</location> |
| 168 | 172 |
</location_id> |
| 169 | 173 |
<obsstartdate>1994-01-17</obsstartdate> |
| inputs/NYBG-CSV/maps/VegBIEN.specimens.csv | ||
|---|---|---|
| 4 | 4 |
County,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,,66 |
| 5 | 5 |
CoordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy,,89 |
| 6 | 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/_nullIf:[null=0,type=float]/value",,81 |
|
| 8 |
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude/_alt/2/_nullIf:[null=0,type=float]/value",,82 |
|
| 9 | 7 |
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 | 8 |
MaximumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| 11 | 9 |
MinimumElevation,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
|
| 10 |
Latitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
|
|
| 11 |
Longitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
|
|
| 12 | 12 |
Habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/1,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 13 | 13 |
Vegetation,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/2,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 14 | 14 |
Substrate,/*_id/taxonoccurrence/*_id/locationevent/landscapenarrative,, |
| inputs/SALVIAS-CSV/test/VegBIEN.plots.xml.ref | ||
|---|---|---|
| 30 | 30 |
</namedplace> |
| 31 | 31 |
</namedplace_id> |
| 32 | 32 |
</locationdetermination> |
| 33 |
<locationnarrative>pre-Holocene; clay</locationnarrative> |
|
| 33 | 34 |
<locationdetermination> |
| 34 | 35 |
<latitude>-3.95</latitude> |
| 35 | 36 |
<longitude>-73.4333</longitude> |
| 36 | 37 |
</locationdetermination> |
| 37 |
<locationnarrative>pre-Holocene; clay</locationnarrative> |
|
| 38 |
<centerlatitude>-3.95</centerlatitude> |
|
| 39 |
<centerlongitude>-73.4333</centerlongitude> |
|
| 38 | 40 |
</location> |
| 39 | 41 |
</location_id> |
| 40 | 42 |
<plotmethod_id><plotmethod><name>1 ha, stems >= 10 cm dbh</name></plotmethod></plotmethod_id> |
| ... | ... | |
| 73 | 75 |
</namedplace> |
| 74 | 76 |
</namedplace_id> |
| 75 | 77 |
</locationdetermination> |
| 78 |
<locationnarrative>pre-Holocene; white and brown sand</locationnarrative> |
|
| 76 | 79 |
<locationdetermination> |
| 77 | 80 |
<latitude>-3.95</latitude> |
| 78 | 81 |
<longitude>-73.4333</longitude> |
| 79 | 82 |
</locationdetermination> |
| 80 |
<locationnarrative>pre-Holocene; white and brown sand</locationnarrative> |
|
| 83 |
<centerlatitude>-3.95</centerlatitude> |
|
| 84 |
<centerlongitude>-73.4333</centerlongitude> |
|
| 81 | 85 |
</location> |
| 82 | 86 |
</location_id> |
| 83 | 87 |
<plotmethod_id><plotmethod><name>1 ha, stems >= 10 cm dbh</name></plotmethod></plotmethod_id> |
| inputs/SALVIAS-CSV/test/import.plots.out.ref | ||
|---|---|---|
| 1 |
Inserted 19 new rows into database |
|
| 1 |
Inserted 15 new rows into database |
|
| inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv | ||
|---|---|---|
| 6 | 6 |
pol1,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince |
| 7 | 7 |
major_geo,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=continent])/placename, |
| 8 | 8 |
pol2,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename,Brad: No pol2=countyParish |
| 9 |
lat_decimal,/*_id/location/locationdetermination[!namedplace_id]/latitude, |
|
| 10 |
long_decimal,/*_id/location/locationdetermination[!namedplace_id]/longitude, |
|
| 11 | 9 |
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 | 10 |
slope_aspect,/*_id/location/slopeaspect, |
| 13 | 11 |
slope_gradient,/*_id/location/slopegradient, |
| 14 | 12 |
elev_max_m,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 15 | 13 |
elev_min_m,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 14 |
lat_decimal,"/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}",
|
|
| 15 |
long_decimal,"/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}",
|
|
| 16 | 16 |
plot_methodology,/*_id/plotmethod/name, |
| 17 | 17 |
project,/*_id/project/projectname, |
| 18 | 18 |
holdridge_life_zone,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| mappings/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 8 | 8 |
/*UniqueIdentifierID->/*s/plot/county,/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename, |
| 9 | 9 |
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy, |
| 10 | 10 |
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc, |
| 11 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/location/locationdetermination[!namedplace_id]/latitude, |
|
| 12 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/location/locationdetermination[!namedplace_id]/longitude, |
|
| 13 | 11 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/location/locationnarrative, |
| 14 | 12 |
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/location/parent_id/location/authorlocationcode, |
| 15 | 13 |
/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_id/location/slopeaspect, |
| 16 | 14 |
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/location/slopegradient, |
| 17 | 15 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 18 | 16 |
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 17 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}",
|
|
| 18 |
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}",
|
|
| 19 | 19 |
/simpleUserdefined[name=plotMethodology]/value,/*_id/plotmethod/name, |
| 20 | 20 |
/*ID->/*s/project/title,/*_id/project/projectname, |
| 21 | 21 |
->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 8 | 8 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/county,/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=county])/placename, |
| 9 | 9 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy, |
| 10 | 10 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc, |
| 11 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/latitude, |
|
| 12 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude, |
|
| 13 | 11 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/locationevent/*_id/location/locationnarrative, |
| 14 | 12 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/*_id/location/parent_id/location/authorlocationcode, |
| 15 | 13 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_id/locationevent/*_id/location/slopeaspect, |
| 16 | 14 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/locationevent/*_id/location/slopegradient, |
| 17 | 15 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 18 | 16 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 17 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}",
|
|
| 18 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}",
|
|
| 19 | 19 |
/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value,/*_id/locationevent/*_id/plotmethod/name, |
| 20 | 20 |
/*ID->/*s/plotObservation/*ID->/*s/project/title,/*_id/locationevent/*_id/project/projectname, |
| 21 | 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| mappings/for_review/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 8 | 8 |
//plot/county,//*_id/namedplace[placesystem=county]/placename, |
| 9 | 9 |
//geospatial/CoordinateUncertaintyInMeters,//location/locationdetermination[]/coordsaccuracy, |
| 10 | 10 |
//geospatial/FootprintWKT,//location/locationdetermination[]/footprintgeometry_dwc, |
| 11 |
//geospatial/DecimalLatitude,//location/locationdetermination[]/latitude, |
|
| 12 |
//geospatial/DecimalLongitude,//location/locationdetermination[]/longitude, |
|
| 13 | 11 |
//plot/simpleUserdefined[name=localityDescription]/value,//location/locationnarrative, |
| 14 | 12 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
| 15 | 13 |
//plot/slopeAspect,//location/slopeaspect, |
| 16 | 14 |
//plot/slopeGradient,//location/slopegradient, |
| 17 | 15 |
//geospatial/maximumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 18 | 16 |
//geospatial/minimumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 17 |
//geospatial/DecimalLatitude,"/*_id/location/{locationdetermination[]/latitude,centerlatitude}",
|
|
| 18 |
//geospatial/DecimalLongitude,"/*_id/location/{locationdetermination[]/longitude,centerlongitude}",
|
|
| 19 | 19 |
/simpleUserdefined[name=plotMethodology]/value,//plotmethod/name, |
| 20 | 20 |
//project/title,//project/projectname, |
| 21 | 21 |
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname, |
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 8 | 8 |
//plot/county,//*_id/namedplace[placesystem=county]/placename, |
| 9 | 9 |
//geospatial/CoordinateUncertaintyInMeters,//location/locationdetermination[]/coordsaccuracy, |
| 10 | 10 |
//geospatial/FootprintWKT,//location/locationdetermination[]/footprintgeometry_dwc, |
| 11 |
//geospatial/DecimalLatitude,//location/locationdetermination[]/latitude, |
|
| 12 |
//geospatial/DecimalLongitude,//location/locationdetermination[]/longitude, |
|
| 13 | 11 |
//plot/simpleUserdefined[name=localityDescription]/value,//location/locationnarrative, |
| 14 | 12 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
| 15 | 13 |
//plot/slopeAspect,//location/slopeaspect, |
| 16 | 14 |
//plot/slopeGradient,//location/slopegradient, |
| 17 | 15 |
//geospatial/maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| 18 | 16 |
//geospatial/minimumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
|
| 17 |
//geospatial/DecimalLatitude,"/*_id/locationevent/*_id/location/{locationdetermination[]/latitude,centerlatitude}",
|
|
| 18 |
//geospatial/DecimalLongitude,"/*_id/locationevent/*_id/location/{locationdetermination[]/longitude,centerlongitude}",
|
|
| 19 | 19 |
//plotObservation/simpleUserdefined[name=plotMethodology]/value,//plotmethod/name, |
| 20 | 20 |
//project/title,//project/projectname, |
| 21 | 21 |
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname, |
| mappings/for_review/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 5 | 5 |
coordinatePrecision,//location/locationdetermination[]/coordsaccuracy,,89 |
| 6 | 6 |
coordinatePrecision/_noCV/value,//location/locationdetermination[]/coordsaccuracy/_noCV/value,,89 |
| 7 | 7 |
footprintWKT,//location/locationdetermination[]/footprintgeometry_dwc,,91 |
| 8 |
decimalLatitude,//location/locationdetermination[]/latitude/_alt/1/_nullIf/value,,85 |
|
| 9 |
verbatimLatitude,//location/locationdetermination[]/latitude/_alt/2/_nullIf/value,,81 |
|
| 10 |
decimalLongitude,//location/locationdetermination[]/longitude/_alt/1/_nullIf/value,,86 |
|
| 11 |
verbatimLongitude,//location/locationdetermination[]/longitude/_alt/2/_nullIf/value,,82 |
|
| 12 | 8 |
locality,//location/locationnarrative/_alt/1,,68 |
| 13 | 9 |
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 | 10 |
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| 15 | 11 |
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
|
| 12 |
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[]/latitude,centerlatitude}/_alt/1/_nullIf/value",,85
|
|
| 13 |
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[]/latitude,centerlatitude}/_alt/2/_nullIf/value",,81
|
|
| 14 |
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[]/longitude,centerlongitude}/_alt/1/_nullIf/value",,86
|
|
| 15 |
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[]/longitude,centerlongitude}/_alt/2/_nullIf/value",,82
|
|
| 16 | 16 |
habitat,//*/commname,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 17 | 17 |
habitat/_merge/1,//*/commname/_merge/1,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 18 | 18 |
habitat/_merge/2,//*/commname/_merge/2,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| mappings/DwC-VegBIEN.specimens.csv | ||
|---|---|---|
| 5 | 5 |
coordinatePrecision,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy,,89 |
| 6 | 6 |
coordinatePrecision/_noCV/value,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy/_noCV/value,,89 |
| 7 | 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/_nullIf:[null=0,type=float]/value",,85 |
|
| 9 |
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/latitude/_alt/2/_nullIf:[null=0,type=float]/value",,81 |
|
| 10 |
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude/_alt/1/_nullIf:[null=0,type=float]/value",,86 |
|
| 11 |
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/longitude/_alt/2/_nullIf:[null=0,type=float]/value",,82 |
|
| 12 | 8 |
locality,/*_id/taxonoccurrence/*_id/locationevent/*_id/location/locationnarrative/_alt/1,,68 |
| 13 | 9 |
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 | 10 |
maximumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",,72
|
| 15 | 11 |
minimumElevationInMeters,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",,71
|
| 12 |
decimalLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/1/_nullIf:[null=0,type=float]/value",,85
|
|
| 13 |
verbatimLatitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/latitude,centerlatitude}/_alt/2/_nullIf:[null=0,type=float]/value",,81
|
|
| 14 |
decimalLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/1/_nullIf:[null=0,type=float]/value",,86
|
|
| 15 |
verbatimLongitude,"/*_id/taxonoccurrence/*_id/locationevent/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}/_alt/2/_nullIf:[null=0,type=float]/value",,82
|
|
| 16 | 16 |
habitat,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 17 | 17 |
habitat/_merge/1,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/1,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
| 18 | 18 |
habitat/_merge/2,/*_id/taxonoccurrence/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname/_merge/2,"Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?",52 |
Also available in: Unified diff
VegBIEN mappings: Mapped current lat/long to centerlat/long as well so location duplicate elimination will work properly