4.2. Import stations coordinates

4.2.1. Prepare coordinates file

Software can import coordinates from Comma-separated-values (CSV) file format or text data formatted by Magellan GNSS Solutions software.

4.2.1.1. CSV coordinates file

Comma-separated values (CSV) format coordinates file has to contain station name, latitude, longitude and elevation data. In addition, line name can be provided.

The CSV file must contain header line with column names. Data are recognized according to the column names as follows:

Column name Data values
Line Name of the line (optional); if the line does not exist, new line will be created
Station Name of the station; if the station exists in the given line, coordinates will be overwritten with new values
Latitude or Lat Station latitude in degrees
Longitude or Lon Station longitude in degrees
UTMX or Easting Station UTM easting in meters
UTMY or Northing Station UTM nothing in meters
Elevation or Altitude or Alt Station elevation in meters
Terrain or Terrain corr. or Terrain correction Value of terrain correction in mGal
Instrument height Default instrument height value for the station. If instrument height value for a gravity reading is zero, default value for its station is used.
[Note]Note

Columns in the CSV file can be presented in any order. Unrecognized columns are skipped. Column names are case-sensitive; e.g. data from the column named "Alt" will be imported as stations elevations while column named "alt" will be ignored.

[Note]Note

UTM coordinates, if present, are preferenced over geographic coordinates.

[Note]Note

If Instrument height value is imported for each station with geographic data, any value different from the default value must be manually entered into the Loop table for the corresponding station occupation.

[Tip]Tip

Instrument height values used for calculations for the particular station can be easily inspected by expanding the corresponding Station node in the Line table.

Similarly, all instrument heights used for a gravity loop can be printed for each station occupation in the Loop report. The Instrument heights checkbox must be selected in the Output and reporting tab of the Project properties window.

The CSV coordinates file can look like this example:

Station,Longitude,Latitude,X,Y,Elevation,Line
BASE,29.58821399,37.6643881,728300,4171800,1270,0
0,29.59081675,37.66527561,728526.9,4171904.84,1280.59,200
100,29.59042609,37.66444295,728494.99,4171811.48,1272.76,200
120,29.59033712,37.66427703,728487.65,4171792.85,1270.48,200
[Note]Note

Columns X and Y will be ignored in the above example. If you rename columns X nd Y to UTMX and UTMY, geographic coordinates will be ignored and UTM coordinates will be converted to latitude and longitude using project datum settings.

4.2.1.2. Import from the GNSS Solutions software

Blue Whale Processing Geophysical Software can import coordinates data from the file prepared from the Stations table in the Magellan GNSS Solutions software provided as an option by the manufacturer with some Ashtech, Thales and Magellan GNSS receivers.

To prepare the file for import, in the Workbook of your adjusted project in the GNSS Solutions software click the Points tab. Select the whole table by a click to the upper-left (blank) cell of the table. Right-click the table and select the "Copy" option. Open a blank text file in Notepad and paste the selected data into it. Save the Notepad txt file at the suitable location in your computer.

The prepared txt file should look like this:

Name	Description	Long	Lat	Ellips height	Status	Constraints	Surv_Horz_Conf	Surv_Height_Conf	Type	Warning
BASE		15° 17' 47.09059"E	50° 08' 09.01157"N	496.662	Adjusted	Horizontal & Vertical Fixed (3D)	0.000	0.000	Control Point	No
2001	 	15° 13' 48.81734"E	50° 07' 42.76530"N	474.735	Adjusted	No constraints	0.022	0.015	Logged Point	No
2002	 	15° 13' 26.49182"E	50° 09' 36.53375"N	413.180	Adjusted	No constraints	0.026	0.018	Logged Point	No
2003	 	15° 16' 21.78458"E	50° 12' 53.36935"N	433.376	Adjusted	No constraints	0.031	0.019	Logged Point	No
[Note]Note

Only stations with status "Adjusted" will be imported. Please adjust your network solution before making the import file.

[Important]Important

GNSS Solutions import txt file should contain stations from a single line only. In case your GNSS Solutions project contains stations from more than one line, prepare separate file for each line containing stations from the corresponding line only.

4.2.2. Import coordinates data into your project

Right-click your project icon in the Projects window and select the "Import coordinates" option:

Select data file prepared in the previous step and click Open. Coordinate data will be imported into appropriate lines/stations of your project.

[Note]Note

Please check the "Geodetic reference frame" and "Elevation datum" settings in the Project properties dialog whether correspond to your data. After import, all coordinates are transformed to the BlueWhaleProcessing internal reference, WGS-84 with ellipsoidal elevation datum. This means, that change of datum or reference frame does never influence any existing coordinates in the project.

[Tip]Tip

If your coordinates file does not contain "Line" column, right-click the icon of line into which you would like to import data instaed of the project icon. Data will be imported into the proper line. GNSS Solutions file does never contain line information.