GPS / TaputapuMicrostation-Bentley

Microstation: Kawemai i nga Coordinates Excel me nga Whakakitenga

Ko te take: Kei a au nga raraunga i whakatupuria ki te Promark 100 GPS, me te whakamahi i te tono a te GNSS ka tukuna mai e enei rorohiko, ka taea e au te tuku atu i nga korero ki Excel.

Ko nga pou e tohuhia ana i te kowhatu kowhai, ko nga taatai ​​i te rawhiti, i te raki, me o raatau whakahuatanga; ko te toenga ko te korero anake e pa ana ki te tukanga pou.

Ko te Problem: Kei te hiahia ahau ki nga kaiwhakamahi me o ratou putanga o Microstation kei te kawemai i te raraunga.

Nui ake te mahinga rorohiko

Nga huarahi iti o te mahi

Ki te kawemai koe i nga taunga ki te Microstation me te whakahau mo tenei, ko nga tohu anake ka tae mai, kaua ko nga tapanga. I te wa roa, he kaiwhakamahi i te kawemai i a ia mai i te CivilCAD he mea whakamiharo, mai i te Microstation ka whakatuwherahia ka huri ki te tira koinei te whakatakotoranga e mahi ai ratau i nga ra whakakai. Na… ahakoa kua tata ahauHe pai ki ahau i paatai ​​mai koe ki ahau mo tetahi whakaaro me pehea e mahi ai; ahakoa te hohonu o taku whakaaro ka mahia e ratau hei tohu ko nga whakahau kaore i te waikura. Koina noa iho nga tikanga i whakaaturia e au i mua me AutoCAD.

Me pehea te whakahoahonohono i nga hononga ki Excel

e hanga VBA he pai, engari rite mua ra kotahi ki ta tatou e faaoti: kia hua ake i te ki te hanga tepu pūtea moni, i konei te tikanga whakakotahi whakahau Microstation (matua i roto i) ki te whakahau Excel Excel (whakaemi)

Ko te hanga i tetahi tohu me te Microstation ka mahia ma te whakahau "wahi waahi", a ki te hiahia koe ki te tuu ki tetahi taunga motuhake, whakamahia te "xy=", me te whakamahi i te whakawehe whakahau ko te tohutoro (;). Na, ma te whakauru i te whakahau wahi tohu; xy = 388218.835,1566315.816 me tohu koe i tetahi tohu i roto i taua whakaritenga.

I roto i te keehi o Excel, he penei te tikanga o te whakahau whakakao: whakahau whakakao, tuwhera panui, ka tohu i nga mea katoa ka whakakao, ka kati ka kati. He whakamarama taku whakamarama, engari kaore i te uaua ka maarama ana ka mahia ana i te wa kotahi:

Whakatau Whakatau = KAUPAPA ka whakatuwherahia e mätou ngä whänau ( na ko te whakahau commando he kuputuhi, me te tohu e wehewehe ana i te whakahau "wahi wahi;" ka tohatohahia te aho e whai ake nei , ko te whakahau i roto i nga korero ka rite ki te tuhinga “xy=" te tohu ki te tohu i te aho hou , a konei ka tohua e matou te pūtau rerekē  C3 katahi ka tohuhia te tohu ki te tohu hou , me te tohu i roto i nga korero mo te wehewehenga o nga whakaritenga "," te tohu ki te tohu i te aho e whai mai nei , pūtau kei roto i te raki te ruruku me te haurua whakamutunga D3,“;” katahi ka kati i nga reu )

Ka penei:

=CONCATENATE("wahi tohu ;", "xy ="C3, ","D3, ";")

Kia oti tenei, ka tuhi noa matou i te ture ki nga pou e whai ake nei, penei:

wahi tohu; xy = 388218.835,1566315.816;
wahi tohu; xy = 388219.911,1566320.28;
wahi tohu; xy = 388216.28,1566320.868;
wahi tohu; xy = 388215.36,1566316.473;
wahi tohu; xy = 388211.706,1566317.245;
wahi tohu; xy = 388212.713,1566321.593;

 

Me pehea te tuku atu ki te Microstation

Ka taea te kape me te whakapiri tika i tenei kuputuhi ki te raina whakahau (whakauru whaitake i roto) me te kite kei te tuhia nga tohu.

Nui ake te mahinga rorohiko

Engari ka taea ano e au te kape ki tetahi kōnae txt, csv ranei ka taea e au te karanga hei tuhinga.

Hei tauira, ka karangahia te kōnae glowpoints.txt, a kei te rongoa ki C; no reira ka karanga koe ka tuhia te ki i roto i  @c: \ glowpoints.txt. Kaua te ingoa e whai waahi, a ko te mea pai me waiho ki tetahi ara ngawari.

Te kawemai i nga tuhinga

E mahi ana i te ara ano, me te rereketanga ehara i te whakahau te tohu engari te kuputuhi kuputuhi:  tuhia te tohu kuputuhi

Concatenamos o te ahua rite, te tohu tuhinga kuputuhi whakahau, te pūtau e mau ana i nga korero, nga whakariterite hei whakatakoto i te tuhinga:

=CONCATENATE(“tohu tohu tohu ;”,B3,”;”,”xy=”,C3,”,”,D3,”;”)

Na me noho tonu taua ara.

tuhi tohu kuputuhi; 10; xy = 388218.835,1566315.816;
tuhi tohu kuputuhi; 11; xy = 388219.911,1566320.28;
tuhi tohu kuputuhi; 12; xy = 388216.28,1566320.868;
tuhi tohu kuputuhi; 13; xy = 388215.36,1566316.473;
tuhi tohu kuputuhi; 14; xy = 388211.706,1566317.245;
tuhi tohu kuputuhi; 15; xy = 388212.713,1566321.593;

Kei reira ano hoki:

Nui ake te mahinga rorohiko

Hei whakaputa i te whakawhiti, he pena ano te mahi, engari me te raina raina whakahau, me te tupato me whai ahei nga tohu; ehara tenei i te keehi. Ko te raina waahi tono, tiimata te taunga, te taunga whakataunga ...

Papu kei reira ano etahi atu huarahi hei mahi, me te tuwhera papatono kaupapa mahi he mahi whakamiharo. Engari he pai te mahi whakangungu hei whakatikatika i taku hinengaro, ki taku keehi, aukati i aku whakahau kei waikura.

Ko Golgi Alvarez

Kaituhi, kairangahau, tohunga mo nga Tauira Whakahaere Whenua. Kua uru atu ia ki te kaupapa whakaaro me te whakatinanatanga o nga tauira penei: National System of Property Administration SINAP in Honduras, Model of Management of Joint Municipalities in Honduras, Integrated Model of Cadastre Management - Registry in Nicaragua, System of Administration of the Territory SAT in Colombia . Ko te Etita o te blog matauranga Geofumadas mai i te 2007 me te kaihanga o te AulaGEO Academy e nui atu i te 100 nga akoranga mo nga kaupapa GIS - CAD - BIM - Digital Twins.

Tefito pā

6 Comments

  1. Kaore au i te waahi o te papatono, engari me whakauru koe i te whakahau katoa, penei i te RAIRANGA KAIPAPA.

    He waimarie pai.

  2. Kia ora e hoa, tino pai nga korero, kua taea e au te whakaora me te pai ake ki te whakaoti i nga ahuatanga i whakaaro ahau kaore e taea te mahi i roto i te microstation, he patai taku e pa ana ki te kaupapa i korerohia e koe i runga ake nei, me pehea taku kawemai i te porowhita hei utu mo te tohu hei tohutoro pai? I mahia e au nga mahi katoa i whakahuahia i runga ake nei ma te whakamahi hei tawhā: =CONCATENAR (“wahi porowhita;…..) katahi ka haria ki te .txt a muri iho ka mau ki roto hei @d:\circulo.txt, engari kare ano ahau i tae. Ka taea e koe te tuhi kauwhata, ka taea e koe te awhina i ahau mo tenei kaupapa?

    Mauruuru.

  3. Kia ora, Ata mai, e hiahia ana ahau ki te mohio mena he akoranga taau, he tuhi ranei taau mo te mahi i muri i te tukatuka mo te 200 gps whakatairanga i roto i te kaupapa rongoa GNSS? He maha nga ra e tarai ana ahau engari kaore i taea e au na te mea ka whiua e nga GPS he momo konae .csv ... Ka tatari au mo o whakautu whakautu.

  4. He pai, he pono, kei te kii atu ahau ki a koutou, kaore te hunga i wikitoria i haere mai ki te wananga a i taku taenga atu ka hiahia ahau ki te whakamoemiti ki a raatau ma ta raatau awhina, engari kua whakarerekehia e raatau etahi atu mea, a i mataku ahau ki te patai atu ki a raatau me pehea te mahi. He pai kei te tautoko tonu ia i a taatau no te mea ko ia tonu te rangatira o tenei mahi, kaore hoki au i mahi ma te whakamatautau i mahia e au na te mea i kite ahau he iti noa te mohio o ratau ki te whakahoki mai me mahi ma te taangata engari ko nga tangata katoa i te awheawhe i miharo ...

    Ka awhina tenei ki a matou ki te whakaputa i te kaha ake i roto i nga mano o nga mahi ka taea te mahi ki te PC, engari he waahi tonu te aratohu ki te ako ki a raatau.

    i te taha o te hunga hangarau KAUTAKI koe, no te mea ka taea e au anake te mea he kuku ahau a guaoooo.

Waiho i te tākupu

Ka kore e whakaputaina tō wāhitau īmēra. Kua tohua ngā āpure e hiahiatia ana ki *

Hoki ki te pihi papa