Spatial Relationships（空間關系）

ST_3DIntersects—如果幾何在3D中“空間相交”，則返回TRUE-僅適用于點混蔼，線串，多邊形袍暴，多面體表面（區(qū)域）坊萝。

ST_3DIntersects— Returns TRUE if the Geometries "spatially intersect" in 3D - only for points, linestrings, polygons, polyhedral surface (area).

ST_Contains—當且僅當B的點不位于A的外部且B的內部的至少一個點位于A的內部時，才返回true句狼。

ST_Contains— Returns true if and only if no points of B lie in the exterior of A, and at least one point of the interior of B lies in the interior of A.

ST_ContainsProperly—如果B與A的內部而不是邊界（或外部）相交笋熬，則返回true。A本身不包含自身腻菇，但是包含自身突诬。

Returns true if B intersects the interior of A but not the boundary (or exterior). A does not contain properly itself, but does contain itself.

ST_Covers—如果幾何B中的任何點都不在幾何A之外，則返回1（TRUE）

ST_Covers— Returns 1 (TRUE) if no point in Geometry B is outside Geometry A

ST_CoveredBy—如果幾何/地理A中的任何點都不在幾何/地理B之外芜繁，則返回1（TRUE）

ST_CoveredBy— Returns 1 (TRUE) if no point in Geometry/Geography A is outside Geometry/Geography B

ST_Crosses—?TRUE 如果提供的幾何具有一些但不是全部內部公共點，則返回绒极。接受兩個幾何對象骏令，TRUE如果它們的交點“空間相交”，則返回它們垄提，也就是說榔袋，幾何具有一些內部點，但并非所有內部點都相同铡俐。

ST_Crosses— Returns?TRUE?if the supplied geometries have some, but not all, interior points in common.

ST_LineCrossingDirection-給定2個線串凰兑，返回-3到3之間的數字，表示哪種交叉行為审丘。0是不相交吏够。僅支持LINESTRING

ST_LineCrossingDirection— Given 2 linestrings, returns a number between -3 and 3 denoting what kind of crossing behavior. 0 is no crossing.

ST_Disjoint—如果幾何不“空間相交”-如果它們不共享任何空間，則返回TRUE滩报。

ST_Disjoint— Returns TRUE if the Geometries do not "spatially intersect" - if they do not share any space together.

ST_Equals—如果給定的幾何表示相同的幾何锅知，則返回true。方向性被忽略脓钾。

ST_Equals— Returns true if the given geometries represent the same geometry. Directionality is ignored.

ST_Intersects—如果“幾何體/地理”在2D中空間相交”（共享空間的任何部分）售睹，則返回FALSE；否則可训，則返回FALSE（它們不相交）昌妹。對于地理公差為0.00001米（因此，任何靠近的點都視為相交）

ST_Intersects— Returns TRUE if the Geometries/Geography "spatially intersect in 2D" - (share any portion of space) and FALSE if they don't (they are Disjoint). For geography tolerance is 0.00001 meters (so any points that close are considered to intersect)

ST_OrderingEquals—如果給定的幾何圖形表示相同的幾何圖形握截，并且點的方向相同飞崖，則返回true。

ST_OrderingEquals— Returns true if the given geometries represent the same geometry and points are in the same directional order.

ST_Overlaps—如果幾何共享空間川蒙，具有相同的維度但彼此之間不完全包含蚜厉，則返回TRUE。

ST_Overlaps— Returns TRUE if the Geometries share space, are of the same dimension, but are not completely contained by each other.

ST_PointInsideCircle—是由center_x畜眨，center_y昼牛，半徑定義的圓內的點幾何

ST_PointInsideCircle— Is the point geometry inside the circle defined by center_x, center_y, radius

ST_Relate—如果此Geometry在空間上與anotherGeometry相關术瓮，則通過測試由交集MatrixPattern中的值指定的兩個幾何的內部，邊界和外部之間的交集贰健，返回true胞四。如果沒有傳入交集矩陣模式，則返回與2個幾何相關的最大交集矩陣模式伶椿。

