IMCDb Forum
General » New fields for this week-end
Category:  
« Previous topic
Reminder of the previous message
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 14/08/2006 @ 23:32:58, By antp
Even if the new mini is produced in UK, it was designed by BMW people I guess. I am not sure that it should be considered as an English car :confused:
Well, I will do the change, it is not a major problem anyway :grin:
By the way, is the latest Rolls-Royce still a UK car?

Latest Edition: 14/08/2006 @ 23:35:16


Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 00:37:23, By Alexander

By the way, is the latest Rolls-Royce still a UK car?

The final assembly is in Goodwood, Sussex. Therefore I would still call it British.
It gets more complicated with Bentley, as some models are (or shall be?) produced at the VW works in Dresden, next to the Phaeton. But on the web-side they make it clear that they are British: 'Our Vision'



Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 00:39:44, By Alexander
Final list for now:

Singer GB
Škoda CS/CZ if possible written Škoda not Skoda
Standard GB
Steyr A
Stutz USA
Sunbeam GB
Tatra CS/CZ
Taylor-Dunn USA
Tempo D
Thames GB
Trabant DDR should be Sachsenring, after 1990 D
Triumph GB I think we have no German Triumph
UAZ SU/RUS
Unic F
Ural SU/RUS
Vanden Plas GB
VELAM F should be written in capital letters
Wales & Edwards GB
Western Star USA & CDN
White-Freightliner USA
Walter CS
Yamaha J
ZiS SU
Zündapp D

I have edited about 300 makes and will leave the rest for other admins ... I shouldn't be so selfish ... :wink:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 00:46:54, By Alexander
One more for batch conversion:

For 'smart' not only the brand, but also the names are written in small letters. The only exception is 'Brabus', as this is a company name added to the car's name.

http://de.wikipedia.org/wiki/Smart_29
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 02:03:28, By firebird86
Antoine: The sub class listing "chassis Cab" should be listed under trucks not cars. I cant think of a single application for a chassis cab in a car catagory. :think:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 11:15:18, By antp
The final assembly is in Goodwood, Sussex. Therefore I would still call it British.
It gets more complicated with Bentley, as some models are (or shall be?) produced at the VW works in Dresden, next to the Phaeton. But on the web-side they make it clear that they are British: 'Our Vision'

For me the country of a make does not depend only on where it is built.
For me the Mexican VW Beetle are still a German car, as it was designed and first produced by VW Germany, and kept nearly unchanged for Mexico.

if possible written Škoda not Skoda

I'll see what I can do :wink:

Trabant DDR should be Sachsenring, after 1990 D

They still produced something after 1990 ? :confused:

VELAM F should be written in capital letters

Yes

Western Star USA & CDN

Two countries? Does it depend if it is a 1974 or a 1981? :lol:

I have edited about 300 makes and will leave the rest for other admins ... I shouldn't be so selfish ... :wink:

Thanks very much for your help :wink:

Latest Edition: 15/08/2006 @ 16:32:56
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 11:17:12, By antp

For 'smart' not only the brand, but also the names are written in small letters. The only exception is 'Brabus', as this is a company name added to the car's name.

For model name it depends on the cases. I already saw it with uppercase even in official documents I think. But you are right: usually they use all lowercase. I am not sure that a case change can be done through SQL (as strings are case-insensitive for searches), I'll test. In the worse case I can do "Fortwo" -> "For2" -> "fortwo" to force the change :grin:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 11:21:04, By antp
Antoine: The sub class listing "chassis Cab" should be listed under trucks not cars. I cant think of a single application for a chassis cab in a car catagory. :think:

The car/truck split is done with the european view of that (as the site was first made by French & Belgian members).
So you have to see "trucks" as "heavy trucks".
Here what we call a truck is something more than 3.5 ton, that requires a special driving license.
So in chassis-cab you find light tow trucks, small cube trucks (a cube posed on a chassis+cab), etc.
This was made because for us (F & B) these vehicles are in the same category than the cars, in weight, size and license requirement.
For the tax services, they are considered as "utility", but a hatchback without rear seats is considered the same.
I know that in USA the SUVs, pickups, etc. are considered as truck like is the semi-trailer tractor truck...
Heavy chassis-cab should be listed as "simply trucks". In French it is called "porteur" but I still have not found its real English equivalent.

Latest Edition: 15/08/2006 @ 11:22:15
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 14:33:38, By antp
Only 2513 vehicles left without country :grin:
To see these, two links:
http://www.imcdb.org/search.php?resultsStyle=asList&origin=
http://www.imcdb.org/vehicles.php?origin=
I also added links to easily see the car of "minorities", e.g. find the Chinese or Finnish cars, on the stats page:
http://www.imcdb.org/stats.php?type=countries
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 14:41:02, By antp
Alexander, here is a gift for you after your work: http://forum.imcdb.org/forum_topic-1023-4198.html
:grin:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 15:17:02, By antp
In the oval-letters countries list, China seems to be missing...
I wanted to use it for this one:
http://www.imcdb.org/vehicle.php?id=32389
Or do we consider this as a Chinese car rather than a German one, though it seems to be just a license-built Jetta and not another car derivated from it.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 15:17:49, By Alexander
Alexander, here is a gift for you after your work: http://forum.imcdb.org/forum_topic-1023-4198.html
:grin:


:love:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 15/08/2006 @ 20:19:56, By antp
I finished renaming the major makes, and included them in the "automatic origin" function ( www.imcdb.org/temp/auto-origin.txt )
Still 1549 vehicles without countries, but "only" 656 that are not "unknown" make (i.e. the 900 others are unknown vehicle anyway, and will get a country when they will get a make).
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
New fields for this week-end
Published 18/08/2006 @ 23:55:59, By Bebert
Pour moi, c'est ok! Si j'ai bien tout compris... :whistle:
Add Reply - Category:  
Sign In :: Sign Up :: Lost your login or your password?
KelCommunity.be :: © 2004-2024 Akretio SPRL :: Powered by Kelare