[postgis-users] ST_intersects : error message

[laurent]

Hello,

Ok sorry for the mistake. So please read the correction : 

-----------------------
CREATE TABLE example_intersections_a AS (SELECT ST_Intersection
(part_1.geom, part_2.geom)FROM fra_adm0 AS part_1,france_merge_pts1 AS
part_2 WHERE ST_Intersects(part_1.geom, part_2.geom));
ALTER TABLE example_intersections_a ADD COLUMN id SERIAL;
ALTER TABLE example_intersections_a ADD PRIMARY KEY (id);
----------------------


My goal is to populate into a new table  the points from my raw points layer
(france_merge_pts1) which contain or touch the surface of my raw surface
polygon (fra_adm0). According to you,  my query is good? My point layer is
huge. I launched the query. It is still ongoing. Maybe is there a way to
speed up the process? 

In advance, thank you. 





--
View this message in context: http://postgis.17.x6.nabble.com/ST-intersects-error-message-tp5005029p5005031.html
Sent from the PostGIS - User mailing list archive at Nabble.com.