ST_IsValid

ST_IsValid takes a geometry as an input parameter and returns 1 if it is valid. Otherwise 0 (zero) is returned.

A geometry is valid only if all of the attributes in the structured type are consistent with the internal representation of geometry data, and if the internal representation is not corrupted.

If the given geometry is null, null is returned.

Syntax

Read syntax diagramSkip visual syntax diagramdb2gse.ST_IsValid(geometry)

Parameter

geometry
A value of one of the seven distinct spatial data types that represents the geometry that is to be tested.

Return type

INTEGER

Example

This example creates several geometries and uses ST_IsValid to check if they are valid. All of the geometries are valid because the constructor routines, such as ST_Geometry, do not allow invalid geometries to be constructed.
SET CURRENT  PATH = CURRENT PATH, db2gse 
CREATE TABLE sample_geoms (id INTEGER, geometry ST_Geometry)

INSERT INTO sample_geoms VALUES
       (1, ST_Geometry(ST_Point('point EMPTY',0)))

INSERT INTO sample_geoms VALUES
       (2, ST_Geometry(ST_Polygon('polygon((40 120, 90 120, 90 150, 40 150, 40 120))' ,0)))

INSERT INTO sample_geoms VALUES
       (3, ST_Geometry(ST_Multipoint('multipoint m (10 10 5, 50 10 6, 10 30 8)' ,0)))

INSERT INTO sample_geoms VALUES
       (4, ST_Geometry(ST_Linestring('linestring z (10 10 166, 20 10 168)',0)))

INSERT INTO sample_geoms VALUES
       (5, ST_Geometry(ST_Point('point zm (10 10 16 30)' ,0)))


SELECT id, ST_IsValid(geometry)  Is_Valid
FROM sample_geoms
Results:

ID          IS_VALID
----------- -----------
          1           1
          2           1
          3           1
          4           1
          5           1