The PODS Data Model International Standard for Petroleum and Natural Gas Pipelines

1. The PODS Data Model International Standard for Petroleum and Natural Gas Pipelines Janet Sinclair, P. E. Executive Director PODS Association, Inc.

2. Agenda • What is PODS? • Members of PODS • PODS and APDM • PODS Relational and PODS Esri Spatial • Components of the PODS Model • How to Join PODS? • PODS Resources

3. What is PODS? • PODS is the recognized industry standard pipeline data model. • PODS provides Pipeline Operators with an enterprise database architecture that is open, vendor-neutral, highly-scalable, and proven. • PODS is the industry best practice for pipeline data management.

4. What is PODS? • PODS is a foundational component of the IT enterprise for pipeline companies. • PODS allows Pipeline Operators to integrate critical life-cycle data and recordswith geospatial location. • Asset information and records • External documents • Inspections • Analysis

5. What is PODS? PODS Mission The PODS Association’s mission is to develop and support open data storage and interchange standards to meet the needs of the pipeline industry. open

6. Why is Open Important? Pipeline Open Data Standard (PODS) • PODS is built based upon the input of many pipeline companies. • Many service providers build their products to interact with the PODS structure. Pipeline Operators who use PODS are not handcuffed to a single vendor’s software applications.

7. What is PODS? • PODS is a voluntary pipeline data standard, collaboratively developed and maintained by the pipeline industry. • PODS was built by Pipeline Operators, for Pipeline Operators. • PODS Association is a membership-based, not-for-profit industry association.

8. What is the PODS Association? Board of Directors Authorized Users Executive Director Technical Committee

9. PODS Leadership PODS Board of Directors President Paul Herrmann Chevron Vice President Elizabeth Ziemer Enbridge Secretary Tim Willms Boardwalk Treasurer Kenneth Greer CenterPoint PODS Executive Director Janet Sinclair, P. E. Jeff Allen Coler & Colantonio Rob Brook PG & E Ron Brush New Century Software Board TC Liaison Dan Palazzolo Williams Mike King BP JW Lucas Enterprise Products Scott Moravec Eagle Info. Mapping PODS Technical Committee Data Modeling Team Administration Team Research & Development Team PODS ESRI Spatial Team Release Coordinators

10. Technical Committee (TC) Chad Corcoran Chesapeake Costas Kotzabassis Mahindra Satyam Release Coordinators Administration Data Modeling Research & Development PODS ESRI Spatial Chairperson Michael Emanuel AeroMetric Chairperson Christopher Moravec Eagle Info. Mapping Chairperson Luke Hutmacher Willbros Engineering Chairperson ArunaGubba Enterprise Products Terry Allen GeoFields Rod Burden Moore Resources ShylaLiebscher J P Kenny Lee Davis WorleyParsons Kirk Cameron New Century Software Janice Fisher Eagle Info. Mapping Narmina Lovely BP Michael Ray GeoFields Dion Duran Enterprise Products Gary Hoover Enterprise Products Eric Thomsen Coler & Colantonio Tracy Thorleifson Eagle Info. Mapping Olga Ingerman Fluor Douglas Thorpe DCP Midstream Peter Veenstra Willbros Engineering Marsh Wong Chevron Teresa Young GeoFields

11. Current Membership * Many PODS member companies have global operations.

12. Current Membership

13. Current Membership Pipeline Operating Companies

14. PODS Relational and GIS • PODS Relational is deployed on Oracle or SQL Server. • PODS Relational is designed to work with a GIS. • PODS Relational is not dependent upon a GIS. • A GIS is used to view the spatial representation of the data within the PODS database. • PODS data may be spatialized in any GIS. • Many software applications are available to manage data within PODS through a GIS interface. The PODS Relational Database

15. PODS Esri Spatial • PODS Esri Spatial is an implementation of the PODS Standard. • PODS Esri Spatial includes the same tables, attributes, and domains of the PODS Standard, but is designed specifically for an Esri SDE deployment. • Releases of PODS Esri Spatial are maintained in-step with PODS Relational. The PODS Esri Spatial Geodatabase

