Dala izinkomba bhokisi amabanga kusuka UTM izixhumanisi

Lokhu okuthunyelwe kusabela ku-Diego, eParaguay osenza umbuzo olandelayo:

Sakujabulela nimbingelele ... esikhathini esithile esidlule usesho ababeze ngephutha zokufuna kuwebhusayithi yakho ngiyitholile umnandi kakhulu, kokubili ukujabulisa Ran njengoba indlela ukuxhumana ciencia.Yo yakho ukukubuza uma wazi ezinye isikripthi, noma ifreyimu abanye Excel ukungisiza ngenza lokhu okulandelayo: Ngiye ngafaka i-CAD i-polygon ngamaphuzu ayo okubonakala kahle, futhi nge-UTM ehambelana nayo. Angikwazi kahle ukuthekelisa ukuba txt ukufunda okukhulunywa excel.Mi: kokwazi UTM idatha 1 ... N amaphuzu, kungenzeka ukuthola idatha zonyaka, izinkomba kanye amabanga okungukuthi ukuthi kusukela Imininingwane engiwenzela? , iphuzu i-1 ine-X ... ye-And ..., futhi uyazi ukuthi iphuzu i-2 ine-X ... Futhi ...; INGABE Ungangitshela ukuthi i-DISTANCE EYAFANELE KANYE NABASEBENZI BAKHO? Ukuze ukwazi ukwenza ishidi elihambelanayo ngokuzenzekelayo, ngiyabonga ... ubuhle obuvela eParaguay!

Kulungile ukuthi yini uGeorge ayifunayo isuka UTM iqondisa ukhiqize isithombe sezinkomba nokuhamba ... futhi njengoba ngiqedile iVeki Elingcwele, lapho ngidlile ikhekhe lezinhlanzi, i-torrejas inyosi futhi ngithathe izithombe ezinhle zama-sawdust emaphepheni ... nansi impendulo. Okokuqala, ake siqaphele ukuthi indlela engcono kakhulu yokwenza lokhu inethuluzi elilungile (Lingaba ne Vba macro of Microstation, nge I-Softdesk noma i-AutoCAD Civil 3D) kodwa ngezinhloso zokufunda, nokuqonda ukuthi empilweni okufanele usebenzise lokho onakho, ake sibone ukuthi singayenza kanjani nge-Excel.

I-1. Yakha amaphuzu

U-Diego usitshela ukuthi unendlela yokuthumela amaphuzu efonini ye-txt, ukuyivula ne-Excel, ngakho-ke kimi ngizokwenza nge-Microstation. Ngenxa yokuthi ngifuna ukuthumela idatha ku-Excel, ngizobeka amaphuzu ku-vertex ngayinye. Ukuze kubonakale, ngishintshe ubukhulu bomugqa, futhi kubalulekile ukuqonda ukuthi i-Microstation izoyithumela efayeleni le-txt ngendlela edalwe ngayo, ngakho-ke kubalulekile ukuyidala ngokulandelanayo.

amaphuzu we-microstation ukuze aphumelele

Ukuwathumela kwa-Excel, kusetshenziswa ithuluzi "lokuhambisa okuxhumanisa", ngakha "uthango" oluhlanganisa wonke amaphuzu futhi ngilungiselela idatha:

  • Ngibela igama lefayela le-txt njenge-test444.txt
  • Ngikhombisa ukuthi umyalelo ongithandayo ngingu-XYZ
  • Uhlobo lwamayunithi kusuka "kumayunithi amakhulu" kumamitha
  • Ngikhombisa ukuthi ngifuna kuphela iziqu ezimbili
  • Khona-ke ukwahlukanisa ngama-commas kanye nokubalwa kusuka ku-1

Ngokuchofoza inkinobho "kocingo" bese uchofoza esikrinini, uhlelo ludala ifayela le-txt futhi lenze inombolo ngephuzu ngalinye, ukusuka ku-1 kuye ku-36.

i-microstation ikhomba ku-txt

I-2. Vula ithebula kusuka ku-ExcelI-txt exel microstation

Ukuvula leli fayela kusuka kwa-Excel, "ifayela / elivulekile" kwenziwa futhi uhlobo lwamafayela "ifayela lombhalo, .prn .csv .txt" luyakhethwa. Bese kuthi kuphaneli elivelayo, kukhethwe ukuthi umbhalo uhlukaniswe ngamakhoma. Ekugcineni ifayili selivuliwe ngamakholomu amathathu, kokuqala kukhona izinombolo zamaphoyinti, kwesibili i-X ixhumanisa bese elesithathu ukuxhumanisa.

I-3. Bala ibangai-trigonometry kakhulu

Ake sibuyele emithethweni eyisisekelo ye-trigonometry kuqala. Khumbula ukuthi sibheke ibanga kanye ne-angle.

a umehluko uhlela = Y (isusiwe ngokukhipha x2 - x1) e Mb = ikholomu umehluko uhlela X (isusiwe ngokukhipha y2 - y1) e Lc = hypotenuse ikholomu impande skwele square b ngaphezulu sikwele, kukholomu P nalokhu kuyoba inani lebanga.

hypotenuse trigonometry

I-4. Ukubala kwe-Course

Manje, ngenxa yenkambo sidinga ukwenza izibalo eziningana; kodwa zonke zivela engxenyeni emkhatsini wesiteshi kanye nokulandelana.sine cosine kakhulu Ukubalwa kwe-angle. Khumbula ukuthi i i-cosine I-engeli ilingana nokuhlukanisa b phakathi kwe c, okungukuthi, i-delta x phakathi kwebanga elibalwe njenge-hypotenuse.

Ngakho-ke kwenziwa kuphela ku-Excel ngokuhlukanisa ikholomu L phakathi kwekholomu P. Senza futhi isibalo se- webele, okuzohlukanisa i-Delta Y phakathi kwe-hypotenuse (M phakathi kweP). Manje for bala inani, sisebenzisa kuphela i-cosine engenayo kukholomu equkethe yona futhi kusukela i-Excel isebenzisa ama-radians, sandisa inani nge-180 futhi sihlukanisa PI; ifomula izobukeka kanje: = ACOS (ikholomu R) * 180 / PI ().

Manje ukubala I-East / West orientation Sabeka umbandela: wokuthi uma i-cosine inesimo esihle, bhala u-E, uma umkhathazi ungamampunge, bhala uW. Ifomula libukeka kanjena: = YEBO (R2 <0, XNUMX W », E E)… likukholamu T Ukubala Ukuqondisa eNyakatho / South, sinikeza isimo esifana naleso esedlule, kodwa ngesifuba; okusho ukuthi, uma umunxa unoshukela, bhala u-N, uma kukubi, bhala u-S bese ifomula lizoba kanjena: = YI (R2 <0, »W», E E)… kukholamu U

Manje khumbulani ukuthi engela ngenhla ibalwa kusukela ovundlile, empumalanga esikudingayo imayelana enyakatho noma eningizimu. Ngakho uma NW futhi SW quadrant idili ukuthatha 90 degrees, ngakho esikwenzayo ukudala isimo ukuthi uma cosine alivumi, wena khipha 90 kanye NE quadrant kanti thina wahlanganyela Khupha 90 lokususa i-engeli ... kuyinto kukholomu V

ehola ukubalwa

Ikholomu V ikhombisa i-engeli, kodwa ifomethi yedesimali. Ukuguqula ama-decimals kuya kumadigri, imizuzu nemizuzwana lokho esikwenzayo kuyayinqamula nge-zero decimals, njengoba kukholomu W. balala imizuzu, sisusa amadigri aphelele ngaphandle kwediguncated futhi siwaphindise ngo-60. Khona-ke sibagxilisa ngezinhla zero njengoba kubonakala kukholomu Y. Uma kwenzeka imizuzwana, susa amaminithi ngaphandle kwamaminithi amathathu, futhi wande nge-60. Ekugcineni imizuzwana zitholakala uncishisiwe ukuba idesimali ezimbili ... iso uma izixhumanisi UTM eyayisetshenziswa babengenazo izindawo engaphezu kwemibili idesimali, ukubaluleka idesimali wale mithandazo ngeke olunembile kakhulu, ngakho-ke bekungeke kube kungcono ishiyelwe a ledesimali.

I-5. Ukudala izikhombisi-ndlela kanye neshadi elide

Izinkathi zonyaka

