{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Fracking and Oklahoma Quakes analysis\n", "\n", "In this analysis, I will be looking at the dataset [Oklahoma Earthquakes and Saltwater Injection Wells](https://www.kaggle.com/ksuchris2000/oklahoma-earthquakes-and-saltwater-injection-wells) to see if I can find any correlation between the earthquakes and the use of [Injection Wells](https://en.wikipedia.org/wiki/Injection_well)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Preface" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import matplotlib.pyplot as plt\n", "import matplotlib.patches as mpatches\n", "import pandas as pd\n", "import cartopy\n", "from cartopy import crs" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "http://www.ogs.ou.edu/pubsscanned/openfile/OF1_2014_Murray.pdf" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Preprocessing" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Source: https://www.kaggle.com/ksuchris2000/oklahoma-earthquakes-and-saltwater-injection-wells\n" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": " Operator WellType WellName \\\n0 XTO ENERGY INC 2R HEWITT UNIT 22 \n1 GATEWAY RESOURCES USA INC 2R ANDY BROWN \n2 WHITE MONTY & TERRY PRODUCTION 2D ROLLER, B. H. \n3 CIRCLE 9 RESOURCES LLC 2R SCHOOL LAND 66 \n4 CIRCLE 9 RESOURCES LLC 2R SCHOOL LAND 66 \n... ... ... ... \n11056 CITATION OIL & GAS CORPORATION 2R COX PENN SAND UNIT \n11057 COMPLETE ENERGY SERVICES INC CDW SEILING SWD \n11058 URBAN OIL & GAS GROUP LLC 2R GLADYS LOVE \n11059 BROWER OIL & GAS CO INC 2D REED \n11060 TRANSCONTINENTAL COMPANY 2R RICHARDS \n\n Approval Date County LAT LONG PSI BBLS \n0 1936-12-18 CARTER 34.199067 -97.399092 1100.0 3500.0 \n1 1945-04-22 WASHINGTON 36.901903 -95.900888 NaN NaN \n2 1946-10-19 LINCOLN 35.511472 -96.767417 0.0 100.0 \n3 1947-03-18 PAWNEE 36.164978 -96.717249 NaN NaN \n4 1947-03-18 PAWNEE 36.167568 -96.722799 NaN NaN \n... ... ... ... ... ... ... \n11056 2017-08-30 CARTER 34.373645 -97.399878 1500.0 999.0 \n11057 2017-08-30 DEWEY 36.146649 -98.934932 1635.0 5000.0 \n11058 2017-08-30 MCCLAIN 34.919795 -97.421550 3500.0 500.0 \n11059 2017-08-30 OKMULGEE 35.475614 -95.911700 400.0 500.0 \n11060 2017-08-30 CARTER 34.342695 -97.542820 225.0 500.0 \n\n[11061 rows x 9 columns]", "text/html": "
\n | Operator | \nWellType | \nWellName | \nApproval Date | \nCounty | \nLAT | \nLONG | \nPSI | \nBBLS | \n
---|---|---|---|---|---|---|---|---|---|
0 | \nXTO ENERGY INC | \n2R | \nHEWITT UNIT 22 | \n1936-12-18 | \nCARTER | \n34.199067 | \n-97.399092 | \n1100.0 | \n3500.0 | \n
1 | \nGATEWAY RESOURCES USA INC | \n2R | \nANDY BROWN | \n1945-04-22 | \nWASHINGTON | \n36.901903 | \n-95.900888 | \nNaN | \nNaN | \n
2 | \nWHITE MONTY & TERRY PRODUCTION | \n2D | \nROLLER, B. H. | \n1946-10-19 | \nLINCOLN | \n35.511472 | \n-96.767417 | \n0.0 | \n100.0 | \n
3 | \nCIRCLE 9 RESOURCES LLC | \n2R | \nSCHOOL LAND 66 | \n1947-03-18 | \nPAWNEE | \n36.164978 | \n-96.717249 | \nNaN | \nNaN | \n
4 | \nCIRCLE 9 RESOURCES LLC | \n2R | \nSCHOOL LAND 66 | \n1947-03-18 | \nPAWNEE | \n36.167568 | \n-96.722799 | \nNaN | \nNaN | \n
... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n... | \n
11056 | \nCITATION OIL & GAS CORPORATION | \n2R | \nCOX PENN SAND UNIT | \n2017-08-30 | \nCARTER | \n34.373645 | \n-97.399878 | \n1500.0 | \n999.0 | \n
11057 | \nCOMPLETE ENERGY SERVICES INC | \nCDW | \nSEILING SWD | \n2017-08-30 | \nDEWEY | \n36.146649 | \n-98.934932 | \n1635.0 | \n5000.0 | \n
11058 | \nURBAN OIL & GAS GROUP LLC | \n2R | \nGLADYS LOVE | \n2017-08-30 | \nMCCLAIN | \n34.919795 | \n-97.421550 | \n3500.0 | \n500.0 | \n
11059 | \nBROWER OIL & GAS CO INC | \n2D | \nREED | \n2017-08-30 | \nOKMULGEE | \n35.475614 | \n-95.911700 | \n400.0 | \n500.0 | \n
11060 | \nTRANSCONTINENTAL COMPANY | \n2R | \nRICHARDS | \n2017-08-30 | \nCARTER | \n34.342695 | \n-97.542820 | \n225.0 | \n500.0 | \n
11061 rows × 9 columns
\n\n", " | time | \n", "latitude | \n", "longitude | \n", "depth | \n", "mag | \n", "magType | \n", "nst | \n", "gap | \n", "dmin | \n", "rms | \n", "... | \n", "updated | \n", "place | \n", "type | \n", "horizontalError | \n", "depthError | \n", "magError | \n", "magNst | \n", "status | \n", "locationSource | \n", "magSource | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1973-03-17 07:43:05.500000+00:00 | \n", "36.087 | \n", "-106.168 | \n", "6.0 | \n", "4.5 | \n", "mb | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "2014-11-06T23:21:10.078Z | \n", "New Mexico | \n", "earthquake | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "reviewed | \n", "us | \n", "us | \n", "
1 | \n", "1973-05-25 14:40:13.900000+00:00 | \n", "33.917 | \n", "-90.775 | \n", "6.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "2014-11-06T23:21:12.859Z | \n", "Mississippi | \n", "earthquake | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "reviewed | \n", "s | \n", "us | \n", "
2 | \n", "1973-09-19 13:28:20.500000+00:00 | \n", "37.160 | \n", "-104.594 | \n", "5.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "2014-11-06T23:21:20.295Z | \n", "Colorado | \n", "earthquake | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "reviewed | \n", "us | \n", "us | \n", "
3 | \n", "1973-09-23 03:58:54.900000+00:00 | \n", "37.148 | \n", "-104.571 | \n", "5.0 | \n", "4.2 | \n", "mb | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "2014-11-06T23:21:20.346Z | \n", "Colorado | \n", "earthquake | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "reviewed | \n", "us | \n", "us | \n", "
4 | \n", "1974-02-15 13:33:49.200000+00:00 | \n", "36.500 | \n", "-100.693 | \n", "24.0 | \n", "4.5 | \n", "mb | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "2014-11-06T23:21:22.859Z | \n", "Oklahoma | \n", "earthquake | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "reviewed | \n", "us | \n", "us | \n", "
5 rows × 22 columns
\n", "