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 BOREHOLE API CHANGE ASCII FORMAT
Field Values for 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:
AC- MINOS CANYON 60.
AM- AMERY TERRACE.
AP- APALACHICOLA 60.
AT- ATWATER * 60.
BA- BRAZOS AREA 42.
BM- BAY MARCHAND AREA 17.
BS- BRETON SOUND AREA 17.
CA- CHANDELEUR AREA 17.
CC- CORPUS CHRISTI 60.
CE- CAMPECHE ESCARPMENT.
CH- CHARLOTTE HARBOR 60.
CP- COON POINT (THIS IS A FIELD) 17.
CS- CHANDELEUR SOUND 17.
DC- DESOTO CANYON 60.
DD- DESTIN DOME 60.
DT- DRY TORTUGAS 60.
EB- EAST BREAKS 60.
EC- EAST CAMERON AREA 17.
EI- EUGENE ISLAND AREA 17.
EL- THE ELBOW 60.
EW- EWING BANK 60.
FM- FLORIDA MIDDLE GROUND 60.
FP- FLORIDA PLAIN.
GA- GALVESTON AREA 42.
GB- GARDEN BANKS 60.
GC- GREEN CANYON 60.
GI- GRAND ISLE AREA 17.
GV- GAINESVILLE 60.
HC- HUDSON CANYON.
HE- HENDERSON 60.
HH- HOWELL HOOK 60.
HI- HIGH ISLAND AREA 42.
KC- KEATHLEY CANYON 60.
KW- KEY WEST 60.
LL- LLOYD 60.
LP- LIGHTHOUSE POINT (THIS IS A FIELD) 17.
LS- LUND SOUTH.
LU- LUND * 60.
MA- MIAMI 60.
MC- MISSISSIPPI CANYON 60.
MI- MATAGORDA ISLAND AREA 42.
MO- MOBILE 60.
MP- MAIN PASS AREA 17.
MQ- MARQESAS 09.
MU- MUSTANG ISLAND AREA 42.
PB- ST PETERSBURG 60.
PE- PENSACOLA 60.
PI- PORT ISABEL 60.
PL- SOUTH PELTO AREA 17.
PN- NORTH PADRE ISLAND AREA 42.
PR- PULLEY RIDGE 60.
PS- SOUTH PADRE ISLAND AREA 42.
RK- RANKIN 60.
SA- SABINE PASS (LOUISIANA) 17.
SE- SIGSBEE ESCARPMENT.
SM- SOUTH MARSH ISLAND AREA 17.
SP- SOUTH PASS AREA 17.
SS- SHIP SHOAL AREA 17.
ST- SOUTH TIMBALIER AREA 17.
SX- SABINE PASS (TEXAS) 42.
TP- TARPON SPRINGS 60.
TS- TIGER SHOAL (THIS IS A FIELD) 17.
TV- TORTUGAS VALLEY.
VK- VIOSCA KNOLL 60.
VN- VERNON * 60.
VR- VERMILION AREA 17.
WC- WEST CAMERON AREA 17.
WD- WEST DELTA AREA 17.
WR- WALKER RIDGE 60.
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:
AC- MINOS CANYON 60.
AM- AMERY TERRACE.
AP- APALACHICOLA 60.
AT- ATWATER * 60.
BA- BRAZOS AREA 42.
BM- BAY MARCHAND AREA 17.
BS- BRETON SOUND AREA 17.
CA- CHANDELEUR AREA 17.
CC- CORPUS CHRISTI 60.
CE- CAMPECHE ESCARPMENT.
CH- CHARLOTTE HARBOR 60.
CP- COON POINT (THIS IS A FIELD) 17.
CS- CHANDELEUR SOUND 17.
DC- DESOTO CANYON 60.
DD- DESTIN DOME 60.
DT- DRY TORTUGAS 60.
EB- EAST BREAKS 60.
EC- EAST CAMERON AREA 17.
EI- EUGENE ISLAND AREA 17.
EL- THE ELBOW 60.
EW- EWING BANK 60.
FM- FLORIDA MIDDLE GROUND 60.
FP- FLORIDA PLAIN.
GA- GALVESTON AREA 42.
GB- GARDEN BANKS 60.
GC- GREEN CANYON 60.
GI- GRAND ISLE AREA 17.
GV- GAINESVILLE 60.
HC- HUDSON CANYON.
HE- HENDERSON 60.
HH- HOWELL HOOK 60.
HI- HIGH ISLAND AREA 42.
KC- KEATHLEY CANYON 60.
KW- KEY WEST 60.
LL- LLOYD 60.
LP- LIGHTHOUSE POINT (THIS IS A FIELD) 17.
LS- LUND SOUTH.
LU- LUND * 60.
MA- MIAMI 60.
MC- MISSISSIPPI CANYON 60.
MI- MATAGORDA ISLAND AREA 42.
MO- MOBILE 60.
MP- MAIN PASS AREA 17.
MQ- MARQESAS 09.
MU- MUSTANG ISLAND AREA 42.
PB- ST PETERSBURG 60.
PE- PENSACOLA 60.
PI- PORT ISABEL 60.
PL- SOUTH PELTO AREA 17.
PN- NORTH PADRE ISLAND AREA 42.
PR- PULLEY RIDGE 60.
PS- SOUTH PADRE ISLAND AREA 42.
RK- RANKIN 60.
SA- SABINE PASS (LOUISIANA) 17.
SE- SIGSBEE ESCARPMENT.
SM- SOUTH MARSH ISLAND AREA 17.
SP- SOUTH PASS AREA 17.
SS- SHIP SHOAL AREA 17.
ST- SOUTH TIMBALIER AREA 17.
SX- SABINE PASS (TEXAS) 42.
TP- TARPON SPRINGS 60.
TS- TIGER SHOAL (THIS IS A FIELD) 17.
TV- TORTUGAS VALLEY.
VK- VIOSCA KNOLL 60.
VN- VERNON * 60.
VR- VERMILION AREA 17.
WC- WEST CAMERON AREA 17.
WD- WEST DELTA AREA 17.
WR- WALKER RIDGE 60.
Bh Total Md
MEASURED_DEPTH
Number Range
Between 0 and 50000