GeomCollection() | Construct geometry collection from geometries从几何图形构造几何图形集合 | |
|---|
GeometryCollection() | Construct geometry collection from geometries从几何图形构造几何图形集合 | |
|---|
LineString() | Construct LineString from Point values从点值构造线字符串 | |
|---|
MBRContains() | Whether MBR of one geometry contains MBR of another一个几何体的MBR是否包含另一个几何体的MBR | |
|---|
MBRCoveredBy() | Whether one MBR is covered by another一个MBR是否被另一个MBR覆盖 | |
|---|
MBRCovers() | Whether one MBR covers another一个MBR是否覆盖另一个MBR | |
|---|
MBRDisjoint() | Whether MBRs of two geometries are disjoint两种几何形状的mbr是否不相交 | |
|---|
MBREquals() | Whether MBRs of two geometries are equal两种几何形状的MBR是否相等 | |
|---|
MBRIntersects() | Whether MBRs of two geometries intersect两种几何形状的MBR是否相交 | |
|---|
MBROverlaps() | Whether MBRs of two geometries overlap两种几何形状的MBR是否重叠 | |
|---|
MBRTouches() | Whether MBRs of two geometries touch两种几何形状的MBR是否接触 | |
|---|
MBRWithin() | Whether MBR of one geometry is within MBR of another一种几何形状的MBR是否在另一种几何形状的MBR内 | |
|---|
MultiLineString() | Contruct MultiLineString from LineString values从字符串值构造多重字符串 | |
|---|
MultiPoint() | Construct MultiPoint from Point values从点值构造多点 | |
|---|
MultiPolygon() | Construct MultiPolygon from Polygon values从多边形值构造多多边形 | |
|---|
Point() | Construct Point from coordinates从坐标构造点 | |
|---|
Polygon() | Construct Polygon from LineString arguments从LineString参数构造多边形 | |
|---|
ST_Area() | Return Polygon or MultiPolygon area返回多边形或多边形区域 | |
|---|
ST_AsBinary(), ST_AsWKB() | Convert from internal geometry format to WKB从内部几何图形格式转换为WKB | |
|---|
ST_AsGeoJSON() | Generate GeoJSON object from geometry从几何体生成GeoJSON对象 | |
|---|
ST_AsText(), ST_AsWKT() | Convert from internal geometry format to WKT从内部几何图形格式转换为WKT | |
|---|
ST_Buffer() | Return geometry of points within given distance from geometry返回距几何体给定距离内点的几何体 | |
|---|
ST_Buffer_Strategy() | Produce strategy option for ST_Buffer()生成ST_Buffer()的策略选项 | |
|---|
ST_Centroid() | Return centroid as a point返回质心作为点 | |
|---|
ST_Collect() | Aggregate spatial values into collection将空间值聚合到集合中 | 8.0.24 |
|---|
ST_Contains() | Whether one geometry contains another一个几何体是否包含另一个几何体 | |
|---|
ST_ConvexHull() | Return convex hull of geometry返回几何凸包 | |
|---|
ST_Crosses() | Whether one geometry crosses another一个几何体是否与另一个几何体相交 | |
|---|
ST_Difference() | Return point set difference of two geometries两种几何的返回点集差 | |
|---|
ST_Dimension() | Dimension of geometry几何尺寸 | |
|---|
ST_Disjoint() | Whether one geometry is disjoint from another一个几何体与另一个几何体是否不相交 | |
|---|
ST_Distance() | The distance of one geometry from another一个几何体与另一个几何体的距离 | |
|---|
ST_Distance_Sphere() | Minimum distance on earth between two geometries地球上两个几何体之间的最小距离 | |
|---|
ST_EndPoint() | End Point of LineString线串的终点 | |
|---|
ST_Envelope() | Return MBR of geometry返回几何体的MBR | |
|---|
ST_Equals() | Whether one geometry is equal to another一个几何体是否等于另一个几何体 | |
|---|
ST_ExteriorRing() | Return exterior ring of Polygon返回多边形外环 | |
|---|
ST_FrechetDistance() | The discrete Fréchet distance of one geometry from another一个几何体与另一个几何体的离散距离 | 8.0.23 |
|---|
ST_GeoHash() | Produce a geohash value生成geohash值 | |
|---|
ST_GeomCollFromText(), ST_GeometryCollectionFromText(), ST_GeomCollFromTxt() | Return geometry collection from WKT从WKT返回几何体集合 | |
|---|
ST_GeomCollFromWKB(), ST_GeometryCollectionFromWKB() | Return geometry collection from WKB从WKB返回几何体集合 | |
|---|
ST_GeometryN() | Return N-th geometry from geometry collection从几何体集合返回第N个几何体 | |
|---|
ST_GeometryType() | Return name of geometry type返回几何体类型的名称 | |
|---|
ST_GeomFromGeoJSON() | Generate geometry from GeoJSON object从GeoJSON对象生成几何体 | |
|---|
ST_GeomFromText(), ST_GeometryFromText() | Return geometry from WKT从WKT返回几何体 | |
|---|
ST_GeomFromWKB(), ST_GeometryFromWKB() | Return geometry from WKB从WKB返回几何体 | |
|---|
ST_HausdorffDistance() | The discrete Hausdorff distance of one geometry from another一个几何体与另一个几何体的离散Hausdorff距离 | 8.0.23 |
|---|
ST_InteriorRingN() | Return N-th interior ring of Polygon返回多边形的第N个内环 | |
|---|
ST_Intersection() | Return point set intersection of two geometries返回点集两个几何体的交集 | |
|---|
ST_Intersects() | Whether one geometry intersects another一个几何体是否与另一个几何体相交 | |
|---|
ST_IsClosed() | Whether a geometry is closed and simple几何图形是否闭合且简单 | |
|---|
ST_IsEmpty() | Whether a geometry is empty几何图形是否为空 | |
|---|
ST_IsSimple() | Whether a geometry is simple几何图形是否简单 | |
|---|
ST_IsValid() | Whether a geometry is valid几何图形是否有效 | |
|---|
ST_LatFromGeoHash() | Return latitude from geohash value从geohash值返回纬度 | |
|---|
ST_Latitude() | Return latitude of Point返回点纬度 | 8.0.12 |
|---|
ST_Length() | Return length of LineString返回字符串的长度 | |
|---|
ST_LineFromText(), ST_LineStringFromText() | Construct LineString from WKT从WKT构造LineString | |
|---|
ST_LineFromWKB(), ST_LineStringFromWKB() | Construct LineString from WKB从WKB构造LineString | |
|---|
ST_LineInterpolatePoint() | The point a given percentage along a LineString沿一条线的给定百分比的点 | 8.0.24 |
|---|
ST_LineInterpolatePoints() | The points a given percentage along a LineString沿线串以给定百分比表示的点 | 8.0.24 |
|---|
ST_LongFromGeoHash() | Return longitude from geohash value从geohash值返回经度 | |
|---|
ST_Longitude() | Return longitude of Point返回点的经度 | 8.0.12 |
|---|
ST_MakeEnvelope() | Rectangle around two points围绕两点的矩形 | |
|---|
ST_MLineFromText(), ST_MultiLineStringFromText() | Construct MultiLineString from WKT从WKT构造多重线 | |
|---|
ST_MLineFromWKB(), ST_MultiLineStringFromWKB() | Construct MultiLineString from WKB从WKB构造多重线 | |
|---|
ST_MPointFromText(), ST_MultiPointFromText() | Construct MultiPoint from WKT从WKT构造多点 | |
|---|
ST_MPointFromWKB(), ST_MultiPointFromWKB() | Construct MultiPoint from WKB从WKB构造多点 | |
|---|
ST_MPolyFromText(), ST_MultiPolygonFromText() | Construct MultiPolygon from WKT从WKT构造多多边形 | |
|---|
ST_MPolyFromWKB(), ST_MultiPolygonFromWKB() | Construct MultiPolygon from WKB从WKB构造多多边形 | |
|---|
ST_NumGeometries() | Return number of geometries in geometry collection返回几何图形集合中的几何图形数 | |
|---|
ST_NumInteriorRing(), ST_NumInteriorRings() | Return number of interior rings in Polygon返回多边形内环数 | |
|---|
ST_NumPoints() | Return number of points in LineString返回LineString中的点数 | |
|---|
ST_Overlaps() | Whether one geometry overlaps another一个几何体是否与另一个几何体重叠 | |
|---|
ST_PointAtDistance() | The point a given distance along a LineString沿着一条线的给定距离的点 | 8.0.24 |
|---|
ST_PointFromGeoHash() | Convert geohash value to POINT value将geohash值转换为POINT值 | |
|---|
ST_PointFromText() | Construct Point from WKT从WKT构造点 | |
|---|
ST_PointFromWKB() | Construct Point from WKB从WKB构造点 | |
|---|
ST_PointN() | Return N-th point from LineString从LineString返回第N个点 | |
|---|
ST_PolyFromText(), ST_PolygonFromText() | Construct Polygon from WKT从WKT构造多边形 | |
|---|
ST_PolyFromWKB(), ST_PolygonFromWKB() | Construct Polygon from WKB从WKB构造多边形 | |
|---|
ST_Simplify() | Return simplified geometry返回简化几何图形 | |
|---|
ST_SRID() | Return spatial reference system ID for geometry返回几何图形的空间参考系统ID | |
|---|
ST_StartPoint() | Start Point of LineString线串的起点 | |
|---|
ST_SwapXY() | Return argument with X/Y coordinates swapped交换X/Y坐标的返回参数 | |
|---|
ST_SymDifference() | Return point set symmetric difference of two geometries返回点集两几何对称差 | |
|---|
ST_Touches() | Whether one geometry touches another一个几何体是否接触另一个几何体 | |
|---|
ST_Transform() | Transform coordinates of geometry几何变换坐标 | 8.0.13 |
|---|
ST_Union() | Return point set union of two geometries返回点集两个几何体的并集 | |
|---|
ST_Validate() | Return validated geometry返回验证的几何图形 | |
|---|
ST_Within() | Whether one geometry is within another一个几何体是否在另一个几何体中 | |
|---|
ST_X() | Return X coordinate of Point返回点的X坐标 | |
|---|
ST_Y() | Return Y coordinate of Point返回点的Y坐标 | |
|---|