-
Notifications
You must be signed in to change notification settings - Fork 0
/
projectdb.sql
676 lines (650 loc) · 79.3 KB
/
projectdb.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
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 12, 2023 at 09:58 AM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.2.0
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `projectdb`
--
-- --------------------------------------------------------
--
-- Table structure for table `complaints`
--
CREATE TABLE `complaints` (
`ID` int(11) NOT NULL,
`Complains` text NOT NULL,
`Department` varchar(64) NOT NULL,
`User` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `complaints`
--
INSERT INTO `complaints` (`ID`, `Complains`, `Department`, `User`) VALUES
(1, 'This is a sample complaint', 'Electric', 'test@mail.com'),
(2, 'Another sample complaint', 'Electric', 'test@mail.com'),
(4, 'another sample', 'Electric', 'test2@mail.com'),
(6, 'sample query', 'dept', 'test@mail.com'),
(14, 'sadssadsad', 'dept', 'test@mail.com'),
(15, 'sdadsadsadsa', 'dept', 'test@mail.com'),
(16, 'sdsdsadsadsadsad', 'dept', 'test@mail.com'),
(17, 'some query', 'dept', 'test@mail.com'),
(18, 'some new complaint\r\n', 'dept', 'test@mail.com'),
(19, 'new new new\r\n', 'dept', 'test@mail.com'),
(20, 'succes\r\n', 'dept', 'rahul@mail.com'),
(21, 'succes\r\n', 'dept', 'rahul@mail.com'),
(22, 'succes\r\n', 'dept', 'rahul@mail.com'),
(23, 'submitted successfully\r\n', 'dept', 'rahul@mail.com'),
(24, 'another responce', 'dept', 'rahul@mail.com'),
(25, '\r\n', 'dept', 'test@mail.com'),
(26, 'more entries\r\n\r\n\r\n', 'dept', 'test@mail.com'),
(27, 'new response\r\n', 'dept', 'raul@mail.com'),
(28, 'is it making a new submition\r\n', 'dept', 'test@mail.com'),
(29, 'shivam bhaiyya ne kanch tod diya', 'dept', 'rahul@mail.com');
-- --------------------------------------------------------
--
-- Table structure for table `dataset`
--
CREATE TABLE `dataset` (
`Complains` text NOT NULL,
`Road Department` int(11) NOT NULL,
`Sewage Maintenance` int(11) NOT NULL,
`Electric Department` int(11) NOT NULL,
`Water Department` int(11) NOT NULL,
`Waste Management` int(11) NOT NULL,
`Urban Amenities` int(11) NOT NULL,
`Public Toilets` int(11) NOT NULL,
`Disposal of Dead Animals` int(11) NOT NULL,
`Pest Control` int(11) NOT NULL,
`User` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `dataset`
--
INSERT INTO `dataset` (`Complains`, `Road Department`, `Sewage Maintenance`, `Electric Department`, `Water Department`, `Waste Management`, `Urban Amenities`, `Public Toilets`, `Disposal of Dead Animals`, `Pest Control`, `User`) VALUES
('the roads near my house is broken and collects rain water during rainy season, This is leading to accidents and breeding of mosquitos.', 1, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('There are no utility poles in the area which makes it really difficult to move out in the evening, night & early morning due to the dark.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The sewer line in my area Pragati Vihar - Phase 1 is clogged for few days & causing slower access to toilets', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('A dog met with a car accident, His body is rotten and is producing a foul smell.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The sewers are very narrow in my locality which results in a clog during rainy seasons, The waste around the sewers also lead to the clogging.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Their are not proper public toilets in the locality hence it results in unhygienic surrounding.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The electric pole near our house is damaged and broken wires are hanging from it.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('My locality has no parks for children. The children end up playing on roads which can be very dangerous. There is space available for cunstructing one, please look into its possibility', 0, 0, 0, 0, 0, 1, 0, 0, 0, 'test@mail.com'),
('The sewers are jammed because of excessive waste on the roads.', 0, 1, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('During the rainy season the roads are clogged with waste that is not cleaned properly. Please send a waste management team to look into the situation.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('I am Mukesh & I live near the central city park. Me and a lot of other people go there for walk and exercise, kids come to play in the swings etc. But it has been over a year since it was last repaired. It is in very poor condition and people are facing issues with the running track, water tank, broken boundaries, broken swings etc. Please try to fix them as soon as possible.', 0, 0, 0, 0, 0, 1, 0, 0, 0, 'test@mail.com'),
('The road near my house is full of potholes and is in dire need of repair.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The construction on the main road near my workplace is taking too long and causing traffic delays.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The small width of the road in my neighborhood is causing dangerous traffic congestion.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of proper signage on the road near my school is causing confusion and making it difficult to navigate.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road in front of my business is in poor condition and is causing damage to vehicles.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the park is uneven and not properly maintained, making it difficult to walk or bike on.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the hospital is under construction and is causing major traffic delays for emergency vehicles.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the shopping center is poorly lit, making it unsafe for pedestrians to come at late night.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the senior center is not accessible for those with mobility impairments.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the train station is in poor condition and needs to be repaved.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the library is not properly maintained and is causing damage to cars.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the community center is too narrow and is causing traffic congestion during peak hours.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the sports complex is in poor condition and needs to be repaved.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the church is not properly maintained and is causing damage to cars.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the post office is too narrow and is causing traffic congestion during peak hours.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the grocery store is in poor condition and needs to be repaved.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the fire station is not properly maintained and is causing damage to cars.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the police station is too narrow and is causing traffic congestion during peak hours.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the city hall is in poor condition and needs to be repaved.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the landfill is not properly maintained and is causing damage to cars.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the waste management facility is too narrow and is causing traffic congestion during peak hours.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the water treatment plant is in poor condition and needs to be repaved.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the power plant is not properly maintained and is causing damage to cars.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the sewage treatment plant is too narrow and is causing traffic congestion during peak hours.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the recycling facility is in poor condition and needs to be repaved.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the landfill is not properly maintained and is causing damage to cars.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the waste management facility is too narrow and is causing traffic congestion during peak hours.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the water treatment plant is in poor condition and needs to be repaved.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the power plant is not properly maintained and is causing damage to cars.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The road near the sewage treatment plant is too narrow and is causing traffic congestion during peak hours', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Electric Bill Always High', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Bulbs Burning Out Frequently in my area', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('it’s about the poor sewage system in my area. People in our locality are suffering a lot due to the faulty pipelines in the sewage system. Because of the sewage problem, we face unhygienic conditions in our area.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('the open and damaged Manholes.Some pedestrians noticed that the open manholes are found almost everywhere, which are death traps for people, especially at night and during the rainy season when the roads are inundated with water covering the manholes unnoticed.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The wastewater is getting accumulated in our locality and there due to improper sewage systems.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Sewer lines are designed to last for many years, but they can eventually break down due to age or sudden changes in the ground.I suspect sewer line has shifted.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('water Pipe corrosion problem are leading to severe damage and expensive repairs.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Public restroom are prone to heavy footfall which subjects restroom Broken door accessories in my locality.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('Poor ventilation is another major problem that users face in public restrooms. Without a constant flow of fresh air, pungent smells reign supreme and there is a concentration of pathogens in the air.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('Used sanitary napkins lying everywhere make for a nauseous sight in public toilet near my area.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('public toilet door latches are not working properly, making it unsafe to use.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('Water taps don\'t work and at times there\'s no water in my locality', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Flushes are not working mostly in my locality. There\'s no jet of hand shower and there\'s a broken mug. How do you clean with a mug on an English toilet ?', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('For the last four months the road has been almost impassable. We have made several complaints. But the problem is being neglected for a long time. The surface of the road is broken by the heavy rains and blocked by the garbage. There are heaps of road material on both sides of the road.', 1, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('the road gets flooded even after a slight rain in my locality. There are pot-holes on the road. The broken culvert is also a danger for vehicles.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('There are a lots of problems due the construction of road in my area. the public has to face the problems such as traffic disarrangement, accident etc. People cannot go to their place in required time.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('near my locality there without proper water supply dispose their waste in an unplanned manner which pollute air and water.', 0, 0, 0, 1, 1, 0, 0, 0, 0, 'test@mail.com'),
('The electric power cut in this area is causing waste-treatment systems shutting down. Which is causing decrease in its daily-throughput and hence decrease in the frequency of the waste picking trucks to pick the waste.', 0, 0, 1, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('the path connecting my village to the city is having holes and cracks in it. It is really risky and challenging for everyone to travel on this path.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('the path connecting my village to the city is having holes and cracks in it. Also It becomes really difficult to travel at night as there is no utility poles or electric poles on the way', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The way is not litted properly, it become difficult to travel at night.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The streets are not luminated properly as there are not enough electric poles.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The roads and streets are not luminated properly', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('There a need of urgent pest control in locality as a lot of garbage is being dumped improperly in our area.', 0, 0, 0, 0, 1, 0, 0, 0, 1, 'test@mail.com'),
('The waste, garbage is not being treated properly. It is causing a great damage to the atmosphere around it.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('There is a urgent fix required for underground pipelines. As we are getting dirty water through the pipelines.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('There are no govt schools in my locality.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Dirty roads and clogged sewage', 0, 1, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Bad roads not good to walk and run', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Segregation of waste', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Sewage system not upto mark during rainy times', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Bad roads and Industrial construction', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('There are public toilets available but they are too dirty and stinky to use, I mean there is no point in making public toilets if there isn\'t a team made in order to maintain them on a regular basis ,I want you to work on the problem and come with an appropriate solution.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('sewage clogging', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('In so many places have problems of construction of public toilets whenever I go to public toilets i have never a good construction of public toilets.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The road of my colony is so bad. All the time when I walk on that road my cloths get so dusty and in rainy season my foot wear get wet and clothes also gets dirty.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Roads are damaged and water usually stores in them.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('There is no format of waste management. Even our roads, river are very dirty nd because of this people are facing lots of problems in terms of health , pollution etc', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The condition of roads quite questionable there are big holes and damaged road here and there and the waste disposal management of town is very bad they throw garbage at the river bank or off the hill which is a serious matter as it is causing pollution here and there. The community should make a proper garbage disposal plant and dispose the waste instead of throwing it somewhere where animals or wind will scatter it. It is a serious matter which should be taken into consideration immediately.', 1, 0, 0, 0, 1, 0, 1, 1, 0, 'test@mail.com'),
('Bad roads', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Noida is fully developed city but in Noida government doesn\'t provide fresh water here water is very salty.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('My concern is about the wires hanging around the tress and buildings which is i think very dangerous for public as well as for other living things.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The roads are sometimes so dirty and even though people keeps littering on it . It needs proper attention from the respective department.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Bad roads, Encroachment and possession of land, street is not working well, No law and order.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Proper Garbage disposal facilities are not provided to public', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('No roads at all I mean from walking distance from my home to Main road there is no causeway at all we have to Walk if there is raining', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('To repair roads after the sewage line project', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The roads in the City area are not proper.Due to that many accidents take place. Government should work on it.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The poor maintenance of the garden around our residential area and the improper disposal of waste. The garden around the residential area was watered regularly, and grass shrubs were trimmed and maintained neatly in the beginning. It has been more than a month now since any kind of maintenance is done in the garden. We have tried contacting the person in charge, but every effort has just been in vain.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Part of highways has potholes and are in bad condition. Roadways are a daily medium of travelling and yet aren\'t maintained.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('it\'s all about the problem and soo much problem. includes Bad roads condition, Sewage covers not properly, somewhere sewage leakage, drainage system beside the road, street lights not properly working and soo much waste on road side', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Polluting of the rivers', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The frequent power cuts in my area are causing major inconvenience and disruption to my daily life.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights in my neighborhood are not working properly and need to be fixed or replaced.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The coverage of street lights in my area is inadequate and needs to be increased for safety reasons.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The voltage fluctuations in my area are causing damage to my electronic devices.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I have been receiving wrong and disproportionate bills for my electricity usage.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('My electricity was disconnected without notice and without any reason.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I received a bill for electricity usage without any meter reading.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights in the park near my house are not working and need to be fixed.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the main road near my workplace are not adequate and need to be increased.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power cuts in my area are frequent and causing major inconvenience to my business.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my school are not working properly and need to be fixed.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The voltage fluctuations in my area are causing damage to my appliances.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I received a bill for electricity usage that is much higher than usual, with no explanation.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my house are not adequate and need to be increased.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('My electricity was disconnected without any warning or explanation.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I received a bill for electricity usage without any meter reading.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power cuts in my area are frequent and causing major inconvenience to my daily life.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my business are not working properly and need to be fixed.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights in my neighborhood are not adequate and need to be increased for safety reasons.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The voltage fluctuations in my area are causing damage to my electronic devices.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I have been receiving wrong and disproportionate bills for my electricity usage.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my school are not working properly and need to be fixed.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('My electricity was disconnected without notice and without any reason.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I received a bill for electricity usage without any meter reading.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power cuts in my area are frequent and causing major inconvenience to my business.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my house are not adequate and need to be increased.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The voltage fluctuations in my area are causing damage to my appliances.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I received a bill for electricity usage that is much higher than usual, with no explanation.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my workplace are not adequate and need to be increased.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('My electricity was disconnected without any warning or explanation.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I received a bill for electricity usage without any meter reading.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power cuts in my area are frequent and causing major inconvenience to my daily life.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my business are not working properly and need to be fixed.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights in my neighborhood are not adequate and need to be increased for safety reasons.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The voltage fluctuations in my area are causing damage to my electronic devices.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I have been receiving wrong and disproportionate bills for my electricity usage.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my school are not working properly and need to be fixed.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('My electricity was disconnected without notice and without any reason.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I received a bill for electricity usage without any meter reading.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power cuts in my area are frequent and causing major inconvenience to my business.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights on the road near my house are not adequate and need to be increased.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The voltage fluctuations in my area are causing damage', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The street lights in our neighborhood have been out for weeks, making it dangerous to walk at night.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power outages in our area are becoming more frequent and last longer each time.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electricity bill for our home has been consistently higher than usual, despite our usage remaining the same.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The transformer in our area is overloading and causing frequent power fluctuations.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electricity lines in our street are old and need to be upgraded for safety.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electric poles in our area are leaning and need to be repaired.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The underground electrical cables in our area are not properly maintained and are exposed above, causing problems to pedestrians', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electricity connection in our building is faulty and needs to be fixed.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electricity wiring in our area is exposed and needs to be covered for safety.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electric meters in our area are not working properly and need to be checked.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power supply to our area is inconsistent and unreliable.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electric poles and wires in our area are causing interference with our electronic devices.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electricity substation in our area is causing excessive noise pollution.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electric lines in our area are in poor condition and need to be replaced.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electricity connection in our area is not sufficient to meet the needs of the residents.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('I am writing to bring to your attention several issues related to electrical infrastructure in our neighborhood. Specifically, there are several electric poles that appear to be faulty and in need of repair. Additionally, there is poor lighting on many of the streets, making it difficult for residents to navigate safely at night.These issues not only pose a safety hazard for residents, but also negatively impact the overall aesthetic of our neighborhood. I urge the Municipal Corporation to take immediate action to address these problems and ensure the safety and well-being of residents.I would appreciate an update on the status of these repairs, and any plans for future maintenance of the electrical infrastructure in our area. Please let me know if there is any further information that I can provide to assist with this matter.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Garbage is not being picked up regularly in our neighborhood.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste collection trucks are making excessive noise in the early morning.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The garbage dump in our area is overflowing and attracting pests.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The garbage trucks are not properly sealed, causing litter on the street.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The recycling bins in our area are not being emptied frequently enough.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste disposal trucks are causing damage to the roads in our area and it needs repair, also please look into the maintainance of the truck so that no such damage occurs in the future', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The public trash cans in our area are overflowing and not being emptied regularly.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The garbage collection schedule in our area is not being adhered to.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste disposal workers in our area are not properly disposing of the waste they collect.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The composting facilities in our area are not being maintained properly and are causing bad odors.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste segregation system in our area is not being implemented properly.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system in our area is not adequate for the population density.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The public litter bins in our area are not sufficient for the amount of waste generated.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management policies in our area are not being enforced effectively.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste disposal trucks in our area are not equipped to handle hazardous waste.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management budget in our area is not sufficient to meet the needs.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste disposition in our area is not being done in an environmentally friendly way.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system in our area is not inclusive of people with disabilities.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste disposal workers in our area are not properly trained to handle different types of waste.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management plan in our area is not being implemented effectively.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Foul smell from the sewer, making it unpleasant to be in the area.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased risk of health problems due to exposure to hazardous waste.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Attraction of pests like rodents and flies.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Risk of water pollution and contamination of ground water.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Blockages in the sewer system, causing backups and flooding.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Dangerous conditions for those who work in the sewer system.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased cost of maintaining and cleaning the sewer system.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Threat to public safety due to potential sewage overflow and leaks.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inefficient treatment of waste leading to increased waste in landfills.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Increased greenhouse gas emissions due to inefficient waste management practices.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Increased burden on the healthcare system due to health problems caused by poor waste management.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Power outages and unreliable electricity supply leading to inconvenience.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased cost of electricity due to inefficient energy distribution.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Interrupted power supply leading to decreased productivity.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Difficulty in accessing basic needs like lighting, heating, and cooling.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Lack of access to technology and modern amenities due to unreliable electricity.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inefficient use of energy leading to higher carbon emissions and environmental harm.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Financial losses for businesses due to power outages and interruptions.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Health risks due to exposure to electrical hazards.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Lack of effective pest control measures leading to pest infestations in public spaces.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Health risks for the public due to exposure to harmful chemicals and pesticides.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Inefficient use of resources and increased waste due to overuse of pesticides.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Threat to non-target species and harm to the environment.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Resistance to pesticides, leading to ineffective pest control.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Increased cost for the municipal corporation to manage pest control.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Difficulty in maintaining public health and hygiene due to pest infestations.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Neglect of pest control leading to decreased quality of life for residents.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Lack of public education and awareness about safe and effective pest control methods.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Inadequate budget allocation for pest control, leading to limited resources and manpower.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Health risks due to exposure to dead animals and the spread of diseases.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Offensive odors and unpleasant sights due to dead animal disposal.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Lack of proper disposal facilities and equipment, leading to environmental pollution.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Threat to public safety due to health hazards posed by dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Increased risk of disease outbreaks due to improper disposal of dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Neglect of dead animal disposal leading to decreased quality of life for residents.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Difficulty in maintaining public health and hygiene due to dead animal disposal.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Inefficient use of resources and increased waste due to improper disposal methods.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Lack of public education and awareness about safe and responsible dead animal disposal.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Inadequate budget allocation for dead animal disposal, leading to limited resources and manpower.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Risk of animal attacks and nuisance due to the presence of scavenging animals attracted by dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Interference with wildlife habitats and migration patterns due to improper disposal of dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Negative impact on tourism and recreation due to unpleasant sights and odors from dead animal disposal.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Poor image of the municipality due to neglect of dead animal disposal.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Spread of diseases to pets and domestic animals due to improper disposal of dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Increased cost of managing public health due to the spread of diseases from dead animal disposal.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Difficulty in maintaining a clean and hygienic environment due to improper dead animal disposal.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Poor road conditions leading to increased traffic, congestion, and accidents.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Lack of proper maintenance and repair of roads, leading to damage and deterioration.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased risk to public safety due to poorly maintained roads and road infrastructure.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inefficient use of resources due to repeated repairs and maintenance.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Difficulty in accessing basic needs and services due to poor road conditions.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased cost of transportation due to inefficient road infrastructure.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Lack of public education and awareness about the importance of proper road maintenance.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Lack of access to green spaces and urban amenities due to ongoing construction.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased traffic and congestion due to road closures and diversions during construction.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inconvenience and disruption to daily life due to construction noise, dust, and other hazards.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Loss of property value and quality of life due to the negative impact of construction.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Financial losses for businesses and residents due to reduced accessibility and decreased foot traffic.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Delays in construction leading to frustration and disappointment among residents.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Poor quality of construction and substandard materials used in parks and roads.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Lack of access to clean and safe drinking water due to contamination from waste.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Poor water quality due to improper disposal and treatment of waste.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Water pollution affecting aquatic life and ecosystems.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Health hazards due to contaminated water supply and exposure to pollutants.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Financial losses for businesses and residents due to decreased access to clean water.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased cost of treating and purifying contaminated water.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Decreased property values and quality of life due to water pollution.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Difficulty in maintaining hygiene and public health due to contaminated water', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Power outages and electrical disruptions due to water damage.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased risk of electrical fires and safety hazards due to water damage.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Financial losses due to power outages and decreased productivity.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inconvenience and disruption to daily life due to power outages and electrical disruptions.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Difficulty in accessing basic needs and services due to power outages and electrical disruptions.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased cost of electricity due to water damage and system failures.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Negative impact on local economies and businesses due to power outages and electrical disruptions.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Lack of public education and awareness about the dangers of water and electricity.', 0, 0, 1, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inadequate budget allocation for electrical maintenance and repair, leading to limited resources and manpower.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Poor quality of electrical infrastructure and equipment, leading to frequent failures and disruptions.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The frequent power outages in this area are negatively affecting the functioning of the waste-recycling plants, leading to a decrease in the recycling rate and an increase in the waste piles on the streets.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of stable electricity supply is disrupting the smooth operation of the waste-management facilities, resulting in inefficient waste processing and frequent overflow of the landfill sites.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The inconsistent power supply is causing delays in the waste collection schedule, leading to a buildup of unsanitary waste on the streets and posing a health hazard to the community.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power cuts are affecting the operation of the waste-to-energy plants, resulting in a reduction in energy generation and a corresponding increase in the amount of waste sent to the landfill.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The power failures are hindering the effectiveness of the composting units, causing a decrease in the production of compost and increasing the reliance on chemical fertilizers.', 0, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Sewers are frequently clogged, causing backups in my home.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The smell from the clogged sewers is overwhelming and unsanitary.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers lead to water overflowing in the streets.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers are causing damage to my property.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to fix the clogged sewers.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers are attracting pests and rodents to the area.', 0, 1, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The constant clogs in the sewers are causing health hazards.', 0, 1, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not providing enough resources to maintain the sewers.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers are causing flooding in my basement.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly educating residents on how to prevent sewer clogs.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers are causing sewage to overflow into local bodies of water.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly inspecting and maintaining the sewers.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers are causing a decrease in property value in the area.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The constant clogs in the sewers are causing a nuisance to the community.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly enforcing regulations to prevent clogs in the sewers.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers are causing a lack of sanitation in the area.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the clogged sewers.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers are causing a public health emergency.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for damages caused by clogged sewers.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The clogs in the sewers are causing a strain on the city\'s infrastructure and budget.', 0, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply is frequently interrupted, causing inconvenience.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water pressure is low, making it difficult to use appliances and fixtures.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water is often dirty and cloudy, causing health concerns.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water bills are unexpectedly high, causing financial strain.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to fix water-related issues.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water leaks in the pipes are causing damage to my property.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources to maintain the water supply.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply is not reaching certain areas of the city, causing a lack of access.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly educating residents on how to conserve water.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply is not meeting the needs of the growing population.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly inspecting and maintaining the water supply infrastructure.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply is not safe to drink, causing health hazards.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly enforcing regulations to ensure water quality.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply is not sufficient during times of drought or high demand.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the water-related problems.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply is not being used efficiently, causing a strain on resources.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for damages caused by water-related issues.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply infrastructure is outdated and in need of repair.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply is not properly managed, leading to wastage.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The water supply problems are causing a negative impact on the environment.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The garbage is not being collected regularly, causing a buildup of waste in the area.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources for waste management.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The garbage trucks are causing noise pollution during collection times.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The garbage is not being properly sorted, leading to contamination and inefficiency.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to address waste management issues.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste disposal sites are causing a strong odor and unsanitary conditions.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is not capable of handling the amount of waste produced by the population.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly educating residents on how to properly dispose of waste.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is causing environmental pollution.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is not accessible for all residents, causing a lack of equal service.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly enforcing regulations to prevent littering and illegal dumping.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is not properly maintained, causing breakdowns and delays.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is not utilizing the latest technology and methods for efficient waste management.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is not properly managed, causing a strain on the budget.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the waste management problems.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is causing health hazards for the community.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for damages caused by waste management issues.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is not recycling enough of the waste produced.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is not properly handling hazardous materials, causing potential dangers.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste management system is not properly planned for the long-term, causing a lack of sustainability.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('Pest infestations are becoming a frequent problem in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not providing enough resources for pest control.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest control methods used by the municipal corporation are not effective.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to address pest control issues.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest infestations are causing damage to my property.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest infestations are causing health hazards for the community.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not properly educating residents on how to prevent pest infestations.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest infestations are causing a decrease in property value in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest infestations are causing a nuisance to the community.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not properly enforcing regulations to prevent pest infestations.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest infestations are causing a lack of sanitation in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the pest control problems.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest infestations are causing a public health emergency.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for damages caused by pest infestations.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest control methods used by the municipal corporation are causing harm to the environment.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not utilizing the latest technology and methods for efficient pest control.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest infestations are causing a strain on the city\'s infrastructure and budget.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not providing regular pest control services.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not addressing the root cause of pest infestations.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Pest infestations are affecting the quality of life for residents in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not removing dead animals in a timely manner.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources for the disposal of dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The disposal methods used by the municipal corporation are not effective or sanitary.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to remove dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Dead animals are causing a strong odor and unsanitary conditions in the area.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Dead animals are causing health hazards for the community.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not properly educating residents on how to report dead animal sightings.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Dead animal disposal is causing a decrease in property value in the area.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Dead animals are causing a nuisance to the community.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not properly enforcing regulations to prevent the accumulation of dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Dead animals are causing a lack of sanitation in the area.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the dead animal disposal problems.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Dead animals are causing public health emergency.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for damages caused by dead animal disposal issues.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The methods used for the disposal of dead animals are causing harm to the environment.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not utilizing the latest technology and methods for efficient disposal of dead animals', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com');
INSERT INTO `dataset` (`Complains`, `Road Department`, `Sewage Maintenance`, `Electric Department`, `Water Department`, `Waste Management`, `Urban Amenities`, `Public Toilets`, `Disposal of Dead Animals`, `Pest Control`, `User`) VALUES
('Dead animal disposal is causing a strain on the city\'s infrastructure and budget.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not providing regular dead animal disposal services.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The municipal corporation is not addressing the root cause of dead animal accumulation.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Dead animal disposal is affecting the quality of life for residents in the area.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The area is in dire need of more parks and gardens for the community to enjoy.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources for the construction of urban amenities like parks and gardens.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('There are not enough public spaces for residents to gather and relax.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to requests for the construction of parks and gardens.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of parks and gardens is causing a negative impact on the health and well-being of residents.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly educating residents on the benefits of urban amenities like parks and gardens.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of parks and gardens is causing a decrease in property value in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The area is in need of more green spaces for the community to enjoy.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly enforcing regulations to ensure the construction of parks and gardens.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of parks and gardens is causing a lack of sanitation in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the lack of urban amenities in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of parks and gardens is causing a public health emergency.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for the lack of urban amenities in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The area is in need of more nature-based amenities to promote community well-being', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The area is in need of more recreational spaces for children, youth and adults', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should utilize the latest technology and methods for efficient construction of urban amenities like parks and gardens', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of urban amenities like parks and gardens is causing a strain on the city\'s infrastructure and budget.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should provide regular maintenance of urban amenities like parks and gardens.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should address the need for urban amenities in certain areas.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should construct urban amenities like parks and gardens to improve the quality of life for residents in the area.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The area is in dire need of more public toilets for the community to use.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources for the construction of public toilets.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('There are not enough public toilets for residents to use.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to requests for the construction of public toilets.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The lack of public toilets is causing a negative impact on the health and well-being of residents.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly educating residents on the benefits of public toilets.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The lack of public toilets is causing a decrease in property value in the area.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The area is in need of more public toilets for the community to use.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation is not properly enforcing regulations to ensure the construction of public toilets.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The lack of public toilets is causing a lack of sanitation in the area.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the lack of public toilets in the area.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The lack of public toilets is causing a public health emergency.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for the lack of public toilets in the area.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The area is in need of more public toilets to promote community hygiene', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The area is in need of more public toilets for the visitors and tourists', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation should utilize the latest technology and methods for efficient construction of public toilets', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The lack of public toilets is causing a strain on the city\'s infrastructure and budget.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation should provide regular maintenance of public toilets.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation should address the need for public toilets in certain areas.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation should construct public toilets to improve the quality of life for residents in the area.', 0, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation should clean the sewers to improve the quality of life for residents in the area and prevent mosquito breeding.', 0, 1, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The dirty sewers are causing mosquito breeding that leading to the spread of mosquito-borne diseases', 0, 1, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The broken roads in the area are causing damage to the water supply pipes, leading to water leaks and disruptions in service.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the damage to water supply pipes caused by broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing a negative impact on the water supply for residents and businesses in the area.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources for the repair of water supply pipes damaged by broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing an increase in water wastage and leading to higher water bills for residents', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should address the need for water supply pipe repairs in certain areas.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should prioritize repairing water supply pipes damaged by broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing water supply pipe corrosion, leading to expensive repairs and replacements.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should construct water supply pipes in a way that protects them from damage caused by broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing water contamination due to damaged pipes.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing a public health emergency due to lack of clean water.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for the negative effects of broken roads on the water supply.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing water supply disruptions during crucial times such as during fires or medical emergencies.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing water contamination due to damaged pipes.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to complaints about broken water supply due to broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing a strain on the city\'s infrastructure and budget.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should provide regular maintenance of water supply pipes to prevent damage from broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads in the area are causing damage to the electric supply infrastructure, leading to power outages and disruptions in service.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the damage to electric supply infrastructure caused by broken roads.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing a negative impact on the electric supply for residents and businesses in the area.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources for the repair of electric supply infrastructure damaged by broken roads.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing an increase in electric wastage and leading to higher bills for residents.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing a public health emergency due to lack of electricity.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing electric supply disruptions during crucial times such as during natural disasters.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing electric supply contamination due to damaged infrastructure.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to complaints about broken electric supply due to broken roads.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should provide regular maintenance of electric supply infrastructure to prevent damage from broken roads.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should prioritize repairing electric supply infrastructure damaged by broken roads.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing electric supply infrastructure corrosion, leading to expensive repairs and replacements.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should construct electric supply infrastructure in a way that protects them from damage caused by broken roads.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Increased traffic and congestion due to road closures and diversions during construction.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inconvenience and disruption to daily life due to road construction noise, dust, and other hazards.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Delays in park development and completion leading to frustration and disappointment among residents.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Neglect of maintenance and upkeep of parks and green spaces after completion.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inadequate facilities and amenities in parks, leading to decreased enjoyment and use.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Poorly designed parks with limited accessibility and usability.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Inadequate safety measures in parks, leading to increased risk of accidents and injuries.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Limited park programming and events, reducing opportunities for community engagement and enjoyment.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Presence of unpleasant odors and sights due to improper disposal of dead animals in parks.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Increased health hazards due to the potential for diseases and parasites from dead animals.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Poor park maintenance and cleanliness, leading to unkempt grounds and unpleasant sights.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('Delays in removal and disposal of dead animals, leading to frustration and dissatisfaction among residents.', 0, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Unresponsive sewer department, leading to unaddressed complaints and maintenance issues related to dead animal removal.', 0, 1, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('Presence of unpleasant odors and sights due to improper disposal of dead animals with regular waste.', 0, 0, 0, 0, 1, 0, 0, 1, 0, 'test@mail.com'),
('Unresponsive waste management department, leading to unaddressed complaints and maintenance issues related to dead animal removal.', 0, 0, 0, 0, 1, 0, 0, 1, 0, 'test@mail.com'),
('Contamination of water sources due to improper disposal of dead animals near waterways.', 0, 0, 0, 1, 0, 0, 0, 1, 0, 'test@mail.com'),
('Increased health hazards due to the potential for diseases and parasites from dead animals entering water sources.', 0, 0, 0, 1, 0, 0, 0, 1, 0, 'test@mail.com'),
('Negative impact on the local environment and wildlife due to improper disposal of dead animals near waterways.', 0, 0, 0, 1, 0, 0, 0, 1, 0, 'test@mail.com'),
('Poorly trained water management workers, leading to inadequate and inefficient removal of dead animals.', 0, 0, 0, 1, 0, 0, 0, 1, 0, 'test@mail.com'),
('Unresponsive water management department, leading to unaddressed complaints and maintenance issues related to dead animal removal.', 0, 0, 0, 1, 0, 0, 0, 1, 0, 'test@mail.com'),
('Infestations of pests such as rodents, insects, and birds, causing health and safety concerns.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Inadequate pest control measures, leading to persistent pest problems', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Ineffective use of pesticides and other pest control methods, leading to continued pest problems.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Lack of resources and investment in modern pest control technology, leading to subpar services.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Health and safety hazards posed by pest control methods, such as exposure to toxic chemicals.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Inadequate monitoring and follow-up by the pest control department, leading to ineffective pest control.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('Infestations of pests due to accumulation of waste and poor waste management practices.', 0, 0, 0, 0, 1, 0, 0, 0, 1, 'test@mail.com'),
('Ineffective waste management practices, leading to continued pest problems and unhealthy environments.', 0, 0, 0, 0, 1, 0, 0, 0, 1, 'test@mail.com'),
('Lack of resources and investment in modern waste management and pest control technology, leading to subpar services.', 0, 0, 0, 0, 1, 0, 0, 0, 1, 'test@mail.com'),
('Inadequate monitoring and follow-up by the waste management and pest control departments, leading to ineffective waste management and pest control.', 0, 0, 0, 0, 1, 0, 0, 0, 1, 'test@mail.com'),
('The broken roads in the area are causing damage to the water supply pipes, leading to water leaks and disruptions in service.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not taking responsibility for the damage to water supply pipes caused by broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing unclean water to be delivered to residents and businesses in the area.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources for the repair of water supply pipes damaged by broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing a negative impact on the water supply for residents and businesses in the area.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing a public health emergency due to contaminated water.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing adequate compensation for the negative effects of broken roads on the water supply.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The area is in need of more resources to repair and maintain the water supply pipes.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing water supply disruptions during crucial times such as during fires or medical emergencies.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing water contamination due to damaged pipes.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to complaints about unclean water due to broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should provide regular maintenance of water supply pipes to prevent damage from broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should address the need for water supply pipe repairs in certain areas.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing water supply pipe corrosion, leading to expensive repairs and replacements.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The broken roads are causing a lack of sanitation in the area the municipal corporation should construct water supply pipes in a way that protects them from damage caused by broken roads.', 1, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not effectively managing waste in the area, leading to contaminated water supplies.', 0, 0, 0, 1, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste in the area is causing harm to local wildlife and ecosystems.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The waste in the area is causing harm to local wildlife and ecosystems.', 0, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not providing enough resources for the proper disposal of waste and dead animals.', 0, 0, 0, 0, 1, 0, 0, 1, 0, 'test@mail.com'),
('The waste is causing a public health emergency due to contaminated water supplies.', 0, 0, 0, 1, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should enforce strict penalties for improper waste disposal to protect the water supply.', 0, 0, 0, 1, 1, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should utilize the latest technology and methods for efficient waste management and proper disposal.', 0, 0, 0, 1, 1, 0, 0, 0, 0, 'test@mail.com'),
('The lack of proper maintenance of the sewage system is causing serious problems due to electrical issues.', 0, 1, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electrical issues in the sewage system are causing health and safety concerns for residents and businesses in the area.', 0, 1, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electrical issues in the sewage system are causing water supply disruptions and reducing the quality of life for residents and businesses in the area.', 0, 1, 1, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The electrical issues are causing sewage backups and overflows, leading to health and safety hazards.', 0, 1, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation is not responding quickly enough to complaints about the electrical issues in the sewage system.', 0, 1, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of proper maintenance of the sewage system is causing serious problems due to road conditions.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The poor maintenance of the roads is causing serious problems due to the sewage system.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The sewage system is hindering access to the roads, causing problems with maintenance and repair.', 0, 1, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The sewage system is causing health and safety concerns for drivers, pedestrians, and residents in the area.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The area is in need of more resources for proper maintenance and repair of the roads.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The sewage system is causing damage to the road infrastructure, leading to expensive repairs and replacements.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The sewage system is creating dangerous road conditions and causing accidents.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The sewage system is causing a lack of road safety in the area.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The improper disposal of dead animals is causing serious road maintenance issues', 1, 0, 0, 0, 0, 0, 0, 1, 0, 'test@mail.com'),
('The dead animals on the roads are causing a health and safety concern for drivers, pedestrians, and residents.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The dead animals on the roads are causing a negative impact on the environment and local wildlife.', 1, 1, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The lack of proper pest control is causing serious road maintenance issues.', 1, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The pests on the roads are hindering the repair and maintenance process.', 1, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation is not providing adequate resources for proper pest control.', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The pests on the roads are causing a health and safety concern for drivers, pedestrians, and residents.', 1, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The pests on the roads are causing a negative impact on the environment and local wildlife.', 1, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation should prioritize proper pest control to protect the health and safety of drivers, pedestrians, and residents.', 1, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The municipal corporation should work to improve the pest control system and road infrastructure to promote the overall well-being and safety of the community.', 1, 0, 0, 0, 0, 0, 0, 0, 1, 'test@mail.com'),
('The lack of proper pest control and public toilet facilities is causing serious road maintenance issues.', 1, 0, 0, 0, 0, 0, 1, 0, 0, 'test@mail.com'),
('The pests and lack of toilets on the roads are hindering the repair and maintenance process.', 1, 0, 0, 0, 0, 0, 1, 0, 1, 'test@mail.com'),
('The municipal corporation is not providing adequate resources for proper pest control and public toilet facilities.', 0, 0, 0, 0, 0, 0, 1, 0, 1, 'test@mail.com'),
('The municipal corporation should prioritize proper pest control and the construction of public toilets to protect the health and safety of drivers, pedestrians, and residents.', 1, 0, 0, 0, 0, 0, 1, 0, 1, 'test@mail.com'),
('The numerous holes in the roads are causing safety hazards for drivers and pedestrians.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The holes which are fill with garbage in the roads are causing damage to vehicles and making it difficult to drive on them.', 1, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('there is not properly maintaining the roads and fixing the holes in a timely manner and due to that electricity is also cut in our area .', 1, 0, 1, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The holes in the roads need to be addressed immediately as they are a constant inconvenience and danger to those who use them.', 1, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('The presence of waste and pests in the water supply is causing a major health concern for the community.', 0, 0, 0, 1, 1, 0, 0, 0, 1, 'test@mail.com'),
('In our area The municipal corporation is not effectively managing the waste and pests in the water supply.', 0, 0, 0, 1, 1, 0, 0, 0, 1, 'test@mail.com'),
('The unclean water is affecting the daily lives and well-being of the community.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The municipal corporation should prioritize the cleanliness of the water supply to protect the health of the community.', 0, 0, 0, 1, 0, 0, 0, 0, 0, 'test@mail.com'),
('The unclean water due to waste and pests needs to be addressed immediately to prevent any further health hazards for the community.', 0, 0, 0, 1, 0, 0, 0, 0, 1, 'test@mail.com'),
('The construction of public toilets is affecting the quality of the water supply in the area.', 0, 0, 0, 1, 0, 0, 1, 0, 0, 'test@mail.com'),
('The unclean water due to the construction of public toilets needs to be addressed immediately to prevent any further health hazards for the community.', 0, 0, 0, 1, 0, 0, 1, 0, 0, 'test@mail.com'),
('The waste in the area is causing hindrances in the construction of public toilets.', 0, 0, 0, 0, 1, 0, 1, 0, 0, 'test@mail.com'),
('The municipal corporation is not effectively managing the waste in the area, leading to problems in the construction process of road and public toilets.', 1, 0, 0, 0, 1, 0, 1, 0, 0, 'test@mail.com'),
('Disposing used sanitary pads in the drains or roadsides from where animals can accidentally eat.', 1, 0, 0, 0, 1, 0, 0, 0, 0, 'test@mail.com'),
('', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com'),
('', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'test@mail.com');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`UID` int(11) NOT NULL,
`Email` varchar(64) NOT NULL,
`Pass` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`UID`, `Email`, `Pass`) VALUES
(1, 'test@mail.com', '900150983cd24fb0d6963f7d28e17f72'),
(2, 'test2@mail.com', '47bce5c74f589f4867dbd57e9ca9f808'),
(3, 'mail@mail', '47bce5c74f589f4867dbd57e9ca9f808'),
(4, 'rahul@mail.com', '47bce5c74f589f4867dbd57e9ca9f808'),
(5, 'shivam@mail.com', '47bce5c74f589f4867dbd57e9ca9f808'),
(6, 'sanchi@mail.com', '47bce5c74f589f4867dbd57e9ca9f808'),
(7, 'new@mail', '47bce5c74f589f4867dbd57e9ca9f808'),
(13, 'rahul@mail', '47bce5c74f589f4867dbd57e9ca9f808'),
(16, 'shweta@mail.com', '47bce5c74f589f4867dbd57e9ca9f808'),
(17, 'raul@mail.com', '47bce5c74f589f4867dbd57e9ca9f808'),
(18, 'more@mail', '47bce5c74f589f4867dbd57e9ca9f808');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `complaints`
--
ALTER TABLE `complaints`
ADD PRIMARY KEY (`ID`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`UID`),
ADD UNIQUE KEY `Email` (`Email`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `UID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;