2014年-世界发展银行全球_Urban_Transport_Data_Analysis_Tool___Users_Manual_36页_5mb

Summary of Urban Transport Data Analysis Tool (UT-DAT)

Core Content

The Urban Transport Data Analysis Tool (UT-DAT) is a benchmarking tool designed to assist cities in diagnosing their urban transport issues by comparing them with peer cities. It is developed by the World Bank's Transport Anchor and supported by the Energy Sector Management Assistance Program (ESMAP). The tool is based on Microsoft Excel and is intended to be user-friendly, allowing for the analysis of transport performance through a set of 30 pre-computed indicators.

The primary objective of UT-DAT is to enable cities to assess their urban transport performance more efficiently, identifying areas where they excel or lag behind in comparison to other cities. It emphasizes the importance of analyzing underlying causes of transport issues rather than just addressing surface-level symptoms, such as congestion or pollution, which are often the result of complex interactions between supply, demand, and performance factors.

Main Features

• Database (Matrix): Contains data for 93 cities across 42 countries, with 144 data items categorized into demographics, travel demand, transport infrastructure, energy, traffic safety, air quality, and macroeconomic data.
• Update Form: Allows users to input or update data for a test city or add a new city to the database.
• Two Report Types:
  • Report 1 (Graphs): Generates bar, column, or line charts for selected indicators.
  • Report 2 (Scatter Plots): Enables visualization of relationships between two data items.
• Quintile Analysis: Cities are ranked and grouped into five quintiles (top to bottom) based on their performance relative to peers, facilitating a more reliable comparison than absolute scores.
• Filtering Functionality: Users can select peer cities manually or via filter criteria (e.g., population, income, etc.).
• Customization: Graphs can be customized using Excel's built-in chart options.

Key Indicators and Data Items

The tool uses 30 indicators, which are derived from raw data items and are calculated to ensure ease of comparison. These indicators include:

• Public transport ridership and supply metrics
• Energy consumption and efficiency
• Traffic safety and pollution levels
• Infrastructure and vehicle data

These indicators are grouped into categories to provide a structured approach to analysis.

Shortcomings of Urban Transport Data

The data used in the UT-DAT are primarily sourced from secondary sources, which leads to several challenges:

• Inconsistency in data collection across cities and countries
• Lack of uniformity in definitions and reporting standards
• Data availability varies across cities and indicators
• Not all cities have complete data for all indicators, leading to the creation of a mock 6th quintile for missing data

Analytical Methodology

To address data variability and unreliability, UT-DAT uses a ranking and quintile-based approach instead of absolute performance scores. This method ensures that comparisons are more meaningful and less prone to error. Cities are grouped into five quintiles based on their relative performance across indicators, with the top quintile representing the top 20% and the bottom quintile the bottom 20%.

The ranking system avoids the assumption that a numerical score reflects an absolute level of performance, which is often unreliable. Instead, it focuses on relative performance, allowing users to identify trends and areas needing improvement.

User Instructions

• Open the tool using Microsoft Excel 2007 or higher.
• Enable macros to ensure the tool functions correctly.
• Use the Matrix sheet to view and manage data.
• Use the Update Form to add or modify data for a city.
• To generate a report:
  • Select the primary city (test city).
  • Choose peer cities manually or via filters.
  • Select indicators for analysis.
  • Choose the chart type (bar, column, or line).
  • Click Proceed to generate the report, which will be saved in a new Excel file.

Conclusion

The UT-DAT is a valuable diagnostic tool for urban transport planning, helping cities identify key performance areas and make informed decisions. By focusing on relative performance and quintile analysis, it provides a more reliable and nuanced understanding of transport challenges, ultimately supporting more effective and sustainable urban mobility solutions.