信息技术地图：全国城市坐标数据库-CSDN博客

本文链接：https://blog.csdn.net/z13615480737/article/details/113626935
最近在做项目的时候要画地图城市的坐标做个效果类似这样的效果从一个城市到另一个城市让后找个城市的坐标一下是整理的 sql文件直接导入就可以用
全国各大城市坐标基本大城市的都包括了
sql文件
a_city_map

CREATE TABLE `a_city_map` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city` varchar(60) DEFAULT NULL COMMENT '城市',
  `mapx` varchar(20) DEFAULT NULL COMMENT 'mapx',
  `mapy` varchar(20) DEFAULT NULL COMMENT 'mapy',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=371 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of a_city_map
-- ----------------------------
INSERT INTO `a_city_map` VALUES ('1', '上海', '121.487899486', '31.24916171');
INSERT INTO `a_city_map` VALUES ('2', '临沧', '100.092612914', '23.8878061038');
INSERT INTO `a_city_map` VALUES ('3', '丽江', '100.229628399', '26.8753510895');
INSERT INTO `a_city_map` VALUES ('4', '保山', '99.1779956133', '25.1204891962');
INSERT INTO `a_city_map` VALUES ('5', '大理白族自治州', '100.223674789', '25.5968996394');
INSERT INTO `a_city_map` VALUES ('6', '德宏傣族景颇族自治州', '98.5894342874', '24.441239663');
INSERT INTO `a_city_map` VALUES ('7', '怒江傈僳族自治州', '98.8599320425', '25.8606769782');
INSERT INTO `a_city_map` VALUES ('8', '文山壮族苗族自治州', '104.246294318', '23.3740868504');
INSERT INTO `a_city_map` VALUES ('9', '昆明', '102.714601139', '25.0491531005');
INSERT INTO `a_city_map` VALUES ('10', '昭通', '103.725020656', '27.3406329636');
INSERT INTO `a_city_map` VALUES ('11', '普洱', '100.98005773', '22.7887777801');
INSERT INTO `a_city_map` VALUES ('12', '曲靖', '103.782538888', '25.5207581429');
INSERT INTO `a_city_map` VALUES ('13', '楚雄彝族自治州', '101.529382239', '25.0663556742');
INSERT INTO `a_city_map` VALUES ('14', '玉溪', '102.545067892', '24.3704471344');
INSERT INTO `a_city_map` VALUES ('15', '红河哈尼族彝族自治州', '103.384064757', '23.3677175165');
INSERT INTO `a_city_map` VALUES ('16', '西双版纳傣族自治州', '100.803038275', '22.0094330022');
INSERT INTO `a_city_map` VALUES ('17', '迪庆藏族自治州', '99.7136815989', '27.8310294612');
INSERT INTO `a_city_map` VALUES ('18', '乌兰察布', '113.112846391', '41.0223629468');
INSERT INTO `a_city_map` VALUES ('19', '乌海', '106.831999097', '39.6831770068');
INSERT INTO `a_city_map` VALUES ('20', '兴安盟', '122.048166514', '46.0837570652');
INSERT INTO `a_city_map` VALUES ('21', '包头', '109.846238532', '40.6471194257');
INSERT INTO `a_city_map` VALUES ('22', '呼伦贝尔', '119.760821794', '49.2016360546');
INSERT INTO `a_city_map` VALUES ('23', '呼和浩特', '111.66035052', '40.8283188731');
INSERT INTO `a_city_map` VALUES ('24', '巴彦淖尔', '107.42380672', '40.7691799024');
INSERT INTO `a_city_map` VALUES ('25', '赤峰', '118.930761192', '42.2971123203');
INSERT INTO `a_city_map` VALUES ('26', '通辽', '122.260363263', '43.633756073');
INSERT INTO `a_city_map` VALUES ('27', '鄂尔多斯', '109.993706251', '39.8164895606');
INSERT INTO `a_city_map` VALUES ('28', '锡林郭勒盟', '116.027339689', '43.9397048423');
INSERT INTO `a_city_map` VALUES ('29', '阿拉善盟', '105.695682871', '38.8430752644');
INSERT INTO `a_city_map` VALUES ('30', '北京', '116.395645038', '39.9299857781');
INSERT INTO `a_city_map` VALUES ('31', '台中', '119.337634104', '26.0911937119');
INSERT INTO `a_city_map` VALUES ('32', '台北', '114.130474436', '22.3748329286');
INSERT INTO `a_city_map` VALUES ('33', '台南', '121.360525873', '38.9658447898');
INSERT INTO `a_city_map` VALUES ('34', '嘉义', '114.246701335', '22.7288657203');
INSERT INTO `a_city_map` VALUES ('35', '高雄', '111.590952812', '21.9464822541');
INSERT INTO `a_city_map` VALUES ('36', '吉林', '126.564543989', '43.8719883344');
INSERT INTO `a_city_map` VALUES ('37', '四平', '124.391382074', '43.1755247011');
INSERT INTO `a_city_map` VALUES ('38', '延边朝鲜族自治州', '129.485901958', '42.8964136037');
INSERT INTO `a_city_map` VALUES ('39', '松原', '124.832994532', '45.1360489701');
INSERT INTO `a_city_map` VALUES ('40', '白城', '122.840776679', '45.6210862752');
INSERT INTO `a_city_map` VALUES ('41', '白山', '126.435797675', '41.945859397');
INSERT INTO `a_city_map` VALUES ('42', '辽源', '125.133686052', '42.9233026191');
INSERT INTO `a_city_map` VALUES ('43', '通化', '125.942650139', '41.7363971299');
INSERT INTO `a_city_map` VALUES ('44', '长春', '125.313642427', '43.8983376071');
INSERT INTO `a_city_map` VALUES ('45', '乐山', '103.760824239', '29.6009576111');
INSERT INTO `a_city_map` VALUES ('46', '内江', '105.073055992', '29.5994615348');
INSERT INTO `a_city_map` VALUES ('47', '凉山彝族自治州', '102.259590803', '27.8923929037');
INSERT INTO `a_city_map` VALUES ('48', '南充', '106.105553984', '30.8009651682');
INSERT INTO `a_city_map` VALUES ('49', '宜宾', '104.633019062', '28.7696747963');
INSERT INTO `a_city_map` VALUES ('50', '巴中', '106.757915842', '31.8691891592');
INSERT INTO `a_city_map` VALUES ('51', '广元', '105.81968694', '32.4410401584');
INSERT INTO `a_city_map` VALUES ('52', '广安', '106.635720331', '30.4639838879');
INSERT INTO `a_city_map` VALUES ('53', '德阳', '104.402397818', '31.1311396527');
INSERT INTO `a_city_map` VALUES ('54', '成都', '104.067923463', '30.6799428454');
INSERT INTO `a_city_map` VALUES ('55', '攀枝花', '101.722423152', '26.5875712571');
INSERT INTO `a_city_map` VALUES ('56', '泸州', '105.443970289', '28.8959298039');
INSERT INTO `a_city_map` VALUES ('57', '甘孜藏族自治州', '101.969232063', '30.0551441144');
INSERT INTO `a_city_map` VALUES ('58', '眉山', '103.841429563', '30.0611150799');
INSERT INTO `a_city_map` VALUES ('59', '绵阳', '104.705518975', '31.5047012581');
INSERT INTO `a_city_map` VALUES ('60', '自贡', '104.776071339', '29.3591568895');
INSERT INTO `a_city_map` VALUES ('61', '资阳', '104.635930302', '30.132191434');
INSERT INTO `a_city_map` VALUES ('62', '达州', '107.494973447', '31.2141988589');
INSERT INTO `a_city_map` VALUES ('63', '遂宁', '105.564887792', '30.5574913504');
INSERT INTO `a_city_map` VALUES ('64', '阿坝藏族羌族自治州', '102.228564689', '31.9057628583');
INSERT INTO `a_city_map` VALUES ('65', '雅安', '103.009356466', '29.9997163371');
INSERT INTO `a_city_map` VALUES ('66', '天津', '117.210813092', '39.1439299033');
INSERT INTO `a_city_map` VALUES ('67', '中卫', '105.196754199', '37.5211241916');
INSERT INTO `a_city_map` VALUES ('68', '吴忠', '106.208254199', '37.9935610029');
INSERT INTO `a_city_map` VALUES ('69', '固原', '106.285267996', '36.0215234807');
INSERT INTO `a_city_map` VALUES ('70', '石嘴山', '106.379337202', '39.0202232836');
INSERT INTO `a_city_map` VALUES ('71', '银川', '106.206478608', '38.5026210119');
INSERT INTO `a_city_map` VALUES ('72', '亳州', '115.787928245', '33.8712105653');
INSERT INTO `a_city_map` VALUES ('73', '六安', '116.505252683', '31.7555583552');
INSERT INTO `a_city_map` VALUES ('74', '合肥', '117.282699092', '31.8669422607');
INSERT INTO `a_city_map` VALUES ('75', '安庆', '117.058738772', '30.5378978174');
INSERT INTO `a_city_map` VALUES ('76', '宣城', '118.752096311', '30.9516423543');
INSERT INTO `a_city_map` VALUES ('77', '宿州', '116.988692412', '33.6367723858');
INSERT INTO `a_city_map` VALUES ('78', '池州', '117.494476772', '30.6600192482');
INSERT INTO `a_city_map` VALUES ('79', '淮北', '116.791447429', '33.9600233054');
INSERT INTO `a_city_map` VALUES ('80', '淮南', '117.018638863', '32.6428118237');
INSERT INTO `a_city_map` VALUES ('81', '滁州', '118.324570351', '32.3173505954');
INSERT INTO `a_city_map` VALUES ('82', '芜湖', '118.384108423', '31.3660197875');
INSERT INTO `a_city_map` VALUES ('83', '蚌埠', '117.357079866', '32.9294989067');
INSERT INTO `a_city_map` VALUES ('84', '铜陵', '117.819428729', '30.9409296947');
INSERT INTO `a_city_map` VALUES ('85', '阜阳', '115.820932259', '32.9012113306');
INSERT INTO `a_city_map` VALUES ('86', '马鞍山', '118.515881847', '31.6885281589');
INSERT INTO `a_city_map` VALUES ('87', '黄山', '118.293569632', '29.7344348562');
INSERT INTO `a_city_map` VALUES ('88', '东营', '118.583926333', '37.4871211553');
INSERT INTO `a_city_map` VALUES ('89', '临沂', '118.340768237', '35.0724090744');
INSERT INTO `a_city_map` VALUES ('90', '威海', '122.093958366', '37.5287870813');
INSERT INTO `a_city_map` VALUES ('91', '德州', '116.328161364', '37.4608259263');
INSERT INTO `a_city_map` VALUES ('92', '日照', '119.507179943', '35.4202251931');
INSERT INTO `a_city_map` VALUES ('93', '枣庄', '117.279305383', '34.8078830784');
INSERT INTO `a_city_map` VALUES ('94', '泰安', '117.089414917', '36.1880777589');
INSERT INTO `a_city_map` VALUES ('95', '济南', '117.024967066', '36.6827847272');
INSERT INTO `a_city_map` VALUES ('96', '济宁', '116.600797625', '35.4021216643');
INSERT INTO `a_city_map` VALUES ('97', '淄博', '118.059134278', '36.8046848542');
INSERT INTO `a_city_map` VALUES ('98', '滨州', '117.968292415', '37.4053139418');
INSERT INTO `a_city_map` VALUES ('99', '潍坊', '119.142633823', '36.7161148731');
INSERT INTO `a_city_map` VALUES ('100', '烟台', '121.30955503', '37.5365615629');
INSERT INTO `a_city_map` VALUES ('101', '聊城', '115.986869139', '36.4558285147');
INSERT INTO `a_city_map` VALUES ('102', '莱芜', '117.684666912', '36.2336541336');
INSERT INTO `a_city_map` VALUES ('103', '菏泽', '115.463359775', '35.2624404961');
INSERT INTO `a_city_map` VALUES ('104', '青岛', '120.384428184', '36.1052149013');
INSERT INTO `a_city_map` VALUES ('105', '临汾', '111.538787596', '36.0997454436');
INSERT INTO `a_city_map` VALUES ('106', '吕梁', '111.143156602', '37.527316097');
INSERT INTO `a_city_map` VALUES ('107', '大同', '113.290508673', '40.1137444997');
INSERT INTO `a_city_map` VALUES ('108', '太原', '112.550863589', '37.890277054');
INSERT INTO `a_city_map` VALUES ('109', '忻州', '112.727938829', '38.461030573');
INSERT INTO `a_city_map` VALUES ('110', '晋中', '112.7385144', '37.6933615268');
INSERT INTO `a_city_map` VALUES ('111', '晋城', '112.867332758', '35.4998344672');
INSERT INTO `a_city_map` VALUES ('112', '朔州', '112.479927727', '39.3376719662');
INSERT INTO `a_city_map` VALUES ('113', '运城', '111.006853653', '35.0388594798');
INSERT INTO `a_city_map` VALUES ('114', '长治', '113.120292086', '36.2016643857');
INSERT INTO `a_city_map` VALUES ('115', '阳泉', '113.569237602', '37.8695294932');
INSERT INTO `a_city_map` VALUES ('116', '东莞', '113.763433991', '23.0430238154');
INSERT INTO `a_city_map` VALUES ('117', '中山', '113.422060021', '22.5451775145');
INSERT INTO `a_city_map` VALUES ('118', '云浮', '112.050945959', '22.9379756855');
INSERT INTO `a_city_map` VALUES ('119', '佛山', '113.134025635', '23.0350948405');
INSERT INTO `a_city_map` VALUES ('120', '广州', '113.307649675', '23.1200491021');
INSERT INTO `a_city_map` VALUES ('121', '惠州', '114.41065808', '23.1135398524');
INSERT INTO `a_city_map` VALUES ('122', '揭阳', '116.379500855', '23.5479994669');
INSERT INTO `a_city_map` VALUES ('123', '梅州', '116.126403098', '24.304570606');
INSERT INTO `a_city_map` VALUES ('124', '汕头', '116.728650288', '23.3839084533');
INSERT INTO `a_city_map` VALUES ('125', '汕尾', '115.372924289', '22.7787305002');
INSERT INTO `a_city_map` VALUES ('126', '江门', '113.078125341', '22.5751167835');
INSERT INTO `a_city_map` VALUES ('127', '河源', '114.713721476', '23.7572508505');
INSERT INTO `a_city_map` VALUES ('128', '深圳', '114.025973657', '22.5460535462');
INSERT INTO `a_city_map` VALUES ('129', '清远', '113.040773349', '23.6984685504');
INSERT INTO `a_city_map` VALUES ('130', '湛江', '110.365067263', '21.2574631038');
INSERT INTO `a_city_map` VALUES ('131', '潮州', '116.630075991', '23.6618116765');
INSERT INTO `a_city_map` VALUES ('132', '珠海', '113.562447026', '22.2569146461');
INSERT INTO `a_city_map` VALUES ('133', '肇庆', '112.47965337', '23.0786632829');
INSERT INTO `a_city_map` VALUES ('134', '茂名', '110.931245331', '21.6682257188');
INSERT INTO `a_city_map` VALUES ('135', '阳江', '111.977009756', '21.8715173045');
INSERT INTO `a_city_map` VALUES ('136', '韶关', '113.594461107', '24.8029603119');
INSERT INTO `a_city_map` VALUES ('137', '北海', '109.122627919', '21.472718235');
INSERT INTO `a_city_map` VALUES ('138', '南宁', '108.297233556', '22.8064929356');
INSERT INTO `a_city_map` VALUES ('139', '崇左', '107.357322038', '22.4154552965');
INSERT INTO `a_city_map` VALUES ('140', '来宾', '109.231816505', '23.7411659265');
INSERT INTO `a_city_map` VALUES ('141', '柳州', '109.42240181', '24.3290533525');
INSERT INTO `a_city_map` VALUES ('142', '桂林', '110.260920147', '25.262901246');
INSERT INTO `a_city_map` VALUES ('143', '梧州', '111.30547195', '23.4853946367');
INSERT INTO `a_city_map` VALUES ('144', '河池', '108.069947709', '24.6995207829');
INSERT INTO `a_city_map` VALUES ('145', '玉林', '110.151676316', '22.6439736084');
INSERT INTO `a_city_map` VALUES ('146', '百色', '106.631821404', '23.9015123679');
INSERT INTO `a_city_map` VALUES ('147', '贵港', '109.613707557', '23.1033731644');
INSERT INTO `a_city_map` VALUES ('148', '贺州', '111.552594179', '24.4110535471');
INSERT INTO `a_city_map` VALUES ('149', '钦州', '108.638798056', '21.9733504653');
INSERT INTO `a_city_map` VALUES ('150', '防城港', '108.351791153', '21.6173984705');
INSERT INTO `a_city_map` VALUES ('151', '乌鲁木齐', '87.5649877411', '43.8403803472');
INSERT INTO `a_city_map` VALUES ('152', '伊犁哈萨克自治州', '81.2978535304', '43.9222480963');
INSERT INTO `a_city_map` VALUES ('153', '克孜勒苏柯尔克孜自治州', '76.1375644775', '39.7503455778');
INSERT INTO `a_city_map` VALUES ('154', '克拉玛依', '84.8811801861', '45.5943310667');
INSERT INTO `a_city_map` VALUES ('155', '博尔塔拉蒙古自治州', '82.0524362672', '44.9136513743');
INSERT INTO `a_city_map` VALUES ('156', '吐鲁番地区', '89.1815948657', '42.9604700169');
INSERT INTO `a_city_map` VALUES ('157', '和田地区', '79.9302386372', '37.1167744927');
INSERT INTO `a_city_map` VALUES ('158', '哈密地区', '93.5283550928', '42.8585963324');
INSERT INTO `a_city_map` VALUES ('159', '喀什地区', '75.9929732675', '39.4706271887');
INSERT INTO `a_city_map` VALUES ('160', '塔城地区', '82.9748805837', '46.7586836297');
INSERT INTO `a_city_map` VALUES ('161', '昌吉回族自治州', '87.2960381257', '44.0070578985');
INSERT INTO `a_city_map` VALUES ('162', '自治区直辖', '85.6148993383', '42.1270009576');
INSERT INTO `a_city_map` VALUES ('163', '阿克苏地区', '80.2698461793', '41.1717309015');
INSERT INTO `a_city_map` VALUES ('164', '阿勒泰地区', '88.1379154871', '47.8397444862');
INSERT INTO `a_city_map` VALUES ('165', '南京', '118.778074408', '32.0572355018');
INSERT INTO `a_city_map` VALUES ('166', '南通', '120.873800951', '32.0146645408');
INSERT INTO `a_city_map` VALUES ('167', '宿迁', '118.296893379', '33.9520497337');
INSERT INTO `a_city_map` VALUES ('168', '常州', '119.981861013', '31.7713967447');
INSERT INTO `a_city_map` VALUES ('169', '徐州', '117.188106623', '34.2715534311');
INSERT INTO `a_city_map` VALUES ('170', '扬州', '119.427777551', '32.4085052546');
INSERT INTO `a_city_map` VALUES ('171', '无锡', '120.305455901', '31.5700374519');
INSERT INTO `a_city_map` VALUES ('172', '泰州', '119.919606016', '32.4760532748');
INSERT INTO `a_city_map` VALUES ('173', '淮安', '119.030186365', '33.6065127393');
INSERT INTO `a_city_map` VALUES ('174', '盐城', '120.148871818', '33.3798618771');
INSERT INTO `a_city_map` VALUES ('175', '苏州', '120.619907115', '31.317987368');
INSERT INTO `a_city_map` VALUES ('176', '连云港', '119.173872217', '34.601548967');
INSERT INTO `a_city_map` VALUES ('177', '镇江', '119.455835405', '32.2044094436');
INSERT INTO `a_city_map` VALUES ('178', '上饶', '117.955463877', '28.4576225539');
INSERT INTO `a_city_map` VALUES ('179', '九江', '115.999848022', '29.7196395261');
INSERT INTO `a_city_map` VALUES ('180', '南昌', '115.893527546', '28.6895780001');
INSERT INTO `a_city_map` VALUES ('181', '吉安', '114.992038711', '27.1138476502');
INSERT INTO `a_city_map` VALUES ('182', '宜春', '114.400038672', '27.8111298958');
INSERT INTO `a_city_map` VALUES ('183', '抚州', '116.360918867', '27.9545451703');
INSERT INTO `a_city_map` VALUES ('184', '新余', '114.947117417', '27.8223215586');
INSERT INTO `a_city_map` VALUES ('185', '景德镇', '117.186522625', '29.3035627684');
INSERT INTO `a_city_map` VALUES ('186', '萍乡', '113.859917033', '27.639544223');
INSERT INTO `a_city_map` VALUES ('187', '赣州', '114.935909079', '25.8452955363');
INSERT INTO `a_city_map` VALUES ('188', '鹰潭', '117.035450186', '28.2413095972');
INSERT INTO `a_city_map` VALUES ('189', '保定', '115.494810169', '38.886564548');
INSERT INTO `a_city_map` VALUES ('190', '唐山', '118.183450598', '39.6505309225');
INSERT INTO `a_city_map` VALUES ('191', '廊坊', '116.703602223', '39.5186106251');
INSERT INTO `a_city_map` VALUES ('192', '张家口', '114.89378153', '40.8111884911');
INSERT INTO `a_city_map` VALUES ('193', '承德', '117.933822456', '40.9925210525');
INSERT INTO `a_city_map` VALUES ('194', '沧州', '116.863806476', '38.2976153503');
INSERT INTO `a_city_map` VALUES ('195', '石家庄', '114.522081844', '38.0489583146');
INSERT INTO `a_city_map` VALUES ('196', '秦皇岛', '119.604367616', '39.9454615659');
INSERT INTO `a_city_map` VALUES ('197', '衡水', '115.686228653', '37.7469290459');
INSERT INTO `a_city_map` VALUES ('198', '邢台', '114.520486813', '37.0695311969');
INSERT INTO `a_city_map` VALUES ('199', '邯郸', '114.482693932', '36.6093079285');
INSERT INTO `a_city_map` VALUES ('200', '三门峡', '111.181262093', '34.7833199411');
INSERT INTO `a_city_map` VALUES ('201', '信阳', '114.085490993', '32.1285823075');
INSERT INTO `a_city_map` VALUES ('202', '南阳', '112.542841901', '33.0114195691');
INSERT INTO `a_city_map` VALUES ('203', '周口', '114.654101942', '33.6237408181');
INSERT INTO `a_city_map` VALUES ('204', '商丘', '115.641885688', '34.4385886402');
INSERT INTO `a_city_map` VALUES ('205', '安阳', '114.351806508', '36.1102667222');
INSERT INTO `a_city_map` VALUES ('206', '平顶山', '113.300848978', '33.7453014565');
INSERT INTO `a_city_map` VALUES ('207', '开封', '114.351642118', '34.8018541758');
INSERT INTO `a_city_map` VALUES ('208', '新乡', '113.912690161', '35.3072575577');
INSERT INTO `a_city_map` VALUES ('209', '洛阳', '112.447524769', '34.6573678177');
INSERT INTO `a_city_map` VALUES ('210', '漯河', '114.0460614', '33.5762786885');
INSERT INTO `a_city_map` VALUES ('211', '濮阳', '115.026627441', '35.7532978882');
INSERT INTO `a_city_map` VALUES ('212', '焦作', '113.211835885', '35.234607555');
INSERT INTO `a_city_map` VALUES ('213', '省直辖', '112.410562192', '31.2093162501');
INSERT INTO `a_city_map` VALUES ('214', '许昌', '113.83531246', '34.0267395887');
INSERT INTO `a_city_map` VALUES ('215', '郑州', '113.64964385', '34.7566100641');
INSERT INTO `a_city_map` VALUES ('216', '驻马店', '114.049153547', '32.9831581541');
INSERT INTO `a_city_map` VALUES ('217', '鹤壁', '114.297769838', '35.7554258742');
INSERT INTO `a_city_map` VALUES ('218', '丽水', '119.929575843', '28.4562995521');
INSERT INTO `a_city_map` VALUES ('219', '台州', '121.440612936', '28.6682832857');
INSERT INTO `a_city_map` VALUES ('220', '嘉兴', '120.760427699', '30.7739922396');
INSERT INTO `a_city_map` VALUES ('221', '宁波', '121.579005973', '29.8852589659');
INSERT INTO `a_city_map` VALUES ('222', '杭州', '120.219375416', '30.2592444615');
INSERT INTO `a_city_map` VALUES ('223', '温州', '120.690634734', '28.002837594');
INSERT INTO `a_city_map` VALUES ('224', '湖州', '120.137243163', '30.8779251557');
INSERT INTO `a_city_map` VALUES ('225', '绍兴', '120.592467386', '30.0023645805');
INSERT INTO `a_city_map` VALUES ('226', '舟山', '122.169872098', '30.0360103026');
INSERT INTO `a_city_map` VALUES ('227', '衢州', '118.875841652', '28.9569104475');
INSERT INTO `a_city_map` VALUES ('228', '金华', '119.652575704', '29.1028991054');
INSERT INTO `a_city_map` VALUES ('229', '三亚', '109.522771281', '18.2577759149');
INSERT INTO `a_city_map` VALUES ('230', '三沙', '112.350383075', '16.840062894');
INSERT INTO `a_city_map` VALUES ('231', '海口', '110.330801848', '20.022071277');
INSERT INTO `a_city_map` VALUES ('232', '十堰', '110.801228917', '32.6369943395');
INSERT INTO `a_city_map` VALUES ('233', '咸宁', '114.300060592', '29.8806567577');
INSERT INTO `a_city_map` VALUES ('234', '孝感', '113.935734392', '30.9279547842');
INSERT INTO `a_city_map` VALUES ('235', '宜昌', '111.310981092', '30.732757818');
INSERT INTO `a_city_map` VALUES ('236', '恩施土家族苗族自治州', '109.491923304', '30.2858883166');
INSERT INTO `a_city_map` VALUES ('237', '武汉', '114.316200103', '30.5810841269');
INSERT INTO `a_city_map` VALUES ('238', '荆州', '112.241865807', '30.332590523');
INSERT INTO `a_city_map` VALUES ('239', '荆门', '112.217330299', '31.0426112029');
INSERT INTO `a_city_map` VALUES ('240', '襄阳', '112.250092848', '32.2291685915');
INSERT INTO `a_city_map` VALUES ('241', '鄂州', '114.895594041', '30.3844393228');
INSERT INTO `a_city_map` VALUES ('242', '随州', '113.379358364', '31.7178576082');
INSERT INTO `a_city_map` VALUES ('243', '黄冈', '114.906618047', '30.4461089379');
INSERT INTO `a_city_map` VALUES ('244', '黄石', '115.050683164', '30.2161271277');
INSERT INTO `a_city_map` VALUES ('245', '娄底', '111.996396357', '27.7410733023');
INSERT INTO `a_city_map` VALUES ('246', '岳阳', '113.146195519', '29.3780070755');
INSERT INTO `a_city_map` VALUES ('247', '常德', '111.653718137', '29.0121488552');
INSERT INTO `a_city_map` VALUES ('248', '张家界', '110.481620157', '29.1248893532');
INSERT INTO `a_city_map` VALUES ('249', '怀化', '109.986958796', '27.5574829012');
INSERT INTO `a_city_map` VALUES ('250', '株洲', '113.131695341', '27.8274329277');
INSERT INTO `a_city_map` VALUES ('251', '永州', '111.614647686', '26.4359716468');
INSERT INTO `a_city_map` VALUES ('252', '湘潭', '112.935555633', '27.835095053');
INSERT INTO `a_city_map` VALUES ('253', '湘西土家族苗族自治州', '109.7457458', '28.3179507937');
INSERT INTO `a_city_map` VALUES ('254', '益阳', '112.366546645', '28.5880877799');
INSERT INTO `a_city_map` VALUES ('255', '衡阳', '112.583818811', '26.8981644154');
INSERT INTO `a_city_map` VALUES ('256', '邵阳', '111.461525404', '27.2368112449');
INSERT INTO `a_city_map` VALUES ('257', '郴州', '113.037704468', '25.7822639757');
INSERT INTO `a_city_map` VALUES ('258', '长沙', '112.979352788', '28.2134782309');
INSERT INTO `a_city_map` VALUES ('259', '无堂区划分区域', '113.557519102', '22.2041179884');
INSERT INTO `a_city_map` VALUES ('260', '澳门半岛', '113.566432335', '22.1950041592');
INSERT INTO `a_city_map` VALUES ('261', '澳门离岛', '113.557519102', '22.2041179884');
INSERT INTO `a_city_map` VALUES ('262', '临夏回族自治州', '103.215249178', '35.5985143488');
INSERT INTO `a_city_map` VALUES ('263', '兰州', '103.823305441', '36.064225525');
INSERT INTO `a_city_map` VALUES ('264', '嘉峪关', '98.2816345853', '39.8023973267');
INSERT INTO `a_city_map` VALUES ('265', '天水', '105.736931623', '34.5843194189');
INSERT INTO `a_city_map` VALUES ('266', '定西', '104.626637601', '35.5860562418');
INSERT INTO `a_city_map` VALUES ('267', '平凉', '106.688911157', '35.55011019');
INSERT INTO `a_city_map` VALUES ('268', '庆阳', '107.644227087', '35.7268007545');
INSERT INTO `a_city_map` VALUES ('269', '张掖', '100.459891869', '38.939320297');
INSERT INTO `a_city_map` VALUES ('270', '武威', '102.640147343', '37.9331721429');
INSERT INTO `a_city_map` VALUES ('271', '甘南藏族自治州', '102.917442486', '34.9922111784');
INSERT INTO `a_city_map` VALUES ('272', '白银', '104.171240904', '36.5466817062');
INSERT INTO `a_city_map` VALUES ('273', '酒泉', '98.5084145062', '39.7414737682');
INSERT INTO `a_city_map` VALUES ('274', '金昌', '102.208126263', '38.5160717995');
INSERT INTO `a_city_map` VALUES ('275', '陇南', '104.934573406', '33.3944799729');
INSERT INTO `a_city_map` VALUES ('276', '三明', '117.642193934', '26.2708352794');
INSERT INTO `a_city_map` VALUES ('277', '南平', '118.181882949', '26.6436264742');
INSERT INTO `a_city_map` VALUES ('278', '厦门', '118.103886046', '24.4892306125');
INSERT INTO `a_city_map` VALUES ('279', '宁德', '119.54208215', '26.6565274192');
INSERT INTO `a_city_map` VALUES ('280', '泉州', '118.600362343', '24.901652384');
INSERT INTO `a_city_map` VALUES ('281', '漳州', '117.676204679', '24.5170647798');
INSERT INTO `a_city_map` VALUES ('282', '福州', '119.330221107', '26.0471254966');
INSERT INTO `a_city_map` VALUES ('283', '莆田', '119.077730964', '25.4484501367');
INSERT INTO `a_city_map` VALUES ('284', '龙岩', '117.017996739', '25.0786854335');
INSERT INTO `a_city_map` VALUES ('285', '山南地区', '91.7506438744', '29.2290269317');
INSERT INTO `a_city_map` VALUES ('286', '拉萨', '91.111890896', '29.6625570621');
INSERT INTO `a_city_map` VALUES ('287', '日喀则地区', '88.8914855677', '29.2690232039');
INSERT INTO `a_city_map` VALUES ('288', '昌都地区', '97.18558158', '31.1405756319');
INSERT INTO `a_city_map` VALUES ('289', '林芝地区', '94.3499854582', '29.6669406258');
INSERT INTO `a_city_map` VALUES ('290', '那曲地区', '92.0670183689', '31.4806798301');
INSERT INTO `a_city_map` VALUES ('291', '阿里地区', '81.1076686895', '30.4045565883');
INSERT INTO `a_city_map` VALUES ('292', '六盘水', '104.85208676', '26.5918660603');
INSERT INTO `a_city_map` VALUES ('293', '安顺', '105.928269966', '26.2285945777');
INSERT INTO `a_city_map` VALUES ('294', '毕节', '105.333323371', '27.4085621313');
INSERT INTO `a_city_map` VALUES ('295', '贵阳', '106.709177096', '26.6299067414');
INSERT INTO `a_city_map` VALUES ('296', '遵义', '106.931260316', '27.6999613771');
INSERT INTO `a_city_map` VALUES ('297', '铜仁', '109.168558028', '27.6749026906');
INSERT INTO `a_city_map` VALUES ('298', '黔东南苗族侗族自治州', '107.985352573', '26.5839917665');
INSERT INTO `a_city_map` VALUES ('299', '黔南布依族苗族自治州', '107.52320511', '26.2645359974');
INSERT INTO `a_city_map` VALUES ('300', '黔西南布依族苗族自治州', '104.900557798', '25.0951480559');
INSERT INTO `a_city_map` VALUES ('301', '丹东', '124.338543115', '40.1290228266');
INSERT INTO `a_city_map` VALUES ('302', '大连', '121.593477781', '38.9487099383');
INSERT INTO `a_city_map` VALUES ('303', '抚顺', '123.929819767', '41.8773038296');
INSERT INTO `a_city_map` VALUES ('304', '朝阳', '120.446162703', '41.5718276679');
INSERT INTO `a_city_map` VALUES ('305', '本溪', '123.77806237', '41.3258376266');
INSERT INTO `a_city_map` VALUES ('306', '沈阳', '123.432790922', '41.8086447835');
INSERT INTO `a_city_map` VALUES ('307', '盘锦', '122.07322781', '41.141248023');
INSERT INTO `a_city_map` VALUES ('308', '营口', '122.233391371', '40.6686510665');
INSERT INTO `a_city_map` VALUES ('309', '葫芦岛', '120.860757645', '40.7430298813');
INSERT INTO `a_city_map` VALUES ('310', '辽阳', '123.172451205', '41.2733392656');
INSERT INTO `a_city_map` VALUES ('311', '铁岭', '123.854849615', '42.2997570121');
INSERT INTO `a_city_map` VALUES ('312', '锦州', '121.147748738', '41.1308788759');
INSERT INTO `a_city_map` VALUES ('313', '阜新', '121.660822129', '42.0192501071');
INSERT INTO `a_city_map` VALUES ('314', '鞍山', '123.007763329', '41.1187436822');
INSERT INTO `a_city_map` VALUES ('315', '重庆', '106.530635013', '29.5446061089');
INSERT INTO `a_city_map` VALUES ('316', '咸阳', '108.707509278', '34.345372996');
INSERT INTO `a_city_map` VALUES ('317', '商洛', '109.934208154', '33.8739073951');
INSERT INTO `a_city_map` VALUES ('318', '安康', '109.038044563', '32.70437045');
INSERT INTO `a_city_map` VALUES ('319', '宝鸡', '107.170645452', '34.3640808097');
INSERT INTO `a_city_map` VALUES ('320', '延安', '109.500509757', '36.6033203523');
INSERT INTO `a_city_map` VALUES ('321', '榆林', '109.745925744', '38.2794392401');
INSERT INTO `a_city_map` VALUES ('322', '汉中', '107.045477629', '33.0815689782');
INSERT INTO `a_city_map` VALUES ('323', '渭南', '109.483932697', '34.5023579758');
INSERT INTO `a_city_map` VALUES ('324', '西安', '108.953098279', '34.2777998978');
INSERT INTO `a_city_map` VALUES ('325', '铜川', '108.968067013', '34.9083676964');
INSERT INTO `a_city_map` VALUES ('326', '果洛藏族自治州', '100.223722769', '34.4804845846');
INSERT INTO `a_city_map` VALUES ('327', '海东地区', '102.085206987', '36.5176101677');
INSERT INTO `a_city_map` VALUES ('328', '海北藏族自治州', '100.879802174', '36.9606541011');
INSERT INTO `a_city_map` VALUES ('329', '海南藏族自治州', '100.624066094', '36.2843638038');
INSERT INTO `a_city_map` VALUES ('330', '海西蒙古族藏族自治州', '97.3426254153', '37.3737990706');
INSERT INTO `a_city_map` VALUES ('331', '玉树藏族自治州', '97.0133161374', '33.0062399097');
INSERT INTO `a_city_map` VALUES ('332', '西宁', '101.76792099', '36.640738612');
INSERT INTO `a_city_map` VALUES ('333', '黄南藏族自治州', '102.007600308', '35.5228515517');
INSERT INTO `a_city_map` VALUES ('334', '九龙', '114.173291988', '22.3072458588');
INSERT INTO `a_city_map` VALUES ('335', '新界', '114.146701965', '22.4274312754');
INSERT INTO `a_city_map` VALUES ('336', '香港岛', '114.183870524', '22.2721034276');
INSERT INTO `a_city_map` VALUES ('337', '七台河', '131.019048047', '45.7750053686');
INSERT INTO `a_city_map` VALUES ('338', '伊春', '128.910765978', '47.7346850751');
INSERT INTO `a_city_map` VALUES ('339', '佳木斯', '130.284734586', '46.8137796047');
INSERT INTO `a_city_map` VALUES ('340', '双鸭山', '131.17140174', '46.6551020625');
INSERT INTO `a_city_map` VALUES ('341', '哈尔滨', '126.657716855', '45.7732246332');
INSERT INTO `a_city_map` VALUES ('342', '大兴安岭地区', '124.19610419', '51.991788968');
INSERT INTO `a_city_map` VALUES ('343', '大庆', '125.02183973', '46.59670902');
INSERT INTO `a_city_map` VALUES ('344', '牡丹江', '129.608035396', '44.5885211528');
INSERT INTO `a_city_map` VALUES ('345', '绥化', '126.989094572', '46.646063927');
INSERT INTO `a_city_map` VALUES ('346', '鸡西', '130.941767273', '45.3215398866');
INSERT INTO `a_city_map` VALUES ('347', '鹤岗', '130.292472051', '47.3386659037');
INSERT INTO `a_city_map` VALUES ('348', '黑河', '127.500830295', '50.2506900907');
INSERT INTO `a_city_map` VALUES ('349', '齐齐哈尔', '123.987288942', '47.3476998134');
INSERT INTO `a_city_map` VALUES ('350', '宁夏回族自治区', '106.27', '38.47');
INSERT INTO `a_city_map` VALUES ('351', '丰镇', '113.12752', '40.448834');
INSERT INTO `a_city_map` VALUES ('352', '东兴', '107.977001', '21.553547');
INSERT INTO `a_city_map` VALUES ('353', '临夏', '103.213515', '35.593475');
INSERT INTO `a_city_map` VALUES ('354', '乌兰浩特', '122.06858', '6.077054');
INSERT INTO `a_city_map` VALUES ('355', '乐平', '117.159664', '28.98133');
INSERT INTO `a_city_map` VALUES ('356', '二连浩特', '111.966991', '43.65214');
INSERT INTO `a_city_map` VALUES ('357', '仙桃', '113.47088', '30.36251');
INSERT INTO `a_city_map` VALUES ('358', '儋州', '109.563314', '19.5266');
INSERT INTO `a_city_map` VALUES ('359', '塔河', '105.0048', '25.171387');
INSERT INTO `a_city_map` VALUES ('360', '密云', '116.912792', '40.414263');
INSERT INTO `a_city_map` VALUES ('361', '巢湖', '117.913395', '31.632446');
INSERT INTO `a_city_map` VALUES ('362', '巴音郭楞蒙古自治州', '86.163209', '41.778463');
INSERT INTO `a_city_map` VALUES ('363', '广东', '86.163209', '41.778463');
INSERT INTO `a_city_map` VALUES ('364', '敦煌', '94.798459', '40.173892');
INSERT INTO `a_city_map` VALUES ('365', '新疆维吾尔自治区', '94.798459', '40.173892');
INSERT INTO `a_city_map` VALUES ('366', '白沙黎族自治县', '109.433325', '19.238479');
INSERT INTO `a_city_map` VALUES ('367', '石河子', '85.951785', '44.263243');
INSERT INTO `a_city_map` VALUES ('368', '诸暨', '120.270083', '29.712426');
INSERT INTO `a_city_map` VALUES ('369', '贵溪', '117.221049', '28.296127');
INSERT INTO `a_city_map` VALUES ('370', '都江堰', '103.645202', '30.99602');