Eʻike i nā pūnaewele Google Earth ma Excel - a hoʻololi iā lākou i ka UTM

Loaʻa iaʻu nāʻikepili ma ka Google Earth, a makemake wau e nānā i nā kikowaena o Excel. E like me kāu eʻike ai, he hana me nā poʻomanaʻo 7 a me kahi hale meʻehā papa.

E mālama i kaʻikepili Google.

E hoʻoiho i kēia ikepili, kaomi pololei ma ka "ʻOkuʻu wahi", a koho i ka "Mālama ma kahi o ..."

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?

A kmz he papa helu kml piha. No laila,ʻo kaʻoi aku o ka maʻalahi loa e wehe iā ia, e like me kā mākou e hana ai me kahi .zip file.

E like me ia e hōʻikeʻia nei i ka kiʻi ma hope nei, hiki paha iā mākouʻaʻoleʻike i ke kauʻana o ka lālā. No kēia, pono mākou e hana i kēia mau hana:

1. Aia ke koho eʻike i ka hoʻopauʻana o nā faila, mai ka "View"ʻaoʻao o ka pūnaewele pūnaewele.

2 Hoʻopiliʻia ka palena mai .kmz a .zip. No ka hanaʻana i kēia, ua hanaʻia kahi pāomi mālie ma ka pūnaewele, a ua hoʻololiʻia kaʻikepili i hala ma hope o ka helu. Eʻae mākou i kaʻelele e hōʻikeʻia, e hōʻike ana e hoʻololi nei mākou i ka hoʻonuiʻana o kaʻaeʻana a hikiʻole ke lilo.

3 Hoʻopaʻa ʻia ka faila. Ua koho ʻia ka pākeke hema, a me ke "Extract in ..." i koho ʻia. I ka hihia, ua kapa ʻia ka faila «Geofumadas Classroom Ground».

E like me ko mākouʻikeʻana, ua hoʻokumuʻia kahi waihona, aʻo ka pololei i loko oʻoukou eʻike i ka kōnae kml i kapaʻia "doc.kml" a me kahi papa i kapaʻiaʻo "nā kikowaena" i loaʻa nāʻikepili i pili, i nā kiʻi nui.

E wehe i ka KML mai Excel

He aha ke KML file?

He kulekeleʻo Kml e ka Google Earth, ma mua o ka huiʻo Keyhole, no laila, ka inoa (Keyhole Markup Language), no laila, he faila i ka hanana XML (eXtensible Markup Language). No laila,ʻo ia he kōnae XML e hiki ke nānāʻ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 au i ka Excel 2015, loaʻa iaʻu kahiʻelele inā makemake wau eʻike ia he papa XML, he heluhelu heluhelu wale nō ināʻaʻole wau e hoʻohana i ka pūnaehana waihona XML. Koho wau i ka 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 ua loaʻa iā mākou ka pūnaewele o Google Earth, ma ka papa Excel. Mai ka laina 29, ma ka column X ka inoa o nā puka, a me ka latitude / longitude kaomi o ka column AH. Ua hūnā wau i kekahi mau pou, no laila eʻikeʻoe i loko o nā lālani 40 a me 41 hiki iāʻoe keʻike i nā polygonsʻelua aʻu i kahakaha ai, me ko lākou string coordinate.

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, aia nā kope i nā kuhikuhi i hōʻikeʻia ma luna nei. A laila, loaʻa iāʻoe nā kikowaena X, Y, a me ka Zone UTM paha i kahakahaʻia ma ka kolamu'ōmaʻomaʻo, i hōʻikeʻia ma kēlā hiʻohiʻona i ka 16 Zone.

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

I hiki iāʻoe ke hoʻouna i nāʻikepili i AutoCAD, ponoʻoe e hoʻoikaika i ke kauoha o nā helu he nui. Aia kēia ma ka pākuhi "Draw", e like me ka mea i hōʻikeʻia ma ke 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 kākauʻia kāu mau koina. No kaʻikeʻana iā lākou, Zoom / hiki ke hana i nā mea a pau.

Hiki iāʻoe ke hōʻoia i ke mamikomo me Paypal a Kāleka Kāleka paha. Ke hanaʻoe i ka uku, loaʻa iāʻoe ka leka uila me ka leka uila. Loaʻa iāʻoe ke kuleana e kākoʻo ma ka leka uila, inā loaʻa ka pilikia me ka hōʻailona.

5 Hōʻoia i "e nānā i nā pūnaewele Google Earth ma Excel - a hoʻohuli iā lākou i UTM"

  1. He mea hilahila,ʻoiʻole aʻaʻoleʻo Google Earth eʻae i ka hoʻokumuʻana i nā polygons me nāʻano aceitáveis. E hoʻohui i ka papahana GIS a me ka hoʻounaʻana iā Google Earth.

    hookipa

  2. Oi Oi!

    Pehea e hiki ai iaʻu ke hoʻohui i kekahi polygonʻaʻole google honua?

    He mea nui e kau i nā helu mua a hoʻokomo iā lākou a polygon paha ma keʻano maʻamau e hiki ai ke hoʻolālā i ka wahi. Akā ka mea e hana ai i ka manawa e hāʻawi ai a Zoom paha i kahi o ka hana, aiʻole pono não sobrepõe ao a polygon paha, e piʻi i kahi mamao nui o ka hemahema ma waena o ka polygon o ponto.
    Ou seja, makemake au e hoʻohui i kahi polygonʻaʻole google honua (hiki ke hana mai ka excel, melhor)

    Makemake wau e hoʻoponopono wau a me ka muito obrigada!

  3. hi geofumadas, kūlana maikaʻi loa no ka hoʻohanaʻana i ka honua google, hiki iaʻu ke hoʻoikaika i kaʻu hana.
    kahi kākoʻo, kahi e hiki ai iaʻu ke kiʻi i kahi palapala no ka loiloi houʻana i nā kaha o ke kapika (X, Y, Z) I UTM, makemake au.
    Kū wau no kāu'ōlelo
    Aloha
    helena

Haʻalele i ka manaʻo hoʻopuka

Kāu leka uila aae? E,ʻaʻole e paʻiʻia.

Ke hoʻohana nei kēia pūnaewele i ka Akismet e ho'ēmi i ka spam. E aʻo pehea e hanaʻia ai kāuʻikeʻikepili.