thosmos / riverdb

A river science data management system in Clojure
https://riverdb.org
GNU Affero General Public License v3.0
14 stars 3 forks source link

SSI Added Parameters #40

Closed SierraStreamsInstitute-Lab closed 1 year ago

SierraStreamsInstitute-Lab commented 2 years ago

We are now measuring Silica (SiO2, in mg/L) and would like to enter this data into RiverDB.

thosmos commented 1 year ago

A Parameter is composed of 5 elements: analyte, matrix, unit, method, & fraction. Silica is the analyte, and mg/L is the unit. What are the matrix, method, & fraction? You can look at the parameter dropdown in the parameter editor for examples. With those 5 bits, I can add it as a parameter option to the dropdown.

Screen Shot 2023-02-05 at 9 52 52 PM
thosmos commented 1 year ago

It looks like we have some of the bits of info in the database already: analyte Silica, and method SM 4500-Si D Silica (Dissolved):Molybdosilicate method. So if that method matches the method you're using, then I can create a parameter for it. However, if it's a different method, then I'll need some details about it in order to to add that method to the DB.

For example, this is the data we have related to the above referenced method:

{:methodlookup/Type1 "Lab",
 :methodlookup/Active true,
 :methodlookup/MethodDescr "Silica (Dissolved):Molybdosilicate method",
 :methodlookup/MethodName "SM 4500-Si D",
 :methodlookup/MethodOnFile "Standard Methods Manual (MPSL)"}
SierraStreamsInstitute-Lab commented 1 year ago

SM 4500-Si D looks like the low range method, and we're using the high range method. I think it would be: Silica (Dissolved) / samplewater / mg/L / Method 8105 / None The method number comes from the manufacturer of the Hach device we use.

thosmos commented 1 year ago

OK, that's been added to the constituent list, so it can be used to create a parameter, for example:

Screen Shot 2023-02-15 at 2 12 36 AM