文档章节

Mysql 地区经纬度 查询

alexgaoyh
 alexgaoyh
发布于 2015/03/26 16:15
字数 15693
阅读 8407
收藏 35

    2015-03-27 修改,增加 MySQL的空间扩展(MySQL Spatial Extensions)的解决方案:


MySQL的空间扩展(MySQL Spatial Extensions),它允许在MySQL中直接处理、保存和分析地理位置相关的信息,看起来这是使用MySQL处理地理位置信息的“官方解决方案”。 但恰恰很可惜的是:它却不支持某些最基本的地理位置操作,比如查询在半径范围内的所有数据。它甚至连两坐标点之间的距离计算方法都没有(MySQL Spatial的distance方法在5.*版本中不支持)

官方指南的做法是这样的:

GLength(LineStringFromWKB(LineString(point1, point2)))

这条语句的处理逻辑是先通过两个点产生一个LineString的类型的数据,然后调用GLength得到这个LineString的实际长度。

这么做虽然有些复杂,貌似也解决了距离计算的问题,但读者需要注意的是:这种方法计算的是欧式空间的距离,简单来说,它给出的结果是两个点在三维空间中的直线距离,不是飞机在地球上飞的那条轨迹,而是笔直穿过地球的那条直线。

所以如果你的地理位置信息是用经纬度进行存储的,你就无法简单的直接使用这种方式进行距离计算。

上sql语句:

select id, pt,city from locationpoint where 0.5 >= GLength(LineStringFromWKB(LineString(pt, point(113.4 ,34.46))))


附上表结构数据:


CREATE TABLE `locationPoint` (
  `id` int(11) NOT NULL,
   pt point not null,
  `province` varchar(20) NOT NULL,
  `city` varchar(20) NOT NULL,
  `longitude` double(10,3) NOT NULL,
  `latitude` double(10,3) NOT NULL,
  PRIMARY KEY (`id`)
)engine=Myisam;

