(982,'866562069471854','Javier Ruiz','3106975812','2024-07-25 11:31:39','2024-07-25 11:31:39','[BLOB]',0,1,11,11001,'Carrera 22 81-95','1'),(983,'866562069471854','Jorge Arroyave','31522664693','2024-07-25 14:31:27','2024-07-25 14:31:27','[BLOB]',0,1,11,11001,'Carrera 15 91-30','1'),(984,'866562069471854','Jorge Arroyave','3152664693','2024-07-25 14:48:02','2024-07-25 14:48:02','[BLOB]',0,1,11,11001,'Carrera 15 91-30','1'),(985,'866562069471854','Jorge Arroyave','3152264693','2024-07-25 16:46:29','2024-07-25 16:46:29','[BLOB]',1,1,11,11001,'Carrera 15 91-30','1'),(986,'866562069471805','Jorge Arroyave','3002094436','2024-07-31 15:15:12','2024-07-31 15:15:12','[BLOB]',0,1,25,54321,'Carrera 15 91-30','1'),(987,'866562069471805','Jorge Arroyave','3152264693','2024-07-31 15:16:10','2024-07-31 15:16:10','[BLOB]',0,1,25,54321,'Carrera 15 91-30','1'),(988,'866562069471805','Jorge Arroyave','3002094436','2024-08-02 16:08:26','2024-08-02 16:08:26','[BLOB]',1,1,11,11001,'Carrera 22 81-95','1');

--
-- Table structure for table `alarm_types`
--

