1 / 21

Holistic Vehicle Tracking System

Future Transit Now. Holistic Vehicle Tracking System. Adam Elliott, Taylor Kinsella, Matthew Lillywhite, Christopher McNeil. Agenda. Introduction Proof of Concept Where the idea came from Major Components Recommendations Conclusions Questions & Answers References. Introduction.

tamera
Download Presentation

Holistic Vehicle Tracking System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Future Transit Now Holistic Vehicle Tracking System Adam Elliott, Taylor Kinsella, Matthew Lillywhite, Christopher McNeil

  2. Agenda • Introduction • Proof of Concept • Where the idea came from • Major Components • Recommendations • Conclusions • Questions & Answers • References

  3. Introduction • Holistic Vehicle Tracking System • Adam Elliott • Database Management • Christopher McNeil • Web Development • Matthew Lillywhite • Infrastructure • Taylor Kinsella

  4. Proof of Concept • Hardware capable of tracking geographical position and sending over cellular network • Server capable of accepting data send from hardware and log into database • Web server used by transit customers to query database • Plotted on interactive google map • Login registration and favourite route • Password encryption / best practices

  5. Where Did the Idea Originate? • All Calgary Public Transit users can relate • Inconsistent scheduling times • Weather deterred

  6. Major Project Components • Server, services and virtualization • Network, routing and port forwarding • Hardware module (Arduino) • Website development • Database development & selection

  7. Server • HP ProLiant DL380 G7 • Hardware RAID • Virtualization • Windows Server 2012 • Uninterruptable Power Supply • Management • iLO Server rack with UPS

  8. Services Member Server • IIS 7 • PHP & Python parser • MySQL Database Domain Controller • DNS • Active Directory Domain Services • GPO

  9. Virtualization Software VMWare VsphereESXi 5.1 • Bare Metal Hyper Visor • VMWare Vclient http://www.vmware.com

  10. Networking / Routing Port Forwarding • Port 80 • Port 3343 • Port 3379 • SSH D-Link Linksys • DD-WRT • Access Controls • DHCP http://www.linksys.com/en-ca

  11. Hardware Module Arduino • Arduino Uno R3 • Arduino Mega 2560 • Adafruit Ultimate GPS Breakout V3 • SM5100b GSM Shield Modules Arduino Mega 2560 Hammod Case

  12. Hardware Module Arduino Mega 2560 Bread Board Arduino Uno R3

  13. Website Development Proj354 Portal • Simplistic • Galleria • Single point of resources Transit Buddy • Responsive (percent-based CSS) • PHP interaction with MySQL database • Hosted via IIS 7 • Integrated Google map http://www.php.net

  14. Website Development Website Performance test http://www.gtmetrix.com

  15. Website Development Transit Buddy with Integrated Google Map

  16. Database Development • Microsoft SQL • My SQL • Microsoft Access • Calgary Transit .CSV imports • Salting and hashing

  17. Database Development Database Design

  18. Recommendations • Device be duplicated and field tested using a single route by Calgary Transit. • Arduino Mega to a “Teensy” development board • Circuit boards and programming chips on a larger scale • Script to update database daily to show which busses are servicing which routes. • Moving to C++ or C#

  19. Conclusions • Proof of concept • 6 million line database • Arduino module with GPS and GSM • Responsive web design (CSS) • Integrated google map • Use of PHP and python • MySQL over MS SQL

  20. Questions & Answers

  21. References • http://www.calgarytransit.com/html/annual_ridership.html • http://www.calgarytransit.com/html/statistics.html • http://transitcamp.ca/2013/10/13/candidate-responses-innovative-ideas-and-the-role-of-transit/ • http://www.nextbus.com/ • http://hosted.fleetcomplete.com/01_start.html • http://www.gpspolice.com/ • http://web.archive.org/web/20121105140753/http://jayeshprojects.blogspot.ca/2010/04/real-time-mobile-gps-tracker-with.html • https://data.calgary.ca/OpenData/Pages/DatasetListingAlphabetical.aspx#C

More Related