This page outlines how records sourced from the oracle databases can be listed, sorted, searched and located geographically using the spatial tool box and the data browser in the Microstation V8i environment.
By using the spatial tool box, Oracle spatial Interoperability and data browsers, you can list, filter and locate records from an oracle database in the microstation V8i application environment. This document will demonstrate how to do this using the DCDB roads centrelines database as an example.
Please note that the more data that is enabled in your view, the slower Microstation will perform (especially if Imagery is attached to your document). Please ensure Imagery is dettached before proceeding
1. First open a dgn project that is set up to connect to the oracle database you wish to search records in.
2. Position the view in roughly the right location that you wish to search or locate records, select the oracle tables that you intend to query, click the query button on the spatial tool bar, select the 'View' option on the query window and click in the view (insert a link for details of this).
3. In the interoperability window, click the "Current Session" node, and check the 'Spatial Area' property to 'View', and ensure the right view is set also.
4. Now right click the table you wish search and select Preview. Only tables which have been enabled (ticked box) can be interogated.
5. All records of the selected table in your current view will appear in a data browser.
6. Now setup how you want your view to respond when you select a record in the data browser. First click the 'Zoom Preferences' button, and set the minimum zoom and zoom factor for the view. The minimum zoom is a value in the coordinate system of your dgn project and dictates HOW FAR OUT the view is able to zoom when locating records. The Zoom Factor is a propotion of the geometric size of the record/s you are selecting, a zoom factor of 1.5 means that the view will zoom to 150% of the size of your selected records.
The next step in this part of the process is to check which views will respond and zoom to the selected objects, do this by right-clicking in the data browser, goto the Locate>Automatic option and check the right view (View 1 in this case). You should only need to do this once per browser session, selected views will have a tick next to them in the list.
7. You are now ready to search for records using the browser. You can simply click on a record in the browser, and it will zoom to and highlight it in your view. Alternatively, you can use the control button to select multiple records, or click and drag the mouse over multiple records.
8. To filter the databrowser, right click in the fields pane at the top of the data browser and select 'Show Filters', a blank record will appear at the top of the browser, you can type your filter criteria for each column in this record space, click in the data space and the databrowser will refresh itself to show only those records that match your criteria.