CREATE TABLE `alarm_types` (
  `alarm_type_id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(45) DEFAULT NULL,
  `active` int DEFAULT '1',
  PRIMARY KEY (`alarm_type_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `alarm_types`
--

INSERT INTO `alarm_types` VALUES (1,'Alarma real',1),(2,'Prueba',1),(3,'Evento sin novedad',1);

--
-- Table structure for table `alarms`
--

CREATE TABLE `alarms` (
  `imei` varchar(20) NOT NULL COMMENT 'IMEI',
  `alarm_mode_id` int DEFAULT NULL COMMENT 'Tipo',
  `client_id` int NOT NULL COMMENT 'Cliente',
  `name` varchar(50) DEFAULT NULL COMMENT 'Nombre',
  `address` varchar(100) DEFAULT NULL COMMENT 'Dirección',
  `district_id` int DEFAULT NULL COMMENT 'Localidad / Comuna',
  `neighborhood` varchar(150) DEFAULT NULL COMMENT 'Barrio',
  `city_id` varchar(6) NOT NULL COMMENT 'Ciudad',
  `latitude` decimal(18,15) DEFAULT NULL COMMENT 'Latitud',
  `longitude` decimal(18,15) DEFAULT NULL COMMENT 'Longitud',
  `mobile_operator_id` int NOT NULL COMMENT 'Operador',
  `phone` varchar(20) NOT NULL COMMENT 'Celular panel de alarma',
  `active` int NOT NULL DEFAULT '1' COMMENT 'Activo',
  `status` tinyint DEFAULT NULL COMMENT 'Estado',
  `created` datetime DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '1',
  `date` datetime DEFAULT NULL COMMENT 'Fecha actualización',
  PRIMARY KEY (`imei`) USING BTREE,
  KEY `city_id` (`city_id`) USING BTREE,
  KEY `district_id` (`district_id`) USING BTREE,
  KEY `mobile_operator_id` (`mobile_operator_id`) USING BTREE,
  KEY `client_id` (`client_id`) USING BTREE,
  KEY `alarm_ibfk_5_idx` (`user_id`) USING BTREE,
  KEY `alarm_mode_id` (`alarm_mode_id`) USING BTREE,
  CONSTRAINT `alarm_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `cities` (`city_id`),
  CONSTRAINT `alarm_ibfk_2` FOREIGN KEY (`district_id`) REFERENCES `districts` (`district_id`),
  CONSTRAINT `alarm_ibfk_3` FOREIGN KEY (`mobile_operator_id`) REFERENCES `mobile_operators` (`mobile_operator_id`),
  CONSTRAINT `alarm_ibfk_4` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`),
  CONSTRAINT `alarm_ibfk_5` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
  CONSTRAINT `alarm_ibfk_6` FOREIGN KEY (`alarm_mode_id`) REFERENCES `alarm_modes` (`alarm_mode_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `alarms`
--

INSERT INTO `alarms` VALUES ('10',1,30,'Institución Educativa los Quindos','una direccion \'\'',NULL,'','63001',4.523219000000000,-75.704264000000000,1,'3173472214',0,2,NULL,1,'2023-10-23 11:42:45'),('1087222443156',NULL,13,'Alarma Cali','CALLE 11 CRA 8 Y 9',NULL,'CIUDADELA','763041',3.417540000000000,-74.123548000000000,1,'3504328972',1,2,'2023-11-01 10:19:43',1,'2024-05-15 15:14:25'),('11',NULL,30,'Intitucion Educativa Ciudadela del Sur','',NULL,NULL,'63001',4.516178000000000,-75.712315000000000,1,'317876345',1,NULL,NULL,1,'2022-07-02 13:14:24'),('12',NULL,30,'Colegio Rufino José Cuervo',NULL,NULL,NULL,'63001',4.523349000000000,-75.694240000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('12343567890987',NULL,30,'Botón de Pánico Samper','',NULL,'','11001',0.000000000000000,0.000000000000000,1,'3187034855',0,2,'2022-03-08 16:19:07',52,'2023-10-23 14:31:01'),('1234567810',NULL,37,'Alarma Prueba 10','carrera 10',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318210',1,2,'2023-07-19 16:50:32',1,'2023-10-23 14:31:01'),('1234567811',NULL,37,'Alarma Actualizada 11','carrera nueva 11',38,'Barrio xyz','76318',4.734711000000000,-74.061911000000000,1,'3504318211',1,2,'2023-07-19 17:01:30',1,'2023-10-23 14:31:01'),('1234567812',NULL,37,'Alarma Prueba 12','carrera 12',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318222',1,2,'2023-07-19 17:03:18',1,'2023-10-23 14:31:01'),('1234567813',NULL,37,'Alarma Prueba 13','carrera 13',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318223',1,2,'2023-07-19 17:07:39',1,'2023-10-23 14:31:01'),('123456789',NULL,37,'Alarma Prueba ','carrera 15',NULL,NULL,'76001',NULL,-74.061962000000000,1,'3212253758',1,2,'2023-07-18 15:01:54',1,'2023-10-23 11:42:45'),('1234567892',NULL,37,'Alarma Prueba','carrera 15',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3212253759',1,2,'2023-07-19 12:20:19',1,'2023-10-23 14:31:01'),('1234567893',NULL,37,'Alarma Prueba','carrera 15',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3212253757',1,2,'2023-07-19 12:25:49',1,'2023-10-23 14:31:01'),('1234567894',NULL,37,'Alarma Prueba 4','carrera 14',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318212',1,2,'2023-07-19 12:34:48',1,'2023-10-23 14:31:01'),('1234567895',NULL,37,'Alarma Prueba 5','carrera 15',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318215',1,2,'2023-07-19 16:03:02',1,'2023-10-23 14:31:01'),('1234567896',NULL,37,'Alarma Prueba 6','carrera 15',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318216',1,2,'2023-07-19 16:33:41',1,'2023-10-23 14:31:01'),('1234567897',NULL,37,'Alarma Prueba 7','carrera 17',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318217',1,2,'2023-07-19 16:40:15',1,'2023-10-23 14:31:01'),('1234567898',NULL,37,'Alarma Prueba 8','carrera 18',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318218',1,2,'2023-07-19 16:43:20',1,'2023-10-23 14:31:01'),('1234567899',NULL,37,'Alarma Prueba 9','carrera 19',40,'Barrio xyz','76001',NULL,-74.061962000000000,1,'3504318219',1,2,'2023-07-19 16:47:06',1,'2023-10-23 14:31:01'),('13',NULL,30,'Colegio Teresita Montes',NULL,NULL,NULL,'63001',4.518467000000000,-75.693638000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('14',NULL,30,'Colegio Bosques de Pinares',NULL,NULL,NULL,'63001',4.513201000000000,-75.697538000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('15',NULL,30,'Instituto Técnico Industrial',NULL,NULL,NULL,'63001',4.503433000000000,-75.697349000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('16',NULL,30,'Colegio Rufino Jose Cuervo Centro',NULL,NULL,NULL,'63001',4.539898000000000,-75.680990000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('17',NULL,30,'Escuela Normal Superior Del Quindío',NULL,NULL,NULL,'63001',4.543778000000000,-75.685213000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('18',NULL,30,'CASD',NULL,NULL,NULL,'63001',4.546049000000000,-75.677170000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('2',NULL,30,'EL RANCHO',NULL,NULL,NULL,'76001',3.459932000000000,-76.534037000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('3',NULL,30,'HELADERIA LA SUIZA','',NULL,'','05615',6.156901000000000,-75.370238000000000,1,'3173472214',0,NULL,NULL,2,'2022-07-02 13:14:35'),('3002094436',NULL,14,'Pánico Jorge Arroyave','',NULL,'','101001',0.000000000000000,0.000000000000000,1,'3002094436',0,2,'2022-03-09 07:33:36',60,'2023-10-23 14:31:01'),('3131010A1A',NULL,21,'TOSTAO','Tv. 94 #80A-29',10,'Quirigua','11001',4.706765000000000,-74.107087000000000,1,'0',0,2,'2022-05-20 09:34:56',1,'2023-10-23 14:31:01'),('3131011612',NULL,17,'Alarma 1','',NULL,'','11001',4.679270400000000,-74.164930200000000,1,'0',0,2,'2022-04-19 15:40:13',1,'2023-10-23 14:31:01'),('31310f0f05',NULL,14,'Alarma 2','0',NULL,'','101001',0.000000000000000,0.000000000000000,1,'0',0,2,'2022-04-28 15:17:14',1,'2023-10-23 14:31:01'),('351374435263961',NULL,30,'Alarma Cali','Av. Colombia #2-84',NULL,'','76001',3.450236000000000,76.539378000000000,1,'3225408866',0,2,'2021-11-17 11:28:08',1,'2023-10-23 14:31:01'),('353507103',NULL,1,'Modulo Apertura C Recuetno','Carrera 7 11-33',17,'Centro','11001',3.417540000000000,-76.528072000000000,1,'0',1,2,'2022-04-27 14:59:40',1,'2024-05-14 10:29:45'),('4',NULL,30,'FERRETERIA DEL ORIENTE',NULL,NULL,NULL,'05615',6.155273000000000,-75.369865000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('5',NULL,30,'ELECTRICOS Y MAS',NULL,NULL,NULL,'05615',6.155458000000000,-75.371507000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('6',NULL,30,'440 ORIENTAL',NULL,NULL,NULL,'11001',4.668230000000000,-74.054249000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('7',NULL,30,'Quinto Bar',NULL,NULL,NULL,'11001',4.668753000000000,-74.054310000000000,1,'3173472214',0,NULL,NULL,2,'2022-07-02 13:14:35'),('8',NULL,30,'BAR ROCKET',NULL,NULL,NULL,'11001',4.667276000000000,-74.054701000000000,1,'3173472214',1,NULL,NULL,1,'2022-07-02 13:14:35'),('860037054798039',NULL,13,'FC CIUDADELA - P.A 23','CALLE 11 CRA 8 Y 9',273,'Balboa','763041',4.334655800000000,-75.824240700000000,1,'9103369144',0,2,'2021-11-30 20:24:51',1,'2024-02-22 09:59:00'),('860037054798047',NULL,13,'FC PUERTO NUEVO - P.A 43','CALLE 9 No. 19-41',284,'PUERTO NUEVO','76275',3.546111000000000,-76.398333000000000,1,'9103369164',1,2,'2021-11-24 11:45:11',1,'2024-05-28 16:22:00'),('860037054798054',NULL,13,'FC COLOMBIA - P.A 57','CALLE 35 NO 29-68',267,'COLOMBIA','7635',3.532185100000000,-76.299298800000000,1,'9103369178',1,2,'2021-11-25 14:10:13',1,'2023-10-23 14:31:01'),('860037054798070',NULL,13,'FC POPULAR  - P.A 103','CALL 18 17-49',290,'POPULAR','76834',4.090939500000000,-76.192795700000000,1,'9103374186',1,2,'2021-11-28 07:33:34',1,'2023-10-23 14:31:01'),('860037054798088',NULL,13,'FC VICTORIA - P.A 86 ','CARRERA 30 29-45',290,'VICTORIA','76834',4.081453600000000,-76.194333200000000,1,'9103374169',1,2,'2021-11-27 10:39:12',1,'2023-10-23 14:31:01'),('860037054798096',NULL,13,'FC CALLE DE LOS ARGOS - P.A 27','CARRERA 8 A 23-24',281,'CALLE DE LOS ARGOS','76147',4.747009100000000,-75.925314000000000,1,'9103369148',1,2,'2021-11-29 18:42:58',1,'2023-10-23 14:31:01'),('860037054798138',NULL,13,'FC ALBERGUE - P.A 14','Cl. 1 Sur #5-14',273,'ALBERGUE','763041',3.891257500000000,-76.292573000000000,1,'9103369136',0,2,'2021-11-30 15:02:42',49,'2023-10-23 14:31:01'),('860037054798153',NULL,13,'FC SANTA MONICA P.A 41','CARRERA 14 C#18-13',281,'SANTA MONICA','76147',4.742459300000000,-75.922266100000000,1,'9103369162',1,2,'2021-11-30 18:44:15',1,'2023-10-23 14:31:01'),('860037054798179',NULL,30,'LABORATORIO','La Esmeralda #1183',NULL,'','7635',3.320729000000000,-76.224408000000000,1,'3135697673',0,2,'2021-09-06 18:00:50',1,'2023-10-23 14:31:01'),('860037054798187',NULL,13,'FC LAS DELICIAS  - P.A 72','EN EL INTERIOR DE LA GALERIA ',267,'LAS DELICIAS','7635',3.524692500000000,-76.297167100000000,1,'9103369193',1,2,'2021-11-26 07:55:41',1,'2023-10-23 14:31:01'),('860037054802385',NULL,13,'FC PARQUES DE ITALIA - P.A 69','CALLE 33C NO 7-71',267,'PARQUES DE ITALIA','7635',3.529340700000000,-76.281276700000000,1,'9103369185',0,2,'2021-11-25 15:21:38',1,'2023-10-23 14:31:01'),('860037054802450',NULL,13,'FC BOSQUES VERSALLES - P.A 63 molinos cien','CALLE 59 # 42A-14',267,'BOSQUES VERSALLES','7635',3.538421800000000,-76.295212500000000,1,'9103369184',1,2,'2021-11-26 18:26:01',1,'2023-10-23 14:31:01'),('860037054802500',NULL,13,'FC RUBEN CRUZ','CARRERA 14 # 23 11 ',290,'RUBEN CRUZ','76834',4.091754800000000,-76.203831300000000,1,'9103374167',1,2,'2021-11-28 07:52:33',1,'2023-10-23 14:31:01'),('860037054802685',NULL,13,'FC PANAMERICANO - P.A 87','CARRERA 37 28-28',290,'PANAMERICANO','76834',4.081929500000000,-76.189311100000000,1,'9103374170',0,2,'2021-11-27 10:48:13',1,'2023-10-23 14:31:01'),('860037054803896',NULL,13,'FC CENTRO  - P.A 64','CALLE 31 CARRERA 25',267,'CENTRO','7635',3.527587200000000,-76.296569000000000,1,'9103369185',1,2,'2021-11-26 18:39:18',1,'2023-10-23 14:31:01'),('860037054804191',NULL,13,'FC GUTIERREZ Y ARANGO - P.A 22','CARRERA 15 CALL 12 Y 13',277,'GUTIERREZ Y ARANGO','76122',4.334528400000000,-75.829174000000000,1,'9103369143',0,2,'2021-11-30 20:22:03',1,'2023-10-23 14:31:01'),('860037054804217',NULL,13,'FC ALAMEDA - P.A 39','CALLE 2 ESTE NO. 2 A -51',281,'ALAMEDA','76147',4.752793100000000,-75.898903700000000,1,'9103369160',1,2,'2021-11-30 17:39:15',1,'2023-10-23 14:31:01'),('860037054804233',NULL,13,'FC BOSQUES VERSALLES - P.A 73','Calle 43 No 25-88 ',267,'BOSQUES VERSALLES','7635',3.538421800000000,-76.295212500000000,1,'9103369194',1,2,'2021-11-26 08:20:26',1,'2023-10-23 14:31:01'),('860037054804241',NULL,13,'FC TOMAS URIBE URIBE - P.A 99','CALLE 21 25-28',290,'TOMAS URIBE URIBE','76834',4.089392800000000,-76.196314700000000,1,'9103374183',1,2,'2021-11-28 14:07:46',1,'2023-10-23 14:31:01'),('860037054804258',NULL,13,'FC JORGE ELIECER GAITAN - P.A 37','CARRERA 6 CALLE 7',281,'JORGE GAITAN','76147',4.748501600000000,-75.907791900000000,1,'9103369158',1,2,'2021-11-30 18:47:16',1,'2023-10-23 14:31:01'),('860037054804266',NULL,13,'FC FUEN MAYOR - P.A 13','CALLE 17 CON 8',273,'FUEN MAYOR','763041',3.907035900000000,-76.293815400000000,1,'9103369134',1,2,'2021-11-30 15:48:54',1,'2023-10-23 14:31:01'),('860037054804282',NULL,13,'FC EL CARMEN','CARRERA 5158 Y 59',288,'EL CARMEN','76736',4.271409000000000,-75.934346100000000,1,'9103374161',1,2,'2021-11-26 14:06:54',1,'2023-10-23 14:31:01'),('860037054805230',NULL,13,'FC DEPARTAMENTAL - P.A 61','CRA 32 # 52-25',267,'DEPARTAMENTAL','7635',3.545961100000000,-76.300383100000000,1,'9103369182',1,2,'2021-11-26 18:07:44',1,'2023-10-23 14:31:01'),('860037054805255',NULL,13,'FC PRADOS DE JULIA  - P.A 7','Cl. 2 Sur #14-13',273,'PRADOS DE JULIA','763041',3.891316400000000,-76.304040000000000,1,'9103369128',1,2,'2021-11-30 11:45:30',1,'2023-10-23 14:31:01'),('860037054805289',NULL,13,'FC MI PUEBLITO - P.A 46','CARRERA 42 No 10-32',284,'MI PUEBLITO','76275',3.338611000000000,-76.248611000000000,1,'9103369167',1,2,'2021-11-25 09:06:23',1,'2023-10-23 14:31:01'),('860037054805305',NULL,13,'FC CENTRO  - P.A 66','CALLE  28 CARRERA 28',267,'CENTRO','7635',3.525263100000000,-76.299082600000000,1,'9103369187',1,2,'2021-11-25 09:55:11',1,'2023-10-23 14:31:01'),('860037054805412',NULL,13,'FC BOLIVAR - P.A 101','CALLE 26A 10-40',290,'BOLIVAR','76834',4.090548900000000,-76.209102000000000,1,'9103374184',1,2,'2021-11-27 11:02:10',1,'2023-10-23 14:31:01'),('860037054805420',NULL,13,'FC CENTRO P.A 42','CALLE 13 ENTRE 4 Y 5 ',281,'CENTRO','76147',4.750167600000000,-75.914828000000000,1,'9103369163',0,2,'2021-11-30 17:42:11',1,'2023-10-23 14:31:01'),('860037054805446',NULL,13,'FC EL RECREO - P.A 45','CARRERA 02 No. 12-67',284,'EL RECREO','76275',3.320833000000000,-76.222500000000000,1,'9103369166',1,2,'2021-11-25 14:18:58',1,'2023-10-23 14:31:01'),('860037054805461',NULL,13,'FC CENTRAL P.A 51','Cl. 5 #6-07',286,'CENTRAL','76318',3.763864100000000,-76.332145100000000,1,'9103369173',1,2,'2021-12-01 14:06:54',1,'2023-10-23 14:31:01'),('860037054805529',NULL,13,'FC POPULAR - P.A 95','CALLE 16 29-56',290,'POPULAR','76834',4.091348800000000,-76.190653600000000,1,'9103374178',1,2,'2021-11-28 07:40:55',1,'2023-10-23 14:31:01'),('860037054805552',NULL,13,'FC AURES - P.A 6','CALLE 1 DN 20 -04',273,'AURES','763041',3.895683300000000,-76.308837100000000,1,'9103369127',1,2,'2021-11-30 13:49:32',1,'2023-10-23 14:31:01'),('860037054805578',NULL,13,'FC SIRACUSA','Cl. 56 #45-09',288,'SIRACUSA','76736',4.268576500000000,-75.929760200000000,1,'9103374162',1,2,'2021-11-26 09:50:35',1,'2023-10-23 14:31:01'),('860037054805586',NULL,13,'FC PRADO - P.A 58','CALLE 35 NO 42-88',267,'PALMIRA','7635',3.532187800000000,-76.313493700000000,1,'9103369179',1,2,'2021-11-25 10:25:16',1,'2023-10-23 14:31:01'),('860037054805602',NULL,13,'FC BOSQUE - P.A 70','CALLE 33C NO 7-71',267,'BOSQUE','7635',3.529340700000000,-76.281276700000000,1,'9103369191',1,2,'2021-11-25 13:50:20',1,'2023-10-23 14:31:01'),('860037054805628',NULL,13,'FC EL CARMEN - P.A 24','CRA 16 Y 15 CON CALLES 7,8,9,10 Y 11',277,'EL CARMEN','76122',4.329174600000000,-75.829073000000000,1,'9103369145',0,2,'2021-11-30 20:27:06',1,'2023-10-23 14:31:01'),('860037054805669',NULL,13,'FC SAN VICENTE - P.A 77','CARRERA 5158 Y 59',288,'SAN VICENTE','76736',4.271409000000000,-75.934346100000000,1,'9103374160',1,2,'2021-11-26 14:25:45',1,'2023-10-23 14:31:01'),('860037054805685',NULL,13,'FC SANTA RITA  - P.A 9','CALLE 4 A SUR 17-37',273,'SANTA RITA','763041',3.890788500000000,-76.309159300000000,1,'9103369130',0,2,'2021-11-30 14:16:46',1,'2023-10-23 14:31:01'),('860037054805693',NULL,13,'FC LIMONAR - P.A 50','Cra. 23 #12-12',284,'LIMONAR','76275',3.328889000000000,-76.238056000000000,1,'9103369171',1,2,'2021-11-25 17:56:31',1,'2023-10-23 14:31:01'),('860037054805701',NULL,13,'FC LIMONAR - P.A 31','MAZ M CASA 19 NO. 15-45',281,'LIMONAR','76147',4.743345100000000,-75.925052200000000,1,'9103369152',1,2,'2021-11-30 18:36:14',1,'2023-10-23 14:31:01'),('860037054805727',NULL,13,'FC SANTA BARBARA - PA 1','CALLE 12 CON 15',273,'SANTA BARBARA','763041',3.901328600000000,-76.292220800000000,1,'9103369122',1,2,'2021-11-30 13:24:20',1,'2023-10-23 14:31:01'),('860037054805735',NULL,13,'FC REVOLUCION -  P.A 12','CALLE 12 1-17E',273,'REVOLUCION','763041',3.900049500000000,-76.289241900000000,1,'9103369133',1,2,'2021-11-30 15:37:04',1,'2023-10-23 14:31:01'),('860037054805743',NULL,13,'FC CENTRO - P.A 90','CALLE 24 N. 24-39',290,'CENTRO','76834',4.087021400000000,-76.197554600000000,1,'9103374173',1,2,'2021-11-28 14:22:00',1,'2023-10-23 14:31:01'),('860037054805750',NULL,13,'FC PALMAR - P.A 93','CALLE 4A 22B-04',290,'PALMAR','76834',4.101766700000000,-76.201246000000000,1,'9103374176',1,2,'2021-11-28 14:13:38',1,'2023-10-23 14:31:01'),('860037054805768',NULL,13,'FC LOPEZ  - P.A 47','CALLE 11 No. 15-69',284,'LOPEZ','76275',3.325278000000000,-76.232500000000000,1,'9103369168',1,2,'2021-11-25 08:53:55',1,'2023-10-23 14:31:01'),('860037054805776',NULL,13,'FC VILLANUEVA - P.A 82','CALLE 21 28A-41',290,'VILLANUEVA','76834',4.089329600000000,-76.193680100000000,1,'9103374165',1,2,'2021-11-28 07:58:07',1,'2023-10-23 14:31:01'),('860037054805792',NULL,13,'FC DIVINO NIÑO - P.A 20','CALLE 14 17-56',273,'DIVNO NIÑO','763041',3.907475700000000,-76.302720000000000,1,'9103369141',1,2,'2021-10-19 18:14:47',1,'2023-10-23 14:31:01'),('860037054805800',NULL,13,'FC REVOLUCION - P.A 10','CALLE 11 3-28',273,'REVOLUCION','763041',3.899486200000000,-76.290205800000000,1,'9103369131',1,2,'2021-11-30 16:26:03',1,'2023-10-23 14:31:01'),('860037054805834',NULL,13,'FC CIUDADELA COMFANDI - P.A 35','CALLE 2 A NO. 22 D-34',281,'CIUDADELA COMFANDI','76147',4.731646200000000,-75.905061000000000,1,'9103369156',1,2,'2021-11-30 19:08:19',1,'2023-10-23 14:31:01'),('860037054805867',NULL,13,'FC SAN CARLOS  - P.A 67','CALLE 15 CARRERA 26 Y 26A ',NULL,'','7635',3.513885900000000,-76.300121900000000,1,'9103369188',1,2,'2021-11-26 07:45:13',1,'2023-10-23 14:31:01'),('860037054805883',NULL,13,'FC POPULAR - P.A 94','CALLE 28 A 16-19',290,'','76834',4.092297300000000,-76.192710200000000,1,'9103374177',1,2,'2021-11-28 14:19:15',1,'2023-10-23 14:31:01'),('860037054805891',NULL,13,'FC MIRANDA','CARRERA 51 # 55-42',288,'MIRANDA','76736',4.264971900000000,-75.934752400000000,1,'9103374163',1,2,'2021-11-26 17:49:58',1,'2023-10-23 14:31:01'),('860037054805909',NULL,13,'FC VILLA LIDA','CONDOMINIO VILLA LINDA',288,'VILLA LIDA','76736',4.267399900000000,-75.928221900000000,1,'9103374164',1,2,'2021-11-26 17:07:04',1,'2023-10-23 14:31:01'),('860037054805917',NULL,13,'FC BALBOA - P.A 16','CALLE 23 CON 8',273,'BALBOA','763041',3.911103300000000,-76.291099300000000,1,'9103369136',1,2,'2021-10-19 18:08:27',1,'2023-10-23 14:31:01'),('860037054805925',NULL,13,'FC SANTA ISABEL  - P.A 100','CARRERA 20 A # 7- 42',290,'SANTA ISABEL','76834',4.098510500000000,-76.204425400000000,1,'9103374183',0,2,'2021-11-28 14:04:38',1,'2023-10-23 14:31:01'),('860037054805941',NULL,13,'FC ORTEZ - P.A 36','CALLE 1 E 2-09',281,'ORTEZ','76147',4.754646900000000,-75.898402100000000,1,'9103369157',1,2,'2021-11-29 17:38:44',1,'2023-10-23 14:31:01'),('860037054805966',NULL,13,'FC LA VEGA - P.A 60','CARRERA 28 CALLE 74 Y 74A',267,'LA VEGA','7635',3.558968300000000,-76.292247600000000,1,'9103369181',1,2,'2021-11-25 10:52:19',1,'2023-10-23 14:31:01'),('860037054805974',NULL,13,'FC CAMBULOS - P.A 40','CARRERA 1 NORTE CALLE 27 ESQUINA ',281,'CAMBULOS','76147',4.757953000000000,-75.929249200000000,1,'9103369161',1,2,'2021-11-30 18:40:04',1,'2023-10-23 14:31:01'),('860037054805982',NULL,13,'FC JORGE GAITAN - P.A 11','CALLE 26 12-19',273,'JORGE GAITAN','763041',3.766539900000000,-76.335376200000000,1,'9103369132',1,2,'2021-11-30 15:22:13',1,'2023-10-23 14:31:01'),('860037054805990',NULL,13,'FC URBANICACION CENTINELA - P.A 25','CARRERA 10 B ETAPA 1A',277,'URBANICACION CENTINELA','76122',4.339668800000000,-75.831564100000000,1,'9103369146',1,2,'2021-11-30 20:28:44',1,'2023-10-23 14:31:01'),('860037054806006',NULL,13,'FC BULEVAR - P.A 30','CARRERA 2 B NO. 28-02',281,'BULEVAR','76147',4.756223600000000,-75.929893600000000,1,'9103369151',1,2,'2021-11-29 17:25:29',1,'2023-10-23 14:31:01'),('860037054806014',NULL,13,'FC LAS AMERICAS','CALLE 15 CARRERA 26 Y 26A ',267,'LAS AMERICAS','7635',3.513885900000000,-76.300121900000000,1,'9103369189',1,2,'2021-11-25 15:55:43',1,'2023-10-23 14:31:01'),('860037054806022',NULL,13,'FC FATIMA  - P.A 105','CALLE 38 34-12',290,'FATIMA','76834',4.074793500000000,-76.193517900000000,1,'9103374188',1,2,'2021-11-28 07:01:40',1,'2023-10-23 14:31:01'),('860037054818118',NULL,13,'FC ASOAGRIN - P.A 94','CALLE 22F 2W-10',290,'ASOAGRIN','76834',4.087656100000000,-76.213441600000000,1,'9103374177',1,2,'2021-11-28 14:09:00',1,'2023-10-23 14:31:01'),('860037054818126',NULL,13,'FC BARRIO EL LLANO, PARQUE LINEAL - P.A 28','CARRERA 2 CON CALLE ',281,'BARRIO EL LLANO','76147',4.751742300000000,-75.919957000000000,1,'9103369149',1,2,'2021-11-30 19:05:12',1,'2023-10-23 14:31:01'),('860037054818142',NULL,13,'FC LOS ANGELES  - P.A 32','MAZ 6 CAS 15',281,'LOS ANGELES','76147',4.760952700000000,-75.936918000000000,1,'9103369153',1,2,'2021-11-30 17:36:34',1,'2023-10-23 14:31:01'),('860037054818159',NULL,13,'FC LA ESPERANZA - P.A 97','CALLE 26C N 12A-13',NULL,'','76834',4.087938100000000,-76.208740400000000,1,'9103374180',1,2,'2021-11-27 12:08:51',1,'2023-10-23 14:31:01'),('860037054818167',NULL,13,'FC OBRERO - P.A 71','CALLE 35 # CRA 26 Y 27',267,'OBRERO','7635',3.531779900000000,-76.296493600000000,1,'9103369192',1,2,'2021-11-25 16:11:54',1,'2023-10-23 14:31:01'),('860037054818324',NULL,13,'FC ARANJUEZ - P.A 52','CARRERA 2 D CALLE 2',286,'CENTRAL','76318',3.759763200000000,-76.328507400000000,1,'9103369172',1,2,'2021-12-01 21:09:55',1,'2023-10-23 14:31:01'),('860037054818332',NULL,13,'LA MERCE - P.A 3','CALLE 2 18 - 66',273,'LA MERCE','763041',3.897126700000000,-76.307275000000000,1,'9103369124',1,2,'2021-10-19 18:02:05',1,'2023-10-23 14:31:01'),('860037054818340',NULL,13,'FC VILLA COLOMBIA - P.A 88','CRA 22A 6A-05',290,'VILLA COLOMBIA','76834',4.099600000000000,-76.201604700000000,1,'9103374171',1,2,'2021-11-28 07:44:36',1,'2023-10-23 14:31:01'),('860037054818563',NULL,13,'FC PORTALES DEL SEMBRADOR - P.A 62','calle 24 con carrera 21',267,'PORTALES DEL SEMBRADOR','7635',3.518931600000000,-76.295945000000000,1,'9103369183',1,2,'2021-11-25 15:05:40',1,'2023-10-23 14:31:01'),('860037054818571',NULL,13,'FC BENEDICTA - P.A 65','CALLE 48 CARRERA 34 ',267,'BENEDICTA','7635',3.543199400000000,-76.302849700000000,1,'9103369186',1,2,'2021-11-25 09:34:59',1,'2023-10-23 14:31:01'),('860037054818589',NULL,13,'FC SANTA ISABEL - P.A 74','CALLE 45B CON CARRERA 30 ',267,'SANTA ISABEL','7635',3.541245400000000,-76.298363700000000,1,'9103369195',1,2,'2021-11-25 13:58:23',1,'2023-10-23 14:31:01'),('860037054818783',NULL,13,'FC LA GRACIELA - P.A 92','CARRERA  25A 13B-31',290,'LA GRACIELA','76834',4.095627100000000,-76.197615300000000,1,'9103374175',1,2,'2021-11-28 14:16:16',1,'2023-10-23 14:31:01'),('860037054818977',NULL,13,'FC NUEVO HORIZONTE - P.A 18','Cra 19a #24a-112',273,'NUEVO HORIZONTE','763041',3.916746600000000,-76.300194300000000,1,'9103369139',1,2,'2021-11-30 13:14:27',1,'2023-10-23 14:31:01'),('860037054819249',NULL,13,'FC JOSE OBRERO - P.A 4','CALLE 29 9-171',273,'JOSE OBRERO','763041',3.915352400000000,-76.290175600000000,1,'9103369125',1,2,'2021-12-01 11:53:10',1,'2023-10-23 14:31:01'),('860037054819686',NULL,13,'FC BOSQUES DE MARACAIBO - P.A 89','MAZ 55 CASA 11',290,'BOSQUES DE MARACAIBO','76834',4.103940100000000,-76.207353400000000,1,'9103374172',1,2,'2021-11-28 14:25:05',1,'2023-10-23 14:31:01'),('860037054819785',NULL,13,'FC LA PRADERA - P.A 26','CARRERA 20 A 5 A-26',281,'LA PRADERA','76147',4.733509300000000,-75.907834000000000,1,'9103369147',1,2,'2021-11-29 19:03:24',1,'2023-10-23 14:31:01'),('860037054820924',NULL,13,'FC CENTRAL - P.A 51','CALLE 5 CON 3 E',286,'ARANJUEZ','76318',3.763017000000000,-76.325144600000000,1,'9103369173',1,2,'2021-12-01 21:15:11',1,'2023-10-23 14:31:01'),('860037054821237',NULL,13,'FC LA ITALIA','CARRERA 10 CON 3',286,'LA ITALIA','76318',3.767155800000000,-76.327951800000000,1,'9103369177',1,2,'2021-12-01 11:32:53',1,'2023-10-23 14:31:01'),('860037054821260',NULL,13,'FC DIVINO NIÑO - P.A 5','Cra. 15 #2121',273,'DIVINO NIÑO','763041',3.912491500000000,-76.297689800000000,1,'9103369126',1,2,'2021-11-30 17:47:53',1,'2023-10-23 14:31:01'),('860037054821278',NULL,13,'FC VILLA HELENA - P.A 33','CALLE 18 ENTRE CARRERA 11 Y 13 NORTE',281,'VILLA HELENA','76147',4.759626600000000,-75.918801700000000,1,'9103369154',1,2,'2021-11-30 19:50:08',1,'2023-10-23 14:31:01'),('860037054821286',NULL,13,'FC SAN ANTONIO P.A-83','CALLE 11 28A 204',290,' SAN ANTONIO','76834',4.097997500000000,-76.193041400000000,1,'9103374166',0,2,'2021-11-28 07:54:25',49,'2023-10-23 14:31:01'),('860037054821302',NULL,13,'FC EL RECREO - P.A 59','CARRERA 24 CON CALLES 21 Y 22',267,'EL RECREO','7635',3.521815300000000,-76.294087600000000,1,'9103369180',1,2,'2021-11-25 11:15:06',1,'2023-10-23 14:31:01'),('860037054821336',NULL,13,'FC NUEVO FARFAN  - P.A 98','CARRERA 3AOESTE 22-34',290,'NUEVO FARFAN ','76834',4.093257400000000,-76.215129400000000,1,'9103374181',1,2,'2021-11-28 07:37:48',1,'2023-10-23 14:31:01'),('860037054821344',NULL,13,'FC LAS COLINAS - P.A 34','BLOQUES 10,11,12 #1-47',281,'COLINAS','76147',4.740365300000000,-75.903436300000000,1,'9103369155',1,2,'2021-11-30 19:56:11',1,'2023-10-23 14:31:01'),('860037054821351',NULL,13,'FC PALO BONITO - P.A 102','CARRERA 22 # 21 A 04',290,'PALO BONITO','76834',4.089418600000000,-76.199389500000000,1,'9103374185',1,2,'2021-11-28 07:35:41',1,'2023-10-23 14:31:01'),('860037054821369',NULL,13,'FC BARRIO EMAUS - P.A 29','CALLE 14 A_ CON CARERA 23B Y 23A',281,'BARRIO EMAUS','76147',4.730515400000000,-75.914646900000000,1,'9103369150',1,2,'2021-11-30 19:10:44',1,'2023-10-23 14:31:01'),('860037054821377',NULL,13,'FC GALERIA - P.A 38','CALLE 13 NO. 5 B -25',281,'GALERIA','76147',4.748085300000000,-75.914802500000000,1,'9103369159',1,2,'2021-11-29 17:09:22',1,'2023-10-23 14:31:01'),('860037054821393',NULL,13,'FC FATIMA 2 -  P.A 85','CALLE 40 # 35 - 62',290,'FATIMA','76834',4.073430000000000,-76.192087600000000,1,'9103374168',1,2,'2021-11-28 07:47:21',1,'2023-10-23 14:31:01'),('860037054821401',NULL,13,'FC WATERLO - P.A 49','CALLE  12B # 32A-31',284,'WATERLO','76275',3.332500000000000,-76.238056000000000,1,'9103369170',0,2,'2021-11-26 08:59:26',1,'2023-10-23 14:31:01'),('860037054821419',NULL,13,'FC LA CABAÑA - P.A 48','CARRERA 11 CON CALLE 5',284,'LA CABAÑA','76275',3.318611000000000,-76.231389000000000,1,'9103369169',1,2,'2021-11-24 14:33:07',1,'2023-10-23 14:31:01'),('860037054821815',NULL,13,'FC LA LUISA','CARRERA 3 D CALLE 4 SUR Y 6',286,'LA LUISA','76318',3.757097100000000,-76.331521900000000,1,'9103369176',0,2,'2021-12-01 11:28:36',1,'2023-10-23 14:31:01'),('860037054821864',NULL,13,'FC LAS NIEVES - P.A 106','CARRERA 7AOESTE 25-86',290,'LAS NIEVES','76834',4.089919500000000,-76.217907200000000,1,'9103374189',1,2,'2021-11-28 07:04:38',1,'2023-10-23 14:31:01'),('860037054821872',NULL,13,'FC SANTA BARBARA - P.A  8','Cra. 8 #11-15',273,'SANTA BARBARA','763041',3.901728700000000,-76.294976100000000,1,'9103369129',1,2,'2021-11-30 13:41:33',1,'2023-10-23 14:31:01'),('860037054821880',NULL,13,'FC VICTORIA - P.A 104','CARRERA 31 28A-23',290,'VICTORIA','76834',4.082673200000000,-76.194022800000000,1,'9103374187',1,2,'2021-11-28 07:30:20',1,'2023-10-23 14:31:01'),('860037054821898',NULL,13,'FC EL LIMONAR - P.A 54','CALLE 7 CARRERA 10 Y 11',286,'LIMONAR','76318',3.766539900000000,-76.335376200000000,1,'9103369175',1,2,'2021-12-01 21:19:11',1,'2023-10-23 14:31:01'),('860037054828290',NULL,13,'FC BARRIO LA VENTURA - P.A 15','Cra. 20 #19-20',273,'BARRIO LA VENTURA','763041',3.912528300000000,-76.302073600000000,1,'9103369135',1,2,'2021-10-19 18:05:46',1,'2023-10-23 14:31:01'),('860037054831012',NULL,13,'FC PABLO BLANCO - PA 2','CALLE 15 28 - 12',273,'PABLO BLANCO ','763041',3.912768400000000,-76.307170400000000,1,'9103369123',1,2,'2021-11-30 13:54:47',1,'2023-10-23 14:31:01'),('860037054831020',NULL,13,'FC BRISAS DEL NORTE - P.A 21','CARRE 7C 26C - 17',273,'BRISAS DEL NORTE','763041',3.913097200000000,-76.288752000000000,1,'9103369142',1,2,'2021-11-30 16:10:08',1,'2023-10-23 14:31:01'),('860037054831100',NULL,13,'FRENTE CÍVICO ALTO BONITO - P.A 19','CALLE 23 CON 8',273,'ALTO BONITO','763041',3.899971200000000,-76.286407800000000,1,'9103369140',1,2,'2021-10-19 18:11:52',1,'2023-10-23 14:31:01'),('860037054832945',NULL,13,'FC CONCORDIA','CALLE50 # 50-21',288,'CONCORDIA','76736',4.263918300000000,-75.934823200000000,1,'9103374158',1,2,'2021-11-26 09:28:40',1,'2023-10-23 14:31:01'),('860037054847301',NULL,13,'FC BARRIO ALTO DE LA CRUZ  - P.A 76','CARRERA 54 CON CALLE 53',288,'BARRIO ALTO DE LA CRUZ','76736',4.266667300000000,-75.937198300000000,1,'9103374159',1,2,'2021-11-26 15:00:49',1,'2023-10-23 14:31:01'),('860037054991683',NULL,13,'FC EL PARAISO - P.A 44','CALLE 06 CON CARRERA 17',284,'EL PARAISO','76275',3.321667000000000,-76.235556000000000,1,'9103369165',1,2,'2021-11-25 09:21:34',1,'2023-10-23 14:31:01'),('8600370554804220',NULL,13,'FC LOS ROSALES','CALLE 31 14-41',273,'ROSALES','763041',3.919057600000000,-76.294161400000000,1,'9103369138',1,2,'2021-11-30 15:54:05',1,'2023-10-23 14:31:01'),('860087054802518',NULL,13,'FC LIBRAIDA - P.A 109','CALLE 9 16-41',295,'LIBRAIDA','76895',4.396486900000000,-76.076579200000000,1,'9103375362',1,2,'2021-12-01 07:22:27',1,'2023-10-23 14:31:01'),('860087054805297',NULL,13,'LOS LAGOS','CALLE2 #2 8-59',295,'LOS LAGOS','76895',4.388350900000000,-76.075407800000000,1,'9103375361',1,2,'2021-12-01 07:17:56',1,'2023-10-23 14:31:01'),('860087054805818',NULL,13,'FC LAS MERCEDES','CRA 11 CLL 14',295,'LAS MERCEDES ','76895',4.398880700000000,-76.070142300000000,1,'9103374190',1,2,'2021-12-01 07:15:23',1,'2023-10-23 14:31:01'),('860087054805859',NULL,13,'FC BOLIVAR  - P.A 110','CARRERA 5 CALLE 16',295,'BOLIVAR','76895',4.396167600000000,-76.065083600000000,1,'9103375363',1,2,'2021-12-01 07:24:28',1,'2023-10-23 14:31:01'),('862261040781606',NULL,13,'FC POPULAR - PA.96','CARRERA 29 15-45',290,'POPULAR','76834',4.091748100000000,-76.190914100000000,1,'9103374179',1,2,'2021-11-27 13:45:33',1,'2023-10-23 14:31:01'),('862261044866148',NULL,1,'DEMO MALETA ALARMA','Carrera 22 81-95',12,'El Polo','11001',4.669547000000000,-76.516366000000000,2,'3154681648',0,2,NULL,1,'2024-02-14 15:22:00'),('862261048681709',NULL,20,'FRUVER MAXI','Cl. 22c #25-56',190,'VILLA GORGONIA','8807',3.396233000000000,-76.387047000000000,1,'3207708429',1,2,NULL,1,'2023-10-23 14:31:01'),('864180033524781',NULL,30,'Alexander Urresta','',37,NULL,'76001',NULL,NULL,1,'3122537634',0,2,NULL,1,'2023-10-23 14:31:01'),('864764035322961',NULL,30,'Galerías','',14,'','11001',4.640700700000000,-74.077080600000000,6,'3058927159',0,2,'2020-12-20 16:36:45',1,'2023-10-23 14:31:01'),('8648450044360061',NULL,1,'Alarma Smart','CALLE 64 H # 76 A - 30',12,'El Polo','11001',3.912528300000000,-75.481163000000000,1,'3054764027',1,2,'2024-05-09 10:45:44',1,'2024-07-30 16:45:00'),('865826047459765',NULL,20,'Alarma  Ciudadela La Victoria Villa Gorgona','Cra 15 No. 23-41 ',NULL,'','8807',3.404658000000000,-76.379435000000000,1,'3225408866',0,2,'2021-11-17 16:27:48',1,'2023-10-23 14:31:01'),('866562069367268',NULL,1,'DEMO SEGURIDAD No 7268','Parque La Flora',38,'La Flora','76001',3.484888000000000,-76.522780000000000,2,'3152684861',1,2,'2024-05-21 11:35:13',1,'2024-05-21 11:43:00'),('866562069367615',NULL,1,'DEMO_BOGOTÁ','Cra. 22 #81-85',NULL,'','76001',4.669533000000000,-74.061850000000000,3,'3178806134',0,2,'2022-07-19 17:04:00',52,'2023-10-23 14:31:01'),('866562069471573',NULL,45,'Alarma Villa Luz (1573)','Carrera 22 81-95',12,'El Polo','11001',4.669547000000000,-75.481163000000000,2,'3174663746',1,2,'2024-05-17 16:14:31',1,'2024-08-04 00:23:00'),('866562069471805',NULL,47,'Alarma Colaborativa (1805)','Vereda Portachuelo',NULL,'Potrerillo','633020',4.468962000000000,-75.789020000000000,2,'3142070774',1,2,'2024-06-14 10:39:53',1,'2024-08-14 14:45:01'),('866562069471854',NULL,47,'Alarma Portachuelo (1854)','Vereda Portachuelo',NULL,'Potrerillo','633020',4.468047000000000,-75.789139000000000,2,'3102393852',1,2,'2024-06-14 10:38:09',1,'2024-08-14 14:45:01'),('869153046565856',NULL,20,'FRUVER MAXI','Cl. 22c #25-56',190,'Villa Gorgonia','8807',3.396223000000000,-76.387037000000000,1,'3207698477',0,2,NULL,74,'2023-10-23 14:31:01'),('869153046565857',NULL,30,'PRUEBAS','Carrera 4 11-50',NULL,'','763041',4.675034000000000,-75.670938000000000,1,'3136846195',0,2,'2021-09-02 16:49:44',2,'2023-10-23 14:31:01'),('8888888888888',NULL,30,'Alarma desarrollo','',NULL,'','11001',NULL,NULL,1,'3173472214',0,2,'2021-01-27 08:44:26',2,'2023-10-23 14:31:01'),('896745231219283',NULL,30,'Alexander Urresta','Carrera 15 91-30',NULL,NULL,'76001',NULL,NULL,3,'3187034855',0,2,NULL,1,'2023-10-23 14:31:01'),('9',NULL,30,'NACIONAL JESÚS MARÍA OCAMPO',NULL,NULL,NULL,'63001',4.531450000000000,-75.689619000000000,1,'3173472214',0,NULL,NULL,1,'2022-07-02 13:14:35'),('EFFFFFFFFF',NULL,1,'Modulo Demo Viotec','Carrera 122 81-95',12,'El Polo','11001',4.671228000000000,-74.063302000000000,1,'3187034855',0,2,'2022-11-25 09:32:49',1,'2023-10-23 14:31:01'),('efffffffff_',NULL,17,'Alarma 2','',NULL,'','11001',4.679270400000000,-74.164930200000000,1,'0',0,2,'2022-04-19 16:18:03',1,'2023-10-23 14:31:01');

--
