Archive of Massachusetts ENvironmental Data

Website and analysis code for AMEND, the Archive of Massachusetts Environmental Data

MA Energy and Environmental Affairs Data Portal Assets

Data source

In August of 2017, the MA Executive Office of Energy and Environmental Affairs (EEA) began operating an “Enterprise Data Portal” for certain state regulatory data. Initially, this has included permit, facilities, inspections, and enforcement, and drinking water testing data; more data assets are promised “regularly.”

Data on combined sewer overflows (CSOs) were added in 2022 and now incorporated in AMEND. Other data tables added to the portal in recent years are not yet integrated.

Definitions, FAQs, disclaimers, and other information related to these datasets is available in PDF format at the EEA Data Portal website’s help page and archived here:

One of these datasets, the historical drinking water quality measurement dataset, is significantly larger than the other (>200 MB in total). Because this measurement-level drinking water quality reporting is not instrumental to the goals of AMEND, we do not include it in our integrated database. We do provide an archived version of the complete drinking water dataset below.

The data from this portal has been archived on this site, last updated on 24 June 2023 09:33 am. The CSO data is queried using a separate script and was last updated on 17 October 2023 11:07 pm.

Download archive

In addition to including them in them in the integrated AMEND Database, we provide our archives of each of these data assets in CSV format:

Data visualization

Data tables

For brevity, a random sample of 10 rows from each table and a subset of all columns is shown below for illustration as to the tables’ form and content.

Enforcement

Enforcement Date Enforcement Type Facility Name Penalty Assessed Program Town
2018-04-19T00:00:00 Notice Of Non-Compliance VIXS AUTO SERVICES INC   REGULATED ACTIVITY(S) SOMERVILLE
2009-04-01T00:00:00 Notice Of Non-Compliance HAMPSHIRE REGIONAL HIGH SCHOOL 0.0 WATER SUPPLY/DRINKING WATER WESTHAMPTON
2000-07-24T00:00:00 Notice Of Non-Compliance MALDEN HIGH SCHOOL   REGULATED ACTIVITY(S) MALDEN
1996-01-24T00:00:00 Field Notice Of Non Compliance MEDICALAB INC XRAY   REGULATED ACTIVITY(S) COHASSET
2019-01-31T00:00:00 Notice Of Non-Compliance WILLIAMSBURG WATER DEPT 0.0 WATER SUPPLY/DRINKING WATER WILLIAMSBURG
2014-12-16T00:00:00 Notice Of Non-Compliance GARBER FAMILY DENTISTRY   REGULATED ACTIVITY(S) SALEM
2002-10-24T00:00:00 Penalty Assessment Notice COMMONWEALTH TANK INC 45000.0 REGULATED ACTIVITY(S) WAKEFIELD
2019-10-08T00:00:00 Reporting Penalty Assessment Notice WEST ISLAND MARINA 500.0 REGULATED ACTIVITY(S) FAIRHAVEN
2014-12-16T00:00:00 Notice Of Non-Compliance AFFORDABLE DENTAL CENTER   REGULATED ACTIVITY(S) DRACUT
2009-11-02T00:00:00 Notice Of Non-Compliance KRIPALU CENTER 0.0 WATER SUPPLY/DRINKING WATER STOCKBRIDGE

Facilities

Facility Name Facility Type Program Street Name Town Active
MIENTKIEWICZ JAMES DEP REGULATED FACILITY REGULATED ACTIVITY(S) 560 HOLMES ST HANSON True
OUR LADY OF LOURDES CHURCH DEP REGULATED FACILITY REGULATED ACTIVITY(S) STATE HIGHWAY ROUTE 6 WELLFLEET True
HOLIDAY AUTO SALES DEP REGULATED FACILITY REGULATED ACTIVITY(S) 810 QUAKER HWY UXBRIDGE True
MAY GRAPHICS & PRINTING DEP REGULATED FACILITY REGULATED ACTIVITY(S) 359 LITTLETON RD WESTFORD True
ANDOVER HEALTHCARE INC DEP REGULATED FACILITY REGULATED ACTIVITY(S) 9 FANARAS DR SALISBURY True
SIGLER MACHINE CO DEP REGULATED FACILITY REGULATED ACTIVITY(S) 3 NORTHEAST BLVD STERLING True
SCITUATE TOWN OF DEP REGULATED FACILITY REGULATED ACTIVITY(S) SOUTHEAST CHANNEL SOUTH RIV SCITUATE True
SPENCER METAL FINISHING DEP REGULATED FACILITY REGULATED ACTIVITY(S) 55 MILL ST BROOKFIELD False
HOLYOKE GAS & ELECTRIC DEPT DEP REGULATED FACILITY REGULATED ACTIVITY(S) 102 CABOT ST HOLYOKE True
ALL SET PRESS, LLC DEP REGULATED FACILITY REGULATED ACTIVITY(S) 121 MADISON ST MALDEN False

Inspection

Facility Name Inspection Date Inspection Type Program Town
EASTHAM LANDFILL 1996-02-09T00:00:00 Unannounced Single-Media Inspection REGULATED ACTIVITY(S) EASTHAM
CAPE COD SPACE FORCE STATION 2009-07-15T00:00:00 Limited Inspect for Compliance Indicators/Field Presence REGULATED ACTIVITY(S) BOURNE
ASHBURNHAM WATER DEPARTMENT 1997-03-13T00:00:00 PERMIT (QUALIFICATION/REVIEW/COMPLIANCE) WATER SUPPLY/DRINKING WATER ASHBURNHAM
SANDWICH WATER DISTRICT 2002-05-22T00:00:00 TECHNICAL ASSISTANCE (NON-SPECIFIC) WATER SUPPLY/DRINKING WATER SANDWICH
DEERFIELD PAPER SLUDGE LANDFILL 2016-09-13T00:00:00 Solid Waste Visit Limited Enforcement Potential REGULATED ACTIVITY(S) MONROE
TOWER STORAGE 2000-10-24T00:00:00 ReInspection REGULATED ACTIVITY(S) CLINTON
COTTAGE STREET LANDFILL CLOSURE PROJECT 2005-03-14T00:00:00 Drive By Inspection REGULATED ACTIVITY(S) SPRINGFIELD
FIRST BUCKEYE CORP 2001-10-18T00:00:00 Announced Single-Media Inspection REGULATED ACTIVITY(S) MARSHFIELD
IRVING OIL TERMINALS INC 2012-01-26T00:00:00 Limited Inspect for Compliance Indicators/Field Presence REGULATED ACTIVITY(S) REVERE
SEALED AIR CORP 2013-01-09T00:00:00 Limited Inspect for Compliance Indicators/Field Presence REGULATED ACTIVITY(S) HOLYOKE

Permits

DateApplied FacilityName FinalDecisionDate PermitNumber PermitType Program Status StreetName Subtype Town
2000-12-27T00:00:00 SAFETY KLEEN SYSTEMS INC 2010-11-10T00:00:00 51005520 HW08 HAZARDOUS WASTE Approved 50A BRIGHAM ST TSD Operation License Or Closure Plan (IRP) MARLBOROUGH
1997-07-16T00:00:00 ORLEANS MARKETPLACE 1997-08-12T00:00:00 131079 WP67 WATER POLLUTION CONTROL Approved 136 RTE 6A APPROVAL OF SEWER PUMPS PRIOR TO THE SEPTIC TANK ORLEANS
2000-08-24T00:00:00 VA BOSTON HEALTHCARE SYSTEM 2001-04-05T00:00:00 W013009 AQ02 AIR QUALITY CONTROL Approved 940 BELMONT ST Plan Approval Non-Major Comprehensive BROCKTON
  MICHAEL J MORSE 2021-10-13T14:01:14 WS10-0002276 WS10 WATER SUPPLY/DRINKING WATER Active 20 BELLI AVE WS10 FITCHBURG
1998-02-19T00:00:00 GRAUEL LOUISA 1998-07-20T00:00:00 124153 WW01A WETLANDS & WATERWAYS Approved 288 HUCKINS NECK RD Water-Dependent License Residential <= 4 units BARNSTABLE
2013-01-28T00:00:00 CHERRY VALLEY WATER DIST 2013-03-11T00:00:00 X254479 WS21C WATER SUPPLY/DRINKING WATER Approved 184 HENSHAW ST Approval to Conduct Pilot Study 200K/Under 1M GPD LEICESTER
  DAVID SCOTT SPENCER 2019-04-05T12:51:51 AL-0045909 AL PESTICIDE Active 78 STANDISH AVE PESTICIDE CREDENTIAL PLYMOUTH
2022-06-22T00:00:00 SANDWICH WATER DISTRICT 2022-07-07T00:00:00 X289128 WS32 WATER SUPPLY/DRINKING WATER Approved 72 TUPPER RD Distribution Modification for Sys Serving Over 3300 People SANDWICH
1999-05-06T00:00:00 FORD ROBERT 2000-10-19T00:00:00 137557 WW01A WETLANDS & WATERWAYS Approved PIERCES POINT LN Water-Dependent License Residential <= 4 units WESTPORT
  JEFF SHILLCUTT 2023-05-12T16:08:56 PR-0006454 PR PESTICIDE Active ATTN: JEFF SHILLCUTT, 17635 NE 67TH CT PRODUCT REGISTRATION REDMOND

Drinking Water (all records)

