AutoCAD-AutoDeskdownloadsMicrostation-Bentleytopografia

Ƙirƙiri akwati na bearings da nisa daga haɗin UTM

Wannan matsayi ne a mayar da martani ga Diego, daga Paraguay wanda ya sanya mana Tambaya ta gaba:

wani yardarsa zuwa gaishe shi ... wasu lokaci da suka wuce da wani search da suka zo bazata so zuwa ga website kuma na same shi musamman mai ban sha'awa, duka biyu don nishadi gudu kamar yadda da su domin sadarwa da ciencia.Yo son tambaye idan kun san wasu rubutun, ko wasu frame Excel don taimaka mini inyi haka: Na kirkiro a cikin CAD wani polygon tare da alamomi da aka gano da kyau, kuma tare da iyayensu na UTM. Ina iya daidai fitarwa zuwa sakon text karanta a excel.Mi tambaya: sanin UTM data 1 ... N maki, shi ne mai yiwuwa a samu data yanayi, kwatance da kuma nisa watau cewa daga cikin bayanai na samar? da 1 batu yana da X ... Y ..., da kuma sanin cewa 2 batu yana da X ... Y .... ZA KA BAUTA NA RAITAIWA YA YI SAKA DA KUMA KUMA? don samun damar yin takardar takarda ta atomatik, na gode ... jin dadi daga Paraguay!

To, abin da Diego yake so shi ne daga UTM tsarawa samar da akwatin kwatance da kuma nisa ... kuma kamar yadda gama Easter, a lokacin da Na ci abinci kifi cake, fritters a cikin zuma, da sun dauka mai kyau hotunan sawdust kyãwãwa ... a nan ne amsar. Na farko, bari mu gane cewa hanya mafi kyau ta yin haka shine tare da kayan aiki mai kyau (Zai iya zama tare da Macba Vba na Microstationtare da Softdesk ko AutoCAD Civil 3D) amma don koyo dalilai, da kuma fahimtar cewa a rayuwa dole ka yi amfani da abin da ka yi, bari mu ga yadda za a yi shi tare da Excel.

1. Haɗa maki

Diego ya gaya mana cewa yana da hanyar aika abubuwan zuwa fayil txt, don buɗe shi tare da Excel, don haka a halin na zan yi ta Microstation. Saboda ina so in aika bayanan zuwa Excel, zan sanya maki a kan kowace kusurwa. Don sanya su bayyane, Na canza kaurin layi, kuma yana da matukar mahimmanci a fahimci cewa Microstation zai aika su zuwa fayil ɗin txt a cikin tsarin da aka ƙirƙira su, don haka ya zama dole a ƙirƙira su a jere.

Tsarin mahimmanci yana da kyau

Don aika su zuwa Excel, ana amfani da kayan aikin "Export Coordinates", Na ƙirƙiri "shinge" wanda ke rufe duk maki kuma na saita bayanan:

  • Na ba sunan fayil txt a matsayin test444.txt
  • Na nuna cewa umurni da ke son ni XYZ
  • Tsarin raka'o'in daga "manyan raka'a" wanda ke cikin mita
  • Na nuna cewa ina son nau'i biyu kawai
  • Sa'an nan kuma rabuwa mai shafewa da lambar daga 1

Ta danna maɓallin "shinge" da danna kan allon, tsarin ya ƙirƙiri fayil ɗin txt kuma ya ƙirƙiri lamba ga kowane maki, daga 1 zuwa 36.

Tsarin mahimmanci zuwa txt

2. Bude tebur daga Exceltxt mafi girma microstation

Don buɗe wannan fayil ɗin daga Excel, je zuwa “file/buɗe” kuma zaɓi nau'in fayil ɗin “fayil ɗin rubutu, .prn .csv .txt” Sa'an nan, a cikin panel ɗin da ya bayyana, zaɓi cewa an raba rubutun da waƙafi. A ƙarshe an buɗe fayil ɗin tare da ginshiƙai uku, a cikin farko akwai lambobin maki, a cikin na biyu X coordinate kuma na uku y coordinate.

