Data Center

Data Center >>
Field Values for PIPELINE LOCATION DATA WITH APPURT - HISTORIC

Field Values for PIPELINE LOCATION DATA WITH APPURT - HISTORIC

Column
Alias Name
Domain
Name
Domain
Type
Valid Value
Description
Segment Number SEGMENT_NUMBERS Number Range Between 0000000 and 9999999
Point Seq Num GD0-9999 Number Range Between 0 and 9999
Latitude LATITUDES Number Range Between -90.00000000 and +90.00000000
Longitude LONGITUDES Number Range Between -180.00000000 and +180.00000000
Nad Year Cd NAD_CODES Enumeration Range The Value-Description Pairs are listed below:
  • 27- NAD27.
  • 83- NAD83.
Proj Code PROJ_CODES Enumeration Range The Value-Description Pairs are listed below:
  • 00- LONG-LAT.
  • 01- UTM ZONE 1.
  • 02- UTM ZONE 2.
  • 03- UTM ZONE 3.
  • 04- UTM ZONE 4.
  • 05- UTM ZONE 5.
  • 06- UTM ZONE 6.
  • 07- UTM ZONE 7.
  • 08- UTM ZONE 8.
  • 09- UTM ZONE 9.
  • 10- UTM ZONE 10.
  • 11- UTM ZONE 11.
  • 12- UTM ZONE 12.
  • 13- UTM ZONE 13.
  • 14- UTM ZONE 14.
  • 15- UTM ZONE 15.
  • 16- UTM ZONE 16.
  • 17- UTM ZONE 17.
  • 18- UTM ZONE 18.
  • 19- UTM ZONE 19.
  • 20- UTM ZONE 20.
  • 21- UTM ZONE 21.
  • 22- UTM ZONE 22.
  • 23- UTM ZONE 23.
  • 24- UTM ZONE 24.
  • 25- UTM ZONE 25.
  • 26- UTM ZONE 26.
  • 27- UTM ZONE 27.
  • 28- UTM ZONE 28.
  • 29- UTM ZONE 29.
  • 30- UTM ZONE 30.
  • 31- UTM ZONE 31.
  • 32- UTM ZONE 32.
  • 33- UTM ZONE 33.
  • 34- UTM ZONE 34.
  • 35- UTM ZONE 35.
  • 36- UTM ZONE 36.
  • 37- UTM ZONE 37.
  • 38- UTM ZONE 38.
  • 39- UTM ZONE 39.
  • 40- UTM ZONE 40.
  • 41- UTM ZONE 41.
  • 42- UTM ZONE 42.
  • 43- UTM ZONE 43.
  • 44- UTM ZONE 44.
  • 45- UTM ZONE 45.
  • 46- UTM ZONE 46.
  • 47- UTM ZONE 47.
  • 48- UTM ZONE 48.
  • 49- UTM ZONE 49.
  • 50- UTM ZONE 50.
  • 51- UTM ZONE 51.
  • 52- UTM ZONE 52.
  • 53- UTM ZONE 53.
  • 54- UTM ZONE 54.
  • 55- UTM ZONE 55.
  • 56- UTM ZONE 56.
  • 57- UTM ZONE 57.
  • 58- UTM ZONE 58.
  • 59- UTM ZONE 59.
  • 60- UTM ZONE 60.
  • 61- RECTANGULAR.
  • 62- TRANSVERSE MERCATOR.
  • 63- LAMBERT CONFORMAL CONIC.
  • 70- TEXAS SOUTHERN LAMBERT.
  • 71- TEXAS SOUTH CENTRAL LAMBERT.
  • 72- LOUISIANA SOUTHERN LAMBERT.
  • 73- ALABAMA LAMBERT.
  • 74- WASHINGTON LAMBERT NORTH.
  • 86- CALIFORNIA LAMBERT ZONE 6.
X Coord Loc COORDINATE Number Range Between -99999999.999999 and 99999999.999999
Y Coord Loc COORDINATE Number Range Between -99999999.999999 and 99999999.999999
Last Rev Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Version Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Asbuilt Flag FLAG Enumeration Range The Value-Description Pairs are listed below:
  • N- No.
  • Y- Yes.
Ppl Apurt Type PPL_APURT_TYPES Enumeration Range The Value-Description Pairs are listed below:
  • ANODE- An anode was installed at this point..
  • BEGIN SPAN PT- The beginning of a span exists at the location point..
  • BEND- A point along a bend in the pipeline..
  • BLOCK LINE- A block boundary line is crossed at this point..
  • CAGE- A protective valve cage or dome exists at the location point..
  • CAP- A cap was installed on the pipeline at the location point..
  • CLAMP- A clamp exists at the location point..
  • COIL TUBING- Coil tubing exists at the location point..
  • CONCRETE MAT- A concrete mat exists at the location point..
  • CROSSING- A pipeline crossing exists at the location point..
  • END SPAN PT- The end point of a span exists at the location point..
  • FAIRWAY- A fairway boundary is crossed at this point..
  • FED-STATE LINE- The Federal/state boundary is crossed at this point..
  • FLANGE- A connection flange exists at the location point..
  • FLEXIBLE PIPE- Flexible pipe exists at the location point..
  • MAIN LINE VALVE- A main line shut down valve exists at the location point..
  • NEW PIPE- Replacement pipe was installed at the location point..
  • PIPELINE SLED- A subsea pipline connection sled exists at the location point..
  • PLATFORM- A platform exists at the location point..
  • PUMP- A pump exists at the location point..
  • RISER- Pipeline riser exists at the location point..
  • SHORELINE- The shoreline is crossed at this point..
  • SHROUD- A protective cover over a flange, crossing, etc., exists at the location point..
  • SUBSEA MANIFOLD- A subsea manifold exists at the location point..
  • SUBSEA SEA PIG- A subsea pig trap or pig launcher exists at the location point..
  • SUBSEA WELL- A subsea well exists at the location point..
  • SUPPORT- A pipeline support exists at the location point..
  • TIE-IN- A subsea tie-in exists at the location point..
  • UMBILICAL SLED- a subsea umbilical sled exists at location point..
  • VALVE- A subsea tie-in side-tap valve exists at the location point..
  • WELL- A single-well cassion exists at the location point..
Version Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10