Shandura UTM kune Geographic Coordinates ne Excel

Mutsamba yapfuura tave tati tambo re Excel rekuti tishandure hurumende Geographic UTM kubva pane shati iyo Gabriel Ortiz aive achiwedzera.

Ngationei ikozvino chigadziro ichi chinoita zvakafanana nenzira inopesana, kureva, kuva nehurongwa muUTM format (Universal Traverso de Mercator) uye kuziva nzvimbo, kuvashandura kune maitiro uye nzvimbo dzenharaunda.

Ngatitange kuzvidzidzira pachedu neizvi: maererano neGoogle Earth, mitsuwa ye Palace of Sports muDF ichava X = 489513.59, Y = 2,145,667.38 ichifunga kuti Google Earth inoshandisa WGS84 datum. (pane zvausingazivi, kuona UTM inokurudzira iwe chete kuenda kuzvishandiso / zvisarudzo / vista3D / show lat / kure)

mufananidzo

Mune maratidziro enzvimbo, aya angave akareba = -8 ° -5 '-59 ”, lat = 19 ° 24' 18”, (kuratidza giredhi muGoogle Earth, tinya pakanzi "view / grid")

mufananidzo

Ndinokurudzira kuti uzvizive nenzira iyi yekuongorora uye kunzwisisa kuti UTM inoronga sei basa kuti uwane zvakanakisisa kubva pane zvishandiso mu Excel.

Ndakaita iyi peji izvo zvingava zvakakosha kune shamwari iyo imwe nguva yapfuura yaitarisira kutumira kuGoogle Earth mamwe data aive muUTM.

lat long google pasi

1 Nzira yekupinda sei data

Yellow minda vanonhonga xy Coordonatele, uyewo nzvimbo, izvi zvinofanira zvakakwana yokutarisira somuenzaniso Mexico, nzvimbo kubvira 16 21 chete Coordonatele saka unogona kuva munzvimbo dzakasiyana.

lat long google pasi

Izvo zvinoitika nehemisphere, sezvakaitika kuColombia, Ecuador neBrazil iyo ine nzvimbo munzvimbo dzose dziri kumusoro uye kumaodzanyemba hemispheres.

Uyewo kumucheto wepamusoro ndiyo inonzi spheroid inotungamirirwa neUTM, iyi haisi yehutano huripo asi panzvimbo yehutano huripo.

2 Zvabuda zvinoguma

mufananidzo

Iyo mikoko muhomwe ndiyo inoratidzira, hurumende dziri kumabvazuva kweGreenwich meridian ichava yakanaka, iyo iri kumabvazuva kumavirira ichava isina kunaka.

3 Nzira yekuvatumira kuGoogle Earth

Kunyange tisati vaona nzira shoma kutumira munhu Excel ikwidzwe kuna Google Earth nenzvimbo uye UTM, saka tora vatarire, kana uchida kutumira UTM anoona AutoCAD, iyi Excel template inokubvumira kuzviita.

geoutm Downloads

Pano unogona kutora template kuti uchinje hutungamiri hweUTM kusvika kuGographic coordinates.

Unogona kuitenga nayo kadhi rechikwereti.

Icho chinomiririra kana mumwe achifunga nezvekubatsira kwaanoita uye nyore nyore kwaanogona kuwana.


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


