Aquastat data: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 2: Line 2:


Most of the data used in the water preprocessor comes from the AQUASTAT database. [http://www.fao.org/nr/water/aquastat/main/index.stm http://www.fao.org/nr/water/aquastat/main/index.stm]
Most of the data used in the water preprocessor comes from the AQUASTAT database. [http://www.fao.org/nr/water/aquastat/main/index.stm http://www.fao.org/nr/water/aquastat/main/index.stm]
'''Documentation:'''
First, I had to adjust the Datadict. I went to the Datadict and filtered for all series that came from Aquastat. I then compared the Series codes to what was being downloaded from the aquastat database (Download from the Flat option, not table). Most codes needed to be changed in the datadict. I also added some series to the datadict. The following series were added:
{| border="0" cellspacing="0" cellpadding="0" width="525" style="width:525px;"
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Direct use of not treated municipal wastewater for irrigation purposes 
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigated crop intensity 
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by surface water 
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by groundwater 
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by mixed surface water and groundwater 
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of treated municipal wastewater 
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of non-treated municipal wastewater 
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of agricultural drainage water 
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by desalinated water
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigation water withdrawal
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigation water requirement
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Direct use of treated municipal wastewater for irrigation purposes
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
area equipped for irrigation: actually irrigated
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
area equipped for full control irrigation: total
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for full control irrigation: actually irrigated
|}
 
The FAO Countries translation needed to be adjusted. China, Sudan, and North Sudan were all adjusted.
When uploading data from excel to Ifs: You can only download so many variables from the database at one time. I uploaded data in shifts. In Ifs, you need to uncheck data that has already been updated.
There were a few series that were not updated, as there was no new data for them on the database. These include:
LandIrEquipDesalinated
LandIrEquipDirectAg
LandIrHarvest%Equip
LandIrHarvest%FullControl
LandIrPotentialReached (There’s a note in the datadict here)


= Current status =
= Current status =
Line 505: Line 420:
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|}
|}
<span style="font-size:larger;">'''AquaStat Documentation:'''</span>
First, I had to adjust the Datadict. I went to the Datadict and filtered for all series that came from Aquastat. I then compared the Series codes to what was being downloaded from the aquastat database (Download from the Flat option, not table). Most codes needed to be changed in the datadict. I also added some series to the datadict. The following series were added:
{| border="0" cellspacing="0" cellpadding="0" width="525" style="width:525px;"
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Direct use of not treated municipal wastewater for irrigation purposes&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigated crop intensity&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by surface water&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by groundwater&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by mixed surface water and groundwater&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of treated municipal wastewater&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of non-treated municipal wastewater&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of agricultural drainage water&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by desalinated water
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigation water withdrawal
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigation water requirement
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Direct use of treated municipal wastewater for irrigation purposes
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
area equipped for irrigation: actually irrigated
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
area equipped for full control irrigation: total
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for full control irrigation: actually irrigated
|}
&nbsp;
The FAO Countries translation needed to be adjusted. China, Sudan, and North Sudan were all adjusted.
When uploading data from excel to Ifs: You can only download so many variables from the database at one time. I uploaded data in shifts. In Ifs, you need to uncheck data that has already been updated.
There were a few series that were not updated, as there was no new data for them on the database. These include:
LandIrEquipDesalinated
LandIrEquipDirectAg
LandIrHarvest%Equip
LandIrHarvest%FullControl
LandIrPotentialReached (There’s a note in the datadict here)
&nbsp;

Revision as of 17:50, 2 June 2016

Back to water preprocessor 

Most of the data used in the water preprocessor comes from the AQUASTAT database. http://www.fao.org/nr/water/aquastat/main/index.stm

Current status

Needs to be pulled. Link to task on teamwork: https://pardeecenter.teamwork.com/tasks/3797325


Series pulled from Aquastat

