Data Center

Data Center >>
Field Values for Platform Structure Removals

Field Values for Platform Structure Removals

Column Alias Name
Position
Domain Name
Length
Domain Type
Alias
Valid Value Description
Mms Company Num MMS_COMPANY_NUMS Number Range Between 00001 and 99999
Received Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Final Action Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Removal Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Site Clearance Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Area Code 0059 Character The Value-Description Pairs are listed below:
  • AB- NG 15-8 60.
  • 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.
  • 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.
Proposed Removal Date PROPOSED_RMV_DTS Date Range Between 01-JAN-1947 and SYSDATE+3650
District Code DISTRICT_CODES Character The Value-Description Pairs are listed below:
  • 1- NEW ORLEANS DISTRICT.
  • 2- HOUMA DISTRICT.
  • 3- LAFAYETTE DISTRICT.
  • 4- LAKE JACKSON DISTRICT.
  • 5- LAKE CHARLES SUBDISTRICT.
  • 6- CORPUS CHRISTI SUBDISTRICT.
Structure Number STRUCTURE_NUMBERS Number Range Between 01 and 99
Water Depth WATER_DEPTHS Number Range Between 0 and 13000