My Oracle Support Banner

How to validate and rectify a MULTIPOLYGON (Doc ID 1951549.1)

Last updated on DECEMBER 05, 2014

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

Goal

Given a MULTIPOLYGON, how do you validate, and rectify the geometry if it is INVALID?

MULTIPOLYGON (
    ((-87.65334677793656 41.853938059885635,
      -87.65336199195337 41.89213567529204,
      -87.60224000804665 41.89213567529204,
      -87.60225522206346 41.853938059885635,
      -87.65334677793656 41.853938059885635)),
    ((-87.66539803179322 41.86294071488337,
      -87.6654132527484 41.90113827019948,
      -87.61428408881292 41.90113827019948,
      -87.6142993097681 41.86294071488337,
      -87.66539803179322 41.86294071488337)),
    ((-87.65335394622579 41.87194461957184,
      -87.653369174124 41.91014211478727,
      -87.60223282587604 41.91014211478727,
      -87.60224805377423 41.87194461957184,
      -87.65335394622579 41.87194461957184)),
    ((-87.64130269023192 41.86294071488337,
      -87.6413179111871 41.90113827019948,
      -87.59018874725163 41.90113827019948,
      -87.59020396820681 41.86294071488337,
      -87.64130269023192 41.86294071488337)))

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.