![Page 1: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/1.jpg)
1
From Flat Files toUsable Deliverables:FME Empowers Transit
Michael GrantManager, Monitoring & Forecasting
![Page 2: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/2.jpg)
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
![Page 3: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/3.jpg)
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.
![Page 4: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/4.jpg)
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
![Page 5: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/5.jpg)
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)
![Page 6: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/6.jpg)
6
Example – BSMS
Bus Stop Management System (BSMS)
![Page 7: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/7.jpg)
7
Example – BSMS
BaseStops.csv
![Page 8: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/8.jpg)
8
Example – BSMS
Naming Bus Stops
![Page 9: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/9.jpg)
9
Example – Google Transit
General Transit Feed Specification (GTFS)
![Page 10: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/10.jpg)
10
Example – Google Transit
Combine GTFS with Bus Stops
![Page 11: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/11.jpg)
11
Example – Google Transit
Google Transit Trip Planner
![Page 12: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/12.jpg)
12
Example – Route Paths
Process GTFS to a usable format
![Page 13: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/13.jpg)
13
Example – Route Paths
HastusFormatted1
![Page 14: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/14.jpg)
14
Example – Route Paths
From Bus Stop – To Bus Stop
![Page 15: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/15.jpg)
15
Example – Route Paths
Building the routes
![Page 16: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/16.jpg)
16
Example – Offset Paths
OffsetPaths – Custom Transformer
![Page 17: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/17.jpg)
17
Example – Offset Paths
Offset Paths with Bezier Curves
![Page 18: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/18.jpg)
18
Example – Offset Paths
Offset Paths with symbology
![Page 19: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/19.jpg)
19
Example – Schedule Animation
Show schedule animation
![Page 20: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/20.jpg)
20
Example – APC Dat file
Raw APC Dat file
![Page 21: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/21.jpg)
21
Example – APC Animation
Show APC animation
![Page 22: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/22.jpg)
22
Example – EpochDatetime
Formatting the date and time
![Page 23: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/23.jpg)
23
Example – AzimuthCalculator
Calculate the azimuth from A to B
![Page 24: From Flat Files to Usable Deliverables: FME Empowers Transit](https://reader037.vdocuments.us/reader037/viewer/2022110114/547c304fb37959892b8b4f9b/html5/thumbnails/24.jpg)
24
Thank You!
Questions?
For more information: Michael Grant
Manager, Monitoring & Forecasting BC Transit [email protected]