Skip to content

ST_GEOGFROMGML

Creates a GEOGRAPHY object from a Geography Markup Language (GML) representation.

See also:

Limitations

Supported: Basic geometry types (Point, LineString, Polygon, Multi*, MultiGeometry) using gml:coordinates format with EPSG SRS codes.

Not supported: Custom namespaces, href links, alternative coordinate formats (gml:pos, gml:posList), or advanced GML features.

Only GML produced by ST_ASGML function is guaranteed to be imported successfully.

Syntax

sql
ST_GEOGFROMGML(<input>)

Arguments

  • <input>: A GML formatted VARCHAR

Returns

A GEOGRAPHY type represented by the input GML format

Example

sql
SELECT ST_GEOGFROMGML('<gml:Point srsName="EPSG:4326"><gml:coordinates>1,1</gml:coordinates></gml:Point>');
-- POINT(1 1)