search

earthrise-media / food-security

Visualizing data to better monitor issues around food security
14 stars 1 forks source link

Experiment with USDA crop data #30

Open mikelmaron opened 1 year ago

mikelmaron commented 1 year ago

After an inquiry on Ukraine, the USDA shared their Crop Explorer

I lot of useful agricultural information can be found on our Crop Explorer website (https://ipad.fas.usda.gov/cropexplorer/Default.aspx). And here is the direct link to the Ukraine’s Country Summary website: https://ipad.fas.usda.gov/countrysummary/Default.aspx?id=UP. The latter provides crop production maps that can give you a general idea of the major crops grown in each oblast.

Could be some interesting ways to present this data on volume, location, and crop calendar together. What if we gave it similar treatment as FEWS NET -- ability interact with data over the course of an annual cycle. emphasize different crops interactively. Further, introduce disruptions -- whether caused by war, change in climate, etc. might that impact resulting yields.

Outcome of this work would be an interactive working with the Crop Explorer data.

mikelmaron commented 1 year ago

Asked USDA about accessing the data...

PSD offers a country-wide, national number. That applies for all three, area, production and yield. USDA does not publish sub-regional level data for any country.

About Ukraine, you are right, the total production and yield numbers for Ukraine can be access though PSD.

I just checked, the State Stat Service site seems to accessible at the moment (https://ukrstat.gov.ua/); you have to look a bit to find the past crop production annual reports.

mikelmaron commented 1 year ago

@cameronkruse notebook exploring USDA data https://github.com/earthrise-media/food-security/blob/main/data-exploration/notebooks/usda-data-exploration.ipynb

mikelmaron commented 1 year ago

Not sure that usda pointed us in the right direction for sub-national. From USDA crop explorer, there's an attribution note "Sub-National production percentages are calculated using IFPRI-SPAM (CY2010) data.". This data is at https://mapspam.info/index.php/data/. It's gridded data as a GeoTIFF, so USDA must be using admin boundaries and IFPRI-SPAM together.

On further examination, the UA statistical site has an English option in the upper right corner. I was able to locate data on agricultural production by region https://ukrstat.gov.ua/operativ/operativ2021/sg/ovuzpsg/Arh_ovuzpsg_2021_e.html

cameronkruse commented 1 year ago

closing this out as this notebook is published. various assets used in Ukraine grain and the cropscape data map