Pangani bokosi malangizo ndi kutalika kwa UTM ndondomeko

Cholemba ichi chikuyankha Diego, wochokera ku Paraguay amene amatipanga funso lotsatira:

losavuta moni ... m'mbuyomu kufufuza amene anabwera mwangozi akufuna wanu webusaiti ndipo ndidalipeza chidwi kwambiri, kaya mwawo adathamanga monga momwe kulankhula ciencia.Yo wanu mungakonde kufunsa ngati inu mukudziwa ena script, kapena chimango Excel kuti andithandize kuchita izi: Ndasindikiza mu CAD ndi polygon ndi mfundo zake zowonongeka bwino, komanso ndi UTM zawo zogwirizana. Ine angathe Tumizani kuti ndilembereni kuwerenga mu excel.Mi funso: podziwa UTM deta 1 ... N mfundo, n'zotheka kupeza deta nyengo, mayendedwe ndi kutalika mwachitsanzo kuti ku nkhani ine kupereka? ndi 1 mfundo ali X ... Y ..., ndipo podziwa kuti 2 mfundo ali X ... Y ...; KODI MUDZIFUNA KUTI NDIPONSO ZINTHU ZINTHU ZINTHU ZOONA ZINTHU ZINTHU ZINTHU ZOONA ZINTHU ZINTHU ZOONA ZINTHU ZINTHU ZOONA ZINTHU ZOONA ZINTHU ZINTHU ZOONA ZINTHU ZOONA ZINTHU ZOFUNIKA KWAMBIRI? Kuti muthe kupanga pepala lovomerezeka, ndikuthokozani ... zokoma za Paraguay!

Chabwino, chimene Diego akufuna chikuchokera UTM ikugwirizana kupanga chithunzi cha maulendo ndi maulendo ... ndipo pamene ndatsiriza Sabata Lopatulika, momwe ine ndadya mkate wa nsomba, torrejas mu uchi ndipo ndatenga zithunzi zabwino za ma carpets ya utuchi ... apa pali yankho. Choyamba, tiyeni tizindikire kuti njira yabwino kwambiri yochitira izi ndi chida choyenera (chingakhale ndi Macro Vba ya Microstationndi Softdesk kapena AutoCAD Civil 3D) koma pofuna kuphunzira, ndi kumvetsa kuti m'moyo muyenera kugwiritsa ntchito zomwe muli nazo, tiyeni tiwone momwe tingachitire ndi Excel.

1. Pangani mfundozo

Diego akutiuza kuti ali ndi njira yotumizira mfundozo ku fayilo ya txt, kuti azitsegule ndi Excel, chifukwa chake ndidzazichita kudzera ku Microstation. Chifukwa ndikufuna kutumiza zidziwitso ku Excel, ndiyika mfundo pa vertex iliyonse. Kuti ziwoneke, ndasintha makulidwe amizere, ndipo ndikofunikira kwambiri kumvetsetsa kuti Microstation idzawatumiza ku fayilo ya txt momwe amapangidwira, motero ndikofunikira kuti ipangidwe motsatana.

microstation imasonyeza kuti ikuposa

Kuti muwatumize ku Excel, gwiritsani ntchito chida cha "export coordinates", pangani "mpanda" umene umakwirira mfundo zonse ndikukonzekera deta:

  • Ndipatsa fayilo la txt monga test444.txt
  • Ndinawonetsa kuti dongosolo lomwe limandisangalatsa ndi XYZ
  • Mapangidwe a mayunitsi ochokera ku "ma unit" omwe ali mu mamita
  • Ndikuwonetsa kuti ndikungofuna ziŵili ziwiri
  • Kenaka wolekanitsa comma ndi chiwerengero cha 1

Pogwiritsa ntchito batani "panda" ndikusindikiza pazenera, dongosololi linapanga mafayilo a txt ndipo linapanga nambala pa mfundo iliyonse, kuyambira 1 mpaka 36.

microstation ikuwonetsa txt

2. Tsegulani tebulo kuchokera ku Exceltxt excel microstation

Kuti mutsegule fayiloyi kuchokera ku Excel, dinani "fayilo / open" ndikusankha mtundu wa fayilo "file file, .prn .csv .txt" Kenako pagawo lomwe likuwonekera, sankhani kuti mawuwo asiyanitsidwa ndi makasitomala. Pomaliza fayiloyo yatsegulidwa ndimizati itatu, yoyamba ndi manambala amalo, ndipo yachiwiri ndi yomwe X imagwirizanitsa ndipo yachitatu ndi yowongolera.

3. Chiwerengero cha Mapiritrigonometry kwambiri

Tiyeni tibwerere kumalamulo oyambira a trigonometry poyamba. Kumbukirani kuti tikufuna mtunda ndi ngodya.

ndi masiyanidwe amayang'anira = Y (chikutha ndi Kuchotsera x2 - x1) mu MB = masiyanidwe ndime amayang'anira X (chikutha ndi Kuchotsera y2 - y1) mu LC = hypotenuse mzati ndi muzu lalikulu la lalikulu b zambiri mzere, mu chigawo P ndi ichi adzakhala mtengo wa mtunda.

chiwonongeko cha trigonometry

4. Kuwerengera mwachilungamo

Tsopano, pa maphunziro tikuyenera kuchita mawerengero angapo; koma onse achoka pambali pakati pa siteshoni ndi imodzi yotsatizana.sine cosine wopambana Kuwerengera kwa ngodya. Kumbukirani kuti cosine laling'ono ndilofanana ndi kugawa b pakati pa c, kapena delta x pakati pa mtunda wowerengedwa ngati hypotenuse.

Chifukwa chake zimangochitika mu Excel yogawaniza gawo L ndi gawo P. Timachitanso mawerengedwe a sine, yomwe idzakhala yogawa Delta Y ndi hypotenuse (M ndi P). Tsopano kwa kuwerengera mbaliOnly tingagwiritse ntchito osiyanitsidwa cosine kwa Danga kuti lili ndi mmene kupambana amagwiritsa radians, chulukitsani mtengo ndi kugawa 180 PI; ndondomekoyi ikanawoneka ngati iyi: = ACOS (chigawo R) * 180 / PI ().

Tsopano kuti muwerenge Kum'mawa / Kumadzulo Timapereka chikhalidwe chake: ngati cosine ili ndi chiyembekezo, lembani E, ngati cosine ili ndi vuto lembani W. Fomuyi ikuwoneka motere: = IF (R2 <0, »W», »E»)… ili mgawo T Kuwerengera North / South orientation, timagawa mkhalidwe wofanana ndi uja wakale, koma ndi sine; ndiye kuti, ngati sine ili ndi vuto, lembani N, ngati ilibe, lembani S ndipo chilinganizo chikhale chonchi: = IF (R2 <0, »W», »E»)… ili mgawo la U

Tsopano tiyeni tikumbukire kuti mawonekedwe omwe adawerengedwa kale akuchokera kopingasa, kum'mawa ndipo zomwe tikufunikira ndizokhudzana ndi kumpoto kapena kumwera. Chifukwa chake ku NW ndi SW quadrants timatenga madigiri a 90 kutali, ndiye zomwe timachita ndikupanga vuto kuti ngati cosine ili ndi vuto, timachotsa 90 ndipo mu NE ndi SE quadrants timatenga 90 kupatula mbali ... m'mbali V

mawerengedwe a maphunziro

Column V imawonetsera ngodya, koma pamitundu ya decimal. Kusintha madimidwe kukhala madigiri, mphindi ndi masekondi zomwe timachita ndikuzidula ndi malo opanda zero, monga momwe ziliri mgawo W. To kuwerengera mphindi, timachotsa madigiri athunthu kuchotsera madigiriwo ndikuchulukitsa ndi 60. Kenako timawadulira malo opanda zero momwe amawonekera pagawo Y. Ngati masekondi, mphindi zimachotsedwa pamphindi zomwe zidadulidwa, ndikuchulukitsidwa ndi 60. Pomaliza, masekondi adadulidwa m'malo awiri osungidwa ... samalani, ngati ma UTM omwe amagwiritsidwa ntchito analibe malo opitilira awiri, kuchuluka kwa masekondi sikudzakhala ndendende kwambiri kotero kungakhale bwino kuwasiya mpaka decimal.