107 Mhinduro kune "Shandura ma UTM mapurisa kusvika geographic inosangana neEexcel"

  1. Manheru akanaka,

    Ndangotenga mufananidzo asi hapana chakauya kwandiri. Ungakwanisa here kutarisa kutumirwa kwekuti kwakanaka?

    gracias
    Javier

  2. Nenzira, ini ndichangowana iyi webhusaiti uye ndinofarira. Ndichiri kupotsa kwechinguva pazviri, asi zvinoratidzika zvikuru.

  3. Handikwanisi kuwana kupi yekuzvitora kana ... 🙁 iripi iro tafura inoshamisa iripi ??

  4. Ndinoda kuziva kuti nei ini pandinopinda kune imwe nzvimbo inobatanidza ini ndinotora mhinduro dzakasiyana semuenzaniso

  5. Q purogiramu Windows Vista kana Excel anogona kushandisa uye kukopa kutendeutsa flat anoona enzvimbo kana viseversa, ndinokuvongai pachine wako nzeve ichi.

    Kutendeseka,

    Efrain Peña Borda

  6. Mangwanani akanaka

    Ndinoda kuziva kana ndiine tafura yako ndinogona kutendeuka (kubva kuUTM kusvika ku GEOGRAPHIC) dzakawanda dzinosangana panguva imwe chete. Vakawanda vakaita se1000.

    Ini ndakamirira kupindura kwako nokukurumidza, kuvonga.

  7. Ndine hanya ne tempel yekare yekushandura GTM mazano KUUTM NEMAFOMO
    Ndapota nditumirei nhamba yekambani yekukosha kwema template

  8. Hi, ini ndine spreadsheet yepamusoro kuti ndiende kubva kumadhigirii kusvika kune madigiri, maminitsi, masaminiti.
    Taura iwe neni

  9. Ndinokutendai, ndinoona kuti ndeipi iyo inofanirwa kubhadhara iyo yandinogona nayo.

  10. Sawa, José Luis.
    Hapana chinetso, template ine mazamu uko inotsigira kuti iwe uiise mumutambo wemakumi.
    Kana ukangozvitenga, iwe unosangana nesu uye tichakuudza kuti ungazviita sei.

  11. Mudiwa zvandinoda ndeye kugona kugona kujekesa iwo anoratidzira mu MicroStation V8i, asi HandHeld yangu inovatengera kwandiri mumakore ekupedzisira LAT W89.14298 N13.71391, uye ini ndinofanira kuvashandura kuva XY, iyo yekupfuura template inovakumbira muDegree, maminetsi uye Seconds.
    Ungandibatsira here neizvi? Ndinokutendai

  12. Kutanga, ndinokutendai nokuda kwekufarira kwenyu.
    Tarisa zvauri kutsvaga, sezvo template ino inotendeuka kubva kuUTM kuenda kune imwe nzvimbo asi kune mamwe mawaturo anonyatsoita kuita zvaunoda.

    Onai mune izvi humwe humwe hutemberi huripo.
    http://geofumadas.com/descargas-utiles/

  13. MUBVUNZO UNOGONA KUFANIRA KUDZIDZA KUNA KUTI KUDZIDZA KUDZIDZA KUNYANYA KUNYANYA NOKUDZIDZA KUTI UNOGONA KUVA.

  14. Iwe unogona kushandisa spreadsheet kuti uchinje nharaunda dzenharaunda
    UTM inoronga uye se

  15. Ndingaita sei kuti ndidzoke hutungamiri hweUTM kune geographic coordinates?

  16. Zvakanaka, template inoshanda pasina zvinetso

    Kana iwe uchitisiya isu muenzaniso, tinogona kuongorora.
    Ndeapi marongero awakapinda, nzvimbo ipi, mhedzisiro yaunoburitsa, nyika yauri iwe uye tinotarisa kuti toona zvinoitika. Usave nyaya yekuparadzanisa nomenclature yezviuru kana decimals.

  17. Hi, ndakatenga spreadsheet, ndinoisa hurumende kuti ndivashandure asi vakandituma kunze kwekondinendi. Zvingave kuti ndezvenharaunda, mune fomu iyi inoisa nzvimbo 15, yeChile iyo inofanira kuisa nzvimbo ipi?

  18. Hi, ini ndinoda kutendeudza hutungamiri mune zvidzidzo zvemashumi kusvika kuhutano mumadhigiri, maminitsi nemasekondi.

  19. Chokwadi kurongeka kwako Uye kwakaipa, nekuti latitude inotangira muEcuador uye painosvika El Salvador iri huwandu hunopfuura miriyoni imwe. Tarisa uone nekuti zviri pachena kuti pane dambudziko.

  20. Ndiko kuti munyika muno kusiyana kwehurefu mumadhigiri kunosiyana pakati pe87 ° ne89 ° uye kureba kuri pakati pe13 ° kusvika 14 ° inyika yeCentral America

  21. Hongu asi isu taisaziva chekutaura. Unoziva sei kuti inofanira kupa?
    Ndeupi Dhemusi wawakashandisa?

    Nyora pano hurumende mumamita, uye isu tichaedza vatendeuki vedu kuti tione kana iwe usina hanya.

  22. tarisa, shandisa chinogadzirisa chinoshandurwa kubva kumamita kusvika madhigirii uye mhedzisiro ini yandinofanira kupa iri 89 ° yakareba uye 13 ° latitude, asi yakandipa 89 ° uye 2 ° latitude shandisa 16 zone uye kuchamhembe kwakadziva kumadokero hemisphere ndinoda kuziva zvazvinoita

  23. pane google mwoyo vhezheni inobvuma kuisa mapepa neUTM kuronga ndeye 6.2.1.6014 (beta)

  24. Iwe unonyorera pahukama hunoti:

    Pano iwe unogona kutora

    Kana pane bhatani rinoti "tenga izvozvi"

  25. Handigoni kuwana nzira yekuendesa madhora e2 uye ini ndinoda kutora iyo inogadzirisa fomu yevashanduri nokukurumidza.

  26. Ok uye pane chero mukana wekuwana mepu yeVenezuela iyo inondiudza kubva kune iyo nzvimbo iyo spindles kana nzvimbo dzinowanikwa?

  27. Hi, ndine zvinganetseka. iyo mihizha yeUTM iyo yakafanana REGVEN? ndechokuti ndinofanira kuziva nzvimbo iyo Venezuela yakakamurwa nayo, iwe unogona kundibatsira nezvo zvinofadza here?

  28. Mune zvimwe zviitiko zvinogona kuitika kuti kudhanilodha kunomira, kana kuti iyo Proxi kubva kwauri kubatanidza inovhara kurodha. Nekudaro, kana izvi zvikaitika, iwe unogona kuzvizivisa netsamba.

    Takatumira template ku email yako.

    Kwaziso.

  29. Haikwanisi, Google Earth haigamuchire kurongedza kuisirwa muUMF fomu. Chinhu chinonyanya kushanda ndechekuti unozviita neiyo GIS chirongwa senge Microstation, gvSIG kana QGis, wozozvitumira ku kml kuti uzvione muGoogle Earth.

  30. Hi, tarisai, ini ndiri kufarira munharaunda. Ndinoda kuziva kuti ndinopinza sei hutano hwangu utm kuenda kuGoogle pasi kare.

  31. Mhoro Miguel. Nezve mubvunzo wako:
    -Iyo inoronga iyo Google Earth inoratidza uye avo vaunoreva kwavari ndevaya vanozivikanwa seUTM. Iyi sistimu inogovera makondinendi munzvimbo dze60 dzinoenda kubva padanda kuenda padanda, 6 degrees refu imwe neimwe. Munzvimbo yekuMabvazuva, dunhu rega rega rine 500,000 seyakakadzika samidhiya uye nekudaro rinowedzera kana kuderera kudzamara rasvika pamuganho wenzvimbo, nekudaro East yekubatanidza inodzokororwa munharaunda yega yega, asi haina kumbobvira yakaipa. Mupfungwa yekuchamhembe, inotangira pa zero kubva ku equator, yakananga padanda rekuchamhembe uye kumaodzanyemba hemisphere inotangira padanda kusvika yasvika ku equator.

    Iyi sistimu inokonzeresa kunetseka kune nyika dzinobatanidzwa munzvimbo dzinopfuura imwe chete, muColombia iri pakati penzvimbo dze17, 18 uye 19. Uyezve, ine peculiarity yekuve nechikamu muchikamu chekumusoro hemisphere uye imwe kumaodzanyemba hemisphere.
    Saka nyika inosarudza kusarudza mhedzisiro yenhema, kuderedza kuoma kweizvi, uye ndicho chikonzero hazvikwanisi kuti hurumende dzienderane neaya inoratidzwa neGoogle Earth.
    Kuita shanduko, Geographic Institutes ine ruzivo rwakadai seizvi:

    http://www.unalmed.edu.co/~janaya/clase3/cambio_coord_datum.htm

    Iwe unogonawo kutarisa pazvibatanidza izvi:

    http://www.unalmed.edu.co/~janaya/clase3/clase3.htm
    http://geofumadas.com/entendiendo-la-proyeccin-utm/

  32. Mangwanani akanaka.

    Painopinda peji yewebhu, nokuti ndanga nditsvaga ruzivo rwemasangano iyo ini mashoko pasi apa:

    Mepu yeColombia yakagadzirirwa neGGAC (Instituto Geografico Agustin Codazzi), mapuratiro emepu yakataurwa ichinyatsoenderana nemiganhu yeGoogle Earth mepu:

    Somuenzaniso, mepu Coordonatele pamusoro Colombia, kuwana chinhu chaipo chete kumaodzanyemba Puerto Wilches 1021223E, 1302614N Coordonatele idzi asingakwanisi kuwana map Google Earth, aikwanisa kutsanangura musiyano uyu?
    Pamusoro pezvo, senge nyaya yekuda kuziva, inotora kubva kuGoogle Earth mepu, zvakanyanya mudhipatimendi reNariño zvinoonekwa kuti marongero ayo anobva kuWest kuenda kuEast, isu tinotora nyaya yeTumaco, iri mu748650 E, tikaramba tichienderera pamwe takananga Kumabvazuva, zviri kurova kuti kana uchisvika ku833969E uye inochinja nguva pfupi kusvika 166030E. Zvinoitikawo kuti muGoogle Earth kubva equator kuenda kuNorth inotanga mu0.0, zvisinei mu IGAC ine inogadzirisa yayo ku equator.
    Mukupedzisa, shanduko dzingaitwe sei kubva kumakanika e IGAC kuenda kuGoogle Earth?
    Ndinokutendai mberi nekubatsirana kwako kwekukosha mukutsanangura iyi mamiriro ezvinhu akavhiringidza.

  33. kwadzakabva basa Gabriel Ortis Very zvakanaka, ini yaishandiswa Win XP asi ini ufambe kuna W7 uye ndaigona kuramba kurishandisa, rinobatsirawo chaizvo kupedza kunongedzera kml faira kuti anoverenga Google pasi, kana iwe ndipei email ndinotuma kwadzakabva.

    gracias

  34. kana ini ndisina mitsigira ini ndinogonawo kuvashandura kuti utm ???

  35. chinhu chakakura chekuita zvakafanana kuti uchinje UTM inosangana ne geographies

  36. Ini ndakaiyedza pamwe nematanho ekubatanidza eNational Cartography yeVenezuela uye inopa mhedzisiro imwe chete. ndatenda

  37. Sawa,

    Ndinokutendai zvikuru pamubatsiro wenyu.

  38. Vitos, kuti uite kutendeuka kumashure, kana kubva Geographical kuenda kuUTM unogona kutarisa iyi Geofumadas inosangana

  39. Ini ndinoda kushandura iyi data W 14 ° 51 ′ 16.59 »YS 90 ° 51 ′ 50.1

  40. Mupiro mukuru iwoyo, unoshanda wakakwana munenge mamiriro ezvinhu ose, asi uri pamiganhu yenzira. Ndinokutendai zvikuru nekugovana nayo pawebhu.
    A great greeting !!

  41. Kuvonga nekugovera maatafura nevanhu.
    iyo inoshandiswa zvikuru

  42. 1 Giga Ndinokutendai mupiro mukati Blog ino, kupfuura kunaka, clickcidades (wekuvamba informatic Makorokoto !!) aigona kukopa Excel spreadsheet enzvimbo kuti UTM, asi kubatana wakapiwa pano asingagoni, kureva UTM kwavanogara, vamwe chaiwo rinoratidza?. Mazvita.

  43. Icho chinhu chakaisvonaka ...
    kune vanhu vanonyanyisa uye havadi kugovana ruzivo rwavo asi ini ndinoona kuti munopa .. thanks for your tool ...
    enda mberi ..

  44. Ndinofanira georeference mufananidzo BS. Sezvo., Argentina pamwe pfungwa dzakatorwa kubva Google pasi, mumwe anoziva spheroid uye datum kushandisa nzvimbo Google Earth uye Argentina ndiyo? Kuti ndiite georeferencing, Erdas anondibvunza kuti iyo data.
    Muchas gracias

  45. Hi! Mupiro wakanaka chaizvo. Zvisinei, iwe unogona here kundipa nzira yekuita nayo chete nechinotakura?
    gracias

  46. Ndinofunga iwe UTM, kutevedzera Coordonatele iri Excel tafura, zvichiratidza zviri uye uve nenzvimbo sezvo well'll nazvo mune dzimwe nzvimbo, kana zvino chichaitika UTM mune dzimwe nzvimbo iyo nzvimbo, utore kutendeuka hutungamiri hwenyika uye maitiro ekutm, kusarudza imwe nzvimbo.

  47. Hi, ini ndine deta yakatorwa muutm munharaunda ye16 asi ini ndinofanira kuvashandura kunharaunda ye15 kuti ndinozviita sei

    gracias

  48. chaizvo zvakanaka chidobi kwenyu, asi ndinoda kuziva kuti kuita shanduko, asi kwete digitaalinen ndiri Engineering mhuka mudzidzi kugadzirwa stoy kudzidza kuchengetedza ivhu uye mvura, panhau iyi ndinobvunza kuratidza Masvomhu uye kuona kukanganisa pakati izvi Coordonatele maviri, kwete nzira yekuzviita Ungandibatsira here? chinhu chinonyanya kukosha ndechokuverenga mhosho pakati pezvibatanidza zviviri!
    thank you before !!

  49. Iwe unofanira kuona nzvimbo inofanirwa kuGoogle Earth, nokuti muColombia the 17,18 uye 19 nzvimbo dzinowirirana

  50. Hi! Pinda nheyo dzenharaunda dzenharaunda kuti uende nadzo kune dzakapfa asi mhedzisiro yandinowana handiyo yandaitarisira. Ndinoda kuti shanduko yezvikwata muColombia. Ndoshanduko ipi yandinofanira kuita?

  51. hello! Mumwe munhu anoziva nzira yandinoenda nayo kubva kuUTM kusvika kuGeograficas (madigiri) asi mune zviduku, kwete mumaminitsi kana masekondi.

    Pane chimwe chinhu chakakosha chinondibvumira kuita izvi here?

    Ndinokutendai nguva yenyu, uye zvakare zvakare maGeofumadas makuru ..!

  52. Geofumadas naGabriel Ortiz, ndinokutendai nokuda kwekuda kwenyu kubatsira vamwe! kubva kuPeru ndinokukwazisai ..!
    chevere!

  53. BASA ZVAKANAKA UYE ITA Makore mashoko wenyu uye zvakanyanya zvechokwadi vakanaka zvakanaka, ndine dambudziko WITH kuchinja Coordinates UTM kana nenzvimbo ndege, KUTI KUDIWA kurangana IN MUNDA WITH LIVE MATANHO KANA ndege kwakavakirwa BASE Data PFUNGWA mumunda Nokusangana UTM anoona kana nenzvimbo mararamiro PEDYO iratidzwe achangobva ERROR UTM Coordonatele, OJALA anogona kundibatsira

  54. Iwe unogona kundiitira nyasha yekundiwana ESET NOD 32 antivirus, ndinozvifarira.

  55. Pane urongwa hweUTM Flyer, kuti uite kuti vashandurwe muGoogle vakandipa ini, asi zvainge zvatofa, iwe unogona kundibatsira uye ugozvipa kwandiri, kuitira kuti zvirege kupera.

  56. MuNicaragua, tinoshanda mu16 uye 17 Zone, mumwe munhu anogona kundibatsira.

  57. Ndinofanira kuwana chirongwa cheUTM Flyer kuti chifambe kubva kuUTM nhamba yeNAD 27 Central kusvika kuGeografica muGoogle Maps

  58. Ini ndinofunga izvo zvinoreva kuti: Zone 18, x = 338552 y = 9065052 kumaodzanyemba hemisphere. Edza iyo pane iyo template. Iwe uchagara mune dhumamu

  59. NDICHAVANYA RUDZIVA RUDO RANGU KUTI VATSVIKE UTM ZVIRANGO KUTI GEOGRAPHICAL CORDINGS DATA IS AS FOLLOWS:
    WEST LENGTH 18L0338552
    SOUTH UATU UTM 9065052

  60. Ndinokutendai nokundibatsira kuti ndiite basa rangu
    kumavirira kwenguva 18L0338552
    Uthern South UTM 9065052

  61. Ndakagamuchira email kubva kuna Mario Sanchez iyo inotitaurira kuti kuitira kukurumidzira basa rake (ari kudzidza maitiro ekufudza makwai achishandisa GPS-GPRS makorani) akawedzera mutsara yematafura kubva kubva ku decimal kuenda kune zvekuita zvega zvega uye kuti izvi Chigumisiro chacho chinowanikwa zvakananga mune geofumed template inoratidzwa munyaya ino.

    Yakawedzerawo mamwe mazano kuverenga kureba pakati pemakwikwi maviri uye kana iwe une nguva yekutora nhaurirano iwe unowanawo nguva yekufamba.

    Akafunga kuti zvichida zvingabatsira kune mumwe munhu saka akazvitumira uye pano vane faira nemarongwa.

  62. Chengetedza nomenclature iyo Gabriel Ortiz calculator inokumbira

    Nzira dzakarurama dzekutaura:
    434156.35 4804758.33 102.44 (nzvimbo imwe neimwe pamutsara, kutanga ye X uye ipapo Y. Z dzinosarudza.)
    433785.44 4803721.57
    Shandisa nzvimbo isina chinhu kana tabha kuti uparadzanise hutano hwe X uye Y, uye iwe Z.

    Kana iwe uri kuisa iyo comma, izvo zvinokutambudza iwe.

  63. Ndinofanira kushandura X, Y kuratidzira kuhutano hweUTM

    Ini ndapinda iyo data muCARTOGRAPHIC COORD CONVersOR ye «Gabriel Ortiz». asi haisi kukanda iyo data yandinofananidza nayo.

    Pane munhu angandibatsira here?

    Iyo data ndeyotevera: X = 622,552.17 / Y = 2,062,181.26

    Nhamba iyo inofanira kuratidzwa ndeye: N 64 ° 24 '46.02' E

    asi hazvibudi paunopinda mairi.

    IHUSO yandinopinda ndeyo: 15 inobatanidza Campeche, Mex.

    Chii chandiri kuita chisina kunaka?

    Ndinotenda nekuda kwekubatsira mberi.

  64. mutembenukiro akakurumbira uye nzira yakanakisisa yekudzidzisa kune zvakawanda kuonga basa guru iri. Ndinokutendai zvikuru

  65. iyi ndiyo nzira yekudzidzisa. ndapota tumira kune iyi email. Ndinokutendai zvikuru

  66. Izvo zvakanaka kune mudzidzi akafanana neni. iwe Unogona kunditumira here kumutumwa iyi? Ndinokutendai zvikuru uye zvakanakisisa zvidimbu nemidzi dzidziso dzakachenjera.

  67. Anahí,
    Kana iwe ukaisa mu Menu / View / Grid iyo nzvimbo inoonekwa, chero bedzi iwe wakashanda UTM muZvi / Options / 3d View.

  68. Iko basa rakanaka, rinobatsira zvikuru, mubvunzo weBolivia sekuratidzira hutachiona hweUTM huri kurongedza kusiyana kweiyo mu19, 20 uye 21.
    Ndinoda kuti mundibatsire kuwana girafu kuratidzira vadzidzi hurumende munzvimbo imwe neimwe.

  69. Kumbongedza, inonyatsoshanda chigadzirwa uye basa rakanaka.

  70. kutanga vachikorokotedza kuita mabasa akasiyana Quen wechipiri amplitudo kupa ruzivo wako 'vamwe sezvo tisina ruzivo zvikuru kupfuura zvikonzero zvakakwana kuti uende mberi rombo

Leave mhinduro

Your kero e havazobvumirwi ichibudiswa.

Nzvimbo iyi inoshandisa Akismet kuderedza spam. Dzidza kuti sei deta yako inoshandiswa.