text: INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (1,'Otranto','-8.01254','101.47364','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (2,'Eindhoven','-82.53901','58.8897','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (3,'Kington','-85.42797','-98.76966','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (4,'Burnaby','70.17813','-110.74923','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (5,'Neufeld an der Leitha','85.11896','24.85772','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (6,'Vlissegem','88.19821','-69.06611','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (7,'Rae Lakes','-63.20095','61.1085','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (8,'Groenlo','-5.37405','17.04679','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (9,'Chimay','79.30405','-176.68252','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (10,'Flensburg','39.43086','-159.32567','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (11,'Metairie','-13.65332','22.79881','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (12,'Douai','-61.00021','97.66153','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (13,'Nieuwmunster','72.37402','15.32714','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (14,'Bard','46.93642','-158.22005','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (15,'Aurora','19.70776','2.05766','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (16,'San José','81.72021','51.14731','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (17,'Sparwood','-62.983','23.74382','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (18,'Melton Mowbray','-25.80632','103.16614','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (19,'Lo Espejo','2.1794','-177.66821','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (20,'Mornimont','80.82503','103.68526','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (21,'Crystal Springs','41.72737','-83.2474','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (22,'Burlington','-66.3067','163.02016','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (23,'Delta','-37.16232','-71.46367','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (24,'Rulles','-33.8535','-161.99673','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (25,'Cantley','75.99199','-149.32813','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (26,'IJlst','70.12819','-93.92579','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (27,'Lo Barnechea','39.66963','-51.82759','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (28,'Gander','-46.11475','-1.92951','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (29,'Hamme','19.7478','-158.83103','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (30,'Çeşme','-30.81744','-179.65089','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (31,'Portland','-73.13176','87.01984','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (32,'San Miguel','12.38059','30.1672','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (33,'Chile Chico','88.45896','-43.96304','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (34,'Grand Rapids','-89.13838','-23.36735','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (35,'Stockerau','1.75609','-105.75547','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (36,'Sedgewick','22.72089','84.32409','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (37,'Lac La Biche County','44.45014','82.82596','Local','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (38,'Hohen Neuendorf','-68.17137','24.30755','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (39,'Colwood','-14.72763','-4.61474','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (40,'Cerami','-55.68531','-108.05845','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (41,'Río Bueno','81.33349','2.61612','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (42,'Delta','22.60227','-155.6747','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (43,'Vancouver','-28.6311','10.19218','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (44,'Pierrefonds','29.67279','-53.16384','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (45,'Virginia Beach','-81.05417','-14.37204','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (46,'Campina Grande','56.76999','-47.00322','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (47,'West Valley City','38.01728','-104.01312','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (48,'Palakkad','40.73784','77.55452','Regional','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (49,'Bloxham','-4.94403','128.83002','Tower','1');
  INSERT INTO locations (id,name,lat,lng,location_type,status) VALUES (50,'Grand-Leez','89.19081','135.91335','Regional','1');
  