-
Notifications
You must be signed in to change notification settings - Fork 0
/
geo_cities.sql
342 lines (342 loc) · 63.7 KB
/
geo_cities.sql
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
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1101', '市辖区', '11', 1, null, null, null, 1, 1, '11');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1201', '市辖区', '12', 1, null, null, null, null, 2, '12');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1301', '石家庄市', '13', 1, null, null, null, null, 3, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1302', '唐山市', '13', 1, null, null, null, null, 4, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1303', '秦皇岛市', '13', 1, null, null, null, null, 5, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1304', '邯郸市', '13', 1, null, null, null, null, 6, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1305', '邢台市', '13', 1, null, null, null, null, 7, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1306', '保定市', '13', 1, null, null, null, null, 8, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1307', '张家口市', '13', 1, null, null, null, null, 9, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1308', '承德市', '13', 1, null, null, null, null, 10, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1309', '沧州市', '13', 1, null, null, null, null, 11, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1310', '廊坊市', '13', 1, null, null, null, null, 12, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1311', '衡水市', '13', 1, null, null, null, null, 13, '13');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1401', '太原市', '14', 1, null, null, null, null, 14, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1402', '大同市', '14', 1, null, null, null, null, 15, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1403', '阳泉市', '14', 1, null, null, null, null, 16, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1404', '长治市', '14', 1, null, null, null, null, 17, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1405', '晋城市', '14', 1, null, null, null, null, 18, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1406', '朔州市', '14', 1, null, null, null, null, 19, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1407', '晋中市', '14', 1, null, null, null, null, 20, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1408', '运城市', '14', 1, null, null, null, null, 21, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1409', '忻州市', '14', 1, null, null, null, null, 22, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1410', '临汾市', '14', 1, null, null, null, null, 23, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1411', '吕梁市', '14', 1, null, null, null, null, 24, '14');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1501', '呼和浩特市', '15', 1, null, null, null, null, 25, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1502', '包头市', '15', 1, null, null, null, null, 26, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1503', '乌海市', '15', 1, null, null, null, null, 27, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1504', '赤峰市', '15', 1, null, null, null, null, 28, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1505', '通辽市', '15', 1, null, null, null, null, 29, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1506', '鄂尔多斯市', '15', 1, null, null, null, null, 30, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1507', '呼伦贝尔市', '15', 1, null, null, null, null, 31, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1508', '巴彦淖尔市', '15', 1, null, null, null, null, 32, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1509', '乌兰察布市', '15', 1, null, null, null, null, 33, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1522', '兴安盟', '15', 1, null, null, null, null, 34, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1525', '锡林郭勒盟', '15', 1, null, null, null, null, 35, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('1529', '阿拉善盟', '15', 1, null, null, null, null, 36, '15');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2101', '沈阳市', '21', 1, null, null, null, null, 37, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2102', '大连市', '21', 1, null, null, null, null, 38, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2103', '鞍山市', '21', 1, null, null, null, null, 39, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2104', '抚顺市', '21', 1, null, null, null, null, 40, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2105', '本溪市', '21', 1, null, null, null, null, 41, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2106', '丹东市', '21', 1, null, null, null, null, 42, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2107', '锦州市', '21', 1, null, null, null, null, 43, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2108', '营口市', '21', 1, null, null, null, null, 44, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2109', '阜新市', '21', 1, null, null, null, null, 45, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2110', '辽阳市', '21', 1, null, null, null, null, 46, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2111', '盘锦市', '21', 1, null, null, null, null, 47, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2112', '铁岭市', '21', 1, null, null, null, null, 48, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2113', '朝阳市', '21', 1, null, null, null, null, 49, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2114', '葫芦岛市', '21', 1, null, null, null, null, 50, '21');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2201', '长春市', '22', 1, null, null, null, null, 51, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2202', '吉林市', '22', 1, null, null, null, null, 52, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2203', '四平市', '22', 1, null, null, null, null, 53, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2204', '辽源市', '22', 1, null, null, null, null, 54, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2205', '通化市', '22', 1, null, null, null, null, 55, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2206', '白山市', '22', 1, null, null, null, null, 56, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2207', '松原市', '22', 1, null, null, null, null, 57, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2208', '白城市', '22', 1, null, null, null, null, 58, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2224', '延边朝鲜族自治州', '22', 1, null, null, null, null, 59, '22');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2301', '哈尔滨市', '23', 1, null, null, null, null, 60, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2302', '齐齐哈尔市', '23', 1, null, null, null, null, 61, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2303', '鸡西市', '23', 1, null, null, null, null, 62, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2304', '鹤岗市', '23', 1, null, null, null, null, 63, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2305', '双鸭山市', '23', 1, null, null, null, null, 64, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2306', '大庆市', '23', 1, null, null, null, null, 65, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2307', '伊春市', '23', 1, null, null, null, null, 66, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2308', '佳木斯市', '23', 1, null, null, null, null, 67, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2309', '七台河市', '23', 1, null, null, null, null, 68, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2310', '牡丹江市', '23', 1, null, null, null, null, 69, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2311', '黑河市', '23', 1, null, null, null, null, 70, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2312', '绥化市', '23', 1, null, null, null, null, 71, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('2327', '大兴安岭地区', '23', 1, null, null, null, null, 72, '23');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3101', '市辖区', '31', 1, null, null, null, 73, 73, '31');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3201', '南京市', '32', 1, null, null, null, null, 74, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3202', '无锡市', '32', 1, null, null, null, null, 75, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3203', '徐州市', '32', 1, null, null, null, null, 76, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3204', '常州市', '32', 1, null, null, null, null, 77, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3205', '苏州市', '32', 1, null, null, null, null, 78, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3206', '南通市', '32', 1, null, null, null, null, 79, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3207', '连云港市', '32', 1, null, null, null, null, 80, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3208', '淮安市', '32', 1, null, null, null, null, 81, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3209', '盐城市', '32', 1, null, null, null, null, 82, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3210', '扬州市', '32', 1, null, null, null, null, 83, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3211', '镇江市', '32', 1, null, null, null, null, 84, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3212', '泰州市', '32', 1, null, null, null, null, 85, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3213', '宿迁市', '32', 1, null, null, null, null, 86, '32');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3301', '杭州市', '33', 1, null, null, null, null, 87, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3302', '宁波市', '33', 1, null, null, null, null, 88, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3303', '温州市', '33', 1, null, null, null, null, 89, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3304', '嘉兴市', '33', 1, null, null, null, null, 90, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3305', '湖州市', '33', 1, null, null, null, null, 91, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3306', '绍兴市', '33', 1, null, null, null, null, 92, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3307', '金华市', '33', 1, null, null, null, null, 93, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3308', '衢州市', '33', 1, null, null, null, null, 94, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3309', '舟山市', '33', 1, null, null, null, null, 95, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3310', '台州市', '33', 1, null, null, null, null, 96, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3311', '丽水市', '33', 1, null, null, null, null, 97, '33');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3401', '合肥市', '34', 1, null, null, null, null, 98, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3402', '芜湖市', '34', 1, null, null, null, null, 99, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3403', '蚌埠市', '34', 1, null, null, null, null, 100, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3404', '淮南市', '34', 1, null, null, null, null, 101, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3405', '马鞍山市', '34', 1, null, null, null, null, 102, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3406', '淮北市', '34', 1, null, null, null, null, 103, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3407', '铜陵市', '34', 1, null, null, null, null, 104, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3408', '安庆市', '34', 1, null, null, null, null, 105, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3410', '黄山市', '34', 1, null, null, null, null, 106, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3411', '滁州市', '34', 1, null, null, null, null, 107, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3412', '阜阳市', '34', 1, null, null, null, null, 108, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3413', '宿州市', '34', 1, null, null, null, null, 109, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3415', '六安市', '34', 1, null, null, null, null, 110, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3416', '亳州市', '34', 1, null, null, null, null, 111, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3417', '池州市', '34', 1, null, null, null, null, 112, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3418', '宣城市', '34', 1, null, null, null, null, 113, '34');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3501', '福州市', '35', 1, null, null, null, null, 114, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3502', '厦门市', '35', 1, null, null, null, null, 115, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3503', '莆田市', '35', 1, null, null, null, null, 116, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3504', '三明市', '35', 1, null, null, null, null, 117, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3505', '泉州市', '35', 1, null, null, null, null, 118, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3506', '漳州市', '35', 1, null, null, null, null, 119, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3507', '南平市', '35', 1, null, null, null, null, 120, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3508', '龙岩市', '35', 1, null, null, null, null, 121, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3509', '宁德市', '35', 1, null, null, null, null, 122, '35');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3601', '南昌市', '36', 1, null, null, null, null, 123, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3602', '景德镇市', '36', 1, null, null, null, null, 124, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3603', '萍乡市', '36', 1, null, null, null, null, 125, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3604', '九江市', '36', 1, null, null, null, null, 126, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3605', '新余市', '36', 1, null, null, null, null, 127, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3606', '鹰潭市', '36', 1, null, null, null, null, 128, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3607', '赣州市', '36', 1, null, null, null, null, 129, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3608', '吉安市', '36', 1, null, null, null, null, 130, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3609', '宜春市', '36', 1, null, null, null, null, 131, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3610', '抚州市', '36', 1, null, null, null, null, 132, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3611', '上饶市', '36', 1, null, null, null, null, 133, '36');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3701', '济南市', '37', 1, null, null, null, null, 134, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3702', '青岛市', '37', 1, null, null, null, null, 135, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3703', '淄博市', '37', 1, null, null, null, null, 136, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3704', '枣庄市', '37', 1, null, null, null, null, 137, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3705', '东营市', '37', 1, null, null, null, null, 138, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3706', '烟台市', '37', 1, null, null, null, null, 139, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3707', '潍坊市', '37', 1, null, null, null, null, 140, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3708', '济宁市', '37', 1, null, null, null, null, 141, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3709', '泰安市', '37', 1, null, null, null, null, 142, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3710', '威海市', '37', 1, null, null, null, null, 143, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3711', '日照市', '37', 1, null, null, null, null, 144, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3713', '临沂市', '37', 1, null, null, null, null, 145, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3714', '德州市', '37', 1, null, null, null, null, 146, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3715', '聊城市', '37', 1, null, null, null, null, 147, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3716', '滨州市', '37', 1, null, null, null, null, 148, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('3717', '菏泽市', '37', 1, null, null, null, null, 149, '37');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4101', '郑州市', '41', 1, null, null, null, null, 150, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4102', '开封市', '41', 1, null, null, null, null, 151, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4103', '洛阳市', '41', 1, null, null, null, null, 152, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4104', '平顶山市', '41', 1, null, null, null, null, 153, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4105', '安阳市', '41', 1, null, null, null, null, 154, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4106', '鹤壁市', '41', 1, null, null, null, null, 155, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4107', '新乡市', '41', 1, null, null, null, null, 156, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4108', '焦作市', '41', 1, null, null, null, null, 157, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4109', '濮阳市', '41', 1, null, null, null, null, 158, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4110', '许昌市', '41', 1, null, null, null, null, 159, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4111', '漯河市', '41', 1, null, null, null, null, 160, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4112', '三门峡市', '41', 1, null, null, null, null, 161, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4113', '南阳市', '41', 1, null, null, null, null, 162, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4114', '商丘市', '41', 1, null, null, null, null, 163, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4115', '信阳市', '41', 1, null, null, null, null, 164, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4116', '周口市', '41', 1, null, null, null, null, 165, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4117', '驻马店市', '41', 1, null, null, null, null, 166, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4190', '省直辖县级行政区划', '41', 1, null, null, null, null, 167, '41');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4201', '武汉市', '42', 1, null, null, null, null, 168, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4202', '黄石市', '42', 1, null, null, null, null, 169, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4203', '十堰市', '42', 1, null, null, null, null, 170, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4205', '宜昌市', '42', 1, null, null, null, null, 171, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4206', '襄阳市', '42', 1, null, null, null, null, 172, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4207', '鄂州市', '42', 1, null, null, null, null, 173, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4208', '荆门市', '42', 1, null, null, null, null, 174, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4209', '孝感市', '42', 1, null, null, null, null, 175, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4210', '荆州市', '42', 1, null, null, null, null, 176, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4211', '黄冈市', '42', 1, null, null, null, null, 177, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4212', '咸宁市', '42', 1, null, null, null, null, 178, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4213', '随州市', '42', 1, null, null, null, null, 179, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4228', '恩施土家族苗族自治州', '42', 1, null, null, null, null, 180, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4290', '省直辖县级行政区划', '42', 1, null, null, null, null, 181, '42');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4301', '长沙市', '43', 1, null, null, null, null, 182, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4302', '株洲市', '43', 1, null, null, null, null, 183, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4303', '湘潭市', '43', 1, null, null, null, null, 184, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4304', '衡阳市', '43', 1, null, null, null, null, 185, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4305', '邵阳市', '43', 1, null, null, null, null, 186, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4306', '岳阳市', '43', 1, null, null, null, null, 187, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4307', '常德市', '43', 1, null, null, null, null, 188, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4308', '张家界市', '43', 1, null, null, null, null, 189, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4309', '益阳市', '43', 1, null, null, null, null, 190, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4310', '郴州市', '43', 1, null, null, null, null, 191, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4311', '永州市', '43', 1, null, null, null, null, 192, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4312', '怀化市', '43', 1, null, null, null, null, 193, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4313', '娄底市', '43', 1, null, null, null, null, 194, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4331', '湘西土家族苗族自治州', '43', 1, null, null, null, null, 195, '43');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4401', '广州市', '44', 1, null, null, null, null, 196, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4402', '韶关市', '44', 1, null, null, null, null, 197, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4403', '深圳市', '44', 1, null, null, null, null, 198, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4404', '珠海市', '44', 1, null, null, null, null, 199, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4405', '汕头市', '44', 1, null, null, null, null, 200, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4406', '佛山市', '44', 1, null, null, null, null, 201, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4407', '江门市', '44', 1, null, null, null, null, 202, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4408', '湛江市', '44', 1, null, null, null, null, 203, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4409', '茂名市', '44', 1, null, null, null, null, 204, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4412', '肇庆市', '44', 1, null, null, null, null, 205, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4413', '惠州市', '44', 1, null, null, null, null, 206, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4414', '梅州市', '44', 1, null, null, null, null, 207, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4415', '汕尾市', '44', 1, null, null, null, null, 208, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4416', '河源市', '44', 1, null, null, null, null, 209, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4417', '阳江市', '44', 1, null, null, null, null, 210, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4418', '清远市', '44', 1, null, null, null, null, 211, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4419', '东莞市', '44', 1, null, null, null, null, 212, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4420', '中山市', '44', 1, null, null, null, null, 213, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4451', '潮州市', '44', 1, null, null, null, null, 214, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4452', '揭阳市', '44', 1, null, null, null, null, 215, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4453', '云浮市', '44', 1, null, null, null, null, 216, '44');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4501', '南宁市', '45', 1, null, null, null, null, 217, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4502', '柳州市', '45', 1, null, null, null, null, 218, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4503', '桂林市', '45', 1, null, null, null, null, 219, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4504', '梧州市', '45', 1, null, null, null, null, 220, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4505', '北海市', '45', 1, null, null, null, null, 221, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4506', '防城港市', '45', 1, null, null, null, null, 222, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4507', '钦州市', '45', 1, null, null, null, null, 223, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4508', '贵港市', '45', 1, null, null, null, null, 224, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4509', '玉林市', '45', 1, null, null, null, null, 225, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4510', '百色市', '45', 1, null, null, null, null, 226, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4511', '贺州市', '45', 1, null, null, null, null, 227, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4512', '河池市', '45', 1, null, null, null, null, 228, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4513', '来宾市', '45', 1, null, null, null, null, 229, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4514', '崇左市', '45', 1, null, null, null, null, 230, '45');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4601', '海口市', '46', 1, null, null, null, null, 231, '46');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4602', '三亚市', '46', 1, null, null, null, null, 232, '46');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4603', '三沙市', '46', 1, null, null, null, null, 233, '46');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4604', '儋州市', '46', 1, null, null, null, null, 234, '46');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('4690', '省直辖县级行政区划', '46', 1, null, null, null, null, 235, '46');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5001', '市辖区', '50', 1, null, null, null, null, 236, '50');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5002', '县', '50', 1, null, null, null, null, 237, '50');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5101', '成都市', '51', 1, null, null, null, null, 238, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5103', '自贡市', '51', 1, null, null, null, null, 239, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5104', '攀枝花市', '51', 1, null, null, null, null, 240, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5105', '泸州市', '51', 1, null, null, null, null, 241, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5106', '德阳市', '51', 1, null, null, null, null, 242, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5107', '绵阳市', '51', 1, null, null, null, null, 243, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5108', '广元市', '51', 1, null, null, null, null, 244, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5109', '遂宁市', '51', 1, null, null, null, null, 245, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5110', '内江市', '51', 1, null, null, null, null, 246, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5111', '乐山市', '51', 1, null, null, null, null, 247, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5113', '南充市', '51', 1, null, null, null, null, 248, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5114', '眉山市', '51', 1, null, null, null, null, 249, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5115', '宜宾市', '51', 1, null, null, null, null, 250, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5116', '广安市', '51', 1, null, null, null, null, 251, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5117', '达州市', '51', 1, null, null, null, null, 252, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5118', '雅安市', '51', 1, null, null, null, null, 253, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5119', '巴中市', '51', 1, null, null, null, null, 254, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5120', '资阳市', '51', 1, null, null, null, null, 255, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5132', '阿坝藏族羌族自治州', '51', 1, null, null, null, null, 256, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5133', '甘孜藏族自治州', '51', 1, null, null, null, null, 257, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5134', '凉山彝族自治州', '51', 1, null, null, null, null, 258, '51');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5201', '贵阳市', '52', 1, null, null, null, null, 259, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5202', '六盘水市', '52', 1, null, null, null, null, 260, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5203', '遵义市', '52', 1, null, null, null, null, 261, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5204', '安顺市', '52', 1, null, null, null, null, 262, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5205', '毕节市', '52', 1, null, null, null, null, 263, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5206', '铜仁市', '52', 1, null, null, null, null, 264, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5223', '黔西南布依族苗族自治州', '52', 1, null, null, null, null, 265, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5226', '黔东南苗族侗族自治州', '52', 1, null, null, null, null, 266, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5227', '黔南布依族苗族自治州', '52', 1, null, null, null, null, 267, '52');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5301', '昆明市', '53', 1, null, null, null, null, 268, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5303', '曲靖市', '53', 1, null, null, null, null, 269, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5304', '玉溪市', '53', 1, null, null, null, null, 270, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5305', '保山市', '53', 1, null, null, null, null, 271, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5306', '昭通市', '53', 1, null, null, null, null, 272, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5307', '丽江市', '53', 1, null, null, null, null, 273, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5308', '普洱市', '53', 1, null, null, null, null, 274, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5309', '临沧市', '53', 1, null, null, null, null, 275, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5323', '楚雄彝族自治州', '53', 1, null, null, null, null, 276, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5325', '红河哈尼族彝族自治州', '53', 1, null, null, null, null, 277, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5326', '文山壮族苗族自治州', '53', 1, null, null, null, null, 278, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5328', '西双版纳傣族自治州', '53', 1, null, null, null, null, 279, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5329', '大理白族自治州', '53', 1, null, null, null, null, 280, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5331', '德宏傣族景颇族自治州', '53', 1, null, null, null, null, 281, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5333', '怒江傈僳族自治州', '53', 1, null, null, null, null, 282, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5334', '迪庆藏族自治州', '53', 1, null, null, null, null, 283, '53');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5401', '拉萨市', '54', 1, null, null, null, null, 284, '54');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5402', '日喀则市', '54', 1, null, null, null, null, 285, '54');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5403', '昌都市', '54', 1, null, null, null, null, 286, '54');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5404', '林芝市', '54', 1, null, null, null, null, 287, '54');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5405', '山南市', '54', 1, null, null, null, null, 288, '54');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5406', '那曲市', '54', 1, null, null, null, null, 289, '54');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('5425', '阿里地区', '54', 1, null, null, null, null, 290, '54');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6101', '西安市', '61', 1, null, null, null, null, 291, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6102', '铜川市', '61', 1, null, null, null, null, 292, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6103', '宝鸡市', '61', 1, null, null, null, null, 293, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6104', '咸阳市', '61', 1, null, null, null, null, 294, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6105', '渭南市', '61', 1, null, null, null, null, 295, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6106', '延安市', '61', 1, null, null, null, null, 296, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6107', '汉中市', '61', 1, null, null, null, null, 297, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6108', '榆林市', '61', 1, null, null, null, null, 298, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6109', '安康市', '61', 1, null, null, null, null, 299, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6110', '商洛市', '61', 1, null, null, null, null, 300, '61');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6201', '兰州市', '62', 1, null, null, null, null, 301, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6202', '嘉峪关市', '62', 1, null, null, null, null, 302, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6203', '金昌市', '62', 1, null, null, null, null, 303, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6204', '白银市', '62', 1, null, null, null, null, 304, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6205', '天水市', '62', 1, null, null, null, null, 305, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6206', '武威市', '62', 1, null, null, null, null, 306, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6207', '张掖市', '62', 1, null, null, null, null, 307, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6208', '平凉市', '62', 1, null, null, null, null, 308, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6209', '酒泉市', '62', 1, null, null, null, null, 309, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6210', '庆阳市', '62', 1, null, null, null, null, 310, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6211', '定西市', '62', 1, null, null, null, null, 311, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6212', '陇南市', '62', 1, null, null, null, null, 312, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6229', '临夏回族自治州', '62', 1, null, null, null, null, 313, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6230', '甘南藏族自治州', '62', 1, null, null, null, null, 314, '62');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6301', '西宁市', '63', 1, null, null, null, null, 315, '63');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6302', '海东市', '63', 1, null, null, null, null, 316, '63');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6322', '海北藏族自治州', '63', 1, null, null, null, null, 317, '63');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6323', '黄南藏族自治州', '63', 1, null, null, null, null, 318, '63');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6325', '海南藏族自治州', '63', 1, null, null, null, null, 319, '63');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6326', '果洛藏族自治州', '63', 1, null, null, null, null, 320, '63');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6327', '玉树藏族自治州', '63', 1, null, null, null, null, 321, '63');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6328', '海西蒙古族藏族自治州', '63', 1, null, null, null, null, 322, '63');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6401', '银川市', '64', 1, null, null, null, null, 323, '64');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6402', '石嘴山市', '64', 1, null, null, null, null, 324, '64');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6403', '吴忠市', '64', 1, null, null, null, null, 325, '64');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6404', '固原市', '64', 1, null, null, null, null, 326, '64');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6405', '中卫市', '64', 1, null, null, null, null, 327, '64');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6501', '乌鲁木齐市', '65', 1, null, null, null, null, 328, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6502', '克拉玛依市', '65', 1, null, null, null, null, 329, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6504', '吐鲁番市', '65', 1, null, null, null, null, 330, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6505', '哈密市', '65', 1, null, null, null, null, 331, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6523', '昌吉回族自治州', '65', 1, null, null, null, null, 332, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6527', '博尔塔拉蒙古自治州', '65', 1, null, null, null, null, 333, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6528', '巴音郭楞蒙古自治州', '65', 1, null, null, null, null, 334, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6529', '阿克苏地区', '65', 1, null, null, null, null, 335, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6530', '克孜勒苏柯尔克孜自治州', '65', 1, null, null, null, null, 336, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6531', '喀什地区', '65', 1, null, null, null, null, 337, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6532', '和田地区', '65', 1, null, null, null, null, 338, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6540', '伊犁哈萨克自治州', '65', 1, null, null, null, null, 339, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6542', '塔城地区', '65', 1, null, null, null, null, 340, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6543', '阿勒泰地区', '65', 1, null, null, null, null, 341, '65');
INSERT INTO power.geo_cities (code, name, provinceCode, level, geocode, latitude, longitude, sort, id, parentCode) VALUES ('6590', '自治区直辖县级行政区划', '65', 1, null, null, null, null, 342, '65');