Mapping Process

In 2020, HEET has developed a new process for generating mappable gas leaks data. This process has resulted in an increase in accuracy and shareable gas leak data that can be imported into any mapping system that can use geocoded data.

The process in overview is as follows:

  • Every February, Annual Service Quality Report (ASQR) data is obtained from MA DPU 
  • Repaired, unrepaired and eliminated leaks data is reviewed, selected and extracted from the reports
  • Full leak address data is constructed in preparation for geocoding
  • The leak address data is geocoded
  • All geocoded addresses are reviewed by the HEET mapping team to catch errors in the original utility leak addresses, as well as any issues with the geocoding addresses that occasionally occur
  • Corrected addresses are geocoded again, and any unresolved issues are manually dealt with to identify the best matching location and GPS coordinates
  • Google KML is generated from the corrected and geocoded data and used for creating Google maps for each utility. These utility-level maps are then reviewed by the HEET mapping team to spot and fix any remaining issues such as leak addresses that were outside of their utility
  • The leak data for each town is then automatically extracted from the final geocoded addresses and town re-designation tables are created to cluster small towns into area maps, such as consolidating North/South/East/West towns
  • Using the final geocoded data and town re-designations, KML is generated to update the HEET gas leaks maps. In the case of Boston specific towns, KML is generated based on matching ZIP codes rather than towns.
  • The final geocoded data is also used to create shareable data files by utility and by town. We share this data under a Creative Commons license. Please contact us directly if you want a copy of the data.

Data Sources

Worksheet nameDPU docket #Docket data source
Berkshire Gas - repaired21-SQ-02BGC SQ Report for 2020.xlsx - Appx D - Gas Leak Class Data - leaks with a 'repair date'
Berkshire Gas - unrepaired21-SQ-02BGC SQ Report for 2020.xlsx - Appx D - Gas Leak Class Data - leaks without a 'repair date'
Eversource Energy - repaired21-SQ-09D.P.U. 21-SQ-09 Appendix 5 - 2020 Eversource SQI Section 144 (e) data Repaired Leaks.xlsx
Eversource Energy - unrepaired21-SQ-09D.P.U. 21-SQ-09 Appendix 5 - 2020 Eversource SQI Section 144 (e) data Existing Leaks.xlsx
Eversource Energy - eliminated21-SQ-09
D.P.U. 21-SQ-09 Appendix 5 - 2020 Eversource SQI Section 144 (e) data Eliminated Leaks.xlsx
Eversource Gas of MA - repaired21-SQ-01D.P.U. 21-SQ-01 App. 7 2020 EGMA Leak Report Repaired Leaks.xlsx
Eversource Gas of MA - unrepaired21-SQ-01D.P.U. 21-SQ-01 App. 7 2020 EGMA Leak Report Existing Leaks.xlsx
Eversource Gas of MA - eliminated21-SQ-01D.P.U. 21-SQ-01 App. 7 2020 EGMA Leak Report Eliminated Leaks.xlsx
Fitchburg - repaired21-SQ-04Gas_App_A.xlsx - pages 46-79
Fitchburg - eliminated21-SQ-04Gas_App_A.xlsx - pages 46-79
Liberty Utilities - repaired21-SQ-08DPU 21-SQ-08 Initial Filing.pdf - pages 25-32
Liberty Utilities - unrepaired21-SQ-08DPU 21-SQ-08 Initial Filing.pdf - pages 16-24
National Grid - Boston Gas - repaired21-SQ-05DPU 21-SQ-05 Boston Gas SQ Report CY 2020 (excel).xlsx - worksheet 9. Repaired Leaks
National Grid - Boston Gas - unrepaired21-SQ-05DPU 21-SQ-05 Boston Gas SQ Report CY 2020 (excel).xlsx - worksheet 10. Open Leaks
National Grid - Colonial Gas - repaired21-SQ-06DPU 21-SQ-06 Colonial Gas SQ Report CY 2020 (excel).xlsx - worksheet 9. Repaired Leaks
National Grid - Colonial Gas - unrepaired21-SQ-06DPU 21-SQ-06 Colonial Gas SQ Report CY 2020 (excel).xlsx - worksheet 10. Open Leaks