ST_GeomFromGML — Construct a geometric object given its GML Representation
geometry ST_GeomFromGML(
varchar GML)
;
Construct a geometric object given its GML Representation. It supports OGC GML standard 2.1.2
ST_AsGML is the reverse of ST_GeomFromGML |
2D | 3D | M |
---|---|---|
- |
OGC SFS for SQL. 1.1 (1999) | OGC SFS for SQL. 1.1.0 (2005) | OGC SFS for SQL. 1.2.0 (2006) | SQL-MM Part 3 |
---|---|---|---|
- | - | - | 5.1.42 ST_GeomFromGML 5.1.38 ST_GMLToSQL |
SELECT ST_GeomFromGML ( '<gml:Point srsName="EPSG:25830"> <gml:coordinates> 1.0,1.0,1.0 </gml:coordinates> </gml:Point>' ); --Result PostgreSQL \011 \001\001\000\000\000\000\000\000\360?\000\000\000\000\000\000\360?\000\000\000\000\000\000\360? --Result H2 09200101000000000000f03f000000000000f03f000000000000f03f SELECT ST_GeomFromGML ( '<gml:Polygon> <gml:outerBoundaryIs> <gml:LinearRing> <gml:coordinates> 1.0,1.0 1.0,3.0 2.0,4.0 3.0,3.0 1.0,1.0 </gml:coordinates> </gml:LinearRing> </gml:outerBoundaryIs> </gml:Polygon>' );