hydraulic modelling with gis data
DESCRIPTION
Presented by Ted Norcott, Harry Bhandal from FortisBC FME is used to extract and prepare Smallworld GIS data for System Planning’s hydraulic modeling software (Winflow). We will explain how this requirement came about, how the information is extracted, manipulated, and used within Winflow.TRANSCRIPT
![Page 1: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/1.jpg)
Hydraulic Modeling with GIS DataTed Norcott Harry BhandalGIS Specialist System Capacity PlanningFortisBC Energy FortisBC Energy
April 27, 2012
![Page 2: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/2.jpg)
FortisBC Company Overview
A subsidiary of Fortis Inc. “FTS” (TSX) Regulated Gas and Electric company 2300 employees 48,000 km of natural gas pipeline 950,000 natural gas customers Largest territory of any North American gas utility
![Page 3: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/3.jpg)
FortisBC (Gas) Service Areas
FortisBC (Mainland)
FortisBC (Whistler)FortisBC (Vancouver Island)
![Page 4: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/4.jpg)
System Capacity Planning
Model Hydraulics of Pipeline System
We are the fortune tellers at Fortis BC
![Page 5: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/5.jpg)
System Capacity Planning
Long Range Capital Planning
Operations Support Planned Emergency
![Page 6: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/6.jpg)
Modeling Software
Distribution System
Software: SynerGEE Gas
(Stoner)
Model Building Tool:
Custom built application in
Smallworld GIS
Transmission System
Software: Gregg
Engineering WinFlow
Model Building Tool:
Constructed by hand
![Page 7: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/7.jpg)
Problem
Licensing and skill set requirements for 2 different
software
Upgrade of SynerGEE required with the need for
additional hardware
$$$$
![Page 8: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/8.jpg)
Solution
Business Case determined Gregg was the most
economical choice
How do we build 48,000 km of pipeline
(Distribution & Transmission) in Gregg?
Building by hand is not a consideration
FME to the rescue!!
![Page 9: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/9.jpg)
Hope, British Columbia (Study Area)
![Page 10: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/10.jpg)
Smallworld ‘GIS’ View
![Page 11: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/11.jpg)
Gregg Engineering ‘WinFlow’ View
![Page 12: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/12.jpg)
FME Processing Stages
1. Export Smallworld data to SHAPE file format 2. Merge address data with meter points 3. Move customer (meter) points onto gas main 4. QA/QC pipe diameter 5. QA/QC core customer file 6. Distinguish industrial vs residential/commercial
customers (Core Customers) 7. Assign work order attribute
![Page 13: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/13.jpg)
1.Extract Smallworld to SHAPE format
![Page 14: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/14.jpg)
2.Feature Merge Addresses with Meters
Address database extracted from Smallworld intoMDB format
![Page 15: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/15.jpg)
2.Feature Merge Addresses with Meters
![Page 16: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/16.jpg)
Customer Connections (Desired Result)
![Page 17: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/17.jpg)
3. Customer Connection Creator
![Page 18: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/18.jpg)
3. Customer Connection Creator
Meters (Address\Premise IDs)
Distribution Pipes
Service Pipes
![Page 19: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/19.jpg)
3. Customer Connection Creator
![Page 20: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/20.jpg)
3. Customer Connection Creator
![Page 21: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/21.jpg)
3. Customer Connection Creator
![Page 22: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/22.jpg)
3. Customer Connection Creator
![Page 23: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/23.jpg)
4. QA\QC Pipe Diameters
![Page 24: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/24.jpg)
5. QA\QC Core Customers
![Page 25: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/25.jpg)
6. Industrial vs. Residential/ Commercial Customers
![Page 26: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/26.jpg)
7. Assign Work Order Information
![Page 27: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/27.jpg)
Deliverables
![Page 28: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/28.jpg)
Conclusion
Standard file format (ESRI Shape)
One hydraulic modeling software
Excellent support from Safe Software
We saved $$$$$$
![Page 29: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/29.jpg)
Future Plans
Automation of process
Self serve options for System Planners
![Page 30: Hydraulic Modelling with GIS Data](https://reader036.vdocuments.us/reader036/viewer/2022062303/557af243d8b42a7e608b5007/html5/thumbnails/30.jpg)
Thank You!
Questions?
For more information: Ted Norcott [email protected] Harry Bhandal [email protected]
www.fortisbc.com