首页 > 数据库技术 > 详细

全国各省市GeoCoord SQL文件(不包括区县)

时间:2015-07-27 18:06:57      阅读:930      评论:0      收藏:0      [点我收藏+]
技术分享
/*
Navicat MySQL Data Transfer

Source Server         : 192.168.0.234
Source Server Version : 50543
Source Host           : 192.168.0.234:3306
Source Database       : sms

Target Server Type    : MYSQL
Target Server Version : 50543
File Encoding         : 65001

Date: 2015-07-27 16:29:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for geocoord
-- ----------------------------
DROP TABLE IF EXISTS `geocoord`;
CREATE TABLE `geocoord` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` int(255) DEFAULT NULL,
  `province` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `city` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `latitude` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitude` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=622 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of geocoord
-- ----------------------------
INSERT INTO `geocoord` VALUES (1, 0, 安徽, 合肥, 31.52, 117.17);
INSERT INTO `geocoord` VALUES (2, 0, 安徽, 安庆, 30.31, 117.02);
INSERT INTO `geocoord` VALUES (3, 0, 安徽, 蚌埠, 32.56, 117.21);
INSERT INTO `geocoord` VALUES (4, 0, 安徽, 亳州, 33.52, 115.47);
INSERT INTO `geocoord` VALUES (5, 0, 安徽, 巢湖, 31.36, 117.52);
INSERT INTO `geocoord` VALUES (6, 0, 安徽, 滁州, 32.18, 118.18);
INSERT INTO `geocoord` VALUES (7, 0, 安徽, 阜阳, 32.54, 115.48);
INSERT INTO `geocoord` VALUES (8, 0, 安徽, 贵池, 30.39, 117.28);
INSERT INTO `geocoord` VALUES (9, 0, 安徽, 淮北, 33.57, 116.47);
INSERT INTO `geocoord` VALUES (10, 0, 安徽, 淮南, 32.37, 116.58);
INSERT INTO `geocoord` VALUES (11, 0, 安徽, 黄山, 29.43, 118.18);
INSERT INTO `geocoord` VALUES (12, 0, 安徽, 界首, 33.15, 115.21);
INSERT INTO `geocoord` VALUES (13, 0, 安徽, 六安, 31.44, 116.28);
INSERT INTO `geocoord` VALUES (14, 0, 安徽, 马鞍山, 31.43, 118.28);
INSERT INTO `geocoord` VALUES (15, 0, 安徽, 明光, 32.47, 117.58);
INSERT INTO `geocoord` VALUES (16, 0, 安徽, 宿州, 33.38, 116.58);
INSERT INTO `geocoord` VALUES (17, 0, 安徽, 天长, 32.41, 118.59);
INSERT INTO `geocoord` VALUES (18, 0, 安徽, 铜陵, 30.56, 117.48);
INSERT INTO `geocoord` VALUES (19, 0, 安徽, 芜湖, 31.19, 118.22);
INSERT INTO `geocoord` VALUES (20, 0, 安徽, 宣州, 30.57, 118.44);
INSERT INTO `geocoord` VALUES (21, 0, 澳门, 澳门, 21.33, 115.07);
INSERT INTO `geocoord` VALUES (22, 0, 北京, 北京, 39.55, 116.24);
INSERT INTO `geocoord` VALUES (23, 0, 福建, 福州, 26.05, 119.18);
INSERT INTO `geocoord` VALUES (24, 0, 福建, 长乐, 25.58, 119.31);
INSERT INTO `geocoord` VALUES (25, 0, 福建, 福安, 27.06, 119.39);
INSERT INTO `geocoord` VALUES (26, 0, 福建, 福清, 25.42, 119.23);
INSERT INTO `geocoord` VALUES (27, 0, 福建, 建瓯, 27.03, 118.20);
INSERT INTO `geocoord` VALUES (28, 0, 福建, 建阳, 27.21, 118.07);
INSERT INTO `geocoord` VALUES (29, 0, 福建, 晋江, 24.49, 118.35);
INSERT INTO `geocoord` VALUES (30, 0, 福建, 龙海, 24.26, 117.48);
INSERT INTO `geocoord` VALUES (31, 0, 福建, 龙岩, 25.06, 117.01);
INSERT INTO `geocoord` VALUES (32, 0, 福建, 南安, 24.57, 118.23);
INSERT INTO `geocoord` VALUES (33, 0, 福建, 南平, 26.38, 118.10);
INSERT INTO `geocoord` VALUES (34, 0, 福建, 宁德, 26.39, 119.31);
INSERT INTO `geocoord` VALUES (35, 0, 福建, 莆田, 24.26, 119.01);
INSERT INTO `geocoord` VALUES (36, 0, 福建, 泉州, 24.56, 118.36);
INSERT INTO `geocoord` VALUES (37, 0, 福建, 三明, 26.13, 117.36);
INSERT INTO `geocoord` VALUES (38, 0, 福建, 邵武, 27.20, 117.29);
INSERT INTO `geocoord` VALUES (39, 0, 福建, 石狮, 24.44, 118.38);
INSERT INTO `geocoord` VALUES (40, 0, 福建, 武夷山, 27.46, 118.02);
INSERT INTO `geocoord` VALUES (41, 0, 福建, 厦门, 24.27, 118.06);
INSERT INTO `geocoord` VALUES (42, 0, 福建, 永安, 25.58, 117.23);
INSERT INTO `geocoord` VALUES (43, 0, 福建, 漳平, 25.17, 117.24);
INSERT INTO `geocoord` VALUES (44, 0, 福建, 漳州, 24.31, 117.39);
INSERT INTO `geocoord` VALUES (45, 0, 甘肃, 兰州, 36.04, 103.51);
INSERT INTO `geocoord` VALUES (46, 0, 甘肃, 白银, 36.33, 104.12);
INSERT INTO `geocoord` VALUES (47, 0, 甘肃, 敦煌, 40.08, 94.41);
INSERT INTO `geocoord` VALUES (48, 0, 甘肃, 嘉峪关, 39.48, 98.14);
INSERT INTO `geocoord` VALUES (49, 0, 甘肃, 金昌, 38.28, 102.10);
INSERT INTO `geocoord` VALUES (50, 0, 甘肃, 酒泉, 39.44, 98.31);
INSERT INTO `geocoord` VALUES (51, 0, 甘肃, 临夏, 35.37, 103.12);
INSERT INTO `geocoord` VALUES (52, 0, 甘肃, 平凉, 35.32, 106.40);
INSERT INTO `geocoord` VALUES (53, 0, 甘肃, 天水, 34.37, 105.42);
INSERT INTO `geocoord` VALUES (54, 0, 甘肃, 武威, 37.56, 102.39);
INSERT INTO `geocoord` VALUES (55, 0, 甘肃, 西峰, 35.45, 107.40);
INSERT INTO `geocoord` VALUES (56, 0, 甘肃, 玉门, 39.49, 97.35);
INSERT INTO `geocoord` VALUES (57, 0, 甘肃, 张掖, 38.56, 100.26);
INSERT INTO `geocoord` VALUES (58, 0, 广东, 广州, 23.08, 113.14);
INSERT INTO `geocoord` VALUES (59, 0, 广东, 潮阳, 23.16, 116.36);
INSERT INTO `geocoord` VALUES (60, 0, 广东, 潮州, 23.40, 116.38);
INSERT INTO `geocoord` VALUES (61, 0, 广东, 澄海, 23.28, 116.46);
INSERT INTO `geocoord` VALUES (62, 0, 广东, 从化, 23.33, 113.33);
INSERT INTO `geocoord` VALUES (63, 0, 广东, 东莞, 23.02, 113.45);
INSERT INTO `geocoord` VALUES (64, 0, 广东, 恩平, 22.12, 112.19);
INSERT INTO `geocoord` VALUES (65, 0, 广东, 佛山, 23.02, 113.06);
INSERT INTO `geocoord` VALUES (66, 0, 广东, 高明, 22.53, 112.50);
INSERT INTO `geocoord` VALUES (67, 0, 广东, 高要, 23.02, 112.26);
INSERT INTO `geocoord` VALUES (68, 0, 广东, 高州, 21.54, 110.50);
INSERT INTO `geocoord` VALUES (69, 0, 广东, 鹤山, 22.46, 112.57);
INSERT INTO `geocoord` VALUES (70, 0, 广东, 河源, 23.43, 114.41);
INSERT INTO `geocoord` VALUES (71, 0, 广东, 花都, 23.23, 113.12);
INSERT INTO `geocoord` VALUES (72, 0, 广东, 化州, 21.39, 110.37);
INSERT INTO `geocoord` VALUES (73, 0, 广东, 惠阳, 22.48, 114.28);
INSERT INTO `geocoord` VALUES (74, 0, 广东, 惠州, 23.05, 114.22);
INSERT INTO `geocoord` VALUES (75, 0, 广东, 江门, 22.35, 113.04);
INSERT INTO `geocoord` VALUES (76, 0, 广东, 揭阳, 22.32, 116.21);
INSERT INTO `geocoord` VALUES (77, 0, 广东, 开平, 22.22, 112.40);
INSERT INTO `geocoord` VALUES (78, 0, 广东, 乐昌, 25.09, 113.21);
INSERT INTO `geocoord` VALUES (79, 0, 广东, 雷州, 20.54, 110.04);
INSERT INTO `geocoord` VALUES (80, 0, 广东, 廉江, 21.37, 110.17);
INSERT INTO `geocoord` VALUES (81, 0, 广东, 连州, 24.48, 112.23);
INSERT INTO `geocoord` VALUES (82, 0, 广东, 罗定, 22.46, 111.33);
INSERT INTO `geocoord` VALUES (83, 0, 广东, 茂名, 21.40, 110.53);
INSERT INTO `geocoord` VALUES (84, 0, 广东, 梅州, 24.19, 116.07);
INSERT INTO `geocoord` VALUES (85, 0, 广东, 南海, 23.01, 113.09);
INSERT INTO `geocoord` VALUES (86, 0, 广东, 番禺, 22.57, 113.22);
INSERT INTO `geocoord` VALUES (87, 0, 广东, 普宁, 23.18, 116.10);
INSERT INTO `geocoord` VALUES (88, 0, 广东, 清远, 23.42, 113.01);
INSERT INTO `geocoord` VALUES (89, 0, 广东, 三水, 23.10, 112.52);
INSERT INTO `geocoord` VALUES (90, 0, 广东, 汕头, 23.22, 116.41);
INSERT INTO `geocoord` VALUES (91, 0, 广东, 汕尾, 22.47, 115.21);
INSERT INTO `geocoord` VALUES (92, 0, 广东, 韶关, 24.48, 113.37);
INSERT INTO `geocoord` VALUES (93, 0, 广东, 深圳, 22.33, 114.07);
INSERT INTO `geocoord` VALUES (94, 0, 广东, 顺德, 22.50, 113.15);
INSERT INTO `geocoord` VALUES (95, 0, 广东, 四会, 23.21, 112.41);
INSERT INTO `geocoord` VALUES (96, 0, 广东, 台山, 22.15, 112.48);
INSERT INTO `geocoord` VALUES (97, 0, 广东, 吴川, 21.26, 110.47);
INSERT INTO `geocoord` VALUES (98, 0, 广东, 新会, 22.32, 113.01);
INSERT INTO `geocoord` VALUES (99, 0, 广东, 兴宁, 24.09, 115.43);
INSERT INTO `geocoord` VALUES (100, 0, 广东, 阳春, 22.10, 111.48);
INSERT INTO `geocoord` VALUES (101, 0, 广东, 阳江, 21.50, 111.58);
INSERT INTO `geocoord` VALUES (102, 0, 广东, 英德, 24.10, 113.22);
INSERT INTO `geocoord` VALUES (103, 0, 广东, 云浮, 22.57, 112.02);
INSERT INTO `geocoord` VALUES (104, 0, 广东, 增城, 23.18, 113.49);
INSERT INTO `geocoord` VALUES (105, 0, 广东, 湛江, 21.11, 110.24);
INSERT INTO `geocoord` VALUES (106, 0, 广东, 肇庆, 23.03, 112.27);
INSERT INTO `geocoord` VALUES (107, 0, 广东, 中山, 22.31, 113.22);
INSERT INTO `geocoord` VALUES (108, 0, 广东, 珠海, 22.17, 113.34);
INSERT INTO `geocoord` VALUES (109, 0, 广西, 南宁, 22.48, 108.19);
INSERT INTO `geocoord` VALUES (110, 0, 广西, 北海, 21.28, 109.07);
INSERT INTO `geocoord` VALUES (111, 0, 广西, 北流, 22.42, 110.21);
INSERT INTO `geocoord` VALUES (112, 0, 广西, 百色, 23.54, 106.36);
INSERT INTO `geocoord` VALUES (113, 0, 广西, 防城港, 21.37, 108.20);
INSERT INTO `geocoord` VALUES (114, 0, 广西, 贵港, 23.06, 109.36);
INSERT INTO `geocoord` VALUES (115, 0, 广西, 桂林, 25.17, 110.17);
INSERT INTO `geocoord` VALUES (116, 0, 广西, 桂平, 23.22, 110.04);
INSERT INTO `geocoord` VALUES (117, 0, 广西, 河池, 24.42, 108.03);
INSERT INTO `geocoord` VALUES (118, 0, 广西, 合山, 23.47, 108.52);
INSERT INTO `geocoord` VALUES (119, 0, 广西, 柳州, 23.19, 109.24);
INSERT INTO `geocoord` VALUES (120, 0, 广西, 赁祥, 22.07, 106.44);
INSERT INTO `geocoord` VALUES (121, 0, 广西, 钦州, 21.57, 108.37);
INSERT INTO `geocoord` VALUES (122, 0, 广西, 梧州, 23.29, 111.20);
INSERT INTO `geocoord` VALUES (123, 0, 广西, 玉林, 22.38, 110.09);
INSERT INTO `geocoord` VALUES (124, 0, 广西, 宜州, 24.28, 108.40);
INSERT INTO `geocoord` VALUES (125, 0, 贵州, 贵阳, 26.35, 106.42);
INSERT INTO `geocoord` VALUES (126, 0, 贵州, 安顺, 26.14, 105.55);
INSERT INTO `geocoord` VALUES (127, 0, 贵州, 毕节, 27.18, 105.18);
INSERT INTO `geocoord` VALUES (128, 0, 贵州, 赤水, 28.34, 105.42);
INSERT INTO `geocoord` VALUES (129, 0, 贵州, 都匀, 26.15, 107.31);
INSERT INTO `geocoord` VALUES (130, 0, 贵州, 凯里, 26.35, 107.58);
INSERT INTO `geocoord` VALUES (131, 0, 贵州, 六盘水, 26.35, 104.50);
INSERT INTO `geocoord` VALUES (132, 0, 贵州, 清镇, 26.33, 106.27);
INSERT INTO `geocoord` VALUES (133, 0, 贵州, 铜仁, 27.43, 109.12);
INSERT INTO `geocoord` VALUES (134, 0, 贵州, 兴义, 25.05, 104.53);
INSERT INTO `geocoord` VALUES (135, 0, 贵州, 遵义, 27.42, 106.55);
INSERT INTO `geocoord` VALUES (136, 0, 海南, 海口, 20.02, 110.20);
INSERT INTO `geocoord` VALUES (137, 0, 海南, 儋州, 19.31, 109.34);
INSERT INTO `geocoord` VALUES (138, 0, 海南, 琼海, 19.14, 110.28);
INSERT INTO `geocoord` VALUES (139, 0, 海南, 琼山, 19.59, 110.21);
INSERT INTO `geocoord` VALUES (140, 0, 海南, 三亚, 18.14, 109.31);
INSERT INTO `geocoord` VALUES (141, 0, 海南, 通什, 18.46, 109.31);
INSERT INTO `geocoord` VALUES (142, 0, 河北, 石家庄, 38.02, 114.30);
INSERT INTO `geocoord` VALUES (143, 0, 河北, 安国, 38.24, 115.20);
INSERT INTO `geocoord` VALUES (144, 0, 河北, 保定, 38.51, 115.30);
INSERT INTO `geocoord` VALUES (145, 0, 河北, 霸州, 39.06, 116.24);
INSERT INTO `geocoord` VALUES (146, 0, 河北, 泊头, 38.04, 116.34);
INSERT INTO `geocoord` VALUES (147, 0, 河北, 沧州, 38.18, 116.52);
INSERT INTO `geocoord` VALUES (148, 0, 河北, 承德, 40.59, 117.57);
INSERT INTO `geocoord` VALUES (149, 0, 河北, 定州, 38.30, 115.00);
INSERT INTO `geocoord` VALUES (150, 0, 河北, 丰南, 39.34, 118.06);
INSERT INTO `geocoord` VALUES (151, 0, 河北, 高碑店, 39.20, 115.51);
INSERT INTO `geocoord` VALUES (152, 0, 河北, 蒿城, 38.02, 114.50);
INSERT INTO `geocoord` VALUES (153, 0, 河北, 邯郸, 36.36, 114.28);
INSERT INTO `geocoord` VALUES (154, 0, 河北, 河间, 38.26, 116.05);
INSERT INTO `geocoord` VALUES (155, 0, 河北, 衡水, 37.44, 115.42);
INSERT INTO `geocoord` VALUES (156, 0, 河北, 黄骅, 38.21, 117.21);
INSERT INTO `geocoord` VALUES (157, 0, 河北, 晋州, 38.02, 115.02);
INSERT INTO `geocoord` VALUES (158, 0, 河北, 冀州, 37.34, 115.33);
INSERT INTO `geocoord` VALUES (159, 0, 河北, 廊坊, 39.31, 116.42);
INSERT INTO `geocoord` VALUES (160, 0, 河北, 鹿泉, 38.04, 114.19);
INSERT INTO `geocoord` VALUES (161, 0, 河北, 南宫, 37.22, 115.23);
INSERT INTO `geocoord` VALUES (162, 0, 河北, 秦皇岛, 39.55, 119.35);
INSERT INTO `geocoord` VALUES (163, 0, 河北, 任丘, 38.42, 116.07);
INSERT INTO `geocoord` VALUES (164, 0, 河北, 三河, 39.58, 117.04);
INSERT INTO `geocoord` VALUES (165, 0, 河北, 沙河, 36.51, 114.30);
INSERT INTO `geocoord` VALUES (166, 0, 河北, 深州, 38.01, 115.32);
INSERT INTO `geocoord` VALUES (167, 0, 河北, 唐山, 39.36, 118.11);
INSERT INTO `geocoord` VALUES (168, 0, 河北, 武安, 36.42, 114.11);
INSERT INTO `geocoord` VALUES (169, 0, 河北, 邢台, 37.04, 114.30);
INSERT INTO `geocoord` VALUES (170, 0, 河北, 辛集, 37.54, 115.12);
INSERT INTO `geocoord` VALUES (171, 0, 河北, 新乐, 38.20, 114.41);
INSERT INTO `geocoord` VALUES (172, 0, 河北, 张家口, 40.48, 114.53);
INSERT INTO `geocoord` VALUES (173, 0, 河北, 涿州, 39.29, 115.59);
INSERT INTO `geocoord` VALUES (174, 0, 河北, 遵化, 40.11, 117.58);
INSERT INTO `geocoord` VALUES (175, 0, 河南, 郑州, 34.46, 113.40);
INSERT INTO `geocoord` VALUES (176, 0, 河南, 安阳, 36.06, 114.21);
INSERT INTO `geocoord` VALUES (177, 0, 河南, 长葛, 34.12, 113.47);
INSERT INTO `geocoord` VALUES (178, 0, 河南, 登封, 34.27, 113.02);
INSERT INTO `geocoord` VALUES (179, 0, 河南, 邓州, 32.42, 112.05);
INSERT INTO `geocoord` VALUES (180, 0, 河南, 巩义, 34.46, 112.58);
INSERT INTO `geocoord` VALUES (181, 0, 河南, 鹤壁, 35.54, 114.11);
INSERT INTO `geocoord` VALUES (182, 0, 河南, 辉县, 35.27, 113.47);
INSERT INTO `geocoord` VALUES (183, 0, 河南, 焦作, 35.14, 113.12);
INSERT INTO `geocoord` VALUES (184, 0, 河南, 济源, 35.04, 112.35);
INSERT INTO `geocoord` VALUES (185, 0, 河南, 开封, 34.47, 114.21);
INSERT INTO `geocoord` VALUES (186, 0, 河南, 灵宝, 34.31, 110.52);
INSERT INTO `geocoord` VALUES (187, 0, 河南, 林州, 36.03, 113.49);
INSERT INTO `geocoord` VALUES (188, 0, 河南, 漯河, 33.33, 114.02);
INSERT INTO `geocoord` VALUES (189, 0, 河南, 洛阳, 34.41, 112.27);
INSERT INTO `geocoord` VALUES (190, 0, 河南, 南阳, 33.00, 112.32);
INSERT INTO `geocoord` VALUES (191, 0, 河南, 平顶山, 33.44, 113.17);
INSERT INTO `geocoord` VALUES (192, 0, 河南, 濮阳, 35.44, 115.01);
INSERT INTO `geocoord` VALUES (193, 0, 河南, 沁阳, 35.05, 112.57);
INSERT INTO `geocoord` VALUES (194, 0, 河南, 汝州, 34.09, 112.50);
INSERT INTO `geocoord` VALUES (195, 0, 河南, 三门峡, 34.47, 111.12);
INSERT INTO `geocoord` VALUES (196, 0, 河南, 商丘, 34.26, 115.38);
INSERT INTO `geocoord` VALUES (197, 0, 河南, 卫辉, 35.24, 114.03);
INSERT INTO `geocoord` VALUES (198, 0, 河南, 舞钢, 33.17, 113.30);
INSERT INTO `geocoord` VALUES (199, 0, 河南, 项城, 33.26, 114.54);
INSERT INTO `geocoord` VALUES (200, 0, 河南, 荥阳, 34.46, 113.21);
INSERT INTO `geocoord` VALUES (201, 0, 河南, 新密, 34.31, 113.22);
INSERT INTO `geocoord` VALUES (202, 0, 河南, 新乡, 35.18, 113.52);
INSERT INTO `geocoord` VALUES (203, 0, 河南, 信阳, 32.07, 114.04);
INSERT INTO `geocoord` VALUES (204, 0, 河南, 新郑, 34.24, 113.43);
INSERT INTO `geocoord` VALUES (205, 0, 河南, 许昌, 34.01, 113.49);
INSERT INTO `geocoord` VALUES (206, 0, 河南, 偃师, 34.43, 112.47);
INSERT INTO `geocoord` VALUES (207, 0, 河南, 义马, 34.43, 111.55);
INSERT INTO `geocoord` VALUES (208, 0, 河南, 禹州, 34.09, 113.28);
INSERT INTO `geocoord` VALUES (209, 0, 河南, 周口, 33.37, 114.38);
INSERT INTO `geocoord` VALUES (210, 0, 河南, 驻马店, 32.58, 114.01);
INSERT INTO `geocoord` VALUES (211, 0, 黑龙江, 哈尔滨, 45.44, 126.36);
INSERT INTO `geocoord` VALUES (212, 0, 黑龙江, 阿城, 45.32, 126.58);
INSERT INTO `geocoord` VALUES (213, 0, 黑龙江, 安达, 46.24, 125.18);
INSERT INTO `geocoord` VALUES (214, 0, 黑龙江, 北安, 48.15, 126.31);
INSERT INTO `geocoord` VALUES (215, 0, 黑龙江, 大庆, 46.36, 125.01);
INSERT INTO `geocoord` VALUES (216, 0, 黑龙江, 富锦, 47.15, 132.02);
INSERT INTO `geocoord` VALUES (217, 0, 黑龙江, 海林, 44.35, 129.21);
INSERT INTO `geocoord` VALUES (218, 0, 黑龙江, 海伦, 47.28, 126.57);
INSERT INTO `geocoord` VALUES (219, 0, 黑龙江, 鹤岗, 47.20, 130.16);
INSERT INTO `geocoord` VALUES (220, 0, 黑龙江, 黑河, 50.14, 127.29);
INSERT INTO `geocoord` VALUES (221, 0, 黑龙江, 佳木斯, 46.47, 130.22);
INSERT INTO `geocoord` VALUES (222, 0, 黑龙江, 鸡西, 45.17, 130.57);
INSERT INTO `geocoord` VALUES (223, 0, 黑龙江, 密山, 45.32, 131.50);
INSERT INTO `geocoord` VALUES (224, 0, 黑龙江, 牡丹江, 44.35, 129.36);
INSERT INTO `geocoord` VALUES (225, 0, 黑龙江, 讷河, 48.29, 124.51);
INSERT INTO `geocoord` VALUES (226, 0, 黑龙江, 宁安, 44.21, 129.28);
INSERT INTO `geocoord` VALUES (227, 0, 黑龙江, 齐齐哈尔, 47.20, 123.57);
INSERT INTO `geocoord` VALUES (228, 0, 黑龙江, 七台河, 45.48, 130.49);
INSERT INTO `geocoord` VALUES (229, 0, 黑龙江, 双城, 45.22, 126.15);
INSERT INTO `geocoord` VALUES (230, 0, 黑龙江, 尚志, 45.14, 127.55);
INSERT INTO `geocoord` VALUES (231, 0, 黑龙江, 双鸭山, 46.38, 131.11);
INSERT INTO `geocoord` VALUES (232, 0, 黑龙江, 绥芬河, 44.25, 131.11);
INSERT INTO `geocoord` VALUES (233, 0, 黑龙江, 绥化, 46.38, 126.59);
INSERT INTO `geocoord` VALUES (234, 0, 黑龙江, 铁力, 46.59, 128.01);
INSERT INTO `geocoord` VALUES (235, 0, 黑龙江, 同江, 47.39, 132.30);
INSERT INTO `geocoord` VALUES (236, 0, 黑龙江, 五常, 44.55, 127.11);
INSERT INTO `geocoord` VALUES (237, 0, 黑龙江, 五大连池, 48.38, 126.07);
INSERT INTO `geocoord` VALUES (238, 0, 黑龙江, 伊春, 47.42, 128.56);
INSERT INTO `geocoord` VALUES (239, 0, 黑龙江, 肇东, 46.04, 125.58);
INSERT INTO `geocoord` VALUES (240, 0, 湖北, 武汉, 30.35, 114.17);
INSERT INTO `geocoord` VALUES (241, 0, 湖北, 安陆, 31.15, 113.41);
INSERT INTO `geocoord` VALUES (242, 0, 湖北, 当阳, 30.50, 111.47);
INSERT INTO `geocoord` VALUES (243, 0, 湖北, 丹江口, 32.33, 108.30);
INSERT INTO `geocoord` VALUES (244, 0, 湖北, 大冶, 30.06, 114.58);
INSERT INTO `geocoord` VALUES (245, 0, 湖北, 恩施, 30.16, 109.29);
INSERT INTO `geocoord` VALUES (246, 0, 湖北, 鄂州, 30.23, 114.52);
INSERT INTO `geocoord` VALUES (247, 0, 湖北, 广水, 31.37, 113.48);
INSERT INTO `geocoord` VALUES (248, 0, 湖北, 洪湖, 29.48, 113.27);
INSERT INTO `geocoord` VALUES (249, 0, 湖北, 黄石, 30.12, 115.06);
INSERT INTO `geocoord` VALUES (250, 0, 湖北, 黄州, 30.27, 114.52);
INSERT INTO `geocoord` VALUES (251, 0, 湖北, 荆门, 31.02, 112.12);
INSERT INTO `geocoord` VALUES (252, 0, 湖北, 荆沙, 30.18, 112.16);
INSERT INTO `geocoord` VALUES (253, 0, 湖北, 老河口, 32.23, 111.40);
INSERT INTO `geocoord` VALUES (254, 0, 湖北, 利川, 30.18, 108.56);
INSERT INTO `geocoord` VALUES (255, 0, 湖北, 麻城, 31.10, 115.01);
INSERT INTO `geocoord` VALUES (256, 0, 湖北, 浦圻, 29.42, 113.51);
INSERT INTO `geocoord` VALUES (257, 0, 湖北, 潜江, 30.26, 112.53);
INSERT INTO `geocoord` VALUES (258, 0, 湖北, 石首, 29.43, 112.24);
INSERT INTO `geocoord` VALUES (259, 0, 湖北, 十堰, 32.40, 110.47);
INSERT INTO `geocoord` VALUES (260, 0, 湖北, 随州, 31.42, 113.22);
INSERT INTO `geocoord` VALUES (261, 0, 湖北, 天门, 60.39, 113.10);
INSERT INTO `geocoord` VALUES (262, 0, 湖北, 武穴, 29.51, 115.33);
INSERT INTO `geocoord` VALUES (263, 0, 湖北, 襄樊, 32.02, 112.08);
INSERT INTO `geocoord` VALUES (264, 0, 湖北, 咸宁, 29.53, 114.17);
INSERT INTO `geocoord` VALUES (265, 0, 湖北, 仙桃, 30.22, 113.27);
INSERT INTO `geocoord` VALUES (266, 0, 湖北, 孝感, 30.56, 113.54);
INSERT INTO `geocoord` VALUES (267, 0, 湖北, 宜昌, 30.42, 111.17);
INSERT INTO `geocoord` VALUES (268, 0, 湖北, 宜城, 31.42, 112.15);
INSERT INTO `geocoord` VALUES (269, 0, 湖北, 应城, 30.57, 113.33);
INSERT INTO `geocoord` VALUES (270, 0, 湖北, 枣阳, 32.07, 112.44);
INSERT INTO `geocoord` VALUES (271, 0, 湖北, 枝城, 30.23, 111.27);
INSERT INTO `geocoord` VALUES (272, 0, 湖北, 钟祥, 31.10, 112.34);
INSERT INTO `geocoord` VALUES (273, 0, 湖南, 长沙, 28.12, 112.59);
INSERT INTO `geocoord` VALUES (274, 0, 湖南, 常德, 29.02, 111.51);
INSERT INTO `geocoord` VALUES (275, 0, 湖南, 郴州, 25.46, 113.02);
INSERT INTO `geocoord` VALUES (276, 0, 湖南, 衡阳, 26.53, 112.37);
INSERT INTO `geocoord` VALUES (277, 0, 湖南, 洪江, 27.07, 109.59);
INSERT INTO `geocoord` VALUES (278, 0, 湖南, 怀化, 27.33, 109.58);
INSERT INTO `geocoord` VALUES (279, 0, 湖南, 津市, 29.38, 111.52);
INSERT INTO `geocoord` VALUES (280, 0, 湖南, 吉首, 28.18, 109.43);
INSERT INTO `geocoord` VALUES (281, 0, 湖南, 耒阳, 26.24, 112.51);
INSERT INTO `geocoord` VALUES (282, 0, 湖南, 冷水江, 27.42, 111.26);
INSERT INTO `geocoord` VALUES (283, 0, 湖南, 冷水滩, 26.26, 111.35);
INSERT INTO `geocoord` VALUES (284, 0, 湖南, 涟源, 27.41, 111.41);
INSERT INTO `geocoord` VALUES (285, 0, 湖南, 醴陵, 27.40, 113.30);
INSERT INTO `geocoord` VALUES (286, 0, 湖南, 临湘, 29.29, 113.27);
INSERT INTO `geocoord` VALUES (287, 0, 湖南, 浏阳, 28.09, 113.37);
INSERT INTO `geocoord` VALUES (288, 0, 湖南, 娄底, 27.44, 111.59);
INSERT INTO `geocoord` VALUES (289, 0, 湖南, 汨罗, 28.49, 113.03);
INSERT INTO `geocoord` VALUES (290, 0, 湖南, 韶山, 27.54, 112.29);
INSERT INTO `geocoord` VALUES (291, 0, 湖南, 邵阳, 27.14, 111.28);
INSERT INTO `geocoord` VALUES (292, 0, 湖南, 武冈, 26.43, 110.37);
INSERT INTO `geocoord` VALUES (293, 0, 湖南, 湘潭, 27.52, 112.53);
INSERT INTO `geocoord` VALUES (294, 0, 湖南, 湘乡, 27.44, 112.31);
INSERT INTO `geocoord` VALUES (295, 0, 湖南, 益阳, 28.36, 112.20);
INSERT INTO `geocoord` VALUES (296, 0, 湖南, 永州, 26.13, 111.37);
INSERT INTO `geocoord` VALUES (297, 0, 湖南, 沅江, 28.50, 112.22);
INSERT INTO `geocoord` VALUES (298, 0, 湖南, 岳阳, 29.22, 113.06);
INSERT INTO `geocoord` VALUES (299, 0, 湖南, 张家界, 29.08, 110.29);
INSERT INTO `geocoord` VALUES (300, 0, 湖南, 株洲, 27.51, 113.09);
INSERT INTO `geocoord` VALUES (301, 0, 湖南, 资兴, 25.58, 113.13);
INSERT INTO `geocoord` VALUES (302, 0, 吉林, 长春, 43.54, 125.19);
INSERT INTO `geocoord` VALUES (303, 0, 吉林, 白城, 45.38, 122.50);
INSERT INTO `geocoord` VALUES (304, 0, 吉林, 白山, 41.56, 126.26);
INSERT INTO `geocoord` VALUES (305, 0, 吉林, 大安, 45.30, 124.18);
INSERT INTO `geocoord` VALUES (306, 0, 吉林, 德惠, 44.32, 125.42);
INSERT INTO `geocoord` VALUES (307, 0, 吉林, 敦化, 43.22, 128.13);
INSERT INTO `geocoord` VALUES (308, 0, 吉林, 公主岭, 43.31, 124.49);
INSERT INTO `geocoord` VALUES (309, 0, 吉林, 和龙, 42.32, 129.00);
INSERT INTO `geocoord` VALUES (310, 0, 吉林, 桦甸, 42.58, 126.44);
INSERT INTO `geocoord` VALUES (311, 0, 吉林, 珲春, 42.52, 130.22);
INSERT INTO `geocoord` VALUES (312, 0, 吉林, 集安, 41.08, 126.11);
INSERT INTO `geocoord` VALUES (313, 0, 吉林, 蛟河, 43.42, 127.21);
INSERT INTO `geocoord` VALUES (314, 0, 吉林, 吉林, 43.52, 126.33);
INSERT INTO `geocoord` VALUES (315, 0, 吉林, 九台, 44.09, 125.51);
INSERT INTO `geocoord` VALUES (316, 0, 吉林, 辽源, 42.54, 125.09);
INSERT INTO `geocoord` VALUES (317, 0, 吉林, 临江, 41.49, 126.53);
INSERT INTO `geocoord` VALUES (318, 0, 吉林, 龙井, 42.46, 129.26);
INSERT INTO `geocoord` VALUES (319, 0, 吉林, 梅河口, 42.32, 125.40);
INSERT INTO `geocoord` VALUES (320, 0, 吉林, 舒兰, 44.24, 126.57);
INSERT INTO `geocoord` VALUES (321, 0, 吉林, 四平, 43.10, 124.22);
INSERT INTO `geocoord` VALUES (322, 0, 吉林, 松原, 45.11, 124.49);
INSERT INTO `geocoord` VALUES (323, 0, 吉林, 洮南, 45.20, 122.47);
INSERT INTO `geocoord` VALUES (324, 0, 吉林, 通化, 41.43, 125.56);
INSERT INTO `geocoord` VALUES (325, 0, 吉林, 图们, 42.57, 129.51);
INSERT INTO `geocoord` VALUES (326, 0, 吉林, 延吉, 42.54, 129.30);
INSERT INTO `geocoord` VALUES (327, 0, 吉林, 愉树, 44.49, 126.32);
INSERT INTO `geocoord` VALUES (328, 0, 江苏, 南京, 32.03, 118.46);
INSERT INTO `geocoord` VALUES (329, 0, 江苏, 常熟, 31.39, 120.43);
INSERT INTO `geocoord` VALUES (330, 0, 江苏, 常州, 31.47, 119.58);
INSERT INTO `geocoord` VALUES (331, 0, 江苏, 丹阳, 32.00, 119.32);
INSERT INTO `geocoord` VALUES (332, 0, 江苏, 东台, 32.51, 120.19);
INSERT INTO `geocoord` VALUES (333, 0, 江苏, 高邮, 32.47, 119.27);
INSERT INTO `geocoord` VALUES (334, 0, 江苏, 海门, 31.53, 121.09);
INSERT INTO `geocoord` VALUES (335, 0, 江苏, 淮安, 33.30, 119.09);
INSERT INTO `geocoord` VALUES (336, 0, 江苏, 淮阴, 33.36, 119.02);
INSERT INTO `geocoord` VALUES (337, 0, 江苏, 江都, 32.26, 119.32);
INSERT INTO `geocoord` VALUES (338, 0, 江苏, 姜堰, 32.34, 120.08);
INSERT INTO `geocoord` VALUES (339, 0, 江苏, 江阴, 31.54, 120.17);
INSERT INTO `geocoord` VALUES (340, 0, 江苏, 靖江, 32.02, 120.17);
INSERT INTO `geocoord` VALUES (341, 0, 江苏, 金坛, 31.46, 119.33);
INSERT INTO `geocoord` VALUES (342, 0, 江苏, 昆山, 31.23, 120.57);
INSERT INTO `geocoord` VALUES (343, 0, 江苏, 连去港, 34.36, 119.10);
INSERT INTO `geocoord` VALUES (344, 0, 江苏, 溧阳, 31.26, 119.29);
INSERT INTO `geocoord` VALUES (345, 0, 江苏, 南通, 32.01, 120.51);
INSERT INTO `geocoord` VALUES (346, 0, 江苏, 邳州, 34.19, 117.59);
INSERT INTO `geocoord` VALUES (347, 0, 江苏, 启乐, 31.48, 121.39);
INSERT INTO `geocoord` VALUES (348, 0, 江苏, 如皋, 32.23, 120.33);
INSERT INTO `geocoord` VALUES (349, 0, 江苏, 宿迁, 33.58, 118.18);
INSERT INTO `geocoord` VALUES (350, 0, 江苏, 苏州, 31.19, 120.37);
INSERT INTO `geocoord` VALUES (351, 0, 江苏, 太仓, 31.27, 121.06);
INSERT INTO `geocoord` VALUES (352, 0, 江苏, 泰兴, 32.10, 120.01);
INSERT INTO `geocoord` VALUES (353, 0, 江苏, 泰州, 32.30, 119.54);
INSERT INTO `geocoord` VALUES (354, 0, 江苏, 通州, 32.05, 121.03);
INSERT INTO `geocoord` VALUES (355, 0, 江苏, 吴江, 31.10, 120.39);
INSERT INTO `geocoord` VALUES (356, 0, 江苏, 无锡, 31.34, 120.18);
INSERT INTO `geocoord` VALUES (357, 0, 江苏, 兴化, 32.56, 119.50);
INSERT INTO `geocoord` VALUES (358, 0, 江苏, 新沂, 34.22, 118.20);
INSERT INTO `geocoord` VALUES (359, 0, 江苏, 徐州, 34.15, 117.11);
INSERT INTO `geocoord` VALUES (360, 0, 江苏, 盐在, 33.22, 120.08);
INSERT INTO `geocoord` VALUES (361, 0, 江苏, 扬中, 32.14, 119.49);
INSERT INTO `geocoord` VALUES (362, 0, 江苏, 扬州, 32.23, 119.26);
INSERT INTO `geocoord` VALUES (363, 0, 江苏, 宜兴, 31.21, 119.49);
INSERT INTO `geocoord` VALUES (364, 0, 江苏, 仪征, 32.16, 119.10);
INSERT INTO `geocoord` VALUES (365, 0, 江苏, 张家港, 31.52, 120.32);
INSERT INTO `geocoord` VALUES (366, 0, 江苏, 镇江, 32.11, 119.27);
INSERT INTO `geocoord` VALUES (367, 0, 江西, 南昌, 28.40, 115.55);
INSERT INTO `geocoord` VALUES (368, 0, 江西, 德兴, 28.57, 117.35);
INSERT INTO `geocoord` VALUES (369, 0, 江西, 丰城, 28.12, 115.48);
INSERT INTO `geocoord` VALUES (370, 0, 江西, 赣州, 28.52, 114.56);
INSERT INTO `geocoord` VALUES (371, 0, 江西, 高安, 28.25, 115.22);
INSERT INTO `geocoord` VALUES (372, 0, 江西, 吉安, 27.07, 114.58);
INSERT INTO `geocoord` VALUES (373, 0, 江西, 景德镇, 29.17, 117.13);
INSERT INTO `geocoord` VALUES (374, 0, 江西, 井冈山, 26.34, 114.10);
INSERT INTO `geocoord` VALUES (375, 0, 江西, 九江, 29.43, 115.58);
INSERT INTO `geocoord` VALUES (376, 0, 江西, 乐平, 28.58, 117.08);
INSERT INTO `geocoord` VALUES (377, 0, 江西, 临川, 27.59, 116.21);
INSERT INTO `geocoord` VALUES (378, 0, 江西, 萍乡, 27.37, 113.50);
INSERT INTO `geocoord` VALUES (379, 0, 江西, 瑞昌, 29.40, 115.38);
INSERT INTO `geocoord` VALUES (380, 0, 江西, 瑞金, 25.53, 116.01);
INSERT INTO `geocoord` VALUES (381, 0, 江西, 上饶, 25.27, 117.58);
INSERT INTO `geocoord` VALUES (382, 0, 江西, 新余, 27.48, 114.56);
INSERT INTO `geocoord` VALUES (383, 0, 江西, 宜春, 27.47, 114.23);
INSERT INTO `geocoord` VALUES (384, 0, 江西, 鹰潭, 28.14, 117.03);
INSERT INTO `geocoord` VALUES (385, 0, 江西, 樟树, 28.03, 115.32);
INSERT INTO `geocoord` VALUES (386, 0, 辽宁, 沈阳, 41.48, 123.25);
INSERT INTO `geocoord` VALUES (387, 0, 辽宁, 鞍山, 41.07, 123.00);
INSERT INTO `geocoord` VALUES (388, 0, 辽宁, 北票, 41.48, 120.47);
INSERT INTO `geocoord` VALUES (389, 0, 辽宁, 本溪, 41.18, 123.46);
INSERT INTO `geocoord` VALUES (390, 0, 辽宁, 朝阳, 41.34, 120.27);
INSERT INTO `geocoord` VALUES (391, 0, 辽宁, 大连, 38.55, 121.36);
INSERT INTO `geocoord` VALUES (392, 0, 辽宁, 丹东, 40.08, 124.22);
INSERT INTO `geocoord` VALUES (393, 0, 辽宁, 大石桥, 40.37, 122.31);
INSERT INTO `geocoord` VALUES (394, 0, 辽宁, 东港, 39.53, 124.08);
INSERT INTO `geocoord` VALUES (395, 0, 辽宁, 凤城, 40.28, 124.02);
INSERT INTO `geocoord` VALUES (396, 0, 辽宁, 抚顺, 41.51, 123.54);
INSERT INTO `geocoord` VALUES (397, 0, 辽宁, 阜新, 42.01, 121.39);
INSERT INTO `geocoord` VALUES (398, 0, 辽宁, 盖州, 40.24, 122.21);
INSERT INTO `geocoord` VALUES (399, 0, 辽宁, 海城, 40.51, 122.43);
INSERT INTO `geocoord` VALUES (400, 0, 辽宁, 葫芦岛, 40.45, 120.51);
INSERT INTO `geocoord` VALUES (401, 0, 辽宁, 锦州, 41.07, 121.09);
INSERT INTO `geocoord` VALUES (402, 0, 辽宁, 开原, 42.32, 124.02);
INSERT INTO `geocoord` VALUES (403, 0, 辽宁, 辽阳, 41.16, 123.12);
INSERT INTO `geocoord` VALUES (404, 0, 辽宁, 凌海, 41.10, 121.21);
INSERT INTO `geocoord` VALUES (405, 0, 辽宁, 凌源, 41.14, 119.22);
INSERT INTO `geocoord` VALUES (406, 0, 辽宁, 盘锦, 41.07, 122.03);
INSERT INTO `geocoord` VALUES (407, 0, 辽宁, 普兰店, 39.23, 121.58);
INSERT INTO `geocoord` VALUES (408, 0, 辽宁, 铁法, 42.28, 123.32);
INSERT INTO `geocoord` VALUES (409, 0, 辽宁, 铁岭, 42.18, 123.51);
INSERT INTO `geocoord` VALUES (410, 0, 辽宁, 瓦房店, 39.37, 122.00);
INSERT INTO `geocoord` VALUES (411, 0, 辽宁, 兴城, 40.37, 120.41);
INSERT INTO `geocoord` VALUES (412, 0, 辽宁, 新民, 41.59, 122.49);
INSERT INTO `geocoord` VALUES (413, 0, 辽宁, 营口, 40.39, 122.13);
INSERT INTO `geocoord` VALUES (414, 0, 辽宁, 庄河, 39.41, 122.58);
INSERT INTO `geocoord` VALUES (415, 0, 内蒙古, 呼和浩特, 40.48, 111.41);
INSERT INTO `geocoord` VALUES (416, 0, 内蒙古, 包头, 40.39, 109.49);
INSERT INTO `geocoord` VALUES (417, 0, 内蒙古, 赤峰, 42.17, 118.58);
INSERT INTO `geocoord` VALUES (418, 0, 内蒙古, 东胜, 39.48, 109.59);
INSERT INTO `geocoord` VALUES (419, 0, 内蒙古, 二连浩特, 43.38, 111.58);
INSERT INTO `geocoord` VALUES (420, 0, 内蒙古, 额尔古纳, 50.13, 120.11);
INSERT INTO `geocoord` VALUES (421, 0, 内蒙古, 丰镇, 40.27, 113.09);
INSERT INTO `geocoord` VALUES (422, 0, 内蒙古, 根河, 50.48, 121.29);
INSERT INTO `geocoord` VALUES (423, 0, 内蒙古, 海拉尔, 49.12, 119.39);
INSERT INTO `geocoord` VALUES (424, 0, 内蒙古, 霍林郭勒, 45.32, 119.38);
INSERT INTO `geocoord` VALUES (425, 0, 内蒙古, 集宁, 41.02, 113.06);
INSERT INTO `geocoord` VALUES (426, 0, 内蒙古, 临河, 40.46, 107.22);
INSERT INTO `geocoord` VALUES (427, 0, 内蒙古, 满洲里, 49.35, 117.23);
INSERT INTO `geocoord` VALUES (428, 0, 内蒙古, 通辽, 43.37, 122.16);
INSERT INTO `geocoord` VALUES (429, 0, 内蒙古, 乌兰浩特, 46.03, 122.03);
INSERT INTO `geocoord` VALUES (430, 0, 内蒙古, 乌海, 39.40, 106.48);
INSERT INTO `geocoord` VALUES (431, 0, 内蒙古, 锡林浩特, 43.57, 116.03);
INSERT INTO `geocoord` VALUES (432, 0, 内蒙古, 牙克石, 49.17, 120.40);
INSERT INTO `geocoord` VALUES (433, 0, 内蒙古, 扎兰屯, 48.00, 122.47);
INSERT INTO `geocoord` VALUES (434, 0, 宁夏, 银川, 38.27, 106.16);
INSERT INTO `geocoord` VALUES (435, 0, 宁夏, 青铜峡, 37.56, 105.59);
INSERT INTO `geocoord` VALUES (436, 0, 宁夏, 石嘴山, 39.02, 106.22);
INSERT INTO `geocoord` VALUES (437, 0, 宁夏, 吴忠, 37.59, 106.11);
INSERT INTO `geocoord` VALUES (438, 0, 青海, 西宁, 36.38, 101.48);
INSERT INTO `geocoord` VALUES (439, 0, 青海, 德令哈, 37.22, 97.23);
INSERT INTO `geocoord` VALUES (440, 0, 青海, 格尔木, 36.26, 94.55);
INSERT INTO `geocoord` VALUES (441, 0, 山东, 济南, 36.40, 117.00);
INSERT INTO `geocoord` VALUES (442, 0, 山东, 安丘, 36.25, 119.12);
INSERT INTO `geocoord` VALUES (443, 0, 山东, 滨州, 37.22, 118.02);
INSERT INTO `geocoord` VALUES (444, 0, 山东, 昌邑, 39.52, 119.24);
INSERT INTO `geocoord` VALUES (445, 0, 山东, 德州, 37.26, 116.17);
INSERT INTO `geocoord` VALUES (446, 0, 山东, 东营, 37.27, 118.30);
INSERT INTO `geocoord` VALUES (447, 0, 山东, 肥城, 36.14, 116.46);
INSERT INTO `geocoord` VALUES (448, 0, 山东, 高密, 36.22, 119.44);
INSERT INTO `geocoord` VALUES (449, 0, 山东, 菏泽, 35.14, 115.26);
INSERT INTO `geocoord` VALUES (450, 0, 山东, 胶南, 35.53, 119.58);
INSERT INTO `geocoord` VALUES (451, 0, 山东, 胶州, 36.17, 120.00);
INSERT INTO `geocoord` VALUES (452, 0, 山东, 即墨, 36.22, 120.28);
INSERT INTO `geocoord` VALUES (453, 0, 山东, 济宁, 35.23, 116.33);
INSERT INTO `geocoord` VALUES (454, 0, 山东, 莱芜, 36.12, 117.40);
INSERT INTO `geocoord` VALUES (455, 0, 山东, 莱西, 36.52, 120.31);
INSERT INTO `geocoord` VALUES (456, 0, 山东, 莱阳, 36.58, 120.42);
INSERT INTO `geocoord` VALUES (457, 0, 山东, 莱州, 37.10, 119.57);
INSERT INTO `geocoord` VALUES (458, 0, 山东, 乐陵, 37.44, 117.12);
INSERT INTO `geocoord` VALUES (459, 0, 山东, 聊城, 36.26, 115.57);
INSERT INTO `geocoord` VALUES (460, 0, 山东, 临清, 36.51, 115.42);
INSERT INTO `geocoord` VALUES (461, 0, 山东, 临沂, 35.03, 118.20);
INSERT INTO `geocoord` VALUES (462, 0, 山东, 龙口, 37.39, 120.21);
INSERT INTO `geocoord` VALUES (463, 0, 山东, 蓬莱, 37.48, 120.45);
INSERT INTO `geocoord` VALUES (464, 0, 山东, 平度, 36.47, 119.58);
INSERT INTO `geocoord` VALUES (465, 0, 山东, 青岛, 36.03, 120.18);
INSERT INTO `geocoord` VALUES (466, 0, 山东, 青州, 36.42, 118.28);
INSERT INTO `geocoord` VALUES (467, 0, 山东, 曲阜, 35.36, 116.58);
INSERT INTO `geocoord` VALUES (468, 0, 山东, 日照, 35.23, 119.32);
INSERT INTO `geocoord` VALUES (469, 0, 山东, 荣成, 37.10, 122.25);
INSERT INTO `geocoord` VALUES (470, 0, 山东, 乳山, 36.54, 121.31);
INSERT INTO `geocoord` VALUES (471, 0, 山东, 寿光, 36.53, 118.44);
INSERT INTO `geocoord` VALUES (472, 0, 山东, 泰安, 36.11, 117.08);
INSERT INTO `geocoord` VALUES (473, 0, 山东, 滕州, 35.06, 117.09);
INSERT INTO `geocoord` VALUES (474, 0, 山东, 潍坊, 36.43, 119.06);
INSERT INTO `geocoord` VALUES (475, 0, 山东, 威海, 37.31, 122.07);
INSERT INTO `geocoord` VALUES (476, 0, 山东, 文登, 37.12, 122.03);
INSERT INTO `geocoord` VALUES (477, 0, 山东, 新泰, 35.54, 117.45);
INSERT INTO `geocoord` VALUES (478, 0, 山东, 烟台, 37.32, 121.24);
INSERT INTO `geocoord` VALUES (479, 0, 山东, 兖州, 35.32, 116.49);
INSERT INTO `geocoord` VALUES (480, 0, 山东, 禹城, 36.56, 116.39);
INSERT INTO `geocoord` VALUES (481, 0, 山东, 枣庄, 34.52, 117.33);
INSERT INTO `geocoord` VALUES (482, 0, 山东, 章丘, 36.43, 117.32);
INSERT INTO `geocoord` VALUES (483, 0, 山东, 招远, 37.21, 120.23);
INSERT INTO `geocoord` VALUES (484, 0, 山东, 诸城, 35.59, 119.24);
INSERT INTO `geocoord` VALUES (485, 0, 山东, 淄博, 36.48, 118.03);
INSERT INTO `geocoord` VALUES (486, 0, 山东, 邹城, 35.24, 116.58);
INSERT INTO `geocoord` VALUES (487, 0, 山西, 太原, 37.54, 112.33);
INSERT INTO `geocoord` VALUES (488, 0, 山西, 长治, 36.11, 113.06);
INSERT INTO `geocoord` VALUES (489, 0, 山西, 大同, 40.06, 113.17);
INSERT INTO `geocoord` VALUES (490, 0, 山西, 高平, 35.48, 112.55);
INSERT INTO `geocoord` VALUES (491, 0, 山西, 古交, 37.54, 112.09);
INSERT INTO `geocoord` VALUES (492, 0, 山西, 河津, 35.35, 110.41);
INSERT INTO `geocoord` VALUES (493, 0, 山西, 侯马, 35.37, 111.21);
INSERT INTO `geocoord` VALUES (494, 0, 山西, 霍州, 36.34, 111.42);
INSERT INTO `geocoord` VALUES (495, 0, 山西, 介休, 37.02, 111.55);
INSERT INTO `geocoord` VALUES (496, 0, 山西, 晋城, 35.30, 112.51);
INSERT INTO `geocoord` VALUES (497, 0, 山西, 临汾, 36.05, 111.31);
INSERT INTO `geocoord` VALUES (498, 0, 山西, 潞城, 36.21, 113.14);
INSERT INTO `geocoord` VALUES (499, 0, 山西, 朔州, 39.19, 112.26);
INSERT INTO `geocoord` VALUES (500, 0, 山西, 孝义, 37.08, 111.48);
INSERT INTO `geocoord` VALUES (501, 0, 山西, 忻州, 38.24, 112.43);
INSERT INTO `geocoord` VALUES (502, 0, 山西, 阳泉, 37.51, 113.34);
INSERT INTO `geocoord` VALUES (503, 0, 山西, 永济, 34.52, 110.27);
INSERT INTO `geocoord` VALUES (504, 0, 山西, 原平, 38.43, 112.42);
INSERT INTO `geocoord` VALUES (505, 0, 山西, 榆次, 37.41, 112.43);
INSERT INTO `geocoord` VALUES (506, 0, 山西, 运城, 35.02, 110.59);
INSERT INTO `geocoord` VALUES (507, 0, 陕西, 西安, 34.17, 108.57);
INSERT INTO `geocoord` VALUES (508, 0, 陕西, 安康, 32.41, 109.01);
INSERT INTO `geocoord` VALUES (509, 0, 陕西, 宝鸡, 34.22, 107.09);
INSERT INTO `geocoord` VALUES (510, 0, 陕西, 韩城, 35.28, 110.27);
INSERT INTO `geocoord` VALUES (511, 0, 陕西, 汉中, 33.04, 107.01);
INSERT INTO `geocoord` VALUES (512, 0, 陕西, 华阴, 34.34, 110.05);
INSERT INTO `geocoord` VALUES (513, 0, 陕西, 商州, 33.52, 109.57);
INSERT INTO `geocoord` VALUES (514, 0, 陕西, 铜川, 35.06, 109.07);
INSERT INTO `geocoord` VALUES (515, 0, 陕西, 渭南, 34.30, 109.30);
INSERT INTO `geocoord` VALUES (516, 0, 陕西, 咸阳, 34.20, 108.43);
INSERT INTO `geocoord` VALUES (517, 0, 陕西, 兴平, 34.18, 108.29);
INSERT INTO `geocoord` VALUES (518, 0, 陕西, 延安, 36.35, 109.28);
INSERT INTO `geocoord` VALUES (519, 0, 陕西, 榆林, 38.18, 109.47);
INSERT INTO `geocoord` VALUES (520, 0, 上海, 上海, 31.14, 121.29);
INSERT INTO `geocoord` VALUES (521, 0, 四川, 成都, 30.40, 104.04);
INSERT INTO `geocoord` VALUES (522, 0, 四川, 巴中, 31.51, 106.43);
INSERT INTO `geocoord` VALUES (523, 0, 四川, 崇州, 30.39, 103.40);
INSERT INTO `geocoord` VALUES (524, 0, 四川, 达川, 31.14, 107.29);
INSERT INTO `geocoord` VALUES (525, 0, 四川, 德阳, 31.09, 104.22);
INSERT INTO `geocoord` VALUES (526, 0, 四川, 都江堰, 31.01, 103.37);
INSERT INTO `geocoord` VALUES (527, 0, 四川, 峨眉山, 29.36, 103.29);
INSERT INTO `geocoord` VALUES (528, 0, 四川, 涪陵, 29.42, 107.22);
INSERT INTO `geocoord` VALUES (529, 0, 四川, 广汉, 30.58, 104.15);
INSERT INTO `geocoord` VALUES (530, 0, 四川, 广元, 32.28, 105.51);
INSERT INTO `geocoord` VALUES (531, 0, 四川, 华蓥, 30.26, 106.44);
INSERT INTO `geocoord` VALUES (532, 0, 四川, 简阳, 30.24, 104.32);
INSERT INTO `geocoord` VALUES (533, 0, 四川, 江油, 31.48, 104.42);
INSERT INTO `geocoord` VALUES (534, 0, 四川, 阆中, 31.36, 105.58);
INSERT INTO `geocoord` VALUES (535, 0, 四川, 乐山, 29.36, 103.44);
INSERT INTO `geocoord` VALUES (536, 0, 四川, 泸州, 28.54, 105.24);
INSERT INTO `geocoord` VALUES (537, 0, 四川, 绵阳, 31.30, 104.42);
INSERT INTO `geocoord` VALUES (538, 0, 四川, 南充, 30.49, 106.04);
INSERT INTO `geocoord` VALUES (539, 0, 四川, 内江, 29.36, 105.02);
INSERT INTO `geocoord` VALUES (540, 0, 四川, 攀枝花, 26.34, 101.43);
INSERT INTO `geocoord` VALUES (541, 0, 四川, 彭州, 30.59, 103.57);
INSERT INTO `geocoord` VALUES (542, 0, 四川, 邛崃, 30.26, 103.28);
INSERT INTO `geocoord` VALUES (543, 0, 四川, 遂宁, 30.31, 105.33);
INSERT INTO `geocoord` VALUES (544, 0, 四川, 万县, 30.50, 108.21);
INSERT INTO `geocoord` VALUES (545, 0, 四川, 万源, 32.03, 108.03);
INSERT INTO `geocoord` VALUES (546, 0, 四川, 西昌, 27.54, 102.16);
INSERT INTO `geocoord` VALUES (547, 0, 四川, 雅安, 29.59, 102.59);
INSERT INTO `geocoord` VALUES (548, 0, 四川, 宜宾, 28.47, 104.34);
INSERT INTO `geocoord` VALUES (549, 0, 四川, 自贡, 29.23, 104.46);
INSERT INTO `geocoord` VALUES (550, 0, 四川, 资阳, 30.09, 104.38);
INSERT INTO `geocoord` VALUES (551, 0, 台湾, 台北, 25.03, 121.30);
INSERT INTO `geocoord` VALUES (552, 0, 天津, 天津, 39.02, 117.12);
INSERT INTO `geocoord` VALUES (553, 0, 西藏, 拉萨, 29.39, 91.08);
INSERT INTO `geocoord` VALUES (554, 0, 西藏, 日喀则, 29.16, 88.51);
INSERT INTO `geocoord` VALUES (555, 0, 香港, 香港, 21.23, 115.12);
INSERT INTO `geocoord` VALUES (556, 0, 新疆, 乌鲁木齐, 43.45, 87.36);
INSERT INTO `geocoord` VALUES (557, 0, 新疆, 阿克苏, 41.09, 80.19);
INSERT INTO `geocoord` VALUES (558, 0, 新疆, 阿勒泰, 47.50, 88.12);
INSERT INTO `geocoord` VALUES (559, 0, 新疆, 阿图什, 39.42, 76.08);
INSERT INTO `geocoord` VALUES (560, 0, 新疆, 博乐, 44.57, 82.08);
INSERT INTO `geocoord` VALUES (561, 0, 新疆, 昌吉, 44.02, 87.18);
INSERT INTO `geocoord` VALUES (562, 0, 新疆, 阜康, 44.09, 87.58);
INSERT INTO `geocoord` VALUES (563, 0, 新疆, 哈密, 42.50, 93.28);
INSERT INTO `geocoord` VALUES (564, 0, 新疆, 和田, 37.09, 79.55);
INSERT INTO `geocoord` VALUES (565, 0, 新疆, 克拉玛依, 45.36, 84.51);
INSERT INTO `geocoord` VALUES (566, 0, 新疆, 喀什, 39.30, 75.59);
INSERT INTO `geocoord` VALUES (567, 0, 新疆, 库尔勒, 41.46, 86.07);
INSERT INTO `geocoord` VALUES (568, 0, 新疆, 奎屯, 44.27, 84.56);
INSERT INTO `geocoord` VALUES (569, 0, 新疆, 石河子, 44.18, 86.00);
INSERT INTO `geocoord` VALUES (570, 0, 新疆, 塔城, 46.46, 82.59);
INSERT INTO `geocoord` VALUES (571, 0, 新疆, 吐鲁番, 42.54, 89.11);
INSERT INTO `geocoord` VALUES (572, 0, 新疆, 伊宁, 43.55, 81.20);
INSERT INTO `geocoord` VALUES (573, 0, 云南, 昆明, 25.04, 102.42);
INSERT INTO `geocoord` VALUES (574, 0, 云南, 保山, 25.08, 99.10);
INSERT INTO `geocoord` VALUES (575, 0, 云南, 楚雄, 25.01, 101.32);
INSERT INTO `geocoord` VALUES (576, 0, 云南, 大理, 25.34, 100.13);
INSERT INTO `geocoord` VALUES (577, 0, 云南, 东川, 26.06, 103.12);
INSERT INTO `geocoord` VALUES (578, 0, 云南, 个旧, 23.21, 103.09);
INSERT INTO `geocoord` VALUES (579, 0, 云南, 景洪, 22.01, 100.48);
INSERT INTO `geocoord` VALUES (580, 0, 云南, 开远, 23.43, 103.13);
INSERT INTO `geocoord` VALUES (581, 0, 云南, 曲靖, 25.30, 103.48);
INSERT INTO `geocoord` VALUES (582, 0, 云南, 瑞丽, 24.00, 97.50);
INSERT INTO `geocoord` VALUES (583, 0, 云南, 思茅, 22.48, 100.58);
INSERT INTO `geocoord` VALUES (584, 0, 云南, 畹町, 24.06, 98.04);
INSERT INTO `geocoord` VALUES (585, 0, 云南, 宣威, 26.13, 104.06);
INSERT INTO `geocoord` VALUES (586, 0, 云南, 玉溪, 24.22, 102.32);
INSERT INTO `geocoord` VALUES (587, 0, 云南, 昭通, 27.20, 103.42);
INSERT INTO `geocoord` VALUES (588, 0, 浙江, 杭州, 30.16, 120.10);
INSERT INTO `geocoord` VALUES (589, 0, 浙江, 慈溪, 30.11, 121.15);
INSERT INTO `geocoord` VALUES (590, 0, 浙江, 东阳, 29.16, 120.14);
INSERT INTO `geocoord` VALUES (591, 0, 浙江, 奉化, 29.39, 121.24);
INSERT INTO `geocoord` VALUES (592, 0, 浙江, 富阳, 30.03, 119.57);
INSERT INTO `geocoord` VALUES (593, 0, 浙江, 海宁, 30.32, 120.42);
INSERT INTO `geocoord` VALUES (594, 0, 浙江, 湖州, 30.52, 120.06);
INSERT INTO `geocoord` VALUES (595, 0, 浙江, 建德, 29.29, 119.16);
INSERT INTO `geocoord` VALUES (596, 0, 浙江, 江山, 28.45, 118.37);
INSERT INTO `geocoord` VALUES (597, 0, 浙江, 嘉兴, 30.46, 120.45);
INSERT INTO `geocoord` VALUES (598, 0, 浙江, 金华, 29.07, 119.39);
INSERT INTO `geocoord` VALUES (599, 0, 浙江, 兰溪, 29.12, 119.28);
INSERT INTO `geocoord` VALUES (600, 0, 浙江, 临海, 28.51, 121.08);
INSERT INTO `geocoord` VALUES (601, 0, 浙江, 丽水, 28.27, 119.54);
INSERT INTO `geocoord` VALUES (602, 0, 浙江, 龙泉, 28.04, 119.08);
INSERT INTO `geocoord` VALUES (603, 0, 浙江, 宁波, 29.52, 121.33);
INSERT INTO `geocoord` VALUES (604, 0, 浙江, 平湖, 30.42, 121.01);
INSERT INTO `geocoord` VALUES (605, 0, 浙江, 衢州, 28.58, 118.52);
INSERT INTO `geocoord` VALUES (606, 0, 浙江, 瑞安, 27.48, 120.38);
INSERT INTO `geocoord` VALUES (607, 0, 浙江, 上虞, 30.01, 120.52);
INSERT INTO `geocoord` VALUES (608, 0, 浙江, 绍兴, 30.00, 120.34);
INSERT INTO `geocoord` VALUES (609, 0, 浙江, 台州, 28.41, 121.27);
INSERT INTO `geocoord` VALUES (610, 0, 浙江, 桐乡, 30.38, 120.32);
INSERT INTO `geocoord` VALUES (611, 0, 浙江, 温岭, 28.22, 121.21);
INSERT INTO `geocoord` VALUES (612, 0, 浙江, 温州, 28.01, 120.39);
INSERT INTO `geocoord` VALUES (613, 0, 浙江, 萧山, 30.09, 120.16);
INSERT INTO `geocoord` VALUES (614, 0, 浙江, 义乌, 29.18, 120.04);
INSERT INTO `geocoord` VALUES (615, 0, 浙江, 乐清, 28.08, 120.58);
INSERT INTO `geocoord` VALUES (616, 0, 浙江, 余杭, 30.26, 120.18);
INSERT INTO `geocoord` VALUES (617, 0, 浙江, 余姚, 30.02, 121.10);
INSERT INTO `geocoord` VALUES (618, 0, 浙江, 永康, 29.54, 120.01);
INSERT INTO `geocoord` VALUES (619, 0, 浙江, 舟山, 30.01, 122.06);
INSERT INTO `geocoord` VALUES (620, 0, 浙江, 诸暨, 29.43, 120.14);
INSERT INTO `geocoord` VALUES (621, 0, 重庆, 重庆, 29.35, 106.33);
View Code

 

全国各省市GeoCoord SQL文件(不包括区县)

原文:http://www.cnblogs.com/wanlxp/p/4680520.html

(0)
(0)
   
举报
评论 一句话评论(0
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!