16. PODS Over Time 5 Fold Increase In Breadth 14 Years

17. Components of the Model Stationed Centerline (the Core)

18. Components of the Model Location (X, Y, Z)

19. Components of the Model Pipeline Facilities

20. Components of the Model Geographic Features & Crossings

21. Components of the Model Cathodic Protection

22. Components of the Model Site Facilities

23. Components of the Model Compression

24. Components of the Model Offline Events

25. Components of the Model Physical Inspections

26. Components of the Model Cathodic Protection Readings

27. Components of the Model Inline Inspections

28. Components of the Model Close Interval Survey Readings

29. Components of the Model Stress Corrosion Cracking Potential

30. Components of the Model Leak Survey

31. Components of the Model Reports & External Documents

32. Components of the Model Alignment Sheet Information

33. Components of the Model Operating Measures

34. Components of the Model Work Orders and Maintenance

35. Components of the Model Boundary Tables

36. Components of the Model Damage Prevention and One Call

37. Components of the Model Repairs

38. Components of the Model Regulatory Compliance

39. Components of the Model Risk Analysis

40. Components of the Model Offshore Offshore Pipelines & Associated Facilities

41. PODS Supports the Enterprise • Regulatory Compliance • Spatial Analysis • Integrity Management • Hydraulic Modeling • Web-based Mapping • Public Awareness • Business Development • Regulatory Reporting • Emergency Response Planning • Corrosion Prevention • Repairs and Maintenance • Strategic Planning • Right-of-Way Management • Risk Analysis • Field Data Collection and Verification • Pipeline Damage Prevention • One Call ticket and Boundary Analysis • Financial and Property Tax Accounting • Internal Company Education • Pipeline Engineering and Field Operations

42. Several active work groups and industry collaborations • NACE, IPLOCA, OGP, GTI, PPDM, Energistics, OGC • 2012 Releases of the PODS Data Model • PODS Esri Spatial 5.1.1 (August) • PODS 6.0 (Release for member comment on September 17th) • PODS Open Spatial (Release for member comment in October) • 8th Annual User Conference • 2012 registration was 267, a 34% increase PODS is an active and growing organization

43. PODS 6.0 Modularized PODS • In PODS 6.0, only the Core is required, all other modules are optional and largely independent. • Modularization will allow new member companies to select the parts of the model they wish to deploy. • PODS 6.0 will be released for member comment on Monday, September 17, 2012.

44. Joining PODS • Membership in the PODS Association • One membership per cooperation, includes all employees and subsidiaries. Membership is renewed annually. • Small Pipeline Operator $2,000* • Large Pipeline Operator $5,000** • Service Provider $2,000 • Government Agency $ 500 * Pipeline Operators having less than 1,000 miles (1,609 km) of transmission, less than 1,000 miles (1,609 km) of gathering, and less than 100,000 customer distribution meters ** All other Pipeline Operators

45. Benefits of Membership 1 – Legal use of the PODS Pipeline Data Model 2 – Receive new releases of the PODS Model and documentation 3 – Unlimited access to PODS online resources 4 – Voting in PODS elections 5 – Advanced review of new releases 6 – Opportunity for representation on the PODS Board of Directors and Technical Committee 7 – Recognition as a PODS member 8 – Learn from pipeline data managers from around the globe 9 – Network with other PODS users 10 – No cost to attend the PODS User Conference

46. www.pods.org User Presentations Association Information News & Events Membership Information Entity Relationship Diagrams --- (for members) Download the Model DDL for Oracle DDL for SQL Server XML for ArcSDE Download the PODS Data Dictionary and Documentation PODS Technical Forum

47. Questions? Janet Sinclair, P. E. janet.sinclair@pods.org 801-583-1013 866-460-PODS www.pods.org