postgres 空间坐标转换和获取中心点

SELECT
	st_astext (
	st_transform ( ST_GeomFromText ( st_astext ( P.shape ), 4326 ), 3857 )) bound,
	concat ( P.x1, P.x2) m1,
	CAST (
	REPLACE (
	REPLACE (
	REPLACE ( ST_AsText ( ST_centroid ( st_transform ( ST_GeomFromText ( st_astext ( P.shape ), 4326 ), 3857 ) )), ' ', ',' ),
	'POINT(',
	'' 
	),
	')',
	'' 
	) AS VARCHAR 
	) point,
	( CASE P.x3 WHEN 0 THEN NULL ELSE P.x3 END ) AS m2
FROM
	xxx P