izikhombisi-ndlela nokudeKulokhu ngisebenzise ifomula eyenziwe concatenated, ngakho-ke ngengeza iseli elinenombolo 1, bese isikhala se-hyphen space, bese iseli elinenombolo 2; ngisele ngale ndlela yeziteshi «1 - 2»

Ibanga. Lezi zivela kukholomu ye-hypotenuse.degrees imizuzu nemizuzwana

Inkambo. Lokhu kuphela kudinga abalethe ebalwa amakholomu ukubaluleka ngaphambilini ibalwa, futhi ukwengeza uphawu cell grade, ngomzuzu noma lesibili kudalwa izindawo cell njengoba kukhonjisiwe esithombeni. Ukwengeza ngifake ikholomu yokubheka, ngoba ekuhloleni kwezinto ezibonakalayo ngokuvamile kuyadingeka. Kusuka lapha ungalanda ifayela ngefomethi DWG, ngesakhiwo DGN, ifayela le-Excel kanye nefayela txt.

Ngakho lokho Nayi ifayela ku-Excel lapho ungakha khona izifundo zokuhamba nezindawo ezihamba ngokulandelana kwe-UTM. Ukwengeza amaphuzu, ungakwazi ukukopisha amakholomu bese uwafaka, kungcono ukuthi uqinisekisa kanjani amafomula, ufuna ukuhlonipha umugqa wokuqala nowokugcina. Kumele futhi ukopishe idatha yephuzu lokuqala ekupheleni kokuqala, ukuze isiteshi sokugcina sibalwa futhi.

Lapha ungalanda ithempulethi ukuze udale ibhokisi lama-bearings nama-distances ukusuka ku-UTM izixhumanisi.

SebenzisaKudinga umnikelo ongokomfanekiso wokulanda, ongayenza I-PayPal noma ikhadi lesikweletu.

Kuyinto engokomfanekiso uma umuntu ecabanga ukuthi isevisi iyinikeza futhi kulula kangakanani ukuthi itholakale.


Funda ukuthi ungenza kanjani lezi ezinye izifanekiso ku Inkambo yokukopela ye-Excel-CAD-GIS.


