INSERT INTO `colonias` (`id_colonia`, `Clave`, `Descripcion`, `Ciudad`, `Municipio`, `Estado`) VALUES
(6562, '72559               ', 'HOGARES DEL BATAN', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6563, '72562               ', 'CAMPANARIO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6564, '72563               ', 'OBLATOS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6565, '72571               ', 'LA TIJERA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6566, '72572               ', 'LOMAS DE TABACHINES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6567, '72573               ', 'UNIDAD HABITACIONAL JOSE CLEMENTE OROZCO', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6568, '72577               ', 'EL SAUZ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6569, '72616               ', 'CUMBRES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6570, '72620               ', 'LOMAS JARDINES DE GUADALUPE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6571, '72630               ', 'FRACC. LOS ABETOS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6572, '72651               ', 'PLAZA GUADALUPE 2DA. SECC.', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6573, '72655               ', 'LA PERIQUERA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6574, '72656               ', 'ITALIA PROVIDENCIA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6575, '72668               ', 'GUADALUPE INN', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6576, '72677               ', 'BUGAMBILIAS SEGUNDA SECC.', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6577, '72679               ', 'INFONAVIT EL COLLI', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6578, '72690               ', 'MANTE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6579, '72693               ', 'VILLAS ALCALDE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6580, '72697               ', 'VILLA UNIVERSIDAD', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6581, '72698               ', 'SANTA MARIA DE JOCOTAN', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6582, '72703               ', 'FRACCIONAMIENTO NUEVA GALICIA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6583, '72705               ', 'EL COLLI INFONAVIT', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6584, '72706               ', 'VISTA DEL PINAR', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6585, '72711               ', 'RESIDENCIAL CORDILLERAS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6586, '72722               ', 'UNIDAD HABITACIONAL JOSE LOPEZ PORTILLO Y ROJAS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6587, '72723               ', 'PERIODISTAS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6588, '72725               ', 'MANUEL AVILA CAMACHO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6589, '72730               ', 'CONJUNTO VILLAS SAN JAVIER', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6590, '72731               ', 'BELENES NORTE INDUSTRIAL           ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6591, '72736               ', 'TERRAZAS MONRAZ ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6592, '72739               ', 'SANTA ENGRACIA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6593, '72746               ', 'EL COLLI C.T.M.', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6594, '72749               ', 'FRESNO DE ORIENTE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6595, '72756               ', 'CONDOMINIO NAVIO LA CALMA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6596, '72758               ', 'HOGARES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6597, '72759               ', 'LAS TORRES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6598, '72766               ', 'TALPITA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6599, '72770               ', 'LOMAS DE SAN ISIDRO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6600, '72775               ', 'UNIDAD MEXICO', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6601, '72778               ', 'CERRO DEL TESORO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6602, '72784               ', 'PARQUES TEPEYAC', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6603, '72791               ', 'CIUDAD BUGAMBILIAS 1RA. SECCION', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6604, '72797               ', 'LOMAS DEL 4', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6605, '72798               ', 'LA MORA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6606, '72800               ', 'CONDOMINIO LOBO', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6607, '72810               ', 'VICENTE GUERRERO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6608, '72813               ', 'CONJUNTO ZAPOPAN', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6609, '72821               ', 'ALAMEDAS DE TESISTAN', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6610, '72828               ', 'LA GRANA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6611, '72855               ', 'LAS CONCHITAS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6612, '72857               ', 'MESA COLORADA ORIENTE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6613, '72871               ', 'ALDRETE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6614, '72880               ', 'FRACCIONAMIENTO CHAPALITA INN', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6615, '72890               ', 'VILLAS DEL VALLE DE ATEMAJAC', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6616, '72892               ', 'CONJUNTO HERMENGILDO GALEANA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6617, '72897               ', 'LA MOJONERA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6618, '72899               ', 'VILLAS DE GUADALUPE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6619, '72901               ', 'RINCONADA PANAMERICANA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6620, '72910               ', 'MARCELINO GARCIA BARRAGAN', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6621, '72913               ', 'JARDINES DE SANTA MARGARITA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6622, '72919               ', 'CONDOMINIO VILLA ATEMAJAC', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6623, '72923               ', 'LOMAS INDEPENDENCIA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6624, '72925               ', 'CONJUNTO TRANCITO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6625, '72943               ', 'CHAPULTEPEC COUNTRY', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6626, '72944               ', 'UNIDAD HABITACIONAL ALAMOS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6627, '72946               ', 'LOMAS DE LA PRIMAVERA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6628, '72947               ', 'EL RETIRO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6629, '72951               ', 'PIRAMIDES DE LAS FUENTES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6630, '72963               ', 'LAS PIRAMIDES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6631, '72970               ', 'MARIMAR', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6632, '72973               ', 'JUAN MANUEL', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6633, '72979               ', 'LOS PALOMOS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6634, '72981               ', 'VILLAS DEL ESTADIO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6635, '72983               ', '27 DE SEPTIEMBRE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6636, '72992               ', 'CIRCUNVALACION GUEVARA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6637, '73010               ', 'OBSERVATORIO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6638, '73012               ', 'FRACCIONAMIENTO MIRADOR SAN ISIDRO', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6639, '73018               ', 'RINCONADA DEL AUDITORIO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6640, '73030               ', 'RESIDENCIAL LAS ARBOLEDAS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6641, '73039               ', 'RINCONADA DEL VALLE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6642, '73042               ', 'CONDOMINIO LOS LAURELES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6643, '73072               ', 'MANANTIAL', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6644, '73074               ', 'UNIDAD FOVISSSTE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6645, '73075               ', 'ESTATUTO JURIDICO FOVISSSTE', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6646, '73086               ', 'EL CAPULLO SEATTLE', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6647, '73091               ', 'CONJUNTO TANCITARO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6648, '73096               ', 'ANZURES', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6649, '73097               ', 'EL SAUCITO ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6650, '73100               ', 'VILLAS DE SAN IGNACIO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6651, '73104               ', 'SAN ANTONIO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6652, '73115               ', 'HACIENDAS DE LA CALMA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6653, '73116               ', 'RINCONADA LAS AZALEAS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6654, '73122               ', 'ANTIGUA CARRETERA TESISTAN', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6655, '73123               ', 'SAN GILBERTO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6656, '73129               ', 'VALLARTA DON BOSCO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6657, '73137               ', 'NOCHE BUENA DELEGACION BENITO JUAREZ', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6658, '73142               ', 'ARROYO HONDO 2A SECCION', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6659, '73158               ', 'CIRCUNVALACION OBLATOS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6660, '73164               ', 'VILLAS DEL COUNTRY', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6661, '73202               ', 'RESIDENCIAL SANTA MARGARITA        ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6662, '73213               ', 'BELLA VISTA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6663, '73217               ', 'ZONA INDUSTRIAL SUR ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6664, '73236               ', 'RESIDENCIAL JARDINES DE CHAPALA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6665, '73244               ', 'CONJUNTO TANCINTARO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6666, '73246               ', 'VILLAS DE TORREMOLINOS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6667, '73256               ', 'FRACCIONAMIENTO JUAN DIEGO', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6668, '73261               ', 'HACIENDA DEL VALLE', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6669, '73269               ', 'UNIDAD HABITACIONAL INFONAVIT COLON', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6670, '73273               ', 'RESIDENCIAL JUAN MANUEL', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6671, '73280               ', 'PARQUE INDUSTRIAL ZAPOPAN NORTE', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6672, '73281               ', 'RINCONADA DE GUADALUPE ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6673, '73286               ', 'CIUDAD BUGAMBILIAS SECC. PANORAMICA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6674, '73293               ', 'PATRIA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6675, '73310               ', 'BOSQUES DEL AUDITORIO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6676, '73321               ', 'SANTA CECILIA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6677, '73339               ', 'RANCHO NUEVO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6678, '73342               ', 'CONJUNTO HACIENDA BELENES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6679, '73345               ', 'TESISTAN', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6680, '73358               ', 'FRACCIONAMIENTO LAS CAÑADAS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6681, '73360               ', 'CIUDAD BUGAMBILIAS 2DA. SECCION', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6682, '73375               ', 'VENTA DEL ASTILLERO', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6683, '73384               ', 'VILLA SANTANDER', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6684, '73386               ', 'VILLAS VALLARTA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6685, '73413               ', 'INDUSTRIA                          ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6686, '73423               ', 'SAN GILBERTO CONDOMINIO LOS ABETOS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6687, '73430               ', 'PLAZA SAN ISIDRO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6688, '73433               ', 'LOS LAURELES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6689, '73435               ', 'SANTA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6690, '73438               ', 'PATRIA NUEVA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6691, '73444               ', 'UNIDAD INFONAVIT DEL COLLI', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6692, '73453               ', 'ZAPATA CENTRO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6693, '73454               ', 'SAUZ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6694, '73458               ', 'PARQUES INDEPENDENCIA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6695, '73478               ', 'PRIVADA AGRICOLA Y JUSTO SIERRA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6696, '73497               ', 'CASINOS TEPEYAC', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6697, '73498               ', 'TONALA CENTRO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6698, '73513               ', 'RINCONADA AMAPOLA                  ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6699, '73515               ', 'LOMA DORADA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6700, '73534               ', 'COMERCIAL DE ABASTOS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6701, '73549               ', 'JARDINES DEL SAUZ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6702, '73570               ', 'CONJUNTO LOS LAURELES', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6703, '73573               ', 'MIRAMAR DEL SOL', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6704, '73586               ', 'MOCTEZUMA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6705, '73588               ', 'BOSQUE ESCONDIDO                   ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6706, '73603               ', 'CONJUNTO RESIDENCIAL JACARANDAS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6707, '73604               ', 'RESIDENCIAL JACARANDAS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6708, '73618               ', 'LOMAS DEL VALLE TERCERA SECCION', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6709, '73628               ', 'BOSQUES DEL CENTINELA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6710, '73629               ', 'CAMPO DE POLO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6711, '73639               ', 'MARIANO BARCENAS Y BAÑUELOS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6712, '73660               ', 'RESIDENCIAL LA CRUZ', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6713, '73684               ', 'HIGERILLAS', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6714, '73701               ', 'FRACCIONAMIENTO GUADALUPE SUR', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6715, '73709               ', 'SAN JOSE DEL TAJO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6716, '73716               ', 'CONJUNTO SAN FRANCISCO', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6717, '73725               ', 'LOMAS DEL ALAMO', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6718, '73727               ', 'COUNTRY', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6719, '73730               ', 'VILLA ESMERALDA', 'ZPP                 ', 'ZPP                 ', 'Jal                 '),
(6720, '73738               ', 'CHAPULTEPEC ORIENTE', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6721, '73741               ', 'CONDOMINIO RESIDENCIAL ALMENDROS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6722, '73746               ', 'BOSQUES DEL VALLE', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6723, '73756               ', 'LAS CASITAS', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6724, '73758               ', 'COPALITA', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6725, '73771               ', 'SUTAJ', 'ZPP                 ', 'ZPP                 ', 'JAL                 '),
(6726, '177350              ', '.', 'ZPTR                ', 'ZPTR                ', 'JAL                 '),
(6727, '175073              ', '.', 'ZT                  ', 'ZT                  ', 'JAL                 '),
(6728, '176869              ', 'CENTRO', 'ZT                  ', 'ZT                  ', 'JAL                 '),
(6729, '178160              ', 'EL CALVARIO', 'ZT                  ', 'ZT                  ', 'JAL                 '),
(6730, '179247              ', 'BARRANCA LAURELES', 'ZT                  ', 'ZT                  ', 'JAL                 '),
(6731, '174524              ', 'CENTRO', 'APATZINGAN          ', 'APATZINGAN          ', 'MICH                '),
(6732, '174525              ', '.', 'APATZINGAN          ', 'APATZINGAN          ', 'MICH                '),
(6733, '70691               ', 'AVIACION', 'APATZINGAN          ', 'APATZINGAN          ', 'MICH                '),
(6734, '178007              ', 'CENTRO', 'ARS                 ', 'ARS                 ', 'MICH                '),
(6735, '175913              ', '.', 'BRISE               ', 'BRIS                ', 'MICH                '),
(6736, '176701              ', 'CENTRO', 'BRISE               ', 'BRIS                ', 'MICH                '),
(6737, '178594              ', 'PLAZA GUADALUPE', 'BRISE               ', 'BRIS                ', 'MICH                '),
(6738, '176725              ', 'CENTRO', 'CHAPA               ', 'CHA                 ', 'MICH                '),
(6739, '178224              ', 'CHAPARACO', 'CHAPA               ', 'CHA                 ', 'MICH                '),
(6740, '177790              ', 'CENTRO', 'CHAVI               ', 'CHAV                ', 'MICH                '),
(6741, '175635              ', '.', 'CR                  ', 'CR                  ', 'MICH                '),
(6742, '174842              ', 'S/C', 'IXTLAN              ', 'IXTLAN              ', 'MICH                '),
(6743, '174322              ', 'CENTRO', 'JAC                 ', 'JAC                 ', 'MICH                '),
(6744, '175568              ', 'FRACC. RIVERAS DEL CIELO', 'JACO                ', 'JACO                ', 'MICH                '),
(6745, '176426              ', 'BUENOS AIRES', 'JACO                ', 'JACO                ', 'MICH                '),
(6746, '177092              ', 'CENTRO', 'JACO                ', 'JACO                ', 'MICH                '),
(6747, '177967              ', 'FRACC. EL ENSUEÑO', 'JACO                ', 'JACO                ', 'MICH                '),
(6748, '175636              ', '.', 'JQ                  ', 'JQ                  ', 'MICH                '),
(6749, '176756              ', 'CENTRO', 'JQ                  ', 'JQ                  ', 'MICH                '),
(6750, '175534              ', 'EMILIANO ZAPATA', 'LAZARO CARDENAS     ', 'LAZARO CARDENAS     ', 'MICH                '),
(6751, '175916              ', '600 CASAS', 'LAZARO CARDENAS     ', 'LAZARO CARDENAS     ', 'MICH                '),
(6752, '177140              ', 'LAZARO CARDENAS', 'LAZARO CARDENAS     ', 'LAZARO CARDENAS     ', 'MICH                '),
(6753, '177818              ', 'VALLE DEL TECNOLOGICO', 'LAZARO CARDENAS     ', 'LAZARO CARDENAS     ', 'MICH                '),
(6754, '70444               ', 'CENTRO', 'LAZARO CARDENAS     ', 'LAZARO CARDENAS     ', 'MICH                '),
(6755, '174297              ', 'PRADOS VERDES', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6756, '174453              ', 'LOMAS DE HIGALGO', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6757, '174476              ', 'CENTRO', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6758, '174500              ', 'CIUDAD INDUSTRIAL', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6759, '174630              ', 'AMPLIACIÓN ANA MARÍA GALLAGA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6760, '174786              ', 'XANGARI', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6761, '174925              ', 'NUEVA CHAPULTEPEC', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6762, '174966              ', 'PASEO DE LAS LOMAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6763, '175038              ', 'INDUSTRIAL', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6764, '175160              ', 'LAS FLORES', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6765, '175163              ', 'CUAUHTEMOC', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6766, '175189              ', 'VASCO DE QUIROGA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6767, '175190              ', 'ELECTRICISTAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6768, '175290              ', 'CHAPULTEPEC SUR', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6769, '175302              ', 'CAMELINAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6770, '175325              ', 'FCO. L. MUJICA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6771, '175330              ', 'FRACCIONAMIENTO MICHELENA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6772, '175503              ', 'FRACC. LAS AMERICAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6773, '175596              ', 'AMPLIACION EL PORVENIR', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6774, '175736              ', 'AGUSTIN ARRIAGA RIVERA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6775, '176269              ', 'HACIENDA DE LA HUERTA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6776, '176275              ', 'SAN JOSE DE GRACIA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6777, '176518              ', 'AGUA CLARA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6778, '176668              ', 'OBRERA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6779, '176842              ', 'DEL EMPLEADO', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6780, '176894              ', 'LAS AMERICAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6781, '176926              ', 'POBLADO OCOLUSEN', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6782, '176976              ', 'EXHACIENDA SAN JOSE DE LA HUERTA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6783, '177108              ', 'BALCONES DE SANTA MARIA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6784, '177141              ', 'LAZARO CARDENAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6785, '177344              ', 'SANTIAGUITO', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6786, '177458              ', 'GUADALUPE', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6787, '177488              ', 'ENRIQUE RAMIREZ', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6788, '177506              ', 'LAGO II', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6789, '177565              ', 'RESIDENCIAL BOSQUES', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6790, '177613              ', 'AMPLIACION DE OCOLUSEN', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6791, '177629              ', 'GERTRUDIS BOCANEGRA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6792, '177786              ', 'AMERICAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6793, '178068              ', 'LOMAS DE SANTA MARIA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6794, '178078              ', 'CINCO DE MAYO', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6795, '178181              ', 'CHAPULTEPEC ORIENTE', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6796, '178262              ', 'FELIX IRETA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6797, '178307              ', 'RINCON QUIETO', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6798, '178466              ', 'FRACCIONAMIENTO TERRAZAS DEL CAMPESTRE', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6799, '178503              ', 'BOSQUE CAMELINAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6800, '178820              ', 'MICHELENA', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6801, '178834              ', 'FRACCIONAMIENTO LOS ANGELES', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6802, '178851              ', 'TRES MARIAS', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6803, '72389               ', 'SAN RAFAEL', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6804, '73572               ', 'CHAPULTEPEC NORTE', 'MORELIA             ', 'MORELIA             ', 'MICH                '),
(6805, '176342              ', 'CENTRO', 'PARACHO             ', 'PARACHO             ', 'MICH                '),
(6806, '176987              ', 'CENTRO', 'PATZCUA             ', 'PATZCUA             ', 'MICH                '),
(6807, '174968              ', 'CENTRO', 'PER                 ', 'PER                 ', 'MICH                '),
(6808, '174978              ', '.', 'PER                 ', 'PER                 ', 'MICH                '),
(6809, '174221              ', 'CUIDAD DEL SOL', 'PIEDAD              ', 'PIEDAD              ', 'MICH                '),
(6810, '174554              ', '.', 'PIEDAD              ', 'PIEDAD              ', 'MICH                '),
(6811, '175004              ', 'LA PURISIMA', 'PIEDAD              ', 'PIEDAD              ', 'MICH                '),
(6812, '175672              ', 'SANTA FE', 'PIEDAD              ', 'PIEDAD              ', 'MICH                '),
(6813, '178240              ', 'BANQUETES', 'PIEDAD              ', 'PIEDAD              ', 'MICH                '),
(6814, '174774              ', 'CENTRO', 'RYS                 ', 'RYS                 ', 'MICH                '),
(6815, '174981              ', '.', 'RYS                 ', 'RYS                 ', 'MICH                '),
(6816, '177937              ', 'NORIA DE MONTES', 'SAHUAYO             ', 'SAHUAYO             ', 'MICH                '),
(6817, '177938              ', 'SAN ONOFRE', 'SAHUAYO             ', 'SAHUAYO             ', 'MICH                '),
(6818, '177940              ', 'LAS BRISAS', 'SAHUAYO             ', 'SAHUAYO             ', 'MICH                '),
(6819, '177941              ', 'TUNA MANZA', 'SAHUAYO             ', 'SAHUAYO             ', 'MICH                '),
(6820, '72280               ', 'CENTRO', 'SAHUAYO             ', 'SAHUAYO             ', 'MICH                '),
(6821, '174288              ', 'CENTRO', 'SNJOSE              ', 'SNJOSE              ', 'MICH                '),
(6822, '176478              ', '.', 'SNJOSE              ', 'SNJOSE              ', 'MICH                '),
(6823, '174264              ', 'SAN MARCOS', 'TARIM               ', 'TARIM               ', 'MICH                '),
(6824, '176403              ', 'CENTRO', 'TARIM               ', 'TARIM               ', 'MICH                '),
(6825, '176404              ', '.', 'TARIM               ', 'TARIM               ', 'MICH                '),
(6826, '174533              ', 'CASA DEL NIÑO', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6827, '174928              ', 'LA PINERA', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6828, '175216              ', 'CENTRO', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6829, '175326              ', '.', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6830, '175715              ', 'MORELOS', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6831, '176142              ', 'GPE.VICTORIA', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6832, '177135              ', 'LA MAGDALENA', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6833, '177258              ', 'FERROCARRILERA', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6834, '177607              ', 'LOS ANGELES', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6835, '177838              ', 'LA COFRADIA', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6836, '179192              ', 'LAZARO CARDENAS', 'URUAPAN             ', 'URUAPAN             ', 'MICH                '),
(6837, '175742              ', '.', 'VISHER              ', 'VISHER              ', 'MICH                '),
(6838, '175566              ', '.', 'YURECUARO           ', 'YURECUARO           ', 'MICH                '),
(6839, '174301              ', 'CENTRO', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6840, '175075              ', 'NORTE CENTRO', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6841, '175357              ', 'EJIDAL', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6842, '175541              ', 'CENTRO ARCOS', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6843, '175640              ', 'JARDINADAS', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6844, '175836              ', 'DEL VALLE', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6845, '175912              ', 'JARDIN DE CATEDRAL', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6846, '178005              ', 'LAS FUENTES', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6847, '178684              ', 'JARDINES DE CATEDRAL', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6848, '178689              ', 'LA NUEVA LUNETA', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6849, '178769              ', 'LA FLORIDA SAN PATRICIO', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6850, '178816              ', 'ARBOLEDAS', 'ZAM                 ', 'ZAM                 ', 'MICH                '),
(6851, '174614              ', 'MODERNA', 'ZAPU                ', 'ZAPU                ', 'MICH                '),
(6852, '176255              ', 'MOJICA', 'ZAPU                ', 'ZAPU                ', 'MICH                '),
(6853, '176257              ', 'SAN MIGUEL', 'ZAPU                ', 'ZAPU                ', 'MICH                '),
(6854, '176347              ', 'PARQUE INDUSTRIAL CUAHTLA', 'AY                  ', 'AYA                 ', 'MOR                 '),
(6855, '174550              ', 'CHIPITLAM', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6856, '174615              ', 'MARAVILLAS', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6857, '174961              ', 'ACAPANTZINGO', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6858, '175109              ', 'TLALTENANGO', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6859, '175435              ', '.', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6860, '175704              ', 'RICARDO FLORES MAGON', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6861, '176251              ', 'AMATITLAN', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6862, '176353              ', 'LOMAS DE LA SELVA', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6863, '176400              ', 'TETELA DEL MONTE', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6864, '176402              ', 'HACIENDA TETELA', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6865, '176891              ', 'MIRAVAL', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6866, '176906              ', 'LOMAS  DEL TZOMPANTLE', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6867, '177094              ', 'LA PRADERA', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6868, '177095              ', 'CENTRO', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6869, '177721              ', 'SATELITE 2 DA. SECCION', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6870, '178194              ', 'LAS PALMAS SUR', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6871, '178498              ', 'LAS PALMAS', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6872, '178512              ', 'LOMAS DEL MIRADOR', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6873, '179160              ', 'QUINTAS MARTHA', 'CUERNA              ', 'CUERNA              ', 'MOR                 '),
(6874, '175436              ', '.', 'JIUTE               ', 'JIUTE               ', 'MOR                 '),
(6875, '175870              ', 'BUGAMBILIAS', 'JIUTE               ', 'JIUTE               ', 'MOR                 '),
(6876, '176968              ', 'TLAHUAPAN', 'JIUTE               ', 'JIUTE               ', 'MOR                 '),
(6877, '177687              ', 'CIVAC', 'JIUTE               ', 'JIUTE               ', 'MOR                 '),
(6878, '178822              ', 'TEJALPA', 'JIUTE               ', 'JIUTE               ', 'MOR                 '),
(6879, '176633              ', 'MIGUEL HIDALGO', 'TMCO                ', 'TMCO                ', 'MOR                 '),
(6880, '176634              ', '.', 'TMCO                ', 'TMCO                ', 'MOR                 '),
(6881, '177766              ', 'LOMAS DE CUERNAVACA', 'TMCO                ', 'TMCO                ', 'MOR                 '),
(6882, '177298              ', 'VILLAS DE XOCHITEPEC', 'XOCHIT              ', 'XOCHIT              ', 'MOR                 '),
(6883, '177473              ', 'FELIPE NERI', 'YAUT                ', 'YAU                 ', 'MOR                 '),
(6884, '177113              ', 'CENTRO', 'ACAPNTA             ', 'ACAPNTA             ', 'NAYARIT             '),
(6885, '175867              ', 'CENTRO', 'ACAPO               ', 'ACAPNTA             ', 'NAYARIT             '),
(6886, '175868              ', '.', 'ACAPO               ', 'ACAPNTA             ', 'NAYARIT             '),
(6887, '176841              ', 'CENTRO', 'AHUACATLN           ', 'AHUACATLN           ', 'NAYARIT             '),
(6888, '174303              ', 'NUEVO VALLARTA', 'BAH                 ', 'BAH                 ', 'NAYARIT             '),
(6889, '175289              ', 'FLAMINGOS NAYARTA', 'BAH                 ', 'BAH                 ', 'NAYARIT             '),
(6890, '175999              ', 'DORADA BUCERIAS', 'BAH                 ', 'BAH                 ', 'NAYARIT             '),
(6891, '176627              ', 'S/C', 'BAH                 ', 'BAH                 ', 'NAYARIT             '),
(6892, '176722              ', 'PUNTA DE MITA', 'BAH                 ', 'BAH                 ', 'NAYARIT             '),
(6893, '177597              ', 'EMILIANO ZAPATA', 'BAH                 ', 'BAH                 ', 'NAYARIT             '),
(6894, '177630              ', 'COSTA CORAL', 'BAH                 ', 'BAH                 ', 'NAYARIT             '),
(6895, '178113              ', 'VALLE DORADO', 'BAH                 ', 'BAH                 ', 'NAYARIT             '),
(6896, '178116              ', 'Valle Dorado', 'MEZCA               ', 'BAH                 ', 'NAYARIT             '),
(6897, '174499              ', 'LAS PALMAS', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6898, '174675              ', 'SIN COLONIA', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6899, '174822              ', 'LOMAS HUANACAXTLE', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6900, '175117              ', 'BUENOS AIRES', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6901, '175140              ', 'DORADA', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6902, '175438              ', '.', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6903, '175515              ', 'CENTRO', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6904, '176552              ', 'FLAMINGOS', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6905, '177189              ', 'LA DORADA', 'BUC                 ', 'BUC                 ', 'NAYARIT             '),
(6906, '175514              ', 'CENTRO', 'COMPOSTLA           ', 'COMPOSTLA           ', 'NAYARIT             '),
(6907, '175528              ', '.', 'COMPOSTLA           ', 'COMPOSTLA           ', 'NAYARIT             '),
(6908, '179332              ', 'JUAN ESCUTIA BORBOLLON', 'COMPOSTLA           ', 'COMPOSTLA           ', 'NAYARIT             '),
(6909, '176839              ', 'GARZAS ROSAS', 'JALTEMBA            ', 'COMPOSTLA           ', 'NAYARIT             '),
(6910, '177947              ', 'CENTRO', 'JALTEMBA            ', 'COMPOSTLA           ', 'NAYARIT             '),
(6911, '177110              ', 'GARZAS ROSAS', 'PEÑITA              ', 'COMPOSTLA           ', 'NAYARIT             '),
(6912, '174830              ', 'CENTRO', 'IXTRIO              ', 'IXTRIO              ', 'NAYARIT             '),
(6913, '175068              ', '.', 'IXTRIO              ', 'IXTRIO              ', 'NAYARIT             '),
(6914, '177212              ', 'JARRETADERAS', 'JARRE               ', 'JARRE               ', 'NAYARIT             '),
(6915, '178334              ', '.', 'JOM                 ', 'JOM                 ', 'NAYARIT             '),
(6916, '175667              ', 'CENTRO', 'LCHU                ', 'LCH                 ', 'NAYARIT             '),
(6917, '175513              ', '.', 'LPEN                ', 'LPEN                ', 'NAYARIT             '),
(6918, '176838              ', 'GARZAS ROSAS', 'LPEN                ', 'LPEN                ', 'NAYARIT             '),
(6919, '175512              ', '.', 'LSVRAS              ', 'LSVRAS              ', 'NAYARIT             '),
(6920, '176899              ', 'FRACC. VALLE DORADO', 'MEZCALITOS          ', 'MEZCALITOS          ', 'NAYARIT             '),
(6921, '175523              ', '.', 'MZLA                ', 'MZLA                ', 'NAYARIT             '),
(6922, '176136              ', 'FRACCIONAMIENTO VALLE DORADO', 'MZLA                ', 'MZLA                ', 'NAYARIT             '),
(6923, '174494              ', '.', 'NVOVALLA            ', 'NVOVALLA            ', 'NAYARIT             '),
(6924, '175616              ', 'NUEVO VALLARTA', 'NVOVALLA            ', 'NVOVALLA            ', 'NAYARIT             '),
(6925, '175663              ', 'FRACCIONAMIENTO NUEVO VALLARTA', 'NVOVALLA            ', 'NVOVALLA            ', 'NAYARIT             '),
(6926, '175744              ', 'FRACCIONAMIENTO NAUTICO TURISTICO', 'NVOVALLA            ', 'NVOVALLA            ', 'NAYARIT             '),
(6927, '178112              ', 'VALLE DORADO', 'NVOVALLA            ', 'NVOVALLA            ', 'NAYARIT             '),
(6928, '178241              ', 'BAHIA DE BANDERAS', 'NVOVALLA            ', 'NVOVALLA            ', 'NAYARIT             '),
(6929, '178440              ', 'FRACCIONAMIENTO COSTA CORAL', 'NVOVALLA            ', 'NVOVALLA            ', 'NAYARIT             '),
(6930, '178502              ', 'VILLA ESMERALDA', 'NVOVALLA            ', 'NVOVALLA            ', 'NAYARIT             '),
(6931, '178443              ', '.', 'PIE                 ', 'PIE                 ', 'NAYARIT             '),
(6932, '175664              ', '.', 'PM                  ', 'PM                  ', 'NAYARIT             '),
(6933, '175727              ', 'JACARANDAS', 'RINGUA              ', 'RINGUA              ', 'NAYARIT             '),
(6934, '176625              ', '.', 'RINGUA              ', 'RINGUA              ', 'NAYARIT             '),
(6935, '176626              ', 'RINCON DE GUAYABITOS', 'RINGUA              ', 'RINGUA              ', 'NAYARIT             '),
(6936, '175865              ', '.', 'RUZ                 ', 'RUIZ                ', 'NAYARIT             '),
(6937, '175866              ', 'CENTRO', 'RUZ                 ', 'RUIZ                ', 'NAYARIT             '),
(6938, '175862              ', 'CENTRO', 'SANT                ', 'SAINX               ', 'NAYARIT             '),
(6939, '176499              ', 'VALLE LERMA', 'SANT                ', 'SAINX               ', 'NAYARIT             '),
(6940, '176848              ', 'CENTRO', 'CHAPALILLA          ', 'SAMAO               ', 'NAYARIT             '),
(6941, '177004              ', 'CENTRO', 'SMOCHA              ', 'SAMAO               ', 'NAYARIT             '),
(6942, '177585              ', '.', 'SAYU                ', 'SAYU                ', 'NAYARIT             '),
(6943, 'BAIRES              ', 'BUENOS AIRES', 'BAND                ', 'TEPIC               ', 'NAYARIT             '),
(6944, '173812              ', 'MENCHACA', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6945, '174369              ', 'CIUDAD INDUSTRIAL', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6946, '174420              ', 'CENTRO DE LA CRUZ DE HUANACAXTLE', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6947, '174604              ', 'CENTRO', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6948, '174750              ', 'LOPEZ MATEOS', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6949, '174769              ', 'PEDREGAL', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6950, '174912              ', 'ELECTRICISTA', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6951, '175046              ', 'CIUDAD DEL VALLE', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6952, '175060              ', 'NORTE CENTRO', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6953, '175142              ', 'DORADA', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6954, '175149              ', 'RINCON DE SAN JUAN', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6955, '175267              ', 'DIAZ ORDAZ', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6956, '175437              ', 'S/C', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6957, '175757              ', 'H. CASAS', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6958, '176194              ', 'FRACC.NAUTICO TURISTICO', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6959, '176381              ', 'FRACCIONAMIENTO ESTADIOS', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6960, '176584              ', 'PUENTE DE SAN CAYETANO', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6961, '176716              ', 'CAJA DE AGUA', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6962, '177064              ', 'VILLA DE LA PAZ', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6963, '177231              ', 'CAMINERA', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6964, '177274              ', 'LLANITOS', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6965, '177437              ', 'FRESNOS', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6966, '177652              ', 'FRACCIONAMIENTO VALLE DEL COUNTRY', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6967, '177655              ', 'MOLOLOA', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6968, '177908              ', 'FRACC. JARDINES DE LA CRUZ', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6969, '178070              ', 'LO DE LAMEDO', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6970, '178309              ', 'EL PEDREGAL', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6971, '178417              ', 'FRACC. JACARANDAS', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6972, '178487              ', 'EL MIRADOR', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6973, '178550              ', 'LAGOS DEL COUNTRY', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6974, '178622              ', 'LOS SAUCES', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6975, '178775              ', 'FRACC. LOS LIMONES', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             ');
INSERT INTO `colonias` (`id_colonia`, `Clave`, `Descripcion`, `Ciudad`, `Municipio`, `Estado`) VALUES
(6976, '178828              ', 'FRACC. CIUDAD DEL VALLE', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6977, '179071              ', 'CANDIDO SALAZAR', 'TEPIC               ', 'TEPIC               ', 'NAYARIT             '),
(6978, '175869              ', 'CENTRO', 'TUXPAN              ', 'TUXPAN              ', 'NAYARIT             '),
(6979, '177484              ', '.', 'VILLAH              ', 'VILLAH              ', 'NAYARIT             '),
(6980, '177485              ', 'CENTRO', 'VILLAH              ', 'VILLAH              ', 'NAYARIT             '),
(6981, '174321              ', 'CENTRO', 'XAL                 ', 'XAL                 ', 'NAYARIT             '),
(6982, '175241              ', 'BENITO JUAREZ', 'ALL                 ', 'ALL                 ', 'NL                  '),
(6983, '176467              ', 'CENTRO', 'ALL                 ', 'ALL                 ', 'NL                  '),
(6984, '174587              ', '.', 'APOD                ', 'APOD                ', 'NL                  '),
(6985, '174831              ', 'MOISES SAENS', 'APOD                ', 'APOD                ', 'NL                  '),
(6986, '175359              ', 'EL MILAGRO', 'APOD                ', 'APOD                ', 'NL                  '),
(6987, '175563              ', 'ANTIGUA COMUNIDAD SAN FRANCISCO', 'APOD                ', 'APOD                ', 'NL                  '),
(6988, '176091              ', 'PARQUE INDUSTRIAL MONTERREY', 'APOD                ', 'APOD                ', 'NL                  '),
(6989, '176685              ', 'PARQUE INDUSTRIAL STIVA AEROPUERTO', 'APOD                ', 'APOD                ', 'NL                  '),
(6990, '176772              ', 'REGIO PARQUE INDUSTRIAL', 'APOD                ', 'APOD                ', 'NL                  '),
(6991, '176882              ', 'RESIDENCIAL DE LOS ROBLES', 'APOD                ', 'APOD                ', 'NL                  '),
(6992, '177055              ', 'PARQUE INDUSTRIAL FINSA MONTERREY', 'APOD                ', 'APOD                ', 'NL                  '),
(6993, '177340              ', 'SANTA ROSA', 'APOD                ', 'APOD                ', 'NL                  '),
(6994, '177448              ', 'PRIVADAS PREMIER', 'APOD                ', 'APOD                ', 'NL                  '),
(6995, '177750              ', 'COLONIAL APODACA', 'APOD                ', 'APOD                ', 'NL                  '),
(6996, '177833              ', 'EL MEZQUITAL', 'APOD                ', 'APOD                ', 'NL                  '),
(6997, '177881              ', 'REGIO PARQUE', 'APOD                ', 'APOD                ', 'NL                  '),
(6998, '178009              ', 'MONTERREY BUSINESS PARK', 'APOD                ', 'APOD                ', 'NL                  '),
(6999, '178137              ', 'APODACA  CENTRO', 'APOD                ', 'APOD                ', 'NL                  '),
(7000, '178331              ', 'CASA BLANCA', 'APOD                ', 'APOD                ', 'NL                  '),
(7001, '178426              ', 'MAGNOLIAS', 'APOD                ', 'APOD                ', 'NL                  '),
(7002, '178499              ', 'CENTRO', 'APOD                ', 'APOD                ', 'NL                  '),
(7003, '178614              ', 'ZONA INDUSTRIAL', 'APOD                ', 'APOD                ', 'NL                  '),
(7004, '178643              ', 'FRACC.  VALLES DE HUINALA 2do  SECTOR', 'APOD                ', 'APOD                ', 'NL                  '),
(7005, '178675              ', 'PARQUE INDUSTRIAL KALOS', 'APOD                ', 'APOD                ', 'NL                  '),
(7006, '178865              ', 'LOMAS DE LA PAZ', 'APOD                ', 'APOD                ', 'NL                  '),
(7007, '178913              ', 'PARQUE INDUSTRIAL STIVA-APTO', 'APOD                ', 'APOD                ', 'NL                  '),
(7008, '179234              ', 'TECHNOLOGY PARK', 'APOD                ', 'APOD                ', 'NL                  '),
(7009, '179235              ', 'PASEO DE LAS PALMAS', 'APOD                ', 'APOD                ', 'NL                  '),
(7010, '174775              ', '.', 'CAD                 ', 'CAD                 ', 'NL                  '),
(7011, '178231              ', 'HDA. LA TRINIDAD', 'CAD                 ', 'CAD                 ', 'NL                  '),
(7012, '178845              ', 'LOPEZ MATEOS 1er. SECTOR', 'CAD                 ', 'CAD                 ', 'NL                  '),
(7013, '178848              ', 'CANDELARIA RIOS ', 'CAD                 ', 'CAD                 ', 'NL                  '),
(7014, '177682              ', 'PARQUE INDUSTRIAL EL CARMEN', 'CARM                ', 'CARMEN              ', 'NL                  '),
(7015, '177683              ', '.', 'CARM                ', 'CARMEN              ', 'NL                  '),
(7016, '178571              ', 'NORBERTO AGUIRRE', 'CATALINA            ', 'CATALINA            ', 'NL                  '),
(7017, '174252              ', 'FRACC. INDUSTRIAL FICOS', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7018, '174785              ', 'MERCADO DE ABASTOS', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7019, '174894              ', 'FRACCIONAMIENTO UNIDAD NACIONAL', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7020, '175185              ', 'LAFAMA', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7021, '175442              ', '.', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7022, '176260              ', 'FRAC. INDUSTRIAL EL LECHUGAL', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7023, '176383              ', 'ZIMIX', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7024, '177034              ', 'TRABAJADORES', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7025, '177091              ', 'ZONA INDUSTRIAL', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7026, '177423              ', 'CENTRO', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7027, '177549              ', 'RINCON DEL PONIENTE', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7028, '177675              ', 'EL LECHUGAL', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7029, '177763              ', 'ANTIGUO LECHUGAL', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7030, '177797              ', 'ENRIQUE RANGEL', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7031, '178195              ', 'AURORITA ', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7032, '178432              ', 'MARTIREZ DE CANANEA', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7033, '178572              ', 'NORBERTO AGUIRRE', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7034, '179020              ', 'PIO XII', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7035, '179079              ', 'FRACC.  INDUSTRIAL MONTE DE LOS OLIVOS', 'CATARINA            ', 'CATARINA            ', 'NL                  '),
(7036, '177877              ', 'CENTRO', 'BENITO              ', 'CBJ                 ', 'NL                  '),
(7037, '177890              ', 'SAN ANTONIO', 'BENITO              ', 'CBJ                 ', 'NL                  '),
(7038, '175444              ', '.', 'CDGPE               ', 'CDGPE               ', 'NL                  '),
(7039, '176210              ', 'ESMERALDA', 'CDGPE               ', 'CDGPE               ', 'NL                  '),
(7040, '176211              ', 'CENTRO', 'CDGPE               ', 'CDGPE               ', 'NL                  '),
(7041, '178773              ', 'LA FUENTE', 'CDGPE               ', 'CDGPE               ', 'NL                  '),
(7042, '178774              ', 'VILLA SAN ANTONIO', 'CDGPE               ', 'CDGPE               ', 'NL                  '),
(7043, '177105              ', 'CENTRO', 'CF                  ', 'CF                  ', 'NL                  '),
(7044, '174354              ', 'HACIENDA DE ANAHUAC', 'ESC                 ', 'ESC                 ', 'NL                  '),
(7045, '174580              ', 'CENTRO', 'ESC                 ', 'ESC                 ', 'NL                  '),
(7046, '175128              ', '..', 'ESC                 ', 'ESC                 ', 'NL                  '),
(7047, '175973              ', 'LOS ELIZONDO', 'ESC                 ', 'ESC                 ', 'NL                  '),
(7048, '177478              ', 'VALLE DEL CANADA', 'ESC                 ', 'ESC                 ', 'NL                  '),
(7049, '178124              ', 'RESIDENCIAL NEXXUS', 'ESC                 ', 'ESC                 ', 'NL                  '),
(7050, '178198              ', 'LAS MALVINAS', 'ESC                 ', 'ESC                 ', 'NL                  '),
(7051, '178831              ', 'PARQUE INDUSTRIAL ESCOBEDO', 'ESC                 ', 'ESC                 ', 'NL                  '),
(7052, 'LA TALA             ', 'LA TALAVERA MODULO SOCIAL', 'FOVIS               ', 'FOVIS               ', 'NL                  '),
(7053, 'LA TALAV            ', 'LA TALAVERNA MODULO SOCIAL', 'FOVIS               ', 'FOVIS               ', 'NL                  '),
(7054, '179526              ', 'NUEVA CASTILLA', 'GENE                ', 'GENES               ', 'NL                  '),
(7055, '174253              ', 'FRACCIONAMIENTO SAN SEBASTIAN', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7056, '174343              ', 'CUESTA VERDE', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7057, '174363              ', 'LIBERTAD', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7058, '174570              ', 'JOSEFA ZOZAYA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7059, '174730              ', 'CERRO AZUL', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7060, '174747              ', 'RINCON DE GUADALUPE', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7061, '174809              ', 'TORRES DE LINDAVISTA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7062, '175002              ', 'PARQUE INDUSTRIAL LA SILLA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7063, '175054              ', 'FRACC. INDUSTRIAL VIGA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7064, '175441              ', 'HERCULES', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7065, '175849              ', 'PARAISO', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7066, '176171              ', 'DIVISION DEL NORTE', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7067, '176317              ', 'CENTRAL DE GARGA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7068, '176377              ', 'COUNTRY SOL', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7069, '176613              ', 'LA PURISIMA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7070, '176932              ', 'PARQUE INDUSTRIAL SAN RAFAEL', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7071, '176986              ', 'CAMINO REAL', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7072, '177328              ', 'FRACC. LA JOYITA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7073, '177404              ', 'ARBOLEDAS DE ACAPULCO', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7074, '177548              ', 'TIERRA PROPIA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7075, '177708              ', 'TERRENOS DE LA EXPOSICION GANADERA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7076, '177723              ', 'SAN RAFAEL', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7077, '177929              ', '31 DE DICIEMBRE', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7078, '177986              ', 'RINCON DE LA PRIMAVERA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7079, '178101              ', 'LOS CRISTALES 2DO SECTOR', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7080, '178244              ', 'LA FLORESTA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7081, '178277              ', 'FRACC AZTECA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7082, '178336              ', 'FRACC. INDUSTRIAL LAS AMERICAS', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7083, '178518              ', 'MISION SANTA FE', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7084, '178593              ', 'PARQUE INDUSTRIAL AVANTE', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7085, '178611              ', 'RIVERAS DE LA SILLA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7086, '178612              ', 'VALLE DE SAN RAFAEL', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7087, '178633              ', 'CANTERA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7088, '178637              ', 'LA TALAVERA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7089, '179170              ', '15 DE MAYO', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7090, '73764               ', 'LINDAVISTA', 'GPE                 ', 'GPE                 ', 'NL                  '),
(7091, '177447              ', '.', 'GTRN                ', 'GTRN                ', 'NL                  '),
(7092, '174906              ', 'CENTRO', 'LIN                 ', 'LIN                 ', 'NL                  '),
(7093, '173853              ', '15 DE MAYO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7094, '173888              ', 'CENTRO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7095, '173905              ', 'EJIDOS DE SAN PEDRO MARTIR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7096, '173906              ', 'LOMAS DEL NILO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7097, '173961              ', 'CENTRAL DE CARGA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7098, '174047              ', 'COUNTRY', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7099, '174226              ', 'LIBERTAD', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7100, '174227              ', 'LEONES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7101, '174241              ', 'BRISAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7102, '174242              ', 'CENTRAL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7103, '174243              ', 'FRACC. INDUSTRIAL FICOS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7104, '174244              ', 'SANTA CATARINA NUEVO LEON', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7105, '174254              ', 'MODERNA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7106, '174278              ', 'VISTA SOL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7107, '174289              ', 'REGINA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7108, '174308              ', 'TERMINAL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7109, '174314              ', 'DEL NORTE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7110, '174333              ', 'BERNARDO REYES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7111, '174367              ', 'BUENOS AIRES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7112, '174382              ', 'NUEVO REPUEBLO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7113, '174405              ', 'OBRERA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7114, '174424              ', 'CHEPEVERA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7115, '174449              ', 'LIBRAMIENTO NORESTE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7116, '174455              ', 'MARIA LUISA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7117, '174472              ', 'SALINAS VICTORIA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7118, '174543              ', 'VISTA HERMOSA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7119, '174545              ', 'LOS ALTOS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7120, '174548              ', 'VALLE DE INFONAVIT 5to. SECTOR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7121, '174564              ', 'SANTA CECILIA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7122, '174567              ', 'URDIALES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7123, '174583              ', 'SAN JERONIMO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7124, '174635              ', 'COLONIA ROMA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7125, '174641              ', 'TECNOLOGICO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7126, '174666              ', 'FRACC. INDUSTRIAL BENITO JUAREZ', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7127, '174685              ', 'MITRAS NORTE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7128, '174691              ', 'LOMAS MODELO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7129, '174729              ', 'EMPLEADOS SFEO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7130, '174758              ', 'COYOACAN', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7131, '174782              ', 'PIO X', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7132, '174804              ', 'ESPANZUELA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7133, '174805              ', 'ESTANZUELA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7134, '174806              ', 'OBISPADO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7135, '174840              ', 'FRACCIONAMIENTO BUENOS AIRES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7136, '174858              ', 'COLINAS DE SAN JERONIMO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7137, '174872              ', 'BUROCRATAS DEL ESTADO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7138, '174890              ', 'MEXICO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7139, '174900              ', 'VILLA DEL RIO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7140, '174927              ', 'LAS TORRES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7141, '174946              ', 'JARDINES DE LAS CUMBRES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7142, '174956              ', 'TREVIÑO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7143, '174959              ', 'EL MIRADOR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7144, '174994              ', 'FIERRO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7145, '175000              ', 'AMPLIACION VALLE DEL MIRADOR ', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7146, '175036              ', 'DEL VALLE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7147, '175049              ', 'ANTONIO I. VILLAREAL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7148, '175076              ', '.', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7149, '175082              ', 'SAN NICOLAS DE LOS GARZA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7150, '175083              ', 'NUEVAS COLONIAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7151, '175088              ', 'CENTRO PATIO SANTA ROSA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7152, '175110              ', 'CHURUBUSCO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7153, '175137              ', 'BALCONES DE ALTA VISTA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7154, '175188              ', 'MIRAVALLE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7155, '175197              ', 'FRANCISCO I MADERO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7156, '175206              ', 'BELLAVISTA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7157, '175208              ', 'RINCON DE SAN GERONIMO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7158, '175210              ', 'LOS FRESNOS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7159, '175236              ', 'RESIDENCIAL LINCOLN', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7160, '175300              ', 'VALLE DE BRISAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7161, '175336              ', 'CONTRY', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7162, '175337              ', 'JUANA ARCO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7163, '175562              ', ' ', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7164, '175572              ', 'DEL CARMEN', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7165, '175579              ', 'SANTA MARIA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7166, '175622              ', 'MITRAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7167, '175631              ', 'VILLA LAS FUENTES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7168, '175673              ', 'DEPORTIVO OBISPADO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7169, '175701              ', 'LOS DOCTORES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7170, '175714              ', 'GARCIA NUEVO LEON', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7171, '175735              ', 'PROGRESO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7172, '175818              ', 'DEL PASEO RESIDENCIAL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7173, '175826              ', 'FRACCIONAMINENTO VALLE MORELOS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7174, '175855              ', 'FRACCIONAMIENTO INDUSTRIAL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7175, '175888              ', 'AGUA FRIA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7176, '175959              ', 'SATELITE ACUEDUCTO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7177, '175996              ', 'MITRAS CENTRO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7178, '176011              ', 'VALLE DEL MIRADOR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7179, '176044              ', 'INDEPENDENCIA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7180, '176074              ', 'ROMA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7181, '176090              ', 'PARQUE INDUSTRIAL MONTERREY', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7182, '176094              ', 'CEMENTOS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7183, '176119              ', 'PRADO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7184, '176162              ', 'PARQUE IND.FINSA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7185, '176170              ', 'MIRADOR CENTRO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7186, '176179              ', 'CERTOMA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7187, '176259              ', 'FRAC. INDUSTRIAL EL LECHUGAL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7188, '176271              ', 'LA LEONA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7189, '176284              ', 'DEL PASEO RESIDENCIAL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7190, '176470              ', 'LOMA LARGA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7191, '176515              ', 'BOSQUES DEL VALLE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7192, '176601              ', 'ANCIRA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7193, '176612              ', 'LA PURISIMA GUADALUPE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7194, '176620              ', 'FRACC. SAN PEDRO GARZA GARCIA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7195, '176629              ', 'OVISPADO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7196, '176719              ', 'PEDRO LOZANO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7197, '176746              ', 'AMPLIACION LOS DOCTORES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7198, '176748              ', 'NIÑO ARTILLERO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7199, '176850              ', 'HIDALGO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7200, '176859              ', 'CARACOL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7201, '176884              ', 'SIERRA VENTANA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7202, '176921              ', 'SERTOMA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7203, '176979              ', 'PARQUE INDUSTRIAL REGIOMONTANO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7204, '177057              ', 'ZAPATA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7205, '177066              ', 'CUMBRES 5to SECTOR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7206, '177120              ', 'VALLE MORELOS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7207, '177223              ', 'PLUTARCO ELIAS CALLES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7208, '177225              ', 'JARDIN ESPAÑOL', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7209, '177226              ', 'CUMBRES 3er SECTOR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7210, '177227              ', 'JARDIN OBISPADO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7211, '177279              ', 'SAN JOSE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7212, '177285              ', 'Morelos', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7213, '177359              ', 'VILLA MITRAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7214, '177479              ', 'TOPO CHICO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7215, '177480              ', 'EL ENCINO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7216, '177556              ', 'BARRIO ANTIGUO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7217, '177574              ', 'BARRIO ESTRELLA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7218, '177578              ', 'LA GRANJE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7219, '177600              ', 'RINCON DE LAS CUMBRES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7220, '177608              ', 'DEL PASEO RESIDENCIAL SEXTO SECTOR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7221, '177650              ', 'DEL PRADO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7222, '177653              ', 'REPUBLICA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7223, '177686              ', 'VALLE DE CHAPULTEPEC', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7224, '177697              ', 'LAS BRISAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7225, '177813              ', 'PARQUE INDUSTRIAL MULTIPARCK', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7226, '177824              ', 'PASEO DE CUMBRES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7227, '177839              ', 'MODELO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7228, '177857              ', 'MOCTEZUMA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7229, '177871              ', 'VENUSTIANO CARRANZA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7230, '177904              ', 'PABLO DE LA GARZA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7231, '177987              ', 'EXPOSICION GUADALUPE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7232, '177991              ', 'FRACC CUMBRES PROVIDENCIA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7233, '178127              ', 'JARDINES DEL CERRO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7234, '178159              ', 'SANTA FE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7235, '178183              ', 'MITRAS SUR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7236, '178353              ', 'LOMAS DE CHEPEVERA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7237, '178371              ', 'RESIDENCIAL CUMBRES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7238, '178420              ', 'CUMBRES 1er. SECTOR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7239, '178425              ', 'MAGNOLIAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7240, '178492              ', 'HOGARES FERROCARRILEROS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7241, '178532              ', 'BALCONES DEL CARMEN', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7242, '178560              ', 'ESTRELLA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7243, '178628              ', 'LOMAS DEL PASEO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7244, '178645              ', 'ALTAVISTA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7245, '178760              ', 'PUERTA DE HIERRO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7246, '178839              ', 'LAS PUENTES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7247, '178844              ', 'RESIDENCIAL LA HACIENDA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7248, '178855              ', 'ORIENTE CENTRO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7249, '178924              ', 'LOMAS DE CUMBRES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7250, '178963              ', 'RESIDENCIAL SAN AGUSTIN', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7251, '178969              ', 'LA CONDESA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7252, '179019              ', 'PIO XII', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7253, '179118              ', 'VALLE DE LAS BRISAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7254, '179529              ', 'CHEPE VERA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7255, '73723               ', 'TALLERES', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7256, '73724               ', 'PRIMERO DE MAYO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7257, '73726               ', 'LA PRIMAVERA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7258, '73739               ', 'CUMBRES 8vo SECTOR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7259, '73747               ', 'LOMAS DE SAN FRANCISCO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7260, '73748               ', 'SIERRAS VENTANAS', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7261, '73749               ', 'TREVILLO', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7262, '73750               ', 'EMILIANO ZAPATA', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7263, '73751               ', 'GUADALUPE', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7264, '73759               ', 'FRACC. INDUSTRIAL NOCALAR', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7265, '73762               ', 'VALLE OTE.', 'MTY                 ', 'MTY                 ', 'NL                  '),
(7266, '177317              ', 'ZACATEQUITAS', 'PES                 ', 'PES                 ', 'NL                  '),
(7267, '177203              ', 'S/C', 'SALI                ', 'SALI                ', 'NL                  '),
(7268, '175495              ', '.', 'SANTIAGONUEVOL      ', 'SANTIAGONL          ', 'NL                  '),
(7269, '176476              ', 'JARDINES DE SANTIAGO', 'SANTIAGONUEVOL      ', 'SANTIAGONL          ', 'NL                  '),
(7270, '179076              ', 'EL BARRIAL', 'SANTIAGONUEVOL      ', 'SANTIAGONL          ', 'NL                  '),
(7271, '179077              ', 'EL MIRADOR', 'SANTIAGONUEVOL      ', 'SANTIAGONL          ', 'NL                  '),
(7272, '174406              ', 'INDUSTRIAL NOGALAR', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7273, '174581              ', 'CENTRO', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7274, '174645              ', 'GARZA CANTU', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7275, '174670              ', 'FRANCISCO G. SADA', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7276, '174736              ', 'RESIDENCIAL ROBLE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7277, '174740              ', 'CASA BELLA', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7278, '174819              ', 'BOSQUES DEL NOGALAR', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7279, '174859              ', 'VALLE DEL NOGALAR', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7280, '175096              ', 'RESIDENCIAL ANAHUAC', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7281, '175214              ', 'LA FE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7282, '175443              ', '.', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7283, '175570              ', 'FUTURO NOGALAR', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7284, '175630              ', 'ESTACION LAGRANGE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7285, '175892              ', 'GUSTAVO DIAZ ORDAZ', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7286, '176024              ', 'VILLA DEL ROBLE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7287, '176031              ', 'ARBOLEDAS DE SAN JORGE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7288, '176036              ', 'RESIDENCIAL PERIFERICO', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7289, '176346              ', 'FRACCIONAMIENTO EL NOGALAR', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7290, '176359              ', 'FRACCIONAMIENTO INDUSTRIAL NOGALAR', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7291, '176460              ', 'LAGRANGE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7292, '176537              ', 'CUAUHTEMOC', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7293, '176549              ', 'RESIDENCIAL CASA BELLA', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7294, '176677              ', 'CENTRAL DE CARGA', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7295, '176846              ', 'JARDINES DE ANAHUAC', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7296, '176909              ', 'PEÑA GUERRA', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7297, '177015              ', 'LA GRANGE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7298, '177198              ', 'INDUSTRIAS DEL VIDRIO SEGUNDO SECTOR', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7299, '177224              ', 'ITURBIDE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7300, '177276              ', 'CIUDAD UNIVERSITARIA', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7301, '177325              ', 'PARQUES DE LA TALAVERNA', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7302, '177469              ', 'BOSQUES DE SANTO DOMINGO', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7303, '177624              ', 'FRACC. CENTRAL DE CARGA', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7304, '177715              ', 'EL ROBLE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7305, '178193              ', 'LOMAS DEL ROBLE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7306, '178398              ', 'HACIENDA LOS MORALES', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7307, '178556              ', 'PARQUE INDUSTRIAL STIVA BARRAGAN', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7308, '178625              ', 'FRACCIONAMIENTO ITURBIDE', 'SNGARZ              ', 'SNGARZ              ', 'NL                  '),
(7309, '177491              ', 'CUAUHTEMOC', 'SNICOLAS            ', 'SNICOLAS            ', 'NL                  '),
(7310, '73731               ', 'CENTRO', 'SNICOLAS            ', 'SNICOLAS            ', 'NL                  '),
(7311, '73732               ', 'LA FE', 'SNICOLAS            ', 'SNICOLAS            ', 'NL                  '),
(7312, '174055              ', 'UNIDAD SAN PEDRO', 'GG                  ', 'SPGG                ', 'NL                  '),
(7313, '174473              ', 'DEL VALLE', 'GG                  ', 'SPGG                ', 'NL                  '),
(7314, '175261              ', 'PLAZA LEONA', 'GG                  ', 'SPGG                ', 'NL                  '),
(7315, '175440              ', '.', 'GG                  ', 'SPGG                ', 'NL                  '),
(7316, '175696              ', 'VALLE DEL CAMPESTRE', 'GG                  ', 'SPGG                ', 'NL                  '),
(7317, '176349              ', 'CENTRO', 'GG                  ', 'SPGG                ', 'NL                  '),
(7318, '176431              ', 'FUENTES DEL VALLE', 'GG                  ', 'SPGG                ', 'NL                  '),
(7319, '176553              ', 'RESIDENCIAL SAN AGUSTIN', 'GG                  ', 'SPGG                ', 'NL                  '),
(7320, '176639              ', 'COLORINES', 'GG                  ', 'SPGG                ', 'NL                  '),
(7321, '177684              ', 'CARRIZALEJO', 'GG                  ', 'SPGG                ', 'NL                  '),
(7322, '174456              ', 'LA LEONA', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7323, '174540              ', 'RESIDENCIAL SAN AGUSTIN', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7324, '174636              ', 'AMPLIACION VALLE DEL MIRADOR', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7325, '174773              ', 'LOMAS DEL VALLE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7326, '174949              ', 'VALLE ORIENTE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7327, '175132              ', 'CENTRO', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7328, '175213              ', 'FRACC. SANTA ENGRACIA ', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7329, '175439              ', '.', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7330, '175621              ', 'RESIDENCIAL SANTA BARBARA', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7331, '175687              ', 'UNIDAD SAN PEDRO', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7332, '175920              ', 'VILLAS DE ARAGON', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7333, '175975              ', 'DEL VALLE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7334, '176087              ', 'PONIENTE CENTRO', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7335, '176102              ', 'REAL SAN AGUSTIN', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7336, '176261              ', 'PALO BLANCO', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7337, '176358              ', 'VALLE DEL CAMPESTRE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7338, '176596              ', 'JERONIMO SILLER', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7339, '176830              ', 'FUENTES DEL VALLE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7340, '177001              ', 'FRACC. ALPINO CHIPINQUE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7341, '177027              ', 'VALLE DE SAN AGUSTIN', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7342, '177286              ', 'MORELOS', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7343, '177312              ', 'C.H.MORELOS', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7344, '177416              ', 'SIERRA MADRE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7345, '177636              ', 'BOSQUES DEL VALLE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7346, '177858              ', 'PLAZA LA LEONA', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7347, '178072              ', 'SAN AGUSTIN', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7348, '178237              ', 'TAMPIQUITO', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7349, '178367              ', 'SANTAENGRACIA', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7350, '178682              ', 'SAN PEDRO 400', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7351, '178777              ', 'CARRIZALEJO', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7352, '178968              ', 'SANTA ENGRACIA', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7353, '73763               ', 'VALLE OTE.', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7354, '73769               ', 'VALLE DEL CAMPESTRE', 'SPGG                ', 'SPGG                ', 'NL                  '),
(7355, '175174              ', 'CD. INDUSTRIAL MITRAS', 'VILGA               ', 'VILGA               ', 'NL                  '),
(7356, '175446              ', '.', 'BAHSDHTLCO          ', 'BAHSDHTLCO          ', 'OAX                 '),
(7357, '174219              ', 'EX-MARQUEZADO', 'OAX                 ', 'OAX                 ', 'OAX                 '),
(7358, '174477              ', 'CENTRO', 'OAX                 ', 'OAX                 ', 'OAX                 '),
(7359, '175445              ', 'SAN FELIPE DEL AGUA', 'OAX                 ', 'OAX                 ', 'OAX                 '),
(7360, '178424              ', 'JALATLACO', 'OAX                 ', 'OAX                 ', 'OAX                 '),
(7361, '178849              ', 'SAN FELIPE DEL AGUA 1', 'OAX                 ', 'OAX                 ', 'OAX                 '),
(7362, '176750              ', 'REFORMA', 'OAXJUA              ', 'OAXJUA              ', 'OAX                 '),
(7363, '176879              ', 'CENTRO', 'OAXJUA              ', 'OAXJUA              ', 'OAX                 '),
(7364, '177770              ', 'SAN FELIPE DEL AGUA', 'OAXJUA              ', 'OAXJUA              ', 'OAX                 '),
(7365, '177819              ', 'SANTA MARIA', 'PTOESCDO            ', 'PTOESCDO            ', 'OAX                 '),
(7366, '176127              ', 'DEL BOSQUE', 'SANLUCA             ', 'SANLUCA             ', 'OAX                 '),
(7367, '176362              ', '.', 'SATLA               ', 'SATU                ', 'OAX                 '),
(7368, '178370              ', 'LA PIRAGUA', 'TUXTPEC             ', 'TUXTPEC             ', 'OAX                 '),
(7369, '178676              ', 'CHACHAPA', 'ANZ                 ', 'ANZ                 ', 'PUEBLA              '),
(7370, '174824              ', 'FRANCISCO I MADERO', 'ATX                 ', 'ATX                 ', 'PUEBLA              '),
(7371, '175447              ', '.', 'ATX                 ', 'ATX                 ', 'PUEBLA              '),
(7372, '175085              ', 'SAN PEDRO', 'CHOLU               ', 'CHOLU               ', 'PUEBLA              '),
(7373, '175450              ', '.', 'CHOLU               ', 'CHOLU               ', 'PUEBLA              '),
(7374, '176974              ', 'PASEO DE SAN ANDRES', 'CHOLU               ', 'CHOLU               ', 'PUEBLA              '),
(7375, '176975              ', 'CENTRO', 'CHOLU               ', 'CHOLU               ', 'PUEBLA              '),
(7376, '177384              ', 'RESERVA TERRITORIAL ATLIXCAYOTL', 'CHOLU               ', 'CHOLU               ', 'PUEBLA              '),
(7377, '174762              ', 'EMILIANO ZAPATA', 'CHOL                ', 'CHOLULA             ', 'PUEBLA              '),
(7378, '176436              ', 'EX HACIENDA SANTA TERESA', 'CHOL                ', 'CHOLULA             ', 'PUEBLA              '),
(7379, '178254              ', 'SAN FCO. OCOTLAN', 'CORONANG            ', 'CORONANGO           ', 'PUEBLA              '),
(7380, '178281              ', 'SAN LORENZO ALMECATLA', 'CUAU                ', 'CUAU                ', 'PUEBLA              '),
(7381, '175227              ', '..', 'CUAUT               ', 'CUAUT               ', 'PUEBLA              '),
(7382, '176644              ', 'SAN LORENZO ALMECATLA', 'CUAUT               ', 'CUAUT               ', 'PUEBLA              '),
(7383, '177156              ', 'PARQUE INDUSTRIAL SAN MIGUEL', 'HUEJO               ', 'HUEJO               ', 'PUEBLA              '),
(7384, '177158              ', 'CUARTO BARRIO', 'HUEJO               ', 'HUEJO               ', 'PUEBLA              '),
(7385, '174218              ', 'GONZALEZ ORTEGA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7386, '174285              ', 'BELLA VISTA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7387, '174395              ', 'RIBERA DEL ATOYAC', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7388, '174411              ', 'CENTRO', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7389, '174415              ', 'EL MIRADOR', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              ');
INSERT INTO `colonias` (`id_colonia`, `Clave`, `Descripcion`, `Ciudad`, `Municipio`, `Estado`) VALUES
(7390, '174559              ', 'LA NORIA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7391, '174590              ', 'SAN RAFAEL PONIENTE', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7392, '174751              ', '.', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7393, '174761              ', 'EMILIANO ZAPATA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7394, '174892              ', 'CORREDOR INDUSTRIAL QUETZACOATL HUEJOTZINGO', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7395, '174947              ', 'REFORMA SUR', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7396, '174952              ', 'PARQUE INDUSTRIAL RESURRECCION', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7397, '175018              ', 'ANZURES', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7398, '175078              ', 'PUEBLA TEXTIL', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7399, '175164              ', 'NUEVA AURORA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7400, '175194              ', 'XONACA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7401, '175247              ', 'BELISARIO DOMINGUEZ', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7402, '175578              ', 'PARQUE INDUSTRIAL 5 DE MAYO', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7403, '175582              ', 'LA LOMA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7404, '176103              ', 'SAN MIGUEL MAYORAZGO', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7405, '176115              ', 'LOS VIVEROS', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7406, '176156              ', 'VOLCANES', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7407, '176245              ', 'PARQUE INDL.FINSA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7408, '176598              ', 'SANTA ANITA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7409, '176606              ', 'CHULAVISTA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7410, '176697              ', 'ANALCO', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7411, '176860              ', 'ESTRELLA DEL SUR', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7412, '176960              ', 'SAN FRANCISCO MAYORAZGO', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7413, '176961              ', 'SAN JOSE MAYORAZGO', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7414, '176998              ', 'SAN FELIPE HUEYOTLIPAN', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7415, '177145              ', 'LAS ANIMAS', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7416, '177174              ', 'BENITO JUAREZ', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7417, '177345              ', 'TRES CRUCES', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7418, '177363              ', 'SANTA MARIA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7419, '177383              ', 'LOMAS DE CASTILLOTLA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7420, '177418              ', 'ZONA INDUSTRIAL NORTE', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7421, '177541              ', 'SANTA CRUZ BUENAVISTA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7422, '177625              ', 'SANTA CRUZ LOS ANGELES', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7423, '177648              ', 'MEXICO 86', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7424, '177914              ', 'LAGULENA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7425, '178134              ', 'OBRERO Y CAMPESINO', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7426, '178253              ', 'SAN FCO. OCOTLAN', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7427, '178286              ', 'VILLA LAS FLORES', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7428, '178535              ', 'REFORMA AGUA AZUL', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7429, '178615              ', 'VILLA ENCANTADA', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7430, '70716               ', 'PRADOS AGUA AZUL', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7431, '72729               ', 'BUGAMBILIAS', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7432, '73153               ', 'GABRIEL PASTOR', 'PUEBLA              ', 'PUEBLA              ', 'PUEBLA              '),
(7433, '178872              ', 'CENTRO', 'TECALI              ', 'PUEBLA              ', 'PUEBLA              '),
(7434, '175449              ', '.', 'SNMTNTEX            ', 'SNMTNTEX            ', 'PUEBLA              '),
(7435, '175803              ', 'CENTRO', 'SNMTNTEX            ', 'SNMTNTEX            ', 'PUEBLA              '),
(7436, '175448              ', '.', 'TEHUACN             ', 'TEHUACN             ', 'PUEBLA              '),
(7437, '176554              ', 'SAN LORENZO TEOTIPILCO', 'TEHUACN             ', 'TEHUACN             ', 'PUEBLA              '),
(7438, '176557              ', 'JACARANDAS', 'TEHUACN             ', 'TEHUACN             ', 'PUEBLA              '),
(7439, '174361              ', 'SAN FRANCISCO', 'TEOTIHUA            ', 'TEOTIHUA            ', 'PUEBLA              '),
(7440, '177998              ', 'TLAXCALANTONGO', 'XIC                 ', 'XIC                 ', 'PUEBLA              '),
(7441, '174644              ', 'FRACC. INDUSTRIAL LA BALVANERA', 'CORR                ', 'CORR                ', 'QRO                 '),
(7442, '175451              ', '.', 'CORR                ', 'CORR                ', 'QRO                 '),
(7443, '177604              ', 'JARDINES DEL BOSQUE 2DA. SECCION', 'CORR                ', 'CORR                ', 'QRO                 '),
(7444, '177822              ', 'EL PUEBLITO', 'CORR                ', 'CORR                ', 'QRO                 '),
(7445, '177668              ', 'PARQUE INDUSTRIAL EL MARQUES', 'ELMARQUES           ', 'ELMARQUES           ', 'QRO                 '),
(7446, '178495              ', 'FRACC. INDUSTRIAL BERNARDO QUINTANA', 'ELMARQUES           ', 'ELMARQUES           ', 'QRO                 '),
(7447, '179016              ', '.', 'ELMARQUES           ', 'ELMARQUES           ', 'QRO                 '),
(7448, '178079              ', 'MONTEBLANCO', 'HUI                 ', 'HUI                 ', 'QRO                 '),
(7449, '175954              ', '..', 'PEDES               ', 'PEDES               ', 'QRO                 '),
(7450, '177931              ', 'EL AHORCADO', 'PEDES               ', 'PEDES               ', 'QRO                 '),
(7451, '177932              ', 'ARBOLEDAS', 'PEDES               ', 'PEDES               ', 'QRO                 '),
(7452, '174987              ', 'CENTRO', 'LCORR               ', 'QRO                 ', 'QRO                 '),
(7453, '174988              ', '.', 'LCORR               ', 'QRO                 ', 'QRO                 '),
(7454, '173931              ', 'SAN PEDRITON PEÑUELAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7455, '174210              ', 'PARQUE INDUSTRIAL FINSA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7456, '174293              ', 'CARRETAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7457, '174315              ', 'PLAZA DE LAS AMERICAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7458, '174360              ', 'BALAUSTRADAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7459, '174404              ', 'CAMPESTRE JURICA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7460, '174417              ', 'CENTRO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7461, '174429              ', 'SAN ANGEL', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7462, '174541              ', 'PEÑUELAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7463, '174556              ', 'EL MARQUES', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7464, '174626              ', 'PLAZAS DEL SOL', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7465, '174640              ', 'PRADOS DEL MIRADOR', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7466, '174643              ', 'FRACC.INDUSTRIAL BALVANERA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7467, '174693              ', 'JURICA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7468, '174700              ', 'CARRILLO PUERTO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7469, '174755              ', 'ZONA INDUSTRIAL', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7470, '174818              ', 'LOS MOLINOS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7471, '174841              ', 'SAN PEDRITO PEÑUELAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7472, '175129              ', '.', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7473, '175173              ', 'LOMAS DE CASABLANCA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7474, '175204              ', 'FRACC. INDUSTRIAL BENITO JUAREZ', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7475, '175283              ', 'LAS TERESAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7476, '175347              ', 'DEL PRADO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7477, '175365              ', 'PARQUE INDUSTRIAL QUERETARO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7478, '175549              ', 'SAN PABLO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7479, '175575              ', 'ALAMOS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7480, '175632              ', 'PARQUE INDUSTRIAL BERNARDO QUINTANA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7481, '175778              ', 'PARQ. INDUSTRIAL BENITO JUAREZ', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7482, '175893              ', 'JARDINES DE QUERETARO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7483, '175937              ', 'CANDILES', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7484, '175955              ', 'VILLAS DEL SOL', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7485, '176018              ', 'EL JACAL', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7486, '176219              ', 'SAN JUAN DEL RIO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7487, '176226              ', 'ARQUITOS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7488, '176253              ', 'LOS NARANJOS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7489, '176345              ', 'CIMATARIO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7490, '176425              ', 'VILLAS DE GUADALUPE', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7491, '176579              ', 'LOMA DEL MARQUES', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7492, '176690              ', 'ARBOLEDAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7493, '176694              ', 'LAS ROSAS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7494, '176810              ', 'EL SALITRE', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7495, '176870              ', 'ZONA INDUSTRIAL BENITO JUAREZ', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7496, '176933              ', 'SATELITE', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7497, '177020              ', 'PRADOS TEPEYAC', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7498, '177021              ', 'SANTA MONICA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7499, '177032              ', 'CERRITO COLORADO II', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7500, '177082              ', 'FRACC JURICA CAMPESTRE', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7501, '177296              ', 'ENSUEÑO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7502, '177381              ', 'CALESA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7503, '177496              ', 'VISTA ALEGRE', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7504, '177546              ', 'MANSIONES DEL VALLE', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7505, '177642              ', 'ZONA INDUSTRIAL BENITO JUAREZ', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7506, '178067              ', 'CEDROS', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7507, '178085              ', 'FRACC. IND. QUERETARO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7508, '178304              ', 'DESARROLLO MONTAÑA 2000', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7509, '178365              ', 'LOMA DORADA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7510, '178396              ', 'QUINTAS DEL MARQUEZ', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7511, '178468              ', 'DESARROLLO SAN PABLO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7512, '178635              ', 'FELIPE CARRILLO PUERTO', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7513, '178655              ', 'SAN JAVIER', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7514, '179075              ', 'COLON', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7515, '179154              ', 'CENTRO SUR', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7516, '73753               ', 'PARQUE IND. JURICA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7517, '73754               ', 'JURIQUILLA', 'QRO                 ', 'QRO                 ', 'QRO                 '),
(7518, '174756              ', 'ZONA INDUSTRIAL', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7519, '175130              ', 'LOMA BONITA', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7520, '175452              ', '.', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7521, '175502              ', 'FRACCIONAMIENTO JUAREZ', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7522, '175670              ', 'FRACCIONAMIENTO LOS NARANJOS', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7523, '175768              ', 'LOMAS DE SAN JUAN', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7524, '176254              ', 'LOS NARANJOS', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7525, '176420              ', 'CENTRO', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7526, '177557              ', 'ZONA INDUSTRIAL VALLE DE ORO', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7527, '178271              ', 'SAN PEDRO', 'SANJUAN             ', 'SJRIO               ', 'QRO                 '),
(7528, '174882              ', 'CENTRO', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7529, '174896              ', 'PARQUE INDUSTRIAL BERNARDO QUINTANA', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7530, '175318              ', 'PARQUE INDUSTRIAL JURICA', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7531, '175779              ', 'PARQUE INDUSTRIAL BENITO JUÁREZ', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7532, '176632              ', 'SAN FRANCISQUITO', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7533, '176781              ', 'BALAUSTRADAS', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7534, '177302              ', 'SAN ANGEL', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7535, '177332              ', 'ARBOLEDAS', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7536, '177643              ', 'ZONA INDUSTRIAL BENITO JUAREZ', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7537, '177989              ', 'JURIQUILLA', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7538, '178394              ', 'MILENIO III', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7539, '178486              ', 'CARRIZAL', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7540, '178778              ', 'VILLAS DE GUADALUPE', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7541, '179401              ', '.', 'STOQUE              ', 'STOQUE              ', 'QRO                 '),
(7542, '177970              ', 'S/C', 'CDBTOJUA            ', 'BTOJUA              ', 'QUINTANA ROO        '),
(7543, '177971              ', 'FRACC. HACIENDA REAL DEL CARIBE', 'CDBTOJUA            ', 'BTOJUA              ', 'QUINTANA ROO        '),
(7544, '178301              ', 'REGION 102', 'CDBTOJUA            ', 'BTOJUA              ', 'QUINTANA ROO        '),
(7545, '174374              ', 'DELEGACION BENITO JUAREZ', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7546, '174684              ', '.', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7547, '174861              ', 'CENTRO', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7548, '175008              ', 'SUPER MANZANA 20', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7549, '175050              ', 'ZONA HOTELERA', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7550, '175059              ', 'TIKAL S. M. 41', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7551, '175746              ', 'ZONA HOTELERA CANCUN BENITO JUAREZ', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7552, '176042              ', 'SOLIDARIDAD', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7553, '176783              ', 'SUPER MANZANA 28', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7554, '176853              ', 'AEROPUERTO INTERNACIONAL DE CANCUN', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7555, '177128              ', 'RANCHO NAZARETH', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7556, '177183              ', 'SUPER MANZANA 114', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7557, '177291              ', 'CONJUNTO VIRREYES ', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7558, '177337              ', 'SUPER MANZANA 24', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7559, '177342              ', 'BENITO JUAREZ', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7560, '177586              ', 'PUERTO AVENTURA SOLIDARIDAD', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7561, '177724              ', 'ZONA HOTELERA 2DA. SECCION', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7562, '178636              ', 'SMZA15', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7563, '178687              ', 'SMZ4, MZ4, LT13', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7564, '179181              ', 'SUPER MANZANA 29', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7565, '71149               ', 'PUERTO JUAREZ', 'CANCUN              ', 'CANCUN              ', 'QUINTANA ROO        '),
(7566, 'TULU                ', 'TULUM', 'TULUM               ', 'CANCUN              ', 'QUINTANA ROO        '),
(7567, '175455              ', '.', 'CHETMAL             ', 'CHETMAL             ', 'QUINTANA ROO        '),
(7568, '175456              ', 'CENTRO', 'CHETMAL             ', 'CHETMAL             ', 'QUINTANA ROO        '),
(7569, '175457              ', 'VEINTE DE NOVIEMBRE', 'CHETMAL             ', 'CHETMAL             ', 'QUINTANA ROO        '),
(7570, '174779              ', 'CENTRO', 'COZUMEL             ', 'COZ                 ', 'QUINTANA ROO        '),
(7571, '175453              ', '.', 'COZUMEL             ', 'COZ                 ', 'QUINTANA ROO        '),
(7572, '174566              ', 'REGION 3', 'PLACA               ', 'SOLI                ', 'QUINTANA ROO        '),
(7573, '174964              ', 'RESIDENCIAL CAMPESTRE', 'PLACA               ', 'SOLI                ', 'QUINTANA ROO        '),
(7574, '175454              ', '.', 'PLACA               ', 'SOLI                ', 'QUINTANA ROO        '),
(7575, '176043              ', 'CENTRO', 'PLACA               ', 'SOLI                ', 'QUINTANA ROO        '),
(7576, '176618              ', 'CENTRO COMERCIAL PASEO DEL CARMEN', 'PLACA               ', 'SOLI                ', 'QUINTANA ROO        '),
(7577, '177058              ', 'PLAYA PARAISO', 'PLACA               ', 'SOLI                ', 'QUINTANA ROO        '),
(7578, '179103              ', 'FRACC. PLAYACAR FASE II', 'PLACA               ', 'SOLI                ', 'QUINTANA ROO        '),
(7579, '179105              ', 'LUIS DONALDO COLOSIO', 'PLACA               ', 'SOLI                ', 'QUINTANA ROO        '),
(7580, '176864              ', '.', 'SOLI                ', 'SOLI                ', 'QUINTANA ROO        '),
(7581, '178006              ', 'PLAYA DEL CARMEN', 'SOLI                ', 'SOLI                ', 'QUINTANA ROO        '),
(7582, '176297              ', '.', 'COSTARICA           ', 'COSTARICA           ', 'SIN                 '),
(7583, '176298              ', 'CENTRO', 'COSTARICA           ', 'COSTARICA           ', 'SIN                 '),
(7584, '174027              ', 'EMILIANO ZAPATA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7585, '174236              ', 'ALMADA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7586, '174294              ', 'CENTRO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7587, '174408              ', 'MARGARITA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7588, '174535              ', 'LAS VEGAS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7589, '174579              ', '.', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7590, '174794              ', 'MIGUEL DE LA MADRID', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7591, '175122              ', 'FRACC. LOMAS DE SAN ISIDRO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7592, '175124              ', 'CENTRO SINALOA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7593, '175308              ', 'LIMON DE LOS RAMOS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7594, '175749              ', 'LAS FLORES', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7595, '175857              ', 'RECURSOS HIDRAÚLICOS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7596, '175931              ', 'JORGE ALMADA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7597, '176009              ', 'AEROPUERTO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7598, '176061              ', 'LAS QUINTAS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7599, '176417              ', 'PENINSULA DE VILLAMOROS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7600, '176474              ', 'RINCON DEL VALLE', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7601, '176510              ', 'UNIVERSITARIA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7602, '176761              ', 'FRACC. HORIZONTES', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7603, '176762              ', 'FRACC. RESIDENCIAL BONANZA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7604, '176904              ', 'PARQUE INDUSTRIAL CANACINTRA 1', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7605, '176980              ', 'DESARROLLO URBANO LA PRIMAVERA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7606, '177052              ', 'FRACC. VILLAS DEL RIO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7607, '177097              ', 'EL VALLADO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7608, '177177              ', 'JOSE MARIA MORELOS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7609, '177187              ', 'FRACC. LOMAS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7610, '177467              ', 'MERCADO DE ABASTOS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7611, '177627              ', 'MIGUEL HIDALGO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7612, '177889              ', 'FRACC RESIDENCIAL MONTECARLO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7613, '177966              ', 'FRACCIONAMIENTO ARBOLEDAS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7614, '178003              ', 'SAN RAFAEL', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7615, '178018              ', 'VALLE BONITO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7616, '178153              ', 'ARBOLEDAS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7617, '178514              ', 'IGNACIO ALLENDE', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7618, '178649              ', 'ROSALES', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7619, '178838              ', 'LAS PINTAS', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7620, '179068              ', 'INFONAVIT HUMAYA', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7621, '71441               ', 'BACHIGUALATO', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7622, '73655               ', 'GUADALUPE', 'CULIACAN            ', 'CULIACAN            ', 'SIN                 '),
(7623, '179132              ', 'JORGE ALMADA', 'CULROSAL            ', 'CULROSAL            ', 'SIN                 '),
(7624, '177406              ', 'CENTRO', 'ESCUINPA            ', 'ESCUINPA            ', 'SIN                 '),
(7625, '177575              ', 'S/C', 'ESCUINPA            ', 'ESCUINPA            ', 'SIN                 '),
(7626, '178302              ', 'NIÑOS HEROES', 'GUAMCHIL            ', 'GUAMCHIL            ', 'SIN                 '),
(7627, '178306              ', 'ZONA INDUSTRIAL', 'GUAMCHIL            ', 'GUAMCHIL            ', 'SIN                 '),
(7628, '177137              ', 'CENTRO', 'GUASVE              ', 'GUASVE              ', 'SIN                 '),
(7629, '174386              ', 'FRACCIONAMIENTO DEL REAL', 'AHOME               ', 'LM                  ', 'SIN                 '),
(7630, '174517              ', '.', 'AHOME               ', 'LM                  ', 'SIN                 '),
(7631, '174009              ', '.', 'LOSMOCHIS           ', 'LM                  ', 'SIN                 '),
(7632, '174677              ', 'CENTRO', 'LOSMOCHIS           ', 'LM                  ', 'SIN                 '),
(7633, '177111              ', 'FRACC.JARDINES DEL BOSQUE', 'LOSMOCHIS           ', 'LM                  ', 'SIN                 '),
(7634, '178408              ', 'FRACC. JARDINES DEL VALLE', 'LOSMOCHIS           ', 'LM                  ', 'SIN                 '),
(7635, '178905              ', 'TABACHINES I', 'LOSMOCHIS           ', 'LM                  ', 'SIN                 '),
(7636, '179193              ', 'JARDIN', 'LOSMOCHIS           ', 'LM                  ', 'SIN                 '),
(7637, '173775              ', 'FRACC. LOMAS DE MAZATLAN', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7638, '174276              ', 'INSURGENTES', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7639, '174307              ', 'SABALO COUNTRY CLUB', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7640, '174529              ', 'S/C', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7641, '174530              ', 'EL VENADILLO', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7642, '174851              ', 'INDECO', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7643, '175254              ', 'VILLAS PUERTO IGUANA', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7644, '175312              ', 'SANCHEZ CELIS', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7645, '175321              ', 'CENTRO', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7646, '175332              ', 'FRACC. EL TOREO', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7647, '175835              ', 'ZONA DORADA', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7648, '175891              ', 'LOMAS DE MAZATLAN', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7649, '175998              ', 'FRANCISCO VILLA', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7650, '176542              ', 'PARQUE INDUSTRIAL ALFREDO V. BONFIL', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7651, '176605              ', 'PALOS PRIETOS', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7652, '176630              ', 'REFORMA', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7653, '176641              ', 'RESIDENCIAL', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7654, '176831              ', 'MARINA MAZATLAN', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7655, '176895              ', 'VILLA GALAXIA', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7656, '177062              ', 'FLAMINGOS', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7657, '177129              ', 'FRACC. PLAYA SUR', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7658, '177505              ', 'ALTOS CENTRO', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7659, '177898              ', 'CORREDOR DE ABASTOS', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7660, '177980              ', 'INFONAVIT PLAYAS', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7661, '178058              ', 'VILLAS DEL MAR', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7662, '178087              ', 'MARINA MAZATLAN ENTRONQUE SABALO CERRITOS', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7663, '178126              ', 'KLEIN', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7664, '178566              ', 'EL QUELITE', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7665, '178589              ', 'FRACC. SABALO', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7666, '178789              ', 'ZONA COSTERA', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7667, '179527              ', 'NIÑOS HEROES', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7668, '179528              ', 'ESPERANZA', 'MAZATLAN            ', 'MAZATLAN            ', 'SIN                 '),
(7669, '176764              ', 'CENTRO', 'NAVOLATO            ', 'NAVOLATO            ', 'SIN                 '),
(7670, '176765              ', '.', 'NAVOLATO            ', 'NAVOLATO            ', 'SIN                 '),
(7671, '176416              ', '.', 'PVM                 ', 'PVM                 ', 'SIN                 '),
(7672, '176192              ', 'GREGORIO OSUNA', 'CDVALLES            ', 'CDVALLES            ', 'SLP                 '),
(7673, 'SMCARM              ', 'SAN MARCOS DE CARMONA', 'MZC                 ', 'MEZCAR              ', 'SLP                 '),
(7674, '177041              ', 'CENTRO', 'RIOVDE              ', 'RIOVDE              ', 'SLP                 '),
(7675, '177042              ', '.', 'RIOVDE              ', 'RIOVDE              ', 'SLP                 '),
(7676, '174509              ', '.', 'CARD                ', 'SLP                 ', 'SLP                 '),
(7677, '178970              ', 'LA COLORADA', 'MEXQ                ', 'SLP                 ', 'SLP                 '),
(7678, '173895              ', 'JARDINES DEL SUR', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7679, '174306              ', 'INDUSTRIAL DE AVIACIÓN', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7680, '174384              ', 'VIVEROS', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7681, '174471              ', 'CENTRO', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7682, '174650              ', 'LOMAS 4ta. SECCION', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7683, '174651              ', '..', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7684, '174821              ', 'GRACIANO SANCHEZ', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7685, '174845              ', 'ZONA INDUSTRIAL', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7686, '174870              ', 'LOMA 2A. SECCION', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7687, '174945              ', 'SANTUARIO', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7688, '175134              ', 'TEQUIZQUIAPAN', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7689, '175299              ', 'LOMA ALTA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7690, '175331              ', 'LA ROSCA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7691, '175537              ', 'GENERAL I. MARTINEZ', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7692, '175548              ', 'MORALES INFONAVIT', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7693, '175804              ', 'TEQUISQUIAPAN', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7694, '175833              ', 'FRACCIONAMIENTO AGUAJE', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7695, '176019              ', 'SAN FELIPE', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7696, '176180              ', 'FRACC.LOMAS DEL TEC', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7697, '176186              ', 'FRAC.NVO.TANGAMANGA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7698, '176240              ', 'FRACC. CAMPESTRE', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7699, '176459              ', 'RICARDO B ANAYA SEGUNDA SECCION', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7700, '176516              ', 'FRACC. LAS MERCEDES', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7701, '176663              ', 'ZONA INDUSTRIAL 1a. SECCION', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7702, '176791              ', 'FRACC VALLE DORADO', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7703, '176872              ', 'POPULAR', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7704, '177003              ', 'TANGAMANGA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7705, '177040              ', 'DEL REAL', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7706, '177065              ', 'JARDIN', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7707, '177167              ', 'FORESTA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7708, '177468              ', 'CENTRAL DE MAQUINARIA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7709, '177666              ', 'LOMAS DEL TEC', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7710, '177897              ', 'FRACC VILLA ANTIGUA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7711, '177905              ', 'MODERNA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7712, '178103              ', 'FRACCIONAMIENTO VILLA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7713, '178161              ', 'ALAMITOS', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7714, '178175              ', 'FRACCIONAMIENTO CAPRICORNIO', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7715, '178386              ', 'BUROCRATA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7716, '178623              ', 'LOS REYES', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7717, '178764              ', 'BARRIO DE SANTIAGO DEL RIO', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7718, '178788              ', 'BUROCRATAS DEL ESTADO', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7719, '178900              ', 'JACARANDAS', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7720, '178966              ', 'FRACC. DEL REAL', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7721, '179179              ', 'LOMAS DE CENTINELA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7722, '179180              ', 'LOMAS DEL CENTINELA', 'SLP                 ', 'SLP                 ', 'SLP                 '),
(7723, '175567              ', 'SAN FELIPE', 'SOLGR               ', 'SOLGR               ', 'SLP                 '),
(7724, '175780              ', 'FIDEL VELAZQUEZ', 'SOLGR               ', 'SOLGR               ', 'SLP                 '),
(7725, '176741              ', 'ZONA INDUSTRIAL', 'SOLGR               ', 'SOLGR               ', 'SLP                 '),
(7726, '178861              ', 'CENTRO', 'SOLGR               ', 'SOLGR               ', 'SLP                 '),
(7727, '178863              ', 'SAN LORENZO', 'SOLGR               ', 'SOLGR               ', 'SLP                 '),
(7728, 'STALU               ', 'SANTA LUCIA', 'SOLGS               ', 'SOLGR               ', 'SLP                 '),
(7729, '176917              ', 'DEPORTIVA', 'AGPTA               ', 'AGPTA               ', 'SON                 '),
(7730, '179072              ', 'CENTRO', 'AGPTA               ', 'AGPTA               ', 'SON                 '),
(7731, '174413              ', 'LIBERTAD', 'CDOBRE              ', 'CDOBRE              ', 'SON                 '),
(7732, '175250              ', 'RESIDENCIAL CASA BLANCA ', 'CDOBRE              ', 'CDOBRE              ', 'SON                 '),
(7733, '175459              ', '.', 'CDOBRE              ', 'CDOBRE              ', 'SON                 '),
(7734, '175828              ', 'CENTRO', 'CDOBRE              ', 'CDOBRE              ', 'SON                 '),
(7735, '176423              ', 'SOCHILOA', 'CDOBRE              ', 'CDOBRE              ', 'SON                 '),
(7736, '176973              ', 'PARQUE INDUSTRIAL', 'CDOBRE              ', 'CDOBRE              ', 'SON                 '),
(7737, '177619              ', 'AEROPUERTO', 'CDOBRE              ', 'CDOBRE              ', 'SON                 '),
(7738, '178685              ', 'S/C', 'EMPALM              ', 'EMPALM              ', 'SON                 '),
(7739, '176614              ', 'CENTRO', 'GUAYMS              ', 'GUAYMS              ', 'SON                 '),
(7740, '176615              ', '.', 'GUAYMS              ', 'GUAYMS              ', 'SON                 '),
(7741, '176616              ', 'SOCHILOA', 'GUAYMS              ', 'GUAYMS              ', 'SON                 '),
(7742, '178552              ', 'TERMOELECTRICA', 'GUAYMS              ', 'GUAYMS              ', 'SON                 '),
(7743, '178553              ', 'AMPLIACION GUADALUPE', 'GUAYMS              ', 'GUAYMS              ', 'SON                 '),
(7744, '173784              ', 'CENTENARIO', 'HER                 ', 'HER                 ', 'SON                 '),
(7745, '174683              ', 'EL LLANO', 'HER                 ', 'HER                 ', 'SON                 '),
(7746, '174754              ', 'LEY 57', 'HER                 ', 'HER                 ', 'SON                 '),
(7747, '174772              ', 'EL RANCHITO', 'HER                 ', 'HER                 ', 'SON                 '),
(7748, '174854              ', 'VILLA DEL REAL', 'HER                 ', 'HER                 ', 'SON                 '),
(7749, '174866              ', 'LOS ARCOS', 'HER                 ', 'HER                 ', 'SON                 '),
(7750, '175458              ', '.', 'HER                 ', 'HER                 ', 'SON                 '),
(7751, '176021              ', 'MISION DE REAL', 'HER                 ', 'HER                 ', 'SON                 '),
(7752, '176146              ', 'A LAS QUINTAS', 'HER                 ', 'HER                 ', 'SON                 '),
(7753, '176203              ', 'VALLE VERDE', 'HER                 ', 'HER                 ', 'SON                 '),
(7754, '176461              ', 'PEDREGAL DE LA VILLA', 'HER                 ', 'HER                 ', 'SON                 '),
(7755, '176506              ', 'EMILIANO ZAPATA', 'HER                 ', 'HER                 ', 'SON                 '),
(7756, '176819              ', 'RINCONADA DE LA ARBOLEDA', 'HER                 ', 'HER                 ', 'SON                 '),
(7757, '176829              ', 'CONSTITUCION', 'HER                 ', 'HER                 ', 'SON                 '),
(7758, '176876              ', 'LAS QUINTAS', 'HER                 ', 'HER                 ', 'SON                 '),
(7759, '176897              ', 'LAS VILLAS', 'HER                 ', 'HER                 ', 'SON                 '),
(7760, '176914              ', 'LOS NARANJOS', 'HER                 ', 'HER                 ', 'SON                 '),
(7761, '176971              ', 'PARQUE INDUSTRIAL', 'HER                 ', 'HER                 ', 'SON                 '),
(7762, '177078              ', 'SAN ANGEL', 'HER                 ', 'HER                 ', 'SON                 '),
(7763, '177301              ', 'OLIVARES', 'HER                 ', 'HER                 ', 'SON                 '),
(7764, '177341              ', 'PUEBLO ALTO', 'HER                 ', 'HER                 ', 'SON                 '),
(7765, '177360              ', 'VALLE HERMOSO', 'HER                 ', 'HER                 ', 'SON                 '),
(7766, '177393              ', 'NUEVO HERMOSILLO', 'HER                 ', 'HER                 ', 'SON                 '),
(7767, '177688              ', 'LAS LOMAS', 'HER                 ', 'HER                 ', 'SON                 '),
(7768, '177756              ', 'MODELO', 'HER                 ', 'HER                 ', 'SON                 '),
(7769, '177911              ', 'PRADOS DEL CENTENARIO', 'HER                 ', 'HER                 ', 'SON                 '),
(7770, '178246              ', 'PIMENTEL', 'HER                 ', 'HER                 ', 'SON                 '),
(7771, '178389              ', 'CASA GRANDE', 'HER                 ', 'HER                 ', 'SON                 '),
(7772, '178457              ', 'FRACC.EL DORADO', 'HER                 ', 'HER                 ', 'SON                 '),
(7773, '178540              ', 'LA MANGA', 'HER                 ', 'HER                 ', 'SON                 '),
(7774, '178575              ', 'COUNTRY CLUB', 'HER                 ', 'HER                 ', 'SON                 '),
(7775, '178588              ', 'FRACCIONAMIENTO RESIDENCIAL ARIZONA', 'HER                 ', 'HER                 ', 'SON                 '),
(7776, '178617              ', 'PITIC', 'HER                 ', 'HER                 ', 'SON                 '),
(7777, '178652              ', 'RESIDENCIAL DE ANZA', 'HER                 ', 'HER                 ', 'SON                 '),
(7778, '178678              ', 'SAN FRANCISCO', 'HER                 ', 'HER                 ', 'SON                 '),
(7779, '178767              ', 'PASEOS DEL SOL', 'HER                 ', 'HER                 ', 'SON                 '),
(7780, '178938              ', 'PUERTA GRANDE RESIDENCIAL', 'HER                 ', 'HER                 ', 'SON                 '),
(7781, '179169              ', 'RAQUET CLUB', 'HER                 ', 'HER                 ', 'SON                 '),
(7782, '179399              ', 'ADOLFO DE LA HUERTA', 'HER                 ', 'HER                 ', 'SON                 '),
(7783, '70596               ', 'LOMA LINDA', 'HER                 ', 'HER                 ', 'SON                 '),
(7784, '70823               ', 'CENTRO', 'HER                 ', 'HER                 ', 'SON                 '),
(7785, '73284               ', 'SAN BENITO', 'HER                 ', 'HER                 ', 'SON                 '),
(7786, '178171              ', 'FRACCIONAMIENTO DIAZ', 'HUATBMPO            ', 'HUATBMPO            ', 'SON                 '),
(7787, '175461              ', '.', 'NAVOJOA             ', 'NAVOJOA             ', 'SON                 '),
(7788, '177119              ', 'JUAREZ', 'NAVOJOA             ', 'NAVOJOA             ', 'SON                 '),
(7789, '71396               ', 'SONORA', 'NAVOJOA             ', 'NAVOJOA             ', 'SON                 '),
(7790, '174759              ', 'MODERNA', 'NOG                 ', 'NOG                 ', 'SON                 '),
(7791, '175013              ', 'CENTRO', 'NOG                 ', 'NOG                 ', 'SON                 '),
(7792, '175460              ', '.', 'NOG                 ', 'NOG                 ', 'SON                 '),
(7793, '175573              ', 'KENNEDY', 'NOG                 ', 'NOG                 ', 'SON                 '),
(7794, '175974              ', 'BOLIVAR', 'NOG                 ', 'NOG                 ', 'SON                 '),
(7795, '176788              ', 'ORIZABA', 'NOG                 ', 'NOG                 ', 'SON                 '),
(7796, '178310              ', 'PARQUE IND. SAN RAMON', 'NOG                 ', 'NOG                 ', 'SON                 '),
(7797, '173900              ', 'XOCHILOA', 'OBREGON             ', 'OBREGON             ', 'SON                 '),
(7798, '175834              ', 'CENTRO', 'OBREGON             ', 'OBREGON             ', 'SON                 '),
(7799, '177589              ', 'CENTRAL DE ABASTOS', 'OBREGON             ', 'OBREGON             ', 'SON                 '),
(7800, '70399               ', 'PARQUE INDUSTRIAL', 'OBREGON             ', 'OBREGON             ', 'SON                 '),
(7801, '73720               ', 'BENITO JUAREZ', 'OBREGON             ', 'OBREGON             ', 'SON                 '),
(7802, '177123              ', 'CENTRO', 'PITI                ', 'PIT                 ', 'SON                 '),
(7803, '177705              ', 'ORIENTE', 'PTOPESCO            ', 'PTOPESCO            ', 'SON                 '),
(7804, '177809              ', 'SANDY BEACH', 'PTOPESCO            ', 'PTOPESCO            ', 'SON                 '),
(7805, '175152              ', 'RUIZ CORTINEZ', 'SNLRIOCDO           ', 'SNLRIOCDO           ', 'SON                 '),
(7806, '177620              ', 'COLONIA INDUSTRIAL', 'SNLRIOCDO           ', 'SNLRIOCDO           ', 'SON                 ');
INSERT INTO `colonias` (`id_colonia`, `Clave`, `Descripcion`, `Ciudad`, `Municipio`, `Estado`) VALUES
(7807, '178128              ', 'RESIDENCIAS', 'SNLRIOCDO           ', 'SNLRIOCDO           ', 'SON                 '),
(7808, '175462              ', '.', 'URES                ', 'URES                ', 'SON                 '),
(7809, '177270              ', '.', 'VPSQ                ', 'VPSQ                ', 'SON                 '),
(7810, '177271              ', 'LA JOYA', 'VPSQ                ', 'VPSQ                ', 'SON                 '),
(7811, '174914              ', 'RANCHERIA ORIENTE', 'COM                 ', 'COM                 ', 'TABASCO             '),
(7812, '71289               ', 'CENTRO', 'PARAISO             ', 'PARAISO             ', 'TABASCO             '),
(7813, '175903              ', '.', 'TACOTALPA           ', 'TACOTALPA           ', 'TABASCO             '),
(7814, '175463              ', '.', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7815, '176149              ', 'FRACC.FRAMBOYANES', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7816, '176153              ', 'ATASTA DE SERRA', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7817, '177614              ', 'INDUSTRIAL', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7818, '177848              ', 'LINDAVISTA', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7819, '178165              ', 'CENTRO', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7820, '178291              ', 'FRACCIONAMIENTO PARAISO', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7821, '178700              ', 'INFONAVIT CIUDAD INDUSTRIAL', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7822, '178898              ', 'JESUS GARCIA', 'VILLHMOSA           ', 'VILLHMOSA           ', 'TABASCO             '),
(7823, '174017              ', 'NUEVO PUERTO INDUSTRIAL', 'AM                  ', 'AM                  ', 'TAM                 '),
(7824, '174521              ', 'CENTRO', 'AM                  ', 'AM                  ', 'TAM                 '),
(7825, '174522              ', '.', 'AM                  ', 'AM                  ', 'TAM                 '),
(7826, '174537              ', 'ALTAMIRA TAMAULIPAS', 'AM                  ', 'AM                  ', 'TAM                 '),
(7827, '176003              ', 'LAGUNA DE LA PUERTA', 'AM                  ', 'AM                  ', 'TAM                 '),
(7828, '176279              ', 'Justo Sierra', 'AM                  ', 'AM                  ', 'TAM                 '),
(7829, '177536              ', 'PUERTO INDUSTRIAL', 'AM                  ', 'AM                  ', 'TAM                 '),
(7830, '178631              ', 'LA ESPAÑITA', 'AM                  ', 'AM                  ', 'TAM                 '),
(7831, '177400              ', 'SIN COLONIA', 'CDCAMARGO           ', 'CDCAMARGO           ', 'TAM                 '),
(7832, '177899              ', 'UNIDAD NACIONAL', 'CDMADERO            ', 'CDMADERO            ', 'TAM                 '),
(7833, '178677              ', 'RICARDO FLORES MAGON', 'CDMADERO            ', 'CDMADERO            ', 'TAM                 '),
(7834, '176488              ', 'ZONA CENTRO', 'CDVICTRIA           ', 'CDVICTRIA           ', 'TAM                 '),
(7835, '177913              ', 'MAGISTERIAL', 'CDVICTRIA           ', 'CDVICTRIA           ', 'TAM                 '),
(7836, '177919              ', 'PARQUE INDUSTRIAL NUEVO SANTANDER', 'CDVICTRIA           ', 'CDVICTRIA           ', 'TAM                 '),
(7837, '178536              ', '.', 'HMATA               ', 'HMATA               ', 'TAM                 '),
(7838, '178537              ', 'MODELO', 'HMATA               ', 'HMATA               ', 'TAM                 '),
(7839, '178860              ', 'ZONA CENTRO', 'HMATA               ', 'HMATA               ', 'TAM                 '),
(7840, '178392              ', 'TALLERES', 'MAD                 ', 'MA                  ', 'TAM                 '),
(7841, '174260              ', 'BUENAVISTA', 'MATA                ', 'MATA                ', 'TAM                 '),
(7842, '175467              ', '.', 'MATA                ', 'MATA                ', 'TAM                 '),
(7843, '176076              ', 'FRACC.SATELITE', 'MATA                ', 'MATA                ', 'TAM                 '),
(7844, '176122              ', 'CAMPESTRE DEL RIO 2', 'MATA                ', 'MATA                ', 'TAM                 '),
(7845, '176580              ', 'CENTRO', 'MATA                ', 'MATA                ', 'TAM                 '),
(7846, '178168              ', 'LAS GRANJAS', 'MATA                ', 'MATA                ', 'TAM                 '),
(7847, '174371              ', 'LA PAZ', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7848, '174427              ', 'ALFONSO MARTINEZ DOMINGUEZ', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7849, '174924              ', 'GRANJAS ECONOMICAS 1', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7850, '175009              ', 'VIVEROS', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7851, '175468              ', '.', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7852, '175587              ', 'ANAHUAC', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7853, '175756              ', 'JUAREZ', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7854, '176150              ', 'JARDIN', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7855, '176164              ', 'CENTRO', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7856, '176291              ', 'CAMPESTRE', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7857, '176296              ', 'MADERO', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7858, '176309              ', 'GRANJAS REGINAS', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7859, '176393              ', 'PARQUE INDUSTRIAL AMERICA', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7860, '176670              ', 'SECTOR ADUANA', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7861, '176686              ', 'EJIDO EL PROGRESO', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7862, '177246              ', 'ZARAGOZA', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7863, '178123              ', 'SAN RAFAEL', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7864, '178245              ', 'HIPODROMO', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7865, '178476              ', 'GUERRERO', 'NUEVOLARE           ', 'NL                  ', 'TAM                 '),
(7866, '175264              ', 'PARQUE INDUSTRIAL DEL NORTE', 'REYNSA              ', 'REYNSA              ', 'TAM                 '),
(7867, '175465              ', '.', 'REYNSA              ', 'REYNSA              ', 'TAM                 '),
(7868, '176274              ', 'PARQUE INDUSTRIAL COLONIAL', 'REYNSA              ', 'REYNSA              ', 'TAM                 '),
(7869, '176937              ', 'LONGORIA', 'REYNSA              ', 'REYNSA              ', 'TAM                 '),
(7870, '177259              ', 'PARQUE INDUSTRIAL REYNOSA', 'REYNSA              ', 'REYNSA              ', 'TAM                 '),
(7871, '177993              ', 'ZONA CENTRO', 'REYNSA              ', 'REYNSA              ', 'TAM                 '),
(7872, '176907              ', 'CENTRO', 'RIB                 ', 'RIB                 ', 'TAM                 '),
(7873, '176908              ', '.', 'RIB                 ', 'RIB                 ', 'TAM                 '),
(7874, '174542              ', 'CENTRO', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7875, '175464              ', '.', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7876, '175952              ', 'LOMAS DEL NARANJAL', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7877, '176002              ', 'LAGUNA DE LA PUERTA', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7878, '176140              ', 'TAMPICO', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7879, '176322              ', 'PETROLERA', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7880, '176774              ', 'ZONA CENTRO', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7881, '176856              ', 'CENTRO ALTAMIRA Y OBREGON', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7882, '176875              ', 'MEXICO', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7883, '177339              ', 'ARENAL', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7884, '177618              ', 'UNIVERSIDAD PONIENTE', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7885, '178082              ', 'DEL PUEBLO', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7886, '178931              ', 'ALTAVISTA', 'TAMP                ', 'TAMP                ', 'TAM                 '),
(7887, '176052              ', 'SAN JOSE', 'VALLE               ', 'VH                  ', 'TAM                 '),
(7888, '179157              ', 'CENTRO', 'VH                  ', 'VH                  ', 'TAM                 '),
(7889, '175466              ', '.', 'villagrn            ', 'VILLAGRN            ', 'TAM                 '),
(7890, '176343              ', 'CAÑADAS', 'APIZAC              ', 'APIZAC              ', 'TLA                 '),
(7891, '178257              ', 'CENTRO', 'APIZAC              ', 'APIZAC              ', 'TLA                 '),
(7892, '176355              ', 'CENTRO', 'HUAMAN              ', 'HUAMAN              ', 'TLA                 '),
(7893, '176356              ', 'CD. INDUSTRIAL  XICOTENCATL 2', 'HUAMAN              ', 'HUAMAN              ', 'TLA                 '),
(7894, '174776              ', 'SAN NICOLAS PANOTLA', 'TLX                 ', 'TLAX                ', 'TLA                 '),
(7895, '174571              ', 'FRACCIONAMIENTO COSTA VERDE', 'BOCAR               ', 'BOCAR               ', 'VER                 '),
(7896, '175307              ', 'EJIDO PRIMERO DE MAYO', 'BOCAR               ', 'BOCAR               ', 'VER                 '),
(7897, '177795              ', 'FRACC. JARDINES DE VIRGINIA', 'BOCAR               ', 'BOCAR               ', 'VER                 '),
(7898, '178419              ', 'YLANG YLANG', 'BOCAR               ', 'BOCAR               ', 'VER                 '),
(7899, '178422              ', 'REVOLUCION SUR', 'BOCAR               ', 'BOCAR               ', 'VER                 '),
(7900, '175470              ', 'CENTRO', 'COATZCOLCS          ', 'COATZCOLCS          ', 'VER                 '),
(7901, '178656              ', 'MANUEL AVILA CAMACHO', 'COATZCOLCS          ', 'COATZCOLCS          ', 'VER                 '),
(7902, '174787              ', 'CLUB CAMPESTRE', 'CORD                ', 'COR                 ', 'VER                 '),
(7903, '174888              ', 'SAN CAYETANO', 'CORD                ', 'COR                 ', 'VER                 '),
(7904, '174899              ', 'SAN DIMAS', 'CORD                ', 'COR                 ', 'VER                 '),
(7905, '175138              ', 'ZONA INDUSTRIAL', 'CORD                ', 'COR                 ', 'VER                 '),
(7906, '175469              ', '.', 'CORD                ', 'COR                 ', 'VER                 '),
(7907, '175588              ', 'SAN NICOLÁS', 'CORD                ', 'COR                 ', 'VER                 '),
(7908, '175699              ', 'SAN JOSE', 'CORD                ', 'COR                 ', 'VER                 '),
(7909, '176858              ', 'CENTRO', 'CORD                ', 'COR                 ', 'VER                 '),
(7910, '176675              ', 'CANTICAS', 'COZO                ', 'COZO                ', 'VER                 '),
(7911, '174029              ', '.', 'FOR                 ', 'FOR                 ', 'VER                 '),
(7912, '174030              ', 'CENTRO', 'FOR                 ', 'FOR                 ', 'VER                 '),
(7913, 'CRIS                ', 'SAN CRISTOBAL', 'HUILO               ', 'HUIL                ', 'VER                 '),
(7914, '174380              ', 'MODELO', 'JALAPA              ', 'JALAPA              ', 'VER                 '),
(7915, '175939              ', 'INDECO ANIMAS', 'JALAPA              ', 'JALAPA              ', 'VER                 '),
(7916, '175940              ', 'CENTRO', 'JALAPA              ', 'JALAPA              ', 'VER                 '),
(7917, '176577              ', 'ENCINAL', 'JALAPA              ', 'JALAPA              ', 'VER                 '),
(7918, '177287              ', 'FRACC. JARDINES DE LAS ANIMAS', 'JALAPA              ', 'JALAPA              ', 'VER                 '),
(7919, '178036              ', 'ZONA UNIVERSITARIA', 'JALAPA              ', 'JALAPA              ', 'VER                 '),
(7920, '177789              ', 'CENTRO', 'MTZDLTRRE           ', 'MTZDLTRRE           ', 'VER                 '),
(7921, '174967              ', 'CENTRO', 'ORIZ                ', 'ORIZ                ', 'VER                 '),
(7922, '177928              ', 'ESPINAL', 'ORIZ                ', 'ORIZ                ', 'VER                 '),
(7923, '175135              ', 'PETROLERA', 'POZRICA             ', 'POZRICA             ', 'VER                 '),
(7924, '174028              ', '.', 'VER                 ', 'VER                 ', 'VER                 '),
(7925, '174329              ', 'SAN CAYETANO', 'VER                 ', 'VER                 ', 'VER                 '),
(7926, '175858              ', 'XICO', 'VER                 ', 'VER                 ', 'VER                 '),
(7927, '176086              ', 'EJIDO 1RO. MAYO', 'VER                 ', 'VER                 ', 'VER                 '),
(7928, '176532              ', 'FRACCIONAMIENTO REFORMA', 'VER                 ', 'VER                 ', 'VER                 '),
(7929, '176936              ', 'PLAN DE AYALA TIHUATLAN', 'VER                 ', 'VER                 ', 'VER                 '),
(7930, '176963              ', 'CAMPESTRE', 'VER                 ', 'VER                 ', 'VER                 '),
(7931, '178131              ', 'FRACC. REFORMA', 'VER                 ', 'VER                 ', 'VER                 '),
(7932, '178549              ', 'FRACC. FAROS', 'VER                 ', 'VER                 ', 'VER                 '),
(7933, '73752               ', 'CENTRO', 'VER                 ', 'VER                 ', 'VER                 '),
(7934, '176981              ', '.', 'XALAPA              ', 'XALAPA              ', 'VER                 '),
(7935, '176982              ', 'RESERVA TERRITORIAL', 'XALAPA              ', 'XALAPA              ', 'VER                 '),
(7936, '176983              ', 'CENTRO', 'XALAPA              ', 'XALAPA              ', 'VER                 '),
(7937, '177288              ', 'FRACC. JARDINES DE LAS ANIMAS', 'XALAPA              ', 'XALAPA              ', 'VER                 '),
(7938, '178462              ', 'ALVARO OBREGON', 'XALAPA              ', 'XALAPA              ', 'VER                 '),
(7939, '178463              ', 'PROGRESO MACUILTEPETL', 'XALAPA              ', 'XALAPA              ', 'VER                 '),
(7940, '178579              ', 'POMONA', 'XALAPA              ', 'XALAPA              ', 'VER                 '),
(7941, '175859              ', 'CENTRO', 'XICO                ', 'XICO                ', 'VER                 '),
(7942, '177793              ', 'PLAN DE AYALA SUR', 'KAN                 ', 'KANA                ', 'YUC                 '),
(7943, '177122              ', 'PLAN DE AYALA SUR', 'KANAN               ', 'KANA                ', 'YUC                 '),
(7944, '174207              ', 'CAMPESTRE', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7945, '174605              ', 'GARCIA GINERES', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7946, '174610              ', 'MEXICO', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7947, '174716              ', 'COL. EMILIANO ZAPATA NORTE', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7948, '175044              ', 'SAN DAMIAN', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7949, '175127              ', 'AMPLIACION CIUDAD INDUSTRIAL', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7950, '175153              ', 'LOPEZ MATEOS', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7951, '175205              ', 'FRACCIONAMIENTO YUCALPETEN', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7952, '175379              ', '.', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7953, '175420              ', 'ITZIMNA', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7954, '175872              ', 'XMATKUIL', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7955, '175987              ', 'OBRERA', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7956, '176132              ', 'SAN MIGUEL', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7957, '176268              ', 'CIUDAD INDUSTRIAL', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7958, '176293              ', 'PARQUE MUEBLERO', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7959, '176539              ', 'PACABTUN', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7960, '176590              ', 'XCUMPICH', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7961, '176815              ', 'SANTA ROSA', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7962, '177211              ', 'FRACC. AMP. CD. INDUSTRIAL', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7963, '177527              ', 'POLIGONO 108', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7964, '177563              ', 'SAMBULA', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7965, '177765              ', 'AEROPUERTO INTERNACIONAL', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7966, '178060              ', 'CHUBURNA DE HIDALGO', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7967, '178362              ', 'PARQUE INDUSTRIAL YUCATAN', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7968, '178634              ', 'GARCIA REJON ALTOS', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7969, '178829              ', 'FRACC. LIMONES', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7970, '178907              ', 'YUCALPETEN', 'MERIDA              ', 'MERIDA              ', 'YUC                 '),
(7971, '177832              ', 'NUEVA YUKALPETEN', 'PROGRES             ', 'PROGRES             ', 'YUC                 '),
(7972, '174731              ', 'YUCALTEPEN', 'PTOPROG             ', 'PTOPRO              ', 'YUC                 '),
(7973, '174980              ', 'CENTRO', 'PTOPROG             ', 'PTOPRO              ', 'YUC                 '),
(7974, '176294              ', 'PARQUE MUEBLERO', 'UMAN                ', 'UMAN                ', 'YUC                 '),
(7975, '175942              ', '.', 'CALE                ', 'CAL                 ', 'ZAC                 '),
(7976, '175943              ', 'CENTRO', 'CALE                ', 'CAL                 ', 'ZAC                 '),
(7977, '175944              ', 'ZONA INDUSTRIAL', 'CALE                ', 'CAL                 ', 'ZAC                 '),
(7978, '177463              ', 'PATRIA Y LIBERTAD', 'FRESN               ', 'FRESN               ', 'ZAC                 '),
(7979, '175758              ', '.', 'GAR                 ', 'GAR                 ', 'ZAC                 '),
(7980, '174676              ', 'CENTRO', 'GUADPE              ', 'GUADPE              ', 'ZAC                 '),
(7981, '176048              ', 'LOMAS DE BERNARDEZ', 'GUADPE              ', 'GUADPE              ', 'ZAC                 '),
(7982, '177722              ', 'SAN RAFAEL', 'GUADPE              ', 'GUADPE              ', 'ZAC                 '),
(7983, '177726              ', 'FRACCIONAMIENTO PRIVADA DEL PARQUE', 'GUADPE              ', 'GUADPE              ', 'ZAC                 '),
(7984, '178252              ', 'FRACC. LA FLORIDA', 'GUADPE              ', 'GUADPE              ', 'ZAC                 '),
(7985, '175614              ', '.', 'JREZDGS             ', 'JREZDGS             ', 'ZAC                 '),
(7986, '177407              ', 'CENTRO', 'JRZ                 ', 'JRZ                 ', 'ZAC                 '),
(7987, '175136              ', 'CENTRO', 'JUCHIP              ', 'JUCHIP              ', 'ZAC                 '),
(7988, '175608              ', '.', 'MOMAX               ', 'MOMAX               ', 'ZAC                 '),
(7989, '177774              ', 'ARBOLEDAS', 'NOCHIS              ', 'NOCHIS              ', 'ZAC                 '),
(7990, '178843              ', 'CENTRO', 'NOCHIS              ', 'NOCHIS              ', 'ZAC                 '),
(7991, '174211              ', '..', 'TAB                 ', 'TAB                 ', 'ZAC                 '),
(7992, '175929              ', 'CENTRO PARAISO', 'TAB                 ', 'TAB                 ', 'ZAC                 '),
(7993, '175613              ', '.', 'TEPE                ', 'TEPE                ', 'ZAC                 '),
(7994, '175602              ', '.', 'TEPECHITLAN         ', 'TEPECHITLAN         ', 'ZAC                 '),
(7995, '175601              ', '.', 'TEUL                ', 'TEUL                ', 'ZAC                 '),
(7996, '175783              ', 'CENTRO', 'TEUL                ', 'TEUL                ', 'ZAC                 '),
(7997, '175603              ', '.', 'TLAL                ', 'TLAL                ', 'ZAC                 '),
(7998, '178506              ', 'CENTRO', 'TLAL                ', 'TLAL                ', 'ZAC                 '),
(7999, '177695              ', 'EDEN', 'TLALM               ', 'TLAL                ', 'ZAC                 '),
(8000, '178930              ', 'SAN FRANCISCO', 'TLALTE              ', 'TLALT               ', 'ZAC                 '),
(8001, '174355              ', 'FRACCIONAMIENTO BOULEVARES', 'ZAC                 ', 'ZAC                 ', 'ZAC                 '),
(8002, '174373              ', 'SIERRA DE ALICA', 'ZAC                 ', 'ZAC                 ', 'ZAC                 '),
(8003, '174865              ', 'LOMAS DE BERNARDEZ', 'ZAC                 ', 'ZAC                 ', 'ZAC                 '),
(8004, '175195              ', 'CENTRO', 'ZAC                 ', 'ZAC                 ', 'ZAC                 '),
(8005, '175471              ', '.', 'ZAC                 ', 'ZAC                 ', 'ZAC                 '),
(8006, '175607              ', '.', 'ZAC                 ', 'ZAC                 ', 'ZAC                 '),
(8007, '57                  ', 'PARQUES DEL BOSQUE ', 'SPEDRO              ', 'SANPEDRO            ', 'JAL                 ');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `config`
--

CREATE TABLE `config` (
  `id` int(11) NOT NULL,
  `afiliado` int(11) DEFAULT NULL,
  `folio_promo` varchar(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `config`
--

INSERT INTO `config` (`id`, `afiliado`, `folio_promo`) VALUES
(1, 1, '7'),
(2, 199, '2');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `config_suscriptor`
--

CREATE TABLE `config_suscriptor` (
  `id` int(11) NOT NULL,
  `Cercanos` tinyint(1) DEFAULT NULL,
  `Gastronomia` tinyint(1) DEFAULT NULL,
  `EstiloDeVida` tinyint(1) DEFAULT NULL,
  `Eventos` tinyint(1) DEFAULT NULL,
  `HogarServicios` tinyint(1) DEFAULT NULL,
  `SaludBelleza` tinyint(1) DEFAULT NULL,
  `id_tarjeta` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `config_suscriptor`
--

INSERT INTO `config_suscriptor` (`id`, `Cercanos`, `Gastronomia`, `EstiloDeVida`, `Eventos`, `HogarServicios`, `SaludBelleza`, `id_tarjeta`) VALUES
(1, 1, 1, 1, 1, 0, 0, 705);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `estados`
--

CREATE TABLE `estados` (
  `id_estado` int(11) NOT NULL,
  `Clave` varchar(50) DEFAULT NULL,
  `Descripcion` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `estados`
--

INSERT INTO `estados` (`id_estado`, `Clave`, `Descripcion`) VALUES
(1, 'AGS                 ', 'AGUASCALIENTES'),
(2, 'BCN                 ', 'BAJA CALIFORNIA'),
(3, 'BCNN                ', 'BAJA CALIFORNIA NORTE'),
(4, 'BCS                 ', 'BAJA CALIFORNIA SUR'),
(5, 'CAM                 ', 'CAMPECHE'),
(6, 'CHIHUAHUA           ', 'CHIHUAHUA'),
(7, 'CHS                 ', 'CHIAPAS'),
(8, 'COAH                ', 'COAHUILA'),
(9, 'COL                 ', 'COLIMA'),
(10, 'D.F.                ', 'CIUDAD DE MEXICO'),
(11, 'DGO                 ', 'DURANGO'),
(12, 'EM                  ', 'ESTADO DE MEXICO'),
(13, 'GRO                 ', 'GUERRERO'),
(14, 'GTO                 ', 'GUANAJUATO'),
(15, 'HGO                 ', 'HIDALGO'),
(16, 'JAL                 ', 'JALISCO'),
(17, 'MICH                ', 'MICHOACAN'),
(18, 'MICHOA              ', 'MICHOACAN DE OCAMPO'),
(19, 'MOR                 ', 'MORELOS'),
(20, 'NAYARIT             ', 'NAYARIT'),
(21, 'NL                  ', 'NUEVO LEÓN'),
(22, 'OAX                 ', 'OAXACA'),
(23, 'PUEBLA              ', 'PUEBLA'),
(24, 'QRO                 ', 'QUERETARO'),
(25, 'QUINTANA ROO        ', 'QUINTANA ROO'),
(26, 'SIN                 ', 'SINALOA'),
(27, 'SLP                 ', 'SAN LUIS POTOSI'),
(28, 'SON                 ', 'SONORA'),
(29, 'TABASCO             ', 'TABASCO'),
(30, 'TAM                 ', 'TAMAULIPAS'),
(31, 'TLA                 ', 'TLAXCALA'),
(32, 'VER                 ', 'VERACRUZ'),
(33, 'VERA                ', 'VERACRUZ DE IGNACIO DE LA LLAVE'),
(34, 'YUC                 ', 'YUCATAN'),
(35, 'ZAC                 ', 'ZACATECAS');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `galeria`
--

CREATE TABLE `galeria` (
  `id` int(11) NOT NULL,
  `img_url` varchar(100) NOT NULL,
  `categoria` varchar(100) NOT NULL,
  `aprobado` tinyint(1) DEFAULT NULL,
  `id_afiliado` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `galeria`
--

INSERT INTO `galeria` (`id`, `img_url`, `categoria`, `aprobado`, `id_afiliado`) VALUES
(58, 'img/1654193805_1653455542_5.jpg', 'promoapp', 0, 1),
(66, 'img/1654266339_24.jpg', 'logoapp', 0, 1),
(67, 'img/1654266359_qergh3eq.png', 'logoapp', 0, 1),
(68, 'img/1654266366_qergrets.png', 'logoapp', 1, 1),
(69, 'img/1654266377_2ewfw5.jpg', 'logoapp', 0, 1),
(70, 'img/1654266391_25.jpg', 'logoapp', 0, 1),
(78, 'img/1655433741_mcdonalds-logo.png', 'logoapp', 1, 1),
(80, 'img/1658882891_logo_labelti.png', 'promoapp', 0, 2),
(82, 'img/1658882929_logo.png', 'logoapp', 0, 2),
(84, 'img/1658883021_e16b5dbbe24e97a62950941fb36d9450.jpg', 'perfilweb', 0, 2),
(89, 'img/per-1.jpg', 'perfilapp', 0, 0),
(90, 'img/per-1.jpg', 'perfilweb', 0, 0),
(91, 'img/pro-1.jpg', 'promoapp', 0, 0),
(92, 'img/pro-1.jpg', 'promoweb', 0, 0),
(93, 'img/afi-1.jpg', 'logoapp', 0, 0),
(94, 'img/afi-1.jpg', 'logoweb', 0, 0),
(103, 'img/1659712463_583-1.jpg', 'perfilweb', 0, 10),
(105, 'img/1659804399_583-1.jpg', 'logoapp', 0, 13),
(109, 'img/1659804613_668-1.jpg', 'promoapp', 0, 13),
(110, 'img/1659804621_349-1.jpg', 'promoapp', 0, 13),
(117, 'img/1660746330_349-1.jpg', 'logoweb', 0, 60),
(118, 'img/1660746519_349-1.jpg', 'perfilapp', 0, 60),
(119, 'img/1660746547_349-1.jpg', 'promoweb', 0, 60),
(120, 'img/1660746690_144-1.jpg', 'logoweb', 0, 9),
(121, 'img/1660746705_144-1.jpg', 'perfilapp', 0, 9),
(122, 'img/1660748568_115-1.jpg', 'perfilapp', 0, 1),
(123, 'img/1660748612_115-1.jpg', 'promoweb', 0, 1),
(126, 'img/1660748672_115-1.jpg', 'logoweb', 0, 1),
(127, 'img/1660758453_641-1.jpg', 'logoweb', 0, 199),
(128, 'img/1660758488_641-1.jpg', 'perfilapp', 0, 199),
(129, 'img/1661291021_94-1.jpg', 'logoweb', 0, 388),
(130, 'img/1661291041_94-1.jpg', 'promoweb', 0, 388),
(131, 'img/1661291060_94-1.jpg', 'perfilapp', 0, 388),
(132, 'img/1661295054_168-1.jpg', 'logoweb', 0, 15),
(133, 'img/1661295123_168-1.jpg', 'perfilapp', 0, 15),
(134, 'img/1661295227_168-1.jpg', 'promoweb', 0, 15),
(136, 'img/1661295489_214-1.jpg', 'promoweb', 0, 24),
(137, 'img/1661295506_214-1.jpg', 'perfilapp', 0, 24),
(138, 'img/1661295522_214-1.jpg', 'logoweb', 0, 24),
(140, 'img/1661295742_272-1.jpg', 'logoweb', 0, 34),
(141, 'img/1661295765_272-1.jpg', 'perfilapp', 0, 34),
(142, 'img/1661295779_272-1.jpg', 'promoweb', 0, 34),
(143, 'img/1661295852_370-1.jpg', 'logoweb', 0, 73),
(144, 'img/1661295872_370-1.jpg', 'promoweb', 0, 73),
(145, 'img/1661295884_370-1.jpg', 'perfilapp', 0, 73),
(146, 'img/1661295982_377-1.jpg', 'logoweb', 0, 76),
(147, 'img/1661296012_377-1.jpg', 'perfilapp', 0, 76),
(148, 'img/1661296033_377-1.jpg', 'promoweb', 0, 76),
(149, 'img/1661296194_387-1.jpg', 'promoweb', 0, 83),
(150, 'img/1661296207_387-1.jpg', 'perfilapp', 0, 83),
(151, 'img/1661296218_387-1.jpg', 'logoweb', 0, 83),
(152, 'img/1661296329_450-1.jpg', 'logoweb', 0, 106),
(153, 'img/1661296357_450-1.jpg', 'perfilapp', 0, 106),
(154, 'img/1661296376_450-1.jpg', 'promoweb', 0, 106),
(155, 'img/1661296464_597-1.jpg', 'perfilapp', 0, 170),
(156, 'img/1661296477_597-1.jpg', 'promoweb', 0, 170),
(157, 'img/1661296488_597-1.jpg', 'logoweb', 0, 170),
(158, 'img/1661296580_614-1.jpg', 'perfilapp', 0, 179),
(160, 'img/1661296610_614-1.jpg', 'promoweb', 0, 179),
(161, 'img/1661296623_614-1.jpg', 'logoweb', 0, 179),
(162, 'img/1661296697_646-1.jpg', 'perfilapp', 0, 202),
(163, 'img/1661296713_646-1.jpg', 'promoweb', 0, 202),
(164, 'img/1661296727_646-1.jpg', 'logoweb', 0, 202),
(166, 'img/1661296962_665-1.jpg', 'logoweb', 0, 218),
(167, 'img/1661296998_665-1.jpg', 'promoweb', 0, 218),
(168, 'img/1661297013_665-1.jpg', 'perfilapp', 0, 218),
(169, 'img/1661297115_671-1.jpg', 'perfilapp', 0, 222),
(170, 'img/1661297128_671-1.jpg', 'promoweb', 0, 222),
(171, 'img/1661297138_671-1.jpg', 'logoweb', 0, 222),
(172, 'img/1661297210_690-1.jpg', 'perfilapp', 0, 236),
(173, 'img/1661297223_690-1.jpg', 'promoweb', 0, 236),
(174, 'img/1661297241_690-1.jpg', 'logoweb', 0, 236),
(175, 'img/1661297321_723-1.jpg', 'perfilapp', 0, 267),
(176, 'img/1661297334_723-1.jpg', 'promoweb', 0, 267),
(177, 'img/1661297351_723-1.jpg', 'logoweb', 0, 267),
(178, 'img/1661297484_756-1.jpg', 'perfilapp', 0, 300),
(179, 'img/1661297498_756-1.jpg', 'promoweb', 0, 300),
(180, 'img/1661297508_756-1.jpg', 'logoweb', 0, 300),
(182, 'img/1661297808_144-1.jpg', 'promoweb', 0, 9),
(183, 'img/1661297888_21-1.jpg', 'perfilapp', 0, 22),
(184, 'img/1661297901_21-1.jpg', 'promoweb', 0, 22),
(185, 'img/1661297913_21-1.jpg', 'logoweb', 0, 22),
(187, 'img/1661298035_15-1.jpg', 'promoweb', 0, 10),
(188, 'img/1661298046_15-1.jpg', 'logoweb', 0, 10),
(189, 'img/1661298232_41-1.jpg', 'perfilapp', 0, 96),
(190, 'img/1661298245_41-1.jpg', 'promoweb', 0, 96),
(191, 'img/1661298258_41-1.jpg', 'logoweb', 0, 96),
(192, 'img/1661298308_60-1.jpg', 'perfilapp', 0, 172),
(193, 'img/1661298318_60-1.jpg', 'promoweb', 0, 172),
(194, 'img/1661298326_60-1.jpg', 'logoweb', 0, 172),
(195, 'img/1661298526_170-1.jpg', 'perfilapp', 0, 16),
(196, 'img/1661298542_170-1.jpg', 'promoweb', 0, 16),
(197, 'img/1661298551_170-1.jpg', 'logoweb', 0, 16),
(198, 'img/1661298633_187-1.jpg', 'perfilapp', 0, 20),
(199, 'img/1661298645_187-1.jpg', 'promoweb', 0, 20),
(200, 'img/1661298656_187-1.jpg', 'logoweb', 0, 20),
(201, 'img/1661299036_258-1.jpg', 'perfilapp', 0, 32),
(202, 'img/1661299050_258-1.jpg', 'promoweb', 0, 32),
(203, 'img/1661299063_258-1.jpg', 'logoweb', 0, 32),
(204, 'img/1661299182_273-1.jpg', 'perfilapp', 0, 35),
(205, 'img/1661299193_273-1.jpg', 'promoweb', 0, 35),
(206, 'img/1661299204_273-1.jpg', 'logoweb', 0, 35),
(207, 'img/1661299416_507-1.jpg', 'perfilapp', 0, 126),
(208, 'img/1661299431_507-1.jpg', 'promoweb', 0, 126),
(209, 'img/1661299455_507-1.jpg', 'logoweb', 0, 126),
(210, 'img/1661299569_583-1.jpg', 'perfilapp', 0, 162),
(211, 'img/1661299584_583-1.jpg', 'promoweb', 0, 162),
(212, 'img/1661299594_583-1.jpg', 'logoweb', 0, 162),
(213, 'img/1661299659_318-1.jpg', 'logoweb', 0, 49),
(214, 'img/1661299679_318-1.jpg', 'perfilapp', 0, 49),
(215, 'img/1661299714_319-1.jpg', 'perfilapp', 0, 50),
(216, 'img/1661299723_319-1.jpg', 'logoweb', 0, 50),
(217, 'img/1661299772_606-1.jpg', 'perfilapp', 0, 175),
(218, 'img/1661299790_606-1.jpg', 'promoweb', 0, 175),
(219, 'img/1661299807_606-1.jpg', 'perfilapp', 0, 175),
(220, 'img/1661299833_606-1.jpg', 'logoweb', 0, 175),
(221, 'img/1661299877_609-1.jpg', 'perfilapp', 0, 177),
(222, 'img/1661299889_609-1.jpg', 'promoweb', 0, 177),
(223, 'img/1661299900_609-1.jpg', 'logoweb', 0, 177),
(224, 'img/1661299965_641-1.jpg', 'promoweb', 0, 199),
(225, 'img/1661300036_668-1.jpg', 'perfilapp', 0, 221),
(226, 'img/1661300047_668-1.jpg', 'promoweb', 0, 221),
(227, 'img/1661300057_668-1.jpg', 'logoweb', 0, 221),
(228, 'img/1661300130_758-1.jpg', 'perfilapp', 0, 302),
(229, 'img/1661300144_758-1.jpg', 'promoweb', 0, 302),
(230, 'img/1661300169_758-1.jpg', 'logoweb', 0, 302),
(231, 'img/1661300458_762-1.jpg', 'perfilapp', 0, 307),
(232, 'img/1661300472_762-1.jpg', 'promoweb', 0, 307),
(233, 'img/1661300485_762-1.jpg', 'logoweb', 0, 307),
(235, 'img/1661300545_770-1.jpg', 'promoweb', 0, 316),
(236, 'img/1661300563_770-1.jpg', 'logoweb', 0, 316),
(237, 'img/1661300579_770-1.jpg', 'perfilapp', 0, 316),
(238, 'img/1661300626_781-1.jpg', 'perfilapp', 0, 327),
(239, 'img/1661300637_781-1.jpg', 'promoweb', 0, 327),
(240, 'img/1661300647_781-1.jpg', 'logoweb', 0, 327),
(241, 'img/1661300744_782-1.jpg', 'perfilapp', 0, 328),
(242, 'img/1661300755_782-1.jpg', 'promoweb', 0, 328),
(243, 'img/1661300766_782-1.jpg', 'logoweb', 0, 328),
(244, 'img/1661306393_15-1.jpg', 'perfilapp', 0, 10),
(252, '../circuloAfiliado/img/1663650622_15-1.jpg', 'perfilapp', NULL, 199),
(253, '../circuloAfiliado/img/1663650733_668-1.jpg', 'perfilweb', NULL, 199);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `img_promo`
--

CREATE TABLE `img_promo` (
  `id` int(11) NOT NULL,
  `codigo_promo` int(11) NOT NULL,
  `id_img` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `img_promo`
--

INSERT INTO `img_promo` (`id`, `codigo_promo`, `id_img`) VALUES
(1, 2, 31),
(2, 2, 32),
(3, 3, 33),
(4, 3, 52),
(5, 3, 54),
(6, 4, 55),
(7, 4, 32),
(13, 5, 54),
(14, 4, 31),
(16, 5, 32),
(17, 6, 32),
(18, 7, 34),
(19, 7, 34),
(20, 7, 31),
(21, 7, 31),
(22, 7, 31),
(23, 8, 31),
(24, 8, 32),
(25, 12, 31),
(26, 12, 32),
(27, 12, 33),
(28, 13, 33),
(29, 14, 31),
(30, 15, 31),
(31, 15, 32),
(32, 16, 34),
(33, 16, 33),
(35, 17, 31),
(36, 17, 32),
(37, 17, 33),
(38, 18, 31),
(39, 18, 32),
(40, 19, 31),
(41, 19, 32),
(42, 20, 31),
(43, 20, 32),
(44, 20, 34),
(45, 20, 32),
(46, 21, 31),
(47, 22, 92),
(49, 23, 112),
(50, 24, 112),
(51, 25, 111),
(52, 26, 111),
(53, 27, 111),
(54, 0, 31),
(55, 0, 31),
(56, 0, 31),
(57, 0, 31),
(58, 1, 34),
(59, 1, 32),
(60, 1, 33),
(61, 1, 33),
(62, 1, 34),
(63, 1, 34),
(64, 1152, 34),
(65, 1152, 31),
(66, 3, 31),
(67, 3, 32),
(69, 1143, 123),
(70, 86, 124),
(71, 86, 125),
(73, 1154, 124),
(74, 1154, 125),
(75, 1154, 123),
(76, 88, 130),
(77, 263, 134),
(78, 302, 136),
(79, 378, 142),
(80, 930, 144),
(81, 419, 148),
(82, 447, 149),
(83, 573, 154),
(84, 551, 154),
(85, 821, 156),
(86, 850, 160),
(87, 849, 160),
(88, 905, 163),
(89, 926, 167),
(90, 927, 167),
(91, 940, 170),
(92, 969, 173),
(93, 1015, 176),
(94, 1146, 179),
(95, 1069, 179),
(96, 410, 182),
(97, 1236, 182),
(98, 1235, 182),
(99, 906, 184),
(100, 56, 184),
(102, 12, 190),
(103, 64, 193),
(104, 86, 123),
(105, 118, 123),
(106, 1172, 123),
(107, 621, 196),
(108, 198, 196),
(109, 253, 199),
(110, 1155, 202),
(111, 1220, 202),
(112, 360, 202),
(113, 379, 205),
(114, 1142, 119),
(115, 1237, 119),
(116, 1238, 119),
(117, 1239, 119),
(118, 1240, 119),
(119, 445, 119),
(120, 664, 208),
(121, 802, 211),
(122, 832, 218),
(123, 1148, 218),
(124, 1147, 222),
(125, 836, 222),
(126, 839, 222),
(127, 900, 224),
(128, 1175, 224),
(129, 934, 226),
(130, 1071, 229),
(131, 1084, 232),
(132, 1099, 235),
(133, 1223, 239),
(134, 1126, 242),
(135, 49, 187),
(136, 666, 187),
(137, 667, 187),
(138, 668, 187),
(139, 669, 187),
(140, 1155, 123),
(141, 1156, 123);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `municipios`
--

CREATE TABLE `municipios` (
  `id_municipio` int(11) NOT NULL,
  `Clave` varchar(50) DEFAULT NULL,
  `Descripcion` varchar(50) DEFAULT NULL,
  `Estado` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `municipios`
--

INSERT INTO `municipios` (`id_municipio`, `Clave`, `Descripcion`, `Estado`) VALUES
(1, 'AGS                 ', 'AGUASCALIENTES', 'AGS                 '),
(2, 'EMIZAPATA           ', 'EMILIANO ZAPATA', 'AGS                 '),
(3, 'JMAR                ', 'JESUS MARIA', 'AGS                 '),
(4, 'MIGHGO              ', 'MIGUEL HIDALGO', 'AGS                 '),
(5, 'PABELLONDE          ', 'PABELLON DE ARTEAGA', 'AGS                 '),
(6, 'SANFRANCIS          ', 'SAN FRANCISCO DE LOS ROMO', 'AGS                 '),
(7, 'SANFRO              ', 'SAN FRANCISCO DE LOS ROMO', 'AGS                 '),
(8, 'SFDR                ', 'SAN FRANCISCO DE LOS ROMO', 'AGS                 '),
(9, 'SPO                 ', 'SAN PEDRO', 'AGS                 '),
(10, 'TLAX                ', 'TLAXCALA', 'AMAXAC              '),
(11, 'ENSE                ', 'ENSENADA', 'BCN                 '),
(12, 'LAM                 ', 'LA MESA', 'BCN                 '),
(13, 'MEXI                ', 'MEXICALI', 'BCN                 '),
(14, 'RSA                 ', 'ROSARITO', 'BCN                 '),
(15, 'SANFELIPE           ', 'SAN FELIPE', 'BCN                 '),
(16, 'TECAT               ', 'TECATE', 'BCN                 '),
(17, 'TIJ                 ', 'TIJUANA', 'BCN                 '),
(18, 'TJNA                ', 'TIJUANA', 'BCNN                '),
(19, 'CDCONSTI            ', 'CIUDAD CONSTITUCION', 'BCS                 '),
(20, 'CONSTI              ', 'CONSTITUCION', 'BCS                 '),
(21, 'CSL                 ', 'CABO SAN LUCAS', 'BCS                 '),
(22, 'GNEGRO              ', 'GUERRERO NEGRO', 'BCS                 '),
(23, 'LCABOS              ', 'LOS CABOS', 'BCS                 '),
(24, 'LORETO              ', 'LORETO', 'BCS                 '),
(25, 'LP                  ', 'LA PAZ', 'BCS                 '),
(26, 'SNJCABO             ', 'SAN JOSE DEL CABO', 'BCS                 '),
(27, 'STAROSALIA          ', 'SANTA ROSALIA', 'BCS                 '),
(28, 'TS                  ', 'TODOS SANTOS', 'BCS                 '),
(29, 'CAMPCHE             ', 'CAMPECHE', 'CAM                 '),
(30, 'CDDELC              ', 'CIUDAD DEL CARMEN', 'CAM                 '),
(31, 'CHAMPTON            ', 'CHAMPOTON', 'CAM                 '),
(32, 'ESCRCEGA            ', 'ESCARCEGA', 'CAM                 '),
(33, 'PALIZ               ', 'PALIZADA', 'CAM                 '),
(34, 'SN FCO DE           ', 'SAN FRANCISCO DE CAMPECHE', 'CAM                 '),
(35, 'CDMEXM              ', 'CIUDAD DE MÉXICO', 'CDMEX               '),
(36, 'CDVC                ', 'VENUSTIANO CARRANZA', 'CDMEX               '),
(37, 'CUAHUCDM            ', 'ALCALDÍA CUAUHTÉMOC', 'CDMEX               '),
(38, 'NDM                 ', 'NAUCALPAN DE JUAREZ', 'CDMEX               '),
(39, 'ASC                 ', 'ASCENSION', 'CHIHUAHUA           '),
(40, 'CAMRGO              ', 'CD. CAMARGO', 'CHIHUAHUA           '),
(41, 'CDGUE               ', 'CD GUERRERO', 'CHIHUAHUA           '),
(42, 'CDJ                 ', 'CD. JUAREZ', 'CHIHUAHUA           '),
(43, 'CHIHUAHUA           ', 'CHIHUAHUA', 'CHIHUAHUA           '),
(44, 'CJI                 ', 'Ciudad Jimenez', 'CHIHUAHUA           '),
(45, 'CORONADONB          ', 'CORONADO NICOLAS BRAVO', 'CHIHUAHUA           '),
(46, 'CUAUHTEM            ', 'CD. CUAUHTEMOC', 'CHIHUAHUA           '),
(47, 'CUAUHTEMOC          ', 'CUAUHTEMOC', 'CHIHUAHUA           '),
(48, 'DELI                ', 'DELICIAS', 'CHIHUAHUA           '),
(49, 'DELICIAS            ', 'CIUDAD DELICIAS', 'CHIHUAHUA           '),
(50, 'HGODLPARRL          ', 'HIDALGO DEL PARRAL', 'CHIHUAHUA           '),
(51, 'JIMENEZ             ', 'CD. JIMENEZ', 'CHIHUAHUA           '),
(52, 'MADERA              ', 'CD. MADERA', 'CHIHUAHUA           '),
(53, 'NVOCSGDES           ', 'NUEVO CASAS GRANDES', 'CHIHUAHUA           '),
(54, 'OJINAGA             ', 'OJINAGA', 'CHIHUAHUA           '),
(55, 'PPAL                ', 'PUERTO PALOMAS', 'CHIHUAHUA           '),
(56, 'PRL                 ', 'PARRAL', 'CHIHUAHUA           '),
(57, 'ROSALES             ', 'ROSALES', 'CHIHUAHUA           '),
(58, 'SNFCODLORO          ', 'SAN FRANCISCO DEL ORO', 'CHIHUAHUA           '),
(59, 'STABARBARA          ', 'SANTA BARBARA', 'CHIHUAHUA           '),
(60, 'ARRIAGA             ', 'ARRIAGA', 'CHS                 '),
(61, 'CACHOATAN           ', 'CACAHOATAN', 'CHS                 '),
(62, 'CINTALAPA           ', 'CINTALAPA', 'CHS                 '),
(63, 'COMITAN             ', 'COMITAN', 'CHS                 '),
(64, 'HUIXTLA             ', 'HUIXTLA', 'CHS                 '),
(65, 'PARRAL              ', 'PARRAL', 'CHS                 '),
(66, 'PICHUCLC            ', 'PICHUCALCO', 'CHS                 '),
(67, 'SNCDLC              ', 'SAN CRISTOBAL DE LAS CASAS', 'CHS                 '),
(68, 'TCH                 ', 'TAPACHULA', 'CHS                 '),
(69, 'TUXGTZ              ', 'TUXTLA GUTIERREZ', 'CHS                 '),
(70, 'TUXTLA              ', 'TUXTLA', 'CHS                 '),
(71, 'VILLFLORE           ', 'VILLAFLORES', 'CHS                 '),
(72, 'ALCALVA             ', 'ALCALDÍA ALVARO OBREGON', 'CIMEX               '),
(73, 'DELEGACIONALVARO    ', 'DELEGACION ALVARO OBREGON', 'CIMEX               '),
(74, 'DELMG               ', 'DELEGACION MIGUEL HIDALGO', 'CIMEX               '),
(75, 'ACU                 ', 'ACUÑA', 'COAH                '),
(76, 'ALLENDE             ', 'ALLENDE', 'COAH                '),
(77, 'CASTAÑ              ', 'CASTAÑOS', 'COAH                '),
(78, 'CFRONTERA           ', 'CIUDAD FRONTERA', 'COAH                '),
(79, 'COAHUI              ', 'COAHUILA', 'COAH                '),
(80, 'COAUDEZA            ', 'COAHUILA DE ZARAGAZA', 'COAH                '),
(81, 'FCOMA               ', 'FRANCISCO I MADERO', 'COAH                '),
(82, 'FRO                 ', 'FRONTERA', 'COAH                '),
(83, 'MONCLO              ', 'MONCLOVA', 'COAH                '),
(84, 'MUZQUIZ             ', 'MUZQUIZ', 'COAH                '),
(85, 'NVAROSITA           ', 'NUEVA ROSITA', 'COAH                '),
(86, 'PARRAS              ', 'PARRAS', 'COAH                '),
(87, 'PEDRO               ', 'SAN PEDRO', 'COAH                '),
(88, 'PIEDRAS             ', 'PIEDRAS NEGRAS', 'COAH                '),
(89, 'PROGRE              ', 'PROGRESO', 'COAH                '),
(90, 'RAMOS               ', 'RAMOS ARIZPE', 'COAH                '),
(91, 'SABNAS              ', 'SABINAS', 'COAH                '),
(92, 'SALTILLO            ', 'SALTILLO', 'COAH                '),
(93, 'TORREON             ', 'TORREON', 'COAH                '),
(94, 'ZRAGZA              ', 'ZARAGOZA', 'COAH                '),
(95, 'ARM                 ', 'ARMERIA', 'COL                 '),
(96, 'CCUA                ', 'CIUDAD CUAHUTEMOC', 'COL                 '),
(97, 'COLIMA              ', 'COLIMA', 'COL                 '),
(98, 'COMA                ', 'COMALA', 'COL                 '),
(99, 'COQUI               ', 'COQUIMATLAN', 'COL                 '),
(100, 'CUY                 ', 'CUYUTLAN', 'COL                 '),
(101, 'MANZANILLO          ', 'MANZANILLO', 'COL                 '),
(102, 'QUES                ', 'QUESERIA', 'COL                 '),
(103, 'SALA                ', 'SALAGUA', 'COL                 '),
(104, 'SALAH               ', 'SALAHUA', 'COL                 '),
(105, 'SANT                ', 'SANTIAGO', 'COL                 '),
(106, 'SANTIA              ', 'SANTIAGO', 'COL                 '),
(107, 'SANTIAGO            ', 'SANTIAGO', 'COL                 '),
(108, 'SNCOMALA            ', 'SAN ANTONIO COMALA', 'COL                 '),
(109, 'TECOMAN             ', 'TECOMAN', 'COL                 '),
(110, 'TRA                 ', 'EL TRAPICHE', 'COL                 '),
(111, 'VIAL                ', 'VILLA DE ALVAREZ', 'COL                 '),
(112, 'VILLA               ', 'VILLA DE ALVAREZ', 'COL                 '),
(113, 'ALVOBR              ', 'ALVARO OBREGON', 'D.F.                '),
(114, 'ATOYACDF            ', 'ATOYAC', 'D.F.                '),
(115, 'BENITO              ', 'BENITO JUAREZ', 'D.F.                '),
(116, 'CDMX                ', 'CIUDAD DE MEXICO', 'D.F.                '),
(117, 'CHAPULTEPEC         ', 'CHAPULTEPEC', 'D.F.                '),
(118, 'CHU                 ', 'CHURUBUSCO', 'D.F.                '),
(119, 'COA                 ', 'COAPA', 'D.F.                '),
(120, 'COYACAN             ', 'COYOACAN', 'D.F.                '),
(121, 'CUAJI               ', 'CUAJIMALPA DE MORELOS', 'D.F.                '),
(122, 'CUAJIMALPA          ', 'CUAJIMALPA', 'D.F.                '),
(123, 'DELALVA             ', 'DELEGACION ALVARO OBREGON', 'D.F.                '),
(124, 'DELBENITOJ          ', 'DELEGACION BENITO JUAREZ', 'D.F.                '),
(125, 'DELCOYO             ', 'DELEGACION COYOACAN', 'D.F.                '),
(126, 'DELCUA              ', 'DELEGACION CUAJIMALPA DE MORELOS', 'D.F.                '),
(127, 'DELCUAJ             ', 'DELEGACION CUAJIMALPA', 'D.F.                '),
(128, 'DELCUAU             ', 'DELEGACION CUAUHTEMOC', 'D.F.                '),
(129, 'DELEAZCA            ', 'DELEGACION AZCAPOTZALCO', 'D.F.                '),
(130, 'DELECA              ', 'DELEGACION ECATEPEC', 'D.F.                '),
(131, 'DELGUSTA            ', 'DELEGACION GUSTAVO A. MADERO', 'D.F.                '),
(132, 'DELIZTA             ', 'DELEGACION IZTAPALAPA', 'D.F.                '),
(133, 'DELIZTAC            ', 'DELEGACION IZTACALCO', 'D.F.                '),
(134, 'DELMAG              ', 'DELEGACION LA MAGDALENA CONTRERAS', 'D.F.                '),
(135, 'DELMH               ', 'DEL.MIGUEL HIDALGO', 'D.F.                '),
(136, 'DELMIX              ', 'DELEGACION MIXCOAC', 'D.F.                '),
(137, 'DELTL               ', 'DELEGACION TLALNEPANTLA', 'D.F.                '),
(138, 'DELTLAL             ', 'DELEG. TLALPAN', 'D.F.                '),
(139, 'DELVEN              ', 'DELEGACION VENUSTIANO CARRANZA', 'D.F.                '),
(140, 'DELXOCH             ', 'DELEGACION XOCHIMILCO', 'D.F.                '),
(141, 'DETLAH              ', 'DELEGACION TLAHUAC', 'D.F.                '),
(142, 'DFMPIO              ', 'DISTRITO FEDERAL', 'D.F.                '),
(143, 'DMALTA              ', 'DELEGACION MILPA ALTA', 'D.F.                '),
(144, 'IXT                 ', 'IZTAPALAPA', 'D.F.                '),
(145, 'IZTAC               ', 'IZTACALCO', 'D.F.                '),
(146, 'IZTAPALAPA          ', 'IZTAPALAPA', 'D.F.                '),
(147, 'MEXICO              ', 'MEXICO', 'D.F.                '),
(148, 'NAUC                ', 'NAUCALPAN', 'D.F.                '),
(149, 'SNFCO               ', 'SAN FRANCISCO TEPOJACO', 'D.F.                '),
(150, 'SPTEPETLAPA         ', 'SAN PABLO TEPETLAPA', 'D.F.                '),
(151, 'TSA                 ', 'TIZAPAN SAN ANGEL', 'D.F.                '),
(152, 'XALOS               ', 'XALOSTOC', 'D.F.                '),
(153, 'XOCHIMLCO           ', 'XOCHIMILCO', 'D.F.                '),
(154, 'DURAN               ', 'DURANGO', 'DGO                 '),
(155, 'DURANGO             ', 'VICTORIA DE DURANGO', 'DGO                 '),
(156, 'GMZPAL              ', 'GOMEZ PALACIO', 'DGO                 '),
(157, 'JOYA                ', 'LA JOYA', 'DGO                 '),
(158, 'LDO                 ', 'LERDO', 'DGO                 '),
(159, 'SGOPAP              ', 'SANTIAGO PAPASQUIARO', 'DGO                 '),
(160, 'VICEN               ', 'VICENTE GUERRERO', 'DGO                 '),
(161, 'CUAUH               ', 'CUAUHTEMOC', 'DISTRITOF           '),
(162, 'DISTRITOFEDE        ', 'DELEGACION CUAJIMALPA DE MORELOS', 'DISTRITOF           '),
(163, 'ATIZ                ', 'VALLE DE CHALCO SOLIDARIDAD', 'EM                  '),
(164, 'ATIZDEZAR           ', 'ATIZAPAN DE ZARAGOZA', 'EM                  '),
(165, 'ATLACO              ', 'ATLACOMULCO', 'EM                  '),
(166, 'AYUCA               ', 'AYUCA', 'EM                  '),
(167, 'AZCAPOT             ', 'AZCAPOTZALCO', 'EM                  '),
(168, 'CAC                 ', 'CACALOMACAN', 'EM                  '),
(169, 'CAPHU               ', 'CAPULHUAC', 'EM                  '),
(170, 'CDSATELITE          ', 'CIUDAD SATELITE', 'EM                  '),
(171, 'CHALCO              ', 'CHALCO', 'EM                  '),
(172, 'CHIAUTLA            ', 'CHIAUTLA', 'EM                  '),
(173, 'CHICO               ', 'CHICOLOAPAN', 'EM                  '),
(174, 'CHIM                ', 'CHIMALHUACAN', 'EM                  '),
(175, 'COACAL              ', 'COACALCO DE BERRIOZABAL', 'EM                  '),
(176, 'COACALCO            ', 'COACALCO', 'EM                  '),
(177, 'COYOA               ', 'COYOACAN', 'EM                  '),
(178, 'CTMCULHUA           ', 'CTM CULHUACAN', 'EM                  '),
(179, 'CUAJIMALPADEMO      ', 'CUAJIMALPA DE MORELOS', 'EM                  '),
(180, 'CUAUITZC            ', 'CUAUTITLAN IZCALLI', 'EM                  '),
(181, 'CUAUTIT             ', 'CUAUTITLAN', 'EM                  '),
(182, 'DECUAH              ', 'DELEGACION CUAUHTEMOC', 'EM                  '),
(183, 'ECAT                ', 'ECATEPEC', 'EM                  '),
(184, 'EM                  ', 'ESTADO DE MEXICO', 'EM                  '),
(185, 'HUE                 ', 'HUEHUETOCA', 'EM                  '),
(186, 'HUEH                ', 'HUEHUETOCA', 'EM                  '),
(187, 'HUIX                ', 'HUIXQUILUCAN', 'EM                  '),
(188, 'IXTAPAL             ', 'IXTAPALAPA', 'EM                  '),
(189, 'IXTAPALU            ', 'IXTAPALUCA', 'EM                  '),
(190, 'IXTDLSAL            ', 'IXTAPAN DE LA SAL', 'EM                  '),
(191, 'IZC                 ', 'IZCALLI', 'EM                  '),
(192, 'JIL                 ', 'JILOTEPEC', 'EM                  '),
(193, 'JOCOTITLAN          ', 'JOCOTITLAN', 'EM                  '),
(194, 'LERM                ', 'LERMA', 'EM                  '),
(195, 'LERMA               ', 'LERMA DE VILLADA', 'EM                  '),
(196, 'LPAZ                ', 'LA PAZ', 'EM                  '),
(197, 'LREYPAZ             ', 'LOS REYES LA PAZ', 'EM                  '),
(198, 'MANAYA              ', 'M. ANAYA', 'EM                  '),
(199, 'MELCHOR             ', 'MELCHOR OCAMPO', 'EM                  '),
(200, 'MET                 ', 'METEPEC', 'EM                  '),
(201, 'NAJ                 ', 'NAUCALPAN DE JUAREZ', 'EM                  '),
(202, 'NAU                 ', 'NAUCALPAN', 'EM                  '),
(203, 'NAUCAL              ', 'NAUCALLI', 'EM                  '),
(204, 'NETZAHUAL           ', 'NETZAHUALCOYOTL', 'EM                  '),
(205, 'NEXTLANPAN          ', 'NEXTLALPAN', 'EM                  '),
(206, 'NEZA                ', 'NEZA', 'EM                  '),
(207, 'NEZAH               ', 'NEZAHUALCOYOTL', 'EM                  '),
(208, 'NOP                 ', 'DELEGACION NOPALTEPEC', 'EM                  '),
(209, 'NROMERO             ', 'DELEG. NICOLAS ROMERO', 'EM                  '),
(210, 'OCOY                ', 'OCOYOACAC', 'EM                  '),
(211, 'ORO                 ', 'EL ORO', 'EM                  '),
(212, 'OTUMBA              ', 'OTUMBA', 'EM                  '),
(213, 'SMATE               ', 'SAN MATEO ATENCO', 'EM                  '),
(214, 'SMOT                ', 'SAN MATEO OTZACATIPAN', 'EM                  '),
(215, 'SNVICENT            ', 'SAN VICENTE CHICOLOAPAN', 'EM                  '),
(216, 'STAMONICA           ', 'SANTA MONICA', 'EM                  '),
(217, 'TAC                 ', 'TEMASCALTEPEC', 'EM                  '),
(218, 'TB                  ', 'TLALNEPANTLA DE BAZ', 'EM                  '),
(219, 'TDELERDO            ', 'TOLUCA DE LERDO', 'EM                  '),
(220, 'TECAM               ', 'TECAMAC', 'EM                  '),
(221, 'TEOLOYUCAN          ', 'TEOLOYUCAN', 'EM                  '),
(222, 'TEPO                ', 'TEPOTZOTLAN', 'EM                  '),
(223, 'TEQUISISTLAN        ', 'TEQUISISTLAN', 'EM                  '),
(224, 'TEQUIXQUIAC         ', 'TEQUIXQUIAC', 'EM                  '),
(225, 'TEXC                ', 'TEXCOCO', 'EM                  '),
(226, 'TIZSNANGL           ', 'TIZAPAN SAN ANGEL', 'EM                  '),
(227, 'TL                  ', 'TLALNEPANTLA', 'EM                  '),
(228, 'TLALM               ', 'TLALMANALCO', 'EM                  '),
(229, 'TLB                 ', 'TLALNEPANTLA DE BAZ', 'EM                  '),
(230, 'TOLUCA              ', 'TOLUCA', 'EM                  '),
(231, 'TRALMA              ', 'TRALMANALCO', 'EM                  '),
(232, 'TUL                 ', 'TULTITLAN', 'EM                  '),
(233, 'TULTIMARIA          ', 'TULTITLAN DE MARIANO', 'EM                  '),
(234, 'TULTITLAN           ', 'TULTITLAN', 'EM                  '),
(235, 'VALBRAVO            ', 'VALLE DE BRAVO', 'EM                  '),
(236, 'XATC                ', 'XALOSTOC', 'EM                  '),
(237, 'XINA                ', 'ZINACANTEPEC', 'EM                  '),
(238, 'ZUM                 ', 'ZUMPANGO', 'EM                  '),
(239, 'ACAJUA              ', 'ACAPULCO DE JUAREZ', 'GRO                 '),
(240, 'ACAPULCO            ', 'ACAPULCO', 'GRO                 '),
(241, 'ARCE                ', 'ARCELIA', 'GRO                 '),
(242, 'CDALTAMIRN          ', 'CIUDAD ALTAMIRANO', 'GRO                 '),
(243, 'CHIL                ', 'CHILPANCINGO DE LOS BRAVOS', 'GRO                 '),
(244, 'CHILAPA             ', 'CHILAPA', 'GRO                 '),
(245, 'CHILPANCINGO        ', 'CHILPANCINGO', 'GRO                 '),
(246, 'COYUCAG             ', 'COYUCA DE CATALAN', 'GRO                 '),
(247, 'IGUALA              ', 'IGUALA', 'GRO                 '),
(248, 'IXTZIHUA            ', 'IXTAPA ZIHUATANEJO', 'GRO                 '),
(249, 'MARQUES             ', 'EL MARQUES', 'GRO                 '),
(250, 'PANTLA              ', 'PANTLA', 'GRO                 '),
(251, 'TAX                 ', 'TAXCO DE ALARCON', 'GRO                 '),
(252, 'TAXCO               ', 'TAXCO', 'GRO                 '),
(253, 'ZIHUA               ', 'ZIHUATANEJO', 'GRO                 '),
(254, 'ACAMBAR             ', 'ACAMBARO', 'GTO                 '),
(255, 'ALDAMAS             ', 'LEON DE LOS ALDAMAS', 'GTO                 '),
(256, 'ANA                 ', 'SANTA ANA PACUECO', 'GTO                 '),
(257, 'APASEO              ', 'APASEO EL ALTO', 'GTO                 '),
(258, 'CELAYA              ', 'CELAYA', 'GTO                 '),
(259, 'CORTAZ              ', 'CORTAZAR', 'GTO                 '),
(260, 'DLSHGO              ', 'DOLORES HIDALGO', 'GTO                 '),
(261, 'GUANAJUATO          ', 'GUANAJUATO', 'GTO                 '),
(262, 'IPTO                ', 'IRAPUATO', 'GTO                 '),
(263, 'LABOR               ', 'LA LABOR', 'GTO                 '),
(264, 'LEON                ', 'LEON', 'GTO                 '),
(265, 'MORLEON             ', 'MOROLEON', 'GTO                 '),
(266, 'PDRI                ', 'PURISIMA DEL RINCON', 'GTO                 '),
(267, 'PENJAMO             ', 'PENJAMO', 'GTO                 '),
(268, 'ROMITA              ', 'ROMITA', 'GTO                 '),
(269, 'SAL                 ', 'SALAMANCA', 'GTO                 '),
(270, 'SALVTIERR           ', 'SALVATIERRA', 'GTO                 '),
(271, 'SANF                ', 'SAN FELIPE', 'GTO                 '),
(272, 'SANTACLARA          ', 'SANTA CLARA', 'GTO                 '),
(273, 'SFCOR               ', 'SAN FRANCISCO DEL RINCON', 'GTO                 '),
(274, 'SILAO               ', 'SILAO', 'GTO                 '),
(275, 'SNJI                ', 'SAN JOSE ITURBIDE', 'GTO                 '),
(276, 'SNLDLPZ             ', 'SAN LUIS DE LA PAZ', 'GTO                 '),
(277, 'SNMDALLDE           ', 'SAN MIGUEL DE ALLENDE', 'GTO                 '),
(278, 'TARIMORO            ', 'TARIMORO', 'GTO                 '),
(279, 'URI                 ', 'URIANGATO', 'GTO                 '),
(280, 'APAN                ', 'APAN', 'HGO                 '),
(281, 'AT                  ', 'ATOTONILCO DE TULA', 'HGO                 '),
(282, 'ATI                 ', 'ATITALAQUIA', 'HGO                 '),
(283, 'CDSAHAGUN           ', 'CIUDAD SAHAGUN', 'HGO                 '),
(284, 'CUAHINO             ', 'CUAUTEPEC DE HINOJOSA', 'HGO                 '),
(285, 'EMZA                ', 'EMILIANO ZAPATA', 'HGO                 '),
(286, 'FRAY                ', 'CIUDAD FRAY BERNARDINO DE SAHAGUN', 'HGO                 '),
(287, 'HUEJU               ', 'HUEJUTLA', 'HGO                 '),
(288, 'HUIC                ', 'HUICHAPAN', 'HGO                 '),
(289, 'IXMI                ', 'IXMIQUILPAN', 'HGO                 '),
(290, 'MINREFORMA          ', 'MINERAL DE LA REFORMA', 'HGO                 '),
(291, 'PACHUCA             ', 'PACHUCA', 'HGO                 '),
(292, 'SALVADOR            ', 'SAN SALVADOR', 'HGO                 '),
(293, 'SANSEB              ', 'SAN SEBASTIAN TENOCHTITLAN', 'HGO                 '),
(294, 'TDALL               ', 'TULA DE ALLENDE', 'HGO                 '),
(295, 'TEPEA               ', 'TEPEAPULCO HIDALGO', 'HGO                 '),
(296, 'TEPEJI              ', 'TEPEJI DEL RIO', 'HGO                 '),
(297, 'TEPOJACO            ', 'TEPOJACO', 'HGO                 '),
(298, 'TIZAYUCA            ', 'TIZAYUCA', 'HGO                 '),
(299, 'TOLCAYUCA           ', 'TOLCAYUCA', 'HGO                 '),
(300, 'TULABRA             ', 'TULANCINGO DE BRAVO', 'HGO                 '),
(301, 'TULAN               ', 'TULANCINGO', 'HGO                 '),
(302, 'ACA                 ', 'ACATIC', 'JAL                 '),
(303, 'ACJ                 ', 'ACATLAN DE JUAREZ', 'JAL                 '),
(304, 'AGUIL               ', 'LAS AGUILILLAS', 'JAL                 '),
(305, 'AHM                 ', 'AHUALULCO DE MERCADO', 'JAL                 '),
(306, 'AHUAL               ', 'AHUALULCO', 'JAL                 '),
(307, 'AJIJIC              ', 'AJIJIC', 'JAL                 '),
(308, 'ALTOS               ', 'LOS ALTOS', 'JAL                 '),
(309, 'AMA                 ', 'AMACUECA', 'JAL                 '),
(310, 'AMC                 ', 'AMECA', 'JAL                 '),
(311, 'AMT                 ', 'AMATITAN', 'JAL                 '),
(312, 'ARA                 ', 'ARANDAS', 'JAL                 '),
(313, 'ARE                 ', 'EL ARENAL', 'JAL                 '),
(314, 'AREN                ', 'ARENAL', 'JAL                 '),
(315, 'ATA                 ', 'ATOTONILCO EL ALTO', 'JAL                 '),
(316, 'ATB                 ', 'ATEMAJAC DE BRIZUELA', 'JAL                 '),
(317, 'ATE                 ', 'ATEQUIZA', 'JAL                 '),
(318, 'ATG                 ', 'ATENGO', 'JAL                 '),
(319, 'ATN                 ', 'ATENGUILLO', 'JAL                 '),
(320, 'ATOTO               ', 'ATOTONILQUILLO', 'JAL                 '),
(321, 'ATQ                 ', 'ATENQUIQUE', 'JAL                 '),
(322, 'ATY                 ', 'ATOYAC', 'JAL                 '),
(323, 'AUTLAN              ', 'AUTLAN', 'JAL                 '),
(324, 'AUTNAV              ', 'AUTLAN DE NAVARRO ', 'JAL                 '),
(325, 'AYO                 ', 'AYOTLAN', 'JAL                 '),
(326, 'AYU                 ', 'AYUTLA', 'JAL                 '),
(327, 'BCA                 ', 'LA BARCA', 'JAL                 '),
(328, 'BELLA               ', 'BELLAVISTA', 'JAL                 '),
(329, 'BNAV                ', 'BARRA DE NAVIDAD', 'JAL                 '),
(330, 'BOL                 ', 'BOLAÑOS', 'JAL                 '),
(331, 'CAJI                ', 'CAJITITLAN', 'JAL                 '),
(332, 'CAP                 ', 'CAPILLA DE GUADALUPE', 'JAL                 '),
(333, 'CAPDGPE             ', 'CAPILLA DE GUADALUPE', 'JAL                 '),
(334, 'CAPILLA DE MILPILLAS', 'CAPILLA DE MILPILLAS', 'JAL                 '),
(335, 'CBA                 ', 'CONCEPCIÓN DE BUENOS AIRES', 'JAL                 '),
(336, 'CCA                 ', 'CASIMIRO CASTILLO', 'JAL                 '),
(337, 'CCO                 ', 'CABO CORRIENTES', 'JAL                 '),
(338, 'CDGUZ               ', 'CIUDAD GUZMAN', 'JAL                 '),
(339, 'CERRO               ', 'CERRO GORDO', 'JAL                 '),
(340, 'CERROGORDO          ', 'SAN IGNACIO CERRO GORDO ', 'JAL                 '),
(341, 'CG                  ', 'CIUDAD GUZMAN', 'JAL                 '),
(342, 'CGUZMAN             ', 'CIUDAD GUZMAN', 'JAL                 '),
(343, 'CH                  ', 'CHIMALTITAN', 'JAL                 '),
(344, 'CHAP                ', 'CHAPALA', 'JAL                 '),
(345, 'CHICHIMECO          ', 'CHICHIMECO', 'JAL                 '),
(346, 'CHIMAL              ', 'CHIMALTITAN', 'JAL                 '),
(347, 'CHIQ                ', 'CHIQUILISTLAN', 'JAL                 '),
(348, 'CIH                 ', 'CIHUATLAN', 'JAL                 '),
(349, 'CO                  ', 'CAÑADAS DE OBREGÓN', 'JAL                 '),
(350, 'COC                 ', 'COCULA', 'JAL                 '),
(351, 'COL                 ', 'COLOTLAN', 'JAL                 '),
(352, 'CONSEBUENOS AIRES   ', 'CONCEPCION DE BUENOS AIRES', 'JAL                 '),
(353, 'CRUDSTAMA           ', 'CRUCERO DE SANTA MARIA', 'JAL                 '),
(354, 'CUA                 ', 'CUAUTITLAN', 'JAL                 '),
(355, 'CUAGARCIA           ', 'CUAUTITLAN DE GARCIA BARRAGAN', 'JAL                 '),
(356, 'CUE                 ', 'CUEXCOMATITLAN', 'JAL                 '),
(357, 'CUQ                 ', 'CUQUIO', 'JAL                 '),
(358, 'CUYU                ', 'CUYUTLAN', 'JAL                 '),
(359, 'DEG                 ', 'DEGOLLADO', 'JAL                 '),
(360, 'ED                  ', 'ENCARNACIÓN DE DÍAZ', 'JAL                 '),
(361, 'EJIDO               ', 'EJIDO LA GLORIA', 'JAL                 '),
(362, 'EJU                 ', 'EJUTLA', 'JAL                 '),
(363, 'EP                  ', 'EL PITILLAL', 'JAL                 '),
(364, 'ES                  ', 'EL SALTO', 'JAL                 '),
(365, 'ETZ                 ', 'ETZATLAN', 'JAL                 '),
(366, 'GDL                 ', 'GUADALAJARA', 'JAL                 '),
(367, 'GF                  ', 'GÓMEZ FARÍAS', 'JAL                 '),
(368, 'GLC                 ', 'GASOLINERA LAS CUATAS', 'JAL                 '),
(369, 'GOMEZF              ', 'GOMEZ FARIAS', 'JAL                 '),
(370, 'GRANJA              ', 'GRANJA', 'JAL                 '),
(371, 'GRU                 ', 'EL GRULLO', 'JAL                 '),
(372, 'GUA                 ', 'GUACHINANGO', 'JAL                 '),
(373, 'HOS                 ', 'HOSTOTIPAQUILLO', 'JAL                 '),
(374, 'HUEA                ', 'HUEJUQUILLA EL ALTO', 'JAL                 '),
(375, 'HUEN                ', 'HUENTITAN', 'JAL                 '),
(376, 'HUER                ', 'LA HUERTA', 'JAL                 '),
(377, 'HUES                ', 'HUESTALAPA', 'JAL                 '),
(378, 'IXD                 ', 'IXTLAHUACAN DEL RIO', 'JAL                 '),
(379, 'IXTLAHUACAN DEL RIO ', 'IXTLAHUACAN DEL RIO', 'JAL                 '),
(380, 'IXTM                ', 'IXTLAHUACAN DE LOS MEMBRILLOS', 'JAL                 '),
(381, 'IXTN                ', 'IXTLAN', 'JAL                 '),
(382, 'JALOS               ', 'JALOSTOTITLÁN', 'JAL                 '),
(383, 'JAM                 ', 'JAMAY', 'JAL                 '),
(384, 'JEMA                ', 'JESUS MARIA', 'JAL                 '),
(385, 'JILD                ', 'JILOTLÁN DE LOS DOLORES', 'JAL                 '),
(386, 'JM                  ', 'JESÚS MARÍA', 'JAL                 '),
(387, 'JOC                 ', 'JOCOTEPEC', 'JAL                 '),
(388, 'JOCOTN              ', 'JOCOTAN', 'JAL                 '),
(389, 'JUA                 ', 'JUANACATLAN', 'JAL                 '),
(390, 'JUC                 ', 'JUCHITLAN', 'JAL                 '),
(391, 'LA PAZ              ', 'LA PAZ', 'JAL                 '),
(392, 'LAJA                ', 'LA LAJA', 'JAL                 '),
(393, 'LARIVE              ', 'LA RIVERA', 'JAL                 '),
(394, 'LGOSMOR             ', 'LAGOS DE MORENO', 'JAL                 '),
(395, 'LIM                 ', 'EL LIMÓN', 'JAL                 '),
(396, 'MAG                 ', 'MAGDALENA', 'JAL                 '),
(397, 'MAS                 ', 'MASCOTA', 'JAL                 '),
(398, 'MAZ                 ', 'MAZAMITLA', 'JAL                 '),
(399, 'MDO                 ', 'MEZQUITAL DEL ORO ', 'JAL                 '),
(400, 'MECHOA              ', 'MECHOACANEJO', 'JAL                 '),
(401, 'MELAQUE             ', 'MELAQUE', 'JAL                 '),
(402, 'MESA                ', 'MESA COLORADA', 'JAL                 '),
(403, 'MEX                 ', 'MEXTICACÁN', 'JAL                 '),
(404, 'MEZ                 ', 'MEZQUITIC', 'JAL                 '),
(405, 'MICHDE              ', 'MICHOACAN DE OCAMPO', 'JAL                 '),
(406, 'MIX                 ', 'MIXTLÁN', 'JAL                 '),
(407, 'MP                  ', 'LA MANZANILLA DE LA PAZ', 'JAL                 '),
(408, 'MZL                 ', 'MEZCALA', 'JAL                 '),
(409, 'NVOV                ', 'NUEVO VALLARTA', 'JAL                 '),
(410, 'OCO                 ', 'OCOTLAN', 'JAL                 '),
(411, 'OJ                  ', 'OJUELOS DE JALISCO', 'JAL                 '),
(412, 'PARRL               ', 'PARRAL', 'JAL                 '),
(413, 'PGDE                ', 'PUENTE GRANDE', 'JAL                 '),
(414, 'PIH                 ', 'PIHUAMO', 'JAL                 '),
(415, 'PON                 ', 'PONCITLAN', 'JAL                 '),
(416, 'PTOV                ', 'PUERTO VALLARTA', 'JAL                 '),
(417, 'PUG                 ', 'PUENTE GRANDE', 'JAL                 '),
(418, 'QUI                 ', 'QUITUPAN', 'JAL                 '),
(419, 'SA                  ', 'SANTA ANITA', 'JAL                 '),
(420, 'SANJ                ', 'SAN JULIAN', 'JAL                 '),
(421, 'SANPEDRO            ', 'SAN PEDRO TLAQUEPAQUE', 'JAL                 '),
(422, 'SAT                 ', 'SAN ANTONIO TLAYACAPAN', 'JAL                 '),
(423, 'SAUCE               ', 'LOS SAUCES', 'JAL                 '),
(424, 'SAY                 ', 'SAYULA', 'JAL                 '),
(425, 'SCB                 ', 'SAN CRISTÓBAL DE LA BARRANCA', 'JAL                 '),
(426, 'SDA                 ', 'SAN DIEGO DE ALEJANDRÍA', 'JAL                 '),
(427, 'SFQ                 ', 'SAN FRANCISCO QUITUPAN', 'JAL                 '),
(428, 'SG                  ', 'SAN GABRIEL', 'JAL                 '),
(429, 'SJ                  ', 'SAN JULIÁN', 'JAL                 '),
(430, 'SJE                 ', 'SAN JUANITO DE ESCOBEDO', 'JAL                 '),
(431, 'SJL                 ', 'SAN JUAN DE LOS LAGOS', 'JAL                 '),
(432, 'SLS                 ', 'SAN LUIS SOYATLAN', 'JAL                 '),
(433, 'SM                  ', 'SAN MARCOS', 'JAL                 '),
(434, 'SMA                 ', 'SAN MIGUEL EL ALTO', 'JAL                 '),
(435, 'SMB                 ', 'SAN MARTÍN DE BOLAÑOS', 'JAL                 '),
(436, 'SMDA                ', 'SANTA MARÍA DE LOS ANGELES', 'JAL                 '),
(437, 'SMH                 ', 'SAN MARTIN HIDALGO', 'JAL                 '),
(438, 'SMO                 ', 'SANTA MARÍA DEL ORO', 'JAL                 '),
(439, 'SMVALLE             ', 'SANTA MARIA DEL VALLE', 'JAL                 '),
(440, 'SMZ                 ', 'SAN MIGUEL ZAPOTITLAN', 'JAL                 '),
(441, 'SN                  ', 'SAN AGUSTIN', 'JAL                 '),
(442, 'SNJC                ', 'SAN JUAN  COSALA', 'JAL                 '),
(443, 'SNJUANOCOT          ', 'SAN JUAN DE OCOTAN', 'JAL                 '),
(444, 'SNMCU               ', 'SAN MIGUEL CUYUTLAN', 'JAL                 '),
(445, 'SNPATRCIO           ', 'SAN PATRICIO MPIO.DE CIHUATLAN', 'JAL                 '),
(446, 'SNSEB               ', 'SAN SEBASTIAN', 'JAL                 '),
(447, 'SSG                 ', 'SAN SEBASTIAN EL GRANDE', 'JAL                 '),
(448, 'SSO                 ', 'SAN SEBASTIAN DEL OESTE', 'JAL                 '),
(449, 'STA CRUZ DE LAS FLOR', 'STA CRUZ DE LAS FLOR', 'JAL                 '),
(450, 'STACRUZAS           ', 'SANTA CRUZ DEL ASTILLERO', 'JAL                 '),
(451, 'TAA                 ', 'TALPA DE ALLENDE', 'JAL                 '),
(452, 'TAG                 ', 'TAMAZULA DE GORDIANO', 'JAL                 '),
(453, 'TAL                 ', 'TALA', 'JAL                 '),
(454, 'TAP                 ', 'TAPALPA', 'JAL                 '),
(455, 'TATEP               ', 'TATEPOSCO', 'JAL                 '),
(456, 'TEC                 ', 'TECALITLAN', 'JAL                 '),
(457, 'TECH                ', 'TECHALUTA DE MONTENEGRO', 'JAL                 '),
(458, 'TECO                ', 'TECOLOTLAN', 'JAL                 '),
(459, 'TEN                 ', 'TENAMAXTLÁN', 'JAL                 '),
(460, 'TEO                 ', 'TEOCALTICHE', 'JAL                 '),
(461, 'TEOC                ', 'TEOCUITATLÁN DE CORONA', 'JAL                 '),
(462, 'TEPATITLAN          ', 'TEPATITLAN', 'JAL                 '),
(463, 'TEPMO               ', 'TEPATITLAN DE MORELOS', 'JAL                 '),
(464, 'TEQ                 ', 'TEQUILA', 'JAL                 '),
(465, 'TES                 ', 'TESISTAN', 'JAL                 '),
(466, 'TEU                 ', 'TEUCHITLÁN', 'JAL                 '),
(467, 'TIZ                 ', 'TIZAPAN EL ALTO', 'JAL                 '),
(468, 'TLA                 ', 'TLAQUEPAQUE', 'JAL                 '),
(469, 'TLJ                 ', 'TLAJOMULCO DE ZUÑIGA', 'JAL                 '),
(470, 'TOL                 ', 'TOLIMÁN', 'JAL                 '),
(471, 'TOLOTLN             ', 'TOLOTLAN', 'JAL                 '),
(472, 'TOLUQUI             ', 'TOLUQUILLA', 'JAL                 '),
(473, 'TOM                 ', 'TOMATLAN', 'JAL                 '),
(474, 'TON                 ', 'TONALA', 'JAL                 '),
(475, 'TONI                ', 'TONILA', 'JAL                 '),
(476, 'TONY                ', 'TONAYA', 'JAL                 '),
(477, 'TOT                 ', 'TOTATICHE', 'JAL                 '),
(478, 'TOTL                ', 'TOTOTLAN', 'JAL                 '),
(479, 'TUX                 ', 'TUXCACUESCO', 'JAL                 '),
(480, 'TUXC                ', 'TUXCUECA', 'JAL                 '),
(481, 'TUXP                ', 'TUXPAN', 'JAL                 '),
(482, 'UNSAN               ', 'UNION DE SAN ANTONIO', 'JAL                 '),
(483, 'USA                 ', 'UNIÓN DE SAN ANTONIO', 'JAL                 '),
(484, 'UT                  ', 'UNION DE TULA', 'JAL                 '),
(485, 'VALLEDEJUA          ', 'VALLE DE JUAREZ', 'JAL                 '),
(486, 'VC                  ', 'VILLA CORONA', 'JAL                 '),
(487, 'VEGA                ', 'LA VEGA', 'JAL                 '),
(488, 'VG                  ', 'VALLE DE GUADALUPE', 'JAL                 '),
(489, 'VGR                 ', 'VILLA GUERRERO', 'JAL                 '),
(490, 'VHID                ', 'VILLA HIDALGO', 'JAL                 '),
(491, 'VJ                  ', 'VALLE DE JUAREZ', 'JAL                 '),
(492, 'VP                  ', 'VILLA PURIFICACIÓN', 'JAL                 '),
(493, 'YAHUALICA           ', 'YAHUALICA DE GONZALEZ GALLO', 'JAL                 '),
(494, 'ZAP                 ', 'ZAPOTLANEJO', 'JAL                 '),
(495, 'ZAPO                ', 'ZAPOTILTIC', 'JAL                 '),
(496, 'ZAPOT               ', 'ZAPOTLAN EL GRANDE', 'JAL                 '),
(497, 'ZAPR                ', 'ZAPOTLÁN DEL REY', 'JAL                 '),
(498, 'ZAPV                ', 'ZAPOTITLÁN DE VADILLO', 'JAL                 '),
(499, 'ZPP                 ', 'ZAPOPAN', 'JAL                 '),
(500, 'ZPTR                ', 'ZAPOTLAN DEL REY', 'JAL                 '),
(501, 'ZT                  ', 'ZACOALCO DE TORRES', 'JAL                 '),
(502, 'APATZINGAN          ', 'APATZINGAN', 'MICH                '),
(503, 'ARS                 ', 'ARIO DE ROSALES', 'MICH                '),
(504, 'BRIS                ', 'BRISEÑAS ', 'MICH                '),
(505, 'CDHID               ', 'CIUDAD HIDALGO', 'MICH                '),
(506, 'CDLAZCAR            ', 'CD. LAZARO CARDENAS', 'MICH                '),
(507, 'CHA                 ', 'CHAPARACO', 'MICH                '),
(508, 'CHAV                ', 'CHAVINDA', 'MICH                '),
(509, 'COALCMAN            ', 'COALCOMAN', 'MICH                '),
(510, 'CR                  ', 'COJUMATLAN DE REGULEZ', 'MICH                '),
(511, 'GUACAMAYAS          ', 'LAS GUACAMAYAS', 'MICH                '),
(512, 'HUETAMO             ', 'HUETAMO', 'MICH                '),
(513, 'IXTLAN              ', 'IXTLAN DE LOS HERVORES', 'MICH                '),
(514, 'JAC                 ', 'JACOMA', 'MICH                '),
(515, 'JACO                ', 'JACONA', 'MICH                '),
(516, 'JQ                  ', 'JIQUILPAN', 'MICH                '),
(517, 'LAZARO CARDENAS     ', 'LAZARO CARDENAS', 'MICH                '),
(518, 'MIC                 ', 'MICHOACAN DE OCAMPO', 'MICH                '),
(519, 'MORELIA             ', 'MORELIA', 'MICH                '),
(520, 'MTIO                ', 'MARAVATIO', 'MICH                '),
(521, 'PAJACUARAN          ', 'PAJACUARAN', 'MICH                '),
(522, 'PANINDICUARO        ', 'PANINDICUARO', 'MICH                '),
(523, 'PARACHO             ', 'PARACHO', 'MICH                '),
(524, 'PATZCUA             ', 'PATZCUARO', 'MICH                '),
(525, 'PER                 ', 'PERIBAN', 'MICH                '),
(526, 'PEREPERO            ', 'PUREPERO', 'MICH                '),
(527, 'PIEDAD              ', 'LA PIEDAD', 'MICH                '),
(528, 'PNCRO               ', 'PANINDUCUARO', 'MICH                '),
(529, 'RYS                 ', 'LOS REYES ', 'MICH                '),
(530, 'SAHUAYO             ', 'SAHUAYO', 'MICH                '),
(531, 'SNJOSE              ', 'SAN JOSE DE GRACIA', 'MICH                '),
(532, 'TANGAN              ', 'TANGANCICUARO', 'MICH                '),
(533, 'TANH                ', 'TANHUATO', 'MICH                '),
(534, 'TARIM               ', 'TARIMBARO', 'MICH                '),
(535, 'TEPALCATEPEC        ', 'TEPALCATEPEC', 'MICH                '),
(536, 'TEPECONTE           ', 'TEPETONGO CONTEPEC', 'MICH                '),
(537, 'URUAPAN             ', 'URUAPAN', 'MICH                '),
(538, 'VISHER              ', 'VISTA HERMOSA', 'MICH                '),
(539, 'YURECUARO           ', 'YURECUARO', 'MICH                '),
(540, 'ZAH                 ', 'ZAHUAYO', 'MICH                '),
(541, 'ZAM                 ', 'ZAMORA', 'MICH                '),
(542, 'ZAPU                ', 'ZACAPU', 'MICH                '),
(543, 'ZITCRO              ', 'ZITACUARO', 'MICH                '),
(544, 'LOSREYES            ', 'LOS REYES', 'MICHOA              '),
(545, 'MOREL               ', 'MORELIA', 'MICHOA              '),
(546, 'URUAP               ', 'URUAPAN', 'MICHOA              '),
(547, 'AYA                 ', 'AYALA', 'MOR                 '),
(548, 'CUAUTLA             ', 'CUAUTLA', 'MOR                 '),
(549, 'CUERNA              ', 'CUERNAVACA', 'MOR                 '),
(550, 'EMILZ               ', 'EMILIANO ZAPATA', 'MOR                 '),
(551, 'JIUTE               ', 'JIUTEPEC', 'MOR                 '),
(552, 'JOJTLA              ', 'JOJUTLA', 'MOR                 '),
(553, 'TMCO                ', 'TEMIXCO', 'MOR                 '),
(554, 'XOCHIT              ', 'XOCHITEPEC', 'MOR                 '),
(555, 'YAU                 ', 'YAUTEPEC', 'MOR                 '),
(556, 'ACAPNTA             ', 'AMATLAN DE CAÑAS', 'NAYARIT             '),
(557, 'AHUACATLN           ', 'AHUACATLAN', 'NAYARIT             '),
(558, 'BAH                 ', 'BAHIA DE BANDERAS', 'NAYARIT             '),
(559, 'BUC                 ', 'BUCERIAS', 'NAYARIT             '),
(560, 'CDRUIZ              ', 'CIUDAD RUIZ', 'NAYARIT             '),
(561, 'COMPOSTLA           ', 'COMPOSTELA', 'NAYARIT             '),
(562, 'FCO. I. MADERO      ', 'FCO. I. MADERO', 'NAYARIT             '),
(563, 'IXTRIO              ', 'IXTLAN DEL RIO', 'NAYARIT             '),
(564, 'JALA                ', 'JALA', 'NAYARIT             '),
(565, 'JALIX               ', 'JALIXCO', 'NAYARIT             '),
(566, 'JARRE               ', 'LAS JARRETADERAS', 'NAYARIT             '),
(567, 'JOM                 ', 'JOMULCO', 'NAYARIT             '),
(568, 'LCH                 ', 'LA CRUZ DE HUANACAXTLE', 'NAYARIT             '),
(569, 'LPEN                ', 'LAS PEÑITAS', 'NAYARIT             '),
(570, 'LSVRAS              ', 'LAS VARAS', 'NAYARIT             '),
(571, 'MEZCALITOS          ', 'MEZCALITOS', 'NAYARIT             '),
(572, 'MZLA                ', 'MEZCALA', 'NAYARIT             '),
(573, 'NVOVALLA            ', 'NUEVO VALLARTA', 'NAYARIT             '),
(574, 'OTA                 ', 'OTATES', 'NAYARIT             '),
(575, 'PIE                 ', 'LAS PIEDRAS', 'NAYARIT             '),
(576, 'PM                  ', 'PUNTA DE MITA', 'NAYARIT             '),
(577, 'RINGUA              ', 'RINCON DE GUAYABITOS', 'NAYARIT             '),
(578, 'RUIZ                ', 'RUIZ', 'NAYARIT             '),
(579, 'SAINX               ', 'SANTIAGO IXCUINTLA', 'NAYARIT             '),
(580, 'SAMAO               ', 'SANTA MARIA DEL ORO', 'NAYARIT             '),
(581, 'SANB                ', 'SAN BLAS', 'NAYARIT             '),
(582, 'SANC                ', 'SAN CAYETANO', 'NAYARIT             '),
(583, 'SAYU                ', 'SAYULITA', 'NAYARIT             '),
(584, 'SGOIXCTLA           ', 'SANTIAGO IXCUINTLA', 'NAYARIT             '),
(585, 'TECUALA             ', 'TECUALA', 'NAYARIT             '),
(586, 'TEPIC               ', 'TEPIC', 'NAYARIT             '),
(587, 'TUXPAN              ', 'TUXPAN', 'NAYARIT             '),
(588, 'VILLAH              ', 'VILLA HIDALGO', 'NAYARIT             '),
(589, 'XAL                 ', 'XALISCO', 'NAYARIT             '),
(590, 'ALL                 ', 'ALLENDE', 'NL                  '),
(591, 'APOD                ', 'APODACA', 'NL                  '),
(592, 'CAD                 ', 'CADEREYTA JIMENEZ', 'NL                  '),
(593, 'CARMEN              ', 'EL CARMEN', 'NL                  '),
(594, 'CATALINA            ', 'STA.CATALINA', 'NL                  '),
(595, 'CATARINA            ', 'SANTA CATARINA', 'NL                  '),
(596, 'CBJ                 ', 'CIUDAD BENITO JUAREZ', 'NL                  '),
(597, 'CDGPE               ', 'CIUDAD GUADALUPE', 'NL                  '),
(598, 'CDSABHGO            ', 'CIUDAD SABINAS HIDALGO', 'NL                  '),
(599, 'CF                  ', 'CIENEGA DE LAS FLORES', 'NL                  '),
(600, 'ESC                 ', 'ESCOBEDO', 'NL                  '),
(601, 'FOVIS               ', 'FOVISSSTE', 'NL                  '),
(602, 'GARNVO              ', 'GARCIA', 'NL                  '),
(603, 'GENES               ', 'GENERAL ESCOBEDO', 'NL                  '),
(604, 'GPE                 ', 'GUADALUPE', 'NL                  '),
(605, 'GTRN                ', 'GENERAL TERAN', 'NL                  '),
(606, 'JUAREZ              ', 'JUAREZ', 'NL                  '),
(607, 'LIN                 ', 'LINARES', 'NL                  '),
(608, 'MONTEMRLOS          ', 'MONTEMORELOS', 'NL                  '),
(609, 'MTY                 ', 'MONTERREY', 'NL                  '),
(610, 'PES                 ', 'PESQUERIA', 'NL                  '),
(611, 'SALI                ', 'SALINAS VICTORIA', 'NL                  '),
(612, 'SANTIAGONL          ', 'SANTIAGO', 'NL                  '),
(613, 'SNGARZ              ', 'SAN NICOLAS DE LOS GARZA', 'NL                  '),
(614, 'SNICOLAS            ', 'SAN NICOLAS', 'NL                  '),
(615, 'SPGG                ', 'SAN PEDRO GARZA GARCIA', 'NL                  '),
(616, 'VILGA               ', 'VILLA DE GARCIA', 'NL                  '),
(617, 'BAHSDHTLCO          ', 'BAHIAS DE HUATULCO', 'OAX                 '),
(618, 'ETLA                ', 'VILLA DE ETLA', 'OAX                 '),
(619, 'HPANDLN             ', 'HUAJUAPAN DE LEON', 'OAX                 '),
(620, 'HUATULCO            ', 'SANTA CRUZ HUATULCO', 'OAX                 '),
(621, 'IXTPEC              ', 'IXTEPEC', 'OAX                 '),
(622, 'JUCHITN             ', 'JUCHITAN', 'OAX                 '),
(623, 'LOMBTA              ', 'LOMA BONITA', 'OAX                 '),
(624, 'MTIASRO             ', 'MATIAS ROMERO', 'OAX                 '),
(625, 'OAX                 ', 'OAXACA', 'OAX                 '),
(626, 'OAXJUA              ', 'OAXACA DE JUAREZ', 'OAX                 '),
(627, 'PTLADGRO            ', 'PUTLA DE GUERRERO', 'OAX                 '),
(628, 'PTOANGEL            ', 'PUERTO ANGEL', 'OAX                 '),
(629, 'PTOESCDO            ', 'PUERTO ESCONDIDO', 'OAX                 '),
(630, 'SALCRUZ             ', 'SALINA CRUZ', 'OAX                 '),
(631, 'SANLUCA             ', 'SANTA LUCIA DEL CAMINO', 'OAX                 '),
(632, 'SANTA CRUZ          ', 'SANTA CRUZ XOXOCOTLAN', 'OAX                 '),
(633, 'SATU                ', 'SAN SEBASTIAN TUTLA', 'OAX                 '),
(634, 'STACRUZHUAT         ', 'SANTA CRUZ HUATULCO', 'OAX                 '),
(635, 'STAMARIAHUA         ', 'SANTA MARIA HUATULCO', 'OAX                 '),
(636, 'TEHTPEC             ', 'TEHUANTEPEC', 'OAX                 '),
(637, 'TLALI               ', 'TLALIXTAC DE CABRERA', 'OAX                 '),
(638, 'TUXTPEC             ', 'TUXTEPEC', 'OAX                 '),
(639, 'VILLADEZAACHILA     ', 'VILLA DE ZAACHILA', 'OAX                 '),
(640, 'ZIMA                ', 'ZIMATLAN DE ALVAREZ', 'OAX                 '),
(641, 'ANZ                 ', 'AMOZOV', 'PUEBLA              '),
(642, 'ATX                 ', 'ATLIXCO', 'PUEBLA              '),
(643, 'CDSERDAN            ', 'CIUDAD SERDAN', 'PUEBLA              '),
(644, 'CHOLU               ', 'CHOLULA', 'PUEBLA              '),
(645, 'CHOLULA             ', 'SAN ANDRES CHOLULA', 'PUEBLA              '),
(646, 'COR                 ', 'CORONANGO', 'PUEBLA              '),
(647, 'CORONANGO           ', 'CORONANGO', 'PUEBLA              '),
(648, 'COX                 ', 'COXCOTLAN', 'PUEBLA              '),
(649, 'CUAU                ', 'CUAUCLANCINGO', 'PUEBLA              '),
(650, 'CUAUT               ', 'CUAUTLANCINGO', 'PUEBLA              '),
(651, 'HEROICA             ', 'HEROICA PUEBLA DE ZARAGOZA', 'PUEBLA              '),
(652, 'HUACHI              ', 'HUACHINANGO', 'PUEBLA              '),
(653, 'HUEJO               ', 'HUEJOTZINGO', 'PUEBLA              '),
(654, 'IZUDMROS            ', 'IZUCAR DE MATAMOROS', 'PUEBLA              '),
(655, 'NOPA                ', 'NOPALUCAN', 'PUEBLA              '),
(656, 'OCOFRAN             ', 'SAN FRANCISCO OCOTLAN', 'PUEBLA              '),
(657, 'PUEBLA              ', 'PUEBLA', 'PUEBLA              '),
(658, 'SANTIAGOMIA         ', 'SANTIAGO MIAHUATLAN', 'PUEBLA              '),
(659, 'SAP                 ', 'SAN PEDRO CHOLULA', 'PUEBLA              '),
(660, 'SFRAC               ', 'SAN FRANCISCO OCOTLAN', 'PUEBLA              '),
(661, 'SNMTNTEX            ', 'SAN MARTIN TEXMELUCAN', 'PUEBLA              '),
(662, 'TEHUACN             ', 'TEHUACAN', 'PUEBLA              '),
(663, 'TEOTIHUA            ', 'TEOTIHUACAN', 'PUEBLA              '),
(664, 'TEZIUTLN            ', 'TEZIUTLAN', 'PUEBLA              '),
(665, 'TLAXC               ', 'TLAXCALANCINGO', 'PUEBLA              '),
(666, 'TLX                 ', 'TLAXCALANCINGO', 'PUEBLA              '),
(667, 'XIC                 ', 'XICOTEPEC', 'PUEBLA              '),
(668, 'XICDJREZ            ', 'XICOTEPEC DE JUAREZ', 'PUEBLA              '),
(669, 'CORR                ', 'CORREGIDORA', 'QRO                 '),
(670, 'ELMARQUES           ', 'EL MARQUES', 'QRO                 '),
(671, 'EZE                 ', 'EZEQUIEL MONTES', 'QRO                 '),
(672, 'HUI                 ', 'HUIMILPA', 'QRO                 '),
(673, 'JALPAN              ', 'JALPAN', 'QRO                 '),
(674, 'PEDES               ', 'PEDRO ESCOBEDO', 'QRO                 '),
(675, 'QRO                 ', 'QUERETARO', 'QRO                 '),
(676, 'SJRIO               ', 'SAN JUAN DEL RIO', 'QRO                 '),
(677, 'STAROSA             ', 'SANTA ROSA JAUREGUI', 'QRO                 '),
(678, 'STOQUE              ', 'SANTIAGO DE QUERETARO', 'QRO                 '),
(679, 'TEQUISQPN           ', 'TEQUISQUIAPAN', 'QRO                 '),
(680, 'VCOR                ', 'VILLA CORREGIDORA', 'QRO                 '),
(681, 'BENTO               ', 'BENITO JUAREZ', 'QUINTANA ROO        '),
(682, 'BTOJUA              ', 'CIUDAD BENITO JUAREZ', 'QUINTANA ROO        '),
(683, 'CANCUN              ', 'CANCUN', 'QUINTANA ROO        '),
(684, 'CHETMAL             ', 'CHETUMAL', 'QUINTANA ROO        '),
(685, 'COZ                 ', 'COZUMEL', 'QUINTANA ROO        '),
(686, 'FPECARPTO           ', 'FELIPE CARRILLO PUERTO', 'QUINTANA ROO        '),
(687, 'ISLAMU              ', 'ISLA MUJERES', 'QUINTANA ROO        '),
(688, 'PTOMORELOS          ', 'PUERTO MORELOS', 'QUINTANA ROO        '),
(689, 'PUJUA               ', 'PUERTO JUAREZ', 'QUINTANA ROO        '),
(690, 'RIVIERA             ', 'RIVIERA MAYA', 'QUINTANA ROO        '),
(691, 'SOLI                ', 'SOLIDARIDAD', 'QUINTANA ROO        '),
(692, 'AH                  ', 'AHOME', 'SIN                 '),
(693, 'CONR                ', 'CONCORDIA', 'SIN                 '),
(694, 'COSTARICA           ', 'COSTA RICA', 'SIN                 '),
(695, 'CROSALES            ', 'CULIACAN DE ROSALES', 'SIN                 '),
(696, 'CULIACAN            ', 'CULIACAN', 'SIN                 '),
(697, 'CULROSAL            ', 'CULIACAN ROSALES', 'SIN                 '),
(698, 'EL FUERTE           ', 'EL FUERTE SINALOA', 'SIN                 '),
(699, 'ESCUINPA            ', 'ESCUINAPA', 'SIN                 '),
(700, 'GUAMCHIL            ', 'GUAMUCHIL', 'SIN                 '),
(701, 'GUASVE              ', 'GUASAVE', 'SIN                 '),
(702, 'LM                  ', 'LOS MOCHIS', 'SIN                 '),
(703, 'LMA                 ', 'LOS MOCHIS AHOME', 'SIN                 '),
(704, 'MAZATLAN            ', 'MAZATLAN', 'SIN                 '),
(705, 'NAVOLATO            ', 'NAVOLATO', 'SIN                 '),
(706, 'PVM                 ', 'PENINSULA DE VILLAMOROS', 'SIN                 '),
(707, 'ROSRIO              ', 'ROSARIO', 'SIN                 '),
(708, 'CDVALLES            ', 'CIUDAD VALLES', 'SLP                 '),
(709, 'DELVILLA            ', 'DELEGACION  VILLA DE POZOS', 'SLP                 '),
(710, 'MATHLA              ', 'MATEHUALA', 'SLP                 '),
(711, 'MEZCAR              ', 'MEZQUITIC DE CARMONA', 'SLP                 '),
(712, 'MEZCARM             ', 'MEZQUITIC DE CARMONA', 'SLP                 '),
(713, 'RIOVDE              ', 'RIO VERDE', 'SLP                 '),
(714, 'SLP                 ', 'SAN LUIS POTOSI', 'SLP                 '),
(715, 'SOLGR               ', 'SOLEDAD DE GRACIANO', 'SLP                 '),
(716, 'TAMZNCHLE           ', 'TAMAZUNCHALE', 'SLP                 '),
(717, 'TM                  ', 'TAMUIN', 'SLP                 ');
INSERT INTO `municipios` (`id_municipio`, `Clave`, `Descripcion`, `Estado`) VALUES
(718, 'VDR                 ', 'VILLA DE REYES', 'SLP                 '),
(719, 'AGPTA               ', 'AGUA PRIETA', 'SON                 '),
(720, 'ALMOS               ', 'ALAMOS', 'SON                 '),
(721, 'CABRCA              ', 'CABORCA', 'SON                 '),
(722, 'CAJENE              ', 'CAJENE', 'SON                 '),
(723, 'CANAN               ', 'CANANEA', 'SON                 '),
(724, 'CDOBRE              ', 'CIUDAD OBREGON', 'SON                 '),
(725, 'EMPALM              ', 'EMPALME', 'SON                 '),
(726, 'GUAYMS              ', 'GUAYMAS', 'SON                 '),
(727, 'HER                 ', 'HERMOSILLO', 'SON                 '),
(728, 'HUATBMPO            ', 'HUATABAMPO', 'SON                 '),
(729, 'NACO                ', 'NACO', 'SON                 '),
(730, 'NACOZ               ', 'NACOZARI', 'SON                 '),
(731, 'NAVOJOA             ', 'NAVOJOA', 'SON                 '),
(732, 'NOG                 ', 'NOGALES', 'SON                 '),
(733, 'OBREGON             ', 'OBREGON', 'SON                 '),
(734, 'PIT                 ', 'PITIQUITO', 'SON                 '),
(735, 'PTOPESCO            ', 'PUERTO PEÑASCO', 'SON                 '),
(736, 'SNLRIOCDO           ', 'SAN LUIS RIO COLORADO', 'SON                 '),
(737, 'SONYTA              ', 'SONOYTA', 'SON                 '),
(738, 'STANA               ', 'SANTA ANA', 'SON                 '),
(739, 'URES                ', 'URES', 'SON                 '),
(740, 'VPSQ                ', 'VILLA PESQUEIRA', 'SON                 '),
(741, 'COM                 ', 'Comalcalco', 'TABASCO             '),
(742, 'HUIMANGLLO          ', 'HUIMANGUILLO', 'TABASCO             '),
(743, 'MACUSPNA            ', 'MACUSPANA', 'TABASCO             '),
(744, 'PARAISO             ', 'PARAISO', 'TABASCO             '),
(745, 'TABACA              ', 'CARDENAS', 'TABASCO             '),
(746, 'TACOTALPA           ', 'TACOTALPA', 'TABASCO             '),
(747, 'TENOSQUE            ', 'TENOSIQUE', 'TABASCO             '),
(748, 'VILLHMOSA           ', 'VILLAHERMOSA', 'TABASCO             '),
(749, 'AM                  ', 'ALTAMIRA', 'TAM                 '),
(750, 'BONI                ', 'BONITA', 'TAM                 '),
(751, 'CDCAMARGO           ', 'CIUDAD CAMARGO', 'TAM                 '),
(752, 'CDMADERO            ', 'CIUDAD MADERO', 'TAM                 '),
(753, 'CDMANTE             ', 'CIUDAD MANTE', 'TAM                 '),
(754, 'CDMIGLALMN          ', 'CIUDAD MIGUEL ALEMAN', 'TAM                 '),
(755, 'CDVICTRIA           ', 'CIUDAD VICTORIA', 'TAM                 '),
(756, 'HMATA               ', 'H. MATAMOROS ', 'TAM                 '),
(757, 'JUMA                ', 'JAUMAVE', 'TAM                 '),
(758, 'MA                  ', 'MADERO', 'TAM                 '),
(759, 'MATA                ', 'MATAMOROS', 'TAM                 '),
(760, 'NL                  ', 'Nuevo Laredo', 'TAM                 '),
(761, 'REYNSA              ', 'REYNOSA', 'TAM                 '),
(762, 'RIB                 ', 'RIO BRAVO', 'TAM                 '),
(763, 'SNFDO               ', 'SAN FERNANDO', 'TAM                 '),
(764, 'TAMP                ', 'TAMPICO', 'TAM                 '),
(765, 'VH                  ', 'Valle Hermoso', 'TAM                 '),
(766, 'VILLAGRN            ', 'VILLAGRAN', 'TAM                 '),
(767, 'APIZAC              ', 'APIZACO', 'TLA                 '),
(768, 'CALPULAL            ', 'CALPULALPAN', 'TLA                 '),
(769, 'HUAMAN              ', 'HUAMANTLA', 'TLA                 '),
(770, 'YAUHQUE             ', 'YAUHQUEMEHCAN', 'TLA                 '),
(771, 'TORREON COAU        ', 'COAHUILA DE ZARAGOZA', 'TORREON             '),
(772, 'ACAYUC              ', 'ACAYUCAN', 'VER                 '),
(773, 'ALAMO               ', 'ALAMO', 'VER                 '),
(774, 'AMAT                ', 'AMATLAN', 'VER                 '),
(775, 'BOCAR               ', 'BOCA DEL RIO', 'VER                 '),
(776, 'COATE               ', 'COATEPEC', 'VER                 '),
(777, 'COATZCOLCS          ', 'COATZACOALCOS', 'VER                 '),
(778, 'COSAMLPN            ', 'COSAMALOPAN', 'VER                 '),
(779, 'COZO                ', 'COZOLEACAQUE', 'VER                 '),
(780, 'CUATEPEC            ', 'CUATEPEC', 'VER                 '),
(781, 'CUIDADMEN           ', 'CIUDAD MENDOZA', 'VER                 '),
(782, 'EMNOZPTA            ', 'EMILIANO ZAPATA', 'VER                 '),
(783, 'FOR                 ', 'FORTIN', 'VER                 '),
(784, 'GTZMRA              ', 'GUTIERREZ ZAMORA', 'VER                 '),
(785, 'HUATUS              ', 'HUATUSCO', 'VER                 '),
(786, 'HUIL                ', 'HUILOAPAN DE CUAUHTEMOC', 'VER                 '),
(787, 'ISLAV               ', 'ISLA', 'VER                 '),
(788, 'IXTACZ              ', 'IXTACZOQUITLAN', 'VER                 '),
(789, 'JALAPA              ', 'JALAPA', 'VER                 '),
(790, 'JALTIPN             ', 'JALTIPAN', 'VER                 '),
(791, 'MINATITLN           ', 'MINATITLAN', 'VER                 '),
(792, 'MISANTL             ', 'MISANTLA', 'VER                 '),
(793, 'MTZDLTRRE           ', 'MARTINEZ DE LA TORRE', 'VER                 '),
(794, 'NANCHI              ', 'NANCHITAL DE LAZARO CARDENAS DEL RIO', 'VER                 '),
(795, 'ORIZ                ', 'ORIZABA', 'VER                 '),
(796, 'ORIZBA              ', 'ORIZABA', 'VER                 '),
(797, 'PAPANTL             ', 'PAPANTLA', 'VER                 '),
(798, 'PEROTE              ', 'PEROTE', 'VER                 '),
(799, 'PNACIONAL           ', 'PUENTE NACIONAL', 'VER                 '),
(800, 'POZRICA             ', 'POZA RICA', 'VER                 '),
(801, 'SANTA RITA          ', 'SANTA RITA', 'VER                 '),
(802, 'SNANDTLA            ', 'SAN ANDRES TLALNELHUAYOCAN', 'VER                 '),
(803, 'SNANDTUX            ', 'SAN ANDRES TUXTLA', 'VER                 '),
(804, 'SNMARCOS            ', 'SAN MARCOS DE LEON', 'VER                 '),
(805, 'SNRAFA              ', 'SAN RAFAEL', 'VER                 '),
(806, 'TEJERIA             ', 'TEJERIA', 'VER                 '),
(807, 'TEMPOL              ', 'TEMPOAL', 'VER                 '),
(808, 'TIERBCA             ', 'TIERRA BLANCA', 'VER                 '),
(809, 'VER                 ', 'VERACRUZ', 'VER                 '),
(810, 'XALAPA              ', 'XALAPA', 'VER                 '),
(811, 'XICO                ', 'XICO', 'VER                 '),
(812, 'JAVERA              ', 'XALAPA', 'VERA                '),
(813, 'KANA                ', 'KANASIN', 'YUC                 '),
(814, 'MERIDA              ', 'MERIDA', 'YUC                 '),
(815, 'PROGRES             ', 'PROGRESO', 'YUC                 '),
(816, 'PTOPRO              ', 'PUERTO PROGRESO', 'YUC                 '),
(817, 'TIOUL               ', 'TIOUL', 'YUC                 '),
(818, 'TIZIMN              ', 'TIZIMIN', 'YUC                 '),
(819, 'UMAN                ', 'UMAN', 'YUC                 '),
(820, 'VALLAD              ', 'VALLADOLID', 'YUC                 '),
(821, 'CAL                 ', 'CALERA', 'ZAC                 '),
(822, 'CALVR               ', 'CALERA DE V.R.', 'ZAC                 '),
(823, 'FRESN               ', 'FRESNILLO', 'ZAC                 '),
(824, 'GAR                 ', 'GARCIA DE LA CADENA', 'ZAC                 '),
(825, 'GUADPE              ', 'GUADALUPE', 'ZAC                 '),
(826, 'JAL                 ', 'JALPA', 'ZAC                 '),
(827, 'JALPA               ', 'JALPA', 'ZAC                 '),
(828, 'JREZDGS             ', 'JEREZ DE GARCIA SALINAS', 'ZAC                 '),
(829, 'JRZ                 ', 'JEREZ', 'ZAC                 '),
(830, 'JUCHIP              ', 'JUCHIPILA', 'ZAC                 '),
(831, 'LA CALERA           ', 'lLA CALERA', 'ZAC                 '),
(832, 'MAY                 ', 'MOYAHUA', 'ZAC                 '),
(833, 'MOMAX               ', 'MOMAX', 'ZAC                 '),
(834, 'NOCHIS              ', 'NOCHISTLAN', 'ZAC                 '),
(835, 'RIOGDE              ', 'RIO GRANDE', 'ZAC                 '),
(836, 'SOM                 ', 'SOMBRERETE', 'ZAC                 '),
(837, 'TAB                 ', 'TABASCO', 'ZAC                 '),
(838, 'TEPE                ', 'TEPETONGO', 'ZAC                 '),
(839, 'TEPECHITLAN         ', 'TEPECHITLAN', 'ZAC                 '),
(840, 'TEUL                ', 'TEUL DE GONZALEZ ORTEGA', 'ZAC                 '),
(841, 'TLALT               ', 'TLALTENANGO', 'ZAC                 '),
(842, 'VALP                ', 'VALPARAISO', 'ZAC                 '),
(843, 'XALPA               ', 'XALPA', 'ZAC                 '),
(844, 'ZAC                 ', 'ZACATECAS', 'ZAC                 '),
(845, 'MICHOACA            ', 'MICHOACAN DE OCAMPO', 'ZAMODE              ');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `paquetes`
--

CREATE TABLE `paquetes` (
  `id_paquete` int(11) NOT NULL,
  `Clave` varchar(50) NOT NULL,
  `Descripcion` varchar(200) NOT NULL,
  `Ejemplar` varchar(50) NOT NULL,
  `NumeroMeses` varchar(50) NOT NULL,
  `TotalEjemplar` varchar(50) NOT NULL,
  `Observacion` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `paquetes`
--

INSERT INTO `paquetes` (`id_paquete`, `Clave`, `Descripcion`, `Ejemplar`, `NumeroMeses`, `TotalEjemplar`, `Observacion`) VALUES
(61, 'FST17               ', 'Fin de Semana Trimestral 2017', 'INF                 ', '3', '590', 'VIE - LUN'),
(62, 'NA20                ', 'Normal Anual Promoción 2020', 'INF                 ', '12', '1998', 'LUN - DOM'),
(63, 'NACAR               ', 'Normal Anual con revista Caras', 'INF                 ', '12', '2400', 'LUN - DOM'),
(64, 'NACF                ', 'Normal Anual Cocina Fácil', 'INF                 ', '12', '2400', 'LUN - DOM'),
(65, 'NAFULL              ', 'Normal Anual Full', 'INF                 ', '12', '2789', 'LUN - DOM'),
(66, 'NTNOV20             ', 'Normal Trimestral Noviembre 2020', 'INF                 ', '3', '599', 'LUN - DOM'),
(67, 'DM                  ', 'Digital Mensual', 'DIG                 ', '1', '19', 'LUN - DOM'),
(68, 'DS                  ', 'Digital Semestral', 'DIG                 ', '6', '99', 'LUN - DOM'),
(69, 'DAPP                ', 'Digital Anual Precio Promoción', 'DIG                 ', '12', '189', 'LUN - DOM'),
(70, 'EA17                ', 'Ejecutivo Anual 2017', 'INF                 ', '12', '1900', 'LUN - VIE'),
(71, 'ES17                ', 'Ejecutivo Semestral 2017', 'INF                 ', '6', '960', 'LUN - VIE'),
(72, 'ET17                ', 'Ejecutivo Trimestral 2017', 'INF                 ', '3', '590', 'LUN - VIE'),
(73, 'FSACAR              ', 'Fin de Semana Anual con revista Caras', 'INF                 ', '12', '1900', 'VIE - LUN'),
(74, 'NSNOV19             ', 'Normal Semestral Noviembre 2019', 'INF                 ', '6', '999', 'LUN - DOM'),
(75, 'FSS17               ', 'Fin de Semana Semestral 2017', 'INF                 ', '6', '960', 'VIE - LUN');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `redenciones`
--

CREATE TABLE `redenciones` (
  `id_redencion` int(11) NOT NULL,
  `rownum` varchar(25) DEFAULT NULL,
  `Id` varchar(25) DEFAULT NULL,
  `Promocion` varchar(100) DEFAULT NULL,
  `Tarjeta` varchar(100) DEFAULT NULL,
  `Sucursal` varchar(100) DEFAULT NULL,
  `Fecha` datetime DEFAULT NULL,
  `UsuarioCaptura` varchar(100) DEFAULT NULL,
  `FechaCaptura` datetime DEFAULT NULL,
  `codigo` varchar(100) DEFAULT NULL,
  `afiliado` int(11) DEFAULT NULL,
  `establecimiento` int(11) DEFAULT NULL,
  `feedback` int(11) DEFAULT NULL,
  `exp` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Volcado de datos para la tabla `redenciones`
--

INSERT INTO `redenciones` (`id_redencion`, `rownum`, `Id`, `Promocion`, `Tarjeta`, `Sucursal`, `Fecha`, `UsuarioCaptura`, `FechaCaptura`, `codigo`, `afiliado`, `establecimiento`, `feedback`, `exp`) VALUES
(1, '', '', '1143', '10070', '115-19', '2022-08-24 18:11:06', 'user', '0000-00-00 00:00:00', 'BL114310008241811', 115, 19, 0, NULL),
(2, '', '', '86', '10070', '115-15', '2022-08-24 18:15:14', 'user', '2022-08-25 00:20:38', 'BL8610008241815', 115, 15, 5, NULL),
(3, '', '', '118', '10070', '115-16', '2022-08-24 18:22:24', 'user', '2022-08-24 18:26:42', 'BL11810008241822', 115, 16, 4, NULL),
(4, '', '', '198', '10070', '170-7', '2022-08-24 21:47:41', 'user', '2022-08-24 21:48:32', 'PO19810008242147', 170, 7, 0, NULL),
(5, '', '', '1143', '10070', '115-18', '2022-08-25 00:19:11', 'user', '0000-00-00 00:00:00', 'BL114310008250019', 115, 18, 0, NULL),
(6, '', '', '1143', '10070', '115-0', '2022-08-25 23:12:25', 'user', '0000-00-00 00:00:00', 'BL114310008252312', 115, 0, 0, NULL),
(7, '', '', '219', '13723', '120-1', '2022-08-26 02:19:22', 'user', '0000-00-00 00:00:00', 'GR21908260219', 120, 1, 4, NULL),
(8, NULL, NULL, '153', '10001', '143-2', '2022-09-03 18:07:21', 'user', NULL, 'VO15309031807', 143, 2, NULL, NULL),
(9, NULL, NULL, '153', '10001', '143-0', '2022-09-03 18:08:17', 'user', NULL, 'VO15309031808', 143, 0, NULL, NULL),
(10, NULL, NULL, '153', '10001', '143-2', '2022-09-03 18:10:16', 'user', NULL, 'VO15309031810', 143, 2, NULL, NULL),
(11, NULL, NULL, '153', '10001', '143-0', '2022-09-03 18:11:11', 'user', '2022-09-03 18:11:29', 'VO15309031811', 143, 0, 3, NULL),
(12, NULL, NULL, '69', '10001', '13-1', '2022-09-03 18:12:32', 'user', NULL, 'GR6909031812', 13, 1, NULL, NULL),
(13, NULL, NULL, '69', '10001', '13-1', '2022-09-03 18:14:49', 'user', NULL, 'GR6909031814', 13, 1, NULL, NULL),
(14, NULL, NULL, '1015', '10001', '723-2', '2022-09-03 18:43:26', 'user', NULL, 'HO101509031842', 723, 2, NULL, NULL),
(15, NULL, NULL, '1015', '10001', '723-1', '2022-09-03 18:59:50', 'user', NULL, 'HO101509031859', 723, 1, NULL, NULL),
(16, NULL, NULL, '1015', '10001', '723-2', '2022-09-03 19:00:44', 'user', NULL, 'HO101509031900', 723, 2, NULL, NULL),
(17, NULL, NULL, '1015', '10001', '723-2', '2022-09-03 19:02:17', 'user', NULL, 'HO101509031902', 723, 2, NULL, NULL),
(18, NULL, NULL, '1015', '10001', '723-0', '2022-09-03 19:03:24', 'user', NULL, 'HO101509031903', 723, 0, NULL, NULL),
(19, NULL, NULL, '1015', '10001', '723-2', '2022-09-03 19:06:52', 'user', NULL, 'HO101509031906', 723, 2, NULL, NULL),
(20, NULL, NULL, '1015', '10001', '723-3', '2022-09-03 19:08:57', 'user', NULL, 'HO101509031908', 723, 3, NULL, NULL),
(21, NULL, NULL, '1015', '10001', '723-0', '2022-09-03 19:13:11', 'user', NULL, 'HO101509031913', 723, 0, NULL, NULL),
(22, NULL, NULL, '1015', '10001', '723-2', '2022-09-03 19:15:36', 'user', NULL, 'HO101509031915', 723, 2, NULL, NULL),
(23, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:13:44', 'user', NULL, 'SE90509032313', 646, 1, NULL, NULL),
(24, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:26:56', 'user', NULL, 'SE90509032326', 646, 1, NULL, NULL),
(25, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:29:37', 'user', NULL, 'SE90509032329', 646, 1, NULL, NULL),
(26, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:31:17', 'user', NULL, 'SE90509032331', 646, 1, NULL, NULL),
(27, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:33:00', 'user', NULL, 'SE90509032332', 646, 1, NULL, NULL),
(28, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:35:35', 'user', NULL, 'SE90509032335', 646, 1, NULL, NULL),
(29, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:36:30', 'user', NULL, 'SE90509032336', 646, 1, NULL, NULL),
(30, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:53:51', 'user', NULL, 'SE90509032353', 646, 1, NULL, '2022-09-03 23:53:51'),
(31, NULL, NULL, '905', '10001', '646-1', '2022-09-03 23:56:40', 'user', NULL, 'SE90509032356', 646, 1, NULL, '1969-12-31 18:38:42'),
(32, NULL, NULL, '905', '10001', '646-1', '2022-09-04 00:03:34', 'user', NULL, 'SE90509040003', 646, 1, NULL, '2022-09-04 00:08:34'),
(33, NULL, NULL, '905', '10001', '646-1', '2022-09-04 00:16:46', 'user', NULL, 'SE90509040016', 646, 1, NULL, '2022-09-04 00:21:46'),
(34, NULL, NULL, '905', '10001', '646-1', '2022-09-04 00:21:40', 'user', NULL, 'SE90509040021', 646, 1, NULL, '2022-09-04 00:26:40'),
(35, NULL, NULL, '905', '10001', '646-1', '2022-09-04 00:22:24', 'user', NULL, 'SE90509040022', 646, 1, NULL, '2022-09-04 00:27:24'),
(36, NULL, NULL, '905', '10001', '646-1', '2022-09-04 00:23:27', 'user', NULL, 'SE90509040023', 646, 1, NULL, '2022-09-04 00:28:27'),
(37, NULL, NULL, '905', '10001', '646-1', '2022-09-04 00:50:13', 'user', NULL, 'SE90509040049', 646, 1, NULL, '2022-09-04 00:55:13'),
(38, NULL, NULL, '905', '10001', '646-1', '2022-09-04 00:50:24', 'user', NULL, 'SE90509040050', 646, 1, NULL, '2022-09-04 00:55:24'),
(39, NULL, NULL, '905', '10001', '646-1', '2022-09-04 00:53:29', 'user', NULL, 'SE90509040053', 646, 1, NULL, '2022-09-04 01:03:29'),
(40, NULL, NULL, '1015', '10001', '723-3', '2022-09-04 00:54:54', 'user', NULL, 'HO101509040054', 723, 3, NULL, '2022-09-04 00:54:54'),
(41, NULL, NULL, '1015', '10001', '723-3', '2022-09-04 00:56:56', 'user', NULL, 'HO101509040056', 723, 3, NULL, '2022-09-04 00:56:56'),
(42, NULL, NULL, '1015', '10001', '723-3', '2022-09-04 00:58:41', 'user', NULL, 'HO101509040058', 723, 3, NULL, '2022-09-04 01:58:41'),
(43, NULL, NULL, '651', '10001', '258-3', '2022-09-04 15:34:01', 'user', NULL, 'JU65109041533', 258, 3, NULL, '2022-09-04 16:34:01'),
(44, NULL, NULL, '905', '10001', '646-1', '2022-09-04 16:22:30', 'user', NULL, 'SE90509041622', 646, 1, NULL, '2022-09-04 16:32:30'),
(45, NULL, NULL, '1015', '10001', '723-2', '2022-09-04 16:28:03', 'user', NULL, 'HO101509041627', 723, 2, NULL, '2022-09-04 17:28:03'),
(46, NULL, NULL, '1155', '10001', '258-2', '2022-09-04 16:28:50', 'user', NULL, 'JU115509041628', 258, 2, NULL, '2022-09-04 17:28:50'),
(47, NULL, NULL, '86', '10001', '115-10', '2022-09-04 16:29:20', 'user', '2022-09-04 16:51:51', 'BL8609041629', 115, 10, 4, '2022-09-04 17:29:20'),
(48, NULL, NULL, '894', '10001', '635-6', '2022-09-04 16:29:52', 'user', NULL, 'LA89409041629', 635, 6, NULL, '2022-09-04 17:29:52'),
(49, NULL, NULL, '56', '10001', '21-29', '2022-09-04 16:30:58', 'user', NULL, 'TI5609041630', 21, 29, NULL, '2022-09-04 17:30:58'),
(50, NULL, NULL, '400', '10001', '319-1', '2022-09-04 16:32:10', 'user', NULL, 'LA40009041632', 319, 1, NULL, '2022-09-04 17:32:10'),
(51, NULL, NULL, '905', '10001', '646-1', '2022-09-04 16:35:30', 'user', NULL, 'SE90509041635', 646, 1, NULL, '2022-09-04 16:45:30'),
(52, NULL, NULL, '905', '10001', '646-01', '2022-09-04 16:51:06', 'user', NULL, 'SE90509041649', 646, 1, NULL, '2022-09-04 17:01:06'),
(53, NULL, NULL, '1143', '10001', '115-16', '2022-09-04 17:27:31', 'user', NULL, 'BL114309041710', 115, 16, NULL, '2022-09-04 18:27:31'),
(54, NULL, NULL, '1143', '10001', '115-8', '2022-09-04 17:27:44', 'user', NULL, 'BL114309041727', 115, 8, NULL, '2022-09-04 17:32:44'),
(55, NULL, NULL, '1143', '10001', '115-16', '2022-09-04 18:16:13', 'user', NULL, 'BL114309041816', 115, 16, NULL, '2022-09-04 18:21:13'),
(56, NULL, NULL, '1143', '10001', '115-7', '2022-09-04 20:33:01', 'user', NULL, 'BL114309042032', 115, 7, NULL, '2022-09-04 20:38:01'),
(57, NULL, NULL, '1143', '10001', '115-19', '2022-09-04 20:33:19', 'user', NULL, 'BL114309042033', 115, 19, NULL, '2022-09-04 20:38:19'),
(58, NULL, NULL, '1143', '10001', '115-8', '2022-09-05 16:31:28', 'user', NULL, 'BL114309051631', 115, 8, NULL, '2022-09-05 16:36:28'),
(59, NULL, NULL, '1155', '10001', '258-3', '2022-09-05 16:32:20', 'user', NULL, 'JU115509051632', 258, 3, NULL, '2022-09-05 17:32:20'),
(60, NULL, NULL, '906', '10001', '21-5', '2022-09-05 17:43:31', 'user', NULL, 'TI90609051743', 21, 5, NULL, '2022-09-05 18:43:31'),
(61, NULL, NULL, '1142', '10001', '349-2', '2022-09-06 20:33:41', 'user', NULL, 'LA114209062033', 349, 2, NULL, '2022-09-06 21:33:41'),
(62, NULL, NULL, '1142', '10001', '349-2', '2022-09-06 20:34:58', 'user', NULL, 'LA114209062034', 349, 2, NULL, '2022-09-06 21:34:58'),
(63, NULL, NULL, '1143', '10001', '115-16', '2022-09-07 15:52:15', 'user', NULL, 'BL114309071551', 115, 16, NULL, '2022-09-07 15:57:15'),
(64, NULL, NULL, '1015', '10001', '723-02', '2022-09-08 04:42:02', 'user', NULL, 'HO101509080441', 723, 2, NULL, '2022-09-08 05:42:02'),
(65, NULL, NULL, '1143', '10001', '115-9', '2022-09-10 18:51:38', 'user', NULL, 'BL114309101851', 115, 9, NULL, '2022-09-10 18:56:38'),
(66, NULL, NULL, '1143', '10001', '115-8', '2022-09-11 19:52:16', 'user', NULL, 'BL114309111952', 115, 8, NULL, '2022-09-11 19:57:16'),
(67, NULL, NULL, '1040', '10488', '154-1', '2022-09-12 23:36:29', 'user', NULL, 'CA104009122336', 154, 1, NULL, '2022-09-13 00:36:29'),
(68, NULL, NULL, '1041', '10488', '154-1', '2022-09-17 00:38:59', 'user', NULL, 'CA104109170038', 154, 1, NULL, '2022-09-17 01:38:59'),
(69, NULL, NULL, '1040', '10488', '154-1', '2022-09-17 02:05:27', 'user', NULL, 'CA104009170205', 154, 1, NULL, '2022-09-17 03:05:27'),
(70, NULL, NULL, '1040', '10488', '154-1', '2022-09-26 17:20:58', 'user', NULL, 'CA104009261720', 154, 1, NULL, '2022-09-26 18:20:58'),
(71, NULL, NULL, '1143', '10488', '115-19', '2022-09-28 03:08:25', 'user', '2022-09-28 03:11:46', 'BL114309280308', 115, 19, 0, '2022-09-28 03:13:25'),
(72, NULL, NULL, '1143', '10488', '115-22', '2022-09-28 03:26:42', 'user', '2022-09-28 03:28:26', 'BL114309280326', 115, 22, 3, '2022-09-28 03:31:42'),
(73, NULL, NULL, '481', '10488', '400-01', '2022-09-28 03:29:05', 'user', NULL, 'TA48109280328', 400, 1, 3, '2022-09-28 04:29:05'),
(74, NULL, NULL, '1143', '10488', '115-17', '2022-09-28 03:54:38', 'user', '2022-09-28 03:54:59', 'BL114309280354', 115, 17, 0, '2022-09-28 03:59:38'),
(75, NULL, NULL, '1040', '10488', '154-1', '2022-10-03 14:53:14', 'user', NULL, 'CA104010031453', 154, 1, NULL, '2022-10-03 15:53:14'),
(76, NULL, NULL, '1040', '10488', '154-1', '2022-10-03 14:55:02', 'user', NULL, 'CA104010031454', 154, 1, NULL, '2022-10-03 15:55:02'),
(77, NULL, NULL, '1040', '10488', '154-1', '2022-10-03 14:56:11', 'user', NULL, 'CA104010031456', 154, 1, NULL, '2022-10-03 15:56:11'),
(78, NULL, NULL, '1040', '10488', '154-1', '2022-10-03 14:57:38', 'user', NULL, 'CA104010031457', 154, 1, NULL, '2022-10-03 15:57:38'),
(79, NULL, NULL, '664', '10488', '507-04', '2022-10-04 01:46:06', 'user', NULL, 'YO66410040145', 507, 4, NULL, '2022-10-04 02:46:06'),
(80, NULL, NULL, '409', '10488', '370-01', '2022-10-04 01:50:11', 'user', NULL, 'TI40910040150', 370, 1, NULL, '2022-10-04 02:50:11'),
(81, NULL, NULL, '1223', '10488', '781-01', '2022-10-04 02:10:16', 'user', NULL, 'GA122310040210', 781, 1, NULL, '2022-10-04 03:10:16'),
(82, NULL, NULL, '1071', '10488', '758-01', '2022-10-13 16:08:13', 'user', NULL, 'LI107110131603', 758, 1, NULL, '2022-10-13 17:08:13'),
(83, NULL, NULL, '664', '10488', '507-04', '2023-11-07 16:38:46', 'user', NULL, 'YO66411071638', 507, 4, 3, '2023-11-07 17:38:46'),
(84, NULL, NULL, '1040', '10488', '154-1', '2023-11-07 17:02:43', 'user', NULL, 'CA104011071702', 154, 1, NULL, '2023-11-07 18:02:43');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `regimenesfiscales`
--

