st_srid function

Applies to: Databricks Runtime 17.1 and above

Preview

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

SQL

-- 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

Related functions

• st_setsrid function
• st_transform function