*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Production licence. Coordinates, complete history. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ........................................................ * production_licence_name varchar(40) The designation of the production licence. * * date_valid_from date The date the production licence is valid from. * * date_valid_to date The date the given area is valid to. * * polygon_no int The sequence number of the polygon in the given area. * * quadrant int The designation of the quadrant the polygon belongs to. * * block int The designation of the block the polygon belongs to. * * polygon_area real The calculated size of the polygon. * Unit of measure: km2 * * point_no int The sequence number of the co-ordinate point depicting * (one of several) the given polygon. * * ns_degrees real North-South geographical co-ordinates in decimal degrees. * Datum: ED50 * * ew_degrees real East-West geographical co-ordinates in decimal degrees. * Datum: ED50 * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_production_licence bigint NPD's unique production licence id. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 24.01.2003 OHO/NPD Initial version * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================