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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms