Ontario Petroleum Wells
Petroleum wells detail
@kaggle.vaishnavivenkatesan_ontario_petroleum_wells
Petroleum wells detail
@kaggle.vaishnavivenkatesan_ontario_petroleum_wells
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
);
Anyone who has the link will be able to view this.