the_capri_data_base
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| the_capri_data_base [2022/01/11 16:40] – [Annex: Testing procedure and checking intermediate steps in COCO (dairy)] gocht | the_capri_data_base [2026/03/13 13:20] (current) – add herd dynamics (Anna) massfeller | ||
|---|---|---|---|
| Line 174: | Line 174: | ||
| Example from file // | Example from file // | ||
| - | + | <code fortran> | |
| - | <html> | + | SET EcoActMAP(ASS_COLS, |
| - | < | + | EAAP.CERE. aact_eaa01_01000_PROD_PP_MIO_EUR |
| - | <META http-equiv=Content-Type content=" | + | EAAP.SWHE. aact_eaa01_01110_PROD_PP_MIO_EUR |
| - | < | + | EAAP.DWHE. aact_eaa01_01120_PROD_PP_MIO_EUR /; |
| - | <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=" | + | |
| - | </ | + | |
| - | </ | + | |
| - | </ | + | |
| - | + | ||
| - | + | ||
| - | + | ||
| - | </ | + | |
| - | </ | + | |
| - | </ | + | |
| - | </ | + | |
| - | + | ||
| - | </ | + | |
| - | </ | + | |
| - | + | ||
| + | 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 246: | Line 207: | ||
| === Other additional input data === | === Other additional input data === | ||
| - | COCO1: | + | COCO1: |
| * Production, market balance and feedstock quantities for biodiesel and bioethanol are collected from a multitude of sources: | * Production, market balance and feedstock quantities for biodiesel and bioethanol are collected from a multitude of sources: | ||
| Line 1413: | 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 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, | + | The following example is a walk-through on the typical data processing steps, |
| The reporting file ' | The reporting file ' | ||
| Line 1436: | 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 | | ||
| - | | APRagr | Ethanol production from agricultural sources | | ||
| | INDt | Sum of model results for BIOF and INDM | | | INDt | Sum of model results for BIOF and INDM | | ||
| | BIOi, INDi, DOMi | intermediate activities to save data from model initialisation for later documentation. | | | BIOi, INDi, DOMi | intermediate activities to save data from model initialisation for later documentation. | | ||
| Line 1482: | Line 1442: | ||
| {{coco_biof_6.png? | {{coco_biof_6.png? | ||
| - | The parameter // | + | The parameter // |
| Line 1701: | Line 1661: | ||
| To assess the reliability of the CAPRI database in terms of GHG results against official UNFCCC notifications, | To assess the reliability of the CAPRI database in terms of GHG results against official UNFCCC notifications, | ||
| + | |||
| + | ==== Annex: Fertilizer Data used in CAPRI ==== | ||
| + | |||
| + | CAPRI combines time series data on **total fertilizer** quantities at member state level from various sources: | ||
| + | |||
| + | - total fertilizer from Eurostat: consumption of inorganic fertilizers [Eurostat table: aei_fm_usefert] (2000-2020) (“TOTdom”) | ||
| + | - total fertilizer consumption (IFA) (1980-2020) (“TOTifa”) | ||
| + | - total fertilizer from Eurostat: sales of manufactured fertilizers (source: EFMA) [Eurostat table: aei_fm_manfert] (1985-2019) (“TOTdem”) | ||
| + | - total nitrogen consumption from UNFCCC (CRF) (“TOTcrf”) | ||
| + | - total fertilizer from Eurostat: gross nutrient balance [Eurostat table: aei_pr_gnb] (1985-2019) (“TOTgnb”) | ||
| + | |||
| + | From these sources the total fertilizer consumption for use in CAPRI (TOTsel) is selected or computed. The application of fertilizer per crop is scaled to TOTsel, so that the sum over all crops (“TOTapp”) is equal TOTsel, the finally consolidated time series. | ||
| + | |||
| + | In the following the selections process of fertilizer sources are described in more detail: | ||
| + | |||
| + | The preferred and most reliable source of total fertilizer use in CAPRI (TOTsel) for the time period beginning in 2000 is assumed to be Eurostat’s total consumption of inorganic fertilizers (TOTdom). | ||
| + | |||
| + | This source is completed and replaced by total fertilizer consumption of IFA if Eurostat data is not available or does not appear to be sufficiently reliable. Potassium (K20) fertilizer consumption is missing from Eurostat’s TOTdom series for all European countries. Also, total fertilizers for Western Balkan countries apart from Albania are missing and taken over from IFA (TOTifa). | ||
| + | |||
| + | Some exceptions to these general rules: | ||
| + | |||
| + | * In Albania we have the particularity that the potassium series from IFA appeared to be unrealistic. These originally very volatile data were therefore smoothed and interpolated. | ||
| + | * Furthermore, | ||
| + | * Italy’s total fertilizer use is relied on EFMA data (TOTdem), which provides long and reliable time series for all three kinds of fertilizer. | ||
| + | * Potassium for Cyprus from 2011 onwards is taken from TOTdem as TOTifa data shows a high volatility. | ||
| + | |||
| + | Our preferred Eurostat data (TOTdom) start only in 2000 such that a backward extension is necessary for CAPRI. Here the data sources are used hierarchically in the following order for completion: (1) Eurostat-EFMA data (TOTdem), (2) IFA fertilizer data which starts 1980 for several countries (TOTifa), (3) UNFCCC total nitrogen consumption (TOTcrf), and (4) Eurostat gross nutrient balance (TOTgnb). | ||
| + | |||
| + | If a different data source is used for the period before 2000, the conversion to the level of the later data source is carried out based on the relation between this source and TOTsel from the oldest common year. All backward extensions involving this level adjustment are marked “bas” in the table below. | ||
| + | |||
| + | Slovenian' | ||
| + | |||
| + | Final fertilizer sources (TOTsel) applied in CAPRI: | ||
| + | |||
| + | {{table_fertisource.png? | ||
| + | |||
| + | Finally, the fertilizer use per crop is scaled to the total fertilizer use in CAPRI (TOTsel), so that the sum over all crops (TOTapp) is equal to our preferred series TOTsel. | ||
| + | |||
| + | In addition to the total fertilizer time series, CAPRI also uses data on **fertilizer utilization by crop (FUBC).** The following list gives (in a less detailed manner) an overview on the data sources collected and prepared for CAPRI: | ||
| + | |||
| + | - Nonpublic FUBC data from the EFMA forecasting exercise in 2008 (fubc0608 (EFMA)). Data exist for the years 2005, 2006, 2007, 2008, 2012, 2017. The years 2004, 2005 are forecasted by also using EFMA data from 2006 (“FUBCefm”). | ||
| + | - IFA fertilizer data for the 90s (“FUBCifa”) exist for certain European member states, but is missing the Western Balkan Countries apart from Albania as well as Malta, Cyprus, Slovenia, Bulgaria, and Romania. | ||
| + | - Data from a publication in Nature (“FUBCnature”) can be activated for all CAPRI “RMS” regions by setting the global %fert_from_Nature%==ON. The source can be found here: https:// | ||
| + | |||
| + | FUBCefm data is backward extended by using FUBCifa. The use of FUBCnature can optionally be used. In the default setting this data source is not considered. If FUBCnature is activated, the source has priority to the combined source of FUBCefma and FUBCifa. | ||
| + | |||
| + | |||
| + | |||
| ===== Input Allocation ===== | ===== Input Allocation ===== | ||
| Line 1818: | Line 1826: | ||
| |Bull fattening (BULF) |BULL: | |Bull fattening (BULF) |BULL: | ||
| |Heifers fattening (HEIF)| HEIL: | |Heifers fattening (HEIF)| HEIL: | ||
| + | |||
| + | === Implementation of herd dynamics in coding === | ||
| + | |||
| + | The dynamic relationships shown in Fig 3 are implemented in the animal sector specific equations in file coco1_estimA.gms, | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | Equation e_yaniB defines the stock change of all young animal types as the difference between production of young animals and their use to source the flow of slaughtered animals. At the example of piglets ready for fattening or becoming young sows: | ||
| + | |||
| + | Equation 1 | ||
| + | \begin{align} | ||
| + | \text{STCM}_{YPIG}(t) = \text{GROF}_{YPIG}(t) - \text{GROF}_{IPIG}(t) | ||
| + | \end{align} | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | Equation e_stocksA is more complex, because it handles basically 3 different cases. The first is the situation in the non-cattle sectors (pigs, poultry, sheep) where production of young animals by breeding activites (sows, hens, ewes) and their raising is assumed to take place within the current year. Taking into account the mappings in the code, then the equation e_stocksA reads for the case of piglets: | ||
| + | |||
| + | Equation 2 | ||
| + | |||
| + | \begin{align} | ||
| + | & | ||
| + | &= \text{GROF}_{YPIG}(t) - \text{GROF}_{IPIG}(t) | ||
| + | \end{align} | ||
| + | |||
| + | As the input use of piglets only covers their use for slaughtered animals (either fatteners or replacement of old sows), the excess of piglet production and this “replacement” use matches with the change in the size of the breeding stock (sows) in the next year. Conversely, a piglet production falling short of the replacement need (STCMYPIG(t) < 0) means that the sow herd will be lower in the next year. | ||
| + | In the cattle sector raising from calves to the adult animals may extend over several years and is therefore represented with specific raising activities that produce one animal category for the next stage, for example raising of male calves to become young bulls for the final fattening process. In this example (case #2), equation e_stocksA reads for the case of young bulls: | ||
| + | |||
| + | Equation 1 | ||
| + | |||
| + | \begin{align} | ||
| + | & | ||
| + | &= \text{GROF}_{YBUL}(t) - \text{GROF}_{IBUL}(t) | ||
| + | \end{align} | ||
| + | |||
| + | This equation is more intuitive considering that the activity level CAMRLEVL(t) is defined to be equal to the output = production of young bulls GROFYBUL(t) in the current year such that this appear on both sides of the equation, which may be simplified to read: | ||
| + | |||
| + | Equation 1 | ||
| + | |||
| + | \begin{align} | ||
| + | & | ||
| + | & | ||
| + | &\iff \text{CAMR}_{LEVL}(t-1) = \text{GROF}_{IBUL}(t) | ||
| + | \end{align} | ||
| + | |||
| + | In this form the equation just states that the current input use of young bulls (into the fattening activities BULL and BULH) must have been raised from young calves in the previous year such that e_stocksA just ensures this aspect of the herd category linkages in the cattle sector. | ||
| + | The third case handeled by equation e_stocksA is the dynamics for young cows where the equation reads as follows: | ||
| + | |||
| + | Equation 1 | ||
| + | |||
| + | \begin{align} | ||
| + | & | ||
| + | &\quad + \text{COWS}_{LEVL}(t+1) - \text{COWS}_{LEVL}(t) \\ | ||
| + | &= \text{STCM}_{YCOW}(t) \\ | ||
| + | &= \text{GROF}_{YCOW}(t) - \text{GROF}_{ICOW}(t) | ||
| + | \end{align} | ||
| + | |||
| + | Considering again that it holds for the activity level of the raising process that HEIRLEVL(t) = GROFYCOW(t), | ||
| + | |||
| + | Equation 1 | ||
| + | |||
| + | \begin{align} | ||
| + | & | ||
| + | &= \text{GROF}_{YCOW}(t-1) - \text{GROF}_{ICOW}(t) | ||
| + | \end{align} | ||
| + | |||
| + | The change in the total cow herd (DCOW+SCOW) in the next year must be equal to the excess of last year’s production of young cows (thus ready to enter the current cow herd) over the replacement need derived from slaughterings of old cows in the current year. | ||
| + | |||
| ====Input allocation for feed==== | ====Input allocation for feed==== | ||
| Line 2060: | Line 2136: | ||
| * Output of manure at tail –depending on animal type, regional animal population and animal yields, as final weights or milk yields (see section on Output at tail). | * Output of manure at tail –depending on animal type, regional animal population and animal yields, as final weights or milk yields (see section on Output at tail). | ||
| * Manure imports and exports (to the region) | * Manure imports and exports (to the region) | ||
| - | * Input of mineral fertiliser –as given from national statistics at sectoral level. | + | * Input of mineral fertiliser –as given from national statistics at sectoral level. |
| * Input of crop residues, biological fixation, atmospheric deposition | * Input of crop residues, biological fixation, atmospheric deposition | ||
| * Emissions (NH3, NOx, N2, N2O, CO2, CH4, NO3, C from soil erosion) only for nitrogen and carbon, and removals (carbon sequestration) only for carbon | * Emissions (NH3, NOx, N2, N2O, CO2, CH4, NO3, C from soil erosion) only for nitrogen and carbon, and removals (carbon sequestration) only for carbon | ||
the_capri_data_base.1641919236.txt.gz · Last modified: 2022/11/07 10:23 (external edit)