I am currently working on some line string data that are very close by and have the same Start and endpoints for the most part. I want to create midpoints or average centroids that will tell me how many of those are grouped up close by.
Using mainly SQL queries i have been able to confirm that the centroids are close enough to intersect with each other using a 15 meter buffer, it is functionnal so far.
SELECT feeder_NRO02.ca_pk_uid AS ID, ST_centroid(feeder_NRO02.geom) AS geom, 1 AS count FROM feeder_NRO02
My issue is that so far, I haven't been able to count how many times those buffers intersect with each other or create an average centroid.
Any advice? I have QGIS and some basic database tools at my disposal for this.