Sheba likhokahanyo tsa Google Earth ho Excel - 'me u li fetolele ho UTM

Ke na le data ho Google Earth, 'me ke batla ho bona likhokahano ho Excel. Joalokaha u bona, ke naha e nang le lits'oants'o tse 7 le ntlo e nang le lits'oants'o tse 'ne.

Boloka polokelo ea Google Earth.

Ho khoasolla lintlha tsena, tobetsa ka ho le letona ho "Libaka tsa ka", ebe u khetha "Boloka sebaka joalo ka..."

Ho ba file e nang le mela, lintlha le thepa eo ke e fetotseng ho litšoantšo, faele e ke ke ea pholosoa e le kml e bonolo empa e le Kmz.

Sifa ea KMZ ke eng?

A kmz ke sete ea lifaele tse hatelitsoeng tsa kml. Kahoo, tsela e bonolo ka ho fetisisa ea ho e notlolla ke kamoo re neng re ka etsa ka file ea .zip kapa .rar.

Joalokaha ho bontšitsoe setšoantšong se latelang, re kanna ra se bone katoloso ea faele. Ho etsa sena, re tlameha ho etsa tse latelang:

1. Khetho ea ho bona katoloso ea faele e kentsoe, ho tsoa ho "View" tab ea mofuputsi oa faele.

2. Fetola katoloso ho tloha .kmz ho .zip. Ho etsa sena, tlanya e bonolo e etsoa faeleng, mme data kamora hore ntlha e fetoloe. Re amohela molaetsa o tla hlaha, o re joetsang hore re fetola katoloso ea lifaele le hore e ka etsa hore e se sebelisoe.

3. Faele ha e hatellehe. Tobetsa ho le letona la toeba, ebe u khetha "Extract to ...". Tabeng ea rona, faele e bitsoa "Geofmed Classroom Land".

Joalokaha re bona, foldara e entsoe, 'me ka hare ho eona u ka bona faele ea kml e bitsoang "doc.kml" le folda e bitsoang "lifaele" tse nang le data e amanang le eona, hangata litšoantšo.

Bula KML ho tloha Excel

Sifa sa Kml ke eng?

Kml ke mofuta o tsebahalang ke Google Earth, o neng o le teng pele ho k'hamphani ea Keyhole, ka hona lebitso (Puo ea Keyhole Markup), ka hona, ke faele e nang le sebopeho sa XML (eXtensible Markup Language). Kahoo, ho ba faele ea XML e tlameha ho khona ho bonoa ho tsoa Excel:

1 Re fetohile ho eketsoa ha eona ho tloha .kml ho .xml.

2. Re bula file ho tloha Excel. Tabeng ea ka, hore ke sebelisa Excel 2015, ke fumana molaetsa haeba ke batla ho e bona e le tafole ea XML, joalo ka buka e balang feela kapa haeba ke batla ho sebelisa phanele ea mohloli oa XML. Ke khetha khetho ea pele.

3 Re batla lethathamo la likamano tsa mobu.

4 Re li kopitsa ho file e ncha.

Mme voila, joale re na le li-coordinate tsa Google Earth, tafoleng ea Excel. Ho qala ho tloha moleng oa 29, kholomong ea X ho hlaha mabitso a li-vertices, 'me latitude / longitude e hokahana kholomong ea AH. Ke patile likholomo tse ling, e le hore u bone hore meleng e 40 le 41 u ka bona li-polygone tse peli tseo ke li kentseng, le liketane tsa tsona tsa likhokahano.

Kahoo, ka ho kopitsa li-columns X le AH koromong, o na le lintho le litsamaiso tsa lintlha tsa hau tsa Google Earth.

Re tšepa hore se boletsoeng ka holimo se u thusitse hore u tsebe ho boloka dintlha tsa Google Earth ka faele ea km, hammoho le ho utloisisa hore na u ka fetisetsa faele ea kmz ho ea hokae, qetellong ho sheba Google Earth ho sebelisoa Excel.

U thahasella ho hong hape?

Fetola data ho tloha Google Earth ho UTM.

Hona joale, haeba u batla ho fetola likopano tsa sebaka seo u nang le sona ka mokhoa oa likarolo tsa bophara le bophirimela ho ea ka mokhoa oa li-UTM tse tsamaisitsoeng, u ka sebelisa template e teng bakeng sa eona.

UTM e tsamaisa eng?

UTM (Universal Traverso Mercator) ke tsamaiso e arohanyang lefats'e libakeng tsa 60 tsa li-degree tsa 6 e 'ngoe le e' ngoe, e fetotsoe ka mokhoa oa lipalo ho tšoana le setjhaba se hlalositsoeng ho ellipsoid; joalo feela e hlalositsoe sehloohong sena. le ho video ena.

Joalokaha u bona, moo u kopitsa likhokahano tse bontšitsoeng kaholimo. Ka lebaka leo, o tla ba le lihokelo tsa X, Y le sebaka sa UTM se tšoailoeng ka har'a kholomo e tala, eo mohlaleng oo e hlahang ho Zone 16.

Romella data ho tloha Google Earth ho AutoCAD.

E le hore u romelle data ho AutoCAD, u tlameha feela ho kenya tshebetsong taelo ea multipoint. Sena se teng tabeng ea "Draw", joalokaha ho bontšitsoe setšoantšong se ka ho le letona.

Hang ha u se u qetile litaelo tsa Multiple Points, kopitsa le ho boloka boitsebiso bo tsoang template ea Excel, ho tloha khoeling ea ho qetela, ho ea molaong oa molaetsa oa AutoCAD.

Ka sena, likhokahano tsa hau li se li entsoe. Ho li sheba, o ka Nyenyefatsa / Tsohle.

U ka fumana template ka Paypal kapa Credit Card. Ha o etsa tefo, o fumana lengolo-tsoibila le nang le sehokelo sa download. Ho reka template ho u fa tokelo ea ho romella tšehetso ka lengolo tsoibila haeba u ka ba le bothata le template.

Ithute ho etsa litempele tsena le tse ling ho Khoso ea Excel-CAD-GIS cheat.