Transform groups

Spatial Extender provides four transform groups that are used to transfer geometries between the database or warehouse and a client application.

These transform groups accommodate the following data exchange formats:
  • Well-known text (WKT) representation
  • Well-known binary (WKB) representation
  • ESRI shape representation
  • Geography Markup Language (GML)

When data is retrieved from a table that contains a spatial column, the data from the spatial column is transformed to either a CLOB(2G) or a BLOB(2G) data type, depending on whether you indicated that the transformed data was to be represented in binary or text format. You can also use the transform groups to transfer spatial data to the database.

To select which transform group is to be used when the data is transferred, use the SET CURRENT DEFAULT TRANSFORM GROUP statement to set the CURRENT DEFAULT TRANSFORM GROUP special register. The value of this special register determines which transform function is called to perform the necessary conversions.

Transform groups can simplify application programming. Instead of explicitly using conversion functions in the SQL statements, you can specify a transform group to implicitly apply the conversion.