Other (Public Domain)

epa-storet-legacy-data-center

The United States Environmental Protection Agency (EPA or sometimes USEPA) is an agency of the Federal government of the United States which was created for the purpose of protecting human health and the environment by writing and enforcing regulations based on laws passed by Congress.

environmental-protection-agency

United States Environmental Protection Agency

EPA storet legacy data center

bag-info.txt

bagit.txt

manifest-md5.txt

tagmanifest-md5.txt

9F848139-C50C-4456-AF67-893196DD1DBA.json

download_ftp_tree.py

run_me.sh

dir_list.txt

STORET_Docs.zip

file-list-docs.txt

not_moved_orgs.zip

file-list-not_moved_orgs.txt

file-list-all_states.txt

all_states.zip

EPASTORETLegacyDataCenter.pdf

EPA - STORET Legacy Data Center

License not specified

sdwis

Our mission is to protect and restore the environment and to foster a healthy and prosperous New Mexico for present and future generations. We implement our mission guided by four tenets: 

###Science

Using the best available science to inform our decision-making in protecting public health and the environment.

###Innovation

Employing creative engineering and technological solutions to address environmental challenges. 

###Collaboration

Engaging communities and interested stakeholders in environmental decision-making outcomes.  

###Compliance

Ensuring meaningful compliance with state regulations and permits; leveling the playing field through enforcement.

The New Mexico Environment Department was created by the 40th state Legislature in 1991 under the “Department of Environment Act” (Chapter 25). As a regulatory agency, NMED enforces various state regulations and federal laws relating to protection of the environment, resources, and public health and safety.

nm-environment-department

New Mexico Environment Department

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/

1. Type **SANTA FE** into the Water System Name box and hit Enter
2. Click **NM3505126** SANTA FE WATER SYSTEM (CITY OF)
3. Click Other Chemical Results
4. Click the recent Sample No. **2111C89-001** on 1592 Cerro Gordo Rd
5. 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]: <> (|---|---|)
[comment]: <> (|FeaturesOfInterest|public water systems|)
[comment]: <> (|Observations|sample results|)
[comment]: <> (|Things|sample points $with locations$|)
[comment]: <> (|ObservedProperties|analytes|)
[comment]: <> (|Sensors|laboratories|)
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:

[https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/FeaturesOfInterest?$filter=substringof('SANTA FE', name)](https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/FeaturesOfInterest?$filter=substringof(%27SANTA%20FE%27,%20name))

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:

[https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/FeaturesOfInterest?$filter=properties/number eq 'NM3505126'](https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/FeaturesOfInterest?$filter=properties/number%20eq%20'NM3505126')

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](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**:

[https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/Observations?$filter=parameters/sample_number eq '2111C89-001'](https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/Observations?$filter=parameters/sample_number%20eq%20%272111C89-001%27)

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:

[https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/Locations?$filter=substringof('PLANT', description) and st_intersects(location, geography'POLYGON((-104.67698 33.23398,-104.67698 33.60708,-104.24332 33.60708,-104.24332 33.23398,-104.67698 33.23398))')](https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/Locations?$filter=substringof%28%27PLANT%27,%20description%29%20and%20st_intersects%28location,%20geography%27POLYGON%28%28-104.67698%2033.23398,-104.67698%2033.60708,-104.24332%2033.60708,-104.24332%2033.23398,-104.67698%2033.23398%29%29%27%29)

To return all positive tests for microbes in the Santa Fe water system:

[https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/FeaturesOfInterest(380)/Observations?$filter=result eq 'P'](https://nmenv.newmexicowaterdata.org/FROST-Server/v1.1/FeaturesOfInterest(380)/Observations?$filter=result%20eq%20%27P%27)

For more query examples please see this [presentation](https://internetofwater.org/wp-content/uploads/2021/07/SensorThings-Webinar.pdf) by the Internet of Water's Kyle Onda.


Drinking Water Watch (DWW) Samples

This is a JSON API version of the violations in SDWIS available through our public facing web interface called Drinking Water Watch.

Drinking Water Watch (DWW) violations

This is the facility information plus location information available from FedRep, a quarterly submittal of data to the Environmental Protection Agency on drinking water systems from the New Mexico Environment Department.

Federal Reporting Services (FedRep) facilities

This site contains information and links on the data services provided by New Mexico Water Data Initiative and is maintained and hosted by the New Mexico Water Data Initiative. The purpose of this site is to provide a comprehensive and sensible set of documentation to help guide users in accessing and finding water data.

Water Data Initiative Documentation Site

Safe Drinking Water Information System - State System (SDWIS/State)

Filters