|
|
| Line 2: |
Line 2: |
| | __TOC__ | | __TOC__ |
| | | | |
| | + | All data is obtained from the Ohio Risk Based Data Management System, an access database hosted at: http://oilandgas.ohiodnr.gov/industry/rbdms |
| | | | |
| − | == Source Information ==
| + | There is no information in the access database pertaining to Penalties or Waste. |
| | | | |
| − | All data is obtained from an access database hosted at: http://oilandgas.ohiodnr.gov/industry/rbdms
| + | ==Production== |
| | | | |
| − | This database provides information regarding the Wells in Ohio, as well as their production information. Compliance data is also present.
| + | All production information originates from the table "Production" within RBDMS. All content on site was last updated using data from 2015-06-15. |
| | | | |
| − | There seems to be no information in the access database pertaining to Penalty, Permit, Violation, or Waste.
| + | ==Inspection== |
| | | | |
| − | == Technical Information for Importing to MySQL==
| + | This database provides information regarding the Wells in Ohio, as well as their production information. Compliance data is also present. |
| − | 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[http://wellwiki.org/wiki/Pennsylvania_Oil_and_Gas_Data_Sources].
| |
| − | | |
| − | | |
| − | '''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.
| |
All data is obtained from the Ohio Risk Based Data Management System, an access database hosted at: http://oilandgas.ohiodnr.gov/industry/rbdms
There is no information in the access database pertaining to Penalties or Waste.
Production
All production information originates from the table "Production" within RBDMS. All content on site was last updated using data from 2015-06-15.
Inspection
This database provides information regarding the Wells in Ohio, as well as their production information. Compliance data is also present.