樹心幽徑

« 20200112設計第一個Android APP:自訂程式標題、文字物件與按鈕 | Main | 20200131用JavaScript將文字盒中的大地座標轉為 kml 或 gpx 航跡檔 »

20200124安裝魯地圖、MapSource、BaseCamp、GoogleEarth並用LIBRE-OFFICE 的CALC試算表及notepad記事本來製作伊加之蕃的kml及gpx航跡檔
2020/01/24,17:16

 

 

(1)在 魯地圖 Taiwan TOPO 下載Install_MOI_Taiwan_TOPO_camp.exe(186MB)

[mirror Rex] / [mirror KCWu] / [mirror Happyman]並安裝Taiwan TOPO 魯地圖

(2a)下載並安裝MapSource 6.16.3更新程式(要先裝有GARMIN 定位器附的MAPSOURCE)

(2b)執行MapSource並按CTRL+U選用(1)所裝的Taiwan TOPO 魯地圖

(3a)使用MapSource的航點標定功能自行標定一序列想要去的航點路線(例如下二圖,編輯功能表/偏好設定分別為WGS84及TWD67)並複製取得自訂航點的WGS84大地座標及TWD67大地座標。

alt

 

alt

 

(3b)用LIBRE-OFFICE 的CALC製作如下試算表,詳如20200127_0208eplus.ods下載 (51 KB)

如下NAME,twd67,wgs84三欄為取自(3a)所標定的航點資料。

如下x67欄D2的公式為=MID(B2,1,6) 

如下y67欄E2的公式為=MID(B2,8,7)

如下x97欄 F2的公式為= D2 + 807.8 + 0.00001549 * D2 + 0.000006521 *E2

如下y97欄 G2的公式為 =E2 - 248.6 + 0.00001549 * E2 + 0.000006521 *D2

如下lon欄h2的公式為=MID(C2,2,8)

如下lat欄i2的公式為=MID(C2,12,9)

如下gpxWPT欄J2的公式為 ="<wpt lon='" & I2 & "' lat='" & H2 & "'> <name>" & A2 & "</name>  </wpt>"

如下gpxTrkpt欄k2的公式為 ="<trkpt lat='" & H2 &"' lon='" & I2 & "'> <ele>1800</ele>  </trkpt>"

如下kmlWPT欄L2的公式為  ="<Placemark><name>" & A2 &"</name><Point><coordinates>" & I2 & "," & H2 & "</coordinates></Point></Placemark>"

如下kmlTrkpt欄M2的公式為 =I2 & "," & H2

 

(3c)20200127_0208eplus.ods 試算表的內容欄位如下:

A1

NAME

B1

TDW67

C1

WGS84

D1

X67

E1

Y67

F1

X97

G1

Y97

H1

lon

I1

lat

J1

gpxWPT

K1

gpxTrkpt

L1

kmlWPT

M1

KMLTrkpt