ST_Relate— Returns true if this Geometry is spatially related to anotherGeometry, by testing for intersections between the Interior, Boundary and Exterior of the two geometries as specified by the values in the intersectionMatrixPattern. If no intersectionMatrixPattern is passed in, then returns the maximum intersectionMatrixPattern that relates the 2 geometries.

ST_RelateMatch—如果交集MattrixPattern1暗含交集MatrixPattern2辜伟，則返回true

ST_RelateMatch— Returns true if intersectionMattrixPattern1 implies intersectionMatrixPattern2

ST_Touches—返回TRUE 幾何是否至少有一個公共點，但它們的內部不相交脊另。不適用于點/點對

ST_Touches— Returns?TRUE?if the geometries have at least one point in common, but their interiors do not intersect.

ST_Within—如果幾何A完全在幾何B內导狡，則返回true。假設如果ST_Within（A偎痛，B）為true并且ST_Within（B旱捧，A）為true，則認為這兩個幾何在空間上相等

ST_Within— Returns true if the geometry A is completely inside geometry B

Distance Relationships（距離）

ST_3DDWithin—對于3d（z）幾何類型踩麦，如果兩個幾何3d距離在單位數量之內枚赡，則返回true。

ST_3DDWithin— For 3d (z) geometry type Returns true if two geometries 3d distance is within number of units.

ST_3DDFullyWithin—如果所有3D幾何形狀彼此都在指定的距離之內谓谦，則返回true贫橙。

ST_3DDFullyWithin— Returns true if all of the 3D geometries are within the specified distance of one another.

ST_DFullyWithin—如果所有幾何都在彼此的指定距離內，則返回true

ST_DFullyWithin— Returns true if all of the geometries are within the specified distance of one another

ST_DWithin—如果幾何在指定距離內反粥，則返回true卢肃。對于幾何單位，以空間參考為單位才顿；對于地理單位践剂，以米為單位，并且默認將測量值設置為use_spheroid = true（圍繞橢球體進行度量）娜膘，以便更快地進行檢查逊脯，將use_spheroid = false沿球進行度量。

ST_DWithin— Returns true if the geometries are within the specified distance of one another. For geometry units are in those of spatial reference and for geography units are in meters and measurement is defaulted to use_spheroid=true (measure around spheroid), for faster check, use_spheroid=false to measure along sphere

Measurement Functions（測量）

ST_Area—返回多邊形幾何的面積竣贪。

ST_Area— Returns the area of a polygonal geometry.

ST_Azimuth—返回北點方位角军洼，以弧度為單位，從點A的垂直方向到點B的角度以弧度為單位演怎。

ST_Azimuth— Returns the north-based azimuth as the angle in radians measured clockwise from the vertical on pointA to pointB.

ST_Angle—返回3個點之間或2個向量之間的角度（4個點或2條線）匕争。

ST_Angle— Returns the angle between 3 points, or between 2 vectors (4 points or 2 lines).

ST_ClosestPoint—返回g1上最接近g2的2D點。這是最短線的第一點爷耀。

ST_ClosestPoint— Returns the 2D point on g1 that is closest to g2. This is the first point of the shortest line.

ST_3DClosestPoint—返回g1上最接近g2的3D點甘桑。這是3D最短線的第一點。

ST_3DClosestPoint— Returns the 3D point on g1 that is closest to g2. This is the first point of the 3D shortest line.

ST_Distance—返回兩個幾何或地理值之間的距離。

ST_Distance— Returns the distance between two geometry or geography values.

ST_3DDistance—以投影單位返回兩個幾何之間的3D笛卡爾最小距離（基于空間參考）跑杭。

ST_3DDistance— Returns the 3D cartesian minimum distance (based on spatial ref) between two geometries in projected units.

ST_DistanceSphere—使用球形地球模型返回兩個lon / lat幾何之間的最小距離（以米為單位）铆帽。

ST_DistanceSphere— Returns minimum distance in meters between two lon/lat geometries using a spherical earth model.

ST_DistanceSpheroid—使用球狀地球模型返回兩個lon / lat幾何之間的最小距離。

ST_DistanceSpheroid— Returns the minimum distance between two lon/lat geometries using a spheroidal earth model.

