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.
The filename does not really matter that much, as long as it ends with the extension .CSV.
- 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.
|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
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.
- Navigate to Administration > Point and limit management > Sensor management.
- Click on the import icon .
- Select the file to import. Delta Watch will process the file and report how many sensors have been imported.
- Save the new additions by clicking on Apply.
- Make individual channel adjustments if required.