-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathloo3968.sql
More file actions
executable file
·101 lines (101 loc) · 10.4 KB
/
loo3968.sql
File metadata and controls
executable file
·101 lines (101 loc) · 10.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
INSERT INTO loos(id,address,latitude,longitude,timing,type,urinal_count,handicap_support,paid,avg_rating,picture_url,created_at,updated_at)
VALUES (0,'Defence Colony',28.6122,77.132,'1000-2200','Western',7,0,0,3.6285,'',1454959793984,1458222679182),
(1,'Model Town',28.6381,77.1106,'1200-2400','Indian',5,0,0,2.35636,'',1459502210401,1454385005981),
(2,'Connaught Place',28.5727,77.3594,'0700-1800','Indian/Western',5,0,0,3.47871,'',1457794263699,1459915549542),
(3,'Vasant Vihar',28.5663,77.1677,'0500-1900','Indian',5,0,1,3.01605,'',1457245052577,1455199868486),
(4,'Snehahdara',28.5261,77.3066,'0700-1800','Indian',7,0,0,1.83926,'',1460338098652,1454303227586),
(5,'Vivek Vihar',28.6156,77.1274,'1200-2400','Indian/Western',1,1,1,3.3697,'',1460051161547,1457220600320),
(6,'Darya Ganj',28.5462,77.0323,'1200-2400','Western',7,0,0,3.83053,'',1457814716535,1455103823011),
(7,'Darya Ganj',28.5104,77.2586,'1200-2400','Indian/Western',1,0,0,1.56691,'',1456653377939,1458395939748),
(8,'Parliament Street',28.4991,77.2349,'1000-2200','Indian',3,0,1,3.84518,'',1458038084701,1453675143900),
(9,'Vasant Vihar',28.5794,77.0486,'0500-1900','Indian',3,1,0,1.10218,'',1459753801373,1453666953695),
(10,'Punjabi Bagh',28.642,77.1055,'0500-1900','Western',7,0,0,3.85409,'',1458599690154,1456872992003),
(11,'Punjabi Bagh',28.5489,77.1823,'1200-2400','Western',5,0,1,1.09168,'',1453274756490,1459719693473),
(12,'Connaught Place',28.664,77.2063,'1200-2400','Indian',1,1,0,4.81225,'',1452827392116,1454460768430),
(13,'Vasant Vihar',28.5929,77.0368,'1200-2400','Western',2,1,0,1.90933,'',1455533994857,1457025209520),
(14,'Kotwali',28.5612,77.0929,'0500-1900','Western',3,0,0,2.49236,'',1454219117011,1458139298697),
(15,'Saraswati Vihar',28.6473,77.1748,'1000-2200','Indian/Western',6,1,0,2.5219,'',1456353417658,1455109537068),
(16,'Najafgarh',28.5345,77.2707,'1200-2400','Western',5,0,0,3.79574,'',1458705511496,1456531025351),
(17,'Vivek Vihar',28.5509,77.0426,'1000-2200','Western',4,1,1,2.17667,'',1459430660523,1458312837388),
(18,'Rajouri Garden',28.5979,77.1935,'1200-2400','Indian',5,1,0,3.13178,'',1457569341673,1457736287473),
(19,'Darya Ganj',28.6497,77.0861,'0500-1900','Indian',1,0,1,2.98553,'',1453684440629,1453174502113),
(20,'Najafgarh',28.5941,77.3949,'1000-2200','Indian/Western',3,1,0,3.3105,'',1458888100346,1457788108339),
(21,'Sadar Bazar',28.6142,77.2907,'0500-1900','Indian/Western',2,0,1,1.88845,'',1452760995646,1455736542042),
(22,'Pahar Ganj',28.5012,77.3741,'0500-1900','Indian',7,0,0,2.05081,'',1458449128666,1458737198219),
(23,'Defence Colony',28.6437,77.3076,'1200-2400','Western',2,1,0,4.98926,'',1453159113722,1455252581217),
(24,'Kotwali',28.6211,77.1526,'1200-2400','Indian',4,1,1,4.19138,'',1453711664236,1456924601988),
(25,'Defence Colony',28.5053,77.2078,'0700-1800','Indian',1,0,0,2.82977,'',1453299898639,1459168323785),
(26,'Parliament Street',28.5523,77.1694,'1000-2200','Indian',7,0,1,3.47249,'',1455355009132,1454404173928),
(27,'Connaught Place',28.5559,77.3948,'0500-1900','Indian/Western',1,0,0,4.29527,'',1456390156113,1455534629094),
(28,'Kotwali',28.6351,77.1665,'1200-2400','Indian',4,1,1,4.8667,'',1453146625347,1453176789777),
(29,'Vasundhara Enclave',28.5953,77.3637,'0500-1900','Indian/Western',3,0,0,4.04563,'',1457579221521,1455207707268),
(30,'Punjabi Bagh',28.593,77.3157,'1000-2200','Indian',5,1,0,3.34126,'',1453055674722,1460345920697),
(31,'Vasant Vihar',28.6332,77.0579,'0500-1900','Western',4,1,0,2.11954,'',1460131176534,1459816376599),
(32,'Narela',28.621,77.103,'1200-2400','Indian/Western',6,0,1,4.17148,'',1454374400043,1455292563581),
(33,'Seema Puri',28.6369,77.1726,'1200-2400','Indian/Western',7,0,1,1.18323,'',1457745605233,1454658129185),
(34,'Kotwali',28.5721,77.3165,'0700-1800','Western',2,1,1,1.95315,'',1454287513571,1458586190451),
(35,'Sabzi Mandi',28.5986,77.1793,'1200-2400','Western',1,0,1,1.27479,'',1453103756755,1453665436185),
(36,'Connaught Place',28.5739,77.2468,'0700-1800','Western',3,1,0,4.82458,'',1457483573082,1456505401723),
(37,'Seelampur',28.5844,77.3372,'1000-2200','Western',5,0,0,2.34269,'',1456637952779,1458470484058),
(38,'Sabzi Mandi',28.6132,77.2714,'1000-2200','Indian',1,1,1,3.56124,'',1459261991192,1457972419895),
(39,'Snehahdara',28.6501,77.1102,'1200-2400','Western',6,0,0,3.88412,'',1454709096019,1456682301927),
(40,'Sabzi Mandi',28.607,77.2549,'0700-1800','Indian',6,1,1,4.69445,'',1456599833943,1453718740433),
(41,'Karol Bagh',28.4857,77.3764,'0500-1900','Indian/Western',2,0,1,3.0589,'',1460309614877,1456140286720),
(42,'Sabzi Mandi',28.5826,77.2666,'1200-2400','Western',3,0,1,3.08307,'',1459020824853,1458804634738),
(43,'Rajouri Garden',28.5791,77.13,'0500-1900','Indian',6,1,1,2.28861,'',1457434420084,1458519813091),
(44,'Hauz Khas',28.5901,77.1134,'0700-1800','Indian',3,1,1,4.97961,'',1455949758460,1453828703899),
(45,'Connaught Place',28.4922,77.2184,'1200-2400','Indian',4,0,0,1.04297,'',1454024263226,1453980075821),
(46,'Preet Vihar',28.5586,77.0442,'1000-2200','Western',7,1,1,2.03531,'',1453774649338,1455668829120),
(47,'Chanakya Puri',28.5537,77.1104,'1200-2400','Indian',2,0,0,4.77795,'',1454911794045,1459066030253),
(48,'Punjabi Bagh',28.5714,77.1016,'0700-1800','Indian',6,0,0,2.42778,'',1453646934201,1456001774545),
(49,'Darya Ganj',28.6134,77.2111,'1000-2200','Indian/Western',3,0,0,1.30567,'',1458628667521,1456037817017),
(50,'Saraswati Vihar',28.4833,77.2668,'0700-1800','Western',2,0,1,1.81899,'',1454792332890,1460340283031),
(51,'Seema Puri',28.6017,77.0594,'0500-1900','Indian',6,0,0,3.76351,'',1455390117169,1458319205428),
(52,'Pahar Ganj',28.5044,77.3782,'0500-1900','Western',5,1,0,2.71941,'',1457296498203,1458861936396),
(53,'Preet Vihar',28.5054,77.1107,'0700-1800','Indian/Western',7,1,1,4.28892,'',1455674672911,1453488402415),
(54,'Parliament Street',28.5849,77.0782,'1200-2400','Indian/Western',4,0,0,4.4818,'',1457883049179,1456281393953),
(55,'Kalkaji',28.6363,77.4028,'0500-1900','Indian',4,1,1,4.02341,'',1455362716131,1454103619083),
(56,'Sadar Bazar',28.5356,77.2023,'0700-1800','Western',1,0,1,2.13944,'',1453972578958,1457570209669),
(57,'Sabzi Mandi',28.6221,77.2212,'1200-2400','Indian',4,1,0,3.62923,'',1453693865650,1453370546816),
(58,'Snehahdara',28.6648,77.2917,'1200-2400','Western',7,1,0,1.08142,'',1458613195551,1453475141737),
(59,'Sabzi Mandi',28.5144,77.0623,'1200-2400','Indian/Western',3,1,0,2.64263,'',1452858026442,1455439056894),
(60,'Connaught Place',28.5609,77.2078,'0700-1800','Indian/Western',3,0,1,2.66472,'',1452658859103,1454052483934),
(61,'Darya Ganj',28.4853,77.0338,'1000-2200','Indian',1,1,1,2.18046,'',1455272897248,1455825568952),
(62,'Gandhi Nagar',28.5915,77.0946,'0500-1900','Western',4,1,0,1.77688,'',1456837360099,1457275601850),
(63,'Saraswati Vihar',28.6507,77.2083,'0500-1900','Indian',1,1,0,2.27299,'',1453717272215,1453214060261),
(64,'Darya Ganj',28.4955,77.1291,'0500-1900','Western',5,0,0,3.58821,'',1454755318532,1458175158821),
(65,'Parliament Street',28.5,77.3452,'1000-2200','Indian',7,0,1,4.91858,'',1453612117736,1459561011440),
(66,'Vasundhara Enclave',28.6617,77.2073,'0700-1800','Western',3,0,1,3.76962,'',1458258105446,1455613661507),
(67,'Pahar Ganj',28.599,77.1225,'0700-1800','Western',6,1,0,1.33851,'',1453984831556,1454184458679),
(68,'Seema Puri',28.5341,77.2066,'0700-1800','Indian/Western',5,1,1,2.80963,'',1457826033056,1454305102998),
(69,'Defence Colony',28.618,77.1947,'0700-1800','Western',3,0,1,1.35353,'',1454976588647,1455633920836),
(70,'Pahar Ganj',28.5852,77.3839,'1200-2400','Western',6,0,1,3.22187,'',1454281512204,1453419858944),
(71,'Chanakya Puri',28.6546,77.2633,'1200-2400','Western',5,0,1,2.81231,'',1459929663535,1454473581283),
(72,'Hauz Khas',28.5777,77.2727,'0500-1900','Indian',7,0,0,2.91363,'',1456677791426,1458919437728),
(73,'Kalkaji',28.5752,77.2116,'1200-2400','Indian',6,1,1,4.07553,'',1457281764349,1456107184007),
(74,'Hauz Khas',28.6605,77.1868,'1200-2400','Western',3,0,0,3.27729,'',1457010014531,1455112595670),
(75,'Snehahdara',28.4929,77.1714,'1200-2400','Western',1,1,0,1.18604,'',1456344012391,1457304143835),
(76,'Connaught Place',28.5588,77.3387,'1200-2400','Western',7,1,0,3.16254,'',1455604865389,1458515077291),
(77,'Model Town',28.4827,77.1057,'1200-2400','Indian/Western',4,0,1,4.05747,'',1457569767745,1453500606323),
(78,'Patel Nagar',28.5009,77.1409,'0500-1900','Indian/Western',3,1,1,4.30735,'',1457762900134,1458313025789),
(79,'Darya Ganj',28.6515,77.2971,'0500-1900','Western',3,1,0,1.26344,'',1454278559046,1459148567282),
(80,'Seelampur',28.6544,77.2902,'0500-1900','Indian/Western',3,1,0,4.52794,'',1459643984734,1460255115544),
(81,'Hauz Khas',28.6429,77.2868,'1200-2400','Western',5,1,0,1.34169,'',1457641042674,1454796606757),
(82,'Vasundhara Enclave',28.5769,77.1729,'1000-2200','Indian',7,0,1,4.50902,'',1452727526240,1454559049635),
(83,'Snehahdara',28.4935,77.1953,'0500-1900','Indian',4,1,1,4.39561,'',1453699454784,1453030947687),
(84,'Delhi Cantt',28.6615,77.1052,'0500-1900','Western',1,0,1,4.88659,'',1456694812809,1460303376138),
(85,'Kotwali',28.5039,77.1588,'0700-1800','Indian/Western',2,0,0,3.7336,'',1456376907375,1458159785416),
(86,'Seema Puri',28.6124,77.0596,'0700-1800','Indian/Western',2,0,0,4.97986,'',1457897706451,1455076124366),
(87,'Vivek Vihar',28.538,77.1668,'0700-1800','Indian/Western',6,0,1,3.78842,'',1457229775611,1453470418882),
(88,'Patel Nagar',28.5474,77.2094,'0700-1800','Western',1,1,1,3.50533,'',1453568996324,1455224669540),
(89,'Model Town',28.5328,77.2667,'1200-2400','Indian/Western',1,1,1,4.12778,'',1458454277482,1456453798032),
(90,'Sabzi Mandi',28.6676,77.3931,'1200-2400','Indian/Western',5,1,0,3.39448,'',1456591099770,1458461415298),
(91,'Seelampur',28.5265,77.3941,'0500-1900','Indian/Western',4,1,0,4.50572,'',1458195145120,1460046239327),
(92,'Rajouri Garden',28.5045,77.1738,'1200-2400','Western',2,0,1,3.94003,'',1459505535337,1456732140819),
(93,'Sadar Bazar',28.5008,77.0417,'0700-1800','Western',5,1,1,1.09326,'',1453098643672,1455916989931),
(94,'Hauz Khas',28.6452,77.3682,'1200-2400','Western',1,1,0,2.4069,'',1457260172044,1458014744868),
(95,'Sadar Bazar',28.5476,77.2416,'0500-1900','Western',7,0,1,1.79116,'',1455645684593,1452776085577),
(96,'Preet Vihar',28.6337,77.1798,'1000-2200','Western',4,1,0,2.47343,'',1454530338134,1459308779917),
(97,'Model Town',28.6054,77.325,'0500-1900','Western',7,1,1,1.34046,'',1455234581548,1457113942771),
(98,'Seema Puri',28.6544,77.1212,'0700-1800','Indian',3,0,1,4.90551,'',1452888212962,1460016817182),
(99,'Seelampur',28.5534,77.1867,'1000-2200','Indian',6,1,0,1.33705,'',1459726567068,1453972619849)