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

Bike Lanes And Retail Sales: A Rigorous Coast-To-Coast Study Is In The Works

The Future of Transportation in Downtown Portland: Inspirations from the 1972 Downtown Plan

Join us Monday, October 24, as TREC director Jennifer Dill moderates a panel on the Future of Transportation in Downtown Portland. Register to attend in person (space is limited), or join online via Zoom.

Moderator: Jennifer Dill, Professor, Toulan School of Urban Studies & Planning and Director of PSU’s Transportation Research and Education Center (TREC)

Panelists:
Gabriel Graff, Central City Capital Program Manager, Portland Bureau of Transportation
Cathy Tuttle, Board Member, BikeLoud PDX
André Lightsey-Walker, Policy Transformation Manager, The Street Trust
​​Mark Raggett, Associate Principal, GBD Architects and Director of Planning and Design, Friends of Green Loop

The year 2022 marked the 50th anniversary of the City of Portland's 1972 Downtown Plan, one of the most consequential plans in the city's history. It put in place a vision for a public, pedestrian-scaled, multipurpose, and vital downtown. Through the requirements adopted in the Downtown Plan and subsequent...

Read more

Inaccessible Accessibility: low-income households and barriers to the “new American dream”

The video begins at 0:20.

Topic: Inaccessible Accessibility: low-income households and barriers to the “new American dream”

In many ways, the resurgence in demand for housing in highly accessible and walkable neighborhoods can be viewed as a triumph of planning and policy efforts to reinvest in walkable urban neighborhoods that support active travel. However, increased demand has resulted in price premiums that can make location-efficient housing choices more difficult for low-income households. This research uses data from a survey of recent movers in six U.S. cities, including Portland, to explore the extent to which households of different economic means are able to choose housing locations that match their accessibility and transportation preferences.

Bio: Arlie Adkins is a PhD candidate and adjunct instructor in the Toulan School of Urban Studies and Planning at Portland State University. His dissertation research focuses on better understanding how people make decisions about non-work travel behavior in the context of a new home. Arlie holds a master’s degree in city planning from UC Berkeley. He previously worked in TriMet’s project planning department as a community affairs specialist and at Flexcar in Washington, DC.

An Analysis of the Efficiency of Urban Commercial Vehicle Tours

The video begins at 1:09.

MURP Workshop Extravaganza

View Hilltop Planning Group's Slides

View Delta Planning Group's Slides

Watch video:

MURP Workshop Extravaganza

The PSU Master of Urban and Regional Planning (MURP) program is known for its workshop projects. For the last two quarters of the program, students work on community-based, client-focused projects. This provides students with the opportunity to work in teams on real-world...

Read more

Divvy's Top Rider Talks About Getting African-Americans Onto Divvy Bikes

Bike-Share Equity In Boston, A Work In Progress

Skateboarding as Transportation: Findings from Exploratory Research

The video begins at 2:45.

Topic: Skateboarding as Transportation: Findings from Exploratory Research

Bio: Tessa Walker is currently completing her thesis on non-motorized transportation and qualitative research methods with supervision from Dr. Jennifer Dill and Dr. David Morgan. For more information on her thesis research please visit the Skate Study PDX website (http://www.skatestudypdx.wordpress.com). Tessa has previously worked in town planning in Vermont, sustainability auditing in Massachusetts, and in bicycle and pedestrian transportation research with the Family Activity Study at PSU. She is currently an intern at the public opinion research firm DHM Research, and she will be a 2013-2014 Hatfield Fellow.

Pages