PROFESSIONAL PETROLEUM DATA MANAGEMENT ASSOCIATION
Using Logical Decomposition to Simplify Complex Data Trudy Curtis, CEO PPDM Association
1
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
WHY I’M TALKING ABOUT THIS SUBJECT
ü Today’s data professional handles a lot of data and information … § … from many different sources… § … that may have been altered by someone else … § … in mostly undocumented ways!
ü It’s helpful to think about the data logically and to question everything ü Research and clarity are important § But it’s hard work § And it goes better if we do it together and share the results 2
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
EVEN THE WORDS WE USE TO MEAN STATUS ARE VAGUE! Status
I’m Function
going to call them Classification
all “Well Status” today.
Role 3
5/20/2014
Type Copyright 2014, PPDM Association. All Rights Reserved
WELL STATUS IS VERY USEFUL
ü Well Status helps us to find wells ü They are used by every stakeholder to find wells that meet common criteria
ü Most of the time, well status can be derived based on business rules § But ONLY if you know what the business rules are!
ü Once found, symbols based on status helps us to create meaningful maps and reports. 4
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
IHS COMPLETE WELL STATUS CODES INTENDED TO BE VERY COMPLETE http://energy.ihs.com/NR/rdonlyres/2F43A1DD-2FB0-40C1-8C9A-1C5010F238EB/0/WellStatus.pdf
5
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
WELL STATUS VALUES ARE VERY COMPLICATED! Life Cycle Historical Information Fluid Type Non specific, unclear Fluid Direction
The underlying rules used to derive are variable. 6
5/20/2014
Fluid Abundance Field Work Status Function Regulatory Process Copyright 2014, PPDM Association. All Rights Reserved
A “RELATIVELY” SIMPLE EXAMPLE Planning
Permitting
Constructing
Operating
Disposing
Approved
Submitted
Spudded
Producer
Temporarily abandoned
Rejected
Approved
Drilled / cased
Injector
Abandoned
…
Plugged and Abandoned
Denied
Completed
Cancelled
Terminated 7
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
WHAT IS DECOMPOSITION?
ü Find the embedded meaning Faceted taxonomies ü Decompose into constituent semantics are designed to ü Name and define atomically. support this
8
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
15 KINDS OF INFORMATION HAVE BEEN IDENTIFIED AND DEFINED Business Life Cycle Phase is a collection of activities and conditions, that are grouped according to business significance, describing where an E&P asset (in this case a well) is at within its progressive history. Phases are related to business significance and are not related to time. Business Life Cycle Phase is relevant for wells that the E&P company has a Business Interest in. The value of the Business Life Cycle Phase is expected to change in a predictable manner as the well progresses through out its history and may reoccur as various operations are executed.
9
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
STARTER SETS OF VALUES For each of the 15 kinds of information, a starter set of values has been created.
10
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
WELL STATUS: COMPLEX VALUES CAN BE DECOMPOSED Well (general entity)
Wellbore
Business Life Cycle Phase Operatorship
Business Interest
Business Intention
Role
Outcome
Trajectory Type
Lahee Class
Wellbore Status
WellStatus.PPDM.org Status Type
Status Value
Well Structure
Wellbore Status
Abandoned
Fluid Direction
Fluid Type
Oil & Gas
Well Reporting Class
Role
Produce
N
Well Status In-Active
Y
Fluid Direction
Y
Play Type
Fluid Type Well Status 11
ABANDONED COMBINATION OIL & GAS PRODUCER
5/20/2014
Static
Qualifier Type
Qualifier Value
Active? Y
Abundance Primary
N
Copyright 2014, PPDM Association. All Rights Reserved
FACET DECOMPOSITION Current Status Code
Current Status Name
Primary Fluid
1G1WIW
1 GAS & 1 WATER INJECTION WELL WORKOVER
Gas
Produce
Commercial
Water
Inject
Success
Producing
1O&1GI
1 OIL & 1 GAS INJECTION WELL
Oil
Produce
Commercial
Gas
Inject
Success
Producing
2O&5G
2 OIL & 5 GAS
Oil & Gas
Produce
Commercial
Success
Producing
2O1GIW
2 OIL & 1 GAS INJECTION WELL WORKOVER
Oil
Produce
Commercial
Success
Producing
GAS
GAS PRODUCER
Gas
Produce
Commercial
Success
Producing
GI-OG
GAS INJECTION WELL-OIL & GAS SHOWS
Gas
Inject
OIL
OIL PRODUCER
Oil
Produce
OSTWOG
OIL STORAGE WELL-OLD WELL WORKED OVER-OIL & GAS SHOWS
Oil
Storage
Oil & Gas
Shows
SUS-OG
SUSPENDED WELL-OIL & GAS SHOWS
No Current Role
Oil & Gas
Shows
WIWO
WATER INJECTION WELL-OLD WELL WORKED OVER-OIL SHOWS
Inject
Oil
Shows
Water
Primary Primary Secondary Secondary Role Fluid Abund Fluid Role
Gas
Oil & Gas
Secondary Wellbore Fluid Outcome Status Abundance
Inject
Shows
Commercial
Injecting Success
Unsuccessfu Suspended l
12 12
5/20/2014
Producing
Copyright 2014, PPDM Association. All Rights Reserved
Injecting
HOW DOES IT WORK IN THE US? INTERNATIONALLY?
ü Industry is using Well Status and Classification information to help create commonality between different regulatory datasets.
ü Mapping and harmonizing the lists is difficult § State lists are not all the same § State lists may not be defined in regulations § State lists have varying levels of granularity.
ü If we want to make the mappings consistent, what do we need to do? ü Would regulators benefit from this Process? 13
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
PROCESS
ü Found representative data sets for § Well status § Well type § Product type § Permit status …
ü Used a few regulatory areas § Texas, Ohio, New York, Louisiana, Colorado, Utah, Wyoming, Ontario, Michigan, Missouri
ü Compared what is in the datasets to what is in Well Status And Classification datasets 14
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
A LOT OF THE VALUES MAP VERY NICELY… IF YOU MAKE SOME ASSUMPTIONS! State
CODES
FULL NAME
Business Life Cycle Lahee Class Phase
TX RRC
B
Oil & Gas
Producing
TX RRC
O
Oil
Producing
NY DEC
IW
Development
Inject
Inflow
NY DEC
OD
Enhanced Oil Recovery - Injection Oil Development Producing
Development
Produce
Outflow
Oil Well
Oil
Primary
NY DEC
OE
Oil Extension
Producing
Extension
Produce
Outflow
Oil Well
Oil
Primary
NY DEC
OW
Oil Wildcat
Producing
New-Pool Wildcat Produce
Outflow
Oil Well
Oil
Primary
NY DEC
OW
Oil Well
Producing
Produce
Outflow
Oil Well
Oil
Primary
LA DNR
10
OIL
Producing
Produce
Outflow
Oil Well
Oil
Primary
Oil Well
Producing
Produce
Outflow
Oil Well
Oil
Primary
Producing Oil Well
Producing
Produce
Outflow
Oil Well
Oil
Primary
Utah OW OGM Wyoming PO GCC15 5/20/2014
Role
Fluid Well Fluid Type Direction Reporting Class Oil & Gas
Produce
Abundance
Oil
Copyright 2014, PPDM Association. All Rights Reserved
DISCOVERIES: SEMANTIC DIFFERENCES
ü What is an “Active” well? ü What is a “Producing” well? ü Abandoned vs. Plugged vs. P&A
16
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
DISCOVERIES: NEED TO INFER OR DERIVE
ü Sometimes no consistent meaning can be reasonably inferred by a nonregulatory user without a lot of research.
§ Makes queries difficult for users
ü Sometimes the information is not contained in a coded “status”, but might be found elsewhere in filings
§ Outcome à might be inferred § Fluid direction à might be inferred § Play type, well structure, trajectory are more difficult
17
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
DISCOVERIES: RELEVANCE TO STAKEHOLDERS Regulators: Not Relevant
Regulators: Relevant
• Outcome
• Business Life Cycle Phase
• Operatorship
• Lahee Class (rare)
• Business Intention
• Fluid Type
• Well Structure
• Fluid Direction
• Business Interest
• Well Reporting Class (maybe)
• Role
• Well Status • Wellbore Status (maybe)
What most public users want
Regulatory Objectives
Ø Did that well get “constructed”?
Ø Are you following the rules?
Ø Is stuff coming out of or going into it?
Ø Is the reservoir managed?
Ø What is that stuff?
Ø Are royalties due us?
DISCOVERIES: LEVEL OF DETAIL
Common Detail
Fluid type Business life cycle Regulatory life cycle
Where is the dividing line?
Extra Detail
19
5/20/2014
Detailed drilling status Data obtained
Copyright 2014, PPDM Association. All Rights Reserved
PLUG AND ABANDON State NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC LA DNR LA DNR LA DNR LA DNR LA DNR LA DNR CO GCC CO GCC CO GCC CO GCC CO GCC Utah OGM Utah OGM Utah OGM Wyoming Wyoming Wyoming Wyoming Wyoming Wyoming 20
5/20/2014
CODES AR PA PM TA AB GWP OWP SP SMP OP 18 27 28 29 30 35 AB AL DA PA TA TA PA LA TA PA NI SR TA PA
FULL NAME Application Received to Drill/Plug/Convert Plugged and Abandoned Plugged Back Multilateral Temporarily Abandoned Abandoned Location Gas Well Plugged Oil Well Plugged Storage Well Plugged Solution Brine Well Plugged Other Well Plugged* TEMPORARILY ABANDONED WELL ABANDONED SWD - NOT PLUGGED UNABLE TO LOCATE WELL-NO PLUGGED AND ABANDONED DRY AND PLUGGED PLUGGED AND ABANDONED PLUGGED BACK - NO PERFORATIONS - NO LUW ABANDONED WELLBORE OR COMPLETION ABANDONED LOCATION DRY AND ABANDONED PLUGGED AND ABANDONED TEMPORARILY ABANDONED Temporarily-abandoned Plugged & Abandoned Location Abandoned Temporarily Abandoned Permanently Abandoned Notice of Intent to Abandon Subsequent Report of Abandonment Temporarily Abandoned Permanently Abandoned
State TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC TX RRC OHIO OHIO OHIO OHIO OHIO OHIO NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC NY DEC LA DNR LA DNR LA DNR LA DNR LA DNR LA DNR
CODES FULL NAME D Plug Dry Hole -- Plugged and Abandoned (W-3) H Plug Dry Hole -- Plugged and Abandoned Letter K Plugged and Abandoned Sulphur Core Test L Plug Back M Core Test (Plugged and Abandoned) O Plug Dry Hole (oil) P Plug Dry Hole (gas) Q Plug Fresh Water R Plug Stat Test S Plug Dry Hole (Explorate) V Plug Uranium Test X Lignite Exploration (Plugged and Abandoned) D Dry Hole -- Plugged and Abandoned (W-3) T Plugged and Abandoned Exploratory Test Well A Abandoned P Re-enter to Plug DA Dry and Abandoned PA Plugged and Abandoned PB Plugged Back RP Replugged Well TA Temporarily Abandoned WW Plugged Back for Water Well AR Application Received to Drill/Plug/Convert PA Plugged and Abandoned PM Plugged Back Multilateral TA Temporarily Abandoned AB Abandoned Location GWP Gas Well Plugged OWP Oil Well Plugged SP Storage Well Plugged SMP Solution Brine Well Plugged OP Other Well Plugged* 18 TEMPORARILY ABANDONED WELL 27 ABANDONED SWD - NOT PLUGGED 28 UNABLE TO LOCATE WELL-NO PLUGGED AND ABANDONED 29 DRY AND PLUGGED 30 PLUGGED AND ABANDONED 35 PLUGGED BACK - NO PERFORATIONS - NO LUW
Operator processes Data obtained Fluids or substances identified Regulatory processes or reports Well outcome Well type or purpose Well configuration Time (temporary, permanent)
Copyright 2014, PPDM Association. All Rights Reserved
NEW FACET LIFE CYCLE: END OF LIFE
Disposing
Current
Temporarily Abandoned Permanently Abandoned
Recommended
Disposing Plugged Plugged and Abandoned 21
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
NEW FACET LIFE CYCLE: PERMITTING Proposed Active Approved Inactive Denied Permitting Cancelled
Add this? Expired Terminated 22
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
SUMMARY
ü A savvy users knows that nothing can be assumed ü It’s best to go back to the trusted authority if you can ü Working together to sort out these problems is better ü There is value to everyone if we can begin to converge in practice!
23
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved
PROFESSIONAL PETROLEUM DATA MANAGEMENT ASSOCIATION
Just a taste of what is needed Thanks for your input! Trudy Curtis
[email protected] 24
5/20/2014
Copyright 2014, PPDM Association. All Rights Reserved