Posts Tagged ‘modelos digitales de elevaciones’

Using Excel to calculate the RMSE for LiDAR vertical ground control points



The height accuracy of the collected LiDAR data can be verified by comparing with independently surveyed ground control points on hard, flat, open surfaces. It is essentially just calculating the height differences for all the control points and then determining the height root mean squared error (RMSE) or differences. Most LiDAR processing software have the reporting function built-in. However, plain Microsoft Excel can also do the job (except for extracting the elevation from the LiDAR data).

Assuming that you are able to calculate the height differences for all the control points and place in a spreadsheet as shown in the figure below. I have a column of delta Z values in column A.

Then to calculate the RMS value for the elevation differences, I can do the following.

  1. In a cell, type in the formula:= SQRT(SUMSQ(A2:A18)/COUNTA(A2:A18))where A2:A18 are the values from cell A2 to A18 in the spreadsheet. Simply replace these with the actual locations on your spreadsheet.
  2. Press RETURN.
    The RMSE value is calculated.



More of my 3D video edited scenarios.


Please, dont forget to turn on your speakers. Even if i first used a different score and Youtube’s elfs told me not to use it (because of copyright authoring) I have chosen this music from their stuff and this is what I finally got…

Hope you like it.
BA Geography
MSc GIS and Remote Sensing
GIS Technician and Multimedia Designer
albertoconcejal -at

One more 3D building. Avenida de la Vega 28108. Restaurante Asiático SHENG. Madrid, Spain.


I used to have lunch every thrusday there, at the ‘Restaurante Asiático SHENG’. I strongly recommend you ‘entremeses’ (In China you will find them as ‘dim-sum’) and Cantonese duck or Hong Kong duck (this was slightly spicy thou).  Very good food, very fast service and pretty cheap menu: 10,7 €… ideal for an IT worker!.


These views were rendered using ‘V-RAY’ for Sketch-up.



And now, Let’s go to Google Earth!



(I have modified my kml using a extruded placemark we talked about a few posts ago).
Now Let’s have our business in 3D!!!!!!!!!!!!!!!.
Hope you like it.
BA Geography
MSc GIS and Remote Sensing
GIS Technician
albertoconcejal -at

Definición de flujos de trabajo en 3D


Protocolos de creación de escenarios en 3D, tratamiento de imágenes satélite, creación de modelos digitales de elevaciones -MDE- y del terreno -MDT- además de modelos en 3D. Google Sketchup, Google Earth, Global Mapper.





Sketch-up google, edificios singulares. 3Ds, vrml, skp,…


Presa de El Atazar, Madrid

Iglesia de Cadalso de los Vidrios

Torreon de Villarejo de Salvanés

Madrid 3d… Geovisualization live!