Skip to content

ST_SetSRID

Sets the SRID (spatial reference identifier) for a geometry.

Usage

geometry ST_SetSRID(geom: geometry, srid: integer)

Arguments

  • geom (geometry): Input geometry
  • srid (integer)

Description

Sets the SRID (spatial reference system identifier) of the geometry. This is metadata only - no coordinate transformation occurs. Use ST_Transform to actually reproject coordinates.

Examples

SELECT ST_SetSRID(ST_Point(-122.35, 47.65), 4326);
┌───────────────────────────────────────────────────────────────────┐
│ st_setsrid(st_point(Float64(-122.35),Float64(47.65)),Int64(4326)) │
│                              geometry                             │
╞═══════════════════════════════════════════════════════════════════╡
│ POINT(-122.35 47.65)                                              │
└───────────────────────────────────────────────────────────────────┘