Bona iGoogle Earth idibanisa kwi-Excel - kwaye uyiguqulele kwi-UTM

Ndineenkcukacha kwiGoogle Earth, kwaye ndifuna ukucinga ngolu hlobo kwi-Excel. Njengoko uyakubona, liyiqonga kunye neendlela ze-7 kunye neendlu ezine.

Gcina idatha yeGoogle Earth.

Ukukhuphela le datha, cofa kwindawo ethi "Iindawo zam", kwaye ukhethe u "Gcina indawo njenge ..."

Ukuze ube yifayili eneemigca, amanqaku kunye neepropati endiziguqule kwiimpawu, ifayile ayiyi kugcinwa njenge-kml elula kodwa njenge Kmz.

Iyintoni ifayile yeKMZ?

I-kmz isethi yeefayili ze-kml ezixinzelelweyo. Ngoko, indlela elula yokuyivula unjengoko siza kwenza ngefayile ye .zip okanye .rar.

Njengoko kuboniswe kumzobo olandelayo, kungenzeka ukuba asibonanga ukongezwa kwefayili. Ngenxa yoko, kufuneka senze oku kulandelayo:

1 Inketho yokujonga ukwandiswa kwefayile yenziwe, kwi "Jonga" ithebhu yebrawuza.

2 Ukongezwa ukusuka .kmz kuya kwi-.zip kuyatshintshwa. Ukwenza oku, iqhosha elincinci lenziwe kwifayile, kunye nedatha elandelayo emva kokuba iphuzu liguqulwe. Siyamkela umyalezo oya kuvela, obonisa ukuba sitshintsha isandiso sefayile kwaye singenakusetyenziswa.

3 Ifayile ibekiwe. Iqhosha leqhosha lasekunene, kwaye "Susa ..." kukhethiwe. Kwimeko yethu, le fayile ibizwa ngokuba yi "Geofumadas Classroom Ground».

Njengoko sikwazi ukubona, ifolda yadalwa, kwaye ngaphakathi ngaphakathi ungabona ifayile ye-kml ebizwa ngokuthi "doc.kml" kunye nefolda ebizwa ngokuthi "iifayile" eziqulethe idatha edibeneyo, kwimifanekiso eqhelekileyo.

Vula i-KML kwi-Excel

Iyiphi ifayile ye-Kml?

KML yifomati wenza ithandwa ngu Google Earth, leyo phambi inkampani nhla, kungoko igama (nhla lophawulo Language), ngoko ke, isakhiwo ifayile XML (andisiweyo Language). Ngoko, ukuba ifayile yeXML kufuneka ikwazi ukujongwa kwi-Excel:

1 Sitshintshe ukwandiswa kwayo ukusuka .kml ukuya ku- .xml.

2 Sivula ifayile evela kwi-Excel. Kwimeko yam, ndisebenzisa i-Excel 2015, ndifumana umyalezo ukuba ndifuna ukuyibona njengefayile ye-XML, njengencwadi yokufunda kuphela okanye ukuba ndifuna ukusebenzisa ipaneli yomthombo we-XML. Ndikhetha ukhetho lokuqala.

3 Sifuna uludwe lweendawo zokudibanisa.

4 Sibakopisha kwifayile entsha.

Kwaye, ngoku sinefayili ye-Google Earth, kwi-table ye-Excel. Ukususela kumqolo we29, kwikholam ye X kubonakala ngamagama eendlela, kwaye ulungelelanisa ulungelelaniso / ubude kwikholam AH. Ndifihlile ezinye iikholomu, ngoko unokubona ukuba kumigca ye40 kunye ne-41 ungabona iipolgoni ezimbini ndizenze, kunye nomtya wazo wokudibanisa.

Ngoko, ngokukopisha iikholomu ze-X kunye nekholeji ye-AH, unayo izinto kunye nokulungelelaniswa kweendawo zakho zeGoogle Earth.