INSERT INTO `locationPoint` VALUES ('1147',point(117.17,31.52 ),'安徽省', '合肥', '117.170', '31.520');          
INSERT INTO `locationPoint` VALUES ('1148',point(117.02,30.31 ),'安徽省', '安庆', '117.020', '30.310');          
INSERT INTO `locationPoint` VALUES ('1149',point(117.21,32.56 ),'安徽省', '蚌埠', '117.210', '32.560');          
INSERT INTO `locationPoint` VALUES ('1150',point(115.47,33.52 ),'安徽省', '亳州', '115.470', '33.520');          
INSERT INTO `locationPoint` VALUES ('1151',point(117.52,31.36 ),'安徽省', '巢湖', '117.520', '31.360');          
INSERT INTO `locationPoint` VALUES ('1152',point(118.18,32.18 ),'安徽省', '滁州', '118.180', '32.180');          
INSERT INTO `locationPoint` VALUES ('1153',point(115.48,32.54 ),'安徽省', '阜阳', '115.480', '32.540');          
INSERT INTO `locationPoint` VALUES ('1154',point(117.28,30.39 ),'安徽省', '贵池', '117.280', '30.390');          
INSERT INTO `locationPoint` VALUES ('1155',point(116.47,33.57 ),'安徽省', '淮北', '116.470', '33.570');          
INSERT INTO `locationPoint` VALUES ('1156',point(116.58,32.37 ),'安徽省', '淮南', '116.580', '32.370');          
INSERT INTO `locationPoint` VALUES ('1157',point(118.18,29.43 ),'安徽省', '黄山', '118.180', '29.430');          
INSERT INTO `locationPoint` VALUES ('1158',point(115.21,33.15 ),'安徽省', '界首', '115.210', '33.150');          
INSERT INTO `locationPoint` VALUES ('1159',point(116.28,31.44 ),'安徽省', '六安', '116.280', '31.440');          
INSERT INTO `locationPoint` VALUES ('1160',point(118.28,31.43 ),'安徽省', '马鞍山', '118.280', '31.430');        
INSERT INTO `locationPoint` VALUES ('1161',point(117.58,32.47 ),'安徽省', '明光', '117.580', '32.470');          
INSERT INTO `locationPoint` VALUES ('1162',point(116.58,33.38 ),'安徽省', '宿州', '116.580', '33.380');          
INSERT INTO `locationPoint` VALUES ('1163',point(118.59,32.41 ),'安徽省', '天长', '118.590', '32.410');          
INSERT INTO `locationPoint` VALUES ('1164',point(117.48,30.56 ),'安徽省', '铜陵', '117.480', '30.560');          
INSERT INTO `locationPoint` VALUES ('1165',point(118.22,31.19 ),'安徽省', '芜湖', '118.220', '31.190');          
INSERT INTO `locationPoint` VALUES ('1166',point(118.44,30.57 ),'安徽省', '宣州', '118.440', '30.570');          
INSERT INTO `locationPoint` VALUES ('1167',point(119.18,26.05 ),'福建省', '福州', '119.180', '26.050');          
INSERT INTO `locationPoint` VALUES ('1168',point(119.31,25.58 ),'福建省', '长乐', '119.310', '25.580');          
INSERT INTO `locationPoint` VALUES ('1169',point(119.39,27.06 ),'福建省', '福安', '119.390', '27.060');          
INSERT INTO `locationPoint` VALUES ('1170',point(119.23,25.42 ),'福建省', '福清', '119.230', '25.420');          
INSERT INTO `locationPoint` VALUES ('1171',point(118.2 ,27.03 ),'福建省', '建瓯', '118.200', '27.030');          
INSERT INTO `locationPoint` VALUES ('1172',point(118.07,27.21 ),'福建省', '建阳', '118.070', '27.210');          
INSERT INTO `locationPoint` VALUES ('1173',point(118.35,24.49 ),'福建省', '晋江', '118.350', '24.490');          
INSERT INTO `locationPoint` VALUES ('1174',point(117.48,24.26 ),'福建省', '龙海', '117.480', '24.260');          
INSERT INTO `locationPoint` VALUES ('1175',point(117.01,25.06 ),'福建省', '龙岩', '117.010', '25.060');          
INSERT INTO `locationPoint` VALUES ('1176',point(118.23,24.57 ),'福建省', '南安', '118.230', '24.570');          
INSERT INTO `locationPoint` VALUES ('1177',point(118.1 ,26.38 ),'福建省', '南平', '118.100', '26.380');          
INSERT INTO `locationPoint` VALUES ('1178',point(119.31,26.39 ),'福建省', '宁德', '119.310', '26.390');          
INSERT INTO `locationPoint` VALUES ('1179',point(119.01,24.26 ),'福建省', '莆田', '119.010', '24.260');          
INSERT INTO `locationPoint` VALUES ('1180',point(118.36,24.56 ),'福建省', '泉州', '118.360', '24.560');          
INSERT INTO `locationPoint` VALUES ('1181',point(117.36,26.13 ),'福建省', '三明', '117.360', '26.130');          
INSERT INTO `locationPoint` VALUES ('1182',point(117.29,27.2  ),'福建省', '邵武', '117.290', '27.200');          
INSERT INTO `locationPoint` VALUES ('1183',point(118.38,24.44 ),'福建省', '石狮', '118.380', '24.440');          
INSERT INTO `locationPoint` VALUES ('1184',point(118.02,27.46 ),'福建省', '武夷山', '118.020', '27.460');        
INSERT INTO `locationPoint` VALUES ('1185',point(118.06,24.27 ),'福建省', '厦门', '118.060', '24.270');          
INSERT INTO `locationPoint` VALUES ('1186',point(117.23,25.58 ),'福建省', '永安', '117.230', '25.580');          
INSERT INTO `locationPoint` VALUES ('1187',point(117.24,25.17 ),'福建省', '漳平', '117.240', '25.170');          
INSERT INTO `locationPoint` VALUES ('1188',point(117.39,24.31 ),'福建省', '漳州', '117.390', '24.310');          
INSERT INTO `locationPoint` VALUES ('1189',point(103.51,36.04 ),'甘肃省', '兰州', '103.510', '36.040');          
INSERT INTO `locationPoint` VALUES ('1190',point(104.12,36.33 ),'甘肃省', '白银', '104.120', '36.330');          
INSERT INTO `locationPoint` VALUES ('1191',point(94.41 ,40.08 ),'甘肃省', '敦煌', '94.410', '40.080');           
INSERT INTO `locationPoint` VALUES ('1192',point(98.14 ,39.48 ),'甘肃省', '嘉峪关', '98.140', '39.480');         
INSERT INTO `locationPoint` VALUES ('1193',point(102.1 ,38.28 ),'甘肃省', '金昌', '102.100', '38.280');          
INSERT INTO `locationPoint` VALUES ('1194',point(98.31 ,39.44 ),'甘肃省', '酒泉', '98.310', '39.440');           
INSERT INTO `locationPoint` VALUES ('1195',point(103.12,35.37 ),'甘肃省', '临夏', '103.120', '35.370');          
INSERT INTO `locationPoint` VALUES ('1196',point(106.4 ,35.32 ),'甘肃省', '平凉', '106.400', '35.320');          
INSERT INTO `locationPoint` VALUES ('1197',point(105.42,34.37 ),'甘肃省', '天水', '105.420', '34.370');          
INSERT INTO `locationPoint` VALUES ('1198',point(102.39,37.56 ),'甘肃省', '武威', '102.390', '37.560');          
INSERT INTO `locationPoint` VALUES ('1199',point(107.4 ,35.45 ),'甘肃省', '西峰', '107.400', '35.450');          
INSERT INTO `locationPoint` VALUES ('1200',point(97.35 ,39.49 ),'甘肃省', '玉门', '97.350', '39.490');           
INSERT INTO `locationPoint` VALUES ('1201',point(100.26,38.56 ),'甘肃省', '张掖', '100.260', '38.560');          
INSERT INTO `locationPoint` VALUES ('1202',point(113.14,23.08 ),'广东省', '广州', '113.140', '23.080');          
INSERT INTO `locationPoint` VALUES ('1203',point(116.36,23.16 ),'广东省', '潮阳', '116.360', '23.160');          
INSERT INTO `locationPoint` VALUES ('1204',point(116.38,23.4  ),'广东省', '潮州', '116.380', '23.400');          
INSERT INTO `locationPoint` VALUES ('1205',point(116.46,23.28 ),'广东省', '澄海', '116.460', '23.280');          
INSERT INTO `locationPoint` VALUES ('1206',point(113.33,23.33 ),'广东省', '从化', '113.330', '23.330');          
INSERT INTO `locationPoint` VALUES ('1207',point(113.45,23.02 ),'广东省', '东莞', '113.450', '23.020');          
INSERT INTO `locationPoint` VALUES ('1208',point(112.19,22.12 ),'广东省', '恩平', '112.190', '22.120');          
INSERT INTO `locationPoint` VALUES ('1209',point(113.06,23.02 ),'广东省', '佛山', '113.060', '23.020');          
INSERT INTO `locationPoint` VALUES ('1210',point(112.5 ,22.53 ),'广东省', '高明', '112.500', '22.530');          
INSERT INTO `locationPoint` VALUES ('1211',point(112.26,23.02 ),'广东省', '高要', '112.260', '23.020');          
INSERT INTO `locationPoint` VALUES ('1212',point(110.5 ,21.54 ),'广东省', '高州', '110.500', '21.540');          
INSERT INTO `locationPoint` VALUES ('1213',point(112.57,22.46 ),'广东省', '鹤山', '112.570', '22.460');          
INSERT INTO `locationPoint` VALUES ('1214',point(114.41,23.43 ),'广东省', '河源', '114.410', '23.430');          
INSERT INTO `locationPoint` VALUES ('1215',point(113.12,23.23 ),'广东省', '花都', '113.120', '23.230');          
INSERT INTO `locationPoint` VALUES ('1216',point(110.37,21.39 ),'广东省', '化州', '110.370', '21.390');          
INSERT INTO `locationPoint` VALUES ('1217',point(114.28,22.48 ),'广东省', '惠阳', '114.280', '22.480');          
INSERT INTO `locationPoint` VALUES ('1218',point(114.22,23.05 ),'广东省', '惠州', '114.220', '23.050');          
INSERT INTO `locationPoint` VALUES ('1219',point(113.04,22.35 ),'广东省', '江门', '113.040', '22.350');          
INSERT INTO `locationPoint` VALUES ('1220',point(116.21,22.32 ),'广东省', '揭阳', '116.210', '22.320');          
INSERT INTO `locationPoint` VALUES ('1221',point(112.4 ,22.22 ),'广东省', '开平', '112.400', '22.220');          
INSERT INTO `locationPoint` VALUES ('1222',point(113.21,25.09 ),'广东省', '乐昌', '113.210', '25.090');          
INSERT INTO `locationPoint` VALUES ('1223',point(110.04,20.54 ),'广东省', '雷州', '110.040', '20.540');          
INSERT INTO `locationPoint` VALUES ('1224',point(110.17,21.37 ),'广东省', '廉江', '110.170', '21.370');          
INSERT INTO `locationPoint` VALUES ('1225',point(112.23,24.48 ),'广东省', '连州', '112.230', '24.480');          
INSERT INTO `locationPoint` VALUES ('1226',point(111.33,22.46 ),'广东省', '罗定', '111.330', '22.460');          
INSERT INTO `locationPoint` VALUES ('1227',point(110.53,21.4  ),'广东省', '茂名', '110.530', '21.400');          
INSERT INTO `locationPoint` VALUES ('1228',point(116.07,24.19 ),'广东省', '梅州', '116.070', '24.190');          
INSERT INTO `locationPoint` VALUES ('1229',point(113.09,23.01 ),'广东省', '南海', '113.090', '23.010');          
INSERT INTO `locationPoint` VALUES ('1230',point(113.22,22.57 ),'广东省', '番禺', '113.220', '22.570');          
INSERT INTO `locationPoint` VALUES ('1231',point(116.1 ,23.18 ),'广东省', '普宁', '116.100', '23.180');          
INSERT INTO `locationPoint` VALUES ('1232',point(113.01,23.42 ),'广东省', '清远', '113.010', '23.420');          
INSERT INTO `locationPoint` VALUES ('1233',point(112.52,23.1  ),'广东省', '三水', '112.520', '23.100');          
INSERT INTO `locationPoint` VALUES ('1234',point(116.41,23.22 ),'广东省', '汕头', '116.410', '23.220');          
INSERT INTO `locationPoint` VALUES ('1235',point(115.21,22.47 ),'广东省', '汕尾', '115.210', '22.470');          
INSERT INTO `locationPoint` VALUES ('1236',point(113.37,24.48 ),'广东省', '韶关', '113.370', '24.480');          
INSERT INTO `locationPoint` VALUES ('1237',point(114.07,22.33 ),'广东省', '深圳', '114.070', '22.330');          
INSERT INTO `locationPoint` VALUES ('1238',point(113.15,22.5  ),'广东省', '顺德', '113.150', '22.500');          
INSERT INTO `locationPoint` VALUES ('1239',point(112.41,23.21 ),'广东省', '四会', '112.410', '23.210');          
INSERT INTO `locationPoint` VALUES ('1240',point(112.48,22.15 ),'广东省', '台山', '112.480', '22.150');          
INSERT INTO `locationPoint` VALUES ('1241',point(110.47,21.26 ),'广东省', '吴川', '110.470', '21.260');          
INSERT INTO `locationPoint` VALUES ('1242',point(113.01,22.32 ),'广东省', '新会', '113.010', '22.320');          
INSERT INTO `locationPoint` VALUES ('1243',point(115.43,24.09 ),'广东省', '兴宁', '115.430', '24.090');          
INSERT INTO `locationPoint` VALUES ('1244',point(111.48,22.1  ),'广东省', '阳春', '111.480', '22.100');          
INSERT INTO `locationPoint` VALUES ('1245',point(111.58,21.5  ),'广东省', '阳江', '111.580', '21.500');          
INSERT INTO `locationPoint` VALUES ('1246',point(113.22,24.1  ),'广东省', '英德', '113.220', '24.100');          
INSERT INTO `locationPoint` VALUES ('1247',point(112.02,22.57 ),'广东省', '云浮', '112.020', '22.570');          
INSERT INTO `locationPoint` VALUES ('1248',point(113.49,23.18 ),'广东省', '增城', '113.490', '23.180');          
INSERT INTO `locationPoint` VALUES ('1249',point(110.24,21.11 ),'广东省', '湛江', '110.240', '21.110');          
INSERT INTO `locationPoint` VALUES ('1250',point(112.27,23.03 ),'广东省', '肇庆', '112.270', '23.030');          
INSERT INTO `locationPoint` VALUES ('1251',point(113.22,22.31 ),'广东省', '中山', '113.220', '22.310');          
INSERT INTO `locationPoint` VALUES ('1252',point(113.34,22.17 ),'广东省', '珠海', '113.340', '22.170');          
INSERT INTO `locationPoint` VALUES ('1253',point(108.19,22.48 ),'广西省', '南宁', '108.190', '22.480');          
INSERT INTO `locationPoint` VALUES ('1254',point(109.07,21.28 ),'广西省', '北海', '109.070', '21.280');          
INSERT INTO `locationPoint` VALUES ('1255',point(110.21,22.42 ),'广西省', '北流', '110.210', '22.420');          
INSERT INTO `locationPoint` VALUES ('1256',point(106.36,23.54 ),'广西省', '百色', '106.360', '23.540');          
INSERT INTO `locationPoint` VALUES ('1257',point(108.2 ,21.37 ),'广西省', '防城港', '108.200', '21.370');        
INSERT INTO `locationPoint` VALUES ('1258',point(109.36,23.06 ),'广西省', '贵港', '109.360', '23.060');          
INSERT INTO `locationPoint` VALUES ('1259',point(110.17,25.17 ),'广西省', '桂林', '110.170', '25.170');          
INSERT INTO `locationPoint` VALUES ('1260',point(110.04,23.22 ),'广西省', '桂平', '110.040', '23.220');          
INSERT INTO `locationPoint` VALUES ('1261',point(108.03,24.42 ),'广西省', '河池', '108.030', '24.420');          
INSERT INTO `locationPoint` VALUES ('1262',point(108.52,23.47 ),'广西省', '合山', '108.520', '23.470');          
INSERT INTO `locationPoint` VALUES ('1263',point(109.24,23.19 ),'广西省', '柳州', '109.240', '23.190');          
INSERT INTO `locationPoint` VALUES ('1264',point(106.44,22.07 ),'广西省', '赁祥', '106.440', '22.070');          
INSERT INTO `locationPoint` VALUES ('1265',point(108.37,21.57 ),'广西省', '钦州', '108.370', '21.570');          
INSERT INTO `locationPoint` VALUES ('1266',point(111.2 ,23.29 ),'广西省', '梧州', '111.200', '23.290');          
INSERT INTO `locationPoint` VALUES ('1267',point(110.09,22.38 ),'广西省', '玉林', '110.090', '22.380');          
INSERT INTO `locationPoint` VALUES ('1268',point(108.4 ,24.28 ),'广西省', '宜州', '108.400', '24.280');          
INSERT INTO `locationPoint` VALUES ('1269',point(106.42,26.35 ),'贵州省', '贵阳', '106.420', '26.350');          
INSERT INTO `locationPoint` VALUES ('1270',point(105.55,26.14 ),'贵州省', '安顺', '105.550', '26.140');          
INSERT INTO `locationPoint` VALUES ('1271',point(105.18,27.18 ),'贵州省', '毕节', '105.180', '27.180');          
INSERT INTO `locationPoint` VALUES ('1272',point(105.42,28.34 ),'贵州省', '赤水', '105.420', '28.340');          
INSERT INTO `locationPoint` VALUES ('1273',point(107.31,26.15 ),'贵州省', '都匀', '107.310', '26.150');          
INSERT INTO `locationPoint` VALUES ('1274',point(107.58,26.35 ),'贵州省', '凯里', '107.580', '26.350');          
INSERT INTO `locationPoint` VALUES ('1275',point(104.5 ,26.35 ),'贵州省', '六盘水', '104.500', '26.350');        
INSERT INTO `locationPoint` VALUES ('1276',point(106.27,26.33 ),'贵州省', '清镇', '106.270', '26.330');          
INSERT INTO `locationPoint` VALUES ('1277',point(109.12,27.43 ),'贵州省', '铜仁', '109.120', '27.430');          
INSERT INTO `locationPoint` VALUES ('1278',point(104.53,25.05 ),'贵州省', '兴义', '104.530', '25.050');          
INSERT INTO `locationPoint` VALUES ('1279',point(106.55,27.42 ),'贵州省', '遵义', '106.550', '27.420');          
INSERT INTO `locationPoint` VALUES ('1280',point(110.2 ,20.02 ),'海南省', '海口', '110.200', '20.020');          
INSERT INTO `locationPoint` VALUES ('1281',point(109.34,19.31 ),'海南省', '儋州', '109.340', '19.310');          
INSERT INTO `locationPoint` VALUES ('1282',point(110.28,19.14 ),'海南省', '琼海', '110.280', '19.140');          
INSERT INTO `locationPoint` VALUES ('1283',point(110.21,19.59 ),'海南省', '琼山', '110.210', '19.590');          
INSERT INTO `locationPoint` VALUES ('1284',point(109.31,18.14 ),'海南省', '三亚', '109.310', '18.140');          
INSERT INTO `locationPoint` VALUES ('1285',point(109.31,18.46 ),'海南省', '通什', '109.310', '18.460');          
INSERT INTO `locationPoint` VALUES ('1286',point(114.3 ,38.02 ),'河北省', '石家庄', '114.300', '38.020');        
INSERT INTO `locationPoint` VALUES ('1287',point(115.2 ,38.24 ),'河北省', '安国', '115.200', '38.240');          
INSERT INTO `locationPoint` VALUES ('1288',point(115.3 ,38.51 ),'河北省', '保定', '115.300', '38.510');          
INSERT INTO `locationPoint` VALUES ('1289',point(116.24,39.06 ),'河北省', '霸州', '116.240', '39.060');          
INSERT INTO `locationPoint` VALUES ('1290',point(116.34,38.04 ),'河北省', '泊头', '116.340', '38.040');          
INSERT INTO `locationPoint` VALUES ('1291',point(116.52,38.18 ),'河北省', '沧州', '116.520', '38.180');          
INSERT INTO `locationPoint` VALUES ('1292',point(117.57,40.59 ),'河北省', '承德', '117.570', '40.590');          
INSERT INTO `locationPoint` VALUES ('1293',point(115   ,38.3  ),'河北省', '定州', '115.000', '38.300');          
INSERT INTO `locationPoint` VALUES ('1294',point(118.06,39.34 ),'河北省', '丰南', '118.060', '39.340');          
INSERT INTO `locationPoint` VALUES ('1295',point(115.51,39.2  ),'河北省', '高碑店', '115.510', '39.200');        
INSERT INTO `locationPoint` VALUES ('1296',point(114.5 ,38.02 ),'河北省', '蒿城', '114.500', '38.020');          
INSERT INTO `locationPoint` VALUES ('1297',point(114.28,36.36 ),'河北省', '邯郸', '114.280', '36.360');          
INSERT INTO `locationPoint` VALUES ('1298',point(116.05,38.26 ),'河北省', '河间', '116.050', '38.260');          
INSERT INTO `locationPoint` VALUES ('1299',point(115.42,37.44 ),'河北省', '衡水', '115.420', '37.440');          
INSERT INTO `locationPoint` VALUES ('1300',point(117.21,38.21 ),'河北省', '黄骅', '117.210', '38.210');          
INSERT INTO `locationPoint` VALUES ('1301',point(115.02,38.02 ),'河北省', '晋州', '115.020', '38.020');          
INSERT INTO `locationPoint` VALUES ('1302',point(115.33,37.34 ),'河北省', '冀州', '115.330', '37.340');          
INSERT INTO `locationPoint` VALUES ('1303',point(116.42,39.31 ),'河北省', '廓坊', '116.420', '39.310');          
INSERT INTO `locationPoint` VALUES ('1304',point(114.19,38.04 ),'河北省', '鹿泉', '114.190', '38.040');          
INSERT INTO `locationPoint` VALUES ('1305',point(115.23,37.22 ),'河北省', '南宫', '115.230', '37.220');          
INSERT INTO `locationPoint` VALUES ('1306',point(119.35,39.55 ),'河北省', '秦皇岛', '119.350', '39.550');        
INSERT INTO `locationPoint` VALUES ('1307',point(116.07,38.42 ),'河北省', '任丘', '116.070', '38.420');          
INSERT INTO `locationPoint` VALUES ('1308',point(117.04,39.58 ),'河北省', '三河', '117.040', '39.580');          
INSERT INTO `locationPoint` VALUES ('1309',point(114.3 ,36.51 ),'河北省', '沙河', '114.300', '36.510');          
INSERT INTO `locationPoint` VALUES ('1310',point(115.32,38.01 ),'河北省', '深州', '115.320', '38.010');          
INSERT INTO `locationPoint` VALUES ('1311',point(118.11,39.36 ),'河北省', '唐山', '118.110', '39.360');          
INSERT INTO `locationPoint` VALUES ('1312',point(114.11,36.42 ),'河北省', '武安', '114.110', '36.420');          
INSERT INTO `locationPoint` VALUES ('1313',point(114.3 ,37.04 ),'河北省', '邢台', '114.300', '37.040');          
INSERT INTO `locationPoint` VALUES ('1314',point(115.12,37.54 ),'河北省', '辛集', '115.120', '37.540');          
INSERT INTO `locationPoint` VALUES ('1315',point(114.41,38.2  ),'河北省', '新乐', '114.410', '38.200');          
INSERT INTO `locationPoint` VALUES ('1316',point(114.53,40.48 ),'河北省', '张家口', '114.530', '40.480');        
INSERT INTO `locationPoint` VALUES ('1317',point(115.59,39.29 ),'河北省', '涿州', '115.590', '39.290');          
INSERT INTO `locationPoint` VALUES ('1318',point(117.58,40.11 ),'河北省', '遵化', '117.580', '40.110');          
INSERT INTO `locationPoint` VALUES ('1319',point(113.4 ,34.46 ),'河南省', '郑州', '113.400', '34.460');          
INSERT INTO `locationPoint` VALUES ('1320',point(114.21,36.06 ),'河南省', '安阳', '114.210', '36.060');          
INSERT INTO `locationPoint` VALUES ('1321',point(113.47,34.12 ),'河南省', '长葛', '113.470', '34.120');          
INSERT INTO `locationPoint` VALUES ('1322',point(113.02,34.27 ),'河南省', '登封', '113.020', '34.270');          
INSERT INTO `locationPoint` VALUES ('1323',point(112.05,32.42 ),'河南省', '邓州', '112.050', '32.420');          
INSERT INTO `locationPoint` VALUES ('1324',point(112.58,34.46 ),'河南省', '巩义', '112.580', '34.460');          
INSERT INTO `locationPoint` VALUES ('1325',point(114.11,35.54 ),'河南省', '鹤壁', '114.110', '35.540');          
INSERT INTO `locationPoint` VALUES ('1326',point(113.47,35.27 ),'河南省', '辉县', '113.470', '35.270');          
INSERT INTO `locationPoint` VALUES ('1327',point(113.12,35.14 ),'河南省', '焦作', '113.120', '35.140');          
INSERT INTO `locationPoint` VALUES ('1328',point(112.35,35.04 ),'河南省', '济源', '112.350', '35.040');          
INSERT INTO `locationPoint` VALUES ('1329',point(114.21,34.47 ),'河南省', '开封', '114.210', '34.470');          
INSERT INTO `locationPoint` VALUES ('1330',point(110.52,34.31 ),'河南省', '灵宝', '110.520', '34.310');          
INSERT INTO `locationPoint` VALUES ('1331',point(113.49,36.03 ),'河南省', '林州', '113.490', '36.030');          
INSERT INTO `locationPoint` VALUES ('1332',point(114.02,33.33 ),'河南省', '漯河', '114.020', '33.330');          
INSERT INTO `locationPoint` VALUES ('1333',point(112.27,34.41 ),'河南省', '洛阳', '112.270', '34.410');          
INSERT INTO `locationPoint` VALUES ('1334',point(112.32,33    ),'河南省', '南阳', '112.320', '33.000');          
INSERT INTO `locationPoint` VALUES ('1335',point(113.17,33.44 ),'河南省', '平顶山', '113.170', '33.440');        
INSERT INTO `locationPoint` VALUES ('1336',point(115.01,35.44 ),'河南省', '濮阳', '115.010', '35.440');          
INSERT INTO `locationPoint` VALUES ('1337',point(112.57,35.05 ),'河南省', '沁阳', '112.570', '35.050');          
INSERT INTO `locationPoint` VALUES ('1338',point(112.5 ,34.09 ),'河南省', '汝州', '112.500', '34.090');          
INSERT INTO `locationPoint` VALUES ('1339',point(111.12,34.47 ),'河南省', '三门峡', '111.120', '34.470');        
INSERT INTO `locationPoint` VALUES ('1340',point(115.38,34.26 ),'河南省', '商丘', '115.380', '34.260');          
INSERT INTO `locationPoint` VALUES ('1341',point(114.03,35.24 ),'河南省', '卫辉', '114.030', '35.240');          
INSERT INTO `locationPoint` VALUES ('1342',point(113.3 ,33.17 ),'河南省', '舞钢', '113.300', '33.170');          
INSERT INTO `locationPoint` VALUES ('1343',point(114.54,33.26 ),'河南省', '项城', '114.540', '33.260');          
INSERT INTO `locationPoint` VALUES ('1344',point(113.21,34.46 ),'河南省', '荥阳', '113.210', '34.460');          
INSERT INTO `locationPoint` VALUES ('1345',point(113.22,34.31 ),'河南省', '新密', '113.220', '34.310');          
INSERT INTO `locationPoint` VALUES ('1346',point(113.52,35.18 ),'河南省', '新乡', '113.520', '35.180');          
INSERT INTO `locationPoint` VALUES ('1347',point(114.04,32.07 ),'河南省', '信阳', '114.040', '32.070');          
INSERT INTO `locationPoint` VALUES ('1348',point(113.43,34.24 ),'河南省', '新郑', '113.430', '34.240');          
INSERT INTO `locationPoint` VALUES ('1349',point(113.49,34.01 ),'河南省', '许昌', '113.490', '34.010');          
INSERT INTO `locationPoint` VALUES ('1350',point(112.47,34.43 ),'河南省', '偃师', '112.470', '34.430');          
INSERT INTO `locationPoint` VALUES ('1351',point(111.55,34.43 ),'河南省', '义马', '111.550', '34.430');          
INSERT INTO `locationPoint` VALUES ('1352',point(113.28,34.09 ),'河南省', '禹州', '113.280', '34.090');          
INSERT INTO `locationPoint` VALUES ('1353',point(114.38,33.37 ),'河南省', '周口', '114.380', '33.370');          
INSERT INTO `locationPoint` VALUES ('1354',point(114.01,32.58 ),'河南省', '驻马店', '114.010', '32.580');        
INSERT INTO `locationPoint` VALUES ('1355',point(126.36,45.44 ),'黑龙江省', '哈尔滨', '126.360', '45.440');      
INSERT INTO `locationPoint` VALUES ('1356',point(126.58,45.32 ),'黑龙江省', '阿城', '126.580', '45.320');        
INSERT INTO `locationPoint` VALUES ('1357',point(125.18,46.24 ),'黑龙江省', '安达', '125.180', '46.240');        
INSERT INTO `locationPoint` VALUES ('1358',point(126.31,48.15 ),'黑龙江省', '北安', '126.310', '48.150');        
INSERT INTO `locationPoint` VALUES ('1359',point(125.01,46.36 ),'黑龙江省', '大庆', '125.010', '46.360');        
INSERT INTO `locationPoint` VALUES ('1360',point(132.02,47.15 ),'黑龙江省', '富锦', '132.020', '47.150');        
INSERT INTO `locationPoint` VALUES ('1361',point(129.21,44.35 ),'黑龙江省', '海林', '129.210', '44.350');        
INSERT INTO `locationPoint` VALUES ('1362',point(126.57,47.28 ),'黑龙江省', '海伦', '126.570', '47.280');        
INSERT INTO `locationPoint` VALUES ('1363',point(130.16,47.2  ),'黑龙江省', '鹤岗', '130.160', '47.200');        
INSERT INTO `locationPoint` VALUES ('1364',point(127.29,50.14 ),'黑龙江省', '黑河', '127.290', '50.140');        
INSERT INTO `locationPoint` VALUES ('1365',point(130.22,46.47 ),'黑龙江省', '佳木斯', '130.220', '46.470');      
INSERT INTO `locationPoint` VALUES ('1366',point(130.57,45.17 ),'黑龙江省', '鸡西', '130.570', '45.170');        
INSERT INTO `locationPoint` VALUES ('1367',point(131.5 ,45.32 ),'黑龙江省', '密山', '131.500', '45.320');        
INSERT INTO `locationPoint` VALUES ('1368',point(129.36,44.35 ),'黑龙江省', '牡丹江', '129.360', '44.350');      
INSERT INTO `locationPoint` VALUES ('1369',point(124.51,48.29 ),'黑龙江省', '讷河', '124.510', '48.290');        
INSERT INTO `locationPoint` VALUES ('1370',point(129.28,44.21 ),'黑龙江省', '宁安', '129.280', '44.210');        
INSERT INTO `locationPoint` VALUES ('1371',point(123.57,47.2  ),'黑龙江省', '齐齐哈尔', '123.570', '47.200');    
INSERT INTO `locationPoint` VALUES ('1372',point(130.49,45.48 ),'黑龙江省', '七台河', '130.490', '45.480');      
INSERT INTO `locationPoint` VALUES ('1373',point(126.15,45.22 ),'黑龙江省', '双城', '126.150', '45.220');        
INSERT INTO `locationPoint` VALUES ('1374',point(127.55,45.14 ),'黑龙江省', '尚志', '127.550', '45.140');        
INSERT INTO `locationPoint` VALUES ('1375',point(131.11,46.38 ),'黑龙江省', '双鸭山', '131.110', '46.380');      
INSERT INTO `locationPoint` VALUES ('1376',point(131.11,44.25 ),'黑龙江省', '绥芬河', '131.110', '44.250');      
INSERT INTO `locationPoint` VALUES ('1377',point(126.59,46.38 ),'黑龙江省', '绥化', '126.590', '46.380');        
INSERT INTO `locationPoint` VALUES ('1378',point(128.01,46.59 ),'黑龙江省', '铁力', '128.010', '46.590');        
INSERT INTO `locationPoint` VALUES ('1379',point(132.3 ,47.39 ),'黑龙江省', '同江', '132.300', '47.390');        
INSERT INTO `locationPoint` VALUES ('1380',point(127.11,44.55 ),'黑龙江省', '五常', '127.110', '44.550');        
INSERT INTO `locationPoint` VALUES ('1381',point(126.07,48.38 ),'黑龙江省', '五大连池', '126.070', '48.380');    
INSERT INTO `locationPoint` VALUES ('1382',point(128.56,47.42 ),'黑龙江省', '伊春', '128.560', '47.420');        
INSERT INTO `locationPoint` VALUES ('1383',point(125.58,46.04 ),'黑龙江省', '肇东', '125.580', '46.040');        
INSERT INTO `locationPoint` VALUES ('1384',point(114.17,30.35 ),'湖北省', '武汉', '114.170', '30.350');          
INSERT INTO `locationPoint` VALUES ('1385',point(113.41,31.15 ),'湖北省', '安陆', '113.410', '31.150');          
INSERT INTO `locationPoint` VALUES ('1386',point(111.47,30.5  ),'湖北省', '当阳', '111.470', '30.500');          
INSERT INTO `locationPoint` VALUES ('1387',point(108.3 ,32.33 ),'湖北省', '丹江口', '108.300', '32.330');        
INSERT INTO `locationPoint` VALUES ('1388',point(114.58,30.06 ),'湖北省', '大冶', '114.580', '30.060');          
INSERT INTO `locationPoint` VALUES ('1389',point(109.29,30.16 ),'湖北省', '恩施', '109.290', '30.160');          
INSERT INTO `locationPoint` VALUES ('1390',point(114.52,30.23 ),'湖北省', '鄂州', '114.520', '30.230');          
INSERT INTO `locationPoint` VALUES ('1391',point(113.48,31.37 ),'湖北省', '广水', '113.480', '31.370');          
INSERT INTO `locationPoint` VALUES ('1392',point(113.27,29.48 ),'湖北省', '洪湖', '113.270', '29.480');          
INSERT INTO `locationPoint` VALUES ('1393',point(115.06,30.12 ),'湖北省', '黄石', '115.060', '30.120');          
INSERT INTO `locationPoint` VALUES ('1394',point(114.52,30.27 ),'湖北省', '黄州', '114.520', '30.270');          
INSERT INTO `locationPoint` VALUES ('1395',point(112.12,31.02 ),'湖北省', '荆门', '112.120', '31.020');          
INSERT INTO `locationPoint` VALUES ('1396',point(112.16,30.18 ),'湖北省', '荆沙', '112.160', '30.180');          
INSERT INTO `locationPoint` VALUES ('1397',point(111.4 ,32.23 ),'湖北省', '老河口', '111.400', '32.230');        
INSERT INTO `locationPoint` VALUES ('1398',point(108.56,30.18 ),'湖北省', '利川', '108.560', '30.180');          
INSERT INTO `locationPoint` VALUES ('1399',point(115.01,31.1  ),'湖北省', '麻城', '115.010', '31.100');          
INSERT INTO `locationPoint` VALUES ('1400',point(113.51,29.42 ),'湖北省', '浦圻', '113.510', '29.420');          
INSERT INTO `locationPoint` VALUES ('1401',point(112.53,30.26 ),'湖北省', '潜江', '112.530', '30.260');          
INSERT INTO `locationPoint` VALUES ('1402',point(112.24,29.43 ),'湖北省', '石首', '112.240', '29.430');          
INSERT INTO `locationPoint` VALUES ('1403',point(110.47,32.4  ),'湖北省', '十堰', '110.470', '32.400');          
INSERT INTO `locationPoint` VALUES ('1404',point(113.22,31.42 ),'湖北省', '随州', '113.220', '31.420');          
INSERT INTO `locationPoint` VALUES ('1405',point(113.1 ,60.39 ),'湖北省', '天门', '113.100', '60.390');          
INSERT INTO `locationPoint` VALUES ('1406',point(115.33,29.51 ),'湖北省', '武穴', '115.330', '29.510');          
INSERT INTO `locationPoint` VALUES ('1407',point(112.08,32.02 ),'湖北省', '襄樊', '112.080', '32.020');          
INSERT INTO `locationPoint` VALUES ('1408',point(114.17,29.53 ),'湖北省', '咸宁', '114.170', '29.530');          
INSERT INTO `locationPoint` VALUES ('1409',point(113.27,30.22 ),'湖北省', '仙桃', '113.270', '30.220');          
INSERT INTO `locationPoint` VALUES ('1410',point(113.54,30.56 ),'湖北省', '孝感', '113.540', '30.560');          
INSERT INTO `locationPoint` VALUES ('1411',point(111.17,30.42 ),'湖北省', '宜昌', '111.170', '30.420');          
INSERT INTO `locationPoint` VALUES ('1412',point(112.15,31.42 ),'湖北省', '宜城', '112.150', '31.420');          
INSERT INTO `locationPoint` VALUES ('1413',point(113.33,30.57 ),'湖北省', '应城', '113.330', '30.570');          
INSERT INTO `locationPoint` VALUES ('1414',point(112.44,32.07 ),'湖北省', '枣阳', '112.440', '32.070');          
INSERT INTO `locationPoint` VALUES ('1415',point(111.27,30.23 ),'湖北省', '枝城', '111.270', '30.230');          
INSERT INTO `locationPoint` VALUES ('1416',point(112.34,31.1  ),'湖北省', '钟祥', '112.340', '31.100');          
INSERT INTO `locationPoint` VALUES ('1417',point(112.59,28.12 ),'湖南省', '长沙', '112.590', '28.120');          
INSERT INTO `locationPoint` VALUES ('1418',point(111.51,29.02 ),'湖南省', '常德', '111.510', '29.020');          
INSERT INTO `locationPoint` VALUES ('1419',point(113.02,25.46 ),'湖南省', '郴州', '113.020', '25.460');          
INSERT INTO `locationPoint` VALUES ('1420',point(112.37,26.53 ),'湖南省', '衡阳', '112.370', '26.530');          
INSERT INTO `locationPoint` VALUES ('1421',point(109.59,27.07 ),'湖南省', '洪江', '109.590', '27.070');          
INSERT INTO `locationPoint` VALUES ('1422',point(109.58,27.33 ),'湖南省', '怀化', '109.580', '27.330');          
INSERT INTO `locationPoint` VALUES ('1423',point(111.52,29.38 ),'湖南省', '津市', '111.520', '29.380');          
INSERT INTO `locationPoint` VALUES ('1424',point(109.43,28.18 ),'湖南省', '吉首', '109.430', '28.180');          
INSERT INTO `locationPoint` VALUES ('1425',point(112.51,26.24 ),'湖南省', '耒阳', '112.510', '26.240');          
INSERT INTO `locationPoint` VALUES ('1426',point(111.26,27.42 ),'湖南省', '冷水江', '111.260', '27.420');        
INSERT INTO `locationPoint` VALUES ('1427',point(111.35,26.26 ),'湖南省', '冷水滩', '111.350', '26.260');        
INSERT INTO `locationPoint` VALUES ('1428',point(111.41,27.41 ),'湖南省', '涟源', '111.410', '27.410');          
INSERT INTO `locationPoint` VALUES ('1429',point(113.3 ,27.4  ),'湖南省', '醴陵', '113.300', '27.400');          
INSERT INTO `locationPoint` VALUES ('1430',point(113.27,29.29 ),'湖南省', '临湘', '113.270', '29.290');          
INSERT INTO `locationPoint` VALUES ('1431',point(113.37,28.09 ),'湖南省', '浏阳', '113.370', '28.090');          
INSERT INTO `locationPoint` VALUES ('1432',point(111.59,27.44 ),'湖南省', '娄底', '111.590', '27.440');          
INSERT INTO `locationPoint` VALUES ('1433',point(113.03,28.49 ),'湖南省', '汨罗', '113.030', '28.490');          
INSERT INTO `locationPoint` VALUES ('1434',point(112.29,27.54 ),'湖南省', '韶山', '112.290', '27.540');          
INSERT INTO `locationPoint` VALUES ('1435',point(111.28,27.14 ),'湖南省', '邵阳', '111.280', '27.140');          
INSERT INTO `locationPoint` VALUES ('1436',point(110.37,26.43 ),'湖南省', '武冈', '110.370', '26.430');          
INSERT INTO `locationPoint` VALUES ('1437',point(112.53,27.52 ),'湖南省', '湘潭', '112.530', '27.520');          
INSERT INTO `locationPoint` VALUES ('1438',point(112.31,27.44 ),'湖南省', '湘乡', '112.310', '27.440');          
INSERT INTO `locationPoint` VALUES ('1439',point(112.2 ,28.36 ),'湖南省', '益阳', '112.200', '28.360');          
INSERT INTO `locationPoint` VALUES ('1440',point(111.37,26.13 ),'湖南省', '永州', '111.370', '26.130');          
INSERT INTO `locationPoint` VALUES ('1441',point(112.22,28.5  ),'湖南省', '沅江', '112.220', '28.500');          
INSERT INTO `locationPoint` VALUES ('1442',point(113.06,29.22 ),'湖南省', '岳阳', '113.060', '29.220');          
INSERT INTO `locationPoint` VALUES ('1443',point(110.29,29.08 ),'湖南省', '张家界', '110.290', '29.080');        
INSERT INTO `locationPoint` VALUES ('1444',point(113.09,27.51 ),'湖南省', '株洲', '113.090', '27.510');          
INSERT INTO `locationPoint` VALUES ('1445',point(113.13,25.58 ),'湖南省', '资兴', '113.130', '25.580');          
INSERT INTO `locationPoint` VALUES ('1446',point(125.19,43.54 ),'吉林省', '长春', '125.190', '43.540');          
INSERT INTO `locationPoint` VALUES ('1447',point(122.5 ,45.38 ),'吉林省', '白城', '122.500', '45.380');          
INSERT INTO `locationPoint` VALUES ('1448',point(126.26,41.56 ),'吉林省', '白山', '126.260', '41.560');          
INSERT INTO `locationPoint` VALUES ('1449',point(124.18,45.3  ),'吉林省', '大安', '124.180', '45.300');          
INSERT INTO `locationPoint` VALUES ('1450',point(125.42,44.32 ),'吉林省', '德惠', '125.420', '44.320');          
INSERT INTO `locationPoint` VALUES ('1451',point(128.13,43.22 ),'吉林省', '敦化', '128.130', '43.220');          
INSERT INTO `locationPoint` VALUES ('1452',point(124.49,43.31 ),'吉林省', '公主岭', '124.490', '43.310');        
INSERT INTO `locationPoint` VALUES ('1453',point(129   ,42.32 ),'吉林省', '和龙', '129.000', '42.320');          
INSERT INTO `locationPoint` VALUES ('1454',point(126.44,42.58 ),'吉林省', '桦甸', '126.440', '42.580');          
INSERT INTO `locationPoint` VALUES ('1455',point(130.22,42.52 ),'吉林省', '珲春', '130.220', '42.520');          
INSERT INTO `locationPoint` VALUES ('1456',point(126.11,41.08 ),'吉林省', '集安', '126.110', '41.080');          
INSERT INTO `locationPoint` VALUES ('1457',point(127.21,43.42 ),'吉林省', '蛟河', '127.210', '43.420');          
INSERT INTO `locationPoint` VALUES ('1458',point(126.33,43.52 ),'吉林省', '吉林', '126.330', '43.520');          
INSERT INTO `locationPoint` VALUES ('1459',point(125.51,44.09 ),'吉林省', '九台', '125.510', '44.090');          
INSERT INTO `locationPoint` VALUES ('1460',point(125.09,42.54 ),'吉林省', '辽源', '125.090', '42.540');          
INSERT INTO `locationPoint` VALUES ('1461',point(126.53,41.49 ),'吉林省', '临江', '126.530', '41.490');          
INSERT INTO `locationPoint` VALUES ('1462',point(129.26,42.46 ),'吉林省', '龙井', '129.260', '42.460');          
INSERT INTO `locationPoint` VALUES ('1463',point(125.4 ,42.32 ),'吉林省', '梅河口', '125.400', '42.320');        
INSERT INTO `locationPoint` VALUES ('1464',point(126.57,44.24 ),'吉林省', '舒兰', '126.570', '44.240');          
INSERT INTO `locationPoint` VALUES ('1465',point(124.22,43.1  ),'吉林省', '四平', '124.220', '43.100');          
INSERT INTO `locationPoint` VALUES ('1466',point(124.49,45.11 ),'吉林省', '松原', '124.490', '45.110');          
INSERT INTO `locationPoint` VALUES ('1467',point(122.47,45.2  ),'吉林省', '洮南', '122.470', '45.200');          
INSERT INTO `locationPoint` VALUES ('1468',point(125.56,41.43 ),'吉林省', '通化', '125.560', '41.430');          
INSERT INTO `locationPoint` VALUES ('1469',point(129.51,42.57 ),'吉林省', '图们', '129.510', '42.570');          
INSERT INTO `locationPoint` VALUES ('1470',point(129.3 ,42.54 ),'吉林省', '延吉', '129.300', '42.540');          
INSERT INTO `locationPoint` VALUES ('1471',point(126.32,44.49 ),'吉林省', '愉树', '126.320', '44.490');          
INSERT INTO `locationPoint` VALUES ('1472',point(118.46,32.03 ),'江苏省', '南京', '118.460', '32.030');          
INSERT INTO `locationPoint` VALUES ('1473',point(120.43,31.39 ),'江苏省', '常熟', '120.430', '31.390');          
INSERT INTO `locationPoint` VALUES ('1474',point(119.58,31.47 ),'江苏省', '常州', '119.580', '31.470');          
INSERT INTO `locationPoint` VALUES ('1475',point(119.32,32    ),'江苏省', '丹阳', '119.320', '32.000');          
INSERT INTO `locationPoint` VALUES ('1476',point(120.19,32.51 ),'江苏省', '东台', '120.190', '32.510');          
INSERT INTO `locationPoint` VALUES ('1477',point(119.27,32.47 ),'江苏省', '高邮', '119.270', '32.470');          
INSERT INTO `locationPoint` VALUES ('1478',point(121.09,31.53 ),'江苏省', '海门', '121.090', '31.530');          
INSERT INTO `locationPoint` VALUES ('1479',point(119.09,33.3  ),'江苏省', '淮安', '119.090', '33.300');          
INSERT INTO `locationPoint` VALUES ('1480',point(119.02,33.36 ),'江苏省', '淮阴', '119.020', '33.360');          
INSERT INTO `locationPoint` VALUES ('1481',point(119.32,32.26 ),'江苏省', '江都', '119.320', '32.260');          
INSERT INTO `locationPoint` VALUES ('1482',point(120.08,32.34 ),'江苏省', '姜堰', '120.080', '32.340');          
INSERT INTO `locationPoint` VALUES ('1483',point(120.17,31.54 ),'江苏省', '江阴', '120.170', '31.540');          
INSERT INTO `locationPoint` VALUES ('1484',point(120.17,32.02 ),'江苏省', '靖江', '120.170', '32.020');          
INSERT INTO `locationPoint` VALUES ('1485',point(119.33,31.46 ),'江苏省', '金坛', '119.330', '31.460');          
INSERT INTO `locationPoint` VALUES ('1486',point(120.57,31.23 ),'江苏省', '昆山', '120.570', '31.230');          
INSERT INTO `locationPoint` VALUES ('1487',point(119.1 ,34.36 ),'江苏省', '连去港', '119.100', '34.360');        
INSERT INTO `locationPoint` VALUES ('1488',point(119.29,31.26 ),'江苏省', '溧阳', '119.290', '31.260');          
INSERT INTO `locationPoint` VALUES ('1489',point(120.51,32.01 ),'江苏省', '南通', '120.510', '32.010');          
INSERT INTO `locationPoint` VALUES ('1490',point(117.59,34.19 ),'江苏省', '邳州', '117.590', '34.190');          
INSERT INTO `locationPoint` VALUES ('1491',point(121.39,31.48 ),'江苏省', '启乐', '121.390', '31.480');          
INSERT INTO `locationPoint` VALUES ('1492',point(120.33,32.23 ),'江苏省', '如皋', '120.330', '32.230');          
INSERT INTO `locationPoint` VALUES ('1493',point(118.18,33.58 ),'江苏省', '宿迁', '118.180', '33.580');          
INSERT INTO `locationPoint` VALUES ('1494',point(120.37,31.19 ),'江苏省', '苏州', '120.370', '31.190');          
INSERT INTO `locationPoint` VALUES ('1495',point(121.06,31.27 ),'江苏省', '太仓', '121.060', '31.270');          
INSERT INTO `locationPoint` VALUES ('1496',point(120.01,32.1  ),'江苏省', '泰兴', '120.010', '32.100');          
INSERT INTO `locationPoint` VALUES ('1497',point(119.54,32.3  ),'江苏省', '泰州', '119.540', '32.300');          
INSERT INTO `locationPoint` VALUES ('1498',point(121.03,32.05 ),'江苏省', '通州', '121.030', '32.050');          
INSERT INTO `locationPoint` VALUES ('1499',point(120.39,31.1  ),'江苏省', '吴江', '120.390', '31.100');          
INSERT INTO `locationPoint` VALUES ('1500',point(120.18,31.34 ),'江苏省', '无锡', '120.180', '31.340');          
INSERT INTO `locationPoint` VALUES ('1501',point(119.5 ,32.56 ),'江苏省', '兴化', '119.500', '32.560');          
INSERT INTO `locationPoint` VALUES ('1502',point(118.2 ,34.22 ),'江苏省', '新沂', '118.200', '34.220');          
INSERT INTO `locationPoint` VALUES ('1503',point(117.11,34.15 ),'江苏省', '徐州', '117.110', '34.150');          
INSERT INTO `locationPoint` VALUES ('1504',point(120.08,33.22 ),'江苏省', '盐在', '120.080', '33.220');          
INSERT INTO `locationPoint` VALUES ('1505',point(119.49,32.14 ),'江苏省', '扬中', '119.490', '32.140');          
INSERT INTO `locationPoint` VALUES ('1506',point(119.26,32.23 ),'江苏省', '扬州', '119.260', '32.230');          
INSERT INTO `locationPoint` VALUES ('1507',point(119.49,31.21 ),'江苏省', '宜兴', '119.490', '31.210');          
INSERT INTO `locationPoint` VALUES ('1508',point(119.1 ,32.16 ),'江苏省', '仪征', '119.100', '32.160');          
INSERT INTO `locationPoint` VALUES ('1509',point(120.32,31.52 ),'江苏省', '张家港', '120.320', '31.520');        
INSERT INTO `locationPoint` VALUES ('1510',point(119.27,32.11 ),'江苏省', '镇江', '119.270', '32.110');          
INSERT INTO `locationPoint` VALUES ('1511',point(115.55,28.4  ),'江西省', '南昌', '115.550', '28.400');          
INSERT INTO `locationPoint` VALUES ('1512',point(117.35,28.57 ),'江西省', '德兴', '117.350', '28.570');          
INSERT INTO `locationPoint` VALUES ('1513',point(115.48,28.12 ),'江西省', '丰城', '115.480', '28.120');          
INSERT INTO `locationPoint` VALUES ('1514',point(114.56,28.52 ),'江西省', '赣州', '114.560', '28.520');          
INSERT INTO `locationPoint` VALUES ('1515',point(115.22,28.25 ),'江西省', '高安', '115.220', '28.250');          
INSERT INTO `locationPoint` VALUES ('1516',point(114.58,27.07 ),'江西省', '吉安', '114.580', '27.070');          
INSERT INTO `locationPoint` VALUES ('1517',point(117.13,29.17 ),'江西省', '景德镇', '117.130', '29.170');        
INSERT INTO `locationPoint` VALUES ('1518',point(114.1 ,26.34 ),'江西省', '井冈山', '114.100', '26.340');        
INSERT INTO `locationPoint` VALUES ('1519',point(115.58,29.43 ),'江西省', '九江', '115.580', '29.430');          
INSERT INTO `locationPoint` VALUES ('1520',point(117.08,28.58 ),'江西省', '乐平', '117.080', '28.580');          
INSERT INTO `locationPoint` VALUES ('1521',point(116.21,27.59 ),'江西省', '临川', '116.210', '27.590');          
INSERT INTO `locationPoint` VALUES ('1522',point(113.5 ,27.37 ),'江西省', '萍乡', '113.500', '27.370');          
INSERT INTO `locationPoint` VALUES ('1523',point(115.38,29.4  ),'江西省', '瑞昌', '115.380', '29.400');          
INSERT INTO `locationPoint` VALUES ('1524',point(116.01,25.53 ),'江西省', '瑞金', '116.010', '25.530');          
INSERT INTO `locationPoint` VALUES ('1525',point(117.58,25.27 ),'江西省', '上饶', '117.580', '25.270');          
INSERT INTO `locationPoint` VALUES ('1526',point(114.56,27.48 ),'江西省', '新余', '114.560', '27.480');          
INSERT INTO `locationPoint` VALUES ('1527',point(114.23,27.47 ),'江西省', '宜春', '114.230', '27.470');          
INSERT INTO `locationPoint` VALUES ('1528',point(117.03,28.14 ),'江西省', '鹰潭', '117.030', '28.140');          
INSERT INTO `locationPoint` VALUES ('1529',point(115.32,28.03 ),'江西省', '樟树', '115.320', '28.030');          
INSERT INTO `locationPoint` VALUES ('1530',point(123.25,41.48 ),'辽宁省', '沈阳', '123.250', '41.480');          
INSERT INTO `locationPoint` VALUES ('1531',point(123   ,41.07 ),'辽宁省', '鞍山', '123.000', '41.070');          
INSERT INTO `locationPoint` VALUES ('1532',point(120.47,41.48 ),'辽宁省', '北票', '120.470', '41.480');          
INSERT INTO `locationPoint` VALUES ('1533',point(123.46,41.18 ),'辽宁省', '本溪', '123.460', '41.180');          
INSERT INTO `locationPoint` VALUES ('1534',point(120.27,41.34 ),'辽宁省', '朝阳', '120.270', '41.340');          
INSERT INTO `locationPoint` VALUES ('1535',point(121.36,38.55 ),'辽宁省', '大连', '121.360', '38.550');          
INSERT INTO `locationPoint` VALUES ('1536',point(124.22,40.08 ),'辽宁省', '丹东', '124.220', '40.080');          
INSERT INTO `locationPoint` VALUES ('1537',point(122.31,40.37 ),'辽宁省', '大石桥', '122.310', '40.370');        
INSERT INTO `locationPoint` VALUES ('1538',point(124.08,39.53 ),'辽宁省', '东港', '124.080', '39.530');          
INSERT INTO `locationPoint` VALUES ('1539',point(124.02,40.28 ),'辽宁省', '凤城', '124.020', '40.280');          
INSERT INTO `locationPoint` VALUES ('1540',point(123.54,41.51 ),'辽宁省', '抚顺', '123.540', '41.510');          
INSERT INTO `locationPoint` VALUES ('1541',point(121.39,42.01 ),'辽宁省', '阜新', '121.390', '42.010');          
INSERT INTO `locationPoint` VALUES ('1542',point(122.21,40.24 ),'辽宁省', '盖州', '122.210', '40.240');          
INSERT INTO `locationPoint` VALUES ('1543',point(122.43,40.51 ),'辽宁省', '海城', '122.430', '40.510');          
INSERT INTO `locationPoint` VALUES ('1544',point(120.51,40.45 ),'辽宁省', '葫芦岛', '120.510', '40.450');        
INSERT INTO `locationPoint` VALUES ('1545',point(121.09,41.07 ),'辽宁省', '锦州', '121.090', '41.070');          
INSERT INTO `locationPoint` VALUES ('1546',point(124.02,42.32 ),'辽宁省', '开原', '124.020', '42.320');          
INSERT INTO `locationPoint` VALUES ('1547',point(123.12,41.16 ),'辽宁省', '辽阳', '123.120', '41.160');          
INSERT INTO `locationPoint` VALUES ('1548',point(121.21,41.1  ),'辽宁省', '凌海', '121.210', '41.100');          
INSERT INTO `locationPoint` VALUES ('1549',point(119.22,41.14 ),'辽宁省', '凌源', '119.220', '41.140');          
INSERT INTO `locationPoint` VALUES ('1550',point(122.03,41.07 ),'辽宁省', '盘锦', '122.030', '41.070');          
INSERT INTO `locationPoint` VALUES ('1551',point(121.58,39.23 ),'辽宁省', '普兰店', '121.580', '39.230');        
INSERT INTO `locationPoint` VALUES ('1552',point(123.32,42.28 ),'辽宁省', '铁法', '123.320', '42.280');          
INSERT INTO `locationPoint` VALUES ('1553',point(123.51,42.18 ),'辽宁省', '铁岭', '123.510', '42.180');          
INSERT INTO `locationPoint` VALUES ('1554',point(122   ,39.37 ),'辽宁省', '瓦房店', '122.000', '39.370');        
INSERT INTO `locationPoint` VALUES ('1555',point(120.41,40.37 ),'辽宁省', '兴城', '120.410', '40.370');          
INSERT INTO `locationPoint` VALUES ('1556',point(122.49,41.59 ),'辽宁省', '新民', '122.490', '41.590');          
INSERT INTO `locationPoint` VALUES ('1557',point(122.13,40.39 ),'辽宁省', '营口', '122.130', '40.390');          
INSERT INTO `locationPoint` VALUES ('1558',point(122.58,39.41 ),'辽宁省', '庄河', '122.580', '39.410');          
INSERT INTO `locationPoint` VALUES ('1559',point(101.48,36.38 ),'青海省', '西宁', '101.480', '36.380');          
INSERT INTO `locationPoint` VALUES ('1560',point(97.23 ,37.22 ),'青海省', '德令哈', '97.230', '37.220');         
INSERT INTO `locationPoint` VALUES ('1561',point(94.55 ,36.26 ),'青海省', '格尔木', '94.550', '36.260');         
INSERT INTO `locationPoint` VALUES ('1562',point(117   ,36.4  ),'山东省', '济南', '117.000', '36.400');          
INSERT INTO `locationPoint` VALUES ('1563',point(119.12,36.25 ),'山东省', '安丘', '119.120', '36.250');          
INSERT INTO `locationPoint` VALUES ('1564',point(118.02,37.22 ),'山东省', '滨州', '118.020', '37.220');          
INSERT INTO `locationPoint` VALUES ('1565',point(119.24,39.52 ),'山东省', '昌邑', '119.240', '39.520');          
INSERT INTO `locationPoint` VALUES ('1566',point(116.17,37.26 ),'山东省', '德州', '116.170', '37.260');          
INSERT INTO `locationPoint` VALUES ('1567',point(118.3 ,37.27 ),'山东省', '东营', '118.300', '37.270');          
INSERT INTO `locationPoint` VALUES ('1568',point(116.46,36.14 ),'山东省', '肥城', '116.460', '36.140');          
INSERT INTO `locationPoint` VALUES ('1569',point(119.44,36.22 ),'山东省', '高密', '119.440', '36.220');          
INSERT INTO `locationPoint` VALUES ('1570',point(115.26,35.14 ),'山东省', '菏泽', '115.260', '35.140');          
INSERT INTO `locationPoint` VALUES ('1571',point(119.58,35.53 ),'山东省', '胶南', '119.580', '35.530');          
INSERT INTO `locationPoint` VALUES ('1572',point(120   ,36.17 ),'山东省', '胶州', '120.000', '36.170');          
INSERT INTO `locationPoint` VALUES ('1573',point(120.28,36.22 ),'山东省', '即墨', '120.280', '36.220');          
INSERT INTO `locationPoint` VALUES ('1574',point(116.33,35.23 ),'山东省', '济宁', '116.330', '35.230');          
INSERT INTO `locationPoint` VALUES ('1575',point(117.4 ,36.12 ),'山东省', '莱芜', '117.400', '36.120');          
INSERT INTO `locationPoint` VALUES ('1576',point(120.31,36.52 ),'山东省', '莱西', '120.310', '36.520');          
INSERT INTO `locationPoint` VALUES ('1577',point(120.42,36.58 ),'山东省', '莱阳', '120.420', '36.580');          
INSERT INTO `locationPoint` VALUES ('1578',point(119.57,37.1  ),'山东省', '莱州', '119.570', '37.100');          
INSERT INTO `locationPoint` VALUES ('1579',point(117.12,37.44 ),'山东省', '乐陵', '117.120', '37.440');          
INSERT INTO `locationPoint` VALUES ('1580',point(115.57,36.26 ),'山东省', '聊城', '115.570', '36.260');          
INSERT INTO `locationPoint` VALUES ('1581',point(115.42,36.51 ),'山东省', '临清', '115.420', '36.510');          
INSERT INTO `locationPoint` VALUES ('1582',point(118.2 ,35.03 ),'山东省', '临沂', '118.200', '35.030');          
INSERT INTO `locationPoint` VALUES ('1583',point(120.21,37.39 ),'山东省', '龙口', '120.210', '37.390');          
INSERT INTO `locationPoint` VALUES ('1584',point(120.45,37.48 ),'山东省', '蓬莱', '120.450', '37.480');          
INSERT INTO `locationPoint` VALUES ('1585',point(119.58,36.47 ),'山东省', '平度', '119.580', '36.470');          
INSERT INTO `locationPoint` VALUES ('1586',point(120.18,36.03 ),'山东省', '青岛', '120.180', '36.030');          
INSERT INTO `locationPoint` VALUES ('1587',point(118.28,36.42 ),'山东省', '青州', '118.280', '36.420');          
INSERT INTO `locationPoint` VALUES ('1588',point(116.58,35.36 ),'山东省', '曲阜', '116.580', '35.360');          
INSERT INTO `locationPoint` VALUES ('1589',point(119.32,35.23 ),'山东省', '日照', '119.320', '35.230');          
INSERT INTO `locationPoint` VALUES ('1590',point(122.25,37.1  ),'山东省', '荣成', '122.250', '37.100');          
INSERT INTO `locationPoint` VALUES ('1591',point(121.31,36.54 ),'山东省', '乳山', '121.310', '36.540');          
INSERT INTO `locationPoint` VALUES ('1592',point(118.44,36.53 ),'山东省', '寿光', '118.440', '36.530');          
INSERT INTO `locationPoint` VALUES ('1593',point(117.08,36.11 ),'山东省', '泰安', '117.080', '36.110');          
INSERT INTO `locationPoint` VALUES ('1594',point(117.09,35.06 ),'山东省', '滕州', '117.090', '35.060');          
INSERT INTO `locationPoint` VALUES ('1595',point(119.06,36.43 ),'山东省', '潍坊', '119.060', '36.430');          
INSERT INTO `locationPoint` VALUES ('1596',point(122.07,37.31 ),'山东省', '威海', '122.070', '37.310');          
INSERT INTO `locationPoint` VALUES ('1597',point(122.03,37.12 ),'山东省', '文登', '122.030', '37.120');          
INSERT INTO `locationPoint` VALUES ('1598',point(117.45,35.54 ),'山东省', '新泰', '117.450', '35.540');          
INSERT INTO `locationPoint` VALUES ('1599',point(121.24,37.32 ),'山东省', '烟台', '121.240', '37.320');          
INSERT INTO `locationPoint` VALUES ('1600',point(116.49,35.32 ),'山东省', '兖州', '116.490', '35.320');          
INSERT INTO `locationPoint` VALUES ('1601',point(116.39,36.56 ),'山东省', '禹城', '116.390', '36.560');          
INSERT INTO `locationPoint` VALUES ('1602',point(117.33,34.52 ),'山东省', '枣庄', '117.330', '34.520');          
INSERT INTO `locationPoint` VALUES ('1603',point(117.32,36.43 ),'山东省', '章丘', '117.320', '36.430');          
INSERT INTO `locationPoint` VALUES ('1604',point(120.23,37.21 ),'山东省', '招远', '120.230', '37.210');          
INSERT INTO `locationPoint` VALUES ('1605',point(119.24,35.59 ),'山东省', '诸城', '119.240', '35.590');          
INSERT INTO `locationPoint` VALUES ('1606',point(118.03,36.48 ),'山东省', '淄博', '118.030', '36.480');          
INSERT INTO `locationPoint` VALUES ('1607',point(116.58,35.24 ),'山东省', '邹城', '116.580', '35.240');          
INSERT INTO `locationPoint` VALUES ('1608',point(112.33,37.54 ),'山西省', '太原', '112.330', '37.540');          
INSERT INTO `locationPoint` VALUES ('1609',point(113.06,36.11 ),'山西省', '长治', '113.060', '36.110');          
INSERT INTO `locationPoint` VALUES ('1610',point(113.17,40.06 ),'山西省', '大同', '113.170', '40.060');          
INSERT INTO `locationPoint` VALUES ('1611',point(112.55,35.48 ),'山西省', '高平', '112.550', '35.480');          
INSERT INTO `locationPoint` VALUES ('1612',point(112.09,37.54 ),'山西省', '古交', '112.090', '37.540');          
INSERT INTO `locationPoint` VALUES ('1613',point(110.41,35.35 ),'山西省', '河津', '110.410', '35.350');          
INSERT INTO `locationPoint` VALUES ('1614',point(111.21,35.37 ),'山西省', '侯马', '111.210', '35.370');          
INSERT INTO `locationPoint` VALUES ('1615',point(111.42,36.34 ),'山西省', '霍州', '111.420', '36.340');          
INSERT INTO `locationPoint` VALUES ('1616',point(111.55,37.02 ),'山西省', '介休', '111.550', '37.020');          
INSERT INTO `locationPoint` VALUES ('1617',point(112.51,35.3  ),'山西省', '晋城', '112.510', '35.300');          
INSERT INTO `locationPoint` VALUES ('1618',point(111.31,36.05 ),'山西省', '临汾', '111.310', '36.050');          
INSERT INTO `locationPoint` VALUES ('1619',point(113.14,36.21 ),'山西省', '潞城', '113.140', '36.210');          
INSERT INTO `locationPoint` VALUES ('1620',point(112.26,39.19 ),'山西省', '朔州', '112.260', '39.190');          
INSERT INTO `locationPoint` VALUES ('1621',point(111.48,37.08 ),'山西省', '孝义', '111.480', '37.080');          
INSERT INTO `locationPoint` VALUES ('1622',point(112.43,38.24 ),'山西省', '忻州', '112.430', '38.240');          
INSERT INTO `locationPoint` VALUES ('1623',point(113.34,37.51 ),'山西省', '阳泉', '113.340', '37.510');          
INSERT INTO `locationPoint` VALUES ('1624',point(110.27,34.52 ),'山西省', '永济', '110.270', '34.520');          
INSERT INTO `locationPoint` VALUES ('1625',point(112.42,38.43 ),'山西省', '原平', '112.420', '38.430');          
INSERT INTO `locationPoint` VALUES ('1626',point(112.43,37.41 ),'山西省', '榆次', '112.430', '37.410');          
INSERT INTO `locationPoint` VALUES ('1627',point(110.59,35.02 ),'山西省', '运城', '110.590', '35.020');          
INSERT INTO `locationPoint` VALUES ('1628',point(108.57,34.17 ),'陕西省', '西安', '108.570', '34.170');          
INSERT INTO `locationPoint` VALUES ('1629',point(109.01,32.41 ),'陕西省', '安康', '109.010', '32.410');          
INSERT INTO `locationPoint` VALUES ('1630',point(107.09,34.22 ),'陕西省', '宝鸡', '107.090', '34.220');          
INSERT INTO `locationPoint` VALUES ('1631',point(110.27,35.28 ),'陕西省', '韩城', '110.270', '35.280');          
INSERT INTO `locationPoint` VALUES ('1632',point(107.01,33.04 ),'陕西省', '汉中', '107.010', '33.040');          
INSERT INTO `locationPoint` VALUES ('1633',point(110.05,34.34 ),'陕西省', '华阴', '110.050', '34.340');          
INSERT INTO `locationPoint` VALUES ('1634',point(109.57,33.52 ),'陕西省', '商州', '109.570', '33.520');          
INSERT INTO `locationPoint` VALUES ('1635',point(109.07,35.06 ),'陕西省', '铜川', '109.070', '35.060');          
INSERT INTO `locationPoint` VALUES ('1636',point(109.3 ,34.3  ),'陕西省', '渭南', '109.300', '34.300');          
INSERT INTO `locationPoint` VALUES ('1637',point(108.43,34.2  ),'陕西省', '咸阳', '108.430', '34.200');          
INSERT INTO `locationPoint` VALUES ('1638',point(108.29,34.18 ),'陕西省', '兴平', '108.290', '34.180');          
INSERT INTO `locationPoint` VALUES ('1639',point(109.28,36.35 ),'陕西省', '延安', '109.280', '36.350');          
INSERT INTO `locationPoint` VALUES ('1640',point(109.47,38.18 ),'陕西省', '榆林', '109.470', '38.180');          
INSERT INTO `locationPoint` VALUES ('1641',point(104.04,30.4  ),'四川省', '成都', '104.040', '30.400');          
INSERT INTO `locationPoint` VALUES ('1642',point(106.43,31.51 ),'四川省', '巴中', '106.430', '31.510');          
INSERT INTO `locationPoint` VALUES ('1643',point(103.4 ,30.39 ),'四川省', '崇州', '103.400', '30.390');          
INSERT INTO `locationPoint` VALUES ('1644',point(107.29,31.14 ),'四川省', '达川', '107.290', '31.140');          
INSERT INTO `locationPoint` VALUES ('1645',point(104.22,31.09 ),'四川省', '德阳', '104.220', '31.090');          
INSERT INTO `locationPoint` VALUES ('1646',point(103.37,31.01 ),'四川省', '都江堰', '103.370', '31.010');        
INSERT INTO `locationPoint` VALUES ('1647',point(103.29,29.36 ),'四川省', '峨眉山', '103.290', '29.360');        
INSERT INTO `locationPoint` VALUES ('1648',point(107.22,29.42 ),'四川省', '涪陵', '107.220', '29.420');          
INSERT INTO `locationPoint` VALUES ('1649',point(104.15,30.58 ),'四川省', '广汉', '104.150', '30.580');          
INSERT INTO `locationPoint` VALUES ('1650',point(105.51,32.28 ),'四川省', '广元', '105.510', '32.280');          
INSERT INTO `locationPoint` VALUES ('1651',point(106.44,30.26 ),'四川省', '华蓥', '106.440', '30.260');          
INSERT INTO `locationPoint` VALUES ('1652',point(104.32,30.24 ),'四川省', '简阳', '104.320', '30.240');          
INSERT INTO `locationPoint` VALUES ('1653',point(104.42,31.48 ),'四川省', '江油', '104.420', '31.480');          
INSERT INTO `locationPoint` VALUES ('1654',point(105.58,31.36 ),'四川省', '阆中', '105.580', '31.360');          
INSERT INTO `locationPoint` VALUES ('1655',point(103.44,29.36 ),'四川省', '乐山', '103.440', '29.360');          
INSERT INTO `locationPoint` VALUES ('1656',point(105.24,28.54 ),'四川省', '泸州', '105.240', '28.540');          
INSERT INTO `locationPoint` VALUES ('1657',point(104.42,31.3  ),'四川省', '绵阳', '104.420', '31.300');          
INSERT INTO `locationPoint` VALUES ('1658',point(106.04,30.49 ),'四川省', '南充', '106.040', '30.490');          
INSERT INTO `locationPoint` VALUES ('1659',point(105.02,29.36 ),'四川省', '内江', '105.020', '29.360');          
INSERT INTO `locationPoint` VALUES ('1660',point(101.43,26.34 ),'四川省', '攀枝花', '101.430', '26.340');        
INSERT INTO `locationPoint` VALUES ('1661',point(103.57,30.59 ),'四川省', '彭州', '103.570', '30.590');          
INSERT INTO `locationPoint` VALUES ('1662',point(103.28,30.26 ),'四川省', '邛崃', '103.280', '30.260');          
INSERT INTO `locationPoint` VALUES ('1663',point(105.33,30.31 ),'四川省', '遂宁', '105.330', '30.310');          
INSERT INTO `locationPoint` VALUES ('1664',point(108.21,30.5  ),'四川省', '万县', '108.210', '30.500');          
INSERT INTO `locationPoint` VALUES ('1665',point(108.03,32.03 ),'四川省', '万源', '108.030', '32.030');          
INSERT INTO `locationPoint` VALUES ('1666',point(102.16,27.54 ),'四川省', '西昌', '102.160', '27.540');          
INSERT INTO `locationPoint` VALUES ('1667',point(102.59,29.59 ),'四川省', '雅安', '102.590', '29.590');          
INSERT INTO `locationPoint` VALUES ('1668',point(104.34,28.47 ),'四川省', '宜宾', '104.340', '28.470');          
INSERT INTO `locationPoint` VALUES ('1669',point(104.46,29.23 ),'四川省', '自贡', '104.460', '29.230');          
INSERT INTO `locationPoint` VALUES ('1670',point(104.38,30.09 ),'四川省', '资阳', '104.380', '30.090');          
INSERT INTO `locationPoint` VALUES ('1671',point(121.3 ,25.03 ),'台湾省', '台北', '121.300', '25.030');          
INSERT INTO `locationPoint` VALUES ('1672',point(102.42,25.04 ),'云南省', '昆明', '102.420', '25.040');          
INSERT INTO `locationPoint` VALUES ('1673',point(99.1  ,25.08 ),'云南省', '保山', '99.100', '25.080');           
INSERT INTO `locationPoint` VALUES ('1674',point(101.32,25.01 ),'云南省', '楚雄', '101.320', '25.010');          
INSERT INTO `locationPoint` VALUES ('1675',point(100.13,25.34 ),'云南省', '大理', '100.130', '25.340');          
INSERT INTO `locationPoint` VALUES ('1676',point(103.12,26.06 ),'云南省', '东川', '103.120', '26.060');          
INSERT INTO `locationPoint` VALUES ('1677',point(103.09,23.21 ),'云南省', '个旧', '103.090', '23.210');          
INSERT INTO `locationPoint` VALUES ('1678',point(100.48,22.01 ),'云南省', '景洪', '100.480', '22.010');          
INSERT INTO `locationPoint` VALUES ('1679',point(103.13,23.43 ),'云南省', '开远', '103.130', '23.430');          
INSERT INTO `locationPoint` VALUES ('1680',point(103.48,25.3  ),'云南省', '曲靖', '103.480', '25.300');          
INSERT INTO `locationPoint` VALUES ('1681',point(97.5  ,24    ),'云南省', '瑞丽', '97.500', '24.000');           
INSERT INTO `locationPoint` VALUES ('1682',point(100.58,22.48 ),'云南省', '思茅', '100.580', '22.480');          
INSERT INTO `locationPoint` VALUES ('1683',point(98.04 ,24.06 ),'云南省', '畹町', '98.040', '24.060');           
INSERT INTO `locationPoint` VALUES ('1684',point(104.06,26.13 ),'云南省', '宣威', '104.060', '26.130');          
INSERT INTO `locationPoint` VALUES ('1685',point(102.32,24.22 ),'云南省', '玉溪', '102.320', '24.220');          
INSERT INTO `locationPoint` VALUES ('1686',point(103.42,27.2  ),'云南省', '昭通', '103.420', '27.200');          
INSERT INTO `locationPoint` VALUES ('1687',point(120.1 ,30.16 ),'浙江省', '杭州', '120.100', '30.160');          
INSERT INTO `locationPoint` VALUES ('1688',point(121.15,30.11 ),'浙江省', '慈溪', '121.150', '30.110');          
INSERT INTO `locationPoint` VALUES ('1689',point(120.14,29.16 ),'浙江省', '东阳', '120.140', '29.160');          
INSERT INTO `locationPoint` VALUES ('1690',point(121.24,29.39 ),'浙江省', '奉化', '121.240', '29.390');          
INSERT INTO `locationPoint` VALUES ('1691',point(119.57,30.03 ),'浙江省', '富阳', '119.570', '30.030');          
INSERT INTO `locationPoint` VALUES ('1692',point(120.42,30.32 ),'浙江省', '海宁', '120.420', '30.320');          
INSERT INTO `locationPoint` VALUES ('1693',point(120.06,30.52 ),'浙江省', '湖州', '120.060', '30.520');          
INSERT INTO `locationPoint` VALUES ('1694',point(119.16,29.29 ),'浙江省', '建德', '119.160', '29.290');          
INSERT INTO `locationPoint` VALUES ('1695',point(118.37,28.45 ),'浙江省', '江山', '118.370', '28.450');          
INSERT INTO `locationPoint` VALUES ('1696',point(120.45,30.46 ),'浙江省', '嘉兴', '120.450', '30.460');          
INSERT INTO `locationPoint` VALUES ('1697',point(119.39,29.07 ),'浙江省', '金华', '119.390', '29.070');          
INSERT INTO `locationPoint` VALUES ('1698',point(119.28,29.12 ),'浙江省', '兰溪', '119.280', '29.120');          
INSERT INTO `locationPoint` VALUES ('1699',point(121.08,28.51 ),'浙江省', '临海', '121.080', '28.510');          
INSERT INTO `locationPoint` VALUES ('1700',point(119.54,28.27 ),'浙江省', '丽水', '119.540', '28.270');          
INSERT INTO `locationPoint` VALUES ('1701',point(119.08,28.04 ),'浙江省', '龙泉', '119.080', '28.040');          
INSERT INTO `locationPoint` VALUES ('1702',point(121.33,29.52 ),'浙江省', '宁波', '121.330', '29.520');          
INSERT INTO `locationPoint` VALUES ('1703',point(121.01,30.42 ),'浙江省', '平湖', '121.010', '30.420');          
INSERT INTO `locationPoint` VALUES ('1704',point(118.52,28.58 ),'浙江省', '衢州', '118.520', '28.580');          
INSERT INTO `locationPoint` VALUES ('1705',point(120.38,27.48 ),'浙江省', '瑞安', '120.380', '27.480');          
INSERT INTO `locationPoint` VALUES ('1706',point(120.52,30.01 ),'浙江省', '上虞', '120.520', '30.010');          
INSERT INTO `locationPoint` VALUES ('1707',point(120.34,30    ),'浙江省', '绍兴', '120.340', '30.000');          
INSERT INTO `locationPoint` VALUES ('1708',point(121.27,28.41 ),'浙江省', '台州', '121.270', '28.410');          
INSERT INTO `locationPoint` VALUES ('1709',point(120.32,30.38 ),'浙江省', '桐乡', '120.320', '30.380');          
INSERT INTO `locationPoint` VALUES ('1710',point(121.21,28.22 ),'浙江省', '温岭', '121.210', '28.220');          
INSERT INTO `locationPoint` VALUES ('1711',point(120.39,28.01 ),'浙江省', '温州', '120.390', '28.010');          
INSERT INTO `locationPoint` VALUES ('1712',point(120.16,30.09 ),'浙江省', '萧山', '120.160', '30.090');          
INSERT INTO `locationPoint` VALUES ('1713',point(120.04,29.18 ),'浙江省', '义乌', '120.040', '29.180');          
INSERT INTO `locationPoint` VALUES ('1714',point(120.58,28.08 ),'浙江省', '乐清', '120.580', '28.080');          
INSERT INTO `locationPoint` VALUES ('1715',point(120.18,30.26 ),'浙江省', '余杭', '120.180', '30.260');          
INSERT INTO `locationPoint` VALUES ('1716',point(121.1 ,30.02 ),'浙江省', '余姚', '121.100', '30.020');          
INSERT INTO `locationPoint` VALUES ('1717',point(120.01,29.54 ),'浙江省', '永康', '120.010', '29.540');          
INSERT INTO `locationPoint` VALUES ('1718',point(122.06,30.01 ),'浙江省', '舟山', '122.060', '30.010');          
INSERT INTO `locationPoint` VALUES ('1719',point(120.14,29.43 ),'浙江省', '诸暨', '120.140', '29.430');          
INSERT INTO `locationPoint` VALUES ('1720',point(106.33,29.35 ),'重庆市', '重庆', '106.330', '29.350');          
INSERT INTO `locationPoint` VALUES ('1721',point(106.15,30.02 ),'重庆市', '合川', '106.150', '30.020');          
INSERT INTO `locationPoint` VALUES ('1722',point(106.16,29.18 ),'重庆市', '江津', '106.160', '29.180');          
INSERT INTO `locationPoint` VALUES ('1723',point(107.05,29.1  ),'重庆市', '南川', '107.050', '29.100');          
INSERT INTO `locationPoint` VALUES ('1724',point(105.53,29.23 ),'重庆市', '永川', '105.530', '29.230');          
INSERT INTO `locationPoint` VALUES ('1725',point(116.24,39.55 ),'北京市', '北京', '116.240', '39.550');          
INSERT INTO `locationPoint` VALUES ('1726',point(117.12,39.02 ),'天津市', '天津', '117.120', '39.020');          
INSERT INTO `locationPoint` VALUES ('1727',point(121.29,31.14 ),'上海市', '上海', '121.290', '31.140');          
INSERT INTO `locationPoint` VALUES ('1728',point(21.23 ,115.12),'香港', '香港', '21.230', '115.120');            
INSERT INTO `locationPoint` VALUES ('1729',point(21.33 ,115.07),'澳门', '澳门', '21.330', '115.070');            
INSERT INTO `locationPoint` VALUES ('1730',point(91.08 ,29.39 ),'西藏自治区', '拉萨', '91.080', '29.390');       
INSERT INTO `locationPoint` VALUES ('1731',point(88.51 ,29.16 ),'西藏自治区', '日喀则', '88.510', '29.160');     
INSERT INTO `locationPoint` VALUES ('1732',point(111.41,40.48 ),'内蒙古自治区', '呼和浩特', '111.410', '40.480');
INSERT INTO `locationPoint` VALUES ('1733',point(109.49,40.39 ),'内蒙古自治区', '包头', '109.490', '40.390');    
INSERT INTO `locationPoint` VALUES ('1734',point(118.58,42.17 ),'内蒙古自治区', '赤峰', '118.580', '42.170');    
INSERT INTO `locationPoint` VALUES ('1735',point(109.59,39.48 ),'内蒙古自治区', '东胜', '109.590', '39.480');    
INSERT INTO `locationPoint` VALUES ('1736',point(111.58,43.38 ),'内蒙古自治区', '二连浩特', '111.580', '43.380');
INSERT INTO `locationPoint` VALUES ('1737',point(120.11,50.13 ),'内蒙古自治区', '额尔古纳', '120.110', '50.130');
INSERT INTO `locationPoint` VALUES ('1738',point(113.09,40.27 ),'内蒙古自治区', '丰镇', '113.090', '40.270');    
INSERT INTO `locationPoint` VALUES ('1739',point(121.29,50.48 ),'内蒙古自治区', '根河', '121.290', '50.480');    
INSERT INTO `locationPoint` VALUES ('1740',point(119.39,49.12 ),'内蒙古自治区', '海拉尔', '119.390', '49.120');  
INSERT INTO `locationPoint` VALUES ('1741',point(119.38,45.32 ),'内蒙古自治区', '霍林郭勒', '119.380', '45.320');
INSERT INTO `locationPoint` VALUES ('1742',point(113.06,41.02 ),'内蒙古自治区', '集宁', '113.060', '41.020');    
INSERT INTO `locationPoint` VALUES ('1743',point(107.22,40.46 ),'内蒙古自治区', '临河', '107.220', '40.460');    
INSERT INTO `locationPoint` VALUES ('1744',point(117.23,49.35 ),'内蒙古自治区', '满洲里', '117.230', '49.350');  
INSERT INTO `locationPoint` VALUES ('1745',point(122.16,43.37 ),'内蒙古自治区', '通辽', '122.160', '43.370');    
INSERT INTO `locationPoint` VALUES ('1746',point(122.03,46.03 ),'内蒙古自治区', '乌兰浩特', '122.030', '46.030');
INSERT INTO `locationPoint` VALUES ('1747',point(106.48,39.4  ),'内蒙古自治区', '乌海', '106.480', '39.400');    
INSERT INTO `locationPoint` VALUES ('1748',point(116.03,43.57 ),'内蒙古自治区', '锡林浩特', '116.030', '43.570');
INSERT INTO `locationPoint` VALUES ('1749',point(120.4 ,49.17 ),'内蒙古自治区', '牙克石', '120.400', '49.170');  
INSERT INTO `locationPoint` VALUES ('1750',point(122.47,48    ),'内蒙古自治区', '扎兰屯', '122.470', '48.000');  
INSERT INTO `locationPoint` VALUES ('1751',point(106.16,38.27 ),'宁夏自治区', '银川', '106.160', '38.270');      
INSERT INTO `locationPoint` VALUES ('1752',point(105.59,37.56 ),'宁夏自治区', '青铜峡', '105.590', '37.560');    
INSERT INTO `locationPoint` VALUES ('1753',point(106.22,39.02 ),'宁夏自治区', '石嘴山', '106.220', '39.020');    
INSERT INTO `locationPoint` VALUES ('1754',point(106.11,37.59 ),'宁夏自治区', '吴忠', '106.110', '37.590');      
INSERT INTO `locationPoint` VALUES ('1755',point(87.36 ,43.45 ),'新疆自治区', '乌鲁木齐', '87.360', '43.450');   
INSERT INTO `locationPoint` VALUES ('1756',point(80.19 ,41.09 ),'新疆自治区', '阿克苏', '80.190', '41.090');     
INSERT INTO `locationPoint` VALUES ('1757',point(88.12 ,47.5  ),'新疆自治区', '阿勒泰', '88.120', '47.500');     
INSERT INTO `locationPoint` VALUES ('1758',point(76.08 ,39.42 ),'新疆自治区', '阿图什', '76.080', '39.420');     
INSERT INTO `locationPoint` VALUES ('1759',point(82.08 ,44.57 ),'新疆自治区', '博乐', '82.080', '44.570');       
INSERT INTO `locationPoint` VALUES ('1760',point(87.18 ,44.02 ),'新疆自治区', '昌吉', '87.180', '44.020');       
INSERT INTO `locationPoint` VALUES ('1761',point(87.58 ,44.09 ),'新疆自治区', '阜康', '87.580', '44.090');       
INSERT INTO `locationPoint` VALUES ('1762',point(93.28 ,42.5  ),'新疆自治区', '哈密', '93.280', '42.500');       
INSERT INTO `locationPoint` VALUES ('1763',point(79.55 ,37.09 ),'新疆自治区', '和田', '79.550', '37.090');       
INSERT INTO `locationPoint` VALUES ('1764',point(84.51 ,45.36 ),'新疆自治区', '克拉玛依', '84.510', '45.360');   
INSERT INTO `locationPoint` VALUES ('1765',point(75.59 ,39.3  ),'新疆自治区', '喀什', '75.590', '39.300');       
INSERT INTO `locationPoint` VALUES ('1766',point(86.07 ,41.46 ),'新疆自治区', '库尔勒', '86.070', '41.460');     
INSERT INTO `locationPoint` VALUES ('1767',point(84.56 ,44.27 ),'新疆自治区', '奎屯', '84.560', '44.270');       
INSERT INTO `locationPoint` VALUES ('1768',point(86    ,44.18 ),'新疆自治区', '石河子', '86.000', '44.180');     
INSERT INTO `locationPoint` VALUES ('1769',point(82.59 ,46.46 ),'新疆自治区', '塔城', '82.590', '46.460');       
INSERT INTO `locationPoint` VALUES ('1770',point(89.11 ,42.54 ),'新疆自治区', '吐鲁番', '89.110', '42.540');     
INSERT INTO `locationPoint` VALUES ('1771',point(81.2  ,43.55 ),'新疆自治区', '伊宁', '81.200', '43.550');







