IRF World Road Statistics - Revision history

Norah.Shamin at 15:51, 13 August 2025

2025-08-13T15:51:00Z

← Older revision		Revision as of 15:51, 13 August 2025
Line 1:		Line 1:
	=~~= Data Source~~ Summary ==		= Summary =
	The International Road Federation (IRF) maintains a database known as World Road Statistics (WRS), comprising over 200 series for over 200 countries. The database is a tremendous resource for infrastructure data, specifically transportation network data. WRS contains information on total road length, but also contains filters to view paved vs. unpaved roads, the kinds of traffic (commercial vs. private), the vehicles using the roadway, accidents and the consequences of them, and more.		The International Road Federation (IRF) maintains a database known as World Road Statistics (WRS), comprising over 200 series for over 200 countries. The database is a tremendous resource for infrastructure data, specifically transportation network data. WRS contains information on total road length, but also contains filters to view paved vs. unpaved roads, the kinds of traffic (commercial vs. private), the vehicles using the roadway, accidents and the consequences of them, and more.

Line 8:		Line 8:
	The latest update in IFs was in April 2025.		The latest update in IFs was in April 2025.

			= Tables In IFs =
	{\| class="wikitable"		{\| class="wikitable"
	\|Table		\|Table
Line 55:		Line 56:
	\|}		\|}

	=== Pulling Instructions~~: ==~~=		= Data Pulling Instructions =

	Step 1) Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse[[File:IRF world Road.png\|center\|IRF World Road Statistics Login Page\|thumb\|735x735px]]Step 2) Select "Country Comparison - Multiple Years" under Chart Type.		Step 1) Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse[[File:IRF world Road.png\|center\|IRF World Road Statistics Login Page\|thumb\|735x735px]]Step 2) Select "Country Comparison - Multiple Years" under Chart Type.
	[[File:WRS IMG 2.png\|center\|thumb\|736x736px\|Select Country Comparison (Multiple Years)]]		[[File:WRS IMG 2.png\|center\|thumb\|736x736px\|Select Country Comparison (Multiple Years)]]
Line 88:		Line 90:

	Step 10) An Excel sheet will download. The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format. Now you can format the data to upload it into IFs. To import data into IFs, please follow the instructions found in the [[Importing data (general instructions)\|Importing Data (general instructions)]] page.		Step 10) An Excel sheet will download. The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format. Now you can format the data to upload it into IFs. To import data into IFs, please follow the instructions found in the [[Importing data (general instructions)\|Importing Data (general instructions)]] page.

			= Data Notes =

Norah.Shamin at 16:26, 9 May 2025

2025-05-09T16:26:31Z

