473,509 Members | 2,763 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Car Models & Makes database

Hi all,

For a project I m working on I am looking for a database with all current
car-makes & models from post-WII till now.

With all the car websites around I am sure this information should be
available somewhere so that I can import it into my MySQL database, but I
simply can't find it.

Does anybody know where I can get my hands on "a" database with this
information so i can fill up my project database?

Thanks in advance.

Dimitri

//------------

Take the '.nospam' out of my emailaddress if you want to mail me.
Jul 19 '05 #1
6 15453
>> Does anybody know where I can get my hands on "a" database with
this information so i can fill up my project database? <<

In North America, a system is used that is far more stringent than the
ISO Standards but is "backward compatible." Here, the VIN is divided
into four sections:

The first three characters shall uniquely identify the manufacturer,
make and type of vehicle (with the same exception of manufacturers
that produce less than 500 vehicles). Effectively, this is the WMI.
There are indeed examples of manufacturers who have more than one WMI
that use the third character as a code for a vehicle category (for
instance bus or truck). Just as often however this is not the case;

The second section consists of five characters (VIN positions 4-8) and
identifies the attributes of the vehicle. For each type of vehicle
(passenger cars, MPV's, trucks, buses, trailers, motorcycles,
incomplete vehicles other than trailers), different information is
required. For cars, MPV's and light trucks it is required that the
first two characters of this section are alphabetic, the third and
fourth shall be numeric and the fifth alphanumeric. This section is
the VDS in ISO 3779 but there it comprises another position of the
VIN;

The third section consists of one character which is the check digit,
calculated over the other 16 characters of the VIN. This character can
be numeric or the letter X;
The fourth section consists of eight characters on positions 10-17 of
the VIN. The last five shall be numeric for cars, MPV's and light
trucks and the last four shall be numeric for all other vehicles. The
first character represents the vehicle model year, the second
character represents the plant of manufacture. The third through
eighth characters are a sequential production number (for
manufacturers producing more than 500 vehicles per year). For other
manufacturers, the sixth, seventh and eight positions represent the
sequential production number.

This section confirms to the VIS in ISO 3779.

A portion of the VIN is the WMI (World Manufacturer Identifier) Code.
SAE assigns this code to U.S. vehicle manufacturers. If you are a U.S.
manufacturer, please contact:

Cathy Douds
WMI Coordinator
SAE International
400 Commonwealth Drive
Warrendale, PA 15096-0001
724.772.8511
724.776.4026 - fax
do***@sae.org

Related Standards:

There are several standards available on VINs and WMIs:

SAE - J187 - Truck Vehicle Identification Numbers
SAE - J218 - Passenger Car Identification Terminology
SAE - J272 - Vehicle Identification Number Systems
SAE - J273 - Passenger Car Vehicle Identification Number System
SAE - J853 - Vehicle Identification Numbers
SAE - J1108 - Truck and Truck Tractor Vehicle Identification Number
Systems
SAE - J1044 - World Manufacturer Identifier
SAE - J1229 - Truck Identification Terminology
SAE - J1877 - Recommended Practice for Bar-Coded Vehicle
Identification Number Label
SAE J129 - Engine and Transmission Identification Numbers
ISO 3779 - Road vehicles - Vehicle identification number (VIN) Content
and structure
ISO 3780 - Road vehicles - World manufacturer identifier (WMI) code
Jul 19 '05 #2
>> Does anybody know where I can get my hands on "a" database with
this information so i can fill up my project database? <<

In North America, a system is used that is far more stringent than the
ISO Standards but is "backward compatible." Here, the VIN is divided
into four sections:

The first three characters shall uniquely identify the manufacturer,
make and type of vehicle (with the same exception of manufacturers
that produce less than 500 vehicles). Effectively, this is the WMI.
There are indeed examples of manufacturers who have more than one WMI
that use the third character as a code for a vehicle category (for
instance bus or truck). Just as often however this is not the case;

The second section consists of five characters (VIN positions 4-8) and
identifies the attributes of the vehicle. For each type of vehicle
(passenger cars, MPV's, trucks, buses, trailers, motorcycles,
incomplete vehicles other than trailers), different information is
required. For cars, MPV's and light trucks it is required that the
first two characters of this section are alphabetic, the third and
fourth shall be numeric and the fifth alphanumeric. This section is
the VDS in ISO 3779 but there it comprises another position of the
VIN;

