UKCS offshore wellbores top 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. Wellbore 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
- 13,388
- Formats
- 4
- Last updated
- 5 Nov 2026
Download & API
UKCS offshore wellbores top holes (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
UKCS offshore wellbores top holes (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
UKCS offshore wellbores top holes (map tiles)pmtiles
Vector tiles — embed in a map
Live ArcGIS layer (source)arcgis
Rendered from PMTiles, queried in-browser from GeoParquet — no server. How this works
Schema
| Field | Type | Values |
|---|---|---|
Well origin reference WELLORIGIN | string | |
Well origin status ORIGINSTAT | string | 3 values: Present (7,070), Decommissioned (6,158), Derogated (160) |
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 | string | 4 values: Development (8,258), Exploration (2,955), Appraisal (2,174)… |
Current wellbore intent CURRWELLIN | string | 4 values: Development (8,526), Exploration (2,890), Appraisal (1,971)… |
Development wellbore type DEVTYPE | string | 4 values: Producer (7,097), Injector (1,060), Other (77)… |
Wellbore mechanical status COMPLESTAT | string | 7 values: Abandoned Phase 3 (6,160), Abandoned Phase 1 (2,570), Abandoned Phase 2 (2,006)… |
Wellbore operational status WELLOPSTAT | string | 4 values: Decomissioned (6,160), Suspended (5,159), Constructed (2,052)… |
Well suffix WELLSUFFIX | string | |
Wellbore alias WELLALIAS | string | |
Operator's wellbore name NAME | string | |
Slot no. SLOTNO | string | |
Is this wellbore multilateral? MULTILAT | string | 2 values: N (13,293), Y (95) |
Is this wellbore the designated well? DESIGNATED | string | 2 values: Y (8,233), N (5,155) |
Field name TARGETFLD | string | |
Primary target idenfifying letter(s) PRIMARYTAR | string | |
Prospect PROSPECT | string | |
Licence type LICTYPE | string | 4 values: Production (13,361), No Data Available (24), ML (2)… |
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 | string | |
Subarea operator at td previous names TDOPPREV | string | |
Subarea operator at td group name TDOPGRP | string | |
Who is responsible for the wellbore RESWOP | string | |
Responsible wellbore operator previous name RESWOPPREV | string | |
Responsible wellbore operator group name RESWOPGRP | string | |
Why are they responsible for the wellbore RESWOPRES | string | 7 values: Field Operator (8,720), Subarea Operator at Well Origin (4,611), Commercial agreement with responsible company (24)… |
Who is responsible for reporting data RESDOP | string | |
Responsible data operator previous name RESDOPPREV | string | |
Responsible data operator group name RESDOPGRP | string | |
Why are they responsible for reporting data RESDOPREAS | string | |
Deviation type DEVIATTYP | string | 3 values: Vertical (7,073), Deviated (4,781), Horizontal (1,379) |
Datum type DATUMTYPE | string | 4 values: Kelly Bushing (7,744), Rotary Table (5,452), Mean Sea Level (99)… |
Datum elevation (ft) DATELEV_F | number | 0 to 679 |
Datum elevation (m) DATELEV_M | number | 0 to 207 |
Well origin surface datum TOPHOLEDTM | string | 4 values: ED50 (13,363), WGS84 (19), ETRS89 (5)… |
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 | string | 3 values: ED50 (13,130), WGS84 (37), ETRS89 (9) |
Bottom hole decimal degrees longitude BOTHOLEXDD | string | |
Bottom hole decimal degrees latitude BOTHOLEYDD | string | |
Wellbore td national grid easting BH_EASTING | number | |
Wellbore td national grid northing BH_NORTHIN | number | |
Wellbore td national grid reference BH_BNG_REF | string | |
Td depth datum type TDDEPDATTY | string | 3 values: Kelly Bushing (8,084), Rotary Table (3,517), Mean Sea Level (129) |
Td depth datum elevation (ft) TDDATDEP_F | number | 0 to 651 |
Td depth datum elevation (m) TDDATDEP_M | number | 0 to 198 |
Td depth - md (ft) TDMDDEPF | number | 0 to 38,911 |
Td depth - md (m) TDMDDEPM | number | 0 to 11,860 |
Td depth - tvdss (ft) TDTVDSSF | number | -17,835 to 575,796 |
Td depth - tvdss (m) TDTVDSSM | number | -5,436 to 175,503 |
Age TD_AGE | string | |
Sidetrack type SDTRKTYPE | string | 2 values: Mechanical (1,444), Geological (1,074) |
Wellbore parent relationship PARENTROLE | string | 3 values: Sidetrack (4,188), Re-drill (890), Re-spud (229) |
Original kickoff - md datum elevation (ft) STMDDATF | number | -199 to 679 |
Original kickoff - md datum elevation (m) STMDDATM | number | -61 to 207 |
Original kickoff - md datum type STRKDTMTY | string | 4 values: Kelly Bushing (8,142), Rotary Table (3,824), Mean Sea Level (152)… |
Kickoff location - md (ft) STMDDEPF | number | 320 to 22,238 |
Kickoff location - md (m) STMDDEPM | number | 98 to 6,778 |
Kickoff location - tvdss (ft) STTVDSSF | number | -10,769 to 20,834 |
Kickoff location - tvdss (m) STTVDSSM | number | -3,282 to 6,350 |
Ground elevation (ft) GRNDELEV_F | number | -139 to 167 |
Ground elevation (m) GRNDELEV_M | number | -42.37 to 50.90 |
Water depth (ft) WATDEP_F | number | 0 to 6,189 |
Water depth (m) WATDEP_M | number | 0 to 1,886 |
Anticipated development wellbore type FLUIDTYPES | string | |
Original hydrocarbon flow class FLOWCLASS | string | |
Other wellbore class OTHERCLASS | string | 6 values: Junked Well (916), Drilling (289), Suspended above T.D. (45)… |
Overall wellbore conventionality WELLCONVEN | string | 2 values: Conventional (1,382), Unconventional (26) |
Unconventional wellbore type UNCWELTYP | string | 2 values: tight gas (30), carbon capture storage (1) |
Overall temperature classification TEMPCLASS | string | 3 values: NT (6,330), HT (930), UHT (4) |
Overall pressure classification PRESSCLASS | string | 3 values: NP (6,326), HP (932), UHP (6) |
Hole temperature - maximum (c) MXTDTEMPC | number | -999 to 318 |
Hole temperature - maximum (f) MXTDTEMPF | number | -1,767 to 604 |
Hole temperature - minimum (c) MNTDTEMPC | number | -999 to 308 |
Hole temperature - minimum (f) MNTDTEMPF | number | -1,767 to 586 |
Platform letter PLATFORM | string | |
Facility name FACILITY | string | |
Facility type FACTYPE | string | 11 values: No Data Available (12,216), PLS - Platform - Large Steel (540), MDRJ - Mobile Drilling Jackup (252)… |
Facility status FACSTATUS | string | 4 values: No Data Available (12,216), OP - Operational (1,010), CD - Closed Down (124)… |
Drilling unit type FIXMOBILE | string | 6 values: Platform (1,059), Semi (369), Jackup (221)… |
Information link WELLINFO | string | 1 values: https://www.nstauthority.co.uk/data-centre/nsta-open-data/ (13,388) |
Open data flag OPEN_DATA | string | 1 values: Y (13,388) |
Wellbore status WELLBRSTAT | string | 1 values: EXTANT (13,388) |
Well origin regulatory jurisdiction COUNTRYCOD | string | 1 values: Seaward (13,388) |