Data Center

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

Field Values for PIPELINE LOCATION DATA WITH APPURT - PART TWO

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