Adding devices and updating device names

[SierraStreamsInstitute-Lab]

We are moving to a more detailed device names, which should address the redundancy of the current naming system in RiverDB (ie YSI devices measure both dissolved oxygen and conductivity).

Our conductivity meters would be EC-SSI-1, EC-SSI-2, etc.

We also need to add new devices for silica, bacteria, phosphate and nitrate (if we move them out of the lab section).

I am wondering whether, if we were to make these fixes (update device names, do turbidity medians, etc.), could we then delete all of our data currently in RiverDB and re-upload? Because the find and replace function in Excel would be a lot faster than doing a lot of these things manually. Thanks for your thoughts!

[thosmos]

Yes I think re-uploading would be faster and better

[SierraStreamsInstitute-Lab]

OK. So I just need to get you all of our updated device names to repopulate those lists?

[thosmos]

Yes and or i need to get the device editor working well enough for you to be able to do it. T

…

On Wed, Feb 15, 2023 at 10:38 AM SierraStreamsInstitute-Lab < ***@***.***> wrote: OK. So I just need to get you all of our updated device names to repopulate those lists? — Reply to this email directly, view it on GitHub <#44 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAEXVZTTVT3GK6PUGJPFK5LWXUPARANCNFSM6AAAAAAUXC2NHM> . You are receiving this because you commented.Message ID: ***@***.***>

[SierraStreamsInstitute-Lab]

I have our new device names drafted. Our version includes the ID number as part of the overall device ID, but that can obviously be split out if it's easier to keep with that convention in RiverDB. I have also updated our site codes to something much simpler and more informative (I think).
Please let me know what you think on both tabs.
RiverDB updates - devices and sites.xlsx

[SierraStreamsInstitute-Lab]

I'm also seeing that data pulled from RiverDB does not have site codes pre-2021. Do you know if that's accurate? Did we just not used to use them? Or is it another potential issue with the data downloader?

[thosmos]

The pre-2021 data was just test data. I think the best approach is to start over from scratch, especially because you have a few parameters that have been de-activated, etc.