全国各省市GeoCoord SQL文件（不包括区县）

/*
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');