Yongeza
UkulandaGoogle umhlaba / imephu

Uluhlu lokuthumela kwelinye ilizwe kuGoogle Earth, ukusuka kwi-Excel, kunye nomfanekiso kunye nesicatshulwa esityebileyo

Lo ngumzekelo wendlela i-Excel engathumela ngayo umxholo kuGoogle Earth. Ityala yile:

Sinoluhlu lwee-coordinates kwifomati ye-geographic format (lat / lon). Sifuna ukuthumela kuGoogle Earth, kwaye sifuna apho ukubonisa ikhowudi yenqaku lomdla, isicatshulwa esibhalwe ngqindilili, isicatshulwa esichazayo, ifoto yenqaku kunye ne-hyperlink ukuze ivule iphepha kwi-Intanethi.

Ngezantsi umzekelo wento esiyethembayo ukuyibonisa xa sichofoza kwinqanaba:

Ikhowudi yile: XL-3458

Ubude:

-103.377499

Latitude:

20.654443

Kwaye oku sinethemba lokubona:


XL-3458

Kwinqanaba eliphakathi

Indlu kaMnu Joaquín Gómez Padre, apho iYunivesithi yeSizwe yayiqala khona kwaye ibuye ibuyiselwe njengemyuziyam ekhuselwe yiNational Institute of Anthropology

Jonga iphepha kwi-intanethi


Nangona ithemplate iya kulayishwa, umoya wecatshulwa ukuchaza indlela yokwenza ngayo wena.

Into esihlala kuyo kukwenza iithegi ze-html kwiikholamu ezahlukeneyo ukuze sikwazi ukuvumelana: Ikhowudi yoku iya kuba:

Kwinqanaba eliphakathi
Indlu kaMnu Joaquín Gómez Padre, apho iYunivesithi yeSizwe yayiqala khona kwaye ibuye ibuyiselwe njengemyuziyam ekhuselwe yiNational Institute of Anthropology

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

<a href=”http://commons.wikimedia.org/wiki/File:Casas_actiopan.jpg">Jonga iphepha kwi-intanethi

Zonke iilebheli Ukubonisa ukuba ngumgca owahlukileyo, ovala nge elingana no-Enter.

Ke iileyibhile ukubonisa ukuba lo mbhalo ubhalwe ngqindilili, ewe, uwuvala nge

im iilebula yomfanekiso, ophakathi ngaphakathi uphethe iipropati ezifana nobubanzi (ububanzi), ukuphakama (ukuphakama) kunye nesalathiso apho umfanekiso (src)

Okokugqibela kukho ileyibheli yehyperlink, evula ngayo

Into ephawulwe ngombala obomvu yinto enokutshintsha ngomfanekiso ngamnye, ngoko siya kuba nomdla emva koko siyeke kwiiseli.

Ngaphandle kokubuya okukhulu, unokwazi ngoko ukuba umsebenzi we-concatenate uza kushwankathela kwinto efana nale:

= QHUBEKA(,CELDA,,CELDA,,CELDA,<img src=”,CELDA,”ububanzi=",CELDA,"ubude=",CELDA,"><a href=”,CELDA,>>,CELDA,)

Oko kuthetha ukuba siza kuhlala kwiikholamu ezisi-8 ukugcina yonke idatha esifuna ukuyibonisa. Nangona kwimeko yabo baneelebhile ezisebenzisa isimboli kunye nezicatshulwa eziphindwe kabini, kunzima kuthi kuba kwi-Excel eyokuqala ibonisa umsebenzi kwaye eyesibini isetyenziselwa ukwahlula umxholo. Oku kusonjululwa ngokubeka imixholo kwiiseli ezahlukeneyo ngokungathi ngumbhalo.

Ekugqibeleni sinakho oku:

i-lon lon ukuya kwi-google yomhlaba

Kwaye ukuthumela kwiGoogle Earth ndibeke iqhosha elenza ifayile.  i-lon lon ukuya kwi-google yomhlabaKulapho uchaza indlela apho ifayile kunye negama okulindele ukuba ube nencazelo ye kml xa iboniswe kwipaneli ekhohlo.

Itemplate inemouse ngaphezulu kweselfowuni ukucebisa ukuba idatha kufuneka ifakwe njani. Ngokubanzi, ihlala inengxaki xa ii-macros zingenakwenziwa kwaye xa indlela yefayile eyenziwayo ingabhalwanga.

Kukho esinakho, unokukhangela ngekhowudi kwibar yebhedi yeGoogle Earth, kwaye ukucofa kwinqanaba liboniswa njengoko silindele.

i-lon lon ukuya kwi-google yomhlaba

 

latlon ukuya kwi-Google earht DownloadsUkukhuphela umzekelo kml

Ifuna igalelo lokomfuziselo lokukhuphela, onokwenza ngalo Paypal okanye kwikhadi lekhredithi.

Kufanekisela ukuba umntu ucinga ngento ebonelela ngayo kunye nokukhululeka okungafumaneka kuwo.

 

 


 

Funda ukuba ungayenza njani le kunye nezinye itemplate kwi Ikhosi yokukopela ye-Excel-CAD-GIS.


 

Iingxaki eziqhelekileyo

Kungenzeka ukuba, xa usebenzisa isicelo, esinye seziganeko ezilandelayo siyakubonakala:


Iphutha le-75 - Inkqubo yefayile.

Oku kwenzeka ngenxa yokuba indlela echazwe apho ifayile ye-kml iya kugcinwa ayifumanekanga okanye ayikho imvume yeli nyathelo.

Ngokufanelekileyo, kuya kufuneka ubeke umendo kwidiski D, enezithintelo ezimbalwa kunediski C. Umzekelo:

D: \

Amaphuzu aphuma eNtshona Pole.

Oku kuya kwenzeka, ngokuba kwiifestile zethu, njengoko kuboniswe kumyalelo wethemplate ukusebenza, ukucwangciswa kwendawo kufuneka kusekwe kwiphaneli yesithili:

  • -Point, for separator decimals
  • -Coma, ngamawaka ahlukeneyo
  • -Coma, ukuze uhlalutye uluhlu

Ngoko ke, idatha enjengale: Iwaka elinesibhozo elinamakhulu asixhenxe anesibhozo kunye neesentimitha ezilishumi elinesibini kufuneka ibonakale njenge-1,780.12

Umfanekiso ubonisa indlela oku kulungiswa ngayo.

Lo mnye umfanekiso obonisa ukucwangciswa kwipaneli yokulawula.

Emva kokuba utshintsho lwenziwe, ifayile iphinda iveliswe kwakhona kwaye, amanqaku aya kubonakala apho ihambelana neGoogle Earth.

 

Ukuba unombuzo, bhalela kwi-imeyile yomhleli editor@geofumadas.com. Ihlala ibonisa uhlobo lweewindows ozisebenzisayo.

Golgi Alvarez

Umbhali, umphandi, ingcali kwiiModeli zoLawulo loMhlaba. Uthathe inxaxheba ekucingeni nasekuphunyezweni kweemodeli ezifana ne: INkqubo yeSizwe yoLawulo lwePropati SINAP eHonduras, iModeli yoLawulo loMasipala abaManyeneyo eHonduras, iModeli eDityanisiweyo yoLawulo lweCadastre - iRegistry eNicaragua, iNkqubo yoLawulo lweTerritory SAT eColombia. . Umhleli weblogi yolwazi lwe-Geofumadas ukususela kwi-2007 kunye nomdali we-AulaGEO Academy equka izifundo ezingaphezu kwe-100 kwi-GIS - CAD - BIM - Digital Twins izihloko.

Amanqaku Afana

