Re:Free US ZIP Code Database as CSV
by technoguyrob on Wednesday April 30, 2008 @12:15AM
(#177283)
Download the database I posted in my other comment here, and try this SQL statement:
Might be faster if you do a query to get the lat and long for the ZIP code you need first, though. Hell, it would probably be fastest to skip the database all together and just import the data and loop the distance formula, recording the smallest distances as you go.
[ Parent
| on HN ]
There are no comments on this comment yet.