Geometry type of view in Oracle Spatial

Hi Jakob,

AFAIK, in addition to inserting entries into user_sdo_geom_metadata, you must also define a primary key for your views so they would appear in the list of features to be registered. Have you done anything similar to the following?

alter view AFL_BROEND add primary key (YOUR_PK_COLUMN) disable;

Regards, Matti

Jeff,

I was communication unclear:

- afl_broend is a view of gis_drain_wells (create view afl_broend as select * from gis_drain_wells).

- Yes, as the view is basicly just a renaming of the table - no where clause or joins. Other than the definition above and the index' layer_gtype there is no garantee.

- Yes, layer_gtype is set to MULTIPOINT for the spatial index of gis_drain_wells - id actually expect it to be just "point". Not sure why its multipoint and not point.

- I use Bentley Map SS2 (standalone) v08.11.07.434

- "Register Feature Wizard" only shows me tables - no views - I'd expect it to give me all entries from mdsys.user_sdo_geom_metadata!? Views are registered in user_sdo_geom_metadata.

Regards. Jakob

Jakob,

A few questions.

• Do both views refer to the same base table?
• Is each view defined in such a way as to guarantee that all rows returned contain the same geometry type?
• For the AFL_BROEND feature class, what is the layer_gtype parameter defined for the index of the referenced table?
• What version and edition of Bentley Map are you using?
• Do you see similar behavior when you use the "Register Feature" process in the Bentley Geospatial Administrator application to create a graphical source?