the_capri_data_base
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
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:42] – [Data Import] matsz | ||
---|---|---|---|
Line 172: | Line 172: | ||
* // | * // | ||
- | Example from file // | + | Example from file // |
- | <file gams Eurostat _agriculture_mapping.gms> | + | <code> |
+ | SET EcoActMAP(ASS_COLS, | ||
+ | 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, | ||
- | | ||
- | | ||
- | | ||
- | ... | ||
- | SET AgriProdMAP(ASS_COLS, | ||
- | CERE.LEVL.( apro_cpnh1_C1000_AR, | ||
- | SWHE.LEVL.( apro_cpnh1_C1110_AR, | ||
- | SWH1.LEVL.( apro_cpnh1_C1111_AR, | ||
- | </ | ||
- | 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, |
+ | CERE.LEVL.( apro_cpnh1_C1000_AR, | ||
+ | SWHE.LEVL.( apro_cpnh1_C1110_AR, | ||
+ | SWH1.LEVL.( apro_cpnh1_C1111_AR, | ||
+ | </ | ||
=== Western Balkan Countries and Turkey === | === Western Balkan Countries and Turkey === | ||
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)==== | ====Annex: Detailed description of Eurostat data processing in COCO (coco1_eurostat.gms)==== | ||
Line 1326: | Line 1376: | ||
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, covring biofuels data preparation in France. | ||
- | The reporting file 'C: | + | The reporting file ' |
{{coco_biof_1.png? | {{coco_biof_1.png? | ||
Line 1347: | Line 1397: | ||
| MAPRagr | Ethanol production from agricultural sources | | | MAPRagr | Ethanol production from agricultural sources | | ||
| EloBio | Biofuel production and demand data from DG Energy project EloBio | | | EloBio | Biofuel production and demand data from DG Energy project EloBio | | ||
- | | DG\_Agri | + | | DG_Agri |
| ProdCom | Eurostat: PRODCOM ANNUAL SOLD (NACE Rev. 2.) [DS-066341] | | | ProdCom | Eurostat: PRODCOM ANNUAL SOLD (NACE Rev. 2.) [DS-066341] | | ||
| EIA | Independent Statistics & Analysis, US Energy Information Administration | | | EIA | Independent Statistics & Analysis, US Energy Information Administration | | ||
| comext | Eurostat: Comext | | | comext | Eurostat: Comext | | ||
- | | Energy\_bal | + | | Energy_bal |
- | | Energy\_dem | + | | Energy_dem |
| final | results of the calculations | | | final | results of the calculations | | ||
| ODOM | other domestic use (activity from biostock calculations | | | ODOM | other domestic use (activity from biostock calculations | | ||
Line 1445: | Line 1495: | ||
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 // | 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(" | e_EAAMLK(" | ||
$ (p_NobsP(" | $ (p_NobsP(" |
the_capri_data_base.txt · Last modified: 2024/07/05 06:24 by massfeller