[postgis-users] ST_intersects : error message

[Rémi Cura]

Maybe you can check that you have indexes on both geom column.

Cheers,

Rémi-C


2013/12/2 laurent <lcelati at latitude-geosystems.com>

> 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.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131202/a6ecc03f/attachment.html>