Step #1: Zoom to the Bend Arch-Fort Worth Basin
- Check the FW_ShaleBasin layer in the Table of Contents on the left side
- Under Bookmarks, select Barnett Shale
Step #2: Identify the Counties, Cities, and Zip codes within the Bend Arch-Fort Worth Basin
- Click the 'Add Data' button and navigate to C:\BarnetShale\ and select 'Census TIGER.lyr'
- If you receive a popup alerting you about differing coordinate systems, check 'Don't warn me again this session'
- In the Table of Contents, expand Census TIGER and check Counties
- Drag FW_ShaleBasin above Census TIGER to be able to view the boundary
- Right-click Counties in the Table of Contents and select Label Features to view labels
- Repeat for Cities and Zip Codes
Step #3: Download and View Barnet Shale Boundary from EIA
- Download from the US Energy Information Agency
- Scroll down and download 'Shapefiles for play boundaries Updated 5/9/2011'
- Extract the contents to the C:\BarnettShale directory
- Click the 'Add Data' button and navigate to C:\BarnetShale\ and select US_ShalePlays_EIA_May2011.shp
Step #4: Geocode UT Arlington (or Another) and Buffer 10 Miles
- Geocode UT Arlington location
- On the toolbar, click the Find button
- Click the Locations tab and enter the address for the University: 701 S. Nedderman Drive, 76019, and click Find.
- Right-click the top address result, and select Add Point
- Close Find dialog box
- Buffer by 10 Miles
- On the toolbar, click the Buffer Wizard button
- If you receive an error trying to save the file, hit the browse button and change the file type to 'Shapefile'
Step #5: Import and Explore Historic Well Data
- Click the 'Add Data' button and navigate to C:\BarnetShale\ and select Oil and Gas Exploration and Production.lyr
- What do the various color cells represent?
- METADATA! Geospatial metadata standard is FGDC
- File source information
- Attribute:
- Attribute Label: CELLSYMB
- Attribute Definition: Production Status
- Attribute Definition Source: U.S. Geological Survey
- Attribute Domain Values:
- Enumerated Domain:
- Enumerated Domain Value: 1
- Enumerated Domain Value Definition: Cell contains at least one productive oil well, but no productive gas wells (green).
- Enumerated Domain Value Definition Source: USGS
- Enumerated Domain:
- Enumerated Domain Value: 2
- Enumerated Domain Value Definition: Cell contains at least one productive gas well, but no productive oil wells (red).
- Enumerated Domain Value Definition Source: USGS
- Enumerated Domain:
- Enumerated Domain Value: 3
- Enumerated Domain Value Definition: Cell contains at least one productive oil well and at least one productive gas well or one well producing both oil and gas (gold).
- Enumerated Domain Value Definition Source: USGS
- Enumerated Domain:
- Enumerated Domain Value: 4
- Enumerated Domain Value Definition: The type of production of the wells located within the cell is unknown, or the wells within the cell had no production (charcoal).
- Enumerated Domain Value Definition Source: USGS
- Explore the data by turning particular decades on and off
Step #6: Download Data from data.gov
- Navigate to Data.gov
- Search for Gas Wells
- Under 'Filter by Location' enter Tarrant County
- Scroll down and click Oil and Gas Exploration and Production in the United States Shown as Quarter-Mile Cells
- Download the top .ZIP file, extract the contents and add uscells05g.shp to ArcMap using the 'Add Data' button
- Back on the search results page, scroll down and click Texas Well Header Data
- To help save time, this data has been downloaded in the C:\BarnettShale\DownloadInCase directory, and filtered only for Tarrant County.
- The file is called Tarrant_TexasWellHeaderData.xls. Bring intoArcMap using the 'Add Data' button
- Double-click the Tarrant_TexasWellHeaderData.xls file and select Sheet1$
Step #7:Plot the Tarrant_TexasWellHeaderData.xls Table as Points
- Right-click Sheet1$ in the Table of Contents and select 'Display XY Data'.
- Specify the X and Y as follows:
- To set the coordinate system as WGS84
- Click the Edit button
- Select Geographic/World/WGS1984
- OK
- OK
- OK
Step# 8: Summarize Landuse or Geology Counts for Well Header Data
- Time contraints are on the mind, so this is changing from both to either/or
- Let's Vote! Any suggestions which?
- Add the appropriate file from the C:\BarnettShale\ directory using the 'Add Data' button
- GAT250k.lyr OR Landuse2010.lyr
- Perform Spatial Joint to count number of wells per geology or landuse type
- Right-click on the file type voted on, and select Joins & Relates\Join
- Ensure the table Layer to Join to this Layer are the Sheet1$ Events and leave other defaults
- OK
- Right-click Join_Output in the Table of Contents and select 'Open Attribute Table'
- Scroll to the far right, and examine the Count field
Final Step#9: Explore Most Current Data at Texas Railroad Commission