Pipeline Location Query Field Definitions

Data Center >> Pipeline >> Pipeline Location Online Query >>
Pipeline Location Online Query Field Definitions


Field Name
Data Type
Field Length
Definition
SEGMENT_NUM NUMBER22The number assigned by MMS to each pipeline segment for purpose of internal identification.
ASBUILT_SEQ_NUM NUMBER22A sequence number identifying a location point on a pipeline asbuilt plat.
LATITUDE NUMBER22The 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 NUMBER22The 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 VARCHAR290The indicator of the North American Datum the data was produced under.
PROJ_CODE VARCHAR29An indicator of the projection code used to generate the x and y coordinates.
X_COORD_LOC NUMBER22The 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 NUMBER22The 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 DATE7Date a row in the database was last updated.
VERSION_DATE DATE7The date an application or data set is put into service.
ASBUILT_FLAG VARCHAR23An indicator of whether a location point on a pipeline is "as built" (Y) or not (N).
PPL_APURT_TYPE VARCHAR290The type of ancilliary structure on a pipeline.
BIDIR_FLAG VARCHAR23An indicator of whether the product in the pipeline can be passed in either direction.

Return to the Pipeline Location Online Query