3. Kira Distanceabubuwan da ke cikin al'ada sune

Bari mu fara komawa kan ka'idodi masu mahimmanci game da yanayin magana. Ka tuna cewa muna neman nesa da kusurwa.

wani bambanci kula = Y (an cire ta subtracting x2 - x1) a Mb = bambanci shafi kula X (an cire ta subtracting y2 - y1) a LC = hypotenuse shafi ne square tushen square b more wani square a cikin P shafi kuma wannan zai zama darajar nesa.

hypotenuse trigonometry

4. Bayanan lissafi

A yanzu, domin hanya muna buƙatar yin lissafin yawa; amma duk bar daga kusurwa tsakanin tashar da kuma jere daya.Sine cosine excel Kira daga cikin kusurwa. Ka tuna cewa cosine na kusurwa daidai yake da rarraba b tsakanin c, ko delta x tsakanin nisa da aka lissafa a matsayin hypotenuse.

Don haka kawai ana yin shi a cikin shafi mai rarraba Excel L ta shafi P. Muna kuma yin lissafin sine, wanda zai kasance don raba Delta Y ta hanyar hasashe (M by P). Yanzu don Ƙididdige kwana, zamu yi amfani da kwakwalwa maras kyau zuwa shafi wanda ya ƙunshi shi kuma kamar yadda Excel yayi amfani da masu ruɗi, ƙara 180 darajar ta kuma raba shi tsakanin PI; wannan tsari zai kasance kamar wannan: = ACOS (shafi na R) * 180 / PI ().

Yanzu don lissafta Gabas ta Gabas / Yamma Mun sanya sharadi: idan cosine yana da kyau, rubuta E, idan cosine ba ta da kyau, rubuta W. Tsarin yana kama da haka: = SI(R2 <0,"W","E")... yana cikin shafi T Don lissafin Tsarin Arewa / Kudu, mun sanya wani yanayi mai kama da na baya, amma tare da sine; wato, idan sine yana da kyau, rubuta N, idan ya kasance mara kyau, rubuta S kuma tsarin zai kasance kamar haka: = SI(R2 <0,"W","E")… yana cikin shafi U

Yanzu bari mu tuna cewa kusurwar da aka lissafta a baya daga kwance take, a gabas kuma abin da muke buƙata shine game da arewa ko kudu. Don haka dangane da quadrants na NW da SW zamu ɗauki digiri 90 nesa, don haka abin da muke yi shine ƙirƙirar yanayin cewa idan cosine ba shi da kyau, sai a cire 90 kuma a cikin ƙananan quran NE da SE za mu ɗauki 90 an rage kwana ... a shafi na V

Hakika lissafi

Shafi na V yana nuna kusurwa, amma a cikin tsari na goma. Don canza adadi zuwa digiri, mintoci da sakan, abin da muke yi shi ne yanke shi da sifilin wurare goma, kamar yadda yake a shafi W. To lissafta minti, mun debe cikakkun digirai da aka debe digirgirn digiri kuma mu ninka su da 60. Sa'annan mu datse su da sifilin wurare goma kamar yadda yake a shafi Y. Idan akwai seconds, an debe mintoci ana cire mintuna kaɗan, kuma aka ninka su da 60. A ƙarshe, an datse sakan zuwa wurare goma ... a yi hankali, idan haɗin UTM ɗin da aka yi amfani da shi ba shi da wurare fiye da goma, ƙima ta goma na sakan ba zai zama ba daidai sosai don haka zai fi kyau a bar su zuwa adadi.

5. Halittar tebur na kwatance da nesa

A yanayi.

wurare da nisaDon wannan na yi amfani da tsarin haɗin gwiwa, don haka sai na ƙara tantanin halitta mai lamba 1, sai sararin samaniya, sannan tantanin halitta mai lamba 2; don haka ina da nau'in tashoshi "1 - 2"

