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/11/07 10:23] (current) – external edit 127.0.0.1
@@ 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.
-<file gams Eurostat _agriculture_mapping.gms>
+<code fortran>
+SET EcoActMAP(ASS_COLS,ASS_ROWS,eco_act_ori_eurostat) "mapping" /
+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 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.
+SET AgriProdMAP(ASS_COLS,ASS_ROWS,agri_prod_ori_eurostat) "mapping" /
+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) /;
+</code>
 === Western Balkan Countries and Turkey ===
@@ Line 209: / Line 207: @@
 === Other additional input data ===
-COCO1: Biofuels
+COCO1: Biofuels FIXME (most links are not working anymore, remove or re-link)
   * Production, market balance and feedstock quantities for biodiesel and bioethanol are collected from a multitude of sources:
@@ Line 1267: / Line 1265: @@
+** 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 1324: / Line 1374: @@
 The COCO module produces various reporting files on the intermediate data processing steps. These files can be used to trace back potential errors in the COCO database to their origin. These debugging files also contain meta-information on the input data and settings used for producing the COCO database.
-The following example is a walk-through on the typical data processing steps, covring biofuels data preparation in France.
+The following example is a walk-through on the typical data processing steps, covering 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 1397: @@
 | 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 |
-| APRagr | Ethanol production from agricultural sources |
 | INDt | Sum of model results for BIOF and INDM |
 | BIOi, INDi, DOMi | intermediate activities to save data from model initialisation for later documentation. |
@@ Line 1393: / Line 1442: @@
 {{coco_biof_6.png?nolink|}}
-The parameter //p_biofDataMS// reports on production (MAPR), trade (import:IMPT, export:EXPT), production from non-agricultural sources (NAGR), prices (UVAD, UVAP) and consumer taxes (CTAX). The distribiutio of total biodiesel processing to the feedstock is also reported, for rapeseed oil (RAPO), sunflower oil (SUNO), soya oil (SOYO) and palm oil (PLMO).
+The parameter //p_biofDataMS// reports on production (MAPR), trade (import:IMPT, export:EXPT), production from non-agricultural sources (NAGR), prices (UVAD, UVAP) and consumer taxes (CTAX). The distribiution of total biodiesel processing to the feedstock is also reported, for rapeseed oil (RAPO), sunflower oil (SUNO), soya oil (SOYO) and palm oil (PLMO).
@@ Line 1445: / Line 1494: @@
 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