Project

General

Profile

Feature #15270

Record well sensor data (mqtt)

Added by Philippe May 3 months ago. Updated 3 months ago.

Status:
New
Priority:
Normal
Start date:
22/11/2023
Due date:
% Done:

0%

Close

Description

Ram () has set up a "gateway" to collect well water sensor (to start with).

The mqtt messages arrive directly on the server. See:

Sensor data published by the GW to this topic "/v1/telemetry" in JSON format. See example below.

{
  "Name":"WSN-0012f82e",
  "MacId":"00:12:f8:2e",
  "RSSI":-19,
  "LQI":13,
  "0x78":"2.97",
  "0x33":"215.00",
  "0x58":"0.40",
  "Sequence_number":64
}

Alok well dashboard.png View (117 KB) Giulio Di Anastasio, 23/11/2023 12:44

Kindergarten dashboard.png View (119 KB) Giulio Di Anastasio, 23/11/2023 12:44

16017
16018

History

#1 Updated by Philippe May 3 months ago

  • Assignee changed from Philippe May to Giulio Di Anastasio

Giulio, which well (id) is the first sensor in?

#2 Updated by Giulio Di Anastasio 3 months ago

16017
16018

The first sensor has been installed in Alok's well, well id is 119, MAC id is 00:12:f8:2e

Then another sensor has been installed at Kindergarten, well id is 238, MAC id is 00:12:df:f4

See attached screenshots

#3 Updated by Philippe May 3 months ago

Done most of the job, but i have a doubt, and i must be missing something: how to compute the level from the top of the well?

For example we get such value: 21545 (mm), which i remember Ram saying it's the height of the column of water above the probe. But we don't know at which depth is the probe. It has to de with the calibration linear function. @giulio, can you enlighten me?

#4 Updated by Giulio Di Anastasio 3 months ago

The depth of the sensor is known, as well as the elevation of the ground and that of top of casing.
The depth of the sensor is decided upfront, and it is different for each well, as it depends on local setup of the well. The sensor is installed at that depth (example: 45 meters from top of casing), then knowing the height of the column of water above the sensor it is wasy to calculate the depth of water.
So, before we set up everything in the database for this, we still need to test the good functioning of the setup: for instance, day before yesterday the sensor in Alok’s well suddenly stopped transmitting. Vijai went and replaced the battery in the transmitting device, and replaced the sensor. But we still don’t know what happened, and that requires some observation.
The best is that we get from Vijai the depth of the sensor even if it temporary, and then finalize it once we have understood what is reLly going on inside the well.
I hope this was clear, of course itnis better to meet in person and clarify all these points, and raise some more…
Cheers

#5 Updated by Philippe May 3 months ago

For sensors out of the ICITI (Aurinoco) network, we have several options (order of priority/easiness), discussed with Ram:

  1. Aurinoco forwards MQTT traffic coming to gis.avcsr.org public IP address to CSR network. I created a ticket for that: https://redmine.auroville.org.in/issues/15280
  2. Get the remote devices to use MQTT over websocket, which seems to be a common solution for a setup like ours (private LAN)
  3. Use a public MQTT "broker", such as https://mqtthq.com/
  4. VPN (software or using dedicated hardware box)
  5. Point to point radio link between remote location (Auro Orchard) and CSR (involved setting up some hardware)

Also available in: Atom PDF