MEMORANDUM

TO: Lisa Biddle, U.S. EPA

FROM: Brent Ruminski, ERG

DATE: March 31, 2015

SUBJECT: Analysis of DI Desktop® (DCN SGE00963)

This memorandum describes ERG’s analysis of Drillinginfo’s (DI) Desktop® Well File 

Database that ERG used to supplement other analyses for the Technical Development Document 

for Proposed Effluent Limitations Guidelines and Standards for Oil and Gas Extraction (DCN 

SGE00704) (hereafter, referred to as the TDD). Specifically, this memorandum focuses on how 

ERG developed a database of active unconventional oil and gas (UOG) wells from Drillinginfo’s 

nationwide database of all oil and gas wells. Table 1 lists the relevant TDD tables and/or figures 

and the TDD analyses supported by this database called DI Desktop® Development Database

(DCN SGE00963.A01). TDD tables and figures not listed in Table 1 either did not require 

calculations and/or analyses by ERG or are described in separate, supporting memoranda.

Appendix F of the TDD contains a crosswalk of all tables and figures in the TDD and the name 

of the relevant supporting memorandum, where applicable. This memorandum is organized into 

the following sections:

 Section 1.0 provides background information about the DI Desktop® database and 

the purpose of this analysis.

 Section 2.0 discusses how ERG analyzed the DI Desktop® database.

 Section 3.0 summarizes the results of the DI Desktop® database analysis and how 

they compare to literature.

 Section 4.0 describes ERG’s quality assurance procedures.

 Section 5.0 lists the references used for these analyses.

 Section 6.0 provides the Microsoft Access® database attachment.

This memorandum will refer to the term UOG. EPA defines UOG resources1as crude oil 

and natural gas2produced by wells drilled3into low porosity, low permeability formations.

Development of UOG resources often requires hydraulic fracturing of the reservoir rock by 

injecting large amounts of fracturing fluid at high pressures to create a network of fissures in the 

rock formations, giving the oil and/or natural gas a pathway to travel to the well for extraction. 

While coalbed methane (CBM) is sometimes referred to as an unconventional resource in 

 

1 UOG resource types are categorized into shale and tight formations.

2 Natural gas can include “natural gas liquids,” components that are liquid at ambient temperature and pressure.

3 Oil and gas wells may be drilled using horizontal, vertical, or directional well trajectories. Drillinginfo refers to 

well trajectory as “drill type”.
Memorandum

March 31, 2015

Page 2

literature, it is not included within the scope of the TDD. As such, the term UOG does not 

include CBM wells when used in this memorandum.

Table 1. Other UOG Analyses Supported by this Memorandum

TDD 

Chapter Supporting Analysis

TDD Table or 

Figure Number

Supporting Analysis 

DCN

B UOG Potential by Resource Type as of January 1, 2012 Table B-3

a

SGE00693.A02

C

DI Desktop® Long-term Produced Water Rates Table C-7 & C-8

b

SGE00724.A02 and A03

FracFocus® Fracturing Fluid Volumes Table C-6 & C-8

b

SGE00724.A04 and A05

New Mexico Flowback Recovery Table C-6 & C-8

b

SGE00724.A07

Wyoming Flowback Recovery Table C-6 & C-8

b

SGE00724.A10

Niobrara Flowback Recovery Table C-6 & C-8

b

SGE00724.A12

a— Methodology used to generate this table is explained in ERG’s memorandum titled Data Compilation 

Memorandum for the Technical Development Document (TDD) for Proposed Effluent Limitations Guidelines and 

Standards for Oil and Gas Extraction – DCN SGE00693.

b— Methodologies used to generate these tables are explained in ERG’s memorandum titled Unconventional Oil 

and Gas (UOG) Produced Water Volumes and Characterization Data Compilation – DCN SGE00724.

1.0 DI DESKTOP® DEVELOPMENT DATABASE BACKGROUND

Drillinginfo is an oil and gas research firm located in Austin, Texas. DI Desktop®is a

comprehensive database generated by Drillinginfo that contains a record (i.e., row) for all oil and 

