Mysql 地区经纬度 查询
&&& LBS 太火了，突然想考虑一下技术实现，附近的XX，网上有很多解决方案，今天只考虑使用Mysql数据库的实现，废话不多说，直接上sql语句：
select * from city where LAT & '34.7466'-1 and LAT & '34.7466'+1 and LNG & '113. and LNG & '113. order by ACOS(SIN(('34.7466' * 3.1415) / 180 ) *SIN((LAT * 3.1415) / 180 ) +COS(('34.7466' * 3.1415) / 180 ) * COS((LAT * 3.1415) / 180 ) *COS(('113.625368'* 3.1415) / 180 - (LNG * 3.1415) / 180 ) ) * 6380 asc limit 10
其中& '34.7466'& '113.625368' 是 河南省郑州市 的经纬度信息，查询结果如下图：
PS: 附上 city 的表结构数据（数据不全，根据具体需求进行补全即可）：
CREATE TABLE `city` (
`id` int(11) NOT NULL auto_increment,
`P_INDEX` varchar(200) NOT NULL,
`P_NAMES` varchar(200) NOT NULL,
`LAT` varchar(200) NOT NULL,
`LNG` varchar(200) NOT NULL,
PRIMARY KEY
(`id`)) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=397 ;-- -- 导出表中的数据 `city`-- INSERT INTO `city` VALUES (1, '110000', '北京市', '39.904214', '116.407413');INSERT INTO `city` VALUES (2, '120000', '天津市', '39.084158', '117.200983');INSERT INTO `city` VALUES (3, '130000', '河北省', '38.037057', '114.468665');INSERT INTO `city` VALUES (4, '140000', '山西省', '37.873376', '112.562569');INSERT INTO `city` VALUES (5, '150000', '内蒙古自治区', '40.817498', '111.765618');INSERT INTO `city` VALUES (6, '210000', '辽宁省', '41.835441', '123.42944');INSERT INTO `city` VALUES (7, '220000', '吉林省', '43.896082', '125.326065');INSERT INTO `city` VALUES (8, '310000', '上海市', '31.230393', '121.473704');INSERT INTO `city` VALUES (9, '460100', '海南省海口市', '20.030793', '110.328859');INSERT INTO `city` VALUES (10, '410700', '河南省新乡市', '35.303004', '113.9268');INSERT INTO `city` VALUES (11, '210900', '辽宁省阜新市', '42.021619', '121.670325');INSERT INTO `city` VALUES (12, '532300', '云南省楚雄彝族自治州', '25.045532', '101.528069');INSERT INTO `city` VALUES (13, '540100', '西藏自治区拉萨市', '29.645554', '91.140856');INSERT INTO `city` VALUES (14, '440900', '广东省茂名市', '21.662999', '110.925456');INSERT INTO `city` VALUES (15, '620300', '甘肃省金昌市', '38.520089', '102.188043');INSERT INTO `city` VALUES (16, '530900', '云南省临沧市', '23.877573', '100.079583');INSERT INTO `city` VALUES (17, '655900', '新疆维吾尔自治区农九师', '46.5161091', '83.6104305');INSERT INTO `city` VALUES (18, '210700', '辽宁省锦州市', '41.09512', '121.127004');INSERT INTO `city` VALUES (19, '622900', '甘肃省临夏回族自治州', '35.601182', '103.210539');INSERT INTO `city` VALUES (20, '430700', '湖南省常德市', '29.031673', '111.698497');INSERT INTO `city` VALUES (21, '411500', '河南省信阳市', '32.147015', '114.091289');INSERT INTO `city` VALUES (22, '141000', '山西省临汾市', '36.088067', '111.51888');INSERT INTO `city` VALUES (23, '640100', '宁夏回族自治区银川市', '38.487194', '106.230909');INSERT INTO `city` VALUES (24, '430100', '湖南省长沙市', '28.228209', '112.938814');INSERT INTO `city` VALUES (25, '370800', '山东省济宁市', '35.414921', '116.587099');INSERT INTO `city` VALUES (26, '450400', '广西壮族自治区梧州市', '23.47691', '111.27917');INSERT INTO `city` VALUES (27, '222400', '吉林省延边朝鲜族自治州', '42.891254', '129.508946');INSERT INTO `city` VALUES (28, '511300', '四川省南充市', '30.837793', '106.110698');INSERT INTO `city` VALUES (29, '652900', '新疆维吾尔自治区阿克苏地区', '41.168779', '80.260605');INSERT INTO `city` VALUES (30, '440300', '广东省深圳市', '22.543099', '114.057868');INSERT INTO `city` VALUES (31, '654300', '新疆维吾尔自治区阿勒泰地区', '47.844924', '88.141253');INSERT INTO `city` VALUES (32, '220800', '吉林省白城市', '45.619641', '122.839024');INSERT INTO `city` VALUES (33, '522400', '贵州省毕节地区', '27.302589', '105.283992');INSERT INTO `city` VALUES (34, '370600', '山东省烟台市', '37.463819', '121.447926');INSERT INTO `city` VALUES (35, '220200', '吉林省吉林市', '43.837883', '126.549572');INSERT INTO `city` VALUES (36, '130100', '河北省石家庄市', '38.042307', '114.51486');INSERT INTO `city` VALUES (37, '656300', '新疆维吾尔自治区农十三师', '42.8269581', '93.5462167');INSERT INTO `city` VALUES (38, '350100', '福建省福州市', '26.074508', '119.296494');INSERT INTO `city` VALUES (39, '621000', '甘肃省庆阳市', '35.738668', '107.632469');INSERT INTO `city` VALUES (40, '990000', '新疆建设兵团', '43.94764', '81.336727');INSERT INTO `city` VALUES (41, '610100', '陕西省西安市', '34.264987', '108.944269');INSERT INTO `city` VALUES (42, '211100', '辽宁省盘锦市', '41.119997', '122.070714');INSERT INTO `city` VALUES (43, '150600', '内蒙古自治区鄂尔多斯市', '39.608266', '109.781327');INSERT INTO `city` VALUES (44, '220300', '吉林省四平市', '43.16642', '124.350398');INSERT INTO `city` VALUES (45, '450600', '广西壮族自治区防城港市', '21.686114', '108.355638');INSERT INTO `city` VALUES (46, '610900', '陕西省安康市', '32.684781', '109.029303');INSERT INTO `city` VALUES (47, '540000', '西藏自治区', '29.647951', '91.117006');INSERT INTO `city` VALUES (48, '350400', '福建省三明市', '26.263407', '117.638678');INSERT INTO `city` VALUES (49, '371400', '山东省德州市', '37.434093', '116.357465');INSERT INTO `city` VALUES (50, '371700', '山东省菏泽市', '35.23375', '115.480656');INSERT INTO `city` VALUES (51, '510900', '四川省遂宁市', '30.532847', '105.592898');INSERT INTO `city` VALUES (52, '520100', '贵州省贵阳市', '26.647449', '106.630143');INSERT INTO `city` VALUES (53, '513200', '四川省阿坝藏族羌族自治州', '31.899413', '102.224653');INSERT INTO `city` VALUES (54, '411300', '河南省南阳市', '32.990614', '112.528345');INSERT INTO `city` VALUES (55, '610600', '陕西省延安市', '36.585424', '109.489635');INSERT INTO `city` VALUES (56, '451400', '广西壮族自治区崇左市', '22.377281', '107.364962');INSERT INTO `city` VALUES (57, '131100', '河北省衡水市', '37.735302', '115.69868');INSERT INTO `city` VALUES (58, '420000', '湖北省', '30.545861', '114.341921');INSERT INTO `city` VALUES (59, '130800', '河北省承德市', '40.954071', '117.962411');INSERT INTO `city` VALUES (60, '220100', '吉林省长春市', '43.817084', '125.323542');INSERT INTO `city` VALUES (61, '620800', '甘肃省平凉市', '35.542686', '106.665106');INSERT INTO `city` VALUES (62, '410000', '河南省', '34.76819', '113.687228');INSERT INTO `city` VALUES (63, '542600', '西藏自治区林芝地区', '29.649128', '94.36149');INSERT INTO `city` VALUES (64, '630100', '青海省西宁市', '36.617144', '101.778228');INSERT INTO `city` VALUES (65, '610300', '陕西省宝鸡市', '34.362053', '107.237539');INSERT INTO `city` VALUES (66, '152500', '内蒙古自治区锡林郭勒盟', '43.933454', '116.048222');INSERT INTO `city` VALUES (67, '510100', '四川省成都市', '30.658601', '104.064856');INSERT INTO `city` VALUES (68, '450100', '广西壮族自治区南宁市', '22.817642', '108.365631');INSERT INTO `city` VALUES (69, '210500', '辽宁省本溪市', '41.294176', '123.766485');INSERT INTO `city` VALUES (70, '310200', '上海市县', '31.112842', '121.381672');INSERT INTO `city` VALUES (71, '530100', '云南省昆明市', '25.037721', '102.722202');INSERT INTO `city` VALUES (72, '655500', '新疆维吾尔自治区农五师', '44.8898803', '82.0705609');INSERT INTO `city` VALUES (73, '430500', '湖南省邵阳市', '27.238893', '111.467791');INSERT INTO `city` VALUES (74, '820000', '澳门特别行政区', '22.198745', '113.543873');INSERT INTO `city` VALUES (75, '632600', '青海省果洛藏族自治州', '34.471675', '100.245027');INSERT INTO `city` VALUES (76, '411000', '河南省许昌市', '34.035506', '113.85264');INSERT INTO `city` VALUES (77, '211200', '辽宁省铁岭市', '42.22297', '123.726163');INSERT INTO `city` VALUES (78, '431200', '湖南省怀化市', '27.554978', '109.998488');INSERT INTO `city` VALUES (79, '430600', '湖南省岳阳市', '29.357104', '113.128958');INSERT INTO `city` VALUES (80, '542200', '西藏自治区山南地区', '29.237137', '91.773134');INSERT INTO `city` VALUES (81, '150900', '内蒙古自治区乌兰察布市', '40.994786', '113.132585');INSERT INTO `city` VALUES (82, '440200', '广东省韶关市', '24.810403', '113.597522');INSERT INTO `city` VALUES (83, '350000', '福建省', '26.099933', '119.296506');INSERT INTO `city` VALUES (84, '222500', '吉林省长白山管委会', '42.437637', '128.114674');INSERT INTO `city` VALUES (85, '130500', '河北省邢台市', '37.070589', '114.504844');INSERT INTO `city` VALUES (86, '371200', '山东省莱芜市', '36.213691', '117.676731');INSERT INTO `city` VALUES (87, '211000', '辽宁省辽阳市', '41.269493', '123.172838');INSERT INTO `city` VALUES (88, '512000', '四川省资阳市', '30.128901', '104.627636');INSERT INTO `city` VALUES (89, '532900', '云南省大理白族自治州', '25.606486', '100.267638');INSERT INTO `city` VALUES (90, '451000', '广西壮族自治区百色市', '23.902371', '106.618275');INSERT INTO `city` VALUES (91, '655200', '新疆维吾尔自治区农二师', '41.7573598', '86.1375676');INSERT INTO `city` VALUES (92, '140200', '山西省大同市', '40.076816', '113.300126');INSERT INTO `city` VALUES (93, '510800', '四川省广元市', '32.435435', '105.843357');INSERT INTO `city` VALUES (94, '656100', '新疆维吾尔自治区建工师', '43.783672', '87.638725');INSERT INTO `city` VALUES (95, '371100', '山东省日照市', '35.416377', '119.526888');INSERT INTO `city` VALUES (96, '520400', '贵州省安顺市', '26.253072', '105.947594');INSERT INTO `city` VALUES (97, '653100', '新疆维吾尔自治区喀什地区', '39.4704', '75.989755');INSERT INTO `city` VALUES (98, '632300', '青海省黄南藏族自治州', '35.519549', '102.015248');INSERT INTO `city` VALUES (99, '411700', '河南省驻马店市', '33.011529', '114.022298');INSERT INTO `city` VALUES (100, '450800', '广西壮族自治区贵港市', '23.111531', '109.598927');INSERT INTO `city` VALUES (101, '513300', '四川省甘孜藏族自治州', '30.04952', '101.962311');INSERT INTO `city` VALUES (102, '511600', '四川省广安市', '30.455962', '106.633212');INSERT INTO `city` VALUES (103, '340700', '安徽省铜陵市', '30.94453', '117.810841');INSERT INTO `city` VALUES (104, '130200', '河北省唐山市', '39.630476', '118.180407');INSERT INTO `city` VALUES (105, '510700', '四川省绵阳市', '31.46745', '104.679114');INSERT INTO `city` VALUES (106, '350600', '福建省漳州市', '24.512949', '117.647481');INSERT INTO `city` VALUES (107, '411400', '河南省商丘市', '34.414172', '115.65637');INSERT INTO `city` VALUES (108, '610800', '陕西省榆林市', '38.285342', '109.734556');INSERT INTO `city` VALUES (109, '150400', '内蒙古自治区赤峰市', '42.257817', '118.886856');INSERT INTO `city` VALUES (110, '430900', '湖南省益阳市', '28.55386', '112.35518');INSERT INTO `city` VALUES (111, '511800', '四川省雅安市', '29.980537', '103.013261');INSERT INTO `city` VALUES (112, '620500', '甘肃省天水市', '34.580862', '105.724947');INSERT INTO `city` VALUES (113, '510400', '四川省攀枝花市', '26.582347', '101.718637');INSERT INTO `city` VALUES (114, '654200', '新疆维吾尔自治区塔城地区', '46.745364', '82.980317');INSERT INTO `city` VALUES (115, '522300', '贵州省黔西南布依族苗族自治州', '25.087825', '104.906397');INSERT INTO `city` VALUES (116, '533100', '云南省德宏傣族景颇族自治州', '24.433353', '98.584895');INSERT INTO `city` VALUES (117, '210400', '辽宁省抚顺市', '41.880872', '123.957208');INSERT INTO `city` VALUES (118, '511700', '四川省达州市', '31.209572', '107.468023');INSERT INTO `city` VALUES (119, '130900', '河北省沧州市', '38.304477', '116.838835');INSERT INTO `city` VALUES (120, '440100', '广东省广州市', '23.129163', '113.264435');INSERT INTO `city` VALUES (121, '340800', '安徽省安庆市', '30.524895', '117.056857');INSERT INTO `city` VALUES (122, '421100', '湖北省黄冈市', '30.453906', '114.872316');INSERT INTO `city` VALUES (123, '130600', '河北省保定市', '38.873891', '115.464806');INSERT INTO `city` VALUES (124, '542500', '西藏自治区阿里地区', '32.501034', '80.105652');INSERT INTO `city` VALUES (125, '632800', '青海省海西蒙古族藏族自治州', '37.377139', '97.369752');INSERT INTO `city` VALUES (126, '210300', '辽宁省鞍山市', '41.108546', '122.994646');INSERT INTO `city` VALUES (127, '710000', '台湾省', '23.69781', '120.960515');INSERT INTO `city` VALUES (128, '140700', '山西省晋中市', '37.687024', '112.752695');INSERT INTO `city` VALUES (129, '620000', '甘肃省', '36.059421', '103.826308');INSERT INTO `city` VALUES (130, '210200', '辽宁省大连市', '38.914003', '121.614682');INSERT INTO `city` VALUES (131, '130400', '河北省邯郸市', '36.625604', '114.539085');INSERT INTO `city` VALUES (132, '620400', '甘肃省白银市', '36.544827', '104.137619');INSERT INTO `city` VALUES (133, '370000', '山东省', '36.668627', '117.020411');INSERT INTO `city` VALUES (134, '650200', '新疆维吾尔自治区克拉玛依市', '45.579889', '84.889207');INSERT INTO `city` VALUES (135, '340500', '安徽省马鞍山市', '31.670452', '118.50676');INSERT INTO `city` VALUES (136, '220700', '吉林省松原市', '45.141789', '124.825118');INSERT INTO `city` VALUES (137, '420100', '湖北省武汉市', '30.593087', '114.305357');INSERT INTO `city` VALUES (138, '652200', '新疆维吾尔自治区哈密地区', '42.818501', '93.514917');INSERT INTO `city` VALUES (139, '640200', '宁夏回族自治区石嘴山市', '38.984346', '106.383047');INSERT INTO `city` VALUES (140, '410400', '河南省平顶山市', '33.76619', '113.192814');INSERT INTO `city` VALUES (141, '533400', '云南省迪庆藏族自治州', '27.818882', '99.702234');INSERT INTO `city` VALUES (142, '341000', '安徽省黄山市', '29.714683', '118.337476');INSERT INTO `city` VALUES (143, '370900', '山东省泰安市', '36.200252', '117.087614');INSERT INTO `city` VALUES (144, '350500', '福建省泉州市', '24.907574', '118.586812');INSERT INTO `city` VALUES (145, '370300', '山东省淄博市', '36.813497', '118.055007');INSERT INTO `city` VALUES (146, '340100', '安徽省合肥市', '31.821448', '117.227271');INSERT INTO `city` VALUES (147, '532800', '云南省西双版纳傣族自治州', '22.008193', '100.797353');INSERT INTO `city` VALUES (148, '140100', '山西省太原市', '37.870662', '112.550619');INSERT INTO `city` VALUES (149, '656200', '新疆维吾尔自治区农十二师', '43.913509', '87.537902');INSERT INTO `city` VALUES (150, '370400', '山东省枣庄市', '34.810488', '117.323725');INSERT INTO `city` VALUES (151, '140400', '山西省长治市', '36.195386', '113.116255');INSERT INTO `city` VALUES (152, '210100', '辽宁省沈阳市', '41.80572', '123.43147');INSERT INTO `city` VALUES (153, '632500', '青海省海南藏族自治州', '36.286438', '100.620373');INSERT INTO `city` VALUES (154, '640000', '宁夏回族自治区', '38.471318', '106.258754');INSERT INTO `city` VALUES (155, '341400', '安徽省巢湖市', '31.597853', '117.864722');INSERT INTO `city` VALUES (156, '140500', '山西省晋城市', '35.49087', '112.851768');INSERT INTO `city` VALUES (157, '152200', '内蒙古自治区兴安盟', '46.077561', '122.067042');INSERT INTO `city` VALUES (158, '530000', '云南省', '25.045359', '102.709812');INSERT INTO `city` VALUES (159, '430200', '湖南省株洲市', '27.827827', '113.133775');INSERT INTO `city` VALUES (160, '141100', '山西省吕梁市', '37.518314', '111.144319');INSERT INTO `city` VALUES (161, '511500', '四川省宜宾市', '28.751812', '104.643382');INSERT INTO `city` VALUES (162, '371600', '山东省滨州市', '37.38199', '117.970703');INSERT INTO `city` VALUES (163, '513400', '四川省凉山彝族自治州', '27.881611', '102.267335');INSERT INTO `city` VALUES (164, '640400', '宁夏回族自治区固原市', '36.015855', '106.24261');INSERT INTO `city` VALUES (165, '211400', '辽宁省葫芦岛市', '40.711052', '120.836932');INSERT INTO `city` VALUES (166, '510500', '四川省泸州市', '28.87182', '105.442347');INSERT INTO `city` VALUES (167, '210800', '辽宁省营口市', '40.667012', '122.235418');INSERT INTO `city` VALUES (168, '640500', '宁夏回族自治区中卫市', '37.516892', '105.173837');INSERT INTO `city` VALUES (169, '530800', '云南省普洱市', '22.777765', '100.970152');INSERT INTO `city` VALUES (170, '420700', '湖北省鄂州市', '30.39194', '114.894843');INSERT INTO `city` VALUES (171, '620700', '甘肃省张掖市', '38.925646', '100.449822');INSERT INTO `city` VALUES (172, '152900', '内蒙古自治区阿拉善盟', '38.851892', '105.728969');INSERT INTO `city` VALUES (173, '440000', '广东省', '23.132191', '113.266531');INSERT INTO `city` VALUES (174, '411200', '河南省三门峡市', '34.772424', '111.20023');INSERT INTO `city` VALUES (175, '656400', '新疆维吾尔自治区农十四师', '37.21247', '79.287642');INSERT INTO `city` VALUES (176, '655800', '新疆维吾尔自治区农八师', '44.306119', '86.080497');INSERT INTO `city` VALUES (177, '610000', '陕西省', '34.265472', '108.954239');INSERT INTO `city` VALUES (178, '654000', '新疆维吾尔自治区伊犁哈萨克自治州', '43.916862', '81.324096');INSERT INTO `city` VALUES (179, '420900', '湖北省孝感市', '30.924568', '113.916903');INSERT INTO `city` VALUES (180, '140600', '山西省朔州市', '39.331595', '112.432825');INSERT INTO `city` VALUES (181, '411100', '河南省漯河市', '33.581413', '114.016539');INSERT INTO `city` VALUES (182, '150100', '内蒙古自治区呼和浩特市', '40.84231', '111.748847');INSERT INTO `city` VALUES (183, '420300', '湖北省十堰市', '32.629397', '110.797991');INSERT INTO `city` VALUES (184, '442000', '广东省中山市', '22.516686', '113.392795');INSERT INTO `city` VALUES (185, '441200', '广东省肇庆市', '23.047192', '112.465091');INSERT INTO `city` VALUES (186, '441500', '广东省汕尾市', '22.786211', '115.375279');INSERT INTO `city` VALUES (187, '370200', '山东省青岛市', '36.06722', '120.382504');INSERT INTO `city` VALUES (188, '150300', '内蒙古自治区乌海市', '39.655024', '106.794205');INSERT INTO `city` VALUES (189, '420500', '湖北省宜昌市', '30.691967', '111.286471');INSERT INTO `city` VALUES (190, '652300', '新疆维吾尔自治区昌吉回族自治州', '44.011183', '87.308225');INSERT INTO `city` VALUES (191, '611000', '陕西省商洛市', '33.870422', '109.940477');INSERT INTO `city` VALUES (192, '655300', '新疆维吾尔自治区农三师', '41.3666667', '79.9666667');INSERT INTO `city` VALUES (193, '410300', '河南省洛阳市', '34.618452', '112.45429');INSERT INTO `city` VALUES (194, '659000', '新疆维吾尔自治区省直辖行政单位', '43.793028', '87.627812');INSERT INTO `city` VALUES (195, '310100', '上海市市辖区', '31.230393', '121.473704');INSERT INTO `city` VALUES (196, '460000', '海南省', '20.017378', '110.349229');INSERT INTO `city` VALUES (197, '350700', '福建省南平市', '26.641769', '118.177708');INSERT INTO `city` VALUES (198, '810000', '香港特别行政区', '22.396428', '114.109497');INSERT INTO `city` VALUES (199, '130700', '河北省张家口市', '40.824418', '114.887543');INSERT INTO `city` VALUES (200, '469000', '海南省省直辖县级行政单位', '20.017378', '110.349229');INSERT INTO `city` VALUES (201, '530400', '云南省玉溪市', '24.352036', '102.546543');INSERT INTO `city` VALUES (202, '371500', '山东省聊城市', '36.456704', '115.985371');INSERT INTO `city` VALUES (203, '621100', '甘肃省定西市', '35.580623', '104.626278');INSERT INTO `city` VALUES (204, '653000', '新疆维吾尔自治区克孜勒苏柯尔克孜自治州', '39.714556', '76.167644');INSERT INTO `city` VALUES (205, '441600', '广东省河源市', '23.743538', '114.700447');INSERT INTO `city` VALUES (206, '450200', '广西壮族自治区柳州市', '24.325502', '109.415953');INSERT INTO `city` VALUES (207, '210600', '辽宁省丹东市', '40.127344', '124.384913');INSERT INTO `city` VALUES (208, '431000', '湖南省郴州市', '25.77051', '113.014718');INSERT INTO `city` VALUES (209, '433100', '湖南省湘西土家族苗族自治州', '28.311948', '109.739172');INSERT INTO `city` VALUES (210, '520200', '贵州省六盘水市', '26.592666', '104.830359');INSERT INTO `city` VALUES (211, '350200', '福建省厦门市', '24.479836', '118.08942');INSERT INTO `city` VALUES (212, '656000', '新疆维吾尔自治区农十师', '47.35376', '87.828299');INSERT INTO `city` VALUES (213, '450700', '广西壮族自治区钦州市', '21.980968', '108.654543');INSERT INTO `city` VALUES (214, '460200', '海南省三亚市', '18.252847', '109.511909');INSERT INTO `city` VALUES (215, '220500', '吉林省通化市', '41.728401', '125.939697');INSERT INTO `city` VALUES (216, '120100', '天津市市辖区', '39.084158', '117.200983');INSERT INTO `city` VALUES (217, '445200', '广东省揭阳市', '23.549993', '116.372831');INSERT INTO `city` VALUES (218, '520000', '贵州省', '26.598026', '106.707116');INSERT INTO `city` VALUES (219, '520300', '贵州省遵义市', '27.725654', '106.927389');INSERT INTO `city` VALUES (220, '370100', '山东省济南市', '36.665282', '116.994917');INSERT INTO `city` VALUES (221, '421200', '湖北省咸宁市', '29.841443', '114.322492');INSERT INTO `city` VALUES (222, '522200', '贵州省铜仁地区', '27.731515', '109.189598');INSERT INTO `city` VALUES (223, '510600', '四川省德阳市', '31.126856', '104.398021');INSERT INTO `city` VALUES (224, '441400', '广东省梅州市', '24.288384', '116.122469');INSERT INTO `city` VALUES (225, '655100', '新疆维吾尔自治区农一师', '41.170146', '80.263915');INSERT INTO `city` VALUES (226, '232700', '黑龙江省大兴安岭地区', '52.335206', '124.711081');INSERT INTO `city` VALUES (227, '530500', '云南省保山市', '25.112065', '99.161471');INSERT INTO `city` VALUES (228, '430800', '湖南省张家界市', '29.117096', '110.479191');INSERT INTO `city` VALUES (229, '510300', '四川省自贡市', '29.33903', '104.778442');INSERT INTO `city` VALUES (230, '331000', '浙江省台州市', '28.656386', '121.420757');INSERT INTO `city` VALUES (231, '330400', '浙江省嘉兴市', '30.753924', '120.758543');INSERT INTO `city` VALUES (232, '411600', '河南省周口市', '33.618686', '114.657616');INSERT INTO `city` VALUES (233, '331100', '浙江省丽水市', '28.46763', '119.922796');INSERT INTO `city` VALUES (234, '430400', '湖南省衡阳市', '26.89384', '112.5719');INSERT INTO `city` VALUES (235, '321200', '江苏省泰州市', '32.455778', '119.923116');INSERT INTO `city` VALUES (236, '410800', '河南省焦作市', '35.215893', '113.241823');INSERT INTO `city` VALUES (237, '341100', '安徽省滁州市', '32.301556', '118.317107');INSERT INTO `city` VALUES (238, '530600', '云南省昭通市', '27.338257', '103.717465');INSERT INTO `city` VALUES (239, '610700', '陕西省汉中市', '33.06748', '107.023323');INSERT INTO `city` VALUES (240, '532600', '云南省文山壮族苗族自治州', '23.368817', '104.251045');INSERT INTO `city` VALUES (241, '630000', '青海省', '36.620901', '101.780199');INSERT INTO `city` VALUES (242, '441900', '广东省东莞市', '23.020536', '113.751765');INSERT INTO `city` VALUES (243, '410900', '河南省濮阳市', '35.762141', '115.02933');INSERT INTO `city` VALUES (244, '370700', '山东省潍坊市', '36.706691', '119.16193');INSERT INTO `city` VALUES (245, '620900', '甘肃省酒泉市', '39.732488', '98.494411');INSERT INTO `city` VALUES (246, '522600', '贵州省黔东南苗族侗族自治州', '26.58355', '107.982828');INSERT INTO `city` VALUES (247, '140800', '山西省运城市', '35.026372', '111.007324');INSERT INTO `city` VALUES (248, '140900', '山西省忻州市', '38.416663', '112.734174');INSERT INTO `city` VALUES (249, '341300', '安徽省宿州市', '33.639394', '116.985301');INSERT INTO `city` VALUES (250, '632200', '青海省海北藏族自治州', '36.954273', '100.900931');INSERT INTO `city` VALUES (251, '341600', '安徽省亳州市', '33.844582', '115.778676');INSERT INTO `city` VALUES (252, '150700', '内蒙古自治区呼伦贝尔市', '49.211572', '119.765739');INSERT INTO `city` VALUES (253, '451300', '广西壮族自治区来宾市', '23.750312', '109.22146');INSERT INTO `city` VALUES (254, '211300', '辽宁省朝阳市', '41.573734', '120.450372');INSERT INTO `city` VALUES (255, '511400', '四川省眉山市', '30.07544', '103.848538');INSERT INTO `city` VALUES (256, '370500', '山东省东营市', '37.434751', '118.674767');INSERT INTO `city` VALUES (257, '431100', '湖南省永州市', '26.420394', '111.613445');INSERT INTO `city` VALUES (258, '420800', '湖北省荆门市', '31.035423', '112.199265');INSERT INTO `city` VALUES (259, '341800', '安徽省宣城市', '30.940718', '118.758816');INSERT INTO `city` VALUES (260, '431300', '湖南省娄底市', '27.701693', '111.996001');INSERT INTO `city` VALUES (261, '220400', '吉林省辽源市', '42.887918', '125.143532');INSERT INTO `city` VALUES (262, '652700', '新疆维吾尔自治区博尔塔拉蒙古自治州', '44.905588', '82.066159');INSERT INTO `city` VALUES (263, '652100', '新疆维吾尔自治区吐鲁番地区', '42.951384', '89.189655');INSERT INTO `city` VALUES (264, '130300', '河北省秦皇岛市', '39.935377', '119.600492');INSERT INTO `city` VALUES (265, '530300', '云南省曲靖市', '25.49001', '103.796167');INSERT INTO `city` VALUES (266, '610500', '陕西省渭南市', '34.499995', '109.509786');INSERT INTO `city` VALUES (267, '350800', '福建省龙岩市', '25.075129', '117.017705');INSERT INTO `city` VALUES (268, '450000', '广西壮族自治区', '22.815478', '108.327546');INSERT INTO `city` VALUES (269, '653200', '新疆维吾尔自治区和田地区', '37.114157', '79.922211');INSERT INTO `city` VALUES (270, '410600', '河南省鹤壁市', '35.747225', '114.297273');INSERT INTO `city` VALUES (271, '445100', '广东省潮州市', '23.656972', '116.622597');INSERT INTO `city` VALUES (272, '110200', '北京市县', '39.9061151', '116.6505296');INSERT INTO `city` VALUES (273, '445300', '广东省云浮市', '22.915094', '112.044491');INSERT INTO `city` VALUES (274, '410200', '河南省开封市', '34.797239', '114.307582');INSERT INTO `city` VALUES (275, '610200', '陕西省铜川市', '34.896747', '108.945142');INSERT INTO `city` VALUES (276, '410500', '河南省安阳市', '36.097593', '114.392756');INSERT INTO `city` VALUES (277, '542100', '西藏自治区昌都地区', '31.140969', '97.17202');INSERT INTO `city` VALUES (278, '430000', '湖南省', '28.112444', '112.98381');INSERT INTO `city` VALUES (279, '620200', '甘肃省嘉峪关市', '39.77313', '98.289152');INSERT INTO `city` VALUES (280, '511900', '四川省巴中市', '31.865236', '106.744729');INSERT INTO `city` VALUES (281, '429000', '湖北省省直辖行政单位', '30.545861', '114.341921');INSERT INTO `city` VALUES (282, '450500', '广西壮族自治区北海市', '21.481217', '109.119899');INSERT INTO `city` VALUES (283, '220600', '吉林省白山市', '41.939994', '126.423587');INSERT INTO `city` VALUES (284, '652800', '新疆维吾尔自治区巴音郭楞蒙古自治州', '41.764131', '86.145267');INSERT INTO `city` VALUES (285, '440600', '广东省佛山市', '23.021548', '113.121416');INSERT INTO `city` VALUES (286, '441800', '广东省清远市', '23.681764', '113.056031');INSERT INTO `city` VALUES (287, '632100', '青海省海东地区', '36.502216', '102.104346');INSERT INTO `city` VALUES (288, '610400', '陕西省咸阳市', '34.329563', '108.709003');INSERT INTO `city` VALUES (289, '350300', '福建省莆田市', '25.454085', '119.007777');INSERT INTO `city` VALUES (290, '440400', '广东省珠海市', '22.270715', '113.576726');INSERT INTO `city` VALUES (291, '450900', '广西壮族自治区玉林市', '22.636379', '110.164756');INSERT INTO `city` VALUES (292, '340400', '安徽省淮南市', '32.625478', '116.999933');INSERT INTO `city` VALUES (293, '110100', '北京市市辖区', '39.913075', '116.538935');INSERT INTO `city` VALUES (294, '655700', '新疆维吾尔自治区农七师', '44.416358', '84.941994');INSERT INTO `city` VALUES (295, '341500', '安徽省六安市', '31.745011', '116.505693');INSERT INTO `city` VALUES (296, '150200', '内蒙古自治区包头市', '40.657447', '109.840386');INSERT INTO `city` VALUES (297, '620100', '甘肃省兰州市', '36.061255', '103.834377');INSERT INTO `city` VALUES (298, '350900', '福建省宁德市', '26.665617', '119.547933');INSERT INTO `city` VALUES (299, '150800', '内蒙古自治区巴彦淖尔市', '40.743213', '107.387657');INSERT INTO `city` VALUES (300, '542300', '西藏自治区日喀则地区', '29.26687', '88.880583');INSERT INTO `city` VALUES (301, '421000', '湖北省荆州市', '30.335165', '112.239741');INSERT INTO `city` VALUES (302, '341700', '安徽省池州市', '30.6648', '117.491568');INSERT INTO `city` VALUES (303, '623000', '甘肃省甘南藏族自治州', '34.983296', '102.911262');INSERT INTO `city` VALUES (304, '440500', '广东省汕头市', '23.353299', '116.681838');INSERT INTO `city` VALUES (305, '511100', '四川省乐山市', '29.552106', '103.765568');INSERT INTO `city` VALUES (306, '150500', '内蒙古自治区通辽市', '43.61944', '122.265737');INSERT INTO `city` VALUES (307, '620600', '甘肃省武威市', '37.928336', '102.638009');INSERT INTO `city` VALUES (308, '340600', '安徽省淮北市', '33.955845', '116.798265');INSERT INTO `city` VALUES (309, '655600', '新疆维吾尔自治区农六师', '44.166757', '87.54324');INSERT INTO `city` VALUES (310, '230800', '黑龙江省佳木斯市', '46.799923', '130.318917');INSERT INTO `city` VALUES (311, '120200', '天津市县', '40.050167', '117.417317');INSERT INTO `city` VALUES (312, '430300', '湖南省湘潭市', '27.829738', '112.944049');INSERT INTO `city` VALUES (313, '650000', '新疆维吾尔自治区', '43.793028', '87.627812');INSERT INTO `city` VALUES (314, '330100', '浙江省杭州市', '30.274089', '120.155069');INSERT INTO `city` VALUES (315, '422800', '湖北省恩施土家族苗族自治州', '30.272156', '109.488172');INSERT INTO `city` VALUES (316, '360100', '江西省南昌市', '28.68316', '115.858089');INSERT INTO `city` VALUES (317, '320800', '江苏省淮安市', '33.61036', '119.015288');INSERT INTO `city` VALUES (318, '230100', '黑龙江省哈尔滨市', '45.803775', '126.534967');INSERT INTO `city` VALUES (319, '361000', '江西省抚州市', '27.9492', '116.358176');INSERT INTO `city` VALUES (320, '321300', '江苏省宿迁市', '33.961994', '118.275497');INSERT INTO `city` VALUES (321, '361100', '江西省上饶市', '28.454863', '117.943433');INSERT INTO `city` VALUES (322, '341200', '安徽省阜阳市', '32.890124', '115.814205');INSERT INTO `city` VALUES (323, '231200', '黑龙江省绥化市', '46.636631', '126.980006');INSERT INTO `city` VALUES (324, '542400', '西藏自治区那曲地区', '31.476198', '92.051241');INSERT INTO `city` VALUES (325, '451100', '广西壮族自治区贺州市', '24.40357', '111.566753');INSERT INTO `city` VALUES (326, '360200', '江西省景德镇市', '29.268836', '117.17842');INSERT INTO `city` VALUES (327, '441300', '广东省惠州市', '23.111847', '114.416196');INSERT INTO `city` VALUES (328, '320000', '江苏省', '32.061707', '118.763232');INSERT INTO `city` VALUES (329, '321100', '江苏省镇江市', '32.199147', '119.45722');INSERT INTO `city` VALUES (330, '450300', '广西壮族自治区桂林市', '25.273566', '110.290195');INSERT INTO `city` VALUES (331, '360500', '江西省新余市', '27.817819', '114.91741');INSERT INTO `city` VALUES (332, '640300', '宁夏回族自治区吴忠市', '37.997476', '106.198225');INSERT INTO `city` VALUES (333, '420200', '湖北省黄石市', '30.199652', '115.03852');INSERT INTO `city` VALUES (334, '371300', '山东省临沂市', '35.104672', '118.356448');INSERT INTO `city` VALUES (335, '500100', '重庆市市辖区', '29.56301', '106.551557');INSERT INTO `city` VALUES (336, '320600', '江苏省南通市', '31.980184', '120.894332');INSERT INTO `city` VALUES (337, '230900', '黑龙江省七台河市', '45.771975', '131.004915');INSERT INTO `city` VALUES (338, '234000', '黑龙江省森工总局', '45.295989', '127.372621');INSERT INTO `city` VALUES (339, '440700', '广东省江门市', '22.578738', '113.081901');INSERT INTO `city` VALUES (340, '230000', '黑龙江省', '45.74217', '126.662507');INSERT INTO `city` VALUES (341, '360700', '江西省赣州市', '25.831925', '114.935025');INSERT INTO `city` VALUES (342, '230500', '黑龙江省双鸭山市', '46.646923', '131.159553');INSERT INTO `city` VALUES (343, '230700', '黑龙江省伊春市', '47.727542', '128.840661');INSERT INTO `city` VALUES (344, '340000', '安徽省', '31.861184', '117.284923');INSERT INTO `city` VALUES (345, '231000', '黑龙江省牡丹江市', '44.551653', '129.633169');INSERT INTO `city` VALUES (346, '340300', '安徽省蚌埠市', '32.916287', '117.389719');INSERT INTO `city` VALUES (347, '530700', '云南省丽江市', '26.876774', '100.230376');INSERT INTO `city` VALUES (348, '360400', '江西省九江市', '29.705103', '116.001951');INSERT INTO `city` VALUES (349, '330800', '浙江省衢州市', '28.93581', '118.874375');INSERT INTO `city` VALUES (350, '410100', '河南省郑州市', '34.7466', '113.625368');INSERT INTO `city` VALUES (351, '230400', '黑龙江省鹤岗市', '47.349935', '130.298101');INSERT INTO `city` VALUES (352, '420600', '湖北省襄樊市', '32.012633', '112.155115');INSERT INTO `city` VALUES (353, '532500', '云南省红河哈尼族彝族自治州', '23.36313', '103.374799');INSERT INTO `city` VALUES (354, '533300', '云南省怒江傈僳族自治州', '25.852548', '98.853097');INSERT INTO `city` VALUES (355, '360800', '江西省吉安市', '27.113039', '114.992912');INSERT INTO `city` VALUES (356, '511000', '四川省内江市', '29.580229', '105.058433');INSERT INTO `city` VALUES (357, '330900', '浙江省舟山市', '29.985451', '122.206604');INSERT INTO `city` VALUES (358, '340200', '安徽省芜湖市', '31.352859', '118.432941');INSERT INTO `city` VALUES (359, '441700', '广东省阳江市', '21.857958', '111.982232');INSERT INTO `city` VALUES (360, '320400', '江苏省常州市', '31.810077', '119.974454');INSERT INTO `city` VALUES (361, '140300', '山西省阳泉市', '37.856658', '113.580415');INSERT INTO `city` VALUES (362, '230300', '黑龙江省鸡西市', '45.295075', '130.969333');INSERT INTO `city` VALUES (363, '330300', '浙江省温州市', '27.994267', '120.699367');INSERT INTO `city` VALUES (364, '233000', '黑龙江省农垦总局', '45.7349266', '126.6926476');INSERT INTO `city` VALUES (365, '510000', '四川省', '30.651652', '104.075931');INSERT INTO `city` VALUES (366, '330200', '浙江省宁波市', '29.868336', '121.54399');INSERT INTO `city` VALUES (367, '330600', '浙江省绍兴市', '29.995762', '120.586109');INSERT INTO `city` VALUES (368, '230600', '黑龙江省大庆市', '46.59019', '125.104637');INSERT INTO `city` VALUES (369, '230200', '黑龙江省齐齐哈尔市', '47.354348', '123.918186');INSERT INTO `city` VALUES (370, '231100', '黑龙江省黑河市', '50.245297', '127.52846');INSERT INTO `city` VALUES (371, '451200', '广西壮族自治区河池市', '24.692931', '108.085261');INSERT INTO `city` VALUES (372, '330000', '浙江省', '30.26586', '120.153676');INSERT INTO `city` VALUES (373, '131000', '河北省廊坊市', '39.538047', '116.683752');INSERT INTO `city` VALUES (374, '500000', '重庆市', '29.56301', '106.551557');INSERT INTO `city` VALUES (375, '522700', '贵州省黔南布依族苗族自治州', '26.254092', '107.52214');INSERT INTO `city` VALUES (376, '371000', '山东省威海市', '37.513068', '122.12042');INSERT INTO `city` VALUES (377, '440800', '广东省湛江市', '21.270702', '110.359387');INSERT INTO `city` VALUES (378, '320900', '江苏省盐城市', '33.347378', '120.163561');INSERT INTO `city` VALUES (379, '320200', '江苏省无锡市', '31.566145', '120.303027');INSERT INTO `city` VALUES (380, '500200', '重庆市县', '29.718137', '106.631034');INSERT INTO `city` VALUES (381, '421300', '湖北省随州市', '31.690216', '113.382458');INSERT INTO `city` VALUES (382, '632700', '青海省玉树藏族自治州', '33.005822', '97.006636');INSERT INTO `city` VALUES (383, '320100', '江苏省南京市', '32.060255', '118.796877');INSERT INTO `city` VALUES (384, '320300', '江苏省徐州市', '34.20475', '117.284067');INSERT INTO `city` VALUES (385, '655400', '新疆维吾尔自治区农四师', '43.9271062', '81.3057543');INSERT INTO `city` VALUES (386, '360000', '江西省', '28.674424', '115.909175');INSERT INTO `city` VALUES (387, '360600', '江西省鹰潭市', '28.260189', '117.069202');INSERT INTO `city` VALUES (388, '650100', '新疆维吾尔自治区乌鲁木齐市', '43.825645', '87.616823');INSERT INTO `city` VALUES (389, '330500', '浙江省湖州市', '30.894348', '120.086823');INSERT INTO `city` VALUES (390, '320500', '江苏省苏州市', '31.298886', '120.585316');INSERT INTO `city` VALUES (391, '321000', '江苏省扬州市', '32.39421', '119.412966');INSERT INTO `city` VALUES (392, '360900', '江西省宜春市', '27.815619', '114.416778');INSERT INTO `city` VALUES (393, '320700', '江苏省连云港市', '34.596544', '119.221282');INSERT INTO `city` VALUES (394, '360300', '江西省萍乡市', '27.622865', '113.854676');INSERT INTO `city` VALUES (395, '330700', '浙江省金华市', '29.079059', '119.647445');INSERT INTO `city` VALUES (396, '621200', '甘肃省陇南市', '33.400766', '104.922071');
最新教程周点击榜
微信扫一扫}