==============以下为单纯sql语句实现===================================

LBS 太火了,突然想考虑一下技术实现,附近的XX,网上有很多解决方案,今天只考虑使用Mysql数据库的实现,废话不多说,直接上sql语句:

    

select * from city where LAT > '34.7466'-1 and LAT < '34.7466'+1 and LNG > '113.625368'-1 and LNG < '113.625368'+1 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');



附上相关链接: http://www.infoq.com/cn/articles/depth-study-of-Symfony2

© 著作权归作者所有

共有 人打赏支持
alexgaoyh

alexgaoyh

粉丝 76
博文 82
码字总数 65212
作品 1
郑州
后端工程师
私信 提问
加载中

评论(5)

如梦技术
如梦技术
先收藏一个,虽然没看懂,但是感觉好厉害的样子。
alexgaoyh
alexgaoyh

引用来自“foxlee”的评论

mysql是支持空间数据的,你这样查询效率太低了,可以利用空间数据和空间函数进行运算

恩,谢谢,看到有数据空间的解决方案,但是不是特别了解,就没写相关文字,后期看懂了会补上。。哇嘎嘎。。
alexgaoyh
alexgaoyh

引用来自“小昭归来”的评论

用mysql效率如何呢

效率不是特别高,可以使用非mysql的方式。。刚刚考虑具体实现,就先选择mysql了。。
foxlee
foxlee
mysql是支持空间数据的,你这样查询效率太低了,可以利用空间数据和空间函数进行运算
小昭归来
小昭归来
用mysql效率如何呢
第三方天气API