e00 244925 2560594 N23.14545 E120.95866 244925 2560594 245,753 2560387 23.14545 120.95866 <wpt lon='120.95866' lat='23.14545'> <name>e00</name> </wpt> <trkpt lat='23.14545' lon='120.95866'> <ele>1800</ele> </trkpt> <Placemark><name>e00</name><Point><coordinates>120.95866,23.14545</coordinates></Point></Placemark> 120.95866,23.14545
e01 244760 2560524 N23.14482 E120.95705 244760 2560524 245,588 2560317 23.14482 120.95705 <wpt lon='120.95705' lat='23.14482'> <name>e01</name> </wpt> <trkpt lat='23.14482' lon='120.95705'> <ele>1800</ele> </trkpt> <Placemark><name>e01</name><Point><coordinates>120.95705,23.14482</coordinates></Point></Placemark> 120.95705,23.14482
e02 244621 2560461 N23.14425 E120.95569 244621 2560461 245,449 2560254 23.14425 120.95569 <wpt lon='120.95569' lat='23.14425'> <name>e02</name> </wpt> <trkpt lat='23.14425' lon='120.95569'> <ele>1800</ele> </trkpt> <Placemark><name>e02</name><Point><coordinates>120.95569,23.14425</coordinates></Point></Placemark> 120.95569,23.14425
e03 244466 2560429 N23.14396 E120.95418 244466 2560429 245,294 2560222 23.14396 120.95418 <wpt lon='120.95418' lat='23.14396'> <name>e03</name> </wpt> <trkpt lat='23.14396' lon='120.95418'> <ele>1800</ele> </trkpt> <Placemark><name>e03</name><Point><coordinates>120.95418,23.14396</coordinates></Point></Placemark> 120.95418,23.14396
e04 244333 2560310 N23.14288 E120.95288 244333 2560310 245,161 2560103 23.14288 120.95288 <wpt lon='120.95288' lat='23.14288'> <name>e04</name> </wpt> <trkpt lat='23.14288' lon='120.95288'> <ele>1800</ele> </trkpt> <Placemark><name>e04</name><Point><coordinates>120.95288,23.14288</coordinates></Point></Placemark> 120.95288,23.14288
e05 244135 2560205 N23.14194 E120.95095 244135 2560205 244,963 2559998 23.14194 120.95095 <wpt lon='120.95095' lat='23.14194'> <name>e05</name> </wpt> <trkpt lat='23.14194' lon='120.95095'> <ele>1800</ele> </trkpt> <Placemark><name>e05</name><Point><coordinates>120.95095,23.14194</coordinates></Point></Placemark> 120.95095,23.14194
e06 244073 2560130 N23.14126 E120.95035 244073 2560130 244,901 2559923 23.14126 120.95035 <wpt lon='120.95035' lat='23.14126'> <name>e06</name> </wpt> <trkpt lat='23.14126' lon='120.95035'> <ele>1800</ele> </trkpt> <Placemark><name>e06</name><Point><coordinates>120.95035,23.14126</coordinates></Point></Placemark> 120.95035,23.14126
e07 244046 2560017 N23.14024 E120.95008 244046 2560017 244,874 2559810 23.14024 120.95008 <wpt lon='120.95008' lat='23.14024'> <name>e07</name> </wpt> <trkpt lat='23.14024' lon='120.95008'> <ele>1800</ele> </trkpt> <Placemark><name>e07</name><Point><coordinates>120.95008,23.14024</coordinates></Point></Placemark> 120.95008,23.14024
e08 243952 2559698 N23.13736 E120.94916 243952 2559698 244,780 2559491 23.13736 120.94916 <wpt lon='120.94916' lat='23.13736'> <name>e08</name> </wpt> <trkpt lat='23.13736' lon='120.94916'> <ele>1800</ele> </trkpt> <Placemark><name>e08</name><Point><coordinates>120.94916,23.13736</coordinates></Point></Placemark> 120.94916,23.13736

 

(3d)TWD67及TWD97的座標互換公式如下:


x67=x97-807.8-0.00001549*x97-0.000006521*y97;



y67=y97+248.6-0.00001549*y97-0.000006521*x97;








x67 y67 x97 y97
Qilis 275034.084586792 2582984.79386616 275863 2582778






x97 = x67 + 807.8 + 0.00001549 * x67 + 0.000006521 * y67;



y97 = y67 - 248.6 + 0.00001549 * y67 + 0.000006521 * x67;







Qilis 275034.0846 2582984.79387 275,863 2582778

 

(4a)將如下gpxWPT及gpxTrkpt二個欄位的內容貼入如下gpx檔的適當位置中即可製作出如下的gpx檔:20200121伊蕃wptTrk3.gpx下載 (17 KB)

gpxWPT gpxTrkpt
<wpt lon='120.95866' lat='23.14545'> <name>e00</name> </wpt> <trkpt lat='23.14545' lon='120.95866'> <ele>1800</ele> </trkpt>
<wpt lon='120.95705' lat='23.14482'> <name>e01</name> </wpt> <trkpt lat='23.14482' lon='120.95705'> <ele>1800</ele> </trkpt>
<wpt lon='120.95569' lat='23.14425'> <name>e02</name> </wpt> <trkpt lat='23.14425' lon='120.95569'> <ele>1800</ele> </trkpt>

 (4b)20200121伊蕃wptTrk3.gpx內容摘述如下:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<gpx xmlns="http://www.topografix.com/GPX/1/1" creator="MapSource 6.15.7" version="1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd">
<metadata>
    <link href="http://www.garmin.com">
      <text>Garmin International</text>
    </link>
    <time>2020-01-22T00:46:18Z</time>
    <bounds maxlat="23.1454495" maxlon="120.9586646" minlat="23.0881861" minlon="120.8897781"/>
</metadata>
<wpt lon='120.95866' lat='23.14545'> <name>e00</name>  </wpt>
<wpt lon='120.95705' lat='23.14482'> <name>e01</name>  </wpt>
<wpt lon='120.95569' lat='23.14425'> <name>e02</name>  </wpt>

:


<trk>
<name>20200127-0208gPLUS</name>
    <extensions>
      <gpxx:TrackExtension xmlns:gpxx="http://www.garmin.com/xmlschemas/GpxExtensions/v3">
        <gpxx:DisplayColor>Green</gpxx:DisplayColor>
      </gpxx:TrackExtension>
    </extensions>
<trkseg>
<trkpt lat='23.16128' lon='120.92484'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16198' lon='120.92435'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16214' lon='120.92345'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16232' lon='120.92215'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16270' lon='120.91963'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16334' lon='120.91780'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16377' lon='120.91587'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16478' lon='120.91550'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16685' lon='120.91489'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16797' lon='120.91485'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.16946' lon='120.91400'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.17115' lon='120.91195'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.17135' lon='120.91100'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.17210' lon='120.90991'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.17422' lon='120.90997'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.17521' lon='120.91003'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.17697' lon='120.90937'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.17906' lon='120.90887'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.18001' lon='120.90908'> <ele>1800</ele>  </trkpt>
<trkpt lat='23.18072' lon='120.90938'> <ele>1800</ele>  </trkpt>
</trkseg>
</trk>
</gpx>

(4c)用MapSource 開啟(4a)所製成的20200121伊蕃wptTrk3.gpx(下載)成功。

 

(5a)將如下kmlWPT及kmlTrkpt二個欄位的內容貼入如下kml檔的適當位置中即可製作如下的kml檔: 20200127-0208eplus5.kml 下載 (15 KB)

kmlWPT KMLTrkpt
<Placemark><name>e00</name><Point><coordinates>120.95866,23.14545</coordinates></Point></Placemark> 120.95866,23.14545
<Placemark><name>e01</name><Point><coordinates>120.95705,23.14482</coordinates></Point></Placemark> 120.95705,23.14482
<Placemark><name>e02</name><Point><coordinates>120.95569,23.14425</coordinates></Point></Placemark>

120.95569,23.14425

(5b)  20200127-0208eplus5.kml內容摘述如下:

<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2" xmlns:gx="http://www.google.com/kml/ext/2.2">
<Document>
<name>GPS device</name>
<Style id="lineStyle">
<LineStyle>
<color>FF0000EF</color>
<width>3</width>
</LineStyle>
</Style>
<Folder>
<name>Waypoints</name>
<Placemark><name>e00</name><Point><coordinates>120.95866,23.14545</coordinates></Point></Placemark>
<Placemark><name>e01</name><Point><coordinates>120.95705,23.14482</coordinates></Point></Placemark>
<Placemark><name>e02</name><Point><coordinates>120.95569,23.14425</coordinates></Point></Placemark>
<Placemark><name>e03</name><Point><coordinates>120.95418,23.14396</coordinates></Point></Placemark>

:

:

<Placemark><name>g20</name><Point><coordinates>120.90938,23.18072</coordinates></Point></Placemark>

</Folder>


<Folder> <name>Tracks</name> <Folder> <snippet/> <description> <![CDATA[<table> <tr><td><b>Distance</b> 8.0 mi </td></tr> </table>]]> </description>
<Placemark> <name>20200122EPLUS </name>
<styleUrl>#lineStyle</styleUrl>
<LineString> <tessellate>1</tessellate>
<coordinates>
120.95866,23.14545
120.95705,23.14482
120.95569,23.14425
:

 120.94141,23.12871
120.93987,23.12681
120.93898,23.12482
120.93842,23.12279
:

 120.88978,23.10096
</coordinates>
</LineString>

<LineString> <tessellate>2</tessellate>
<coordinates>
120.93904,23.11520
120.93846,23.11436
120.93707,23.11286
:

 120.94065,23.08841

</coordinates>
</LineString>

<LineString> <tessellate>3</tessellate>
<coordinates>
120.92484,23.16128
120.92435,23.16198
:

 120.90887,23.17906
120.90908,23.18001
120.90938,23.18072
</coordinates>
</LineString>
</Placemark> </Folder> </Folder>
</Document> </kml>

(6a)下載並安裝google earth

(6b)用google earth 開啟(4a)所製成的20200121伊蕃wptTrk3.gpx(下載)成功。

(6c)用google earth 開啟(5a)所製成的20200127-0208eplus5.kml( 下載)成功。

http://oldwww.kmvs.km.edu.tw/lf/gallery/70/20200122EPLUS.jpg

 

(7a)下載並安裝BaseCamp(安裝完成重開機才會生效)。

2019/10/30

BaseCamp 4.7.1版軟體更新下載

Download下載軟體(61.58 MB)

(7b)執行BaseCamp並於地圖功能表中選用(1)所裝的Taiwan TOPO 魯地圖

(7c)用BaseCamp 開啟(4a)所製成的20200121伊蕃wptTrk3.gpx(下載)成功。

REF :

迴響

 
Accessible and Valid XHTML 1.0 Strict and CSS Powered by LifeType