Saib Google Earth cov haujlwm hauv Excel - thiab hloov lawv mus rau UTM

Kuv muaj cov ntaub ntawv hauv Google Ntiaj Teb, thiab kuv xav pom qhov ua kom sib haum hauv Excel. Raws li koj tuaj yeem pom, nws yog thaj av uas muaj 7 pem toj thiab ib lub tsev uas muaj plaub ntsug.

Txuag Google cov ntaub ntawv hauv ntiaj teb.

Txhawm rau rub tawm cov ntaub ntawv no, nyem rau ntawm "Kuv qhov chaw", thiab xaiv "Txuag qhov chaw li ..."

Rau qhov ua cov ntaub ntawv uas muaj cov kab, cov ntsiab lus thiab cov khoom uas kuv tau hloov rau cov cim, cov ntaub ntawv yuav tsis raug cawm dim li kml yooj yim tab sis ua Kmz.

Ib cov ntaub ntawv KMZ yog dab tsi?

Ib kmz yog qhov teeb ntawm compressed kml ntaub ntawv. Yog li txoj hauv kev yooj yim rau unzip nws yog qhov uas peb xav nrog .zip lossis .rar cov ntaub ntawv.

Raws li pom nyob hauv daim duab hauv qab no, peb yuav tsis pom lub pob txuas ntxiv. Txhawm rau ua qhov no, peb yuav tsum ua cov hauv qab no:

1. Qhov kev xaiv kom pom cov ntaub ntawv txuas ntxiv yog qhib, los ntawm "Saib" tab ntawm cov ntaub ntawv tshawb nrhiav.

2. Hloov pauv txuas ntawm .kmz rau .zip. Txhawm rau ua qhov no, lub pob nyem yog ua rau ntawm cov ntawv, thiab cov ntaub ntawv tom qab tus taw tes hloov kho. Peb lees txais cov lus uas yuav tshwm sim, uas qhia peb tias peb tab tom hloov pauv ntawv thov thiab nws tuaj yeem ua rau nws siv tsis tau.

3. Cov ntaub ntawv yog uncompressed. Txoj cai nas khawm, thiab xaiv "Extract to ...". Hauv peb cov ntaub ntawv, cov ntaub ntawv hu ua "Geofumed Classroom Land".

Raws li peb tuaj yeem pom, ib daim ntawv tais ceev tseg tau tsim, thiab sab hauv koj tuaj yeem pom cov ntaub ntawv kml hu ua "doc.kml" thiab ib lub nplaub tshev hu ua "cov ntaub ntawv" uas muaj cov ntaub ntawv cuam tshuam, feem ntau cov duab.

Qhib KML los ntawm Excel

Ib cov ntaub ntawv Kml yog dab tsi?

Kml yog ib hom ntawv uas nrov los ntawm Google Earth, uas yog ua ntej lub tuam txhab Keyhole, yog li ntawd lub npe (Keyhole Markup Language), yog li ntawd, nws yog cov ntaub ntawv nrog XML qauv (eXtensible Markup Language). Yog li, ua ib daim ntawv XML nws yuav tsum tuaj yeem pom ntawm Excel:

1 Peb hloov nws txoj kev ncua ntawm .kml rau .xml.

2. Peb qhib cov ntaub ntawv los ntawm Excel. Hauv kuv qhov xwm txheej, uas kuv tau siv Excel 2015, Kuv tau txais cov lus yog tias kuv xav pom nws ua XML rooj, ua ib phau ntawv nyeem nkaus xwb lossis yog tias kuv xav siv XML lub vaj huam sib luag. Kuv xaiv thawj qhov kev xaiv.

3 Peb tshawb tau cov npe ntawm cov thaj chaw.

4 Peb luam lawv rau ib daim ntawv tshiab.

Thiab voila, tam sim no peb muaj Google Earth cov ntawv tswj hwm cov ntaub ntawv, hauv Excel cov lus. Pib txij kab 29, hauv kab X tshwm cov npe ntawm cov kab ntsug, thiab cov kab sib xyaw ntev ntev / latitude hauv kem AH. Kuv tau zais qee kab ntawv, kom koj tuaj yeem pom tias nyob hauv kab 40 thiab 41 koj tuaj yeem pom ob lub thawb uas kuv tau kos, nrog lawv cov saw ntawm cov neeg sib koom tes.

Li ntawd, nrog luam X cov kab X thiab kab sau AH, koj muaj cov khoom thiab kev tswj ntawm koj Google cov ntsiab lus tseem ceeb.

Peb cia siab tias cov lus saum toj no tau pab koj nkag siab txog kev khaws Google Earth cov ntaub ntawv nyob rau hauv ib daim ntawv thov kmz, thiab kom nkag siab tias yuav kis tau li cas kmz rau kml, thaum kawg saib Google Earth coordinates siv Excel.

Puas txaus siab rau lwm yam?

Hloov cov ntaub ntawv los ntawm Google Lub Ntiaj Teb rau UTM.

Tam sim no, yog tias koj xav hloov cov thaj chaw uas koj muaj nyob rau hauv daim ntawv ntawm kaum degrees degrees latitude thiab longitude rau ib daim UTM coordinate hom, koj siv tau cov template uas muaj rau qhov ntawd.

UTM ua haujlwm dabtsi?

UTM (Universal Traverso Mercator) yog ib qhov system uas faib lub ntiaj teb hauv 60 aav ntawm 6 degrees txhua, hloov hauv kev ua lej kom zoo li lub phiajxwm ntawm ib qho ellipsoid; cia li nyiam yog piav qhia hauv tsab xov xwm no. thiab hauv qhov yees duab no.

Raws li koj tau pom, muaj koj luam cov ua haujlwm tau qhia saum toj no. Raws li qhov tshwm sim, koj yuav muaj X, Y tswj hwm thiab tseem suav qhov UTM Cheeb Tsam cim hauv kem ntsuab, uas nyob hauv qhov piv txwv ntawd tshwm sim nyob rau thaj tsam 16.

Xa cov ntaub ntawv los ntawm Google Lub Ntiaj Teb rau AutoCAD.

Txhawm rau xa cov ntaub ntawv mus rau AutoCAD, koj tsuas yog yuav tsum qhib lub multipoint hais kom ua. Qhov no yog nyob rau hauv "Draw" tab, raws li qhia hauv daim duab ntawm sab xis.

Thaum koj tau qhib cov lus qhuab qhia ntau lub ntsiab lus, luam thiab paste cov ntaub ntawv los ntawm Excel template, ntawm sab kawg, mus rau AutoCAD hais kom ua kab.

Nrog rau qhov no, koj txoj kev sib koom tes tau kos. Txhawm rau saib lawv, koj tuaj yeem xoom / Txhua.

Koj tuaj yeem kis tau tus qauv nrog Paypal lossis Credit CardCov. Thaum ua qhov kev them nqi, koj tau txais email nrog qhov txuas txuas. Kev yuav tus template ntaws koj xa email txhawb, nyob rau hauv rooj plaub koj muaj teeb meem ntawm lub ntsej muag.

Kawm yuav ua li cas thiaj ua qhov no thiab lwm tus qauv hauv Excel-CAD-GIS dag cov chav kawm.