Skip to content

Rigspecification

Basic Metadata

Database Table No of Features Last Updated
mps_mapping_rigspecification 780 March 28, 2024

Coverage

Database Table Attributes

Field Type Description
rig_name CharField Name of the Rig
description TextField Description of the Rig
imo_number IntegerField IMO number of the Rig
mmsi IntegerField Maritime Mobile Service Identity number
rig_manager_name CharField Rig Manager Name
rig_manager_group_name CharField Rig Manager Group Name
rig_owner_name CharField Rig Owner Name
rig_owner_group_name CharField Rig Owner Group Name
rig_type CharField Rig Type eg jackup drillship semi-submersible
rig_sub_type CharField Rig Sub Type definition
rig_generation CharField Rig generation determines delivery year and water depth capability
year_built IntegerField Year Built
year_last_upgraded IntegerField Year Last Upgraded
rig_status CharField Operating status definition of the rig
harsh_environment CharField Designed for harsh environment
accommodation IntegerField Accommodation module present or not
no_bops IntegerField Number of Blowout Preventers
bop_max_psi FloatField Max Psi of BOP
hook_load FloatField Total force pulling down on the hook
max_water_depth FloatField Max Water Depth
next_sps_due_date DateField Next Sps Due Date
mps_est_shore_status CharField Calculated attribute showing whether the Rig is on or offshore
mps_est_elevation_m FloatField Calculated attribute showing elevation of the Rig
mps_created_time DateTimeField Date time that the seabed feature was created in the database
updt DateTimeField Last updated time
mps_project_tag TextField Project
mps_datasource_tags TextField Data source tags