Modified well-known text representation

The HCL® OneDB® 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.