xtrade-order_v20240829.sql
36 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
use `dili_xtrade`;
ALTER TABLE `dili_xtrade`.`ecap_contact_person`
ADD COLUMN `street_id` bigint NULL COMMENT '街道id' AFTER `district_name`,
ADD COLUMN `street_name` varchar(40) NULL COMMENT '街道名称' AFTER `street_id`;
ALTER TABLE `dili_xtrade`.`order_delivery`
ADD COLUMN `street_id` bigint NULL COMMENT '街道id' AFTER `district_name`,
ADD COLUMN `street_name` varchar(40) NULL COMMENT '街道名称' AFTER `street_id`;
DROP TABLE IF EXISTS `base_region`;
CREATE TABLE `base_region` (
`id` bigint NOT NULL AUTO_INCREMENT,
`market_id` bigint NULL DEFAULT NULL COMMENT '市场id',
`province_id` bigint NULL DEFAULT NULL COMMENT '省id',
`province_name` varchar(10) NULL DEFAULT NULL COMMENT '省',
`city_id` bigint NULL DEFAULT NULL COMMENT '城市id',
`city_name` varchar(30) NULL DEFAULT NULL COMMENT '城市',
`district_id` bigint NULL DEFAULT NULL COMMENT '区县id',
`district_name` varchar(30) NULL DEFAULT NULL COMMENT '区县',
`street_id` bigint NULL DEFAULT NULL COMMENT '街道id',
`street_name` varchar(30) NULL DEFAULT NULL COMMENT '街道名称',
`state` tinyint NULL DEFAULT 1 COMMENT '是否启用(1启用，2禁用)',
`created_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modified_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`version` int NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB COMMENT = '腾讯地图行政区划';
-- ----------------------------
-- Records of base_region
-- ----------------------------
INSERT INTO `base_region` VALUES (121, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102001, '清波街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (122, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102003, '湖滨街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (123, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102004, '小营街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (124, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102008, '南星街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (125, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102009, '紫阳街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (126, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102010, '望江街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (127, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102011, '凯旋街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (128, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102012, '采荷街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (129, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102013, '闸弄口街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (130, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102014, '四季青街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (131, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102015, '彭埠街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (132, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102016, '笕桥街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:48', 1);
INSERT INTO `base_region` VALUES (133, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102017, '丁兰街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (134, 30, 330000, '浙江省', 330100, '杭州市', 330102, '上城区', 330102018, '九堡街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (135, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105001, '米市巷街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (136, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105002, '湖墅街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (137, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105003, '小河街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (138, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105004, '和睦街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (139, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105005, '拱宸桥街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (140, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105007, '大关街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (141, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105008, '上塘街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (142, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105009, '祥符街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (143, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105010, '康桥街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (144, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105011, '半山街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (145, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105012, '天水街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (146, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105013, '武林街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (147, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105014, '长庆街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (148, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105015, '潮鸣街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (149, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105016, '朝晖街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (150, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105017, '文晖街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (151, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105018, '东新街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (152, 30, 330000, '浙江省', 330100, '杭州市', 330105, '拱墅区', 330105019, '石桥街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (153, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106002, '北山街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (154, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106003, '灵隐街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (155, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106004, '西溪街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (156, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106005, '翠苑街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (157, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106006, '文新街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (158, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106011, '转塘街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (159, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106012, '蒋村街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (160, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106013, '留下街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (161, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106014, '古荡街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (162, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106015, '西湖街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (163, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106109, '三墩镇', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (164, 30, 330000, '浙江省', 330100, '杭州市', 330106, '西湖区', 330106110, '双浦镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (165, 30, 330000, '浙江省', 330100, '杭州市', 330108, '滨江区', 330108001, '西兴街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (166, 30, 330000, '浙江省', 330100, '杭州市', 330108, '滨江区', 330108002, '浦沿街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (167, 30, 330000, '浙江省', 330100, '杭州市', 330108, '滨江区', 330108003, '长河街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (168, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109001, '城厢街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (169, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109002, '北干街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (170, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109003, '蜀山街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (171, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109004, '新塘街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (172, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109005, '靖江街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (173, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109006, '南阳街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (174, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109012, '新街街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (175, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109013, '闻堰街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (176, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109014, '宁围街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (177, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109015, '盈丰街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:23:18', 1);
INSERT INTO `base_region` VALUES (178, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109100, '楼塔镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (179, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109101, '河上镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (180, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109102, '戴村镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (181, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109103, '浦阳镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (182, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109104, '进化镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (183, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109105, '临浦镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (184, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109106, '义桥镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (185, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109107, '所前镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (186, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109108, '衙前镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (187, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109113, '瓜沥镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (188, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109115, '益农镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (189, 30, 330000, '浙江省', 330100, '杭州市', 330109, '萧山区', 330109120, '党湾镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (190, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110005, '五常街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (191, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110009, '仁和街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (192, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110010, '闲林街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (193, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110011, '中泰街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (194, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110012, '余杭街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (195, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110013, '良渚街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (196, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110014, '仓前街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:49', 1);
INSERT INTO `base_region` VALUES (197, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110109, '径山镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (198, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110110, '瓶窑镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (199, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110111, '鸬鸟镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (200, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110112, '百丈镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (201, 30, 330000, '浙江省', 330100, '杭州市', 330110, '余杭区', 330110113, '黄湖镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (202, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111001, '富春街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (203, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111002, '春江街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (204, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111003, '东洲街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (205, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111004, '鹿山街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (206, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111005, '银湖街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (207, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111100, '万市镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (208, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111101, '洞桥镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (209, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111102, '新登镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (210, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111103, '渌渚镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (211, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111104, '胥口镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (212, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111105, '永昌镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (213, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111106, '大源镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (214, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111107, '灵桥镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (215, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111108, '里山镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (216, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111109, '常绿镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (217, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111110, '场口镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (218, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111111, '常安镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (219, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111112, '龙门镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (220, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111200, '新桐乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (221, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111201, '上官乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (222, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111202, '渔山乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (223, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111203, '环山乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (224, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111204, '湖源乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (225, 30, 330000, '浙江省', 330100, '杭州市', 330111, '富阳区', 330111205, '春建乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (226, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112001, '锦城街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (227, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112002, '玲珑街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (228, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112003, '青山湖街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (229, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112004, '锦南街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (230, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112005, '锦北街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (231, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112100, '高虹镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (232, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112101, '太湖源镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (233, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112102, '於潜镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (234, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112103, '天目山镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (235, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112104, '太阳镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (236, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112105, '潜川镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (237, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112106, '昌化镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (238, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112107, '河桥镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (239, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112108, '龙岗镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (240, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112109, '湍口镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (241, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112110, '清凉峰镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:29', 1);
INSERT INTO `base_region` VALUES (242, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112111, '岛石镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (243, 30, 330000, '浙江省', 330100, '杭州市', 330112, '临安区', 330112112, '板桥镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (244, 30, 330000, '浙江省', 330100, '杭州市', 330113, '临平区', 330113001, '临平街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (245, 30, 330000, '浙江省', 330100, '杭州市', 330113, '临平区', 330113002, '南苑街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (246, 30, 330000, '浙江省', 330100, '杭州市', 330113, '临平区', 330113003, '东湖街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (247, 30, 330000, '浙江省', 330100, '杭州市', 330113, '临平区', 330113004, '星桥街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (248, 30, 330000, '浙江省', 330100, '杭州市', 330113, '临平区', 330113006, '乔司街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (249, 30, 330000, '浙江省', 330100, '杭州市', 330113, '临平区', 330113007, '运河街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (250, 30, 330000, '浙江省', 330100, '杭州市', 330113, '临平区', 330113008, '崇贤街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (251, 30, 330000, '浙江省', 330100, '杭州市', 330113, '临平区', 330113102, '塘栖镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (252, 30, 330000, '浙江省', 330100, '杭州市', 330114, '钱塘区', 330114001, '白杨街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (253, 30, 330000, '浙江省', 330100, '杭州市', 330114, '钱塘区', 330114002, '下沙街道', 1, '2024-08-29 12:49:16', '2024-08-30 16:13:50', 1);
INSERT INTO `base_region` VALUES (254, 30, 330000, '浙江省', 330100, '杭州市', 330114, '钱塘区', 330114003, '义蓬街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (255, 30, 330000, '浙江省', 330100, '杭州市', 330114, '钱塘区', 330114004, '新湾街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (256, 30, 330000, '浙江省', 330100, '杭州市', 330114, '钱塘区', 330114005, '河庄街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (257, 30, 330000, '浙江省', 330100, '杭州市', 330114, '钱塘区', 330114006, '前进街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (258, 30, 330000, '浙江省', 330100, '杭州市', 330114, '钱塘区', 330114007, '临江街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (259, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122001, '桐君街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (260, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122002, '旧县街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (261, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122003, '城南街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (262, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122004, '凤川街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (263, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122101, '富春江镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (264, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122102, '横村镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (265, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122105, '江南镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (266, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122109, '分水镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (267, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122110, '瑶琳镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (268, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122112, '百江镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (269, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122201, '莪山畲族乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (270, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122202, '钟山乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (271, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122204, '新合乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (272, 30, 330000, '浙江省', 330100, '杭州市', 330122, '桐庐县', 330122210, '合村乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (273, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127101, '文昌镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (274, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127102, '石林镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (275, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127103, '临岐镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (276, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127104, '威坪镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (277, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127106, '姜家镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (278, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127107, '梓桐镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (279, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127108, '汾口镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (280, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127109, '中洲镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (281, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127110, '大墅镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (282, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127111, '枫树岭镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (283, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127112, '千岛湖镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (284, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127200, '里商乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (285, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127201, '金峰乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (286, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127202, '富文乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (287, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127203, '左口乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (288, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127205, '屏门乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (289, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127206, '瑶山乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (290, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127208, '王阜乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (291, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127210, '宋村乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (292, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127211, '鸠坑乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (293, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127212, '浪川乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (294, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127214, '界首乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (295, 30, 330000, '浙江省', 330100, '杭州市', 330127, '淳安县', 330127216, '安阳乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (296, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182001, '新安江街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (297, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182002, '洋溪街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (298, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182003, '更楼街道', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (299, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182101, '莲花镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (300, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182102, '乾潭镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (301, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182104, '梅城镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (302, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182105, '杨村桥镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (303, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182106, '下涯镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (304, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182107, '大洋镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (305, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182108, '三都镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (306, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182109, '寿昌镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (307, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182110, '航头镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (308, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182111, '大慈岩镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (309, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182112, '大同镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (310, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182113, '李家镇', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);
INSERT INTO `base_region` VALUES (311, 30, 330000, '浙江省', 330100, '杭州市', 330182, '建德市', 330182202, '钦堂乡', 0, '2024-08-29 12:49:16', '2024-09-02 11:20:30', 1);