-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathAdministratives-China(Street)-6.sql
3794 lines (3535 loc) · 134 KB
/
Administratives-China(Street)-6.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）
* 数据范围：广东省(44)、广西省(45)、海南省(46)。
*/
/* 广东省 广州市 荔湾区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 03, 001, '沙面街道'),
(44, 01, 03, 002, '岭南街道'),
(44, 01, 03, 003, '华林街道'),
(44, 01, 03, 004, '多宝街道'),
(44, 01, 03, 005, '昌华街道'),
(44, 01, 03, 006, '逢源街道'),
(44, 01, 03, 007, '龙津街道'),
(44, 01, 03, 008, '金花街道'),
(44, 01, 03, 009, '彩虹街道'),
(44, 01, 03, 010, '南源街道'),
(44, 01, 03, 011, '西村街道'),
(44, 01, 03, 012, '站前街道'),
(44, 01, 03, 013, '桥中街道'),
(44, 01, 03, 014, '白鹤洞街道'),
(44, 01, 03, 015, '冲口街道'),
(44, 01, 03, 016, '花地街道'),
(44, 01, 03, 017, '石围塘街道'),
(44, 01, 03, 018, '茶滘街道'),
(44, 01, 03, 019, '东漖街道'),
(44, 01, 03, 020, '海龙街道'),
(44, 01, 03, 021, '东沙街道'),
(44, 01, 03, 022, '中南街道');
/* 广东省 广州市 越秀区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 04, 001, '洪桥街道'),
(44, 01, 04, 003, '北京街道'),
(44, 01, 04, 004, '六榕街道'),
(44, 01, 04, 005, '流花街道'),
(44, 01, 04, 007, '光塔街道'),
(44, 01, 04, 010, '人民街道'),
(44, 01, 04, 011, '东山街道'),
(44, 01, 04, 012, '农林街道'),
(44, 01, 04, 013, '梅花村街道'),
(44, 01, 04, 014, '黄花岗街道'),
(44, 01, 04, 015, '华乐街道'),
(44, 01, 04, 016, '建设街道'),
(44, 01, 04, 017, '大塘街道'),
(44, 01, 04, 018, '珠光街道'),
(44, 01, 04, 019, '大东街道'),
(44, 01, 04, 020, '白云街道'),
(44, 01, 04, 021, '登峰街道'),
(44, 01, 04, 022, '矿泉街道');
/* 广东省 广州市 海珠区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 05, 001, '赤岗街道'),
(44, 01, 05, 002, '新港街道'),
(44, 01, 05, 003, '昌岗街道'),
(44, 01, 05, 004, '江南中街道'),
(44, 01, 05, 005, '滨江街道'),
(44, 01, 05, 006, '素社街道'),
(44, 01, 05, 007, '海幢街道'),
(44, 01, 05, 008, '南华西街道'),
(44, 01, 05, 009, '龙凤街道'),
(44, 01, 05, 010, '沙园街道'),
(44, 01, 05, 011, '南石头街道'),
(44, 01, 05, 012, '凤阳街道'),
(44, 01, 05, 013, '瑞宝街道'),
(44, 01, 05, 014, '江海街道'),
(44, 01, 05, 015, '琶洲街道'),
(44, 01, 05, 016, '南洲街道'),
(44, 01, 05, 017, '华洲街道'),
(44, 01, 05, 018, '官洲街道');
/* 广东省 广州市 天河区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 06, 001, '五山街道'),
(44, 01, 06, 002, '员村街道'),
(44, 01, 06, 003, '车陂街道'),
(44, 01, 06, 004, '沙河街道'),
(44, 01, 06, 006, '石牌街道'),
(44, 01, 06, 007, '沙东街道'),
(44, 01, 06, 008, '天河南街道'),
(44, 01, 06, 009, '林和街道'),
(44, 01, 06, 010, '兴华街道'),
(44, 01, 06, 011, '棠下街道'),
(44, 01, 06, 012, '天园街道'),
(44, 01, 06, 013, '猎德街道'),
(44, 01, 06, 014, '冼村街道'),
(44, 01, 06, 015, '元岗街道'),
(44, 01, 06, 016, '黄村街道'),
(44, 01, 06, 017, '长兴街道'),
(44, 01, 06, 018, '龙洞街道'),
(44, 01, 06, 019, '凤凰街道'),
(44, 01, 06, 020, '前进街道'),
(44, 01, 06, 021, '珠吉街道'),
(44, 01, 06, 022, '新塘街道');
/* 广东省 广州市 白云区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 11, 002, '三元里街道'),
(44, 01, 11, 003, '松洲街道'),
(44, 01, 11, 004, '景泰街道'),
(44, 01, 11, 005, '同德街道'),
(44, 01, 11, 006, '黄石街道'),
(44, 01, 11, 007, '棠景街道'),
(44, 01, 11, 008, '新市街道'),
(44, 01, 11, 009, '同和街道'),
(44, 01, 11, 010, '京溪街道'),
(44, 01, 11, 011, '永平街道'),
(44, 01, 11, 012, '嘉禾街道'),
(44, 01, 11, 013, '均禾街道'),
(44, 01, 11, 014, '石井街道'),
(44, 01, 11, 015, '金沙街道'),
(44, 01, 11, 016, '云城街道'),
(44, 01, 11, 017, '鹤龙街道'),
(44, 01, 11, 018, '白云湖街道'),
(44, 01, 11, 019, '石门街道'),
(44, 01, 11, 103, '人和镇'),
(44, 01, 11, 107, '太和镇'),
(44, 01, 11, 108, '钟落潭镇'),
(44, 01, 11, 113, '江高镇');
/* 广东省 广州市 黄埔区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 12, 001, '黄埔街道'),
(44, 01, 12, 002, '红山街道'),
(44, 01, 12, 003, '鱼珠街道'),
(44, 01, 12, 005, '大沙街道'),
(44, 01, 12, 006, '文冲街道'),
(44, 01, 12, 007, '穗东街道'),
(44, 01, 12, 008, '南岗街道'),
(44, 01, 12, 009, '荔联街道'),
(44, 01, 12, 010, '长洲街道'),
(44, 01, 12, 011, '夏港街道'),
(44, 01, 12, 012, '萝岗街道'),
(44, 01, 12, 013, '东区街道'),
(44, 01, 12, 014, '联和街道'),
(44, 01, 12, 015, '永和街道'),
(44, 01, 12, 101, '九龙镇');
/* 广东省 广州市 番禺区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 13, 007, '市桥街道'),
(44, 01, 13, 008, '沙头街道'),
(44, 01, 13, 009, '东环街道'),
(44, 01, 13, 010, '桥南街道'),
(44, 01, 13, 011, '小谷围街道'),
(44, 01, 13, 012, '大石街道'),
(44, 01, 13, 013, '洛浦街道'),
(44, 01, 13, 014, '石壁街道'),
(44, 01, 13, 015, '钟村街道'),
(44, 01, 13, 016, '大龙街道'),
(44, 01, 13, 102, '南村镇'),
(44, 01, 13, 103, '新造镇'),
(44, 01, 13, 104, '化龙镇'),
(44, 01, 13, 105, '石楼镇'),
(44, 01, 13, 118, '沙湾镇'),
(44, 01, 13, 120, '石基镇');
/* 广东省 广州市 花都区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 14, 001, '新华街道办事处'),
(44, 01, 14, 002, '花城街道办事处'),
(44, 01, 14, 003, '秀全街道办事处'),
(44, 01, 14, 004, '新雅街道办事处'),
(44, 01, 14, 103, '梯面镇'),
(44, 01, 14, 104, '花山镇'),
(44, 01, 14, 105, '花东镇'),
(44, 01, 14, 107, '炭步镇'),
(44, 01, 14, 108, '赤坭镇'),
(44, 01, 14, 109, '狮岭镇');
/* 广东省 广州市 南沙区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 15, 001, '南沙街道'),
(44, 01, 15, 002, '珠江街道'),
(44, 01, 15, 003, '龙穴街道'),
(44, 01, 15, 100, '万顷沙镇'),
(44, 01, 15, 101, '横沥镇'),
(44, 01, 15, 102, '黄阁镇'),
(44, 01, 15, 103, '东涌镇'),
(44, 01, 15, 104, '大岗镇'),
(44, 01, 15, 105, '榄核镇');
/* 广东省 广州市 从化区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 17, 001, '街口街道'),
(44, 01, 17, 002, '江埔街道'),
(44, 01, 17, 003, '城郊街道'),
(44, 01, 17, 103, '温泉镇'),
(44, 01, 17, 104, '良口镇'),
(44, 01, 17, 107, '吕田镇'),
(44, 01, 17, 111, '太平镇'),
(44, 01, 17, 113, '鳌头镇');
/* 广东省 广州市 增城区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 01, 18, 001, '荔城街道'),
(44, 01, 18, 002, '增江街道'),
(44, 01, 18, 003, '朱村街道'),
(44, 01, 18, 004, '永宁街道'),
(44, 01, 18, 101, '新塘镇'),
(44, 01, 18, 102, '石滩镇'),
(44, 01, 18, 103, '中新镇'),
(44, 01, 18, 104, '正果镇'),
(44, 01, 18, 105, '派潭镇'),
(44, 01, 18, 106, '小楼镇'),
(44, 01, 18, 107, '仙村镇');
/* 广东省 韶关市 武江区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 03, 001, '新华街道办事处'),
(44, 02, 03, 002, '惠民街道办事处'),
(44, 02, 03, 100, '西联镇'),
(44, 02, 03, 101, '西河镇'),
(44, 02, 03, 102, '龙归镇'),
(44, 02, 03, 103, '江湾镇'),
(44, 02, 03, 104, '重阳镇');
/* 广东省 韶关市 浈江区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 04, 001, '东河街道办事处'),
(44, 02, 04, 002, '车站街道办事处'),
(44, 02, 04, 008, '风采街道办事处'),
(44, 02, 04, 100, '新韶镇'),
(44, 02, 04, 101, '乐园镇'),
(44, 02, 04, 102, '十里亭镇'),
(44, 02, 04, 103, '犁市镇'),
(44, 02, 04, 104, '花坪镇');
/* 广东省 韶关市 曲江区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 05, 001, '松山街道办事处'),
(44, 02, 05, 100, '马坝镇'),
(44, 02, 05, 101, '大塘镇'),
(44, 02, 05, 102, '枫湾镇'),
(44, 02, 05, 103, '小坑镇'),
(44, 02, 05, 104, '沙溪镇'),
(44, 02, 05, 106, '乌石镇'),
(44, 02, 05, 107, '樟市镇'),
(44, 02, 05, 108, '白土镇'),
(44, 02, 05, 109, '罗坑镇');
/* 广东省 韶关市 始兴县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 22, 100, '太平镇'),
(44, 02, 22, 101, '马市镇'),
(44, 02, 22, 102, '澄江镇'),
(44, 02, 22, 103, '顿岗镇'),
(44, 02, 22, 104, '罗坝镇'),
(44, 02, 22, 105, '司前镇'),
(44, 02, 22, 106, '隘子镇'),
(44, 02, 22, 107, '城南镇'),
(44, 02, 22, 108, '沈所镇'),
(44, 02, 22, 204, '深渡水乡');
/* 广东省 韶关市 仁化县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 24, 001, '丹霞街道办事处'),
(44, 02, 24, 102, '闻韶镇'),
(44, 02, 24, 103, '扶溪镇'),
(44, 02, 24, 104, '长江镇'),
(44, 02, 24, 105, '城口镇'),
(44, 02, 24, 106, '红山镇'),
(44, 02, 24, 107, '石塘镇'),
(44, 02, 24, 108, '董塘镇'),
(44, 02, 24, 109, '大桥镇'),
(44, 02, 24, 110, '周田镇'),
(44, 02, 24, 111, '黄坑镇');
/* 广东省 韶关市 翁源县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 29, 100, '龙仙镇'),
(44, 02, 29, 104, '坝仔镇'),
(44, 02, 29, 106, '江尾镇'),
(44, 02, 29, 109, '官渡镇'),
(44, 02, 29, 111, '周陂镇'),
(44, 02, 29, 113, '翁城镇'),
(44, 02, 29, 114, '新江镇');
/* 广东省 韶关市 乳源瑶族自治县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 32, 100, '乳城镇'),
(44, 02, 32, 103, '一六镇'),
(44, 02, 32, 104, '桂头镇'),
(44, 02, 32, 106, '洛阳镇'),
(44, 02, 32, 108, '大布镇'),
(44, 02, 32, 109, '大桥镇'),
(44, 02, 32, 111, '东坪镇'),
(44, 02, 32, 112, '游溪镇'),
(44, 02, 32, 113, '必背镇');
/* 广东省 韶关市 新丰县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 33, 001, '丰城街道办事处'),
(44, 02, 33, 100, '黄礤镇'),
(44, 02, 33, 101, '马头镇'),
(44, 02, 33, 102, '梅坑镇'),
(44, 02, 33, 103, '沙田镇'),
(44, 02, 33, 104, '遥田镇'),
(44, 02, 33, 105, '回龙镇');
/* 广东省 韶关市 乐昌市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 81, 001, '乐城街道办事处'),
(44, 02, 81, 102, '北乡镇'),
(44, 02, 81, 103, '九峰镇'),
(44, 02, 81, 104, '廊田镇'),
(44, 02, 81, 105, '长来镇'),
(44, 02, 81, 106, '梅花镇'),
(44, 02, 81, 107, '三溪镇'),
(44, 02, 81, 108, '坪石镇'),
(44, 02, 81, 110, '黄圃镇'),
(44, 02, 81, 111, '五山镇'),
(44, 02, 81, 112, '两江镇'),
(44, 02, 81, 113, '沙坪镇'),
(44, 02, 81, 114, '云岩镇'),
(44, 02, 81, 115, '秀水镇'),
(44, 02, 81, 117, '大源镇'),
(44, 02, 81, 118, '庆云镇'),
(44, 02, 81, 119, '白石镇');
/* 广东省 韶关市 南雄市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 02, 82, 001, '雄州街道办事处'),
(44, 02, 82, 100, '乌迳镇'),
(44, 02, 82, 103, '界址镇'),
(44, 02, 82, 104, '坪田镇'),
(44, 02, 82, 105, '黄坑镇'),
(44, 02, 82, 106, '邓坊镇'),
(44, 02, 82, 107, '油山镇'),
(44, 02, 82, 109, '南亩镇'),
(44, 02, 82, 110, '水口镇'),
(44, 02, 82, 111, '江头镇'),
(44, 02, 82, 112, '湖口镇'),
(44, 02, 82, 113, '珠玑镇'),
(44, 02, 82, 115, '主田镇'),
(44, 02, 82, 116, '古市镇'),
(44, 02, 82, 118, '全安镇'),
(44, 02, 82, 120, '百顺镇'),
(44, 02, 82, 121, '澜河镇'),
(44, 02, 82, 122, '帽子峰镇');
/* 广东省 深圳市 罗湖区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 03, 03, 001, '桂园街道办事处'),
(44, 03, 03, 002, '黄贝街道办事处'),
(44, 03, 03, 003, '东门街道办事处'),
(44, 03, 03, 004, '翠竹街道办事处'),
(44, 03, 03, 005, '南湖街道办事处'),
(44, 03, 03, 006, '笋岗街道办事处'),
(44, 03, 03, 007, '东湖街道办事处'),
(44, 03, 03, 008, '莲塘街道办事处'),
(44, 03, 03, 009, '东晓街道办事处'),
(44, 03, 03, 010, '清水河街道办事处');
/* 广东省 深圳市 福田区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 03, 04, 001, '南园街道办事处'),
(44, 03, 04, 002, '园岭街道办事处'),
(44, 03, 04, 004, '福田街道办事处'),
(44, 03, 04, 005, '沙头街道办事处'),
(44, 03, 04, 006, '香蜜湖街道办事处'),
(44, 03, 04, 007, '梅林街道办事处'),
(44, 03, 04, 008, '莲花街道办事处'),
(44, 03, 04, 009, '华富街道办事处'),
(44, 03, 04, 010, '福保街道办事处'),
(44, 03, 04, 011, '华强北街道办事处');
/* 广东省 深圳市 南山区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 03, 05, 001, '南头街道办事处'),
(44, 03, 05, 002, '南山街道办事处'),
(44, 03, 05, 003, '沙河街道办事处'),
(44, 03, 05, 005, '蛇口街道办事处'),
(44, 03, 05, 006, '招商街道办事处'),
(44, 03, 05, 007, '粤海街道办事处'),
(44, 03, 05, 008, '桃源街道办事处'),
(44, 03, 05, 009, '西丽街道办事处');
/* 广东省 深圳市 宝安区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 03, 06, 001, '新安街道办事处'),
(44, 03, 06, 002, '光明办事处'),
(44, 03, 06, 003, '西乡街道办事处'),
(44, 03, 06, 004, '福永街道办事处'),
(44, 03, 06, 005, '沙井街道办事处'),
(44, 03, 06, 006, '松岗街道办事处'),
(44, 03, 06, 007, '公明办事处'),
(44, 03, 06, 008, '石岩街道办事处'),
(44, 03, 06, 011, '大浪办事处'),
(44, 03, 06, 012, '龙华办事处'),
(44, 03, 06, 013, '民治办事处'),
(44, 03, 06, 014, '观湖办事处'),
(44, 03, 06, 015, '福城办事处'),
(44, 03, 06, 016, '观澜办事处');
/* 广东省 深圳市 龙岗区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 03, 07, 003, '平湖街道办事处'),
(44, 03, 07, 006, '坪地街道办事处'),
(44, 03, 07, 007, '坪山街道办事处'),
(44, 03, 07, 008, '坑梓街道办事处'),
(44, 03, 07, 009, '葵涌街道办事处'),
(44, 03, 07, 010, '大鹏街道办事处'),
(44, 03, 07, 011, '南澳街道办事处'),
(44, 03, 07, 012, '南湾街道办事处'),
(44, 03, 07, 013, '坂田街道办事处'),
(44, 03, 07, 014, '布吉街道办事处'),
(44, 03, 07, 015, '龙城街道办事处'),
(44, 03, 07, 016, '龙岗街道办事处'),
(44, 03, 07, 017, '横岗街道办事处');
/* 广东省 深圳市 盐田区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 03, 08, 001, '梅沙街道办事处'),
(44, 03, 08, 002, '盐田街道办事处'),
(44, 03, 08, 003, '沙头角街道办事处'),
(44, 03, 08, 004, '海山街道办事处');
/* 广东省 珠海市 香洲区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 04, 02, 001, '翠香街道办'),
(44, 04, 02, 002, '梅华街道办'),
(44, 04, 02, 003, '前山街道办'),
(44, 04, 02, 004, '吉大街道办'),
(44, 04, 02, 005, '拱北街道办'),
(44, 04, 02, 006, '香湾街道办'),
(44, 04, 02, 007, '狮山街道办'),
(44, 04, 02, 008, '湾仔街道办'),
(44, 04, 02, 100, '唐家湾镇'),
(44, 04, 02, 102, '南屏镇'),
(44, 04, 02, 104, '横琴镇'),
(44, 04, 02, 105, '桂山镇'),
(44, 04, 02, 106, '万山镇'),
(44, 04, 02, 107, '担杆镇');
/* 广东省 珠海市 斗门区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 04, 03, 001, '白藤街道办事处'),
(44, 04, 03, 100, '莲洲镇'),
(44, 04, 03, 103, '斗门镇'),
(44, 04, 03, 105, '乾务镇'),
(44, 04, 03, 106, '白蕉镇'),
(44, 04, 03, 107, '井岸镇');
/* 广东省 珠海市 金湾区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 04, 04, 100, '三灶镇'),
(44, 04, 04, 101, '南水镇'),
(44, 04, 04, 103, '红旗镇'),
(44, 04, 04, 104, '平沙镇');
/* 广东省 汕头市 龙湖区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 05, 07, 001, '金霞街道'),
(44, 05, 07, 003, '珠池街道'),
(44, 05, 07, 004, '新津街道'),
(44, 05, 07, 005, '鸥汀街道'),
(44, 05, 07, 008, '龙祥街道'),
(44, 05, 07, 100, '外砂镇'),
(44, 05, 07, 101, '新溪镇');
/* 广东省 汕头市 金平区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 05, 11, 001, '石炮台街道'),
(44, 05, 11, 002, '金砂街道'),
(44, 05, 11, 003, '金厦街道'),
(44, 05, 11, 004, '东方街道'),
(44, 05, 11, 005, '大华街道'),
(44, 05, 11, 006, '同益街道'),
(44, 05, 11, 007, '光华街道'),
(44, 05, 11, 008, '东墩街道'),
(44, 05, 11, 009, '广厦街道'),
(44, 05, 11, 010, '海安街道'),
(44, 05, 11, 011, '新福街道'),
(44, 05, 11, 012, '乌桥街道'),
(44, 05, 11, 013, '岐山街道'),
(44, 05, 11, 014, '永祥街道'),
(44, 05, 11, 015, '鮀莲街道'),
(44, 05, 11, 016, '鮀江街道'),
(44, 05, 11, 017, '月浦街道');
/* 广东省 汕头市 濠江区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 05, 12, 001, '达濠街道'),
(44, 05, 12, 002, '马窖街道'),
(44, 05, 12, 003, '礐石街道'),
(44, 05, 12, 004, '广澳街道'),
(44, 05, 12, 005, '滨海街道'),
(44, 05, 12, 006, '河浦街道'),
(44, 05, 12, 007, '玉新街道');
/* 广东省 汕头市 潮阳区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 05, 13, 001, '文光街道'),
(44, 05, 13, 002, '棉北街道'),
(44, 05, 13, 003, '城南街道'),
(44, 05, 13, 004, '金浦街道'),
(44, 05, 13, 100, '海门镇'),
(44, 05, 13, 101, '河溪镇'),
(44, 05, 13, 102, '和平镇'),
(44, 05, 13, 103, '西胪镇'),
(44, 05, 13, 104, '关埠镇'),
(44, 05, 13, 106, '谷饶镇'),
(44, 05, 13, 107, '贵屿镇'),
(44, 05, 13, 108, '铜盂镇'),
(44, 05, 13, 110, '金灶镇');
/* 广东省 汕头市 潮南区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 05, 14, 001, '峡山街道'),
(44, 05, 14, 101, '井都镇'),
(44, 05, 14, 103, '成田镇'),
(44, 05, 14, 104, '司马浦镇'),
(44, 05, 14, 105, '陈店镇'),
(44, 05, 14, 106, '两英镇'),
(44, 05, 14, 107, '仙城镇'),
(44, 05, 14, 108, '胪岗镇'),
(44, 05, 14, 109, '红场镇'),
(44, 05, 14, 110, '雷岭镇'),
(44, 05, 14, 112, '陇田镇');
/* 广东省 汕头市 澄海区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 05, 15, 001, '凤翔街道'),
(44, 05, 15, 002, '广益街道'),
(44, 05, 15, 003, '澄华街道'),
(44, 05, 15, 100, '上华镇'),
(44, 05, 15, 101, '隆都镇'),
(44, 05, 15, 102, '莲下镇'),
(44, 05, 15, 103, '莲上镇'),
(44, 05, 15, 104, '溪南镇'),
(44, 05, 15, 105, '东里镇'),
(44, 05, 15, 106, '盐鸿镇'),
(44, 05, 15, 107, '莲华镇');
/* 广东省 汕头市 南澳县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 05, 23, 100, '后宅镇'),
(44, 05, 23, 101, '云澳镇'),
(44, 05, 23, 102, '深澳镇');
/* 广东省 佛山市 禅城区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 06, 04, 010, '石湾镇街道办事处'),
(44, 06, 04, 011, '张槎街道办事处'),
(44, 06, 04, 012, '祖庙街道办事处'),
(44, 06, 04, 100, '南庄镇');
/* 广东省 佛山市 南海区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 06, 05, 011, '桂城街道办事处'),
(44, 06, 05, 121, '九江镇'),
(44, 06, 05, 122, '西樵镇'),
(44, 06, 05, 123, '丹灶镇'),
(44, 06, 05, 124, '狮山镇'),
(44, 06, 05, 125, '大沥镇'),
(44, 06, 05, 126, '里水镇');
/* 广东省 佛山市 顺德区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 06, 06, 003, '伦教街道办事处'),
(44, 06, 06, 004, '勒流街道办事处'),
(44, 06, 06, 005, '大良街道办事处'),
(44, 06, 06, 006, '容桂街道办事处'),
(44, 06, 06, 101, '陈村镇'),
(44, 06, 06, 102, '北滘镇'),
(44, 06, 06, 103, '乐从镇'),
(44, 06, 06, 104, '龙江镇'),
(44, 06, 06, 105, '杏坛镇'),
(44, 06, 06, 106, '均安镇');
/* 广东省 佛山市 三水区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 06, 07, 001, '西南街道办事处'),
(44, 06, 07, 004, '云东海街道办事处'),
(44, 06, 07, 101, '大塘镇'),
(44, 06, 07, 103, '乐平镇'),
(44, 06, 07, 104, '白坭镇'),
(44, 06, 07, 105, '芦苞镇'),
(44, 06, 07, 106, '南山镇');
/* 广东省 佛山市 高明区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 06, 08, 004, '荷城街道办事处'),
(44, 06, 08, 106, '杨和镇'),
(44, 06, 08, 107, '明城镇'),
(44, 06, 08, 108, '更合镇');
/* 广东省 江门市 蓬江区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 07, 03, 002, '白沙街道办事处'),
(44, 07, 03, 005, '潮连街道办事处'),
(44, 07, 03, 006, '环市街道办事处'),
(44, 07, 03, 101, '棠下镇'),
(44, 07, 03, 102, '荷塘镇'),
(44, 07, 03, 103, '杜阮镇');
/* 广东省 江门市 江海区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 07, 04, 001, '江南街道办事处'),
(44, 07, 04, 004, '外海街道办事处'),
(44, 07, 04, 005, '礼乐街道办事处');
/* 广东省 江门市 新会区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 07, 05, 001, '会城街道办'),
(44, 07, 05, 101, '大泽镇'),
(44, 07, 05, 102, '司前镇'),
(44, 07, 05, 103, '罗坑镇'),
(44, 07, 05, 104, '双水镇'),
(44, 07, 05, 105, '崖门镇'),
(44, 07, 05, 106, '沙堆镇'),
(44, 07, 05, 107, '古井镇'),
(44, 07, 05, 108, '三江镇'),
(44, 07, 05, 109, '睦洲镇'),
(44, 07, 05, 110, '大鳌镇');
/* 广东省 江门市 台山市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 07, 81, 001, '台城街道办事处'),
(44, 07, 81, 100, '大江镇'),
(44, 07, 81, 101, '水步镇'),
(44, 07, 81, 102, '四九镇'),
(44, 07, 81, 103, '白沙镇'),
(44, 07, 81, 104, '三合镇'),
(44, 07, 81, 105, '冲蒌镇'),
(44, 07, 81, 106, '斗山镇'),
(44, 07, 81, 107, '都斛镇'),
(44, 07, 81, 108, '赤溪镇'),
(44, 07, 81, 109, '端芬镇'),
(44, 07, 81, 110, '广海镇'),
(44, 07, 81, 111, '海宴镇'),
(44, 07, 81, 112, '汶村镇'),
(44, 07, 81, 113, '深井镇'),
(44, 07, 81, 114, '北陡镇'),
(44, 07, 81, 115, '川岛镇');
/* 广东省 江门市 开平市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 07, 83, 001, '三埠街道'),
(44, 07, 83, 002, '长沙街道'),
(44, 07, 83, 103, '沙塘镇'),
(44, 07, 83, 104, '苍城镇'),
(44, 07, 83, 105, '龙胜镇'),
(44, 07, 83, 106, '大沙镇'),
(44, 07, 83, 107, '马冈镇'),
(44, 07, 83, 108, '塘口镇'),
(44, 07, 83, 109, '赤坎镇'),
(44, 07, 83, 110, '百合镇'),
(44, 07, 83, 111, '蚬冈镇'),
(44, 07, 83, 112, '金鸡镇'),
(44, 07, 83, 115, '月山镇'),
(44, 07, 83, 116, '赤水镇'),
(44, 07, 83, 117, '水口镇');
/* 广东省 江门市 鹤山市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 07, 84, 001, '沙坪街道'),
(44, 07, 84, 101, '龙口镇'),
(44, 07, 84, 102, '雅瑶镇'),
(44, 07, 84, 103, '古劳镇'),
(44, 07, 84, 104, '桃源镇'),
(44, 07, 84, 105, '鹤城镇'),
(44, 07, 84, 106, '共和镇'),
(44, 07, 84, 107, '址山镇'),
(44, 07, 84, 108, '宅梧镇'),
(44, 07, 84, 112, '双合镇');
/* 广东省 江门市 恩平市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 07, 85, 001, '恩城街道办事处'),
(44, 07, 85, 100, '横陂镇'),
(44, 07, 85, 101, '圣堂镇'),
(44, 07, 85, 102, '良西镇'),
(44, 07, 85, 103, '沙湖镇'),
(44, 07, 85, 104, '牛江镇'),
(44, 07, 85, 105, '君堂镇'),
(44, 07, 85, 106, '大田镇'),
(44, 07, 85, 107, '那吉镇'),
(44, 07, 85, 108, '大槐镇'),
(44, 07, 85, 109, '东成镇');
/* 广东省 湛江市 赤坎区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 02, 001, '中华街道'),
(44, 08, 02, 002, '寸金街道'),
(44, 08, 02, 003, '民主街道'),
(44, 08, 02, 004, '中山街道'),
(44, 08, 02, 005, '沙湾街道'),
(44, 08, 02, 006, '调顺街道'),
(44, 08, 02, 007, '南桥街道'),
(44, 08, 02, 008, '北桥街道');
/* 广东省 湛江市 霞山区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 03, 001, '解放街道办事处'),
(44, 08, 03, 002, '爱国街道办事处'),
(44, 08, 03, 003, '工农街道办事处'),
(44, 08, 03, 004, '友谊街道办事处'),
(44, 08, 03, 005, '新兴街道办事处'),
(44, 08, 03, 006, '海滨街道办事处'),
(44, 08, 03, 009, '建设街道办事处'),
(44, 08, 03, 010, '东新街道办事处'),
(44, 08, 03, 011, '新园街道办事处'),
(44, 08, 03, 012, '海头街道办事处'),
(44, 08, 03, 070, '泉庄街道办事处'),
(44, 08, 03, 071, '乐华街道办事处');
/* 广东省 湛江市 坡头区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 04, 001, '南调街道办事处'),
(44, 08, 04, 002, '麻斜街道办事处'),
(44, 08, 04, 100, '南三镇'),
(44, 08, 04, 101, '坡头镇'),
(44, 08, 04, 102, '乾塘镇'),
(44, 08, 04, 103, '龙头镇'),
(44, 08, 04, 104, '官渡镇');
/* 广东省 湛江市 麻章区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 11, 100, '麻章镇'),
(44, 08, 11, 101, '太平镇'),
(44, 08, 11, 102, '湖光镇'),
(44, 08, 11, 170, '东山镇'),
(44, 08, 11, 171, '东简镇'),
(44, 08, 11, 172, '民安镇'),
(44, 08, 11, 173, '硇洲镇');
/* 广东省 湛江市 遂溪县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 23, 100, '遂城镇'),
(44, 08, 23, 101, '黄略镇'),
(44, 08, 23, 102, '洋青镇'),
(44, 08, 23, 103, '界炮镇'),
(44, 08, 23, 104, '乐民镇'),
(44, 08, 23, 105, '江洪镇'),
(44, 08, 23, 106, '杨柑镇'),
(44, 08, 23, 107, '城月镇'),
(44, 08, 23, 108, '乌塘镇'),
(44, 08, 23, 109, '建新镇'),
(44, 08, 23, 110, '岭北镇'),
(44, 08, 23, 111, '北坡镇'),
(44, 08, 23, 112, '港门镇'),
(44, 08, 23, 113, '草潭镇'),
(44, 08, 23, 114, '河头镇');
/* 广东省 湛江市 徐闻县 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 25, 001, '徐城街道办'),
(44, 08, 25, 102, '迈陈镇'),
(44, 08, 25, 103, '海安镇'),
(44, 08, 25, 104, '曲界镇'),
(44, 08, 25, 105, '前山镇'),
(44, 08, 25, 106, '西连镇'),
(44, 08, 25, 107, '下桥镇'),
(44, 08, 25, 108, '龙塘镇'),
(44, 08, 25, 109, '下洋镇'),
(44, 08, 25, 110, '锦和镇'),
(44, 08, 25, 111, '和安镇'),
(44, 08, 25, 112, '新寮镇'),
(44, 08, 25, 113, '南山镇'),
(44, 08, 25, 201, '城北乡'),
(44, 08, 25, 204, '角尾乡');
/* 广东省 湛江市 廉江市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 81, 001, '罗州街道办'),
(44, 08, 81, 002, '城南街道办'),
(44, 08, 81, 003, '城北街道办'),
(44, 08, 81, 101, '石城镇'),
(44, 08, 81, 102, '新民镇'),
(44, 08, 81, 103, '吉水镇'),
(44, 08, 81, 104, '河唇镇'),
(44, 08, 81, 105, '石角镇'),
(44, 08, 81, 106, '良垌镇'),
(44, 08, 81, 107, '横山镇'),
(44, 08, 81, 108, '安铺镇'),
(44, 08, 81, 109, '营仔镇'),
(44, 08, 81, 110, '青平镇'),
(44, 08, 81, 111, '车板镇'),
(44, 08, 81, 112, '高桥镇'),
(44, 08, 81, 113, '石岭镇'),
(44, 08, 81, 114, '雅塘镇'),
(44, 08, 81, 115, '石颈镇'),
(44, 08, 81, 116, '长山镇'),
(44, 08, 81, 117, '塘蓬镇'),
(44, 08, 81, 118, '和寮镇');
/* 广东省 湛江市 雷州市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 82, 001, '雷城街道办'),
(44, 08, 82, 002, '西湖街道办'),
(44, 08, 82, 003, '新城街道办'),
(44, 08, 82, 100, '白沙镇'),
(44, 08, 82, 101, '沈塘镇'),
(44, 08, 82, 102, '客路镇'),
(44, 08, 82, 103, '杨家镇'),
(44, 08, 82, 104, '唐家镇'),
(44, 08, 82, 105, '企水镇'),
(44, 08, 82, 106, '纪家镇'),
(44, 08, 82, 107, '松竹镇'),
(44, 08, 82, 108, '南兴镇'),
(44, 08, 82, 109, '雷高镇'),
(44, 08, 82, 110, '东里镇'),
(44, 08, 82, 111, '调风镇'),
(44, 08, 82, 112, '龙门镇'),
(44, 08, 82, 113, '英利镇'),
(44, 08, 82, 114, '北和镇'),
(44, 08, 82, 115, '乌石镇'),
(44, 08, 82, 116, '覃斗镇'),
(44, 08, 82, 117, '附城镇');
/* 广东省 湛江市 吴川市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 08, 83, 001, '梅录街道'),
(44, 08, 83, 002, '塘尾街道'),
(44, 08, 83, 003, '大山江街道'),
(44, 08, 83, 004, '博铺街道'),
(44, 08, 83, 005, '海滨街道'),
(44, 08, 83, 100, '浅水镇'),
(44, 08, 83, 101, '长岐镇'),
(44, 08, 83, 102, '覃巴镇'),
(44, 08, 83, 103, '王村港镇'),
(44, 08, 83, 104, '振文镇'),
(44, 08, 83, 105, '樟铺镇'),
(44, 08, 83, 106, '吴阳镇'),
(44, 08, 83, 107, '塘缀镇'),
(44, 08, 83, 109, '黄坡镇'),
(44, 08, 83, 111, '兰石镇');
/* 广东省 茂名市 茂南区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 09, 02, 001, '红旗街道办'),
(44, 09, 02, 002, '河西街道办'),
(44, 09, 02, 003, '河东街道办'),
(44, 09, 02, 004, '露天矿街道办'),
(44, 09, 02, 005, '新华街道办'),
(44, 09, 02, 006, '官渡街道办'),
(44, 09, 02, 007, '站前街道办'),
(44, 09, 02, 100, '金塘镇'),
(44, 09, 02, 101, '公馆镇'),
(44, 09, 02, 102, '新坡镇'),
(44, 09, 02, 103, '镇盛镇'),
(44, 09, 02, 104, '鳌头镇'),
(44, 09, 02, 105, '袂花镇'),
(44, 09, 02, 106, '高山镇'),
(44, 09, 02, 107, '山阁镇');
/* 广东省 茂名市 电白区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 09, 04, 001, '南海街道'),
(44, 09, 04, 002, '高地街道'),
(44, 09, 04, 100, '马踏镇'),
(44, 09, 04, 101, '岭门镇'),
(44, 09, 04, 102, '坡心镇'),
(44, 09, 04, 103, '七迳镇'),
(44, 09, 04, 104, '树仔镇'),
(44, 09, 04, 105, '沙院镇'),
(44, 09, 04, 106, '麻岗镇'),
(44, 09, 04, 107, '旦场镇'),
(44, 09, 04, 108, '羊角镇'),
(44, 09, 04, 109, '小良镇'),
(44, 09, 04, 115, '霞洞镇'),
(44, 09, 04, 116, '观珠镇'),
(44, 09, 04, 117, '沙琅镇'),
(44, 09, 04, 118, '黄岭镇'),
(44, 09, 04, 119, '望夫镇'),
(44, 09, 04, 120, '罗坑镇'),
(44, 09, 04, 121, '那霍镇'),
(44, 09, 04, 123, '水东镇'),
(44, 09, 04, 125, '博贺镇'),
(44, 09, 04, 126, '林头镇'),
(44, 09, 04, 127, '电城镇'),
(44, 09, 04, 128, '陈村镇');
/* 广东省 茂名市 高州市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 09, 81, 002, '石仔岭街道'),
(44, 09, 81, 003, '山美街道'),
(44, 09, 81, 006, '金山街道'),
(44, 09, 81, 007, '潘州街道'),
(44, 09, 81, 008, '宝光街道'),
(44, 09, 81, 100, '谢鸡镇'),
(44, 09, 81, 101, '新垌镇'),
(44, 09, 81, 102, '云潭镇'),
(44, 09, 81, 103, '分界镇'),
(44, 09, 81, 104, '根子镇'),
(44, 09, 81, 105, '泗水镇'),
(44, 09, 81, 107, '镇江镇'),
(44, 09, 81, 109, '沙田镇'),
(44, 09, 81, 110, '南塘镇'),
(44, 09, 81, 111, '荷花镇'),
(44, 09, 81, 112, '石板镇'),
(44, 09, 81, 115, '大井镇'),
(44, 09, 81, 116, '潭头镇'),
(44, 09, 81, 119, '大坡镇'),
(44, 09, 81, 120, '平山镇'),
(44, 09, 81, 121, '深镇镇'),
(44, 09, 81, 122, '马贵镇'),
(44, 09, 81, 123, '古丁镇'),
(44, 09, 81, 124, '曹江镇'),
(44, 09, 81, 126, '荷塘镇'),
(44, 09, 81, 127, '石鼓镇'),
(44, 09, 81, 128, '东岸镇'),
(44, 09, 81, 129, '长坡镇');
/* 广东省 茂名市 化州市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 09, 82, 001, '河西街道'),
(44, 09, 82, 002, '东山街道'),
(44, 09, 82, 003, '下郭街道'),
(44, 09, 82, 004, '南盛街道'),
(44, 09, 82, 005, '石湾街道'),
(44, 09, 82, 100, '长岐镇'),
(44, 09, 82, 101, '同庆镇'),
(44, 09, 82, 102, '杨梅镇'),
(44, 09, 82, 103, '良光镇'),
(44, 09, 82, 104, '笪桥镇'),
(44, 09, 82, 106, '丽岗镇'),
(44, 09, 82, 107, '新安镇'),
(44, 09, 82, 108, '官桥镇'),
(44, 09, 82, 110, '林尘镇'),
(44, 09, 82, 112, '合江镇'),
(44, 09, 82, 113, '那务镇'),
(44, 09, 82, 114, '播扬镇'),
(44, 09, 82, 115, '宝圩镇'),
(44, 09, 82, 116, '平定镇'),
(44, 09, 82, 117, '文楼镇'),
(44, 09, 82, 118, '江湖镇'),
(44, 09, 82, 120, '中垌镇');
/* 广东省 茂名市 信宜市 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 09, 83, 001, '东镇街道办'),
(44, 09, 83, 101, '镇隆镇'),
(44, 09, 83, 102, '水口镇'),
(44, 09, 83, 105, '丁堡镇'),
(44, 09, 83, 106, '池洞镇'),
(44, 09, 83, 112, '贵子镇'),
(44, 09, 83, 113, '怀乡镇'),
(44, 09, 83, 114, '茶山镇'),
(44, 09, 83, 115, '洪冠镇'),
(44, 09, 83, 116, '白石镇'),
(44, 09, 83, 117, '大成镇'),
(44, 09, 83, 118, '钱排镇'),
(44, 09, 83, 119, '合水镇'),
(44, 09, 83, 120, '新宝镇'),
(44, 09, 83, 121, '平塘镇'),
(44, 09, 83, 122, '思贺镇'),
(44, 09, 83, 123, '金垌镇'),
(44, 09, 83, 124, '朱砂镇'),
(44, 09, 83, 125, '北界镇');
/* 广东省 肇庆市 端州区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 12, 02, 001, '端州区城东街道'),
(44, 12, 02, 003, '端州区城西街道'),
(44, 12, 02, 005, '端州区黄岗街道'),
(44, 12, 02, 006, '端州区睦岗街道');
/* 广东省 肇庆市 鼎湖区 */
INSERT INTO `Street` (ProvinceId, CityId, DistrictId, StreetId, Name) VALUES
(44, 12, 03, 001, '坑口街道办事处'),
(44, 12, 03, 002, '桂城街道办事处'),