> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sdf.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Geospatial Functions

## `h3_cell_to_boundary`

Returns a polygon containing the h3 integer cell boundaries
*Supported Signatures*

```sql theme={null}
function h3_cell_to_boundary(decimal(38, 0)) returns geography
function h3_cell_to_boundary(varchar) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_boundary)

## `h3_cell_to_children`

Returns the H3 children cells as integers for a given H3 index
*Supported Signatures*

```sql theme={null}
function h3_cell_to_children(decimal(38, 0), decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_children)

## `h3_cell_to_children_string`

Returns the H3 children cells as strings for a given H3 index
*Supported Signatures*

```sql theme={null}
function h3_cell_to_children_string(varchar, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_children_string)

## `h3_cell_to_parent`

Returns the H3 parent cell as an integer for a given H3 index
*Supported Signatures*

```sql theme={null}
function h3_cell_to_parent(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function h3_cell_to_parent(varchar, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_parent)

## `h3_cell_to_point`

Returns a point (geography) corresponding to the center of the h3 integer cell passed
*Supported Signatures*

```sql theme={null}
function h3_cell_to_point(decimal(38, 0)) returns geography
function h3_cell_to_point(varchar) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_cell_to_point)

## `h3_coverage`

Returns the full spherical based covering of H3 cells as integers for any geography type
*Supported Signatures*

```sql theme={null}
function h3_coverage(geography, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_coverage)

## `h3_coverage_strings`

Returns the full spherical based covering of H3 cells as strings for any geography type
*Supported Signatures*

```sql theme={null}
function h3_coverage_strings(geography, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_coverage_strings)

## `h3_get_resolution`

Returns the cell resolution for a given H3 integer cell
*Supported Signatures*

```sql theme={null}
function h3_get_resolution(decimal(38, 0)) returns decimal(38, 0)
function h3_get_resolution(varchar) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_get_resolution)

## `h3_grid_disk`

Returns all H3 cells that are at most k steps away from the input cell
*Supported Signatures*

```sql theme={null}
function h3_grid_disk(decimal(38, 0), decimal(38, 0)) returns array
function h3_grid_disk(varchar, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_grid_disk)

## `h3_grid_distance`

Returns the number of H3 cells that are betweem two input cells
*Supported Signatures*

```sql theme={null}
function h3_grid_distance(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function h3_grid_distance(varchar, varchar) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_grid_distance)

## `h3_grid_path`

Returns all H3 cells that are along the straight line connecting both cells
*Supported Signatures*

```sql theme={null}
function h3_grid_path(decimal(38, 0), decimal(38, 0)) returns array
function h3_grid_path(varchar, varchar) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_grid_path)

## `h3_int_to_string`

Returns the H3 cell formatted as a string given its integer representation
*Supported Signatures*

```sql theme={null}
function h3_int_to_string(decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_int_to_string)

## `h3_latlng_to_cell`

Returns an H3 index as an integer that corresponds to a given point (lat/lng) and resolution
*Supported Signatures*

```sql theme={null}
function h3_latlng_to_cell(double, double, decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_latlng_to_cell)

## `h3_latlng_to_cell_string`

Returns an H3 index as a string that corresponds to a given point (lat/lng) and resolution
*Supported Signatures*

```sql theme={null}
function h3_latlng_to_cell_string(double, double, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_latlng_to_cell_string)

## `h3_point_to_cell`

Returns an H3 integer cell that corresponds to a given point (geography) and resolution
*Supported Signatures*

```sql theme={null}
function h3_point_to_cell(geography, decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_point_to_cell)

## `h3_point_to_cell_string`

Returns an H3 string cell that corresponds to a given point (geography) and resolution
*Supported Signatures*

```sql theme={null}
function h3_point_to_cell_string(geography, decimal(38, 0)) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_point_to_cell_string)

## `h3_polygon_to_cells`

Returns the planar centroid based covering of H3 cells as integers for a polygon/multipolygon
*Supported Signatures*

```sql theme={null}
function h3_polygon_to_cells(geography, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_polygon_to_cells)

## `h3_polygon_to_cells_strings`

Returns the planar centroid based covering of H3 cells as strings for a polygon/multipolygon
*Supported Signatures*

```sql theme={null}
function h3_polygon_to_cells_strings(geography, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_polygon_to_cells_strings)

## `h3_string_to_int`

Returns the H3 cell formatted as an integer given its string representation
*Supported Signatures*

```sql theme={null}
function h3_string_to_int(varchar) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/h3_string_to_int)

## `haversine`

Calculate great circle distance (in km) from two (lat, lon) locations (degrees).
*Supported Signatures*

```sql theme={null}
function haversine(double, double, double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/haversine)

## `st_area`

Area of the object in square meters
*Supported Signatures*

```sql theme={null}
function st_area(geography) returns double
function st_area(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_area)

## `st_asbinary`

Return the WKB representation of the GEOGRAPHY object
*Supported Signatures*

```sql theme={null}
function st_asbinary(geography) returns binary
function st_asbinary(geometry) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_asbinary)

## `st_asewkb`

Return the EWKB representation of the GEOGRAPHY object
*Supported Signatures*

```sql theme={null}
function st_asewkb(geography) returns binary
function st_asewkb(geometry) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_asewkb)

## `st_asewkt`

Return the WKB representation of the GEOGRAPHY object
*Supported Signatures*

```sql theme={null}
function st_asewkt(geography) returns varchar
function st_asewkt(geometry) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_asewkt)

## `st_asgeojson`

Return the GeoJSON representation of the GEOGRAPHY object
*Supported Signatures*

```sql theme={null}
function st_asgeojson(geography) returns object
function st_asgeojson(geometry) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_asgeojson)

## `st_astext`

Return the WKT representation of the GEOGRAPHY object
*Supported Signatures*

```sql theme={null}
function st_astext(geography) returns varchar
function st_astext(geometry) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_astext)

## `st_aswkb`

Return the WKB representation of the GEOGRAPHY object
*Supported Signatures*

```sql theme={null}
function st_aswkb(geography) returns binary
function st_aswkb(geometry) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_aswkb)

## `st_aswkt`

Return the WKB representation of the GEOGRAPHY object
*Supported Signatures*

```sql theme={null}
function st_aswkt(geography) returns varchar
function st_aswkt(geometry) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_aswkt)

## `st_azimuth`

Returns the azimuth in radians of the segment defined by the given point
*Supported Signatures*

```sql theme={null}
function st_azimuth(geography, geography) returns double
function st_azimuth(geometry, geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_azimuth)

## `st_buffer`

Returns the geometry generated by the buffer operation upon the given input geometry using the diven distance
*Supported Signatures*

```sql theme={null}
function st_buffer(geometry, double) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_buffer)

## `st_centroid`

The centroid of geography
*Supported Signatures*

```sql theme={null}
function st_centroid(geography) returns geography
function st_centroid(geometry) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_centroid)

## `st_collect`

Aggregates all geographies into a GeometryCollection or Multi\* geography if they are all of the same single element type (e.g. Point)
*Supported Signatures*

```sql theme={null}
function st_collect(geography) returns geography
function st_collect(geography, geography) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_collect)

## `st_contains`

True if the first object fully contains the second
*Supported Signatures*

```sql theme={null}
function st_contains(geography, geography) returns boolean
function st_contains(geometry, geometry) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_contains)

## `st_coveredby`

True if the second object covers the first
*Supported Signatures*

```sql theme={null}
function st_coveredby(geography, geography) returns boolean
function st_coveredby(geometry, geometry) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_coveredby)

## `st_covers`

True if the first object covers the second
*Supported Signatures*

```sql theme={null}
function st_covers(geography, geography) returns boolean
function st_covers(geometry, geometry) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_covers)

## `st_difference`

Geometry representing the set difference a minus b
*Supported Signatures*

```sql theme={null}
function st_difference(geography, geography) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_difference)

## `st_dimension`

The dimension of the input geography
*Supported Signatures*

```sql theme={null}
function st_dimension(geography) returns decimal(38, 0)
function st_dimension(geometry) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_dimension)

## `st_disjoint`

True if the two objects not intersect
*Supported Signatures*

```sql theme={null}
function st_disjoint(geography, geography) returns boolean
function st_disjoint(geometry, geometry) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_disjoint)

## `st_distance`

Distance between two geography objects in meters
*Supported Signatures*

