1 / 16

Border Data Warehouse

Border Data Warehouse. The Cascade Gateway. Vancouver, BC. Bellingham, WA. Variable Message Signs. Northbound. Southbound. CascadeGatewayData.com. Volume. Departure rate. Delay. Queue length (meters). Vehicles in queue. Project product. BWT border wide interface

taro
Download Presentation

Border Data Warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Border Data Warehouse

  2. TheCascade Gateway Vancouver, BC Bellingham, WA

  3. Variable Message Signs Northbound Southbound

  4. CascadeGatewayData.com

  5. Volume Departure rate Delay Queue length (meters) Vehicles in queue

  6. Project product • BWT border wide interface • Nationally summarized wait time data • Portal to regional archives • Cascade Gateway data warehouse • Standard format wait time data • Other, regionally available border data • Niagara region data warehouse • Standard format wait time data • Other, regionally available border data • Border region data warehouse 3 • Standard format wait time data • Other, regionally available border data • Border region data warehouse 4, etc. • Standard format wait time data • Other, regionally available border data Project product Existing Future Future

  7. Simplified comparison of Cascade Gateway ATIS and Niagara BWT schema Cascade Gateway Niagara • Organization (WSDOT or BC MoT) • Data collection period • Organizational identifier • Detector report • Crossing (crossing & traffic type) • Crossing ID • Status (open, closed) • Lanes (fixed number of lanes) • Link direction • Delay • Open lanes • Queue length • Vehicles in queue • Service rate (vehicles per hour) • Date • Lane data (actually loop data?) • Detector lane number • Detector ID • Detector vehicle speed • Detector vehicle count • Detector occupancy • Detector average-vehicle length • Detector start time • Detector end-time • Link measurement duration • VDS identifier (actually loop IDs) • VDS name (loop names) • Link direction • ATC error code • Network status • Lane (Traveler, NEXUS, Commercial, FAST) • Port of Entry code • System status (operational, down) • Time/date of last update • Delay • Wait time event • System readiness

  8. Border-wide BWT system data elements for high-level schema • Location (port name) • Direction (to U.S., to Canada) • Traffic type (Passenger, NEXUS, Commercial, FAST) • Time unit associated with records • System status (operational, down) • CURRENT delay of cars now arriving at port • ACTUAL delay of cars now departing port

  9. Sample of System Requirements • The custom query shall result in multiple output types including data table, chart, and downloadable file. • The custom query tool shall allow users to select date ranges and days of the week. • The custom query tool shall allow users to group by month, day of week, day, am/pm, hourly, or by five minute increment. • The custom query tool shall allow users to query multiple detectors or crossings at a time. • Over 100 requirements were identified for Cascade Gateway Border Data Warehouse

More Related