Acura Integra Type-R All Integra Type R Discussions

ITR VIN / Badge # database

Thread Tools
 
Search this Thread
 
Old Jul 11, 2006 | 08:33 AM
  #1  
Doespike's Avatar
Thread Starter
Honda-Tech Member
 
Joined: Apr 2006
Posts: 3,959
Likes: 1
From: Buffalo, NY, USA
Default ITR VIN / Badge # Archive

Here-ye! Here-ye! A project underway....an ITR VIN vs Badge Number database containing ALL ITRs, not just stolen, wrecked, or otherwise stripped. The idea here is that it's easier to find this info now from current owners rather than tracking down previous owners who may or may not remember the badge #. And sadly, a mint condition ITR today could be a stripped shell tomorrow.

We're thinking perhaps a few well known and trusted folks could keep and update a PRIVATE database with ITR VINs along with the associated Badge #, color, and year. The information gathered would not be made public. If someday, someone is searching for the badge # of an ITR they just bought, they would contact one of these people with their VIN and hopefully get a match. I'd say at least 2-3 people to handle this so that the data will be backed up if something were to happen to one person's computer.

This program would be completely voluntary. I think this is the ITR community's best bet for maintaining this invaluable info for years to come, unless Honda ever releases THE LIST


Modified by Doespike at 1:39 AM 2/3/2008
Reply
Old Jul 11, 2006 | 11:06 AM
  #2  
Chris N's Avatar
Honda-Tech Member
 
Joined: Jul 2002
Posts: 14,274
Likes: 0
Default Re: ITR VIN / Badge # database (Doespike)

Wouldn't you want database and application people to do this?

Top priority to me would not be trusted, well known or moderator, since that doesn't guarantee they'll know a good way to store all this data so its useable/searchable. i can think of 100 people I work with who think an excel spreadsheet is a 'database'.

chris - who is not volunteering, unless dave r0r wants to help me set up something on ITRCA.


Modified by Chris N at 2:21 PM 7/11/2006
Reply
Old Jul 11, 2006 | 11:11 AM
  #3  
nsxtasy's Avatar
H-T Order of Merit
 
Joined: Jan 2000
Posts: 23,478
Likes: 2
From: Chicago
Default Re: ITR VIN / Badge # database (Doespike)

andyt already has a list of all USIM ITR VINs which associates them with color and year. I believe he also has received a sampling of a small number of badge numbers associated with VINs, which he has used on occasion to estimate approximate badge numbers for any particular VIN. (I'm sure you're aware that the badge numbers were not necessarily assigned in the exact same sequence as the VINs came off the assembly line.) It's all documented in that topic that's stickied at the top of this forum (the one that I originated).
Reply
Old Jul 11, 2006 | 07:46 PM
  #4  
Doespike's Avatar
Thread Starter
Honda-Tech Member
 
Joined: Apr 2006
Posts: 3,959
Likes: 1
From: Buffalo, NY, USA
Default Re: ITR VIN / Badge # database (nsxtasy)

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by Chris N &raquo;</TD></TR><TR><TD CLASS="quote">Wouldn't you want database and application people to do this?

Top priority to me would not be trusted, well known or moderator, since that doesn't guarantee they'll know a good way to store all this data so its useable/searchable. i can think of 100 people I work with who think an excel spreadsheet is a 'database'.

chris - who is not volunteering, unless dave r0r wants to help me set up something on ITRCA.
Modified by Chris N at 2:21 PM 7/11/2006</TD></TR></TABLE>
Yes, an Excel Spreadsheet Weither its here or ITRCA or both, as long as people see the post and participate if they choose.

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by nsxtasy &raquo;</TD></TR><TR><TD CLASS="quote">andyt already has a list of all USIM ITR VINs which associates them with color and year. I believe he also has received a sampling of a small number of badge numbers associated with VINs, which he has used on occasion to estimate approximate badge numbers for any particular VIN. (I'm sure you're aware that the badge numbers were not necessarily assigned in the exact same sequence as the VINs came off the assembly line.) It's all documented in that topic that's stickied at the top of this forum (the one that I originated).</TD></TR></TABLE>

