Wona Google Earth inowirirana muExcel - uye uvashandurire kuUTM

Ndine dhata muGoogle Earth, uye ini ndoda kuona iwo marongero muExcel. Sezvauri kuona, inyika ine ma vertices manomwe uye imba ine mavhenekeri mana.

Chengeta data yeGoogle Earth.

Kudhawunirodha iyi data, tinya kurudyi pa "Nzvimbo Dzangu", uye sarudza "Sevha nzvimbo se..."

Sekuve faira ine mitsara, mapepa uye zvinhu zvandakashandura kune zvidhori, faira haigoni kuponeswa seyo kml asi nyore se Kmz.

Chii chinyorwa cheKMZ?

Iyo kmz seti yemakomputa kml mafaera. Saka, nzira iri nyore yekuisunungura iyo sezvatingaita ne .zip kana .rar faira.

Sezvinoratidzwa mune inotevera graphic, isu hatingaone iyo yekuwedzera faira. Kuti tiite izvi, tinofanira kuita zvinotevera:

1. Sarudzo yekuona faira yekuwedzera inoshandiswa, kubva pa "View" tab yefaira rekuongorora.

Chinja kuwedzerwa kubva .kmz kuenda ku .zip. Kuti uite izvi, kubaya zvinyoro nyoro kunoitwa pane iyo faira, uye iyo data iri mushure mekiyi yashandurwa. Isu tinogamuchira meseji inozoonekwa, iyo inotitaurira kuti tiri kuchinja iyo yekuwedzera faira uye kuti inogona kuita kuti isashande.

3. Iyo faira haina kudzvanywa. Rudyi bhatani rembeva, uye sarudza "Bvisa ku ...". Kwatiri, iyo faira inonzi "Geofmed Classroom Land".

Sezvatinoona, folda yakagadzirwa, uye mukati chaimo munogona kuona kml faira inonzi "doc.kml" uye folda inonzi "mafaira" ine data yakabatana, kazhinji mifananidzo.

Vhura KML kubva kuExcel

Chii chine file yeKll?

Kml fomati yakakosheswa neGoogle Earth, yaive pamberi pekambani yeKeyhole, nekudaro zita (Keyhole Markup Mutauro), nekudaro, iri faira rine XML chimiro (eXtensible Markup Mutauro). Saka, kuve faira reXML rinofanira kukwanisa kutariswa kubva kuExcel:

1 Takachinja kuwedzera kwayo kubva ku .kml kusvika ku .xml.

2. Isu tinovhura iyo faira kubva kuExcel. Mune yangu nyaya, iyo yandiri kushandisa Excel 2015, ndinowana meseji kana ndichida kuiona setafura yeXML, sebhuku rekuverenga-chete kana kana ndichida kushandisa iyo XML sosi yepaneru. Ini ndinosarudza yekutanga sarudzo.

3 Isu tinotsvaga runyorwa rwekugadzirisa nzvimbo.

4 Tinozvikopa ivo kune faira itsva.

Uye voila, ikozvino tave neGoogle Earth inoratidzira faira, mune tafura yeExcel. Kutanga kubva pamutsara 29, mukoramu X unoonekwa mazita emawere, uye latitude / longitude inoratidzira mukoramu AH Ini ndaviga mamwe makoramu, kuti iwe ugone kuona kuti mumitsara makumi mana nemakumi mana nepfumbamwe unogona kuona mapoligoni maviri andakadhirowa, neketani yadzo yemahara.

Nokudaro, nekukopisa mitsara ye X neAH column, une zvinhu uye mazano eGoogle Earth points.

Tinotarisira kuti zviri pamusoro apa zvakakubatsira kuti unzwisise nzira yekuchengetedza dhidhiyo yeGoogle Earth mune faira kmz, uyewo kuti unzwisise kuti ungapfuura sei file kmz kusvika kml, pakupedzisira maonero aGoogle Earth inoshandisa sei Excel.

Kufarira pane chimwe chinhu?

Shandura data kubva kuGoogle Earth kuUTM.

Iye zvino, kana iwe uchida kutendeuka mahofisi emunharaunda mauri mune chimiro chemadhigirii emadhora ekukwirira uye kumucheto kusvika kune mafomu ekurongwa kweUTM anofungidzirwa, unogona kushandisa template iripo yeiyo.

Ndezvipi zvirongwa zveUTM?

UTM (Universal Traverso Mercator) inzira inoparadzanisa nyika munzvimbo dze 60 dze6 digiri nechikamu chimwe nechimwe, inoshandurwa nenzira yemasvomhu kuti iite segridhi inorongwa pane ellipsoid; zvakangofanana inotsanangurwa munyaya ino. and mune iyi vidiyo.

Sezvauri kuona, ipapo iwe unoteedzera iwo akaratidzirwa pamusoro Nekuda kweizvozvo, iwe unenge uine X, Y inoratidzira uyezve neUTM Zoni yakaratidzirwa mugirini yegirini, iyo mumuenzaniso iwoyo inowanikwa muZone 16.

Tumira data kubva kuGoogle Earth kuAcCAD.

Kuti utumire data ku AutoCAD, iwe unongofanirwa kumisa iyo multipoint command. Iyi iri mu "Dhiza" tab, sezvakaratidzwa mumufananidzo uri kurudyi.

Kana wambotora Multiple Points command, kopi uye unamate data kubva kuExcel template, kubva pakuronga rwekupedzisira, kuenda kuAuto AutoCAD mutsara.

Nezve izvi, ako makoodhi akave akavezwa. Kuti uvaone, unogona Zoom / All.

Iwe unogona kuwana template ne Paypal kana Credit Card. Paunenge uchiita muripo, unogashira email neyekuburitsa chinongedzo. Kutenga template kunoita kuti utumire email rutsigiro, kana uine dambudziko ne template.

Dzidza maitiro ekugadzira izvi nemamwe matemplate mu Excel-CAD-GIS kubiridzira.