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!

Validate geometry

911831Aug 19 2012 — edited Aug 21 2012

Hi,

According to the white paper about Spatial best practices :

"Spatial data *must be valid to ensure correct results when you perform spatial analysis.* If an SDO_GEOMETRY column is spatially indexed, Oracle will perform some validity checks when spatial data is inserted into the column. But complete validation only occurs by running either the SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT or SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT procedure."

it's sounds that VALIDATE_GEOMETRY_WITH_CONTEXT is mandatory only for spatial analysis purpose.

My question is, if for a spatial table I never perform spatial analysis, is it mandatory to run VALIDATE_GEOMETRY_WITH_CONTEXT on that table ? I will use this table to feed a WMS service, so what will be the impact of invalid geometries on the WMS service ?

Thanks

Charles

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2012

Added on Aug 19 2012

#database-key-features, #spatial

4 comments

2,093 views