ST_FrechetDistance—返回兩個幾何之間的Fréchet距離德谅。兩個幾何之間相似度或不相似度的度量

ST_FrechetDistance— Returns the Fréchet distance between two geometries.

ST_HausdorffDistance—返回兩個幾何之間的Hausdorff距離爹橱。兩個幾何之間相似度或不相似度的度量

ST_HausdorffDistance— Returns the Hausdorff distance between two geometries.

ST_Length—返回線性幾何的2D長度。

ST_Length— Returns the 2D length of a linear geometry.

ST_Length2D—返回線性幾何的2D長度窄做。別名ST_Length

ST_Length2D— Returns the 2D length of a linear geometry. Alias for?ST_Length

ST_3DLength—返回線性幾何的3D長度愧驱。

ST_3DLength— Returns the 3D length of a linear geometry.

ST_LengthSpheroid—返回球體上lon / lat幾何的2D或3D長度/周長。

ST_LengthSpheroid— Returns the 2D or 3D length/perimeter of a lon/lat geometry on a spheroid.

ST_LongestLine—返回兩個幾何之間的2D最長線椭盏。

ST_LongestLine— Returns the 2D longest line between two geometries.

ST_3DLongestLine—返回兩個幾何之間的3D最長線

ST_3DLongestLine— Returns the 3D longest line between two geometries

ST_MaxDistance—以投影單位返回兩個幾何之間的最大二維距離组砚。

ST_MaxDistance— Returns the 2D largest distance between two geometries in projected units.

ST_3DMaxDistance—以投影單位返回兩個幾何之間的3D笛卡爾最大距離（基于空間參考）。

ST_3DMaxDistance— Returns the 3D cartesian maximum distance (based on spatial ref) between two geometries in projected units.

ST_MinimumClearance—返回幾何圖形的最小間隙掏颊，度量幾何圖形的魯棒性惫确。

ST_MinimumClearance— Returns the minimum clearance of a geometry, a measure of a geometry's robustness.

ST_MinimumClearanceLine—返回跨越幾何最小間隙的兩點LineString。

ST_MinimumClearanceLine— Returns the two-point LineString spanning a geometry's minimum clearance.

ST_Perimeter—返回多邊形幾何或地理邊界的長度（周長）蚯舱。

ST_Perimeter— Returns the length of the boundary of a polygonal geometry or geography.

ST_Perimeter2D—返回多邊形幾何的2D周長。ST_Perimeter的別名掩蛤。

ST_Perimeter2D— Returns the 2D perimeter of a polygonal geometry. Alias for?ST_Perimeter.

ST_3DPerimeter—返回多邊形幾何的3D周長枉昏。

ST_3DPerimeter— Returns the 3D perimeter of a polygonal geometry.

ST_Project—返回從起點投影一個距離和方位角（方位角）的點。返回使用給定的距離和方位角（方位角）從沿測地線的起點投影的點揍鸟。這被稱為直接測地問題

ST_Project— Returns a point projected from a start point by a distance and bearing (azimuth).

ST_ShortestLine—返回兩個幾何之間的2D最短線

ST_ShortestLine— Returns the 2D shortest line between two geometries

ST_3DShortestLine—返回兩個幾何之間的3D最短線

ST_3DShortestLine— Returns the 3D shortest line between two geometries

TIPS

1.計算距離兄裂，面積和角度的測量值。及計算由測量確定的幾何值

2.Fréchet距離是曲線之間相似度的量度阳藻，其中考慮了沿曲線的點的位置和順序晰奖。因此，它通常比Hausdorff距離更好

3.方位角（也稱為航向或方位角）以弧度表示腥泥。從真北（方位角零）順時針測量匾南。East是方位角π/ 2（90度）；南方是方位角π（180度）;?西方是方位角3π/ 2（270度）蛔外。支持負方位角值和大于2π（360度）的值蛆楞。

Geometry Processing（幾何處理）

ST_Buffer—（T）返回一個幾何圖形，該幾何圖形覆蓋距輸入幾何圖形給定距離內的所有點夹厌。

ST_Buffer— (T) Returns a geometry covering all points within a given distance from the input geometry.

