Ontario Petroleum Wells

Petroleum wells detail

@kaggle.vaishnavivenkatesan_ontario_petroleum_wells

Table List

1 table(3.4 MB)

Petroleum Well

@kaggle.vaishnavivenkatesan_ontario_petroleum_wells.petroleum_well

3.4 MB
26666 rows
42 columns

x X	y Y	objectid OBJECTID	ogf_id OGF ID	well_id WELL ID	licence_number LICENCE NUMBER	well_name WELL NAME	operator OPERATOR	well_type WELL TYPE	well_mode WELL MODE	surface_latitude_83 SURFACE LATITUDE 83	surface_longitude_83 SURFACE LONGITUDE 83	bottom_latitude_83 BOTTOM LATITUDE 83	bottom_longitude_83 BOTTOM LONGITUDE 83	location_accuracy LOCATION ACCURACY	location_source LOCATION SOURCE	ground_elevation GROUND ELEVATION	total_depth TOTAL DEPTH	true_vertical_depth TRUE VERTICAL DEPTH	county COUNTY	township TOWNSHIP	lot LOT	concession CONCESSION	north_south_boundary NORTH SOUTH BOUNDARY	north_south_flg NORTH SOUTH FLG	east_west_boundary EAST WEST BOUNDARY	east_west_flg EAST WEST FLG	offshore_block OFFSHORE BLOCK	offshore_tract OFFSHORE TRACT	vertical_flg VERTICAL FLG	horizontal_flg HORIZONTAL FLG	directional_flg DIRECTIONAL FLG	deepening_flg DEEPENING FLG	reentry_flg REENTRY FLG	lateral_flg LATERAL FLG	spud_date SPUD DATE	total_depth_reached_date TOTAL DEPTH REACHED DATE	plugging_end_date PLUGGING END DATE	map_symbol_code MAP SYMBOL CODE	geometry_update_datetime GEOMETRY UPDATE DATETIME	effective_datetime EFFECTIVE DATETIME	system_datetime SYSTEM DATETIME
-80.2181980033342	43.1335362544316	130116593	244130641	32702	F020287	Bow Park Farm Well #9	Bow Park Farms	Natural Gas Well	Unknown	43.13352778	-80.21819444	43.13352778	-80.21819444	Within 200 metres	Well Records (pre 1921)	185.93	192.33	192.33	Brant	Brantford	15	OT		X		X	nan	nan	Y	N	N	N	N	N	Fri Jan 01 1904 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 1904 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	GP - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-80.2063091984932	43.12111955279	130116609	244130642	32703	F020288	Bow Park Farm Well #3	Bow Park Farms	Natural Gas Well	Unknown	43.12111111	-80.20630556	43.122	-80.20708333	Within 500 metres	Part Lot Centroid	182.97	186.23	186.23	Brant	Brantford	8	OT		X		X	nan	nan	Y	N	N	N	N	N	Fri Jan 01 1904 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 1904 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	GP - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-80.2136425001766	43.1138973511657	130116625	244130643	32704	F020289	Bow Park Farm Well #6	Bow Park Farms	Natural Gas Well	Unknown	43.11388889	-80.21363889	43.11388889	-80.21363889	Within 200 metres	Well Records (pre 1921)	197.42	197.51	197.51	Brant	Brantford	7	OT		X		X	nan	nan	Y	N	N	N	N	N	Fri Jan 01 1904 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 01 1904 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	GP - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-80.3372814447827	43.1773973565834	130116641	244130644	32705	F020290	Brant Hydro Station	Unknown	Dry Hole	Unknown	43.17738889	-80.33727778	43.17738889	-80.33727778	Within 200 metres	Well Records (pre 1921)	222.81	102.11	102.11	Brant	Brantford	19	I	60.96	N		X	nan	nan	Y	N	N	N	N	N	Wed Jan 01 1800 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 1800 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	DH - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-80.2090036004626	43.1338973549276	130116657	244130645	32706	F020291	Bow Park Well #7	Bow Park Farms	Gas Show	Unknown	43.13388889	-80.209	43.13458333	-80.20772222	Within 1,000 metres	Lot Centroid	199.64	187.76	187.76	Brant	Brantford		OT		X		X	nan	nan	Y	N	N	N	N	N	Wed Jan 01 1800 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 1800 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	GS - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-83.0788376968926	42.0433387222015	130116673	244130646	32707	F020292	Reed #1	Downstoetter	Dry Hole	Unknown	42.04333056	-83.07883333	42.09720361	-83.11039444	Within 50 metres	Well Records (1921 to 1954)	176	302.06	302.06	Essex	Malden	3	III	30.48	N	182.88	E	nan	nan	Y	N	N	N	N	N	Mon Jan 01 1940 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 01 1940 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	DH - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-80.7749481364001	42.6510361423473	130116689	244130647	32708	F020293	D.H. Burth - Dominion Natural Gas	Dominion Natural Gas Co. Ltd.	Natural Gas Well	Abandoned Well	42.65102778	-80.77494444	42.65102778	-80.77494444	Within 50 metres	Well Records (1921 to 1954)	194	438.91	438.91	Elgin	Bayham	18	I		X		X	nan	nan	Y	N	N	N	N	N	Wed Jan 01 1800 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 1800 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Sep 19 1935 00:00:00 GMT+0000 (Coordinated Universal Time)	GP - ABD	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-82.3083097786857	42.2553970980018	130116705	244130648	32709	F020294	John T. James #1 - United Oil Co.	United Oil Co.	Oil Well	Unknown	42.25538889	-82.30830556	42.25113889	-82.30897222	Within 200 metres	Well Records (pre 1921)	185.93			Kent	Tilbury East	11	NMR		X		X	nan	nan	Y	N	N	N	N	N	Mon Jan 01 1906 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 01 1906 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	OP - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-82.3036985772174	42.2548970981379	130116721	244130649	32710	F020295	Harvey Scott #1 - Swanson, Lernbech, Stranberg	Swanson, Lernbech, Stranberg	Oil Well	Unknown	42.25488889	-82.30369444	42.25744444	-82.30041667	Within 200 metres	Well Records (pre 1921)	184.4			Kent	Tilbury East	10	NMR		X		X	nan	nan	Y	N	N	N	N	N	Sun Jan 01 1905 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 01 1905 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	OP - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)
-82.2602263598505	42.2102859922884	130116737	244130650	32711	F020296	Pattinson & Ladd & Kabana	Pattinson, Ladd, Kabana	Natural Gas Well	Unknown	42.21027778	-82.26022222	42.21027778	-82.26022222	Within 200 metres	Well Records (pre 1921)	192.33	419.71	419.71	Kent	Tilbury East	7	XIV		X		X	nan	nan	Y	N	N	N	N	N	Mon Jan 01 1934 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 01 1934 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	GP - UNK	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)	Wed Sep 23 2020 14:27:56 GMT+0000 (Coordinated Universal Time)


