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
<a name="geospatial-functions"></a>

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\$1Area](ST_Area-function.md)
+ [ST\$1AsEWKT](ST_AsEWKT-function.md)
+ [ST\$1JSON AsGeo](ST_AsGeoJSON-function.md)
+ [ST\$1WEBB AsHex](ST_AsHexEWKB-function.md)
+ [ST\$1WKB AsHex](ST_AsHexWKB-function.md)
+ [ST\$1 AsText](ST_AsText-function.md)
+ [ST\$1Distance](ST_Distance-function.md)
+ [ST\$1 GeogFromText](ST_GeogFromText-function.md)
+ [ST\$1WKB GeogFrom](ST_GeogFromWKB-function.md)
+ [ST\$1Length](ST_Length-function.md)
+ [ST\$1 NPoints](ST_NPoints-function.md)
+ [ST\$1Perimeter](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\$1Boundary](H3_Boundary-function.md)
+ [H3\$1Center](H3_Center-function.md)
+ [H3\$1 FromLongLat](H3_FromLongLat-function.md)
+ [H3\$1 FromPoint](H3_FromPoint-function.md)
+ [H3\$1 IsValid](H3_IsValid-function.md)
+ [H3\$1Polyfill](H3_Polyfill-function.md)
+ [Résolution H3\$1](H3_Resolution-function.md)
+ [H3\$1 ToChildren](H3_ToChildren-function.md)
+ [H3\$1 ToParent](H3_ToParent-function.md)
+ [ST\$1 AddPoint](ST_AddPoint-function.md)
+ [ST\$1Angle](ST_Angle-function.md)
+ [ST\$1Area](ST_Area-function.md)
+ [ST\$1 AsBinary](ST_AsBinary-function.md)
+ [ST\$1AsEWKB](ST_AsEWKB-function.md)
+ [ST\$1AsEWKT](ST_AsEWKT-function.md)
+ [ST\$1JSON AsGeo](ST_AsGeoJSON-function.md)
+ [ST\$1WKB AsHex](ST_AsHexWKB-function.md)
+ [ST\$1WEBB AsHex](ST_AsHexEWKB-function.md)
+ [ST\$1 AsText](ST_AsText-function.md)
+ [ST\$1Azimuth](ST_Azimuth-function.md)
+ [ST\$1Boundary](ST_Boundary-function.md)
+ [ST\$1Buffer](ST_Buffer-function.md)
+ [ST\$1Centroid](ST_Centroid-function.md)
+ [ST\$1Collect](ST_Collect-function.md)
+ [ST\$1Contains](ST_Contains-function.md)
+ [ST\$1 ContainsProperly](ST_ContainsProperly-function.md)
+ [ST\$1 ConvexHull](ST_ConvexHull-function.md)
+ [ST\$1 CoveredBy](ST_CoveredBy-function.md)
+ [ST\$1Covers](ST_Covers-function.md)
+ [ST\$1Crosses](ST_Crosses-function.md)
+ [ST\$1Dimension](ST_Dimension-function.md)
+ [ST\$1Disjoint](ST_Disjoint-function.md)
+ [ST\$1Distance](ST_Distance-function.md)
+ [ST\$1 DistanceSphere](ST_DistanceSphere-function.md)
+ [ST\$1 DWithin](ST_DWithin-function.md)
+ [ST\$1 EndPoint](ST_EndPoint-function.md)
+ [ST\$1Enveloppe](ST_Envelope-function.md)
+ [ST\$1Equals](ST_Equals-function.md)
+ [ST\$1 ExteriorRing](ST_ExteriorRing-function.md)
+ [ST\$1Force2D](ST_Force2D-function.md)
+ [ST\$1Force3D](ST_Force3D-function.md)
+ [ST\$1Force3DM](ST_Force3DM-function.md)
+ [ST\$1Force3DZ](ST_Force3DZ-function.md)
+ [ST\$1Force4D](ST_Force4D-function.md)
+ [ST\$1 GeoHash](ST_GeoHash-function.md)
+ [ST\$1 GeogFromText](ST_GeogFromText-function.md)
+ [ST\$1WKB GeogFrom](ST_GeogFromWKB-function.md)
+ [ST\$1GeometryN](ST_GeometryN-function.md)
+ [ST\$1 GeometryType](ST_GeometryType-function.md)
+ [ST\$1WEBB GeomFrom](ST_GeomFromEWKB-function.md)
+ [ST\$1EWKT GeomFrom](ST_GeomFromEWKT-function.md)
+ [ST\$1 GeomFromGeoHash](ST_GeomFromGeoHash-function.md)
+ [ST\$1JSON GeomFromGeo](ST_GeomFromGeoJSON-function.md)
+ [ST\$1 GeomFromGeoSquare](ST_GeomFromGeoSquare-function.md)
+ [ST\$1 GeomFromText](ST_GeomFromText-function.md)
+ [ST\$1WKB GeomFrom](ST_GeomFromWKB-function.md)
+ [ST\$1 GeoSquare](ST_GeoSquare-function.md)
+ [ST\$1N InteriorRing](ST_InteriorRingN-function.md)
+ [ST\$1Intersects](ST_Intersects-function.md)
+ [ST\$1Intersection](ST_Intersection-function.md)
+ [ST\$1CCW IsPolygon](ST_IsPolygonCCW-function.md)
+ [ST\$1CW IsPolygon](ST_IsPolygonCW-function.md)
+ [ST\$1 IsClosed](ST_IsClosed-function.md)
+ [ST\$1 IsCollection](ST_IsCollection-function.md)
+ [ST\$1 IsEmpty](ST_IsEmpty-function.md)
+ [ST\$1 IsRing](ST_IsRing-function.md)
+ [ST\$1 IsSimple](ST_IsSimple-function.md)
+ [ST\$1 IsValid](ST_IsValid-function.md)
+ [ST\$1Length](ST_Length-function.md)
+ [ST\$1 LengthSphere](ST_LengthSphere-function.md)
+ [ST\$1Length2D](ST_Length2D-function.md)
+ [ST\$1 LineFromMultiPoint](ST_LineFromMultiPoint-function.md)
+ [ST\$1 LineInterpolatePoint](ST_LineInterpolatePoint-function.md)
+ [ST\$1M](ST_M-function.md)
+ [ST\$1 MakeEnvelope](ST_MakeEnvelope-function.md)
+ [ST\$1 MakeLine](ST_MakeLine-function.md)
+ [ST\$1 MakePoint](ST_MakePoint-function.md)
+ [ST\$1 MakePolygon](ST_MakePolygon-function.md)
+ [ST\$1 MemSize](ST_MemSize-function.md)
+ [ST\$1 MMax](ST_MMax-function.md)
+ [ST\$1 MMin](ST_MMin-function.md)
+ [ST\$1Multi](ST_Multi-function.md)
+ [ST\$1 NDims](ST_NDims-function.md)
+ [ST\$1 NPoints](ST_NPoints-function.md)
+ [ST\$1 NRings](ST_NRings-function.md)
+ [ST\$1 NumGeometries](ST_NumGeometries-function.md)
+ [ST\$1 NumInteriorRings](ST_NumInteriorRings-function.md)
+ [ST\$1 NumPoints](ST_NumPoints-function.md)
+ [ST\$1Perimeter](ST_Perimeter-function.md)
+ [ST\$1Perimeter2D](ST_Perimeter2D-function.md)
+ [ST\$1Point](ST_Point-function.md)
+ [ST\$1PointN](ST_PointN-function.md)
+ [ST\$1Points](ST_Points-function.md)
+ [ST\$1Polygon](ST_Polygon-function.md)
+ [ST\$1 RemovePoint](ST_RemovePoint-function.md)
+ [ST\$1Reverse](ST_Reverse-function.md)
+ [ST\$1 SetPoint](ST_SetPoint-function.md)
+ [ST\$1SetSRID](ST_SetSRID-function.md)
+ [ST\$1Simplify](ST_Simplify-function.md)
+ [ST\$1SRID](ST_SRID-function.md)
+ [ST\$1 StartPoint](ST_StartPoint-function.md)
+ [ST\$1Touches](ST_Touches-function.md)
+ [ST\$1Transform](ST_Transform-function.md)
+ [ST\$1Union](ST_Union-function.md)
+ [ST\$1Within](ST_Within-function.md)
+ [ST\$1X](ST_X-function.md)
+ [ST\$1 XMax](ST_XMax-function.md)
+ [ST\$1 XMin](ST_XMin-function.md)
+ [ST\$1Y](ST_Y-function.md)
+ [ST\$1 YMax](ST_YMax-function.md)
+ [ST\$1 YMin](ST_YMin-function.md)
+ [ST\$1Z](ST_Z-function.md)
+ [ST\$1 ZMax](ST_ZMax-function.md)
+ [ST\$1 ZMin](ST_ZMin-function.md)
+ [Supports BBox](SupportsBBox-function.md)