ZosangalatsaGoogle Earth / Maps

Tumizani mndandanda wamalo ophatikizira ku Google Earth, kuchokera ku Excel, wokhala ndi zithunzi komanso zolemba zambiri

Ichi ndi chitsanzo cha momwe Excel ingatumizire zinthu ku Google Earth. Mlandu ndi uwu:

Tili ndi mndandanda wamakonzedwe amtundu wa decimal (lat / lon). Tikufuna kutumiza ku Google Earth, ndipo tikufuna kuti iwonetse nambala yazosangalatsa, mawu olimba mtima, mawu ofotokozera, chithunzi cha mfundoyi ndi cholumikizira kuti mutsegule tsamba pa intaneti.

Pansipa pali chitsanzo cha zomwe tikuyembekeza kusonyeza pamene tifufuza pa mfundoyi:

Nambala ndi: XL-3458

Kutalika:

-103.377499

Latitude:

20.654443

Ndipo izi ndi zomwe tikuyembekeza kuziwona:


XL-3458

Malo apakati

Nyumba ya Bambo Joaquín Gómez Padre, komwe kunali yunivesite ya dziko lonse ndipo idabwezeretsedwanso ngati nyumba yosungiramo zinthu zakale yotetezedwa ndi National Institute of Anthropology

Onani tsamba pa intaneti


Ngakhale template idzaikidwa, mzimu wa nkhaniyi ndi kufotokoza momwe mungachitire nokha.

Zomwe tili nazo ndikupanga ma tag a html m'magawo osiyanasiyana kuti athe kuwunikira: Nambala ya izi ikhala:

Malo apakati
Nyumba ya Bambo Joaquín Gómez Padre, komwe kunali yunivesite ya dziko lonse ndipo idabwezeretsedwanso ngati nyumba yosungiramo zinthu zakale yotetezedwa ndi National Institute of Anthropology

<img src=”http://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Casas_actiopan.jpg/800px-Casas_actiopan.jpg"width="144kutalika = "168">

<a href="http://commons.wikimedia.org/wiki/File:Casas_actiopan.jpg">Onani tsamba pa intaneti

Malembo onse omwe zikuwonetsa kuti ndi mzere wosiyana, kutseka ndi zomwe zikufanana ndi Enter.

Kenako, chizindikirocho chikuwonetsa kuti mawuwa ndi olimba, ndikuwatseka ndi

im ndi chizindikiro cha chithunzicho, chomwe mkati chimanyamula katundu monga m'lifupi (m'lifupi), kutalika (kutalika) ndi chitsogozo chomwe chithunzicho ndi (src)

Pomaliza pali cholembera cha hyperlink, chomwe chimayamba ndi

Chomwe chimasindikizidwa mu chibakuwa ndi chokhutira chomwe chingasinthe ndi chithunzi chilichonse, kotero tidzakhala ndi chidwi ndikuchoka m'maselo.

Popanda kubweranso, mukhoza kuona kuti ntchito ya concatenate idzafotokozedwa mwachidule pazinthu izi:

= ONANI(,CELDA,,CELDA,,CELDA,<img src=",CELDA,"width=",CELDA,kutalika = ",CELDA,"><a href=",CELDA,>>,CELDA,)

Zomwe zikutanthawuza, kuti titenga mizati 8 kuti tisunge zonse zomwe tikufuna kuwonetsa. Ngakhale kwa iwo omwe ali ndi zilembo zomwe amagwiritsa ntchito = chizindikiro ndi mawu obwereza kawiri, ndizovuta kwa ife chifukwa mu Excel woyamba akuwonetsa ntchito ndipo wachiwiri amagwiritsidwa ntchito kupatula zolemba. Izi zimathetsedwa poyika zomwe zili m'maselo osiyanasiyana ngati kuti zidalembedwa.

Potsiriza tili ndi izi:

lat lon kupita google lapansi

Ndipo kutumiza ku Google Earth ndayika batani yomwe imapanga fayilo.  lat lon kupita google lapansiKumeneko mumatchula njira yomwe fayilo ilili ndi dzina limene mukuyembekeza kuti lifotokoze kml pamene likuwonetsedwa mu gulu lamanzere.

