Source Information

All data is obtained from an access database hosted at: http://oilandgas.ohiodnr.gov/industry/rbdms

This database provides information regarding the Wells in Ohio, as well as their production information. Compliance data is also present.

There seems to be no information in the access database pertaining to Penalty, Permit, Violation, or Waste.

Production

Ohio State law mandates that owner of any well capable of producing oil or natural gas must report oil, gas and brine production data from each well they own, on an annual basis by March 31 for the preceding calendar year. Some domestic well owners are exempt and are not required to file production statements.

Annual production information may be downloaded by year, beginning in 1984. Each record contains the following fields: production year, county, township, API well number, permit number, owner name, well name, well number, oil (1 barrel = 42 US gallons), gas (1 MCF = 1,000 cubic feet of gas), brine (1 barrel = 42 US gallons), the number of production days, date completed, and the plugging date (where applicable).

Technical Information for Importing to MySQL

As data is in an access database, it is easiest to export the tables required to an excel file, where it can then be edited and saved as a CSV. From here, it can be imported with ease to MySQL using similar procedures as detailed for Pennsylvania[1].

Production:

Most recent time of update found by searching "34%" in WELL_API for production table, after which PERIOD_ID was sorted in reverse order. WELL_API in the form of 34003249030000 instead of 34-003-24903(-0000) like PA. Stored in the MySQL database in this form as well. Not sure how to get the PRODUCTION_ID - we can use DATE_MOD with [$-409]yyyy-MM;@ formatting in excel to obtain a 2015-5 style of PERIOD_ID like the rest of the database. Unsure if this is genuinely accurate as the year of production and the date mod can differ.

Well:

WELL_API is in the form 34-XXX-XXXXX, access table in the form 34XXXXXXXXXXXX. Using excel with =LEFT(A2,2) & "-" & MID(A2,3,3) & "-" & MID(A2,6,5)) we can convert this.

""TODO:""

There is information regarding Compliance within our MySQL database, but this information needs to be located.