I was successful in getting all our warrants on the web, except for the secret indictments while I was with the SCSO. I wrote the original website in Fox and Web Connection and since I left, they have redone it in php using my design. Check it out at www.shelbywarrants.org. This site, coupled with the WASP program I wrote helped reduce the backlog by over 5,000 warrants in one year, even though the current Sheriff (who doesn't know the difference between a tort and a felony) cut the Fugitive Bureau by 25 officers. The website allows anyone to search by name or address, last name only, or street name only. It then allows the user to submit a tip (anonymous or otherwise.)
Now, all those same warrants will be getting pushed out so that if someone in the neighborhood watch has a warrant, they will turn themselves in or else hit the road, and other's will turn them in. John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chet Gardiner Sent: Friday, April 27, 2007 9:37 PM To: [email protected] Subject: Re: Need a Math Wiz Have you checked with your lawyers before "enlisting" civilians to "catch crooks"? Are you fingering a bunch of regular folks who've just missed a traffic court appointment or are these warrants for real "crooks"? Are you trying to pin these "crimes" on folks with outstanding warrants? I wonder how many of the warrants are for folks who are in neighborhood watch groups... Sounds fishy... This sounds kinda' near that gray line that separates legal from unconstitutional... http://www.aclu-tn.org/ http://www.aclu.org/police/gen/14614pub19971201.html 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. > Mime-Version: 1.0 > Content-Transfer-Encoding: 7bit > Content-Type: text/plain; charset=us-ascii > > 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: [email protected] 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.
