• To begin search, click the plus sign to open appropriate folder; then click the search you wish to perform.
• 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.

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: Active Well Owner search provides unlimited results. For County Engineers List and Permit/Plug List, 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.

If no search criteria is used, a complete list of active well owners is provided by clicking the white "Report" button. However, 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.

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.

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).

Microsoft Excel 2002 or newer version is required for the Excel Export to work with most web browsers except Mozilla Firefox.
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.

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 10,000 records per search.

Microsoft Excel 2002 or newer version is required for the Excel Export to work with most web browsers except Mozilla Firefox.
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.

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 100 completion reports per search.
• Corrections search will create a report of corrections to permits.
• 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.

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.

The Completions search has 12 search criteria. Each search returns up to one hundred (100) 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.

• 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); the first two numbers are 3 4 for Ohio; next three numbers are the County Code; next five numbers are the Permit Number; last four numbers are either 0000 or 0100.
• Do not change any other fields;
• Click Report above API well # to display results.

• 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.

• 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.

The Corrections Search creates a report of changes to issued permits. There are four (4) criteria to limit the search results: Date Effective, County, Township, and Operator Name. Correction Search returns up to six pages of results.

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. Results are limited to 1,150 records per search.

• 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.

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. Results are limited to 1,150 records per search.

• 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.

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.

1. 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.
2. 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.
3. 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 on the bottom and on the right side of the screen.
4. 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 should appear on the map. If Google cannot plot well location, add a closing parenthesis within the Google search field and click Search Maps.

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.
• 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 Martin Breunig, (614) 265-6926.