ST_BuildArea—創(chuàng)建由給定幾何圖形的組成線段形成的面幾何圖形豹爹，返回類型可以是Polygon或MultiPolygon，具體取決于輸入

ST_BuildArea— Creates an areal geometry formed by the constituent linework of given geometry

ST_Centroid—返回幾何的幾何中心矛纹。計算幾何的幾何中心臂聋，或等效地將幾何的質心計算為POINT。對于[?MULTI]?POINT，將其計算為輸入坐標的算術平均值孩等。對于[?MULTI]?LINESTRING艾君，將其計算為每個線段的加權長度。對于[?MULTI]?POLYGON瞎访，“權重”是根據面積來考慮的腻贰。

ST_Centroid— Computes the geometric center of a geometry, or equivalently, the center of mass of the geometry as a?POINT. For [MULTI]POINTs, this is computed as the arithmetic mean of the input coordinates. For [MULTI]LINESTRINGs, this is computed as the weighted length of each line segment. For [MULTI]POLYGONs, "weight" is thought in terms of area. If an empty geometry is supplied, an empty?GEOMETRYCOLLECTION?is returned. If?NULL?is supplied,?NULL?is returned. If?CIRCULARSTRING?or?COMPOUNDCURVE?are supplied, they are converted to linestring wtih CurveToLine first, then same than for?LINESTRING

ST_ClipByBox2D—返回屬于矩形的幾何圖形的一部分。

ST_ClipByBox2D— Returns the portion of a geometry falling within a rectangle.

ST_ConcaveHull—幾何形狀的凹殼表示可能的凹形幾何形狀扒秸，該幾何形狀將集合中的所有幾何形狀都包含在內播演。您可以將其視為收縮包裝。

ST_ConcaveHull— The concave hull of a geometry represents a possibly concave geometry that encloses all geometries within the set. You can think of it as shrink wrapping.

ST_ConvexHull—計算幾何的凸包伴奥。

ST_ConvexHull— Computes the convex hull of a geometry.

ST_CurveToLine—將圓形/曲線多面體/多表面轉換為線性/多面體/多面體

ST_CurveToLine— Converts a CIRCULARSTRING/CURVEPOLYGON/MULTISURFACE to a LINESTRING/POLYGON/MULTIPOLYGON

ST_DelaunayTriangles—返回圍繞給定輸入點的Delaunay三角剖分写烤。

ST_DelaunayTriangles— Return a Delaunay triangulation around the given input points.

ST_Difference—返回一個幾何，該幾何表示不與幾何B相交的幾何A的那一部分拾徙。

ST_Difference— Returns a geometry that represents that part of geometry A that does not intersect with geometry B.

ST_FlipCoordinates—返回給定幾何圖形的X和Y軸已翻轉的版本洲炊。對于已建立緯度/經度特征并需要對其進行修復的人員而言非常有用。（經緯度翻轉）

ST_FlipCoordinates— Returns a version of the given geometry with X and Y axis flipped. Useful for people who have built latitude/longitude features and need to fix them.

ST_GeneratePoints—將多邊形或多多邊形轉換為由原始區(qū)域內的隨機位置點組成的多點尼啡。

ST_GeneratePoints— Converts a polygon or multi-polygon into a multi-point composed of randomly location points within the original areas.

ST_GeometricMedian?—返回MultiPoint的幾何中間值暂衡。

ST_GeometricMedian?— Returns the geometric median of a MultiPoint.

ST_Intersection—（T）返回表示geomA和geomB共享部分的幾何。

ST_Intersection— (T) Returns a geometry that represents the shared portion of geomA and geomB.

ST_LineToCurve—將LINESTRING / POLYGON轉換為圓形崖瞭，CURVEPOLYGON

ST_LineToCurve— Converts a LINESTRING/POLYGON to a CIRCULARSTRING, CURVEPOLYGON

ST_MakeValid—嘗試使無效的幾何圖形有效而不丟失頂點狂巢。

ST_MakeValid— Attempts to make an invalid geometry valid without losing vertices.

ST_MemUnion—與ST_Union相同，僅對內存友好（使用更少的內存和更多的處理器時間）书聚。

ST_MemUnion— Same as ST_Union, only memory-friendly (uses less memory and more processor time).

