 Click to Search OIL AND GAS WELL DATABASE Updated 9/15/2008
This online search is linked directly to the RBDMS database, therefore a search always yields the most current well information. Access more than 250,000 Ohio oil and gas well records including completion, permit and production information.
INSTRUCTIONS - How to Use the Oil and Gas Well Database Updated 12/19/2008
Basic Instructions for All Searches
Downloads
- Active Well Owners
- County Engineer's List
- Permit and Plug List
- Printing Download Table
Emergency Response
- Printing Emergency Response Table
Reports
- Printing Reports
- Completions (including annual production and well images)
-- API Well Number Search
-- Well Permit # and County Search
-- Operator Name and Well Name Searches
- Corrections
- County Engineers List
- Permit and Plug List
Problems & Quick Solutions (to get correct information)
- Blank table or report
- Cannot view well images
- Cannot view entire Ohio Well Completions Report
- Open browser with map of well location might not work
Other Problems
- Producing Formation search field is not working
- Corrections search is not working
- Slow search
Other Useful Information
 Basic Instructions for All Searches
- Select a search operator in the middle box across from the field(s) you want to use; usually Like or Equal.
-- Like searches for results that include what is selected from the dropdown menu or entered;
-- Equal is an exact search.
- Select a search operator for every row search data are selected or entered.
- Click the right-most box to enter/select the data you want to search by.
- Repeat these two steps for every field you want to use to search.
-- Do not alter a row if it is not being used to search.
- Click Report to display results.
Downloads
The searches in the Downloads folder provide information in table format that can be exported into Microsoft Excel spreadsheets. Search criteria can be used to customize these tables. To access these searches, click the plus sign next to Downloads and then click the type of search you wish to perform. Note: Results are limited to 1,000 records per search.
-
Active Well Owners search creates a table with registered well owners/companies in Ohio.
-
County Engineers List creates a table of applications received.
-
Permit and Plug List creates a table of issued permits.
Active Well Owners
There are three search criteria to limit results: Operator Name, City and Zip Code (5 digit).
-
Operator Name will yield the most precise results when the name is entered in the same format it appears on a permit. If this does not yield a result, try either a keyword from the company name or enter the last name first, if it is a person's name. (Operator name is the same as company name or active well owner.)
-
City and Zip Code (5 digit) refer to the mailing address of the active well owner and not to where they are active in drilling or plugging.
County Engineers List
There are five search criteria to limit results: Date Application Received, County, Operator Name, Application Type, and Township.
- Date Application Received.
- County and Township refer to the proposed well location.
- Operator Name is the owner/company that applied for the permit.
- Application Type refers to the action to be performed such as Drill a New Well, Plug Back, or Plug and Abandon.
Permit and Plug List
This list refers to issued permits. There are eight search criteria to limit results: Application Issued Date, County, Township, Operator Name, Application Type, Section Number, Lot, and Permit or Plug.
- Application Issued Date is the date the permit was issued.
- County, Township, Section Number, and Lot refer to the well location.
- Operator Name is the owner/company that applied for the permit.
- Application Type is the type of permit being requested.
- Permit or Plug is the option to search for only permits to drill (Permit) or permits to plug (Plug).
Printing Download Table
To print Download Table:
- Click Excel Export;
- Microsoft Excel will either open with data OR the download table will change to the Excel format and data has to be selected, copied and pasted into Microsoft Excel.
- Format data in Excel as desired and print.
Emergency Response
This search provides information for producing wells in a table. Geographically based, it is used in cases of emergency to obtain owner contact information for the well. This information can also be useful for getting large lists of wells for whole counties or townships. To access this search, click the plus sign next to Emergency Response and then click Well Information.
There are three search criteria to limit results: County, Operator Name and Township. Search results can be exported to Microsoft Excel to be sorted. Results are limited to 1,000 records per search.
Printing Emergency Response Table
To print Emergency Response Table:
- Click Excel Export;
- Microsoft Excel will either open with data OR the emergency response table will change to the Excel format and data has to be selected, copied and pasted into Microsoft Excel.
- Format data in Excel as desired and print.
Reports
Searches in the Reports folder will produce reports for each well included in the query.
- Completions search is the most comprehensive including location, operator, formation, casing and annual production information (where the data is available). This is the best search to get individual well information. There is a limit of 20 completion reports per search.
- Corrections search will create a report of corrections to permits within a designated time period.
- County Engineers search will create a report of applications received with select information provided for each application.
- Permit and Plug List search will create a report of all the permits issued within a specified time frame.
Both County Engineers and Permit and Plug List searches can be customized by various search criteria like location and owner/company name to get particular reports. To access these searches, click the plus sign next to Reports and then click the type of search you wish to perform.
Printing Reports
To print Completions Report:
- Click on 'Select a format' box (at top of report in tan area)
- Click on either Excel or Acrobat (PDF) file;
- Click on Export;
- Box will appear asking to either Open or Save File;
-- Open File will open either Microsoft Excel or Adobe Reader to display file for printing.
-- Save will query where to save the file.
Completions (including Annual Production and Well Images)
The Completions search has 12 search criteria. Each search returns up to twenty (20) Ohio Well Completion Reports. These reports contain the most information for each well. To view the entire report, including annual production and link to well image(s), you may need to scroll down. (Note the two scroll bars.) Well images might include permit application, surveyor's plat, completion report, and other misc. information. Most Completion searches will either involve searching by API Well Number, Permit Number, or Operator Name or Well Name.
API Well Number Search
- Click on the plus sign next to Reports;
- Click on Completions;
- Select a search operator in the middle box across from API well number;
-- Equal, when all 14 numbers are known;
-- Like, when most of the numbers are known;
(See Permit Number Search section to search with 4 or 5 digit permit number.)
- Click the right-most box to enter API well number; do not use dashes or spaces (for example, 34153229730000);
- Do not change any other fields;
- Click Report above API well # to display results.
Permit Number and County Search
- Click on the plus sign next to Reports;
- Click on Completions;
- Select search operator in middle box across from Permit Number;
-- Equal, when all 5 numbers are known;
-- Like, when 4 or less numbers are known;
- Click the right-most box to enter Permit Number; enter no dashes or spaces;
- Select Equal in middle box across from County;
- Click the right-most box to select County;
- Do not change any other fields;
- Click Report above API well # to display results.
Operator Name and Well Name Searches (use with County and Township searches)
- Click on the plus sign next to Reports;
- Click on Completions;
- Select Like in middle box across from either Operator Name or Well Name;
- Click right-most box to enter name;
-- Search by unique part of name;
-- If it is a person's name, enter the last name first and do not use a comma;
- Click Report above API well # to display results.
Corrections
The Corrections Search is currently not working.
County Engineers List
The County Engineers List search creates small reports of the applications received. There are five search criteria to limit the search results: Date Application Received, County, Operator Name, Application Type and Township.
- Date Application Received.
- County and Township refer to the proposed well location.
- Operator Name is the owner/company that applied for the permit..
- Application Type refers to the action to be performed such as Drill New Well, Plug Back, or Plug and Abandon.
Permit and Plug List
The Permit and Plug List search creates small reports of permits issued. There are eight search criteria to limit the search results: Application Issued Date, County, Township, Operator Name, Application Type, Section Number, Lot, and Permit or Plug.
- Application Issued Date.
- County, Township, Section Number and Lot refer to the well location.
- Operator Name is the owner/company that applied for the permit.
- Application Type is the action being performed.
- Permit or Plug is the option to search for only permits to drill or permits to plug.
Permit and Plug List can be limited to a particular time period using the Application Issued Date. For example, to limit the list to the last week, click the middle box (across from the Application Issued Date) to select Greater Than or Equal, then click the right-most box to enter the date for a week ago. The report will include all permits issued from that date until the current date.
PROBLEMS & QUICK SOLUTIONS (to get correct information)
The Oil and Gas Well Database was implemented in January 2008 and since that time we continue to discover and fix problems. These are addressed below along with solutions to get the correct results.
- Blank table or report. This may result
- when there are no records to match what was entered,
- if too many search criteria are used,
- when incorrect search criteria is entered,
- when the database is being heavily used, or
- if a Producing Formation is selected.
First, click the #2 Search bar, check what was entered, and click Report again. If this does not work, reduce the number of search criteria used and search again. If it still does not work, consult the Other Problems section of this page below.
- Cannot view well images. When clicking the Link to Image(s) at the bottom of the Ohio Well Completions Report, a box will query whether to save or open the images. After clicking Open, the images should appear. The link containing the word Geosurvey is a PDF file of the well card. The other images are TIFF files that contain multiple images. They can be viewed with Windows Picture and Fax Viewer or Microsoft Office Document Imaging.
You may need to change your viewer if you cannot successfully view multiple images per file. Some viewers, like QuickTime, will only view the first image. Windows Picture and Fax Viewer works well. Follow the following setup procedure: start with Explore; then Tools/Folder Options/File Types; next look for the .TIF extension; next click Change or Select New; finally select Windows Picture and Fax Viewer. If unsuccessful, contact Gregg Miller for assistance at 614-265-6915.
- Cannot view entire Ohio Well Completions Report. Depending on your internet browser, you may need to scroll down to view formation and production information and links to well images. Note: There are two scroll bars.
- Open browser with map of well location might not work. When clicking the link "open browser with map of well location" near bottom of Ohio Well Completions Report, a new window opens in Google Maps. When working correctly, the well location map should appear. If Google cannot plot well location, add a closing parenthesis within the Google search field and click Search Maps.
OTHER PROBLEMS
These problems occur in the database, but there are no solutions currently to get speedy or correct results if trying to use the following:
- Producing Formation search field is not working properly. Any search that includes the use of the Producing Formation field will usually result in a blank report or incomplete results.
- Corrections search is currently not working.
- Slow search. Every search creates a new report each time a search is performed. When the database is being heavily used, generally during the afternoon, additional processing time is required.
Database comments and questions can be directed to Kelly Barrett, (614) 265-6502.
OTHER USEFUL INFORMATION
Oil and Gas Well Locator - Interactive map showing well location.
Active Brine Haulers - For a current list, contact Tom Tomastik at (614) 265-1032
Well Record Definitions - list of fields on a completion report
County Codes List (3-digit) |