Portland State University

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

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:

• PostgreSQL – Download at: https://www.postgresql.org/download/
• pgAdmin4 – Download at: https://www.pgadmin.org/download/

REGISTRATION

PROFESSIONAL DEVELOPMENT

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

Friday Transportation Seminars at Portland State University have been a tradition since 2000. You can join us online at 11:30 AM. All presentations are recorded and shared on the event page afterwards.

PRESENTATION ARCHIVE

• Darshan Chauhan's Presentation Slides
• Sangwan Lee's Presentation Slides
• Video
• PDH Certificate

THE TOPIC

Join us for a two-part seminar diving into research that was presented by Portland State University students at the annual meeting of the Transportation Research Board (TRB) in January 2022.

FIRST PRESENTATION
Drone Facility Location Considering Coverage Reliability: Application to Emergency Medical Scenarios
Darshan Chauhan, Civil & Environmental Engineering

In honor of our 10-year anniversary, we’re trying something a little different. Instead of brief sessions that introduce you to a topic– we will be offering fifteen half-day workshops that focus on skill building and providing the tools to apply the latest research to practice. These will be hands-on, immersive learning experiences in a small classroom setting.

REGISTRATION

This event is a la carte, and pricing is per workshop. You may attend as few as one, or as many as four workshops.

• Half-Day Workshop (general admission): $95
• Half-Day Workshop (student rate): $50

THE PROGRAM

⇨SEE THE FULL SCHEDULE AND DETAILS

• Survey Design: Asking the Right Questions
• Bicycle/Pedestrian Focused Signal Timing Strategies: What, When, Where, Why, and How?
• Activating Community Opportunities Using Transportation Organizations as Assets
• Cost Accounting for Program and Budget Planning Today and Tomorrow
• Data Analysis for Smarties Who Forgot What They Learned in College
• What’s New in the HCM 6th Edition?
• Ecological Momentary Assessment Methods with Transportation Disadvantaged Populations
• Calculating...

The video begins at 1:20.

View slides: Foster Presentation (PDF)

View slides: Muhs Presentation (PDF)

View slides: Wagner Presentation (PDF)

Summaries:

Evaluating Driver and Pedestrian Behaviors at Enhanced Multilane Midblock Pedestrian Crossings: Case Study in Portland, Oregon This study examines driver and pedestrian behaviors at two enhanced midblock pedestrian crossings in Portland, Oregon. One crossing is on a five-lane arterial with a posted speed of 35/45 miles-per-hour (MPH) and features six rectangular rapid flash beacon (RRFB) assemblies and a narrow median refuge. The other crossing is on a suburban arterial with four travel lanes and a two-way left-turn lane. The crossing is enhanced with four RRFB assemblies and a median island with a “Z” crossing, or Danish offset, designed to encourage pedestrians to face oncoming traffic before completing the second stage of their crossing. Approximately 62 hours of video have been collected at the two locations. A total of 351 pedestrian crossings are analyzed for driver compliance (yielding) rates, pedestrian...