Portland State University

View slides

The video begins at 5:38.

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...

PRESENTATION ARCHIVE

• Video
• Presentation slides

OVERVIEW

Many transit agencies plan to automate their fare collection and limit the use of cash, with the goals of improving boarding and data collection while lowering operating costs. Yet about 10% of adults in the United States lack a bank account or credit card, and many either rely on restrictive cell-phone data plans or don’t have access to internet or a smartphone. 

This webinar will present part of a larger research project exploring these issues in the cities of Denver, Colorado, and Eugene and Portland–Gresham, Oregon. In this part, we explore the tradeoffs between reducing cash acceptance, ridership and the costs of fare collection systems. How much does it save to reduce cash acceptance, verses ridership and equity impacts?

We will also present a cost-effectiveness framework that combines a qualitative and quantitative analysis and use this model to explore case scenarios in our three cities. The model shows that adding a retail network to...

PRESENTATION ARCHIVE

Miss the webinar or want a look back?

• Watch the recorded video
• View the presentation slides

OVERVIEW

This webinar will present an open-source socio-transportation analytic toolbox (STAT) for public transit system planning. This webinar will consist of a demonstration of the STAT toolbox, for the primary purpose of getting feedback from transit agencies on the tool's usefulness. We are especially interested in hearing about any improvements that would aid transit agencies in implementing it.

The STAT toolbox was created in an effort to integrate social media and general transit feed specification (GTFS) data for transit agencies, to aid in evaluating and enhancing the performance of public transit systems. The toolbox enables the integration, analysis, and visualization of two major new open transportation data sources—social media and GTFS data—to support transit decision making. In this webinar, we will introduce how we...