ST_GeometryTypeCode
Signature
Description
Returns the geometry type code from the OpenGIS Simple Features Implementation Specification for SQL version 1.2.1. Ignores z- and m-values. For use in contraints.
CODE | GEOMETRY TYPE |
---|---|
0 | Geometry |
1 | POINT |
2 | LINESTRING |
3 | POLYGON |
4 | MULTIPOINT |
5 | MULTILINESTRING |
6 | MULTIPOLYGON |
7 | GEOMCOLLECTION |
13 | CURVE |
14 | SURFACE |
15 | POLYHEDRALSURFACE |