Re: Zip Code Proximity search

[john.pedersen]

I found some code for creating a stored procedure in sql server for doing a proximity search:

CREATE PROCEDURE dbo.sp_FindNearby
@CenterLat float,
@CenterLon float,
@SearchDistance float,
@EarthRadius float
AS
declare @CntXAxis float
declare @CntYAxis float
declare @CntZAxis float

set @CntXAxis = cos(radians(@CenterLat)) * cos(radians(@CenterLon))
set @CntYAxis = cos(radians(@CenterLat)) * sin(radians(@CenterLon))
set @CntZAxis = sin(radians(@CenterLat))

select *, ProxDistance = @EarthRadius * acos( XAxis*@CntXAxis +
YAxis*@CntYAxis + ZAxis*@CntZAxis)
from [TABLENAME]
where @EarthRadius * acos( XAxis*@CntXAxis + YAxis*@CntYAxis +
ZAxis*@CntZAxis) <= @SearchDistance
order by ProxDistance ASC
GO

Maybe someone could have a go at creating a mysql version - I'll have a go myself, but it's all new to me, so it may take some time