It contains data on passenger cars (including Russia) in
section marks (brands), models, generations, modifications of vehicles and their characteristics,
as well as photos of models of cars (some photos on the model).
For each modification of the data listed on the type of engine, gearbox and drive, as well as annual
Specifications are divided into groups (body, engine, transmission, etc.)
and each response echoed through the 2nd tables: auto_param_names (containing name
and units) and auto_params (containing values \u200b\u200bdirectly). This
to simplify the structure of the work with the characteristics.
The database includes characteristics such cars as the vehicle dimensions, weight, type of actuator, body type, engine capacity, tire options, and more. On average, about 30-40 on vehicle characteristics.
Images are presented for each brand and each model of car.
Model: 2218 (5143 versions generations and modifications)
Parameter group: 7 (body, engine, transmission, brake system, Expl. Indicators
Parameters auto: 1'380'316 (on average, 35-40 in the car)
Data format: Dump MySQL database in the form of SQL queries to create and populate the tables.
Pictures: 24906 photos (2.5 GB) (archive downloaded separately from the database)
Pay for the goods you receive 2 links to download:
1) archive with 2 dumps (sql), and a more detailed description of the structure (rtf) (10Mb)
- Auto.sql - table auto_brands, auto_models, auto_submodels, auto_modify
- Auto_ext.sql - table auto_param_groups, auto_param_names, auto_params
2) archive with photos of cars (2.5 GB)
Downloading is done at your choice from my website, or with Yandex.Disk OneDrive (SkyDrive)
(* Notify me in case of difficulties with downloading files)
[Auto_brands] - brand vehicles (fields id, name, url)
[Auto_models] - model cars (fields id, name, brand_id)
[Auto_submodels] - (not necessary) modification of the body and different generations of cars.
If the name field is empty, then for this model there is only one modification.
[Auto_modify] - modification of the vehicle. It contains fields:
name - information transmission, engine size and power.
brand_id, model_id, submodel_id - to communicate with auto_brands, auto_models, auto_submodels
longname - similarly to the field name, but it also contains information on the modifications
from the table auto_submodels (why is not auto_submodels
the necessary tables)
engine_type - engine type (gasoline / diesel / hybrid)
drive_type - drive (front, rear, complete)
release_from - the beginning of the year of release
release_to - the end of the year of release
url - used to form the address of the image (more in the included
Instructions to the archive)
[Auto_param_groups] - a group of parameters (body, engine mission) (fields id, name)
[Auto_param_names] - Available Specifications
group_id - Field Communication c auto_param_groups
name - the name of the characteristics (power, Width)
units - the unit of measurement (hp, mm, etc., or NULL, if not specified)
[Auto_params] - just do property values
param_id - communication with auto_param_names
group_id - communication with auto_param_groups
modify_id - communication with auto_modify
value - the property value
The base is designed to save time programmer to find relevant information
Filling the site and eliminates the need to parse the pages of other sites.