Aquastat data: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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]<span style="font-size:medium;">&nbsp;</span>
Back to [[Water_preprocessor|water preprocessor]]&nbsp;


The AQUASTAT database can be queried on-line and the query results can be downloaded in CSV (table or flat) format. The current database regroups data per 5-year period and shows for each variable the value for the most recent year during that period, if available. For example, if for the period 2003-2007 data are available for the year 2004 and for the year 2006, then the value for the year 2006 is shown. Also, for many variables no time series can be made available yet due to lack of sufficient data. Data collection began in 1958.<br/><br/>Data for the variable [4313] "Area equipped for irrigation: total" is collected by and available in both AQUASTAT and FAOSTAT and harmonization between AQUASTAT and FAOSTAT takes place on a regular basis to ensure consistency between the two. The difference between the two is that AQUASTAT only enters data for the year given in the reference, while FAOSTAT fills all years from 1961 onwards by inter- and extrapolation from the common data-points. Thus, time series on this variable can be found under&nbsp;[http://faostat3.fao.org/download/E/EL/E FAOSTAT land], choosing the last variable in "items": Total area equipped for irrigation. For other non-water related time-series on food and agriculture see the&nbsp;[http://faostat3.fao.org/home/E FAOSTAT home page].
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]


= Metadata =
= Current status =


