To the list of courses || RASA2018 || To the theme || Estonian

Exercise 4030. Points 3, theme: Local Statistics Along a Line

Open exercise
A person is driving from Järve 4A, Elva to Vanemuise 46, Tartu.
  1. How long is the route and how large is the total climb (sum of vertical upward moving)?
  2. Add the route graph and explanation about the methods and data used.


You can find the location of an address using national geoportals (like XGIS, Bing maps, and Google maps. The last displays also the StreetView image of the location. There are also other options.
A GIS dektop software is not inevitably needed for drawing a route — GPSVisualizer works fine as well. It can measure the route length but not the total climb or altitude difference.
The SDC can help here if to transform the coordinates to Lambert-Est XY.
  • Save the digitized profile.
  • Open it in Excel. Select columns containing the coordinates and transform these to L-Est using the SDC or Spatial calculator from the Estonian Land Board.
  • Go to the page of Statistics along a line in the SDC.
  • Log in using account RASAtudeng : RASAtudeng.
  • Input the coordiantes to the input cell, select Lidar elevation as the data layer, write 100 as the Window interval and local value as the statistic. Window size does not matter if the only calculated statistic is local value.
  • If the data layer is numerical and the local value is selected, the calculator will return the sum of ascent among other numerical results.

The total ascent is returned also from gradient function of the SDC.
A profile graph is output also by the GPSVisualizer.

When summing the ascent in Excel, you have to calculate the altitude difference at each measured point (subtract the previous altitude from the location altitude starting from the second location). Then sum up the positive differences. The IF function can be used to select postive values (eg: =IF(B25>0;B25;0)). B25 is the cell which value is compared to zero. If the value is larger than 0, it is not changed, if not, then the call value will be 0.
Log in to send your results and to see the expected answer and responses from other students.