```sql theme={null}
function st_distance(geography, geography) returns double
function st_distance(geometry, geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_distance)

## `st_dwithin`

True if the minimum distance between two objects is smaller than or equal to the specified distance in meters
*Supported Signatures*

```sql theme={null}
function st_dwithin(geography, geography, double) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_dwithin)

## `st_endpoint`

The last point in the geography, only supports LineStrings
*Supported Signatures*

```sql theme={null}
function st_endpoint(geography) returns geography
function st_endpoint(geometry) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_endpoint)

## `st_envelope`

the double-precision (float8) minimum bounding box for the supplied geometry
*Supported Signatures*

```sql theme={null}
function st_envelope(geography) returns geography
function st_envelope(geometry) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_envelope)

## `st_geogfromgeohash`

The geography represented by the geohash
*Supported Signatures*

```sql theme={null}
function st_geogfromgeohash(varchar, decimal(38, 0)) returns geography
function st_geogfromgeohash(varchar) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_geogfromgeohash)

## `st_geogpointfromgeohash`

The point represented by the geohash
*Supported Signatures*

```sql theme={null}
function st_geogpointfromgeohash(varchar) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_geogpointfromgeohash)

## `st_geographyfromwkb`

Parse WKB or EWKB
*Supported Signatures*

```sql theme={null}
function st_geographyfromwkb(varchar) returns geography
function st_geographyfromwkb(varchar, boolean) returns geography
function st_geographyfromwkb(binary) returns geography
function st_geographyfromwkb(binary, boolean) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_geographyfromwkb)

## `st_geographyfromwkt`

Alias of ST\_GEOGRAPHYFROMTEXT
*Supported Signatures*

```sql theme={null}
function st_geographyfromwkt(varchar) returns geography
function st_geographyfromwkt(varchar, boolean) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_geographyfromwkt)

## `st_geohash`

The geohash of a geography
*Supported Signatures*

```sql theme={null}
function st_geohash(geography, decimal(38, 0)) returns varchar
function st_geohash(geography) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_geohash)

## `st_geometryfromwkb`

Parse WKB or EWKB from binary
*Supported Signatures*

```sql theme={null}
function st_geometryfromwkb(binary, decimal(38, 0)) returns geometry
function st_geometryfromwkb(binary) returns geometry
function st_geometryfromwkb(varchar, decimal(38, 0)) returns geometry
function st_geometryfromwkb(varchar) returns geometry
function st_geometryfromwkb(binary, decimal(38, 0), boolean, boolean) returns geometry
function st_geometryfromwkb(binary, boolean, boolean) returns geometry
function st_geometryfromwkb(varchar, decimal(38, 0), boolean, boolean) returns geometry
function st_geometryfromwkb(varchar, boolean, boolean) returns geometry
function st_geometryfromwkb(varchar, decimal(38, 0), boolean) returns geometry
function st_geometryfromwkb(varchar, boolean) returns geometry
function st_geometryfromwkb(binary, decimal(38, 0), boolean) returns geometry
function st_geometryfromwkb(binary, boolean) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_geometryfromwkb)

## `st_geometryfromwkt`

Alias of ST\_GEOMETRYFROMTEXT
*Supported Signatures*

```sql theme={null}
function st_geometryfromwkt(varchar) returns geometry
function st_geometryfromwkt(varchar, decimal(38, 0)) returns geometry
function st_geometryfromwkt(varchar, decimal(38, 0), boolean) returns geometry
function st_geometryfromwkt(varchar, boolean) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_geometryfromwkt)

## `st_hausdorffdistance`

the Hausdorff distance between two geometries
*Supported Signatures*

```sql theme={null}
function st_hausdorffdistance(geography, geography) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_hausdorffdistance)

## `st_intersection`

Geometry representing the intersection of a and b
*Supported Signatures*

```sql theme={null}
function st_intersection(geography, geography) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_intersection)

## `st_intersects`

True if the two objects intersect
*Supported Signatures*

```sql theme={null}
function st_intersects(geography, geography) returns boolean
function st_intersects(geometry, geometry) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_intersects)

## `st_isvalid`

True if g has an internal representation
*Supported Signatures*

```sql theme={null}
function st_isvalid(geography) returns boolean
function st_isvalid(geometry) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_isvalid)

## `st_length`

Length or perimeter of the object in meters
*Supported Signatures*

```sql theme={null}
function st_length(geography) returns double
function st_length(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_length)

