The Asian Transport Outlook (ATO) Urban Database is a collection of urban-level indicators on the transport sector in the Asia Pacific region using more than 100 indicators. The database is structured into categories. The indicators are also tagged with indicator metadata that will enable detailed filtering of the database.
To organize data and indicators, nine main categories have been created.
Each indicator has a unique code consisting of three elements: e.g. SEC-UDB-001, SEC refers to the Socio-economic category, UDB refers to the Urban database, and the 001 refers to indicator number. In certain cases when an indicator was scrapped, the number will become vacant. The database is not arranged numerically by indicator code but by category groups.
For each of the indicators a short description is provided in the indicator metadata. In those cases where an indicator has been collected from a secondary source the original source definition will be used. Any applicable notes or limitations are specified in the indicator description as well.
For all the indicators, a set of indicator metadata will be defined that can be used for filtering of the indicators in the interface.
The sources can broken down in three categories: (a) indicators that have been collected from other secondary sources, (b) indicators composed by the ATO team on the basis of information collection from varying sources, these are described as Varying Sources and (c) indicators that are calculated by ATO team on the basis of other ATO indicators, these are listed as Calculated/Estimated.
For all indicators, the source is identified in the indicator metadata. If multiple sources of the indicator are available, this is listed accordingly.
The ATO urban centers are also tagged with economy metadata. In addition to the indicator metadata, the economy metadata will also help filter down the desired data.
The ATO Urban Database Masterlist of Indicators provides an overview of the indicators that are included in the ATO Urban Database. This provides tabular information about the indicators such as indicator definition, mode, source, and status. The masterlist is structured based on the nine categories listed above.
An offline version of the masterlist is available for download in the ATO Urban Database Masterlist of Indicators page. This includes the indicator description, category, mode, status, unit, and source for each indicator however in a tabular form. Using the headers, the list can be filtered down as needed.
In the web-based version of the ATO Urban Database Masterlist of Indicators, the masterlist includes a functionality for filtering and searching of indicators to improve ease-of-use. This list of indicators can be filtered by clicking on the category cards, or using the filter box above the list. The searchbox can be used to search for specific indicators. Any keywords entered will be used to look for similar information within the indicator metadata of all the indicators. When the desired indicator is found, the Explore can be clicked to go to the ATO Urban Database interface where the indicator will already be pre-selected. The Download can be clicked to download the data for all urban centers and all years for that specific indicator.
Within the ATO Urban Database interface, the space on the left will contain panels that filter data by urban centers, indicators, and time. To access any specific data, all parameters (i.e. economy, indicator, time, and download option) need to have a selection before the Download button becomes active. A prompt will appear if any of the parameters are missing.
Individual urban centers can be selected by clicking on the checkbox. All urban centers can be selected by clicking Select All. The selection can be reset by clicking on Reset.
To filter by economy typology, click on the filter button to open the expanded filter window. The filters on the left (i.e. Subregion, Income Group, or other Groups) can be used to narrow down the list of urban center.
Notes about filtering:
Indicators are organized by nine main categories which can be expanded to show all indicators within each category. Individual indicators can be selected by clicking on the checkbox. All indicators can be selected by clicking Select All. The selection can be reset by clicking on Reset.
When an indicator with multiple sources is selected, all sources are automatically selected.
To filter by indicator typology, click on the filter button to open the expanded filter window. The filters on the left (i.e. Category or Mode) can be used to narrow down the list of indicators.
Notes about filtering:
The desired data timeframe can be selected per year by clicking on the checkbox or you can use the slider to select a range of years. All available years can be selected by clicking on Select All. The selection can be reset by clicking on Reset.
Note that if indicators have no data for the selected years, these will not appear in the output generated for download.
Shortcuts are available to quickly select recent 5, 10, or 20 years, or years up to present.
Within the ATO Urban Database interface, the space on the right will provide selection of the download option for the selected data. After selecting, the appropriate filteypes can be clicked to download the data.
The indicator view provides the standard view of indicators. Each page generated is a table for one indicator across multiple urban centers. This is best for side-by-side data comparison between urban centers.
When downloaded, the list of selected indicators will be summarized in the Table of Contents (TOC) which includes indicator metadata such as subcategory, indicator name, indicator code, scope, mode, sector, source, and a shortcut to the indicator sheet. Note that indicators which have no data for the selected years will not appear.
The indicator sheet will include the indicator metadata at the top which includes indicator code, indicator name, description, scope, mode, sector, unit, source, and weblink. A shortcut back to TOC is available below the indicator metadata.
The data table will have urban centers as rows and years as columns. For indicators with multiple units, the respective units will be indicated as columns as well.
The urban center view provides the factsheet view of urban centers. Each page generated is an table of one urban center across multiple indicators. This is best for an overview of various indicators of one urban center.
When downloaded, the list of selected urban centers will be summarized in the Table of Contents (TOC) which includes ATO UC Code, ADB Subregion, AIIB Subregion, income group, and a shortcut to the urban center sheet.
The urban center sheet will include the urban center metadata at the top. A shortcut back to TOC is available below the urban center metadata.
The data table will have indicators as rows and years as columns. Years starting 2000 will be reflected contiguously until the maximum year selected.
The raw data provides the long-format view of data. This is best for further analysis using third-party software like Excel. The filetypes that are provided are .xlsx, .csv, and .json.
When .xlsx or .csv is downloaded, each data point will be displayed as a row beside urban center code, urban center name, indicator code, indicator name, source, units, header, and year. For .json, the data will be displayed in a key:value format.
The indicators can also be downloaded as a whole workbook. Download links are available at the ATO Urban Database landing page and the ATO Urban Database interface how-to panel. The structure of downloaded file will follow the standard indicator view.
Cookies used on the site are categorized and below you can read about each category and allow or deny some or all of them. When categories than have been previously allowed are disabled, all cookies assigned to that category will be removed from your browser. Additionally you can see a list of cookies assigned to each category and detailed information in the cookie declaration.
Some cookies are required to provide core functionality. The website won't function properly without these cookies and they are enabled by default and cannot be disabled.
Analytical cookies help us improve our website by collecting and reporting information on its usage.
Cookies used on the site are categorized and below you can read about each category and allow or deny some or all of them. When categories than have been previously allowed are disabled, all cookies assigned to that category will be removed from your browser. Additionally you can see a list of cookies assigned to each category and detailed information in the cookie declaration.
Some cookies are required to provide core functionality. The website won't function properly without these cookies and they are enabled by default and cannot be disabled.
Name | Hostname | Vendor | Expiry |
---|---|---|---|
sessionid | asiantransportoutlook.com | Asian Transport Outlook | 2 weeks |
Used by the website for authentication. |
|||
csrftoken | asiantransportoutlook.com | Asian Transport Outlook | 24 hrs |
Used by website to protect CSRF vulnerable resources. |
Analytical cookies help us improve our website by collecting and reporting information on its usage.
Name | Hostname | Vendor | Expiry |
---|---|---|---|
_ga | .asiantransportoutlook.com | Google Analytics | 2 years |
Used by Google Analytics to distinguish users. |
|||
_ga_Z5W4M9226H | .asiantransportoutlook.com | Google Analytics | 2 years |
Used by Google Analytics to to persist session state.. |
|||
_clck | .asiantransportoutlook.com | Microsoft Clarity | 1 year |
Persists the Clarity User ID and preferences, unique to that site is attributed to the same user ID. |
|||
_clsk | .asiantransportoutlook.com | Microsoft Clarity | 1 year |
Connects multiple page views by a user into a single Clarity session recording. |
We use cookies to analyze our traffic. For these reasons, we may share your site usage data with our analytics partners.
By clicking "Allow All", you consent to store on your device all the technologies described in our
GDPR and Privacy Policy page.
You can update your cookie settings by visiting the 'Manage Cookies' link in the footer.