The PODS Data Model International Standard for Petroleum and Natural Gas Pipelines Janet Sinclair, P. E. Executive Director PODS Association, Inc.
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
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.
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
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
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.
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.
What is the PODS Association? Board of Directors Authorized Users Executive Director Technical Committee
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
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
Current Membership * Many PODS member companies have global operations.
Current Membership Pipeline Operating Companies
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
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
PODS Over Time 5 Fold Increase In Breadth 14 Years
Components of the Model Stationed Centerline (the Core)
Components of the Model Location (X, Y, Z)
Components of the Model Pipeline Facilities
Components of the Model Geographic Features & Crossings
Components of the Model Cathodic Protection
Components of the Model Site Facilities
Components of the Model Compression
Components of the Model Offline Events
Components of the Model Physical Inspections
Components of the Model Cathodic Protection Readings
Components of the Model Inline Inspections
Components of the Model Close Interval Survey Readings
Components of the Model Stress Corrosion Cracking Potential
Components of the Model Leak Survey
Components of the Model Reports & External Documents
Components of the Model Alignment Sheet Information
Components of the Model Operating Measures
Components of the Model Work Orders and Maintenance
Components of the Model Boundary Tables
Components of the Model Damage Prevention and One Call
Components of the Model Repairs
Components of the Model Regulatory Compliance
Components of the Model Risk Analysis
Components of the Model Offshore Offshore Pipelines & Associated Facilities
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
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
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.
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
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
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
Questions? Janet Sinclair, P. E. firstname.lastname@example.org 801-583-1013 866-460-PODS www.pods.org