from flat files to usable deliverables: fme empowers transit
DESCRIPTION
TRANSCRIPT
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 [email protected]