Amazon Redshift non supporterà più la creazione di nuovi Python UDFs a partire dalla Patch 198. Python esistente UDFs continuerà a funzionare fino al 30 giugno 2026. Per ulteriori informazioni, consulta il [post del blog](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

Le traduzioni sono generate tramite traduzione automatica. In caso di conflitto tra il contenuto di una traduzione e la versione originale in Inglese, quest'ultima prevarrà.

# Funzioni spaziali
<a name="geospatial-functions"></a>

Le relazioni tra oggetti geometrici si basano sul modello Dimensionally Extended nine-Intersection Model (DE-9IM). Questo modello definisce predicati come uguale, contiene e ricopre. Per ulteriori informazione sulla definizione delle relazioni spaziali, consultare [DE-9IM](https://en.wikipedia.org/wiki/DE-9IM) su Wikipedia.

Per ulteriori informazioni su come utilizzare i dati spaziali con Amazon Redshift, consulta [Query su dati spaziali in Amazon Redshift](geospatial-overview.md).

Amazon Redshift fornisce funzioni spaziali che funzionano con i tipi di dati `GEOMETRY` e `GEOGRAPHY`. Di seguito sono elencate le funzioni che supportano il tipo di dati `GEOGRAPHY`:
+ [ST\$1Area](ST_Area-function.md)
+ [ST\$1AsEWKT](ST_AsEWKT-function.md)
+ [ST\$1 JSON AsGeo](ST_AsGeoJSON-function.md)
+ [ST\$1 EWKB AsHex](ST_AsHexEWKB-function.md)
+ [ST\$1 WKB 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)
+ [GeogFromST\$1 WKB](ST_GeogFromWKB-function.md)
+ [ST\$1Length](ST_Length-function.md)
+ [ST\$1 NPoints](ST_NPoints-function.md)
+ [ST\$1Perimeter](ST_Perimeter-function.md)

Di seguito viene elencato il set completo di funzioni spaziali supportate da Amazon Redshift. 

**Topics**
+ [Aggiungi BBox](AddBBox-function.md)
+ [Rilascia 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)
+ [H3\$1Resolution](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\$1 JSON AsGeo](ST_AsGeoJSON-function.md)
+ [ST\$1 WKB AsHex](ST_AsHexWKB-function.md)
+ [ST\$1 EWKB 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\$1Envelope](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)
+ [GeogFromST\$1 WKB](ST_GeogFromWKB-function.md)
+ [ST\$1GeometryN](ST_GeometryN-function.md)
+ [ST\$1 GeometryType](ST_GeometryType-function.md)
+ [ST\$1 EWKB GeomFrom](ST_GeomFromEWKB-function.md)
+ [ST\$1 GeomFrom EWKT](ST_GeomFromEWKT-function.md)
+ [ST\$1 GeomFromGeoHash](ST_GeomFromGeoHash-function.md)
+ [GeomFromGeoST\$1 JSON](ST_GeomFromGeoJSON-function.md)
+ [ST\$1 GeomFromGeoSquare](ST_GeomFromGeoSquare-function.md)
+ [ST\$1 GeomFromText](ST_GeomFromText-function.md)
+ [GeomFromST\$1 WKB](ST_GeomFromWKB-function.md)
+ [ST\$1 GeoSquare](ST_GeoSquare-function.md)
+ [ST\$1 N InteriorRing](ST_InteriorRingN-function.md)
+ [ST\$1Intersects](ST_Intersects-function.md)
+ [ST\$1Intersection](ST_Intersection-function.md)
+ [IsPolygonST\$1 CCW](ST_IsPolygonCCW-function.md)
+ [IsPolygonST\$1 CW](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)
+ [Supporta BBox](SupportsBBox-function.md)