CREATE TABLE petroleum_well (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "ogf_id" BIGINT,
  "well_id" BIGINT,
  "licence_number" VARCHAR,
  "well_name" VARCHAR,
  "operator" VARCHAR,
  "well_type" VARCHAR,
  "well_mode" VARCHAR,
  "surface_latitude_83" DOUBLE,
  "surface_longitude_83" DOUBLE,
  "bottom_latitude_83" DOUBLE,
  "bottom_longitude_83" DOUBLE,
  "location_accuracy" VARCHAR,
  "location_source" VARCHAR,
  "ground_elevation" DOUBLE,
  "total_depth" DOUBLE,
  "true_vertical_depth" DOUBLE,
  "county" VARCHAR,
  "township" VARCHAR,
  "lot" VARCHAR,
  "concession" VARCHAR,
  "north_south_boundary" DOUBLE,
  "north_south_flg" VARCHAR,
  "east_west_boundary" DOUBLE,
  "east_west_flg" VARCHAR,
  "offshore_block" VARCHAR,
  "offshore_tract" VARCHAR,
  "vertical_flg" VARCHAR,
  "horizontal_flg" VARCHAR,
  "directional_flg" VARCHAR,
  "deepening_flg" VARCHAR,
  "reentry_flg" VARCHAR,
  "lateral_flg" VARCHAR,
  "spud_date" TIMESTAMP,
  "total_depth_reached_date" TIMESTAMP,
  "plugging_end_date" TIMESTAMP,
  "map_symbol_code" VARCHAR,
  "geometry_update_datetime" TIMESTAMP,
  "effective_datetime" TIMESTAMP,
  "system_datetime" TIMESTAMP
);