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 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\_Area](ST_Area-function.md) + [ST\_AsEWKT](ST_AsEWKT-function.md) + [ST\_ JSON AsGeo](ST_AsGeoJSON-function.md) + [ST\_ EWKB 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) + [GeogFromST\_ WKB](ST_GeogFromWKB-function.md) + [ST\_Length](ST_Length-function.md) + [ST\_ NPoints](ST_NPoints-function.md) + [ST\_Perimeter](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\_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\_ JSON AsGeo](ST_AsGeoJSON-function.md) + [ST\_ WKB AsHex](ST_AsHexWKB-function.md) + [ST\_ EWKB 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\_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) + [GeogFromST\_ WKB](ST_GeogFromWKB-function.md) + [ST\_GeometryN](ST_GeometryN-function.md) + [ST\_ GeometryType](ST_GeometryType-function.md) + [ST\_ EWKB GeomFrom](ST_GeomFromEWKB-function.md) + [ST\_ GeomFrom EWKT](ST_GeomFromEWKT-function.md) + [ST\_ GeomFromGeoHash](ST_GeomFromGeoHash-function.md) + [GeomFromGeoST\_ JSON](ST_GeomFromGeoJSON-function.md) + [ST\_ GeomFromGeoSquare](ST_GeomFromGeoSquare-function.md) + [ST\_ GeomFromText](ST_GeomFromText-function.md) + [GeomFromST\_ WKB](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) + [IsPolygonST\_ CCW](ST_IsPolygonCCW-function.md) + [IsPolygonST\_ CW](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) + [Supporta BBox](SupportsBBox-function.md)