*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Fixed facilities. General information. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * facility_name varchar(40) Facility name used by NPD. * * phase varchar(40) Current phase of the facility. * Examples: * FUTURE * FABRICATION * INSTALLATION * IN SERVICE * DECOMMISSIONED * ABANDONED IN PLACE * REMOVED * LAID UP * * surface_facility varchar(1) Indicates if it is a surface or subsurface facility. * Examples: * Y * N * * functions varchar(2000) Tells what functions the facility covers. * Examples: * DRILLING * DRILLING TEMPLATE * FIELD CONTROL CENTER * FISCAL METERING * FLARE STACK * FLOTEL * FULL STABILIZATION * GAS EXPORT * GAS INJECTION * GAS INJECTOR * GAS PRODUCER * ISOLATION VALVE * LOADING BOUY * MANIFOLD * MANIFOLD STATION * OFFLOADING * OIL PRODUCER * PIG RECIVER * PIPELINE END MANIFOLD * QUARTER * RISER * RISER BASE * RISER SUPPORT * SEPARATION * SILO * STORAGE * T-CONNECTION * TERMINAL * TRAWLGEAR PROTECTION * TUNNEL * UMBILICAL SUPPORT * WATER INJECTION * WATER/GAS INJECTION * WELLHEAD * Y-CONNECTION * PROCESSING * ACCOMMODATION * SUPPORT * BOOSTER * DISTRIBUTION * WATER PRODUCER * or a combination of these. * * geodetic_datum varchar(10) Reference system for coordinates. * * NS_decimal_degrees real Facility location in decimal degree coordinates, * latitude. * * EW_decimal_degrees real Facility location in decimal degree coordinates, * longitude. * * UTM_zone bigint UTM zone. * * NS_UTM real UTM coordinates north/south. * * EW_UTM real UTM coordinates east/west. * * fact_page_url varchar(2000) URL to the NPD's fact-page. * * fact_map_url varchar(2000) URL to the NPD's map-page. * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_facility bigint NPD's unique facility id. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 03.05.2003 OHO/NPD Initial version * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================