Bona i-Google Earth ixhumanisa ku-Excel - futhi uyiguqulele ku-UTM

Nginayo idatha ku-Google Earth, futhi ngifuna ukubona ngeso lengqondo izixhumanisi ku-Excel. Njengoba ungabona, kuyisakhiwo esinesigcawu se-7 nendlu enezine ezine.

Londoloza idatha ye-Google Earth.

Ukulanda le datha, chofoza kwesokudla ku- “Izindawo zami”, bese ukhetha u- “Gcina indawo njenge…”

Ukuze ube ifayela elinemigqa, amaphuzu kanye nezakhiwo engiziguqulele kuma-icons, ifayela ngeke ligcinwe njenge-kml elula kodwa njenge-Kmz.

Iyini ifayela le-KMZ?

I-kmz iqoqo lamafayela we-compressed kml. Ngakho-ke, indlela elula yokuyivula iyindlela esingazenza ngayo ngefayela le-.zip noma .rar.

Njengoba kuboniswa kusifanekiso esilandelayo, kungenzeka ukuthi asiboni isandiso sefayela. Kulokhu, kufanele senze okulandelayo:

I-1. Ikhetho lokubona ukwandiswa kwamafayela kuvuliwe, kusukela kuthebhu ethi "Buka" yesiphequluli sefayela.

I-2 Isandiso kusuka ku-.kmz kuya ku-.zip siyashintshwa. Ukuze wenze lokhu, ukuchofoza okukhambile kwenziwa kwifayili, futhi idatha elandela iphuzu ishintshiwe. Samukela umyalezo ozovela, obonisa ukuthi sishintsha isandiso sefayela nokuthi singasetshenziswa.

I-3 Ifayela libolile. Inkinobho yegundane kwesokudla, futhi "Khipha ku ..." kukhethiwe. Kithina, ifayela libizwa nge- «Geofumadas Classroom Ground».

Njengoba singabona, ifolda yadalwa, futhi ngaphakathi ngaphakathi ungabona ifayela le-kml ebizwa ngokuthi "doc.kml" kanye nefolda ebizwa ngokuthi "amafayela" aqukethe idatha ehambisanayo, ngezithombe ezijwayelekile.

Vula i-KML kusuka ku-Excel

Iyini ifayela le-Kml?

I-Kml ifomethi ephakanyiswa yi-Google Earth, eyayingaphambi kwenkampani ye-Keyhole, ngakho-ke igama (uLimi Lwe-Keyhole Markup), ngakho-ke, lifayela ku-XML isakhiwo (Ulimi lwe-EXtensible Markup). Ngakho, ukuba ifayela le-XML kufanele libukwe kusukela ku-Excel:

I-1 Sishintshe isandiso sayo kusuka ku- .kml kuya ku-.xml.

I-2 Sivula ifayela kusuka ku-Excel. Esimweni sami, ngisebenzisa i-Excel 2015, ngithola umlayezo uma ngifuna ukukubona njengethebula le-XML, njengencwadi yokufunda kuphela noma uma ngifuna ukusebenzisa iphaneli yomthombo we-XML. Ngakhetha ukhetho lokuqala.

I-3 Sifuna uhlu lwezixhumanisi zendawo.

I-4 Sizikopisha kufayela elisha.

Futhi voila, manje sinefayela lezixhumanisi ze-Google Earth, kuthebula le-Excel. Kusukela ku-29 irowu, ku-ikholomu X avela amagama ama-vertices, nezixhumanisi i-latitude / longitude ku-ikholomu AH. Ngizifihlile amanye amakholomu, ukuze ubone ukuthi emigqeni ye-40 ne-41 ungabona ama-polygons amabili engiwadonsayo, nge-string yabo yokuxhumanisa.

Ngakho, ngokukopisha amakholomu we-X nekholomu ye-AH, unezinhloso nezixhumanisi zamaphoyinti wakho we-Google Earth.

Sithemba ukuthi lokhu okungenhla kukusize ukuthi uqonde ukuthi ungagcina kanjani idatha ye-Google Earth efayeleni le-kmz, nokuqonda ukuthi ungadlulisa kanjani ifayela le-kmz ukuya ku-kml, ekugcineni ukuthi ubuka kanjani i-Google Earth isebenzisa i-Excel.


