Spatial (MOSC)

MOSC Banner

Querying invalid geometries

edited Apr 2, 2012 9:57AM in Spatial (MOSC) 4 commentsAnswered
Back in Oracle 8i, the doco said that if a geometry was invalid it would not be indexed and hence would not be returned by a query.

We jumped from 8i to 10gR2 and didn't have too many problems.

We are now considering moving to 11gR2 and are considering the impacts of the strongly recommended approach to not have spatial data at a resolution higher than 5cm.  Our data is a higher resolution than that and consequently we have many (many many) invalid geometries if we set the layer up with that resolution (tolerance).  However, with the little bit of testing we have done so far, invalid geometries are being returned by queries.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center