Google Answers Logo
View Question
 
Q: Automotive Information ( Answered,   0 Comments )
Question  
Subject: Automotive Information
Category: Sports and Recreation > Automotive
Asked by: juggernot-ga
List Price: $100.00
Posted: 10 Jan 2006 15:22 PST
Expires: 09 Feb 2006 15:22 PST
Question ID: 431754
I would like to get a published (good enough for government work)
source(s) of automobile manufacturers gross weight (or curb, etc) for
all passenger vehicles and light trucks (1 ton and less) sold in
america for the current year and previous years as far back as
reasonably available (10 years or so). I would prefer a source that
updates with each new model year. Include domestic and import vehicles
sold by franchised automobile dealers from Acura to Volvo as listed at
edmunds.com.

Request for Question Clarification by pafalafa-ga on 14 Jan 2006 14:18 PST
juggernot-ga,


The information is available, but it takes a bit of doing to extract it.  

In each model year, there are roughly 2,000 or more car make/model
combinations with various configurations, and various weights.

These data are all compiled by Uncle Sam, and made available on a
year-to-year basis.

For instance, the 2005 model year has almost exactly 2,500 entries. 
The list (which includes tons of information in addition to weight)
looks like this when just model and weight are listed:



NEON/SRT-4/SX 2.0	3000
NEON/SRT-4/SX 2.0	3000
NEON/SRT-4/SX 2.0	3000
NEON/SRT-4/SX 2.0	3000
STRATUS 4-DR	3500
STRATUS 4-DR	3500
WRANGLER/TJ 4WD	3625
WRANGLER/TJ 4WD	3625
SEBRING 4-DR	3625
SEBRING 4-DR	3625
SEBRING 4-DR	3625
SEBRING 4-DR	3625
SEBRING 4-DR	3625
SEBRING 4-DR	3625
SEBRING 4-DR	3750
SEBRING 4-DR	3750
WRANGLER/TJ 4WD	3875
WRANGLER/TJ 4WD	3875
NEON/SRT-4/SX 2.0	3250
NEON/SRT-4/SX 2.0	3250
GRAND CHEROKEE 4WD	5000
GRAND CHEROKEE 4WD	5000
LIBERTY/CHEROKEE 4WD	4250
LIBERTY/CHEROKEE 4WD	4250
TOWN & COUNTRY 2WD	4250
TOWN & COUNTRY 2WD	4250
TOWN & COUNTRY 2WD	4250
CARAVAN 2WD	4500
CARAVAN 2WD	4500
CARAVAN 2WD	4250
CARAVAN 2WD	4250
CARAVAN 2WD	4250
CARAVAN 2WD	4250
CARAVAN 2WD	4500
CARAVAN 2WD	4500
PT CRUISER	3500
PT CRUISER	3500
PT CRUISER	3500
PACIFICA 2WD	4750
PACIFICA 2WD	4750
PACIFICA 2WD	4750
PACIFICA 2WD	4750
PACIFICA 2WD	4750
PACIFICA 2WD	5000
PACIFICA 2WD	5000
PACIFICA AWD	5000
PACIFICA AWD	5000
CROSSFIRE ROADSTER	3375
CROSSFIRE ROADSTER	3375
CROSSFIRE ROADSTER	3375
CROSSFIRE ROADSTER	3375
CROSSFIRE ROADSTER	3625
CROSSFIRE ROADSTER	3625
PT CRUISER	3625
PT CRUISER	3625
PT CRUISER	3625
PT CRUISER	3625
PT CRUISER	3625
LIBERTY/CHEROKEE 4WD	4250
LIBERTY/CHEROKEE 4WD	4250
LIBERTY/CHEROKEE 4WD	4250
300C/SRT-8	4500
300C/SRT-8	4500
300C/SRT-8	4500
300C/SRT-8	4500

==========

The multiple listings for a model represent different configurations
(stick vs standard, for instance, or 2-wheel vs 4-wheel drive) which
sometimes changes the weight, sometimes not.


The information goes back at least to 1984, and probably further.


I CANNOT extract the information for you and present models and
weights...there is simply too many discrete spreadsheet files to make
this a manageable project for all the years involved.

However, I can certainly direct you to the source of the information,
and provide instructions for how to access it.


Would that meet your needs?


pafalafa-ga

Clarification of Question by juggernot-ga on 18 Jan 2006 17:17 PST
Yes, that would be very helpful. I have many questions, but seeing the
data structure will answer them.

Is this the only source you know of?

Does it come from the manufacturers? 

Thank you for your response!!!
Answer  
Subject: Re: Automotive Information
Answered By: pafalafa-ga on 18 Jan 2006 18:09 PST
 
juggernot-ga,


Thanks for getting back to me on this.


I must admit, this was an especially frustrating search.  I kept
coming across figures that made it clear that *somewhere* there
existed a database of makes/models/weights, but actually tracking it
down was tough.

Finally though, it turned out to be the databases maintained by the
Environmental Protection Agency, and used to determine gas mileage and
fuel efficiency.  Makes sense, I suppose, to use the weight of the
vehicle as one variable in determining how efficiently the vehicle
uses gasoline.


Anyway, the data are here:


http://www.epa.gov/otaq/tcldata.htm
Test Car List Data Files


and cover the current 2006 models, and extend back to 1984.  


These are comma-delimited files that can be opened up into a
spreadsheet, which makes manipulating the data a breeze.  The files
from recent years are straight downloads, while the earlier files are
zipped.

