PostGIS, ST_Transform (no function exists..)

Question

I have the following code to get 30m geometry shapes from a point layer already created

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

I keep receiving the error: LINE 3 function st_transform(geography, integer) does not exist What do I need to add in front of ___,SRID 2263? That seems to be the ST_Transform function where they say I have an error

Avocado · Accepted Answer · 2022-02-12 15:22:14Z

4

You need to transform the geography back into geometry; ST_Transform does not work with 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 );

edited Feb 12, 2022 at 15:22

answered Apr 24, 2020 at 0:11

Avocado

9117 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sTonystork Over a year ago

That was all i needed! Thank you avocado I had been stuck on this for a while, will eat one of you tomorrow in appreciation!!

Avocado Over a year ago

Awesome! Feast away! You can always check out the argument types for postgis functions in their docs, e.g., postgis.net/docs/ST_Transform.html

Collectives™ on Stack Overflow

PostGIS, ST_Transform (no function exists..)

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related