Public water system · NY1006202
ActiveSweet Peas Hillsdale Country Diner LLC
At a glance
Sweet Peas Hillsdale Country Diner LLC (PWSID NY1006202) is an active transient non-community water system in Columbia County, New York. It reports serving 60 people through 1 service connection. Its primary water source is groundwater, and EPA lists it as privately owned. Of the 12 most recent violations in EPA's records, none is health-based, and the most recent began in February 2014.
Dataset updated . Source: EPA SDWIS/ECHO public records.
Population served
60
Service connections
1
Primary source
GW
Groundwater
System type
TNCWS
Transient non-community water system
System record
How does Sweet Peas Hillsdale Country Diner LLC compare with other water systems in Columbia County?
By EPA's size categories, Sweet Peas Hillsdale Country Diner LLC is a very small system (500 people or fewer). Columbia County has 205 active public water systems. Its population served is well below the county average of 529 people per system, and accounts for less than 0.1% of the 108,444 people reported by systems filed under the county. Across New York, the 8,167 active systems average 2,374 people each. Nationally, the average active transient non-community water system reports serving 144 people, so Sweet Peas Hillsdale Country Diner LLC is about 58% below that figure.
What does “transient non-community water system” mean?
A transient non-community water system serves places where people do not stay long, such as gas stations and campgrounds, and regularly serves at least 25 people a day for at least 60 days a year. New York has 5,182 active transient non-community water systems, 63% of the state's 8,167 active systems. Groundwater means the system draws its water from wells or springs fed by underground aquifers. 7,096 New York systems (87%) list groundwater as their primary source.
Who owns and regulates Sweet Peas Hillsdale Country Diner LLC?
EPA lists Sweet Peas Hillsdale Country Diner LLC as privately owned. The NY state drinking water program is its primacy agency, the regulator with primary enforcement responsibility for the system under the Safe Drinking Water Act. 177 of the 205 active systems in Columbia County (86%) are also privately owned.
Does Sweet Peas Hillsdale Country Diner LLC have drinking water violations?
Of the 12 most recent violations in EPA's records, none is health-based, and the most recent began in February 2014. The violations listed here began between January 2003 and February 2014. By type: 12 monitoring and reporting. The contaminant or rule involved most often is Total coliform bacteria (TCR) (9 of them). EPA lists 12 as resolved. Resolved means at least one resolving action is on record: the system returned to compliance, the rule no longer applies, or no further action was needed.
| Began | Violation | Contaminant or rule | Health-based | Status |
|---|---|---|---|---|
| 2014-02-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2014-01-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2010-07-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2009-01-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2009-01-01 | Monitoring and reportingMonitoring, Regular · code 03 | Nitratecode 1040 | No | Resolved |
| 2008-01-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2006-01-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2005-04-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2005-01-01 | Monitoring and reportingMonitoring, Regular · code 03 | Nitratecode 1040 | No | Resolved |
| 2003-10-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2003-04-01 | Monitoring and reportingMonitoring, Routine Major (TCR) · code 23 | Total coliform bacteria (TCR)code 3100 | No | Resolved |
| 2003-01-01 | Monitoring and reportingMonitoring, Regular · code 03 | Nitratecode 1040 | No | Resolved |
The 12 most recent violations in EPA's records, newest first. Labels and codes come from EPA's SDWIS reference tables. A monitoring or reporting violation means a required test or report was missed or late; it does not by itself mean a contaminant was found. "Health-based" marks violations of a legal limit or required treatment.
Sweet Peas Hillsdale Country Diner LLC: frequently asked questions
Who runs Sweet Peas Hillsdale Country Diner LLC?
Sweet Peas Hillsdale Country Diner LLC (PWSID NY1006202) is a transient non-community water system privately owned. It is regulated by the NY state drinking water program.
How many people does Sweet Peas Hillsdale Country Diner LLC serve?
Sweet Peas Hillsdale Country Diner LLC reports serving 60 people through 1 service connection in Columbia County, New York.
Where does Sweet Peas Hillsdale Country Diner LLC get its water?
EPA SDWIS lists this system's primary water source as groundwater. Groundwater means the system draws its water from wells or springs fed by underground aquifers.
Does Sweet Peas Hillsdale Country Diner LLC have any drinking water violations?
Of the 12 most recent violations in EPA's records, none is health-based, and the most recent began in February 2014. A monitoring or reporting violation means a required test or report was missed or late; it does not by itself mean a contaminant was found.
Is Sweet Peas Hillsdale Country Diner LLC's water safe to drink?
AquaCensus shows EPA compliance records, not current water test results, so it cannot say whether the water is safe at a given moment. Of the 12 most recent violations in EPA's records, none is health-based, and the most recent began in February 2014. For current results, consult EPA ECHO, or the NY state drinking water program.
Where can I find Sweet Peas Hillsdale Country Diner LLC's water quality report?
The annual Consumer Confidence Report requirement applies to community water systems. Sweet Peas Hillsdale Country Diner LLC is a transient non-community water system, so it is not required to publish one; like every public water system, it must notify the people it serves about violations under EPA's public notification rules.
Other water systems in Columbia County
| Water system | County | Population served | Type | Source |
|---|---|---|---|---|
| Chatham Fair Water Distribution | Columbia | 53,700 | Transient non-community | Purchased groundwater |
| Martin Van Buren Historical House | Columbia | 10,000 | Transient non-community | Groundwater |
| Hudson City | Columbia | 6,750 | Community | Surface water |
| Greenport Wd No1 | Columbia | 4,050 | Community | Groundwater |
| Taconic Hills School | Columbia | 2,500 | Non-transient non-community | Groundwater |
| Lake Taghkanic State Park | Columbia | 2,500 | Transient non-community | Surface water |
Related pages
Working with water-system records? Pro adds alerts, change history and CSV export ($49/mo); Enterprise adds full national files, the API and an MCP server for AI tools.
About this data
Source: U.S. EPA Safe Drinking Water Information System (SDWIS) and SDWA violation records, via EPA ECHO, as published October 1, 2026 — AquaCensus refreshes it quarterly. See the methodology for how records are matched, cleaned and scored.
Cite as: AquaCensus, “Sweet Peas Hillsdale Country Diner LLC, PWSID NY1006202, New York”, https://aquacensus.com/water-systems/new-york/sweet-peas-hillsdale-country-diner-llc-ny1006202 (data as of October 1, 2026).