Improving Information Usability at BC Transit Michael Grant

Improving Information Usability at BC Transit Michael Grant Manager, Monitoring & Forecasting 1

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 2

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

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 4

Flat Files § Bus Stop Management System (BSMS) § Base. Stops. 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) 5

Example – BSMS § Bus Stop Management System (BSMS) 6

Example – BSMS § Base. Stops. csv 7

Example – BSMS § Naming Bus Stops 8

Example – Google Transit § General Transit Feed Specification (GTFS) 9

Example – Google Transit § Combine GTFS with Bus Stops 10

Example – Google Transit § Google Transit Trip Planner 11

Example – Route Paths § Process GTFS to a usable format 12

Example – Route Paths § Hastus. Formatted 1 13

Example – Route Paths § From Bus Stop – To Bus Stop 14

Example – Route Paths § Building the routes 15

Example – Offset Paths § Offset. Paths – Custom Transformer 16

Example – Offset Paths § Offset Paths with Bezier Curves 17

Example – Offset Paths § Offset Paths with symbology 18

Example – Schedule Animation § Show schedule animation 19

Example – APC Dat file § Raw APC Dat file 20

Example – APC Animation § Show APC animation 21

Example – Epoch. Datetime § Formatting the date and time 22

Example – Azimuth. Calculator § Calculate the azimuth from A to B 23

Thank You! § Questions? § For more information: § Michael Grant § Manager, Monitoring & Forecasting § BC Transit § michael_grant@bctransit. com 24