ST_MinimumBoundingCircle—返回可以完全包含幾何圖形的最小圓形多邊形唧领。默認情況下，每四分之一圈使用48個細分雌续。

ST_MinimumBoundingCircle— Returns the smallest circle polygon that can fully contain a geometry. Default uses 48 segments per quarter circle.

ST_MinimumBoundingRadius—返回可以完全包含幾何圖形的最小圓的圓心和半徑斩个。

ST_MinimumBoundingRadius— Returns the center point and radius of the smallest circle that can fully contain a geometry.

ST_OrientedEnvelope—返回包含幾何的最小旋轉矩形。

ST_OrientedEnvelope— Returns a minimum rotated rectangle enclosing a geometry.

ST_Polygonize—聚合驯杜。創(chuàng)建一個GeometryCollection受啥，其中包含由一組幾何的構成線形成的可能的多邊形。

ST_Polygonize— Aggregate. Creates a GeometryCollection containing possible polygons formed from the constituent linework of a set of geometries.

ST_Node—節(jié)點一組線串鸽心。使用最少數量的節(jié)點將一組線串完全節(jié)點化腔呜，同時保留所有輸入節(jié)點

ST_Node— Node a set of linestrings.

ST_OffsetCurve—返回距輸入線給定距離和邊距的偏移線。對于計算圍繞中心線的平行線很有用

ST_OffsetCurve— Return an offset line at a given distance and side from an input line. Useful for computing parallel lines about a center line

ST_PointOnSurface—返回POINT保證位于表面上的位置再悼。

ST_PointOnSurface— Returns a?POINT?guaranteed to lie on the surface.

ST_RemoveRepeatedPoints—返回給定幾何的版本核畴，其中刪除了重復的點。

ST_RemoveRepeatedPoints— Returns a version of the given geometry with duplicated points removed.

ST_SharedPaths—返回包含兩個輸入線串/多線串共享的路徑的集合冲九。

ST_SharedPaths— Returns a collection containing paths shared by the two input linestrings/multilinestrings.

ST_ShiftLongitude—在-180..180和0..360范圍之間切換幾何坐標谤草。

ST_ShiftLongitude— Toggle geometry coordinates between -180..180 and 0..360 ranges.

ST_WrapX—將幾何圖形環(huán)繞X值跟束。

ST_WrapX— Wrap a geometry around an X value.

ST_Simplify—使用Douglas-Peucker算法返回給定幾何的“簡化”版本。

ST_Simplify— Returns a "simplified" version of the given geometry using the Douglas-Peucker algorithm.

ST_SimplifyPreserveTopology—使用Douglas-Peucker算法返回給定幾何的“簡化”版本丑孩。將避免創(chuàng)建無效的派生幾何（尤其是多邊形）冀宴。

ST_SimplifyPreserveTopology— Returns a "simplified" version of the given geometry using the Douglas-Peucker algorithm. Will avoid creating derived geometries (polygons in particular) that are invalid.

ST_SimplifyVW—使用Visvalingam-Whyatt算法返回給定幾何的“簡化”版本

ST_SimplifyVW— Returns a "simplified" version of the given geometry using the Visvalingam-Whyatt algorithm

ST_ChaikinSmoothing—使用Chaikin算法返回給定幾何的“平滑”版本

ST_ChaikinSmoothing— Returns a "smoothed" version of the given geometry using the Chaikin algorithm

ST_FilterByM—根據頂點的m值過濾頂點(此功能主要旨在與ST_SetEffectiveArea結合使用。ST_EffectiveArea以其m值設置頂點的有效面積温学。借助ST_FilterByM略贮，僅通過過濾即可獲得幾何的簡化版本，而無需任何計算)

ST_FilterByM— Filters vertex points based on their m-value

ST_SetEffectiveArea—設置每個頂點的有效面積仗岖，將值存儲在M坐標中逃延。然后可以通過對坐標進行過濾來生成簡化的幾何圖形。

ST_SetEffectiveArea— Sets the effective area for each vertex, storing the value in the M ordinate. A simplified geometry can then be generated by filtering on the M ordinate.

ST_Split—返回通過拆分幾何圖形得到的幾何圖形的集合轧拄。