Yeah, I've checked out your post a few times , andyt
Yes, I know you can't determine Badge# from the VIN which is why I think this would be a good project. This way we could get a record of the EXACT badge for VINs and not an approximation.
Reply
Old Jul 18, 2007 | 05:45 PM
  #5  
DC2 R guy's Avatar
Honda-Tech Member
 
Joined: Oct 2006
Posts: 2,980
Likes: 0
From: Pomona 909, ca
Default Re: ITR VIN / Badge # database (Doespike)

BUMP
Reply
Old Jul 18, 2007 | 06:00 PM
  #6  
Doostur's Avatar
Honda-Tech Member
 
Joined: Sep 2004
Posts: 15,427
Likes: 0
From: Boost > NA
Default

Godo idea... buts its gonna be alot of work.
Reply
Old Jul 18, 2007 | 06:15 PM
  #7  
rino924's Avatar
White Trash Wish Cash
Community Builder
Community Influencer
 
Joined: Sep 2004
Posts: 2,374
Likes: 0
From: Indiana
Default Re: (Doostur)

Doespike, this is a good idea, and a ton of work

although he has me on a lead to contact a girl who I am 97% sure had my old ITR and the only thing holding me back is not having a myspace account to contact her

so if a legit person i am familiar with (ie trust giving some info out) and has a myspace account, pm me
Reply
Old Jul 18, 2007 | 06:56 PM
  #8  
Doespike's Avatar
Thread Starter
Honda-Tech Member
 
Joined: Apr 2006
Posts: 3,959
Likes: 1
From: Buffalo, NY, USA
Default Re: (Doostur)

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by Doostur &raquo;</TD></TR><TR><TD CLASS="quote">Good idea... buts its gonna be a lot of work.</TD></TR></TABLE>
It has already been a bit of work, but I've enjoyed it and have the desire to see this project through. I've made pretty good progress on the 97's (I'm starting with 97 and working forward through the years, though still collecting info on the others) and I should be making a pretty good breakthrough on the majority of USDM 97s within a month or so.

Now is the best time to record this information for the ages. There are still plenty of former owners of stolen/stripped/wrecked ITRs around in the community who will be the last ones to know the definitive link between that ITR's VIN and its badge. Even if that shell isn't rebuilt, this info would eliminate that badge as a possible badge for another nekkid ITR.

For those who couldn't give a shitte about badges, no problem. I respect that. Move on to the next thread. This is simply something I wish to do and some others care about.

As for privacy, I do not give out or post sensitive information. Honestly though, a lot of this information has already been publicly published, but still, thieves/haters won't locate an R by me :evil:

At the moment, I'm backing up my information with one person only, Jim aka Walker111. He's good people, well trusted in my opinion and many many others, and also has an interest in recording badges. I'm doing this simply because if something happened to me or my home, I wouldn't want this data to be lost. A lot of this info is no longer posted online to be searched again.

If you'd like to provide your ITRs info, I'd be very appreciative as will any future owner of your caR. Ok, I'm tired of typing, more whiskey

BTW, Chris N is a ******.
Reply
Old Jul 18, 2007 | 07:22 PM
  #9  
EG6-DC2's Avatar
Honda-Tech Member
 
Joined: Jan 2004
Posts: 2,328
Likes: 0
From: At the beach, AZ
Default Re: (Doespike)

Joe, the badge to VIN number thing kinda seems like doing an ITR Soduko.

Lets all help Joe out with this, I already did awhile ago. He has put a lot of time and effort into this and really cares about these cars.
Reply
Old Jul 18, 2007 | 07:23 PM
  #10  
itrSteez's Avatar
Honda-Tech Member
20 Year Member
 
Joined: Nov 2002
Posts: 3,510
Likes: 0
From: Wilmington, NC
Default

I could set this up webbased so easily... and lock down the directory to a few individuals that are allowed to see/modify the list.

excel is a microsoft product
Reply
Old Jul 18, 2007 | 08:00 PM
  #11  
andyt's Avatar
Honda-Tech Member
 
Joined: Nov 2004
Posts: 519
Likes: 0
From: TN, US
Default Re:

Here are some that I have.

JH4DC2317VS002881 57
JH4DC2310VS002916 90
JH4DC2314WS002189 97
JH4DC2318WS002616 349
JH4DC2314WS002922 454
JH4DC2315WS003920 946
JH4DC2316WS004106 1007
JH4DC2311YS001231 88
JH4DC2316YS003363 748
JH4DC231XYS004242 1070

I've got some more around here somewhere....i'll keep looking.
Reply
Old Jul 18, 2007 | 08:23 PM
  #12  
Doespike's Avatar
Thread Starter
Honda-Tech Member
 
Joined: Apr 2006
Posts: 3,959
Likes: 1
From: Buffalo, NY, USA
Default Re: (EG6-DC2)

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by EG6-DC2 &raquo;</TD></TR><TR><TD CLASS="quote">Joe, the badge to VIN number thing kinda seems like doing an ITR Soduko. </TD></TR></TABLE>
I admit, I had to look this up Thanks Nolan
<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by itrSteez &raquo;</TD></TR><TR><TD CLASS="quote">I could set this up webbased so easily... and lock down the directory to a few individuals that are allowed to see/modify the list.

excel is a microsoft product </TD></TR></TABLE>
I've only been using Excel because I have it and know how to use it. So far it's been organizing the info pretty well. Something web based and more customized would probably be better, but would definitely have to be concerned about security.

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by andyt &raquo;</TD></TR><TR><TD CLASS="quote">Here are some that I have.

I've got some more around here somewhere....i'll keep looking.</TD></TR></TABLE>
Thanks a lot Andy! Your work on this as well as other's have helped tremendously! Knowing the valid ITR serial numbers over the years and the possible VIN Excel spreadsheet (Dave ROR?) have been invaluable!
Reply
Old Jul 18, 2007 | 08:42 PM
  #13  
itrSteez's Avatar
Honda-Tech Member
20 Year Member
 
Joined: Nov 2002
Posts: 3,510
Likes: 0
From: Wilmington, NC
Default Re: (Doespike)

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by Doespike &raquo;</TD></TR><TR><TD CLASS="quote">
I've only been using Excel because I have it and know how to use it. So far it's been organizing the info pretty well. Something web based and more customized would probably be better, but would definitely have to be concerned about security.
</TD></TR></TABLE>

Linux + MySQL = Security

It'd be nothing we'd have to do immediately... it could be done down the road, but if you'd like it done I could crack it out in between projects.

