Revision 4797
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/CTFS/Plot/map.csv | ||
|---|---|---|
| 5 | 5 |
LocationName,locality,, |
| 6 | 6 |
Latitude,verbatimLatitude,, |
| 7 | 7 |
Longitude,verbatimLongitude,, |
| 8 |
Elevation,verbatimElevation,, |
|
| 8 |
Elevation,elevationInMeters,,"Assuming units are m based on the range of values [1] and the country the data is from (Panama). Not documented in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>. |
|
| 9 |
|
|
| 10 |
[1] Using the following query: |
|
| 11 |
----- |
|
| 12 |
SELECT ""Elevation""::real, ""LocationName"" |
|
| 13 |
FROM ""CTFS"".""Plot"" |
|
| 14 |
GROUP BY ""Elevation""::real , ""LocationName"" |
|
| 15 |
ORDER BY ""Elevation""::real DESC |
|
| 16 |
-----" |
|
| 9 | 17 |
ReferenceX,ReferenceX,,Rarely used |
| 10 | 18 |
ReferenceY,ReferenceY,,Rarely used |
| 11 | 19 |
SizeOfSite,plotArea_ha,,"""Size in hectares"" (SizeOfSite comments in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>)" |
| inputs/CTFS/Plot/VegBIEN.csv | ||
|---|---|---|
| 5 | 5 |
PlotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 6 | 6 |
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
| 7 | 7 |
SizeOfSite,/location/area_m2/_ha_to_m2/value,"""Size in hectares"" (SizeOfSite comments in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>)" |
| 8 |
Elevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 8 |
Elevation,/location/elevation_m/_alt/1,"Assuming units are m based on the range of values [1] and the country the data is from (Panama). Not documented in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>. |
|
| 9 |
|
|
| 10 |
[1] Using the following query: |
|
| 11 |
----- |
|
| 12 |
SELECT ""Elevation""::real, ""LocationName"" |
|
| 13 |
FROM ""CTFS"".""Plot"" |
|
| 14 |
GROUP BY ""Elevation""::real , ""LocationName"" |
|
| 15 |
ORDER BY ""Elevation""::real DESC |
|
| 16 |
-----" |
|
| 9 | 17 |
ShapeOfSite,/location/locationcoords/footprintgeometry_dwc, |
| 10 | 18 |
Latitude,"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value", |
| 11 | 19 |
Longitude,"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value", |
| inputs/CTFS/Plot/test.xml.ref | ||
|---|---|---|
| 7 | 7 |
<authorlocationcode>$PlotName</authorlocationcode> |
| 8 | 8 |
<sourceaccessioncode>$PlotID</sourceaccessioncode> |
| 9 | 9 |
<area_m2><_ha_to_m2><value>$SizeOfSite</value></_ha_to_m2></area_m2> |
| 10 |
<elevation_m> |
|
| 11 |
<_replace> |
|
| 12 |
<\bca\.?></\bca\.?> |
|
| 13 |
<value>$Elevation</value> |
|
| 14 |
</_replace> |
|
| 15 |
</elevation_m> |
|
| 10 |
<elevation_m>$Elevation</elevation_m> |
|
| 16 | 11 |
<locationcoords> |
| 17 | 12 |
<footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc> |
| 18 | 13 |
<latitude_deg> |
Also available in: Unified diff
inputs/CTFS/Plot/map.csv: Remapped Elevation from verbatimElevation to elevationInMeters, since it is a float in the original bci.sql database. Note that the units are assumed based on the range of values present and the country the data is from (Panama).