查詢結果分析
相關文獻
頁籤選單縮合
題 名 | 應用Excel VBA與數值高程模型於地形導覽=Apply Excel VBA and Digital Elevation Model to Terrain Guide |
---|---|
作 者 | 林志重; | 書刊名 | 建國科大社會人文期刊 |
卷 期 | 34:2 2015.07[民104.07] |
頁 次 | 頁101-108 |
分類號 | 992.2 |
關鍵詞 | 地形導覽; Excel巨集程式; 玉山群峰; 數值高程模型; Terrain guide; Excel VBA; Yushan Mountains; Digital elevation model; |
語 文 | 中文(Chinese) |
中文摘要 | 台灣地形起伏顯著,極富地形觀光資源,但是一般人觀光旅遊之際,面對群山美景,卻難以辨識地形起伏的山勢名稱。雖然地形的呈現與展示有多種方式,但多涉及複雜之軟體操作,與結果呈現的接受度。因此,本文嘗試以一般肉眼視覺的觀看方式,應用普及的試算表軟體VBA設計巨集程式,利用台灣最高的玉山群峰30公尺精度的數值高程模型,總計25,676筆為輸入地形資料,再設定相距約70公里的彰化建國科技大學為眺望觀賞點,計算該座標與各高程點的方位角與仰角,並以統計圖表的散佈圖型式,自動繪製地形起伏的清楚外觀。本文所繪製呈現的地形視覺,其真實性以及正確性,經與實際地形比對,有很令人滿意的結果,可作為地形觀光時導覽解說之用。 |
英文摘要 | The terrain of Taiwan is diverse and full of tourism resources. Ordinary people could not distinguish and explain the undulation of the mountains. There are many methods to display terrain, but most of them involve complicated software operation and the acceptance of the presented result. Therefore, based on the viewing method of naked eyes, we tried to use the popular spreadsheet software Excel VBA macro program to automatically draw the terrain of clear appearance. The implementing method is, use the Yushan mountains digital elevation model of 30 meters accuracy, total 25,676 terrain data, as input, set Chienkuo Technology University in Changhua, which is about 70 kilometers far away from Yushan mountains, as overlook viewing coordinate point, calculate the azimuth angles and altitude angles of each elevation point, and draw the scatter diagram. The reality and correctness of the terrain we drew and present in this paper have satisfactory results, compared with real terrain. It can be used on communication of terrain touring guide. |
本系統中英文摘要資訊取自各篇刊載內容。