Skip to main content

st_srid function

Applies to: check marked yes 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