INDEXSURFACE WKT representation and syntax - PolarDB

The well-known text (WKT) representation of INDEXSURFACE uses three keywords: INDEXSURFACE, VERTEX, and INDEX.

Syntax

INDEXSURFACE(
  VERTEX(x1 y1 z1, x2 y2 z2, ...),
  INDEX(
        (i1,i2,i3,...),
        (j1,j2,j3,...),
        ...
     )
  )

Formatting rules:

VERTEX block: separate dimensions within a coordinate with a space; separate coordinates with a comma
INDEX block: enclose each face's vertex indexes in parentheses (); separate indexes within a face with a comma; separate faces with a comma
Separate the VERTEX block and INDEX block with a comma

Dimensions

INDEXSURFACE supports Z and M dimensions.

Examples

3D surface

INDEXSURFACE(
  VERTEX(201755.424609375 241700.688720703 7025.00027160645,201755.424609375 241700.688720703 6774.9998336792,202255.431298828 241700.688720703 6774.9998336792,202255.431298828 241700.688720703 7025.00027160645,202255.431298828 243149.418896484 6774.9998336792,201755.424609375 243149.418896484 6774.9998336792,201755.424609375 243149.418896484 7025.00027160645,202255.431298828 243149.418896484 7025.00027160645),
   INDEX((0,1,2),(2,3,0),(4,5,6),(6,7,4),(2,1,5),(5,4,2),(3,2,7),(4,7,2),(0,3,7),(7,6,0),(1,0,5),(6,5,0)))

M dimension

INDEXSURFACE M(
  VERTEX(201755.424609375 241700.688720703 7025.00027160645,201755.424609375 241700.688720703 6774.9998336792,202255.431298828 241700.688720703 6774.9998336792,202255.431298828 241700.688720703 7025.00027160645,202255.431298828 243149.418896484 6774.9998336792,201755.424609375 243149.418896484 6774.9998336792,201755.424609375 243149.418896484 7025.00027160645,202255.431298828 243149.418896484 7025.00027160645),
   INDEX((0,1,2),(2,3,0),(4,5,6),(6,7,4),(2,1,5),(5,4,2),(3,2,7),(4,7,2),(0,3,7),(7,6,0),(1,0,5),(6,5,0)))