swimdrinkfish / opendata Goto Github PK

MinItems property for records Array does not allow for a schema compliant way to show that no records have been returned. This could happen when working with APIs, and there are no records responsive to a query.

This violates spec:
{ "$schema": "https://raw.githubusercontent.com/swimdrinkfish/opendata/master/v1.0.1/schema.json#", "documentTime": "2020-09-02T18:33:28.095921+00:00", "records": [] }

One of the fields in the data is an advisory, which is a boolean based on the local water quality standard.

It's not exactly clear to me how this will be determined — would it be done by the user uploading the data? Will there also be an open data specification for the local water quality standards by the cities / municipalities?

When we created the method code list for methods used to enumerate sample results we anticipated that, as new methods become available, the list would be updated. We invite everyone to review the list of methods and to contribute any we may have missed.
For example, we recently added two qPCR methods for E.coli: the EPA's draft Method C, and BioGX

Method 701.0 for microcystin should be added to Cyanobacteria and toxins detection methods

This method is used for the determination of total (extracellular and intracellular) microcystins –
ADDA in surface water, ground water and finished drinking water.
Reporting Limit (RL): 0.30 µg/L

https://epa.ohio.gov/Portals/28/documents/labcert/Ohio%20EPA%20DES%20701.0%20Version%202.2.pdf

Add new multitube fermentation method ASTM D6503 - 99 (Idexx Enterolert). This is not an EPA method, rather an ASTM method.

For future extendability, it might be beneficial for sample to be an array (to have multiple samples). Some locations may take numerous samples and search for different substances. For example, extending the use to include a turbidity reading.

Example snippet:

"substance": "clarity",
"method": "1337_turbidity_disk",
"units": "m",
"result": 1.5

Investigate the possibility of adding a “no status available” update to the standard, thus allowing “no data” indicators. This would let monitoring authorities and labs indicate that there have been issues with sample data collection and/or decisions to skip collection for various reasons.

We presently depend on “no status is no status”, which effectively means that if data isn’t published it’s not available. The problem is that this requires (for example) a day to end before you know for sure that data for that day wasn’t available, and even then late delivery of data for unspecified delays is possible.

An explicit “there will be no data” indicator may be helpful.

Recommend adding water temperature as a non-mandatory metadata in Sample Object Reference for version 1.1 of the standard.

As a best practice, monitors collect the temperature at each sample site. Important and useful piece of information.

Suggest the following temperature objects:

1. Temperature (field type: numeric)
2. temperatureUnit (field type : enum ; C for celsius; F for fahrenheit; K for Kelvin)

Method code is a string enumeration value indicating the method code that was used to enumerate the sample result number. This method code should correspond to a method used to enumerate the sampled substance. For more information about the valid method codes, please see “Appendix 1 - Method Codes” in reference doc.

Suggest addition of method code "unknown/not provided" to the list of method codes.
"Unknown/not provided" will allow for data where the sample analysis method was not provided.

This is a membrane filtration method (CFU)
Name is M-TEC-Ig agar method
alternate name is MECP E3371

description : Public Health Ontario method: Specimens are tested by the Membrane Filtration method modified from MECP E3371: A Membrane Filtration Method for the Detection and Enumeration of Total Coliform, Escherichia coli, and Enterococci/Fecal Streptococci in Environmental Samples for the microbiological indicator Escherichia coli (E. coli).

I think we need to add a mechanism to the standard to revoke a published sample result if it is discovered after-the-fact that a result is not valid due to an issue like malfunctioning/miscalibrated test equipment, improper collection technique that may have resulted in contamination, or some other issue.

Advisories can only be issued by authoritative bodies, such as an environmental health officer. Therefore suggest the following in order to accommodate sample results from bodies without authority to issue health advisory such as citizen science groups, research bodies, etc.

Add the following objects to the advisory object reference:

• advisoryIssuedBy: (string); name of individual or body with authority to issue the advisory

• result_passed: mandatory, enum (An object indicating yes or no if the described water quality sample is in excess of the prevailing local standard for recreational water use)

(2017) IDEXX has Std Method approval for Enterolert and the Std Method code is 9230-D
https://www.standardmethods.org/doi/10.2105/SMWW.2882.197

Appendix 2 - Substance Codes should include two other cyanotoxins: Anatoxin-a and Saxitoxin.