Infrastructure preprocessor: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(23 intermediate revisions by one other user not shown)
Line 3: Line 3:
= Sources =
= Sources =


[[World_Development_Indicators|WDI]], [[International_Telecommunications_Union_(ITU)|ITU]], WHO, WSS/JMP
[[World_Development_Indicators|WDI]], [[International_Telecommunications_Union_(ITU)|ITU]], WHO, [[WSS/JMP|WSS/JMP]]


= Infrastructure series pulled into preprocessor  =
= Infrastructure series pulled into preprocessor  =
This table was created using DataDict 7.20 and filtering group by: Information Communication, Infrastructure; Information Communication,Infrastructure;   Information Communication, Infrastructure, Trade; Infrastructure, Water, Health; Science technology, infrastructure, Knowledge; and Transportation, Infrastructure.


{| cellspacing="0" border="1" bgcolor="#ffffff"
{| cellspacing="0" border="1" bgcolor="#ffffff"
|+ <font face="calibri" color="#000000">'''DataDict 720'''</font>
|+ '''Copy Of DataDict'''
|-
|-
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Table</font>
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Table</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Group</font>
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Source</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Definition</font>
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">Last IFs Update</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Source</font>
! bgcolor="#c0c0c0" | <font style="font-size: 11pt;" face="calibri" color="#000000">UsedInPreprocessorFileName</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Last IFs Update</font>
|- valign="top"
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">UsedInPreprocessor</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLandIrPotential</font>
! bgcolor="#c0c0c0" | <font face="calibri" color="#000000">Years</font>
| [[Aquastat_data|<span style="color: rgb(0, 0, 255);"><font style="font-size: 11pt;" face="calibri">AQU BATCH PULL</font></span>]]<br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/06/06</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">SeriesLandIrPotentialReached</span></font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">AQUASTAT, at </span>[http://www.fao.org/nr/water/aquastat/dbase/index.stm <span style="background-color: rgb(255, 255, 0);">http://www.fao.org/nr/water/aquastat/dbase/index.stm</span>]</font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">2011/11/16</span></font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">INFRA</span></font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnElecAccess%Urban</font>
| [[World_Development_Indicators|<span style="color: rgb(0, 0, 255);"><font style="font-size: 11pt;" face="calibri">Data extracted from WDI</font></span>]]<br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/05/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnElecAccess%Rural</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Data extracted from WDI</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/05/10</font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnElecAccess%National</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Data extracted from WDI</font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/05/05</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnElecTotalCapacityEIA</font>
| [[Energy_Information_Administration_(EIA)|<span style="color: rgb(0, 0, 255);"><font style="font-size: 11pt;" face="calibri">EIA; US Energy Information Administration;</font></span>]]<br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/04/22</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">SeriesLandIrAreaEquipFAO</span></font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">FAO</span></font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">2013/12/19</span></font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">INFRA</span></font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLandTotal</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">FAO BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/04/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesLandAgri</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">FAO BATCH PULL</font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/04/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTInternetHousehold%</font>
| [[International_Telecommunications_Union_(ITU)|<span style="color: rgb(0, 0, 255);"><font style="font-size: 11pt;" face="calibri">ITU</font></span>]]<br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/04/14</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">SeriesHouseholds</span></font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">ITU 2011</span></font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">2011/08/19</span></font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">INFRA</span></font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTBroadbandMobileSubsPer100</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ITU 2014 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/02/03</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTComputerHousehold%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ITU 2014 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/01/28</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTBroadbandSubscribersPer100ITU</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ITU 2015</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/05/18</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTTelephoneCellSubscribersPer100</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ITU 2015</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/05/18</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTTelephoneLinesPer100</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ITU 2015</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/05/18</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTCYBICTDevelopmentIndexITU</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">ITU: Measuring the Information Society 2008, 2010-2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/05/10</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesRoadRuralAccessIndex</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">SeriesRoadRuralAccessIndex</span></font><br/>
| <font face="calibri" color="#000000">Transportation,Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">The World Bank Rural Access Index</span></font>
| <font face="calibri" color="#000000">Rural Access Index, proportion of the rural population who live within 2 km (25 minute walk) of all-weather road</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">2010/07/15</span></font>
| <font face="calibri" color="#000000">The World Bank Rural Access Index</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color: rgb(255, 255, 0);">INFRA</span></font>
| <font face="calibri" color="#000000">2010/07/15</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTExpend%GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesPopulation</font>
| <font face="calibri" color="#000000">Information Communication,Infrastructure</font>
| [[United_Nations_Population_Division_(UNPD)|<span style="color: rgb(0, 0, 255);"><font style="font-size: 11pt;" face="calibri">UNPD 2015 (DSR added Taiwan from WEO)</font></span>]]<br/>
| <font face="calibri" color="#000000">ICT technology expenditure,&nbsp;% of GDP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/09/18</font>
| <font face="calibri" color="#000000">WDI CD 2010 and existing IFs data</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2011/05/28</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWasteWaterColConnect%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWasteWaterColConnect%</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">UNSD/ UNEP/ OECD/ EUROSTAT</font><br/>
| <font face="calibri" color="#000000">Percent of population connected to urban wastewater collection system</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011/08/08</font>
| <font face="calibri" color="#000000">UNSD/ UNEP/ OECD/ EUROSTAT</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2011/08/08</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWasteWaterTreatConnect%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWasteWaterTreatConnect%</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">UNSD/ UNEP/ OECD/ EUROSTAT</font><br/>
| <font face="calibri" color="#000000">Percent of population connected to urban wastewater treatment system</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011/08/08</font>
| <font face="calibri" color="#000000">UNSD/ UNEP/ OECD/ EUROSTAT</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2011/08/08</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesR&D%GDPWDI</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesEnvSolidFuels</span></font>
| <font face="calibri" color="#000000">Science Technology, Infrastructure, Knowledge</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">UNSTATS and WHO survey data and missing point estimation by DPHE, WHO and UC Berkley researchers</span></font>
| <font face="calibri" color="#000000">R&D as&nbsp;% of GDP (in some earlier years was GNI)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2013/07/03</span></font>
| <font face="calibri" color="#000000">Constructed from multiple WDI vol;CD incl 01, 02, 04,05,06,07; 2006-2008 Update from UIS Website</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2013/08/07</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTExport%Exp</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnElecConsPerCap</font>
| <font face="calibri" color="#000000">Information Communication,Infrastructure, Trade</font>
| [[World_Development_Indicators|<span style="color:#0000FF;"><font style="font-size: 11pt;" face="calibri">WDI BATCH PULL</font></span>]]
| <font face="calibri" color="#000000">Exports of ICT as&nbsp;% of total exports</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font face="calibri" color="#000000">WDI 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2013/11/08</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTImport%Imp</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnElecTransLoss%</font>
| <font face="calibri" color="#000000">Information Communication,Infrastructure, Trade</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI BATCH PULL</font>
| <font face="calibri" color="#000000">Imports of ICT as&nbsp;% of total imports</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/07/14</font>
| <font face="calibri" color="#000000">WDI 2013</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2013/11/08</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesRoadPavedKm</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesGDP2011PCPPP</span></font>
| <font face="calibri" color="#000000">Transportation,Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">WDI - calculaed from WDI and other sources; extrapolated based on previous GDP_PCPPP2005 values in IFs; extrapolated based on CIA Factbook; taken directly from CIA Factbook; taken directly from previous GDP_PCPPP2005 values in IFs</span></font>
| <font face="calibri" color="#000000">Length of paved roads, kilometers</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2015/09/18</span></font>
| <font face="calibri" color="#000000">WDI 2013; WDI 2011; Calderon (communication to DR) and Canning, David (1998) with updates by Canning from WDI 2006</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2013/12/17</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesRoadsPaved%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesRoadPavedKm</span></font>
| <font face="calibri" color="#000000">Transportation,Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">WDI 2013; WDI 2011; Calderon (communication to DR) and Canning, David (1998) with updates by Canning from WDI 2006</span></font>
| <font face="calibri" color="#000000">Roads, paved as a percent of total roads</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2013/12/17</span></font>
| <font face="calibri" color="#000000">WDI 2014 May BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2014/06/11</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesRoadsTotalNetwork</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesRoadsPaved%</font>
| <font face="calibri" color="#000000">Transportation,Infrastructure</font>
| [[World_Development_Indicators|<span style="color:#0000FF;"><font style="font-size: 11pt;" face="calibri">WDI 2014 May BATCH PULL</font></span>]]
| <font face="calibri" color="#000000">Roads, total network, kilometers</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2014/06/11</font>
| <font face="calibri" color="#000000">WDI 2014 May BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2014/06/11</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesVehiclesper1000</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnConTotalWDI</font>
| <font face="calibri" color="#000000">Transportation,Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2014 May BATCH PULL</font>
| <font face="calibri" color="#000000">Vehicles per 1000 People</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2014/06/11</font>
| <font face="calibri" color="#000000">WDI 2014 May BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2014/06/11</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWHO2012WaterPipedFiltered</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesRoadsTotalNetwork</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2014 May BATCH PULL</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Piped Water to premises which is Filtered or Boiled (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2014/06/11</font>
| <font face="calibri" color="#000000">WHO: provided directly by Annette Pruss-Ustun of the WHO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2014/06/24</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWHO2012WaterPipedNoFilter</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnProdElec</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2014 May BATCH PULL</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Piped Water to premises which is not Filtered or Boiled (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2014/06/11</font>
| <font face="calibri" color="#000000">WHO: provided directly by Annette Pruss-Ustun of the WHO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2014/06/24</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWHO2012WaterOthImpFiltered</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesEnElecShrEnDem</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2014 May BATCH PULL</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Other Improved Water which is Filtered or Boiled (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2014/06/11</font>
| <font face="calibri" color="#000000">WHO: provided directly by Annette Pruss-Ustun of the WHO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2014/06/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWHO2012WaterOthImpNoFilter</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesIncBelow1D25c%WDI2011</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI 2015 March WDI Website</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Other Improved Water which is not Filtered or Boiled (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/03/17</font>
| <font face="calibri" color="#000000">WHO: provided directly by Annette Pruss-Ustun of the WHO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2014/06/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWHO2012WaterUnImpFiltered</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesICTExpend%GDP</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WDI CD 2010 and existing IFs data</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Unimproved Water which is Filtered or Boiled (%). Total Unimproved Water is the sum of Surface and Other Unimproved water access. (This is probably the same as WSSJMP unimproved water)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2011/05/28</font>
| <font face="calibri" color="#000000">WHO: provided directly by Annette Pruss-Ustun of the WHO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2014/06/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWHO2012WaterUnImpNoFilter</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesWHO2012WaterPipedFiltered</span></font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">WHO: provided directly by Annette Pruss-Ustun of the WHO</span></font>
| <font face="calibri" color="#000000">Proportion of Total population served with Unimproved Water which is not Filtered or Boiled (%). Total Unimproved Water is the sum of Surface and Other Unimproved water access. (This is probably the same as WSSJMP unimproved water)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2014/06/24</span></font>
| <font face="calibri" color="#000000">WHO: provided directly by Annette Pruss-Ustun of the WHO</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2014/06/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTTelephoneLinesPer100</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesWHO2012WaterUnImpNoFilter</span></font>
| <font face="calibri" color="#000000">Information Communication, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">WHO: provided directly by Annette Pruss-Ustun of the WHO</span></font>
| <font face="calibri" color="#000000">Fixed telephone lines per 100 inhabitants</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2014/06/25</span></font>
| <font face="calibri" color="#000000">ITU 2014</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2014/06/30</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTBroadbandSubscribersPer100ITU</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesWHO2012WaterUnImpFiltered</span></font>
| <font face="calibri" color="#000000">Information Communication, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">WHO: provided directly by Annette Pruss-Ustun of the WHO</span></font>
| <font face="calibri" color="#000000">Fixed broadband subscriptions per 100 inhabitants</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2014/06/25</span></font>
| <font face="calibri" color="#000000">ITU 2014 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2015/01/28</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTComputerHousehold%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesWHO2012WaterPipedNoFilter</span></font>
| <font face="calibri" color="#000000">Information Communication, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">WHO: provided directly by Annette Pruss-Ustun of the WHO</span></font>
| <font face="calibri" color="#000000">Proportion of households with a computer</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2014/06/24</span></font>
| <font face="calibri" color="#000000">ITU 2014 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2015/01/28</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTTelephoneCellSubscribersPer100</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesWHO2012WaterOthImpFiltered</span></font>
| <font face="calibri" color="#000000">Information Communication, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">WHO: provided directly by Annette Pruss-Ustun of the WHO</span></font>
| <font face="calibri" color="#000000">Mobile cellular subscriptions per 100 inhabitants</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2014/06/25</span></font>
| <font face="calibri" color="#000000">ITU 2014 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2015/01/28</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTBroadbandMobileSubsPer100</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">SeriesWHO2012WaterOthImpNoFilter</span></font>
| <font face="calibri" color="#000000">Information Communication,Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">WHO: provided directly by Annette Pruss-Ustun of the WHO</span></font>
| <font face="calibri" color="#000000">Broadband Mobile, Mobile cellular subscriptions with access to data communication at broadband speed per 100 inhabitants</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">2014/06/25</span></font>
| <font face="calibri" color="#000000">ITU 2014 BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000"><span style="background-color:#FFFF00;">INFRA</span></font>
| <font face="calibri" color="#000000">2015/02/03</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTInternetHousehold%</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovernanceEffect</font>
| <font face="calibri" color="#000000">Information Communication, Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri">[[Worldwide_Governance_Indicators|Worldwide_Governance_Indicators]]</font><font style="font-size: 11pt;" face="calibri" color="#000000">, [http://info.worldbank.org/governance/wgi/index.asp http://info.worldbank.org/governance/wgi/index.asp]</font>
| <font face="calibri" color="#000000">Proportion of households with Internet access at home</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/04/07</font>
| <font face="calibri" color="#000000">ITU</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/04/14</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesICTInternet%Pop</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesGovernanceRegQual</font>
| <font face="calibri" color="#000000">Information Communication,Infrastructure</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">Worldwide Governance Indicators, [http://info.worldbank.org/governance/wgi/index.asp http://info.worldbank.org/governance/wgi/index.asp]</font>
| <font face="calibri" color="#000000">Percent of population on-line</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2016/04/07</font>
| <font face="calibri" color="#000000">WDI BATCH PULL</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/07/14</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWSSJMPSanitationTotal%Improved</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWSSJMPSanitationTotal%Shared</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Improved Sanitation (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/08/25</font>
| <font face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/08/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWSSJMPSanitationTotal%OpenDefecation</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWSSJMPWaterTotal%OtherUnimproved</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Open Defecation Sanitation (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/08/25</font>
| <font face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/08/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWSSJMPSanitationTotal%OtherUnimproved</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWSSJMPWaterTotal%OtherImproved</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font face="calibri" color="#000000">Proportion of Total population with Other Unimproved Sanitation (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/08/25</font>
| <font face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/08/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWSSJMPSanitationTotal%Shared</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWSSJMPSanitationTotal%Improved</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Shared Sanitation (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/08/25</font>
| <font face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/08/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWSSJMPWaterTotal%OtherImproved</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWSSJMPSanitationTotal%OpenDefecation</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Other Improved Water (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/08/25</font>
| <font face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/08/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWSSJMPWaterTotal%OtherUnimproved</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWSSJMPWaterTotal%Surface</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font face="calibri" color="#000000">Proportion of Total population with Other Unimproved Water (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/08/25</font>
| <font face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/08/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWSSJMPWaterTotal%Piped</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWSSJMPSanitationTotal%OtherUnimproved</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font face="calibri" color="#000000">Proportion of Total population served with Piped Water (%)</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/08/25</font>
| <font face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/08/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|- valign="top"
|- valign="top"
| <font face="calibri" color="#000000">SeriesWSSJMPWaterTotal%Surface</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">SeriesWSSJMPWaterTotal%Piped</font>
| <font face="calibri" color="#000000">Infrastructure, Water, Health</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font face="calibri" color="#000000">Proportion of Total population with Surface Water (%)</font><br/>
| <font style="font-size: 11pt;" face="calibri" color="#000000">2015/08/25</font>
| <font face="calibri" color="#000000">WSS JMP WHO/UNICEF JMP</font>
| <font style="font-size: 11pt;" face="calibri" color="#000000">INFRA</font>
| <font face="calibri" color="#000000">2015/08/25</font>
| align="right" | <font face="calibri" color="#000000">Yes</font>
| <br/>
|}
|}


Line 281: Line 265:
== Land equipped for irrigation ==
== Land equipped for irrigation ==


Potentially irrigable land is initialized using '''SeriesLandIrPotential'''
*Area equipped for irrigation (TLANDIRAREAEQUIP) is initialized using '''SeriesLandIrAreaEquipFAO'''
**'''Source:''' FAO
**'''Definition:''' Land Area Equipped for Irrigation
**'''Last IFs update:''' 2013/12/19
**''<span style="background-color: rgb(255, 255, 0);">'''Note:''' need to switch to AQUASTAT when it gets updated</span>''
 
 
 
*Potentially irrigable land reached (CLandIrPotReached) initialized using&nbsp;'''SeriesLandIrPotentialReached'''
**'''Source: '''AQUASTAT, at [http://www.fao.org/nr/water/aquastat/dbase/index.stm http://www.fao.org/nr/water/aquastat/dbase/index.stm]
**'''<span style="background-color: rgb(255, 255, 0);">Notes:</span>'''<span style="background-color: rgb(255, 255, 0);">DSR; looked at FAO/Aquastat data to find countries with no growth/decline in the recent period</span>
 
 
 
*If CLandIrPotReached is not null, and it is less than the area of land equipped for irrigation (TLANDIRAREAEQUIP)
**Then set the saturation level (CLandIrAreaSat) as 10% above TLANDIRAREAEQUIP.
*Otherwise, CLandIrPotReached is the saturation level
*''Note: This is to ensure that the reached potential is not less than land equipped for irrigation, as that would lead to a transient in the first year''
 
 
 
*Potentially irrigable land (CLandIrPot) is initialized using '''SeriesLandIrPotential'''
**'''Source:''' AQUASTAT
**'''Definition:''' Irrigation potential (1000 ha)
*If null then
**If land equipped for irrigation is null, then
***Assume potentially irrigable land is 10% of agricultural land area (CLandAgri).
***Land equipped for irrigation is 33% of potentially irrigable land
***Saturation level is 29.7% of potentiall irrigable land
****CLandIRAreaSat(ICount%) = (0.1 + 0.9 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot
****39.7% because (TLANDIRAREAEQUIP/CLandIrPot) = .33
****<span style="background-color: rgb(255, 255, 0);">'''Note:''' This seems wrong because saturation level (39.7% of potential) is only slightly higher than land equipped (33%)</span>
**If&nbsp;there is data on land equipped for irrigation then
***If land equipped for irrigation is greater than 9% of agricultural land and less than 91% of agricultural land then
****Saturation level (CLandIRAreaSat) is 10% higher than current level of land equipped for irrigation (LANDIRAREAEQUIP)
***If land equipped for irrigation is less than 9% of agricultural land then
****Potentially irrigable land is 10% of agricultural land
****Saturation level is initialized using same equation above: CLandIRAreaSat(ICount%) = (0.1 + 0.9 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot
****'''<span style="background-color: rgb(255, 255, 0);">Note:</span>'''<span><span style="background-color: rgb(255, 255, 0);">This also sets the saturation level low (lower than potentially irrigable, which is 10% of agricultural land)</span></span>
***If land equipped for irrigation is greater than 91% of agricultural land then
****Potentially irrigable land is set as agricultural land
****Saturation level is again set as: CLandIRAreaSat(ICount%) = (0.1 + 0.9 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot
****'''<span style="background-color: rgb(255, 255, 0);">Note:</span>'''<span style="background-color: rgb(255, 255, 0);">There is currently no country where this is the case i.e. this branch of the code is never activated</span>
*If there is data for potentially irrigable land
**But there isn't data on land equipped for irrigation
***Land equipped for irrigation is 33% of potentially irrigable land
**And there is data on land equipped for irrigation then
***CLandIRAreaSat(ICount%) = Amin(cLandAgri, AMAX(TLANDIRAREAEQUIP * 1.01, (0.4 + 0.6 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot))
***<span style="color: rgb(0, 128, 0);">'If Potential is less than AreaEuip set the saturation at 1% higher than actual</span>
***'''<span style="background-color: rgb(255, 255, 0);">Note:</span>'''<span style="background-color: rgb(255, 255, 0);">This is not true. If potential is less than equipped, then ((0.4 + 0.6 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot) could actually be larger than (LANDIRAREAEQUIP * 1.01)</span>
 
 
 
*Set the land equipped for irrigation growth rate as
**CLandIrAreaEquipGR(ICount%) = getAnnualGrowthRate(LandIrAreaEquipTbl, BaseYear, 0.08, -0.08, 3, 5, 15, 10)
**'''''Note:''' this calculates a growth rate using historical values. The parameters are (max growth rate, min growth rate, minimum number of years needed to compute growth rate, maximum number of years to compute growth rate, maximum number of years to go backward from BaseYear, maximum number of years to go forward from BaseYear)''
*If unable to calculate (no data) then
**set as -9999 (which should get adjusted to 0.001)
 
<span style="background-color:#FFFF00;">***INCOMPLETE DOCUMENTATION***</span>
 








= ICT =


&nbsp;
*ICT spending (CSpend) is initialized using '''SeriesICTExpend%GDP'''
**'''Source:'''&nbsp;WDI CD 2010 and existing IFs data
**'''Definition:'''&nbsp;ICT technology expenditure, % of GDP
**'''Last IFs update:'''&nbsp;2011/05/28
*If null, then estimate using:&nbsp;"GDP/Capita (PPP 2000) Versus ICT Expenditures % GDP (" & CStr(BaseYear) & ") Linear"
**This uses the equation: "GDP/Capita (PPP 2000) Versus ICT Expenditures % GDP (2005) Linear" from TablFunc

Latest revision as of 21:17, 6 November 2017

SeriesRoadRuralAccessIndex is obviously a series we need to look into. The World Bank no longer has this exact index however.

Sources

WDI, ITU, WHO, WSS/JMP

Infrastructure series pulled into preprocessor 

Copy Of DataDict
Table Source Last IFs Update UsedInPreprocessorFileName
SeriesLandIrPotential AQU BATCH PULL
 2016/06/06 INFRA
SeriesLandIrPotentialReached
 AQUASTAT, at http://www.fao.org/nr/water/aquastat/dbase/index.stm
 2011/11/16 INFRA
SeriesEnElecAccess%Urban Data extracted from WDI
 2016/05/10 INFRA
SeriesEnElecAccess%Rural Data extracted from WDI 2016/05/10
 INFRA
SeriesEnElecAccess%National Data extracted from WDI
 2016/05/05 INFRA
SeriesEnElecTotalCapacityEIA EIA; US Energy Information Administration;
 2016/04/22 INFRA
SeriesLandIrAreaEquipFAO
 FAO 2013/12/19 INFRA
SeriesLandTotal FAO BATCH PULL 2015/04/10 INFRA
SeriesLandAgri FAO BATCH PULL
 2015/04/10 INFRA
SeriesICTInternetHousehold% ITU
 2015/04/14 INFRA
SeriesHouseholds
 ITU 2011 2011/08/19 INFRA
SeriesICTBroadbandMobileSubsPer100 ITU 2014 BATCH PULL 2015/02/03 INFRA
SeriesICTComputerHousehold% ITU 2014 BATCH PULL 2015/01/28 INFRA
SeriesICTBroadbandSubscribersPer100ITU ITU 2015 2016/05/18 INFRA
SeriesICTTelephoneCellSubscribersPer100 ITU 2015 2016/05/18 INFRA
SeriesICTTelephoneLinesPer100 ITU 2015 2016/05/18 INFRA
SeriesICTCYBICTDevelopmentIndexITU ITU: Measuring the Information Society 2008, 2010-2014 2015/05/10 INFRA
SeriesRoadRuralAccessIndex
 The World Bank Rural Access Index 2010/07/15 INFRA
SeriesPopulation UNPD 2015 (DSR added Taiwan from WEO)
 2015/09/18 INFRA
SeriesWasteWaterColConnect% UNSD/ UNEP/ OECD/ EUROSTAT
 2011/08/08 INFRA
SeriesWasteWaterTreatConnect% UNSD/ UNEP/ OECD/ EUROSTAT
 2011/08/08 INFRA
SeriesEnvSolidFuels UNSTATS and WHO survey data and missing point estimation by DPHE, WHO and UC Berkley researchers 2013/07/03 INFRA
SeriesEnElecConsPerCap WDI BATCH PULL 2015/07/14 INFRA
SeriesEnElecTransLoss% WDI BATCH PULL 2015/07/14 INFRA
SeriesGDP2011PCPPP WDI - calculaed from WDI and other sources; extrapolated based on previous GDP_PCPPP2005 values in IFs; extrapolated based on CIA Factbook; taken directly from CIA Factbook; taken directly from previous GDP_PCPPP2005 values in IFs 2015/09/18 INFRA
SeriesRoadPavedKm WDI 2013; WDI 2011; Calderon (communication to DR) and Canning, David (1998) with updates by Canning from WDI 2006 2013/12/17 INFRA
SeriesRoadsPaved% WDI 2014 May BATCH PULL 2014/06/11 INFRA
SeriesEnConTotalWDI WDI 2014 May BATCH PULL 2014/06/11 INFRA
SeriesRoadsTotalNetwork WDI 2014 May BATCH PULL 2014/06/11 INFRA
SeriesEnProdElec WDI 2014 May BATCH PULL 2014/06/11 INFRA
SeriesEnElecShrEnDem WDI 2014 May BATCH PULL 2014/06/11 INFRA
SeriesIncBelow1D25c%WDI2011 WDI 2015 March WDI Website 2015/03/17 INFRA
SeriesICTExpend%GDP WDI CD 2010 and existing IFs data 2011/05/28 INFRA
SeriesWHO2012WaterPipedFiltered WHO: provided directly by Annette Pruss-Ustun of the WHO 2014/06/24 INFRA
SeriesWHO2012WaterUnImpNoFilter WHO: provided directly by Annette Pruss-Ustun of the WHO 2014/06/25 INFRA
SeriesWHO2012WaterUnImpFiltered WHO: provided directly by Annette Pruss-Ustun of the WHO 2014/06/25 INFRA
SeriesWHO2012WaterPipedNoFilter WHO: provided directly by Annette Pruss-Ustun of the WHO 2014/06/24 INFRA
SeriesWHO2012WaterOthImpFiltered WHO: provided directly by Annette Pruss-Ustun of the WHO 2014/06/25 INFRA
SeriesWHO2012WaterOthImpNoFilter WHO: provided directly by Annette Pruss-Ustun of the WHO 2014/06/25 INFRA
SeriesGovernanceEffect Worldwide_Governance_Indicators, http://info.worldbank.org/governance/wgi/index.asp 2016/04/07 INFRA
SeriesGovernanceRegQual Worldwide Governance Indicators, http://info.worldbank.org/governance/wgi/index.asp 2016/04/07 INFRA
SeriesWSSJMPSanitationTotal%Shared WSS JMP WHO/UNICEF JMP 2015/08/25 INFRA
SeriesWSSJMPWaterTotal%OtherUnimproved WSS JMP WHO/UNICEF JMP 2015/08/25 INFRA
SeriesWSSJMPWaterTotal%OtherImproved WSS JMP WHO/UNICEF JMP 2015/08/25 INFRA
SeriesWSSJMPSanitationTotal%Improved WSS JMP WHO/UNICEF JMP 2015/08/25 INFRA
SeriesWSSJMPSanitationTotal%OpenDefecation WSS JMP WHO/UNICEF JMP 2015/08/25 INFRA
SeriesWSSJMPWaterTotal%Surface WSS JMP WHO/UNICEF JMP 2015/08/25 INFRA
SeriesWSSJMPSanitationTotal%OtherUnimproved WSS JMP WHO/UNICEF JMP 2015/08/25 INFRA
SeriesWSSJMPWaterTotal%Piped WSS JMP WHO/UNICEF JMP 2015/08/25 INFRA

Irrigation

Land equipped for irrigation

  • Area equipped for irrigation (TLANDIRAREAEQUIP) is initialized using SeriesLandIrAreaEquipFAO
    • Source: FAO
    • Definition: Land Area Equipped for Irrigation
    • Last IFs update: 2013/12/19
    • Note: need to switch to AQUASTAT when it gets updated


  • Potentially irrigable land reached (CLandIrPotReached) initialized using SeriesLandIrPotentialReached


  • If CLandIrPotReached is not null, and it is less than the area of land equipped for irrigation (TLANDIRAREAEQUIP)
    • Then set the saturation level (CLandIrAreaSat) as 10% above TLANDIRAREAEQUIP.
  • Otherwise, CLandIrPotReached is the saturation level
  • Note: This is to ensure that the reached potential is not less than land equipped for irrigation, as that would lead to a transient in the first year


  • Potentially irrigable land (CLandIrPot) is initialized using SeriesLandIrPotential
    • Source: AQUASTAT
    • Definition: Irrigation potential (1000 ha)
  • If null then
    • If land equipped for irrigation is null, then
      • Assume potentially irrigable land is 10% of agricultural land area (CLandAgri).
      • Land equipped for irrigation is 33% of potentially irrigable land
      • Saturation level is 29.7% of potentiall irrigable land
        • CLandIRAreaSat(ICount%) = (0.1 + 0.9 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot
        • 39.7% because (TLANDIRAREAEQUIP/CLandIrPot) = .33
        • Note: This seems wrong because saturation level (39.7% of potential) is only slightly higher than land equipped (33%)
    • If there is data on land equipped for irrigation then
      • If land equipped for irrigation is greater than 9% of agricultural land and less than 91% of agricultural land then
        • Saturation level (CLandIRAreaSat) is 10% higher than current level of land equipped for irrigation (LANDIRAREAEQUIP)
      • If land equipped for irrigation is less than 9% of agricultural land then
        • Potentially irrigable land is 10% of agricultural land
        • Saturation level is initialized using same equation above: CLandIRAreaSat(ICount%) = (0.1 + 0.9 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot
        • Note:This also sets the saturation level low (lower than potentially irrigable, which is 10% of agricultural land)
      • If land equipped for irrigation is greater than 91% of agricultural land then
        • Potentially irrigable land is set as agricultural land
        • Saturation level is again set as: CLandIRAreaSat(ICount%) = (0.1 + 0.9 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot
        • Note:There is currently no country where this is the case i.e. this branch of the code is never activated
  • If there is data for potentially irrigable land
    • But there isn't data on land equipped for irrigation
      • Land equipped for irrigation is 33% of potentially irrigable land
    • And there is data on land equipped for irrigation then
      • CLandIRAreaSat(ICount%) = Amin(cLandAgri, AMAX(TLANDIRAREAEQUIP * 1.01, (0.4 + 0.6 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot))
      • 'If Potential is less than AreaEuip set the saturation at 1% higher than actual
      • Note:This is not true. If potential is less than equipped, then ((0.4 + 0.6 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot) could actually be larger than (LANDIRAREAEQUIP * 1.01)


  • Set the land equipped for irrigation growth rate as
    • CLandIrAreaEquipGR(ICount%) = getAnnualGrowthRate(LandIrAreaEquipTbl, BaseYear, 0.08, -0.08, 3, 5, 15, 10)
    • Note: this calculates a growth rate using historical values. The parameters are (max growth rate, min growth rate, minimum number of years needed to compute growth rate, maximum number of years to compute growth rate, maximum number of years to go backward from BaseYear, maximum number of years to go forward from BaseYear)
  • If unable to calculate (no data) then
    • set as -9999 (which should get adjusted to 0.001)

***INCOMPLETE DOCUMENTATION***



ICT

  • ICT spending (CSpend) is initialized using SeriesICTExpend%GDP
    • Source: WDI CD 2010 and existing IFs data
    • Definition: ICT technology expenditure, % of GDP
    • Last IFs update: 2011/05/28
  • If null, then estimate using: "GDP/Capita (PPP 2000) Versus ICT Expenditures % GDP (" & CStr(BaseYear) & ") Linear"
    • This uses the equation: "GDP/Capita (PPP 2000) Versus ICT Expenditures % GDP (2005) Linear" from TablFunc
Retrieved from "https://pardeewiki.du.edu//index.php?title=Infrastructure_preprocessor&oldid=8644"