Skip to content

Infrastructure Terminals Dev

Basic Metadata

Database Schema Database Table No of Features Last Updated
mapstand_phoenix mps_mapping_terminal_dev 5960 September 18, 2025

Database Table Attributes

Field Type Description
name CharField Name of the Terminal
description TextField Description of the Terminal
id BigAutoField Id
infrastructure_type CharField Infrastructure Type
construction_cost_m_usd FloatField Construction Cost M Usd
design_lifespan_yrs FloatField Design Lifespan Yrs
installation_date DateField Installation Date
removal_date DateField Removal Date
status CharField Status
owner_name CharField Owner Name
owner_group_name CharField Owner Group Name
optr_name CharField Operator Name
operator_group_name CharField Operator Group Name
admin_area_name CharField Country name of the location of the Terminal
mps_est_shore_status CharField Calculated attribute showing whether the Terminal is on or offshore
mps_est_elevation_m FloatField Calculated attribute giving the elevation in meters above or below sea level
capacity_mtpa FloatField Capacity Mtpa
commodity TextField Commodity
marine_in BooleanField Marine In
marine_out BooleanField Marine Out
rail_in BooleanField Rail In
rail_out BooleanField Rail Out
road_in BooleanField Road In
road_out BooleanField Road Out
pipeline_in BooleanField Pipeline In
pipeline_out BooleanField Pipeline Out
storage_type CharField Storage Type
terminal_type CharField Terminal Type
tanks IntegerField Tanks
tank_types CharField Tank Types
tank_sizes_cbm FloatField Tank Sizes Cbm
max_draught_m FloatField Max Draught M
vessel_berths IntegerField Vessel Berths
glbl_country CharField Glbl Country
glbl_country_region CharField Glbl Country Region
glbl_country_subregion CharField Glbl Country Subregion
glbl_continent CharField Glbl Continent
mps_created_time DateTimeField Date time that the Terminal was created in the database
updt DateTimeField Last updated time
mps_project_tag TextField Project
mps_datasource_tags TextField Data source tags