← Older revision		Revision as of 16:26, 9 May 2025
Line 4:		Line 4:
	To IFs, the IRF provides an important window into the transportation infrastructure of a country. A robust, paved road network makes it easier for a country's exporters to access ports, and for its citizens to find jobs if they are scarce locally. IFs uses three preprocessors from this data source: RoadsPavedKm, the total length of paved roads in a country measured in kilometers; RoadsTotalNetwork, the total length of roads paved or unpaved; and RoadsPaved%, the proportion of the total network which is paved.		To IFs, the IRF provides an important window into the transportation infrastructure of a country. A robust, paved road network makes it easier for a country's exporters to access ports, and for its citizens to find jobs if they are scarce locally. IFs uses three preprocessors from this data source: RoadsPavedKm, the total length of paved roads in a country measured in kilometers; RoadsTotalNetwork, the total length of roads paved or unpaved; and RoadsPaved%, the proportion of the total network which is paved.

	Another table is usually updated with these three preprocessors: RuralAccessIndex. This table is pulled from the [https://datacatalog.worldbank.org/search/dataset/0038250 World Bank].		Another table is usually updated with these three preprocessors: RuralAccessIndex. Yhe Rural Access Index measures the proportion of the rural population who live within 2 km of an all-season road. It is included in the Sustainable Development Goals as indicator 9.1.1., providing a way of measuring progress towards Goal 9 and Target 9.1. This table is pulled from the [https://datacatalog.worldbank.org/search/dataset/0038250 World Bank].

	The latest update in IFs was in April 2025.		The latest update in IFs was in April 2025.
Line 15:		Line 15:
	\|Years		\|Years
	\|Source		\|Source
	\|Name is Source		\|Name in Source
	\|Preprocessor Name		\|Preprocessor Name
	\|-		\|-

Norah.Shamin at 22:13, 8 May 2025

2025-05-08T22:13:38Z

← Older revision		Revision as of 22:13, 8 May 2025
Line 3:		Line 3:

	To IFs, the IRF provides an important window into the transportation infrastructure of a country. A robust, paved road network makes it easier for a country's exporters to access ports, and for its citizens to find jobs if they are scarce locally. IFs uses three preprocessors from this data source: RoadsPavedKm, the total length of paved roads in a country measured in kilometers; RoadsTotalNetwork, the total length of roads paved or unpaved; and RoadsPaved%, the proportion of the total network which is paved.		To IFs, the IRF provides an important window into the transportation infrastructure of a country. A robust, paved road network makes it easier for a country's exporters to access ports, and for its citizens to find jobs if they are scarce locally. IFs uses three preprocessors from this data source: RoadsPavedKm, the total length of paved roads in a country measured in kilometers; RoadsTotalNetwork, the total length of roads paved or unpaved; and RoadsPaved%, the proportion of the total network which is paved.

			Another table is usually updated with these three preprocessors: RuralAccessIndex. This table is pulled from the [https://datacatalog.worldbank.org/search/dataset/0038250 World Bank].

			The latest update in IFs was in April 2025.

			{\| class="wikitable"
			\|Table
			\|Definition
			\|Extended Source Definition
			\|Unit
			\|Years
			\|Source
			\|Name is Source
			\|Preprocessor Name
			\|-
			\|SeriesRoadRuralAccessIndex
			\|Rural Access Index, proportion of the rural population who live within 2 km (25 minute walk) of all-weather road
			\|RAI estimates the number of people who live within 2 kilometers (or about 25 minutes walking time) of the nearest all-weather road (Roberts, KC, and Rastogi 2006)
			\|Index
			\|1993-2004,2009-2022
			\|Rural Access Index, World Bank
			\|Rural Access Index
			\|INFRASTRUCTURE
			\|-
			\|SeriesRoadsTotalNetwork
			\|Roads, total network, kilometers
			\|some values are filled from CIA's World Factbook, significantly inconsistent values are manually deleted.
			\|Kilometers
			\|1960-2022
			\|World Road Statistics, International Road Federation
			\|Total Road Network - All Road Types - Total
			\|INFRASTRUCTURE
			\|-
			\|SeriesRoadsPaved%
			\|Paved roads as a percent of total roads
			\|some values are filled from CIA's World Factbook, significantly inconsistent values are manually deleted.
			\|Percent
			\|1990-2022
			\|World Road Statistics, International Road Federation
			\|Paved Network Ratio
			\|INFRASTRUCTURE
			\|-
			\|SeriesRoadPavedKm
			\|Length of paved roads, kilometers
			\|No Extended Source
			\|Kilometers
			\|1990-2010,2017-2022
			\|World Road Statistics, International Road Federation
			\|Total Road Network- All Road Types - Paved
			\|INFRASTRUCTURE
			\|}

	=== Pulling Instructions: ===		=== Pulling Instructions: ===

Sami.McKinsey at 17:00, 20 November 2023

2023-11-20T17:00:19Z

← Older revision		Revision as of 17:00, 20 November 2023
Line 5:		Line 5:

	=== Pulling Instructions: ===		=== Pulling Instructions: ===
	Step 1) Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse[[File:IRF world Road.png\|center\|IRF World Road Statistics Login Page\|~~frame~~]]Step 2) Select "Country Comparison - Multiple Years" under Chart Type.		Step 1) Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse[[File:IRF world Road.png\|center\|IRF World Road Statistics Login Page\|thumb\|735x735px]]Step 2) Select "Country Comparison - Multiple Years" under Chart Type.
	[[File:WRS IMG 2.png\|center\|thumb\|736x736px\|Select Country Comparison (Multiple Years)]]		[[File:WRS IMG 2.png\|center\|thumb\|736x736px\|Select Country Comparison (Multiple Years)]]
	Step 3) Manually select each continent in the selection box.		Step 3) Manually select each continent in the selection box.