Ideally we could make it search if you punch in your VIN (treating the VIN as the private key, we wouldn't make it public data) it could tell you year, color, #.

but it won't go backwards, ya know?

Make a public view where all they can do is punch in a vin and hit submit...

then make an admin view where they can view the complete list add/modify.

Also give a form where people can submit/verify their production number (that might take some logistics to figure out how to keep integrity in that system)
Reply
Old Jul 18, 2007 | 08:47 PM
  #14  
andyt's Avatar
Honda-Tech Member
 
Joined: Nov 2004
Posts: 519
Likes: 0
From: TN, US
Default Re: (Doespike)

Did walker send you a copy of the spreadsheet I generated for him?
It had quite a bit of info in it.
Reply
Old Jul 18, 2007 | 08:49 PM
  #15  
Doespike's Avatar
Thread Starter
Honda-Tech Member
 
Joined: Apr 2006
Posts: 3,959
Likes: 1
From: Buffalo, NY, USA
Default Re: (itrSteez)

Great idea! I can definitely see this evolving into something like that. At the moment, I'm still in my "initial" stage of research. I'm literally editing entries, and adding new ones daily. It's hard to say when this stage will be done....might be a year. After that, it'll just be any new info that comes along. So yeah, at some point this project will need someone with those kinds of skillz
Reply
Old Jul 18, 2007 | 08:53 PM
  #16  
Doespike's Avatar
Thread Starter
Honda-Tech Member
 
Joined: Apr 2006
Posts: 3,959
Likes: 1
From: Buffalo, NY, USA
Default Re: (andyt)

Um, me forgets I think I remember him mentioning it. I have the Excel file with all the possible ITR VINs over the years....the one that calculates the check digit. Then I just cross reference with the info that Ken quoted from you in the first post of the "How many ITRs were made..." thread. It's kind of bulky and Excel always recalculates each time I open it......and runs out of memory
Reply
Old Jul 18, 2007 | 10:27 PM
  #17  
itrSteez's Avatar
Honda-Tech Member
20 Year Member
 
Joined: Nov 2002
Posts: 3,510
Likes: 0
From: Wilmington, NC
Default Re: (Doespike)

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by Doespike &raquo;</TD></TR><TR><TD CLASS="quote">Great idea! I can definitely see this evolving into something like that. At the moment, I'm still in my "initial" stage of research. I'm literally editing entries, and adding new ones daily. It's hard to say when this stage will be done....might be a year. After that, it'll just be any new info that comes along. So yeah, at some point this project will need someone with those kinds of skillz </TD></TR></TABLE>

What would be neat if the database has the right number the user forcefully "donates" then the proceeds go to expo funds.
Reply
Old Jul 18, 2007 | 11:40 PM
  #18  
:jdmshmaydm:'s Avatar
Honda-Tech Member
 
Joined: Jul 2002
Posts: 4,490
Likes: 0
From: Okinawa, USA
Default Re: Re: (andyt)

I don't think I would do that. You never know what could happen. Hacking or infiltrators etc. A thief or thieves would have a field day with that. With all the info along with your VIN one could tell your full name, address, and other misc. info. It's dealing with personal information too, not just a car.

IMO.
Reply
Old Jul 19, 2007 | 12:28 AM
  #19  
itrSteez's Avatar
Honda-Tech Member
20 Year Member
 
Joined: Nov 2002
Posts: 3,510
Likes: 0
From: Wilmington, NC
Default Re: Re: (Gatecrasher21AF)

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by Gatecrasher21AF &raquo;</TD></TR><TR><TD CLASS="quote">I don't think I would do that. You never know what could happen. Hacking or infiltrators etc. A thief or thieves would have a field day with that. With all the info along with your VIN one could tell your full name, address, and other misc. info. It's dealing with personal information too, not just a car.

IMO.</TD></TR></TABLE>

Who said anything about putting full names and addresses in there? (Year, Color, VIN, Prod #) that's it....
Reply
Old Jul 19, 2007 | 12:33 AM
  #20  
Doostur's Avatar
Honda-Tech Member
 
Joined: Sep 2004
Posts: 15,427
Likes: 0
From: Boost > NA
Default

And girlfriend cellphone numbers too... thanks.
Reply
Old Jul 19, 2007 | 04:53 AM
  #21  
Dave_B's Avatar
Honda-Tech Member
 
Joined: Aug 2004
Posts: 12,098
Likes: 1
From: blavica
Default

You know I'll help in any way I can.
Reply
Old Jul 19, 2007 | 10:09 PM
  #22  
neo_'s Avatar
Honda-Tech Member
 
Joined: Jul 2006
Posts: 2,676
Likes: 1
From: South Florida
Default Re: (Dave_B)

Sounds like a great idea, lets get the ball rolling!

P.S. You can add a "?" next to my VIN number... Theifs FTL
Reply
Old Jul 19, 2007 | 10:21 PM
  #23  
rino924's Avatar
White Trash Wish Cash
Community Builder
Community Influencer
 
Joined: Sep 2004
Posts: 2,374
Likes: 0
From: Indiana
Default Re: (neo_)

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by neo_ &raquo;</TD></TR><TR><TD CLASS="quote">Sounds like a great idea, lets get the ball rolling!

P.S. You can add a "?" next to my VIN number... Theifs FTL</TD></TR></TABLE>

you mean badge number, right
Reply
Old Jul 19, 2007 | 10:31 PM
  #24  
neo_'s Avatar
Honda-Tech Member
 
Joined: Jul 2006
Posts: 2,676
Likes: 1
From: South Florida
Default Re: (rino924)

<TABLE WIDTH="90%" CELLSPACING=0 CELLPADDING=0 ALIGN=CENTER><TR><TD>Quote, originally posted by rino924 &raquo;</TD></TR><TR><TD CLASS="quote">

you mean badge number, right </TD></TR></TABLE>

No, not really. I know my VIN number but I don't know my badge number. Thats why there would be a "? next to my VIN number"

Reply
Old Jul 20, 2007 | 06:19 AM
  #25  
rino924's Avatar
White Trash Wish Cash
Community Builder
Community Influencer
 
Joined: Sep 2004
Posts: 2,374
Likes: 0
From: Indiana
Default Re: (neo_)

doh!

it was late
Reply



All times are GMT -8. The time now is 06:38 AM.