Geoida
Help

Import and Export Formats


Geoida supports a range of import and export formats for both point and observation data:

Some of the formats offered for observation import to the e-Data, Traverse and Least Squares Network Adjustment options are also available for the import of point data in the Import option, however the discussion that follows will be primarily related to the import and export of observation data.



Sections below:




  Export

Geoida provides three formats for the export of observation data:

Format Type Options Purpose Observation
State 		Import
Again
Standard Extract
  • e-Data
  • Traverse
 Merging data sets; editing; re-processing Reduced Yes
CSV Extract
  • Traverse
 Export only Reduced No
CSV Raw Export
  • Traverse
  • Least Squares Network Adjustment
 Export Raw Yes

Table 1: Formats used in Geoida for the export of observation data

Extract files

An Extract file may be created when processing an observation file or data set with the e-Data or Traverse options - any control survey, traverse or network observations detected within the data will be "extracted" from the data set and subjected to a process of analysis and optimisation. During this procedure, distances are balanced where possible over forward and reverse lines and reduced to horizontal and vertical components, and repeated horizontal angles are compiled and meaned. These optimised observations are written to the Extract file.

There are two types of Extract file, the Standard Extract file and the CSV Extract file:

The main advantage of the CSV format over the Standard format is that the CSV Extract file is emminently the more suitable for export of observation data, while the Standard Extract file is intended for use within Geoida only and, if necessary, is easier to edit for that purpose.

Note that both Extract file formats contain horizontal distances and vertical components reduced from slope distance and vertical angle observations and do not contain raw distance observations. If raw observations are required for export to external applications, selection of the CSV Raw Format for export will be more appropriate - refer to Import and Export Formats.

For more detail about Geoida Extract files refer to the Extract file topic.


CSV Raw Export

The Geoida Raw Export format is a CSV format used for the export of raw observations from either the Traverse or Least Squares Network Adjustment options. Observations are exported as-is in 3D form and may contain slope distance and vertical (zenith) angle observations, heights of instrument and target, height differences, as well as the usual horizontal angle, direction or azimuth observations.

The structure of the Raw Export format is defined in the header line of the export file - when imported to a spreadsheet or similar application the header line will identify the fields and permit the data to be accurately loaded in column format. Do not change the layout of the file.


<At>,<From>,<To>,<Azimuth>,<HAngle>,<VAngle>,<ZAngle>,<SDist>, ...
... <HDist>,<VDist>,<HI>,<HT>,<ToHt>,<Fix>,<Code>,<SDev>,<centIns>, ...
... <centTgt>,<disConst>,<PPM>,<coefRef>,<approxDis>,<levelBays>
1,3,2,,266.14243,,,,,,,,,,,1.7,0.001,0.001,,,,,
2,3,1,,74.33097,,,,,,,,,,,1.7,0.001,0.001,,,,,
3,2,4,,236.45333,,,,,,,,,,,1.7,0.001,0.001,,,,,
3,2,1,,348.18413,,,,,,,,,,,1.7,0.001,0.001,,,,,
4,6,3,,186.59157,,,,,,,,,,,1.7,0.001,0.001,,,,,
4,6,5,,214.18443,,,,,,,,,,,1.7,0.001,0.001,,,,,
5,6,4,,18.07090,,,,,,,,,,,1.7,0.001,0.001,,,,,
6,4,5,,16.11310,,,,,,,,,,,1.7,0.001,0.001,,,,,
3,,2,,,,,,,3.561,,,,,,0.007,0.000,0.000,,,,566.5,1
5,,6,,,,,,,0.565,,,,,,0.007,0.000,0.000,,,,1012.1,1
5,,4,,,,,,,3.332,,,,,,0.007,0.000,0.000,,,,500.7,1
1,,3,,,,,,,-1.885,,,,,,0.007,0.000,0.000,,,,547.2,1
4,,6,,,,,,,-2.781,,,,,,0.007,0.000,0.000,,,,558.4,1
3,,4,,,,,,,3.188,,,,,,0.007,0.000,0.000,,,,666.5,1
1,,3,,,,,547.222,,,1.480,1.700,,,,,0.000,0.000,0.002,1.0,,,
3,,2,,,,,566.518,,,1.698,1.660,,,,,0.000,0.000,0.002,1.0,,,
3,,4,,,,,666.493,,,1.698,1.630,,,,,0.000,0.000,0.002,1.0,,,
4,,5,,,,,500.700,,,1.629,1.633,,,,,0.000,0.000,0.002,1.0,,,
4,,6,,,,,558.406,,,1.629,1.632,,,,,0.000,0.000,0.002,1.0,,,
5,,6,,,,,1012.101,,,1.635,1.633,,,,,0.000,0.000,0.002,1.0,,,

Figure 1: Sample Raw Export file from 'Least Squares Network Adjustment' option

When exported from the Traverse option, multiple observation types may be contained within one line within the file depending on how the data has been entered, whereas when exported from the Least Squares Network Adjustment option, observation types will be written separately to the file as categorised by the observation tabs within the form as in the example above.

Note: Only terrestrial observations are exported from the Least Squares Network Adjustment option - GNSS observations are not exported.

The Raw Export format is ideal for the export of raw 3D observation data without the application of any corrections or reductions; it is identical to the Foreign CSV format for observation import considered in the Import section below.

Return to Section Titles



  Import

Geoida provides a range of formats for the import of point coordinate data via the Import option, and for the import of observation data to the e-Data, Traverse, and Least Squares Network Adjustment options for further processing. The use of most data formats is straight forward, but the formats discussed below are those for which some additional explanation is necessary.


Foreign CSV

General information - Two different foreign CSV formats are used for point and observation import and each will be discussed in further detail below, however Geoida otherwise treats them identically and observes the following principles with which any CSV files intended for import must comply:

Converted from CHM to HTML with chm2web Standard 2.85 (unicode)