X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id ADE07DB38D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 17 Nov 2005 13:37:18 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 77403-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 17 Nov 2005 17:37:17 +0000 (GMT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.194])
	by svr1.postgresql.org (Postfix) with ESMTP id 83EE7DABE0
	for <pgsql-sql@postgresql.org>; Thu, 17 Nov 2005 13:37:15 -0400 (AST)
Received: by xproxy.gmail.com with SMTP id s14so2264847wxc
	for <pgsql-sql@postgresql.org>; Thu, 17 Nov 2005 09:37:15 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=WzcaFdgE16wt96QLf9XlsPsdEQ+BumaMTCgP51QvjfdEGvqfjm817VWuwo9VU68GO6iCS0qQTqVN1Mg7t+JVKZSmbK+0rFexZBsZWR+c2GdEcWOBK6UAyn6Kdp7rHbDOxRoCd8jsYyUznwFOcHH1V/mg3oy9aZslQnvNQq8s/3Y=
Received: by 10.70.37.13 with SMTP id k13mr5188779wxk;
	Thu, 17 Nov 2005 09:37:15 -0800 (PST)
Received: by 10.70.82.1 with HTTP; Thu, 17 Nov 2005 09:37:15 -0800 (PST)
Message-ID: <888b7c4d0511170937j2db0d61fo8ffe830e2a50df76@mail.gmail.com>
Date: Thu, 17 Nov 2005 09:37:15 -0800
From: PaulD <pauldacus@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Geographic DB
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1107_2197278.1132249035101"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.316 required=5 tests=[AWL=0.315,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.316
X-Spam-Level: 
X-Archive-Number: 200511/131
X-Sequence-Number: 23382

------=_Part_1107_2197278.1132249035101
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,

I actually implemented something in PHP/mySQL that is a DB of latitudes
& longitudes and zipcodes.  The formula computes distance 'as the crow
flies' using the radius of the Earth between 2 zipcodes, etc.  It's

here:

http://www.deschuteshay.com/distance/ziptest1.php

I wish I could remember where I got this data... maybe
hotscripts.com <http://hotscripts.com/>?
If needed, I can gzip a mysql dump... I'll leave the PG conversion to
you :-)  Very simple though... only 3 fields!

Tell me if you'd like... maybe I'll post a download link to a page.

------=_Part_1107_2197278.1132249035101
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<pre><font><font><font><font size=3D"-0">Hi,<br><br>I actually implemented =
something in PHP/mySQL that is a DB of latitudes<br>&amp; longitudes and zi=
pcodes.  The formula computes distance 'as the crow<br>flies' using the rad=
ius of the Earth between 2 zipcodes, etc.  It's
<br><br>here:<br><br><a href=3D"http://www.deschuteshay.com/distance/ziptes=
t1.php" target=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event=
,this)">http://www.deschuteshay.com/distance/ziptest1.php</a><br><br>I wish=
 I could remember where I got this data... maybe=20
<a href=3D"http://hotscripts.com/" target=3D"_blank" onclick=3D"return top.=
js.OpenExtLink(window,event,this)"><br>hotscripts.com</a>?<br>If needed, I =
can gzip a mysql dump... I'll leave the PG conversion to<br>you :-)  Very s=
imple though... only 3 fields!
<br><br>Tell me if you'd like... maybe I'll post a download link to a page.=
</font></font></font></font></pre>


------=_Part_1107_2197278.1132249035101--