Aquastat FAO's Global Information System on Water and Agriculture

From Pardee Wiki
Revision as of 22:09, 17 January 2023 by Kaitlyn.Granger (talk | contribs) (updated pictures with arrows)
Jump to navigation Jump to search

SUMMARY

AQUASTAT is the UN's Food and Agriculture Organization (FAO) global information system on water resources and agricultural water management. It collects, analyzes, and provides free access to over 180 variables and indicators by country and year from 1960. AQUASTAT plays an important role in monitoring of the UN's Sustainable Development Goal 6 that sets out to "ensure availability and sustainable management of water and sanitation for all". Additionally, AQUASTAT's new dissemination system allows users to download up to 100,000 data points.

GENERAL STEPS TO PULL DATA FROM AQUASTAT

Step 1.) Navigate to the home page of AQUASTAT FAO's Global Information System on Water and Agriculture,

Step 2.) Near the top of the page, click on the tab labeled "Database"

AQUASTAT's Homepage


Step 3.) On the left hand side of the page, click on the tab labeled "Country Statistics"

AQUASTAT's Database Homepage



AQUASTAT Database Page.png










AQUASTAT Country Statistic Page.png

3. On the left hand side of the page, click on the tab labeled "Country Statistics"









AQUASTAT TABLEAU PAGE.png



4. On the left hand side of the page, click on the tab labeled "Meta Data", under "Country Statistics"

THIS WILL OPEN A PAGE ON ANOTHER TAB







AQUASTAT COUNTRIES SELECTED.png






5. Under the "Countries" section on the right side, select (ALL) to select all countries










AQUASTAT YEARS SELECTED.png






6. Under the "Year" section on the right side, select (ALL) to select all years












7. To find your specific variable, click which "Variable Group", then the "Variable Subgroup", and finally your "Variable"










SPECIFIC VARIABLE EXAMPLE: SeriesIrrigatedCropIntensity

Variable Group.png




8. On the left hand side, under "Variable Group", select "Irrigation and drainage development"


AQUASTAT VARIABLE SUBGROUP.png






9. The "Variable Subgroup" section under "Variable Group" should now be populated with different subgroups. Select the subgroup "Irrigated crop area and cropping intensity"


AQUASTAT Variable.png








10. The "Variable" section under "Variable Subgroup" should now be populated with different variables. Select the variable "Irrigated cropping intensity"


AQUASTAT Download Button.png







AQUASTAT Data page.png


11. On the top left side of the page, click "Show Data"







12. A NEW PAGE WILL POPULATE ON A NEW TAB... on the top right side click on "Download"

AQUASTAT Excel page.png









13. An Excel sheet will download. Now you can format the data to upload it into IF's! To pull data into IFs, please follow the instructions found in the Data Pull Instructions Page

Retrieved from "https://pardeewiki.du.edu//index.php?title=Aquastat_FAO%27s_Global_Information_System_on_Water_and_Agriculture&oldid=9872"