Skip to Main Content
Data Center
U.S. DEPARTMENT OF THE INTERIOR
Search
Sitemap
Contact Us
Employment
Go Full Width
Go Fixed Width
Skip Navigation
BOEM.GOV
About BOEM
Regions
Newsroom
Oil & Gas Energy
Renewable Energy
Environment
Marine Minerals
BOEM Data Center
Online Queries
Company
Approvals
Company Detail
Incidents of Non-Compliance
Lease Owner
Platform Structure with associated INC count
Leasing
Assignments
Company Detail
Decommissioning Cost Estimates
Lease Area Block Lookup
Lease Owner
Non-Required/Required Documents Received
Offshore Statistics by Water Depth
Serial Register Page
Pipeline
Pipeline Locations
Pipeline Permits
ROW Descriptions
Plans and Permits
Application for Permit to Drill (APD)
eWell Submissions Applications for Permit to Drill
eWell Submissions Applications for Permit to Modify
Exploration and Development Plans
Platform/Rig
Offshore Statistics by Water Depth
Platform Structure
Production
Facility/Measurement Points (FMP)
FMP/Meters/Tanks Listing
PASR / Commingling Flow Report
Offshore Statistics by Water Depth
Production by Planning Area with Daily Production Rates
Production Data
Well
Application for Permit to Drill (APD)
American Petroleum Institute (API) Lookup
American Petroleum Institute (API) Number Changes
Borehole
Bottomhole Pressure Survey
eWell Submissions Applications for Permit to Drill
eWell Submissions Applications for Permit to Modify
eWell Submissions End of Operations Report
eWell Submissions Well Activity Reports
Scanned
Documents
Active-Inactive Leases
Adjudication Files
Collateral Files
Company Files
Directional Surveys
Expired Leases
G&G Permits
Pipeline Maps
Plans
Renewable Energy Lease Files
ROW Files
SOP-SOO
Unit Agreements
Well
Well Potential Test Reports
PDF Reports
Company
Leasing
Paleontologic
Pipeline
Plans and Permits
Platform/Rig
Production
Well
ASCII Downloads
Company
Directional Surveys
Field & Reserves
Geological and Geophysical Studies
Leasing
Alaska Leasing
GOMR Leasing
Pacific Leasing
Mapping
Paleontologic
Pipeline
GOMR Pipeline
Pacific Pipeline
Plans and Permits
Platform/Rig
GOMR Platform/Rig
Pacific Platform/Rig
Production
GOMR Production
OGOR-A
OGOR-B
OGOR-C
Pacific Production
Well
Alaska Well
GOMR Well
Pacific Well
Other Resources
Concrete Anchors
Data Management
Deepwater Natural Gas and Oil Qualified Fields
ESPIS
eWell Permitting and Reporting System
Fees for Service Refund Request
File Request System
Well Data
GoM Permanent Deepwater Structures
Public Information Ordering System
Quick Data Online Query
Video Tutorials
Data Center
>>
Field Values for PACIFIC BOREHOLE API CHANGE ASCII FORMAT
Field Values for PACIFIC BOREHOLE API CHANGE ASCII FORMAT
Column
Alias Name
Domain
Name
Domain
Type
Valid Value
Description
Bh Actv Type Cd
BH_ACTV_TYPE_CDS
Enumeration Range
The Value-Description Pairs are listed below:
API- API well number change.
BLS- Bottom lease number change.
LBC- Location change - Bottom Cadastral.
LBS- Location change - Bottom Submitted.
LSC- Location change - Surface Cadastral.
LSE- Lease number change.
LSS- NAD 83 Surface Location change - Submitted.
ODO- Original Drilling Operator.
OPC- Oper change-bottom lease, district.
OPH- Oper change-bottom lease, as a part of historical well data cleanup process.
OPR- Oper change-bottom lease, leasing.
OSD- Oper change-surface lease, district.
OSL- Oper change-surface lease, leasing.
OWN- Original Well Name.
PRF- Public Release Flag Change.
RKB- Rig kelly bushing change.
SLS- Surface lease number change.
STA- Well status change.
TMD- Total measured depth change.
TVD- True vertical depth change.
WLN- Well name change.
Activity Date
GENERAL_DATES
Date Range
Between 01-JAN-1947 and SYSDATE+10
Surf Area Code
0059
Enumeration Range
The Value-Description Pairs are listed below:
6A- CHANNEL ISLANDS AREA
6B- CHANNEL ISLANDS AREA
6C- CHANNEL ISLANDS AREA
6D- CHANNEL ISLANDS AREA
6E- CHANNEL ISLANDS AREA
AC- ASTORIA CANYON
AR- ARGEUELLO FAN
AS- ASTORIA FAN
BC- BARCLEY CANYON
BG- BODEGA CANYON
BK- BUSHNELL KNOLL
BS- BLANCO SADDLE
CB- CAPE BLANCO
CC- CASCADIA BASIN
CD- CAPE DIAAPPOINTMENT
CF- CAPE FLATTERY
CG- CASCADIA GAP
CH- COPALIS BEACH
CI- CHANNEL ISLANDS
CR- CRESCENT CITY
CS- COOS BAY
DB- DAISY BANKS
DF- DELGADA FAN
ER- ESCANABA RIDGE
ET- ESCANABA TROUGH
EU- EUREKA
HB- HECETA BANK
HO- HOQUIAM
HS- HAKE SEAMOUNT
JS- JASPER SEAMOUNT
KR- KLAMATH RIDGE
LA- LOS ANGELES
LB- LONG BEACH
LS- CAPE DISAPPOINTMENT WEST
MB- MONTEREY BAY
MF- MONTEREY FAN
NA- NAVARRO CANYON
NC- NOYO CANYON
NF- NITINAT FAN
NP- NEWPORT
PA- PATTON RIDGE
PE- PIONEER ESCARPMENT
PJ- PRESIDENT JACKSON SEAMOUNT
PR- PIONEER RIDGE
PS- PARKS SEAMOUNT
RA- THE RAMPART
RB- ROSEBURG
RD- REDDING
SA- SANTA CRUZ
SC- SAN CLEMENTE
SD- SAN DIEGO
SE- SEATTLE
SF- SAN FRANCISCO
SI- SANTA ROSA ISLAND
SL- SALEM
SM- SANTA MARIA
SO- SAN LUIS OBISPO
SR- SANTA ROSA
SS- STODDARD SEAMOUNT
ST- SANTA ANA
SU- SUR CANYON
SV- STEEL VENDOR SEAMOUNT
TA- TANEY SEAMOUNT
TB- TILLAMOOK BAY
TS- THOMPSON SEAMOUNT
UK- UKIAH
UN- (UNNAMED)
VB- VELERO BASIN
VC- VANCOUVER
VG- VANCOUGAR GAP
VS- VANCE SEAMOUNT
WE- WEED
WS- WESTFALL SEAMOUNT
Well Spud Date
GENERAL_DATES
Date Range
Between 01-JAN-1947 and SYSDATE+10
Botm Area Code
0059
Enumeration Range
The Value-Description Pairs are listed below:
6A- CHANNEL ISLANDS AREA
6B- CHANNEL ISLANDS AREA
6C- CHANNEL ISLANDS AREA
6D- CHANNEL ISLANDS AREA
6E- CHANNEL ISLANDS AREA
AC- ASTORIA CANYON
AR- ARGEUELLO FAN
AS- ASTORIA FAN
BC- BARCLEY CANYON
BG- BODEGA CANYON
BK- BUSHNELL KNOLL
BS- BLANCO SADDLE
CB- CAPE BLANCO
CC- CASCADIA BASIN
CD- CAPE DIAAPPOINTMENT
CF- CAPE FLATTERY
CG- CASCADIA GAP
CH- COPALIS BEACH
CI- CHANNEL ISLANDS
CR- CRESCENT CITY
CS- COOS BAY
DB- DAISY BANKS
DF- DELGADA FAN
ER- ESCANABA RIDGE
ET- ESCANABA TROUGH
EU- EUREKA
HB- HECETA BANK
HO- HOQUIAM
HS- HAKE SEAMOUNT
JS- JASPER SEAMOUNT
KR- KLAMATH RIDGE
LA- LOS ANGELES
LB- LONG BEACH
LS- CAPE DISAPPOINTMENT WEST
MB- MONTEREY BAY
MF- MONTEREY FAN
NA- NAVARRO CANYON
NC- NOYO CANYON
NF- NITINAT FAN
NP- NEWPORT
PA- PATTON RIDGE
PE- PIONEER ESCARPMENT
PJ- PRESIDENT JACKSON SEAMOUNT
PR- PIONEER RIDGE
PS- PARKS SEAMOUNT
RA- THE RAMPART
RB- ROSEBURG
RD- REDDING
SA- SANTA CRUZ
SC- SAN CLEMENTE
SD- SAN DIEGO
SE- SEATTLE
SF- SAN FRANCISCO
SI- SANTA ROSA ISLAND
SL- SALEM
SM- SANTA MARIA
SO- SAN LUIS OBISPO
SR- SANTA ROSA
SS- STODDARD SEAMOUNT
ST- SANTA ANA
SU- SUR CANYON
SV- STEEL VENDOR SEAMOUNT
TA- TANEY SEAMOUNT
TB- TILLAMOOK BAY
TS- THOMPSON SEAMOUNT
UK- UKIAH
UN- (UNNAMED)
VB- VELERO BASIN
VC- VANCOUVER
VG- VANCOUGAR GAP
VS- VANCE SEAMOUNT
WE- WEED
WS- WESTFALL SEAMOUNT
Bh Total Md
MEASURED_DEPTH
Number Range
Between 0 and 50000