Baselight

Pipelines Linear - Removed (ETRS89)

North Sea Transition Authority

@ukgov.pipelines_linear_removed_etrs892

About this Dataset

Pipelines Linear - Removed (ETRS89)

Tables

Table 1

@ukgov.pipelines_linear_removed_etrs892.table_1
  • 30 KB
  • 67 rows
  • 35 columns
Loading...

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feature_id" VARCHAR,
  "nstapipno" VARCHAR,
  "pipe_name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "fluid" VARCHAR,
  "pipe_sys" VARCHAR,
  "descriptio" VARCHAR,
  "status" VARCHAR,
  "comments" VARCHAR,
  "diametermm" DOUBLE,
  "length_m" DOUBLE,
  "insul_type" VARCHAR,
  "int_diam" BIGINT,
  "mx_op_pres" BIGINT,
  "thickness" BIGINT,
  "bundle" BIGINT,
  "bundle_flg" VARCHAR,
  "crs_code" BIGINT,
  "crs_name" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "untrenched" VARCHAR,
  "exposed" VARCHAR,
  "upd_date" TIMESTAMP,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "rep_owner" VARCHAR,
  "rep_opertr" VARCHAR,
  "rep_holder" VARCHAR,
  "shape_length" DOUBLE,
  "simplified" VARCHAR
);