Shamil Salakhetdinov
shamil at users.mns.ru
Fri Jul 1 06:17:44 CDT 2005
Thank you a lot, Marty! Shamil ----- Original Message ----- From: "MartyConnelly" <martyconnelly at shaw.ca> To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com> Sent: Thursday, June 30, 2005 11:45 AM Subject: Re: [dba-Tech] VIN Coding/Decoding? > > > Shamil Salakhetdinov wrote: > > >Hi All, > > > >Is there anywhere VIN coding/decoding decription and information? > >Is that an open(free) information or it has to be bought from somewhere? > >I did find this http://yarchive.net/car/vin.html but it's incomplete. > > > >Thank you in advance for any additional information on VIN decoding! > > > >Shamil > > > > > > > > > I have only messed around with this but I don't think you want to do > this from scratch > The data is updated monthly by car manufacturers. Some US government > department may > have a full database, like the FBI, but commercially it is generally > being done by a web service. > Most commercial ones are not yet complete and still being built to > include heavy trucks, RV's and motorcycles. > Some web services will give you proper complete info anywhere between > 67% to 95 % of the time > depending on which one you use. You will have to get quotes on cost per > web transaction > but it is probably around $0.50 to a $1. > > And things like a 1964 Corvette have only 9 digit VINS. Who knows what > is on a East German Trabant. > > Maybe you can pick up a free VIN database from NewZealand or Australia > I have an Access database with the US NHTSA Safety and Manufacturers > Vehicle Recalls > and that is available on line as a text delimited file. > > I have seen PDA's that use these VIN database web services at some of > the larger car auctions. > They also hook into a state's license bureau to track titles and > accident info, as well, from the VIN > not just decoding the info from the VIN number. > > This company makes a standalone program or web service that delivers > XMLVIN info for US compliant VIN's as below > Cost is about $300 US with updates. > www.vinpower.com > > Here is an explanation of what is involved in producing the info from a > vin decoder > from another VIN web service supplier. > These guys even provide jpeg pictures of auto in the xml > http://dataonesoftware.com/vinDecoderHome.php > > Explanation of a VIN database > http://www.dataonesoftware.com/sources/DecoderBrochure.pdf > > Other sites with basic VIN breakdown and checkdigit methods > > http://www2.vinpower.com/VINInformation.aspx > http://www.washingtonwatchdog.org/documents/cfr/title49/part565.html > http://www.nhtsa.dot.gov/cars/problems/salvage/ > > Here is some sample XML web service output. > > <?xml version="1.0" encoding="ISO-8859-1"?> > <REPORTS> > <REPORT type="OPTION"> > <VinPOWER version="1.0.0"> > <DATABASE version="2004.11.008"> > <MODULE name="PASSENGER, MPV, LIGHT TRUCK" > version="2004.11.005"/> > <MODULE name="EXT. BASIC JATO 20041104_101058" > version="2004.11.005"/> > </DATABASE> > <VIN number="1B3EJ46X11N602989"> > <DECODED Model_Year="2001" Make="Dodge" Model="Stratus" > Trim_Level="SE"> > <KEY name="Model Year" value="2001"/> > <KEY name="Make" value="Dodge"/> > <KEY name="Model" value="Stratus"/> > <KEY name="Body Type" value="4 Door Sedan"/> > <KEY name="Trim Level" value="SE"/> > <KEY name="Engine Type" value="L4, 2.4L; DOHC 16V"/> > <KEY name="Country" value="UNITED STATES"/> > <KEY name="Assy. Plant" value="Sterling Heights, MI"/> > <KEY name="Production Seq. Number" value="602989"/> > <KEY name="Check Digit" value="1"/> > <KEY name="Drive Line Type" value="FWD"/> > <KEY name="Manufacturer" value="DaimlerChrysler > Corporation"/> > <KEY name="Restraint System" value="Dual Air Bag; > Automatic Belts"/> > <KEY name="Vehicle Type" value="Passenger Car"/> > <KEY name="Vehicle Class" value="Mid-size Car"/> > <KEY name="Fuel Type" value="Gasoline"/> > <KEY name="JATO" value="157146"/> > </DECODED> > </VIN> > </VinPOWER> > <VEHICLES Year="2001" Make="DODGE" Model="STRATUS"> > <VEHICLE Model_Year="2001" Make="DODGE" Model="STRATUS" > Trim_Level="SE" Version_Name="SE" Driven_Wheels="F" Number_of_Doors="4" > Vehicle_id="15714620010216"> > <BASIC_INFO> > <ITEM item_name="vehicle_id" item_value="15714620010216"/> > <ITEM item_name="Unique Identity" item_value="157146"/> > <ITEM item_name="Researcher initials" item_value="JH"/> > <ITEM item_name="Data date" item_value="20010216"/> > <ITEM item_name="Date of change" item_value="20010216"/> > <ITEM item_name="Research date" item_value="20010507"/> > <ITEM item_name="Conclude date" item_value="20010730"/> > <ITEM item_name="Data status" item_value="4"/> > <ITEM item_name="Model year" item_value="2001"/> > <ITEM item_name="Country" item_value="USA"/> > <ITEM item_name="Responsible market UID" > item_value="157146"/> > <ITEM item_name="Date physically checked" item_value="0"/> > <ITEM item_name="Make group" > item_value="DAIMLERCHRYSLER"/> > <ITEM item_name="Make" item_value="DODGE"/> > <ITEM item_name="Local make name" item_value="Dodge"/> > <ITEM item_name="Model" item_value="STRATUS"/> > <ITEM item_name="Local model name" item_value="Stratus"/> > <ITEM item_name="Model descriptor" item_value="-"/> > <ITEM item_name="Version name" item_value="SE"/> > <ITEM item_name="Local version name" item_value="SE"/> > <ITEM item_name="Special/limited edition" item_value="-"/> > <ITEM item_name="Trim level" item_value="SE"/> > <ITEM item_name="local trim level" item_value="SE"/> > <ITEM item_name="trim classification" item_value="B1"/> > <ITEM item_name="Pricing descriptor" item_value="-"/> > <ITEM item_name="Number of doors" item_value="4"/> > <ITEM item_name="local number of doors" item_value="4"/> > <ITEM item_name="Body type" item_value="SA"/> > <ITEM item_name="local body type" item_value="SA"/> > <ITEM item_name="cab type" item_value=""/> > <ITEM item_name="roof type" item_value=""/> > <ITEM item_name="wheelbase type" item_value=""/> > <ITEM item_name="Driver location" item_value=""/> > <ITEM item_name="Driven wheels" item_value="F"/> > <ITEM item_name="Transmission type" item_value="A"/> > <ITEM item_name="Liters" item_value="2.4"/> > <ITEM item_name="Maximum power kW" item_value="112"/> > <ITEM item_name="Maximum power hp/PS" item_value="150"/> > <ITEM item_name="Fuel type" item_value="U"/> > <ITEM item_name="Compressor" item_value=""/> > <ITEM item_name="Seating capacity" item_value="5"/> > <ITEM item_name="Price currency" item_value="USD"/> > <ITEM item_name="Override option price currency" > item_value=""/> > <ITEM item_name="Override attribute price currency" > item_value=""/> > <ITEM item_name="MSRP" item_value="17830"/> > <ITEM item_name="Dealer Invoice" item_value="16582"/> > <ITEM item_name="Wholesale price" item_value="15587.1"/> > <ITEM item_name="Wholesale price" item_value="15587.1"/> > <ITEM item_name="MSRP including delivery charge" > item_value="18425"/> > <ITEM item_name="Net prices" item_value="-"/> > <ITEM item_name="Country of assembly" item_value="USA"/> > <ITEM item_name="Date version introduced" > item_value="20000717"/> > <ITEM item_name="Date model introduced" > item_value="20000717"/> > <ITEM item_name="Vehicle type" item_value="N"/> > <ITEM item_name="Manufacturer's code" > item_value="JRDH41"/> > <ITEM item_name="First research date" > item_value="20010222"/> > <ITEM item_name="Data status research date" > item_value="20010507"/> > <ITEM item_name="VIN" item_value="1B3AJ42B"/> > <ITEM item_name="Make continent group" item_value="USA"/> > <ITEM item_name="Model group" item_value="DODGE STRATUS"/> > <ITEM item_name="Version information" item_value="S"/> > <ITEM item_name="Latest price list date/number" > item_value="20010216-4"/> > <ITEM item_name="Release date" item_value="20010222"/> > <ITEM item_name="Indicative prices only" item_value=""/> > <ITEM item_name="Cash/Net price" item_value="0"/> > <ITEM item_name="Finance price" item_value="0"/> > <ITEM item_name="Source of price list" item_value=""/> > <ITEM item_name="Make code" item_value="-"/> > <ITEM item_name="Model code" item_value="-"/> > <ITEM item_name="Model generation" item_value="2"/> > <ITEM item_name="Date body type introduced" > item_value="0"/> > <ITEM item_name="Date number of doors introduced" > item_value="0"/> > <ITEM item_name="Previous model name" > item_value="STRATUS"/> > <ITEM item_name="Previous version name" item_value="SE"/> > <ITEM item_name="Date version was linked" item_value="0"/> > <ITEM item_name="Version id" item_value="15714601"/> > <ITEM item_name="JATOCode1" item_value=""/> > <ITEM item_name="JATOCode2" item_value=""/> > <ITEM item_name="Secondary Price currency" > item_value="EUR"/> > <ITEM item_name="Secondary MSRP" item_value="14671.9"/> > <ITEM item_name="Secondary Dealer Invoice" > item_value="13644.9"/> > <ITEM item_name="Secondary Wholesale price" > item_value="12826.2"/> > <ITEM item_name="Secondary Wholesale price" > item_value="12826.2"/> > <ITEM item_name="Secondary MSRP including delivery > charge" item_value="15161.5"/> > <ITEM item_name="JATO global segment" item_value="-5"/> > <ITEM item_name="JATO regional segment" item_value="-22"/> > </BASIC_INFO> > <STANDARD_EQUIPMENT> > <ITEM item_name="Trim" item_value="Trim level: SE"/> > <ITEM item_name="Body style" item_value="Four-door > sedan body style"/> > <ITEM item_name="Seating" item_value="Seating: five > seats"/> > <ITEM item_name="Speakers" item_value="Four speaker(s)"/> > <ITEM item_name="Antenna" item_value="Fixed mast > antenna"/> > <ITEM item_name="Audio system" item_value="Audio > system with cassette"/> > <ITEM item_name="Coefficient of drag" > item_value="Coefficient of drag: 0.31"/> > <ITEM item_name="Body side molding" item_value="Body > side molding"/> > <ITEM item_name="Chrome/bright trim" > item_value="Chrome/bright trim on side of body"/> > <ITEM item_name="Disc brakes" item_value="Four disc > brakes including two ventilated discs"/> > <ITEM item_name="Bumpers" item_value="Body color front > and rear bumpers"/> > <ITEM item_name="Delivery charges" item_value="Fixed > delivery charges: 595"/> > <ITEM item_name="Remote trunk/hatch release" > item_value="Electric remote trunk/hatch release"/> > <ITEM item_name="Cruise control" item_value="Cruise > control"/> > <ITEM item_name="Courtesy lights" > item_value="Delayed/fade courtesy lights"/> > <ITEM item_name="Vanity mirror" item_value="Driver and > passenger vanity mirror"/> > <ITEM item_name="External dimensions" > item_value="External dimensions: overall length (inches): 191.2, overall > width (inches): 70.6, overall height (inches): 54.9, wheelbase (inches): > 108, front track (inches): 60.2, rear track (inches): 60.2 and curb to > curb turning circle (feet): 36.8"/> > <ITEM item_name="Internal dimensions" > item_value="Internal dimensions: front headroom (inches): 37.6, rear > headroom (inches): 35.8, front hip room (inches): 52.5, rear hip room > (inches): 53.1, front leg room (inches): 42.3, rear leg room (inches): > 38.1, front shoulder room (inches): 55.2, rear shoulder room (inches): > 54.7 and interior volume (cu ft): 94"/> > <ITEM item_name="Cargo capacity" item_value="Cargo > capacity: all seats in place (cu ft): 16"/> > <ITEM item_name="Drive" item_value="Front-wheel drive"/> > <ITEM item_name="Engine" item_value="2,429 cc 2.4 > liters in-line 4 engine with 87.5 mm bore, 101 mm stroke, 9.4 > compression ratio, double overhead cam and four valves per cylinder"/> > <ITEM item_name="Emission control level" > item_value="Emission control level FED"/> > <ITEM item_name="Fuel system" item_value="Multi-point > injection fuel system"/> > <ITEM item_name="Fuel" item_value="Unleaded fuel"/> > <ITEM item_name="Fuel tank" item_value="16 gallon main > unleaded fuel tank"/> > <ITEM item_name="Tachometer" item_value="Tachometer"/> > <ITEM item_name="Low fuel level warning" > item_value="Low fuel level warning"/> > <ITEM item_name="Clock" item_value="Clock"/> > <ITEM item_name="Headlights" item_value="Complex > surface lens halogen bulb headlights"/> > <ITEM item_name="Headlight control" > item_value="Headlight control"/> > <ITEM item_name="Tires" item_value="Front and rear > tires with 205 mm tire width, 65% tire profile and T tire rating"/> > <ITEM item_name="Power locks" item_value="Internal > button power locks"/> > <ITEM item_name="Paint" item_value="Metallic paint , > black paint , gloss paint , pearl paint"/> > <ITEM item_name="Power" item_value="Power: 112 kW , > 150 HP SAE @ 5,200 rpm; 167 ft lb , 226 Nm @ 4,000 rpm"/> > <ITEM item_name="Fuel economy" item_value="Fuel > economy EPA highway (mpg): 30 and EPA city (mpg): 20"/> > <ITEM item_name="Front airbag" item_value="Driver and > passenger front airbag"/> > <ITEM item_name="Head restraints" item_value="Two > height adjustable head restraints on front seats"/> > <ITEM item_name="Front seat belts" item_value="Height > adjustable 3-point reel front seat belts on driver seat and passenger > seat with pre-tensioners"/> > <ITEM item_name="Rear seat belts" item_value="3-point > reel rear seat belts on driver side, passenger side and center side"/> > <ITEM item_name="Seat upholstery" item_value="Cloth > seat upholstery"/> > <ITEM item_name="Front seat center armrest" > item_value="Front seat center armrest"/> > <ITEM item_name="Front seat" item_value="Bucket driver > and passenger seat"/> > <ITEM item_name="Rear seats" item_value="Three > asymmetrical bench front facing rear seats"/> > <ITEM item_name="Steering wheel" item_value="Plastic > steering wheel with tilt adjustment"/> > <ITEM item_name="Power steering" item_value="Power > steering"/> > <ITEM item_name="Glove compartment" > item_value="Lockable glove compartment"/> > <ITEM item_name="Door pockets/bins" item_value="Door > pockets/bins for driver seat and passenger seat"/> > <ITEM item_name="Cup holders" item_value="Front seats > and rear seats cup holders"/> > <ITEM item_name="Suspension" item_value="Wishbone > front suspension independent with stabilizer bar and coil springs , > multi-link rear suspension independent with stabilizer bar and coil > springs"/> > <ITEM item_name="Transmission" item_value="Automatic > four-speed transmission with lock-up, electronic control and shift lever > on floor"/> > <ITEM item_name="Ventilation system" > item_value="Ventilation system with recirculation setting"/> > <ITEM item_name="Air conditioning" item_value="Air > conditioning"/> > <ITEM item_name="Rear view mirror" item_value="Rear > view mirror"/> > <ITEM item_name="Door mirrors" item_value="Driver and > passenger power black door mirrors"/> > <ITEM item_name="Rear window" item_value="Rear window > with defogger"/> > <ITEM item_name="Tinted glass" item_value="Tinted > glass on cabin"/> > <ITEM item_name="Heat reflective glass" > item_value="Heat reflective glass"/> > <ITEM item_name="Windshield wipers" > item_value="Windshield wipers with variable intermittent wipe"/> > <ITEM item_name="Power windows" item_value="Front > power windows with one one-touch , rear power windows"/> > <ITEM item_name="Warranty whole vehicle" > item_value="Full car warranty: duration (months): 36 or distance > (miles): 36,000"/> > <ITEM item_name="Warranty powertrain" > item_value="Powertrain warranty: duration (months): 36 or distance > (miles): 36,000"/> > <ITEM item_name="Warranty anti-corrosion" > item_value="Anticorrosion warranty: duration (months): 60 or distance > (miles): 100,000"/> > <ITEM item_name="Warranty roadside assistance" > item_value="Road-side assistance warranty: duration (months): 36 or > distance (miles): 36,000"/> > <ITEM item_name="Weights" item_value="Weights: curb > weight (lbs) 3,226"/> > <ITEM item_name="Wheels" item_value="Front and rear > steel wheels with 15 inch rim diam, 6 inch rim width and full wheel > covers"/> > <ITEM item_name="Spare wheel" item_value="Spacesaver > steel rim internal spare wheel"/> > <ITEM item_name="Console" item_value="Full dashboard > console with open storage box , full floor console with covered storage > box"/> > <ITEM item_name="Date introduced" item_value="Date > introduced 20,000,717 and 20,000,717"/> > </STANDARD_EQUIPMENT> > > </VEHICLE> > </VEHICLES> > </REPORT> > </REPORTS> > > -- > Marty Connelly > Victoria, B.C. > Canada > > > > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >