I can do that using MS MapPoint, MapInfo, or even Google, but I need to select the records first.
JH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leland F. Jackson, CPA Sent: Friday, April 27, 2007 10:51 PM To: ProFox Email List Subject: Re: Need a Math Wiz This looks interesting: http://www.mapproinc.com/docs/how_to_use_mappro_with_databases.pdf http://www.mapproinc.com/ Regards, LelandJ john harvey wrote: > Aight, I know some o use guyz are math wizzes and I ain't. I am persistent > though, and I will gladly use stolen/purloined/borrowed/copied/etc code. > > I have a table of warrants 55,000+ which I have geocoded. I am testing a > system that will push out information, via email, to the neighborhood watch > groups, a table of crimes within a 1/2 mile radius, over the past 30 days. > That data is already available via a system the MPD has and I'm pushing it > to some test users. > > I want to also add into those emails a listing of warrants within that > radius and push it out as well. Therein lies the problem. (I'm afraid I must > have been distracted when those classes were taught). Does anyone have a > clue how to do a select from a table given a lat and long and select all > records that fall within the 1/2 mile radius? > > Help!!!!!! > > John Harvey > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.