-- MySQL dump 10.13  Distrib 5.5.50, for Linux (x86_64)
--
-- Host: localhost    Database: gdcrouter
-- ------------------------------------------------------
-- Server version	5.5.50

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8_unicode_ci NOT NULL,
  `queue` text COLLATE utf8_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
) ENGINE=InnoDB AUTO_INCREMENT=1829 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
INSERT INTO `jobs` VALUES (1647,'default','{\"displayName\":\"App\\\\Jobs\\\\SendAlert\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"timeout\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendAlert\",\"command\":\"O:18:\\\"App\\\\Jobs\\\\SendAlert\\\":5:{s:8:\\\"\\u0000*\\u0000round\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":2:{s:5:\\\"class\\\";s:9:\\\"App\\\\Round\\\";s:2:\\\"id\\\";i:92;}s:6:\\\"\\u0000*\\u0000job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";s:7:\\\"default\\\";s:5:\\\"delay\\\";N;}\"}}',255,NULL,1523493497,1523493437);
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=428 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (397,'2014_10_12_000000_create_users_table',1),(398,'2014_10_12_100000_create_password_resets_table',1),(399,'2017_08_21_091710_create_seg_points_table',1),(400,'2017_08_31_102213_create_settings_table',1),(401,'2017_09_05_092855_create_seg_routes_table',1),(402,'2017_09_05_143207_create_seg_point_seg_route_table',1),(403,'2017_09_13_091235_create_rounds_table',1),(404,'2017_09_13_091335_create_round_points_table',1),(405,'2017_11_13_080236_add_lat_lng_fields_to_seg_points_table',1),(406,'2017_11_16_184042_add_lat_lng_fields_to_round_points_table',1),(407,'2017_11_21_144354_add_is_admin_field_to_users_table',1),(408,'2018_01_03_112214_create_roles_table',1),(409,'2018_01_03_112419_create_permissions_table',1),(410,'2018_01_03_112559_create_role_user_table',1),(411,'2018_01_03_114713_create_permission_role_table',1),(412,'2018_01_03_153955_remove_is_admin_field_from_users_table',1),(413,'2018_02_19_114304_drop_default_tz_offset_column',1),(414,'2018_02_19_114553_add_default_tz_offset_column_to_settings_table',1),(415,'2018_02_19_115706_create_jobs_table',1),(416,'2018_02_19_124533_add_alert_email_to_settings_table',1),(417,'2018_02_19_131153_create_failed_jobs_table',1),(418,'2018_02_20_104034_add_alert_and_alert_count_fields_to_round_points_table',1),(419,'2018_02_20_180138_add_job_id_to_rounds_table',1),(420,'2018_02_22_115324_change_alert_email_field_in_table_settings',1),(421,'2018_02_22_124501_add_alert_email_field_to_seg_routes_table',1),(422,'2018_02_22_164824_change_tz_offset_field_in_seg_routes_table',1),(423,'2018_02_23_112801_create_seg_apps_table',1),(424,'2018_02_23_114255_add_seg_app_id',1),(425,'2018_02_23_115326_add_client_id',1),(426,'2018_02_26_183101_add_encrypted_password_field_to_users_table',1),(427,'2018_02_28_095218_add_comment_to_round_points_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permission_role`
--

DROP TABLE IF EXISTS `permission_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permission_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permission_role_permission_id_role_id_unique` (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permission_role`
--

LOCK TABLES `permission_role` WRITE;
/*!40000 ALTER TABLE `permission_role` DISABLE KEYS */;
INSERT INTO `permission_role` VALUES (1,1,1,NULL,NULL),(2,1,2,NULL,NULL),(3,1,3,NULL,NULL),(4,2,2,NULL,NULL),(5,2,3,NULL,NULL),(6,3,2,NULL,NULL),(7,4,2,NULL,NULL),(8,4,3,NULL,NULL),(9,5,2,NULL,NULL),(10,6,2,NULL,NULL),(11,6,3,NULL,NULL),(12,7,2,NULL,NULL),(13,8,2,NULL,NULL),(14,8,3,NULL,NULL),(15,9,2,NULL,NULL),(16,10,2,NULL,NULL),(17,11,2,NULL,NULL),(18,12,2,NULL,NULL),(19,13,2,NULL,NULL);
/*!40000 ALTER TABLE `permission_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'Acceder a la administracion','access-admin','2018-03-01 07:42:23','2018-03-01 07:42:23'),(2,'Ver los vigilantes','view-guards','2018-03-01 07:42:23','2018-03-01 07:42:23'),(3,'Modificar los vigilantes','modify-guards','2018-03-01 07:42:23','2018-03-01 07:42:23'),(4,'Ver los puntons','view-points','2018-03-01 07:42:23','2018-03-01 07:42:23'),(5,'Modificar los puntos','modify-points','2018-03-01 07:42:23','2018-03-01 07:42:23'),(6,'Ver las rutas','view-routes','2018-03-01 07:42:23','2018-03-01 07:42:23'),(7,'Modificar las rutas','modify-routes','2018-03-01 07:42:23','2018-03-01 07:42:23'),(8,'Ver los informes','view-rounds','2018-03-01 07:42:23','2018-03-01 07:42:23'),(9,'Modificar los informes','modify-rounds','2018-03-01 07:42:24','2018-03-01 07:42:24'),(10,'Ver las opciones','view-options','2018-03-01 07:42:24','2018-03-01 07:42:24'),(11,'Ver los clientes','view-clients','2018-03-01 07:42:24','2018-03-01 07:42:24'),(12,'Modificar los clientes','modify-clients','2018-03-01 07:42:24','2018-03-01 07:42:24'),(13,'Ver la app','view-app','2018-03-01 07:42:24','2018-03-01 07:42:24');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_user`
--

DROP TABLE IF EXISTS `role_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_user` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `role_user_user_id_role_id_unique` (`user_id`,`role_id`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_user`
--

LOCK TABLES `role_user` WRITE;
/*!40000 ALTER TABLE `role_user` DISABLE KEYS */;
INSERT INTO `role_user` VALUES (1,1,NULL,NULL),(2,2,NULL,NULL),(3,3,NULL,NULL),(15,4,NULL,NULL),(17,4,NULL,NULL),(18,4,NULL,NULL),(21,4,NULL,NULL),(22,4,NULL,NULL),(24,4,NULL,NULL),(25,4,NULL,NULL),(28,3,NULL,NULL),(29,3,NULL,NULL),(31,4,NULL,NULL),(32,3,NULL,NULL),(33,4,NULL,NULL),(34,3,NULL,NULL),(35,4,NULL,NULL),(36,4,NULL,NULL),(38,4,NULL,NULL),(39,3,NULL,NULL),(40,4,NULL,NULL),(41,4,NULL,NULL);
/*!40000 ALTER TABLE `role_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'Super admin','super-admin','2018-03-01 07:42:23','2018-03-01 07:42:23'),(2,'App admin','app-admin','2018-03-01 07:42:23','2018-03-01 07:42:23'),(3,'Cliente','cliente','2018-03-01 07:42:23','2018-03-01 07:42:23'),(4,'Vigilante','vigilante','2018-03-01 07:42:23','2018-03-01 07:42:23');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `round_points`
--

DROP TABLE IF EXISTS `round_points`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `round_points` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `round_id` int(10) unsigned DEFAULT NULL,
  `seg_point_id` int(10) unsigned DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT '0',
  `read_time` datetime DEFAULT NULL,
  `lat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lng` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alert` tinyint(1) NOT NULL DEFAULT '0',
  `alert_count` int(10) unsigned NOT NULL DEFAULT '0',
  `comment` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `round_points_round_id_foreign` (`round_id`),
  KEY `round_points_seg_point_id_foreign` (`seg_point_id`),
  CONSTRAINT `round_points_round_id_foreign` FOREIGN KEY (`round_id`) REFERENCES `rounds` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `round_points_seg_point_id_foreign` FOREIGN KEY (`seg_point_id`) REFERENCES `seg_points` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2638 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `round_points`
--

LOCK TABLES `round_points` WRITE;
/*!40000 ALTER TABLE `round_points` DISABLE KEYS */;
INSERT INTO `round_points` VALUES (757,188,6,1,'2018-04-27 15:32:33','0','0',0,0,NULL,'2018-04-27 18:30:34','2018-04-27 18:32:33'),(758,188,5,1,'2018-04-27 15:33:37','0','0',0,0,NULL,'2018-04-27 18:30:34','2018-04-27 18:33:37'),(1728,247,14,1,'2018-06-29 05:01:36','-34.7056136','-55.9470978',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:01:36'),(1729,247,15,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1730,247,14,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1731,247,15,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1732,247,14,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1733,247,15,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1734,247,14,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1735,247,15,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1736,247,14,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1737,247,15,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:33','2018-06-29 08:00:33'),(1738,247,15,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:34','2018-06-29 08:00:34'),(1739,247,14,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:34','2018-06-29 08:00:34'),(1740,247,14,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:34','2018-06-29 08:00:34'),(1741,247,15,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:34','2018-06-29 08:00:34'),(1742,247,15,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:34','2018-06-29 08:00:34'),(1743,247,14,0,NULL,'','',0,0,NULL,'2018-06-29 08:00:34','2018-06-29 08:00:34'),(1744,248,13,1,'2018-07-01 02:35:47','-34.7710927','-55.9864313',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 05:35:47'),(1745,248,12,1,'2018-07-01 02:41:33','-34.7709481','-55.9864843',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 05:41:33'),(1746,248,11,1,'2018-07-01 02:45:52','-34.755242','-55.9791554',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 05:45:52'),(1747,248,10,1,'2018-07-01 02:48:40','-34.7710927','-55.9864313',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 05:48:40'),(1748,248,13,1,'2018-07-01 03:35:12','-34.7710927','-55.9864313',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 06:35:12'),(1749,248,12,1,'2018-07-01 03:41:42','-34.7590841','-55.9806821',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 06:41:42'),(1750,248,11,1,'2018-07-01 03:43:52','-34.755242','-55.9791554',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 06:43:52'),(1751,248,10,1,'2018-07-01 03:47:09','-34.7378509','-55.9777976',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 06:47:09'),(1752,248,13,1,'2018-07-01 04:32:21','-34.7711886','-55.9865002',0,0,NULL,'2018-06-29 08:12:15','2018-07-01 07:32:21'),(1753,248,12,1,'2018-07-01 04:46:50','-34.7569755','-55.9787164',0,0,NULL,'2018-06-29 08:12:16','2018-07-01 07:46:50'),(1754,248,11,1,'2018-07-01 04:48:37','-34.7573676','-55.9798179',0,0,NULL,'2018-06-29 08:12:16','2018-07-01 07:48:37'),(1755,248,10,1,'2018-07-01 04:52:23','-34.7569755','-55.9787164',0,0,NULL,'2018-06-29 08:12:16','2018-07-01 07:52:23'),(1756,248,13,1,'2018-07-01 05:37:18','-34.7710635','-55.9865532',0,0,NULL,'2018-06-29 08:12:16','2018-07-01 08:37:18'),(1757,248,12,1,'2018-07-01 05:51:31','-34.7569755','-55.9787164',0,0,NULL,'2018-06-29 08:12:16','2018-07-01 08:51:31'),(1758,248,11,1,'2018-07-01 05:53:51','-34.7573023','-55.9796343',0,0,NULL,'2018-06-29 08:12:16','2018-07-01 08:53:51'),(1759,248,10,1,'2018-07-01 05:57:15','-34.7711886','-55.9865002',0,0,NULL,'2018-06-29 08:12:16','2018-07-01 08:57:15'),(1760,248,13,1,'2018-07-03 00:09:43','-34.7574102','-55.9782269',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 03:09:43'),(1761,248,11,1,'2018-07-03 00:21:30','-34.7554277','-55.9775048',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 03:21:30'),(1762,248,13,1,'2018-07-03 01:17:56','-34.7574942','-55.9782687',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 04:17:56'),(1763,248,12,1,'2018-07-03 01:23:51','-34.7573358','-55.9781268',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 04:23:51'),(1764,248,11,1,'2018-07-03 01:25:30','-34.7553251','-55.9775678',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 04:25:30'),(1765,248,10,1,'2018-07-03 01:30:02','-34.7566347','-55.9757234',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 04:30:02'),(1766,248,13,1,'2018-07-03 02:18:00','-34.7574042','-55.9781863',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 05:18:00'),(1767,248,12,1,'2018-07-03 02:23:12','-34.7578019','-55.9750896',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 05:23:12'),(1768,248,11,1,'2018-07-03 02:28:22','-34.7553251','-55.9775678',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 05:28:22'),(1769,248,10,1,'2018-07-03 02:31:37','-34.7566347','-55.9757234',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 05:31:37'),(1770,248,13,1,'2018-07-03 03:21:05','-34.7575488','-55.9784783',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 06:21:05'),(1771,248,12,1,'2018-07-03 03:28:25','-34.7578019','-55.9750896',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 06:28:25'),(1772,248,11,1,'2018-07-03 03:32:09','-34.7555947','-55.9756626',0,0,NULL,'2018-06-29 08:12:16','2018-07-03 06:32:09'),(1773,248,10,1,'2018-07-03 03:35:49','-34.7566347','-55.9757234',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 06:35:49'),(1774,248,13,1,'2018-07-03 04:21:14','-34.757455','-55.978218',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 07:21:14'),(1775,248,12,1,'2018-07-03 04:26:17','-34.7577756','-55.975011',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 07:26:17'),(1776,248,11,1,'2018-07-03 04:28:36','-34.7575419','-55.9746599',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 07:28:36'),(1777,248,10,1,'2018-07-03 05:00:18','-34.7566347','-55.9757234',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 08:00:18'),(1778,248,13,1,'2018-07-03 05:18:59','-34.7575333','-55.9783835',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 08:18:59'),(1779,248,12,1,'2018-07-03 05:28:18','-34.7562768','-55.9765555',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 08:28:18'),(1780,248,11,1,'2018-07-03 05:42:17','-34.7556047','-55.977517',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 08:42:17'),(1781,248,10,1,'2018-07-03 05:50:22','-34.7566347','-55.9757234',0,0,NULL,'2018-06-29 08:12:17','2018-07-03 08:50:22'),(1782,249,14,1,'2018-06-29 22:26:48','0','0',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:26:48'),(1783,249,15,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1784,249,14,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1785,249,15,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1786,249,14,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1787,249,15,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1788,249,14,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1789,249,15,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1790,249,14,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1791,249,15,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1792,249,15,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1793,249,14,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1794,249,14,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1795,249,15,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1796,249,15,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1797,249,14,0,NULL,'','',0,0,NULL,'2018-06-30 01:12:39','2018-06-30 01:12:39'),(1798,250,13,1,'2018-07-03 06:22:45','-34.7574252','-55.9782133',0,0,NULL,'2018-07-03 09:22:01','2018-07-03 09:22:45'),(1799,250,12,1,'2018-07-03 06:50:21','-34.7560905','-55.9778545',0,0,NULL,'2018-07-03 09:22:01','2018-07-03 09:50:21'),(1800,250,11,1,'2018-07-03 06:52:42','-34.7553251','-55.9775678',0,0,NULL,'2018-07-03 09:22:01','2018-07-03 09:52:42'),(1801,250,10,1,'2018-07-03 07:00:24','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:01','2018-07-03 10:00:24'),(1802,250,13,1,'2018-07-04 00:17:48','-34.7573753','-55.9782237',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 03:17:48'),(1803,250,12,1,'2018-07-04 00:28:42','-34.7578019','-55.9750896',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 03:28:42'),(1804,250,11,1,'2018-07-04 00:33:31','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 03:33:31'),(1805,250,10,1,'2018-07-04 00:37:21','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 03:37:21'),(1806,250,13,1,'2018-07-04 01:20:52','-34.7575342','-55.9783508',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 04:20:52'),(1807,250,12,1,'2018-07-04 01:31:19','-34.7573539','-55.9751423',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 04:31:19'),(1808,250,11,1,'2018-07-04 01:36:38','-34.7537141','-55.9756962',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 04:36:38'),(1809,250,10,1,'2018-07-04 01:45:27','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 04:45:27'),(1810,250,13,1,'2018-07-04 02:28:37','-34.7573185','-55.9781815',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 05:28:37'),(1811,250,12,1,'2018-07-04 02:39:11','0','0',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 05:39:11'),(1812,250,11,1,'2018-07-04 02:43:28','-34.7510225','-55.9662495',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 05:43:28'),(1813,250,10,1,'2018-07-04 02:50:30','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 05:50:30'),(1814,250,13,1,'2018-07-04 03:35:25','-34.7573099','-55.9781002',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 06:35:25'),(1815,250,11,1,'2018-07-04 03:48:29','-34.7575488','-55.9747513',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 06:48:29'),(1816,250,13,1,'2018-07-04 04:30:37','-34.7571651','-55.9779595',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 07:30:37'),(1817,250,12,1,'2018-07-04 04:37:55','-34.7578019','-55.9750896',0,0,NULL,'2018-07-03 09:22:01','2018-07-04 07:37:55'),(1818,250,11,1,'2018-07-04 04:44:28','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 07:44:28'),(1819,250,10,1,'2018-07-04 04:49:05','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 07:49:05'),(1820,250,13,1,'2018-07-04 05:35:57','-34.7573731','-55.9781137',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 08:35:57'),(1821,250,12,1,'2018-07-04 05:47:39','-34.7571957','-55.9757086',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 08:47:39'),(1822,250,11,1,'2018-07-04 05:50:47','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 08:50:47'),(1823,250,10,1,'2018-07-04 05:55:18','-34.7570756','-55.9753757',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 08:55:18'),(1824,250,13,1,'2018-07-04 06:35:20','-34.7575491','-55.9785008',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 09:35:20'),(1825,250,12,1,'2018-07-04 06:56:50','-34.7578019','-55.9750896',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 09:56:50'),(1826,250,11,1,'2018-07-04 06:58:30','-34.7572681','-55.9753795',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 09:58:30'),(1827,250,10,1,'2018-07-04 07:05:33','-34.7566347','-55.9757234',0,0,NULL,'2018-07-03 09:22:02','2018-07-04 10:05:33'),(1828,250,13,1,'2018-07-05 00:22:54','-34.7576929','-55.9782199',0,0,NULL,'2018-07-03 09:22:02','2018-07-05 03:22:54'),(1829,250,12,1,'2018-07-05 00:40:37','-34.7553251','-55.9775678',0,0,NULL,'2018-07-03 09:22:02','2018-07-05 03:40:37'),(1830,250,11,1,'2018-07-05 00:44:20','-34.7570659','-55.9752596',0,0,NULL,'2018-07-03 09:22:02','2018-07-05 03:44:20'),(1831,250,10,1,'2018-07-05 00:47:17','-34.7570659','-55.9752596',0,0,NULL,'2018-07-03 09:22:02','2018-07-05 03:47:17'),(1832,250,13,1,'2018-07-05 01:34:43','-34.757488','-55.9782646',0,0,NULL,'2018-07-03 09:22:02','2018-07-05 04:34:43'),(1833,250,12,1,'2018-07-05 01:50:21','-34.7577366','-55.9750348',0,0,NULL,'2018-07-03 09:22:02','2018-07-05 04:50:21'),(1834,250,11,1,'2018-07-05 01:55:52','-34.7553251','-55.9775678',0,0,NULL,'2018-07-03 09:22:02','2018-07-05 04:55:52'),(1835,250,10,1,'2018-07-05 02:01:18','-34.7566501','-55.9757343',0,0,NULL,'2018-07-03 09:22:02','2018-07-05 05:01:18'),(1836,251,13,1,'2018-07-05 02:47:28','-34.7573442','-55.978113',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 05:47:28'),(1837,251,12,1,'2018-07-05 02:59:11','-34.7564306','-55.977875',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 05:59:11'),(1838,251,11,1,'2018-07-05 03:02:32','-34.7568015','-55.9772695',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 06:02:32'),(1839,251,10,1,'2018-07-05 03:06:24','-34.7566733','-55.975713',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 06:06:24'),(1840,251,13,1,'2018-07-05 03:40:22','-34.7574814','-55.9783568',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 06:40:22'),(1841,251,12,1,'2018-07-05 03:48:08','-34.757635','-55.9752013',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 06:48:08'),(1842,251,11,1,'2018-07-05 03:52:52','-34.7574299','-55.9745418',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 06:52:52'),(1843,251,10,1,'2018-07-05 04:02:22','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 07:02:22'),(1844,251,13,1,'2018-07-05 04:49:36','-34.7573321','-55.9781345',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 07:49:36'),(1845,251,12,1,'2018-07-05 05:01:09','-34.7577963','-55.9750284',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 08:01:09'),(1846,251,11,1,'2018-07-05 05:15:38','0','0',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 08:15:38'),(1847,251,10,1,'2018-07-05 05:21:12','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 08:21:12'),(1848,251,13,1,'2018-07-05 06:25:38','-34.7574577','-55.9782644',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 09:25:38'),(1849,251,12,1,'2018-07-05 06:46:37','-34.7577679','-55.9750652',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 09:46:37'),(1850,251,11,1,'2018-07-05 06:48:36','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 09:48:36'),(1851,251,10,1,'2018-07-05 06:52:42','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:28','2018-07-05 09:52:42'),(1852,251,13,1,'2018-07-06 00:18:39','-34.7575865','-55.9784775',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 03:18:39'),(1853,251,11,1,'2018-07-06 00:30:41','0','0',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 03:30:41'),(1854,251,13,1,'2018-07-06 01:23:08','-34.7574923','-55.9782557',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 04:23:08'),(1855,251,12,1,'2018-07-06 01:30:44','-34.7573531','-55.976237',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 04:30:44'),(1856,251,11,1,'2018-07-06 01:34:44','0','0',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 04:34:44'),(1857,251,10,1,'2018-07-06 01:45:47','0','0',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 04:45:47'),(1858,251,13,1,'2018-07-06 02:30:21','-34.7573676','-55.978142',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 05:30:21'),(1859,251,12,1,'2018-07-06 02:38:22','-34.7571809','-55.9761403',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 05:38:22'),(1860,251,11,1,'2018-07-06 02:42:40','-34.7571712','-55.9753042',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 05:42:40'),(1861,251,10,1,'2018-07-06 02:46:01','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 05:46:01'),(1862,251,13,1,'2018-07-06 03:28:31','-34.757341','-55.9781213',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 06:28:31'),(1863,251,12,1,'2018-07-06 03:38:22','-34.7572615','-55.9780884',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 06:38:22'),(1864,251,11,1,'2018-07-06 03:42:24','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 06:42:24'),(1865,251,10,1,'2018-07-06 03:47:20','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 06:47:20'),(1866,251,13,1,'2018-07-06 04:30:25','-34.7573682','-55.9781731',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 07:30:25'),(1867,251,12,1,'2018-07-06 04:38:23','-34.7561674','-55.9778875',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 07:38:23'),(1868,251,11,1,'2018-07-06 04:42:19','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 07:42:19'),(1869,251,10,1,'2018-07-06 04:46:04','-34.7566501','-55.9757343',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 07:46:04'),(1870,251,13,1,'2018-07-06 05:35:50','0','0',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 08:35:50'),(1871,251,12,1,'2018-07-06 05:44:06','-34.7571566','-55.9781862',0,0,NULL,'2018-07-05 05:01:29','2018-07-06 08:44:06'),(1872,251,11,1,'2018-07-06 05:47:32','0','0',0,0,NULL,'2018-07-05 05:01:30','2018-07-06 08:47:32'),(1873,251,10,1,'2018-07-06 05:51:19','0','0',0,0,NULL,'2018-07-05 05:01:30','2018-07-06 08:51:19'),(1874,252,9,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:09','2018-07-06 02:20:09'),(1875,252,5,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:09','2018-07-06 02:20:09'),(1876,252,6,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:09','2018-07-06 02:20:09'),(1877,252,7,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1878,252,8,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1879,252,8,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1880,252,7,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1881,252,6,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1882,252,5,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1883,252,9,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1884,252,9,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1885,252,5,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1886,252,6,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1887,252,7,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1888,252,8,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1889,252,9,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1890,252,5,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1891,252,6,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1892,252,7,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1893,252,8,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1894,252,8,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1895,252,7,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:10','2018-07-06 02:20:10'),(1896,252,6,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:11','2018-07-06 02:20:11'),(1897,252,5,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:11','2018-07-06 02:20:11'),(1898,252,9,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:11','2018-07-06 02:20:11'),(1899,252,9,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:11','2018-07-06 02:20:11'),(1900,252,5,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:11','2018-07-06 02:20:11'),(1901,252,6,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:11','2018-07-06 02:20:11'),(1902,252,7,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:11','2018-07-06 02:20:11'),(1903,252,8,0,NULL,'','',0,0,NULL,'2018-07-06 02:20:11','2018-07-06 02:20:11'),(1904,253,13,1,'2018-07-07 23:05:20','-34.7575363','-55.9784072',0,0,NULL,'2018-07-06 11:05:23','2018-07-08 02:05:20'),(1905,253,12,1,'2018-07-07 23:09:30','-34.7570013','-55.9763413',0,0,NULL,'2018-07-06 11:05:23','2018-07-08 02:09:30'),(1906,253,11,1,'2018-07-07 23:13:22','-34.7573837','-55.9750234',0,0,NULL,'2018-07-06 11:05:23','2018-07-08 02:13:22'),(1907,253,10,1,'2018-07-07 23:16:57','-34.7570491','-55.9753952',0,0,NULL,'2018-07-06 11:05:23','2018-07-08 02:16:57'),(1908,253,13,1,'2018-07-08 00:59:11','-34.7575954','-55.9783958',0,0,NULL,'2018-07-06 11:05:23','2018-07-08 03:59:11'),(1909,253,12,1,'2018-07-08 01:03:31','-34.7574441','-55.9751365',0,0,NULL,'2018-07-06 11:05:23','2018-07-08 04:03:31'),(1910,253,11,1,'2018-07-08 01:06:37','-34.7577573','-55.9750543',0,0,NULL,'2018-07-06 11:05:23','2018-07-08 04:06:37'),(1911,253,10,1,'2018-07-08 01:10:22','-34.7566501','-55.9757343',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 04:10:22'),(1912,253,13,1,'2018-07-08 03:09:03','-34.7575272','-55.9783515',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 06:09:03'),(1913,253,12,1,'2018-07-08 03:13:51','-34.7573994','-55.9751472',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 06:13:51'),(1914,253,11,1,'2018-07-08 03:17:50','-34.7553916','-55.9735963',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 06:17:50'),(1915,253,10,1,'2018-07-08 03:25:22','-34.7566501','-55.9757343',0,0,'FUERTE LLUVIA Y VIENTO EN EL KM 30 DE LA RUTA 101 DIFICULTA HACER RECORRIDAS CADA 45 MINUTOS','2018-07-06 11:05:24','2018-07-08 06:25:22'),(1916,253,13,1,'2018-07-08 04:31:08','-34.7575419','-55.9782168',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 07:31:08'),(1917,253,12,1,'2018-07-08 04:38:04','-34.7561629','-55.9778378',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 07:38:04'),(1918,253,11,1,'2018-07-08 04:44:48','-34.7566501','-55.9757343',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 07:44:48'),(1919,253,10,1,'2018-07-08 05:08:28','-34.7566501','-55.9757343',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 08:08:28'),(1920,253,13,1,'2018-07-08 05:50:28','-34.7574898','-55.9782646',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 08:50:28'),(1921,253,11,1,'2018-07-08 05:56:02','-34.7553251','-55.9775678',0,0,NULL,'2018-07-06 11:05:24','2018-07-08 08:56:02'),(1922,253,13,1,'2018-07-10 00:14:40','-34.7575779','-55.974668',0,0,NULL,'2018-07-06 11:05:24','2018-07-10 03:14:40'),(1923,253,12,1,'2018-07-10 00:30:24','-34.7578871','-55.975329',0,0,NULL,'2018-07-06 11:05:24','2018-07-10 03:30:24'),(1924,253,11,1,'2018-07-10 00:34:25','-34.7566501','-55.9757343',0,0,NULL,'2018-07-06 11:05:24','2018-07-10 03:34:25'),(1925,253,10,1,'2018-07-10 00:39:19','-34.7566501','-55.9757343',0,0,NULL,'2018-07-06 11:05:24','2018-07-10 03:39:19'),(1926,253,13,1,'2018-07-10 01:33:51','-34.75761','-55.9785732',0,0,NULL,'2018-07-06 11:05:24','2018-07-10 04:33:51'),(1927,253,12,1,'2018-07-10 01:41:12','-34.7574217','-55.9752473',0,0,NULL,'2018-07-06 11:05:24','2018-07-10 04:41:12'),(1928,253,11,1,'2018-07-10 01:46:57','-34.7569643','-55.9753731',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 04:46:57'),(1929,253,10,1,'2018-07-10 01:50:34','0','0',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 04:50:34'),(1930,253,13,1,'2018-07-10 02:37:29','-34.7577927','-55.978425',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 05:37:29'),(1931,253,12,1,'2018-07-10 02:43:53','-34.7572811','-55.9752753',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 05:43:53'),(1932,253,11,1,'2018-07-10 02:47:29','0','0',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 05:47:29'),(1933,253,10,1,'2018-07-10 02:55:29','-34.7566501','-55.9757343',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 05:55:29'),(1934,253,13,1,'2018-07-10 03:42:23','-34.7574961','-55.9773476',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 06:42:23'),(1935,253,12,1,'2018-07-10 03:49:17','-34.7573531','-55.9782369',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 06:49:17'),(1936,253,11,1,'2018-07-10 03:53:23','-34.757232','-55.9751672',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 06:53:23'),(1937,253,10,1,'2018-07-10 03:58:38','-34.7566501','-55.9757343',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 06:58:38'),(1938,253,13,1,'2018-07-10 04:44:45','-34.7573619','-55.978139',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 07:44:45'),(1939,253,12,1,'2018-07-10 04:53:40','-34.7566691','-55.9757225',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 07:53:40'),(1940,253,11,1,'2018-07-10 04:55:49','-34.7570791','-55.9750675',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 07:55:49'),(1941,253,10,1,'2018-07-10 04:59:23','0','0',0,0,NULL,'2018-07-06 11:05:25','2018-07-10 07:59:23'),(1942,254,10,1,'2018-07-07 00:07:25','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 03:07:25'),(1943,254,11,1,'2018-07-07 00:16:14','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 03:16:14'),(1944,254,12,1,'2018-07-07 00:18:39','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 03:18:39'),(1945,254,13,1,'2018-07-07 00:23:31','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 03:23:31'),(1946,254,10,1,'2018-07-07 01:07:38','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 04:07:38'),(1947,254,11,1,'2018-07-07 01:13:15','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 04:13:15'),(1948,254,12,1,'2018-07-07 01:14:15','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 04:14:15'),(1949,254,13,1,'2018-07-07 01:19:11','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 04:19:11'),(1950,254,10,1,'2018-07-07 02:03:32','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 05:03:32'),(1951,254,11,1,'2018-07-07 02:09:22','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 05:09:22'),(1952,254,12,1,'2018-07-07 02:15:27','0','0',0,0,NULL,'2018-07-07 03:03:54','2018-07-07 05:15:27'),(1953,254,13,1,'2018-07-07 02:19:45','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 05:19:45'),(1954,254,10,1,'2018-07-07 03:06:56','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 06:06:56'),(1955,254,11,1,'2018-07-07 03:12:48','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 06:12:48'),(1956,254,12,1,'2018-07-07 03:15:23','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 06:15:23'),(1957,254,13,1,'2018-07-07 03:19:46','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 06:19:46'),(1958,254,10,1,'2018-07-07 04:08:32','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 07:08:32'),(1959,254,11,1,'2018-07-07 04:11:40','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 07:11:40'),(1960,254,12,1,'2018-07-07 04:14:08','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 07:14:08'),(1961,254,13,1,'2018-07-07 04:18:16','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 07:18:16'),(1962,254,10,1,'2018-07-07 05:09:43','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 08:09:43'),(1963,254,11,1,'2018-07-07 05:12:06','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 08:12:06'),(1964,254,12,1,'2018-07-07 05:15:20','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 08:15:20'),(1965,254,13,1,'2018-07-07 05:18:59','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 08:18:59'),(1966,254,10,1,'2018-07-07 06:08:19','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 09:08:19'),(1967,254,12,1,'2018-07-07 06:12:30','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 09:12:30'),(1968,254,10,1,'2018-07-07 06:58:11','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 09:58:11'),(1969,254,11,1,'2018-07-07 07:00:41','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 10:00:41'),(1970,254,12,1,'2018-07-07 07:02:08','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 10:02:08'),(1971,254,13,1,'2018-07-07 07:06:18','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-07 10:06:18'),(1972,254,10,1,'2018-07-08 04:54:23','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-08 07:54:23'),(1973,254,11,1,'2018-07-08 04:58:13','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-08 07:58:13'),(1974,254,12,1,'2018-07-08 04:59:56','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-08 07:59:56'),(1975,254,13,1,'2018-07-08 05:05:05','0','0',0,0,NULL,'2018-07-07 03:03:55','2018-07-08 08:05:05'),(1976,255,10,1,'2018-07-07 08:11:50','0','0',0,0,NULL,'2018-07-07 10:32:46','2018-07-07 11:11:50'),(1977,255,11,1,'2018-07-07 08:14:49','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 11:14:49'),(1978,255,12,1,'2018-07-07 08:16:14','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 11:16:14'),(1979,255,13,1,'2018-07-07 08:20:25','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 11:20:25'),(1980,255,10,1,'2018-07-07 10:15:52','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 13:15:52'),(1981,255,11,1,'2018-07-07 10:19:25','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 13:19:25'),(1982,255,12,1,'2018-07-07 10:20:19','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 13:20:19'),(1983,255,13,1,'2018-07-07 10:22:33','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 13:22:33'),(1984,255,10,1,'2018-07-07 11:23:04','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 14:23:04'),(1985,255,11,1,'2018-07-07 11:25:53','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 14:25:53'),(1986,255,12,1,'2018-07-07 11:27:15','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 14:27:15'),(1987,255,13,1,'2018-07-07 11:31:05','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 14:31:05'),(1988,255,10,1,'2018-07-07 11:35:05','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 14:35:05'),(1989,255,11,1,'2018-07-07 11:44:34','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 14:44:34'),(1990,255,12,1,'2018-07-07 11:45:24','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 14:45:24'),(1991,255,13,1,'2018-07-07 11:48:53','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 14:48:53'),(1992,255,10,1,'2018-07-07 12:24:04','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 15:24:04'),(1993,255,11,1,'2018-07-07 12:27:22','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 15:27:22'),(1994,255,12,1,'2018-07-07 12:28:36','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 15:28:36'),(1995,255,13,1,'2018-07-07 12:32:37','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 15:32:37'),(1996,255,10,1,'2018-07-07 13:34:13','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 16:34:13'),(1997,255,11,1,'2018-07-07 13:37:04','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 16:37:04'),(1998,255,12,1,'2018-07-07 13:38:03','0','0',0,0,NULL,'2018-07-07 10:32:47','2018-07-07 16:38:03'),(1999,255,13,1,'2018-07-07 13:41:08','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-07 16:41:08'),(2000,255,10,1,'2018-07-14 08:11:17','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 11:11:17'),(2001,255,12,1,'2018-07-14 08:18:30','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 11:18:30'),(2002,255,10,1,'2018-07-14 08:21:11','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 11:21:11'),(2003,255,11,1,'2018-07-14 08:23:28','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 11:23:28'),(2004,255,12,1,'2018-07-14 08:24:29','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 11:24:29'),(2005,255,13,1,'2018-07-14 08:28:19','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 11:28:19'),(2006,255,10,1,'2018-07-14 09:24:33','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 12:24:33'),(2007,255,11,1,'2018-07-14 09:27:25','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 12:27:25'),(2008,255,12,1,'2018-07-14 09:30:46','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 12:30:46'),(2009,255,13,1,'2018-07-14 09:35:21','0','0',0,0,NULL,'2018-07-07 10:32:48','2018-07-14 12:35:21'),(2010,256,10,1,'2018-07-09 00:08:07','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 03:08:07'),(2011,256,11,1,'2018-07-09 00:12:13','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 03:12:13'),(2012,256,12,1,'2018-07-09 00:14:27','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 03:14:27'),(2013,256,13,1,'2018-07-09 00:20:06','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 03:20:06'),(2014,256,10,1,'2018-07-09 01:08:20','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 04:08:20'),(2015,256,11,1,'2018-07-09 01:16:47','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 04:16:47'),(2016,256,12,1,'2018-07-09 01:19:01','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 04:19:01'),(2017,256,13,1,'2018-07-09 01:23:26','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 04:23:26'),(2018,256,10,1,'2018-07-09 02:10:01','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 05:10:01'),(2019,256,11,1,'2018-07-09 02:16:56','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 05:16:56'),(2020,256,12,1,'2018-07-09 02:19:54','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 05:19:54'),(2021,256,13,1,'2018-07-09 02:23:51','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 05:23:51'),(2022,256,10,1,'2018-07-09 03:10:09','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 06:10:09'),(2023,256,11,1,'2018-07-09 03:16:50','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 06:16:50'),(2024,256,12,1,'2018-07-09 03:20:23','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 06:20:23'),(2025,256,13,1,'2018-07-09 03:25:08','0','0',0,0,NULL,'2018-07-09 03:01:43','2018-07-09 06:25:08'),(2026,256,10,1,'2018-07-09 04:10:13','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 07:10:13'),(2027,256,11,1,'2018-07-09 04:14:38','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 07:14:38'),(2028,256,12,1,'2018-07-09 04:16:17','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 07:16:17'),(2029,256,13,1,'2018-07-09 04:19:45','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 07:19:45'),(2030,256,10,1,'2018-07-09 05:06:54','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 08:06:54'),(2031,256,11,1,'2018-07-09 05:10:32','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 08:10:32'),(2032,256,12,1,'2018-07-09 05:12:14','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 08:12:14'),(2033,256,13,1,'2018-07-09 05:15:47','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 08:15:47'),(2034,256,10,1,'2018-07-09 06:06:45','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 09:06:45'),(2035,256,12,1,'2018-07-09 06:14:58','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-09 09:14:58'),(2036,256,10,1,'2018-07-11 00:11:33','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-11 03:11:33'),(2037,256,11,1,'2018-07-11 00:19:55','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-11 03:19:55'),(2038,256,12,1,'2018-07-11 00:22:17','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-11 03:22:17'),(2039,256,13,1,'2018-07-11 00:26:56','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-11 03:26:56'),(2040,256,10,1,'2018-07-11 01:13:46','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-11 04:13:46'),(2041,256,11,1,'2018-07-11 01:20:52','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-11 04:20:52'),(2042,256,12,1,'2018-07-11 01:23:41','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-11 04:23:41'),(2043,256,13,1,'2018-07-11 01:28:00','0','0',0,0,NULL,'2018-07-09 03:01:44','2018-07-11 04:28:00'),(2044,257,13,1,'2018-07-10 05:45:58','-34.7575608','-55.9783361',0,0,NULL,'2018-07-10 07:59:30','2018-07-10 08:45:58'),(2045,257,12,1,'2018-07-10 05:54:58','-34.7567418','-55.9756511',0,0,NULL,'2018-07-10 07:59:30','2018-07-10 08:54:58'),(2046,257,11,1,'2018-07-10 05:56:50','-34.757585','-55.9746979',0,0,NULL,'2018-07-10 07:59:30','2018-07-10 08:56:50'),(2047,257,10,1,'2018-07-10 06:00:39','-34.756699','-55.9756795',0,0,NULL,'2018-07-10 07:59:31','2018-07-10 09:00:39'),(2048,257,13,1,'2018-07-14 22:13:59','-34.7574168','-55.9782481',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 01:13:59'),(2049,257,12,1,'2018-07-14 22:29:17','-34.7568755','-55.9758404',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 01:29:17'),(2050,257,11,1,'2018-07-14 22:35:17','-34.757098','-55.9750592',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 01:35:17'),(2051,257,10,1,'2018-07-14 22:43:38','0','0',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 01:43:38'),(2052,257,13,1,'2018-07-14 23:32:31','-34.7575247','-55.9783835',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 02:32:31'),(2053,257,12,1,'2018-07-14 23:38:59','-34.7571375','-55.9762917',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 02:38:59'),(2054,257,11,1,'2018-07-14 23:40:48','0','0',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 02:40:48'),(2055,257,10,1,'2018-07-14 23:44:04','0','0',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 02:44:04'),(2056,257,13,1,'2018-07-15 00:48:59','-34.7575524','-55.9783476',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 03:48:59'),(2057,257,12,1,'2018-07-15 00:56:25','-34.7579494','-55.9752692',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 03:56:25'),(2058,257,11,1,'2018-07-15 01:01:15','-34.7572189','-55.9746272',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 04:01:15'),(2059,257,10,1,'2018-07-15 01:04:35','-34.7570302','-55.9753579',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 04:04:35'),(2060,257,13,1,'2018-07-15 01:45:10','-34.7573921','-55.9782397',0,0,NULL,'2018-07-10 07:59:31','2018-07-15 04:45:10'),(2061,257,11,1,'2018-07-15 01:53:48','0','0',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 04:53:48'),(2062,257,13,1,'2018-07-15 02:39:14','-34.7573294','-55.9780557',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 05:39:14'),(2063,257,12,1,'2018-07-15 02:45:47','-34.7570055','-55.9766091',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 05:45:47'),(2064,257,11,1,'2018-07-15 02:50:32','-34.7570864','-55.975809',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 05:50:32'),(2065,257,10,1,'2018-07-15 02:53:29','-34.756547','-55.9761179',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 05:53:29'),(2066,257,13,1,'2018-07-15 03:44:11','-34.7574569','-55.9781776',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 06:44:11'),(2067,257,12,1,'2018-07-15 03:49:31','0','0',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 06:49:31'),(2068,257,11,1,'2018-07-15 03:51:23','-34.7570706','-55.9752237',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 06:51:23'),(2069,257,10,1,'2018-07-15 03:54:42','-34.7568965','-55.9756072',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 06:54:42'),(2070,257,13,1,'2018-07-15 04:46:53','-34.7574536','-55.9782912',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 07:46:53'),(2071,257,12,1,'2018-07-15 04:55:17','0','0',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 07:55:17'),(2072,257,11,1,'2018-07-15 05:01:49','-34.7572869','-55.9753051',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 08:01:49'),(2073,257,10,1,'2018-07-15 05:06:33','-34.756547','-55.9761179',0,0,NULL,'2018-07-10 07:59:32','2018-07-15 08:06:33'),(2074,257,13,1,'2018-07-17 00:15:58','-34.7573899','-55.9781943',0,0,'HORA REAL 0:15','2018-07-10 07:59:32','2018-07-17 03:15:58'),(2075,257,12,1,'2018-07-17 00:23:33','-34.7569746','-55.9764353',0,0,'HORA REAL 0:23','2018-07-10 07:59:32','2018-07-17 03:23:33'),(2076,257,11,1,'2018-07-17 00:26:29','-34.7571873','-55.975244',0,0,'HORA REAL 0:26','2018-07-10 07:59:32','2018-07-17 03:26:29'),(2077,257,10,1,'2018-07-17 00:30:34','-34.7565718','-55.9760909',0,0,'HORA REAL 0:30','2018-07-10 07:59:32','2018-07-17 03:30:34'),(2078,257,13,1,'2018-07-17 01:17:20','-34.757452','-55.978245',0,0,'HORA REAL 0:16','2018-07-10 07:59:32','2018-07-17 04:17:20'),(2079,257,12,1,'2018-07-17 01:25:41','-34.7572526','-55.9762644',0,0,'CORRECCION HORA REAL PUNTO DE CONTROL ANTERIOR 1:16\nHORA REAL F CORE 1:25','2018-07-10 07:59:32','2018-07-17 04:25:41'),(2080,257,11,1,'2018-07-17 01:28:52','-34.7572043','-55.9750366',0,0,'HORA REAL 1:28','2018-07-10 07:59:32','2018-07-17 04:28:52'),(2081,257,10,1,'2018-07-17 01:32:34','-34.756547','-55.9761179',0,0,'HORA REAL 1:32','2018-07-10 07:59:32','2018-07-17 04:32:34'),(2082,258,10,1,'2018-07-11 02:11:43','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 05:11:43'),(2083,258,11,1,'2018-07-11 02:16:56','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 05:16:56'),(2084,258,12,1,'2018-07-11 02:21:51','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 05:21:51'),(2085,258,13,1,'2018-07-11 02:25:53','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 05:25:53'),(2086,258,10,1,'2018-07-11 03:10:34','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 06:10:34'),(2087,258,11,1,'2018-07-11 03:16:50','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 06:16:50'),(2088,258,12,1,'2018-07-11 03:19:09','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 06:19:09'),(2089,258,13,1,'2018-07-11 03:23:17','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 06:23:17'),(2090,258,10,1,'2018-07-11 04:11:04','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 07:11:04'),(2091,258,11,1,'2018-07-11 04:15:37','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 07:15:37'),(2092,258,12,1,'2018-07-11 04:18:20','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 07:18:20'),(2093,258,13,1,'2018-07-11 04:23:08','0','0',0,0,NULL,'2018-07-11 05:10:44','2018-07-11 07:23:08'),(2094,258,10,1,'2018-07-11 05:07:28','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 08:07:28'),(2095,258,11,1,'2018-07-11 05:11:34','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 08:11:34'),(2096,258,12,1,'2018-07-11 05:17:17','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 08:17:17'),(2097,258,13,1,'2018-07-11 05:21:24','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 08:21:24'),(2098,258,10,1,'2018-07-11 06:05:41','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 09:05:41'),(2099,258,11,1,'2018-07-11 06:09:58','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 09:09:58'),(2100,258,12,1,'2018-07-11 06:11:13','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 09:11:13'),(2101,258,13,1,'2018-07-11 06:14:58','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 09:14:58'),(2102,258,10,1,'2018-07-11 06:56:45','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 09:56:45'),(2103,258,11,1,'2018-07-11 07:01:18','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 10:01:18'),(2104,258,12,1,'2018-07-11 07:02:35','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 10:02:35'),(2105,258,13,1,'2018-07-11 07:06:27','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-11 10:06:27'),(2106,258,10,1,'2018-07-12 00:11:30','0','0',0,0,NULL,'2018-07-11 05:10:45','2018-07-12 03:11:30'),(2107,258,12,1,'2018-07-12 00:17:35','0','0',0,0,NULL,'2018-07-11 05:10:46','2018-07-12 03:17:35'),(2108,258,10,1,'2018-07-12 01:07:33','0','0',0,0,NULL,'2018-07-11 05:10:46','2018-07-12 04:07:33'),(2109,258,11,1,'2018-07-12 01:16:44','0','0',0,0,NULL,'2018-07-11 05:10:46','2018-07-12 04:16:44'),(2110,258,12,1,'2018-07-12 01:19:49','0','0',0,0,NULL,'2018-07-11 05:10:46','2018-07-12 04:19:49'),(2111,258,13,1,'2018-07-12 01:24:20','0','0',0,0,NULL,'2018-07-11 05:10:46','2018-07-12 04:24:20'),(2112,258,10,1,'2018-07-12 02:08:32','0','0',0,0,NULL,'2018-07-11 05:10:46','2018-07-12 05:08:32'),(2113,258,11,1,'2018-07-12 02:16:27','0','0',0,0,NULL,'2018-07-11 05:10:47','2018-07-12 05:16:27'),(2114,258,12,1,'2018-07-12 02:19:00','0','0',0,0,NULL,'2018-07-11 05:10:47','2018-07-12 05:19:00'),(2115,258,13,1,'2018-07-12 02:23:08','0','0',0,0,NULL,'2018-07-11 05:10:47','2018-07-12 05:23:08'),(2116,259,10,1,'2018-07-12 03:10:11','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 06:10:11'),(2117,259,11,1,'2018-07-12 03:12:56','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 06:12:56'),(2118,259,12,1,'2018-07-12 03:15:39','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 06:15:39'),(2119,259,13,1,'2018-07-12 03:20:23','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 06:20:23'),(2120,259,10,1,'2018-07-12 04:10:31','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 07:10:31'),(2121,259,11,1,'2018-07-12 04:13:41','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 07:13:41'),(2122,259,12,1,'2018-07-12 04:19:18','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 07:19:18'),(2123,259,13,1,'2018-07-12 04:24:13','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 07:24:13'),(2124,259,10,1,'2018-07-12 05:12:02','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 08:12:02'),(2125,259,11,1,'2018-07-12 05:15:04','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 08:15:04'),(2126,259,12,1,'2018-07-12 05:17:58','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 08:17:58'),(2127,259,13,1,'2018-07-12 05:22:01','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 08:22:01'),(2128,259,10,1,'2018-07-12 05:59:30','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 08:59:30'),(2129,259,11,1,'2018-07-12 06:06:57','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 09:06:57'),(2130,259,12,1,'2018-07-12 06:11:14','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 09:11:14'),(2131,259,13,1,'2018-07-12 06:14:27','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-12 09:14:27'),(2132,259,10,1,'2018-07-13 00:15:14','0','0',0,0,NULL,'2018-07-12 06:07:35','2018-07-13 03:15:14'),(2133,259,11,1,'2018-07-13 00:19:12','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 03:19:12'),(2134,259,12,1,'2018-07-13 00:22:04','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 03:22:04'),(2135,259,13,1,'2018-07-13 00:26:50','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 03:26:50'),(2136,259,10,1,'2018-07-13 01:13:50','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 04:13:50'),(2137,259,11,1,'2018-07-13 01:17:16','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 04:17:16'),(2138,259,12,1,'2018-07-13 01:20:16','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 04:20:16'),(2139,259,13,1,'2018-07-13 01:24:25','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 04:24:25'),(2140,259,10,1,'2018-07-13 02:13:10','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 05:13:10'),(2141,259,12,1,'2018-07-13 02:26:48','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 05:26:48'),(2142,259,10,1,'2018-07-13 03:09:37','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 06:09:37'),(2143,259,11,1,'2018-07-13 03:18:44','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 06:18:44'),(2144,259,12,1,'2018-07-13 03:21:25','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 06:21:25'),(2145,259,13,1,'2018-07-13 03:25:40','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 06:25:40'),(2146,259,10,1,'2018-07-13 04:14:51','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 07:14:51'),(2147,259,11,1,'2018-07-13 04:19:02','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 07:19:02'),(2148,259,12,1,'2018-07-13 04:21:43','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 07:21:43'),(2149,259,13,1,'2018-07-13 04:25:44','0','0',0,0,NULL,'2018-07-12 06:07:36','2018-07-13 07:25:44'),(2150,260,10,1,'2018-07-13 06:00:26','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-13 09:00:26'),(2151,260,11,1,'2018-07-13 06:04:38','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-13 09:04:38'),(2152,260,12,1,'2018-07-13 06:05:40','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-13 09:05:40'),(2153,260,13,1,'2018-07-13 06:09:24','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-13 09:09:24'),(2154,260,10,1,'2018-07-14 01:49:11','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 04:49:11'),(2155,260,11,1,'2018-07-14 01:52:00','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 04:52:00'),(2156,260,12,1,'2018-07-14 01:54:11','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 04:54:11'),(2157,260,13,1,'2018-07-14 01:57:52','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 04:57:52'),(2158,260,10,1,'2018-07-14 02:46:52','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 05:46:52'),(2159,260,11,1,'2018-07-14 03:04:07','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 06:04:07'),(2160,260,12,1,'2018-07-14 03:07:31','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 06:07:31'),(2161,260,13,1,'2018-07-14 03:12:14','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 06:12:14'),(2162,260,10,1,'2018-07-14 03:47:59','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 06:47:59'),(2163,260,11,1,'2018-07-14 03:55:51','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 06:55:51'),(2164,260,12,1,'2018-07-14 03:58:31','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 06:58:31'),(2165,260,13,1,'2018-07-14 04:02:59','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 07:02:59'),(2166,260,10,1,'2018-07-14 04:39:20','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 07:39:20'),(2167,260,11,1,'2018-07-14 04:42:23','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 07:42:23'),(2168,260,12,1,'2018-07-14 04:44:58','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 07:44:58'),(2169,260,13,1,'2018-07-14 04:49:15','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 07:49:15'),(2170,260,10,1,'2018-07-14 05:40:22','0','0',0,0,NULL,'2018-07-13 07:25:50','2018-07-14 08:40:22'),(2171,260,11,1,'2018-07-14 05:44:10','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-14 08:44:10'),(2172,260,12,1,'2018-07-14 05:46:49','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-14 08:46:49'),(2173,260,13,1,'2018-07-14 05:51:05','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-14 08:51:05'),(2174,260,10,1,'2018-07-14 06:43:38','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-14 09:43:38'),(2175,260,12,1,'2018-07-14 06:49:18','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-14 09:49:18'),(2176,260,10,1,'2018-07-15 00:13:05','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-15 03:13:05'),(2177,260,11,1,'2018-07-15 00:19:08','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-15 03:19:08'),(2178,260,12,1,'2018-07-15 00:22:06','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-15 03:22:06'),(2179,260,13,1,'2018-07-15 00:29:34','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-15 03:29:34'),(2180,260,10,1,'2018-07-15 01:12:11','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-15 04:12:11'),(2181,260,11,1,'2018-07-15 01:19:04','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-15 04:19:04'),(2182,260,12,1,'2018-07-15 01:20:16','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-15 04:20:16'),(2183,260,13,1,'2018-07-15 01:25:06','0','0',0,0,NULL,'2018-07-13 07:25:51','2018-07-15 04:25:06'),(2184,261,10,1,'2018-07-14 10:35:52','0','0',0,0,NULL,'2018-07-14 12:35:27','2018-07-14 13:35:52'),(2185,261,11,1,'2018-07-14 10:39:41','0','0',0,0,NULL,'2018-07-14 12:35:27','2018-07-14 13:39:41'),(2186,261,12,1,'2018-07-14 10:44:52','0','0',0,0,NULL,'2018-07-14 12:35:27','2018-07-14 13:44:52'),(2187,261,13,1,'2018-07-14 10:50:54','0','0',0,0,NULL,'2018-07-14 12:35:27','2018-07-14 13:50:54'),(2188,261,10,1,'2018-07-14 11:39:34','0','0',0,0,NULL,'2018-07-14 12:35:27','2018-07-14 14:39:34'),(2189,261,11,1,'2018-07-14 11:42:55','0','0',0,0,NULL,'2018-07-14 12:35:27','2018-07-14 14:42:55'),(2190,261,12,1,'2018-07-14 11:44:28','0','0',0,0,NULL,'2018-07-14 12:35:27','2018-07-14 14:44:28'),(2191,261,13,1,'2018-07-14 11:49:21','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 14:49:21'),(2192,261,10,1,'2018-07-14 13:03:44','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 16:03:44'),(2193,261,11,1,'2018-07-14 13:06:04','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 16:06:04'),(2194,261,12,1,'2018-07-14 13:07:21','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 16:07:21'),(2195,261,13,1,'2018-07-14 13:11:10','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 16:11:10'),(2196,261,10,1,'2018-07-14 14:24:55','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 17:24:55'),(2197,261,11,1,'2018-07-14 14:27:47','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 17:27:47'),(2198,261,12,1,'2018-07-14 14:30:46','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 17:30:46'),(2199,261,13,1,'2018-07-14 14:34:50','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 17:34:50'),(2200,261,10,1,'2018-07-14 15:03:19','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 18:03:19'),(2201,261,11,1,'2018-07-14 15:07:00','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 18:07:00'),(2202,261,12,1,'2018-07-14 15:08:23','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 18:08:23'),(2203,261,13,1,'2018-07-14 15:19:27','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-14 18:19:27'),(2204,261,10,1,'2018-07-18 09:22:38','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-18 12:22:38'),(2205,261,11,1,'2018-07-18 09:24:53','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-18 12:24:53'),(2206,261,12,1,'2018-07-18 09:27:35','0','0',0,0,NULL,'2018-07-14 12:35:28','2018-07-18 12:27:35'),(2207,261,13,1,'2018-07-18 09:31:20','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 12:31:20'),(2208,261,10,1,'2018-07-18 10:30:03','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 13:30:03'),(2209,261,12,1,'2018-07-18 10:34:09','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 13:34:09'),(2210,261,10,1,'2018-07-18 10:36:47','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 13:36:47'),(2211,261,11,1,'2018-07-18 10:39:03','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 13:39:03'),(2212,261,12,1,'2018-07-18 10:39:57','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 13:39:57'),(2213,261,13,1,'2018-07-18 10:43:41','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 13:43:41'),(2214,261,10,1,'2018-07-18 11:29:42','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 14:29:42'),(2215,261,11,1,'2018-07-18 11:32:44','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 14:32:44'),(2216,261,12,1,'2018-07-18 11:36:26','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 14:36:26'),(2217,261,13,1,'2018-07-18 11:41:59','0','0',0,0,NULL,'2018-07-14 12:35:29','2018-07-18 14:41:59'),(2218,262,10,1,'2018-07-15 02:10:30','0','0',0,0,NULL,'2018-07-15 04:25:11','2018-07-15 05:10:30'),(2219,262,11,1,'2018-07-15 02:14:05','0','0',0,0,NULL,'2018-07-15 04:25:11','2018-07-15 05:14:05'),(2220,262,12,1,'2018-07-15 02:19:00','0','0',0,0,NULL,'2018-07-15 04:25:11','2018-07-15 05:19:00'),(2221,262,13,1,'2018-07-15 02:23:54','0','0',0,0,NULL,'2018-07-15 04:25:11','2018-07-15 05:23:54'),(2222,262,10,1,'2018-07-15 03:09:54','0','0',0,0,NULL,'2018-07-15 04:25:11','2018-07-15 06:09:54'),(2223,262,11,1,'2018-07-15 03:13:17','0','0',0,0,NULL,'2018-07-15 04:25:11','2018-07-15 06:13:17'),(2224,262,12,1,'2018-07-15 03:16:05','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 06:16:05'),(2225,262,13,1,'2018-07-15 03:21:35','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 06:21:35'),(2226,262,10,1,'2018-07-15 04:14:42','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 07:14:42'),(2227,262,11,1,'2018-07-15 04:18:04','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 07:18:04'),(2228,262,12,1,'2018-07-15 04:21:43','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 07:21:43'),(2229,262,13,1,'2018-07-15 04:27:09','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 07:27:09'),(2230,262,10,1,'2018-07-15 05:12:17','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 08:12:17'),(2231,262,11,1,'2018-07-15 05:14:51','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 08:14:51'),(2232,262,12,1,'2018-07-15 05:17:23','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 08:17:23'),(2233,262,13,1,'2018-07-15 05:22:05','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 08:22:05'),(2234,262,10,1,'2018-07-15 06:07:47','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 09:07:47'),(2235,262,11,1,'2018-07-15 06:17:56','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 09:17:56'),(2236,262,12,1,'2018-07-15 06:19:23','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 09:19:23'),(2237,262,13,1,'2018-07-15 06:23:49','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-15 09:23:49'),(2238,262,10,1,'2018-07-16 01:32:17','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 04:32:17'),(2239,262,11,1,'2018-07-16 01:35:12','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 04:35:12'),(2240,262,12,1,'2018-07-16 01:37:30','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 04:37:30'),(2241,262,13,1,'2018-07-16 01:42:22','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 04:42:22'),(2242,262,10,1,'2018-07-16 02:36:51','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 05:36:51'),(2243,262,12,1,'2018-07-16 02:49:43','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 05:49:43'),(2244,262,10,1,'2018-07-16 03:32:48','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 06:32:48'),(2245,262,11,1,'2018-07-16 03:38:48','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 06:38:48'),(2246,262,12,1,'2018-07-16 03:41:32','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 06:41:32'),(2247,262,13,1,'2018-07-16 03:45:34','0','0',0,0,NULL,'2018-07-15 04:25:12','2018-07-16 06:45:34'),(2248,262,10,1,'2018-07-16 04:34:06','0','0',0,0,NULL,'2018-07-15 04:25:13','2018-07-16 07:34:06'),(2249,262,11,1,'2018-07-16 04:41:42','0','0',0,0,NULL,'2018-07-15 04:25:13','2018-07-16 07:41:42'),(2250,262,12,1,'2018-07-16 04:44:20','0','0',0,0,NULL,'2018-07-15 04:25:13','2018-07-16 07:44:20'),(2251,262,13,1,'2018-07-16 04:48:12','0','0',0,0,NULL,'2018-07-15 04:25:13','2018-07-16 07:48:12'),(2252,263,10,1,'2018-07-16 05:37:17','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 08:37:17'),(2253,263,11,1,'2018-07-16 05:40:44','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 08:40:44'),(2254,263,12,1,'2018-07-16 05:44:23','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 08:44:23'),(2255,263,13,1,'2018-07-16 05:48:41','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 08:48:41'),(2256,263,10,1,'2018-07-16 06:36:28','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 09:36:28'),(2257,263,11,1,'2018-07-16 06:39:49','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 09:39:49'),(2258,263,12,1,'2018-07-16 06:40:52','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 09:40:52'),(2259,263,13,1,'2018-07-16 06:44:59','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 09:44:59'),(2260,263,10,1,'2018-07-16 07:29:03','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 10:29:03'),(2261,263,11,1,'2018-07-16 07:34:51','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 10:34:51'),(2262,263,12,1,'2018-07-16 07:35:52','0','0',0,0,NULL,'2018-07-16 08:35:04','2018-07-16 10:35:52'),(2263,263,13,1,'2018-07-16 07:39:12','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-16 10:39:12'),(2264,263,10,1,'2018-07-18 00:10:06','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 03:10:06'),(2265,263,11,1,'2018-07-18 00:13:04','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 03:13:04'),(2266,263,12,1,'2018-07-18 00:15:23','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 03:15:23'),(2267,263,13,1,'2018-07-18 00:23:13','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 03:23:13'),(2268,263,10,1,'2018-07-18 01:05:52','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 04:05:52'),(2269,263,11,1,'2018-07-18 01:08:06','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 04:08:06'),(2270,263,12,1,'2018-07-18 01:10:24','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 04:10:24'),(2271,263,13,1,'2018-07-18 01:18:03','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 04:18:03'),(2272,263,10,1,'2018-07-18 02:05:01','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 05:05:01'),(2273,263,11,1,'2018-07-18 02:08:02','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 05:08:02'),(2274,263,12,1,'2018-07-18 02:12:39','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 05:12:39'),(2275,263,13,1,'2018-07-18 02:20:18','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 05:20:18'),(2276,263,10,1,'2018-07-18 03:04:52','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 06:04:52'),(2277,263,12,1,'2018-07-18 03:13:15','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 06:13:15'),(2278,263,10,1,'2018-07-18 04:00:50','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 07:00:50'),(2279,263,11,1,'2018-07-18 04:03:50','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 07:03:50'),(2280,263,12,1,'2018-07-18 04:09:09','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 07:09:09'),(2281,263,13,1,'2018-07-18 04:16:05','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 07:16:05'),(2282,263,10,1,'2018-07-18 05:06:01','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 08:06:01'),(2283,263,11,1,'2018-07-18 05:08:48','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 08:08:48'),(2284,263,12,1,'2018-07-18 05:11:58','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 08:11:58'),(2285,263,13,1,'2018-07-18 05:17:12','0','0',0,0,NULL,'2018-07-16 08:35:05','2018-07-18 08:17:12'),(2286,264,13,1,'2018-07-17 02:18:47','-34.7574357','-55.9782249',0,0,'HORA REAL 2:18','2018-07-17 04:32:39','2018-07-17 05:18:47'),(2287,264,12,1,'2018-07-17 02:25:33','-34.7572018','-55.9760752',0,0,'HORA REAL 2:25','2018-07-17 04:32:39','2018-07-17 05:25:33'),(2288,264,11,1,'2018-07-17 02:27:43','-34.7571717','-55.9753603',0,0,'HORA REAL 2:27','2018-07-17 04:32:39','2018-07-17 05:27:43'),(2289,264,10,1,'2018-07-17 02:30:44','-34.756547','-55.9761179',0,0,NULL,'2018-07-17 04:32:39','2018-07-17 05:30:44'),(2290,264,13,1,'2018-07-17 03:20:28','-34.7572842','-55.978111',0,0,'HORA REAL 3:20','2018-07-17 04:32:39','2018-07-17 06:20:28'),(2291,264,12,1,'2018-07-17 03:27:32','-34.7569379','-55.9781289',0,0,'HORA REAL 3:27','2018-07-17 04:32:39','2018-07-17 06:27:32'),(2292,264,11,1,'2018-07-17 03:30:43','-34.7571598','-55.9750533',0,0,'HORA REAL 3:30','2018-07-17 04:32:39','2018-07-17 06:30:43'),(2293,264,10,1,'2018-07-17 03:35:32','-34.7579922','-55.9787184',0,0,'HORA REAL 3:35','2018-07-17 04:32:39','2018-07-17 06:35:32'),(2294,264,13,1,'2018-07-17 04:25:42','-34.7573903','-55.9782007',0,0,'HORA REAL 4:25','2018-07-17 04:32:39','2018-07-17 07:25:42'),(2295,264,12,1,'2018-07-17 04:31:39','-34.7570398','-55.9755128',0,0,'HORA REAL 4:31','2018-07-17 04:32:39','2018-07-17 07:31:39'),(2296,264,11,1,'2018-07-17 04:35:33','-34.757104','-55.9753582',0,0,'HORA REAL 4:35','2018-07-17 04:32:39','2018-07-17 07:35:33'),(2297,264,10,1,'2018-07-17 04:40:54','-34.756547','-55.9761179',0,0,'HORA REAL 4:40','2018-07-17 04:32:40','2018-07-17 07:40:54'),(2298,264,13,1,'2018-07-17 05:21:24','0','0',0,0,'HORA REAL 5:20','2018-07-17 04:32:40','2018-07-17 08:21:24'),(2299,264,12,1,'2018-07-17 05:26:57','-34.7564917','-55.976755',0,0,'HORA REAL 5:26','2018-07-17 04:32:40','2018-07-17 08:26:57'),(2300,264,11,1,'2018-07-17 05:29:51','0','0',0,0,'HORA REAL 5:29','2018-07-17 04:32:40','2018-07-17 08:29:51'),(2301,264,10,1,'2018-07-17 05:39:29','-34.756547','-55.9761179',0,0,'HORA REAL 5:39','2018-07-17 04:32:40','2018-07-17 08:39:29'),(2302,264,13,1,'2018-07-17 06:19:25','-34.7575358','-55.9783491',0,0,'HORA REAL 6:18','2018-07-17 04:32:40','2018-07-17 09:19:25'),(2303,264,11,1,'2018-07-17 06:40:40','-34.7571212','-55.9749841',0,0,'ATENCION: EN ESTA RONDA EL SISTEMA GENERO UN ERROR ELIMINANDO LOS PUNTOS DE CONTROL 2 Y 4 (F CORE Y PORTERIA)\nHORA REAL EN TANQUE 6:40','2018-07-17 04:32:40','2018-07-17 09:40:40'),(2304,264,13,1,'2018-07-21 22:02:53','-34.7574251','-55.9782497',0,0,'HORA REAL 22:03','2018-07-17 04:32:40','2018-07-22 01:02:53'),(2305,264,12,1,'2018-07-21 22:10:55','-34.7568459','-55.9768687',0,0,'HORA REAL 22:11','2018-07-17 04:32:40','2018-07-22 01:10:55'),(2306,264,11,1,'2018-07-21 22:13:18','-34.7573645','-55.9746914',0,0,'HORA REAL 22:13','2018-07-17 04:32:40','2018-07-22 01:13:18'),(2307,264,10,1,'2018-07-21 22:16:55','-34.756547','-55.9761179',0,0,'HORA REAL 22:17','2018-07-17 04:32:40','2018-07-22 01:16:55'),(2308,264,13,1,'2018-07-21 23:03:04','-34.7575303','-55.9782675',0,0,'HORA REAL 23:03','2018-07-17 04:32:40','2018-07-22 02:03:04'),(2309,264,12,1,'2018-07-21 23:11:54','-34.7571763','-55.9761672',0,0,'HORA REAL 23:12','2018-07-17 04:32:41','2018-07-22 02:11:54'),(2310,264,11,1,'2018-07-21 23:15:50','-34.7573115','-55.9754957',0,0,'HORA REAL 23:16','2018-07-17 04:32:41','2018-07-22 02:15:50'),(2311,264,10,1,'2018-07-21 23:19:01','-34.756547','-55.9761179',0,0,'HORA REAL 23:19','2018-07-17 04:32:41','2018-07-22 02:19:01'),(2312,264,13,1,'2018-07-22 00:01:04','-34.757459','-55.978292',0,0,'HORA REAL  0:01','2018-07-17 04:32:41','2018-07-22 03:01:04'),(2313,264,12,1,'2018-07-22 00:07:48','-34.7575728','-55.9748583',0,0,'HORA REAL  0:08','2018-07-17 04:32:41','2018-07-22 03:07:48'),(2314,264,11,1,'2018-07-22 00:11:48','-34.7575722','-55.9746653',0,0,'HORA REAL  0:12','2018-07-17 04:32:41','2018-07-22 03:11:48'),(2315,264,10,1,'2018-07-22 00:15:46','-34.756547','-55.9761179',0,0,'HORA REAL 0:16','2018-07-17 04:32:41','2018-07-22 03:15:46'),(2316,264,13,1,'2018-07-22 01:03:13','-34.7575069','-55.9783436',0,0,NULL,'2018-07-17 04:32:41','2018-07-22 04:03:13'),(2317,264,12,1,'2018-07-22 01:11:50','-34.7578377','-55.975173',0,0,'HORA REAL VERTICE 1:03\nHORA REAL F CORE 1:12','2018-07-17 04:32:41','2018-07-22 04:11:50'),(2318,264,11,1,'2018-07-22 01:14:50','-34.7570427','-55.9751521',0,0,'HORA REAL TANQUE 1:15','2018-07-17 04:32:41','2018-07-22 04:14:50'),(2319,264,10,1,'2018-07-22 01:18:48','-34.7570273','-55.9754822',0,0,'HORA REAL  PORTERIA 1:19','2018-07-17 04:32:41','2018-07-22 04:18:48'),(2320,264,13,1,'2018-07-22 02:02:41','-34.7574543','-55.9782588',0,0,'HORA REAL 2:02','2018-07-17 04:32:41','2018-07-22 05:02:41'),(2321,264,12,1,'2018-07-22 02:08:01','-34.7579463','-55.9751951',0,0,'HORA REAL 2:08','2018-07-17 04:32:41','2018-07-22 05:08:01'),(2322,264,11,1,'2018-07-22 02:10:50','-34.7573694','-55.9754749',0,0,'HORA REAL 2:11','2018-07-17 04:32:41','2018-07-22 05:10:50'),(2323,264,10,1,'2018-07-22 02:16:55','0','0',0,0,'HORA REAL 2:17','2018-07-17 04:32:41','2018-07-22 05:16:55'),(2324,265,10,1,'2018-07-18 06:08:50','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 09:08:50'),(2325,265,11,1,'2018-07-18 06:11:58','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 09:11:58'),(2326,265,12,1,'2018-07-18 06:13:45','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 09:13:45'),(2327,265,13,1,'2018-07-18 06:19:09','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 09:19:09'),(2328,265,10,1,'2018-07-18 06:55:18','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 09:55:18'),(2329,265,11,1,'2018-07-18 06:58:21','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 09:58:21'),(2330,265,12,1,'2018-07-18 07:00:07','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 10:00:07'),(2331,265,13,1,'2018-07-18 07:04:46','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 10:04:46'),(2332,265,10,1,'2018-07-18 07:46:20','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 10:46:20'),(2333,265,11,1,'2018-07-18 07:48:49','0','0',0,0,NULL,'2018-07-18 09:07:54','2018-07-18 10:48:49'),(2334,265,12,1,'2018-07-18 07:50:11','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-18 10:50:11'),(2335,265,13,1,'2018-07-18 07:53:27','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-18 10:53:27'),(2336,265,10,1,'2018-07-19 00:09:51','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 03:09:51'),(2337,265,11,1,'2018-07-19 00:16:17','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 03:16:17'),(2338,265,12,1,'2018-07-19 00:18:38','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 03:18:38'),(2339,265,13,1,'2018-07-19 00:26:14','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 03:26:14'),(2340,265,10,1,'2018-07-19 01:13:40','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 04:13:40'),(2341,265,11,1,'2018-07-19 01:19:11','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 04:19:11'),(2342,265,12,1,'2018-07-19 01:24:24','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 04:24:24'),(2343,265,13,1,'2018-07-19 01:31:58','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 04:31:58'),(2344,265,10,1,'2018-07-19 02:03:40','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 05:03:40'),(2345,265,11,1,'2018-07-19 02:06:16','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 05:06:16'),(2346,265,12,1,'2018-07-19 02:08:48','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 05:08:48'),(2347,265,13,1,'2018-07-19 02:13:36','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 05:13:36'),(2348,265,10,1,'2018-07-19 03:02:56','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 06:02:56'),(2349,265,12,1,'2018-07-19 03:08:53','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 06:08:53'),(2350,265,10,1,'2018-07-19 03:58:10','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 06:58:10'),(2351,265,11,1,'2018-07-19 04:01:19','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 07:01:19'),(2352,265,12,1,'2018-07-19 04:03:57','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 07:03:57'),(2353,265,13,1,'2018-07-19 04:11:11','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-19 07:11:11'),(2354,265,10,1,'2018-07-20 00:12:30','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-20 03:12:30'),(2355,265,11,1,'2018-07-20 00:15:12','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-20 03:15:12'),(2356,265,12,1,'2018-07-20 00:17:39','0','0',0,0,NULL,'2018-07-18 09:07:55','2018-07-20 03:17:39'),(2357,265,13,1,'2018-07-20 00:22:51','0','0',0,0,NULL,'2018-07-18 09:07:56','2018-07-20 03:22:51'),(2358,266,10,1,'2018-07-18 12:35:20','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 15:35:20'),(2359,266,11,1,'2018-07-18 12:38:36','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 15:38:36'),(2360,266,12,1,'2018-07-18 12:42:06','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 15:42:06'),(2361,266,13,1,'2018-07-18 12:49:13','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 15:49:13'),(2362,266,10,1,'2018-07-18 14:07:23','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 17:07:23'),(2363,266,11,1,'2018-07-18 14:10:10','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 17:10:10'),(2364,266,12,1,'2018-07-18 14:13:36','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 17:13:36'),(2365,266,13,1,'2018-07-18 14:17:39','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 17:17:39'),(2366,266,10,1,'2018-07-18 15:05:21','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 18:05:21'),(2367,266,11,1,'2018-07-18 15:07:50','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 18:07:50'),(2368,266,12,1,'2018-07-18 15:10:41','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 18:10:41'),(2369,266,13,1,'2018-07-18 15:14:16','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 18:14:16'),(2370,266,10,1,'2018-07-18 16:03:47','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 19:03:47'),(2371,266,11,1,'2018-07-18 16:06:17','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 19:06:17'),(2372,266,12,1,'2018-07-18 16:09:09','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 19:09:09'),(2373,266,13,1,'2018-07-18 16:13:22','0','0',0,0,NULL,'2018-07-18 14:42:38','2018-07-18 19:13:22'),(2374,266,10,1,'2018-07-21 07:16:20','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 10:16:20'),(2375,266,11,1,'2018-07-21 07:18:45','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 10:18:45'),(2376,266,12,1,'2018-07-21 07:21:46','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 10:21:46'),(2377,266,13,1,'2018-07-21 07:30:55','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 10:30:55'),(2378,266,10,1,'2018-07-21 08:16:23','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 11:16:23'),(2379,266,11,1,'2018-07-21 08:18:55','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 11:18:55'),(2380,266,12,1,'2018-07-21 08:22:07','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 11:22:07'),(2381,266,13,1,'2018-07-21 08:27:46','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 11:27:46'),(2382,266,10,1,'2018-07-21 09:31:53','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 12:31:53'),(2383,266,12,1,'2018-07-21 09:34:52','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 12:34:52'),(2384,266,10,1,'2018-07-21 09:37:14','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 12:37:14'),(2385,266,11,1,'2018-07-21 09:39:40','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 12:39:40'),(2386,266,12,1,'2018-07-21 09:42:22','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 12:42:22'),(2387,266,13,1,'2018-07-21 09:46:28','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 12:46:28'),(2388,266,10,1,'2018-07-21 10:28:48','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 13:28:48'),(2389,266,11,1,'2018-07-21 10:31:38','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 13:31:38'),(2390,266,12,1,'2018-07-21 10:35:30','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 13:35:30'),(2391,266,13,1,'2018-07-21 10:40:11','0','0',0,0,NULL,'2018-07-18 14:42:39','2018-07-21 13:40:11'),(2392,267,10,1,'2018-07-20 01:12:35','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 04:12:35'),(2393,267,11,1,'2018-07-20 01:15:10','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 04:15:10'),(2394,267,12,1,'2018-07-20 01:18:45','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 04:18:45'),(2395,267,13,1,'2018-07-20 01:24:16','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 04:24:16'),(2396,267,10,1,'2018-07-20 02:08:19','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 05:08:19'),(2397,267,11,1,'2018-07-20 02:12:21','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 05:12:21'),(2398,267,12,1,'2018-07-20 02:16:15','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 05:16:15'),(2399,267,13,1,'2018-07-20 02:21:13','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 05:21:13'),(2400,267,10,1,'2018-07-20 03:08:24','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 06:08:24'),(2401,267,11,1,'2018-07-20 03:14:32','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 06:14:32'),(2402,267,12,1,'2018-07-20 03:17:02','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 06:17:02'),(2403,267,13,1,'2018-07-20 03:21:10','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 06:21:10'),(2404,267,10,1,'2018-07-20 04:08:54','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 07:08:54'),(2405,267,11,1,'2018-07-20 04:15:38','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 07:15:38'),(2406,267,12,1,'2018-07-20 04:18:01','0','0',0,0,NULL,'2018-07-20 04:11:36','2018-07-20 07:18:01'),(2407,267,13,1,'2018-07-20 04:22:20','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-20 07:22:20'),(2408,267,10,1,'2018-07-20 05:08:18','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-20 08:08:18'),(2409,267,11,1,'2018-07-20 05:12:16','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-20 08:12:16'),(2410,267,12,1,'2018-07-20 05:14:56','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-20 08:14:56'),(2411,267,13,1,'2018-07-20 05:19:18','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-20 08:19:18'),(2412,267,10,1,'2018-07-21 00:10:08','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-21 03:10:08'),(2413,267,11,1,'2018-07-21 00:14:33','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-21 03:14:33'),(2414,267,12,1,'2018-07-21 00:17:31','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-21 03:17:31'),(2415,267,13,1,'2018-07-21 00:22:10','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-21 03:22:10'),(2416,267,10,1,'2018-07-21 01:09:39','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-21 04:09:39'),(2417,267,12,1,'2018-07-21 01:17:24','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-21 04:17:24'),(2418,267,10,1,'2018-07-21 02:09:37','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-21 05:09:37'),(2419,267,11,1,'2018-07-21 02:14:44','0','0',0,0,NULL,'2018-07-20 04:11:37','2018-07-21 05:14:44'),(2420,267,12,1,'2018-07-21 02:17:13','0','0',0,0,NULL,'2018-07-20 04:11:38','2018-07-21 05:17:13'),(2421,267,13,1,'2018-07-21 02:21:52','0','0',0,0,NULL,'2018-07-20 04:11:38','2018-07-21 05:21:52'),(2422,267,10,1,'2018-07-21 03:09:37','0','0',0,0,NULL,'2018-07-20 04:11:38','2018-07-21 06:09:37'),(2423,267,11,1,'2018-07-21 03:12:35','0','0',0,0,NULL,'2018-07-20 04:11:38','2018-07-21 06:12:35'),(2424,267,12,1,'2018-07-21 03:15:01','0','0',0,0,NULL,'2018-07-20 04:11:38','2018-07-21 06:15:01'),(2425,267,13,1,'2018-07-21 03:19:42','0','0',0,0,NULL,'2018-07-20 04:11:38','2018-07-21 06:19:42'),(2426,268,10,1,'2018-07-21 04:10:48','0','0',0,0,NULL,'2018-07-21 07:09:29','2018-07-21 07:10:48'),(2427,268,11,1,'2018-07-21 04:16:21','0','0',0,0,NULL,'2018-07-21 07:09:29','2018-07-21 07:16:21'),(2428,268,12,1,'2018-07-21 04:18:41','0','0',0,0,NULL,'2018-07-21 07:09:29','2018-07-21 07:18:41'),(2429,268,13,1,'2018-07-21 05:20:11','0','0',0,0,NULL,'2018-07-21 07:09:29','2018-07-21 08:20:11'),(2430,268,10,1,'2018-07-21 06:08:40','0','0',0,0,NULL,'2018-07-21 07:09:29','2018-07-21 09:08:40'),(2431,268,11,1,'2018-07-21 06:14:47','0','0',0,0,NULL,'2018-07-21 07:09:29','2018-07-21 09:14:47'),(2432,268,12,1,'2018-07-21 06:15:40','0','0',0,0,NULL,'2018-07-21 07:09:29','2018-07-21 09:15:40'),(2433,268,13,1,'2018-07-21 06:19:24','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 09:19:24'),(2434,268,10,1,'2018-07-21 16:10:53','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 19:10:53'),(2435,268,11,1,'2018-07-21 16:17:56','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 19:17:56'),(2436,268,12,1,'2018-07-21 16:19:46','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 19:19:46'),(2437,268,13,1,'2018-07-21 16:24:08','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 19:24:08'),(2438,268,10,1,'2018-07-21 17:12:22','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 20:12:22'),(2439,268,11,1,'2018-07-21 17:15:35','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 20:15:35'),(2440,268,12,1,'2018-07-21 17:18:08','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 20:18:08'),(2441,268,13,1,'2018-07-21 17:22:39','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 20:22:39'),(2442,268,10,1,'2018-07-21 18:01:56','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 21:01:56'),(2443,268,11,1,'2018-07-21 18:05:13','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 21:05:13'),(2444,268,12,1,'2018-07-21 18:07:50','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 21:07:50'),(2445,268,13,1,'2018-07-21 18:13:12','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 21:13:12'),(2446,268,10,1,'2018-07-21 18:44:51','0','0',0,0,NULL,'2018-07-21 07:09:30','2018-07-21 21:44:51'),(2447,268,11,1,'2018-07-21 18:48:17','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 21:48:17'),(2448,268,12,1,'2018-07-21 18:50:34','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 21:50:34'),(2449,268,13,1,'2018-07-21 18:54:50','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 21:54:50'),(2450,268,10,1,'2018-07-21 19:38:05','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 22:38:05'),(2451,268,12,1,'2018-07-21 19:42:35','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 22:42:35'),(2452,268,10,1,'2018-07-21 20:29:51','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 23:29:51'),(2453,268,11,1,'2018-07-21 20:32:14','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 23:32:14'),(2454,268,12,1,'2018-07-21 20:34:43','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 23:34:43'),(2455,268,13,1,'2018-07-21 20:39:15','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-21 23:39:15'),(2456,268,10,1,'2018-07-21 21:13:58','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-22 00:13:58'),(2457,268,11,1,'2018-07-21 21:16:18','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-22 00:16:18'),(2458,268,12,1,'2018-07-21 21:19:08','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-22 00:19:08'),(2459,268,13,1,'2018-07-21 21:23:43','0','0',0,0,NULL,'2018-07-21 07:09:31','2018-07-22 00:23:43'),(2460,269,10,1,'2018-07-21 11:36:13','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 14:36:13'),(2461,269,11,1,'2018-07-21 11:38:41','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 14:38:41'),(2462,269,12,1,'2018-07-21 11:41:51','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 14:41:51'),(2463,269,13,1,'2018-07-21 11:46:07','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 14:46:07'),(2464,269,10,1,'2018-07-21 12:50:03','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 15:50:03'),(2465,269,11,1,'2018-07-21 12:52:37','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 15:52:37'),(2466,269,12,1,'2018-07-21 12:53:56','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 15:53:56'),(2467,269,13,1,'2018-07-21 12:58:06','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 15:58:06'),(2468,269,10,1,'2018-07-21 13:39:19','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 16:39:19'),(2469,269,11,1,'2018-07-21 13:42:03','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 16:42:03'),(2470,269,12,1,'2018-07-21 13:45:01','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 16:45:01'),(2471,269,13,1,'2018-07-21 13:49:00','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 16:49:00'),(2472,269,10,1,'2018-07-21 14:33:17','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 17:33:17'),(2473,269,11,1,'2018-07-21 14:35:33','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 17:35:33'),(2474,269,12,1,'2018-07-21 14:36:31','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 17:36:31'),(2475,269,13,1,'2018-07-21 14:40:27','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 17:40:27'),(2476,269,10,1,'2018-07-21 15:14:58','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 18:14:58'),(2477,269,11,1,'2018-07-21 15:17:23','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 18:17:23'),(2478,269,12,1,'2018-07-21 15:19:55','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 18:19:55'),(2479,269,13,1,'2018-07-21 15:24:06','0','0',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 18:24:06'),(2480,269,10,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:18','2018-07-21 13:40:18'),(2481,269,11,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2482,269,12,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2483,269,13,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2484,269,10,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2485,269,12,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2486,269,10,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2487,269,11,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2488,269,12,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2489,269,13,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2490,269,10,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2491,269,11,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2492,269,12,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2493,269,13,0,NULL,'','',0,0,NULL,'2018-07-21 13:40:19','2018-07-21 13:40:19'),(2494,270,10,1,'2018-07-21 22:32:26','0','0',0,0,NULL,'2018-07-22 01:31:27','2018-07-22 01:32:26'),(2495,270,11,1,'2018-07-21 22:35:46','0','0',0,0,NULL,'2018-07-22 01:31:27','2018-07-22 01:35:46'),(2496,270,12,1,'2018-07-21 22:38:22','0','0',0,0,NULL,'2018-07-22 01:31:27','2018-07-22 01:38:22'),(2497,270,13,1,'2018-07-21 22:44:41','0','0',0,0,NULL,'2018-07-22 01:31:27','2018-07-22 01:44:41'),(2498,270,10,1,'2018-07-21 23:34:45','0','0',0,0,NULL,'2018-07-22 01:31:27','2018-07-22 02:34:45'),(2499,270,11,1,'2018-07-21 23:37:35','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 02:37:35'),(2500,270,12,1,'2018-07-21 23:39:51','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 02:39:51'),(2501,270,13,1,'2018-07-21 23:44:26','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 02:44:26'),(2502,270,10,1,'2018-07-22 00:31:39','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 03:31:39'),(2503,270,11,1,'2018-07-22 00:35:39','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 03:35:39'),(2504,270,12,1,'2018-07-22 00:38:12','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 03:38:12'),(2505,270,13,1,'2018-07-22 00:44:43','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 03:44:43'),(2506,270,10,1,'2018-07-22 01:33:05','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 04:33:05'),(2507,270,11,1,'2018-07-22 01:36:28','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 04:36:28'),(2508,270,12,1,'2018-07-22 01:41:22','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 04:41:22'),(2509,270,13,1,'2018-07-22 01:46:04','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 04:46:04'),(2510,270,10,1,'2018-07-22 02:34:32','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 05:34:32'),(2511,270,11,1,'2018-07-22 02:37:45','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 05:37:45'),(2512,270,12,1,'2018-07-22 02:40:15','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 05:40:15'),(2513,270,13,1,'2018-07-22 02:47:19','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 05:47:19'),(2514,270,10,1,'2018-07-22 03:34:09','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 06:34:09'),(2515,270,11,1,'2018-07-22 03:39:47','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 06:39:47'),(2516,270,12,1,'2018-07-22 03:43:48','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 06:43:48'),(2517,270,13,1,'2018-07-22 03:48:21','0','0',0,0,NULL,'2018-07-22 01:31:28','2018-07-22 06:48:21'),(2518,270,10,1,'2018-07-22 04:35:30','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 07:35:30'),(2519,270,12,1,'2018-07-22 04:40:34','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 07:40:34'),(2520,270,10,1,'2018-07-22 05:40:46','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 08:40:46'),(2521,270,11,1,'2018-07-22 05:43:13','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 08:43:13'),(2522,270,12,1,'2018-07-22 05:46:20','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 08:46:20'),(2523,270,13,1,'2018-07-22 05:50:53','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 08:50:53'),(2524,270,10,1,'2018-07-22 06:52:41','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 09:52:41'),(2525,270,11,1,'2018-07-22 06:55:12','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 09:55:12'),(2526,270,12,1,'2018-07-22 06:57:02','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 09:57:02'),(2527,270,13,1,'2018-07-22 07:00:29','0','0',0,0,NULL,'2018-07-22 01:31:29','2018-07-22 10:00:29'),(2528,271,13,1,'2018-07-22 03:09:14','0','0',0,0,'HORA REAL 3:09','2018-07-22 05:17:00','2018-07-22 06:09:14'),(2529,271,12,1,'2018-07-22 03:15:05','-34.7579461','-55.9752665',0,0,'HORA REAL 3:15','2018-07-22 05:17:00','2018-07-22 06:15:05'),(2530,271,11,1,'2018-07-22 03:17:48','-34.756547','-55.9761179',0,0,'HORA REAL 3:18','2018-07-22 05:17:00','2018-07-22 06:17:48'),(2531,271,10,1,'2018-07-22 03:20:54','-34.7568725','-55.9762',0,0,'HORA REAL 3:21','2018-07-22 05:17:00','2018-07-22 06:20:54'),(2532,271,13,1,'2018-07-22 04:03:07','-34.7574229','-55.9782056',0,0,'HORA REAL 4:03','2018-07-22 05:17:00','2018-07-22 07:03:07'),(2533,271,12,1,'2018-07-22 04:09:16','-34.7576774','-55.9763434',0,0,'HORA REAL 4:09','2018-07-22 05:17:00','2018-07-22 07:09:16'),(2534,271,11,1,'2018-07-22 04:13:11','-34.7571859','-55.9751411',0,0,'HORA REAL 4:13','2018-07-22 05:17:00','2018-07-22 07:13:11'),(2535,271,10,1,'2018-07-22 04:16:51','-34.756547','-55.9761179',0,0,'HORA REAL 4:17','2018-07-22 05:17:00','2018-07-22 07:16:51'),(2536,271,13,1,'2018-07-22 05:09:41','-34.7574104','-55.9782465',0,0,'HORA REAL 5:09','2018-07-22 05:17:01','2018-07-22 08:09:41'),(2537,271,12,1,'2018-07-22 05:14:49','-34.7579494','-55.9752692',0,0,'HORA REAL 5:15','2018-07-22 05:17:01','2018-07-22 08:14:49'),(2538,271,11,1,'2018-07-22 05:18:53','-34.7579461','-55.9752665',0,0,'HORA REAL 5:19','2018-07-22 05:17:01','2018-07-22 08:18:53'),(2539,271,10,1,'2018-07-22 05:27:24','-34.756547','-55.9761179',0,0,'HORA REAL 5:27\nFINALIZO JORNADA NOCTURNA CON 8 RECORRIDOS POR EL TEJIDO SIN NOVEDAD\nSE REALIZO IGUALMENTE INSPECCION INICIAL DE LA OBRA 21:45 SIN NOVEDAD','2018-07-22 05:17:01','2018-07-22 08:27:24'),(2540,271,13,1,'2018-07-24 00:10:19','-34.7574151','-55.9782228',0,0,'HORA REAL 0:10','2018-07-22 05:17:01','2018-07-24 03:10:19'),(2541,271,12,1,'2018-07-24 00:17:45','0','0',0,0,'HORA REAL 0:17','2018-07-22 05:17:01','2018-07-24 03:17:45'),(2542,271,11,1,'2018-07-24 00:25:49','-34.7570698','-55.9748089',0,0,'HORA REAL 0:25','2018-07-22 05:17:01','2018-07-24 03:25:49'),(2543,271,10,1,'2018-07-24 00:31:52','0','0',0,0,'HORA REAL 0:32','2018-07-22 05:17:01','2018-07-24 03:31:52'),(2544,271,13,1,'2018-07-24 01:16:51','-34.7574462','-55.9782444',0,0,'HORA REAL 0:17','2018-07-22 05:17:01','2018-07-24 04:16:51'),(2545,271,11,1,'2018-07-24 01:26:26','-34.7574014','-55.9750089',0,0,'HORA REAL TANQUE 0:26\nATENCION:\nEN ESTA RECORRIDA EL SISTEMA ME ELIMINO LOS PUNTOS DE CONTROL 2 Y 4 (F CORE Y PORTERIA)','2018-07-22 05:17:01','2018-07-24 04:26:26'),(2546,271,13,1,'2018-07-24 02:20:34','-34.7574961','-55.9783091',0,0,'HORA REAL 2:20','2018-07-22 05:17:01','2018-07-24 05:20:34'),(2547,271,12,1,'2018-07-24 02:25:49','-34.7574372','-55.9754629',0,0,'HORA REAL 2:26','2018-07-22 05:17:01','2018-07-24 05:25:49'),(2548,271,11,1,'2018-07-24 02:29:11','-34.7570495','-55.9750631',0,0,'HORA REAL 2:29','2018-07-22 05:17:01','2018-07-24 05:29:11'),(2549,271,10,1,'2018-07-24 02:34:56','-34.7566486','-55.9757751',0,0,'HORA REAL 2:35','2018-07-22 05:17:01','2018-07-24 05:34:56'),(2550,271,13,1,'2018-07-24 03:18:54','-34.7574786','-55.9782864',0,0,'HORA REAL 3:19','2018-07-22 05:17:01','2018-07-24 06:18:54'),(2551,271,12,1,'2018-07-24 03:25:55','-34.7556852','-55.9779894',0,0,'HORA REAL 3:26','2018-07-22 05:17:01','2018-07-24 06:25:55'),(2552,271,11,1,'2018-07-24 03:28:55','-34.756926','-55.9745238',0,0,'HORA REAL 3:29','2018-07-22 05:17:01','2018-07-24 06:28:55'),(2553,271,10,1,'2018-07-24 03:34:52','-34.7566486','-55.9757751',0,0,'HORA REAL 3:35','2018-07-22 05:17:01','2018-07-24 06:34:52'),(2554,271,13,1,'2018-07-24 04:23:19','-34.75744','-55.9782657',0,0,'HORA 4:23','2018-07-22 05:17:02','2018-07-24 07:23:19'),(2555,271,12,1,'2018-07-24 04:29:12','-34.7573279','-55.9755058',0,0,'HORA 4:29','2018-07-22 05:17:02','2018-07-24 07:29:12'),(2556,271,11,1,'2018-07-24 04:30:53','-34.75686','-55.9747504',0,0,'HORA 4:31;','2018-07-22 05:17:02','2018-07-24 07:30:53'),(2557,271,10,1,'2018-07-24 04:34:51','-34.7566486','-55.9757751',0,0,'HORA 4:35','2018-07-22 05:17:02','2018-07-24 07:34:51'),(2558,271,13,1,'2018-07-24 05:20:28','-34.7575279','-55.9783585',0,0,'HORA 5:20','2018-07-22 05:17:02','2018-07-24 08:20:28'),(2559,271,12,1,'2018-07-24 05:25:49','-34.7562929','-55.9779185',0,0,'HORA 5:26','2018-07-22 05:17:02','2018-07-24 08:25:49'),(2560,271,11,1,'2018-07-24 05:27:57','-34.7567904','-55.9748066',0,0,'HORA 5:28','2018-07-22 05:17:02','2018-07-24 08:27:57'),(2561,271,10,1,'2018-07-24 05:33:35','-34.7566486','-55.9757751',0,0,'HORA 5:33','2018-07-22 05:17:02','2018-07-24 08:33:35'),(2562,271,13,1,'2018-07-24 06:20:09','-34.757512','-55.978326',0,0,'HORA REAL 6:20','2018-07-22 05:17:02','2018-07-24 09:20:09'),(2563,271,12,1,'2018-07-24 06:27:04','-34.7573637','-55.9754916',0,0,'HORA REAL 6:27','2018-07-22 05:17:02','2018-07-24 09:27:04'),(2564,271,11,1,'2018-07-24 06:29:50','-34.7571245','-55.9745637',0,0,'HORA REAL 6:30','2018-07-22 05:17:02','2018-07-24 09:29:50'),(2565,271,10,1,'2018-07-24 06:48:11','-34.7570816','-55.9752577',0,0,'HORA REAL 6:48','2018-07-22 05:17:02','2018-07-24 09:48:11'),(2566,272,10,1,'2018-07-23 00:09:17','0','0',0,0,NULL,'2018-07-23 03:08:05','2018-07-23 03:09:17'),(2567,272,11,1,'2018-07-23 00:12:51','0','0',0,0,NULL,'2018-07-23 03:08:05','2018-07-23 03:12:51'),(2568,272,12,1,'2018-07-23 00:15:32','0','0',0,0,NULL,'2018-07-23 03:08:05','2018-07-23 03:15:32'),(2569,272,13,1,'2018-07-23 00:20:02','0','0',0,0,NULL,'2018-07-23 03:08:05','2018-07-23 03:20:02'),(2570,272,10,1,'2018-07-23 01:05:04','0','0',0,0,NULL,'2018-07-23 03:08:05','2018-07-23 04:05:04'),(2571,272,11,1,'2018-07-23 01:08:14','0','0',0,0,NULL,'2018-07-23 03:08:05','2018-07-23 04:08:14'),(2572,272,12,1,'2018-07-23 01:11:48','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 04:11:48'),(2573,272,13,1,'2018-07-23 01:15:20','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 04:15:20'),(2574,272,10,1,'2018-07-23 02:06:49','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 05:06:49'),(2575,272,11,1,'2018-07-23 02:10:34','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 05:10:34'),(2576,272,12,1,'2018-07-23 02:14:56','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 05:14:56'),(2577,272,13,1,'2018-07-23 02:19:05','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 05:19:05'),(2578,272,10,1,'2018-07-23 03:06:44','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 06:06:44'),(2579,272,11,1,'2018-07-23 03:09:31','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 06:09:31'),(2580,272,12,1,'2018-07-23 03:12:14','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 06:12:14'),(2581,272,13,1,'2018-07-23 03:16:29','0','0',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 06:16:29'),(2582,272,10,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2583,272,11,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2584,272,12,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2585,272,13,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2586,272,10,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2587,272,11,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2588,272,12,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2589,272,13,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2590,272,10,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2591,272,12,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:06','2018-07-23 03:08:06'),(2592,272,10,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:07','2018-07-23 03:08:07'),(2593,272,11,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:07','2018-07-23 03:08:07'),(2594,272,12,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:07','2018-07-23 03:08:07'),(2595,272,13,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:07','2018-07-23 03:08:07'),(2596,272,10,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:07','2018-07-23 03:08:07'),(2597,272,11,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:07','2018-07-23 03:08:07'),(2598,272,12,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:07','2018-07-23 03:08:07'),(2599,272,13,0,NULL,'','',0,0,NULL,'2018-07-23 03:08:07','2018-07-23 03:08:07'),(2600,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2601,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2602,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2603,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2604,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2605,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2606,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2607,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2608,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2609,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2610,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2611,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2612,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2613,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2614,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2615,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2616,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2617,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2618,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:17','2018-07-24 09:48:17'),(2619,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2620,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2621,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2622,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2623,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2624,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2625,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2626,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2627,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2628,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2629,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2630,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2631,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2632,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2633,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2634,273,13,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2635,273,12,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2636,273,11,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18'),(2637,273,10,0,NULL,'','',0,0,NULL,'2018-07-24 09:48:18','2018-07-24 09:48:18');
/*!40000 ALTER TABLE `round_points` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rounds`
--

DROP TABLE IF EXISTS `rounds`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rounds` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seg_app_id` int(10) unsigned DEFAULT NULL,
  `seg_route_id` int(10) unsigned DEFAULT NULL,
  `done` tinyint(1) NOT NULL DEFAULT '0',
  `job_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rounds_seg_route_id_foreign` (`seg_route_id`),
  KEY `rounds_seg_app_id_foreign` (`seg_app_id`),
  CONSTRAINT `rounds_seg_app_id_foreign` FOREIGN KEY (`seg_app_id`) REFERENCES `seg_apps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `rounds_seg_route_id_foreign` FOREIGN KEY (`seg_route_id`) REFERENCES `seg_routes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=274 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rounds`
--

LOCK TABLES `rounds` WRITE;
/*!40000 ALTER TABLE `rounds` DISABLE KEYS */;
INSERT INTO `rounds` VALUES (188,1,9,1,NULL,'2018-04-27 13:30:33','2018-04-27 18:33:38'),(247,1,65,0,NULL,'2018-06-29 03:00:33','2018-06-29 03:00:33'),(248,1,59,1,NULL,'2018-06-29 03:12:15','2018-07-03 08:50:23'),(249,1,64,0,NULL,'2018-06-29 20:12:39','2018-06-29 20:12:39'),(250,1,59,1,NULL,'2018-07-03 04:22:00','2018-07-05 05:01:19'),(251,1,59,1,NULL,'2018-07-05 00:01:28','2018-07-06 08:51:20'),(252,1,60,0,NULL,'2018-07-05 21:20:09','2018-07-05 21:20:09'),(253,1,59,1,NULL,'2018-07-06 06:05:22','2018-07-10 07:59:24'),(254,1,56,1,NULL,'2018-07-06 22:03:54','2018-07-08 08:05:06'),(255,1,57,1,NULL,'2018-07-07 05:32:46','2018-07-14 12:35:23'),(256,1,56,1,NULL,'2018-07-08 22:01:43','2018-07-11 04:28:01'),(257,1,59,1,NULL,'2018-07-10 02:59:30','2018-07-17 04:32:35'),(258,1,56,1,NULL,'2018-07-11 00:10:44','2018-07-12 05:23:09'),(259,1,56,1,NULL,'2018-07-12 01:07:35','2018-07-13 07:25:45'),(260,1,56,1,NULL,'2018-07-13 02:25:50','2018-07-15 04:25:07'),(261,1,57,1,NULL,'2018-07-14 07:35:27','2018-07-18 14:42:00'),(262,1,56,1,NULL,'2018-07-14 23:25:11','2018-07-16 07:48:13'),(263,1,56,1,NULL,'2018-07-16 03:35:04','2018-07-18 08:17:13'),(264,1,59,1,NULL,'2018-07-16 23:32:39','2018-07-22 05:16:56'),(265,1,56,1,NULL,'2018-07-18 04:07:54','2018-07-20 03:22:53'),(266,1,57,1,NULL,'2018-07-18 09:42:38','2018-07-21 13:40:12'),(267,1,56,1,NULL,'2018-07-19 23:11:36','2018-07-21 06:19:43'),(268,1,56,1,NULL,'2018-07-21 02:09:29','2018-07-22 00:23:44'),(269,1,57,0,NULL,'2018-07-21 08:40:18','2018-07-21 08:40:18'),(270,1,56,1,NULL,'2018-07-21 20:31:27','2018-07-22 10:00:30'),(271,1,59,1,NULL,'2018-07-22 00:17:00','2018-07-24 09:48:12'),(272,1,56,0,NULL,'2018-07-22 22:08:05','2018-07-22 22:08:05'),(273,1,59,0,NULL,'2018-07-24 04:48:17','2018-07-24 04:48:17');
/*!40000 ALTER TABLE `rounds` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seg_apps`
--

DROP TABLE IF EXISTS `seg_apps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seg_apps` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `seg_apps_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seg_apps`
--

LOCK TABLES `seg_apps` WRITE;
/*!40000 ALTER TABLE `seg_apps` DISABLE KEYS */;
INSERT INTO `seg_apps` VALUES (1,'Sixteenth Security Group','2018-03-01 07:42:32','2018-03-01 07:42:32');
/*!40000 ALTER TABLE `seg_apps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seg_point_seg_route`
--

DROP TABLE IF EXISTS `seg_point_seg_route`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seg_point_seg_route` (
  `seg_point_id` int(10) unsigned NOT NULL,
  `seg_route_id` int(10) unsigned NOT NULL,
  `position` int(10) unsigned NOT NULL,
  `verification_time` time NOT NULL,
  KEY `seg_point_seg_route_seg_point_id_foreign` (`seg_point_id`),
  KEY `seg_point_seg_route_seg_route_id_foreign` (`seg_route_id`),
  CONSTRAINT `seg_point_seg_route_seg_point_id_foreign` FOREIGN KEY (`seg_point_id`) REFERENCES `seg_points` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `seg_point_seg_route_seg_route_id_foreign` FOREIGN KEY (`seg_route_id`) REFERENCES `seg_routes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seg_point_seg_route`
--

LOCK TABLES `seg_point_seg_route` WRITE;
/*!40000 ALTER TABLE `seg_point_seg_route` DISABLE KEYS */;
INSERT INTO `seg_point_seg_route` VALUES (6,9,1,'16:00:00'),(5,9,2,'16:30:00'),(10,56,1,'00:15:00'),(11,56,2,'00:28:00'),(12,56,3,'00:36:00'),(13,56,4,'00:40:00'),(10,56,5,'01:00:00'),(11,56,6,'01:10:00'),(12,56,7,'01:22:00'),(13,56,8,'01:40:00'),(10,56,9,'02:00:00'),(11,56,10,'02:10:00'),(12,56,11,'02:20:00'),(13,56,12,'02:30:00'),(10,56,13,'02:40:00'),(11,56,14,'02:51:00'),(12,56,15,'03:05:00'),(13,56,16,'03:18:00'),(10,56,17,'03:28:00'),(11,56,18,'03:44:00'),(12,56,19,'03:52:00'),(13,56,20,'04:05:00'),(10,56,21,'04:40:00'),(11,56,22,'04:55:00'),(12,56,23,'05:05:00'),(13,56,24,'05:15:00'),(10,56,25,'05:26:00'),(12,56,26,'05:35:00'),(10,56,27,'05:50:00'),(11,56,28,'06:05:00'),(12,56,29,'06:14:00'),(13,56,30,'06:27:00'),(10,56,31,'06:42:00'),(11,56,32,'06:55:00'),(12,56,33,'07:15:00'),(13,56,34,'07:34:00'),(10,57,1,'08:00:00'),(11,57,2,'08:13:00'),(12,57,3,'08:21:00'),(13,57,4,'08:25:00'),(10,57,5,'08:45:00'),(11,57,6,'08:55:00'),(12,57,7,'09:07:00'),(13,57,8,'09:25:00'),(10,57,9,'09:45:00'),(11,57,10,'09:55:00'),(12,57,11,'10:05:00'),(13,57,12,'10:15:00'),(10,57,13,'10:25:00'),(11,57,14,'10:36:00'),(12,57,15,'10:50:00'),(13,57,16,'11:03:00'),(10,57,17,'11:13:00'),(11,57,18,'11:29:00'),(12,57,19,'11:37:00'),(13,57,20,'11:50:00'),(10,57,21,'12:25:00'),(11,57,22,'12:40:00'),(12,57,23,'12:50:00'),(13,57,24,'13:00:00'),(10,57,25,'13:11:00'),(12,57,26,'13:20:00'),(10,57,27,'13:35:00'),(11,57,28,'13:50:00'),(12,57,29,'13:59:00'),(13,57,30,'14:12:00'),(10,57,31,'14:27:00'),(11,57,32,'14:40:00'),(12,57,33,'15:00:00'),(13,57,34,'15:19:00'),(10,58,1,'16:00:00'),(11,58,2,'16:13:00'),(12,58,3,'16:21:00'),(13,58,4,'16:25:00'),(10,58,5,'16:45:00'),(11,58,6,'16:55:00'),(12,58,7,'17:07:00'),(13,58,8,'17:25:00'),(10,58,9,'17:45:00'),(11,58,10,'17:55:00'),(12,58,11,'18:05:00'),(13,58,12,'18:15:00'),(10,58,13,'18:25:00'),(11,58,14,'18:36:00'),(12,58,15,'18:50:00'),(13,58,16,'19:03:00'),(10,58,17,'19:13:00'),(11,58,18,'19:29:00'),(12,58,19,'19:37:00'),(13,58,20,'19:50:00'),(10,58,21,'20:25:00'),(11,58,22,'20:40:00'),(12,58,23,'20:50:00'),(13,58,24,'21:00:00'),(10,58,25,'21:11:00'),(12,58,26,'21:20:00'),(10,58,27,'21:35:00'),(11,58,28,'21:50:00'),(12,58,29,'21:59:00'),(13,58,30,'22:12:00'),(10,58,31,'22:27:00'),(11,58,32,'22:40:00'),(12,58,33,'23:00:00'),(13,58,34,'23:19:00'),(13,59,1,'22:05:00'),(12,59,2,'22:10:00'),(11,59,3,'22:20:00'),(10,59,4,'22:25:00'),(13,59,5,'22:35:00'),(12,59,6,'22:45:00'),(11,59,7,'23:00:00'),(10,59,8,'23:05:00'),(13,59,9,'23:15:00'),(12,59,10,'23:26:00'),(11,59,11,'23:36:00'),(10,59,12,'23:46:00'),(13,59,13,'00:00:00'),(12,59,14,'00:15:00'),(11,59,15,'00:30:00'),(10,59,16,'00:40:00'),(13,59,17,'00:50:00'),(11,59,18,'01:00:00'),(13,59,19,'01:12:00'),(12,59,20,'01:22:00'),(11,59,21,'01:35:00'),(10,59,22,'01:45:00'),(13,59,23,'02:00:00'),(12,59,24,'02:15:00'),(11,59,25,'02:30:00'),(10,59,26,'02:40:00'),(13,59,27,'02:45:00'),(12,59,28,'03:00:00'),(11,59,29,'03:15:00'),(10,59,30,'03:30:00'),(13,59,31,'04:00:00'),(12,59,32,'04:15:00'),(11,59,33,'04:30:00'),(10,59,34,'04:40:00'),(13,59,35,'04:55:00'),(12,59,36,'05:10:00'),(11,59,37,'05:25:00'),(10,59,38,'05:35:00'),(9,60,1,'23:20:00'),(5,60,2,'23:25:00'),(6,60,3,'23:35:00'),(7,60,4,'23:45:00'),(8,60,5,'00:06:00'),(8,60,6,'00:20:00'),(7,60,7,'00:35:00'),(6,60,8,'00:45:00'),(5,60,9,'01:00:00'),(9,60,10,'01:07:00'),(9,60,11,'01:20:00'),(5,60,12,'01:26:00'),(6,60,13,'01:36:00'),(7,60,14,'01:50:00'),(8,60,15,'02:00:00'),(9,60,16,'02:25:00'),(5,60,17,'02:34:00'),(6,60,18,'02:45:00'),(7,60,19,'03:05:00'),(8,60,20,'03:20:00'),(8,60,21,'03:50:00'),(7,60,22,'04:08:00'),(6,60,23,'04:25:00'),(5,60,24,'04:35:00'),(9,60,25,'04:40:00'),(9,60,26,'05:04:00'),(5,60,27,'05:13:00'),(6,60,28,'05:30:00'),(7,60,29,'05:45:00'),(8,60,30,'06:00:00'),(9,61,1,'23:17:00'),(5,61,2,'23:22:00'),(6,61,3,'23:32:00'),(7,61,4,'23:42:00'),(8,61,5,'00:03:00'),(8,61,6,'00:17:00'),(7,61,7,'00:32:00'),(6,61,8,'00:42:00'),(5,61,9,'00:57:00'),(9,61,10,'01:04:00'),(9,61,11,'01:17:00'),(5,61,12,'01:23:00'),(6,61,13,'01:33:00'),(7,61,14,'01:47:00'),(8,61,15,'01:57:00'),(9,61,16,'02:22:00'),(5,61,17,'02:31:00'),(6,61,18,'02:42:00'),(7,61,19,'03:02:00'),(8,61,20,'03:17:00'),(8,61,21,'03:47:00'),(7,61,22,'04:05:00'),(6,61,23,'04:22:00'),(5,61,24,'04:32:00'),(9,61,25,'04:37:00'),(9,61,26,'05:01:00'),(5,61,27,'05:10:00'),(6,61,28,'05:27:00'),(7,61,29,'05:42:00'),(8,61,30,'05:57:00'),(9,62,1,'23:20:00'),(5,62,2,'23:25:00'),(6,62,3,'23:35:00'),(7,62,4,'23:45:00'),(8,62,5,'00:06:00'),(8,62,6,'00:20:00'),(7,62,7,'00:35:00'),(6,62,8,'00:45:00'),(5,62,9,'01:00:00'),(9,62,10,'01:07:00'),(9,62,11,'01:20:00'),(5,62,12,'01:26:00'),(6,62,13,'01:36:00'),(7,62,14,'01:50:00'),(8,62,15,'02:00:00'),(9,62,16,'02:25:00'),(5,62,17,'02:34:00'),(6,62,18,'02:45:00'),(7,62,19,'03:05:00'),(8,62,20,'03:20:00'),(8,62,21,'03:50:00'),(7,62,22,'04:08:00'),(6,62,23,'04:25:00'),(5,62,24,'04:35:00'),(9,62,25,'04:40:00'),(9,62,26,'05:04:00'),(5,62,27,'05:13:00'),(6,62,28,'05:30:00'),(7,62,29,'05:45:00'),(8,62,30,'06:00:00'),(9,63,1,'23:25:00'),(5,63,2,'23:30:00'),(6,63,3,'23:40:00'),(7,63,4,'23:50:00'),(8,63,5,'00:11:00'),(8,63,6,'00:25:00'),(7,63,7,'00:40:00'),(6,63,8,'00:50:00'),(5,63,9,'01:05:00'),(9,63,10,'01:12:00'),(9,63,11,'01:25:00'),(5,63,12,'01:31:00'),(6,63,13,'01:41:00'),(7,63,14,'01:55:00'),(8,63,15,'02:05:00'),(9,63,16,'02:30:00'),(5,63,17,'02:39:00'),(6,63,18,'02:50:00'),(7,63,19,'03:10:00'),(8,63,20,'03:25:00'),(8,63,21,'03:55:00'),(7,63,22,'04:13:00'),(6,63,23,'04:30:00'),(5,63,24,'04:40:00'),(9,63,25,'04:45:00'),(9,63,26,'05:09:00'),(5,63,27,'05:18:00'),(6,63,28,'05:35:00'),(7,63,29,'05:50:00'),(8,63,30,'06:05:00'),(14,64,1,'22:10:00'),(15,64,2,'22:25:00'),(14,64,3,'23:01:00'),(15,64,4,'23:27:00'),(14,64,5,'00:10:00'),(15,64,6,'00:25:00'),(14,64,7,'01:03:00'),(15,64,8,'01:22:00'),(14,64,9,'02:02:00'),(15,64,10,'02:22:00'),(15,64,11,'03:02:00'),(14,64,12,'03:22:00'),(14,64,13,'04:02:00'),(15,64,14,'04:27:00'),(15,64,15,'05:02:00'),(14,64,16,'05:22:00'),(14,65,1,'22:11:00'),(15,65,2,'22:26:00'),(14,65,3,'23:02:00'),(15,65,4,'23:28:00'),(14,65,5,'00:11:00'),(15,65,6,'00:26:00'),(14,65,7,'01:04:00'),(15,65,8,'01:23:00'),(14,65,9,'02:03:00'),(15,65,10,'02:23:00'),(15,65,11,'03:03:00'),(14,65,12,'03:23:00'),(14,65,13,'04:03:00'),(15,65,14,'04:28:00'),(15,65,15,'05:03:00'),(14,65,16,'05:23:00'),(14,66,1,'22:10:00'),(15,66,2,'22:25:00'),(14,66,3,'23:01:00'),(15,66,4,'23:27:00'),(14,66,5,'00:10:00'),(15,66,6,'00:25:00'),(14,66,7,'01:03:00'),(15,66,8,'01:22:00'),(14,66,9,'02:02:00'),(15,66,10,'02:22:00'),(15,66,11,'03:02:00'),(14,66,12,'03:22:00'),(14,66,13,'04:02:00'),(15,66,14,'04:27:00'),(15,66,15,'05:02:00'),(14,66,16,'05:22:00'),(30,68,1,'01:15:00'),(27,68,2,'01:30:00'),(26,68,3,'01:50:00'),(28,68,4,'02:10:00'),(29,68,5,'02:32:00'),(30,68,6,'03:40:00'),(27,68,7,'04:00:00'),(26,68,8,'04:20:00'),(28,68,9,'04:30:00'),(29,68,10,'04:50:00'),(30,68,11,'06:20:00'),(27,68,12,'06:40:00'),(26,68,13,'07:00:00'),(28,68,14,'07:20:00'),(29,68,15,'07:40:00'),(30,68,16,'08:00:00'),(27,68,17,'08:20:00'),(30,67,1,'17:25:00'),(27,67,2,'17:40:00'),(26,67,3,'18:00:00'),(28,67,4,'18:20:00'),(29,67,5,'18:42:00'),(30,67,6,'19:50:00'),(27,67,7,'20:10:00'),(26,67,8,'20:30:00'),(28,67,9,'20:40:00'),(29,67,10,'21:00:00'),(30,67,11,'22:30:00'),(27,67,12,'22:50:00'),(26,67,13,'23:10:00'),(28,67,14,'23:30:00'),(29,67,15,'23:50:00'),(30,67,16,'00:10:00'),(27,67,17,'00:30:00');
/*!40000 ALTER TABLE `seg_point_seg_route` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seg_points`
--

DROP TABLE IF EXISTS `seg_points`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seg_points` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seg_app_id` int(10) unsigned DEFAULT NULL,
  `client_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `qr_id` char(36) COLLATE utf8_unicode_ci NOT NULL,
  `qr_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `lat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lng` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `seg_points_seg_app_id_foreign` (`seg_app_id`),
  KEY `seg_points_client_id_foreign` (`client_id`),
  CONSTRAINT `seg_points_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `seg_points_seg_app_id_foreign` FOREIGN KEY (`seg_app_id`) REFERENCES `seg_apps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seg_points`
--

LOCK TABLES `seg_points` WRITE;
/*!40000 ALTER TABLE `seg_points` DISABLE KEYS */;
INSERT INTO `seg_points` VALUES (5,1,29,'Juango Silo 1','12d7ab00-2d17-11e8-8ed3-15d9a530c5c6','/images/apps/sixteenth_security_group/12d7ab00-2d17-11e8-8ed3-15d9a530c5c6.png','','-34.8411667','-56.28644444444444','2017-12-06 16:27:49','2018-03-21 14:49:36'),(6,1,29,'Juango Tanques','b9ba1270-daab-11e7-a093-cf1ccb54028a','/images/b9ba1270-daab-11e7-a093-cf1ccb54028a.png','Tanques de GLP','-34.8421389','-56.28794444444444','2017-12-06 16:35:06','2018-03-20 14:18:59'),(7,1,29,'Juango Galpon Perimetro','ed6c74f0-daab-11e7-b97f-c3b440e1c509','/images/ed6c74f0-daab-11e7-b97f-c3b440e1c509.png','Galpón, esquina interior','-34.8446944','-56.28933333333333','2017-12-06 16:37:01','2018-03-20 14:19:15'),(8,1,29,'Juango Talleres','5e3ddf60-daac-11e7-8951-7d55c4f90dad','/images/5e3ddf60-daac-11e7-8951-7d55c4f90dad.png','Exterior Talleres hacia tanques de agua','-34.8431389','-56.28702777777777','2017-12-06 16:39:38','2018-03-20 14:19:26'),(9,1,29,'Juango Oficinas','65d85580-46d5-11e8-b310-f799bd1fe143','/images/apps/sixteenth_security_group/65d85580-46d5-11e8-b310-f799bd1fe143.png','Oficina Ingreso trasero','-34.8418889','-56.286722222222224','2017-12-06 16:48:06','2018-04-23 09:04:58'),(10,1,28,'Dr Selby Porteria','c4f146d0-dab0-11e7-806a-4173fda4ee78','/images/c4f146d0-dab0-11e7-806a-4173fda4ee78.png','','-34.75675295','-55.97561136','2017-12-06 17:12:37','2018-03-20 14:19:49'),(11,1,28,'Dr Selby Tanques de GLP','0e008b60-dab1-11e7-8531-61cf6c7c868c','/images/0e008b60-dab1-11e7-8531-61cf6c7c868c.png','','-34.75553212','-55.97682238','2017-12-06 17:14:57','2018-06-22 14:46:47'),(12,1,28,'Dr Selby F.Core','7ca0ee40-dab1-11e7-b919-159afa02f613','/images/7ca0ee40-dab1-11e7-b919-159afa02f613.png','','-34.75577976','-55.97734373','2017-12-06 17:17:45','2018-03-20 14:20:12'),(13,1,28,'Dr Selby Vertice','cb367200-dab1-11e7-ac4e-f5085c0097c7','/images/cb367200-dab1-11e7-ac4e-f5085c0097c7.png','','-34.7583784','-55.97813632','2017-12-06 17:20:51','2018-03-20 14:20:25'),(14,1,32,'OSE Pando Portería','d05c20c0-dac1-11e7-b0ed-37017052793b','/images/d05c20c0-dac1-11e7-b0ed-37017052793b.png','','-34.70519932','-55.94581369','2017-12-06 19:16:39','2018-04-04 15:56:00'),(15,1,32,'OSE Pando Fondo','622465e0-dac2-11e7-8d52-291321580389','/images/622465e0-dac2-11e7-8d52-291321580389.png','','-34.70492369','-55.94566081','2017-12-06 19:18:28','2018-04-04 15:56:12'),(20,1,34,'HOSPITAL ESPAÑOL','256edb90-158b-11e8-99b7-f54e8ff7df6e','/images/256edb90-158b-11e8-99b7-f54e8ff7df6e.png','','-34.8749769','-56.1813768','2018-02-19 14:41:05','2018-06-22 14:47:26'),(24,1,32,'OSE Fondo','c0e54330-73d0-11e8-9dda-bf8e02f4f841','/images/apps/sixteenth_security_group/c0e54330-73d0-11e8-9dda-bf8e02f4f841.png','','-34.70497996','-55.94610101','2018-04-16 16:15:16','2018-06-19 14:55:06'),(26,1,39,'Air Liquide comedor','cb0c3960-8f74-11e8-a484-8d21eac77445','/images/apps/sixteenth_security_group/cb0c3960-8f74-11e8-a484-8d21eac77445.png','','-34.78072036','-56.35966089','2018-07-24 19:27:02','2018-07-24 19:29:17'),(27,1,39,'Air Liquide galpon','def7cb60-8f77-11e8-a3a6-4dce152f4ef4','/images/apps/sixteenth_security_group/def7cb60-8f77-11e8-a3a6-4dce152f4ef4.png','','-34.78059649','-56.36029607','2018-07-24 19:32:58','2018-07-24 19:32:58'),(28,1,39,'Air Liquide incendio','650f0aa0-8f78-11e8-8c21-5d04e8210fa3','/images/apps/sixteenth_security_group/650f0aa0-8f78-11e8-8c21-5d04e8210fa3.png','','-34.77998488','-56.35919401','2018-07-24 19:37:58','2018-07-24 19:37:58'),(29,1,39,'Air Liquide vertice','3029fbb0-8f79-11e8-b73e-7d2405f30f44','/images/apps/sixteenth_security_group/3029fbb0-8f79-11e8-b73e-7d2405f30f44.png','','-34.77959825','-56.36010731','2018-07-24 19:40:08','2018-07-24 19:40:08'),(30,1,39,'Air Liquide garita fondo','9d0c1c40-8f79-11e8-833e-2bfe2872fba5','/images/apps/sixteenth_security_group/9d0c1c40-8f79-11e8-833e-2bfe2872fba5.png','','-34.77981135','-56.36018762','2018-07-24 19:43:10','2018-07-24 19:43:10'),(31,1,28,'vertice tanque','a197cbe0-9033-11e8-aa2f-239681b98a66','/images/apps/sixteenth_security_group/a197cbe0-9033-11e8-aa2f-239681b98a66.png','','-34.75544839','-55.9769289','2018-07-25 17:54:37','2018-07-25 17:54:37'),(32,1,28,'vertice edificio 1','1400fcd0-9034-11e8-a505-95b4e3da5ab8','/images/apps/sixteenth_security_group/1400fcd0-9034-11e8-a505-95b4e3da5ab8.png','','-34.75632979','-55.97645609','2018-07-25 17:57:32','2018-07-25 17:57:32'),(33,1,28,'Entrada edificio 2','54599b70-9034-11e8-a758-8daf5058bea0','/images/apps/sixteenth_security_group/54599b70-9034-11e8-a758-8daf5058bea0.png','','-34.75628918','-55.97685252','2018-07-25 18:00:24','2018-07-25 18:00:24'),(34,1,28,'Interno galpon 2 (1)','a0af9ff0-9034-11e8-94e7-6bd361a2b1d7','/images/apps/sixteenth_security_group/a0af9ff0-9034-11e8-94e7-6bd361a2b1d7.png','','-34.7561834','-55.97667952','2018-07-25 18:02:20','2018-07-25 18:02:20'),(35,1,28,'Interno galpon (2)','ee85e400-9034-11e8-a240-1f6c34d016b8','/images/apps/sixteenth_security_group/ee85e400-9034-11e8-a240-1f6c34d016b8.png','','-34.75617128','-55.97684514','2018-07-25 18:05:06','2018-07-25 18:05:06');
/*!40000 ALTER TABLE `seg_points` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seg_routes`
--

DROP TABLE IF EXISTS `seg_routes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seg_routes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seg_app_id` int(10) unsigned DEFAULT NULL,
  `client_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tz_offset` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alarm_delta` int(10) unsigned NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `alert_email` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `seg_routes_user_id_foreign` (`user_id`),
  KEY `seg_routes_seg_app_id_foreign` (`seg_app_id`),
  KEY `seg_routes_client_id_foreign` (`client_id`),
  CONSTRAINT `seg_routes_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `seg_routes_seg_app_id_foreign` FOREIGN KEY (`seg_app_id`) REFERENCES `seg_apps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `seg_routes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seg_routes`
--

LOCK TABLES `seg_routes` WRITE;
/*!40000 ALTER TABLE `seg_routes` DISABLE KEYS */;
INSERT INTO `seg_routes` VALUES (9,1,3,25,'test','-3',20,'','','2018-02-16 16:56:45','2018-02-22 16:18:44'),(56,1,28,31,'Aleman Dr Selby','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 14:53:05','2018-06-28 14:53:05'),(57,1,28,38,'BRYAN Dr Selby','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 15:26:36','2018-06-28 15:26:36'),(58,1,28,22,'ITSVAN Dr Selby','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 15:28:31','2018-06-28 15:28:31'),(59,1,28,35,'jacobo Dr Selby','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 15:30:49','2018-06-28 15:30:49'),(60,1,29,36,'sandy  juango','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 16:26:21','2018-06-28 16:26:21'),(61,1,29,22,'istvan  juango','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 16:59:09','2018-06-28 16:59:09'),(62,1,29,35,'jacobo  juango','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 17:00:10','2018-06-28 17:00:10'),(63,1,29,21,'jonathan  juango','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 17:01:17','2018-06-28 17:01:17'),(64,1,32,33,'cabrera ose','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 17:05:56','2018-06-28 17:15:34'),(65,1,32,35,'jacobo ose','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 17:16:43','2018-06-28 17:16:43'),(66,1,32,22,'itsvan ose','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-06-28 17:17:43','2018-06-28 17:17:43'),(67,1,39,41,'Francisco Air Liquide','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-07-24 20:26:55','2018-07-24 20:26:55'),(68,1,39,40,'Fernanda Air Liquide','America/Montevideo',15,'','mregalado@ssg.com.uy','2018-07-24 20:45:10','2018-07-24 20:45:10');
/*!40000 ALTER TABLE `seg_routes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seg_app_id` int(10) unsigned DEFAULT NULL,
  `default_tz_offset` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alarm_delta` int(10) unsigned NOT NULL,
  `alert_email` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `settings_seg_app_id_foreign` (`seg_app_id`),
  CONSTRAINT `settings_seg_app_id_foreign` FOREIGN KEY (`seg_app_id`) REFERENCES `seg_apps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,1,'America/Montevideo',15,'seguridad@gdcreator.net; mregalado@ssg.com.uy','2018-03-01 07:42:33','2018-03-20 15:27:18');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seg_app_id` int(10) unsigned DEFAULT NULL,
  `client_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `encrypted_password` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `api_token` char(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `domicilio` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `localidad` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `departamento` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `telefono` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cedula` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `vencimiento_carnet` date DEFAULT NULL,
  `vencimiento_digefe` date DEFAULT NULL,
  `ingreso_empresa` date DEFAULT NULL,
  `telefono_empresa` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description_2` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_seg_app_id_foreign` (`seg_app_id`),
  KEY `users_client_id_foreign` (`client_id`),
  CONSTRAINT `users_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `users_seg_app_id_foreign` FOREIGN KEY (`seg_app_id`) REFERENCES `seg_apps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,NULL,NULL,'super admin','super_admin@gdcrouter.com','$2y$10$Yi/yW1Sf0SmMMPJkf.Vg2.lQ1hssDYpsJuyPxslNJ.SxTtbM33nzK',NULL,'A4qtzIRLv1qLCI8kDug5lkDitQHUrTX8QykRnp3aEl8IGCf2Q0BVPaA83MmG',NULL,'','','','','','',NULL,NULL,NULL,'','','2018-03-01 07:42:24','2018-03-01 07:42:24'),(2,1,NULL,'admin_sixteenth_security_group','admin_sixteenth_security_group@gdcrouter.com','$2y$10$icchQMuPPzVfFfAtVxjLGOMf37r3/KIQbhOYXwoHBtU5nRINRNFlO','eyJpdiI6IkhCUTY4VkF6U290b0lzRVlcL1BXcEdRPT0iLCJ2YWx1ZSI6ImVncDVFXC9rblVsSDk2WmFERHYyV3p3PT0iLCJtYWMiOiJhYmUxNmEwYTkyNDQwMGYwYWZiZTYxZmM4ZTA0ZWQyYTYzMWM3OTE3YTY1YzNjYTZhN2I2MDMyZjJjZDM4NmQwIn0=','yE7zclCtfh2wLT0HlNRIworDrDjMNG5Z8spSGSNg59a7c7nKJRlzN0q3LCYO',NULL,'','','','','','',NULL,NULL,NULL,'',NULL,'2018-03-01 07:42:33','2018-03-01 07:42:33'),(3,1,NULL,'Cliente 1','cliente1@gdcrouter.com','$2y$10$K4hUdlCnitK1Csp3VET31eaJ0n.69sHD58TTcQc4aNruCcDORQKKu',NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,'',NULL,'2018-03-01 07:43:17','2018-03-01 07:43:17'),(15,1,3,'Darwin','djlorenzo@ssg.com.uy','$2y$10$uOisHqaHAdblCYBtXKR.xeQrNcer9v7XDUvUXwX4vWqykAIwhVl3G',NULL,NULL,'24a648d0-9f91-11e7-a831-07116a7827fa','Prueba 2 UY','','','','','','1970-01-01','1970-01-01','1970-01-01','','','2017-09-22 10:25:39','2018-02-15 20:32:36'),(17,1,3,'HUGO DANIEL ROSALES PORTILLO','hrosales@ssg.com','$2y$10$YwtgJUnXgaEf2zvDDjTSMuV99kLFAG0qZgPBV/favFq3I5RVdZehy',NULL,NULL,'64b83740-daa6-11e7-b661-3994175aad24','RAP MALDONADO','','','','','','1970-01-01','1970-01-01','1970-01-01','','','2017-12-06 15:56:24','2018-04-04 13:57:52'),(18,1,3,'WALTER PEREZ MARTINEZ','wperez@ssg.com','$2y$10$tyExalf4YgvVhdxRYqWTWe0mJoDz6QU1YSg28lYDOXgBfbBjLaBjq',NULL,NULL,'81050220-daa6-11e7-b051-730c732aa5d0','RAP MALDONADO','','','','','',NULL,NULL,NULL,'','','2017-12-06 15:57:12','2017-12-06 15:57:12'),(21,1,29,'JONATHAN AGUIRRE','jaguirre@ssg.com','$2y$10$eHWbChjann3Z5WFmqHctmee2tIHjwRnBcriIKdnr63bVOI8q7XK5u',NULL,NULL,'a9b5c750-daa8-11e7-81b7-9f679944f89f','JUANGO','','','','','','1970-01-01','1970-01-01','1970-01-01','','','2017-12-06 16:12:39','2018-03-20 14:17:29'),(22,1,3,'itsvan castillo','icastillo@ssg.com','$2y$10$dM67ST7pEihfIOGGERMOLe.sCFU6nuauO8hq54FlXj7vRkFPDVeWu',NULL,NULL,'c7f51990-ffc4-11e7-947d-b17d3a972af4','juango,dr selby','','','','','','1970-01-01','1970-01-01','1970-01-01','','','2018-01-22 21:37:09','2018-02-15 20:32:46'),(24,1,3,'MAURICIO','mregalado@ssg.com.uy','$2y$10$mQw2jdcR5Jmpdiu8nIjjI.Zwf7foLtngL2KJT6FasKbapYE/ANoyG',NULL,NULL,'226c6470-020a-11e8-8fd4-33e5353760e5','','','','','','',NULL,NULL,NULL,'','','2018-01-25 18:58:38','2018-01-25 18:58:38'),(25,1,3,'demo','demo@site.com','$2y$10$LqNT6iCnMgJSLxR0DVFlbu.8q9nvdx/WS2oaMumNXbFR0qNFV62zq',NULL,NULL,'a42480c0-1342-11e8-a770-25bf6c729b10','','','','','','','1970-01-01','1970-01-01','1970-01-01','','','2018-02-16 16:55:57','2018-06-25 08:05:07'),(28,1,NULL,'Dr. Selby - Terry SA','gabriel@selby.com.uy','$2y$10$4k1YN8sLIUyaMvY3CBRxB.U6RzxC.O8eQgOJqG.OO/2i.FKgGFQQW',NULL,'i78ZkBLlZiTC3BXSx6ivcs823opauiokc3Avi2ok3WBVnDZbtCs9ZUASYgeS',NULL,'','','','','','',NULL,NULL,NULL,'',NULL,'2018-03-20 14:14:20','2018-07-03 16:03:00'),(29,1,NULL,'Juango Logística','ldominguez@juango.com.uy','$2y$10$rXT8vZ8DGHJ2cYORE1/ieu96A6Ng4RWJc0/dTP/IqiYc3q1UQUcLC',NULL,'xS9E6aUjSdaI89PKZJTEOQmVlpNQc6DdmyCfF5qyzdesX7ZDIAgQ56FlpEg0',NULL,'','','','','','',NULL,NULL,NULL,'',NULL,'2018-03-20 14:15:28','2018-04-16 16:25:06'),(31,1,28,'Federico Aleman','faleman@ssg.com.uy','$2y$10$gzY1uXa/LIkR3fvucAd8rusMtslLrqdwqRINhrkvykWaQNLt01eFy',NULL,NULL,'7ba8bfa0-3820-11e8-b515-8da0e22217a5','','Camino Las Rosas s/n','Villa Olmos','Canelones','093630119','4.597.956-3','1970-01-01','1970-01-01','1970-01-01','094911103','','2018-04-04 15:54:39','2018-04-24 20:09:33'),(32,1,NULL,'OSE Pando','administracion@ssg.com.uy','$2y$10$q.C7GOdQOx/tpRKWmH9RUOMg.DE7SMZ8AhIr1NTszyHMlIiJ3ZnUS',NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,'',NULL,'2018-04-04 15:55:30','2018-04-04 15:55:30'),(33,1,32,'Julio Cabrera','jcabrera@ssg.com','$2y$10$ce8awTY///KvnlJlBZxs..X97Td6KxY/59i5HDolZWnsZUsP3luRG',NULL,NULL,'05157220-390c-11e8-9ade-b34273e80641','','','','','','3.564.379-8',NULL,NULL,'2017-09-11','','','2018-04-05 20:00:42','2018-04-05 20:00:42'),(34,1,NULL,'Hospital Español','intendenciaespanol@asse.com.uy','$2y$10$TpGCEIRVm1zRsNWRlD3zJ.qc5CPqEAUNZcvZe939UAqUEa0mB51PC',NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,'',NULL,'2018-04-11 14:33:04','2018-04-11 14:33:04'),(35,1,29,'Jacobo','jacobo@ssg.com','$2y$10$54lKlK9Cn2h8/TRlucuB7uBeNGZjJb9a2F5iu90qtFMSQOh4Qwx86',NULL,NULL,'43ccd920-426f-11e8-88be-69e8834cef5f','','Minas 1824','centro','Montevideo','094187168','6.311.552-3',NULL,NULL,'2018-03-17','','','2018-04-17 18:43:48','2018-04-17 18:43:48'),(36,1,29,'SANDY GOTERA','sgotera@ssg.com.uy','$2y$10$6PpL9qaCtxubGZ47EOL4u.fiVb/XnGUTaLLv0dOOjx/jH5UYOMbcu',NULL,NULL,'05121a50-4893-11e8-b7d9-7de21d6f6a22','','J.L.CUESTAS 1484','CIUDAD VIEJA','Montevideo','093533978','',NULL,NULL,'2018-04-12','mregalado@ssg.com.uy','CORREA CARGADOR DE CELL TONFA YPORTA TONFA Y UNIFORME COMPLETO','2018-04-25 14:14:51','2018-04-25 14:14:51'),(38,1,28,'Bryan Rivera','brivera@ssg.com','$2y$10$PlxEN/vAHJmOz7aO.nCG7eITewNuALcgbEXsRGi42KT0Nq8qtFu0C',NULL,NULL,'1edbe2f0-6fef-11e8-a5d2-3350fea3a44e','','','','','091972940','4.368.826-','1970-01-01','1970-01-01','2018-06-26','mregalado@ssg.com.uy','','2018-06-14 16:22:24','2018-06-14 16:26:45'),(39,1,NULL,'Air Liquide','cecilia.helguera@airliquide.com','$2y$10$V0PM5ybnvi/WhxxO7Z/QxuCatKJmstrJDqeMqXJ0/KUzVUvq5Xxvi',NULL,NULL,NULL,'','','','','','',NULL,NULL,NULL,'',NULL,'2018-07-24 19:06:49','2018-07-24 19:06:49'),(40,1,39,'Fernanda Zagazazu','fzagazazu@ssg.com','$2y$10$rCRPUE7G67LIxqKf1rTCBuHSk3AdEaLTEO5OXCicGloRku6EjZ3zC',NULL,NULL,'c3010670-8f7c-11e8-8dd1-332ef640100d','','oficial 2 5839','nuevo paris','Montevideo','094142753','4.533.938-7','1970-01-01','1970-01-01','2018-07-09','','Pantalon,campera, remera,cinto,porta tonfa','2018-07-24 20:04:24','2018-07-24 20:47:03'),(41,1,39,'Francisco Castillo','fcastillo@ssg.com','$2y$10$Sr2dBikUT7zgjoZBIdYwaOe89VkWnMdWbsDpsApVRBDrA169yeZG2',NULL,NULL,'52ae58e0-8f7d-11e8-a7f2-d797dc3b5fca','','andes 1170','centro','Montevideo','097801084','i683045','1970-01-01','1970-01-01','2018-07-09','','pantalon, campera, remera, cinto ,porta tonfa,tonfa, cell, linterna,equipo de agua','2018-07-24 20:08:25','2018-07-24 20:47:27');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'gdcrouter'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-07-27  1:45:47