[QGIS-Developer] point in polygon strikes again: big performance issue

[Jorge Gustavo Rocha]

Hi Harrissou,

Thanks for the tip. I've used:

array_sum( overlay_contains( '03-04-21', Active ) )

and it works, but... there is not significant perform enhancement. As
far as I can see, overlay_contains does not take any advantage of a
spatial index.

Regards,

Jorge

Às 22:36 de 14/03/21, Delaz J escreveu:
> Hi Jorge,
> 
> It doesn't explain nor fix the issue with your expression but mind
> trying /array_sum(overlay_contains('03-04-2021', 'Active'))/? No working
> QGIS around to test myself.
> 
> I don't remember if array_sum was introduced in 3.18 or master but
> overlay_** requires at least 3.16. Regards, Harrissou
> 
> Le 14/03/2021 à 22:47, David Strip a écrit :
>> I was able to replicate your problem on my system (Win 10, QGIS 3.10.5).
>>
>> I tried "Join attributes by location (summary)". This computed the
>> result in about 5 seconds.
>> There are some anomalies in the data, however. For example, there's an
>> entry for Belgium with province value "Unknown" and no lat/lon, so it
>> doesn't get included in the total. Also, the point for Northern
>> Territories, Australia, lies in the ocean, so it is not contained in
>> the Australia polygon.
>>
>>
>> _______________________________________________
>> QGIS-Developer mailing list
>> QGIS-Developer at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> 

J. Gustavo
-- 
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Gabinete 3.29 (Piso 3)
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor