Onani Google Earth ikugwirizanitsa ku Excel - ndipo mutembenuzire ku UTM

Ndili ndi deta ku Google Earth, ndipo ndikufuna kuwona maofesiwa mu Excel. Monga mukuonera, ndi chiwembu ndi mazenera a 7 ndi nyumba yokhala ndi mavoti anai.

Sungani deta ya Google Earth.

Kutsitsa izi, dinani kumanja "Malo Anga", ndikusankha "Sungani malo ngati ..."

Pokhala fayilo yomwe imakhala ndi mizere, mfundo ndi katundu zomwe ndasinthira ku mafano, fayilo siidzapulumutsidwa ngati simple kml koma Kmz.

Kodi fayilo ya KMZ ndi chiyani?

A kmz ndi seti ya maofesi a compress kml. Kotero, njira yosavuta yowulumikiza ndi momwe tingachitire ndi file ya .zip kapena .rar.

Monga momwe zisonyezera muwunikira lotsatirali, mwina mwina sitikuwona kufalikira kwa fayilo. Pa izi, tiyenera kuchita zotsatirazi:

1. Njira yosonyezera kufalikira kwa mafayilo yamasulidwa, kuchokera pa "View" tab ya osatsegula fayilo.

2 Kuwonjezeka kwa .kmz to .zip kusinthidwa. Kuti muchite izi, dinani yofewa imapangidwa pa fayilo, ndipo deta yomwe ili pambuyo pake isinthidwa. Timavomereza uthenga umene udzawonekere, kusonyeza kuti tikusintha fayilo yowonjezera komanso kuti ikhale yosasinthika.

3 Fayiloyo imasokoneza. Dinani la mbewa yakumanja, ndipo "Extract in ..." wasankhidwa. M'malo mwathu, fayilo imatchedwa «Geofumadas Classroom Ground».

Monga tikuonera, foda inalengedwa, ndipo mkati mwake mukhoza kuona fayilo ya kml yotchedwa "doc.kml" ndi foda yomwe imatchedwa "mafayilo" omwe ali ndi deta yogwirizana, ndi zithunzi zambiri.

Tsegulani KML kuchokera ku Excel

Kodi fayilo ya Kml ndi chiyani?

Kml ndi yovomerezeka ndi Google Earth, yomwe inali patsogolo pa kampani ya Keyhole, motero dzina (Keyhole Markup Language), ndilo fayilo mu XML dongosolo (Language EXtensible Markup). Choncho, kukhala fayilo ya XML iyenera kuwonedwa kuchokera ku Excel:

1 Tasintha kufalikira kwake kuchokera ku .kml ku .xml.

2 Timatsegula fayilo kuchokera ku Excel. Kwa ine, ndikugwiritsa ntchito Excel 2015, ndimalandira uthenga ngati ndikufuna kuwona ngati galasi la XML, ngati bukhu lokhalokha kapena ngati ndikufuna kugwiritsa ntchito gulu la chithunzi cha XML. Ndikusankha njira yoyamba.

3 Timayang'ana mndandanda wa maiko a dziko.

4 Timawafanizira ku fayilo yatsopano.

Ndipo voila, tsopano tiri ndi fayilo ya zochitika za Google Earth, mu tebulo la Excel. Kuchokera m'ndandanda 29, mu ndime X ikuwoneka maina a ndime, ndipo zikugwirizana ndi latitude / longitude mu chigawo cha AH. Ndabisala zipilala zina, kuti muwone kuti mu mzere wa 40 ndi 41 mukhoza kuona ma polygoni awiri omwe ndinatulutsa, ndi chingwe chawo chogwirizana.

Kotero, pokopera zikhomo X ndi AH gawo, muli ndi zinthu ndi zolemba zanu za Google Earth.

Tikukhulupirira kuti zomwe tafotokozazi zakuthandizani kumvetsa momwe mungasungire deta ya Google Earth mufayilo ya kmz, komanso kumvetsetsa momwe mungapititsire fayilo ya kmz kufika kilomita imodzi, potsiriza momwe mungayang'anire Google Earth ikugwiritsira ntchito Excel.


