Infrastructure preprocessor

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 

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.

DataDict 720

Table	Group	Definition	Source	Last IFs Update	UsedInPreprocessor	Years
SeriesRoadRuralAccessIndex	Transportation,Infrastructure	Rural Access Index, proportion of the rural population who live within 2 km (25 minute walk) of all-weather road	The World Bank Rural Access Index	2010/07/15	Yes
SeriesICTExpend%GDP	Information Communication,Infrastructure	ICT technology expenditure, % of GDP	WDI CD 2010 and existing IFs data	2011/05/28	Yes
SeriesWasteWaterColConnect%	Infrastructure, Water, Health	Percent of population connected to urban wastewater collection system	UNSD/ UNEP/ OECD/ EUROSTAT	2011/08/08	Yes
SeriesWasteWaterTreatConnect%	Infrastructure, Water, Health	Percent of population connected to urban wastewater treatment system	UNSD/ UNEP/ OECD/ EUROSTAT	2011/08/08	Yes
SeriesR&D%GDPWDI	Science Technology, Infrastructure, Knowledge	R&D as % of GDP (in some earlier years was GNI)	Constructed from multiple WDI vol;CD incl 01, 02, 04,05,06,07; 2006-2008 Update from UIS Website	2013/08/07	Yes
SeriesICTExport%Exp	Information Communication,Infrastructure, Trade	Exports of ICT as % of total exports	WDI 2013	2013/11/08	Yes
SeriesICTImport%Imp	Information Communication,Infrastructure, Trade	Imports of ICT as % of total imports	WDI 2013	2013/11/08	Yes
SeriesRoadPavedKm	Transportation,Infrastructure	Length of paved roads, kilometers	WDI 2013; WDI 2011; Calderon (communication to DR) and Canning, David (1998) with updates by Canning from WDI 2006	2013/12/17	Yes
SeriesRoadsPaved%	Transportation,Infrastructure	Roads, paved as a percent of total roads	WDI 2014 May BATCH PULL	2014/06/11	Yes
SeriesRoadsTotalNetwork	Transportation,Infrastructure	Roads, total network, kilometers	WDI 2014 May BATCH PULL	2014/06/11	Yes
SeriesVehiclesper1000	Transportation,Infrastructure	Vehicles per 1000 People	WDI 2014 May BATCH PULL	2014/06/11	Yes
SeriesWHO2012WaterPipedFiltered	Infrastructure, Water, Health	Proportion of Total population served with Piped Water to premises which is Filtered or Boiled (%)	WHO: provided directly by Annette Pruss-Ustun of the WHO	2014/06/24	Yes
SeriesWHO2012WaterPipedNoFilter	Infrastructure, Water, Health	Proportion of Total population served with Piped Water to premises which is not Filtered or Boiled (%)	WHO: provided directly by Annette Pruss-Ustun of the WHO	2014/06/24	Yes
SeriesWHO2012WaterOthImpFiltered	Infrastructure, Water, Health	Proportion of Total population served with Other Improved Water which is Filtered or Boiled (%)	WHO: provided directly by Annette Pruss-Ustun of the WHO	2014/06/25	Yes
SeriesWHO2012WaterOthImpNoFilter	Infrastructure, Water, Health	Proportion of Total population served with Other Improved Water which is not Filtered or Boiled (%)	WHO: provided directly by Annette Pruss-Ustun of the WHO	2014/06/25	Yes
SeriesWHO2012WaterUnImpFiltered	Infrastructure, Water, Health	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)	WHO: provided directly by Annette Pruss-Ustun of the WHO	2014/06/25	Yes
SeriesWHO2012WaterUnImpNoFilter	Infrastructure, Water, Health	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)	WHO: provided directly by Annette Pruss-Ustun of the WHO	2014/06/25	Yes
SeriesICTTelephoneLinesPer100	Information Communication, Infrastructure	Fixed telephone lines per 100 inhabitants	ITU 2014	2014/06/30	Yes
SeriesICTBroadbandSubscribersPer100ITU	Information Communication, Infrastructure	Fixed broadband subscriptions per 100 inhabitants	ITU 2014 BATCH PULL	2015/01/28	Yes
SeriesICTComputerHousehold%	Information Communication, Infrastructure	Proportion of households with a computer	ITU 2014 BATCH PULL	2015/01/28	Yes
SeriesICTTelephoneCellSubscribersPer100	Information Communication, Infrastructure	Mobile cellular subscriptions per 100 inhabitants	ITU 2014 BATCH PULL	2015/01/28	Yes
SeriesICTBroadbandMobileSubsPer100	Information Communication,Infrastructure	Broadband Mobile, Mobile cellular subscriptions with access to data communication at broadband speed per 100 inhabitants	ITU 2014 BATCH PULL	2015/02/03	Yes
SeriesICTInternetHousehold%	Information Communication, Infrastructure	Proportion of households with Internet access at home	ITU	2015/04/14	Yes
SeriesICTInternet%Pop	Information Communication,Infrastructure	Percent of population on-line	WDI BATCH PULL	2015/07/14	Yes
SeriesWSSJMPSanitationTotal%Improved	Infrastructure, Water, Health	Proportion of Total population served with Improved Sanitation (%)	WSS JMP WHO/UNICEF JMP	2015/08/25	Yes
SeriesWSSJMPSanitationTotal%OpenDefecation	Infrastructure, Water, Health	Proportion of Total population served with Open Defecation Sanitation (%)	WSS JMP WHO/UNICEF JMP	2015/08/25	Yes
SeriesWSSJMPSanitationTotal%OtherUnimproved	Infrastructure, Water, Health	Proportion of Total population with Other Unimproved Sanitation (%)	WSS JMP WHO/UNICEF JMP	2015/08/25	Yes
SeriesWSSJMPSanitationTotal%Shared	Infrastructure, Water, Health	Proportion of Total population served with Shared Sanitation (%)	WSS JMP WHO/UNICEF JMP	2015/08/25	Yes
SeriesWSSJMPWaterTotal%OtherImproved	Infrastructure, Water, Health	Proportion of Total population served with Other Improved Water (%)	WSS JMP WHO/UNICEF JMP	2015/08/25	Yes
SeriesWSSJMPWaterTotal%OtherUnimproved	Infrastructure, Water, Health	Proportion of Total population with Other Unimproved Water (%)	WSS JMP WHO/UNICEF JMP	2015/08/25	Yes
SeriesWSSJMPWaterTotal%Piped	Infrastructure, Water, Health	Proportion of Total population served with Piped Water (%)	WSS JMP WHO/UNICEF JMP	2015/08/25	Yes
SeriesWSSJMPWaterTotal%Surface	Infrastructure, Water, Health	Proportion of Total population with Surface Water (%)	WSS JMP WHO/UNICEF JMP	2015/08/25	Yes

Irrigation

Land equipped for irrigation

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

• Potentially irrigable land (CLandIrPotReached) initialized usingSeriesLandIrPotentialReached
  • Source: AQUASTAT, at http://www.fao.org/nr/water/aquastat/dbase/index.stm
  • Notes:DSR; looked at FAO/Aquastat data to find countries with no growth/decline in the recent period

• 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

• 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

CLandIRAreaSat(ICount%) = Amin(cLandAgri, AMAX(TLANDIRAREAEQUIP * 1.01, (0.4 + 0.6 * (TLANDIRAREAEQUIP / CLandIrPot)) * CLandIrPot))