gas wells drilled in the United States. 4 Drillinginfo uses oil and gas databases maintained by 

individual state oil and gas agencies to create the DI Desktop®database. For this analysis, ERG 

downloaded a version of the DI Desktop®database on January 5, 2012. For the most part, this

version of DI Desktop® reflects wells drilled the second half of 2011. State-level information 

such as the oil and gas agency names, last production date5, production start date6, and update 

frequency (e.g., monthly, quarterly) is provided in Drillinginfo’s Data Coverage table (DCN 

SGE01027). The raw DI Desktop®database ERG used for this analysis is contained in the 

“HDPI_EXPRT” table of Attachment 1 (DCN SGE00963.A01) in addition to DCN SGE00520. 

Basic well data contained in the DI Desktop®for each well includes: well API number7,

location, operator, and well trajectory. DI Desktop®also includes annual oil, gas, and produced 

water production per well. Table 2 provides the complete list of data fields in the DI Desktop® 

database. The fields ERG used either in this analysis or other TDD supporting analyses are 

marked with an asterisk. All other fields were not used by ERG. 

 

4 The database is subject to restrictions on its use and dissemination. Based on the license agreement discussions, 

access to the raw data in the database is limited to ERG and EPA personnel only; although summary data developed 

using queries can be disseminated more widely. Wholesale “data dumps” cannot be disseminated electronically. All 

disseminations of such summary data, however, should cite Drillinginfo as the source of the information.

5 This is the date that the state last updated the data that Drillinginfo included in ERG’s version of the DI Desktop® 

database downloaded on January 5, 2012.

6

First year that the state agency maintained records for oil and gas wells. 

7 An API number is a unique identifier assigned to each well drilled for oil and gas in the United States. The API 

number was originally assigned based on standards established by the American Petroleum Institute (API). 
Memorandum

March 31, 2015

Page 3

The DI Desktop® database includes records for wells that are no longer active (i.e., shut 

in), underground injection wells8that do not produce oil and gas, conventional oil and gas 

(COG) wells, CBM wells, and UOG wells. It does not, however, contain a field that indicates if 

wells are conventional or unconventional. Section 2.0 describes how ERG determined which 

active wells in the raw database are drilled into UOG formations.

Table 2. Field Names and Descriptions in the DI Desktop® Database

Field Name Description

ENTITY_ID* HPDI assigned ID unique to a given property. A well is referred to as a “property” in 

the DI Desktop database.

API_NO* API assigned number of a well on the property.

PROPERTY_TYPE Property type (e.g., lease, unit, well, completion, other, unknown).

PRODUCTION_TYPE* Production type (e.g., oil, gas, injection).

WELL_NAME Operator assigned well/lease name of the property.

FIELD Field name the property is reporting from.

LEASE_NO State number assigned to the property or lease or unit the property is part of.

WELL_NO Operator assigned well number of the property.

CURR_OPER_NAME Current operator name.

LIQ_GATH_NAME_1 Current primary liquid gatherer for a property.

GAS_GATH_NAME_1 Current primary gas gatherer for a property.

SPUD_DATE* Latest date drilling commenced on property.

COMMON_OPER_NAME Corporate entity that is determined by HPDI to own the current operator.

LATITUDE Latitude the property is located in

LONGITUDE Longitude the property is located in

LOCATION Township the property is located in.

COUNTY County the property is located in.

DISTRICT District within a given state the property is assigned.

STATE* State the property is located in.

OFFSHORE Offshore waters indicator.

RESERVOIR Reservoir, formation, zone, or pool that the property is reported as producing from.

SECTION Section property is located in.

QTR_QTR Quarter the property is located in (note: Texas only).

MERIDIAN Meridian legal description is referenced from.

BASIN* The basin the property is located in.

STATUS* Current status of the well (e.g., active, inactive, shut in).

TOTAL_DEPTH Total depth the well was drilled to.

COMPLETION_DATE* Latest completion date of the well.

DRILL_TYPE* This is the configuration of the wellbore (equivalent to EPA’s use of “well 

trajectory”). Options include: H – Horizontal; D – Directional; V – Vertical; U –

