You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sedona.apache.org by ji...@apache.org on 2024/04/29 02:42:07 UTC
(sedona) 01/02: [DOCS] Add 1.5.2 release notes and doc changes (#1378)
This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a commit to branch branch-1.5.2
in repository https://gitbox.apache.org/repos/asf/sedona.git
commit d87189f0382b42c71c83c34d75a4a092c9555b53
Author: Jia Yu <ji...@apache.org>
AuthorDate: Sun Apr 28 13:55:54 2024 -0700
[DOCS] Add 1.5.2 release notes and doc changes (#1378)
---
...na-snowflake.sql => sedona-snowflake-1.5.1.sql} | 0
docs/image/snowflake/sedona-snowflake.sql | 3508 ++++++++++++++------
docs/setup/release-notes.md | 116 +-
docs/usecases/Sedona_OvertureMaps_GeoParquet.ipynb | 23 +
mkdocs.yml | 8 +-
5 files changed, 2558 insertions(+), 1097 deletions(-)
diff --git a/docs/image/snowflake/sedona-snowflake.sql b/docs/image/snowflake/sedona-snowflake-1.5.1.sql
similarity index 100%
copy from docs/image/snowflake/sedona-snowflake.sql
copy to docs/image/snowflake/sedona-snowflake-1.5.1.sql
diff --git a/docs/image/snowflake/sedona-snowflake.sql b/docs/image/snowflake/sedona-snowflake.sql
index f3ec87975..3b3dad56b 100644
--- a/docs/image/snowflake/sedona-snowflake.sql
+++ b/docs/image/snowflake/sedona-snowflake.sql
@@ -1,2340 +1,3668 @@
-- IsNativeApp is false. Generating DDL for User-Managed Snowflake Account
-- UDFs --
-create or replace function sedona.ST_Affine (geometry BINARY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xOff DOUBLE, yOff DOUBLE, zOff DOUBLE)
+create or replace function sedona.ST_SimplifyPreserveTopology (geometry BINARY, distanceTolerance DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Affine'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SimplifyPreserveTopology'
;
-create or replace function sedona.ST_Affine (geometry BINARY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE)
-returns BINARY
+create or replace function sedona.GeometryType (geometry BINARY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Affine'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.GeometryType'
;
-create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY)
-returns DOUBLE
+create or replace function sedona.ST_AddPoint (linestring BINARY, point BINARY, position NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AddPoint'
;
-create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY, geom3 BINARY)
-returns DOUBLE
+create or replace function sedona.ST_AsBinary (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsBinary'
;
-create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY, geom3 BINARY, geom4 BINARY)
-returns DOUBLE
+create or replace function sedona.ST_AsGeoJSON (geometry BINARY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsGeoJSON'
;
-create or replace function sedona.ST_Area (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_Boundary (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Area'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Boundary'
;
-create or replace function sedona.ST_AsEWKB (geometry BINARY)
+create or replace function sedona.ST_BoundingDiagonal (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsEWKB'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_BoundingDiagonal'
;
-create or replace function sedona.ST_AsEWKT (geometry BINARY)
-returns VARCHAR
+create or replace function sedona.ST_BestSRID (geometry BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsEWKT'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_BestSRID'
;
-create or replace function sedona.ST_AsGML (geometry BINARY)
-returns VARCHAR
+create or replace function sedona.ST_ShiftLongitude (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsGML'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ShiftLongitude'
;
-create or replace function sedona.ST_AsKML (geometry BINARY)
-returns VARCHAR
+create or replace function sedona.ST_BuildArea (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsKML'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_BuildArea'
;
-create or replace function sedona.ST_Azimuth (left BINARY, right BINARY)
-returns DOUBLE
+create or replace function sedona.ST_Centroid (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Azimuth'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Centroid'
;
-create or replace function sedona.ST_Buffer (geometry BINARY, radius DOUBLE)
+create or replace function sedona.ST_ClosestPoint (geometry1 BINARY, geometry2 BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Buffer'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ClosestPoint'
;
-create or replace function sedona.ST_Covers (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_CollectionExtract (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Covers'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CollectionExtract'
;
-create or replace function sedona.ST_Crosses (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_CollectionExtract (geometry BINARY, geomType NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Crosses'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CollectionExtract'
;
-create or replace function sedona.ST_Degrees (angleInRadian DOUBLE)
-returns DOUBLE
+create or replace function sedona.ST_ConcaveHull (geometry BINARY, pctConvex DOUBLE, allowHoles BOOLEAN)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Degrees'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConcaveHull'
;
-create or replace function sedona.ST_Equals (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_ConcaveHull (geometry BINARY, pctConvex DOUBLE)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Equals'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConcaveHull'
;
-create or replace function sedona.ST_Force2D (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_Contains (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force2D'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Contains'
;
-create or replace function sedona.ST_GeoHash (geometry BINARY, precision NUMBER)
-returns VARCHAR
+create or replace function sedona.ST_CoordDim (geometry BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeoHash'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CoordDim'
;
-create or replace function sedona.ST_IsEmpty (geometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_ConvexHull (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsEmpty'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConvexHull'
;
-create or replace function sedona.ST_IsRing (geometry BINARY)
+create or replace function sedona.ST_CoveredBy (leftGeometry BINARY, rightGeometry BINARY)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsRing'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CoveredBy'
;
-create or replace function sedona.ST_IsValid (geometry BINARY, flags NUMBER)
+create or replace function sedona.ST_CrossesDateLine (geometry BINARY)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CrossesDateLine'
;
-create or replace function sedona.ST_IsValid (geometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_Difference (leftGeometry BINARY, rightGeometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Difference'
;
-create or replace function sedona.ST_Length (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_Dimension (geometry BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Length'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Dimension'
;
-create or replace function sedona.ST_Multi (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_Disjoint (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Multi'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Disjoint'
;
-create or replace function sedona.ST_NDims (geometry BINARY)
-returns NUMBER
+create or replace function sedona.ST_Distance (left BINARY, right BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NDims'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Distance'
;
-create or replace function sedona.ST_NPoints (geometry BINARY)
-returns NUMBER
+create or replace function sedona.ST_3DDistance (left BINARY, right BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NPoints'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_3DDistance'
;
-create or replace function sedona.ST_Point (x DOUBLE, y DOUBLE)
+create or replace function sedona.ST_DumpPoints (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Point'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DumpPoints'
;
-create or replace function sedona.ST_PointN (geometry BINARY, n NUMBER)
+create or replace function sedona.ST_EndPoint (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointN'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_EndPoint'
;
-create or replace function sedona.ST_PointZ (x DOUBLE, y DOUBLE, z DOUBLE, srid NUMBER)
+create or replace function sedona.ST_Envelope (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointZ'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Envelope'
;
-create or replace function sedona.ST_PointZ (x DOUBLE, y DOUBLE, z DOUBLE)
+create or replace function sedona.ST_ExteriorRing (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointZ'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ExteriorRing'
;
-create or replace function sedona.ST_Polygon (geometry BINARY, srid NUMBER)
+create or replace function sedona.ST_FlipCoordinates (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Polygon'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_FlipCoordinates'
;
-create or replace function sedona.ST_Reverse (geometry BINARY)
+create or replace function sedona.ST_Force_2D (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Reverse'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force_2D'
;
-create or replace function sedona.ST_SRID (geometry BINARY)
-returns NUMBER
+create or replace function sedona.ST_GeomFromGML (gml VARCHAR)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SRID'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGML'
;
-create or replace function sedona.ST_AsText (geometry BINARY)
-returns VARCHAR
+create or replace function sedona.ST_GeomFromGeoHash (geoHash VARCHAR, precision NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGeoHash'
;
-create or replace function sedona.ST_SetSRID (geometry BINARY, srid NUMBER)
+create or replace function sedona.ST_GeomFromGeoJSON (geoJson VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SetSRID'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGeoJSON'
;
-create or replace function sedona.ST_Split (input BINARY, blade BINARY)
+create or replace function sedona.ST_GeomFromKML (kml VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Split'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromKML'
;
-create or replace function sedona.ST_Touches (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_GeomFromText (wkt VARCHAR)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Touches'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromText'
;
-create or replace function sedona.ST_Union (leftGeom BINARY, rightGeom BINARY)
+create or replace function sedona.ST_GeomFromText (wkt VARCHAR, srid NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Union'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromText'
;
-create or replace function sedona.ST_Within (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_GeomFromWKB (wkb BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Within'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKB'
;
-create or replace function sedona.ST_X (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_GeomFromWKT (wkt VARCHAR)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_X'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKT'
;
-create or replace function sedona.ST_XMax (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_GeomFromWKT (wkt VARCHAR, srid NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_XMax'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKT'
;
-create or replace function sedona.ST_XMin (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_GeometryN (geometry BINARY, n NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_XMin'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometryN'
;
-create or replace function sedona.ST_Y (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_GeometryType (geometry BINARY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Y'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometryType'
;
-create or replace function sedona.ST_YMax (geometry BINARY)
+create or replace function sedona.ST_HausdorffDistance (geom1 BINARY, geom2 BINARY, densifyFrac DOUBLE)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_YMax'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_HausdorffDistance'
;
-create or replace function sedona.ST_YMin (geometry BINARY)
+create or replace function sedona.ST_HausdorffDistance (geom1 BINARY, geom2 BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_YMin'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_HausdorffDistance'
;
-create or replace function sedona.ST_Z (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_InteriorRingN (geometry BINARY, n NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Z'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_InteriorRingN'
;
-create or replace function sedona.ST_ZMax (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_Intersection (leftGeometry BINARY, rightGeometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ZMax'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Intersection'
;
-create or replace function sedona.ST_ZMin (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_Intersects (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ZMin'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Intersects'
;
-create or replace function sedona.ST_DWithin (geomA BINARY, geomB BINARY, distance DOUBLE)
+create or replace function sedona.ST_IsClosed (geometry BINARY)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DWithin'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsClosed'
;
-create or replace function sedona.ST_Force3D (geom BINARY, zValue DOUBLE)
-returns BINARY
+create or replace function sedona.ST_IsCollection (geometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force3D'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsCollection'
;
-create or replace function sedona.ST_Force3D (geom BINARY)
-returns BINARY
+create or replace function sedona.ST_IsPolygonCW (geometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force3D'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsPolygonCW'
;
-create or replace function sedona.ST_NRings (geom BINARY)
-returns NUMBER
+create or replace function sedona.ST_IsPolygonCCW (geometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NRings'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsPolygonCCW'
;
-create or replace function sedona.GeometryType (geometry BINARY)
-returns VARCHAR
+create or replace function sedona.ST_IsSimple (geometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.GeometryType'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsSimple'
;
-create or replace function sedona.ST_AddPoint (linestring BINARY, point BINARY, position NUMBER)
-returns BINARY
+create or replace function sedona.ST_IsValidReason (geometry BINARY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AddPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValidReason'
;
-create or replace function sedona.ST_AsBinary (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_IsValidReason (geometry BINARY, flags NUMBER)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsBinary'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValidReason'
;
-create or replace function sedona.ST_AsGeoJSON (geometry BINARY)
-returns VARCHAR
+create or replace function sedona.ST_LineFromMultiPoint (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsGeoJSON'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineFromMultiPoint'
;
-create or replace function sedona.ST_Boundary (geometry BINARY)
+create or replace function sedona.ST_LineFromText (geomString VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Boundary'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineFromText'
;
-create or replace function sedona.ST_BoundingDiagonal (geometry BINARY)
+create or replace function sedona.ST_LineInterpolatePoint (geom BINARY, fraction DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_BoundingDiagonal'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineInterpolatePoint'
;
-create or replace function sedona.ST_BuildArea (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_LineLocatePoint (geom BINARY, point BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_BuildArea'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineLocatePoint'
;
-create or replace function sedona.ST_Centroid (geometry BINARY)
+create or replace function sedona.ST_LineMerge (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Centroid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineMerge'
;
-create or replace function sedona.ST_ClosestPoint (geometry1 BINARY, geometry2 BINARY)
+create or replace function sedona.ST_LineStringFromText (geomString VARCHAR, delimiter VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ClosestPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineStringFromText'
;
-create or replace function sedona.ST_CollectionExtract (geometry BINARY, geomType NUMBER)
+create or replace function sedona.ST_LineSubstring (geom BINARY, fromFraction DOUBLE, toFraction DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CollectionExtract'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineSubstring'
;
-create or replace function sedona.ST_CollectionExtract (geometry BINARY)
+create or replace function sedona.ST_MakeLine (geometryCollection BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CollectionExtract'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeLine'
;
-create or replace function sedona.ST_ConcaveHull (geometry BINARY, pctConvex DOUBLE, allowHoles BOOLEAN)
+create or replace function sedona.ST_MakeLine (point1 BINARY, point2 BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConcaveHull'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeLine'
;
-create or replace function sedona.ST_ConcaveHull (geometry BINARY, pctConvex DOUBLE)
+create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE, m DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConcaveHull'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
;
-create or replace function sedona.ST_Contains (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Contains'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
;
-create or replace function sedona.ST_CoordDim (geometry BINARY)
-returns NUMBER
+create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CoordDim'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
;
-create or replace function sedona.ST_ConvexHull (geometry BINARY)
+create or replace function sedona.ST_MLineFromText (wkt VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ConvexHull'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MLineFromText'
;
-create or replace function sedona.ST_CoveredBy (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_MLineFromText (wkt VARCHAR, srid NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_CoveredBy'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MLineFromText'
;
-create or replace function sedona.ST_Difference (leftGeometry BINARY, rightGeometry BINARY)
+create or replace function sedona.ST_MPolyFromText (wkt VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Difference'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MPolyFromText'
;
-create or replace function sedona.ST_Dimension (geometry BINARY)
-returns NUMBER
+create or replace function sedona.ST_MPolyFromText (wkt VARCHAR, srid NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Dimension'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MPolyFromText'
;
-create or replace function sedona.ST_Disjoint (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_MakePolygon (shell BINARY, holes BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Disjoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePolygon'
;
-create or replace function sedona.ST_Distance (left BINARY, right BINARY)
-returns DOUBLE
+create or replace function sedona.ST_MakePolygon (shell BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Distance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePolygon'
;
-create or replace function sedona.ST_3DDistance (left BINARY, right BINARY)
-returns DOUBLE
+create or replace function sedona.ST_MakeValid (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_3DDistance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeValid'
;
-create or replace function sedona.ST_DumpPoints (geometry BINARY)
+create or replace function sedona.ST_MakeValid (geometry BINARY, keepCollapsed BOOLEAN)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DumpPoints'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeValid'
;
-create or replace function sedona.ST_EndPoint (geometry BINARY)
+create or replace function sedona.ST_MinimumBoundingCircle (geometry BINARY, quadrantSegments NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_EndPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MinimumBoundingCircle'
;
-create or replace function sedona.ST_Envelope (geometry BINARY)
+create or replace function sedona.ST_Normalize (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Envelope'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Normalize'
;
-create or replace function sedona.ST_ExteriorRing (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_NumGeometries (geometry BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ExteriorRing'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumGeometries'
;
-create or replace function sedona.ST_FlipCoordinates (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_NumInteriorRings (geometry BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_FlipCoordinates'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumInteriorRings'
;
-create or replace function sedona.ST_Force_2D (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_OrderingEquals (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force_2D'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_OrderingEquals'
;
-create or replace function sedona.ST_GeomFromGML (gml VARCHAR)
-returns BINARY
+create or replace function sedona.ST_Overlaps (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGML'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Overlaps'
;
-create or replace function sedona.ST_GeomFromGeoHash (geoHash VARCHAR, precision NUMBER)
+create or replace function sedona.ST_PointFromText (geomString VARCHAR, geomFormat VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGeoHash'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointFromText'
;
-create or replace function sedona.ST_GeomFromGeoJSON (geoJson VARCHAR)
+create or replace function sedona.ST_PointOnSurface (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromGeoJSON'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointOnSurface'
;
-create or replace function sedona.ST_GeomFromKML (kml VARCHAR)
+create or replace function sedona.ST_Polygonize (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromKML'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Polygonize'
;
-create or replace function sedona.ST_GeomFromText (wkt VARCHAR, srid NUMBER)
+create or replace function sedona.ST_PolygonFromEnvelope (minX DOUBLE, minY DOUBLE, maxX DOUBLE, maxY DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PolygonFromEnvelope'
;
-create or replace function sedona.ST_GeomFromText (wkt VARCHAR)
+create or replace function sedona.ST_PolygonFromText (geomString VARCHAR, delimiter VARCHAR)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PolygonFromText'
;
-create or replace function sedona.ST_GeomFromWKB (wkb BINARY)
+create or replace function sedona.ST_PrecisionReduce (geometry BINARY, precisionScale NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKB'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PrecisionReduce'
;
-create or replace function sedona.ST_GeomFromWKT (wkt VARCHAR)
+create or replace function sedona.ST_ReducePrecision (geometry BINARY, precisionScale NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKT'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ReducePrecision'
;
-create or replace function sedona.ST_GeomFromWKT (wkt VARCHAR, srid NUMBER)
+create or replace function sedona.ST_RemovePoint (linestring BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeomFromWKT'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_RemovePoint'
;
-create or replace function sedona.ST_GeometryN (geometry BINARY, n NUMBER)
+create or replace function sedona.ST_RemovePoint (linestring BINARY, position NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometryN'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_RemovePoint'
;
-create or replace function sedona.ST_GeometryType (geometry BINARY)
-returns VARCHAR
+create or replace function sedona.ST_S2CellIDs (input BINARY, level NUMBER)
+returns ARRAY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometryType'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_S2CellIDs'
;
-create or replace function sedona.ST_HausdorffDistance (geom1 BINARY, geom2 BINARY)
-returns DOUBLE
+create or replace function sedona.ST_SetPoint (linestring BINARY, position NUMBER, point BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_HausdorffDistance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SetPoint'
;
-create or replace function sedona.ST_HausdorffDistance (geom1 BINARY, geom2 BINARY, densifyFrac DOUBLE)
-returns DOUBLE
+create or replace function sedona.ST_StartPoint (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_HausdorffDistance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_StartPoint'
;
-create or replace function sedona.ST_InteriorRingN (geometry BINARY, n NUMBER)
+create or replace function sedona.ST_SubDivide (geometry BINARY, maxVertices NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_InteriorRingN'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SubDivide'
;
-create or replace function sedona.ST_Intersection (leftGeometry BINARY, rightGeometry BINARY)
+create or replace function sedona.ST_SymDifference (leftGeom BINARY, rightGeom BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Intersection'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SymDifference'
;
-create or replace function sedona.ST_Intersects (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_Transform (geometry BINARY, sourceCRS VARCHAR, targetCRS VARCHAR, lenient BOOLEAN)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Intersects'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Transform'
;
-create or replace function sedona.ST_IsClosed (geometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_Transform (geometry BINARY, sourceCRS VARCHAR, targetCRS VARCHAR)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsClosed'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Transform'
;
-create or replace function sedona.ST_IsCollection (geometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_VoronoiPolygons (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsCollection'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_IsSimple (geometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_VoronoiPolygons (geometry BINARY, tolerance DOUBLE, extent BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsSimple'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_IsValidReason (geometry BINARY)
-returns VARCHAR
+create or replace function sedona.ST_VoronoiPolygons (geometry BINARY, tolerance DOUBLE)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValidReason'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_IsValidReason (geometry BINARY, flags NUMBER)
-returns VARCHAR
+create or replace function sedona.ST_AreaSpheroid (geometry BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValidReason'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AreaSpheroid'
;
-create or replace function sedona.ST_LineFromMultiPoint (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_DistanceSphere (geomA BINARY, geomB BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineFromMultiPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSphere'
;
-create or replace function sedona.ST_LineFromText (geomString VARCHAR)
-returns BINARY
+create or replace function sedona.ST_DistanceSphere (geomA BINARY, geomB BINARY, radius DOUBLE)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSphere'
;
-create or replace function sedona.ST_LineInterpolatePoint (geom BINARY, fraction DOUBLE)
-returns BINARY
+create or replace function sedona.ST_DistanceSpheroid (geomA BINARY, geomB BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineInterpolatePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSpheroid'
;
-create or replace function sedona.ST_LineLocatePoint (geom BINARY, point BINARY)
+create or replace function sedona.ST_FrechetDistance (geomA BINARY, geomB BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineLocatePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_FrechetDistance'
;
-create or replace function sedona.ST_LineMerge (geometry BINARY)
+create or replace function sedona.ST_ForcePolygonCW (geom BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineMerge'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ForcePolygonCW'
;
-create or replace function sedona.ST_LineStringFromText (geomString VARCHAR, delimiter VARCHAR)
+create or replace function sedona.ST_ForcePolygonCCW (geom BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineStringFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ForcePolygonCCW'
;
-create or replace function sedona.ST_LineSubstring (geom BINARY, fromFraction DOUBLE, toFraction DOUBLE)
-returns BINARY
+create or replace function sedona.ST_LengthSpheroid (geom BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LineSubstring'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LengthSpheroid'
;
-create or replace function sedona.ST_MakeLine (geometryCollection BINARY)
+create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT, maxIter NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeLine'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
;
-create or replace function sedona.ST_MakeLine (point1 BINARY, point2 BINARY)
+create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT, maxIter NUMBER, failIfNotConverged BOOLEAN)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeLine'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
;
-create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE)
+create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
;
-create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE, z DOUBLE, m DOUBLE)
+create or replace function sedona.ST_GeometricMedian (geom BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
;
-create or replace function sedona.ST_MakePoint (x DOUBLE, y DOUBLE)
-returns BINARY
+create or replace function sedona.ST_NumPoints (geom BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumPoints'
;
-create or replace function sedona.ST_MLineFromText (wkt VARCHAR)
+create or replace function sedona.ST_Translate (geom BINARY, deltaX DOUBLE, deltaY DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MLineFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Translate'
;
-create or replace function sedona.ST_MLineFromText (wkt VARCHAR, srid NUMBER)
+create or replace function sedona.ST_Translate (geom BINARY, deltaX DOUBLE, deltaY DOUBLE, deltaZ DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MLineFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Translate'
;
-create or replace function sedona.ST_MPolyFromText (wkt VARCHAR)
+create or replace function sedona.ST_Affine (geometry BINARY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xOff DOUBLE, yOff DOUBLE, zOff DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MPolyFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Affine'
;
-create or replace function sedona.ST_MPolyFromText (wkt VARCHAR, srid NUMBER)
+create or replace function sedona.ST_Affine (geometry BINARY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MPolyFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Affine'
;
-create or replace function sedona.ST_MakePolygon (shell BINARY, holes BINARY)
-returns BINARY
+create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePolygon'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
;
-create or replace function sedona.ST_MakePolygon (shell BINARY)
-returns BINARY
+create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY, geom3 BINARY, geom4 BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakePolygon'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
;
-create or replace function sedona.ST_MakeValid (geometry BINARY, keepCollapsed BOOLEAN)
-returns BINARY
+create or replace function sedona.ST_Angle (geom1 BINARY, geom2 BINARY, geom3 BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeValid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Angle'
;
-create or replace function sedona.ST_MakeValid (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_Area (geometry BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MakeValid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Area'
;
-create or replace function sedona.ST_MinimumBoundingCircle (geometry BINARY, quadrantSegments NUMBER)
+create or replace function sedona.ST_AsEWKB (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_MinimumBoundingCircle'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsEWKB'
;
-create or replace function sedona.ST_Normalize (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_AsEWKT (geometry BINARY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Normalize'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsEWKT'
;
-create or replace function sedona.ST_NumGeometries (geometry BINARY)
-returns NUMBER
+create or replace function sedona.ST_AsGML (geometry BINARY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumGeometries'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsGML'
;
-create or replace function sedona.ST_NumInteriorRings (geometry BINARY)
-returns NUMBER
+create or replace function sedona.ST_AsKML (geometry BINARY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumInteriorRings'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsKML'
;
-create or replace function sedona.ST_OrderingEquals (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_Azimuth (left BINARY, right BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_OrderingEquals'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Azimuth'
;
-create or replace function sedona.ST_Overlaps (leftGeometry BINARY, rightGeometry BINARY)
-returns BOOLEAN
+create or replace function sedona.ST_Buffer (geometry BINARY, radius DOUBLE, useSpheroid BOOLEAN, parameters VARCHAR)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Overlaps'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Buffer'
;
-create or replace function sedona.ST_PointFromText (geomString VARCHAR, geomFormat VARCHAR)
+create or replace function sedona.ST_Buffer (geometry BINARY, radius DOUBLE, useSpheroid BOOLEAN)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Buffer'
;
-create or replace function sedona.ST_PointOnSurface (geometry BINARY)
+create or replace function sedona.ST_Buffer (geometry BINARY, radius DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointOnSurface'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Buffer'
;
-create or replace function sedona.ST_PolygonFromEnvelope (minX DOUBLE, minY DOUBLE, maxX DOUBLE, maxY DOUBLE)
-returns BINARY
+create or replace function sedona.ST_Covers (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PolygonFromEnvelope'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Covers'
;
-create or replace function sedona.ST_PolygonFromText (geomString VARCHAR, delimiter VARCHAR)
-returns BINARY
+create or replace function sedona.ST_Crosses (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PolygonFromText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Crosses'
;
-create or replace function sedona.ST_PrecisionReduce (geometry BINARY, precisionScale NUMBER)
-returns BINARY
+create or replace function sedona.ST_Degrees (angleInRadian DOUBLE)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PrecisionReduce'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Degrees'
;
-create or replace function sedona.ST_ReducePrecision (geometry BINARY, precisionScale NUMBER)
-returns BINARY
+create or replace function sedona.ST_Equals (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ReducePrecision'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Equals'
;
-create or replace function sedona.ST_RemovePoint (linestring BINARY)
+create or replace function sedona.ST_Force2D (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_RemovePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force2D'
;
-create or replace function sedona.ST_RemovePoint (linestring BINARY, position NUMBER)
-returns BINARY
+create or replace function sedona.ST_GeoHash (geometry BINARY, precision NUMBER)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_RemovePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeoHash'
;
-create or replace function sedona.ST_S2CellIDs (input BINARY, level NUMBER)
-returns ARRAY
+create or replace function sedona.ST_IsEmpty (geometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_S2CellIDs'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsEmpty'
;
-create or replace function sedona.ST_SetPoint (linestring BINARY, position NUMBER, point BINARY)
-returns BINARY
+create or replace function sedona.ST_IsRing (geometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SetPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsRing'
;
-create or replace function sedona.ST_StartPoint (geometry BINARY)
-returns BINARY
+create or replace function sedona.ST_IsValid (geometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_StartPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValid'
;
-create or replace function sedona.ST_SubDivide (geometry BINARY, maxVertices NUMBER)
-returns BINARY
+create or replace function sedona.ST_IsValid (geometry BINARY, flags NUMBER)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SubDivide'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_IsValid'
;
-create or replace function sedona.ST_SymDifference (leftGeom BINARY, rightGeom BINARY)
-returns BINARY
+create or replace function sedona.ST_Length (geometry BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SymDifference'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Length'
;
-create or replace function sedona.ST_Transform (geometry BINARY, sourceCRS VARCHAR, targetCRS VARCHAR, lenient BOOLEAN)
+create or replace function sedona.ST_Multi (geometry BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Transform'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Multi'
;
-create or replace function sedona.ST_Transform (geometry BINARY, sourceCRS VARCHAR, targetCRS VARCHAR)
-returns BINARY
+create or replace function sedona.ST_NDims (geometry BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Transform'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NDims'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry BINARY, tolerance DOUBLE)
-returns BINARY
+create or replace function sedona.ST_NPoints (geometry BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NPoints'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry BINARY)
+create or replace function sedona.ST_Point (x DOUBLE, y DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Point'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry BINARY, tolerance DOUBLE, extent BINARY)
+create or replace function sedona.ST_PointN (geometry BINARY, n NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_VoronoiPolygons'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointN'
;
-create or replace function sedona.ST_AreaSpheroid (geometry BINARY)
-returns DOUBLE
+create or replace function sedona.ST_PointZ (x DOUBLE, y DOUBLE, z DOUBLE)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AreaSpheroid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointZ'
;
-create or replace function sedona.ST_DistanceSphere (geomA BINARY, geomB BINARY)
-returns DOUBLE
+create or replace function sedona.ST_PointZ (x DOUBLE, y DOUBLE, z DOUBLE, srid NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSphere'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_PointZ'
;
-create or replace function sedona.ST_DistanceSphere (geomA BINARY, geomB BINARY, radius DOUBLE)
-returns DOUBLE
+create or replace function sedona.ST_Polygon (geometry BINARY, srid NUMBER)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSphere'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Polygon'
;
-create or replace function sedona.ST_DistanceSpheroid (geomA BINARY, geomB BINARY)
-returns DOUBLE
+create or replace function sedona.ST_Reverse (geometry BINARY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DistanceSpheroid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Reverse'
;
-create or replace function sedona.ST_FrechetDistance (geomA BINARY, geomB BINARY)
-returns DOUBLE
+create or replace function sedona.ST_SRID (geometry BINARY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_FrechetDistance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SRID'
;
-create or replace function sedona.ST_LengthSpheroid (geom BINARY)
-returns DOUBLE
+create or replace function sedona.ST_AsText (geometry BINARY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_LengthSpheroid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_AsText'
;
-create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT, maxIter NUMBER, failIfNotConverged BOOLEAN)
+create or replace function sedona.ST_SetSRID (geometry BINARY, srid NUMBER)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SetSRID'
;
-create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT)
+create or replace function sedona.ST_Split (input BINARY, blade BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Split'
;
-create or replace function sedona.ST_GeometricMedian (geom BINARY)
+create or replace function sedona.ST_Snap (input BINARY, reference BINARY, tolerance DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Snap'
;
-create or replace function sedona.ST_GeometricMedian (geom BINARY, tolerance FLOAT, maxIter NUMBER)
+create or replace function sedona.ST_Touches (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Touches'
+;
+create or replace function sedona.ST_Union (leftGeom BINARY, rightGeom BINARY)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_GeometricMedian'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Union'
;
-create or replace function sedona.ST_NumPoints (geom BINARY)
-returns NUMBER
+create or replace function sedona.ST_Within (leftGeometry BINARY, rightGeometry BINARY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NumPoints'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Within'
;
-create or replace function sedona.ST_Translate (geom BINARY, deltaX DOUBLE, deltaY DOUBLE)
-returns BINARY
+create or replace function sedona.ST_X (geometry BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Translate'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_X'
;
-create or replace function sedona.ST_Translate (geom BINARY, deltaX DOUBLE, deltaY DOUBLE, deltaZ DOUBLE)
-returns BINARY
+create or replace function sedona.ST_XMax (geometry BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Translate'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_XMax'
;
-create or replace function sedona.ST_SimplifyPreserveTopology (geometry BINARY, distanceTolerance DOUBLE)
-returns BINARY
+create or replace function sedona.ST_XMin (geometry BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_SimplifyPreserveTopology'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_XMin'
;
-create or replace function sedona.ST_Affine (geometry GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_Y (geometry BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Affine'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Y'
;
-create or replace function sedona.ST_Affine (geometry GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xOff DOUBLE, yOff DOUBLE, zOff DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_YMax (geometry BINARY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Affine'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_YMax'
;
-create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY, geom3 GEOMETRY)
+create or replace function sedona.ST_YMin (geometry BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_YMin'
;
-create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY)
+create or replace function sedona.ST_Z (geometry BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Z'
;
-create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY, geom3 GEOMETRY, geom4 GEOMETRY)
+create or replace function sedona.ST_ZMax (geometry BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ZMax'
;
-create or replace function sedona.ST_Area (geometry GEOMETRY)
+create or replace function sedona.ST_ZMin (geometry BINARY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Area'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_ZMin'
;
-create or replace function sedona.ST_AsEWKB (geometry GEOMETRY)
+create or replace function sedona.ST_DWithin (geomA BINARY, geomB BINARY, distance DOUBLE)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_DWithin'
+;
+create or replace function sedona.ST_Force3D (geom BINARY, zValue DOUBLE)
returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsEWKB'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force3D'
;
-create or replace function sedona.ST_AsEWKT (geometry GEOMETRY)
+create or replace function sedona.ST_Force3D (geom BINARY)
+returns BINARY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_Force3D'
+;
+create or replace function sedona.ST_NRings (geom BINARY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFs.ST_NRings'
+;
+create or replace function sedona.ST_SimplifyPreserveTopology (geometry GEOMETRY, distanceTolerance DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SimplifyPreserveTopology'
+;
+create or replace function sedona.GeometryType (geometry GEOMETRY)
returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsEWKT'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.GeometryType'
;
-create or replace function sedona.ST_AsGML (geometry GEOMETRY)
+create or replace function sedona.ST_AddPoint (linestring GEOMETRY, point GEOMETRY, position NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AddPoint'
+;
+create or replace function sedona.ST_AsBinary (geometry GEOMETRY)
+returns BINARY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsBinary'
+;
+create or replace function sedona.ST_AsGeoJSON (geometry GEOMETRY)
returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsGML'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsGeoJSON'
;
-create or replace function sedona.ST_AsKML (geometry GEOMETRY)
+create or replace function sedona.ST_Boundary (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Boundary'
+;
+create or replace function sedona.ST_BoundingDiagonal (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BoundingDiagonal'
+;
+create or replace function sedona.ST_BestSRID (geometry GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BestSRID'
+;
+create or replace function sedona.ST_ShiftLongitude (geometry GEOMETRY)
returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsKML'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ShiftLongitude'
;
-create or replace function sedona.ST_Azimuth (left GEOMETRY, right GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_BuildArea (geometry GEOMETRY)
+returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Azimuth'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BuildArea'
;
-create or replace function sedona.ST_Buffer (geometry GEOMETRY, radius DOUBLE)
+create or replace function sedona.ST_Centroid (geometry GEOMETRY)
returns GEOMETRY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Buffer'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Centroid'
;
-create or replace function sedona.ST_Covers (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+create or replace function sedona.ST_ClosestPoint (geometry1 GEOMETRY, geometry2 GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ClosestPoint'
+;
+create or replace function sedona.ST_CollectionExtract (geometry GEOMETRY, geomType NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CollectionExtract'
+;
+create or replace function sedona.ST_CollectionExtract (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CollectionExtract'
+;
+create or replace function sedona.ST_ConcaveHull (geometry GEOMETRY, pctConvex DOUBLE, allowHoles BOOLEAN)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConcaveHull'
+;
+create or replace function sedona.ST_ConcaveHull (geometry GEOMETRY, pctConvex DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConcaveHull'
+;
+create or replace function sedona.ST_Contains (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Covers'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Contains'
+;
+create or replace function sedona.ST_CoordDim (geometry GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CoordDim'
+;
+create or replace function sedona.ST_ConvexHull (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConvexHull'
+;
+create or replace function sedona.ST_CoveredBy (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CoveredBy'
+;
+create or replace function sedona.ST_CrossesDateLine (geometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CrossesDateLine'
+;
+create or replace function sedona.ST_Difference (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Difference'
+;
+create or replace function sedona.ST_Dimension (geometry GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Dimension'
+;
+create or replace function sedona.ST_Disjoint (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Disjoint'
+;
+create or replace function sedona.ST_Distance (left GEOMETRY, right GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Distance'
+;
+create or replace function sedona.ST_3DDistance (left GEOMETRY, right GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_3DDistance'
+;
+create or replace function sedona.ST_DumpPoints (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DumpPoints'
+;
+create or replace function sedona.ST_EndPoint (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_EndPoint'
+;
+create or replace function sedona.ST_Envelope (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Envelope'
+;
+create or replace function sedona.ST_ExteriorRing (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ExteriorRing'
+;
+create or replace function sedona.ST_FlipCoordinates (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_FlipCoordinates'
+;
+create or replace function sedona.ST_Force_2D (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force_2D'
+;
+create or replace function sedona.ST_GeometryN (geometry GEOMETRY, n NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometryN'
+;
+create or replace function sedona.ST_GeometryType (geometry GEOMETRY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometryType'
+;
+create or replace function sedona.ST_HausdorffDistance (geom1 GEOMETRY, geom2 GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_HausdorffDistance'
+;
+create or replace function sedona.ST_HausdorffDistance (geom1 GEOMETRY, geom2 GEOMETRY, densifyFrac DOUBLE)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_HausdorffDistance'
+;
+create or replace function sedona.ST_InteriorRingN (geometry GEOMETRY, n NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_InteriorRingN'
+;
+create or replace function sedona.ST_Intersection (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Intersection'
+;
+create or replace function sedona.ST_Intersects (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Intersects'
+;
+create or replace function sedona.ST_IsClosed (geometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsClosed'
+;
+create or replace function sedona.ST_IsCollection (geometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsCollection'
+;
+create or replace function sedona.ST_IsPolygonCW (geometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsPolygonCW'
+;
+create or replace function sedona.ST_IsPolygonCCW (geom GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsPolygonCCW'
+;
+create or replace function sedona.ST_IsSimple (geometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsSimple'
+;
+create or replace function sedona.ST_IsValidReason (geometry GEOMETRY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValidReason'
+;
+create or replace function sedona.ST_IsValidReason (geometry GEOMETRY, flags NUMBER)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValidReason'
+;
+create or replace function sedona.ST_LineFromMultiPoint (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineFromMultiPoint'
+;
+create or replace function sedona.ST_LineInterpolatePoint (geom GEOMETRY, fraction DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineInterpolatePoint'
+;
+create or replace function sedona.ST_LineLocatePoint (geom GEOMETRY, point GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineLocatePoint'
+;
+create or replace function sedona.ST_LineMerge (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineMerge'
+;
+create or replace function sedona.ST_LineSubstring (geom GEOMETRY, fromFraction DOUBLE, toFraction DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineSubstring'
+;
+create or replace function sedona.ST_MakeLine (geometryCollection GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeLine'
+;
+create or replace function sedona.ST_MakeLine (point1 GEOMETRY, point2 GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeLine'
+;
+create or replace function sedona.ST_MakePolygon (shell GEOMETRY, holes GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakePolygon'
+;
+create or replace function sedona.ST_MakePolygon (shell GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakePolygon'
+;
+create or replace function sedona.ST_MakeValid (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeValid'
+;
+create or replace function sedona.ST_MakeValid (geometry GEOMETRY, keepCollapsed BOOLEAN)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeValid'
+;
+create or replace function sedona.ST_MinimumBoundingCircle (geometry GEOMETRY, quadrantSegments NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MinimumBoundingCircle'
+;
+create or replace function sedona.ST_Normalize (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Normalize'
+;
+create or replace function sedona.ST_NumGeometries (geometry GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumGeometries'
+;
+create or replace function sedona.ST_NumInteriorRings (geometry GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumInteriorRings'
+;
+create or replace function sedona.ST_OrderingEquals (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_OrderingEquals'
+;
+create or replace function sedona.ST_Overlaps (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Overlaps'
+;
+create or replace function sedona.ST_PointOnSurface (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PointOnSurface'
+;
+create or replace function sedona.ST_Polygonize (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Polygonize'
+;
+create or replace function sedona.ST_PrecisionReduce (geometry GEOMETRY, precisionScale NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PrecisionReduce'
+;
+create or replace function sedona.ST_ReducePrecision (geometry GEOMETRY, precisionScale NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ReducePrecision'
+;
+create or replace function sedona.ST_RemovePoint (linestring GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_RemovePoint'
+;
+create or replace function sedona.ST_RemovePoint (linestring GEOMETRY, position NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_RemovePoint'
+;
+create or replace function sedona.ST_S2CellIDs (input GEOMETRY, level NUMBER)
+returns ARRAY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_S2CellIDs'
+;
+create or replace function sedona.ST_SetPoint (linestring GEOMETRY, position NUMBER, point GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SetPoint'
+;
+create or replace function sedona.ST_StartPoint (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_StartPoint'
+;
+create or replace function sedona.ST_SubDivide (geometry GEOMETRY, maxVertices NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SubDivide'
+;
+create or replace function sedona.ST_SymDifference (leftGeom GEOMETRY, rightGeom GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SymDifference'
+;
+create or replace function sedona.ST_Transform (geometry GEOMETRY, sourceCRS VARCHAR, targetCRS VARCHAR, lenient BOOLEAN)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Transform'
+;
+create or replace function sedona.ST_Transform (geometry GEOMETRY, sourceCRS VARCHAR, targetCRS VARCHAR)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Transform'
+;
+create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
+;
+create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY, tolerance DOUBLE, extent GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
+;
+create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY, tolerance DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
+;
+create or replace function sedona.ST_AreaSpheroid (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AreaSpheroid'
+;
+create or replace function sedona.ST_DistanceSphere (geomA GEOMETRY, geomB GEOMETRY, radius DOUBLE)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSphere'
+;
+create or replace function sedona.ST_DistanceSphere (geomA GEOMETRY, geomB GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSphere'
+;
+create or replace function sedona.ST_DistanceSpheroid (geomA GEOMETRY, geomB GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSpheroid'
+;
+create or replace function sedona.ST_FrechetDistance (geomA GEOMETRY, geomB GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_FrechetDistance'
+;
+create or replace function sedona.ST_ForcePolygonCW (geom GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ForcePolygonCW'
+;
+create or replace function sedona.ST_ForcePolygonCCW (geom GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ForcePolygonCCW'
+;
+create or replace function sedona.ST_LengthSpheroid (geom GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LengthSpheroid'
+;
+create or replace function sedona.ST_GeometricMedian (geom GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
+;
+create or replace function sedona.ST_GeometricMedian (geom GEOMETRY, tolerance FLOAT)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
+;
+create or replace function sedona.ST_GeometricMedian (geom GEOMETRY, tolerance FLOAT, maxIter NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
+;
+create or replace function sedona.ST_NumPoints (geom GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumPoints'
+;
+create or replace function sedona.ST_Translate (geom GEOMETRY, deltaX DOUBLE, deltaY DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Translate'
+;
+create or replace function sedona.ST_Translate (geom GEOMETRY, deltaX DOUBLE, deltaY DOUBLE, deltaZ DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Translate'
+;
+create or replace function sedona.ST_Affine (geometry GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Affine'
+;
+create or replace function sedona.ST_Affine (geometry GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xOff DOUBLE, yOff DOUBLE, zOff DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Affine'
+;
+create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY, geom3 GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
+;
+create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY, geom3 GEOMETRY, geom4 GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
+;
+create or replace function sedona.ST_Angle (geom1 GEOMETRY, geom2 GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
+;
+create or replace function sedona.ST_Area (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Area'
+;
+create or replace function sedona.ST_AsEWKB (geometry GEOMETRY)
+returns BINARY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsEWKB'
+;
+create or replace function sedona.ST_AsEWKT (geometry GEOMETRY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsEWKT'
+;
+create or replace function sedona.ST_AsGML (geometry GEOMETRY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsGML'
+;
+create or replace function sedona.ST_AsKML (geometry GEOMETRY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsKML'
+;
+create or replace function sedona.ST_Azimuth (left GEOMETRY, right GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Azimuth'
+;
+create or replace function sedona.ST_Buffer (geometry GEOMETRY, radius DOUBLE, useSpheroid BOOLEAN, parameters VARCHAR)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Buffer'
+;
+create or replace function sedona.ST_Buffer (geometry GEOMETRY, radius DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Buffer'
+;
+create or replace function sedona.ST_Buffer (geometry GEOMETRY, radius DOUBLE, useSpheroid BOOLEAN)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Buffer'
+;
+create or replace function sedona.ST_Covers (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Covers'
+;
+create or replace function sedona.ST_Crosses (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Crosses'
+;
+create or replace function sedona.ST_Equals (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Equals'
+;
+create or replace function sedona.ST_Force2D (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force2D'
+;
+create or replace function sedona.ST_GeoHash (geometry GEOMETRY, precision NUMBER)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeoHash'
+;
+create or replace function sedona.ST_IsEmpty (geometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsEmpty'
+;
+create or replace function sedona.ST_IsRing (geometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsRing'
+;
+create or replace function sedona.ST_IsValid (geometry GEOMETRY, flags NUMBER)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValid'
+;
+create or replace function sedona.ST_IsValid (geometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValid'
+;
+create or replace function sedona.ST_Length (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Length'
+;
+create or replace function sedona.ST_Multi (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Multi'
+;
+create or replace function sedona.ST_NDims (geometry GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NDims'
+;
+create or replace function sedona.ST_NPoints (geometry GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NPoints'
+;
+create or replace function sedona.ST_PointN (geometry GEOMETRY, n NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PointN'
+;
+create or replace function sedona.ST_Polygon (geometry GEOMETRY, srid NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Polygon'
+;
+create or replace function sedona.ST_Reverse (geometry GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Reverse'
+;
+create or replace function sedona.ST_SRID (geometry GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SRID'
+;
+create or replace function sedona.ST_AsText (geometry GEOMETRY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsText'
+;
+create or replace function sedona.ST_SetSRID (geometry GEOMETRY, srid NUMBER)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SetSRID'
+;
+create or replace function sedona.ST_Split (input GEOMETRY, blade GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Split'
+;
+create or replace function sedona.ST_Snap (input GEOMETRY, reference GEOMETRY, tolerance DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Snap'
+;
+create or replace function sedona.ST_Touches (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Touches'
+;
+create or replace function sedona.ST_Union (leftGeom GEOMETRY, rightGeom GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Union'
+;
+create or replace function sedona.ST_Within (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Within'
+;
+create or replace function sedona.ST_X (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_X'
+;
+create or replace function sedona.ST_XMax (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_XMax'
+;
+create or replace function sedona.ST_XMin (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_XMin'
+;
+create or replace function sedona.ST_Y (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Y'
+;
+create or replace function sedona.ST_YMax (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_YMax'
+;
+create or replace function sedona.ST_YMin (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_YMin'
+;
+create or replace function sedona.ST_Z (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Z'
+;
+create or replace function sedona.ST_ZMax (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ZMax'
+;
+create or replace function sedona.ST_ZMin (geometry GEOMETRY)
+returns DOUBLE
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ZMin'
+;
+create or replace function sedona.ST_DWithin (geomA GEOMETRY, geomB GEOMETRY, distance DOUBLE)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DWithin'
+;
+create or replace function sedona.ST_Force3D (geom GEOMETRY, zValue DOUBLE)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force3D'
+;
+create or replace function sedona.ST_Force3D (geom GEOMETRY)
+returns GEOMETRY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force3D'
+;
+create or replace function sedona.ST_NRings (geom GEOMETRY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NRings'
+;
+create or replace function sedona.ST_SimplifyPreserveTopology (geometry GEOGRAPHY, distanceTolerance DOUBLE)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SimplifyPreserveTopology'
+;
+create or replace function sedona.GeometryType (geometry GEOGRAPHY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.GeometryType'
+;
+create or replace function sedona.ST_AddPoint (linestring GEOGRAPHY, point GEOGRAPHY, position NUMBER)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AddPoint'
+;
+create or replace function sedona.ST_AsBinary (geometry GEOGRAPHY)
+returns BINARY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsBinary'
+;
+create or replace function sedona.ST_AsGeoJSON (geometry GEOGRAPHY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsGeoJSON'
+;
+create or replace function sedona.ST_Boundary (geometry GEOGRAPHY)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Boundary'
+;
+create or replace function sedona.ST_BoundingDiagonal (geometry GEOGRAPHY)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BoundingDiagonal'
+;
+create or replace function sedona.ST_BestSRID (geometry GEOGRAPHY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BestSRID'
+;
+create or replace function sedona.ST_ShiftLongitude (geometry GEOGRAPHY)
+returns VARCHAR
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ShiftLongitude'
+;
+create or replace function sedona.ST_BuildArea (geometry GEOGRAPHY)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BuildArea'
+;
+create or replace function sedona.ST_Centroid (geometry GEOGRAPHY)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Centroid'
+;
+create or replace function sedona.ST_ClosestPoint (geometry1 GEOGRAPHY, geometry2 GEOGRAPHY)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ClosestPoint'
+;
+create or replace function sedona.ST_CollectionExtract (geometry GEOGRAPHY, geomType NUMBER)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CollectionExtract'
+;
+create or replace function sedona.ST_CollectionExtract (geometry GEOGRAPHY)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CollectionExtract'
+;
+create or replace function sedona.ST_ConcaveHull (geometry GEOGRAPHY, pctConvex DOUBLE, allowHoles BOOLEAN)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConcaveHull'
+;
+create or replace function sedona.ST_ConcaveHull (geometry GEOGRAPHY, pctConvex DOUBLE)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConcaveHull'
+;
+create or replace function sedona.ST_Contains (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Contains'
+;
+create or replace function sedona.ST_CoordDim (geometry GEOGRAPHY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CoordDim'
+;
+create or replace function sedona.ST_ConvexHull (geometry GEOGRAPHY)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConvexHull'
+;
+create or replace function sedona.ST_CoveredBy (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CoveredBy'
+;
+create or replace function sedona.ST_CrossesDateLine (geometry GEOGRAPHY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CrossesDateLine'
+;
+create or replace function sedona.ST_Difference (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns GEOGRAPHY
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Difference'
+;
+create or replace function sedona.ST_Dimension (geometry GEOGRAPHY)
+returns NUMBER
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Dimension'
+;
+create or replace function sedona.ST_Disjoint (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
+language java
+RETURNS NULL ON NULL INPUT
+IMMUTABLE
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Disjoint'
;
-create or replace function sedona.ST_Crosses (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_Distance (left GEOGRAPHY, right GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Crosses'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Distance'
;
-create or replace function sedona.ST_Equals (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_3DDistance (left GEOGRAPHY, right GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Equals'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_3DDistance'
;
-create or replace function sedona.ST_Force2D (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_DumpPoints (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force2D'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DumpPoints'
;
-create or replace function sedona.ST_GeoHash (geometry GEOMETRY, precision NUMBER)
-returns VARCHAR
+create or replace function sedona.ST_EndPoint (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeoHash'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_EndPoint'
;
-create or replace function sedona.ST_IsEmpty (geometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_Envelope (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsEmpty'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Envelope'
;
-create or replace function sedona.ST_IsRing (geometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_ExteriorRing (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsRing'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ExteriorRing'
;
-create or replace function sedona.ST_IsValid (geometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_FlipCoordinates (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_FlipCoordinates'
;
-create or replace function sedona.ST_IsValid (geometry GEOMETRY, flags NUMBER)
-returns BOOLEAN
+create or replace function sedona.ST_Force_2D (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force_2D'
;
-create or replace function sedona.ST_Length (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_GeometryN (geometry GEOGRAPHY, n NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Length'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometryN'
;
-create or replace function sedona.ST_Multi (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_GeometryType (geometry GEOGRAPHY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Multi'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometryType'
;
-create or replace function sedona.ST_NDims (geometry GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_HausdorffDistance (geom1 GEOGRAPHY, geom2 GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NDims'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_HausdorffDistance'
;
-create or replace function sedona.ST_NPoints (geometry GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_HausdorffDistance (geom1 GEOGRAPHY, geom2 GEOGRAPHY, densifyFrac DOUBLE)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NPoints'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_HausdorffDistance'
;
-create or replace function sedona.ST_PointN (geometry GEOMETRY, n NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_InteriorRingN (geometry GEOGRAPHY, n NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PointN'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_InteriorRingN'
;
-create or replace function sedona.ST_Polygon (geometry GEOMETRY, srid NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_Intersection (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Polygon'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Intersection'
;
-create or replace function sedona.ST_Reverse (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Intersects (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Reverse'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Intersects'
;
-create or replace function sedona.ST_SRID (geometry GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_IsClosed (geometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SRID'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsClosed'
;
-create or replace function sedona.ST_AsText (geometry GEOMETRY)
-returns VARCHAR
+create or replace function sedona.ST_IsCollection (geometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsText'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsCollection'
;
-create or replace function sedona.ST_SetSRID (geometry GEOMETRY, srid NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_IsPolygonCW (geometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SetSRID'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsPolygonCW'
;
-create or replace function sedona.ST_Split (input GEOMETRY, blade GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_IsPolygonCCW (geom GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Split'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsPolygonCCW'
;
-create or replace function sedona.ST_Touches (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+create or replace function sedona.ST_IsSimple (geometry GEOGRAPHY)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Touches'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsSimple'
;
-create or replace function sedona.ST_Union (leftGeom GEOMETRY, rightGeom GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_IsValidReason (geometry GEOGRAPHY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Union'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValidReason'
;
-create or replace function sedona.ST_Within (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_IsValidReason (geometry GEOGRAPHY, flags NUMBER)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Within'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValidReason'
;
-create or replace function sedona.ST_X (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_LineFromMultiPoint (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_X'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineFromMultiPoint'
;
-create or replace function sedona.ST_XMax (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_LineInterpolatePoint (geom GEOGRAPHY, fraction DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_XMax'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineInterpolatePoint'
;
-create or replace function sedona.ST_XMin (geometry GEOMETRY)
+create or replace function sedona.ST_LineLocatePoint (geom GEOGRAPHY, point GEOGRAPHY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_XMin'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineLocatePoint'
;
-create or replace function sedona.ST_Y (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_LineMerge (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Y'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineMerge'
;
-create or replace function sedona.ST_YMax (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_LineSubstring (geom GEOGRAPHY, fromFraction DOUBLE, toFraction DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_YMax'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineSubstring'
;
-create or replace function sedona.ST_YMin (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_MakeLine (geometryCollection GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_YMin'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeLine'
;
-create or replace function sedona.ST_Z (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_MakeLine (point1 GEOGRAPHY, point2 GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Z'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeLine'
;
-create or replace function sedona.ST_ZMax (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_MakePolygon (shell GEOGRAPHY, holes GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ZMax'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakePolygon'
;
-create or replace function sedona.ST_ZMin (geometry GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_MakePolygon (shell GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ZMin'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakePolygon'
;
-create or replace function sedona.ST_DWithin (geomA GEOMETRY, geomB GEOMETRY, distance DOUBLE)
-returns BOOLEAN
+create or replace function sedona.ST_MakeValid (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DWithin'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeValid'
;
-create or replace function sedona.ST_Force3D (geom GEOMETRY, zValue DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_MakeValid (geometry GEOGRAPHY, keepCollapsed BOOLEAN)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force3D'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeValid'
;
-create or replace function sedona.ST_Force3D (geom GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_MinimumBoundingCircle (geometry GEOGRAPHY, quadrantSegments NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force3D'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MinimumBoundingCircle'
;
-create or replace function sedona.ST_NRings (geom GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_Normalize (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NRings'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Normalize'
;
-create or replace function sedona.GeometryType (geometry GEOMETRY)
-returns VARCHAR
+create or replace function sedona.ST_NumGeometries (geometry GEOGRAPHY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.GeometryType'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumGeometries'
;
-create or replace function sedona.ST_AddPoint (linestring GEOMETRY, point GEOMETRY, position NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_NumInteriorRings (geometry GEOGRAPHY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AddPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumInteriorRings'
;
-create or replace function sedona.ST_AsBinary (geometry GEOMETRY)
-returns BINARY
+create or replace function sedona.ST_OrderingEquals (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsBinary'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_OrderingEquals'
;
-create or replace function sedona.ST_AsGeoJSON (geometry GEOMETRY)
-returns VARCHAR
+create or replace function sedona.ST_Overlaps (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsGeoJSON'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Overlaps'
;
-create or replace function sedona.ST_Boundary (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_PointOnSurface (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Boundary'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PointOnSurface'
;
-create or replace function sedona.ST_BoundingDiagonal (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Polygonize (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BoundingDiagonal'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Polygonize'
;
-create or replace function sedona.ST_BuildArea (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_PrecisionReduce (geometry GEOGRAPHY, precisionScale NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_BuildArea'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PrecisionReduce'
;
-create or replace function sedona.ST_Centroid (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_ReducePrecision (geometry GEOGRAPHY, precisionScale NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Centroid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ReducePrecision'
;
-create or replace function sedona.ST_ClosestPoint (geometry1 GEOMETRY, geometry2 GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_RemovePoint (linestring GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ClosestPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_RemovePoint'
;
-create or replace function sedona.ST_CollectionExtract (geometry GEOMETRY, geomType NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_RemovePoint (linestring GEOGRAPHY, position NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CollectionExtract'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_RemovePoint'
;
-create or replace function sedona.ST_CollectionExtract (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_S2CellIDs (input GEOGRAPHY, level NUMBER)
+returns ARRAY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CollectionExtract'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_S2CellIDs'
;
-create or replace function sedona.ST_ConcaveHull (geometry GEOMETRY, pctConvex DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_SetPoint (linestring GEOGRAPHY, position NUMBER, point GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConcaveHull'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SetPoint'
;
-create or replace function sedona.ST_ConcaveHull (geometry GEOMETRY, pctConvex DOUBLE, allowHoles BOOLEAN)
-returns GEOMETRY
+create or replace function sedona.ST_StartPoint (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConcaveHull'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_StartPoint'
;
-create or replace function sedona.ST_Contains (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_SubDivide (geometry GEOGRAPHY, maxVertices NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Contains'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SubDivide'
;
-create or replace function sedona.ST_CoordDim (geometry GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_SymDifference (leftGeom GEOGRAPHY, rightGeom GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CoordDim'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SymDifference'
;
-create or replace function sedona.ST_ConvexHull (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Transform (geometry GEOGRAPHY, sourceCRS VARCHAR, targetCRS VARCHAR, lenient BOOLEAN)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ConvexHull'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Transform'
;
-create or replace function sedona.ST_CoveredBy (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_Transform (geometry GEOGRAPHY, sourceCRS VARCHAR, targetCRS VARCHAR)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_CoveredBy'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Transform'
;
-create or replace function sedona.ST_Difference (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_VoronoiPolygons (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Difference'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_Dimension (geometry GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_VoronoiPolygons (geometry GEOGRAPHY, tolerance DOUBLE, extent GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Dimension'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_Disjoint (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_VoronoiPolygons (geometry GEOGRAPHY, tolerance DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Disjoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
;
-create or replace function sedona.ST_Distance (left GEOMETRY, right GEOMETRY)
+create or replace function sedona.ST_AreaSpheroid (geometry GEOGRAPHY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Distance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AreaSpheroid'
;
-create or replace function sedona.ST_3DDistance (left GEOMETRY, right GEOMETRY)
+create or replace function sedona.ST_DistanceSphere (geomA GEOGRAPHY, geomB GEOGRAPHY, radius DOUBLE)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_3DDistance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSphere'
;
-create or replace function sedona.ST_DumpPoints (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_DistanceSphere (geomA GEOGRAPHY, geomB GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DumpPoints'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSphere'
;
-create or replace function sedona.ST_EndPoint (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_DistanceSpheroid (geomA GEOGRAPHY, geomB GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_EndPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSpheroid'
;
-create or replace function sedona.ST_Envelope (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_FrechetDistance (geomA GEOGRAPHY, geomB GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Envelope'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_FrechetDistance'
;
-create or replace function sedona.ST_ExteriorRing (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_ForcePolygonCW (geom GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ExteriorRing'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ForcePolygonCW'
;
-create or replace function sedona.ST_FlipCoordinates (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_ForcePolygonCCW (geom GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_FlipCoordinates'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ForcePolygonCCW'
;
-create or replace function sedona.ST_Force_2D (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_LengthSpheroid (geom GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force_2D'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LengthSpheroid'
;
-create or replace function sedona.ST_GeometryN (geometry GEOMETRY, n NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_GeometricMedian (geom GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometryN'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
;
-create or replace function sedona.ST_GeometryType (geometry GEOMETRY)
-returns VARCHAR
+create or replace function sedona.ST_GeometricMedian (geom GEOGRAPHY, tolerance FLOAT)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometryType'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
;
-create or replace function sedona.ST_HausdorffDistance (geom1 GEOMETRY, geom2 GEOMETRY, densifyFrac DOUBLE)
-returns DOUBLE
+create or replace function sedona.ST_GeometricMedian (geom GEOGRAPHY, tolerance FLOAT, maxIter NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_HausdorffDistance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
;
-create or replace function sedona.ST_HausdorffDistance (geom1 GEOMETRY, geom2 GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_NumPoints (geom GEOGRAPHY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_HausdorffDistance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumPoints'
;
-create or replace function sedona.ST_InteriorRingN (geometry GEOMETRY, n NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_Translate (geom GEOGRAPHY, deltaX DOUBLE, deltaY DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_InteriorRingN'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Translate'
;
-create or replace function sedona.ST_Intersection (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Translate (geom GEOGRAPHY, deltaX DOUBLE, deltaY DOUBLE, deltaZ DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Intersection'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Translate'
;
-create or replace function sedona.ST_Intersects (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_Affine (geometry GEOGRAPHY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Intersects'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Affine'
;
-create or replace function sedona.ST_IsClosed (geometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_Affine (geometry GEOGRAPHY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xOff DOUBLE, yOff DOUBLE, zOff DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsClosed'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Affine'
;
-create or replace function sedona.ST_IsCollection (geometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_Angle (geom1 GEOGRAPHY, geom2 GEOGRAPHY, geom3 GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsCollection'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
;
-create or replace function sedona.ST_IsSimple (geometry GEOMETRY)
-returns BOOLEAN
+create or replace function sedona.ST_Angle (geom1 GEOGRAPHY, geom2 GEOGRAPHY, geom3 GEOGRAPHY, geom4 GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsSimple'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
;
-create or replace function sedona.ST_IsValidReason (geometry GEOMETRY)
-returns VARCHAR
+create or replace function sedona.ST_Angle (geom1 GEOGRAPHY, geom2 GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValidReason'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Angle'
;
-create or replace function sedona.ST_IsValidReason (geometry GEOMETRY, flags NUMBER)
-returns VARCHAR
+create or replace function sedona.ST_Area (geometry GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValidReason'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Area'
;
-create or replace function sedona.ST_LineFromMultiPoint (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_AsEWKB (geometry GEOGRAPHY)
+returns BINARY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineFromMultiPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsEWKB'
;
-create or replace function sedona.ST_LineInterpolatePoint (geom GEOMETRY, fraction DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_AsEWKT (geometry GEOGRAPHY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineInterpolatePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsEWKT'
;
-create or replace function sedona.ST_LineLocatePoint (geom GEOMETRY, point GEOMETRY)
-returns DOUBLE
+create or replace function sedona.ST_AsGML (geometry GEOGRAPHY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineLocatePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsGML'
;
-create or replace function sedona.ST_LineMerge (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_AsKML (geometry GEOGRAPHY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineMerge'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsKML'
;
-create or replace function sedona.ST_LineSubstring (geom GEOMETRY, fromFraction DOUBLE, toFraction DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_Azimuth (left GEOGRAPHY, right GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LineSubstring'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Azimuth'
;
-create or replace function sedona.ST_MakeLine (geometryCollection GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Buffer (geometry GEOGRAPHY, radius DOUBLE, useSpheroid BOOLEAN, parameters VARCHAR)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeLine'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Buffer'
;
-create or replace function sedona.ST_MakeLine (point1 GEOMETRY, point2 GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Buffer (geometry GEOGRAPHY, radius DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeLine'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Buffer'
;
-create or replace function sedona.ST_MakePolygon (shell GEOMETRY, holes GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Buffer (geometry GEOGRAPHY, radius DOUBLE, useSpheroid BOOLEAN)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakePolygon'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Buffer'
;
-create or replace function sedona.ST_MakePolygon (shell GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Covers (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakePolygon'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Covers'
;
-create or replace function sedona.ST_MakeValid (geometry GEOMETRY, keepCollapsed BOOLEAN)
-returns GEOMETRY
+create or replace function sedona.ST_Crosses (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeValid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Crosses'
;
-create or replace function sedona.ST_MakeValid (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Equals (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MakeValid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Equals'
;
-create or replace function sedona.ST_MinimumBoundingCircle (geometry GEOMETRY, quadrantSegments NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_Force2D (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_MinimumBoundingCircle'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force2D'
;
-create or replace function sedona.ST_Normalize (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_GeoHash (geometry GEOGRAPHY, precision NUMBER)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Normalize'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeoHash'
;
-create or replace function sedona.ST_NumGeometries (geometry GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_IsEmpty (geometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumGeometries'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsEmpty'
;
-create or replace function sedona.ST_NumInteriorRings (geometry GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_IsRing (geometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumInteriorRings'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsRing'
;
-create or replace function sedona.ST_OrderingEquals (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+create or replace function sedona.ST_IsValid (geometry GEOGRAPHY, flags NUMBER)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_OrderingEquals'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValid'
;
-create or replace function sedona.ST_Overlaps (leftGeometry GEOMETRY, rightGeometry GEOMETRY)
+create or replace function sedona.ST_IsValid (geometry GEOGRAPHY)
returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Overlaps'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_IsValid'
;
-create or replace function sedona.ST_PointOnSurface (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Length (geometry GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PointOnSurface'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Length'
;
-create or replace function sedona.ST_PrecisionReduce (geometry GEOMETRY, precisionScale NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_Multi (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PrecisionReduce'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Multi'
;
-create or replace function sedona.ST_ReducePrecision (geometry GEOMETRY, precisionScale NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_NDims (geometry GEOGRAPHY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ReducePrecision'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NDims'
;
-create or replace function sedona.ST_RemovePoint (linestring GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_NPoints (geometry GEOGRAPHY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_RemovePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NPoints'
;
-create or replace function sedona.ST_RemovePoint (linestring GEOMETRY, position NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_PointN (geometry GEOGRAPHY, n NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_RemovePoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_PointN'
;
-create or replace function sedona.ST_S2CellIDs (input GEOMETRY, level NUMBER)
-returns ARRAY
+create or replace function sedona.ST_Polygon (geometry GEOGRAPHY, srid NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_S2CellIDs'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Polygon'
;
-create or replace function sedona.ST_SetPoint (linestring GEOMETRY, position NUMBER, point GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Reverse (geometry GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SetPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Reverse'
;
-create or replace function sedona.ST_StartPoint (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_SRID (geometry GEOGRAPHY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_StartPoint'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SRID'
;
-create or replace function sedona.ST_SubDivide (geometry GEOMETRY, maxVertices NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_AsText (geometry GEOGRAPHY)
+returns VARCHAR
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SubDivide'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AsText'
;
-create or replace function sedona.ST_SymDifference (leftGeom GEOMETRY, rightGeom GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_SetSRID (geometry GEOGRAPHY, srid NUMBER)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SymDifference'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SetSRID'
;
-create or replace function sedona.ST_Transform (geometry GEOMETRY, sourceCRS VARCHAR, targetCRS VARCHAR, lenient BOOLEAN)
-returns GEOMETRY
+create or replace function sedona.ST_Split (input GEOGRAPHY, blade GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Transform'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Split'
;
-create or replace function sedona.ST_Transform (geometry GEOMETRY, sourceCRS VARCHAR, targetCRS VARCHAR)
-returns GEOMETRY
+create or replace function sedona.ST_Snap (input GEOGRAPHY, reference GEOGRAPHY, tolerance DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Transform'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Snap'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY, tolerance DOUBLE, extent GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Touches (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Touches'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY, tolerance DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_Union (leftGeom GEOGRAPHY, rightGeom GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Union'
;
-create or replace function sedona.ST_VoronoiPolygons (geometry GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_Within (leftGeometry GEOGRAPHY, rightGeometry GEOGRAPHY)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_VoronoiPolygons'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Within'
;
-create or replace function sedona.ST_AreaSpheroid (geometry GEOMETRY)
+create or replace function sedona.ST_X (geometry GEOGRAPHY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_AreaSpheroid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_X'
;
-create or replace function sedona.ST_DistanceSphere (geomA GEOMETRY, geomB GEOMETRY, radius DOUBLE)
+create or replace function sedona.ST_XMax (geometry GEOGRAPHY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSphere'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_XMax'
;
-create or replace function sedona.ST_DistanceSphere (geomA GEOMETRY, geomB GEOMETRY)
+create or replace function sedona.ST_XMin (geometry GEOGRAPHY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSphere'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_XMin'
;
-create or replace function sedona.ST_DistanceSpheroid (geomA GEOMETRY, geomB GEOMETRY)
+create or replace function sedona.ST_Y (geometry GEOGRAPHY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DistanceSpheroid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Y'
;
-create or replace function sedona.ST_FrechetDistance (geomA GEOMETRY, geomB GEOMETRY)
+create or replace function sedona.ST_YMax (geometry GEOGRAPHY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_FrechetDistance'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_YMax'
;
-create or replace function sedona.ST_LengthSpheroid (geom GEOMETRY)
+create or replace function sedona.ST_YMin (geometry GEOGRAPHY)
returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_LengthSpheroid'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_YMin'
;
-create or replace function sedona.ST_GeometricMedian (geom GEOMETRY, tolerance FLOAT)
-returns GEOMETRY
+create or replace function sedona.ST_Z (geometry GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Z'
;
-create or replace function sedona.ST_GeometricMedian (geom GEOMETRY)
-returns GEOMETRY
+create or replace function sedona.ST_ZMax (geometry GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ZMax'
;
-create or replace function sedona.ST_GeometricMedian (geom GEOMETRY, tolerance FLOAT, maxIter NUMBER)
-returns GEOMETRY
+create or replace function sedona.ST_ZMin (geometry GEOGRAPHY)
+returns DOUBLE
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_GeometricMedian'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_ZMin'
;
-create or replace function sedona.ST_NumPoints (geom GEOMETRY)
-returns NUMBER
+create or replace function sedona.ST_DWithin (geomA GEOGRAPHY, geomB GEOGRAPHY, distance DOUBLE)
+returns BOOLEAN
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NumPoints'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_DWithin'
;
-create or replace function sedona.ST_Translate (geom GEOMETRY, deltaX DOUBLE, deltaY DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_Force3D (geom GEOGRAPHY, zValue DOUBLE)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Translate'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force3D'
;
-create or replace function sedona.ST_Translate (geom GEOMETRY, deltaX DOUBLE, deltaY DOUBLE, deltaZ DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_Force3D (geom GEOGRAPHY)
+returns GEOGRAPHY
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Translate'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_Force3D'
;
-create or replace function sedona.ST_SimplifyPreserveTopology (geometry GEOMETRY, distanceTolerance DOUBLE)
-returns GEOMETRY
+create or replace function sedona.ST_NRings (geom GEOGRAPHY)
+returns NUMBER
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
-handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_SimplifyPreserveTopology'
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
+handler = 'org.apache.sedona.snowflake.snowsql.UDFsV2.ST_NRings'
;
-- UDTFs --
create or replace function sedona.ST_MinimumBoundingRadius (geom BINARY)
@@ -2342,7 +3670,7 @@ returns table(center BINARY, radius DOUBLE)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_MinimumBoundingRadius'
;
create or replace function sedona.ST_InterSection_Aggr (geom BINARY)
@@ -2350,7 +3678,7 @@ returns table(intersected BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Intersection_Aggr'
;
create or replace function sedona.ST_SubDivideExplode (geom BINARY, maxVertices NUMBER)
@@ -2358,7 +3686,7 @@ returns table(geom BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_SubDivideExplode'
;
create or replace function sedona.ST_Envelope_Aggr (geom BINARY)
@@ -2366,7 +3694,7 @@ returns table(envelope BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Envelope_Aggr'
;
create or replace function sedona.ST_Union_Aggr (geom BINARY)
@@ -2374,7 +3702,7 @@ returns table(unioned BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Union_Aggr'
;
create or replace function sedona.ST_Collect (geom BINARY)
@@ -2382,7 +3710,7 @@ returns table(collection BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Collect'
;
create or replace function sedona.ST_Dump (geomCollection BINARY)
@@ -2390,6 +3718,6 @@ returns table(geom BINARY)
language java
RETURNS NULL ON NULL INPUT
IMMUTABLE
-imports = ('@ApacheSedona/sedona-snowflake-1.5.1.jar', '@ApacheSedona/geotools-wrapper-1.5.1-28.2.jar')
+imports = ('@ApacheSedona/sedona-snowflake-1.5.2.jar', '@ApacheSedona/geotools-wrapper-1.5.2-28.2.jar')
handler = 'org.apache.sedona.snowflake.snowsql.udtfs.ST_Dump'
;
diff --git a/docs/setup/release-notes.md b/docs/setup/release-notes.md
index ed9e5754e..45e8e2268 100644
--- a/docs/setup/release-notes.md
+++ b/docs/setup/release-notes.md
@@ -1,9 +1,116 @@
-!!!note
- Support of Spark 2.X and Scala 2.11 was removed in Sedona 1.3.0+ although some parts of the source code might still be compatible. Sedona 1.3.0+ releases binary for both Scala 2.12 and 2.13.
-
!!! note
Sedona Python currently only works with Shapely 1.x. If you use GeoPandas, please use <= GeoPandas `0.11.1`. GeoPandas > 0.11.1 will automatically install Shapely 2.0. If you use Shapely, please use <= `1.8.4`.
+## Sedona 1.5.2
+
+Sedona 1.5.2 is compiled against Spark 3.3 / Spark 3.4 / Spark 3.5, Flink 1.12, Snowflake 7+, Java 8.
+
+This release is a maintenance release that includes bug fixes and minor improvements. No new features or major changes are added in this release.
+
+### Bug
+
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-470'>SEDONA-470</a>] - Cannot distinguish between missing or null crs from the result of geoparquet.metadata
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-471'>SEDONA-471</a>] - SedonaKepler cannot work with Uber H3 hex since 1.5.1
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-472'>SEDONA-472</a>] - Adapter API no longer works with unshaded jar
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-473'>SEDONA-473</a>] - cdm-core mistakenly becomes a compile dependency for sedona-spark-shaded
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-477'>SEDONA-477</a>] - Avoid producing rasters with images having non-zero origins
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-494'>SEDONA-494</a>] - Raster data source cannot write to HDFS
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-495'>SEDONA-495</a>] - Raster data source uses shared FileSystem connections which lead to race condition
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-497'>SEDONA-497</a>] - SpatialRDD read from multiple Shapefiles has incorrect fieldName property
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-500'>SEDONA-500</a>] - Cannot correctly read data from directories containing multiple shapefiles
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-501'>SEDONA-501</a>] - ST_Split maps to wrong Java-call
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-505'>SEDONA-505</a>] - Treat geometry with SRID=0 as if it was in EPSG:4326 in various raster functions
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-507'>SEDONA-507</a>] - RS_AsImage cannot visualize rasters with non-integral band data
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-510'>SEDONA-510</a>] - geometry columns with snake_case names in GeoParquet files cannot be recognized as geometry column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-511'>SEDONA-511</a>] - geometry columns with snake_case names in GeoParquet files cannot be recognized as geometry column
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-519'>SEDONA-519</a>] - ST_SubDivide (Snowflake) fails even on documentation example
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-520'>SEDONA-520</a>] - Missing dependencies in Snowflake JAR
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-531'>SEDONA-531</a>] - RDD spatial join in Python throws Not available error
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-534'>SEDONA-534</a>] - Disable Python warning message of finding jars
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-545'>SEDONA-545</a>] - Sedona Python DataFrame API fail due to missing commas
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-548'>SEDONA-548</a>] - Fix Python Dataframe API Constructor registrations
+</li>
+</ul>
+
+### Improvement
+
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-474'>SEDONA-474</a>] - Remove manipulation of warnings config
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-506'>SEDONA-506</a>] - Add lenient mode for RS_ZonalStats and RS_ZonalStatsAll
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-512'>SEDONA-512</a>] - Python serializer should report the object type in the error message
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-515'>SEDONA-515</a>] - Add handling for noDataValues in RS_Resample
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-529'>SEDONA-529</a>] - Add basic `EditorConfig` file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-535'>SEDONA-535</a>] - Add the pull request labeler
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-536'>SEDONA-536</a>] - Add CODEOWNERS file
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-541'>SEDONA-541</a>] - Allow concurrent snowflake testers
+</li>
+</ul>
+
+### Test
+
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-513'>SEDONA-513</a>] - Add pre-commit hook `mixed-line-ending`
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-523'>SEDONA-523</a>] - Add pre-commit hook `fix-byte-order-marker`
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-524'>SEDONA-524</a>] - Clean up the `pre-commit` config
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-525'>SEDONA-525</a>] - Add two more pre-commit hooks
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-528'>SEDONA-528</a>] - Add `pre-commit` hook `check-yaml`
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-530'>SEDONA-530</a>] - Add `pre-commit` hook `debug-statements`
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-537'>SEDONA-537</a>] - Add pre-commit hook `requirements-txt-fixer`
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-538'>SEDONA-538</a>] - Add four more pre-commit hooks
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-542'>SEDONA-542</a>] - Add `pre-commit` hook `check-executables-have-shebangs`
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-544'>SEDONA-544</a>] - Add `ruff-pre-commit` for `Python` linting
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-546'>SEDONA-546</a>] - Python linting enable rule `E712`
+</li>
+</ul>
+
+<h2> Task
+</h2>
+<ul>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-469'>SEDONA-469</a>] - Update Sedona docker and binder to use 1.5.1
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-496'>SEDONA-496</a>] - Dependabot: reduce the open pull requests limit to 2
+</li>
+<li>[<a href='https://issues.apache.org/jira/browse/SEDONA-526'>SEDONA-526</a>] - Upgrade `actions/setup-java` to `v4`
+</li>
+</ul>
+
## Sedona 1.5.1
Sedona 1.5.1 is compiled against Spark 3.3 / Spark 3.4 / Spark 3.5, Flink 1.12, Snowflake 7+, Java 8.
@@ -679,6 +786,9 @@ This version is a minor release on Sedoma 1.3.0 line. It fixes a few critical bu
* [SEDONA-194](https://issues.apache.org/jira/browse/SEDONA-194) - Merge org.datasyslab.sernetcdf into Sedona
* [SEDONA-208](https://issues.apache.org/jira/browse/SEDONA-208) - Use Spark RuntimeConfig in SedonaConf
+!!!note
+ Support of Spark 2.X and Scala 2.11 was removed in Sedona 1.3.0+ although some parts of the source code might still be compatible. Sedona 1.3.0+ releases binary for both Scala 2.12 and 2.13.
+
## Sedona 1.3.0
This version is a major release on Sedona 1.3.0 line and consists of 50 PRs. It includes many new functions, optimization and bug fixes.
diff --git a/docs/usecases/Sedona_OvertureMaps_GeoParquet.ipynb b/docs/usecases/Sedona_OvertureMaps_GeoParquet.ipynb
index 33e655c17..f99c4862d 100644
--- a/docs/usecases/Sedona_OvertureMaps_GeoParquet.ipynb
+++ b/docs/usecases/Sedona_OvertureMaps_GeoParquet.ipynb
@@ -1,5 +1,28 @@
{
"cells": [
+ {
+ "cell_type": "markdown",
+ "id": "7f06f00b",
+ "metadata": {},
+ "source": [
+ "```\n",
+ "Licensed to the Apache Software Foundation (ASF) under one\n",
+ "or more contributor license agreements. See the NOTICE file\n",
+ "distributed with this work for additional information\n",
+ "regarding copyright ownership. The ASF licenses this file\n",
+ "to you under the Apache License, Version 2.0 (the\n",
+ "\"License\"); you may not use this file except in compliance\n",
+ "with the License. You may obtain a copy of the License at\n",
+ " http://www.apache.org/licenses/LICENSE-2.0\n",
+ "Unless required by applicable law or agreed to in writing,\n",
+ "software distributed under the License is distributed on an\n",
+ "\"AS IS\" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY\n",
+ "KIND, either express or implied. See the License for the\n",
+ "specific language governing permissions and limitations\n",
+ "under the License.\n",
+ "```"
+ ]
+ },
{
"cell_type": "markdown",
"id": "66a56fcb-27a5-4b37-a913-05a8f887d22f",
diff --git a/mkdocs.yml b/mkdocs.yml
index a1c90cbf9..ddb2fd9ea 100644
--- a/mkdocs.yml
+++ b/mkdocs.yml
@@ -161,10 +161,10 @@ extra:
current_version: 1.5.1
current_geotools: 1.5.1-28.2
sedona_create_release:
- current_version: 1.5.1
- current_git_tag: sedona-1.5.1-rc1
- current_rc: 1.5.1-rc1
- current_snapshot: 1.5.1-SNAPSHOT
+ current_version: 1.5.2
+ current_git_tag: sedona-1.5.2-rc1
+ current_rc: 1.5.2-rc1
+ current_snapshot: 1.5.2-SNAPSHOT
next_version: 1.6.0
copyright: Copyright © 2024 The Apache Software Foundation. Apache Sedona, Sedona, Apache, the Apache feather logo, and the Apache Sedona project logo are either registered trademarks or trademarks of The Apache Software Foundation in the United States and other countries. All other marks mentioned may be trademarks or registered trademarks of their respective owners. Please visit <a href="http://www.apache.org/">Apache Software Foundation</a> for more details.<img referrerpolicy="no-ref [...]