X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 717B8D1B443
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  1 Jan 2004 05:04:37 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 72275-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  1 Jan 2004 01:03:47 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id 8016CD1B449
	for <pgsql-sql@postgresql.org>; Thu,  1 Jan 2004 01:03:47 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.12.9/8.12.9) with ESMTP id i0153RU6003248
	for <pgsql-sql@postgresql.org>; Thu, 1 Jan 2004 05:03:27 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id i014uOJr098432
	for pgsql-sql@postgresql.org; Thu, 1 Jan 2004 04:56:24 GMT
From: Randolf Richardson <rr@8x.ca>
X-Newsgroups: comp.databases.postgresql.sql
Subject: Re: Radius of a zip code
Date: Thu, 1 Jan 2004 04:56:24 +0000 (UTC)
Organization: Inter-Corporate Computer & Network Services, Inc.
Lines: 27
Message-ID: <Xns9462D2D4F5738rr8xca@200.46.204.72>
References: <000b01c3cc09$e043fd70$0201a8c0@andy2>
	<8408.1072483789@sss.pgh.pa.us>
X-Complaints-To: usenet@news.hub.org
User-Agent: Xnews/5.04.25
X-Face: 
 +kXh]<cm0}l<Fvzd*?E]I7=Ug!X`>8'{:R`HzXla-aT~$s8a+C)k/B%RBr$_3sP`[kA}cl7#mD^9Z:oM`HpoC_kUEH['RZ*Ob%pz\ww^q&x)~zc`.xd]VQ4WN/3t2nS-<I>BvI%LF\B4:\9$EI:/|<)`?8I_;
	xzG@SOYFir/gk_eB4"Rl43-h%)8O0sR$b&Mp3XHR(0j=
X-Face-Author: Randolf Richardson (composed with Adobe Photoshop)
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/21
X-Sequence-Number: 16414

"tgl@sss.pgh.pa.us (Tom Lane)" wrote in comp.databases.postgresql.sql:

[sNip]
> I'm guessing that the big problem is that you didn't measure longitude
> and latitude in identical units in your table, so your "circle" isn't
> real circular, and the smaller problem is that "miles" converts to
> "degrees of arc" differently at different latitudes.

    	Don't forget that there are two different types of "miles" which need 
to be considered when measuring distances:

    	    	1 statute/land mile = 1.609 km
    	    	1 nautical/sea mile = 1.85 km

    	Since kilometers are consistent over land and water (and in the great 
vacuum of space), the metric system should always be used to ensure clarity, 
unless the only land masses the user is concerned with have no bodies of 
water.

    	=)

-- 
Sir Randolf, noble spam fighter - rr@8x.ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.