Surface Points - Removed (WGS84)
North Sea Transition Authority
@ukgov.surface_points_removed_wgs844
North Sea Transition Authority
@ukgov.surface_points_removed_wgs844
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid" BIGINT,
"feature_id" VARCHAR,
"name" VARCHAR,
"inf_type" VARCHAR,
"rep_group" VARCHAR,
"descriptio" VARCHAR,
"pipe_sys" VARCHAR,
"point_desc" VARCHAR,
"crs_code" BIGINT,
"crs_name" VARCHAR,
"orig_x_lon" DOUBLE,
"orig_y_lat" DOUBLE,
"status" VARCHAR,
"comments" VARCHAR,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP,
"end_reas" VARCHAR,
"upd_date" TIMESTAMP,
"upd_type" VARCHAR,
"upd_reas" VARCHAR,
"legacy_id" DOUBLE,
"plat_flag" VARCHAR
);
Anyone who has the link will be able to view this.