User Tools

Site Tools


Sidebar

Introduction

Getting started with CAPRI

The CAPRI Data Base

Baseline Generation

Scenario simulation

Post model analysis

Spatial dis-aggregation CAPDIS module

Stability testing tools for model tasks

References

Annex Code lists

testarticle

annex_code_lists

Annex: Code lists

Table 1: Codes used for storing the original REGIO tables in the data base and their description, rows

Codes used in CAPRI’s REGIO tablesOriginal REGIO description
TOTLTerritorial area
FOREForest land
AGRIUtilized agricultural area
GARDPrivate gardens
GRASPermanent grassland
PERMPermanent crops
VINEVineyards
OLIVOlive plantations
ARABArable land
GREFGreen fodder on arable land
CERECereals (including rice)
WHEASoft and durum wheat and spelt
BARLBarley
MAIZGrain maize
RICERice
POTAPotatoes
SUGASugar beet
OILSOilseeds (total)
RAPERape
SUNFSunflower
TOBATobacco
MAIFFodder maize
CATTCattle (total)
COWTCows (total)
DCOWDairy cows
CALVOther cows
CAT1Total cattle under one year
CALFSlaughter calves
CABMMale breeding calves (<1 year)
CABFFemale breeding calves (<1 year)
BUL2Male cattle (1-2 years)
H2SLSlaughter heifers (1-2 years)
H2BRFemale cattle (1-2 years)
BUL3Male cattle (2 years and above)
H3SLSlaughter heifers (2 years and above)
H3BRBreeding heifers
BUFFTotal buffaloes
PIGSTotal pigs (total)
PIG1Piglets under 20 kg
PIG2Piglets under 50 kg and over 20 kg
PIG3Fattening pigs over 50 kg
BOARBreeding boars
SOW2Total breeding sows
SOW1Sows having farrowed
GILTGilts having farrowed for the first time
SOWMMaiden sows
GILMMaiden gilts
SHEPSheep total)
GOATGoats (total)
EUQIEquidae (total)
POULPoultry (total)
OUTPFinal production
CROPTotal crops production
DWHEDurum wheat
PULSPulses
ROOTRoots and tubers
INDUIndustrial crops
TEXTTextile fibre plants
HOPSHops
VEGEFresh vegetables
TOMATomatoes
CAULCauliflowers
FRUIFresh fruit
APPLApples
PEARPears
PEACPeaches
CITRCitrus fruit (total)
ORANOranges
LEMNLemons
MANDMandarins
GRAPTable grapes
WINEWine
TABOTable olives
OLIOOlive oil
NURSNursery plants
FLOWFlowers and ornamental plants
OCROOther crops
ANITTotal animal production
ANIMAnimal
SHGOSheep and goats
ANIPAnimal products
MILKMilk
EGGSEggs
INPUIntermediate consumption (total)
FEEDAnimal feeding stuffs
FDGRAnimal compounds for grazing livestock
FDPIAnimal compounds for pigs
FDPOAnimal compounds for poultry
FODDStraight feeding stuffs
FERTFertilizers and enrichments
ENEREnergy and lubricants
INPOOther inputs
GVAMGross value added at market prices
SUBSSubsidies
TAXSTaxes linked to production (including VAT balance)
GVAFGross value added at factor costs
DEPMDepreciation
LABOCompensation and social security contributions of employees
RENTRent and other payments
INTEInterests
GFCFTotal of gross fixed capital formation
BUILBuildings and other structures
MACHTransport equipment and machinery
GFCOOther gross fixed capital formation

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
LEVLHerd size / Area / # of persons
LSUNLive stock units
PROPPhysical production
YILDYield
VALEEAA position in ECU
VALNEAA position in NC

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
SWHEWHEACEREARAB Soft wheat
DWHEWHEACEREARAB Durum wheat
RYE CEREARAB Rye
BARLBARLCEREARAB Barley
OATS CEREARAB Oats
MAIZMAIZCEREARAB Maize
OCER CEREARAB Other cereals (excl. rice)
PARIRICECEREARAB Paddy rice
PULS ARAB Pulses
POTAPOTA ARAB Potatoes
SUGBSUGA ARAB Sugar beet
RAPERAPEOILSARAB Rape and turnip rape
SUNFSUNFOILSARAB Sunflower seed
SOYA OILSARAB Soya beans
OLIV OLIVPERM Olives for oil
OOIL OILSARAB Other oil seeds and oleaginous fruits
FLAX ARAB Flax and hemp (faser)
TOBATOBA ARAB Tobacco, unmanufactured, incl. dried
OIND ARAB Other industrial crops
CAUL ARAB Cauliflowers
TOMA ARAB Tomatoes
OVEG ARAB Other vegetables
APPL PERM Apples, pears and peaches
OFRU PERM Other fresh fruits
CITR PERM Citrus fruits
TAGR VINEPERM Table grapes
TABO OLIVPERM Table olives
TWIN VINEPERM Table wine
OWIN VINEPERM Other wine
NURS PERM Nursery plants
FLOW ARAB Flowers,ornamental plants, etc.
OCRO ARAB Other final crop products
MILKDCOW Dairy cows
BEEFBUL2BUL3 Bulls fattening
CALFCALF Calves fattening (old VEAL)
PORKPIG3PIG2PIG1 Pig fattening
MUTMGOATHEP Ewes and goats
MUTTGOATSHEP Sheep and goat fattening
EGGSPOUL Laying hens
POULPOUL Poultry fattening
OANI Other animals
OROO ARAB Other root crops
GRASGRAS Green fodder
SILAGREF ARAB Silage
CALVCALV Suckler cows
RCALCABMCABF Calves, raising
HEIFH2SLH2BRH3SLH3BRHeifers
PIGLSOW2 Pig breeding
FALL FALL Fallow land

Table 4: List of activities in the supply model

Group Activity Code
CerealsSoft wheatSWHE
Durum wheatDWHE
Rye and MeslinRYEM
BarleyBARL
OatsOATS
Paddy ricePARI
MaizeMAIZ
Other cerealsOCER
OilseedsRapeRAPE
SunflowerSUNF
SoyaSOYA
Olives for oilOLIV
Other oilseedsOOIL
Other annual cropsPulsesPULS
PotatoesPOTA
Sugar beetSUGB
Flax and hempTEXT
TobaccoTOBA
Other industrial cropsOIND
Vegetables & Fruits & Other perennialsTomatoesTOMA
Other vegetablesOVEG
Apples, pear & peachesAPPL
Citrus fruitsCITR
Other fruitsOFRU
Table grapesTAGR
Table olivesTABO
Table wineTWIN
NurseriesNURS
FlowersFLOW
Other marketable cropsOCRO
Fodder productionFodder maizeMAIF
Fodder root cropsROOF
Other fodder on arable landOFAR
Graze and grazingGRAS
Fallow land and set-asideSet-aside idlingSETA
Non food production on set-asideNONF
Fallow landFALL
CattleDairy cowsDCOW
Sucker cowsSCOW
Male adult cattle fatteningBULF
Heifers fatteningHEIR
Heifers raisingHEIF
Fattening of male calvesCAMF
Fattening of female calvesCAFF
Raising of male calvesCAMR
Raising of female calvesCAFR
Pigs, poultry and other animalsPig fatteningPIGF
Pig breedingSOWS
Poultry fatteningPOUF
Laying hensHENS
Sheep and goat fatteningSHGF
Sheep and goat for milkSHGM
Other animalsOANI

Table 5: Output, inputs, income indicators, policy variables and processed products in the data base

Group Item Code
Outputs
CerealsSoft wheatSWHE
Durum wheatDWHE
Rye and MeslinRYEM
BarleyBARL
OatsOATS
Paddy ricePARI
MaizeMAIZ
Other cerealsOCER
OilseedsRapeRAPE
SunflowerSUNF
SoyaSOYA
Olives for oilOLIV
Other oilseedsOOIL
Other annual cropsPulsesPULS
PotatoesPOTA
Sugar beetSUGB
Flax and hempTEXT
TobaccoTOBA
Other industrial cropsOIND
Vegetables & Fruits & Other perennialsTomatoesTOMA
Other vegetablesOVEG
Apples, pear & peachesAPPL
Citrus fruitsCITR
Other fruitsOFRU
Table grapesTAGR
Table olivesTABO
Table wineTWIN
NurseriesNURS
FlowersFLOW
Other marketable cropsOCRO
FodderGrasGRAS
Fodder maizeMAIF
Other fodder from arable landOFAR
Fodder root cropsROOF
StrawSTRA
Marketable products from animal productMilk from cowsCOMI
BeefBEEF
Pork meatPORK
Sheep and goat meatSGMT
Sheep and goat milkSGMI
Poultry meatPOUM
Other marketable animal productsOANI
Intermediate products from animal productionMilk from cows for feedingCOMF
Milk from sheep and goat cows for feedingSGMF
Young cowsYCOW
Young bullsYBUL
Young heifersYHEI
Young male calvesYCAM
Young female calvesYCAF
PigletsYPIG
LambsYLAM
ChickenYCHI
Nitrogen from manureMANN
Phosphate from manureMANP
Potassium from manureMANK
Other Output from EAARenting of milk quota RQUO
Agricultural servicesSERO
Inputs
Mineral and organic fertiliser & Seed and plant protectionNitrogen fertiliserNITF
Phosphate fertiliserPHOF
Potassium fertiliserPOTF
Calcium fertiliserCAOF
SeedSEED
Plant protectionPLAP
Feedings tuffFeed cerealsFCER
Feed rich proteinFPRO
Feed rich energyFENE
Feed based on milk productsFMIL
GrasFGRA
Fodder maizeFMAI
Other Feed from arable landFOFA
Fodder root cropsFROO
Feed otherFOTH
StrawFSTRA
Young animal & Other animal specific inputsYoung cowICOW
Young bullIBUL
Young heiferIHEI
Young male calfICAM
Young female calfICAF
PigletIPIG
LambILAM
ChickenICHI
Pharmaceutical inputsIPHA
General inputs|Maintennce machineryREPM
Maintennce buildingsREPB
ElectricityELEC
Heating gas and oilEGAS
FuelsEFUL
LubricantsELUB
WaterWATR
Agricultural services inputSERI
Other inputsINPO
Income indicatorsProduction valueTOOU
Total input costsTOIN
Gross value added at producer pricesGVAP
Gross value added at basic pricesGVAB
Gross value added at market prices plus CAP premiumsMGVA
Activity levelCropped area, slaughtered heads or herd sizeLEVL
Policy variables Relating to activitiesPremium ceilingPRMC
Historic yieldHSTY
Premium per ton historic yieldPRET
Set-aside rateSETR
Premium declared below base area/herdPRMD
Premium effectively paidPRME
Premium amount in regulationPRMR
Type of premium applicationAPPTYPE
Factor converting PRMR into PRMDAPPFACT
Ceiling cut factorCEILCUT
Processed productsRice milledRICE
MolasseMOLA
StarchSTAR
SugarSUGA
Rape seed oilRAPO
Sunflower seed oilSUNO
Soya oilSOYO
Olive oilOLIO
Other oilOTHO
Rape seed cakeRAPC
Sunflower seed cakeSUNC
Soya cakeSOYC
Olive cakesOLIC
Other cakesOTHC
Gluten feed from ethanol productionGLUE
BiodieselBIOD
BioethanolBIOE
Palm oilPLMO
ButterBUTT
Skimmed milk powderSMIP
CheeseCHES
Fresh milk productsFRMI
CreamsCREM
Concentrated milkCOCM
Whole milk powderWMIO
Whey powderWHEP
Casein and caseinatesCASE
Feed rich protein imports or byproductsFPRI
Feed rich energy imports or byproductsFENI

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

annex_code_lists.txt · Last modified: 2020/06/25 17:48 by matsz