Where Did That Gasoline Pipeline Break?


Last week, one of the major pipelines supplying gasoline to the eastern US broke. Do you know where the break is, and which states will be having shortages? Me neither! ... So, of course, I created a SAS map to help...

First I read up about the spill on various news sites. It appears this was a 36 inch underground pipeline owned by the Colonial Pipeline Company, that supplied 1.3 million barrels of gasoline a day. The break is in a rural area southwest of Birmingham, Alabama. For some of the states supplied by this pipeline, there are not a lot of other options for getting gasoline.

I did a bit of web searching, and found a shapefile for "Petroleum Product Pipelines". I downloaded and extracted the zip file, and then used Proc MapImport to convert it into a SAS dataset. The dataset contained lat/long coordinates along the various pipelines, and from there it was simply a matter of coming up with a bit of clever SAS code to annotate the pipeline data on a US map.

Here's what I came up with:

pipelines

Is your state supplied by this pipeline? Are you seeing shortages yet? How long do you think it will take to repair the pipeline?

This content was reposted from SAS Learning Post. Go there to view the original post.

Robert Allison, The Graph Guy!, SAS

Robert Allison has worked at SAS for more than 20 years and is perhaps the foremost expert in creating custom graphs using SAS/GRAPH. His educational background is in computer science, and he holds a BS, MS, and PhD from North Carolina State University. He is the author of several conference papers, has won a few graphic competitions, and has written a book calledSAS/GRAPH: Beyond the Basics.

What Cities are in Hurricane Irma's Path?

Here's an example of using data and visualization to look at weather -- specifically, the possible path of Hurricane Irma. Does your city need to get ready?

Mapping Out the Next Robot Invasion

Where are all the robots today? Here's a look at a better data visualization to represent where in the US all the robots are.


Re: Fascinating map
  • 10/3/2016 12:25:18 PM
NO RATINGS

Another argument for greater use of alternative energy sources.

Re: Fascinating map
  • 10/3/2016 12:07:51 PM
NO RATINGS

@ Tomsg -  There is a long history of oil companies creating artificilal shortages in order to raise prices.  Nothing would surprise me.   Pacific Gas and Electric even had fake brown outs and black outs in order raise prices.  Imagine turning the electricty off in parts of a city just to make a buck and to heck with the hosptials, schools and businesses. 

Re: Fascinating map
  • 9/28/2016 9:50:49 AM
NO RATINGS

@Terry Sweeney, I don't know, if I owned a gas station and I knew I could increase my sales by having the lowest priced gas around I'd be very motivated to know how to work inside the supply chain and make sure I was buying at the best prices.  I've heard  a few times that the money isn't made at the pump but you have to bring the traffic in and gas price is the best external advertising a gas station can get.

Re: Fascinating map
  • 9/28/2016 8:49:11 AM
NO RATINGS

I think it is part fear and part taking advantage fo the situation. Tampa prices have actually gone down because there is a glut of refined product in Texas with no place to go.

Re: Fascinating map
  • 9/27/2016 12:18:06 PM
NO RATINGS

Very interesting to see exactly where those pipes are. I was surprised that in Florida it seems there's just a fairly short line from the Port of Tampa moving inland a short distance. Not being on the broken line, apparently is why our gas prices didn't move. One does wonder if the price variations when such things happen are legitimate or based on fear or industry manipulations.

Re: Fascinating map
  • 9/27/2016 11:58:37 AM
NO RATINGS

Yes I do live in a state supplied by the pipeline and interestingly I have not seen anything about the pipeline issue in the news! I would be very interested in knowing the environmental implications of the rupture as well. From an analytics perspective how common are ruptures, what are the most common causes, what are the implications to supply and pricing from past ruptures!

Re: Fascinating map
  • 9/27/2016 11:44:13 AM
NO RATINGS

All true, SaneIT... but doesn't everybody in the supply chain for oil and gasoline have a bit of incentive to not know more and to be less efficient and to even welcome these spikes in pricing? Serendipitous way to make your quarterly numbers!

Re: Fascinating map
  • 9/27/2016 8:04:46 AM
NO RATINGS

I don't think we need keys to the gates but knowing the direction the lines flow in regard to this issue would be nice.  I guess there are assumptions that we all know Texas is the origin but I know there are wells and refineries outside of Texas. A little bit of information could tell us how real the shortage was and possibly help plan ahead for these occurrences.  I'm sure contracts with the gasoline companies caused part of the problem but looking at the map it seems like some logistical adjustments could be made fairly quickly to keep the stations from running dry.  We live in an age of information maybe we can use that information to avoid major issues.

 

Re: Fascinating map
  • 9/26/2016 5:15:01 PM
NO RATINGS

The Mexican cartel probably finds ways to divert resources that travel by rail and truck as well.

I don't work in the oil industry, so I may be wrong. But would you agree that an underground pipe is likely to be more reliable than either trucking or rail?

Re: Fascinating map
  • 9/26/2016 3:37:10 PM
NO RATINGS

@ Terry, I never realized that's when they had price hikes.  Living in San Francisco, I think I've driven less than five times in the last twenty years.  Honestly, they probably should take away my licence. 

Pipeline leaks or burst are a real concern.  In Mexico about 10% of all the oil in the pipelines winds up being stolen and resold  The Mexican cartel once caused a whole town to burn down and killed hundreds of people when they tapped into a line and they couldn't reseal it. 

Page 1 / 3   >   >>
INFORMATION RESOURCES
ANALYTICS IN ACTION
CARTERTOONS
VIEW ALL +
QUICK POLL
VIEW ALL +