Dataset: Top Hole - Bottom Hole Straight Line Connection (BNG)

About this Dataset

Top Hole - Bottom Hole Straight Line Connection (BNG)

{{description}}
Publisher name: North Sea Transition Authority
Last updated: 2025-06-16T04:00:05Z

Tables

Table 1

@ukgov.top_hole_bottom_hole_straight_line_connection_bng3.table_1

467.05 KB
2110 rows
128 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "w_id" BIGINT,
  "wellboreid" BIGINT,
  "wellregno" VARCHAR,
  "spuddate" TIMESTAMP,
  "datetdreac" TIMESTAMP,
  "compledate" TIMESTAMP,
  "releasedat" TIMESTAMP,
  "subareaop" VARCHAR,
  "subopno" VARCHAR,
  "subopprev" VARCHAR,
  "subopgrp" VARCHAR,
  "tdoperator" VARCHAR,
  "tdsaopnum" VARCHAR,
  "tdopprev" VARCHAR,
  "tdopgrp" VARCHAR,
  "entitytype" VARCHAR,
  "repentreas" VARCHAR,
  "datarepent" VARCHAR,
  "dataentnum" VARCHAR,
  "dataenprev" VARCHAR,
  "dataengrp" VARCHAR,
  "targetfld" VARCHAR,
  "licno" VARCHAR,
  "lictype" VARCHAR,
  "origintent" VARCHAR,
  "currwellin" VARCHAR,
  "deviattyp" VARCHAR,
  "datumtype" VARCHAR,
  "datelev_f" DOUBLE,
  "datelev_m" DOUBLE,
  "topholedtm" VARCHAR,
  "topholeydd" VARCHAR,
  "topholexdd" VARCHAR,
  "topholeyge" VARCHAR,
  "topholexge" VARCHAR,
  "topholeyng" DOUBLE,
  "topholexng" DOUBLE,
  "tphlbngref" VARCHAR,
  "botholedtm" VARCHAR,
  "botholeydd" VARCHAR,
  "botholexdd" VARCHAR,
  "bh_easting" DOUBLE,
  "bh_northin" DOUBLE,
  "bh_bng_ref" VARCHAR,
  "tdlicno" VARCHAR,
  "tddepdatty" VARCHAR,
  "tddatdep_f" DOUBLE,
  "tddatdep_m" DOUBLE,
  "tdmddepf" DOUBLE,
  "tdmddepm" DOUBLE,
  "tdtvdssf" DOUBLE,
  "tdtvdssm" DOUBLE,
  "td_age" VARCHAR,
  "released" VARCHAR,
  "parentwell" VARCHAR,
  "stmddepf" DOUBLE,
  "stmddepm" DOUBLE,
  "sttvdssf" DOUBLE,
  "sttvdssm" DOUBLE,
  "compop" VARCHAR,
  "compopnum" VARCHAR,
  "compopprev" VARCHAR,
  "roporg" VARCHAR,
  "respopnum" VARCHAR,
  "resopgrp" VARCHAR,
  "roporgprev" VARCHAR,
  "wellorigin" VARCHAR,
  "originstat" VARCHAR,
  "complestat" VARCHAR,
  "wellopstat" VARCHAR,
  "wellsuffix" VARCHAR,
  "wellalias" VARCHAR,
  "name" VARCHAR,
  "primarytar" VARCHAR,
  "prospect" VARCHAR,
  "devtype" VARCHAR,
  "pprswellno" VARCHAR,
  "denno" DOUBLE,
  "drillseqno" BIGINT,
  "discovery" VARCHAR,
  "regowned" VARCHAR,
  "licconfper" DOUBLE,
  "wellsymbol" DOUBLE,
  "mapsymdesc" VARCHAR,
  "flowclass" VARCHAR,
  "otherclass" VARCHAR,
  "fluidtypes" VARCHAR,
  "origopname" VARCHAR,
  "wellconven" VARCHAR,
  "uncweltyp" VARCHAR,
  "tempclass" VARCHAR,
  "pressclass" VARCHAR,
  "wellseq" VARCHAR,
  "mntdtempc" DOUBLE,
  "mntdtempf" DOUBLE,
  "mxtdtempc" DOUBLE,
  "mxtdtempf" DOUBLE,
  "releaseno" VARCHAR,
  "sdtrktype" VARCHAR
);