SURVEY FILE IMPORT
  • 29 Sep 2023
  • 5 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

SURVEY FILE IMPORT

  • Dark
    Light
  • PDF

Article summary

Use the Survey file import keyconvert form to view the survey data in the system and to import survey files into the system. Surveys carried out in the field can be imported directly into the system.

Importing a survey file

  1. In the main toolbar, click Survey file import convert.
  2. Click Choose file to select the file for reading.
  3. Select the right Code set used in the survey file.
  4. Select the Mapping configuration that is appropriate for the survey file structure.
  5. Select the correct input SRS for the survey file.
  • KKJ (such as KKJ / Finland zone 1)
  • Shortened GK (such as ETRS89 / ETRS-GK19FIN (EPSG:3126))
  • Standard GK (2010) (such as ETRS89 / ETRS-GK19FIN 2010 (EPSG:3873))
  • local coordinate systems (such as ANC Finland)
  • WGS (such as WGS84 (EPSG:4326))
  1. Select Operation: Create objects, Write geometries, or Also create objects. If you select Create objects, the mapped ducts, manholes, valves, and so on, are created on the map. The survey geometries include point and line objects, and the Surveys layer is activated in the Layer selection when these are applied.
  2. Select the Combine points with the same kind code checkbox to form lines based on consecutive points.
  3. Select the Combine even if point numbers are not consecutive checkbox to join lines with non-consecutive point numbers.
  4. Fill in the rest of the fields as necessary.
  5. Click Convert convert in the form’s toolbar. The survey file is automatically saved after the conversion.

Any errors and warnings are displayed on the list. Usually, these errors are related to the structure of the survey file, and they are displayed to help find the possible errors in the file.

Survey results

Click Show results table to view the survey objects in a list. In addition, the form will open automatically, for example, when you browse through the survey items, and the information on the form is updated in accordance with the survey that is being viewed.

The form shows what types of objects were documented in the imported survey. The list has seven columns by default: Type, Kind code, Code description, Geometry, Point number, Line number, and Length. The columns displayed depend on the survey setting that is applied. The objects for which KeyAqua network objects have already been created are displayed in the list with a green background.

The imported survey file results can be located or deleted, or they can be used to create individual objects. Update the Results of the Survey list by clicking Refresh refresh.

The Show menu includes the following options for displaying the Results of the Survey list: All objects, Created objects, and Not created objects.

Creating, locating, and deleting network objects

To create KeyAqua objects with the type defined in the Type column, select them on the list and click Create objects accept. The rows of created objects are marked in green.

If you want to create different types of items on a map from survey objects, first hold down the Shift key and click the left mouse button to select similar items from the list (Line or Point). Then click Create objects accept and select the correct Object type in the Create objects window that opens. For line objects, water and sewer duct options are available, and types such as manhole and valve are available for point objects. Click Create to display the survey items on the map.

To locate a single survey geometry, select the correct object row and click Locate arrow_in. To delete a single survey geometry, click Delete object cross when the geometry in question has been selected. The selected geometry will be displayed on the list in blue.

Editing network objects

  1. Select the created object (green) that you want to edit.
  2. In the toolbar at the bottom, select Edit table_link, or click the right mouse button and select Edit in the menu.
  3. The form for the created network object is displayed. For example, if the object’s type is Sewer duct, the object is opened on the Sewer duct form.

Editing the geometry of survey objects

You can view survey objects on the Survey Line string and Survey Point forms that are available in the menu for Survey file import convert. The main purpose of these forms is to provide tools for editing the location and geometry of the objects. You cannot use forms to create new survey objects.

  1. On the list, select the object whose geometry you want to edit.
  2. In the context menu, click Edit geometry chart_line, or select Edit geometrychart_line in the toolbar at the bottom.
  3. Depending on the geometry type of the object, the Survey Point or Survey Line string form is displayed.

Survey results report

You can create an Excel report on the survey results, including the applicable codes, their number, and the total length per code. Create a report by clicking Survey results report in the menu for the Reports button.

Survey file description

Admin users can define various Survey settings for survey files.

T3 PIH format

The so-called GT format (T3 PIH) is discussed next. The GT file is a text file that consists of columns. Each row has 7 or 8 columns. These are called T1–T8. Columns are separated using space or tabulation characters. The data in a column must not include space or tabulation characters and, apart from column T8, the column cells cannot be empty.

In the figure below, an example of a land survey file. The survey file includes a sewer duct (1100), two different types of water ducts (1129 and 1134), and two water duct shut-off valves (8675), as shown in the code set used on the next page.

TIP: PIH = North, East and Height

T8 data model:

  • T1 - Surface code
  • T2 - Line code
  • T3 - Survey code
  • T4 - Point number
  • T5 - North coordinate
  • T6 - East coordinate
  • T7 - Height (Z)
  • T8 - Comments

The file has information on one coordinate point on each row. The first four numbers are the point identifiers T1...T4, and T3 is typically the survey code. Survey code refers to a “key” that is used to link the description and property values to a certain coordinate point. The applied code set defines the kind codes that are used in a land survey file. These can be edited via the admin user interface.

The line code T2 is used to separate various lines. For point objects, T2 is 0.

The identifier T4 is usually the point number defining the order in which points have been measured.

Identifiers are followed by coordinate values. Coordinates can be in the order North-East-Height or East-North-Height (this can be defined on the form).

In addition to the coordinate values (T5–T7), a row can include a comment or other information related to the object (T8). 

The following code set is applied to the example:

T11 PIH format

The GT file is a text file that consists of the same eight columns as the T8 format and has additional three columns which are Depth, Location accuracy and Height accuracy. Each row has total of 11 columns. Columns are separated using space or tabulation characters. The data in a column must not include space or tabulation characters and, apart from column T11, the column cells cannot be empty.

To be able to use this format, select Keyaqua default code 2022 from the Code set menu.

T11 data model:

  • T1 - Surface code
  • T2 - Line code
  • T3 - Survey code
  • T4 - Point number
  • T5 - North coordinate
  • T6 - East coordinate
  • T7 - Height (Z)
  • T8 - Depth (from the ground level or from the open trench)
  • T9 - Location accuracy
  • T10 - Height accuracy
  • T11 - Comments

Was this article helpful?