Online California Freight Data Repository for Freight Modeling and Analysis

1. 2010 Innovations in Freight-Demand Modeling and Data Symposium Online CaliforniaFreight Data Repositoryfor Freight Modeling and Analysis Andre Tok, Miyuan Zhao, Joseph Y.J. Chow, Stephen G. Ritchie, and DimitriArkhipov, University of California at Irvine

2. Issues with Freight Data • Multiple freight data sources • Different user-interface designs and architecture • Availability of data definitions • Data dictionaries not always explicitly provided • Inconsistent data formats • Creates potential incompatibilities for modeling and analysis • Text-based data • Inability to assess scope and relevance of datasets

3. Online California Freight Data Repository (Cal-Fred) Features • User-centered online tool • Convenient access through web-based architecture (http://moon.its.uci.edu/calfred/) • Standardized interface, centralized location for obtaining freight data from a variety of public sources • Data definitions • Downloadable data dictionaries and lookups associated with each data source • Data formats • Data tables associated with each data source can be downloaded in a variety of formats (tab-delimited, csv, html) to accommodate user needs • Data evaluation and assessment • Time-series and spatial analysis tools provide convenient evaluation and visual assessment of data

5. List of Data Sources

6. Cal-Fred User Interface and Modules:A single integrated application

7. Data Source Query Interface Data query interface Data source description (updates with change in data source selection) Data dictionaries associated with data source 2003 International Monetary Fund Data Quality Assessment Framework-based assessment summary (click to display)

8. Cal-FRED Time Series Analysis Query interface with map display options Tabular and chart results with display and data download options Map display options interface Google Maps-based location selection interface

9. Cal-FRED Spatial Analysis Query interface with map display options Tabular and chart results display text results and percentage contribution with data download options Google Maps-based color-scaled results illustrates geographical distribution of data

10. Cal-FRED External Data Sources Toggle between public and private data source lists Data source filter narrows down list of displayed sources Filtered list of external data sources (click to access data source via external web page) Data source descriptions are displayed as the mouse hovers over a data source

11. FREDDY Search vs Google Search FREDDY Search Results (uses Google custom search engine to search over 40 freight related websites) Google Search Results

12. Application Examples • Freight network optimization: the Cal-GIFT model • Highway, railway, waterway networks, transfer facility locations • Truck/rail/vessel emissions, energy consumption from EPA • Ports/rail terminal volumes, good types transferred, handling delay • Commodity flow OD’s (FAF2) • Freight data analysis: Commodity Flow Disaggregation • FAF2 • Socioeconomic data: County Business Patterns, Census Populations, Quarterly Census of Employment and Wages • Metropolitan Planning Organization Goods Movement Studies • Truck VMT/HPMS • FAF2 • VIUS • Land use model integration (Caltrans PECAS) • Highway, railway, waterway networks, transfer facility locations • FAF2 • Socioeconomic data: County Business Patterns, Census Populations, Quarterly Census of Employment and Wages

13. Questions & Answers