MySQL Forums
Forum List  »  GIS

spatial Buffer
Posted by: sherif attia
Date: April 03, 2010 09:59AM

Hello everybody,

I'm new using mysql spatial
I want to return all points within a certain radius from a predefined point
I use the following query:

SELECT * FROM pointsTable where MBRContains(
Buffer(GeomFromText( 'POINT(-122.078916 37.393885 )' ),200),
coord) = 1

But unfortunately I get this error:

FUNCTION mydb.BUFFER does not exist

Can anybody tell me the best solution for that?

Options: ReplyQuote

Written By
spatial Buffer
April 03, 2010 09:59AM
April 26, 2010 01:45AM

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.