幾種實(shí)現(xiàn)經(jīng)緯度查詢排序

在實(shí)際應(yīng)用開(kāi)發(fā)中，經(jīng)常有這么一個(gè)需求：給定一個(gè)經(jīng)緯度，實(shí)現(xiàn)查找附近的人或物扼褪。其實(shí)現(xiàn)方式也有多種：基于MySQL的、基于MongoDB的粱栖，故開(kāi)篇記錄總結(jié)一下各種方式的實(shí)現(xiàn)话浇。當(dāng)然在選擇技術(shù)方案，需要考量自身的成本闹究，適合自己的就是最好的幔崖。

數(shù)據(jù)準(zhǔn)備

表結(jié)構(gòu)及數(shù)據(jù)是網(wǎng)上找來(lái)的，方便測(cè)試渣淤，數(shù)據(jù)太多赏寇，放在文章最后的附錄中，有需要的可以查看价认。

# 表結(jié)構(gòu)
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;

方案1：基于MySQL的實(shí)現(xiàn)方式

基于MySQL的實(shí)現(xiàn)也有2種方式嗅定，一種利用MySQL的空間擴(kuò)展（MySQL Spatial Extensions），還有一種是單純用sql語(yǔ)句實(shí)現(xiàn)用踩。

（一）MySQL Spatial Extensions

這里簡(jiǎn)單介紹下MySQL Spatial Extensions渠退，這是MySQL的空間擴(kuò)展忙迁，支持集中空間數(shù)據(jù)類型（Point，LineString碎乃，Polygon）姊扔，但自身支持的API并不多。支持的存儲(chǔ)引擎有Myisam梅誓、InnoDB旱眯，區(qū)別是Myisam引擎只是spatial index，而InnoDB并不支持证九。當(dāng)一個(gè)字段被加上spatial index索引時(shí)删豺，在查詢中使用一些內(nèi)建spatial相關(guān)的函數(shù)，將會(huì)優(yōu)化查詢速度愧怜。但在不使用內(nèi)建函數(shù)時(shí)呀页，并沒(méi)有什么卵用。
利用這種方式實(shí)現(xiàn)需要經(jīng)緯度的數(shù)據(jù)類型為Point拥坛。具體實(shí)現(xiàn)sql如下：

select id, pt,city from locationpoint  ORDER BY GLength(LineStringFromWKB(LineString(pt, point(113.4 ,34.46)))) ASC

（二）sql實(shí)現(xiàn)

sql實(shí)現(xiàn)原理是根據(jù)給定點(diǎn)與數(shù)據(jù)庫(kù)點(diǎn)坐標(biāo)計(jì)算距離排序蓬蝶。根據(jù)經(jīng)緯度計(jì)算距離公式如下：

地球半徑 R=6378.140KM

C = sin(LatA)*sin(LatB) + cos(LatA)*cos(LatB)*cos(MLonA-MLonB)
Distance = R*Arccos(C)*Pi/180

C = sin(LatA*Pi/180)*sin(LatB*Pi/180) + cos(LatA*Pi/180)*cos(LatB*Pi/180)*cos((MLonA-MLonB)*Pi/180)
Distance = R*Arccos(C)

SELECT
    id,
    pt,
    city
FROM
    locationpoint
ORDER BY
    ACOS(
        SIN(34.46 * PI() / 180) * SIN(latitude * PI() / 180) + COS(34.46 * PI() / 180) * COS(latitude * PI() / 180) * COS(
            113.4 * PI() / 180 - longitude * PI() / 180
        )
    ) * 6378.14 ASC
LIMIT 10;

方案2：基于MongoDB實(shí)現(xiàn)

Mongodb專門針對(duì)這種查詢建立了地理空間索引。 2d和2dsphere索引猜惋，分別是針對(duì)平面和球面丸氛。建立一張簡(jiǎn)單的表如下：

{
  "_id": ObjectId("518b1f1a83ba88ca60000001"),
  "loc":
 [
    104.067221,
    30.620076
  ]
}

{
  "_id": ObjectId("518b1f1a83ba88ca60000002"),
  "loc":
 [
    104.067222,
    30.620046
  ]
}

（注：loc為二維數(shù)組，分別為經(jīng)度著摔，緯度且必須按照（經(jīng)度缓窜，緯度）順序存儲(chǔ)）

標(biāo)準(zhǔn)查詢方式，為地球經(jīng)緯度查詢內(nèi)置谍咆；
參數(shù)一: 為查詢條件利用$near查找附近;
參數(shù)二: $maxDistance為經(jīng)緯弧度（1° latitude = 111.12 kilometers）即 1/111.12禾锤，表示查找附近一公里。

db.user.find({
 gps :{ $near : [104.065847, 30.657554] , $maxDistance : 1/111.12} })

執(zhí)行命名方式摹察，模擬成一個(gè)圓球,表示查詢一公里矾利；
參數(shù)一: 指定geoNear方式和表名捣鲸；
參數(shù)二: 坐標(biāo);
參數(shù)三:是否為球形;
參數(shù)四:弧度（弧度=弧長(zhǎng)/半徑一千米的弧度1000/6378000）;
參數(shù)五:指定球形半徑（地球半徑）

db.runCommand({geoNear:'user',
 near:[104.065847, 30.657554], spherical:true,
 maxDistance:1000/6378000, distanceMultiplier:6378000});

附錄：相關(guān)數(shù)據(jù)

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 ),'安徽省', '阜陽(yáng)', '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 ),'安徽省', '天長(zhǎng)', '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 ),'福建省', '長(zhǎng)樂(lè)', '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 ),'福建省', '建陽(yáng)', '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 ),'甘肅省', '嘉峪關(guān)', '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 ),'甘肅省', '平?jīng)?, '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 ),'廣東省', '潮陽(yáng)', '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 ),'廣東省', '惠陽(yáng)', '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 ),'廣東省', '揭陽(yáng)', '116.210', '22.320');
INSERT INTO `locationPoint` VALUES ('1221',point(112.4 ,22.22 ),'廣東省', '開(kāi)平', '112.400', '22.220');
INSERT INTO `locationPoint` VALUES ('1222',point(113.21,25.09 ),'廣東省', '樂(lè)昌', '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 ),'廣東省', '清遠(yuǎn)', '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 ),'廣東省', '韶關(guān)', '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 ),'廣東省', '四會(huì)', '112.410', '23.210');
INSERT INTO `locationPoint` VALUES ('1240',point(112.48,22.15 ),'廣東省', '臺(tái)山', '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 ),'廣東省', '新會(huì)', '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  ),'廣東省', '陽(yáng)春', '111.480', '22.100');
INSERT INTO `locationPoint` VALUES ('1245',point(111.58,21.5  ),'廣東省', '陽(yáng)江', '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 ),'貴州省', '貴陽(yáng)', '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 ),'貴州省', '畢節(jié)', '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 ),'貴州省', '清鎮(zhèn)', '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 ),'河北省', '安國(guó)', '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 ),'河北省', '邢臺(tái)', '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  ),'河北省', '新樂(lè)', '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 ),'河南省', '安陽(yáng)', '114.210', '36.060');
INSERT INTO `locationPoint` VALUES ('1321',point(113.47,34.12 ),'河南省', '長(zhǎng)葛', '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 ),'河南省', '濟(jì)源', '112.350', '35.040');
INSERT INTO `locationPoint` VALUES ('1329',point(114.21,34.47 ),'河南省', '開(kāi)封', '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 ),'河南省', '洛陽(yáng)', '112.270', '34.410');
INSERT INTO `locationPoint` VALUES ('1334',point(112.32,33    ),'河南省', '南陽(yáng)', '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 ),'河南省', '濮陽(yáng)', '115.010', '35.440');
INSERT INTO `locationPoint` VALUES ('1337',point(112.57,35.05 ),'河南省', '沁陽(yáng)', '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 ),'河南省', '衛(wèi)輝', '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 ),'河南省', '項(xiàng)城', '114.540', '33.260');
INSERT INTO `locationPoint` VALUES ('1344',point(113.21,34.46 ),'河南省', '滎陽(yáng)', '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 ),'河南省', '新鄉(xiāng)', '113.520', '35.180');
INSERT INTO `locationPoint` VALUES ('1347',point(114.04,32.07 ),'河南省', '信陽(yáng)', '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 ),'黑龍江省', '安達(dá)', '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 ),'黑龍江省', '七臺(tái)河', '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  ),'湖北省', '當(dāng)陽(yáng)', '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 ),'湖北省', '應(yīng)城', '113.330', '30.570');
INSERT INTO `locationPoint` VALUES ('1414',point(112.44,32.07 ),'湖北省', '棗陽(yáng)', '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 ),'湖南省', '長(zhǎng)沙', '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 ),'湖南省', '衡陽(yáng)', '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 ),'湖南省', '耒陽(yáng)', '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 ),'湖南省', '瀏陽(yáng)', '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 ),'湖南省', '邵陽(yáng)', '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 ),'湖南省', '湘鄉(xiāng)', '112.310', '27.440');
INSERT INTO `locationPoint` VALUES ('1439',point(112.2 ,28.36 ),'湖南省', '益陽(yáng)', '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 ),'湖南省', '岳陽(yáng)', '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 ),'吉林省', '長(zhǎng)春', '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 ),'吉林省', '九臺(tái)', '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 ),'吉林省', '愉樹(shù)', '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    ),'江蘇省', '丹陽(yáng)', '119.320', '32.000');
INSERT INTO `locationPoint` VALUES ('1476',point(120.19,32.51 ),'江蘇省', '東臺(tái)', '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 ),'江蘇省', '溧陽(yáng)', '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 ),'江蘇省', '啟樂(lè)', '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 ),'江蘇省', '太倉(cāng)', '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 ),'江蘇省', '無(wú)錫', '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 ),'江蘇省', '揚(yáng)中', '119.490', '32.140');
INSERT INTO `locationPoint` VALUES ('1506',point(119.26,32.23 ),'江蘇省', '揚(yáng)州', '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 ),'江蘇省', '鎮(zhèn)江', '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 ),'江西省', '景德鎮(zhèn)', '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 ),'江西省', '樂(lè)平', '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 ),'江西省', '萍鄉(xiāng)', '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 ),'江西省', '樟樹(shù)', '115.320', '28.030');
INSERT INTO `locationPoint` VALUES ('1530',point(123.25,41.48 ),'遼寧省', '沈陽(yáng)', '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 ),'遼寧省', '朝陽(yáng)', '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 ),'遼寧省', '開(kāi)原', '124.020', '42.320');
INSERT INTO `locationPoint` VALUES ('1547',point(123.12,41.16 ),'遼寧省', '遼陽(yáng)', '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 ),'遼寧省', '營(yíng)口', '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  ),'山東省', '濟(jì)南', '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 ),'山東省', '東營(yíng)', '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 ),'山東省', '濟(jì)寧', '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 ),'山東省', '萊陽(yáng)', '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 ),'山東省', '樂(lè)陵', '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 ),'山東省', '煙臺(tái)', '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 ),'山東省', '招遠(yuǎn)', '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 ),'山西省', '長(zhǎng)治', '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 ),'山西省', '陽(yáng)泉', '113.340', '37.510');
INSERT INTO `locationPoint` VALUES ('1624',point(110.27,34.52 ),'山西省', '永濟(jì)', '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 ),'山西省', '運(yùn)城', '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  ),'陜西省', '咸陽(yáng)', '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 ),'四川省', '達(dá)川', '107.290', '31.140');
INSERT INTO `locationPoint` VALUES ('1645',point(104.22,31.09 ),'四川省', '德陽(yáng)', '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 ),'四川省', '簡(jiǎn)陽(yáng)', '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 ),'四川省', '樂(lè)山', '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  ),'四川省', '綿陽(yáng)', '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 ),'四川省', '內(nèi)江', '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  ),'四川省', '萬(wàn)縣', '108.210', '30.500');
INSERT INTO `locationPoint` VALUES ('1665',point(108.03,32.03 ),'四川省', '萬(wàn)源', '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 ),'四川省', '資陽(yáng)', '104.380', '30.090');
INSERT INTO `locationPoint` VALUES ('1671',point(121.3 ,25.03 ),'臺(tái)灣省', '臺(tái)北', '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 ),'云南省', '個(gè)舊', '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 ),'云南省', '開(kāi)遠(yuǎn)', '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 ),'浙江省', '東陽(yáng)', '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 ),'浙江省', '富陽(yáng)', '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 ),'浙江省', '臺(tái)州', '121.270', '28.410');
INSERT INTO `locationPoint` VALUES ('1709',point(120.32,30.38 ),'浙江省', '桐鄉(xiāng)', '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 ),'浙江省', '樂(lè)清', '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 ),'西藏自治區(qū)', '拉薩', '91.080', '29.390');
INSERT INTO `locationPoint` VALUES ('1731',point(88.51 ,29.16 ),'西藏自治區(qū)', '日喀則', '88.510', '29.160');
INSERT INTO `locationPoint` VALUES ('1732',point(111.41,40.48 ),'內(nèi)蒙古自治區(qū)', '呼和浩特', '111.410', '40.480');
INSERT INTO `locationPoint` VALUES ('1733',point(109.49,40.39 ),'內(nèi)蒙古自治區(qū)', '包頭', '109.490', '40.390');
INSERT INTO `locationPoint` VALUES ('1734',point(118.58,42.17 ),'內(nèi)蒙古自治區(qū)', '赤峰', '118.580', '42.170');
INSERT INTO `locationPoint` VALUES ('1735',point(109.59,39.48 ),'內(nèi)蒙古自治區(qū)', '東勝', '109.590', '39.480');
INSERT INTO `locationPoint` VALUES ('1736',point(111.58,43.38 ),'內(nèi)蒙古自治區(qū)', '二連浩特', '111.580', '43.380');
INSERT INTO `locationPoint` VALUES ('1737',point(120.11,50.13 ),'內(nèi)蒙古自治區(qū)', '額爾古納', '120.110', '50.130');
INSERT INTO `locationPoint` VALUES ('1738',point(113.09,40.27 ),'內(nèi)蒙古自治區(qū)', '豐鎮(zhèn)', '113.090', '40.270');
INSERT INTO `locationPoint` VALUES ('1739',point(121.29,50.48 ),'內(nèi)蒙古自治區(qū)', '根河', '121.290', '50.480');
INSERT INTO `locationPoint` VALUES ('1740',point(119.39,49.12 ),'內(nèi)蒙古自治區(qū)', '海拉爾', '119.390', '49.120');
INSERT INTO `locationPoint` VALUES ('1741',point(119.38,45.32 ),'內(nèi)蒙古自治區(qū)', '霍林郭勒', '119.380', '45.320');
INSERT INTO `locationPoint` VALUES ('1742',point(113.06,41.02 ),'內(nèi)蒙古自治區(qū)', '集寧', '113.060', '41.020');
INSERT INTO `locationPoint` VALUES ('1743',point(107.22,40.46 ),'內(nèi)蒙古自治區(qū)', '臨河', '107.220', '40.460');
INSERT INTO `locationPoint` VALUES ('1744',point(117.23,49.35 ),'內(nèi)蒙古自治區(qū)', '滿洲里', '117.230', '49.350');
INSERT INTO `locationPoint` VALUES ('1745',point(122.16,43.37 ),'內(nèi)蒙古自治區(qū)', '通遼', '122.160', '43.370');
INSERT INTO `locationPoint` VALUES ('1746',point(122.03,46.03 ),'內(nèi)蒙古自治區(qū)', '烏蘭浩特', '122.030', '46.030');
INSERT INTO `locationPoint` VALUES ('1747',point(106.48,39.4  ),'內(nèi)蒙古自治區(qū)', '烏海', '106.480', '39.400');
INSERT INTO `locationPoint` VALUES ('1748',point(116.03,43.57 ),'內(nèi)蒙古自治區(qū)', '錫林浩特', '116.030', '43.570');
INSERT INTO `locationPoint` VALUES ('1749',point(120.4 ,49.17 ),'內(nèi)蒙古自治區(qū)', '牙克石', '120.400', '49.170');
INSERT INTO `locationPoint` VALUES ('1750',point(122.47,48    ),'內(nèi)蒙古自治區(qū)', '扎蘭屯', '122.470', '48.000');
INSERT INTO `locationPoint` VALUES ('1751',point(106.16,38.27 ),'寧夏自治區(qū)', '銀川', '106.160', '38.270');
INSERT INTO `locationPoint` VALUES ('1752',point(105.59,37.56 ),'寧夏自治區(qū)', '青銅峽', '105.590', '37.560');
INSERT INTO `locationPoint` VALUES ('1753',point(106.22,39.02 ),'寧夏自治區(qū)', '石嘴山', '106.220', '39.020');
INSERT INTO `locationPoint` VALUES ('1754',point(106.11,37.59 ),'寧夏自治區(qū)', '吳忠', '106.110', '37.590');
INSERT INTO `locationPoint` VALUES ('1755',point(87.36 ,43.45 ),'新疆自治區(qū)', '烏魯木齊', '87.360', '43.450');
INSERT INTO `locationPoint` VALUES ('1756',point(80.19 ,41.09 ),'新疆自治區(qū)', '阿克蘇', '80.190', '41.090');
INSERT INTO `locationPoint` VALUES ('1757',point(88.12 ,47.5  ),'新疆自治區(qū)', '阿勒泰', '88.120', '47.500');
INSERT INTO `locationPoint` VALUES ('1758',point(76.08 ,39.42 ),'新疆自治區(qū)', '阿圖什', '76.080', '39.420');
INSERT INTO `locationPoint` VALUES ('1759',point(82.08 ,44.57 ),'新疆自治區(qū)', '博樂(lè)', '82.080', '44.570');
INSERT INTO `locationPoint` VALUES ('1760',point(87.18 ,44.02 ),'新疆自治區(qū)', '昌吉', '87.180', '44.020');
INSERT INTO `locationPoint` VALUES ('1761',point(87.58 ,44.09 ),'新疆自治區(qū)', '阜康', '87.580', '44.090');
INSERT INTO `locationPoint` VALUES ('1762',point(93.28 ,42.5  ),'新疆自治區(qū)', '哈密', '93.280', '42.500');
INSERT INTO `locationPoint` VALUES ('1763',point(79.55 ,37.09 ),'新疆自治區(qū)', '和田', '79.550', '37.090');
INSERT INTO `locationPoint` VALUES ('1764',point(84.51 ,45.36 ),'新疆自治區(qū)', '克拉瑪依', '84.510', '45.360');
INSERT INTO `locationPoint` VALUES ('1765',point(75.59 ,39.3  ),'新疆自治區(qū)', '喀什', '75.590', '39.300');
INSERT INTO `locationPoint` VALUES ('1766',point(86.07 ,41.46 ),'新疆自治區(qū)', '庫(kù)爾勒', '86.070', '41.460');
INSERT INTO `locationPoint` VALUES ('1767',point(84.56 ,44.27 ),'新疆自治區(qū)', '奎屯', '84.560', '44.270');
INSERT INTO `locationPoint` VALUES ('1768',point(86    ,44.18 ),'新疆自治區(qū)', '石河子', '86.000', '44.180');
INSERT INTO `locationPoint` VALUES ('1769',point(82.59 ,46.46 ),'新疆自治區(qū)', '塔城', '82.590', '46.460');
INSERT INTO `locationPoint` VALUES ('1770',point(89.11 ,42.54 ),'新疆自治區(qū)', '吐魯番', '89.110', '42.540');
INSERT INTO `locationPoint` VALUES ('1771',point(81.2  ,43.55 ),'新疆自治區(qū)', '伊寧', '81.200', '43.550');

最后編輯于：2017.12.04 03:48:57

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者

人面猴
序言：七十年代末糯而，一起剝皮案震驚了整個(gè)濱河市，隨后出現(xiàn)的幾起案子克滴，更是在濱河造成了極大的恐慌逼争，老刑警劉巖，帶你破解...
沈念sama閱讀 211,123評(píng)論 6贊 490
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件偿曙，死亡現(xiàn)場(chǎng)離奇詭異氮凝，居然都是意外死亡羔巢，警方通過(guò)查閱死者的電腦和手機(jī)望忆，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 90,031評(píng)論 2贊 384
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進(jìn)店門罩阵，熙熙樓的掌柜王于貴愁眉苦臉地迎上來(lái)，“玉大人启摄，你說(shuō)我怎么就攤上這事稿壁。” “怎么了歉备？”我有些...
開(kāi)封第一講書(shū)人閱讀 156,723評(píng)論 0贊 345
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵傅是，是天一觀的道長(zhǎng)。經(jīng)常有香客問(wèn)我蕾羊，道長(zhǎng)喧笔，這世上最難降的妖魔是什么？我笑而不...
開(kāi)封第一講書(shū)人閱讀 56,357評(píng)論 1贊 283
?港島之戀（遺憾婚禮）
正文為了忘掉前任龟再，我火速辦了婚禮书闸，結(jié)果婚禮上，老公的妹妹穿的比我還像新娘利凑。我一直安慰自己浆劲，他們只是感情好，可當(dāng)我...
茶點(diǎn)故事閱讀 65,412評(píng)論 5贊 384
惡毒庶女頂嫁案：這布局不是一般人想出來(lái)的
文/花漫我一把揭開(kāi)白布哀澈。她就那樣靜靜地躺著牌借，像睡著了一般。火紅的嫁衣襯著肌膚如雪割按。梳的紋絲不亂的頭發(fā)上膨报，一...
開(kāi)封第一講書(shū)人閱讀 49,760評(píng)論 1贊 289
城市分裂傳說(shuō)
那天，我揣著相機(jī)與錄音适荣，去河邊找鬼丙躏。笑死，一個(gè)胖子當(dāng)著我的面吹牛束凑，可吹牛的內(nèi)容都是我干的晒旅。我是一名探鬼主播，決...
沈念sama閱讀 38,904評(píng)論 3贊 405
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開(kāi)眼汪诉，長(zhǎng)吁一口氣：“原來(lái)是場(chǎng)噩夢(mèng)啊……” “哼废恋！你這毒婦竟也來(lái)了？” 一聲冷哼從身側(cè)響起扒寄，我...
開(kāi)封第一講書(shū)人閱讀 37,672評(píng)論 0贊 266
萬(wàn)榮殺人案實(shí)錄
序言：老撾萬(wàn)榮一對(duì)情侶失蹤鱼鼓，失蹤者是張志新（化名）和其女友劉穎，沒(méi)想到半個(gè)月后该编，有當(dāng)?shù)厝嗽跇?shù)林里發(fā)現(xiàn)了一具尸體迄本，經(jīng)...
沈念sama閱讀 44,118評(píng)論 1贊 303
?護(hù)林員之死
正文獨(dú)居荒郊野嶺守林人離奇死亡，尸身上長(zhǎng)有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點(diǎn)故事閱讀 36,456評(píng)論 2贊 325
?白月光啟示錄
正文我和宋清朗相戀三年课竣，在試婚紗的時(shí)候發(fā)現(xiàn)自己被綠了嘉赎。大學(xué)時(shí)的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片置媳。...
茶點(diǎn)故事閱讀 38,599評(píng)論 1贊 340
活死人
序言：一個(gè)原本活蹦亂跳的男人離奇死亡，死狀恐怖公条，靈堂內(nèi)的尸體忽然破棺而出拇囊，到底是詐尸還是另有隱情，我是刑警寧澤靶橱，帶...
沈念sama閱讀 34,264評(píng)論 4贊 328
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布寥袭，位于F島的核電站，受9級(jí)特大地震影響关霸，放射性物質(zhì)發(fā)生泄漏传黄。R本人自食惡果不足惜，卻給世界環(huán)境...
茶點(diǎn)故事閱讀 39,857評(píng)論 3贊 312
男人毒藥：我在死后第九天來(lái)索命
文/蒙蒙一队寇、第九天我趴在偏房一處隱蔽的房頂上張望尝江。院中可真熱鬧，春花似錦英上、人聲如沸炭序。這莊子的主人今日做“春日...
開(kāi)封第一講書(shū)人閱讀 30,731評(píng)論 0贊 21
一樁弒父案苍日，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽(yáng)惭聂。三九已至，卻和暖如春相恃，著一層夾襖步出監(jiān)牢的瞬間辜纲，已是汗流浹背。一陣腳步聲響...
開(kāi)封第一講書(shū)人閱讀 31,956評(píng)論 1贊 264
情欲美人皮
我被黑心中介騙來(lái)泰國(guó)打工拦耐，沒(méi)想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留耕腾，地道東北人。一個(gè)月前我還...
沈念sama閱讀 46,286評(píng)論 2贊 360
代替公主和親
正文我出身青樓杀糯，卻偏偏與公主長(zhǎng)得像扫俺，于是被迫代替她去往敵國(guó)和親。傳聞我的和親對(duì)象是個(gè)殘疾皇子固翰，可洞房花燭夜當(dāng)晚...
茶點(diǎn)故事閱讀 43,465評(píng)論 2贊 348