Sami.McKinsey: /* Pulling Instructions: */

2023-11-20T16:59:58Z

Pulling Instructions:

← Older revision		Revision as of 16:59, 20 November 2023
Line 5:		Line 5:

	=== Pulling Instructions: ===		=== Pulling Instructions: ===
			Step 1) Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse[[File:IRF world Road.png\|center\|IRF World Road Statistics Login Page\|frame]]Step 2) Select "Country Comparison - Multiple Years" under Chart Type.
			[[File:WRS IMG 2.png\|center\|thumb\|736x736px\|Select Country Comparison (Multiple Years)]]
			Step 3) Manually select each continent in the selection box.
			[[File:WRS IMG 3.png\|center\|thumb\|734x734px\|Select each continent manually]]
			Step 4) In the countries box, select "all countries".
			[[File:WRS IMG 4.png\|center\|thumb\|741x741px\|Select "All countries"]]

	~~# Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary~~, ~~register~~. ~~The registration process is short, and provides immediate access to the data warehouse[[File:IRF world~~ Road~~.png\|center\|frameless\|545x545px\|IRF World Road Statistics Login Page]]~~
	~~# Select "Country Comparison - Multiple Years~~" ~~under Chart Type~~.~~[[File:Chart Type Road networks.png\|center\|frameless\|579x579px\|Select Country Comparison (Multiple Years)]]~~		Step 5) Under themes, select an option. Most IFs preprocessors will be under "Road Network". This example will continue with that selection.
	~~# Manually select each continent in the~~ selection ~~box. In the countries box, select "all countries"~~.		[[File:WRS IMG 5.png\|center\|thumb\|745x745px\|Select desired option under "Themes"]]
	# [[File:~~Continent and Country selector Road Networks~~.png\|center\|~~frameless~~\|~~549x549px~~\|Select ~~each continent manually, then~~ "~~all countries~~"]]Under ~~themes~~, select ~~"road network"~~		Step 6) Under "Metrics", select desired series.
	# For the preprocessor RoadPavedKm, select "Total Road Network- All Road Types - Paved"
	# For the preprocessor RoadsTotalNetwork, select "Total Road Network- All Road Types - Total"		* For the preprocessor RoadPavedKm, select "Total Road Network- All Road Types - Paved"
	# For the preprocessor RoadsPaved%, select "Paved Network Ratio"		* For the preprocessor RoadsTotalNetwork, select "Total Road Network- All Road Types - Total"
	# Select "Show Graph"		* For the preprocessor RoadsPaved%, select "Paved Network Ratio"
	# Click on the three bar menu in the upper right corner of the graph, then "download as CSV" or "download as XLS".[[File:~~World Road menu~~.png\|center\|~~frameless~~\|~~632x632px~~\|~~Select~~ the ~~three bar menu in the upper right corner of the graph~~]]
	# The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format.		[[File:WRS IMG 6.png\|center\|thumb\|749x749px\|Select desired series under "Metrics"]]


			Step 7) After those four selections are complete, the Country comparison page will look like this. Select "Show Graph".
			[[File:WRS IMG 7.png\|center\|thumb\|737x737px\|Country completion page after selection]]


			Step 8) A new page will populate.
			[[File:WRS IMG 8.png\|center\|thumb\|740x740px\|WRS Graph Page]]


			Step 9) Click on the three bar menu in the upper right corner of the graph, then "download as CSV" or "download as XLS".
			[[File:Screenshot (3).png\|center\|thumb\|733x733px\|Download the data series]]


			Step 10) An Excel sheet will download. The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format. Now you can format the data to upload it into IFs. To import data into IFs, please follow the instructions found in the [[Importing data (general instructions)\|Importing Data (general instructions)]] page.

Greg.Gillen: Reformatted and added data source summary

2023-09-21T21:36:34Z

Reformatted and added data source summary

