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:43] – [Annex: Testing procedure and checking intermediate steps in COCO (dairy)] himics | the_capri_data_base [2022/01/10 11:38] – [Annex: Testing procedure and checking intermediate steps in COCO (biofuels)] matsz | ||
---|---|---|---|
Line 172: | Line 172: | ||
* // | * // | ||
- | Example from file // | + | Example from file // |
+ | |||
+ | |||
+ | < | ||
+ | < | ||
+ | <META http-equiv=Content-Type content=" | ||
+ | < | ||
+ | <style type=" | ||
+ | span { | ||
+ | font-family: | ||
+ | font-size: 9pt; | ||
+ | color: #000000; | ||
+ | } | ||
+ | .sc0 { | ||
+ | } | ||
+ | .sc9 { | ||
+ | font-weight: | ||
+ | color: #0000FF; | ||
+ | } | ||
+ | .sc12 { | ||
+ | font-weight: | ||
+ | color: #6600CC; | ||
+ | } | ||
+ | .sc13 { | ||
+ | font-weight: | ||
+ | color: #6600CC; | ||
+ | } | ||
+ | .sc16 { | ||
+ | color: #880000; | ||
+ | } | ||
+ | .sc24 { | ||
+ | } | ||
+ | </ | ||
+ | </ | ||
+ | < | ||
+ | <div style=" | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | </ | ||
+ | </ | ||
- | <file gams Eurostat _agriculture_mapping.gms> | ||
- | 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/ | ||
=== Western Balkan Countries and Turkey === | === Western Balkan Countries and Turkey === | ||
Line 1146: | Line 1183: | ||
| 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 1415: | ||
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? |
the_capri_data_base.txt · Last modified: 2024/05/31 13:49 by massfeller