Activists may have occasions to contact oil pipeline operators.
Failing to find a convenient directory of oil pipeline operators, I have created the Oil Pipeline Operator Directory (2015), with basic contact information. 2015 is the latest data.
- OPERATOR_ID – Important because it’s the key to tracking an operator
- TITLE (PREPARER) Person preparing form 7000-1.1 (Rev. 06-2014).
- NAME (PREPARER)
- EMAIL (PREPARER)
- PHONE (PREPARER)
- FAX (PREPARER)
- NAME (SIGNER) Person certifying the information on the form.
- TITLE (SIGNER)
- EMAIL (SIGNER)
- PHONE (SIGNER)
I preserved the distinction between the person preparing Form 7000-1.1 and the person signing it for the operator.
I haven’t found a convenient mapping of operators to pipelines. The data exists, I have seen maps drawn using the Operator_ID to identify pipelines. But haven’t run it to ground, yet.
Creation of the Directory
I started with the 2015 report in Hazardous Liquid Annual Data – 2010 to present (ZIP) hosted at Distribution, Transmission & Gathering, LNG, and Liquid Annual Data by the Pipeline and Hazardous Materials Safety Administration (PHMSA). Using sheet HL AR Part N to O I deleted columns A, B, C, D, E, L and R, then sorted by operator number and deleted duplicates. Where one duplicate was more complete, I kept the more complete duplicate.
There is a wealth of data at Pipeline and Hazardous Materials Safety Administration (PHMSA). Is there any of it in particular which if made more easily accessible would be more important or useful?
Suggestions on what data and how to make it more useful?