Revision 4808
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/NCU-NCSC/Specimen/map.csv | ||
|---|---|---|
| 8 | 8 |
State,stateProvince,, |
| 9 | 9 |
County,county,, |
| 10 | 10 |
Cultivated?,cultivated,, |
| 11 |
Elevation,verbatimElevation,, |
|
| 11 |
Elevation,verbatimElevation,,"Includes units [1]. |
|
| 12 |
|
|
| 13 |
[1] Using the following query: |
|
| 14 |
----- |
|
| 15 |
SELECT ""Elevation"", ""Country"", ""State"" |
|
| 16 |
FROM ""NCU-NCSC"".""Specimen"" |
|
| 17 |
WHERE ""Elevation"" IS NOT NULL |
|
| 18 |
GROUP BY ""Elevation"" , ""Country"", ""State"" |
|
| 19 |
-----" |
|
| 12 | 20 |
Lat (-=S),verbatimLatitude,"/_replace:[""\?$""=]/value", |
| 13 | 21 |
Long (-=W),verbatimLongitude,"/_replace:[""\?$""=]/value", |
| 14 | 22 |
Accuracy,coordinateUncertaintyInMeters,, |
| inputs/NCU-NCSC/Specimen/VegBIEN.csv | ||
|---|---|---|
| 2 | 2 |
Accession Number,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1", |
| 3 | 3 |
SeriesName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1", |
| 4 | 4 |
Barcode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else", |
| 5 |
Elevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value", |
|
| 5 |
Elevation,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value","Includes units [1]. |
|
| 6 |
|
|
| 7 |
[1] Using the following query: |
|
| 8 |
----- |
|
| 9 |
SELECT ""Elevation"", ""Country"", ""State"" |
|
| 10 |
FROM ""NCU-NCSC"".""Specimen"" |
|
| 11 |
WHERE ""Elevation"" IS NOT NULL |
|
| 12 |
GROUP BY ""Elevation"" , ""Country"", ""State"" |
|
| 13 |
-----" |
|
| 6 | 14 |
Accuracy,/location/locationcoords/coordsaccuracy_deg/_noCV/value/_alt/1, |
| 7 | 15 |
Lat (-=S),"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
| 8 | 16 |
Long (-=W),"/location/locationcoords/longitude_deg/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value", |
Also available in: Unified diff
inputs/NCU-NCSC/Specimen/map.csv: Documented that Elevation includes units