-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy paththoga_lk.sql
2957 lines (2772 loc) · 197 KB
/
thoga_lk.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
-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 30, 2021 at 05:31 AM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.2.26
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `thoga.lk`
--
-- --------------------------------------------------------
--
-- Table structure for table `address`
--
CREATE TABLE `address` (
`address_id` int(100) NOT NULL,
`user_id` int(10) NOT NULL,
`address_line1` varchar(100) NOT NULL,
`address_line2` varchar(100) NOT NULL,
`city` int(10) NOT NULL,
`district` int(10) NOT NULL,
`province` int(10) NOT NULL,
`zip_code` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `address`
--
INSERT INTO `address` (`address_id`, `user_id`, `address_line1`, `address_line2`, `city`, `district`, `province`, `zip_code`) VALUES
(2, 2, 'No ,1', 'Reid Avenue', 1841, 5, 1, 10000),
(4, 4, 'No.12', 'Parana Rd', 1841, 5, 1, 10000),
(7, 7, 'No 1/5', 'Gallella Road', 1841, 5, 1, 45010),
(8, 8, 'No 1/5', 'Gella Road', 1032, 11, 2, 45000);
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE `admin` (
`admin_id` int(11) NOT NULL,
`user_name` varchar(20) NOT NULL,
`password` varchar(80) NOT NULL,
`name` varchar(100) NOT NULL,
`tel_no` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`admin_id`, `user_name`, `password`, `name`, `tel_no`) VALUES
(1, 'ucsc', 'd32934b31349d77e70957e057b1bcd28', 'Dumidu', '0766358125'),
(3, 'dumidu', 'd32934b31349d77e70957e057b1bcd28', 'dumidu', '0766344989');
-- --------------------------------------------------------
--
-- Table structure for table `advertisement`
--
CREATE TABLE `advertisement` (
`ad_id` int(10) NOT NULL,
`ad_caption` varchar(100) NOT NULL,
`company` varchar(20) NOT NULL,
`position` varchar(50) NOT NULL,
`status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `advertisement`
--
INSERT INTO `advertisement` (`ad_id`, `ad_caption`, `company`, `position`, `status`) VALUES
(1, 'Insects Killer', 'Baurs LTD', 'Vertical', 0),
(2, 'Ad-Crofix', 'DAWN', 'Vertical', 1),
(3, 'Leasing Ad', 'CDB Leasing', 'Horizontal', 1);
-- --------------------------------------------------------
--
-- Table structure for table `buyer`
--
CREATE TABLE `buyer` (
`buyer_id` int(11) NOT NULL,
`user_id` int(10) NOT NULL,
`br_no` varchar(50) NOT NULL,
`b_name` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `buyer`
--
INSERT INTO `buyer` (`buyer_id`, `user_id`, `br_no`, `b_name`) VALUES
(2, 2, '17853642', 'ucsc');
-- --------------------------------------------------------
--
-- Table structure for table `cities`
--
CREATE TABLE `cities` (
`id` int(11) NOT NULL,
`district_id` int(11) NOT NULL,
`name_en` varchar(45) DEFAULT NULL,
`name_si` varchar(45) DEFAULT NULL,
`name_ta` varchar(45) DEFAULT NULL,
`sub_name_en` varchar(45) DEFAULT NULL,
`sub_name_si` varchar(45) DEFAULT NULL,
`sub_name_ta` varchar(45) DEFAULT NULL,
`postcode` varchar(15) DEFAULT NULL,
`latitude` double DEFAULT NULL,
`longitude` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `cities`
--
INSERT INTO `cities` (`id`, `district_id`, `name_en`, `name_si`, `name_ta`, `sub_name_en`, `sub_name_si`, `sub_name_ta`, `postcode`, `latitude`, `longitude`) VALUES
(1, 1, 'Akkaraipattu', 'අක්කරපත්තුව', NULL, NULL, NULL, NULL, '32400', 7.2167, 81.85),
(2, 1, 'Ambagahawatta', 'අඹගහවත්ත', NULL, NULL, NULL, NULL, '90326', 7.4, 81.3),
(3, 1, 'Ampara', 'අම්පාර', NULL, NULL, NULL, NULL, '32000', 7.2833, 81.6667),
(4, 1, 'Bakmitiyawa', 'බක්මිටියාව', NULL, NULL, NULL, NULL, '32024', 7.026268, 81.633832),
(5, 1, 'Deegawapiya', 'දීඝවාපිය', NULL, NULL, NULL, NULL, '32006', 7.2833, 81.6667),
(6, 1, 'Devalahinda', 'දෙවලහිඳ', NULL, NULL, NULL, NULL, '32038', 7.1889, 81.5778),
(7, 1, 'Digamadulla Weeragoda', 'දිගාමඩුල්ල වීරගොඩ', NULL, NULL, NULL, NULL, '32008', 7.2833, 81.6667),
(8, 1, 'Dorakumbura', 'දොරකුඹුර', NULL, NULL, NULL, NULL, '32104', 7.358849, 81.280133),
(9, 1, 'Gonagolla', 'ගොනගොල්ල', NULL, NULL, NULL, NULL, '32064', 7.449853, 81.618014),
(10, 1, 'Hulannuge', 'හුලංනුගේ', NULL, NULL, NULL, NULL, '32514', 7.4, 81.3),
(11, 1, 'Kalmunai', 'කල්මුණේ', NULL, NULL, NULL, NULL, '32300', 7.413897, 81.826718),
(12, 1, 'Kannakipuram', 'කන්නකිපුරම්', NULL, NULL, NULL, NULL, '32405', 7.2167, 81.85),
(13, 1, 'Karativu', 'කරතිව්', NULL, NULL, NULL, NULL, '32250', 7.3833, 81.8333),
(14, 1, 'Kekirihena', 'කැකිරිහේන', NULL, NULL, NULL, NULL, '32074', 7.490724, 81.310836),
(15, 1, 'Koknahara', 'කොක්නහර', NULL, NULL, NULL, NULL, '32035', 7.184832, 81.555806),
(16, 1, 'Kolamanthalawa', 'කෝලමන්තලාව', NULL, NULL, NULL, NULL, '32102', 7.351733, 81.249913),
(17, 1, 'Komari', 'කෝමාරි', NULL, NULL, NULL, NULL, '32418', 6.976958, 81.78883),
(18, 1, 'Lahugala', 'ලාහුගල', NULL, NULL, NULL, NULL, '32512', 7.415566, 81.33954),
(19, 1, 'lmkkamam', 'ල්ම්ක්කමම්', NULL, NULL, NULL, NULL, '32450', 7.1125, 81.8542),
(20, 1, 'Mahaoya', 'මහඔය', NULL, NULL, NULL, NULL, '32070', 7.535248, 81.351145),
(21, 1, 'Marathamune', 'මාරත්මුනේ', NULL, NULL, NULL, NULL, '32314', 7.45, 81.8167),
(22, 1, 'Namaloya', 'නාමල්ඔය', NULL, NULL, NULL, NULL, '32037', 7.1889, 81.5778),
(23, 1, 'Navithanveli', 'නාවිදන්වෙලි', NULL, NULL, NULL, NULL, '32308', 7.4333, 81.7833),
(24, 1, 'Nintavur', 'නින්දවූර්', NULL, NULL, NULL, NULL, '32340', 7.35, 81.85),
(25, 1, 'Oluvil', 'ඔළුවිල', NULL, NULL, NULL, NULL, '32360', 7.2833, 81.85),
(26, 1, 'Padiyatalawa', 'පදියතලාව', NULL, NULL, NULL, NULL, '32100', 7.4, 81.2333),
(27, 1, 'Pahalalanda', 'පහලලන්ද', NULL, NULL, NULL, NULL, '32034', 7.21752, 81.578714),
(28, 1, 'Panama', 'පානම', NULL, NULL, NULL, NULL, '32508', 6.812201, 81.712237),
(29, 1, 'Pannalagama', 'පන්නලගම', NULL, NULL, NULL, NULL, '32022', 7.0667, 81.6167),
(30, 1, 'Paragahakele', 'පරගහකැලේ', NULL, NULL, NULL, NULL, '32031', 7.25669, 81.609526),
(31, 1, 'Periyaneelavanai', 'පෙරියනීලවන්නි', NULL, NULL, NULL, NULL, '32316', 7.434002, 81.814169),
(32, 1, 'Polwaga Janapadaya', 'පොල්වග ජනපදය', NULL, NULL, NULL, NULL, '32032', 7.1889, 81.5778),
(33, 1, 'Pottuvil', 'පොතුවිල්', NULL, NULL, NULL, NULL, '32500', 6.8667, 81.8333),
(34, 1, 'Sainthamaruthu', 'සායින්දමරුදු', NULL, NULL, NULL, NULL, '32280', 7.3833, 81.8333),
(35, 1, 'Samanthurai', 'සමන්තුරේ', NULL, NULL, NULL, NULL, '32200', 7.3833, 81.8333),
(36, 1, 'Serankada', 'සේරන්කද', NULL, NULL, NULL, NULL, '32101', 7.464517, 81.263599),
(37, 1, 'Tempitiya', 'ටැම්පිටිය', NULL, NULL, NULL, NULL, '32072', 7.610374, 81.429907),
(38, 1, 'Thambiluvil', 'ල්තැඹිළුවි', NULL, NULL, NULL, NULL, '32415', 7.132227, 81.819074),
(39, 1, 'Tirukovil', 'තිරුකෝවිල', NULL, NULL, NULL, NULL, '32420', 7.1167, 81.85),
(40, 1, 'Uhana', 'උහන', NULL, NULL, NULL, NULL, '32060', 7.363281, 81.637746),
(41, 1, 'Wadinagala', 'වඩිනාගල', NULL, NULL, NULL, NULL, '32039', 7.127849, 81.56922),
(42, 1, 'Wanagamuwa', 'වනගමුව', NULL, NULL, NULL, NULL, '32454', 7.1125, 81.8542),
(43, 2, 'Angamuwa', 'අංගමුව', NULL, NULL, NULL, NULL, '50248', 8.177645, 80.205048),
(44, 2, 'Anuradhapura', 'අනුරාධපුරය', NULL, NULL, NULL, NULL, '50000', 8.35, 80.3833),
(45, 2, 'Awukana', 'අව්කන', NULL, NULL, NULL, NULL, '50169', 7.9753, 80.5266),
(46, 2, 'Bogahawewa', 'බෝගහවැව', NULL, NULL, NULL, NULL, '50566', 8.328993, 80.251702),
(47, 2, 'Dematawewa', 'දෙමටවැව', NULL, NULL, NULL, NULL, '50356', 8.357373, 80.870087),
(48, 2, 'Dimbulagala', 'දිඹුලාගල', NULL, NULL, NULL, NULL, '51031', 7.9167, 80.55),
(49, 2, 'Dutuwewa', 'දුටුවැව', NULL, NULL, NULL, NULL, '50393', 8.65, 80.5167),
(50, 2, 'Elayapattuwa', 'ඇලයාපත්තුව', NULL, NULL, NULL, NULL, '50014', 8.413522, 80.318148),
(51, 2, 'Ellewewa', 'ඇල්ලේවැව', NULL, NULL, NULL, NULL, '51034', 7.9167, 80.55),
(52, 2, 'Eppawala', 'එප්පාවල', NULL, NULL, NULL, NULL, '50260', 8.1167, 80.7333),
(53, 2, 'Etawatunuwewa', 'ඇතාවැටුනවැව', NULL, NULL, NULL, NULL, '50584', 8.5595, 80.5476),
(54, 2, 'Etaweeragollewa', 'ඇතාවීරගොලෑව', NULL, NULL, NULL, NULL, '50518', 8.613962, 80.539713),
(55, 2, 'Galapitagala', 'ගලපිටගල', NULL, NULL, NULL, NULL, '32066', 8.089843, 80.685528),
(56, 2, 'Galenbindunuwewa', 'ගලෙන්බිඳුනුවැව', NULL, NULL, NULL, NULL, '50390', 8.5833, 80.55),
(57, 2, 'Galkadawala', 'ගල්කඩවල', NULL, NULL, NULL, NULL, '50006', 8.412861, 80.378175),
(58, 2, 'Galkiriyagama', 'ගල්කිරියාගම', NULL, NULL, NULL, NULL, '50120', 7.9414, 80.565),
(59, 2, 'Galkulama', 'ගල්කුලම', NULL, NULL, NULL, NULL, '50064', 8.270414, 80.506526),
(60, 2, 'Galnewa', 'ගල්නෑව', NULL, NULL, NULL, NULL, '50170', 8.2, 80.3667),
(61, 2, 'Gambirigaswewa', 'ගම්බිරිගස්වැව', NULL, NULL, NULL, NULL, '50057', 8.4667, 80.3667),
(62, 2, 'Ganewalpola', 'ගනේවල්පොල', NULL, NULL, NULL, NULL, '50142', 8.090528, 80.628195),
(63, 2, 'Gemunupura', 'ගැමුණුපුර', NULL, NULL, NULL, NULL, '50224', 8.0667, 80.6833),
(64, 2, 'Getalawa', 'ගෙතලාව', NULL, NULL, NULL, NULL, '50392', 8.6167, 80.5333),
(65, 2, 'Gnanikulama', 'ඝාණිකුළම', NULL, NULL, NULL, NULL, '50036', 8.297336, 80.431753),
(66, 2, 'Gonahaddenawa', 'ගෝනහද්දෙනෑව', NULL, NULL, NULL, NULL, '50554', 8.5333, 80.5083),
(67, 2, 'Habarana', 'හබරන', NULL, NULL, NULL, NULL, '50150', 8.047531, 80.748664),
(68, 2, 'Halmillawa Dambulla', 'හල්මිලෑව දඹුල්ල', NULL, NULL, NULL, NULL, '50124', 7.9474, 80.594),
(69, 2, 'Halmillawetiya', 'හල්මිල්ලවැටිය', NULL, NULL, NULL, NULL, '50552', 8.35, 80.2667),
(70, 2, 'Hidogama', 'හිද්දෝගම', NULL, NULL, NULL, NULL, '50044', 8.250421, 80.418663),
(71, 2, 'Horawpatana', 'හොරොව්පතාන', NULL, NULL, NULL, NULL, '50350', 8.4333, 80.8667),
(72, 2, 'Horiwila', 'හොරිවිල', NULL, NULL, NULL, NULL, '50222', 8.0667, 80.6833),
(73, 2, 'Hurigaswewa', 'හුරිගස්වැව', NULL, NULL, NULL, NULL, '50176', 8.1333, 80.3667),
(74, 2, 'Hurulunikawewa', 'හුරුලුනිකවැව', NULL, NULL, NULL, NULL, '50394', 8.6167, 80.5333),
(75, 2, 'Ihala Puliyankulama', 'ඉහල පුලියන්කුලම', NULL, NULL, NULL, NULL, '61316', 8.153213, 80.559989),
(76, 2, 'Kagama', 'කගම', NULL, NULL, NULL, NULL, '50282', 8.061465, 80.478039),
(77, 2, 'Kahatagasdigiliya', 'කහටගස්දිගිලිය', NULL, NULL, NULL, NULL, '50320', 8.4167, 80.6833),
(78, 2, 'Kahatagollewa', 'කහටගොල්ලෑව', NULL, NULL, NULL, NULL, '50562', 8.45, 80.65),
(79, 2, 'Kalakarambewa', 'කලකරඹෑව', NULL, NULL, NULL, NULL, '50288', 8.0833, 80.4667),
(80, 2, 'Kalaoya', 'කලාඔය', NULL, NULL, NULL, NULL, '50226', 8.0667, 80.6833),
(81, 2, 'Kalawedi Ulpotha', 'කලාවැදි උල්පොත', NULL, NULL, NULL, NULL, '50556', 8.5333, 80.5083),
(82, 2, 'Kallanchiya', 'කලංචිය', NULL, NULL, NULL, NULL, '50454', 8.45, 80.55),
(83, 2, 'Kalpitiya', 'කල්පිටිය', NULL, NULL, NULL, NULL, '61360', 8.2333, 79.7667),
(84, 2, 'Kalukele Badanagala', 'කළුකැලේ බදනාගල', NULL, NULL, NULL, NULL, '51037', 7.9167, 80.55),
(85, 2, 'Kapugallawa', 'කපුගල්ලව', NULL, NULL, NULL, NULL, '50370', 8.4233, 80.6783),
(86, 2, 'Karagahawewa', 'කරගහවැව', NULL, NULL, NULL, NULL, '50232', 8.23416, 80.322772),
(87, 2, 'Kashyapapura', 'කාශ්යපපුර', NULL, NULL, NULL, NULL, '51032', 7.9167, 80.55),
(88, 2, 'Kebithigollewa', 'කැබිතිගොල්ලෑව', NULL, NULL, NULL, NULL, '50500', 8.5333, 80.4833),
(89, 2, 'Kekirawa', 'කැකිරාව', NULL, NULL, NULL, NULL, '50100', 8.037462, 80.59801),
(90, 2, 'Kendewa', 'කේන්දෑව', NULL, NULL, NULL, NULL, '50452', 8.4833, 80.6),
(91, 2, 'Kiralogama', 'කිරළෝගම', NULL, NULL, NULL, NULL, '50259', 8.19407, 80.37012),
(92, 2, 'Kirigalwewa', 'කිරිගල්වැව', NULL, NULL, NULL, NULL, '50511', 8.537767, 80.556651),
(93, 2, 'Kirimundalama', 'කිරිමුන්ඩලම', NULL, NULL, NULL, NULL, '61362', 8.2333, 79.7667),
(94, 2, 'Kitulhitiyawa', 'කිතුල්හිටියාව', NULL, NULL, NULL, NULL, '50132', 7.916592, 80.63811),
(95, 2, 'Kurundankulama', 'කුරුන්දන්කුලම', NULL, NULL, NULL, NULL, '50062', 8.2, 80.45),
(96, 2, 'Labunoruwa', 'ලබුනෝරුව', NULL, NULL, NULL, NULL, '50088', 8.168026, 80.617001),
(97, 2, 'Ihalagama', 'ඉහලගම', NULL, NULL, NULL, NULL, '50304', 8.35, 80.5),
(98, 2, 'Ipologama', 'ඉපොලොගම', NULL, NULL, NULL, NULL, '50280', 8.0833, 80.4667),
(99, 2, 'Madatugama', 'මාදතුගම', NULL, NULL, NULL, NULL, '50130', 7.940041, 80.638217),
(100, 2, 'Maha Elagamuwa', 'මහ ඇලගමුව', NULL, NULL, NULL, NULL, '50126', 7.991935, 80.61824),
(101, 2, 'Mahabulankulama', 'මහබුලංකුලම', NULL, NULL, NULL, NULL, '50196', 7.9753, 80.5266),
(102, 2, 'Mahailluppallama', 'මහඉලුප්පල්ලම', NULL, NULL, NULL, NULL, '50270', 8.106, 80.3619),
(103, 2, 'Mahakanadarawa', 'මහකනදරාව', NULL, NULL, NULL, NULL, '50306', 8.35, 80.5),
(104, 2, 'Mahapothana', 'මහපොතාන', NULL, NULL, NULL, NULL, '50327', 8.4167, 80.6833),
(105, 2, 'Mahasenpura', 'මහසෙන්පුර', NULL, NULL, NULL, NULL, '50574', 8.5595, 80.5476),
(106, 2, 'Mahawilachchiya', 'මහවිලච්චිය', NULL, NULL, NULL, NULL, '50022', 8.2814, 80.4588),
(107, 2, 'Mailagaswewa', 'මයිලගස්වැව', NULL, NULL, NULL, NULL, '50384', 8.4, 80.6333),
(108, 2, 'Malwanagama', 'මල්වනගම', NULL, NULL, NULL, NULL, '50236', 8.225, 80.3333),
(109, 2, 'Maneruwa', 'මනේරුව', NULL, NULL, NULL, NULL, '50182', 7.895997, 80.475966),
(110, 2, 'Maradankadawala', 'මරදන්කඩවල', NULL, NULL, NULL, NULL, '50080', 8.1333, 80.4833),
(111, 2, 'Maradankalla', 'මරදන්කල්ල', NULL, NULL, NULL, NULL, '50308', 8.317498, 80.537899),
(112, 2, 'Medawachchiya', 'මැදවච්චිය', NULL, NULL, NULL, NULL, '50500', 8.540822, 80.495957),
(113, 2, 'Megodawewa', 'මීගොඩවැව', NULL, NULL, NULL, NULL, '50334', 8.2333, 80.7333),
(114, 2, 'Mihintale', 'මිහින්තලේ', NULL, NULL, NULL, NULL, '50300', 8.35, 80.5),
(115, 2, 'Morakewa', 'මොරකෑව', NULL, NULL, NULL, NULL, '50349', 8.513051, 80.778223),
(116, 2, 'Mulkiriyawa', 'මුල්කිරියාව', NULL, NULL, NULL, NULL, '50324', 8.4167, 80.6833),
(117, 2, 'Muriyakadawala', 'මුරියකඩවල', NULL, NULL, NULL, NULL, '50344', 8.236464, 80.654663),
(118, 5, 'Colombo 15', 'කොළඹ 15', 'கொழும்பு 15', 'Modara', 'මෝදර', 'முகத்துவாரம்', '01500', 6.959444, 79.875278),
(119, 2, 'Nachchaduwa', 'නච්චදූව', NULL, NULL, NULL, NULL, '50046', 8.2667, 80.4667),
(120, 2, 'Namalpura', 'නාමල්පුර', NULL, NULL, NULL, NULL, '50339', 8.2333, 80.7333),
(121, 2, 'Negampaha', 'නෑගම්පහ', NULL, NULL, NULL, NULL, '50180', 7.9872, 80.4597),
(122, 2, 'Nochchiyagama', 'නොච්චියාගම', NULL, NULL, NULL, NULL, '50200', 8.266802, 80.20823),
(123, 2, 'Nuwaragala', 'නුවරගල', NULL, NULL, NULL, NULL, '51039', 7.9167, 80.55),
(124, 2, 'Padavi Maithripura', 'පදවි මෛත්රීපුර', NULL, NULL, NULL, NULL, '50572', 8.5595, 80.5476),
(125, 2, 'Padavi Parakramapura', 'පදවි පරාක්රමපුර', NULL, NULL, NULL, NULL, '50582', 8.5595, 80.5476),
(126, 2, 'Padavi Sripura', 'පදවි ශ්රීපුර', NULL, NULL, NULL, NULL, '50587', 8.5595, 80.5476),
(127, 2, 'Padavi Sritissapura', 'පදවි ශ්රීතිස්සපුර', NULL, NULL, NULL, NULL, '50588', 8.5595, 80.5476),
(128, 2, 'Padaviya', 'පදවිය', NULL, NULL, NULL, NULL, '50570', 8.5595, 80.5476),
(129, 2, 'Padikaramaduwa', 'පඩිකරමඩුව', NULL, NULL, NULL, NULL, '50338', 8.2333, 80.7333),
(130, 2, 'Pahala Halmillewa', 'පහල හල්මිල්ලෑව', NULL, NULL, NULL, NULL, '50206', 8.21672, 80.19116),
(131, 2, 'Pahala Maragahawe', 'පහල මරගහවෙ', NULL, NULL, NULL, NULL, '50220', 8.0667, 80.6833),
(132, 2, 'Pahalagama', 'පහලගම', NULL, NULL, NULL, NULL, '50244', 8.186896, 80.283767),
(133, 2, 'Palugaswewa', 'පලුගස්වැව', NULL, NULL, NULL, NULL, '50144', 8.053538, 80.71918),
(134, 2, 'Pandukabayapura', 'පන්ඩුකාබයපුර', NULL, NULL, NULL, NULL, '50448', 8.4467, 80.46731),
(135, 2, 'Pandulagama', 'පන්ඩුලගම', NULL, NULL, NULL, NULL, '50029', 8.2814, 80.4588),
(136, 2, 'Parakumpura', 'පරාක්රමපුර', NULL, NULL, NULL, NULL, '50326', 8.4167, 80.6833),
(137, 2, 'Parangiyawadiya', 'පරංගියාවාඩිය', NULL, NULL, NULL, NULL, '50354', 8.491831, 80.910014),
(138, 2, 'Parasangahawewa', 'පරසන්ගහවැව', NULL, NULL, NULL, NULL, '50055', 8.4333, 80.4333),
(139, 2, 'Pelatiyawa', 'පැලටියාව', NULL, NULL, NULL, NULL, '51033', 7.9167, 80.55),
(140, 2, 'Pemaduwa', 'පෙමදූව', NULL, NULL, NULL, NULL, '50020', 8.2814, 80.4588),
(141, 2, 'Perimiyankulama', 'පෙරිමියන්කුලම', NULL, NULL, NULL, NULL, '50004', 8.270584, 80.535827),
(142, 2, 'Pihimbiyagolewa', 'පිහිඹියගොල්ලෑව', NULL, NULL, NULL, NULL, '50512', 8.5595, 80.5476),
(143, 2, 'Pubbogama', 'පුබ්බෝගම', NULL, NULL, NULL, NULL, '50122', 7.9167, 80.6),
(144, 2, 'Punewa', 'පූනෑව', NULL, NULL, NULL, NULL, '50506', 8.6167, 80.4667),
(145, 2, 'Rajanganaya', 'රාජාංගනය', NULL, NULL, NULL, NULL, '50246', 8.1708, 80.2833),
(146, 2, 'Rambewa', 'රම්බෑව්', NULL, NULL, NULL, NULL, '50450', 8.4333, 80.5),
(147, 2, 'Rampathwila', 'රම්පත්විල', NULL, NULL, NULL, NULL, '50386', 8.4, 80.6333),
(148, 2, 'Rathmalgahawewa', 'රත්මල්ගහවැව', NULL, NULL, NULL, NULL, '50514', 8.5595, 80.5476),
(149, 2, 'Saliyapura', 'සාලියපුර', NULL, NULL, NULL, NULL, '50008', 8.3389, 80.4333),
(150, 2, 'Seeppukulama', 'සීප්පුකුලම', NULL, NULL, NULL, NULL, '50380', 8.4, 80.6333),
(151, 2, 'Senapura', 'සේනාපුර', NULL, NULL, NULL, NULL, '50284', 8.0833, 80.4667),
(152, 2, 'Sivalakulama', 'සිවලකුලම', NULL, NULL, NULL, NULL, '50068', 8.25237, 80.641743),
(153, 2, 'Siyambalewa', 'සියඹලෑව', NULL, NULL, NULL, NULL, '50184', 7.95, 80.5167),
(154, 2, 'Sravasthipura', 'ස්රාවස්තිපුර', NULL, NULL, NULL, NULL, '50042', 8.2667, 80.4333),
(155, 2, 'Talawa', 'තලාව', NULL, NULL, NULL, NULL, '50230', 8.2167, 80.35),
(156, 2, 'Tambuttegama', 'තඹුත්තේගම', NULL, NULL, NULL, NULL, '50240', 8.15, 80.3),
(157, 2, 'Tammennawa', 'තම්මැන්නාව', NULL, NULL, NULL, NULL, '50104', 8.0333, 80.6),
(158, 2, 'Tantirimale', 'තන්තිරිමලේ', NULL, NULL, NULL, NULL, '50016', 8.4, 80.3),
(159, 2, 'Telhiriyawa', 'තෙල්හිරියාව', NULL, NULL, NULL, NULL, '50242', 8.15, 80.3333),
(160, 2, 'Tirappane', 'තිරප්පනේ', NULL, NULL, NULL, NULL, '50072', 8.2167, 80.3833),
(161, 2, 'Tittagonewa', 'තිත්තගෝනෑව', NULL, NULL, NULL, NULL, '50558', 8.7167, 80.75),
(162, 2, 'Udunuwara Colony', 'උඩුනුවර කොළණිය', NULL, NULL, NULL, NULL, '50207', 8.2417, 80.1917),
(163, 2, 'Upuldeniya', 'උපුල්දෙනිය', NULL, NULL, NULL, NULL, '50382', 8.4, 80.6333),
(164, 2, 'Uttimaduwa', 'උට්ටිමඩුව', NULL, NULL, NULL, NULL, '50067', 8.254989, 80.55487),
(165, 2, 'Vellamanal', 'වෙල්ලමනල්', NULL, NULL, NULL, NULL, '31053', 8.5167, 81.1833),
(166, 2, 'Viharapalugama', 'විහාරපාළුගම', NULL, NULL, NULL, NULL, '50012', 8.4, 80.3),
(167, 2, 'Wahalkada', 'වාහල්කඩ', NULL, NULL, NULL, NULL, '50564', 8.5667, 80.6222),
(168, 2, 'Wahamalgollewa', 'වහමල්ගොල්ලෑව', NULL, NULL, NULL, NULL, '50492', 8.479838, 80.497451),
(169, 2, 'Walagambahuwa', 'වලගම්බාහුව', NULL, NULL, NULL, NULL, '50086', 8.153134, 80.499049),
(170, 2, 'Walahaviddawewa', 'වලහාවිද්දෑව', NULL, NULL, NULL, NULL, '50516', 8.5595, 80.5476),
(171, 2, 'Welimuwapotana', 'වැලිමුවපතාන', NULL, NULL, NULL, NULL, '50358', 8.4333, 80.8667),
(172, 2, 'Welioya Project', 'වැලිඔය ව්යාපෘතිය', NULL, NULL, NULL, NULL, '50586', 8.5595, 80.5476),
(173, 3, 'Akkarasiyaya', 'අක්කරසියය', NULL, NULL, NULL, NULL, '90166', 6.7792, 80.9208),
(174, 3, 'Aluketiyawa', 'අලුකෙටියාව', NULL, NULL, NULL, NULL, '90736', 7.317155, 81.127134),
(175, 3, 'Aluttaramma', 'අළුත්තරම', NULL, NULL, NULL, NULL, '90722', 7.2167, 81.0667),
(176, 3, 'Ambadandegama', 'අඹදන්ඩෙගම', NULL, NULL, NULL, NULL, '90108', 6.81591, 81.056492),
(177, 3, 'Ambagasdowa', 'අඹගස්දූව', NULL, NULL, NULL, NULL, '90300', 6.928519, 80.892126),
(178, 3, 'Arawa', 'අරාව', NULL, NULL, NULL, NULL, '90017', 7.162769, 81.07755),
(179, 3, 'Arawakumbura', 'අරාවකුඹුර', NULL, NULL, NULL, NULL, '90532', 7.084925, 81.198802),
(180, 3, 'Arawatta', 'අරාවත්ත', NULL, NULL, NULL, NULL, '90712', 7.328715, 81.036976),
(181, 3, 'Atakiriya', 'අටකිරියාව', NULL, NULL, NULL, NULL, '90542', 7.0667, 81.1056),
(182, 3, 'Badulla', 'බදුල්ල', NULL, NULL, NULL, NULL, '90000', 6.995365, 81.048438),
(183, 3, 'Baduluoya', 'බදුලුඔය', NULL, NULL, NULL, NULL, '90019', 7.151852, 81.023867),
(184, 3, 'Ballaketuwa', 'බල්ලකැටුව', NULL, NULL, NULL, NULL, '90092', 6.862905, 81.097249),
(185, 3, 'Bambarapana', 'බඹරපාන', NULL, NULL, NULL, NULL, '90322', 7.1167, 81.0375),
(186, 3, 'Bandarawela', 'බණ්ඩාරවෙල', NULL, NULL, NULL, NULL, '90100', 6.828867, 80.990898),
(187, 3, 'Beramada', 'බෙරමඩ', NULL, NULL, NULL, NULL, '90066', 7.055713, 80.987238),
(188, 3, 'Bibilegama', 'බිබිලේගම', NULL, NULL, NULL, NULL, '90502', 6.887473, 81.141268),
(189, 3, 'Boragas', 'බොරගස්', NULL, NULL, NULL, NULL, '90362', 6.901625, 80.840162),
(190, 3, 'Boralanda', 'බොරලන්ද', NULL, NULL, NULL, NULL, '90170', 6.828637, 80.881603),
(191, 3, 'Bowela', 'බෝවෙල', NULL, NULL, NULL, NULL, '90302', 6.95, 80.9333),
(192, 3, 'Central Camp', 'මධ්යම කඳවුර', NULL, NULL, NULL, NULL, '32050', 7.3589, 81.1759),
(193, 3, 'Damanewela', 'දමනෙවෙල', NULL, NULL, NULL, NULL, '32126', 7.2125, 81.0583),
(194, 3, 'Dambana', 'දඹාන', NULL, NULL, NULL, NULL, '90714', 7.3583, 81.1083),
(195, 3, 'Dehiattakandiya', 'දෙහිඅත්තකන්ඩිය', NULL, NULL, NULL, NULL, '32150', 7.2125, 81.0583),
(196, 3, 'Demodara', 'දෙමෝදර', NULL, NULL, NULL, NULL, '90080', 6.899055, 81.053273),
(197, 3, 'Diganatenna', 'දිගනතැන්න', NULL, NULL, NULL, NULL, '90132', 6.8667, 80.9667),
(198, 3, 'Dikkapitiya', 'දික්කපිටිය', NULL, NULL, NULL, NULL, '90214', 6.7381, 80.9669),
(199, 3, 'Dimbulana', 'දිඹුලාන', NULL, NULL, NULL, NULL, '90324', 7.006897, 80.948431),
(200, 3, 'Divulapelessa', 'දිවුලපැලැස්ස', NULL, NULL, NULL, NULL, '90726', 7.2167, 81.0667),
(201, 3, 'Diyatalawa', 'දියතලාව', NULL, NULL, NULL, NULL, '90150', 6.8, 80.9667),
(202, 3, 'Dulgolla', 'දුල්ගොල්ල', NULL, NULL, NULL, NULL, '90104', 6.819618, 81.012115),
(203, 3, 'Ekiriyankumbura', 'ඇකිරියන්කුඹුර', NULL, NULL, NULL, NULL, '91502', 7.269736, 81.226709),
(204, 3, 'Ella', 'ඇල්ල', NULL, NULL, NULL, NULL, '90090', 6.874485, 81.050937),
(205, 3, 'Ettampitiya', 'ඇට්ටම්පිටිය', NULL, NULL, NULL, NULL, '90140', 6.9342, 80.9853),
(206, 3, 'Galauda', 'ගලඋඩ', NULL, NULL, NULL, NULL, '90065', 7.037347, 80.981759),
(207, 3, 'Galporuyaya', 'ගල්පොරුයාය', NULL, NULL, NULL, NULL, '90752', 7.4, 81.05),
(208, 3, 'Gawarawela', 'ගවරවෙල', NULL, NULL, NULL, NULL, '90082', 6.897394, 81.069668),
(209, 3, 'Girandurukotte', 'ගිරාඳුරුකෝට්ටෙ', NULL, NULL, NULL, NULL, '90750', 7.4, 81.05),
(210, 3, 'Godunna', 'ගොඩුන්න', NULL, NULL, NULL, NULL, '90067', 7.071959, 80.975003),
(211, 3, 'Gurutalawa', 'ගුරුතලාව', NULL, NULL, NULL, NULL, '90208', 6.8431, 80.9228),
(212, 3, 'Haldummulla', 'හල්දුම්මුල්ල', NULL, NULL, NULL, NULL, '90180', 6.77061, 80.884385),
(213, 3, 'Hali Ela', 'හාලි ඇල', NULL, NULL, NULL, NULL, '90060', 6.95, 81.0333),
(214, 3, 'Hangunnawa', 'හඟුන්නෑව', NULL, NULL, NULL, NULL, '90224', 6.948019, 80.871427),
(215, 3, 'Haputale', 'හපුතලේ', NULL, NULL, NULL, NULL, '90160', 6.7667, 80.9667),
(216, 3, 'Hebarawa', 'හබරාව', NULL, NULL, NULL, NULL, '90724', 7.2167, 81.0667),
(217, 3, 'Heeloya', 'හීලොය', NULL, NULL, NULL, NULL, '90112', 6.8212, 80.9407),
(218, 3, 'Helahalpe', 'හෙලහල්පේ', NULL, NULL, NULL, NULL, '90122', 6.8212, 80.9407),
(219, 3, 'Helapupula', 'හෙලපුපුළ', NULL, NULL, NULL, NULL, '90094', 6.8556, 81.0722),
(220, 3, 'Hopton', 'හෝප්ටන්', NULL, NULL, NULL, NULL, '90524', 6.9594, 81.1552),
(221, 3, 'Idalgashinna', 'ඉදල්ගස්ඉන්න', NULL, NULL, NULL, NULL, '96167', 6.7833, 80.9),
(222, 3, 'Kahataruppa', 'කහටරුප්ප', NULL, NULL, NULL, NULL, '90052', 7.023705, 81.105188),
(223, 3, 'Kalugahakandura', 'කළුගහකණ්ඳුර', NULL, NULL, NULL, NULL, '90546', 7.123675, 81.094178),
(224, 3, 'Kalupahana', 'කළුපහණ', NULL, NULL, NULL, NULL, '90186', 6.770298, 80.854521),
(225, 3, 'Kebillawela', 'කොබිල්ලවෙල', NULL, NULL, NULL, NULL, '90102', 6.816937, 80.993072),
(226, 3, 'Kendagolla', 'කන්දෙගොල්ල', NULL, NULL, NULL, NULL, '90048', 6.990765, 81.110073),
(227, 3, 'Keselpotha', 'කෙසෙල්පොත', NULL, NULL, NULL, NULL, '90738', 7.32819, 81.083285),
(228, 3, 'Ketawatta', 'කේතවත්ත', NULL, NULL, NULL, NULL, '90016', 7.103503, 81.080813),
(229, 3, 'Kiriwanagama', 'කිරිවනගම', NULL, NULL, NULL, NULL, '90184', 6.971183, 80.91551),
(230, 3, 'Koslanda', 'කොස්ලන්ද', NULL, NULL, NULL, NULL, '90190', 6.759935, 81.027417),
(231, 3, 'Kuruwitenna', NULL, NULL, NULL, NULL, NULL, '90728', 7.2167, 81.0667),
(232, 3, 'Kuttiyagolla', NULL, NULL, NULL, NULL, NULL, '90046', 7.0167, 81.0833),
(233, 3, 'Landewela', NULL, NULL, NULL, NULL, NULL, '90068', 7.002113, 81.000496),
(234, 3, 'Liyangahawela', NULL, NULL, NULL, NULL, NULL, '90106', 6.817452, 81.032456),
(235, 3, 'Lunugala', NULL, NULL, NULL, NULL, NULL, '90530', 7.041299, 81.199335),
(236, 3, 'Lunuwatta', NULL, NULL, NULL, NULL, NULL, '90310', 6.953933, 80.917059),
(237, 3, 'Madulsima', NULL, NULL, NULL, NULL, NULL, '90535', 7.045064, 81.133375),
(238, 3, 'Mahiyanganaya', NULL, NULL, NULL, NULL, NULL, '90700', 7.2444, 81.1167),
(239, 3, 'Makulella', NULL, NULL, NULL, NULL, NULL, '90114', 6.8212, 80.9407),
(240, 3, 'Malgoda', NULL, NULL, NULL, NULL, NULL, '90754', 7.4, 81.05),
(241, 3, 'Mapakadawewa', NULL, NULL, NULL, NULL, NULL, '90730', 7.3, 81.1167),
(242, 3, 'Maspanna', NULL, NULL, NULL, NULL, NULL, '90328', 7.024427, 80.942159),
(243, 3, 'Maussagolla', NULL, NULL, NULL, NULL, NULL, '90582', 6.898433, 81.147817),
(244, 3, 'Mawanagama', NULL, NULL, NULL, NULL, NULL, '32158', 7.2125, 81.0583),
(245, 3, 'Medawela Udukinda', NULL, NULL, NULL, NULL, NULL, '90218', 6.846, 80.9279),
(246, 3, 'Meegahakiula', NULL, NULL, NULL, NULL, NULL, '90015', 7.0833, 80.9833),
(247, 3, 'Metigahatenna', NULL, NULL, NULL, NULL, NULL, '90540', 6.9667, 81.0833),
(248, 3, 'Mirahawatta', NULL, NULL, NULL, NULL, NULL, '90134', 6.8817, 80.9347),
(249, 3, 'Miriyabedda', NULL, NULL, NULL, NULL, NULL, '90504', 6.9167, 81.15),
(250, 3, 'Nawamedagama', NULL, NULL, NULL, NULL, NULL, '32120', 7.2125, 81.0583),
(251, 3, 'Nelumgama', NULL, NULL, NULL, NULL, NULL, '90042', 7, 81.0917),
(252, 3, 'Nikapotha', NULL, NULL, NULL, NULL, NULL, '90165', 6.740622, 80.97083),
(253, 3, 'Nugatalawa', NULL, NULL, NULL, NULL, NULL, '90216', 6.9, 80.8833),
(254, 3, 'Ohiya', NULL, NULL, NULL, NULL, NULL, '90168', 6.821352, 80.841789),
(255, 3, 'Pahalarathkinda', NULL, NULL, NULL, NULL, NULL, '90756', 7.4, 81.05),
(256, 3, 'Pallekiruwa', NULL, NULL, NULL, NULL, NULL, '90534', 7.007551, 81.227033),
(257, 3, 'Passara', NULL, NULL, NULL, NULL, NULL, '90500', 6.935017, 81.151166),
(258, 3, 'Pattiyagedara', NULL, NULL, NULL, NULL, NULL, '90138', 6.8742, 80.9507),
(259, 3, 'Pelagahatenna', NULL, NULL, NULL, NULL, NULL, '90522', 6.9594, 81.1552),
(260, 3, 'Perawella', NULL, NULL, NULL, NULL, NULL, '90222', 6.943148, 80.84264),
(261, 3, 'Pitamaruwa', NULL, NULL, NULL, NULL, NULL, '90544', 7.106546, 81.135882),
(262, 3, 'Pitapola', NULL, NULL, NULL, NULL, NULL, '90171', 6.803692, 80.884474),
(263, 3, 'Puhulpola', NULL, NULL, NULL, NULL, NULL, '90212', 6.907145, 80.931109),
(264, 3, 'Rajagalatenna', NULL, NULL, NULL, NULL, NULL, '32068', 7.5458, 81.125),
(265, 3, 'Ratkarawwa', NULL, NULL, NULL, NULL, NULL, '90164', 6.8, 80.9167),
(266, 3, 'Ridimaliyadda', NULL, NULL, NULL, NULL, NULL, '90704', 7.2333, 81.1),
(267, 3, 'Silmiyapura', NULL, NULL, NULL, NULL, NULL, '90364', 6.912388, 80.843988),
(268, 3, 'Sirimalgoda', NULL, NULL, NULL, NULL, NULL, '90044', 7.003857, 81.073671),
(269, 3, 'Siripura', NULL, NULL, NULL, NULL, NULL, '32155', 7.2125, 81.0583),
(270, 3, 'Sorabora Colony', NULL, NULL, NULL, NULL, NULL, '90718', 7.3583, 81.1083),
(271, 3, 'Soragune', NULL, NULL, NULL, NULL, NULL, '90183', 6.8333, 80.8778),
(272, 3, 'Soranatota', NULL, NULL, NULL, NULL, NULL, '90008', 7.0167, 81.05),
(273, 3, 'Taldena', NULL, NULL, NULL, NULL, NULL, '90014', 7.0833, 81.05),
(274, 3, 'Timbirigaspitiya', NULL, NULL, NULL, NULL, NULL, '90012', 7.0333, 81.05),
(275, 3, 'Uduhawara', NULL, NULL, NULL, NULL, NULL, '90226', 6.94706, 80.85877),
(276, 3, 'Uraniya', NULL, NULL, NULL, NULL, NULL, '90702', 7.237143, 81.102818),
(277, 3, 'Uva Karandagolla', NULL, NULL, NULL, NULL, NULL, '90091', 6.8333, 81.0667),
(278, 3, 'Uva Mawelagama', NULL, NULL, NULL, NULL, NULL, '90192', 6.7333, 81.0167),
(279, 3, 'Uva Tenna', NULL, NULL, NULL, NULL, NULL, '90188', 6.8333, 80.8778),
(280, 3, 'Uva Tissapura', NULL, NULL, NULL, NULL, NULL, '90734', 7.3, 81.1167),
(281, 3, 'Welimada', NULL, NULL, NULL, NULL, NULL, '90200', 6.906059, 80.913222),
(282, 3, 'Werunketagoda', NULL, NULL, NULL, NULL, NULL, '32062', 7.5458, 81.125),
(283, 3, 'Wewatta', NULL, NULL, NULL, NULL, NULL, '90716', 7.337729, 81.201255),
(284, 3, 'Wineethagama', NULL, NULL, NULL, NULL, NULL, '90034', 7.029, 80.937),
(285, 3, 'Yalagamuwa', NULL, NULL, NULL, NULL, NULL, '90329', 7.047834, 80.950541),
(286, 3, 'Yalwela', NULL, NULL, NULL, NULL, NULL, '90706', 7.2667, 81.15),
(287, 4, 'Addalaichenai', NULL, NULL, NULL, NULL, NULL, '32350', 7.4833, 81.75),
(288, 4, 'Ampilanthurai', 'අම්පිලන්තුරෙයි', NULL, NULL, NULL, NULL, '30162', 7.8597, 81.4411),
(289, 4, 'Araipattai', NULL, NULL, NULL, NULL, NULL, '30150', 7.667705, 81.725335),
(290, 4, 'Ayithiyamalai', NULL, NULL, NULL, NULL, NULL, '30362', 7.670934, 81.574798),
(291, 4, 'Bakiella', NULL, NULL, NULL, NULL, NULL, '30206', 7.5083, 81.7583),
(292, 4, 'Batticaloa', 'මඩකලපුව', NULL, NULL, NULL, NULL, '30000', 7.7167, 81.7),
(293, 4, 'Cheddipalayam', 'චෙඩ්ඩිපලයම්', NULL, NULL, NULL, NULL, '30194', 7.575161, 81.783189),
(294, 4, 'Chenkaladi', 'චෙන්කලඩි', NULL, NULL, NULL, NULL, '30350', 7.7833, 81.6),
(295, 4, 'Eravur', 'එරාවූර්', NULL, NULL, NULL, NULL, '30300', 7.768518, 81.619817),
(296, 4, 'Kaluwanchikudi', NULL, NULL, NULL, NULL, NULL, '30200', 7.5167, 81.7833),
(297, 4, 'Kaluwankemy', NULL, NULL, NULL, NULL, NULL, '30372', 7.8, 81.5667),
(298, 4, 'Kannankudah', NULL, NULL, NULL, NULL, NULL, '30016', 7.675505, 81.674125),
(299, 4, 'Karadiyanaru', NULL, NULL, NULL, NULL, NULL, '30354', 7.689478, 81.531117),
(300, 4, 'Kathiraveli', NULL, NULL, NULL, NULL, NULL, '30456', 8.243933, 81.360298),
(301, 4, 'Kattankudi', NULL, NULL, NULL, NULL, NULL, '30100', 7.675, 81.73),
(302, 4, 'Kiran', NULL, NULL, NULL, NULL, NULL, '30394', 7.866841, 81.529737),
(303, 4, 'Kirankulam', NULL, NULL, NULL, NULL, NULL, '30159', 7.615628, 81.764245),
(304, 4, 'Koddaikallar', NULL, NULL, NULL, NULL, NULL, '30249', 7.6389, 81.6639),
(305, 4, 'Kokkaddichcholai', NULL, NULL, NULL, NULL, NULL, '30160', 7.8597, 81.4411),
(306, 4, 'Kurukkalmadam', NULL, NULL, NULL, NULL, NULL, '30192', 7.594069, 81.77497),
(307, 4, 'Mandur', NULL, NULL, NULL, NULL, NULL, '30220', 7.482114, 81.762407),
(308, 4, 'Miravodai', NULL, NULL, NULL, NULL, NULL, '30426', 7.9, 81.5167),
(309, 4, 'Murakottanchanai', NULL, NULL, NULL, NULL, NULL, '30392', 7.8667, 81.5333),
(310, 4, 'Navagirinagar', NULL, NULL, NULL, NULL, NULL, '30238', 7.525, 81.725),
(311, 4, 'Navatkadu', NULL, NULL, NULL, NULL, NULL, '30018', 7.5833, 81.7167),
(312, 4, 'Oddamavadi', NULL, NULL, NULL, NULL, NULL, '30420', 7.9167, 81.5167),
(313, 4, 'Palamunai', NULL, NULL, NULL, NULL, NULL, '32354', 7.4833, 81.75),
(314, 4, 'Pankudavely', NULL, NULL, NULL, NULL, NULL, '30352', 7.75, 81.5667),
(315, 4, 'Periyaporativu', NULL, NULL, NULL, NULL, NULL, '30230', 7.536243, 81.764557),
(316, 4, 'Periyapullumalai', NULL, NULL, NULL, NULL, NULL, '30358', 7.561255, 81.47434),
(317, 4, 'Pillaiyaradi', NULL, NULL, NULL, NULL, NULL, '30022', 7.75, 81.6333),
(318, 4, 'Punanai', NULL, NULL, NULL, NULL, NULL, '30428', 7.9667, 81.3833),
(319, 4, 'Thannamunai', NULL, NULL, NULL, NULL, NULL, '30024', 7.76355, 81.645852),
(320, 4, 'Thettativu', NULL, NULL, NULL, NULL, NULL, '30196', 7.5833, 81.7833),
(321, 4, 'Thikkodai', NULL, NULL, NULL, NULL, NULL, '30236', 7.525269, 81.684177),
(322, 4, 'Thirupalugamam', NULL, NULL, NULL, NULL, NULL, '30234', 7.525, 81.725),
(323, 4, 'Unnichchai', NULL, NULL, NULL, NULL, NULL, '30364', 7.6167, 81.55),
(324, 4, 'Vakaneri', NULL, NULL, NULL, NULL, NULL, '30424', 7.9167, 81.4333),
(325, 4, 'Vakarai', NULL, NULL, NULL, NULL, NULL, '30450', 8.165968, 81.415623),
(326, 4, 'Valaichenai', NULL, NULL, NULL, NULL, NULL, '30400', 7.7, 81.6),
(327, 4, 'Vantharumoolai', NULL, NULL, NULL, NULL, NULL, '30376', 7.807445, 81.591476),
(328, 4, 'Vellavely', NULL, NULL, NULL, NULL, NULL, '30204', 7.5, 81.7333),
(329, 5, 'Akarawita', 'අකරවිට', NULL, NULL, NULL, NULL, '10732', 6.95, 80.1),
(330, 5, 'Ambalangoda', 'අම්බලන්ගොඩ', NULL, NULL, NULL, NULL, '80300', 6.77533, 79.96413),
(331, 5, 'Athurugiriya', 'අතුරුගිරිය', NULL, NULL, NULL, NULL, '10150', 6.873072, 79.997214),
(332, 5, 'Avissawella', 'අවිස්සාවේල්ල', NULL, NULL, NULL, NULL, '10700', 6.955003, 80.211692),
(333, 5, 'Batawala', 'බටවැල', NULL, NULL, NULL, NULL, '10513', 6.877924, 80.051592),
(334, 5, 'Battaramulla', 'බත්තරමුල්ල', NULL, NULL, NULL, NULL, '10120', 6.900299, 79.922136),
(335, 5, 'Biyagama', 'බියගම', NULL, NULL, NULL, NULL, '11650', 6.9408, 79.9889),
(336, 5, 'Bope', 'බෝපෙ', NULL, NULL, NULL, NULL, '10522', 6.8333, 80.1167),
(337, 5, 'Boralesgamuwa', 'බොරලැස්ගමුව', NULL, NULL, NULL, NULL, '10290', 6.8425, 79.9006),
(338, 5, 'Colombo 8', 'කොළඹ 8', 'கொழும்பு 8', 'Borella', 'බොරැල්ල', 'பொறளை', '00800', 6.914722, 79.877778),
(339, 5, 'Dedigamuwa', 'දැඩිගමුව', NULL, NULL, NULL, NULL, '10656', 6.9115, 80.0622),
(340, 5, 'Dehiwala', 'දෙහිවල', NULL, NULL, NULL, NULL, '10350', 6.856387, 79.865156),
(341, 5, 'Deltara', 'දෙල්තර', NULL, NULL, NULL, NULL, '10302', 6.7833, 79.9167),
(342, 5, 'Habarakada', 'හබරකඩ', NULL, NULL, NULL, NULL, '10204', 6.882518, 80.017704),
(343, 5, 'Hanwella', NULL, NULL, NULL, NULL, NULL, '10650', 6.905988, 80.083333),
(344, 5, 'Hiripitya', NULL, NULL, NULL, NULL, NULL, '10232', 6.85, 79.95),
(345, 5, 'Hokandara', NULL, NULL, NULL, NULL, NULL, '10118', 6.890237, 79.969894),
(346, 5, 'Homagama', NULL, NULL, NULL, NULL, NULL, '10200', 6.85685, 80.005384),
(347, 5, 'Horagala', NULL, NULL, NULL, NULL, NULL, '10502', 6.807635, 80.066995),
(348, 5, 'Kaduwela', NULL, NULL, NULL, NULL, NULL, '10640', 6.930497, 79.984817),
(349, 5, 'Kaluaggala', NULL, NULL, NULL, NULL, NULL, '11224', 6.9167, 80.1),
(350, 5, 'Kapugoda', NULL, NULL, NULL, NULL, NULL, '10662', 6.9486, 80.1),
(351, 5, 'Kehelwatta', NULL, NULL, NULL, NULL, NULL, '12550', 6.75, 79.9167),
(352, 5, 'Kiriwattuduwa', NULL, NULL, NULL, NULL, NULL, '10208', 6.804157, 80.009759),
(353, 5, 'Kolonnawa', NULL, NULL, NULL, NULL, NULL, '10600', 6.933035, 79.888095),
(354, 5, 'Kosgama', NULL, NULL, NULL, NULL, NULL, '10730', 6.9333, 80.1411),
(355, 5, 'Madapatha', NULL, NULL, NULL, NULL, NULL, '10306', 6.766824, 79.930103),
(356, 5, 'Maharagama', NULL, NULL, NULL, NULL, NULL, '10280', 6.843401, 79.932766),
(357, 5, 'Malabe', NULL, NULL, NULL, NULL, NULL, '10115', 6.901241, 79.958072),
(358, 5, 'Moratuwa', NULL, NULL, NULL, NULL, NULL, '10400', 6.7733, 79.8825),
(359, 5, 'Mount Lavinia', NULL, NULL, NULL, NULL, NULL, '10370', 6.838864, 79.863141),
(360, 5, 'Mullegama', NULL, NULL, NULL, NULL, NULL, '10202', 6.887403, 80.012959),
(361, 5, 'Napawela', NULL, NULL, NULL, NULL, NULL, '10704', 6.9531, 80.2183),
(362, 5, 'Nugegoda', NULL, NULL, NULL, NULL, NULL, '10250', 6.877563, 79.886231),
(363, 5, 'Padukka', NULL, NULL, NULL, NULL, NULL, '10500', 6.837834, 80.090301),
(364, 5, 'Pannipitiya', NULL, NULL, NULL, NULL, NULL, '10230', 6.843999, 79.944518),
(365, 5, 'Piliyandala', NULL, NULL, NULL, NULL, NULL, '10300', 6.7981, 79.9264),
(366, 5, 'Pitipana Homagama', NULL, NULL, NULL, NULL, NULL, '10206', 6.8477, 80.016),
(367, 5, 'Polgasowita', NULL, NULL, NULL, NULL, NULL, '10320', 6.7842, 79.9811),
(368, 5, 'Pugoda', NULL, NULL, NULL, NULL, NULL, '10660', 6.9703, 80.1222),
(369, 5, 'Ranala', NULL, NULL, NULL, NULL, NULL, '10654', 6.915253, 80.032962),
(370, 5, 'Siddamulla', NULL, NULL, NULL, NULL, NULL, '10304', 6.815785, 79.955978),
(371, 5, 'Siyambalagoda', NULL, NULL, NULL, NULL, NULL, '81462', 6.800041, 79.966845),
(372, 5, 'Sri Jayawardenepu', NULL, NULL, NULL, NULL, NULL, '10100', 6.8897, 79.9359),
(373, 5, 'Talawatugoda', NULL, NULL, NULL, NULL, NULL, '10116', 6.8692, 79.9411),
(374, 5, 'Tummodara', NULL, NULL, NULL, NULL, NULL, '10682', 6.9061, 80.1353),
(375, 5, 'Waga', NULL, NULL, NULL, NULL, NULL, '10680', 6.9061, 80.1353),
(376, 5, 'Colombo 6', 'කොළඹ 6', 'கொழும்பு 6', 'Wellawatta', 'වැල්ලවත්ත', 'வெள்ளவத்தை', '00600', 6.874657, 79.860483),
(377, 6, 'Agaliya', 'අගලිය', NULL, NULL, NULL, NULL, '80212', 6.1833, 80.2),
(378, 6, 'Ahangama', 'අහංගම', NULL, NULL, NULL, NULL, '80650', 5.970765, 80.370204),
(379, 6, 'Ahungalla', 'අහුන්ගල්ල', NULL, NULL, NULL, NULL, '80562', 6.315216, 80.03029),
(380, 6, 'Akmeemana', 'අක්මීමාන', NULL, NULL, NULL, NULL, '80090', 6.1845, 80.3032),
(381, 6, 'Alawatugoda', 'අලවතුගොඩ', NULL, NULL, NULL, NULL, '20140', 6.4167, 80),
(382, 6, 'Aluthwala', 'අළුත්වල', NULL, NULL, NULL, NULL, '80332', 6.180801, 80.136538),
(383, 6, 'Ampegama', 'අම්පෙගම', NULL, NULL, NULL, NULL, '80204', 6.193907, 80.14453),
(384, 6, 'Amugoda', 'අමුගොඩ', NULL, NULL, NULL, NULL, '80422', 6.314635, 80.22104),
(385, 6, 'Anangoda', 'අනන්ගොඩ', NULL, NULL, NULL, NULL, '80044', 6.0722, 80.2389),
(386, 6, 'Angulugaha', 'අඟුලුගහ', NULL, NULL, NULL, NULL, '80122', 6.036963, 80.322148),
(387, 6, 'Ankokkawala', 'අංකොක්කාවල', NULL, NULL, NULL, NULL, '80048', 6.05329, 80.274014),
(388, 6, 'Aselapura', 'ඇසලපුර', NULL, NULL, NULL, NULL, '51072', 6.3167, 80.0333),
(389, 6, 'Baddegama', 'බද්දේගම', NULL, NULL, NULL, NULL, '80200', 6.165975, 80.201841),
(390, 6, 'Balapitiya', 'බලපිටිය', NULL, NULL, NULL, NULL, '80550', 6.269254, 80.036054),
(391, 6, 'Banagala', 'බනගල', NULL, NULL, NULL, NULL, '80143', 6.2706, 80.42),
(392, 6, 'Batapola', 'බටපොල', NULL, NULL, NULL, NULL, '80320', 6.235697, 80.120034),
(393, 6, 'Bentota', 'බෙන්තොට', NULL, NULL, NULL, NULL, '80500', 6.4211, 79.9989),
(394, 6, 'Boossa', 'බූස්ස', NULL, NULL, NULL, NULL, '80270', 6.2233, 80.2),
(395, 6, 'Dellawa', 'දෙල්ලව', NULL, NULL, NULL, NULL, '81477', 6.335012, 80.452741),
(396, 6, 'Dikkumbura', 'දික්කුඹුර', NULL, NULL, NULL, NULL, '80654', 6.012945, 80.376153),
(397, 6, 'Dodanduwa', 'දොඩන්දූව', NULL, NULL, NULL, NULL, '80250', 6.0967, 80.1456),
(398, 6, 'Ella Tanabaddegama', 'ඇල්ල තනබද්දේගම', NULL, NULL, NULL, NULL, '80402', 6.2922, 80.1988),
(399, 6, 'Elpitiya', 'ඇල්පිටිය', NULL, NULL, NULL, NULL, '80400', 6.300214, 80.171923),
(400, 6, 'Galle', 'ගාල්ල', NULL, NULL, NULL, NULL, '80000', 6.0536, 80.2117),
(401, 6, 'Ginimellagaha', 'ගිනිමෙල්ලගහ', NULL, NULL, NULL, NULL, '80220', 6.2233, 80.2),
(402, 6, 'Gintota', 'ගින්තොට', NULL, NULL, NULL, NULL, '80280', 6.0564, 80.1839),
(403, 6, 'Godahena', 'ගොඩහේන', NULL, NULL, NULL, NULL, '80302', 6.2333, 80.0667),
(404, 6, 'Gonamulla Junction', 'ගෝනමුල්ල හංදිය', NULL, NULL, NULL, NULL, '80054', 6.0667, 80.3),
(405, 6, 'Gonapinuwala', 'ගොනාපිනූවල', NULL, NULL, NULL, NULL, '80230', 6.2233, 80.2),
(406, 6, 'Habaraduwa', 'හබරාදූව', NULL, NULL, NULL, NULL, '80630', 6.0043, 80.326),
(407, 6, 'Haburugala', 'හබුරුගල', NULL, NULL, NULL, NULL, '80506', 6.4052, 80.038306),
(408, 6, 'Hikkaduwa', NULL, NULL, NULL, NULL, NULL, '80240', 6.139535, 80.113201),
(409, 6, 'Hiniduma', NULL, NULL, NULL, NULL, NULL, '80080', 6.316028, 80.328888),
(410, 6, 'Hiyare', NULL, NULL, NULL, NULL, NULL, '80056', 6.079898, 80.317871),
(411, 6, 'Kahaduwa', NULL, NULL, NULL, NULL, NULL, '80460', 6.2244, 80.21),
(412, 6, 'Kahawa', NULL, NULL, NULL, NULL, NULL, '80312', 6.185429, 80.07601),
(413, 6, 'Karagoda', NULL, NULL, NULL, NULL, NULL, '80151', 6.084182, 80.395041),
(414, 6, 'Karandeniya', NULL, NULL, NULL, NULL, NULL, '80360', 6.260467, 80.072462),
(415, 6, 'Kosgoda', NULL, NULL, NULL, NULL, NULL, '80570', 6.332288, 80.028315),
(416, 6, 'Kottawagama', NULL, NULL, NULL, NULL, NULL, '80062', 6.1375, 80.3419),
(417, 6, 'Kottegoda', NULL, NULL, NULL, NULL, NULL, '81180', 6.1667, 80.1),
(418, 6, 'Kuleegoda', NULL, NULL, NULL, NULL, NULL, '80328', 6.2167, 80.1167),
(419, 6, 'Magedara', NULL, NULL, NULL, NULL, NULL, '80152', 6.108129, 80.393927),
(420, 6, 'Mahawela Sinhapura', NULL, NULL, NULL, NULL, NULL, '51076', 6.3167, 80.0333),
(421, 6, 'Mapalagama', NULL, NULL, NULL, NULL, NULL, '80112', 6.234713, 80.27784),
(422, 6, 'Mapalagama Central', NULL, NULL, NULL, NULL, NULL, '80116', 6.2167, 80.3),
(423, 6, 'Mattaka', NULL, NULL, NULL, NULL, NULL, '80424', 6.302366, 80.254218),
(424, 6, 'Meda-Keembiya', NULL, NULL, NULL, NULL, NULL, '80092', 6.1845, 80.3032),
(425, 6, 'Meetiyagoda', NULL, NULL, NULL, NULL, NULL, '80330', 6.189135, 80.093504),
(426, 6, 'Nagoda', NULL, NULL, NULL, NULL, NULL, '80110', 6.201296, 80.277829),
(427, 6, 'Nakiyadeniya', NULL, NULL, NULL, NULL, NULL, '80064', 6.143029, 80.338164),
(428, 6, 'Nawadagala', NULL, NULL, NULL, NULL, NULL, '80416', 6.304655, 80.134175),
(429, 6, 'Neluwa', NULL, NULL, NULL, NULL, NULL, '80082', 6.37393, 80.363267),
(430, 6, 'Nindana', NULL, NULL, NULL, NULL, NULL, '80318', 6.207731, 80.107663),
(431, 6, 'Pahala Millawa', NULL, NULL, NULL, NULL, NULL, '81472', 6.293995, 80.475431),
(432, 6, 'Panangala', NULL, NULL, NULL, NULL, NULL, '80075', 6.274182, 80.334525),
(433, 6, 'Pannimulla Panagoda', NULL, NULL, NULL, NULL, NULL, '80086', 6.36, 80.3653),
(434, 6, 'Parana ThanaYamgoda', NULL, NULL, NULL, NULL, NULL, '80114', 6.2167, 80.3),
(435, 6, 'Patana', NULL, NULL, NULL, NULL, NULL, '22012', 6.1333, 80.1167),
(436, 6, 'Pitigala', NULL, NULL, NULL, NULL, NULL, '80420', 6.348894, 80.217851),
(437, 6, 'Poddala', NULL, NULL, NULL, NULL, NULL, '80170', 6.1167, 80.2167),
(438, 6, 'Polgampola', NULL, NULL, NULL, NULL, NULL, '12136', 6.3244, 80.4383),
(439, 6, 'Porawagama', NULL, NULL, NULL, NULL, NULL, '80408', 6.279568, 80.231811),
(440, 6, 'Rantotuwila', NULL, NULL, NULL, NULL, NULL, '80354', 6.3833, 80.0833),
(441, 6, 'Talagampola', NULL, NULL, NULL, NULL, NULL, '80058', 6.0667, 80.3),
(442, 6, 'Talgaspe', NULL, NULL, NULL, NULL, NULL, '80406', 6.3, 80.2),
(443, 6, 'Talpe', NULL, NULL, NULL, NULL, NULL, '80615', 6.0061, 80.2961),
(444, 6, 'Tawalama', NULL, NULL, NULL, NULL, NULL, '80148', 6.3333, 80.3333),
(445, 6, 'Tiranagama', NULL, NULL, NULL, NULL, NULL, '80244', 6.1333, 80.1167),
(446, 6, 'Udalamatta', NULL, NULL, NULL, NULL, NULL, '80108', 6.18924, 80.306106),
(447, 6, 'Udugama', NULL, NULL, NULL, NULL, NULL, '80070', 6.188469, 80.338951),
(448, 6, 'Uluvitike', NULL, NULL, NULL, NULL, NULL, '80168', 6.3056, 80.309),
(449, 6, 'Unawatuna', NULL, NULL, NULL, NULL, NULL, '80600', 6.0169, 80.249901),
(450, 6, 'Unenwitiya', NULL, NULL, NULL, NULL, NULL, '80214', 6.2417, 80.225),
(451, 6, 'Uragaha', NULL, NULL, NULL, NULL, NULL, '80352', 6.35, 80.1167),
(452, 6, 'Uragasmanhandiya', NULL, NULL, NULL, NULL, NULL, '80350', 6.358461, 80.082277),
(453, 6, 'Wakwella', NULL, NULL, NULL, NULL, NULL, '80042', 6.1, 80.1833),
(454, 6, 'Walahanduwa', NULL, NULL, NULL, NULL, NULL, '80046', 6.05443, 80.251763),
(455, 6, 'Wanchawela', NULL, NULL, NULL, NULL, NULL, '80120', 6.0333, 80.3167),
(456, 6, 'Wanduramba', NULL, NULL, NULL, NULL, NULL, '80100', 6.136388, 80.252794),
(457, 6, 'Warukandeniya', NULL, NULL, NULL, NULL, NULL, '80084', 6.381574, 80.43131),
(458, 6, 'Watugedara', NULL, NULL, NULL, NULL, NULL, '80340', 6.25, 80.05),
(459, 6, 'Weihena', NULL, NULL, NULL, NULL, NULL, '80216', 6.310127, 80.23392),
(460, 6, 'Welikanda', NULL, NULL, NULL, NULL, NULL, '51070', 6.3167, 80.0333),
(461, 6, 'Wilanagama', NULL, NULL, NULL, NULL, NULL, '20142', 6.4167, 80),
(462, 6, 'Yakkalamulla', NULL, NULL, NULL, NULL, NULL, '80150', 6.109027, 80.349195),
(463, 6, 'Yatalamatta', NULL, NULL, NULL, NULL, NULL, '80107', 6.172247, 80.293052),
(464, 7, 'Akaragama', 'අකරගම', NULL, NULL, NULL, NULL, '11536', 7.262603, 79.958057),
(465, 7, 'Ambagaspitiya', 'අඹගස්පිටිය', NULL, NULL, NULL, NULL, '11052', 7.0833, 80.0667),
(466, 7, 'Ambepussa', 'අඹේපුස්ස', NULL, NULL, NULL, NULL, '11212', 7.25, 80.1667),
(467, 7, 'Andiambalama', 'ආඬිඅම්බලම', NULL, NULL, NULL, NULL, '11558', 7.188346, 79.902344),
(468, 7, 'Attanagalla', 'අත්තනගල්ල', NULL, NULL, NULL, NULL, '11120', 7.1119, 80.1328),
(469, 7, 'Badalgama', 'බඩල්ගම', NULL, NULL, NULL, NULL, '11538', 7.291218, 79.978003),
(470, 7, 'Banduragoda', 'බඳුරගොඩ', NULL, NULL, NULL, NULL, '11244', 7.2319, 80.0678),
(471, 7, 'Batuwatta', 'බටුවත්ත', NULL, NULL, NULL, NULL, '11011', 7.058399, 79.932048),
(472, 7, 'Bemmulla', 'බෙම්මුල්ල', NULL, NULL, NULL, NULL, '11040', 7.120933, 80.028191),
(473, 7, 'Biyagama IPZ', 'බියගම IPZ', NULL, NULL, NULL, NULL, '11672', 6.9492, 80.0153),
(474, 7, 'Bokalagama', 'බොකලගම', NULL, NULL, NULL, NULL, '11216', 7.2333, 80.15),
(475, 7, 'Bollete (WP)', 'බොල්ලතේ', NULL, NULL, NULL, NULL, '11024', 7.0667, 79.95),
(476, 7, 'Bopagama', 'බෝපගම', NULL, NULL, NULL, NULL, '11134', 7.079641, 80.15868),
(477, 7, 'Buthpitiya', 'බුත්පිටිය', NULL, NULL, NULL, NULL, '11720', 7.042846, 80.051854),
(478, 7, 'Dagonna', 'දාගොන්න', NULL, NULL, NULL, NULL, '11524', 7.221568, 79.927455),
(479, 7, 'Danowita', 'දංඕවිට', NULL, NULL, NULL, NULL, '11896', 7.2028, 80.1758),
(480, 7, 'Debahera', 'දෙබහැර', NULL, NULL, NULL, NULL, '11889', 7.1389, 80.0981),
(481, 7, 'Dekatana', 'දෙකටන', NULL, NULL, NULL, NULL, '11690', 6.968317, 80.035385),
(482, 7, 'Delgoda', 'දෙල්ගොඩ', NULL, NULL, NULL, NULL, '11700', 6.986583, 80.01576),
(483, 7, 'Delwagura', 'දෙල්වගුර', NULL, NULL, NULL, NULL, '11228', 7.265367, 80.003272),
(484, 7, 'Demalagama', 'දෙමළගම', NULL, NULL, NULL, NULL, '11692', 6.988934, 80.046886),
(485, 7, 'Demanhandiya', 'දෙමන්හන්දිය', NULL, NULL, NULL, NULL, '11270', 7.2333, 79.9),
(486, 7, 'Dewalapola', 'දේවාලපොල', NULL, NULL, NULL, NULL, '11102', 7.162553, 79.997446),
(487, 7, 'Divulapitiya', 'දිවුලපිටිය', NULL, NULL, NULL, NULL, '11250', 7.2167, 80.0156),
(488, 7, 'Divuldeniya', 'දිවුල්දෙණිය', NULL, NULL, NULL, NULL, '11208', 7.3, 80.1),
(489, 7, 'Dompe', 'දොම්පෙ', NULL, NULL, NULL, NULL, '11680', 6.949806, 80.055083),
(490, 7, 'Dunagaha', 'දුනගහ', NULL, NULL, NULL, NULL, '11264', 7.2342, 79.9756),
(491, 7, 'Ekala', 'ඒකල', NULL, NULL, NULL, NULL, '11380', 7.105558, 79.91532),
(492, 7, 'Ellakkala', 'ඇල්ලක්කල', NULL, NULL, NULL, NULL, '11116', 7.135968, 80.132524),
(493, 7, 'Essella', NULL, NULL, NULL, NULL, NULL, '11108', 7.178736, 80.021603),
(494, 7, 'Galedanda', 'ගලේදණ්ඩ', NULL, NULL, NULL, NULL, '90206', 6.964202, 79.930611),
(495, 7, 'Gampaha', 'ගම්පහ', NULL, NULL, NULL, NULL, '11000', 7.0917, 79.9942),
(496, 7, 'Ganemulla', 'ගණේමුල්ල', NULL, NULL, NULL, NULL, '11020', 7.064183, 79.963294),
(497, 7, 'Giriulla', 'ගිරිවුල්ල', NULL, NULL, NULL, NULL, '60140', 7.3275, 80.1267),
(498, 7, 'Gonawala', 'ගෝනවල', NULL, NULL, NULL, NULL, '11630', 6.9612, 79.9992),
(499, 7, 'Halpe', 'හල්පෙ', NULL, NULL, NULL, NULL, '70145', 7.261935, 80.10821),
(500, 7, 'Hapugastenna', NULL, NULL, NULL, NULL, NULL, '70164', 7.1, 80.1667),
(501, 7, 'Heiyanthuduwa', NULL, NULL, NULL, NULL, NULL, '11618', 6.96283, 79.963309),
(502, 7, 'Hinatiyana Madawala', NULL, NULL, NULL, NULL, NULL, '11568', 7.1667, 79.95),
(503, 7, 'Hiswella', NULL, NULL, NULL, NULL, NULL, '11734', 7.021559, 80.160869),
(504, 7, 'Horampella', NULL, NULL, NULL, NULL, NULL, '11564', 7.185188, 79.976771),
(505, 7, 'Hunumulla', NULL, NULL, NULL, NULL, NULL, '11262', 7.244925, 79.996921),
(506, 7, 'Hunupola', NULL, NULL, NULL, NULL, NULL, '60582', 7.111463, 80.130625),
(507, 7, 'Ihala Madampella', NULL, NULL, NULL, NULL, NULL, '11265', 7.250345, 79.960941),
(508, 7, 'Imbulgoda', NULL, NULL, NULL, NULL, NULL, '11856', 7.035, 79.9931),
(509, 7, 'Ja-Ela', NULL, NULL, NULL, NULL, NULL, '11350', 7.076147, 79.894932),
(510, 7, 'Kadawatha', NULL, NULL, NULL, NULL, NULL, '11850', 7.0258, 79.9882),
(511, 7, 'Kahatowita', NULL, NULL, NULL, NULL, NULL, '11144', 7.0667, 80.1167),
(512, 7, 'Kalagedihena', NULL, NULL, NULL, NULL, NULL, '11875', 7.118004, 80.058001),
(513, 7, 'Kaleliya', NULL, NULL, NULL, NULL, NULL, '11160', 7.195, 80.1136),
(514, 7, 'Kandana', NULL, NULL, NULL, NULL, NULL, '11320', 7.05056, 79.895123),
(515, 7, 'Katana', NULL, NULL, NULL, NULL, NULL, '11534', 7.2517, 79.9078),
(516, 7, 'Katudeniya', NULL, NULL, NULL, NULL, NULL, '21016', 7.3, 80.0833),
(517, 7, 'Katunayake', NULL, NULL, NULL, NULL, NULL, '11450', 7.1647, 79.8731),
(518, 7, 'Katunayake Air Force Camp', NULL, NULL, NULL, NULL, NULL, '11440', 7.1407, 79.8782),
(519, 7, 'Katunayake(FTZ)', NULL, NULL, NULL, NULL, NULL, '11420', 7.1407, 79.8782),
(520, 7, 'Katuwellegama', NULL, NULL, NULL, NULL, NULL, '11526', 7.208557, 79.94572),
(521, 7, 'Kelaniya', NULL, NULL, NULL, NULL, NULL, '11600', 6.956357, 79.921431),
(522, 7, 'Kimbulapitiya', NULL, NULL, NULL, NULL, NULL, '11522', 7.202265, 79.908937),
(523, 7, 'Kirindiwela', NULL, NULL, NULL, NULL, NULL, '11730', 7.044223, 80.126707),
(524, 7, 'Kitalawalana', NULL, NULL, NULL, NULL, NULL, '11206', 7.3, 80.1),
(525, 7, 'Kochchikade', NULL, NULL, NULL, NULL, NULL, '11540', 7.2581, 79.8542),
(526, 7, 'Kotadeniyawa', NULL, NULL, NULL, NULL, NULL, '11232', 7.279861, 80.05581),
(527, 7, 'Kotugoda', NULL, NULL, NULL, NULL, NULL, '11390', 7.1217, 79.9297),
(528, 7, 'Kumbaloluwa', NULL, NULL, NULL, NULL, NULL, '11105', 7.179375, 80.082233),
(529, 7, 'Loluwagoda', NULL, NULL, NULL, NULL, NULL, '11204', 7.294586, 80.126624),
(530, 7, 'Mabodale', NULL, NULL, NULL, NULL, NULL, '11114', 7.2, 80.0167),
(531, 7, 'Madelgamuwa', NULL, NULL, NULL, NULL, NULL, '11033', 7.110062, 79.948175),
(532, 7, 'Makewita', NULL, NULL, NULL, NULL, NULL, '11358', 7.1, 79.9333),
(533, 7, 'Makola', NULL, NULL, NULL, NULL, NULL, '11640', 6.983178, 79.9525),
(534, 7, 'Malwana', NULL, NULL, NULL, NULL, NULL, '11670', 6.951988, 80.012561),
(535, 7, 'Mandawala', NULL, NULL, NULL, NULL, NULL, '11061', 7.003066, 80.097082),
(536, 7, 'Marandagahamula', NULL, NULL, NULL, NULL, NULL, '11260', 7.2447, 79.9696),
(537, 7, 'Mellawagedara', NULL, NULL, NULL, NULL, NULL, '11234', 7.285808, 80.023977),
(538, 7, 'Minuwangoda', NULL, NULL, NULL, NULL, NULL, '11550', 7.176455, 79.954904),
(539, 7, 'Mirigama', NULL, NULL, NULL, NULL, NULL, '11200', 7.2414, 80.1325),
(540, 7, 'Miriswatta', NULL, NULL, NULL, NULL, NULL, '80508', 7.0711, 80.0183),
(541, 7, 'Mithirigala', NULL, NULL, NULL, NULL, NULL, '11742', 6.9648, 80.0648),
(542, 7, 'Muddaragama', NULL, NULL, NULL, NULL, NULL, '11112', 7.2167, 80.05),
(543, 7, 'Mudungoda', NULL, NULL, NULL, NULL, NULL, '11056', 7.064698, 79.999092),
(544, 7, 'Mulleriyawa New Town', NULL, NULL, NULL, NULL, NULL, '10620', 6.9301, 80.0549),
(545, 7, 'Naranwala', NULL, NULL, NULL, NULL, NULL, '11063', 7.001631, 80.027404),
(546, 7, 'Nawana', NULL, NULL, NULL, NULL, NULL, '11222', 7.270062, 80.092618),
(547, 7, 'Nedungamuwa', NULL, NULL, NULL, NULL, NULL, '11066', 7.05, 80.0333),
(548, 7, 'Negombo', NULL, NULL, NULL, NULL, NULL, '11500', 7.2086, 79.8358),
(549, 7, 'Nikadalupotha', NULL, NULL, NULL, NULL, NULL, '60580', 7.1167, 80.1333),
(550, 7, 'Nikahetikanda', NULL, NULL, NULL, NULL, NULL, '11128', 7.099089, 80.179551),
(551, 7, 'Nittambuwa', NULL, NULL, NULL, NULL, NULL, '11880', 7.144243, 80.096178),
(552, 7, 'Niwandama', NULL, NULL, NULL, NULL, NULL, '11354', 7.078762, 79.928331),
(553, 7, 'Opatha', NULL, NULL, NULL, NULL, NULL, '80142', 7.132037, 79.921419),
(554, 7, 'Pamunugama', NULL, NULL, NULL, NULL, NULL, '11370', 7.094359, 79.844569),
(555, 7, 'Pamunuwatta', NULL, NULL, NULL, NULL, NULL, '11214', 7.214678, 80.139696),
(556, 7, 'Panawala', NULL, NULL, NULL, NULL, NULL, '70612', 6.9833, 80.0333),
(557, 7, 'Pasyala', NULL, NULL, NULL, NULL, NULL, '11890', 7.172926, 80.115911),
(558, 7, 'Peliyagoda', NULL, NULL, NULL, NULL, NULL, '11830', 6.960977, 79.878852),
(559, 7, 'Pepiliyawala', NULL, NULL, NULL, NULL, NULL, '11741', 7.002342, 80.128886),
(560, 7, 'Pethiyagoda', NULL, NULL, NULL, NULL, NULL, '11043', 7.1167, 80.0167),
(561, 7, 'Polpithimukulana', NULL, NULL, NULL, NULL, NULL, '11324', 7.0444, 79.8782),
(562, 7, 'Puwakpitiya', NULL, NULL, NULL, NULL, NULL, '10712', 7.040498, 80.064451),
(563, 7, 'Radawadunna', NULL, NULL, NULL, NULL, NULL, '11892', 7.177279, 80.141344),
(564, 7, 'Radawana', NULL, NULL, NULL, NULL, NULL, '11725', 7.029871, 80.100915),
(565, 7, 'Raddolugama', NULL, NULL, NULL, NULL, NULL, '11400', 7.140656, 79.898198),
(566, 7, 'Ragama', NULL, NULL, NULL, NULL, NULL, '11010', 7.025281, 79.917386),
(567, 7, 'Ruggahawila', NULL, NULL, NULL, NULL, NULL, '11142', 7.0667, 80.1167),
(568, 7, 'Seeduwa', NULL, NULL, NULL, NULL, NULL, '11410', 7.132059, 79.885024),
(569, 7, 'Siyambalape', NULL, NULL, NULL, NULL, NULL, '11607', 6.964545, 79.986406),
(570, 7, 'Talahena', NULL, NULL, NULL, NULL, NULL, '11504', 7.1667, 79.8167),
(571, 7, 'Thambagalla', NULL, NULL, NULL, NULL, NULL, '60584', 7.1167, 80.1333),
(572, 7, 'Thimbirigaskatuwa', NULL, NULL, NULL, NULL, NULL, '11532', 7.2669, 79.9495),
(573, 7, 'Tittapattara', NULL, NULL, NULL, NULL, NULL, '10664', 6.9297, 80.0889),
(574, 7, 'Udathuthiripitiya', NULL, NULL, NULL, NULL, NULL, '11054', 7.075, 80.0333),
(575, 7, 'Udugampola', NULL, NULL, NULL, NULL, NULL, '11030', 7.1167, 79.9833),
(576, 7, 'Uggalboda', NULL, NULL, NULL, NULL, NULL, '11034', 7.135549, 79.948259),
(577, 7, 'Urapola', NULL, NULL, NULL, NULL, NULL, '11126', 7.104792, 80.136935),
(578, 7, 'Uswetakeiyawa', NULL, NULL, NULL, NULL, NULL, '11328', 7.031046, 79.860339),
(579, 7, 'Veyangoda', NULL, NULL, NULL, NULL, NULL, '11100', 7.156981, 80.095842),
(580, 7, 'Walgammulla', NULL, NULL, NULL, NULL, NULL, '11146', 7.071902, 80.116511),
(581, 7, 'Walpita', NULL, NULL, NULL, NULL, NULL, '11226', 7.258131, 80.034704),
(582, 7, 'Walpola (WP)', NULL, NULL, NULL, NULL, NULL, '11012', 7.0418, 79.9257),
(583, 7, 'Wathurugama', NULL, NULL, NULL, NULL, NULL, '11724', 7.0421, 80.0701),
(584, 7, 'Watinapaha', NULL, NULL, NULL, NULL, NULL, '11104', 7.2, 79.9833),
(585, 7, 'Wattala', NULL, NULL, NULL, NULL, NULL, '11104', 6.990037, 79.892207),
(586, 7, 'Weboda', NULL, NULL, NULL, NULL, NULL, '11858', 7.0167, 79.9833),
(587, 7, 'Wegowwa', NULL, NULL, NULL, NULL, NULL, '11562', 7.178443, 79.962063),
(588, 7, 'Weweldeniya', NULL, NULL, NULL, NULL, NULL, '11894', 7.1834, 80.1446),
(589, 7, 'Yakkala', NULL, NULL, NULL, NULL, NULL, '11870', 7.1167, 80.05),
(590, 7, 'Yatiyana', NULL, NULL, NULL, NULL, NULL, '11566', 7.184998, 79.931858),
(591, 8, 'Ambalantota', 'අම්බලන්තොට', NULL, NULL, NULL, NULL, '82100', 6.114494, 81.025983),
(592, 8, 'Angunakolapelessa', 'අඟුණකොළපැලැස්ස', NULL, NULL, NULL, NULL, '82220', 6.162261, 80.899471),
(593, 8, 'Angunakolawewa', 'අඟුණකොලවැව', NULL, NULL, NULL, NULL, '91302', 6.389127, 81.093226),
(594, 8, 'Bandagiriya Colony', 'බන්ඩගිරිය කොලොනි', NULL, NULL, NULL, NULL, '82005', 6.1833, 81.1389),
(595, 8, 'Barawakumbuka', 'බරවකුඹුර', NULL, NULL, NULL, NULL, '82110', 6.1667, 80.8167),
(596, 8, 'Beliatta', 'බෙලිඅත්ත', NULL, NULL, NULL, NULL, '82400', 6.048637, 80.734343),
(597, 8, 'Beragama', 'බෙරගම', NULL, NULL, NULL, NULL, '82102', 6.15, 81.0667),
(598, 8, 'Beralihela', 'බෙරලිහෙල', NULL, NULL, NULL, NULL, '82618', 6.2556, 81.2944),
(599, 8, 'Bundala', 'බූන්දල', NULL, NULL, NULL, NULL, '82002', 6.195164, 81.250493),
(600, 8, 'Ellagala', 'ඇල්ලගල', NULL, NULL, NULL, NULL, '82619', 6.26867, 81.359512);
INSERT INTO `cities` (`id`, `district_id`, `name_en`, `name_si`, `name_ta`, `sub_name_en`, `sub_name_si`, `sub_name_ta`, `postcode`, `latitude`, `longitude`) VALUES
(601, 8, 'Gangulandeniya', 'ගඟුලදෙණිය', NULL, NULL, NULL, NULL, '82586', 6.2833, 80.7167),
(602, 8, 'Getamanna', 'ගැටමාන්න', NULL, NULL, NULL, NULL, '82420', 6.036244, 80.669146),
(603, 8, 'Goda Koggalla', 'ගොඩ කොග්ගල්ල', NULL, NULL, NULL, NULL, '82401', 6.0333, 80.75),
(604, 8, 'Gonagamuwa Uduwila', 'ගොනාගමුව උඩුවිල', NULL, NULL, NULL, NULL, '82602', 6.25, 81.2917),
(605, 8, 'Gonnoruwa', 'ගොන්නොරුව', NULL, NULL, NULL, NULL, '82006', 6.230443, 81.112465),
(606, 8, 'Hakuruwela', 'හකුරුවෙල', NULL, NULL, NULL, NULL, '82248', 6.146456, 80.83047),
(607, 8, 'Hambantota', 'හම්බන්තොට', NULL, NULL, NULL, NULL, '82000', 6.127563, 81.111287),
(608, 8, 'Handugala', 'හඳගුල', NULL, NULL, NULL, NULL, '81326', 6.188877, 80.62414),
(609, 8, 'Hungama', NULL, NULL, NULL, NULL, NULL, '82120', 6.108006, 80.927144),
(610, 8, 'Ihala Beligalla', NULL, NULL, NULL, NULL, NULL, '82412', 6.092378, 80.747311),
(611, 8, 'Ittademaliya', NULL, NULL, NULL, NULL, NULL, '82462', 6.167432, 80.735179),
(612, 8, 'Julampitiya', NULL, NULL, NULL, NULL, NULL, '82252', 6.2261, 80.7403),
(613, 8, 'Kahandamodara', NULL, NULL, NULL, NULL, NULL, '82126', 6.078654, 80.902917),
(614, 8, 'Kariyamaditta', NULL, NULL, NULL, NULL, NULL, '82274', 6.257359, 80.809448),
(615, 8, 'Katuwana', NULL, NULL, NULL, NULL, NULL, '82500', 6.2667, 80.6972),
(616, 8, 'Kawantissapura', NULL, NULL, NULL, NULL, NULL, '82622', 6.2786, 81.2524),
(617, 8, 'Kirama', NULL, NULL, NULL, NULL, NULL, '82550', 6.2117, 80.6653),
(618, 8, 'Kirinda', NULL, NULL, NULL, NULL, NULL, '82614', 6.268985, 81.290653),
(619, 8, 'Lunama', NULL, NULL, NULL, NULL, NULL, '82108', 6.098517, 80.971511),
(620, 8, 'Lunugamwehera', NULL, NULL, NULL, NULL, NULL, '82634', 6.3417, 81.15),
(621, 8, 'Magama', NULL, NULL, NULL, NULL, NULL, '82608', 6.280108, 81.270354),
(622, 8, 'Mahagalwewa', NULL, NULL, NULL, NULL, NULL, '82016', 6.1833, 81.1389),
(623, 8, 'Mamadala', NULL, NULL, NULL, NULL, NULL, '82109', 6.158126, 80.96681),
(624, 8, 'Medamulana', NULL, NULL, NULL, NULL, NULL, '82254', 6.175878, 80.770016),
(625, 8, 'Middeniya', NULL, NULL, NULL, NULL, NULL, '82270', 6.2494, 80.7672),
(626, 8, 'Migahajandur', NULL, NULL, NULL, NULL, NULL, '82014', 6.1833, 81.1389),
(627, 8, 'Modarawana', NULL, NULL, NULL, NULL, NULL, '82416', 6.117576, 80.720781),
(628, 8, 'Mulkirigala', NULL, NULL, NULL, NULL, NULL, '82242', 6.12, 80.7397),
(629, 8, 'Nakulugamuwa', NULL, NULL, NULL, NULL, NULL, '82300', 6.1842, 80.9063),
(630, 8, 'Netolpitiya', NULL, NULL, NULL, NULL, NULL, '82135', 6.066848, 80.850703),
(631, 8, 'Nihiluwa', NULL, NULL, NULL, NULL, NULL, '82414', 6.077147, 80.696499),
(632, 8, 'Padawkema', NULL, NULL, NULL, NULL, NULL, '82636', 6.35, 81.1667),
(633, 8, 'Pahala Andarawewa', NULL, NULL, NULL, NULL, NULL, '82008', 6.1833, 81.1389),
(634, 8, 'Rammalawarapitiya', NULL, NULL, NULL, NULL, NULL, '82554', 6.2117, 80.6653),
(635, 8, 'Ranakeliya', NULL, NULL, NULL, NULL, NULL, '82612', 6.2167, 81.3),
(636, 8, 'Ranmuduwewa', NULL, NULL, NULL, NULL, NULL, '82018', 6.1833, 81.1389),
(637, 8, 'Ranna', NULL, NULL, NULL, NULL, NULL, '82125', 6.103377, 80.890168),
(638, 8, 'Ratmalwala', NULL, NULL, NULL, NULL, NULL, '82276', 6.2667, 80.85),
(639, 8, 'RU/Ridiyagama', NULL, NULL, NULL, NULL, NULL, '82106', 6.1375, 81.0042),
(640, 8, 'Sooriyawewa Town', NULL, NULL, NULL, NULL, NULL, '82010', 6.1833, 81.1389),
(641, 8, 'Tangalla', NULL, NULL, NULL, NULL, NULL, '82200', 6.0231, 80.7889),
(642, 8, 'Tissamaharama', NULL, NULL, NULL, NULL, NULL, '82600', 6.370333, 81.328087),
(643, 8, 'Uda Gomadiya', NULL, NULL, NULL, NULL, NULL, '82504', 6.2667, 80.6972),
(644, 8, 'Udamattala', NULL, NULL, NULL, NULL, NULL, '82638', 6.3333, 81.1333),
(645, 8, 'Uswewa', NULL, NULL, NULL, NULL, NULL, '82278', 6.246247, 80.862175),
(646, 8, 'Vitharandeniya', NULL, NULL, NULL, NULL, NULL, '82232', 6.1824, 80.806),
(647, 8, 'Walasmulla', NULL, NULL, NULL, NULL, NULL, '82450', 6.15, 80.7),
(648, 8, 'Weeraketiya', NULL, NULL, NULL, NULL, NULL, '82240', 6.135, 80.7865),
(649, 8, 'Weerawila', NULL, NULL, NULL, NULL, NULL, '82632', 6.3417, 81.15),
(650, 8, 'Weerawila NewTown', NULL, NULL, NULL, NULL, NULL, '82615', 6.2556, 81.2944),
(651, 8, 'Wekandawela', NULL, NULL, NULL, NULL, NULL, '82246', 6.135, 80.7865),
(652, 8, 'Weligatta', NULL, NULL, NULL, NULL, NULL, '82004', 6.205897, 81.196032),
(653, 8, 'Yatigala', NULL, NULL, NULL, NULL, NULL, '82418', 6.1, 80.6833),
(654, 9, 'Jaffna', NULL, NULL, NULL, NULL, NULL, '40000', 9.660668, 80.022706),
(655, 10, 'Agalawatta', 'අගලවත්ත', NULL, NULL, NULL, NULL, '12200', 6.541499, 80.155785),
(656, 10, 'Alubomulla', 'අලුබෝමුල්ල', NULL, NULL, NULL, NULL, '12524', 6.711977, 79.965857),
(657, 10, 'Anguruwatota', 'අංගුරුවතොට', NULL, NULL, NULL, NULL, '12320', 6.6383, 80.0861),
(658, 10, 'Atale', 'අටලේ', NULL, NULL, NULL, NULL, '71363', 6.45, 80.2667),
(659, 10, 'Baduraliya', 'බදුරලීය', NULL, NULL, NULL, NULL, '12230', 6.523102, 80.232371),
(660, 10, 'Bandaragama', 'බණ්ඩාරගම', NULL, NULL, NULL, NULL, '12530', 6.710264, 79.986087),
(661, 10, 'Batugampola', 'බටුගම්පොල', NULL, NULL, NULL, NULL, '10526', 6.769068, 80.142775),
(662, 10, 'Bellana', 'බෙල්ලන', NULL, NULL, NULL, NULL, '12224', 6.518936, 80.183117),
(663, 10, 'Beruwala', 'බේරුවල', NULL, NULL, NULL, NULL, '12070', 6.4739, 79.9842),
(664, 10, 'Bolossagama', 'බොලොස්සගම', NULL, NULL, NULL, NULL, '12008', 6.62099, 80.015288),
(665, 10, 'Bombuwala', 'බොඹුවල', NULL, NULL, NULL, NULL, '12024', 6.5833, 80.0167),
(666, 10, 'Boralugoda', 'බොරළුගොඩ', NULL, NULL, NULL, NULL, '12142', 6.438709, 80.278799),
(667, 10, 'Bulathsinhala', 'බුලත්සිංහල', NULL, NULL, NULL, NULL, '12300', 6.666199, 80.164896),
(668, 10, 'Danawala Thiniyawala', 'දනවල තිනියවල', NULL, NULL, NULL, NULL, '12148', 6.4333, 80.2667),
(669, 10, 'Delmella', 'දෙල්මෙල්ල', NULL, NULL, NULL, NULL, '12304', 6.67833, 80.210488),
(670, 10, 'Dharga Town', 'දර්ගා නගරය', NULL, NULL, NULL, NULL, '12090', 6.648, 80.0089),
(671, 10, 'Diwalakada', 'දිවාලකද', NULL, NULL, NULL, NULL, '12308', 6.696767, 80.146983),
(672, 10, 'Dodangoda', 'දොඩන්ගොඩ', NULL, NULL, NULL, NULL, '12020', 6.555952, 80.006847),
(673, 10, 'Dombagoda', 'දොඹගොඩ', NULL, NULL, NULL, NULL, '12416', 6.661797, 80.053343),
(674, 10, 'Ethkandura', 'ඇත්කඳුර', NULL, NULL, NULL, NULL, '80458', 6.4415, 80.1807),
(675, 10, 'Galpatha', 'ගල්පාත', NULL, NULL, NULL, NULL, '12005', 6.5983, 80.0015),
(676, 10, 'Gamagoda', 'ගමගොඩ', NULL, NULL, NULL, NULL, '12016', 6.597103, 80.005539),
(677, 10, 'Gonagalpura', 'ගොනාගල්පුර', NULL, NULL, NULL, NULL, '80502', 6.6307, 80.0169),
(678, 10, 'Gonapola Junction', 'ගෝනපොල හංදිය', NULL, NULL, NULL, NULL, '12410', 6.6944, 80.0333),
(679, 10, 'Govinna', 'ගෝවින්න', NULL, NULL, NULL, NULL, '12310', 6.663337, 80.116274),
(680, 10, 'Gurulubadda', 'ගුරුලුබැද්ද', NULL, NULL, NULL, NULL, '12236', 6.5333, 80.2667),
(681, 10, 'Halkandawila', 'හල්කන්දවිල', NULL, NULL, NULL, NULL, '12055', 6.5167, 80.0167),
(682, 10, 'Haltota', 'හල්තොට', NULL, NULL, NULL, NULL, '12538', 6.69554, 80.02127),
(683, 10, 'Halvitigala Colony', 'හල්විටගල ජනපදය', NULL, NULL, NULL, NULL, '80146', 6.5791, 80.2233),
(684, 10, 'Halwala', 'හල්වල', NULL, NULL, NULL, NULL, '12118', 6.416524, 80.106562),
(685, 10, 'Halwatura', 'හල්වතුර', NULL, NULL, NULL, NULL, '12306', 6.7, 80.2),
(686, 10, 'Handapangoda', 'හඳපාන්ගොඩ', NULL, NULL, NULL, NULL, '10524', 6.789746, 80.140774),
(687, 10, 'Hedigalla Colony', NULL, NULL, NULL, NULL, NULL, '12234', 6.5333, 80.2667),
(688, 10, 'Henegama', NULL, NULL, NULL, NULL, NULL, '11715', 6.7167, 80.0333),
(689, 10, 'Hettimulla', NULL, NULL, NULL, NULL, NULL, '71210', 6.461362, 79.992643),
(690, 10, 'Horana', NULL, NULL, NULL, NULL, NULL, '12400', 6.719389, 80.061557),
(691, 10, 'Ittapana', NULL, NULL, NULL, NULL, NULL, '12116', 6.42254, 80.079501),
(692, 10, 'Kahawala', NULL, NULL, NULL, NULL, NULL, '10508', 6.7833, 80.1),
(693, 10, 'Kalawila Kiranthidiya', NULL, NULL, NULL, NULL, NULL, '12078', 6.4619, 80.0004),
(694, 10, 'Kalutara', NULL, NULL, NULL, NULL, NULL, '12000', 6.581333, 79.958546),
(695, 10, 'Kananwila', NULL, NULL, NULL, NULL, NULL, '12418', 6.7667, 80.05),
(696, 10, 'Kandanagama', NULL, NULL, NULL, NULL, NULL, '12428', 6.7667, 80.0778),
(697, 10, 'Kelinkanda', NULL, NULL, NULL, NULL, NULL, '12218', 6.587128, 80.29322),
(698, 10, 'Kitulgoda', NULL, NULL, NULL, NULL, NULL, '12222', 6.5167, 80.1833),
(699, 10, 'Koholana', NULL, NULL, NULL, NULL, NULL, '12007', 6.618149, 79.989353),
(700, 10, 'Kuda Uduwa', NULL, NULL, NULL, NULL, NULL, '12426', 6.747871, 80.078499),
(701, 10, 'Labbala', NULL, NULL, NULL, NULL, NULL, '60162', 6.4833, 80),
(702, 10, 'lhalahewessa', NULL, NULL, NULL, NULL, NULL, '80432', 6.4415, 80.1807),
(703, 10, 'lnduruwa', NULL, NULL, NULL, NULL, NULL, '80510', 6.4681, 80.0257),
(704, 10, 'lngiriya', NULL, NULL, NULL, NULL, NULL, '12440', 6.7296, 80.0604),
(705, 10, 'Maggona', NULL, NULL, NULL, NULL, NULL, '12060', 6.503158, 79.977597),
(706, 10, 'Mahagama', NULL, NULL, NULL, NULL, NULL, '12210', 6.620177, 80.154204),
(707, 10, 'Mahakalupahana', NULL, NULL, NULL, NULL, NULL, '12126', 6.3917, 80.1417),
(708, 10, 'Maharangalla', NULL, NULL, NULL, NULL, NULL, '71211', 6.4667, 80),
(709, 10, 'Malgalla Talangalla', NULL, NULL, NULL, NULL, NULL, '80144', 6.5791, 80.2233),
(710, 10, 'Matugama', NULL, NULL, NULL, NULL, NULL, '12100', 6.5222, 80.1144),
(711, 10, 'Meegahatenna', NULL, NULL, NULL, NULL, NULL, '12130', 6.3637, 80.285),
(712, 10, 'Meegama', NULL, NULL, NULL, NULL, NULL, '12094', 6.648, 80.0089),
(713, 10, 'Meegoda', NULL, NULL, NULL, NULL, NULL, '10504', 6.8053, 80.0829),
(714, 10, 'Millaniya', NULL, NULL, NULL, NULL, NULL, '12412', 6.686206, 80.017227),
(715, 10, 'Millewa', NULL, NULL, NULL, NULL, NULL, '12422', 6.7833, 80.0667),
(716, 10, 'Miwanapalana', NULL, NULL, NULL, NULL, NULL, '12424', 6.75, 80.1),
(717, 10, 'Molkawa', NULL, NULL, NULL, NULL, NULL, '12216', 6.607725, 80.238612),
(718, 10, 'Morapitiya', NULL, NULL, NULL, NULL, NULL, '12232', 6.527127, 80.263667),
(719, 10, 'Morontuduwa', NULL, NULL, NULL, NULL, NULL, '12564', 6.65, 79.9667),
(720, 10, 'Nawattuduwa', NULL, NULL, NULL, NULL, NULL, '12106', 6.5019, 80.0937),
(721, 10, 'Neboda', NULL, NULL, NULL, NULL, NULL, '12030', 6.5906, 80.0842),
(722, 10, 'Padagoda', NULL, NULL, NULL, NULL, NULL, '12074', 6.456979, 80.009049),
(723, 10, 'Pahalahewessa', NULL, NULL, NULL, NULL, NULL, '12144', 6.4333, 80.2667),
(724, 10, 'Paiyagala', NULL, NULL, NULL, NULL, NULL, '12050', 6.5167, 80.0167),
(725, 10, 'Panadura', NULL, NULL, NULL, NULL, NULL, '12500', 6.7133, 79.9042),
(726, 10, 'Pannala', NULL, NULL, NULL, NULL, NULL, '60160', 6.4833, 80),
(727, 10, 'Paragastota', NULL, NULL, NULL, NULL, NULL, '12414', 6.6667, 80),
(728, 10, 'Paragoda', NULL, NULL, NULL, NULL, NULL, '12302', 6.627108, 80.24112),
(729, 10, 'Paraigama', NULL, NULL, NULL, NULL, NULL, '12122', 6.4167, 80.1167),
(730, 10, 'Pelanda', NULL, NULL, NULL, NULL, NULL, '12214', 6.6056, 80.2333),
(731, 10, 'Pelawatta', NULL, NULL, NULL, NULL, NULL, '12138', 6.385227, 80.207989),
(732, 10, 'Pimbura', NULL, NULL, NULL, NULL, NULL, '70472', 6.570997, 80.161311),
(733, 10, 'Pitagaldeniya', NULL, NULL, NULL, NULL, NULL, '71360', 6.45, 80.2667),
(734, 10, 'Pokunuwita', NULL, NULL, NULL, NULL, NULL, '12404', 6.7333, 80.0333),
(735, 10, 'Poruwedanda', NULL, NULL, NULL, NULL, NULL, '12432', 6.7333, 80.1167),
(736, 10, 'Ratmale', NULL, NULL, NULL, NULL, NULL, '81030', 6.45, 80.2),
(737, 10, 'Remunagoda', NULL, NULL, NULL, NULL, NULL, '12009', 6.594994, 80.031349),
(738, 10, 'Talgaswela', NULL, NULL, NULL, NULL, NULL, '80470', 6.4415, 80.1807),
(739, 10, 'Tebuwana', NULL, NULL, NULL, NULL, NULL, '12025', 6.5944, 80.0611),
(740, 10, 'Uduwara', NULL, NULL, NULL, NULL, NULL, '12322', 6.6167, 80.0667),
(741, 10, 'Utumgama', NULL, NULL, NULL, NULL, NULL, '12127', 6.3917, 80.1417),
(742, 10, 'Veyangalla', NULL, NULL, NULL, NULL, NULL, '12204', 6.5422, 80.1583),
(743, 10, 'Wadduwa', NULL, NULL, NULL, NULL, NULL, '12560', 6.667121, 79.924051),
(744, 10, 'Walagedara', NULL, NULL, NULL, NULL, NULL, '12112', 6.437775, 80.071449),
(745, 10, 'Walallawita', NULL, NULL, NULL, NULL, NULL, '12134', 6.3667, 80.2),
(746, 10, 'Waskaduwa', NULL, NULL, NULL, NULL, NULL, '12580', 6.6317, 79.9442),
(747, 10, 'Welipenna', NULL, NULL, NULL, NULL, NULL, '12108', 6.466448, 80.101763),
(748, 10, 'Weliveriya', NULL, NULL, NULL, NULL, NULL, '11710', 6.7167, 80.0333),
(749, 10, 'Welmilla Junction', NULL, NULL, NULL, NULL, NULL, '12534', 6.7072, 80.01),
(750, 10, 'Weragala', NULL, NULL, NULL, NULL, NULL, '71622', 6.527062, 80.004097),
(751, 10, 'Yagirala', NULL, NULL, NULL, NULL, NULL, '12124', 6.378714, 80.161812),
(752, 10, 'Yatadolawatta', NULL, NULL, NULL, NULL, NULL, '12104', 6.52309, 80.064428),
(753, 10, 'Yatawara Junction', NULL, NULL, NULL, NULL, NULL, '12006', 6.5983, 80.0015),
(754, 11, 'Aludeniya', 'අලුදෙණිය', NULL, NULL, NULL, NULL, '20062', 7.370491, 80.46648),
(755, 11, 'Ambagahapelessa', 'අඹගහපැලැස්ස', NULL, NULL, NULL, NULL, '20986', 7.243803, 81.00264),
(756, 11, 'Ambagamuwa Udabulathgama', 'අඹගමුව උඩබුලත්ගම', NULL, NULL, NULL, NULL, '20678', 7.0333, 80.5),
(757, 11, 'Ambatenna', 'අඹතැන්න', NULL, NULL, NULL, NULL, '20136', 7.3472, 80.6192),
(758, 11, 'Ampitiya', 'අම්පිටිය', NULL, NULL, NULL, NULL, '20160', 7.2667, 80.65),
(759, 11, 'Ankumbura', 'අංකුඹුර', NULL, NULL, NULL, NULL, '20150', 7.434149, 80.568704),
(760, 11, 'Atabage', 'අටබාගෙ', NULL, NULL, NULL, NULL, '20574', 7.1333, 80.6),
(761, 11, 'Balana', 'බලන', NULL, NULL, NULL, NULL, '20308', 7.269032, 80.485503),
(762, 11, 'Bambaragahaela', 'බඹරගහඇල', NULL, NULL, NULL, NULL, '20644', 7.0523, 80.5023),
(763, 11, 'Batagolladeniya', 'බටගොල්ලදෙණිය', NULL, NULL, NULL, NULL, '20154', 7.41596, 80.576688),
(764, 11, 'Batugoda', 'බටුගොඩ', NULL, NULL, NULL, NULL, '20132', 7.366275, 80.59604),
(765, 11, 'Batumulla', 'බටුමුල්ල', NULL, NULL, NULL, NULL, '20966', 7.256086, 80.978905),
(766, 11, 'Bawlana', 'බව්ලන', NULL, NULL, NULL, NULL, '20218', 7.211388, 80.718828),
(767, 11, 'Bopana', 'බෝපන', NULL, NULL, NULL, NULL, '20932', 7.3, 80.9),
(768, 11, 'Danture', 'දංතුරේ', NULL, NULL, NULL, NULL, '20465', 7.2833, 80.5333),
(769, 11, 'Dedunupitiya', 'දේදුනුපිටිය', NULL, NULL, NULL, NULL, '20068', 7.3333, 80.4333),
(770, 11, 'Dekinda', 'දෙකිඳ', NULL, NULL, NULL, NULL, '20658', 7.014688, 80.509932),
(771, 11, 'Deltota', 'දෙල්තොට', NULL, NULL, NULL, NULL, '20430', 7.2, 80.6667),
(772, 11, 'Divulankadawala', 'දිවුලන්කදවල', NULL, NULL, NULL, NULL, '51428', 7.175, 80.55),
(773, 11, 'Dolapihilla', 'දොලපිහිල්ල', NULL, NULL, NULL, NULL, '20126', 7.393576, 80.584659),
(774, 11, 'Dolosbage', 'දොලොස්බාගෙ', NULL, NULL, NULL, NULL, '20510', 7.0806, 80.4731),
(775, 11, 'Dunuwila', 'දුනුවිල', NULL, NULL, NULL, NULL, '20824', 7.3833, 80.6333),
(776, 11, 'Etulgama', 'ඇතුල්ගම', NULL, NULL, NULL, NULL, '20202', 7.2333, 80.65),
(777, 11, 'Galaboda', 'ගලබොඩ', NULL, NULL, NULL, NULL, '20664', 6.9875, 80.5319),
(778, 11, 'Galagedara', 'ගලගෙදර', NULL, NULL, NULL, NULL, '20100', 7.369716, 80.520308),
(779, 11, 'Galaha', 'ගලහ', NULL, NULL, NULL, NULL, '20420', 7.195764, 80.668659),
(780, 11, 'Galhinna', 'ගල්හින්න', NULL, NULL, NULL, NULL, '20152', 7.418361, 80.560015),
(781, 11, 'Gampola', 'ගම්පොල', NULL, NULL, NULL, NULL, '20500', 7.1647, 80.5767),
(782, 11, 'Gelioya', 'ගෙලිඔය', NULL, NULL, NULL, NULL, '20620', 7.2136, 80.6017),
(783, 11, 'Godamunna', 'ගොඩමුන්න', NULL, NULL, NULL, NULL, '20214', 7.227313, 80.697447),
(784, 11, 'Gomagoda', 'ගොමගොඩ', NULL, NULL, NULL, NULL, '20184', 7.3167, 80.7333),
(785, 11, 'Gonagantenna', 'ගොනාගන්තැන්න', NULL, NULL, NULL, NULL, '20712', 7.1517, 80.7118),
(786, 11, 'Gonawalapatana', 'ගෝනවලපතන', NULL, NULL, NULL, NULL, '20656', 7.0358, 80.5262),
(787, 11, 'Gunnepana', 'ගුන්නෙපන', NULL, NULL, NULL, NULL, '20270', 7.2696, 80.6537),
(788, 11, 'Gurudeniya', 'ගුරුදෙණිය', NULL, NULL, NULL, NULL, '20189', 7.265953, 80.702921),
(789, 11, 'Hakmana', 'හක්මන', NULL, NULL, NULL, NULL, '81300', 7.334701, 80.82402),
(790, 11, 'Handaganawa', 'හඳගනාව', NULL, NULL, NULL, NULL, '20984', 7.277451, 80.989485),
(791, 11, 'Handawalapitiya', 'හඳවලපිටිය', NULL, NULL, NULL, NULL, '20438', 7.2, 80.6667),
(792, 11, 'Handessa', 'හඳැස්ස', NULL, NULL, NULL, NULL, '20480', 7.230048, 80.580831),
(793, 11, 'Hanguranketha', NULL, NULL, NULL, NULL, NULL, '20710', 7.1517, 80.7118),
(794, 11, 'Harangalagama', NULL, NULL, NULL, NULL, NULL, '20669', 7.0271, 80.5493),
(795, 11, 'Hataraliyadda', NULL, NULL, NULL, NULL, NULL, '20060', 7.3333, 80.4667),
(796, 11, 'Hindagala', NULL, NULL, NULL, NULL, NULL, '20414', 7.231512, 80.600815),
(797, 11, 'Hondiyadeniya', NULL, NULL, NULL, NULL, NULL, '20524', 7.1364, 80.5766),
(798, 11, 'Hunnasgiriya', NULL, NULL, NULL, NULL, NULL, '20948', 7.298756, 80.849834),
(799, 11, 'Inguruwatta', NULL, NULL, NULL, NULL, NULL, '60064', 7.175038, 80.599767),
(800, 11, 'Jambugahapitiya', NULL, NULL, NULL, NULL, NULL, '20822', 7.3833, 80.6333),
(801, 11, 'Kadugannawa', NULL, NULL, NULL, NULL, NULL, '20300', 7.2536, 80.5275),
(802, 11, 'Kahataliyadda', NULL, NULL, NULL, NULL, NULL, '20924', 7.376, 80.8213),
(803, 11, 'Kalugala', NULL, NULL, NULL, NULL, NULL, '20926', 7.390136, 80.883008),
(804, 11, 'Kandy', NULL, NULL, NULL, NULL, NULL, '20000', 7.2964, 80.635),
(805, 11, 'Kapuliyadde', NULL, NULL, NULL, NULL, NULL, '20206', 7.2401, 80.6808),
(806, 11, 'Katugastota', NULL, NULL, NULL, NULL, NULL, '20800', 7.3161, 80.6211),
(807, 11, 'Katukitula', NULL, NULL, NULL, NULL, NULL, '20588', 7.1089, 80.6339),
(808, 11, 'Kelanigama', NULL, NULL, NULL, NULL, NULL, '20688', 7.0049, 80.5182),
(809, 11, 'Kengalla', NULL, NULL, NULL, NULL, NULL, '20186', 7.296461, 80.711767),
(810, 11, 'Ketaboola', NULL, NULL, NULL, NULL, NULL, '20660', 7.0271, 80.5493),
(811, 11, 'Ketakumbura', NULL, NULL, NULL, NULL, NULL, '20306', 7.210532, 80.571678),
(812, 11, 'Kobonila', NULL, NULL, NULL, NULL, NULL, '20928', 7.376, 80.8213),
(813, 11, 'Kolabissa', NULL, NULL, NULL, NULL, NULL, '20212', 7.225, 80.7167),
(814, 11, 'Kolongoda', NULL, NULL, NULL, NULL, NULL, '20971', 7.3552, 80.8375),
(815, 11, 'Kulugammana', NULL, NULL, NULL, NULL, NULL, '20048', 7.315193, 80.590268),
(816, 11, 'Kumbukkandura', NULL, NULL, NULL, NULL, NULL, '20902', 7.2969, 80.7686),
(817, 11, 'Kumburegama', NULL, NULL, NULL, NULL, NULL, '20086', 7.357279, 80.551316),
(818, 11, 'Kundasale', NULL, NULL, NULL, NULL, NULL, '20168', 7.2667, 80.6833),
(819, 11, 'Leemagahakotuwa', NULL, NULL, NULL, NULL, NULL, '20482', 7.2333, 80.5833),
(820, 11, 'lhala Kobbekaduwa', NULL, NULL, NULL, NULL, NULL, '20042', 7.3167, 80.5833),
(821, 11, 'Lunugama', NULL, NULL, NULL, NULL, NULL, '11062', 7.198402, 80.578244),
(822, 11, 'Lunuketiya Maditta', NULL, NULL, NULL, NULL, NULL, '20172', 7.3292, 80.716),
(823, 11, 'Madawala Bazaar', NULL, NULL, NULL, NULL, NULL, '20260', 7.2696, 80.6537),
(824, 11, 'Madawalalanda', NULL, NULL, NULL, NULL, NULL, '32016', 7.3792, 80.4982),
(825, 11, 'Madugalla', NULL, NULL, NULL, NULL, NULL, '20938', 7.265802, 80.882139),
(826, 11, 'Madulkele', NULL, NULL, NULL, NULL, NULL, '20840', 7.400281, 80.728874),
(827, 11, 'Mahadoraliyadda', NULL, NULL, NULL, NULL, NULL, '20945', 7.3, 80.85),
(828, 11, 'Mahamedagama', NULL, NULL, NULL, NULL, NULL, '20216', 7.225, 80.7167),
(829, 11, 'Mahanagapura', NULL, NULL, NULL, NULL, NULL, '32018', 7.3792, 80.4982),
(830, 11, 'Mailapitiya', NULL, NULL, NULL, NULL, NULL, '20702', 7.1517, 80.7118),
(831, 11, 'Makkanigama', NULL, NULL, NULL, NULL, NULL, '20828', 7.3833, 80.6333),
(832, 11, 'Makuldeniya', NULL, NULL, NULL, NULL, NULL, '20921', 7.341706, 80.777466),
(833, 11, 'Mangalagama', NULL, NULL, NULL, NULL, NULL, '32069', 7.285856, 80.563656),
(834, 11, 'Mapakanda', NULL, NULL, NULL, NULL, NULL, '20662', 7.007889, 80.531101),
(835, 11, 'Marassana', NULL, NULL, NULL, NULL, NULL, '20210', 7.221663, 80.732336),
(836, 11, 'Marymount Colony', NULL, NULL, NULL, NULL, NULL, '20714', 7.1517, 80.7118),
(837, 11, 'Mawatura', NULL, NULL, NULL, NULL, NULL, '20564', 7.1, 80.5667),
(838, 11, 'Medamahanuwara', NULL, NULL, NULL, NULL, NULL, '20940', 7.3, 80.85),
(839, 11, 'Medawala Harispattuwa', NULL, NULL, NULL, NULL, NULL, '20120', 7.3417, 80.6833),
(840, 11, 'Meetalawa', NULL, NULL, NULL, NULL, NULL, '20512', 7.0986, 80.4699),
(841, 11, 'Megoda Kalugamuwa', NULL, NULL, NULL, NULL, NULL, '20409', 7.2631, 80.6028),
(842, 11, 'Menikdiwela', NULL, NULL, NULL, NULL, NULL, '20470', 7.288455, 80.501662),
(843, 11, 'Menikhinna', NULL, NULL, NULL, NULL, NULL, '20170', 7.3167, 80.7),
(844, 11, 'Mimure', NULL, NULL, NULL, NULL, NULL, '20923', 7.4333, 80.8333),
(845, 11, 'Minigamuwa', NULL, NULL, NULL, NULL, NULL, '20109', 7.3333, 80.5167),
(846, 11, 'Minipe', NULL, NULL, NULL, NULL, NULL, '20983', 7.223556, 80.990971),
(847, 11, 'Moragahapallama', NULL, NULL, NULL, NULL, NULL, '32012', 7.3792, 80.4982),
(848, 11, 'Murutalawa', NULL, NULL, NULL, NULL, NULL, '20232', 7.3, 80.5667),
(849, 11, 'Muruthagahamulla', NULL, NULL, NULL, NULL, NULL, '20526', 7.1364, 80.5766),
(850, 11, 'Nanuoya', NULL, NULL, NULL, NULL, NULL, '22150', 7.1171, 80.6387),
(851, 11, 'Naranpanawa', NULL, NULL, NULL, NULL, NULL, '20176', 7.339733, 80.729831),
(852, 11, 'Narawelpita', NULL, NULL, NULL, NULL, NULL, '81302', 7.3167, 80.8),
(853, 11, 'Nawalapitiya', NULL, NULL, NULL, NULL, NULL, '20650', 7.05048, 80.530631),
(854, 11, 'Nawathispane', NULL, NULL, NULL, NULL, NULL, '20670', 7.0333, 80.5),
(855, 11, 'Nillambe', NULL, NULL, NULL, NULL, NULL, '20418', 7.15, 80.6333),
(856, 11, 'Nugaliyadda', NULL, NULL, NULL, NULL, NULL, '20204', 7.2333, 80.7),
(857, 11, 'Ovilikanda', NULL, NULL, NULL, NULL, NULL, '21020', 7.45, 80.5667),
(858, 11, 'Pallekotuwa', NULL, NULL, NULL, NULL, NULL, '20084', 7.3333, 80.5667),