I used google's api to get the lat and long and now thanks to Dave Bernard, who I met at FoxForward last year, I think I have a solution. I'll check with him to see if he minds me posting his code.
John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leland F. Jackson, CPA Sent: Friday, April 27, 2007 11:13 PM To: ProFox Email List Subject: Re: Need a Math Wiz Well, why couldn't you use MapPro to build a geocoded file of all address within a fifty mile radius of your center point. Then import the geocoded file into a foxpro database. Then run a join on your warrant database against the geocoded database to see what you get. Regards, LelandJ john harvey wrote: > 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.