Infrastructure preprocessor: Difference between revisions
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>'' | ||
* | |||
*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> | ||
*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
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.
| 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%)