:SFMesh SQL references

Terms

Data types

Data models

WKT

• Models

  • INDEXSURFACE

  • TRIANGLESTRIP

  • TRIANGLEFAN

• MESHGEOM

• SFMESH

EWKT

Constructor functions

• ST_MakeTexture

• ST_MakeMaterial

Input functions

• ST_MeshFromText

• ST_MeshGeomFromWKT

• ST_MeshGeomFromEWKT

• ST_MeshFromText

• ST_MeshFromWKT

• ST_MeshFromEWKT

• ST_TextureFromText

• ST_MaterialFromText

• ST_MeshGeomFromBinary

• ST_MeshGeomFromWKB

• ST_MeshGeomFromEWKB

• ST_MeshGeomFromHexEWKB

• ST_MeshFromHexEWKB

• ST_MeshGeomFromGeom

• ST_MeshFromGeom

• ST_MeshFrommeshGeom

Output functions

• ST_AsText

• ST_AsWKT

• ST_AsEWKT

• ST_AsBinary

• ST_AsWKB

• ST_AsEWKB

• ST_AsHexEWKB

• ST_AsGeometry

• ST_AsRaw

• ST_AsGltf

• ST_AsGlb

Attribute functions

• ST_Memsize

• ST_Dimension

• ST_CoordDim

• ST_NDims

• ST_NumPatches

• ST_IsEmpty

• ST_Npoints

• ST_NumGeometries

• ST_GeometryN

• ST_BoundingDiagonal

• ST_NumMaterials

• ST_NumTextures

• ST_MaterialN

• ST_SetMaterial

• ST_TextureN

• ST_SetTexture

• ST_Materials

• ST_Textures

• ST_JsonString

• ST_Type

• ST_Name

• ST_SetName

• ST_UserData

• ST_SetNodeID

• ST_NodeID

• ST_SetUserData

• ST_SetBinData

• ST_HasBinData

• ST_BinData

• ST_ClearBinData

• ST_Estimated3DExtent

Spatial relationship identification functions

• ST_3DIntersects

• ST_3DContains

Spatial analysis functions

• ST_3DIntersection

• ST_3DDifference

Processing functions

• ST_SwapOrdinates

• ST_FlipCoordinates

• ST_Collect

• ST_FromSuperMap

Model processing functions

• ST_Triangulate

• ST_GeometryMatch

• ST_Extrude

• ST_3DBuffer

• ST_Loft

Spatial distance functions

• ST_3DArea

• ST_Volume/ST_3DVolume

• ST_3DDistance

Affine transformation functions

• ST_Affine

• ST_Scale

• ST_Rotate

• ST_Translate

• ST_TransScale

• ST_ECEFToENU

SRID functions

• ST_Srid

• ST_SetSrid

• ST_Transform

LOD

• ST_LOD

• ST_SetLOD

Management functions

• ST_HasBBox

• ST_AddBBox

Indexes and operators

• GiST index

• &&

• ~

• @

• <->