{"schema_version":"1.2","pwsid":"WI1280122","system_name":"RIPVIEW COURT 2","city":"CAMBRIDGE","state":"WI","population_served":31,"source_type":"GW","summary":"RIPVIEW COURT 2 serves approximately 31 people in CAMBRIDGE, Wisconsin. Based on contaminant analyses from DNR, EPA ECHO, 0 contaminants have been measured above federal EPA standards (MCL) and 1 exceeds health-based guidelines. The most significant finding is Lead (90th Percentile) at 0.00225 mg/L, which is 11.2x the health guideline. Data is drawn from source-level compliance monitoring and covers 2021 through 2026. Results reflect conditions at the point of collection (wells, treatment plants), not necessarily at the tap.","data_period":{"start":"2021-10-12","end":"2026-05-12"},"contaminants_tested":60,"contaminants_detected":16,"exceedances":0,"guideline_exceedances":1,"contaminants":[{"name":"Nitrate (as N)","code":"NITRATE","cas_number":"14797-55-8","group":"inorganics","section":"other_detected","measured_value":4.6,"unit":"mg/L","sample_date":"2026-05-12","source":"DNR","source_scope":"source_monitoring","health_guideline_value":10,"health_guideline_source":"EPA MCLG","epa_mcl_value":10,"status":"below_limits","detection_limit":null},{"name":"Chlorine (free)","code":"0700","cas_number":null,"group":"disinfectants","section":"other_detected","measured_value":0.02,"unit":"mg/L","sample_date":"2025-07-02","source":"DNR","source_scope":"source_monitoring","health_guideline_value":4,"health_guideline_source":"EPA MCLG","epa_mcl_value":4,"status":"below_limits","detection_limit":null},{"name":"Nickel","code":"1036","cas_number":null,"group":"inorganics","section":"other_detected","measured_value":0.0025,"unit":"mg/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":0.012,"health_guideline_source":"OEHHA PHG","epa_mcl_value":null,"status":"below_limits","detection_limit":null},{"name":"Barium","code":"BARIUM","cas_number":"7440-39-3","group":"inorganics","section":"other_detected","measured_value":0.047,"unit":"mg/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":1,"health_guideline_source":"OEHHA PHG 2003 (hypertension endpoint)","epa_mcl_value":2,"status":"below_limits","detection_limit":null},{"name":"Fluoride (natural)","code":"FLUORIDE","cas_number":"16984-48-8","group":"inorganics","section":"other_detected","measured_value":0.085,"unit":"mg/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":4,"health_guideline_source":"EPA MCLG","epa_mcl_value":4,"status":"below_limits","detection_limit":null},{"name":"PFHpA (Perfluoroheptanoic Acid)","code":"PFHPA","cas_number":null,"group":"pfas","section":"other_detected","measured_value":0.5,"unit":"ng/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":null,"health_guideline_source":null,"epa_mcl_value":null,"status":"detected","detection_limit":null},{"name":"Uranium","code":"4006","cas_number":"7440-61-1","group":"radionuclides","section":"other_detected","measured_value":0.173,"unit":"ug/L","sample_date":"2023-07-10","source":"DNR","source_scope":"source_monitoring","health_guideline_value":0.0005,"health_guideline_source":"OEHHA PHG","epa_mcl_value":0.03,"status":"below_limits","detection_limit":null},{"name":"Combined Radium (226+228)","code":"4010","cas_number":null,"group":"radionuclides","section":"other_detected","measured_value":0.984,"unit":"pCi/L","sample_date":"2023-07-10","source":"DNR","source_scope":"source_monitoring","health_guideline_value":0,"health_guideline_source":"EPA MCLG","epa_mcl_value":5,"status":"below_limits","detection_limit":null},{"name":"Gross Alpha Radiation (excluding Radon and Uranium)","code":"4000_EXCL","cas_number":null,"group":"radionuclides","section":"other_detected","measured_value":5.17,"unit":"pCi/L","sample_date":"2023-07-10","source":"DNR","source_scope":"source_monitoring","health_guideline_value":null,"health_guideline_source":null,"epa_mcl_value":15,"status":"below_limits","detection_limit":null},{"name":"Lead (90th Percentile)","code":"PB90","cas_number":"7439-92-1","group":"lead_copper","section":"guideline_exceedance","measured_value":0.00225,"unit":"mg/L","sample_date":"2024-09-30","source":"EPA ECHO","source_scope":"federal_program","health_guideline_value":0.0002,"health_guideline_source":"OEHHA PHG","epa_mcl_value":null,"status":"exceeds_guideline","detection_limit":null},{"name":"Copper (90th Percentile)","code":"COPPER","cas_number":"7440-50-8","group":"lead_copper","section":"other_detected","measured_value":28,"unit":"ug/L","sample_date":"2024-08-13","source":"DNR","source_scope":"source_monitoring","health_guideline_value":0.3,"health_guideline_source":"OEHHA PHG","epa_mcl_value":null,"status":"below_limits","detection_limit":null},{"name":"PFHxA (Perfluorohexanoic Acid)","code":"PFHXA","cas_number":"307-24-4","group":"pfas","section":"pfas","measured_value":0.8,"unit":"ng/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":null,"health_guideline_source":null,"epa_mcl_value":null,"status":"detected","detection_limit":null},{"name":"PFBS (Perfluorobutane Sulfonate)","code":"PFBS","cas_number":"375-73-5","group":"pfas","section":"pfas","measured_value":1.3,"unit":"ng/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":null,"health_guideline_source":null,"epa_mcl_value":null,"status":"detected","detection_limit":null},{"name":"PFHxS (Perfluorohexane Sulfonate)","code":"PFHXS","cas_number":"355-46-4","group":"pfas","section":"pfas","measured_value":1.5,"unit":"ng/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":0.01,"health_guideline_source":"EPA MCLG","epa_mcl_value":0.01,"status":"below_limits","detection_limit":null},{"name":"PFOA (Perfluorooctanoic Acid)","code":"PFOA","cas_number":"335-67-1","group":"pfas","section":"pfas","measured_value":1.6,"unit":"ng/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":0,"health_guideline_source":"EPA MCLG","epa_mcl_value":0.004,"status":"below_limits","detection_limit":null},{"name":"PFOS (Perfluorooctane Sulfonate)","code":"PFOS","cas_number":"1763-23-1","group":"pfas","section":"pfas","measured_value":2.1,"unit":"ng/L","sample_date":"2024-04-17","source":"DNR","source_scope":"source_monitoring","health_guideline_value":0,"health_guideline_source":"EPA MCLG","epa_mcl_value":0.004,"status":"below_limits","detection_limit":null}],"sources":[{"name":"DNR","url":"https://apps.dnr.wi.gov/dwsportalpub"},{"name":"EPA ECHO","url":"https://echo.epa.gov/"}],"pfas_combined_display":{"value":3.7,"unit":"ng/L","sample_date":"2024-04-17","note":"Legacy 2016 EPA Health Advisory combined PFOA+PFOS metric. Not a current MCL."},"well_counts":{"active":1,"retired":0,"facilities_synced_at":"2026-09-05T13:11:48.807Z"},"historical_wells":[],"has_only_historical_data":false,"pfas_hazard_index":{"value":0.1507,"compounds_used":["PFHXS","PFBS"],"is_partial":true,"threshold":1,"components":[{"code":"PFHXS","value_ng_l":1.5,"hbwc_ng_l":10,"ratio":0.15},{"code":"PFBS","value_ng_l":1.3,"hbwc_ng_l":2000,"ratio":0.0007}]},"tthm_lraa":[],"haa5_lraa":[]}