-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathAdministratives-China(Street)-8.sql
3811 lines (3565 loc) · 135 KB
/
Administratives-China(Street)-8.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
* _____ ______
* /_ / ____ ____ ____ _________ / __/ /_
* / / / __ \/ __ \/ __ \/ ___/ __ \/ /_/ __/
* / /__/ /_/ / / / / /_/ /\_ \/ /_/ / __/ /_
* /____/\____/_/ /_/\__ /____/\____/_/ \__/
* /____/
*
* Authors:
* 钟峰(Popeye Zhong) <[email protected]>
*
* 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)
* 数据范围:陕西省(61)、甘肃省(62)、青海省(63)。
*/
/* 陕西省 西安市 新城区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 02, 001, '西一路街道办事处'),
(61, 01, 02, 002, '长乐中路街道办事处'),
(61, 01, 02, 003, '中山门街道办事处'),
(61, 01, 02, 004, '韩森寨街道办事处'),
(61, 01, 02, 005, '解放门街道办事处'),
(61, 01, 02, 006, '自强路街道办事处'),
(61, 01, 02, 007, '太华路街道办事处'),
(61, 01, 02, 008, '长乐西路街道办事处'),
(61, 01, 02, 009, '胡家庙街道办事处');
/* 陕西省 西安市 碑林区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 03, 001, '南院门街道办事处'),
(61, 01, 03, 002, '柏树林街道办事处'),
(61, 01, 03, 003, '长乐坊街道办事处'),
(61, 01, 03, 004, '东关南街街道办事处'),
(61, 01, 03, 005, '太乙路街道办事处'),
(61, 01, 03, 006, '文艺路街道办事处'),
(61, 01, 03, 007, '长安路街道办事处'),
(61, 01, 03, 008, '张家村街道办事处');
/* 陕西省 西安市 莲湖区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 04, 001, '青年路街道办事处'),
(61, 01, 04, 002, '北院门街道办事处'),
(61, 01, 04, 003, '北关街道办事处'),
(61, 01, 04, 004, '红庙坡街道办事处'),
(61, 01, 04, 005, '环城西路街道办事处'),
(61, 01, 04, 006, '西关街道办事处'),
(61, 01, 04, 007, '土门街道办事处'),
(61, 01, 04, 008, '桃园路街道办事处'),
(61, 01, 04, 009, '枣园街道办事处');
/* 陕西省 西安市 灞桥区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 11, 001, '纺织城街道办事处'),
(61, 01, 11, 002, '十里铺街道办事处'),
(61, 01, 11, 003, '红旗街道办事处'),
(61, 01, 11, 004, '席王街道办事处'),
(61, 01, 11, 005, '洪庆街道办事处'),
(61, 01, 11, 006, '狄寨街道办事处'),
(61, 01, 11, 007, '灞桥街道办事处'),
(61, 01, 11, 008, '新筑街道办事处'),
(61, 01, 11, 009, '新合街道办事处');
/* 陕西省 西安市 未央区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 12, 001, '张家堡街道办事处'),
(61, 01, 12, 002, '三桥街道办事处'),
(61, 01, 12, 003, '辛家庙街道办事处'),
(61, 01, 12, 004, '徐家湾街道办事处'),
(61, 01, 12, 005, '大明宫街道办事处'),
(61, 01, 12, 006, '谭家街道办事处'),
(61, 01, 12, 007, '草滩街道办事处'),
(61, 01, 12, 008, '六村堡街道办事处'),
(61, 01, 12, 009, '未央宫街道办事处'),
(61, 01, 12, 010, '汉城街道办事处'),
(61, 01, 12, 011, '未央湖街道办事处'),
(61, 01, 12, 012, '建章路街道办事处');
/* 陕西省 西安市 雁塔区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 13, 001, '小寨路街道办事处'),
(61, 01, 13, 002, '大雁塔街道办事处'),
(61, 01, 13, 003, '长延堡街道办事处'),
(61, 01, 13, 004, '电子城街道办事处'),
(61, 01, 13, 005, '等驾坡街道办事处'),
(61, 01, 13, 006, '鱼化寨街道办事处'),
(61, 01, 13, 007, '丈八沟街道办事处'),
(61, 01, 13, 008, '曲江街道办事处');
/* 陕西省 西安市 阎良区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 14, 001, '凤凰路街道办事处'),
(61, 01, 14, 002, '新华路街道办事处'),
(61, 01, 14, 003, '振兴街道办事处'),
(61, 01, 14, 004, '新兴街道办事处'),
(61, 01, 14, 005, '北屯街道办事处'),
(61, 01, 14, 100, '武屯镇'),
(61, 01, 14, 101, '关山镇');
/* 陕西省 西安市 临潼区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 15, 001, '骊山街道办事处'),
(61, 01, 15, 002, '秦陵街道办事处'),
(61, 01, 15, 003, '新丰街道办事处'),
(61, 01, 15, 004, '代王街道办事处'),
(61, 01, 15, 005, '斜口街道办事处'),
(61, 01, 15, 006, '行者街道办事处'),
(61, 01, 15, 007, '零口街道办事处'),
(61, 01, 15, 008, '相桥街道办事处'),
(61, 01, 15, 009, '雨金街道办事处'),
(61, 01, 15, 010, '新市街道办事处'),
(61, 01, 15, 011, '徐杨街道办事处'),
(61, 01, 15, 012, '西泉街道办事处'),
(61, 01, 15, 013, '栎阳街道办事处'),
(61, 01, 15, 014, '马额街道办事处'),
(61, 01, 15, 015, '何寨街道办事处'),
(61, 01, 15, 016, '交口街道办事处'),
(61, 01, 15, 017, '油槐街道办事处'),
(61, 01, 15, 018, '北田街道办事处'),
(61, 01, 15, 019, '铁炉街道办事处'),
(61, 01, 15, 020, '任留街道办事处'),
(61, 01, 15, 021, '穆寨街道办事处'),
(61, 01, 15, 022, '小金街道办事处'),
(61, 01, 15, 023, '仁宗街道办事处');
/* 陕西省 西安市 长安区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 16, 001, '韦曲街道办事处'),
(61, 01, 16, 002, '郭杜街道办事处'),
(61, 01, 16, 003, '滦镇街道办事处'),
(61, 01, 16, 004, '引镇街道办事处'),
(61, 01, 16, 005, '王寺街道办事处'),
(61, 01, 16, 006, '马王街道办事处'),
(61, 01, 16, 007, '太乙宫街道办事处'),
(61, 01, 16, 008, '东大街道办事处'),
(61, 01, 16, 009, '子午街道办事处'),
(61, 01, 16, 010, '斗门街道办事处'),
(61, 01, 16, 011, '细柳街道办事处'),
(61, 01, 16, 012, '杜曲街道办事处'),
(61, 01, 16, 013, '大兆街道办事处'),
(61, 01, 16, 014, '黄良街道办事处'),
(61, 01, 16, 015, '兴隆街道办事处'),
(61, 01, 16, 016, '王曲街道办事处'),
(61, 01, 16, 017, '鸣犊街道办事处'),
(61, 01, 16, 018, '王莽街道办事处'),
(61, 01, 16, 019, '五台街道办事处'),
(61, 01, 16, 020, '高桥街道办事处'),
(61, 01, 16, 021, '五星街道办事处'),
(61, 01, 16, 022, '灵沼街道办事处'),
(61, 01, 16, 023, '杨庄街道办事处'),
(61, 01, 16, 024, '砲里街道办事处'),
(61, 01, 16, 025, '魏寨街道办事处');
/* 陕西省 西安市 高陵区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 17, 001, '鹿苑街道办事处'),
(61, 01, 17, 002, '泾渭街道办事处'),
(61, 01, 17, 003, '崇皇街道办事处'),
(61, 01, 17, 101, '通远镇'),
(61, 01, 17, 102, '耿镇'),
(61, 01, 17, 106, '张卜镇');
/* 陕西省 西安市 蓝田县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 22, 001, '蓝关街道办事处'),
(61, 01, 22, 101, '洩湖镇'),
(61, 01, 22, 102, '华胥镇'),
(61, 01, 22, 103, '前卫镇'),
(61, 01, 22, 104, '汤峪镇'),
(61, 01, 22, 105, '焦岱镇'),
(61, 01, 22, 106, '玉山镇'),
(61, 01, 22, 107, '三里镇'),
(61, 01, 22, 108, '普化镇'),
(61, 01, 22, 109, '葛牌镇'),
(61, 01, 22, 110, '灞源镇'),
(61, 01, 22, 111, '九间房镇'),
(61, 01, 22, 112, '蓝桥镇'),
(61, 01, 22, 113, '辋川镇'),
(61, 01, 22, 115, '厚镇'),
(61, 01, 22, 116, '三官庙镇'),
(61, 01, 22, 118, '安村镇'),
(61, 01, 22, 119, '孟村镇'),
(61, 01, 22, 120, '小寨镇');
/* 陕西省 西安市 周至县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 24, 001, '二曲街道办事处'),
(61, 01, 24, 101, '哑柏镇'),
(61, 01, 24, 102, '终南镇'),
(61, 01, 24, 103, '马召镇'),
(61, 01, 24, 104, '集贤镇'),
(61, 01, 24, 105, '楼观镇'),
(61, 01, 24, 106, '尚村镇'),
(61, 01, 24, 107, '广济镇'),
(61, 01, 24, 108, '厚畛子镇'),
(61, 01, 24, 109, '青化镇'),
(61, 01, 24, 110, '竹峪镇'),
(61, 01, 24, 111, '翠峰镇'),
(61, 01, 24, 112, '四屯镇'),
(61, 01, 24, 115, '司竹镇'),
(61, 01, 24, 116, '九峰镇'),
(61, 01, 24, 117, '富仁镇'),
(61, 01, 24, 118, '骆峪镇'),
(61, 01, 24, 119, '陈河镇'),
(61, 01, 24, 120, '板房子镇'),
(61, 01, 24, 121, '王家河镇');
/* 陕西省 西安市 户县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 01, 25, 001, '甘亭街道办'),
(61, 01, 25, 101, '余下镇'),
(61, 01, 25, 102, '祖庵镇'),
(61, 01, 25, 103, '秦渡镇'),
(61, 01, 25, 104, '大王镇'),
(61, 01, 25, 105, '草堂镇'),
(61, 01, 25, 106, '蒋村镇'),
(61, 01, 25, 107, '庞光镇'),
(61, 01, 25, 108, '涝店镇'),
(61, 01, 25, 109, '甘河镇'),
(61, 01, 25, 110, '石井镇'),
(61, 01, 25, 111, '玉蝉镇'),
(61, 01, 25, 112, '五竹镇'),
(61, 01, 25, 114, '渭丰镇');
/* 陕西省 铜川市 王益区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 02, 02, 001, '七一路街道办事处'),
(61, 02, 02, 002, '红旗街道办事处'),
(61, 02, 02, 003, '桃园街道办事处'),
(61, 02, 02, 004, '青年路街道办事处'),
(61, 02, 02, 005, '王家河街道办事处'),
(61, 02, 02, 006, '王益街道办事处'),
(61, 02, 02, 100, '黄堡镇');
/* 陕西省 铜川市 印台区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 02, 03, 001, '城关街道办事处'),
(61, 02, 03, 002, '三里洞街道办事处'),
(61, 02, 03, 003, '王石凹街道办事处'),
(61, 02, 03, 004, '印台街道办事处'),
(61, 02, 03, 100, '陈炉镇'),
(61, 02, 03, 101, '红土镇'),
(61, 02, 03, 102, '广阳镇'),
(61, 02, 03, 104, '金锁关镇'),
(61, 02, 03, 106, '阿庄镇');
/* 陕西省 铜川市 耀州区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 02, 04, 001, '永安路街道办事处'),
(61, 02, 04, 002, '天宝路街道办事处'),
(61, 02, 04, 003, '咸丰路街道办事处'),
(61, 02, 04, 004, '正阳路街道办事处'),
(61, 02, 04, 005, '锦阳路街道办事处'),
(61, 02, 04, 006, '坡头街道办事处'),
(61, 02, 04, 101, '董家河镇'),
(61, 02, 04, 102, '庙湾镇'),
(61, 02, 04, 103, '瑶曲镇'),
(61, 02, 04, 104, '照金镇'),
(61, 02, 04, 107, '小丘镇'),
(61, 02, 04, 108, '孙塬镇'),
(61, 02, 04, 109, '关庄镇'),
(61, 02, 04, 111, '石柱镇');
/* 陕西省 铜川市 宜君县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 02, 22, 001, '宜阳街道办事处'),
(61, 02, 22, 101, '彭镇'),
(61, 02, 22, 102, '五里镇'),
(61, 02, 22, 103, '太安镇'),
(61, 02, 22, 104, '棋盘镇'),
(61, 02, 22, 105, '尧生镇'),
(61, 02, 22, 106, '哭泉镇'),
(61, 02, 22, 201, '云梦乡');
/* 陕西省 宝鸡市 渭滨区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 02, 001, '金陵街道办事处'),
(61, 03, 02, 002, '经二路街道办事处'),
(61, 03, 02, 003, '清姜街道办事处'),
(61, 03, 02, 004, '姜谭街道办事处'),
(61, 03, 02, 005, '桥南街道办事处'),
(61, 03, 02, 100, '马营镇'),
(61, 03, 02, 101, '石鼓镇'),
(61, 03, 02, 102, '神农镇'),
(61, 03, 02, 103, '高家镇'),
(61, 03, 02, 104, '八鱼镇');
/* 陕西省 宝鸡市 金台区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 03, 001, '中山东路街道办事处'),
(61, 03, 03, 002, '西关街道办事处'),
(61, 03, 03, 003, '中山西路街道办事处'),
(61, 03, 03, 004, '群众路街道办事处'),
(61, 03, 03, 006, '东风路街道办事处'),
(61, 03, 03, 007, '十里铺街道办事处'),
(61, 03, 03, 008, '卧龙寺街道办事处'),
(61, 03, 03, 100, '陈仓镇'),
(61, 03, 03, 101, '蟠龙镇'),
(61, 03, 03, 102, '金河镇'),
(61, 03, 03, 103, '硖石镇');
/* 陕西省 宝鸡市 陈仓区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 04, 001, '虢镇街道办事处'),
(61, 03, 04, 002, '东关街道办事处'),
(61, 03, 04, 003, '千渭街道办事处'),
(61, 03, 04, 101, '阳平镇'),
(61, 03, 04, 102, '千河镇'),
(61, 03, 04, 103, '磻溪镇'),
(61, 03, 04, 104, '天王镇'),
(61, 03, 04, 105, '慕仪镇'),
(61, 03, 04, 106, '周原镇'),
(61, 03, 04, 107, '贾村镇'),
(61, 03, 04, 109, '县功镇'),
(61, 03, 04, 110, '新街镇'),
(61, 03, 04, 111, '坪头镇'),
(61, 03, 04, 112, '香泉镇'),
(61, 03, 04, 113, '赤沙镇'),
(61, 03, 04, 114, '拓石镇'),
(61, 03, 04, 115, '凤阁岭镇'),
(61, 03, 04, 116, '钓渭镇');
/* 陕西省 宝鸡市 凤翔县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 22, 100, '城关镇'),
(61, 03, 22, 101, '虢王镇'),
(61, 03, 22, 102, '彪角镇'),
(61, 03, 22, 103, '横水镇'),
(61, 03, 22, 104, '田家庄镇'),
(61, 03, 22, 105, '糜杆桥镇'),
(61, 03, 22, 107, '南指挥镇'),
(61, 03, 22, 108, '陈村镇'),
(61, 03, 22, 109, '长青镇'),
(61, 03, 22, 110, '柳林镇'),
(61, 03, 22, 111, '姚家沟镇'),
(61, 03, 22, 112, '范家寨镇');
/* 陕西省 宝鸡市 岐山县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 23, 100, '凤鸣镇'),
(61, 03, 23, 101, '蔡家坡镇'),
(61, 03, 23, 103, '益店镇'),
(61, 03, 23, 104, '蒲村镇'),
(61, 03, 23, 106, '青化镇'),
(61, 03, 23, 107, '枣林镇'),
(61, 03, 23, 108, '雍川镇'),
(61, 03, 23, 111, '故郡镇'),
(61, 03, 23, 112, '京当镇');
/* 陕西省 宝鸡市 扶风县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 24, 100, '城关镇'),
(61, 03, 24, 101, '天度镇'),
(61, 03, 24, 102, '午井镇'),
(61, 03, 24, 103, '绛帐镇'),
(61, 03, 24, 104, '段家镇'),
(61, 03, 24, 105, '杏林镇'),
(61, 03, 24, 106, '召公镇'),
(61, 03, 24, 107, '法门镇');
/* 陕西省 宝鸡市 眉县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 26, 100, '首善镇'),
(61, 03, 26, 101, '横渠镇'),
(61, 03, 26, 102, '槐芽镇'),
(61, 03, 26, 103, '汤峪镇'),
(61, 03, 26, 104, '常兴镇'),
(61, 03, 26, 105, '金渠镇'),
(61, 03, 26, 106, '营头镇'),
(61, 03, 26, 107, '齐镇');
/* 陕西省 宝鸡市 陇县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 27, 100, '城关镇'),
(61, 03, 27, 101, '东风镇'),
(61, 03, 27, 102, '八渡镇'),
(61, 03, 27, 104, '东南镇'),
(61, 03, 27, 106, '温水镇'),
(61, 03, 27, 107, '天成镇'),
(61, 03, 27, 108, '曹家湾镇'),
(61, 03, 27, 109, '固关镇'),
(61, 03, 27, 112, '河北镇'),
(61, 03, 27, 113, '新集川镇');
/* 陕西省 宝鸡市 千阳县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 28, 100, '城关镇'),
(61, 03, 28, 101, '崔家头镇'),
(61, 03, 28, 102, '南寨镇'),
(61, 03, 28, 103, '张家塬镇'),
(61, 03, 28, 104, '水沟镇'),
(61, 03, 28, 105, '草碧镇'),
(61, 03, 28, 107, '高崖镇');
/* 陕西省 宝鸡市 麟游县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 29, 100, '九成宫镇'),
(61, 03, 29, 101, '崔木镇'),
(61, 03, 29, 102, '招贤镇'),
(61, 03, 29, 103, '两亭镇'),
(61, 03, 29, 105, '常丰镇'),
(61, 03, 29, 106, '丈八镇'),
(61, 03, 29, 107, '酒房镇');
/* 陕西省 宝鸡市 凤县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 30, 100, '双石铺镇'),
(61, 03, 30, 101, '凤州镇'),
(61, 03, 30, 102, '黄牛铺镇'),
(61, 03, 30, 103, '红花铺镇'),
(61, 03, 30, 104, '河口镇'),
(61, 03, 30, 105, '唐藏镇'),
(61, 03, 30, 106, '平木镇'),
(61, 03, 30, 107, '坪坎镇'),
(61, 03, 30, 110, '留凤关镇');
/* 陕西省 宝鸡市 太白县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 03, 31, 100, '咀头镇'),
(61, 03, 31, 101, '桃川镇'),
(61, 03, 31, 102, '鹦鸽镇'),
(61, 03, 31, 103, '靖口镇'),
(61, 03, 31, 104, '太白河镇'),
(61, 03, 31, 105, '黄柏塬镇'),
(61, 03, 31, 106, '王家堎镇');
/* 陕西省 咸阳市 秦都区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 02, 001, '人民路街道办事处'),
(61, 04, 02, 002, '西兰路街道办事处'),
(61, 04, 02, 003, '吴家堡街道办事处'),
(61, 04, 02, 004, '渭阳西路街道办事处'),
(61, 04, 02, 005, '陈杨寨街道办事处'),
(61, 04, 02, 006, '古渡街道办事处'),
(61, 04, 02, 007, '沣东街道办事处'),
(61, 04, 02, 008, '钓台街道办事处'),
(61, 04, 02, 009, '马泉街道办事处'),
(61, 04, 02, 010, '渭滨街道办事处'),
(61, 04, 02, 011, '双照街道办事处'),
(61, 04, 02, 012, '马庄街道办事处');
/* 陕西省 咸阳市 杨陵区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 03, 001, '杨陵街道办事处'),
(61, 04, 03, 002, '李台街道办事处'),
(61, 04, 03, 003, '大寨街道办事处'),
(61, 04, 03, 100, '五泉镇'),
(61, 04, 03, 102, '揉谷镇');
/* 陕西省 咸阳市 渭城区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 04, 001, '中山街道办事处'),
(61, 04, 04, 002, '文汇路街道办事处'),
(61, 04, 04, 003, '新兴街道办事处'),
(61, 04, 04, 004, '渭阳街道办事处'),
(61, 04, 04, 005, '渭城街道办事处'),
(61, 04, 04, 006, '窑店街道办事处'),
(61, 04, 04, 007, '正阳街道办事处'),
(61, 04, 04, 008, '周陵街道办事处'),
(61, 04, 04, 009, '底张街道办事处'),
(61, 04, 04, 010, '北杜街道办事处');
/* 陕西省 咸阳市 三原县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 22, 001, '城关街道办事处'),
(61, 04, 22, 102, '陂西镇'),
(61, 04, 22, 103, '独李镇'),
(61, 04, 22, 104, '大程镇'),
(61, 04, 22, 105, '西阳镇'),
(61, 04, 22, 106, '鲁桥镇'),
(61, 04, 22, 107, '陵前镇'),
(61, 04, 22, 109, '新兴镇'),
(61, 04, 22, 110, '嵯峨镇'),
(61, 04, 22, 111, '渠岸镇');
/* 陕西省 咸阳市 泾阳县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 23, 001, '泾干街道办事处'),
(61, 04, 23, 101, '永乐镇'),
(61, 04, 23, 102, '云阳镇'),
(61, 04, 23, 103, '桥底镇'),
(61, 04, 23, 104, '王桥镇'),
(61, 04, 23, 105, '口镇'),
(61, 04, 23, 107, '三渠镇'),
(61, 04, 23, 108, '高庄镇'),
(61, 04, 23, 111, '太平镇'),
(61, 04, 23, 112, '崇文镇'),
(61, 04, 23, 113, '安吴镇'),
(61, 04, 23, 114, '兴隆镇'),
(61, 04, 23, 115, '中张镇');
/* 陕西省 咸阳市 乾县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 24, 001, '城关街道办事处'),
(61, 04, 24, 101, '薛录镇'),
(61, 04, 24, 102, '梁村镇'),
(61, 04, 24, 103, '临平镇'),
(61, 04, 24, 104, '姜村镇'),
(61, 04, 24, 105, '王村镇'),
(61, 04, 24, 106, '马连镇'),
(61, 04, 24, 107, '阳峪镇'),
(61, 04, 24, 108, '峰阳镇'),
(61, 04, 24, 109, '注泔镇'),
(61, 04, 24, 110, '灵源镇'),
(61, 04, 24, 111, '阳洪镇'),
(61, 04, 24, 112, '梁山镇'),
(61, 04, 24, 113, '周城镇'),
(61, 04, 24, 114, '新阳镇'),
(61, 04, 24, 115, '大杨镇');
/* 陕西省 咸阳市 礼泉县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 25, 001, '城关街道办事处'),
(61, 04, 25, 101, '史德镇'),
(61, 04, 25, 102, '西张堡镇'),
(61, 04, 25, 103, '阡东镇'),
(61, 04, 25, 104, '烽火镇'),
(61, 04, 25, 105, '烟霞镇'),
(61, 04, 25, 106, '赵镇'),
(61, 04, 25, 108, '叱干镇'),
(61, 04, 25, 109, '南坊镇'),
(61, 04, 25, 110, '石潭镇'),
(61, 04, 25, 111, '昭陵镇'),
(61, 04, 25, 112, '骏马镇');
/* 陕西省 咸阳市 永寿县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 26, 001, '监军街道办事处'),
(61, 04, 26, 101, '店头镇'),
(61, 04, 26, 102, '常宁镇'),
(61, 04, 26, 104, '甘井镇'),
(61, 04, 26, 105, '马坊镇'),
(61, 04, 26, 108, '渠子镇'),
(61, 04, 26, 110, '永平镇');
/* 陕西省 咸阳市 彬县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 27, 001, '城关街道办事处'),
(61, 04, 27, 101, '北极镇'),
(61, 04, 27, 102, '新民镇'),
(61, 04, 27, 103, '龙高镇'),
(61, 04, 27, 105, '永乐镇'),
(61, 04, 27, 106, '义门镇'),
(61, 04, 27, 107, '水口镇'),
(61, 04, 27, 108, '韩家镇'),
(61, 04, 27, 109, '太峪镇');
/* 陕西省 咸阳市 长武县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 28, 001, '昭仁街道办事处'),
(61, 04, 28, 101, '相公镇'),
(61, 04, 28, 102, '巨家镇'),
(61, 04, 28, 103, '丁家镇'),
(61, 04, 28, 104, '洪家镇'),
(61, 04, 28, 105, '亭口镇'),
(61, 04, 28, 106, '彭公镇'),
(61, 04, 28, 108, '枣元镇');
/* 陕西省 咸阳市 旬邑县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 29, 001, '城关街道办事处'),
(61, 04, 29, 101, '土桥镇'),
(61, 04, 29, 102, '职田镇'),
(61, 04, 29, 103, '张洪镇'),
(61, 04, 29, 104, '太村镇'),
(61, 04, 29, 105, '郑家镇'),
(61, 04, 29, 106, '湫坡头镇'),
(61, 04, 29, 107, '底庙镇'),
(61, 04, 29, 109, '马栏镇'),
(61, 04, 29, 110, '清塬镇');
/* 陕西省 咸阳市 淳化县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 30, 001, '城关街道办事处'),
(61, 04, 30, 101, '官庄镇'),
(61, 04, 30, 103, '方里镇'),
(61, 04, 30, 104, '润镇'),
(61, 04, 30, 105, '车坞镇'),
(61, 04, 30, 106, '铁王镇'),
(61, 04, 30, 107, '石桥镇'),
(61, 04, 30, 109, '十里塬镇');
/* 陕西省 咸阳市 武功县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 31, 001, '普集街道办事处'),
(61, 04, 31, 101, '苏坊镇'),
(61, 04, 31, 102, '武功镇'),
(61, 04, 31, 103, '游风镇'),
(61, 04, 31, 104, '贞元镇'),
(61, 04, 31, 105, '长宁镇'),
(61, 04, 31, 106, '小村镇'),
(61, 04, 31, 107, '大庄镇');
/* 陕西省 咸阳市 兴平市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 04, 81, 001, '东城街道办事处'),
(61, 04, 81, 002, '西城街道办事处'),
(61, 04, 81, 003, '店张街道办事处'),
(61, 04, 81, 004, '西吴街道办事处'),
(61, 04, 81, 005, '马嵬街道办事处'),
(61, 04, 81, 101, '赵村镇'),
(61, 04, 81, 102, '桑镇'),
(61, 04, 81, 104, '南市镇'),
(61, 04, 81, 105, '庄头镇'),
(61, 04, 81, 106, '南位镇'),
(61, 04, 81, 107, '阜寨镇'),
(61, 04, 81, 108, '丰仪镇'),
(61, 04, 81, 109, '汤坊镇');
/* 陕西省 渭南市 临渭区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 02, 001, '杜桥街道办事处'),
(61, 05, 02, 002, '人民街道办事处'),
(61, 05, 02, 003, '解放街道办事处'),
(61, 05, 02, 004, '向阳街道办事处'),
(61, 05, 02, 005, '站南街道办事处'),
(61, 05, 02, 006, '双王街道办事处'),
(61, 05, 02, 007, '良田街道办事处'),
(61, 05, 02, 008, '崇业路街道办事处'),
(61, 05, 02, 100, '桥南镇'),
(61, 05, 02, 101, '阳郭镇'),
(61, 05, 02, 102, '故市镇'),
(61, 05, 02, 103, '下邽镇'),
(61, 05, 02, 104, '三张镇'),
(61, 05, 02, 105, '交斜镇'),
(61, 05, 02, 106, '辛市镇'),
(61, 05, 02, 107, '崇宁镇'),
(61, 05, 02, 108, '孝义镇'),
(61, 05, 02, 109, '吝店镇'),
(61, 05, 02, 111, '官底镇'),
(61, 05, 02, 112, '官路镇'),
(61, 05, 02, 113, '丰原镇'),
(61, 05, 02, 114, '阎村镇'),
(61, 05, 02, 115, '龙背镇'),
(61, 05, 02, 116, '官道镇');
/* 陕西省 渭南市 华县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 21, 001, '华州街道办事处'),
(61, 05, 21, 101, '杏林镇'),
(61, 05, 21, 102, '赤水镇'),
(61, 05, 21, 103, '高塘镇'),
(61, 05, 21, 104, '大明镇'),
(61, 05, 21, 105, '瓜坡镇'),
(61, 05, 21, 106, '莲花寺镇'),
(61, 05, 21, 107, '柳枝镇'),
(61, 05, 21, 108, '下庙镇'),
(61, 05, 21, 109, '金堆镇');
/* 陕西省 渭南市 潼关县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 22, 001, '城关街道办事处'),
(61, 05, 22, 101, '秦东镇'),
(61, 05, 22, 102, '太要镇'),
(61, 05, 22, 103, '桐峪镇'),
(61, 05, 22, 104, '代字营镇');
/* 陕西省 渭南市 大荔县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 23, 001, '城关街道办事处'),
(61, 05, 23, 101, '许庄镇'),
(61, 05, 23, 102, '朝邑镇'),
(61, 05, 23, 103, '安仁镇'),
(61, 05, 23, 104, '两宜镇'),
(61, 05, 23, 105, '羌白镇'),
(61, 05, 23, 106, '官池镇'),
(61, 05, 23, 107, '冯村镇'),
(61, 05, 23, 108, '双泉镇'),
(61, 05, 23, 110, '下寨镇'),
(61, 05, 23, 111, '韦林镇'),
(61, 05, 23, 112, '范家镇'),
(61, 05, 23, 113, '苏村镇'),
(61, 05, 23, 114, '赵渡镇'),
(61, 05, 23, 116, '埝桥镇'),
(61, 05, 23, 117, '段家镇');
/* 陕西省 渭南市 合阳县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 24, 001, '城关街道办事处'),
(61, 05, 24, 101, '甘井镇'),
(61, 05, 24, 102, '坊镇'),
(61, 05, 24, 103, '洽川镇'),
(61, 05, 24, 104, '新池镇'),
(61, 05, 24, 105, '黑池镇'),
(61, 05, 24, 106, '路井镇'),
(61, 05, 24, 107, '和家庄镇'),
(61, 05, 24, 108, '王村镇'),
(61, 05, 24, 110, '同家庄镇'),
(61, 05, 24, 111, '百良镇'),
(61, 05, 24, 112, '金峪镇');
/* 陕西省 渭南市 澄城县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 25, 001, '城关街道办事处'),
(61, 05, 25, 101, '冯原镇'),
(61, 05, 25, 102, '王庄镇'),
(61, 05, 25, 103, '尧头镇'),
(61, 05, 25, 104, '赵庄镇'),
(61, 05, 25, 105, '交道镇'),
(61, 05, 25, 106, '寺前镇'),
(61, 05, 25, 107, '韦庄镇'),
(61, 05, 25, 108, '安里镇'),
(61, 05, 25, 109, '庄头镇');
/* 陕西省 渭南市 蒲城县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 26, 001, '城关街道办事处'),
(61, 05, 26, 101, '罕井镇'),
(61, 05, 26, 102, '孙镇'),
(61, 05, 26, 103, '兴镇'),
(61, 05, 26, 104, '党睦镇'),
(61, 05, 26, 105, '高阳镇'),
(61, 05, 26, 106, '永丰镇'),
(61, 05, 26, 107, '荆姚镇'),
(61, 05, 26, 108, '苏坊镇'),
(61, 05, 26, 109, '龙阳镇'),
(61, 05, 26, 112, '洛滨镇'),
(61, 05, 26, 113, '陈庄镇'),
(61, 05, 26, 114, '桥陵镇'),
(61, 05, 26, 116, '尧山镇'),
(61, 05, 26, 117, '椿林镇'),
(61, 05, 26, 118, '龙池镇');
/* 陕西省 渭南市 白水县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 27, 001, '城关街道办事处'),
(61, 05, 27, 102, '尧禾镇'),
(61, 05, 27, 103, '杜康镇'),
(61, 05, 27, 104, '西固镇'),
(61, 05, 27, 105, '林皋镇'),
(61, 05, 27, 106, '史官镇'),
(61, 05, 27, 107, '北塬镇'),
(61, 05, 27, 109, '雷牙镇');
/* 陕西省 渭南市 富平县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 28, 001, '城关街道办事处'),
(61, 05, 28, 101, '庄里镇'),
(61, 05, 28, 102, '张桥镇'),
(61, 05, 28, 103, '美原镇'),
(61, 05, 28, 104, '流曲镇'),
(61, 05, 28, 105, '淡村镇'),
(61, 05, 28, 107, '留古镇'),
(61, 05, 28, 108, '老庙镇'),
(61, 05, 28, 109, '薛镇'),
(61, 05, 28, 110, '到贤镇'),
(61, 05, 28, 111, '曹村镇'),
(61, 05, 28, 112, '宫里镇'),
(61, 05, 28, 113, '梅家坪镇'),
(61, 05, 28, 114, '刘集镇'),
(61, 05, 28, 115, '齐村镇');
/* 陕西省 渭南市 韩城市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 81, 001, '新城街道办事处'),
(61, 05, 81, 002, '金城街道办事处'),
(61, 05, 81, 100, '龙门镇'),
(61, 05, 81, 101, '桑树坪镇'),
(61, 05, 81, 103, '芝川镇'),
(61, 05, 81, 104, '西庄镇'),
(61, 05, 81, 106, '芝阳镇'),
(61, 05, 81, 107, '板桥镇');
/* 陕西省 渭南市 华阴市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 05, 82, 001, '太华路街道办事处'),
(61, 05, 82, 002, '岳庙街道办事处'),
(61, 05, 82, 100, '孟塬镇'),
(61, 05, 82, 103, '华西镇'),
(61, 05, 82, 104, '罗敷镇'),
(61, 05, 82, 105, '华山镇');
/* 陕西省 延安市 宝塔区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 02, 001, '宝塔山街道办事处'),
(61, 06, 02, 002, '南市街道办事处'),
(61, 06, 02, 003, '凤凰山街道办事处'),
(61, 06, 02, 004, '枣园街道办事处'),
(61, 06, 02, 005, '桥沟街道办事处'),
(61, 06, 02, 102, '河庄坪镇'),
(61, 06, 02, 103, '李渠镇'),
(61, 06, 02, 104, '姚店镇'),
(61, 06, 02, 105, '青化砭镇'),
(61, 06, 02, 106, '蟠龙镇'),
(61, 06, 02, 107, '柳林镇'),
(61, 06, 02, 108, '南泥湾镇'),
(61, 06, 02, 109, '临镇'),
(61, 06, 02, 110, '甘谷驿镇'),
(61, 06, 02, 200, '川口乡'),
(61, 06, 02, 202, '冯庄乡'),
(61, 06, 02, 205, '麻洞川乡'),
(61, 06, 02, 208, '万花山乡');
/* 陕西省 延安市 延长县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 21, 001, '七里村街道办事处'),
(61, 06, 21, 101, '黑家堡镇'),
(61, 06, 21, 102, '郑庄镇'),
(61, 06, 21, 103, '张家滩镇'),
(61, 06, 21, 104, '交口镇'),
(61, 06, 21, 106, '雷赤镇'),
(61, 06, 21, 107, '罗子山镇'),
(61, 06, 21, 108, '安沟镇');
/* 陕西省 延安市 延川县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 22, 001, '大禹街道办事处'),
(61, 06, 22, 101, '永坪镇'),
(61, 06, 22, 102, '延水关镇'),
(61, 06, 22, 103, '文安驿镇'),
(61, 06, 22, 104, '杨家圪台镇'),
(61, 06, 22, 105, '贾家坪镇'),
(61, 06, 22, 107, '关庄镇'),
(61, 06, 22, 108, '乾坤湾镇');
/* 陕西省 延安市 子长县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 23, 001, '瓦窑堡街道办事处'),
(61, 06, 23, 101, '杨家园子镇'),
(61, 06, 23, 102, '玉家湾镇'),
(61, 06, 23, 103, '安定镇'),
(61, 06, 23, 104, '马家砭镇'),
(61, 06, 23, 105, '南沟岔镇'),
(61, 06, 23, 106, '涧峪岔镇'),
(61, 06, 23, 107, '李家岔镇'),
(61, 06, 23, 108, '余家坪镇');
/* 陕西省 延安市 安塞县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 24, 001, '真武洞街道办事处'),
(61, 06, 24, 101, '砖窑湾镇'),
(61, 06, 24, 102, '沿河湾镇'),
(61, 06, 24, 103, '招安镇'),
(61, 06, 24, 104, '化子坪镇'),
(61, 06, 24, 105, '坪桥镇'),
(61, 06, 24, 106, '建华镇'),
(61, 06, 24, 107, '高桥镇'),
(61, 06, 24, 108, '镰刀湾镇');
/* 陕西省 延安市 志丹县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 25, 001, '保安街道办事处'),
(61, 06, 25, 101, '杏河镇'),
(61, 06, 25, 102, '顺宁镇'),
(61, 06, 25, 103, '旦八镇'),
(61, 06, 25, 104, '金丁镇'),
(61, 06, 25, 105, '永宁镇'),
(61, 06, 25, 106, '义正镇'),
(61, 06, 25, 107, '双河镇');
/* 陕西省 延安市 吴起县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 26, 001, '吴起街道办事处'),
(61, 06, 26, 101, '铁边城镇'),
(61, 06, 26, 102, '周湾镇'),
(61, 06, 26, 103, '白豹镇'),
(61, 06, 26, 104, '长官庙镇'),
(61, 06, 26, 105, '长城镇'),
(61, 06, 26, 106, '五谷城镇'),
(61, 06, 26, 107, '吴仓堡镇'),
(61, 06, 26, 108, '庙沟镇');
/* 陕西省 延安市 甘泉县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 27, 001, '美水街道办事处'),
(61, 06, 27, 101, '下寺湾镇'),
(61, 06, 27, 102, '道镇'),
(61, 06, 27, 103, '石门镇'),
(61, 06, 27, 200, '桥镇乡'),
(61, 06, 27, 203, '劳山乡');
/* 陕西省 延安市 富县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 28, 001, '茶坊街道办事处'),
(61, 06, 28, 101, '羊泉镇'),
(61, 06, 28, 102, '张村驿镇'),
(61, 06, 28, 103, '张家湾镇'),
(61, 06, 28, 104, '直罗镇'),
(61, 06, 28, 106, '牛武镇'),
(61, 06, 28, 109, '寺仙镇'),
(61, 06, 28, 204, '北道德乡');
/* 陕西省 延安市 洛川县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 29, 001, '凤栖街道办事处'),
(61, 06, 29, 101, '旧县镇'),
(61, 06, 29, 102, '交口河镇'),
(61, 06, 29, 103, '老庙镇'),
(61, 06, 29, 104, '土基镇'),
(61, 06, 29, 105, '石头镇'),
(61, 06, 29, 106, '槐柏镇'),
(61, 06, 29, 107, '永乡镇'),
(61, 06, 29, 200, '菩堤乡');
/* 陕西省 延安市 宜川县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 30, 001, '丹州街道办事处'),
(61, 06, 30, 101, '秋林镇'),
(61, 06, 30, 102, '云岩镇'),
(61, 06, 30, 104, '集义镇'),
(61, 06, 30, 105, '壶口镇'),
(61, 06, 30, 200, '英旺乡'),
(61, 06, 30, 201, '交里乡');
/* 陕西省 延安市 黄龙县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 31, 100, '石堡镇'),
(61, 06, 31, 101, '白马滩镇'),
(61, 06, 31, 102, '瓦子街镇'),
(61, 06, 31, 106, '界头庙镇'),
(61, 06, 31, 107, '三岔镇'),
(61, 06, 31, 205, '圪台乡'),
(61, 06, 31, 206, '崾崄乡');
/* 陕西省 延安市 黄陵县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 06, 32, 001, '桥山街道办事处'),
(61, 06, 32, 101, '店头镇'),
(61, 06, 32, 102, '隆坊镇'),
(61, 06, 32, 103, '田庄镇'),
(61, 06, 32, 104, '阿党镇'),
(61, 06, 32, 105, '双龙镇');
/* 陕西省 汉中市 汉台区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 07, 02, 001, '北关街道办事处'),
(61, 07, 02, 002, '东大街街道办事处'),
(61, 07, 02, 003, '汉中路街道办事处'),
(61, 07, 02, 004, '中山街街道办事处'),
(61, 07, 02, 005, '东关街道办事处'),
(61, 07, 02, 006, '鑫源街道办事处'),
(61, 07, 02, 008, '七里街道办事处'),
(61, 07, 02, 009, '龙江街道办事处'),
(61, 07, 02, 100, '铺镇'),
(61, 07, 02, 101, '武乡镇'),
(61, 07, 02, 102, '河东店镇'),
(61, 07, 02, 104, '宗营镇'),
(61, 07, 02, 105, '老君镇'),
(61, 07, 02, 106, '汉王镇'),
(61, 07, 02, 107, '徐望镇');
/* 陕西省 汉中市 南郑县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 07, 21, 001, '汉山街道办事处'),
(61, 07, 21, 101, '圣水镇'),
(61, 07, 21, 102, '大河坎镇'),
(61, 07, 21, 103, '协税镇'),
(61, 07, 21, 104, '梁山镇'),
(61, 07, 21, 105, '阳春镇'),
(61, 07, 21, 106, '高台镇'),
(61, 07, 21, 107, '新集镇'),
(61, 07, 21, 108, '濂水镇'),
(61, 07, 21, 109, '黄官镇'),
(61, 07, 21, 110, '青树镇'),
(61, 07, 21, 111, '红庙镇'),
(61, 07, 21, 112, '牟家坝镇'),
(61, 07, 21, 113, '法镇'),
(61, 07, 21, 114, '湘水镇'),
(61, 07, 21, 115, '小南海镇'),
(61, 07, 21, 116, '碑坝镇'),
(61, 07, 21, 117, '黎坪镇'),
(61, 07, 21, 118, '福成镇'),
(61, 07, 21, 119, '两河镇'),
(61, 07, 21, 120, '胡家营镇');
/* 陕西省 汉中市 城固县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(61, 07, 22, 001, '博望街道办事处'),
(61, 07, 22, 002, '莲花街道办事处'),
(61, 07, 22, 101, '龙头镇'),
(61, 07, 22, 102, '沙河营镇'),
(61, 07, 22, 103, '文川镇'),
(61, 07, 22, 104, '柳林镇'),
(61, 07, 22, 105, '老庄镇'),
(61, 07, 22, 107, '桔园镇'),
(61, 07, 22, 108, '原公镇'),