DB2 Version 9.7 for Linux, UNIX, and Windows

Spatial functions: categories and uses

This chapter introduces all the spatial functions, organizing them by category.

Spatial functions: categories and uses
Spatial functions that convert geometry values to data exchange formats
Constructor functions
Conversion to well-known text (WKT) representation
Conversion to well-known binary (WKB) representation
Conversion to ESRI shape representation
Conversion to Geography Markup Language (GML) representation
Functions that compare geographic features
Comparison functions
Functions that check whether one geometry contains another
Functions that check intersections between geometries
Functions that compare geometries' envelopes
Functions that check whether two things are identical
Function that checks for no intersection between two geometries
Function that compares geometries to the DE-9IM pattern matrix string
Functions that return information about properties of geometries
Function that returns data-type information
Functions that return coordinate and measure information
Functions that return information about geometries within a geometry
Functions that show information about boundaries, envelopes, and rings
Functions that return information about a geometry's dimensions
Functions that reveal whether a geometry is closed, empty, or simple
Functions that identify a geometry's spatial reference system
Functions that generate new geometries from existing geometries
Functions that convert one geometry to another
Functions that create new geometries with different space configurations
Functions that derive one geometry from many
Functions that work with measures
Functions that create modified forms of existing geometries
Function that returns distance information
Function that returns index information
Conversions between coordinate systems