- Access to Resources 2801
- Active Advertising Systems 37
- Courses, Lessons 402
- Databases 1288
- Base of Trust sites 140
- Others 1148
- Design 1589
- Game Accounts 32112
- Gift Cards 1443
- Hosting 45
- Invites 313
- iTunes & App Store 1180
- Social Networks 2621
- Templates 168
- Miscellaneous 566
The base car, characteristics and photos
Refunds: 0
Uploaded: 23.06.2014
Content: text 642 symbols
Seller will give you a gift certificate in the amount of
Product description
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" ( https://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)
https://plati.market/asp/pay.asp?id_d=1897197 - Base cars
https://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
2Period | |||
1 month | 3 months | 12 months | |
0 | 0 | 0 | |
0 | 0 | 0 |