Izimpendulo ze-41 "Yakha inkambo yezintambo nama-distances ukusuka ku-UTM izixhumanisi"

  1. Kukhona ithuluzi okuthiwa Calculo_Topográfico.exe, wena automates inqubo ukuguqulela UTM izixhumanisi isipredishithi, kuhlanganise nama-engeli, amabombo kanye amabanga, kanye namanye amathuluzi awusizo ezifana ukuthola iphutha cishe inhlolovo, noma empumalanga noma engela amabanga, kunciphisa a ipholigoni endaweni ezazifunwa ukulungisa uhlangothi noma engela, ekahle ukucekwa kwabantu, futhi ikakhulukazi udala umdwebo ku-AutoCAD, okukuvumela ukuba ukukopisha nokunamathisela (noma) pilot (s) ngemapholigoni nge ukuthi usebenza; futhi-ke ithumela kwamanye amazwe idatha Luhlela iziteshi Imininingwane, ukuze ulayishe (noma ukulanda) ulwazi.

  2. Ithempulethi enhle kakhulu, ngenze i-macro ngokuqondile ku-Microstation eyenza okufanayo kimi futhi ngiyithumela efayeleni le-txt.

  3. Nginelisekile ngempela futhi ngasikhathi sinye ngiyaxolisa kakhulu ngokungakwazi ukulanda uhlelo lokusebenza, ngoba angikwazi ukwenza umnikelo ongokomfanekiso, ngoba angikhiqiza okwamanje? emsebenzini wami njengomcwaningi futhi ngobuqotho nginesithakazelo kulowo lwazi ukukhulisa nokuqinisa umsebenzi wami, uma ungenza umusa ukuwuthumela kimi ngizokubonga kakhulu
    I-Samana Dominican Republic

  4. Hlola i-imeyili yakho, ngogaxekile.
    Isixhumanisi sokulayishwa singahamba lapho.

    Phendula ngokucaphuna

  5. Kuhle kakhulu, kuyasiza !! kodwa ngenza umnikelo futhi isifanekiso asilayishiwe ..
    Phendula ngokucaphuna

  6. Sawubona ntambama enhle uzoba nayo i-athikili noma izibonelo zokubalwa kwento esikalini? lokho ukusetshenziswa nokubaluleka, imikhonzo evela eMexico

  7. Kuhle kakhulu, ngalolu mhlahlandlela ngakwazi ukuthuthukisa ishidi elivelele elibala izinkombandlela, ngiyabonga ngokukwabelana ngolwazi olubalulekile.

    Ukubingelela okuvela eNicaragua

  8. Sawubona, ungubani? Ngithemba kahle, ngifuna ukubona ukuthi ngingekubambe kungasiza njengoba ukuthola oh ukudweba amabanga phakathi kwezindawo ezimbili futhi izifundo zabo izixhumanisi oh kunalokho nge zindawo futhi longitudes ngoba engingazenza coordendas UTM xy nalelo nami awanandaba kodwa angikwazi ukukwenza Lolu hlobo oluthile lwezixhumanisi eziboniswa kumamephu e-Google emhlabeni.
    Ukubingelela .. Ngithemba impendulo yakho uma kungenzeka.

  9. Bangani, ngifunda imibuzo yakho mayelana nokubalwa kwe-topographic, isizukulwane "samatafula" wokuxhumanisa kanye nokulebula kwezikhombisi namabanga e-Autocad, ngincoma ukusebenzisa ithuluzi le-CIVILCAD, elakhiwe eMexico, le module yenza i-autocad ibe yithuluzi lezibalo ze-topographic, amaphrofayili , izigaba, ama-contours, njll, njll.
    Ngokuphathelene nemibuzo yakho ye-UTM eyisicaba, zonke izinhlelo zenqubo ye-GPS (izixazululo ze-GNSS zabathengisi, izixazululo ze-Ashtech ze-Promark 2, Ihhovisi Lokuhlola I-Spectra Precision le-GPS Epoch 10 no-50, njll.) Zinezindlela zokuguqulwa phakathi kwezinhlelo ze- ukuxhumanisa, konke abakudingayo kungukuhlela okukodwa noma ngaphezulu ku-UTM nakuzixhumanisi ze- "flat" (okungukuthi, izixhumanisi abafisa ukuzisebenzisa nesiteshi esiphelele) futhi nezinhlelo zizokubala izilinganiso zezinto nolwazi oludingekayo badinga, funda nje imanuwali ehambisanayo yemishini yabo bese uhlela kahle ukuqoqwa kwedatha. Sanibonani baseMexico City. I-imeyili yami ithi gilberto1@sitg.com.mx.

  10. Kungadingeka ukwenza ushintsho etafuleni, kodwa kungenzeka kahle. Uma usithumela isibonelo singazama.

  11. Umnikelo omuhle kakhulu. Sengivele itafula lami selilungile. Ngifisa ukwazi ukuthi kungangisiza yini ukuthola ama-engeli wokuphamba ngedatha esevele itholakala kulethebula elifanayo. Ngiyabonga !!

  12. UProfesa, kanye nenqubo eguqukayo?
    Kusukela ekuqondisweni kuya ezixhumaniswaneni zendawo?
    Muchas Gracias

  13. Uqinisile, kwenzeka ukuthi i-bandwidth ye-eofumadas.com, nokuyilapho amafayela nezithombe ezivela kule bhulogi zisingathiwe, zedlulwa. Kuzofanele ngiphakamise ububanzi, ngizame futhi emuva kwesikhathi.

  14. Kuthiwani, zama ukulanda ifayela elidumile kodwa ngimake engatholakali, ngingasiza ngalokhu.

    imikhonzo

  15. Kumele ube ocacile ngokwengeziwe kulokho okushoyo ngezixhumanisi zendawo.

    Ingabe usebenze ukusho i-geographic kanye namadigri, imizuzu, imizuzwana? Ngalokho ungawasebenzisa leli thuluzi.

    Uma ungazange usho lokho, ake sibone ukuthi usinikeza isibonelo ukukusiza.

  16. Nginakho ukuqondisa i-UTM njengoba ngenza ukuze ngiyinciphise kubambiswano bezobuciko.

  17. Ukufundiswa kakhulu ukuthi wena ukubala indawo AutoCAD, okuyinto ufuna hhayi kuphela ukubala indawo kodwa uqinisekise Ukuvalwa, mhlawumbe kukhona abanye isifanekiso owenza okufunayo kodwa abazi.

  18. Ikhasi lihle kakhulu. Ngingathanda ukwazi ukuthi ngingabala kanjani (ku-Excel) indawo evela ku-polygon eyenziwe kusukela ekulayisheni izinhlangothi nezintambo ezitholakale ensimini. Ngingumqashi futhi ngisebenzisa uhlelo lwe-Autocad, ngilubandakanya namatafula e-Excel.
    Ngiyazisa kakhulu isithakazelo sakho ekuphenduleni umbuzo wami
    Imikhonzo ye-Cordial evela e-Asuncion del Paraguay
    Mabel

  19. Ngicabanga ukuthi udida inqubo, uma ungenazo izixhumanisi ze-utm, akufanele uzibhekele. Kufanele uhumushe okushiwo umdwebo wakho wokwethula, kukhona iphuzu lokuqala, uma lingasho ukuthi lixhumanise ukubeka kuphi, bese ubona ukuthi kukhona inkambo nebanga lokuya ephuzwini elilandelayo.

  20. I-Maestro Alvarez, leli fayela libala izixhumanisi ze-UTM kusuka esigabeni esiphambene esikhuliswe nge-traffic futhi izinga liyamangalisa kodwa angisakwazi ukukuqonda

  21. Bheka umngane wasePeru ungithumelele isifanekiso ngombuto kodwa angiqondi ukuthi u-UTM ubeke ekuqaleni ekuqaleni kwePI ngayinye, njengoba okunamathiselwe kwefayela

  22. Sawubona Jcp, ngiyaqonda ukuthi unomugqa ophakathi nendawo, kanye neziteshi kanye nesiteshi ngasinye kukhona okuphambili kwesokudla nakwesobunxele. Ngicabanga ukuthi into efaneleke kakhulu ukuthi ungazami ukuxhumanisa i-utm, kepha wenze imibuthano esuka enkabeni, ubeka iphoyinti ekuxhumaneni kombuthano kanye nomugqa.

    lokhu kungakwenza wenze okufanayo nalokhu kusebenza

    http://geofumadas.com/construir-curvas-de-nivel-usando-autocad/

    Khona-ke, ukuze ungeze iziphakamiso, hlela isimo sephoyinti lapho unganika khona ukuphakama uma ufaka.

  23. UMnu Sawubona Alvarez ngisebenzisa civil 3d 2009, UTM entry amaphuzu ngefomethi .csv kodwa senginezinsuku ukuguqula izigaba engu- eyakhiwe zokuhamba kanye UTM ezingeni Excel, ngiba-eksisi kuchazwa futhi kuyaqala yami iphuzu 0 000 + yamthola GPS geotagging ... ukuze ukubala amaphuzu njengoba PI of kushaft yami izingxenye UTM

    Ngivela kuHonduras

    jcpescotosb@hotmail.com

  24. Eqinisweni, ngivele nginezixhumanisi ku-intm, kodwa ngifuna ukunciphisa ezindiza yezokwelapha ukuze ngizisebenze ensimini

  25. Bheka, angizange ngiyisebenzise leyo Promark kodwa ngiyabona ukuthi ibheka okuningi njengeMap Map Map njalo kusuka eThales.

    Kulokhu ngakwenza kanje:

    1. Cindezela inkinobho ethi «MENU»
    2. Khetha «amayunithi wemephu»
    3. Khetha «Ukudidiyela uhlelo» bese ukhetha i-UTM
    4. Khetha «i-Datum» bese ukhombisa i-WGS84

  26. zincane, ziwuphawu lwe-2, edolobheni lase-Mexico elingu-14, ngizokwazisa noma yiluphi ulwazi onganginika lona.

  27. ... ahem, ahem ... 🙂

    Futhi hlobo luni lwegps, brand kanye nomodeli abasebenzisa?
    Kukuphi izwe kanye nendawo okuyiyo?

  28. alvarez othandekayo, ngaphezu kwakho konke ukubingelela, ngaqaphela ukuthi ulwazi lwakho sendawo kanye ne-software isihambile, ngingase ngikwazi ukusiza, inkampani Ngisebenzela, uphathe i-GPS, futhi ngifuna bazi ukuthi mina ulungise izixhumanisi UTM izixhumanisi kwendawo O Planas, ukuphathwa ensimini, uye wabheka ukwaziswa okuningi mayelana futhi ngizwe impendulo yakho.

  29. Pablo, ukuhlola kwakho kulungile, sengivele ngenzile ukulungiswa kokubhala, kuyikholomu L phakathi kwekholomu P

    enye inkinga oyibekayo, ngicabanga ukuthi awuqedile ukuphawula ukuze ukwazi ukuyihlaziya

  30. Ngilandela isinyathelo ngesinyathelo. Nginezifundo eziqondakalayo, kodwa ngokwenzayo angikwazi ukufeza imiphumela emihle.
    Mae kubonakala sengathi ngenza okuthile okungalungile. futhi ekucubungulweni kwamayunithi we-Autocad yinxenye yama-angles nesiqondiso angikucaci kahle.
    Ngifuna ukuphakamisa ukuthi ubuyekeze ingxenye yama-angles engicabanga ukuthi kunephutha, lapho lithi "ukuhlukanisa ikholomu N ngekholamu P" ngicabanga ukuthi likholamu L ngekholamu uP.
    Enye iphutha lokubhala livela ekubalweni kweNyakatho / South ukuma, ifomula ithi: kuyoba kanje: = YEBO (R2

  31. Uma usho isakhiwo esilinganisiwe endaweni lapho indawo ishintsha khona ... ngeke ikusebenze.

    Uma ngabe usho ukuthi labo baxhumanisi bakwesinye isizinda se-utm, akufanele kube noshintsho ngoba kufanele ukuthi ukhulume ngobubanzi obufanayo, ngakho izixhumanisi ziyafana

  32. Sawubona,

    Ngithande lokhu ngokwezifiso ngokuhle, nginombuzo

    Isebenza kanjani uma kukhona ushintsho lwe-spindle?

    Gracias

    Juan

  33. mmm, ngithumelele iskripthi esivela kuwe e-mail ukuthi unayo, ukuyibukeza.

    Ngizobona ukuthi yini lapho

  34. akunakwenzeka! Manje iya ku-100%, ngiyisebenzise futhi kuyiqiniso! ngiyabonga emuva kakhulu, kuye kwaba usizo kimi.

    Umbuzo ngakho, njengoba sikunqubo ezenzakalelayo. Kusetshenziswa i-AutoCAD, ukuba ne-polyo-referenced ye-geo-track eyalandelwa, ngama-vertices ayo aziwayo e-UTM, engikudingayo kungumaka wezinxenye, ukuze kuthi lapho ngichofoza kuwo ngibanikeze ilebuli yabo ehambisanayo, ngokwesibonelo: 176.35

  35. ngomumo, sengivele ngilayishe inguqulo ye-2 yefayela elihamba phambili. Isizathu ukuthi e-NE nase-SE quadrants, i-angle eya ku-90 bekufanele isuswe.

    Zama futhi ungitshele lutho.

    Kumele ucacile, ukuthi izinhlawulo ezengeziwe ezisetshenziselwa ukuqondisa kwe-UTM, izoguqula ukuhlaziywa kwemizuzwana.

  36. mmm, uqinisile, ngicabanga ukuthi ngiyakwazi ukuyixazulula

    Ngizoyihlola uma ngibuyela ekhaya

  37. uprofesa othandekayo, okokuqala ngibonga ngempendulo yakho esheshayo, ngiyithola ngempela ngesikhathi!
    Ngiphawule ukuthi kungisize kakhulu, bengikuhlola, yize ngithanda ukuveza ukungabaza / ukusikisela / ukukhathazeka: Ngibala ibanga kahle kakhulu, manje i-angle linginikeza umphelelisi, ngokwesibonelo esikhundleni sokuba yi-88d13'13 », uyanginika 1d21'47 »!!! Kumele kube ulungiso oluncane futhi sesenziwe! Ngiyabonga futhi ngosizo lwakho!

Shiya impendulo

Ikheli lakho le ngeke ishicilelwe.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda ukuthi idatha yakho yokuphawula isetshenziswa kanjani.