Proof of concept. This is an unofficial demo built by Datopian from the North Sea Transition Authority's public data. The official portal is NSTA Open Data. Questions or feedback: hello@datopian.com

UK England onshore petroleum wellbores bottom holes

A wellbore is a path of drilled footage from the Well Origin to a terminating point. The location of each wellbore is the wellbore's well origin. A well origin is the location on the surface of the earth or sea bed where the drill bit penetrates the earth to establish or rework a well. Definitions for wellbore and well origin taken from PPDM ‘what is a well: https://whatisawell.ppdm.org/ ’. Data collection starts once a well has been spudded when the operator submits a spud notification on WONS. The NSTA will issue an official well number via WONS, which is to be used for all data and records resulting from the well's drilling. All well data requirements are set out in the documents Petroleum Operations Notices (PON) 9 (offshore) and PON 9b (onshore). Onshore operators have a statutory obligation to also supply well data to the British Geological Survey (BGS). Visit the BGS website for more information. Well Bottom Hole is the bottom hole location of the borehole at its final measured total depth. Top Hole - Bottom Hole, Straight Line Connection is a straight line connection from the top hole location and bottom hole location, it is not a wellbore path.

Records
2,124
Formats
4
Last updated
5 Nov 2026

Download & API

UK England onshore petroleum wellbores bottom holes (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
UK England onshore petroleum wellbores bottom holes (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
UK England onshore petroleum wellbores bottom holes (map tiles)pmtiles
Vector tiles — embed in a map
Download
Live ArcGIS layer (source)arcgis
Download

Rendered from PMTiles, queried in-browser from GeoParquet — no server. How this works

Schema

FieldTypeValues
Well origin reference
WELLORIGIN
string
Well origin status
ORIGINSTAT
string4 values: Decommissioned (1,424), Present (696), Derogated (3)…
Parent wellbore
PARENTWELL
string
Well registration no.
WELLREGNO
string
Wellbore spud date
SPUDDATE
datetime
Wellbore td reached date
DATETDREAC
datetime
Wellbore completion date
COMPLEDATE
datetime
Release date
RELEASEDAT
datetime
Original wellbore intent
ORIGINTENT
string3 values: Development (1,119), Exploration (765), Appraisal (240)
Current wellbore intent
CURRWELLIN
string4 values: Development (1,149), Exploration (752), Appraisal (222)…
Development wellbore type
DEVTYPE
string4 values: Producer (486), Injector (107), Other (8)…
Wellbore mechanical status
COMPLESTAT
string6 values: Abandoned Phase 3 (1,394), Completed (Operating) (299), Abandoned Phase 1 (223)…
Wellbore operational status
WELLOPSTAT
string3 values: Decomissioned (1,394), Constructed (431), Suspended (299)
Well suffix
WELLSUFFIX
string12 values: Z (139), Y (58), R (28)…
Wellbore alias
WELLALIAS
string
Operator's wellbore name
NAME
string
Slot no.
SLOTNO
string
Is this wellbore multilateral?
MULTILAT
string2 values: N (2,015), Y (109)
Is this wellbore the designated well?
DESIGNATED
string2 values: Y (1,641), N (483)
Field name
TARGETFLD
string
Primary target idenfifying letter(s)
PRIMARYTAR
string
Prospect
PROSPECT
string9 values: Bowland Shale (3), West Newton (3), Broadford Bridge (2)…
Licence type
LICTYPE
string7 values: PL (780), ML (270), PEDL (201)…
Licence no. at well origin
LICNO
string
Licence no. at total depth (td)
TDLICNO
string
Subarea operator at well origin
SUBAREAOP
string
Subarea operator previous names
SUBOPPREV
string
Subarea operator group name
SUBOPGRP
string
Subarea operator at td
TDOPERATOR
string8 values: No Data Available (2,094), PERENCO UK LIMITED (13), ISLAND GAS LIMITED (12)…
Subarea operator at td previous names
TDOPPREV
string6 values: No Data Available (2,094), COTWOGAS LIMITED, BDO STOY HAYWARD (2003) LIMITED (12), COALGAS (UK) LIMITED (1)…
Subarea operator at td group name
TDOPGRP
string7 values: No Data Available (2,094), PERENCO OIL & GAS (13), STAR ENERGY GROUP PLC (13)…
Who is responsible for the wellbore
RESWOP
string11 values: No Data Available (2,066), INEOS UPSTREAM LIMITED (24), ISLAND GAS LIMITED (19)…
Responsible wellbore operator previous name
RESWOPPREV
string8 values: No Data Available (2,066), COTWOGAS LIMITED, BDO STOY HAYWARD (2003) LIMITED (19), CAIRN ENERGY PLC, NEW CAIRN ENERGY PLC, RANDOTTE (NO. 507) LIMITED (1)…
Responsible wellbore operator group name
RESWOPGRP
string10 values: No Data Available (2,066), INEOS INDUSTRIES (24), STAR ENERGY GROUP PLC (20)…
Why are they responsible for the wellbore
RESWOPRES
string3 values: Field Operator (16), Subarea Operator at Well Origin (8), Subarea Operator at TD (2)
Who is responsible for reporting data
RESDOP
string2 values: No Data Available (2,123), PERENCO UK LIMITED (1)
Responsible data operator previous name
RESDOPPREV
string1 values: No Data Available (2,123)
Responsible data operator group name
RESDOPGRP
string2 values: No Data Available (2,123), PERENCO OIL & GAS (1)
Why are they responsible for reporting data
RESDOPREAS
string
Deviation type
DEVIATTYP
string3 values: Vertical (1,282), Deviated (836), Horizontal (6)
Datum type
DATUMTYPE
string5 values: Rotary Table (1,500), Kelly Bushing (489), Ground Level Elevation (66)…
Datum elevation (ft)
DATELEV_F
number0 to 1,631
Datum elevation (m)
DATELEV_M
number0 to 497
Well origin surface datum
TOPHOLEDTM
string1 values: OSGB NG (2,124)
Top hole decimal degrees longitude
TOPHOLEXDD
string
Top hole decimal degrees latitude
TOPHOLEYDD
string
Top hole geographic longitude
TOPHOLEXGE
string
Top hole geographic latitude
TOPHOLEYGE
string
Top hole national grid longitude
TOPHOLEXNG
string
Top hole national grid latitude
TOPHOLEYNG
string
Well origin surface national grid reference
TPHLBNGREF
string
Wellbore td datum
BOTHOLEDTM
string1 values: OSGB NG (2,124)
Bottom hole decimal degrees longitude
BOTHOLEXDD
string
Bottom hole decimal degrees latitude
BOTHOLEYDD
string
Wellbore td national grid easting
BH_EASTING
number94,543 to 647,360
Wellbore td national grid northing
BH_NORTHIN
number77,101 to 952,167
Wellbore td national grid reference
BH_BNG_REF
string
Td depth datum type
TDDEPDATTY
string5 values: Rotary Table (1,439), Kelly Bushing (461), Ground Level Elevation (60)…
Td depth datum elevation (ft)
TDDATDEP_F
number0 to 1,631
Td depth datum elevation (m)
TDDATDEP_M
number0 to 497
Td depth - md (ft)
TDMDDEPF
number0 to 37,001
Td depth - md (m)
TDMDDEPM
number0 to 11,278
Td depth - tvdss (ft)
TDTVDSSF
number-6,571 to 16,361
Td depth - tvdss (m)
TDTVDSSM
number-2,003 to 4,987
Age
TD_AGE
string10 values: Upper Jurassic (16), Namurian (13), Westphalian (9)…
Sidetrack type
SDTRKTYPE
string2 values: Geological (75), Mechanical (30)
Wellbore parent relationship
PARENTROLE
string3 values: Sidetrack (285), Re-drill (59), Re-spud (3)
Original kickoff - md datum elevation (ft)
STMDDATF
number0 to 1,631
Original kickoff - md datum elevation (m)
STMDDATM
number0 to 497
Original kickoff - md datum type
STRKDTMTY
string5 values: Rotary Table (1,440), Kelly Bushing (463), Ground Level Elevation (60)…
Kickoff location - md (ft)
STMDDEPF
number250 to 7,487
Kickoff location - md (m)
STMDDEPM
number76 to 2,282
Kickoff location - tvdss (ft)
STTVDSSF
number-1,082 to 6,468
Kickoff location - tvdss (m)
STTVDSSM
number-330 to 1,971
Ground elevation (ft)
GRNDELEV_F
number-434 to 1,620
Ground elevation (m)
GRNDELEV_M
number-132 to 494
Water depth (ft)
WATDEP_F
number0 to 786
Water depth (m)
WATDEP_M
number0 to 240
Anticipated development wellbore type
FLUIDTYPES
string4 values: Oil (772), Gas (206), Water (88)…
Original hydrocarbon flow class
FLOWCLASS
string12 values: Oil Well (660), Dry Hole (518), Hydrocarbon Indications (395)…
Other wellbore class
OTHERCLASS
string5 values: Junked Well (41), Drilling (3), Observation Well (2)…
Overall wellbore conventionality
WELLCONVEN
string2 values: Conventional (1,980), Unconventional (114)
Unconventional wellbore type
UNCWELTYP
string5 values: coalbed methane (60), methane venting (39), shale gas/oil (10)…
Overall temperature classification
TEMPCLASS
string1 values: NT (520)
Overall pressure classification
PRESSCLASS
string1 values: NP (520)
Hole temperature - maximum (c)
MXTDTEMPC
number35 to 116
Hole temperature - maximum (f)
MXTDTEMPF
number95 to 241
Hole temperature - minimum (c)
MNTDTEMPC
number13 to 106
Hole temperature - minimum (f)
MNTDTEMPF
number55 to 223
Platform letter
PLATFORM
string
Facility name
FACILITY
string1 values: No Data Available (2,124)
Facility type
FACTYPE
string1 values: No Data Available (2,124)
Facility status
FACSTATUS
string1 values: No Data Available (2,124)
Drilling unit type
FIXMOBILE
string2 values: Land rig (286), No rig (3)
Information link
WELLINFO
string1 values: https://mapapps2.bgs.ac.uk/geoindex/home.html?layer=BGSHydrocarbonWellData (2,124)
Open data flag
OPEN_DATA
string1 values: Y (2,124)
Wellbore status
WELLBRSTAT
string1 values: EXTANT (2,124)
Land rig name
LANDRIGNM
string
Well origin regulatory jurisdiction
COUNTRYCOD
string1 values: Landward (2,124)
Well origin county
ONS_COUNTY
string