MySQL Forums
Forum List  »  GIS

Find Points near Linestring
Posted by: Karsten Violka
Date: March 25, 2010 05:51AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Find Points near Linestring
5894
March 25, 2010 05:51AM
2598
March 26, 2010 03:01AM
2601
March 26, 2010 04:41AM
2615
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.