www.webdeveloper.com
Results 1 to 15 of 15

Thread: Car Make/Model database required for website

  1. #1
    Join Date
    Feb 2005
    Posts
    9

    Question Car Make/Model database required for website

    hi, i am developing a car related website in asp/sql and require a database of all car makes and models for the UK, same thing you see on insurance company online quote sites, car parts sites etc.

    know anywhere i can download one from? .xls, .csv file etc.

    any help appreciated, dont fancy inputing the data myself

  2. #2
    Join Date
    Nov 2003
    Location
    SA
    Posts
    261
    try google
    The best way to predict the future, is to invent it!

  3. #3
    Join Date
    Feb 2005
    Posts
    9
    Quote Originally Posted by slyfox
    try google
    always my first option, but no luck this time

  4. #4
    Join Date
    Nov 2003
    Location
    SA
    Posts
    261
    Search under ASP for whatever you want, they probably have already done it...

    www.hotscripts.com
    www.planetsourcecode.com

    good luck
    The best way to predict the future, is to invent it!

  5. #5
    Join Date
    Apr 2008
    Posts
    1

    Car Make / Model List

    Hi,


    Did you ever find a list of car makes / models? I am in the need of one for a new project.

    thanks

  6. #6
    Join Date
    May 2007
    Posts
    63

    car make/model

    Most insurance cos get the information from Experian, they hold the national registration database and offer a vehicle reg look up facility .. chargeable of course

  7. #7
    Join Date
    Jan 2009
    Posts
    2
    Try this website: www.llorban.com/cardb

    includes 1172 car models in mysql, excel and other formats.

  8. #8
    Join Date
    May 2007
    Posts
    63
    I have a list of 3,293 that it cost me a fair amount to acquire. Pm me if you would like to make an offer (yes I have IPR so can reproduce but will do so on the understanding that you will not distribute further). example entries

    ALFA ROMEO 147 1.6 (120 bhp)
    ALFA ROMEO 147 2.0
    ALFA ROMEO 147 1.9 JTDM
    ALFA ROMEO 147 1.9 JTDM 16v
    ALFA ROMEO GT 1.8 TS
    ALFA ROMEO GT 2.0 JTS
    ALFA ROMEO GT 3.2 V6 24v
    ALFA ROMEO GT 1.9 JTDM 16v


    ....

    VOLVO XC90 D5
    VOLVO XC90 D5 Geartronic
    VOLVO XC90 D5 Executive Geartronic & SE Sport
    VOLVO XC90 3.2 Geartronic
    VOLVO XC90 3.2 Executive Geartronic & SE Sport
    VOLVO XC90 V8 Geartronic
    VOLVO XC90 V8 Executive Geartronic & SE Sport

    I will not warranty it to be comrehensive as I beleive it was current as of 2008 so might be missing some newer or some very old models, was useful for my vehicle sites.

    Doh! just realised this is an old, old topic and the guy above was spamming with his first post, how foolish do I feel now! sorry mods
    Last edited by the-ferret; 01-13-2009 at 12:13 PM. Reason: cos i am stoopid

  9. #9
    Join Date
    Jan 2009
    Posts
    1

    Car Make & Model List

    Ferret- Does your list include a breakdown of vehicles and makes by year?

  10. #10
    Join Date
    May 2007
    Posts
    63
    I have a number of feeds. The consolidated list of manufacturer, model and derivative has 6,180 records but I have excluded date related data to avoid duplication. (This shortened list excludes details of tyre size and VIN numbers)

    I do however has feeds for make, model, derivative manufactured by year from 2001 - 2007. The source has been culled from my fleet emissions database hence it contains some date information, for example the data in 2006 vehicle list contains the following entries for the Vauxhall Vectra (partial set displayed else message is too long to post):

    VAUXHALL Vectra, MY2005 1.8i 16v 4 Door Saloon
    VAUXHALL Vectra, MY2005 1.8i 16v 5 Door Hatchback with close ratio gearbox
    VAUXHALL Vectra, MY2005 1.8i 16v 5 Door Hatchback with wide ratio gearbox
    VAUXHALL Vectra, MY2005 1.8i 16v 5 Door Estate
    VAUXHALL Vectra, MY2005 2.0i 16v Turbo 4 Door Saloon
    VAUXHALL Vectra, MY2005 2.0i 16v Turbo 5 Door Hatchback without 18"/19" tyre
    VAUXHALL Vectra, MY2005 2.0i 16v Turbo 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2005 2.0i 16v Turbo 5 Door Estate with 16"/17" tyre
    VAUXHALL Vectra, MY2005 2.0i 16v Turbo 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 4 Door Saloon
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 5 Door Hatchback with 16"/17" tyre
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 5 Door Hatchback with 18" tyre
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 5 Door Hatchback without 18"/19" tyre
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 5 Door Estate with 16"/17" tyre
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 5 Door Estate with 16"/17" tyre
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 5 Door Estate with 18" tyre
    VAUXHALL Vectra, MY2005 2.2i 16v Direct 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2005 3.2i V6 24v 4 Door Saloon
    VAUXHALL Vectra, MY2005 3.2i V6 24v 4 Door Saloon
    VAUXHALL Vectra, MY2005 3.2i V6 24v 5 Door Hatchback with 16"/17" tyre
    VAUXHALL Vectra, MY2005 3.2i V6 24v 5 Door Hatchback with 16"/17" tyre
    VAUXHALL Vectra, MY2005 3.2i V6 24v 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2005 3.2i V6 24v 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2005 3.2i V6 24v 5 Door Estate
    VAUXHALL Vectra, MY2005 3.2i V6 24v 5 Door Estate
    VAUXHALL Vectra, MY2005 1.9CDTi 8v 120PS 4 Door Saloon
    VAUXHALL Vectra, MY2005 1.9CDTi 8v 120PS 5 Door Hatchback without 18"/19" tyre
    VAUXHALL Vectra, MY2005 1.9CDTi 8v 120PS 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2005 1.9CDTi 8v 120PS 5 Door Estate without 18"/19" tyre
    VAUXHALL Vectra, MY2005 1.9CDTi 8v 120PS 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2005 1.9CDTi 16v 150PS 4 Door Saloon
    VAUXHALL Vectra, MY2005 1.9CDTi 16v 150PS 4 Door Saloon
    VAUXHALL Vectra, MY2005 1.9CDTi 16v 150PS 5 Door Hatchback without 18"/19" tyre
    VAUXHALL Vectra, MY2005 1.9CDTi 16v 150PS 5 Door Hatchback without 18"/19" tyre From VIN: W0L0ZCF6851035873

    The same feed in 2007

    VAUXHALL Vectra, MY2006 1.8i 16v 4 Door Saloon
    VAUXHALL Vectra, MY2006 1.8i 16v 5 Door Estate
    VAUXHALL Vectra, MY2006 1.8i 16v 5 Door Hatchback with 15"/16"/17" tyre and close ratio gear box
    VAUXHALL Vectra, MY2006 1.8i 16v 5 Door Hatchback with 15"/16"/17" tyre,wide ratio gear box and Z18XE engine
    VAUXHALL Vectra, MY2006 1.8i 16v 5 Door Hatchback with 15"/16"/17" tyre,wide ratio gear box and Z18XER engine
    VAUXHALL Vectra, MY2006 1.8i 16v 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2006 1.8i 16v VVT 4 Door Saloon
    VAUXHALL Vectra, MY2006 1.8i 16v VVT 5 Door Estate
    VAUXHALL Vectra, MY2006 1.8i 16v VVT 5 Door Hatchback
    VAUXHALL Vectra, MY2006 2.0i 16v Turbo 5 Door Estate with 16"/17" tyre
    VAUXHALL Vectra, MY2006 2.0i 16v Turbo 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2006 2.0i 16v Turbo 5 Door Hatchback with 16"/17" tyre
    VAUXHALL Vectra, MY2006 2.0i 16v Turbo 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 4 Door Saloon
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 4 Door Saloon
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 4 Door Saloon
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 5 Door Estate with 16"/17" tyre
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 5 Door Estate with 16"/17" tyre
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 5 Door Hatchback with 16"/17" tyre
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 5 Door Hatchback with 16"/17" tyre
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2006 2.2i 16v Direct 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2006 2.8i V6 24v Turbo 5 Door Estate
    VAUXHALL Vectra, MY2006 2.8i V6 24v Turbo 5 Door Estate VXR
    VAUXHALL Vectra, MY2006 2.8i V6 24v Turbo 5 Door Estate with 16"/17" tyre
    VAUXHALL Vectra, MY2006 2.8i V6 24v Turbo 5 Door Hatchback VXR
    VAUXHALL Vectra, MY2006 2.8i V6 24v Turbo 5 Door Hatchback with 16"/17" tyre
    VAUXHALL Vectra, MY2006 2.8i V6 24v Turbo 5 Door Hatchback with close ratio gearbox
    VAUXHALL Vectra, MY2006 2.8i V6 24v Turbo 5 Door Hatchback with wide ratio gearbox
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 4 Door Saloon
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 4 Door Saloon
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 5 Door Estate with 15"/16"/17" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 5 Door Estate without 18"/19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 5 Door Hatchback without 18"/19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 16v 150PS 5 Door Hatchback without 18"/19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 8v 120PS 4 Door Saloon
    VAUXHALL Vectra, MY2006 1.9CDTi 8v 120PS 5 Door Estate with 19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 8v 120PS 5 Door Estate without 18"/19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 8v 120PS 5 Door Hatchback with 19" tyre
    VAUXHALL Vectra, MY2006 1.9CDTi 8v 120PS 5 Door Hatchback without 18"/19" tyre
    VAUXHALL Vectra, MY2006 3.0CDTi V6 24v 5 Door Estate
    VAUXHALL Vectra, MY2006 3.0CDTi V6 24v 5 Door Estate
    VAUXHALL Vectra, MY2006 3.0CDTi V6 24v 5 Door Hatchback
    VAUXHALL Vectra, MY2006 3.0CDTi V6 24v 5 Door Hatchback
    VAUXHALL Vectra, MY2007 1.8i 16v VVT 4 Door Saloon
    VAUXHALL Vectra, MY2007 1.8i 16v VVT without 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 1.8i 16v VVT with 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 1.8i 16v VVT without 19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 1.8i 16v VVT with 19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.0i 16v Turbo +16/17" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 2.0i 16v Turbo +19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 2.0i 16v Turbo +16/17" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.0i 16v Turbo +19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.2i 16v Direct 4 Door Saloon
    VAUXHALL Vectra, MY2007 2.2i 16v Direct 4 Door Saloon
    VAUXHALL Vectra, MY2007 2.2i 16v Direct without 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 2.2i 16v Direct with 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 2.2i 16v Direct without 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 2.2i 16v Direct with 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 2.2i 16v Direct without 19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.2i 16v Direct with 19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.2i 16v Direct without 19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.2i 16v Direct with 19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.8i V6 24v Turbo +16/17" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 2.8i V6 24v Turbo +18/19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 2.8i V6 24v Turbo VXR 5 Door Estate
    VAUXHALL Vectra, MY2007 2.8i V6 24v Turbo +16/17" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.8i V6 24v Turbo +16/17/18" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 2.8i V6 24v Turbo VXR 5 Door Hatchback
    VAUXHALL Vectra, MY2007 1.9 CDTi 8v 120PS 4 Door Saloon
    VAUXHALL Vectra, MY2007 1.9 CDTi 8v 120PS without 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 1.9 CDTi 8v 120PS with 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 1.9 CDTi 8v 120PS without 19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 1.9 CDTi 8v 120PS with 19" tyre 5 Door Hatchback
    VAUXHALL Vectra, MY2007 1.9 CDTi 16v 150PS 4 Door Saloon
    VAUXHALL Vectra, MY2007 1.9 CDTi 16v 150PS 4 Door Saloon
    VAUXHALL Vectra, MY2007 1.9 CDTi 16v 150PS without 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 1.9 CDTi 16v 150PS with 19" tyre 5 Door Estate
    VAUXHALL Vectra, MY2007 1.9 CDTi 16v 150PS without 19" tyre 5 Door Estate

    Some manufacturer data has no year ref and some just refer to 'New' models, for example from the data for 2000 (prob not so New now!):

    VOLKSWAGEN New Polo Hatch 3 & 5 Door E 1.0 50 bhp
    VOLKSWAGEN New Polo Hatch 3 & 5 Door E 1.4 60 bhp

    In total 13,323 entries but I am sure that if you take all of the data then there will be an amount of de-duplicating needed.

    Hope that helps
    Graham

  11. #11
    Join Date
    Jan 2009
    Posts
    1
    Graham, is there a good way to contact you off the forum?

  12. #12
    Join Date
    May 2007
    Posts
    63
    Yep, a busy week so probably best to drop me an email, my personal mail address the-ferret@tiscali.co.uk
    Last edited by the-ferret; 01-21-2009 at 04:00 PM. Reason: .

  13. #13
    Join Date
    Jan 2009
    Posts
    1
    I have a year, make model database in excel, access and sql dump formats if you still need it. I could also use some help with coding to get my site using year make model dropdown menus if possible!

  14. #14
    Join Date
    May 2007
    Posts
    63
    Quote Originally Posted by warehousetire View Post
    I have a year, make model database in excel, access and sql dump formats if you still need it. I could also use some help with coding to get my site using year make model dropdown menus if possible!

    Happy to help with coding in return for a copy of your data (useful to compare to mine and check to see it is comprehensive). What are you looking for, quick and dirty php/mysql where selecting a vehicle make from dropdown reloads the page to select model or something a little more elegant maybe AJAX call to dynamically populate the model when the make selection changes?

    Drop me an emil the-ferret@tiscali.co.uk
    Last edited by the-ferret; 01-28-2009 at 03:34 AM. Reason: terrible typing mistooks

  15. #15
    Join Date
    Jul 2008
    Posts
    2
    Quote Originally Posted by the-ferret View Post
    Yep, a busy week so probably best to drop me an email, my personal mail address the-ferret@tiscali.co.uk
    Sorry to randomly barge in here...
    Im need the same list if possible. Hope u dont mind if i jump on the email address and speak with u offline aswel.
    Thought it would be better 2 contact u here 1st...

Thread Information

Users Browsing this Thread

There are currently 3 users browsing this thread. (0 members and 3 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles