On 3/14/2021 5:34 PM, Jorge Gustavo
Rocha wrote:
I tried a different approach, using aggregate, matching on the country name, thinking that would be faster than a spatial check.Hi David, Thanks for replication this issue. "Join attributes by location (summary)" is definitely the best choice for this use case. It creates the new layer in a few seconds. That's why I think we are missing something (spatial indexes?, dependency graph?) in the _expression_ engine.There are anomalies in the data. That's almost the same with any dataset we start working with :-) Regards, Jorge
I created a new field with the _expression_:
Much to my surprise, this was slower than "Join attributes by location (summary)"aggregate( '03-03-2021','sum', "Confirmed", "Country_Region" ILIKE attribute(@parent,'SOVEREIGNT'))
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
