1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Need Car Makes and Models Database

Discussion in 'MySQL' started by fhirzall, Sep 23, 2006.

Thread Status:
Not open for further replies.
  1. joshribakoff

    joshribakoff Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #21
    Hey,

    At my website www.vehiclefits.com I just put up a list of Makes Models & Trims. I sell the lists for Make Model Year as well as Make Model Trim Year and can deliver in any formats desired.

    Josh
    SEMrush
     
    joshribakoff, Sep 29, 2009 IP
    SEMrush
  2. misiyuse

    misiyuse Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #22
    Go To http://www.autoauctionhelp.com/All_Cars_List_text.html

    May be it will help

    Good Luck
     
    misiyuse, Jul 29, 2010 IP
  3. tq17749

    tq17749 Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #23
    Hi, I was looking for a database of vehicles too and here's the one that I found that's free and very complete: http://yearmakemodeldatabase.com/
     
    tq17749, Sep 23, 2010 IP
  4. B@ts

    B@ts Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #24
    Check out www.thevehiclelist.com

    I bought this database - and it comes with dependent dropdowns too. Great price. I tried the free one you just posted - but its missing stuff and its only up to 2009.
     
    B@ts, Sep 28, 2010 IP
  5. Crazace2006

    Crazace2006 Active Member

    Messages:
    143
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #25
    Crazace2006, Oct 28, 2010 IP
  6. Idealws

    Idealws Greenhorn

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #26
    Hello,

    After taking some time to try and find a DB with Year, Make, Model and Trim I decided to create my own.

    The DB and script I have is all Years, Makes, Models and Trims (for those that had one) for years 1904-2012

    Here is the script that comes with it: http://www.carlistdb.com/demo/
    Feel free to test away and verify the data it is current as of today.

    You can purchase the above script and DB for a onetime fee of $99.

    To order use the following URL: https://www.idealws.com/billing/cart.php?a=add&pid=78

    We accept payment via PayPal, Visa, MC, Amex and Discover.

    Have any questions? Feel free to let me know.

    Regards,
    Ray
     
    Idealws, Jul 19, 2011 IP
  7. WireWheels

    WireWheels Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #27
    This MAY be exactly what I've been looking for. Can you give me some details about the db? Like what is it (Access, MySQL, etc), how is it licensed, am I allowed to modify it / add to it...
    Thanks!

    WireWheels
     
    WireWheels, Jul 19, 2011 IP
  8. Idealws

    Idealws Greenhorn

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #28
    WireWheels,

    The license is for your use and cannot be resold to others unless your buying a license for a client and selling that license to them. Basically one license one site. The data is in MySQL form via a SQL dump file. I can also provide it in a csv file if needed or excel if needed.
    We will provide new updated to the DB once every 6 months via our client area for you to download. The script files are coded in PHP and easy to edit to your liking.

    The DB is not encoded so you can add to it as you see fit. Here is an example of the data in the sql dump file:

    INSERT INTO `makesmodels` VALUES (12829, 1986, 'Ford', 'Aerostar', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12830, 1986, 'Ford', 'Bronco', '4WD');
    INSERT INTO `makesmodels` VALUES (12831, 1986, 'Ford', 'Bronco', 'Eddie Bauer 4WD');
    INSERT INTO `makesmodels` VALUES (12832, 1986, 'Ford', 'Bronco', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12833, 1986, 'Ford', 'Bronco II', '4WD');
    INSERT INTO `makesmodels` VALUES (12834, 1986, 'Ford', 'Bronco II', 'Eddie Bauer');
    INSERT INTO `makesmodels` VALUES (12835, 1986, 'Ford', 'Bronco II', 'Eddie Bauer 4WD');
    INSERT INTO `makesmodels` VALUES (12836, 1986, 'Ford', 'Bronco II', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12837, 1986, 'Ford', 'Club Wagon', 'E150');
    INSERT INTO `makesmodels` VALUES (12838, 1986, 'Ford', 'Club Wagon', 'E250');
    INSERT INTO `makesmodels` VALUES (12839, 1986, 'Ford', 'Club Wagon', 'E350 Super');
    INSERT INTO `makesmodels` VALUES (12840, 1986, 'Ford', 'Club Wagon', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12841, 1986, 'Ford', 'Crown Victoria', 'Country Squire');
    INSERT INTO `makesmodels` VALUES (12842, 1986, 'Ford', 'Crown Victoria', 'Country Squire LX');
    INSERT INTO `makesmodels` VALUES (12843, 1986, 'Ford', 'Crown Victoria', 'LX');
    INSERT INTO `makesmodels` VALUES (12844, 1986, 'Ford', 'Crown Victoria', 'S');
    INSERT INTO `makesmodels` VALUES (12845, 1986, 'Ford', 'Crown Victoria', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12846, 1986, 'Ford', 'E150', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12847, 1986, 'Ford', 'E250', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12848, 1986, 'Ford', 'E350', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12849, 1986, 'Ford', 'EXP', 'Luxury');
    INSERT INTO `makesmodels` VALUES (12850, 1986, 'Ford', 'EXP', 'Sport');
    INSERT INTO `makesmodels` VALUES (12851, 1986, 'Ford', 'EXP', 'Other/Don\'t Know');
    INSERT INTO `makesmodels` VALUES (12852, 1986, 'Ford', 'Escort', 'GT');
    INSERT INTO `makesmodels` VALUES (12853, 1986, 'Ford', 'Escort', 'L');
    INSERT INTO `makesmodels` VALUES (12854, 1986, 'Ford', 'Escort', 'LX');
    INSERT INTO `makesmodels` VALUES (12855, 1986, 'Ford', 'Escort', 'Pony');
    INSERT INTO `makesmodels` VALUES (12856, 1986, 'Ford', 'Escort', 'Other/Don\'t Know');

    There are 40,759 total records in the DB which was updated yesterday.

    Please let me know if there is anything else I can do for you.

    Regards,
    Ray
     
    Idealws, Jul 19, 2011 IP
  9. k4m1k4z3

    k4m1k4z3 Guest

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #29
    Try on page meta-info.appspot.com. You can find there list of popular car make with models in XML or JSON files.
     
    k4m1k4z3, Jul 25, 2011 IP
  10. WireWheels

    WireWheels Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #30
    Thanks Ray. What is the make and year range of the database?
     
    WireWheels, Aug 15, 2011 IP
  11. Idealws

    Idealws Greenhorn

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #31
    The year range is 1904-2012

    Here is a list of the makes:

    AC
    Acura
    Alfa Romeo
    Am General
    American Motors
    Aston Martin
    Auburn
    Audi
    Austin
    Austin-Healey
    Avanti Motors
    Bentley
    BMW
    Bugatti
    Buick
    Cadillac
    Checker
    Chevrolet
    Chrysler
    Citroen
    Daewoo
    Daihatsu
    Datsun
    Delahaye
    Delorean
    Desoto
    DeTomaso
    Dodge
    Eagle
    Edsel
    Essex
    Ferrari
    Fiat
    Fisker
    Ford
    Franklin
    Geo
    GMC
    Honda
    Hudson
    Hummer
    Hupmobile
    Hyundai
    Infiniti
    International
    Isuzu
    Jaguar
    Jeep
    Jensen
    Kaiser
    Kia
    Koenigsegg
    Lamborghini
    Lancia
    Land Rover
    LaSalle
    Lexus
    Lincoln
    Lotus
    Maserati
    Maybach
    Mazda
    Mercedes-Benz
    Mercury
    Merkur
    MG
    MINI
    Mitsubishi
    Morgan
    Morris
    Nash
    Nissan
    Oldsmobile
    Opel
    Packard
    Panoz
    Peugeot
    Plymouth
    Pontiac
    Porsche
    Qvale
    Renault
    Rolls-Royce
    Rover
    Saab
    Saleen
    Saturn
    Scion
    Smart
    Spyker
    Sterling
    Studebaker
    Subaru
    Sunbeam
    Suzuki
    Tesla
    THINK
    Toyota
    Triumph
    Volkswagen
    Volvo
    Willys
    Yugo

    Please let me know if there is anything else I can do for you.

    Regards,
    Ray
     
    Idealws, Aug 15, 2011 IP
  12. MancuZ28

    MancuZ28 Greenhorn

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    21
    #32
    I just started a project with this kind of thing in mind. I designed it to be an easy to use javascript API, so that with just a few lines of code you can create dependent year / make / model dropdowns, or browseable lists. Once you drill down to the model level you can also get many specs of the car as well.


    It's still pretty early on in development, but maybe it can help some people here. If you have any ideas about how it could be more useful, please let me know.


    http://www.carqueryapi.com/
     
    MancuZ28, Aug 24, 2011 IP
  13. mmerlinn

    mmerlinn Prominent Member

    Messages:
    2,988
    Likes Received:
    715
    Best Answers:
    7
    Trophy Points:
    320
    #33
    @mancu728

    Your list is incomplete. For example, you don't have a listing for a 1986 Aerostar.

    And the list view is unusable.

    Once you get in working correctly and fully populated, it should be a handy thing to have.
     
    mmerlinn, Aug 28, 2011 IP
  14. nbd007

    nbd007 Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #34
    Anyone have a tire size database
     
    nbd007, Sep 10, 2011 IP
  15. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #35
    Mancu, can you post the API spec? What do we call, with what data, to get what back?

    Oops, sorry. Missed your documentation menu item.
     
    Rukbat, Sep 10, 2011 IP
  16. andrew.k

    andrew.k Peon

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #36
    andrew.k, Oct 10, 2011 IP
  17. andrew.k

    andrew.k Peon

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #37
    andrew.k, Nov 3, 2011 IP
  18. tsweb

    tsweb Greenhorn

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #38
    ASP.Net Web Application and Database that is really helpful at: http://store.nmally.com/index.php?main_page=product_info&cPath=65&products_id=185
     
    tsweb, Apr 4, 2012 IP
  19. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #39
    tsweb, the OP wants the data, not a tool to create databases.
     
    Rukbat, Apr 4, 2012 IP
  20. tsweb

    tsweb Greenhorn

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #40
    Yes the data is included as a Microsoft T-SQL file ready for import / execution. Just informing the community of this ready to use solution!
     
    tsweb, Apr 4, 2012 IP
Thread Status:
Not open for further replies.