469,265 Members | 1,994 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,265 developers. It's quick & easy.

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 14887
>> 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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Matt Fletcher | last post: by
6 posts views Thread by mali_djuro | last post: by
reply views Thread by Dimitri Tholen | last post: by
1 post views Thread by aaa | last post: by
2 posts views Thread by slavi.marinov | last post: by
15 posts views Thread by Bart | last post: by
4 posts views Thread by cover | last post: by
17 posts views Thread by Fred Nelson | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.