湖濱散記部落格的樹心幽徑[login][主頁]
502:20190926為安卓手機裝google Earth來觀看KML航跡檔的衛星空照地景

一、在手機的google商店處輸入「Google Earth」,找到Google EarthAPP(本軟体免費),請下載安裝之。

二、用google Earth開啟如下KML來觀看:

2019071718d6d7.kml下載 (182 KB) | created 21 九月, 2019

20190717d6.kml下載 (99 KB) | created 21 九月, 2019

20190718d7.kml下載 (87 KB) | created 21 九月, 2019

三、20190718d7.kml顯示結果載圖如下:

alt

四、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>253C5</name>
<Point><coordinates>121.258945,24.455650</coordinates></Point>
</Placemark>
<Placemark><name>254地形</name>
<Point><coordinates>121.258902,24.457039</coordinates></Point>
</Placemark>
<Placemark><name>255大霸登山口</name>
<Point><coordinates>121.258719,24.457177</coordinates></Point>
</Placemark>
<Placemark><name>256小霸岔</name>
<Point><coordinates>121.256945,24.456892</coordinates></Point>
</Placemark>
<Placemark><name>258馬洋岔</name>
<Point><coordinates>121.257953,24.463483</coordinates></Point>
</Placemark>
<Placemark><name>259森林</name>
<Point><coordinates>121.260282,24.468092</coordinates></Point>
</Placemark>
<Placemark><name>261草原水池原木牌</name>
<Point><coordinates>121.265097,24.477990</coordinates></Point>
</Placemark>
<Placemark><name>262右有大水池</name>
<Point><coordinates>121.264924,24.478865</coordinates></Point>
</Placemark>
<Placemark><name>264馬洋池營地</name>
<Point><coordinates>121.266913,24.487369</coordinates></Point>
</Placemark>
<Placemark><name>265展望空地</name>
<Point><coordinates>121.269833,24.489752</coordinates></Point>
</Placemark>
<Placemark><name>266長倒木</name>
<Point><coordinates>121.272557,24.490615</coordinates></Point>
</Placemark>
<Placemark><name>268馬洋山比夏灣岔</name>
<Point><coordinates>121.276438,24.501276</coordinates></Point>
</Placemark>
<Placemark><name>269岔</name>
<Point><coordinates>121.275610,24.502112</coordinates></Point>
</Placemark>
<Placemark><name>270樹洞營地旁</name>
<Point><coordinates>121.274181,24.504664</coordinates></Point>
</Placemark>
<Placemark><name>271倒樹空地</name>
<Point><coordinates>121.272510,24.504943</coordinates></Point>
</Placemark>
<Placemark><name>272轉稜點</name>
<Point><coordinates>121.271025,24.505778</coordinates></Point>
</Placemark>
<Placemark><name>274松針營地</name>
<Point><coordinates>121.263637,24.505905</coordinates></Point>
</Placemark>
<Placemark><name>275神木1</name>
<Point><coordinates>121.264295,24.506593</coordinates></Point>
</Placemark>
<Placemark><name>276神木2</name>
<Point><coordinates>121.264002,24.506928</coordinates></Point>
</Placemark>
<Placemark><name>277神木3</name>
<Point><coordinates>121.263685,24.507415</coordinates></Point>
</Placemark>
<Placemark><name>278神木4</name>
<Point><coordinates>121.263390,24.507778</coordinates></Point>
</Placemark>
<Placemark><name>279溪上方路條</name>
<Point><coordinates>121.263409,24.508814</coordinates></Point>
</Placemark>
<Placemark><name>280抵活水溪溝</name>
<Point><coordinates>121.263590,24.509052</coordinates></Point>
</Placemark>
<Placemark><name>281過溪</name>
<Point><coordinates>121.261969,24.510217</coordinates></Point>
</Placemark>
<Placemark><name>282雙溪中稜</name>
<Point><coordinates>121.261907,24.510395</coordinates></Point>
</Placemark>
<Placemark><name>283大神木林</name>
<Point><coordinates>121.261725,24.515058</coordinates></Point>
</Placemark>
<Placemark><name>284鞍2260</name>
<Point><coordinates>121.262220,24.515846</coordinates></Point>
</Placemark>
<Placemark><name>285營地5p無</name>
<Point><coordinates>121.261723,24.516567</coordinates></Point>
</Placemark>
<Placemark><name>286C6</name>
<Point><coordinates>121.261912,24.516216</coordinates></Point>
</Placemark>
<Placemark><name>287C6</name>
<Point><coordinates>121.262017,24.516085</coordinates></Point>
</Placemark>
<Placemark><name>288溪畔獵營</name>
<Point><coordinates>121.264607,24.517036</coordinates></Point>
</Placemark>
<Placemark><name>289神木大獵屋</name>
<Point><coordinates>121.264782,24.517778</coordinates></Point>
</Placemark>
<Placemark><name>290過溪</name>
<Point><coordinates>121.265010,24.517803</coordinates></Point>
</Placemark>
<Placemark><name>291奚畔獵營</name>
<Point><coordinates>121.265435,24.519214</coordinates></Point>
</Placemark>
<Placemark><name>292小天下路條</name>
<Point><coordinates>121.265731,24.519766</coordinates></Point>
</Placemark>
<Placemark><name>293陡下</name>
<Point><coordinates>121.266528,24.520826</coordinates></Point>
</Placemark>
<Placemark><name>295右下有獵寮</name>
<Point><coordinates>121.267734,24.521986</coordinates></Point>
</Placemark>
<Placemark><name>296溪底</name>
<Point><coordinates>121.267770,24.522191</coordinates></Point>
</Placemark>
<Placemark><name>297過溪</name>
<Point><coordinates>121.267764,24.522368</coordinates></Point>
</Placemark>
<Placemark><name>298昔過溪</name>
<Point><coordinates>121.267271,24.522331</coordinates></Point>
</Placemark>
<Placemark><name>299登西南稜大崩</name>
<Point><coordinates>121.267790,24.523127</coordinates></Point>
</Placemark>
<Placemark><name>300大崩上</name>
<Point><coordinates>121.267993,24.523284</coordinates></Point>
</Placemark>
<Placemark><name>301橫渡危</name>
<Point><coordinates>121.268281,24.523940</coordinates></Point>
</Placemark>
<Placemark><name>302乾溝旁陡上</name>
<Point><coordinates>121.268262,24.524307</coordinates></Point>
</Placemark>
<Placemark><name>303簡易木橋</name>
<Point><coordinates>121.268279,24.524946</coordinates></Point>
</Placemark>
<Placemark><name>304流泉</name>
<Point><coordinates>121.268142,24.525773</coordinates></Point>
</Placemark>
<Placemark><name>305獵寮</name>
<Point><coordinates>121.268234,24.526814</coordinates></Point>
</Placemark>
<Placemark><name>306水源</name>
<Point><coordinates>121.268767,24.527376</coordinates></Point>
</Placemark>
<Placemark><name>308_2494峰岔</name>
<Point><coordinates>121.266892,24.528752</coordinates></Point>
</Placemark>
<Placemark><name>310巨木</name>
<Point><coordinates>121.268305,24.530721</coordinates></Point>
</Placemark>
<Placemark><name>311乾溝</name>
<Point><coordinates>121.268303,24.531385</coordinates></Point>
</Placemark>
<Placemark><name>312雙溪口上空地</name>
<Point><coordinates>121.268213,24.534051</coordinates></Point>
</Placemark>
<Placemark><name>313雙溪口</name>
<Point><coordinates>121.267823,24.533700</coordinates></Point>
</Placemark>
<Placemark><name>314營地</name>
<Point><coordinates>121.264734,24.535011</coordinates></Point>
</Placemark>
<Placemark><name>315獨木橋後獵營</name>
<Point><coordinates>121.264313,24.535006</coordinates></Point>
</Placemark>
<Placemark><name>317上坡長稜</name>
<Point><coordinates>121.263518,24.537178</coordinates></Point>
</Placemark>
<Placemark><name>318腰繞</name>
<Point><coordinates>121.263649,24.538916</coordinates></Point>
</Placemark>
<Placemark><name>322溪水</name>
<Point><coordinates>121.263341,24.542274</coordinates></Point>
</Placemark>
<Placemark><name>327神奇活水池</name>
<Point><coordinates>121.267101,24.546789</coordinates></Point>
</Placemark>
<Placemark><name>328基那吉岔</name>
<Point><coordinates>121.267623,24.547594</coordinates></Point>
</Placemark>
<Placemark><name>333</name>
<Point><coordinates>121.267645,24.547636</coordinates></Point>
</Placemark>
<Placemark><name>335山頭</name>
<Point><coordinates>121.261083,24.546047</coordinates></Point>
</Placemark>
<Placemark><name>338空地</name>
<Point><coordinates>121.256770,24.545511</coordinates></Point>
</Placemark>
<Placemark><name>339轉北</name>
<Point><coordinates>121.255016,24.545506</coordinates></Point>
</Placemark>
<Placemark><name>340布奴加里前營地</name>
<Point><coordinates>121.254152,24.546974</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>(null)</name>
<styleUrl>#lineStyle</styleUrl>
<LineString> <tessellate>1</tessellate>
<coordinates>
121.2589103,24.4556401
121.2589485,24.4556413
121.2589479,24.4556410
121.2589477,24.4556484
121.2589448,24.4556521
121.2589489,24.4556528
121.2589463,24.4556514
121.2589467,24.4556483
121.2589399,24.4556457
121.2589374,24.4556418
121.2589521,24.4556315
121.2589466,24.4556343
121.2589399,24.4556470
121.2589445,24.4556412
121.2589436,24.4556494
121.2589434,24.4556518
121.2589410,24.4556511
121.2589462,24.4556579
121.2589443,24.4556602
121.2589493,24.4556629
121.2589478,24.4556588
121.2589405,24.4556605
121.2589386,24.4556555
121.2589400,24.4556522
121.2589392,24.4556462
121.2589467,24.4556510
121.2589526,24.4556572
121.2589451,24.4556643
121.2589450,24.4556666
121.2589531,24.4556769
121.2589491,24.4556447
121.2589539,24.4556470
121.2589608,24.4556491
121.2589642,24.4556457
121.2589467,24.4556173
121.2589502,24.4556338
121.2589291,24.4556421
121.2589344,24.4556421
121.2589490,24.4556361
121.2589406,24.4556243
121.2589438,24.4556233
121.2589392,24.4556356
121.2589426,24.4556401
121.2589305,24.4556399
121.2589305,24.4556393
121.2589377,24.4556412
121.2589409,24.4556259
121.2589432,24.4556264
121.2589448,24.4556268
121.2589546,24.4556246
121.2589705,24.4556183
121.2589574,24.4556483
121.2589248,24.4557474
121.2588990,24.4558520
121.2588926,24.4559013
121.2588888,24.4559201
121.2588577,24.4559611
121.2588396,24.4559858
121.2588223,24.4560065
121.2588256,24.4560292
121.2587910,24.4560310
121.2587772,24.4560376
121.2587769,24.4560443
121.2587964,24.4560740
121.2588039,24.4560845
121.2587989,24.4561043
121.2587954,24.4561080
121.2587944,24.4561181
121.2587948,24.4561213
121.2588089,24.4561377
121.2588077,24.4561531
121.2588317,24.4561620
121.2588395,24.4561567
121.2588430,24.4561600
121.

:

,24.5469803
121.2541473,24.5469817
</coordinates>
</LineString>
</Placemark> </Folder> </Folder>
</Document> </kml>


 

 


select id,article_id,topic,text from lt_articles_text where article_id =502; ok. update lt_articles set num_reads=num_reads +1 where id=502; ok.