INTERNATIONAL CONFERENCE ON OPEN DATA FOR AGRICULTURE 10 km Grid as the Unit of Data Analysis, Management, and Release 30 April 2013 Prepared by Jawoo Koo ([email protected]) INTERNATIONAL FOOD POLICY RESEARCH INSTITUTE | WASHINGTON, DC 

OPEN AG DATA CONFERENCE — 30 APRIL 2013 | 2 CV of Yield 624 % 0 HI, I’M JAWOO I’M A CROP MODELER I simulate crop growth and yields at regional or global scale, using mathematical agronomic crop growth mod- el to estimate changes in outputs as a consequence of changes in inputs. The simulation outputs are often used as inputs into global trade and economic models. 

OPEN AG DATA CONFERENCE — 30 APRIL 2013 | 3 I WORK WITH ECONOMISTS They want to know everything everywhere for all crops, asking like: Hey, get me yield response of all the important staple crops for all the promising technologies, everywhere. The only way to make them happy is to run crop models on fine grids, that can be aggregated in multiple ways. Problem is, not enough data exist to cover everywhere. 

OPEN AG DATA CONFERENCE — 30 APRIL 2013 | 4 I MANAGED TO GENERATE MODEL IN- PUT DATA ON GRIDS BY MASHING-UP MULTIPLE OPEN DATASETS Once everything is on the standard grids, I was able to utilize model output data in many interesting ways! A4 A3 A2 A1 A CELL A1 July 1980 - Rainfall 100 mm 12 x (daily rainfall pattern) for July at CELL A from POWER 1997: 68 mm 1998: 70 mm 1999: 80 mm 2000: 50 mm 2001: 60 mm 2002: 70 mm 2003: 80 mm 2004: 40 mm 2005: 95 mm 2006: 100 mm 2007: 80 mm 2008: 120 mm Use July 2006 daily weather at CELL A as July 1980 daily weather at CELL A1 WEATHER 1. Type (FAO 90) 2. Texture 3. Organic Carbon Content 4. pH 5. Water Availability *WI_PLMW001 WISE C 87 WISE DATABASE, SOIL MW001 @SITE COUNTRY LAT LONG SCS Family -99 Malawi -15.050 35.250 Eutric Planosol (PLe) @ SCOM SALB SLU1 SLDR SLRO SLNF SLPF SMHB SMPX SMKE G 0.13 11.52 0.25 73.00 1.00 1.00 SA001 SA001 SA001 @ SLB SLMH SLLL SDUL SSAT SRGF SSKS SBDM SLOC SLCL SLSI SLCF SLNI SLHW SLHB SCEC SADC 19 Ap 0.185 0.353 0.473 1.00 0.46 1.33 1.60 44.00 16.00 -99.0 0.14 6.10 -99.0 19.40 -99.0 48 B1 0.221 0.324 0.436 0.51 0.47 1.45 0.40 52.00 10.00 -99.0 0.04 6.80 -99.0 11.90 -99.0 72 B2 0.237 0.352 0.445 0.30 0.29 1.43 0.20 56.00 10.00 -99.0 0.02 8.30 -99.0 13.00 -99.0 87 B3 0.228 0.302 0.380 0.20 0.33 1.59 0.20 34.00 10.00 -99.0 0.02 8.80 -99.0 12.60 -99.0 @ SLB SLPX SLPT SLPO CACO3 SLAL SLFE SLMN SLBS SLPA SLPB SLKE SLMG SLNA SLSU SLEC SLCA 19 -99.0 -99.0 -99.0 -99.0 -99.0 -99.0 -99.0 72.0 -99.0 -99.0 0.2 3.8 0.3 -99.0 9.6 9.6 48 -99.0 -99.0 -99.0 -99.0 -99.0 -99.0 -99.0 91.0 -99.0 -99.0 0.9 3.6 0.2 -99.0 3.2 5.9 72 -99.0 -99.0 -99.0 -99.0 -99.0 -99.0 -99.0 100.0 -99.0 -99.0 0.4 6.7 0.2 -99.0 4.6 6.3 87 -99.0 -99.0 -99.0 -99.0 -99.0 -99.0 -99.0 100.0 -99.0 -99.0 0.4 4.2 0.2 -99.0 -99.0 9.9 PLAN B: HC27 (27 generic soil profiles for SSA; 3 texture x 3 fertility x 3 depth) MISSION: FIND THE BEST MATCHING PROFILE FOR EACH SOIL IN HWSD 1.1 

OPEN AG DATA CONFERENCE — 30 APRIL 2013 | 5 TRY at http://harvestchoice.org/page/crop-response EXAMPLE: CROP YIELD RESPONSE TOOL The web-based tool allows users to run database query. Users define two scenarios (baseline vs. what-if) and see the changes in yields, on map, chart, and table. The interface basically creates a straightforward SQL query and display the results dy- namically! 

OPEN AG DATA CONFERENCE — 30 APRIL 2013 | 6 OTHER USES OF GRIDS Each grid cell carries >300 layers of indicators in various biophysical and socioeconomic themes, including: Land Cover, Climate, Elevation, Demographics, Crop produc- tion, Livestock statistics, Market Accessibility, and Pov- erty. The layers of managed in a series of database tables, which can be used aggregation/analytical tools. 

OPEN AG DATA CONFERENCE — 30 APRIL 2013 | 7 IFPRI ifpri.org The International Food Policy Research Institute (IFPRI) seeks sustainable solutions for ending hunger and poverty. IFPRI is one of 15 centers supported by the Consultative Group on International Agricultural Research (CGIAR), an alliance of 64 governments, private foundations, and international and regional organizations. HarvestChoice harvestchoice.org HarvestChoice generates knowledge products to help guide strategic in- vestments to improve the well-being of poor people in sub-Saharan Africa through more productive and profitable farming. To do this, a novel and spatially explicit evaluation framework is being developed and deployed. By design, primary knowledge products are currently targeted to the needs of investors, policymakers and program managers, as well as the analysts and tech- nical specialists who support them. Most decisions that HarvestChoice targets are those having implications that cut across country bounda- ries. Mark Rosegrant / PI Jawoo Koo / Crop Modeling, Spatial Analysis Carlo Azzarri / Micro-economics, M&E Zhe Guo / GIS Coordinator, Spatial Analysis Ulrike Wood-Sichra / Database, Statistics Management Ivy Romero / Program Coordinator Cecile Martignac / Participatory GIS, Spatial Analysis Melanie Bacou / Economist Maria Comanescu / Developer Cindy Cox / Plant Pathology, Technical Writer Naomie Sakana / Farming Systems modeling Steve Kibet / Data Management in East Africa HARVESTCHOICE TEAM AT IFPRI