ST_Split— Returns a collection of geometries resulting by splitting a geometry.

ST_SymDifference—返回表示A和B不相交的部分的幾何揽祥。之所以稱為對稱差異，是因為ST_SymDifference（A檩电，B）= ST_SymDifference（B拄丰，A）。

ST_SymDifference— Returns a geometry that represents the portions of A and B that do not intersect. It is called a symmetric difference because ST_SymDifference(A,B) = ST_SymDifference(B,A).

ST_Subdivide—返回一組幾何俐末，其中該組中的任何幾何都沒有超過指定數目的頂點料按。

ST_Subdivide— Returns a set of geometry where no geometry in the set has more than the specified number of vertices.

ST_Union—返回表示幾何圖形的點集并集的幾何圖形。

ST_Union— Returns a geometry that represents the point set union of the Geometries.

ST_UnaryUnion—與ST_Union類似卓箫，但是在幾何圖形組件級別工作载矿。

ST_UnaryUnion— Like ST_Union, but working at the geometry component level.

ST_VoronoiLines—返回從幾何頂點構造的Voronoi圖的像元之間的邊界。

ST_VoronoiLines— Returns the boundaries between the cells of the Voronoi diagram constructed from the vertices of a geometry.

ST_VoronoiPolygons—返回從幾何頂點構造的Voronoi圖的像元丽柿。

ST_VoronoiPolygons— Returns the cells of the Voronoi diagram constructed from the vertices of a geometry.

?Affine Transformations（仿射變換）

ST_Affine—將3D仿射變換應用于幾何圖形。

ST_Affine— Apply a 3D affine transformation to a geometry.

ST_Rotate—圍繞原點旋轉幾何魂挂。

ST_Rotate— Rotates a geometry about an origin point.

ST_RotateX—繞X軸旋轉幾何甫题。

ST_RotateX— Rotates a geometry about the X axis.

ST_RotateY—圍繞Y軸旋轉幾何。

ST_RotateY— Rotates a geometry about the Y axis.

ST_RotateZ—繞Z軸旋轉幾何涂召。

ST_RotateZ— Rotates a geometry about the Z axis.

ST_Scale—按給定因子縮放幾何坠非。

ST_Scale— Scales a geometry by given factors.

ST_Translate—按給定的偏移量轉換幾何圖形。

ST_Translate— Translates a geometry by given offsets.

ST_TransScale—按給定的偏移量和因子平移和縮放幾何果正。

ST_TransScale— Translates and scales a geometry by given offsets and factors.

TIPS

1.更改幾何的位置和形狀

?Clustering Functions（聚類）

ST_ClusterDBSCAN—窗口函數炎码，使用DBSCAN算法為每個輸入幾何返回聚類ID。

ST_ClusterDBSCAN— Window function that returns a cluster id for each input geometry using the DBSCAN algorithm.

ST_ClusterIntersecting—聚合函數秋泳，用于將輸入幾何形狀聚類為連接的集合潦闲。

ST_ClusterIntersecting— Aggregate function that clusters the input geometries into connected sets.

ST_ClusterKMeans—窗口函數，使用K-means算法為每個輸入幾何返回聚類ID迫皱。

ST_ClusterKMeans— Window function that returns a cluster id for each input geometry using the K-means algorithm.

ST_ClusterWithin—聚合函數歉闰，用于按分隔距離對輸入幾何圖形進行聚類。

ST_ClusterWithin— Aggregate function that clusters the input geometries by separation distance.

Bounding Box Functions（邊界框的操作）

Box2D—返回表示幾何2D范圍的BOX2D。

Box2D— Returns a BOX2D representing the 2D extent of the geometry.

Box3D—返回代表幾何圖形3D范圍的BOX3D和敬。

Box3D— Returns a BOX3D representing the 3D extent of the geometry.

ST_EstimatedExtent—返回空間表的“估計”范圍凹炸。

ST_EstimatedExtent— Return the 'estimated' extent of a spatial table.

ST_Expand—返回從另一個邊界框或幾何圖形擴展的邊界框。指定一個應在各個方向上擴展該框的距離昼弟，或者指定每個方向的擴展距離

