Infrastructure Platform Dev

Basic Metadata

Database Schema	Database Table	No of Features	Last Updated
mapstand_phoenix	infrastructure_platform_dev	None	September 18, 2025

Database Table Attributes

Field	Type	Description
name	CharField	Name of the platform
description	TextField	Description of the platform
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	nstallation date of the platform
owner_name	CharField	Platform owner name
owner_group_name	CharField	Owner Group Name
optr_name	CharField	Platform operator name
operator_group_name	CharField	Operator Group Name
removal_date	DateField	Removal Date
sub_type	CharField	Platform sub type
purpose	CharField	Platform purpose
fixed_floating	CharField	Fixed or floating platform
status	CharField	Platform status
topside_weight_tonnes	FloatField	Topside Weight Tonnes
total_weight_tonnes	FloatField	Total Weight Tonnes
helipad	BooleanField	Helipad or not
manned	BooleanField	Manned or not
berths	IntegerField	Number of berths on the platform
well_slots	IntegerField	Number of well slots on the platform
admin_area_name	CharField	Country Name where the Platform is located
mps_est_shore_status	CharField	Calculated attribute showing whether the platform is on or offshore
mps_est_elevation_m	FloatField	Calculated attribute showing elevation of platform
glbl_country	CharField	Glbl Country
glbl_country_region	CharField	Glbl Country Region
glbl_country_subregion	CharField	Glbl Country Subregion
glbl_continent	CharField	Glbl Continent
electrification	BooleanField	Electrification
is_planned_state	BooleanField	Is Planned State
sector	CharField	Sector
sector_sub_type	CharField	Sector Sub Type
mps_created_time	DateTimeField	Date time that the Platform was created in the database
updt	DateTimeField	Last updated time
mps_project_tag	TextField	Project
mps_datasource_tags	TextField	Data source tags