Microstation Geographics, haɗa zuwa Database

Kodayake Geographics kyauta ne na Bentley, bayan Benley Map da Cadastre suna nan don zama, a nan akwai wasu bayanai ga dalibi wanda yake so ya haɗa wani bayanan kan taswirar Geographics.

Daga batutuwa da suka gabata

A wani matsayi na bayyana a gaban yadda wasu guts na Geographics ke aiki, wannan taƙaitaccen kusan shigarwar 15 ya nuna cewa na ji daɗi sosai.

1. Littafin alama
2. Ƙaddamarwa
3. Tsarin tsaftacewa
4. Haɗin haɗin
5. Topological bincike
6. Haɗa aiki na gida
7. Shigo da fayilolin siffar
8. Ƙirƙiri grid
9. Wasu bambanta tare da Bentley Map
10. Ƙaddamar da VBA
11. Differences tare da Cadastre
12. Yi tafiya zuwa Bentley Map
13. Kyafaffen da G! Kayan aiki
14. Karin misalai

Abin da ke faruwa shi ne cewa Geographics ya kasance koyaushe haka ne, software da dole ne sanannun abubuwan shan sigari su aiwatar da ita a matakin mai gudanarwa. Duk da yake masu amfani dole ne su koyi yin abubuwan yau da kullun don amfani da shi, amma duk da haka kayan aiki ne duk da cewa Bentley baya amsa tallafi, amma har yanzu masu haƙƙin haƙƙin waɗanda ba sa so su bar shi ya kare haƙƙin haƙori da ƙusa.

Abin da za a haɗa

Ana iya haɗuwa da yanayin ƙasa zuwa aƙalla Oracle, SQLServer ko Bayanan Samun dama, zai fi dacewa ta hanyar ODBC, kodayake ba su ne kawai keɓaɓɓun bayanai ba ko kuma yanayin haɗin haɗi kawai. An ƙirƙiri haɗin, kamar yadda na yi bayani a cikin abu na 6 na jerin da suka gabata.

Abin da za a haɗa

Geographics, a cikin wadannan sifofi suna aiki ta hanyar haɗin haɗin haɗi (haɗin haɗakarwa), wanda zai iya zama layi, aya, tantanin halitta, ko polygon. Wannan haɗin yana aiki kamar haka:

• Abinda ke haɗi dole ne a kan taswirar, ƙira da lambar tab na nau'in 425876.
• MsLink yana da lambar da ba a maimaita akan taswira ba kuma an haɗa shi da zarar an haɗa abu zuwa cibiyar.
• MapID yana da lambar da ta haɗu da layi tare da taswirar rijista, don haka za'a iya maimaita MsLink daga wannan taswira zuwa wani, bambanci yana cikin lambar rijistar taswira, batun da na bayyana a sashi na 12 na jerin saman.
• Da zarar an haɗa shi, yana yiwuwa a duba wasu tebura a cikin bayanan cikin Geographics, kamar rajistar mai karɓar haraji, ƙimomin ƙa'idoji ... Kuma tare da waɗannan, gudanar da ayyuka kamar nazarin yanayin ƙasa, taswirar jigogi, bayani na taswira, da sauransu.

Da bayanai

• Domin yin hulɗa tare da aikin Geographics, dole ne bayanan ya ƙunshi waɗannan allon:

category
alama
mapsmscatalog
ugcategory
ugcommandugfeature
ugjoin_cat
ugmap
ugtable_cat

• Bugu da ƙari, teburin da kake so ka haɗa, kamar rajista na cadastral (zaton an kira shi tab) ya kamata a saka ginshiƙi mai suna MsLink a ciki, yayin da nake rubuta shi, tare da M da L a cikin babban rubutu. Kuma wannan dole ne ya kasance na nau'in keɓaɓɓu ne, don haka duk lokacin da aka ƙirƙiri sabon kati ana sanya masa lambar da ba za a maimaita ta ba.
• Dole ne a kara ginshiƙai masu zuwa a teburin:

Area, sunan wadannan ginshikan bashi da matsala, menene ma'ana shine ya zama adadi ne da wurare goma. Wannan zai kasance don sabunta yankin kadara a cikin rumbun adana bayanai.

Yanayi, kamar wanda ya gabata, don adana darajar jimlar gado na kayan.

x1, y1, x2, y2. Waɗannan ginshiƙai huɗu ne inda za a adana abubuwan haɗin da ke ayyana kewayon kayan, kuma wanda zai zama da amfani don zuwa dukiyar (gano wuri) an zaɓa, kamar dai don buga shi a Geoweb Publisher.

• Bayan haka, a cikin rumbun adana bayanai, a cikin teburin mscatalog ya zama dole a hada da teburin yin rajistar kuma a sanya mata mai ganowa. Wannan don ana iya ganin teburin daga Geographics a mataki na gaba kuma za'a iya yin rijista a cikin kasidar.

Taswirar

• Dole ne a yi rajistar taswira, an yi wannan daga Shirin / kafa / rijistar taswirar / fayil din. Tare da wannan, taswirar tana samun lamba a teburin ugmaps.
• Dole ne kuma a ƙirƙira teburin da aka halitta daga labarin ƙasa. Don wannan dole ne ku je Taswira / saitin / tebur / kundin tabbacin. Anan aka ƙirƙira shi, sanya TICKET a cikin suna, MSLINK (babban harufa) a cikin maɓallin farko da kuma sunan laƙabi, a wannan yanayin FC. Sannan Shaida. Da wannan, a shirye muke muyi kwarkwasa.

Hanya

Abubuwan za a haɗa su zuwa filin a teburin tab, ta mslink a matsayin maɓalli na ainihi kuma bisa ga wasan da shafi key_fiche.

Dole ne a sami wasa na musamman tsakanin abin da za a haɗa shi (bari mu ɗauka lamba ta alama akan taswirar) da kuma mai ganowa a cikin rajistar. Yana iya zama lambar fayil ko maɓallin cadastral, amma bai kamata a maimaita shi a kan taswira ɗaya ba.

Don haɗi, a shingesa'an nan Database / mai sarrafa rubutu. Mun bar matakin lambar guntu kawai, don ci gaba zuwa gasar. Sannan zamu zabi sunan teburin da muke son hadawa da kuma shafi wanda yake dauke da wasan. A wannan yanayin, teburin Tab da shafi key_fiche.

Kunna zaɓi Yi amfani da Fence, mun zabi maɓallin Join kuma mun danna kan allon.

• Shirya, Gegraphics nema duk waɗannan sassan lambar katin a taswirar, wanda ya dace da lambar katin database a teburin tab da kuma shafi key_fiche. Kuma ya yi kwarkwasa ta cikin mslink auto-lambar data kasance a cikin wannan shafi. Hanyar gwada shi ta amfani da umarnin sake duba halayen, ya kamata ka dauke da teburin da aka hade.
• Don sabunta yankin da kewaye, matakan suna aiki ko fasaloli na kan iyakokin ƙasa da toshewa, da sigogin ƙasa. To an gama Database / yankin yanki u
  ddate.
• Don sabunta daidaito, Database / daidaitawa sabuntawa.
• Saka shi ne ƙirƙirar sabon rikodin a cikin database, update don yin sabuntawa.

Na sani, kuma ina sane. Yanzu kun fahimci dalilin da yasa waɗannan abubuwan suke sarrafa kansu ta hanyar kayan aikin VBA ...

Koyaya, koyan dabarun aikin motsa jiki ne wanda ya inganta wani ɓangare na kwakwalwarmu. Da Geospatial Administrator Har ila yau yana da ɗakunanta.