Deleted

The issue is that the Oracle Spatial database is an ESRI Oracle Spatial database, and it's not clear whether it is SDE_BINARY or SDO_GEOMETRY-enabled. Can someone with experience using these two platforms together comment? What steps need to be taken to ensure the data can be queried with Bentley Map?

Theresa. If the geometry data is stored as SDE_BINARY, then Map can not read the geometry. SDE_BINARY is a ESRI proprietary format, and thus not open for other applications to interpret. If the geometry data is stored as SDO_GEOMETRY, then Map will have no problem reading the data.

To determine what format the data is stroed in you need to look at the ESRI spatial Database table look at the following line :

support.esri.com/.../38582

We use pure SDO. We do not use binary. We CAN query the data. We can register the data. The problem is that no matter what we try the data files will not show up in the viewport or only one file will appear in the viewport when there should be dozens.

There may be a mix of terminology here, so bear with me.

"No matter what we try the data files do not show up in the the viewport".

This sounds like you are doing a automated process to extract the data from the spatial database into 'files'. I suspect these are dgn files. Is the ProjectWise Oracle Spatial Connector involved here ? Is this assumption correct ?

If you are not using the ProjectWise Oracle Connector, then the usual workflow is to open a dgn file in Map, using the workspace created in the GSA, navigate to the Interoperability and connect to the registered Spatial database ( Oracle in this case). Log onto the spatial database and select the layers you wish to retrieve into the drawing. At this point you select one or more of the layers and 'query' the layer graphics into the drawing.

When in the GSA, you needed to define the graphics parameters ( level, color, weight, linestyle, etc.) to display in the dgn file. The geometry should display in the dgn file using these attributes you defined in the GSA.

Please let us know what environment you are in, that may assist in the resolution.
Thanks!

"If you are not using the ProjectWise Oracle Connector, then the usual workflow is to open a dgn file in Map, using the workspace created in the GSA, navigate to the Interoperability and connect to the registered Spatial database ( Oracle in this case). Log onto the spatial database and select the layers you wish to retrieve into the drawing. At this point you select one or more of the layers and 'query' the layer graphics into the drawing."

This is exactly the workflow we are using. (Not ProjectWise Oracle Connector.) We can see the registered features. We can import them, connect to them and query them. They simply will not appear in the view once we set a data point in the view after performing a query. In my case, one would appear, but not the others that were queried. Dan has my contact information--perhaps this would be simpler with a phone call and then I could post the results once we get it working?