ST_FindUTMSRID

Signature

INT ST_FindUTMSRID(GEOMETRY geom);

Description

Find the UTM SRID code from the centroid of a geometry (geom).

Examples

We have a POINT, placed in west of France and which coordinates is (-1.53391 47.20259) (in WGS 84 - EPSG:4326)

SELECT ST_FindUTMSRID('POINT(-1.53391 47.20259)');

-- Answer: 32630

Here, EPSG:32630 correspond to WGS 84 / UTM zone 30N.

See also