臺灣博碩士論文加值系統

近年來工業發展迅速，導致河川水質汙染日益嚴重，且民眾對環境的保育意識逐漸增加。因此政府相關部門開始派員對河川水質採樣，並送回實驗室分析，但此方式非常耗費人力即時間成本。本論文設計自動量測浮台對河川水質進行自動化水質及空氣品質檢測並上傳系統，提供民眾可查看河川水質狀況。
本論文使用NI myRIO嵌入式系統做為自動量測浮台之核心控制器，以及一台電腦作為伺服器。自動量測浮台每一小時皆會對河川水質進行檢測，當數據檢測完成後會藉由無線通訊技術上傳至資料庫。
本論文改善了兩個問題，第一，以往河川數據檢測皆是由人力採樣，再帶回實驗室進行水質數值分析，第二，以往河川數據檢測的週期性過長以及水質分析所需的時間過長，無法及時反應當前水質狀況。本論文提供了一個能即時自動檢測水質數據，並自動回傳數值的系統，讓政府部門及民眾能得到最即時的河川水質狀態。

In recent years, the rapid industrial development has led to increasingly serious water pollution in rivers, and people's awareness of environmental conservation has gradually increased. Therefore, relevant government departments begin to sample the water quality of the river and send it to the laboratory for analysis, but this method consumes manpower and time cost. This paper designs a automatic measurement floating platform to automatically measurement and upload the water quality of the river, so that the public can check the water quality of the river.
In this paper, the NI myRIO embedded system is used as the core controller of the floating platform, and a computer is used as the server. The automatic measurement floating platform will test the water quality of the river every hour. After the data measurement is completed, it will be uploaded to the database through wireless communication technology.
This paper improves two problems. First, in the past, river data testing was done by human sampling, and then brought back to the laboratory for numerical analysis of water quality. Second, in the past, the periodicity of river data measurement and the time required for water quality analysis were too long to reflect the current water quality status in time. This paper provides a system that can automatically measurement water quality data in real time and automatically return the value, so that government departments and the public can get real time water quality status of river.

目錄
中文摘要 i
Abstract ii
誌謝 iii
目錄 iv
圖目錄 vii
表目錄 ix
第一章 緒論 1
1.1研究背景 1
1.2研究動機 3
1.3研究目的 4
1.4研究方法 5
1.5論文架構 5
第二章 NI myRIO嵌入式系統 7
2.1NI myRIO簡介與特性 7
2.2 NI LabVIEW圖控式程式介紹 10
第三章 系統架構 13
3.1 自動量測浮台-硬體架構 14
3.2 自動量測浮台-電源供應 15
3.3 自動量測浮台-固定方式 17
3.4 自動量測浮台-數據檢測方式 19
3.4.1 檢測水溫 20
3.4.2 檢測pH值 21
3.4.3 檢測溶氧值 23
3.4.4 檢測濁度 25
3.4.5 檢測水中總溶解固體 26
3.4.6 檢測氧化還原電位 27
3.4.7 檢測導電度 28
3.4.8 檢測PM2.5及PM10 29
3.4.9 感測器控制板 31
3.5 自動量測浮台-資料傳輸方式 34
第四章 水質數據檢測及顯示 39
4.1 自動量測浮台數據檢測流程 39
4.2 伺服器 41
4.2.1 XAMPP介紹 41
4.2.2 網頁伺服器 42
4.2.3數據資料庫 43
4.3 使用者介面 44
第五章 高雄市後勁溪水質檢測驗證 46
5.1 自動量測浮台實體 46
5.2 實際測試 48
第六章 結論與未來展望 50
6.1 結論 50
6.2 未來展望 52
參考文獻 53
自傳 58

[1]高雄市政府環境保護局環境檢測科。監測計畫。檢自https://lab.ksepb.kcg.gov.tw/kaqm/tw/b0403a.aspx (民111年4月7日)。
[2]彭瑞祥 (民102年12月9日)。日月光廠偷排廢水至後勁溪 環保局罰60萬勒令停工。環境資訊中心。檢自 https://e-info.org.tw/node/95607 (民111年5月20日)。
[3]陳文嬋 (民108年12月14日)。後勁溪上游遭污染變色高市府查獲印刷、養雞廠2家違法排放。自由時報。檢自 https://news.ltn.com.tw/news/life/breakingnews/3011513 (民111年5月20日)。
[4]陳文嬋 (民109年12月14日)。抓到了！高市筆秀橋大排驚泛油污 環保局查獲雞肉加工廠偷排。自由時報。檢自 https://news.ltn.com.tw/news/life/breakingnews/3128398 (民111年5月20日)。
[5]Engineer Ambitiously (Feb 4, 2020). NI. NI myRIO Hardware at a Glance. Retrieved from https://www.ni.com/en-us/support/documentation/supplemental/13/ni-myrio-hardware-at-a-glance.html (Mar 4, 2022)
[6]National Instruments(2018). NI Academic RIO Device architecture overview. Retrieved from https://learn-cf.ni.com/teach/riodevguide/guide/myrio_architecture-overview.html (Mar 17,2022).
[7]Ministry of Transportation and Communications (Feb. 10 ,2022). MONTHLY STATISTICS OF TRANSPORTATION AND COMMUNICATIONS REPUBLIC OF CHINA. Retrieved from https://www.motc.gov.tw/uploaddowndoc?file=mebook/202202101155580.pdf&filedisplay=11012book.pdf&flag=doc (Mar. 7, 2022).
[8]F. Predan et al., "Wafer-bonded GaInP/GaAs/GaInAs//GaSb four-junction solar cells with 43.8% efficiency under concentration," 2020 47th IEEE Photovoltaic Specialists Conference (PVSC). 2020, pp. 0250-0252, doi: 10.1109/PVSC45281.2020.9300633.
[9]劉彥忠。淺談浮動碼頭。檢自http://www.hydraulic.org.tw/new/upfile/post/22-劉彥忠_淺談浮動碼頭.pdf (民111年3月10日)
[10]Environmental Protection Administration, Executive Yuan Environmental Water Quality Information (May 28 2020). Temperature. Retrieved from https://wq.epa.gov.tw/EWQP/en/Encyclopedia/NounDefinition/Pedia_47.aspx (Mar 15, 2022)
[11]Environmental Protection Administration, Executive Yuan Environmental Water Quality Information (May 28, 2020). Hydrogen Ion Concentration Index (pH). Retrieved from https://wq.epa.gov.tw/EWQP/en/Encyclopedia/NounDefinition/Pedia_47.aspx (Mar 15, 2022)
[12]Yunzhang Rao, Guoliang Chen, Hong Wu and Shuitai Xu, "Study on variation rules between heavy metal ions' concentration and pH value in acid mine drainage," 2011 Second International Conference on Mechanic Automation and Control Engineering, 2011, pp. 2644-2647, doi: 10.1109/MACE.2011.5987527.
[13]R. M. Kingsta, A. S. Saumi and P. Saranya, "Design and Construction of Arduino Based pH Control System for Household Waste Water Reuse," 2019 3rd International Conference on Trends in Electronics and Informatics (ICOEI). 2019, pp. 1037-1041, doi: 10.1109/ICOEI.2019.8862752.
[14]Environmental Protection Administration, Executive Yuan Environmental Water Quality Information (Jan 20, 2020). Dissolved oxygen, DO. Retrieved from https://wq.epa.gov.tw/EWQP/en/Encyclopedia/NounDefinition/Pedia_02.aspx (Apr 13, 2022).
[15]周榮華(民91年2月)，溶氧Dissolved Oxygen(DO)。檢自 https://terms.naer.edu.tw/detail/1319599/ (民111年4月13日)
[16]Environmental Protection Administration, Executive Yuan Environmental Water Quality Information (May 28, 2020). River pollution Index. Retrieved from https://wq.epa.gov.tw/EWQP/en/Encyclopedia/NounDefinition/Pedia_37.aspx (Apr 27, 2022)
[17]Environmental Protection Administration, Executive Yuan Environmental Water Quality Information (May 28, 2020). Turbidity. Retrieved from https://wq.epa.gov.tw/EWQP/en/Encyclopedia/NounDefinition/Pedia_21.aspx (Apr 13, 2022)
[18]Environmental Protection Administration, Executive Yuan Environmental Water Quality Information (May 28, 2020). Total dissolved solids (TDS). Retrieved from https://wq.epa.gov.tw/EWQP/en/Encyclopedia/NounDefinition/Pedia_07.aspx (Apr 13, 2022)
[19]Gao Meijuan, Zhang Fan and Tian Jingwen, "Oxidation Reduction Potential network sensor based on Kalman filtering," 2008 27th Chinese Control Conference, 2008, pp. 673-676, doi: 10.1109/CHICC.2008.4605265.
[20]DFRobot, Analog_ORP_Meter_SKU_SEN0165_-DFRobot. Retrieved from https://wq.epa.gov.tw/EWQP/en/Encyclopedia/NounDefinition/Pedia_48.aspx (Apr 19, 2022)
[21]Environmental Protection Administration, Executive Yuan Environmental Water Quality Information (May 28, 2020).Electrical conductivity (EC). Retrieved from https://wq.epa.gov.tw/EWQP/en/Encyclopedia/NounDefinition/Pedia_48.aspx (Apr 14, 2022)
[22]行政院農業委員會主管法規共用系統(民92年11月07日)，公告灌溉用水水質標準。檢自 https://law.coa.gov.tw/glrsnewsout/LawContent.aspx?id=GL000066 (民111年4月26日)
[23]WHO | World Health Organization (Sep 22, 2021). Ambient (outdoor) air pollution. Retrieved from https://www.who.int/news-room/fact-sheets/detail/ambient-(outdoor)-air-quality-and-health (Mar 14,2022)
[24]行政院環境保護署(109)。中華民國空氣品質監測報告108年年報。臺北市：行政院環境保護署。
[25]Magdalena Nohrborg for 3GPP. LTE. Retrieved from https://www.3gpp.org/technologies/keywords-acronyms/98-lte (Mar 18, 2022)
[26]Toon Norp. 5G service requirements. Retrieved from https://www.3gpp.org/news-events/1831-sa1_5g (Feb 27, 2017)
[27]Szydelko, Michal & Dryjanski, Marcin. (2016). 3GPP Spectrum Access Evolution Towards 5G. EAI Endorsed Transactions on Cognitive Communications. 3. 10.4108/eai.23-2-2017.152184.
[28]中華民國國家通訊傳播委員會 (民108年11月21日)。第19屆世界通訊大會（WRC-19）確立5G新頻段。檢自https://intlfocus.ncc.gov.tw/xcdoc/cont?xsmsid=0J210565885111070723&sid=0K073358569725494200 (民111年3月21日)
[29]International Telecommunication Union. Radio Regulations 2020. 2019 World Radiocommunication Conference.
[30]中華電信(民111年4月1日)，網路涵蓋率查詢。檢自 https://coverage.cht.com.tw/coverage/tw.html (民111年4月13日)
[31]Syahidah Nurani Zulkifli, Herlina Abdul Rahima, Woei-JyeLaub, "Detection of contaminants in water supply: A review on state-of-the-art monitoring technologies and their applications". Sensors and Actuators B: Chemical, 255(3). doi:10.1016/j.snb.2017.09.078
[32]XAMPP (2022). About the XAMPP project. Retrieved from https://www.apachefriends.org/ (Mar 4, 2022).
[33]Apache,Platform Specific Notes. Retrieved from https://httpd.apache.org/docs/2.4/platform/index.html.en (Apr 13, 2022).
[34]phpMyAdmin.Bringing MySQL to the web.Retrieved from https://www.phpmyadmin.net (Mar 11,2022).
[35]Tong Duan and Venkata Dinavahi, "Starlink Space Network-Enhanced Cyber–Physical Power System," in IEEE Transactions on Smart Grid, vol. 12, no. 4, pp. 3673-3675, July 2021, doi: 10.1109/TSG.2021.3068046.