Data driven discussions about gas extraction and related topics.

PA Oil and Gas Inspection Data Available

The Pennsylvania Department of Environmental Protection has updated their delivery mechanism of violation data, and it is now possible to search all inspections, including those that do not result in violations. To test it out, I downloaded all oil and gas inspection data from January 1, 2011 to January 16, 2012. Here is a summary of the results from that query:

While the vast majority of instances where no violations were issued were recorded in Column F, it seemed likely to me that no violations would have been issued for any category in rows D through I, so I aggregated those columns and divided by the total number of inspections.

According to the report instructions, the report was intended to include only those violations that resulted in a violation, but the final compliance report does allow for seeing all results. This is a very good thing, a it provides us with another way to evaluate the various operators within industry.

Before I present that data for the Marcellus Shale operators, I should point out a source of skew: When an inspection yields more than one violation, there are multiple entries for the actual inspection. For example, if one inspection yielded ten violations, this analysis would look at it as ten inspections, each of which yielded one violation. Clearly, that would distort the actual number of inspections with violations downward, resulting in more favorable scores for any operator with multiple violations on any one inspection. That in mind, let’s consider the following results to be preliminary.  Still, it is useful in combination with the violations per well and violations per million cubic feet of production metrics to triangulate in on the operators’ culture of compliance.

DataTool MS Permit Updates Throughout the Marcellus Shale Region

Marcellus Shale permit data has been updated in recent days for the following states:


Permits throughout the Marcellus Shale Region. Please click the gray compass rose and double carat (^) to hide those menus.

In addition to the above updates, I have verified that there are currently no Marcellus Shale permits in Maryland and Virginia, although there is interest for such activity in each state. Also, while the Marcellus Shale is not typically thought to extend into Kentucky, the West Virginia wells extended sufficiently close to the border to make searching in neighboring counties worthwhile. While there are wells drilled into other Devonian shales, the Marcellus Shale is not represented in Boyd, Greenup, Lawrence, Martin, or Pike Counties in Kentucky.

Youngstown Earthquake Related to Gas Extraction Industry?

Youngstown, Ohio rang out the old year in style, with a magnitude 4.0 earthquake that apparently felt as far away as Buffalo, but received attention nationally (See the LA Times blog titled 4.0 quake hits Youngstown Ohio. Yes, Ohio.) There is a widespread notion that the temblor was related to Class II injection wells in the area–see for example this Akron Beacon Journal article where Ohio state geologist Michael Hansen is quoted as saying there is “little doubt” that this latest in a series of 11 quakes is the result of activities at injection wells in the immediate area. The article goes on to say that his boss, Ohio Department of Natural Resources director James Zehringer, closed several injection wells in the area as the issue is being examined.

But wait a second…if you go to this NPR link, you see an AP story titled “Earthquake Strikes Near Ohio Fracking Site”, where the same James Zehringer is quoted as saying, “The seismic events are not a direct result of fracking.”

What gives? Actually, there is no discrepancy at all, except that the AP writer lumped injection wells together with hydraulic fracturing, which have some similarities in that they highly pressurized oil injections of oil and gas related fluids, but the two are in fact different. Therefore, saying that the seismic events are not a direct result of fracking is completely true.

But it does make one wonder…most of Pennsylvania has been deemed unsuitable for brine injection wells, which is why much of our waste water has gone to Ohio in the first place. But if these supposedly safe activities can result in a disturbance equivalent to 15 metrics tons of TNT, maybe we don’t really understand what we’re doing down there.

Here are maps showing earthquakes near the Ohio river basin since 1973. For more information on any event, hit the blue “i” button, followed by any map feature. Clicking the gray compass rose and double carat (^) will hide those menus.

Animating Data: A Different Way to Look at Marcellus Shale Drilling

by Josh Knauer, CEO of Rhiza

