In this tutorial I will attempt to build a dashboard to explore upstream oil and gas data (by upstream I mean each row of data contains all the information for a specific well).
Database is comprised of more than 23K wells located in Eagle Ford Shale in South West Texas. Data is scraped from public data web page of Texas Railroad Commission, web scraping scripts are not included here. The aim of this study is to create dashboards to explore data on the web.
I created a csv data containing upstream data. Here are the description of each column in the csv data:
- Completion_FluidVolume: fluid volume pumped during hydraulic fracturing process (gal)
- Completion_LateralLength: horizontal lateral length of wellbore (all wellbores are horizontally drilled) (ft)
- Completion_ProppantMass: total proppant mass pumped during hydraulic fracturing process (bbl)
- CompletionDate: Date of the well completion
- Date_DrillingEnd: Drilling end date
- Date_SpudDate: Drilling start date
- Date_StartDate: Production start date
- Info_API: Unique API code identifier for this well
- Info_Name: Well name
- Info_Operator: Operator company name
- Info_ServiceCompany: Service company name
- Location_BLatitude: Bottomhole coordinate, Latitude
- Location_BLongitude: Bottomhole coordinate, Longitude
- Location_County: County name that well is located
- Location_SLatitude: Surface coordinate, Latitude
- Location_SLongitude: Surface coordinate, Longitude
- Location_TVD: True Vertical Depth (ft) of wellbore
- Prod_BOE12Month: First 12 month BOE production for each well (STB)
- Prod_BOE3Month: First 3 month BOE production for each well (STB)
- Prod_BOE6Month: First 6 month BOE production for each well (STB)
- Prod_Type: Type of fluid that this well produces (oil, gas,...)
I am not using all of the listed data column in this study. However, I am planning to use the rest of the data in future and expand this case study.
I used D3.js and Javascript to build this case study. If you have problem in loading data with Google Chrome, try to activate Internet Information Services (IIS) for Windows Server and load UpStream_DashBoard_EFStudy.html with Microsoft Edge. Dashboard has 4 panels:
- Panel 1. (Top Left) Texas counties with more than 400 wells
- Panel 2. (Top Right) Surface locations of the wells color coded with respect to the producing fluid
- Panel 3. (Bottom Left) Average 6 month BOE Production (Oil + Oil equivalent production from gas) for each prdoucing year
- Panel 4. (Bottom Right) Top producing operator year by year (operator with highest average 6 month BOE with atleast 20 wells)
Once all files are loaded and complied, you should be able to see the following dashboard. You can zoom in the map and look for more details in the map:
