You have to purchase a database. ZIP codes are not geographic, you
can't calculate lat/lon from them. Here is one source:
On Jun 26, 2005, at 6:43 PM, Scott Gifford wrote:
> Jack Lauman <jlauman@stripped> writes:
>> A couple of months ago these was a discussion about ZIP code plotting
>> on this list. Does anyone know how to calculate LONG/LAT coordinates
>> from ZIP+4?
> In the U.S., you can use the census data:
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?