PostGIS，ST_Transform(不存在函数)

Question

我有以下代码，可以从已经创建的点层中获得30m的几何形状

CREATE TABLE intrsct_buff AS ( SELECT ST_Transform( ST_Buffer( ST_Transform(pt.geom,4326)::geography, 30.0), 2263) as geom, pt.count FROM public.intrsct_pts as pt );

我不断收到错误：第3行function st_transform(geography, integer) does not exist我需要在___,SRID 2263前面添加什么？这似乎是ST_Transform函数，他们说我有一个错误

Answer 1

您需要将地理转换回几何图形；ST_Transform无法与geography:配合使用

CREATE TABLE intrsct_buff AS ( 
SELECT
ST_Transform(
ST_Buffer(
ST_Transform(
pt.geom,
4326
)::geography,
30.0
)::geometry,
2263
) as geom,
pt.count
FROM
public.intrsct_pts as pt
);