• Replies 3 replies
  • Subscribers 58 subscribers
  • Views 1740 views
  • Users 0 members are here

Geometry type of view in Oracle Spatial

Jakob Worm

Hi,

I've understood that Bentley Map reads the spatial index to determin the geometry type ie. point, line og polygon of a table in oracle. Now what's going on with views? Belowe is two screen shots. One of the view afl_broend which is a view on the table gis_drain_wells. afl_broend incorrectly is shown as a area feature (or collection?) and gis_drain_wells is correctly shown as a point feature. Can I force afl_broend to be interpreted as a point feature with the point symblogy options that gives ie. point, cell, text?

 

 

Parents
  • Offline

    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?

    Regards,

    Jeff Bielefeld [Bentley]



  • in reply to Jeff Bielefeld

    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

Reply
  • in reply to Jeff Bielefeld

    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

Children
  • Offline in reply to Jakob Worm

    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

Communities
Support and Services
Training and Learning
Social Media