Hopefully I explain this properly. I am trying to check if a route falls into another route I have created. The route is saved as a linestring. My search query is:
SELECT idFROM routesWHERE ST_Contains( ST_Buffer( ST_GeomFromText('LINESTRING($route)'), 10, 'endcap=round join=round'), route)It's not returning any results even though it should be. I have a few routes for it to check for that are either are the exact same route or one it should be contained in.
What may I be missing here?
أكثر...
SELECT idFROM routesWHERE ST_Contains( ST_Buffer( ST_GeomFromText('LINESTRING($route)'), 10, 'endcap=round join=round'), route)It's not returning any results even though it should be. I have a few routes for it to check for that are either are the exact same route or one it should be contained in.
What may I be missing here?
أكثر...