Data Center

Data Center >>
Field Values for PIPELINE LOCATION BY VERSION DATE WITH APPURT

Field Values for PIPELINE LOCATION BY VERSION DATE WITH APPURT

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..