- Access to Resources 2811
- Active Advertising Systems 37
- Courses, Lessons 403
- Databases 1149
- Base of Trust sites 138
- Others 1011
- Design 1586
- Game Accounts 32440
- Gift Cards 1469
- Hosting 45
- Invites 311
- iTunes & App Store 1229
- Social Networks 3604
- Templates 172
- Miscellaneous 566
GEO database, geo-information, SQL database of cities, countries, regions and areas of the world
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
0Period | |||
1 month | 3 months | 12 months | |
0 | 0 | 0 | |
0 | 0 | 0 |