Overview of Coding Systems in CountrySTAT/FENIX
Explore the detailed coding systems within the CountrySTAT/FENIX platform including Central Product Classification, Harmonized Commodity Description, and more. Learn how to use the coding systems to create tables and manage data effectively for economic analysis and decision-making.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
CountrySTAT / FENIX Overview of the Coding System in the new CountrySTAT platform TRAINING OF FOCAL POINTS ON THE CountrySTAT/FENIX SYSTEM
Overview Work flow Coding System: Central Product Classification Coding System: Harmonized Commodity Description and Coding System Coding System: Global Administrative Unit Layers Coding System: CountrySTAT indicators Coding System: Fishery products Coding System: Scientific Fishery products Coding System: Forestry products Coding System: Forestry trees Coding System: DAC Coding System: Attributes Coding System: Unit of measurement Coding System: Flags Coding System: Country specific
Work flow Use the right Coding System Create your table following the rules Have the data ready CVS format No columns with labels CPC 2.1 HS GAUL CountrySTAT indicators Unit of Measurement DAC Attributes Flag Forestry production Fishery production Scientific Fishery production Codifications: Forestry trees metadata ready Have the Title Subject Data type Domain Your table is published Go to the metadata editor Upload the values Create the DSD structure Fill all metadata 07/09/2024 3
Coding Systems CPC 2.1 For goods and services GAUL For geo data HS For trade data CountrySTAT indicators For all indicators UM Unit of measurement Attributes Characteristics of the indicators Flags To indicate missing and estimated values Forestry products Fishery products DAC For sectors Scientific Fishery products Forestry trees
Coding System: CPC The Central Product Classification (CPC) constitutes a complete product classification covering all goods and services based on a set of internationally agreed concepts, definitions, principles and classification rules It provides a comprehensive framework within which data on products can be collected and presented in a format that allows for economic analysis supporting decision-taking and policy-making 07/09/2024 5
Coding System: CPC The current version, CPC version 2.1, is the result of a scheduled review of the CPC structure and detail, in order to ensure the classification s relevance for describing current products in the economy. For CountrySTAT should be utilized an expanded version (provided in the Excel file) All detailed structure and explanatory notes can be found at the following link (CPC 2.1 not expanded version): http://unstats.un.org/unsd/cr/registry/regcst. asp?Cl=31 Here all the available correspondences: http://unstats.un.org/unsd/cr/registry/regot.asp?Lg=1
Coding Systems: HS The Harmonized Commodity Description and Coding System generally referred to as "Harmonized System" or simply "HS" is a multipurpose international product nomenclature developed by the World Customs Organization (WCO). The Harmonized Commodity Description and Coding System (HS) is an exhaustive nomenclature of internationally traded commodities (goods) classified according to the following criteria: raw or basic material degree of processing use or function economic activities In CountrySTAT we use the 6 digits HS codification 07/09/2024 12
Coding Systems: GAUL The Global Administrative Unit Layers (GAUL) is an initiative implemented by FAO within the Bill & Melinda Gates Foundation, Agricultural Market Information System (AMIS) and AfricaFertilizer.org projects. The GAUL compiles and disseminates the best available information on administrative units for all the countries in the world, providing a contribution to the standardization of the spatial dataset representing administrative units. The GAUL always maintains global layers with a unified coding system at country, first (e.g. departments) and second administrative levels (e.g. districts). Where data is available, it provides layers on a country by country basis down to third, fourth and lowers levels
Coding Systems: GAUL The overall methodology consists in a) collecting the best available data from most reliable sources b) establishing validation periods of the geographic features (when possible) c) adding selected data to the global layer based on the last country boundaries map provided by the UN Cartographic Unit (UNCS) d) generating codes using GAUL Coding System e) distribute data to the users
Coding Systems: GAUL Because GAUL works at global level, unsettled territories are reported. The approach of GAUL is to deal with these areas in such a way to preserve national integrity for all disputing countries . GAUL is released once a year and the target beneficiary of GAUL data is the UN community and other authorized international and national partners. Data might not be officially validated by authoritative national sources and cannot be distributed to the general public. A disclaimer should always accompany any use of GAUL data. GAUL keeps track of administrative units that has been changed, added or dismissed in the past for political causes. Changes implemented in different years are recorded in GAUL on different layers. For this reason the GAUL product is not a single layer but a group of layers, named "GAUL Set" .
Coding Systems: GAUL ADM0_NAME Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan Afghanistan ADM1_CODE ADM1_NAME Paktika Parwan Uruzgan Badakhshan Badghis Baghlan STR1_YEAR EXP1_YEAR 99877 297 301 272 273 274 275 276 99878 277 278 279 280 1000 1000 1000 1000 1000 1000 1000 1000 2004 1000 1000 1000 1000 1994 2003 2003 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 Balkh Bamyan Daykundi Farah Faryab Ghazni Ghor These are just the first few lines to give an idea of the codification. Entire codification is provided through the Excel file GAUL
Coding Systems: CountrySTAT Indicators code 0101 0102 0103 0104 0105 0106 0201 0202 0203 0301 0302 0303 0304 0305 0306 0307 0308 0309 indicator Production quantity Production value Yield Area Harvested Area sown Seeds quantity Protein quantity Lipid quantity Food supply quantity Export quantity Export value Import quantity Import value Consumption quantity Re-export quantity Re-export value Re-import quantity Re-import value Domain Machinery 0401 Machines in service Population Economically active population Population total density Population growth Rate Life expectancy Consumer price Producer price Commercial rate Official rate Wholesale price Annual average price Constant prices Current prices 0501 Production 0502 0503 0504 0505 0601 0602 0603 0604 0605 0606 Population Food availability Prices Trade Value added0701 0702
Coding Systems: CountrySTAT Indicators 0801 0802 0803 Administrative Area Agricultural area Arable land Arable land and permanent crops area Area equipped for irrigation Fallow Land Forest area Inland water Land Area Other land Other wooded land Permanent crops area Permanent meadows and pastures Temporary crops area Temporary meadows and pastures Unemployment Rate Labour force Participation Rate Average rainfall Max temperature Min temperature 1101 1102 110201 Female Live Animals 110202 Lactating Animals 110203 Male Live Animals 110204 Born Animals 110205 Bought Animals 110206 Animals got as gift 110207 Animals got for caretaking 110208 Sold Animals 110209 Stolen Animals 110210 Animals given for caretaking 110211 Animals given as gift 1103 Laying hens 1104 Dead Animals 1105 Total Input 1106 Total Output Slaughtered animals Live animals 0804 0805 0806 0807 0808 0809 0810 0811 0812 0813 0814 0815 Land use Livestock Employment0901 0902 1001 1002 1003 Water
Coding Systems: CountrySTAT Indicators 1201 1202 1203 1301 130101 130102 13010201 13010202 130103 1302 130201 130202 13020201 13020202 130203 GPD GDP growth GDP per capita Aquaculture production Inland Aquaculture production Marine Aquaculture production Industrial Marine Aquaculture production Artisanal Marine Aquaculture production Marine/Brackish Aquaculture production Capture production Inland Capture production Marine Capture production Industrial Marine Capture production Artisanal Marine Capture production Marine/Brackish Capture production National Account Fishery
Coding Systems: Unit of Measurement 0116 0117 0118 0119 0120 0121 0122 0123 0124 0125 0126 0127 0128 0129 0130 0131 0132 Centimeter local currency by ton Degree Celsius Percentage MT or Cubic meter Local currency/hectar Local currency/1 cubic meter Kg/Ha Local currency/Kg 1000 Ha mm Square meter Household Ton/Ha Km2 Years Local currency/dollar 0101 0102 0103 0104 0105 0106 0107 0108 0109 0110 0111 0112 0113 0114 0115 head Ha ton US$ local currency index thousands units cubic meter kg/capita/yr Kcal/capita/day g/capita/day 1000 US$ Liter Cubic meter/second Choose only 1 of the 3 codes These are just the first few lines to give an idea of the codification. Entire codification is provided through the Excel file 2016_Codelist_final
Coding Systems: Fishery products code product Freshwater fishes Marine fishes not identified Crustaceans Freshwater crustaceans Crabs, sea-spiders Lobsters, spiny-rock lobsters King crabs, squat-lobsters Shrimps, prawns Krill, planktonic crustaceans Miscellaneous marine crustaceans 39 4 41 42 43 44 45 46 1 62 Sperm-whales, pilot-whales Carps, barbels and other cyprinids 11 Tilapias and other cichlids 63 64 7 71 72 73 74 Eared seals, hair seals, walruses Miscellaneous aquatic mammals Miscellaneous aquatic animals Frogs and other amphibians Turtles Crocodiles and alligators Sea-squirts and other tunicates Horseshoe crabs and other arachnoids 12 Miscellaneous freshwater fishes 13 Diadromous fishes 2 Sturgeons, paddlefishes 21 River eels 22 Salmons, trouts, smelts 47 5 51 52 53 54 55 56 57 23 75 76 77 Molluscs Freshwater molluscs Abalones, winkles, conchs Oysters Mussels Scallops, pectens Clams, cockles, arkshells Squids, cuttlefishes, octopuses Miscellaneous marine molluscs Shads 24 Sea-urchins and other echinoderms Miscellaneous aquatic invertebrates Miscellaneous aquatic animal products Pearls, mother-of-pearl, shells Corals Sponges Aquatic plants Brown seaweeds Red seaweeds Green seaweeds Miscellaneous aquatic plants Miscellaneous diadromous fishes 25 Marine fishes 3 8 81 82 83 9 91 92 93 94 Flounders, halibuts, soles 31 Cods, hakes, haddocks 32 Miscellaneous coastal fishes 33 Miscellaneous demersal fishes 34 Herrings, sardines, anchovies 35 58 Tunas, bonitos, billfishes 36 Whales, seals and other aquatic mammals Miscellaneous pelagic fishes 37 6 61 Sharks, rays, chimaeras Blue-whales, fin-whales 38
Coding Systems: Scientific Fishery products code 1400100101 1400100201 1400100401 1400100402 1400100403 1400100404 1400100405 1400100601 1400100602 1400100603 1400100901 1400101101 1400102001 1400102901 1400110601 1400112001 1400112801 1400112901 1400113701 dimensions Cycleptus elongatus Deltistes luxatus Catostomus catostomus Catostomus commersoni Catostomus latipinnis Catostomus macrocheilus Catostomus tahoensis Moxostoma congestum Moxostoma erythrurum Moxostoma macrolepidotum Lagochila lacera Ictiobus cyprinellus Myxocyprinus asiaticus Carpiodes carpio Xyrauchen texanus Chasmistes cujus Minytrema melanops Erimyzon sucetta Hypentelium nigricans 1400200102 1400200201 1400200202 1400200401 1400200501 1400200601 1400200701 1400200801 1400201201 1400201202 1400201301 1400201302 1400201303 1400201304 1400201305 1400201307 1400201308 1400201309 1400201310 1400201311 Abramis brama Cyprinus carpio Cyprinus pellegrini Aaptosyax grypus Abbottina rivularis Acanthalburnus microlepis Tinca tinca Acapoeta tanganicae Alburnus alburnus Alburnus albidus Barbus barbus Barbus meridionalis Barbus canis Barbus aeneus Barbus capensis Barbus haasi Barbus holotaenia Barbus johnstonii Barbus macrotaenia Barbus neumayeri These are just the first few lines to give an idea of the codification. Entire codification is provided through the Excel file 2016_Codelist_final
Coding Systems: Forestry products 0126 0127 0128 0129 0130 0131 0132 0133 0134 0135 0136 0137 0138 0139 0140 0141 0142 0143 0144 0145 0146 0147 0148 0149 0150 0151 0152 Sawlogs+Veneer Logs (C) Pulpwood,Round&Split(C) Pulpwood,Round&Split(NC) Sawlogs+Veneer Logs (NC) Pulpwood+Particles(C) Pulpwood+Particles(NC) Pulpwood,Round&Split Trd Chips and Particles Wood Residues Other Indust Roundwd(C) Other Indust Roundwd Trd Other Indust Roundwd(NC) Wood Fuel(C) Wood Fuel(NC) Wood Fuel Trd Sawnwood (C) Sawnwood (NC) Veneer Sheets Plywood Particle Board Hardboard MDF Fibreboard, Compressed Insulating Board Ind Rwd Wir (C) Ind Rwd Wir (NC) Tropica Ind Rwd Wir (NC) Other code 0101 0102 0103 0104 0105 0106 0107 0108 0109 0110 0111 0112 0113 0114 0115 0116 0117 0118 0119 0120 0121 0122 0123 0124 0125 product Recovered Fibre Pulp Uncoated Mechanical Uncoated Woodfree Coated Papers Case Materials Folding Boxboard Wrapping Papers Other Papers Packaging Wood Charcoal Mechanical Wood Pulp Semi-Chemical Wood Pulp Chemical Wood Pulp Unbleached Sulphite Pulp Bleached Sulphite Pulp Unbleached Sulphate Pulp Bleached Sulphate Pulp Dissolving Wood Pulp Other Fibre Pulp Recovered Paper Newsprint Printing+Writing Paper Other Paper+Paperboard Household+Sanitary Paper Wrapg+Packg Paper+Board Paper+Paperboard NES
Coding Systems: Forestry trees Code 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 English name Sapodilla Hardy Kiwifruit Kiwifruit False Cardamom Candle nut Native Ginger Ananas Custard Apple Cherimoya Soursop Soncoya Poshte Sugar Apple/Sweetsop Bunya Nut Jakfruit Asparagus Latin name Achras sapota Actinidia arguta Actinidia deliciosa Aframomum angustifolium Aleurites moluccana Alpinia caerulea Ananas comosus Annona atemoya Annona cherimoya Annona muricata Annona purpurea Annona scleroderma Annona squamosa Araucaria bidwillii Artocarpus integrifolia Asparagus officinalis These are just the first few lines to give an idea of the codification. Entire codification is provided through the Excel file 2016_Codelist_final
Coding Systems: Attributes DAC: Sector DAC 5 CODE DESCRIPTION 110 111 112 113 114 120 121 122 130 140 150 151 152 160 210 230 240 250 310 311 EDUCATION Education, level unspecified Basic education Secondary education Post-secondary education HEALTH Health, general Basic health POPULATION POLICIES/PROGRAMMES AND REPRODUCTIVE HEALTH WATER SUPPLY AND SANITATION GOVERNMENT AND CIVIL SOCIETY Government and civil society, general Conflict prevention and resolution, peace and security OTHER SOCIAL INFRASTRUCTURE AND SERVICES TRANSPORT AND STORAGE ENERGY GENERATION AND SUPPLY BANKING AND FINANCIAL SERVICES BUSINESS AND OTHER SERVICES AGRICULTURE+FORESTRY+FISHERY AGRICULTURE These are just the first few lines to give an idea of the codification. Entire codification is provided through the Excel file 2016_Codelist_final
Coding Systems: Attributes Gender Agricultural population code 5001 5002 5003 5004 dimensions Female Male Unspecified Total code 6001 6002 6003 6004 dimensions Agricultural Non agricultural Unspecified Total Residence Food code 9001 9002 9003 9004 dimensions code 7001 7002 7003 7004 dimensions Food Rural Non Food Urban Unspecified Unspecified Total Total
Coding Systems: Attributes Field management code 8001 8002 8003 8004 8005 8006 8007 8008 8009 8010 dimensions Rainfed Irrigated Cultivated Cultivated and irrigated Natural Growth Organic Certified organic In conversion to organic Unspecified Total
Coding Systems: FLAGS FLAGS e = Estimated value c = Calculated value (through a formula) FLAG AUTOMATICALLY GENERETED BY THE SYSTEM m = Missing data / Data not existing Missing data (data exist but were not collected) / Data do not even hypothetically exist m DATA SHOULD NOT BE ENTERED IN THE SYSTEM BECAUSE IT WILL BE AUTOMATICALLY GENERATED BY THE SYSTEM WHENEVER NEEDED
Country-specific Coding Systems If a country has its own specific Coding System, it can be added to the CountrySTAT/FENIX list The CountrySTAT/FENIX team is working on the conversion tool to allow automatic conversion between different Coding Systems the country will be responsible for matching its coding systems with the existing ones
