Amazon Redshift ne prendra plus en charge la création de nouveaux Python à UDFs partir du patch 198. UDFs Le Python existant continuera de fonctionner 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 DE-9IM (Dimensionally Extended nine-Intersection Model). 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) dans 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** + [Ajouter BBox](AddBBox-function.md) + [Lâchez BBox](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\_JSON GeomFromGeo](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) + [Supports BBox](SupportsBBox-function.md)