== Update Frequency ==
Needs to be pulled. Link to task on teamwork: [https://pardeecenter.teamwork.com/tasks/3797325 https://pardeecenter.teamwork.com/tasks/3797325]


==== Varies by Main Database category and sub-category: ====
= <br/>Series pulled from Aquastat =


#Geography and population category: Every year (through FAOSTAT for land use and population and undernourishment, World Bank for GDP, UNDP for HDI and GII).
{| cellspacing="0" border="1" bgcolor="#ffffff"
#Water resources category: These are long-term average annual values and therefore remain the same over the years. A comprehensive review had been undertaken in 2014.
|+
#Water use category and Irrigation and drainage development category: For Africa, Southern and Central America & Caribbean, and Asia: between 1 and 10 years, depending on data availability which is checked at least every 5 years for each country, and with a thorough update (full dataset) every 10 years together with the country profile update. For Europe, Northern America, Australia and New Zealand: depends on data availability from Eurostat and OECD.
|-
#Updates of data for some specific sub-categories are being done in collaboration with others, as and when data become available, such as: wastewater sub-category in collaboration with IWMI; conservation agriculture sub-category in collaboration with Conservation Agriculture expert groups; access to improved drinking water source sub-category data are provided by the WHO/UNICEF Joint Monitoring Programme for Water Supply and Sanitation.
! bgcolor="#c0c0c0" style="text-align: left;" | <font color="#000000" style="font-size: 11pt;" face="calibri">Table</font><br/>
#Some of the variables are updated during major review exercises (see the other datasets below).
! bgcolor="#c0c0c0" style="text-align: left;" | <font color="#000000" style="font-size: 11pt;" face="calibri">Group</font>
! bgcolor="#c0c0c0" style="text-align: left;" | <font color="#000000" style="font-size: 11pt;" face="calibri">Definition</font>
! bgcolor="#c0c0c0" style="text-align: left;" | <font color="#000000" style="font-size: 11pt;" face="calibri">Years</font>
! bgcolor="#c0c0c0" style="text-align: left;" | <font color="#000000" style="font-size: 11pt;" face="calibri">Source</font>
! bgcolor="#c0c0c0" style="text-align: left;" | <font color="#000000" style="font-size: 11pt;" face="calibri">Last IFs Update</font>
! bgcolor="#c0c0c0" style="text-align: left;" | <font color="#000000" style="font-size: 11pt;" face="calibri">UsedInPreprocessor</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterWith%Household</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Water withdrawals, percent used by households (1990=70-99;2000=update, mostly 2000)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterWith%Ind</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Water withdrawals, percent used in industry (1990=70-99;2000=update, mostly 2000)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrEquip%WaterManaged</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">% of agricultural water managed area equipped for irrigation (%)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterGroundEntering</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Infrastructure, Water, Health</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Groundwater entering the country (natural)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterTotalWithdPC</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total water withdrawal per capita</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterWith%Fresh</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">% of total actual renewable freshwater resources withdrawn (%)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1987, 1990-1997, 1999-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterDesalinated</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Desalinated Water Produced</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1988-1997, 1999-2008, 2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQUASTAT</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2011/01/20</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterGroundWithD</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Ground Water Withdrawal</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1980, 1985, 1987-1990, 1992-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterSurfaceWithD</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Surface Water Withdrawal</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1980, 1985, 1987-1990, 1992-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrEquip%Cultivated</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">% of cultivated area equipped for irrigation (%)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrEquip%Potential</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">% of irrigation potential equipped for irrigation (%)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1970, 1972, 1975, 1977, 1979-1980, 1982-1985, 1987-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrEquipActual</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Area equipped for irrigation: actually irrigated (1000 ha)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1975, 1977, 1980, 1982-1983, 1985-2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrEquipDrained</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Area equipped for irrigation drained (1000 ha)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1985, 1987, 1990-2006, 2008-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrHarvest%Equip</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Economic, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Harvested irrigated crop area as&nbsp;% of area equipped for full control irrigation (%)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1984, 1987, 1989-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrHarvest%FullControl</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Economic, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Harvested irrigated crop area as&nbsp;% of full control irrigation area actually irrigated (%)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1989-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrPotential</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Irrigation potential (1000 ha)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2005, 2007-2008, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Yes</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrAreaEquip</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Area equipped for irrigation: total (1000 ha)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrWaterLogged</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Area waterlogged by irrigation (1000 ha)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1990-1993, 1995, 1997-2000, 2002-2007</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesTotalDamCapacity</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Economic, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total dam capacity (km3)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1960, 1965, 1970, 1975, 1977, 1980, 1984-1985, 1989-1998, 2000-2008, 2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrHarvestedCropArea</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total harvested irrigated crop area (1000 ha)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1961, 1966, 1971-1972, 1975-1977, 1980-1982, 1984-1985, 1987-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWasterwaterTreated</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Economic, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Wastewater: treated volume (10^9 m3/yr)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1967, 1971, 1975, 1979-1980, 1982, 1985, 1987, 1989-2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWastewaterTreatedReused</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Economic, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Treated wastewater reused (10^9 m3/yr)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1971-1972, 1975, 1977, 1982, 1985, 1987, 1989-1998, 2000-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterTotalWithdSector</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total water withdrawal (summed by sector)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1988-1997, 1999-2006</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQUASTAT</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2010/02/20</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterDependencyRatio</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Dependency ratio, percentage of total renewable water resources originating outside of the country</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterResTotalExploit</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Water resources: total exploitable</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997-1998, 2000-2003, 2005, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterTotalAgManagedArea</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total agricultural water managed area</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1964-1967, 1970, 1972, 1974-1975, 1977, 1979-1980, 1982-1985, 1987-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterTotalRenewPC</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Water resources: total renewable per capita (actual)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterWithAgr%FreshAquastat</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">% of total actual renewable water resources withdrawn by agriculture (%)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1988-2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterWithdAgriculture</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agricultural water withdrawal</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1965, 1969-1970, 1974-1975, 1979-1980, 1982, 1984-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterWithdIndustrial</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Industrial water withdrawal</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1965, 1970, 1974-1975, 1979-1980, 1982, 1984-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterWithdMunicipal</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Municipal water withdrawal</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1965, 1970, 1974-1975, 1979-1980, 1982, 1984-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterGroundLeaving</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Infrastructure, Water, Health</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Groundwater leaving the country (naturally)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterGroundProdInternal</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Infrastructure, Water, Health</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Groundwater produced internally (natural)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterGroundTotal</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Infrastructure, Water, Health</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Groundwater total renewable</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrPotentialReached</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Irrigation potential (1000 ha) for countries that reached the potential already</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2009</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQUASTAT, at [http://www.fao.org/nr/water/aquastat/dbase/index.stm http://www.fao.org/nr/water/aquastat/dbase/index.stm]</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2011/11/16</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Yes</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandCultivatedArea</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Economic, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Cultivated area (1000 ha)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIr%Grain</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">% of total grain production irrigated (%)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1984, 1988-1995</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrActual%Equip</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Area equipped for irrigation: actually irrigated,&nbsp;%</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1975, 1977, 1980-1982, 1985, 1987-2012</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesLandIrAreaSalinized</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Area salinized by irrigation (1000 ha)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1972, 1987-1995, 1997-2006, 2009-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWastewaterProduced</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Economic, Infrastructure</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Wastewater: produced volume (10^9 m3/yr)</font><br/>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1965, 1967, 1971, 1975, 1979-1980, 1982, 1985, 1987, 1989-2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterResTotalRenew</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Water resources: total renewable (actual)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992-2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterTotalWithdSources</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total water withdrawal (summed by sources)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterWith%Agric</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Agriculture, Infrastructure, Environment, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Water withdrawals, percent used in agriculture (1990=70-99;2000=update, mostly 2000)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1965, 1970, 1975, 1979-1980, 1982, 1984-1997, 1999-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2013 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2013/07/18</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesDesalinatedWater</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Desalinated Water Produced</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQUASTAT</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2011/01/20</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterTotalWithd</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total water withdrawal (summed by sector)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1965, 1970, 1975-1976, 1979-1980, 1982, 1984-1997, 1999-2010</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQUASTAT</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2011/01/20</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterResExploitGround</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Exploitable: regular renewable groundwater (10^9 m3/yr)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2014 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2014/02/19</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterResExploitSurface</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Exploitable: total renewable surface water (10^9 m3/yr)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2014 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2014/02/23</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterResOverlap</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Overlap between surface and groundwater</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2014 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2014/02/19</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterResTotalRenewGround</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total renewable groundwater (actual) (10^9 m3/yr)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2014 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2014/02/19</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|- valign="top"
| <font color="#000000" style="font-size: 11pt;" face="calibri">SeriesWaterResTotalRenewSurface</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Environment, Infrastructure, Water</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">Total renewable suface water (actual)</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">1962, 1967, 1972, 1977, 1982, 1987, 1992, 1997, 2002, 2007, 2011</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">AQU 2014 BATCH PULL</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">2014/02/19</font>
| <font color="#000000" style="font-size: 11pt;" face="calibri">No</font>
|}


== AquaStat Questionnaires&nbsp;and Guidelines ==
<span style="font-size:larger;">'''AquaStat Documentation:'''</span>


AQUASTAT uses questionnaires and prepares guidelines with detailed definitions and instructions, implements projects to strengthen national capacities, and holds workshops to clarify some of the more complex data concepts. Survey information is as follows:
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:


To reach the above objective, it has been decided to proceed as follows, with two surveys:
{| 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;


*Every 5-10 years: a detailed global survey to prepare/update country profiles and regional syntheses. This document refers to this survey, which is prepared on the basis of a detailed questionnaire filled in at country level by national and regional experts, under the supervision of FAO/NRL.
|-
*Every year: a small global survey to ensure regular updating of the existing country profiles, of key changes at country level, especially on the area equipped for irrigation and on the institutional and policy aspects. It is done by concerned institutions, which are willing to participate, and is managed in the regional and central offices of FAO.
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigated crop intensity&nbsp;


The 5-10 year survey aims at preparing national country profiles in a homogeneous way. It ensures participation of national experts, in charge of the information collection and report drafting at the country level, and validation by FAO experts. The experts are provided with:
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by surface water&nbsp;


*A detailed questionnaire to be completed for each country at national level (and sub-national level for some variables) on the basis of existing available information
|-
*Detailed guidelines for preparing a country profile and gathering qualitative information
| nowrap="nowrap" style="width:525px;height:20px;" |
*Explanatory notes and definitions to ensure consistency in the use of concepts and words and facilitate computation
Area equipped for irrigation by groundwater&nbsp;


=== Costs ===
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by mixed surface water and groundwater&nbsp;


Costs should be expressed in US$ (United States Dollars) in the questionnaire and country profiles. The conversion used to pass from the local currency to US$ should be the one that was valid in the year to which the value refers and should be indicated in the comments.&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of treated municipal wastewater&nbsp;


== Definitions ==
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of non-treated municipal wastewater&nbsp;


Definitions for every series can be found in this document:&nbsp;[http://www.fao.org/nr/water/aquastat/sets/aq-5yr-guide_eng.pdf&nbsp http://www.fao.org/nr/water/aquastat/sets/aq-5yr-guide_eng.pdf&nbsp];
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by direct use of agricultural drainage water&nbsp;


== DataDict ==
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Area equipped for irrigation by desalinated water


'''Variable: '''Names were not changed from previous years this data was pulled. New variables were&nbsp;assigned names that are consistent with variables of similar topics.
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigation water withdrawal


'''Table: '''These were not changed from previous years this data was pulled. New variables were assigned based on the variable title and consistency.
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Irrigation water requirement


'''Groups: '''These were not changed from previous years this data was pulled. New variables were assigned groups based on consistency with variables of similar topics. New Irrigation series were given groups: Agriculture, Infrastructure, Water.&nbsp;
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
Direct use of treated municipal wastewater for irrigation purposes


'''Subgroups: '''These were not changed form previoys years this data was pulled. New Irrigation data was given the Subgroup: Irrigation.
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
area equipped for irrigation: actually irrigated


'''Definitions and Units:''' This categories were not changed from previous years. New variables were given definitions based on the consise definitions provided in the AquaStat database. Units were also provided in the data base.
|-
| nowrap="nowrap" style="width:525px;height:20px;" |
area equipped for full control irrigation: total


'''Years: '''Years for every series were changed to available data provided through the database. Years vary between different series. The aquastat database calculates years in 5 year incriments. This five year incriments go back to 1958. The most recent incriment is 2013-2017. In the datadict, these incrimental periods are not used. Instead, only actual data recorded for the earliest&nbsp;specific year to the last specific year is used.
'''Source:''' Source for all AquaStat series were given AQU BATCH PULL.
'''Original Source:''' The original source for all series is the AquaStat database.
Notes and Last IFs Update were updated accordingly.
'''Aggregation: '''Aggregations were not changed from pervious updates. New variables were assigned aggregations based on the type of variable and the Units used.
'''Disaggregation''' was consistently GDP.
'''Name in source''' is based on the name each variable was given in the AquaStat database.
'''Code in Source: '''All codes were changed to match the exact variable names present when downloading the data from the database. The downloaded names were different from the name in source.
'''Decimal places: '''This category was left blank in order to avoid rounding exact data.
'''Country Concordance: '''FAO countries were used.
== Series Updated ==
<p style="text-align: center;"></p>
{| border="1" bgcolor="#ffffff" cellspacing="0"
|+ '''DataDict'''
|-
|-
! bgcolor="#c0c0c0" style="text-align: left;" | <font face="Calibri" color="#000000">Variable</font>
| nowrap="nowrap" style="width:525px;height:20px;" |  
|- valign="TOP"
Area equipped for full control irrigation: actually irrigated
| <font face="Calibri" color="#000000">DesalinatedWater</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">IrrigatedCropIntensity</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">IrWaterReq</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">IrWaterWith</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandCultivatedArea</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandEquipIrActual</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandEquipIrFullControl</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandEquipIrFullControlActual</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIr%Grain</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrAreaSalinized</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrEquipDrained</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrEquipGround</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrHarvestedCropArea</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrWaterLogged</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">TotalDamCapacity</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WasterwaterTreated</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WasteWaterDirectNotTreated</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WastewaterIrDirectTreated</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WasteWaterLandEquipDirectNotTreated</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WasteWaterLandEquipDirectTreated</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WastewaterProduced</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WastewaterTreatedReused</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterDependencyRatio</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterDesalinated</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterGroundEntering</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterGroundLeaving</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterGroundProdInternal</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterGroundTotal</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterGroundWithD</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterResExploitGround</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterResExploitSurface</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterResOverlap</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterResTotalExploit</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterResTotalRenew</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterResTotalRenewGround</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterResTotalRenewSurface</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterSurfaceWithD</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterTotalRenewPC</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterTotalWithd</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterTotalWithdPC</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterTotalWithdSector</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterTotalWithdSources</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterWith%Agric</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterWith%Fresh</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterWith%Household</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterWith%Ind</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterWithAgr%FreshAquastat</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterWithdAgriculture</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterWithdIndustrial</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterWithdMunicipal</font>
|}


== Series that will soon be updated ==
{| border="1" bgcolor="#ffffff" cellspacing="0"
|+ '''DataDict'''
|-
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Variable</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrActual%Equip</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrAreaEquip</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrEquip%Cultivated</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrEquip%Potential</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrEquip%WaterManaged</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrEquipActual</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrEquipMixed</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrEquipSurface</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">LandIrPotential</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">WaterTotalAgManagedArea</font>
|}
|}


&nbsp;


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


== New Series added ==
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.


*Direct use of not treated municipal wastewater for irrigation purposes&nbsp;
There were a few series that were not updated, as there was no new data for them on the database. These include:
*Irrigated crop intensity&nbsp;
*Area equipped for irrigation by surface water&nbsp;
*Area equipped for irrigation by groundwater&nbsp;
*Area equipped for irrigation by mixed surface water and groundwater&nbsp;
*Area equipped for irrigation by direct use of treated municipal wastewater&nbsp;
*Area equipped for irrigation by direct use of non-treated municipal wastewater&nbsp;
*Area equipped for irrigation by direct use of agricultural drainage water&nbsp;
*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
 
== Preprocessor Series ==
 
Unknown since the model is currently in development
 
== Country Coverage ==
 
Every country, with&nbsp;the exception of Kosovo, is included in the database. However, available data for each country varies by series.
 
{| border="1" bgcolor="#ffffff" cellspacing="0"
|+ '''FAO Country Translation'''
|-
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">IFs Countries</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">FAO Countries</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">United Arab Emirates</font>
| <font face="Calibri" color="#000000">United Arab Emirates</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Afghanistan</font>
| <font face="Calibri" color="#000000">Afghanistan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Albania</font>
| <font face="Calibri" color="#000000">Albania</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Armenia</font>
| <font face="Calibri" color="#000000">Armenia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Angola</font>
| <font face="Calibri" color="#000000">Angola</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Argentina</font>
| <font face="Calibri" color="#000000">Argentina</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Austria</font>
| <font face="Calibri" color="#000000">Austria</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Australia</font>
| <font face="Calibri" color="#000000">Australia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Azerbaijan</font>
| <font face="Calibri" color="#000000">Azerbaijan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Bosnia and Herzegovina</font>
| <font face="Calibri" color="#000000">Bosnia and Herzegovina</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Barbados</font>
| <font face="Calibri" color="#000000">Barbados</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Bangladesh</font>
| <font face="Calibri" color="#000000">Bangladesh</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Belgium</font>
| <font face="Calibri" color="#000000">Belgium</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Burkina Faso</font>
| <font face="Calibri" color="#000000">Burkina Faso</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Bulgaria</font>
| <font face="Calibri" color="#000000">Bulgaria</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Bahrain</font>
| <font face="Calibri" color="#000000">Bahrain</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Burundi</font>
| <font face="Calibri" color="#000000">Burundi</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Benin</font>
| <font face="Calibri" color="#000000">Benin</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Brunei</font>
| <font face="Calibri" color="#000000">Brunei Darussalam</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Bolivia</font>
| <font face="Calibri" color="#000000">Bolivia (Plurinational State of)</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Brazil</font>
| <font face="Calibri" color="#000000">Brazil</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Bahamas, The</font>
| <font face="Calibri" color="#000000">Bahamas</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Bhutan</font>
| <font face="Calibri" color="#000000">Bhutan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Botswana</font>
| <font face="Calibri" color="#000000">Botswana</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Belarus</font>
| <font face="Calibri" color="#000000">Belarus</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Belize</font>
| <font face="Calibri" color="#000000">Belize</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Canada</font>
| <font face="Calibri" color="#000000">Canada</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Congo, Democratic Republic of</font>
| <font face="Calibri" color="#000000">Democratic Republic of the Congo</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Central African Republic</font>
| <font face="Calibri" color="#000000">Central African Republic</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Congo, Republic of</font>
| <font face="Calibri" color="#000000">Congo</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Switzerland</font>
| <font face="Calibri" color="#000000">Switzerland</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Cote d'Ivoire</font>
| <font face="Calibri" color="#000000">Côte d'Ivoire</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Chile</font>
| <font face="Calibri" color="#000000">Chile</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Cameroon</font>
| <font face="Calibri" color="#000000">Cameroon</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">China</font>
| <font face="Calibri" color="#000000">China</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Colombia</font>
| <font face="Calibri" color="#000000">Colombia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Costa Rica</font>
| <font face="Calibri" color="#000000">Costa Rica</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Cuba</font>
| <font face="Calibri" color="#000000">Cuba</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Cape Verde</font>
| <font face="Calibri" color="#000000">Cabo Verde</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Cyprus</font>
| <font face="Calibri" color="#000000">Cyprus</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Czech Republic</font>
| <font face="Calibri" color="#000000">Czech Republic</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Germany</font>
| <font face="Calibri" color="#000000">Germany</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Djibouti</font>
| <font face="Calibri" color="#000000">Djibouti</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Denmark</font>
| <font face="Calibri" color="#000000">Denmark</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Dominican Republic</font>
| <font face="Calibri" color="#000000">Dominican Republic</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Algeria</font>
| <font face="Calibri" color="#000000">Algeria</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Ecuador</font>
| <font face="Calibri" color="#000000">Ecuador</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Estonia</font>
| <font face="Calibri" color="#000000">Estonia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Egypt, Arab Republic of</font>
| <font face="Calibri" color="#000000">Egypt</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Eritrea</font>
| <font face="Calibri" color="#000000">Eritrea</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Spain</font>
| <font face="Calibri" color="#000000">Spain</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Ethiopia</font>
| <font face="Calibri" color="#000000">Ethiopia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Finland</font>
| <font face="Calibri" color="#000000">Finland</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Fiji</font>
| <font face="Calibri" color="#000000">Fiji</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Micronesia, Fed. Sts.</font>
| <font face="Calibri" color="#000000">Micronesia (Federated States of)</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">France</font>
| <font face="Calibri" color="#000000">France</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Gabon</font>
| <font face="Calibri" color="#000000">Gabon</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">United Kingdom</font>
| <font face="Calibri" color="#000000">United Kingdom</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Grenada</font>
| <font face="Calibri" color="#000000">Grenada</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Georgia</font>
| <font face="Calibri" color="#000000">Georgia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Ghana</font>
| <font face="Calibri" color="#000000">Ghana</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Gambia, The</font>
| <font face="Calibri" color="#000000">Gambia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Guinea</font>
| <font face="Calibri" color="#000000">Guinea</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Equatorial Guinea</font>
| <font face="Calibri" color="#000000">Equatorial Guinea</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Greece</font>
| <font face="Calibri" color="#000000">Greece</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Guatemala</font>
| <font face="Calibri" color="#000000">Guatemala</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Guinea-Bissau</font>
| <font face="Calibri" color="#000000">Guinea-Bissau</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Guyana</font>
| <font face="Calibri" color="#000000">Guyana</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Hong Kong</font>
| <font face="Calibri" color="#000000">China, Hong Kong SAR</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Honduras</font>
| <font face="Calibri" color="#000000">Honduras</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Croatia</font>
| <font face="Calibri" color="#000000">Croatia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Haiti</font>
| <font face="Calibri" color="#000000">Haiti</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Hungary</font>
| <font face="Calibri" color="#000000">Hungary</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Indonesia</font>
| <font face="Calibri" color="#000000">Indonesia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Ireland</font>
| <font face="Calibri" color="#000000">Ireland</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Israel</font>
| <font face="Calibri" color="#000000">Israel</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">India</font>
| <font face="Calibri" color="#000000">India</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Iraq</font>
| <font face="Calibri" color="#000000">Iraq</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Iran, Islamic Republic of</font>
| <font face="Calibri" color="#000000">Iran (Islamic Republic of)</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Iceland</font>
| <font face="Calibri" color="#000000">Iceland</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Italy</font>
| <font face="Calibri" color="#000000">Italy</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Jamaica</font>
| <font face="Calibri" color="#000000">Jamaica</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Jordan</font>
| <font face="Calibri" color="#000000">Jordan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Japan</font>
| <font face="Calibri" color="#000000">Japan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Kenya</font>
| <font face="Calibri" color="#000000">Kenya</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Kyrgyz Republic</font>
| <font face="Calibri" color="#000000">Kyrgyzstan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Cambodia</font>
| <font face="Calibri" color="#000000">Cambodia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Comoros</font>
| <font face="Calibri" color="#000000">Comoros</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Kosovo</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">Korea, Democratic People's Republic of</font>
| <font face="Calibri" color="#000000">Democratic People's Republic of Korea</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Korea, Republic of</font>
| <font face="Calibri" color="#000000">Republic of Korea</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Kuwait</font>
| <font face="Calibri" color="#000000">Kuwait</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Kazakhstan</font>
| <font face="Calibri" color="#000000">Kazakhstan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Laos, People's Democratic Republic</font>
| <font face="Calibri" color="#000000">Lao People's Democratic Republic</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Lebanon</font>
| <font face="Calibri" color="#000000">Lebanon</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">St. Lucia</font>
| <font face="Calibri" color="#000000">Saint Lucia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Sri Lanka</font>
| <font face="Calibri" color="#000000">Sri Lanka</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Liberia</font>
| <font face="Calibri" color="#000000">Liberia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Lesotho</font>
| <font face="Calibri" color="#000000">Lesotho</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Lithuania</font>
| <font face="Calibri" color="#000000">Lithuania</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Luxembourg</font>
| <font face="Calibri" color="#000000">Luxembourg</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Latvia</font>
| <font face="Calibri" color="#000000">Latvia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Libya</font>
| <font face="Calibri" color="#000000">Libya</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Morocco</font>
| <font face="Calibri" color="#000000">Morocco</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Moldova</font>
| <font face="Calibri" color="#000000">Republic of Moldova</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Montenegro</font>
| <font face="Calibri" color="#000000">Montenegro</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Madagascar</font>
| <font face="Calibri" color="#000000">Madagascar</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Macedonia, Former Yugoslav Republic of</font>
| <font face="Calibri" color="#000000">The former Yugoslav Republic of Macedonia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Mali</font>
| <font face="Calibri" color="#000000">Mali</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Myanmar</font>
| <font face="Calibri" color="#000000">Myanmar</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Mongolia</font>
| <font face="Calibri" color="#000000">Mongolia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Mauritania</font>
| <font face="Calibri" color="#000000">Mauritania</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Malta</font>
| <font face="Calibri" color="#000000">Malta</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Mauritius</font>
| <font face="Calibri" color="#000000">Mauritius</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Maldives</font>
| <font face="Calibri" color="#000000">Maldives</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Malawi</font>
| <font face="Calibri" color="#000000">Malawi</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Mexico</font>
| <font face="Calibri" color="#000000">Mexico</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Malaysia</font>
| <font face="Calibri" color="#000000">Malaysia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Mozambique</font>
| <font face="Calibri" color="#000000">Mozambique</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Namibia</font>
| <font face="Calibri" color="#000000">Namibia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Niger</font>
| <font face="Calibri" color="#000000">Niger</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Nigeria</font>
| <font face="Calibri" color="#000000">Nigeria</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Nicaragua</font>
| <font face="Calibri" color="#000000">Nicaragua</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Netherlands</font>
| <font face="Calibri" color="#000000">Netherlands</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Norway</font>
| <font face="Calibri" color="#000000">Norway</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Nepal</font>
| <font face="Calibri" color="#000000">Nepal</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">New Zealand</font>
| <font face="Calibri" color="#000000">New Zealand</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Oman</font>
| <font face="Calibri" color="#000000">Oman</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Panama</font>
| <font face="Calibri" color="#000000">Panama</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Peru</font>
| <font face="Calibri" color="#000000">Peru</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Papua New Guinea</font>
| <font face="Calibri" color="#000000">Papua New Guinea</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Philippines</font>
| <font face="Calibri" color="#000000">Philippines</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Pakistan</font>
| <font face="Calibri" color="#000000">Pakistan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Poland</font>
| <font face="Calibri" color="#000000">Poland</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Puerto Rico</font>
| <font face="Calibri" color="#000000">Puerto Rico</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Palestine</font>
| <font face="Calibri" color="#000000">Occupied Palestinian Territory</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Portugal</font>
| <font face="Calibri" color="#000000">Portugal</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Paraguay</font>
| <font face="Calibri" color="#000000">Paraguay</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Qatar</font>
| <font face="Calibri" color="#000000">Qatar</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Romania</font>
| <font face="Calibri" color="#000000">Romania</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Serbia</font>
| <font face="Calibri" color="#000000">Serbia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Russian Federation</font>
| <font face="Calibri" color="#000000">Russian Federation</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Rwanda</font>
| <font face="Calibri" color="#000000">Rwanda</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Saudi Arabia</font>
| <font face="Calibri" color="#000000">Saudi Arabia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Solomon Islands</font>
| <font face="Calibri" color="#000000">Solomon Islands</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Seychelles</font>
| <font face="Calibri" color="#000000">Seychelles</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Sudan</font>
| <font face="Calibri" color="#000000">Sudan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Sweden</font>
| <font face="Calibri" color="#000000">Sweden</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Singapore</font>
| <font face="Calibri" color="#000000">Singapore</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Slovenia</font>
| <font face="Calibri" color="#000000">Slovenia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Slovak Republic</font>
| <font face="Calibri" color="#000000">Slovakia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Sierra Leone</font>
| <font face="Calibri" color="#000000">Sierra Leone</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Senegal</font>
| <font face="Calibri" color="#000000">Senegal</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Somalia</font>
| <font face="Calibri" color="#000000">Somalia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Suriname</font>
| <font face="Calibri" color="#000000">Suriname</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Sudan South</font>
| <font face="Calibri" color="#000000">South Sudan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Sao Tome and Principe</font>
| <font face="Calibri" color="#000000">Sao Tome and Principe</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">El Salvador</font>
| <font face="Calibri" color="#000000">El Salvador</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Syrian Arab Republic</font>
| <font face="Calibri" color="#000000">Syrian Arab Republic</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Swaziland</font>
| <font face="Calibri" color="#000000">Swaziland</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Chad</font>
| <font face="Calibri" color="#000000">Chad</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Togo</font>
| <font face="Calibri" color="#000000">Togo</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Thailand</font>
| <font face="Calibri" color="#000000">Thailand</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Tajikistan</font>
| <font face="Calibri" color="#000000">Tajikistan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Timor-Leste</font>
| <font face="Calibri" color="#000000">Timor-Leste</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Turkmenistan</font>
| <font face="Calibri" color="#000000">Turkmenistan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Tunisia</font>
| <font face="Calibri" color="#000000">Tunisia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Tonga</font>
| <font face="Calibri" color="#000000">Tonga</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Turkey</font>
| <font face="Calibri" color="#000000">Turkey</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Trinidad and Tobago</font>
| <font face="Calibri" color="#000000">Trinidad and Tobago</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Taiwan, China</font>
| <font face="Calibri" color="#000000">China, Taiwan Province of</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Tanzania</font>
| <font face="Calibri" color="#000000">United Republic of Tanzania</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Ukraine</font>
| <font face="Calibri" color="#000000">Ukraine</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Uganda</font>
| <font face="Calibri" color="#000000">Uganda</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">United States</font>
| <font face="Calibri" color="#000000">United States of America</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Uruguay</font>
| <font face="Calibri" color="#000000">Uruguay</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Uzbekistan</font>
| <font face="Calibri" color="#000000">Uzbekistan</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">St. Vincent and the Grenadines</font>
| <font face="Calibri" color="#000000">Saint Vincent and the Grenadines</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Venezuela</font>
| <font face="Calibri" color="#000000">Venezuela (Bolivarian Republic of)</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Vietnam</font>
| <font face="Calibri" color="#000000">Viet Nam</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Vanuatu</font>
| <font face="Calibri" color="#000000">Vanuatu</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Samoa</font>
| <font face="Calibri" color="#000000">Samoa</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Yemen, Republic of</font>
| <font face="Calibri" color="#000000">Yemen</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">South Africa</font>
| <font face="Calibri" color="#000000">South Africa</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Zambia</font>
| <font face="Calibri" color="#000000">Zambia</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">Zimbabwe</font>
| <font face="Calibri" color="#000000">Zimbabwe</font>
|}
 
= Instructions =
 
#Download the data from the Aquastat Database.&nbsp;[http://www.fao.org/nr/water/aquastat/data/query/index.html?lang=en http://www.fao.org/nr/water/aquastat/data/query/index.html?lang=en]. Select all countries and all years. There are too many variables to download all variables at once. Divide the variables by topics (ie geography and population, water resources, etc) download this data via the "Flat" option.
#Change the codes in the Datadict&nbsp;for every variable downloaded in this Excel file. The codes need to match to match the variables listed in the downloaded data exactly.&nbsp;
#Check to ensure no changes are needed in the FAO Country translation. In the most recent update&nbsp;China, Sudan and South Sudan all needed to be updated.
#Upload data in IFs using the batch pool option. There will be multiple excel sheets, as the AquaStat data cannot download all variables at once. After the first excel sheet is updated, unselect data that was imported; otherwise this data will be uploaded again with a new excel sheet, and you will lose the already imported data.
#Vet. The most recent update reveiled errors in data in some series. You may need extensive vetting.
#Some series do not contain enough data in the database to be updated. These include:


LandIrEquipDesalinated
LandIrEquipDesalinated
Line 816: Line 504:
LandIrHarvest%FullControl
LandIrHarvest%FullControl


LandIrPotentialReached&nbsp;
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)

 

Retrieved from "https://pardeewiki.du.edu//index.php?title=Aquastat_data&oldid=718"