Vehicle Safety
Recalls Search 320,000+ NHTSA safety recalls Complaints 2.1M+ consumer safety complaints TSBs 4.7M technical service bulletins VIN Lookup Decode any vehicle VIN instantly OBD Codes 12,000+ diagnostic trouble codes Fuel Economy EPA MPG data for all vehicles Safety Ratings 11,700+ NHTSA crash test ratings Investigations 5,300+ NHTSA defect investigations Statistics Recall trends & safety analysis
Consumer Safety
Product Safety 9,700+ CPSC product recalls Food Safety 28,600+ FDA food recalls Pet Safety 1.3M FDA animal adverse events Drug Safety 17,500+ FDA drug recalls Device Safety 38,400+ FDA device recalls Workplace Safety 102,900+ OSHA injury reports Brand History Cross-category recall lookup by company
Infrastructure
Bridge Safety 624,000 bridge inspections Aviation Safety 30,000+ NTSB aviation events Dam Safety 92,600 dam safety records Water Safety 433,000+ public water systems Railroad Safety 438,000+ rail crossings Pipeline Safety 8,800+ pipeline incidents State Safety Dashboards Safety grades for all 50 U.S. states ZIP Safety Report Check any 5-digit ZIP across 9 datasets
Public Health
Nursing Homes 14,700 CMS rated facilities Environmental 80,000+ hazardous sites & releases
Blog

Vehicle Safety

Vehicle Recalls320,000+ NHTSA safety recalls Browse VehiclesEvery make, model and year Complaints2.1M+ consumer safety complaints TSBs4.7M technical service bulletins VIN LookupDecode any vehicle VIN instantly OBD Codes12,000+ diagnostic trouble codes Fuel EconomyEPA MPG data for all vehicles Safety Ratings11,700+ NHTSA crash test ratings Investigations5,300+ NHTSA defect investigations StatisticsRecall trends & safety analysis Compare VehiclesTwo vehicles side by side

Consumer Safety

Product Safety9,700+ CPSC product recalls Food Safety28,600+ FDA food recalls Pet Safety1.3M FDA animal adverse events Drug Safety17,500+ FDA drug recalls Device Safety38,400+ FDA device recalls Workplace Safety102,900+ OSHA injury reports Brand HistoryRecall lookup by company

Infrastructure

Bridge Safety624,000 bridge inspections Aviation Safety30,000+ NTSB aviation events Dam Safety92,600 dam safety records Water Safety433,000+ public water systems Railroad Safety438,000+ rail crossings Pipeline Safety8,800+ pipeline incidents State DashboardsSafety grades for all 50 states ZIP ReportAny 5-digit ZIP across 9 datasets

Public Health

Nursing Homes14,700 CMS rated facilities Environmental80,000+ hazardous sites & releases BlogGuides, news & safety insights

NINESTAR CONNECT - GEM WATER

Indiana - Community Water System - PWSID: IN5230008

System Information

PWSIDIN5230008
System NameNINESTAR CONNECT - GEM WATER
System TypeCommunity Water System
Water SourceGround Water
Activity StatusActive
Owner TypePrivate
EPA Region05
Serves SchoolNo
WholesalerNo
First ReportedAug 22, 1997
Last ReportedFeb 12, 2026

Location & Contact

StateIndiana
CityGREENFIELD
ZIP Code46140
Address2243 East Main Street
OrganizationMARTIN, ALAN
Phone317-694-7299

Population & Service

Population Served1,700
Service Connections1,250

Drinking Water Violations (9)

This water system has 9 violations recorded in the EPA SDWIS database.

Begin Date End Date Contaminant Category Health-Based Major Measured Federal MCL State MCL Status Return to Compliance Rule
Jan 1, 2025 Dec 31, 2025 MR No Yes - 10 mg/L - Archived Dec 31, 2025 -
Jul 1, 1998 - MR No No - TT - Resolved Mar 9, 2006 -
Jul 1, 1998 - TT Yes No - TT - Resolved Mar 9, 2006 -
Jan 1, 1998 Jun 30, 1998 MR No No - TT - Resolved Jun 30, 1998 -
Oct 1, 1997 Oct 31, 1997 MR No No - 5% of samples - Resolved Oct 31, 1997 -
Oct 1, 1997 Oct 31, 1997 MR No No - 5% of samples - Resolved Oct 31, 1997 -
Jan 1, 1996 Dec 31, 1998 MR No Yes - 0.2 mg/L - Resolved Dec 31, 1998 -
Jan 1, 1996 Dec 31, 1998 MR No Yes - 0.2 mg/L - Resolved Dec 31, 1998 -
Jan 1, 1996 Dec 31, 1998 MR No Yes - 0.2 mg/L - Resolved Dec 31, 1998 -

About This Water System

Public water system data comes from the EPA Safe Drinking Water Information System (SDWIS). Systems with violations must notify customers. Contact your water utility for the latest annual water quality report.

Browse All Water Systems Water Safety Stats Water Safety Home
Browse All Water Systems Water Systems in Indiana