全国各大城市坐标

我就是我 2023-10-05 19:06 39阅读 0赞

最近在做项目的时候要画地图 城市的坐标做个效果类似这样的效果从一个城市到另一个城市 让后找个城市的坐标 一下是整理的 sql文件直接导入就可以用

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70][]

全国各大城市坐标基本大城市的都包括了

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 1][]

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

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210204103705214.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20210204103831478.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw==,size_16,color_FFFFFF,t_70