geo-registry

st_transform

How PostGIS runs Reproject: st_transform.

About this implementation
Engine PostGIS
Tool name st_transform
Interface sql
Implements Reproject
Documentation Not stated
Effects modifies input: no, network: no
Notes Not stated
Status active

Parameters

Name Type Required Default Choices Note
geom geometry no Not stated Not stated Not stated
from_proj text no Not stated Not stated Not stated
to_proj text no Not stated Not stated Not stated
to_srid integer no Not stated Not stated Not stated

SQL overloads

  • st_transform(geom geometry, from_proj text, to_proj text) → geometry
  • st_transform(geom geometry, from_proj text, to_srid integer) → geometry
  • st_transform(geom geometry, to_proj text) → geometry
  • st_transform(geometry, integer) → geometry

How it maps to the operation

Operation parameter Parameter here Note
layer #1 Not stated
crs #2 An SRID (4326), or to_proj for a PROJ string; the SRID must be in spatial_ref_sys.

Differences from the operation

  • Uses the database's spatial_ref_sys and PROJ; results can differ from GDAL where the transformation chosen differs.

Harvested by the postgis harvester from engine version 3.7.0. Names can change when an engine is harvested again.