全球城市经纬度坐标sql

/* SQLyog v10.2 MySQL - 5.5.8-log ********************************************************************* */ /*!40101 SET NAMES utf8 */; create table `location` ( `id` int (11), `country` varchar (75), `city` varchar (120), `latitude` double , `longitude` float , `altitude` float ); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('1','Afghanistan','Kabul','34.5166667','69.1833344','1808.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('2','Afghanistan','Kandahar','31.6100000','65.6999969','1015.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('3','Afghanistan','Mazar-e Sharif','36.7069444','67.1122208','369.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('4','Afghanistan','Herat','34.3400000','62.1899986','927.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('5','Afghanistan','Jalalabad','34.4200000','70.4499969','573.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('6','Afghanistan','Konduz','36.7200000','68.8600006','394.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('7','Afghanistan','Ghazni','33.5535554','68.4268875','2175.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('8','Afghanistan','Balkh','36.7586111','66.8961105','328.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('9','Afghanistan','Baghlan','36.1200000','68.6999969','565.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('10','Afghanistan','Gardez','33.5900000','69.2200012','2279.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('11','Afghanistan','Khost','33.3380556','69.9202805','1178.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('12','Afghanistan','Khanabad','36.6800000','69.1100006','490.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('13','Afghanistan','Tashqorghan','36.6952778','67.6980591','460.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('14','Afghanistan','Taloqan','36.7360511','69.5345078','788.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('15','Afghanistan','Cool urhajo','34.2654452','67.3451614','2733.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('16','Afghanistan','Pol-e Khomri','35.9425000','68.7191696','832.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('17','Afghanistan','Sheberghan','36.6672222','65.7536087','362.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('18','Afghanistan','Charikar','35.0136110','69.1713867','1534.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('19','Afghanistan','Sar-e Pol','36.2155556','65.9363861','629.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('20','Afghanistan','Paghman','34.5875000','68.9533310','2276.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('21','Afghanistan','Samangan','36.2652778','68.0166702','960.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('22','Afghanistan','Nawab City','31.5800000','64.3600006','775.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('23','Afghanistan','Gereshk','31.8188889','64.5647202','844.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('24','Afghanistan','Farakh','32.3700000','62.1100006','653.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('25','Afghanistan','Feyzabad','37.1175000','70.5797195','1235.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('26','Afghanistan','Sindand','33.3000000','62.1399994','1071.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('27','Afghanistan','Andkhvoy','36.9525000','65.1236115','319.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('28','Afghanistan','Rostaq','37.1275000','69.8305588','1323.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('29','Afghanistan','Qaravol','37.2211111','68.7799988','327.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('30','Afghanistan','Nahrin','36.0652778','69.1338882','1156.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('31','Afghanistan','Baraki Barak','33.9675000','68.9486084','1937.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('32','Afghanistan','At Khvajeh','37.0841667','69.4805527','474.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('33','Afghanistan','Eslam Qal`eh','34.6666667','61.0666656','721.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('34','Afghanistan','Karokh','34.4791667','62.5869446','1309.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('35','Afghanistan','Mehtar Lam','34.6713889','70.2094421','768.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('36','Afghanistan','Kushk','33.2961111','61.9527779','1126.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('37','Afghanistan','Shahrag','34.1083333','64.3033371','2393.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('38','Afghanistan','Asmar','35.0300000','71.3499985','934.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('39','Afghanistan','Sang-e Charak','35.8497222','66.4369431','1547.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('40','Afghanistan','Khash','31.5291667','62.7924995','578.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('41','Afghanistan','Achin','34.1200000','70.6999969','997.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('42','Afghanistan','Jabal os Saraj','35.1183330','69.2377777','1575.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('43','Afghanistan','Qarqin','37.4127778','66.0472260','250.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('44','Afghanistan','Mirabad','30.4352778','61.8347206','499.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('45','Afghanistan','Zarghun Shahr','32.8472222','68.4458313','2114.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('46','Afghanistan','Sangin','32.0733333','64.8338852','892.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('47','Afghanistan','Panjab','34.3875000','67.0233307','2707.0'); insert into `location` (`id`, `country`, `city`, `latitude`, `longitude`, `altitude`) values('48','Afghanistan','Uruzgan','32.9200000','66.6299973','2010.0'); insert int