Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 10.1.0.4 SDO_GEOMETRY and ArcSDE 9.1 SP1

491421Apr 10 2006 — edited Apr 18 2006

We are having a few of issues that I'm hoping someone can shed some light on.

1) In SDE.SPATIAL_REFERENCES table when using SDO_GEOMETRY is it normal to get two instances of a spatial reference one with the ESRI coord sys string and one with the Oracle coord sys string?

2) When zooming in on the sdo_geometry layers some features are not displayed. We have rebuilt the spatial index and analyzed the table with no change. Any other suggestions?

3)We ran sdo_validate_layer_with_context on the above layer and it returned a number of entries with incorrect rotation. Is this the cause of the disappearing features - if so is there a function to automatically reorder the coordinates? If loading from sde to sdo_geometry is this a normal issue?

4)We are having issues loading data from sde to sdo_geometry that includes true curves. It's strange but if the geometry count (number of rings) is odd then the features will not load. Oracle Spatial supports the curves drawn in ArcGIS right? Has anyone else seen this issue?

Thank you for any help that can be provided.

Stephanie

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2006

Added on Apr 10 2006

#database-key-features, #spatial

3 comments

917 views