-
Notifications
You must be signed in to change notification settings - Fork 8
Expand file tree
/
Copy pathAdministratives-China(Street)-3.sql
More file actions
4937 lines (4637 loc) · 171 KB
/
Administratives-China(Street)-3.sql
File metadata and controls
4937 lines (4637 loc) · 171 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)
* 数据范围:江苏省(32)、浙江省(33)、安徽省(34)。
*/
/* 江苏省,南京市,玄武区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 02, 002, '梅园新村街道'),
(32, 01, 02, 003, '新街口街道'),
(32, 01, 02, 005, '玄武门街道'),
(32, 01, 02, 007, '锁金村街道'),
(32, 01, 02, 008, '红山街道'),
(32, 01, 02, 009, '孝陵卫街道'),
(32, 01, 02, 010, '玄武湖街道');
/* 江苏省,南京市,秦淮区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 04, 001, '秦虹街道'),
(32, 01, 04, 002, '夫子庙街道'),
(32, 01, 04, 003, '红花街道'),
(32, 01, 04, 004, '双塘街道'),
(32, 01, 04, 005, '中华门街道'),
(32, 01, 04, 006, '五老村街道'),
(32, 01, 04, 007, '洪武路街道'),
(32, 01, 04, 008, '大光路街道'),
(32, 01, 04, 009, '瑞金路街道'),
(32, 01, 04, 010, '月牙湖街道'),
(32, 01, 04, 011, '光华路街道'),
(32, 01, 04, 012, '朝天宫街道');
/* 江苏省,南京市,建邺区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 05, 001, '莫愁湖街道'),
(32, 01, 05, 002, '沙洲街道'),
(32, 01, 05, 003, '双闸街道'),
(32, 01, 05, 004, '江心洲街道'),
(32, 01, 05, 006, '兴隆街道'),
(32, 01, 05, 007, '南苑街道');
/* 江苏省,南京市,鼓楼区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 06, 001, '宁海路街道'),
(32, 01, 06, 002, '华侨路街道'),
(32, 01, 06, 003, '湖南路街道'),
(32, 01, 06, 004, '中央门街道'),
(32, 01, 06, 005, '挹江门街道'),
(32, 01, 06, 006, '江东街道'),
(32, 01, 06, 007, '凤凰街道'),
(32, 01, 06, 008, '阅江楼街道'),
(32, 01, 06, 009, '热河南路街道'),
(32, 01, 06, 010, '幕府山街道'),
(32, 01, 06, 011, '建宁路街道'),
(32, 01, 06, 012, '宝塔桥街道'),
(32, 01, 06, 013, '小市街道');
/* 江苏省,南京市,浦口区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 11, 001, '泰山街道'),
(32, 01, 11, 002, '顶山街道'),
(32, 01, 11, 003, '沿江街道'),
(32, 01, 11, 004, '江浦街道'),
(32, 01, 11, 005, '桥林街道'),
(32, 01, 11, 006, '汤泉街道'),
(32, 01, 11, 007, '盘城街道'),
(32, 01, 11, 008, '星甸街道'),
(32, 01, 11, 009, '永宁街道');
/* 江苏省,南京市,栖霞区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 13, 001, '尧化街道'),
(32, 01, 13, 002, '马群街道'),
(32, 01, 13, 003, '迈皋桥街道'),
(32, 01, 13, 004, '燕子矶街道'),
(32, 01, 13, 005, '栖霞街道'),
(32, 01, 13, 006, '龙潭街道'),
(32, 01, 13, 007, '仙林街道'),
(32, 01, 13, 009, '八卦洲街道'),
(32, 01, 13, 010, '西岗街道');
/* 江苏省,南京市,雨花台区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 14, 001, '雨花街道'),
(32, 01, 14, 002, '赛虹桥街道'),
(32, 01, 14, 004, '西善桥街道'),
(32, 01, 14, 005, '板桥街道'),
(32, 01, 14, 006, '铁心桥街道'),
(32, 01, 14, 007, '梅山街道');
/* 江苏省,南京市,江宁区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 15, 001, '东山街道'),
(32, 01, 15, 002, '秣陵街道'),
(32, 01, 15, 003, '汤山街道'),
(32, 01, 15, 004, '淳化街道'),
(32, 01, 15, 005, '禄口街道'),
(32, 01, 15, 006, '江宁街道'),
(32, 01, 15, 007, '谷里街道'),
(32, 01, 15, 008, '湖熟街道'),
(32, 01, 15, 009, '横溪街道'),
(32, 01, 15, 010, '麒麟街道');
/* 江苏省,南京市,六合区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 16, 001, '大厂街道'),
(32, 01, 16, 004, '葛塘街道'),
(32, 01, 16, 005, '长芦街道'),
(32, 01, 16, 006, '雄州街道'),
(32, 01, 16, 007, '龙池街道'),
(32, 01, 16, 008, '程桥街道'),
(32, 01, 16, 009, '金牛湖街道'),
(32, 01, 16, 010, '横梁街道'),
(32, 01, 16, 011, '龙袍街道'),
(32, 01, 16, 012, '马鞍街道'),
(32, 01, 16, 013, '冶山街道'),
(32, 01, 16, 110, '竹镇镇');
/* 江苏省,南京市,溧水区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 17, 001, '永阳街道'),
(32, 01, 17, 002, '柘塘街道'),
(32, 01, 17, 101, '白马镇'),
(32, 01, 17, 102, '东屏镇'),
(32, 01, 17, 104, '石湫镇'),
(32, 01, 17, 105, '洪蓝镇'),
(32, 01, 17, 106, '晶桥镇'),
(32, 01, 17, 107, '和凤镇');
/* 江苏省,南京市,高淳区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 01, 18, 001, '淳溪街道'),
(32, 01, 18, 002, '古柏街道'),
(32, 01, 18, 101, '阳江镇'),
(32, 01, 18, 102, '砖墙镇'),
(32, 01, 18, 104, '漆桥镇'),
(32, 01, 18, 105, '固城镇'),
(32, 01, 18, 106, '东坝镇'),
(32, 01, 18, 108, '桠溪镇');
/* 江苏省,无锡市,崇安区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 02, 02, 001, '崇安寺街道'),
(32, 02, 02, 002, '通江街道'),
(32, 02, 02, 003, '广瑞路街道'),
(32, 02, 02, 004, '上马墩街道'),
(32, 02, 02, 005, '江海街道'),
(32, 02, 02, 006, '广益街道');
/* 江苏省,无锡市,南长区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 02, 03, 001, '迎龙桥街道'),
(32, 02, 03, 002, '南禅寺街道'),
(32, 02, 03, 003, '清名桥街道'),
(32, 02, 03, 004, '金星街道'),
(32, 02, 03, 005, '金匮街道'),
(32, 02, 03, 006, '扬名街道');
/* 江苏省,无锡市,北塘区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 02, 04, 001, '黄巷街道'),
(32, 02, 04, 002, '山北街道'),
(32, 02, 04, 003, '北大街街道'),
(32, 02, 04, 004, '惠山街道');
/* 江苏省,无锡市,锡山区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 02, 05, 001, '东亭街道'),
(32, 02, 05, 002, '安镇街道'),
(32, 02, 05, 003, '东北塘街道'),
(32, 02, 05, 102, '羊尖镇'),
(32, 02, 05, 103, '鹅湖镇'),
(32, 02, 05, 105, '锡北镇'),
(32, 02, 05, 106, '东港镇');
/* 江苏省,无锡市,惠山区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 02, 06, 001, '堰桥街道'),
(32, 02, 06, 002, '长安街道'),
(32, 02, 06, 003, '钱桥街道'),
(32, 02, 06, 004, '前洲街道'),
(32, 02, 06, 005, '玉祁街道'),
(32, 02, 06, 102, '洛社镇'),
(32, 02, 06, 103, '阳山镇');
/* 江苏省,无锡市,滨湖区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 02, 11, 001, '河埒街道'),
(32, 02, 11, 002, '荣巷街道'),
(32, 02, 11, 003, '蠡园街道'),
(32, 02, 11, 004, '蠡湖街道'),
(32, 02, 11, 006, '华庄街道'),
(32, 02, 11, 007, '太湖街道'),
(32, 02, 11, 008, '雪浪街道'),
(32, 02, 11, 009, '马山街道'),
(32, 02, 11, 101, '胡埭镇');
/* 江苏省,无锡市,江阴市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 02, 81, 001, '澄江街道'),
(32, 02, 81, 004, '南闸街道'),
(32, 02, 81, 005, '云亭街道'),
(32, 02, 81, 006, '临港街道'),
(32, 02, 81, 100, '璜土镇'),
(32, 02, 81, 102, '月城镇'),
(32, 02, 81, 103, '青阳镇'),
(32, 02, 81, 104, '徐霞客镇'),
(32, 02, 81, 107, '华士镇'),
(32, 02, 81, 108, '周庄镇'),
(32, 02, 81, 109, '新桥镇'),
(32, 02, 81, 110, '长泾镇'),
(32, 02, 81, 111, '顾山镇'),
(32, 02, 81, 112, '祝塘镇');
/* 江苏省,无锡市,宜兴市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 02, 82, 001, '宜城街道'),
(32, 02, 82, 002, '屺亭街道'),
(32, 02, 82, 003, '新庄街道'),
(32, 02, 82, 004, '新街街道'),
(32, 02, 82, 005, '芳桥街道'),
(32, 02, 82, 100, '张渚镇'),
(32, 02, 82, 101, '西渚镇'),
(32, 02, 82, 102, '太华镇'),
(32, 02, 82, 103, '徐舍镇'),
(32, 02, 82, 104, '官林镇'),
(32, 02, 82, 105, '杨巷镇'),
(32, 02, 82, 106, '新建镇'),
(32, 02, 82, 107, '和桥镇'),
(32, 02, 82, 108, '高塍镇'),
(32, 02, 82, 109, '万石镇'),
(32, 02, 82, 110, '周铁镇'),
(32, 02, 82, 112, '丁蜀镇'),
(32, 02, 82, 113, '湖父镇');
/* 江苏省,徐州市,鼓楼区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 02, 001, '黄楼街道'),
(32, 03, 02, 002, '丰财街道'),
(32, 03, 02, 003, '琵琶街道'),
(32, 03, 02, 004, '牌楼街道'),
(32, 03, 02, 005, '铜沛街道'),
(32, 03, 02, 006, '环城街道'),
(32, 03, 02, 007, '九里街道');
/* 江苏省,徐州市,云龙区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 03, 001, '彭城街道'),
(32, 03, 03, 002, '子房街道'),
(32, 03, 03, 003, '黄山街道'),
(32, 03, 03, 004, '骆驼山街道'),
(32, 03, 03, 005, '大郭庄街道'),
(32, 03, 03, 006, '翠屏山街道'),
(32, 03, 03, 007, '大龙湖街道'),
(32, 03, 03, 008, '潘塘街道');
/* 江苏省,徐州市,贾汪区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 05, 001, '老矿街道'),
(32, 03, 05, 003, '大泉街道'),
(32, 03, 05, 004, '大吴街道'),
(32, 03, 05, 005, '潘安湖街道'),
(32, 03, 05, 102, '青山泉镇'),
(32, 03, 05, 104, '紫庄镇'),
(32, 03, 05, 105, '塔山镇'),
(32, 03, 05, 106, '汴塘镇'),
(32, 03, 05, 107, '江庄镇');
/* 江苏省,徐州市,泉山区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 11, 001, '王陵街道'),
(32, 03, 11, 002, '七里沟街道'),
(32, 03, 11, 003, '永安街道'),
(32, 03, 11, 004, '湖滨街道'),
(32, 03, 11, 005, '段庄街道'),
(32, 03, 11, 006, '翟山街道'),
(32, 03, 11, 007, '奎山街道'),
(32, 03, 11, 008, '和平街道'),
(32, 03, 11, 009, '金山街道'),
(32, 03, 11, 010, '泰山街道'),
(32, 03, 11, 011, '庞庄街道'),
(32, 03, 11, 012, '火花街道'),
(32, 03, 11, 013, '桃园街道'),
(32, 03, 11, 014, '苏山街道');
/* 江苏省,徐州市,铜山区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 12, 001, '三河尖街道'),
(32, 03, 12, 002, '张双楼街道'),
(32, 03, 12, 003, '垞城街道'),
(32, 03, 12, 004, '张集街道'),
(32, 03, 12, 005, '义安街道'),
(32, 03, 12, 006, '利国街道'),
(32, 03, 12, 007, '电厂街道'),
(32, 03, 12, 008, '拾屯街道'),
(32, 03, 12, 009, '铜山街道办事处'),
(32, 03, 12, 051, '新区街道办事处'),
(32, 03, 12, 052, '三堡街道办事处'),
(32, 03, 12, 102, '何桥镇'),
(32, 03, 12, 103, '黄集镇'),
(32, 03, 12, 104, '马坡镇'),
(32, 03, 12, 105, '郑集镇'),
(32, 03, 12, 106, '柳新镇'),
(32, 03, 12, 107, '刘集镇'),
(32, 03, 12, 108, '大彭镇'),
(32, 03, 12, 109, '汉王镇'),
(32, 03, 12, 111, '棠张镇'),
(32, 03, 12, 112, '张集镇'),
(32, 03, 12, 113, '房村镇'),
(32, 03, 12, 114, '伊庄镇'),
(32, 03, 12, 115, '单集镇'),
(32, 03, 12, 116, '利国镇'),
(32, 03, 12, 118, '大许镇'),
(32, 03, 12, 119, '茅村镇'),
(32, 03, 12, 120, '柳泉镇');
/* 江苏省,徐州市,丰县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 21, 001, '中阳里街道办事处'),
(32, 03, 21, 002, '凤城街道办事处'),
(32, 03, 21, 003, '孙楼街道办事处'),
(32, 03, 21, 102, '首羡镇'),
(32, 03, 21, 103, '顺河镇'),
(32, 03, 21, 104, '常店镇'),
(32, 03, 21, 105, '欢口镇'),
(32, 03, 21, 106, '师寨镇'),
(32, 03, 21, 107, '华山镇'),
(32, 03, 21, 108, '梁寨镇'),
(32, 03, 21, 109, '范楼镇'),
(32, 03, 21, 111, '宋楼镇'),
(32, 03, 21, 112, '大沙河镇'),
(32, 03, 21, 113, '王沟镇'),
(32, 03, 21, 114, '赵庄镇');
/* 江苏省,徐州市,沛县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 22, 001, '沛城街道办事处'),
(32, 03, 22, 002, '大屯街道办事处'),
(32, 03, 22, 003, '汉源街道办事处'),
(32, 03, 22, 004, '汉兴街道办事处'),
(32, 03, 22, 101, '龙固镇'),
(32, 03, 22, 102, '杨屯镇'),
(32, 03, 22, 105, '胡寨镇'),
(32, 03, 22, 106, '魏庙镇'),
(32, 03, 22, 107, '五段镇'),
(32, 03, 22, 108, '张庄镇'),
(32, 03, 22, 109, '张寨镇'),
(32, 03, 22, 110, '敬安镇'),
(32, 03, 22, 111, '河口镇'),
(32, 03, 22, 112, '栖山镇'),
(32, 03, 22, 113, '鹿楼镇'),
(32, 03, 22, 114, '朱寨镇'),
(32, 03, 22, 115, '安国镇');
/* 江苏省,徐州市,睢宁县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 24, 101, '睢城镇'),
(32, 03, 24, 102, '王集镇'),
(32, 03, 24, 103, '双沟镇'),
(32, 03, 24, 104, '岚山镇'),
(32, 03, 24, 105, '李集镇'),
(32, 03, 24, 106, '桃园镇'),
(32, 03, 24, 107, '官山镇'),
(32, 03, 24, 108, '高作镇'),
(32, 03, 24, 109, '沙集镇'),
(32, 03, 24, 110, '凌城镇'),
(32, 03, 24, 111, '邱集镇'),
(32, 03, 24, 112, '古邳镇'),
(32, 03, 24, 113, '姚集镇'),
(32, 03, 24, 114, '魏集镇'),
(32, 03, 24, 115, '梁集镇'),
(32, 03, 24, 116, '庆安镇');
/* 江苏省,徐州市,新沂市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 81, 001, '新安街道办事处'),
(32, 03, 81, 002, '北沟街道办事处'),
(32, 03, 81, 003, '墨河街道办事处'),
(32, 03, 81, 004, '唐店街道办事处'),
(32, 03, 81, 102, '瓦窑镇'),
(32, 03, 81, 103, '港头镇'),
(32, 03, 81, 105, '合沟镇'),
(32, 03, 81, 106, '草桥镇'),
(32, 03, 81, 107, '窑湾镇'),
(32, 03, 81, 108, '棋盘镇'),
(32, 03, 81, 109, '马陵山镇'),
(32, 03, 81, 110, '新店镇'),
(32, 03, 81, 111, '邵店镇'),
(32, 03, 81, 113, '时集镇'),
(32, 03, 81, 114, '高流镇'),
(32, 03, 81, 115, '阿湖镇'),
(32, 03, 81, 116, '双塘镇');
/* 江苏省,徐州市,邳州市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 03, 82, 001, '东湖街道办事处'),
(32, 03, 82, 002, '运河街道办事处'),
(32, 03, 82, 003, '戴圩街道办事处'),
(32, 03, 82, 004, '炮车街道办事处'),
(32, 03, 82, 102, '邳城镇'),
(32, 03, 82, 103, '官湖镇'),
(32, 03, 82, 104, '四户镇'),
(32, 03, 82, 105, '宿羊山镇'),
(32, 03, 82, 106, '八义集镇'),
(32, 03, 82, 107, '土山镇'),
(32, 03, 82, 108, '碾庄镇'),
(32, 03, 82, 109, '港上镇'),
(32, 03, 82, 110, '邹庄镇'),
(32, 03, 82, 111, '占城镇'),
(32, 03, 82, 112, '新河镇'),
(32, 03, 82, 113, '八路镇'),
(32, 03, 82, 115, '铁富镇'),
(32, 03, 82, 116, '岔河镇'),
(32, 03, 82, 118, '陈楼镇'),
(32, 03, 82, 119, '邢楼镇'),
(32, 03, 82, 120, '戴庄镇'),
(32, 03, 82, 121, '车辐山镇'),
(32, 03, 82, 122, '燕子埠镇'),
(32, 03, 82, 123, '赵墩镇'),
(32, 03, 82, 124, '议堂镇');
/* 江苏省,常州市,天宁区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 04, 02, 001, '雕庄街道'),
(32, 04, 02, 002, '青龙街道'),
(32, 04, 02, 003, '茶山街道'),
(32, 04, 02, 004, '红梅街道'),
(32, 04, 02, 005, '天宁街道'),
(32, 04, 02, 006, '兰陵街道'),
(32, 04, 02, 109, '郑陆镇');
/* 江苏省,常州市,钟楼区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 04, 04, 001, '五星街道'),
(32, 04, 04, 002, '永红街道'),
(32, 04, 04, 003, '北港街道'),
(32, 04, 04, 004, '西林街道'),
(32, 04, 04, 005, '南大街街道'),
(32, 04, 04, 006, '荷花池街道'),
(32, 04, 04, 007, '新闸街道'),
(32, 04, 04, 116, '邹区镇');
/* 江苏省,常州市,新北区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 04, 11, 001, '河海街道'),
(32, 04, 11, 002, '三井街道'),
(32, 04, 11, 003, '龙虎塘街道'),
(32, 04, 11, 100, '春江镇'),
(32, 04, 11, 101, '孟河镇'),
(32, 04, 11, 102, '新桥镇'),
(32, 04, 11, 103, '薛家镇'),
(32, 04, 11, 104, '罗溪镇'),
(32, 04, 11, 105, '西夏墅镇'),
(32, 04, 11, 122, '奔牛镇');
/* 江苏省,常州市,武进区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 04, 12, 001, '戚墅堰街道'),
(32, 04, 12, 002, '丁堰街道'),
(32, 04, 12, 003, '潞城街道'),
(32, 04, 12, 100, '湖塘镇'),
(32, 04, 12, 102, '牛塘镇'),
(32, 04, 12, 103, '洛阳镇'),
(32, 04, 12, 104, '遥观镇'),
(32, 04, 12, 105, '横林镇'),
(32, 04, 12, 106, '横山桥镇'),
(32, 04, 12, 110, '雪堰镇'),
(32, 04, 12, 113, '前黄镇'),
(32, 04, 12, 114, '礼嘉镇'),
(32, 04, 12, 119, '嘉泽镇'),
(32, 04, 12, 120, '湟里镇');
/* 江苏省,常州市,金坛区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 04, 13, 001, '西城街道'),
(32, 04, 13, 100, '金城镇'),
(32, 04, 13, 104, '儒林镇'),
(32, 04, 13, 106, '直溪镇'),
(32, 04, 13, 108, '朱林镇'),
(32, 04, 13, 109, '薛埠镇'),
(32, 04, 13, 112, '指前镇');
/* 江苏省,常州市,溧阳市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 04, 81, 100, '溧城镇'),
(32, 04, 81, 101, '埭头镇'),
(32, 04, 81, 102, '上黄镇'),
(32, 04, 81, 103, '戴埠镇'),
(32, 04, 81, 106, '天目湖镇'),
(32, 04, 81, 107, '别桥镇'),
(32, 04, 81, 109, '上兴镇'),
(32, 04, 81, 111, '竹箦镇'),
(32, 04, 81, 114, '南渡镇'),
(32, 04, 81, 116, '社渚镇');
/* 江苏省,苏州市,虎丘区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 05, 001, '横塘街道'),
(32, 05, 05, 002, '狮山街道'),
(32, 05, 05, 003, '枫桥街道'),
(32, 05, 05, 004, '镇湖街道'),
(32, 05, 05, 100, '浒墅关镇'),
(32, 05, 05, 101, '通安镇'),
(32, 05, 05, 102, '东渚镇');
/* 江苏省,苏州市,吴中区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 06, 001, '长桥街道'),
(32, 05, 06, 003, '越溪街道'),
(32, 05, 06, 004, '郭巷街道'),
(32, 05, 06, 005, '横泾街道'),
(32, 05, 06, 006, '香山街道'),
(32, 05, 06, 009, '城南街道'),
(32, 05, 06, 100, '甪直镇'),
(32, 05, 06, 103, '木渎镇'),
(32, 05, 06, 104, '胥口镇'),
(32, 05, 06, 107, '东山镇'),
(32, 05, 06, 108, '光福镇'),
(32, 05, 06, 109, '金庭镇'),
(32, 05, 06, 110, '临湖镇');
/* 江苏省,苏州市,相城区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 07, 001, '元和街道'),
(32, 05, 07, 002, '太平街道'),
(32, 05, 07, 003, '黄桥街道'),
(32, 05, 07, 004, '北桥街道'),
(32, 05, 07, 005, '北河泾街道'),
(32, 05, 07, 006, '漕湖街道'),
(32, 05, 07, 100, '望亭镇'),
(32, 05, 07, 102, '黄埭镇'),
(32, 05, 07, 105, '渭塘镇'),
(32, 05, 07, 109, '阳澄湖镇');
/* 江苏省,苏州市,姑苏区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 08, 001, '双塔街道'),
(32, 05, 08, 002, '沧浪街道'),
(32, 05, 08, 003, '胥江街道'),
(32, 05, 08, 004, '吴门桥街道'),
(32, 05, 08, 005, '葑门街道'),
(32, 05, 08, 006, '友新街道'),
(32, 05, 08, 007, '观前街道'),
(32, 05, 08, 008, '平江街道'),
(32, 05, 08, 009, '苏锦街道'),
(32, 05, 08, 010, '娄门街道'),
(32, 05, 08, 011, '城北街道'),
(32, 05, 08, 012, '桃花坞街道'),
(32, 05, 08, 013, '石路街道'),
(32, 05, 08, 014, '金阊街道'),
(32, 05, 08, 015, '留园街道'),
(32, 05, 08, 016, '虎丘街道'),
(32, 05, 08, 017, '白洋湾街道');
/* 江苏省,苏州市,吴江区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 09, 100, '太湖新城镇'),
(32, 05, 09, 104, '平望镇'),
(32, 05, 09, 105, '盛泽镇'),
(32, 05, 09, 107, '七都镇'),
(32, 05, 09, 108, '震泽镇'),
(32, 05, 09, 109, '桃源镇'),
(32, 05, 09, 110, '黎里镇');
/* 江苏省,苏州市,常熟市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 81, 100, '虞山镇'),
(32, 05, 81, 101, '梅李镇'),
(32, 05, 81, 102, '海虞镇'),
(32, 05, 81, 104, '古里镇'),
(32, 05, 81, 105, '沙家浜镇'),
(32, 05, 81, 106, '支塘镇'),
(32, 05, 81, 107, '董浜镇'),
(32, 05, 81, 110, '辛庄镇'),
(32, 05, 81, 111, '尚湖镇');
/* 江苏省,苏州市,张家港市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 82, 100, '杨舍镇'),
(32, 05, 82, 101, '塘桥镇'),
(32, 05, 82, 102, '金港镇'),
(32, 05, 82, 103, '锦丰镇'),
(32, 05, 82, 104, '乐余镇'),
(32, 05, 82, 105, '凤凰镇'),
(32, 05, 82, 106, '南丰镇'),
(32, 05, 82, 107, '大新镇');
/* 江苏省,苏州市,昆山市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 83, 100, '玉山镇'),
(32, 05, 83, 101, '巴城镇'),
(32, 05, 83, 102, '周市镇'),
(32, 05, 83, 103, '陆家镇'),
(32, 05, 83, 104, '花桥镇'),
(32, 05, 83, 105, '淀山湖镇'),
(32, 05, 83, 106, '张浦镇'),
(32, 05, 83, 107, '周庄镇'),
(32, 05, 83, 108, '千灯镇'),
(32, 05, 83, 109, '锦溪镇');
/* 江苏省,苏州市,太仓市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 05, 85, 100, '城厢镇'),
(32, 05, 85, 101, '沙溪镇'),
(32, 05, 85, 102, '浏河镇'),
(32, 05, 85, 103, '浮桥镇'),
(32, 05, 85, 104, '璜泾镇'),
(32, 05, 85, 105, '双凤镇');
/* 江苏省,南通市,崇川区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 06, 02, 001, '城东街道'),
(32, 06, 02, 002, '和平桥街道'),
(32, 06, 02, 003, '任港街道'),
(32, 06, 02, 004, '新城桥街道'),
(32, 06, 02, 005, '虹桥街道'),
(32, 06, 02, 006, '学田街道'),
(32, 06, 02, 007, '钟秀街道'),
(32, 06, 02, 008, '文峰街道'),
(32, 06, 02, 009, '观音山街道'),
(32, 06, 02, 010, '狼山镇街道');
/* 江苏省,南通市,港闸区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 06, 11, 001, '永兴街道'),
(32, 06, 11, 002, '唐闸镇街道'),
(32, 06, 11, 003, '天生港镇街道'),
(32, 06, 11, 004, '秦灶街道'),
(32, 06, 11, 005, '陈桥街道'),
(32, 06, 11, 006, '幸福街道');
/* 江苏省,南通市,通州区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 06, 12, 001, '金沙街道'),
(32, 06, 12, 002, '兴东街道'),
(32, 06, 12, 003, '先锋街道'),
(32, 06, 12, 004, '金新街道'),
(32, 06, 12, 101, '西亭镇'),
(32, 06, 12, 102, '二甲镇'),
(32, 06, 12, 103, '东社镇'),
(32, 06, 12, 104, '三余镇'),
(32, 06, 12, 107, '十总镇'),
(32, 06, 12, 110, '石港镇'),
(32, 06, 12, 112, '刘桥镇'),
(32, 06, 12, 114, '平潮镇'),
(32, 06, 12, 116, '五接镇'),
(32, 06, 12, 117, '兴仁镇'),
(32, 06, 12, 119, '张芝山镇'),
(32, 06, 12, 120, '川姜镇');
/* 江苏省,南通市,海安县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 06, 21, 100, '海安镇'),
(32, 06, 21, 101, '城东镇'),
(32, 06, 21, 102, '曲塘镇'),
(32, 06, 21, 103, '李堡镇'),
(32, 06, 21, 105, '角斜镇'),
(32, 06, 21, 107, '大公镇'),
(32, 06, 21, 109, '雅周镇'),
(32, 06, 21, 111, '白甸镇'),
(32, 06, 21, 112, '南莫镇'),
(32, 06, 21, 113, '墩头镇');
/* 江苏省,南通市,如东县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 06, 23, 100, '栟茶镇'),
(32, 06, 23, 101, '洋口镇'),
(32, 06, 23, 102, '苴镇'),
(32, 06, 23, 103, '长沙镇'),
(32, 06, 23, 104, '大豫镇'),
(32, 06, 23, 105, '掘港镇'),
(32, 06, 23, 107, '马塘镇'),
(32, 06, 23, 108, '丰利镇'),
(32, 06, 23, 109, '曹埠镇'),
(32, 06, 23, 110, '岔河镇'),
(32, 06, 23, 111, '双甸镇'),
(32, 06, 23, 112, '新店镇'),
(32, 06, 23, 113, '河口镇'),
(32, 06, 23, 114, '袁庄镇');
/* 江苏省,南通市,启东市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 06, 81, 100, '汇龙镇'),
(32, 06, 81, 102, '惠萍镇'),
(32, 06, 81, 104, '东海镇'),
(32, 06, 81, 106, '南阳镇'),
(32, 06, 81, 107, '海复镇'),
(32, 06, 81, 108, '合作镇'),
(32, 06, 81, 109, '王鲍镇'),
(32, 06, 81, 110, '吕四港镇');
/* 江苏省,南通市,如皋市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 06, 82, 001, '如城街道'),
(32, 06, 82, 103, '东陈镇'),
(32, 06, 82, 104, '丁堰镇'),
(32, 06, 82, 105, '白蒲镇'),
(32, 06, 82, 107, '下原镇'),
(32, 06, 82, 108, '九华镇'),
(32, 06, 82, 110, '石庄镇'),
(32, 06, 82, 111, '长江镇'),
(32, 06, 82, 112, '吴窑镇'),
(32, 06, 82, 113, '江安镇'),
(32, 06, 82, 116, '搬经镇'),
(32, 06, 82, 117, '磨头镇');
/* 江苏省,南通市,海门市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 06, 84, 106, '常乐镇'),
(32, 06, 84, 108, '悦来镇'),
(32, 06, 84, 111, '四甲镇'),
(32, 06, 84, 113, '余东镇'),
(32, 06, 84, 114, '正余镇'),
(32, 06, 84, 117, '海永镇');
/* 江苏省,连云港市,连云区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 07, 03, 001, '墟沟街道'),
(32, 07, 03, 003, '连云街道'),
(32, 07, 03, 004, '云山街道'),
(32, 07, 03, 005, '板桥街道'),
(32, 07, 03, 006, '连岛街道'),
(32, 07, 03, 007, '徐圩街道'),
(32, 07, 03, 008, '海州湾街道'),
(32, 07, 03, 009, '宿城街道'),
(32, 07, 03, 010, '高公岛街道'),
(32, 07, 03, 203, '前三岛乡');
/* 江苏省,连云港市,海州区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 07, 06, 001, '朐阳街道'),
(32, 07, 06, 002, '浦西街道'),
(32, 07, 06, 003, '新东街道'),
(32, 07, 06, 004, '新南街道'),
(32, 07, 06, 005, '路南街道'),
(32, 07, 06, 006, '新海街道'),
(32, 07, 06, 007, '南城街道'),
(32, 07, 06, 008, '花果山街道'),
(32, 07, 06, 009, '云台街道'),
(32, 07, 06, 010, '新浦街道'),
(32, 07, 06, 011, '海州街道'),
(32, 07, 06, 012, '幸福路街道'),
(32, 07, 06, 013, '洪门街道'),
(32, 07, 06, 014, '宁海街道'),
(32, 07, 06, 100, '锦屏镇'),
(32, 07, 06, 101, '浦南镇'),
(32, 07, 06, 102, '新坝镇'),
(32, 07, 06, 103, '板浦镇');
/* 江苏省,连云港市,赣榆区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 07, 07, 100, '青口镇'),
(32, 07, 07, 101, '柘汪镇'),
(32, 07, 07, 102, '石桥镇'),
(32, 07, 07, 103, '金山镇'),
(32, 07, 07, 104, '黑林镇'),
(32, 07, 07, 105, '厉庄镇'),
(32, 07, 07, 106, '海头镇'),
(32, 07, 07, 107, '塔山镇'),
(32, 07, 07, 108, '赣马镇'),
(32, 07, 07, 109, '班庄镇'),
(32, 07, 07, 110, '城头镇'),
(32, 07, 07, 112, '城西镇'),
(32, 07, 07, 114, '宋庄镇'),
(32, 07, 07, 115, '沙河镇'),
(32, 07, 07, 116, '墩尚镇');
/* 江苏省,连云港市,东海县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 07, 22, 001, '牛山街道办事处'),
(32, 07, 22, 002, '石榴街道办事处'),
(32, 07, 22, 101, '白塔埠镇'),
(32, 07, 22, 103, '黄川镇'),
(32, 07, 22, 104, '石梁河镇'),
(32, 07, 22, 105, '青湖镇'),
(32, 07, 22, 107, '温泉镇'),
(32, 07, 22, 108, '双店镇'),
(32, 07, 22, 109, '桃林镇'),
(32, 07, 22, 110, '洪庄镇'),
(32, 07, 22, 111, '安峰镇'),
(32, 07, 22, 112, '房山镇'),
(32, 07, 22, 113, '平明镇'),
(32, 07, 22, 200, '驼峰乡'),
(32, 07, 22, 203, '李埝乡'),
(32, 07, 22, 204, '山左口乡'),
(32, 07, 22, 205, '石湖乡'),
(32, 07, 22, 206, '曲阳乡'),
(32, 07, 22, 207, '张湾乡');
/* 江苏省,连云港市,灌云县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 07, 23, 100, '伊山镇'),
(32, 07, 23, 102, '杨集镇'),
(32, 07, 23, 103, '燕尾港镇'),
(32, 07, 23, 104, '同兴镇'),
(32, 07, 23, 105, '四队镇'),
(32, 07, 23, 106, '圩丰镇'),
(32, 07, 23, 107, '龙苴镇'),
(32, 07, 23, 108, '下车镇'),
(32, 07, 23, 203, '图河乡'),
(32, 07, 23, 207, '东王集乡'),
(32, 07, 23, 208, '侍庄乡'),
(32, 07, 23, 209, '小伊乡'),
(32, 07, 23, 212, '南岗乡');
/* 江苏省,连云港市,灌南县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 07, 24, 100, '新安镇'),
(32, 07, 24, 101, '堆沟港镇'),
(32, 07, 24, 102, '田楼镇'),
(32, 07, 24, 103, '北陈集镇'),
(32, 07, 24, 104, '张店镇'),
(32, 07, 24, 105, '三口镇'),
(32, 07, 24, 106, '孟兴庄镇'),
(32, 07, 24, 107, '汤沟镇'),
(32, 07, 24, 108, '百禄镇'),
(32, 07, 24, 109, '新集镇'),
(32, 07, 24, 204, '李集乡');
/* 江苏省,淮安市,清河区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 08, 02, 001, '府前街道办事处'),
(32, 08, 02, 002, '长西街道办事处'),
(32, 08, 02, 003, '淮海街道办事处'),
(32, 08, 02, 004, '长东街道办事处'),
(32, 08, 02, 005, '柳树湾街道办事处'),
(32, 08, 02, 006, '水渡口街道办事处'),
(32, 08, 02, 007, '白鹭湖街道办事处');
/* 江苏省,淮安市,淮安区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 08, 03, 100, '淮城镇'),
(32, 08, 03, 101, '平桥镇'),
(32, 08, 03, 102, '上河镇'),
(32, 08, 03, 103, '马甸镇'),
(32, 08, 03, 104, '朱桥镇'),
(32, 08, 03, 105, '溪河镇'),
(32, 08, 03, 106, '施河镇'),
(32, 08, 03, 107, '车桥镇'),
(32, 08, 03, 108, '泾口镇'),
(32, 08, 03, 109, '流均镇'),
(32, 08, 03, 110, '博里镇'),
(32, 08, 03, 111, '仇桥镇'),
(32, 08, 03, 112, '复兴镇'),
(32, 08, 03, 113, '苏嘴镇'),
(32, 08, 03, 114, '钦工镇'),
(32, 08, 03, 115, '顺河镇'),
(32, 08, 03, 116, '季桥镇'),
(32, 08, 03, 117, '席桥镇'),
(32, 08, 03, 118, '林集镇'),
(32, 08, 03, 119, '南闸镇'),
(32, 08, 03, 200, '建淮乡'),
(32, 08, 03, 201, '茭陵乡'),
(32, 08, 03, 202, '宋集乡'),
(32, 08, 03, 203, '城东乡'),
(32, 08, 03, 204, '三堡乡');
/* 江苏省,淮安市,淮阴区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 08, 04, 100, '王营镇'),
(32, 08, 04, 101, '赵集镇'),
(32, 08, 04, 102, '吴城镇'),
(32, 08, 04, 103, '南陈集镇'),
(32, 08, 04, 104, '码头镇'),
(32, 08, 04, 105, '王兴镇'),
(32, 08, 04, 106, '棉花庄镇'),
(32, 08, 04, 107, '丁集镇'),
(32, 08, 04, 108, '五里镇'),
(32, 08, 04, 109, '徐溜镇'),
(32, 08, 04, 110, '渔沟镇'),
(32, 08, 04, 111, '吴集镇'),
(32, 08, 04, 112, '西宋集镇'),
(32, 08, 04, 113, '三树镇'),
(32, 08, 04, 200, '韩桥乡'),
(32, 08, 04, 201, '新渡乡'),
(32, 08, 04, 202, '老张集乡'),
(32, 08, 04, 203, '凌桥乡'),
(32, 08, 04, 204, '袁集乡'),
(32, 08, 04, 205, '刘老庄乡'),
(32, 08, 04, 206, '古寨乡');
/* 江苏省,淮安市,青浦区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 08, 11, 001, '清江街道办事处'),
(32, 08, 11, 002, '浦楼街道办事处'),
(32, 08, 11, 003, '闸口街道办事处'),
(32, 08, 11, 004, '清安街道办事处'),
(32, 08, 11, 100, '和平镇'),
(32, 08, 11, 101, '武墩镇'),
(32, 08, 11, 102, '盐河镇'),
(32, 08, 11, 200, '城南乡'),
(32, 08, 11, 201, '黄码乡');
/* 江苏省,淮安市,涟水县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 08, 26, 100, '涟城镇'),
(32, 08, 26, 101, '高沟镇'),
(32, 08, 26, 102, '唐集镇'),
(32, 08, 26, 103, '保滩镇'),
(32, 08, 26, 104, '大东镇'),
(32, 08, 26, 105, '五港镇'),
(32, 08, 26, 106, '梁岔镇'),
(32, 08, 26, 107, '石湖镇'),
(32, 08, 26, 108, '朱码镇'),
(32, 08, 26, 109, '岔庙镇'),
(32, 08, 26, 110, '东胡集镇'),
(32, 08, 26, 111, '南集镇'),
(32, 08, 26, 112, '义兴镇'),
(32, 08, 26, 113, '成集镇'),
(32, 08, 26, 114, '红窑镇'),
(32, 08, 26, 115, '陈师镇'),
(32, 08, 26, 116, '前进镇'),
(32, 08, 26, 200, '徐集乡'),
(32, 08, 26, 201, '黄营乡');
/* 江苏省,淮安市,洪泽县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 08, 29, 001, '高良涧街道'),
(32, 08, 29, 002, '朱坝街道'),
(32, 08, 29, 003, '黄集街道'),
(32, 08, 29, 101, '蒋坝镇'),
(32, 08, 29, 103, '岔河镇'),
(32, 08, 29, 104, '西顺河镇'),
(32, 08, 29, 105, '老子山镇'),
(32, 08, 29, 106, '三河镇'),
(32, 08, 29, 110, '东双沟镇');
/* 江苏省,淮安市,盱眙县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 08, 30, 001, '盱城街道'),
(32, 08, 30, 002, '太和街道'),
(32, 08, 30, 003, '古桑街道'),
(32, 08, 30, 101, '马坝镇'),
(32, 08, 30, 102, '官滩镇'),
(32, 08, 30, 103, '旧铺镇'),
(32, 08, 30, 104, '桂五镇'),
(32, 08, 30, 105, '管镇镇'),
(32, 08, 30, 106, '河桥镇'),
(32, 08, 30, 107, '鲍集镇'),
(32, 08, 30, 108, '黄花塘镇'),
(32, 08, 30, 109, '明祖陵镇'),
(32, 08, 30, 110, '铁佛镇'),
(32, 08, 30, 111, '淮河镇'),
(32, 08, 30, 112, '仇集镇'),
(32, 08, 30, 113, '观音寺镇'),
(32, 08, 30, 114, '天泉湖镇'),
(32, 08, 30, 200, '维桥乡'),
(32, 08, 30, 201, '穆店乡'),
(32, 08, 30, 204, '兴隆乡');
/* 江苏省,淮安市,金湖县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 08, 31, 100, '黎城镇'),
(32, 08, 31, 101, '金南镇'),
(32, 08, 31, 102, '闵桥镇'),
(32, 08, 31, 103, '塔集镇'),
(32, 08, 31, 106, '前锋镇'),
(32, 08, 31, 107, '吕良镇'),
(32, 08, 31, 108, '陈桥镇'),
(32, 08, 31, 109, '金北镇'),
(32, 08, 31, 110, '戴楼镇'),
(32, 08, 31, 111, '银涂镇');
/* 江苏省,盐城市,亭湖区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(32, 09, 02, 001, '五星街道'),
(32, 09, 02, 002, '文峰街道'),
(32, 09, 02, 003, '先锋街道'),