Chikhomo chimakhala ndi mbewa ina yomwe imalumikizidwa ndi cell kuti iwonetse momwe zidziwitso ziyenera kulowedwera. Kawirikawiri zimakhala ndi vuto pamene ma macro saloledwa komanso pamene njira yomwe fayilo ikupangidwira siyilembedwe.

Kumeneko tili nayo, mungathe kufufuza ndi code pamtundu wa Google Earth, ndipo kudindira pa mfundoyo ikuwonetsedwa monga momwe timayembekezera.

lat lon kupita google lapansi

 

latlon kupita google earhtTsitsani chitsanzo kml

Pamafunika chopereka chophiphiritsira kutsitsa, komwe mungachite Paypal kapena khadi la ngongole.

Ndilophiphiritsira ngati wina akuwona momwe ntchitoyo ikugwiritsire ntchito komanso kumasuka kwake.

 

 


 

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


 

Mavuto ambiri

Zitha kuchitika kuti, pogwiritsa ntchito ntchitoyi, chimodzi mwa zochitika zotsatirazi zikhoza kuwoneka:


Zolakwitsa 75 - Fayilo njira.

Izi zimachitika chifukwa njira yomwe yafotokozedwa pamene fayilo ya kml idzapulumutsidwa siyikupezeka kapena palibe zilolezo za izi.

Mwachidziwikire, muyenera kuyika njira pa disk D, yomwe ili ndi malire ochepa kuposa omwe disk C amakhala nayo.

D: \

Mfundo izi zikubwera ku North Pole.

Izi zimachitika kawirikawiri, chifukwa m'mawindo athu, monga momwe tawonetsedwera muzithunzi zogwirira ntchito, malo okonzekera dera ayenera kukhazikitsidwa mu gulu lachigawo:

  • -Pangidwe, kuti mukhale wopatukana
  • -Coma, kwa separator zikwi
  • -Coma, kuti mulekanitse mndandanda

Kotero, deta monga: Mamita 1,000 ndi makumi asanu ndi atatu mphambu makumi asanu ndi awiri ndi masentimita khumi ndi awiri ayenera kuwonedwa ngati 1,780.12

Chithunzicho chikuwonetsa momwe kukonzekeraku kwakhalira.

Ichi ndi chithunzi china chomwe chikuwonetsa kasinthidwe mu gulu lolamulira.

Pomwe kusintha ukupangidwa, fayilo imapangidwanso kachiwiri, mfundozo zidzawonekera kumene zikugwirizana ndi Google Earth.

 

Ngati muli ndi funso, lemberani imelo yothandizira editor@geofumadas.com. Nthawi zonse imawonetsa mtundu wama windows omwe mukugwiritsa ntchito.

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