Nisa.  Wadannan sun fito daga shafi na hypotenuse.digiri mintuna da sakanni

A hanya.  Wannan kawai yana buƙatar kawo lissafin lissafi a cikin ginshiƙai da aka lissafa a baya, kuma don tantanin tantanin halitta don ƙara digirin digiri, minti ko na biyu an halicce shi a cikin dukiyar tantanin halitta kamar yadda aka nuna a cikin hoton. Bugu da ƙari, na kara da wani shafi na lura, domin a cikin saitunan yawan rubutu ana bukatar shi. Daga nan zaka iya sauke fayil a tsari dwg, a cikin tsari DGN, fayil ɗin Excel da fayil din txt.

Don haka A nan ne fayil a Excel tare da shi zaka iya ƙirƙirar taken da tebur mai nisa daga daidaitattun haɗin UTM. Don ƙara maki, za ku iya kwafa ginshiƙai ku saka su, ya fi saboda wannan hanyar kuna ba da garantin hanyoyin, neman girmama layi na farko da na ƙarshe. Hakanan dole ne ku kwafe bayanan daga farkon zuwa ƙarshen na farko, don a kirga tashar ta ƙarshe da kyau.

Anan zaka iya sauke samfurin don ƙirƙirar akwatin kwalliya da nisa daga daidaitattun UTM.

 

Saukewa da saukewaYana buƙatar gudummawa ta alama don saukarwa, wanda zaku iya yi da shi PayPal ko katin bashi.

Shi ne m la'akari da darajar da shi na samar da sauƙi da wanda za ka iya saya.

 


Koyi yadda ake yin wannan da sauran samfura a cikin Excel-CAD-GIS hanya mai cuta.


 

Golgi Alvarez

Marubuci, mai bincike, kwararre a cikin Samfuran Gudanar da Ƙasa. Ya halarci Conceptualization da aiwatar da model kamar: National System of Property Administration SINAP a Honduras, Model na Management of hadin gwiwa Municipalities a Honduras, Integrated Model na Cadastre Management - Registry a Nicaragua, System of Administration na Territory SAT a Colombia. . Editan shafin ilimin Geofumadas tun daga 2007 kuma mahaliccin Kwalejin AulaGEO wanda ya haɗa da darussa sama da 100 akan GIS - CAD - BIM - batutuwan Twins na Dijital.

shafi Articles

