Spatial data types

When you enable a Db2 subsystem for spatial operations, IBM® Spatial Support for Db2 for z/OS® provides the database with seven distinct geometry types.

Six of these geometry types are instantiable, and one is abstract.

The six instantiable data types are ST_Point, ST_LineString, ST_Polygon, ST_MultiPoint, ST_MultiLineString, and ST_MultiPolygon.

The data type that is abstract, or not instantiable, is ST_Geometry.

Spatial data types include support for the following:
  • Data types for geographic features that can be perceived as forming a single unit; for example, individual residences and isolated lakes.
  • Data types for geographic features that are made up of multiple units or components; for example, canal systems and groups of islands in a lake.
  • A data type for geographic features of all kinds.