臺灣博碩士論文加值系統

本文以Follow-the-leader的概念，設計整合GPS (Global Positioning System)裝置、無線網路技術和數據資料庫衍生的應用系統，將群組隊伍之GPS定位資料即時傳遞並儲存在資料庫中。使用者可快速的透過三者間的互動模式，由電子地圖得知群組的正確位置，使群體關係快速的組織建立，藉此達到群組行進之跟隨設計與路線紀錄的目的。
本文主要將所構思的系統軟體發展出來，完成雛形的軟體與硬體系統整合，進行基礎的功能測試。載具的應用包含汽車、腳踏車與超輕航機，並針對各種載具應用介紹不同的設計方法。

By the general idea: “follow the leader”, a new monitoring concept for motorcade is designed and organized. The system integrates GPS, wireless network technical, GIS map and MySQL database. The member’s position in the same motorcade will be shown on the GIS map in real time. Therefore, the leader and follower’s relationship will be built quickly.
The system architecture and design concept are discussed for different kind of vehicle characteristics. Real world tests are demonstrated and verified in cars, bicycles and even ultra light aircrafts.

CONTENTS
Abstract i
摘要 ii
CHAPTER I INTRODUCTION 1
1.1 Motivation 1
1.2 Main Idea 2
1.3 Literature Survey 4
1.4 Scope 7
1.5 Thesis Outline 8
CHAPTER II TECHNICAL BACKGROUND AND SOLUTION 10
2.1 Problem Background 10
2.2 Technical Background 11
2.2.1 Car PC 11
2.2.2 Wireless Communication 12
2.2.3 Global Positioning System 13
2.2.4 Geographic Information System 15
2.2.5 MySQL database 17
2.3 Remarks 18
CHAPTER III SYSTEM ARCHITECTURE 19
3.1 Hardware And Software Architecture 19
3.2 Car Client 21
3.2.1 Distance Analysis 23
3.3 The Server in Surveillance Center 26
3.4 Database Arrangement 29
3.5 Remarks 30
CHAPTER IV SYSTEM IMPLEMENTATION AND VERIFICATION 31
4.1 The Server 31
4.2 The Clients 34
4.3 Remarks 39
CHATPER V SOLUTION ALGORITHM IN DIFFERENT SCENARIOS 40
5.1 Tracking Tools 40
5.1.1 TR-102 Tracker 41
5.1.2 Google Map API 43
5.2 Application about Tracking Bicycles 43
5.3 Real World Application 47
5.4 Application in Tracking Ultra Light Aircraft 56
5.5 Remarks 58
CHATPER VI DISCUSSION AND CONCLUSION 59
6.1 Discussion 59
6.2 Conclusion 60
REFERANCES 62
VITA 65

REFERANCES
[1]B. Nejikovsky, E. Keller, “Wireless communications based system to monitor performance of rail vehicles”, Railroad Conference, 2000. Proceedings of the 2000 ASME/IEEE Joint, April 2000, pp. 111- 124.
[2]X. Jianping, Z. Jun, C. Hebin, “GPS Real Time Vehicle Alarm Monitoring System Based on GPRS/CSD using the Embedded System”, Proceedings of 6th International Conference on ITS Telecommunications 2006, Vol. 1, June 2006, pp. 1155–1158.
[3]The Gravel Car Security Management System, available from website: http://www.asiatek.com.tw/sucessed/SuccessExamDetail.aspx?ID=11
[4]Intelligent Taxi Security Management and Dispatching System, available from website: http://www.asiatek.com.tw/sucessed/SuccessExamDetail.aspx?ID=9
[5]S. Parkvall, E. Englund, M. Lundevall and J. Torsner, “Evolving 3G Mobile Systems: Broadband and Broadcast Services in WCDMA”, IEEE Communication Magazine, Vol. 44, February 2006, pp. 68-74.
[6]M. Jurvansuu, J. Prokkola, M. Hanski, P. Perala, “HSDPA Performance in Live Networks”, Communications, ICC '07. IEEE International Conference on, June 2007. pp. 467-471.
[7]P. Bolstad, GIS Fundamentals: A first text on Geographic Information Systems, Second Edition, White Bear Lake, MN: Eider Press, 2005, pp. 543.
[8]I. Heywood, S. Cornelius, S.Carver, An Introduction to Geographical Information Systems, Prentice Hall, 2002, ISBN 0-13-061198-0.
[9]M. Di Giacomo, “MySQL: Lessons Learned on a Digital Library”, IEEE Software, Vol. 22, No. 3, May-June 2005, pp. 10-13.
[10]C. E. Lin, C. C. Li, “A Real Time GPRS Surveillance System using the Embedded System”, AIAA Journal of Aerospace Computing, Information and Communication, Vol. 1, No. 1, January 2004, pp. 44-59.
[11]P. I. Philippopoulos, G. Soulos, A. Krukowski, N. Argyreas, V. Gorgas, D. Kyriazanos, D. I. Axiotis, Thomopoulos, S.C.A., “ToD: An Intelligent Location-Based Transport Management System” IEEE Intelligent Vehicles Symposium, June 2007, pp. 793-798.
[12]“MySQL”, available from website: http://www.mysql.com/
[13]MSDN, available from website: http://msdn.microsoft.com/
[14]Google Map Api, available from website: http://code.google.com/intl/zh-TW/apis/maps/
[15]毛治國，「結合車輛定位與無線通訊技術在新一代道路車輛管理系統之研究」，交通部，2004-2007。
[16]簡良益、蔡長欣，「PaPaGO!SDK GIS系統建置理論與實務」，研勤科技，2004。
[17]許清榮、買大誠，「Visual Basic 2005 Express程式設計經典教本」，博碩文化，2006。
[18]陳立元、范逸之、廖錦棋，「 Visual Basic 2005與自動化系統監控」，文魁資訊，2006。
[19]王國榮，「ASP.NET網頁製作教本」，旗標出版社，2003。