Revision 1078
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/SALVIAS/test/VegBIEN.plots.xml.ref | ||
|---|---|---|
| 4 | 4 |
<location_id> |
| 5 | 5 |
<location> |
| 6 | 6 |
<area>0.06</area> |
| 7 |
<authorlocationcode>ACHUPALL</authorlocationcode> |
|
| 8 | 7 |
<elevation>2100.0</elevation> |
| 9 | 8 |
<locationdetermination> |
| 10 | 9 |
<namedplace_id> |
| ... | ... | |
| 37 | 36 |
<projectname>1</projectname> |
| 38 | 37 |
</project> |
| 39 | 38 |
</project_id> |
| 39 |
<authorlocationcode>ACHUPALL</authorlocationcode> |
|
| 40 | 40 |
<commclass> |
| 41 | 41 |
<commdetermination> |
| 42 | 42 |
<commconcept_id> |
| ... | ... | |
| 63 | 63 |
<location_id> |
| 64 | 64 |
<location> |
| 65 | 65 |
<area>0.1</area> |
| 66 |
<authorlocationcode>ALLACHER</authorlocationcode> |
|
| 67 | 66 |
<elevation>530.0</elevation> |
| 68 | 67 |
<locationdetermination> |
| 69 | 68 |
<namedplace_id> |
| ... | ... | |
| 96 | 95 |
<projectname>1</projectname> |
| 97 | 96 |
</project> |
| 98 | 97 |
</project_id> |
| 98 |
<authorlocationcode>ALLACHER</authorlocationcode> |
|
| 99 | 99 |
<commclass> |
| 100 | 100 |
<commdetermination> |
| 101 | 101 |
<commconcept_id> |
| 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 |
SiteCode,/*_id/location/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
|
| 4 | 3 |
Elev,/*_id/location/elevation/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
| 5 | 4 |
Country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
| 6 | 5 |
PolDiv1,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince |
| ... | ... | |
| 15 | 14 |
LongDec,"/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}",
|
| 16 | 15 |
PlotMethod,/*_id/plotmethod/name, |
| 17 | 16 |
project_id,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 17 |
SiteCode,/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
|
| 18 | 18 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 19 | 19 |
life_zone,/commclass/commdetermination/*_id/commconcept/commdescription, |
| 20 | 20 |
Precip,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]:[@fkey=tableRecord_ID]/definedvalue", |
| inputs/SALVIAS-CSV/test/VegBIEN.plots.xml.ref | ||
|---|---|---|
| 4 | 4 |
<location_id> |
| 5 | 5 |
<location> |
| 6 | 6 |
<area>0.44</area> |
| 7 |
<authorlocationcode>ALP-11</authorlocationcode> |
|
| 8 | 7 |
<elevation>200</elevation> |
| 9 | 8 |
<locationdetermination> |
| 10 | 9 |
<namedplace_id> |
| ... | ... | |
| 46 | 45 |
<projectname>RAINFOR - 1 ha Peru</projectname> |
| 47 | 46 |
</project> |
| 48 | 47 |
</project_id> |
| 48 |
<authorlocationcode>ALP-11</authorlocationcode> |
|
| 49 | 49 |
<obsstartdate>1990-11-16</obsstartdate> |
| 50 | 50 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
| 51 | 51 |
<sourceaccessioncode>26102</sourceaccessioncode> |
| ... | ... | |
| 54 | 54 |
<location_id> |
| 55 | 55 |
<location> |
| 56 | 56 |
<area>0.4</area> |
| 57 |
<authorlocationcode>ALP-12</authorlocationcode> |
|
| 58 | 57 |
<elevation>200</elevation> |
| 59 | 58 |
<locationdetermination> |
| 60 | 59 |
<namedplace_id> |
| ... | ... | |
| 96 | 95 |
<projectname>RAINFOR - 1 ha Peru</projectname> |
| 97 | 96 |
</project> |
| 98 | 97 |
</project_id> |
| 98 |
<authorlocationcode>ALP-12</authorlocationcode> |
|
| 99 | 99 |
<obsstartdate>1990-11-16</obsstartdate> |
| 100 | 100 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
| 101 | 101 |
<sourceaccessioncode>26103</sourceaccessioncode> |
| inputs/SALVIAS-CSV/test/VegBIEN.organisms.xml.ref | ||
|---|---|---|
| 3 | 3 |
<taxonoccurrence id="0"> |
| 4 | 4 |
<locationevent_id> |
| 5 | 5 |
<locationevent> |
| 6 |
<location_id> |
|
| 7 |
<location> |
|
| 8 |
<authorlocationcode>1</authorlocationcode> |
|
| 9 |
<parent_id><location><authorlocationcode>ALP-11</authorlocationcode></location></parent_id> |
|
| 10 |
</location> |
|
| 11 |
</location_id> |
|
| 6 |
<authorlocationcode>1</authorlocationcode> |
|
| 12 | 7 |
<obsstartdate>2001-01-01</obsstartdate> |
| 8 |
<parent_id><locationevent><authorlocationcode>ALP-11</authorlocationcode></locationevent></parent_id> |
|
| 13 | 9 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
| 14 | 10 |
<sourceaccessioncode>26102</sourceaccessioncode> |
| 15 | 11 |
</locationevent> |
| ... | ... | |
| 126 | 122 |
<taxonoccurrence id="1"> |
| 127 | 123 |
<locationevent_id> |
| 128 | 124 |
<locationevent> |
| 129 |
<location_id> |
|
| 130 |
<location> |
|
| 131 |
<authorlocationcode>4</authorlocationcode> |
|
| 132 |
<parent_id><location><authorlocationcode>ALP-11</authorlocationcode></location></parent_id> |
|
| 133 |
</location> |
|
| 134 |
</location_id> |
|
| 125 |
<authorlocationcode>4</authorlocationcode> |
|
| 135 | 126 |
<obsstartdate>2001-01-01</obsstartdate> |
| 127 |
<parent_id><locationevent><authorlocationcode>ALP-11</authorlocationcode></locationevent></parent_id> |
|
| 136 | 128 |
<datasource_id><party><organizationname>SALVIAS</organizationname></party></datasource_id> |
| 137 | 129 |
<sourceaccessioncode>26102</sourceaccessioncode> |
| 138 | 130 |
</locationevent> |
| inputs/SALVIAS-CSV/test/import.organisms.out.ref | ||
|---|---|---|
| 1 |
Inserted 82 new rows into database |
|
| 1 |
Inserted 80 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 |
plot_code,/*_id/location/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
|
| 4 | 3 |
elev_m,/*_id/location/elevation/_alt/1,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick. |
| 5 | 4 |
country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
| 6 | 5 |
pol1,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename",Brad: No; pol1=stateProvince |
| ... | ... | |
| 15 | 14 |
long_decimal,"/*_id/location/{locationdetermination[!namedplace_id]/longitude,centerlongitude}",
|
| 16 | 15 |
plot_methodology,/*_id/plotmethod/name, |
| 17 | 16 |
project,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 17 |
plot_code,/authorlocationcode,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project) |
|
| 18 | 18 |
holdridge_life_zone,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 19 | 19 |
life_zone_code,/commclass/commdetermination/*_id/commconcept/commdescription, |
| 20 | 20 |
precip_mm,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]:[@fkey=tableRecord_ID]/definedvalue", |
| inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
SALVIAS,VegBIEN:/taxonoccurrence,Comments |
| 2 |
subplot,/*_id/locationevent/*_id/location/authorlocationcode, |
|
| 3 |
plot_code,/*_id/locationevent/*_id/location/parent_id/location/authorlocationcode,"Brad: Same as plotCode, above" |
|
| 2 |
subplot,/*_id/locationevent/authorlocationcode, |
|
| 4 | 3 |
census_date,/*_id/locationevent/obsstartdate/_date/year, |
| 4 |
plot_code,/*_id/locationevent/parent_id/locationevent/authorlocationcode,"Brad: Same as plotCode, above" |
|
| 5 | 5 |
PLOT_ID,/*_id/locationevent:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/sourceaccessioncode,"Brad: Not sure why this is repeated? This field and plotCode, as the same as above." |
| 6 | 6 |
height_m,/aggregateoccurrence/*_id/plantobservation/overallheight,Brad: Incorrect for VegBank. This is a measurement applied to a single tree. Check with Bob |
| 7 | 7 |
stem_height_m,/aggregateoccurrence/*_id/plantobservation/overallheight,"Brad: Same as for height, but applies to individuals stems, not trees. Rare." |
| mappings/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/plotObservation,VegBIEN:/locationevent,Comments |
| 2 | 2 |
/*UniqueIdentifierID->/*s/plot/area,/*_id/location/area, |
| 3 |
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/location/authorlocationcode, |
|
| 4 | 3 |
/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/location/elevation/_alt/1, |
| 5 | 4 |
/*UniqueIdentifierID->/*s/plot/country,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
| 6 | 5 |
/*UniqueIdentifierID->/*s/plot/state,"/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename", |
| ... | ... | |
| 9 | 8 |
/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy, |
| 10 | 9 |
/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc, |
| 11 | 10 |
/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/location/locationnarrative, |
| 12 |
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/location/parent_id/location/authorlocationcode, |
|
| 13 | 11 |
/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_id/location/slopeaspect, |
| 14 | 12 |
/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/location/slopegradient, |
| 15 | 13 |
/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| ... | ... | |
| 19 | 17 |
/simpleUserdefined[name=plotMethodology]/value,/*_id/plotmethod/name, |
| 20 | 18 |
/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1, |
| 21 | 19 |
/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 20 |
/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/authorlocationcode, |
|
| 22 | 21 |
->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 23 | 22 |
->/*s/communityDetermination[*ID]/*s/communityConcept/name,/commclass/commdetermination/*_id/commconcept/commdescription, |
| 24 | 23 |
/simpleUserdefined[name=precipMm]/value,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]:[@fkey=tableRecord_ID]/definedvalue", |
| ... | ... | |
| 30 | 29 |
/obsStartDate/_date/day,/obsstartdate/_date/day, |
| 31 | 30 |
/obsStartDate/_date/month,/obsstartdate/_date/month, |
| 32 | 31 |
/obsStartDate/_date/year,/obsstartdate/_date/year, |
| 32 |
/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/parent_id/locationevent/authorlocationcode, |
|
| 33 | 33 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]:[@fkey=tableRecord_ID]/definedvalue", |
| 34 | 34 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]]:[@fkey=tableRecord_ID]/definedvalue", |
| 35 | 35 |
->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]]:[@fkey=tableRecord_ID]/definedvalue", |
| mappings/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonoccurrence,Comments |
| 2 | 2 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/area,/*_id/locationevent/*_id/location/area, |
| 3 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/*_id/location/authorlocationcode, |
|
| 4 | 3 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/verbatimElevation,/*_id/locationevent/*_id/location/elevation/_alt/1, |
| 5 | 4 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/country,"/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""area|country|territory""])/placename", |
| 6 | 5 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/state,"/*_id/locationevent/*_id/location/locationdetermination(/*_id/namedplace[placesystem=""region|state|province""])/placename", |
| ... | ... | |
| 9 | 8 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/CoordinateUncertaintyInMeters,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/coordsaccuracy, |
| 10 | 9 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/FootprintWKT,/*_id/locationevent/*_id/location/locationdetermination[!namedplace_id]/footprintgeometry_dwc, |
| 11 | 10 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/simpleUserdefined[name=localityDescription]/value,/*_id/locationevent/*_id/location/locationnarrative, |
| 12 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/*_id/location/parent_id/location/authorlocationcode, |
|
| 13 | 11 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeAspect,/*_id/locationevent/*_id/location/slopeaspect, |
| 14 | 12 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/slopeGradient,/*_id/locationevent/*_id/location/slopegradient, |
| 15 | 13 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/geospatial/maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| ... | ... | |
| 19 | 17 |
/*ID->/*s/plotObservation/simpleUserdefined[name=plotMethodology]/value,/*_id/locationevent/*_id/plotmethod/name, |
| 20 | 18 |
/*ID->/*s/plotObservation/*ID->/*s/project/personnel[role=metadataProvider]/organizationName,/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1, |
| 21 | 19 |
/*ID->/*s/plotObservation/*ID->/*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,/*_id/locationevent/*_id/project:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/projectname, |
| 20 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/authorlocationcode, |
|
| 22 | 21 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/commonName,/*_id/locationevent/commclass/commdetermination/*_id/commconcept/*_id/*/commname, |
| 23 | 22 |
/*ID->/*s/plotObservation->/*s/communityDetermination[*ID]/*s/communityConcept/name,/*_id/locationevent/commclass/commdetermination/*_id/commconcept/commdescription, |
| 24 | 23 |
/*ID->/*s/plotObservation/simpleUserdefined[name=precipMm]/value,"/*_id/locationevent/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]:[@fkey=tableRecord_ID]/definedvalue", |
| ... | ... | |
| 30 | 29 |
/*ID->/*s/plotObservation/obsStartDate/_date/day,/*_id/locationevent/obsstartdate/_date/day, |
| 31 | 30 |
/*ID->/*s/plotObservation/obsStartDate/_date/month,/*_id/locationevent/obsstartdate/_date/month, |
| 32 | 31 |
/*ID->/*s/plotObservation/obsStartDate/_date/year,/*_id/locationevent/obsstartdate/_date/year, |
| 32 |
/*ID->/*s/plotObservation/*UniqueIdentifierID->/*s/plot/relatedSpatialItem/relatedItem[relationshipType=parentPlot]/relatedItemID->/*s/plot/plotUniqueIdentifier,/*_id/locationevent/parent_id/locationevent/authorlocationcode, |
|
| 33 | 33 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=acidity]/value,"/*_id/locationevent/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]:[@fkey=tableRecord_ID]/definedvalue", |
| 34 | 34 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=base]/value,"/*_id/locationevent/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]]:[@fkey=tableRecord_ID]/definedvalue", |
| 35 | 35 |
/*ID->/*s/plotObservation->/*s/abioticObservation[*ID]/simpleUserdefined[name=calcium]/value,"/*_id/locationevent/soilobs:[soilhorizon=unknown]/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]]:[@fkey=tableRecord_ID]/definedvalue", |
| mappings/for_review/VegX-VegBIEN.plots.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/plotObservation,VegBIEN:/locationevent,Comments |
| 2 | 2 |
//plot/area,//location/area, |
| 3 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
|
| 4 | 3 |
//geospatial/verbatimElevation,//location/elevation/_alt/1, |
| 5 | 4 |
//plot/country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename", |
| 6 | 5 |
//plot/state,"//*_id/namedplace[placesystem=""region|state|province""]/placename", |
| ... | ... | |
| 9 | 8 |
//geospatial/CoordinateUncertaintyInMeters,//location/locationdetermination[]/coordsaccuracy, |
| 10 | 9 |
//geospatial/FootprintWKT,//location/locationdetermination[]/footprintgeometry_dwc, |
| 11 | 10 |
//plot/simpleUserdefined[name=localityDescription]/value,//location/locationnarrative, |
| 12 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
|
| 13 | 11 |
//plot/slopeAspect,//location/slopeaspect, |
| 14 | 12 |
//plot/slopeGradient,//location/slopegradient, |
| 15 | 13 |
//geospatial/maximumElevationInMeters,"/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| ... | ... | |
| 19 | 17 |
/simpleUserdefined[name=plotMethodology]/value,//plotmethod/name, |
| 20 | 18 |
//project/personnel[role=metadataProvider]/organizationName,//party/organizationname/_alt/1, |
| 21 | 19 |
//*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,//project/projectname, |
| 20 |
//plot/plotUniqueIdentifier,/authorlocationcode, |
|
| 22 | 21 |
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname, |
| 23 | 22 |
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription, |
| 24 | 23 |
/simpleUserdefined[name=precipMm]/value,"/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]/definedvalue", |
| ... | ... | |
| 30 | 29 |
/obsStartDate/_date/day,/obsstartdate/_date/day, |
| 31 | 30 |
/obsStartDate/_date/month,/obsstartdate/_date/month, |
| 32 | 31 |
/obsStartDate/_date/year,/obsstartdate/_date/year, |
| 32 |
//plot/plotUniqueIdentifier,//locationevent/authorlocationcode, |
|
| 33 | 33 |
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,"//soilobs/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]/definedvalue", |
| 34 | 34 |
//*s/abioticObservation/simpleUserdefined[name=base]/value,"//soilobs/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]]/definedvalue", |
| 35 | 35 |
//*s/abioticObservation/simpleUserdefined[name=calcium]/value,"//soilobs/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]]/definedvalue", |
| mappings/for_review/VegX-VegBIEN.organisms.csv | ||
|---|---|---|
| 1 | 1 |
VegX:/*s/individualOrganismObservation,VegBIEN:/taxonoccurrence,Comments |
| 2 | 2 |
//plot/area,//location/area, |
| 3 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
|
| 4 | 3 |
//geospatial/verbatimElevation,//location/elevation/_alt/1, |
| 5 | 4 |
//plot/country,"//*_id/namedplace[placesystem=""area|country|territory""]/placename", |
| 6 | 5 |
//plot/state,"//*_id/namedplace[placesystem=""region|state|province""]/placename", |
| ... | ... | |
| 9 | 8 |
//geospatial/CoordinateUncertaintyInMeters,//location/locationdetermination[]/coordsaccuracy, |
| 10 | 9 |
//geospatial/FootprintWKT,//location/locationdetermination[]/footprintgeometry_dwc, |
| 11 | 10 |
//plot/simpleUserdefined[name=localityDescription]/value,//location/locationnarrative, |
| 12 |
//plot/plotUniqueIdentifier,//location/authorlocationcode, |
|
| 13 | 11 |
//plot/slopeAspect,//location/slopeaspect, |
| 14 | 12 |
//plot/slopeGradient,//location/slopegradient, |
| 15 | 13 |
//geospatial/maximumElevationInMeters,"/*_id/locationevent/*_id/location/{elevation/_alt/2/_avg/max,elevationrange/_range/to}",
|
| ... | ... | |
| 19 | 17 |
//plotObservation/simpleUserdefined[name=plotMethodology]/value,//plotmethod/name, |
| 20 | 18 |
//project/personnel[role=metadataProvider]/organizationName,//party/organizationname/_alt/1, |
| 21 | 19 |
//*s/project:[personnel[role=metadataProvider]/organizationName=$/_ignore/inLabel]/title,//project/projectname, |
| 20 |
//plot/plotUniqueIdentifier,//locationevent/authorlocationcode, |
|
| 22 | 21 |
//*s/communityDetermination/*s/communityConcept/commonName,//*/commname, |
| 23 | 22 |
//*s/communityDetermination/*s/communityConcept/name,//commconcept/commdescription, |
| 24 | 23 |
//plotObservation/simpleUserdefined[name=precipMm]/value,"//locationevent/definedvalue[*_id/userdefined[tablename=locationevent,userdefinedname=precipitationMm]]/definedvalue", |
| ... | ... | |
| 30 | 29 |
//plotObservation/obsStartDate/_date/day,//locationevent/obsstartdate/_date/day, |
| 31 | 30 |
//plotObservation/obsStartDate/_date/month,//locationevent/obsstartdate/_date/month, |
| 32 | 31 |
//plotObservation/obsStartDate/_date/year,//locationevent/obsstartdate/_date/year, |
| 32 |
//plot/plotUniqueIdentifier,//locationevent/authorlocationcode, |
|
| 33 | 33 |
//*s/abioticObservation/simpleUserdefined[name=acidity]/value,"//soilobs/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilAcidity]]/definedvalue", |
| 34 | 34 |
//*s/abioticObservation/simpleUserdefined[name=base]/value,"//soilobs/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilBase]]/definedvalue", |
| 35 | 35 |
//*s/abioticObservation/simpleUserdefined[name=calcium]/value,"//soilobs/definedvalue[*_id/userdefined[tablename=soilObs,userdefinedname=soilCalcium]]/definedvalue", |
Also available in: Unified diff
SALVIAS mappings: Map SiteCode/plot_code to locationevent.authorlocationcode because locationevent is now the place to store author-specific plot information