Revision 10394
Added by Aaron Marcuse-Kubitza over 11 years ago
inputs/CTFS/Plot/map.csv | ||
---|---|---|
19 | 19 |
ReferenceY,*ReferenceY,,Rarely used |
20 | 20 |
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>)" |
21 | 21 |
ShapeOfSite,footprintWKT,, |
22 |
DescriptionOfSite,locality,,
|
|
22 |
DescriptionOfSite,locationRemarks,,
|
|
23 | 23 |
Country.src.row_num,*Country.src.row_num,, |
24 | 24 |
CountryName,country,, |
inputs/CTFS/Plot/VegBIEN.csv | ||
---|---|---|
14 | 14 |
GROUP BY ""Elevation""::real , ""LocationName"" |
15 | 15 |
ORDER BY ""Elevation""::real DESC |
16 | 16 |
-----" |
17 |
DescriptionOfSite,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
|
18 | 17 |
LocationName,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1, |
19 | 18 |
PlotName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then", |
20 | 19 |
PlotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
21 | 20 |
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
22 | 21 |
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
23 |
DescriptionOfSite,/location/locationnarrative/_merge/1, |
|
24 | 22 |
LocationName,/location/locationnarrative/_merge/1, |
23 |
DescriptionOfSite,/location/locationnarrative/_merge/4, |
|
25 | 24 |
ShapeOfSite,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc, |
26 | 25 |
Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value", |
27 | 26 |
Longitude,"/location/locationplace/*_id/place/*_id/coordinates/longitude_deg/_nullIf:[null=0,type=float]/value", |
inputs/CTFS/Plot/test.xml.ref | ||
---|---|---|
11 | 11 |
<sourceaccessioncode>$PlotID</sourceaccessioncode> |
12 | 12 |
<area_m2><_ha_to_m2><value>$SizeOfSite</value></_ha_to_m2></area_m2> |
13 | 13 |
<elevation_m>$Elevation</elevation_m> |
14 |
<iscultivated> |
|
15 |
<_locationnarrative_is_cultivated> |
|
16 |
<locationnarrative> |
|
17 |
<_alt> |
|
18 |
<0>$DescriptionOfSite</0> |
|
19 |
<1>$LocationName</1> |
|
20 |
</_alt> |
|
21 |
</locationnarrative> |
|
22 |
</_locationnarrative_is_cultivated> |
|
23 |
</iscultivated> |
|
14 |
<iscultivated><_locationnarrative_is_cultivated><locationnarrative>$LocationName</locationnarrative></_locationnarrative_is_cultivated></iscultivated> |
|
24 | 15 |
<locationnarrative> |
25 |
<_alt> |
|
26 |
<0>$DescriptionOfSite</0> |
|
16 |
<_merge> |
|
27 | 17 |
<1>$LocationName</1> |
28 |
</_alt> |
|
18 |
<4>$DescriptionOfSite</4> |
|
19 |
</_merge> |
|
29 | 20 |
</locationnarrative> |
30 | 21 |
<locationplace> |
31 | 22 |
<place_id> |
Also available in: Unified diff
inputs/CTFS/Plot/map.csv: DescriptionOfSite: remapped to locationRemarks, not locality