Unknown. 

FORMATION* Formation that the property is reported as producing from. 

 

8

For more information about underground injection wells, see ERG’s TDD supporting memorandum titled Analysis 

of Active Underground Injection for Disposal Wells - DCN SGE00736.
Memorandum

March 31, 2015

Page 4

Table 2. Field Names and Descriptions in the DI Desktop® Database

Field Name Description

LATEST_FLOW_PRESS

URE

Latest flow pressure reported. Note: for instances where duplicate API numbers were 

combined, the minimum value was selected.

LATEST_WHSIP Latest well head shut-in pressure reported. Note: for instances where duplicate API 

numbers were combined, the minimum value was selected.

SumOfLIQ_DAILY Average daily liquid production in last 12 months.

SumOfGAS_DAILY Average daily gas production in last 12 months.

SumOfLIQ_CUM Cumulative liquid production of property.

SumOfGAS_CUM Cumulative gas production of property.

SumOfWRT_CUM Cumulative water production of property.

LAST_PROD_DATE* Last date production was reported for the property.

SumOfLIQ_YEAR Oil production reported in barrels in the 12 months ending with 

LAST_PROD_DATE.

SumOfGAS_YEAR Gas production reported in MCF in the 12 months ending with LAST_PROD_DATE.

SumOfWTR_YEAR Water production reported in barrels in the 12 months ending with 

LAST_PROD_DATE.

LATITUDE_BOTM Bottom hole latitude of the property.

LONGITUDE_BOTM Bottom hole longitude of the property.

SumOfLIQ07 Oil production in barrels for 2007.

SumOfGAS07 Gas production in thousand cubic feet for 2007.

SumOfWTR07* Water production in barrels for 2007.

SumOfLIQ08 Oil production in barrels for 2008.

SumOfGAS08 Gas production in thousand cubic feet for 2008.

SumOfWTR08* Water production in barrels for 2008.

SumOfLIQ09 Oil production in barrels for 2009.

SumOfGAS09 Gas production in thousand cubic feet for 2009.

SumOfWTR09* Water production in barrels for 2009.

SumOfLIQ10 Oil production in barrels for 2010.

SumOfGAS10 Gas production in thousand cubic feet for 2010.

SumOfWTR10* Water production in barrels for 2010.

SumOfLIQ11 Oil production in barrels for 2011.

SumOfGAS11 Gas production in thousand cubic feet for 2011.

SumOfWTR11* Water production in barrels for 2011.

PROD09 Yes/No flag indicating if oil and/or gas production was greater than zero in 2009.

PROD10 Yes/No flag indicating if oil and/or gas production was greater than zero in 2010.

PROD11 Yes/No flag indicating if oil and/or gas production was greater than zero in 2011.

ACTIVE_FLAG Yes/No flag indicating active status based on production

ACTIVE_PROD_FLAG Yes/No flag indicating whether entity is active (using the ACTIVE_FL field) and had 

production in 2011 (using the PROD11 field).

SHALE_FLAG Yes/No flag for Pennsylvania only indicating if the type of production is shale gas.

TEST_DATE Date of the most recent well test.

TEST_TIMES_TESTED Total number of times the well was tested.

TEST_GAS_CUM Cumulative reported gas at the time of the most recent well test.
Memorandum

March 31, 2015

Page 5

Table 2. Field Names and Descriptions in the DI Desktop® Database

Field Name Description

TEST_GOR Gas to oil ratio at the time of the most recent well test.

TEST_FLOW_PRES Well head flowing pressure at the time of the most recent well test.

TEST_FLOWOZ Flowing pressure divided by Z-Factor at the time of the most recent well test.

TEST_WHSIP Well head shut-in pressure at the time of the most recent well test.

TEST_SIPOZ Bottom hole pressure divided by the Z-Factor, if well head shut-in pressure is 

provided at the time of the most recent well test.

TEST_GAS_GRAVITY Gas gravity at the time of the most recent well test.

TEST_LIQ_GRAVITY Liquid gravity at the time of the most recent well test.