41 Comments

  1. Akwai kayan aiki kira Calculo_Topográfico.exe, ku automates aiwatar da mayar wa UTM tsarawa a falle, ciki har da malã'iku, bearings da nisa, kazalika da sauran kayayyakin aiki, kamar amfani sami m kuskure na duba, ko dai gabas ko kwana ta nesa, rage a polygon yankin nemi ta gyaggyarawa daya gefen, ko wani kwana, manufa domin dismemberment, da kuma musamman ka ƙirƙiri da zane a AutoCAD, kyale ka ka kwafa da liƙa (ko) Pilot (s) na polygons tare da cewa kana aiki; kuma fitar da kaya da bayanai zuwa Tsarin total tashoshin, upload (ko download) bayanai.

  2. Tambaya: Saboda ƙananan ƙididdigar sun ƙidaya su daga ƙasa zuwa sama amma ba hanyar da ke kusa ba?

  3. Kyakkyawan samfurin, Na samar da wani macro kai tsaye a Microstation wanda yake daidai da ni kuma ya fitar da ita zuwa fayil txt.

  4. Na yi matukar farin ciki kuma a lokaci guda na yi hakuri saboda ba ta iya sauke aikace-aikacen ba, tun da ba zan iya yin taimako na alama ba, domin ba a halin yanzu nake ba? a cikin sana'a a matsayin mai nazari kuma da gaske ina sha'awar waɗannan bayanai don fadada da ƙarfafa sana'a, idan za ku iya yarda da ni don aikawa a gare ni zan gode da ku sosai
    Jamhuriyar Dominican Republic Samana

  5. Bincika wasikar ku, a spam.
    Hakan tafiya zai iya zuwa can.

    gaisuwa

  6. Mafi kyau, yana da matukar amfani !! amma na kawai sanya gudunmawar kuma bai download da template ..
    gaisuwa

  7. Sa'a, rana mai kyau, za ku sami labarin ko misalai na sikelin lissafi? watau aikace-aikace da muhimmancin, gaisuwa daga Mexico

  8. Madalla, tare da wannan jagorar na iya ƙirƙirar takarda mai mahimmanci wanda ke ƙayyade wurare, godiya ga raba wannan muhimmin bayani.

    Gaisuwa daga Nicaragua

  9. Hi, yaya kake? Ina fatan da kyau, ina so in gan idan na iya taimaka kamar yadda ka gane oh zana nisa tsakanin biyu da maki kuma aka karkasa su tare da tsarawa oh m tare da latitudes da longitudes saboda zan iya yi tare da coordendas utm xy da cewa Ina da wani matsaloli amma ba zan iya yi da shi da sauran tsarawa nuna a kan maps of Google Earth.
    gaisuwa .. Ina fatan amsarku idan ya yiwu ..

  10. Abokai, karanta tambayoyinku game da lissafin topographic, tsarar "Tables" na daidaitawa da lakabin kwatance da nisa a cikin Autocad, Ina ba da shawarar yin amfani da kayan aikin CIVILCAD, wanda aka haɓaka a Mexico, wannan ƙirar tana canza autocad zuwa kayan aiki don lissafin topographic, bayanan martaba, sassan. , layukan kwane-kwane, da sauransu, da sauransu.
    Game da tambayoyin ku daga UTM zuwa daidaitawar daidaitawa, duk shirye-shiryen sarrafa GPS (maganin GNSS don promarks, mafita na Ashtech don Promark 2, Ofishin Bincike na Spectra Precision na GPS Epoch 10 da 50, da sauransu) suna da tsarin canzawa tsakanin tsarin daidaitawa, duk abin da suke buƙata. aƙalla ma'aurata biyu ne ko fiye da haɗin kai a cikin UTM kuma a cikin daidaitawar "lebur" (watau daidaitawar da suke son amfani da su tare da jimlar tashar) kuma shirye-shiryen za su lissafta ma'aunin ma'auni da bayanan da suke buƙata, kawai ku karanta daidai. littattafan kayan aikinsu da tsara tattara bayanai da kyau. Gaisuwa daga birnin Mexico. imel na shine gilberto1@sitg.com.mx.

  11. Za a yi gyare-gyare zuwa tebur, amma zai iya zama. Idan ka aiko mana misali za mu iya gwadawa.

  12. Kyakkyawan taimako. Na riga an shirya tebur na. Ina so in san idan za ku iya taimaka mini in sami kusurwar da ke da bayanan da ke da wannan tebur. Na gode !!

  13. Malami, da kuma hanyar da ke baya?
    Daga hanyoyi zuwa daidaito geographic?
    na gode sosai

  14. kun kasance daidai, shi yana faruwa cewa bandwidth na geofumadas.com, wanda shine inda suke shirya fayiloli da hotuna na wannan blog da aka wuce. Dole in ci gaba da nisa, gwadawa daga baya.

  15. yaya game da, gwada sauke fayiloli mai kayatarwa amma nuna mani cewa ba'a samu ba, zan iya taimakawa tare da wannan.

    gaisuwa

  16. Ya kamata ku kasance ƙayyadaddu fiye da yadda kuke nufi tare da haɗin gwiwar topographical.

    Shin kawai ka ce yankin da digiri, minti, seconds? Domin wannan zaka iya amfani wannan kayan aiki.

    Idan ba ku kula da wannan ba, duba idan kun bamu misali don taimaka muku.

  17. Ina da haɗin UTM kamar yadda nake yi don rage su zuwa haɗin kai.

  18. Abu mafi mahimmanci shine don ka lissafa yankin a AutoCAD, abin da kake nema ba kawai don lissafi yankin ba amma don tabbatar da ƙulli, watakila akwai samfuri a can wanda yake yin abin da kake so amma ban san shi ba.

  19. Shafin yana da kyau. Ina so in san yadda za a lissafta (a cikin Excel) yankin da aka samo daga polygon da aka samo daga ƙaddamar da tarnaƙi da kuma takaddun da aka samu a filin. Ni manzo ne kuma ina amfani da shirin Autocad, hada shi tare da Tables na Excel.
    Ina jin dadin da kake so wajen amsa tambayoyin da nake yi.
    Kyau mafi kyau daga Asuncion na Paraguay
    Mabel

  20. Ina tsammanin kana rikitarwa hanya, idan ba ku da haɗin gwargwadon imel, ba dole ba ne ku nemi su. Dole ne ku fassara abin da shafinku na farkawa ya ce, akwai farawa, idan bai ce haɗin kai ba, sanya shi a ko'ina, sa'annan ku gani idan akwai hanya da nesa don zuwa wurin gaba.

  21. Fayil ba don wannan ba, yana da lissafin akwatin na bearings bisa ga maki tare da haɗin kai

  22. Maestro Alvarez, wannan fayil yana ƙididdige bayanan UTM daga wani ɓangaren ɓangaren da aka tashe tare da zirga-zirga kuma matakin yana da ban mamaki amma har yanzu ba zan fahimta ba

  23. Duba aboki daga Peru ya aiko mani samfurin tare da tambaya amma ba zan iya gane cewa UTM aka sanya a farkon tsakanin kowane PI ba, a matsayin abin da aka haɗa fayil ɗin

  24. Hello Jcp, Na fahimci cewa kana da layi na tsakiya, tare da tashoshi da kowane tashar akwai daidaitattun zuwa dama da hagu. Ina tsammanin abin da ya fi dacewa shi ne cewa ba kayi kokarin samun jagorancin aiki ba, amma ka sanya maciji daga tsakiya, saka mahimmanci a tsinkayar da'irar da layin.

    wannan zai sa ka sami wani abu mai kama da wannan aikin

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

    Sa'an nan kuma don ƙara ƙwanƙolin da ya saita wani nau'i mai mahimmanci wanda za a shigar da wannan zaka iya ba da tayi.

  25. Ya ƙaunataccen Mr. Alvarez Ina amfani da farar hula 3d 2009, na shigar da maki UTM a cikin tsarin .cvs amma yanzu ya zama dole in canza sassan gicciye waɗanda aka ɗaga tare da zirga-zirga da matakin zuwa UTM a cikin nasara, ina da tsayayyen ginshiƙi da kuma wurin farawa 0 + 000 Na ɗaga shi tare da GPS don samun damar iya sarrafa shi ... ta yaya zan kirga maki POI na axis dina da sassan zuwa UTM

    Ni daga Honduras

    jcpescotosb@hotmail.com

  26. A hakikanin gaskiya, ƙayyadaddun da na riga na samu, amma ina so in rage su zuwa jirgin saman topographics don aiki a filin

  27. Duba, ban yi amfani da wannan Shawarwarin ba amma na ga yana kama da Mobile Mobile wanda ya kasance daga Thales.

    A cikin wannan na yi haka:

    1. Kuna danna maɓallin "MENU".
    2. Zaɓi "Ƙungiyoyin Taswira"
    3. Zaɓi "Coordinate System" kuma zaɓi UTM
    4. Kuna zaɓi "Datum" kuma a nan kuna nuna WGS84

  28. su ne ƙananan, suna da alamar 2, a cikin birnin 14 yankin mexico, Ina godiya da duk wani bayani da za ka iya samar.

  29. Hem Ahem, ahem… 🙂

    Kuma wane nau'i na GPS, da kuma yin amfani da su?
    Wani ƙasa da yankin kuke ciki?

  30. Dear Alvarez, a sama da dukan wata gaisuwa, na lura cewa ka sani a topography da software suna ci gaba, na iya taimaka, kamfanin na aiki domin, sarrafa GPS, kuma ina so in san yadda zan daidaita da UTM tsarawa daga topographical tsarawa Ya Planas, to filin management, sun duba fi bayanai game da shi, kuma zai gode da amsa.

  31. Bulus, godiyar ku, na riga na gyara gyara, shafi na L a tsakanin shafi na P

    da sauran matsala da kuke tasowa, ina tsammanin kun kasa cika bayanin don ku iya nazarin shi

  32. Na bi umarnin mataki zuwa mataki. A gaskiya dai na fahimta, amma a cikin aikin ban sami damar cimma sakamako mai kyau ba.
    Mae alama kamar ina yin wani abu ba daidai ba. Har ila yau, a cikin daidaitattun raka'a na Autocad, za ku ga ɓangaren kusurwar da kuma shugabanci ba ni da cikakkiyar bayyana.
    Ina so in ba da shawarar cewa ku sake duba sashin kusurwoyi, ina tsammanin akwai kuskure, inda aka ce "raba shafi N ta shafi P" a gare ni kamar shafi ne L da shafi P.
    Wani kuskuren rubuce-rubuce ya bayyana a cikin lissafi na Arewacin Kudu / Ta Kudu, wanda ya ce: zai kasance: = SI (R2

  33. idan kana nufin makircin da aka auna a yankin da yankin ya canza ... ba zai yi aiki a gare ku ba.

    Idan ka nufin ka da wadanda tsarawa a wani yanki utm, a can ya zama babu canji domin ka zaton kana magana game da wannan latitud, don haka da lura ne m

  34. Sannu,

    Ina son wannan zayyanawa a fice, Ina da tambaya

    Yaya za'a yi amfani da shi lokacin da canjin canje-canje ya kasance?

    Gracias

    Juan

  35. mmm, aika mani rubutun da ka ambata cikin wasikun da kake da shi, don duba shi.

    Zan ga abin da yake a can

  36. impeccable !!! yanzu je 100%, Na yi amfani da shi kuma gaskiya ne! Na gode sosai, na kasance da amfani.

    Tambaya game da ita, tunda muna cikin matakan sarrafa kansa. Yin amfani da AutoCAD, bayan zana polygon na georeferenced, tare da sanannun madaidaicin UTM, abin da nake buƙata shine alamar sassan, ta yadda danna su yana ba su "lakabin" daidai, misali: 176.35.

  37. Yayi, Na riga na sanya nauyin 2 na fayil din mai girma. Dalilin shi ne cewa a cikin NE da SE zazzabi, an yi kuskuren kusurwar zuwa 90.

    Ka ba shi gwada kuma bari in san.

    Dole ku zama a fili, cewa ana amfani da ƙarin ƙirar ƙira a cikin haɗin UTM, zai canza adadin ƙima na seconds.

  38. mmm, yana da gaskiya, ina tsammanin na san yadda zan warware shi

    Zan duba shi lokacin da na dawo gida.

  39. Malamai mai daraja, na farko na gode don amsawa mai sauri, Na zo a kan lokaci!
    Ina gaya muku cewa ya taimake ni da yawa, na gwada shi, ko da yake ina so in bayyana shakka / shawara / damuwa: yana lissafin nisa sosai, yanzu kusurwa ya ba ni ƙarin, misali maimakon zama 88d13' 13 ", yana ba ni 1d21'47" !!! Dole ne ya zama ƙaramin daidaitawa kuma a nan muna! Na gode sosai don taimakon ku !!!

Deja un comentario

Your email address ba za a buga. Bukata filayen suna alama da *

Komawa zuwa maɓallin kewayawa