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, and 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 null but 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)