I'm a project leader in a Water Supply Public Organization in Argentina. We supply water to farms and orchards over a complex canal network that flows from the rivers that come from the mountains to the final user in a house, farm, orchard, potabilization plant, etc.
Over this network we have different technologies measure the water flow and send the values to a centralized server.
In this server we collect, parse and insert data into a relational database, simulating a time series. The data finish in a table, one per point that we collect, with this structure. ID | SENSOR | TIME | VALUE