The World City Names Database with Latitude and Longitude record count is given below in thousands.
- Africa – 430K
- Arctic Region – 2K
- Asia – 590K
- Central America and the Caribbean – 75K
- Commonwealth of Independent States – 110K
- Europe – 617K
- Middle East – 248K
- North America – 209K
- Oceania – 37K
- South America – 149K
- South East Asia – 322K
- World Others – 1K
TOTAL – 2.79 Million
The data is available as sql dump file. You can download a sample database for the world city names from the download link above. The sql dump file is readily executable on MySQL query browser. The sample sql dump file code is given below.
INSERT INTO `Cities` VALUES (1, ‘AD’, ’06’, ‘aixas’, ‘Aixàs’, 42.4833333, 1.4666667);
INSERT INTO `Cities` VALUES (2, ‘AD’, ’06’, ‘aixirivali’, ‘Aixirivali’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (3, ‘AD’, ’06’, ‘aixirivall’, ‘Aixirivall’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (4, ‘AD’, ’06’, ‘aixirvall’, ‘Aixirvall’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (5, ‘AD’, ’06’, ‘aixovall’, ‘Aixovall’, 42.4666667, 1.4833333);
INSERT INTO `Cities` VALUES (6, ‘AD’, ’07’, ‘andorra’, ‘Andorra’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (7, ‘AD’, ’07’, ‘andorra la vella’, ‘Andorra la Vella’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (8, ‘AD’, ’07’, ‘andorra-vieille’, ‘Andorra-Vieille’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (9, ‘AD’, ’07’, ‘andorre’, ‘Andorre’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (10, ‘AD’, ’07’, ‘andorre-la-vieille’, ‘Andorre-la-Vieille’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (11, ‘AD’, ’07’, ‘andorre-vieille’, ‘Andorre-Vieille’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (12, ‘AD’, ’04’, ‘ansalonga’, ‘Ansalonga’, 42.5666667, 1.5166667);
INSERT INTO `Cities` VALUES (13, ‘AD’, ’05’, ‘anyos’, ‘Anyós’, 42.5333333, 1.5333333);
INSERT INTO `Cities` VALUES (14, ‘AD’, ’04’, ‘arans’, ‘Arans’, 42.5833333, 1.5166667);
INSERT INTO `Cities` VALUES (15, ‘AD’, ’04’, ‘arinsal’, ‘Arinsal’, 42.5666667, 1.4833333);
INSERT INTO `Cities` VALUES (16, ‘AD’, ’06’, ‘aubinya’, ‘Aubinyà’, 42.45, 1.5);
INSERT INTO `Cities` VALUES (17, ‘AD’, ’06’, ‘auvinya’, ‘Auvinya’, 42.45, 1.5);
INSERT INTO `Cities` VALUES (18, ‘AD’, ’06’, ‘bicisarri’, ‘Biçisarri’, 42.4833333, 1.4666667);
INSERT INTO `Cities` VALUES (19, ‘AD’, ’06’, ‘bixessarri’, ‘Bixessarri’, 42.4833333, 1.4666667);
INSERT INTO `Cities` VALUES (20, ‘AD’, ’06’, ‘bixisarri’, ‘Bixisarri’, 42.4833333, 1.4666667);
INSERT INTO `Cities` VALUES (21, ‘AD’, ’02’, ‘canillo’, ‘Canillo’, 42.5666667, 1.6);
INSERT INTO `Cities` VALUES (22, ‘AD’, ’03’, ‘casas vila’, ‘Casas Vila’, 42.5333333, 1.5666667);
INSERT INTO `Cities` VALUES (23, ‘AD’, ’06’, ‘certers’, ‘Certers’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (24, ‘AD’, ’06’, ‘certes’, ‘Certés’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (25, ‘AD’, ’06’, ‘eixirivall’, ‘Eixirivall’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (26, ‘AD’, ’04’, ‘el pui’, ‘El Pui’, 42.55, 1.5166667);
INSERT INTO `Cities` VALUES (27, ‘AD’, ’03’, ‘els bons’, ‘Els Bons’, 42.5333333, 1.5833333);
Data in the sample file is for demonstration only. Complete database is available in the full package. Please Download full package from the link below: world-city-names-database-with-latitude-longitude-p-117.html
You must be logged in to post a comment.