User Tools

Site Tools


annex_code_lists

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
annex_code_lists [2020/03/30 11:50]
matsz
annex_code_lists [2020/06/25 17:48] (current)
matsz
Line 1: Line 1:
 ======Annex:​ Code lists====== ======Annex:​ Code lists======
  
-====Table 1: Codes used for storing the original REGIO tables in the data base and their description,​ rows====+**Table 1: Codes used for storing the original REGIO tables in the data base and their description,​ rows**
  
 ^Codes used in CAPRI’s REGIO tables^Original REGIO description^ ^Codes used in CAPRI’s REGIO tables^Original REGIO description^
Line 109: Line 109:
 |GFCO|Other gross fixed capital formation| |GFCO|Other gross fixed capital formation|
  
-====Table 2: Codes used for storing the original REGIO tables in the data base and their description,​ columns====+**Table 2: Codes used for storing the original REGIO tables in the data base and their description,​ columns**
  
 ^Codes used in CAPRI’s REGIO tables ^Original REGIO description^ ^Codes used in CAPRI’s REGIO tables ^Original REGIO description^
Line 119: Line 119:
 |VALN|EAA position in NC| |VALN|EAA position in NC|
  
-====Table 3: Connection between CAPRI and REGIO crop areas, crop production and herd sizes====+**Table 3: 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^ ^SPEL-code ^REGIO-code ^REGIO-code ^REGIO-code ^REGIO-code ^Description of SPEL activity^
Line 172: Line 172:
 |FALL| ​  ​| ​  ​|FALL|  ​  ​|Fallow land| |FALL| ​  ​| ​  ​|FALL|  ​  ​|Fallow land|
  
-====Table 4: List of activities in the supply model====+**Table 4: List of activities in the supply model**
  
 ^Group ^Activity ^Code^ ^Group ^Activity ^Code^
Line 194: Line 194:
 |:::​|Tobacco|TOBA| |:::​|Tobacco|TOBA|
 |:::|Other industrial crops|OIND| |:::|Other industrial crops|OIND|
-|**Vegetables ​\\ +|**Vegetables ​Fruits ​Other perennials**|Tomatoes|TOMA|
-Fruits ​\\ +
-Other perennials**|Tomatoes|TOMA|+
 |:::|Other vegetables|OVEG| |:::|Other vegetables|OVEG|
 |:::​|Apples,​ pear & peaches|APPL| |:::​|Apples,​ pear & peaches|APPL|
