Ben Clewett wrote:
Hi,
I have a need to locate (x,y) coordinates from mysql where they are
close to another coordinate. For instance, all pizza bars near my car.
Example: Searching for points closer than z to (i,j) using Pythagoras:
SET i = 10;
SET j = 10;
SET z = 30;
SELECT x, y
FROM
Sorry, subject corruption, my last email should have had this subject,
not 'temporary table issue'...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
D]
> Sent: 10 January 2006 14:27
> To: Ben Clewett
> Cc: mysql@lists.mysql.com
> Subject: Re: Geographical advice
>
> If you visualise your search area as a circle around your 'target'
> coordinates, then you can eliminate many of the irrelevant rows by search
> for
If you visualise your search area as a circle around your 'target' coordinates,
then you can eliminate many of the irrelevant rows by search for coordinates
that fall within a square surrounding that circle.
So, imagine a simple grid with target coordinates of 6,8 and a search radius of
3. Ther
Hi,
I have a need to locate (x,y) coordinates from mysql where they are
close to another coordinate. For instance, all pizza bars near my car.
Example: Searching for points closer than z to (i,j) using Pythagoras:
SET i = 10;
SET j = 10;
SET z = 30;
SELECT x, y
FROM coordinates
WHERE PO
