Skip to content

Infrastructure Pipelines Dev

Basic Metadata

Database Schema Database Table No of Features Last Updated
mapstand_phoenix mps_mapping_pipeline_dev 160868 September 18, 2025

Database Table Attributes

Field Type Description
name CharField Name of the pipeline
description TextField Description of the pipeline
id BigAutoField Id
fluid CharField Pipeline fluid
status CharField Pipeline status
optr_name CharField Pipeline operator name
operator_group_name CharField Operator Group Name
unit CharField Unit
category CharField Pipeline category
admin_area_name CharField Country Name where the pipeline is located
mps_est_shore_status CharField Calculated attribute showing whether the pipeline is on or offshore
mps_est_elevation_start_m FloatField Calculated attribute showing elevation at start of seismic survey
mps_est_elevation_end_m FloatField Calculated attribute showing elevation at end of pipeline
mps_est_elevation_min_m FloatField Calculated attribute giving the minimum elevation in meters above or below sea level
mps_est_elevation_max_m FloatField Calculated attribute giving the maximum elevation in meters above or below sea level
mps_est_length_km FloatField Calculated attribute giving the length of pipeline in km
installation_year IntegerField Installation Year
decommissioning_year IntegerField Decommissioning Year
installation_date DateField Installation Date
removal_date DateField Removal Date
admin_area_start CharField Admin Area Start
admin_area_end CharField Admin Area End
is_planned_state BooleanField Is Planned State
type CharField Type
diameter_inches FloatField Diameter Inches
glbl_start_country CharField Glbl Start Country
glbl_start_country_region CharField Glbl Start Country Region
glbl_start_country_subregion CharField Glbl Start Country Subregion
glbl_start_continent CharField Glbl Start Continent
glbl_end_country CharField Glbl End Country
glbl_end_country_region CharField Glbl End Country Region
glbl_end_country_subregion CharField Glbl End Country Subregion
glbl_end_continent CharField Glbl End Continent
mps_created_time DateTimeField Date time that the pipeline was created in the database
updt DateTimeField Last updated time
mps_project_tag TextField Project
mps_datasource_tags TextField Data source tags