22 Comments

  1. Sele ndiyikhuphele itemplate, ndiza kuyifunda kwaye ndiza kubhala nayiphi na imibuzo okanye uhlengahlengiso. Enkosi g '

  2. Andiboni ikhonkco ukwenza inkokhelo ngokudluliselwa kwebhanki. Ndivela e-El Salvador. Ndiyabonga

  3. Ndandifuna ukuthenga ithemplate kodwa andinayo ikhadi njengami

  4. Khangela, uqinisekile ukuba ubeka iqhosha elichazayo. Lo ngumzekelo:
    D: obrasalc

  5. Landa ifayile ye-Excel, kwaye ndinzima ukulayisha iifoto kwidisk disk D: / obras / alc, nceda undithumele ingcaciso njengoko ndiyakwazi ukulayisha iifoto ezivela kule dilesi.
    Ngaba kuyimfuneko ukuba iifoto zibe nobukhulu abathile? okanye ungasebenzisana ne-4 photos mb

  6. Ewe, ngokwenene unokufumana iindlela zendawo kwikhompyutha okanye kwinethiwekhi

  7. Kucinganiselwa ukuba kunokwenzeka ukufunda imifanekiso egcinwe kwindawo yePP okanye usebenzisa ii-network drives. Ndiyabonga

  8. Ngaba le sicelo ingafunda imifanekiso egcinwe endaweni ngaphandle kokusebenzisa i-URL?

  9. Sawubona, ndinomdla ekuthengeni iikhomplathi zakho. Ndivela ePeru, kodwa xa ndikunika kwikhonkco yokudlulisa i-akhawunti yebhanki, andifumananga nantoni na.

  10. Sizisola ngesiganeko, kodwa sele sisisombululo kwaye inkqubo yokuhlawula isele inikwe amandla.

    Ukubulisa

  11. Ndingathanda ukuhlawula ezininzi zezityalo ezilapha kwaye andinako

  12. Ewe.
    I-macro ayinayo ikona yokukhusela, ngoko ingatshintshwa.

  13. Ukukhuphela kubandakanya ukukwazi ukuguqula ifayile yomthombo okanye i-macro ebalulekileyo yale program ekugqibeleni.

  14. Akusilo ukuhluleka kwedatha, kukuthi umfanekiso weGoogle uchithekile

  15. Ewe, i-datum enayo kwiGoogle Earth yiWGS84.
    Ngaba ufumene isizathu sokwehluleka kwedatha yam?

  16. Bathumele kwiofisi yokuposa ukuze babone. Ndithumele itafile ku-Excel kunye nefayile ye-kml eyenza. editor@geofumadas.com

    Khangela ukuba usebenzisa iDatum, i-Google Earth isebenzisa i-UTM WGS84.

  17. Enkosi ngesantya kwisisombululo esisebenzayo. Nangona kunjalo, xa ndiqhuba ifayile ye "kml" ngeGoogle Earth, phantse akukho nanye yamanqaku alungelelanisayo avelayo kwaye bambalwa kuphela ababonwayo, phantse isoloko ingowoku-1 nowokugqibela kolu thotho, kodwa kude kakhulu noko kuhambelanayo (100 Kms. pe ) . Ndidikwe kukwenza itests akhonto. Ngaba ndingakuthumela ifayile enedatha elayishiweyo kwenye i-imeyile? Ngoko ubuya kubona ukuba kwenzeka ntoni. Enkosi,

  18. Le ngxaki eyaziwayo, njengoko kubhaliwe ngasentla.
    Shintsha indlela, ubeka ifayile ngqo kwi C: kwaye loo nto ayivunyelwe yi-Windows ukumiswa. Sebenzisa enye indlela uze uqinisekise ukuba ikhona.

  19. Iprogram ibonakala inkulu kum kwaye ininzi indleko yokuyifumana.
    Ndiyifumene nentlawulo ye-2 $ kodwa kuvela ukuba xa ndiyifeza ayisebenzi kwaye isixwayiso siphumela sathi:
    “Impazamo yexesha lokusebenza '75' yenzekile.
    Indlela okanye impazamo yofikelelo lwefayile”
    Ndiya kuqonda ukuba unako ukumxelela indlela yokuyicombulula okanye ukuba ungithumelele enye ifayile ye-Excel, ngokukhawuleza, ngenxa yokuba kufuneka ndilungise umsebenzi wokumelwa kwamanqaku asekuhlaleni kwaye ndiphulile.
    Regards,

  20. Kuxhomekeke ekuhambeni.

    Ukuba uphumekile kwiimitha ezimbalwa (i-10 ukuya kwi-15 metres) kuba imifanekiso yeGoogle iyafuduka, unokubona ukutshintsha umfanekiso kuminyaka edlulileyo kwaye uya kubona ukuba i-georeference imbi kakhulu. Nangona ulungelelaniso luchanekileyo.

    Ukuba ukufuduka kubanzi, kubakho ukuba zilungelelaniswa kwenye i-Datum. I-Google isebenzisa iWGS84.

    Ukuba izilungelelaniso ziwela kwenye indawo yeplanethi, mhlawumbi ukuba ungena ngaphaya kwebala nobude. Okanye awusebenzisi umqondiso: Kwi-western hemisphere ubude abubi, kwi-southern hemisphere i-latitude ayibi.

  21. Igalelo elilungileyo kakhulu kuphela ukuba uyaqaphela ukuba xa ndibeka indawo yam yokudibanisa ayibonisi ngqo ukuba iphi ... kutheni ucinga ukuba iya kuba?

Shiya amazwana

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.

Buyela phezulu kwiqhosha