Project

General

Profile

« Previous | Next » 

Revision 4807

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/Madidi/Plot/map.csv: Remapped Minimum altitude from minimumElevationInMeters to verbatimElevation_m, since it is a range, not a minimum. 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
28 28 
ORDER BY ""Altitude""::real DESC
29 29 
-----
30 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>"
31 
Minimum altitude,minimumElevationInMeters,,
31 
Minimum altitude,verbatimElevation_m,,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].
32 

  		




  
  33
  
    
[1] Using the following query:


  		




  
  34
  
    
-----


  		




  
  35
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  
  36
  
    
FROM ""Madidi"".""Plot""


  		




  
  37
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  
  38
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  
  39
  
    
-----


  		




  
  40
  
    
[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>"


  		




  32
  41
  
    
Locality,locality,,


  		




  33
  42
  
    
Locality description,communityName,,Often begins with the text in Vegetation type


  		




  34
  43
  
    
Direction,slopeAspect,/_alt/1,Part files provide either this field or Orientación


  		












  

    
      inputs/Madidi/Plot/VegBIEN.csv
    
  





  16
  16
  
    
ORDER BY ""Altitude""::real DESC


  		




  17
  17
  
    
-----


  		




  18
  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>"


  		




  19
  
  
    
Minimum altitude,"/location/elevation_m/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",


  		




  20
  
  
    
Minimum altitude,"/location/elevationrange_m/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",


  		




  21
  
  
    
Minimum altitude,"/location/elevationrange_m/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",


  		




  
  19
  
    
Minimum altitude,/location/elevation_m/_alt/2/_avg/max/_rangeEnd/value,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  
  20
  
    

  		




  
  21
  
    
[1] Using the following query:


  		




  
  22
  
    
-----


  		




  
  23
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  
  24
  
    
FROM ""Madidi"".""Plot""


  		




  
  25
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  
  26
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  
  27
  
    
-----


  		




  
  28
  
    
[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>"


  		




  
  29
  
    
Minimum altitude,/location/elevation_m/_alt/2/_avg/min/_rangeStart/value,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  
  30
  
    

  		




  
  31
  
    
[1] Using the following query:


  		




  
  32
  
    
-----


  		




  
  33
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  
  34
  
    
FROM ""Madidi"".""Plot""


  		




  
  35
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  
  36
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  
  37
  
    
-----


  		




  
  38
  
    
[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>"


  		




  
  39
  
    
Minimum altitude,/location/elevationrange_m/_range/from/_rangeStart/value,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  
  40
  
    

  		




  
  41
  
    
[1] Using the following query:


  		




  
  42
  
    
-----


  		




  
  43
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  
  44
  
    
FROM ""Madidi"".""Plot""


  		




  
  45
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  
  46
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  
  47
  
    
-----


  		




  
  48
  
    
[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>"


  		




  
  49
  
    
Minimum altitude,/location/elevationrange_m/_range/to/_rangeEnd/value,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  
  50
  
    

  		




  
  51
  
    
[1] Using the following query:


  		




  
  52
  
    
-----


  		




  
  53
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  
  54
  
    
FROM ""Madidi"".""Plot""


  		




  
  55
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  
  56
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  
  57
  
    
-----


  		




  
  58
  
    
[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>"


  		




  22
  59
  
    
Topographical situation,/location/landform,


  		




  23
  60
  
    
Latitude,"/location/locationcoords/latitude_deg/_alt/1/_nullIf:[null=0,type=float]/value",


  		




  24
  61
  
    
Latitude (DMS),"/location/locationcoords/latitude_deg/_alt/2/_nullIf:[null=0,type=float]/value",


  		




  ......




  53
  90
  
    
Direction,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/1,Part files provide either this field or Orientación


  		




  54
  91
  
    
Orientación/exposicion,/location/slopeaspect_deg/_alt/1/_compass/value/_alt/2,Part files provide either this field or Direction


  		




  55
  92
  
    
Slope,/location/slopegradient_fraction/_alt/1,


  		




  
  93
  
    
Minimum altitude,/location/verbatimelevation,"This is a range [1], not a minimum. Assuming units are m based on the range of values [1] and the region the data is from (Madidi National Park) [2].


  		




  
  94
  
    

  		




  
  95
  
    
[1] Using the following query:


  		




  
  96
  
    
-----


  		




  
  97
  
    
SELECT ""Minimum altitude"", ""Locality""


  		




  
  98
  
    
FROM ""Madidi"".""Plot""


  		




  
  99
  
    
WHERE ""Minimum altitude"" IS NOT NULL


  		




  
  100
  
    
GROUP BY ""Minimum altitude"" , ""Locality""


  		




  
  101
  
    
-----


  		




  
  102
  
    
[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>"


  		




  56
  103
  
    
Collaborators,,"** No join mapping for Collaborators ** Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"


  		




  57
  104
  
    
Coordinates,,** No join mapping for Coordinates ** Concatenation of Latitude (DMS) and Longitude (DMS)


  		




  58
  105
  
    
Installed and evaluated by,,"** No join mapping for Installed and evaluated by ** Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"


  		












  

    
      inputs/Madidi/Plot/test.xml.ref
    
  





  12
  12
  
    
                        <1>$Altitude</1>


  		




  13
  13
  
    
                        <2>


  		




  14
  14
  
    
                            <_avg>


  		




  15
  
  
    
                                <min>


  		




  16
  
  
    
                                    <_units>


  		




  17
  
  
    
                                        <default>m</default>


  		




  18
  
  
    
                                        <to>m</to>


  		




  19
  
  
    
                                        <to></to>


  		




  20
  
  
    
                                        <value>


  		




  21
  
  
    
                                            <_rangeStart>


  		




  22
  
  
    
                                                <value>


  		




  23
  
  
    
                                                    <_replace>


  		




  24
  
  
    
                                                        <\bca\.?></\bca\.?>


  		




  25
  
  
    
                                                        <value>$Minimum altitude</value>


  		




  26
  
  
    
                                                    </_replace>


  		




  27
  
  
    
                                                </value>


  		




  28
  
  
    
                                            </_rangeStart>


  		




  29
  
  
    
                                        </value>


  		




  30
  
  
    
                                    </_units>


  		




  31
  
  
    
                                </min>


  		




  
  15
  
    
                                <max><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></max>


  		




  
  16
  
    
                                <min><_rangeStart><value>$Minimum altitude</value></_rangeStart></min>


  		




  32
  17
  
    
                            </_avg>


  		




  33
  18
  
    
                        </2>


  		




  34
  19
  
    
                    </_alt>


  		




  35
  20
  
    
                </elevation_m>


  		




  36
  21
  
    
                <elevationrange_m>


  		




  37
  22
  
    
                    <_range>


  		




  38
  
  
    
                        <from>


  		




  39
  
  
    
                            <_units>


  		




  40
  
  
    
                                <default>m</default>


  		




  41
  
  
    
                                <to>m</to>


  		




  42
  
  
    
                                <to></to>


  		




  43
  
  
    
                                <value>


  		




  44
  
  
    
                                    <_rangeStart>


  		




  45
  
  
    
                                        <value>


  		




  46
  
  
    
                                            <_replace>


  		




  47
  
  
    
                                                <\bca\.?></\bca\.?>


  		




  48
  
  
    
                                                <value>$Minimum altitude</value>


  		




  49
  
  
    
                                            </_replace>


  		




  50
  
  
    
                                        </value>


  		




  51
  
  
    
                                    </_rangeStart>


  		




  52
  
  
    
                                </value>


  		




  53
  
  
    
                            </_units>


  		




  54
  
  
    
                        </from>


  		




  55
  
  
    
                        <to>


  		




  56
  
  
    
                            <_units>


  		




  57
  
  
    
                                <default>m</default>


  		




  58
  
  
    
                                <to>m</to>


  		




  59
  
  
    
                                <to></to>


  		




  60
  
  
    
                                <value>


  		




  61
  
  
    
                                    <_rangeEnd>


  		




  62
  
  
    
                                        <value>


  		




  63
  
  
    
                                            <_replace>


  		




  64
  
  
    
                                                <\bca\.?></\bca\.?>


  		




  65
  
  
    
                                                <value>$Minimum altitude</value>


  		




  66
  
  
    
                                            </_replace>


  		




  67
  
  
    
                                        </value>


  		




  68
  
  
    
                                    </_rangeEnd>


  		




  69
  
  
    
                                </value>


  		




  70
  
  
    
                            </_units>


  		




  71
  
  
    
                        </to>


  		




  
  23
  
    
                        <from><_rangeStart><value>$Minimum altitude</value></_rangeStart></from>


  		




  
  24
  
    
                        <to><_rangeEnd><value>$Minimum altitude</value></_rangeEnd></to>


  		




  72
  25
  
    
                    </_range>


  		




  73
  26
  
    
                </elevationrange_m>


  		




  74
  27
  
    
                <landform>$Topographical situation</landform>


  		




  ......




  161
  114
  
    
                    </_compass>


  		




  162
  115
  
    
                </slopeaspect_deg>


  		




  163
  116
  
    
                <slopegradient_fraction>$Slope</slopegradient_fraction>


  		




  
  117
  
    
                <verbatimelevation>$Minimum altitude</verbatimelevation>


  		




  164
  118
  
    
            </location>


  		




  165
  119
  
    
        </path>


  		




  166
  120
  
    
    </_simplifyPath>


  		












Also available in:  Unified diff