Data Center

Data Center >>
Field Values for ALASKA BOREHOLE API CHANGE ASCII FORMAT

Field Values for ALASKA 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:
  • 0A- OPD NS04-07
  • 0B- OPD NS04-08
  • 0C- BARROW CANYON
  • 0D- CANADA BASIN WEST
  • 0E- OPD NS07-08
  • 0F- HANNA SHOAL
  • 0G- HARRISON BAY NORTH
  • 0H- BEECHEY POINT NORTH
  • 0I- FLAXMAN ISLAND NORTH
  • 0J- OPD NR07-02
  • 0K- MACKENZIE CANYON NORTH
  • 0M- OPD NS02-06
  • 0N- OPD NS03-04
  • 0P- OPD NS03-06
  • 0Q- OPD NS04-03
  • 0R- OPD NS04-04
  • 0S- OPD NS04-05
  • 0T- OPD NS04-06
  • 0U- OPD NS05-03
  • 0V- OPD NS05-04
  • 0W- OPD NS05-05
  • 0X- OPD NS05-06
  • 0Y- OPD NS06-03
  • 0Z- OPD NS06-05
  • 1A- OPD NP60-08
  • 1B- ALEUTIAN BASIN
  • 1C- OPD NO60-03
  • 1D- OPD NO60-04
  • 1E- OPD NO60-05
  • 1F- OPD NO60-06
  • 1G- OPD NO01-05
  • 1H- OPD NO59-08
  • 1I- OPD NO60-07
  • 1J- OPD NO01-07
  • 1L- OPD NO01-08
  • 1M- OPD NS06-06
  • 1N- OPD NS07-05
  • 1P- OPD NS08-05
  • 1Q- OPD NS08-07
  • 1R- OPD NL01-01
  • 1S- OPD NL60-03
  • 1T- OPD NM01-06
  • 1U- OPD NM01-06
  • 1V- OPD NM01-07
  • 1W- OPD NM01-08
  • 1X- OPD NM02-05
  • 1Y- OPD NM02-06
  • 1Z- OPD NM02-07
  • 2A- OPD NN59-05
  • 2B- OPD NN59-07
  • 2C- OPD NN03-07
  • 2D- OPD NM58-02
  • 2E- OPD NM59-01
  • 2F- OPD NM59-02
  • 2G- OPD NM03-01
  • 2H- OPD NM58-04
  • 2I- OPD NM59-03
  • 2J- OPD NM59-04
  • 2K- OPD NM60-03
  • 2L- OPD NM60-04
  • 2M- OPD NM01-04
  • 2N- OPD NM02-03
  • 2O- OPD NM02-04
  • 2P- OPD NM03-03
  • 2Q- OPD NM02-08
  • 2R- OPD NM03-05
  • 2S- OPD NM59-05
  • 2T- OPD NM59-06
  • 2U- OPD NM60-05
  • 2V- OPD NM60-06
  • 2W- OPD NM60-07
  • 2X- OPD NM60-08
  • 2Y- OPD NS03-05
  • 2Z- OPD NS07-06
  • 3A- PORTLOCK BANK
  • 3B- CHIRIKOF ISLAND
  • 3C- OPD NN05-02
  • 3D- OPD NN06-01
  • 3E- OPD NN05-04
  • 3F- OPD NN06-03
  • 3G- OPD NN05-05
  • 3H- OPD NN05-06
  • 3I- OPD NN06-05
  • 3J- OPD NN05-07
  • 3K- OPD NN05-08
  • 3L- OPD NS02-04
  • 3M- OPD NR07-01
  • 3N- OPD NQ02-07
  • 3O- HOOPER BAY
  • 3P- OPD NO06-08
  • 3S- OPD NN04-08
  • 3T- OPD NM01-05
  • 3U- OPD NL01-02
  • 4A- ICY BAY SOUTH
  • 4B- OPD NS03-03
  • 4C- OPD NO07-05
  • 4D- OPD NO07-06
  • 4E- OPD NO07-08
  • 4F- OPD NN06-02
  • 4G- OPD NN07-01
  • 4H- OPD NN07-02
  • 4I- OPD NN06-04
  • 4J- OPD NN07-03
  • 4K- OPD NN07-04
  • 4L- OPD NN08-03
  • 4M- OPD NN06-06
  • 4N- OPD NN07-05
  • 4O- OPD NN07-06
  • 4P- OPD NN08-05
  • A0- UGASHIK WEST
  • A1- BRISTOL BAY
  • AA- ATTU
  • AB- ALBATROSS BANK
  • AD- ADAK
  • AF- AFOGNAK
  • AK- AMLIA KNOLL
  • AM- AMUKTA PASS
  • AN- AKUTAN NORTH
  • AP- AMCHITKA PASS
  • AT- ATKA
  • AU- AKUTAN
  • AV- ALSEK VALLEY
  • BA- BAIRD INLET
  • BB- BOWERS BANK
  • BE- BEAUFORT BASIN
  • BF- BAKER FAN
  • BG- BERING GLACIER
  • BH- BERING SEA
  • BI- BARTER ISLAND
  • BL- BLACK
  • BN- BRISTOL BAY NORTH
  • BO- BARROW
  • BP- BEECHEY POINT
  • BR- BOWERS RIDGE
  • BS- BLYING SOUND
  • BT- BEAUFORT TERRACE
  • BW- BOWERS SEAMOUNT
  • CA- CAPE SEPPINGS
  • CB- COLD BAY
  • CC- CHAGULAK CANYON
  • CD- CORDOVA
  • CH- CHIGNIK
  • CI- CANADA BASIN
  • CM- CAPE MENDENHALL
  • CN- CAPE NEWENHAM
  • CP- CAPE DENBIGH
  • CR- CRAIG
  • CS- CHIRIKOF SEAMOUNT
  • CW- CAPE NEWENHAM WEST
  • DI- DEASE INLET
  • DL- DE LONG MOUNTAINS
  • DP- DEMARCATION POINT
  • DR- DERICKSON SEAMOUNT
  • DS- DALL SEAMOUNT
  • DX- DIXON ENTRANCE
  • ES- ELY SEAMOUNT
  • FI- FLAXMAN ISLAND
  • FP- FALSE PASS
  • GA- GAMBELL
  • GI- GARELOI ISLAND
  • GN- GOODNEWS
  • GO- GODDARD
  • H1- BERING STRAIT
  • HB- HARRISON BAY
  • HI- HAGEMEISTER ISLAND
  • HO- CAPE SEPPINGS WEST
  • IB- ICY BAY
  • IL- ILIAMNA
  • IS- SHISHMAREF
  • JU- JUNEAU
  • KA- KARLUK
  • KB- KANAGA BASIN
  • KC- KOROVIN CANYON
  • KE- KODIAK EAST
  • KI- KWIGUK
  • KN- KENAI
  • KO- KODIAK
  • KP- KRESTA POINT
  • KR- KARO
  • KS- OPD NO06-07
  • KT- KETCHIKAN
  • KV- KISKA VOLCANO
  • KW- KUSKOKWIM BAY
  • KZ- KOTZEBUE
  • LD- LITTLE DIOMEDE ISLAND
  • LI- SOLIVIK ISLAND
  • M0- GAMBELL SOUTH
  • M1- ST. MATTHEW NORTH
  • M2- HOOPER BAY WEST
  • M3- NUNIVAK ISLAND WEST
  • M4- ST. MATTHEW SOUTH
  • M5- CAPE MENDENHALL WEST
  • MA- MACKENZIE CANYON
  • MC- MURRAY CANYON
  • MD- MAURY DEEP
  • MF- MT. FAIRWEATHER
  • MI- MIDDLETON ISLAND
  • MK- MT. KATMAI
  • MM- MT. MICHELSON
  • MR- MEADE RIVER
  • MT- MITROFANIA ISLAND
  • N0- OPD NP01-02
  • NA- NOATAK
  • NI- NUNIVAK ISLAND
  • NN- NAKNEK
  • NO- NOME
  • NS- NORTON SOUND
  • OC- OKMUK CANYON
  • PA- PORT ALEXANDER
  • PC- PRIBILOF CANYON
  • PH- POINT HOPE
  • PL- POINT LAY
  • PR- PRINCE RUPERT
  • PS- PRATT SEAMOUNT
  • PT- POCHNOI TROUGH
  • RC- RUDE CANYON
  • RI- RAT ISLANDS
  • S0- ALEUTIAN TRENCH
  • S1- OPD NNO4-03
  • S2- OPD NM03-02
  • S3- OPD NM04-01
  • S4- OPD NM04-02
  • S5- OPD NM03-04
  • S6- OPD NM04-03
  • S7- SELAWIK
  • S8- SEWARD
  • SA- ST. PAUL EAST
  • SB- UNIMAK SEAMOUNT
  • SC- ST. GEORGE CANYON
  • SE- SELDOVIA
  • SF- SURVEYOR SEACHANNEL
  • SG- ST. GEORGE
  • SH- SHUMAGIN BANK
  • SI- SAMALGA ISLAND
  • SJ- ST. LAWRENCE
  • SK- SITKA
  • SL- ST. PAUL SPUR
  • SM- ST. MICHAEL
  • SN- SIMEONOF ISLAND
  • SO- SOLOMON
  • SP- ST. PAUL
  • SQ- SUMDUM
  • SR- ST. PAUL NORTH
  • SS- SIRIUS SEAMOUNT
  • ST- STEPOVAK BAY
  • SU- SEGUAM
  • SW- SUTWIK ISLAND
  • SX- ST. GEORGE EAST
  • SY- SHEMYA ISLAND
  • SZ- SOUTHEAST CAPE
  • TE- TESHEKPUK
  • TH- ST. MATTHEW
  • TI- TRINITY ISLAND
  • TL- TRINITY ISLANDS
  • TR- TELLER
  • TS- TISON
  • TU- STUDDS
  • U0- OPD NS02-08
  • U1- OPD NS03-07
  • U2- OPD NS03-08
  • U3- POSEY
  • U4- COLBERT
  • U5- CHUKCHI SEA
  • U6- POINT LAY WEST
  • U7- POINT HOPE WEST
  • UG- UGASHIK
  • UL- UNALAKLEET
  • UM- UMNAK
  • UN- UNALASKA
  • UO- OPD NS06-08
  • UP- ULM PLATEAU
  • UV- UKIVOK
  • V0- OPD NP01-03
  • V1- BOSSLER
  • V2- SAULSBURY WEST
  • V3- SAULSBURY
  • V4- BANKS
  • V5- ST. MATTHEW WEST
  • V6- PERVENETS CANYON
  • V7- PERVENETS CANYON EAST
  • V8- ST. MATTHEW CANYON
  • W0- OPD NN59-02
  • W1- OPD NN60-01
  • W2- OPD NN60-02
  • W3- OPD NN01-01
  • W4- OPD NN01-02
  • W5- PRIBILOF CANYON WEST
  • W6- OPD NN59-03
  • W7- OPD NN59-04
  • W8- OPD NN60-05
  • WA- WAINWRIGHT
  • WK- WALLS KNOLL
  • YA- YAKUTAT
  • ZC- ZHEMCHUG CANYON
  • ZG- ZHEMCHUG GULLY
  • ZS- ZHEMCHUG SPUR
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:
  • 0A- OPD NS04-07
  • 0B- OPD NS04-08
  • 0C- BARROW CANYON
  • 0D- CANADA BASIN WEST
  • 0E- OPD NS07-08
  • 0F- HANNA SHOAL
  • 0G- HARRISON BAY NORTH
  • 0H- BEECHEY POINT NORTH
  • 0I- FLAXMAN ISLAND NORTH
  • 0J- OPD NR07-02
  • 0K- MACKENZIE CANYON NORTH
  • 0M- OPD NS02-06
  • 0N- OPD NS03-04
  • 0P- OPD NS03-06
  • 0Q- OPD NS04-03
  • 0R- OPD NS04-04
  • 0S- OPD NS04-05
  • 0T- OPD NS04-06
  • 0U- OPD NS05-03
  • 0V- OPD NS05-04
  • 0W- OPD NS05-05
  • 0X- OPD NS05-06
  • 0Y- OPD NS06-03
  • 0Z- OPD NS06-05
  • 1A- OPD NP60-08
  • 1B- ALEUTIAN BASIN
  • 1C- OPD NO60-03
  • 1D- OPD NO60-04
  • 1E- OPD NO60-05
  • 1F- OPD NO60-06
  • 1G- OPD NO01-05
  • 1H- OPD NO59-08
  • 1I- OPD NO60-07
  • 1J- OPD NO01-07
  • 1L- OPD NO01-08
  • 1M- OPD NS06-06
  • 1N- OPD NS07-05
  • 1P- OPD NS08-05
  • 1Q- OPD NS08-07
  • 1R- OPD NL01-01
  • 1S- OPD NL60-03
  • 1T- OPD NM01-06
  • 1U- OPD NM01-06
  • 1V- OPD NM01-07
  • 1W- OPD NM01-08
  • 1X- OPD NM02-05
  • 1Y- OPD NM02-06
  • 1Z- OPD NM02-07
  • 2A- OPD NN59-05
  • 2B- OPD NN59-07
  • 2C- OPD NN03-07
  • 2D- OPD NM58-02
  • 2E- OPD NM59-01
  • 2F- OPD NM59-02
  • 2G- OPD NM03-01
  • 2H- OPD NM58-04
  • 2I- OPD NM59-03
  • 2J- OPD NM59-04
  • 2K- OPD NM60-03
  • 2L- OPD NM60-04
  • 2M- OPD NM01-04
  • 2N- OPD NM02-03
  • 2O- OPD NM02-04
  • 2P- OPD NM03-03
  • 2Q- OPD NM02-08
  • 2R- OPD NM03-05
  • 2S- OPD NM59-05
  • 2T- OPD NM59-06
  • 2U- OPD NM60-05
  • 2V- OPD NM60-06
  • 2W- OPD NM60-07
  • 2X- OPD NM60-08
  • 2Y- OPD NS03-05
  • 2Z- OPD NS07-06
  • 3A- PORTLOCK BANK
  • 3B- CHIRIKOF ISLAND
  • 3C- OPD NN05-02
  • 3D- OPD NN06-01
  • 3E- OPD NN05-04
  • 3F- OPD NN06-03
  • 3G- OPD NN05-05
  • 3H- OPD NN05-06
  • 3I- OPD NN06-05
  • 3J- OPD NN05-07
  • 3K- OPD NN05-08
  • 3L- OPD NS02-04
  • 3M- OPD NR07-01
  • 3N- OPD NQ02-07
  • 3O- HOOPER BAY
  • 3P- OPD NO06-08
  • 3S- OPD NN04-08
  • 3T- OPD NM01-05
  • 3U- OPD NL01-02
  • 4A- ICY BAY SOUTH
  • 4B- OPD NS03-03
  • 4C- OPD NO07-05
  • 4D- OPD NO07-06
  • 4E- OPD NO07-08
  • 4F- OPD NN06-02
  • 4G- OPD NN07-01
  • 4H- OPD NN07-02
  • 4I- OPD NN06-04
  • 4J- OPD NN07-03
  • 4K- OPD NN07-04
  • 4L- OPD NN08-03
  • 4M- OPD NN06-06
  • 4N- OPD NN07-05
  • 4O- OPD NN07-06
  • 4P- OPD NN08-05
  • A0- UGASHIK WEST
  • A1- BRISTOL BAY
  • AA- ATTU
  • AB- ALBATROSS BANK
  • AD- ADAK
  • AF- AFOGNAK
  • AK- AMLIA KNOLL
  • AM- AMUKTA PASS
  • AN- AKUTAN NORTH
  • AP- AMCHITKA PASS
  • AT- ATKA
  • AU- AKUTAN
  • AV- ALSEK VALLEY
  • BA- BAIRD INLET
  • BB- BOWERS BANK
  • BE- BEAUFORT BASIN
  • BF- BAKER FAN
  • BG- BERING GLACIER
  • BH- BERING SEA
  • BI- BARTER ISLAND
  • BL- BLACK
  • BN- BRISTOL BAY NORTH
  • BO- BARROW
  • BP- BEECHEY POINT
  • BR- BOWERS RIDGE
  • BS- BLYING SOUND
  • BT- BEAUFORT TERRACE
  • BW- BOWERS SEAMOUNT
  • CA- CAPE SEPPINGS
  • CB- COLD BAY
  • CC- CHAGULAK CANYON
  • CD- CORDOVA
  • CH- CHIGNIK
  • CI- CANADA BASIN
  • CM- CAPE MENDENHALL
  • CN- CAPE NEWENHAM
  • CP- CAPE DENBIGH
  • CR- CRAIG
  • CS- CHIRIKOF SEAMOUNT
  • CW- CAPE NEWENHAM WEST
  • DI- DEASE INLET
  • DL- DE LONG MOUNTAINS
  • DP- DEMARCATION POINT
  • DR- DERICKSON SEAMOUNT
  • DS- DALL SEAMOUNT
  • DX- DIXON ENTRANCE
  • ES- ELY SEAMOUNT
  • FI- FLAXMAN ISLAND
  • FP- FALSE PASS
  • GA- GAMBELL
  • GI- GARELOI ISLAND
  • GN- GOODNEWS
  • GO- GODDARD
  • H1- BERING STRAIT
  • HB- HARRISON BAY
  • HI- HAGEMEISTER ISLAND
  • HO- CAPE SEPPINGS WEST
  • IB- ICY BAY
  • IL- ILIAMNA
  • IS- SHISHMAREF
  • JU- JUNEAU
  • KA- KARLUK
  • KB- KANAGA BASIN
  • KC- KOROVIN CANYON
  • KE- KODIAK EAST
  • KI- KWIGUK
  • KN- KENAI
  • KO- KODIAK
  • KP- KRESTA POINT
  • KR- KARO
  • KS- OPD NO06-07
  • KT- KETCHIKAN
  • KV- KISKA VOLCANO
  • KW- KUSKOKWIM BAY
  • KZ- KOTZEBUE
  • LD- LITTLE DIOMEDE ISLAND
  • LI- SOLIVIK ISLAND
  • M0- GAMBELL SOUTH
  • M1- ST. MATTHEW NORTH
  • M2- HOOPER BAY WEST
  • M3- NUNIVAK ISLAND WEST
  • M4- ST. MATTHEW SOUTH
  • M5- CAPE MENDENHALL WEST
  • MA- MACKENZIE CANYON
  • MC- MURRAY CANYON
  • MD- MAURY DEEP
  • MF- MT. FAIRWEATHER
  • MI- MIDDLETON ISLAND
  • MK- MT. KATMAI
  • MM- MT. MICHELSON
  • MR- MEADE RIVER
  • MT- MITROFANIA ISLAND
  • N0- OPD NP01-02
  • NA- NOATAK
  • NI- NUNIVAK ISLAND
  • NN- NAKNEK
  • NO- NOME
  • NS- NORTON SOUND
  • OC- OKMUK CANYON
  • PA- PORT ALEXANDER
  • PC- PRIBILOF CANYON
  • PH- POINT HOPE
  • PL- POINT LAY
  • PR- PRINCE RUPERT
  • PS- PRATT SEAMOUNT
  • PT- POCHNOI TROUGH
  • RC- RUDE CANYON
  • RI- RAT ISLANDS
  • S0- ALEUTIAN TRENCH
  • S1- OPD NNO4-03
  • S2- OPD NM03-02
  • S3- OPD NM04-01
  • S4- OPD NM04-02
  • S5- OPD NM03-04
  • S6- OPD NM04-03
  • S7- SELAWIK
  • S8- SEWARD
  • SA- ST. PAUL EAST
  • SB- UNIMAK SEAMOUNT
  • SC- ST. GEORGE CANYON
  • SE- SELDOVIA
  • SF- SURVEYOR SEACHANNEL
  • SG- ST. GEORGE
  • SH- SHUMAGIN BANK
  • SI- SAMALGA ISLAND
  • SJ- ST. LAWRENCE
  • SK- SITKA
  • SL- ST. PAUL SPUR
  • SM- ST. MICHAEL
  • SN- SIMEONOF ISLAND
  • SO- SOLOMON
  • SP- ST. PAUL
  • SQ- SUMDUM
  • SR- ST. PAUL NORTH
  • SS- SIRIUS SEAMOUNT
  • ST- STEPOVAK BAY
  • SU- SEGUAM
  • SW- SUTWIK ISLAND
  • SX- ST. GEORGE EAST
  • SY- SHEMYA ISLAND
  • SZ- SOUTHEAST CAPE
  • TE- TESHEKPUK
  • TH- ST. MATTHEW
  • TI- TRINITY ISLAND
  • TL- TRINITY ISLANDS
  • TR- TELLER
  • TS- TISON
  • TU- STUDDS
  • U0- OPD NS02-08
  • U1- OPD NS03-07
  • U2- OPD NS03-08
  • U3- POSEY
  • U4- COLBERT
  • U5- CHUKCHI SEA
  • U6- POINT LAY WEST
  • U7- POINT HOPE WEST
  • UG- UGASHIK
  • UL- UNALAKLEET
  • UM- UMNAK
  • UN- UNALASKA
  • UO- OPD NS06-08
  • UP- ULM PLATEAU
  • UV- UKIVOK
  • V0- OPD NP01-03
  • V1- BOSSLER
  • V2- SAULSBURY WEST
  • V3- SAULSBURY
  • V4- BANKS
  • V5- ST. MATTHEW WEST
  • V6- PERVENETS CANYON
  • V7- PERVENETS CANYON EAST
  • V8- ST. MATTHEW CANYON
  • W0- OPD NN59-02
  • W1- OPD NN60-01
  • W2- OPD NN60-02
  • W3- OPD NN01-01
  • W4- OPD NN01-02
  • W5- PRIBILOF CANYON WEST
  • W6- OPD NN59-03
  • W7- OPD NN59-04
  • W8- OPD NN60-05
  • WA- WAINWRIGHT
  • WK- WALLS KNOLL
  • YA- YAKUTAT
  • ZC- ZHEMCHUG CANYON
  • ZG- ZHEMCHUG GULLY
  • ZS- ZHEMCHUG SPUR
Bh Total Md MEASURED_DEPTH Number Range Between 0 and 50000