ST_Transform error

Question

I am getting an error from ST_Tranform while using ST_Intersection: No function matches the given name and argument types. You might need to add explicit type casts.

select ST_Intersection(ST_Transform(ST_GeomFromText('POLYGON((
200000 2900000,250000 3500000,300000 2960000,200000 2967400,200000 
2900000))',96703),4326), ST_Transform((geom, 2249), 4326))
from polygon_folder;

You forgot a function around (geom, 2249) – thibautg Jun 07 '16 at 20:21 — thibautg, Jun 07 '16 at 20:21

score 2 · Accepted Answer · edited Apr 13 '17 at 12:34

2

You probably want to do this:

  select ST_Intersection(
  ST_Transform(
      ST_SetSRID(ST_GeomFromText('POLYGON((
    200000 2900000,250000 3500000,300000 2960000,200000 2967400,200000 
    2900000))'),96703),4326), 

ST_Transform(geom, 4326))
from polygon_folder;

But, I am quite sure (from Finding all polygons inside of a polygon) that ST_Intersection is not really what you need....

edited Apr 13 '17 at 12:34

Community

1

answered Jun 07 '16 at 20:23

WKT

2,183
1
10
19

So what is a good way to find all the polygons that intersect with a given polygon? @WKT – moffittime Jun 07 '16 at 20:29
About select * from polygon_folder pf where ST_Intersects(pf.geometry, ST_GeomFromText('....'); – user30184 Jun 07 '16 at 20:35

ST_Transform error

1 Answers1

Linked