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 [2020/08/02 07:04] – [Overview and data requirements for the national scale] matsz | the_capri_data_base [2021/12/13 13:40] – [COCO2: Final completions] himics | ||
---|---|---|---|
Line 135: | Line 135: | ||
** Table 4: Temporal coverage of national data by region ** | ** Table 4: Temporal coverage of national data by region ** | ||
^ Member State ^ Range ^ | ^ Member State ^ Range ^ | ||
- | | EU15 Member States without Germany | 1984 – 2014 | | + | | EU15 Member States without Germany | 1984 – 2018/ |
- | | Germany and (12) New Member States | 1989 – 2014 | | + | | Germany and (12) New Member States | 1989 – 2018/ |
- | | Western Balkan (WB) Countries and Turkey | 1995 – 2014 | | + | | Western Balkan (WB) Countries and Turkey | 1995 – 2018/ |
- | | Norway | 1984 – 2014 | | + | | Norway | 1984 – 2017 | |
=== Eurostat data === | === Eurostat data === | ||
Line 164: | Line 164: | ||
** Second step: data selection and code mapping ** | ** Second step: data selection and code mapping ** | ||
+ | |||
The second step is data selection and code mapping performed by the GAMS program // | The second step is data selection and code mapping performed by the GAMS program // | ||
Line 173: | Line 174: | ||
Example from file // | Example from file // | ||
- | | SET AgriProdOriEurostat | + | <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/ | The results of the program run are gdx-files loaded by files (e.g. coco/ | ||
Line 1018: | Line 1031: | ||
After this last include file the completions in module COCO2 are finished and the main output file (coco2_output.gdx) is unloaded. This file is loaded in subsequent modules (main use in CAPREG, but also in CAPTRD for nowcasting and in CAPMOD for update of LULUCF coefficients). | After this last include file the completions in module COCO2 are finished and the main output file (coco2_output.gdx) is unloaded. This file is loaded in subsequent modules (main use in CAPREG, but also in CAPTRD for nowcasting and in CAPMOD for update of LULUCF coefficients). | ||
+ | |||
+ | |||
+ | |||
+ | ====Code lists for the COCO database==== | ||
+ | |||
+ | This section includes detailed code lists, which are in use in the COCO database. | ||
+ | |||
+ | **Table: Codes used for storing the original REGIO tables in the database and their description (rows)** | ||
+ | |||
+ | ^ Codes used in CAPRI REGIO tables ^ Original REGIO description ^ | ||
+ | | TOTL | Territorial area | | ||
+ | | FORE | Forest land | | ||
+ | | AGRI | Utilized agricultural area | | ||
+ | | GARD | Private gardens | | ||
+ | | GRAS | Permanent grassland | | ||
+ | | PERM | Permanent crops | | ||
+ | | VINE | Vineyards | | ||
+ | | OLIV | Olive plantations | | ||
+ | | ARAB | Arable land | | ||
+ | | GREF | Green fodder on arable land | | ||
+ | | CERE | Cereals (including rice) | | ||
+ | | WHEA | Soft and durum wheat and spelt | | ||
+ | | BARL | Barley | | ||
+ | | MAIZ | Grain maize | | ||
+ | | RICE | Rice | | ||
+ | | POTA | Potatoes | | ||
+ | | SUGA | Sugar beet | | ||
+ | | OILS | Oilseeds (total) | | ||
+ | | RAPE | Rape | | ||
+ | | SUNF | Sunflower | | ||
+ | | TOBA | Tobacco | | ||
+ | | MAIF | Fodder maize | | ||
+ | | CATT | Cattle (total) | | ||
+ | | COWT | Cows (total) | | ||
+ | | DCOW | Dairy cows | | ||
+ | | CALV | Other cows | | ||
+ | | CAT1 | Total cattle under one year | | ||
+ | | CALF | Slaughter calves | | ||
+ | | CABM | Male breeding calves (\<1 year) | | ||
+ | | CABF | Female breeding calves (\<1 year) | | ||
+ | | BUL2 | Male cattle (1-2 years) | | ||
+ | | H2SL | Slaughter heifers (1-2 years) | | ||
+ | | H2BR | Female cattle (1-2 years) | | ||
+ | | BUL3 | Male cattle (2 years and above) | | ||
+ | | H3SL | Slaughter heifers (2 years and above) | | ||
+ | | H3BR | Breeding heifers | | ||
+ | | BUFF | Total buffaloes | | ||
+ | | PIGS | Total pigs (total) | | ||
+ | | PIG1 | Piglets under 20 kg | | ||
+ | | PIG2 | Piglets under 50 kg and over 20 kg | | ||
+ | | PIG3 | Fattening pigs over 50 kg | | ||
+ | | BOAR | Breeding boars | | ||
+ | | SOW2 | Total breeding sows | | ||
+ | | SOW1 | Sows having farrowed | | ||
+ | | GILT | Gilts having farrowed for the first time | | ||
+ | | SOWM | Maiden sows | | ||
+ | | GILM | Maiden gilts | | ||
+ | | SHEP | Sheep total) | | ||
+ | | GOAT | Goats (total) | | ||
+ | | EUQI | Equidae (total) | | ||
+ | | POUL | Poultry (total) | | ||
+ | | OUTP | Final production | | ||
+ | | CROP | Total crops production | | ||
+ | | DWHE | Durum wheat | | ||
+ | | PULS | Pulses | | ||
+ | | ROOT | Roots and tubers | | ||
+ | | INDU | Industrial crops | | ||
+ | | TEXT | Textile fibre plants | | ||
+ | | HOPS | Hops | | ||
+ | | VEGE | Fresh vegetables | | ||
+ | | TOMA | Tomatoes | | ||
+ | | CAUL | Cauliflowers | | ||
+ | | FRUI | Fresh fruit | | ||
+ | | APPL | Apples | | ||
+ | | PEAR | Pears | | ||
+ | | PEAC | Peaches | | ||
+ | | CITR | Citrus fruit (total) | | ||
+ | | ORAN | Oranges | | ||
+ | | LEMN | Lemons | | ||
+ | | MAND | Mandarins | | ||
+ | | GRAP | Table grapes | | ||
+ | | WINE | Wine | | ||
+ | | TABO | Table olives | | ||
+ | | OLIO | Olive oil | | ||
+ | | NURS | Nursery plants | | ||
+ | | FLOW | Flowers and ornamental plants | | ||
+ | | OCRO | Other crops | | ||
+ | | ANIT | Total animal production | | ||
+ | | ANIM | Animal | | ||
+ | | SHGO | Sheep and goats | | ||
+ | | ANIP | Animal products | | ||
+ | | MILK | Milk | | ||
+ | | EGGS | Eggs | | ||
+ | | INPU | Intermediate consumption (total) | | ||
+ | | FEED | Animal feeding stuffs | | ||
+ | | FDGR | Animal compounds for grazing livestock | | ||
+ | | FDPI | Animal compounds for pigs | | ||
+ | | FDPO | Animal compounds for poultry | | ||
+ | | FODD | Straight feeding stuffs | | ||
+ | | FERT | Fertilizers and enrichments | | ||
+ | | ENER | Energy and lubricants | | ||
+ | | INPO | Other inputs | | ||
+ | | GVAM | Gross value added at market prices | | ||
+ | | SUBS | Subsidies | | ||
+ | | TAXS | Taxes linked to production (including VAT balance) | | ||
+ | | GVAF | Gross value added at factor costs | | ||
+ | | DEPM | Depreciation | | ||
+ | | LABO | Compensation and social security contributions of employees | | ||
+ | | RENT | Rent and other payments | | ||
+ | | INTE | Interests | | ||
+ | | GFCF | Total of gross fixed capital formation | | ||
+ | | BUIL | Buildings and other structures | | ||
+ | | MACH | Transport equipment and machinery | | ||
+ | | GFCO | Other gross fixed capital formation | | ||
===== The Regionalised Data Base (CAPREG) ===== | ===== The Regionalised Data Base (CAPREG) ===== | ||
Line 1699: | Line 1826: | ||
| **Ex-post** | | **Ex-post** | ||
- | |**Given:**\\ -Herd sizes\\ | + | |**Given: |
+ | |-Herd sizes|-Herd sizes| | ||
+ | | => Manure output|=> manure output| | ||
+ | |-Crop areas and yields|-Crop areas and yields| | ||
+ | |=> Export with harvest|=> Export with harvest| | ||
+ | |-National anorganic application|-National and Regional anorganic application| | ||
+ | |**Estimated: | ||
+ | |-Regional anorganic application|-Factor for Fertilization beyond export (trended)| | ||
+ | |-Factor for Fertilization beyond N export|-Manure availability (trended)| | ||
+ | |-Manure availability| | ||
A good overview on how the Nitrogen balances are constructed and can be used for analysis can be found in: Leip A., Britz W., de Vries W. and Weiss F. (2011): Farm, land, and soil nitrogen budgets for agriculture in Europe calculated with CAPRI, Environmental Pollution 159(11), 3243-3253 and Leip, A., Weiss, F. and Britz, W. (2011): Agri-Environmental Nitrogen Indicators for EU27, in: Flichman G. (ed.), Bio-Economic Models applied to Agricultural Systems, p. 109-124, Springer, Netherlands. | A good overview on how the Nitrogen balances are constructed and can be used for analysis can be found in: Leip A., Britz W., de Vries W. and Weiss F. (2011): Farm, land, and soil nitrogen budgets for agriculture in Europe calculated with CAPRI, Environmental Pollution 159(11), 3243-3253 and Leip, A., Weiss, F. and Britz, W. (2011): Agri-Environmental Nitrogen Indicators for EU27, in: Flichman G. (ed.), Bio-Economic Models applied to Agricultural Systems, p. 109-124, Springer, Netherlands. | ||
Line 1869: | Line 2005: | ||
|::: | |::: | ||
|::: |Rice production|CH4Ric| | |::: |Rice production|CH4Ric| | ||
- | |::: |Land use change emissions from\\ biomass burning|CH4bur| | + | |::: |Land use change emissions from biomass burning|CH4bur| |
|**Nitrous Oxide**|Manure management|N2OMan| | |**Nitrous Oxide**|Manure management|N2OMan| | ||
|::: | |::: | ||
Line 1875: | Line 2011: | ||
|::: | |::: | ||
|::: |Crop residues|N2OCro| | |::: |Crop residues|N2OCro| | ||
- | |::: | + | |::: |
- | |::: | + | |::: |
|::: | |::: | ||
- | |::: |Land use change emissions from the \\ burning of biomass|N2Obur| | + | |::: |Land use change emissions from the burning of biomass|N2Obur| |
|**Carbon dioxide**|Cultivation of histosols|CO2his| | |**Carbon dioxide**|Cultivation of histosols|CO2his| | ||
|::: | |::: | ||
|::: | |::: | ||
- | |::: |Land use change emissions from above \\ and below ground biomass|CO2bio| | + | |::: |Land use change emissions from above and below ground biomass|CO2bio| |
- | |::: |Land use change emissions from soil \\ carbon changes|CO2soi| \\ Source: CAPRI Modelling System | + | |::: |Land use change emissions from soil carbon changes|CO2soi| \\ Source: CAPRI Modelling System |
For a detailed analysis of these single emission sources refer to Pérez 2006: Greenhouse Gases: Inventories, | For a detailed analysis of these single emission sources refer to Pérez 2006: Greenhouse Gases: Inventories, | ||
Line 1955: | Line 2091: | ||
| Region | | Region | ||
- | |:::| | regional | + | |:::| | regional |
|Belgium (BL24)|Soft wheat| 31.49| 31.26| 31.49| 24.99| 32.73| 53.88| | |Belgium (BL24)|Soft wheat| 31.49| 31.26| 31.49| 24.99| 32.73| 53.88| | ||
|:::|Sugar beet | | |:::|Sugar beet | |
the_capri_data_base.txt · Last modified: 2022/11/07 10:23 by 127.0.0.1