Dataset: Ontario Petroleum Wells

About this Dataset

Ontario Petroleum Wells

Context

This data set consist of information about the petroleum wells at Ontario.

Content

This file consist of various fields such as license number, well name , operator and well type.

Acknowledgements

This is done during the internship at Tact Labs.

Tables

Petroleum Well

@kaggle.vaishnavivenkatesan_ontario_petroleum_wells.petroleum_well

3.4 MB
26666 rows
42 columns


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
);