Differences

This shows you the differences between two versions of the page.

--- the_capri_data_base [2020/08/02 08:09] – [Input allocation for labour] matsz
+++ the_capri_data_base [2021/12/13 13:40] – [COCO2: Final completions] himics
@@ Line 135: / Line 135: @@
 ** Table 4: Temporal coverage of national data by region **
 ^ Member State ^ Range ^
-| EU15 Member States without Germany | 1984 – 2014 |
+| EU15 Member States without Germany | 1984 – 2018/2019 |
-| Germany and (12) New Member States | 1989 – 2014 |
+| Germany and (12) New Member States | 1989 – 2018/2019 |
-| Western Balkan (WB) Countries and Turkey | 1995 – 2014 |
+| Western Balkan (WB) Countries and Turkey | 1995 – 2018/2019 |
-| Norway | 1984 – 2014 |
+| Norway | 1984 – 2017 |
 === Eurostat data ===
@@ Line 164: / Line 164: @@
 ** Second step: data selection and code mapping **
 The second step is data selection and code mapping performed by the GAMS program //‘coco_input.gms’.// Cross sets linking Eurostat codes to COCO codes define the subset of data series subsequently used.
@@ Line 173: / Line 174: @@
 Example from file //‘Eurostat _agriculture_mapping.gms’//
-| SET AgriProdOriEurostat / \\ apro_acs_a_C1000_AR "CEREALS-EXCLUDING RICE-AREA"\\ apro_acs_a_C1110_AR "COMMON WHEAT AND SPELT - AREA" \\ \\ SET AgriProd_MAP(ASS_COLS,ASS_ROWS,AgriProdOriEurostat) / \\ CERE.LEVL. apro_acs_a_C1000_AR \\ SWHE.LEVL. apro_acs_a_C1110_AR |
+<file gams Eurostat _agriculture_mapping.gms>
+SET EcoActMAP(ASS_COLS,ASS_ROWS,eco_act_ori_eurostat)/
+ EAAP.CERE. aact_eaa01_01000_PROD_PP_MIO_EUR
+ EAAP.SWHE. aact_eaa01_01110_PROD_PP_MIO_EUR
+ EAAP.DWHE. aact_eaa01_01120_PROD_PP_MIO_EUR
+ ...
+SET AgriProdMAP(ASS_COLS,ASS_ROWS,agri_prod_ori_eurostat)/
+CERE.LEVL.( apro_cpnh1_C1000_AR,apro_cpnh1_h_C1000_AR)
+SWHE.LEVL.( apro_cpnh1_C1110_AR,apro_cpnh1_h_C1110_AR)
+SWH1.LEVL.( apro_cpnh1_C1111_AR,apro_cpnh1_h_C1111_AR)
+</file>
 The results of the program run are gdx-files loaded by files (e.g. coco/coco1_eurostat.gms) which are in turn loaded by coco1.gms or coco2.gms.
@@ Line 1018: / Line 1031: @@
 After this last include file the completions in module COCO2 are finished and the main output file (coco2_output.gdx) is unloaded. This file is loaded in subsequent modules (main use in CAPREG, but also in CAPTRD for nowcasting and in CAPMOD for update of LULUCF coefficients).
+====Code lists for the COCO database====
+This section includes detailed code lists, which are in use in the COCO database.
+**Table: Codes used for storing the original REGIO tables in the database and their description (rows)**
+^ Codes used in CAPRI REGIO tables ^ Original REGIO description ^
+| TOTL | Territorial area |
+| FORE | Forest land |
+| AGRI | Utilized agricultural area |
+| GARD | Private gardens |
+| GRAS | Permanent grassland |
+| PERM | Permanent crops |
+| VINE | Vineyards |
+| OLIV | Olive plantations |
+| ARAB | Arable land |
+| GREF | Green fodder on arable land |
+| CERE | Cereals (including rice) |
+| WHEA | Soft and durum wheat and spelt |
+| BARL | Barley |
+| MAIZ | Grain maize |
+| RICE | Rice |
+| POTA | Potatoes |
+| SUGA | Sugar beet |
+| OILS | Oilseeds (total) |
+| RAPE | Rape |
+| SUNF | Sunflower |
+| TOBA | Tobacco |
+| MAIF | Fodder maize |
+| CATT | Cattle (total) |
+| COWT | Cows (total) |
+| DCOW | Dairy cows |
+| CALV | Other cows |
+| CAT1 | Total cattle under one year |
+| CALF | Slaughter calves |
+| CABM | Male breeding calves (\&lt;1 year) |
+| CABF | Female breeding calves (\&lt;1 year) |
+| BUL2 | Male cattle (1-2 years) |
+| H2SL | Slaughter heifers (1-2 years) |
+| H2BR | Female cattle (1-2 years) |
+| BUL3 | Male cattle (2 years and above) |
+| H3SL | Slaughter heifers (2 years and above) |
+| H3BR | Breeding heifers |
+| BUFF | Total buffaloes |
+| PIGS | Total pigs (total) |
+| PIG1 | Piglets under 20 kg |
+| PIG2 | Piglets under 50 kg and over 20 kg |
+| PIG3 | Fattening pigs over 50 kg |
+| BOAR | Breeding boars |
+| SOW2 | Total breeding sows |
+| SOW1 | Sows having farrowed |
+| GILT | Gilts having farrowed for the first time |
+| SOWM | Maiden sows |
+| GILM | Maiden gilts |
+| SHEP | Sheep total) |
+| GOAT | Goats (total) |
+| EUQI | Equidae (total) |
+| POUL | Poultry (total) |
+| OUTP | Final production |
+| CROP | Total crops production |
+| DWHE | Durum wheat |
+| PULS | Pulses |
+| ROOT | Roots and tubers |
+| INDU | Industrial crops |
+| TEXT | Textile fibre plants |
+| HOPS | Hops |
+| VEGE | Fresh vegetables |
+| TOMA | Tomatoes |
+| CAUL | Cauliflowers |
+| FRUI | Fresh fruit |
+| APPL | Apples |
+| PEAR | Pears |
+| PEAC | Peaches |
+| CITR | Citrus fruit (total) |
+| ORAN | Oranges |
+| LEMN | Lemons |
+| MAND | Mandarins |
+| GRAP | Table grapes |
+| WINE | Wine |
+| TABO | Table olives |
+| OLIO | Olive oil |
+| NURS | Nursery plants |
+| FLOW | Flowers and ornamental plants |
+| OCRO | Other crops |
+| ANIT | Total animal production |
+| ANIM | Animal |
+| SHGO | Sheep and goats |
+| ANIP | Animal products |
+| MILK | Milk |
+| EGGS | Eggs |
+| INPU | Intermediate consumption (total) |
+| FEED | Animal feeding stuffs |
+| FDGR | Animal compounds for grazing livestock |
+| FDPI | Animal compounds for pigs |
+| FDPO | Animal compounds for poultry |
+| FODD | Straight feeding stuffs |
+| FERT | Fertilizers and enrichments |
+| ENER | Energy and lubricants |
+| INPO | Other inputs |
+| GVAM | Gross value added at market prices |
+| SUBS | Subsidies |
+| TAXS | Taxes linked to production (including VAT balance) |
+| GVAF | Gross value added at factor costs |
+| DEPM | Depreciation |
+| LABO | Compensation and social security contributions of employees |
+| RENT | Rent and other payments |
+| INTE | Interests |
+| GFCF | Total of gross fixed capital formation |
+| BUIL | Buildings and other structures |
+| MACH | Transport equipment and machinery |
+| GFCO | Other gross fixed capital formation |
 ===== The Regionalised Data Base (CAPREG) =====