Aquastat FAO's Global Information System on Water and Agriculture: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
(updated pictures with arrows)
(added all of the pictures with updated arrows)
Line 1: Line 1:


== SUMMARY ==
== 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.
[https://www.fao.org/aquastat/en/ 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 ==
== GENERAL STEPS TO PULL DATA FROM AQUASTAT ==
Line 8: Line 8:


Step 2.) Near the top of the page, click on the tab labeled "'''Database'''"
Step 2.) Near the top of the page, click on the tab labeled "'''Database'''"
[[File:Aquastat IMG STEP 01.jpg|center|thumb|550x550px|AQUASTAT's Homepage]]
[[File:Aquastat IMG STEP 01.jpg|center|thumb|576x576px|AQUASTAT's Homepage]]
 


Step 3.) On the left hand side of the page, click on the tab labeled "'''Country Statistics'''"
Step 3.) On the left hand side of the page, click on the tab labeled "'''Country Statistics'''"
[[File:Aquastat IMG STEP 03.jpg|center|thumb|547x547px|AQUASTAT's Database Homepage]]
[[File:Aquastat IMG STEP 03.jpg|center|thumb|574x574px|AQUASTAT's Database Homepage]]
 
 
 
 
[[File:AQUASTAT Database Page.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
[[File:AQUASTAT Country Statistic Page.png|thumb|493x493px]]
 
3. On the left hand side of the page, click on the tab labeled "'''Country Statistics'''"
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
[[File:AQUASTAT TABLEAU PAGE.png|thumb|494x494px]]
 
 






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


THIS WILL OPEN A PAGE ON ANOTHER TAB
THIS WILL OPEN A PAGE ON ANOTHER TAB
[[File:Aquastat IMG STEP 04 Actual.jpg|center|thumb|575x575px|AQUASTAT's Country Statistics Page]]




Step 5.) Under the "Countries" section on the right side, select '''(ALL)''' to select all countries
[[File:Aquastat IMG STEP 05.jpg|center|thumb|575x575px|Select (All) Countries]]


Step 6.) Under the "Year" section on the right side, select '''(ALL)''' to select all years from 1960 to the most recent
[[File:Aquastat IMG STEP 06.jpg|center|thumb|575x575px|Select (All) Years]]


 
Step 7.) To find your specific variable, click which "Variable Group" it is in, then the "Variable Subgroup", and finally your "Variable"
 
[[File:Aquastat IMG STEP 07.jpg|center|thumb|576x576px|The Variable Group of your Series]]
 
 
 
 
 
 
 
[[File:AQUASTAT COUNTRIES SELECTED.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
5. Under the "Countries" section on the right side, select '''(ALL)''' to select all countries
 
 
 
 
 
 
 
 
 
 
 
 
 
 
                         
   
     
 
[[File:AQUASTAT YEARS SELECTED.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
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 ==
== SPECIFIC VARIABLE EXAMPLE: SeriesIrrigatedCropIntensity ==
[[File:Variable Group.png|thumb|494x494px]]
Step 8.) On the left hand side, under "Variable Group", select "'''Irrigation and drainage development'''"
 
[[File:Aquastat IMG STEP 08.jpg|center|thumb|575x575px|Select the Variable Group]]
 
 
 
 
 
 
8. On the left hand side, under "Variable Group", select "'''Irrigation and drainage development'''"
 
 
[[File:AQUASTAT VARIABLE SUBGROUP.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
9. The "Variable Subgroup" section under "Variable Group" should now be populated with different subgroups. Select the subgroup "'''Irrigated crop area and cropping intensity'''"
 
 
 
[[File:AQUASTAT Variable.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
10. The "Variable" section under "Variable Subgroup" should now be populated with different variables. Select the variable "'''Irrigated cropping intensity'''"
 
 
[[File:AQUASTAT Download Button.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 
 
 
 
 
[[File:AQUASTAT Data page.png|thumb|494x494px]]
 
 
 
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'''"
[[File:AQUASTAT Excel page.png|thumb|494x494px]]
 
 
 
 
 
 
 
 
 


Step 9.) The "Variable Subgroup" section under "Variable Group" should now be populated with different subgroups. Select the subgroup "'''Irrigated crop area and cropping intensity'''"
[[File:Aquastat IMG STEP 09.jpg|center|thumb|575x575px|Select the Variable Subgroup]]


Step 10.) The "Variable" section under "Variable Subgroup" should now be populated with different variables. Select the variable "'''Irrigated cropping intensity'''"
[[File:Aquastat IMG STEP 10.jpg|center|thumb|575x575px|Select the Variable]]




Step 11.) On the top left side of the page, click "'''Show Data'''"
[[File:Aquastat IMG STEP 11.jpg|center|thumb|575x575px|Click "Show Data"]]


Step 12.) A NEW PAGE WILL POPULATE ON A NEW TAB... on the top right side click on "'''Download'''"
[[File:Aquastat IMG STEP 12.jpg|center|thumb|574x574px|Click "Download"]]




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]]
13. An Excel sheet will download. Now you can format the data to upload it into IFs. To pull data into IFs, please follow the instructions found in the [[Data Pull Instructions Page]]
[[File:AQUASTAT Excel page.png|thumb|575x575px|center]]

Revision as of 23:14, 17 January 2023

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


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

THIS WILL OPEN A PAGE ON ANOTHER TAB

AQUASTAT's Country Statistics Page


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

Select (All) Countries

Step 6.) Under the "Year" section on the right side, select (ALL) to select all years from 1960 to the most recent

Select (All) Years

Step 7.) To find your specific variable, click which "Variable Group" it is in, then the "Variable Subgroup", and finally your "Variable"

The Variable Group of your Series

SPECIFIC VARIABLE EXAMPLE: SeriesIrrigatedCropIntensity

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

Select the Variable Group

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

Select the Variable Subgroup

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

Select the Variable


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

Click "Show Data"

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

Click "Download"


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

AQUASTAT Excel page.png
Retrieved from "https://pardeewiki.du.edu//index.php?title=Aquastat_FAO%27s_Global_Information_System_on_Water_and_Agriculture&oldid=9883"