Project

General

Profile

« Previous | Next » 

Revision 4798

inputs/Madidi/Plot/map.csv: Remapped Altitude from verbatimElevation to elevationInMeters, since the values are all decimals. Note that the units are assumed based on the range of values present and the region the data is from (Madidi National Park).

View differences:

inputs/Madidi/Plot/map.csv
17 17
Longitude,decimalLongitude,,
18 18
Latitude (DMS),verbatimLatitude,,
19 19
Longitude (DMS),verbatimLongitude,,
20
Altitude,verbatimElevation,,
20
Altitude,elevationInMeters,,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].
21

  
22
[1] Using the following query:
23
-----
24
SELECT ""Altitude""::real, ""Locality""
25
FROM ""Madidi"".""Plot""
26
WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'
27
GROUP BY ""Altitude""::real , ""Locality""
28
ORDER BY ""Altitude""::real DESC
29
-----
30
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"
21 31
Minimum altitude,minimumElevationInMeters,,
22 32
Locality,locality,,
23 33
Locality description,communityName,,Often begins with the text in Vegetation type
inputs/Madidi/Plot/VegBIEN.csv
5 5
Inventory name,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
6 6
Inventory code,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
7 7
Area,/location/area_m2/_ha_to_m2/value,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"
8
Altitude,"/location/elevation_m/_alt/1/_replace:[""\bca\.?""=]/value",
8
Altitude,/location/elevation_m/_alt/1,"Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].
9

  
10
[1] Using the following query:
11
-----
12
SELECT ""Altitude""::real, ""Locality""
13
FROM ""Madidi"".""Plot""
14
WHERE ""Altitude"" IS NOT NULL AND ""Altitude"" != ' 1430'
15
GROUP BY ""Altitude""::real , ""Locality""
16
ORDER BY ""Altitude""::real DESC
17
-----
18
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"
9 19
Minimum altitude,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
10 20
Minimum altitude,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11 21
Minimum altitude,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
inputs/Madidi/Plot/test.xml.ref
9 9
                <area_m2><_ha_to_m2><value>$Area</value></_ha_to_m2></area_m2>
10 10
                <elevation_m>
11 11
                    <_alt>
12
                        <1>
13
                            <_replace>
14
                                <\bca\.?></\bca\.?>
15
                                <value>$Altitude</value>
16
                            </_replace>
17
                        </1>
12
                        <1>$Altitude</1>
18 13
                        <2>
19 14
                            <_avg>
20 15
                                <min>

Also available in: Unified diff