Skip to content

ST_SRID

Returns the SRID (spatial reference identifier) of a geometry.

Usage

integer ST_SRID(geom: geometry)
integer ST_SRID(geog: geography)

Arguments

  • geog (geography): Input geography
  • geom (geometry): Input geometry

See Coordinate Reference Systems for how SedonaDB represents and compares CRS.

Examples

SELECT ST_SRID(ST_SetSRID(ST_Point(-122.35, 47.65), 4326));

┌────────────────────────────────────────────────────────────────────────────┐
│ st_srid(st_setsrid(st_point(Float64(-122.35),Float64(47.65)),Int64(4326))) │
│                                   uint32                                   │
╞════════════════════════════════════════════════════════════════════════════╡
│                                                                       4326 │
└────────────────────────────────────────────────────────────────────────────┘