Points to Surface Comparison Report

Last updated: 2025-04-08

Overview

This report will compare points from a point group or a point file to a surface. An .xlsx report file will be created with the point and surface comparison data. The PointData tab of the Excel file includes the individual point elevations compared to the surface elevation. In the Results tab you can adjust the tolerance values for the analysis and check the sensitivity of raising or lowering the surface elevation.

Usage

WisDOT Survey tab > Mapping panel > Points to Surface Comparison

The tool can also be accessed from the command line: DOTREPORTPOINTSTOSURFACECOMPARE

Point comparison using a point group

  1. In the Points to Surface Comparison Report dialog, select a surface from the menu.
  2. Select the Point Group radio button and select a point group from the menu.
  3. Click the folder icon in the Output panel to open the Save File As.. dialog.
  4. Browse to a file location and type a file name for the .xlsx report.
  5. Save
  6. Create Report

Point comparison using a point file

  1. In the Points to Surface Comparison Report dialog, select a surface from the menu.
  2. Select the File radio button.
  3. Click the folder icon in the Output panel to open the Select Point File dialog.

  4. Select a point file.

    Requirement: Point file must be PENZD format of the file type: .txt, .wsi, or .csv.

  5. Open
  6. Click the folder icon in the Output panel to open the Save File As.. dialog.
  7. Browse to a file location and type a file name for the .xlsx report.
  8. Save
  9. Create Report
  10. Select lines from the point file to include in the report. Exclude any header information lines. Use Shift or Ctrl buttons to select/deselect multiple lines.
  11. OK
  12. Once complete, the .xlsx report will open.

.xlsx output

  1. PointData tab

    • View a point by point comparison to the surface

  2. Results tab

    • Adjust tolerance levels

    • Raise or lower the overall surface elevation

    • View the overall comparison results

Sample report

pnt-to-srfc-cmpr.xlsx