The third section consists of one character which is the check digit,
calculated over the other 16 characters of the VIN. This character can
be numeric or the letter X;
The fourth section consists of eight characters on positions 10-17 of
the VIN. The last five shall be numeric for cars, MPV's and light
trucks and the last four shall be numeric for all other vehicles. The
first character represents the vehicle model year, the second
character represents the plant of manufacture. The third through
eighth characters are a sequential production number (for
manufacturers producing more than 500 vehicles per year). For other
manufacturers, the sixth, seventh and eight positions represent the
sequential production number.

This section confirms to the VIS in ISO 3779.

A portion of the VIN is the WMI (World Manufacturer Identifier) Code.
SAE assigns this code to U.S. vehicle manufacturers. If you are a U.S.
manufacturer, please contact:

Cathy Douds
WMI Coordinator
SAE International
400 Commonwealth Drive
Warrendale, PA 15096-0001
724.772.8511
724.776.4026 - fax
do***@sae.org

Related Standards:

There are several standards available on VINs and WMIs:

SAE - J187 - Truck Vehicle Identification Numbers
SAE - J218 - Passenger Car Identification Terminology
SAE - J272 - Vehicle Identification Number Systems
SAE - J273 - Passenger Car Vehicle Identification Number System
SAE - J853 - Vehicle Identification Numbers
SAE - J1108 - Truck and Truck Tractor Vehicle Identification Number
Systems
SAE - J1044 - World Manufacturer Identifier
SAE - J1229 - Truck Identification Terminology
SAE - J1877 - Recommended Practice for Bar-Coded Vehicle
Identification Number Label
SAE J129 - Engine and Transmission Identification Numbers
ISO 3779 - Road vehicles - Vehicle identification number (VIN) Content
and structure
ISO 3780 - Road vehicles - World manufacturer identifier (WMI) code
Jul 19 '05 #3
>> Does anybody know where I can get my hands on "a" database with
this information so i can fill up my project database? <<

In North America, a system is used that is far more stringent than the
ISO Standards but is "backward compatible." Here, the VIN is divided
into four sections:

The first three characters shall uniquely identify the manufacturer,
make and type of vehicle (with the same exception of manufacturers
that produce less than 500 vehicles). Effectively, this is the WMI.
There are indeed examples of manufacturers who have more than one WMI
that use the third character as a code for a vehicle category (for
instance bus or truck). Just as often however this is not the case;

The second section consists of five characters (VIN positions 4-8) and
identifies the attributes of the vehicle. For each type of vehicle
(passenger cars, MPV's, trucks, buses, trailers, motorcycles,
incomplete vehicles other than trailers), different information is
required. For cars, MPV's and light trucks it is required that the
first two characters of this section are alphabetic, the third and
fourth shall be numeric and the fifth alphanumeric. This section is
the VDS in ISO 3779 but there it comprises another position of the
VIN;

The third section consists of one character which is the check digit,
calculated over the other 16 characters of the VIN. This character can
be numeric or the letter X;
The fourth section consists of eight characters on positions 10-17 of
the VIN. The last five shall be numeric for cars, MPV's and light
trucks and the last four shall be numeric for all other vehicles. The
first character represents the vehicle model year, the second
character represents the plant of manufacture. The third through
eighth characters are a sequential production number (for
manufacturers producing more than 500 vehicles per year). For other
manufacturers, the sixth, seventh and eight positions represent the
sequential production number.

This section confirms to the VIS in ISO 3779.

A portion of the VIN is the WMI (World Manufacturer Identifier) Code.
SAE assigns this code to U.S. vehicle manufacturers. If you are a U.S.
manufacturer, please contact:

Cathy Douds
WMI Coordinator
SAE International
400 Commonwealth Drive
Warrendale, PA 15096-0001
724.772.8511
724.776.4026 - fax
do***@sae.org

Related Standards:

There are several standards available on VINs and WMIs:

