Radius search
Latimer, Richard
richard.latimer@airways.co.nz
Mon, 6 Nov 2000 08:05:58 +1300
Hi,
Have you looked on the Cognos website?
I recall an article in Supportlink sometime in the last couple of years
describing how somebody implemented somehting similar to what you are
proposing.
cheers
Richard
> -----Original Message-----
> From: Edis, Bob [SMTP:bob.edis@fleetpride.com]
> Sent: Sunday, November 05, 2000 6:28 AM
> To: 'powerh-l@list.swau.edu'
> Subject: RE: Radius search
>
> G'day John
>
> I suggest you use an external procedure written in C or BASIC or similar
> that can be called from a Quick screen.
>
> Blue
>
> -----Original Message-----
> From: John Pearce [mailto:jpearce@rmi.net]
> Sent: Saturday, November 04, 2000 8:43 AM
> To: powerh-l@sphere.swau.edu
> 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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.