Amazon Redshift ne prendra plus en charge la création de nouveaux UDFs Python à partir du patch 198. Les fonctions Python définies par l’utilisateur existantes continueront de fonctionner normalement jusqu’au 30 juin 2026. Pour plus d’informations, consultez le [ billet de blog ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). Les traductions sont fournies par des outils de traduction automatique. En cas de conflit entre le contenu d'une traduction et celui de la version originale en anglais, la version anglaise prévaudra. # Fonctions spatiales Les relations entre les objets de géométrie sont basées sur le modèle à neuf intersections dimensionnellement étendu (). DE-9IM Ce modèle définit des prédicats tels que est égal à, contient et couvre. Pour plus d'informations sur la définition des relations spatiales, consultez [DE-9IM](https://en.wikipedia.org/wiki/DE-9IM)Wikipedia. Pour plus d’informations sur l’utilisation des données spatiales avec Amazon Redshift, consultez [Interrogation des données spatiales dans Amazon Redshift](geospatial-overview.md). Amazon Redshift fournit des fonctions spatiales qui fonctionnent avec les types de données `GEOMETRY` et `GEOGRAPHY`. La liste suivante répertorie les fonctions qui prennent en charge le type de données `GEOGRAPHY` : + [ST\_Area](ST_Area-function.md) + [ST\_AsEWKT](ST_AsEWKT-function.md) + [ST\_JSON AsGeo](ST_AsGeoJSON-function.md) + [ST\_WEBB AsHex](ST_AsHexEWKB-function.md) + [ST\_WKB AsHex](ST_AsHexWKB-function.md) + [ST\_ AsText](ST_AsText-function.md) + [ST\_Distance](ST_Distance-function.md) + [ST\_ GeogFromText](ST_GeogFromText-function.md) + [ST\_WKB GeogFrom](ST_GeogFromWKB-function.md) + [ST\_Length](ST_Length-function.md) + [ST\_NPoints](ST_NPoints-function.md) + [ST\_Perimeter](ST_Perimeter-function.md) La liste suivante répertorie l’ensemble complet des fonctions spatiales prises en charge par 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) + [Résolution H3\_](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\_JSON AsGeo](ST_AsGeoJSON-function.md) + [ST\_WKB AsHex](ST_AsHexWKB-function.md) + [ST\_WEBB AsHex](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\_Enveloppe](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\_WKB GeogFrom](ST_GeogFromWKB-function.md) + [ST\_GeometryN](ST_GeometryN-function.md) + [ST\_ GeometryType](ST_GeometryType-function.md) + [ST\_WEBB GeomFrom](ST_GeomFromEWKB-function.md) + [ST\_EWKT GeomFrom](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\_WKB GeomFrom](ST_GeomFromWKB-function.md) + [ST\_ GeoSquare](ST_GeoSquare-function.md) + [ST\_N InteriorRing](ST_InteriorRingN-function.md) + [ST\_Intersects](ST_Intersects-function.md) + [ST\_Intersection](ST_Intersection-function.md) + [ST\_CCW IsPolygon](ST_IsPolygonCCW-function.md) + [ST\_CW IsPolygon](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)