설명

Sets the SRID on a geometry to a particular integer value. Useful in constructing bounding boxes for queries.

	This function does not transform the geometry coordinates in any way - it simply sets the meta data defining the spatial reference system the geometry is assumed to be in. Use ST_Transform if you want to transform the geometry into a new projection.

This method implements the OGC Simple Features Implementation Specification for SQL 1.1.

This method supports Circular Strings and Curves.

예시

Mark a point as WGS 84 longitude/latitude.

SELECT ST_SetSRID(ST_Point(-123.365556, 48.428611), 4326) AS wgs84long_lat;

SRID=4326;POINT(-123.365556 48.428611)

0101000020E6100000D236FE4465D75EC059DAA9B9DC364840

Figure

Mark a point as WGS 84 longitude/latitude and then transform it to Web Mercator.

SELECT ST_Transform(ST_SetSRID(ST_Point(-123.365556, 48.428611), 4326), 3785) AS sphere_merc;

SRID=3785;POINT(-13732990.8753491 6178458.96425423)

0101000020C90E000010DC02DC8F316AC16657B6BDA6915741

Figure

참고

4.5절. “SPATIAL_REF_SYS 테이블과 공간 참조 시스템”, ST_SRID, ST_Transform, UpdateGeometrySRID