-
Notifications
You must be signed in to change notification settings - Fork 8
Expand file tree
/
Copy pathAdministratives-China(Street)-4.sql
More file actions
5434 lines (5107 loc) · 190 KB
/
Administratives-China(Street)-4.sql
File metadata and controls
5434 lines (5107 loc) · 190 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
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
/*
* _____ ______
* /_ / ____ ____ ____ _________ / __/ /_
* / / / __ \/ __ \/ __ \/ ___/ __ \/ /_/ __/
* / /__/ /_/ / / / / /_/ /\_ \/ /_/ / __/ /_
* /____/\____/_/ /_/\__ /____/\____/_/ \__/
* /____/
*
* Authors:
* 钟峰(Popeye Zhong) <zongsoft@qq.com>
*
* Copyright (C) 2015-2019 Zongsoft Studio. All rights reserved.
*
* MIT License
*
* Permission is hereby granted, free of charge, to any person obtaining a copy
* of this software and associated documentation files (the "Software"), to deal
* in the Software without restriction, including without limitation the rights
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
* copies of the Software, and to permit persons to whom the Software is
* furnished to do so, subject to the following conditions:
* The above copyright notice and this permission notice shall be included in all
* copies or substantial portions of the Software.
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
*/
/*
* 《2015年统计用区划代码和城乡划分代码(截止2015年09月30日)》 即(街道、社区、镇、乡/村)行政区划信息
* 数据来源:中华人民共和国国家统计局(http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2015/index.html)
* 数据范围:福建省(35)、江西省(36)、山东省(37)。
*/
/* 福建省 福州市 鼓楼区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 02, 001, '鼓东街道'),
(35, 01, 02, 002, '鼓西街道'),
(35, 01, 02, 003, '温泉街道'),
(35, 01, 02, 004, '东街街道'),
(35, 01, 02, 005, '南街街道'),
(35, 01, 02, 006, '安泰街道'),
(35, 01, 02, 007, '华大街道'),
(35, 01, 02, 008, '水部街道'),
(35, 01, 02, 009, '五凤街道'),
(35, 01, 02, 100, '洪山镇');
/* 福建省 福州市 台江区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 03, 001, '瀛洲街道'),
(35, 01, 03, 002, '后洲街道'),
(35, 01, 03, 003, '义洲街道'),
(35, 01, 03, 004, '新港街道'),
(35, 01, 03, 005, '上海街道'),
(35, 01, 03, 007, '苍霞街道'),
(35, 01, 03, 009, '茶亭街道'),
(35, 01, 03, 010, '洋中街道'),
(35, 01, 03, 011, '鳌峰街道'),
(35, 01, 03, 012, '宁化街道');
/* 福建省 福州市 仓山区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 04, 001, '仓前街道'),
(35, 01, 04, 002, '东升街道'),
(35, 01, 04, 003, '对湖街道'),
(35, 01, 04, 004, '临江街道'),
(35, 01, 04, 005, '三叉街街道'),
(35, 01, 04, 006, '上渡街道'),
(35, 01, 04, 007, '下渡街道'),
(35, 01, 04, 008, '金山街道'),
(35, 01, 04, 100, '仓山镇'),
(35, 01, 04, 101, '城门镇'),
(35, 01, 04, 102, '盖山镇'),
(35, 01, 04, 103, '建新镇'),
(35, 01, 04, 104, '螺洲镇');
/* 福建省 福州市 马尾区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 05, 001, '罗星街道'),
(35, 01, 05, 100, '马尾镇'),
(35, 01, 05, 101, '亭江镇'),
(35, 01, 05, 102, '琅岐镇');
/* 福建省 福州市 晋安区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 11, 001, '茶园街道'),
(35, 01, 11, 002, '王庄街道'),
(35, 01, 11, 003, '象园街道'),
(35, 01, 11, 100, '鼓山镇'),
(35, 01, 11, 101, '新店镇'),
(35, 01, 11, 102, '岳峰镇'),
(35, 01, 11, 103, '宦溪镇'),
(35, 01, 11, 201, '寿山乡'),
(35, 01, 11, 202, '日溪乡');
/* 福建省 福州市 闽侯县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 21, 001, '甘蔗街道'),
(35, 01, 21, 101, '白沙镇'),
(35, 01, 21, 102, '南屿镇'),
(35, 01, 21, 103, '尚干镇'),
(35, 01, 21, 104, '祥谦镇'),
(35, 01, 21, 105, '青口镇'),
(35, 01, 21, 106, '南通镇'),
(35, 01, 21, 107, '上街镇'),
(35, 01, 21, 108, '荆溪镇'),
(35, 01, 21, 200, '竹岐乡'),
(35, 01, 21, 201, '鸿尾乡'),
(35, 01, 21, 202, '洋里乡'),
(35, 01, 21, 203, '大湖乡'),
(35, 01, 21, 204, '廷坪乡'),
(35, 01, 21, 206, '小箬乡');
/* 福建省 福州市 连江县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 22, 100, '凤城镇'),
(35, 01, 22, 101, '敖江镇'),
(35, 01, 22, 102, '东岱镇'),
(35, 01, 22, 103, '琯头镇'),
(35, 01, 22, 104, '晓澳镇'),
(35, 01, 22, 105, '东湖镇'),
(35, 01, 22, 106, '丹阳镇'),
(35, 01, 22, 107, '长龙镇'),
(35, 01, 22, 108, '透堡镇'),
(35, 01, 22, 109, '马鼻镇'),
(35, 01, 22, 110, '官坂镇'),
(35, 01, 22, 111, '筱埕镇'),
(35, 01, 22, 112, '黄岐镇'),
(35, 01, 22, 113, '苔菉镇'),
(35, 01, 22, 114, '浦口镇'),
(35, 01, 22, 115, '坑园镇'),
(35, 01, 22, 200, '潘渡乡'),
(35, 01, 22, 201, '江南乡'),
(35, 01, 22, 202, '蓼沿乡'),
(35, 01, 22, 203, '安凯乡'),
(35, 01, 22, 204, '下宫乡'),
(35, 01, 22, 205, '小沧畲族乡');
/* 福建省 福州市 罗源县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 23, 100, '凤山镇'),
(35, 01, 23, 101, '松山镇'),
(35, 01, 23, 102, '起步镇'),
(35, 01, 23, 103, '中房镇'),
(35, 01, 23, 104, '飞竹镇'),
(35, 01, 23, 105, '鉴江镇'),
(35, 01, 23, 200, '白塔乡'),
(35, 01, 23, 201, '洪洋乡'),
(35, 01, 23, 202, '西兰乡'),
(35, 01, 23, 203, '霍口畲族乡'),
(35, 01, 23, 204, '碧里乡');
/* 福建省 福州市 闽清县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 24, 100, '梅城镇'),
(35, 01, 24, 101, '梅溪镇'),
(35, 01, 24, 102, '白樟镇'),
(35, 01, 24, 103, '金沙镇'),
(35, 01, 24, 104, '白中镇'),
(35, 01, 24, 105, '池园镇'),
(35, 01, 24, 106, '坂东镇'),
(35, 01, 24, 107, '塔庄镇'),
(35, 01, 24, 108, '省璜镇'),
(35, 01, 24, 109, '雄江镇'),
(35, 01, 24, 110, '东桥镇'),
(35, 01, 24, 200, '云龙乡'),
(35, 01, 24, 201, '上莲乡'),
(35, 01, 24, 204, '三溪乡'),
(35, 01, 24, 205, '桔林乡'),
(35, 01, 24, 206, '下祝乡');
/* 福建省 福州市 永泰县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 25, 100, '樟城镇'),
(35, 01, 25, 101, '嵩口镇'),
(35, 01, 25, 102, '梧桐镇'),
(35, 01, 25, 103, '葛岭镇'),
(35, 01, 25, 104, '城峰镇'),
(35, 01, 25, 105, '清凉镇'),
(35, 01, 25, 106, '长庆镇'),
(35, 01, 25, 107, '同安镇'),
(35, 01, 25, 108, '大洋镇'),
(35, 01, 25, 200, '塘前乡'),
(35, 01, 25, 201, '富泉乡'),
(35, 01, 25, 202, '岭路乡'),
(35, 01, 25, 203, '赤锡乡'),
(35, 01, 25, 204, '洑口乡'),
(35, 01, 25, 205, '盖洋乡'),
(35, 01, 25, 206, '东洋乡'),
(35, 01, 25, 207, '霞拔乡'),
(35, 01, 25, 208, '盘谷乡'),
(35, 01, 25, 209, '红星乡'),
(35, 01, 25, 210, '白云乡'),
(35, 01, 25, 211, '丹云乡');
/* 福建省 福州市 平潭县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 28, 100, '潭城镇'),
(35, 01, 28, 101, '苏澳镇'),
(35, 01, 28, 102, '流水镇'),
(35, 01, 28, 103, '澳前镇'),
(35, 01, 28, 104, '北厝镇'),
(35, 01, 28, 105, '平原镇'),
(35, 01, 28, 106, '敖东镇'),
(35, 01, 28, 200, '白青乡'),
(35, 01, 28, 201, '屿头乡'),
(35, 01, 28, 202, '大练乡'),
(35, 01, 28, 203, '芦洋乡'),
(35, 01, 28, 204, '中楼乡'),
(35, 01, 28, 205, '东庠乡'),
(35, 01, 28, 206, '岚城乡'),
(35, 01, 28, 207, '南海乡');
/* 福建省 福州市 福清市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 81, 002, '玉屏街道'),
(35, 01, 81, 003, '龙山街道'),
(35, 01, 81, 004, '龙江街道'),
(35, 01, 81, 005, '宏路街道'),
(35, 01, 81, 006, '石竹街道'),
(35, 01, 81, 007, '音西街道'),
(35, 01, 81, 008, '阳下街道'),
(35, 01, 81, 103, '海口镇'),
(35, 01, 81, 104, '城头镇'),
(35, 01, 81, 105, '南岭镇'),
(35, 01, 81, 106, '龙田镇'),
(35, 01, 81, 107, '江镜镇'),
(35, 01, 81, 108, '港头镇'),
(35, 01, 81, 109, '高山镇'),
(35, 01, 81, 110, '沙埔镇'),
(35, 01, 81, 111, '三山镇'),
(35, 01, 81, 112, '东瀚镇'),
(35, 01, 81, 113, '渔溪镇'),
(35, 01, 81, 114, '上迳镇'),
(35, 01, 81, 115, '新厝镇'),
(35, 01, 81, 116, '江阴镇'),
(35, 01, 81, 117, '东张镇'),
(35, 01, 81, 118, '镜洋镇'),
(35, 01, 81, 119, '一都镇');
/* 福建省 福州市 长乐市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 01, 82, 001, '吴航街道'),
(35, 01, 82, 002, '航城街道'),
(35, 01, 82, 003, '营前街道'),
(35, 01, 82, 004, '漳港街道'),
(35, 01, 82, 102, '首占镇'),
(35, 01, 82, 103, '玉田镇'),
(35, 01, 82, 104, '松下镇'),
(35, 01, 82, 105, '江田镇'),
(35, 01, 82, 106, '古槐镇'),
(35, 01, 82, 107, '文武砂镇'),
(35, 01, 82, 108, '鹤上镇'),
(35, 01, 82, 110, '湖南镇'),
(35, 01, 82, 111, '金峰镇'),
(35, 01, 82, 112, '文岭镇'),
(35, 01, 82, 113, '梅花镇'),
(35, 01, 82, 114, '潭头镇'),
(35, 01, 82, 200, '罗联乡'),
(35, 01, 82, 201, '猴屿乡');
/* 福建省 厦门市 思明区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 02, 03, 001, '厦港街道'),
(35, 02, 03, 003, '中华街道'),
(35, 02, 03, 005, '滨海街道'),
(35, 02, 03, 006, '鹭江街道'),
(35, 02, 03, 007, '开元街道'),
(35, 02, 03, 008, '梧村街道'),
(35, 02, 03, 009, '筼筜街道'),
(35, 02, 03, 010, '莲前街道'),
(35, 02, 03, 011, '嘉莲街道'),
(35, 02, 03, 012, '鼓浪屿街道');
/* 福建省 厦门市 海沧区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 02, 05, 001, '海沧街道'),
(35, 02, 05, 002, '新阳街道'),
(35, 02, 05, 003, '嵩屿街道'),
(35, 02, 05, 004, '东孚街道');
/* 福建省 厦门市 湖里区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 02, 06, 001, '湖里街道'),
(35, 02, 06, 002, '殿前街道'),
(35, 02, 06, 003, '禾山街道'),
(35, 02, 06, 004, '江头街道'),
(35, 02, 06, 005, '金山街道');
/* 福建省 厦门市 集美区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 02, 11, 001, '集美街道'),
(35, 02, 11, 002, '侨英街道'),
(35, 02, 11, 003, '杏林街道'),
(35, 02, 11, 004, '杏滨街道'),
(35, 02, 11, 102, '灌口镇'),
(35, 02, 11, 103, '后溪镇');
/* 福建省 厦门市 同安区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 02, 12, 001, '大同街道'),
(35, 02, 12, 002, '祥平街道'),
(35, 02, 12, 105, '莲花镇'),
(35, 02, 12, 106, '新民镇'),
(35, 02, 12, 107, '洪塘镇'),
(35, 02, 12, 108, '西柯镇'),
(35, 02, 12, 109, '汀溪镇'),
(35, 02, 12, 110, '五显镇');
/* 福建省 厦门市 翔安区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 02, 13, 001, '大嶝街道'),
(35, 02, 13, 102, '马巷镇'),
(35, 02, 13, 103, '新圩镇'),
(35, 02, 13, 104, '新店镇'),
(35, 02, 13, 111, '内厝镇');
/* 福建省 莆田市 城厢区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 03, 02, 001, '龙桥街道'),
(35, 03, 02, 002, '凤凰山街道'),
(35, 03, 02, 003, '霞林街道'),
(35, 03, 02, 100, '常太镇'),
(35, 03, 02, 101, '华亭镇'),
(35, 03, 02, 102, '灵川镇'),
(35, 03, 02, 103, '东海镇');
/* 福建省 莆田市 涵江区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 03, 03, 001, '涵东街道'),
(35, 03, 03, 002, '涵西街道'),
(35, 03, 03, 100, '三江口镇'),
(35, 03, 03, 101, '白塘镇'),
(35, 03, 03, 102, '国欢镇'),
(35, 03, 03, 103, '梧塘镇'),
(35, 03, 03, 104, '江口镇'),
(35, 03, 03, 105, '萩芦镇'),
(35, 03, 03, 106, '白沙镇'),
(35, 03, 03, 107, '庄边镇'),
(35, 03, 03, 108, '新县镇'),
(35, 03, 03, 200, '大洋乡');
/* 福建省 莆田市 荔城区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 03, 04, 001, '镇海街道'),
(35, 03, 04, 002, '拱辰街道'),
(35, 03, 04, 100, '西天尾镇'),
(35, 03, 04, 101, '黄石镇'),
(35, 03, 04, 102, '新度镇'),
(35, 03, 04, 103, '北高镇');
/* 福建省 莆田市 秀屿区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 03, 05, 100, '笏石镇'),
(35, 03, 05, 101, '东庄镇'),
(35, 03, 05, 102, '忠门镇'),
(35, 03, 05, 103, '东埔镇'),
(35, 03, 05, 104, '东峤镇'),
(35, 03, 05, 105, '埭头镇'),
(35, 03, 05, 106, '平海镇'),
(35, 03, 05, 107, '南日镇'),
(35, 03, 05, 108, '湄洲镇'),
(35, 03, 05, 109, '山亭镇'),
(35, 03, 05, 200, '月塘乡');
/* 福建省 莆田市 仙游县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 03, 22, 001, '鲤城街道'),
(35, 03, 22, 100, '枫亭镇'),
(35, 03, 22, 101, '榜头镇'),
(35, 03, 22, 102, '郊尾镇'),
(35, 03, 22, 103, '度尾镇'),
(35, 03, 22, 104, '鲤南镇'),
(35, 03, 22, 105, '赖店镇'),
(35, 03, 22, 106, '盖尾镇'),
(35, 03, 22, 107, '园庄镇'),
(35, 03, 22, 108, '大济镇'),
(35, 03, 22, 109, '龙华镇'),
(35, 03, 22, 110, '钟山镇'),
(35, 03, 22, 111, '游洋镇'),
(35, 03, 22, 200, '西苑乡'),
(35, 03, 22, 201, '石苍乡'),
(35, 03, 22, 202, '社硎乡'),
(35, 03, 22, 203, '书峰乡'),
(35, 03, 22, 204, '菜溪乡');
/* 福建省 三明市 梅列区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 02, 001, '列东街道'),
(35, 04, 02, 002, '列西街道'),
(35, 04, 02, 003, '徐碧街道'),
(35, 04, 02, 100, '陈大镇'),
(35, 04, 02, 101, '洋溪镇');
/* 福建省 三明市 三元区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 03, 001, '城关街道'),
(35, 04, 03, 002, '白沙街道'),
(35, 04, 03, 003, '富兴堡街道'),
(35, 04, 03, 004, '荆西街道'),
(35, 04, 03, 100, '莘口镇'),
(35, 04, 03, 101, '岩前镇'),
(35, 04, 03, 200, '城东乡'),
(35, 04, 03, 201, '中村乡');
/* 福建省 三明市 明溪县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 21, 100, '雪峰镇'),
(35, 04, 21, 101, '盖洋镇'),
(35, 04, 21, 102, '胡坊镇'),
(35, 04, 21, 103, '瀚仙镇'),
(35, 04, 21, 200, '城关乡'),
(35, 04, 21, 201, '沙溪乡'),
(35, 04, 21, 202, '夏阳乡'),
(35, 04, 21, 203, '枫溪乡'),
(35, 04, 21, 204, '夏坊乡');
/* 福建省 三明市 清流县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 23, 100, '龙津镇'),
(35, 04, 23, 101, '嵩溪镇'),
(35, 04, 23, 102, '嵩口镇'),
(35, 04, 23, 103, '灵地镇'),
(35, 04, 23, 104, '长校镇'),
(35, 04, 23, 201, '温郊乡'),
(35, 04, 23, 202, '林畲乡'),
(35, 04, 23, 203, '田源乡'),
(35, 04, 23, 204, '沙芜乡'),
(35, 04, 23, 205, '赖坊乡'),
(35, 04, 23, 206, '余朋乡'),
(35, 04, 23, 208, '李家乡'),
(35, 04, 23, 209, '里田乡');
/* 福建省 三明市 宁化县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 24, 100, '翠江镇'),
(35, 04, 24, 101, '泉上镇'),
(35, 04, 24, 102, '湖村镇'),
(35, 04, 24, 103, '石壁镇'),
(35, 04, 24, 104, '曹坊镇'),
(35, 04, 24, 105, '安远镇'),
(35, 04, 24, 106, '淮土镇'),
(35, 04, 24, 200, '城郊乡'),
(35, 04, 24, 201, '城南乡'),
(35, 04, 24, 202, '济村乡'),
(35, 04, 24, 204, '方田乡'),
(35, 04, 24, 205, '安乐乡'),
(35, 04, 24, 207, '治平畲族乡'),
(35, 04, 24, 208, '中沙乡'),
(35, 04, 24, 209, '河龙乡'),
(35, 04, 24, 210, '水茜乡');
/* 福建省 三明市 大田县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 25, 100, '均溪镇'),
(35, 04, 25, 101, '石牌镇'),
(35, 04, 25, 102, '上京镇'),
(35, 04, 25, 103, '广平镇'),
(35, 04, 25, 104, '桃源镇'),
(35, 04, 25, 105, '太华镇'),
(35, 04, 25, 106, '建设镇'),
(35, 04, 25, 107, '奇韬镇'),
(35, 04, 25, 200, '华兴乡'),
(35, 04, 25, 201, '屏山乡'),
(35, 04, 25, 202, '吴山乡'),
(35, 04, 25, 203, '济阳乡'),
(35, 04, 25, 204, '武陵乡'),
(35, 04, 25, 205, '谢洋乡'),
(35, 04, 25, 206, '文江乡'),
(35, 04, 25, 207, '梅山乡'),
(35, 04, 25, 208, '湖美乡'),
(35, 04, 25, 209, '前坪乡');
/* 福建省 三明市 尤溪县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 26, 100, '城关镇'),
(35, 04, 26, 101, '梅仙镇'),
(35, 04, 26, 102, '西滨镇'),
(35, 04, 26, 103, '洋中镇'),
(35, 04, 26, 104, '新阳镇'),
(35, 04, 26, 105, '管前镇'),
(35, 04, 26, 106, '西城镇'),
(35, 04, 26, 107, '尤溪口镇'),
(35, 04, 26, 108, '坂面镇'),
(35, 04, 26, 200, '联合乡'),
(35, 04, 26, 201, '汤川乡'),
(35, 04, 26, 202, '溪尾乡'),
(35, 04, 26, 203, '中仙乡'),
(35, 04, 26, 204, '台溪乡'),
(35, 04, 26, 206, '八字桥乡');
/* 福建省 三明市 沙县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 27, 001, '凤岗街道'),
(35, 04, 27, 002, '虬江街道'),
(35, 04, 27, 101, '青州镇'),
(35, 04, 27, 102, '夏茂镇'),
(35, 04, 27, 104, '高砂镇'),
(35, 04, 27, 105, '高桥镇'),
(35, 04, 27, 106, '富口镇'),
(35, 04, 27, 107, '大洛镇'),
(35, 04, 27, 201, '南霞乡'),
(35, 04, 27, 203, '南阳乡'),
(35, 04, 27, 204, '郑湖乡'),
(35, 04, 27, 205, '湖源乡');
/* 福建省 三明市 将乐县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 28, 100, '古镛镇'),
(35, 04, 28, 101, '万安镇'),
(35, 04, 28, 102, '高唐镇'),
(35, 04, 28, 103, '白莲镇'),
(35, 04, 28, 104, '黄潭镇'),
(35, 04, 28, 105, '水南镇'),
(35, 04, 28, 200, '光明乡'),
(35, 04, 28, 201, '漠源乡'),
(35, 04, 28, 202, '南口乡'),
(35, 04, 28, 203, '万全乡'),
(35, 04, 28, 204, '安仁乡'),
(35, 04, 28, 205, '大源乡'),
(35, 04, 28, 206, '余坊乡');
/* 福建省 三明市 泰宁县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 29, 100, '杉城镇'),
(35, 04, 29, 101, '朱口镇'),
(35, 04, 29, 200, '新桥乡'),
(35, 04, 29, 201, '上青乡'),
(35, 04, 29, 202, '大田乡'),
(35, 04, 29, 203, '梅口乡'),
(35, 04, 29, 204, '下渠乡'),
(35, 04, 29, 205, '开善乡'),
(35, 04, 29, 208, '大龙乡');
/* 福建省 三明市 建宁县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 30, 100, '濉溪镇'),
(35, 04, 30, 101, '里心镇'),
(35, 04, 30, 102, '溪口镇'),
(35, 04, 30, 103, '均口镇'),
(35, 04, 30, 201, '伊家乡'),
(35, 04, 30, 202, '黄坊乡'),
(35, 04, 30, 203, '溪源乡'),
(35, 04, 30, 204, '客坊乡'),
(35, 04, 30, 205, '黄埠乡');
/* 福建省 三明市 永安市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 04, 81, 001, '燕东街道'),
(35, 04, 81, 002, '燕西街道'),
(35, 04, 81, 003, '燕南街道'),
(35, 04, 81, 004, '燕北街道'),
(35, 04, 81, 100, '西洋镇'),
(35, 04, 81, 101, '贡川镇'),
(35, 04, 81, 102, '安砂镇'),
(35, 04, 81, 103, '小陶镇'),
(35, 04, 81, 104, '大湖镇'),
(35, 04, 81, 105, '曹远镇'),
(35, 04, 81, 106, '洪田镇'),
(35, 04, 81, 107, '槐南镇'),
(35, 04, 81, 202, '上坪乡'),
(35, 04, 81, 203, '罗坊乡'),
(35, 04, 81, 204, '青水乡');
/* 福建省 泉州市 鲤城区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 02, 001, '海滨街道'),
(35, 05, 02, 002, '临江街道'),
(35, 05, 02, 003, '鲤中街道'),
(35, 05, 02, 004, '开元街道'),
(35, 05, 02, 005, '浮桥街道'),
(35, 05, 02, 006, '江南街道'),
(35, 05, 02, 007, '金龙街道'),
(35, 05, 02, 008, '常泰街道');
/* 福建省 泉州市 丰泽区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 03, 001, '东湖街道'),
(35, 05, 03, 002, '丰泽街道'),
(35, 05, 03, 003, '泉秀街道'),
(35, 05, 03, 004, '清源街道'),
(35, 05, 03, 005, '华大街道'),
(35, 05, 03, 006, '城东街道'),
(35, 05, 03, 007, '东海街道'),
(35, 05, 03, 008, '北峰街道');
/* 福建省 泉州市 洛江区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 04, 001, '万安街道'),
(35, 05, 04, 002, '双阳街道'),
(35, 05, 04, 100, '罗溪镇'),
(35, 05, 04, 101, '马甲镇'),
(35, 05, 04, 102, '河市镇'),
(35, 05, 04, 200, '虹山乡');
/* 福建省 泉州市 泉港区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 05, 001, '山腰街道办事处'),
(35, 05, 05, 100, '南埔镇'),
(35, 05, 05, 101, '界山镇'),
(35, 05, 05, 102, '后龙镇'),
(35, 05, 05, 103, '峰尾镇'),
(35, 05, 05, 105, '前黄镇'),
(35, 05, 05, 106, '涂岭镇');
/* 福建省 泉州市 惠安县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 21, 100, '螺城镇'),
(35, 05, 21, 101, '螺阳镇'),
(35, 05, 21, 102, '黄塘镇'),
(35, 05, 21, 103, '紫山镇'),
(35, 05, 21, 104, '洛阳镇'),
(35, 05, 21, 105, '东园镇'),
(35, 05, 21, 106, '张坂镇'),
(35, 05, 21, 107, '崇武镇'),
(35, 05, 21, 108, '山霞镇'),
(35, 05, 21, 109, '涂寨镇'),
(35, 05, 21, 110, '东岭镇'),
(35, 05, 21, 111, '东桥镇'),
(35, 05, 21, 112, '净峰镇'),
(35, 05, 21, 113, '小岞镇'),
(35, 05, 21, 114, '辋川镇'),
(35, 05, 21, 200, '百崎回族乡');
/* 福建省 泉州市 安溪县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 24, 100, '凤城镇'),
(35, 05, 24, 101, '蓬莱镇'),
(35, 05, 24, 102, '湖头镇'),
(35, 05, 24, 103, '官桥镇'),
(35, 05, 24, 104, '剑斗镇'),
(35, 05, 24, 105, '城厢镇'),
(35, 05, 24, 106, '金谷镇'),
(35, 05, 24, 107, '龙门镇'),
(35, 05, 24, 108, '虎邱镇'),
(35, 05, 24, 109, '芦田镇'),
(35, 05, 24, 110, '感德镇'),
(35, 05, 24, 111, '魁斗镇'),
(35, 05, 24, 112, '西坪镇'),
(35, 05, 24, 200, '参内乡'),
(35, 05, 24, 201, '白濑乡'),
(35, 05, 24, 202, '湖上乡'),
(35, 05, 24, 203, '尚卿乡'),
(35, 05, 24, 204, '大坪乡'),
(35, 05, 24, 205, '龙涓乡'),
(35, 05, 24, 206, '长坑乡'),
(35, 05, 24, 207, '蓝田乡'),
(35, 05, 24, 208, '祥华乡'),
(35, 05, 24, 209, '桃舟乡'),
(35, 05, 24, 210, '福田乡');
/* 福建省 泉州市 永春县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 25, 100, '桃城镇'),
(35, 05, 25, 101, '五里街镇'),
(35, 05, 25, 102, '一都镇'),
(35, 05, 25, 103, '下洋镇'),
(35, 05, 25, 104, '蓬壶镇'),
(35, 05, 25, 105, '达埔镇'),
(35, 05, 25, 106, '吾峰镇'),
(35, 05, 25, 107, '石鼓镇'),
(35, 05, 25, 108, '岵山镇'),
(35, 05, 25, 109, '东平镇'),
(35, 05, 25, 110, '湖洋镇'),
(35, 05, 25, 111, '坑仔口镇'),
(35, 05, 25, 112, '玉斗镇'),
(35, 05, 25, 113, '锦斗镇'),
(35, 05, 25, 114, '东关镇'),
(35, 05, 25, 115, '桂洋镇'),
(35, 05, 25, 116, '苏坑镇'),
(35, 05, 25, 117, '仙夹镇'),
(35, 05, 25, 200, '横口乡'),
(35, 05, 25, 201, '呈祥乡'),
(35, 05, 25, 202, '介福乡'),
(35, 05, 25, 204, '外山乡');
/* 福建省 泉州市 德化县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 26, 100, '浔中镇'),
(35, 05, 26, 101, '龙浔镇'),
(35, 05, 26, 102, '三班镇'),
(35, 05, 26, 103, '龙门滩镇'),
(35, 05, 26, 104, '雷峰镇'),
(35, 05, 26, 105, '南埕镇'),
(35, 05, 26, 106, '水口镇'),
(35, 05, 26, 107, '赤水镇'),
(35, 05, 26, 108, '上涌镇'),
(35, 05, 26, 109, '葛坑镇'),
(35, 05, 26, 110, '盖德镇'),
(35, 05, 26, 111, '美湖镇'),
(35, 05, 26, 200, '杨梅乡'),
(35, 05, 26, 202, '汤头乡'),
(35, 05, 26, 204, '桂阳乡'),
(35, 05, 26, 206, '国宝乡'),
(35, 05, 26, 208, '大铭乡'),
(35, 05, 26, 209, '春美乡');
/* 福建省 泉州市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 27, 000, '金门县');
/* 福建省 泉州市 石狮市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 81, 001, '湖滨街道'),
(35, 05, 81, 002, '凤里街道'),
(35, 05, 81, 100, '灵秀镇'),
(35, 05, 81, 101, '宝盖镇'),
(35, 05, 81, 102, '蚶江镇'),
(35, 05, 81, 103, '祥芝镇'),
(35, 05, 81, 104, '鸿山镇'),
(35, 05, 81, 105, '锦尚镇'),
(35, 05, 81, 106, '永宁镇');
/* 福建省 泉州市 晋江市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 82, 001, '青阳街道办事处'),
(35, 05, 82, 002, '梅岭街道办事处'),
(35, 05, 82, 003, '西园街道办事处'),
(35, 05, 82, 004, '罗山街道办事处'),
(35, 05, 82, 005, '新塘街道办事处'),
(35, 05, 82, 006, '灵源街道办事处'),
(35, 05, 82, 101, '安海镇'),
(35, 05, 82, 102, '磁灶镇'),
(35, 05, 82, 103, '陈埭镇'),
(35, 05, 82, 104, '东石镇'),
(35, 05, 82, 105, '深沪镇'),
(35, 05, 82, 106, '金井镇'),
(35, 05, 82, 107, '池店镇'),
(35, 05, 82, 109, '内坑镇'),
(35, 05, 82, 110, '龙湖镇'),
(35, 05, 82, 111, '永和镇'),
(35, 05, 82, 112, '英林镇'),
(35, 05, 82, 113, '紫帽镇'),
(35, 05, 82, 114, '西滨镇');
/* 福建省 泉州市 南安市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 05, 83, 001, '溪美街道'),
(35, 05, 83, 002, '柳城街道'),
(35, 05, 83, 003, '美林街道'),
(35, 05, 83, 100, '省新镇'),
(35, 05, 83, 101, '仑苍镇'),
(35, 05, 83, 102, '东田镇'),
(35, 05, 83, 103, '英都镇'),
(35, 05, 83, 104, '翔云镇'),
(35, 05, 83, 105, '金淘镇'),
(35, 05, 83, 106, '诗山镇'),
(35, 05, 83, 107, '蓬华镇'),
(35, 05, 83, 108, '码头镇'),
(35, 05, 83, 109, '九都镇'),
(35, 05, 83, 110, '乐峰镇'),
(35, 05, 83, 111, '罗东镇'),
(35, 05, 83, 112, '梅山镇'),
(35, 05, 83, 113, '洪濑镇'),
(35, 05, 83, 114, '洪梅镇'),
(35, 05, 83, 115, '康美镇'),
(35, 05, 83, 116, '丰州镇'),
(35, 05, 83, 117, '霞美镇'),
(35, 05, 83, 118, '官桥镇'),
(35, 05, 83, 119, '水头镇'),
(35, 05, 83, 120, '石井镇'),
(35, 05, 83, 200, '眉山乡'),
(35, 05, 83, 201, '向阳乡');
/* 福建省 漳州市 芗城区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 02, 001, '东铺头街道'),
(35, 06, 02, 002, '西桥街道'),
(35, 06, 02, 003, '新桥街道'),
(35, 06, 02, 004, '巷口街道'),
(35, 06, 02, 005, '南坑街道'),
(35, 06, 02, 006, '通北街道'),
(35, 06, 02, 100, '浦南镇'),
(35, 06, 02, 101, '天宝镇'),
(35, 06, 02, 102, '芝山镇'),
(35, 06, 02, 103, '石亭镇');
/* 福建省 漳州市 龙文区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 03, 100, '蓝田镇'),
(35, 06, 03, 101, '步文镇'),
(35, 06, 03, 102, '朝阳镇'),
(35, 06, 03, 103, '郭坑镇');
/* 福建省 漳州市 云霄县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 22, 100, '云陵镇'),
(35, 06, 22, 101, '陈岱镇'),
(35, 06, 22, 102, '东厦镇'),
(35, 06, 22, 103, '莆美镇'),
(35, 06, 22, 104, '列屿镇'),
(35, 06, 22, 105, '火田镇'),
(35, 06, 22, 200, '下河乡'),
(35, 06, 22, 201, '马铺乡'),
(35, 06, 22, 202, '和平乡');
/* 福建省 漳州市 漳浦县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 23, 100, '绥安镇'),
(35, 06, 23, 101, '旧镇镇'),
(35, 06, 23, 102, '佛昙镇'),
(35, 06, 23, 103, '赤湖镇'),
(35, 06, 23, 104, '杜浔镇'),
(35, 06, 23, 105, '霞美镇'),
(35, 06, 23, 106, '官浔镇'),
(35, 06, 23, 107, '石榴镇'),
(35, 06, 23, 108, '盘陀镇'),
(35, 06, 23, 109, '长桥镇'),
(35, 06, 23, 110, '前亭镇'),
(35, 06, 23, 111, '马坪镇'),
(35, 06, 23, 112, '深土镇'),
(35, 06, 23, 113, '六鳌镇'),
(35, 06, 23, 114, '沙西镇'),
(35, 06, 23, 115, '古雷镇'),
(35, 06, 23, 116, '大南坂镇'),
(35, 06, 23, 200, '南浦乡'),
(35, 06, 23, 201, '赤岭畲族乡'),
(35, 06, 23, 202, '湖西畲族乡'),
(35, 06, 23, 203, '赤土乡');
/* 福建省 漳州市 诏安县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 24, 100, '南诏镇'),
(35, 06, 24, 101, '四都镇'),
(35, 06, 24, 102, '梅岭镇'),
(35, 06, 24, 103, '桥东镇'),
(35, 06, 24, 104, '深桥镇'),
(35, 06, 24, 105, '太平镇'),
(35, 06, 24, 106, '霞葛镇'),
(35, 06, 24, 107, '官陂镇'),
(35, 06, 24, 108, '秀篆镇'),
(35, 06, 24, 200, '金星乡'),
(35, 06, 24, 201, '西潭乡'),
(35, 06, 24, 202, '白洋乡'),
(35, 06, 24, 203, '建设乡'),
(35, 06, 24, 204, '红星乡'),
(35, 06, 24, 205, '梅洲乡');
/* 福建省 漳州市 长泰县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 25, 100, '武安镇'),
(35, 06, 25, 101, '岩溪镇'),
(35, 06, 25, 102, '陈巷镇'),
(35, 06, 25, 103, '枋洋镇'),
(35, 06, 25, 200, '坂里乡');
/* 福建省 漳州市 东山县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 26, 100, '西埔镇'),
(35, 06, 26, 101, '樟塘镇'),
(35, 06, 26, 102, '康美镇'),
(35, 06, 26, 103, '杏陈镇'),
(35, 06, 26, 104, '陈城镇'),
(35, 06, 26, 105, '前楼镇'),
(35, 06, 26, 106, '铜陵镇');
/* 福建省 漳州市 南靖县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 27, 100, '山城镇'),
(35, 06, 27, 101, '丰田镇'),
(35, 06, 27, 102, '靖城镇'),
(35, 06, 27, 103, '龙山镇'),
(35, 06, 27, 104, '金山镇'),
(35, 06, 27, 105, '和溪镇'),
(35, 06, 27, 106, '奎洋镇'),
(35, 06, 27, 107, '梅林镇'),
(35, 06, 27, 108, '书洋镇'),
(35, 06, 27, 109, '船场镇'),
(35, 06, 27, 110, '南坑镇');
/* 福建省 漳州市 平和县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 28, 100, '小溪镇'),
(35, 06, 28, 101, '山格镇'),
(35, 06, 28, 102, '文峰镇'),
(35, 06, 28, 103, '南胜镇'),
(35, 06, 28, 104, '坂仔镇'),
(35, 06, 28, 105, '安厚镇'),
(35, 06, 28, 106, '大溪镇'),
(35, 06, 28, 107, '霞寨镇'),
(35, 06, 28, 108, '九峰镇'),
(35, 06, 28, 109, '芦溪镇'),
(35, 06, 28, 200, '五寨乡'),
(35, 06, 28, 201, '国强乡'),
(35, 06, 28, 202, '崎岭乡'),
(35, 06, 28, 203, '长乐乡'),
(35, 06, 28, 204, '秀峰乡');
/* 福建省 漳州市 华安县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 29, 100, '华丰镇'),
(35, 06, 29, 101, '丰山镇'),
(35, 06, 29, 102, '沙建镇'),
(35, 06, 29, 103, '新圩镇'),
(35, 06, 29, 104, '高安镇'),
(35, 06, 29, 105, '仙都镇'),
(35, 06, 29, 200, '高车乡'),
(35, 06, 29, 201, '马坑乡'),
(35, 06, 29, 203, '湖林乡');
/* 福建省 漳州市 龙海市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 06, 81, 100, '石码镇'),
(35, 06, 81, 101, '海澄镇'),
(35, 06, 81, 102, '角美镇'),
(35, 06, 81, 103, '白水镇'),
(35, 06, 81, 104, '浮宫镇'),
(35, 06, 81, 105, '程溪镇'),
(35, 06, 81, 106, '港尾镇'),
(35, 06, 81, 107, '九湖镇'),
(35, 06, 81, 108, '颜厝镇'),
(35, 06, 81, 109, '榜山镇'),
(35, 06, 81, 110, '紫泥镇'),
(35, 06, 81, 111, '东园镇'),
(35, 06, 81, 200, '东泗乡'),
(35, 06, 81, 201, '隆教畲族乡');
/* 福建省 南平市 延平区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 07, 02, 001, '梅山街道'),
(35, 07, 02, 002, '黄墩街道'),
(35, 07, 02, 003, '紫云街道'),
(35, 07, 02, 004, '四鹤街道'),
(35, 07, 02, 005, '水南街道'),
(35, 07, 02, 006, '水东街道'),
(35, 07, 02, 100, '来舟镇'),
(35, 07, 02, 101, '樟湖镇'),
(35, 07, 02, 102, '夏道镇'),
(35, 07, 02, 103, '西芹镇'),
(35, 07, 02, 104, '峡阳镇'),
(35, 07, 02, 105, '南山镇'),
(35, 07, 02, 106, '大横镇'),
(35, 07, 02, 107, '王台镇'),
(35, 07, 02, 108, '太平镇'),
(35, 07, 02, 109, '塔前镇'),
(35, 07, 02, 110, '茫荡镇'),
(35, 07, 02, 111, '洋后镇'),
(35, 07, 02, 112, '炉下镇'),
(35, 07, 02, 200, '巨口乡'),
(35, 07, 02, 202, '赤门乡');
/* 福建省 南平市 建阳区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 07, 03, 001, '潭城街道'),
(35, 07, 03, 002, '童游街道'),
(35, 07, 03, 102, '将口镇'),
(35, 07, 03, 103, '徐市镇'),
(35, 07, 03, 104, '莒口镇'),
(35, 07, 03, 105, '麻沙镇'),
(35, 07, 03, 106, '黄坑镇'),
(35, 07, 03, 107, '水吉镇'),
(35, 07, 03, 108, '漳墩镇'),
(35, 07, 03, 109, '小湖镇'),
(35, 07, 03, 200, '崇雒乡'),
(35, 07, 03, 201, '书坊乡'),
(35, 07, 03, 202, '回龙乡');
/* 福建省 南平市 顺昌县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 07, 21, 001, '双溪街道'),
(35, 07, 21, 100, '建西镇'),
(35, 07, 21, 101, '洋口镇'),
(35, 07, 21, 102, '元坑镇'),
(35, 07, 21, 103, '埔上镇'),
(35, 07, 21, 104, '大历镇'),
(35, 07, 21, 105, '大干镇'),
(35, 07, 21, 106, '仁寿镇'),
(35, 07, 21, 107, '郑坊镇'),
(35, 07, 21, 200, '洋墩乡'),
(35, 07, 21, 202, '岚下乡'),
(35, 07, 21, 203, '高阳乡');
/* 福建省 南平市 浦城县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(35, 07, 22, 001, '南浦街道'),
(35, 07, 22, 002, '河滨街道'),
(35, 07, 22, 101, '富岭镇'),
(35, 07, 22, 102, '石陂镇'),
(35, 07, 22, 103, '临江镇'),
(35, 07, 22, 104, '仙阳镇'),
(35, 07, 22, 105, '水北街镇'),
(35, 07, 22, 106, '永兴镇'),
(35, 07, 22, 107, '忠信镇'),
(35, 07, 22, 108, '莲塘镇'),
(35, 07, 22, 109, '九牧镇'),
(35, 07, 22, 200, '万安乡'),
(35, 07, 22, 201, '古楼乡'),
(35, 07, 22, 202, '山下乡'),
(35, 07, 22, 203, '枫溪乡'),
(35, 07, 22, 204, '濠村乡'),
(35, 07, 22, 205, '管厝乡'),
(35, 07, 22, 206, '盘亭乡'),
(35, 07, 22, 207, '官路乡');
/* 福建省 南平市 光泽县 */