1

I have a 'POINTS' layer with 74 points geometry with the fields "NAME" and "ID". I want to add a virtual layer with the following query to calculate the clusters using the DBSCAN function:

SELECT NAME, ST_ClusterDBSCAN(geometry, 4, 2, ID) over() AS cluster_id, *
FROM POINTS

The result I get is an error message as shown in the screenshot: enter image description here

What could I do to get this error solved?

Improve this question

1 Answer 1

Reset to default
2

Virtual layers use SpatiaLite under the hood, which doesn't have st_clusterDBScan. Instead, you can add a query layer using the DB Manager, which will forward the query to the database.

enter image description here

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.