-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsql_db_dummy.sql
More file actions
4360 lines (4336 loc) · 160 KB
/
sql_db_dummy.sql
File metadata and controls
4360 lines (4336 loc) · 160 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
-- --------------------------------------------------------
-- 호스트: 127.0.0.1
-- 서버 버전: 10.5.4-MariaDB-1:10.5.4+maria~focal - mariadb.org binary distribution
-- 서버 OS: debian-linux-gnu
-- HeidiSQL 버전: 11.0.0.5919
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- spots 데이터베이스 구조 내보내기
DROP DATABASE IF EXISTS `spots`;
CREATE DATABASE IF NOT EXISTS `spots` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `spots`;
-- 테이블 spots.apply_team 구조 내보내기
DROP TABLE IF EXISTS `apply_team`;
CREATE TABLE IF NOT EXISTS `apply_team` (
`team_uid` int(11) DEFAULT NULL,
`user_uid` int(11) DEFAULT NULL,
`comment` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='팀 신청';
-- 테이블 데이터 spots.apply_team:~2 rows (대략적) 내보내기
DELETE FROM `apply_team`;
/*!40000 ALTER TABLE `apply_team` DISABLE KEYS */;
INSERT INTO `apply_team` (`team_uid`, `user_uid`, `comment`) VALUES
(61, 1, '가입신청'),
(53, 102, 'asdasd');
/*!40000 ALTER TABLE `apply_team` ENABLE KEYS */;
-- 테이블 spots.city_code 구조 내보내기
DROP TABLE IF EXISTS `city_code`;
CREATE TABLE IF NOT EXISTS `city_code` (
`city_code` varchar(50) NOT NULL,
`city_name` varchar(50) NOT NULL,
PRIMARY KEY (`city_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='도코드';
-- 테이블 데이터 spots.city_code:~218 rows (대략적) 내보내기
DELETE FROM `city_code`;
/*!40000 ALTER TABLE `city_code` DISABLE KEYS */;
INSERT INTO `city_code` (`city_code`, `city_name`) VALUES
('1111000000', '종로구'),
('1114000000', '중구'),
('1117000000', '용산구'),
('1120000000', '성동구'),
('1123000000', '동대문구'),
('1126000000', '중랑구'),
('1129000000', '성북구'),
('1132000000', '도봉구'),
('1135000000', '노원구'),
('1138000000', '은평구'),
('1141000000', '서대문구'),
('1144000000', '마포구'),
('1147000000', '양천구'),
('1150000000', '강서구'),
('1153000000', '구로구'),
('1156000000', '영등포구'),
('1159000000', '동작구'),
('1162000000', '관악구'),
('1165000000', '서초구'),
('1168000000', '강남구'),
('1171000000', '송파구'),
('1174000000', '강동구'),
('2611000000', '중구'),
('2614000000', '서구'),
('2617000000', '동구'),
('2620000000', '영도구'),
('2623000000', '부산진구'),
('2626000000', '동래구'),
('2629000000', '남구'),
('2632000000', '북구'),
('2635000000', '해운대구'),
('2638000000', '사하구'),
('2641000000', '금정구'),
('2644000000', '강서구'),
('2647000000', '연제구'),
('2650000000', '수영구'),
('2653000000', '사상구'),
('2671000000', '기장군'),
('2711000000', '중구'),
('2714000000', '동구'),
('2717000000', '서구'),
('2720000000', '남구'),
('2723000000', '북구'),
('2726000000', '수성구'),
('2729000000', '달서구'),
('2771000000', '달성군'),
('2811000000', '중구'),
('2814000000', '동구'),
('2820000000', '남동구'),
('2826000000', '서구'),
('2871000000', '강화군'),
('2872000000', '옹진군'),
('2911000000', '동구'),
('2914000000', '서구'),
('2917000000', '북구'),
('2920000000', '광산구'),
('3011000000', '동구'),
('3014000000', '중구'),
('3017000000', '서구'),
('3020000000', '유성구'),
('3023000000', '대덕구'),
('3111000000', '중구'),
('3114000000', '남구'),
('3117000000', '동구'),
('3120000000', '북구'),
('3171000000', '울주군'),
('4111000000', '수원시'),
('4113000000', '성남시'),
('4115000000', '의정부시'),
('4117000000', '안양시'),
('4119000000', '부천시'),
('4121000000', '광명시'),
('4122000000', '평택시'),
('4125000000', '동두천시'),
('4127000000', '안산시'),
('4128000000', '고양시'),
('4129000000', '과천시'),
('4131000000', '구리시'),
('4136000000', '남양주시'),
('4137000000', '오산시'),
('4139000000', '시흥시'),
('4141000000', '군포시'),
('4143000000', '의왕시'),
('4145000000', '하남시'),
('4146000000', '용인시'),
('4148000000', '파주시'),
('4150000000', '이천시'),
('4155000000', '안성시'),
('4157000000', '김포시'),
('4159000000', '화성시'),
('4161000000', '광주시'),
('4163000000', '양주시'),
('4165000000', '포천시'),
('4167000000', '여주시'),
('4180000000', '연천군'),
('4182000000', '가평군'),
('4183000000', '양평군'),
('4211000000', '춘천시'),
('4213000000', '원주시'),
('4215000000', '강릉시'),
('4217000000', '동해시'),
('4219000000', '태백시'),
('4221000000', '속초시'),
('4223000000', '삼척시'),
('4272000000', '홍천군'),
('4273000000', '횡성군'),
('4275000000', '영월군'),
('4276000000', '평창군'),
('4277000000', '정선군'),
('4278000000', '철원군'),
('4279000000', '화천군'),
('4280000000', '양구군'),
('4281000000', '인제군'),
('4282000000', '고성군'),
('4283000000', '양양군'),
('4311000000', '청주시'),
('4313000000', '충주시'),
('4315000000', '제천시'),
('4372000000', '보은군'),
('4373000000', '옥천군'),
('4374000000', '영동군'),
('4375000000', '진천군'),
('4376000000', '괴산군'),
('4377000000', '음성군'),
('4380000000', '단양군'),
('4413000000', '천안시'),
('4415000000', '공주시'),
('4418000000', '보령시'),
('4420000000', '아산시'),
('4421000000', '서산시'),
('4423000000', '논산시'),
('4425000000', '계룡시'),
('4427000000', '당진시'),
('4471000000', '금산군'),
('4476000000', '부여군'),
('4477000000', '서천군'),
('4479000000', '청양군'),
('4480000000', '홍성군'),
('4481000000', '예산군'),
('4511000000', '전주시'),
('4513000000', '군산시'),
('4514000000', '익산시'),
('4518000000', '정읍시'),
('4519000000', '남원시'),
('4521000000', '김제시'),
('4571000000', '완주군'),
('4572000000', '진안군'),
('4573000000', '무주군'),
('4574000000', '장수군'),
('4575000000', '임실군'),
('4577000000', '순창군'),
('4579000000', '고창군'),
('4580000000', '부안군'),
('4611000000', '목포시'),
('4613000000', '여수시'),
('4615000000', '순천시'),
('4617000000', '나주시'),
('4623000000', '광양시'),
('4671000000', '담양군'),
('4672000000', '곡성군'),
('4673000000', '구례군'),
('4677000000', '고흥군'),
('4678000000', '보성군'),
('4679000000', '화순군'),
('4680000000', '장흥군'),
('4681000000', '강진군'),
('4682000000', '해남군'),
('4683000000', '영암군'),
('4684000000', '무안군'),
('4686000000', '함평군'),
('4687000000', '영광군'),
('4688000000', '장성군'),
('4689000000', '완도군'),
('4690000000', '진도군'),
('4691000000', '신안군'),
('4711000000', '포항시'),
('4713000000', '경주시'),
('4715000000', '김천시'),
('4717000000', '안동시'),
('4719000000', '구미시'),
('4721000000', '영주시'),
('4723000000', '영천시'),
('4725000000', '상주시'),
('4728000000', '문경시'),
('4729000000', '경산시'),
('4772000000', '군위군'),
('4773000000', '의성군'),
('4775000000', '청송군'),
('4776000000', '영양군'),
('4777000000', '영덕군'),
('4782000000', '청도군'),
('4783000000', '고령군'),
('4784000000', '성주군'),
('4785000000', '칠곡군'),
('4790000000', '예천군'),
('4792000000', '봉화군'),
('4793000000', '울진군'),
('4794000000', '울릉군'),
('4812000000', '창원시'),
('4817000000', '진주시'),
('4822000000', '통영시'),
('4824000000', '사천시'),
('4825000000', '김해시'),
('4827000000', '밀양시'),
('4831000000', '거제시'),
('4833000000', '양산시'),
('4872000000', '의령군'),
('4873000000', '함안군'),
('4874000000', '창녕군'),
('4882000000', '고성군'),
('4884000000', '남해군'),
('4885000000', '하동군'),
('4886000000', '산청군'),
('4887000000', '함양군'),
('4888000000', '거창군'),
('4889000000', '합천군'),
('5011000000', '제주시'),
('5013000000', '서귀포시');
/*!40000 ALTER TABLE `city_code` ENABLE KEYS */;
-- 테이블 spots.dong_code 구조 내보내기
DROP TABLE IF EXISTS `dong_code`;
CREATE TABLE IF NOT EXISTS `dong_code` (
`dong_code` varchar(50) NOT NULL,
`dong_name` varchar(50) NOT NULL,
PRIMARY KEY (`dong_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='동코드';
-- 테이블 데이터 spots.dong_code:~3,547 rows (대략적) 내보내기
DELETE FROM `dong_code`;
/*!40000 ALTER TABLE `dong_code` DISABLE KEYS */;
INSERT INTO `dong_code` (`dong_code`, `dong_name`) VALUES
('1111051500', '청운효자동'),
('1111053000', '사직동'),
('1111054000', '삼청동'),
('1111055000', '부암동'),
('1111056000', '평창동'),
('1111057000', '무악동'),
('1111058000', '교남동'),
('1111060000', '가회동'),
('1111061500', '종로1.2.3.4가동'),
('1111063000', '종로5.6가동'),
('1111064000', '이화동'),
('1111065000', '혜화동'),
('1111067000', '창신제1동'),
('1111068000', '창신제2동'),
('1111069000', '창신제3동'),
('1111070000', '숭인제1동'),
('1111071000', '숭인제2동'),
('1114052000', '소공동'),
('1114054000', '회현동'),
('1114055000', '명동'),
('1114057000', '필동'),
('1114058000', '장충동'),
('1114059000', '광희동'),
('1114060500', '을지로동'),
('1114061500', '신당동'),
('1114062500', '다산동'),
('1114063500', '약수동'),
('1114064500', '청구동'),
('1114065000', '신당제5동'),
('1114066500', '동화동'),
('1114067000', '황학동'),
('1114068000', '중림동'),
('1117051000', '후암동'),
('1117052000', '용산2가동'),
('1117053000', '남영동'),
('1117055500', '청파동'),
('1117056000', '원효로제1동'),
('1117057000', '원효로제2동'),
('1117058000', '효창동'),
('1117059000', '용문동'),
('1117062500', '한강로동'),
('1117063000', '이촌제1동'),
('1117064000', '이촌제2동'),
('1117065000', '이태원제1동'),
('1117066000', '이태원제2동'),
('1117068500', '한남동'),
('1117069000', '서빙고동'),
('1117070000', '보광동'),
('1120052000', '왕십리제2동'),
('1120053500', '왕십리도선동'),
('1120054000', '마장동'),
('1120055000', '사근동'),
('1120056000', '행당제1동'),
('1120057000', '행당제2동'),
('1120058000', '응봉동'),
('1120059000', '금호1가동'),
('1120061500', '금호2.3가동'),
('1120062000', '금호4가동'),
('1120064500', '옥수동'),
('1120065000', '성수1가제1동'),
('1120066000', '성수1가제2동'),
('1120067000', '성수2가제1동'),
('1120069000', '성수2가제3동'),
('1120072000', '송정동'),
('1120079000', '용답동'),
('1121571000', '화양동'),
('1121573000', '군자동'),
('1121574000', '중곡제1동'),
('1121575000', '중곡제2동'),
('1121576000', '중곡제3동'),
('1121577000', '중곡제4동'),
('1121578000', '능동'),
('1121581000', '광장동'),
('1121582000', '자양제1동'),
('1121583000', '자양제2동'),
('1121584000', '자양제3동'),
('1121584700', '자양제4동'),
('1121585000', '구의제1동'),
('1121586000', '구의제2동'),
('1121587000', '구의제3동'),
('1123053600', '용신동'),
('1123054500', '제기동'),
('1123056000', '전농제1동'),
('1123057000', '전농제2동'),
('1123060000', '답십리제1동'),
('1123061000', '답십리제2동'),
('1123065000', '장안제1동'),
('1123066000', '장안제2동'),
('1123070500', '청량리동'),
('1123071000', '회기동'),
('1123072000', '휘경제1동'),
('1123073000', '휘경제2동'),
('1123074000', '이문제1동'),
('1123075000', '이문제2동'),
('1126052000', '면목제2동'),
('1126054000', '면목제4동'),
('1126055000', '면목제5동'),
('1126056500', '면목본동'),
('1126057000', '면목제7동'),
('1126057500', '면목제3.8동'),
('1126058000', '상봉제1동'),
('1126059000', '상봉제2동'),
('1126060000', '중화제1동'),
('1126061000', '중화제2동'),
('1126062000', '묵제1동'),
('1126063000', '묵제2동'),
('1126065500', '망우본동'),
('1126066000', '망우제3동'),
('1126068000', '신내1동'),
('1126069000', '신내2동'),
('1129052500', '성북동'),
('1129055500', '삼선동'),
('1129057500', '동선동'),
('1129058000', '돈암제1동'),
('1129059000', '돈암제2동'),
('1129060000', '안암동'),
('1129061000', '보문동'),
('1129062000', '정릉제1동'),
('1129063000', '정릉제2동'),
('1129064000', '정릉제3동'),
('1129065000', '정릉제4동'),
('1129066000', '길음제1동'),
('1129068500', '길음제2동'),
('1129070500', '종암동'),
('1129071500', '월곡제1동'),
('1129072500', '월곡제2동'),
('1129076000', '장위제1동'),
('1129077000', '장위제2동'),
('1129078000', '장위제3동'),
('1129081000', '석관동'),
('1130553400', '삼양동'),
('1130553500', '미아동'),
('1130554500', '송중동'),
('1130555500', '송천동'),
('1130557500', '삼각산동'),
('1130559500', '번1동'),
('1130560300', '번2동'),
('1130560800', '번3동'),
('1130561500', '수유1동'),
('1130562500', '수유2동'),
('1130563500', '수유3동'),
('1130564500', '우이동'),
('1130566000', '인수동'),
('1132051100', '창제1동'),
('1132051200', '창제2동'),
('1132051300', '창제3동'),
('1132051400', '창제4동'),
('1132051500', '창제5동'),
('1132052100', '도봉제1동'),
('1132052200', '도봉제2동'),
('1132066000', '쌍문제1동'),
('1132067000', '쌍문제2동'),
('1132068000', '쌍문제3동'),
('1132068100', '쌍문제4동'),
('1132069000', '방학제1동'),
('1132070000', '방학제2동'),
('1132071000', '방학제3동'),
('1135056000', '월계1동'),
('1135057000', '월계2동'),
('1135058000', '월계3동'),
('1135059500', '공릉1동'),
('1135060000', '공릉2동'),
('1135061100', '하계1동'),
('1135061200', '하계2동'),
('1135061900', '중계본동'),
('1135062100', '중계1동'),
('1135062400', '중계4동'),
('1135062500', '중계2.3동'),
('1135063000', '상계1동'),
('1135064000', '상계2동'),
('1135066500', '상계3.4동'),
('1135067000', '상계5동'),
('1135069500', '상계6.7동'),
('1135070000', '상계8동'),
('1135071000', '상계9동'),
('1135072000', '상계10동'),
('1138051000', '녹번동'),
('1138052000', '불광제1동'),
('1138053000', '불광제2동'),
('1138055100', '갈현제1동'),
('1138055200', '갈현제2동'),
('1138056000', '구산동'),
('1138057000', '대조동'),
('1138058000', '응암제1동'),
('1138059000', '응암제2동'),
('1138060000', '응암제3동'),
('1138062500', '역촌동'),
('1138063100', '신사제1동'),
('1138063200', '신사제2동'),
('1138064000', '증산동'),
('1138065000', '수색동'),
('1138069000', '진관동'),
('1141052000', '천연동'),
('1141055500', '북아현동'),
('1141056500', '충현동'),
('1141058500', '신촌동'),
('1141061500', '연희동'),
('1141062000', '홍제제1동'),
('1141064000', '홍제제3동'),
('1141065500', '홍제제2동'),
('1141066000', '홍은제1동'),
('1141068500', '홍은제2동'),
('1141069000', '남가좌제1동'),
('1141070000', '남가좌제2동'),
('1141071000', '북가좌제1동'),
('1141072000', '북가좌제2동'),
('1144055500', '아현동'),
('1144056500', '공덕동'),
('1144058500', '도화동'),
('1144059000', '용강동'),
('1144060000', '대흥동'),
('1144061000', '염리동'),
('1144063000', '신수동'),
('1144065500', '서강동'),
('1144066000', '서교동'),
('1144068000', '합정동'),
('1144069000', '망원제1동'),
('1144070000', '망원제2동'),
('1144071000', '연남동'),
('1144072000', '성산제1동'),
('1144073000', '성산제2동'),
('1144074000', '상암동'),
('1147051000', '목1동'),
('1147052000', '목2동'),
('1147053000', '목3동'),
('1147054000', '목4동'),
('1147055000', '목5동'),
('1147056000', '신월1동'),
('1147057000', '신월2동'),
('1147058000', '신월3동'),
('1147059000', '신월4동'),
('1147060000', '신월5동'),
('1147061000', '신월6동'),
('1147061100', '신월7동'),
('1147062000', '신정1동'),
('1147063000', '신정2동'),
('1147064000', '신정3동'),
('1147065000', '신정4동'),
('1147067000', '신정6동'),
('1147068000', '신정7동'),
('1150051000', '염창동'),
('1150052000', '등촌제1동'),
('1150053000', '등촌제2동'),
('1150053500', '등촌제3동'),
('1150054000', '화곡제1동'),
('1150055000', '화곡제2동'),
('1150056000', '화곡제3동'),
('1150057000', '화곡제4동'),
('1150059000', '화곡본동'),
('1150059100', '화곡제6동'),
('1150059300', '화곡제8동'),
('1150060300', '가양제1동'),
('1150060400', '가양제2동'),
('1150060500', '가양제3동'),
('1150061100', '발산제1동'),
('1150061500', '우장산동'),
('1150062000', '공항동'),
('1150063000', '방화제1동'),
('1150064000', '방화제2동'),
('1150064100', '방화제3동'),
('1153051000', '신도림동'),
('1153052000', '구로제1동'),
('1153053000', '구로제2동'),
('1153054000', '구로제3동'),
('1153055000', '구로제4동'),
('1153056000', '구로제5동'),
('1153059500', '가리봉동'),
('1153072000', '고척제1동'),
('1153073000', '고척제2동'),
('1153074000', '개봉제1동'),
('1153075000', '개봉제2동'),
('1153076000', '개봉제3동'),
('1153077000', '오류제1동'),
('1153078000', '오류제2동'),
('1153079000', '수궁동'),
('1154551000', '가산동'),
('1154561000', '독산제1동'),
('1154562000', '독산제2동'),
('1154563000', '독산제3동'),
('1154564000', '독산제4동'),
('1154567000', '시흥제1동'),
('1154568000', '시흥제2동'),
('1154569000', '시흥제3동'),
('1154570000', '시흥제4동'),
('1154571000', '시흥제5동'),
('1156051500', '영등포본동'),
('1156053500', '영등포동'),
('1156054000', '여의동'),
('1156055000', '당산제1동'),
('1156056000', '당산제2동'),
('1156058500', '도림동'),
('1156060500', '문래동'),
('1156061000', '양평제1동'),
('1156062000', '양평제2동'),
('1156063000', '신길제1동'),
('1156065000', '신길제3동'),
('1156066000', '신길제4동'),
('1156067000', '신길제5동'),
('1156068000', '신길제6동'),
('1156069000', '신길제7동'),
('1156070000', '대림제1동'),
('1156071000', '대림제2동'),
('1156072000', '대림제3동'),
('1159051000', '노량진제1동'),
('1159052000', '노량진제2동'),
('1159053000', '상도제1동'),
('1159054000', '상도제2동'),
('1159055000', '상도제3동'),
('1159056000', '상도제4동'),
('1159060500', '흑석동'),
('1159062000', '사당제1동'),
('1159063000', '사당제2동'),
('1159064000', '사당제3동'),
('1159065000', '사당제4동'),
('1159065100', '사당제5동'),
('1159066000', '대방동'),
('1159067000', '신대방제1동'),
('1159068000', '신대방제2동'),
('1162052500', '보라매동'),
('1162054500', '청림동'),
('1162056500', '성현동'),
('1162057500', '행운동'),
('1162058500', '낙성대동'),
('1162059500', '청룡동'),
('1162060500', '은천동'),
('1162061500', '중앙동'),
('1162062500', '인헌동'),
('1162063000', '남현동'),
('1162064500', '서원동'),
('1162065500', '신원동'),
('1162066500', '서림동'),
('1162068500', '신사동'),
('1162069500', '신림동'),
('1162071500', '난향동'),
('1162072500', '조원동'),
('1162073500', '대학동'),
('1162074500', '삼성동'),
('1162076500', '미성동'),
('1162077500', '난곡동'),
('1165051000', '서초1동'),
('1165052000', '서초2동'),
('1165053000', '서초3동'),
('1165053100', '서초4동'),
('1165054000', '잠원동'),
('1165055000', '반포본동'),
('1165056000', '반포1동'),
('1165057000', '반포2동'),
('1165058000', '반포3동'),
('1165058100', '반포4동'),
('1165059000', '방배본동'),
('1165060000', '방배1동'),
('1165061000', '방배2동'),
('1165062000', '방배3동'),
('1165062100', '방배4동'),
('1165065100', '양재1동'),
('1165065200', '양재2동'),
('1165066000', '내곡동'),
('1168051000', '신사동'),
('1168052100', '논현1동'),
('1168053100', '논현2동'),
('1168054500', '압구정동'),
('1168056500', '청담동'),
('1168058000', '삼성1동'),
('1168059000', '삼성2동'),
('1168060000', '대치1동'),
('1168061000', '대치2동'),
('1168063000', '대치4동'),
('1168064000', '역삼1동'),
('1168065000', '역삼2동'),
('1168065500', '도곡1동'),
('1168065600', '도곡2동'),
('1168066000', '개포1동'),
('1168067000', '개포2동'),
('1168069000', '개포4동'),
('1168070000', '세곡동'),
('1168072000', '일원본동'),
('1168073000', '일원1동'),
('1168074000', '일원2동'),
('1168075000', '수서동'),
('1171051000', '풍납1동'),
('1171052000', '풍납2동'),
('1171053100', '거여1동'),
('1171053200', '거여2동'),
('1171054000', '마천1동'),
('1171055000', '마천2동'),
('1171056100', '방이1동'),
('1171056200', '방이2동'),
('1171056600', '오륜동'),
('1171057000', '오금동'),
('1171058000', '송파1동'),
('1171059000', '송파2동'),
('1171060000', '석촌동'),
('1171061000', '삼전동'),
('1171062000', '가락본동'),
('1171063100', '가락1동'),
('1171063200', '가락2동'),
('1171064100', '문정1동'),
('1171064200', '문정2동'),
('1171064600', '장지동'),
('1171064700', '위례동'),
('1171065000', '잠실본동'),
('1171067000', '잠실2동'),
('1171068000', '잠실3동'),
('1171069000', '잠실4동'),
('1171071000', '잠실6동'),
('1171072000', '잠실7동'),
('1174051500', '강일동'),
('1174052000', '상일동'),
('1174053000', '명일제1동'),
('1174054000', '명일제2동'),
('1174055000', '고덕제1동'),
('1174056000', '고덕제2동'),
('1174057000', '암사제1동'),
('1174058000', '암사제2동'),
('1174059000', '암사제3동'),
('1174060000', '천호제1동'),
('1174061000', '천호제2동'),
('1174062000', '천호제3동'),
('1174064000', '성내제1동'),
('1174065000', '성내제2동'),
('1174066000', '성내제3동'),
('1174068500', '길동'),
('1174069000', '둔촌제1동'),
('1174070000', '둔촌제2동'),
('2611051000', '중앙동'),
('2611052000', '동광동'),
('2611053000', '대청동'),
('2611054500', '보수동'),
('2611056000', '부평동'),
('2611057000', '광복동'),
('2611058000', '남포동'),
('2611059000', '영주제1동'),
('2611060000', '영주제2동'),
('2614051000', '동대신제1동'),
('2614052000', '동대신제2동'),
('2614053000', '동대신제3동'),
('2614054000', '서대신제1동'),
('2614056000', '서대신제3동'),
('2614057000', '서대신제4동'),
('2614059000', '부민동'),
('2614061500', '아미동'),
('2614063000', '초장동'),
('2614064000', '충무동'),
('2614065000', '남부민제1동'),
('2614066000', '남부민제2동'),
('2614068000', '암남동'),
('2617051000', '초량제1동'),
('2617052000', '초량제2동'),
('2617053000', '초량제3동'),
('2617055000', '초량제6동'),
('2617056000', '수정제1동'),
('2617057000', '수정제2동'),
('2617059000', '수정제4동'),
('2617060000', '수정제5동'),
('2617064500', '좌천동'),
('2617065000', '범일제1동'),
('2617066000', '범일제2동'),
('2617068000', '범일제5동'),
('2620053000', '남항동'),
('2620054000', '영선제1동'),
('2620055000', '영선제2동'),
('2620058500', '신선동'),
('2620059000', '봉래제1동'),
('2620060500', '봉래제2동'),
('2620063000', '청학제1동'),
('2620064000', '청학제2동'),
('2620065000', '동삼제1동'),
('2620066000', '동삼제2동'),
('2620067000', '동삼제3동'),
('2623051000', '부전제1동'),
('2623052000', '부전제2동'),
('2623054000', '연지동'),
('2623055000', '초읍동'),
('2623056000', '양정제1동'),
('2623057000', '양정제2동'),
('2623060000', '전포제1동'),
('2623061000', '전포제2동'),
('2623064000', '부암제1동'),
('2623066000', '부암제3동'),
('2623067000', '당감제1동'),
('2623068000', '당감제2동'),
('2623070000', '당감제4동'),
('2623071000', '가야제1동'),
('2623072000', '가야제2동'),
('2623074000', '개금제1동'),
('2623075000', '개금제2동'),
('2623076000', '개금제3동'),
('2623077000', '범천제1동'),
('2623078000', '범천제2동'),
('2626051000', '수민동'),
('2626052000', '복산동'),
('2626054500', '명륜동'),
('2626055000', '온천제1동'),
('2626056000', '온천제2동'),
('2626057000', '온천제3동'),
('2626058000', '사직제1동'),
('2626059000', '사직제2동'),
('2626060000', '사직제3동'),
('2626074000', '안락제1동'),
('2626075000', '안락제2동'),
('2626076100', '명장제1동'),
('2626076200', '명장제2동'),
('2629051000', '대연제1동'),
('2629053000', '대연제3동'),
('2629054000', '대연제4동'),
('2629055000', '대연제5동'),
('2629056000', '대연제6동'),
('2629057000', '용호제1동'),
('2629058000', '용호제2동'),
('2629059000', '용호제3동'),
('2629060000', '용호제4동'),
('2629061000', '용당동'),
('2629062000', '감만제1동'),
('2629063000', '감만제2동'),
('2629064500', '우암동'),
('2629068000', '문현제1동'),
('2629069000', '문현제2동'),
('2629070000', '문현제3동'),
('2629071000', '문현제4동'),
('2632051000', '구포제1동'),
('2632052000', '구포제2동'),
('2632052100', '구포제3동'),
('2632053000', '금곡동'),
('2632054100', '화명제1동'),
('2632054200', '화명제2동'),
('2632054300', '화명제3동'),
('2632055000', '덕천제1동'),
('2632056000', '덕천제2동'),
('2632056100', '덕천제3동'),
('2632057100', '만덕제1동'),
('2632057200', '만덕제2동'),
('2632057300', '만덕제3동'),
('2635051000', '우제1동'),
('2635052000', '우제2동'),
('2635052500', '우제3동'),
('2635053000', '중제1동'),
('2635054000', '중제2동'),
('2635055100', '좌제1동'),
('2635055200', '좌제2동'),
('2635055300', '좌제3동'),
('2635055400', '좌제4동'),
('2635056000', '송정동'),
('2635057000', '반여제1동'),
('2635058000', '반여제2동'),
('2635059000', '반여제3동'),
('2635059500', '반여제4동'),
('2635061000', '반송제1동'),
('2635062000', '반송제2동'),
('2635065000', '재송제1동'),
('2635066000', '재송제2동'),
('2638051000', '괴정제1동'),
('2638052000', '괴정제2동'),
('2638053000', '괴정제3동'),
('2638054000', '괴정제4동'),
('2638055000', '당리동'),
('2638056100', '하단제1동'),
('2638056200', '하단제2동'),
('2638057100', '신평제1동'),
('2638057200', '신평제2동'),
('2638058000', '장림제1동'),
('2638059000', '장림제2동'),
('2638060100', '다대제1동'),
('2638060200', '다대제2동'),
('2638061000', '구평동'),
('2638062000', '감천제1동'),
('2638063000', '감천제2동'),
('2641051000', '서제1동'),
('2641052000', '서제2동'),
('2641053000', '서제3동'),
('2641055500', '금사회동동'),
('2641057000', '부곡제1동'),
('2641058000', '부곡제2동'),
('2641059000', '부곡제3동'),
('2641059100', '부곡제4동'),
('2641060000', '장전제1동'),
('2641061000', '장전제2동'),
('2641062000', '장전제3동'),
('2641063500', '선두구동'),
('2641066500', '청룡노포동'),
('2641067000', '남산동'),
('2641068000', '구서제1동'),
('2641069000', '구서제2동'),
('2641070000', '금성동'),
('2644051000', '대저1동'),
('2644052000', '대저2동'),
('2644053000', '강동동'),
('2644053500', '명지1동'),
('2644054500', '명지2동'),
('2644055000', '가락동'),
('2644056000', '녹산동'),
('2644058000', '가덕도동'),
('2647061000', '거제제1동'),
('2647062000', '거제제2동'),
('2647063000', '거제제3동'),
('2647064000', '거제제4동'),
('2647065000', '연산제1동'),
('2647066000', '연산제2동'),
('2647067000', '연산제3동'),
('2647068000', '연산제4동'),
('2647069000', '연산제5동'),
('2647070000', '연산제6동'),
('2647072000', '연산제8동'),
('2647073000', '연산제9동'),
('2650066000', '남천제1동'),
('2650067000', '남천제2동'),
('2650073000', '수영동'),
('2650074000', '망미제1동'),
('2650075000', '망미제2동'),
('2650076000', '광안제1동'),
('2650077000', '광안제2동'),
('2650078000', '광안제3동'),
('2650079000', '광안제4동'),
('2650080000', '민락동'),
('2653058000', '삼락동'),
('2653059100', '모라제1동'),
('2653059300', '모라제3동'),
('2653060000', '덕포제1동'),
('2653061000', '덕포제2동'),
('2653062000', '괘법동'),
('2653064500', '감전동'),
('2653065000', '주례제1동'),
('2653066000', '주례제2동'),
('2653066100', '주례제3동'),
('2653067000', '학장동'),
('2653068000', '엄궁동'),
('2671025000', '기장읍'),
('2671025300', '장안읍'),
('2671025600', '정관읍'),
('2671031000', '일광면'),
('2671033000', '철마면'),
('2711051700', '동인동'),
('2711054500', '삼덕동'),
('2711056500', '성내1동'),
('2711057500', '성내2동'),
('2711058500', '성내3동'),
('2711059500', '대신동'),
('2711064000', '남산1동'),
('2711065000', '남산2동'),
('2711066000', '남산3동'),
('2711067000', '남산4동'),
('2711068000', '대봉1동'),
('2711069000', '대봉2동'),
('2714051000', '신암1동'),
('2714052000', '신암2동'),
('2714053000', '신암3동'),
('2714054000', '신암4동'),
('2714054100', '신암5동'),
('2714055500', '신천1.2동'),
('2714057000', '신천3동'),
('2714058000', '신천4동'),
('2714059000', '효목1동'),
('2714060000', '효목2동'),
('2714061500', '도평동'),
('2714062000', '불로.봉무동'),
('2714064000', '지저동'),
('2714065500', '동촌동'),
('2714067000', '방촌동'),
('2714068500', '해안동'),
('2714072000', '안심1동'),
('2714073000', '안심2동'),
('2714074500', '안심3.4동'),
('2714076000', '공산동'),
('2717051000', '내당1동'),
('2717052500', '내당2.3동'),
('2717054000', '내당4동'),
('2717055000', '비산1동'),
('2717056500', '비산2.3동'),
('2717058000', '비산4동'),
('2717059000', '비산5동'),
('2717060000', '비산6동'),
('2717061000', '비산7동'),
('2717062000', '평리1동'),
('2717063000', '평리2동'),
('2717064000', '평리3동'),
('2717065000', '평리4동'),
('2717066000', '평리5동'),
('2717066100', '평리6동'),
('2717067500', '상중이동'),
('2717069500', '원대동'),
('2720051500', '이천동'),
('2720053000', '봉덕1동'),
('2720054000', '봉덕2동'),
('2720055000', '봉덕3동'),
('2720056000', '대명1동'),
('2720057100', '대명2동'),
('2720058600', '대명3동'),
('2720059000', '대명4동'),
('2720060000', '대명5동'),
('2720061000', '대명6동'),
('2720064000', '대명9동'),
('2720065000', '대명10동'),
('2720066000', '대명11동'),
('2723051000', '고성동'),
('2723052600', '칠성동'),
('2723055000', '침산1동'),
('2723056000', '침산2동'),
('2723057000', '침산3동'),
('2723061000', '산격1동'),
('2723062000', '산격2동'),
('2723063000', '산격3동'),
('2723063100', '산격4동'),
('2723064500', '대현동'),
('2723067100', '복현1동'),
('2723067200', '복현2동'),
('2723068000', '검단동'),
('2723069500', '무태조야동'),
('2723071500', '관문동'),
('2723072500', '태전1동'),
('2723073500', '태전2동'),
('2723074500', '구암동'),
('2723075000', '관음동'),
('2723077000', '읍내동'),
('2723078000', '동천동'),
('2723079000', '노원동'),
('2723080000', '국우동'),
('2726051000', '범어1동'),
('2726052000', '범어2동'),
('2726053000', '범어3동'),
('2726054000', '범어4동'),
('2726055000', '만촌1동'),
('2726056000', '만촌2동'),