5. Kulengedwa kwa tebulo la maulendo ndi maulendo

Zaka.

mayendedwe ndi kutalikaPachifukwachi ndimagwiritsa ntchito fomu ya concatenate, kotero ndikuwonjezera selo yomwe ili ndi nambala 1, ndiye malo osungira malo, ndiyeno selo liri ndi nambala 2; mwanjira imeneyo ndimakhala ngati mawonekedwe «1 - 2»

Madera.  Izi zimachokera ku chigawo cha hypotenuse.madigiri ndi mphindi

Maphunziro.  Izi zikutanthauza kubweretsa mtengo wowerengedwera pazomwe zidalembedwa kale, komanso kuti selo liwonjezere chizindikiro cha digiri, mphindi kapena yachiwiri zimapangidwa muzipangizo za selo monga momwe zasonyezedwera mu fano. Kuwonjezera apo, ndawonjezera ndondomeko yowonongeka, chifukwa kafukufuku wamakono amafunika. Kuchokera apa mukhoza kukopera fayiloyi muyeso dwg, muwonekedwe DGN, fayilo ya Excel ndi fayilo txt.

Kotero izo Pano pali fayilo ku Excel momwe mungapangire tebulo lamutu ndi mtunda kuchokera kumaulalo motsatizana a UTM. Kuti muwonjezere mfundo, mutha kukopera zipilala ndikuziyika, ndibwino chifukwa mwanjira imeneyi mumatsimikizira mayendedwe, pofuna kulemekeza mzere woyamba ndi womaliza. Muyeneranso kukopera zomwe mwapeza kuchokera koyamba mpaka kumapeto koyamba, kuti malo omaliza aziwerengedwa bwino.

Pano mungathe kukopera template kupanga bokosi la zida ndi maulendo kuchokera ku ma UTM.

 

utm nyimbo zamakonoPamafunika 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.


 

