Data Center

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

Field Definitions for PIPELINE LOCATION DATA WITH APPURT - HISTORIC

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.
316 18 Version Date VERSION_DATE -The date an application or data set is put into service.