Samun Bayani mai Mahimmanci daga BentleyMap
Wadannan su ne misalin ayyukan da za a iya yi ta amfani da Microstation BentleyMap don sarrafa bayanai daga wani asusun OracleSpatial.
Shigar da Client Oracle
Ba lallai ba ne a sanya Oracle a kwamfutar. Abokin ciniki kawai, a wannan yanayin ina amfani da 11g R2. Sabanin lokacin da aka yi amfani da shi Microsation Geographics, Ba lallai ba ne don ayyana igiyar haɗin kan abokin ciniki, saboda a can ya yi aiki sosai ta amfani da mai haɗa ODBC. Game da BentleyMap, ana ayyana layin haɗin a cikin VBA don kada a shiga, an adana shi a cikin fayil xml ko an shigar da shi a cikin allon yayin yin haɗin.
Haɗa zuwa ga bayanai
Don haka dole kuyi:
Fayil> hulɗar taswira
Wannan yana ƙirƙirar shafin a cikin ɓangaren gefe, wanda shine abin da ke ba mu damar yin haɗi zuwa bayanai daga tushe daban-daban. Game da BentleyMap, zaku iya samun damar haɗin Oracle, SQL Server da sabis na WFS daga nan.
Abin tausayi cewa babu wata dangantaka da PostGIS.
A cikin babban fayil Haɗin, danna-dama ka zaɓi Sabon Haɗa Oracle ...
Wannan rukuni ne, inda dole ne mu shigar da mai amfani, kalmar wucewa da adireshin sabis.
Idan akwai damar shiga ta tashar jiragen ruwa, wanda yawanci shine 1521, da kuma mai watsa shiri da sabis na nesa inda aka buga shi.
Abubuwan haɗi na haɗi za a iya adana su azaman xml ɗin fayil mai tsawo, sqlx ko wfsx don kira ba tare da shiga cikin filayen ba.
Yi shawarta da kuma gyara bayanin
Da zarar an kirkiro haɗin, ana nuna nau'ikan da aka samo a cikin aikin, wanda za'a iya gani a cikin tsari na tsari da nau'in, ko ta hanyar jinsi na halayen da aka bayyana a cikin Geospatial Administrator.
Don bincika bayanai, ana amfani da icon a cikin nau'i na tabarau, wannan yana ba da damar nuna bayanin a cikin takarda ko a matsayin tsarin XML.
A cikin maɓallin dama na linzamin kwamfuta iri iri ɗaya ana nuna nau'ikan ayyuka na kayan aikin kayan aiki na sararin samaniya:
- Ana amfani da Querry don yin tambayoyin bayanai, ko dai daga nuni (Duba) ko daga wani tambaya, ko daga duk bayanan data kasance a cikin tsari na sararin samaniya.
- Ana amfani da gidan waya don ajiye canje-canje da aka yi zuwa lissafi.
- Kulle / buše don ba da damar yiwuwar yin canje-canje.
- Kashe Kayayyakin Kasuwanci yana ɓatar da bayanan ra'ayi
Idan kana so ka yi takamaiman tambaya, zaka iya sanya shi a filin Inda Magana, gwargwadon bayanan da abun ya kunsa. A wannan halin, Ina son kawai ƙananan ƙungiyoyi, waɗanda suke cikin aiki kuma waɗanda suke cikin sashin 0006 na Sashin 08 da Municipality 01. Tambayar ita ce:
KASHE = 0 DA CODDEPARTAMENTO = 08 DA CODMUNICIPIO = 01 DA SECTOR = 0006
Yana da mahimmanci a fahimci cewa BentleyMap yana yin gyare-gyare na asali, don haka yiwuwar bala'i yana cikin ƙarancin kulawar tsaro. Wajibi ne a fito da matsayin masu amfani a sarari, wajen sarrafa sigar da zaɓuɓɓuka don dawo da bayanin da aka share bisa kuskure. Gabaɗaya mutane ɓatattu ne kuma suna rikita abin da ke kulle tare da buɗewa.
In ba haka ba, yana da ban mamaki, la'akari da cewa yana da duk ƙarfin software na CAD. Yi ya ce dole ne ku Yi amfani da VBA don samun mafi alhẽri ga kayan aiki da kuma yadda za a gudanar da haɗin gwiwar.