[postgis-users] ST_Intersection very slow

Mark Wynter mark at dimensionaledge.com
Wed Feb 25 00:18:47 PST 2015


I’ll also try and take a look - I’ve just downloaded the dataset in question - I’m keen to see it.  Will revert.

On 25 Feb 2015, at 6:41 pm, Rémi Cura <remi.cura at gmail.com> wrote:

> Damn I'm publishing a QGIS plugin for POstGIS, 
> I can't write you the fast intersection by casting polygon to points, intersection then casting back to polygon.
> I'll try to squeeze it somehow.
> Cheers,
> Rémi-C
> 
> 2015-02-25 1:44 GMT+01:00 Mark Wynter <mark at dimensionaledge.com>:
> The land cover data you’re working with - does it come as a raster?   We need a strategy for busting up that single, monolithic poly with lots of holes.
> If its a raster, then I think that tiling on import would be of huge benefit.
> I’m just under the pump the next few days.
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150225/89a04b2b/attachment.html>


More information about the postgis-users mailing list