*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Discovery. Outline coordinates, hydrocarbon type and NPD id's. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * discovery_name varchar(40) Discovery name used at the NPD. * * hc_type varchar(40) Main hydrocarbon type of the discovery. * Example: * GAS * GAS/CONDENSATE * OIL * OIL/GAS * * polygon_no int Polygon number in the given discovery. * * 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. * * ew_degrees real East-West geographical co-ordinates in decimal degrees. * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_discovery bigint NPD's unique discovery id. * * NPDID_field bigint NPD's unique field id, if any. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 22.04.2003 OHO/NPD Initial version. * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================