*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Development 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. * * production_facility_name varchar(50) The NPD's designation of the facility the wellbore was/is * produced 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. * * multilateral varchar(20) Indicates wether it's a multilateral wellbore or not: * NO * YES * * 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 8013 - 203 SP. 200 (TARGET) * ST 8511 - 252 CDP 685 * ST 8511 306 642 1805 (TARGET) * ST 8511236 CDP 492 * ST 8511-268,EDP 620 * * wellbore_status varchar(60) Wellbore status at completion date. * Examples: * CLOSED * INJECTING * JUNKED * PLUGGED * PRODUCING * PRODUCING/INJECTING * SUSP.AT 13 3/8" * SUSP.AT 14" * SUSP.AT 18 5/8" * SUSP.AT 20" * SUSP.AT 30" * SUSP.AT 9 5/8" * SUSP.AT TD * * wellbore_contents varchar(60) Indicates the contents of the wellbore. * Examples: * CO2 * CUTTINGS * GAS * GAS/CONDENSATE * NOT APPLICABLE * NOT AVAILABLE * OIL * OIL/GAS * WATER * * original_wellbore_contents varchar(60) Pre-drilled expected contents of the wellbore. * Examples: * CO2 * CUTTINGS * GAS * GAS/CONDENSATE * NOT APPLICABLE * NOT AVAILABLE * OIL * OIL/GAS * WATER * * wellbore_purpose varchar(60) Post-drill classification of the wellbore. * Examples: * INJECTION * OBSERVATION * PRODUCTION * * original_wellbore_purpose varchar(60) Pre-drill purpose of the wellbore. * Examples: * INJECTION * OBSERVATION * PRODUCTION * * 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 * * 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_drilling bigint NPD's unique facility id for the facility the wellbore is * drilled from. * * NPDID_facility_production bigint NPD's unique facility id for the facility the wellbore is * produced 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. * * 18.04.2005 OHO/NPD Removed column: drilling_facility_type and age_at_total_depth. * Introduced column: production_facility_name, original_wellbore_contents, * multilateral and NPDID_facility_production. * Renamed column: NPDID_facility to NPDID_facility_drilling. * * 14.05.2010 ON/NPD Removed the word "discovery" from the description of "NPDID_wellbore". * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================