Data gurus, I need your help - Fuelly Forums

Android Users - Coming Soon! - Migrating from aCar 4.8 to 5.0

Reply
 
Thread Tools Display Modes
 
Old 02-25-2006, 11:23 AM   #1
Driving on E
 
Matt Timion's Avatar
 
Join Date: Sep 2005
Posts: 3,110
Country: United States
Data gurus, I need your help

Does anyone know where to get the EPA ratings for cars in ANY database format? Comma delimited is fine.

I'm going to try to add all of EPA ratings to the site so we can track who has hypermileage status, but I can't find a usable database anywhere.

A while ago someone posted a link to the EPA's downloadable database, but it was not easily usable.

If ANYONE can help, please let me know.

This will also enable you to compare your car to other drivers of the same car.
__________________

Matt Timion is offline   Reply With Quote
Old 02-25-2006, 11:40 AM   #2
Registered Member
 
krousdb's Avatar
 
Join Date: Feb 2006
Posts: 1,480
Country: United States
Location: Raleigh, NC
Re: Data gurus, I need your help

Quote:
Originally Posted by Matt Timion
Does anyone know where to get the EPA ratings for cars in ANY database format? Comma delimited is fine.

I'm going to try to add all of EPA ratings to the site so we can track who has hypermileage status, but I can't find a usable database anywhere.

A while ago someone posted a link to the EPA's downloadable database, but it was not easily usable.

If ANYONE can help, please let me know.

This will also enable you to compare your car to other drivers of the same car.
I tried to find the same thing awhile ago with no success. If you would like, I will volunteer to help build the database manually. Maybe if we all take one make, honda, acura, nissan, toyota etc... it wouldn't be such a big deal. Or..... Why not load them as we need them. Get the data for the cars that we have in the gaslog and add more as new cars are added. The EPA data goes back to 1985 so there is a lot out there.
__________________

__________________


krousdb is offline   Reply With Quote
Old 02-25-2006, 12:37 PM   #3
*shrug*
 
Join Date: Sep 2005
Posts: 6,195
Country: United States
Dibs on Honda!

Dibs on Honda!
SVOboy is offline   Reply With Quote
Old 02-25-2006, 12:40 PM   #4
Registered Member
 
krousdb's Avatar
 
Join Date: Feb 2006
Posts: 1,480
Country: United States
Location: Raleigh, NC
Re: Dibs on Honda!

Quote:
Originally Posted by SVOboy
Dibs on Honda!
Honda is the only fun one for me. Please don't make me do GM!
__________________


krousdb is offline   Reply With Quote
Old 02-25-2006, 12:52 PM   #5
*shrug*
 
Join Date: Sep 2005
Posts: 6,195
Country: United States
Fine then, dibs on Acura!

Fine then, dibs on Acura!
SVOboy is offline   Reply With Quote
Old 02-25-2006, 01:06 PM   #6
Driving on E
 
Matt Timion's Avatar
 
Join Date: Sep 2005
Posts: 3,110
Country: United States
Re: Data gurus, I need your help

Quote:
Originally Posted by krousdb
I tried to find the same thing awhile ago with no success. If you would like, I will volunteer to help build the database manually. Maybe if we all take one make, honda, acura, nissan, toyota etc... it wouldn't be such a big deal. Or..... Why not load them as we need them. Get the data for the cars that we have in the gaslog and add more as new cars are added. The EPA data goes back to 1985 so there is a lot out there.
If we all do it, I doubtit would take much longer than a week or two to get it all done.

I'm going on a road trip (MPG!!!) and will be back tomorrow. We can discuss it more then.
Matt Timion is offline   Reply With Quote
Old 02-25-2006, 05:44 PM   #7
Registered Member
 
MetroMPG's Avatar
 
Join Date: Dec 2005
Posts: 4,223
Country: United States
EPA 1978 -

EPA 1978 - 2006

http://www.fueleconomy.gov/feg/download.shtml

i opened the 1998 db and it looked ok to me.

i think rh77 pointed me to this link originally.
MetroMPG is offline   Reply With Quote
Old 02-26-2006, 05:27 PM   #8
Driving on E
 
Matt Timion's Avatar
 
Join Date: Sep 2005
Posts: 3,110
Country: United States
Re: EPA 1978 -

Quote:
Originally Posted by MetroMPG
EPA 1978 - 2006

http://www.fueleconomy.gov/feg/download.shtml

i opened the 1998 db and it looked ok to me.

i think rh77 pointed me to this link originally.
As it turns out 1998 was the first year the xcel files started looking normal. Take a look at the 1997 file. It's scary to say the least.

I guess that helps shave a few years off of our list though.
Matt Timion is offline   Reply With Quote
Old 02-26-2006, 07:44 PM   #9
Registered Member
 
MetroMPG's Avatar
 
Join Date: Dec 2005
Posts: 4,223
Country: United States
the 97 file isn't TOO bad.

the 97 file isn't TOO bad. just needs some massaging. i think it could be cleaned up in a few minutes.

it's not delimited and there are some unknown fields (e.g. numeric, in front of the manufacturer and a couple of other ones). but at least there's consistent whitespace between most of the columns.
MetroMPG is offline   Reply With Quote
Old 02-26-2006, 11:35 PM   #10
Driving on E
 
Matt Timion's Avatar
 
Join Date: Sep 2005
Posts: 3,110
Country: United States
Re: the 97 file isn't TOO bad.

Quote:
Originally Posted by MetroMPG
the 97 file isn't TOO bad. just needs some massaging. i think it could be cleaned up in a few minutes.

it's not delimited and there are some unknown fields (e.g. numeric, in front of the manufacturer and a couple of other ones). but at least there's consistent whitespace between most of the columns.
I experimented with these fields today and figured I could probably import the data based on a few constants, which would make the whole thing much easier.

That being said, I started to look at the data, and it's still messy. Even the most recent years have their problems. For example, there are 4 "civics" in 1999. Nothing is said about WHICH civic they are talking about (DX, LX, Si, hatchback, sedan, etc.)

So I think the best solution might be to let the users enter their vehicles themselves. most people know their own EPA ratings. We can slowly build the database as we need it. There is no need for us to slave over 28 years of data (often with over 700 entries for each year). It also doesn't help that each year the EPA changed it's data format.

What do you all think?
__________________

Matt Timion is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web site errors jeffreydj69 Fuelly Web Support and Community News 3 04-18-2013 02:21 AM
Multiple fillups per day - graph order Davek Fuelly Web Support and Community News 5 11-01-2010 01:19 AM
Still hoping for FB app/badge & iPhone app Icehawk Fuelly Web Support and Community News 3 10-15-2009 12:10 AM
Incorrect Milage Calcuatlion PatM Fuelly Web Support and Community News 4 07-17-2009 08:21 PM
Unburned Fuel rh77 General Maintenance and Repair 11 11-30-2005 09:01 PM

Powered by vBadvanced CMPS v3.2.3


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


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.