At Rhiza, we love to experiment with new ways of visualizing data that help tell better data stories. In most of our work environments, using data is kind of difficult and visualizing is usually left to data experts. We’d love to see a future where sharing data visualizations (maps, charts, explanations, etc) is as easy as recording and sharing a video on YouTube. Not everything produced will be stellar in quality, but at least we’ll all be a lot further down the road towards breaking down the traditional data silos and moving data aggregation and visualization solely out of the hands of database admins and graphic designers. We’ll still need those folks, their jobs will just get a lot more fun!

To this end, when I saw a data animation created by John Detwiler that showed the spread of drilled Marcellus shale gas wells in Bradford County, I wanted to create my own data animation telling the same story, but for the entire state of Pennsylvania… Read more»

Updated Drilled Wells Data for PA

Three drilled wells datasets for Pennsylvania have been updated or created, including:

The last of the three datasets is the most unique, with data spatially joined to municipalities. The following two maps exhibit the Marcellus Shale related data that they contain:


Number of Marcellus Shale wells per PA municipalities as of December 16, 2011. Click the gray compass rose and double carat (^) to hide those menus. Then click the information tool (the blue “i”) then any map feature for more information.


Number of Marcellus Shale wells in PA municipalities per square mile, as of December 16, 2011. Area calculation performed in PA State Plane South.

Bradford County PA Wells Drilled Animation

Bradford County Wells Drilled Animation

One of the regular users, John Detwiler, recently took the mapping application that is part of the platform to an even greater level. He exported wells drilled data by year into Google Earth to create an animation of the shale gas wells drilled from 2007-11 in Bradford County, PA. Check it out:

Violations per Well by Operator, Part 2: Bad Actors

Recently, I conducted an analysis of the legacy of each Marcellus Shale operator’s violations over time, normalized by the number of wells each company has drilled, in a metric that I call Violations per Well, or VpW. While that analysis was cumulative, I’ve had FracTracker readers ask if the VpW from one year predicts the VpW for the following year, particularly among the bad actors. To help answer that question, I’ve taken the same raw data from the previous post, and recompiled it to help address that.

I’ve been looking at violations per well for some time, on the theory that it can be used to help score a company’s compliance history with regards to the Pennsylvania Department of Environmental Protection, which issues them. All of these wells and violations are Marcellus Shale specific, and come from sources posted on the DEP website.

For ease of use, I’ve color coded the results, with bright green being the best scores, and bright red being the worst. Companies without wells for a given year are indicated in pale blue. They may either indicate drilling operators that were inactive in a given year, or midstream companies that haven’t drilled any well. Here’s the color coded key:

And here are the results:

To look at the bad actors from 2010, I selected all of the entries that were colored burgundy or bright red for that year’s VpW score. How have they fared so far in 2011?

To be fair, I should point out that operators with very few wells can get obnoxious VpW scores in a hurry. On the other hand, there were 14 Marcellus Shale operators with at least one well drilled in 2010 that didn’t get any violations that year. Therefore, in this instance, I’ve included all operators with a VpW of 1.00 or greater, and will leave questions about sample size up to the reader.

Five of the operators with VpW scores of 1.00 or higher haven’t drilled any wells at all in 2011 so far. In fact, all of them had VpW scores of at least 2.50. There may be a variety of reason for their absence in 2011, but honestly, their lack of compliance isn’t missed.

Nine operators improved from 2010 to 2011, four of which improved all the way into green categories. This is the result that we want to see, where companies appear to be responsive to violations issued by the DEP. Notable among this group is Citrus Energy, which had a huge amount of violations compared to one drilled well in 2010, to a VpW score under 0.50 so far in 2011. Also, PA Gen Energy is an operator with a significant number of wells that went from a red to a green category, which is encouraging to see. Cabot, on the other hand, barely budged, and remains over 2.00 violations per well.

