緊急事故醫療資源整合平台與大數據分析應用

Emergency Medical Resource Information Service Platform and Its Big Data Analysis Applications

10.6285/MIC.201908/SP_02_8.0003

邢學皓(Shue-Hao Sing)；廖宗得(Tsung-Der Liao)；張顯瑞(Shen-Ruei Chang)；曾聖傑(Scern-Jie Tseng)；周韻寰(Annie Y. H. Chou)；曾守正(Frank S. C. Tseng)

醫療資源 ； 資料倉儲 ； 大數據分析 ； Medical Resources ； Data Warehousing ； Big Data Analysis

管理資訊計算

8卷特刊2（2019 / 08 / 01）

21 - 36

繁體中文

本研究探討如何開發一個醫療資源資訊服務平台，透過爬蟲程式蒐集網路上各醫院公開的病床與門診資訊，整合之後存入資料庫中，除了將各醫院的資料格式統一之外，也透過建置查詢網站以及手機App，提供民眾和院方進行整合式查詢，提高緊急事故發生時能正確導引到有空病床的醫院或轉診效率。透過行動裝置上的GPS定位，則可以從使用者端蒐集其查詢地點的資訊，並結合從醫院方面蒐集到的醫療資訊，透過大數據分析方式，將緊急事故的熱點地圖以視覺化方式呈現，幫助民眾分辨容易產生交通事故的地點，藉此規畫或引導民眾找到更安全的回家路線，並讓各醫院了解偏遠地區民眾的需求，以及病床的使用情形。

This study explores how to develop a medical resource information service platform to collect information on hospital beds and outpatient clinics in various hospitals through a development of Web crawler, and the integration of collected data into a database. In addition to unifying the data formats of the hospitals, our system offer functionalities for querying the website and develop a mobile app to provide an integrated query result of the hospital sickbeds to improve the efficiency of referral to the hospital with available sickbeds when an emergency occurs. Through the GPS positioning on users mobile devices, the information of the location of the inquiry can be collected from the user side, and the medical information collected from the hospital can be combined to visually present the hot spot map of global emergency situation through big data analysis approach. This substantially help people identify places that are prone to traffic accidents, thereby hopefully assist users to plan or find a safer route. Besides, it also help hospitals understand the medical resources needed in rural township areas and the usage of hospital sickbeds.

1. 內政部統計處統計地圖API(2019)，https://segisapi.moi.gov.tw/STAT_API_SAMPLE/api
2. Google Maps Platform (2019)，https://developers.google.com/maps/?hl=zh-tw
3. 維基百科 (2019)，https://zh.wikipedia.org/wiki/資料倉儲
4. Android Studio Developer (2019)，https://developer.android.com/studio
5. Yam news (2017)，「醫療系統聯盟」5 月份在東海大學成立，可望提供跨領域的醫療產學服務，https://n.yam.com/Article/20170507174547
6. TGOS Map API (2019)，https://api.tgos.tw/TGOS_MAP_API/docs/site/web
7. Google Chart (2019)，https://developers.google.com/chart/
8. 用數據看台灣 (2019)，https://www.taiwanstat.com/statistics/medical-resources/
9. Google 地圖 (2019) ，https://zh.wikipedia.org/wiki/Google%E5%9C%B0%E5%9B%BE
10. Guest editors Basole, R.C. (2016), Applying Visualization to Understand Sports Data and Predict Results, IEEE Computer Graphics and Applications, https://www.computer.org/web/pressroom/computer-graphics-sports
11. Golfarelli, M. and Rizzi, S. (2009), Introduction to Data Warehousing, McGraw-Hill Osborne Media. https://cdn.ttgtmedia.com/searchDataManagement/downloads/Data_Warehouse_Design.pdf
12. Han, J.,Kamber, M.,Pei, J.(2016).Data Mining. Concepts and Techniques.The Morgan Kaufmann.
13. Heer, Jeffrey (2017), “Advances in Information Visualization,” Computing Now, IEEE Tech News, https://dx-dev.computer.org/publications/tech-news/computing-now/advances-in-information-visualization
14. Inmon, W.(1992).Building the Data Warehouse.Wiley and Sons.
15. Jarmul, K.,Lawson, R.(2017).Python Web Scraping: Hands-on data scraping and crawling using PyQT, Selnium, HTML and Python.
16. Mitchell, R.(2015).Web Scraping with Python: Collecting Data from the Modern Web.O’Reilly Media, Inc..
17. 易起宇(2018)，醫療App盛行。比看醫生便宜，經濟日報，https://money.udn.com/money/story/10868/3418798
18. 施協源(2010)，TVBS News，沒救護車？疑長庚醫院扣車害人。https://news.tvbs.com.tw/local/77971
19. 曾守正,周韻寰(2018).大數據分析之資料庫理論與實務.華泰文化出版.
20. 辜騰玉 (2014)，Android 開發者久等了，官方 IDE 開發工具 Android Studio 重點特色快看，https://www.ithome.com.tw/news/92892
21. 黃啟銘 (2018)，高雄榮總。啟動國際醫療 APP 遠距服務，經濟日報，https://money.udn.com/money/story/11800/3216789
22. 蔡維斌 (2018)，媽祖醫院新創遠距醫療 APP，不識字老人都會操作，聯合新聞網，https://udn.com/news/story/7326/3413048
23. 衛生福利部中央健康保險署 (2019)，重度級急救責任醫院急診即時訊息，http://www.nhi.gov.tw/SysService/SevereAcuteHospital.aspx