Ohio Oil and Gas Data Sources

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.

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.