*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Exploration wellbore. Fact-page TOPs. *----------------------------------------------------------------------------------------------------------- * 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. * * lithostratigraphic_unit varchar(40) Lithostratigraphic unit. * * level int Level of lithostratigraphic unit. * Level 2 will normally be "lithostratigraphic group" or equivalent. * Level 3 will normally be "lithostratigraphic formation". * Level 4 will normally be "lithostratigraphic member". * * top_depth int Measured length along the wellbore from kelly bushing * to start of lithostratigraphic unit. * Always the formation the bit goes into. Note that in some * situations, for example highly deviated wells, faults, drilling * beyond salt walls, this might not be a true stratigraphic top. * The start of a unit will be its stratigraphic base when drilled * from underneath. In case of intercalating formations several top * depths may occur for the same formation designating the * top depths of the sub-packages. * Unit of measure: m * * bottom_depth int Measured length along the wellbore from kelly bushing * to end of lithostratigraphic unit. * Always the formation the bit goes into. Note that in some * situations, for example highly deviated wells, faults, drilling * beyond salt walls, this might not be a true stratigraphic top. * The end of a unit will be its stratigraphic top when drilled * from underneath. In case of intercalating formations several * bottom depths may occur for the same formation designating * the bottom depths of the sub-packages. * The end of the lowest lithostratigraphic unit equals TD * (total final depth) for the well. * Unit of measure: m * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_wellbore int NPD's unique wellbore id. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 14.01.2009 ON,AW,TBR/NPD Initial version * 13.04.2010 ON,AW/NPD Level 4 will normally be "lithostratigraphic member". * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================