GIS example using free Kentucky data
Contact: Brandon C. Nuttall
Using ArcView to process the Oil and Gas well data file for reconnaissance investigations
The instructions provided here are not intended to make you an expert in the ArcView GIS software. Visit ESRI for information on training and other
- Create a directory for the data and basemap files for this project, then download these files to that directory. If you have a copy of the KGSampler of Digital Data CD-ROM, these files are
available in the GIS shapes\Bounds and GIS shapes\O&g directories.
- From http://www.uky.edu/KGS/gis/geology.html, download KYOG83.ZIP
- Other files you might want from http://www.uky.edu/KGS/gis/geology.html
- kyfaults24k.ZIP surface faults digitized from the 1:24,000-scale geologic map of Kentucky
- CARTER1.ZIP 1-minute Carter coordinate grid
- CARTER5.ZIP 5-minute Carter coordinate grid
- From http://www.uky.edu/KGS/gis/bounds.html, download COUNTY.ZIP
- Other files you might want from http://www.uky.edu/KGS/gis/bounds.html
- QUADSKY.ZIP grid of topographic map boundaries
- Unzip the shape files to the directory you created for the download (see: http://www.winzip.com/ for WinZip)
- Start ArcView with a new view (ArcView 3.2 prompts you for this when you start a new project)
- Add themes to the view
- KYOG83V2 (With the KGSampler CD-ROM, use KYOG83)
- Format the View
- In the table of contents, the oil and gas well shape file should be first (on top) with the county data following.
- Click the check box to enable display of the county boundary file.
- Set View | Properties | Projection category to UTM 83 and type to Zone 16. When you click OK, the Map Units should be meters and the Distance Units miles or feet. Click OK again to apply the
- Change the county shape file legend
- Click the county shape file entry in the view table of contents to make it the active theme
- Click Theme | Edit Legend
- Double click the symbol and change the foreground color to light blue
- Click Apply then close the Legend Editor window
- Build a query and display the Trenton and deeper penetrations
- Click the oil and gas well shape file in the view table of contents to make it the active theme
- Click Theme | Properties
- Click the query builder tool button (hammer with question mark icon)
- In the list of fields, scroll down and double click on Tdfm to add it into the query window
- On the array of operators, click the greater than or equal to button (>=)
- Type in "365" (with the quotes). For other codes, see http://www.uky.edu/KGS/PTTC/miscdata/strtcode.htm
- The expression should look like, parentheses included: ([Tdfm]>="365")
- Click OK (the expression will be copied into the Definition dialog box)
- Click OK to apply the expression
- Click the check box for the oil and gas well shape file to display it
- Select the wells west of 86 degrees longitude and make a new shape file
- With the oil and gas well shape file the active theme, click the Query Builder button on the tool bar (hammer with question mark icon)
- Scroll down and double click on Lonnad83 to select the field
- Type in ".AsNumber" (without the quotes, but with the leading period)
- Click the less than or equal to operator
- Type in "(-86.0)" (without the quotes)
- The expression should look like, parentheses included: ([Lonnad83].AsNumber <= (-86.0))
- Click the New Set button and close the query window when ArcView finishes computing
- Click Theme | Convert to Shape File
- Enter and new theme name (like WKYPRET.SHP)
- No, do not save the file in the projected units (leave it in decimal degrees)
- Yes, add the new shape file to the view
- Click on the new theme to make it active
- Click Theme | Edit Legend
- Click the Load button
- Find the file KYOG83V2.AVL (KYOG83.AVL on the KGSampler CD-ROM), click OK
- In the Load Legend window, select the Result field and make sure the All choice is checked, click OK
- Click Apply, then close the Legend editor window
- Summarize Pretrenton wells by county
- Click the WKYPRET.SHP entry in the views table of contents to make it active
- Click the open theme table button (with grid over a sheet of paper icon)
- Click the county entry in the views table of contents to make it active
- Click the open theme table button
- In the Attributes of county window, click on the Shape field header (it should turn dark gray). Note the values in this field are all "Polygon."
- In the Attributes of WKYPRET.SHP window, click on the Shape field header. The values in this field are "Point."
- The Join button on the toolbar (to the left of the sigma icon) becomes active. Click it.
- In the new, joined, table, scroll right and find the Name field. Click on the Name field column header.
- Click the summarize button on the tool bar (sigma icon).
- Change the name of the output file (if you want)
- Click OK to create a dBase format file of the summary information. The table will be made available; see the list of tables in the project window (click Tables).
- Make the summary data available and post it on the map
- Click on the Name field in the summary data table
- Open the table for the county theme
- Click on the Name field in the county theme table
- Click the Join button
- Close all the tables
- In the view, make the county theme active
- Click Theme | Autolabel
- Set the label field to count
- Select "Use Themes Text Label Placement Property"
- Click OK (Note that along the Hopkins and Muhlenberg County boundaries and in the New Madrid Bend area of Fulton County, there are several isolated polygons that get labeled with duplicate
values. This can be fixed by selecting each duplicate label and pressing the delete key.)
© 2000 Kentucky Geological Survey, University of Kentucky