Experience implementing portal portland transportation archive listing
Download
1 / 30

Experience Implementing PORTAL: Portland Transportation Archive Listing - PowerPoint PPT Presentation


  • 114 Views
  • Uploaded on

Experience Implementing PORTAL: Portland Transportation Archive Listing. Andrew M. Byrd Andy Delcambre Steve Hansen Portland State University TransNow 2 nd Annual Conference Portland, Oregon  November 19, 2004. Outline. What is PORTAL?

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Experience Implementing PORTAL: Portland Transportation Archive Listing' - adam-williamson


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Experience implementing portal portland transportation archive listing

Experience Implementing PORTAL: Portland Transportation Archive Listing

Andrew M. Byrd

Andy Delcambre

Steve Hansen

Portland State University

TransNow 2nd Annual Conference

Portland, Oregon  November 19, 2004


Outline
Outline Archive Listing

  • What is PORTAL?

  • National ITS Architecture and Archived Data User Service (ADUS)

  • PORTAL (the Portland Transportation Archive Listing)

  • Describe Architecture

  • Describe Database Processing and Storage

  • PORTAL Applications

  • Next Steps


Introduction guiding principles
Introduction Archive ListingGuiding Principles

“Data are too valuable to only use once.”


Introduction guiding principles1
Introduction Archive ListingGuiding Principles

“Management of the transportation system cannot be done without knowledge of its performance.”


Archived data user service adus its architecture 1999
Archived Data User Service (ADUS) Archive ListingITS Architecture 1999

  • USDOT Vision for ADUS:

    “Improve transportation decisions through the archiving and sharing of ITS generated data.”

  • Principles of ADUS to Achieve Vision

    • All ITS deployments should consider data archiving

    • Archive data to maximize integration with other data sources and systems

    • Archive data in a way that eases retrieval for those with access

    • Provide information that is integral to transportation practice


Archived data user service adus implementing a successful data archive
Archived Data User Service (ADUS) Archive ListingImplementing a Successful Data Archive

A Few Examples of Existing Systems

  • California PeMS - only statewide system

  • Puget Sound (WSDOT/TRAC) - started small and successfully expanded

  • San Antonio, TX TransGuide, Datalink system

    Cooperation with Various Agencies

  • Oregon Department of Transportation

  • Metro (Portland’s regional planning agency)

  • The City of Portland

  • TriMet (Portland’s regional transit agency)


Portland transportation archive listing portal psu designated as regional archive center
Portland Transportation Archive Listing (PORTAL) Archive ListingPSU Designated as Regional Archive Center

  • Through regional cooperation, Portland State University is the regional center for collecting, coordinating and disseminating variable sources of transportation data and derived performance measures.


Portal architecture regional its data sources
PORTAL Architecture Archive ListingRegional ITS Data Sources

  • 77 CCTV Cameras

  • 18 Variable Message Signs (VMS)

  • 436 Inductive Loop Detectors

  • 118 Ramp Meters

  • Weather data stations

  • TriMet Automatic Vehicle Location (AVL) System and Bus Dispatch System (BDS)

  • Extensive Fiber Optics Network


Portal architecture inductive loop detectors
PORTAL Architecture Archive ListingInductive Loop Detectors

  • Most commonly used data source

  • Work like a large metal detector

  • Controllers provide three data fields: volume (count), speed (average), and occupancy (% time a vehicle is over the sensor)

  • This data is aggregated at the loop controllers to 20 second resolution

  • Most frequently found at entrance ramps – one original use was for the automated control of ramp metering.


Portal architecture inductive loop detectors1

HOV Archive Listing

Lane

Inductive

Loop Sensors

(detectors)

Station

Station

Station

Ramp

PORTAL Architecture Inductive Loop Detectors


PORTAL Architecture Archive ListingInductive Loop Detectors

  • The loop detector system was put into place by ODOT - our portion of the project does not install or maintain sensors at their Transportation Management Operations Center

  • Loop detector data is used by ODOT for real-time operations – a minute to minute view of the regional transportation network

  • We are archiving the high resolution data that ODOT and others collect but do not retain after immediate use