← Older revision		Revision as of 21:36, 21 September 2023
Line 1:		Line 1:
			== Data Source Summary ==
			The International Road Federation (IRF) maintains a database known as World Road Statistics (WRS), comprising over 200 series for over 200 countries. The database is a tremendous resource for infrastructure data, specifically transportation network data. WRS contains information on total road length, but also contains filters to view paved vs. unpaved roads, the kinds of traffic (commercial vs. private), the vehicles using the roadway, accidents and the consequences of them, and more.

			To IFs, the IRF provides an important window into the transportation infrastructure of a country. A robust, paved road network makes it easier for a country's exporters to access ports, and for its citizens to find jobs if they are scarce locally. IFs uses three preprocessors from this data source: RoadsPavedKm, the total length of paved roads in a country measured in kilometers; RoadsTotalNetwork, the total length of roads paved or unpaved; and RoadsPaved%, the proportion of the total network which is paved.

	=== Pulling Instructions: ===		=== Pulling Instructions: ===

	# Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse		# Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse[[File:IRF world Road.png\|center\|frameless\|545x545px\|IRF World Road Statistics Login Page]]
	# Select "Country Comparison - Multiple Years" under Chart Type.		# Select "Country Comparison - Multiple Years" under Chart Type.[[File:Chart Type Road networks.png\|center\|frameless\|579x579px\|Select Country Comparison (Multiple Years)]]
	# Manually select each continent in the selection box. In the countries box, select "all countries".		# Manually select each continent in the selection box. In the countries box, select "all countries".
	# Under themes, select "road network"		# [[File:Continent and Country selector Road Networks.png\|center\|frameless\|549x549px\|Select each continent manually, then "all countries"]]Under themes, select "road network"
	# For the preprocessor RoadPavedKm, select "Total Road Network- All Road Types - Paved"		# For the preprocessor RoadPavedKm, select "Total Road Network- All Road Types - Paved"
	# For the preprocessor RoadsTotalNetwork, select "Total Road Network- All Road Types - Total"		# For the preprocessor RoadsTotalNetwork, select "Total Road Network- All Road Types - Total"
	# For the preprocessor RoadsPaved%, select "Paved Network Ratio"		# For the preprocessor RoadsPaved%, select "Paved Network Ratio"
	# Select "Show Graph"		# Select "Show Graph"
	# Click on the three bar menu in the upper right corner of the graph, then "download as CSV" or "download as XLS".		# Click on the three bar menu in the upper right corner of the graph, then "download as CSV" or "download as XLS".[[File:World Road menu.png\|center\|frameless\|632x632px\|Select the three bar menu in the upper right corner of the graph]]
	# The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format.		# The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format.

	~~[[File:IRF world Road.png\|thumb\|IRF World Road Statistics Login Page]]~~
	~~[[File:Chart Type Road networks.png\|thumb\|Select Country Comparison (Multiple Years)]]~~
	~~[[File:Continent and Country selector Road Networks.png\|thumb\|Select each continent manually, then "all countries"]]~~
	~~[[File:World Road menu.png\|thumb\|Select the three bar menu in the upper right corner of the graph]]~~

Greg.Gillen: Pulling instructions page created

2023-09-20T17:59:36Z

Pulling instructions page created

New page

=== Pulling Instructions: ===

# Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse
# Select "Country Comparison - Multiple Years" under Chart Type.
# Manually select each continent in the selection box. In the countries box, select "all countries".
# Under themes, select "road network"
# For the preprocessor RoadPavedKm, select "Total Road Network- All Road Types - Paved"
# For the preprocessor RoadsTotalNetwork, select "Total Road Network- All Road Types - Total"
# For the preprocessor RoadsPaved%, select "Paved Network Ratio"
# Select "Show Graph"
# Click on the three bar menu in the upper right corner of the graph, then "download as CSV" or "download as XLS".
# The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format.

[[File:IRF world Road.png|thumb|IRF World Road Statistics Login Page]]
[[File:Chart Type Road networks.png|thumb|Select Country Comparison (Multiple Years)]]
[[File:Continent and Country selector Road Networks.png|thumb|Select each continent manually, then "all countries"]]
[[File:World Road menu.png|thumb|Select the three bar menu in the upper right corner of the graph]]