Data Center

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

Field Definitions for PIPELINE LOCATION BY VERSION DATE WITH APPURT

Click on hyperlinked Column Aliases to show possible values.

The Start Position Column is used for fixed dumps only. Click on the column alias for a valid list of values or codes associated with the element selected.

Start
Position
Item
Length
Column
Alias
Definition
1 8 Segment Number SEGMENT_NUM -The number assigned by MMS to each pipeline segment for purpose of internal identification.
9 5 Point Seq Num ASBUILT_SEQ_NUM -A sequence number identifying a location point on a pipeline asbuilt plat.
14 14 Latitude ASBUILT_LAT -The latitude coordinate of a location point on a pipeline asbuilt plat.
28 15 Longitude ASBUILT_LONG -The longitude coordinate of a location point on a pipeline asbuilt plat.
43 2 Nad Year Cd NAD_YEAR_CD -The indicator of the North American Datum the data was produced under.
45 3 Proj Code PROJ_CODE -An indicator of the projection code used to generate the x and y coordinates.
48 18 X Coord Loc SURF_X_COORD_LOC -X coordinate for a surface location (east-west measurement).
66 18 Y Coord Loc SURF_Y_COORD_LOC -Y coordinate for a surface location (north-south measurement).
84 8 Last Rev Date LAST_REV_DATE -Date a row in the database was last updated.
92 8 Version Date VERSION_DATE -The date an application or data set is put into service.
100 1 Asbuilt Flag ASBUILT_FLAG -An indicator of whether a location point on a pipeline is "as built" (Y) or not (N).
101 15 Ppl Apurt Type PPL_APURT_TYPE -The type of ancilliary structure on a pipeline.
116 200 Ppl Apurt Name PPL_APURT_NAME -The name of an ancilliary structure on a pipeline.