Pause - Data upload and card flexibility

[Caesarh97]

Hi Eric,

I'm very interested to understand how we can improve our dashboard and accommodate as many water quality parameters as possible. Very few sensors collect the five metrics that we currently have available on our dashboard card. I'd like to explore what we can do to make a flexible feature and what this would require from a development standpoint.

Normal water quality dashboard card (Sonde Data)
WQ: Check csv file “water_quality_data.csv”. When a user uploads a file: 1. Parse the headers dynamically instead of enforcing a strict template. 2. Present the user with a dropdown or selection UI where they can: Choose the correct unit for each parameter (e.g., “Salinity → PSU”, “Turbidity → NTU”). 3. Store this mapping in the database for future uploads from the same user/site.
water_quality_data.csv

Water quality with thresholds (HUI)
Please see the Excel file "flexible HUI card upload.xlsx". What could be interesting would be to build a new flexible card that would fit any new water quality group in the world. My idea here is that metrics, measurements, and thresholds would be variables. So, each new group can submit 4 metrics and their measurements and the thresholds for each metric, and their card will be created.

For example, Column 1 would populate the top left of the dashboard card (users would rename “Column 1” to the correct metric such as “turbidity”). Then the measurement will be specified in the measurement section, and then the threshold in the threshold section.

This is just some brainstorming. Do you think it has some potential, or is it too much development?
flexible HUI card upload.xlsx

Integrate data via API
What's possible? Would it require a lot of dev time? Here's an example of temperature data that we can publish. Data is real-time, but I currently have to upload it as CSV files manually. SimCosta data

[Caesarh97]

Update - We will pause this project and maybe start it in a few months, potentially when more water quality data and acoustics are available in the Sofar Spotter. Pete is interested in pursuing this idea, but not at this moment.