Downloading datasets
In this section, we will start building the ETL in our Notebook by downloading the following datasets:
- World countries
- Population
- Rainfall
- Agricultural land
- Crop yields
- Pesticide and fertilizer use
- Temperature change
Let’s get started. Create a new Notebook in ArcGIS Pro named CropYieldETL
using the New Notebook option under the Insert tab:

Figure 13.3: New empty Notebook named “CropYieldETL”
World countries
First, you will search for and download a country boundary dataset from ArcGIS Online using the ArcGIS API for Python.
- In the first cell, you will import the API with the following code:
from arcgis.gis import GIS
Run the cell.
- Once imported, you will connect to two separate instances. The first one is anonymous and will be used for searching for datasets; the second takes your ArcGIS Pro login credentials for download...