forked from wecatch/china_regions
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcity.sql
executable file
·344 lines (344 loc) · 22.8 KB
/
city.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
343
344
INSERT INTO city VALUES ('1', '110100', '市辖区', '110000');
INSERT INTO city VALUES ('2', '120100', '市辖区', '120000');
INSERT INTO city VALUES ('3', '130100', '石家庄市', '130000');
INSERT INTO city VALUES ('4', '130200', '唐山市', '130000');
INSERT INTO city VALUES ('5', '130300', '秦皇岛市', '130000');
INSERT INTO city VALUES ('6', '130400', '邯郸市', '130000');
INSERT INTO city VALUES ('7', '130500', '邢台市', '130000');
INSERT INTO city VALUES ('8', '130600', '保定市', '130000');
INSERT INTO city VALUES ('9', '130700', '张家口市', '130000');
INSERT INTO city VALUES ('10', '130800', '承德市', '130000');
INSERT INTO city VALUES ('11', '130900', '沧州市', '130000');
INSERT INTO city VALUES ('12', '131000', '廊坊市', '130000');
INSERT INTO city VALUES ('13', '131100', '衡水市', '130000');
INSERT INTO city VALUES ('14', '139000', '省直辖县级行政区划', '130000');
INSERT INTO city VALUES ('15', '140100', '太原市', '140000');
INSERT INTO city VALUES ('16', '140200', '大同市', '140000');
INSERT INTO city VALUES ('17', '140300', '阳泉市', '140000');
INSERT INTO city VALUES ('18', '140400', '长治市', '140000');
INSERT INTO city VALUES ('19', '140500', '晋城市', '140000');
INSERT INTO city VALUES ('20', '140600', '朔州市', '140000');
INSERT INTO city VALUES ('21', '140700', '晋中市', '140000');
INSERT INTO city VALUES ('22', '140800', '运城市', '140000');
INSERT INTO city VALUES ('23', '140900', '忻州市', '140000');
INSERT INTO city VALUES ('24', '141000', '临汾市', '140000');
INSERT INTO city VALUES ('25', '141100', '吕梁市', '140000');
INSERT INTO city VALUES ('26', '150100', '呼和浩特市', '150000');
INSERT INTO city VALUES ('27', '150200', '包头市', '150000');
INSERT INTO city VALUES ('28', '150300', '乌海市', '150000');
INSERT INTO city VALUES ('29', '150400', '赤峰市', '150000');
INSERT INTO city VALUES ('30', '150500', '通辽市', '150000');
INSERT INTO city VALUES ('31', '150600', '鄂尔多斯市', '150000');
INSERT INTO city VALUES ('32', '150700', '呼伦贝尔市', '150000');
INSERT INTO city VALUES ('33', '150800', '巴彦淖尔市', '150000');
INSERT INTO city VALUES ('34', '150900', '乌兰察布市', '150000');
INSERT INTO city VALUES ('35', '152200', '兴安盟', '150000');
INSERT INTO city VALUES ('36', '152500', '锡林郭勒盟', '150000');
INSERT INTO city VALUES ('37', '152900', '阿拉善盟', '150000');
INSERT INTO city VALUES ('38', '210100', '沈阳市', '210000');
INSERT INTO city VALUES ('39', '210200', '大连市', '210000');
INSERT INTO city VALUES ('40', '210300', '鞍山市', '210000');
INSERT INTO city VALUES ('41', '210400', '抚顺市', '210000');
INSERT INTO city VALUES ('42', '210500', '本溪市', '210000');
INSERT INTO city VALUES ('43', '210600', '丹东市', '210000');
INSERT INTO city VALUES ('44', '210700', '锦州市', '210000');
INSERT INTO city VALUES ('45', '210800', '营口市', '210000');
INSERT INTO city VALUES ('46', '210900', '阜新市', '210000');
INSERT INTO city VALUES ('47', '211000', '辽阳市', '210000');
INSERT INTO city VALUES ('48', '211100', '盘锦市', '210000');
INSERT INTO city VALUES ('49', '211200', '铁岭市', '210000');
INSERT INTO city VALUES ('50', '211300', '朝阳市', '210000');
INSERT INTO city VALUES ('51', '211400', '葫芦岛市', '210000');
INSERT INTO city VALUES ('52', '220100', '长春市', '220000');
INSERT INTO city VALUES ('53', '220200', '吉林市', '220000');
INSERT INTO city VALUES ('54', '220300', '四平市', '220000');
INSERT INTO city VALUES ('55', '220400', '辽源市', '220000');
INSERT INTO city VALUES ('56', '220500', '通化市', '220000');
INSERT INTO city VALUES ('57', '220600', '白山市', '220000');
INSERT INTO city VALUES ('58', '220700', '松原市', '220000');
INSERT INTO city VALUES ('59', '220800', '白城市', '220000');
INSERT INTO city VALUES ('60', '222400', '延边朝鲜族自治州', '220000');
INSERT INTO city VALUES ('61', '230100', '哈尔滨市', '230000');
INSERT INTO city VALUES ('62', '230200', '齐齐哈尔市', '230000');
INSERT INTO city VALUES ('63', '230300', '鸡西市', '230000');
INSERT INTO city VALUES ('64', '230400', '鹤岗市', '230000');
INSERT INTO city VALUES ('65', '230500', '双鸭山市', '230000');
INSERT INTO city VALUES ('66', '230600', '大庆市', '230000');
INSERT INTO city VALUES ('67', '230700', '伊春市', '230000');
INSERT INTO city VALUES ('68', '230800', '佳木斯市', '230000');
INSERT INTO city VALUES ('69', '230900', '七台河市', '230000');
INSERT INTO city VALUES ('70', '231000', '牡丹江市', '230000');
INSERT INTO city VALUES ('71', '231100', '黑河市', '230000');
INSERT INTO city VALUES ('72', '231200', '绥化市', '230000');
INSERT INTO city VALUES ('73', '232700', '大兴安岭地区', '230000');
INSERT INTO city VALUES ('74', '310100', '市辖区', '310000');
INSERT INTO city VALUES ('75', '320100', '南京市', '320000');
INSERT INTO city VALUES ('76', '320200', '无锡市', '320000');
INSERT INTO city VALUES ('77', '320300', '徐州市', '320000');
INSERT INTO city VALUES ('78', '320400', '常州市', '320000');
INSERT INTO city VALUES ('79', '320500', '苏州市', '320000');
INSERT INTO city VALUES ('80', '320600', '南通市', '320000');
INSERT INTO city VALUES ('81', '320700', '连云港市', '320000');
INSERT INTO city VALUES ('82', '320800', '淮安市', '320000');
INSERT INTO city VALUES ('83', '320900', '盐城市', '320000');
INSERT INTO city VALUES ('84', '321000', '扬州市', '320000');
INSERT INTO city VALUES ('85', '321100', '镇江市', '320000');
INSERT INTO city VALUES ('86', '321200', '泰州市', '320000');
INSERT INTO city VALUES ('87', '321300', '宿迁市', '320000');
INSERT INTO city VALUES ('88', '330100', '杭州市', '330000');
INSERT INTO city VALUES ('89', '330200', '宁波市', '330000');
INSERT INTO city VALUES ('90', '330300', '温州市', '330000');
INSERT INTO city VALUES ('91', '330400', '嘉兴市', '330000');
INSERT INTO city VALUES ('92', '330500', '湖州市', '330000');
INSERT INTO city VALUES ('93', '330600', '绍兴市', '330000');
INSERT INTO city VALUES ('94', '330700', '金华市', '330000');
INSERT INTO city VALUES ('95', '330800', '衢州市', '330000');
INSERT INTO city VALUES ('96', '330900', '舟山市', '330000');
INSERT INTO city VALUES ('97', '331000', '台州市', '330000');
INSERT INTO city VALUES ('98', '331100', '丽水市', '330000');
INSERT INTO city VALUES ('99', '340100', '合肥市', '340000');
INSERT INTO city VALUES ('100', '340200', '芜湖市', '340000');
INSERT INTO city VALUES ('101', '340300', '蚌埠市', '340000');
INSERT INTO city VALUES ('102', '340400', '淮南市', '340000');
INSERT INTO city VALUES ('103', '340500', '马鞍山市', '340000');
INSERT INTO city VALUES ('104', '340600', '淮北市', '340000');
INSERT INTO city VALUES ('105', '340700', '铜陵市', '340000');
INSERT INTO city VALUES ('106', '340800', '安庆市', '340000');
INSERT INTO city VALUES ('107', '341000', '黄山市', '340000');
INSERT INTO city VALUES ('108', '341100', '滁州市', '340000');
INSERT INTO city VALUES ('109', '341200', '阜阳市', '340000');
INSERT INTO city VALUES ('110', '341300', '宿州市', '340000');
INSERT INTO city VALUES ('111', '341500', '六安市', '340000');
INSERT INTO city VALUES ('112', '341600', '亳州市', '340000');
INSERT INTO city VALUES ('113', '341700', '池州市', '340000');
INSERT INTO city VALUES ('114', '341800', '宣城市', '340000');
INSERT INTO city VALUES ('115', '350100', '福州市', '350000');
INSERT INTO city VALUES ('116', '350200', '厦门市', '350000');
INSERT INTO city VALUES ('117', '350300', '莆田市', '350000');
INSERT INTO city VALUES ('118', '350400', '三明市', '350000');
INSERT INTO city VALUES ('119', '350500', '泉州市', '350000');
INSERT INTO city VALUES ('120', '350600', '漳州市', '350000');
INSERT INTO city VALUES ('121', '350700', '南平市', '350000');
INSERT INTO city VALUES ('122', '350800', '龙岩市', '350000');
INSERT INTO city VALUES ('123', '350900', '宁德市', '350000');
INSERT INTO city VALUES ('124', '360100', '南昌市', '360000');
INSERT INTO city VALUES ('125', '360200', '景德镇市', '360000');
INSERT INTO city VALUES ('126', '360300', '萍乡市', '360000');
INSERT INTO city VALUES ('127', '360400', '九江市', '360000');
INSERT INTO city VALUES ('128', '360500', '新余市', '360000');
INSERT INTO city VALUES ('129', '360600', '鹰潭市', '360000');
INSERT INTO city VALUES ('130', '360700', '赣州市', '360000');
INSERT INTO city VALUES ('131', '360800', '吉安市', '360000');
INSERT INTO city VALUES ('132', '360900', '宜春市', '360000');
INSERT INTO city VALUES ('133', '361000', '抚州市', '360000');
INSERT INTO city VALUES ('134', '361100', '上饶市', '360000');
INSERT INTO city VALUES ('135', '370100', '济南市', '370000');
INSERT INTO city VALUES ('136', '370200', '青岛市', '370000');
INSERT INTO city VALUES ('137', '370300', '淄博市', '370000');
INSERT INTO city VALUES ('138', '370400', '枣庄市', '370000');
INSERT INTO city VALUES ('139', '370500', '东营市', '370000');
INSERT INTO city VALUES ('140', '370600', '烟台市', '370000');
INSERT INTO city VALUES ('141', '370700', '潍坊市', '370000');
INSERT INTO city VALUES ('142', '370800', '济宁市', '370000');
INSERT INTO city VALUES ('143', '370900', '泰安市', '370000');
INSERT INTO city VALUES ('144', '371000', '威海市', '370000');
INSERT INTO city VALUES ('145', '371100', '日照市', '370000');
INSERT INTO city VALUES ('146', '371200', '莱芜市', '370000');
INSERT INTO city VALUES ('147', '371300', '临沂市', '370000');
INSERT INTO city VALUES ('148', '371400', '德州市', '370000');
INSERT INTO city VALUES ('149', '371500', '聊城市', '370000');
INSERT INTO city VALUES ('150', '371600', '滨州市', '370000');
INSERT INTO city VALUES ('151', '371700', '菏泽市', '370000');
INSERT INTO city VALUES ('152', '410100', '郑州市', '410000');
INSERT INTO city VALUES ('153', '410200', '开封市', '410000');
INSERT INTO city VALUES ('154', '410300', '洛阳市', '410000');
INSERT INTO city VALUES ('155', '410400', '平顶山市', '410000');
INSERT INTO city VALUES ('156', '410500', '安阳市', '410000');
INSERT INTO city VALUES ('157', '410600', '鹤壁市', '410000');
INSERT INTO city VALUES ('158', '410700', '新乡市', '410000');
INSERT INTO city VALUES ('159', '410800', '焦作市', '410000');
INSERT INTO city VALUES ('160', '410900', '濮阳市', '410000');
INSERT INTO city VALUES ('161', '411000', '许昌市', '410000');
INSERT INTO city VALUES ('162', '411100', '漯河市', '410000');
INSERT INTO city VALUES ('163', '411200', '三门峡市', '410000');
INSERT INTO city VALUES ('164', '411300', '南阳市', '410000');
INSERT INTO city VALUES ('165', '411400', '商丘市', '410000');
INSERT INTO city VALUES ('166', '411500', '信阳市', '410000');
INSERT INTO city VALUES ('167', '411600', '周口市', '410000');
INSERT INTO city VALUES ('168', '411700', '驻马店市', '410000');
INSERT INTO city VALUES ('169', '419000', '省直辖县级行政区划', '410000');
INSERT INTO city VALUES ('170', '420100', '武汉市', '420000');
INSERT INTO city VALUES ('171', '420200', '黄石市', '420000');
INSERT INTO city VALUES ('172', '420300', '十堰市', '420000');
INSERT INTO city VALUES ('173', '420500', '宜昌市', '420000');
INSERT INTO city VALUES ('174', '420600', '襄阳市', '420000');
INSERT INTO city VALUES ('175', '420700', '鄂州市', '420000');
INSERT INTO city VALUES ('176', '420800', '荆门市', '420000');
INSERT INTO city VALUES ('177', '420900', '孝感市', '420000');
INSERT INTO city VALUES ('178', '421000', '荆州市', '420000');
INSERT INTO city VALUES ('179', '421100', '黄冈市', '420000');
INSERT INTO city VALUES ('180', '421200', '咸宁市', '420000');
INSERT INTO city VALUES ('181', '421300', '随州市', '420000');
INSERT INTO city VALUES ('182', '422800', '恩施土家族苗族自治州', '420000');
INSERT INTO city VALUES ('183', '429000', '省直辖县级行政区划', '420000');
INSERT INTO city VALUES ('184', '430100', '长沙市', '430000');
INSERT INTO city VALUES ('185', '430200', '株洲市', '430000');
INSERT INTO city VALUES ('186', '430300', '湘潭市', '430000');
INSERT INTO city VALUES ('187', '430400', '衡阳市', '430000');
INSERT INTO city VALUES ('188', '430500', '邵阳市', '430000');
INSERT INTO city VALUES ('189', '430600', '岳阳市', '430000');
INSERT INTO city VALUES ('190', '430700', '常德市', '430000');
INSERT INTO city VALUES ('191', '430800', '张家界市', '430000');
INSERT INTO city VALUES ('192', '430900', '益阳市', '430000');
INSERT INTO city VALUES ('193', '431000', '郴州市', '430000');
INSERT INTO city VALUES ('194', '431100', '永州市', '430000');
INSERT INTO city VALUES ('195', '431200', '怀化市', '430000');
INSERT INTO city VALUES ('196', '431300', '娄底市', '430000');
INSERT INTO city VALUES ('197', '433100', '湘西土家族苗族自治州', '430000');
INSERT INTO city VALUES ('198', '440100', '广州市', '440000');
INSERT INTO city VALUES ('199', '440200', '韶关市', '440000');
INSERT INTO city VALUES ('200', '440300', '深圳市', '440000');
INSERT INTO city VALUES ('201', '440400', '珠海市', '440000');
INSERT INTO city VALUES ('202', '440500', '汕头市', '440000');
INSERT INTO city VALUES ('203', '440600', '佛山市', '440000');
INSERT INTO city VALUES ('204', '440700', '江门市', '440000');
INSERT INTO city VALUES ('205', '440800', '湛江市', '440000');
INSERT INTO city VALUES ('206', '440900', '茂名市', '440000');
INSERT INTO city VALUES ('207', '441200', '肇庆市', '440000');
INSERT INTO city VALUES ('208', '441300', '惠州市', '440000');
INSERT INTO city VALUES ('209', '441400', '梅州市', '440000');
INSERT INTO city VALUES ('210', '441500', '汕尾市', '440000');
INSERT INTO city VALUES ('211', '441600', '河源市', '440000');
INSERT INTO city VALUES ('212', '441700', '阳江市', '440000');
INSERT INTO city VALUES ('213', '441800', '清远市', '440000');
INSERT INTO city VALUES ('214', '441900', '东莞市', '440000');
INSERT INTO city VALUES ('215', '442000', '中山市', '440000');
INSERT INTO city VALUES ('216', '445100', '潮州市', '440000');
INSERT INTO city VALUES ('217', '445200', '揭阳市', '440000');
INSERT INTO city VALUES ('218', '445300', '云浮市', '440000');
INSERT INTO city VALUES ('219', '450100', '南宁市', '450000');
INSERT INTO city VALUES ('220', '450200', '柳州市', '450000');
INSERT INTO city VALUES ('221', '450300', '桂林市', '450000');
INSERT INTO city VALUES ('222', '450400', '梧州市', '450000');
INSERT INTO city VALUES ('223', '450500', '北海市', '450000');
INSERT INTO city VALUES ('224', '450600', '防城港市', '450000');
INSERT INTO city VALUES ('225', '450700', '钦州市', '450000');
INSERT INTO city VALUES ('226', '450800', '贵港市', '450000');
INSERT INTO city VALUES ('227', '450900', '玉林市', '450000');
INSERT INTO city VALUES ('228', '451000', '百色市', '450000');
INSERT INTO city VALUES ('229', '451100', '贺州市', '450000');
INSERT INTO city VALUES ('230', '451200', '河池市', '450000');
INSERT INTO city VALUES ('231', '451300', '来宾市', '450000');
INSERT INTO city VALUES ('232', '451400', '崇左市', '450000');
INSERT INTO city VALUES ('233', '460100', '海口市', '460000');
INSERT INTO city VALUES ('234', '460200', '三亚市', '460000');
INSERT INTO city VALUES ('235', '460300', '三沙市', '460000');
INSERT INTO city VALUES ('236', '460400', '儋州市', '460000');
INSERT INTO city VALUES ('237', '469000', '省直辖县级行政区划', '460000');
INSERT INTO city VALUES ('238', '500100', '市辖区', '500000');
INSERT INTO city VALUES ('239', '500200', '县', '500000');
INSERT INTO city VALUES ('240', '510100', '成都市', '510000');
INSERT INTO city VALUES ('241', '510300', '自贡市', '510000');
INSERT INTO city VALUES ('242', '510400', '攀枝花市', '510000');
INSERT INTO city VALUES ('243', '510500', '泸州市', '510000');
INSERT INTO city VALUES ('244', '510600', '德阳市', '510000');
INSERT INTO city VALUES ('245', '510700', '绵阳市', '510000');
INSERT INTO city VALUES ('246', '510800', '广元市', '510000');
INSERT INTO city VALUES ('247', '510900', '遂宁市', '510000');
INSERT INTO city VALUES ('248', '511000', '内江市', '510000');
INSERT INTO city VALUES ('249', '511100', '乐山市', '510000');
INSERT INTO city VALUES ('250', '511300', '南充市', '510000');
INSERT INTO city VALUES ('251', '511400', '眉山市', '510000');
INSERT INTO city VALUES ('252', '511500', '宜宾市', '510000');
INSERT INTO city VALUES ('253', '511600', '广安市', '510000');
INSERT INTO city VALUES ('254', '511700', '达州市', '510000');
INSERT INTO city VALUES ('255', '511800', '雅安市', '510000');
INSERT INTO city VALUES ('256', '511900', '巴中市', '510000');
INSERT INTO city VALUES ('257', '512000', '资阳市', '510000');
INSERT INTO city VALUES ('258', '513200', '阿坝藏族羌族自治州', '510000');
INSERT INTO city VALUES ('259', '513300', '甘孜藏族自治州', '510000');
INSERT INTO city VALUES ('260', '513400', '凉山彝族自治州', '510000');
INSERT INTO city VALUES ('261', '520100', '贵阳市', '520000');
INSERT INTO city VALUES ('262', '520200', '六盘水市', '520000');
INSERT INTO city VALUES ('263', '520300', '遵义市', '520000');
INSERT INTO city VALUES ('264', '520400', '安顺市', '520000');
INSERT INTO city VALUES ('265', '520500', '毕节市', '520000');
INSERT INTO city VALUES ('266', '520600', '铜仁市', '520000');
INSERT INTO city VALUES ('267', '522300', '黔西南布依族苗族自治州', '520000');
INSERT INTO city VALUES ('268', '522600', '黔东南苗族侗族自治州', '520000');
INSERT INTO city VALUES ('269', '522700', '黔南布依族苗族自治州', '520000');
INSERT INTO city VALUES ('270', '530100', '昆明市', '530000');
INSERT INTO city VALUES ('271', '530300', '曲靖市', '530000');
INSERT INTO city VALUES ('272', '530400', '玉溪市', '530000');
INSERT INTO city VALUES ('273', '530500', '保山市', '530000');
INSERT INTO city VALUES ('274', '530600', '昭通市', '530000');
INSERT INTO city VALUES ('275', '530700', '丽江市', '530000');
INSERT INTO city VALUES ('276', '530800', '普洱市', '530000');
INSERT INTO city VALUES ('277', '530900', '临沧市', '530000');
INSERT INTO city VALUES ('278', '532300', '楚雄彝族自治州', '530000');
INSERT INTO city VALUES ('279', '532500', '红河哈尼族彝族自治州', '530000');
INSERT INTO city VALUES ('280', '532600', '文山壮族苗族自治州', '530000');
INSERT INTO city VALUES ('281', '532800', '西双版纳傣族自治州', '530000');
INSERT INTO city VALUES ('282', '532900', '大理白族自治州', '530000');
INSERT INTO city VALUES ('283', '533100', '德宏傣族景颇族自治州', '530000');
INSERT INTO city VALUES ('284', '533300', '怒江傈僳族自治州', '530000');
INSERT INTO city VALUES ('285', '533400', '迪庆藏族自治州', '530000');
INSERT INTO city VALUES ('286', '540100', '拉萨市', '540000');
INSERT INTO city VALUES ('287', '540200', '日喀则市', '540000');
INSERT INTO city VALUES ('288', '540300', '昌都市', '540000');
INSERT INTO city VALUES ('289', '540400', '林芝市', '540000');
INSERT INTO city VALUES ('290', '540500', '山南市', '540000');
INSERT INTO city VALUES ('291', '542400', '那曲地区', '540000');
INSERT INTO city VALUES ('292', '542500', '阿里地区', '540000');
INSERT INTO city VALUES ('293', '610100', '西安市', '610000');
INSERT INTO city VALUES ('294', '610200', '铜川市', '610000');
INSERT INTO city VALUES ('295', '610300', '宝鸡市', '610000');
INSERT INTO city VALUES ('296', '610400', '咸阳市', '610000');
INSERT INTO city VALUES ('297', '610500', '渭南市', '610000');
INSERT INTO city VALUES ('298', '610600', '延安市', '610000');
INSERT INTO city VALUES ('299', '610700', '汉中市', '610000');
INSERT INTO city VALUES ('300', '610800', '榆林市', '610000');
INSERT INTO city VALUES ('301', '610900', '安康市', '610000');
INSERT INTO city VALUES ('302', '611000', '商洛市', '610000');
INSERT INTO city VALUES ('303', '620100', '兰州市', '620000');
INSERT INTO city VALUES ('304', '620200', '嘉峪关市', '620000');
INSERT INTO city VALUES ('305', '620300', '金昌市', '620000');
INSERT INTO city VALUES ('306', '620400', '白银市', '620000');
INSERT INTO city VALUES ('307', '620500', '天水市', '620000');
INSERT INTO city VALUES ('308', '620600', '武威市', '620000');
INSERT INTO city VALUES ('309', '620700', '张掖市', '620000');
INSERT INTO city VALUES ('310', '620800', '平凉市', '620000');
INSERT INTO city VALUES ('311', '620900', '酒泉市', '620000');
INSERT INTO city VALUES ('312', '621000', '庆阳市', '620000');
INSERT INTO city VALUES ('313', '621100', '定西市', '620000');
INSERT INTO city VALUES ('314', '621200', '陇南市', '620000');
INSERT INTO city VALUES ('315', '622900', '临夏回族自治州', '620000');
INSERT INTO city VALUES ('316', '623000', '甘南藏族自治州', '620000');
INSERT INTO city VALUES ('317', '630100', '西宁市', '630000');
INSERT INTO city VALUES ('318', '630200', '海东市', '630000');
INSERT INTO city VALUES ('319', '632200', '海北藏族自治州', '630000');
INSERT INTO city VALUES ('320', '632300', '黄南藏族自治州', '630000');
INSERT INTO city VALUES ('321', '632500', '海南藏族自治州', '630000');
INSERT INTO city VALUES ('322', '632600', '果洛藏族自治州', '630000');
INSERT INTO city VALUES ('323', '632700', '玉树藏族自治州', '630000');
INSERT INTO city VALUES ('324', '632800', '海西蒙古族藏族自治州', '630000');
INSERT INTO city VALUES ('325', '640100', '银川市', '640000');
INSERT INTO city VALUES ('326', '640200', '石嘴山市', '640000');
INSERT INTO city VALUES ('327', '640300', '吴忠市', '640000');
INSERT INTO city VALUES ('328', '640400', '固原市', '640000');
INSERT INTO city VALUES ('329', '640500', '中卫市', '640000');
INSERT INTO city VALUES ('330', '650100', '乌鲁木齐市', '650000');
INSERT INTO city VALUES ('331', '650200', '克拉玛依市', '650000');
INSERT INTO city VALUES ('332', '650400', '吐鲁番市', '650000');
INSERT INTO city VALUES ('333', '650500', '哈密市', '650000');
INSERT INTO city VALUES ('334', '652300', '昌吉回族自治州', '650000');
INSERT INTO city VALUES ('335', '652700', '博尔塔拉蒙古自治州', '650000');
INSERT INTO city VALUES ('336', '652800', '巴音郭楞蒙古自治州', '650000');
INSERT INTO city VALUES ('337', '652900', '阿克苏地区', '650000');
INSERT INTO city VALUES ('338', '653000', '克孜勒苏柯尔克孜自治州', '650000');
INSERT INTO city VALUES ('339', '653100', '喀什地区', '650000');
INSERT INTO city VALUES ('340', '653200', '和田地区', '650000');
INSERT INTO city VALUES ('341', '654000', '伊犁哈萨克自治州', '650000');
INSERT INTO city VALUES ('342', '654200', '塔城地区', '650000');
INSERT INTO city VALUES ('343', '654300', '阿勒泰地区', '650000');
INSERT INTO city VALUES ('344', '659000', '自治区直辖县级行政区划', '650000');