：SFMesh SQL參考

基本概念

資料類型

模型

WKT

• 模型

  • INDEXSURFACE

  • TRIANGLESTRIP

  • TRIANGLEFAN

• MESHGEOM

• SFMESH

EWKT

建構函式

• ST_MakeTexture

• ST_MakeMaterial

輸入函數

• 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

輸出函數

• ST_AsText

• ST_AsWKT

• ST_AsEWKT

• ST_AsBinary

• ST_AsWKB

• ST_AsEWKB

• ST_AsHexEWKB

• ST_AsGeometry

• ST_AsRaw

• ST_AsGltf

• ST_AsGlb

屬性函數

• 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

空間關係判斷

• ST_3DIntersects

• ST_3DContains

空間分析

• ST_3DIntersection

• ST_3DDifference

處理函數

• ST_SwapOrdinates

• ST_FlipCoordinates

• ST_Collect

• ST_FromSuperMap

模型加工

• ST_Triangulate

• ST_GeometryMatch

• ST_Extrude

• ST_3DBuffer

• ST_Loft

空間度量

• ST_3DArea

• ST_Volume/ST_3DVolume

• ST_3DDistance

仿射變換

• ST_Affine

• ST_Scale

• ST_Rotate

• ST_Translate

• ST_TransScale

• ST_ECEFToENU

空間參考

• ST_Srid

• ST_SetSrid

• ST_Transform

LOD

• ST_LOD

• ST_SetLOD

管理

• ST_HasBBox

• ST_AddBBox

索引和操作符

• GIST索引

• &&

• ~

• @

• <->