Duba abubuwan haɗin Google Earth a cikin Excel - kuma canza su zuwa UTM

Ina da bayanai a cikin Google Earth, kuma ina son ganin abubuwan da ke cikin Excel. Kamar yadda kake gani, ƙasa ce mai gaɓoɓi 7 da gida mai gaɓoɓi huɗu.

Ajiye bayanan Google Earth.

Don sauke wannan bayanai, dama danna kan "My Places", kuma zaɓi «Ajiye wuri kamar yadda ...»

Domin zama fayil wanda yana da layi, maki da kaddarorin da na canza zuwa gumakan, ba za a ajiye fayil ɗin a matsayin mai sauƙi ba amma a matsayin Kmz.

Mene ne fayil KMZ?

A kmz saiti ne na fayilolin kml masu matsi. Don haka hanya mafi sauki don cirewa kamar yadda zamuyi tare da .zip ko .rar fayil.

Kamar yadda aka nuna a cikin mai zane mai zuwa, ƙila ba mu ga ƙarin fayil ba. Don yin wannan, dole ne muyi haka:

 

1. Zaɓin zaɓin don ganin an ƙara fayiloli daga cikin "Duba" shafin mai bincike.

2. Canja tsawo daga .kmz zuwa .zip. Don yin wannan, ana yin laushi mai laushi akan fayil ɗin, kuma bayanan da ke bayan ma'anar an canza su. Mun yarda da sakon da zai bayyana, wanda ke nuna mana cewa muna canza fayil din da kuma zai iya sanya shi mara amfani.

3. Fayil an cire shi. Madannin linzamin dama, sa'annan zaɓi "Cire cikin ...". A halinmu, ana kiran fayil ɗin «Geofumadas Classroom Terrain».

Kamar yadda muka gani, an halicci babban fayil, kuma a cikin ciki zaka iya ganin fayil din km da ake kira "doc.kml" da kuma babban fayil da ake kira "fayiloli" wanda ya ƙunshi bayanan haɗe, a cikin hotuna.

Bude KML daga Excel

Menene fayil din Kml?

Kml wani tsari ne wanda Google Earth ta yada, wanda yake a gaban kamfanin Keyhole, saboda haka sunan shi (Keyhole Markup Language), saboda haka, fayil ne mai tsarin XML (eXtensible Markup Language). Don haka, kasancewar fayil ɗin XML dole ne ya kasance ana iya gani daga Excel:

1 Mun canza da tsawo daga .kml zuwa .xml.

2. Muna buɗe fayil ɗin daga Excel. A halin da nake ciki, cewa ina amfani da Excel 2015, Ina samun saƙo idan ina son ganin sa azaman tebur na XML, a matsayin littafi mai karantawa kawai ko kuma idan ina son amfani da tushen tushen XML. Na zaɓi zaɓi na farko.

3 Mun bincika jerin jerin haɗin giraben.

4 Muna kwafe su zuwa sabon fayil.

Kuma voila, yanzu mun sami fayil ɗin haɗin Google Earth, a cikin tebur na Excel. Farawa daga jere na 29, a shafi na X sun bayyana sunayen ginshiƙai, da latitude / longitude suna daidaitawa a cikin shafi na AH. Na ɓoye wasu ginshiƙai, don ku ga cewa a layuka 40 da 41 zaku iya ganin polygons biyu da na zana, tare da jerin abubuwan haɗin su.

Saboda haka, tare da kwashe ginshiƙan X da kuma shafi na AH, kana da abubuwa da kuma haɗin abubuwan da ke cikin Google Earth.

Muna fatan abin da ke sama ya taimake ka ka fahimci yadda za a adana bayanan Google Earth a cikin wani sakon kmz, kazalika ka fahimci yadda za a wuce wata hanyar kmz zuwa km, a karshe yadda za ka duba daidaituwa ta Google ta amfani da Excel.


Abin sha'awa a wani abu dabam?


Sauya bayanai daga Google Earth zuwa UTM.

Yanzu, idan kuna son mayar da waɗannan haɗin gwargwadon wuri wanda kuke da shi a cikin nau'i na ƙimar ƙaƙƙarwa na latitude da longitude zuwa wani tsari na haɗin UTM da aka tsara, to, zaku iya amfani da samfurin da ke akwai don wannan.

Mene ne haɗin UTM?

UTM (Universal Traverso Mercator) tsarin ne wanda ke rarraba duniya a cikin yankunan 60 na digiri na 6 kowannensu, canza cikin hanyar hanyar ilmin lissafi don kama da grid da aka tsara a kan wani ellipsoid; kamar dai an bayyana a cikin wannan labarin. da kuma a wannan bidiyo.

Kamar yadda kake gani, a can zaku kwafa abubuwan haɗin da aka nuna a sama. A sakamakon haka, zaku sami haɗin X, Y da kuma UTM Zone wanda aka yiwa alama a cikin koren shafi, wanda a wannan misalin ya bayyana a Zone 16.

Aika bayanai daga Google Earth zuwa AutoCAD.

Don samun damar aika bayanan zuwa AutoCAD, kawai kuna kunna umarnin maki da yawa. Wannan yana cikin shafin «Draw», kamar yadda aka nuna a zane a hannun dama.

Da zarar kun kunna umarnin Multiple Points, kwafa da manna bayanai daga samfurin Excel, daga shafi na ƙarshe, zuwa layin umarnin AutoCAD.

Tare da wannan, an zana abubuwan haɗin ku. Don duba su, zaku iya Rage zuƙowa / Duk.

Zaka iya saya samfurin tare da Paypal ko katin bashi. Lokacin biyan kuɗi, kun karɓi imel tare da mahaɗin saukarwa. Sayen samfurin yana ba ku damar tallafawa imel, idan kuna da matsala tare da samfurin.


Koyi yadda ake yin wannan da sauran samfura a cikin Excel-CAD-GIS hanya mai cuta.


 

5 Amsoshi zuwa "Duba abubuwan haɗin Google Earth a cikin Excel - kuma maida su zuwa UTM"

  1. Abin kunya ne, mafiya ko Google Earth ba zai bada izinin ƙirƙirar polygons ba tare da halaye aceitáveis ​​daidai. Saura da fazê-lo daga shirin GIS kuma aika shi zuwa Google Earth.

    gaisuwa

  2. Oi jayana!

    Yaya zan iya ƙara polygon ba google duniya ba?

    Yana da muhimmanci a sanya matakai na farko da kuma ƙara su ko polygon a hanyar da ta dace domin ya dace da yankin. Amma abin da ya faru lokacin da faço ko Zoom ya ba da yanki na aiki, ko fastoci ta hanyar yin amfani da ko polygon, ba da wata babbar kuskure tsakanin ko polygon o ponto.
    Ou seja, Ina buƙatar ƙara polygon ba google duniya (zai iya zama daga tayarwa, daɗaɗa)

    Ina fatan cewa na daidaita kuma muito obrigada!

  3. hi geofumadas, kyakkyawan shawarwari don amfani da google duniya, yana taimaka mini mai yawa a cikin aikin.
    wani goyon baya, inda zan iya sauke KOWANYI TO BUGANI DA LITTAFI GASKIYAR KASHIN GEOGRAPHIC (X, Y, Z) TO UTM, Ina bukatanta.
    Ina jira don sharhin ku
    gaisuwa
    fabio

Barin amsa

Your email address ba za a buga.

Wannan shafin yana amfani da Akismet don rage spam. Koyi yadda aka sarrafa bayanan bayaninka.