ST_Expand— Returns a bounding box expanded from another bounding box or a geometry.

ST_Extent—一個聚合函數啤它，返回一個包圍一組幾何形狀的邊界框

ST_Extent— an aggregate function that returns the bounding box that bounds rows of geometries.

ST_3DExtent—返回3D邊界框的聚合函數，該邊界框限制幾何圖形的行舱痘。

ST_3DExtent— an aggregate function that returns the 3D bounding box that bounds rows of geometries.

ST_MakeBox2D—創(chuàng)建由兩個2D點幾何定義的BOX2D变骡。

ST_MakeBox2D— Creates a BOX2D defined by two 2D point geometries.

ST_3DMakeBox—創(chuàng)建由兩個3D點幾何定義的BOX3D。

ST_3DMakeBox— Creates a BOX3D defined by two 3D point geometries.

ST_XMax—返回2D或3D邊界框或幾何的X最大值衰粹。

ST_XMax— Returns the X maxima of a 2D or 3D bounding box or a geometry.

ST_XMin—返回2D或3D邊界框或幾何的X最小值锣光。

ST_XMin— Returns the X minima of a 2D or 3D bounding box or a geometry.

ST_YMax—返回2D或3D邊界框或幾何的Y最大值。

ST_YMax— Returns the Y maxima of a 2D or 3D bounding box or a geometry.

ST_YMin—返回2D或3D邊界框或幾何的Y最小值铝耻。

ST_YMin— Returns the Y minima of a 2D or 3D bounding box or a geometry.

ST_ZMax—返回2D或3D邊界框或幾何的Z最大值誊爹。

ST_ZMax— Returns the Z maxima of a 2D or 3D bounding box or a geometry.

ST_ZMin—返回2D或3D邊界框或幾何的Z最小值。

ST_ZMin— Returns the Z minima of a 2D or 3D bounding box or a geometry.

Linear Referencing（線性參考）

ST_LineInterpolatePoint—返回沿直線插入的點瓢捉。第二個參數是一個介于0和1之間的float8频丘，代表必須定位的線串總長度的一部分。

ST_LineInterpolatePoint— Returns a point interpolated along a line. Second argument is a float8 between 0 and 1 representing fraction of total length of linestring the point has to be located.

ST_3DLineInterpolatePoint—返回沿3D線插入的點泡态。第二個參數是一個介于0和1之間的float8搂漠，代表必須定位的線串總長度的一部分。

ST_3DLineInterpolatePoint— Returns a point interpolated along a line in 3D. Second argument is a float8 between 0 and 1 representing fraction of total length of linestring the point has to be located.

ST_LineInterpolatePoints—返回沿線插補的一個或多個點某弦。

ST_LineInterpolatePoints— Returns one or more points interpolated along a line.

ST_LineLocatePoint—返回0到1之間的浮點數桐汤，表示LineString上與給定Point點最近的點的位置，以總2d線長的一部分表示靶壮。

ST_LineLocatePoint— Returns a float between 0 and 1 representing the location of the closest point on LineString to the given Point, as a fraction of total 2d line length.

ST_LineSubstring—返回一個線串怔毛，該線串是輸入的子串，從總2d長度的給定分數開始和結束腾降。第二個和第三個參數是介于0和1之間的float8值拣度。

ST_LineSubstring— Return a linestring being a substring of the input one starting and ending at the given fractions of total 2d length. Second and third arguments are float8 values between 0 and 1.

ST_LocateAlong—返回帶有與指定度量匹配的元素的派生幾何集合值辅鲸。不支持多邊形元素汰规。

ST_LocateAlong— Return a derived geometry collection value with elements that match the specified measure. Polygonal elements are not supported.

ST_LocateBetween—返回派生的幾何集合值设捐，其元素與指定范圍的測量值（包括端值）進行匹配芳室。

ST_LocateBetween— Return a derived geometry collection value with elements that match the specified range of measures inclusively.

ST_LocateBetweenElevations—返回派生的幾何（集合）值树瞭，其元素與指定的高程范圍相交魁兼。

ST_LocateBetweenElevations— Return a derived geometry (collection) value with elements that intersect the specified range of elevations inclusively.

