| title | GeomFromGML (geography Data Type) | ||
|---|---|---|---|
| description | GeomFromGML (geography Data Type) | ||
| author | MladjoA | ||
| ms.author | mlandzic | ||
| ms.date | 07/30/2017 | ||
| ms.service | sql | ||
| ms.subservice | t-sql | ||
| ms.topic | reference | ||
| ms.custom |
|
||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]
Constructs a geography instance given a representation in the [!INCLUDEssNoVersion] subset of the Geography Markup Language (GML).
For more information on GML, see the following Open Geospatial Consortium Specifications: OGC Specifications, Geography Markup Language
This geography data type method supports FullGlobe instances or spatial instances that are larger than a hemisphere.
GeomFromGml ( GML_input, SRID )
GML_input
Is an XML input from which the GML will return a value.
SRID
Is an int expression representing the spatial reference ID (SRID) of the geography instance to return.
[!INCLUDEssNoVersion] return type: geography
CLR return type: SqlGeography
This method throws a FormatException if the input is not well-formatted.
This method will throw ArgumentException if the input contains antipodal edge.
The following example uses GeomFromGml() to create a geography instance.
DECLARE @g geography;
DECLARE @x xml;
SET @x = '<LineString xmlns="http://www.opengis.net/gml"><posList>47.656 -122.36 47.656 -122.343</posList></LineString>';
SET @g = geography::GeomFromGml(@x, 4326);
SELECT @g.ToString(); The following example uses GeomFromGml() to create a FullGlobe``geography instance.
DECLARE @g geography;
DECLARE @x xml;
SET @x = '<FullGlobe xmlns="http://schemas.microsoft.com/sqlserver/2011/geography" />';
SET @g = geography::GeomFromGml(@x, 4326);
SELECT @g.ToString();