Mysql 地区经纬度 查询

时间:2022-04-21 02:27:11

摘要: 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() NOT NULL,
pt point not null,
`province` varchar() NOT NULL,
`city` varchar() NOT NULL,
`longitude` double(,) NOT NULL,
`latitude` double(,) NOT NULL,
PRIMARY KEY (`id`)
)engine=Myisam; INSERT INTO `locationPoint` VALUES ('',point(117.17,31.52 ),'安徽省', '合肥', '117.170', '31.520');
INSERT INTO `locationPoint` VALUES ('',point(117.02,30.31 ),'安徽省', '安庆', '117.020', '30.310');
INSERT INTO `locationPoint` VALUES ('',point(117.21,32.56 ),'安徽省', '蚌埠', '117.210', '32.560');
INSERT INTO `locationPoint` VALUES ('',point(115.47,33.52 ),'安徽省', '亳州', '115.470', '33.520');
INSERT INTO `locationPoint` VALUES ('',point(117.52,31.36 ),'安徽省', '巢湖', '117.520', '31.360');
INSERT INTO `locationPoint` VALUES ('',point(118.18,32.18 ),'安徽省', '滁州', '118.180', '32.180');
INSERT INTO `locationPoint` VALUES ('',point(115.48,32.54 ),'安徽省', '阜阳', '115.480', '32.540');
INSERT INTO `locationPoint` VALUES ('',point(117.28,30.39 ),'安徽省', '贵池', '117.280', '30.390');
INSERT INTO `locationPoint` VALUES ('',point(116.47,33.57 ),'安徽省', '淮北', '116.470', '33.570');
INSERT INTO `locationPoint` VALUES ('',point(116.58,32.37 ),'安徽省', '淮南', '116.580', '32.370');
INSERT INTO `locationPoint` VALUES ('',point(118.18,29.43 ),'安徽省', '黄山', '118.180', '29.430');
INSERT INTO `locationPoint` VALUES ('',point(115.21,33.15 ),'安徽省', '界首', '115.210', '33.150');
INSERT INTO `locationPoint` VALUES ('',point(116.28,31.44 ),'安徽省', '六安', '116.280', '31.440');
INSERT INTO `locationPoint` VALUES ('',point(118.28,31.43 ),'安徽省', '马鞍山', '118.280', '31.430');
INSERT INTO `locationPoint` VALUES ('',point(117.58,32.47 ),'安徽省', '明光', '117.580', '32.470');
INSERT INTO `locationPoint` VALUES ('',point(116.58,33.38 ),'安徽省', '宿州', '116.580', '33.380');
INSERT INTO `locationPoint` VALUES ('',point(118.59,32.41 ),'安徽省', '天长', '118.590', '32.410');
INSERT INTO `locationPoint` VALUES ('',point(117.48,30.56 ),'安徽省', '铜陵', '117.480', '30.560');
INSERT INTO `locationPoint` VALUES ('',point(118.22,31.19 ),'安徽省', '芜湖', '118.220', '31.190');
INSERT INTO `locationPoint` VALUES ('',point(118.44,30.57 ),'安徽省', '宣州', '118.440', '30.570');
INSERT INTO `locationPoint` VALUES ('',point(119.18,26.05 ),'福建省', '福州', '119.180', '26.050');
INSERT INTO `locationPoint` VALUES ('',point(119.31,25.58 ),'福建省', '长乐', '119.310', '25.580');
INSERT INTO `locationPoint` VALUES ('',point(119.39,27.06 ),'福建省', '福安', '119.390', '27.060');
INSERT INTO `locationPoint` VALUES ('',point(119.23,25.42 ),'福建省', '福清', '119.230', '25.420');
INSERT INTO `locationPoint` VALUES ('',point(118.2 ,27.03 ),'福建省', '建瓯', '118.200', '27.030');
INSERT INTO `locationPoint` VALUES ('',point(118.07,27.21 ),'福建省', '建阳', '118.070', '27.210');
INSERT INTO `locationPoint` VALUES ('',point(118.35,24.49 ),'福建省', '晋江', '118.350', '24.490');
INSERT INTO `locationPoint` VALUES ('',point(117.48,24.26 ),'福建省', '龙海', '117.480', '24.260');
INSERT INTO `locationPoint` VALUES ('',point(117.01,25.06 ),'福建省', '龙岩', '117.010', '25.060');
INSERT INTO `locationPoint` VALUES ('',point(118.23,24.57 ),'福建省', '南安', '118.230', '24.570');
INSERT INTO `locationPoint` VALUES ('',point(118.1 ,26.38 ),'福建省', '南平', '118.100', '26.380');
INSERT INTO `locationPoint` VALUES ('',point(119.31,26.39 ),'福建省', '宁德', '119.310', '26.390');
INSERT INTO `locationPoint` VALUES ('',point(119.01,24.26 ),'福建省', '莆田', '119.010', '24.260');
INSERT INTO `locationPoint` VALUES ('',point(118.36,24.56 ),'福建省', '泉州', '118.360', '24.560');
INSERT INTO `locationPoint` VALUES ('',point(117.36,26.13 ),'福建省', '三明', '117.360', '26.130');
INSERT INTO `locationPoint` VALUES ('',point(117.29,27.2 ),'福建省', '邵武', '117.290', '27.200');
INSERT INTO `locationPoint` VALUES ('',point(118.38,24.44 ),'福建省', '石狮', '118.380', '24.440');
INSERT INTO `locationPoint` VALUES ('',point(118.02,27.46 ),'福建省', '武夷山', '118.020', '27.460');
INSERT INTO `locationPoint` VALUES ('',point(118.06,24.27 ),'福建省', '厦门', '118.060', '24.270');
INSERT INTO `locationPoint` VALUES ('',point(117.23,25.58 ),'福建省', '永安', '117.230', '25.580');
INSERT INTO `locationPoint` VALUES ('',point(117.24,25.17 ),'福建省', '漳平', '117.240', '25.170');
INSERT INTO `locationPoint` VALUES ('',point(117.39,24.31 ),'福建省', '漳州', '117.390', '24.310');
INSERT INTO `locationPoint` VALUES ('',point(103.51,36.04 ),'甘肃省', '兰州', '103.510', '36.040');
INSERT INTO `locationPoint` VALUES ('',point(104.12,36.33 ),'甘肃省', '白银', '104.120', '36.330');
INSERT INTO `locationPoint` VALUES ('',point(94.41 ,40.08 ),'甘肃省', '敦煌', '94.410', '40.080');
INSERT INTO `locationPoint` VALUES ('',point(98.14 ,39.48 ),'甘肃省', '嘉峪关', '98.140', '39.480');
INSERT INTO `locationPoint` VALUES ('',point(102.1 ,38.28 ),'甘肃省', '金昌', '102.100', '38.280');
INSERT INTO `locationPoint` VALUES ('',point(98.31 ,39.44 ),'甘肃省', '酒泉', '98.310', '39.440');
INSERT INTO `locationPoint` VALUES ('',point(103.12,35.37 ),'甘肃省', '临夏', '103.120', '35.370');
INSERT INTO `locationPoint` VALUES ('',point(106.4 ,35.32 ),'甘肃省', '平凉', '106.400', '35.320');
INSERT INTO `locationPoint` VALUES ('',point(105.42,34.37 ),'甘肃省', '天水', '105.420', '34.370');
INSERT INTO `locationPoint` VALUES ('',point(102.39,37.56 ),'甘肃省', '武威', '102.390', '37.560');
INSERT INTO `locationPoint` VALUES ('',point(107.4 ,35.45 ),'甘肃省', '西峰', '107.400', '35.450');
INSERT INTO `locationPoint` VALUES ('',point(97.35 ,39.49 ),'甘肃省', '玉门', '97.350', '39.490');
INSERT INTO `locationPoint` VALUES ('',point(100.26,38.56 ),'甘肃省', '张掖', '100.260', '38.560');
INSERT INTO `locationPoint` VALUES ('',point(113.14,23.08 ),'广东省', '广州', '113.140', '23.080');
INSERT INTO `locationPoint` VALUES ('',point(116.36,23.16 ),'广东省', '潮阳', '116.360', '23.160');
INSERT INTO `locationPoint` VALUES ('',point(116.38,23.4 ),'广东省', '潮州', '116.380', '23.400');
INSERT INTO `locationPoint` VALUES ('',point(116.46,23.28 ),'广东省', '澄海', '116.460', '23.280');
INSERT INTO `locationPoint` VALUES ('',point(113.33,23.33 ),'广东省', '从化', '113.330', '23.330');
INSERT INTO `locationPoint` VALUES ('',point(113.45,23.02 ),'广东省', '东莞', '113.450', '23.020');
INSERT INTO `locationPoint` VALUES ('',point(112.19,22.12 ),'广东省', '恩平', '112.190', '22.120');
INSERT INTO `locationPoint` VALUES ('',point(113.06,23.02 ),'广东省', '佛山', '113.060', '23.020');
INSERT INTO `locationPoint` VALUES ('',point(112.5 ,22.53 ),'广东省', '高明', '112.500', '22.530');
INSERT INTO `locationPoint` VALUES ('',point(112.26,23.02 ),'广东省', '高要', '112.260', '23.020');
INSERT INTO `locationPoint` VALUES ('',point(110.5 ,21.54 ),'广东省', '高州', '110.500', '21.540');
INSERT INTO `locationPoint` VALUES ('',point(112.57,22.46 ),'广东省', '鹤山', '112.570', '22.460');
INSERT INTO `locationPoint` VALUES ('',point(114.41,23.43 ),'广东省', '河源', '114.410', '23.430');
INSERT INTO `locationPoint` VALUES ('',point(113.12,23.23 ),'广东省', '花都', '113.120', '23.230');
INSERT INTO `locationPoint` VALUES ('',point(110.37,21.39 ),'广东省', '化州', '110.370', '21.390');
INSERT INTO `locationPoint` VALUES ('',point(114.28,22.48 ),'广东省', '惠阳', '114.280', '22.480');
INSERT INTO `locationPoint` VALUES ('',point(114.22,23.05 ),'广东省', '惠州', '114.220', '23.050');
INSERT INTO `locationPoint` VALUES ('',point(113.04,22.35 ),'广东省', '江门', '113.040', '22.350');
INSERT INTO `locationPoint` VALUES ('',point(116.21,22.32 ),'广东省', '揭阳', '116.210', '22.320');
INSERT INTO `locationPoint` VALUES ('',point(112.4 ,22.22 ),'广东省', '开平', '112.400', '22.220');
INSERT INTO `locationPoint` VALUES ('',point(113.21,25.09 ),'广东省', '乐昌', '113.210', '25.090');
INSERT INTO `locationPoint` VALUES ('',point(110.04,20.54 ),'广东省', '雷州', '110.040', '20.540');
INSERT INTO `locationPoint` VALUES ('',point(110.17,21.37 ),'广东省', '廉江', '110.170', '21.370');
INSERT INTO `locationPoint` VALUES ('',point(112.23,24.48 ),'广东省', '连州', '112.230', '24.480');
INSERT INTO `locationPoint` VALUES ('',point(111.33,22.46 ),'广东省', '罗定', '111.330', '22.460');
INSERT INTO `locationPoint` VALUES ('',point(110.53,21.4 ),'广东省', '茂名', '110.530', '21.400');
INSERT INTO `locationPoint` VALUES ('',point(116.07,24.19 ),'广东省', '梅州', '116.070', '24.190');
INSERT INTO `locationPoint` VALUES ('',point(113.09,23.01 ),'广东省', '南海', '113.090', '23.010');
INSERT INTO `locationPoint` VALUES ('',point(113.22,22.57 ),'广东省', '番禺', '113.220', '22.570');
INSERT INTO `locationPoint` VALUES ('',point(116.1 ,23.18 ),'广东省', '普宁', '116.100', '23.180');
INSERT INTO `locationPoint` VALUES ('',point(113.01,23.42 ),'广东省', '清远', '113.010', '23.420');
INSERT INTO `locationPoint` VALUES ('',point(112.52,23.1 ),'广东省', '三水', '112.520', '23.100');
INSERT INTO `locationPoint` VALUES ('',point(116.41,23.22 ),'广东省', '汕头', '116.410', '23.220');
INSERT INTO `locationPoint` VALUES ('',point(115.21,22.47 ),'广东省', '汕尾', '115.210', '22.470');
INSERT INTO `locationPoint` VALUES ('',point(113.37,24.48 ),'广东省', '韶关', '113.370', '24.480');
INSERT INTO `locationPoint` VALUES ('',point(114.07,22.33 ),'广东省', '深圳', '114.070', '22.330');
INSERT INTO `locationPoint` VALUES ('',point(113.15,22.5 ),'广东省', '顺德', '113.150', '22.500');
INSERT INTO `locationPoint` VALUES ('',point(112.41,23.21 ),'广东省', '四会', '112.410', '23.210');
INSERT INTO `locationPoint` VALUES ('',point(112.48,22.15 ),'广东省', '台山', '112.480', '22.150');
INSERT INTO `locationPoint` VALUES ('',point(110.47,21.26 ),'广东省', '吴川', '110.470', '21.260');
INSERT INTO `locationPoint` VALUES ('',point(113.01,22.32 ),'广东省', '新会', '113.010', '22.320');
INSERT INTO `locationPoint` VALUES ('',point(115.43,24.09 ),'广东省', '兴宁', '115.430', '24.090');
INSERT INTO `locationPoint` VALUES ('',point(111.48,22.1 ),'广东省', '阳春', '111.480', '22.100');
INSERT INTO `locationPoint` VALUES ('',point(111.58,21.5 ),'广东省', '阳江', '111.580', '21.500');
INSERT INTO `locationPoint` VALUES ('',point(113.22,24.1 ),'广东省', '英德', '113.220', '24.100');
INSERT INTO `locationPoint` VALUES ('',point(112.02,22.57 ),'广东省', '云浮', '112.020', '22.570');
INSERT INTO `locationPoint` VALUES ('',point(113.49,23.18 ),'广东省', '增城', '113.490', '23.180');
INSERT INTO `locationPoint` VALUES ('',point(110.24,21.11 ),'广东省', '湛江', '110.240', '21.110');
INSERT INTO `locationPoint` VALUES ('',point(112.27,23.03 ),'广东省', '肇庆', '112.270', '23.030');
INSERT INTO `locationPoint` VALUES ('',point(113.22,22.31 ),'广东省', '中山', '113.220', '22.310');
INSERT INTO `locationPoint` VALUES ('',point(113.34,22.17 ),'广东省', '珠海', '113.340', '22.170');
INSERT INTO `locationPoint` VALUES ('',point(108.19,22.48 ),'广西省', '南宁', '108.190', '22.480');
INSERT INTO `locationPoint` VALUES ('',point(109.07,21.28 ),'广西省', '北海', '109.070', '21.280');
INSERT INTO `locationPoint` VALUES ('',point(110.21,22.42 ),'广西省', '北流', '110.210', '22.420');
INSERT INTO `locationPoint` VALUES ('',point(106.36,23.54 ),'广西省', '百色', '106.360', '23.540');
INSERT INTO `locationPoint` VALUES ('',point(108.2 ,21.37 ),'广西省', '防城港', '108.200', '21.370');
INSERT INTO `locationPoint` VALUES ('',point(109.36,23.06 ),'广西省', '贵港', '109.360', '23.060');
INSERT INTO `locationPoint` VALUES ('',point(110.17,25.17 ),'广西省', '桂林', '110.170', '25.170');
INSERT INTO `locationPoint` VALUES ('',point(110.04,23.22 ),'广西省', '桂平', '110.040', '23.220');
INSERT INTO `locationPoint` VALUES ('',point(108.03,24.42 ),'广西省', '河池', '108.030', '24.420');
INSERT INTO `locationPoint` VALUES ('',point(108.52,23.47 ),'广西省', '合山', '108.520', '23.470');
INSERT INTO `locationPoint` VALUES ('',point(109.24,23.19 ),'广西省', '柳州', '109.240', '23.190');
INSERT INTO `locationPoint` VALUES ('',point(106.44,22.07 ),'广西省', '赁祥', '106.440', '22.070');
INSERT INTO `locationPoint` VALUES ('',point(108.37,21.57 ),'广西省', '钦州', '108.370', '21.570');
INSERT INTO `locationPoint` VALUES ('',point(111.2 ,23.29 ),'广西省', '梧州', '111.200', '23.290');
INSERT INTO `locationPoint` VALUES ('',point(110.09,22.38 ),'广西省', '玉林', '110.090', '22.380');
INSERT INTO `locationPoint` VALUES ('',point(108.4 ,24.28 ),'广西省', '宜州', '108.400', '24.280');
INSERT INTO `locationPoint` VALUES ('',point(106.42,26.35 ),'贵州省', '贵阳', '106.420', '26.350');
INSERT INTO `locationPoint` VALUES ('',point(105.55,26.14 ),'贵州省', '安顺', '105.550', '26.140');
INSERT INTO `locationPoint` VALUES ('',point(105.18,27.18 ),'贵州省', '毕节', '105.180', '27.180');
INSERT INTO `locationPoint` VALUES ('',point(105.42,28.34 ),'贵州省', '赤水', '105.420', '28.340');
INSERT INTO `locationPoint` VALUES ('',point(107.31,26.15 ),'贵州省', '都匀', '107.310', '26.150');
INSERT INTO `locationPoint` VALUES ('',point(107.58,26.35 ),'贵州省', '凯里', '107.580', '26.350');
INSERT INTO `locationPoint` VALUES ('',point(104.5 ,26.35 ),'贵州省', '六盘水', '104.500', '26.350');
INSERT INTO `locationPoint` VALUES ('',point(106.27,26.33 ),'贵州省', '清镇', '106.270', '26.330');
INSERT INTO `locationPoint` VALUES ('',point(109.12,27.43 ),'贵州省', '铜仁', '109.120', '27.430');
INSERT INTO `locationPoint` VALUES ('',point(104.53,25.05 ),'贵州省', '兴义', '104.530', '25.050');
INSERT INTO `locationPoint` VALUES ('',point(106.55,27.42 ),'贵州省', '遵义', '106.550', '27.420');
INSERT INTO `locationPoint` VALUES ('',point(110.2 ,20.02 ),'海南省', '海口', '110.200', '20.020');
INSERT INTO `locationPoint` VALUES ('',point(109.34,19.31 ),'海南省', '儋州', '109.340', '19.310');
INSERT INTO `locationPoint` VALUES ('',point(110.28,19.14 ),'海南省', '琼海', '110.280', '19.140');
INSERT INTO `locationPoint` VALUES ('',point(110.21,19.59 ),'海南省', '琼山', '110.210', '19.590');
INSERT INTO `locationPoint` VALUES ('',point(109.31,18.14 ),'海南省', '三亚', '109.310', '18.140');
INSERT INTO `locationPoint` VALUES ('',point(109.31,18.46 ),'海南省', '通什', '109.310', '18.460');
INSERT INTO `locationPoint` VALUES ('',point(114.3 ,38.02 ),'河北省', '石家庄', '114.300', '38.020');
INSERT INTO `locationPoint` VALUES ('',point(115.2 ,38.24 ),'河北省', '安国', '115.200', '38.240');
INSERT INTO `locationPoint` VALUES ('',point(115.3 ,38.51 ),'河北省', '保定', '115.300', '38.510');
INSERT INTO `locationPoint` VALUES ('',point(116.24,39.06 ),'河北省', '霸州', '116.240', '39.060');
INSERT INTO `locationPoint` VALUES ('',point(116.34,38.04 ),'河北省', '泊头', '116.340', '38.040');
INSERT INTO `locationPoint` VALUES ('',point(116.52,38.18 ),'河北省', '沧州', '116.520', '38.180');
INSERT INTO `locationPoint` VALUES ('',point(117.57,40.59 ),'河北省', '承德', '117.570', '40.590');
INSERT INTO `locationPoint` VALUES ('',point( ,38.3 ),'河北省', '定州', '115.000', '38.300');
INSERT INTO `locationPoint` VALUES ('',point(118.06,39.34 ),'河北省', '丰南', '118.060', '39.340');
INSERT INTO `locationPoint` VALUES ('',point(115.51,39.2 ),'河北省', '高碑店', '115.510', '39.200');
INSERT INTO `locationPoint` VALUES ('',point(114.5 ,38.02 ),'河北省', '蒿城', '114.500', '38.020');
INSERT INTO `locationPoint` VALUES ('',point(114.28,36.36 ),'河北省', '邯郸', '114.280', '36.360');
INSERT INTO `locationPoint` VALUES ('',point(116.05,38.26 ),'河北省', '河间', '116.050', '38.260');
INSERT INTO `locationPoint` VALUES ('',point(115.42,37.44 ),'河北省', '衡水', '115.420', '37.440');
INSERT INTO `locationPoint` VALUES ('',point(117.21,38.21 ),'河北省', '黄骅', '117.210', '38.210');
INSERT INTO `locationPoint` VALUES ('',point(115.02,38.02 ),'河北省', '晋州', '115.020', '38.020');
INSERT INTO `locationPoint` VALUES ('',point(115.33,37.34 ),'河北省', '冀州', '115.330', '37.340');
INSERT INTO `locationPoint` VALUES ('',point(116.42,39.31 ),'河北省', '廓坊', '116.420', '39.310');
INSERT INTO `locationPoint` VALUES ('',point(114.19,38.04 ),'河北省', '鹿泉', '114.190', '38.040');
INSERT INTO `locationPoint` VALUES ('',point(115.23,37.22 ),'河北省', '南宫', '115.230', '37.220');
INSERT INTO `locationPoint` VALUES ('',point(119.35,39.55 ),'河北省', '秦皇岛', '119.350', '39.550');
INSERT INTO `locationPoint` VALUES ('',point(116.07,38.42 ),'河北省', '任丘', '116.070', '38.420');
INSERT INTO `locationPoint` VALUES ('',point(117.04,39.58 ),'河北省', '三河', '117.040', '39.580');
INSERT INTO `locationPoint` VALUES ('',point(114.3 ,36.51 ),'河北省', '沙河', '114.300', '36.510');
INSERT INTO `locationPoint` VALUES ('',point(115.32,38.01 ),'河北省', '深州', '115.320', '38.010');
INSERT INTO `locationPoint` VALUES ('',point(118.11,39.36 ),'河北省', '唐山', '118.110', '39.360');
INSERT INTO `locationPoint` VALUES ('',point(114.11,36.42 ),'河北省', '武安', '114.110', '36.420');
INSERT INTO `locationPoint` VALUES ('',point(114.3 ,37.04 ),'河北省', '邢台', '114.300', '37.040');
INSERT INTO `locationPoint` VALUES ('',point(115.12,37.54 ),'河北省', '辛集', '115.120', '37.540');
INSERT INTO `locationPoint` VALUES ('',point(114.41,38.2 ),'河北省', '新乐', '114.410', '38.200');
INSERT INTO `locationPoint` VALUES ('',point(114.53,40.48 ),'河北省', '张家口', '114.530', '40.480');
INSERT INTO `locationPoint` VALUES ('',point(115.59,39.29 ),'河北省', '涿州', '115.590', '39.290');
INSERT INTO `locationPoint` VALUES ('',point(117.58,40.11 ),'河北省', '遵化', '117.580', '40.110');
INSERT INTO `locationPoint` VALUES ('',point(113.4 ,34.46 ),'河南省', '郑州', '113.400', '34.460');
INSERT INTO `locationPoint` VALUES ('',point(114.21,36.06 ),'河南省', '安阳', '114.210', '36.060');
INSERT INTO `locationPoint` VALUES ('',point(113.47,34.12 ),'河南省', '长葛', '113.470', '34.120');
INSERT INTO `locationPoint` VALUES ('',point(113.02,34.27 ),'河南省', '登封', '113.020', '34.270');
INSERT INTO `locationPoint` VALUES ('',point(112.05,32.42 ),'河南省', '邓州', '112.050', '32.420');
INSERT INTO `locationPoint` VALUES ('',point(112.58,34.46 ),'河南省', '巩义', '112.580', '34.460');
INSERT INTO `locationPoint` VALUES ('',point(114.11,35.54 ),'河南省', '鹤壁', '114.110', '35.540');
INSERT INTO `locationPoint` VALUES ('',point(113.47,35.27 ),'河南省', '辉县', '113.470', '35.270');
INSERT INTO `locationPoint` VALUES ('',point(113.12,35.14 ),'河南省', '焦作', '113.120', '35.140');
INSERT INTO `locationPoint` VALUES ('',point(112.35,35.04 ),'河南省', '济源', '112.350', '35.040');
INSERT INTO `locationPoint` VALUES ('',point(114.21,34.47 ),'河南省', '开封', '114.210', '34.470');
INSERT INTO `locationPoint` VALUES ('',point(110.52,34.31 ),'河南省', '灵宝', '110.520', '34.310');
INSERT INTO `locationPoint` VALUES ('',point(113.49,36.03 ),'河南省', '林州', '113.490', '36.030');
INSERT INTO `locationPoint` VALUES ('',point(114.02,33.33 ),'河南省', '漯河', '114.020', '33.330');
INSERT INTO `locationPoint` VALUES ('',point(112.27,34.41 ),'河南省', '洛阳', '112.270', '34.410');
INSERT INTO `locationPoint` VALUES ('',point(112.32, ),'河南省', '南阳', '112.320', '33.000');
INSERT INTO `locationPoint` VALUES ('',point(113.17,33.44 ),'河南省', '平顶山', '113.170', '33.440');
INSERT INTO `locationPoint` VALUES ('',point(115.01,35.44 ),'河南省', '濮阳', '115.010', '35.440');
INSERT INTO `locationPoint` VALUES ('',point(112.57,35.05 ),'河南省', '沁阳', '112.570', '35.050');
INSERT INTO `locationPoint` VALUES ('',point(112.5 ,34.09 ),'河南省', '汝州', '112.500', '34.090');
INSERT INTO `locationPoint` VALUES ('',point(111.12,34.47 ),'河南省', '三门峡', '111.120', '34.470');
INSERT INTO `locationPoint` VALUES ('',point(115.38,34.26 ),'河南省', '商丘', '115.380', '34.260');
INSERT INTO `locationPoint` VALUES ('',point(114.03,35.24 ),'河南省', '卫辉', '114.030', '35.240');
INSERT INTO `locationPoint` VALUES ('',point(113.3 ,33.17 ),'河南省', '舞钢', '113.300', '33.170');
INSERT INTO `locationPoint` VALUES ('',point(114.54,33.26 ),'河南省', '项城', '114.540', '33.260');
INSERT INTO `locationPoint` VALUES ('',point(113.21,34.46 ),'河南省', '荥阳', '113.210', '34.460');
INSERT INTO `locationPoint` VALUES ('',point(113.22,34.31 ),'河南省', '新密', '113.220', '34.310');
INSERT INTO `locationPoint` VALUES ('',point(113.52,35.18 ),'河南省', '新乡', '113.520', '35.180');
INSERT INTO `locationPoint` VALUES ('',point(114.04,32.07 ),'河南省', '信阳', '114.040', '32.070');
INSERT INTO `locationPoint` VALUES ('',point(113.43,34.24 ),'河南省', '新郑', '113.430', '34.240');
INSERT INTO `locationPoint` VALUES ('',point(113.49,34.01 ),'河南省', '许昌', '113.490', '34.010');
INSERT INTO `locationPoint` VALUES ('',point(112.47,34.43 ),'河南省', '偃师', '112.470', '34.430');
INSERT INTO `locationPoint` VALUES ('',point(111.55,34.43 ),'河南省', '义马', '111.550', '34.430');
INSERT INTO `locationPoint` VALUES ('',point(113.28,34.09 ),'河南省', '禹州', '113.280', '34.090');
INSERT INTO `locationPoint` VALUES ('',point(114.38,33.37 ),'河南省', '周口', '114.380', '33.370');
INSERT INTO `locationPoint` VALUES ('',point(114.01,32.58 ),'河南省', '驻马店', '114.010', '32.580');
INSERT INTO `locationPoint` VALUES ('',point(126.36,45.44 ),'黑龙江省', '哈尔滨', '126.360', '45.440');
INSERT INTO `locationPoint` VALUES ('',point(126.58,45.32 ),'黑龙江省', '阿城', '126.580', '45.320');
INSERT INTO `locationPoint` VALUES ('',point(125.18,46.24 ),'黑龙江省', '安达', '125.180', '46.240');
INSERT INTO `locationPoint` VALUES ('',point(126.31,48.15 ),'黑龙江省', '北安', '126.310', '48.150');
INSERT INTO `locationPoint` VALUES ('',point(125.01,46.36 ),'黑龙江省', '大庆', '125.010', '46.360');
INSERT INTO `locationPoint` VALUES ('',point(132.02,47.15 ),'黑龙江省', '富锦', '132.020', '47.150');
INSERT INTO `locationPoint` VALUES ('',point(129.21,44.35 ),'黑龙江省', '海林', '129.210', '44.350');
INSERT INTO `locationPoint` VALUES ('',point(126.57,47.28 ),'黑龙江省', '海伦', '126.570', '47.280');
INSERT INTO `locationPoint` VALUES ('',point(130.16,47.2 ),'黑龙江省', '鹤岗', '130.160', '47.200');
INSERT INTO `locationPoint` VALUES ('',point(127.29,50.14 ),'黑龙江省', '黑河', '127.290', '50.140');
INSERT INTO `locationPoint` VALUES ('',point(130.22,46.47 ),'黑龙江省', '佳木斯', '130.220', '46.470');
INSERT INTO `locationPoint` VALUES ('',point(130.57,45.17 ),'黑龙江省', '鸡西', '130.570', '45.170');
INSERT INTO `locationPoint` VALUES ('',point(131.5 ,45.32 ),'黑龙江省', '密山', '131.500', '45.320');
INSERT INTO `locationPoint` VALUES ('',point(129.36,44.35 ),'黑龙江省', '牡丹江', '129.360', '44.350');
INSERT INTO `locationPoint` VALUES ('',point(124.51,48.29 ),'黑龙江省', '讷河', '124.510', '48.290');
INSERT INTO `locationPoint` VALUES ('',point(129.28,44.21 ),'黑龙江省', '宁安', '129.280', '44.210');
INSERT INTO `locationPoint` VALUES ('',point(123.57,47.2 ),'黑龙江省', '齐齐哈尔', '123.570', '47.200');
INSERT INTO `locationPoint` VALUES ('',point(130.49,45.48 ),'黑龙江省', '七台河', '130.490', '45.480');
INSERT INTO `locationPoint` VALUES ('',point(126.15,45.22 ),'黑龙江省', '双城', '126.150', '45.220');
INSERT INTO `locationPoint` VALUES ('',point(127.55,45.14 ),'黑龙江省', '尚志', '127.550', '45.140');
INSERT INTO `locationPoint` VALUES ('',point(131.11,46.38 ),'黑龙江省', '双鸭山', '131.110', '46.380');
INSERT INTO `locationPoint` VALUES ('',point(131.11,44.25 ),'黑龙江省', '绥芬河', '131.110', '44.250');
INSERT INTO `locationPoint` VALUES ('',point(126.59,46.38 ),'黑龙江省', '绥化', '126.590', '46.380');
INSERT INTO `locationPoint` VALUES ('',point(128.01,46.59 ),'黑龙江省', '铁力', '128.010', '46.590');
INSERT INTO `locationPoint` VALUES ('',point(132.3 ,47.39 ),'黑龙江省', '同江', '132.300', '47.390');
INSERT INTO `locationPoint` VALUES ('',point(127.11,44.55 ),'黑龙江省', '五常', '127.110', '44.550');
INSERT INTO `locationPoint` VALUES ('',point(126.07,48.38 ),'黑龙江省', '五大连池', '126.070', '48.380');
INSERT INTO `locationPoint` VALUES ('',point(128.56,47.42 ),'黑龙江省', '伊春', '128.560', '47.420');
INSERT INTO `locationPoint` VALUES ('',point(125.58,46.04 ),'黑龙江省', '肇东', '125.580', '46.040');
INSERT INTO `locationPoint` VALUES ('',point(114.17,30.35 ),'湖北省', '武汉', '114.170', '30.350');
INSERT INTO `locationPoint` VALUES ('',point(113.41,31.15 ),'湖北省', '安陆', '113.410', '31.150');
INSERT INTO `locationPoint` VALUES ('',point(111.47,30.5 ),'湖北省', '当阳', '111.470', '30.500');
INSERT INTO `locationPoint` VALUES ('',point(108.3 ,32.33 ),'湖北省', '丹江口', '108.300', '32.330');
INSERT INTO `locationPoint` VALUES ('',point(114.58,30.06 ),'湖北省', '大冶', '114.580', '30.060');
INSERT INTO `locationPoint` VALUES ('',point(109.29,30.16 ),'湖北省', '恩施', '109.290', '30.160');
INSERT INTO `locationPoint` VALUES ('',point(114.52,30.23 ),'湖北省', '鄂州', '114.520', '30.230');
INSERT INTO `locationPoint` VALUES ('',point(113.48,31.37 ),'湖北省', '广水', '113.480', '31.370');
INSERT INTO `locationPoint` VALUES ('',point(113.27,29.48 ),'湖北省', '洪湖', '113.270', '29.480');
INSERT INTO `locationPoint` VALUES ('',point(115.06,30.12 ),'湖北省', '黄石', '115.060', '30.120');
INSERT INTO `locationPoint` VALUES ('',point(114.52,30.27 ),'湖北省', '黄州', '114.520', '30.270');
INSERT INTO `locationPoint` VALUES ('',point(112.12,31.02 ),'湖北省', '荆门', '112.120', '31.020');
INSERT INTO `locationPoint` VALUES ('',point(112.16,30.18 ),'湖北省', '荆沙', '112.160', '30.180');
INSERT INTO `locationPoint` VALUES ('',point(111.4 ,32.23 ),'湖北省', '老河口', '111.400', '32.230');
INSERT INTO `locationPoint` VALUES ('',point(108.56,30.18 ),'湖北省', '利川', '108.560', '30.180');
INSERT INTO `locationPoint` VALUES ('',point(115.01,31.1 ),'湖北省', '麻城', '115.010', '31.100');
INSERT INTO `locationPoint` VALUES ('',point(113.51,29.42 ),'湖北省', '浦圻', '113.510', '29.420');
INSERT INTO `locationPoint` VALUES ('',point(112.53,30.26 ),'湖北省', '潜江', '112.530', '30.260');
INSERT INTO `locationPoint` VALUES ('',point(112.24,29.43 ),'湖北省', '石首', '112.240', '29.430');
INSERT INTO `locationPoint` VALUES ('',point(110.47,32.4 ),'湖北省', '十堰', '110.470', '32.400');
INSERT INTO `locationPoint` VALUES ('',point(113.22,31.42 ),'湖北省', '随州', '113.220', '31.420');
INSERT INTO `locationPoint` VALUES ('',point(113.1 ,60.39 ),'湖北省', '天门', '113.100', '60.390');
INSERT INTO `locationPoint` VALUES ('',point(115.33,29.51 ),'湖北省', '武穴', '115.330', '29.510');
INSERT INTO `locationPoint` VALUES ('',point(112.08,32.02 ),'湖北省', '襄樊', '112.080', '32.020');
INSERT INTO `locationPoint` VALUES ('',point(114.17,29.53 ),'湖北省', '咸宁', '114.170', '29.530');
INSERT INTO `locationPoint` VALUES ('',point(113.27,30.22 ),'湖北省', '仙桃', '113.270', '30.220');
INSERT INTO `locationPoint` VALUES ('',point(113.54,30.56 ),'湖北省', '孝感', '113.540', '30.560');
INSERT INTO `locationPoint` VALUES ('',point(111.17,30.42 ),'湖北省', '宜昌', '111.170', '30.420');
INSERT INTO `locationPoint` VALUES ('',point(112.15,31.42 ),'湖北省', '宜城', '112.150', '31.420');
INSERT INTO `locationPoint` VALUES ('',point(113.33,30.57 ),'湖北省', '应城', '113.330', '30.570');
INSERT INTO `locationPoint` VALUES ('',point(112.44,32.07 ),'湖北省', '枣阳', '112.440', '32.070');
INSERT INTO `locationPoint` VALUES ('',point(111.27,30.23 ),'湖北省', '枝城', '111.270', '30.230');
INSERT INTO `locationPoint` VALUES ('',point(112.34,31.1 ),'湖北省', '钟祥', '112.340', '31.100');
INSERT INTO `locationPoint` VALUES ('',point(112.59,28.12 ),'湖南省', '长沙', '112.590', '28.120');
INSERT INTO `locationPoint` VALUES ('',point(111.51,29.02 ),'湖南省', '常德', '111.510', '29.020');
INSERT INTO `locationPoint` VALUES ('',point(113.02,25.46 ),'湖南省', '郴州', '113.020', '25.460');
INSERT INTO `locationPoint` VALUES ('',point(112.37,26.53 ),'湖南省', '衡阳', '112.370', '26.530');
INSERT INTO `locationPoint` VALUES ('',point(109.59,27.07 ),'湖南省', '洪江', '109.590', '27.070');
INSERT INTO `locationPoint` VALUES ('',point(109.58,27.33 ),'湖南省', '怀化', '109.580', '27.330');
INSERT INTO `locationPoint` VALUES ('',point(111.52,29.38 ),'湖南省', '津市', '111.520', '29.380');
INSERT INTO `locationPoint` VALUES ('',point(109.43,28.18 ),'湖南省', '吉首', '109.430', '28.180');
INSERT INTO `locationPoint` VALUES ('',point(112.51,26.24 ),'湖南省', '耒阳', '112.510', '26.240');
INSERT INTO `locationPoint` VALUES ('',point(111.26,27.42 ),'湖南省', '冷水江', '111.260', '27.420');
INSERT INTO `locationPoint` VALUES ('',point(111.35,26.26 ),'湖南省', '冷水滩', '111.350', '26.260');
INSERT INTO `locationPoint` VALUES ('',point(111.41,27.41 ),'湖南省', '涟源', '111.410', '27.410');
INSERT INTO `locationPoint` VALUES ('',point(113.3 ,27.4 ),'湖南省', '醴陵', '113.300', '27.400');
INSERT INTO `locationPoint` VALUES ('',point(113.27,29.29 ),'湖南省', '临湘', '113.270', '29.290');
INSERT INTO `locationPoint` VALUES ('',point(113.37,28.09 ),'湖南省', '浏阳', '113.370', '28.090');
INSERT INTO `locationPoint` VALUES ('',point(111.59,27.44 ),'湖南省', '娄底', '111.590', '27.440');
INSERT INTO `locationPoint` VALUES ('',point(113.03,28.49 ),'湖南省', '汨罗', '113.030', '28.490');
INSERT INTO `locationPoint` VALUES ('',point(112.29,27.54 ),'湖南省', '韶山', '112.290', '27.540');
INSERT INTO `locationPoint` VALUES ('',point(111.28,27.14 ),'湖南省', '邵阳', '111.280', '27.140');
INSERT INTO `locationPoint` VALUES ('',point(110.37,26.43 ),'湖南省', '武冈', '110.370', '26.430');
INSERT INTO `locationPoint` VALUES ('',point(112.53,27.52 ),'湖南省', '湘潭', '112.530', '27.520');
INSERT INTO `locationPoint` VALUES ('',point(112.31,27.44 ),'湖南省', '湘乡', '112.310', '27.440');
INSERT INTO `locationPoint` VALUES ('',point(112.2 ,28.36 ),'湖南省', '益阳', '112.200', '28.360');
INSERT INTO `locationPoint` VALUES ('',point(111.37,26.13 ),'湖南省', '永州', '111.370', '26.130');
INSERT INTO `locationPoint` VALUES ('',point(112.22,28.5 ),'湖南省', '沅江', '112.220', '28.500');
INSERT INTO `locationPoint` VALUES ('',point(113.06,29.22 ),'湖南省', '岳阳', '113.060', '29.220');
INSERT INTO `locationPoint` VALUES ('',point(110.29,29.08 ),'湖南省', '张家界', '110.290', '29.080');
INSERT INTO `locationPoint` VALUES ('',point(113.09,27.51 ),'湖南省', '株洲', '113.090', '27.510');
INSERT INTO `locationPoint` VALUES ('',point(113.13,25.58 ),'湖南省', '资兴', '113.130', '25.580');
INSERT INTO `locationPoint` VALUES ('',point(125.19,43.54 ),'吉林省', '长春', '125.190', '43.540');
INSERT INTO `locationPoint` VALUES ('',point(122.5 ,45.38 ),'吉林省', '白城', '122.500', '45.380');
INSERT INTO `locationPoint` VALUES ('',point(126.26,41.56 ),'吉林省', '白山', '126.260', '41.560');
INSERT INTO `locationPoint` VALUES ('',point(124.18,45.3 ),'吉林省', '大安', '124.180', '45.300');
INSERT INTO `locationPoint` VALUES ('',point(125.42,44.32 ),'吉林省', '德惠', '125.420', '44.320');
INSERT INTO `locationPoint` VALUES ('',point(128.13,43.22 ),'吉林省', '敦化', '128.130', '43.220');
INSERT INTO `locationPoint` VALUES ('',point(124.49,43.31 ),'吉林省', '公主岭', '124.490', '43.310');
INSERT INTO `locationPoint` VALUES ('',point( ,42.32 ),'吉林省', '和龙', '129.000', '42.320');
INSERT INTO `locationPoint` VALUES ('',point(126.44,42.58 ),'吉林省', '桦甸', '126.440', '42.580');
INSERT INTO `locationPoint` VALUES ('',point(130.22,42.52 ),'吉林省', '珲春', '130.220', '42.520');
INSERT INTO `locationPoint` VALUES ('',point(126.11,41.08 ),'吉林省', '集安', '126.110', '41.080');
INSERT INTO `locationPoint` VALUES ('',point(127.21,43.42 ),'吉林省', '蛟河', '127.210', '43.420');
INSERT INTO `locationPoint` VALUES ('',point(126.33,43.52 ),'吉林省', '吉林', '126.330', '43.520');
INSERT INTO `locationPoint` VALUES ('',point(125.51,44.09 ),'吉林省', '九台', '125.510', '44.090');
INSERT INTO `locationPoint` VALUES ('',point(125.09,42.54 ),'吉林省', '辽源', '125.090', '42.540');
INSERT INTO `locationPoint` VALUES ('',point(126.53,41.49 ),'吉林省', '临江', '126.530', '41.490');
INSERT INTO `locationPoint` VALUES ('',point(129.26,42.46 ),'吉林省', '龙井', '129.260', '42.460');
INSERT INTO `locationPoint` VALUES ('',point(125.4 ,42.32 ),'吉林省', '梅河口', '125.400', '42.320');
INSERT INTO `locationPoint` VALUES ('',point(126.57,44.24 ),'吉林省', '舒兰', '126.570', '44.240');
INSERT INTO `locationPoint` VALUES ('',point(124.22,43.1 ),'吉林省', '四平', '124.220', '43.100');
INSERT INTO `locationPoint` VALUES ('',point(124.49,45.11 ),'吉林省', '*', '124.490', '45.110');
INSERT INTO `locationPoint` VALUES ('',point(122.47,45.2 ),'吉林省', '洮南', '122.470', '45.200');
INSERT INTO `locationPoint` VALUES ('',point(125.56,41.43 ),'吉林省', '通化', '125.560', '41.430');
INSERT INTO `locationPoint` VALUES ('',point(129.51,42.57 ),'吉林省', '图们', '129.510', '42.570');
INSERT INTO `locationPoint` VALUES ('',point(129.3 ,42.54 ),'吉林省', '延吉', '129.300', '42.540');
INSERT INTO `locationPoint` VALUES ('',point(126.32,44.49 ),'吉林省', '愉树', '126.320', '44.490');
INSERT INTO `locationPoint` VALUES ('',point(118.46,32.03 ),'江苏省', '南京', '118.460', '32.030');
INSERT INTO `locationPoint` VALUES ('',point(120.43,31.39 ),'江苏省', '常熟', '120.430', '31.390');
INSERT INTO `locationPoint` VALUES ('',point(119.58,31.47 ),'江苏省', '常州', '119.580', '31.470');
INSERT INTO `locationPoint` VALUES ('',point(119.32, ),'江苏省', '丹阳', '119.320', '32.000');
INSERT INTO `locationPoint` VALUES ('',point(120.19,32.51 ),'江苏省', '东台', '120.190', '32.510');
INSERT INTO `locationPoint` VALUES ('',point(119.27,32.47 ),'江苏省', '高邮', '119.270', '32.470');
INSERT INTO `locationPoint` VALUES ('',point(121.09,31.53 ),'江苏省', '海门', '121.090', '31.530');
INSERT INTO `locationPoint` VALUES ('',point(119.09,33.3 ),'江苏省', '淮安', '119.090', '33.300');
INSERT INTO `locationPoint` VALUES ('',point(119.02,33.36 ),'江苏省', '淮阴', '119.020', '33.360');
INSERT INTO `locationPoint` VALUES ('',point(119.32,32.26 ),'江苏省', '江都', '119.320', '32.260');
INSERT INTO `locationPoint` VALUES ('',point(120.08,32.34 ),'江苏省', '姜堰', '120.080', '32.340');
INSERT INTO `locationPoint` VALUES ('',point(120.17,31.54 ),'江苏省', '江阴', '120.170', '31.540');
INSERT INTO `locationPoint` VALUES ('',point(120.17,32.02 ),'江苏省', '靖江', '120.170', '32.020');
INSERT INTO `locationPoint` VALUES ('',point(119.33,31.46 ),'江苏省', '金坛', '119.330', '31.460');
INSERT INTO `locationPoint` VALUES ('',point(120.57,31.23 ),'江苏省', '昆山', '120.570', '31.230');
INSERT INTO `locationPoint` VALUES ('',point(119.1 ,34.36 ),'江苏省', '连去港', '119.100', '34.360');
INSERT INTO `locationPoint` VALUES ('',point(119.29,31.26 ),'江苏省', '溧阳', '119.290', '31.260');
INSERT INTO `locationPoint` VALUES ('',point(120.51,32.01 ),'江苏省', '南通', '120.510', '32.010');
INSERT INTO `locationPoint` VALUES ('',point(117.59,34.19 ),'江苏省', '邳州', '117.590', '34.190');
INSERT INTO `locationPoint` VALUES ('',point(121.39,31.48 ),'江苏省', '启乐', '121.390', '31.480');
INSERT INTO `locationPoint` VALUES ('',point(120.33,32.23 ),'江苏省', '如皋', '120.330', '32.230');
INSERT INTO `locationPoint` VALUES ('',point(118.18,33.58 ),'江苏省', '宿迁', '118.180', '33.580');
INSERT INTO `locationPoint` VALUES ('',point(120.37,31.19 ),'江苏省', '苏州', '120.370', '31.190');
INSERT INTO `locationPoint` VALUES ('',point(121.06,31.27 ),'江苏省', '太仓', '121.060', '31.270');
INSERT INTO `locationPoint` VALUES ('',point(120.01,32.1 ),'江苏省', '泰兴', '120.010', '32.100');
INSERT INTO `locationPoint` VALUES ('',point(119.54,32.3 ),'江苏省', '泰州', '119.540', '32.300');
INSERT INTO `locationPoint` VALUES ('',point(121.03,32.05 ),'江苏省', '通州', '121.030', '32.050');
INSERT INTO `locationPoint` VALUES ('',point(120.39,31.1 ),'江苏省', '吴江', '120.390', '31.100');
INSERT INTO `locationPoint` VALUES ('',point(120.18,31.34 ),'江苏省', '无锡', '120.180', '31.340');
INSERT INTO `locationPoint` VALUES ('',point(119.5 ,32.56 ),'江苏省', '兴化', '119.500', '32.560');
INSERT INTO `locationPoint` VALUES ('',point(118.2 ,34.22 ),'江苏省', '新沂', '118.200', '34.220');
INSERT INTO `locationPoint` VALUES ('',point(117.11,34.15 ),'江苏省', '徐州', '117.110', '34.150');
INSERT INTO `locationPoint` VALUES ('',point(120.08,33.22 ),'江苏省', '盐在', '120.080', '33.220');
INSERT INTO `locationPoint` VALUES ('',point(119.49,32.14 ),'江苏省', '扬中', '119.490', '32.140');
INSERT INTO `locationPoint` VALUES ('',point(119.26,32.23 ),'江苏省', '扬州', '119.260', '32.230');
INSERT INTO `locationPoint` VALUES ('',point(119.49,31.21 ),'江苏省', '宜兴', '119.490', '31.210');
INSERT INTO `locationPoint` VALUES ('',point(119.1 ,32.16 ),'江苏省', '仪征', '119.100', '32.160');
INSERT INTO `locationPoint` VALUES ('',point(120.32,31.52 ),'江苏省', '张家港', '120.320', '31.520');
INSERT INTO `locationPoint` VALUES ('',point(119.27,32.11 ),'江苏省', '镇江', '119.270', '32.110');
INSERT INTO `locationPoint` VALUES ('',point(115.55,28.4 ),'江西省', '南昌', '115.550', '28.400');
INSERT INTO `locationPoint` VALUES ('',point(117.35,28.57 ),'江西省', '德兴', '117.350', '28.570');
INSERT INTO `locationPoint` VALUES ('',point(115.48,28.12 ),'江西省', '丰城', '115.480', '28.120');
INSERT INTO `locationPoint` VALUES ('',point(114.56,28.52 ),'江西省', '赣州', '114.560', '28.520');
INSERT INTO `locationPoint` VALUES ('',point(115.22,28.25 ),'江西省', '高安', '115.220', '28.250');
INSERT INTO `locationPoint` VALUES ('',point(114.58,27.07 ),'江西省', '吉安', '114.580', '27.070');
INSERT INTO `locationPoint` VALUES ('',point(117.13,29.17 ),'江西省', '景德镇', '117.130', '29.170');
INSERT INTO `locationPoint` VALUES ('',point(114.1 ,26.34 ),'江西省', '井冈山', '114.100', '26.340');
INSERT INTO `locationPoint` VALUES ('',point(115.58,29.43 ),'江西省', '九江', '115.580', '29.430');
INSERT INTO `locationPoint` VALUES ('',point(117.08,28.58 ),'江西省', '乐平', '117.080', '28.580');
INSERT INTO `locationPoint` VALUES ('',point(116.21,27.59 ),'江西省', '临川', '116.210', '27.590');
INSERT INTO `locationPoint` VALUES ('',point(113.5 ,27.37 ),'江西省', '萍乡', '113.500', '27.370');
INSERT INTO `locationPoint` VALUES ('',point(115.38,29.4 ),'江西省', '瑞昌', '115.380', '29.400');
INSERT INTO `locationPoint` VALUES ('',point(116.01,25.53 ),'江西省', '瑞金', '116.010', '25.530');
INSERT INTO `locationPoint` VALUES ('',point(117.58,25.27 ),'江西省', '上饶', '117.580', '25.270');
INSERT INTO `locationPoint` VALUES ('',point(114.56,27.48 ),'江西省', '新余', '114.560', '27.480');
INSERT INTO `locationPoint` VALUES ('',point(114.23,27.47 ),'江西省', '宜春', '114.230', '27.470');
INSERT INTO `locationPoint` VALUES ('',point(117.03,28.14 ),'江西省', '鹰潭', '117.030', '28.140');
INSERT INTO `locationPoint` VALUES ('',point(115.32,28.03 ),'江西省', '樟树', '115.320', '28.030');
INSERT INTO `locationPoint` VALUES ('',point(123.25,41.48 ),'辽宁省', '沈阳', '123.250', '41.480');
INSERT INTO `locationPoint` VALUES ('',point( ,41.07 ),'辽宁省', '鞍山', '123.000', '41.070');
INSERT INTO `locationPoint` VALUES ('',point(120.47,41.48 ),'辽宁省', '北票', '120.470', '41.480');
INSERT INTO `locationPoint` VALUES ('',point(123.46,41.18 ),'辽宁省', '本溪', '123.460', '41.180');
INSERT INTO `locationPoint` VALUES ('',point(120.27,41.34 ),'辽宁省', '朝阳', '120.270', '41.340');
INSERT INTO `locationPoint` VALUES ('',point(121.36,38.55 ),'辽宁省', '大连', '121.360', '38.550');
INSERT INTO `locationPoint` VALUES ('',point(124.22,40.08 ),'辽宁省', '丹东', '124.220', '40.080');
INSERT INTO `locationPoint` VALUES ('',point(122.31,40.37 ),'辽宁省', '大石桥', '122.310', '40.370');
INSERT INTO `locationPoint` VALUES ('',point(124.08,39.53 ),'辽宁省', '东港', '124.080', '39.530');
INSERT INTO `locationPoint` VALUES ('',point(124.02,40.28 ),'辽宁省', '凤城', '124.020', '40.280');
INSERT INTO `locationPoint` VALUES ('',point(123.54,41.51 ),'辽宁省', '抚顺', '123.540', '41.510');
INSERT INTO `locationPoint` VALUES ('',point(121.39,42.01 ),'辽宁省', '阜新', '121.390', '42.010');
INSERT INTO `locationPoint` VALUES ('',point(122.21,40.24 ),'辽宁省', '盖州', '122.210', '40.240');
INSERT INTO `locationPoint` VALUES ('',point(122.43,40.51 ),'辽宁省', '海城', '122.430', '40.510');
INSERT INTO `locationPoint` VALUES ('',point(120.51,40.45 ),'辽宁省', '葫芦岛', '120.510', '40.450');
INSERT INTO `locationPoint` VALUES ('',point(121.09,41.07 ),'辽宁省', '锦州', '121.090', '41.070');
INSERT INTO `locationPoint` VALUES ('',point(124.02,42.32 ),'辽宁省', '开原', '124.020', '42.320');
INSERT INTO `locationPoint` VALUES ('',point(123.12,41.16 ),'辽宁省', '辽阳', '123.120', '41.160');
INSERT INTO `locationPoint` VALUES ('',point(121.21,41.1 ),'辽宁省', '凌海', '121.210', '41.100');
INSERT INTO `locationPoint` VALUES ('',point(119.22,41.14 ),'辽宁省', '凌源', '119.220', '41.140');
INSERT INTO `locationPoint` VALUES ('',point(122.03,41.07 ),'辽宁省', '盘锦', '122.030', '41.070');
INSERT INTO `locationPoint` VALUES ('',point(121.58,39.23 ),'辽宁省', '普兰店', '121.580', '39.230');
INSERT INTO `locationPoint` VALUES ('',point(123.32,42.28 ),'辽宁省', '铁法', '123.320', '42.280');
INSERT INTO `locationPoint` VALUES ('',point(123.51,42.18 ),'辽宁省', '铁岭', '123.510', '42.180');
INSERT INTO `locationPoint` VALUES ('',point( ,39.37 ),'辽宁省', '瓦房店', '122.000', '39.370');
INSERT INTO `locationPoint` VALUES ('',point(120.41,40.37 ),'辽宁省', '兴城', '120.410', '40.370');
INSERT INTO `locationPoint` VALUES ('',point(122.49,41.59 ),'辽宁省', '新民', '122.490', '41.590');
INSERT INTO `locationPoint` VALUES ('',point(122.13,40.39 ),'辽宁省', '营口', '122.130', '40.390');
INSERT INTO `locationPoint` VALUES ('',point(122.58,39.41 ),'辽宁省', '庄河', '122.580', '39.410');
INSERT INTO `locationPoint` VALUES ('',point(101.48,36.38 ),'青海省', '西宁', '101.480', '36.380');
INSERT INTO `locationPoint` VALUES ('',point(97.23 ,37.22 ),'青海省', '德令哈', '97.230', '37.220');
INSERT INTO `locationPoint` VALUES ('',point(94.55 ,36.26 ),'青海省', '格尔木', '94.550', '36.260');
INSERT INTO `locationPoint` VALUES ('',point( ,36.4 ),'山东省', '济南', '117.000', '36.400');
INSERT INTO `locationPoint` VALUES ('',point(119.12,36.25 ),'山东省', '安丘', '119.120', '36.250');
INSERT INTO `locationPoint` VALUES ('',point(118.02,37.22 ),'山东省', '滨州', '118.020', '37.220');
INSERT INTO `locationPoint` VALUES ('',point(119.24,39.52 ),'山东省', '昌邑', '119.240', '39.520');
INSERT INTO `locationPoint` VALUES ('',point(116.17,37.26 ),'山东省', '德州', '116.170', '37.260');
INSERT INTO `locationPoint` VALUES ('',point(118.3 ,37.27 ),'山东省', '东营', '118.300', '37.270');
INSERT INTO `locationPoint` VALUES ('',point(116.46,36.14 ),'山东省', '肥城', '116.460', '36.140');
INSERT INTO `locationPoint` VALUES ('',point(119.44,36.22 ),'山东省', '高密', '119.440', '36.220');
INSERT INTO `locationPoint` VALUES ('',point(115.26,35.14 ),'山东省', '菏泽', '115.260', '35.140');
INSERT INTO `locationPoint` VALUES ('',point(119.58,35.53 ),'山东省', '胶南', '119.580', '35.530');
INSERT INTO `locationPoint` VALUES ('',point( ,36.17 ),'山东省', '胶州', '120.000', '36.170');
INSERT INTO `locationPoint` VALUES ('',point(120.28,36.22 ),'山东省', '即墨', '120.280', '36.220');
INSERT INTO `locationPoint` VALUES ('',point(116.33,35.23 ),'山东省', '济宁', '116.330', '35.230');
INSERT INTO `locationPoint` VALUES ('',point(117.4 ,36.12 ),'山东省', '莱芜', '117.400', '36.120');
INSERT INTO `locationPoint` VALUES ('',point(120.31,36.52 ),'山东省', '莱西', '120.310', '36.520');
INSERT INTO `locationPoint` VALUES ('',point(120.42,36.58 ),'山东省', '莱阳', '120.420', '36.580');
INSERT INTO `locationPoint` VALUES ('',point(119.57,37.1 ),'山东省', '莱州', '119.570', '37.100');
INSERT INTO `locationPoint` VALUES ('',point(117.12,37.44 ),'山东省', '乐陵', '117.120', '37.440');
INSERT INTO `locationPoint` VALUES ('',point(115.57,36.26 ),'山东省', '聊城', '115.570', '36.260');
INSERT INTO `locationPoint` VALUES ('',point(115.42,36.51 ),'山东省', '临清', '115.420', '36.510');
INSERT INTO `locationPoint` VALUES ('',point(118.2 ,35.03 ),'山东省', '临沂', '118.200', '35.030');
INSERT INTO `locationPoint` VALUES ('',point(120.21,37.39 ),'山东省', '龙口', '120.210', '37.390');
INSERT INTO `locationPoint` VALUES ('',point(120.45,37.48 ),'山东省', '蓬莱', '120.450', '37.480');
INSERT INTO `locationPoint` VALUES ('',point(119.58,36.47 ),'山东省', '平度', '119.580', '36.470');
INSERT INTO `locationPoint` VALUES ('',point(120.18,36.03 ),'山东省', '青岛', '120.180', '36.030');
INSERT INTO `locationPoint` VALUES ('',point(118.28,36.42 ),'山东省', '青州', '118.280', '36.420');
INSERT INTO `locationPoint` VALUES ('',point(116.58,35.36 ),'山东省', '曲阜', '116.580', '35.360');
INSERT INTO `locationPoint` VALUES ('',point(119.32,35.23 ),'山东省', '日照', '119.320', '35.230');
INSERT INTO `locationPoint` VALUES ('',point(122.25,37.1 ),'山东省', '荣成', '122.250', '37.100');
INSERT INTO `locationPoint` VALUES ('',point(121.31,36.54 ),'山东省', '乳山', '121.310', '36.540');
INSERT INTO `locationPoint` VALUES ('',point(118.44,36.53 ),'山东省', '寿光', '118.440', '36.530');
INSERT INTO `locationPoint` VALUES ('',point(117.08,36.11 ),'山东省', '泰安', '117.080', '36.110');
INSERT INTO `locationPoint` VALUES ('',point(117.09,35.06 ),'山东省', '滕州', '117.090', '35.060');
INSERT INTO `locationPoint` VALUES ('',point(119.06,36.43 ),'山东省', '潍坊', '119.060', '36.430');
INSERT INTO `locationPoint` VALUES ('',point(122.07,37.31 ),'山东省', '威海', '122.070', '37.310');
INSERT INTO `locationPoint` VALUES ('',point(122.03,37.12 ),'山东省', '文登', '122.030', '37.120');
INSERT INTO `locationPoint` VALUES ('',point(117.45,35.54 ),'山东省', '新泰', '117.450', '35.540');
INSERT INTO `locationPoint` VALUES ('',point(121.24,37.32 ),'山东省', '烟台', '121.240', '37.320');
INSERT INTO `locationPoint` VALUES ('',point(116.49,35.32 ),'山东省', '兖州', '116.490', '35.320');
INSERT INTO `locationPoint` VALUES ('',point(116.39,36.56 ),'山东省', '禹城', '116.390', '36.560');
INSERT INTO `locationPoint` VALUES ('',point(117.33,34.52 ),'山东省', '枣庄', '117.330', '34.520');
INSERT INTO `locationPoint` VALUES ('',point(117.32,36.43 ),'山东省', '章丘', '117.320', '36.430');
INSERT INTO `locationPoint` VALUES ('',point(120.23,37.21 ),'山东省', '招远', '120.230', '37.210');
INSERT INTO `locationPoint` VALUES ('',point(119.24,35.59 ),'山东省', '诸城', '119.240', '35.590');
INSERT INTO `locationPoint` VALUES ('',point(118.03,36.48 ),'山东省', '淄博', '118.030', '36.480');
INSERT INTO `locationPoint` VALUES ('',point(116.58,35.24 ),'山东省', '邹城', '116.580', '35.240');
INSERT INTO `locationPoint` VALUES ('',point(112.33,37.54 ),'山西省', '太原', '112.330', '37.540');
INSERT INTO `locationPoint` VALUES ('',point(113.06,36.11 ),'山西省', '长治', '113.060', '36.110');
INSERT INTO `locationPoint` VALUES ('',point(113.17,40.06 ),'山西省', '大同', '113.170', '40.060');
INSERT INTO `locationPoint` VALUES ('',point(112.55,35.48 ),'山西省', '高平', '112.550', '35.480');
INSERT INTO `locationPoint` VALUES ('',point(112.09,37.54 ),'山西省', '古交', '112.090', '37.540');
INSERT INTO `locationPoint` VALUES ('',point(110.41,35.35 ),'山西省', '河津', '110.410', '35.350');
INSERT INTO `locationPoint` VALUES ('',point(111.21,35.37 ),'山西省', '侯马', '111.210', '35.370');
INSERT INTO `locationPoint` VALUES ('',point(111.42,36.34 ),'山西省', '霍州', '111.420', '36.340');
INSERT INTO `locationPoint` VALUES ('',point(111.55,37.02 ),'山西省', '介休', '111.550', '37.020');
INSERT INTO `locationPoint` VALUES ('',point(112.51,35.3 ),'山西省', '晋城', '112.510', '35.300');
INSERT INTO `locationPoint` VALUES ('',point(111.31,36.05 ),'山西省', '临汾', '111.310', '36.050');
INSERT INTO `locationPoint` VALUES ('',point(113.14,36.21 ),'山西省', '潞城', '113.140', '36.210');
INSERT INTO `locationPoint` VALUES ('',point(112.26,39.19 ),'山西省', '朔州', '112.260', '39.190');
INSERT INTO `locationPoint` VALUES ('',point(111.48,37.08 ),'山西省', '孝义', '111.480', '37.080');
INSERT INTO `locationPoint` VALUES ('',point(112.43,38.24 ),'山西省', '忻州', '112.430', '38.240');
INSERT INTO `locationPoint` VALUES ('',point(113.34,37.51 ),'山西省', '阳泉', '113.340', '37.510');
INSERT INTO `locationPoint` VALUES ('',point(110.27,34.52 ),'山西省', '永济', '110.270', '34.520');
INSERT INTO `locationPoint` VALUES ('',point(112.42,38.43 ),'山西省', '原平', '112.420', '38.430');
INSERT INTO `locationPoint` VALUES ('',point(112.43,37.41 ),'山西省', '榆次', '112.430', '37.410');
INSERT INTO `locationPoint` VALUES ('',point(110.59,35.02 ),'山西省', '运城', '110.590', '35.020');
INSERT INTO `locationPoint` VALUES ('',point(108.57,34.17 ),'陕西省', '西安', '108.570', '34.170');
INSERT INTO `locationPoint` VALUES ('',point(109.01,32.41 ),'陕西省', '安康', '109.010', '32.410');
INSERT INTO `locationPoint` VALUES ('',point(107.09,34.22 ),'陕西省', '宝鸡', '107.090', '34.220');
INSERT INTO `locationPoint` VALUES ('',point(110.27,35.28 ),'陕西省', '韩城', '110.270', '35.280');
INSERT INTO `locationPoint` VALUES ('',point(107.01,33.04 ),'陕西省', '汉中', '107.010', '33.040');
INSERT INTO `locationPoint` VALUES ('',point(110.05,34.34 ),'陕西省', '华阴', '110.050', '34.340');
INSERT INTO `locationPoint` VALUES ('',point(109.57,33.52 ),'陕西省', '商州', '109.570', '33.520');
INSERT INTO `locationPoint` VALUES ('',point(109.07,35.06 ),'陕西省', '铜川', '109.070', '35.060');
INSERT INTO `locationPoint` VALUES ('',point(109.3 ,34.3 ),'陕西省', '渭南', '109.300', '34.300');
INSERT INTO `locationPoint` VALUES ('',point(108.43,34.2 ),'陕西省', '咸阳', '108.430', '34.200');
INSERT INTO `locationPoint` VALUES ('',point(108.29,34.18 ),'陕西省', '兴平', '108.290', '34.180');
INSERT INTO `locationPoint` VALUES ('',point(109.28,36.35 ),'陕西省', '延安', '109.280', '36.350');
INSERT INTO `locationPoint` VALUES ('',point(109.47,38.18 ),'陕西省', '榆林', '109.470', '38.180');
INSERT INTO `locationPoint` VALUES ('',point(104.04,30.4 ),'四川省', '成都', '104.040', '30.400');
INSERT INTO `locationPoint` VALUES ('',point(106.43,31.51 ),'四川省', '巴中', '106.430', '31.510');
INSERT INTO `locationPoint` VALUES ('',point(103.4 ,30.39 ),'四川省', '崇州', '103.400', '30.390');
INSERT INTO `locationPoint` VALUES ('',point(107.29,31.14 ),'四川省', '达川', '107.290', '31.140');
INSERT INTO `locationPoint` VALUES ('',point(104.22,31.09 ),'四川省', '德阳', '104.220', '31.090');
INSERT INTO `locationPoint` VALUES ('',point(103.37,31.01 ),'四川省', '都江堰', '103.370', '31.010');
INSERT INTO `locationPoint` VALUES ('',point(103.29,29.36 ),'四川省', '峨眉山', '103.290', '29.360');
INSERT INTO `locationPoint` VALUES ('',point(107.22,29.42 ),'四川省', '涪陵', '107.220', '29.420');
INSERT INTO `locationPoint` VALUES ('',point(104.15,30.58 ),'四川省', '广汉', '104.150', '30.580');
INSERT INTO `locationPoint` VALUES ('',point(105.51,32.28 ),'四川省', '广元', '105.510', '32.280');
INSERT INTO `locationPoint` VALUES ('',point(106.44,30.26 ),'四川省', '华蓥', '106.440', '30.260');
INSERT INTO `locationPoint` VALUES ('',point(104.32,30.24 ),'四川省', '简阳', '104.320', '30.240');
INSERT INTO `locationPoint` VALUES ('',point(104.42,31.48 ),'四川省', '江油', '104.420', '31.480');
INSERT INTO `locationPoint` VALUES ('',point(105.58,31.36 ),'四川省', '阆中', '105.580', '31.360');
INSERT INTO `locationPoint` VALUES ('',point(103.44,29.36 ),'四川省', '乐山', '103.440', '29.360');
INSERT INTO `locationPoint` VALUES ('',point(105.24,28.54 ),'四川省', '泸州', '105.240', '28.540');
INSERT INTO `locationPoint` VALUES ('',point(104.42,31.3 ),'四川省', '绵阳', '104.420', '31.300');
INSERT INTO `locationPoint` VALUES ('',point(106.04,30.49 ),'四川省', '南充', '106.040', '30.490');
INSERT INTO `locationPoint` VALUES ('',point(105.02,29.36 ),'四川省', '内江', '105.020', '29.360');
INSERT INTO `locationPoint` VALUES ('',point(101.43,26.34 ),'四川省', '攀枝花', '101.430', '26.340');
INSERT INTO `locationPoint` VALUES ('',point(103.57,30.59 ),'四川省', '彭州', '103.570', '30.590');
INSERT INTO `locationPoint` VALUES ('',point(103.28,30.26 ),'四川省', '邛崃', '103.280', '30.260');
INSERT INTO `locationPoint` VALUES ('',point(105.33,30.31 ),'四川省', '遂宁', '105.330', '30.310');
INSERT INTO `locationPoint` VALUES ('',point(108.21,30.5 ),'四川省', '万县', '108.210', '30.500');
INSERT INTO `locationPoint` VALUES ('',point(108.03,32.03 ),'四川省', '万源', '108.030', '32.030');
INSERT INTO `locationPoint` VALUES ('',point(102.16,27.54 ),'四川省', '西昌', '102.160', '27.540');
INSERT INTO `locationPoint` VALUES ('',point(102.59,29.59 ),'四川省', '雅安', '102.590', '29.590');
INSERT INTO `locationPoint` VALUES ('',point(104.34,28.47 ),'四川省', '宜宾', '104.340', '28.470');
INSERT INTO `locationPoint` VALUES ('',point(104.46,29.23 ),'四川省', '自贡', '104.460', '29.230');
INSERT INTO `locationPoint` VALUES ('',point(104.38,30.09 ),'四川省', '资阳', '104.380', '30.090');
INSERT INTO `locationPoint` VALUES ('',point(121.3 ,25.03 ),'*省', '台北', '121.300', '25.030');
INSERT INTO `locationPoint` VALUES ('',point(102.42,25.04 ),'云南省', '昆明', '102.420', '25.040');
INSERT INTO `locationPoint` VALUES ('',point(99.1 ,25.08 ),'云南省', '保山', '99.100', '25.080');
INSERT INTO `locationPoint` VALUES ('',point(101.32,25.01 ),'云南省', '楚雄', '101.320', '25.010');
INSERT INTO `locationPoint` VALUES ('',point(100.13,25.34 ),'云南省', '大理', '100.130', '25.340');
INSERT INTO `locationPoint` VALUES ('',point(103.12,26.06 ),'云南省', '东川', '103.120', '26.060');
INSERT INTO `locationPoint` VALUES ('',point(103.09,23.21 ),'云南省', '个旧', '103.090', '23.210');
INSERT INTO `locationPoint` VALUES ('',point(100.48,22.01 ),'云南省', '景洪', '100.480', '22.010');
INSERT INTO `locationPoint` VALUES ('',point(103.13,23.43 ),'云南省', '开远', '103.130', '23.430');
INSERT INTO `locationPoint` VALUES ('',point(103.48,25.3 ),'云南省', '曲靖', '103.480', '25.300');
INSERT INTO `locationPoint` VALUES ('',point(97.5 , ),'云南省', '瑞丽', '97.500', '24.000');
INSERT INTO `locationPoint` VALUES ('',point(100.58,22.48 ),'云南省', '思茅', '100.580', '22.480');
INSERT INTO `locationPoint` VALUES ('',point(98.04 ,24.06 ),'云南省', '畹町', '98.040', '24.060');
INSERT INTO `locationPoint` VALUES ('',point(104.06,26.13 ),'云南省', '宣威', '104.060', '26.130');
INSERT INTO `locationPoint` VALUES ('',point(102.32,24.22 ),'云南省', '玉溪', '102.320', '24.220');
INSERT INTO `locationPoint` VALUES ('',point(103.42,27.2 ),'云南省', '昭通', '103.420', '27.200');
INSERT INTO `locationPoint` VALUES ('',point(120.1 ,30.16 ),'浙江省', '杭州', '120.100', '30.160');
INSERT INTO `locationPoint` VALUES ('',point(121.15,30.11 ),'浙江省', '慈溪', '121.150', '30.110');
INSERT INTO `locationPoint` VALUES ('',point(120.14,29.16 ),'浙江省', '东阳', '120.140', '29.160');
INSERT INTO `locationPoint` VALUES ('',point(121.24,29.39 ),'浙江省', '奉化', '121.240', '29.390');
INSERT INTO `locationPoint` VALUES ('',point(119.57,30.03 ),'浙江省', '富阳', '119.570', '30.030');
INSERT INTO `locationPoint` VALUES ('',point(120.42,30.32 ),'浙江省', '海宁', '120.420', '30.320');
INSERT INTO `locationPoint` VALUES ('',point(120.06,30.52 ),'浙江省', '湖州', '120.060', '30.520');
INSERT INTO `locationPoint` VALUES ('',point(119.16,29.29 ),'浙江省', '建德', '119.160', '29.290');
INSERT INTO `locationPoint` VALUES ('',point(118.37,28.45 ),'浙江省', '*', '118.370', '28.450');
INSERT INTO `locationPoint` VALUES ('',point(120.45,30.46 ),'浙江省', '嘉兴', '120.450', '30.460');
INSERT INTO `locationPoint` VALUES ('',point(119.39,29.07 ),'浙江省', '金华', '119.390', '29.070');
INSERT INTO `locationPoint` VALUES ('',point(119.28,29.12 ),'浙江省', '兰溪', '119.280', '29.120');
INSERT INTO `locationPoint` VALUES ('',point(121.08,28.51 ),'浙江省', '临海', '121.080', '28.510');
INSERT INTO `locationPoint` VALUES ('',point(119.54,28.27 ),'浙江省', '丽水', '119.540', '28.270');
INSERT INTO `locationPoint` VALUES ('',point(119.08,28.04 ),'浙江省', '龙泉', '119.080', '28.040');
INSERT INTO `locationPoint` VALUES ('',point(121.33,29.52 ),'浙江省', '宁波', '121.330', '29.520');
INSERT INTO `locationPoint` VALUES ('',point(121.01,30.42 ),'浙江省', '平湖', '121.010', '30.420');
INSERT INTO `locationPoint` VALUES ('',point(118.52,28.58 ),'浙江省', '衢州', '118.520', '28.580');
INSERT INTO `locationPoint` VALUES ('',point(120.38,27.48 ),'浙江省', '瑞安', '120.380', '27.480');
INSERT INTO `locationPoint` VALUES ('',point(120.52,30.01 ),'浙江省', '上虞', '120.520', '30.010');
INSERT INTO `locationPoint` VALUES ('',point(120.34, ),'浙江省', '绍兴', '120.340', '30.000');
INSERT INTO `locationPoint` VALUES ('',point(121.27,28.41 ),'浙江省', '台州', '121.270', '28.410');
INSERT INTO `locationPoint` VALUES ('',point(120.32,30.38 ),'浙江省', '桐乡', '120.320', '30.380');
INSERT INTO `locationPoint` VALUES ('',point(121.21,28.22 ),'浙江省', '温岭', '121.210', '28.220');
INSERT INTO `locationPoint` VALUES ('',point(120.39,28.01 ),'浙江省', '温州', '120.390', '28.010');
INSERT INTO `locationPoint` VALUES ('',point(120.16,30.09 ),'浙江省', '萧山', '120.160', '30.090');
INSERT INTO `locationPoint` VALUES ('',point(120.04,29.18 ),'浙江省', '义乌', '120.040', '29.180');
INSERT INTO `locationPoint` VALUES ('',point(120.58,28.08 ),'浙江省', '乐清', '120.580', '28.080');
INSERT INTO `locationPoint` VALUES ('',point(120.18,30.26 ),'浙江省', '余杭', '120.180', '30.260');
INSERT INTO `locationPoint` VALUES ('',point(121.1 ,30.02 ),'浙江省', '余姚', '121.100', '30.020');
INSERT INTO `locationPoint` VALUES ('',point(120.01,29.54 ),'浙江省', '永康', '120.010', '29.540');
INSERT INTO `locationPoint` VALUES ('',point(122.06,30.01 ),'浙江省', '舟山', '122.060', '30.010');
INSERT INTO `locationPoint` VALUES ('',point(120.14,29.43 ),'浙江省', '诸暨', '120.140', '29.430');
INSERT INTO `locationPoint` VALUES ('',point(106.33,29.35 ),'重庆市', '重庆', '106.330', '29.350');
INSERT INTO `locationPoint` VALUES ('',point(106.15,30.02 ),'重庆市', '合川', '106.150', '30.020');
INSERT INTO `locationPoint` VALUES ('',point(106.16,29.18 ),'重庆市', '江津', '106.160', '29.180');
INSERT INTO `locationPoint` VALUES ('',point(107.05,29.1 ),'重庆市', '南川', '107.050', '29.100');
INSERT INTO `locationPoint` VALUES ('',point(105.53,29.23 ),'重庆市', '永川', '105.530', '29.230');
INSERT INTO `locationPoint` VALUES ('',point(116.24,39.55 ),'北京市', '北京', '116.240', '39.550');
INSERT INTO `locationPoint` VALUES ('',point(117.12,39.02 ),'天津市', '天津', '117.120', '39.020');
INSERT INTO `locationPoint` VALUES ('',point(121.29,31.14 ),'上海市', '上海', '121.290', '31.140');
INSERT INTO `locationPoint` VALUES ('',point(21.23 ,115.12),'香港', '香港', '21.230', '115.120');
INSERT INTO `locationPoint` VALUES ('',point(21.33 ,115.07),'澳门', '澳门', '21.330', '115.070');
INSERT INTO `locationPoint` VALUES ('',point(91.08 ,29.39 ),'*自治区', '拉萨', '91.080', '29.390');
INSERT INTO `locationPoint` VALUES ('',point(88.51 ,29.16 ),'*自治区', '日喀则', '88.510', '29.160');
INSERT INTO `locationPoint` VALUES ('',point(111.41,40.48 ),'内蒙古自治区', '呼和浩特', '111.410', '40.480');
INSERT INTO `locationPoint` VALUES ('',point(109.49,40.39 ),'内蒙古自治区', '包头', '109.490', '40.390');
INSERT INTO `locationPoint` VALUES ('',point(118.58,42.17 ),'内蒙古自治区', '赤峰', '118.580', '42.170');
INSERT INTO `locationPoint` VALUES ('',point(109.59,39.48 ),'内蒙古自治区', '东胜', '109.590', '39.480');
INSERT INTO `locationPoint` VALUES ('',point(111.58,43.38 ),'内蒙古自治区', '二连浩特', '111.580', '43.380');
INSERT INTO `locationPoint` VALUES ('',point(120.11,50.13 ),'内蒙古自治区', '额尔古纳', '120.110', '50.130');
INSERT INTO `locationPoint` VALUES ('',point(113.09,40.27 ),'内蒙古自治区', '丰镇', '113.090', '40.270');
INSERT INTO `locationPoint` VALUES ('',point(121.29,50.48 ),'内蒙古自治区', '根河', '121.290', '50.480');
INSERT INTO `locationPoint` VALUES ('',point(119.39,49.12 ),'内蒙古自治区', '海拉尔', '119.390', '49.120');
INSERT INTO `locationPoint` VALUES ('',point(119.38,45.32 ),'内蒙古自治区', '霍林郭勒', '119.380', '45.320');
INSERT INTO `locationPoint` VALUES ('',point(113.06,41.02 ),'内蒙古自治区', '集宁', '113.060', '41.020');
INSERT INTO `locationPoint` VALUES ('',point(107.22,40.46 ),'内蒙古自治区', '临河', '107.220', '40.460');
INSERT INTO `locationPoint` VALUES ('',point(117.23,49.35 ),'内蒙古自治区', '满洲里', '117.230', '49.350');
INSERT INTO `locationPoint` VALUES ('',point(122.16,43.37 ),'内蒙古自治区', '通辽', '122.160', '43.370');
INSERT INTO `locationPoint` VALUES ('',point(122.03,46.03 ),'内蒙古自治区', '乌兰浩特', '122.030', '46.030');
INSERT INTO `locationPoint` VALUES ('',point(106.48,39.4 ),'内蒙古自治区', '乌海', '106.480', '39.400');
INSERT INTO `locationPoint` VALUES ('',point(116.03,43.57 ),'内蒙古自治区', '锡林浩特', '116.030', '43.570');
INSERT INTO `locationPoint` VALUES ('',point(120.4 ,49.17 ),'内蒙古自治区', '牙克石', '120.400', '49.170');
INSERT INTO `locationPoint` VALUES ('',point(122.47, ),'内蒙古自治区', '扎兰屯', '122.470', '48.000');
INSERT INTO `locationPoint` VALUES ('',point(106.16,38.27 ),'宁夏自治区', '银川', '106.160', '38.270');
INSERT INTO `locationPoint` VALUES ('',point(105.59,37.56 ),'宁夏自治区', '青铜峡', '105.590', '37.560');
INSERT INTO `locationPoint` VALUES ('',point(106.22,39.02 ),'宁夏自治区', '石嘴山', '106.220', '39.020');
INSERT INTO `locationPoint` VALUES ('',point(106.11,37.59 ),'宁夏自治区', '吴忠', '106.110', '37.590');
INSERT INTO `locationPoint` VALUES ('',point(87.36 ,43.45 ),'*自治区', '乌鲁木齐', '87.360', '43.450');
INSERT INTO `locationPoint` VALUES ('',point(80.19 ,41.09 ),'*自治区', '阿克苏', '80.190', '41.090');
INSERT INTO `locationPoint` VALUES ('',point(88.12 ,47.5 ),'*自治区', '阿勒泰', '88.120', '47.500');
INSERT INTO `locationPoint` VALUES ('',point(76.08 ,39.42 ),'*自治区', '阿图什', '76.080', '39.420');
INSERT INTO `locationPoint` VALUES ('',point(82.08 ,44.57 ),'*自治区', '博乐', '82.080', '44.570');
INSERT INTO `locationPoint` VALUES ('',point(87.18 ,44.02 ),'*自治区', '昌吉', '87.180', '44.020');
INSERT INTO `locationPoint` VALUES ('',point(87.58 ,44.09 ),'*自治区', '阜康', '87.580', '44.090');
INSERT INTO `locationPoint` VALUES ('',point(93.28 ,42.5 ),'*自治区', '哈密', '93.280', '42.500');
INSERT INTO `locationPoint` VALUES ('',point(79.55 ,37.09 ),'*自治区', '和田', '79.550', '37.090');
INSERT INTO `locationPoint` VALUES ('',point(84.51 ,45.36 ),'*自治区', '克拉玛依', '84.510', '45.360');
INSERT INTO `locationPoint` VALUES ('',point(75.59 ,39.3 ),'*自治区', '喀什', '75.590', '39.300');
INSERT INTO `locationPoint` VALUES ('',point(86.07 ,41.46 ),'*自治区', '库尔勒', '86.070', '41.460');
INSERT INTO `locationPoint` VALUES ('',point(84.56 ,44.27 ),'*自治区', '奎屯', '84.560', '44.270');
INSERT INTO `locationPoint` VALUES ('',point( ,44.18 ),'*自治区', '石河子', '86.000', '44.180');
INSERT INTO `locationPoint` VALUES ('',point(82.59 ,46.46 ),'*自治区', '塔城', '82.590', '46.460');
INSERT INTO `locationPoint` VALUES ('',point(89.11 ,42.54 ),'*自治区', '吐鲁番', '89.110', '42.540');
INSERT INTO `locationPoint` VALUES ('',point(81.2 ,43.55 ),'*自治区', '伊宁', '81.200', '43.550');
 

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

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

select * from city where LAT > '34.7466'- and LAT < '34.7466'+ and LNG > '113.625368'- and LNG < '113.625368'+ order by ACOS(SIN(('34.7466' * 3.1415) /  ) *SIN((LAT * 3.1415) /  ) +COS(('34.7466' * 3.1415) /  ) * COS((LAT * 3.1415) /  ) *COS(('113.625368'* 3.1415) /  - (LNG * 3.1415) /  ) ) *  asc limit 

其中  '34.7466'  '113.625368' 是 河南省郑州市 的经纬度信息,查询结果如下图:

Mysql 地区经纬度 查询

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

来源:

https://my.oschina.net/alexgaoyh/blog/392123