Project

General

Profile

« Previous | Next » 

Revision 459

VegX-VegBIEN mapping: Merge different sources of plot elevation

View differences:

inputs/SALVIAS/map.VegBIEN.plots.csv
1 1
SALVIAS:plotMetadata,VegBIEN:/plotevent,Comments
2 2
plot_area_ha,/*_id/plot/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
Elev,/*_id/plot/elevation,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.
3
Elev,/*_id/plot/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 4
Country,"/*_id/plot/place(/*_id/namedplace[placesystem=""area|country|territory""])/placename",
5 5
PolDiv1,"/*_id/plot/place(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince
6 6
MajorGeo,/*_id/plot/place(/*_id/namedplace[placesystem=continent])/placename,
......
10 10
LongDec,/*_id/plot/reallongitude,
11 11
slope_aspect,/*_id/plot/slopeaspect,
12 12
slope_gradient,/*_id/plot/slopegradient,
13
elev_max_m,"/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}",
13
elev_max_m,"/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
15 15
project_id,/*_id/project/projectname,
16 16
PlotID,/authorcode/_alt/1,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
17 17
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
mappings/VegX-VegBIEN.plots.csv
1 1
VegX:/*s/plotObservation,VegBIEN:/plotevent
2 2
/*UniqueIdentifierID->/*s/plot/area,/*_id/plot/area
3 3
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/plot/dsgpoly
4
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/plot/elevation
4
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/plot/elevation/_alt/1
5 5
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/plot/locationaccuracy
6 6
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/plot/parent_id/plot:[confidentialitystatus=0]/authorcode/_alt/1
7 7
/*UniqueIdentifierID->/*s/plot/country,"/*_id/plot/place(/*_id/namedplace[placesystem=""area|country|territory""])/placename"
......
14 14
/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/plot/reallongitude
15 15
/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_id/plot/slopeaspect
16 16
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/plot/slopegradient
17
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}"
18
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}"
17
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}"
18
/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}"
19 19
/*ID->/*s/project/title,/*_id/project/projectname
20 20
/simpleUserdefined[name=authorCode]/value,/authorcode/_alt/1
21 21
->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/commclass/commdetermination/*_id/commconcept/*_id/*/commname
mappings/VegX-VegBIEN.organisms.csv
1 1
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonoccurrence
2 2
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area,/*_id/plotevent/*_id/plot/area
3 3
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/plotevent/*_id/plot/dsgpoly
4
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/plotevent/*_id/plot/elevation
4
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/plotevent/*_id/plot/elevation/_alt/1
5 5
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/plotevent/*_id/plot/locationaccuracy
6 6
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/plotevent/*_id/plot/parent_id/plot:[confidentialitystatus=0]/authorcode/_alt/1
7 7
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country,"/*_id/plotevent/*_id/plot/place(/*_id/namedplace[placesystem=""area|country|territory""])/placename"
......
14 14
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/DecimalLongitude,/*_id/plotevent/*_id/plot/reallongitude
15 15
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_id/plotevent/*_id/plot/slopeaspect
16 16
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/plotevent/*_id/plot/slopegradient
17
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/plotevent/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}"
18
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/plotevent/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}"
17
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/plotevent/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}"
18
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/minimumElevationInMeters,"/*_id/plotevent/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}"
19 19
/*ID->/*s/plotObservation/*ID->/*s/project/title,/*_id/plotevent/*_id/project/projectname
20 20
/*ID->/*s/plotObservation/simpleUserdefined[name=authorCode]/value,/*_id/plotevent/authorcode/_alt/1
21 21
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/communityConcepts/communityConcept/commonName,/*_id/plotevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname
mappings/NYBG-VegBIEN.organisms.csv
7 7
Locality,/*_id/plotevent/*_id/plot/place/*_id/namedplace/placedescription,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one."
8 8
Latitude,/*_id/plotevent/*_id/plot/reallatitude,
9 9
Longitude,/*_id/plotevent/*_id/plot/reallongitude,
10
MaximumElevation,"/*_id/plotevent/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}",
11
MinimumElevation,"/*_id/plotevent/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}",
10
MaximumElevation,"/*_id/plotevent/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
11
MinimumElevation,"/*_id/plotevent/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
12 12
DayCollected,/*_id/plotevent/obsstartdate/_date/day,
13 13
MonthCollected,/*_id/plotevent/obsstartdate/_date/month,
14 14
YearCollected,/*_id/plotevent/obsstartdate/_date/year,
mappings/for_review/VegX-VegBIEN.plots.csv
1 1
VegX:/*s/plotObservation,VegBIEN:/plotevent
2 2
//plot/area,//plot/area
3 3
//geospatial/FootprintWKT,//plot/dsgpoly
4
//geospatial/verbatimElevation,//plot/elevation
4
//geospatial/verbatimElevation,//plot/elevation/_alt/1
5 5
//geospatial/CoordinateUncertaintyInMeters,//plot/locationaccuracy
6 6
//plot/plotUniqueIdentifier,//plot/authorcode/_alt/1
7 7
//plot/country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename"
......
14 14
//geospatial/DecimalLongitude,//plot/reallongitude
15 15
//plot/slopeAspect,//plot/slopeaspect
16 16
//plot/slopeGradient,//plot/slopegradient
17
//geospatial/maximumElevationInMeters,"/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}"
18
//geospatial/minimumElevationInMeters,"/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}"
17
//geospatial/maximumElevationInMeters,"/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}"
18
//geospatial/minimumElevationInMeters,"/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}"
19 19
//project/title,//project/projectname
20 20
/simpleUserdefined[name=authorCode]/value,/authorcode/_alt/1
21 21
//*s/communityDetermination/communityConcepts/communityConcept/commonName,//*/commname
mappings/for_review/VegX-VegBIEN.organisms.csv
1 1
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonoccurrence
2 2
//plot/area,//plot/area
3 3
//geospatial/FootprintWKT,//plot/dsgpoly
4
//geospatial/verbatimElevation,//plot/elevation
4
//geospatial/verbatimElevation,//plot/elevation/_alt/1
5 5
//geospatial/CoordinateUncertaintyInMeters,//plot/locationaccuracy
6 6
//plot/plotUniqueIdentifier,//plot/authorcode/_alt/1
7 7
//plot/country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename"
......
14 14
//geospatial/DecimalLongitude,//plot/reallongitude
15 15
//plot/slopeAspect,//plot/slopeaspect
16 16
//plot/slopeGradient,//plot/slopegradient
17
//geospatial/maximumElevationInMeters,"/*_id/plotevent/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}"
18
//geospatial/minimumElevationInMeters,"/*_id/plotevent/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}"
17
//geospatial/maximumElevationInMeters,"/*_id/plotevent/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}"
18
//geospatial/minimumElevationInMeters,"/*_id/plotevent/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}"
19 19
//project/title,//project/projectname
20 20
//plotObservation/simpleUserdefined[name=authorCode]/value,//plotevent/authorcode/_alt/1
21 21
//*s/communityDetermination/communityConcepts/communityConcept/commonName,//*/commname
mappings/for_review/NYBG-VegBIEN.organisms.csv
7 7
Locality,//namedplace/placedescription,"Brad: Correct for VB; Nick, is there no specific element for locality description in VegX? Definitely need one."
8 8
Latitude,//plot/reallatitude,
9 9
Longitude,//plot/reallongitude,
10
MaximumElevation,"/*_id/plotevent/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}",
11
MinimumElevation,"/*_id/plotevent/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}",
10
MaximumElevation,"/*_id/plotevent/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
11
MinimumElevation,"/*_id/plotevent/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
12 12
DayCollected,//plotevent/obsstartdate/_date/day,
13 13
MonthCollected,//plotevent/obsstartdate/_date/month,
14 14
YearCollected,//plotevent/obsstartdate/_date/year,
mappings/for_review/SALVIAS-VegBIEN.plots.csv
1 1
SALVIAS,VegBIEN:/plotevent,Comments
2 2
plot_area_ha,//plot/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
elev_m,//plot/elevation,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.
3
elev_m,//plot/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 4
country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename",
5 5
pol1,"//*_id/namedplace[placesystem=""region|state|province""]/placename",Brad: No; pol1=stateProvince
6 6
major_geo,//*_id/namedplace[placesystem=continent]/placename,
......
10 10
long_decimal,//plot/reallongitude,
11 11
slope_aspect,//plot/slopeaspect,
12 12
slope_gradient,//plot/slopegradient,
13
elev_max_m,"/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}",
13
elev_max_m,"/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
15 15
project,//project/projectname,
16 16
life_zone_code,//*/commname,
17 17
holdridge_life_zone,//commconcept/commdescription,
mappings/for_review/SALVIAS_db-VegBIEN.plots.csv
1 1
SALVIAS:plotMetadata,VegBIEN:/plotevent,Comments
2 2
plot_area_ha,//plot/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
Elev,//plot/elevation,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.
3
Elev,//plot/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 4
Country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename",
5 5
PolDiv1,"//*_id/namedplace[placesystem=""region|state|province""]/placename",Brad: No; pol1=stateProvince
6 6
MajorGeo,//*_id/namedplace[placesystem=continent]/placename,
......
10 10
LongDec,//plot/reallongitude,
11 11
slope_aspect,//plot/slopeaspect,
12 12
slope_gradient,//plot/slopegradient,
13
elev_max_m,"/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}",
13
elev_max_m,"/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
15 15
project_id,//project/projectname,
16 16
PlotID,/authorcode/_alt/1,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
17 17
life_zone_code,//*/commname,
mappings/SALVIAS-VegBIEN.plots.csv
1 1
SALVIAS,VegBIEN:/plotevent,Comments
2 2
plot_area_ha,/*_id/plot/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
elev_m,/*_id/plot/elevation,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.
3
elev_m,/*_id/plot/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 4
country,"/*_id/plot/place(/*_id/namedplace[placesystem=""area|country|territory""])/placename",
5 5
pol1,"/*_id/plot/place(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince
6 6
major_geo,/*_id/plot/place(/*_id/namedplace[placesystem=continent])/placename,
......
10 10
long_decimal,/*_id/plot/reallongitude,
11 11
slope_aspect,/*_id/plot/slopeaspect,
12 12
slope_gradient,/*_id/plot/slopegradient,
13
elev_max_m,"/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}",
13
elev_max_m,"/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
15 15
project,/*_id/project/projectname,
16 16
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,
17 17
holdridge_life_zone,/commclass/commdetermination/*_id/commconcept/commdescription,
mappings/SALVIAS_db-VegBIEN.plots.csv
1 1
SALVIAS:plotMetadata,VegBIEN:/plotevent,Comments
2 2
plot_area_ha,/*_id/plot/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
Elev,/*_id/plot/elevation,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.
3
Elev,/*_id/plot/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 4
Country,"/*_id/plot/place(/*_id/namedplace[placesystem=""area|country|territory""])/placename",
5 5
PolDiv1,"/*_id/plot/place(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince
6 6
MajorGeo,/*_id/plot/place(/*_id/namedplace[placesystem=continent])/placename,
......
10 10
LongDec,/*_id/plot/reallongitude,
11 11
slope_aspect,/*_id/plot/slopeaspect,
12 12
slope_gradient,/*_id/plot/slopegradient,
13
elev_max_m,"/*_id/plot/{elevation/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_avg/min,elevationrange/_range/from}",
13
elev_max_m,"/*_id/plot/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
14
elev_min_m,"/*_id/plot/{elevation/_alt/2/_avg/min,elevationrange/_range/from}",
15 15
project_id,/*_id/project/projectname,
16 16
PlotID,/authorcode/_alt/1,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
17 17
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname,

Also available in: Unified diff