From pauldacus@gmail.com Thu Nov 17 17:37:18 2005 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 ; 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 ; 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 ; Thu, 17 Nov 2005 13:37:15 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so2264847wxc for ; 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 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 ? 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 
Hi,

I actually implemented =
something in PHP/mySQL that is a DB of latitudes
& longitudes and zi=
pcodes.  The formula computes distance 'as the crow
flies' using the rad=
ius 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=20

hotscripts.com?
If needed, I =
can gzip a mysql dump... I'll leave the PG conversion to
you :-)  Very s=
imple though... only 3 fields!


Tell me if you'd like... maybe I'll post a download link to a page.=
------=_Part_1107_2197278.1132249035101-- From pauldacus@gmail.com Thu Nov 17 18:40:20 2005 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 A2120DB600 for ; Thu, 17 Nov 2005 14:40:20 -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 84299-10 for ; Thu, 17 Nov 2005 18:40:20 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.206]) by svr1.postgresql.org (Postfix) with ESMTP id 1FD27D967F for ; Thu, 17 Nov 2005 14:40:17 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so2279120wxc for ; Thu, 17 Nov 2005 10:40:18 -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=AkRPqxZjHgFAi5TfcZYhxhNHc1oHLw15jAs6McpheKwGo0wVdtKUm+CxhgvNhExBcPZv0eez9lcfcTpo7Rl9jjUzQnwX8vY3YpybJ+dTXjPZMz/1FhMHgVloEJmxRbL9getNM9cakg43OFzLtKwAFwjNqLFJSJhTIUu/ymkcx7U= Received: by 10.70.52.8 with SMTP id z8mr5247193wxz; Thu, 17 Nov 2005 10:40:18 -0800 (PST) Received: by 10.70.82.1 with HTTP; Thu, 17 Nov 2005 10:40:17 -0800 (PST) Message-ID: <888b7c4d0511171040h6ae7885ct4a7786001d9f27b7@mail.gmail.com> Date: Thu, 17 Nov 2005 10:40:17 -0800 From: PaulD To: pgsql-sql@postgresql.org Subject: Geographic DB MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1982_544651.1132252817291" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.311 required=5 tests=[AWL=-0.664, HTML_00_10=0.642, HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.311 X-Spam-Level: * X-Archive-Number: 200511/132 X-Sequence-Number: 23383 ------=_Part_1982_544651.1132252817291 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Having been asked, I posted a mySQL dump of latitude, longitude and zip codes for the US. I've also included a PHP zipcode computational piece of code, a DB manager, and the page itself.... all in GZIP format. Instruction= s are on the page. P.S. I can't possibly help you if you're having problems! Unzip it all, put the dump into mySQL, edit the db.inc file (username/pwd/host/db_name), run the ziptest1.php script, and if it works GREAT! If it doesn't... you'll hav= e a new opportunity to learn! I would never want to take that away from you :-) It works for me, so if it doesn't work for you, I probably can't fix it= . Paul Dacus ------=_Part_1982_544651.1132252817291 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Having been asked, I posted a mySQL dump of latitude, longitude and zip cod= es for the US.  I've also included a PHP zipcode computational piece o= f code, a DB manager, and the page itself.... all in GZIP format.  Ins= tructions are on the page.

P.S.  I can't possibly help you if you're having problems!&nbs= p; Unzip it all, put the dump into mySQL, edit the db.inc file (username/pw= d/host/db_name), run the ziptest1.php script, and if it works GREAT!  = If it doesn't... you'll have a new opportunity to learn!  I would neve= r want to take that away from you :-)  It works for me, so if it doesn= 't work for you, I probably can't fix it.


Paul Dacus
------=_Part_1982_544651.1132252817291--