holistic vehicle tracking system
DESCRIPTION
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. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/1.jpg)
Holistic Vehicle Tracking System
Adam Elliott, Taylor Kinsella, Matthew Lillywhite, Christopher McNeil
Future Transit Now
![Page 2: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/2.jpg)
Agenda
• Introduction• Proof of Concept• Where the idea came from• Major Components• Recommendations• Conclusions• Questions & Answers• References
![Page 3: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/3.jpg)
Introduction• Holistic Vehicle Tracking System– Adam Elliott
• Database Management– Christopher McNeil
• Web Development– Matthew Lillywhite
• Infrastructure– Taylor Kinsella
![Page 4: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/4.jpg)
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
![Page 5: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/5.jpg)
Where Did the Idea Originate?• All Calgary Public Transit users can relate• Inconsistent scheduling times• Weather deterred
![Page 6: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/6.jpg)
Major Project Components• Server, services and virtualization• Network, routing and port forwarding• Hardware module (Arduino)• Website development• Database development & selection
![Page 7: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/7.jpg)
Server
HP ProLiant DL380 G7• Hardware RAID• Virtualization• Windows Server 2012• Uninterruptable
Power Supply• Management• iLO
Server rack with UPS
![Page 8: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/8.jpg)
ServicesMember Server• IIS 7• PHP & Python parser• MySQL DatabaseDomain Controller• DNS• Active Directory Domain Services• GPO
![Page 9: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/9.jpg)
Virtualization Software
VMWare Vsphere ESXi 5.1• Bare Metal Hyper Visor• VMWare Vclient
http://www.vmware.com
![Page 10: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/10.jpg)
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
![Page 11: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/11.jpg)
Hardware Module
Arduino
Arduino Mega 2560 Hammod Case
• Arduino Uno R3• Arduino Mega 2560
• Adafruit Ultimate GPS Breakout V3• SM5100b GSM Shield
Modules
![Page 12: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/12.jpg)
Hardware Module
Arduino Mega 2560 Bread BoardArduino Uno R3
![Page 13: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/13.jpg)
Website DevelopmentProj354 Portal• Simplistic• Galleria• Single point of resourcesTransit Buddy• Responsive (percent-based CSS)• PHP interaction with MySQL database• Hosted via IIS 7• Integrated Google map
http://www.php.net
![Page 14: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/14.jpg)
Website Development
Website Performance testhttp://www.gtmetrix.com
![Page 15: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/15.jpg)
Website Development
Transit Buddy with Integrated Google Map
![Page 16: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/16.jpg)
Database Development• Microsoft SQL• My SQL• Microsoft Access• Calgary Transit .CSV imports• Salting and hashing
![Page 17: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/17.jpg)
Database Development
Database Design
![Page 18: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/18.jpg)
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#
![Page 19: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/19.jpg)
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
![Page 20: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/20.jpg)
Questions & Answers
![Page 21: Holistic Vehicle Tracking System](https://reader034.vdocuments.us/reader034/viewer/2022051317/56816362550346895dd4343a/html5/thumbnails/21.jpg)
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