从补丁 198 开始，Amazon Redshift 将不再支持创建新的 Python UDF。现有的 Python UDF 将继续正常运行至 2026 年 6 月 30 日。有关更多信息，请参阅[博客文章](https://www.amazonaws.cn/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/)。 # 空间函数 几何对象之间的关系基于维度扩展的九交模型 (DE-9IM)。此模型定义了诸如等于、包含和覆盖之类的谓词。有关空间关系的定义的更多信息，请参阅 Wikipedia 中的 [DE-9IM](https://en.wikipedia.org/wiki/DE-9IM)。 有关如何在 Amazon Redshift 中使用空间数据的更多信息，请参阅[在 Amazon Redshift 中查询空间数据](geospatial-overview.md)。 Amazon Redshift 提供了可以使用 `GEOMETRY` 和 `GEOGRAPHY` 数据类型的空间函数。下面列出了支持 `GEOGRAPHY` 数据类型的函数： + [ST\_Area](ST_Area-function.md) + [ST\_AsEWKT](ST_AsEWKT-function.md) + [ST\_AsGeoJSON](ST_AsGeoJSON-function.md) + [ST\_AsHexEWKB](ST_AsHexEWKB-function.md) + [ST\_AsHexWKB](ST_AsHexWKB-function.md) + [ST\_AsText](ST_AsText-function.md) + [ST\_Distance](ST_Distance-function.md) + [ST\_GeogFromText](ST_GeogFromText-function.md) + [ST\_GeogFromWKB](ST_GeogFromWKB-function.md) + [ST\_Length](ST_Length-function.md) + [ST\_NPoints](ST_NPoints-function.md) + [ST\_Perimeter](ST_Perimeter-function.md) 下面列出了 Amazon Redshift 支持的全套空间函数。 **Topics** + [AddBBox](AddBBox-function.md) + [DropBBox](DropBBox-function.md) + [GeometryType](GeometryType-function.md) + [H3\_Boundary](H3_Boundary-function.md) + [H3\_Center](H3_Center-function.md) + [H3\_FromLongLat](H3_FromLongLat-function.md) + [H3\_FromPoint](H3_FromPoint-function.md) + [H3\_IsValid](H3_IsValid-function.md) + [H3\_Polyfill](H3_Polyfill-function.md) + [H3\_Resolution](H3_Resolution-function.md) + [H3\_ToChildren](H3_ToChildren-function.md) + [H3\_ToParent](H3_ToParent-function.md) + [ST\_AddPoint](ST_AddPoint-function.md) + [ST\_Angle](ST_Angle-function.md) + [ST\_Area](ST_Area-function.md) + [ST\_AsBinary](ST_AsBinary-function.md) + [ST\_AsEWKB](ST_AsEWKB-function.md) + [ST\_AsEWKT](ST_AsEWKT-function.md) + [ST\_AsGeoJSON](ST_AsGeoJSON-function.md) + [ST\_AsHexWKB](ST_AsHexWKB-function.md) + [ST\_AsHexEWKB](ST_AsHexEWKB-function.md) + [ST\_AsText](ST_AsText-function.md) + [ST\_Azimuth](ST_Azimuth-function.md) + [ST\_Boundary](ST_Boundary-function.md) + [ST\_Buffer](ST_Buffer-function.md) + [ST\_Centroid](ST_Centroid-function.md) + [ST\_Collect](ST_Collect-function.md) + [ST\_Contains](ST_Contains-function.md) + [ST\_ContainsProperly](ST_ContainsProperly-function.md) + [ST\_ConvexHull](ST_ConvexHull-function.md) + [ST\_CoveredBy](ST_CoveredBy-function.md) + [ST\_Covers](ST_Covers-function.md) + [ST\_Crosses](ST_Crosses-function.md) + [ST\_Dimension](ST_Dimension-function.md) + [ST\_Disjoint](ST_Disjoint-function.md) + [ST\_Distance](ST_Distance-function.md) + [ST\_DistanceSphere](ST_DistanceSphere-function.md) + [ST\_DWithin](ST_DWithin-function.md) + [ST\_EndPoint](ST_EndPoint-function.md) + [ST\_Envelope](ST_Envelope-function.md) + [ST\_Equals](ST_Equals-function.md) + [ST\_ExteriorRing](ST_ExteriorRing-function.md) + [ST\_Force2D](ST_Force2D-function.md) + [ST\_Force3D](ST_Force3D-function.md) + [ST\_Force3DM](ST_Force3DM-function.md) + [ST\_Force3DZ](ST_Force3DZ-function.md) + [ST\_Force4D](ST_Force4D-function.md) + [ST\_GeoHash](ST_GeoHash-function.md) + [ST\_GeogFromText](ST_GeogFromText-function.md) + [ST\_GeogFromWKB](ST_GeogFromWKB-function.md) + [ST\_GeometryN](ST_GeometryN-function.md) + [ST\_GeometryType](ST_GeometryType-function.md) + [ST\_GeomFromEWKB](ST_GeomFromEWKB-function.md) + [ST\_GeomFromEWKT](ST_GeomFromEWKT-function.md) + [ST\_GeomFromGeoHash](ST_GeomFromGeoHash-function.md) + [ST\_GeomFromGeoJSON](ST_GeomFromGeoJSON-function.md) + [ST\_GeomFromGeoSquare](ST_GeomFromGeoSquare-function.md) + [ST\_GeomFromText](ST_GeomFromText-function.md) + [ST\_GeomFromWKB](ST_GeomFromWKB-function.md) + [ST\_GeoSquare](ST_GeoSquare-function.md) + [ST\_InteriorRingN](ST_InteriorRingN-function.md) + [ST\_Intersects](ST_Intersects-function.md) + [ST\_Intersection](ST_Intersection-function.md) + [ST\_IsPolygonCCW](ST_IsPolygonCCW-function.md) + [ST\_IsPolygonCW](ST_IsPolygonCW-function.md) + [ST\_IsClosed](ST_IsClosed-function.md) + [ST\_IsCollection](ST_IsCollection-function.md) + [ST\_IsEmpty](ST_IsEmpty-function.md) + [ST\_IsRing](ST_IsRing-function.md) + [ST\_IsSimple](ST_IsSimple-function.md) + [ST\_IsValid](ST_IsValid-function.md) + [ST\_Length](ST_Length-function.md) + [ST\_LengthSphere](ST_LengthSphere-function.md) + [ST\_Length2D](ST_Length2D-function.md) + [ST\_LineFromMultiPoint](ST_LineFromMultiPoint-function.md) + [ST\_LineInterpolatePoint](ST_LineInterpolatePoint-function.md) + [ST\_M](ST_M-function.md) + [ST\_MakeEnvelope](ST_MakeEnvelope-function.md) + [ST\_MakeLine](ST_MakeLine-function.md) + [ST\_MakePoint](ST_MakePoint-function.md) + [ST\_MakePolygon](ST_MakePolygon-function.md) + [ST\_MemSize](ST_MemSize-function.md) + [ST\_MMax](ST_MMax-function.md) + [ST\_MMin](ST_MMin-function.md) + [ST\_Multi](ST_Multi-function.md) + [ST\_NDims](ST_NDims-function.md) + [ST\_NPoints](ST_NPoints-function.md) + [ST\_NRings](ST_NRings-function.md) + [ST\_NumGeometries](ST_NumGeometries-function.md) + [ST\_NumInteriorRings](ST_NumInteriorRings-function.md) + [ST\_NumPoints](ST_NumPoints-function.md) + [ST\_Perimeter](ST_Perimeter-function.md) + [ST\_Perimeter2D](ST_Perimeter2D-function.md) + [ST\_Point](ST_Point-function.md) + [ST\_PointN](ST_PointN-function.md) + [ST\_Points](ST_Points-function.md) + [ST\_Polygon](ST_Polygon-function.md) + [ST\_RemovePoint](ST_RemovePoint-function.md) + [ST\_Reverse](ST_Reverse-function.md) + [ST\_SetPoint](ST_SetPoint-function.md) + [ST\_SetSRID](ST_SetSRID-function.md) + [ST\_Simplify](ST_Simplify-function.md) + [ST\_SRID](ST_SRID-function.md) + [ST\_StartPoint](ST_StartPoint-function.md) + [ST\_Touches](ST_Touches-function.md) + [ST\_Transform](ST_Transform-function.md) + [ST\_Union](ST_Union-function.md) + [ST\_Within](ST_Within-function.md) + [ST\_X](ST_X-function.md) + [ST\_XMax](ST_XMax-function.md) + [ST\_XMin](ST_XMin-function.md) + [ST\_Y](ST_Y-function.md) + [ST\_YMax](ST_YMax-function.md) + [ST\_YMin](ST_YMin-function.md) + [ST\_Z](ST_Z-function.md) + [ST\_ZMax](ST_ZMax-function.md) + [ST\_ZMin](ST_ZMin-function.md) + [SupportsBBox](SupportsBBox-function.md)