Transportation Data Education: SQL Workshop

Join us for a three day introductory in-person workshop on databases and SQL

June 17, 18, and 20, 1:00 pm - 4:30 pm

Each day will be a combination of a lecture and practical. We will cover:

  • Introduction to relational databases.
  • Structured query language (SQL).
  • How to setup a PostgreSQL database on your local machine and use it to analyze data.

Software Requirements

You will be expected to bring your own laptop and have all required software installed prior to the workshop. If you are using a work-issued laptop, you will most likely need administrator privileges to install the following required software:

REGISTRATION

General: $325
Non-profit and community-based organizations: $125
PSU Students: $10 

PROFESSIONAL DEVELOPMENT

This three-day workshop is eligible for 9 hours of professional...

Read more

Webinar: Scooting to Healthy and Safe Mode Choices

PRESENTATION ARCHIVE

OVERVIEW

Shared electric scooters (e-scooters) are fast becoming a mobility option in cities across the United States. This new micromobility mode has the potential to replace car usage for certain trips, which stands to have a positive impact on public health and sustainability goals. However, many aspects of this emerging mode are not well understood.This webinar explores the findings of three NITC studies examining transportation mode choices, safety, and public health outcomes of electric scooters.

KEY LEARNING OUTCOMES

By the end of this presentation, the participant will be able to:

  • describe the ways in which electric scooters may provide new substitutive, complimentary or synergist transportation opportunities for different activities...
Read more

TRB Highlights: 3 PSU Student Presentations

Watch video

View slides: Bell Presentation (PDF)

Moore Presentation (PDF)

Ma Presentation (PDF)

Summaries: 
Identification and Characterization of PM2.5 and VOC Hot Spots on Arterial Corridor by Integrating Probe Vehicle, Traffic, and Land Use Data: The purpose of this study is to explore the use of integrated probe vehicle, traffic and land use data to identify and characterize fine particulate matter (PM2.5) and volatile organic compound (VOC) hot spot locations on urban arterial corridors. An emission hot spot is defined as a fixed location along a corridor in which the mean pollutant concentrations are consistently above the 85th percentile of pollutant concentrations when considering all other locations along the corridor during the same time period. In order to collect data for this study, an electric vehicle was equipped with instruments designed to measure PM2.5 and VOC concentrations. Second-by-second measurements were performed for each pollutant from both the right and left sides of the vehicle. Detailed meteorological, traffic and land use data is also...

Read more

Older Drivers in Oregon: Factors Associated with Continuing or Ceasing to Drive

View slides

The video begins at 3:00.

Research Rounds Speaker Series: Dr. Lisa Bates

This event was hosted by Portland State University's Research and Strategic Partnerships. See the schedule for the monthly Research Rounds Speaker Series here.

REVISIT THE LECTURE: VIDEO AND SLIDES

 Miss the lecture or want a look back at the presentation? Watch the video, or view the presentation slides here.

"Naturally Occurring" or "Until Market Speculation Starts":...

Read more
Info Session: Apply to be a MURP at Portland State for 2019

Online Info Session: PSU Master of Urban and Regional Planning (MURP)

WATCH THE RECORDED VIDEO

 

INFO SESSION OVERVIEW

Thinking about a graduate degree in urban and regional planning? Do you have questions about the Portland State University program? Looking for tips on how to write a great application? You're not alone! Join us on December 13 for an online information session designed to get you the information you need.

Learn more about the MURP program here - where you can read up on seven reasons to become a MURP, meet the faculty, and see FAQ answered.

KEY LEARNING OUTCOMES

  • Meet our faculty and current students
  • Learn how the program works and what makes it unique
  • Explore all the ways Portland is the perfect place to get a planning education
  • Ask your questions and get answers

The priority application deadline for Fall...

Read more

Cyclist Compliance at Signalized Intersections

Watch video

View slides

Summary: Although the running of red lights is perceived by motorists as a commonplace behavior for cyclists, little research has been done on the actual rates of cyclist compliance at signalized intersections. Furthermore, little is known about the factors that influence cyclist non-compliance. This research seeks to illuminate the rates of and reasons for infringement against red lights using video footage and survey data from cyclists in Oregon. 

Bio: Sam became interested in transportation and planning while studying abroad in Freiburg im Breisgau, Germany. After benefiting from the efficient transit service and excellent walkability there, he came back to the states with a gusto for safe, efficient, and environmentally sustainable transportation. After finally figuring out what to do with his Civil Engineering degree, he enrolled in Portland State. Sam's research interests include cyclist behavior and the comprehension and safety implications of new infrastructure. Originally hailing from Kansas, he has grown weary of Wizard of Oz jokes but is otherwise happy to call Portland his home, especially with the abundance of good coffee, micro brews, and stellar pie that PDX has to offer.

Webinar: Collecting and Analyzing Pedestrian Behaviors at Intersections Using LiDAR Tracking Technologies

PRESENTATION ARCHIVE

OVERVIEW

The aim of this research is to investigate pedestrian behavior at signalized intersections using state-of-the-art LIDAR sensing technologies and to use this data, along with vehicular data, to develop a more effective multimodal signal control system.

In the presentation, the presenters will describe a novel method of collecting pedestrian crossing behaviors at signalized intersection, discuss the findings and implications of data analytics, and introduce a novel approach to dynamic flashing yellow arrow mechanisms to reduce the conflict between left turn vehicles and crossing pedestrians.

KEY LEARNING OUTCOMES

  • Understand the framework of LiDAR sensing solutions;
  • Understand how to collect pedestrian behaviors at intersections;
  • Understand how to provide new protection for crossing pedestrians with object-tracking technologies.

THE RESEARCH

This webinar is based on a study funded by the National Institute...

Read more

Behavioral Responses to Oregon's Mileage Fee Experiment

The video begins at 2:08.

Back to School at PSU: Students in Transportation Engineering and Planning (STEP)

Calling all Portland State University transportation students: Join us for a Fall 2021 Back-to-School gathering!

After a year of remote learning, we're excited to be back on campus - starting with our annual Fall mixer for transportation students, staff and faculty. Meet us on the rooftop of the Urban Center Building for a meet-and-greet and free lunch. This will be an outdoor event with room to spread out – please wear a mask to keep everyone safe.

If you're interested in a career in transportation – whether you're enrolled in the PSU school of civil engineering, urban studies, or another transportation-adjacent discipline – this event is for you. RSVP here!

STUDENT LEADERSHIP BOARD

The Students in Transportation Engineering and Planning (ITE-STEP) student group at PSU have been helping students interested in mobility connect across disciplines for many years. STEP hosts professional development events, field tours of transportation infrastructure, game nights, and more! Through STEP, transportation students can get connected to funding for attending trainings and conferences. Additionally, they...

Read more

Pages