TEST_GAS_VOLUME Daily gas production at the time of the most recent well test.

TEST_WAT_VOLUME Daily water production at the time of the most recent well test.

TEST_LIQ_VOLUME Daily liquid production at the time of the most recent well test.

TEST_TYPE Type of test conducted for the most recent well test.

TEST_CHOKE_SIZE Choke used during the most recent well test.

TEST_TBG_PRES Pressure present in the tubing at the time of the most recent well test.

2.0 ANALYSIS METHODOLOGY

The following steps describe how ERG used the raw DI Desktop® database to make a 

list of active oil and gas extraction wells drilled into UOG formations. These steps outline the 

queries in Attachment 1 (DCN SGE00963.A01).

Step 1 – Create Production Type Crosswalk

The raw DI Desktop® database contains many different types of wells including those 

where the primary purpose is not oil and gas extraction (e.g., injection for enhanced recovery). 

The type of well is indicated by the PRODUCTION_TYPE field. However, due to terminology 

differences between state oil and gas agencies, there are 441 combinations of production types in 

the DI Desktop® database9. Therefore, ERG created a crosswalk to identify the production types 

that represent oil and gas extraction. Table 3 shows a few examples of the most common 

production types reported and those that ERG flagged as oil and/or gas extraction. The full 

crosswalk is in the table called “Prod Type Crosswalk” in Attachment 1 (DCN

SGSE00963.A01). Section 3.0 discusses data quality related to this crosswalk.

 

9

For example, most North Dakota wells are reported as “O&G” production types but in Texas, most wells are 

classified as “OIL”, “GAS”, or “OIL,GAS”.
Memorandum

March 31, 2015

Page 6

Table 3. Examples from the Production Type Crosswalk

Production Typea Oil and/or Gas Extraction Well Flagb Number of Wells with Production Typec

OIL Yes 989,903

GAS Yes 668,078

(N/A) No 475,546

O&G Yes 229,143

DRY No 173,213

CBM Yes 78,200

SW INJ No 37,564

INJ No 33,496

GAS,OIL Yes 29,752

a—This is the well type reported in the PRODUCTION_TYPE field in the DI Desktop® database.

b—This field is flagged as yes if ERG considered the production type to be oil and gas extraction wells.

c—These are the total number of records in the raw database. 

Step 2 – Create Active Oil and Gas Wells Table 

ERG used queries 100 through 103 in Attachment 1 to create a list of active oil and gas 

extraction wells. These queries cross reference each well record in the DI Desktop® database 

against the Production Type Crosswalk ERG created in Step 1. Only well records where the 

PRODUCTION_TYPE field is flagged as oil and gas extraction and identified as active are 

included in the results. For most states, ERG considered active wells to be those that produced 

oil, gas, and/or water during the year that the data was last updated by Drillinginfo.

10 The most 

recent production date for each state is provided in Drillinginfo’s Data Coverage table (DCN 

SGE01027). The table called “Active Oil and Gas Wells” in Attachment 1 contains the final list 

of active wells. Table 4 describes queries 100 through 103 in more detail. Because each state 

updates their data at different times, ERG used separate queries for different states to complete 

this step.11

 

10 This is the date that the state last updated the data that Drillinginfo included in ERG’s version of the DI Desktop® 

database downloaded on January 5, 2012. 

11 For MD, NY, OH, OR, and WV the last data update date was December 2010. For KY and TN, the last data 

update date was December 2009. For all other states except for PA, the last data update was between June and 

November 2011 (DCN SGE01027). Due to the lack of entries in the last production field for PA, ERG instead used 

the STATUS field to identify active PA wells.
Memorandum

March 31, 2015

Page 7

Table 4. Step 2 Query Descriptions

Query Description

100 – Make 

Active Wells 

Table

This query creates a new table called “Active Oil and Gas Wells” and populates it with well 

records from the full DI Desktop® database that meet the following criteria:

 The PRODUCTION_TYPE field matches one of the oil and gas production types 

