Infrastructure preprocessor: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 283: Line 283:
*Area equipped for irrigation (TLANDIRAREAEQUIP) is initialized using '''SeriesLandIrAreaEquipFAO'''
*Area equipped for irrigation (TLANDIRAREAEQUIP) is initialized using '''SeriesLandIrAreaEquipFAO'''
**'''Source:''' FAO
**'''Source:''' FAO
**'''Definition:''' Land Area Equipped for Irrigation  
**'''Definition:''' Land Area Equipped for Irrigation
**''<span style="background-color: rgb(255, 255, 0);">'''Note:''' need to switch to AQUASTAT when it gets updated</span>''
**''<span style="background-color: rgb(255, 255, 0);">'''Note:''' need to switch to AQUASTAT when it gets updated</span>''


''<span style="background-color: rgb(255, 255, 0);"></span>''


*''<span style="background-color: rgb(255, 255, 0);"></span>''Potentially irrigable land (CLandIrPotReached) initialized using'''SeriesLandIrPotentialReached'''
 
*Potentially irrigable land (CLandIrPotReached) initialized using'''SeriesLandIrPotentialReached'''
**'''Source: '''AQUASTAT, at [http://www.fao.org/nr/water/aquastat/dbase/index.stm http://www.fao.org/nr/water/aquastat/dbase/index.stm]
**'''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>
**'''<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>
<span style="background-color: rgb(255, 255, 0);"></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.
*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
*Otherwise, CLandIrPotReached is the saturation level


Potentially irrigable land is initialized using '''SeriesLandIrPotential'''
 
 
*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
***<span style="background-color: rgb(255, 255, 0);"></span><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>





Revision as of 22:45, 17 May 2016

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


  • 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%)