Table
Group Definition Years Source Last IFs Update UsedInPreprocessor
SeriesWaterWith%Household Environment, Infrastructure, Water Water withdrawals, percent used by households (1990=70-99;2000=update, mostly 2000) 1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterWith%Ind Environment, Infrastructure, Water Water withdrawals, percent used in industry (1990=70-99;2000=update, mostly 2000) 1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrEquip%WaterManaged Agriculture, Infrastructure, Water % of agricultural water managed area equipped for irrigation (%)
1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterGroundEntering Infrastructure, Water, Health Groundwater entering the country (natural) 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterTotalWithdPC Environment, Infrastructure, Water Total water withdrawal per capita 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterWith%Fresh Agriculture, Infrastructure, Environment, Water % of total actual renewable freshwater resources withdrawn (%)
1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1987, 1990-1997, 1999-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterDesalinated Environment, Infrastructure, Water Desalinated Water Produced 1988-1997, 1999-2008, 2010 AQUASTAT 2011/01/20 No
SeriesWaterGroundWithD Environment, Infrastructure, Water Ground Water Withdrawal 1980, 1985, 1987-1990, 1992-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterSurfaceWithD Environment, Infrastructure, Water Surface Water Withdrawal 1980, 1985, 1987-1990, 1992-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrEquip%Cultivated Agriculture, Infrastructure % of cultivated area equipped for irrigation (%)
1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrEquip%Potential Agriculture, Infrastructure % of irrigation potential equipped for irrigation (%)
1962, 1967, 1970, 1972, 1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrEquipActual Agriculture, Infrastructure Area equipped for irrigation: actually irrigated (1000 ha)
1962, 1967, 1972, 1975, 1977, 1980, 1982-1983, 1985-2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrEquipDrained Agriculture, Infrastructure Area equipped for irrigation drained (1000 ha)
1985, 1987, 1990-2006, 2008-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrHarvest%Equip Economic, Infrastructure Harvested irrigated crop area as % of area equipped for full control irrigation (%)
1984, 1987, 1989-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrHarvest%FullControl Economic, Infrastructure Harvested irrigated crop area as % of full control irrigation area actually irrigated (%)
1962, 1967, 1972, 1977, 1982, 1987, 1989-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrPotential Agriculture, Infrastructure Irrigation potential (1000 ha)
1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2005, 2007-2008, 2011 AQU 2013 BATCH PULL 2013/07/18 Yes
SeriesLandIrAreaEquip Agriculture, Infrastructure Area equipped for irrigation: total (1000 ha)
1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrWaterLogged Agriculture, Infrastructure Area waterlogged by irrigation (1000 ha)
1990-1993, 1995, 1997-2000, 2002-2007 AQU 2013 BATCH PULL 2013/07/18 No
SeriesTotalDamCapacity Economic, Infrastructure Total dam capacity (km3)
1960, 1965, 1970, 1975, 1977, 1980, 1984-1985, 1989-1998, 2000-2008, 2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrHarvestedCropArea Agriculture, Infrastructure Total harvested irrigated crop area (1000 ha)
1961, 1966, 1971-1972, 1975-1977, 1980-1982, 1984-1985, 1987-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWasterwaterTreated Economic, Infrastructure Wastewater: treated volume (10^9 m3/yr)
1967, 1971, 1975, 1979-1980, 1982, 1985, 1987, 1989-2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWastewaterTreatedReused Economic, Infrastructure Treated wastewater reused (10^9 m3/yr)
1962, 1967, 1971-1972, 1975, 1977, 1982, 1985, 1987, 1989-1998, 2000-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterTotalWithdSector Agriculture, Infrastructure, Environment, Water Total water withdrawal (summed by sector) 1988-1997, 1999-2006 AQUASTAT 2010/02/20 No
SeriesWaterDependencyRatio Agriculture, Infrastructure, Environment, Water Dependency ratio, percentage of total renewable water resources originating outside of the country 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterResTotalExploit Agriculture, Infrastructure, Environment, Water Water resources: total exploitable 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997-1998, 2000-2003, 2005, 2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterTotalAgManagedArea Agriculture, Infrastructure, Environment, Water Total agricultural water managed area 1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterTotalRenewPC Agriculture, Infrastructure, Environment, Water Water resources: total renewable per capita (actual) 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterWithAgr%FreshAquastat Agriculture, Infrastructure, Environment, Water % of total actual renewable water resources withdrawn by agriculture (%)
1988-2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterWithdAgriculture Agriculture, Infrastructure, Environment, Water Agricultural water withdrawal 1965, 1969-1970, 1974-1975, 1979-1980, 1982, 1984-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterWithdIndustrial Environment, Infrastructure, Water Industrial water withdrawal 1965, 1970, 1974-1975, 1979-1980, 1982, 1984-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterWithdMunicipal Environment, Infrastructure, Water Municipal water withdrawal 1965, 1970, 1974-1975, 1979-1980, 1982, 1984-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterGroundLeaving Infrastructure, Water, Health Groundwater leaving the country (naturally) 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterGroundProdInternal Infrastructure, Water, Health Groundwater produced internally (natural) 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterGroundTotal Infrastructure, Water, Health Groundwater total renewable 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrPotentialReached Agriculture, Infrastructure Irrigation potential (1000 ha) for countries that reached the potential already 2009 AQUASTAT, at http://www.fao.org/nr/water/aquastat/dbase/index.stm 2011/11/16 Yes
SeriesLandCultivatedArea Economic, Infrastructure Cultivated area (1000 ha)
1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIr%Grain Agriculture, Infrastructure % of total grain production irrigated (%)
1984, 1988-1995 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrActual%Equip Agriculture, Infrastructure Area equipped for irrigation: actually irrigated, % 1962, 1967, 1972, 1975, 1977, 1980-1982, 1985, 1987-2012 AQU 2013 BATCH PULL 2013/07/18 No
SeriesLandIrAreaSalinized Agriculture, Infrastructure Area salinized by irrigation (1000 ha)
1972, 1987-1995, 1997-2006, 2009-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWastewaterProduced Economic, Infrastructure Wastewater: produced volume (10^9 m3/yr)
1965, 1967, 1971, 1975, 1979-1980, 1982, 1985, 1987, 1989-2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterResTotalRenew Agriculture, Infrastructure, Environment, Water Water resources: total renewable (actual) 1962, 1967, 1972, 1977, 1982, 1987, 1992-2007, 2011 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterTotalWithdSources Agriculture, Infrastructure, Environment, Water Total water withdrawal (summed by sources) 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesWaterWith%Agric Agriculture, Infrastructure, Environment, Water Water withdrawals, percent used in agriculture (1990=70-99;2000=update, mostly 2000) 1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010 AQU 2013 BATCH PULL 2013/07/18 No
SeriesDesalinatedWater Environment, Infrastructure, Water Desalinated Water Produced 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010 AQUASTAT 2011/01/20 No
SeriesWaterTotalWithd Environment, Infrastructure, Water Total water withdrawal (summed by sector) 1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010 AQUASTAT 2011/01/20 No
SeriesWaterResExploitGround Environment, Infrastructure, Water Exploitable: regular renewable groundwater (10^9 m3/yr) 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL 2014/02/19 No
SeriesWaterResExploitSurface Environment, Infrastructure, Water Exploitable: total renewable surface water (10^9 m3/yr) 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL 2014/02/23 No
SeriesWaterResOverlap Environment, Infrastructure, Water Overlap between surface and groundwater 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL 2014/02/19 No
SeriesWaterResTotalRenewGround Environment, Infrastructure, Water Total renewable groundwater (actual) (10^9 m3/yr) 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL 2014/02/19 No
SeriesWaterResTotalRenewSurface Environment, Infrastructure, Water Total renewable suface water (actual) 1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011 AQU 2014 BATCH PULL 2014/02/19 No

