[postgis-users] ST_Intersection very slow

Rémi Cura remi.cura at gmail.com
Wed Feb 25 00:24:20 PST 2015


Where is the data set?
Cheers,
Rémi-C

2015-02-25 9:18 GMT+01:00 Mark Wynter <mark at dimensionaledge.com>:

> 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/94b62fd8/attachment.html>


More information about the postgis-users mailing list