-
Notifications
You must be signed in to change notification settings - Fork 8
Expand file tree
/
Copy pathAdministratives-China(Street)-7.sql
More file actions
8615 lines (8210 loc) · 297 KB
/
Administratives-China(Street)-7.sql
File metadata and controls
8615 lines (8210 loc) · 297 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)
* 数据范围:四川省(51)、贵州省(52)、云南省(53)。
*/
/* 四川省 成都市 锦江区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 04, 020, '督院街街道办事处'),
(51, 01, 04, 021, '盐市口街道办事处'),
(51, 01, 04, 022, '春熙路街道办事处'),
(51, 01, 04, 023, '书院街街道办事处'),
(51, 01, 04, 024, '合江亭街道办事处'),
(51, 01, 04, 025, '水井坊街道办事处'),
(51, 01, 04, 026, '牛市口街道办事处'),
(51, 01, 04, 027, '龙舟路街道办事处'),
(51, 01, 04, 028, '双桂路街道办事处'),
(51, 01, 04, 029, '莲新街道办事处'),
(51, 01, 04, 030, '沙河街道办事处'),
(51, 01, 04, 031, '东光街道办事处'),
(51, 01, 04, 032, '狮子山街道办事处'),
(51, 01, 04, 035, '成龙路街道办事处'),
(51, 01, 04, 036, '柳江街道办事处'),
(51, 01, 04, 037, '三圣街道办事处');
/* 四川省 成都市 青羊区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 05, 001, '太升路街道办事处'),
(51, 01, 05, 002, '草市街街道办事处'),
(51, 01, 05, 003, '西御河街道办事处'),
(51, 01, 05, 004, '汪家拐街道办事处'),
(51, 01, 05, 005, '少城街道办事处'),
(51, 01, 05, 006, '新华西路街道办事处'),
(51, 01, 05, 007, '草堂街道办事处'),
(51, 01, 05, 008, '府南街道办事处'),
(51, 01, 05, 009, '光华街道办事处'),
(51, 01, 05, 010, '东坡街道办事处'),
(51, 01, 05, 011, '金沙街道办事处'),
(51, 01, 05, 012, '黄田坝街道办事处'),
(51, 01, 05, 013, '苏坡街道办事处'),
(51, 01, 05, 014, '文家街道办事处');
/* 四川省 成都市 金牛区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 06, 024, '西安路街道'),
(51, 01, 06, 025, '西华街道'),
(51, 01, 06, 026, '人民北路街道'),
(51, 01, 06, 027, '荷花池街道'),
(51, 01, 06, 030, '驷马桥街道'),
(51, 01, 06, 031, '茶店子街道'),
(51, 01, 06, 032, '抚琴街道'),
(51, 01, 06, 035, '九里堤街道'),
(51, 01, 06, 036, '五块石街道'),
(51, 01, 06, 037, '黄忠街道'),
(51, 01, 06, 038, '营门口街道'),
(51, 01, 06, 040, '金泉街道'),
(51, 01, 06, 041, '沙河源街道'),
(51, 01, 06, 042, '天回镇街道'),
(51, 01, 06, 043, '凤凰山街道');
/* 四川省 成都市 武侯区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 07, 001, '浆洗街街道办事处'),
(51, 01, 07, 004, '望江路街道办事处'),
(51, 01, 07, 005, '玉林街道办事处'),
(51, 01, 07, 006, '跳伞塔街道办事处'),
(51, 01, 07, 007, '火车南站街道办事处'),
(51, 01, 07, 008, '双楠街道办事处'),
(51, 01, 07, 009, '晋阳街道办事处'),
(51, 01, 07, 010, '红牌楼街道办事处'),
(51, 01, 07, 011, '簇桥街道办事处'),
(51, 01, 07, 012, '机投桥街道办事处'),
(51, 01, 07, 013, '金花桥街道办事处'),
(51, 01, 07, 014, '簇锦街道办事处'),
(51, 01, 07, 015, '华兴街道办事处'),
(51, 01, 07, 061, '芳草街道办事处'),
(51, 01, 07, 062, '肖家河街道办事处'),
(51, 01, 07, 063, '石羊场街道办事处'),
(51, 01, 07, 064, '桂溪街道办事处');
/* 四川省 成都市 成华区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 08, 002, '猛追湾街道'),
(51, 01, 08, 004, '双桥子街道'),
(51, 01, 08, 005, '建设路街道'),
(51, 01, 08, 006, '府青路街道'),
(51, 01, 08, 007, '二仙桥街道'),
(51, 01, 08, 008, '跳蹬河街道'),
(51, 01, 08, 010, '双水碾街道'),
(51, 01, 08, 011, '万年场街道'),
(51, 01, 08, 012, '桃蹊路街道'),
(51, 01, 08, 013, '圣灯街道'),
(51, 01, 08, 014, '保和街道'),
(51, 01, 08, 015, '青龙街道'),
(51, 01, 08, 016, '龙潭街道'),
(51, 01, 08, 017, '白莲池街道');
/* 四川省 成都市 龙泉驿区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 12, 001, '龙泉街道办事处'),
(51, 01, 12, 002, '大面街道办事处'),
(51, 01, 12, 003, '十陵街道办事处'),
(51, 01, 12, 004, '同安街道办事处'),
(51, 01, 12, 102, '洛带镇'),
(51, 01, 12, 104, '西河镇'),
(51, 01, 12, 108, '洪安镇'),
(51, 01, 12, 109, '柏合镇'),
(51, 01, 12, 110, '茶店镇'),
(51, 01, 12, 111, '黄土镇'),
(51, 01, 12, 115, '山泉镇'),
(51, 01, 12, 200, '万兴乡');
/* 四川省 成都市 青白江区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 13, 001, '红阳街道办事处'),
(51, 01, 13, 002, '大弯街道办事处'),
(51, 01, 13, 102, '弥牟镇'),
(51, 01, 13, 103, '大同镇'),
(51, 01, 13, 104, '城厢镇'),
(51, 01, 13, 105, '祥福镇'),
(51, 01, 13, 106, '姚渡镇'),
(51, 01, 13, 108, '清泉镇'),
(51, 01, 13, 110, '龙王镇'),
(51, 01, 13, 111, '福洪镇'),
(51, 01, 13, 203, '人和乡');
/* 四川省 成都市 新都区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 14, 001, '大丰街道办事处'),
(51, 01, 14, 003, '三河街道办事处'),
(51, 01, 14, 004, '新都街道办事处'),
(51, 01, 14, 102, '石板滩镇'),
(51, 01, 14, 103, '新繁镇'),
(51, 01, 14, 104, '新民镇'),
(51, 01, 14, 106, '泰兴镇'),
(51, 01, 14, 108, '斑竹园镇'),
(51, 01, 14, 109, '清流镇'),
(51, 01, 14, 111, '马家镇'),
(51, 01, 14, 112, '龙桥镇'),
(51, 01, 14, 114, '木兰镇'),
(51, 01, 14, 116, '军屯镇');
/* 四川省 成都市 温江区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 15, 001, '柳城街道办事处'),
(51, 01, 15, 002, '公平街道办事处'),
(51, 01, 15, 003, '涌泉街道办事处'),
(51, 01, 15, 004, '天府街道办事处'),
(51, 01, 15, 101, '和盛镇'),
(51, 01, 15, 102, '永盛镇'),
(51, 01, 15, 103, '金马镇'),
(51, 01, 15, 104, '永宁镇'),
(51, 01, 15, 105, '万春镇'),
(51, 01, 15, 106, '寿安镇');
/* 四川省 成都市 金堂县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 21, 001, '赵镇街道办事处'),
(51, 01, 21, 101, '三星镇'),
(51, 01, 21, 102, '清江镇'),
(51, 01, 21, 103, '官仓镇'),
(51, 01, 21, 104, '淮口镇'),
(51, 01, 21, 105, '白果镇'),
(51, 01, 21, 106, '五凤镇'),
(51, 01, 21, 108, '高板镇'),
(51, 01, 21, 109, '三溪镇'),
(51, 01, 21, 110, '福兴镇'),
(51, 01, 21, 111, '金龙镇'),
(51, 01, 21, 112, '赵家镇'),
(51, 01, 21, 113, '竹篙镇'),
(51, 01, 21, 114, '广兴镇'),
(51, 01, 21, 115, '隆盛镇'),
(51, 01, 21, 116, '转龙镇'),
(51, 01, 21, 117, '土桥镇'),
(51, 01, 21, 118, '云合镇'),
(51, 01, 21, 119, '又新镇'),
(51, 01, 21, 200, '栖贤乡'),
(51, 01, 21, 203, '平桥乡');
/* 四川省 成都市 双流县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 22, 001, '东升街道办'),
(51, 01, 22, 002, '西航港街道办'),
(51, 01, 22, 003, '华阳镇街道办'),
(51, 01, 22, 004, '中和街道办'),
(51, 01, 22, 005, '九江街道办事处'),
(51, 01, 22, 006, '黄甲街道办事处'),
(51, 01, 22, 007, '公兴街道办事处'),
(51, 01, 22, 008, '协和街道办事处'),
(51, 01, 22, 101, '太平镇'),
(51, 01, 22, 102, '永兴镇'),
(51, 01, 22, 106, '籍田镇'),
(51, 01, 22, 107, '正兴镇'),
(51, 01, 22, 108, '彭镇'),
(51, 01, 22, 109, '大林镇'),
(51, 01, 22, 110, '煎茶镇'),
(51, 01, 22, 111, '黄龙溪镇'),
(51, 01, 22, 112, '永安镇'),
(51, 01, 22, 115, '黄水镇'),
(51, 01, 22, 116, '金桥镇'),
(51, 01, 22, 119, '胜利镇'),
(51, 01, 22, 120, '新兴镇'),
(51, 01, 22, 121, '兴隆镇'),
(51, 01, 22, 122, '万安镇'),
(51, 01, 22, 123, '白沙镇'),
(51, 01, 22, 124, '三星镇'),
(51, 01, 22, 125, '合江镇');
/* 四川省 成都市 郫县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 24, 001, '郫筒街道办事处'),
(51, 01, 24, 019, '合作街道办事处'),
(51, 01, 24, 020, '西园街道办事处'),
(51, 01, 24, 101, '团结镇'),
(51, 01, 24, 102, '犀浦镇'),
(51, 01, 24, 103, '花园镇'),
(51, 01, 24, 104, '唐昌镇'),
(51, 01, 24, 105, '安德镇'),
(51, 01, 24, 106, '三道堰镇'),
(51, 01, 24, 107, '安靖镇'),
(51, 01, 24, 108, '红光镇'),
(51, 01, 24, 110, '新民场镇'),
(51, 01, 24, 112, '德源镇'),
(51, 01, 24, 115, '友爱镇'),
(51, 01, 24, 117, '古城镇'),
(51, 01, 24, 118, '唐元镇');
/* 四川省 成都市 大邑县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 29, 001, '晋原镇街道办事处'),
(51, 01, 29, 101, '王泗镇'),
(51, 01, 29, 103, '新场镇'),
(51, 01, 29, 104, '悦来镇'),
(51, 01, 29, 105, '安仁镇'),
(51, 01, 29, 106, '出江镇'),
(51, 01, 29, 107, '花水湾镇'),
(51, 01, 29, 108, '西岭镇'),
(51, 01, 29, 109, '斜源镇'),
(51, 01, 29, 110, '董场镇'),
(51, 01, 29, 111, '韩场镇'),
(51, 01, 29, 112, '三岔镇'),
(51, 01, 29, 113, '上安镇'),
(51, 01, 29, 114, '苏家镇'),
(51, 01, 29, 115, '青霞镇'),
(51, 01, 29, 116, '沙渠镇'),
(51, 01, 29, 118, '蔡场镇'),
(51, 01, 29, 202, '雾山乡'),
(51, 01, 29, 203, '金星乡'),
(51, 01, 29, 205, '鹤鸣乡');
/* 四川省 成都市 蒲江县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 31, 001, '鹤山街道'),
(51, 01, 31, 101, '大塘镇'),
(51, 01, 31, 102, '寿安镇'),
(51, 01, 31, 103, '朝阳湖镇'),
(51, 01, 31, 104, '西来镇'),
(51, 01, 31, 105, '大兴镇'),
(51, 01, 31, 106, '甘溪镇'),
(51, 01, 31, 107, '成佳镇'),
(51, 01, 31, 200, '复兴乡'),
(51, 01, 31, 201, '光明乡'),
(51, 01, 31, 202, '白云乡'),
(51, 01, 31, 203, '长秋乡');
/* 四川省 成都市 新津县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 32, 100, '五津镇'),
(51, 01, 32, 101, '花桥镇'),
(51, 01, 32, 102, '花源镇'),
(51, 01, 32, 103, '金华镇'),
(51, 01, 32, 104, '普兴镇'),
(51, 01, 32, 105, '兴义镇'),
(51, 01, 32, 106, '新平镇'),
(51, 01, 32, 107, '方兴镇'),
(51, 01, 32, 108, '安西镇'),
(51, 01, 32, 109, '永商镇'),
(51, 01, 32, 110, '邓双镇'),
(51, 01, 32, 202, '文井乡');
/* 四川省 成都市 都江堰市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 81, 001, '奎光塔街道办事处'),
(51, 01, 81, 002, '幸福街道办事处'),
(51, 01, 81, 003, '永丰街道办事处'),
(51, 01, 81, 004, '灌口街道办事处'),
(51, 01, 81, 005, '银杏街道办事处'),
(51, 01, 81, 102, '蒲阳镇'),
(51, 01, 81, 103, '聚源镇'),
(51, 01, 81, 104, '崇义镇'),
(51, 01, 81, 105, '天马镇'),
(51, 01, 81, 106, '石羊镇'),
(51, 01, 81, 107, '柳街镇'),
(51, 01, 81, 108, '玉堂镇'),
(51, 01, 81, 109, '中兴镇'),
(51, 01, 81, 110, '青城山镇'),
(51, 01, 81, 111, '龙池镇'),
(51, 01, 81, 112, '胥家镇'),
(51, 01, 81, 113, '安龙镇'),
(51, 01, 81, 114, '大观镇'),
(51, 01, 81, 202, '向峨乡');
/* 四川省 成都市 彭州市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 82, 100, '天彭镇'),
(51, 01, 82, 101, '龙门山镇'),
(51, 01, 82, 102, '新兴镇'),
(51, 01, 82, 103, '丽春镇'),
(51, 01, 82, 104, '九尺镇'),
(51, 01, 82, 105, '蒙阳镇'),
(51, 01, 82, 106, '通济镇'),
(51, 01, 82, 107, '丹景山镇'),
(51, 01, 82, 108, '隆丰镇'),
(51, 01, 82, 109, '敖平镇'),
(51, 01, 82, 110, '磁峰镇'),
(51, 01, 82, 111, '桂花镇'),
(51, 01, 82, 113, '军乐镇'),
(51, 01, 82, 114, '三界镇'),
(51, 01, 82, 116, '小渔洞镇'),
(51, 01, 82, 118, '红岩镇'),
(51, 01, 82, 120, '升平镇'),
(51, 01, 82, 121, '白鹿镇'),
(51, 01, 82, 123, '葛仙山镇'),
(51, 01, 82, 126, '致和镇');
/* 四川省 成都市 邛崃市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 83, 100, '临邛镇'),
(51, 01, 83, 101, '羊安镇'),
(51, 01, 83, 102, '牟礼镇'),
(51, 01, 83, 103, '桑园镇'),
(51, 01, 83, 104, '平乐镇'),
(51, 01, 83, 105, '夹关镇'),
(51, 01, 83, 106, '火井镇'),
(51, 01, 83, 107, '水口镇'),
(51, 01, 83, 108, '固驿镇'),
(51, 01, 83, 109, '冉义镇'),
(51, 01, 83, 110, '回龙镇'),
(51, 01, 83, 111, '高埂镇'),
(51, 01, 83, 112, '前进镇'),
(51, 01, 83, 113, '高何镇'),
(51, 01, 83, 115, '临济镇'),
(51, 01, 83, 116, '卧龙镇'),
(51, 01, 83, 118, '天台山镇'),
(51, 01, 83, 120, '宝林镇'),
(51, 01, 83, 201, '茶园乡'),
(51, 01, 83, 206, '道佐乡'),
(51, 01, 83, 209, '油榨乡'),
(51, 01, 83, 211, '南宝乡'),
(51, 01, 83, 212, '大同乡'),
(51, 01, 83, 214, '孔明乡');
/* 四川省 成都市 崇州市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 01, 84, 001, '崇阳街道办事处'),
(51, 01, 84, 101, '三江镇'),
(51, 01, 84, 102, '江源镇'),
(51, 01, 84, 103, '羊马镇'),
(51, 01, 84, 104, '廖家镇'),
(51, 01, 84, 105, '元通镇'),
(51, 01, 84, 106, '观胜镇'),
(51, 01, 84, 107, '怀远镇'),
(51, 01, 84, 108, '三郎镇'),
(51, 01, 84, 109, '街子镇'),
(51, 01, 84, 110, '文井江镇'),
(51, 01, 84, 111, '王场镇'),
(51, 01, 84, 112, '白头镇'),
(51, 01, 84, 113, '道明镇'),
(51, 01, 84, 114, '隆兴镇'),
(51, 01, 84, 116, '大划镇'),
(51, 01, 84, 117, '崇平镇'),
(51, 01, 84, 118, '梓潼镇'),
(51, 01, 84, 119, '桤泉镇'),
(51, 01, 84, 201, '锦江乡'),
(51, 01, 84, 202, '公议乡'),
(51, 01, 84, 206, '鸡冠山乡'),
(51, 01, 84, 208, '济协乡'),
(51, 01, 84, 209, '燎原乡'),
(51, 01, 84, 211, '集贤乡');
/* 四川省 自贡市 自流井区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 03, 02, 001, '五星街街道'),
(51, 03, 02, 002, '东兴寺街道'),
(51, 03, 02, 003, '新街街道'),
(51, 03, 02, 004, '郭家坳街街道'),
(51, 03, 02, 005, '丹桂街道'),
(51, 03, 02, 006, '学苑街道'),
(51, 03, 02, 101, '仲权镇'),
(51, 03, 02, 102, '舒坪镇'),
(51, 03, 02, 103, '荣边镇'),
(51, 03, 02, 201, '红旗乡'),
(51, 03, 02, 202, '高峰乡'),
(51, 03, 02, 203, '农团乡'),
(51, 03, 02, 204, '漆树乡');
/* 四川省 自贡市 贡井区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 03, 03, 001, '筱溪街道'),
(51, 03, 03, 002, '贡井街道'),
(51, 03, 03, 100, '艾叶镇'),
(51, 03, 03, 101, '建设镇'),
(51, 03, 03, 102, '长土镇'),
(51, 03, 03, 104, '龙潭镇'),
(51, 03, 03, 105, '桥头镇'),
(51, 03, 03, 106, '五宝镇'),
(51, 03, 03, 107, '莲花镇'),
(51, 03, 03, 108, '成佳镇'),
(51, 03, 03, 109, '白庙镇'),
(51, 03, 03, 200, '章佳乡'),
(51, 03, 03, 201, '牛尾乡');
/* 四川省 自贡市 大安区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 03, 04, 001, '大安街道'),
(51, 03, 04, 002, '龙井街道'),
(51, 03, 04, 003, '马冲口街道'),
(51, 03, 04, 004, '凉高山街道'),
(51, 03, 04, 100, '大山铺镇'),
(51, 03, 04, 102, '团结镇'),
(51, 03, 04, 103, '三多寨镇'),
(51, 03, 04, 104, '何市镇'),
(51, 03, 04, 105, '新店镇'),
(51, 03, 04, 106, '新民镇'),
(51, 03, 04, 107, '牛佛镇'),
(51, 03, 04, 108, '庙坝镇'),
(51, 03, 04, 109, '回龙镇'),
(51, 03, 04, 204, '永嘉乡'),
(51, 03, 04, 205, '和平乡'),
(51, 03, 04, 207, '凤凰乡');
/* 四川省 自贡市 沿滩区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 03, 11, 100, '沿滩镇'),
(51, 03, 11, 101, '卫坪镇'),
(51, 03, 11, 102, '兴隆镇'),
(51, 03, 11, 105, '富全镇'),
(51, 03, 11, 106, '永安镇'),
(51, 03, 11, 107, '联络镇'),
(51, 03, 11, 108, '邓关镇'),
(51, 03, 11, 109, '王井镇'),
(51, 03, 11, 110, '黄市镇'),
(51, 03, 11, 111, '瓦市镇'),
(51, 03, 11, 112, '仙市镇'),
(51, 03, 11, 203, '刘山乡'),
(51, 03, 11, 204, '九洪乡');
/* 四川省 自贡市 荣县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 03, 21, 100, '旭阳镇'),
(51, 03, 21, 102, '双石镇'),
(51, 03, 21, 103, '望佳镇'),
(51, 03, 21, 107, '鼎新镇'),
(51, 03, 21, 110, '乐德镇'),
(51, 03, 21, 111, '过水镇'),
(51, 03, 21, 112, '古文镇'),
(51, 03, 21, 113, '河口镇'),
(51, 03, 21, 114, '新桥镇'),
(51, 03, 21, 115, '正紫镇'),
(51, 03, 21, 116, '度佳镇'),
(51, 03, 21, 117, '东佳镇'),
(51, 03, 21, 118, '长山镇'),
(51, 03, 21, 119, '保华镇'),
(51, 03, 21, 120, '留佳镇'),
(51, 03, 21, 121, '来牟镇'),
(51, 03, 21, 122, '双古镇'),
(51, 03, 21, 123, '观山镇'),
(51, 03, 21, 124, '高山镇'),
(51, 03, 21, 125, '东兴镇'),
(51, 03, 21, 126, '铁厂镇'),
(51, 03, 21, 202, '金花乡'),
(51, 03, 21, 203, '雷音乡'),
(51, 03, 21, 204, '古佳乡'),
(51, 03, 21, 205, '于佳乡'),
(51, 03, 21, 206, '复兴乡'),
(51, 03, 21, 207, '墨林乡');
/* 四川省 自贡市 富顺县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 03, 22, 100, '富世镇'),
(51, 03, 22, 101, '东湖镇'),
(51, 03, 22, 102, '琵琶镇'),
(51, 03, 22, 103, '狮市镇'),
(51, 03, 22, 104, '骑龙镇'),
(51, 03, 22, 107, '互助镇'),
(51, 03, 22, 111, '代寺镇'),
(51, 03, 22, 112, '中石镇'),
(51, 03, 22, 113, '童寺镇'),
(51, 03, 22, 114, '古佛镇'),
(51, 03, 22, 115, '永年镇'),
(51, 03, 22, 116, '彭庙镇'),
(51, 03, 22, 117, '兜山镇'),
(51, 03, 22, 118, '板桥镇'),
(51, 03, 22, 119, '福善镇'),
(51, 03, 22, 120, '李桥镇'),
(51, 03, 22, 121, '赵化镇'),
(51, 03, 22, 122, '安溪镇'),
(51, 03, 22, 123, '万寿镇'),
(51, 03, 22, 124, '飞龙镇'),
(51, 03, 22, 125, '怀德镇'),
(51, 03, 22, 126, '长滩镇'),
(51, 03, 22, 200, '龙万乡'),
(51, 03, 22, 201, '宝庆乡'),
(51, 03, 22, 202, '富和乡'),
(51, 03, 22, 203, '石道乡');
/* 四川省 攀枝花市 东区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 04, 02, 001, '大渡口街道办事处'),
(51, 04, 02, 002, '炳草岗街道办事处'),
(51, 04, 02, 003, '南山街道办事处'),
(51, 04, 02, 004, '向阳村街道办事处'),
(51, 04, 02, 005, '弄弄坪街道办事处'),
(51, 04, 02, 006, '枣子坪街道办事处'),
(51, 04, 02, 007, '长寿路街道办事处'),
(51, 04, 02, 008, '密地街道办事处'),
(51, 04, 02, 009, '瓜子坪街道办事处'),
(51, 04, 02, 100, '银江镇');
/* 四川省 攀枝花市 西区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 04, 03, 001, '清香坪街道办事处'),
(51, 04, 03, 002, '玉泉街道办事处'),
(51, 04, 03, 003, '河门口街道办事处'),
(51, 04, 03, 004, '陶家渡街道办事处'),
(51, 04, 03, 005, '摩梭河街道办事处'),
(51, 04, 03, 006, '大宝鼎街道办事处'),
(51, 04, 03, 100, '格里坪镇');
/* 四川省 攀枝花市 仁和区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 04, 11, 001, '大河中路街道办事处'),
(51, 04, 11, 100, '仁和镇'),
(51, 04, 11, 101, '平地镇'),
(51, 04, 11, 102, '大田镇'),
(51, 04, 11, 103, '福田镇'),
(51, 04, 11, 104, '同德镇'),
(51, 04, 11, 105, '金江镇'),
(51, 04, 11, 106, '布德镇'),
(51, 04, 11, 107, '前进镇'),
(51, 04, 11, 200, '大龙潭彝族乡'),
(51, 04, 11, 201, '啊喇彝族乡'),
(51, 04, 11, 202, '总发乡'),
(51, 04, 11, 203, '太平乡'),
(51, 04, 11, 204, '务本乡'),
(51, 04, 11, 205, '中坝乡');
/* 四川省 攀枝花市 米易县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 04, 21, 100, '攀莲镇'),
(51, 04, 21, 101, '丙谷镇'),
(51, 04, 21, 102, '得石镇'),
(51, 04, 21, 103, '撒莲镇'),
(51, 04, 21, 104, '垭口镇'),
(51, 04, 21, 105, '白马镇'),
(51, 04, 21, 106, '普威镇'),
(51, 04, 21, 200, '草场乡'),
(51, 04, 21, 201, '湾丘彝族乡'),
(51, 04, 21, 202, '白坡彝族乡'),
(51, 04, 21, 203, '麻陇彝族乡'),
(51, 04, 21, 204, '新山傈僳族乡');
/* 四川省 攀枝花市 盐边县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 04, 22, 100, '桐子林镇'),
(51, 04, 22, 101, '红格镇'),
(51, 04, 22, 102, '渔门镇'),
(51, 04, 22, 103, '永兴镇'),
(51, 04, 22, 200, '益民乡'),
(51, 04, 22, 201, '新九乡'),
(51, 04, 22, 202, '和爱彝族乡'),
(51, 04, 22, 203, '红果彝族乡'),
(51, 04, 22, 204, '鳡鱼彝族乡'),
(51, 04, 22, 205, '共和乡'),
(51, 04, 22, 206, '国胜乡'),
(51, 04, 22, 207, '红宝苗族彝族乡'),
(51, 04, 22, 208, '惠民乡'),
(51, 04, 22, 209, '箐河傈僳族乡'),
(51, 04, 22, 210, '温泉彝族乡'),
(51, 04, 22, 211, '格萨拉彝族乡');
/* 四川省 泸州市 江阳区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 05, 02, 001, '南城街道'),
(51, 05, 02, 002, '北城街道'),
(51, 05, 02, 003, '大山坪街道'),
(51, 05, 02, 004, '邻玉街道办事处'),
(51, 05, 02, 005, '蓝田街道办事处'),
(51, 05, 02, 006, '茜草街道办事处'),
(51, 05, 02, 007, '华阳街道办事处'),
(51, 05, 02, 008, '张坝景区办事处'),
(51, 05, 02, 009, '泰安街道办事处'),
(51, 05, 02, 010, '况场街道办事处'),
(51, 05, 02, 103, '黄舣镇'),
(51, 05, 02, 104, '弥陀镇'),
(51, 05, 02, 106, '通滩镇'),
(51, 05, 02, 107, '江北镇'),
(51, 05, 02, 108, '方山镇'),
(51, 05, 02, 109, '丹林镇'),
(51, 05, 02, 110, '分水岭镇'),
(51, 05, 02, 111, '石寨镇');
/* 四川省 泸州市 纳溪区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 05, 03, 001, '安富街道'),
(51, 05, 03, 002, '永宁街道'),
(51, 05, 03, 003, '东升街道'),
(51, 05, 03, 100, '大渡口镇'),
(51, 05, 03, 101, '护国镇'),
(51, 05, 03, 102, '打古镇'),
(51, 05, 03, 103, '上马镇'),
(51, 05, 03, 104, '合面镇'),
(51, 05, 03, 105, '棉花坡镇'),
(51, 05, 03, 106, '丰乐镇'),
(51, 05, 03, 107, '白节镇'),
(51, 05, 03, 108, '天仙镇'),
(51, 05, 03, 109, '新乐镇'),
(51, 05, 03, 110, '渠坝镇'),
(51, 05, 03, 111, '龙车镇');
/* 四川省 泸州市 龙马潭区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 05, 04, 001, '小市街道办事处'),
(51, 05, 04, 002, '高坝街道办事处'),
(51, 05, 04, 003, '红星街道办事处'),
(51, 05, 04, 004, '莲花池街道办事处'),
(51, 05, 04, 005, '罗汉街道办事处'),
(51, 05, 04, 006, '鱼塘街道办事处'),
(51, 05, 04, 007, '安宁街道办事处'),
(51, 05, 04, 102, '石洞镇'),
(51, 05, 04, 103, '胡市镇'),
(51, 05, 04, 104, '特兴镇'),
(51, 05, 04, 106, '双加镇'),
(51, 05, 04, 107, '金龙镇'),
(51, 05, 04, 108, '长安镇');
/* 四川省 泸州市 泸县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 05, 21, 001, '玉蟾街道办事处'),
(51, 05, 21, 100, '福集镇'),
(51, 05, 21, 101, '嘉明镇'),
(51, 05, 21, 102, '喻寺镇'),
(51, 05, 21, 103, '得胜镇'),
(51, 05, 21, 105, '牛滩镇'),
(51, 05, 21, 106, '兆雅镇'),
(51, 05, 21, 107, '玄滩镇'),
(51, 05, 21, 108, '太伏镇'),
(51, 05, 21, 109, '云龙镇'),
(51, 05, 21, 110, '石桥镇'),
(51, 05, 21, 111, '毗卢镇'),
(51, 05, 21, 112, '奇峰镇'),
(51, 05, 21, 113, '潮河镇'),
(51, 05, 21, 114, '云锦镇'),
(51, 05, 21, 115, '立石镇'),
(51, 05, 21, 116, '百和镇'),
(51, 05, 21, 117, '天兴镇'),
(51, 05, 21, 118, '方洞镇'),
(51, 05, 21, 123, '海潮镇');
/* 四川省 泸州市 合江县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 05, 22, 100, '合江镇'),
(51, 05, 22, 101, '望龙镇'),
(51, 05, 22, 102, '白沙镇'),
(51, 05, 22, 103, '佛荫镇'),
(51, 05, 22, 104, '先市镇'),
(51, 05, 22, 105, '尧坝镇'),
(51, 05, 22, 106, '九支镇'),
(51, 05, 22, 107, '五通镇'),
(51, 05, 22, 108, '凤鸣镇'),
(51, 05, 22, 109, '榕山镇'),
(51, 05, 22, 110, '白鹿镇'),
(51, 05, 22, 111, '甘雨镇'),
(51, 05, 22, 112, '福宝镇'),
(51, 05, 22, 113, '先滩镇'),
(51, 05, 22, 114, '自怀镇'),
(51, 05, 22, 115, '大桥镇'),
(51, 05, 22, 116, '车辋镇'),
(51, 05, 22, 117, '白米镇'),
(51, 05, 22, 118, '参宝镇'),
(51, 05, 22, 119, '法王寺镇'),
(51, 05, 22, 120, '虎头镇'),
(51, 05, 22, 121, '神臂城镇'),
(51, 05, 22, 122, '南滩镇'),
(51, 05, 22, 123, '实录镇'),
(51, 05, 22, 124, '石龙镇'),
(51, 05, 22, 200, '密溪乡'),
(51, 05, 22, 210, '榕右乡');
/* 四川省 泸州市 叙永县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 05, 24, 100, '叙永镇'),
(51, 05, 24, 101, '江门镇'),
(51, 05, 24, 102, '马岭镇'),
(51, 05, 24, 103, '天池镇'),
(51, 05, 24, 104, '水尾镇'),
(51, 05, 24, 105, '两河镇'),
(51, 05, 24, 106, '落卜镇'),
(51, 05, 24, 107, '后山镇'),
(51, 05, 24, 108, '分水镇'),
(51, 05, 24, 109, '摩尼镇'),
(51, 05, 24, 110, '赤水镇'),
(51, 05, 24, 111, '龙凤镇'),
(51, 05, 24, 112, '正东镇'),
(51, 05, 24, 113, '观兴镇'),
(51, 05, 24, 200, '向林乡'),
(51, 05, 24, 201, '大石乡'),
(51, 05, 24, 202, '兴隆乡'),
(51, 05, 24, 206, '黄坭乡'),
(51, 05, 24, 207, '营山乡'),
(51, 05, 24, 208, '麻城乡'),
(51, 05, 24, 210, '合乐苗族乡'),
(51, 05, 24, 211, '白腊苗族乡'),
(51, 05, 24, 212, '枧槽苗族乡'),
(51, 05, 24, 213, '水潦彝族乡'),
(51, 05, 24, 214, '石坝彝族乡');
/* 四川省 泸州市 古蔺县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 05, 25, 100, '古蔺镇'),
(51, 05, 25, 101, '龙山镇'),
(51, 05, 25, 102, '永乐镇'),
(51, 05, 25, 103, '太平镇'),
(51, 05, 25, 104, '二郎镇'),
(51, 05, 25, 105, '大村镇'),
(51, 05, 25, 106, '石宝镇'),
(51, 05, 25, 107, '丹桂镇'),
(51, 05, 25, 108, '水口镇'),
(51, 05, 25, 109, '观文镇'),
(51, 05, 25, 110, '双沙镇'),
(51, 05, 25, 111, '德耀镇'),
(51, 05, 25, 112, '护家镇'),
(51, 05, 25, 113, '石屏镇'),
(51, 05, 25, 114, '土城镇'),
(51, 05, 25, 115, '皇华镇'),
(51, 05, 25, 202, '鱼化乡'),
(51, 05, 25, 204, '东新乡'),
(51, 05, 25, 207, '白泥乡'),
(51, 05, 25, 208, '椒园乡'),
(51, 05, 25, 209, '马嘶苗族乡'),
(51, 05, 25, 211, '马蹄乡'),
(51, 05, 25, 212, '箭竹苗族乡'),
(51, 05, 25, 214, '大寨苗族乡'),
(51, 05, 25, 215, '桂花乡'),
(51, 05, 25, 216, '黄荆乡');
/* 四川省 德阳市 旌阳区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 06, 03, 001, '旌阳街道'),
(51, 06, 03, 002, '城南街道'),
(51, 06, 03, 003, '城北街道'),
(51, 06, 03, 004, '旌东街道'),
(51, 06, 03, 005, '工农街道'),
(51, 06, 03, 006, '八角井街道办事处'),
(51, 06, 03, 100, '黄许镇'),
(51, 06, 03, 101, '孝泉镇'),
(51, 06, 03, 103, '柏隆镇'),
(51, 06, 03, 104, '孝感镇'),
(51, 06, 03, 105, '天元镇'),
(51, 06, 03, 107, '扬嘉镇'),
(51, 06, 03, 108, '德新镇'),
(51, 06, 03, 110, '双东镇'),
(51, 06, 03, 111, '新中镇'),
(51, 06, 03, 117, '和新镇'),
(51, 06, 03, 201, '东湖乡');
/* 四川省 德阳市 中江县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 06, 23, 100, '凯江镇'),
(51, 06, 23, 101, '南华镇'),
(51, 06, 23, 102, '回龙镇'),
(51, 06, 23, 103, '通济镇'),
(51, 06, 23, 104, '永太镇'),
(51, 06, 23, 105, '黄鹿镇'),
(51, 06, 23, 106, '集凤镇'),
(51, 06, 23, 107, '富兴镇'),
(51, 06, 23, 108, '辑庆镇'),
(51, 06, 23, 109, '兴隆镇'),
(51, 06, 23, 110, '龙台镇'),
(51, 06, 23, 111, '永安镇'),
(51, 06, 23, 112, '双龙镇'),
(51, 06, 23, 113, '玉兴镇'),
(51, 06, 23, 114, '永兴镇'),
(51, 06, 23, 115, '悦来镇'),
(51, 06, 23, 116, '继光镇'),
(51, 06, 23, 117, '仓山镇'),
(51, 06, 23, 118, '广福镇'),
(51, 06, 23, 119, '会龙镇'),
(51, 06, 23, 120, '万福镇'),
(51, 06, 23, 121, '普兴镇'),
(51, 06, 23, 122, '联合镇'),
(51, 06, 23, 123, '冯店镇'),
(51, 06, 23, 124, '积金镇'),
(51, 06, 23, 125, '太安镇'),
(51, 06, 23, 127, '杰兴镇'),
(51, 06, 23, 130, '南山镇'),
(51, 06, 23, 132, '东北镇'),
(51, 06, 23, 200, '古店乡'),
(51, 06, 23, 201, '青市乡'),
(51, 06, 23, 203, '瓦店乡'),
(51, 06, 23, 204, '石泉乡'),
(51, 06, 23, 206, '柏树乡'),
(51, 06, 23, 207, '白果乡'),
(51, 06, 23, 208, '清河乡'),
(51, 06, 23, 209, '高店乡'),
(51, 06, 23, 210, '石笋乡'),
(51, 06, 23, 211, '太平乡'),
(51, 06, 23, 212, '民主乡'),
(51, 06, 23, 214, '永丰乡'),
(51, 06, 23, 216, '元兴乡'),
(51, 06, 23, 218, '通山乡'),
(51, 06, 23, 219, '石龙乡'),
(51, 06, 23, 221, '合兴乡');
/* 四川省 德阳市 罗江县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 06, 26, 100, '万安镇'),
(51, 06, 26, 101, '鄢家镇'),
(51, 06, 26, 102, '金山镇'),
(51, 06, 26, 103, '略坪镇'),
(51, 06, 26, 104, '御营镇'),
(51, 06, 26, 105, '慧觉镇'),
(51, 06, 26, 106, '调元镇'),
(51, 06, 26, 107, '新盛镇'),
(51, 06, 26, 108, '蟠龙镇'),
(51, 06, 26, 113, '白马关镇');
/* 四川省 德阳市 广汉市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 06, 81, 100, '雒城镇'),
(51, 06, 81, 101, '三水镇'),
(51, 06, 81, 102, '连山镇'),
(51, 06, 81, 103, '高坪镇'),
(51, 06, 81, 104, '南兴镇'),
(51, 06, 81, 105, '向阳镇'),
(51, 06, 81, 106, '小汉镇'),
(51, 06, 81, 107, '金轮镇'),
(51, 06, 81, 108, '新丰镇'),
(51, 06, 81, 109, '兴隆镇'),
(51, 06, 81, 112, '和兴镇'),
(51, 06, 81, 113, '松林镇'),
(51, 06, 81, 114, '金鱼镇'),
(51, 06, 81, 115, '新平镇'),
(51, 06, 81, 116, '南丰镇'),
(51, 06, 81, 119, '西高镇'),
(51, 06, 81, 200, '北外乡'),
(51, 06, 81, 202, '西外乡');
/* 四川省 德阳市 什邡市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 06, 82, 001, '方亭街道办事处'),
(51, 06, 82, 002, '皂角街道办事处'),
(51, 06, 82, 101, '元石镇'),
(51, 06, 82, 103, '回澜镇'),
(51, 06, 82, 105, '洛水镇'),
(51, 06, 82, 106, '禾丰镇'),
(51, 06, 82, 107, '双盛镇'),
(51, 06, 82, 108, '马祖镇'),
(51, 06, 82, 109, '隐峰镇'),
(51, 06, 82, 110, '马井镇'),
(51, 06, 82, 111, '蓥华镇'),
(51, 06, 82, 113, '南泉镇'),
(51, 06, 82, 116, '湔氐镇'),
(51, 06, 82, 118, '红白镇'),
(51, 06, 82, 119, '冰川镇'),
(51, 06, 82, 120, '师古镇');
/* 四川省 德阳市 绵竹市 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 06, 83, 100, '剑南镇'),
(51, 06, 83, 101, '东北镇'),
(51, 06, 83, 102, '西南镇'),
(51, 06, 83, 103, '兴隆镇'),
(51, 06, 83, 104, '九龙镇'),
(51, 06, 83, 105, '遵道镇'),
(51, 06, 83, 106, '汉旺镇'),
(51, 06, 83, 108, '拱星镇'),
(51, 06, 83, 109, '土门镇'),
(51, 06, 83, 110, '广济镇'),
(51, 06, 83, 111, '金花镇'),
(51, 06, 83, 112, '玉泉镇'),
(51, 06, 83, 113, '板桥镇'),
(51, 06, 83, 115, '新市镇'),
(51, 06, 83, 116, '孝德镇'),
(51, 06, 83, 119, '富新镇'),
(51, 06, 83, 121, '齐天镇'),
(51, 06, 83, 122, '什地镇'),
(51, 06, 83, 123, '绵远镇'),
(51, 06, 83, 124, '清平镇'),
(51, 06, 83, 201, '天池乡');
/* 四川省 绵阳市 涪城区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 07, 03, 001, '城厢街道'),
(51, 07, 03, 002, '城北街道'),
(51, 07, 03, 003, '工区街道'),
(51, 07, 03, 004, '南山街道'),
(51, 07, 03, 005, '朝阳街道'),
(51, 07, 03, 006, '高新街道'),
(51, 07, 03, 007, '城南街道'),
(51, 07, 03, 008, '金家林街道'),
(51, 07, 03, 009, '科创园街道'),
(51, 07, 03, 100, '丰谷镇'),
(51, 07, 03, 101, '关帝镇'),
(51, 07, 03, 102, '塘汛镇'),
(51, 07, 03, 103, '青义镇'),
(51, 07, 03, 104, '龙门镇'),
(51, 07, 03, 105, '石塘镇'),
(51, 07, 03, 106, '吴家镇'),
(51, 07, 03, 107, '杨家镇'),
(51, 07, 03, 108, '金峰镇'),
(51, 07, 03, 109, '玉皇镇'),
(51, 07, 03, 110, '新皂镇'),
(51, 07, 03, 111, '河边镇'),
(51, 07, 03, 112, '磨家镇'),
(51, 07, 03, 113, '永兴镇'),
(51, 07, 03, 200, '城郊乡'),
(51, 07, 03, 201, '石洞乡');
/* 四川省 绵阳市 游仙区 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 07, 04, 001, '涪江街道'),
(51, 07, 04, 003, '富乐街道办事处'),
(51, 07, 04, 006, '春雷街道办'),
(51, 07, 04, 007, '松林街道办'),
(51, 07, 04, 008, '华丰街道办'),
(51, 07, 04, 100, '游仙镇'),
(51, 07, 04, 101, '石马镇'),
(51, 07, 04, 102, '新桥镇'),
(51, 07, 04, 103, '小枧沟镇'),
(51, 07, 04, 104, '魏城镇'),
(51, 07, 04, 105, '沉抗镇'),
(51, 07, 04, 106, '忠兴镇'),
(51, 07, 04, 107, '柏林镇'),
(51, 07, 04, 108, '徐家镇'),
(51, 07, 04, 109, '石板镇'),
(51, 07, 04, 110, '刘家镇'),
(51, 07, 04, 111, '玉河镇'),
(51, 07, 04, 112, '松垭镇'),
(51, 07, 04, 113, '白蝉镇'),
(51, 07, 04, 114, '观太镇'),
(51, 07, 04, 115, '云凤镇'),
(51, 07, 04, 116, '太平镇'),
(51, 07, 04, 117, '街子镇'),
(51, 07, 04, 202, '建华乡'),
(51, 07, 04, 204, '东林乡'),
(51, 07, 04, 206, '梓棉乡'),
(51, 07, 04, 207, '朝真乡'),
(51, 07, 04, 208, '东宣乡'),
(51, 07, 04, 210, '凤凰乡');
/* 四川省 绵阳市 三台县 */
INSERT INTO Street (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(51, 07, 22, 100, '北坝镇'),
(51, 07, 22, 101, '潼川镇'),
(51, 07, 22, 102, '东塔镇'),
(51, 07, 22, 103, '百顷镇'),
(51, 07, 22, 104, '塔山镇'),
(51, 07, 22, 105, '柳池镇'),
(51, 07, 22, 106, '龙树镇'),
(51, 07, 22, 107, '石安镇'),
(51, 07, 22, 108, '富顺镇'),
(51, 07, 22, 109, '三元镇'),
(51, 07, 22, 110, '秋林镇'),
(51, 07, 22, 111, '永新镇'),
(51, 07, 22, 112, '新德镇'),
(51, 07, 22, 113, '新生镇'),