Ohio Oil and Gas Data Sources - Revision history

Wiki at 23:21, 15 January 2021

2021-01-15T23:21:18Z

Wiki at 21:29, 30 August 2019

2019-08-30T21:29:57Z

Mason: added documentation tag

2015-07-07T15:06:44Z

added documentation tag

Mason at 22:43, 6 July 2015

2015-07-06T22:43:46Z

James Gilbert: /* Production */

2015-07-01T16:28:25Z

‎Production

James Gilbert: /* References */

2015-06-30T14:35:52Z

‎References

James Gilbert at 14:04, 30 June 2015

2015-06-30T14:04:45Z

James Gilbert: /* Production */

2015-06-30T14:03:49Z

‎Production

James Gilbert: /* References */

2015-06-30T14:01:35Z

‎References

James Gilbert at 13:59, 30 June 2015

2015-06-30T13:59:06Z

← Older revision		Revision as of 23:21, 15 January 2021
Line 55:		Line 55:

	Overall, this release resulted in the generation of {{PAGESINCATEGORY:Ohio_Wells}} new or modified Ohio Well Pages; {{PAGESINCATEGORY:Ohio_Operators}} new or modified Ohio Operator Pages; {{#number_format:{{#expr:{{formatnum:{{PAGESINCATEGORY: Ohio_counties}}\|R}}+{{formatnum:{{PAGESINCATEGORY:Ohio_Municipalities}}\|R}}}}}} new or modified Ohio County and Municipality Pages; and {{PAGESINCATEGORY:Ohio_Well_Pads}} new or modified Ohio Well Pad Pages.The team for this project consisted of Joel Gehman, Michael Boisvert and Ankesh Kumar. Funding for the project was provided in part by financial support from the Social Sciences and Humanities Research Council of Canada and the University of Alberta, as well as in-kind support University of Alberta School of Business.		Overall, this release resulted in the generation of {{PAGESINCATEGORY:Ohio_Wells}} new or modified Ohio Well Pages; {{PAGESINCATEGORY:Ohio_Operators}} new or modified Ohio Operator Pages; {{#number_format:{{#expr:{{formatnum:{{PAGESINCATEGORY: Ohio_counties}}\|R}}+{{formatnum:{{PAGESINCATEGORY:Ohio_Municipalities}}\|R}}}}}} new or modified Ohio County and Municipality Pages; and {{PAGESINCATEGORY:Ohio_Well_Pads}} new or modified Ohio Well Pad Pages.The team for this project consisted of Joel Gehman, Michael Boisvert and Ankesh Kumar. Funding for the project was provided in part by financial support from the Social Sciences and Humanities Research Council of Canada and the University of Alberta, as well as in-kind support University of Alberta School of Business.
		+
		+
		+	==Ohio v4.0 (January 2021)==
		+	This was the fourth release of Ohio oil and gas data on Wellwiki. All the data for this upgrade came from the Ohio Department of Natural Resources website <ref name = 'a1'>{{cite web \| title = OIL & GAS WELL DATABASE \| url = https://ohiodnr.gov/wps/portal/gov/odnr/discover-and-learn/safety-conservation/about-odnr/oil-gas/oil-gas-resources/featured-content-3}}</ref>. This update contains data up to November 2020. The tables used from the database are:
		+
		+	• Codes
		+
		+	• Company
		+
		+	• Format
		+
		+	• Perfs
		+
		+	• Production
		+
		+	• tblInspection
		+
		+	• tblInspectorStringCement
		+
		+	• tblInspFail
		+
		+	• tblLocational
		+
		+	• tblStimulation
		+
		+	• Well
		+
		+	• WellHistry
		+
		+
		+
		+	Overall, this upgrade resulted in the generation of 272,155 new or modified Ohio Well Pages; 9,097 new or modified Ohio Operator Pages; 1,743 new or modified Ohio Municipality Pages and 88 new or modified Ohio County Pages. The team for this project consisted of Joel Gehman, Cole Miller, and Georgio Cheruvelil. Financial support and in-kind support for this project was provided by the University of Alberta School of Business.
		+

	==References==		==References==

@@ Line 1: / Line 1: @@
 __TOC__
-There is no information in the access database pertaining to Penalties or Waste.
+==Ohio v1.0 (September 2014)==
-All production information originates from the table "Production" within RBDMS. All content on site was last updated using data from 2015-06-15.
+==Ohio v2.0 (July 2015)==
-This database provides information regarding the Wells in Ohio, as well as their production information. Compliance data is also present.
+==Ohio v3.0 (July 2019)==

← Older revision		Revision as of 15:06, 7 July 2015
Line 1:		Line 1:
−		+	[[Category:Documentation]]
	__TOC__		__TOC__

@@ Line 2: / Line 2: @@
 __TOC__
-== 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.

← Older revision		Revision as of 16:28, 1 July 2015
Line 10:		Line 10:

	There seems to be no information in the access database pertaining to Penalty, Permit, Violation, or Waste.		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 obtained from the production table within the [http://oilandgas.ohiodnr.gov/production Risk Based Data Management System] (RBDMS). The table is available 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==		== Technical Information for Importing to MySQL==

← Older revision		Revision as of 14:35, 30 June 2015
Line 37:		Line 37:

	There is information regarding Compliance within our MySQL database, but this information needs to be located.		There is information regarding Compliance within our MySQL database, but this information needs to be located.
−
−
−
−	~~=References=~~
−	~~{{reflist}}~~

@@ Line 14: / Line 14: @@
 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 obtained from the production table within the [http://oilandgas.ohiodnr.gov/industry/rbdms Risk Based Data Management System] (RBDMS). The table is available 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).
+Annual production information may be obtained from the production table within the [http://oilandgas.ohiodnr.gov/production Risk Based Data Management System] (RBDMS). The table is available 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==

← Older revision		Revision as of 14:01, 30 June 2015
Line 41:		Line 41:

	=References=		=References=
−	{{reflist~~\|30em~~}}	+	{{reflist}}

← Older revision		Revision as of 13:59, 30 June 2015
Line 37:		Line 37:

	There is information regarding Compliance within our MySQL database, but this information needs to be located.		There is information regarding Compliance within our MySQL database, but this information needs to be located.
		+
		+
		+
		+	=References=
		+	{{reflist\|30em}}