/*
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 ('', '', '安徽', '合肥', '31.52', '117.17');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '安庆', '30.31', '117.02');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '蚌埠', '32.56', '117.21');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '亳州', '33.52', '115.47');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '巢湖', '31.36', '117.52');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '滁州', '32.18', '118.18');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '阜阳', '32.54', '115.48');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '贵池', '30.39', '117.28');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '淮北', '33.57', '116.47');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '淮南', '32.37', '116.58');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '黄山', '29.43', '118.18');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '界首', '33.15', '115.21');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '六安', '31.44', '116.28');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '马鞍山', '31.43', '118.28');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '明光', '32.47', '117.58');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '宿州', '33.38', '116.58');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '天长', '32.41', '118.59');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '铜陵', '30.56', '117.48');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '芜湖', '31.19', '118.22');
INSERT INTO `geocoord` VALUES ('', '', '安徽', '宣州', '30.57', '118.44');
INSERT INTO `geocoord` VALUES ('', '', '澳门', '澳门', '21.33', '115.07');
INSERT INTO `geocoord` VALUES ('', '', '北京', '北京', '39.55', '116.24');
INSERT INTO `geocoord` VALUES ('', '', '福建', '福州', '26.05', '119.18');
INSERT INTO `geocoord` VALUES ('', '', '福建', '长乐', '25.58', '119.31');
INSERT INTO `geocoord` VALUES ('', '', '福建', '福安', '27.06', '119.39');
INSERT INTO `geocoord` VALUES ('', '', '福建', '福清', '25.42', '119.23');
INSERT INTO `geocoord` VALUES ('', '', '福建', '建瓯', '27.03', '118.20');
INSERT INTO `geocoord` VALUES ('', '', '福建', '建阳', '27.21', '118.07');
INSERT INTO `geocoord` VALUES ('', '', '福建', '晋江', '24.49', '118.35');
INSERT INTO `geocoord` VALUES ('', '', '福建', '龙海', '24.26', '117.48');
INSERT INTO `geocoord` VALUES ('', '', '福建', '龙岩', '25.06', '117.01');
INSERT INTO `geocoord` VALUES ('', '', '福建', '南安', '24.57', '118.23');
INSERT INTO `geocoord` VALUES ('', '', '福建', '南平', '26.38', '118.10');
INSERT INTO `geocoord` VALUES ('', '', '福建', '宁德', '26.39', '119.31');
INSERT INTO `geocoord` VALUES ('', '', '福建', '莆田', '24.26', '119.01');
INSERT INTO `geocoord` VALUES ('', '', '福建', '泉州', '24.56', '118.36');
INSERT INTO `geocoord` VALUES ('', '', '福建', '三明', '26.13', '117.36');
INSERT INTO `geocoord` VALUES ('', '', '福建', '邵武', '27.20', '117.29');
INSERT INTO `geocoord` VALUES ('', '', '福建', '石狮', '24.44', '118.38');
INSERT INTO `geocoord` VALUES ('', '', '福建', '武夷山', '27.46', '118.02');
INSERT INTO `geocoord` VALUES ('', '', '福建', '厦门', '24.27', '118.06');
INSERT INTO `geocoord` VALUES ('', '', '福建', '永安', '25.58', '117.23');
INSERT INTO `geocoord` VALUES ('', '', '福建', '漳平', '25.17', '117.24');
INSERT INTO `geocoord` VALUES ('', '', '福建', '漳州', '24.31', '117.39');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '兰州', '36.04', '103.51');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '白银', '36.33', '104.12');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '敦煌', '40.08', '94.41');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '嘉峪关', '39.48', '98.14');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '金昌', '38.28', '102.10');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '酒泉', '39.44', '98.31');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '临夏', '35.37', '103.12');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '平凉', '35.32', '106.40');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '天水', '34.37', '105.42');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '武威', '37.56', '102.39');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '西峰', '35.45', '107.40');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '玉门', '39.49', '97.35');
INSERT INTO `geocoord` VALUES ('', '', '甘肃', '张掖', '38.56', '100.26');
INSERT INTO `geocoord` VALUES ('', '', '广东', '广州', '23.08', '113.14');
INSERT INTO `geocoord` VALUES ('', '', '广东', '潮阳', '23.16', '116.36');
INSERT INTO `geocoord` VALUES ('', '', '广东', '潮州', '23.40', '116.38');
INSERT INTO `geocoord` VALUES ('', '', '广东', '澄海', '23.28', '116.46');
INSERT INTO `geocoord` VALUES ('', '', '广东', '从化', '23.33', '113.33');
INSERT INTO `geocoord` VALUES ('', '', '广东', '东莞', '23.02', '113.45');
INSERT INTO `geocoord` VALUES ('', '', '广东', '恩平', '22.12', '112.19');
INSERT INTO `geocoord` VALUES ('', '', '广东', '佛山', '23.02', '113.06');
INSERT INTO `geocoord` VALUES ('', '', '广东', '高明', '22.53', '112.50');
INSERT INTO `geocoord` VALUES ('', '', '广东', '高要', '23.02', '112.26');
INSERT INTO `geocoord` VALUES ('', '', '广东', '高州', '21.54', '110.50');
INSERT INTO `geocoord` VALUES ('', '', '广东', '鹤山', '22.46', '112.57');
INSERT INTO `geocoord` VALUES ('', '', '广东', '河源', '23.43', '114.41');
INSERT INTO `geocoord` VALUES ('', '', '广东', '花都', '23.23', '113.12');
INSERT INTO `geocoord` VALUES ('', '', '广东', '化州', '21.39', '110.37');
INSERT INTO `geocoord` VALUES ('', '', '广东', '惠阳', '22.48', '114.28');
INSERT INTO `geocoord` VALUES ('', '', '广东', '惠州', '23.05', '114.22');
INSERT INTO `geocoord` VALUES ('', '', '广东', '江门', '22.35', '113.04');
INSERT INTO `geocoord` VALUES ('', '', '广东', '揭阳', '22.32', '116.21');
INSERT INTO `geocoord` VALUES ('', '', '广东', '开平', '22.22', '112.40');
INSERT INTO `geocoord` VALUES ('', '', '广东', '乐昌', '25.09', '113.21');
INSERT INTO `geocoord` VALUES ('', '', '广东', '雷州', '20.54', '110.04');
INSERT INTO `geocoord` VALUES ('', '', '广东', '廉江', '21.37', '110.17');
INSERT INTO `geocoord` VALUES ('', '', '广东', '连州', '24.48', '112.23');
INSERT INTO `geocoord` VALUES ('', '', '广东', '罗定', '22.46', '111.33');
INSERT INTO `geocoord` VALUES ('', '', '广东', '茂名', '21.40', '110.53');
INSERT INTO `geocoord` VALUES ('', '', '广东', '梅州', '24.19', '116.07');
INSERT INTO `geocoord` VALUES ('', '', '广东', '南海', '23.01', '113.09');
INSERT INTO `geocoord` VALUES ('', '', '广东', '番禺', '22.57', '113.22');
INSERT INTO `geocoord` VALUES ('', '', '广东', '普宁', '23.18', '116.10');
INSERT INTO `geocoord` VALUES ('', '', '广东', '清远', '23.42', '113.01');
INSERT INTO `geocoord` VALUES ('', '', '广东', '三水', '23.10', '112.52');
INSERT INTO `geocoord` VALUES ('', '', '广东', '汕头', '23.22', '116.41');
INSERT INTO `geocoord` VALUES ('', '', '广东', '汕尾', '22.47', '115.21');
INSERT INTO `geocoord` VALUES ('', '', '广东', '韶关', '24.48', '113.37');
INSERT INTO `geocoord` VALUES ('', '', '广东', '深圳', '22.33', '114.07');
INSERT INTO `geocoord` VALUES ('', '', '广东', '顺德', '22.50', '113.15');
INSERT INTO `geocoord` VALUES ('', '', '广东', '四会', '23.21', '112.41');
INSERT INTO `geocoord` VALUES ('', '', '广东', '台山', '22.15', '112.48');
INSERT INTO `geocoord` VALUES ('', '', '广东', '吴川', '21.26', '110.47');
INSERT INTO `geocoord` VALUES ('', '', '广东', '新会', '22.32', '113.01');
INSERT INTO `geocoord` VALUES ('', '', '广东', '兴宁', '24.09', '115.43');
INSERT INTO `geocoord` VALUES ('', '', '广东', '阳春', '22.10', '111.48');
INSERT INTO `geocoord` VALUES ('', '', '广东', '阳江', '21.50', '111.58');
INSERT INTO `geocoord` VALUES ('', '', '广东', '英德', '24.10', '113.22');
INSERT INTO `geocoord` VALUES ('', '', '广东', '云浮', '22.57', '112.02');
INSERT INTO `geocoord` VALUES ('', '', '广东', '增城', '23.18', '113.49');
INSERT INTO `geocoord` VALUES ('', '', '广东', '湛江', '21.11', '110.24');
INSERT INTO `geocoord` VALUES ('', '', '广东', '肇庆', '23.03', '112.27');
INSERT INTO `geocoord` VALUES ('', '', '广东', '中山', '22.31', '113.22');
INSERT INTO `geocoord` VALUES ('', '', '广东', '珠海', '22.17', '113.34');
INSERT INTO `geocoord` VALUES ('', '', '广西', '南宁', '22.48', '108.19');
INSERT INTO `geocoord` VALUES ('', '', '广西', '北海', '21.28', '109.07');
INSERT INTO `geocoord` VALUES ('', '', '广西', '北流', '22.42', '110.21');
INSERT INTO `geocoord` VALUES ('', '', '广西', '百色', '23.54', '106.36');
INSERT INTO `geocoord` VALUES ('', '', '广西', '防城港', '21.37', '108.20');
INSERT INTO `geocoord` VALUES ('', '', '广西', '贵港', '23.06', '109.36');
INSERT INTO `geocoord` VALUES ('', '', '广西', '桂林', '25.17', '110.17');
INSERT INTO `geocoord` VALUES ('', '', '广西', '桂平', '23.22', '110.04');
INSERT INTO `geocoord` VALUES ('', '', '广西', '河池', '24.42', '108.03');
INSERT INTO `geocoord` VALUES ('', '', '广西', '合山', '23.47', '108.52');
INSERT INTO `geocoord` VALUES ('', '', '广西', '柳州', '23.19', '109.24');
INSERT INTO `geocoord` VALUES ('', '', '广西', '赁祥', '22.07', '106.44');
INSERT INTO `geocoord` VALUES ('', '', '广西', '钦州', '21.57', '108.37');
INSERT INTO `geocoord` VALUES ('', '', '广西', '梧州', '23.29', '111.20');
INSERT INTO `geocoord` VALUES ('', '', '广西', '玉林', '22.38', '110.09');
INSERT INTO `geocoord` VALUES ('', '', '广西', '宜州', '24.28', '108.40');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '贵阳', '26.35', '106.42');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '安顺', '26.14', '105.55');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '毕节', '27.18', '105.18');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '赤水', '28.34', '105.42');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '都匀', '26.15', '107.31');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '凯里', '26.35', '107.58');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '六盘水', '26.35', '104.50');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '清镇', '26.33', '106.27');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '铜仁', '27.43', '109.12');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '兴义', '25.05', '104.53');
INSERT INTO `geocoord` VALUES ('', '', '贵州', '遵义', '27.42', '106.55');
INSERT INTO `geocoord` VALUES ('', '', '海南', '海口', '20.02', '110.20');
INSERT INTO `geocoord` VALUES ('', '', '海南', '儋州', '19.31', '109.34');
INSERT INTO `geocoord` VALUES ('', '', '海南', '琼海', '19.14', '110.28');
INSERT INTO `geocoord` VALUES ('', '', '海南', '琼山', '19.59', '110.21');
INSERT INTO `geocoord` VALUES ('', '', '海南', '三亚', '18.14', '109.31');
INSERT INTO `geocoord` VALUES ('', '', '海南', '通什', '18.46', '109.31');
INSERT INTO `geocoord` VALUES ('', '', '河北', '石家庄', '38.02', '114.30');
INSERT INTO `geocoord` VALUES ('', '', '河北', '安国', '38.24', '115.20');
INSERT INTO `geocoord` VALUES ('', '', '河北', '保定', '38.51', '115.30');
INSERT INTO `geocoord` VALUES ('', '', '河北', '霸州', '39.06', '116.24');
INSERT INTO `geocoord` VALUES ('', '', '河北', '泊头', '38.04', '116.34');
INSERT INTO `geocoord` VALUES ('', '', '河北', '沧州', '38.18', '116.52');
INSERT INTO `geocoord` VALUES ('', '', '河北', '承德', '40.59', '117.57');
INSERT INTO `geocoord` VALUES ('', '', '河北', '定州', '38.30', '115.00');
INSERT INTO `geocoord` VALUES ('', '', '河北', '丰南', '39.34', '118.06');
INSERT INTO `geocoord` VALUES ('', '', '河北', '高碑店', '39.20', '115.51');
INSERT INTO `geocoord` VALUES ('', '', '河北', '蒿城', '38.02', '114.50');
INSERT INTO `geocoord` VALUES ('', '', '河北', '邯郸', '36.36', '114.28');
INSERT INTO `geocoord` VALUES ('', '', '河北', '河间', '38.26', '116.05');
INSERT INTO `geocoord` VALUES ('', '', '河北', '衡水', '37.44', '115.42');
INSERT INTO `geocoord` VALUES ('', '', '河北', '黄骅', '38.21', '117.21');
INSERT INTO `geocoord` VALUES ('', '', '河北', '晋州', '38.02', '115.02');
INSERT INTO `geocoord` VALUES ('', '', '河北', '冀州', '37.34', '115.33');
INSERT INTO `geocoord` VALUES ('', '', '河北', '廊坊', '39.31', '116.42');
INSERT INTO `geocoord` VALUES ('', '', '河北', '鹿泉', '38.04', '114.19');
INSERT INTO `geocoord` VALUES ('', '', '河北', '南宫', '37.22', '115.23');
INSERT INTO `geocoord` VALUES ('', '', '河北', '秦皇岛', '39.55', '119.35');
INSERT INTO `geocoord` VALUES ('', '', '河北', '任丘', '38.42', '116.07');
INSERT INTO `geocoord` VALUES ('', '', '河北', '三河', '39.58', '117.04');
INSERT INTO `geocoord` VALUES ('', '', '河北', '沙河', '36.51', '114.30');
INSERT INTO `geocoord` VALUES ('', '', '河北', '深州', '38.01', '115.32');
INSERT INTO `geocoord` VALUES ('', '', '河北', '唐山', '39.36', '118.11');
INSERT INTO `geocoord` VALUES ('', '', '河北', '武安', '36.42', '114.11');
INSERT INTO `geocoord` VALUES ('', '', '河北', '邢台', '37.04', '114.30');
INSERT INTO `geocoord` VALUES ('', '', '河北', '辛集', '37.54', '115.12');
INSERT INTO `geocoord` VALUES ('', '', '河北', '新乐', '38.20', '114.41');
INSERT INTO `geocoord` VALUES ('', '', '河北', '张家口', '40.48', '114.53');
INSERT INTO `geocoord` VALUES ('', '', '河北', '涿州', '39.29', '115.59');
INSERT INTO `geocoord` VALUES ('', '', '河北', '遵化', '40.11', '117.58');
INSERT INTO `geocoord` VALUES ('', '', '河南', '郑州', '34.46', '113.40');
INSERT INTO `geocoord` VALUES ('', '', '河南', '安阳', '36.06', '114.21');
INSERT INTO `geocoord` VALUES ('', '', '河南', '长葛', '34.12', '113.47');
INSERT INTO `geocoord` VALUES ('', '', '河南', '登封', '34.27', '113.02');
INSERT INTO `geocoord` VALUES ('', '', '河南', '邓州', '32.42', '112.05');
INSERT INTO `geocoord` VALUES ('', '', '河南', '巩义', '34.46', '112.58');
INSERT INTO `geocoord` VALUES ('', '', '河南', '鹤壁', '35.54', '114.11');
INSERT INTO `geocoord` VALUES ('', '', '河南', '辉县', '35.27', '113.47');
INSERT INTO `geocoord` VALUES ('', '', '河南', '焦作', '35.14', '113.12');
INSERT INTO `geocoord` VALUES ('', '', '河南', '济源', '35.04', '112.35');
INSERT INTO `geocoord` VALUES ('', '', '河南', '开封', '34.47', '114.21');
INSERT INTO `geocoord` VALUES ('', '', '河南', '灵宝', '34.31', '110.52');
INSERT INTO `geocoord` VALUES ('', '', '河南', '林州', '36.03', '113.49');
INSERT INTO `geocoord` VALUES ('', '', '河南', '漯河', '33.33', '114.02');
INSERT INTO `geocoord` VALUES ('', '', '河南', '洛阳', '34.41', '112.27');
INSERT INTO `geocoord` VALUES ('', '', '河南', '南阳', '33.00', '112.32');
INSERT INTO `geocoord` VALUES ('', '', '河南', '平顶山', '33.44', '113.17');
INSERT INTO `geocoord` VALUES ('', '', '河南', '濮阳', '35.44', '115.01');
INSERT INTO `geocoord` VALUES ('', '', '河南', '沁阳', '35.05', '112.57');
INSERT INTO `geocoord` VALUES ('', '', '河南', '汝州', '34.09', '112.50');
INSERT INTO `geocoord` VALUES ('', '', '河南', '三门峡', '34.47', '111.12');
INSERT INTO `geocoord` VALUES ('', '', '河南', '商丘', '34.26', '115.38');
INSERT INTO `geocoord` VALUES ('', '', '河南', '卫辉', '35.24', '114.03');
INSERT INTO `geocoord` VALUES ('', '', '河南', '舞钢', '33.17', '113.30');
INSERT INTO `geocoord` VALUES ('', '', '河南', '项城', '33.26', '114.54');
INSERT INTO `geocoord` VALUES ('', '', '河南', '荥阳', '34.46', '113.21');
INSERT INTO `geocoord` VALUES ('', '', '河南', '新密', '34.31', '113.22');
INSERT INTO `geocoord` VALUES ('', '', '河南', '新乡', '35.18', '113.52');
INSERT INTO `geocoord` VALUES ('', '', '河南', '信阳', '32.07', '114.04');
INSERT INTO `geocoord` VALUES ('', '', '河南', '新郑', '34.24', '113.43');
INSERT INTO `geocoord` VALUES ('', '', '河南', '许昌', '34.01', '113.49');
INSERT INTO `geocoord` VALUES ('', '', '河南', '偃师', '34.43', '112.47');
INSERT INTO `geocoord` VALUES ('', '', '河南', '义马', '34.43', '111.55');
INSERT INTO `geocoord` VALUES ('', '', '河南', '禹州', '34.09', '113.28');
INSERT INTO `geocoord` VALUES ('', '', '河南', '周口', '33.37', '114.38');
INSERT INTO `geocoord` VALUES ('', '', '河南', '驻马店', '32.58', '114.01');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '哈尔滨', '45.44', '126.36');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '阿城', '45.32', '126.58');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '安达', '46.24', '125.18');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '北安', '48.15', '126.31');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '大庆', '46.36', '125.01');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '富锦', '47.15', '132.02');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '海林', '44.35', '129.21');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '海伦', '47.28', '126.57');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '鹤岗', '47.20', '130.16');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '黑河', '50.14', '127.29');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '佳木斯', '46.47', '130.22');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '鸡西', '45.17', '130.57');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '密山', '45.32', '131.50');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '牡丹江', '44.35', '129.36');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '讷河', '48.29', '124.51');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '宁安', '44.21', '129.28');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '齐齐哈尔', '47.20', '123.57');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '七台河', '45.48', '130.49');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '双城', '45.22', '126.15');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '尚志', '45.14', '127.55');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '双鸭山', '46.38', '131.11');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '绥芬河', '44.25', '131.11');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '绥化', '46.38', '126.59');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '铁力', '46.59', '128.01');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '同江', '47.39', '132.30');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '五常', '44.55', '127.11');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '五大连池', '48.38', '126.07');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '伊春', '47.42', '128.56');
INSERT INTO `geocoord` VALUES ('', '', '黑龙江', '肇东', '46.04', '125.58');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '武汉', '30.35', '114.17');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '安陆', '31.15', '113.41');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '当阳', '30.50', '111.47');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '丹江口', '32.33', '108.30');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '大冶', '30.06', '114.58');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '恩施', '30.16', '109.29');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '鄂州', '30.23', '114.52');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '广水', '31.37', '113.48');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '洪湖', '29.48', '113.27');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '黄石', '30.12', '115.06');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '黄州', '30.27', '114.52');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '荆门', '31.02', '112.12');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '荆沙', '30.18', '112.16');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '老河口', '32.23', '111.40');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '利川', '30.18', '108.56');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '麻城', '31.10', '115.01');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '浦圻', '29.42', '113.51');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '潜江', '30.26', '112.53');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '石首', '29.43', '112.24');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '十堰', '32.40', '110.47');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '随州', '31.42', '113.22');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '天门', '60.39', '113.10');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '武穴', '29.51', '115.33');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '襄樊', '32.02', '112.08');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '咸宁', '29.53', '114.17');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '仙桃', '30.22', '113.27');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '孝感', '30.56', '113.54');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '宜昌', '30.42', '111.17');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '宜城', '31.42', '112.15');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '应城', '30.57', '113.33');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '枣阳', '32.07', '112.44');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '枝城', '30.23', '111.27');
INSERT INTO `geocoord` VALUES ('', '', '湖北', '钟祥', '31.10', '112.34');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '长沙', '28.12', '112.59');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '常德', '29.02', '111.51');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '郴州', '25.46', '113.02');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '衡阳', '26.53', '112.37');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '洪江', '27.07', '109.59');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '怀化', '27.33', '109.58');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '津市', '29.38', '111.52');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '吉首', '28.18', '109.43');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '耒阳', '26.24', '112.51');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '冷水江', '27.42', '111.26');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '冷水滩', '26.26', '111.35');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '涟源', '27.41', '111.41');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '醴陵', '27.40', '113.30');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '临湘', '29.29', '113.27');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '浏阳', '28.09', '113.37');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '娄底', '27.44', '111.59');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '汨罗', '28.49', '113.03');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '韶山', '27.54', '112.29');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '邵阳', '27.14', '111.28');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '武冈', '26.43', '110.37');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '湘潭', '27.52', '112.53');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '湘乡', '27.44', '112.31');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '益阳', '28.36', '112.20');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '永州', '26.13', '111.37');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '沅江', '28.50', '112.22');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '岳阳', '29.22', '113.06');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '张家界', '29.08', '110.29');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '株洲', '27.51', '113.09');
INSERT INTO `geocoord` VALUES ('', '', '湖南', '资兴', '25.58', '113.13');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '长春', '43.54', '125.19');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '白城', '45.38', '122.50');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '白山', '41.56', '126.26');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '大安', '45.30', '124.18');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '德惠', '44.32', '125.42');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '敦化', '43.22', '128.13');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '公主岭', '43.31', '124.49');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '和龙', '42.32', '129.00');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '桦甸', '42.58', '126.44');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '珲春', '42.52', '130.22');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '集安', '41.08', '126.11');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '蛟河', '43.42', '127.21');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '吉林', '43.52', '126.33');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '九台', '44.09', '125.51');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '辽源', '42.54', '125.09');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '临江', '41.49', '126.53');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '龙井', '42.46', '129.26');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '梅河口', '42.32', '125.40');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '舒兰', '44.24', '126.57');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '四平', '43.10', '124.22');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '*', '45.11', '124.49');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '洮南', '45.20', '122.47');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '通化', '41.43', '125.56');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '图们', '42.57', '129.51');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '延吉', '42.54', '129.30');
INSERT INTO `geocoord` VALUES ('', '', '吉林', '愉树', '44.49', '126.32');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '南京', '32.03', '118.46');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '常熟', '31.39', '120.43');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '常州', '31.47', '119.58');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '丹阳', '32.00', '119.32');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '东台', '32.51', '120.19');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '高邮', '32.47', '119.27');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '海门', '31.53', '121.09');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '淮安', '33.30', '119.09');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '淮阴', '33.36', '119.02');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '江都', '32.26', '119.32');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '姜堰', '32.34', '120.08');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '江阴', '31.54', '120.17');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '靖江', '32.02', '120.17');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '金坛', '31.46', '119.33');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '昆山', '31.23', '120.57');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '连去港', '34.36', '119.10');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '溧阳', '31.26', '119.29');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '南通', '32.01', '120.51');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '邳州', '34.19', '117.59');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '启乐', '31.48', '121.39');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '如皋', '32.23', '120.33');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '宿迁', '33.58', '118.18');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '苏州', '31.19', '120.37');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '太仓', '31.27', '121.06');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '泰兴', '32.10', '120.01');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '泰州', '32.30', '119.54');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '通州', '32.05', '121.03');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '吴江', '31.10', '120.39');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '无锡', '31.34', '120.18');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '兴化', '32.56', '119.50');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '新沂', '34.22', '118.20');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '徐州', '34.15', '117.11');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '盐在', '33.22', '120.08');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '扬中', '32.14', '119.49');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '扬州', '32.23', '119.26');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '宜兴', '31.21', '119.49');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '仪征', '32.16', '119.10');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '张家港', '31.52', '120.32');
INSERT INTO `geocoord` VALUES ('', '', '江苏', '镇江', '32.11', '119.27');
INSERT INTO `geocoord` VALUES ('', '', '江西', '南昌', '28.40', '115.55');
INSERT INTO `geocoord` VALUES ('', '', '江西', '德兴', '28.57', '117.35');
INSERT INTO `geocoord` VALUES ('', '', '江西', '丰城', '28.12', '115.48');
INSERT INTO `geocoord` VALUES ('', '', '江西', '赣州', '28.52', '114.56');
INSERT INTO `geocoord` VALUES ('', '', '江西', '高安', '28.25', '115.22');
INSERT INTO `geocoord` VALUES ('', '', '江西', '吉安', '27.07', '114.58');
INSERT INTO `geocoord` VALUES ('', '', '江西', '景德镇', '29.17', '117.13');
INSERT INTO `geocoord` VALUES ('', '', '江西', '井冈山', '26.34', '114.10');
INSERT INTO `geocoord` VALUES ('', '', '江西', '九江', '29.43', '115.58');
INSERT INTO `geocoord` VALUES ('', '', '江西', '乐平', '28.58', '117.08');
INSERT INTO `geocoord` VALUES ('', '', '江西', '临川', '27.59', '116.21');
INSERT INTO `geocoord` VALUES ('', '', '江西', '萍乡', '27.37', '113.50');
INSERT INTO `geocoord` VALUES ('', '', '江西', '瑞昌', '29.40', '115.38');
INSERT INTO `geocoord` VALUES ('', '', '江西', '瑞金', '25.53', '116.01');
INSERT INTO `geocoord` VALUES ('', '', '江西', '上饶', '25.27', '117.58');
INSERT INTO `geocoord` VALUES ('', '', '江西', '新余', '27.48', '114.56');
INSERT INTO `geocoord` VALUES ('', '', '江西', '宜春', '27.47', '114.23');
INSERT INTO `geocoord` VALUES ('', '', '江西', '鹰潭', '28.14', '117.03');
INSERT INTO `geocoord` VALUES ('', '', '江西', '樟树', '28.03', '115.32');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '沈阳', '41.48', '123.25');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '鞍山', '41.07', '123.00');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '北票', '41.48', '120.47');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '本溪', '41.18', '123.46');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '朝阳', '41.34', '120.27');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '大连', '38.55', '121.36');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '丹东', '40.08', '124.22');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '大石桥', '40.37', '122.31');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '东港', '39.53', '124.08');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '凤城', '40.28', '124.02');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '抚顺', '41.51', '123.54');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '阜新', '42.01', '121.39');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '盖州', '40.24', '122.21');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '海城', '40.51', '122.43');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '葫芦岛', '40.45', '120.51');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '锦州', '41.07', '121.09');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '开原', '42.32', '124.02');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '辽阳', '41.16', '123.12');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '凌海', '41.10', '121.21');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '凌源', '41.14', '119.22');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '盘锦', '41.07', '122.03');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '普兰店', '39.23', '121.58');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '铁法', '42.28', '123.32');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '铁岭', '42.18', '123.51');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '瓦房店', '39.37', '122.00');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '兴城', '40.37', '120.41');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '新民', '41.59', '122.49');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '营口', '40.39', '122.13');
INSERT INTO `geocoord` VALUES ('', '', '辽宁', '庄河', '39.41', '122.58');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '呼和浩特', '40.48', '111.41');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '包头', '40.39', '109.49');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '赤峰', '42.17', '118.58');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '东胜', '39.48', '109.59');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '二连浩特', '43.38', '111.58');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '额尔古纳', '50.13', '120.11');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '丰镇', '40.27', '113.09');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '根河', '50.48', '121.29');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '海拉尔', '49.12', '119.39');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '霍林郭勒', '45.32', '119.38');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '集宁', '41.02', '113.06');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '临河', '40.46', '107.22');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '满洲里', '49.35', '117.23');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '通辽', '43.37', '122.16');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '乌兰浩特', '46.03', '122.03');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '乌海', '39.40', '106.48');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '锡林浩特', '43.57', '116.03');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '牙克石', '49.17', '120.40');
INSERT INTO `geocoord` VALUES ('', '', '内蒙古', '扎兰屯', '48.00', '122.47');
INSERT INTO `geocoord` VALUES ('', '', '宁夏', '银川', '38.27', '106.16');
INSERT INTO `geocoord` VALUES ('', '', '宁夏', '青铜峡', '37.56', '105.59');
INSERT INTO `geocoord` VALUES ('', '', '宁夏', '石嘴山', '39.02', '106.22');
INSERT INTO `geocoord` VALUES ('', '', '宁夏', '吴忠', '37.59', '106.11');
INSERT INTO `geocoord` VALUES ('', '', '青海', '西宁', '36.38', '101.48');
INSERT INTO `geocoord` VALUES ('', '', '青海', '德令哈', '37.22', '97.23');
INSERT INTO `geocoord` VALUES ('', '', '青海', '格尔木', '36.26', '94.55');
INSERT INTO `geocoord` VALUES ('', '', '山东', '济南', '36.40', '117.00');
INSERT INTO `geocoord` VALUES ('', '', '山东', '安丘', '36.25', '119.12');
INSERT INTO `geocoord` VALUES ('', '', '山东', '滨州', '37.22', '118.02');
INSERT INTO `geocoord` VALUES ('', '', '山东', '昌邑', '39.52', '119.24');
INSERT INTO `geocoord` VALUES ('', '', '山东', '德州', '37.26', '116.17');
INSERT INTO `geocoord` VALUES ('', '', '山东', '东营', '37.27', '118.30');
INSERT INTO `geocoord` VALUES ('', '', '山东', '肥城', '36.14', '116.46');
INSERT INTO `geocoord` VALUES ('', '', '山东', '高密', '36.22', '119.44');
INSERT INTO `geocoord` VALUES ('', '', '山东', '菏泽', '35.14', '115.26');
INSERT INTO `geocoord` VALUES ('', '', '山东', '胶南', '35.53', '119.58');
INSERT INTO `geocoord` VALUES ('', '', '山东', '胶州', '36.17', '120.00');
INSERT INTO `geocoord` VALUES ('', '', '山东', '即墨', '36.22', '120.28');
INSERT INTO `geocoord` VALUES ('', '', '山东', '济宁', '35.23', '116.33');
INSERT INTO `geocoord` VALUES ('', '', '山东', '莱芜', '36.12', '117.40');
INSERT INTO `geocoord` VALUES ('', '', '山东', '莱西', '36.52', '120.31');
INSERT INTO `geocoord` VALUES ('', '', '山东', '莱阳', '36.58', '120.42');
INSERT INTO `geocoord` VALUES ('', '', '山东', '莱州', '37.10', '119.57');
INSERT INTO `geocoord` VALUES ('', '', '山东', '乐陵', '37.44', '117.12');
INSERT INTO `geocoord` VALUES ('', '', '山东', '聊城', '36.26', '115.57');
INSERT INTO `geocoord` VALUES ('', '', '山东', '临清', '36.51', '115.42');
INSERT INTO `geocoord` VALUES ('', '', '山东', '临沂', '35.03', '118.20');
INSERT INTO `geocoord` VALUES ('', '', '山东', '龙口', '37.39', '120.21');
INSERT INTO `geocoord` VALUES ('', '', '山东', '蓬莱', '37.48', '120.45');
INSERT INTO `geocoord` VALUES ('', '', '山东', '平度', '36.47', '119.58');
INSERT INTO `geocoord` VALUES ('', '', '山东', '青岛', '36.03', '120.18');
INSERT INTO `geocoord` VALUES ('', '', '山东', '青州', '36.42', '118.28');
INSERT INTO `geocoord` VALUES ('', '', '山东', '曲阜', '35.36', '116.58');
INSERT INTO `geocoord` VALUES ('', '', '山东', '日照', '35.23', '119.32');
INSERT INTO `geocoord` VALUES ('', '', '山东', '荣成', '37.10', '122.25');
INSERT INTO `geocoord` VALUES ('', '', '山东', '乳山', '36.54', '121.31');
INSERT INTO `geocoord` VALUES ('', '', '山东', '寿光', '36.53', '118.44');
INSERT INTO `geocoord` VALUES ('', '', '山东', '泰安', '36.11', '117.08');
INSERT INTO `geocoord` VALUES ('', '', '山东', '滕州', '35.06', '117.09');
INSERT INTO `geocoord` VALUES ('', '', '山东', '潍坊', '36.43', '119.06');
INSERT INTO `geocoord` VALUES ('', '', '山东', '威海', '37.31', '122.07');
INSERT INTO `geocoord` VALUES ('', '', '山东', '文登', '37.12', '122.03');
INSERT INTO `geocoord` VALUES ('', '', '山东', '新泰', '35.54', '117.45');
INSERT INTO `geocoord` VALUES ('', '', '山东', '烟台', '37.32', '121.24');
INSERT INTO `geocoord` VALUES ('', '', '山东', '兖州', '35.32', '116.49');
INSERT INTO `geocoord` VALUES ('', '', '山东', '禹城', '36.56', '116.39');
INSERT INTO `geocoord` VALUES ('', '', '山东', '枣庄', '34.52', '117.33');
INSERT INTO `geocoord` VALUES ('', '', '山东', '章丘', '36.43', '117.32');
INSERT INTO `geocoord` VALUES ('', '', '山东', '招远', '37.21', '120.23');
INSERT INTO `geocoord` VALUES ('', '', '山东', '诸城', '35.59', '119.24');
INSERT INTO `geocoord` VALUES ('', '', '山东', '淄博', '36.48', '118.03');
INSERT INTO `geocoord` VALUES ('', '', '山东', '邹城', '35.24', '116.58');
INSERT INTO `geocoord` VALUES ('', '', '山西', '太原', '37.54', '112.33');
INSERT INTO `geocoord` VALUES ('', '', '山西', '长治', '36.11', '113.06');
INSERT INTO `geocoord` VALUES ('', '', '山西', '大同', '40.06', '113.17');
INSERT INTO `geocoord` VALUES ('', '', '山西', '高平', '35.48', '112.55');
INSERT INTO `geocoord` VALUES ('', '', '山西', '古交', '37.54', '112.09');
INSERT INTO `geocoord` VALUES ('', '', '山西', '河津', '35.35', '110.41');
INSERT INTO `geocoord` VALUES ('', '', '山西', '侯马', '35.37', '111.21');
INSERT INTO `geocoord` VALUES ('', '', '山西', '霍州', '36.34', '111.42');
INSERT INTO `geocoord` VALUES ('', '', '山西', '介休', '37.02', '111.55');
INSERT INTO `geocoord` VALUES ('', '', '山西', '晋城', '35.30', '112.51');
INSERT INTO `geocoord` VALUES ('', '', '山西', '临汾', '36.05', '111.31');
INSERT INTO `geocoord` VALUES ('', '', '山西', '潞城', '36.21', '113.14');
INSERT INTO `geocoord` VALUES ('', '', '山西', '朔州', '39.19', '112.26');
INSERT INTO `geocoord` VALUES ('', '', '山西', '孝义', '37.08', '111.48');
INSERT INTO `geocoord` VALUES ('', '', '山西', '忻州', '38.24', '112.43');
INSERT INTO `geocoord` VALUES ('', '', '山西', '阳泉', '37.51', '113.34');
INSERT INTO `geocoord` VALUES ('', '', '山西', '永济', '34.52', '110.27');
INSERT INTO `geocoord` VALUES ('', '', '山西', '原平', '38.43', '112.42');
INSERT INTO `geocoord` VALUES ('', '', '山西', '榆次', '37.41', '112.43');
INSERT INTO `geocoord` VALUES ('', '', '山西', '运城', '35.02', '110.59');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '西安', '34.17', '108.57');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '安康', '32.41', '109.01');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '宝鸡', '34.22', '107.09');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '韩城', '35.28', '110.27');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '汉中', '33.04', '107.01');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '华阴', '34.34', '110.05');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '商州', '33.52', '109.57');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '铜川', '35.06', '109.07');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '渭南', '34.30', '109.30');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '咸阳', '34.20', '108.43');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '兴平', '34.18', '108.29');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '延安', '36.35', '109.28');
INSERT INTO `geocoord` VALUES ('', '', '陕西', '榆林', '38.18', '109.47');
INSERT INTO `geocoord` VALUES ('', '', '上海', '上海', '31.14', '121.29');
INSERT INTO `geocoord` VALUES ('', '', '四川', '成都', '30.40', '104.04');
INSERT INTO `geocoord` VALUES ('', '', '四川', '巴中', '31.51', '106.43');
INSERT INTO `geocoord` VALUES ('', '', '四川', '崇州', '30.39', '103.40');
INSERT INTO `geocoord` VALUES ('', '', '四川', '达川', '31.14', '107.29');
INSERT INTO `geocoord` VALUES ('', '', '四川', '德阳', '31.09', '104.22');
INSERT INTO `geocoord` VALUES ('', '', '四川', '都江堰', '31.01', '103.37');
INSERT INTO `geocoord` VALUES ('', '', '四川', '峨眉山', '29.36', '103.29');
INSERT INTO `geocoord` VALUES ('', '', '四川', '涪陵', '29.42', '107.22');
INSERT INTO `geocoord` VALUES ('', '', '四川', '广汉', '30.58', '104.15');
INSERT INTO `geocoord` VALUES ('', '', '四川', '广元', '32.28', '105.51');
INSERT INTO `geocoord` VALUES ('', '', '四川', '华蓥', '30.26', '106.44');
INSERT INTO `geocoord` VALUES ('', '', '四川', '简阳', '30.24', '104.32');
INSERT INTO `geocoord` VALUES ('', '', '四川', '江油', '31.48', '104.42');
INSERT INTO `geocoord` VALUES ('', '', '四川', '阆中', '31.36', '105.58');
INSERT INTO `geocoord` VALUES ('', '', '四川', '乐山', '29.36', '103.44');
INSERT INTO `geocoord` VALUES ('', '', '四川', '泸州', '28.54', '105.24');
INSERT INTO `geocoord` VALUES ('', '', '四川', '绵阳', '31.30', '104.42');
INSERT INTO `geocoord` VALUES ('', '', '四川', '南充', '30.49', '106.04');
INSERT INTO `geocoord` VALUES ('', '', '四川', '内江', '29.36', '105.02');
INSERT INTO `geocoord` VALUES ('', '', '四川', '攀枝花', '26.34', '101.43');
INSERT INTO `geocoord` VALUES ('', '', '四川', '彭州', '30.59', '103.57');
INSERT INTO `geocoord` VALUES ('', '', '四川', '邛崃', '30.26', '103.28');
INSERT INTO `geocoord` VALUES ('', '', '四川', '遂宁', '30.31', '105.33');
INSERT INTO `geocoord` VALUES ('', '', '四川', '万县', '30.50', '108.21');
INSERT INTO `geocoord` VALUES ('', '', '四川', '万源', '32.03', '108.03');
INSERT INTO `geocoord` VALUES ('', '', '四川', '西昌', '27.54', '102.16');
INSERT INTO `geocoord` VALUES ('', '', '四川', '雅安', '29.59', '102.59');
INSERT INTO `geocoord` VALUES ('', '', '四川', '宜宾', '28.47', '104.34');
INSERT INTO `geocoord` VALUES ('', '', '四川', '自贡', '29.23', '104.46');
INSERT INTO `geocoord` VALUES ('', '', '四川', '资阳', '30.09', '104.38');
INSERT INTO `geocoord` VALUES ('', '', '*', '台北', '25.03', '121.30');
INSERT INTO `geocoord` VALUES ('', '', '天津', '天津', '39.02', '117.12');
INSERT INTO `geocoord` VALUES ('', '', '*', '拉萨', '29.39', '91.08');
INSERT INTO `geocoord` VALUES ('', '', '*', '日喀则', '29.16', '88.51');
INSERT INTO `geocoord` VALUES ('', '', '香港', '香港', '21.23', '115.12');
INSERT INTO `geocoord` VALUES ('', '', '*', '乌鲁木齐', '43.45', '87.36');
INSERT INTO `geocoord` VALUES ('', '', '*', '阿克苏', '41.09', '80.19');
INSERT INTO `geocoord` VALUES ('', '', '*', '阿勒泰', '47.50', '88.12');
INSERT INTO `geocoord` VALUES ('', '', '*', '阿图什', '39.42', '76.08');
INSERT INTO `geocoord` VALUES ('', '', '*', '博乐', '44.57', '82.08');
INSERT INTO `geocoord` VALUES ('', '', '*', '昌吉', '44.02', '87.18');
INSERT INTO `geocoord` VALUES ('', '', '*', '阜康', '44.09', '87.58');
INSERT INTO `geocoord` VALUES ('', '', '*', '哈密', '42.50', '93.28');
INSERT INTO `geocoord` VALUES ('', '', '*', '和田', '37.09', '79.55');
INSERT INTO `geocoord` VALUES ('', '', '*', '克拉玛依', '45.36', '84.51');
INSERT INTO `geocoord` VALUES ('', '', '*', '喀什', '39.30', '75.59');
INSERT INTO `geocoord` VALUES ('', '', '*', '库尔勒', '41.46', '86.07');
INSERT INTO `geocoord` VALUES ('', '', '*', '奎屯', '44.27', '84.56');
INSERT INTO `geocoord` VALUES ('', '', '*', '石河子', '44.18', '86.00');
INSERT INTO `geocoord` VALUES ('', '', '*', '塔城', '46.46', '82.59');
INSERT INTO `geocoord` VALUES ('', '', '*', '吐鲁番', '42.54', '89.11');
INSERT INTO `geocoord` VALUES ('', '', '*', '伊宁', '43.55', '81.20');
INSERT INTO `geocoord` VALUES ('', '', '云南', '昆明', '25.04', '102.42');
INSERT INTO `geocoord` VALUES ('', '', '云南', '保山', '25.08', '99.10');
INSERT INTO `geocoord` VALUES ('', '', '云南', '楚雄', '25.01', '101.32');
INSERT INTO `geocoord` VALUES ('', '', '云南', '大理', '25.34', '100.13');
INSERT INTO `geocoord` VALUES ('', '', '云南', '东川', '26.06', '103.12');
INSERT INTO `geocoord` VALUES ('', '', '云南', '个旧', '23.21', '103.09');
INSERT INTO `geocoord` VALUES ('', '', '云南', '景洪', '22.01', '100.48');
INSERT INTO `geocoord` VALUES ('', '', '云南', '开远', '23.43', '103.13');
INSERT INTO `geocoord` VALUES ('', '', '云南', '曲靖', '25.30', '103.48');
INSERT INTO `geocoord` VALUES ('', '', '云南', '瑞丽', '24.00', '97.50');
INSERT INTO `geocoord` VALUES ('', '', '云南', '思茅', '22.48', '100.58');
INSERT INTO `geocoord` VALUES ('', '', '云南', '畹町', '24.06', '98.04');
INSERT INTO `geocoord` VALUES ('', '', '云南', '宣威', '26.13', '104.06');
INSERT INTO `geocoord` VALUES ('', '', '云南', '玉溪', '24.22', '102.32');
INSERT INTO `geocoord` VALUES ('', '', '云南', '昭通', '27.20', '103.42');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '杭州', '30.16', '120.10');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '慈溪', '30.11', '121.15');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '东阳', '29.16', '120.14');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '奉化', '29.39', '121.24');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '富阳', '30.03', '119.57');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '海宁', '30.32', '120.42');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '湖州', '30.52', '120.06');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '建德', '29.29', '119.16');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '*', '28.45', '118.37');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '嘉兴', '30.46', '120.45');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '金华', '29.07', '119.39');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '兰溪', '29.12', '119.28');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '临海', '28.51', '121.08');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '丽水', '28.27', '119.54');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '龙泉', '28.04', '119.08');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '宁波', '29.52', '121.33');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '平湖', '30.42', '121.01');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '衢州', '28.58', '118.52');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '瑞安', '27.48', '120.38');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '上虞', '30.01', '120.52');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '绍兴', '30.00', '120.34');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '台州', '28.41', '121.27');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '桐乡', '30.38', '120.32');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '温岭', '28.22', '121.21');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '温州', '28.01', '120.39');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '萧山', '30.09', '120.16');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '义乌', '29.18', '120.04');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '乐清', '28.08', '120.58');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '余杭', '30.26', '120.18');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '余姚', '30.02', '121.10');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '永康', '29.54', '120.01');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '舟山', '30.01', '122.06');
INSERT INTO `geocoord` VALUES ('', '', '浙江', '诸暨', '29.43', '120.14');
INSERT INTO `geocoord` VALUES ('', '', '重庆', '重庆', '29.35', '106.33');