Monday, May 31, 2010

Create range thematics with Global Mapper

 It is not very obvious from the graphical user interface design and arrangement but it is quite possible to create thematic maps with Global Mapper; but the function is not as convenient as GeoMedia's or MapInfo's. I tried to use Global Mapper to create a similar range thematic map of average temperatures in the US as the sample GeoMedia dataset (shown below).

To create thematic maps in Global Mapper, do the following:

  1. Start up Global Mapper and display a polygon geometry data file e.g. States.shp.
  2. Press ALT+C.

    The Overlay Control Center dialog box appears.

  3. Select the layer in the list box and click Options.

    The Vector Options dialog box appears.

  4. Click the Area Styles tab.


  5. Toggle on Apply Styling Based on Attribute/Name Values.

    The Attribute/Name to Base Style On drop down list is activated.
  6. In the Attribute/Name to Base Style On field, choose a field e.g. AVETEMP.



    Note: In this example, we want to create a range thematic map based on the average temperature values in Fahrenheit from 20 degrees to 100 degrees. Each range is 10 degrees e.g. 60 ~ 69.99.
  7. Click New Value.

    The Select Area Style dialog box appears.

  8. In the Fill Pattern field, choose a value e.g. Solid Fill. Click the Fill Pattern Color.

    The Color dialog box appears.

  9. Choose a color. Click OK.

    The Enter Value for Style dialog box appears.

  10. Enter the value e.g. 60. Click OK.
  11. Repeat the previous steps 7 to 10 to create the ending range value e.g. 69.99.
  12. Repeat the previous steps 7 to 11 to create the next starting and ending range values e.g. 70 to 79.99.
  13. Toggle Interpolate Colors Between Numeric Values on.

    The Vector Options dialog box may look like this.


    Note: It is much easier to define thematic ranges in GeoMedia as it has a function to automatically classify the ranges based on the actual attribute values.
  14. Click OK.

    The range thematic map is created. Compare this with the sample GeoMedia thematic map above.


Monday, May 24, 2010

GDM2000 - BRSO (GRS80) Coordinates Conversion Calculator

Note: A WebApp version of this Google Gadget is available here http://dominoc925-pages.appspot.com/webapp/gdm2000brso/default.html.

GDM2000 or Geodetic Datum of Malaysia 2000 and BRSO or Borneo Rectified Skew Orthomorphic are coordinate systems commonly used in East Malaysia. This Google Gadget will allow you to convert between one or more pairs of BRSO easting, northing coordinates and geographical GDM2000 latitude, longitude (GRS80) coordinates, all on GRS80 ellipsoid.

Monday, May 17, 2010

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.



Monday, May 10, 2010

GDM2000 - MRSO(Peninsular) on GRS80 Ellipsoid Coordinates Converter

Note: A WebApp version of this Google Gadget is available here http://dominoc925-pages.appspot.com/webapp/gdm2000mrso/default.html.

GDM2000 or Geodetic Datum of Malaysia 2000 and MRSO(Peninsular) or Malayan Rectified Skew Orthomorphic are coordinate systems commonly used in Peninsular or West Malaysia. Thie Google Gadget will allow you to convert between one or more pairs of MRSO(Peninsular) easting, northing coordinates and geographical GDM2000 latitude, longitude (GRS80) coordinates, all on GRS80 ellipsoid.