ST_ParseWKT(VARCHAR(128), LONG VARCHAR) method

Syntax

ST_SpatialRefSys::ST_ParseWKT(VARCHAR(128) element, LONG VARCHAR srs_text)

Parameters

• element – The element to retrieve from the WKT. The following named elements may be retrieved:
  • srs_name

    The name of the spatial reference system

  • srs_type

    The coordinate system type.

  • organization

    The name of the organization that defined the spatial reference system.

  • organization_id

    The integer identifier assigned by the organization that defined the spatial reference system.

  • linear_unit_of_measure

    The name of the linear unit of measure.

  • linear_unit_of_measure_factor

    The conversion factor for the linear unit of measure.

  • angular_unit_of_measure

    The name of the angular unit of measure.

  • angular_unit_of_measure_factor

    The conversion factor for the angular unit of measure.

• srs_text – The spatial reference system definition text

Returns

LONG VARCHAR Retrieves a named element from the WKT definition of a spatial reference system.

Examples

• Example 1 – The following example returns a result with one row for each of the named elements.

  with V(element,srs_text) as (
  SELECT row_value as element, 'GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]' as srs_text
  FROM sa_split_list('srs_name,srs_type,organization,organization_id,linear_unit_of_measure,linear_unit_of_measure_factor,angular_unit_of_measure,angular_unit_of_measure_factor') D
  )
  SELECT element, ST_SpatialRefSys::ST_ParseWKT( element, srs_text ) parsed
  FROM V

  The example returns the following result set:

  element	parsed
  srs_name	WGS 84
  srs_type	GEOGRAPHIC
  organization	EPSG
  organization_id	4326
  linear_unit_of_measure	NULL
  linear_unit_of_measure_factor	NULL
  angular_unit_of_measure	degree
  angular_unit_of_measure_factor	.017453292519943282

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension