the_complete_and_consistent_data_base_coco_for_the_national_scale
Differences
This shows you the differences between two versions of the page.
the_complete_and_consistent_data_base_coco_for_the_national_scale [2020/03/27 07:02] – [COCO1: Overlay from various sources] matsz | the_complete_and_consistent_data_base_coco_for_the_national_scale [2022/11/07 10:23] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 315: | Line 315: | ||
//Fuel prices and taxes// | //Fuel prices and taxes// | ||
- | For a specification of processing-, | + | For a specification of processing-, |
===Assigning data to database array=== | ===Assigning data to database array=== | ||
Line 437: | Line 437: | ||
* To acknowledge that the Corine Classes may be mapped to several LUCAS categories we multiplied them with the “profiles”, | * To acknowledge that the Corine Classes may be mapped to several LUCAS categories we multiplied them with the “profiles”, | ||
* **LEVRegio** - Eurostat regional land use data (Eurostat Table: “agr_r_landuse”, | * **LEVRegio** - Eurostat regional land use data (Eurostat Table: “agr_r_landuse”, | ||
- | * **LEVFAO** - Land use data from the resource FAOSTAT domain((See [[http:// | + | * **LEVFAO** - Land use data from the resource FAOSTAT domain |
* **LEVLucas** – directly using the LUCAS data is an option that has been considered but not implemented in CAPRI so this code is not used at the moment. | * **LEVLucas** – directly using the LUCAS data is an option that has been considered but not implemented in CAPRI so this code is not used at the moment. | ||
* **LEVLandCov** - Eurostat land cover data for 2009, 2012, 2015 at the MS level. Agricultural land is only distinguished into cropland CROP and grassland GRAS, but 5 nonagricultural areas are neatly aggregating up to the total country (Artificial ARTIF, shrubland (considered similar to “other wooded land” OWL), bare land & wetlands (mapped to “other sparcely vegetated or bare OSPA) and waters WATER. | * **LEVLandCov** - Eurostat land cover data for 2009, 2012, 2015 at the MS level. Agricultural land is only distinguished into cropland CROP and grassland GRAS, but 5 nonagricultural areas are neatly aggregating up to the total country (Artificial ARTIF, shrubland (considered similar to “other wooded land” OWL), bare land & wetlands (mapped to “other sparcely vegetated or bare OSPA) and waters WATER. | ||
- | * **LEVEnvio** - Eurostat land cover data from the environment section (Table “env_la_luc1”((Apparently these data are currently under revision because they are not accessible on the Eurostat website anymore since about June 2012. However they are still accessible (in July 2012) via [[http:// | + | * **LEVEnvio** - Eurostat land cover data from the environment section (Table “env_la_luc1” |
* **LEVMcpfe** – Data from the Ministerial Conference on the Protection of Forests in Europe C&I database for quantitative indicators. This gives validated data on the forest sector (forest land FORE, other wooded land OWL) and some non forestry data (inland waters INLW, total country area ARTO), but data were only given for 1990, 2000, 2005, 2010, 2015. | * **LEVMcpfe** – Data from the Ministerial Conference on the Protection of Forests in Europe C&I database for quantitative indicators. This gives validated data on the forest sector (forest land FORE, other wooded land OWL) and some non forestry data (inland waters INLW, total country area ARTO), but data were only given for 1990, 2000, 2005, 2010, 2015. | ||
* **LEVFSS** - Eurostat farm structure survey data (Table “ef_lu_ovcropaa" | * **LEVFSS** - Eurostat farm structure survey data (Table “ef_lu_ovcropaa" | ||
Line 525: | Line 525: | ||
It should be mentioned that the above representation of the COCO objective function is a quite simplified one: It is evident that the above lacks safeguards against division by zero or very small values which are included in the GAMS code. Furthermore there are different types of gaps which are not reflected above to avoid clutter (Are there gaps in a series with some data or is the series empty? Is the mean based on data or estimated from \(y_{i, | It should be mentioned that the above representation of the COCO objective function is a quite simplified one: It is evident that the above lacks safeguards against division by zero or very small values which are included in the GAMS code. Furthermore there are different types of gaps which are not reflected above to avoid clutter (Are there gaps in a series with some data or is the series empty? Is the mean based on data or estimated from \(y_{i, | ||
- | Equation 4 indicates that accountancy restrictions are added. These restrictions can be balances (land, milk contents, young animals), aggregation conditions, definitions for processing coefficients and yields etc. They are quite similar to those applied for the ex ante trend projections as discussed in detail in Section | + | Equation 4 indicates that accountancy restrictions are added. These restrictions can be balances (land, milk contents, young animals), aggregation conditions, definitions for processing coefficients and yields etc. They are quite similar to those applied for the ex ante trend projections as discussed in detail in Section |
{{: | {{: | ||
Line 690: | Line 690: | ||
Where available, producer prices for milk products were already included from Eurostat statistics (Agricultural prices and price indices) in COCO1. Completeness was not achieved in COCO1, however, because processed dairy products are not part of the EAA. Here we complete some gaps using price information for some Member States and (partly assumed) relationships among dairy product prices and their fat and protein contents. | Where available, producer prices for milk products were already included from Eurostat statistics (Agricultural prices and price indices) in COCO1. Completeness was not achieved in COCO1, however, because processed dairy products are not part of the EAA. Here we complete some gaps using price information for some Member States and (partly assumed) relationships among dairy product prices and their fat and protein contents. | ||
- | Data on total consumer expenditures as well as expentitures by food groups are included from various sources as described in Chapter 2.2.2.5, partly extended using general price index information. | + | Data on total consumer expenditures as well as expentitures by food groups are included from various sources as described in Chapter 2.2.2.5 |
Consumer price index weights and price indices for food aggregates (2005=100) are coming from Eurostat tables on HICP. Supplementary information for Albania, Bosnia and Croatia comes from national agencies. The price index weights are used to extend older series on food expenditure by product groups (say “meat”) which have been discontinued (see below under file coco2_shares.gms). | Consumer price index weights and price indices for food aggregates (2005=100) are coming from Eurostat tables on HICP. Supplementary information for Albania, Bosnia and Croatia comes from national agencies. The price index weights are used to extend older series on food expenditure by product groups (say “meat”) which have been discontinued (see below under file coco2_shares.gms). | ||
Line 716: | Line 716: | ||
\begin{align} | \begin{align} | ||
\begin{split} | \begin{split} | ||
- | max_t &- \sum_{m, | + | max_t &- \sum_{m, |
- | & | + | & \cdot PE_{m, |
- | & | + | & |
- | & | + | & \cdot PED_{m, |
- | & | + | & |
- | & | + | & \cdot PEX_{m, |
- | & | + | & |
\end{split} | \end{split} | ||
Line 770: | Line 770: | ||
\begin{equation} | \begin{equation} | ||
- | DCP_{m,j} = \sum_{k\forall_{m, | + | DCP_{m,j} = \sum_{k\forall_{m, |
\end{equation} | \end{equation} | ||
Line 782: | Line 782: | ||
\begin{equation} | \begin{equation} | ||
- | CP_{m,j} = \sum_{k\forall_{m, | + | CP_{m,j} = \sum_{k\forall_{m, |
\end{equation} | \end{equation} | ||
Line 788: | Line 788: | ||
\begin{equation} | \begin{equation} | ||
- | EX_{m, | + | EX_{m, |
\end{equation} | \end{equation} | ||
Line 794: | Line 794: | ||
\begin{equation} | \begin{equation} | ||
- | TOFAC_m=\sum_{k\forall_{m}(TOFAC.LO_m\ge TOFAC.UP_m)} PFAC_{m,k}*TOFACS_m | + | TOFAC_m=\sum_{k\forall_{m}(TOFAC.LO_m\ge TOFAC.UP_m)} PFAC_{m, |
\end{equation} | \end{equation} | ||
Line 800: | Line 800: | ||
\begin{equation} | \begin{equation} | ||
- | \sum_{FOPOS} EX_{m, | + | \sum_{FOPOS} EX_{m, |
\end{equation} | \end{equation} | ||
Line 806: | Line 806: | ||
\begin{equation} | \begin{equation} | ||
- | EX_{m, | + | EX_{m, |
\end{equation} | \end{equation} | ||
Line 824: | Line 824: | ||
* In some cases it is convenient to have the completed COCO1 results of all countries at hand for comparison purposes and in order to achieve a balanced picture across MS. This is the main motive for the assignments of consumer loss rates (Section 3.2.7.1). | * In some cases it is convenient to have the completed COCO1 results of all countries at hand for comparison purposes and in order to achieve a balanced picture across MS. This is the main motive for the assignments of consumer loss rates (Section 3.2.7.1). | ||
- | * Whenever averages of consolidated data (from COCO1) across several or all MS are involved, a solution in a loop requires certain sequence (such as first solving for non-candidate countries to form the averages that are input to candidate countries) or is better solved in a new module like COCO2. This applies to the expenditure allocation problem (Section | + | * Whenever averages of consolidated data (from COCO1) across several or all MS are involved, a solution in a loop requires certain sequence (such as first solving for non-candidate countries to form the averages that are input to candidate countries) or is better solved in a new module like COCO2. This applies to the expenditure allocation problem (Section |
===Assignment of consumer loss rates and nutrient intake per head === | ===Assignment of consumer loss rates and nutrient intake per head === | ||
Line 881: | Line 881: | ||
\begin{split} | \begin{split} | ||
& | & | ||
- | &= min [DAILY_{up}^{HEIF}, | + | & |
\end{split} | \end{split} | ||
\end{align} | \end{align} | ||
Line 889: | Line 889: | ||
\begin{align} | \begin{align} | ||
\begin{split} | \begin{split} | ||
+ | |||
& | & | ||
- | &= min [DAYS_{up}^{HEIF}, | + | &= min \left[ DAYS_{up}^{HEIF}, |
- | & \quad (BEEF_r^{HEIF}/ | + | |
\end{split} | \end{split} | ||
\end{align} | \end{align} | ||
Line 898: | Line 899: | ||
\begin{equation} | \begin{equation} | ||
- | meanWgt_r^{HEIF}=startWgt_{HEIF}+\frac {dailyIncrease_r^{HEIF}\cdot fatngdays_r^{HEIF}} 2 | + | meanWgt_r^{HEIF}=startWgt_{HEIF}+\frac {dailyIncrease_r^{HEIF}\cdot fatngdays_r^{HEIF}} |
\end{equation} | \end{equation} | ||
the_complete_and_consistent_data_base_coco_for_the_national_scale.1585292524.txt.gz · Last modified: 2022/11/07 10:23 (external edit)