How to Upload Data for Storage and Analysis on Wellntel Analytics Dashboard

Manual Measurements Vs Wellntel on Hydrograph

As of January 2020, any type of water information (with a time-stamp) can be stored permanently and can be integrated and analyzed in Wellntel’s Analytics Dashboard (AD). The capability is available as an option to Analytics Dashboard subscribers and Curators.

  • Subscribers and Curators can upload data manually to the Cloud using new upload tools on AD,
  • or, when infrastructure allows, data from connected devices, management software or databases can be automatically posted using Wellntel’s new PUT API (Application Programming Interface.)

* In both cases, data are permanently and securely stored, which enables key AD functions like grouping.

The focus here will be on how to manually upload data using new tools on AD. For more information about posting data to the Cloud using Wellntel’s API please contact Wellntel Tech Support.

To get started, contact Wellntel Tech Support or the Science and Information Manager to briefly let us know what type of data you would like to upload and the relationship these data have with your Wellntel groundwater-monitoring network. Using this information, a Wellntel technician will then set up your upload account for payment, issue security keys, provide software and instructions for your local machine(s) key, and help set up your network geographically and in AD. The process can be done in one day or less, and once complete, you can upload as often and as much as your network requires.

Once your upload account is established, you will see a new feature set on your AD: “Upload” where you can upload data files that include the data to be stored in the Cloud and accessed within AD.

Input files are required to be in .csv format. When a file is loaded, a column header matching tool will appear that will allow you to select and match the  input file fields with those required by the Wellntel database. These fields include:

Field NameDescription
Sensor_idThe integer id number assigned to the reservoir specific measurement during location and hardware registration. 
This can be found on the “Locations” feature set below the Wellntel system locations once registration is complete.
Gateway_idThe integer id number assigned to the gateway assigned to your account for uploading data on AD during hardware registration. 
This can be found on the “Locations” feature set below the Wellntel system locations once registration is complete.
TimestampThe measurement time and date in ISO8601 format including the time offset from UTC (e.g. 2020-03-10T12:19:00-0500)
ValueThe decimal number for the measurement value or data point.
Data_type_idThe integer number for the data type of the value.
The list of Wellntel data types and their id numbers can be found on the Upload feature set once location and hardware registration is complete.

If the fields shown in this table are not included in the input .csv file, the data will not be uploaded to the database. Although field names can be anything, and then matched and updated with this tool, it is good practice to use the field names provided to eliminate mismatches or errors during upload.

Once a data file is input and field names are matched correctly, click the “Post to Database” button to upload these data to the Wellntel database. If there are any issues with uploading, you will be given a descriptive error message. If everything goes well, you will get a confirmation message with the number of readings posted to the database. Please contact Wellntel Tech Support for assistance if you are unable to upload data.

Groundwater elevation and depth to water measurements uploaded using this new feature will be accessible on the Hydrographs feature set after reloading AD. Below is an example manual measurements of the depth to water at two wells plotted alongside Wellntel-sensor-measured depth to water. Although these two types of measurements were not necessarily collected at the same time, bringing historical data into the picture when analyzing trends and patterns identified with continuous sensors can be extremely valuable for context and understanding.

For more information about the Wellntel Analytics Dashboard and Water Data Management tools, see the Wellntel Operating Manual.

Note: Currently Wellntel supports a number of different data types, however, if you don’t see the data type needed, we would be happy to add a new one to the list. Development of unique and appropriate analytics and visualizations for new data types may be project dependent, or may take some time to roll out as they fit into our ongoing AD development schedule.