There are also three operators from 2010 with VpW scores of 1.00 or greater that actually got worse in 2011. And keep in mind, the data used includes almost two more months of drilled wells than violations, so inclusion in this group is especially dubious. They include Rice Drilling B, whose VpW more than duobled to 2.13; XTO, which went from awful to horrific since becoming a subsidiary of ExxonMobil; and Ultra Resources, whose performance has been nothing short of ghastly in 2011. Luckily, Ultra has been leaving the Keystone State alone since January–let’s hope it stays that way.

I maintain that since so many operators–big and small–are able to keep their violations to wells ratio at less than 1:2, all of the operators that operate in Pennsylvania’s Marcellus Shale should try to reach that standard.  Those that show a continued disregard for our laws protecting our environment should face stiff fines for their complacency, while those operators that average more than two violations per well drilled over a prolonged period of time need to be banned.

Drilled Marcellus Shale Wells per Month

The following chart takes a look at the number of drilled Marcellus Shale wells in Pennsylvania, from 2006 through November, 2011. The accompanying trend line is included, not so much to predict December’s total, but to show the relatively decent R2 value.  That is to say, despite the occasional peaks (e.g., September 2010) and troughs (e.g., November 2010), the number of Marcellus Shale wells drilled per month has been increasing in a fairly orderly manner over the past 4 years and 8 months.

Actually, the best Excel trendline was a sixth order polynomial, with an R2 value of .087, but that’s getting fairly silly relative to my purposes here.

However, when you use the same data but only look at the last 24 months, the results are far more erratic. Once again, the highest R2 value was from a polynomial trendline. But that value wasn’t very high at all:

Once again, I don’t think the equation itself is that important, but the 0.18 R2 value is pretty low. Even the sixth order polynomial, with three peaks and three troughs, has an R2 value of only 0.34.

While the first chart shows an industry that is steadily accelerating, the second one shows…I don’t know.  I’m hesitant to offer interpretations.  My sense is that even though the R2 value is surprisingly low compared to the first chart, it doesn’t actually mean that much. Visually assessing the chart, it doesn’t seem to be a seasonal fluctuation, but there are mini-clusters of months with higher amounts of drilling activity, and those with lower amounts as well.  Certainly, the trendline is higher this month that it was two years ago, but not dramatically so.

Violations per Well by Operator Over Time

The following chart contains all operators that have either drilled a Marcellus Shale well in Pennsylvania from March 6, 2006 to November 27, 2011, or have been issued a Marcellus Shale related violation by the Pennsylvania Department of Environmental Protection between January 1, 2008 and September 30, 2011. Results are cumulative, thereby reflecting each company’s legacy with the Marcellus Shale, rather than their performances for any given year. The Violations per Well (VpW) score has been color coded for easy reference, with the following scale:

Most companies that are issued violations are well operators, although there do seem to be some midstream companies on the violation list. This might account for some of the blue “No wells” below, but mostly they reflect operators that were not yet active. For example, Antero Resource’s first well was in 2010, so entries for 2008 and 2009 read as “No wells”.

Whenever we look at Marcellus operators over time, the changes in companies has to be dealt with in some way. In this case, I took a minimalist approach: while East Resources, Inc. and East Resources, Llc. were combined, I did not merge name changes that were more substantial than that. For example, even though CNX Gas and Consol Gas are both owned by Consol, I did not merge the two. Another example is St. Mary Land and Exploration changed its name to SM Energy, and those two entries were left unchanged. Because of all of the changes within the industry, I have included the most recent drill date, so that viewers can determine if the drillers are still active.

PA Data Updates, New DataTool Charting Functionality

Several oil and gas datasets from the Pennsylvania Department of Environmental Protection (DEP) have been updated on the FracTracker DataTool, including:

Additionally, a Pennsylvania zip code dataset from the US Census has been added, but it appears to have some errors, with some zip codes inside Pennsylvania missing, and some outside of the border included.

PA zip codes. Please click the “i” tool then any map feature for more information.

Also, Rhiza Labs, the software developer of our DataTool, has been working hard to add new charting functionality to their Upshot platform. Any data that is classified as numeric upon upload can be charted. Play around with it, and let us know what you think.