Differences

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

--- the_capri_data_base [2021/12/14 14:09] – [Annex: Code lists for the COCO database] himics
+++ the_capri_data_base [2022/01/17 09:32] – [Annex: Testing procedure and checking intermediate steps in COCO (biofuels)] matsz
@@ Line 172: / Line 172: @@
   * //‘eurostat_ econfinc_mapping.gms’// for the tables from Eurostat’s “Economy and Finance” Statistics
-Example from file //‘Eurostat _agriculture_mapping.gms’//
+Example from file //‘Eurostat _agriculture_mapping.gms’//. 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.
+<html>
+<head>
+<META http-equiv=Content-Type content="text/html; charset=UTF-8">
+<title>Exported from Notepad++</title>
+<style type="text/css">
+span {
+	font-family: 'Consolas';
+	font-size: 9pt;
+	color: #000000;
+}
+.sc0 {
+}
+.sc9 {
+	font-weight: bold;
+	color: #0000FF;
+}
+.sc12 {
+	font-weight: bold;
+	color: #6600CC;
+}
+.sc13 {
+	font-weight: bold;
+	color: #6600CC;
+}
+.sc16 {
+	color: #880000;
+}
+.sc24 {
+}
+</style>
+</head>
+<body>
+<div style="float: left; white-space: pre; line-height: 1; background: #FFFFFF; "><span class="sc9">SET</span><span class="sc24"> </span><span class="sc0">EcoActMAP</span><span class="sc13">(</span><span class="sc0">ASS_COLS</span><span class="sc12">,</span><span class="sc0">ASS_ROWS</span><span class="sc12">,</span><span class="sc0">eco_act_ori_eurostat</span><span class="sc13">)</span><span class="sc24"> </span><span class="sc16">"mapping"</span><span class="sc24"> </span><span class="sc12">/</span><span class="sc24">
+ </span><span class="sc0">EAAP.CERE.</span><span class="sc24"> </span><span class="sc0">aact_eaa01_01000_PROD_PP_MIO_EUR</span><span class="sc24">
+ </span><span class="sc0">EAAP.SWHE.</span><span class="sc24"> </span><span class="sc0">aact_eaa01_01110_PROD_PP_MIO_EUR</span><span class="sc24">
+ </span><span class="sc0">EAAP.DWHE.</span><span class="sc24"> </span><span class="sc0">aact_eaa01_01120_PROD_PP_MIO_EUR</span><span class="sc24"> </span><span class="sc12">/;</span><span class="sc24">
+</span><span class="sc9">SET</span><span class="sc24"> </span><span class="sc0">AgriProdMAP</span><span class="sc13">(</span><span class="sc0">ASS_COLS</span><span class="sc12">,</span><span class="sc0">ASS_ROWS</span><span class="sc12">,</span><span class="sc0">agri_prod_ori_eurostat</span><span class="sc13">)</span><span class="sc24"> </span><span class="sc16">"mapping"</span><span class="sc24"> </span><span class="sc12">/</span><span class="sc24">
+</span><span class="sc0">CERE.LEVL.</span><span class="sc13">(</span><span class="sc24"> </span><span class="sc0">apro_cpnh1_C1000_AR</span><span class="sc12">,</span><span class="sc0">apro_cpnh1_h_C1000_AR</span><span class="sc13">)</span><span class="sc24">
+</span><span class="sc0">SWHE.LEVL.</span><span class="sc13">(</span><span class="sc24"> </span><span class="sc0">apro_cpnh1_C1110_AR</span><span class="sc12">,</span><span class="sc0">apro_cpnh1_h_C1110_AR</span><span class="sc13">)</span><span class="sc24">
+</span><span class="sc0">SWH1.LEVL.</span><span class="sc13">(</span><span class="sc24"> </span><span class="sc0">apro_cpnh1_C1111_AR</span><span class="sc12">,</span><span class="sc0">apro_cpnh1_h_C1111_AR</span><span class="sc13">)</span><span class="sc24"> </span><span class="sc12">/;</span><span class="sc24">
+</span></div></body>
+</html>
-<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.
 === Western Balkan Countries and Turkey ===
@@ Line 1267: / Line 1304: @@
+** Table: Codes of land use classes (Set LandUse)**
+^Code  ^Label  ^
+| OART | artificial |
+| ARAO | (other) arable crops - all arable crops excluding rice and fallow (see also definition of ARAC below) |
+| PARI | paddy rice (already defined) |
+| GRAT | temporary grassland (alternative code used for CORINE data, definition identical to TGRA |
+| FRCT | fruit and citrus |
+| OLIVGR | Olive Groves |
+| VINY | vineyard (already defined) |
+| NUPC | nursery and permanent crops (Note: the aggregate PERM also includes flowers and other vegetables |
+| BLWO | board leaved wood |
+| COWO | coniferous wood |
+| MIWO | mixed wood |
+| POEU | plantations (wood) and eucalyptus |
+| SHRUNTC | shrub land - no tree cover |
+| SHRUTC | shrub land - tree cover |
+| GRANTC | Grassland - no tree cover |
+| GRATC | Grassland - tree cover |
+| FALL | fallow land (already defined) |
+| OSPA | other sparsely vegetated or bare |
+| INLW | inland waters |
+| MARW | marine waters |
+| KITC | kitchen garden |
+** Table: Codes of land use aggregates (Set LandUseAgg)**
+^Code  ^Label  ^
+| OLND | other land - shrub, sparsely vegetated or bare |
+| ARAC | arable crops |
+| FRUN | fruits, nursery and (other) permanent crops |
+| WATER | inland or marine waters |
+| ARTIF | artificial - buildings or roads |
+| OWL | other wooded land - shrub or grassland with tree cover (definition to be discussed) |
+| TWL | total wooded land - forest + other wooded land |
+| SHRU | shrub land |
+| FORE | forest (already defined) |
+| GRAS | grassland (already defined) |
+| ARAB | arable (already defined) |
+| PERM | permanent crops (already defined) |
+| UAAR | utilizable agricultural area (already defined) |
+| ARTO | total area - total land and inland waters |
+| ARTM | total area including marine waters |
+| CROP | crop area - arable and permanent |
+**Table: Codes of mutually exclusive subset adding up to total area - ARTO (Set LandUseARTO)**
+^Code  ^Label  ^
+| OLND | other land - shrub, sparsely vegetated or bare |
+| ARTIF | artificial - buildings or roads |
+| FORE | forest |
+| UAAR | utilizable agricultural area |
+| INLW | Inland waters |
 ====Annex: Detailed description of Eurostat data processing in COCO (coco1_eurostat.gms)====
@@ Line 1326: / Line 1415: @@
 The following example is a walk-through on the typical data processing steps, covring biofuels data preparation in France.
-The reporting file 'C:\Users\himics\c\dairybiof\output\results\coco\biof_data_with_prep\chk_biof_data_with_prep_FR000000.gdx' reports on the data preparation for biofuels for France (FR000) in COCO1. The file includes the set ‘meta_prepare_biofuel_data’, with meta-information on the recent coco1 run (e.g. creation date of file, GAMS version used).
+The reporting file 'output/results/coco/biof_data_with_prep/chk_biof_data_with_prep_FR000000.gdx' reports on the data preparation for biofuels for France (FR000) in COCO1. The file includes the set ‘meta_prepare_biofuel_data’, with meta-information on the recent coco1 run (e.g. creation date of file, GAMS version used).
 {{coco_biof_1.png?nolink|}}
@@ Line 1347: / Line 1436: @@
 | MAPRagr | Ethanol production from agricultural sources |
 | EloBio | Biofuel production and demand data from DG Energy project EloBio |
-| DG\_Agri | Ethanol data from DGAgri website and supplementary files |
+| DG_Agri | Ethanol data from DGAgri website and supplementary files |
 | ProdCom | Eurostat: PRODCOM ANNUAL SOLD (NACE Rev. 2.) [DS-066341] |
 | EIA | Independent Statistics &amp; Analysis, US Energy Information Administration |
 | comext | Eurostat: Comext |
-| Energy\_bal | Eurostat: Supply, transformation, consumption - renewable energies - annual data [nrg\_107a] |
+| Energy_bal | Eurostat: Supply, transformation, consumption - renewable energies - annual data [nrg_107a] |
-| Energy\_dem | Eurostat: Supply, transformation, consumption - renewable energies - annual data [nrg\_102a, nrg\_1073a] |
+| Energy_dem | Eurostat: Supply, transformation, consumption - renewable energies - annual data [nrg_102a, nrg_1073a] |
 | final | results of the calculations |
 | ODOM | other domestic use (activity from biostock calculations |
@@ Line 1445: / Line 1534: @@
 Under activity dairy cows (DCOW) the following items are reported: yield, total production (GROF), feed use (FEDM) and losses on market (LOSM). Eurostat’s //National Accounts of Agriculture (EAA)// only supply data for the aggregate milk (MILK). The equation //e_EAAMLK// in the consolidation model //AnimNSSQ// ensures the consistency of EAA values for MILK, as they are split up between cow milk (COMI) and sheep and goat milk (SGMI).
-<code gams>
+<code fortran>
 e_EAAMLK("%MS%000",T)
      $ (p_NobsP("%MS%000","EAAP","MILK") AND ESTR("MILK") and