I have been playing around with Bentley Map Enterprise v8i (SS2) with our Oracle Server. The tables on my Oracle server are built from MapInfo TAB files (using MapInfo EasyLoader Utility), and a script is run to fix the SRID and USER_SDO_GEOM_METADATA, so that BM can work with the tables.
For some reason BM isn't recognising my geometry types correctly. In the "Interoperability" dialog, it says every table has a Polygon Geometry Type.
I have checked the Geometry column, and the SDO_GTYPE seems to be correct. What else do I need to check?
Thanks Ian
I think that would be the best approach, or even if it defaulted to polygons but the user had the ability to change the geometry type in the GDI when it can't be discovered.
Glad to hear you made it work. In any case, a geometry-specific index cannot be bad. I took note that it would be better to let users define the geometry type in GDI when it can't be discovered automatically.
Martin
Thanks Martin and Jerry,
In this case I was going directly from BM and not using the GSA, when you go from BM you don't have the ability to specify the geometry type (as pointed out by Jerry). In this case I wanted to open the data directly from BM because it is not maintained by any of our Bentley products, and therefore I didn't want to include it in a GSA model.
I have also had some issues (with Bentley Water) not recognizing features when they have been registered with the GSA. And I have had to run through the registration process multiple times to get it to work. Unfortunatley, I haven't been able to consistantly re-create the problem, so I have no idea what it could be.
Again, thanks for your help. I have modified my scripts that upload my data to this Oracle server, and now the GTYPE is being included in the creation of the spatial index and this has fixed my problem.
Yea, but if he is not going thru the GSA and registering the features, then I beleive he will have to update the spatial index. I can't really tell from his screen shot if this is the case, but it looks like he is doing a direct connect and not going thru a project.
But I agree if Ian is going thru the GSA, to register features this would be a option.
Ian, just as a side note, I did a quick test and as far as I can see Map SS2 should ask you to specify the geometry type of a class in the register features wizard if it cannot automatically detect it. You should be able to specify the type there instead of changing your indexes if you prefer to leave them as they are.