The International Mobility and Trade Corridor Program

Cascade Gateway Border Data Warehouse

Status: Ongoing

CascadeGatewayData.com

Overview

The Cascade Gateway Border Data Warehouse Upgrade and BIFA Integration project improved upon the existing Cascade Gateway border data warehouse and developed a project architecture based on the Border Information Flow Architecture (BIFA) developed out of the Transportation Border Working Group. The site is viewable at: www.CascadeGatewayData.com.

Location

The Cascade Gateway Border Data Warehouse incorporates data from the four ports-of-entry between the Lower Mainland, BC and Whatcom County, WA. It also includes additional data collected from readers on Interstate 5.

Why this project was needed

The original Cascade Gateway Border Data Warehouse, developed in 2007 (see below), needed an upgrade to improve website efficiency, storage capability, and querying tools. This project was seen as an ideal candidate to test the effectiveness of the BIFA template, developed to better capture complex Intelligent Transportation Systems (ITS) architectures that cross the U.S. – Canada border.

Results

The Cascade Gateway Border Data Warehouse has received a complete upgrade to improve functionality, security, and the quantity of data saved within the system. A full series of reports were developed to describe the process of using the BIFA template to develop a project architecture, and to review and provide guidance to other regions considering the BIFA for their cross-border ITS projects.

Cost

$490,000

Funding & Partnerships

This project was funded by:

Project Reports


Original Cascade Gateway Border Data Warehouse Project

Status: Completed in 2007

Overview

The original border wait time archive project captured data coming from the B.C. Ministry of Transportation and WA State Department of Transportation  advanced traveler information systems and presented the data in an online archive accessible to the public.

Location

The Cascade Gateway Border Data Warehouse incorporates data from the four ports-of-entry between the Lower Mainland, BC and Whatcom County, WA.

Results

The project developed a schema-based standard for organizing the traffic data coming in from two systems, compiled a GPS inventory of state and provincial ATIS system components, and developed an online archive accessible at: CascadeGatewayData.com.

Cost

$220,000

Funding & Partnerships

This project was funded by:

Project Reports