sql - 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 );

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

标签： sqlbuffertransformpostgisspatial

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
);