全国天气预报查询_免费版 30分钟更新一次。免费版限制并发1秒1次,可根据地名、经纬度GPS、IP查询对应地区的预报。包括7日天气、预警、PM 2.5空气质量指数,穿衣、出行、洗车等生活指数。4万...

半月庄主
2017/03/10
1
0
关于mysql和hadoop数据交互的问题,和hadoop的文件夹设计

关于mysql和hadoop数据交互的问题,和hadoop的文件夹设计 目前mysql按地区,商业区区分,假设读取mysql数据库的地区,根据地区划分 我昨天和领导沟通了,领导说点击率不是必要条件,地区划分...

知行合一1
2016/03/23
118
0
lbs中从库中查询某经纬度2KM范围内的数据

sql语句查询经纬度范围 指定一个经纬度,给定一个范围值(单位:千米),查出在经纬度周围这个范围内的数据。 经度:113.914619 纬度:22.50128 范围:2km longitude为数据表经度字段 latitude为数...

laserdance
2012/02/16
0
1
几个地理位置信息处理方案的对比和分析

对于任何LBS应用来说,让用户寻找周围的好友可能都是一个必不可少的功能,我们就以这个功能为例,来看看各种处理方案之间的差异和区别。 我们假设有如下功能需求: 显示我附近的人由近到远排...