SAE - J187 - Truck Vehicle Identification Numbers
SAE - J218 - Passenger Car Identification Terminology
SAE - J272 - Vehicle Identification Number Systems
SAE - J273 - Passenger Car Vehicle Identification Number System
SAE - J853 - Vehicle Identification Numbers
SAE - J1108 - Truck and Truck Tractor Vehicle Identification Number
Systems
SAE - J1044 - World Manufacturer Identifier
SAE - J1229 - Truck Identification Terminology
SAE - J1877 - Recommended Practice for Bar-Coded Vehicle
Identification Number Label
SAE J129 - Engine and Transmission Identification Numbers
ISO 3779 - Road vehicles - Vehicle identification number (VIN) Content
and structure
ISO 3780 - Road vehicles - World manufacturer identifier (WMI) code
Jul 19 '05 #4
try motorbase.com

"Dimitri Tholen" <dt*****@chello.nl.nospam> wrote in message
news:40*********************@news.xs4all.nl...
Hi all,

For a project I m working on I am looking for a database with all current
car-makes & models from post-WII till now.

With all the car websites around I am sure this information should be
available somewhere so that I can import it into my MySQL database, but I
simply can't find it.

Does anybody know where I can get my hands on "a" database with this
information so i can fill up my project database?

Thanks in advance.

Dimitri

//------------

Take the '.nospam' out of my emailaddress if you want to mail me.

Jul 19 '05 #5
try motorbase.com

"Dimitri Tholen" <dt*****@chello.nl.nospam> wrote in message
news:40*********************@news.xs4all.nl...
Hi all,

For a project I m working on I am looking for a database with all current
car-makes & models from post-WII till now.

With all the car websites around I am sure this information should be
available somewhere so that I can import it into my MySQL database, but I
simply can't find it.

Does anybody know where I can get my hands on "a" database with this
information so i can fill up my project database?

Thanks in advance.

Dimitri

//------------

Take the '.nospam' out of my emailaddress if you want to mail me.

Jul 19 '05 #6
try motorbase.com

"Dimitri Tholen" <dt*****@chello.nl.nospam> wrote in message
news:40*********************@news.xs4all.nl...
Hi all,

For a project I m working on I am looking for a database with all current
car-makes & models from post-WII till now.

With all the car websites around I am sure this information should be
available somewhere so that I can import it into my MySQL database, but I
simply can't find it.

Does anybody know where I can get my hands on "a" database with this
information so i can fill up my project database?

Thanks in advance.

Dimitri

//------------

Take the '.nospam' out of my emailaddress if you want to mail me.

Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
1685
by: Matt Fletcher | last post by:
Hi guys, I am trying to allow the models in a mysql database to be ordered by the site owner. I was thinking along the lines of a <SELECT> list containing the model names and Up and Down...
6
3931
by: mali_djuro | last post by:
Hi all, i used JDOM to create XML file. first, i get data from database and create Document object. in some data i have quotas, so it makes replacment in content of elements. for example: if i...
0
614
by: Dimitri Tholen | last post by:
Hi all, For a project I m working on I am looking for a database with all current car-makes & models from post-WII till now. With all the car websites around I am sure this information should...
1
1506
by: aaa | last post by:
Hi. Does anyone know any web site with common database models presented and explained. Database models like calendar, adressbook, storehouse... Thnx in advance
2
8272
by: lobrys | last post by:
hi I build a VB .NET application that makes file access, environnemet acess, database access, etc.... If I ran the app locally, everything works....(normal) If I copy the app on a server, and...
2
2461
by: slavi.marinov | last post by:
Hello all, I have a simple question on PHP and the way it handles strings. Let's say I have a database and a php script that communicates with the database. The database has some kind of...
15
1820
by: Bart | last post by:
Hi, I receive an utf8 character from a database, like 田 (Japanese Character, style: &#XXXXX). How can I visualize the Japanese character on my application? I have found the class...
4
1561
by: cover | last post by:
I have two distinctively different pieces of equipment that I'm trying to build a database for, each having 20 inputs which makes my mysql table 40 fields wide. Form one is for 'shakers' and...
17
3224
by: Fred Nelson | last post by:
Hi: I have written several web applications that obtain their connection strings from the web.config file. This is very easy to use and it makes it easy to move an app from development into...
3
1239
by: DKn | last post by:
Hi, For Wake-On-Lan enable/disable i downloaded the software for HP systems is HP CMI version is 1.00 A4 and for DELL systems is OMCI version is 7.1.382 A04. It is working fine. Can i know what...
0
7233
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7135
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7342
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7410
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
4729
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3215
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1570
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
774
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
440
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.