ZosangalatsaGoogle Earth / Maps

Onani makonzedwe a Google Earth mu Excel - ndikusintha kukhala UTM

Ndili ndi deta ku Google Earth, ndipo ndikufuna kuwona maofesi a Excel. Monga mukuwonera, ndi dziko lokhala ndi mawonekedwe 7 komanso nyumba yokhala ndi mbali zinayi.

Sungani deta ya Google Earth.

Kuti mutsitse detayi, dinani kumanja pa "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 yamafayilo a kml. Chifukwa chake, njira yosavuta yosinthira izi ndi momwe tingachitire ndi fayilo ya .zip kapena .rar.

Monga tawonera pazithunzi zotsatirazi, mwina sitingathe kuwona kufalikira kwa fayilo. Kuti tichite izi, tiyenera kuchita izi:

 

1. The njira kuona wapamwamba kutambasuka adamulowetsa, kuchokera "View" tabu wa wapamwamba wofufuza.

2. Sinthani zowonjezera kuchokera .kmz kupita ku .zip. Kuti muchite izi, kudina kofewa kumapangidwa pa fayilo, ndipo zomwe zimatsatidwazo zisinthidwa. Tikuvomereza uthenga womwe udzawonekere, womwe umatiuza kuti tikusintha zowonjezera ndikuti zitha kupangitsa kuti zisagwiritsidwe ntchito.

3. Fayiloyo ndi yosakanizidwa. Dinani kumanja kwa mbewa, ndikusankha "Chotsani ku ...". Kwa ife, fayiloyo imatchedwa "Geofmed Classroom Land".

Monga tikuonera, chikwatu chinapangidwa, ndipo mkati momwe mungathe kuwona fayilo ya kml yotchedwa "doc.kml" ndi foda yotchedwa "mafayilo" yomwe ili ndi deta yogwirizana, nthawi zambiri zithunzi.

Tsegulani KML kuchokera ku Excel

Kodi fayilo ya Kml ndi chiyani?

Kml ndi mtundu wodziwika ndi Google Earth, womwe udalipo kampani ya Keyhole isanachitike, chifukwa chake dzina (Keyhole Markup Language), ndiye fayilo yokhala ndi XML (eXtensible Markup Language). Chifukwa chake, pokhala 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, kuti ndikugwiritsa ntchito Excel 2015, ndimalandira uthenga ngati ndikufuna kuuwona ngati tebulo la XML, ngati buku lowerengera kapena ngati ndikufuna kugwiritsa ntchito gwero la XML. Ndimasankha njira yoyamba.

3 Timayang'ana mndandanda wa maiko a dziko.

4 Timawafanizira ku fayilo yatsopano.

Ndipo voila, tsopano tili ndi Google Earth yolumikizira fayilo, mu tebulo la Excel. Kuyambira pa mzere 29, m'ndandanda X pamakhala mayina amizere, ndipo kutalika / kutalika kumayendera m'mbali AH. Ndabisa zipilala zina, kuti muwone kuti m'mizere 40 ndi 41 mutha kuwona ma polygoni awiri omwe ndidalemba, ndi maunyolo awo.

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 mukuwonera, pamenepo mumatsanzira makonzedwe omwe ali pamwambapa. Zotsatira zake, mudzakhala ndi ma X, Y oyang'anira komanso UTM Zone yomwe ili ndi gawo lobiriwira, lomwe pachitsanzo chimenecho limapezeka ku Zone 16.

Tumizani deta kuchokera Google Earth kuti ikhale AutoCAD.

Kuti mutumize deta ku AutoCAD, muyenera kungoyambitsa lamulo la multipoint. Izi zili mu "Jambulani" tabu, monga zikuwonekera pachithunzi chakumanja.

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

Ndi izi, maofesi anu ajambulidwa. Kuti muwone, mutha kusintha / zonse.

Mukhoza kupeza template Paypal kapena Credit Card. Mukamalipira, mumalandira imelo yokhala ndi ulalo wotsitsa. Kugula template kumakupatsani mwayi wothandizira imelo, ngati mungakhale ndi vuto ndi template.


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


 

Golgi Alvarez

Wolemba, wofufuza, katswiri wa Land Management Models. Iye watenga nawo gawo pakukonza ndi kukhazikitsa zitsanzo monga: National System of Property Administration SINAP ku Honduras, Model of Management of Joint Municipalities ku Honduras, Integrated Model of Cadastre Management - Registry ku Nicaragua, System of Administration ya Territory SAT ku Colombia. . Mkonzi wa blog ya chidziwitso cha Geofumadas kuyambira 2007 ndi mlengi wa AulaGEO Academy yomwe imaphatikizapo maphunziro oposa 100 pa GIS - CAD - BIM - Digital Twins mitu.

Nkhani

5 Comments

  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

Kusiya ndemanga

Anu email sati lofalitsidwa. Amafuna minda amalembedwa ndi *

Bwererani pamwamba