-- MySQL dump 10.13  Distrib 5.7.12, for Win32 (AMD64)
--
-- Host: localhost    Database: circle_k
-- ------------------------------------------------------
-- Server version	5.7.10-log

/*!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 `ubicaciones`
--

DROP TABLE IF EXISTS `ubicaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ubicaciones` (
  `UbicacionesID` varchar(50) NOT NULL,
  `InternalVersion` int(11) DEFAULT '0',
  `Activo` tinyint(4) DEFAULT '0',
  `PlazasID` varchar(50) DEFAULT NULL,
  `Nombre` varchar(100) DEFAULT NULL,
  `CiudadesID` varchar(50) DEFAULT NULL,
  `Colonia` varchar(100) DEFAULT NULL,
  `Calle` varchar(100) DEFAULT NULL,
  `Numero` varchar(10) DEFAULT NULL,
  `CodigoPostal` varchar(10) DEFAULT NULL,
  `Latitud` varchar(50) DEFAULT NULL,
  `Longitud` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`UbicacionesID`),
  KEY `WDIDX_Ubicaciones_Activo` (`Activo`),
  KEY `WDIDX_Ubicaciones_PlazasID` (`PlazasID`),
  KEY `WDIDX_Ubicaciones_Nombre` (`Nombre`),
  KEY `WDIDX_Ubicaciones_CiudadesID` (`CiudadesID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ubicaciones`
--

LOCK TABLES `ubicaciones` WRITE;
/*!40000 ALTER TABLE `ubicaciones` DISABLE KEYS */;
INSERT INTO `ubicaciones` VALUES ('0-1',0,0,'1','SIMULADOR COMPRAS','104-89','COMERCIAL','Callejon Madero y 6ta','','','',''),('0-2',6,1,'12','ESTACION 1642','104-46','Olivares','Blvd. Luis Encinas','SN','83180','',''),('1-39',13,1,'1','TLAXCALA 6 Y 7','104-89','Sonora','Avenida Tlaxcala 6 y 7','608-A','83440','',''),('1-40',2,0,'','KINO Y 2','','','','','','',''),('1-41',5,1,'1','CJON. KINO Y 2','104-89','','','','0','',''),('1-42',2,0,'','TLAXCALA Y MONTERREY','','','','','','',''),('1-43',5,1,'1','CJON MADERO Y 2','104-89','','','','0','',''),('1-44',4,1,'1','CJON KINO Y 2','104-1','Comercial','AVENIDA KINO Y CALLE 2DA','01','83449','',''),('1-45',2,0,'','MONTERREY Y TLAXCALA','','','','','','',''),('1-46',5,1,'1','CJON. REVOLUCION 5 Y 6','104-89','','','','0','',''),('1-47',2,0,'','KM 43','','','','','','',''),('1-48',2,0,'','EL ENCINO','','','','','','',''),('104-1',13,1,'1','MONTERREY Y TLAXCALA  ','104-89','Ruiz Cortines','CALZADA MONTERREY','682','83439','',''),('104-10',17,1,'3','LAZARO CARDENAS','104-60','Villa Florida','CALZ. GENERAL LAZARO CARDENAS','3769','21395','32.600379','-115.370666'),('104-11',18,1,'3','KENWORTH','104-60','González Ortega','CALZ. GUSTAVI VILDOSOLA CASTRO. ENTRE BLVD. GOBERNADOR BRAULIO MALDONADO Y BLVD. SANCHEZ','1999','21397','32.60209278','-115.4256906'),('104-12',15,1,'1','KINO Y 2DA','104-89','Cuauhtémoc','AVENIDA KINO Y CALLE 2DA','01','83400','',''),('104-13',17,1,'3','CETYS Y NOVENA','104-60','Unidad Patria','CALZ. CETYS ANTES BLVD. AEROPUERTO','4170','21230','32.65253726','-115.3755822'),('104-14',17,1,'3','GOMEZ MORIN','104-60','Las Hadas','CALZ. LIC. MANUEL GOMEZ MORIN','390','21216','32.662722','-115.414666'),('104-15',22,1,'3','1810','104-60','Desarrollo Urbano Orizaba Sur','CALZ. ADOLFO LOPEZ MATEOS Y CALZADA 1810','78','21135','32.60965076','-115.4385598'),('104-16',17,1,'3','RIO NUEVO','104-60','Río Nuevo','CALZADA DE LOS PRESIDENTES','952','21120','32.650366','-115.485656'),('104-17',15,0,'3','PLAZA MANDARIN','104-60','Sanchez Taboada','CALZ. LIC. ADOLFO LOPEZ MATEOS','2253','21360','32.62226','-115.449137'),('104-18',12,1,'3','CALLE 11','104-60','Universitario','CALZ. HEROICO COLEGIO MILITAR','1800','21180','32.630049','-115.505884'),('104-19',18,1,'3','KM. 43','104-60','Guadalupe Victoria','CALLE 3RA.','101','21720','32.28914841','-115.110869'),('104-2',15,1,'1','TAMAULIPAS Y 22','104-89','Jalisco','AV TAMAULIPAS Y CALLE 22','2200','83447','',''),('104-20',17,1,'4','BENITO JUAREZ','104-78','Recinto Portuario','BLVD BENITO JUAREZ Y CALLE 1RA','S/N','83554','31.3080538','-113.5403616'),('104-21',14,1,'4','JOSEFA ORTIZ','104-78','Oriente','BLVD. JOSEFA ORTIZ DE DOMINGUEZ Y CALLE MENCHOR OCAMPO','322','83553','31.3176055','-113.5208585'),('104-22',12,1,'4','SIMON MORUA','104-78','Oriente','SIMON MORUA Y BELIZARIO DOMINGUEZ','S/N','83553','',''),('104-23',15,1,'1','CONSTITUCION Y LOS PINOS','104-89','Industrial','CALZADA CONSTITUCION Y BLVD. LOS PINOS','1501','83430','',''),('104-24',15,1,'5','ENCINO','104-100','Emiliano Zapata','CAMINO VECINAL A LA COLONIA MACLOVIO HERRERA','301','21460','32.54623662','-116.6254561'),('104-25',15,1,'5','EL DESCANSO','104-100','El Descanso','PASEO MORELOS ESQ. CALLE HIDALGO','1211','21478','32.57077291','-116.6056875'),('104-26',9,1,'1','CIRCULO R','104-89','Comercial','AVENIDA REVOLUCION','1098','83449','',''),('104-27',5,1,'3','TEST ','104-60','','','','0','',''),('104-28',13,1,'3','GOMEZ MORIN 2','104-60','Las Delicias','CALZADA MANUEL GOMEZ MORIN','2198','21297','',''),('104-29',18,1,'3','ANAHUAC','104-60','Anáhuac','CALZADA ANAHUAC','899','21060','32.621096','-115.418117'),('104-3',14,1,'1','NUEVO LEON Y 22','104-89','Federal','AV NUEVO LEON','2201','83489','',''),('104-30',13,1,'1','OBREGON Y CUAUHTEMOC','104-89','Cuauhtémoc','AVENIDA OBREGON Y CALLE CUAUTEMOC A OESTE','100','83400','',''),('104-31',15,1,'1','NUEVO LEON Y 9','104-89','Del Bosque','A NUEVO LEON Y 9','810','83480','',''),('104-32',15,1,'1','TLAXCALA Y 12','104-89','Sonora','AVENIDA TLAXCALA Y 12','1200','83440','',''),('104-33',12,1,'1','BRECHA Y 17','104-89','Mezquite','AV. BENJAMIN FLORES Y CALLE 17','1700','83488','',''),('104-34',13,1,'1','SONORA Y 17','104-89','Jalisco','AVENIDA SONORA Y CALLE 17','1608','83447','',''),('104-35',11,1,'1','ALMACEN- CEDIS','104-89','Parque Industrial','DE LA INDUSTRIA','1','83455','',''),('104-36',13,1,'1','OBREGON Y 16','104-89','Residencias','AV. OBREGON Y 16','1602','83448','',''),('104-37',4,1,'3','SISTEMAS','104-60','','','','0','',''),('104-38',9,1,'1','RECURSOS HUMANOS SAN LUIS','104-89','','','','0','',''),('104-4',14,1,'1','KINO Y 26','104-89','Residencias','AV KINO Y 26','2510','83448','',''),('104-49',4,1,'3','PRUEBA','104-60','','','','0','',''),('104-5',14,1,'1','QUINTANA ROO Y 26','104-89','Federal','AV. QUINTANA ROO \"B\" Y 26','2511','83489','',''),('104-50',13,1,'3','ANAHUAC 2','104-60','Quinta del Rey','AV. FONELAS','500-A','21355','',''),('104-51',11,1,'1','TLAXCALA Y 17','104-89','','TLAXCALA Y 17','','0','',''),('104-52',2,1,'1','ZARAGOZA 4TA Y 5TA','104-89','','ZARAGOZA 4TA Y 5TA','','0','',''),('104-53',4,1,'2','SONOYTA SANTA FE','104-156','Sonoyta Centro','BLVD. BENEMERITO DE LAS AMERICAS ENTRE CALLES PALACIO MUNICIPAL Y PETRA SANTOS.','878','83570','',''),('104-54',2,1,'1','ARRENDAMIENTO','104-89','Industrial','AV. AVILA CAMACHO Y VERACRUZ','601','83430','',''),('104-55',14,1,'1','QUINTANA ROO Y 26 1','104-89','Federal','AVENIDA QUINTANA ROO B','B','83489','',''),('104-56',4,1,'1','MADERO Y 6TA','104-89','Comercial','AV. MADERO Y 6TA','601','83449','',''),('104-6',14,1,'1','REVOLUCION Y 34','104-89','Burócrata','AV REVOLUCION Y 34','3401','83450','',''),('104-7',14,1,'1','TLAXCALA Y 34','104-89','Campestre','CALLEJON JALISCO Y 34','3308','83499','',''),('104-8',13,1,'1','LIBERTAD Y 42','104-89','Progreso','LIBERTAD Y 42','4109','83458','',''),('104-9',12,1,'2','SONOYTA','104-156','CENTRO','BLVD BENEMERITO DE LAS AMERICAS','104','83571','',''),('116-1',1,1,'1','MANTENIMIENTO','104-89','','','','0','',''),('116-2',1,1,'1','SUPERVISION','104-89','','','','0','',''),('178-1',17,1,'3','JUSTO SIERRA Y TAPICEROS','104-60','Burócrata','CALZ. JUSTO SIERRA','700','21020','32.65308377','-115.4529237'),('178-10',2,1,'3','CENTROS CAMBIARIOS','104-60','','','','0','',''),('178-11',1,1,'3','FLOTILLAS','104-60','','','','0','',''),('178-12',3,1,'3','CALIBRACION','104-60','','','','0','',''),('178-13',4,1,'12','ESTACIONES DE AUTOSERVICIO Y COMBUSTIBLES TICO','104-46','Unión de Ladrilleros','BOULEVARD LAZARO CARDENAS','910','83179','',''),('178-14',3,1,'1','CREDITO Y COBRANZA','104-89','Comercial','','','83449','',''),('178-15',5,1,'8','DEL MAR','104-76','Los Ángeles','BLVD BENITO JUAREZ','293','22703','32.359425','-117.059033'),('178-17',3,1,'4','ASIAN EXPRESS MALECON','104-78','EL PUERTO','MALECON FUNDADORES','6','83554','',''),('178-18',8,1,'14','SAN QUINTIN SUR','104-37','Nuevo Mexicali','CARRETERA TRANSPENINSULAR ENSENADA LA PAZ','S/N','22930','30.550888','-115.938593'),('178-19',7,1,'14','SAN QUINTIN NORTE','104-37','Vicente Guerrero','AVENIDA BENITO JUAREZ','102','22920','30.731033','-115.991401'),('178-2',13,1,'3','CALZADA DE LA AMERICAS','999-1','Cuauhtémoc Sur','CALZADA DE LAS AMERICAS','','21200','',''),('178-20',8,1,'7','MANEADERO','104-37','Maneadero','CARRETERA TRANSPENINSULAR ENSENADA LA PAZ','6','22790','31.728288','-116.577732'),('178-21',4,1,'4','LA CUCHILLA','104-78','Puerto Peñasco Centro','BOULEVARD BENITO JUAREZ','S/N','83550','',''),('178-22',1,1,'1','EL VALLE','104-89','Luis B. Sánchez','CARRETERA SAN LUIS RC GOLFO DE SANTA CLARA','79','83500','',''),('178-23',2,1,'24','YECORA','104-1998','Yécora','CARRETERA INTERNACIONAL NOGALES KM 280','','85780','',''),('178-24',2,1,'9','ZONA URBANA','104-106','Zona Urbana Río Tijuana','BLVD RODOLFO SANCHEZ TABOADA','9540','22010','',''),('178-25',4,1,'3','CUAUHTEMOC SUR','104-60','Cuauhtémoc Sur','CUAUHTEMOC','51','21200','',''),('178-26',3,1,'5','LAZARO CARDENAS','104-100','Tecate Centro','LAZARO CARDENAS','20','21400','',''),('178-27',2,1,'18','GUAYMAS SUBWAY','104-45','Las Delicias','CALZ GARCIA LOPEZ','S/N','85427','',''),('178-4',12,1,'3','PORTALES','104-60','Las Palomas','CALZADA DE LAS HACIENDAS','1363','21188','32.595947','-115.493155'),('178-5',13,1,'7','COSTERO','104-37','Valle Dorado','BLVD COSTERO','2100','22890','31.844052','-116.612301'),('178-6',6,1,'9','VIVEROS','104-106','VALLE REDONDO','BLVD HEROES DE LA INDEPENDENCIA','21121','22720','',''),('178-7',2,1,'3','MANTENIMIENTO MXL','104-60','','','','0','',''),('178-8',2,1,'3','PLANEACION DE ESTACIONES','104-60','','','','0','',''),('178-9',1,1,'3','CORDINACION DE ESTACIONES','104-60','','','','0','',''),('188-1',16,1,'3','TERAN TERAN','104-60','Televisora','CALZ. LIC. HECTOR TERAN TERAN','2199-A','21337','32.61363','-115.51437099999998'),('188-2',17,1,'3','KM43 2','104-60','Del Sol','CALZADA DE LOS INSURGENTES 14 Y 15','750','21720','32.288922','-115.097491'),('192-1',13,1,'1','NUEVO LEON Y 42','104-89','México','av. nuevo leon y calle 42','4200','83498','',''),('192-10',12,1,'3','VIP MARKET','104-60','Hacienda Dorada','AVENIDA MISION DE SAN DIEGO','3499','21376','32.635071','-115.386514'),('192-100',5,1,'21','ROMA ESPERANZA','104-2','Esperanza','CALLE 16 Y AVE 20','','84260','',''),('192-101',2,1,'20','DOS POTRILLOS MOCTEZUMA','104-1970','','','','84560','',''),('192-102',1,1,'22','VILLA JUAREZ JECOPACO','104-12','','','','85294','',''),('192-103',3,1,'12','AMIGAS MIGUEL ALEMAN','104-46','Miguel Alemán Centro','CARRETERA BAHIA KINO','84','83344','',''),('192-104',3,1,'11','PAPALOTE LOMAS DE KINO','104-202','Lomas de Kino','JESUS GARCIA','1002','84160','',''),('192-105',4,1,'16','CENTRO SUBWAY','104-70','Fundo Legal','AVENIDA OBREGON','98','84030','',''),('192-106',3,1,'16','GALERIA NORTE','104-70','El Greco','BOULEVARD LUIS DONALDO COLOSIO','local 9','84066','',''),('192-107',3,1,'16','MALL SUBWAY','104-70','El Greco','BOULEVARD EL GRECO','interiorD9','84066','',''),('192-108',1,1,'1','CLIENTES LOLAS SAN LUIS','104-46','','','','0','',''),('192-109',1,1,'3','CLIENTES LOLAS MEXICALI','104-60','','','','0','',''),('192-11',2,0,'4','OFICINAS MADERO CENTRA','60','','','','0','',''),('192-110',1,1,'7','CLIENTES LOLAS ENSENADA','104-37','','','','0','',''),('192-111',1,1,'16','CLIENTES LOLAS NOGALES','104-70','','','','0','',''),('192-112',1,1,'13','CLIENTES LOLAS OBREGON','104-157','','','','0','',''),('192-113',2,1,'18','CLIENTES LOLAS GUAYMAS','104-45','','','','0','',''),('192-114',4,1,'9','PLAZA PENINSULA','104-106','Chapultepec Alamar','VIP RAPIDA ORIENTE','L-78 A','22110','',''),('192-115',3,1,'1','QUINTANA ROO A Y 26','104-89','Campestre','AV QUINTANA ROO \"A\" Y 26','2600','83499','',''),('192-116',3,1,'1','MAZATLAN Y 30','104-89','Reforma','MAZATLAN B','3000','83497','',''),('192-118',3,1,'3','CATAVINA','104-60','Rivera','CALZADA CETYS Y PERIFERICO','1800','21259','',''),('192-119',3,1,'3','CARRANZA','104-60','Plutarco Elías Calles','BLVD LAZARO CARDENAZ L003 Y 03A','1972','21376','',''),('192-12',16,1,'3','VIP MARKET LOPEZ MATEOS','104-60','Agualeguas','BLVD ADOLFO LOPEZ MATEOS','1599','21090','32.632569','-115.462312'),('192-120',3,1,'3','MONTECARLO SUBWAY','104-60','Montecarlo','CALZADA VENUSTIANO CARRANZA','1419','21255','',''),('192-121',3,1,'23','CANANEA','104-16','Minera Sección Este','LAZARO GUTIERREZ DE LARA','1','84624','',''),('192-122',3,1,'12','KENO','104-46','Sahuaro Indeco','BLVD SOLIDAR Y MENDOZA','','83171','',''),('192-123',2,1,'12','PUMA','104-46','Libertad','SOLIDARIDAD ESQ R ROMERO','','83130','',''),('192-124',3,1,'12','GRANJAS','104-46','Las Granjas','BOULEVARD SOLIDARIDAD','646','83250','',''),('192-125',6,1,'12','QUIROGA','104-46','Quinta Emilia','BLVD JESUS GARCIA MORALES','496','83214','',''),('192-126',4,1,'16','NOGALES INTERNACIONAL','104-70','Colinas Del Sur','CARRETERA INTERNACIONAL 15','4408','84093','',''),('192-127',4,0,'1','PROGRAMA DUAL','104-89','Sonora','','','83440','',''),('192-128',1,1,'1','PERSONAL TEMPORAL APOYO RH','104-89','Sonora','','','83440','',''),('192-129',1,1,'9','CLIENTES LOLAS TIJUANA','104-106','El Lago','','','22210','',''),('192-13',18,1,'3','MONTECARLO','104-60','Montecarlo','CALZADA INDEPENDENCIA','1100','21255','32.638187','-115.392804'),('192-130',2,1,'15','QUIROZ Y MORA','104-15','Caborca Centro','DOMINGO QUIROZ Y MORA','1 LOCAL A','83600','',''),('192-131',2,1,'12','SONORA CORRECCION','104-1982','Independencia','','','21290','',''),('192-132',2,1,'9','GATO BRONCO','104-106','Murua Oriente','BLVD MANUEL J CLOUTHIER','5301','22465','',''),('192-133',2,1,'3','LAZARO CARDENAS BOMBEROS','104-60','Des. Urbanos Zacatecas II','BLVD LAZARO CARDENAS','1388','21389','',''),('192-134',1,1,'1','CLIENTES LOLAS ESTAOS UNIDOS','104-89','Independencia','','','21290','',''),('192-135',1,1,'5','UNIVERSIDAD','104-100','Guajardo','BLVD UNIVERSIDAD','531','21470','',''),('192-14',11,1,'5','TECATE 4 NAPA','104-100','FRACCIONAMIENTO ROMERO','AV BENITO JUAREZ','999','0','',''),('192-15',16,1,'7','PEDRO LOYOLA','104-37','Obrera','AVE DR PEDRO LOYOLA LOCAL A','487','22830','31.844665','-116.607878'),('192-18',16,1,'5','NAPA','104-100','Romero','AVENIDA BENITO JUAREZ','999','21410','32.572738','-116.635785'),('192-19',17,1,'3','AMERICAS','104-60','Cuauhtémoc Sur','CALZADA DE LAS AMERICAS','180','21200','32.662509','-115.44804'),('192-2',17,1,'3','EJIDO PUEBLA','104-60','González Ortega','CARRETERA MEXICALI SAN LUIS RIO COLORADO','140','21397','32.56950144','-115.3391203'),('192-20',4,1,'7','CARRETERA TRANSPENINSULAR','104-37','CHAPULTEPEC II','CARRETERA TRANSPENINSULAR ENSENADA LA PAZ','6531','0','',''),('192-21',2,1,'7','AUTOPISTA TIJUANA ENSENADA','104-37','VILLA LAS ROSAS','AUTOPISTA TIJUANA ENSENADA','4768','0','',''),('192-22',1,1,'3','CORRALES','3','','','','0','',''),('192-23',27,1,'7','REFORMA','104-37','Chapultepec','EJ CHAPULTEPEC','6531','22785','31.803747','-116.59513'),('192-24',21,1,'7','PLAYITAS','104-37','El Sauzal','AUTOPISTA TIJUANA ENSENADA','4768','22760','31.870207','-116.67594'),('192-25',1,1,'1','ONDACEL RECARGA','60','','','','0','',''),('192-26',14,1,'8','ROSARITO 1','104-76','Veracruz','CARRETERA LIBRE TIJUANA ENSENADA','501','22705','32.399823','-117.052803'),('192-27',16,1,'3','TECNOLOGICO','104-60','Calles','CALZADA GENERAL LÁZARO CÁRDENAS','2098','21226','32.619797','-115.401472'),('192-28',16,1,'3','ISLAS AGRARIAS','104-60','González Ortega','CALZADA ROTARIO INTERNACIONAL','2998','21397','32.613977','-115.381958'),('192-29',5,0,'1','CONSTITUCION Y RIO MAYO OC','104-89','LA MESA','CALZADA CONSTITUCIÓN Y RIO MAYO','418 LocalD','83420','',''),('192-3',3,0,'3','EJIDO PEBLA GAS','104-60','','','','0','',''),('192-30',9,1,'1','OBREGON Y 5','104-89','Comercial','AVE OBREGON Y CALLE QUINTA','501','83449','',''),('192-31',3,1,'1','CLIENTES ONDACEL','60','','','','0','',''),('192-32',5,1,'1','COCINA CENTRAL','104-89','CUAUHTEMOC','KINO Y 2DA','','0','',''),('192-33',2,1,'3','RECURSOS HUMANOS MEXICALI','104-60','','','','0','',''),('192-34',2,1,'2','RECURSOS HUMANOS SONOYTA','104-156','','','','0','',''),('192-35',2,1,'4','RECURSOS HUMANOS PUERTO PEÑASCO','104-78','','','','0','',''),('192-36',3,1,'5','RECURSOS HUMANOS TECATE','104-100','','','','0','',''),('192-37',3,1,'7','RECURSOS HUMANOS ENSENADA','104-37','','','','0','',''),('192-38',12,1,'3','CENTRO CIVICO','104-60','Centro Cívico','CALZADA INDEPENDENCIA','884','21000','32.643763','-115.477999'),('192-39',4,1,'3','TERAN TERAN ASIAN EXPRESS','104-60','Televisora','CALZ LIC HECTOR TERAN TERAN','2199','21337','',''),('192-4',8,1,'1','NUEVO LEON Y  9  FERIAS Y EVENTOS','104-89','Del Bosque','AVE NUEVO LEON Y CALLE 9','810','83480','',''),('192-40',12,1,'3','EJIDO HERMOSILLO','104-60','Hermosillo','CARRETERA MEXICALI - SAN LUIS KM 60','SN','21840','32.523787','-114.917138'),('192-41',5,1,'9','MADERO Y 4TA','104-106','Zona Centro','CALLE 4TA SALVADOR DIAZ MIRON','8350','22000','',''),('192-42',1,1,'3','ADMINISTRACION MEXICALI','3','','','','0','',''),('192-43',2,1,'3','ABOGADOS','104-60','','','','0','',''),('192-44',7,1,'8','CANTAMAR','104-76','Cantamar','BENITO JUAREZ SUR','16804 A','22710','32.227112','-116.920644'),('192-45',12,1,'3','VISTA HERMOSA','104-60','Vista Hermosa','CALZADA CETYS','1499 A','21240','32.659187','-115.421231'),('192-46',5,1,'10','SANTA  ANA','104-200','Bellavista','BOULEVARD INTERNACIONAL','1410 A','84600','',''),('192-47',1,1,'3','OPERACIONES VIP MEXICALI','3','','','','0','',''),('192-48',2,1,'1','GERENTES ADMINISTRATIVOS','104-89','','','','0','',''),('192-49',1,1,'1','RECURSOS HUMANOS FORANEOS','60','','','','0','',''),('192-5',4,1,'1','SUPER AHORRO UN PRECIO Y MAS','104-89','La Mesa','Calzada Constitución','1501','83420','',''),('192-50',3,1,'11','MAGDALENA','104-202','CENTRO','AVENIDA AV','502','84160','',''),('192-51',2,1,'3','CANAL 66','104-60','','','','0','',''),('192-52',5,1,'1','KINO Y 2DA COCINA','104-89','Cuauhtémoc','AV KINO Y 2DA','103 ALTOS','83400','',''),('192-53',5,1,'9','SAN ANTONIO','104-106','San Antonio Club Hípico y de Golf','CARR LIBRE TIJUANA ENSENADA','11325','22563','',''),('192-54',11,1,'3','PUEBLO NUEVO','104-60','Pueblo Nuevo','CALZ HEROICO COLEGIO MILITAR','165','21120','32.6635151','-115.5055231'),('192-55',9,1,'12','PADRE KINO','104-46','Centro Oriente','BLVD. LUIS ENCINAS','SN','83000','',''),('192-56',7,1,'12','ARCOS','104-46','Los Arcos','BLVD. LUIS DONALDO COLOSIO','SN','83250','',''),('192-57',6,1,'12','CENTENARIO','104-46','Centenario','AV. REFORMA','SN','83260','',''),('192-58',9,1,'12','CONTRERAS','104-46','Centro Norte','BLVD. LUIS ENCINAS','SN','83000','',''),('192-59',7,1,'12','PERINORTE','104-46','Los Rosales','AV. PERIFERICO NORTE','SN','83140','',''),('192-6',15,1,'5','VALLE DE LAS PALMAS','104-106','La Muralla','CARRETERA LIBRE TIJUANA TECATE','30722','22253','32.472988','-116.745509'),('192-60',2,1,'1','ALMACEN ARIZONA','104-89','','','','0','',''),('192-61',7,1,'12','GASEXPRESS','','','','','','',''),('192-62',7,1,'9','VISTA ALAMAR','104-106','Vista Alamar','AV. AZTECAS','18001','22450','',''),('192-63',2,1,'3','CC OFICINAS MEXICALI','104-60','INDUSTRIAL','E','25','0','',''),('192-64',6,1,'13','NAINARI','104-157','Ciudad Obregón Centro (Fundo Legal)','NAINARI','1050','85000','',''),('192-65',2,1,'1','IMPORTACIONES','104-89','Residencias','CALLE 16 ENTRE AV OBREGON Y CJON CARLOS G CALLES','1601','83448','',''),('192-66',6,1,'7','VALLE DORADO','104-37','Valle Dorado','AV REFORMA','397','22890','31.837490','-116.60165'),('192-67',4,1,'9','PLAYAS DE TIJUANA','104-106','El Mirador','LIBRAMIENTO PLAYAS DE TIJUANA','2916','22204','',''),('192-68',4,1,'9','LA CUESTA','104-106','De los Maestros','LIBRE TIJUANA ENSENADA','7152','22640','',''),('192-69',4,1,'13','TABASCO','104-157','Ciudad Obregón Centro (Fundo Legal)','TABASCO','SUR 870','85000','',''),('192-7',15,1,'1','CONSTITUCION Y RIO MAYO','104-89','La Mesa','CONSTITUCION Y RIO MAYO','418 LOCALA','83420','',''),('192-70',1,1,'9','TIJUANA UABC','104-60','','','','0','',''),('192-71',6,1,'3','LAS FUENTES','104-60','Las Fuentes','AV CUAUHTEMOC','500','21230','',''),('192-72',4,1,'3','JARDINES DEL LAGO','104-60','Villafontana','LAZARO CARDENAS','1399','21180','',''),('192-73',6,1,'9','RAVELO','104-106','Ampliación Guaycura','CALLE PUNTA  DEL DIABLO','19401','22214','',''),('192-74',1,1,'3','CUAUHTEMOC NORTE','104-60','CUAUHTEMOC NORTE','JUSTO SIERRA','299','21200','',''),('192-75',2,1,'3','ZARAGOZA','104-60','Nueva','IGNACIO ZARAGOZA','1601','21100','',''),('192-76',3,1,'3','BAJA CALIFORNIA','104-60','Independencia','BLVD LAZARO CARDENAS','861','21290','',''),('192-77',3,1,'3','SANTA ISABEL','104-60','Real del Río','CARRETERA SANTA ISABEL ESQ YUGOSLAVIA','2900','21137','',''),('192-78',5,1,'3','LAS HADAS','104-60','Andalucía','CALZADA MANUEL GOMEZ MORIN','400','21217','',''),('192-79',2,1,'1','TLAXCALA Y 34 GARVA','104-89','Campestre','TLAXCALA','2308','83499','',''),('192-8',16,1,'1','GOLFO DE SANTA CLARA','104-89','Golfo de Santa Clara','LUIS ENCINAS','609','83540','',''),('192-80',4,1,'1','OBREGON Y 15','104-89','Residencias','OBREGON','1413','83448','',''),('192-81',2,1,'3','VILLAFONTANA','104-60','','','','21230','',''),('192-82',1,1,'3','SAN FELIPE','104-60','','','','0','',''),('192-83',1,1,'9','EL PECAS','104-106','VISTA ALAMAR','','18611','22450','',''),('192-84',3,1,'1','OBREGON Y 45','104-89','10 de Abril','AVENIDA OBREGON','4500','83459','',''),('192-85',1,1,'3','AKRON CABALLITO','104-60','INDUSTRIAL','ADOLFO LOPEZ MATEOS','701','0','',''),('192-86',1,1,'9','AKRON TJ95','104-106','','','','0','',''),('192-87',2,1,'9','AKRON TJ96','104-106','','','','0','',''),('192-88',2,1,'9','AKRON TJ97','104-106','','','','0','',''),('192-89',1,1,'1','SALSAS LOLAS','104-89','','','','0','',''),('192-9',14,1,'1','DALIAS Y 26','104-89','Mezquite','AVENIDA DALIAS A Y CALLE 26','2508 A','83488','',''),('192-90',2,1,'12','CLIENTES LOLAS HERMOSILLO','104-46','','','','0','',''),('192-91',5,1,'12','PADRE KINO INSUMOS ALMACEN','104-46','Centro Oriente','BLVD LUIS ENCINAS J','S/N','83000','',''),('192-92',1,1,'1','CASA DE CAMBIO','104-89','','','','0','',''),('192-93',3,1,'1','CENTROS CAMBIARIOS SL','104-89','','','','0','',''),('192-94',6,1,'4','SOBARZO','104-78','Luis Donaldo Colosio','JOSEFA ORTIZ DE DOMINGUEZ','268','83553','',''),('192-95',6,1,'15','CABORCA','104-15','Caborca Centro','DOMINGO QUIROZ Y MORA','222','83600','',''),('192-96',6,1,'16','NOGALES','104-70','Colinas Del Sur','AV ALVARO OBREGON','4428','84093','',''),('192-97',1,1,'17','HUATABAMPO','104-48','','','','0','',''),('192-98',1,1,'18','GUAYMAS','104-45','','','','0','',''),('192-99',1,1,'19','NAVOJOA','104-68','','','','0','',''),('78-1',1,1,'3','PROVEEDORA','104-60','VILLA BONITA','AV. VALLE DEL MEZQUITAL','2030','21378','','');
/*!40000 ALTER TABLE `ubicaciones` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2026-05-30  9:24:15