I have routes (linestrings) recorded in the database. I want to create a query which returns the routes that have some commonality with a circle whose center and radius are passed as parameter.
I tried this way:
SELECT * FROM routes WHERE ST_Touches(geom, (ST_Buffer(ST_GeomFromText('POINT(-12.988542214345332 -38.44563066959381)'), 100, 8)))
Is it correct?