(assigned by ERG) in the Production Type crosswalk table; 

 The LAST_PROD_DATE field contains a date on or after 1/1/2011; and

 The well is not located in MD, NY, OH, OR, WV, KY, TN or PA.

This query also creates two new field names called 

CONSOLIDATED_FORMATION_NAME and RESOURCE_TYPE. This field is left blank, 

but is populated in Step 4.

101 – Append 

MD, NY, OH, 

OR, and WV

This query appends well records from the full DI Desktop® database to the “Active Oil and 

Gas Wells” table that meet the following criteria:

 The PRODUCTION_TYPE field matches one of the oil and gas production types 

(assigned by ERG) in the Production Type crosswalk table; 

 The LAST_PROD_DATE field contains a date on or after 12/1/2010; and

 The well is located in MD, NY, OH, OR, or WV

102 – Append KY

and TN

This query appends well records from the full DI Desktop® database to the “Active Oil and 

Gas Wells” table that meet the following criteria:

 The PRODUCTION_TYPE field matches one of the oil and gas production types 

(assigned by ERG) in the Production Type crosswalk table; 

 The LAST_PROD_DATE field contains a date on or after 12/1/2009; and

 The well is located in KY or TN.

103 – Append PA This query appends well records from the full DI Desktop® database to the “Active Oil and 

Gas Wells” table that meet the following criteria:

 The PRODUCTION_TYPE field matches one of the oil and gas production types 

(assigned by ERG) in the Production Type crosswalk table; 

 The well STATUS field is “Active”; and

 The well is located in PA.

Step 3 – Create Consolidated Formation Crosswalk

The DI Desktop® database does not identify wells as unconventional or conventional.

However, it identifies the basin and formation in which the well is completed. ERG used 

information in the BASIN and FORMATION fields to identify UOG wells. However, because 

these fields include inconsistent naming conventions and spelling errors, ERG created a 

comprehensive crosswalk between the basin and formation combinations reported in DI

Desktop®, consolidated UOG formation names, and the applicable resource type. Table 5

provides examples of these consolidations. The full crosswalk contains over 66,000 

combinations and is in the table called “Consolidated Formation Crosswalk” in Attachment 1 

(SGE DCN00963.A01). Section 3.0 discusses data quality related to this crosswalk.

To assign consolidated UOG formation names, ERG searched the list of reported basin 

and formation combinations for the UOG formation names listed in Table 9.3 of EIA’s 

Assumptions to the 2014 Annual Energy Outlook report (DCN SGE00988). ERG used other 

references to supplement the EIA report as needed to identify unconventional formations and 

resource. The DOCUMENTATION field in the consolidated formation crosswalk contains the 

DCN(s) for the reference(s) ERG used to identify each unconventional formation.
Memorandum

March 31, 2015

Page 8

Table 5. Formation Consolidation Examples

Reported Basin in Desktop

Reported Formation in 

Desktop

Consolidated 

Formation (assigned 

by ERG)

Resource Type

(assigned by 

ERG)

TEXAS & LOUISIANA GULF COAST EAGLEFORD Eagle Ford shale

TEXAS & LOUISIANA GULF COAST EAGLE FORD Eagle Ford shale

TEXAS & LOUISIANA GULF COAST EAGLE FORD SHALE Eagle Ford shale

ANADARKO GRANITE WASH Granite Wash tight

ANADARKO GRANITE WASH CONS Granite Wash tight

ANADARKO GRANITE WASH -C- Granite Wash tight

EAST TEXAS HA Haynesville shale

EAST TEXAS HAYNESVILLE SHALE Haynesville shale

EAST TEXAS HAYNESVILLE Haynesville shale

Step 4 – Update Active Oil and Gas Table (Query 200)

Lastly, ERG used Query 200 in Attachment 1 to update the “Active Oil and Gas Wells”

table with consolidated UOG formation names. This query updates the RESOURCE_TYPE and 

CONSOLIDATED FORMATION NAME fields in the “Active Oil and Gas Wells” table by 

cross referencing the reported basin and formation combination against the “Consolidated 

Formation Crosswalk” table ERG created in Step 3.