ST_InterpolatePoint—返回在靠近提供的點的點處的幾何的度量尺寸的值典徊。

ST_InterpolatePoint— Return the value of the measure dimension of a geometry at the point closed to the provided point.

ST_AddMeasure—返回帶有在起點和終點之間線性插值的測量元素的派生幾何颤专。

ST_AddMeasure— Return a derived geometry with measure elements linearly interpolated between the start and end points.

Trajectory Functions

ST_IsValidTrajectory—返回true幾何是否為有效軌跡寄啼。

ST_IsValidTrajectory— Returns?true?if the geometry is a valid trajectory.

ST_ClosestPointOfApproach—返回沿兩個軌跡插補的點最近的度量宿接。

ST_ClosestPointOfApproach— Returns the measure at which points interpolated along two trajectories are closest.

ST_DistanceCPA—返回兩個軌跡的最接近點之間的距離赘淮。

ST_DistanceCPA— Returns the distance between the closest point of approach of two trajectories.

ST_CPAWithin—返回true兩個軌跡的最接近點是否在指定距離內。

ST_CPAWithin— Returns?true?if the closest point of approach of two trajectories is within the specified distance.

TIPS

1. 支持使用軌跡睦霎。軌跡是在每個坐標上帶有度量（M值）的線性幾何梢卸。測量值必須沿線增加。時空數據可以通過使用相對時間（例如紀元）作為度量值來建模副女。

?SFCGAL Functions

postgis_sfcgal_version—返回正在使用的SFCGAL的版本

postgis_sfcgal_version— Returns the version of SFCGAL in use

ST_Extrude—將曲面拉伸到相關體積

ST_Extrude— Extrude a surface to a related volume

ST_StraightSkeleton—根據幾何計算直線骨架

ST_StraightSkeleton— Compute a straight skeleton from a geometry

ST_ApproximateMedialAxis—計算平面幾何的近似中間軸蛤高。

ST_ApproximateMedialAxis— Compute the approximate medial axis of an areal geometry.

ST_IsPlanar—檢查曲面是否為平面

ST_IsPlanar— Check if a surface is or not planar

ST_Orientation—確定表面方向

ST_Orientation— Determine surface orientation

ST_ForceLHR—強制LHR方向

ST_ForceLHR— Force LHR orientation

ST_MinkowskiSum—執(zhí)行Minkowski和

ST_MinkowskiSum— Performs Minkowski sum

ST_ConstrainedDelaunayTriangles—返回圍繞給定輸入幾何形狀的約束Delaunay三角剖分。

ST_ConstrainedDelaunayTriangles— Return a constrained Delaunay triangulation around the given input geometry.

ST_3DIntersection—執(zhí)行3D相交

ST_3DIntersection— Perform 3D intersection

ST_3DDifference—執(zhí)行3D差異

ST_3DDifference— Perform 3D difference

ST_3DUnion—執(zhí)行3D合并

ST_3DUnion— Perform 3D union

ST_3DArea—計算3D表面幾何形狀的面積碑幅。實體將返回0戴陡。

ST_3DArea— Computes area of 3D surface geometries. Will return 0 for solids.

ST_Tesselate—執(zhí)行多邊形或多面曲面的表面鑲嵌處理，并以TIN或TINS集合的形式返回

ST_3DArea— Computes area of 3D surface geometries. Will return 0 for solids.

ST_Volume—計算3D實體的體積沟涨。如果應用于表面（甚至閉合）幾何恤批，則將返回0。

ST_Volume— Computes the volume of a 3D solid. If applied to surface (even closed) geometries will return 0.

ST_MakeSolid—將幾何體轉換為實體裹赴。不執(zhí)行檢查喜庞。為了獲得有效的實體，輸入幾何必須為封閉的多面曲面或封閉的TIN棋返。

ST_MakeSolid— Cast the geometry into a solid. No check is performed. To obtain a valid solid, the input geometry must be a closed Polyhedral Surface or a closed TIN.

ST_IsSolid—測試幾何是否為實體延都。不執(zhí)行有效性檢查。

ST_IsSolid— Test if the geometry is a solid. No validity check is performed.