You can download the compiled DS-WQX schema from above.Īlternately, you can build it from the source to include in your project. This is accomplished by having acceptance and rejection tests. We aim to have our test be as robust as possible. Temperature should be within -100 degC and 100 degC.Hardness should not be less than or equal to 0.Dissolved oxygen saturation should not be less than 0%.Dissolved oxygen (DO) should not be in %.In addition to our schema enforcing allowed values the column conditional logic we have included additional check for common errors to the frontend flavour of our schema. In addition to the observation-level information in DS-WQX, DataStream uses dataset level metadata. To view the most recent version number and record of changes please see the DataStream Upload Template. The DataStream open data schema will continue to evolve to meet user needs and therefore is subject to various updates over time (e.g. DataStream’s science and technical advisory team, regional partners and collaborators, data contributors, government representatives as well as other members of the water community were engaged in this process.ĭataStream’s open data schema (DS-WQX v1.0) was fully implemented across all regional DataStream platforms in 2019.
DataStream is free to use and allows users to query, visualize, and download data. Data is uploaded, stored and shared in DataStream’s Open Data Schema - a model based on the WQX standard for the Exchange of Water Quality Data. In 2018, The Gordon Foundation led a comprehensive review process to determine how this model could be adapted to best meet the needs of diverse water monitoring initiatives in Canada. DataStream ( ) is an online open-access platform for sharing water quality and sediment quality data. In the US, the WQX schema is used on the US EPA’s Water Quality Portal to share over 340 million water quality data records data from 400 federal, state, tribal and other partners. It was designed to enable multiple monitoring entities to share results in a common format. The WQX schema was developed by the US Environmental Protection Agency (EPA) and the US Geological Society (USGS) and is an implementation of the ESAR (Environmental Sampling, Analysis and Results) data standard. To ensure consistent formatting of water data and to avoid ambiguous or missing information, we developed an observation-level data schema based on the WQX standard for the Exchange of Water Quality Data. Data contributors maintain ownership of their data which are published under open data licenses. Water monitoring groups across Canada - including communities, researchers, Indigenous nations and governments at all levels - are using DataStream to publish their data.ĭataStream was developed by The Gordon Foundation and is carried out in collaboration with regional partners and monitoring networks. DataStream is free to use and allows users to query, visualize, and download data in this standardized format. DataStream Open Data Schema for Water Quality Dataĭownload the latest version in JSON Schema, Google SpreadSheet, Excel template formats.ĭataStream ( ) is an online open-access platform for sharing water quality and sediment quality data.