Borehole locations may occasionally be measured in global coordinates such as latitudinal and longitudinal values rather than a UTM system. They often refer to values in degrees, minutes or seconds rather than in meters of feet. If you would like to change the lat-long coordinates to a metric system, you can do so in GEOVIA Surpac.
For instance, a borehole has co-ordinates of: Latitude (North) 23⁰ 31′ 10.87″ and Longitude (East) 68⁰ 56′ 37.85″. All the boreholes in this area have been surveyed by this system. To change it in the UTM system, you will need to arrange the data in the following format and need to save the file in .csv format:
Open Surpac and import the file as a single string. Follow the below steps to import your data from a text file.
In the next step, you will need to select the .csv file field numbers as per X, Y, Z and definition fields of a string file. The string file named “bh_lat_long” will be generated and saved in your work directory.
Go to File tools > Transformations > Lat/Long to transverse Mercator.
The highlighted portion above illustrates the northing (D5) and easting (D6) values of all the boreholes. You can copy the values at each of these boreholes and use this converted value as your borehole coordinates.
This process can easily be streamlined and turned into a macro – if you’d like to find out more, contact your local office here.