What Types of Postgis Data Are These

Asked

Viewed 80 times

2

In the Postgis 2.3 documentation in Part 4.2 Postgis Geography Type, it is mentioned that the following types are supported.

  • POINT

  • LINESTRING

  • POLYGON

  • MULTIPOINT

  • MULTILINESTRING

  • MULTIPOLYGON

  • GEOMETRYCOLLECTION

But elsewhere I see written about ST_CircularString, POLYHEDRALSURFACE and so, what are these values?

database postgresql postgis

1 answer

0

POLYHEDRALSURFACE are nothing more than polyhedral surfaces, usually in three dimensions, which are composed of vertices, edges, facets and a relation of incidence on them.

SELECT ST_AsEWKT(ST_GeometryN(p_geom,3)) As geom_ewkt FROM (SELECT ST_GeomFromEWKT('POLYHEDRALSURFACE(((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)),((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 0)),((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)),((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 1)) )') AS p_geom ) AS a;geom_ewkt POLYGON((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0))

or

SELECT ST_AsEWKT(ST_GeometryN(geom,2)) as wkt FROM (SELECT ST_GeomFromEWKT('TIN (((0 0 0,0 0 1,0 1 0,0 0 0)), ((0 0 0,0 1 0,1 1 0,0 0 0)))') AS geom) AS g; wkt TRIANGLE((0 0 0,0 1 0,1 1 0,0 0 0))

Already ST_CircularString is a subtype of ST_Curve using circular line segments between control points.

Browser other questions tagged database postgresql postgis

You are not signed in. Login or sign up in order to post.