carrie berard, lead analyst, gas r&d steve hope,...
TRANSCRIPT
www.avangrid.com 1
ESRI GeoConX ConferenceOctober 17-20, 2016 Phoenix, AZ
Carrie Berard, Lead Analyst, Gas R&DSteve Hope, Project Manager, GIS
www.avangrid.com 2
Iberdrola, Avangrid, NYSEG, RGE…Who Are We?
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
Iberdrola SA (Spain)– The world leader in wind generation– One of the 5 largest utilities in the world (31k emp, 31 ml. cust)– Holdings in US, Brazil, Mexico, UK and Europe– Presence in 25 US States
Avangrid (US Distribution) CompaniesNYSEG (NY) 880,000 Electric - 260,000 GasRGE (NY) 370,000 Electric - 300,000 GasCMP (Maine) 600,000 ElectricMNG (Maine) 4,000 GasNHG (New Hampshire) 1,200 GasUIL (Connecticut) 328,000 ElectricCNG (Connecticut) 155,000 GasSCG (Connecticut) 165,000 GasBGC (New Hampshire) 35,000 Gas
www.avangrid.com 3
March 12, 2014 – New York, NY - Gas Explosion collapses two buildings in Harlem, killing 8 and injuring 54. A crack in a plastic service tee coupling to the main line was found t
The FDNY
arrived
Gas odor
Natural Gas Explosion
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 4
Soil undermining of the gas piping due to adjacent water facility leakage had caused sag in the piping. 36” inches of paving material from multiple road patches were covering the leak, instead of normal 18”.
It was found that the sewer undermining, road weighting and the failure of the “poorly completed, poorly beaded” gas fusion were co-contributing factors of the explosion.
Review of all fuser qualification records uncovered many fusers had lapsed qualifications of up to a year. The fuser in this case was lapsed by 1 month and inspector lapsed by 6 months.
Mapping for that section of piping inadequately identified the pipe material.
Leak survey records could not be produced for that section of piping for 2013-14.
Public Service Commission Investigation Result - 05/14
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 5
PE fusion investigation of all NY utilities launched 6/14 identified widespread non-compliance with qualification protocols.
A new PSC order was published 05/15. “Second person” qualified inspections were required starting 10/15 and work fully documented. Random samples of existing fusions were inspected across all NY utilities beginning immediately. Extensive training/re-qualification of personnel also took place in this period.
Beginning on 01/16, the final step was to have “an auditable, electronic database must be kept correlating the GPS location to the fusion and result of its’ inspection. This includes newly constructed fusions and any that are remediated. Fusion records and failures are to be submitted to PSC, including fuser and inspector information.” The plan to accomplish this was due 09/15.
PSC Order Goes Into Effect
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 6
Short time to plan (3+ months) and implement (6+ months) an electronic data capture solution.
Determined it was best to leverageour existing GIS system and fieldcollection, as used in our ElectricStorm Damage AssessmentProgram, which had been inproduction for approximately1 year.
Electric Storm Damage Assessment was using 300 Apple iPads with ESRI Collector dedicated for major outage events. It was decided that Gas would get 300 for their own use.
Plans for Accomplishing Electronic Fusion Data
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 7
Benefits:
Experience working with iPads/Collector Low Cost (esp. iPads) Ease of Use/Acceptance (iPad “likeability”) Gas GIS map included in .tpk for offline Solution fairly quick to deploy ESRI GIS Database/Reporting Training overlap ESRI support/supplement internal IT Relationship with Verizon
Leveraging Existing ESRI Solution
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 8
Phase Timeline to Prepare and Deploy iPads
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
Phase I June/July - Order & Setup Units, Develop Collector AppPhase II Aug/Sept - Test Prototype, Prepare Training Materials Phase III Oct/Dec - Train Field Users, Deploy, Train Office Staff
www.avangrid.com 9
Short timeline, holiday season
300 iPads – no Mobile Device Management (MDM) in place
Geography of service territory
Combination of Contractors and Internal Workers
New Order, reasonableness and perception of accomplishing data collection
Benefitted from it not being construction “season”.Formed action team to setup devices, scripted and organized. Verizon VERY helpful. Consolidated meetings to main offices and “piggyback” to other meetings.Loaned internal units to contractors until they could acquire their own.Stressed this is the mandate and we must follow or face fines. Safety of public is foremost.
General Challenges and Solutions
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 10
iPads – purchased 16gb, need upgrade to 32gb for offline use
iPads - Replica Syncronization Errors in 1Q
IOS upgrades, security breach
Contractor iPads
Training issues
Early swapout of devices during setup phase. Verizon extremely helpful.Worked with ESRI Support. No real resolve except upgrade of Collector version.Difficult without MDM. In progress…Load .tpk for offline, need for basic online street map in cases where no .tpk is loaded.Photos captured with every point used to verify correct procedures. …NEW…QA/QC effort to clean data.
iPad and Collector Challenges and Solutions
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 11
Gas Plastic Fusion System Process Configuration
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
ArcGIS Online
iPads with Collector(Internal)
AGOL Dashboard(Supervisor)
Reports(Excel-Sharepoint)
ArcGIS Online(View/Edit)
iPads with Collector(Contractor)
Email Notifications
CompanyDatabase
ESRI DataReviewerAnd PhotoSurvey
New – In Progress
www.avangrid.com 12
iPad Mini’s with ESRI Collector
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 13
ArcGIS Online for Viewing/Editing/QA/QC
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 14
ArcGIS Online Dashboard for Summarized Data
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 15
Fusion Reports by:
All Fusions SAP
Number Fuser Inspector Areas
* Customize, filter and sort for many other needs.
Reporting to Meet PSC Requirements
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
Fuser Insp. Count Crew Reason OPCO-Div.1509 1305 17 Contr. New Cons. NYSEG-Ith.1509 1314 5 Contr. New Cons. NYSEG-Ith1509 1620 1 Contr. New Cons. NYSEG-Ith
www.avangrid.com 16
Email Failure Notifications to Supervisors
Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
www.avangrid.com 17Avangrid Captures Gas Plastic Fusion Welds Using Collector to Meet Public Service Commission Regulation
Questions – Comments
(begin Training Video)