from flat files to usable deliverables: fme empowers transit

1

From Flat Files toUsable Deliverables:FME Empowers Transit

Michael GrantManager, Monitoring & Forecasting

2

Overview

Background BC Transit, Monitoring & Forecasting

FME Empowerment Why we use FME

Flat Files BSMS, Hastus, APC

Examples Automating bus stop names Google Transit Building bus route paths (with offsets) Displaying Automated Passenger Count data

3

Background

BC Transit Authority for public passenger transportation

systems and rail transit systems in regions throughout BC.

Monitoring & Forecasting Department for monitoring BC Transit's

productivity.

4

FME Empowerment

Need Data driven department

Data in / data out… lots of processing and analysis

Existing Software Good and bad…

Development of standards Improve quality, efficiency, and functionality

Benefits of FME Control the process Customize based on the data available Customize the outputs

5

Flat Files

Bus Stop Management System (BSMS) BaseStops.csv (import/export file) Contains all of the BUS STOP attributes

Hastus (scheduling software) General Transit Feed Specification (GTFS)

Automated Passenger Counters (APC) *.dat files (raw data)

6

Example – BSMS

Bus Stop Management System (BSMS)

7

Example – BSMS

BaseStops.csv

8

Example – BSMS

Naming Bus Stops

9

Example – Google Transit

General Transit Feed Specification (GTFS)

10

Example – Google Transit

Combine GTFS with Bus Stops

11

Example – Google Transit

Google Transit Trip Planner

12

Example – Route Paths

Process GTFS to a usable format

13

Example – Route Paths

HastusFormatted1

14

Example – Route Paths

From Bus Stop – To Bus Stop

15

Example – Route Paths

Building the routes

16

Example – Offset Paths

OffsetPaths – Custom Transformer

17

Example – Offset Paths

Offset Paths with Bezier Curves

18

Example – Offset Paths

Offset Paths with symbology

19

Example – Schedule Animation

Show schedule animation

20

Example – APC Dat file

Raw APC Dat file

21

Example – APC Animation

Show APC animation

22

Example – EpochDatetime

Formatting the date and time

23

Example – AzimuthCalculator

Calculate the azimuth from A to B

24

Thank You!

Questions?

For more information: Michael Grant

Manager, Monitoring & Forecasting BC Transit michael_grant@bctransit.com