Data Center

Data Center >>
Field Values for PLANSITESVIEW

Field Values for PLANSITESVIEW

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
Plan Ctrl Cd PLAN_CTRL_CDS Enumeration Range The Value-Description Pairs are listed below:
  • A- Ancillary Plan.
  • N- Initial Plan - First exploration or development plan submitted for a particular bottom-hole lease..
  • O- Oil Spill Response Plan.
  • R- Revised Plan - An proposed change to an approved exploration or development plan that does not increase the number of allowable permits..
  • S- Supplemental Plan - A proposed addition to an approved exploration or development plan that will cause in increase in the number of allowable permits..
  • U- Historic Unit Plan - A Unit plan reviewed by the Plans Section before the Plans Section was given authority to approve the Unit Plans..
Site Cancel Dt GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Plan Fnl Actn Cd PLAN_FNL_ACTN_CDS Enumeration Range The Value-Description Pairs are listed below:
  • A- Approved - The exploration or development plan is approved..
  • C- Conditional Approval - Approved with certain conditions that require the submission of additional information after operations are started..
  • D- Denied - The exploration or development plan can not be approved, and the operator does not have the ability to modify the plan to correct the problem..
  • M- Modification required - A problem was identified that must be correct before approval can be granted..
  • V- Verbal approval - For revised plans that include only small changes to approved plans and that require no additional environmental analysis..
  • X- Canceled by operator.
Plan Fnl Actn Dt FLD_DATE Date Range Between 01-JAN-47 and 01-DEC-97
Surf E W Dist N_S_E_W_DISTS Number Range Between 0 and 32000
Surf E W Code E_W_CODES Enumeration Range The Value-Description Pairs are listed below:
  • E- EAST BLOCK LINE.
  • W- WEST BLOCK LINE.
Surf N S Dist N_S_E_W_DISTS Number Range Between 0 and 32000
Surf N S Code N_S_CODES Enumeration Range The Value-Description Pairs are listed below:
  • N- NORTH BLOCK LINE.
  • S- SOUTH BLOCK LINE.
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.
Surf Proj Zone PROJ_ZONE_CODES Enumeration Range The Value-Description Pairs are listed below:
  • 01- 177W 180W-174W.
  • 02- 171W 174W-168W.
  • 03- 165W 168W-162W.
  • 04- 159W 162W-156W.
  • 05- 153W 156W-150W.
  • 06- 147W 150W-144W.
  • 07- 141W 144W-138W.
  • 08- 135W 138W-132W.
  • 09- 129W 132W-126W.
  • 10- 123W 126W-120W.
  • 11- 117W 120W-114W.
  • 12- 111W 114W-108W.
  • 13- 105W 108W-102W.
  • 14- 099W 102W-096W.
  • 15- 093W 096W-090W.
  • 16- 087W 090W-084W.
  • 17- 081W 084W-078W.
  • 18- 075W 078W-072W.
  • 19- 069W 072W-066W.
  • 20- 063W 066W-060W.
  • 21- 057W 060W-054W.
  • 22- 051W 054W-048W.
  • 23- 045W 048W-042W.
  • 24- 039W 042W-036W.
  • 25- 033W 036W-030W.
  • 26- 027W 030W-024W.
  • 27- 021W 024W-018W.
  • 28- 015W 018W-012W.
  • 29- 009W 012W-006W.
  • 30- 003W 006W-000E.
  • 31- 003E 000E-006E.
  • 32- 009E 006E-012E.
  • 33- 015E 012E-018E.
  • 34- 021E 018E-024E.
  • 35- 027E 024E-030E.
  • 36- 033E 030E-036E.
  • 37- 039E 036E-042E.
  • 38- 045E 042E-048E.
  • 39- 051E 048E-054E.
  • 40- 057E 054E-060E.
  • 41- 063E 060E-066E.
  • 42- 069E 066E-072E.
  • 43- 075E 072E-078E.
  • 44- 081E 078E-084E.
  • 45- 087E 084E-090E.
  • 46- 093E 090E-096E.
  • 47- 099E 096E-102E.
  • 48- 105E 102E-108E.
  • 49- 111E 108E-114E.
  • 50- 117E 114E-120E.
  • 51- 123E 120E-126E.
  • 52- 129E 126E-132E.
  • 53- 135E 132E-138E.
  • 54- 141E 138E-144E.
  • 55- 147E 144E-150E.
  • 56- 153E 150E-156E.
  • 57- 159E 156E-162E.
  • 58- 165E 162E-168E.
  • 59- 171E 168E-174E.
  • 60- 177E 174E-180W.
  • 70- Texas (Lambert), South Zone (OCSIS).
  • 71- Texas (Lambert), South Central Zone (OCSIS).
  • 72- Louisiana (Lambert), South Zone (OCSIS).
  • 73- Alabama (Lambert), South Zone (OCSIS).
  • 86- California (Lambert), Zone 6 (OCSIS).
  • 87- Alaska State Plane, 3 feet.
  • 88- Alaska State Plane, 4 feet.
Surf X Coord Loc COORDINATE Number Range Between -99999999.999999 and 99999999.999999
Surf Y Coord Loc COORDINATE Number Range Between -99999999.999999 and 99999999.999999
Surf Latitude WELL_LATITUDES Number Range Between 23.23434 and 31.19888
Surf Longitude WELL_LONGITUDES Number Range Between -97.51426 and -79.52885
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.
Water Depth WATER_DEPTHS Number Range Between 0 and 13000
Plan Type Code PLAN_TYPE_CODES Enumeration Range The Value-Description Pairs are listed below:
  • DOCD- Development Operations Coordination Document (A Development Plan leases in the Western Gulf of Mexico).
  • DPP- Development Production Plans.
  • EP- Exploration Plan.
  • POD- Plan of Development.
  • POE- Plan of Exploration.
Plan Sub Recv Dt GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10