Generate a Spatial Data Object Definition in Standard Text Format

You can use the function GeometryAsText() to convert the longvarbinary values of the geometry column into Well-Known Text (WKT) format.

The function GeometryAsText() is also useful to troubleshoot when a specific shape isn’t being represented in the visualization.

This example shows the usage of GeometryAsText().

Description of the illustration maps_geodatatype_calc_onecol_geometryastext.png

This example shows the standard format of the Storm Buffer geometry column.

Description of the illustration maps_geodatatype_calc_onecol_geometryastext_stormbuffercol.png

You can also use standard calculation functions along with GeometryAsText(). For example, you can use the string function Length() to calculate the size of a shape, which is useful when identifying if a shape is beyond the acceptable limit of 128 kilobytes.

Usage: Length(GeometryAsText(Geometry_Column)) returns the size of the geometry shape in bytes.