3.0 DI DESKTOP® ANALYSIS RESULTS

Table 6 shows the total number of active wells identified by ERG in the DI Desktop® 

database by resource type and well trajectory. ERG generated the results in Table 6 using query 

300 in Attachment 1.12 For comparison, the total number of active oil and gas wells reported by 

EIA in 2009 (DCN SGE01022) is included in Table 6. Wells that ERG did not identify as UOG 

are included in the COG and CBM category. 

The total number of oil and gas wells that were active in 2011 may have been higher than 

the number ERG estimated (i.e., 620,000 wells). This is primarily because the 

PRODUCTION_TYPE field was reported as “N/A” for over 450,000 well records in the DI 

Desktop® database such that ERG could not identify all oil and gas extraction wells (see Table 3

in Step 1). Further, the total number of UOG wells that were active in 2011 may have been 

higher than the number ERG estimated (i.e., 160,000 wells). This is primarily because the 

FOMRATION field for over 140,000 active oil and gas wells identified by ERG was reported as 

“N/A”, “0”, “(N”, or blank such that ERG could not identify a common formation name and 

could not determine if the well was in a conventional or unconventional formation (see Step 3).

 

12 Query 300 is a crosstab query that counts the number of wells in the “Active Oil and Gas Wells” table by well 

trajectory and resource type.
Memorandum

March 31, 2015

Page 9

Table 6. Active Oil and Gas Extraction Wells Summary

Resource Type

Identified by ERG in DI Desktop® by Well Trajectory 

(2011)

a Reported by 

EIA (end of 

2009)b,c Horizontal Directional Vertical Unknown Total

UOG: Tight 5,620 9,230 59,600 32,800 107,000 NR

UOG: Shale 22,400 1,820 15,100 15,300 54,700 NR

COG and CBM 7,820 17,000 201,000 231,000 457,000 NR

Total 35,900 28,100 276,000 279,000 619,000 825,000

a— For the most part, this version of DI Desktop® reflects wells drilled during the second half of 2011 (see DCN 

SGE01027 for state-by-state dates).

b—Source for EIA well counts: DCN SGE01022

c—ERG was unable to identify a more recent national level count of active oil and gas wells.

4.0 QUALITY CONTROL PROCEDURES

All of the analyses presented in this memorandum adhered to the Environmental 

Engineering Support for Clean Water Regulations Programmatic Quality Assurance Project 

Plan (PQAPP) (DCN SGE00957) and the Unconventional Oil and Gas (UOG) Supplemental 

Quality Assurance Project Plan (SQAPP) (DCN SGE00958), including collecting, evaluating, 

and analyzing existing data and information.

Specifically, ERG used the procedures described in Section 4 of the PQAPP to gather and 

manage existing data in support of the UOG proposed rulemaking. ERG staff entered reference 

information for relevant sources into the UOG Literature Review database. The ERG index 

keeper reviewed all reference information, assigned each reference a Document Control Number 

(DCN), imported the reference information into the UOG Project File Index database, and saved 

referenced files in the Electronic Project File folder.

ERG also used the procedures described in Section 3 of the SQAPP when collecting 

existing data for use in the UOG proposed rulemaking. ERG used a combination of sources, 

including reports, papers, and online databases from state regulatory agencies such as 

departments (e.g., oil and gas commissions). As shown in Table 7 in this memorandum, ERG 

assigned a source flag (A, B, C or D) to all references used in these analyses. ERG did not use 

any Source Flag C or D references in this analysis. ERG defines each source flag as follows: 

 Source Flag A - Journal articles and documents prepared by or for a government 

agency (e.g., site visit reports, industry meeting notes); 

 Source Flag B - Documents prepared by a verified source13 that include citation 

information (e.g., operator reports, vendor documents, conference presentations, 

university publications); 

 Source Flag C - Documents prepared by a verified source that do not include citation 

information (e.g., operator reports, vendor documents, conference presentations); and 

 

13 ERG considered sources as “verified” if we were able to find information about the author outside of the reference 

document. ERG primarily verified information by looking for company/organization websites that confirmed the 

author’s affiliation with the UOG industry
Memorandum

March 31, 2015

Page 10

 Source Flag D - Documents prepared by a source that could not be verified and that 

do not include citation information.

EPA and ERG followed the procedures described in Section 7.0 of the PQAPP to 

generate, evaluate, and analyze data. ERG conducted the following QA checks during the 

analyses:

 ERG created the Microsoft Access database provided in Attachment 1 and 

performed a 100 percent check of all queries, and documented these in internal 

versions of the databases.

 ERG created two crosswalks in the Microsoft Access database provided in 

Attachment 1 and performed a 20 percent check of all records in them.

 ERG had a senior staff member familiar with ELGs and the UOG proposed 

rulemaking review all analyses.

5.0 REFERENCES

Table 7 provides DCNs, citations, and source flags for references used in these analyses. 

The references in Table 7 are sorted numerically by DCN.

Table 7. References

DCN Source Citation 

Source

Flaga

SGE00153 U.S. Energy Information Administration (EIA). 2011. Shale Gas Plays, 

Lower 48 States. Prepared by EIA Office of Oil and Gas. (May).

A

SGE00155 U.S. Energy Information Administration (EIA). 2010. Tight Sands Gas Plays, 

Lower 48 States. Prepared by EIA Office of Oil and Gas. (June).

A

SGE00442.A06 Murray, Kyle E. 2013. Examining Water Production Volumes and Produced 

Water Quality in the Mississippi Lime to Develop Appropriate Management 

Strategies. Mississippi Lime Production and Produced Water.

B

SGE00330 Energy Information Administration (EIA). 2011. Review of Emerging 

Resources: U.S. Shale Gas and Shale Oil Plays.

A

SGE00486 Energy Information Administration. 2013. Assumptions to the Annual 

Energy Outlook 2013.

A

SGE00520 Drillinginfo. 2011. DI Desktop® December 2011 Download. Drillinginfo, 

Inc. Downloaded 1/5/2012.

B

SGE00694 Oklahoma Geological Survey. 2014. Gas Shale Database. Accessed January 

29, 2014.

A

SGE00736 ERG. 2015. Analysis of Active Underground Injection for Disposal Wells. A

SGE00957 Eastern Research Group, Inc. 2014. Environmental Engineering Support for 

Clean Water Regulations Programmatic Quality Assurance Project Plan 

(PQAPP).

A

SGE00958 Eastern Research Group, Inc. 2014. Unconventional Oil and Gas (UOG) 

Supplemental Quality Assurance Project Plan (SQAPP).

A

SGE00988 Energy Information Administration. 2014. Assumptions to the Annual 

Energy Outlook 2014.

A
Memorandum

March 31, 2015

Page 11

Table 7. References

DCN Source Citation 

Source

Flaga

SGE00991 United States Geological Survey. 2008. Assessment of Undiscovered Oil and 

Gas Resources of the Permian Basin Province of West Texas and Southeast 

New Mexico, 2007.

A

SGE01022 Energy Information Administration. 2011. Distribution and Production of Oil 

and Gas Wells by State. (January 7).

A

SGE01023 Office of Governor Dennis Gaugaard. 2012. South Dakota Oil and Gas 

Development/Preparedness Executive Branch Work Groups: Summary of 

Findings. (September).

A

SGE01027 Drillinginfo. 2012. HPDI Data Coverage. (January 5). B

a—Source Flag A—Journal articles and documents prepared by or for a government agency (e.g., site visit 

reports, industry meeting notes).

Source Flag B—Documents prepared by a verified source that include citation information (e.g., operator 

reports, vendor documents, university publications).

Source Flag C—Documents prepared by a verified source that do not include citation information (e.g., 

operator reports, vendor documents, conference presentations); and 

Source Flag D—Documents prepared by a source that could not be verified and that do not include citation 

information.

6.0 ATTACHMENT
Memorandum

February 19, 2015

Page 12

ATTACHMENT 1: DI DESKTOP® DEVELOPMENT DATABASE (DCN SGE00963.A01)