Share via

st_srid function

Applies to: check marked yes Databricks Runtime 17.1 and above

Important

This feature is in Public Preview.

Returns the SRID of the input GEOGRAPHY or GEOMETRY value.

Syntax

st_srid ( geoExpr )

Arguments

  • geoExpr: A GEOGRAPHY or GEOMETRY value, or a STRING or BINARY value representing a geospatial value.

Returns

A value of type INTEGER, representing the SRID of the input GEOGRAPHY or GEOMETRY value.

The function returns NULL if the input is NULL.

Examples

-- Returns SRID from EWKB representation.
> SELECT st_srid(st_geomfromewkb(X'0101000020110F000000000000000024400000000000004140'))
  3857
-- Returns default SRID for geography.
> SELECT st_srid(st_geogfromtext('POINT(10 34)'))
  4326