Unentshisekelo kwenye into?


Guqula idatha kusuka ku-Google Earth kuya ku-UTM.

Manje, uma ufuna ukuguqula lezo zixhumanisi zomhlaba ukuthi unesimo samadijithi wedesimali we-latitude nobude kuya kufomathi yokuqondisa okuklanyelwe i-UTM, ungasebenzisa ithemplate ekhona yalokho.

Yiziphi izixhumanisi ze-UTM?

I-UTM (i-Universal Traverso Mercator) iyisistimu ehlukanisa umhlaba emhlabeni wezizinda ze-60 ze-6 degree ngayinye, ishintshwe ngendlela yemathemathi ukuze ifane negridi ehlolwe ku-ellipsoid; njengaye ichazwa kulesi sihloko. futhi kule vidiyo.

Njengoba ungabona, kukhona amakhophi izixhumanisi eziboniswe ngenhla. Ngenxa yalokho, uzoba nezixhumanisi ze-X, Y kanye ne-UTM Zone emakwe kukholomu eluhlaza, okuleso sibonelo kuvela ku-16 Zone.

Thumela idatha kusuka ku-Google Earth ku-AutoCAD.

Ukuze ukwazi ukuthumela idatha ku-AutoCAD, kufanele usebenze kuphela umyalo wamaphuzu amaningi. Lokhu kusethebhu ethi "Dweba", njengoba kuboniswe kumdwebo ngakwesokudla.

Uma ususebenze umyalelo we-Multiple Points, kopisha bese unamathisela idatha kusuka kuthempulethi ye-Excel, kusukela kukholomu yokugcina, kuya kumgca we-AutoCAD umyalo.

Ngalokhu, izixhumanisi zakho zihanjisiwe. Ukuzibona ngeso lengqondo, Zoom / Konke kungenziwa.

Ungathola ithempulethi nge Paypal noma Credit Card. Uma wenza inkokhelo, uthola i-imeyili ngesixhumanisi sokulanda. Ukuthola ithempulethi kukunika ilungelo lokusekela nge-imeyili, uma unenkinga ngesifanekiso.


Funda ukuthi ungenza kanjani lezi ezinye izifanekiso ku Inkambo yokukopela ye-Excel-CAD-GIS.


Izimpendulo ze-5 "Buka i-Google Earth iqondisa ku-Excel - futhi uyiguqulele ku-UTM"

  1. Kuyinto amahloni, okuningi noma i-Google Earth ayivumeli ukudalwa kwama-polygoni nezici ze-precisão aceitáveis. Ukuqhafaza uhlelo lokusebenza lwe-GIS bese ulithumela ku-Google Earth.

    I-Saudações

  2. Oi geofumadas !!

    Ngingafaka kanjani i-polygon hhayi i-google emhlabeni?

    Kubalulekile ukubeka amaphuzu okuqala bese uwafaka noma i-polygon ngendlela evamile ukuze uthumele indawo. Kodwa kwenzekani uma i-quando faço noma i-Zoom inikeza indawo yomsebenzi, noma i-ponto ne-sobrepõe ao noma i-polygon, ukukhetha ibanga elide lephutha phakathi kwe-polygon noma ponto.
    Noma bheka, ngidinga ukungeza i-polygon hhayi i-google umhlaba (Kungenzeka ukuthi iphuma phambili, iphikisana)

    Ngithemba ukuthi ngiyashintsha futhi ngiyongena emito obrigada!

  3. hi geofumadas, amathiphu amahle kakhulu ekusebenziseni i-google komhlaba, ingisiza kakhulu emsebenzini wami.
    ukwesekwa, lapho ngingakwazi ukulanda IFOMU YOKUPHUMA ULIMI LWAMAGESHINI E-GEOGRAPHICAL (X, Y, Z) KU-UTM, ngidinga.
    Ngilindele ukuphawula kwakho
    imikhonzo
    fabio

Shiya impendulo

Ikheli lakho le ngeke ishicilelwe.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda ukuthi idatha yakho yokuphawula isetshenziswa kanjani.