Chemical Name Class Collected Date Contaminant Group Location Name Public Water System Name Raw or Finished Measurement Result Town
PARA-DICHLOROBENZENE COM 2023-02-01T00:00:00 VOC SCHOOL G.P. WELL HAMILTON WATER DEPT F ND HAMILTON
PERFLUOROBUTANESULFONIC ACID-PFBS NTNC 2022-01-03T00:00:00 PFAS POINT OF ENTRY JACOBS PILLOW DANCE FESTIVAL F ND BECKET
PARA-DICHLOROBENZENE NC 2014-08-20T00:00:00 VOC WELL #1 GRAND VIEW F ND MENDON
1,1,1,2-TETRACHLOROETHANE NC 2022-02-14T00:00:00 VOC FINISHED: WELL #1 HOLY VIRGIN MARY SPIRITUAL VINEYARD F ND CHARLTON
PCB AROCLOR 1248 COM 2023-05-10T00:00:00 SOC GP WELL # 1 BUZZARDS BAY WATER DISTRICT F ND BOURNE
BROMOMETHANE COM 2023-05-03T00:00:00 VOC RIVERNECK #1 WELL-RAW WATER CHELMSFORD WATER DISTRICT R ND CHELMSFORD
1,1-DICHLOROPROPENE NC 2021-07-07T00:00:00 VOC RAW WATER: WELL #1 CHARLTON PLAZA R ND CHARLTON
ATRAZINE COM 2012-11-15T00:00:00 SOC CHURCH LANE TREATMENT PLANT NORTH SAGAMORE WATER DISTRICT F ND BOURNE
MANGANESE COM 2020-09-11T00:00:00 SECCON VINE BROOK GWTF - FINISHED BURLINGTON WATER DEPT F 0.013 BURLINGTON
PERFLUOROBUTANESULFONIC ACID-PFBS COM 2023-01-17T00:00:00 PFAS POINT OF ENTRY POST TREATMENT CHESTER WATER DEPT F ND CHESTER

Drinking Water (annualized measurement counts records)

Year Public Water System Name Contaminant Group Raw or Finished Result
2003.0 HARVARD RIDGE CONDOMINIUM INORG F 70
2015.0 TURNERS FALLS WATER DEPT SOC F 45
1997.0 WESTMINSTER DEPARTMENT OF PUBLIC WORKS NITRAT F 1
1996.0 SHARON WATER DEPT THM F 1
2014.0 BERLIN MEMORIAL SCHOOL NITRIT F 1
2014.0 MCI NORFOLK/CEDAR JUNCTION/WALPOLE NITRAT F 2
2000.0 AYER DPW WATER DIVISION NITRIT F 1
2009.0 JOHN ROAD INDUSTRIAL PARK PERCHL F 1
2003.0 WEST BOYLSTON WATER DISTRICT INORG F 49
2018.0 MONROE WATER DISTRICT SECCON F 2

Combined Sewer Overflows

Year Incident ID incidentDate Reporter Class Event Type Water Body Municipality Volume
2023 741d1606-27a2-41ec-8fcb-1bbd15521123 2023-04-15 Verified Data Report CSO – UnTreated CONNECTICUT R. SPRINGFIELD 190000
2023 096c54ab-e835-4f68-aa5f-08d905a157af 2023-08-08 Verified Data Report CSO – UnTreated MOUNT HOPE BAY FALL RIVER 996698
2023 4452d010-b4d5-4543-aeb0-517316d0bf33 2023-07-29 Public Notification Report CSO – UnTreated MERRIMACK RIVER HAVERHILL  
2022 36295256-5b23-4a3e-bbef-4f30887bc83e 2022-07-12 Verified Data Report CSO – UnTreated CONNECTICUT R. HOLYOKE 11335
2023 1d4cb7c9-bf6c-4204-bdec-38c55dd8cc9b 2023-09-29 Public Notification Report CSO – UnTreated ACUSHNET RIVER NEW BEDFORD  
2023 7ba6d447-f8f3-4285-bdbe-d087a8484cf7 2023-03-13 Verified Data Report CSO – Treated TAUNTON RIVER FALL RIVER 780000
2023 c88f8602-2491-4fa5-bcd6-7cd1755a9aab 2023-04-01 Public Notification Report CSO – UnTreated ACUSHNET RIVER NEW BEDFORD  
2023 f594053b-655f-4c96-954d-b74e05c41c0e 2023-06-28 Verified Data Report CSO – UnTreated CHICOPEE R. SPRINGFIELD 249000
2023 b8ea2a80-633c-45bf-acb3-0525dccc6ccc 2023-01-26 Public Notification Report SSO – System Surcharging Under High Flow Conditions Other AMESBURY  
2022 70c381ab-c2be-45c9-8ee3-de4bb5f62e66 2022-09-13 Verified Data Report CSO – UnTreated OUTER NEW BEDFORD HARBOR NEW BEDFORD 160000