AquaStat Documentation:

First, I had to adjust the Datadict. I went to the Datadict and filtered for all series that came from Aquastat. I then compared the Series codes to what was being downloaded from the aquastat database (Download from the Flat option, not table). Most codes needed to be changed in the datadict. I also added some series to the datadict. The following series were added:

Direct use of not treated municipal wastewater for irrigation purposes 

Irrigated crop intensity 

Area equipped for irrigation by surface water 

Area equipped for irrigation by groundwater 

Area equipped for irrigation by mixed surface water and groundwater 

Area equipped for irrigation by direct use of treated municipal wastewater 

Area equipped for irrigation by direct use of non-treated municipal wastewater 

Area equipped for irrigation by direct use of agricultural drainage water 

Area equipped for irrigation by desalinated water

Irrigation water withdrawal

Irrigation water requirement

Direct use of treated municipal wastewater for irrigation purposes

area equipped for irrigation: actually irrigated

area equipped for full control irrigation: total

Area equipped for full control irrigation: actually irrigated

 

The FAO Countries translation needed to be adjusted. China, Sudan, and North Sudan were all adjusted.

When uploading data from excel to Ifs: You can only download so many variables from the database at one time. I uploaded data in shifts. In Ifs, you need to uncheck data that has already been updated.

There were a few series that were not updated, as there was no new data for them on the database. These include:

LandIrEquipDesalinated

LandIrEquipDirectAg

LandIrHarvest%Equip

LandIrHarvest%FullControl

LandIrPotentialReached (There’s a note in the datadict here)