Line 230: Line 228:
 |:::|Sheep and goat for milk|SHGM| |:::|Sheep and goat for milk|SHGM|
 |:::|Other animals|OANI| |:::|Other animals|OANI|
 +
 +**Table 5: Output, inputs, income indicators, policy variables and processed products in the data base**
 +
 +^Group ^Item ^Code^ ​
 +|**Outputs**|||
 +|**Cereals**|Soft wheat|SWHE|
 +|:::|Durum wheat|DWHE|
 +|:::|Rye and Meslin|RYEM|
 +|:::​|Barley|BARL|
 +|:::​|Oats|OATS|
 +|:::|Paddy rice|PARI|
 +|:::​|Maize|MAIZ|
 +|:::|Other cereals|OCER|
 +|**Oilseeds**|Rape|RAPE|
 +|:::​|Sunflower|SUNF|
 +|:::​|Soya|SOYA|
 +|:::|Olives for oil|OLIV|
 +|:::|Other oilseeds|OOIL|
 +|**Other annual crops**|Pulses|PULS|
 +|:::​|Potatoes|POTA|
 +|:::|Sugar beet|SUGB|
 +|:::|Flax and hemp|TEXT|
 +|:::​|Tobacco|TOBA|
 +|:::|Other industrial crops|OIND|
 +|**Vegetables & Fruits & Other perennials**|Tomatoes|TOMA|
 +|:::|Other vegetables|OVEG|
 +|:::​|Apples,​ pear & peaches|APPL|
 +|:::|Citrus fruits|CITR|
 +|:::|Other fruits|OFRU|
 +|:::|Table grapes|TAGR|
 +|:::|Table olives|TABO|
 +|:::|Table wine|TWIN|
 +|:::​|Nurseries|NURS|
 +|:::​|Flowers|FLOW|
 +|:::|Other marketable crops|OCRO|
 +|**Fodder**|Gras|GRAS|
 +|:::|Fodder maize|MAIF|
 +|:::|Other fodder from arable land|OFAR|
 +|:::|Fodder root crops|ROOF|
 +|:::​|Straw|STRA|
 +|**Marketable products from animal product**|Milk from cows|COMI|
 +|:::​|Beef|BEEF|
 +|:::|Pork meat|PORK|
 +|:::|Sheep and goat meat|SGMT|
 +|:::|Sheep and goat milk|SGMI|
 +|:::​|Poultry meat|POUM|
 +|:::|Other marketable animal products|OANI|
 +|**Intermediate products from animal production**|Milk from cows for feeding|COMF|
 +|:::|Milk from sheep and goat cows for feeding|SGMF|
 +|:::|Young cows|YCOW|
 +|:::|Young bulls|YBUL|
 +|:::|Young heifers|YHEI|
 +|:::|Young male calves|YCAM|
 +|:::|Young female calves|YCAF|
 +|:::​|Piglets|YPIG|
 +|:::​|Lambs|YLAM|
 +|:::​|Chicken|YCHI|
 +|:::​|Nitrogen from manure|MANN|
 +|:::​|Phosphate from manure|MANP|
 +|:::​|Potassium from manure|MANK|
 +|**Other Output from EAA**|Renting of milk quota |RQUO|
 +|:::​|Agricultural services|SERO|
 +|**Inputs**|||
 +|**Mineral and organic fertiliser &
 +Seed and plant protection**|Nitrogen fertiliser|NITF|
 +|:::​|Phosphate fertiliser|PHOF|
 +|:::​|Potassium fertiliser|POTF|
 +|:::​|Calcium fertiliser|CAOF|
 +|:::​|Seed|SEED|
 +|:::|Plant protection|PLAP|
 +|**Feedings tuff**|Feed cereals|FCER|
 +|:::|Feed rich protein|FPRO|
 +|:::|Feed rich energy|FENE|
 +|:::|Feed based on milk products|FMIL|
 +|:::​|Gras|FGRA|
 +|:::|Fodder maize|FMAI|
 +|:::|Other Feed from arable land|FOFA|
 +|:::|Fodder root crops|FROO|
 +|:::|Feed other|FOTH|
 +|:::​|Straw|FSTRA|
 +|**Young animal & Other animal specific inputs**|Young cow|ICOW|
 +|:::|Young bull|IBUL|
 +|:::|Young heifer|IHEI|
 +|:::|Young male calf|ICAM|
 +|:::|Young female calf|ICAF|
 +|:::​|Piglet|IPIG|
 +|:::​|Lamb|ILAM|
 +|:::​|Chicken|ICHI|
 +|**Pharmaceutical inputs**|IPHA|
 +|**General inputs|Maintennce machinery**|REPM|
 +|:::​|Maintennce buildings|REPB|
 +|:::​|Electricity|ELEC|
 +|:::​|Heating gas and oil|EGAS|
 +|:::​|Fuels|EFUL|
 +|:::​|Lubricants|ELUB|
 +|:::​|Water|WATR|
 +|:::​|Agricultural services input|SERI|
 +|:::|Other inputs|INPO|
 +|**Income indicators**|Production value|TOOU|
 +|:::|Total input costs|TOIN|
 +|:::|Gross value added at producer prices|GVAP|
 +|:::|Gross value added at basic prices|GVAB|
 +|:::|Gross value added at market prices plus CAP premiums|MGVA|
 +|**Activity level**|Cropped area, slaughtered heads or herd size|LEVL|
 +|**Policy variables Relating to activities**|Premium ceiling|PRMC|
 +|:::​|Historic yield|HSTY|
 +|:::​|Premium per ton historic yield|PRET|
 +|:::​|Set-aside rate|SETR|
 +|:::​|Premium declared below base area/​herd|PRMD|
 +|:::​|Premium effectively paid|PRME|
 +|:::​|Premium amount in regulation|PRMR|
 +|:::|Type of premium application|APPTYPE|
 +|:::|Factor converting PRMR into PRMD|APPFACT|
 +|:::​|Ceiling cut factor|CEILCUT|
 +|**Processed products**|Rice milled|RICE|
 +|:::​|Molasse|MOLA|
 +|:::​|Starch|STAR|
 +|:::​|Sugar|SUGA|
 +|:::|Rape seed oil|RAPO|
 +|:::​|Sunflower seed oil|SUNO|
 +|:::|Soya oil|SOYO|
 +|:::|Olive oil|OLIO|
 +|:::|Other oil|OTHO|
 +|:::|Rape seed cake|RAPC|
 +|:::​|Sunflower seed cake|SUNC|
 +|:::|Soya cake|SOYC|
 +|:::|Olive cakes|OLIC|
 +|:::|Other cakes|OTHC|
 +|:::|Gluten feed from ethanol production|GLUE|
 +|:::​|Biodiesel|BIOD|
 +|:::​|Bioethanol|BIOE|
 +|:::|Palm oil|PLMO|
 +|:::​|Butter|BUTT|
 +|:::​|Skimmed milk powder|SMIP|
 +|:::​|Cheese|CHES|
 +|:::|Fresh milk products|FRMI|
 +|:::​|Creams|CREM|
 +|:::​|Concentrated milk|COCM|
 +|:::|Whole milk powder|WMIO|
 +|:::|Whey powder|WHEP|
 +|:::|Casein and caseinates|CASE|
 +|:::|Feed rich protein imports or byproducts|FPRI|
 +|:::|Feed rich energy imports or byproducts|FENI|
 +
 +**Table 6: Codes of the input allocation estimation**
 +
 +|**The set of FADN inputs (FI)**||
 +|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)|
 +|**The set of CAPRI inputs (CI) used in the reconcilation**||
 +|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,​ OFRU, OVEG, OCRO, OWIN, OIND, OOIL, OFAR, OANI} \\ 
 +2. The set of activity groups, and their elements, used in the replacement or missing/​negative coefficients \\ 
 + ​‘GROUPS’= {YOUNG, VEGE, SETT, PULS, PIG, OILS, MILK, MEAT, INDS, HORSE, GOAT, FRU, FOD, FLOWER, DENNY, COW,  \\ 
 + ​CHICK1,​ CHICK2, CHICK3, CERE, ARAB} \\ 
 + ​YOUNG={YBUL,​ YCOW}, \\ 
 + ​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,​ NURS}, \\ 
 + ​DENNY={PORK,​ SOWS}, \\ 
 + ​COW={DCOW,​ SCOW, HEIF, HEIR, CAMF, CAFF, BULF, CAMR, CAFR}, \\ 
 + ​CHICK1={HENS,​ POUF}, \\ 
 + ​CERE={SWHE,​ DWHE, BARL, OATS, RYEM, MAIZ}, \\ 
 + ​ARAB={POTA,​ SUGB} \\ 
 +3. The sets of Northern European, Southern European countries: \\ 
 + ​‘NEUR’={NL000,​ UK000, AT000, BL000, DE000, DK000, FI000, FR000, SE000} \\ 
 + ​‘SEUR’={El000,​ ES000, PT000, IT000, IR000} \\ 
 +
 +**Table 7: Codes of land use classes (Set LandUse)**
 +
 +|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 8: Codes of land use aggregates (Set LandUseAgg)**
 +|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 9: Codes of mutually exclusive subset adding up to total area - ARTO (Set LandUseARTO)**
 +
 +|OLND |other land - shrub, sparsely vegetated or bare|
 +|ARTIF |artificial - buildings or roads|
 +|FORE |forest ​  |
 +|UAAR |utilizable agricultural area |
 +|INLW |Inland waters|
 +
 +**Figure 48: Mapping primary agricultural activities to groups and land use in coco**
 +
 +{{::​figure_48.png?​600|}}
 +
  
  
annex_code_lists.1585558229.txt.gz · Last modified: 2020/03/30 11:50 by matsz