Modified well-known text representation

The HCL Informix® software provides an additional modified well-known text representation for loading text strings directly into geometry columns without filtering the string through one of the Spatial DataBlade text functions. By placing the SRID in front of the text description, you can insert the resulting text string directly into a spatial column. The load statement in the DB-Access utility reads text files generated with this format and inserts the modified well-known text representation into the geometry columns.

To create a modified well-known text representation, remove the quotations and precede the text description with the SRID separated by a space.

For example, the well-known text representation of a point in the ST_PointFromText() function:

ST_PointFromText(‘Point zm (10.98  29.91 10.2 9.1)',1)

converts to:

1 ST_Point zm(10.98  29.91 10.2 9.1)

You can write the modified text string into a file and separate it from other column values by the standard delimiter.