Radius search

[John Webster]

I seem to recall someone wrote this technique up in either a conference
paper or SupportLink. Try searching the Cognos knowledge base. I remember it
because it was another example of US imperialism which assumed that
everybody had zip codes within the USA!
John W
----- Original Message -----
From: "John Pearce" <jpearce@rmi.net>
To: <powerh-l@sphere.swau.edu>
Sent: Sunday, November 5 2000 03:42
Subject: Radius search


> Greetings!
>
> I've been asked to implement a radius search based on Zipcode.  Somdthing
> like find all addreses in the database that are within 100 miles of
Zipcode
> 80201.  I located a database of Zipcodes with lattitude & longitude
> coordinates and I've found the math to make it work.  The downside is that
> the math requires trig functions that don't seem to be within PowerHouse.
>
> I'm wondering if anyone has done this type of thing and how it was done.
> If it makes any difference, the platform is HP MPE/iX 5.5 and PH 8.19.
>
> Thanks,
>
> John
>
> ------------------------------------------------------------------
> John Pearce  <jpearce@rmi.net> | Bethesda Management Company
> Speaking for only myself | Colorado Springs, CO  USA
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=
> Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.