ST_Geometry in PostgreSQL only
ST_PolyFromShape takes an ESRI multipolygon shape and a spatial reference ID and returns a polygon.
sde.st_polyfromshape (esri_shape bytea, srid integer)
This example illustrates how ST_PolyFromShape can be used to create a polygon from an ESRI shape representation. In this example, the polygon is stored in the geometry column of the polys table, then the shape column is updated with its ESRI shape representation (using the ST_AsShape function). Finally, the ST_PolyFromShape function is used to return the multipolygon from the shape column. The x- and y-coordinates for this geometry are (50, 20) (50, 40) (70, 30). The polys table has a geometry column, where the polygon is stored; a shape column, where the polygon's ESRI shape representation is stored; and an id column to uniquely identify each record.
CREATE TABLE polys (id integer unique, geometry sde.st_geometry, shape bytea); INSERT INTO polys VALUES ( 111, sde.st_polygon ('polygon ((10.01 20.03, 10.52 40.11, 30.29 41.56, 31.78 10.74, 10.01 20.03))', 0) ); UPDATE polys SET shape = sde.st_asshape (geometry) WHERE id = 111;
SELECT id, sde.st_astext (sde.st_polyfromshape (shape, 0)) AS polygon FROM polys; id polygon 111 POLYGON (10.01000000 20.03000000, 31.78000000 10.74000000, 30.29000000 41.56000000, 10.52000000 40.11000000, 10.01000000 20.03000000)