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 zazzage wannan bayanan, danna dama akan "Gwamnatina", sannan zaɓi "Ajiye wuri azaman..."

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 don ganin tsawo na fayil yana kunna, daga shafin "Duba" na mai binciken fayil.

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 ɗin ba a matsawa ba. Maɓallin linzamin kwamfuta na dama, kuma zaɓi "Cire zuwa...". A cikin yanayinmu, ana kiran fayil ɗin "Geofumed Classroom Land".

Kamar yadda muke iya gani, an ƙirƙiri babban fayil, kuma a ciki za ku iya ganin fayil ɗin kml mai suna "doc.kml" da babban fayil mai suna "files" wanda ya ƙunshi bayanan haɗin gwiwa, gabaɗaya 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 aika bayanan zuwa AutoCAD, kawai kuna kunna umarnin multipoint. Wannan yana cikin shafin “Zana”, kamar yadda aka nuna a hoton da ke 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.