GEO database, geo-information, SQL database of cities, countries, regions and areas of the world

The sale of this product is suspended.

Try to search similar items from other sellers.

Sold: 3 last one 07.04.2012
Refunds: 0

Uploaded: 26.06.2008
Content: base_.rar 170,14 kB

Product description


GEO database, geo-information, SQL database of cities, countries, regions and areas of the world.
You can then import from SQL in any format: EXCEL, ACCESS, DB, XML, CSV, and others.

The structure of the database:

Table country ############ ############

country_id - the unique number of the country
country_rus - Russian name of the country
country_eng - the English name of the country

Table regions ############ ############

region_id - the unique number of the region
region_rus - Russian Region
region_eng - the English name of the region
country_id - id of the country that owns the region

TABLE cities ############ ############

city_id - the unique number of the city
city_rus - Russian city name
city_eng - the English name of the city
region_id - id district, which belongs to the city

cm. Example for PHP (sample.php), which implemented the use of this database.

Additional information

It does look like this:
-
- Table structure `cities`
-

CREATE TABLE `cities` (
`City_id` int (11) NOT NULL default '0'
`City_rus` varchar (255) NOT NULL default '',
`City_eng` varchar (255) NOT NULL default '',
`Region_id` int (11) NOT NULL default '0'
) TYPE = MyISAM;

-
- Dump the data in the table `cities`
-

INSERT INTO `cities` VALUES (1, 'Ballarat', 'Ballarat', 1);
INSERT INTO `cities` VALUES (2, 'Bendigo', 'Bendigo', 1);
INSERT INTO `cities` VALUES (3, 'Warrnambool', 'Warrnambool', 1);
INSERT INTO `cities` VALUES (4, 'Wodonga', 'Wodonga', 1);
INSERT INTO `cities` VALUES (5, 'Geelong', 'Geelong', 1);
INSERT INTO `cities` VALUES (6, 'Melton', 'Melton', 1);
INSERT INTO `cities` VALUES (7, 'Melbourne', 'Melbourne', 1);
INSERT INTO `cities` VALUES (8, 'Mildura', 'Mildura', 1);
INSERT INTO `cities` VALUES (9, 'Traralgon', 'Traralgon', 1);


AMERICA N
AMERICA N / Canada
AMERICA N / Canada / Alberta
AMERICA N / Canada / British Columbia
AMERICA N / Canada / Manitoba
AMERICA N / Canada / New Brunswick
AMERICA N / Canada / Newfoundland & Labrador
AMERICA N / Canada / Northwest Territories
AMERICA N / Canada / Nova Scotia
AMERICA N / Canada / Nunavut
AMERICA N / Canada / Ontario
AMERICA N / Canada / Prince Edward Island
AMERICA N / Canada / Quebec
AMERICA N / Canada / Saskatchewan
AMERICA N / Canada / Yukon Territory
AMERICA N / Mexico
AMERICA N / Mexico / Aguascalientes


After the purchase of the base city, visit the email. 30 MB have not got into the site. For 1-2 days send the link for download.

Feedback

0
Period
1 month 3 months 12 months
0 0 0
0 0 0
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.)

This website uses cookies to provide a more effective user experience. See our Cookie policy for details.