|
SEGMENT_NUM
| NUMBER | 22 | The number assigned by MMS to each pipeline segment for purpose of internal identification. |
|
ASBUILT_SEQ_NUM
| NUMBER | 22 | A sequence number identifying a location point on a pipeline asbuilt plat. |
|
LATITUDE
| NUMBER | 22 | The angular distance north or south of the equator measured in degrees along a meridian. Maximum length, and decimal length in the business table can be either 12, 8 for all other components or 13, 9 for Lease and Sale components respectively.
|
|
LONGITUDE
| NUMBER | 22 | The angular distance on the earth, east or west of the prime meridian at Greenwich, England, to the point on the earth's surface for which the position is being determined. Maximum length, and decimal length in the business table can be either 13, 8 for all other components or 14, 9 for Lease and Sale components respectively. |
|
NAD_YEAR_CD
| VARCHAR2 | 90 | The indicator of the North American Datum the data was produced under. |
|
PROJ_CODE
| VARCHAR2 | 9 | An indicator of the projection code used to generate the x and y coordinates. |
|
X_COORD_LOC
| NUMBER | 22 | The x-location in a Cartesian coordinate system. Coordinates are used to represent locations on the earth's surface relative to other locations. Plane coordinates describe a two-dimensional x,y location in terms of distance from a fixed reference. The x-coordinate is the easterly/westerly indicator of the coordinate pair. |
|
Y_COORD_LOC
| NUMBER | 22 | The y-location in a Cartesian coordinate system. Coordinates are used to represent locations on the earth's surface relative to other locations. Plane coordinates describe a two-dimensional x, y location in terms of distance from a fixed reference. The y-coordinate is the northerly/southerly indicator of the coordinate pair. |
|
LAST_REV_DATE
| DATE | 7 | Date a row in the database was last updated. |
|
VERSION_DATE
| DATE | 7 | The date an application or data set is put into service. |
|
ASBUILT_FLAG
| VARCHAR2 | 3 | An indicator of whether a location point on a pipeline is "as built" (Y) or not (N). |
|
PPL_APURT_TYPE
| VARCHAR2 | 90 | The type of ancilliary structure on a pipeline. |
|
BIDIR_FLAG
| VARCHAR2 | 3 | An indicator of whether the product in the pipeline can be passed in either direction. |
