The base car, characteristics and photos

Affiliates: 3,33 $how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 51 last one 14.12.2017
Refunds: 0

Uploaded: 23.06.2014
Content: text 642 symbols

Seller

LicensedSoft information about the seller and his items
offlineAsk a question

Seller will give you a gift certificate in the amount of 50 RUB for a positive review of the product purchased..

Description

The base car, characteristics and photos The base car, characteristics and photos

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
Release.
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.

Actuality: 06.2014
Manufacturer: 210
Model: 2218 (5143 versions generations and modifications)
Modifications: 36162
Parameter group: 7 (body, engine, transmission, brake system, Expl. Indicators
Suspension, steering)
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)

Tables:
[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:
id
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
id
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
id
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.

Additional information

Preview of the content and structure of the database, please visit http://bases.boenskov.ru/demo/auto_ext
Part of this framework is the "Database car models and modifications" (http://www.plati.market/asp/pay.asp?idd=1725977) which does not contain information about the characteristics of the car and photos, and can be purchased separately.

*** Do not forget to leave a positive review on this product! It's important for me!
If the product to meet your needs, the reviews of the product you will not only thank me, but also to get away from me a little reward in the form of a gift certificate.

=== [Other options] ===
Pay attention to the new version of the database from 03.2015: (* database structure is different)
http://plati.market/asp/pay.asp?id_d=1897197 - Base cars
http://plati.market/asp/pay.asp?id_d=1897883 - Base of cars and characteristics

=== [MAYBE these bases you will be interested] ========
- Http://www.plati.market/asp/pay.asp?id_d=1725977 - Database car models and modifications
- Http://www.plati.market/asp/pay.asp?id_d=1751353 - Base car characteristics and photos
- Http://www.plati.market/asp/pay.asp?id_d=1753542 - The basis for the selection of tires and wheels for cars
- Http://www.plati.market/asp/pay.asp?id_d=1796458 - base of cities and regions of Russia + Crimea (2014) (VK)
- Http://www.plati.market/asp/pay.asp?id_d=1767568 - National Classification Currencies (RCC)
- Http://www.plati.market/asp/pay.asp?id_d=1747005 - codebook OKPD2 (introduced from 01.02.2014)

=== [MAKE] =========
If you own a website, blog or other information resource ITshnogo direction, you have the opportunity to earn extra income leaving the affiliate links on my database. As a reward you will get 20% from the first sale and + 5% for each subsequent (maximum 50%)

Feedback

2
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
Seller will give you a gift certificate in the amount of 50 RUB for a positive review of the product purchased..
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)