t_sys_city.sql 67 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : 127.0.0.1_3306
  4. Source Server Version : 50725
  5. Source Host : 127.0.0.1:3306
  6. Source Database : gyee
  7. Target Server Type : MYSQL
  8. Target Server Version : 50725
  9. File Encoding : 65001
  10. Date: 2019-10-05 01:42:59
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for t_sys_city
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `t_sys_city`;
  17. CREATE TABLE `t_sys_city` (
  18. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
  19. `city_code` varchar(40) NOT NULL COMMENT '市代码',
  20. `city_name` varchar(40) NOT NULL COMMENT '市名称',
  21. `short_name` varchar(20) NOT NULL COMMENT '简称',
  22. `province_code` varchar(40) DEFAULT NULL COMMENT '省代码',
  23. `lng` varchar(20) DEFAULT NULL COMMENT '经度',
  24. `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
  25. `sort` int(6) DEFAULT NULL COMMENT '排序',
  26. `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  27. `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
  28. `memo` varchar(250) DEFAULT NULL COMMENT '备注',
  29. `data_state` int(11) DEFAULT NULL COMMENT '状态',
  30. PRIMARY KEY (`id`),
  31. KEY `Index_1` (`city_code`)
  32. ) ENGINE=InnoDB AUTO_INCREMENT=391 DEFAULT CHARSET=utf8 COMMENT='城市设置';
  33. -- ----------------------------
  34. -- Records of t_sys_city
  35. -- ----------------------------
  36. INSERT INTO `t_sys_city` VALUES ('1', '110100', '北京市', '北京', '110000', '116.405289', '39.904987', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  37. INSERT INTO `t_sys_city` VALUES ('2', '120100', '天津市', '天津', '120000', '117.190186', '39.125595', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  38. INSERT INTO `t_sys_city` VALUES ('3', '130100', '石家庄市', '石家庄', '130000', '114.502464', '38.045475', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  39. INSERT INTO `t_sys_city` VALUES ('4', '130200', '唐山市', '唐山', '130000', '118.175392', '39.635113', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  40. INSERT INTO `t_sys_city` VALUES ('5', '130300', '秦皇岛市', '秦皇岛', '130000', '119.586578', '39.942532', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  41. INSERT INTO `t_sys_city` VALUES ('6', '130400', '邯郸市', '邯郸', '130000', '114.490685', '36.612274', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  42. INSERT INTO `t_sys_city` VALUES ('7', '130500', '邢台市', '邢台', '130000', '114.50885', '37.068199', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  43. INSERT INTO `t_sys_city` VALUES ('8', '130600', '保定市', '保定', '130000', '115.48233', '38.867657', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  44. INSERT INTO `t_sys_city` VALUES ('9', '130700', '张家口市', '张家口', '130000', '114.884094', '40.811901', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  45. INSERT INTO `t_sys_city` VALUES ('10', '130800', '承德市', '承德', '130000', '117.939156', '40.976204', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  46. INSERT INTO `t_sys_city` VALUES ('11', '130900', '沧州市', '沧州', '130000', '116.85746', '38.310581', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  47. INSERT INTO `t_sys_city` VALUES ('12', '131000', '廊坊市', '廊坊', '130000', '116.704437', '39.523926', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  48. INSERT INTO `t_sys_city` VALUES ('13', '131100', '衡水市', '衡水', '130000', '115.665993', '37.735096', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  49. INSERT INTO `t_sys_city` VALUES ('14', '140100', '太原市', '太原', '140000', '112.549248', '37.857014', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  50. INSERT INTO `t_sys_city` VALUES ('15', '140200', '大同市', '大同', '140000', '113.295258', '40.090309', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  51. INSERT INTO `t_sys_city` VALUES ('16', '140300', '阳泉市', '阳泉', '140000', '113.583282', '37.861187', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  52. INSERT INTO `t_sys_city` VALUES ('17', '140400', '长治市', '长治', '140000', '113.113556', '36.191113', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  53. INSERT INTO `t_sys_city` VALUES ('18', '140500', '晋城市', '晋城', '140000', '112.851273', '35.497555', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  54. INSERT INTO `t_sys_city` VALUES ('19', '140600', '朔州市', '朔州', '140000', '112.433388', '39.331261', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  55. INSERT INTO `t_sys_city` VALUES ('20', '140700', '晋中市', '晋中', '140000', '112.736465', '37.696495', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  56. INSERT INTO `t_sys_city` VALUES ('21', '140800', '运城市', '运城', '140000', '111.00396', '35.022778', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  57. INSERT INTO `t_sys_city` VALUES ('22', '140900', '忻州市', '忻州', '140000', '112.733536', '38.41769', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  58. INSERT INTO `t_sys_city` VALUES ('23', '141000', '临汾市', '临汾', '140000', '111.517975', '36.084148', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  59. INSERT INTO `t_sys_city` VALUES ('24', '141100', '吕梁市', '吕梁', '140000', '111.134338', '37.524364', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  60. INSERT INTO `t_sys_city` VALUES ('25', '150100', '呼和浩特市', '呼和浩特', '150000', '111.670799', '40.81831', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  61. INSERT INTO `t_sys_city` VALUES ('26', '150200', '包头市', '包头', '150000', '109.840408', '40.658169', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  62. INSERT INTO `t_sys_city` VALUES ('27', '150300', '乌海市', '乌海', '150000', '106.825562', '39.673733', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  63. INSERT INTO `t_sys_city` VALUES ('28', '150400', '赤峰市', '赤峰', '150000', '118.956802', '42.275318', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  64. INSERT INTO `t_sys_city` VALUES ('29', '150500', '通辽市', '通辽', '150000', '122.263123', '43.617428', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  65. INSERT INTO `t_sys_city` VALUES ('30', '150600', '鄂尔多斯市', '鄂尔多斯', '150000', '109.990288', '39.817181', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  66. INSERT INTO `t_sys_city` VALUES ('31', '150700', '呼伦贝尔市', '呼伦贝尔', '150000', '119.758171', '49.215332', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  67. INSERT INTO `t_sys_city` VALUES ('32', '150800', '巴彦淖尔市', '巴彦淖尔', '150000', '107.416962', '40.757401', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  68. INSERT INTO `t_sys_city` VALUES ('33', '150900', '乌兰察布市', '乌兰察布', '150000', '113.11454', '41.034126', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  69. INSERT INTO `t_sys_city` VALUES ('34', '152200', '兴安盟', '兴安', '150000', '122.07032', '46.076267', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  70. INSERT INTO `t_sys_city` VALUES ('35', '152500', '锡林郭勒盟', '锡林郭勒', '150000', '116.090996', '43.944019', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  71. INSERT INTO `t_sys_city` VALUES ('36', '152900', '阿拉善盟', '阿拉善', '150000', '105.706421', '38.844814', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  72. INSERT INTO `t_sys_city` VALUES ('37', '210100', '沈阳市', '沈阳', '210000', '123.429092', '41.796768', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  73. INSERT INTO `t_sys_city` VALUES ('38', '210200', '大连市', '大连', '210000', '121.618622', '38.914589', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  74. INSERT INTO `t_sys_city` VALUES ('39', '210300', '鞍山市', '鞍山', '210000', '122.995628', '41.110626', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  75. INSERT INTO `t_sys_city` VALUES ('40', '210400', '抚顺市', '抚顺', '210000', '123.921112', '41.875957', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  76. INSERT INTO `t_sys_city` VALUES ('41', '210500', '本溪市', '本溪', '210000', '123.770515', '41.297909', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  77. INSERT INTO `t_sys_city` VALUES ('42', '210600', '丹东市', '丹东', '210000', '124.383041', '40.124294', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  78. INSERT INTO `t_sys_city` VALUES ('43', '210700', '锦州市', '锦州', '210000', '121.135742', '41.11927', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  79. INSERT INTO `t_sys_city` VALUES ('44', '210800', '营口市', '营口', '210000', '122.235153', '40.667431', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  80. INSERT INTO `t_sys_city` VALUES ('45', '210900', '阜新市', '阜新', '210000', '121.648964', '42.011795', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  81. INSERT INTO `t_sys_city` VALUES ('46', '211000', '辽阳市', '辽阳', '210000', '123.181519', '41.269402', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  82. INSERT INTO `t_sys_city` VALUES ('47', '211100', '盘锦市', '盘锦', '210000', '122.069572', '41.124485', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  83. INSERT INTO `t_sys_city` VALUES ('48', '211200', '铁岭市', '铁岭', '210000', '123.844276', '42.290585', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  84. INSERT INTO `t_sys_city` VALUES ('49', '211300', '朝阳市', '朝阳', '210000', '120.45118', '41.576759', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  85. INSERT INTO `t_sys_city` VALUES ('50', '211400', '葫芦岛市', '葫芦岛', '210000', '120.856392', '40.755573', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  86. INSERT INTO `t_sys_city` VALUES ('51', '220100', '长春市', '长春', '220000', '125.324501', '43.886841', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  87. INSERT INTO `t_sys_city` VALUES ('52', '220200', '吉林市', '吉林', '220000', '126.553017', '43.843578', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  88. INSERT INTO `t_sys_city` VALUES ('53', '220300', '四平市', '四平', '220000', '124.370789', '43.170345', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  89. INSERT INTO `t_sys_city` VALUES ('54', '220400', '辽源市', '辽源', '220000', '125.145348', '42.902691', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  90. INSERT INTO `t_sys_city` VALUES ('55', '220500', '通化市', '通化', '220000', '125.936501', '41.721176', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  91. INSERT INTO `t_sys_city` VALUES ('56', '220600', '白山市', '白山', '220000', '126.427841', '41.942505', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  92. INSERT INTO `t_sys_city` VALUES ('57', '220700', '松原市', '松原', '220000', '124.823608', '45.118244', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  93. INSERT INTO `t_sys_city` VALUES ('58', '220800', '白城市', '白城', '220000', '122.84111', '45.619026', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  94. INSERT INTO `t_sys_city` VALUES ('59', '222400', '延边朝鲜族自治州', '延边朝鲜族', '220000', '129.513229', '42.904823', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  95. INSERT INTO `t_sys_city` VALUES ('60', '230100', '哈尔滨市', '哈尔滨', '230000', '126.642464', '45.756966', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  96. INSERT INTO `t_sys_city` VALUES ('61', '230200', '齐齐哈尔市', '齐齐哈尔', '230000', '123.957916', '47.342079', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  97. INSERT INTO `t_sys_city` VALUES ('62', '230300', '鸡西市', '鸡西', '230000', '130.975967', '45.300045', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  98. INSERT INTO `t_sys_city` VALUES ('63', '230400', '鹤岗市', '鹤岗', '230000', '130.277481', '47.332085', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  99. INSERT INTO `t_sys_city` VALUES ('64', '230500', '双鸭山市', '双鸭山', '230000', '131.157303', '46.64344', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  100. INSERT INTO `t_sys_city` VALUES ('65', '230600', '大庆市', '大庆', '230000', '125.112717', '46.590733', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  101. INSERT INTO `t_sys_city` VALUES ('66', '230700', '伊春市', '伊春', '230000', '128.899399', '47.724773', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  102. INSERT INTO `t_sys_city` VALUES ('67', '230800', '佳木斯市', '佳木斯', '230000', '130.361633', '46.809605', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  103. INSERT INTO `t_sys_city` VALUES ('68', '230900', '七台河市', '七台河', '230000', '131.015579', '45.771267', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  104. INSERT INTO `t_sys_city` VALUES ('69', '231000', '牡丹江市', '牡丹江', '230000', '129.618607', '44.582962', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  105. INSERT INTO `t_sys_city` VALUES ('70', '231100', '黑河市', '黑河', '230000', '127.499023', '50.249584', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  106. INSERT INTO `t_sys_city` VALUES ('71', '231200', '绥化市', '绥化', '230000', '126.992928', '46.637394', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  107. INSERT INTO `t_sys_city` VALUES ('72', '232700', '大兴安岭地区', '大兴安岭', '230000', '124.711525', '52.335262', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  108. INSERT INTO `t_sys_city` VALUES ('73', '310100', '上海市', '上海', '310000', '121.472641', '31.231707', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  109. INSERT INTO `t_sys_city` VALUES ('74', '320100', '南京市', '南京', '320000', '118.76741', '32.041546', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  110. INSERT INTO `t_sys_city` VALUES ('75', '320200', '无锡市', '无锡', '320000', '120.301666', '31.57473', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  111. INSERT INTO `t_sys_city` VALUES ('76', '320300', '徐州市', '徐州', '320000', '117.184814', '34.261791', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  112. INSERT INTO `t_sys_city` VALUES ('77', '320400', '常州市', '常州', '320000', '119.946976', '31.772753', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  113. INSERT INTO `t_sys_city` VALUES ('78', '320500', '苏州市', '苏州', '320000', '120.619583', '31.299379', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  114. INSERT INTO `t_sys_city` VALUES ('79', '320600', '南通市', '南通', '320000', '120.864609', '32.016212', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  115. INSERT INTO `t_sys_city` VALUES ('80', '320700', '连云港市', '连云港', '320000', '119.178818', '34.600018', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  116. INSERT INTO `t_sys_city` VALUES ('81', '320800', '淮安市', '淮安', '320000', '119.021263', '33.597507', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  117. INSERT INTO `t_sys_city` VALUES ('82', '320900', '盐城市', '盐城', '320000', '120.139999', '33.377632', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  118. INSERT INTO `t_sys_city` VALUES ('83', '321000', '扬州市', '扬州', '320000', '119.421005', '32.393158', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  119. INSERT INTO `t_sys_city` VALUES ('84', '321100', '镇江市', '镇江', '320000', '119.452751', '32.204403', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  120. INSERT INTO `t_sys_city` VALUES ('85', '321200', '泰州市', '泰州', '320000', '119.915176', '32.484882', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  121. INSERT INTO `t_sys_city` VALUES ('86', '321300', '宿迁市', '宿迁', '320000', '118.275162', '33.963009', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  122. INSERT INTO `t_sys_city` VALUES ('87', '330100', '杭州市', '杭州', '330000', '120.15358', '30.287458', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  123. INSERT INTO `t_sys_city` VALUES ('88', '330200', '宁波市', '宁波', '330000', '121.549789', '29.868387', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  124. INSERT INTO `t_sys_city` VALUES ('89', '330300', '温州市', '温州', '330000', '120.672112', '28.000574', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  125. INSERT INTO `t_sys_city` VALUES ('90', '330400', '嘉兴市', '嘉兴', '330000', '120.750862', '30.762653', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  126. INSERT INTO `t_sys_city` VALUES ('91', '330500', '湖州市', '湖州', '330000', '120.102402', '30.867199', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  127. INSERT INTO `t_sys_city` VALUES ('92', '330600', '绍兴市', '绍兴', '330000', '120.582115', '29.997116', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  128. INSERT INTO `t_sys_city` VALUES ('93', '330700', '金华市', '金华', '330000', '119.649506', '29.089523', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  129. INSERT INTO `t_sys_city` VALUES ('94', '330800', '衢州市', '衢州', '330000', '118.872627', '28.941708', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  130. INSERT INTO `t_sys_city` VALUES ('95', '330900', '舟山市', '舟山', '330000', '122.106865', '30.016027', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  131. INSERT INTO `t_sys_city` VALUES ('96', '331000', '台州市', '台州', '330000', '121.428596', '28.661379', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  132. INSERT INTO `t_sys_city` VALUES ('97', '331100', '丽水市', '丽水', '330000', '119.921783', '28.451994', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  133. INSERT INTO `t_sys_city` VALUES ('98', '340100', '合肥市', '合肥', '340000', '117.283043', '31.861191', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  134. INSERT INTO `t_sys_city` VALUES ('99', '340200', '芜湖市', '芜湖', '340000', '118.37645', '31.326319', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  135. INSERT INTO `t_sys_city` VALUES ('100', '340300', '蚌埠市', '蚌埠', '340000', '117.363228', '32.939667', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  136. INSERT INTO `t_sys_city` VALUES ('101', '340400', '淮南市', '淮南', '340000', '117.018326', '32.647575', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  137. INSERT INTO `t_sys_city` VALUES ('102', '340500', '马鞍山市', '马鞍山', '340000', '118.507904', '31.689362', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  138. INSERT INTO `t_sys_city` VALUES ('103', '340600', '淮北市', '淮北', '340000', '116.794662', '33.971706', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  139. INSERT INTO `t_sys_city` VALUES ('104', '340700', '铜陵市', '铜陵', '340000', '117.816574', '30.929935', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  140. INSERT INTO `t_sys_city` VALUES ('105', '340800', '安庆市', '安庆', '340000', '117.043549', '30.508829', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  141. INSERT INTO `t_sys_city` VALUES ('106', '341000', '黄山市', '黄山', '340000', '118.317322', '29.709238', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  142. INSERT INTO `t_sys_city` VALUES ('107', '341100', '滁州市', '滁州', '340000', '118.316261', '32.303627', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  143. INSERT INTO `t_sys_city` VALUES ('108', '341200', '阜阳市', '阜阳', '340000', '115.819733', '32.896969', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  144. INSERT INTO `t_sys_city` VALUES ('109', '341300', '宿州市', '宿州', '340000', '116.984085', '33.633892', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  145. INSERT INTO `t_sys_city` VALUES ('110', '341500', '六安市', '六安', '340000', '116.507675', '31.75289', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  146. INSERT INTO `t_sys_city` VALUES ('111', '341600', '亳州市', '亳州', '340000', '115.782936', '33.869339', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  147. INSERT INTO `t_sys_city` VALUES ('112', '341700', '池州市', '池州', '340000', '117.489159', '30.656036', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  148. INSERT INTO `t_sys_city` VALUES ('113', '341800', '宣城市', '宣城', '340000', '118.757996', '30.945667', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  149. INSERT INTO `t_sys_city` VALUES ('114', '350100', '福州市', '福州', '350000', '119.306236', '26.075302', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  150. INSERT INTO `t_sys_city` VALUES ('115', '350200', '厦门市', '厦门', '350000', '118.110222', '24.490475', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  151. INSERT INTO `t_sys_city` VALUES ('116', '350300', '莆田市', '莆田', '350000', '119.007561', '25.431011', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  152. INSERT INTO `t_sys_city` VALUES ('117', '350400', '三明市', '三明', '350000', '117.635002', '26.265444', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  153. INSERT INTO `t_sys_city` VALUES ('118', '350500', '泉州市', '泉州', '350000', '118.589424', '24.908854', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  154. INSERT INTO `t_sys_city` VALUES ('119', '350600', '漳州市', '漳州', '350000', '117.661804', '24.510897', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  155. INSERT INTO `t_sys_city` VALUES ('120', '350700', '南平市', '南平', '350000', '118.178459', '26.635628', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  156. INSERT INTO `t_sys_city` VALUES ('121', '350800', '龙岩市', '龙岩', '350000', '117.029778', '25.091602', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  157. INSERT INTO `t_sys_city` VALUES ('122', '350900', '宁德市', '宁德', '350000', '119.527084', '26.659241', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  158. INSERT INTO `t_sys_city` VALUES ('123', '360100', '南昌市', '南昌', '360000', '115.892151', '28.676493', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  159. INSERT INTO `t_sys_city` VALUES ('124', '360200', '景德镇市', '景德镇', '360000', '117.214661', '29.292561', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  160. INSERT INTO `t_sys_city` VALUES ('125', '360300', '萍乡市', '萍乡', '360000', '113.852188', '27.622946', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  161. INSERT INTO `t_sys_city` VALUES ('126', '360400', '九江市', '九江', '360000', '115.992813', '29.712034', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  162. INSERT INTO `t_sys_city` VALUES ('127', '360500', '新余市', '新余', '360000', '114.930832', '27.810835', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  163. INSERT INTO `t_sys_city` VALUES ('128', '360600', '鹰潭市', '鹰潭', '360000', '117.033836', '28.238638', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  164. INSERT INTO `t_sys_city` VALUES ('129', '360700', '赣州市', '赣州', '360000', '114.940277', '25.850969', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  165. INSERT INTO `t_sys_city` VALUES ('130', '360800', '吉安市', '吉安', '360000', '114.986374', '27.111698', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  166. INSERT INTO `t_sys_city` VALUES ('131', '360900', '宜春市', '宜春', '360000', '114.391136', '27.8043', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  167. INSERT INTO `t_sys_city` VALUES ('132', '361000', '抚州市', '抚州', '360000', '116.358353', '27.98385', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  168. INSERT INTO `t_sys_city` VALUES ('133', '361100', '上饶市', '上饶', '360000', '117.971184', '28.44442', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  169. INSERT INTO `t_sys_city` VALUES ('134', '370100', '济南市', '济南', '370000', '117.000923', '36.675808', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  170. INSERT INTO `t_sys_city` VALUES ('135', '370200', '青岛市', '青岛', '370000', '120.355171', '36.082981', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  171. INSERT INTO `t_sys_city` VALUES ('136', '370300', '淄博市', '淄博', '370000', '118.047646', '36.814938', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  172. INSERT INTO `t_sys_city` VALUES ('137', '370400', '枣庄市', '枣庄', '370000', '117.557961', '34.856422', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  173. INSERT INTO `t_sys_city` VALUES ('138', '370500', '东营市', '东营', '370000', '118.664711', '37.434563', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  174. INSERT INTO `t_sys_city` VALUES ('139', '370600', '烟台市', '烟台', '370000', '121.39138', '37.539295', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  175. INSERT INTO `t_sys_city` VALUES ('140', '370700', '潍坊市', '潍坊', '370000', '119.107079', '36.709251', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  176. INSERT INTO `t_sys_city` VALUES ('141', '370800', '济宁市', '济宁', '370000', '116.587242', '35.415394', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  177. INSERT INTO `t_sys_city` VALUES ('142', '370900', '泰安市', '泰安', '370000', '117.129066', '36.194969', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  178. INSERT INTO `t_sys_city` VALUES ('143', '371000', '威海市', '威海', '370000', '122.116394', '37.509689', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  179. INSERT INTO `t_sys_city` VALUES ('144', '371100', '日照市', '日照', '370000', '119.461205', '35.428589', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  180. INSERT INTO `t_sys_city` VALUES ('145', '371200', '莱芜市', '莱芜', '370000', '117.677734', '36.214397', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  181. INSERT INTO `t_sys_city` VALUES ('146', '371300', '临沂市', '临沂', '370000', '118.326447', '35.065281', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  182. INSERT INTO `t_sys_city` VALUES ('147', '371400', '德州市', '德州', '370000', '116.307426', '37.453968', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  183. INSERT INTO `t_sys_city` VALUES ('148', '371500', '聊城市', '聊城', '370000', '115.98037', '36.456013', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  184. INSERT INTO `t_sys_city` VALUES ('149', '371600', '滨州市', '滨州', '370000', '118.016975', '37.383541', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  185. INSERT INTO `t_sys_city` VALUES ('150', '371700', '菏泽市', '菏泽', '370000', '115.469383', '35.246532', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  186. INSERT INTO `t_sys_city` VALUES ('151', '410100', '郑州市', '郑州', '410000', '113.665413', '34.757977', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  187. INSERT INTO `t_sys_city` VALUES ('152', '410200', '开封市', '开封', '410000', '114.341446', '34.79705', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  188. INSERT INTO `t_sys_city` VALUES ('153', '410300', '洛阳市', '洛阳', '410000', '112.434471', '34.66304', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  189. INSERT INTO `t_sys_city` VALUES ('154', '410400', '平顶山市', '平顶山', '410000', '113.307716', '33.735241', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  190. INSERT INTO `t_sys_city` VALUES ('155', '410500', '安阳市', '安阳', '410000', '114.352486', '36.103443', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  191. INSERT INTO `t_sys_city` VALUES ('156', '410600', '鹤壁市', '鹤壁', '410000', '114.295441', '35.748238', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  192. INSERT INTO `t_sys_city` VALUES ('157', '410700', '新乡市', '新乡', '410000', '113.883987', '35.302616', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  193. INSERT INTO `t_sys_city` VALUES ('158', '410800', '焦作市', '焦作', '410000', '113.238266', '35.23904', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  194. INSERT INTO `t_sys_city` VALUES ('159', '410881', '济源市', '济源', '410000', '112.59005', '35.090378', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  195. INSERT INTO `t_sys_city` VALUES ('160', '410900', '濮阳市', '濮阳', '410000', '115.041298', '35.768234', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  196. INSERT INTO `t_sys_city` VALUES ('161', '411000', '许昌市', '许昌', '410000', '113.826065', '34.022957', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  197. INSERT INTO `t_sys_city` VALUES ('162', '411100', '漯河市', '漯河', '410000', '114.026405', '33.575855', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  198. INSERT INTO `t_sys_city` VALUES ('163', '411200', '三门峡市', '三门峡', '410000', '111.194099', '34.777336', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  199. INSERT INTO `t_sys_city` VALUES ('164', '411300', '南阳市', '南阳', '410000', '112.540916', '32.999081', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  200. INSERT INTO `t_sys_city` VALUES ('165', '411400', '商丘市', '商丘', '410000', '115.650497', '34.437054', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  201. INSERT INTO `t_sys_city` VALUES ('166', '411500', '信阳市', '信阳', '410000', '114.075027', '32.123276', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  202. INSERT INTO `t_sys_city` VALUES ('167', '411600', '周口市', '周口', '410000', '114.649651', '33.620358', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  203. INSERT INTO `t_sys_city` VALUES ('168', '411700', '驻马店市', '驻马店', '410000', '114.024734', '32.980167', '18', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  204. INSERT INTO `t_sys_city` VALUES ('169', '420100', '武汉市', '武汉', '420000', '114.298569', '30.584354', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  205. INSERT INTO `t_sys_city` VALUES ('170', '420200', '黄石市', '黄石', '420000', '115.077049', '30.220074', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  206. INSERT INTO `t_sys_city` VALUES ('171', '420300', '十堰市', '十堰', '420000', '110.787918', '32.646908', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  207. INSERT INTO `t_sys_city` VALUES ('172', '420500', '宜昌市', '宜昌', '420000', '111.29084', '30.702637', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  208. INSERT INTO `t_sys_city` VALUES ('173', '420600', '襄阳市', '襄阳', '420000', '112.14415', '32.042427', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  209. INSERT INTO `t_sys_city` VALUES ('174', '420700', '鄂州市', '鄂州', '420000', '114.890594', '30.396536', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  210. INSERT INTO `t_sys_city` VALUES ('175', '420800', '荆门市', '荆门', '420000', '112.204254', '31.035419', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  211. INSERT INTO `t_sys_city` VALUES ('176', '420900', '孝感市', '孝感', '420000', '113.926659', '30.926422', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  212. INSERT INTO `t_sys_city` VALUES ('177', '421000', '荆州市', '荆州', '420000', '112.238129', '30.326857', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  213. INSERT INTO `t_sys_city` VALUES ('178', '421100', '黄冈市', '黄冈', '420000', '114.879364', '30.447712', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  214. INSERT INTO `t_sys_city` VALUES ('179', '421200', '咸宁市', '咸宁', '420000', '114.328964', '29.832798', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  215. INSERT INTO `t_sys_city` VALUES ('180', '421300', '随州市', '随州', '420000', '113.373772', '31.717497', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  216. INSERT INTO `t_sys_city` VALUES ('181', '422800', '恩施土家族苗族自治州', '恩施', '420000', '109.486992', '30.283113', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  217. INSERT INTO `t_sys_city` VALUES ('182', '429004', '仙桃市', '仙桃', '420000', '113.453972', '30.364952', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  218. INSERT INTO `t_sys_city` VALUES ('183', '429005', '潜江市', '潜江', '420000', '112.896866', '30.421215', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  219. INSERT INTO `t_sys_city` VALUES ('184', '429006', '天门市', '天门', '420000', '113.165863', '30.653061', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  220. INSERT INTO `t_sys_city` VALUES ('185', '429021', '神农架林区', '神农架', '420000', '114.298569', '30.584354', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  221. INSERT INTO `t_sys_city` VALUES ('186', '430100', '长沙市', '长沙', '430000', '112.982277', '28.19409', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  222. INSERT INTO `t_sys_city` VALUES ('187', '430200', '株洲市', '株洲', '430000', '113.151733', '27.835806', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  223. INSERT INTO `t_sys_city` VALUES ('188', '430300', '湘潭市', '湘潭', '430000', '112.944054', '27.829729', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  224. INSERT INTO `t_sys_city` VALUES ('189', '430400', '衡阳市', '衡阳', '430000', '112.607697', '26.900358', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  225. INSERT INTO `t_sys_city` VALUES ('190', '430500', '邵阳市', '邵阳', '430000', '111.469231', '27.237843', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  226. INSERT INTO `t_sys_city` VALUES ('191', '430600', '岳阳市', '岳阳', '430000', '113.132858', '29.370291', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  227. INSERT INTO `t_sys_city` VALUES ('192', '430700', '常德市', '常德', '430000', '111.691345', '29.040224', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  228. INSERT INTO `t_sys_city` VALUES ('193', '430800', '张家界市', '张家界', '430000', '110.479919', '29.127401', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  229. INSERT INTO `t_sys_city` VALUES ('194', '430900', '益阳市', '益阳', '430000', '112.355042', '28.570066', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  230. INSERT INTO `t_sys_city` VALUES ('195', '431000', '郴州市', '郴州', '430000', '113.032066', '25.793589', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  231. INSERT INTO `t_sys_city` VALUES ('196', '431100', '永州市', '永州', '430000', '111.608017', '26.434517', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  232. INSERT INTO `t_sys_city` VALUES ('197', '431200', '怀化市', '怀化', '430000', '109.978241', '27.550081', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  233. INSERT INTO `t_sys_city` VALUES ('198', '431300', '娄底市', '娄底', '430000', '112.008499', '27.728136', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  234. INSERT INTO `t_sys_city` VALUES ('199', '433100', '湘西土家族苗族自治州', '湘西', '430000', '109.739738', '28.314297', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  235. INSERT INTO `t_sys_city` VALUES ('200', '440100', '广州市', '广州', '440000', '113.28064', '23.125177', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  236. INSERT INTO `t_sys_city` VALUES ('201', '440200', '韶关市', '韶关', '440000', '113.591545', '24.801323', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  237. INSERT INTO `t_sys_city` VALUES ('202', '440300', '深圳市', '深圳', '440000', '114.085945', '22.547001', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  238. INSERT INTO `t_sys_city` VALUES ('203', '440400', '珠海市', '珠海', '440000', '113.553986', '22.224979', '22', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  239. INSERT INTO `t_sys_city` VALUES ('204', '440500', '汕头市', '汕头', '440000', '116.708466', '23.371019', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  240. INSERT INTO `t_sys_city` VALUES ('205', '440600', '佛山市', '佛山', '440000', '113.122719', '23.028763', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  241. INSERT INTO `t_sys_city` VALUES ('206', '440700', '江门市', '江门', '440000', '113.09494', '22.590431', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  242. INSERT INTO `t_sys_city` VALUES ('207', '440800', '湛江市', '湛江', '440000', '110.364975', '21.274899', '19', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  243. INSERT INTO `t_sys_city` VALUES ('208', '440900', '茂名市', '茂名', '440000', '110.919228', '21.659752', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  244. INSERT INTO `t_sys_city` VALUES ('209', '441200', '肇庆市', '肇庆', '440000', '112.472527', '23.051546', '20', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  245. INSERT INTO `t_sys_city` VALUES ('210', '441300', '惠州市', '惠州', '440000', '114.412598', '23.079405', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  246. INSERT INTO `t_sys_city` VALUES ('211', '441400', '梅州市', '梅州', '440000', '116.117584', '24.299112', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  247. INSERT INTO `t_sys_city` VALUES ('212', '441500', '汕尾市', '汕尾', '440000', '115.364235', '22.774485', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  248. INSERT INTO `t_sys_city` VALUES ('213', '441600', '河源市', '河源', '440000', '114.6978', '23.746265', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  249. INSERT INTO `t_sys_city` VALUES ('214', '441700', '阳江市', '阳江', '440000', '111.975105', '21.859222', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  250. INSERT INTO `t_sys_city` VALUES ('215', '441800', '清远市', '清远', '440000', '113.051224', '23.685022', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  251. INSERT INTO `t_sys_city` VALUES ('216', '441900', '东莞市', '东莞', '440000', '113.746262', '23.046238', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  252. INSERT INTO `t_sys_city` VALUES ('217', '442000', '中山市', '中山', '440000', '113.382393', '22.521112', '21', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  253. INSERT INTO `t_sys_city` VALUES ('218', '442101', '东沙群岛', '东沙', '440000', '112.552948', '21.810463', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  254. INSERT INTO `t_sys_city` VALUES ('219', '445100', '潮州市', '潮州', '440000', '116.632301', '23.661701', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  255. INSERT INTO `t_sys_city` VALUES ('220', '445200', '揭阳市', '揭阳', '440000', '116.355736', '23.543777', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  256. INSERT INTO `t_sys_city` VALUES ('221', '445300', '云浮市', '云浮', '440000', '112.044441', '22.929802', '18', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  257. INSERT INTO `t_sys_city` VALUES ('222', '450100', '南宁市', '南宁', '450000', '108.320007', '22.82402', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  258. INSERT INTO `t_sys_city` VALUES ('223', '450200', '柳州市', '柳州', '450000', '109.411705', '24.314617', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  259. INSERT INTO `t_sys_city` VALUES ('224', '450300', '桂林市', '桂林', '450000', '110.299118', '25.274216', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  260. INSERT INTO `t_sys_city` VALUES ('225', '450400', '梧州市', '梧州', '450000', '111.297607', '23.474804', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  261. INSERT INTO `t_sys_city` VALUES ('226', '450500', '北海市', '北海', '450000', '109.119255', '21.473343', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  262. INSERT INTO `t_sys_city` VALUES ('227', '450600', '防城港市', '防城港', '450000', '108.345474', '21.614632', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  263. INSERT INTO `t_sys_city` VALUES ('228', '450700', '钦州市', '钦州', '450000', '108.624176', '21.967127', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  264. INSERT INTO `t_sys_city` VALUES ('229', '450800', '贵港市', '贵港', '450000', '109.602142', '23.093599', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  265. INSERT INTO `t_sys_city` VALUES ('230', '450900', '玉林市', '玉林', '450000', '110.154396', '22.631359', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  266. INSERT INTO `t_sys_city` VALUES ('231', '451000', '百色市', '百色', '450000', '106.616287', '23.897741', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  267. INSERT INTO `t_sys_city` VALUES ('232', '451100', '贺州市', '贺州', '450000', '111.552055', '24.414141', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  268. INSERT INTO `t_sys_city` VALUES ('233', '451200', '河池市', '河池', '450000', '108.062103', '24.695898', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  269. INSERT INTO `t_sys_city` VALUES ('234', '451300', '来宾市', '来宾', '450000', '109.229774', '23.733767', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  270. INSERT INTO `t_sys_city` VALUES ('235', '451400', '崇左市', '崇左', '450000', '107.353928', '22.404108', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  271. INSERT INTO `t_sys_city` VALUES ('236', '460100', '海口市', '海口', '460000', '110.331192', '20.031971', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  272. INSERT INTO `t_sys_city` VALUES ('237', '460200', '三亚市', '三亚', '460000', '109.50827', '18.247871', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  273. INSERT INTO `t_sys_city` VALUES ('238', '460300', '三沙市', '三沙', '460000', '112.348824', '16.831039', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  274. INSERT INTO `t_sys_city` VALUES ('239', '469001', '五指山市', '五指山', '460000', '109.516663', '18.77692', '19', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  275. INSERT INTO `t_sys_city` VALUES ('240', '469002', '琼海市', '琼海', '460000', '110.466782', '19.246012', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  276. INSERT INTO `t_sys_city` VALUES ('241', '469003', '儋州市', '儋州', '460000', '109.576782', '19.517487', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  277. INSERT INTO `t_sys_city` VALUES ('242', '469005', '文昌市', '文昌', '460000', '110.753975', '19.612986', '18', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  278. INSERT INTO `t_sys_city` VALUES ('243', '469006', '万宁市', '万宁', '460000', '110.388794', '18.796215', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  279. INSERT INTO `t_sys_city` VALUES ('244', '469007', '东方市', '东方', '460000', '108.653786', '19.10198', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  280. INSERT INTO `t_sys_city` VALUES ('245', '469025', '定安县', '定安', '460000', '110.349236', '19.684965', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  281. INSERT INTO `t_sys_city` VALUES ('246', '469026', '屯昌县', '屯昌', '460000', '110.102776', '19.362917', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  282. INSERT INTO `t_sys_city` VALUES ('247', '469027', '澄迈县', '澄迈', '460000', '110.007149', '19.737095', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  283. INSERT INTO `t_sys_city` VALUES ('248', '469028', '临高县', '临高', '460000', '109.687698', '19.908293', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  284. INSERT INTO `t_sys_city` VALUES ('249', '469030', '白沙黎族自治县', '白沙', '460000', '109.452606', '19.224585', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  285. INSERT INTO `t_sys_city` VALUES ('250', '469031', '昌江黎族自治县', '昌江', '460000', '109.053352', '19.260967', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  286. INSERT INTO `t_sys_city` VALUES ('251', '469033', '乐东黎族自治县', '乐东', '460000', '109.175446', '18.74758', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  287. INSERT INTO `t_sys_city` VALUES ('252', '469034', '陵水黎族自治县', '陵水', '460000', '110.037216', '18.505007', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  288. INSERT INTO `t_sys_city` VALUES ('253', '469035', '保亭黎族苗族自治县', '保亭', '460000', '109.702454', '18.636372', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  289. INSERT INTO `t_sys_city` VALUES ('254', '469036', '琼中黎族苗族自治县', '琼中', '460000', '109.839996', '19.03557', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  290. INSERT INTO `t_sys_city` VALUES ('255', '500100', '重庆市', '重庆', '500000', '106.504959', '29.533155', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  291. INSERT INTO `t_sys_city` VALUES ('256', '510100', '成都市', '成都', '510000', '104.065735', '30.659462', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  292. INSERT INTO `t_sys_city` VALUES ('257', '510300', '自贡市', '自贡', '510000', '104.773445', '29.352764', '20', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  293. INSERT INTO `t_sys_city` VALUES ('258', '510400', '攀枝花市', '攀枝花', '510000', '101.716003', '26.580446', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  294. INSERT INTO `t_sys_city` VALUES ('259', '510500', '泸州市', '泸州', '510000', '105.443352', '28.889137', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  295. INSERT INTO `t_sys_city` VALUES ('260', '510600', '德阳市', '德阳', '510000', '104.398651', '31.127991', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  296. INSERT INTO `t_sys_city` VALUES ('261', '510700', '绵阳市', '绵阳', '510000', '104.741722', '31.46402', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  297. INSERT INTO `t_sys_city` VALUES ('262', '510800', '广元市', '广元', '510000', '105.829758', '32.433666', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  298. INSERT INTO `t_sys_city` VALUES ('263', '510900', '遂宁市', '遂宁', '510000', '105.571327', '30.513311', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  299. INSERT INTO `t_sys_city` VALUES ('264', '511000', '内江市', '内江', '510000', '105.066139', '29.58708', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  300. INSERT INTO `t_sys_city` VALUES ('265', '511100', '乐山市', '乐山', '510000', '103.761261', '29.582024', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  301. INSERT INTO `t_sys_city` VALUES ('266', '511300', '南充市', '南充', '510000', '106.082977', '30.79528', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  302. INSERT INTO `t_sys_city` VALUES ('267', '511400', '眉山市', '眉山', '510000', '103.831787', '30.048319', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  303. INSERT INTO `t_sys_city` VALUES ('268', '511500', '宜宾市', '宜宾', '510000', '104.630821', '28.760189', '19', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  304. INSERT INTO `t_sys_city` VALUES ('269', '511600', '广安市', '广安', '510000', '106.633369', '30.456398', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  305. INSERT INTO `t_sys_city` VALUES ('270', '511700', '达州市', '达州', '510000', '107.502258', '31.209484', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  306. INSERT INTO `t_sys_city` VALUES ('271', '511800', '雅安市', '雅安', '510000', '103.00103', '29.987722', '18', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  307. INSERT INTO `t_sys_city` VALUES ('272', '511900', '巴中市', '巴中', '510000', '106.75367', '31.858809', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  308. INSERT INTO `t_sys_city` VALUES ('273', '512000', '资阳市', '资阳', '510000', '104.641914', '30.122211', '21', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  309. INSERT INTO `t_sys_city` VALUES ('274', '513200', '阿坝藏族羌族自治州', '阿坝', '510000', '102.221375', '31.899792', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  310. INSERT INTO `t_sys_city` VALUES ('275', '513300', '甘孜藏族自治州', '甘孜', '510000', '101.963814', '30.050663', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  311. INSERT INTO `t_sys_city` VALUES ('276', '513400', '凉山彝族自治州', '凉山', '510000', '102.258743', '27.886763', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  312. INSERT INTO `t_sys_city` VALUES ('277', '520100', '贵阳市', '贵阳', '520000', '106.713478', '26.578342', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  313. INSERT INTO `t_sys_city` VALUES ('278', '520200', '六盘水市', '六盘水', '520000', '104.846741', '26.584642', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  314. INSERT INTO `t_sys_city` VALUES ('279', '520300', '遵义市', '遵义', '520000', '106.937263', '27.706627', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  315. INSERT INTO `t_sys_city` VALUES ('280', '520400', '安顺市', '安顺', '520000', '105.93219', '26.245544', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  316. INSERT INTO `t_sys_city` VALUES ('281', '522200', '铜仁市', '铜仁', '520000', '109.191551', '27.718346', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  317. INSERT INTO `t_sys_city` VALUES ('282', '522300', '黔西南布依族苗族自治州', '黔西南', '520000', '104.897972', '25.08812', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  318. INSERT INTO `t_sys_city` VALUES ('283', '522400', '毕节市', '毕节', '520000', '105.285011', '27.301693', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  319. INSERT INTO `t_sys_city` VALUES ('284', '522600', '黔东南苗族侗族自治州', '黔东南', '520000', '107.977486', '26.583351', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  320. INSERT INTO `t_sys_city` VALUES ('285', '522700', '黔南布依族苗族自治州', '黔南', '520000', '107.517159', '26.258219', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  321. INSERT INTO `t_sys_city` VALUES ('286', '530100', '昆明市', '昆明', '530000', '102.71225', '25.040609', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  322. INSERT INTO `t_sys_city` VALUES ('287', '530300', '曲靖市', '曲靖', '530000', '103.797852', '25.501556', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  323. INSERT INTO `t_sys_city` VALUES ('288', '530400', '玉溪市', '玉溪', '530000', '102.543907', '24.35046', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  324. INSERT INTO `t_sys_city` VALUES ('289', '530500', '保山市', '保山', '530000', '99.16713', '25.111801', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  325. INSERT INTO `t_sys_city` VALUES ('290', '530600', '昭通市', '昭通', '530000', '103.717216', '27.337', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  326. INSERT INTO `t_sys_city` VALUES ('291', '530700', '丽江市', '丽江', '530000', '100.233025', '26.872108', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  327. INSERT INTO `t_sys_city` VALUES ('292', '530800', '普洱市', '普洱', '530000', '100.972343', '22.777321', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  328. INSERT INTO `t_sys_city` VALUES ('293', '530900', '临沧市', '临沧', '530000', '100.086967', '23.886566', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  329. INSERT INTO `t_sys_city` VALUES ('294', '532300', '楚雄彝族自治州', '楚雄', '530000', '101.546043', '25.041988', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  330. INSERT INTO `t_sys_city` VALUES ('295', '532500', '红河哈尼族彝族自治州', '红河', '530000', '103.384186', '23.366776', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  331. INSERT INTO `t_sys_city` VALUES ('296', '532600', '文山壮族苗族自治州', '文山', '530000', '104.244011', '23.369511', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  332. INSERT INTO `t_sys_city` VALUES ('297', '532800', '西双版纳傣族自治州', '西双版纳', '530000', '100.797943', '22.001724', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  333. INSERT INTO `t_sys_city` VALUES ('298', '532900', '大理白族自治州', '大理', '530000', '100.22567', '25.589449', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  334. INSERT INTO `t_sys_city` VALUES ('299', '533100', '德宏傣族景颇族自治州', '德宏', '530000', '98.578362', '24.436693', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  335. INSERT INTO `t_sys_city` VALUES ('300', '533300', '怒江傈僳族自治州', '怒江', '530000', '98.854301', '25.850948', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  336. INSERT INTO `t_sys_city` VALUES ('301', '533400', '迪庆藏族自治州', '迪庆', '530000', '99.706467', '27.826853', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  337. INSERT INTO `t_sys_city` VALUES ('302', '540100', '拉萨市', '拉萨', '540000', '91.13221', '29.66036', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  338. INSERT INTO `t_sys_city` VALUES ('303', '542100', '昌都地区', '昌都', '540000', '97.178452', '31.136875', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  339. INSERT INTO `t_sys_city` VALUES ('304', '542200', '山南地区', '山南', '540000', '91.766525', '29.236023', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  340. INSERT INTO `t_sys_city` VALUES ('305', '542300', '日喀则地区', '日喀则', '540000', '88.885147', '29.267519', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  341. INSERT INTO `t_sys_city` VALUES ('306', '542400', '那曲地区', '那曲', '540000', '92.060211', '31.476004', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  342. INSERT INTO `t_sys_city` VALUES ('307', '542500', '阿里地区', '阿里', '540000', '80.105499', '32.503185', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  343. INSERT INTO `t_sys_city` VALUES ('308', '542600', '林芝地区', '林芝', '540000', '94.36235', '29.654694', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  344. INSERT INTO `t_sys_city` VALUES ('309', '610100', '西安市', '西安', '610000', '108.948021', '34.263161', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  345. INSERT INTO `t_sys_city` VALUES ('310', '610200', '铜川市', '铜川', '610000', '108.979607', '34.91658', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  346. INSERT INTO `t_sys_city` VALUES ('311', '610300', '宝鸡市', '宝鸡', '610000', '107.144867', '34.369316', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  347. INSERT INTO `t_sys_city` VALUES ('312', '610400', '咸阳市', '咸阳', '610000', '108.705116', '34.333439', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  348. INSERT INTO `t_sys_city` VALUES ('313', '610500', '渭南市', '渭南', '610000', '109.502884', '34.499382', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  349. INSERT INTO `t_sys_city` VALUES ('314', '610600', '延安市', '延安', '610000', '109.490807', '36.596539', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  350. INSERT INTO `t_sys_city` VALUES ('315', '610700', '汉中市', '汉中', '610000', '107.028618', '33.077667', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  351. INSERT INTO `t_sys_city` VALUES ('316', '610800', '榆林市', '榆林', '610000', '109.741196', '38.290161', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  352. INSERT INTO `t_sys_city` VALUES ('317', '610900', '安康市', '安康', '610000', '109.029274', '32.6903', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  353. INSERT INTO `t_sys_city` VALUES ('318', '611000', '商洛市', '商洛', '610000', '109.939774', '33.86832', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  354. INSERT INTO `t_sys_city` VALUES ('319', '620100', '兰州市', '兰州', '620000', '103.823555', '36.058041', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  355. INSERT INTO `t_sys_city` VALUES ('320', '620200', '嘉峪关市', '嘉峪关', '620000', '98.277306', '39.78653', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  356. INSERT INTO `t_sys_city` VALUES ('321', '620300', '金昌市', '金昌', '620000', '102.187889', '38.514236', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  357. INSERT INTO `t_sys_city` VALUES ('322', '620400', '白银市', '白银', '620000', '104.173607', '36.545681', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  358. INSERT INTO `t_sys_city` VALUES ('323', '620500', '天水市', '天水', '620000', '105.724998', '34.578529', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  359. INSERT INTO `t_sys_city` VALUES ('324', '620600', '武威市', '武威', '620000', '102.634697', '37.929996', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  360. INSERT INTO `t_sys_city` VALUES ('325', '620700', '张掖市', '张掖', '620000', '100.455475', '38.932896', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  361. INSERT INTO `t_sys_city` VALUES ('326', '620800', '平凉市', '平凉', '620000', '106.684692', '35.542789', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  362. INSERT INTO `t_sys_city` VALUES ('327', '620900', '酒泉市', '酒泉', '620000', '98.510796', '39.744022', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  363. INSERT INTO `t_sys_city` VALUES ('328', '621000', '庆阳市', '庆阳', '620000', '107.638374', '35.734219', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  364. INSERT INTO `t_sys_city` VALUES ('329', '621100', '定西市', '定西', '620000', '104.626297', '35.579578', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  365. INSERT INTO `t_sys_city` VALUES ('330', '621200', '陇南市', '陇南', '620000', '104.929382', '33.388599', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  366. INSERT INTO `t_sys_city` VALUES ('331', '622900', '临夏回族自治州', '临夏', '620000', '103.212006', '35.599445', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  367. INSERT INTO `t_sys_city` VALUES ('332', '623000', '甘南藏族自治州', '甘南', '620000', '102.911011', '34.986355', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  368. INSERT INTO `t_sys_city` VALUES ('333', '630100', '西宁市', '西宁', '630000', '101.778915', '36.623177', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  369. INSERT INTO `t_sys_city` VALUES ('334', '632100', '海东市', '海东', '630000', '102.103271', '36.502914', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  370. INSERT INTO `t_sys_city` VALUES ('335', '632200', '海北藏族自治州', '海北', '630000', '100.901062', '36.959435', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  371. INSERT INTO `t_sys_city` VALUES ('336', '632300', '黄南藏族自治州', '黄南', '630000', '102.019989', '35.517742', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  372. INSERT INTO `t_sys_city` VALUES ('337', '632500', '海南藏族自治州', '海南藏族', '630000', '100.619545', '36.280354', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  373. INSERT INTO `t_sys_city` VALUES ('338', '632600', '果洛藏族自治州', '果洛', '630000', '100.242142', '34.473598', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  374. INSERT INTO `t_sys_city` VALUES ('339', '632700', '玉树藏族自治州', '玉树', '630000', '97.008522', '33.004047', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  375. INSERT INTO `t_sys_city` VALUES ('340', '632800', '海西蒙古族藏族自治州', '海西', '630000', '97.370789', '37.374664', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  376. INSERT INTO `t_sys_city` VALUES ('341', '640100', '银川市', '银川', '640000', '106.278175', '38.46637', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  377. INSERT INTO `t_sys_city` VALUES ('342', '640200', '石嘴山市', '石嘴山', '640000', '106.376175', '39.013329', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  378. INSERT INTO `t_sys_city` VALUES ('343', '640300', '吴忠市', '吴忠', '640000', '106.199409', '37.986164', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  379. INSERT INTO `t_sys_city` VALUES ('344', '640400', '固原市', '固原', '640000', '106.28524', '36.004562', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  380. INSERT INTO `t_sys_city` VALUES ('345', '640500', '中卫市', '中卫', '640000', '105.189568', '37.51495', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  381. INSERT INTO `t_sys_city` VALUES ('346', '650100', '乌鲁木齐市', '乌鲁木齐', '650000', '87.617729', '43.792816', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  382. INSERT INTO `t_sys_city` VALUES ('347', '650200', '克拉玛依市', '克拉玛依', '650000', '84.873947', '45.595886', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  383. INSERT INTO `t_sys_city` VALUES ('348', '652100', '吐鲁番地区', '吐鲁番', '650000', '89.184074', '42.947613', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  384. INSERT INTO `t_sys_city` VALUES ('349', '652200', '哈密地区', '哈密', '650000', '93.513161', '42.833248', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  385. INSERT INTO `t_sys_city` VALUES ('350', '652300', '昌吉回族自治州', '昌吉', '650000', '87.304008', '44.014576', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  386. INSERT INTO `t_sys_city` VALUES ('351', '652700', '博尔塔拉蒙古自治州', '博尔塔拉', '650000', '82.074776', '44.903259', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  387. INSERT INTO `t_sys_city` VALUES ('352', '652800', '巴音郭楞蒙古自治州', '巴音郭楞', '650000', '86.15097', '41.768551', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  388. INSERT INTO `t_sys_city` VALUES ('353', '652900', '阿克苏地区', '阿克苏', '650000', '80.265068', '41.170712', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  389. INSERT INTO `t_sys_city` VALUES ('354', '653000', '克孜勒苏柯尔克孜自治州', '克孜勒苏柯尔克孜', '650000', '76.172829', '39.713432', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  390. INSERT INTO `t_sys_city` VALUES ('355', '653100', '喀什地区', '喀什', '650000', '75.989136', '39.467663', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  391. INSERT INTO `t_sys_city` VALUES ('356', '653200', '和田地区', '和田', '650000', '79.925331', '37.110687', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  392. INSERT INTO `t_sys_city` VALUES ('357', '654000', '伊犁哈萨克自治州', '伊犁', '650000', '81.317947', '43.92186', '18', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  393. INSERT INTO `t_sys_city` VALUES ('358', '654200', '塔城地区', '塔城', '650000', '82.985733', '46.7463', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  394. INSERT INTO `t_sys_city` VALUES ('359', '654300', '阿勒泰地区', '阿勒泰', '650000', '88.139633', '47.848392', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  395. INSERT INTO `t_sys_city` VALUES ('360', '659001', '石河子市', '石河子', '650000', '86.041077', '44.305885', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  396. INSERT INTO `t_sys_city` VALUES ('361', '659002', '阿拉尔市', '阿拉尔', '650000', '81.285881', '40.541916', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  397. INSERT INTO `t_sys_city` VALUES ('362', '659003', '图木舒克市', '图木舒克', '650000', '79.07798', '39.867317', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  398. INSERT INTO `t_sys_city` VALUES ('363', '659004', '五家渠市', '五家渠', '650000', '87.526886', '44.1674', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  399. INSERT INTO `t_sys_city` VALUES ('364', '710100', '台北市', '台北', '710000', '121.509064', '25.044333', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  400. INSERT INTO `t_sys_city` VALUES ('365', '710200', '高雄市', '高雄', '710000', '121.509064', '25.044333', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  401. INSERT INTO `t_sys_city` VALUES ('366', '710300', '台南市', '台南', '710000', '121.509064', '25.044333', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  402. INSERT INTO `t_sys_city` VALUES ('367', '710400', '台中市', '台中', '710000', '121.509064', '25.044333', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  403. INSERT INTO `t_sys_city` VALUES ('368', '710500', '金门县', '金门', '710000', '121.509064', '25.044333', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  404. INSERT INTO `t_sys_city` VALUES ('369', '710600', '南投县', '南投', '710000', '121.509064', '25.044333', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  405. INSERT INTO `t_sys_city` VALUES ('370', '710700', '基隆市', '基隆', '710000', '121.509064', '25.044333', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  406. INSERT INTO `t_sys_city` VALUES ('371', '710800', '新竹市', '新竹', '710000', '121.509064', '25.044333', '18', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  407. INSERT INTO `t_sys_city` VALUES ('372', '710900', '嘉义市', '嘉义', '710000', '121.509064', '25.044333', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  408. INSERT INTO `t_sys_city` VALUES ('373', '711100', '新北市', '新北', '710000', '121.509064', '25.044333', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  409. INSERT INTO `t_sys_city` VALUES ('374', '711200', '宜兰县', '宜兰', '710000', '121.509064', '25.044333', '20', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  410. INSERT INTO `t_sys_city` VALUES ('375', '711300', '新竹县', '新竹', '710000', '121.509064', '25.044333', '19', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  411. INSERT INTO `t_sys_city` VALUES ('376', '711400', '桃园县', '桃园', '710000', '121.509064', '25.044333', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  412. INSERT INTO `t_sys_city` VALUES ('377', '711500', '苗栗县', '苗栗', '710000', '121.509064', '25.044333', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  413. INSERT INTO `t_sys_city` VALUES ('378', '711700', '彰化县', '彰化', '710000', '121.509064', '25.044333', '22', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  414. INSERT INTO `t_sys_city` VALUES ('379', '711900', '嘉义县', '嘉义', '710000', '121.509064', '25.044333', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  415. INSERT INTO `t_sys_city` VALUES ('380', '712100', '云林县', '云林', '710000', '121.509064', '25.044333', '21', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  416. INSERT INTO `t_sys_city` VALUES ('381', '712400', '屏东县', '屏东', '710000', '121.509064', '25.044333', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  417. INSERT INTO `t_sys_city` VALUES ('382', '712500', '台东县', '台东', '710000', '121.509064', '25.044333', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  418. INSERT INTO `t_sys_city` VALUES ('383', '712600', '花莲县', '花莲', '710000', '121.509064', '25.044333', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  419. INSERT INTO `t_sys_city` VALUES ('384', '712700', '澎湖县', '澎湖', '710000', '121.509064', '25.044333', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  420. INSERT INTO `t_sys_city` VALUES ('385', '712800', '连江县', '连江', '710000', '121.509064', '25.044333', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  421. INSERT INTO `t_sys_city` VALUES ('386', '810100', '香港岛', '香港岛', '810000', '114.173355', '22.320047', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  422. INSERT INTO `t_sys_city` VALUES ('387', '810200', '九龙', '九龙', '810000', '114.173355', '22.320047', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  423. INSERT INTO `t_sys_city` VALUES ('388', '810300', '新界', '新界', '810000', '114.173355', '22.320047', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  424. INSERT INTO `t_sys_city` VALUES ('389', '820100', '澳门半岛', '澳门半岛', '820000', '113.549133', '22.198751', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');
  425. INSERT INTO `t_sys_city` VALUES ('390', '820200', '离岛', '离岛', '820000', '113.549088', '22.198952', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '0');