Find Points near Linestring
Hi,
I want to build a table with linestrings (saved routes) and would like to
-- find all linestrings near a defined point
-- find all points (pois in another table) near a selected linestring.
I think I have to build a buffer for linestring and use it for a search.
here ist a similar solution for MS SQL-Server:
http://johanneskebeck.spaces.live.com/blog/cns!42E1F70205EC8A96!4504.entry
Is there a practical solution for MySQL that also gives good performance for a large database?
thanks & best regards,
Karsten
Subject
Views
Written By
Posted
Find Points near Linestring
6103
March 25, 2010 05:51AM
2715
March 26, 2010 03:01AM
2709
March 26, 2010 04:41AM
2740
March 27, 2010 03:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.