🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Technology & Design › GIS / Surveying / Drone Operations › Total Station Surveying › Lesson 11
TEC-GIS45-04 · Lesson 11 · 10 clock hours · lab

Data Download, Processing, and Export

Objective. Students transfer raw field data from the data collector to office software, process observations into a coordinate file, and export deliverables in formats usable by AutoCAD Civil 3D and ArcGIS.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by an industry-certified professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why Office Processing Matters

Field observations recorded by a total station are raw measurements: horizontal angles, vertical angles, and slope distances. Those numbers must be transferred to office software, corrected for physical effects, and organized into a usable coordinate file before any deliverable can be produced. A mistake at this stage—skipped corrections, a misread point number, or a wrong export format—can corrupt every downstream product: the CAD drawing, the GIS layer, and ultimately the client's decisions. Precision in the office is just as important as precision in the field.

Transferring the Raw Job File

Most modern data collectors connect to an office workstation via USB cable. Before connecting, power down the data collector and inspect the cable for damaged insulation; a frayed USB cable near a powered workstation is an electrical hazard—replace it before use. Once connected, the operating system recognizes the device as a removable drive or a COM port, depending on the manufacturer.

Open the manufacturer's office software (Trimble Business Center or Leica Infinity are common choices in this program). Use the import or transfer function to pull the raw job file from the collector. The raw file typically stores every observation in a proprietary binary or ASCII format. After import, the software displays each observation in a list: the instrument point, the backsight point, foresight point, horizontal circle reading, zenith angle, and slope distance. Review this list completely before processing. Look for:

Annotate any suspect observation in the software's notes field with a reason code before you decide to keep or reject it. Common reason codes used in this program: BL (blunder), DUP (duplicate), NV (not visited / incomplete shot).

Applying Corrections

Raw slope distances require two physical corrections before they become ground distances.

Atmospheric correction accounts for the fact that the instrument's EDM (electronic distance measurement) light travels through air whose density depends on temperature and pressure. The instrument applies a parts-per-million (ppm) correction using the temperature and pressure values entered at setup. Verify in the job file that those values were recorded; if the field crew left the defaults, the correction may be wrong. The office software allows you to override the atmospheric parameters and reprocess.

Curvature and refraction correction is needed when shots are long enough for the Earth's curvature and atmospheric refraction to affect the elevation difference derived from a zenith angle measurement. Most office software applies this automatically when you enable it in the project settings. Confirm it is turned on for any traverse leg or elevation shot longer than a few hundred feet.

After corrections, the software reduces the slope distance to a horizontal distance and computes a ΔZ (change in elevation). Combined with the instrument height, reflector height, and the elevation of the instrument point, it calculates the northing (N), easting (E), and elevation (Z) of each foresight point.

Reviewing the Control Setup

The coordinate solution is only as good as the control it is built on. Confirm that the instrument point coordinates and the backsight azimuth or backsight coordinates in the job file match the values from your control network documentation. A single transposed digit in a control coordinate will shift every derived point by the same amount—the traverse will close perfectly but be in the wrong location.

After processing, inspect the traverse closure. The office software reports a linear error of closure and a precision ratio (e.g., 1:10,000). Compare this to the required precision for your project class. If closure is outside tolerance, do not export until the problem is found and documented.

Generating and Annotating the Coordinate List

Once the traverse closes within tolerance and corrections are applied, generate the final coordinate list. The list should contain every accepted point with its Point ID, N, E, Z, and description. In the software, mark rejected shots with the appropriate reason code so the list and the audit trail both reflect what was excluded and why.

Exporting for ArcGIS Pro and AutoCAD Civil 3D

The most portable export format for point data is a comma-delimited text file (.csv) with columns in this order: Point, N, E, Z, Description. This column order is the convention expected by AutoCAD Civil 3D's Point Import command and is compatible with ArcGIS Pro's Add XY Data tool (you will map the E column to X-longitude and the N column to Y-latitude within the dialog).