Siyathemba ukuba oku ngasentla kukuncede ukuba uqonde indlela yokugcina idatha yeGoogle Earth kwifayili ye-kmz, kunye nokuqonda indlela yokudlula ifayile ye-kmz ukuya kwi-kml, ekugqibeleni indlela yokujonga i-Google Earth isebenzise i-Excel.


Unomdla kwenye into?


Guqula idatha kwiGoogle Earth ukuya ku-UTM.

Ngoku, ukuba ufuna ukuguqula ezo zilungelelaniso zeendawo zokuhlala ukuba unesimo samazinga aphezulu aphezulu kunye nobude ukuya kwifom ehambelana ne-UTM yokubambisana, uze usebenzise itemplate ekhoyo.

Ziziphi izilungiso ze-UTM?

I-UTM (i-Universal Traverso Mercator) yinkqubo ehlula ihlabathi kwiindawo ze-60 ze-6 degrees nganye, iguqulwe ngendlela yemathematika ukuba ifane negridi efakwe kwi-ellipsoid; njengaye ichazwe kweli nqaku. kwaye kule vidiyo.

Njengoko ubona, kukho iikopi eziboniswe ngasentla. Ngenxa yoko, uya kuba ne-X, Y kunye ne-UTM Indawo ephawulwe kwikholam eluhlaza, leyo kuloo mzekelo ivela kwi-16 Zone.

Thumela idatha esuka kwi-Google Earth kwi-AutoCAD.

Ukuze ukwazi ukuthumela idatha kwi-AutoCAD, kufuneka usebenze kuphela umyalelo wamaphuzu amaninzi. Oku kukukhonkco "Dweba", njengoko kuboniswe kumzobo ongakwesokudla.

Emva kokuba usebenze umyalelo we-Multiple Points, khuphela kwaye unamathisele idatha kwi-template ye-Excel, ukusuka kwikholam yokugqibela, kumgca we-AutoCAD umyalelo.

Ngaloo, iinqununu zakho zidibene. Ukuze uzibonise, Zoom / Zonke ziyakwenziwa.

Unokufumana itemplate PayPal okanye Credit Card. Xa wenza inkokhelo, ufumana i-imeyili enekhonkco lokukhuphela. Ukufumana itemplate kukunika ilungelo lokuxhasa nge-imeyile, xa unenkinga ngethemplate.


Funda ukuba ungayenza njani le kunye nezinye itemplate kwi Ikhosi yokukopela ye-Excel-CAD-GIS.


Iimpendulo ze-5 "Ukujonga i-Google Earth idibanisa kwi-Excel - kwaye uyiguqulele ku-UTM"

  1. Ihlazo, ngaphezulu okanye i-Google Earth ayivumeli ukudala iipolgoni kunye neempawu ze-precisão aceitáveis. I-melk fazê-lo em outro ye-GIS inkqubo kwaye uyithumele kwi-Google Earth.

    Saudações

  2. Oi geofumadas !!

    Ndingayongeza njani i-polygon engekho iGoogle emhlabeni?

    Kubalulekile ukubeka amanqaku okuqala kwaye uyongeze okanye ipoloni ngendlela eqhelekileyo ukuze udibanise indawo. Kodwa kwenzeka ntoni xa i-faando okanye i-Zoom inikeza indawo yomsebenzi, okanye i-ponto ne-sobrepõe ao okanye i-polygon, deixando umgama omkhulu wephutha phakathi kwe-polygon apho ponto.
    Okanye, kufuneka ndidibanise i-polygon engekho umhlaba we-google (unokusuka kwi-excel, i-melhor)

    Ndiyathemba ukuba ndiyatshintsha kwaye i-muito obrigada!

  3. hi geofumadas, iingcebiso ezifanelekileyo zokusebenzisa umhlaba weGoogle, inceda kum eninzi kum msebenzi wam.
    inkxaso, apho ndiyakwazi ukukhuphela iFOMU YOKUCHINTSHA ULWIMI LWABAHLANGISI BEJOGRAPHI (X, Y, Z) E-UTM, ndiyayifuna.
    Ndilindele amazwana akho
    mbuliso
    fabio

Shiya impendulo

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.