ODM2 / ODM2DataSharingPortal

A Python-Django web application enabling users to upload, share, and display data from their environmental monitoring sites via the app's ODM2 database. Data can either be automatically streamed from Internet of Things (IoT) devices, manually uploaded via CSV files, or manually entered into forms.
BSD 3-Clause "New" or "Revised" License
31 stars 8 forks source link

Inconsistent display of multiple datapoints at one timestamp #664

Open mbarneytu opened 1 year ago

mbarneytu commented 1 year ago

We had a case where the code for one EnviroDIY site was accidentally loaded onto Mayfly boards for 2 different sites. Once powered on, both Mayfly boards sent a point to MMW with the same timestamp.

The problem is that the duplicate points display when you click "View Data Table" for a variable, but they do not display in either a downloaded CSV file nor in TSV.

This inconsistency creates confusion during troubleshooting, such as in our case, where Site 1 had data, but Site 2 did not (because its data were being sent to Site 1's page). Example: See data for 2023-07-02 06:30:00 for this site: https://monitormywatershed.org/sites/EFCR-AboveSilver/

Two datapoints are displayed for each timestamp in "View Data Table": image

Only a single datapoint is displayed for each timestamp in a downloaded CSV.