Steps to verify the export:

1. Open the .csv in a plain text editor and confirm the header row matches the expected column names and that decimal places are consistent.

2. In ArcGIS Pro, use Map > Add Data > Add XY Data, select the .csv, set X Field = E and Y Field = N, assign the correct projected coordinate system, and verify that points plot in the correct location relative to a reference layer.

3. In Civil 3D, use Home > Import Points, select the PNEZD (comma-delimited) format, browse to the .csv, and confirm the point cloud appears in the correct position in the drawing.

If points appear in the wrong location or at the wrong elevation, recheck the coordinate system assignment and the N/E column mapping before assuming a processing error.

Data Integrity and File Naming

Save the processed job file and the exported .csv with a clear naming convention that includes the project name, date, and version (e.g., `RiverRd_Traverse_2025-06-10_v1.csv`). Keep the raw imported file untouched as the original record. Never overwrite raw data with processed data.

Key terms8

BlunderA gross observational error—such as a misread distance or wrong point number—that is clearly outside expected measurement variation and must be identified and rejected before processing.
Atmospheric correctionA parts-per-million (ppm) adjustment applied to EDM slope distances to account for the effect of air temperature and pressure on the speed of the instrument's light signal.
Curvature and refraction correctionAn adjustment that compensates for the combined effect of Earth's curvature and atmospheric bending on the vertical angle component of long EDM shots, affecting computed elevations.
PNEZD formatA comma-delimited point file format with columns ordered Point, Northing, Easting, Elevation (Z), Description; a standard import format recognized by AutoCAD Civil 3D and other survey software.
Linear error of closureThe straight-line distance between the computed closing position of a traverse and its known starting position, used to assess overall traverse accuracy before adjustment.
Add XY DataAn ArcGIS Pro tool that creates a point layer from a table containing numeric coordinate columns, requiring the user to specify which columns represent X (Easting) and Y (Northing) and to assign a coordinate system.
Precision ratioThe ratio of the linear error of closure to the total traverse length (e.g., 1:10,000), used to express how accurately a traverse was observed and computed relative to a required standard.
Reason codeA short annotation (such as BL for blunder or DUP for duplicate) added to a rejected observation in the office software to document why the shot was excluded from the final coordinate list.

Worked examples4

1. A slope distance of 312.45 ft is measured with an EDM. The instrument applies an atmospheric correction of –8 ppm. What is the corrected slope distance?
  1. Convert the correction to a multiplier: –8 ppm = –8 × 10⁻⁶ = –0.000008
  2. Calculate the correction amount: 312.45 ft × 0.000008 = 0.0025 ft (round to 0.002 ft at this precision)
  3. Apply the correction: 312.45 – 0.002 = 312.448 ft
  4. Report the corrected slope distance as 312.448 ft, or 312.45 ft rounded to the nearest hundredth
Answer: Corrected slope distance ≈ 312.448 ft (312.45 ft to the nearest hundredth)
2. A traverse has a total perimeter length of 4,250 ft and a linear error of closure of 0.34 ft. What is the precision ratio, and does it meet a 1:10,000 requirement?
  1. Write the precision ratio as 1 : (perimeter ÷ error of closure)
  2. Calculate: 4,250 ÷ 0.34 = 12,500 (rounded to the nearest 500)
  3. The ratio is 1:12,500
  4. Compare to the requirement: 1:12,500 is better (larger denominator) than 1:10,000, so the traverse meets the requirement
Answer: Precision ratio is 1:12,500; the traverse meets the 1:10,000 requirement.
3. After importing a .csv into ArcGIS Pro with Add XY Data, all points appear approximately 500,000 ft east of their expected location. The coordinate system is set to State Plane (NAD 83, US ft) with a false easting of 500,000 ft. The user mapped the N column to X and the E column to Y. What is the likely cause and correction?
  1. Recognize that N and E were swapped in the Add XY Data dialog: the Northing values were assigned to X (Easting) and vice versa
  2. The false easting in State Plane shifts valid Easting values by 500,000 ft, so using Northing as X produces a position far to the east of the true location
  3. Remove the event layer from the map
  4. Re-run Add XY Data and correctly set X Field = E (Easting) and Y Field = N (Northing)
Answer: The N and E columns were assigned to the wrong fields. Correct by setting X Field = E and Y Field = N in the Add XY Data dialog.
4. A foresight point is computed from a corrected slope distance of 285.12 ft, a zenith angle of 87°24'00", an instrument height (HI) of 5.42 ft, and a target height (HR) of 6.00 ft. The instrument point elevation is 452.70 ft. What is the elevation of the foresight point? (Ignore curvature/refraction for this short distance.)
  1. Convert the zenith angle to decimal degrees: 87°24'00" = 87 + 24/60 = 87.4000°
  2. Compute the vertical difference from slope distance and zenith angle: ΔZ = slope distance × cos(zenith angle) = 285.12 × cos(87.4°)
  3. cos(87.4°) ≈ 0.04536; ΔZ = 285.12 × 0.04536 ≈ 12.934 ft (uphill shot since zenith < 90°)
  4. Apply HI and HR: Elevation foresight = Elevation instrument + HI + ΔZ – HR = 452.70 + 5.42 + 12.934 – 6.00
  5. Elevation foresight = 452.70 + 5.42 + 12.934 – 6.00 = 465.054 ft
Answer: Elevation of the foresight point ≈ 465.05 ft

The math in this lesson2

Learners apply a -8 ppm correction (-8 x 10^-6) to a 312.45 ft slope distance to get 312.448 ft.
8.EE.4N-Q.3
Brush up in the math halls at newSchoolWorks.com:
In class: Connect data collector to the office workstation; use the manufacturer's office software (Trimble Business Center or Leica Infinity) to import the raw job file and review all observations for blunders · Process the control setup, apply atmospheric and curvature/refraction corrections, and generate a final coordinate list; annotate any rejected shots with reason codes · Export the coordinate file as a comma-delimited .csv (Point, N, E, Z, Description) and verify it imports correctly into both ArcGIS Pro (Add XY Data) and AutoCAD Civil 3D
Materials: Office workstation, manufacturer's office processing software, USB cable, raw data files from field lessons, ArcGIS Pro, AutoCAD Civil 3D (student license), export format reference sheet
Check: Exported .csv imports without errors into ArcGIS Pro and Civil 3D; coordinate values match processed output within rounding—both imports verified by instructor for pass

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Workplace Safety / Equipment Handling
1. When transferring a raw job file from the data collector via USB, what is the first safety action before connecting the cable?
Surveying Field Data / Data Quality
2. Which reason code should be annotated on an observation where the same point number was recorded twice with different coordinate values?
Total Station / EDM Corrections
3. Atmospheric correction to EDM slope distances is expressed in parts per million (ppm). If the correction is +12 ppm and the measured slope distance is 500.00 ft, what is the corrected distance?
Traverse Computation / NSPS CST
4. A traverse has a perimeter of 6,000 ft and a linear error of closure of 0.50 ft. What is the precision ratio?
GIS Data Import / Esri ArcGIS Pro
5. When using ArcGIS Pro's Add XY Data tool to import a PNEZD .csv file, which column should be assigned to the X Field?
CAD Integration / Survey Deliverables
6. Which AutoCAD Civil 3D point import format matches the column order Point, Northing, Easting, Elevation, Description in a comma-delimited file?
Total Station Corrections / NSPS CST
7. Curvature and refraction correction most significantly affects which type of measurement?
Control / Traverse Quality Control
8. After generating a final coordinate list, you discover that the instrument point coordinates entered in the field do not match your control network documentation. What is the correct action before exporting the deliverable?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →