Mysql 地区经纬度 查询
摘要: Mysql数据库,根据地区的经纬度信息,查询附近相邻的地区
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' 是 河南省郑州市 的经纬度信息,查询结果如下图:
附上相关链接: http://www.infoq.com/cn/articles/depth-study-of-Symfony2
来源:
https://my.oschina.net/alexgaoyh/blog/392123