[postgis-users] multipolygon polygon test intersects

[Christo Du Preez]

I managed to get it working. The only problem is speed.

I'm using it in a function and having to test a couple thousand polygons
takes ages. I also tried using a temp table, this is also not an option
because of the speed issue.

Christo Du Preez wrote:
> Sorry to be such a pain. How would I use the dump function? Is there a
> sample that I can perhaps study/
>
> Nicolas Ribot wrote:
>   
>>> Thanx Nicolas,
>>>
>>> What if I store my polygons in a geometrycollection instead of a
>>> multipolygon and then use the && operator?
>>>
>>>       
>> I think it will be the same as working with multipolygons: a
>> geometryCollection is one object, and the whole extent of all the
>> contained objects will be considered with the && operator.
>>
>> You really have to to have one object per row in your table in order
>> to compare objects.
>>
>> Nicolas
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>>     
>
>   

-- 
Christo Du Preez

Senior Software Engineer
Mecola IT
Mobile:	 +27 [0]83 326 8087
Skype:	 christodupreez
Website: http://www.locateandtrade.co.za