41 Imayankha "Pangani tebulo la mayendedwe ndi mtunda kuchokera kumayendedwe a UTM"

  1. Pali chida wotchedwa Calculo_Topográfico.exe, inu automates ndondomeko ya kusintha kwa UTM Malo spreadsheet, monga kumathandiza kupeza ngodya zabwino, mayendedwe ndi kutalika, komanso zipangizo zina zothandiza ngati kupeza cholakwa N'kuthekanso kafukufuku, mwina kum'mawa kapena ngodya ndi mtunda, amachepetsa ndi polygon m'dera anafuna ndi kusintha mbali imodzi kapena ngodya, abwino kwa dismemberment, makamaka munakonza zojambula mu AutoCAD, wakupatsani kukopera ndi phala (kapena) Pilot (s) wa polygons ndi kuti mukugwira ntchito; Komanso zogulitsa kunja deta kuti imakonzanso okwerera okwana, kweza (kapena kukopera) mudziwe.

  2. Funso: Chifukwa deltas amawerengera iwo kuchokera pansi komanso osati mozungulira?

  3. Ndondomeko yabwino, ndapanga zambiri mwa Microstation zomwe zimachita chimodzimodzi kwa ine ndikuzitumiza ku fayilo ya txt.

  4. Ndakhala wokhutira kwambiri ndipo panthawi imodzimodzi ndikumva chisoni kuti sindinathe kugwiritsa ntchito ntchitoyi, chifukwa sindingathe kupereka zopereka zophiphiritsira, chifukwa ine sindikupanga? mu ntchito yanga monga wofufuza komanso moona mtima ndikukhudzidwa ndi zomwe ndikudziwa kuti ndikulitse ndikulimbikitseni ntchito yanga, ngati mutatha kunditumizira kunditumizira ine ndikuthokozani kwambiri
    Samana Dominican Republic

  5. Sungani makalata anu, mu spam.
    Ulendo waulendo ukhoza kupita kumeneko.

    zonse

  6. Zabwino, ndi zothandiza !! koma ndangopanga zoperekazo ndipo sindinatengere template ..
    zonse

  7. Moni masana kodi mungakhale ndi cholembedwa kapena zitsanzo za mawerengedwa ake? ndiko kugwiritsa ntchito ndi kufunika, moni wochokera ku Mexico

  8. Ndondomeko, ndi ndondomekoyi ndinatha kupanga pepala lapamwamba lomwe limapereka malangizo, chifukwa chogawana mfundo izi zofunika.

    Moni wa Nicaragua

  9. Eya, uli bwanji? Ndikuyembekeza bwino, ndikufuna ndikuwone ngati mungathe kundithandiza pamene mukuwerengera o kutalika pakati pa mfundo ziwiri ndi makonzedwe awo ndi makonzedwe O mmalo mokhala ndi miyendo ndi mautali aatali chifukwa ndikhoza kuchita ndi mautm x komanso kuti ndilibe mavuto koma sindingathe kuchita nawo Mtundu wina wa maofesi omwe amasonyeza pa Google Earth mapu.
    moni .. Ndikuyembekeza yankho lanu ngati n'kotheka ..

  10. Axamwali, powerenga mafunso anu okhudzana ndi kuwerengera kwa mitundu, mbiri ya "matebulo" othandizira ndi kulembera zonyamula mayendedwe ndi mtunda ku Autocad, ndikulimbikitsa kugwiritsa ntchito chida cha CIVILCAD, chopangidwa ku Mexico, gawo ili limapangitsa autocad kukhala chida chowerengera topographic, mbiri , zigawo, ma contour, etc., etc.
    Ponena za mafunso anu aulere a UTM, mapulogalamu onse amachitidwe a GPS (mayankho a GNSS ochita malonda, mayankho a Ashtech a Promark 2, Spectra Precision Survey Office ya GPS Epoch 10 ndi 50, etc.) ali ndi kusintha kwa zinthu pakati pa machitidwe zogwirizanitsa, zonse zomwe amafunikira ndizoyang'anira umodzi kapena zingapo mu UTM komanso mu "flat" yolumikizira (ndiye kuti, magwirizano omwe akufuna kugwiritsa ntchito ndi station yonse) ndipo mapulogalamuwa amawerengera kuchuluka kwake komanso chidziwitso chofunikira amafunikira, ingowerenga zolemba zofananira za zida zawo ndikukonzekera bwino kusonkha kwa deta. Moni wochokera ku Mexico City. Imelo yanga ndi gilberto1@sitg.com.mx.

  11. Zingafunike kusintha patebulo, koma zitha bwino. Mukatitumizira chitsanzo titha kuyesa.

  12. Zabwino kwambiri. Tebulo langa ndakonzeka kale. Ndikufuna kudziwa ngati zingandithandizire kupeza mayimidwe osokonekera ndi data yomwe ili kale pagome lomweli. Zikomo !!

  13. Mphunzitsi, ndi chifukwa chotsutsana?
    Kuchokera kumayendedwe kupita ku malo ozungulira?
    Muchas gracias

  14. Mukunena zowona, zimachitika kuti bandwidth ya geofumadas.com, komwe mafayilo ndi zithunzi zochokera kubuloguyi zimathandizira, zidapitilira. Ndiyenera kukweza m'lifupi, yesaninso nthawi ina.

  15. nanga bwanji, yesani kukopera fayilo yapamwamba koposa koma ndiwonetseni ine kuti palibe, ndingathe kuthandizira izi.

    zonse

  16. Muyenera kukhala achindunji kuposa momwe mukutanthawuzira ndi makonzedwe apamwamba.

    Kodi munangonena malo ndi madigiri, mphindi, masekondi? Kuti muthe kugwiritsa ntchito chida ichi.

    Ngati simunatchulepo, onani ngati mutatipatsa chitsanzo chothandizani.

  17. Ndili ndi UTM yomwe imalumikiza monga momwe ndikuchitira kuti ndizichepetsanso makampani ogwirira ntchito.

  18. Chinthu chothandiza kwambiri kuti muwerenge dera la AutoCAD, zomwe mukuzifuna sikuti ndizitha kuwerengera dera koma kuti zitsimikizire kutsekedwa, mwinamwake pali chithunzi chomwe chikuchita zomwe mukufuna koma sindikudziwa.

  19. Tsambali ndi labwino kwambiri. Ndikufuna kudziwa momwe ndingagwiritsire ntchito (mu Excel) dera lomwe limachokera ku polygon yomwe imapangidwa kuchokera kumalo ozungulira ndi zonyamulira zomwe zimapezeka m'munda. Ndine wojambula zithunzi ndipo ndimagwiritsa ntchito pulogalamu ya Autocad, ndikuphatikizapo ndi matebulo a Excel.
    Ndikuyamikira kwambiri chidwi chanu poyankha funso langa.
    Zabwino kwambiri kuchokera ku Asuncion ku Paraguay
    Mabel

  20. Ndikuganiza kuti mukusokoneza njirayi, ngati mulibe ma ulalo a ma utm, simuyenera kuyang'ana iwo. Muyenera kutanthauzira zomwe zolemba zanu zakufufuza zikunena, pali poyambira, ngati sichinena kuti chogwirizanitsa chikhazikitseni kulikonse, ndiye kuwona ngati pali njira ndi mtunda wopita ku mfundo ina.

  21. Fayilo siyi ya izo, ndi kuwerengera bokosi la zojambula zochokera pa mfundo ndi zogwirizana

  22. Maestro Alvarez, fayiloyi ikulumikiza maulendo a UTM kuchokera pamtandanda womwe unakwezedwa ndi msampha ndi msinkhu ndi zodabwitsa koma ine sindingakhoze kuchimvetsa icho

  23. Taonani mnzanga wina wa ku Peru wanditumizira template ndi funso koma sindingathe kumvetsa kuti UTM yayikidwa pachiyambi pakati pa PI iliyonse, monga fayilo cholumikizira

  24. Moni Jcp, ndikumvetsetsa kuti muli ndi mzere wapakati, ndi masiteshoni ndi malo aliwonse ali ndi malo kumanja ndi kumanzere. Ndikuganiza kuti chinthu choyenera kwambiri ndikuti musayesetse kuti utm ugwirizane, koma pangani zozungulira kuchokera pakatikati, ndikuyika mfundoyo pamphepete mwa bwalo ndi mzere.

    izi zingakupangitseni kukhala ndi zofanana ndi izi

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

    Ndiye kuti muwonjezere mapamwamba omwe akukonzekera mawonekedwe a mfundo yomwe mungalowemo mungapereke kukwezeka.

  25. Wokondedwa Bambo Alvarez ndikugwiritsa ntchito boma 3d 2009, ndimalowetsa ma UTM mu mtundu wa .cvs koma tsopano ndiyenera kusintha magawo omwe akwezedwa ndi magalimoto ndi mulingo kukhala UTM opambana, ndili ndi cholumikizira ndipo poyambira 0 + 000 ndimakweza ndi GPS kuti ndikwaniritse izi ... ndingawerengere bwanji ma POI olamulira anga ndi magawo ake ku UTM

    Ndimachokera ku Honduras

    jcpescotosb@hotmail.com

  26. Ndipotu, ndondomeko zomwe ndakhala ndikuzichita kale, koma ndikufuna kuzichepetsera ku ndege kuti zizigwira ntchito kumunda

  27. Tawonani, sindinagwiritse ntchito Promark koma ndikuwona ikuwoneka mofanana ndi Map Map Mobile kuyambira ku Thales.

    Mu ichi ndinatero:

    1 Kanikizani batani la «MENU»
    2 Sankhani «Ma Mapu Mapu»
    3 Sankhani «Coordinate system» ndikusankha UTM
    4 Mumasankha «Datum» ndipo apa mukuwonetsa WGS84

  28. iwo ali ochepa, iwo amawoneka kuti ndi 2, mumzinda wa Mexico zone 14, ine ndikanati ndidziwe zambiri zomwe mungapereke.

  29. … Ahem, ahem… 🙂

    Ndipo ndi gps mtundu wanji, wopanga ndi chitsanzo omwe amagwiritsa ntchito?
    Ndi dziko liti ndi dera liti lomwe muli?

  30. Wokondedwa ALVAREZ, pamwamba moni onse, ndinazindikira kuti nzeru zanu mu zimachititsa chilumbachi ndi mapulogalamu patsogolo, Ine akhoza kuthandiza, kampani I ntchito, kusamalira GPS, ndipo ine ndikufuna kudziwa momwe ine kusintha UTM ndondomeko ya ndondomeko mtunda O Planas, kwa eni munda, anayang'ana mudziwe zambiri za izo ndi angayamikire mungayankhire.

  31. Paulo, ndikuyamikira kwanu, ndakhala ndikukonzekera kulembera kalata, ndilo L ndime pakati pa ndime P

    vuto lina limene inu mukulikulitsa, ndikuganiza kuti simunathe kumaliza ndemanga kuti muthe kuzifufuza

  32. Ndinatsatira malangizo ndi sitepe. Theoretically ndinamvetsa, koma ndikuchita sindinathe kupeza zotsatira zabwino.
    Mae akuwoneka ngati ndikuchita chinachake cholakwika. komanso mu kasinthidwe ka magulu a Autocad omwe ali mbali ya maangelo ndi malangizo ine sindiri bwino kwambiri.
    Ndikufuna kunena kuti muwunikenso gawo la ngodya zomwe ndikuganiza kuti pali cholakwika, pomwe akuti "kugawa gawo N lolemba P" Ndikuganiza kuti ndi L L ndi column P.
    Kulakwitsa kwina kwa kulembanso kumawoneka mu kuwerengera kwa kumpoto / kumwera kwa South, chiganizo chikuti: chidzakhala: = SI (R2

  33. ngati mukutanthauza chiwembu chomwe chimayesedwa kudera lomwe malowo asintha ... sichingakugwireni.

    Ngati mukutanthauza kuti kukhala ndi ziwonetserozo kumalo enanso a utm, sikuyenera kusinthika chifukwa mukuyenera kuti mulankhule za kutalika komweko, ndiye kuti maupangiri amafanana

  34. moni,

    Ndinafuna kukonda izi mwabwino, ndili ndi funso

    Kodi zimagwiritsidwa ntchito bwanji ngati kusintha kwasonga?

    Gracias

    Juan

  35. mmm, nditumizireni ine script yomwe mumayankhula mu imelo yomwe muli nayo, kuti muyiyankhe.

    Ine ndiwona zomwe ziri kumeneko

  36. chosamveka !!! tsopano pitani ku 100%, ndagwiritsa ntchito ndipo ndi zoona! zikomo kwambiri, ndakhala ndikuthandiza.

    Funso lokhudza izi, popeza tili munjira zoyendera zokha. Kugwiritsa ntchito AutoCAD, kukhala ndi polygon yoyeseza, ndi mawonekedwe ake odziwika a UTM, zomwe ndikusowa ndi chizindikiritso cha magawo, kotero kuti ndikadina nawo ndikuwapatsa "zilembo" zotsatana, mwachitsanzo: 176.35

  37. okonzeka, ndayika kale mtundu wa 2 wa fayilo yopambana. Cholinga chake chinali chakuti mu NE ndi SE quadrants momwe angle ku 90 idayenera kuti ichotsedwe.

    Yesani ndikudziwitse.

    Muyenera kukhala omveka, kuti ziwonetsero zambiri zimagwiritsidwa ntchito mu UTM zolumikiza, zidzasintha ziwonongeko za masekondi.

  38. mmm, iye akulondola, ine ndikuganiza ine ndikudziwa momwe ndingathetsere izo

    Ndiyang'anitsitsa ndikadzabwereranso kunyumba kwanga.

  39. aphunzitsi olemekezeka, choyamba ndikuthokozani chifukwa cha yankho lanu mofulumira, ndikufika nthawi!
    Ndimamuuza kuti zandithandiza kwambiri, ndimamuyesa, ngakhale ndimafuna kufotokoza kukayikira / lingaliro / nkhawa: imawerengera mtunda bwino kwambiri, tsopano ngodya imandipatsa zowonjezera, mwachitsanzo m'malo mokhala 88d13'13 », zimandipatsa 1d21'47 »!!! Iyenera kukhala kusintha pang'ono ndipo tatha! Zikomo kachiwiri chifukwa cha thandizo lanu !!!

Siyani yankho

Anu email sati lofalitsidwa.

Tsambali likugwiritsa ntchito Akismet kuchepetsa spam. Phunzirani momwe deta yanu ikufotokozera.