***************************************** * SPAM 2017 V2r1 * Dec-17-2020 * ***************************************** Difference to previous version SPAM 2017 V1r1: - Allocation for Malawi is different due to some corrections ***************************************** * SPAM 2017 V1r1 * Jul-10-2020 * ***************************************** Difference to previous version SPAM 2017 V1r0: NONE of the files has the text 'global' in their names! It is just 'SSA' ..................................... RESULTS for SPAM 2017 V2r1 - only SSA ..................................... Pixel values for 6 variables and 5 technologies, with individual crops and crop groups in each record, csv format Pixel values for 6 variables and 5 technologies, with individual crops and crop groups in each record, dbf format Pixel values for 6 variables, 5 technologies, 42 crops, tif format Admin_level 1 values for FIPS classifications, for 5 variables and 3 technologies, with individual crops and crop groups in each record, dbf and csv format - spam2017V2r1_SSA.csv.zip SPAM results by pixel, files in csv format for variables A, H, P, V, Y and 6 technologies: A, H, I, L, S and R, filename type I - spam2017V2r1_SSA.dbf.zip SPAM results by pixel, files in dbf format for variables A, H, P, V, Y and 6 technologies: A, H, I, L, S and R, filename type I - spam2017V2r1_SSA_phys_area.geotiff.zip SPAM physical area, by pixel, files in tif format for 6 technologies x 42 crops, filename type III - spam2017V2r1_SSA_harv_area.geotiff.zip SPAM harvested area, by pixel, files in tif format for 6 technologies x 42 crops, filename type III - spam2017V2r1_SSA_prod.geotiff.zip SPAM production, by pixel, files in tif format for 6 technologies x 42 crops, filename type III - spam2017V2r1_SSA_val_prod.geotiff.zip SPAM value of production, by pixel, files in tif format for 6 technologies x 42 crops, filename type III - spam2017V2r1_SSA_yield.geotiff.zip SPAM yield, by pixel, files in tif format for 6 technologies x 42 crops, filename type III - Spam2017V2r1_FIPS_SSA_level1_csv.zip SPAM results, aggregated to admin level 1 FIPS classification, files in csv format for variables H, P, V, YQ, YV and 3 technologies: A, I and R, filename type II - Spam2017V2r1_FIPS_SSA_level1_dbf.zip SPAM results, aggregated to admin level 1 FIPS classification, files in dbf format for variables H, P, V, YQ, YV and 3 technologies: A, I and R, filename type II ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ File name type I (pixelized values) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ All files have standard names, which allow direct identification of variable and technology: spam2017V2r1_SSA_v_t.fff where v = variable t = technology fff = file format v: Variables ----------------- _A_ physicalarea _H_ harvested area _P_ production _V_ value of production _Y_ yield (production per harvested area) t: Technologies --------------- *_TA all technologies together, ie complete crop or crop group *_TH rainfed high inputs portion of crop or crop group *_TI irrigated portion of crop or crop group *_TL rainfed low inputs portion of crop or crop group *_TS rainfed subsistence portion of crop or crop group *_TR rainfed portion of crop or crop group (= TA - TI) fff: File formats ----------------- *.dbf FoxPlus, directly readable by ArcGis *.csv comma separated values ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure of file name type I (pixelized values) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ each record has 9 fields to identify a pixel: ISO3, prod_level (=fips2), alloc_key (SPAM pixel id), cell5m (cell5m id), x (x-coordinate - longitude of centroid), y (y-coordinate - latitude of centroid), rec_type (see variables above), tech_type (see technologies above), unit (same in each zip file, for all values) 42 fields for 42 crops with notation: crop_T, where T = A, H, I, S or R (see crops below) 7 fields for annotations: creation data of data, year_data (years of statistics used), source (source for scaling, always FAO avg(2004-06), name_cntr, name_adm1, name_adm2 (all derived from prod_level field) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ File name type II (admin level 1 values) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ All files have standard names, which allow direct identification of variable and technology: Spam2017V2r1_aaaa_SSA_level1_v_t.fff where level1 = denotes level of aggregation, in this case admin level 1 aaaa = admin level 1 classification system v = variable t = technology fff = file format aaaa: admin level 1 classification system ------------------------------------- FIPS FIPS codes (Federal Information Processing Standards) - used in pixelized SPAM values and throughout the SPAM allocation process v: variables ----------------- _H_ harvested area _P_ production _V_ value of production _YQ_ yield quantity (production per ha) _YV_ yield value (I$ per ha) t: technologies --------------- *_TA all technologies together, ie complete crop or crop group *_TI irrigated portion of crop or crop group *_TR rainfed portion of crop or crop group (= TA - TI) fff: file formats ----------------- *.dbf dbf format, readable by many applications *.csv comma separated values ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure of file name type II (admin level 1 values) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ similar to pixel files type I, but all identification is moved to the front and no pixel IDs or coordinates are registered each record has: 10 fields to identify an admin level1 unit, and record type and unit: ISO3, fs_code (farming system code), fs_name (farming system name),prod_level (=fips1 or GADM depending on classification), name_cntr, name_adm1, name_adm2 (empty here) (all derived from prod_level field), rec_type (see variables above), tech_type (see technologies above), unit (same in each zip file, for all values) 42 fields for 42 crops (see crop list below) 9 fields for 9 crop groups (see list below) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ File name type III (tif files) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ All files have standard names, which allow direct identification of crop, variable and technology: spam2017V2r1_SSA_v_crop_t.tif where v = variable crop = short crop or group name (see below) t = technology v: Variables ----------------- _A_ physicalarea _H_ harvested area _P_ production _V_ value of production _Y_ yield (production per harvested area) t: Technologies --------------- *_A all technologies together, ie complete crop or crop group *_H rainfed high inputs portion of crop or crop group *_I irrigated portion of crop or crop group *_L rainfed low inputs portion of crop or crop group *_S rainfed subsistence portion of crop or crop group *_R rainfed portion of crop or crop group (= TA - TI) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure of file name type III (tif files) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Standard geotiff file format ***** Crop ***** crop # full name field and partial file name 1 wheat whea 2 rice rice 3 maize maiz 4 barley barl 5 pearl millet pmil 6 small millet smil 7 sorghum sorg 8 other cereals ocer 9 potato pota 10 sweet potato swpo 11 yams yams 12 cassava cass 13 other roots orts 14 bean bean 15 chickpea chic 16 cowpea cowp 17 pigeonpea pige 18 lentil lent 19 other pulses opul 20 soybean soyb 21 groundnut grou 22 coconut cnut 23 oilpalm oilp 24 sunflower sunf 25 rapeseed rape 26 sesameseed sesa 27 other oil crops ooil 28 sugarcane sugc 29 sugarbeet sugb 30 cotton cott 31 other fibre crops ofib 32 arabica coffee acof 33 robusta coffee rcof 34 cocoa coco 35 tea teas 36 tobacco toba 37 banana bana 38 plantain plnt 39 tropical fruit trof 40 temperate fruit temf 41 vegetables vege 42 rest of crops rest ************************************** Crop group names and their membership: ************************************** group # full name field and partial file name include crops n to m 1 total total 1 42 2 cereal cere 1 8 3 roots root 9 13 4 pulses puls 14 19 5 oilcrops oilc 20 27 6 millet mill 5 6 7 coffee coff 32 33 8 fruit fruit 39 40 9 banana+plantains banpl 37 38