Delta Watch: Importing sensor definitions

Need to create many sensor definitions at once?

This article explains how simple this task is, leaving you with time left for other things.

Log in or sign up for myTopcon to view this page:

Delta Watch: Importing sensor definitions

Introduction

When using Delta Watch to import and visualize data from other sources than geodetic observations, these sensors always need to be created in the Sensor management table section of the Point and limit management module. Whether this sensor represents the extra Delta Link or total station information, or if it is a data source from a geotechnical sensor such as a piezometer or tilt sensor, before the data can be imported and processed, an entry needs to be added to the Sensor management table.

If only a handful of sensors need to be added at any one time, then this is easiest done using the Add function within Delta Watch to add each sensor individually.

However, if a big number of sensors needs to be created, and especially if all these sensors have (local) map and/or WGS84 coordinates, then it is simpler to create an import file to import all of them at once.

This article describes the import data file format to do exactly this.

Import file (*.CSV) description

Using an import file has the benefit of:

  • Importing many sensors quickly
  • Specifying custom symbols for map views
  • Specifying coordinates for visualization, both project coordinates and WGS84 for Delta Live!
  • Assigning external names directly at import

The file can be created in any program as long as it can be saved in an ASCII CSV format with a layout and content as described below.

 

Filename

The filename does not really matter that much, as long as it ends with the extension .CSV.

 

File format

  • Has got a single header line
  • Uses a semicolon as column separator
  • Uses CRLF as EOL character

The table below describes the order of the data columns for the file. All columns are required, but some might be left empty if no value is known.

Field Description Format
Name* Unique name for this sensor. Name is case sensitive. This name will be used for configuration throughout Delta Watch. String
Externalname Alternative name, used for charting/reporting Delta Live! String
Active* True/False field indicating if the sensor is still active Y or N
SerialNumber Certain sensor types are linked based on Serial number, such as Delta Link units or total station. String
X (local) Northing coordinate for positioning on maps within Delta Watch Float
Y (local) Easting coordinate for positioning on maps within Delta Watch Float
Z (local) Elevation value for reference only within Delta Watch Float
Type* Type ID, see below table for details Long
SymbolID ID of the symbol to be used when visualizing the sensors on maps and overviews in both Delta Watch and Delta Live! See overview table farther down. Long
ScaleFactor* Scale factor of the symbol to customize how big the symbol shows on maps. Use 1.0 as default. Float
Comment Freely usable single line field String
WGS84Latitude WGS84 Latitude for visualization in Delta Live! Degrees
WGS84Longitude WGS84 Longitude for visualization in Delta Live! Degrees

* These columns need to have a value!

Example header line

Name;ExternalName;Active;SerialNumber;X;Y;Z;Type;SymbolID;ScaleFactor;Comment;WGS84Latitude;WGS84Longitude

 

Table with the sensor TypeIDs. Any other ID is not valid and might result in rejection of the sensor.

TypeID Type Name Description Data Source
2 Inclinometer Geotechnical sensor used by the Inclinometer module Various
4 Extensometer Geotechnical sensor used by the Extensometer module Various
10 Meteorological Placeholder for weather station data, primarily used for THP sensors connected to a Delta Link unit ENV file as created by Delta Link
11 Tilt meter Geotechnical sensor used in the Tilt meter module Various
15 Water level Geotechnical sensor used in the Water level module Various
16 Delta Link Placeholder for health and status info of the Delta Link unit OBS*.DAT file from Delta Link
17 Total station Placeholder for total station performance and statistics data *.STNI file as created by DeltaLog

 

 The below table shows all available symbols and their ID:

Importing the file

Once the file is created, it can be imported in Delta Watch.

  1. Navigate to Administration > Point and limit managementSensor management.
  2. Click on the import icon [import].
  3. Select the file to import. Delta Watch will process the file and report how many sensors have been imported.
  4. Save the new additions by clicking on Apply.
  5. Make individual channel adjustments if required.