bigdata-highway-analytics/db/bs_jaotong.sql
18796357645 11657ae4f5 上传
2025-03-31 20:06:02 +08:00

2359 lines
200 KiB
SQL

/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50736
Source Host : localhost:3306
Source Schema : bs_jaotong
Target Server Type : MySQL
Target Server Version : 50736
File Encoding : 65001
Date: 30/03/2025 18:43:28
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for city_code
-- ----------------------------
DROP TABLE IF EXISTS `city_code`;
CREATE TABLE `city_code` (
`code` int(5) NOT NULL,
`name` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`pinyin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of city_code
-- ----------------------------
INSERT INTO `city_code` VALUES (460100, '海口', 'hai kou');
INSERT INTO `city_code` VALUES (460200, '三亚', 'san ya');
INSERT INTO `city_code` VALUES (510100, '成都', 'cheng du');
INSERT INTO `city_code` VALUES (450300, '桂林', 'gui lin');
INSERT INTO `city_code` VALUES (610100, '西安', 'xi an');
INSERT INTO `city_code` VALUES (654000, '伊犁', 'yi li');
INSERT INTO `city_code` VALUES (441300, '惠州', 'hui zhou');
INSERT INTO `city_code` VALUES (640100, '银川', 'yin chuan');
INSERT INTO `city_code` VALUES (511300, '南充', 'nan chong');
INSERT INTO `city_code` VALUES (450200, '柳州', 'liu zhou');
INSERT INTO `city_code` VALUES (410100, '郑州', 'zheng zhou');
INSERT INTO `city_code` VALUES (620100, '兰州', 'lan zhou');
INSERT INTO `city_code` VALUES (370100, '济南', 'ji nan');
INSERT INTO `city_code` VALUES (450100, '南宁', 'nan ning');
INSERT INTO `city_code` VALUES (410700, '新乡', 'xin xiang');
INSERT INTO `city_code` VALUES (610400, '咸阳', 'xian yang');
INSERT INTO `city_code` VALUES (140100, '太原', 'tai yuan');
INSERT INTO `city_code` VALUES (140200, '大同', 'da tong');
INSERT INTO `city_code` VALUES (440300, '深圳', 'shen zuo');
INSERT INTO `city_code` VALUES (411300, '南阳', 'nan yang');
INSERT INTO `city_code` VALUES (430100, '长沙', 'chang sha');
INSERT INTO `city_code` VALUES (440900, '茂名', 'mao ming');
INSERT INTO `city_code` VALUES (440100, '广州', 'guang zhou');
INSERT INTO `city_code` VALUES (130400, '邯郸', 'han dan');
INSERT INTO `city_code` VALUES (440800, '湛江', 'zhan jiang');
INSERT INTO `city_code` VALUES (130600, '保定', 'bao ding');
INSERT INTO `city_code` VALUES (440600, '佛山', 'fo shan');
INSERT INTO `city_code` VALUES (510600, '德阳', 'de yang');
INSERT INTO `city_code` VALUES (441900, '东莞', 'dong zuo');
INSERT INTO `city_code` VALUES (410300, '洛阳', 'luo yang');
INSERT INTO `city_code` VALUES (131000, '廊坊', 'lang fang');
INSERT INTO `city_code` VALUES (371400, '德州', 'de zhou');
INSERT INTO `city_code` VALUES (441800, '清远', 'qing yuan');
INSERT INTO `city_code` VALUES (442000, '中山', 'zhong shan');
INSERT INTO `city_code` VALUES (150600, '鄂尔多斯', 'e er duo si');
INSERT INTO `city_code` VALUES (130500, '邢台', 'xing tai');
INSERT INTO `city_code` VALUES (530100, '昆明', 'kun ming');
INSERT INTO `city_code` VALUES (350600, '漳州', 'zhang zhou');
INSERT INTO `city_code` VALUES (630100, '西宁', 'xi ning');
INSERT INTO `city_code` VALUES (650100, '乌鲁木齐', 'wu lu mu qi');
INSERT INTO `city_code` VALUES (130900, '沧州', 'cang zhou');
INSERT INTO `city_code` VALUES (150100, '呼和浩特', 'hu he hao te');
INSERT INTO `city_code` VALUES (350100, '福州', 'fu zhou');
INSERT INTO `city_code` VALUES (330300, '温州', 'wen zhou');
INSERT INTO `city_code` VALUES (440500, '汕头', 'shan tou');
INSERT INTO `city_code` VALUES (440400, '珠海', 'zhu hai');
INSERT INTO `city_code` VALUES (360700, '赣州', 'gan zhou');
INSERT INTO `city_code` VALUES (350500, '泉州', 'quan zhou');
INSERT INTO `city_code` VALUES (321300, '宿迁', 'su qian');
INSERT INTO `city_code` VALUES (520100, '贵阳', 'gui yang');
INSERT INTO `city_code` VALUES (370900, '泰安', 'tai an');
INSERT INTO `city_code` VALUES (130700, '张家口', 'zhang jia kou');
INSERT INTO `city_code` VALUES (370700, '潍坊', 'wei fang');
INSERT INTO `city_code` VALUES (420100, '武汉', 'wu han');
INSERT INTO `city_code` VALUES (510700, '绵阳', 'mian yang');
INSERT INTO `city_code` VALUES (810000, '香港', 'xiang gang');
INSERT INTO `city_code` VALUES (500000, '重庆', 'chong qing');
INSERT INTO `city_code` VALUES (130200, '唐山', 'tang shan');
INSERT INTO `city_code` VALUES (320100, '南京', 'nan jing');
INSERT INTO `city_code` VALUES (440200, '韶关', 'shao guan');
INSERT INTO `city_code` VALUES (310000, '上海', 'shang hai');
INSERT INTO `city_code` VALUES (330100, '杭州', 'hang zhou');
INSERT INTO `city_code` VALUES (130100, '石家庄', 'shi jia zhuang');
INSERT INTO `city_code` VALUES (330400, '嘉兴', 'jia xing');
INSERT INTO `city_code` VALUES (371300, '临沂', 'lin yi');
INSERT INTO `city_code` VALUES (370600, '烟台', 'yan tai');
INSERT INTO `city_code` VALUES (110000, '北京', 'bei jing');
INSERT INTO `city_code` VALUES (441200, '肇庆', 'zhao qing');
INSERT INTO `city_code` VALUES (340100, '合肥', 'he fei');
INSERT INTO `city_code` VALUES (360100, '南昌', 'nan chang');
INSERT INTO `city_code` VALUES (440700, '江门', 'jiang men');
INSERT INTO `city_code` VALUES (430400, '衡阳', 'heng yang');
INSERT INTO `city_code` VALUES (330800, '衢州', 'qu zhou');
INSERT INTO `city_code` VALUES (320900, '盐城', 'yan cheng');
INSERT INTO `city_code` VALUES (370200, '青岛', 'qing dao');
INSERT INTO `city_code` VALUES (341100, '滁州', 'chu zhou');
INSERT INTO `city_code` VALUES (321100, '镇江', 'zhen jiang');
INSERT INTO `city_code` VALUES (330200, '宁波', 'ning bo');
INSERT INTO `city_code` VALUES (210100, '沈阳', 'shen yang');
INSERT INTO `city_code` VALUES (220100, '长春', 'chang chun');
INSERT INTO `city_code` VALUES (210200, '大连', 'da lian');
INSERT INTO `city_code` VALUES (230100, '哈尔滨', 'ha er bin');
INSERT INTO `city_code` VALUES (321000, '扬州', 'yang zhou');
INSERT INTO `city_code` VALUES (370800, '济宁', 'ji ning');
INSERT INTO `city_code` VALUES (350200, '厦门', 'xia men');
INSERT INTO `city_code` VALUES (320400, '常州', 'chang zhou');
INSERT INTO `city_code` VALUES (320700, '连云港', 'lian yun gang');
INSERT INTO `city_code` VALUES (320500, '苏州', 'su zhou');
INSERT INTO `city_code` VALUES (331000, '台州', 'tai zhou');
INSERT INTO `city_code` VALUES (120000, '天津', 'tian jin');
INSERT INTO `city_code` VALUES (370300, '淄博', 'zi bo');
INSERT INTO `city_code` VALUES (340200, '芜湖', 'wu hu');
INSERT INTO `city_code` VALUES (330600, '绍兴', 'shao xing');
INSERT INTO `city_code` VALUES (320300, '徐州', 'xu zhou');
INSERT INTO `city_code` VALUES (330500, '湖州', 'hu zhou');
INSERT INTO `city_code` VALUES (320800, '淮安', 'huai an');
INSERT INTO `city_code` VALUES (321200, '泰州', 'tai zhou');
INSERT INTO `city_code` VALUES (330700, '金华', 'jin hua');
INSERT INTO `city_code` VALUES (320200, '无锡', 'wu xi');
INSERT INTO `city_code` VALUES (320600, '南通', 'nan tong');
-- ----------------------------
-- Table structure for city_road
-- ----------------------------
DROP TABLE IF EXISTS `city_road`;
CREATE TABLE `city_road` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`road_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`index` double(10, 2) NOT NULL,
`speed` double(10, 2) NOT NULL,
`travelTime` double(10, 2) NOT NULL,
`delayTime` double(10, 2) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2001 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of city_road
-- ----------------------------
INSERT INTO `city_road` VALUES (1001, '琼州大道', '460100', '海口', 2.40, 18.60, 8.80, 5.10);
INSERT INTO `city_road` VALUES (1002, '龙昆南路', '460100', '海口', 1.90, 27.30, 9.30, 4.40);
INSERT INTO `city_road` VALUES (1003, '迎宾大道', '460100', '海口', 1.70, 37.60, 9.40, 3.80);
INSERT INTO `city_road` VALUES (1004, '高登东街', '460100', '海口', 1.50, 23.30, 5.50, 1.80);
INSERT INTO `city_road` VALUES (1005, '凤翔东路', '460100', '海口', 1.50, 30.00, 6.80, 2.10);
INSERT INTO `city_road` VALUES (1006, '永万路', '460100', '海口', 1.40, 31.40, 8.90, 2.70);
INSERT INTO `city_road` VALUES (1007, '青年路', '460100', '海口', 1.40, 20.70, 8.20, 2.50);
INSERT INTO `city_road` VALUES (1008, '龙昆南路', '460100', '海口', 1.40, 38.70, 6.50, 1.80);
INSERT INTO `city_road` VALUES (1009, '高登东街', '460100', '海口', 1.30, 25.20, 5.10, 1.30);
INSERT INTO `city_road` VALUES (1010, '国兴大道', '460100', '海口', 1.30, 39.50, 5.90, 1.50);
INSERT INTO `city_road` VALUES (1011, '三亚河西路', '460200', '三亚', 1.80, 21.30, 8.10, 3.70);
INSERT INTO `city_road` VALUES (1012, '胜利路', '460200', '三亚', 1.70, 21.50, 7.40, 3.10);
INSERT INTO `city_road` VALUES (1013, '回新路', '460200', '三亚', 1.60, 28.60, 9.20, 3.50);
INSERT INTO `city_road` VALUES (1014, '金鸡岭街', '460200', '三亚', 1.50, 27.80, 4.90, 1.70);
INSERT INTO `city_road` VALUES (1015, '回新路', '460200', '三亚', 1.40, 34.20, 7.50, 2.30);
INSERT INTO `city_road` VALUES (1016, '三亚河西路', '460200', '三亚', 1.30, 30.10, 5.80, 1.50);
INSERT INTO `city_road` VALUES (1017, '海螺一路', '460200', '三亚', 1.30, 36.40, 5.00, 1.30);
INSERT INTO `city_road` VALUES (1018, '迎宾路', '460200', '三亚', 1.30, 37.60, 17.60, 4.40);
INSERT INTO `city_road` VALUES (1019, '临春河路', '460200', '三亚', 1.30, 29.50, 6.60, 1.60);
INSERT INTO `city_road` VALUES (1020, '三亚河东路', '460200', '三亚', 1.30, 34.90, 8.10, 2.00);
INSERT INTO `city_road` VALUES (1021, '蜀西路', '510100', '成都', 2.90, 21.60, 12.10, 7.90);
INSERT INTO `city_road` VALUES (1022, '永康路', '510100', '成都', 2.60, 24.10, 9.30, 5.80);
INSERT INTO `city_road` VALUES (1023, '南三环路三段', '510100', '成都', 2.50, 33.30, 6.50, 3.90);
INSERT INTO `city_road` VALUES (1024, '跨湖路', '510100', '成都', 2.50, 17.90, 9.90, 5.90);
INSERT INTO `city_road` VALUES (1025, '花都大道东段', '510100', '成都', 2.50, 18.80, 8.40, 5.00);
INSERT INTO `city_road` VALUES (1026, '科华南路', '510100', '成都', 2.50, 26.30, 17.10, 10.20);
INSERT INTO `city_road` VALUES (1027, '南三环路二段', '510100', '成都', 2.40, 34.40, 5.00, 2.90);
INSERT INTO `city_road` VALUES (1028, '成华大道十里店路', '510100', '成都', 2.20, 24.00, 9.80, 5.30);
INSERT INTO `city_road` VALUES (1029, '剑南大道中段', '510100', '成都', 2.20, 32.10, 6.50, 3.50);
INSERT INTO `city_road` VALUES (1030, '剑南大道中段', '510100', '成都', 2.10, 34.20, 6.10, 3.20);
INSERT INTO `city_road` VALUES (1031, '六合路', '450300', '桂林', 1.70, 18.90, 6.50, 2.60);
INSERT INTO `city_road` VALUES (1032, '六合路', '450300', '桂林', 1.60, 19.20, 6.40, 2.40);
INSERT INTO `city_road` VALUES (1033, '普陀路', '450300', '桂林', 1.40, 28.80, 4.40, 1.30);
INSERT INTO `city_road` VALUES (1034, '金水路', '450300', '桂林', 1.40, 32.30, 3.90, 1.00);
INSERT INTO `city_road` VALUES (1035, '骖鸾路', '450300', '桂林', 1.40, 26.50, 5.10, 1.30);
INSERT INTO `city_road` VALUES (1036, '穿山东路', '450300', '桂林', 1.30, 28.80, 5.00, 1.30);
INSERT INTO `city_road` VALUES (1037, '金水路', '450300', '桂林', 1.30, 32.30, 3.90, 1.00);
INSERT INTO `city_road` VALUES (1038, '东安路', '450300', '桂林', 1.30, 31.90, 4.40, 1.10);
INSERT INTO `city_road` VALUES (1039, '金鸡路', '450300', '桂林', 1.30, 30.10, 9.40, 2.20);
INSERT INTO `city_road` VALUES (1040, '七星路', '450300', '桂林', 1.30, 32.30, 4.60, 1.10);
INSERT INTO `city_road` VALUES (1041, '二环南路西段', '610100', '西安', 2.50, 26.30, 13.30, 7.80);
INSERT INTO `city_road` VALUES (1042, '东二环路', '610100', '西安', 2.30, 28.20, 16.70, 9.40);
INSERT INTO `city_road` VALUES (1043, '凤城一路', '610100', '西安', 1.90, 15.80, 18.60, 8.90);
INSERT INTO `city_road` VALUES (1044, '西沣北路', '610100', '西安', 1.90, 25.60, 5.30, 2.50);
INSERT INTO `city_road` VALUES (1045, '丈八西路', '610100', '西安', 1.70, 22.40, 10.20, 4.40);
INSERT INTO `city_road` VALUES (1046, '雁南二路辅路', '610100', '西安', 1.70, 20.40, 6.20, 2.70);
INSERT INTO `city_road` VALUES (1047, '二环南路东段', '610100', '西安', 1.70, 36.00, 8.10, 3.40);
INSERT INTO `city_road` VALUES (1048, '含光路南段', '610100', '西安', 1.70, 24.60, 6.40, 2.60);
INSERT INTO `city_road` VALUES (1049, '西三环辅路', '610100', '西安', 1.70, 25.60, 15.40, 6.20);
INSERT INTO `city_road` VALUES (1050, '东二环路', '610100', '西安', 1.60, 38.80, 11.70, 4.60);
INSERT INTO `city_road` VALUES (1051, '公园大街', '654000', '伊犁', 1.40, 36.50, 3.70, 1.00);
INSERT INTO `city_road` VALUES (1052, '西环路', '654000', '伊犁', 1.40, 34.10, 8.70, 2.30);
INSERT INTO `city_road` VALUES (1053, '军垦路', '654000', '伊犁', 1.30, 27.90, 4.50, 1.10);
INSERT INTO `city_road` VALUES (1054, '军垦路', '654000', '伊犁', 1.30, 28.30, 4.40, 1.00);
INSERT INTO `city_road` VALUES (1055, '果园街', '654000', '伊犁', 1.30, 26.20, 5.60, 1.20);
INSERT INTO `city_road` VALUES (1056, '山东路', '654000', '伊犁', 1.30, 37.70, 7.50, 1.60);
INSERT INTO `city_road` VALUES (1057, '北京北路', '654000', '伊犁', 1.30, 35.00, 3.60, 0.70);
INSERT INTO `city_road` VALUES (1058, '阿合买提江路', '654000', '伊犁', 1.20, 38.40, 5.60, 1.10);
INSERT INTO `city_road` VALUES (1059, '公园大街', '654000', '伊犁', 1.20, 42.80, 3.10, 0.60);
INSERT INTO `city_road` VALUES (1060, '西环路', '654000', '伊犁', 1.20, 37.00, 8.00, 1.60);
INSERT INTO `city_road` VALUES (1061, '新乐路', '441300', '惠州', 2.00, 18.70, 10.20, 5.10);
INSERT INTO `city_road` VALUES (1062, '甲子路', '441300', '惠州', 1.60, 23.80, 7.70, 2.90);
INSERT INTO `city_road` VALUES (1063, '新乐路', '441300', '惠州', 1.60, 23.10, 8.20, 3.10);
INSERT INTO `city_road` VALUES (1064, '甲子路', '441300', '惠州', 1.40, 29.30, 6.20, 1.80);
INSERT INTO `city_road` VALUES (1065, '204县道', '441300', '惠州', 1.30, 35.00, 10.40, 2.30);
INSERT INTO `city_road` VALUES (1066, '和畅七路', '441300', '惠州', 1.30, 31.60, 6.80, 1.50);
INSERT INTO `city_road` VALUES (1067, '人民三路', '441300', '惠州', 1.30, 36.20, 3.80, 0.80);
INSERT INTO `city_road` VALUES (1068, '曙光路', '441300', '惠州', 1.30, 34.50, 4.20, 0.90);
INSERT INTO `city_road` VALUES (1069, '三环南路', '441300', '惠州', 1.30, 49.50, 7.40, 1.50);
INSERT INTO `city_road` VALUES (1070, '滨江东路', '441300', '惠州', 1.30, 33.10, 4.20, 0.80);
INSERT INTO `city_road` VALUES (1071, '凤仪路', '640100', '银川', 1.40, 25.20, 4.80, 1.40);
INSERT INTO `city_road` VALUES (1072, '新华东路', '640100', '银川', 1.40, 26.20, 5.00, 1.40);
INSERT INTO `city_road` VALUES (1073, '天平街', '640100', '银川', 1.30, 30.60, 5.40, 1.30);
INSERT INTO `city_road` VALUES (1074, '塔渠街', '640100', '银川', 1.30, 32.40, 4.30, 1.00);
INSERT INTO `city_road` VALUES (1075, '惠北巷', '640100', '银川', 1.30, 31.80, 5.10, 1.20);
INSERT INTO `city_road` VALUES (1076, '北京中路', '640100', '银川', 1.30, 41.80, 9.50, 2.00);
INSERT INTO `city_road` VALUES (1077, '新华东路', '640100', '银川', 1.30, 31.30, 8.30, 1.70);
INSERT INTO `city_road` VALUES (1078, '文昌南街', '640100', '银川', 1.30, 42.50, 8.20, 1.70);
INSERT INTO `city_road` VALUES (1079, '新昌东路', '640100', '银川', 1.30, 35.90, 3.70, 0.70);
INSERT INTO `city_road` VALUES (1080, '庆丰街', '640100', '银川', 1.30, 32.70, 8.20, 1.70);
INSERT INTO `city_road` VALUES (1081, '鹤鸣路', '511300', '南充', 1.20, 34.40, 5.40, 1.00);
INSERT INTO `city_road` VALUES (1082, '文峰大道', '511300', '南充', 1.20, 43.40, 3.70, 0.60);
INSERT INTO `city_road` VALUES (1083, '陈寿路', '511300', '南充', 1.20, 42.40, 3.30, 0.50);
INSERT INTO `city_road` VALUES (1084, '鹤鸣路', '511300', '南充', 1.20, 35.20, 5.40, 0.80);
INSERT INTO `city_road` VALUES (1085, '江东中路三段', '511300', '南充', 1.20, 44.30, 3.50, 0.50);
INSERT INTO `city_road` VALUES (1086, '东顺路三段', '511300', '南充', 1.20, 46.40, 3.10, 0.40);
INSERT INTO `city_road` VALUES (1087, '高都路', '511300', '南充', 1.20, 40.30, 5.80, 0.80);
INSERT INTO `city_road` VALUES (1088, '陈寿路', '511300', '南充', 1.20, 44.30, 3.20, 0.40);
INSERT INTO `city_road` VALUES (1089, '滨江中路一段', '511300', '南充', 1.10, 51.80, 2.30, 0.30);
INSERT INTO `city_road` VALUES (1090, '绕城高速', '511300', '南充', 1.10, 78.40, 7.60, 1.00);
INSERT INTO `city_road` VALUES (1091, '屏山大道', '450200', '柳州', 1.70, 24.90, 7.00, 2.90);
INSERT INTO `city_road` VALUES (1092, '文昌路', '450200', '柳州', 1.70, 32.10, 3.90, 1.50);
INSERT INTO `city_road` VALUES (1093, '永前路', '450200', '柳州', 1.50, 20.50, 9.00, 3.10);
INSERT INTO `city_road` VALUES (1094, '雅儒路', '450200', '柳州', 1.40, 24.40, 5.50, 1.60);
INSERT INTO `city_road` VALUES (1095, '永前路', '450200', '柳州', 1.40, 22.50, 8.20, 2.30);
INSERT INTO `city_road` VALUES (1096, '沿江路', '450200', '柳州', 1.40, 36.20, 3.90, 1.10);
INSERT INTO `city_road` VALUES (1097, '柳邕路', '450200', '柳州', 1.40, 30.90, 12.40, 3.50);
INSERT INTO `city_road` VALUES (1098, '雅儒路', '450200', '柳州', 1.40, 24.70, 5.40, 1.50);
INSERT INTO `city_road` VALUES (1099, '柳石路', '450200', '柳州', 1.40, 30.30, 7.40, 2.00);
INSERT INTO `city_road` VALUES (1100, '文昌路', '450200', '柳州', 1.40, 36.40, 3.40, 0.90);
INSERT INTO `city_road` VALUES (1101, '龙湖大道', '410100', '郑州', 3.00, 16.20, 13.90, 9.30);
INSERT INTO `city_road` VALUES (1102, '宏康路', '410100', '郑州', 2.80, 13.90, 13.60, 8.70);
INSERT INTO `city_road` VALUES (1103, '文昌路', '410100', '郑州', 2.60, 12.40, 18.70, 11.50);
INSERT INTO `city_road` VALUES (1104, '龙湖大道', '410100', '郑州', 2.30, 20.20, 11.20, 6.30);
INSERT INTO `city_road` VALUES (1105, '文昌路', '410100', '郑州', 1.70, 19.50, 11.90, 4.80);
INSERT INTO `city_road` VALUES (1106, '宏康路', '410100', '郑州', 1.60, 23.30, 8.10, 3.00);
INSERT INTO `city_road` VALUES (1107, '东风路', '410100', '郑州', 1.50, 28.80, 15.60, 5.00);
INSERT INTO `city_road` VALUES (1108, '康平路', '410100', '郑州', 1.40, 25.30, 6.80, 2.00);
INSERT INTO `city_road` VALUES (1109, '航海中路', '410100', '郑州', 1.40, 31.20, 8.00, 2.30);
INSERT INTO `city_road` VALUES (1110, '商城路', '410100', '郑州', 1.40, 27.70, 6.60, 1.90);
INSERT INTO `city_road` VALUES (1111, '西津东路', '620100', '兰州', 1.60, 34.40, 6.50, 2.40);
INSERT INTO `city_road` VALUES (1112, '雁西路', '620100', '兰州', 1.50, 27.10, 5.40, 1.70);
INSERT INTO `city_road` VALUES (1113, '福利东路', '620100', '兰州', 1.40, 32.20, 6.80, 2.10);
INSERT INTO `city_road` VALUES (1114, '敦煌路', '620100', '兰州', 1.40, 29.80, 4.70, 1.40);
INSERT INTO `city_road` VALUES (1115, '西津东路', '620100', '兰州', 1.40, 36.30, 6.80, 2.00);
INSERT INTO `city_road` VALUES (1116, '南滨河东路', '620100', '兰州', 1.40, 36.70, 4.90, 1.40);
INSERT INTO `city_road` VALUES (1117, '盐场路', '620100', '兰州', 1.40, 33.80, 4.70, 1.30);
INSERT INTO `city_road` VALUES (1118, '甘南路', '620100', '兰州', 1.40, 25.80, 7.20, 2.00);
INSERT INTO `city_road` VALUES (1119, '华林路', '620100', '兰州', 1.40, 24.30, 6.50, 1.80);
INSERT INTO `city_road` VALUES (1120, '建宁西路', '620100', '兰州', 1.40, 37.20, 3.70, 1.00);
INSERT INTO `city_road` VALUES (1121, '祝舜路', '370100', '济南', 2.10, 18.30, 9.90, 5.30);
INSERT INTO `city_road` VALUES (1122, '花园路', '370100', '济南', 1.80, 23.20, 11.30, 5.20);
INSERT INTO `city_road` VALUES (1123, '贞元街', '370100', '济南', 1.50, 29.80, 6.60, 2.10);
INSERT INTO `city_road` VALUES (1124, '文化东路', '370100', '济南', 1.30, 30.30, 5.90, 1.50);
INSERT INTO `city_road` VALUES (1125, '和平路', '370100', '济南', 1.30, 34.20, 5.20, 1.30);
INSERT INTO `city_road` VALUES (1126, '联四路', '370100', '济南', 1.30, 24.10, 5.40, 1.40);
INSERT INTO `city_road` VALUES (1127, '华龙路', '370100', '济南', 1.30, 31.10, 6.00, 1.50);
INSERT INTO `city_road` VALUES (1128, '经二路', '370100', '济南', 1.30, 25.50, 7.60, 1.80);
INSERT INTO `city_road` VALUES (1129, '祝舜路', '370100', '济南', 1.30, 30.00, 6.10, 1.50);
INSERT INTO `city_road` VALUES (1130, '凤箫路', '370100', '济南', 1.30, 30.80, 5.40, 1.30);
INSERT INTO `city_road` VALUES (1131, '竹溪大道', '450100', '南宁', 1.70, 42.50, 7.40, 3.00);
INSERT INTO `city_road` VALUES (1132, '青山路', '450100', '南宁', 1.50, 40.70, 3.20, 1.10);
INSERT INTO `city_road` VALUES (1133, '青秀路', '450100', '南宁', 1.50, 27.30, 4.90, 1.60);
INSERT INTO `city_road` VALUES (1134, '中华路', '450100', '南宁', 1.50, 30.90, 6.30, 2.10);
INSERT INTO `city_road` VALUES (1135, '亭洪路', '450100', '南宁', 1.40, 34.00, 12.70, 3.60);
INSERT INTO `city_road` VALUES (1136, '柳沙路', '450100', '南宁', 1.40, 29.70, 5.10, 1.40);
INSERT INTO `city_road` VALUES (1137, '五合大道', '450100', '南宁', 1.40, 35.70, 6.20, 1.60);
INSERT INTO `city_road` VALUES (1138, '新民路', '450100', '南宁', 1.30, 29.10, 5.00, 1.30);
INSERT INTO `city_road` VALUES (1139, '桃源路', '450100', '南宁', 1.30, 33.60, 4.10, 1.00);
INSERT INTO `city_road` VALUES (1140, '竹溪大道', '450100', '南宁', 1.30, 53.40, 5.90, 1.50);
INSERT INTO `city_road` VALUES (1141, '荣校路', '410700', '新乡', 1.40, 26.50, 4.80, 1.30);
INSERT INTO `city_road` VALUES (1142, '胜利中街', '410700', '新乡', 1.40, 28.30, 4.80, 1.30);
INSERT INTO `city_road` VALUES (1143, '劳动南街', '410700', '新乡', 1.40, 33.30, 8.80, 2.40);
INSERT INTO `city_road` VALUES (1144, '胜利南街', '410700', '新乡', 1.30, 32.50, 7.10, 1.80);
INSERT INTO `city_road` VALUES (1145, '金穗大道(中)', '410700', '新乡', 1.30, 33.50, 6.10, 1.40);
INSERT INTO `city_road` VALUES (1146, '劳动中街', '410700', '新乡', 1.30, 29.10, 4.70, 1.10);
INSERT INTO `city_road` VALUES (1147, '金穗大道(中)', '410700', '新乡', 1.30, 33.30, 6.20, 1.40);
INSERT INTO `city_road` VALUES (1148, '人民中路', '410700', '新乡', 1.30, 32.40, 6.00, 1.30);
INSERT INTO `city_road` VALUES (1149, '解放大道(中)', '410700', '新乡', 1.30, 31.60, 4.50, 1.00);
INSERT INTO `city_road` VALUES (1150, '荣校路', '410700', '新乡', 1.30, 29.30, 4.30, 0.90);
INSERT INTO `city_road` VALUES (1151, '东风路', '610400', '咸阳', 1.50, 29.40, 6.80, 2.40);
INSERT INTO `city_road` VALUES (1152, '人民西路', '610400', '咸阳', 1.40, 32.90, 4.90, 1.50);
INSERT INTO `city_road` VALUES (1153, '东风路', '610400', '咸阳', 1.40, 31.70, 6.30, 1.90);
INSERT INTO `city_road` VALUES (1154, '扶苏路', '610400', '咸阳', 1.40, 35.00, 5.70, 1.70);
INSERT INTO `city_road` VALUES (1155, '秦皇北路', '610400', '咸阳', 1.30, 34.50, 3.50, 0.90);
INSERT INTO `city_road` VALUES (1156, '滨河西路', '610400', '咸阳', 1.30, 35.30, 4.60, 1.10);
INSERT INTO `city_road` VALUES (1157, '人民西路', '610400', '咸阳', 1.30, 34.90, 4.70, 1.20);
INSERT INTO `city_road` VALUES (1158, '毕塬西路', '610400', '咸阳', 1.30, 30.50, 5.40, 1.20);
INSERT INTO `city_road` VALUES (1159, '世纪大道(东段)', '610400', '咸阳', 1.30, 36.80, 6.80, 1.50);
INSERT INTO `city_road` VALUES (1160, '毕塬西路', '610400', '咸阳', 1.30, 29.60, 5.50, 1.20);
INSERT INTO `city_road` VALUES (1161, '人民南路', '140100', '太原', 1.60, 32.10, 10.00, 3.90);
INSERT INTO `city_road` VALUES (1162, '亲贤北街', '140100', '太原', 1.50, 28.20, 7.50, 2.50);
INSERT INTO `city_road` VALUES (1163, '亲贤北街', '140100', '太原', 1.50, 27.50, 7.70, 2.50);
INSERT INTO `city_road` VALUES (1164, '许坦东街', '140100', '太原', 1.40, 24.40, 7.20, 2.20);
INSERT INTO `city_road` VALUES (1165, '平阳路', '140100', '太原', 1.40, 30.50, 9.40, 2.80);
INSERT INTO `city_road` VALUES (1166, '平阳南路', '140100', '太原', 1.40, 33.40, 8.60, 2.60);
INSERT INTO `city_road` VALUES (1167, '府东街', '140100', '太原', 1.30, 33.90, 9.70, 2.40);
INSERT INTO `city_road` VALUES (1168, '东岗路', '140100', '太原', 1.30, 28.00, 4.70, 1.20);
INSERT INTO `city_road` VALUES (1169, '体育路', '140100', '太原', 1.30, 34.40, 8.50, 2.10);
INSERT INTO `city_road` VALUES (1170, '坞城路', '140100', '太原', 1.30, 38.80, 4.90, 1.20);
INSERT INTO `city_road` VALUES (1171, '永固街', '140200', '大同', 1.50, 27.80, 5.00, 1.70);
INSERT INTO `city_road` VALUES (1172, '永固街', '140200', '大同', 1.40, 30.20, 4.70, 1.30);
INSERT INTO `city_road` VALUES (1173, '北苑路', '140200', '大同', 1.30, 34.60, 7.70, 1.60);
INSERT INTO `city_road` VALUES (1174, '西环路', '140200', '大同', 1.20, 43.50, 3.40, 0.70);
INSERT INTO `city_road` VALUES (1175, '红旗街', '140200', '大同', 1.20, 29.30, 6.00, 1.10);
INSERT INTO `city_road` VALUES (1176, '永泰南路', '140200', '大同', 1.20, 37.20, 6.70, 1.20);
INSERT INTO `city_road` VALUES (1177, '红旗街', '140200', '大同', 1.20, 29.40, 5.90, 1.00);
INSERT INTO `city_road` VALUES (1178, '永和路', '140200', '大同', 1.20, 37.40, 10.60, 1.70);
INSERT INTO `city_road` VALUES (1179, '向阳街', '140200', '大同', 1.20, 34.50, 6.60, 1.00);
INSERT INTO `city_road` VALUES (1180, '向阳街', '140200', '大同', 1.20, 34.90, 6.50, 1.00);
INSERT INTO `city_road` VALUES (1181, '和平路', '440300', '深圳', 2.80, 13.80, 12.90, 8.30);
INSERT INTO `city_road` VALUES (1182, '深南东路', '440300', '深圳', 1.90, 21.70, 10.40, 5.00);
INSERT INTO `city_road` VALUES (1183, '金田路', '440300', '深圳', 1.70, 23.70, 9.10, 3.70);
INSERT INTO `city_road` VALUES (1184, '固戍一路', '440300', '深圳', 1.60, 15.70, 11.90, 4.60);
INSERT INTO `city_road` VALUES (1185, '吉华路', '440300', '深圳', 1.60, 21.40, 8.80, 3.40);
INSERT INTO `city_road` VALUES (1186, '天宝路', '440300', '深圳', 1.60, 19.30, 7.60, 2.90);
INSERT INTO `city_road` VALUES (1187, '翻身路', '440300', '深圳', 1.50, 22.20, 8.60, 2.90);
INSERT INTO `city_road` VALUES (1188, '河堤路', '440300', '深圳', 1.50, 26.40, 10.40, 3.50);
INSERT INTO `city_road` VALUES (1189, '裕安二路', '440300', '深圳', 1.50, 20.30, 6.40, 2.10);
INSERT INTO `city_road` VALUES (1190, '固戍二路', '440300', '深圳', 1.50, 20.30, 7.90, 2.60);
INSERT INTO `city_road` VALUES (1191, '工业北路', '411300', '南阳', 2.00, 21.10, 7.90, 3.90);
INSERT INTO `city_road` VALUES (1192, '新华东路', '411300', '南阳', 1.40, 26.00, 6.60, 2.00);
INSERT INTO `city_road` VALUES (1193, '新华东路', '411300', '南阳', 1.40, 26.40, 6.50, 1.70);
INSERT INTO `city_road` VALUES (1194, '七一路', '411300', '南阳', 1.30, 31.20, 4.70, 1.20);
INSERT INTO `city_road` VALUES (1195, '范蠡西路', '411300', '南阳', 1.30, 30.90, 4.50, 1.10);
INSERT INTO `city_road` VALUES (1196, '人民南路', '411300', '南阳', 1.30, 30.60, 5.20, 1.30);
INSERT INTO `city_road` VALUES (1197, '车站北路', '411300', '南阳', 1.30, 33.00, 4.40, 1.00);
INSERT INTO `city_road` VALUES (1198, '范蠡西路', '411300', '南阳', 1.30, 30.60, 4.60, 1.10);
INSERT INTO `city_road` VALUES (1199, '工业北路', '411300', '南阳', 1.30, 31.40, 4.30, 1.00);
INSERT INTO `city_road` VALUES (1200, '人民南路', '411300', '南阳', 1.30, 30.50, 5.30, 1.20);
INSERT INTO `city_road` VALUES (1201, '荷花路', '430100', '长沙', 1.70, 21.10, 7.70, 3.20);
INSERT INTO `city_road` VALUES (1202, '中意一路', '430100', '长沙', 1.60, 24.40, 8.60, 3.10);
INSERT INTO `city_road` VALUES (1203, '迎新路', '430100', '长沙', 1.50, 24.20, 5.50, 1.70);
INSERT INTO `city_road` VALUES (1204, '芙蓉中路', '430100', '长沙', 1.40, 33.20, 16.50, 5.10);
INSERT INTO `city_road` VALUES (1205, '三一大道', '430100', '长沙', 1.40, 41.50, 14.80, 4.30);
INSERT INTO `city_road` VALUES (1206, '开福大道', '430100', '长沙', 1.40, 35.90, 25.80, 7.50);
INSERT INTO `city_road` VALUES (1207, '万家丽南路', '430100', '长沙', 1.40, 34.40, 9.10, 2.60);
INSERT INTO `city_road` VALUES (1208, '枫林一路', '430100', '长沙', 1.40, 35.10, 4.10, 1.10);
INSERT INTO `city_road` VALUES (1209, '枫林一路', '430100', '长沙', 1.40, 37.60, 3.80, 1.00);
INSERT INTO `city_road` VALUES (1210, '古曲南路', '430100', '长沙', 1.40, 29.20, 4.30, 1.20);
INSERT INTO `city_road` VALUES (1211, '江东中路', '440900', '茂名', 1.40, 28.20, 4.40, 1.20);
INSERT INTO `city_road` VALUES (1212, '迎宾大道', '440900', '茂名', 1.40, 34.80, 4.90, 1.30);
INSERT INTO `city_road` VALUES (1213, '新湖路', '440900', '茂名', 1.30, 31.40, 3.90, 1.00);
INSERT INTO `city_road` VALUES (1214, '西粤中路', '440900', '茂名', 1.30, 31.00, 4.00, 1.00);
INSERT INTO `city_road` VALUES (1215, '金城路', '440900', '茂名', 1.30, 33.40, 4.50, 1.10);
INSERT INTO `city_road` VALUES (1216, '光华北路', '440900', '茂名', 1.30, 33.20, 4.10, 1.00);
INSERT INTO `city_road` VALUES (1217, '光华北路', '440900', '茂名', 1.30, 35.10, 3.80, 0.90);
INSERT INTO `city_road` VALUES (1218, '西粤中路', '440900', '茂名', 1.30, 33.30, 3.70, 0.80);
INSERT INTO `city_road` VALUES (1219, '红旗北路', '440900', '茂名', 1.30, 35.90, 4.20, 0.90);
INSERT INTO `city_road` VALUES (1220, '人民路', '440900', '茂名', 1.20, 37.20, 12.30, 2.30);
INSERT INTO `city_road` VALUES (1221, '鹤龙二路', '440100', '广州', 3.40, 12.00, 17.30, 12.20);
INSERT INTO `city_road` VALUES (1222, '鹤龙四路', '440100', '广州', 2.90, 15.20, 9.00, 5.90);
INSERT INTO `city_road` VALUES (1223, '逸景路', '440100', '广州', 2.70, 14.90, 8.10, 5.10);
INSERT INTO `city_road` VALUES (1224, '新滘西路', '440100', '广州', 2.60, 23.90, 9.60, 5.80);
INSERT INTO `city_road` VALUES (1225, '逸景路', '440100', '广州', 2.30, 17.70, 6.90, 3.90);
INSERT INTO `city_road` VALUES (1226, '花地大道南', '440100', '广州', 2.20, 24.20, 8.20, 4.50);
INSERT INTO `city_road` VALUES (1227, '鹤龙二路', '440100', '广州', 2.10, 19.70, 10.60, 5.60);
INSERT INTO `city_road` VALUES (1228, '广州大道北', '440100', '广州', 1.90, 26.70, 13.40, 6.50);
INSERT INTO `city_road` VALUES (1229, 'S15广佛高速', '440100', '广州', 1.90, 31.40, 4.40, 2.10);
INSERT INTO `city_road` VALUES (1230, '华洲路', '440100', '广州', 1.90, 14.20, 12.70, 5.90);
INSERT INTO `city_road` VALUES (1231, '油漆厂路', '130400', '邯郸', 1.60, 20.60, 6.00, 2.40);
INSERT INTO `city_road` VALUES (1232, '油漆厂路', '130400', '邯郸', 1.40, 25.10, 4.90, 1.30);
INSERT INTO `city_road` VALUES (1233, '和平路', '130400', '邯郸', 1.30, 26.90, 12.30, 3.00);
INSERT INTO `city_road` VALUES (1234, '和平路', '130400', '邯郸', 1.30, 27.60, 11.90, 2.80);
INSERT INTO `city_road` VALUES (1235, '光明南大街', '130400', '邯郸', 1.30, 30.80, 5.40, 1.20);
INSERT INTO `city_road` VALUES (1236, '水厂路', '130400', '邯郸', 1.30, 31.50, 7.50, 1.50);
INSERT INTO `city_road` VALUES (1237, '铁西南大街', '130400', '邯郸', 1.20, 35.50, 3.90, 0.80);
INSERT INTO `city_road` VALUES (1238, '滏东北大街', '130400', '邯郸', 1.20, 36.40, 9.70, 1.90);
INSERT INTO `city_road` VALUES (1239, '光明北大街', '130400', '邯郸', 1.20, 32.20, 4.90, 1.00);
INSERT INTO `city_road` VALUES (1240, '丛台路', '130400', '邯郸', 1.20, 32.40, 13.10, 2.50);
INSERT INTO `city_road` VALUES (1241, '南方路', '440800', '湛江', 1.80, 23.40, 5.50, 2.40);
INSERT INTO `city_road` VALUES (1242, '金康中路', '440800', '湛江', 1.40, 36.70, 4.10, 1.30);
INSERT INTO `city_road` VALUES (1243, '乐金路', '440800', '湛江', 1.40, 30.50, 4.10, 1.10);
INSERT INTO `city_road` VALUES (1244, '绿华路', '440800', '湛江', 1.30, 34.40, 5.10, 1.30);
INSERT INTO `city_road` VALUES (1245, '海滨大道南', '440800', '湛江', 1.30, 31.00, 5.30, 1.30);
INSERT INTO `city_road` VALUES (1246, '人民大道南', '440800', '湛江', 1.30, 33.10, 5.60, 1.30);
INSERT INTO `city_road` VALUES (1247, '绿华路', '440800', '湛江', 1.30, 36.70, 4.80, 1.10);
INSERT INTO `city_road` VALUES (1248, '体育南路', '440800', '湛江', 1.30, 40.10, 4.70, 1.00);
INSERT INTO `city_road` VALUES (1249, '人民大道中', '440800', '湛江', 1.30, 39.20, 5.60, 1.20);
INSERT INTO `city_road` VALUES (1250, '人民大道北', '440800', '湛江', 1.30, 42.50, 5.10, 1.00);
INSERT INTO `city_road` VALUES (1251, '利民街', '130600', '保定', 1.40, 30.30, 5.90, 1.60);
INSERT INTO `city_road` VALUES (1252, '天威中路', '130600', '保定', 1.30, 33.90, 5.80, 1.40);
INSERT INTO `city_road` VALUES (1253, '永华南大街', '130600', '保定', 1.30, 28.80, 5.20, 1.20);
INSERT INTO `city_road` VALUES (1254, '裕华西路', '130600', '保定', 1.30, 29.00, 4.70, 1.00);
INSERT INTO `city_road` VALUES (1255, '利民街', '130600', '保定', 1.30, 32.00, 5.60, 1.20);
INSERT INTO `city_road` VALUES (1256, '瑞祥大街', '130600', '保定', 1.20, 32.60, 10.70, 2.00);
INSERT INTO `city_road` VALUES (1257, '建华大街', '130600', '保定', 1.20, 32.60, 5.70, 1.10);
INSERT INTO `city_road` VALUES (1258, '永华南大街', '130600', '保定', 1.20, 30.50, 5.00, 0.90);
INSERT INTO `city_road` VALUES (1259, '复兴东路', '130600', '保定', 1.20, 42.90, 4.00, 0.70);
INSERT INTO `city_road` VALUES (1260, '永华北大街', '130600', '保定', 1.20, 33.90, 3.90, 0.70);
INSERT INTO `city_road` VALUES (1261, '建设大道', '440600', '佛山', 1.80, 19.30, 6.30, 2.80);
INSERT INTO `city_road` VALUES (1262, '佛山大道中', '440600', '佛山', 1.50, 41.40, 7.50, 2.70);
INSERT INTO `city_road` VALUES (1263, '海北大道', '440600', '佛山', 1.40, 29.70, 5.70, 1.60);
INSERT INTO `city_road` VALUES (1264, '联星大道', '440600', '佛山', 1.40, 19.60, 6.60, 1.80);
INSERT INTO `city_road` VALUES (1265, '河西大道', '440600', '佛山', 1.40, 21.80, 5.90, 1.60);
INSERT INTO `city_road` VALUES (1266, '广佛路', '440600', '佛山', 1.40, 32.90, 21.70, 5.90);
INSERT INTO `city_road` VALUES (1267, '新有中路', '440600', '佛山', 1.40, 28.20, 5.30, 1.40);
INSERT INTO `city_road` VALUES (1268, '盐秀路', '440600', '佛山', 1.40, 23.80, 6.10, 1.60);
INSERT INTO `city_road` VALUES (1269, '里水大道南', '440600', '佛山', 1.30, 34.00, 8.70, 2.30);
INSERT INTO `city_road` VALUES (1270, '佛山大道北', '440600', '佛山', 1.30, 47.90, 4.80, 1.20);
INSERT INTO `city_road` VALUES (1271, 'G5京昆高速', '510600', '德阳', 1.60, 56.60, 75.30, 29.20);
INSERT INTO `city_road` VALUES (1272, '岷山路二段', '510600', '德阳', 1.20, 38.60, 4.20, 0.80);
INSERT INTO `city_road` VALUES (1273, '岷山路二段', '510600', '德阳', 1.20, 38.10, 4.30, 0.80);
INSERT INTO `city_road` VALUES (1274, '庐山路', '510600', '德阳', 1.20, 39.20, 3.10, 0.50);
INSERT INTO `city_road` VALUES (1275, '龙泉山路', '510600', '德阳', 1.20, 40.40, 5.20, 0.80);
INSERT INTO `city_road` VALUES (1276, '泰山南路二段', '510600', '德阳', 1.20, 41.30, 4.40, 0.70);
INSERT INTO `city_road` VALUES (1277, '天山路', '510600', '德阳', 1.20, 36.40, 5.20, 0.70);
INSERT INTO `city_road` VALUES (1278, '庐山南路', '510600', '德阳', 1.20, 43.60, 9.10, 1.30);
INSERT INTO `city_road` VALUES (1279, '泰山南路二段', '510600', '德阳', 1.10, 40.70, 4.50, 0.60);
INSERT INTO `city_road` VALUES (1280, '玉泉路', '510600', '德阳', 1.10, 34.20, 3.60, 0.50);
INSERT INTO `city_road` VALUES (1281, '金朗南路', '441900', '东莞', 2.70, 16.30, 8.40, 5.30);
INSERT INTO `city_road` VALUES (1282, '康乐路', '441900', '东莞', 2.60, 19.20, 7.40, 4.50);
INSERT INTO `city_road` VALUES (1283, '恒泉路', '441900', '东莞', 2.20, 16.80, 9.10, 5.00);
INSERT INTO `city_road` VALUES (1284, '迎宾路', '441900', '东莞', 2.10, 25.80, 5.50, 2.80);
INSERT INTO `city_road` VALUES (1285, '松水路', '441900', '东莞', 1.90, 18.90, 10.60, 5.00);
INSERT INTO `city_road` VALUES (1286, '金宁路', '441900', '东莞', 1.80, 24.10, 9.30, 4.10);
INSERT INTO `city_road` VALUES (1287, '东大路', '441900', '东莞', 1.80, 16.90, 7.40, 3.30);
INSERT INTO `city_road` VALUES (1288, '东大路', '441900', '东莞', 1.70, 18.30, 6.80, 2.70);
INSERT INTO `city_road` VALUES (1289, '鸿福路', '441900', '东莞', 1.60, 29.00, 4.50, 1.70);
INSERT INTO `city_road` VALUES (1290, '中兴路', '441900', '东莞', 1.60, 20.90, 6.40, 2.30);
INSERT INTO `city_road` VALUES (1291, '长兴街', '410300', '洛阳', 1.60, 24.00, 8.90, 3.30);
INSERT INTO `city_road` VALUES (1292, '珠江路', '410300', '洛阳', 1.50, 22.70, 6.70, 2.10);
INSERT INTO `city_road` VALUES (1293, '珠江路', '410300', '洛阳', 1.40, 23.50, 6.50, 1.90);
INSERT INTO `city_road` VALUES (1294, '洛宜路', '410300', '洛阳', 1.40, 27.10, 10.40, 3.00);
INSERT INTO `city_road` VALUES (1295, '唐宫东路', '410300', '洛阳', 1.40, 24.40, 6.80, 2.00);
INSERT INTO `city_road` VALUES (1296, '丽春东路', '410300', '洛阳', 1.40, 26.30, 6.50, 1.80);
INSERT INTO `city_road` VALUES (1297, '洛宜路', '410300', '洛阳', 1.30, 27.10, 10.40, 2.60);
INSERT INTO `city_road` VALUES (1298, '唐宫西路', '410300', '洛阳', 1.30, 28.00, 7.10, 1.80);
INSERT INTO `city_road` VALUES (1299, '丽新路', '410300', '洛阳', 1.30, 27.60, 5.60, 1.40);
INSERT INTO `city_road` VALUES (1300, '中州中路', '410300', '洛阳', 1.30, 33.40, 9.00, 2.10);
INSERT INTO `city_road` VALUES (1301, '永丰道', '131000', '廊坊', 1.30, 30.60, 4.50, 1.00);
INSERT INTO `city_road` VALUES (1302, '银河南路', '131000', '廊坊', 1.30, 38.90, 6.40, 1.30);
INSERT INTO `city_road` VALUES (1303, '永华道', '131000', '廊坊', 1.20, 34.20, 4.40, 0.80);
INSERT INTO `city_road` VALUES (1304, '光明东道', '131000', '廊坊', 1.20, 43.30, 9.70, 1.70);
INSERT INTO `city_road` VALUES (1305, '银河南路', '131000', '廊坊', 1.20, 42.80, 5.90, 1.00);
INSERT INTO `city_road` VALUES (1306, '爱民西道', '131000', '廊坊', 1.20, 36.20, 4.70, 0.80);
INSERT INTO `city_road` VALUES (1307, '永华道', '131000', '廊坊', 1.20, 34.70, 4.30, 0.70);
INSERT INTO `city_road` VALUES (1308, '金光西道', '131000', '廊坊', 1.20, 38.20, 3.70, 0.60);
INSERT INTO `city_road` VALUES (1309, '新源道', '131000', '廊坊', 1.20, 34.50, 8.20, 1.30);
INSERT INTO `city_road` VALUES (1310, '东安路', '131000', '廊坊', 1.20, 37.70, 9.30, 1.40);
INSERT INTO `city_road` VALUES (1311, '三八中路', '371400', '德州', 1.30, 32.80, 7.20, 1.70);
INSERT INTO `city_road` VALUES (1312, '湖滨中大道', '371400', '德州', 1.30, 34.30, 5.00, 1.10);
INSERT INTO `city_road` VALUES (1313, '湖滨南大道', '371400', '德州', 1.30, 35.20, 5.70, 1.30);
INSERT INTO `city_road` VALUES (1314, '育英大街', '371400', '德州', 1.30, 30.00, 7.50, 1.60);
INSERT INTO `city_road` VALUES (1315, '湖滨中大道', '371400', '德州', 1.20, 33.70, 5.10, 1.00);
INSERT INTO `city_road` VALUES (1316, '德兴中大道', '371400', '德州', 1.20, 35.60, 5.00, 0.90);
INSERT INTO `city_road` VALUES (1317, 'G3京台高速', '371400', '德州', 1.20, 89.20, 67.10, 10.70);
INSERT INTO `city_road` VALUES (1318, '东方红西路', '371400', '德州', 1.20, 38.30, 5.80, 0.80);
INSERT INTO `city_road` VALUES (1319, '湖滨南大道', '371400', '德州', 1.20, 38.50, 5.10, 0.70);
INSERT INTO `city_road` VALUES (1320, '新河路', '371400', '德州', 1.20, 38.70, 3.90, 0.50);
INSERT INTO `city_road` VALUES (1321, '大学东路', '441800', '清远', 1.40, 37.50, 8.10, 2.30);
INSERT INTO `city_road` VALUES (1322, '东岗路', '441800', '清远', 1.30, 27.70, 10.00, 2.50);
INSERT INTO `city_road` VALUES (1323, '东岗路', '441800', '清远', 1.30, 29.80, 9.30, 2.00);
INSERT INTO `city_road` VALUES (1324, '凤翔中路', '441800', '清远', 1.30, 40.40, 6.90, 1.50);
INSERT INTO `city_road` VALUES (1325, '松鹤大街', '441800', '清远', 1.20, 33.80, 4.70, 0.90);
INSERT INTO `city_road` VALUES (1326, '大学西路', '441800', '清远', 1.20, 36.30, 6.10, 1.00);
INSERT INTO `city_road` VALUES (1327, '北江二路', '441800', '清远', 1.20, 42.30, 3.70, 0.60);
INSERT INTO `city_road` VALUES (1328, '桥北路', '441800', '清远', 1.20, 41.70, 4.30, 0.70);
INSERT INTO `city_road` VALUES (1329, '北江一路', '441800', '清远', 1.20, 45.50, 4.00, 0.60);
INSERT INTO `city_road` VALUES (1330, '大学西路', '441800', '清远', 1.20, 36.60, 6.00, 1.00);
INSERT INTO `city_road` VALUES (1331, '广珠公路', '442000', '中山', 1.80, 35.20, 11.60, 5.10);
INSERT INTO `city_road` VALUES (1332, '东镇东一路', '442000', '中山', 1.40, 31.90, 5.70, 1.70);
INSERT INTO `city_road` VALUES (1333, '岐江公路', '442000', '中山', 1.30, 32.80, 9.80, 2.50);
INSERT INTO `city_road` VALUES (1334, '新兴大道中', '442000', '中山', 1.30, 28.30, 5.00, 1.20);
INSERT INTO `city_road` VALUES (1335, '广珠公路', '442000', '中山', 1.30, 49.00, 8.30, 2.00);
INSERT INTO `city_road` VALUES (1336, '同安大道东', '442000', '中山', 1.30, 22.70, 5.90, 1.40);
INSERT INTO `city_road` VALUES (1337, '东富路', '442000', '中山', 1.30, 27.40, 5.60, 1.30);
INSERT INTO `city_road` VALUES (1338, '广成路', '442000', '中山', 1.30, 30.80, 9.60, 2.20);
INSERT INTO `city_road` VALUES (1339, '升辉南路', '442000', '中山', 1.30, 29.00, 5.70, 1.20);
INSERT INTO `city_road` VALUES (1340, '联丰南路', '442000', '中山', 1.30, 34.70, 5.00, 1.10);
INSERT INTO `city_road` VALUES (1341, '布尔台格路', '150600', '鄂尔多斯', 1.30, 30.50, 4.10, 1.00);
INSERT INTO `city_road` VALUES (1342, '伊煤路', '150600', '鄂尔多斯', 1.30, 37.40, 8.40, 1.70);
INSERT INTO `city_road` VALUES (1343, '杭锦北路', '150600', '鄂尔多斯', 1.20, 35.30, 4.20, 0.70);
INSERT INTO `city_road` VALUES (1344, '吉劳庆北路', '150600', '鄂尔多斯', 1.20, 33.00, 3.90, 0.70);
INSERT INTO `city_road` VALUES (1345, '伊化北路', '150600', '鄂尔多斯', 1.20, 37.00, 4.70, 0.80);
INSERT INTO `city_road` VALUES (1346, '吉劳庆北路', '150600', '鄂尔多斯', 1.20, 33.80, 3.90, 0.60);
INSERT INTO `city_road` VALUES (1347, '文明西街', '150600', '鄂尔多斯', 1.20, 49.50, 6.30, 0.90);
INSERT INTO `city_road` VALUES (1348, '准格尔北路', '150600', '鄂尔多斯', 1.20, 39.00, 3.50, 0.50);
INSERT INTO `city_road` VALUES (1349, '鄂尔多斯西街', '150600', '鄂尔多斯', 1.20, 38.50, 6.70, 0.90);
INSERT INTO `city_road` VALUES (1350, '阿勒腾席热路', '150600', '鄂尔多斯', 1.20, 40.70, 5.00, 0.70);
INSERT INTO `city_road` VALUES (1351, '泉南东大街', '130500', '邢台', 1.40, 33.30, 5.40, 1.60);
INSERT INTO `city_road` VALUES (1352, '育才路', '130500', '邢台', 1.30, 26.50, 4.60, 1.10);
INSERT INTO `city_road` VALUES (1353, '守敬北路', '130500', '邢台', 1.30, 35.60, 3.90, 0.80);
INSERT INTO `city_road` VALUES (1354, '泉北西大街', '130500', '邢台', 1.30, 40.20, 7.80, 1.60);
INSERT INTO `city_road` VALUES (1355, '守敬北路', '130500', '邢台', 1.20, 34.90, 3.90, 0.80);
INSERT INTO `city_road` VALUES (1356, '开元南路', '130500', '邢台', 1.20, 36.90, 5.60, 1.10);
INSERT INTO `city_road` VALUES (1357, '开元南路', '130500', '邢台', 1.20, 37.50, 5.50, 1.00);
INSERT INTO `city_road` VALUES (1358, '红星街', '130500', '邢台', 1.20, 31.20, 4.90, 0.90);
INSERT INTO `city_road` VALUES (1359, '冶金北路', '130500', '邢台', 1.20, 37.50, 7.40, 1.30);
INSERT INTO `city_road` VALUES (1360, '红星街', '130500', '邢台', 1.20, 31.20, 4.90, 0.80);
INSERT INTO `city_road` VALUES (1361, 'G78汕昆高速', '530100', '昆明', 2.30, 39.50, 43.40, 24.40);
INSERT INTO `city_road` VALUES (1362, '虹桥路辅路', '530100', '昆明', 1.90, 26.00, 5.00, 2.40);
INSERT INTO `city_road` VALUES (1363, '昆洛路', '530100', '昆明', 1.80, 19.40, 9.00, 3.90);
INSERT INTO `city_road` VALUES (1364, '永中路', '530100', '昆明', 1.80, 20.50, 9.50, 4.10);
INSERT INTO `city_road` VALUES (1365, '二环快速A线(东)', '530100', '昆明', 1.70, 45.60, 6.90, 2.90);
INSERT INTO `city_road` VALUES (1366, '福德路', '530100', '昆明', 1.70, 17.00, 7.90, 3.20);
INSERT INTO `city_road` VALUES (1367, '昆洛路', '530100', '昆明', 1.70, 19.70, 8.90, 3.60);
INSERT INTO `city_road` VALUES (1368, '二环快速B线(南)', '530100', '昆明', 1.60, 48.50, 8.70, 3.40);
INSERT INTO `city_road` VALUES (1369, 'G78汕昆高速', '530100', '昆明', 1.60, 51.10, 5.90, 2.30);
INSERT INTO `city_road` VALUES (1370, '海屯路', '530100', '昆明', 1.60, 23.40, 8.00, 3.10);
INSERT INTO `city_road` VALUES (1371, '南昌中路', '350600', '漳州', 1.30, 29.60, 4.10, 1.10);
INSERT INTO `city_road` VALUES (1372, '大学路', '350600', '漳州', 1.30, 31.50, 4.60, 1.20);
INSERT INTO `city_road` VALUES (1373, '南昌中路', '350600', '漳州', 1.30, 29.90, 4.10, 1.00);
INSERT INTO `city_road` VALUES (1374, '芝山路', '350600', '漳州', 1.30, 37.60, 3.40, 0.70);
INSERT INTO `city_road` VALUES (1375, '西洋坪路', '350600', '漳州', 1.30, 41.60, 5.90, 1.20);
INSERT INTO `city_road` VALUES (1376, '胜利西路', '350600', '漳州', 1.30, 38.40, 7.80, 1.60);
INSERT INTO `city_road` VALUES (1377, '胜利东路', '350600', '漳州', 1.30, 36.00, 3.40, 0.70);
INSERT INTO `city_road` VALUES (1378, '新浦路', '350600', '漳州', 1.20, 29.80, 5.40, 1.00);
INSERT INTO `city_road` VALUES (1379, '丹霞路', '350600', '漳州', 1.20, 33.10, 6.20, 1.10);
INSERT INTO `city_road` VALUES (1380, '腾飞路', '350600', '漳州', 1.20, 33.90, 7.20, 1.30);
INSERT INTO `city_road` VALUES (1381, '共和路', '630100', '西宁', 1.40, 28.10, 4.50, 1.20);
INSERT INTO `city_road` VALUES (1382, '西关大街', '630100', '西宁', 1.40, 32.40, 14.10, 3.80);
INSERT INTO `city_road` VALUES (1383, '青海大学路', '630100', '西宁', 1.40, 31.30, 4.00, 1.00);
INSERT INTO `city_road` VALUES (1384, '五四大街', '630100', '西宁', 1.30, 33.00, 4.10, 1.10);
INSERT INTO `city_road` VALUES (1385, '七一路', '630100', '西宁', 1.30, 35.70, 5.30, 1.10);
INSERT INTO `city_road` VALUES (1386, '青海大学路', '630100', '西宁', 1.30, 34.40, 3.60, 0.80);
INSERT INTO `city_road` VALUES (1387, '长江路', '630100', '西宁', 1.30, 34.30, 4.00, 0.80);
INSERT INTO `city_road` VALUES (1388, '宁张路', '630100', '西宁', 1.20, 49.40, 4.30, 0.80);
INSERT INTO `city_road` VALUES (1389, '德令哈路', '630100', '西宁', 1.20, 33.80, 5.80, 1.00);
INSERT INTO `city_road` VALUES (1390, '昆仑西路', '630100', '西宁', 1.20, 49.90, 6.50, 1.10);
INSERT INTO `city_road` VALUES (1391, '大湾北路', '650100', '乌鲁木齐', 1.40, 27.30, 7.30, 2.20);
INSERT INTO `city_road` VALUES (1392, '仓房沟北路', '650100', '乌鲁木齐', 1.40, 28.10, 4.90, 1.40);
INSERT INTO `city_road` VALUES (1393, '幸福路', '650100', '乌鲁木齐', 1.40, 31.00, 4.10, 1.10);
INSERT INTO `city_road` VALUES (1394, '鲤鱼山南路', '650100', '乌鲁木齐', 1.40, 30.40, 9.20, 2.50);
INSERT INTO `city_road` VALUES (1395, '鲤鱼山南路', '650100', '乌鲁木齐', 1.40, 29.50, 9.50, 2.60);
INSERT INTO `city_road` VALUES (1396, '观园路辅路', '650100', '乌鲁木齐', 1.40, 37.60, 6.90, 1.80);
INSERT INTO `city_road` VALUES (1397, '北京中路', '650100', '乌鲁木齐', 1.30, 37.80, 3.80, 1.00);
INSERT INTO `city_road` VALUES (1398, '仓房沟北路', '650100', '乌鲁木齐', 1.30, 29.20, 4.70, 1.20);
INSERT INTO `city_road` VALUES (1399, '红山路', '650100', '乌鲁木齐', 1.30, 32.10, 7.70, 1.90);
INSERT INTO `city_road` VALUES (1400, '杭州东街', '650100', '乌鲁木齐', 1.30, 29.00, 4.60, 1.10);
INSERT INTO `city_road` VALUES (1401, '鲸川路', '130900', '沧州', 1.30, 32.10, 5.50, 1.30);
INSERT INTO `city_road` VALUES (1402, '永安南大道', '130900', '沧州', 1.30, 34.30, 7.70, 1.70);
INSERT INTO `city_road` VALUES (1403, '永安南大道', '130900', '沧州', 1.30, 35.20, 7.50, 1.60);
INSERT INTO `city_road` VALUES (1404, '清池北大道', '130900', '沧州', 1.30, 41.00, 5.80, 1.20);
INSERT INTO `city_road` VALUES (1405, '浮阳南大道', '130900', '沧州', 1.30, 35.50, 7.30, 1.50);
INSERT INTO `city_road` VALUES (1406, '永安北大道', '130900', '沧州', 1.20, 42.10, 5.70, 1.00);
INSERT INTO `city_road` VALUES (1407, '解放西路', '130900', '沧州', 1.20, 42.80, 9.40, 1.50);
INSERT INTO `city_road` VALUES (1408, '浮阳南大道', '130900', '沧州', 1.20, 38.50, 6.70, 1.10);
INSERT INTO `city_road` VALUES (1409, '开元南大道', '130900', '沧州', 1.20, 39.60, 6.90, 1.10);
INSERT INTO `city_road` VALUES (1410, '解放东路', '130900', '沧州', 1.20, 39.20, 7.00, 1.00);
INSERT INTO `city_road` VALUES (1411, '丰州南路', '150100', '呼和浩特', 1.40, 29.20, 9.80, 3.00);
INSERT INTO `city_road` VALUES (1412, '展览馆西路', '150100', '呼和浩特', 1.40, 23.70, 5.50, 1.60);
INSERT INTO `city_road` VALUES (1413, '展览馆西路', '150100', '呼和浩特', 1.30, 25.30, 5.20, 1.20);
INSERT INTO `city_road` VALUES (1414, '海拉尔大街辅路', '150100', '呼和浩特', 1.30, 37.10, 3.90, 0.90);
INSERT INTO `city_road` VALUES (1415, '学苑西街', '150100', '呼和浩特', 1.30, 33.30, 4.70, 1.10);
INSERT INTO `city_road` VALUES (1416, '海拉尔大街辅路', '150100', '呼和浩特', 1.30, 39.90, 5.00, 1.00);
INSERT INTO `city_road` VALUES (1417, '腾飞北路', '150100', '呼和浩特', 1.20, 37.70, 3.90, 0.80);
INSERT INTO `city_road` VALUES (1418, '海拉尔东街辅路', '150100', '呼和浩特', 1.20, 38.10, 5.80, 1.20);
INSERT INTO `city_road` VALUES (1419, '人民路', '150100', '呼和浩特', 1.20, 27.30, 5.00, 1.00);
INSERT INTO `city_road` VALUES (1420, '丁香南路', '150100', '呼和浩特', 1.20, 36.90, 5.60, 1.10);
INSERT INTO `city_road` VALUES (1421, '远洋路', '350100', '福州', 1.70, 39.70, 4.70, 1.80);
INSERT INTO `city_road` VALUES (1422, '浦上大道', '350100', '福州', 1.50, 43.10, 9.60, 3.10);
INSERT INTO `city_road` VALUES (1423, '西二环北路', '350100', '福州', 1.40, 40.60, 3.20, 1.00);
INSERT INTO `city_road` VALUES (1424, '金洲南路', '350100', '福州', 1.40, 31.00, 6.80, 2.00);
INSERT INTO `city_road` VALUES (1425, '连江北路', '350100', '福州', 1.40, 48.10, 3.90, 1.10);
INSERT INTO `city_road` VALUES (1426, '工业路', '350100', '福州', 1.40, 37.30, 6.30, 1.80);
INSERT INTO `city_road` VALUES (1427, '吴航路', '350100', '福州', 1.40, 35.20, 4.30, 1.20);
INSERT INTO `city_road` VALUES (1428, '花溪中路', '350100', '福州', 1.40, 30.30, 4.60, 1.30);
INSERT INTO `city_road` VALUES (1429, '连江北路', '350100', '福州', 1.40, 48.90, 3.80, 1.00);
INSERT INTO `city_road` VALUES (1430, '上三路', '350100', '福州', 1.40, 33.70, 3.60, 1.00);
INSERT INTO `city_road` VALUES (1431, '瞿任路', '330300', '温州', 2.50, 15.80, 8.90, 5.30);
INSERT INTO `city_road` VALUES (1432, '景德西路', '330300', '温州', 1.90, 23.80, 10.30, 5.00);
INSERT INTO `city_road` VALUES (1433, '温瞿东路', '330300', '温州', 1.90, 23.60, 13.40, 6.40);
INSERT INTO `city_road` VALUES (1434, '瞿任路', '330300', '温州', 1.70, 23.50, 6.00, 2.40);
INSERT INTO `city_road` VALUES (1435, '西山东路', '330300', '温州', 1.70, 26.30, 4.60, 1.80);
INSERT INTO `city_road` VALUES (1436, '三溪路', '330300', '温州', 1.60, 25.30, 4.70, 1.80);
INSERT INTO `city_road` VALUES (1437, '豪达路', '330300', '温州', 1.60, 25.40, 5.00, 1.90);
INSERT INTO `city_road` VALUES (1438, '温瞿西路', '330300', '温州', 1.50, 25.30, 9.40, 3.10);
INSERT INTO `city_road` VALUES (1439, '双塔路', '330300', '温州', 1.50, 24.30, 16.40, 5.20);
INSERT INTO `city_road` VALUES (1440, '瓯海大道', '330300', '温州', 1.30, 51.60, 46.70, 12.00);
INSERT INTO `city_road` VALUES (1441, '金凤东路', '440500', '汕头', 3.00, 20.90, 12.00, 8.00);
INSERT INTO `city_road` VALUES (1442, '金湖路', '440500', '汕头', 1.80, 21.90, 9.40, 4.30);
INSERT INTO `city_road` VALUES (1443, '天山南路', '440500', '汕头', 1.60, 28.20, 6.10, 2.20);
INSERT INTO `city_road` VALUES (1444, '护堤路', '440500', '汕头', 1.50, 29.30, 16.60, 5.30);
INSERT INTO `city_road` VALUES (1445, '长平路', '440500', '汕头', 1.40, 25.20, 5.30, 1.50);
INSERT INTO `city_road` VALUES (1446, '黄山路', '440500', '汕头', 1.30, 26.50, 10.70, 2.70);
INSERT INTO `city_road` VALUES (1447, '东厦南路', '440500', '汕头', 1.30, 29.00, 6.20, 1.60);
INSERT INTO `city_road` VALUES (1448, '黄河路辅路', '440500', '汕头', 1.30, 32.10, 7.30, 1.80);
INSERT INTO `city_road` VALUES (1449, '澄江路', '440500', '汕头', 1.30, 33.50, 7.50, 1.80);
INSERT INTO `city_road` VALUES (1450, '华山北路', '440500', '汕头', 1.30, 31.00, 4.00, 0.90);
INSERT INTO `city_road` VALUES (1451, '昌盛路', '440400', '珠海', 2.70, 23.50, 9.70, 6.10);
INSERT INTO `city_road` VALUES (1452, '粤华路', '440400', '珠海', 1.70, 19.80, 7.70, 3.20);
INSERT INTO `city_road` VALUES (1453, '翠屏路', '440400', '珠海', 1.60, 30.20, 5.50, 2.10);
INSERT INTO `city_road` VALUES (1454, '侨光路', '440400', '珠海', 1.60, 20.30, 6.20, 2.30);
INSERT INTO `city_road` VALUES (1455, '港昌路', '440400', '珠海', 1.60, 32.20, 6.70, 2.50);
INSERT INTO `city_road` VALUES (1456, '迎宾南路', '440400', '珠海', 1.60, 31.90, 4.10, 1.50);
INSERT INTO `city_road` VALUES (1457, '迎宾南路', '440400', '珠海', 1.60, 31.40, 4.10, 1.50);
INSERT INTO `city_road` VALUES (1458, '琴政路', '440400', '珠海', 1.50, 22.90, 6.10, 1.90);
INSERT INTO `city_road` VALUES (1459, '水湾路', '440400', '珠海', 1.40, 26.90, 4.90, 1.40);
INSERT INTO `city_road` VALUES (1460, '九洲大道西', '440400', '珠海', 1.40, 44.50, 3.40, 0.90);
INSERT INTO `city_road` VALUES (1461, '九曲河路', '360700', '赣州', 1.40, 22.50, 5.60, 1.50);
INSERT INTO `city_road` VALUES (1462, '橙香大道', '360700', '赣州', 1.30, 38.20, 4.20, 1.00);
INSERT INTO `city_road` VALUES (1463, '章江南大道', '360700', '赣州', 1.30, 32.90, 10.40, 2.40);
INSERT INTO `city_road` VALUES (1464, '105国道', '360700', '赣州', 1.30, 38.40, 3.40, 0.80);
INSERT INTO `city_road` VALUES (1465, '登峰大道', '360700', '赣州', 1.30, 33.40, 7.60, 1.60);
INSERT INTO `city_road` VALUES (1466, '城南大道', '360700', '赣州', 1.30, 33.10, 5.50, 1.20);
INSERT INTO `city_road` VALUES (1467, '赣江源大道', '360700', '赣州', 1.30, 36.50, 4.40, 0.90);
INSERT INTO `city_road` VALUES (1468, '梅林大街', '360700', '赣州', 1.20, 32.90, 6.50, 1.30);
INSERT INTO `city_road` VALUES (1469, '九曲河路', '360700', '赣州', 1.20, 24.70, 7.50, 1.40);
INSERT INTO `city_road` VALUES (1470, '梅关大道', '360700', '赣州', 1.20, 40.00, 6.90, 1.30);
INSERT INTO `city_road` VALUES (1471, '昌盛路', '350500', '泉州', 1.60, 22.80, 7.80, 2.90);
INSERT INTO `city_road` VALUES (1472, '兴贤路', '350500', '泉州', 1.40, 27.00, 5.70, 1.70);
INSERT INTO `city_road` VALUES (1473, '通港西街', '350500', '泉州', 1.40, 39.80, 3.80, 1.10);
INSERT INTO `city_road` VALUES (1474, '泉秀街', '350500', '泉州', 1.40, 29.20, 4.10, 1.10);
INSERT INTO `city_road` VALUES (1475, '江南大街', '350500', '泉州', 1.40, 36.40, 5.20, 1.40);
INSERT INTO `city_road` VALUES (1476, '宝洲街', '350500', '泉州', 1.30, 30.80, 5.30, 1.40);
INSERT INTO `city_road` VALUES (1477, '兴贤路', '350500', '泉州', 1.30, 27.70, 5.50, 1.40);
INSERT INTO `city_road` VALUES (1478, '泉秀街', '350500', '泉州', 1.30, 29.60, 4.10, 1.00);
INSERT INTO `city_road` VALUES (1479, '丰泽街', '350500', '泉州', 1.30, 33.10, 3.70, 0.90);
INSERT INTO `city_road` VALUES (1480, '笋江路', '350500', '泉州', 1.30, 37.70, 4.40, 1.10);
INSERT INTO `city_road` VALUES (1481, '厦门路', '321300', '宿迁', 1.30, 36.40, 5.10, 1.20);
INSERT INTO `city_road` VALUES (1482, '西湖路', '321300', '宿迁', 1.30, 35.00, 8.00, 1.60);
INSERT INTO `city_road` VALUES (1483, '微山湖路', '321300', '宿迁', 1.20, 32.80, 4.50, 0.90);
INSERT INTO `city_road` VALUES (1484, '微山湖西路', '321300', '宿迁', 1.20, 36.80, 5.20, 1.00);
INSERT INTO `city_road` VALUES (1485, '青年路', '321300', '宿迁', 1.20, 36.70, 6.60, 1.20);
INSERT INTO `city_road` VALUES (1486, '西湖路', '321300', '宿迁', 1.20, 36.40, 7.80, 1.40);
INSERT INTO `city_road` VALUES (1487, '滨河路', '321300', '宿迁', 1.20, 47.80, 4.50, 0.80);
INSERT INTO `city_road` VALUES (1488, '青年路', '321300', '宿迁', 1.20, 36.90, 6.60, 1.20);
INSERT INTO `city_road` VALUES (1489, '深圳路', '321300', '宿迁', 1.20, 37.60, 5.30, 0.90);
INSERT INTO `city_road` VALUES (1490, '西湖西路', '321300', '宿迁', 1.20, 44.80, 10.50, 1.80);
INSERT INTO `city_road` VALUES (1491, '松花南路', '520100', '贵阳', 1.90, 21.40, 6.10, 2.90);
INSERT INTO `city_road` VALUES (1492, '花果园大街', '520100', '贵阳', 1.70, 19.10, 7.00, 2.90);
INSERT INTO `city_road` VALUES (1493, '解放路辅路', '520100', '贵阳', 1.70, 20.50, 6.40, 2.50);
INSERT INTO `city_road` VALUES (1494, '宝山北路', '520100', '贵阳', 1.60, 27.40, 4.90, 1.90);
INSERT INTO `city_road` VALUES (1495, '朝阳洞路辅路', '520100', '贵阳', 1.60, 24.90, 6.00, 2.30);
INSERT INTO `city_road` VALUES (1496, '北京路', '520100', '贵阳', 1.60, 30.50, 4.00, 1.50);
INSERT INTO `city_road` VALUES (1497, '金清大道', '520100', '贵阳', 1.50, 35.10, 3.70, 1.30);
INSERT INTO `city_road` VALUES (1498, '数博大道思雅路', '520100', '贵阳', 1.40, 35.60, 9.30, 2.90);
INSERT INTO `city_road` VALUES (1499, '宝山南路', '520100', '贵阳', 1.40, 32.40, 3.80, 1.20);
INSERT INTO `city_road` VALUES (1500, '中环路西段', '520100', '贵阳', 1.40, 47.50, 6.80, 2.00);
INSERT INTO `city_road` VALUES (1501, '岱宗大街', '370900', '泰安', 1.30, 32.80, 8.00, 1.90);
INSERT INTO `city_road` VALUES (1502, '灵山大街', '370900', '泰安', 1.20, 40.50, 18.30, 3.20);
INSERT INTO `city_road` VALUES (1503, '龙潭南路', '370900', '泰安', 1.20, 38.30, 10.60, 1.80);
INSERT INTO `city_road` VALUES (1504, '泮河北街', '370900', '泰安', 1.20, 36.00, 3.70, 0.60);
INSERT INTO `city_road` VALUES (1505, 'S31泰新高速', '370900', '泰安', 1.20, 84.90, 43.40, 7.40);
INSERT INTO `city_road` VALUES (1506, '正阳门大街', '370900', '泰安', 1.20, 41.30, 5.50, 0.90);
INSERT INTO `city_road` VALUES (1507, '迎春路', '370900', '泰安', 1.20, 35.00, 4.30, 0.70);
INSERT INTO `city_road` VALUES (1508, '望岳西路', '370900', '泰安', 1.20, 35.60, 4.80, 0.80);
INSERT INTO `city_road` VALUES (1509, 'G22青兰高速', '370900', '泰安', 1.20, 88.50, 47.80, 7.40);
INSERT INTO `city_road` VALUES (1510, '擂鼓石大街', '370900', '泰安', 1.20, 38.70, 12.80, 2.00);
INSERT INTO `city_road` VALUES (1511, '五一东大街', '130700', '张家口', 1.30, 31.60, 5.80, 1.50);
INSERT INTO `city_road` VALUES (1512, '钻石南路', '130700', '张家口', 1.20, 38.40, 3.70, 0.70);
INSERT INTO `city_road` VALUES (1513, '钻石中路', '130700', '张家口', 1.20, 36.60, 3.50, 0.70);
INSERT INTO `city_road` VALUES (1514, '清水河中路', '130700', '张家口', 1.20, 37.10, 4.40, 0.80);
INSERT INTO `city_road` VALUES (1515, '林园路', '130700', '张家口', 1.20, 34.80, 3.50, 0.60);
INSERT INTO `city_road` VALUES (1516, '建国路', '130700', '张家口', 1.20, 37.30, 7.50, 1.20);
INSERT INTO `city_road` VALUES (1517, '平门大街辅路', '130700', '张家口', 1.20, 40.60, 5.50, 0.90);
INSERT INTO `city_road` VALUES (1518, '林园路', '130700', '张家口', 1.20, 34.60, 3.60, 0.50);
INSERT INTO `city_road` VALUES (1519, '滨河北路', '130700', '张家口', 1.20, 36.20, 3.90, 0.60);
INSERT INTO `city_road` VALUES (1520, '铁道东路', '130700', '张家口', 1.20, 25.20, 5.00, 0.70);
INSERT INTO `city_road` VALUES (1521, '福寿西街', '370700', '潍坊', 1.20, 37.90, 10.20, 1.90);
INSERT INTO `city_road` VALUES (1522, '宝通东街', '370700', '潍坊', 1.20, 53.50, 27.90, 4.90);
INSERT INTO `city_road` VALUES (1523, '胜利东街', '370700', '潍坊', 1.20, 41.30, 10.80, 1.70);
INSERT INTO `city_road` VALUES (1524, '四平路', '370700', '潍坊', 1.20, 32.70, 10.60, 1.70);
INSERT INTO `city_road` VALUES (1525, '胜利东街', '370700', '潍坊', 1.20, 42.70, 10.40, 1.60);
INSERT INTO `city_road` VALUES (1526, '东风东街', '370700', '潍坊', 1.20, 42.30, 14.30, 2.20);
INSERT INTO `city_road` VALUES (1527, '鸢飞路', '370700', '潍坊', 1.20, 36.70, 18.00, 2.40);
INSERT INTO `city_road` VALUES (1528, '福寿东街', '370700', '潍坊', 1.20, 39.50, 13.90, 1.80);
INSERT INTO `city_road` VALUES (1529, '月河路', '370700', '潍坊', 1.10, 45.20, 13.70, 1.80);
INSERT INTO `city_road` VALUES (1530, '乐山街', '370700', '潍坊', 1.10, 50.10, 18.80, 2.40);
INSERT INTO `city_road` VALUES (1531, '青龙路', '420100', '武汉', 2.40, 22.80, 7.20, 4.10);
INSERT INTO `city_road` VALUES (1532, '康福路', '420100', '武汉', 2.30, 13.70, 9.20, 5.10);
INSERT INTO `city_road` VALUES (1533, '杨桥湖大道', '420100', '武汉', 2.00, 25.70, 9.30, 4.60);
INSERT INTO `city_road` VALUES (1534, '民族大道', '420100', '武汉', 1.90, 22.50, 13.10, 6.30);
INSERT INTO `city_road` VALUES (1535, '珞喻路辅路', '420100', '武汉', 1.70, 22.70, 6.50, 2.80);
INSERT INTO `city_road` VALUES (1536, '雄楚大道辅路', '420100', '武汉', 1.50, 28.30, 19.10, 6.70);
INSERT INTO `city_road` VALUES (1537, '东湖南路', '420100', '武汉', 1.50, 26.10, 7.00, 2.40);
INSERT INTO `city_road` VALUES (1538, '民族大道', '420100', '武汉', 1.50, 29.50, 10.00, 3.50);
INSERT INTO `city_road` VALUES (1539, '鹦鹉大道', '420100', '武汉', 1.50, 29.10, 12.50, 4.30);
INSERT INTO `city_road` VALUES (1540, '凌家山北路', '420100', '武汉', 1.50, 25.80, 5.70, 1.90);
INSERT INTO `city_road` VALUES (1541, '一环路北段', '510700', '绵阳', 1.70, 36.80, 11.00, 4.60);
INSERT INTO `city_road` VALUES (1542, '仙人路一段', '510700', '绵阳', 1.30, 25.80, 6.20, 1.60);
INSERT INTO `city_road` VALUES (1543, '临园路西段', '510700', '绵阳', 1.30, 37.80, 3.30, 0.70);
INSERT INTO `city_road` VALUES (1544, '玉女路', '510700', '绵阳', 1.30, 32.40, 4.00, 0.90);
INSERT INTO `city_road` VALUES (1545, '剑门路西段', '510700', '绵阳', 1.30, 34.90, 5.10, 1.10);
INSERT INTO `city_road` VALUES (1546, '东津路', '510700', '绵阳', 1.20, 39.70, 3.10, 0.60);
INSERT INTO `city_road` VALUES (1547, '一环路东段', '510700', '绵阳', 1.20, 38.20, 4.40, 0.80);
INSERT INTO `city_road` VALUES (1548, '长虹大道南段', '510700', '绵阳', 1.20, 41.10, 6.20, 1.20);
INSERT INTO `city_road` VALUES (1549, '普明北路东段', '510700', '绵阳', 1.20, 37.10, 5.60, 1.00);
INSERT INTO `city_road` VALUES (1550, '火炬西街南段', '510700', '绵阳', 1.20, 41.10, 3.20, 0.60);
INSERT INTO `city_road` VALUES (1551, '青葵公路', '810000', '香港', 1.30, 71.20, 3.60, 0.70);
INSERT INTO `city_road` VALUES (1552, '亚皆老街', '810000', '香港', 1.20, 40.20, 4.20, 0.80);
INSERT INTO `city_road` VALUES (1553, '观塘道', '810000', '香港', 1.20, 47.80, 4.10, 0.70);
INSERT INTO `city_road` VALUES (1554, '狮子山隧道公路', '810000', '香港', 1.20, 55.70, 5.10, 0.80);
INSERT INTO `city_road` VALUES (1555, '荔枝角道', '810000', '香港', 1.20, 37.50, 4.30, 0.70);
INSERT INTO `city_road` VALUES (1556, '大涌桥路', '810000', '香港', 1.20, 42.20, 4.30, 0.70);
INSERT INTO `city_road` VALUES (1557, '黄竹坑道', '810000', '香港', 1.20, 52.00, 2.60, 0.40);
INSERT INTO `city_road` VALUES (1558, '窝打老道', '810000', '香港', 1.20, 41.90, 5.90, 0.80);
INSERT INTO `city_road` VALUES (1559, '观塘道', '810000', '香港', 1.20, 53.80, 3.70, 0.50);
INSERT INTO `city_road` VALUES (1560, '弥敦道', '810000', '香港', 1.10, 34.60, 6.00, 0.80);
INSERT INTO `city_road` VALUES (1561, '新溉大道', '500000', '重庆', 3.60, 17.10, 14.90, 10.80);
INSERT INTO `city_road` VALUES (1562, '双碑隧道', '500000', '重庆', 2.30, 34.40, 7.60, 4.20);
INSERT INTO `city_road` VALUES (1563, '大学城北路', '500000', '重庆', 2.00, 25.60, 14.10, 7.20);
INSERT INTO `city_road` VALUES (1564, '宝圣大道', '500000', '重庆', 2.00, 19.10, 9.70, 4.80);
INSERT INTO `city_road` VALUES (1565, '科城路', '500000', '重庆', 1.90, 21.20, 12.60, 6.00);
INSERT INTO `city_road` VALUES (1566, '渝鲁大道', '500000', '重庆', 1.90, 34.70, 7.30, 3.40);
INSERT INTO `city_road` VALUES (1567, '双湖路', '500000', '重庆', 1.80, 21.60, 7.30, 3.30);
INSERT INTO `city_road` VALUES (1568, '大学城南二路', '500000', '重庆', 1.70, 30.50, 8.60, 3.60);
INSERT INTO `city_road` VALUES (1569, '龙腾大道', '500000', '重庆', 1.70, 37.40, 5.30, 2.20);
INSERT INTO `city_road` VALUES (1570, '长江二路', '500000', '重庆', 1.60, 32.10, 6.50, 2.50);
INSERT INTO `city_road` VALUES (1571, '文化路', '130200', '唐山', 1.30, 30.90, 6.00, 1.50);
INSERT INTO `city_road` VALUES (1572, '大里南路', '130200', '唐山', 1.30, 31.30, 4.90, 1.20);
INSERT INTO `city_road` VALUES (1573, '大里南路', '130200', '唐山', 1.30, 33.10, 4.80, 1.10);
INSERT INTO `city_road` VALUES (1574, '友谊南路', '130200', '唐山', 1.30, 32.80, 6.10, 1.30);
INSERT INTO `city_road` VALUES (1575, '卫国南路', '130200', '唐山', 1.30, 35.10, 5.80, 1.20);
INSERT INTO `city_road` VALUES (1576, '大里北路', '130200', '唐山', 1.30, 35.70, 6.00, 1.20);
INSERT INTO `city_road` VALUES (1577, '长虹西道', '130200', '唐山', 1.20, 37.40, 5.40, 1.10);
INSERT INTO `city_road` VALUES (1578, '大里北路', '130200', '唐山', 1.20, 36.20, 5.90, 1.20);
INSERT INTO `city_road` VALUES (1579, '学院北路', '130200', '唐山', 1.20, 39.70, 9.50, 1.90);
INSERT INTO `city_road` VALUES (1580, '运河西路', '130200', '唐山', 1.20, 44.00, 5.70, 1.00);
INSERT INTO `city_road` VALUES (1581, '南京长江大桥', '320100', '南京', 3.50, 19.80, 14.30, 10.20);
INSERT INTO `city_road` VALUES (1582, '南京长江大桥', '320100', '南京', 2.00, 35.30, 8.10, 4.00);
INSERT INTO `city_road` VALUES (1583, '内环西线', '320100', '南京', 1.50, 44.50, 10.30, 3.40);
INSERT INTO `city_road` VALUES (1584, '湖山路', '320100', '南京', 1.50, 28.30, 10.10, 3.30);
INSERT INTO `city_road` VALUES (1585, '上高路', '320100', '南京', 1.50, 24.10, 10.10, 3.30);
INSERT INTO `city_road` VALUES (1586, '内环东线', '320100', '南京', 1.40, 49.20, 8.90, 2.50);
INSERT INTO `city_road` VALUES (1587, '吴侯街', '320100', '南京', 1.40, 29.70, 5.90, 1.60);
INSERT INTO `city_road` VALUES (1588, '江东北路辅路', '320100', '南京', 1.30, 29.50, 6.10, 1.50);
INSERT INTO `city_road` VALUES (1589, '文苑路', '320100', '南京', 1.30, 35.80, 5.30, 1.30);
INSERT INTO `city_road` VALUES (1590, '中央路', '320100', '南京', 1.30, 31.80, 5.50, 1.30);
INSERT INTO `city_road` VALUES (1591, '796县道', '440200', '韶关', 1.30, 37.10, 3.40, 0.70);
INSERT INTO `city_road` VALUES (1592, '惠民北路', '440200', '韶关', 1.30, 37.40, 3.50, 0.70);
INSERT INTO `city_road` VALUES (1593, '芙蓉北路', '440200', '韶关', 1.20, 39.20, 4.60, 0.90);
INSERT INTO `city_road` VALUES (1594, '浈江大道中', '440200', '韶关', 1.20, 40.10, 7.50, 1.50);
INSERT INTO `city_road` VALUES (1595, '芙蓉北路', '440200', '韶关', 1.20, 40.70, 4.20, 0.80);
INSERT INTO `city_road` VALUES (1596, '碧亭路', '440200', '韶关', 1.20, 42.20, 4.90, 0.90);
INSERT INTO `city_road` VALUES (1597, '马坝大道', '440200', '韶关', 1.20, 38.80, 5.30, 0.90);
INSERT INTO `city_road` VALUES (1598, '惠民北路', '440200', '韶关', 1.20, 37.60, 3.40, 0.60);
INSERT INTO `city_road` VALUES (1599, 'G6011南韶高速', '440200', '韶关', 1.20, 82.80, 93.40, 15.30);
INSERT INTO `city_road` VALUES (1600, '教育路', '440200', '韶关', 1.20, 37.10, 5.70, 0.90);
INSERT INTO `city_road` VALUES (1601, '北翟路地道', '310000', '上海', 2.50, 25.80, 5.10, 3.10);
INSERT INTO `city_road` VALUES (1602, '延安高架路', '310000', '上海', 2.20, 30.90, 26.00, 14.20);
INSERT INTO `city_road` VALUES (1603, '广灵四路', '310000', '上海', 2.10, 17.80, 7.20, 3.70);
INSERT INTO `city_road` VALUES (1604, '北翟路地道', '310000', '上海', 2.10, 30.60, 4.20, 2.20);
INSERT INTO `city_road` VALUES (1605, '虹梅南路辅路', '310000', '上海', 2.00, 19.10, 7.00, 3.60);
INSERT INTO `city_road` VALUES (1606, '虹梅高架路', '310000', '上海', 1.60, 47.30, 13.30, 5.10);
INSERT INTO `city_road` VALUES (1607, '申兰路', '310000', '上海', 1.60, 30.10, 8.30, 3.00);
INSERT INTO `city_road` VALUES (1608, '华江公路', '310000', '上海', 1.50, 29.00, 7.60, 2.50);
INSERT INTO `city_road` VALUES (1609, '诸光路地道', '310000', '上海', 1.50, 39.10, 3.40, 1.10);
INSERT INTO `city_road` VALUES (1610, '沪闵高架路', '310000', '上海', 1.40, 51.90, 8.80, 2.60);
INSERT INTO `city_road` VALUES (1611, '红十五线', '330100', '杭州', 2.30, 19.20, 7.90, 4.50);
INSERT INTO `city_road` VALUES (1612, '中河高架', '330100', '杭州', 1.90, 38.30, 9.80, 4.60);
INSERT INTO `city_road` VALUES (1613, '红十五线', '330100', '杭州', 1.70, 27.40, 5.60, 2.40);
INSERT INTO `city_road` VALUES (1614, '人民大道', '330100', '杭州', 1.60, 27.70, 13.00, 5.00);
INSERT INTO `city_road` VALUES (1615, '上塘高架', '330100', '杭州', 1.60, 47.20, 16.70, 5.90);
INSERT INTO `city_road` VALUES (1616, '艮山西路', '330100', '杭州', 1.60, 43.40, 5.30, 1.90);
INSERT INTO `city_road` VALUES (1617, '振兴西路', '330100', '杭州', 1.50, 25.90, 10.10, 3.50);
INSERT INTO `city_road` VALUES (1618, '外翁线', '330100', '杭州', 1.50, 30.80, 8.20, 2.70);
INSERT INTO `city_road` VALUES (1619, '文海北路', '330100', '杭州', 1.40, 32.20, 4.10, 1.20);
INSERT INTO `city_road` VALUES (1620, '万佳路', '330100', '杭州', 1.40, 21.80, 6.80, 2.10);
INSERT INTO `city_road` VALUES (1621, '休门街', '130100', '石家庄', 1.50, 22.20, 6.20, 2.20);
INSERT INTO `city_road` VALUES (1622, '中华北大街', '130100', '石家庄', 1.40, 43.10, 10.10, 3.10);
INSERT INTO `city_road` VALUES (1623, '107国道', '130100', '石家庄', 1.30, 42.30, 10.40, 2.50);
INSERT INTO `city_road` VALUES (1624, '燕赵南大街', '130100', '石家庄', 1.30, 28.60, 4.70, 1.10);
INSERT INTO `city_road` VALUES (1625, '燕赵北大街', '130100', '石家庄', 1.30, 32.20, 4.80, 1.10);
INSERT INTO `city_road` VALUES (1626, '东二环北路辅路', '130100', '石家庄', 1.30, 34.80, 3.70, 0.80);
INSERT INTO `city_road` VALUES (1627, '翟营南大街', '130100', '石家庄', 1.30, 29.60, 13.00, 2.90);
INSERT INTO `city_road` VALUES (1628, '建设北大街', '130100', '石家庄', 1.30, 35.50, 5.60, 1.20);
INSERT INTO `city_road` VALUES (1629, '滨河街', '130100', '石家庄', 1.30, 26.60, 5.60, 1.20);
INSERT INTO `city_road` VALUES (1630, '泰华街', '130100', '石家庄', 1.30, 32.30, 8.70, 1.90);
INSERT INTO `city_road` VALUES (1631, '文贤路', '330400', '嘉兴', 2.00, 20.70, 9.00, 4.40);
INSERT INTO `city_road` VALUES (1632, '中山东路', '330400', '嘉兴', 1.40, 30.50, 6.20, 1.80);
INSERT INTO `city_road` VALUES (1633, '湘家荡大道', '330400', '嘉兴', 1.40, 39.10, 11.30, 3.00);
INSERT INTO `city_road` VALUES (1634, '桐乡大道', '330400', '嘉兴', 1.30, 43.20, 8.40, 1.80);
INSERT INTO `city_road` VALUES (1635, '吉杨路', '330400', '嘉兴', 1.30, 31.40, 5.50, 1.20);
INSERT INTO `city_road` VALUES (1636, '越秀南路', '330400', '嘉兴', 1.30, 31.60, 4.80, 1.00);
INSERT INTO `city_road` VALUES (1637, '嘉洪大道', '330400', '嘉兴', 1.20, 46.00, 9.30, 1.60);
INSERT INTO `city_road` VALUES (1638, '禾兴南路', '330400', '嘉兴', 1.20, 35.00, 5.20, 0.90);
INSERT INTO `city_road` VALUES (1639, '湘家荡大道', '330400', '嘉兴', 1.20, 45.90, 8.70, 1.50);
INSERT INTO `city_road` VALUES (1640, '十八里西街', '330400', '嘉兴', 1.20, 42.10, 3.70, 0.60);
INSERT INTO `city_road` VALUES (1641, '长沙路', '371300', '临沂', 1.40, 33.00, 13.60, 4.00);
INSERT INTO `city_road` VALUES (1642, '兰山路', '371300', '临沂', 1.40, 25.30, 5.30, 1.50);
INSERT INTO `city_road` VALUES (1643, '金安路', '371300', '临沂', 1.30, 28.70, 5.50, 1.30);
INSERT INTO `city_road` VALUES (1644, '解放路辅路', '371300', '临沂', 1.30, 26.20, 6.30, 1.50);
INSERT INTO `city_road` VALUES (1645, '济南路', '371300', '临沂', 1.30, 29.70, 8.80, 2.00);
INSERT INTO `city_road` VALUES (1646, '新华路', '371300', '临沂', 1.30, 28.60, 9.90, 2.20);
INSERT INTO `city_road` VALUES (1647, '开元路', '371300', '临沂', 1.30, 31.10, 5.00, 1.10);
INSERT INTO `city_road` VALUES (1648, '兰山路', '371300', '临沂', 1.30, 27.70, 4.90, 1.10);
INSERT INTO `city_road` VALUES (1649, '红旗路', '371300', '临沂', 1.30, 27.20, 8.50, 1.80);
INSERT INTO `city_road` VALUES (1650, '银雀山路', '371300', '临沂', 1.30, 30.50, 15.60, 3.30);
INSERT INTO `city_road` VALUES (1651, '华庭路', '370600', '烟台', 1.40, 30.10, 4.30, 1.10);
INSERT INTO `city_road` VALUES (1652, '桐林路', '370600', '烟台', 1.30, 31.40, 5.50, 1.30);
INSERT INTO `city_road` VALUES (1653, '湘潭路', '370600', '烟台', 1.30, 38.10, 3.60, 0.70);
INSERT INTO `city_road` VALUES (1654, '秦淮河路', '370600', '烟台', 1.20, 36.40, 8.00, 1.40);
INSERT INTO `city_road` VALUES (1655, '二马路', '370600', '烟台', 1.20, 39.50, 3.70, 0.60);
INSERT INTO `city_road` VALUES (1656, '通世路', '370600', '烟台', 1.20, 39.00, 5.10, 0.80);
INSERT INTO `city_road` VALUES (1657, '双河西路', '370600', '烟台', 1.20, 41.20, 4.30, 0.60);
INSERT INTO `city_road` VALUES (1658, '胜利路', '370600', '烟台', 1.20, 34.00, 3.90, 0.60);
INSERT INTO `city_road` VALUES (1659, '清泉路', '370600', '烟台', 1.20, 37.10, 3.50, 0.50);
INSERT INTO `city_road` VALUES (1660, '胜利路', '370600', '烟台', 1.20, 35.00, 3.80, 0.50);
INSERT INTO `city_road` VALUES (1661, 'S12机场高速', '110000', '北京', 8.30, 9.80, 126.60, 111.20);
INSERT INTO `city_road` VALUES (1662, '菜户营南路', '110000', '北京', 2.60, 24.70, 4.90, 3.00);
INSERT INTO `city_road` VALUES (1663, 'S12机场高速', '110000', '北京', 1.90, 42.70, 28.90, 13.60);
INSERT INTO `city_road` VALUES (1664, '首都机场辅路', '110000', '北京', 1.80, 26.80, 25.40, 11.10);
INSERT INTO `city_road` VALUES (1665, '西二环', '110000', '北京', 1.60, 42.20, 11.90, 4.50);
INSERT INTO `city_road` VALUES (1666, '西长安街', '110000', '北京', 1.50, 34.40, 3.70, 1.30);
INSERT INTO `city_road` VALUES (1667, 'S50东五环', '110000', '北京', 1.40, 55.80, 24.30, 7.40);
INSERT INTO `city_road` VALUES (1668, '回南路', '110000', '北京', 1.40, 28.20, 18.50, 5.30);
INSERT INTO `city_road` VALUES (1669, '工人体育场北路', '110000', '北京', 1.40, 28.60, 4.70, 1.30);
INSERT INTO `city_road` VALUES (1670, '西三环北路', '110000', '北京', 1.40, 50.50, 5.00, 1.30);
INSERT INTO `city_road` VALUES (1671, '七星二路', '441200', '肇庆', 1.30, 37.00, 5.70, 1.40);
INSERT INTO `city_road` VALUES (1672, '七星二路', '441200', '肇庆', 1.30, 41.90, 5.10, 1.10);
INSERT INTO `city_road` VALUES (1673, '高要大道', '441200', '肇庆', 1.30, 50.00, 5.60, 1.20);
INSERT INTO `city_road` VALUES (1674, '星湖大道', '441200', '肇庆', 1.30, 42.60, 9.80, 2.00);
INSERT INTO `city_road` VALUES (1675, '星湖西路', '441200', '肇庆', 1.20, 36.40, 3.40, 0.70);
INSERT INTO `city_road` VALUES (1676, '府前大街', '441200', '肇庆', 1.20, 39.10, 3.20, 0.50);
INSERT INTO `city_road` VALUES (1677, '要南三路', '441200', '肇庆', 1.20, 42.90, 2.90, 0.40);
INSERT INTO `city_road` VALUES (1678, '建设二路', '441200', '肇庆', 1.20, 36.50, 3.80, 0.60);
INSERT INTO `city_road` VALUES (1679, '玑东路', '441200', '肇庆', 1.20, 39.20, 3.20, 0.50);
INSERT INTO `city_road` VALUES (1680, '世纪大道', '441200', '肇庆', 1.20, 41.80, 2.90, 0.40);
INSERT INTO `city_road` VALUES (1681, '长江西路', '340100', '合肥', 1.70, 26.20, 5.70, 2.40);
INSERT INTO `city_road` VALUES (1682, '和平路', '340100', '合肥', 1.40, 27.50, 18.00, 5.40);
INSERT INTO `city_road` VALUES (1683, '宿州路', '340100', '合肥', 1.40, 23.50, 5.90, 1.70);
INSERT INTO `city_road` VALUES (1684, '海棠路', '340100', '合肥', 1.40, 30.30, 5.60, 1.60);
INSERT INTO `city_road` VALUES (1685, '九华山路', '340100', '合肥', 1.40, 27.10, 4.50, 1.20);
INSERT INTO `city_road` VALUES (1686, '宁国南路', '340100', '合肥', 1.30, 26.60, 7.20, 1.90);
INSERT INTO `city_road` VALUES (1687, '海棠路', '340100', '合肥', 1.30, 31.80, 5.30, 1.30);
INSERT INTO `city_road` VALUES (1688, '习友西路辅路', '340100', '合肥', 1.30, 26.60, 7.20, 1.80);
INSERT INTO `city_road` VALUES (1689, '寿春路', '340100', '合肥', 1.30, 31.10, 5.00, 1.30);
INSERT INTO `city_road` VALUES (1690, '淠河路', '340100', '合肥', 1.30, 26.90, 5.70, 1.40);
INSERT INTO `city_road` VALUES (1691, '井冈山大道', '360100', '南昌', 2.10, 22.10, 10.20, 5.40);
INSERT INTO `city_road` VALUES (1692, '施尧路', '360100', '南昌', 1.90, 26.10, 8.10, 3.70);
INSERT INTO `city_road` VALUES (1693, '紫阳大道', '360100', '南昌', 1.60, 30.00, 9.60, 3.60);
INSERT INTO `city_road` VALUES (1694, '北京东路', '360100', '南昌', 1.50, 36.20, 10.00, 3.10);
INSERT INTO `city_road` VALUES (1695, '凌波路', '360100', '南昌', 1.40, 26.90, 4.60, 1.40);
INSERT INTO `city_road` VALUES (1696, '芳草路', '360100', '南昌', 1.40, 24.70, 5.10, 1.50);
INSERT INTO `city_road` VALUES (1697, '长麦路', '360100', '南昌', 1.40, 27.80, 5.50, 1.60);
INSERT INTO `city_road` VALUES (1698, '洪都南大道辅路', '360100', '南昌', 1.40, 30.80, 4.10, 1.20);
INSERT INTO `city_road` VALUES (1699, '上海路', '360100', '南昌', 1.40, 26.20, 5.30, 1.50);
INSERT INTO `city_road` VALUES (1700, '礼步湖大道', '360100', '南昌', 1.40, 30.00, 6.20, 1.70);
INSERT INTO `city_road` VALUES (1701, '中兴三路', '440700', '江门', 1.30, 30.00, 5.90, 1.50);
INSERT INTO `city_road` VALUES (1702, '117乡道', '440700', '江门', 1.30, 30.50, 4.70, 1.00);
INSERT INTO `city_road` VALUES (1703, '南华东路', '440700', '江门', 1.30, 33.70, 4.60, 1.00);
INSERT INTO `city_road` VALUES (1704, '胜利路', '440700', '江门', 1.30, 35.30, 4.30, 0.90);
INSERT INTO `city_road` VALUES (1705, '中兴三路', '440700', '江门', 1.30, 32.00, 5.50, 1.10);
INSERT INTO `city_road` VALUES (1706, '圭峰路', '440700', '江门', 1.20, 39.90, 6.10, 1.20);
INSERT INTO `city_road` VALUES (1707, '新昌路', '440700', '江门', 1.20, 36.70, 3.40, 0.60);
INSERT INTO `city_road` VALUES (1708, '江沙路', '440700', '江门', 1.20, 43.70, 2.90, 0.60);
INSERT INTO `city_road` VALUES (1709, '冈州大道中', '440700', '江门', 1.20, 36.00, 5.80, 1.10);
INSERT INTO `city_road` VALUES (1710, '江海一路', '440700', '江门', 1.20, 39.70, 3.00, 0.60);
INSERT INTO `city_road` VALUES (1711, '黄白路', '430400', '衡阳', 2.00, 18.50, 10.70, 5.40);
INSERT INTO `city_road` VALUES (1712, '蒸阳南路', '430400', '衡阳', 1.80, 26.20, 20.00, 9.00);
INSERT INTO `city_road` VALUES (1713, '黄白路', '430400', '衡阳', 1.80, 19.90, 9.90, 4.30);
INSERT INTO `city_road` VALUES (1714, '白云路', '430400', '衡阳', 1.40, 24.80, 7.30, 2.10);
INSERT INTO `city_road` VALUES (1715, '白云路', '430400', '衡阳', 1.30, 26.20, 7.20, 1.80);
INSERT INTO `city_road` VALUES (1716, '延安路', '430400', '衡阳', 1.30, 28.00, 6.50, 1.60);
INSERT INTO `city_road` VALUES (1717, '三江路', '430400', '衡阳', 1.30, 28.00, 4.80, 1.10);
INSERT INTO `city_road` VALUES (1718, '船山大道', '430400', '衡阳', 1.30, 36.00, 11.20, 2.50);
INSERT INTO `city_road` VALUES (1719, '祝融路', '430400', '衡阳', 1.30, 29.30, 6.10, 1.30);
INSERT INTO `city_road` VALUES (1720, '祝融路', '430400', '衡阳', 1.30, 30.10, 5.90, 1.30);
INSERT INTO `city_road` VALUES (1721, '荷花中路', '330800', '衢州', 1.30, 33.40, 4.20, 0.90);
INSERT INTO `city_road` VALUES (1722, '九华北大道', '330800', '衢州', 1.20, 38.00, 4.90, 0.90);
INSERT INTO `city_road` VALUES (1723, '衢江南路', '330800', '衢州', 1.20, 38.80, 3.30, 0.50);
INSERT INTO `city_road` VALUES (1724, '府东街', '330800', '衢州', 1.20, 42.20, 4.70, 0.80);
INSERT INTO `city_road` VALUES (1725, '荷一路', '330800', '衢州', 1.20, 38.30, 5.50, 0.90);
INSERT INTO `city_road` VALUES (1726, '九华北大道', '330800', '衢州', 1.20, 38.40, 4.70, 0.70);
INSERT INTO `city_road` VALUES (1727, '劳动路', '330800', '衢州', 1.20, 45.60, 3.30, 0.50);
INSERT INTO `city_road` VALUES (1728, '荷一路', '330800', '衢州', 1.20, 38.50, 5.50, 0.80);
INSERT INTO `city_road` VALUES (1729, '荷花西路', '330800', '衢州', 1.20, 35.50, 3.50, 0.50);
INSERT INTO `city_road` VALUES (1730, '劳动路', '330800', '衢州', 1.20, 45.00, 3.40, 0.40);
INSERT INTO `city_road` VALUES (1731, '建军中路', '320900', '盐城', 1.30, 30.60, 4.00, 1.00);
INSERT INTO `city_road` VALUES (1732, '新永路', '320900', '盐城', 1.30, 33.30, 3.70, 0.80);
INSERT INTO `city_road` VALUES (1733, '大庆中路', '320900', '盐城', 1.20, 33.60, 3.80, 0.70);
INSERT INTO `city_road` VALUES (1734, '海潮路', '320900', '盐城', 1.20, 31.50, 4.00, 0.80);
INSERT INTO `city_road` VALUES (1735, '双元路', '320900', '盐城', 1.20, 26.70, 6.10, 1.10);
INSERT INTO `city_road` VALUES (1736, '建军中路', '320900', '盐城', 1.20, 34.90, 3.50, 0.60);
INSERT INTO `city_road` VALUES (1737, '戴庄路', '320900', '盐城', 1.20, 34.10, 10.50, 1.80);
INSERT INTO `city_road` VALUES (1738, '解放南路', '320900', '盐城', 1.20, 39.00, 18.50, 3.10);
INSERT INTO `city_road` VALUES (1739, '解放南路', '320900', '盐城', 1.20, 39.70, 18.20, 3.00);
INSERT INTO `city_road` VALUES (1740, '迎宾南路', '320900', '盐城', 1.20, 34.50, 6.10, 1.00);
INSERT INTO `city_road` VALUES (1741, '正阳中路', '370200', '青岛', 1.60, 29.80, 15.60, 5.70);
INSERT INTO `city_road` VALUES (1742, '钱塘江路', '370200', '青岛', 1.30, 32.50, 4.00, 1.00);
INSERT INTO `city_road` VALUES (1743, '江西路', '370200', '青岛', 1.30, 29.10, 8.50, 2.00);
INSERT INTO `city_road` VALUES (1744, '京口路', '370200', '青岛', 1.30, 28.70, 4.50, 1.00);
INSERT INTO `city_road` VALUES (1745, '夏塔路', '370200', '青岛', 1.30, 32.80, 9.90, 2.10);
INSERT INTO `city_road` VALUES (1746, '天风南路', '370200', '青岛', 1.30, 37.00, 3.80, 0.80);
INSERT INTO `city_road` VALUES (1747, '人民路', '370200', '青岛', 1.20, 32.70, 5.50, 1.10);
INSERT INTO `city_road` VALUES (1748, '钱塘江路', '370200', '青岛', 1.20, 33.10, 3.90, 0.80);
INSERT INTO `city_road` VALUES (1749, '阿里山路', '370200', '青岛', 1.20, 34.50, 3.90, 0.70);
INSERT INTO `city_road` VALUES (1750, '洛阳路', '370200', '青岛', 1.20, 31.30, 4.00, 0.70);
INSERT INTO `city_road` VALUES (1751, '南谯中路', '341100', '滁州', 1.20, 40.50, 6.90, 1.30);
INSERT INTO `city_road` VALUES (1752, '会峰东路', '341100', '滁州', 1.20, 44.20, 2.90, 0.50);
INSERT INTO `city_road` VALUES (1753, '南谯北路', '341100', '滁州', 1.20, 36.00, 6.50, 1.00);
INSERT INTO `city_road` VALUES (1754, '洪武东路', '341100', '滁州', 1.20, 53.90, 8.70, 1.30);
INSERT INTO `city_road` VALUES (1755, '南谯中路', '341100', '滁州', 1.20, 42.40, 6.50, 1.00);
INSERT INTO `city_road` VALUES (1756, '全椒北路', '341100', '滁州', 1.20, 39.50, 4.20, 0.60);
INSERT INTO `city_road` VALUES (1757, '醉翁西路', '341100', '滁州', 1.20, 47.10, 8.30, 1.20);
INSERT INTO `city_road` VALUES (1758, '中都大道', '341100', '滁州', 1.20, 44.40, 15.30, 2.20);
INSERT INTO `city_road` VALUES (1759, '洪武东路', '341100', '滁州', 1.20, 54.70, 8.60, 1.20);
INSERT INTO `city_road` VALUES (1760, '清流中路', '341100', '滁州', 1.20, 43.00, 6.10, 0.80);
INSERT INTO `city_road` VALUES (1761, '润州路', '321100', '镇江', 1.60, 21.70, 8.50, 3.20);
INSERT INTO `city_road` VALUES (1762, '左湖路', '321100', '镇江', 1.20, 52.40, 2.30, 0.50);
INSERT INTO `city_road` VALUES (1763, '运河路', '321100', '镇江', 1.20, 35.10, 4.80, 0.90);
INSERT INTO `city_road` VALUES (1764, '金谷路', '321100', '镇江', 1.20, 34.40, 4.00, 0.70);
INSERT INTO `city_road` VALUES (1765, '金谷路', '321100', '镇江', 1.20, 35.30, 3.90, 0.70);
INSERT INTO `city_road` VALUES (1766, '长风路', '321100', '镇江', 1.20, 49.40, 6.60, 1.10);
INSERT INTO `city_road` VALUES (1767, '学府路', '321100', '镇江', 1.20, 40.00, 9.80, 1.50);
INSERT INTO `city_road` VALUES (1768, '解放路', '321100', '镇江', 1.20, 37.60, 4.70, 0.70);
INSERT INTO `city_road` VALUES (1769, '学府路', '321100', '镇江', 1.20, 39.10, 10.00, 1.50);
INSERT INTO `city_road` VALUES (1770, '花山路', '321100', '镇江', 1.20, 31.50, 4.60, 0.70);
INSERT INTO `city_road` VALUES (1771, '学府路', '330200', '宁波', 2.00, 19.20, 9.70, 4.90);
INSERT INTO `city_road` VALUES (1772, '日丽东路', '330200', '宁波', 1.90, 22.50, 5.60, 2.60);
INSERT INTO `city_road` VALUES (1773, '日丽东路', '330200', '宁波', 1.90, 22.70, 5.70, 2.60);
INSERT INTO `city_road` VALUES (1774, '钱湖北路', '330200', '宁波', 1.80, 23.50, 6.60, 3.00);
INSERT INTO `city_road` VALUES (1775, '学府路', '330200', '宁波', 1.80, 23.00, 8.10, 3.50);
INSERT INTO `city_road` VALUES (1776, '扬帆路', '330200', '宁波', 1.60, 26.70, 8.40, 3.10);
INSERT INTO `city_road` VALUES (1777, '新大路', '330200', '宁波', 1.50, 24.40, 10.70, 3.50);
INSERT INTO `city_road` VALUES (1778, '贸城中路', '330200', '宁波', 1.40, 30.60, 4.60, 1.20);
INSERT INTO `city_road` VALUES (1779, '新大路', '330200', '宁波', 1.30, 26.70, 9.70, 2.50);
INSERT INTO `city_road` VALUES (1780, '顺明路', '330200', '宁波', 1.30, 30.00, 5.80, 1.40);
INSERT INTO `city_road` VALUES (1781, '富民街', '210100', '沈阳', 1.80, 24.20, 5.10, 2.20);
INSERT INTO `city_road` VALUES (1782, '蒲昌路', '210100', '沈阳', 1.60, 25.30, 15.90, 6.00);
INSERT INTO `city_road` VALUES (1783, '黄河南大街', '210100', '沈阳', 1.30, 38.80, 5.10, 1.30);
INSERT INTO `city_road` VALUES (1784, '富民街', '210100', '沈阳', 1.30, 31.50, 3.90, 1.00);
INSERT INTO `city_road` VALUES (1785, '蒲昌路', '210100', '沈阳', 1.30, 33.70, 11.80, 2.70);
INSERT INTO `city_road` VALUES (1786, '银杏路', '210100', '沈阳', 1.30, 30.10, 4.80, 1.10);
INSERT INTO `city_road` VALUES (1787, '北陵大街', '210100', '沈阳', 1.30, 40.10, 3.30, 0.70);
INSERT INTO `city_road` VALUES (1788, '文大路', '210100', '沈阳', 1.30, 36.20, 7.60, 1.60);
INSERT INTO `city_road` VALUES (1789, '景星北街', '210100', '沈阳', 1.30, 25.80, 5.30, 1.10);
INSERT INTO `city_road` VALUES (1790, '青榆路', '210100', '沈阳', 1.20, 29.10, 4.50, 0.90);
INSERT INTO `city_road` VALUES (1791, '畅溪街', '220100', '长春', 1.30, 42.10, 4.10, 1.00);
INSERT INTO `city_road` VALUES (1792, '同志街', '220100', '长春', 1.30, 29.90, 6.90, 1.60);
INSERT INTO `city_road` VALUES (1793, '安达街', '220100', '长春', 1.30, 31.60, 3.90, 0.90);
INSERT INTO `city_road` VALUES (1794, '博学路', '220100', '长春', 1.30, 36.00, 3.90, 0.80);
INSERT INTO `city_road` VALUES (1795, '北人民大街', '220100', '长春', 1.30, 38.80, 6.30, 1.40);
INSERT INTO `city_road` VALUES (1796, '博学路', '220100', '长春', 1.30, 38.80, 3.60, 0.80);
INSERT INTO `city_road` VALUES (1797, '威海路', '220100', '长春', 1.30, 26.80, 6.10, 1.30);
INSERT INTO `city_road` VALUES (1798, '沈阳大路', '220100', '长春', 1.30, 41.20, 3.30, 0.70);
INSERT INTO `city_road` VALUES (1799, '佳园路', '220100', '长春', 1.20, 30.10, 4.90, 1.00);
INSERT INTO `city_road` VALUES (1800, '世光路', '220100', '长春', 1.20, 29.20, 4.70, 0.90);
INSERT INTO `city_road` VALUES (1801, '五五路', '210200', '大连', 1.20, 32.30, 4.60, 0.90);
INSERT INTO `city_road` VALUES (1802, '数码路', '210200', '大连', 1.20, 38.30, 3.60, 0.60);
INSERT INTO `city_road` VALUES (1803, '银杏大道', '210200', '大连', 1.20, 46.40, 3.00, 0.50);
INSERT INTO `city_road` VALUES (1804, '黄河路', '210200', '大连', 1.20, 36.40, 10.70, 1.70);
INSERT INTO `city_road` VALUES (1805, '数码路', '210200', '大连', 1.20, 37.90, 3.60, 0.60);
INSERT INTO `city_road` VALUES (1806, '辽河西路', '210200', '大连', 1.20, 42.20, 7.30, 1.10);
INSERT INTO `city_road` VALUES (1807, '联合路', '210200', '大连', 1.20, 36.40, 4.40, 0.60);
INSERT INTO `city_road` VALUES (1808, '中长街', '210200', '大连', 1.20, 35.60, 3.50, 0.50);
INSERT INTO `city_road` VALUES (1809, '东北三街', '210200', '大连', 1.20, 31.00, 6.40, 0.90);
INSERT INTO `city_road` VALUES (1810, '西安路', '210200', '大连', 1.20, 33.40, 5.10, 0.70);
INSERT INTO `city_road` VALUES (1811, '学院路', '230100', '哈尔滨', 1.90, 22.00, 13.40, 6.50);
INSERT INTO `city_road` VALUES (1812, '学院路', '230100', '哈尔滨', 1.90, 22.20, 13.30, 6.40);
INSERT INTO `city_road` VALUES (1813, '中兴大道', '230100', '哈尔滨', 1.60, 26.80, 5.40, 2.10);
INSERT INTO `city_road` VALUES (1814, '温州路', '230100', '哈尔滨', 1.60, 26.10, 4.90, 1.80);
INSERT INTO `city_road` VALUES (1815, '新京路', '230100', '哈尔滨', 1.30, 23.00, 5.40, 1.20);
INSERT INTO `city_road` VALUES (1816, 'G1京哈高速', '230100', '哈尔滨', 1.20, 83.80, 50.30, 9.80);
INSERT INTO `city_road` VALUES (1817, '中兴大道', '230100', '哈尔滨', 1.20, 35.80, 4.10, 0.80);
INSERT INTO `city_road` VALUES (1818, '南兴街', '230100', '哈尔滨', 1.20, 29.40, 4.60, 0.90);
INSERT INTO `city_road` VALUES (1819, '南兴街', '230100', '哈尔滨', 1.20, 29.30, 4.60, 0.90);
INSERT INTO `city_road` VALUES (1820, '呼兰大道', '230100', '哈尔滨', 1.20, 45.80, 8.60, 1.50);
INSERT INTO `city_road` VALUES (1821, '百祥路', '321000', '扬州', 1.40, 30.40, 7.70, 2.20);
INSERT INTO `city_road` VALUES (1822, '邗江中路', '321000', '扬州', 1.40, 33.80, 7.90, 2.10);
INSERT INTO `city_road` VALUES (1823, '百祥路', '321000', '扬州', 1.30, 31.80, 7.40, 1.90);
INSERT INTO `city_road` VALUES (1824, '盐运路', '321000', '扬州', 1.30, 34.30, 4.70, 1.20);
INSERT INTO `city_road` VALUES (1825, '黄金坝路', '321000', '扬州', 1.30, 31.50, 4.70, 1.00);
INSERT INTO `city_road` VALUES (1826, '四望亭路', '321000', '扬州', 1.30, 29.50, 5.80, 1.30);
INSERT INTO `city_road` VALUES (1827, '华扬西路', '321000', '扬州', 1.30, 35.30, 7.60, 1.60);
INSERT INTO `city_road` VALUES (1828, '邗江南路', '321000', '扬州', 1.30, 43.30, 14.40, 3.10);
INSERT INTO `city_road` VALUES (1829, '四望亭路', '321000', '扬州', 1.30, 29.40, 5.80, 1.20);
INSERT INTO `city_road` VALUES (1830, '念四桥路', '321000', '扬州', 1.20, 31.20, 5.00, 1.00);
INSERT INTO `city_road` VALUES (1831, '祥济路', '370800', '济宁', 1.70, 27.50, 10.90, 4.50);
INSERT INTO `city_road` VALUES (1832, '太白楼中路', '370800', '济宁', 1.30, 31.80, 5.10, 1.30);
INSERT INTO `city_road` VALUES (1833, '祥济路', '370800', '济宁', 1.30, 35.70, 8.40, 2.10);
INSERT INTO `city_road` VALUES (1834, '玄帝庙街', '370800', '济宁', 1.30, 27.10, 7.10, 1.70);
INSERT INTO `city_road` VALUES (1835, '荷花路', '370800', '济宁', 1.30, 37.90, 10.40, 2.30);
INSERT INTO `city_road` VALUES (1836, '荷花路', '370800', '济宁', 1.30, 38.20, 7.70, 1.60);
INSERT INTO `city_road` VALUES (1837, '供销路', '370800', '济宁', 1.20, 29.50, 7.10, 1.40);
INSERT INTO `city_road` VALUES (1838, '任城大道', '370800', '济宁', 1.20, 40.30, 5.10, 0.90);
INSERT INTO `city_road` VALUES (1839, '太白楼东路', '370800', '济宁', 1.20, 43.10, 6.20, 1.10);
INSERT INTO `city_road` VALUES (1840, '吴泰闸路', '370800', '济宁', 1.20, 37.10, 7.20, 1.30);
INSERT INTO `city_road` VALUES (1841, '同明路', '350200', '厦门', 1.90, 16.10, 11.50, 5.30);
INSERT INTO `city_road` VALUES (1842, '同明路', '350200', '厦门', 1.80, 16.60, 11.20, 4.90);
INSERT INTO `city_road` VALUES (1843, '仙岳路辅路', '350200', '厦门', 1.50, 31.40, 4.30, 1.40);
INSERT INTO `city_road` VALUES (1844, '天安路', '350200', '厦门', 1.40, 21.60, 6.40, 2.00);
INSERT INTO `city_road` VALUES (1845, '九天湖路', '350200', '厦门', 1.40, 24.60, 6.10, 1.70);
INSERT INTO `city_road` VALUES (1846, '枋湖东路', '350200', '厦门', 1.40, 26.10, 5.80, 1.60);
INSERT INTO `city_road` VALUES (1847, '思明南路', '350200', '厦门', 1.40, 25.80, 6.00, 1.60);
INSERT INTO `city_road` VALUES (1848, '仙岳路辅路', '350200', '厦门', 1.40, 36.30, 5.90, 1.60);
INSERT INTO `city_road` VALUES (1849, '禾祥西路', '350200', '厦门', 1.40, 25.90, 6.00, 1.60);
INSERT INTO `city_road` VALUES (1850, '厦禾路', '350200', '厦门', 1.40, 36.80, 8.90, 2.30);
INSERT INTO `city_road` VALUES (1851, '渎边线', '320400', '常州', 1.20, 49.70, 2.70, 0.50);
INSERT INTO `city_road` VALUES (1852, '武宜中路', '320400', '常州', 1.20, 38.40, 6.10, 1.20);
INSERT INTO `city_road` VALUES (1853, '星园路', '320400', '常州', 1.20, 33.20, 5.70, 1.10);
INSERT INTO `city_road` VALUES (1854, '横林大道', '320400', '常州', 1.20, 40.40, 3.30, 0.60);
INSERT INTO `city_road` VALUES (1855, '华山南路', '320400', '常州', 1.20, 31.60, 4.10, 0.80);
INSERT INTO `city_road` VALUES (1856, '玉塘路', '320400', '常州', 1.20, 33.00, 5.60, 1.10);
INSERT INTO `city_road` VALUES (1857, '关河西路', '320400', '常州', 1.20, 35.20, 4.50, 0.90);
INSERT INTO `city_road` VALUES (1858, '飞龙东路', '320400', '常州', 1.20, 35.70, 6.60, 1.30);
INSERT INTO `city_road` VALUES (1859, '虹西路', '320400', '常州', 1.20, 44.30, 8.50, 1.60);
INSERT INTO `city_road` VALUES (1860, '永宁北路', '320400', '常州', 1.20, 35.20, 6.40, 1.20);
INSERT INTO `city_road` VALUES (1861, '科苑北路', '320700', '连云港', 1.40, 39.00, 3.20, 0.90);
INSERT INTO `city_road` VALUES (1862, '巨龙南路', '320700', '连云港', 1.40, 30.00, 5.70, 1.60);
INSERT INTO `city_road` VALUES (1863, '巨龙南路', '320700', '连云港', 1.40, 29.70, 5.80, 1.50);
INSERT INTO `city_road` VALUES (1864, '镇海路', '320700', '连云港', 1.30, 33.20, 4.40, 1.10);
INSERT INTO `city_road` VALUES (1865, '东关路', '320700', '连云港', 1.30, 31.40, 5.70, 1.40);
INSERT INTO `city_road` VALUES (1866, '华中路', '320700', '连云港', 1.30, 31.00, 5.20, 1.20);
INSERT INTO `city_road` VALUES (1867, '中山西路', '320700', '连云港', 1.30, 35.30, 4.50, 1.00);
INSERT INTO `city_road` VALUES (1868, '海连东路', '320700', '连云港', 1.30, 35.40, 4.40, 1.00);
INSERT INTO `city_road` VALUES (1869, '海昌南路', '320700', '连云港', 1.30, 28.10, 4.30, 0.90);
INSERT INTO `city_road` VALUES (1870, '通灌南路', '320700', '连云港', 1.30, 32.80, 6.70, 1.40);
INSERT INTO `city_road` VALUES (1871, '友新快速路', '320500', '苏州', 2.10, 36.60, 16.50, 8.60);
INSERT INTO `city_road` VALUES (1872, '东振路', '320500', '苏州', 2.00, 20.40, 6.10, 3.10);
INSERT INTO `city_road` VALUES (1873, '东振路', '320500', '苏州', 1.80, 22.80, 5.50, 2.40);
INSERT INTO `city_road` VALUES (1874, '金陵西路', '320500', '苏州', 1.60, 23.70, 9.00, 3.40);
INSERT INTO `city_road` VALUES (1875, '桐泾北路', '320500', '苏州', 1.50, 32.80, 7.20, 2.40);
INSERT INTO `city_road` VALUES (1876, '汾湖路', '320500', '苏州', 1.50, 28.30, 4.30, 1.40);
INSERT INTO `city_road` VALUES (1877, '中山北路', '320500', '苏州', 1.50, 31.70, 12.80, 4.00);
INSERT INTO `city_road` VALUES (1878, '中山北路', '320500', '苏州', 1.40, 33.50, 12.10, 3.60);
INSERT INTO `city_road` VALUES (1879, '干将东路', '320500', '苏州', 1.30, 32.80, 4.60, 1.20);
INSERT INTO `city_road` VALUES (1880, '人民路', '320500', '苏州', 1.30, 32.60, 17.20, 4.30);
INSERT INTO `city_road` VALUES (1881, '银安街', '331000', '台州', 1.70, 22.70, 7.90, 3.40);
INSERT INTO `city_road` VALUES (1882, '银安街', '331000', '台州', 1.60, 23.90, 7.50, 2.80);
INSERT INTO `city_road` VALUES (1883, '广场西路', '331000', '台州', 1.40, 25.60, 4.80, 1.30);
INSERT INTO `city_road` VALUES (1884, '鸿州大道', '331000', '台州', 1.30, 32.20, 6.70, 1.60);
INSERT INTO `city_road` VALUES (1885, '鸿州大道', '331000', '台州', 1.30, 30.90, 7.10, 1.60);
INSERT INTO `city_road` VALUES (1886, '商海南街', '331000', '台州', 1.30, 31.40, 4.50, 1.00);
INSERT INTO `city_road` VALUES (1887, '洪灵路', '331000', '台州', 1.30, 30.20, 5.70, 1.30);
INSERT INTO `city_road` VALUES (1888, '广场南路', '331000', '台州', 1.30, 29.40, 4.50, 1.00);
INSERT INTO `city_road` VALUES (1889, '银安西街', '331000', '台州', 1.30, 33.30, 5.40, 1.10);
INSERT INTO `city_road` VALUES (1890, '中山西路', '331000', '台州', 1.30, 30.30, 4.80, 1.00);
INSERT INTO `city_road` VALUES (1891, '大沽南路', '120000', '天津', 1.90, 28.80, 22.90, 10.90);
INSERT INTO `city_road` VALUES (1892, '河北路', '120000', '天津', 1.60, 21.50, 7.50, 2.70);
INSERT INTO `city_road` VALUES (1893, '黑牛城道辅路', '120000', '天津', 1.40, 32.10, 12.10, 3.60);
INSERT INTO `city_road` VALUES (1894, '新慧路', '120000', '天津', 1.40, 31.30, 5.30, 1.40);
INSERT INTO `city_road` VALUES (1895, '气象台路', '120000', '天津', 1.30, 32.10, 4.10, 1.00);
INSERT INTO `city_road` VALUES (1896, '月牙河西路', '120000', '天津', 1.30, 29.40, 4.80, 1.20);
INSERT INTO `city_road` VALUES (1897, '宾水西道延长线', '120000', '天津', 1.30, 41.50, 5.40, 1.30);
INSERT INTO `city_road` VALUES (1898, '大沽南路辅路', '120000', '天津', 1.30, 35.20, 9.50, 2.30);
INSERT INTO `city_road` VALUES (1899, '秀川路', '120000', '天津', 1.30, 34.30, 8.00, 1.80);
INSERT INTO `city_road` VALUES (1900, '贵州路', '120000', '天津', 1.30, 29.60, 4.10, 0.90);
INSERT INTO `city_road` VALUES (1901, '重庆路', '370300', '淄博', 1.20, 32.00, 7.10, 1.30);
INSERT INTO `city_road` VALUES (1902, '鲁山大道', '370300', '淄博', 1.20, 48.30, 13.90, 2.50);
INSERT INTO `city_road` VALUES (1903, '共青团西路', '370300', '淄博', 1.20, 31.60, 7.80, 1.40);
INSERT INTO `city_road` VALUES (1904, '柳园路', '370300', '淄博', 1.20, 38.50, 4.60, 0.80);
INSERT INTO `city_road` VALUES (1905, '共青团西路', '370300', '淄博', 1.20, 32.60, 7.60, 1.20);
INSERT INTO `city_road` VALUES (1906, '米河路', '370300', '淄博', 1.20, 35.50, 3.40, 0.60);
INSERT INTO `city_road` VALUES (1907, '鲁泰大道辅路', '370300', '淄博', 1.20, 39.70, 5.80, 0.90);
INSERT INTO `city_road` VALUES (1908, '102省道', '370300', '淄博', 1.20, 49.20, 33.00, 5.10);
INSERT INTO `city_road` VALUES (1909, '人民西路', '370300', '淄博', 1.20, 35.40, 4.00, 0.60);
INSERT INTO `city_road` VALUES (1910, '西二路', '370300', '淄博', 1.20, 29.30, 5.90, 0.90);
INSERT INTO `city_road` VALUES (1911, '文昌西路', '340200', '芜湖', 1.40, 28.40, 4.30, 1.20);
INSERT INTO `city_road` VALUES (1912, '中山北路', '340200', '芜湖', 1.30, 31.70, 4.00, 0.90);
INSERT INTO `city_road` VALUES (1913, '文昌西路', '340200', '芜湖', 1.30, 30.50, 4.00, 0.90);
INSERT INTO `city_road` VALUES (1914, '文津西路', '340200', '芜湖', 1.30, 30.10, 4.50, 0.90);
INSERT INTO `city_road` VALUES (1915, '文津西路', '340200', '芜湖', 1.30, 31.00, 4.40, 0.90);
INSERT INTO `city_road` VALUES (1916, '涌金路', '340200', '芜湖', 1.20, 30.40, 6.60, 1.20);
INSERT INTO `city_road` VALUES (1917, '乌霞山路', '340200', '芜湖', 1.20, 34.70, 4.40, 0.80);
INSERT INTO `city_road` VALUES (1918, '鸠江北路', '340200', '芜湖', 1.20, 35.80, 7.60, 1.30);
INSERT INTO `city_road` VALUES (1919, '中山北路', '340200', '芜湖', 1.20, 33.40, 3.70, 0.60);
INSERT INTO `city_road` VALUES (1920, '沿河路', '340200', '芜湖', 1.20, 38.00, 5.70, 0.90);
INSERT INTO `city_road` VALUES (1921, '育才路', '330600', '绍兴', 1.30, 32.20, 9.60, 2.30);
INSERT INTO `city_road` VALUES (1922, '江东路', '330600', '绍兴', 1.30, 37.20, 4.60, 1.00);
INSERT INTO `city_road` VALUES (1923, '湖西路', '330600', '绍兴', 1.30, 30.90, 6.30, 1.40);
INSERT INTO `city_road` VALUES (1924, '博文路', '330600', '绍兴', 1.30, 34.10, 3.80, 0.80);
INSERT INTO `city_road` VALUES (1925, '越州大道', '330600', '绍兴', 1.30, 35.10, 8.10, 1.70);
INSERT INTO `city_road` VALUES (1926, '环城北路', '330600', '绍兴', 1.30, 35.00, 3.70, 0.80);
INSERT INTO `city_road` VALUES (1927, '环城南路', '330600', '绍兴', 1.30, 36.30, 4.00, 0.80);
INSERT INTO `city_road` VALUES (1928, '湖中路', '330600', '绍兴', 1.30, 29.30, 6.10, 1.20);
INSERT INTO `city_road` VALUES (1929, '安昌路', '330600', '绍兴', 1.30, 31.50, 5.20, 1.10);
INSERT INTO `city_road` VALUES (1930, '湖西路', '330600', '绍兴', 1.30, 31.30, 6.20, 1.20);
INSERT INTO `city_road` VALUES (1931, '汉景大道', '320300', '徐州', 1.40, 26.90, 5.10, 1.60);
INSERT INTO `city_road` VALUES (1932, '天齐南路', '320300', '徐州', 1.30, 35.60, 4.20, 1.10);
INSERT INTO `city_road` VALUES (1933, '苏堤路', '320300', '徐州', 1.30, 31.40, 5.90, 1.50);
INSERT INTO `city_road` VALUES (1934, '汉景大道', '320300', '徐州', 1.30, 28.60, 4.80, 1.20);
INSERT INTO `city_road` VALUES (1935, '泰山路', '320300', '徐州', 1.30, 37.50, 6.40, 1.40);
INSERT INTO `city_road` VALUES (1936, '矿山路', '320300', '徐州', 1.30, 33.20, 4.70, 1.00);
INSERT INTO `city_road` VALUES (1937, '响山路', '320300', '徐州', 1.30, 35.50, 3.40, 0.70);
INSERT INTO `city_road` VALUES (1938, '北京路', '320300', '徐州', 1.20, 37.20, 5.80, 1.10);
INSERT INTO `city_road` VALUES (1939, '和平路', '320300', '徐州', 1.20, 41.80, 6.80, 1.40);
INSERT INTO `city_road` VALUES (1940, '中山南路', '320300', '徐州', 1.20, 35.00, 3.80, 0.70);
INSERT INTO `city_road` VALUES (1941, '同心路', '330500', '湖州', 1.50, 38.40, 9.70, 3.30);
INSERT INTO `city_road` VALUES (1942, '康泰西路', '330500', '湖州', 1.40, 24.70, 5.90, 1.70);
INSERT INTO `city_road` VALUES (1943, '富民路', '330500', '湖州', 1.40, 26.00, 5.30, 1.50);
INSERT INTO `city_road` VALUES (1944, '利济西路', '330500', '湖州', 1.40, 29.60, 5.20, 1.50);
INSERT INTO `city_road` VALUES (1945, '康泰西路', '330500', '湖州', 1.40, 24.80, 5.80, 1.60);
INSERT INTO `city_road` VALUES (1946, '利济西路', '330500', '湖州', 1.40, 30.30, 5.10, 1.40);
INSERT INTO `city_road` VALUES (1947, '姚山路', '330500', '湖州', 1.40, 31.50, 6.30, 1.70);
INSERT INTO `city_road` VALUES (1948, '长安西路', '330500', '湖州', 1.40, 27.80, 4.80, 1.30);
INSERT INTO `city_road` VALUES (1949, '富民路', '330500', '湖州', 1.40, 26.40, 5.20, 1.40);
INSERT INTO `city_road` VALUES (1950, '长安西路', '330500', '湖州', 1.30, 27.40, 4.90, 1.20);
INSERT INTO `city_road` VALUES (1951, '北门大街', '320800', '淮安', 1.40, 30.70, 4.60, 1.30);
INSERT INTO `city_road` VALUES (1952, '二支线', '320800', '淮安', 1.30, 50.70, 3.20, 0.70);
INSERT INTO `city_road` VALUES (1953, '北门大街', '320800', '淮安', 1.30, 33.50, 4.30, 1.00);
INSERT INTO `city_road` VALUES (1954, '楚州大道', '320800', '淮安', 1.30, 35.80, 10.30, 2.10);
INSERT INTO `city_road` VALUES (1955, '城西北路', '320800', '淮安', 1.30, 37.30, 4.70, 0.90);
INSERT INTO `city_road` VALUES (1956, '城西北路', '320800', '淮安', 1.20, 38.80, 4.60, 0.90);
INSERT INTO `city_road` VALUES (1957, '西安北路', '320800', '淮安', 1.20, 41.20, 4.30, 0.80);
INSERT INTO `city_road` VALUES (1958, '解放东路', '320800', '淮安', 1.20, 35.20, 3.60, 0.70);
INSERT INTO `city_road` VALUES (1959, '香江路', '320800', '淮安', 1.20, 28.00, 6.90, 1.30);
INSERT INTO `city_road` VALUES (1960, '343国道', '320800', '淮安', 1.20, 49.70, 48.70, 8.90);
INSERT INTO `city_road` VALUES (1961, '口泰路', '321200', '泰州', 1.60, 23.60, 11.60, 4.10);
INSERT INTO `city_road` VALUES (1962, '春晖路', '321200', '泰州', 1.30, 31.00, 12.50, 3.00);
INSERT INTO `city_road` VALUES (1963, '鼓楼北路', '321200', '泰州', 1.30, 34.50, 5.10, 1.10);
INSERT INTO `city_road` VALUES (1964, '静安路', '321200', '泰州', 1.20, 31.00, 4.50, 0.90);
INSERT INTO `city_road` VALUES (1965, '春晖路', '321200', '泰州', 1.20, 32.30, 11.90, 2.30);
INSERT INTO `city_road` VALUES (1966, '青年南路', '321200', '泰州', 1.20, 37.10, 7.20, 1.40);
INSERT INTO `city_road` VALUES (1967, '兴泰南路', '321200', '泰州', 1.20, 43.80, 5.60, 1.10);
INSERT INTO `city_road` VALUES (1968, '海陵南路', '321200', '泰州', 1.20, 38.90, 16.90, 3.00);
INSERT INTO `city_road` VALUES (1969, '青年南路', '321200', '泰州', 1.20, 37.30, 7.20, 1.30);
INSERT INTO `city_road` VALUES (1970, '泰州大道', '321200', '泰州', 1.20, 46.00, 13.90, 2.30);
INSERT INTO `city_road` VALUES (1971, '金磐路', '330700', '金华', 1.20, 30.70, 5.20, 1.00);
INSERT INTO `city_road` VALUES (1972, '和信路', '330700', '金华', 1.20, 31.80, 4.30, 0.80);
INSERT INTO `city_road` VALUES (1973, '兰溪街', '330700', '金华', 1.20, 29.40, 7.40, 1.30);
INSERT INTO `city_road` VALUES (1974, '和信路', '330700', '金华', 1.20, 33.10, 4.20, 0.70);
INSERT INTO `city_road` VALUES (1975, '人民东路', '330700', '金华', 1.20, 33.30, 5.00, 0.80);
INSERT INTO `city_road` VALUES (1976, '金磐路', '330700', '金华', 1.20, 31.60, 5.00, 0.80);
INSERT INTO `city_road` VALUES (1977, '八达中路', '330700', '金华', 1.20, 37.80, 4.30, 0.70);
INSERT INTO `city_road` VALUES (1978, '同心路', '330700', '金华', 1.20, 29.60, 4.40, 0.70);
INSERT INTO `city_road` VALUES (1979, '八一北街', '330700', '金华', 1.20, 41.20, 3.40, 0.50);
INSERT INTO `city_road` VALUES (1980, '八达中路', '330700', '金华', 1.20, 37.90, 4.30, 0.60);
INSERT INTO `city_road` VALUES (1981, '梅秦路', '320200', '无锡', 2.10, 20.90, 7.10, 3.70);
INSERT INTO `city_road` VALUES (1982, '文瑞路', '320200', '无锡', 1.80, 27.30, 4.70, 2.00);
INSERT INTO `city_road` VALUES (1983, '文瑞路', '320200', '无锡', 1.60, 29.30, 4.40, 1.70);
INSERT INTO `city_road` VALUES (1984, '行创四路', '320200', '无锡', 1.40, 30.30, 9.20, 2.70);
INSERT INTO `city_road` VALUES (1985, '隐秀路', '320200', '无锡', 1.40, 32.70, 13.20, 3.60);
INSERT INTO `city_road` VALUES (1986, '观山路', '320200', '无锡', 1.40, 36.20, 14.20, 3.80);
INSERT INTO `city_road` VALUES (1987, '大剧院路', '320200', '无锡', 1.40, 31.70, 4.00, 1.10);
INSERT INTO `city_road` VALUES (1988, '隐秀路', '320200', '无锡', 1.30, 32.90, 13.10, 3.40);
INSERT INTO `city_road` VALUES (1989, '观山路', '320200', '无锡', 1.30, 36.50, 14.00, 3.50);
INSERT INTO `city_road` VALUES (1990, '政和大道', '320200', '无锡', 1.30, 35.90, 6.80, 1.60);
INSERT INTO `city_road` VALUES (1991, '现代大道', '320600', '南通', 1.30, 28.10, 8.10, 1.90);
INSERT INTO `city_road` VALUES (1992, '工农路', '320600', '南通', 1.30, 37.50, 7.80, 1.80);
INSERT INTO `city_road` VALUES (1993, '人民西路', '320600', '南通', 1.20, 37.00, 4.70, 0.90);
INSERT INTO `city_road` VALUES (1994, '北大街', '320600', '南通', 1.20, 39.20, 4.40, 0.80);
INSERT INTO `city_road` VALUES (1995, '345国道', '320600', '南通', 1.20, 47.80, 25.40, 4.80);
INSERT INTO `city_road` VALUES (1996, '工农路', '320600', '南通', 1.20, 41.10, 7.20, 1.30);
INSERT INTO `city_road` VALUES (1997, '金浩大道', '320600', '南通', 1.20, 47.20, 3.00, 0.50);
INSERT INTO `city_road` VALUES (1998, '红星路', '320600', '南通', 1.20, 36.60, 5.80, 1.00);
INSERT INTO `city_road` VALUES (1999, '通盛大道', '320600', '南通', 1.20, 44.90, 12.40, 2.10);
INSERT INTO `city_road` VALUES (2000, '湘江北路', '320600', '南通', 1.20, 37.90, 5.70, 0.90);
-- ----------------------------
-- Table structure for city_week
-- ----------------------------
DROP TABLE IF EXISTS `city_week`;
CREATE TABLE `city_week` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`code` int(10) NOT NULL,
`res` double(10, 2) NOT NULL,
`inert_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 701 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of city_week
-- ----------------------------
INSERT INTO `city_week` VALUES (1, '海口', 460100, 20.83, '1709395200000');
INSERT INTO `city_week` VALUES (2, '海口', 460100, 22.22, '1709481600000');
INSERT INTO `city_week` VALUES (3, '海口', 460100, 20.14, '1709568000000');
INSERT INTO `city_week` VALUES (4, '海口', 460100, 17.36, '1709654400000');
INSERT INTO `city_week` VALUES (5, '海口', 460100, 25.00, '1709740800000');
INSERT INTO `city_week` VALUES (6, '海口', 460100, 47.92, '1709827200000');
INSERT INTO `city_week` VALUES (7, '海口', 460100, 31.25, '1709913600000');
INSERT INTO `city_week` VALUES (8, '三亚', 460200, 16.67, '1709395200000');
INSERT INTO `city_week` VALUES (9, '三亚', 460200, 15.97, '1709481600000');
INSERT INTO `city_week` VALUES (10, '三亚', 460200, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (11, '三亚', 460200, 13.89, '1709654400000');
INSERT INTO `city_week` VALUES (12, '三亚', 460200, 13.89, '1709740800000');
INSERT INTO `city_week` VALUES (13, '三亚', 460200, 26.39, '1709827200000');
INSERT INTO `city_week` VALUES (14, '三亚', 460200, 16.67, '1709913600000');
INSERT INTO `city_week` VALUES (15, '成都', 510100, 34.72, '1709395200000');
INSERT INTO `city_week` VALUES (16, '成都', 510100, 29.17, '1709481600000');
INSERT INTO `city_week` VALUES (17, '成都', 510100, 32.64, '1709568000000');
INSERT INTO `city_week` VALUES (18, '成都', 510100, 27.78, '1709654400000');
INSERT INTO `city_week` VALUES (19, '成都', 510100, 37.50, '1709740800000');
INSERT INTO `city_week` VALUES (20, '成都', 510100, 58.33, '1709827200000');
INSERT INTO `city_week` VALUES (21, '成都', 510100, 48.61, '1709913600000');
INSERT INTO `city_week` VALUES (22, '桂林', 450300, 26.39, '1709395200000');
INSERT INTO `city_week` VALUES (23, '桂林', 450300, 18.75, '1709481600000');
INSERT INTO `city_week` VALUES (24, '桂林', 450300, 11.81, '1709568000000');
INSERT INTO `city_week` VALUES (25, '桂林', 450300, 11.81, '1709654400000');
INSERT INTO `city_week` VALUES (26, '桂林', 450300, 11.11, '1709740800000');
INSERT INTO `city_week` VALUES (27, '桂林', 450300, 20.14, '1709827200000');
INSERT INTO `city_week` VALUES (28, '桂林', 450300, 31.94, '1709913600000');
INSERT INTO `city_week` VALUES (29, '西安', 610100, 45.14, '1709395200000');
INSERT INTO `city_week` VALUES (30, '西安', 610100, 29.17, '1709481600000');
INSERT INTO `city_week` VALUES (31, '西安', 610100, 32.64, '1709568000000');
INSERT INTO `city_week` VALUES (32, '西安', 610100, 37.50, '1709654400000');
INSERT INTO `city_week` VALUES (33, '西安', 610100, 48.61, '1709740800000');
INSERT INTO `city_week` VALUES (34, '西安', 610100, 62.50, '1709827200000');
INSERT INTO `city_week` VALUES (35, '西安', 610100, 52.78, '1709913600000');
INSERT INTO `city_week` VALUES (36, '伊犁', 654000, 34.03, '1709395200000');
INSERT INTO `city_week` VALUES (37, '伊犁', 654000, 25.00, '1709481600000');
INSERT INTO `city_week` VALUES (38, '伊犁', 654000, 19.44, '1709568000000');
INSERT INTO `city_week` VALUES (39, '伊犁', 654000, 22.22, '1709654400000');
INSERT INTO `city_week` VALUES (40, '伊犁', 654000, 22.22, '1709740800000');
INSERT INTO `city_week` VALUES (41, '伊犁', 654000, 45.83, '1709827200000');
INSERT INTO `city_week` VALUES (42, '伊犁', 654000, 40.97, '1709913600000');
INSERT INTO `city_week` VALUES (43, '惠州', 441300, 15.28, '1709395200000');
INSERT INTO `city_week` VALUES (44, '惠州', 441300, 9.03, '1709481600000');
INSERT INTO `city_week` VALUES (45, '惠州', 441300, 9.03, '1709568000000');
INSERT INTO `city_week` VALUES (46, '惠州', 441300, 9.72, '1709654400000');
INSERT INTO `city_week` VALUES (47, '惠州', 441300, 6.25, '1709740800000');
INSERT INTO `city_week` VALUES (48, '惠州', 441300, 21.53, '1709827200000');
INSERT INTO `city_week` VALUES (49, '惠州', 441300, 7.64, '1709913600000');
INSERT INTO `city_week` VALUES (50, '银川', 640100, 25.00, '1709395200000');
INSERT INTO `city_week` VALUES (51, '银川', 640100, 21.53, '1709481600000');
INSERT INTO `city_week` VALUES (52, '银川', 640100, 19.44, '1709568000000');
INSERT INTO `city_week` VALUES (53, '银川', 640100, 20.83, '1709654400000');
INSERT INTO `city_week` VALUES (54, '银川', 640100, 23.61, '1709740800000');
INSERT INTO `city_week` VALUES (55, '银川', 640100, 37.50, '1709827200000');
INSERT INTO `city_week` VALUES (56, '银川', 640100, 33.33, '1709913600000');
INSERT INTO `city_week` VALUES (57, '南充', 511300, 16.67, '1709395200000');
INSERT INTO `city_week` VALUES (58, '南充', 511300, 28.47, '1709481600000');
INSERT INTO `city_week` VALUES (59, '南充', 511300, 27.08, '1709568000000');
INSERT INTO `city_week` VALUES (60, '南充', 511300, 26.39, '1709654400000');
INSERT INTO `city_week` VALUES (61, '南充', 511300, 22.92, '1709740800000');
INSERT INTO `city_week` VALUES (62, '南充', 511300, 47.22, '1709827200000');
INSERT INTO `city_week` VALUES (63, '南充', 511300, 26.39, '1709913600000');
INSERT INTO `city_week` VALUES (64, '柳州', 450200, 31.25, '1709395200000');
INSERT INTO `city_week` VALUES (65, '柳州', 450200, 15.28, '1709481600000');
INSERT INTO `city_week` VALUES (66, '柳州', 450200, 11.11, '1709568000000');
INSERT INTO `city_week` VALUES (67, '柳州', 450200, 11.11, '1709654400000');
INSERT INTO `city_week` VALUES (68, '柳州', 450200, 11.11, '1709740800000');
INSERT INTO `city_week` VALUES (69, '柳州', 450200, 22.22, '1709827200000');
INSERT INTO `city_week` VALUES (70, '柳州', 450200, 31.25, '1709913600000');
INSERT INTO `city_week` VALUES (71, '郑州', 410100, 24.31, '1709395200000');
INSERT INTO `city_week` VALUES (72, '郑州', 410100, 20.83, '1709481600000');
INSERT INTO `city_week` VALUES (73, '郑州', 410100, 17.36, '1709568000000');
INSERT INTO `city_week` VALUES (74, '郑州', 410100, 22.22, '1709654400000');
INSERT INTO `city_week` VALUES (75, '郑州', 410100, 16.67, '1709740800000');
INSERT INTO `city_week` VALUES (76, '郑州', 410100, 34.72, '1709827200000');
INSERT INTO `city_week` VALUES (77, '郑州', 410100, 31.25, '1709913600000');
INSERT INTO `city_week` VALUES (78, '兰州', 620100, 43.75, '1709395200000');
INSERT INTO `city_week` VALUES (79, '兰州', 620100, 43.75, '1709481600000');
INSERT INTO `city_week` VALUES (80, '兰州', 620100, 36.81, '1709568000000');
INSERT INTO `city_week` VALUES (81, '兰州', 620100, 37.50, '1709654400000');
INSERT INTO `city_week` VALUES (82, '兰州', 620100, 40.97, '1709740800000');
INSERT INTO `city_week` VALUES (83, '兰州', 620100, 61.81, '1709827200000');
INSERT INTO `city_week` VALUES (84, '兰州', 620100, 48.61, '1709913600000');
INSERT INTO `city_week` VALUES (85, '济南', 370100, 36.11, '1709395200000');
INSERT INTO `city_week` VALUES (86, '济南', 370100, 25.69, '1709481600000');
INSERT INTO `city_week` VALUES (87, '济南', 370100, 28.47, '1709568000000');
INSERT INTO `city_week` VALUES (88, '济南', 370100, 26.39, '1709654400000');
INSERT INTO `city_week` VALUES (89, '济南', 370100, 25.00, '1709740800000');
INSERT INTO `city_week` VALUES (90, '济南', 370100, 41.67, '1709827200000');
INSERT INTO `city_week` VALUES (91, '济南', 370100, 47.22, '1709913600000');
INSERT INTO `city_week` VALUES (92, '南宁', 450100, 6.94, '1709395200000');
INSERT INTO `city_week` VALUES (93, '南宁', 450100, 11.11, '1709481600000');
INSERT INTO `city_week` VALUES (94, '南宁', 450100, 6.25, '1709568000000');
INSERT INTO `city_week` VALUES (95, '南宁', 450100, 6.25, '1709654400000');
INSERT INTO `city_week` VALUES (96, '南宁', 450100, 6.25, '1709740800000');
INSERT INTO `city_week` VALUES (97, '南宁', 450100, 13.19, '1709827200000');
INSERT INTO `city_week` VALUES (98, '南宁', 450100, 29.17, '1709913600000');
INSERT INTO `city_week` VALUES (99, '新乡', 410700, 25.69, '1709395200000');
INSERT INTO `city_week` VALUES (100, '新乡', 410700, 14.58, '1709481600000');
INSERT INTO `city_week` VALUES (101, '新乡', 410700, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (102, '新乡', 410700, 19.44, '1709654400000');
INSERT INTO `city_week` VALUES (103, '新乡', 410700, 18.06, '1709740800000');
INSERT INTO `city_week` VALUES (104, '新乡', 410700, 34.03, '1709827200000');
INSERT INTO `city_week` VALUES (105, '新乡', 410700, 34.72, '1709913600000');
INSERT INTO `city_week` VALUES (106, '咸阳', 610400, 25.69, '1709395200000');
INSERT INTO `city_week` VALUES (107, '咸阳', 610400, 12.50, '1709481600000');
INSERT INTO `city_week` VALUES (108, '咸阳', 610400, 11.81, '1709568000000');
INSERT INTO `city_week` VALUES (109, '咸阳', 610400, 11.11, '1709654400000');
INSERT INTO `city_week` VALUES (110, '咸阳', 610400, 14.58, '1709740800000');
INSERT INTO `city_week` VALUES (111, '咸阳', 610400, 24.31, '1709827200000');
INSERT INTO `city_week` VALUES (112, '咸阳', 610400, 35.42, '1709913600000');
INSERT INTO `city_week` VALUES (113, '太原', 140100, 21.53, '1709395200000');
INSERT INTO `city_week` VALUES (114, '太原', 140100, 19.44, '1709481600000');
INSERT INTO `city_week` VALUES (115, '太原', 140100, 15.97, '1709568000000');
INSERT INTO `city_week` VALUES (116, '太原', 140100, 14.58, '1709654400000');
INSERT INTO `city_week` VALUES (117, '太原', 140100, 17.36, '1709740800000');
INSERT INTO `city_week` VALUES (118, '太原', 140100, 25.00, '1709827200000');
INSERT INTO `city_week` VALUES (119, '太原', 140100, 19.44, '1709913600000');
INSERT INTO `city_week` VALUES (120, '大同', 140200, 15.97, '1709395200000');
INSERT INTO `city_week` VALUES (121, '大同', 140200, 16.67, '1709481600000');
INSERT INTO `city_week` VALUES (122, '大同', 140200, 14.58, '1709568000000');
INSERT INTO `city_week` VALUES (123, '大同', 140200, 15.28, '1709654400000');
INSERT INTO `city_week` VALUES (124, '大同', 140200, 15.28, '1709740800000');
INSERT INTO `city_week` VALUES (125, '大同', 140200, 25.69, '1709827200000');
INSERT INTO `city_week` VALUES (126, '大同', 140200, 22.22, '1709913600000');
INSERT INTO `city_week` VALUES (127, '深圳', 440300, 20.83, '1709395200000');
INSERT INTO `city_week` VALUES (128, '深圳', 440300, 28.47, '1709481600000');
INSERT INTO `city_week` VALUES (129, '深圳', 440300, 34.72, '1709568000000');
INSERT INTO `city_week` VALUES (130, '深圳', 440300, 28.47, '1709654400000');
INSERT INTO `city_week` VALUES (131, '深圳', 440300, 29.17, '1709740800000');
INSERT INTO `city_week` VALUES (132, '深圳', 440300, 43.75, '1709827200000');
INSERT INTO `city_week` VALUES (133, '深圳', 440300, 22.92, '1709913600000');
INSERT INTO `city_week` VALUES (134, '南阳', 411300, 28.47, '1709395200000');
INSERT INTO `city_week` VALUES (135, '南阳', 411300, 14.58, '1709481600000');
INSERT INTO `city_week` VALUES (136, '南阳', 411300, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (137, '南阳', 411300, 12.50, '1709654400000');
INSERT INTO `city_week` VALUES (138, '南阳', 411300, 13.89, '1709740800000');
INSERT INTO `city_week` VALUES (139, '南阳', 411300, 27.08, '1709827200000');
INSERT INTO `city_week` VALUES (140, '南阳', 411300, 38.19, '1709913600000');
INSERT INTO `city_week` VALUES (141, '长沙', 430100, 23.61, '1709395200000');
INSERT INTO `city_week` VALUES (142, '长沙', 430100, 24.31, '1709481600000');
INSERT INTO `city_week` VALUES (143, '长沙', 430100, 21.53, '1709568000000');
INSERT INTO `city_week` VALUES (144, '长沙', 430100, 18.06, '1709654400000');
INSERT INTO `city_week` VALUES (145, '长沙', 430100, 20.14, '1709740800000');
INSERT INTO `city_week` VALUES (146, '长沙', 430100, 41.67, '1709827200000');
INSERT INTO `city_week` VALUES (147, '长沙', 430100, 24.31, '1709913600000');
INSERT INTO `city_week` VALUES (148, '茂名', 440900, 10.42, '1709395200000');
INSERT INTO `city_week` VALUES (149, '茂名', 440900, 11.11, '1709481600000');
INSERT INTO `city_week` VALUES (150, '茂名', 440900, 6.94, '1709568000000');
INSERT INTO `city_week` VALUES (151, '茂名', 440900, 7.64, '1709654400000');
INSERT INTO `city_week` VALUES (152, '茂名', 440900, 8.33, '1709740800000');
INSERT INTO `city_week` VALUES (153, '茂名', 440900, 18.06, '1709827200000');
INSERT INTO `city_week` VALUES (154, '茂名', 440900, 6.94, '1709913600000');
INSERT INTO `city_week` VALUES (155, '广州', 440100, 22.92, '1709395200000');
INSERT INTO `city_week` VALUES (156, '广州', 440100, 44.44, '1709481600000');
INSERT INTO `city_week` VALUES (157, '广州', 440100, 38.19, '1709568000000');
INSERT INTO `city_week` VALUES (158, '广州', 440100, 36.81, '1709654400000');
INSERT INTO `city_week` VALUES (159, '广州', 440100, 34.03, '1709740800000');
INSERT INTO `city_week` VALUES (160, '广州', 440100, 47.92, '1709827200000');
INSERT INTO `city_week` VALUES (161, '广州', 440100, 47.22, '1709913600000');
INSERT INTO `city_week` VALUES (162, '邯郸', 130400, 10.42, '1709395200000');
INSERT INTO `city_week` VALUES (163, '邯郸', 130400, 17.36, '1709481600000');
INSERT INTO `city_week` VALUES (164, '邯郸', 130400, 12.50, '1709568000000');
INSERT INTO `city_week` VALUES (165, '邯郸', 130400, 13.89, '1709654400000');
INSERT INTO `city_week` VALUES (166, '邯郸', 130400, 13.19, '1709740800000');
INSERT INTO `city_week` VALUES (167, '邯郸', 130400, 23.61, '1709827200000');
INSERT INTO `city_week` VALUES (168, '邯郸', 130400, 15.97, '1709913600000');
INSERT INTO `city_week` VALUES (169, '湛江', 440800, 7.64, '1709395200000');
INSERT INTO `city_week` VALUES (170, '湛江', 440800, 10.42, '1709481600000');
INSERT INTO `city_week` VALUES (171, '湛江', 440800, 4.86, '1709568000000');
INSERT INTO `city_week` VALUES (172, '湛江', 440800, 4.86, '1709654400000');
INSERT INTO `city_week` VALUES (173, '湛江', 440800, 6.25, '1709740800000');
INSERT INTO `city_week` VALUES (174, '湛江', 440800, 16.67, '1709827200000');
INSERT INTO `city_week` VALUES (175, '湛江', 440800, 13.19, '1709913600000');
INSERT INTO `city_week` VALUES (176, '保定', 130600, 39.58, '1709395200000');
INSERT INTO `city_week` VALUES (177, '保定', 130600, 36.81, '1709481600000');
INSERT INTO `city_week` VALUES (178, '保定', 130600, 36.11, '1709568000000');
INSERT INTO `city_week` VALUES (179, '保定', 130600, 35.42, '1709654400000');
INSERT INTO `city_week` VALUES (180, '保定', 130600, 36.11, '1709740800000');
INSERT INTO `city_week` VALUES (181, '保定', 130600, 47.92, '1709827200000');
INSERT INTO `city_week` VALUES (182, '保定', 130600, 45.14, '1709913600000');
INSERT INTO `city_week` VALUES (183, '佛山', 440600, 19.44, '1709395200000');
INSERT INTO `city_week` VALUES (184, '佛山', 440600, 22.92, '1709481600000');
INSERT INTO `city_week` VALUES (185, '佛山', 440600, 14.58, '1709568000000');
INSERT INTO `city_week` VALUES (186, '佛山', 440600, 15.28, '1709654400000');
INSERT INTO `city_week` VALUES (187, '佛山', 440600, 12.50, '1709740800000');
INSERT INTO `city_week` VALUES (188, '佛山', 440600, 24.31, '1709827200000');
INSERT INTO `city_week` VALUES (189, '佛山', 440600, 25.69, '1709913600000');
INSERT INTO `city_week` VALUES (190, '德阳', 510600, 15.28, '1709395200000');
INSERT INTO `city_week` VALUES (191, '德阳', 510600, 22.22, '1709481600000');
INSERT INTO `city_week` VALUES (192, '德阳', 510600, 20.83, '1709568000000');
INSERT INTO `city_week` VALUES (193, '德阳', 510600, 22.22, '1709654400000');
INSERT INTO `city_week` VALUES (194, '德阳', 510600, 19.44, '1709740800000');
INSERT INTO `city_week` VALUES (195, '德阳', 510600, 54.17, '1709827200000');
INSERT INTO `city_week` VALUES (196, '德阳', 510600, 36.81, '1709913600000');
INSERT INTO `city_week` VALUES (197, '东莞', 441900, 22.22, '1709395200000');
INSERT INTO `city_week` VALUES (198, '东莞', 441900, 20.83, '1709481600000');
INSERT INTO `city_week` VALUES (199, '东莞', 441900, 16.67, '1709568000000');
INSERT INTO `city_week` VALUES (200, '东莞', 441900, 15.97, '1709654400000');
INSERT INTO `city_week` VALUES (201, '东莞', 441900, 20.14, '1709740800000');
INSERT INTO `city_week` VALUES (202, '东莞', 441900, 27.78, '1709827200000');
INSERT INTO `city_week` VALUES (203, '东莞', 441900, 25.69, '1709913600000');
INSERT INTO `city_week` VALUES (204, '洛阳', 410300, 8.33, '1709395200000');
INSERT INTO `city_week` VALUES (205, '洛阳', 410300, 11.11, '1709481600000');
INSERT INTO `city_week` VALUES (206, '洛阳', 410300, 10.42, '1709568000000');
INSERT INTO `city_week` VALUES (207, '洛阳', 410300, 13.19, '1709654400000');
INSERT INTO `city_week` VALUES (208, '洛阳', 410300, 11.81, '1709740800000');
INSERT INTO `city_week` VALUES (209, '洛阳', 410300, 22.22, '1709827200000');
INSERT INTO `city_week` VALUES (210, '洛阳', 410300, 14.58, '1709913600000');
INSERT INTO `city_week` VALUES (211, '廊坊', 131000, 12.50, '1709395200000');
INSERT INTO `city_week` VALUES (212, '廊坊', 131000, 14.58, '1709481600000');
INSERT INTO `city_week` VALUES (213, '廊坊', 131000, 14.58, '1709568000000');
INSERT INTO `city_week` VALUES (214, '廊坊', 131000, 14.58, '1709654400000');
INSERT INTO `city_week` VALUES (215, '廊坊', 131000, 13.89, '1709740800000');
INSERT INTO `city_week` VALUES (216, '廊坊', 131000, 27.08, '1709827200000');
INSERT INTO `city_week` VALUES (217, '廊坊', 131000, 24.31, '1709913600000');
INSERT INTO `city_week` VALUES (218, '德州', 371400, 22.22, '1709395200000');
INSERT INTO `city_week` VALUES (219, '德州', 371400, 16.67, '1709481600000');
INSERT INTO `city_week` VALUES (220, '德州', 371400, 16.67, '1709568000000');
INSERT INTO `city_week` VALUES (221, '德州', 371400, 15.97, '1709654400000');
INSERT INTO `city_week` VALUES (222, '德州', 371400, 16.67, '1709740800000');
INSERT INTO `city_week` VALUES (223, '德州', 371400, 20.83, '1709827200000');
INSERT INTO `city_week` VALUES (224, '德州', 371400, 36.81, '1709913600000');
INSERT INTO `city_week` VALUES (225, '清远', 441800, 20.14, '1709395200000');
INSERT INTO `city_week` VALUES (226, '清远', 441800, 19.44, '1709481600000');
INSERT INTO `city_week` VALUES (227, '清远', 441800, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (228, '清远', 441800, 11.81, '1709654400000');
INSERT INTO `city_week` VALUES (229, '清远', 441800, 11.11, '1709740800000');
INSERT INTO `city_week` VALUES (230, '清远', 441800, 20.14, '1709827200000');
INSERT INTO `city_week` VALUES (231, '清远', 441800, 12.50, '1709913600000');
INSERT INTO `city_week` VALUES (232, '中山', 442000, 17.36, '1709395200000');
INSERT INTO `city_week` VALUES (233, '中山', 442000, 20.83, '1709481600000');
INSERT INTO `city_week` VALUES (234, '中山', 442000, 18.06, '1709568000000');
INSERT INTO `city_week` VALUES (235, '中山', 442000, 18.06, '1709654400000');
INSERT INTO `city_week` VALUES (236, '中山', 442000, 17.36, '1709740800000');
INSERT INTO `city_week` VALUES (237, '中山', 442000, 25.69, '1709827200000');
INSERT INTO `city_week` VALUES (238, '中山', 442000, 24.31, '1709913600000');
INSERT INTO `city_week` VALUES (239, '鄂尔多斯', 150600, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (240, '鄂尔多斯', 150600, 10.42, '1709481600000');
INSERT INTO `city_week` VALUES (241, '鄂尔多斯', 150600, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (242, '鄂尔多斯', 150600, 9.72, '1709654400000');
INSERT INTO `city_week` VALUES (243, '鄂尔多斯', 150600, 9.72, '1709740800000');
INSERT INTO `city_week` VALUES (244, '鄂尔多斯', 150600, 20.83, '1709827200000');
INSERT INTO `city_week` VALUES (245, '鄂尔多斯', 150600, 17.36, '1709913600000');
INSERT INTO `city_week` VALUES (246, '邢台', 130500, 18.75, '1709395200000');
INSERT INTO `city_week` VALUES (247, '邢台', 130500, 18.06, '1709481600000');
INSERT INTO `city_week` VALUES (248, '邢台', 130500, 15.28, '1709568000000');
INSERT INTO `city_week` VALUES (249, '邢台', 130500, 13.89, '1709654400000');
INSERT INTO `city_week` VALUES (250, '邢台', 130500, 15.28, '1709740800000');
INSERT INTO `city_week` VALUES (251, '邢台', 130500, 40.97, '1709827200000');
INSERT INTO `city_week` VALUES (252, '邢台', 130500, 34.03, '1709913600000');
INSERT INTO `city_week` VALUES (253, '昆明', 530100, 24.31, '1709395200000');
INSERT INTO `city_week` VALUES (254, '昆明', 530100, 23.61, '1709481600000');
INSERT INTO `city_week` VALUES (255, '昆明', 530100, 24.31, '1709568000000');
INSERT INTO `city_week` VALUES (256, '昆明', 530100, 25.00, '1709654400000');
INSERT INTO `city_week` VALUES (257, '昆明', 530100, 20.14, '1709740800000');
INSERT INTO `city_week` VALUES (258, '昆明', 530100, 44.44, '1709827200000');
INSERT INTO `city_week` VALUES (259, '昆明', 530100, 30.56, '1709913600000');
INSERT INTO `city_week` VALUES (260, '漳州', 350600, 13.19, '1709395200000');
INSERT INTO `city_week` VALUES (261, '漳州', 350600, 8.33, '1709481600000');
INSERT INTO `city_week` VALUES (262, '漳州', 350600, 6.94, '1709568000000');
INSERT INTO `city_week` VALUES (263, '漳州', 350600, 5.56, '1709654400000');
INSERT INTO `city_week` VALUES (264, '漳州', 350600, 6.94, '1709740800000');
INSERT INTO `city_week` VALUES (265, '漳州', 350600, 13.19, '1709827200000');
INSERT INTO `city_week` VALUES (266, '漳州', 350600, 15.28, '1709913600000');
INSERT INTO `city_week` VALUES (267, '西宁', 630100, 34.03, '1709395200000');
INSERT INTO `city_week` VALUES (268, '西宁', 630100, 22.92, '1709481600000');
INSERT INTO `city_week` VALUES (269, '西宁', 630100, 25.00, '1709568000000');
INSERT INTO `city_week` VALUES (270, '西宁', 630100, 21.53, '1709654400000');
INSERT INTO `city_week` VALUES (271, '西宁', 630100, 25.00, '1709740800000');
INSERT INTO `city_week` VALUES (272, '西宁', 630100, 43.06, '1709827200000');
INSERT INTO `city_week` VALUES (273, '西宁', 630100, 37.50, '1709913600000');
INSERT INTO `city_week` VALUES (274, '乌鲁木齐', 650100, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (275, '乌鲁木齐', 650100, 19.44, '1709481600000');
INSERT INTO `city_week` VALUES (276, '乌鲁木齐', 650100, 18.75, '1709568000000');
INSERT INTO `city_week` VALUES (277, '乌鲁木齐', 650100, 17.36, '1709654400000');
INSERT INTO `city_week` VALUES (278, '乌鲁木齐', 650100, 18.06, '1709740800000');
INSERT INTO `city_week` VALUES (279, '乌鲁木齐', 650100, 39.58, '1709827200000');
INSERT INTO `city_week` VALUES (280, '乌鲁木齐', 650100, 26.39, '1709913600000');
INSERT INTO `city_week` VALUES (281, '沧州', 130900, 45.83, '1709395200000');
INSERT INTO `city_week` VALUES (282, '沧州', 130900, 36.11, '1709481600000');
INSERT INTO `city_week` VALUES (283, '沧州', 130900, 40.97, '1709568000000');
INSERT INTO `city_week` VALUES (284, '沧州', 130900, 37.50, '1709654400000');
INSERT INTO `city_week` VALUES (285, '沧州', 130900, 34.03, '1709740800000');
INSERT INTO `city_week` VALUES (286, '沧州', 130900, 55.56, '1709827200000');
INSERT INTO `city_week` VALUES (287, '沧州', 130900, 50.69, '1709913600000');
INSERT INTO `city_week` VALUES (288, '呼和浩特', 150100, 11.81, '1709395200000');
INSERT INTO `city_week` VALUES (289, '呼和浩特', 150100, 15.28, '1709481600000');
INSERT INTO `city_week` VALUES (290, '呼和浩特', 150100, 15.28, '1709568000000');
INSERT INTO `city_week` VALUES (291, '呼和浩特', 150100, 14.58, '1709654400000');
INSERT INTO `city_week` VALUES (292, '呼和浩特', 150100, 14.58, '1709740800000');
INSERT INTO `city_week` VALUES (293, '呼和浩特', 150100, 22.22, '1709827200000');
INSERT INTO `city_week` VALUES (294, '呼和浩特', 150100, 11.11, '1709913600000');
INSERT INTO `city_week` VALUES (295, '福州', 350100, 13.19, '1709395200000');
INSERT INTO `city_week` VALUES (296, '福州', 350100, 16.67, '1709481600000');
INSERT INTO `city_week` VALUES (297, '福州', 350100, 18.06, '1709568000000');
INSERT INTO `city_week` VALUES (298, '福州', 350100, 19.44, '1709654400000');
INSERT INTO `city_week` VALUES (299, '福州', 350100, 16.67, '1709740800000');
INSERT INTO `city_week` VALUES (300, '福州', 350100, 22.92, '1709827200000');
INSERT INTO `city_week` VALUES (301, '福州', 350100, 14.58, '1709913600000');
INSERT INTO `city_week` VALUES (302, '温州', 330300, 18.75, '1709395200000');
INSERT INTO `city_week` VALUES (303, '温州', 330300, 16.67, '1709481600000');
INSERT INTO `city_week` VALUES (304, '温州', 330300, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (305, '温州', 330300, 12.50, '1709654400000');
INSERT INTO `city_week` VALUES (306, '温州', 330300, 13.19, '1709740800000');
INSERT INTO `city_week` VALUES (307, '温州', 330300, 22.22, '1709827200000');
INSERT INTO `city_week` VALUES (308, '温州', 330300, 16.67, '1709913600000');
INSERT INTO `city_week` VALUES (309, '汕头', 440500, 9.03, '1709395200000');
INSERT INTO `city_week` VALUES (310, '汕头', 440500, 10.42, '1709481600000');
INSERT INTO `city_week` VALUES (311, '汕头', 440500, 15.28, '1709568000000');
INSERT INTO `city_week` VALUES (312, '汕头', 440500, 16.67, '1709654400000');
INSERT INTO `city_week` VALUES (313, '汕头', 440500, 12.50, '1709740800000');
INSERT INTO `city_week` VALUES (314, '汕头', 440500, 18.75, '1709827200000');
INSERT INTO `city_week` VALUES (315, '汕头', 440500, 12.50, '1709913600000');
INSERT INTO `city_week` VALUES (316, '珠海', 440400, 11.81, '1709395200000');
INSERT INTO `city_week` VALUES (317, '珠海', 440400, 18.06, '1709481600000');
INSERT INTO `city_week` VALUES (318, '珠海', 440400, 17.36, '1709568000000');
INSERT INTO `city_week` VALUES (319, '珠海', 440400, 16.67, '1709654400000');
INSERT INTO `city_week` VALUES (320, '珠海', 440400, 14.58, '1709740800000');
INSERT INTO `city_week` VALUES (321, '珠海', 440400, 23.61, '1709827200000');
INSERT INTO `city_week` VALUES (322, '珠海', 440400, 17.36, '1709913600000');
INSERT INTO `city_week` VALUES (323, '赣州', 360700, 2.08, '1709395200000');
INSERT INTO `city_week` VALUES (324, '赣州', 360700, 8.33, '1709481600000');
INSERT INTO `city_week` VALUES (325, '赣州', 360700, 6.25, '1709568000000');
INSERT INTO `city_week` VALUES (326, '赣州', 360700, 6.94, '1709654400000');
INSERT INTO `city_week` VALUES (327, '赣州', 360700, 6.25, '1709740800000');
INSERT INTO `city_week` VALUES (328, '赣州', 360700, 12.50, '1709827200000');
INSERT INTO `city_week` VALUES (329, '赣州', 360700, 6.94, '1709913600000');
INSERT INTO `city_week` VALUES (330, '泉州', 350500, 9.72, '1709395200000');
INSERT INTO `city_week` VALUES (331, '泉州', 350500, 6.94, '1709481600000');
INSERT INTO `city_week` VALUES (332, '泉州', 350500, 4.17, '1709568000000');
INSERT INTO `city_week` VALUES (333, '泉州', 350500, 4.17, '1709654400000');
INSERT INTO `city_week` VALUES (334, '泉州', 350500, 4.17, '1709740800000');
INSERT INTO `city_week` VALUES (335, '泉州', 350500, 7.64, '1709827200000');
INSERT INTO `city_week` VALUES (336, '泉州', 350500, 8.33, '1709913600000');
INSERT INTO `city_week` VALUES (337, '宿迁', 321300, 4.86, '1709395200000');
INSERT INTO `city_week` VALUES (338, '宿迁', 321300, 11.11, '1709481600000');
INSERT INTO `city_week` VALUES (339, '宿迁', 321300, 11.81, '1709568000000');
INSERT INTO `city_week` VALUES (340, '宿迁', 321300, 10.42, '1709654400000');
INSERT INTO `city_week` VALUES (341, '宿迁', 321300, 9.03, '1709740800000');
INSERT INTO `city_week` VALUES (342, '宿迁', 321300, 11.11, '1709827200000');
INSERT INTO `city_week` VALUES (343, '宿迁', 321300, 5.56, '1709913600000');
INSERT INTO `city_week` VALUES (344, '贵阳', 520100, 2.78, '1709395200000');
INSERT INTO `city_week` VALUES (345, '贵阳', 520100, 15.28, '1709481600000');
INSERT INTO `city_week` VALUES (346, '贵阳', 520100, 11.81, '1709568000000');
INSERT INTO `city_week` VALUES (347, '贵阳', 520100, 11.11, '1709654400000');
INSERT INTO `city_week` VALUES (348, '贵阳', 520100, 9.72, '1709740800000');
INSERT INTO `city_week` VALUES (349, '贵阳', 520100, 23.61, '1709827200000');
INSERT INTO `city_week` VALUES (350, '贵阳', 520100, 15.28, '1709913600000');
INSERT INTO `city_week` VALUES (351, '泰安', 370900, 10.42, '1709395200000');
INSERT INTO `city_week` VALUES (352, '泰安', 370900, 13.19, '1709481600000');
INSERT INTO `city_week` VALUES (353, '泰安', 370900, 11.81, '1709568000000');
INSERT INTO `city_week` VALUES (354, '泰安', 370900, 11.81, '1709654400000');
INSERT INTO `city_week` VALUES (355, '泰安', 370900, 12.50, '1709740800000');
INSERT INTO `city_week` VALUES (356, '泰安', 370900, 18.75, '1709827200000');
INSERT INTO `city_week` VALUES (357, '泰安', 370900, 18.06, '1709913600000');
INSERT INTO `city_week` VALUES (358, '张家口', 130700, 5.56, '1709395200000');
INSERT INTO `city_week` VALUES (359, '张家口', 130700, 16.67, '1709481600000');
INSERT INTO `city_week` VALUES (360, '张家口', 130700, 13.89, '1709568000000');
INSERT INTO `city_week` VALUES (361, '张家口', 130700, 13.89, '1709654400000');
INSERT INTO `city_week` VALUES (362, '张家口', 130700, 13.19, '1709740800000');
INSERT INTO `city_week` VALUES (363, '张家口', 130700, 21.53, '1709827200000');
INSERT INTO `city_week` VALUES (364, '张家口', 130700, 14.58, '1709913600000');
INSERT INTO `city_week` VALUES (365, '潍坊', 370700, 9.03, '1709395200000');
INSERT INTO `city_week` VALUES (366, '潍坊', 370700, 13.19, '1709481600000');
INSERT INTO `city_week` VALUES (367, '潍坊', 370700, 14.58, '1709568000000');
INSERT INTO `city_week` VALUES (368, '潍坊', 370700, 13.89, '1709654400000');
INSERT INTO `city_week` VALUES (369, '潍坊', 370700, 15.97, '1709740800000');
INSERT INTO `city_week` VALUES (370, '潍坊', 370700, 17.36, '1709827200000');
INSERT INTO `city_week` VALUES (371, '潍坊', 370700, 9.03, '1709913600000');
INSERT INTO `city_week` VALUES (372, '武汉', 420100, 21.53, '1709395200000');
INSERT INTO `city_week` VALUES (373, '武汉', 420100, 22.92, '1709481600000');
INSERT INTO `city_week` VALUES (374, '武汉', 420100, 16.67, '1709568000000');
INSERT INTO `city_week` VALUES (375, '武汉', 420100, 14.58, '1709654400000');
INSERT INTO `city_week` VALUES (376, '武汉', 420100, 17.36, '1709740800000');
INSERT INTO `city_week` VALUES (377, '武汉', 420100, 34.72, '1709827200000');
INSERT INTO `city_week` VALUES (378, '武汉', 420100, 27.78, '1709913600000');
INSERT INTO `city_week` VALUES (379, '绵阳', 510700, 15.97, '1709395200000');
INSERT INTO `city_week` VALUES (380, '绵阳', 510700, 14.58, '1709481600000');
INSERT INTO `city_week` VALUES (381, '绵阳', 510700, 13.89, '1709568000000');
INSERT INTO `city_week` VALUES (382, '绵阳', 510700, 13.19, '1709654400000');
INSERT INTO `city_week` VALUES (383, '绵阳', 510700, 13.89, '1709740800000');
INSERT INTO `city_week` VALUES (384, '绵阳', 510700, 20.83, '1709827200000');
INSERT INTO `city_week` VALUES (385, '绵阳', 510700, 13.19, '1709913600000');
INSERT INTO `city_week` VALUES (386, '香港', 810000, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (387, '香港', 810000, 33.33, '1709481600000');
INSERT INTO `city_week` VALUES (388, '香港', 810000, 33.33, '1709568000000');
INSERT INTO `city_week` VALUES (389, '香港', 810000, 36.81, '1709654400000');
INSERT INTO `city_week` VALUES (390, '香港', 810000, 33.33, '1709740800000');
INSERT INTO `city_week` VALUES (391, '香港', 810000, 50.69, '1709827200000');
INSERT INTO `city_week` VALUES (392, '香港', 810000, 37.50, '1709913600000');
INSERT INTO `city_week` VALUES (393, '重庆', 500000, 22.22, '1709395200000');
INSERT INTO `city_week` VALUES (394, '重庆', 500000, 17.36, '1709481600000');
INSERT INTO `city_week` VALUES (395, '重庆', 500000, 18.06, '1709568000000');
INSERT INTO `city_week` VALUES (396, '重庆', 500000, 18.06, '1709654400000');
INSERT INTO `city_week` VALUES (397, '重庆', 500000, 20.14, '1709740800000');
INSERT INTO `city_week` VALUES (398, '重庆', 500000, 38.89, '1709827200000');
INSERT INTO `city_week` VALUES (399, '重庆', 500000, 23.61, '1709913600000');
INSERT INTO `city_week` VALUES (400, '唐山', 130200, 9.72, '1709395200000');
INSERT INTO `city_week` VALUES (401, '唐山', 130200, 15.97, '1709481600000');
INSERT INTO `city_week` VALUES (402, '唐山', 130200, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (403, '唐山', 130200, 14.58, '1709654400000');
INSERT INTO `city_week` VALUES (404, '唐山', 130200, 13.89, '1709740800000');
INSERT INTO `city_week` VALUES (405, '唐山', 130200, 18.06, '1709827200000');
INSERT INTO `city_week` VALUES (406, '唐山', 130200, 12.50, '1709913600000');
INSERT INTO `city_week` VALUES (407, '南京', 320100, 20.14, '1709395200000');
INSERT INTO `city_week` VALUES (408, '南京', 320100, 26.39, '1709481600000');
INSERT INTO `city_week` VALUES (409, '南京', 320100, 21.53, '1709568000000');
INSERT INTO `city_week` VALUES (410, '南京', 320100, 19.44, '1709654400000');
INSERT INTO `city_week` VALUES (411, '南京', 320100, 19.44, '1709740800000');
INSERT INTO `city_week` VALUES (412, '南京', 320100, 34.72, '1709827200000');
INSERT INTO `city_week` VALUES (413, '南京', 320100, 29.86, '1709913600000');
INSERT INTO `city_week` VALUES (414, '韶关', 440200, 5.56, '1709395200000');
INSERT INTO `city_week` VALUES (415, '韶关', 440200, 12.50, '1709481600000');
INSERT INTO `city_week` VALUES (416, '韶关', 440200, 7.64, '1709568000000');
INSERT INTO `city_week` VALUES (417, '韶关', 440200, 6.94, '1709654400000');
INSERT INTO `city_week` VALUES (418, '韶关', 440200, 6.94, '1709740800000');
INSERT INTO `city_week` VALUES (419, '韶关', 440200, 11.81, '1709827200000');
INSERT INTO `city_week` VALUES (420, '韶关', 440200, 6.25, '1709913600000');
INSERT INTO `city_week` VALUES (421, '上海', 310000, 13.89, '1709395200000');
INSERT INTO `city_week` VALUES (422, '上海', 310000, 27.08, '1709481600000');
INSERT INTO `city_week` VALUES (423, '上海', 310000, 28.47, '1709568000000');
INSERT INTO `city_week` VALUES (424, '上海', 310000, 24.31, '1709654400000');
INSERT INTO `city_week` VALUES (425, '上海', 310000, 25.69, '1709740800000');
INSERT INTO `city_week` VALUES (426, '上海', 310000, 38.89, '1709827200000');
INSERT INTO `city_week` VALUES (427, '上海', 310000, 22.92, '1709913600000');
INSERT INTO `city_week` VALUES (428, '杭州', 330100, 21.53, '1709395200000');
INSERT INTO `city_week` VALUES (429, '杭州', 330100, 17.36, '1709481600000');
INSERT INTO `city_week` VALUES (430, '杭州', 330100, 20.14, '1709568000000');
INSERT INTO `city_week` VALUES (431, '杭州', 330100, 13.89, '1709654400000');
INSERT INTO `city_week` VALUES (432, '杭州', 330100, 15.28, '1709740800000');
INSERT INTO `city_week` VALUES (433, '杭州', 330100, 31.94, '1709827200000');
INSERT INTO `city_week` VALUES (434, '杭州', 330100, 22.22, '1709913600000');
INSERT INTO `city_week` VALUES (435, '石家庄', 130100, 12.50, '1709395200000');
INSERT INTO `city_week` VALUES (436, '石家庄', 130100, 17.36, '1709481600000');
INSERT INTO `city_week` VALUES (437, '石家庄', 130100, 18.75, '1709568000000');
INSERT INTO `city_week` VALUES (438, '石家庄', 130100, 14.58, '1709654400000');
INSERT INTO `city_week` VALUES (439, '石家庄', 130100, 13.89, '1709740800000');
INSERT INTO `city_week` VALUES (440, '石家庄', 130100, 22.22, '1709827200000');
INSERT INTO `city_week` VALUES (441, '石家庄', 130100, 13.19, '1709913600000');
INSERT INTO `city_week` VALUES (442, '嘉兴', 330400, 6.94, '1709395200000');
INSERT INTO `city_week` VALUES (443, '嘉兴', 330400, 16.67, '1709481600000');
INSERT INTO `city_week` VALUES (444, '嘉兴', 330400, 18.06, '1709568000000');
INSERT INTO `city_week` VALUES (445, '嘉兴', 330400, 16.67, '1709654400000');
INSERT INTO `city_week` VALUES (446, '嘉兴', 330400, 15.97, '1709740800000');
INSERT INTO `city_week` VALUES (447, '嘉兴', 330400, 21.53, '1709827200000');
INSERT INTO `city_week` VALUES (448, '嘉兴', 330400, 9.72, '1709913600000');
INSERT INTO `city_week` VALUES (449, '临沂', 371300, 8.33, '1709395200000');
INSERT INTO `city_week` VALUES (450, '临沂', 371300, 11.11, '1709481600000');
INSERT INTO `city_week` VALUES (451, '临沂', 371300, 12.50, '1709568000000');
INSERT INTO `city_week` VALUES (452, '临沂', 371300, 10.42, '1709654400000');
INSERT INTO `city_week` VALUES (453, '临沂', 371300, 9.72, '1709740800000');
INSERT INTO `city_week` VALUES (454, '临沂', 371300, 19.44, '1709827200000');
INSERT INTO `city_week` VALUES (455, '临沂', 371300, 8.33, '1709913600000');
INSERT INTO `city_week` VALUES (456, '烟台', 370600, 4.17, '1709395200000');
INSERT INTO `city_week` VALUES (457, '烟台', 370600, 13.89, '1709481600000');
INSERT INTO `city_week` VALUES (458, '烟台', 370600, 12.50, '1709568000000');
INSERT INTO `city_week` VALUES (459, '烟台', 370600, 13.19, '1709654400000');
INSERT INTO `city_week` VALUES (460, '烟台', 370600, 12.50, '1709740800000');
INSERT INTO `city_week` VALUES (461, '烟台', 370600, 19.44, '1709827200000');
INSERT INTO `city_week` VALUES (462, '烟台', 370600, 11.11, '1709913600000');
INSERT INTO `city_week` VALUES (463, '北京', 110000, 20.14, '1709395200000');
INSERT INTO `city_week` VALUES (464, '北京', 110000, 28.47, '1709481600000');
INSERT INTO `city_week` VALUES (465, '北京', 110000, 28.47, '1709568000000');
INSERT INTO `city_week` VALUES (466, '北京', 110000, 27.08, '1709654400000');
INSERT INTO `city_week` VALUES (467, '北京', 110000, 33.33, '1709740800000');
INSERT INTO `city_week` VALUES (468, '北京', 110000, 47.22, '1709827200000');
INSERT INTO `city_week` VALUES (469, '北京', 110000, 34.72, '1709913600000');
INSERT INTO `city_week` VALUES (470, '肇庆', 441200, 9.72, '1709395200000');
INSERT INTO `city_week` VALUES (471, '肇庆', 441200, 9.72, '1709481600000');
INSERT INTO `city_week` VALUES (472, '肇庆', 441200, 10.42, '1709568000000');
INSERT INTO `city_week` VALUES (473, '肇庆', 441200, 8.33, '1709654400000');
INSERT INTO `city_week` VALUES (474, '肇庆', 441200, 6.94, '1709740800000');
INSERT INTO `city_week` VALUES (475, '肇庆', 441200, 13.19, '1709827200000');
INSERT INTO `city_week` VALUES (476, '肇庆', 441200, 7.64, '1709913600000');
INSERT INTO `city_week` VALUES (477, '合肥', 340100, 5.56, '1709395200000');
INSERT INTO `city_week` VALUES (478, '合肥', 340100, 14.58, '1709481600000');
INSERT INTO `city_week` VALUES (479, '合肥', 340100, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (480, '合肥', 340100, 11.81, '1709654400000');
INSERT INTO `city_week` VALUES (481, '合肥', 340100, 11.11, '1709740800000');
INSERT INTO `city_week` VALUES (482, '合肥', 340100, 17.36, '1709827200000');
INSERT INTO `city_week` VALUES (483, '合肥', 340100, 6.94, '1709913600000');
INSERT INTO `city_week` VALUES (484, '南昌', 360100, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (485, '南昌', 360100, 13.19, '1709481600000');
INSERT INTO `city_week` VALUES (486, '南昌', 360100, 15.97, '1709568000000');
INSERT INTO `city_week` VALUES (487, '南昌', 360100, 11.11, '1709654400000');
INSERT INTO `city_week` VALUES (488, '南昌', 360100, 10.42, '1709740800000');
INSERT INTO `city_week` VALUES (489, '南昌', 360100, 13.89, '1709827200000');
INSERT INTO `city_week` VALUES (490, '南昌', 360100, 4.86, '1709913600000');
INSERT INTO `city_week` VALUES (491, '江门', 440700, 3.47, '1709395200000');
INSERT INTO `city_week` VALUES (492, '江门', 440700, 15.28, '1709481600000');
INSERT INTO `city_week` VALUES (493, '江门', 440700, 9.03, '1709568000000');
INSERT INTO `city_week` VALUES (494, '江门', 440700, 9.03, '1709654400000');
INSERT INTO `city_week` VALUES (495, '江门', 440700, 8.33, '1709740800000');
INSERT INTO `city_week` VALUES (496, '江门', 440700, 11.81, '1709827200000');
INSERT INTO `city_week` VALUES (497, '江门', 440700, 6.94, '1709913600000');
INSERT INTO `city_week` VALUES (498, '衡阳', 430400, 0.69, '1709395200000');
INSERT INTO `city_week` VALUES (499, '衡阳', 430400, 5.56, '1709481600000');
INSERT INTO `city_week` VALUES (500, '衡阳', 430400, 6.25, '1709568000000');
INSERT INTO `city_week` VALUES (501, '衡阳', 430400, 3.47, '1709654400000');
INSERT INTO `city_week` VALUES (502, '衡阳', 430400, 3.47, '1709740800000');
INSERT INTO `city_week` VALUES (503, '衡阳', 430400, 10.42, '1709827200000');
INSERT INTO `city_week` VALUES (504, '衡阳', 430400, 0.69, '1709913600000');
INSERT INTO `city_week` VALUES (505, '衢州', 330800, 2.78, '1709395200000');
INSERT INTO `city_week` VALUES (506, '衢州', 330800, 10.42, '1709481600000');
INSERT INTO `city_week` VALUES (507, '衢州', 330800, 13.19, '1709568000000');
INSERT INTO `city_week` VALUES (508, '衢州', 330800, 9.72, '1709654400000');
INSERT INTO `city_week` VALUES (509, '衢州', 330800, 9.03, '1709740800000');
INSERT INTO `city_week` VALUES (510, '衢州', 330800, 11.81, '1709827200000');
INSERT INTO `city_week` VALUES (511, '衢州', 330800, 3.47, '1709913600000');
INSERT INTO `city_week` VALUES (512, '盐城', 320900, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (513, '盐城', 320900, 10.42, '1709481600000');
INSERT INTO `city_week` VALUES (514, '盐城', 320900, 9.03, '1709568000000');
INSERT INTO `city_week` VALUES (515, '盐城', 320900, 4.17, '1709654400000');
INSERT INTO `city_week` VALUES (516, '盐城', 320900, 4.17, '1709740800000');
INSERT INTO `city_week` VALUES (517, '盐城', 320900, 6.94, '1709827200000');
INSERT INTO `city_week` VALUES (518, '盐城', 320900, 4.17, '1709913600000');
INSERT INTO `city_week` VALUES (519, '青岛', 370200, 6.94, '1709395200000');
INSERT INTO `city_week` VALUES (520, '青岛', 370200, 15.97, '1709481600000');
INSERT INTO `city_week` VALUES (521, '青岛', 370200, 14.58, '1709568000000');
INSERT INTO `city_week` VALUES (522, '青岛', 370200, 15.97, '1709654400000');
INSERT INTO `city_week` VALUES (523, '青岛', 370200, 18.75, '1709740800000');
INSERT INTO `city_week` VALUES (524, '青岛', 370200, 22.92, '1709827200000');
INSERT INTO `city_week` VALUES (525, '青岛', 370200, 12.50, '1709913600000');
INSERT INTO `city_week` VALUES (526, '滁州', 341100, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (527, '滁州', 341100, 9.03, '1709481600000');
INSERT INTO `city_week` VALUES (528, '滁州', 341100, 8.33, '1709568000000');
INSERT INTO `city_week` VALUES (529, '滁州', 341100, 5.56, '1709654400000');
INSERT INTO `city_week` VALUES (530, '滁州', 341100, 4.86, '1709740800000');
INSERT INTO `city_week` VALUES (531, '滁州', 341100, 7.64, '1709827200000');
INSERT INTO `city_week` VALUES (532, '滁州', 341100, 1.39, '1709913600000');
INSERT INTO `city_week` VALUES (533, '镇江', 321100, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (534, '镇江', 321100, 11.81, '1709481600000');
INSERT INTO `city_week` VALUES (535, '镇江', 321100, 13.89, '1709568000000');
INSERT INTO `city_week` VALUES (536, '镇江', 321100, 8.33, '1709654400000');
INSERT INTO `city_week` VALUES (537, '镇江', 321100, 8.33, '1709740800000');
INSERT INTO `city_week` VALUES (538, '镇江', 321100, 9.72, '1709827200000');
INSERT INTO `city_week` VALUES (539, '镇江', 321100, 0.00, '1709913600000');
INSERT INTO `city_week` VALUES (540, '宁波', 330200, 2.08, '1709395200000');
INSERT INTO `city_week` VALUES (541, '宁波', 330200, 15.28, '1709481600000');
INSERT INTO `city_week` VALUES (542, '宁波', 330200, 17.36, '1709568000000');
INSERT INTO `city_week` VALUES (543, '宁波', 330200, 15.28, '1709654400000');
INSERT INTO `city_week` VALUES (544, '宁波', 330200, 13.89, '1709740800000');
INSERT INTO `city_week` VALUES (545, '宁波', 330200, 19.44, '1709827200000');
INSERT INTO `city_week` VALUES (546, '宁波', 330200, 4.17, '1709913600000');
INSERT INTO `city_week` VALUES (547, '沈阳', 210100, 6.25, '1709395200000');
INSERT INTO `city_week` VALUES (548, '沈阳', 210100, 21.53, '1709481600000');
INSERT INTO `city_week` VALUES (549, '沈阳', 210100, 17.36, '1709568000000');
INSERT INTO `city_week` VALUES (550, '沈阳', 210100, 17.36, '1709654400000');
INSERT INTO `city_week` VALUES (551, '沈阳', 210100, 17.36, '1709740800000');
INSERT INTO `city_week` VALUES (552, '沈阳', 210100, 31.25, '1709827200000');
INSERT INTO `city_week` VALUES (553, '沈阳', 210100, 11.81, '1709913600000');
INSERT INTO `city_week` VALUES (554, '长春', 220100, 0.69, '1709395200000');
INSERT INTO `city_week` VALUES (555, '长春', 220100, 21.53, '1709481600000');
INSERT INTO `city_week` VALUES (556, '长春', 220100, 18.75, '1709568000000');
INSERT INTO `city_week` VALUES (557, '长春', 220100, 18.75, '1709654400000');
INSERT INTO `city_week` VALUES (558, '长春', 220100, 18.75, '1709740800000');
INSERT INTO `city_week` VALUES (559, '长春', 220100, 34.72, '1709827200000');
INSERT INTO `city_week` VALUES (560, '长春', 220100, 11.11, '1709913600000');
INSERT INTO `city_week` VALUES (561, '大连', 210200, 4.17, '1709395200000');
INSERT INTO `city_week` VALUES (562, '大连', 210200, 20.83, '1709481600000');
INSERT INTO `city_week` VALUES (563, '大连', 210200, 18.75, '1709568000000');
INSERT INTO `city_week` VALUES (564, '大连', 210200, 16.67, '1709654400000');
INSERT INTO `city_week` VALUES (565, '大连', 210200, 16.67, '1709740800000');
INSERT INTO `city_week` VALUES (566, '大连', 210200, 25.00, '1709827200000');
INSERT INTO `city_week` VALUES (567, '大连', 210200, 22.22, '1709913600000');
INSERT INTO `city_week` VALUES (568, '哈尔滨', 230100, 1.39, '1709395200000');
INSERT INTO `city_week` VALUES (569, '哈尔滨', 230100, 18.06, '1709481600000');
INSERT INTO `city_week` VALUES (570, '哈尔滨', 230100, 15.97, '1709568000000');
INSERT INTO `city_week` VALUES (571, '哈尔滨', 230100, 15.97, '1709654400000');
INSERT INTO `city_week` VALUES (572, '哈尔滨', 230100, 15.28, '1709740800000');
INSERT INTO `city_week` VALUES (573, '哈尔滨', 230100, 25.69, '1709827200000');
INSERT INTO `city_week` VALUES (574, '哈尔滨', 230100, 18.06, '1709913600000');
INSERT INTO `city_week` VALUES (575, '扬州', 321000, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (576, '扬州', 321000, 14.58, '1709481600000');
INSERT INTO `city_week` VALUES (577, '扬州', 321000, 11.81, '1709568000000');
INSERT INTO `city_week` VALUES (578, '扬州', 321000, 9.72, '1709654400000');
INSERT INTO `city_week` VALUES (579, '扬州', 321000, 6.94, '1709740800000');
INSERT INTO `city_week` VALUES (580, '扬州', 321000, 13.89, '1709827200000');
INSERT INTO `city_week` VALUES (581, '扬州', 321000, 4.86, '1709913600000');
INSERT INTO `city_week` VALUES (582, '济宁', 370800, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (583, '济宁', 370800, 5.56, '1709481600000');
INSERT INTO `city_week` VALUES (584, '济宁', 370800, 2.78, '1709568000000');
INSERT INTO `city_week` VALUES (585, '济宁', 370800, 3.47, '1709654400000');
INSERT INTO `city_week` VALUES (586, '济宁', 370800, 2.78, '1709740800000');
INSERT INTO `city_week` VALUES (587, '济宁', 370800, 8.33, '1709827200000');
INSERT INTO `city_week` VALUES (588, '济宁', 370800, 2.78, '1709913600000');
INSERT INTO `city_week` VALUES (589, '厦门', 350200, 5.56, '1709395200000');
INSERT INTO `city_week` VALUES (590, '厦门', 350200, 13.19, '1709481600000');
INSERT INTO `city_week` VALUES (591, '厦门', 350200, 11.81, '1709568000000');
INSERT INTO `city_week` VALUES (592, '厦门', 350200, 15.28, '1709654400000');
INSERT INTO `city_week` VALUES (593, '厦门', 350200, 12.50, '1709740800000');
INSERT INTO `city_week` VALUES (594, '厦门', 350200, 20.14, '1709827200000');
INSERT INTO `city_week` VALUES (595, '厦门', 350200, 6.25, '1709913600000');
INSERT INTO `city_week` VALUES (596, '常州', 320400, 0.69, '1709395200000');
INSERT INTO `city_week` VALUES (597, '常州', 320400, 16.67, '1709481600000');
INSERT INTO `city_week` VALUES (598, '常州', 320400, 15.97, '1709568000000');
INSERT INTO `city_week` VALUES (599, '常州', 320400, 12.50, '1709654400000');
INSERT INTO `city_week` VALUES (600, '常州', 320400, 12.50, '1709740800000');
INSERT INTO `city_week` VALUES (601, '常州', 320400, 13.89, '1709827200000');
INSERT INTO `city_week` VALUES (602, '常州', 320400, 4.86, '1709913600000');
INSERT INTO `city_week` VALUES (603, '连云港', 320700, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (604, '连云港', 320700, 4.17, '1709481600000');
INSERT INTO `city_week` VALUES (605, '连云港', 320700, 6.94, '1709568000000');
INSERT INTO `city_week` VALUES (606, '连云港', 320700, 4.17, '1709654400000');
INSERT INTO `city_week` VALUES (607, '连云港', 320700, 3.47, '1709740800000');
INSERT INTO `city_week` VALUES (608, '连云港', 320700, 11.11, '1709827200000');
INSERT INTO `city_week` VALUES (609, '连云港', 320700, 0.69, '1709913600000');
INSERT INTO `city_week` VALUES (610, '苏州', 320500, 5.56, '1709395200000');
INSERT INTO `city_week` VALUES (611, '苏州', 320500, 18.06, '1709481600000');
INSERT INTO `city_week` VALUES (612, '苏州', 320500, 15.97, '1709568000000');
INSERT INTO `city_week` VALUES (613, '苏州', 320500, 13.19, '1709654400000');
INSERT INTO `city_week` VALUES (614, '苏州', 320500, 13.89, '1709740800000');
INSERT INTO `city_week` VALUES (615, '苏州', 320500, 19.44, '1709827200000');
INSERT INTO `city_week` VALUES (616, '苏州', 320500, 6.94, '1709913600000');
INSERT INTO `city_week` VALUES (617, '台州', 331000, 4.17, '1709395200000');
INSERT INTO `city_week` VALUES (618, '台州', 331000, 14.58, '1709481600000');
INSERT INTO `city_week` VALUES (619, '台州', 331000, 12.50, '1709568000000');
INSERT INTO `city_week` VALUES (620, '台州', 331000, 9.72, '1709654400000');
INSERT INTO `city_week` VALUES (621, '台州', 331000, 9.72, '1709740800000');
INSERT INTO `city_week` VALUES (622, '台州', 331000, 13.89, '1709827200000');
INSERT INTO `city_week` VALUES (623, '台州', 331000, 4.17, '1709913600000');
INSERT INTO `city_week` VALUES (624, '天津', 120000, 1.39, '1709395200000');
INSERT INTO `city_week` VALUES (625, '天津', 120000, 15.97, '1709481600000');
INSERT INTO `city_week` VALUES (626, '天津', 120000, 14.58, '1709568000000');
INSERT INTO `city_week` VALUES (627, '天津', 120000, 15.97, '1709654400000');
INSERT INTO `city_week` VALUES (628, '天津', 120000, 15.97, '1709740800000');
INSERT INTO `city_week` VALUES (629, '天津', 120000, 20.83, '1709827200000');
INSERT INTO `city_week` VALUES (630, '天津', 120000, 11.81, '1709913600000');
INSERT INTO `city_week` VALUES (631, '淄博', 370300, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (632, '淄博', 370300, 7.64, '1709481600000');
INSERT INTO `city_week` VALUES (633, '淄博', 370300, 7.64, '1709568000000');
INSERT INTO `city_week` VALUES (634, '淄博', 370300, 5.56, '1709654400000');
INSERT INTO `city_week` VALUES (635, '淄博', 370300, 4.86, '1709740800000');
INSERT INTO `city_week` VALUES (636, '淄博', 370300, 9.03, '1709827200000');
INSERT INTO `city_week` VALUES (637, '淄博', 370300, 2.78, '1709913600000');
INSERT INTO `city_week` VALUES (638, '芜湖', 340200, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (639, '芜湖', 340200, 9.03, '1709481600000');
INSERT INTO `city_week` VALUES (640, '芜湖', 340200, 9.72, '1709568000000');
INSERT INTO `city_week` VALUES (641, '芜湖', 340200, 4.86, '1709654400000');
INSERT INTO `city_week` VALUES (642, '芜湖', 340200, 4.86, '1709740800000');
INSERT INTO `city_week` VALUES (643, '芜湖', 340200, 10.42, '1709827200000');
INSERT INTO `city_week` VALUES (644, '芜湖', 340200, 0.00, '1709913600000');
INSERT INTO `city_week` VALUES (645, '绍兴', 330600, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (646, '绍兴', 330600, 9.72, '1709481600000');
INSERT INTO `city_week` VALUES (647, '绍兴', 330600, 10.42, '1709568000000');
INSERT INTO `city_week` VALUES (648, '绍兴', 330600, 6.94, '1709654400000');
INSERT INTO `city_week` VALUES (649, '绍兴', 330600, 6.94, '1709740800000');
INSERT INTO `city_week` VALUES (650, '绍兴', 330600, 8.33, '1709827200000');
INSERT INTO `city_week` VALUES (651, '绍兴', 330600, 2.78, '1709913600000');
INSERT INTO `city_week` VALUES (652, '徐州', 320300, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (653, '徐州', 320300, 7.64, '1709481600000');
INSERT INTO `city_week` VALUES (654, '徐州', 320300, 11.11, '1709568000000');
INSERT INTO `city_week` VALUES (655, '徐州', 320300, 3.47, '1709654400000');
INSERT INTO `city_week` VALUES (656, '徐州', 320300, 1.39, '1709740800000');
INSERT INTO `city_week` VALUES (657, '徐州', 320300, 10.42, '1709827200000');
INSERT INTO `city_week` VALUES (658, '徐州', 320300, 1.39, '1709913600000');
INSERT INTO `city_week` VALUES (659, '湖州', 330500, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (660, '湖州', 330500, 10.42, '1709481600000');
INSERT INTO `city_week` VALUES (661, '湖州', 330500, 10.42, '1709568000000');
INSERT INTO `city_week` VALUES (662, '湖州', 330500, 6.94, '1709654400000');
INSERT INTO `city_week` VALUES (663, '湖州', 330500, 7.64, '1709740800000');
INSERT INTO `city_week` VALUES (664, '湖州', 330500, 9.03, '1709827200000');
INSERT INTO `city_week` VALUES (665, '湖州', 330500, 0.00, '1709913600000');
INSERT INTO `city_week` VALUES (666, '淮安', 320800, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (667, '淮安', 320800, 2.08, '1709481600000');
INSERT INTO `city_week` VALUES (668, '淮安', 320800, 2.78, '1709568000000');
INSERT INTO `city_week` VALUES (669, '淮安', 320800, 3.47, '1709654400000');
INSERT INTO `city_week` VALUES (670, '淮安', 320800, 2.78, '1709740800000');
INSERT INTO `city_week` VALUES (671, '淮安', 320800, 4.86, '1709827200000');
INSERT INTO `city_week` VALUES (672, '淮安', 320800, 0.00, '1709913600000');
INSERT INTO `city_week` VALUES (673, '泰州', 321200, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (674, '泰州', 321200, 5.56, '1709481600000');
INSERT INTO `city_week` VALUES (675, '泰州', 321200, 6.25, '1709568000000');
INSERT INTO `city_week` VALUES (676, '泰州', 321200, 0.69, '1709654400000');
INSERT INTO `city_week` VALUES (677, '泰州', 321200, 0.69, '1709740800000');
INSERT INTO `city_week` VALUES (678, '泰州', 321200, 3.47, '1709827200000');
INSERT INTO `city_week` VALUES (679, '泰州', 321200, 0.00, '1709913600000');
INSERT INTO `city_week` VALUES (680, '金华', 330700, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (681, '金华', 330700, 6.25, '1709481600000');
INSERT INTO `city_week` VALUES (682, '金华', 330700, 6.25, '1709568000000');
INSERT INTO `city_week` VALUES (683, '金华', 330700, 6.25, '1709654400000');
INSERT INTO `city_week` VALUES (684, '金华', 330700, 4.17, '1709740800000');
INSERT INTO `city_week` VALUES (685, '金华', 330700, 8.33, '1709827200000');
INSERT INTO `city_week` VALUES (686, '金华', 330700, 0.69, '1709913600000');
INSERT INTO `city_week` VALUES (687, '无锡', 320200, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (688, '无锡', 320200, 14.58, '1709481600000');
INSERT INTO `city_week` VALUES (689, '无锡', 320200, 13.89, '1709568000000');
INSERT INTO `city_week` VALUES (690, '无锡', 320200, 11.81, '1709654400000');
INSERT INTO `city_week` VALUES (691, '无锡', 320200, 11.81, '1709740800000');
INSERT INTO `city_week` VALUES (692, '无锡', 320200, 15.97, '1709827200000');
INSERT INTO `city_week` VALUES (693, '无锡', 320200, 2.78, '1709913600000');
INSERT INTO `city_week` VALUES (694, '南通', 320600, 0.00, '1709395200000');
INSERT INTO `city_week` VALUES (695, '南通', 320600, 9.72, '1709481600000');
INSERT INTO `city_week` VALUES (696, '南通', 320600, 11.11, '1709568000000');
INSERT INTO `city_week` VALUES (697, '南通', 320600, 4.17, '1709654400000');
INSERT INTO `city_week` VALUES (698, '南通', 320600, 3.47, '1709740800000');
INSERT INTO `city_week` VALUES (699, '南通', 320600, 6.94, '1709827200000');
INSERT INTO `city_week` VALUES (700, '南通', 320600, 2.08, '1709913600000');
-- ----------------------------
-- Table structure for countryindicators
-- ----------------------------
DROP TABLE IF EXISTS `countryindicators`;
CREATE TABLE `countryindicators` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`avg` double(30, 20) NOT NULL,
`indicator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`maxValue` double(30, 20) NOT NULL,
`numGTAvg` int(10) NOT NULL,
`topCityName` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of countryindicators
-- ----------------------------
INSERT INTO `countryindicators` VALUES (7, 0.16305555555555550000, '路网高延时运行时间占比', 0.43551587301587297000, 38, '兰州', '2025-03-06 02:56:26');
INSERT INTO `countryindicators` VALUES (8, 0.00328791394306026200, '路网拥堵路段里程比', 0.02137774011157267400, 35, '广州', '2025-03-06 02:56:26');
INSERT INTO `countryindicators` VALUES (9, 0.00160364857142857100, '常发拥堵路段里程比', 0.00822728571428571500, 36, '广州', '2025-03-06 02:56:26');
INSERT INTO `countryindicators` VALUES (10, 1.36462392999999940000, '路网行程延时指数', 1.59347900000000000000, 45, '北京', '2025-03-06 02:56:26');
INSERT INTO `countryindicators` VALUES (11, 0.08403407730030920000, '道路运行速度偏差率', 0.19676366604342174000, 45, '上海', '2025-03-06 02:56:26');
INSERT INTO `countryindicators` VALUES (12, 33.30323057000000400000, '平均速度(km/h)', 26.48561100000000000000, 48, '伊犁', '2025-03-06 02:56:26');
-- ----------------------------
-- Table structure for jam
-- ----------------------------
DROP TABLE IF EXISTS `jam`;
CREATE TABLE `jam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`freeFlowSpeed` double(10, 2) NULL DEFAULT NULL COMMENT '畅通速度',
`realSpeed` double(10, 2) NULL DEFAULT NULL COMMENT '平均速度',
`idxRatio` int(2) NULL DEFAULT NULL,
`idxRatioState` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`idx` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '拥堵延时指数',
`label` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`name` int(20) NULL DEFAULT NULL,
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of jam
-- ----------------------------
INSERT INTO `jam` VALUES (1, 38.54, 29.64, 1, 'up', '1.3', '伊犁州', 654000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (2, 39.76, 31.52, 2, 'up', '1.26', '新乡市', 410700, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (3, 42.41, 33.83, -1, 'down', '1.25', '香港', 810000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (4, 42.03, 33.56, 1, 'up', '1.25', '银川市', 640100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (5, 43.71, 35.10, -1, 'down', '1.25', '广州市', 440100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (6, 39.05, 31.37, 0, 'flat', '1.24', '海口市', 460100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (7, 42.13, 33.87, 2, 'up', '1.24', '德阳市', 510600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (8, 40.94, 32.97, 0, 'flat', '1.24', '昆明市', 530100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (9, 48.22, 38.90, 1, 'up', '1.24', '宿迁市', 321300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (10, 44.39, 35.90, 2, 'up', '1.24', '西安市', 610100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (11, 39.43, 32.03, 1, 'up', '1.23', '桂林市', 450300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (12, 44.39, 36.14, 0, 'flat', '1.23', '泰安市', 370900, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (13, 41.23, 33.61, 1, 'up', '1.23', '汕头市', 440500, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (14, 40.39, 32.95, 1, 'up', '1.23', '柳州市', 450200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (15, 43.31, 35.37, -1, 'down', '1.22', '深圳市', 440300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (16, 43.53, 35.57, -1, 'down', '1.22', '南充市', 511300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (17, 43.58, 35.79, 0, 'flat', '1.22', '漳州市', 350600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (18, 45.31, 37.22, 0, 'flat', '1.22', '乌鲁木齐市', 650100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (19, 43.36, 35.65, 0, 'flat', '1.22', '茂名市', 440900, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (20, 43.71, 35.99, 0, 'flat', '1.21', '南宁市', 450100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (21, 46.25, 38.11, 2, 'up', '1.21', '朔州市', 140600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (22, 42.57, 35.08, 0, 'flat', '1.21', '三亚市', 460200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (23, 43.13, 35.62, -1, 'down', '1.21', '清远市', 441800, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (24, 39.04, 32.39, 1, 'up', '1.21', '南阳市', 411300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (25, 43.83, 36.41, 0, 'flat', '1.2', '兰州市', 620100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (26, 46.01, 38.22, 1, 'up', '1.2', '西宁市', 630100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (27, 45.30, 37.77, 1, 'up', '1.2', '成都市', 510100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (28, 48.75, 40.72, -6, 'down', '1.2', '镇江市', 321100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (29, 41.98, 35.09, 0, 'flat', '1.2', '长沙市', 430100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (30, 45.42, 38.00, -1, 'down', '1.2', '湛江市', 440800, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (31, 49.62, 41.51, -7, 'down', '1.2', '鄂尔多斯市', 150600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (32, 44.37, 37.17, 1, 'up', '1.19', '嘉兴市', 330400, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (33, 49.21, 41.32, 1, 'up', '1.19', '郑州市', 410100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (34, 45.28, 38.02, 1, 'up', '1.19', '湖州市', 330500, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (35, 42.65, 35.82, -2, 'down', '1.19', '滁州市', 341100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (36, 48.97, 41.22, 0, 'flat', '1.19', '福州市', 350100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (37, 47.40, 39.90, -1, 'down', '1.19', '潍坊市', 370700, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (38, 50.69, 42.72, 0, 'flat', '1.19', '太原市', 140100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (39, 45.13, 38.05, 2, 'up', '1.19', '洛阳市', 410300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (40, 48.16, 40.61, 2, 'up', '1.19', '肇庆市', 441200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (41, 42.38, 35.83, 0, 'flat', '1.18', '上海市', 310000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (42, 46.16, 39.04, 1, 'up', '1.18', '北京市', 110000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (43, 41.78, 35.37, -2, 'down', '1.18', '德州市', 371400, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (44, 46.40, 39.33, 1, 'up', '1.18', '济南市', 370100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (45, 51.91, 44.02, 0, 'flat', '1.18', '珠海市', 440400, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (46, 41.74, 35.41, 1, 'up', '1.18', '温州市', 330300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (47, 43.70, 37.12, -1, 'down', '1.18', '赣州市', 360700, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (48, 48.82, 41.49, -2, 'down', '1.18', '扬州市', 321000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (49, 43.80, 37.26, 0, 'flat', '1.18', '廊坊市', 131000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (50, 44.17, 37.58, -1, 'down', '1.18', '韶关市', 440200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (51, 44.73, 38.08, 1, 'up', '1.17', '大同市', 140200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (52, 48.89, 41.63, 1, 'up', '1.17', '淄博市', 370300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (53, 52.46, 44.67, 2, 'up', '1.17', '济宁市', 370800, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (54, 42.78, 36.46, 0, 'flat', '1.17', '衢州市', 330800, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (55, 42.90, 36.64, 2, 'up', '1.17', '咸阳市', 610400, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (56, 45.04, 38.48, 1, 'up', '1.17', '杭州市', 330100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (57, 47.07, 40.24, -1, 'down', '1.17', '南京市', 320100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (58, 49.37, 42.20, 0, 'flat', '1.17', '绵阳市', 510700, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (59, 46.90, 40.13, 2, 'up', '1.17', '绍兴市', 330600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (60, 47.59, 40.72, 0, 'flat', '1.17', '唐山市', 130200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (61, 47.41, 40.59, -1, 'down', '1.17', '常州市', 320400, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (62, 46.07, 39.48, -2, 'down', '1.17', '东莞市', 441900, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (63, 42.86, 36.73, 1, 'up', '1.17', '保定市', 130600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (64, 48.25, 41.36, 0, 'flat', '1.17', '淮安市', 320800, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (65, 45.30, 38.85, -1, 'down', '1.17', '宁波市', 330200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (66, 45.70, 39.25, 2, 'up', '1.16', '邢台市', 130500, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (67, 49.51, 42.55, 1, 'up', '1.16', '重庆市', 500000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (68, 44.54, 38.30, 0, 'flat', '1.16', '芜湖市', 340200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (69, 45.34, 39.03, -2, 'down', '1.16', '惠州市', 441300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (70, 44.42, 38.25, -3, 'down', '1.16', '连云港市', 320700, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (71, 47.04, 40.61, 0, 'flat', '1.16', '佛山市', 440600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (72, 48.11, 41.54, 1, 'up', '1.16', '贵阳市', 520100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (73, 49.42, 42.68, 2, 'up', '1.16', '武汉市', 420100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (74, 52.41, 45.27, -5, 'down', '1.16', '泰州市', 321200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (75, 51.16, 44.22, 0, 'flat', '1.16', '盐城市', 320900, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (76, 47.51, 41.08, -1, 'down', '1.16', '中山市', 442000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (77, 42.55, 36.84, -1, 'down', '1.15', '邯郸市', 130400, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (78, 43.64, 37.81, 0, 'flat', '1.15', '衡阳市', 430400, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (79, 49.91, 43.30, -1, 'down', '1.15', '厦门市', 350200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (80, 48.55, 42.19, 0, 'flat', '1.15', '合肥市', 340100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (81, 43.28, 37.66, -2, 'down', '1.15', '沧州市', 130900, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (82, 47.16, 41.20, 0, 'flat', '1.14', '南昌市', 360100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (83, 47.35, 41.48, -2, 'down', '1.14', '青岛市', 370200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (84, 48.20, 42.24, 0, 'flat', '1.14', '呼和浩特市', 150100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (85, 45.57, 39.96, -1, 'down', '1.14', '烟台市', 370600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (86, 47.29, 41.49, -1, 'down', '1.14', '台州市', 331000, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (87, 49.65, 43.64, -1, 'down', '1.14', '江门市', 440700, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (88, 52.83, 46.46, 0, 'flat', '1.14', '南通市', 320600, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (89, 49.31, 43.39, 0, 'flat', '1.14', '徐州市', 320300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (90, 46.40, 40.88, -1, 'down', '1.14', '无锡市', 320200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (91, 48.33, 42.60, -1, 'down', '1.13', '泉州市', 350500, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (92, 47.16, 41.64, 1, 'up', '1.13', '大连市', 210200, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (93, 50.41, 44.67, -3, 'down', '1.13', '临沂市', 371300, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (94, 50.63, 44.92, 0, 'flat', '1.13', '石家庄市', 130100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (95, 50.29, 44.63, 0, 'flat', '1.13', '苏州市', 320500, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (96, 47.24, 41.98, -1, 'down', '1.13', '张家口市', 130700, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (97, 46.22, 41.27, -1, 'down', '1.12', '长春市', 220100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (98, 43.31, 38.68, 0, 'flat', '1.12', '沈阳市', 210100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (99, 43.58, 39.00, 1, 'up', '1.12', '哈尔滨市', 230100, '2025-03-11 15:15:00');
INSERT INTO `jam` VALUES (100, 42.55, 38.13, 0, 'flat', '1.12', '金华市', 330700, '2025-03-11 15:15:00');
-- ----------------------------
-- Table structure for prediction
-- ----------------------------
DROP TABLE IF EXISTS `prediction`;
CREATE TABLE `prediction` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idx` double(10, 2) NOT NULL,
`create_time` date NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 181 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of prediction
-- ----------------------------
INSERT INTO `prediction` VALUES (1, 3.58, '2025-01-29');
INSERT INTO `prediction` VALUES (2, 3.05, '2025-01-29');
INSERT INTO `prediction` VALUES (3, 1.96, '2025-01-29');
INSERT INTO `prediction` VALUES (4, 0.98, '2025-01-30');
INSERT INTO `prediction` VALUES (5, 2.85, '2025-01-30');
INSERT INTO `prediction` VALUES (6, 3.88, '2025-01-30');
INSERT INTO `prediction` VALUES (7, 3.81, '2025-01-31');
INSERT INTO `prediction` VALUES (8, 1.33, '2025-01-31');
INSERT INTO `prediction` VALUES (9, 2.17, '2025-01-31');
INSERT INTO `prediction` VALUES (10, 2.43, '2025-02-01');
INSERT INTO `prediction` VALUES (11, 3.43, '2025-02-01');
INSERT INTO `prediction` VALUES (12, 1.78, '2025-02-01');
INSERT INTO `prediction` VALUES (13, 3.18, '2025-02-02');
INSERT INTO `prediction` VALUES (14, 2.90, '2025-02-02');
INSERT INTO `prediction` VALUES (15, 3.27, '2025-02-02');
INSERT INTO `prediction` VALUES (16, 3.89, '2025-02-03');
INSERT INTO `prediction` VALUES (17, 1.22, '2025-02-03');
INSERT INTO `prediction` VALUES (18, 3.60, '2025-02-03');
INSERT INTO `prediction` VALUES (19, 3.66, '2025-02-04');
INSERT INTO `prediction` VALUES (20, 1.28, '2025-02-04');
INSERT INTO `prediction` VALUES (21, 1.11, '2025-02-04');
INSERT INTO `prediction` VALUES (22, 2.09, '2025-02-05');
INSERT INTO `prediction` VALUES (23, 2.05, '2025-02-05');
INSERT INTO `prediction` VALUES (24, 3.29, '2025-02-05');
INSERT INTO `prediction` VALUES (25, 3.86, '2025-02-06');
INSERT INTO `prediction` VALUES (26, 2.99, '2025-02-06');
INSERT INTO `prediction` VALUES (27, 2.07, '2025-02-06');
INSERT INTO `prediction` VALUES (28, 1.17, '2025-02-07');
INSERT INTO `prediction` VALUES (29, 2.25, '2025-02-07');
INSERT INTO `prediction` VALUES (30, 3.94, '2025-02-07');
INSERT INTO `prediction` VALUES (31, 2.27, '2025-02-08');
INSERT INTO `prediction` VALUES (32, 3.74, '2025-02-08');
INSERT INTO `prediction` VALUES (33, 1.94, '2025-02-08');
INSERT INTO `prediction` VALUES (34, 3.55, '2025-02-09');
INSERT INTO `prediction` VALUES (35, 2.15, '2025-02-09');
INSERT INTO `prediction` VALUES (36, 3.15, '2025-02-09');
INSERT INTO `prediction` VALUES (37, 0.95, '2025-02-10');
INSERT INTO `prediction` VALUES (38, 1.75, '2025-02-10');
INSERT INTO `prediction` VALUES (39, 3.15, '2025-02-10');
INSERT INTO `prediction` VALUES (40, 3.25, '2025-02-11');
INSERT INTO `prediction` VALUES (41, 0.82, '2025-02-11');
INSERT INTO `prediction` VALUES (42, 2.22, '2025-02-11');
INSERT INTO `prediction` VALUES (43, 1.61, '2025-02-12');
INSERT INTO `prediction` VALUES (44, 2.51, '2025-02-12');
INSERT INTO `prediction` VALUES (45, 2.81, '2025-02-12');
INSERT INTO `prediction` VALUES (46, 3.67, '2025-02-13');
INSERT INTO `prediction` VALUES (47, 3.24, '2025-02-13');
INSERT INTO `prediction` VALUES (48, 1.69, '2025-02-13');
INSERT INTO `prediction` VALUES (49, 3.14, '2025-02-14');
INSERT INTO `prediction` VALUES (50, 1.15, '2025-02-14');
INSERT INTO `prediction` VALUES (51, 2.54, '2025-02-14');
INSERT INTO `prediction` VALUES (52, 2.96, '2025-02-15');
INSERT INTO `prediction` VALUES (53, 1.67, '2025-02-15');
INSERT INTO `prediction` VALUES (54, 3.37, '2025-02-15');
INSERT INTO `prediction` VALUES (55, 1.82, '2025-02-16');
INSERT INTO `prediction` VALUES (56, 1.35, '2025-02-16');
INSERT INTO `prediction` VALUES (57, 1.41, '2025-02-16');
INSERT INTO `prediction` VALUES (58, 1.17, '2025-02-17');
INSERT INTO `prediction` VALUES (59, 3.53, '2025-02-17');
INSERT INTO `prediction` VALUES (60, 1.33, '2025-02-17');
INSERT INTO `prediction` VALUES (61, 2.98, '2025-02-18');
INSERT INTO `prediction` VALUES (62, 3.68, '2025-02-18');
INSERT INTO `prediction` VALUES (63, 1.10, '2025-02-18');
INSERT INTO `prediction` VALUES (64, 1.31, '2025-02-19');
INSERT INTO `prediction` VALUES (65, 1.20, '2025-02-19');
INSERT INTO `prediction` VALUES (66, 0.88, '2025-02-19');
INSERT INTO `prediction` VALUES (67, 1.48, '2025-02-20');
INSERT INTO `prediction` VALUES (68, 2.99, '2025-02-20');
INSERT INTO `prediction` VALUES (69, 2.04, '2025-02-20');
INSERT INTO `prediction` VALUES (70, 0.57, '2025-02-21');
INSERT INTO `prediction` VALUES (71, 1.01, '2025-02-21');
INSERT INTO `prediction` VALUES (72, 3.88, '2025-02-21');
INSERT INTO `prediction` VALUES (73, 1.27, '2025-02-22');
INSERT INTO `prediction` VALUES (74, 0.82, '2025-02-22');
INSERT INTO `prediction` VALUES (75, 2.03, '2025-02-22');
INSERT INTO `prediction` VALUES (76, 3.82, '2025-02-23');
INSERT INTO `prediction` VALUES (77, 2.00, '2025-02-23');
INSERT INTO `prediction` VALUES (78, 3.77, '2025-02-23');
INSERT INTO `prediction` VALUES (79, 3.98, '2025-02-24');
INSERT INTO `prediction` VALUES (80, 2.07, '2025-02-24');
INSERT INTO `prediction` VALUES (81, 2.99, '2025-02-24');
INSERT INTO `prediction` VALUES (82, 3.85, '2025-02-25');
INSERT INTO `prediction` VALUES (83, 1.04, '2025-02-25');
INSERT INTO `prediction` VALUES (84, 3.21, '2025-02-25');
INSERT INTO `prediction` VALUES (85, 0.64, '2025-02-26');
INSERT INTO `prediction` VALUES (86, 1.73, '2025-02-26');
INSERT INTO `prediction` VALUES (87, 2.59, '2025-02-26');
INSERT INTO `prediction` VALUES (88, 0.74, '2025-02-27');
INSERT INTO `prediction` VALUES (89, 3.98, '2025-02-27');
INSERT INTO `prediction` VALUES (90, 2.33, '2025-02-27');
INSERT INTO `prediction` VALUES (91, 3.84, '2025-02-28');
INSERT INTO `prediction` VALUES (92, 0.89, '2025-02-28');
INSERT INTO `prediction` VALUES (93, 3.10, '2025-02-28');
INSERT INTO `prediction` VALUES (94, 2.01, '2025-03-01');
INSERT INTO `prediction` VALUES (95, 1.32, '2025-03-01');
INSERT INTO `prediction` VALUES (96, 1.46, '2025-03-01');
INSERT INTO `prediction` VALUES (97, 1.21, '2025-03-02');
INSERT INTO `prediction` VALUES (98, 0.83, '2025-03-02');
INSERT INTO `prediction` VALUES (99, 3.36, '2025-03-02');
INSERT INTO `prediction` VALUES (100, 2.90, '2025-03-03');
INSERT INTO `prediction` VALUES (101, 1.26, '2025-03-03');
INSERT INTO `prediction` VALUES (102, 3.99, '2025-03-03');
INSERT INTO `prediction` VALUES (103, 2.88, '2025-03-04');
INSERT INTO `prediction` VALUES (104, 3.28, '2025-03-04');
INSERT INTO `prediction` VALUES (105, 1.57, '2025-03-04');
INSERT INTO `prediction` VALUES (106, 0.92, '2025-03-05');
INSERT INTO `prediction` VALUES (107, 3.59, '2025-03-05');
INSERT INTO `prediction` VALUES (108, 2.37, '2025-03-05');
INSERT INTO `prediction` VALUES (109, 3.00, '2025-03-06');
INSERT INTO `prediction` VALUES (110, 2.67, '2025-03-06');
INSERT INTO `prediction` VALUES (111, 2.65, '2025-03-06');
INSERT INTO `prediction` VALUES (112, 3.61, '2025-03-07');
INSERT INTO `prediction` VALUES (113, 2.63, '2025-03-07');
INSERT INTO `prediction` VALUES (114, 2.16, '2025-03-07');
INSERT INTO `prediction` VALUES (115, 2.27, '2025-03-08');
INSERT INTO `prediction` VALUES (116, 1.63, '2025-03-08');
INSERT INTO `prediction` VALUES (117, 1.59, '2025-03-08');
INSERT INTO `prediction` VALUES (118, 3.80, '2025-03-09');
INSERT INTO `prediction` VALUES (119, 3.23, '2025-03-09');
INSERT INTO `prediction` VALUES (120, 0.99, '2025-03-09');
INSERT INTO `prediction` VALUES (121, 3.13, '2025-03-10');
INSERT INTO `prediction` VALUES (122, 0.60, '2025-03-10');
INSERT INTO `prediction` VALUES (123, 1.56, '2025-03-10');
INSERT INTO `prediction` VALUES (124, 0.61, '2025-03-11');
INSERT INTO `prediction` VALUES (125, 2.45, '2025-03-11');
INSERT INTO `prediction` VALUES (126, 0.79, '2025-03-11');
INSERT INTO `prediction` VALUES (127, 3.20, '2025-03-12');
INSERT INTO `prediction` VALUES (128, 3.95, '2025-03-12');
INSERT INTO `prediction` VALUES (129, 2.44, '2025-03-12');
INSERT INTO `prediction` VALUES (130, 3.72, '2025-03-13');
INSERT INTO `prediction` VALUES (131, 1.52, '2025-03-13');
INSERT INTO `prediction` VALUES (132, 2.69, '2025-03-13');
INSERT INTO `prediction` VALUES (133, 1.83, '2025-03-14');
INSERT INTO `prediction` VALUES (134, 3.41, '2025-03-14');
INSERT INTO `prediction` VALUES (135, 3.64, '2025-03-14');
INSERT INTO `prediction` VALUES (136, 2.97, '2025-03-15');
INSERT INTO `prediction` VALUES (137, 1.33, '2025-03-15');
INSERT INTO `prediction` VALUES (138, 1.15, '2025-03-15');
INSERT INTO `prediction` VALUES (139, 1.92, '2025-03-16');
INSERT INTO `prediction` VALUES (140, 1.45, '2025-03-16');
INSERT INTO `prediction` VALUES (141, 2.43, '2025-03-16');
INSERT INTO `prediction` VALUES (142, 3.64, '2025-03-17');
INSERT INTO `prediction` VALUES (143, 1.07, '2025-03-17');
INSERT INTO `prediction` VALUES (144, 1.71, '2025-03-17');
INSERT INTO `prediction` VALUES (145, 3.39, '2025-03-18');
INSERT INTO `prediction` VALUES (146, 1.78, '2025-03-18');
INSERT INTO `prediction` VALUES (147, 0.92, '2025-03-18');
INSERT INTO `prediction` VALUES (148, 3.75, '2025-03-19');
INSERT INTO `prediction` VALUES (149, 3.39, '2025-03-19');
INSERT INTO `prediction` VALUES (150, 3.49, '2025-03-19');
INSERT INTO `prediction` VALUES (151, 3.13, '2025-03-20');
INSERT INTO `prediction` VALUES (152, 1.18, '2025-03-20');
INSERT INTO `prediction` VALUES (153, 2.16, '2025-03-20');
INSERT INTO `prediction` VALUES (154, 2.57, '2025-03-21');
INSERT INTO `prediction` VALUES (155, 3.46, '2025-03-21');
INSERT INTO `prediction` VALUES (156, 2.42, '2025-03-21');
INSERT INTO `prediction` VALUES (157, 3.54, '2025-03-22');
INSERT INTO `prediction` VALUES (158, 0.68, '2025-03-22');
INSERT INTO `prediction` VALUES (159, 3.55, '2025-03-22');
INSERT INTO `prediction` VALUES (160, 1.89, '2025-03-23');
INSERT INTO `prediction` VALUES (161, 3.42, '2025-03-23');
INSERT INTO `prediction` VALUES (162, 1.45, '2025-03-23');
INSERT INTO `prediction` VALUES (163, 1.51, '2025-03-24');
INSERT INTO `prediction` VALUES (164, 2.98, '2025-03-24');
INSERT INTO `prediction` VALUES (165, 0.62, '2025-03-24');
INSERT INTO `prediction` VALUES (166, 1.93, '2025-03-25');
INSERT INTO `prediction` VALUES (167, 0.86, '2025-03-25');
INSERT INTO `prediction` VALUES (168, 2.34, '2025-03-25');
INSERT INTO `prediction` VALUES (169, 0.70, '2025-03-26');
INSERT INTO `prediction` VALUES (170, 3.93, '2025-03-26');
INSERT INTO `prediction` VALUES (171, 1.02, '2025-03-26');
INSERT INTO `prediction` VALUES (172, 3.19, '2025-03-27');
INSERT INTO `prediction` VALUES (173, 2.44, '2025-03-27');
INSERT INTO `prediction` VALUES (174, 1.38, '2025-03-27');
INSERT INTO `prediction` VALUES (175, 3.60, '2025-03-28');
INSERT INTO `prediction` VALUES (176, 3.96, '2025-03-28');
INSERT INTO `prediction` VALUES (177, 1.16, '2025-03-28');
INSERT INTO `prediction` VALUES (178, 3.40, '2025-03-29');
INSERT INTO `prediction` VALUES (179, 1.31, '2025-03-29');
INSERT INTO `prediction` VALUES (180, 2.33, '2025-03-29');
-- ----------------------------
-- Table structure for rank
-- ----------------------------
DROP TABLE IF EXISTS `rank`;
CREATE TABLE `rank` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`rank` int(11) NOT NULL,
`adcode` int(11) NOT NULL,
`cityName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`idx` double(10, 4) NOT NULL,
`freeFlowSpeed` double(10, 4) NOT NULL,
`realSpeed` double(10, 4) NOT NULL,
`idx1` double(10, 4) NOT NULL,
`ratio1w` double(10, 1) NOT NULL,
`healthValue` double(10, 4) NOT NULL,
`healState` int(11) NOT NULL,
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 607 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of rank
-- ----------------------------
INSERT INTO `rank` VALUES (506, 32, 370800, '济宁市', 1.2748, 51.6343, 40.5049, 1.2743, -1.0, 0.7798, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (507, 23, 370300, '淄博市', 1.2818, 48.0174, 37.4610, 1.2771, 0.0, 0.7690, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (508, 33, 321200, '泰州市', 1.2461, 51.3492, 41.2092, 1.2453, -2.0, 0.7657, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (509, 28, 320800, '淮安市', 1.2597, 47.5162, 37.7192, 1.2540, -1.0, 0.7624, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (510, 24, 150600, '鄂尔多斯市', 1.3240, 48.9122, 36.9427, 1.3298, -1.0, 0.7621, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (511, 27, 350500, '泉州市', 1.2692, 47.8807, 37.7263, 1.2868, 1.0, 0.7619, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (512, 26, 320900, '盐城市', 1.2929, 50.0246, 38.6905, 1.2912, -5.0, 0.7613, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (513, 33, 320700, '连云港市', 1.2724, 44.0848, 34.6468, 1.2682, 1.0, 0.7536, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (514, 29, 330700, '金华市', 1.2510, 42.1520, 33.6957, 1.2553, 1.0, 0.7533, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (515, 28, 441200, '肇庆市', 1.2894, 47.9423, 37.1814, 1.2898, 1.0, 0.7509, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (516, 18, 370700, '潍坊市', 1.3522, 46.7207, 34.5512, 1.3527, -3.0, 0.7476, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (517, 19, 321300, '宿迁市', 1.3537, 47.0925, 34.7876, 1.3617, -1.0, 0.7469, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (518, 22, 341100, '滁州市', 1.3403, 42.2647, 31.5342, 1.3228, 2.0, 0.7456, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (519, 21, 350600, '漳州市', 1.3474, 43.2702, 32.1137, 1.3571, 0.0, 0.7456, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (520, 17, 410300, '洛阳市', 1.3595, 44.4594, 32.7030, 1.3648, -1.0, 0.7442, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (521, 15, 360700, '赣州市', 1.3311, 43.1582, 32.4236, 1.3398, -1.0, 0.7431, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (522, 30, 430400, '衡阳市', 1.2829, 43.2648, 33.7247, 1.2895, -4.0, 0.7428, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (523, 10, 370900, '泰安市', 1.3628, 43.9478, 32.2472, 1.3611, -3.0, 0.7423, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (524, 16, 440800, '湛江市', 1.3309, 44.9639, 33.7849, 1.3280, 1.0, 0.7417, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (525, 27, 441300, '惠州市', 1.3009, 45.0665, 34.6431, 1.3027, 2.0, 0.7415, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (526, 8, 140200, '大同市', 1.3826, 44.1154, 31.9077, 1.3918, -2.0, 0.7412, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (527, 26, 330600, '绍兴市', 1.3039, 46.2073, 35.4365, 1.3082, 1.0, 0.7412, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (528, 32, 330500, '湖州市', 1.2580, 44.9219, 35.7101, 1.2591, -1.0, 0.7370, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (529, 17, 331000, '台州市', 1.3268, 46.6192, 35.1376, 1.3302, -2.0, 0.7355, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (530, 34, 320600, '南通市', 1.2428, 51.7962, 41.6777, 1.2459, -3.0, 0.7348, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (531, 23, 330800, '衢州市', 1.3106, 42.5852, 32.4932, 1.3130, -1.0, 0.7344, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (532, 27, 320300, '徐州市', 1.2927, 48.7293, 37.6945, 1.2963, -5.0, 0.7339, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (533, 12, 370600, '烟台市', 1.3399, 45.0193, 33.5992, 1.3386, 0.0, 0.7318, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (534, 20, 321100, '镇江市', 1.3137, 47.9285, 36.4829, 1.3124, -3.0, 0.7292, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (535, 31, 321000, '扬州市', 1.2804, 48.0474, 37.5249, 1.2871, -3.0, 0.7281, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (536, 10, 130500, '邢台市', 1.4286, 45.1456, 31.6017, 1.4333, -2.0, 0.7280, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (537, 30, 340200, '芜湖市', 1.2862, 44.0031, 34.2124, 1.2944, 1.0, 0.7279, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (538, 15, 130200, '唐山市', 1.3885, 46.8025, 33.7067, 1.3886, 1.0, 0.7278, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (539, 13, 440900, '茂名市', 1.3692, 43.1604, 31.5226, 1.3702, 0.0, 0.7269, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (540, 15, 130700, '张家口市', 1.3672, 46.9290, 34.3238, 1.3716, -2.0, 0.7258, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (541, 11, 440500, '汕头市', 1.3425, 41.0225, 30.5566, 1.3518, 0.0, 0.7252, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (542, 9, 411300, '南阳市', 1.4288, 38.7145, 27.0953, 1.4437, -3.0, 0.7252, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (543, 28, 440700, '江门市', 1.2932, 49.2543, 38.0873, 1.2941, 0.0, 0.7249, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (544, 19, 371300, '临沂市', 1.3496, 49.6469, 36.7872, 1.3514, -1.0, 0.7213, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (545, 22, 440200, '韶关市', 1.2850, 43.8110, 34.0947, 1.2851, 0.0, 0.7175, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (546, 31, 340100, '合肥市', 1.2724, 48.0692, 37.7784, 1.2802, -3.0, 0.7149, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (547, 3, 511300, '南充市', 1.4691, 43.1007, 29.3378, 1.4703, -2.0, 0.7119, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (548, 5, 330300, '温州市', 1.3565, 41.2940, 30.4421, 1.3642, -3.0, 0.7079, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (549, 10, 131000, '廊坊市', 1.3730, 43.4788, 31.6670, 1.3847, 0.0, 0.7078, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (550, 18, 350200, '厦门市', 1.3265, 49.4650, 37.2893, 1.3355, 5.0, 0.7076, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (551, 20, 610400, '咸阳市', 1.3495, 42.7319, 31.6642, 1.3493, 1.0, 0.7067, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (552, 13, 371400, '德州市', 1.4038, 41.2300, 29.3710, 1.4016, -1.0, 0.7063, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (553, 14, 450100, '南宁市', 1.3352, 43.4135, 32.5140, 1.3375, -2.0, 0.7056, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (554, 6, 410700, '新乡市', 1.4480, 39.4370, 27.2358, 1.4605, -5.0, 0.7044, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (555, 23, 440400, '珠海市', 1.3281, 51.5413, 38.8097, 1.3310, 2.0, 0.7042, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (556, 29, 330200, '宁波市', 1.2870, 44.8646, 34.8592, 1.3094, -3.0, 0.7023, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (557, 20, 370200, '青岛市', 1.3518, 46.6358, 34.4980, 1.3670, -1.0, 0.6996, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (558, 6, 330400, '嘉兴市', 1.4077, 43.8385, 31.1418, 1.4072, 5.0, 0.6968, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (559, 16, 450300, '桂林市', 1.3876, 39.0626, 28.1518, 1.3965, -3.0, 0.6966, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (560, 6, 640100, '银川市', 1.4218, 41.8409, 29.4285, 1.4251, -1.0, 0.6963, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (561, 9, 130400, '邯郸市', 1.3761, 42.1585, 30.6355, 1.3836, -4.0, 0.6938, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (562, 12, 460200, '三亚市', 1.4084, 42.2410, 29.9932, 1.4065, -4.0, 0.6934, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (563, 14, 350100, '福州市', 1.3887, 48.4599, 34.8955, 1.3984, 2.0, 0.6932, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (564, 29, 320400, '常州市', 1.2911, 46.7918, 36.2405, 1.2936, -2.0, 0.6928, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (565, 12, 450200, '柳州市', 1.3700, 40.2128, 29.3524, 1.3673, 0.0, 0.6882, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (566, 5, 654000, '伊犁州', 1.4533, 38.4907, 26.4856, 1.4662, 5.0, 0.6875, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (567, 4, 510600, '德阳市', 1.4681, 41.8277, 28.4909, 1.4897, -1.0, 0.6857, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (568, 25, 441800, '清远市', 1.2963, 43.0467, 33.2067, 1.2970, -1.0, 0.6817, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (569, 4, 630100, '西宁市', 1.4613, 45.6052, 31.2087, 1.4666, 2.0, 0.6796, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (570, 26, 360100, '南昌市', 1.2715, 46.6662, 36.7030, 1.2718, -2.0, 0.6796, 1, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (571, 11, 441900, '东莞市', 1.4169, 45.7314, 32.2762, 1.4393, 2.0, 0.6740, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (572, 25, 320200, '无锡市', 1.2753, 46.0127, 36.0812, 1.2814, -2.0, 0.6720, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (573, 5, 442000, '中山市', 1.4236, 47.0195, 33.0283, 1.4346, 7.0, 0.6711, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (574, 11, 210200, '大连市', 1.3721, 46.3361, 33.7712, 1.3721, 0.0, 0.6710, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (575, 19, 330100, '杭州市', 1.3249, 44.7698, 33.7918, 1.3382, -6.0, 0.6703, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (576, 21, 150100, '呼和浩特市', 1.3089, 47.8513, 36.5598, 1.3152, -3.0, 0.6702, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (577, 9, 510700, '绵阳市', 1.3749, 48.4983, 35.2747, 1.3829, -2.0, 0.6698, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (578, 24, 320500, '苏州市', 1.2763, 49.7822, 39.0049, 1.2822, -1.0, 0.6677, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (579, 7, 410100, '郑州市', 1.4472, 48.6901, 33.6443, 1.4626, -1.0, 0.6653, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (580, 21, 140100, '太原市', 1.3501, 50.2423, 37.2151, 1.3556, 0.0, 0.6604, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (581, 25, 120000, '天津市', 1.3160, 47.3074, 35.9472, 1.3252, 1.0, 0.6526, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (582, 2, 130900, '沧州市', 1.5043, 42.9180, 28.5300, 1.5463, -8.0, 0.6492, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (583, 24, 520100, '贵阳市', 1.3028, 47.8543, 36.7323, 1.3089, -1.0, 0.6484, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (584, 2, 810000, '香港', 1.4792, 41.8278, 28.2763, 1.4909, 0.0, 0.6472, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (585, 8, 530100, '昆明市', 1.4439, 40.6791, 28.1738, 1.4680, -1.0, 0.6443, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (586, 5, 440600, '佛山市', 1.4495, 46.6550, 32.1876, 1.4531, 8.0, 0.6436, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (587, 14, 220100, '长春市', 1.3691, 45.7379, 33.4061, 1.3694, -7.0, 0.6367, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (588, 22, 130100, '石家庄市', 1.3369, 49.9359, 37.3530, 1.3542, -2.0, 0.6359, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (589, 2, 370100, '济南市', 1.4742, 45.9171, 31.1481, 1.4773, -2.0, 0.6341, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (590, 17, 230100, '哈尔滨市', 1.3686, 43.0243, 31.4356, 1.3770, -12.0, 0.6271, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (591, 7, 210100, '沈阳市', 1.4075, 42.8292, 30.4303, 1.4312, -1.0, 0.6247, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (592, 8, 500000, '重庆市', 1.3781, 49.1224, 35.6442, 1.4028, 1.0, 0.6073, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (593, 16, 430100, '长沙市', 1.3646, 41.7421, 30.5891, 1.3766, -3.0, 0.6026, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (594, 18, 320100, '南京市', 1.3682, 46.6258, 34.0792, 1.3821, 0.0, 0.5969, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (595, 13, 420100, '武汉市', 1.3356, 48.9840, 36.6749, 1.3489, -2.0, 0.5795, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (596, 1, 130600, '保定市', 1.5453, 42.4339, 27.4600, 1.5494, -1.0, 0.5733, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (597, 3, 620100, '兰州市', 1.4734, 43.5943, 29.5872, 1.4768, 3.0, 0.5709, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (598, 2, 510100, '成都市', 1.5286, 45.0266, 29.4570, 1.5561, -2.0, 0.5548, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (599, 4, 440300, '深圳市', 1.4624, 43.0758, 29.4558, 1.4909, 6.0, 0.5497, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (600, 7, 460100, '海口市', 1.4211, 38.8780, 27.3586, 1.4277, 1.0, 0.5475, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (601, 3, 610100, '西安市', 1.4679, 44.1729, 30.0918, 1.4874, 0.0, 0.5289, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (602, 1, 650100, '乌鲁木齐市', 1.5639, 45.1303, 28.8571, 1.6192, 10.0, 0.5197, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (603, 1, 110000, '北京市', 1.5935, 45.7901, 28.7359, 1.5708, 12.0, 0.4878, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (604, 4, 310000, '上海市', 1.3957, 42.1350, 30.1902, 1.4113, -4.0, 0.4773, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (605, 3, 440100, '广州市', 1.5263, 43.5460, 28.5304, 1.5502, 9.0, 0.4216, 0, '2025-03-06 02:56:00');
INSERT INTO `rank` VALUES (606, 1, 140600, '朔州市', 1.5646, 45.3721, 28.9990, 1.5721, -1.0, 0.0000, 0, '2025-03-06 02:56:00');
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (2, '674126018@qq.com', 'admin', '2024-03-11 13:39:16');
INSERT INTO `sys_user` VALUES (3, '1674126018@qq.com', 'admin', NULL);
INSERT INTO `sys_user` VALUES (4, '6274126018@qq.com', 'admin', NULL);
INSERT INTO `sys_user` VALUES (5, '627234126018@qq.com', 'admin', NULL);
INSERT INTO `sys_user` VALUES (6, '67412446018@qq.com', 'admin', NULL);
SET FOREIGN_KEY_CHECKS = 1;