Zip code proximity search
586099Jul 2 2007 — edited Jul 3 2007Hi,
I createed a zip_codes table in oracle and populated around 40,000 records.
Can somebody help me to retrieve the data for a proximity search for a given zip code. This is same as a store locator or car search for a given zip code and radius in miles.
CREATE TABLE zip_codes (
zip float NOT NULL ,
city varchar2(30) NOT NULL ,
state varchar2(2) NOT NULL ,
latitude float NOT NULL ,
longitude float NOT NULL ,
timezone float NOT NULL ,
dst float NOT NULL ,
latitude_cos float NOT NULL ,
latitude_sin float NOT NULL ,
PRIMARY KEY (zip)
) ;
Thanks in advance.....