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 13:32] – [Annex: Testing procedure and checking intermediate steps in COCO (dairy)] himics | the_capri_data_base [2022/01/17 09:53] – [Data Import] matsz | ||
---|---|---|---|
Line 172: | Line 172: | ||
* // | * // | ||
- | Example from file // | + | Example from file // |
- | <file gams Eurostat _agriculture_mapping.gms> | + | <code fortran> |
+ | 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 1146: | Line 1144: | ||
| GFCO | Other gross fixed capital formation | | | GFCO | Other gross fixed capital formation | | ||
+ | **Table: Codes used for storing the original REGIO tables in the data base and their description (columns)** | ||
+ | |||
+ | ^ Codes used in CAPRI REGIO tables ^ Original REGIO description ^ | ||
+ | | LEVL | Herd size / Area / # of persons | | ||
+ | | LSUN | Live stock units | | ||
+ | | PROP | Physical production | | ||
+ | | YILD | Yield | | ||
+ | | VALE | EAA position in ECU | | ||
+ | | VALN | EAA position in NC | | ||
+ | |||
+ | **Table: Connection between CAPRI and REGIO crop areas, crop production and herd sizes** | ||
+ | |||
+ | ^ SPEL-code ^ REGIO-code ^ REGIO-code ^ REGIO-code ^ REGIO-code ^ Description of SPEL activity ^ | ||
+ | | SWHE | WHEA | CERE | ARAB | | Soft wheat | | ||
+ | | DWHE | WHEA | CERE | ARAB | | Durum wheat | | ||
+ | | RYE | | CERE | ARAB | | Rye | | ||
+ | | BARL | BARL | CERE | ARAB | | Barley | | ||
+ | | OATS | | CERE | ARAB | | Oats | | ||
+ | | MAIZ | MAIZ | CERE | ARAB | | Maize | | ||
+ | | OCER | | CERE | ARAB | | Other cereals (excl. rice) | | ||
+ | | PARI | RICE | CERE | ARAB | | Paddy rice | | ||
+ | | PULS | | | ARAB | | Pulses | | ||
+ | | POTA | POTA | | ARAB | | Potatoes | | ||
+ | | SUGB | SUGA | | ARAB | | Sugar beet | | ||
+ | | RAPE | RAPE | OILS | ARAB | | Rape and turnip rape | | ||
+ | | SUNF | SUNF | OILS | ARAB | | Sunflower seed | | ||
+ | | SOYA | | OILS | ARAB | | Soya beans | | ||
+ | | OLIV | | OLIV | PERM | | Olives for oil | | ||
+ | | OOIL | | OILS | ARAB | | Other oil seeds and oleaginous fruits | | ||
+ | | FLAX | | | ARAB | | Flax and hemp \*\*\* (faser) \*\*\* | | ||
+ | | TOBA | TOBA | | ARAB | | Tobacco, unmanufactured, | ||
+ | | OIND | | | ARAB | | Other industrial crops | | ||
+ | | CAUL | | | ARAB | | Cauliflowers | | ||
+ | | TOMA | | | ARAB | | Tomatoes | | ||
+ | | OVEG | | | ARAB | | Other vegetables | | ||
+ | | APPL | | | PERM | | Apples, pears and peaches | | ||
+ | | OFRU | | | PERM | | Other fresh fruits | | ||
+ | | CITR | | | PERM | | Citrus fruits | | ||
+ | | TAGR | | VINE | PERM | | Table grapes | | ||
+ | | TABO | | OLIV | PERM | | Table olives | | ||
+ | | TWIN | | VINE | PERM | | Table wine | | ||
+ | | OWIN | | VINE | PERM | | Other wine | | ||
+ | | NURS | | | PERM | | Nursery plants | | ||
+ | | FLOW | | | ARAB | | Flowers, | ||
+ | | OCRO | | | ARAB | | Other final crop products | | ||
+ | | MILK | DCOW | | | | Dairy cows | | ||
+ | | BEEF | BUL2 | BUL3 | | | Bulls fattening | | ||
+ | | CALF | CALF | | | | Calves fattening (old VEAL) | | ||
+ | | PORK | PIG3 | PIG2 | PIG1 | | Pig fattening | | ||
+ | | MUTM | GOAT | SHEP | | | Ewes and goats | | ||
+ | | MUTT | GOAT | SHEP | | | Sheep and goat fattening | | ||
+ | | EGGS | POUL | | | | Laying hens | | ||
+ | | POUL | POUL | | | | Poultry fattening | | ||
+ | | OANI | | | | | Other animals | | ||
+ | | OROO | | | ARAB | | Other root crops | | ||
+ | | GRAS | GRAS | | | | Green fodder | | ||
+ | | SILA | GREF | | ARAB | | Silage | | ||
+ | | CALV | CALV | | | | Suckler cows | | ||
+ | | RCAL | CABM | CABF | | | Calves, raising | | ||
+ | | HEIF | H2SL | H2BR | H3SL | H3BR | Heifers | | ||
+ | | PIGL | SOW2 | | | | Pig breeding | | ||
+ | | FALL | | | FALL | | Fallow land | | ||
+ | |||
+ | **Tables: Codes of the input allocation estimation** | ||
+ | |||
+ | ^FADN inputs (FI) ^Label | ||
+ | | TOIN | total inputs | | ||
+ | | COSA | animal specific inputs | | ||
+ | | FEDG | self grown feedings | | ||
+ | | ANIO | other animal inputs | | ||
+ | | FEDP | purchased feedings | | ||
+ | | COSC | crop specific inputs | | ||
+ | | SEED | seeds | | ||
+ | | PLAP | plant protection | | ||
+ | | FERT | fertilisers | | ||
+ | | TOIX | other inputs (overheads) | | ||
+ | |||
+ | |||
+ | ^CAPRI inputs (CI) used in the reconciliation ^label ^ | ||
+ | | TOIN | total inputs | | ||
+ | | FEED | feedings | | ||
+ | | IPHA | other animal inputs | | ||
+ | | COSC | crop specific inputs | | ||
+ | | SEED | seeds | | ||
+ | | PLAP | plant protection | | ||
+ | | FERT | fertilisers | | ||
+ | | REPA | repairs | | ||
+ | | ENER | energy | | ||
+ | | SERI | agricultural services input | | ||
+ | | INPO | other inputs | | ||
+ | |||
+ | 1. The set of //Other// activities that had been omitted from the econometric estimation: | ||
+ | |||
+ | * OTHER={OCER, | ||
+ | |||
+ | 2. The set of activity groups, and their elements, used in the replacement or missing/ | ||
+ | |||
+ | * GROUPS = {YOUNG, VEGE, SETT, PULS, PIG, OILS, MILK, MEAT, INDS, HORSE, GOAT, FRU, FOD, FLOWER, DENNY, COW, CHICK1, CHICK2, CHICK3, CERE, ARAB} | ||
+ | * YOUNG={YBUL, | ||
+ | * VEGE={TOMA}, | ||
+ | * SETT={SETA, NONF, FALL, GRAS}, | ||
+ | * PULS=PULS | ||
+ | * PIG={PIGF, SOWS}, | ||
+ | * OILS={RAPE, SOYA, SUNF, PARI, OLIV}, | ||
+ | * INDS={TOBA, TEXT, TABO}, | ||
+ | * GOAT={SHGM, SHGF}, | ||
+ | * FRU={APPL, CITR, TAGR, TWIN}, | ||
+ | * FOD={ROOF, MAIF}, | ||
+ | * FLOWER={FLOW, | ||
+ | * DENNY={PORK, | ||
+ | * COW={DCOW, SCOW, HEIF, HEIR, CAMF, CAFF, BULF, CAMR, CAFR}, | ||
+ | * CHICK1={HENS, | ||
+ | * CERE={SWHE, DWHE, BARL, OATS, RYEM, MAIZ}, | ||
+ | * ARAB={POTA, SUGB} | ||
+ | |||
+ | 3. The sets of Northern European, Southern European countries: | ||
+ | |||
+ | * NEUR={NL000, | ||
+ | * SEUR={El000, | ||
+ | |||
+ | |||
+ | ** 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 1203: | 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 1224: | 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 1322: | 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(" | ||
Line 1337: | Line 1510: | ||
{{: | {{: | ||
+ | |||
+ | From the example for COMI above you can also understand the influence of the standard deviation from raw data (e.g. FEDM.StdeData), | ||
+ | |||
+ | The first initialisation of // | ||
+ | |||
+ | |||
+ | |||
+ | **Example 3: data consolidation for cow dairy cow activity (DCOW)** | ||
+ | |||
+ | The procedure of data consolidation and booking intermediate data processing results for the dairy cow activity (DCOW) is demonstrated in the following screenshot. | ||
+ | |||
+ | {{: | ||
+ | |||
+ | The rows of the table show the product item code for the production activity DCOW, and the data processing steps (status). The first two lines show the coco1 results for slaughtering. The items starting with Y and I stand for the output and input of calves. The initialization, | ||
+ | |||
===== The Regionalised Data Base (CAPREG) ===== | ===== The Regionalised Data Base (CAPREG) ===== |
the_capri_data_base.txt · Last modified: 2024/07/05 06:24 by massfeller