## `st_makegeompoint`

Creates a point with the given x and y
*Supported Signatures*

```sql theme={null}
function st_makegeompoint(double, double) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_makegeompoint)

## `st_makeline`

Create a Line out of the points in the input geographies
*Supported Signatures*

```sql theme={null}
function st_makeline(geography, geography) returns geography
function st_makeline(geometry, geometry) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_makeline)

## `st_makepoint`

Creates a point with the given longitude and latitude
*Supported Signatures*

```sql theme={null}
function st_makepoint(double, double) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_makepoint)

## `st_makepolygon`

The Polygon consisting of the LineString as outer shell
*Supported Signatures*

```sql theme={null}
function st_makepolygon(geography) returns geography
function st_makepolygon(geometry) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_makepolygon)

## `st_makepolygonoriented`

The Polygon consisting of the LineString as outer shell, with unmodified orientation
*Supported Signatures*

```sql theme={null}
function st_makepolygonoriented(geography) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_makepolygonoriented)

## `st_npoints`

The number of points in the object's definition
*Supported Signatures*

```sql theme={null}
function st_npoints(geography) returns decimal(38, 0)
function st_npoints(geometry) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_npoints)

## `st_numpoints`

Alias for ST\_NPOINTS
*Supported Signatures*

```sql theme={null}
function st_numpoints(geography) returns decimal(38, 0)
function st_numpoints(geometry) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_numpoints)

## `st_perimeter`

Perimeter of the object in meters
*Supported Signatures*

```sql theme={null}
function st_perimeter(geography) returns double
function st_perimeter(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_perimeter)

## `st_point`

Creates a point with the given longitude and latitude
*Supported Signatures*

```sql theme={null}
function st_point(double, double) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_point)

## `st_pointn`

The nth point in the geography, only supports LineStrings
*Supported Signatures*

```sql theme={null}
function st_pointn(geography, decimal(38, 0)) returns geography
function st_pointn(geometry, decimal(38, 0)) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_pointn)

## `st_polygon`

Alias for ST\_MAKEPOLYGON
*Supported Signatures*

```sql theme={null}
function st_polygon(geography) returns geography
function st_polygon(geometry) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_polygon)

## `st_setsrid`

Returns a geometry same as input geometry but with SRID set to the given value
*Supported Signatures*

```sql theme={null}
function st_setsrid(geometry, decimal(38, 0)) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_setsrid)

## `st_simplify`

Simplified version of the given geometry
*Supported Signatures*

```sql theme={null}
function st_simplify(geography, double, boolean) returns geography
function st_simplify(geography, double) returns geography
function st_simplify(geometry, double) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_simplify)

## `st_srid`

Returns the SRID of a geography if present. Otherwise 4326
*Supported Signatures*

```sql theme={null}
function st_srid(geography) returns decimal(38, 0)
function st_srid(geometry) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_srid)

## `st_startpoint`

The first point in the geography, only supports LineStrings
*Supported Signatures*

```sql theme={null}
function st_startpoint(geography) returns geography
function st_startpoint(geometry) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_startpoint)

## `st_symdifference`

Geometry representing the set symmetric difference a minus b
*Supported Signatures*

```sql theme={null}
function st_symdifference(geography, geography) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_symdifference)

## `st_transform`

Returns the geometry transformed from one SRID to another SRID.
*Supported Signatures*

```sql theme={null}
function st_transform(geometry, decimal(38, 0), decimal(38, 0)) returns geometry
function st_transform(geometry, decimal(38, 0)) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_transform)

## `st_union`

Geometry representing the union of a and b
*Supported Signatures*

```sql theme={null}
function st_union(geography, geography) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_union)

## `st_within`

True if the second object fully contains the first
*Supported Signatures*

```sql theme={null}
function st_within(geography, geography) returns boolean
function st_within(geometry, geometry) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_within)

## `st_x`

The longitude of a point
*Supported Signatures*

```sql theme={null}
function st_x(geography) returns double
function st_x(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_x)

## `st_xmax`

The maximum longitude
*Supported Signatures*

```sql theme={null}
function st_xmax(geography) returns double
function st_xmax(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_xmax)

## `st_xmin`

The minimum longitude
*Supported Signatures*

```sql theme={null}
function st_xmin(geography) returns double
function st_xmin(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_xmin)

