Proposal: Use fueleconomy.gov API for transport database

[hyperdrive3]

Notes go here:

http://www.fueleconomy.gov/feg/ws/index.shtml

Can download current data in csv or xml format, very comprehensive fuel economy data on all range of vehicles.

EDIT: Decided to download the comprehensive csv file of all vehicles they have data on. Now I'll just have a feature in-app to search the CSV by car model and make, results show up in a scrolling list.

I'll store the data in a ArrayList or Map for fast access for later use.

Create another class to handle this.

User can add cars to a local sql database, this is the list that the user can choose from later when clicking a drop downlist on the action bar.

[hyperdrive3]

Okay, so the file is too big to process on a single thread, maybe break the file up?

Also I need to remove any electric vehicles from the list, as this is more for actual petroleum consumption.

• Remove any fields deemed irrelevant to the application, look up the website for detailed info on the fields.

[hyperdrive3]

Update: Split vehicle data into 5 CSV files, some rows are incorrect due to exporting errors, fix this later. For now I'm ignoring rows that don't have all the fields I need.

[hyperdrive3]

Decided to ignore broken rows.

[hyperdrive3]

Closing this. Considering another API completely if time permits.

[hyperdrive3]

TODO: Search for other API.