Sometimes data is provided in CSV format from other packages that contain Latitude and Longitude information. To ensure this data to be seen and read in Surpac, it is necessary to convert the data into a grid reference system. In this example, the reference will be MGA94, however the technique can be equally applied to other grid systems.
Step 1: The first step is to take the csv data and turn it into a string file. This can be done in numerous ways including via excel, using a macro or importing the file into Surpac. For this example we will use excel and then import the file.
The csv currently looks like the image below, with Longitude in column 1, Latitude in column 2 and height in column 3. The other fields will be carried through to the resulting string file but aren’t important for the conversion.