Drinking Water Watch (DWW) Samples
URL: https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/
Drinking Water Watch Samples now in SensorThings API
The NMENV's Drinking Water Watch is a public facing web app that members of the public can use to find information on their public water system.
https://sdwis.water.net.env.nm.gov/NMDWW/
- Type SANTA FE into the Water System Name box and hit Enter
- Click NM3505126 SANTA FE WATER SYSTEM (CITY OF)
- Click Other Chemical Results
- Click the recent Sample No. 2111C89-001 on 1592 Cerro Gordo Rd
- You can now see 11 different chemicals (analytes) and the values gathered
SensorThings API is a REST compliant interface for software to query the same data programmatically, that is, with a script or using another app to query it regularly, instead of via mouseclicks. Common uses of this method to display data on a map, or generate a report, or conduct research. Click the link below to start:
https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1
Your experience will be best using Mozilla Firefox because the output is in a format called JSON, and Firefox will indent and color code it for you instead of returning a mass of jumbled text. Other browsers needs a plugin to parse and format JSON.
You will see a number of elements, or topics, there. In general, they correspond to Drinking Water Watch tables as follows:
comment: (|SensorThings API element|Drinking Water Watch table|)
comment: (|FeaturesOfInterest|public water systems|) comment: (|Observations|sample results|) comment: (|Things|sample points (with locations)|)
FeaturesOfInterest --> public water systems
Observations --> sample results
Things --> sample points (with locations)
ObservedProperties --> analytes
Sensors --> laboratories
Click on the link for public water systems
https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/FeaturesOfInterest
To find all water systems with SANTA FE in their name you can add a query to the URL like so:
As with the Drinking Water Watch graphical user interface, you can see that the SANTA FE WATER SYSTEM (CITY OF) has a SDWIS ID number of NM3505126. Now you can also filter by this to go directly to it:
Sample results, or Observations, for this utility are given in a URL in the body of the returned JSON string.
https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/FeaturesOfInterest(380)/Observations
If you want to see the results of a specific sample, you may filter by its sample number. Let's try the one we got earlier, 2111C89-001:
You can see the same 11 results from before.
A strength of SensorThings API is that it can be queried using any number of these built-in linkages that tie samples to public water systems (Observations to a FeatureOfInterest), but also a number of custom queries.
You can return all treatment plants in a geographic area by sending in a bounding box of latitude longitude values around Roswell. Please note that absolutely everything is case sensitive:
To return all positive tests for microbes in the Santa Fe water system:
For more query examples please see this presentation by the Internet of Water's Kyle Onda.
Additional Information
Field | Value |
---|---|
Data last updated | March 3, 2022 |
Metadata last updated | March 3, 2022 |
Created | March 3, 2022 |
Format | SensorThings API |
License | License not specified |
Id | 1701a270-32a6-4970-bbc5-6dc0345f22ec |
Package id | 0af28ebc-0032-40ea-a0ad-21a1a964ac52 |
State | active |