Interactive Web Map of Marcellus and Utica Shale

Interactive Web Map of Marcellus and Utica Shale Showing Thickness and Depth within the State of PA Derege W. Kobre Adviser: Dr. Jay Parrish

INTRODUCTION Objective? Why I have chosen this project ? Who will benefit from the project ? What is Marcellus Shale and why it is important? q What is Utica Shale and why it is important? q q

INTRODUCTION q The recent change in drilling and production q What is Horizontal Fracking ? q What is Hydraulic Fracking ? q What is the estimated resource from the Marcellus Shale? q What is the estimated resource from the Utica Shale? Vertical Fractures Or Pores

SOURCE DATA WORKFLOW EXCEL SPREAD SHEET FILE FORMAT GEOSTATISTICAL ANALYSIS Arc. GIS DESKTOP TEXT & TABLE FILE FORMATS(. csv and. dbs for geometry and attributes respectively) ACCESS My. SQL SERVER PHP XML FILE FORMAT WEB DEVELOPMENT CLIENT

METHODOLOGY q Source Data (EXL Spread Sheet) v MWELLHEADER. xls v v Marcellus_tops. xls Utica_tops. xls q Algorithm v Data Preparation (ACCESS database)

METHODOLOGY Source Data (EXL Spread Sheet) Algorithm q q v Data Preparation (ACCESS database) » Create query 1 from the joined MWELLHEADER table and Marcellus_tops table based on UWI and MTOP values (1795 RETURNS) » Create query 2 from the joined MWELLHEADER table and Marcellus_tops table based on UWI and MBOT values (1753 RETURNS) » Create query 3 that will change query 1 to a table named WELLMTOP » Create query 4 that will change query 2 to a table named WELLMBOT

METHODOLOGY Source Data Algorithm q q v v Data Preparation (ACCESS database) Geoprocessing (Arc. GIS) • Add coordinate data to the WELLMTOP table (x y events) & save as a shapefile • Join the rest of the table to it to include the fields MTOP and MBOT and name the combined shapefile WELLCOMB • Add the fields MTHICK and MDEPTH • Use the field calculator to update the records (e. g MTHICK = [MBOT]-[MTOP] )

Geoprocessing (Arc. GIS) • Do Geostatistical Analysis from Geostatistical Wizard using Kriging method for each fields to create a prediction map layer of polygon shape – right click on the kriging layer – Click data >> export to vector • Confirm that "GA Layer To Contour" dialogue box pops up allowing to make a polygon shape file of filled contours that showed both the prediction map and prediction standard error map for each field • Use Natural Neigbour method for the Utica data – Reclassify raster output – Change raster to polygon

Geoprocessing (Arc. GIS) • Export the shapefiles out to Access database. MWELL. shp UWELL. shp MTHICK. shp MDEPTH. shp MTHICKERR. shp MDEPTHERR. shp Uthick. shp Udepth. shp • The shapfiles are exported out in two forms 1. 2. Text (use export shapefile to csv tool created by Jim Detwiler from my toolbox) Note: to append the geometry data Table (dbase IV) Note: to append the attributes

METHODOLOGY q q Source Data Algorithm v Data Preparation (ACCESS database) v Geoprocessing (Arc. GIS) v Create Tables (My. SQL database) v Form XML data using PHP server side scripting language

METHODOLOGY q Source Data q Algorithm v Data Preparation (ACCESS database) v Geoprocessing (Arc. GIS) v Create Tables (My. SQL database) v Form XML data using PHP server side scripting language

METHODOLOGY q Source Data q Algorithm v Data Preparation (ACCESS database) v Geoprocessing (Arc. GIS) v Create Tables (My. SQL database) v Form XML data using PHP server side scripting language v Create the point and polygon maps using Google Engine, HTML and Java. Script client side programming language v Repeat the above two steps for each layer

ANTICIPATED RESULTS

CONCLUSION q q Challenges Improving result with more data Future prospect in improved methodology Sample demonstration

CONFERENCE • • • GSA Northeastern Section 49 th Annual Meeting 23 to 25 March 2014 GSA Abstract deadline: 10 Dec. 2013

REFERENCES q David O'Sullivan, P. , & Unwin, D. J. (2010). Geographic Information Analysis (2 nd ed. ). New Jersey: John Wiley & Sons, Inc. q King, H. (n. d. ). Marcellus Shale - Appalachian Basin Natural Gas Play. Retrieved 12 01, 2013, from Geology. com: http: //geology. com/articles/marcellus-shale. shtml q Maps and Digital Data. (n. d. ). Retrieved from DCNR Pennsylvania Department of Conservation and Natural Resources: http: //www. dcnr. state. pa. us/topogeo/econresource/oilandgas/marcellus_maps/index. htm q NETL. (2007, 1 31). Natural Gas Program Archive. Retrieved from U. S. Department of Energy: Office of Fossil Energy: National Energy Technology Laboratory: http: //www. netl. doe. gov/KMD/Forms/Cd. Dvd. Retrieval. aspx

QUESTIONS? Your comments and feedbacks are appreciated