Recording UTM Coordinates for Time Data

RockWorks | Utilities | Coords | Merge Time-Stamped GPS Data

This program is used to add X,Y coordinates (e.g. UTM eastings & northings) to datasets that only have a "timestamp". The coordinates for a given event (e.g. a geophysical measurement) are established by locating the preceding and succeeding times within a designated GPS file and interpolating between these two "known" points.

Here's an example: Let's say that you have a dataset of conductivity measurements. Each measurement has a time. Now, let's say that you have another dataset from a GPS that has time and coordinates. This program will use the GPS dataset to add coordinates to the conductivity dataset so that the conductivity measurements can be subsequently mapped.

Menu Options
Step-by-Step Summary

Menu Options

• Data Columns
  • Input: Time: Select the name of the column in the datasheet that contains the time measurements.
  • Output: X (Easting), Y (Northing): Select the name of the columns in the current datasheet into which the program is to record the computed X and Y coordinates. Any existing data in this column will be overwritten.
• Options
  • Time/Coordinates Input File (RwDat): Click here to browse for the separate datasheet you've created that lists times with X,Y coordinates. The program will use this file to know how to assign Eastings and Northings to the time records. A common source of this type of data is a GPS unit - see Importing Garmin GPS Data for information about capturing "tracks" data.
  • Decimals: Define the number of decimal places to be stored in the output coordinates.
  • Time / Offset Correction: Click in these prompts to type in the decimal hours, minutes, and seconds to be added to your data, if any.
  • 
    

Step-by-Step Summary

1. Access the RockWorks Datasheet program tab.
2. Create and save the reference Time/Coordinates data file.
3. Open or create a data file containing the times to be translated.
4. Select the Utilities | Coords | Merge Time-Stamped GPS Data menu option.
5. Enter the requested translation items, described above.
6. Click the Continue button to proceed.

The program will read the input time data, match it to the times and coordinates listed in the reference Time/Coordinates file, and list computed Eastings and Northings in the selected output columns.

Back to Coords Menu Summary

RockWare home page