Thanks, the issue with this data isn't law enforcement data. The data is owned by the clerk's office and we are going to try to clean it up. It will become a political football, if I start ranting about the clerk's office not doing their job, so we'll just fix it and move on. Which is not to say we don't have some garbage in our data too!<G>
JH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gil Hale Sent: Saturday, April 26, 2008 7:41 AM To: [email protected] Subject: RE: VIN Decoder > If we had had this tool.... What a great way to harness database technology. One would think the various law enforecement agencies, especially at the state and Federal level would have already had that capability. But, if law enforcement agencies are run anything like civilian businesses I bet they just have a bunch of disjointed and corrupted databases that are "too hard" to link together in any kind of really useful manner. Anyway, my hat is off to you for your efforts, and the good it can do in the situation cited. Even if I were otherwise inclined to put out some kind of smart-assed quip, given the scenario you shared with us such a quip would hardly be socially correct. I really do not think I can conjure up a more hated slice of society than those who prey on children. Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John Harvey > Sent: Saturday, April 26, 2008 2:43 AM > To: [EMAIL PROTECTED] > Subject: RE: VIN Decoder > > > I have to parse the vin number so I can pull make,model,body > style and year. > I think I can do this fairly quickly. I'm writing a power search utility > using Google's mapping for the front end, then I'll let the investigators > pick a radius for the search. Here's an example of how this will > work - last > fall we had some sex pervert trying to abduct kids from an elementary > school. The officers got a vehicle description for make, model > and year. If > we had had this tool we would have been able to plug those > parameters in and > pull all matches within a selected radius, then check for matches > in the sex > offender database. The first priority though, is to get the garbage out of > the mvr table. > > JH > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Stephen Russell > Sent: Friday, April 25, 2008 3:20 PM > To: ProFox Email List > Subject: Re: VIN Decoder > > On Fri, Apr 25, 2008 at 2:40 PM, John Harvey <[EMAIL PROTECTED]> > wrote: > > > Yeah, I found a bunch of links too. Problem is, our local county clerk > > isn't > > doing the job and the MVR table is crap. Ford is Frd, Ford, For, etc. > > > > I've got 1.5 million records to unscrew. > > > ----------------------------------------------------------------- > > So you just need to get mfg straight or do you need make / model and have > them consistent to a Dropdown list level? > > > > -- > Stephen Russell > Sr. Production Systems Programmer > Mimeo.com > Memphis TN > > 901.246-0159 > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [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.
