X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 61DA7475F34 for ; Wed, 26 Mar 2003 19:58:45 -0500 (EST) Received: from volt.beyondtheweb.com (unknown [64.141.17.13]) by postgresql.org (Postfix) with ESMTP id 7434B475CBC for ; Wed, 26 Mar 2003 19:58:41 -0500 (EST) Received: from 192.168.111.107 (h64-141-16-15.sunwave.net [64.141.16.15]) by volt.beyondtheweb.com (8.11.6/8.11.6) with ESMTP id h2R0wc018223; Wed, 26 Mar 2003 16:58:38 -0800 From: Michael A Nachbaur To: "Ryan" , Subject: Re: Off topic : world database Date: Wed, 26 Mar 2003 16:55:21 +0000 User-Agent: KMail/1.5 Cc: References: <3E824070.7070207@oasis.net.au> <10083.65.102.128.233.1048719399.squirrel@fordparts.com> In-Reply-To: <10083.65.102.128.233.1048719399.squirrel@fordparts.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200303261655.21899.mike@nachbaur.com> X-Spam-Status: No, hits=-28.9 required=5.0 tests=BAYES_20,DATE_IN_PAST_06_12,EMAIL_ATTRIBUTION,IN_REP_TO, QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES,USER_AGENT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/595 X-Sequence-Number: 12633 On March 26, 2003 10:56 pm, Ryan wrote: > Your best bet is buying a good zipcode database that has lat/long, but > would only really help you in the USA. This kind of data tends not to be > cheap... Either that, or web scrape mapquest.com or some other site that provides lat/long for returned results, but that probably violates the acceptable use policy of those sites. I for one would be very interested in such a web service (I'd really like a address / street lookup to find lat/longs for addresses, but thats not likely to happen).