## `st_y`

The latitude of a point
*Supported Signatures*

```sql theme={null}
function st_y(geography) returns double
function st_y(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_y)

## `st_ymax`

The maximum latitude
*Supported Signatures*

```sql theme={null}
function st_ymax(geography) returns double
function st_ymax(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_ymax)

## `st_ymin`

The minimum latitude
*Supported Signatures*

```sql theme={null}
function st_ymin(geography) returns double
function st_ymin(geometry) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/st_ymin)

## `to_geography`

No-op; prevents us from re-packaging GEOGRAPHY during input
*Supported Signatures*

```sql theme={null}
function to_geography(geography) returns geography
function to_geography(geography, boolean) returns geography
function to_geography(variant) returns geography
function to_geography(variant, boolean) returns geography
function to_geography(varchar) returns geography
function to_geography(varchar, boolean) returns geography
function to_geography(binary) returns geography
function to_geography(binary, boolean) returns geography
function to_geography($1) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/to_geography)

## `to_geometry`

No-op; prevents us from re-packaging GEOMETRY during input
*Supported Signatures*

```sql theme={null}
function to_geometry(geometry) returns geometry
function to_geometry(variant, decimal(38, 0)) returns geometry
function to_geometry(variant) returns geometry
function to_geometry(varchar, decimal(38, 0)) returns geometry
function to_geometry(varchar) returns geometry
function to_geometry(binary, decimal(38, 0)) returns geometry
function to_geometry(binary) returns geometry
function to_geometry(variant, decimal(38, 0), boolean, boolean) returns geometry
function to_geometry(variant, boolean, boolean) returns geometry
function to_geometry(variant, decimal(38, 0), boolean) returns geometry
function to_geometry(variant, boolean) returns geometry
function to_geometry(varchar, decimal(38, 0), boolean, boolean) returns geometry
function to_geometry(varchar, boolean, boolean) returns geometry
function to_geometry(varchar, decimal(38, 0), boolean) returns geometry
function to_geometry(varchar, boolean) returns geometry
function to_geometry(binary, decimal(38, 0), boolean, boolean) returns geometry
function to_geometry(binary, boolean, boolean) returns geometry
function to_geometry(binary, decimal(38, 0), boolean) returns geometry
function to_geometry(binary, boolean) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/to_geometry)

## `try_to_geography`

No-op; prevents us from re-packaging GEOGRAPHY during input
*Supported Signatures*

```sql theme={null}
function try_to_geography(geography) returns geography
function try_to_geography(geography, boolean) returns geography
function try_to_geography(variant) returns geography
function try_to_geography(variant, boolean) returns geography
function try_to_geography(varchar) returns geography
function try_to_geography(varchar, boolean) returns geography
function try_to_geography(binary) returns geography
function try_to_geography(binary, boolean) returns geography
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/try_to_geography)

## `try_to_geometry`

No-op; prevents us from re-packaging GEOMETRY during input
*Supported Signatures*

```sql theme={null}
function try_to_geometry(geometry) returns geometry
function try_to_geometry(variant, decimal(38, 0)) returns geometry
function try_to_geometry(variant) returns geometry
function try_to_geometry(varchar, decimal(38, 0)) returns geometry
function try_to_geometry(varchar) returns geometry
function try_to_geometry(binary, decimal(38, 0)) returns geometry
function try_to_geometry(binary) returns geometry
function try_to_geometry(variant, decimal(38, 0), boolean, boolean) returns geometry
function try_to_geometry(variant, boolean, boolean) returns geometry
function try_to_geometry(variant, decimal(38, 0), boolean) returns geometry
function try_to_geometry(variant, boolean) returns geometry
function try_to_geometry(varchar, decimal(38, 0), boolean, boolean) returns geometry
function try_to_geometry(varchar, boolean, boolean) returns geometry
function try_to_geometry(varchar, decimal(38, 0), boolean) returns geometry
function try_to_geometry(varchar, boolean) returns geometry
function try_to_geometry(binary, decimal(38, 0), boolean, boolean) returns geometry
function try_to_geometry(binary, boolean, boolean) returns geometry
function try_to_geometry(binary, decimal(38, 0), boolean) returns geometry
function try_to_geometry(binary, boolean) returns geometry
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/try_to_geometry)