(181207,29,'0000489973','0081080700','2016-08-31','18:59:48','2016-09-07','2016-08-31','18:59:00',0,0,'BFHX84','CLV02C','0005032523','Ebco - Ascotan','Antofagasta','02','Lima 156','CL','Quilicura','CV02','Juan Palacios \r',0,NULL,NULL,NULL,NULL,NULL),(181208,29,'0000489720','0081079642','2016-08-31','08:36:14','2016-09-01','2016-08-31','08:36:00',0,0,'bzsw66','CLA13','0005000879','Soc. Industrial Romeral S.A.','Puente Alto','13','Av. Santa Rosa 01998','CL','Puente Alto','AV02','Fernando Cabrera\r',0,NULL,NULL,NULL,NULL,NULL),(181209,29,'0000489964','0081079960','2016-08-31','18:14:55','2016-09-07','2016-08-31','18:14:00',0,0,'YU4094','CLV13','0005039738','Inarco - Edificio Habitacional','Lo Barnechea','13','Av. La Dehesa  100','CL','Renca','CV02','Juan Gutierrez B \r',0,NULL,NULL,NULL,NULL,NULL),(181210,29,'0000489742','0081079919','2016-08-31','09:24:43','2016-09-02','2016-08-31','09:32:00',0,0,'HCCX39','CLV13','0005033816','Almagro - Lyon 2440','Providencia','13','Ricardo Lyon 2440','CL','Providencia','CV02','Gerald Araneda \r',0,NULL,NULL,NULL,NULL,NULL),(181211,29,'0000489910','0081079961','2016-08-31','15:43:51','2016-09-02','2016-08-31','15:43:00',0,0,'FSLF12','CLV13','0005039738','Inarco - Edificio Habitacional','Lo Barnechea','13','Av. La Dehesa  100','CL','Renca','CV02','Hector Rios \r',0,NULL,NULL,NULL,NULL,NULL),(181212,29,'0000489893','0081080589','2016-08-31','15:07:10','2016-09-02','2016-08-31','15:06:00',0,0,'DKYV75','CLA13','0005006711','Avellaneda - Padre Hurtado','Padre Hurtado','13','Ferrocarril 150','CL','Renca','AV02','Cristhian Veli\r',0,NULL,NULL,NULL,NULL,NULL),(181213,29,'0000489909','0081080585','2016-08-31','15:38:40','2016-09-02','2016-08-31','15:38:00',0,0,'HDJS20','CLA13','0005040199','Ingevec - Edificio Pedro Alarcon Pe','San Miguel','13','San Francisco  3536','CL','Renca','AV02','Juan Pere\r',0,NULL,NULL,NULL,NULL,NULL),(181214,29,'0000489906','0081079955','2016-08-31','15:33:55','2016-09-02','2016-08-31','15:33:00',0,0,'RE1466','CLV13','0005039738','Inarco - Edificio Habitacional','Lo Barnechea','13','Av. La Dehesa  100','CL','Renca','CV02','Danilo Alvarez\r',0,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `gpswsdata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gpswsfiles`
--

DROP TABLE IF EXISTS `gpswsfiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gpswsfiles` (
  `idfile` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `fechacarga` datetime DEFAULT NULL,
  PRIMARY KEY (`idfile`),
  UNIQUE KEY `idfile_UNIQUE` (`idfile`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1 COMMENT='Nombre de archivos cargados en el sistema';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gpswsfiles`
--

LOCK TABLES `gpswsfiles` WRITE;
/*!40000 ALTER TABLE `gpswsfiles` DISABLE KEYS */;
INSERT INTO `gpswsfiles` VALUES (6,'5_4_GPS-20160103.txt','2016-01-15 16:53:09'),(7,'6_5_4_GPS-20160103.txt','2016-01-18 11:01:07'),(8,'7_6_5_4_GPS-20160103.txt','2016-01-27 18:23:56'),(9,'8_7_6_5_4_GPS-20160103.txt','2016-01-27 18:53:59'),(10,'9_8_7_6_5_4_GPS-20160103.txt','2016-01-28 20:28:27'),(11,'GPS-20160818.txt','2016-08-30 13:07:42'),(12,'11_GPS-20160818.txt','2016-08-30 13:22:43'),(13,'12_11_GPS-20160818.txt','2016-08-30 13:25:51'),(14,'13_12_11_GPS-20160818.txt','2016-08-30 13:28:54'),(15,'14_13_12_11_GPS-20160818.txt','2016-08-30 13:29:30'),(16,'15_14_13_12_11_GPS-20160818.txt','2016-08-30 13:33:34'),(17,'16_15_14_13_12_11_GPS-20160818.txt','2016-08-30 13:33:40'),(18,'GPS-20160907.txt','2016-09-09 11:11:02'),(19,'GPS-20160907.txt','2016-09-14 10:55:35'),(20,'GPS-20160907.txt','2016-09-14 10:56:39'),(21,'GPS-20160907.txt','2016-09-14 10:57:10'),(22,'GPS-20160907.txt','2016-09-14 10:57:19'),(23,'GPS-20160907.txt','2016-09-14 10:59:05'),(24,'GPS-20160907.txt','2016-09-14 10:59:44'),(25,'GPS-20160907.txt','2016-09-14 10:59:54'),(26,'GPS-20160907.txt','2016-09-14 11:00:48'),(27,'GPS-20160907.txt','2016-09-14 11:01:46'),(28,'GPS-20160907.txt','2016-09-14 11:04:46'),(29,'GPS-20160907.txt','2016-09-14 11:09:04');
/*!40000 ALTER TABLE `gpswsfiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gpswslog`
--

DROP TABLE IF EXISTS `gpswslog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gpswslog` (
  `idgpswslog` int(11) NOT NULL AUTO_INCREMENT,
  `transporte` varchar(45) DEFAULT NULL,
  `asunto` varchar(200) DEFAULT NULL,
  `descripcion` varchar(1000) DEFAULT NULL,
  `estado` varchar(15) DEFAULT NULL,
  `request` text,
  `fecha` datetime DEFAULT NULL,
  PRIMARY KEY (`idgpswslog`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=latin1 COMMENT='Tabla de Log de Transporte';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gpswslog`
--

LOCK TABLES `gpswslog` WRITE;
/*!40000 ALTER TABLE `gpswslog` DISABLE KEYS */;
INSERT INTO `gpswslog` VALUES (1,'','ERROR IDCHOFER','Chofer no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:04:47'),(2,'','ERROR IDCHOFER','Chofer no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:09:05'),(3,'0000486226','ERROR IDCHOFER','Chofer no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:18:08'),(4,'0000486869','ERROR IDCHOFER','Chofer no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:18:26'),(5,'0000489822','ERROR IDCHOFER','Chofer Edgardo Aravena\rno encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:18:57'),(6,'0000488905','ERROR IDCHOFER','Chofer Jose Ulloa\rno encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:19:06'),(7,'0000489016','ERROR IDCHOFER','Chofer Victor Muñoz\rno encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:45:35'),(8,'0000488596','ERROR IDCHOFER','Chofer Igor Reye\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:45:48'),(9,'0000486426','ERROR IDCHOFER','Chofer Claudio Pin\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:45:58'),(10,'0000485500','ERROR IDGPS','Patente BCBT28 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:46:03'),(11,'0000486972','ERROR IDGPS','Patente WR8574 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:48:17'),(12,'0000489090','ERROR IDGPS','Patente FPFD59 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:48:23'),(13,'0000488107','ERROR IDCHOFER','Chofer Miguel Saravia\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:27'),(14,'0000488309','ERROR IDGPS','Patente WJ4686 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:48:34'),(15,'0000489264','ERROR IDCHOFER','Chofer Cesar Palma\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:35'),(16,'0000486455','ERROR IDGPS','Patente WR8574 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:48:36'),(17,'0000487176','ERROR IDGPS','Patente DKYV75 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:48:37'),(18,'0000489362','ERROR IDGPS','Patente FPFD59 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:48:38'),(19,'0000487775','ERROR IDCHOFER','Chofer Fernando Quilodra\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:38'),(20,'0000487999','ERROR IDCHOFER','Chofer Alejandro Valdebenit\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:39'),(21,'0000487783','ERROR IDCHOFER','Chofer Ciro Leichtle\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:39'),(22,'0000489189','ERROR IDCHOFER','Chofer Hugo Tor\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:40'),(23,'0000489756','ERROR IDCHOFER','Chofer Roberto Espinoza\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:41'),(24,'0000488097','ERROR IDCHOFER','Chofer Daniel Acuña\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:41'),(25,'0000488897','ERROR IDCHOFER','Chofer Ivan Barrera\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:42'),(26,'0000489149','ERROR IDCHOFER','Chofer Sandro Puelles\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:43'),(27,'0000485681','ERROR IDCHOFER','Chofer Ariel Meneses\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:43'),(28,'0000485751','ERROR IDCHOFER','Chofer Gabriel Araya\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:44'),(29,'0000487875','ERROR IDCHOFER','Chofer Cristian Herrera\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:44'),(30,'0000486269','ERROR IDCHOFER','Chofer Jaime Enrique\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:45'),(31,'0000485879','ERROR IDGPS','Patente WY7855 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:48:46'),(32,'0000487045','ERROR IDCHOFER','Chofer Robinson Cuevas\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:46'),(33,'0000486964','ERROR IDCHOFER','Chofer Rodrigo Ramo\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:47'),(34,'0000489388','ERROR IDCHOFER','Chofer Geraldo Aranda\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:59'),(35,'0000484971','ERROR IDCHOFER','Chofer Erick Gonzalez\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:48:59'),(36,'0000487561','ERROR IDCHOFER','Chofer Claudio Vicuña\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:49:00'),(37,'0000485411','ERROR IDGPS','Patente YB1302 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:49:01'),(38,'0000488185','ERROR IDCHOFER','Chofer Hugo Araya\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:49:01'),(39,'0000485541','ERROR IDCHOFER','Chofer Luis Sepulved\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:49:02'),(40,'0000485360','ERROR IDCHOFER','Chofer Cristian Muño\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:49:03'),(41,'0000486355','ERROR IDCHOFER','Chofer Radomiro Mora\r no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:49:03'),(42,'0000487028','ERROR IDGPS','Patente WJ4686 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:49:04'),(43,'0000484968','ERROR IDCHOFER','Chofer Cesar Jerez no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:51:10'),(44,'0000485156','ERROR IDCHOFER','Chofer Felipe Mora no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:51:10'),(45,'0000487769','ERROR IDCHOFER','Chofer Claudio Pin no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:51:11'),(46,'0000484464','ERROR IDCHOFER','Chofer Freddy Orellana no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:51:11'),(47,'0000484926','ENVIADO LOJACK','<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><soap:Fault><faultcode>soap:Client</faultcode><faultstring>System.Web.Services.Protocols.SoapException: Server was unable to read request. ---&gt; System.InvalidOperationException: There is an error in XML document (8, 29). ---&gt; System.FormatException: Input string was not in a correct format.\r\n   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer&amp; number, NumberFormatInfo info, Boolean parseDecimal)\r\n   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)\r\n   at System.Xml.XmlConvert.ToInt32(String s)\r\n   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read1_NullableOfInt32(Boolean checkType)\r\n   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read24_CrearViaj','ENVIADO',NULL,'2016-09-14 11:51:21'),(48,'0000484315','ERROR IDCHOFER','Chofer Carlos Opazo no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:51:21'),(49,'0000484493','ERROR IDCHOFER','Chofer Luis Rodriguez no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:51:21'),(50,'0000489126','ERROR IDGPS','Patente DKYV75 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:51:21'),(51,'0000484484','ERROR IDCHOFER','Chofer Fernando Vergar no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:51:21'),(52,'0000488193','ERROR IDGPS','Patente HKRW59 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:51:21'),(53,'0000488562','ERROR IDCHOFER','Chofer Fernando Vergar no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:55:25'),(54,'0000485943','ERROR IDCHOFER','Chofer Roberto Espinoza no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:55:25'),(55,'0000484945','ERROR IDCHOFER','Chofer Freddy Orellana no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:55:25'),(56,'0000488743','ENVIADO LOJACK','<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><CrearViajeResponse xmlns=\"http://tempuri.org/\"><CrearViajeResult>224069</CrearViajeResult></CrearViajeResponse></soap:Body></soap:Envelope>','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488743</Descripcion>\r\n							<idGPS>171063</idGPS>\r\n							<Patente>BRYX77</Patente>\r\n							<idChofer>34197</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>3</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.5191</float>\n<float>-33.5185</float>\n<float>-33.5157</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.5972</float>\n<float>-70.5956</float>\n<float>-70.5869</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>L y D - Clinica Vespucio</string>\n<string>L y D - Habilitacion Torre B (C.Ves</string>\n<string>Roberto Cayulao - El Parque</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-23T09:31:00</dateTime>\n<dateTime>2016-11-23T09:50:46</dateTime>\n<dateTime>2016-11-23T09:34:59</dateTime>\n<dateTime>2016-11-23T09:34:16</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-23T10:01:00</dateTime>\n<dateTime>2016-11-23T09:50:46</dateTime>\n<dateTime>2016-11-23T09:34:59</dateTime>\n<dateTime>2016-11-23T09:34:16</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>15335</int>\n<int>898</int>\n<int>1367</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Serafin Zamora 190</string>\n<string>Americo Vespucio  6775</string>\n<string>Av El Parque 1630</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>La Florida</string>\n<string>La Florida</string>\n<string>La Florida</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>La Florida</string>\n<string>La Florida</string>\n<string>La Florida</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488743 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 11:55:30'),(57,'0000485495','ERROR IDCHOFER','Chofer Alexis Pizarro no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:55:30'),(58,'0000488405','ERROR IDCHOFER','Chofer Jimmy Bicher no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:55:30'),(59,'0000485703','ENVIADO LOJACK','<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><soap:Fault><faultcode>soap:Client</faultcode><faultstring>System.Web.Services.Protocols.SoapException: Server was unable to read request. ---&gt; System.InvalidOperationException: There is an error in XML document (55, 12). ---&gt; System.FormatException: Input string was not in a correct format.\r\n   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer&amp; number, NumberFormatInfo info, Boolean parseDecimal)\r\n   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)\r\n   at System.Xml.XmlConvert.ToInt32(String s)\r\n   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read24_CrearViaje()\r\n   at Microsoft.Xml.Serialization.GeneratedAssembly.ArrayOfObjectSerializer20.Deserialize(XmlSerializationReader','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000485703</Descripcion>\r\n							<idGPS>171063</idGPS>\r\n							<Patente>BRYX77</Patente>\r\n							<idChofer>34197</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>3</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.6049</float>\n<float>-33.7328</float>\n<float>-33.7337</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6825</float>\n<float>-70.6898</float>\n<float>-70.6866</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Baquedano - P.H. Magallanes</string>\n<string>Convet - CF4018 Los Almendros de Bu</string>\n<string>Luis Antonio Sepulveda Fuentes</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-07T07:29:00</dateTime>\n<dateTime>2016-11-07T07:29:00</dateTime>\n<dateTime>2016-11-07T07:29:00</dateTime>\n<dateTime>2016-11-07T07:29:00</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-07T07:59:00</dateTime>\n<dateTime>2016-11-07T07:29:00</dateTime>\n<dateTime>2016-11-07T07:29:00</dateTime>\n<dateTime>2016-11-07T07:29:00</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int></int>\n<int></int>\n<int></int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Av. Padre Hurtado esq. Marisc 16190</string>\n<string>Camino El Arpa. 1530</string>\n<string>Rogelio Ugarte. Alto Jahuel 129</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>San Bernardo</string>\n<string>Buin</string>\n<string>Buin</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>San Bernardo</string>\n<string>Buin</string>\n<string>Buin</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000485703 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 11:55:35'),(60,'0000485255','ERROR IDCHOFER','Chofer  no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:55:35'),(61,'0000487920','ERROR IDCHOFER','Chofer Pedro Muñoz no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 11:55:36'),(62,'0000484351','ERROR IDGPS','Patente WR8574 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 11:55:36'),(63,'0000486833','ERROR IDCHOFER','Chofer Sergio Andrade no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:00:44'),(64,'0000484691','ERROR IDCHOFER','Chofer Ariel Meneses no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:00:54'),(65,'0000486314','ERROR IDCHOFER','Chofer Carlos Aros no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:00:55'),(66,'0000487489','ERROR IDGPS','Patente DRSF72 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:00:57'),(67,'0000489798','ERROR IDGPS','Patente YV4085 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:00:58'),(68,'0000489799','ERROR IDCHOFER','Chofer Gabriel Araya no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:00:59'),(69,'0000487603','ERROR IDCHOFER','Chofer Hector Cistern no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:01:23'),(70,'0000487900','ERROR IDCHOFER','Chofer Rodrigo Ramo no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:01:26'),(71,'0000488535','ERROR IDGPS','Patente WJ5285 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:01:26'),(72,'0000489001','ENVIADO LOJACK','<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><CrearViajeResponse xmlns=\"http://tempuri.org/\"><CrearViajeResult>224073</CrearViajeResult></CrearViajeResponse></soap:Body></soap:Envelope>','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000489001</Descripcion>\r\n							<idGPS>128813</idGPS>\r\n							<Patente>FVPJ34</Patente>\r\n							<idChofer>34193</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>3</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.6158</float>\n<float>-33.5468</float>\n<float>-33.549</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6849</float>\n<float>-70.6061</float>\n<float>-70.5875</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Ormuz - Edificio Las Brisas</string>\n<string>Acero Sur / La Florida</string>\n<string>Centro Comercial Vicuña Mackenna</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-24T09:17:00</dateTime>\n<dateTime>2016-11-24T09:17:00</dateTime>\n<dateTime>2016-11-24T09:35:44</dateTime>\n<dateTime>2016-11-24T09:22:33</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-24T09:47:00</dateTime>\n<dateTime>2016-11-24T09:17:00</dateTime>\n<dateTime>2016-11-24T09:35:44</dateTime>\n<dateTime>2016-11-24T09:22:33</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>13736</int>\n<int>1902</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Almirante Riveros  01055</string>\n<string>Av Trinidad 1412</string>\n<string>Vicuña Mackenna 8770</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>San Bernardo</string>\n<string>La Florida</string>\n<string>La Florida</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>San Bernardo</string>\n<string>La Florida</string>\n<string>La Florida</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000489001 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:01:31'),(73,'0000488638','ERROR IDCHOFER','Chofer Alexis Vasque no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:04:24'),(74,'0000489094','ERROR IDGPS','Patente WY7855 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:04:51'),(75,'0000488158','ERROR IDCHOFER','Chofer Rodrigo Ramo no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:04:53'),(76,'0000488432','ERROR IDGPS','Patente FXVH87 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:04:54'),(77,'0000489060','ERROR IDCHOFER','Chofer Ariel Meneses no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:04:54'),(78,'0000489682','ERROR IDGPS','Patente GWXS18 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:04:55'),(79,'0000489683','ERROR IDCHOFER','Chofer Rodrigo Ramo no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:04:56'),(80,'0000488307','ENVIADO LOJACK','<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><CrearViajeResponse xmlns=\"http://tempuri.org/\"><CrearViajeResult>224076</CrearViajeResult></CrearViajeResponse></soap:Body></soap:Envelope>','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488307</Descripcion>\r\n							<idGPS>65738</idGPS>\r\n							<Patente>YN8078</Patente>\r\n							<idChofer>34212</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>3</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.5468</float>\n<float>-33.5227</float>\n<float>-33.514</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6061</float>\n<float>-70.5987</float>\n<float>-70.5952</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Acero Sur / La Florida</string>\n<string>Easy / E510 La Florida</string>\n<string>Sigro - Edificio Tres Lagos</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-21T02:23:00</dateTime>\n<dateTime>2016-11-21T02:23:00</dateTime>\n<dateTime>2016-11-21T02:30:31</dateTime>\n<dateTime>2016-11-21T02:30:33</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-21T02:53:00</dateTime>\n<dateTime>2016-11-21T02:23:00</dateTime>\n<dateTime>2016-11-21T02:30:31</dateTime>\n<dateTime>2016-11-21T02:30:33</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>3671</int>\n<int>2957</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Av Trinidad 1412</string>\n<string>Av. Vicuña Mackenna con Depart 6100</string>\n<string>Froilan Lagos  1500</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>La Florida</string>\n<string>La Florida</string>\n<string>La Florida</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>La Florida</string>\n<string>La Florida</string>\n<string>La Florida</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488307 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:05:01'),(81,'0000487820','ERROR IDGPS','Patente WJ4686 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:05:43'),(82,'0000489641','ERROR IDCHOFER','Chofer Ariel Meneses no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:05:44'),(83,'0000488643','ERROR IDCHOFER','Chofer Alvaro Barra no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:05:45'),(84,'0000485709','ERROR IDGPS','Patente CKGG40 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:05:45'),(85,'0000489647','ENVIADO LOJACK','<?xml version=\"1.0\" encoding=\"utf-8\"?><soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><soap:Body><CrearViajeResponse xmlns=\"http://tempuri.org/\"><CrearViajeResult>224078</CrearViajeResult></CrearViajeResponse></soap:Body></soap:Envelope>','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000489647</Descripcion>\r\n							<idGPS>120047</idGPS>\r\n							<Patente>ZU6102</Patente>\r\n							<idChofer>34179</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>3</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.4294</float>\n<float>-33.4193</float>\n<float>-33.3593</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.572</float>\n<float>-70.5673</float>\n<float>-70.5055</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>ALM - Carlos Alvarado</string>\n<string>Ingenieros - Domingo Bondi</string>\n<string>Ryal - Lo Barnechea</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-28T04:43:00</dateTime>\n<dateTime>2016-11-28T04:43:00</dateTime>\n<dateTime>2016-11-28T04:48:40</dateTime>\n<dateTime>2016-11-28T05:02:21</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-28T05:13:00</dateTime>\n<dateTime>2016-11-28T04:43:00</dateTime>\n<dateTime>2016-11-28T04:48:40</dateTime>\n<dateTime>2016-11-28T05:02:21</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>2041</int>\n<int>11332</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Carlos Alvarado 4828</string>\n<string>Domingo Bondi  1190</string>\n<string>Camino Vecinal  13879</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Las Condes</string>\n<string>Las Condes</string>\n<string>Lo Barnechea</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Las Condes</string>\n<string>Las Condes</string>\n<string>Lo Barnechea</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000489647 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:05:49'),(86,'0000489692','ENVIADO LOJACK','224094','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000489692</Descripcion>\r\n							<idGPS>151282</idGPS>\r\n							<Patente>PH5533</Patente>\r\n							<idChofer>34144</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>3</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.5115</float>\n<float>-33.4972</float>\n<float>-33.4885</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6647</float>\n<float>-70.6608</float>\n<float>-70.6522</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Const y Serv - San Miguel</string>\n<string>Befco - Edif San Nicolas</string>\n<string>Fuchs Gellona - Arcangel</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-28T05:35:00</dateTime>\n<dateTime>2016-11-28T05:35:00</dateTime>\n<dateTime>2016-11-28T05:40:38</dateTime>\n<dateTime>2016-11-28T05:41:00</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-28T06:05:00</dateTime>\n<dateTime>2016-11-28T05:35:00</dateTime>\n<dateTime>2016-11-28T05:40:38</dateTime>\n<dateTime>2016-11-28T05:41:00</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>2513</int>\n<int>2474</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Decima Avenida 1415</string>\n<string>San Nicolas 1419</string>\n<string>Arcangel 1161</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>San Miguel</string>\n<string>San Miguel</string>\n<string>San Miguel</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>San Miguel</string>\n<string>San Miguel</string>\n<string>San Miguel</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000489692 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:36:14'),(87,'0000487492','ERROR IDCHOFER','Chofer Alejandro Valdebenit no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:36:43'),(88,'0000488498','ERROR IDCHOFER','Chofer Claudio Pin no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:36:46'),(89,'0000489695','ERROR IDCHOFER','Chofer Freddy Orellana no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:36:53'),(90,'0000488683','ENVIADO LOJACK','224095','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488683</Descripcion>\r\n							<idGPS>128813</idGPS>\r\n							<Patente>FVPJ34</Patente>\r\n							<idChofer>34193</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>4</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-34.1701</float>\n<float>-34.4082</float>\n<float>-34.4082</float>\n<float>-34.2878</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.7406</float>\n<float>-70.8625</float>\n<float>-70.8625</float>\n<float>-71.0855</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Pitagora - Rancagua</string>\n<string>Madrigal Noriega / Sucursal Rengo</string>\n<string>Madrigal Noriega / Sucursal Rengo</string>\n<string>Olivia Miranda - Ruta H 30 Coltauco</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-23T08:04:00</dateTime>\n<dateTime>2016-11-23T08:04:00</dateTime>\n<dateTime>2016-11-23T08:33:53</dateTime>\n<dateTime>2016-11-23T08:33:53</dateTime>\n<dateTime>2016-11-23T08:47:49</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-23T08:34:00</dateTime>\n<dateTime>2016-11-23T08:04:00</dateTime>\n<dateTime>2016-11-23T08:33:53</dateTime>\n<dateTime>2016-11-23T08:33:53</dateTime>\n<dateTime>2016-11-23T08:47:49</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>33478</int>\n<int>33478</int>\n<int>48011</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Camino La Estrella 401 Pta Corte</string>\n<string>Bisquert 326</string>\n<string>Bisquert 326</string>\n<string>Ruta H 30 Coltauco ref Hospedaje Vi</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Rancagua</string>\n<string>Rengo</string>\n<string>Rengo</string>\n<string>Coltauco</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Rancagua</string>\n<string>Rengo</string>\n<string>Rengo</string>\n<string>Coltauco</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488683 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:36:56'),(91,'0000486045','ERROR IDCHOFER','Chofer Rafael Pini no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:37:41'),(92,'0000486977','ERROR IDCHOFER','Chofer Luis Sepulveda no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:37:44'),(93,'0000486713','ERROR IDCHOFER','Chofer Fernando Vergar no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:39:15'),(94,'0000488504','ERROR IDCHOFER','Chofer Ignacio Salgad no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:39:17'),(95,'0000487610','ERROR IDCHOFER','Chofer Geraldo Arand no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:39:17'),(96,'0000489116','ERROR IDGPS','Patente BSZJ41 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:39:18'),(97,'0000488171','ERROR IDGPS','Patente BLHJ42 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:39:19'),(98,'0000489745','ERROR IDCHOFER','Chofer Jose Benitez no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:39:19'),(99,'0000489796','ERROR IDCHOFER','Chofer Juan Castillo no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:39:20'),(100,'0000488744','ERROR IDGPS','Patente YV4085 no encontrada en la tabla de idgps','NO ENVIADO',NULL,'2016-09-14 12:39:21'),(101,'0000487785','ERROR IDCHOFER','Chofer Joel Rivera no encontrado en la tabla idchofer','NO ENVIADO',NULL,'2016-09-14 12:39:22'),(102,'0000488036','ENVIADO LOJACK','224097','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488036</Descripcion>\r\n							<idGPS>84998</idGPS>\r\n							<Patente>FCBS91</Patente>\r\n							<idChofer>34151</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>4</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.4365</float>\n<float>-33.4365</float>\n<float>-33.4624</float>\n<float>-33.4057</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6538</float>\n<float>-70.6538</float>\n<float>-70.6471</float>\n<float>-70.6599</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Euro - Santiago</string>\n<string>Su Ksa - Vive Independecia 2</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-20T02:38:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>0</int>\n<int>26690</int>\n<int>4473</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Santo Domingo 1170</string>\n<string>Santo Domingo 1170</string>\n<string>Arturo Prat 1304</string>\n<string>Julio Martienz Pradanos 1351 -1353</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488036 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:39:25'),(103,'0000488036','ENVIADO LOJACK','224106','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488036</Descripcion>\r\n							<idGPS>84998</idGPS>\r\n							<Patente>FCBS91</Patente>\r\n							<idChofer>34151</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>4</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.4365</float>\n<float>-33.4365</float>\n<float>-33.4624</float>\n<float>-33.4057</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6538</float>\n<float>-70.6538</float>\n<float>-70.6471</float>\n<float>-70.6599</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Euro - Santiago</string>\n<string>Su Ksa - Vive Independecia 2</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-20T02:38:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>0</int>\n<int>26690</int>\n<int>4473</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Santo Domingo 1170</string>\n<string>Santo Domingo 1170</string>\n<string>Arturo Prat 1304</string>\n<string>Julio Martienz Pradanos 1351 -1353</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488036 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:55:06'),(104,'0000488036','ENVIADO LOJACK','224108','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488036</Descripcion>\r\n							<idGPS>84998</idGPS>\r\n							<Patente>FCBS91</Patente>\r\n							<idChofer>34151</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>4</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.4365</float>\n<float>-33.4365</float>\n<float>-33.4624</float>\n<float>-33.4057</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6538</float>\n<float>-70.6538</float>\n<float>-70.6471</float>\n<float>-70.6599</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Euro - Santiago</string>\n<string>Su Ksa - Vive Independecia 2</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-20T02:38:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>0</int>\n<int>26690</int>\n<int>4473</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Santo Domingo 1170</string>\n<string>Santo Domingo 1170</string>\n<string>Arturo Prat 1304</string>\n<string>Julio Martienz Pradanos 1351 -1353</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488036 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:56:04'),(105,'0000488036','ENVIADO LOJACK','224109','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488036</Descripcion>\r\n							<idGPS>84998</idGPS>\r\n							<Patente>FCBS91</Patente>\r\n							<idChofer>34151</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>4</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.4365</float>\n<float>-33.4365</float>\n<float>-33.4624</float>\n<float>-33.4057</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6538</float>\n<float>-70.6538</float>\n<float>-70.6471</float>\n<float>-70.6599</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Euro - Santiago</string>\n<string>Su Ksa - Vive Independecia 2</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-20T02:38:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>0</int>\n<int>26690</int>\n<int>4473</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Santo Domingo 1170</string>\n<string>Santo Domingo 1170</string>\n<string>Arturo Prat 1304</string>\n<string>Julio Martienz Pradanos 1351 -1353</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488036 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:56:16'),(106,'0000488036','ENVIADO LOJACK','224110','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488036</Descripcion>\r\n							<idGPS>84998</idGPS>\r\n							<Patente>FCBS91</Patente>\r\n							<idChofer>34151</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>4</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.4365</float>\n<float>-33.4365</float>\n<float>-33.4624</float>\n<float>-33.4057</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6538</float>\n<float>-70.6538</float>\n<float>-70.6471</float>\n<float>-70.6599</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Euro - Santiago</string>\n<string>Su Ksa - Vive Independecia 2</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-20T02:38:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>0</int>\n<int>0</int>\n<int>26690</int>\n<int>4473</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Santo Domingo 1170</string>\n<string>Santo Domingo 1170</string>\n<string>Arturo Prat 1304</string>\n<string>Julio Martienz Pradanos 1351 -1353</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488036 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:56:46'),(107,'0000488036','ENVIADO LOJACK','224111','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488036</Descripcion>\r\n							<idGPS>84998</idGPS>\r\n							<Patente>FCBS91</Patente>\r\n							<idChofer>34151</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>4</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.4624</float>\n<float>-33.4365</float>\n<float>-33.4365</float>\n<float>-33.4057</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6471</float>\n<float>-70.6538</float>\n<float>-70.6538</float>\n<float>-70.6599</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Euro - Santiago</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Su Ksa - Vive Independecia 2</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:24:18</dateTime>\n<dateTime>2016-11-20T02:24:18</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-20T02:38:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:24:18</dateTime>\n<dateTime>2016-11-20T02:24:18</dateTime>\n<dateTime>2016-11-20T02:21:22</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>26690</int>\n<int>3481</int>\n<int>3481</int>\n<int>4473</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Arturo Prat 1304</string>\n<string>Santo Domingo 1170</string>\n<string>Santo Domingo 1170</string>\n<string>Julio Martienz Pradanos 1351 -1353</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488036 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 12:57:22'),(108,'0000488036','ENVIADO LOJACK','224115','ENVIADO','<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n					<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">\r\n					  <soap:Body>\r\n						<CrearViaje xmlns=\"http://tempuri.org/\">\r\n							<Descripcion>PROCESO CREACION 0000488036</Descripcion>\r\n							<idGPS>84998</idGPS>\r\n							<Patente>FCBS91</Patente>\r\n							<idChofer>34151</idChofer>\r\n							<LegajoChofer/>\r\n							<ParadasCount>4</ParadasCount>\r\n							<Latitud>\r\n								<float>-33.619818</float>\n<float>-33.4624</float>\n<float>-33.4365</float>\n<float>-33.4365</float>\n<float>-33.4057</float>\r\n							</Latitud>\r\n							<Longitud>\r\n								<float>-70.574001</float>\n<float>-70.6471</float>\n<float>-70.6538</float>\n<float>-70.6538</float>\n<float>-70.6599</float>\r\n							</Longitud>\r\n							<Color>\r\n								<string>FF0000</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\n<string>FFFFFF</string>\r\n							</Color>\r\n							<Etiqueta>\r\n								<string>C.I.El Volcán S.A. Concha y Toro</string>\n<string>Euro - Santiago</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Danacorp - 230 Santo Domingo</string>\n<string>Su Ksa - Vive Independecia 2</string>\r\n							</Etiqueta>\r\n							<Radio>\r\n								<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\n<int>350</int>\r\n							</Radio>\r\n							<Arribo>\r\n								<dateTime>2016-11-20T02:08:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:53:23</dateTime>\n<dateTime>2016-11-20T03:38:46</dateTime>\n<dateTime>2016-11-20T05:06:36</dateTime>\r\n							</Arribo>\r\n							<Partida>\r\n								<dateTime>2016-11-20T02:38:00</dateTime>\n<dateTime>2016-11-20T02:37:05</dateTime>\n<dateTime>2016-11-20T02:53:23</dateTime>\n<dateTime>2016-11-20T03:38:46</dateTime>\n<dateTime>2016-11-20T05:06:36</dateTime>\r\n							</Partida>\r\n							<Distancia>\r\n								<int>500</int>\n<int>26690</int>\n<int>3481</int>\n<int>3481</int>\n<int>4473</int>\r\n							</Distancia>\r\n							<idTipoPunto>\r\n								<int>2</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\n<int>3</int>\r\n							</idTipoPunto>\r\n							<Numeracion>\r\n								<int>602</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\n<int>0</int>\r\n							</Numeracion>\r\n							<Direccion>\r\n								<string>Av. Concha y Toro</string>\n<string>Arturo Prat 1304</string>\n<string>Santo Domingo 1170</string>\n<string>Santo Domingo 1170</string>\n<string>Julio Martienz Pradanos 1351 -1353</string>\r\n							</Direccion>\r\n							<Provincia>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Provincia>\r\n							<Pais>\r\n								<string>Chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\n<string>chile</string>\r\n							</Pais>\r\n							<Telefonos>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Telefonos>\r\n							<Contacto>\r\n								<string></string>\n<string></string>\n<string></string>\n<string></string>\n<string></string>\r\n							</Contacto>\r\n							<Localidad>\r\n								<string>Puente Alto</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Santiago</string>\n<string>Independencia</string>\r\n							</Localidad>\r\n							<Observaciones>CARGA TRANSPORTE 0000488036 </Observaciones>\r\n							<UltimoEsFin>1</UltimoEsFin>\r\n							<Usuario>volcanws</Usuario>\r\n							<Password>1234</Password>\r\n							<Token>LoJackDefaultTokenWSDespacho</Token>\r\n						</CrearViaje>\r\n					  </soap:Body>\r\n					</soap:Envelope>','2016-09-14 13:01:50');
/*!40000 ALTER TABLE `gpswslog` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gpswsorigen`
--

DROP TABLE IF EXISTS `gpswsorigen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gpswsorigen` (
  `idgpswsorigen` int(11) NOT NULL AUTO_INCREMENT,
  `cliente` varchar(10) DEFAULT NULL,
  `pais` varchar(100) DEFAULT NULL,
  `nombre` varchar(100) DEFAULT NULL,
  `calle` varchar(100) DEFAULT NULL,
  `numero` int(11) DEFAULT NULL,
  `ciudad` varchar(45) DEFAULT NULL,
  `lat` varchar(45) DEFAULT NULL,
  `lng` varchar(45) DEFAULT NULL,
  `estado` int(11) DEFAULT NULL,
  PRIMARY KEY (`idgpswsorigen`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 COMMENT='Tabla de Origenes segun contexto PxEx de información de Transportes';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gpswsorigen`
--

LOCK TABLES `gpswsorigen` WRITE;
/*!40000 ALTER TABLE `gpswsorigen` DISABLE KEYS */;
INSERT INTO `gpswsorigen` VALUES (1,'AVAT','CL','Aislantes Volcán S.A','Pedro Aguirre Cerda',15600,'Antofagasta','-23.531102','-70.393294',1),(2,'CVAT','CL','Cía. Industrial el Volcán  S.A','Pedro Aguirre Cerda',15600,'Antofagasta','-23.531102','-70.393294',1),(3,'FVAT','CL','Fibrocementos Volcán S.A','Pedro Aguirre Cerda',15600,'Antofagasta','-23.531102','-70.393294',1),(4,'AVLS','CL','Aislantes Volcán S.A','Ruta D43, Bodega A2',701,'Coquimbo','-29.959001','-71.338918',1),(5,'CVLS','CL','Cía. Industrial el Volcán  S.A','Ruta D43, Bodega A2',701,'Coquimbo','-29.959001','-71.338918',1),(6,'FVLS','CL','Fibrocementos Volcán S.A','Ruta D43, Bodega A2',701,'Coquimbo','-29.959001','-71.338918',1),(7,'AVVI','CL','Aislantes Volcán S.A','Octava avenida',1153,'Viña del Mar','-32.997464','-71.481862',1),(8,'CVVI','CL','Comp.Ind.El Volcán Viña del Mar','Octava avenida',1153,'Viña del Mar','-32.997464','-71.481862',1),(9,'FVVI','CL','Fibrocementos Volcán S.A','Octava avenida',1153,'Viña del Mar','-32.997464','-71.481862',1),(10,'AVCO','CL','Aislantes Volcán S.A','Camino a Coronel KM 10',5580,'Concepción','-36.951750','-73.012967',1),(11,'CVCO','CL','C.I.El Volcán S.A. (NO USAR var C.C','Camino a Coronel KM 10',5580,'Concepción','-36.951750','-73.012967',1),(12,'FVCO','CL','Fibrocementos Volcán S.A','Camino a Coronel KM 10',5580,'Concepción','-36.951750','-73.012967',1),(13,'AVPM','CL','Aislantes Volcán S.A','Ruta 5 Sur KM 1025',0,'Puerto Montt','-41.456611','-72.971048',1),(14,'CVPM','CL','C.I.El Volcán S.A. Puerto Montt','Ruta 5 Sur KM 1025',0,'Puerto Montt','-41.456611','-72.971048',1),(15,'FVPM','CL','Fibrocementos Volcán S.A','Ruta 5 Sur KM 1025',0,'Puerto Montt','-41.456611','-72.971048',1),(16,'INVV','CL','INVERSIONES VOLCAN S.A.','AGUSTINAS, DEPTO. P.10',1357,'SANTIAGO','-33.441121','-70.655788',1),(17,'5000867','CL','Transportes Yeso Ltda.','Av. Concha y Toro',602,'Puente Alto','-33.619818','-70.574001',1),(18,'CV02','CL','C.I.El Volcán S.A. Concha y Toro','Av. Concha y Toro',602,'Puente Alto','-33.619818','-70.574001',1),(19,'CVSA','CL','COMPAÑIA INDUSTRIAL EL VOLCAN S.A.','Av Concha y Toro',610,'Puente Alto','-33.605981','-70.576711',1),(20,'TYES','CL','Transportes Yeso Ltda.','Av Concha y Toro',610,'Puente Alto','-33.605981','-70.576711',1),(21,'MVAL','CL','Minera Lo Valdés','Lo Valdes Camino EL Volcán S/N',0,'San José de Maipo - Santiago','-33.829637','-70.079559',1),(22,'AV02','CL','Aislantes Volcán S.A','Quitalmahue',2202,'Puente Alto','-33.639039','-70.624513',1),(23,'AV03','CL','Pto. Expedición AVSA Producción','Quitalmahue',2202,'Puente Alto','-33.639039','-70.624513',1),(24,'AVSA','CL','Aislantes Volcán','Quitalmahue',2202,'Puente Alto','-33.639039','-70.624513',1),(25,'FIBR','CL','FIBROCEMENTOS VOLCAN LTDA.','Los Boldos',620,'Lampa','-33.327314','-70.733327',1),(26,'FV02','CL','Fibrocementos Volcán Ltda.','Los Boldos',620,'Parque Industrial, Valle Grande - L','-33.327314','-70.733327',1);
/*!40000 ALTER TABLE `gpswsorigen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'volcan_ws_gps'
--
/*!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 2016-09-14 13:31:49
