Differences

This shows you the differences between two versions of the page.

--- the_capri_data_base [2020/08/02 08:07] – [Input allocation for fertilisers and nutrient balances] matsz
+++ the_capri_data_base [2021/12/13 11:11] – [Data Import] himics
@@ Line 135: / Line 135: @@
 ** Table 4: Temporal coverage of national data by region **
 ^ Member State ^ Range ^
-| EU15 Member States without Germany | 1984 – 2014 |
+| EU15 Member States without Germany | 1984 – 2018/2019 |
-| Germany and (12) New Member States | 1989 – 2014 |
+| Germany and (12) New Member States | 1989 – 2018/2019 |
-| Western Balkan (WB) Countries and Turkey | 1995 – 2014 |
+| Western Balkan (WB) Countries and Turkey | 1995 – 2018/2019 |
-| Norway | 1984 – 2014 |
+| Norway | 1984 – 2017 |
 === Eurostat data ===
@@ Line 164: / Line 164: @@
 ** Second step: data selection and code mapping **
 The second step is data selection and code mapping performed by the GAMS program //‘coco_input.gms’.// Cross sets linking Eurostat codes to COCO codes define the subset of data series subsequently used.
@@ Line 173: / Line 174: @@
 Example from file //‘Eurostat _agriculture_mapping.gms’//
-| SET AgriProdOriEurostat / \\ apro_acs_a_C1000_AR "CEREALS-EXCLUDING RICE-AREA"\\ apro_acs_a_C1110_AR "COMMON WHEAT AND SPELT - AREA" \\ \\ SET AgriProd_MAP(ASS_COLS,ASS_ROWS,AgriProdOriEurostat) / \\ CERE.LEVL. apro_acs_a_C1000_AR \\ SWHE.LEVL. apro_acs_a_C1110_AR |
+<file gams Eurostat _agriculture_mapping.gms>
+SET EcoActMAP(ASS_COLS,ASS_ROWS,eco_act_ori_eurostat)/
+ 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 AgriProdMAP(ASS_COLS,ASS_ROWS,agri_prod_ori_eurostat)/
+CERE.LEVL.( apro_cpnh1_C1000_AR,apro_cpnh1_h_C1000_AR)
+SWHE.LEVL.( apro_cpnh1_C1110_AR,apro_cpnh1_h_C1110_AR)
+SWH1.LEVL.( apro_cpnh1_C1111_AR,apro_cpnh1_h_C1111_AR)
+</file>
 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.
@@ Line 1964: / Line 1977: @@
 |  Region  |  crop or aggregate  |  Econometric estimation  |||  HPD solution including  |||
-|:::| |  regional  |  national- \\ including yield  |  national - \\ without yield  |  regional, \\ national, crop \\ aggregates  |  + expert assumption  |  + regional \\ labour supply  |
+|:::| |  regional  |  national- including yield  |  national - without yield  |  regional, national, crop  aggregates  |  + expert assumption  |  + regional labour supply  |
 |Belgium (BL24)|Soft wheat|	31.49|	31.26|	31.49|	24.99|	32.73|	53.88|
 |:::|Sugar beet	|  76.25|	77.39|	76.25|	62.19|	48.27|	68.36|