CREATE TABLE 'city' (
'province' varchar(20) NOT NULL,
'city' varchar(20) NOT NULL,
'N' varchar(20) NOT NULL,
'E' varchar(20) NOT NULL
) ;
-- ----------------------------
INSERT INTO 'city' VALUES ('安徽省', '合肥', '31.52', '117.17');
INSERT INTO 'city' VALUES ('安徽省', '安庆', '30.31', '117.02');
INSERT INTO 'city' VALUES ('安徽省', '蚌埠', '32.56', '117.21');
INSERT INTO 'city' VALUES ('安徽省', '亳州', '33.52', '115.47');
INSERT INTO 'city' VALUES ('安徽省', '巢湖', '31.36', '117.52');
INSERT INTO 'city' VALUES ('安徽省', '滁州', '32.18', '118.18');
INSERT INTO 'city' VALUES ('安徽省', '阜阳', '32.54', '115.48');
INSERT INTO 'city' VALUES ('安徽省', '贵池', '30.39', '117.28');
INSERT INTO 'city' VALUES ('安徽省', '淮北', '33.57', '116.47');
INSERT INTO 'city' VALUES ('安徽省', '淮南', '32.37', '116.58');
INSERT INTO 'city' VALUES ('安徽省', '黄山', '29.43', '118.18');
INSERT INTO 'city' VALUES ('安徽省', '界首', '33.15', '115.21');
INSERT INTO 'city' VALUES ('安徽省', '六安', '31.44', '116.28');
INSERT INTO 'city' VALUES ('安徽省', '马鞍山', '31.43', '118.28');
INSERT INTO 'city' VALUES ('安徽省', '明光', '32.47', '117.58');
INSERT INTO 'city' VALUES ('安徽省', '宿州', '33.38', '116.58');
INSERT INTO 'city' VALUES ('安徽省', '天长', '32.41', '118.59');
INSERT INTO 'city' VALUES ('安徽省', '铜陵', '30.56', '117.48');
INSERT INTO 'city' VALUES ('安徽省', '芜湖', '31.19', '118.22');
INSERT INTO 'city' VALUES ('安徽省', '宣州', '30.57', '118.44');
INSERT INTO 'city' VALUES ('澳门', '澳门市', '21.33', '115.07');
INSERT INTO 'city' VALUES ('北京市', '北京市', '39.55', '116.24');
INSERT INTO 'city' VALUES ('福建省', '福州', '26.05', '119.18');
INSERT INTO 'city' VALUES ('福建省', '长乐', '25.58', '119.31');
INSERT INTO 'city' VALUES ('福建省', '福安', '27.06', '119.39');
INSERT INTO 'city' VALUES ('福建省', '福清', '25.42', '119.23');
INSERT INTO 'city' VALUES ('福建省', '建瓯', '27.03', '118.2');
INSERT INTO 'city' VALUES ('福建省', '建阳', '27.21', '118.07');
INSERT INTO 'city' VALUES ('福建省', '晋江', '24.49', '118.35');
INSERT INTO 'city' VALUES ('福建省', '龙海', '24.26', '117.48');
INSERT INTO 'city' VALUES ('福建省', '龙岩', '25.06', '117.01');
INSERT INTO 'city' VALUES ('福建省', '南安', '24.57', '118.23');
INSERT INTO 'city' VALUES ('福建省', '南平', '26.38', '118.1');
INSERT INTO 'city' VALUES ('福建省', '宁德', '26.39', '119.31');
INSERT INTO 'city' VALUES ('福建省', '莆田', '24.26', '119.01');
INSERT INTO 'city' VALUES ('福建省', '泉州', '24.56', '118.36');
INSERT INTO 'city' VALUES ('福建省', '三明', '26.13', '117.36');
INSERT INTO 'city' VALUES ('福建省', '邵武', '27.2', '117.29');
INSERT INTO 'city' VALUES ('福建省', '石狮', '24.44', '118.38');
INSERT INTO 'city' VALUES ('福建省', '武夷山', '27.46', '118.02');
INSERT INTO 'city' VALUES ('福建省', '厦门', '24.27', '118.06');
INSERT INTO 'city' VALUES ('福建省', '永安', '25.58', '117.23');
INSERT INTO 'city' VALUES ('福建省', '漳平', '25.17', '117.24');
INSERT INTO 'city' VALUES ('福建省', '漳州', '24.31', '117.39');
INSERT INTO 'city' VALUES ('甘肃省', '兰州', '36.04', '103.51');
INSERT INTO 'city' VALUES ('甘肃省', '白银', '36.33', '104.12');
INSERT INTO 'city' VALUES ('甘肃省', '敦煌', '40.08', '94.41');
INSERT INTO 'city' VALUES ('甘肃省', '嘉峪关', '39.48', '98.14');
INSERT INTO 'city' VALUES ('甘肃省', '金昌', '38.28', '102.1');
INSERT INTO 'city' VALUES ('甘肃省', '酒泉', '39.44', '98.31');
INSERT INTO 'city' VALUES ('甘肃省', '临夏', '35.37', '103.12');
INSERT INTO 'city' VALUES ('甘肃省', '平凉', '35.32', '106.4');
INSERT INTO 'city' VALUES ('甘肃省', '天水', '34.37', '105.42');
INSERT INTO 'city' VALUES ('甘肃省', '武威', '37.56', '102.39');
INSERT INTO 'city' VALUES ('甘肃省', '西峰', '35.45', '107.4');
INSERT INTO 'city' VALUES ('甘肃省', '玉门', '39.49', '97.35');
INSERT INTO 'city' VALUES ('甘肃省', '张掖', '38.56', '100.26');
INSERT INTO 'city' VALUES ('广东省', '广州', '23.08', '113.14');
INSERT INTO 'city' VALUES ('广东省', '潮阳', '23.16', '116.36');
INSERT INTO 'city' VALUES ('广东省', '潮州', '23.4', '116.38');
INSERT INTO 'city' VALUES ('广东省', '澄海', '23.28', '116.46');
INSERT INTO 'city' VALUES ('广东省', '从化', '23.33', '113.33');
INSERT INTO 'city' VALUES ('广东省', '东莞', '23.02', '113.45');
INSERT INTO 'city' VALUES ('广东省', '恩平', '22.12', '112.19');
INSERT INTO 'city' VALUES ('广东省', '佛山', '23.02', '113.06');
INSERT INTO 'city' VALUES ('广东省', '高明', '22.53', '112.5');
INSERT INTO 'city' VALUES ('广东省', '高要', '23.02', '112.26');
INSERT INTO 'city' VALUES ('广东省', '高州', '21.54', '110.5');
INSERT INTO 'city' VALUES ('广东省', '鹤山', '22.46', '112.57');
INSERT INTO 'city' VALUES ('广东省', '河源', '23.43', '114.41');
INSERT INTO 'city' VALUES ('广东省', '花都', '23.23', '113.12');
INSERT INTO 'city' VALUES ('广东省', '化州', '21.39', '110.37');
INSERT INTO 'city' VALUES ('广东省', '惠阳', '22.48', '114.28');
INSERT INTO 'city' VALUES ('广东省', '惠州', '23.05', '114.22');
INSERT INTO 'city' VALUES ('广东省', '江门', '22.35', '113.04');
INSERT INTO 'city' VALUES ('广东省', '揭阳', '22.32', '116.21');
INSERT INTO 'city' VALUES ('广东省', '开平', '22.22', '112.4');
INSERT INTO 'city' VALUES ('广东省', '乐昌', '25.09', '113.21');
INSERT INTO 'city' VALUES ('广东省', '雷州', '20.54', '110.04');
INSERT INTO 'city' VALUES ('广东省', '廉江', '21.37', '110.17');
INSERT INTO 'city' VALUES ('广东省', '连州', '24.48', '112.23');
INSERT INTO 'city' VALUES ('广东省', '罗定', '22.46', '111.33');
INSERT INTO 'city' VALUES ('广东省', '茂名', '21.4', '110.53');
INSERT INTO 'city' VALUES ('广东省', '梅州', '24.19', '116.07');
INSERT INTO 'city' VALUES ('广东省', '南海', '23.01', '113.09');
INSERT INTO 'city' VALUES ('广东省', '番禺', '22.57', '113.22');
INSERT INTO 'city' VALUES ('广东省', '普宁', '23.18', '116.1');
INSERT INTO 'city' VALUES ('广东省', '清远', '23.42', '113.01');
INSERT INTO 'city' VALUES ('广东省', '三水', '23.1', '112.52');
INSERT INTO 'city' VALUES ('广东省', '汕头', '23.22', '116.41');
INSERT INTO 'city' VALUES ('广东省', '汕尾', '22.47', '115.21');
INSERT INTO 'city' VALUES ('广东省', '韶关', '24.48', '113.37');
INSERT INTO 'city' VALUES ('广东省', '深圳', '22.33', '114.07');
INSERT INTO 'city' VALUES ('广东省', '顺德', '22.5', '113.15');
INSERT INTO 'city' VALUES ('广东省', '四会', '23.21', '112.41');
INSERT INTO 'city' VALUES ('广东省', '台山', '22.15', '112.48');
INSERT INTO 'city' VALUES ('广东省', '吴川', '21.26', '110.47');
INSERT INTO 'city' VALUES ('广东省', '新会', '22.32', '113.01');
INSERT INTO 'city' VALUES ('广东省', '兴宁', '24.09', '115.43');
INSERT INTO 'city' VALUES ('广东省', '阳春', '22.1', '111.48');
INSERT INTO 'city' VALUES ('广东省', '阳江', '21.5', '111.58');
INSERT INTO 'city' VALUES ('广东省', '英德', '24.1', '113.22');
INSERT INTO 'city' VALUES ('广东省', '云浮', '22.57', '112.02');
INSERT INTO 'city' VALUES ('广东省', '增城', '23.18', '113.49');
INSERT INTO 'city' VALUES ('广东省', '湛江', '21.11', '110.24');
INSERT INTO 'city' VALUES ('广东省', '肇庆', '23.03', '112.27');
INSERT INTO 'city' VALUES ('广东省', '中山', '22.31', '113.22');
INSERT INTO 'city' VALUES ('广东省', '珠海', '22.17', '113.34');
INSERT INTO 'city' VALUES ('广西自治区', '南宁', '22.48', '108.19');
INSERT INTO 'city' VALUES ('广西自治区', '北海', '21.28', '109.0
