Live Logger Data: Water Level Calculations

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDGE > EDGE Features >

Live Logger Data: Water Level Calculations

A new feature was added to EDGE 7.0, Live Logger Data. By using this feature, water levels at monitored wells can be automatically calculated based on Level Logger(s) and Baro Logger(s) readings.

 

Principle of Water Level Measurement with Level Loggers and Baro Loggers

 

"Leveloggers (L) measure the total pressure acting on a transducer at their zero point/sensor. The total pressure is caused by the column of water lying above the Levelogger pressure sensor AND the barometric (atmospheric) pressure acting on the water surface. To compensate for barometric pressure fluctuations and get true height of water column measurements (H), a Barologger (B) is required."

 

25248-Barologger

 

Equation:

 

Levelogger Reading (L) — Barologger Reading (B) = Height of Water Column (H)

 

Note: "Levelogger is rated for a specific submergence depth. The choice of model largely depends on the accuracy of the water level required and the submergence depth. The selection is based on the maximum anticipated water level fluctuation."

 

(source https://www.solinst.com/products/dataloggers-and-telemetry/3001-levelogger-series/operating-instructions/quick-start-guide/3001-quick-start-guide.pdf)

 

Transducer Field Data Collection EDGE Work Flow

 

The following diagram presents the work flow which includes the barometric pressure data stored in the database, the EDGE field data collection, and the submission of collected data into database.

 

25248-TransducerFieldDataCollection

EDGE Workflow

 

Step 1.  EDGE - Preload the Baro Loggers

(Start: Pre-load latest barometric pressure records from database in Figure 2 above)

 

Note: This action is performed every time, for each field event.

 

Go to Devices.

1.Select the instrument to be used (e.g. In-Situ_Level500)

2.Open File

 

25248-Devices

 

3.Select the appropriate file containing the Baro Logger data (e.g. Barologger.csv, see below)

 

25248-BarologgerFile

 

4.Save the EDD (e.g. EDD_loggerloc1.xlsx).

 

Note:  Make sure Live Data is enabled in EDGE Configuration.

 

25248-LiveDataEnabled

 

Step 2.  Create EDGE Field EDD Report in EQuIS

 

Note: This action is performed every time, for each field event.

 

1.Open EQuIS

2.Open EDP

3.Open the format pertinent to the build with the Live Logger

4.Load the EDD created during Step 1 (e.g. EDD_loggerloc1.xlsx)

5.Create and then Commit

6.The data will be uploaded in EQuIS

7.Make sure the library is available in EQuIS libraries (e.g. EarthSoft.Reports.Library.40338.dll)

8.Create EDGE Field EDD Report

 

25248_Report

 

Save report as EDD_Report... (e.g. EDGE_Report_12345.xlsx).

 

Step 3.  Configuring EDGE

 

Note: Step 3 is performed just once, the first time, while configuring EDGE

 

The necessary EDGE configuration can be below in Figure 7

To configure EDGE click on the 'Plugins' and check-mark the necessary forms, click 'Save' and 'Close'

Click on the EDGE marble (top left) and Select Show/Hide Tabs

Select the necessary forms to be shown and uncheck any unnecessary forms and click 'Ok'

On the WL Form select 'Setup' and select the fields shown in Figure 7 (below)

 

There are several enumerations to take note of: baroTimeOffset; live_connect_address

The baroTimeOffset enumeration needs to match to the proper date to be able to collect the most recent barometric pressure readings from the Weather Station

The default time setting is set to 3 hours but can be at a maximum of 999 hours. Changing the hours allows the user to expand or minimize the search range for current barometric data but the most current data will always be selected

The hours value checks for data within a ± range (e.g. ±3 hours = 6 hour overall range)

Under the live_connect_address enumeration enter the web address required to connect to the weather station to receive the latest barometric pressure data

For further help with configuration and enumerations please click here: Configuration and Enumerations.

 

25248-WLFormWithSections

 

Step 4.  Live Connect

 

Note: This action is performed every time, for each field event.

 

Go to Devices

Load logger files

Click Live Connect

When opening, the user is prompted to enter its username and password; the password may also be saved to the EDGE build (encrypted)

Make sure you are connected to the internet. Real-time Barometric data is received from the weather station selected in the report.

 

Live Connect Feature

Live Connect Feature

Note: New Feature When Loading Logger Files

 

Square Brackets

Square Brackets

 

If the file name including location has square/parenthesis brackets, sys_loc_code comes from the file name and the log name (B-33 random in Figure 8 above) is ignored (also see Figure 9 below)

If the file name including location has no square/parenthesis brackets, sys_loc_code comes from the log name

 

Brackets

Brackets

 

Step 5.  Calculation in the WL Form (work within EDGE)

 

Note: Step 5 is performed every time, for each field event.

 

Load the EDD report created in Step 2 (e.g. EDGE_Report_12345.xlsx)

Load the Logger files and press Live Connect

At this point the WL Form is set-up and ready

Create a New Record

When creating a Water Level record, the following fields that are automatically filled based on the location associated with the record:

 When using the BaroLogger Troll:

         date_of_deployment

         bp_time_of_calibration

         bp_current

         logger_id

 When using the Weather Station:

         bp_current

 

These values are based on the Live_Logger_Ref (historical) values

 

The Real-Time DTW [dtw_realtime] value will auto-populate from Transducer in the WL Form [Waterlevel_v1]

At this point it will calculate the Corrected depth to water [corrected_dtw] value based on the Baro Logger data (Ref. Equation 1 below)

If no Baro Logger data exists it will default to the Real-Time Depth to Water [dtw_realtime] value

Now enter the Manual DTW (ft) [water_level_depth] value

Water Level Depth vs. Corrected Depth Check calculates the absolute difference value between the of Water Level Depth [water_level_depth] and Corrected DTW [corrected_dtw]

If the absolute difference value is greater than the tolerance value it will automatically flag and in the Live_Logger_Data_Header will show "WARN"

If "WARN" is visible, no data from the location will be loaded to the EDP (Ref. Figure 10 and 11)

The tolerance value comes from the Live_Logger_Ref from the EDD created earlier. The user can set the tolerance value accordingly in the EDGE Field EDD Report

And save the EDD as... (e.g. EDGE_Report_12345_complete.xlsx).

 

Calculations

 

Before proceeding, a conversion between feet and PSI is necessary, if Corrected DTW [corrected_dtw] = depth_unit is set to feet.  

 

1 foot = 0.4329 PSI, and 1 PSI = 2.31 feet

 

Equation 1:

[corrected_dtw] = [water_level_depth] - [bp_time_of_calibration] + [bp_current]

 

Equation 2:

abs = |[water_level_depth] - [corrected_dtw]|

Notes:

To match sys_loc_code, in Live_Logger_Ref tab, the value parameter needs to be set up to WS_BAROP

oCondition for flagging series - in Live_Logger_Ref tab, the value parameter needs to be set up to FLAG_SERIES for value1 which is Level Depth To Water

 

Step 6. Commit to database

 

Note: Step 6 is performed every time, after each field event

 

Save the EDD, then load to EDP. For any field has the warning "WARN" in Live_Logger_Data_Header, the corresponding data will not show in the Live_Logger_Data

Create - during the Create step in EDP, the groundwater elevation is calculated as per Equation 3 only if the dtw exists. If "WARN" in datum_qualifier_4, groundwater elevation will not be calculated.

 

Equation 3:

[Groundwater Elevation (corrected)] = [Well Measuring Point Elevation] - ([Transducer Depth to Water] – [Barometric Pressure at Time of Calibration (in feet)] + [Current Barometric Pressure (in feet)])

 

where

 

[Well Measuring Point Elevation] and [Barometric Pressure at time of Calibration] is from Live_Logger_Ref in EDD, based on sys_loc_code

[Transducer Depth to Water] is from the current logger row

[Current Barometric Pressure (in feet)] closest to the date

 

25248-Warn

 

25248-LevelDepthtoWater

 

Commit - data committed to database (DB)

 

25248-ColumnHeader