*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Exploration wellbores. General information. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * wellbore_name varchar(60) Official wellbore name based on NPD guidelines for * designation of wells and wellbores. * * well_name varchar(60) Official well name based on NPD guidelines for designation * of wells and wellbores. * * discovery_name varchar(40) Name of the discovery the wellbore is related to. * * field_name varchar(40) Official name of the field the wellbore is drilled on. * * production_licence_name varchar(40) The official designation of the production licence the * wellbore was drilled in. * * drill_permit int The drilling permit number as stated in the drilling * permit granted when permission for drilling is applied. * * drill_permit_version varchar(10) The version of the drilling permit. * Examples: * L: exploration * P: development * * drill_oper_group_designation varchar(40) Group designation of the drilling operator company. * * drill_oper_long_name varchar(100) Long name of the drilling operator company. * * drilling_facility_name varchar(50) The NPD's designation of the facility the wellbore was * drilled from. * * wellbore_entry_date date The date when the drill bit penetrates the earth * crust/sea floor. * * wellbore_completion_date date The date when the last anchor is pulled after drilling * activities are ended. * * drilling_days int Duration of drilling the well. * * main_NCS_area varchar(60) Main geographical area on the Norwegian Continental Shelf. * Examples: * BARENTS SEA * NORWEGIAN SEA * NORTH SEA * * quadrant int The designation of the quadrant the wellbore is drilled in. * * block int The designation of the block the wellbore is drilled in. * * well_number_in_block int Sequence number of the well in the given block (item 4 in * the well name). * * NS_decimal_degrees real Well location at surface in decimal degree coordinates, * latitude. * * EW_decimal_degrees real Well location at surface in decimal degree coordinates, * longitude. * * geodetic_datum varchar(10) Reference system for coordinates. * * NS_UTM real UTM coordinates north/south. * * EW_UTM real UTM coordinates east/west. * * UTM_zone bigint UTM zone. * * seismic_location varchar(60) Position of well on seismic survey lines. * Examples: * ST 8403 - 445 SP. 350 * ST 8403 - 451 SP. 338 * ST 8403 - 463 SP. 322 * * reentry_activity varchar(60) Activity performed in reentry wellbore. * Examples: * DRILLING * DRILLING/PLUGGING * LOGGING * PLUGGING * TESTING * TESTING/PLUGGING * * wellbore_status varchar(60) Wellbore status at completion date. * Examples: * ABANDONED * BLOWOUT * JUNKED * P&A * PLUGGED * RE-CLASS TO DEV * SUSP.AT 13 3/8'' * SUSP.AT 7'' * SUSP.AT 9 5/8'' * SUSP.REENTERED LATER * SUSPENDED * * wellbore_contents varchar(60) Shows (trace amounts of hydrocarbons), GAS, CONDENSATE, or * OIL. SHOWS are detected as fluorescent cut (organic extract), * petroleum odour, or visual stain on cuttings or cores, or as * increased gas reading on the mud-loggers gas detection * equipment. * Examples: * DRY * GAS * GAS SHOWS * GAS/CONDENSATE * NO INFO * OIL * OIL SHOWS * OIL/GAS * OIL/GAS SHOWS * SHOWS * * wellbore_purpose varchar(60) Post-drill classification of the wellbore. * Examples: * APPRAISAL * WILDCAT * * original_wellbore_purpose varchar(60) Pre-drill purpose of the wellbore. * Examples: * APPRAISAL * WILDCAT * * total_depth int Total measured length of well bore from kelly bushing to * total depth. Unit of measure: m * * kelly_bushing_elevation int Elevation of rotary kelly bushing above mean sea level. * Unit of measure: m * * water_depth int Water depth from mean sea level at well site. * Unit of measure: m * * deepest_penetrated_age varchar(60) Deepest penetrated age. For most of the wellbores, this is * age of formation at total depth. For highly deviated * wellbores, this may differ from age at TD. * Examples: * CARBONIFEROUS * CRETACEOUS * DEVONIAN * EARLY CARBONIFEROUS * EARLY CRETACEOUS * EARLY JURASSIC * EARLY PERMIAN * EARLY TRIASSIC * EOCENE * JURASSIC * LATE CARBONIFEROUS * LATE CRETACEOUS * LATE JURASSIC * LATE PERMIAN * LATE TRIASSIC * MIDDLE JURASSIC * MIDDLE TRIASSIC * MIOCENE * OLIGOCENE * PALEOCENE * PERMIAN * PLIOCENE * PRE-DEVONIAN * TERTIARY * TRIASSIC * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_wellbore bigint NPD's unique wellbore id. * * NPDID_discovery bigint NPD's unique discovery id for the discovery the well is * related to. * * NPDID_field bigint NPD's unique field id for the field the wellbore is * drilled on. * * NPDID_facility bigint NPD's unique facility id for the facility the wellbore is * drilled from. * * NPDID_production_licence bigint NPD's unique production licence id for the production * licence the wellbore was drilled in. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 23.09.2003 HaS/NPD Initial version * * 23.11.2003 OHO/NPD Changed wellbore_status and seismic_location from using " to '' because of conflict * with text qualifier. * * 22.04.2005 OHO/NPD Removed column: drilling_facility_type. * Introduced column: reentry_activity. * Renamed column: age_at_total_depth to deepest_penetrated_age. * * 14.05.2010 ON/NPD Removed the word "discovery" from the description of "NPDID_wellbore". * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================