-
Notifications
You must be signed in to change notification settings - Fork 7
/
Copy patharea.sql
3312 lines (3306 loc) · 184 KB
/
area.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
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
Navicat MySQL Data Transfer
Source Server : MySQL
Source Server Version : 50505
Source Host : localhost:3306
Source Database : bpadmin
Target Server Type : MYSQL
Target Server Version : 50505
File Encoding : 65001
Date: 2016-03-24 13:30:48
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL COMMENT '区域名称',
`pid` int(11) NOT NULL COMMENT '父级ID',
PRIMARY KEY (`id`),
KEY `index_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=3281 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('1', '北京', '0');
INSERT INTO `area` VALUES ('2', '北京市', '1');
INSERT INTO `area` VALUES ('3', '东城区', '2');
INSERT INTO `area` VALUES ('4', '西城区', '2');
INSERT INTO `area` VALUES ('5', '崇文区', '2');
INSERT INTO `area` VALUES ('6', '宣武区', '2');
INSERT INTO `area` VALUES ('7', '朝阳区', '2');
INSERT INTO `area` VALUES ('8', '丰台区', '2');
INSERT INTO `area` VALUES ('9', '石景山区', '2');
INSERT INTO `area` VALUES ('10', '海淀区', '2');
INSERT INTO `area` VALUES ('11', '门头沟区', '2');
INSERT INTO `area` VALUES ('12', '房山区', '2');
INSERT INTO `area` VALUES ('13', '通州区', '2');
INSERT INTO `area` VALUES ('14', '顺义区', '2');
INSERT INTO `area` VALUES ('15', '昌平区', '2');
INSERT INTO `area` VALUES ('16', '大兴区', '2');
INSERT INTO `area` VALUES ('17', '怀柔区', '2');
INSERT INTO `area` VALUES ('18', '平谷区', '2');
INSERT INTO `area` VALUES ('19', '密云县', '2');
INSERT INTO `area` VALUES ('20', '延庆县', '2');
INSERT INTO `area` VALUES ('21', '上海', '0');
INSERT INTO `area` VALUES ('22', '上海市', '21');
INSERT INTO `area` VALUES ('23', '黄浦区', '22');
INSERT INTO `area` VALUES ('24', '卢湾区', '22');
INSERT INTO `area` VALUES ('25', '徐汇区', '22');
INSERT INTO `area` VALUES ('26', '长宁区', '22');
INSERT INTO `area` VALUES ('27', '静安区', '22');
INSERT INTO `area` VALUES ('28', '普陀区', '22');
INSERT INTO `area` VALUES ('29', '闸北区', '22');
INSERT INTO `area` VALUES ('30', '虹口区', '22');
INSERT INTO `area` VALUES ('31', '杨浦区', '22');
INSERT INTO `area` VALUES ('32', '闵行区', '22');
INSERT INTO `area` VALUES ('33', '宝山区', '22');
INSERT INTO `area` VALUES ('34', '嘉定区', '22');
INSERT INTO `area` VALUES ('35', '浦东新区', '22');
INSERT INTO `area` VALUES ('36', '金山区', '22');
INSERT INTO `area` VALUES ('37', '松江区', '22');
INSERT INTO `area` VALUES ('38', '青浦区', '22');
INSERT INTO `area` VALUES ('39', '南汇区', '22');
INSERT INTO `area` VALUES ('40', '奉贤区', '22');
INSERT INTO `area` VALUES ('41', '崇明县', '22');
INSERT INTO `area` VALUES ('42', '天津', '0');
INSERT INTO `area` VALUES ('43', '天津市', '42');
INSERT INTO `area` VALUES ('44', '和平区', '43');
INSERT INTO `area` VALUES ('45', '河东区', '43');
INSERT INTO `area` VALUES ('46', '河西区', '43');
INSERT INTO `area` VALUES ('47', '南开区', '43');
INSERT INTO `area` VALUES ('48', '河北区', '43');
INSERT INTO `area` VALUES ('49', '红桥区', '43');
INSERT INTO `area` VALUES ('50', '塘沽区', '43');
INSERT INTO `area` VALUES ('51', '汉沽区', '43');
INSERT INTO `area` VALUES ('52', '大港区', '43');
INSERT INTO `area` VALUES ('53', '东丽区', '43');
INSERT INTO `area` VALUES ('54', '西青区', '43');
INSERT INTO `area` VALUES ('55', '津南区', '43');
INSERT INTO `area` VALUES ('56', '北辰区', '43');
INSERT INTO `area` VALUES ('57', '武清区', '43');
INSERT INTO `area` VALUES ('58', '宝坻区', '43');
INSERT INTO `area` VALUES ('59', '宁河县', '43');
INSERT INTO `area` VALUES ('60', '静海县', '43');
INSERT INTO `area` VALUES ('61', '蓟县', '43');
INSERT INTO `area` VALUES ('62', '重庆', '0');
INSERT INTO `area` VALUES ('63', '重庆市', '62');
INSERT INTO `area` VALUES ('64', '万州区', '63');
INSERT INTO `area` VALUES ('65', '涪陵区', '63');
INSERT INTO `area` VALUES ('66', '渝中区', '63');
INSERT INTO `area` VALUES ('67', '大渡口区', '63');
INSERT INTO `area` VALUES ('68', '江北区', '63');
INSERT INTO `area` VALUES ('69', '沙坪坝区', '63');
INSERT INTO `area` VALUES ('70', '九龙坡区', '63');
INSERT INTO `area` VALUES ('71', '南岸区', '63');
INSERT INTO `area` VALUES ('72', '北碚区', '63');
INSERT INTO `area` VALUES ('73', '万盛区', '63');
INSERT INTO `area` VALUES ('74', '双桥区', '63');
INSERT INTO `area` VALUES ('75', '渝北区', '63');
INSERT INTO `area` VALUES ('76', '巴南区', '63');
INSERT INTO `area` VALUES ('77', '黔江区', '63');
INSERT INTO `area` VALUES ('78', '长寿区', '63');
INSERT INTO `area` VALUES ('79', '綦江县', '63');
INSERT INTO `area` VALUES ('80', '潼南县', '63');
INSERT INTO `area` VALUES ('81', '铜梁县', '63');
INSERT INTO `area` VALUES ('82', '大足县', '63');
INSERT INTO `area` VALUES ('83', '荣昌县', '63');
INSERT INTO `area` VALUES ('84', '璧山县', '63');
INSERT INTO `area` VALUES ('85', '梁平县', '63');
INSERT INTO `area` VALUES ('86', '城口县', '63');
INSERT INTO `area` VALUES ('87', '丰都县', '63');
INSERT INTO `area` VALUES ('88', '垫江县', '63');
INSERT INTO `area` VALUES ('89', '武隆县', '63');
INSERT INTO `area` VALUES ('90', '忠县', '63');
INSERT INTO `area` VALUES ('91', '开县', '63');
INSERT INTO `area` VALUES ('92', '云阳县', '63');
INSERT INTO `area` VALUES ('93', '奉节县', '63');
INSERT INTO `area` VALUES ('94', '巫山县', '63');
INSERT INTO `area` VALUES ('95', '巫溪县', '63');
INSERT INTO `area` VALUES ('96', '石柱土家族自治县', '63');
INSERT INTO `area` VALUES ('97', '秀山土家族苗族自治县', '63');
INSERT INTO `area` VALUES ('98', '酉阳土家族苗族自治县', '63');
INSERT INTO `area` VALUES ('99', '彭水苗族土家族自治县', '63');
INSERT INTO `area` VALUES ('100', '江津市', '63');
INSERT INTO `area` VALUES ('101', '合川市', '63');
INSERT INTO `area` VALUES ('102', '永川市', '63');
INSERT INTO `area` VALUES ('103', '南川市', '63');
INSERT INTO `area` VALUES ('104', '安徽', '0');
INSERT INTO `area` VALUES ('105', '合肥市', '104');
INSERT INTO `area` VALUES ('106', '瑶海区', '105');
INSERT INTO `area` VALUES ('107', '庐阳区', '105');
INSERT INTO `area` VALUES ('108', '蜀山区', '105');
INSERT INTO `area` VALUES ('109', '包河区', '105');
INSERT INTO `area` VALUES ('110', '长丰县', '105');
INSERT INTO `area` VALUES ('111', '肥东县', '105');
INSERT INTO `area` VALUES ('112', '肥西县', '105');
INSERT INTO `area` VALUES ('113', '安庆市', '104');
INSERT INTO `area` VALUES ('114', '迎江区', '113');
INSERT INTO `area` VALUES ('115', '大观区', '113');
INSERT INTO `area` VALUES ('116', '郊区', '113');
INSERT INTO `area` VALUES ('117', '怀宁县', '113');
INSERT INTO `area` VALUES ('118', '枞阳县', '113');
INSERT INTO `area` VALUES ('119', '潜山县', '113');
INSERT INTO `area` VALUES ('120', '太湖县', '113');
INSERT INTO `area` VALUES ('121', '宿松县', '113');
INSERT INTO `area` VALUES ('122', '望江县', '113');
INSERT INTO `area` VALUES ('123', '岳西县', '113');
INSERT INTO `area` VALUES ('124', '桐城市', '113');
INSERT INTO `area` VALUES ('125', '蚌埠市', '104');
INSERT INTO `area` VALUES ('126', '龙子湖区', '125');
INSERT INTO `area` VALUES ('127', '蚌山区', '125');
INSERT INTO `area` VALUES ('128', '禹会区', '125');
INSERT INTO `area` VALUES ('129', '淮上区', '125');
INSERT INTO `area` VALUES ('130', '怀远县', '125');
INSERT INTO `area` VALUES ('131', '五河县', '125');
INSERT INTO `area` VALUES ('132', '固镇县', '125');
INSERT INTO `area` VALUES ('133', '亳州市', '104');
INSERT INTO `area` VALUES ('134', '谯城区', '133');
INSERT INTO `area` VALUES ('135', '涡阳县', '133');
INSERT INTO `area` VALUES ('136', '蒙城县', '133');
INSERT INTO `area` VALUES ('137', '利辛县', '133');
INSERT INTO `area` VALUES ('138', '巢湖市', '104');
INSERT INTO `area` VALUES ('139', '居巢区', '138');
INSERT INTO `area` VALUES ('140', '庐江县', '138');
INSERT INTO `area` VALUES ('141', '无为县', '138');
INSERT INTO `area` VALUES ('142', '含山县', '138');
INSERT INTO `area` VALUES ('143', '和县', '138');
INSERT INTO `area` VALUES ('144', '池州市', '104');
INSERT INTO `area` VALUES ('145', '贵池区', '144');
INSERT INTO `area` VALUES ('146', '东至县', '144');
INSERT INTO `area` VALUES ('147', '石台县', '144');
INSERT INTO `area` VALUES ('148', '青阳县', '144');
INSERT INTO `area` VALUES ('149', '滁州市', '104');
INSERT INTO `area` VALUES ('150', '琅琊区', '149');
INSERT INTO `area` VALUES ('151', '南谯区', '149');
INSERT INTO `area` VALUES ('152', '来安县', '149');
INSERT INTO `area` VALUES ('153', '全椒县', '149');
INSERT INTO `area` VALUES ('154', '定远县', '149');
INSERT INTO `area` VALUES ('155', '凤阳县', '149');
INSERT INTO `area` VALUES ('156', '天长市', '149');
INSERT INTO `area` VALUES ('157', '明光市', '149');
INSERT INTO `area` VALUES ('158', '阜阳市', '104');
INSERT INTO `area` VALUES ('159', '颍州区', '158');
INSERT INTO `area` VALUES ('160', '颍东区', '158');
INSERT INTO `area` VALUES ('161', '颍泉区', '158');
INSERT INTO `area` VALUES ('162', '临泉县', '158');
INSERT INTO `area` VALUES ('163', '太和县', '158');
INSERT INTO `area` VALUES ('164', '阜南县', '158');
INSERT INTO `area` VALUES ('165', '颍上县', '158');
INSERT INTO `area` VALUES ('166', '界首市', '158');
INSERT INTO `area` VALUES ('167', '淮北市', '104');
INSERT INTO `area` VALUES ('168', '杜集区', '167');
INSERT INTO `area` VALUES ('169', '相山区', '167');
INSERT INTO `area` VALUES ('170', '烈山区', '167');
INSERT INTO `area` VALUES ('171', '濉溪县', '167');
INSERT INTO `area` VALUES ('172', '淮南市', '104');
INSERT INTO `area` VALUES ('173', '大通区', '172');
INSERT INTO `area` VALUES ('174', '田家庵区', '172');
INSERT INTO `area` VALUES ('175', '谢家集区', '172');
INSERT INTO `area` VALUES ('176', '八公山区', '172');
INSERT INTO `area` VALUES ('177', '潘集区', '172');
INSERT INTO `area` VALUES ('178', '凤台县', '172');
INSERT INTO `area` VALUES ('179', '黄山市', '104');
INSERT INTO `area` VALUES ('180', '屯溪区', '179');
INSERT INTO `area` VALUES ('181', '黄山区', '179');
INSERT INTO `area` VALUES ('182', '徽州区', '179');
INSERT INTO `area` VALUES ('183', '歙县', '179');
INSERT INTO `area` VALUES ('184', '休宁县', '179');
INSERT INTO `area` VALUES ('185', '黟县', '179');
INSERT INTO `area` VALUES ('186', '祁门县', '179');
INSERT INTO `area` VALUES ('187', '六安市', '104');
INSERT INTO `area` VALUES ('188', '金安区', '187');
INSERT INTO `area` VALUES ('189', '裕安区', '187');
INSERT INTO `area` VALUES ('190', '寿县', '187');
INSERT INTO `area` VALUES ('191', '霍邱县', '187');
INSERT INTO `area` VALUES ('192', '舒城县', '187');
INSERT INTO `area` VALUES ('193', '金寨县', '187');
INSERT INTO `area` VALUES ('194', '霍山县', '187');
INSERT INTO `area` VALUES ('195', '马鞍山市', '104');
INSERT INTO `area` VALUES ('196', '金家庄区', '195');
INSERT INTO `area` VALUES ('197', '花山区', '195');
INSERT INTO `area` VALUES ('198', '雨山区', '195');
INSERT INTO `area` VALUES ('199', '当涂县', '195');
INSERT INTO `area` VALUES ('200', '宿州市', '104');
INSERT INTO `area` VALUES ('201', '墉桥区', '200');
INSERT INTO `area` VALUES ('202', '砀山县', '200');
INSERT INTO `area` VALUES ('203', '萧县', '200');
INSERT INTO `area` VALUES ('204', '灵璧县', '200');
INSERT INTO `area` VALUES ('205', '泗县', '200');
INSERT INTO `area` VALUES ('206', '铜陵市', '104');
INSERT INTO `area` VALUES ('207', '铜官山区', '206');
INSERT INTO `area` VALUES ('208', '狮子山区', '206');
INSERT INTO `area` VALUES ('209', '郊区', '206');
INSERT INTO `area` VALUES ('210', '铜陵县', '206');
INSERT INTO `area` VALUES ('211', '芜湖市', '104');
INSERT INTO `area` VALUES ('212', '镜湖区', '211');
INSERT INTO `area` VALUES ('213', '马塘区', '211');
INSERT INTO `area` VALUES ('214', '新芜区', '211');
INSERT INTO `area` VALUES ('215', '鸠江区', '211');
INSERT INTO `area` VALUES ('216', '芜湖县', '211');
INSERT INTO `area` VALUES ('217', '繁昌县', '211');
INSERT INTO `area` VALUES ('218', '南陵县', '211');
INSERT INTO `area` VALUES ('219', '宣城市', '104');
INSERT INTO `area` VALUES ('220', '宣州区', '219');
INSERT INTO `area` VALUES ('221', '郎溪县', '219');
INSERT INTO `area` VALUES ('222', '广德县', '219');
INSERT INTO `area` VALUES ('223', '泾县', '219');
INSERT INTO `area` VALUES ('224', '绩溪县', '219');
INSERT INTO `area` VALUES ('225', '旌德县', '219');
INSERT INTO `area` VALUES ('226', '宁国市', '219');
INSERT INTO `area` VALUES ('227', '福建', '0');
INSERT INTO `area` VALUES ('228', '福州市', '227');
INSERT INTO `area` VALUES ('229', '鼓楼区', '228');
INSERT INTO `area` VALUES ('230', '台江区', '228');
INSERT INTO `area` VALUES ('231', '仓山区', '228');
INSERT INTO `area` VALUES ('232', '马尾区', '228');
INSERT INTO `area` VALUES ('233', '晋安区', '228');
INSERT INTO `area` VALUES ('234', '闽侯县', '228');
INSERT INTO `area` VALUES ('235', '连江县', '228');
INSERT INTO `area` VALUES ('236', '罗源县', '228');
INSERT INTO `area` VALUES ('237', '闽清县', '228');
INSERT INTO `area` VALUES ('238', '永泰县', '228');
INSERT INTO `area` VALUES ('239', '平潭县', '228');
INSERT INTO `area` VALUES ('240', '福清市', '228');
INSERT INTO `area` VALUES ('241', '长乐市', '228');
INSERT INTO `area` VALUES ('242', '龙岩市', '227');
INSERT INTO `area` VALUES ('243', '新罗区', '242');
INSERT INTO `area` VALUES ('244', '长汀县', '242');
INSERT INTO `area` VALUES ('245', '永定县', '242');
INSERT INTO `area` VALUES ('246', '上杭县', '242');
INSERT INTO `area` VALUES ('247', '武平县', '242');
INSERT INTO `area` VALUES ('248', '连城县', '242');
INSERT INTO `area` VALUES ('249', '漳平市', '242');
INSERT INTO `area` VALUES ('250', '南平市', '227');
INSERT INTO `area` VALUES ('251', '延平区', '250');
INSERT INTO `area` VALUES ('252', '顺昌县', '250');
INSERT INTO `area` VALUES ('253', '浦城县', '250');
INSERT INTO `area` VALUES ('254', '光泽县', '250');
INSERT INTO `area` VALUES ('255', '松溪县', '250');
INSERT INTO `area` VALUES ('256', '政和县', '250');
INSERT INTO `area` VALUES ('257', '邵武市', '250');
INSERT INTO `area` VALUES ('258', '武夷山市', '250');
INSERT INTO `area` VALUES ('259', '建瓯市', '250');
INSERT INTO `area` VALUES ('260', '建阳市', '250');
INSERT INTO `area` VALUES ('261', '宁德市', '227');
INSERT INTO `area` VALUES ('262', '蕉城区', '261');
INSERT INTO `area` VALUES ('263', '霞浦县', '261');
INSERT INTO `area` VALUES ('264', '古田县', '261');
INSERT INTO `area` VALUES ('265', '屏南县', '261');
INSERT INTO `area` VALUES ('266', '寿宁县', '261');
INSERT INTO `area` VALUES ('267', '周宁县', '261');
INSERT INTO `area` VALUES ('268', '柘荣县', '261');
INSERT INTO `area` VALUES ('269', '福安市', '261');
INSERT INTO `area` VALUES ('270', '福鼎市', '261');
INSERT INTO `area` VALUES ('271', '莆田市', '227');
INSERT INTO `area` VALUES ('272', '城厢区', '271');
INSERT INTO `area` VALUES ('273', '涵江区', '271');
INSERT INTO `area` VALUES ('274', '荔城区', '271');
INSERT INTO `area` VALUES ('275', '秀屿区', '271');
INSERT INTO `area` VALUES ('276', '仙游县', '271');
INSERT INTO `area` VALUES ('277', '泉州市', '227');
INSERT INTO `area` VALUES ('278', '鲤城区', '277');
INSERT INTO `area` VALUES ('279', '丰泽区', '277');
INSERT INTO `area` VALUES ('280', '洛江区', '277');
INSERT INTO `area` VALUES ('281', '泉港区', '277');
INSERT INTO `area` VALUES ('282', '惠安县', '277');
INSERT INTO `area` VALUES ('283', '安溪县', '277');
INSERT INTO `area` VALUES ('284', '永春县', '277');
INSERT INTO `area` VALUES ('285', '德化县', '277');
INSERT INTO `area` VALUES ('286', '金门县', '277');
INSERT INTO `area` VALUES ('287', '石狮市', '277');
INSERT INTO `area` VALUES ('288', '晋江市', '277');
INSERT INTO `area` VALUES ('289', '南安市', '277');
INSERT INTO `area` VALUES ('290', '三明市', '227');
INSERT INTO `area` VALUES ('291', '梅列区', '290');
INSERT INTO `area` VALUES ('292', '三元区', '290');
INSERT INTO `area` VALUES ('293', '明溪县', '290');
INSERT INTO `area` VALUES ('294', '清流县', '290');
INSERT INTO `area` VALUES ('295', '宁化县', '290');
INSERT INTO `area` VALUES ('296', '大田县', '290');
INSERT INTO `area` VALUES ('297', '尤溪县', '290');
INSERT INTO `area` VALUES ('298', '沙县', '290');
INSERT INTO `area` VALUES ('299', '将乐县', '290');
INSERT INTO `area` VALUES ('300', '泰宁县', '290');
INSERT INTO `area` VALUES ('301', '建宁县', '290');
INSERT INTO `area` VALUES ('302', '永安市', '290');
INSERT INTO `area` VALUES ('303', '厦门市', '227');
INSERT INTO `area` VALUES ('304', '思明区', '303');
INSERT INTO `area` VALUES ('305', '海沧区', '303');
INSERT INTO `area` VALUES ('306', '湖里区', '303');
INSERT INTO `area` VALUES ('307', '集美区', '303');
INSERT INTO `area` VALUES ('308', '同安区', '303');
INSERT INTO `area` VALUES ('309', '翔安区', '303');
INSERT INTO `area` VALUES ('310', '漳州市', '227');
INSERT INTO `area` VALUES ('311', '芗城区', '310');
INSERT INTO `area` VALUES ('312', '龙文区', '310');
INSERT INTO `area` VALUES ('313', '云霄县', '310');
INSERT INTO `area` VALUES ('314', '漳浦县', '310');
INSERT INTO `area` VALUES ('315', '诏安县', '310');
INSERT INTO `area` VALUES ('316', '长泰县', '310');
INSERT INTO `area` VALUES ('317', '东山县', '310');
INSERT INTO `area` VALUES ('318', '南靖县', '310');
INSERT INTO `area` VALUES ('319', '平和县', '310');
INSERT INTO `area` VALUES ('320', '华安县', '310');
INSERT INTO `area` VALUES ('321', '龙海市', '310');
INSERT INTO `area` VALUES ('322', '甘肃', '0');
INSERT INTO `area` VALUES ('323', '兰州市', '322');
INSERT INTO `area` VALUES ('324', '城关区', '323');
INSERT INTO `area` VALUES ('325', '七里河区', '323');
INSERT INTO `area` VALUES ('326', '西固区', '323');
INSERT INTO `area` VALUES ('327', '安宁区', '323');
INSERT INTO `area` VALUES ('328', '红古区', '323');
INSERT INTO `area` VALUES ('329', '永登县', '323');
INSERT INTO `area` VALUES ('330', '皋兰县', '323');
INSERT INTO `area` VALUES ('331', '榆中县', '323');
INSERT INTO `area` VALUES ('332', '白银市', '322');
INSERT INTO `area` VALUES ('333', '白银区', '332');
INSERT INTO `area` VALUES ('334', '平川区', '332');
INSERT INTO `area` VALUES ('335', '靖远县', '332');
INSERT INTO `area` VALUES ('336', '会宁县', '332');
INSERT INTO `area` VALUES ('337', '景泰县', '332');
INSERT INTO `area` VALUES ('338', '定西市', '322');
INSERT INTO `area` VALUES ('339', '安定区', '338');
INSERT INTO `area` VALUES ('340', '通渭县', '338');
INSERT INTO `area` VALUES ('341', '陇西县', '338');
INSERT INTO `area` VALUES ('342', '渭源县', '338');
INSERT INTO `area` VALUES ('343', '临洮县', '338');
INSERT INTO `area` VALUES ('344', '漳县', '338');
INSERT INTO `area` VALUES ('345', '岷县', '338');
INSERT INTO `area` VALUES ('346', '甘南藏族自治州', '322');
INSERT INTO `area` VALUES ('347', '合作市', '346');
INSERT INTO `area` VALUES ('348', '临潭县', '346');
INSERT INTO `area` VALUES ('349', '卓尼县', '346');
INSERT INTO `area` VALUES ('350', '舟曲县', '346');
INSERT INTO `area` VALUES ('351', '迭部县', '346');
INSERT INTO `area` VALUES ('352', '玛曲县', '346');
INSERT INTO `area` VALUES ('353', '碌曲县', '346');
INSERT INTO `area` VALUES ('354', '夏河县', '346');
INSERT INTO `area` VALUES ('355', '嘉峪关市', '322');
INSERT INTO `area` VALUES ('356', '金昌市', '322');
INSERT INTO `area` VALUES ('357', '金川区', '356');
INSERT INTO `area` VALUES ('358', '永昌县', '356');
INSERT INTO `area` VALUES ('359', '酒泉市', '322');
INSERT INTO `area` VALUES ('360', '肃州区', '359');
INSERT INTO `area` VALUES ('361', '金塔县', '359');
INSERT INTO `area` VALUES ('362', '安西县', '359');
INSERT INTO `area` VALUES ('363', '肃北蒙古族自治县', '359');
INSERT INTO `area` VALUES ('364', '阿克塞哈萨克族自治县', '359');
INSERT INTO `area` VALUES ('365', '玉门市', '359');
INSERT INTO `area` VALUES ('366', '敦煌市', '359');
INSERT INTO `area` VALUES ('367', '临夏回族自治州', '322');
INSERT INTO `area` VALUES ('368', '临夏市', '367');
INSERT INTO `area` VALUES ('369', '临夏县', '367');
INSERT INTO `area` VALUES ('370', '康乐县', '367');
INSERT INTO `area` VALUES ('371', '永靖县', '367');
INSERT INTO `area` VALUES ('372', '广河县', '367');
INSERT INTO `area` VALUES ('373', '和政县', '367');
INSERT INTO `area` VALUES ('374', '东乡族自治县', '367');
INSERT INTO `area` VALUES ('375', '积石山保安族东乡族撒拉族自治县', '367');
INSERT INTO `area` VALUES ('376', '陇南市', '322');
INSERT INTO `area` VALUES ('377', '武都区', '376');
INSERT INTO `area` VALUES ('378', '成县', '376');
INSERT INTO `area` VALUES ('379', '文县', '376');
INSERT INTO `area` VALUES ('380', '宕昌县', '376');
INSERT INTO `area` VALUES ('381', '康县', '376');
INSERT INTO `area` VALUES ('382', '西和县', '376');
INSERT INTO `area` VALUES ('383', '礼县', '376');
INSERT INTO `area` VALUES ('384', '徽县', '376');
INSERT INTO `area` VALUES ('385', '两当县', '376');
INSERT INTO `area` VALUES ('386', '平凉市', '322');
INSERT INTO `area` VALUES ('387', '崆峒区', '386');
INSERT INTO `area` VALUES ('388', '泾川县', '386');
INSERT INTO `area` VALUES ('389', '灵台县', '386');
INSERT INTO `area` VALUES ('390', '崇信县', '386');
INSERT INTO `area` VALUES ('391', '华亭县', '386');
INSERT INTO `area` VALUES ('392', '庄浪县', '386');
INSERT INTO `area` VALUES ('393', '静宁县', '386');
INSERT INTO `area` VALUES ('394', '庆阳市', '322');
INSERT INTO `area` VALUES ('395', '西峰区', '394');
INSERT INTO `area` VALUES ('396', '庆城县', '394');
INSERT INTO `area` VALUES ('397', '环县', '394');
INSERT INTO `area` VALUES ('398', '华池县', '394');
INSERT INTO `area` VALUES ('399', '合水县', '394');
INSERT INTO `area` VALUES ('400', '正宁县', '394');
INSERT INTO `area` VALUES ('401', '宁县', '394');
INSERT INTO `area` VALUES ('402', '镇原县', '394');
INSERT INTO `area` VALUES ('403', '天水市', '322');
INSERT INTO `area` VALUES ('404', '秦城区', '403');
INSERT INTO `area` VALUES ('405', '北道区', '403');
INSERT INTO `area` VALUES ('406', '清水县', '403');
INSERT INTO `area` VALUES ('407', '秦安县', '403');
INSERT INTO `area` VALUES ('408', '甘谷县', '403');
INSERT INTO `area` VALUES ('409', '武山县', '403');
INSERT INTO `area` VALUES ('410', '张家川回族自治县', '403');
INSERT INTO `area` VALUES ('411', '武威市', '322');
INSERT INTO `area` VALUES ('412', '凉州区', '411');
INSERT INTO `area` VALUES ('413', '民勤县', '411');
INSERT INTO `area` VALUES ('414', '古浪县', '411');
INSERT INTO `area` VALUES ('415', '天祝藏族自治县', '411');
INSERT INTO `area` VALUES ('416', '张掖市', '322');
INSERT INTO `area` VALUES ('417', '甘州区', '416');
INSERT INTO `area` VALUES ('418', '肃南裕固族自治县', '416');
INSERT INTO `area` VALUES ('419', '民乐县', '416');
INSERT INTO `area` VALUES ('420', '临泽县', '416');
INSERT INTO `area` VALUES ('421', '高台县', '416');
INSERT INTO `area` VALUES ('422', '山丹县', '416');
INSERT INTO `area` VALUES ('423', '广东', '0');
INSERT INTO `area` VALUES ('424', '广州市', '423');
INSERT INTO `area` VALUES ('425', '东山区', '424');
INSERT INTO `area` VALUES ('426', '荔湾区', '424');
INSERT INTO `area` VALUES ('427', '越秀区', '424');
INSERT INTO `area` VALUES ('428', '海珠区', '424');
INSERT INTO `area` VALUES ('429', '天河区', '424');
INSERT INTO `area` VALUES ('430', '芳村区', '424');
INSERT INTO `area` VALUES ('431', '白云区', '424');
INSERT INTO `area` VALUES ('432', '黄埔区', '424');
INSERT INTO `area` VALUES ('433', '番禺区', '424');
INSERT INTO `area` VALUES ('434', '花都区', '424');
INSERT INTO `area` VALUES ('435', '增城市', '424');
INSERT INTO `area` VALUES ('436', '从化市', '424');
INSERT INTO `area` VALUES ('437', '潮州市', '423');
INSERT INTO `area` VALUES ('438', '湘桥区', '437');
INSERT INTO `area` VALUES ('439', '潮安县', '437');
INSERT INTO `area` VALUES ('440', '饶平县', '437');
INSERT INTO `area` VALUES ('441', '东莞市', '423');
INSERT INTO `area` VALUES ('442', '佛山市', '423');
INSERT INTO `area` VALUES ('443', '禅城区', '442');
INSERT INTO `area` VALUES ('444', '南海区', '442');
INSERT INTO `area` VALUES ('445', '顺德区', '442');
INSERT INTO `area` VALUES ('446', '三水区', '442');
INSERT INTO `area` VALUES ('447', '高明区', '442');
INSERT INTO `area` VALUES ('448', '河源市', '423');
INSERT INTO `area` VALUES ('449', '源城区', '448');
INSERT INTO `area` VALUES ('450', '紫金县', '448');
INSERT INTO `area` VALUES ('451', '龙川县', '448');
INSERT INTO `area` VALUES ('452', '连平县', '448');
INSERT INTO `area` VALUES ('453', '和平县', '448');
INSERT INTO `area` VALUES ('454', '东源县', '448');
INSERT INTO `area` VALUES ('455', '惠州市', '423');
INSERT INTO `area` VALUES ('456', '惠城区', '455');
INSERT INTO `area` VALUES ('457', '惠阳区', '455');
INSERT INTO `area` VALUES ('458', '博罗县', '455');
INSERT INTO `area` VALUES ('459', '惠东县', '455');
INSERT INTO `area` VALUES ('460', '龙门县', '455');
INSERT INTO `area` VALUES ('461', '江门市', '423');
INSERT INTO `area` VALUES ('462', '蓬江区', '461');
INSERT INTO `area` VALUES ('463', '江海区', '461');
INSERT INTO `area` VALUES ('464', '新会区', '461');
INSERT INTO `area` VALUES ('465', '台山市', '461');
INSERT INTO `area` VALUES ('466', '开平市', '461');
INSERT INTO `area` VALUES ('467', '鹤山市', '461');
INSERT INTO `area` VALUES ('468', '恩平市', '461');
INSERT INTO `area` VALUES ('469', '揭阳市', '423');
INSERT INTO `area` VALUES ('470', '榕城区', '469');
INSERT INTO `area` VALUES ('471', '揭东县', '469');
INSERT INTO `area` VALUES ('472', '揭西县', '469');
INSERT INTO `area` VALUES ('473', '惠来县', '469');
INSERT INTO `area` VALUES ('474', '普宁市', '469');
INSERT INTO `area` VALUES ('475', '茂名市', '423');
INSERT INTO `area` VALUES ('476', '茂南区', '475');
INSERT INTO `area` VALUES ('477', '茂港区', '475');
INSERT INTO `area` VALUES ('478', '电白县', '475');
INSERT INTO `area` VALUES ('479', '高州市', '475');
INSERT INTO `area` VALUES ('480', '化州市', '475');
INSERT INTO `area` VALUES ('481', '信宜市', '475');
INSERT INTO `area` VALUES ('482', '梅江区', '423');
INSERT INTO `area` VALUES ('483', '梅州市', '423');
INSERT INTO `area` VALUES ('484', '梅县', '483');
INSERT INTO `area` VALUES ('485', '大埔县', '483');
INSERT INTO `area` VALUES ('486', '丰顺县', '483');
INSERT INTO `area` VALUES ('487', '五华县', '483');
INSERT INTO `area` VALUES ('488', '平远县', '483');
INSERT INTO `area` VALUES ('489', '蕉岭县', '483');
INSERT INTO `area` VALUES ('490', '兴宁市', '483');
INSERT INTO `area` VALUES ('491', '清远市', '423');
INSERT INTO `area` VALUES ('492', '清城区', '491');
INSERT INTO `area` VALUES ('493', '佛冈县', '491');
INSERT INTO `area` VALUES ('494', '阳山县', '491');
INSERT INTO `area` VALUES ('495', '连山壮族瑶族自治县', '491');
INSERT INTO `area` VALUES ('496', '连南瑶族自治县', '491');
INSERT INTO `area` VALUES ('497', '清新县', '491');
INSERT INTO `area` VALUES ('498', '英德市', '491');
INSERT INTO `area` VALUES ('499', '连州市', '491');
INSERT INTO `area` VALUES ('500', '汕头市', '423');
INSERT INTO `area` VALUES ('501', '龙湖区', '500');
INSERT INTO `area` VALUES ('502', '金平区', '500');
INSERT INTO `area` VALUES ('503', '濠江区', '500');
INSERT INTO `area` VALUES ('504', '潮阳区', '500');
INSERT INTO `area` VALUES ('505', '潮南区', '500');
INSERT INTO `area` VALUES ('506', '澄海区', '500');
INSERT INTO `area` VALUES ('507', '南澳县', '500');
INSERT INTO `area` VALUES ('508', '汕尾市', '423');
INSERT INTO `area` VALUES ('509', '城区', '508');
INSERT INTO `area` VALUES ('510', '海丰县', '508');
INSERT INTO `area` VALUES ('511', '陆河县', '508');
INSERT INTO `area` VALUES ('512', '陆丰市', '508');
INSERT INTO `area` VALUES ('513', '韶关市', '423');
INSERT INTO `area` VALUES ('514', '武江区', '513');
INSERT INTO `area` VALUES ('515', '浈江区', '513');
INSERT INTO `area` VALUES ('516', '曲江区', '513');
INSERT INTO `area` VALUES ('517', '始兴县', '513');
INSERT INTO `area` VALUES ('518', '仁化县', '513');
INSERT INTO `area` VALUES ('519', '翁源县', '513');
INSERT INTO `area` VALUES ('520', '乳源瑶族自治县', '513');
INSERT INTO `area` VALUES ('521', '新丰县', '513');
INSERT INTO `area` VALUES ('522', '乐昌市', '513');
INSERT INTO `area` VALUES ('523', '南雄市', '513');
INSERT INTO `area` VALUES ('524', '深圳市', '423');
INSERT INTO `area` VALUES ('525', '罗湖区', '524');
INSERT INTO `area` VALUES ('526', '福田区', '524');
INSERT INTO `area` VALUES ('527', '南山区', '524');
INSERT INTO `area` VALUES ('528', '宝安区', '524');
INSERT INTO `area` VALUES ('529', '龙岗区', '524');
INSERT INTO `area` VALUES ('530', '盐田区', '524');
INSERT INTO `area` VALUES ('531', '阳江市', '423');
INSERT INTO `area` VALUES ('532', '江城区', '531');
INSERT INTO `area` VALUES ('533', '阳西县', '531');
INSERT INTO `area` VALUES ('534', '阳东县', '531');
INSERT INTO `area` VALUES ('535', '阳春市', '531');
INSERT INTO `area` VALUES ('536', '云浮市', '423');
INSERT INTO `area` VALUES ('537', '云城区', '536');
INSERT INTO `area` VALUES ('538', '新兴县', '536');
INSERT INTO `area` VALUES ('539', '郁南县', '536');
INSERT INTO `area` VALUES ('540', '云安县', '536');
INSERT INTO `area` VALUES ('541', '罗定市', '536');
INSERT INTO `area` VALUES ('542', '湛江市', '423');
INSERT INTO `area` VALUES ('543', '赤坎区', '542');
INSERT INTO `area` VALUES ('544', '霞山区', '542');
INSERT INTO `area` VALUES ('545', '坡头区', '542');
INSERT INTO `area` VALUES ('546', '麻章区', '542');
INSERT INTO `area` VALUES ('547', '遂溪县', '542');
INSERT INTO `area` VALUES ('548', '徐闻县', '542');
INSERT INTO `area` VALUES ('549', '廉江市', '542');
INSERT INTO `area` VALUES ('550', '雷州市', '542');
INSERT INTO `area` VALUES ('551', '吴川市', '542');
INSERT INTO `area` VALUES ('552', '肇庆市', '423');
INSERT INTO `area` VALUES ('553', '端州区', '552');
INSERT INTO `area` VALUES ('554', '鼎湖区', '552');
INSERT INTO `area` VALUES ('555', '广宁县', '552');
INSERT INTO `area` VALUES ('556', '怀集县', '552');
INSERT INTO `area` VALUES ('557', '封开县', '552');
INSERT INTO `area` VALUES ('558', '德庆县', '552');
INSERT INTO `area` VALUES ('559', '高要市', '552');
INSERT INTO `area` VALUES ('560', '四会市', '552');
INSERT INTO `area` VALUES ('561', '中山市', '423');
INSERT INTO `area` VALUES ('562', '珠海市', '423');
INSERT INTO `area` VALUES ('563', '香洲区', '562');
INSERT INTO `area` VALUES ('564', '斗门区', '562');
INSERT INTO `area` VALUES ('565', '金湾区', '562');
INSERT INTO `area` VALUES ('566', '广西', '0');
INSERT INTO `area` VALUES ('567', '南宁市', '566');
INSERT INTO `area` VALUES ('568', '兴宁区', '567');
INSERT INTO `area` VALUES ('569', '青秀区', '567');
INSERT INTO `area` VALUES ('570', '江南区', '567');
INSERT INTO `area` VALUES ('571', '西乡塘区', '567');
INSERT INTO `area` VALUES ('572', '良庆区', '567');
INSERT INTO `area` VALUES ('573', '邕宁区', '567');
INSERT INTO `area` VALUES ('574', '武鸣县', '567');
INSERT INTO `area` VALUES ('575', '隆安县', '567');
INSERT INTO `area` VALUES ('576', '马山县', '567');
INSERT INTO `area` VALUES ('577', '上林县', '567');
INSERT INTO `area` VALUES ('578', '宾阳县', '567');
INSERT INTO `area` VALUES ('579', '横县', '567');
INSERT INTO `area` VALUES ('580', '百色市', '566');
INSERT INTO `area` VALUES ('581', '右江区', '580');
INSERT INTO `area` VALUES ('582', '田阳县', '580');
INSERT INTO `area` VALUES ('583', '田东县', '580');
INSERT INTO `area` VALUES ('584', '平果县', '580');
INSERT INTO `area` VALUES ('585', '德保县', '580');
INSERT INTO `area` VALUES ('586', '靖西县', '580');
INSERT INTO `area` VALUES ('587', '那坡县', '580');
INSERT INTO `area` VALUES ('588', '凌云县', '580');
INSERT INTO `area` VALUES ('589', '乐业县', '580');
INSERT INTO `area` VALUES ('590', '田林县', '580');
INSERT INTO `area` VALUES ('591', '西林县', '580');
INSERT INTO `area` VALUES ('592', '隆林各族自治县', '580');
INSERT INTO `area` VALUES ('593', '北海市', '566');
INSERT INTO `area` VALUES ('594', '海城区', '593');
INSERT INTO `area` VALUES ('595', '银海区', '593');
INSERT INTO `area` VALUES ('596', '铁山港区', '593');
INSERT INTO `area` VALUES ('597', '合浦县', '593');
INSERT INTO `area` VALUES ('598', '崇左市', '566');
INSERT INTO `area` VALUES ('599', '江洲区', '598');
INSERT INTO `area` VALUES ('600', '扶绥县', '598');
INSERT INTO `area` VALUES ('601', '宁明县', '598');
INSERT INTO `area` VALUES ('602', '龙州县', '598');
INSERT INTO `area` VALUES ('603', '大新县', '598');
INSERT INTO `area` VALUES ('604', '天等县', '598');
INSERT INTO `area` VALUES ('605', '凭祥市', '598');
INSERT INTO `area` VALUES ('606', '防城港市', '566');
INSERT INTO `area` VALUES ('607', '港口区', '606');
INSERT INTO `area` VALUES ('608', '防城区', '606');
INSERT INTO `area` VALUES ('609', '上思县', '606');
INSERT INTO `area` VALUES ('610', '东兴市', '606');
INSERT INTO `area` VALUES ('611', '贵港市', '566');
INSERT INTO `area` VALUES ('612', '港北区', '611');
INSERT INTO `area` VALUES ('613', '港南区', '611');
INSERT INTO `area` VALUES ('614', '覃塘区', '611');
INSERT INTO `area` VALUES ('615', '平南县', '611');
INSERT INTO `area` VALUES ('616', '桂平市', '611');
INSERT INTO `area` VALUES ('617', '桂林市', '566');
INSERT INTO `area` VALUES ('618', '秀峰区', '617');
INSERT INTO `area` VALUES ('619', '叠彩区', '617');
INSERT INTO `area` VALUES ('620', '象山区', '617');
INSERT INTO `area` VALUES ('621', '七星区', '617');
INSERT INTO `area` VALUES ('622', '雁山区', '617');
INSERT INTO `area` VALUES ('623', '阳朔县', '617');
INSERT INTO `area` VALUES ('624', '临桂县', '617');
INSERT INTO `area` VALUES ('625', '灵川县', '617');
INSERT INTO `area` VALUES ('626', '全州县', '617');
INSERT INTO `area` VALUES ('627', '兴安县', '617');
INSERT INTO `area` VALUES ('628', '永福县', '617');
INSERT INTO `area` VALUES ('629', '灌阳县', '617');
INSERT INTO `area` VALUES ('630', '龙胜各族自治县', '617');
INSERT INTO `area` VALUES ('631', '资源县', '617');
INSERT INTO `area` VALUES ('632', '平乐县', '617');
INSERT INTO `area` VALUES ('633', '荔蒲县', '617');
INSERT INTO `area` VALUES ('634', '恭城瑶族自治县', '617');
INSERT INTO `area` VALUES ('635', '河池市', '566');
INSERT INTO `area` VALUES ('636', '金城江区', '635');
INSERT INTO `area` VALUES ('637', '南丹县', '635');
INSERT INTO `area` VALUES ('638', '天峨县', '635');
INSERT INTO `area` VALUES ('639', '凤山县', '635');
INSERT INTO `area` VALUES ('640', '东兰县', '635');
INSERT INTO `area` VALUES ('641', '罗城仫佬族自治县', '635');
INSERT INTO `area` VALUES ('642', '环江毛南族自治县', '635');
INSERT INTO `area` VALUES ('643', '巴马瑶族自治县', '635');
INSERT INTO `area` VALUES ('644', '都安瑶族自治县', '635');
INSERT INTO `area` VALUES ('645', '大化瑶族自治县', '635');
INSERT INTO `area` VALUES ('646', '宜州市', '635');
INSERT INTO `area` VALUES ('647', '贺州市', '566');
INSERT INTO `area` VALUES ('648', '八步区', '647');
INSERT INTO `area` VALUES ('649', '昭平县', '647');
INSERT INTO `area` VALUES ('650', '钟山县', '647');
INSERT INTO `area` VALUES ('651', '富川瑶族自治县', '647');
INSERT INTO `area` VALUES ('652', '来宾市', '566');
INSERT INTO `area` VALUES ('653', '兴宾区', '652');
INSERT INTO `area` VALUES ('654', '忻城县', '652');
INSERT INTO `area` VALUES ('655', '象州县', '652');
INSERT INTO `area` VALUES ('656', '武宣县', '652');
INSERT INTO `area` VALUES ('657', '金秀瑶族自治县', '652');
INSERT INTO `area` VALUES ('658', '合山市', '652');
INSERT INTO `area` VALUES ('659', '柳州市', '566');
INSERT INTO `area` VALUES ('660', '城中区', '659');
INSERT INTO `area` VALUES ('661', '鱼峰区', '659');
INSERT INTO `area` VALUES ('662', '柳南区', '659');
INSERT INTO `area` VALUES ('663', '柳北区', '659');
INSERT INTO `area` VALUES ('664', '柳江县', '659');
INSERT INTO `area` VALUES ('665', '柳城县', '659');
INSERT INTO `area` VALUES ('666', '鹿寨县', '659');
INSERT INTO `area` VALUES ('667', '融安县', '659');
INSERT INTO `area` VALUES ('668', '融水苗族自治县', '659');
INSERT INTO `area` VALUES ('669', '三江侗族自治县', '659');
INSERT INTO `area` VALUES ('670', '钦州市', '566');
INSERT INTO `area` VALUES ('671', '钦南区', '670');
INSERT INTO `area` VALUES ('672', '钦北区', '670');
INSERT INTO `area` VALUES ('673', '灵山县', '670');
INSERT INTO `area` VALUES ('674', '浦北县', '670');
INSERT INTO `area` VALUES ('675', '梧州市', '566');
INSERT INTO `area` VALUES ('676', '万秀区', '675');
INSERT INTO `area` VALUES ('677', '蝶山区', '675');
INSERT INTO `area` VALUES ('678', '长洲区', '675');
INSERT INTO `area` VALUES ('679', '苍梧县', '675');
INSERT INTO `area` VALUES ('680', '藤县', '675');
INSERT INTO `area` VALUES ('681', '蒙山县', '675');
INSERT INTO `area` VALUES ('682', '岑溪市', '675');
INSERT INTO `area` VALUES ('683', '玉林市', '566');
INSERT INTO `area` VALUES ('684', '玉州区', '683');
INSERT INTO `area` VALUES ('685', '容县', '683');
INSERT INTO `area` VALUES ('686', '陆川县', '683');
INSERT INTO `area` VALUES ('687', '博白县', '683');
INSERT INTO `area` VALUES ('688', '兴业县', '683');
INSERT INTO `area` VALUES ('689', '北流市', '683');
INSERT INTO `area` VALUES ('690', '贵州', '0');
INSERT INTO `area` VALUES ('691', '贵阳市', '690');
INSERT INTO `area` VALUES ('692', '南明区', '691');
INSERT INTO `area` VALUES ('693', '云岩区', '691');
INSERT INTO `area` VALUES ('694', '花溪区', '691');
INSERT INTO `area` VALUES ('695', '乌当区', '691');
INSERT INTO `area` VALUES ('696', '白云区', '691');
INSERT INTO `area` VALUES ('697', '小河区', '691');
INSERT INTO `area` VALUES ('698', '开阳县', '691');
INSERT INTO `area` VALUES ('699', '息烽县', '691');
INSERT INTO `area` VALUES ('700', '修文县', '691');
INSERT INTO `area` VALUES ('701', '清镇市', '691');
INSERT INTO `area` VALUES ('702', '安顺市', '690');
INSERT INTO `area` VALUES ('703', '西秀区', '702');
INSERT INTO `area` VALUES ('704', '平坝县', '702');
INSERT INTO `area` VALUES ('705', '普定县', '702');
INSERT INTO `area` VALUES ('706', '镇宁布依族苗族自治县', '702');
INSERT INTO `area` VALUES ('707', '关岭布依族苗族自治县', '702');
INSERT INTO `area` VALUES ('708', '紫云苗族布依族自治县', '702');
INSERT INTO `area` VALUES ('709', '毕节地区', '690');
INSERT INTO `area` VALUES ('710', '毕节市', '709');
INSERT INTO `area` VALUES ('711', '大方县', '709');
INSERT INTO `area` VALUES ('712', '黔西县', '709');
INSERT INTO `area` VALUES ('713', '金沙县', '709');
INSERT INTO `area` VALUES ('714', '织金县', '709');
INSERT INTO `area` VALUES ('715', '纳雍县', '709');
INSERT INTO `area` VALUES ('716', '威宁彝族回族苗族自治县', '709');
INSERT INTO `area` VALUES ('717', '赫章县', '709');
INSERT INTO `area` VALUES ('718', '六盘水市', '690');
INSERT INTO `area` VALUES ('719', '钟山区', '718');
INSERT INTO `area` VALUES ('720', '六枝特区', '718');
INSERT INTO `area` VALUES ('721', '水城县', '718');
INSERT INTO `area` VALUES ('722', '盘县', '718');
INSERT INTO `area` VALUES ('723', '黔东南苗族侗族自治州', '690');
INSERT INTO `area` VALUES ('724', '凯里市', '723');
INSERT INTO `area` VALUES ('725', '黄平县', '723');
INSERT INTO `area` VALUES ('726', '施秉县', '723');
INSERT INTO `area` VALUES ('727', '三穗县', '723');
INSERT INTO `area` VALUES ('728', '镇远县', '723');
INSERT INTO `area` VALUES ('729', '岑巩县', '723');
INSERT INTO `area` VALUES ('730', '天柱县', '723');
INSERT INTO `area` VALUES ('731', '锦屏县', '723');
INSERT INTO `area` VALUES ('732', '剑河县', '723');
INSERT INTO `area` VALUES ('733', '台江县', '723');
INSERT INTO `area` VALUES ('734', '黎平县', '723');
INSERT INTO `area` VALUES ('735', '榕江县', '723');
INSERT INTO `area` VALUES ('736', '从江县', '723');
INSERT INTO `area` VALUES ('737', '雷山县', '723');
INSERT INTO `area` VALUES ('738', '麻江县', '723');
INSERT INTO `area` VALUES ('739', '丹寨县', '723');
INSERT INTO `area` VALUES ('740', '黔南布依族苗族自治州', '690');
INSERT INTO `area` VALUES ('741', '都匀市', '740');
INSERT INTO `area` VALUES ('742', '福泉市', '740');
INSERT INTO `area` VALUES ('743', '荔波县', '740');
INSERT INTO `area` VALUES ('744', '贵定县', '740');
INSERT INTO `area` VALUES ('745', '瓮安县', '740');
INSERT INTO `area` VALUES ('746', '独山县', '740');
INSERT INTO `area` VALUES ('747', '平塘县', '740');
INSERT INTO `area` VALUES ('748', '罗甸县', '740');
INSERT INTO `area` VALUES ('749', '长顺县', '740');
INSERT INTO `area` VALUES ('750', '龙里县', '740');
INSERT INTO `area` VALUES ('751', '惠水县', '740');
INSERT INTO `area` VALUES ('752', '三都水族自治县', '740');
INSERT INTO `area` VALUES ('753', '黔西南布依族苗族自治州', '690');
INSERT INTO `area` VALUES ('754', '兴义市', '753');
INSERT INTO `area` VALUES ('755', '兴仁县', '753');
INSERT INTO `area` VALUES ('756', '普安县', '753');
INSERT INTO `area` VALUES ('757', '晴隆县', '753');
INSERT INTO `area` VALUES ('758', '贞丰县', '753');
INSERT INTO `area` VALUES ('759', '望谟县', '753');
INSERT INTO `area` VALUES ('760', '册亨县', '753');
INSERT INTO `area` VALUES ('761', '安龙县', '753');
INSERT INTO `area` VALUES ('762', '铜仁地区', '690');
INSERT INTO `area` VALUES ('763', '铜仁市', '762');
INSERT INTO `area` VALUES ('764', '江口县', '762');
INSERT INTO `area` VALUES ('765', '玉屏侗族自治县', '762');
INSERT INTO `area` VALUES ('766', '石阡县', '762');
INSERT INTO `area` VALUES ('767', '思南县', '762');
INSERT INTO `area` VALUES ('768', '印江土家族苗族自治县', '762');
INSERT INTO `area` VALUES ('769', '德江县', '762');
INSERT INTO `area` VALUES ('770', '沿河土家族自治县', '762');
INSERT INTO `area` VALUES ('771', '松桃苗族自治县', '762');
INSERT INTO `area` VALUES ('772', '万山特区', '762');
INSERT INTO `area` VALUES ('773', '遵义市', '690');
INSERT INTO `area` VALUES ('774', '红花岗区', '773');
INSERT INTO `area` VALUES ('775', '汇川区', '773');
INSERT INTO `area` VALUES ('776', '遵义县', '773');
INSERT INTO `area` VALUES ('777', '桐梓县', '773');
INSERT INTO `area` VALUES ('778', '绥阳县', '773');
INSERT INTO `area` VALUES ('779', '正安县', '773');
INSERT INTO `area` VALUES ('780', '道真仡佬族苗族自治县', '773');
INSERT INTO `area` VALUES ('781', '务川仡佬族苗族自治县', '773');
INSERT INTO `area` VALUES ('782', '凤冈县', '773');
INSERT INTO `area` VALUES ('783', '湄潭县', '773');
INSERT INTO `area` VALUES ('784', '余庆县', '773');
INSERT INTO `area` VALUES ('785', '习水县', '773');
INSERT INTO `area` VALUES ('786', '赤水市', '773');
INSERT INTO `area` VALUES ('787', '仁怀市', '773');
INSERT INTO `area` VALUES ('788', '海南', '0');
INSERT INTO `area` VALUES ('789', '海口市', '788');
INSERT INTO `area` VALUES ('790', '秀英区', '789');
INSERT INTO `area` VALUES ('791', '龙华区', '789');
INSERT INTO `area` VALUES ('792', '琼山区', '789');
INSERT INTO `area` VALUES ('793', '美兰区', '789');
INSERT INTO `area` VALUES ('794', '白沙黎族自治县', '788');
INSERT INTO `area` VALUES ('795', '保亭黎族苗族自治县', '788');
INSERT INTO `area` VALUES ('796', '昌江黎族自治县', '788');
INSERT INTO `area` VALUES ('797', '澄迈县', '788');
INSERT INTO `area` VALUES ('798', '儋州市', '788');
INSERT INTO `area` VALUES ('799', '定安县', '788');
INSERT INTO `area` VALUES ('800', '东方市', '788');
INSERT INTO `area` VALUES ('801', '乐东黎族自治县', '788');
INSERT INTO `area` VALUES ('802', '临高县', '788');
INSERT INTO `area` VALUES ('803', '陵水黎族自治县', '788');
INSERT INTO `area` VALUES ('804', '南沙群岛', '788');
INSERT INTO `area` VALUES ('805', '琼海市', '788');
INSERT INTO `area` VALUES ('806', '琼中黎族苗族自治县', '788');
INSERT INTO `area` VALUES ('807', '三亚市', '788');
INSERT INTO `area` VALUES ('808', '屯昌县', '788');
INSERT INTO `area` VALUES ('809', '万宁市', '788');
INSERT INTO `area` VALUES ('810', '文昌市', '788');
INSERT INTO `area` VALUES ('811', '五指山市', '788');
INSERT INTO `area` VALUES ('812', '西沙群岛', '788');
INSERT INTO `area` VALUES ('813', '中沙群岛的岛礁及其海域', '788');
INSERT INTO `area` VALUES ('814', '河北', '0');
INSERT INTO `area` VALUES ('815', '石家庄市', '814');
INSERT INTO `area` VALUES ('816', '长安区', '815');
INSERT INTO `area` VALUES ('817', '桥东区', '815');
INSERT INTO `area` VALUES ('818', '桥西区', '815');
INSERT INTO `area` VALUES ('819', '新华区', '815');
INSERT INTO `area` VALUES ('820', '井陉矿区', '815');
INSERT INTO `area` VALUES ('821', '裕华区', '815');
INSERT INTO `area` VALUES ('822', '井陉县', '815');
INSERT INTO `area` VALUES ('823', '正定县', '815');
INSERT INTO `area` VALUES ('824', '栾城县', '815');
INSERT INTO `area` VALUES ('825', '行唐县', '815');
INSERT INTO `area` VALUES ('826', '灵寿县', '815');
INSERT INTO `area` VALUES ('827', '高邑县', '815');
INSERT INTO `area` VALUES ('828', '深泽县', '815');
INSERT INTO `area` VALUES ('829', '赞皇县', '815');
INSERT INTO `area` VALUES ('830', '无极县', '815');
INSERT INTO `area` VALUES ('831', '平山县', '815');
INSERT INTO `area` VALUES ('832', '元氏县', '815');
INSERT INTO `area` VALUES ('833', '赵县', '815');
INSERT INTO `area` VALUES ('834', '辛集市', '815');
INSERT INTO `area` VALUES ('835', '藁城市', '815');
INSERT INTO `area` VALUES ('836', '晋州市', '815');
INSERT INTO `area` VALUES ('837', '新乐市', '815');
INSERT INTO `area` VALUES ('838', '鹿泉市', '815');
INSERT INTO `area` VALUES ('839', '保定市', '814');
INSERT INTO `area` VALUES ('840', '新市区', '839');
INSERT INTO `area` VALUES ('841', '北市区', '839');
INSERT INTO `area` VALUES ('842', '南市区', '839');
INSERT INTO `area` VALUES ('843', '满城县', '839');
INSERT INTO `area` VALUES ('844', '清苑县', '839');
INSERT INTO `area` VALUES ('845', '涞水县', '839');
INSERT INTO `area` VALUES ('846', '阜平县', '839');
INSERT INTO `area` VALUES ('847', '徐水县', '839');
INSERT INTO `area` VALUES ('848', '定兴县', '839');
INSERT INTO `area` VALUES ('849', '唐县', '839');
INSERT INTO `area` VALUES ('850', '高阳县', '839');
INSERT INTO `area` VALUES ('851', '容城县', '839');
INSERT INTO `area` VALUES ('852', '涞源县', '839');
INSERT INTO `area` VALUES ('853', '望都县', '839');
INSERT INTO `area` VALUES ('854', '安新县', '839');
INSERT INTO `area` VALUES ('855', '易县', '839');
INSERT INTO `area` VALUES ('856', '曲阳县', '839');
INSERT INTO `area` VALUES ('857', '蠡县', '839');
INSERT INTO `area` VALUES ('858', '顺平县', '839');
INSERT INTO `area` VALUES ('859', '博野县', '839');
INSERT INTO `area` VALUES ('860', '雄县', '839');
INSERT INTO `area` VALUES ('861', '涿州市', '839');
INSERT INTO `area` VALUES ('862', '定州市', '839');
INSERT INTO `area` VALUES ('863', '安国市', '839');
INSERT INTO `area` VALUES ('864', '高碑店市', '839');
INSERT INTO `area` VALUES ('865', '沧州市', '814');
INSERT INTO `area` VALUES ('866', '新华区', '865');
INSERT INTO `area` VALUES ('867', '运河区', '865');
INSERT INTO `area` VALUES ('868', '沧县', '865');
INSERT INTO `area` VALUES ('869', '青县', '865');
INSERT INTO `area` VALUES ('870', '东光县', '865');
INSERT INTO `area` VALUES ('871', '海兴县', '865');
INSERT INTO `area` VALUES ('872', '盐山县', '865');
INSERT INTO `area` VALUES ('873', '肃宁县', '865');
INSERT INTO `area` VALUES ('874', '南皮县', '865');
INSERT INTO `area` VALUES ('875', '吴桥县', '865');
INSERT INTO `area` VALUES ('876', '献县', '865');
INSERT INTO `area` VALUES ('877', '孟村回族自治县', '865');
INSERT INTO `area` VALUES ('878', '泊头市', '865');
INSERT INTO `area` VALUES ('879', '任丘市', '865');
INSERT INTO `area` VALUES ('880', '黄骅市', '865');
INSERT INTO `area` VALUES ('881', '河间市', '865');
INSERT INTO `area` VALUES ('882', '承德市', '814');
INSERT INTO `area` VALUES ('883', '双桥区', '882');
INSERT INTO `area` VALUES ('884', '双滦区', '882');
INSERT INTO `area` VALUES ('885', '鹰手营子矿区', '882');
INSERT INTO `area` VALUES ('886', '承德县', '882');
INSERT INTO `area` VALUES ('887', '兴隆县', '882');
INSERT INTO `area` VALUES ('888', '平泉县', '882');
INSERT INTO `area` VALUES ('889', '滦平县', '882');
INSERT INTO `area` VALUES ('890', '隆化县', '882');
INSERT INTO `area` VALUES ('891', '丰宁满族自治县', '882');
INSERT INTO `area` VALUES ('892', '宽城满族自治县', '882');
INSERT INTO `area` VALUES ('893', '围场满族蒙古族自治县', '882');
INSERT INTO `area` VALUES ('894', '邯郸市', '814');
INSERT INTO `area` VALUES ('895', '邯山区', '894');
INSERT INTO `area` VALUES ('896', '丛台区', '894');
INSERT INTO `area` VALUES ('897', '复兴区', '894');
INSERT INTO `area` VALUES ('898', '峰峰矿区', '894');
INSERT INTO `area` VALUES ('899', '邯郸县', '894');
INSERT INTO `area` VALUES ('900', '临漳县', '894');
INSERT INTO `area` VALUES ('901', '成安县', '894');
INSERT INTO `area` VALUES ('902', '大名县', '894');
INSERT INTO `area` VALUES ('903', '涉县', '894');
INSERT INTO `area` VALUES ('904', '磁县', '894');
INSERT INTO `area` VALUES ('905', '肥乡县', '894');
INSERT INTO `area` VALUES ('906', '永年县', '894');
INSERT INTO `area` VALUES ('907', '邱县', '894');
INSERT INTO `area` VALUES ('908', '鸡泽县', '894');
INSERT INTO `area` VALUES ('909', '广平县', '894');
INSERT INTO `area` VALUES ('910', '馆陶县', '894');
INSERT INTO `area` VALUES ('911', '魏县', '894');
INSERT INTO `area` VALUES ('912', '曲周县', '894');
INSERT INTO `area` VALUES ('913', '武安市', '894');
INSERT INTO `area` VALUES ('914', '衡水市', '814');
INSERT INTO `area` VALUES ('915', '桃城区', '914');
INSERT INTO `area` VALUES ('916', '枣强县', '914');
INSERT INTO `area` VALUES ('917', '武邑县', '914');
INSERT INTO `area` VALUES ('918', '武强县', '914');
INSERT INTO `area` VALUES ('919', '饶阳县', '914');
INSERT INTO `area` VALUES ('920', '安平县', '914');
INSERT INTO `area` VALUES ('921', '故城县', '914');
INSERT INTO `area` VALUES ('922', '景县', '914');
INSERT INTO `area` VALUES ('923', '阜城县', '914');
INSERT INTO `area` VALUES ('924', '冀州市', '914');
INSERT INTO `area` VALUES ('925', '深州市', '914');
INSERT INTO `area` VALUES ('926', '廊坊市', '814');
INSERT INTO `area` VALUES ('927', '安次区', '926');
INSERT INTO `area` VALUES ('928', '广阳区', '926');
INSERT INTO `area` VALUES ('929', '固安县', '926');
INSERT INTO `area` VALUES ('930', '永清县', '926');
INSERT INTO `area` VALUES ('931', '香河县', '926');
INSERT INTO `area` VALUES ('932', '大城县', '926');
INSERT INTO `area` VALUES ('933', '文安县', '926');
INSERT INTO `area` VALUES ('934', '大厂回族自治县', '926');
INSERT INTO `area` VALUES ('935', '霸州市', '926');
INSERT INTO `area` VALUES ('936', '三河市', '926');
INSERT INTO `area` VALUES ('937', '秦皇岛市', '814');
INSERT INTO `area` VALUES ('938', '海港区', '937');
INSERT INTO `area` VALUES ('939', '山海关区', '937');
INSERT INTO `area` VALUES ('940', '北戴河区', '937');
INSERT INTO `area` VALUES ('941', '青龙满族自治县', '937');
INSERT INTO `area` VALUES ('942', '昌黎县', '937');
INSERT INTO `area` VALUES ('943', '抚宁县', '937');
INSERT INTO `area` VALUES ('944', '卢龙县', '937');
INSERT INTO `area` VALUES ('945', '唐山市', '814');
INSERT INTO `area` VALUES ('946', '路南区', '945');
INSERT INTO `area` VALUES ('947', '路北区', '945');
INSERT INTO `area` VALUES ('948', '古冶区', '945');
INSERT INTO `area` VALUES ('949', '开平区', '945');
INSERT INTO `area` VALUES ('950', '丰南区', '945');
INSERT INTO `area` VALUES ('951', '丰润区', '945');
INSERT INTO `area` VALUES ('952', '滦县', '945');
INSERT INTO `area` VALUES ('953', '滦南县', '945');
INSERT INTO `area` VALUES ('954', '乐亭县', '945');
INSERT INTO `area` VALUES ('955', '迁西县', '945');
INSERT INTO `area` VALUES ('956', '玉田县', '945');
INSERT INTO `area` VALUES ('957', '唐海县', '945');
INSERT INTO `area` VALUES ('958', '遵化市', '945');
INSERT INTO `area` VALUES ('959', '迁安市', '945');
INSERT INTO `area` VALUES ('960', '邢台市', '814');
INSERT INTO `area` VALUES ('961', '桥东区', '960');
INSERT INTO `area` VALUES ('962', '桥西区', '960');
INSERT INTO `area` VALUES ('963', '邢台县', '960');
INSERT INTO `area` VALUES ('964', '临城县', '960');
INSERT INTO `area` VALUES ('965', '内丘县', '960');
INSERT INTO `area` VALUES ('966', '柏乡县', '960');
INSERT INTO `area` VALUES ('967', '隆尧县', '960');
INSERT INTO `area` VALUES ('968', '任县', '960');