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.