Using Logical Decomposition to Simplify Complex Data

Report 9 Downloads 40 Views
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