Hello,
For each WWTPs we got from the wastewater agencies the maximal flow rate the WWTPs can accept and treat. We also have the minimal flow rate which is the flow rate which should be observed when there is no rain so the flow rate due only to the discharges by the population. These minimal flows are calculated via different parameters by the wastewater agencies.
In which table should we report these data?
Thank you.
Hi there,
Great question! Site characteristic data like this sounds like a site measure, so it would actually be stored in the measures table. There’s a field in the measures table - specimen - that specifies whether a measure is at the level of a sample, a site, or a population (for clinical data).
So for example, the measures table with both sample measures and site measures (as you describe above) might look like this (abridged columns):
| Report ID | … | Sample ID | … | Polygon ID | Site ID | Dataset ID | … | Compartment | Specimen | … | Measure | Value | Unit | Aggregation | … |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| measRepX0 | … | samExam022 | … | sewerShedEx | wwwtpEx | wwBelgium | … | water | sample | … | covN1 | 0.00243 | gc/mL | mean | … |
| measRepX1 | … | samExam023 | … | sewerShedEx | wwwtpEx | wwBelgium | … | water | sample | … | covN1 | 0.00036 | gc/mL | mean | … |
| siteRepX | … | NA | … | sewerShedEx | wwwtpEx | wwBelgium | … | water | site | … | maxFlow | 485.36 | ML/day | single | … |
| siteRepY | … | NA | … | sewerShedEx | wwwtpEx | wwBelgium | … | water | site | … | minFlow | 50.92 | ML/day | single | … |
| measRepX5 | … | samExam203 | … | sewerShedEx | wwwtpEx | wwBelgium | … | water | sample | … | covE | 0.00856 | gc/mL | mean | … |
Does that make sense?
Hi,
Thanks for your answer.
Yes indeed it makes sense. It answered my question
Kind regards
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.