22 Comments

  1. Ndatsitsa kale template, ndiyiphunzira ndipo ndilemba mafunso kapena zosintha zina. Zikomo g '

  2. Sindikuwona chiyanjano cholipiritsa kudzera ku banki. Ndimachokera ku El Salvador. Zikomo

  3. Ndinkafuna kugula template koma ndilibe khadi ngati ineyo

  4. Onetsetsani, mukutsimikiza kuti mukuyikira batani. Ichi ndi chitsanzo:
    D: obrasalc

  5. Koperani fayilo ya Excel, ndipo ndikuvutika kutumiza zithunzi kuchokera ku disk D: / obras / alc, chonde nditumizireni tsatanetsatane momwe ndingathere zithunzi kuchokera ku adilesiyi.
    Kodi ndikofunikira kuti zithunzi zikhale ndi kukula kwake? kapena mukhoza kugwira ntchito ndi zithunzi za 4 Mb

  6. Inde, ndithudi mungathe kupeza njira zam'deralo pamakompyuta kapena pa intaneti

  7. akuganiza kuti n'zotheka kuwerengera zithunzi zosungidwa m'deralo p PC kapena kugwiritsa ntchito makompyuta. Zikomo

  8. Kodi pulogalamuyi ingawerenge zithunzi zomwe zasungidwa popanda kugwiritsa ntchito URL?

  9. Eya, ndikufuna kugula zizindikiro zanu. Ndine wochokera ku Peru, koma ndikakupatsani izi ku banki ya ku banki, sindikupeza kalikonse.

  10. Timadandaula pazochitikazo, koma tazikonzeratu kale ndipo njira yobwezera yatha kale.

    Zikomo.

  11. Ndikufuna kulipira zambiri zomwe zili pano ndipo sindingathe

  12. Inde.
    Zachilendozi zilibe fungulo lotetezera, kotero likhoza kusinthidwa.

  13. Kuwongolera kumaphatikizapo kutha kusintha fayilo yoyamba kapena lalikulu ma pulogalamuyi mwachindunji.

  14. Sizomwe mukulephera, ndikuti fano la Google likuthawa kwawo

  15. Inde, datamu yomwe ndiri nayo ku Google Earth ndi WGS84.
    Kodi mwapeza chifukwa cha kulephera ndi deta yanga?

  16. Tumizani iwo ku positi ofesi kuti muwawone. Nditumizireni tebulo ku Excel ndi filef kml yomwe imapanga. Mkonzi@geofumadas.com

    Onani ngati mukugwiritsa ntchito Datum, Google Earth ikugwiritsa ntchito UTM WGS84.

  17. Zikomo chifukwa cha liwiro la yankho lomwe lagwira ntchito. Komabe, ndikathamangitsa fayilo ya "kml" ndi Google Earth, pafupifupi palibe mfundo zogwirizanitsa zomwe zimawonekera ndipo ochepa okha ndi omwe amawoneka, pafupifupi nthawi zonse 1 ndi otsiriza a mndandanda, koma kutali kwambiri ndi zomwe zimagwirizana (100 Kms. pe) . Ndatopa ndikuchita mayeso ndipo palibe. Kodi ndingatumizireni fayiloyo ndi data yomwe yadzaza ku imelo? Ndiye ukawona zomwe zikuchitika. Zikomo,

  18. Icho ndi vuto lodziwika, monga izo zalembedwera pamwambapa.
    Sinthani njira, mukuyika fayiloyi mwachindunji ku C: ndipo izi siziloledwa ndi Windows kusintha. Gwiritsani ntchito njira ina ndikuonetsetsa kuti ilipo.

  19. Pulogalamuyo ikuwoneka ngati yabwino kwa ine ndipo yanditengera zambiri kuti ndiipeze.
    Ndili ndi malipiro a ndalama za 2 $ koma ndikupeza kuti ndikachita izo sizigwira ntchito ndipo chenjezo limatuluka kuti:
    "Vuto la nthawi yothamanga '75' linachitika.
    Cholakwika panjira kapena mafayilo"
    Ndikuyamikira ngati mungathe kundiuza momwe ndingathetsere kapena ngati mutanditumizira foni ina ya Excel mwamsanga, chifukwa ndikuyenera kukonzekera ntchito yowunikira malo ndipo ndachedwa.
    Nkhani,

  20. Zimadalira kusamuka.

    Ngati mumasamukira kumtunda mamita angapo (10 kwa XMUMX mamita) chifukwa chakuti fano la google likuthawa kwawo, mukhoza kuwona kusintha chithunzicho kwa zaka zapitazo ndipo mudzawona kuti georeference ndi yoipa kwambiri. Ngakhale mgwirizanowu ndi wolondola.

    Ngati kubwerera kwawo kuli kwakukulu, zikhoza kukhala kuti ndizogwirizana ndi Datum ina. Google imagwiritsa ntchito WGS84.

    Ngati makonzedwewa akugweranso kumalo ena a dziko lapansi, zikhoza kukhala kuti mukulowera kumbali ndi longitude. Kapena simukugwiritsa ntchito chizindikiro: Kumtunda kwakumadzulo kutalika kuli kovuta, kumwera kwa dziko lapansi ndiko kusiyana kulibe.

  21. Chopereka chabwino kwambiri kungoti mumazindikira kuti ndikayika makonzedwe anga sizimandiwonetsa komwe kuli ... mukuganiza kuti zidzakhala bwanji?

Kusiya ndemanga

Anu email sati lofalitsidwa. Amafuna minda amalembedwa ndi *

Bwererani pamwamba