Wokonda china chake?


Sinthani deta kuchokera Google Earth kupita ku UTM.

Tsopano, ngati mukufuna kutembenuza maofesi a dzikoli omwe muli ndi madigiri aatali ndi longitude kufika ku UTM yomwe ikuwonetseratu maonekedwe, ndiye mukhoza kugwiritsa ntchito template yomwe ilipo.

Kodi ma UTM amawotani?

UTM (Universal Traverso Mercator) ndi dongosolo lomwe limagawaniza dziko lonse mu 60 madera a madigiri a 6 iliyonse, kusinthidwa mwa njira ya masamu kufanana ndi galasi lotengedwa pa ellipsoid; monga ngati akufotokozedwa m'nkhaniyi. ndi mu kanema iyi.

Monga mukuonera, apo pali ma edata omwe tawonetsedwa pamwambapa. Chotsatira chake, mudzakhala ndi X, Y komanso makonzedwe a UTM omwe ali pamtundu wobiriwira, womwe muchitsanzo chimenecho umapezeka m'dera la 16.

Tumizani deta kuchokera Google Earth kuti ikhale AutoCAD.

Kuti muthe kutumiza deta ku AutoCAD, mumangoyenera kulamulira malamulo ambiri. Izi ziri pa tabu ya "Dulani", monga momwe ikuwonetsedwera mujambula kumanja.

Mutatsegula Multiple Points command, lembani ndi kusunga deta kuchokera ku template ya Excel, kuchokera ku gawo lomaliza, kupita ku mzere wa command AutoCAD.

Ndi ichi, makonzedwe anu athandizidwa. Kuti muwoneke, Onetsetsani / Zonse zikhoza kuchitika.

Mukhoza kupeza template Paypal kapena Credit Card. Mukamapereka malipiro, mumalandira imelo ndi chiyanjano chotsitsa. Kupeza template kukupatsani ufulu wothandizira ndi imelo, ngati muli ndi vuto ndi template.


Phunzirani momwe mungapangire izi ndi ma template ena mu Maphunziro achinyengo a Excel-CAD-GIS.


Mayankho a 5 ku "Onani Google Earth ikugwirizanitsa ku Excel - ndikutembenuza ku UTM"

  1. Ndizochititsa manyazi, zambiri kapena Google Earth salola ma polygoni ndi zizindikiro za precisão aceitáveis. Lembani pulogalamu ya GIS ndikuitumiza ku Google Earth.

    moni

  2. Oi geofumadas !!

    Ndingathe bwanji kuwonjezera pa polygon osati google earth?

    Ndikofunika kuyika mfundo zoyamba ndikuziwonjezera kapena polygon m'njira yachilendo kuti muwononge dera lanu. Koma chimachitika n'chiyani ngati zolemba kapena Zoom zimapereka malo ogwira ntchito, kapena ponto kapena sobrepõe ao kapena polygon, deixando mtunda waukulu wa zolakwika pakati pa polygon yo ponto.
    Kapena ndikufunika kuwonjezera pulogoni osati google lapansi (Icho chikhoza kukhala choposa, chonchi)

    Ndikukhulupirira kuti ndimasintha ndi muito obrigada!

  3. Maofesi a maofesi, ndondomeko zabwino zogwiritsira ntchito google lapansi, zimandithandiza kwambiri pantchito yanga.
    chithandizo, komwe ndingathe kukopera MAFUNSO OTHANDIZA LIST YA GEOGRAPHICAL COORDINATES (X, Y, Z) KU UTM, Ndikufunika.
    Ndikudikira ndemanga yanu
    zonse
    fabio

Siyani yankho

Anu email sati lofalitsidwa.

Tsambali likugwiritsa ntchito Akismet kuchepetsa spam. Phunzirani momwe deta yanu ikufotokozera.