thumbnail

Data cleaning methodology for monthly water-to-oil and water-to-gas production ratios in continuous resource assessments

Open-File Report 2016-1204

By:
, , and
DOI:10.3133/ofr20161204

Links

  • Document: Report (4.26 MB pdf)
  • Data Release: USGS Data Release Data cleaning methodology source code—Creating water-to-oil and water-to-gas ratios in sequence from start of production using the IHS PIDM database
  • Download citation as: RIS

Abstract

Petroleum production data are usually stored in a format that makes it easy to determine the year and month production started, if there are any breaks, and when production ends. However, in some cases, you may want to compare production runs where the start of production for all wells starts at month one regardless of the year the wells started producing. This report describes the JAVA program the U.S. Geological Survey developed to examine water-to-oil and water-to-gas ratios in the form of month 1, month 2, and so on with the objective of estimating quantities of water and proppant used in low-permeability petroleum production. The text covers the data used by the program, the challenges with production data, the program logic for checking the quality of the production data, and the program logic for checking the completeness of the data.

Suggested Citation

Varela, B.A., Haines, S.S., and Gianoutsos, N.J., 2017, Data cleaning methodology for monthly water-to-oil and water-to-gas production ratios in continuous resource assessments: U.S. Geological Survey Open-File Report 2016–1204, 11 p., https://doi.org/10.3133/ofr20161204.

ISSN: 2331-1258 (online)

Table of Contents

  • Abstract
  • Introduction
  • Variations in Data Sources
  • Difficulties and Challenges of Disordered Data
  • Data Cleaning Strategy
  • Cleaning Algorithm
  • Checking Completeness of Water-to-Oil/Gas Calculation
  • Summary
  • References

Additional publication details

Publication type:
Report
Publication Subtype:
USGS Numbered Series
Title:
Data cleaning methodology for monthly water-to-oil and water-to-gas production ratios in continuous resource assessments
Series title:
Open-File Report
Series number:
2016-1204
DOI:
10.3133/ofr20161204
Year Published:
2017
Language:
English
Publisher:
U.S. Geological Survey
Publisher location:
Reston, VA
Contributing office(s):
Central Energy Resources Science Center
Description:
Report: ii, 11 p.; Data Release
Online Only (Y/N):
Y