javaer
2018/05/11
0
0
再提LBS经纬度搜索和距离排序,求更优方案

再提LBS经纬度搜索和距离排序,求更优方案 1赞踩收藏 一直在琢磨LBS,期待可以发现更好的方案。现在纠结了。 简单列举一下已经了解到的方案: 1.sphinx geo索引 2.mongodb geo索引 3.MySQL ...

飓风2000
2016/08/04
40
1

没有更多内容

加载失败,请刷新页面

加载更多

记录replugin使用的一个坑

反复编译插件放入宿主中,一直出现如下错误: android.content.res.Resources$NotFoundException: Resource ID #0x7f050000 type #0x5 is not valid 回滚代码,重启AS还是出错。最终发现将宿...

Gemini-Lin
今天
1
0
Vert.x系列(二)--EventBusImpl源码分析

前言:Vert.x 实现了2种完成不同的eventBus: EventBusImpl(A local event bus implementation)和 它的子类 ClusteredEventBus(An event bus implementation that clusters with other Ve......

冷基
今天
1
0
Perl - 获取文件项目

参考:http://www.runoob.com/perl/perl-directories.html 下面返回JSON格式的文件列表 #!/usr/bin/perluse strict;use warnings;use utf8;use feature ':5.26';require Fi......

wffger
昨天
2
0
vue组件系列3、查询下载

直接源码,虽然样式样式不好看,逻辑也不是最优,但是可以留作纪念。毕竟以后类似的功能只需要优化就可以了,不用每次都重头开始。。。 <template> <div class="pre_upload"> <div ...

轻轻的往前走
昨天
2
0
java浅复制和深复制

之前写了数组的复制,所以这里继续总结一下浅复制和深复制。 浅拷贝:对基本数据类型进行值传递,对引用数据类型进行引用传递般的拷贝。 深拷贝:对基本数据类型进行值传递,对引用数据类型,...

woshixin
昨天
2
0

没有更多内容

加载失败,请刷新页面

加载更多

返回顶部
顶部