If you find you need any help in either unzipping the files, or
importing them into a spreadsheet, let me know, and I can walk you
through the process.



There are more than 50 column headers for each year's data -- the most
recent year looks like this:


yr	mfr	mfr name	bidx	vid	cfg	carline	car/truck	cid	police	rhp	ec1	ec2	ec3	ec4	ec5	evc	trns	drv	od
etw	cmp	axle	n/v	a/c	dhp	sil	prc	prp	tnum	fuel	C/H	avcd	wt	hc	co	co2	nox	pm	mpg	target-a	target-b
target-c	set-a	set-b	set-c	engine code	eng family	vpc	cstdwn



so you can see that there's quite a bit of information on each model,
which may or may not be of interest to you, depending on what you're
up to, I suppose.



Each column has a description as to what's in it, and -- where
relevant -- a set of codes.  For instance, the 'trns' column
description and codes are as follows:


==========
trns - transmission code

C4 - Manual 4-Speed (Creeper) (M-4)
M3 - Manual Three-Speed
M4 - Manual Four-Speed (No Creeper)
M5 - Manual Five-Speed
SA - Semi-Automatic
A3 - Automatic 3-Speed (No Lockup)
L3 - Lock-Up/Automatic/3-Speed
A4 - Automatic 4-Speed (No Lockup)
L4 - Lock-Up/Automatic/4-Speed
C5 - Manual 5-Speed (Creeper) (M-5)
S2 - Semi-Automatic Two Speed
S3 - Semi-Automatic Three Speed
S4 - Semi-Automatic Four Speed
S5 - Semi-Automatic Five Speed
AV - Automatic Variable Gear Ratios
M6 - Manual Six Speed
A5 - Automatic 5-Speed (No Lockup)
L5 - Lock-Up/Automatic/5-Speed
C6 - Manual 6-Speed (Creeper) (M-6)
A6 - Automatic 6-Speed (No Lockup)
S6 - Semi-Automatic Six Speed
==========


The full set of descriptions and codes can be found here:


http://www.epa.gov/otaq/cert/mpg/testcars/database/testCarListDefinitions.pdf
Fuel Economy Test Car List Database Files


which tells you, by the way, that the 'etw' column is the "equivalent
test weight" of the vehicle, which is government-speak for the weight
of the vehicle under supposedly real-world test conditions (you *said*
you were looking for good-enough-for-government data!).


I think, with that, you probably have everything you need in terms of
make/model/configuration weight data.


But as always, if there's anything else I can do for you, don't
hesitate to ask.  Just post a Request for Clarification, and I'm at
your service.


All the best,


pafalafa-ga


search strategy -- Google searches on:

vehicle weight statistics

curb weight site:gov

"equivalent test weight" site:gov

Request for Answer Clarification by juggernot-ga on 23 Jan 2006 09:37 PST
pafalafa

I am trying to capture the auto manufacturers curb weight they publish
for each vehicle configuration.

Can you look at the data structure and tell me how to convert the
weights listed back to what the manufacturer lists?

Thanx

Clarification of Answer by pafalafa-ga on 23 Jan 2006 11:21 PST
juggernot-ga,

The quick answer is that the you can get the curb weight by
subtracting 300 pounds from the equivalent test weight.

The more complex answer is that EPA applies slightly different
criteria to different classes of car, and as the vehicles get up to
truck-size, the weight factor might be somewhat different from 300
pounds.  But as a rule of thumb, I think you'll be pretty much on
target just by using the 300 pound figure.

To see the details on all this, check out:


http://a257.g.akamaitech.net/7/257/2422/20cot20031500/edocket.access.gpo.gov/cfr_2003/julqtr/40cfr86.129-00.htm
CONTROL OF EMISSIONS FROM NEW AND IN-USE HIGHWAY VEHICLES AND ENGINES
Road load power, test weight, and inertia weight class determination


In particular, search the page for "equivalent test weight", and
you'll find (about halfway into the document) a pretty detailed
explanation of the adjustments made to curb weight.

Let me know if there's anything else you need on this.


paf

Request for Answer Clarification by juggernot-ga on 25 Jan 2006 17:40 PST
pafalafa

Sorry to be elusive, but I need the weights the manufacturer lists as
curb weight, or gross weight because the application calculates a fee
(to the penny) based on the weight stated on the manufacturers
certificate of origin (MCO) or manufacturers statement of origin
(MSO).

Clarification of Answer by pafalafa-ga on 25 Jan 2006 18:36 PST
juggernot-ga,

No need to apologize, but I'm not sure I can get you anything more
precise than I've already presented.  I'm just not aware of there
being any other publicly-available source of vehicle weight data,
other than what I've already provided.

As I understand things, subtracting 300 pounds from the EPA weights
should get you to the curb weight for the passenger cars (the heavier
trucks are more complicated, though).  As noted in the EPA regulations
on the testing (which I linked to, above):


"...For light-duty vehicles and light light-duty trucks, test weight 
basis is loaded vehicle weight, which is the vehicle weight plus 300 
pounds..."



Subtracting the 300 pounds should get you to the unloaded vehicle
weight, which is what I understand as the curb weight.


Perhaps if you explained a bit more about why you need this
information -- particularly why you need it so to be so exacting --
then it would spark some thoughts about alternative sources of
information.

Otherwise, I'm afraid that what I've provided already is probably the
best I can do.  If it's not good enough, let me know, and I'll ask the
editors to withdraw my answer, in which case you should receive a full
refund.

All the best,

paf
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy