OpenCities Map and Map Connections Dialog issues
Hello,
we use the Map Connections Dialog to query and post Oracle data from a configured graphical source.
The workflow looks like: query data > lock for edit > edit > post back.
Since there are cases where we need to edit a bunch of datasets (like…
Unable to post Oracle Spatial data received error ORA-13011 Value Out of Range
Explanation: If you are unable to post Oracle Spatial data features and received error as :
Error Inserting Feature (class: spatial_table_name, id: 2020)
Invalid geometry for table spatial_table_name, column GEOMETRY.
Oracle details: A specified…
Unable to query Oracle Spatial data using fence received error ORA-06512
If querying oracle spatial data using a fence throws error as
ORA-29902: error in executing ODCIIndexStart() routine ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line…
Is there in the GSA a macro to storing Oracle connection parameters....
Hey Guys!!!
Is there in the GSA a macro to storing the parameters of a Oracle connection or something like this?
I'm using Bentley Map SS3 and Oracle 11g
Thanks!!!
Posting To Oracle error ORA-24801
Hi,
I trying to post my feature to Oracle and i have this error:
Error Inserting Feature (class: OC_NUM_AQU_REGARD_P, id: 30357812) InsertRow: ORA-24801: valeur de paramètre non valide dans la fonction lob OCI
Any ideas? Other than removing my CLOB…
Data Streaming with deleted data
Hi,
When i have a feature in mode "data streaming"=true. If i PAN, i see all new feature created by other user on my Oracle. It's ok.
But the datastreaming did not remove the feature who are deleted by other user on my Oracle.
What is the…
- Concatenate properties to populate new property using Property Watcher
This article describes how to concatenate the values of two properties to create a third. For example, you may want to capture an asset tag property that must be entered as nn-nnn. To accommodate this, Left and Right properties are defined which are filled…
- Queries are not undoable
The MicroStation Undo command has no record of spatial queries in Bentley Map. For this reason, there is a built-in warning dialog that displays when you perform a spatial query that reads:
Selecting the “Don’t’ show this message again” option…
Spatial Databases
- 3D arcs being stroked when posted and queried
- Angle of queried point feature is wrong
- Conflict Inspector
- Convert DGNs with MSLinks to MS SQL Server Spatial via FME
- Creating a Map schema for Spatial Features
- Create domain lists in…
RE: Draw multi part polygon in Bentley Map.
Kiran,
If the Oracle Spatial multipolygon layer was registered as a "Polygon Collection" feature class then you should be able to perform the following:
In the Bentley Geospatial Administrator right click on the polygon collection feature class…
RE: How to set the scale based visibility for a layer in Map Manager?
Kiran,
In the Map Manager you can perform the following:
Right-click your feature class and select the "Symbology..." option.
In "Symbology" dialog choose "General > Thematic Definition set > User defined 1" option.
In "Symbology" dialog choose…
RE: [BM SS4] What happens to User Data Linkages?
Bruce,
Please zip up and send me via private message...
Your modified MVBA file.
A sample design file containing the original MicroStation shape elements.
A current copy of your Bentley Geospatial Administrator schema file.
...and I will…
How to view the data in History table?
Hello,
We have the requirement of viewing data of a History view of a version enabled table in Oracle Spatial. Let me explain it in a bit details.
We have one table, say LAND_LOTS.We enable the versioning on it using Oracle Workspace Manager as below…
RE: Bentley Geospatial Administrator (version 08.11.09.91) Database problems
Keith,
Create your new Named Connection using the Oracle Spatial Connection node in the Graphical Sources section of the GSA Schema. You should be able to ignore the previously-created connection.
A defect had been filed against the inability to remove…
RE: Oracle spatial join with external database
Jun,
This ability to define this type of join has been added to the pending Bentley Map V8i (SELECTseries 4) 08.11.09.4xx release. I would suggest that you download and test the beta.
- Oracle views in spatial feature definitions
Purpose
The purpose of this entry is to describe the design of Oracle Views for the definition of spatial features used by Bentley Geospatial products ( ie Bentley Map, Bentley Electric, Bentley Gas, Bentley Water, GeoWeb Publisher, and the Oracle…
Re: gdi explorer and vba
Stefan,
As mentioned, the Bentley Map V8 i (SELECTseries 2) 08.11.07 release provides the new Interoperability API services, documented in the ...\Bentley \Documentation\GeoDataInterchangeAPI.chm help file. The " gdi connect " keyin is also new to…
Re: Defining Annotation table for PBA
Veeresh,
First regarding the use of composite primary keys for annotation, you're correct that capability used to work. However when the ability to support arbitrary-depth features in Bentley Map was added for Oracle Spatial persistence, subfeatures…
Re: Multi Polygons
Keith,
For sure, if you post an unexpected geometry type it will result to an error; database won’t accept it. I suppose some change most be made in Oracle Spatial database first to force Map to work with simple geometry. Unfortunately, i cannot go…
Re: Strip XFM data from features interactively or via code
Gerald,
In Bentley Map today, there does not exist any user level type command that strips intelligence and linkages from an XFM native feature instance. There are however some ways to achieve this result using the Bentley Map API using C or C++ native…
Re: Gdi import from oracle spatial ommits compound polygons geometry (gtype=1003,elem_info=1005)
Jiri,
For the following compound geometry...
SHAPE(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES) --------------------------------------------------------------------------------------------------------------------------…
Export Shapefile in MS - Attribute names to 10 chars restricted?
Hi everyone,
i was trying to export my XFM-Data from a DGN to a Shape file via the Interoperability tool in Microstation v8i 08.11.07.443 (with Bentley Map extension). That worked so far as a Shape with a dbf file was created, but the names of my XFM…
Updating area/perimeter/length on Oracle Spatial
Is there a way to use the Area/Perimeter and Length Update tools from the Database Operation toolbox if the data is queried from Oracle Spatial? Currently, when I try to use the tool I get the message "SELECT statement returned no rows", and I can only…
Re: Cell Angle in Geospatial does not seem to have any effect when placing a point
...will also add that Bentley Map supports the use of Oracle oriented points described here to persist the rotation of the feature instance.
Re: Memory issues
Greetings Veeresh,
Have you any custom code involved or are you only using standard Interoperability functionality? Could you provide the exception.log that was generated?