Portal architecture fiber optic data connection
PORTAL Architecture Archive ListingFiber Optic Data Connection

Rich Johnson, City of Portland


Portal architecture data flows
PORTAL Architecture Archive ListingData Flows


PORTAL Architecture Archive ListingDatabase and Web Servers

  • We are retaining the data in a PostgreSQL database

  • Data is gathered every 20 seconds and inserted into the database

  • Every night, the preceding day’s 20 second data is aggregated to 5 minute and 1 hour resolution

  • Additional analysis is performed on the original three fields - we calculate VMT, VHT, delay, and travel time


Portal architecture database and web servers
PORTAL Architecture Archive ListingDatabase and Web Servers

  • VMT = segment length * volume

  • Travel time = segment length / speed

  • VHT = travel time * volume

  • Delay = travel time – free flow travel time (60 mph)


Portal architecture database and web servers1
PORTAL Architecture Archive ListingDatabase and Web Servers

  • Database Back End

    • SQL relational database

    • 200 MB per day of raw data

    • 75 GB per year

    • High capacity disk array

    • 5 MB compressed for download

  • Off-site backup server

    • Daily backups

    • Uninterruptible power

  • Web-based interface

    • Easily accessible

    • User-friendly

    • PHP language


Portal architecture database and web servers2
PORTAL Architecture Archive ListingDatabase and Web Servers

  • Users have the ability to:

    • sample raw data

    • store data permanently in accordance to their specifications

    • use aggregate data at desired resolutions

  • Outputs

    • onscreen table

    • plotted on relevant graphs

    • downloaded on comma separated value (CSV) format for permanent offline storage


Data analysis and visualization homepage
Data Analysis and Visualization Archive ListingHomepage


Data analysis and visualization contour plots speed
Data Analysis and Visualization Archive ListingContour Plots: Speed


Data analysis and visualization time series plots volume
Data Analysis and Visualization Archive ListingTime Series Plots: Volume


Data analysis and visualization grouped data plots speed
Data Analysis and Visualization Archive ListingGrouped Data Plots: Speed


Applications Archive ListingTravel Demand Modeling

  • Metro (the Portland regional Metropolitan Planning Organization) uses a typical four-step computer modeling process to predict future transportation needs

  • The final step of modeling (trip assignment) requires a function relating volume to delay for finding equilibrium on the highway network

  • Capacity information and volume-delay relationships for segments of Oregon Highway 217 west of Portland established from archived loop data


Applications Archive ListingTravel Demand Modeling


Applications Archive ListingTravel Demand Modeling


Applications Archive ListingPerformance Measures

  • Archived data have also been used to produce regional performance measures, allowing better understanding of the transportation network

  • Average speed maps show visually the average velocity of vehicles at different points on the highway system during peak periods

  • Congestion frequency charts show how often congestion occurs at each time of day at different points in the transportation network


Applications Archive ListingRegional Peak Period Speed Map


Applications Archive ListingCongestion Frequency Charts

Congestion frequency on I-5 South at Barbur Boulevard

Percent of time congestion occurs

Time of day


Next steps expanding archive functionality
Next Steps Archive ListingExpanding Archive Functionality

  • Data from:

    • TriMet

    • Washington State DOT

    • City of Portland

    • ODOT WIM Data

  • Additional processing tools and performance measures


Acknowledgments
Acknowledgments Archive Listing

  • National Science Foundation

  • Oregon Department of Transportation

  • City of Portland

  • TriMet

  • Portland State University

  • Oregon Engineering and Technology Industry Council


Feedback your opinions and suggestions
Feedback Archive ListingYour Opinions and Suggestions

Please let us know what you think about existing or future:

  • Data sources

  • Performance measures

  • Data visualizations and summaries

    Contact us:

    [email protected]

    http://portal.its.pdx.edu

    Sign up for an account!


ad