H2GIS

Fork me on GitHub

ST_GeomFromGML

Signature

GEOMETRY ST_GeomFromGML(VARCHAR gml);
GEOMETRY ST_GeomFromGML(VARCHAR gml, INT srid);

Description

Converts an input gml representation into a Geometry, optionally with spatial reference id srid.

This function supports:

  • only GML 2.1.2
  • 3D coordinates
  • Multi-geometries

Examples

For a Point, with a srid
SELECT ST_GeomFromGML('
	<gml:Point>
	    <gml:coordinates>
	    	50.2,38.7
	    </gml:coordinates>
	</gml:Point>', 4326);
-- Answer: POINT (50.2 38.7)
For a 3D Point
SELECT ST_GeomFromGML('
	<gml:Point>
	    <gml:coordinates>
	    	50.2,38.7,20
	    </gml:coordinates>
	</gml:Point>');
-- Answer: POINT (50.2 38.7 20)
For a Linestring
SELECT ST_GeomFromGML('
	<gml:LineString srsName="EPSG:4326">
	    <gml:coordinates>
	    	-60.5,35.2 -62.3,47.4 -65.6,48.4
	    </gml:coordinates>
	</gml:LineString>');
-- Answer: LINESTRING (-60.5 35.2, -62.3 47.4, -65.6 48.4)
For a MultiLinestring
SELECT ST_GeomFromGML('
	<MultiLineString srsName="EPSG:4326">
	  <lineStringMember>
	     <LineString>
		<coordinates>56.1,0.45 67.23,0.67</coordinates>
	     </LineString>
	  </lineStringMember>
	  <lineStringMember>
	     <LineString>
		<coordinates>46.71,9.25 56.88,10.44</coordinates>
	     </LineString>
	  </lineStringMember>
	  <lineStringMember>
	     <LineString>
		<coordinates>324.1,219.7 0.45,0.56</coordinates>
	     </LineString>
	  </lineStringMember>
	</MultiLineString>');
-- Answer: MULTILINESTRING ((56.1 0.45, 67.23 0.67), 
--			    (46.71 9.25, 56.88 10.44), 
--			    (324.1 219.7, 0.45 0.56))
For a Polygon
SELECT ST_GeomFromGML('
	<gml:Polygon>
	  <gml:outerBoundaryIs>
	     <gml:LinearRing>
		<gml:coordinates>
		  0,0 50,0 50,50 0,50 0,0
		</gml:coordinates>
	     </gml:LinearRing>
          </gml:outerBoundaryIs>
	</gml:Polygon>');
-- Answer: POLYGON ((0 0, 50 0, 50 50, 0 50, 0 0))
See also