Geographical city MySQL database

</p> <p>CREATE TABLE `geo_city` (<br /> `CityId` int(10) unsigned NOT NULL default ‘0’,<br /> `CountryId` int(10) unsigned NOT NULL default ‘0’,<br /> `RegionId` int(10) unsigned NOT NULL default ‘0’,<br /> `City` varchar(100) NOT NULL default ”,<br /> `Latitude` float NOT NULL default ‘0’,<br /> `Longitude` float NOT NULL default ‘0’,<br /> `TimeZone` varchar(6) NOT NULL default ”,<br /> `DmaId` int(10) unsigned NOT NULL default ‘0’,<br /> `Code` varchar(5) NOT NULL default ”,<br /> PRIMARY KEY (`CityId`),<br /> KEY `CountryId` (`CountryId`),<br /> KEY `RegionId` (`RegionId`),<br /> KEY `City` (`City`)<br /> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=’Cities from GeoBytes’;</p> <p>—<br /> — Dumping data for table `geo_city`<br /> —</p> <p>INSERT INTO `geo_city` VALUES(27239, 254, 124, ‘Gray Mountain’, 35.8756, -111.412, ‘-07:00’, 753, ‘GMOU’);<br /> INSERT INTO `geo_city` VALUES(35786, 254, 148, ‘Rapelje’, 45.9932, -109.288, ‘-07:00’, 756, ‘RAPE’);<br /> INSERT INTO `geo_city` VALUES(4354, 122, 2329, ‘Tamana’, 32.917, 130.567, ‘+09:00’, 0, ‘TAMA’);<br /> INSERT INTO `geo_city` VALUES(13343, 254, 144, ‘Croswell’, 43.2651, -82.6467, ‘-05:00’, 505, ‘CROS’);<br /> INSERT INTO `geo_city` VALUES(39829, 254, 146, ‘Vardaman’, 33.9472, -89.1968, ‘-06:00’, 673, ‘VARD’);<br /> INSERT INTO `geo_city` VALUES(39933, 254, 144, ‘Vicksburg’, 42.1149, -85.4789, ‘-05:00’, 563, ‘VICK’);<br /> INSERT INTO `geo_city` VALUES(21609, 254, 137, ‘Bryant’, 41.9723, -90.3407, ‘-06:00’, 682, ‘BRYA’);<br /> INSERT INTO `geo_city` VALUES(29400, 254, 134, ‘Kellogg’, 47.7187, -116.088, ‘-08:00’, 881, ‘KELL’);<br /> INSERT INTO `geo_city` VALUES(38484, 254, 152, ‘Stockton’, 40.4365, -74.9753, ‘-05:00’, 501, ‘STOC’);<br /> INSERT INTO `geo_city` VALUES(7528, 254, 127, ‘Akron’, 40.1266, -103.261, ‘-07:00’, 751, ‘AKRO’);</p> <p>
Full File: uploads/geocities.txt