E ʻike i nā hoʻonohonoho Google Earth ma Excel - a hoʻololi iā lākou i UTM

He ʻikepili kaʻu ma Google Earth, a makemake wau e ʻike i nā kuhikuhina ma Excel. E like me kāu e ʻike ai, he ʻāina me 7 piko a me kahi hale me nā piko ʻehā.

E mālama i kaʻikepili Google.

No ka hoʻoiho ʻana i kēia ʻikepili, kaomi pololei ma "Koʻu mau wahi", a koho iā "Save place as..."

No ka laweʻana i kahi faila i loaʻa nā laina, nā kiko a me nā waiwai i hoʻololiʻia i nā kiʻi,ʻaʻole e mālamaʻia ka file ma kahi kml māmā akā ma kahi Kmz.

He aha ka kōnae KMZ?

ʻO kahi kmz kahi o nā faila kml i kaohi ʻia. No laila ʻo ke ala maʻalahi loa e wehe iā ia e like me mākou me kahi faila .zip a i ʻole .rar.

E like me ka hōʻike ʻana i kēia kiʻi, ʻaʻole paha mākou e ʻike i ka hoʻolōʻihi file. E hana ai i kēia, pono mākou e hana i kēia mau mea:

1. Ho'ā 'ia ke koho e 'ike i ka ho'onui 'ia o ka waihona, mai ka "View" tab o ka waihona explorer.

2. Hoʻololi i ka hoʻolōʻihi mai .kmz i .zip. No ka hana ʻana i kēia, hana ʻia kahi kaomi palupalu ma ka faile, a hoʻololi ʻia ka ʻikepili ma hope o ke kiko. ʻAe mākou i ka leka e hōʻike ʻia, e haʻi ana iā mākou ke hoʻololi nei mākou i ka faila faila a hiki iā ia ke hoʻohana ʻole.

3. ʻAʻole paʻa ka faila. Pākuʻi ʻiole ʻākau, a koho iā "Extract to...". I kā mākou hihia, kapa ʻia ka faila "Geofumed Classroom Land".

E like me kā mākou e ʻike ai, ua hana ʻia kahi waihona, a ma loko pono ʻoe e ʻike ai i ka faila kml i kapa ʻia ʻo "doc.kml" a me kahi waihona i kapa ʻia "faila" i loaʻa nā ʻikepili pili, nā kiʻi maʻamau.

E wehe i ka KML mai Excel

He aha ke KML file?

ʻO Kml kahi ʻano i hoʻolaha ʻia e Google Earth, ka mea ma mua o ka hui Keyhole, no laila ka inoa (Keyhole Markup ʻ )lelo), no laila, he faila me kahi hanana XML (ʻXlelo Markup eXtensible). No laila, he faila XML pono ia e ʻike ʻia mai Excel:

1 Ua hoʻololi mākou i kona hoʻonuiʻana mai .kml i .xml.

2. Wehe mākou i ka faila mai Excel. I koʻu hihia, ke hoʻohana nei wau iā Excel 2015, loaʻa iaʻu kahi leka inā makemake wau e ʻike iā ia ma ke ʻano he papa XML, ma ke ʻano he puke heluhelu wale nō a inā makemake wau e hoʻohana i ka paneli kumu XML. Koho wau i ke koho mua.

3 Huli mākou i ka papa inoa o nā kuhi'āina.

4 Hoʻopili mākou iā lākou i kahi faila hou.

A voila, i kēia manawa iā mākou ka faila hoʻonohonoho honua o Google Earth, i ka papa ʻaina Excel. E hoʻomaka ana mai ka lālani 29, ma ke kolamu X e ʻike ʻia nā inoa o nā piko, a me nā hoʻonohonoho latitude / longitude i ke kolamu AH. Ua hūnā wau i kekahi mau kolamu, i ʻike ʻoe i nā lālani 40 a me 41 hiki iā ʻoe ke ʻike i nā polygona ʻelua aʻu i huki ai, me kā lākou kaulahao kaulike.

No laila, me ke kopeʻana i nā koluma X a me ka column AH, aiaʻoe i nā mea a me nā hoʻohui o kāu mau māhele Google.

Manaʻo mākou ua kōkua ka mea i luna iāʻoe e hoʻomaopopo i keʻano o ka hoʻopakeleʻana i kaʻike Google Earth ma ka file melez, a me kaʻike i keʻano o ka heleʻana i kahi melenaekile i kml, i ka mea hope e nānā i nā kuhiʻana o Google Earth ma o Excel.

Loaʻa i kekahi mea'ē aʻe?

E hoʻohuli i nāʻikepili mai ka Honua Google i ka UTM.

I kēia manawa, inā makemakeʻoe e hoʻololi i kēlā mau palena'āina i loaʻa iāʻoe i keʻano o nā māmā decimal of latitude a longitude i kahi hōʻuluʻulu hoʻonohonoho hoʻonohonoho UTM, a laila hiki iāʻoe ke hoʻohana i keʻano hoʻopili no kēia.

He aha nā kuhina UTM?

ʻO UTM (Universal Traverner Mercator) kahi pūnaewele e hoʻokaʻawale ana i ka honua ma nā 60 o nā māhele 6 i kēlā me kēia, i hoʻololiʻia i kahi alamīmiki e like me ke kiʻi i hoʻolālāʻia i kahi ellipsoid; e like me Ua ho'ākākaʻia ma kēiaʻatikala. a i kēia wikiō.

E like me kāu e ʻike ai, ma laila ʻoe e kope ai i nā kuhi i hōʻike ʻia ma luna. A ʻo kahi hopena, e loaʻa iā ʻoe nā kikowaena X, Y a me ka Zone UTM i hōʻailona ʻia i ka kolamu ʻōmaʻomaʻo, a ma ia hiʻohiʻona e ʻike ʻia ma ka Zone 16.

Hoʻouna i nāʻikepili mai Google Earth a i ka AutoCAD.

No ka hoʻouna ʻana i ka ʻikepili i AutoCAD, pono ʻoe e hoʻāla i ke kauoha multipoint. Aia kēia ma ka pā "Draw", e like me ka mea i hōʻike ʻia ma ke kaha kiʻi ma ka ʻākau.

I ka manawa i hoʻonā aiʻoe i ka kauoha Multiple Points, kope a pasi i nāʻikepili mai ka mamal Excel, mai ke kalani hope loa, i ka laina kauohaʻo AutoCAD.

Me kēia, ua huki ʻia kāu mau kikowaena. E nānā iā lākou, hiki iā ʻoe ke hoʻokuʻi / All.

Hiki iāʻoe ke hōʻoia i ke mamikomo me Paypal a Kāleka Kāleka paha. Ke hana nei i ka uku, loaʻa iā ʻoe kahi leka uila me ka loulou hoʻoiho. ʻO ke kūʻai ʻana i ke anakuhi kūpono iā ʻoe e kākoʻo leka uila, inā he pilikia kāu me ke anakuhi.

E aʻo pehea e hana ai i kēia a me nā hana ʻē aʻe i ka ʻO Excel-CAD-GIS hoʻopunipuni papa.