alanboy/gist:5226337

## gistfile1.sql
-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 22-03-2013 a las 22:35:42
-- Versión del servidor: 5.1.49-3
-- Versión de PHP: 5.3.3-7+squeeze8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de datos: `spiderman`
--

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

--
-- Estructura de tabla para la tabla `ciudad`
--

CREATE TABLE IF NOT EXISTS `ciudad` (
  `id_ciudad` int(11) NOT NULL AUTO_INCREMENT COMMENT 'identificador unico de registro',
  `id_estado` int(11) NOT NULL COMMENT 'identificador unico de registro (estado)',
  `nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL COMMENT 'nombre',
  `nombre_coloquial` varchar(32) DEFAULT NULL,
  `tags` varchar(100) DEFAULT NULL,
  `popularidad` float NOT NULL DEFAULT '0',
  `lat` double NOT NULL,
  `lng` double NOT NULL,
  `bsw_lat` double NOT NULL COMMENT 'bounds southwest',
  `bsw_lng` double NOT NULL COMMENT 'bounds southwest',
  `bne_lat` double NOT NULL COMMENT 'bounds northeast',
  `bne_lng` double NOT NULL COMMENT 'bounds northeast',
  `vistas` int(11) DEFAULT '0',
  PRIMARY KEY (`id_ciudad`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2466 ;

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

INSERT INTO `ciudad` (`id_ciudad`, `id_estado`, `nombre`, `nombre_coloquial`, `tags`, `popularidad`, `lat`, `lng`, `bsw_lat`, `bsw_lng`, `bne_lat`, `bne_lng`, `vistas`) VALUES
(1, 1, 'Aguascalientes', 'Aguascalientes', NULL, 0.512186, 21.8817964, -102.2912701, 21.8200957, -102.3555607, 21.9580787, -102.2301414, 263),
(2, 1, 'Asientos', 'Asientos', NULL, 0.270373, 22.2384759, -102.0890156, 0, 0, 0, 0, 17),
(3, 1, 'Calvillo', 'Calvillo', NULL, 0.238005, 21.85, -102.7166667, 21.8390381, -102.7420224, 21.8599536, -102.6908739, 39),
(5, 1, 'JesÃºs MarÃa', 'Jesus Maria', NULL, 0.346915, 21.9611111, -102.3433333, 21.9395942, -102.3643236, 21.9793088, -102.3264887, 97),
(6, 1, 'PabellÃ³n de Arteaga', 'Pabellon de Arteaga', NULL, 0, 22.1459657, -102.2760701, 22.1366757, -102.2957134, 22.1573525, -102.2687706, 59),
(7, 1, 'RincÃ³n de Romos', 'Rincon de Romos', NULL, 0.24067, 22.2292624, -102.3205376, 22.2186878, -102.3338826, 22.2406163, -102.3037035, 0),
(10, 1, 'San Francisco de los Romo', 'San Francisco de los Romo', NULL, 0.0616908, 22.0686684, -102.2702329, 22.0603351, -102.2843461, 22.0885526, -102.2591997, 0),
(11, 1, 'El Llano', 'El Llano', NULL, 0.210586, 21.912105, -102.048837, 0, 0, 0, 0, 46),
(12, 2, 'Mexicali', 'Mexicali', NULL, 0.309596, 32.6455704, -115.4453421, 32.5551523, -115.5510556, 32.6729734, -115.3471316, 157),
(13, 2, 'Tijuana', 'Tijuana', NULL, 0.388043, 32.533489, -117.018204, 32.4415839, -117.1242124, 32.5556328, -116.8224665, 251),
(14, 2, 'Ensenada', 'Ensenada', NULL, 0.300838, 31.859577, -116.606428, 31.7665708, -116.669758, 31.9073122, -116.5523545, 164),
(15, 2, 'Tecate', 'Tecate', NULL, 0.257807, 32.571441, -116.638059, 0, 0, 0, 0, 90),
(16, 2, 'Rosarito', 'Rosarito', NULL, 0.246382, 32.358791, -117.048203, 32.2934565, -117.0863059, 32.425404, -117.0287224, 201),
(17, 2, 'Ciudad Guadalupe Victoria', 'Guadalupe Victoria', NULL, 0.223915, 32.28786, -115.1046436, 32.2733486, -115.1250063, 32.3006141, -115.082721, 0),
(18, 2, 'San Felipe', 'San Felipe', NULL, 0.114242, 31.0250709, -114.8407776, 30.9752692, -114.8694993, 31.0445646, -114.8059855, 38),
(19, 2, 'San QuintÃn', 'San Quintin', NULL, 0.071211, 30.5655306, -115.9433778, 30.5547367, -115.9454829, 30.5717144, -115.9306051, 71),
(20, 2, 'Ciudad Morelos', 'Ciudad Morelos', NULL, 0.0833968, 32.6321704, -114.8535291, 32.6213464, -114.8691034, 32.6375427, -114.8432924, 0),
(21, 2, 'Los Algodones', 'Los Algodones', NULL, 0.187738, 32.7152778, -114.7288889, 0, 0, 0, 0, 3),
(22, 2, 'La Rumorosa', 'La Rumorosa', NULL, 0.202589, 32.6027177, -116.0780748, 0, 0, 0, 0, 29),
(23, 2, 'CataviÃ±a', 'Cataviña', NULL, 0.0620716, 36.778261, -119.4179324, 32.528832, -124.482003, 42.0095169, -114.131211, 5),
(26, 3, 'La Paz', 'La Paz', NULL, 0.243717, 24.1333333, -110.3, 24.0461446, -110.3528374, 24.1867914, -110.253753, 67),
(27, 3, 'Loreto', 'Loreto', NULL, 0.24981, 26.0117564, -111.3477531, 25.9945056, -111.3646136, 26.0237378, -111.3345118, 45),
(28, 3, 'Los Cabos', 'Los Cabos', NULL, 0.187357, 22.8905327, -109.9167371, 22.8718701, -109.9712988, 22.914768, -109.8935748, 57),
(31, 4, 'CalkinÃ', 'Calkini', NULL, 0.143945, 20.3666667, -90.05, 20.345036, -90.0659724, 20.388235, -90.0311719, 134),
(32, 4, 'Campeche', 'Campeche', NULL, 0.321401, 19.8454459, -90.5236731, 19.7848441, -90.6223751, 19.8763407, -90.4777941, 201),
(33, 4, 'Candelaria', 'Candelaria', NULL, 0.146992, 18.1859479, -91.0431269, 18.1769293, -91.0559306, 18.2039329, -91.0277653, 65),
(34, 4, 'Carmen', 'Carmen', NULL, 0.244097, 18.2666669, -91.8000001, 0, 0, 0, 0, 76),
(35, 4, 'ChampotÃ³n', 'Champoton', NULL, 0.115385, 19.3482882, -90.7177236, 19.3205393, -90.7432931, 19.3727979, -90.7044701, 28),
(36, 4, 'EscÃ¡rcega', 'Escarcega', NULL, 0.0974867, 18.6064587, -90.7378016, 18.5901873, -90.7718161, 18.6221351, -90.7198933, 0),
(37, 4, 'HecelchakÃ¡n', 'Hecelchakan', NULL, 0.0807312, 20.177339, -90.135364, 20.1610794, -90.1516057, 20.1978446, -90.1207168, 25),
(38, 4, 'HopelchÃ©n', 'Hopelchen', NULL, 0.0620716, 19.7472419, -89.8424644, 19.7404264, -89.8537601, 19.7547054, -89.8317169, 0),
(39, 4, 'Palizada', 'Palizada', NULL, 0.0559787, 18.2545777, -92.0914799, 0, 0, 0, 0, 27),
(40, 4, 'Tenabo', 'Tenabo', NULL, 0.11805, 20.0409674, -90.2255519, 20.0336317, -90.2346046, 20.0494829, -90.2166146, 0),
(42, 5, 'Acala', 'Acala', NULL, 0.0879665, 16.5534979, -92.8069456, 16.5489421, -92.8233259, 16.56524, -92.7926631, 32),
(44, 5, 'Aldama', 'Aldama', NULL, 0.129094, 16.0882855, -93.754243, 16.0836169, -93.7602575, 16.0923028, -93.7481908, 50),
(45, 5, 'Altamirano', 'Altamirano', NULL, 0.124143, 16.7342989, -92.0362219, 0, 0, 0, 0, 27),
(49, 5, 'Angel Albino Corzo', 'Angel Albino Corzo', NULL, 0.124905, 15.8722857, -92.7235766, 15.8661222, -92.7305529, 15.8772107, -92.7129899, 0),
(50, 5, 'Arriaga', 'Arriaga', NULL, 0.143945, 16.233817, -93.896297, 16.214917, -93.9254687, 16.2535968, -93.8630157, 197),
(53, 5, 'BenemÃ©rito de las AmÃ©ricas', 'Benemerito de las Americas', NULL, 0.0662605, 16.5142764, -90.6540954, 16.5041514, -90.6628814, 16.5253212, -90.6446629, 0),
(54, 5, 'BerriozÃ¡bal', 'Berriozabal', NULL, 0.159177, 16.8, -93.2666667, 16.7823062, -93.2844934, 16.8161837, -93.2430074, 26),
(55, 5, 'Bochil', 'Bochil', NULL, 0.0635948, 16.994722, -92.891994, 16.9880471, -92.9119508, 17.002322, -92.882566, 28),
(56, 5, 'CacahoatÃ¡n', 'Cacahoatan', NULL, 0.0894897, 14.9882917, -92.1651776, 14.9813789, -92.1771259, 15.0092864, -92.1521896, 0),
(57, 5, 'CatazajÃ¡', 'Catazaja', NULL, 0.0978675, 17.7235734, -92.0113139, 17.7129552, -92.01958, 17.7299537, -92.0062923, 0),
(58, 5, 'ChalchihuitÃ¡n', 'Chalchihuitan', NULL, 0.0464585, 16.965065, -92.6153361, 16.9550493, -92.6245522, 16.9750806, -92.6061201, 0),
(60, 5, 'Chanal', 'Chanal', NULL, 0.0708302, 16.6536697, -92.2560136, 16.6450174, -92.2634721, 16.6617772, -92.2499636, 0),
(63, 5, 'Chiapa de Corzo', 'Chiapa de Corzo', NULL, 0.157654, 16.7022364, -93.0082481, 16.6907085, -93.0583438, 16.7531004, -92.9776644, 32),
(66, 5, 'Chicomuselo', 'Chicomuselo', NULL, 0.0483625, 15.7427507, -92.2844891, 0, 0, 0, 0, 2),
(68, 5, 'Cintalapa', 'Cintalapa', NULL, 0.0670221, 16.6432854, -93.7622204, 0, 0, 0, 0, 41),
(70, 5, 'ComitÃ¡n de DomÃnguez', 'Comitan de Dominguez', NULL, 0.107007, 16.2497971, -92.1317436, 16.1967502, -92.164061, 16.2688245, -92.0960596, 0),
(71, 5, 'CopainalÃ¡', 'Copainala', NULL, 0.0993907, 17.092326, -93.209237, 17.0836959, -93.2176644, 17.1103192, -93.2018686, 0),
(72, 5, 'El Bosque', 'El Bosque', NULL, 0.13671, 17.0624692, -92.7209999, 0, 0, 0, 0, 103),
(74, 5, 'Escuintla', 'Escuintla', NULL, 0.116527, 15.3227892, -92.6576635, 0, 0, 0, 0, 24),
(76, 5, 'Frontera Comalapa', 'Frontera Comalapa', NULL, 0.0681645, 15.6582577, -92.1427249, 15.6457761, -92.1526051, 15.6738678, -92.1306187, 0),
(81, 5, 'Huixtla', 'Huixtla', NULL, 0.142041, 15.1385534, -92.4646701, 15.1247199, -92.4870064, 15.1588596, -92.4498328, 164),
(84, 12, 'ixtapa-zihuatanejo', 'ixtapa-zihuatanejo', 'playa', 0.244097, 17.6473381, -101.5269687, 17.6472358, -101.5487775, 17.6518175, -101.5216692, 50),
(86, 5, 'Jiquipilas', 'Jiquipilas', NULL, 0.06131, 16.6669137, -93.6501004, 16.660084, -93.6548571, 16.6747982, -93.640189, 0),
(88, 5, 'JuÃ¡rez', 'Juarez', NULL, 0.172506, 17.6121564, -93.1779266, 0, 0, 0, 0, 40),
(89, 5, 'La Concordia', 'La Concordia', NULL, 0.0209444, 16.1166427, -92.6881991, 16.1073119, -92.7079859, 16.1254684, -92.6747593, 15),
(91, 5, 'La Independencia', 'La Independencia', NULL, 0.019802, 16.5255199, -91.7737811, 0, 0, 0, 0, 39),
(92, 5, 'La Libertad', 'La Libertad', NULL, 0.151561, 17.6891622, -91.7190274, 0, 0, 0, 0, 156),
(93, 5, 'La Trinitaria', 'La Trinitaria', NULL, 0.0498858, 16.1202999, -92.0407031, 16.0974649, -92.0713214, 16.1455212, -92.017411, 0),
(95, 5, 'Las Margaritas', 'Las Margaritas', NULL, 0.118812, 16.3152778, -91.9816667, 16.3026782, -91.9902781, 16.3215389, -91.9716891, 0),
(96, 5, 'Las Rosas', 'Las Rosas', NULL, 0.0879665, 16.3607767, -92.3672906, 16.3560992, -92.3794829, 16.3767219, -92.3625459, 33),
(97, 5, 'Mapastepec', 'Mapastepec', NULL, 0.0498858, 15.4329682, -92.8978399, 15.4267812, -92.9080189, 15.4568757, -92.8845576, 0),
(98, 5, 'Maravilla Tenejapa', 'Maravilla Tenejapa', NULL, 0.130998, 16.1409664, -91.2927151, 16.1348793, -91.2993479, 16.1463807, -91.288662, 108),
(101, 5, 'MazatÃ¡n', 'Mazatan', NULL, 0.104722, 14.861665, -92.448493, 14.8519803, -92.460578, 14.8741174, -92.4407789, 0),
(104, 5, 'Montecristo de Guerrero', 'Montecristo de Guerrero', NULL, 0.119193, 16.768729, -93.1781365, 16.7601793, -93.1782456, 16.7892032, -93.1764487, 0),
(107, 5, 'Ocosingo', 'Ocosingo', NULL, 0.0666413, 16.9066667, -92.0938889, 16.892608, -92.1111601, 16.9215598, -92.0718347, 21),
(109, 5, 'Ocozocoautla de Espinosa', 'Ocozocoautla de Espinosa', NULL, 0.104722, 16.7581182, -93.3739204, 16.7401635, -93.393207, 16.7865879, -93.3574748, 0),
(113, 5, 'Palenque', 'Palenque', NULL, 0.163747, 17.5100299, -91.9814964, 17.4902668, -92.006916, 17.5581961, -91.9600101, 71),
(114, 5, 'PantelhÃ³', 'Pantelho', NULL, 0.0441736, 17.0069832, -92.4701674, 16.998501, -92.4791381, 17.0110613, -92.4616981, 0),
(116, 5, 'Pichucalco', 'Pichucalco', NULL, 0.0662605, 17.5081744, -93.1186601, 17.4979699, -93.1294349, 17.5272522, -93.0918936, 0),
(117, 5, 'Pijijiapan', 'Pijijiapan', NULL, 0.0441736, 15.6851709, -93.2122536, 15.6740047, -93.2163826, 15.6964304, -93.2015319, 0),
(120, 5, 'Reforma', 'Reforma', NULL, 0.214775, 17.8670517, -93.1473964, 17.8457207, -93.1801073, 17.8875212, -93.1377819, 72),
(124, 5, 'San CristÃ³bal de las Casas', 'San Cristobal de las Casas', NULL, 0.0860625, 16.737585, -92.636652, 16.6981205, -92.6840748, 16.7644581, -92.6007614, 58),
(125, 5, 'San Fernando', 'San Fernando', NULL, 0.134425, 16.8694312, -93.2070859, 16.8643657, -93.2119646, 16.8761569, -93.2016434, 27),
(127, 5, 'San Lucas', 'San Lucas', NULL, 0.0696877, 16.6087477, -92.7190246, 0, 0, 0, 0, 39),
(128, 5, 'Santiago el Pinar', 'Santiago el Pinar', NULL, 0.149276, 19.4215138, -102.0480323, 19.4179507, -102.0508561, 19.4256598, -102.0476592, 40),
(135, 5, 'Suchiapa', 'Suchiapa', NULL, 0.106626, 16.6238059, -93.1000854, 16.6048204, -93.1153881, 16.6398735, -93.0846274, 30),
(138, 5, 'Tapachula', 'Tapachula', NULL, 0.156512, 14.9, -92.2666667, 14.8647688, -92.3219781, 14.9579002, -92.2339038, 120),
(144, 5, 'Tila', 'Tila', NULL, 0.109673, 17.2997722, -92.4257972, 17.2922817, -92.433249, 17.311182, -92.4170661, 0),
(145, 5, 'TonalÃ¡', 'Tonala', NULL, 0.137852, 16.0867084, -93.7561196, 16.0699239, -93.7802838, 16.106783, -93.7339748, 22),
(148, 5, 'Tuxtla Chico', 'Tuxtla Chico', NULL, 0.143945, 14.9897499, -92.1565781, 0, 0, 0, 0, 260),
(149, 5, 'Tuxtla GutiÃ©rrez', 'Tuxtla Gutierrez', NULL, 0.0963442, 16.75, -93.1166667, 16.6850439, -93.2203016, 16.8070248, -93.0445526, 229),
(150, 5, 'TuzantÃ¡n', 'Tuzantan', NULL, 0.0963442, 15.1466592, -92.4224854, 15.1420611, -92.4268627, 15.1512573, -92.418108, 0),
(152, 5, 'UniÃ³n JuÃ¡rez', 'Union Juarez', NULL, 0.135187, 15.0645412, -92.0811838, 0, 0, 0, 0, 152),
(155, 5, 'Villa Corzo', 'Villa Corzo', NULL, 0.0399848, 16.1853857, -93.2681856, 16.1744851, -93.272207, 16.1911661, -93.2598147, 0),
(156, 5, 'Villaflores', 'Villaflores', NULL, 0.0807312, 16.232572, -93.265726, 16.2144222, -93.2878645, 16.2557753, -93.2249693, 0),
(157, 5, 'YajalÃ³n', 'Yajalon', NULL, 0.0388423, 17.175506, -92.335116, 17.1618521, -92.3443976, 17.1879207, -92.3208027, 34),
(158, 5, 'ZinacantÃ¡n', 'Zinacantan', NULL, 0.147753, 16.7594787, -92.7216306, 0, 0, 0, 0, 202),
(159, 6, 'Ahumada', 'Ahumada', NULL, 0.145849, 30.4109082, -107.9098871, 30.3957201, -107.9103769, 30.4261209, -107.9094624, 159),
(161, 6, 'Allende', 'Allende', NULL, 0.1508, 26.9142489, -105.4185031, 0, 0, 0, 0, 23),
(162, 6, 'Aquiles SerdÃ¡n', 'Aquiles Serdan', NULL, 0.14166, 28.5936841, -105.8873746, 0, 0, 0, 0, 193),
(163, 6, 'AscensiÃ³n', 'Ascension', NULL, 0.166032, 31.0927778, -107.9963889, 31.0742072, -108.0268236, 31.1068183, -107.9816753, 31),
(167, 6, 'Bocoyna', 'Bocoyna', NULL, 0.0601676, 27.8401224, -107.5832991, 0, 0, 0, 0, 37),
(168, 6, 'Buenaventura', 'Buenaventura', NULL, 0.103199, 29.8388499, -107.4702001, 0, 0, 0, 0, 29),
(169, 6, 'Camargo', 'Camargo', NULL, 0.169078, 28.6396892, -106.0788183, 28.637568, -106.0802727, 28.6417395, -106.0774474, 20),
(171, 6, 'Casas Grandes', 'Casas Grandes', NULL, 0.11805, 30.3776089, -107.9497751, 30.3684262, -107.9642991, 30.3915357, -107.9451961, 28),
(172, 6, 'Chihuahua', 'Chihuahua', NULL, 0.521706, 28.6352778, -106.0888889, 28.5586774, -106.167106, 28.7729082, -105.9612896, 315),
(174, 6, 'Coronado', 'Coronado', NULL, 0.201066, 28.6310384, -106.0760532, 28.6259475, -106.0808634, 28.6364025, -106.0713538, 55),
(175, 6, 'Coyame del Sotol', 'Coyame del Sotol', NULL, 0.107007, 28.6352778, -106.0888889, 28.5586774, -106.167106, 28.7729082, -105.9612896, 0),
(176, 6, 'CuauhtÃ©moc', 'Cuauhtemoc', NULL, 0.143945, 28.406612, -106.866509, 28.3739245, -106.9096027, 28.4531783, -106.8038059, 175),
(178, 6, 'Delicias', 'Delicias', NULL, 0.211348, 28.1833333, -105.4666667, 28.1533442, -105.5048266, 28.2190026, -105.4245854, 30),
(179, 6, 'Dr. Belisario DomÃnguez', 'Dr. Belisario Dominguez', NULL, 0.134806, 31.7051363, -106.4940252, 31.7050231, -106.4941114, 31.7063351, -106.4938423, 10),
(181, 6, 'Galeana', 'Galeana', NULL, 0.0898705, 30.1118377, -107.6136371, 0, 0, 0, 0, 36),
(182, 6, 'GÃ³mez FarÃas', 'Gomez Farias', NULL, 0.0765423, 29.3588269, -107.7362036, 29.3368264, -107.7481516, 29.3754099, -107.7241581, 0),
(184, 6, 'Guachochi', 'Guachochi', NULL, 0.049505, 26.8194444, -107.07, 26.8075902, -107.0909463, 26.8387444, -107.0580911, 0),
(185, 6, 'Guadalupe', 'Guadalupe', NULL, 0.199924, 31.3899646, -106.1050652, 0, 0, 0, 0, 66),
(188, 6, 'Guerrero', 'Guerrero', NULL, 0.112338, 28.5551399, -107.4924011, 0, 0, 0, 0, 36),
(189, 6, 'Hidalgo del Parral', 'Hidalgo del Parral', NULL, 0.154989, 26.9323162, -105.6666844, 26.9064654, -105.7246376, 26.9598194, -105.6313009, 0),
(191, 6, 'Ignacio Zaragoza', 'Ignacio Zaragoza', NULL, 0.0780655, 29.6459134, -107.7604514, 29.6355212, -107.7740739, 29.6517969, -107.7533794, 0),
(192, 6, 'Janos', 'Janos', NULL, 0.120716, 30.8889327, -108.1924159, 0, 0, 0, 0, 19),
(193, 6, 'JimÃ©nez', 'Jimenez', NULL, 0.175171, 27.1406589, -104.9157031, 0, 0, 0, 0, 71),
(194, 6, 'JuÃ¡rez', 'Juarez', NULL, 0.111577, 31.7311292, -106.4625624, 31.5612371, -106.5862237, 31.7795603, -106.2963333, 49),
(196, 6, 'La Cruz', 'La Cruz', NULL, 0.202589, 27.8622487, -105.1973931, 0, 0, 0, 0, 27),
(197, 6, 'LÃ³pez', 'Lopez', NULL, 0.124143, 29.1861976, -108.1332317, 29.1834555, -108.1389198, 29.1918896, -108.1173511, 56),
(198, 6, 'Madera', 'Madera', NULL, 0.172506, 29.19, -108.1413889, 29.1738767, -108.1609637, 29.2091827, -108.1152386, 31),
(201, 6, 'MatachÃ', 'Matachi', NULL, 0.049505, 28.6849847, -106.137139, 28.6843354, -106.1398855, 28.6869381, -106.1360896, 0),
(202, 6, 'Matamoros', 'Matamoros', NULL, 0.113481, 26.7602729, -105.5864736, 26.7544349, -105.5957394, 26.7704749, -105.5742621, 25),
(203, 6, 'Meoqui', 'Meoqui', NULL, 0.0868241, 28.2697374, -105.4808081, 28.2597309, -105.4930301, 28.2787292, -105.4690744, 0),
(204, 6, 'Morelos', 'Morelos', NULL, 0.175171, 28.6848643, -106.0820211, 28.6827996, -106.0835199, 28.6871307, -106.0795851, 41),
(205, 6, 'Moris', 'Moris', NULL, 0.102056, 28.1489782, -108.5192669, 0, 0, 0, 0, 36),
(206, 6, 'Namiquipa', 'Namiquipa', NULL, 0.0437928, 29.2497759, -107.4129114, 29.2430754, -107.4191214, 29.2566077, -107.4070766, 0),
(207, 6, 'Nonoava', 'Nonoava', NULL, 0.00913938, 27.4739917, -106.7372209, 0, 0, 0, 0, 10),
(208, 6, 'Nuevo Casas Grandes', 'Nuevo Casas Grandes', NULL, 0.107768, 30.4166667, -107.9, 30.377337, -107.9391094, 30.4649311, -107.8673529, 0),
(209, 6, 'Ocampo', 'Ocampo', NULL, 0.109292, 28.1912543, -108.364121, 0, 0, 0, 0, 37),
(214, 6, 'Rosario', 'Rosario', NULL, 0.214014, 28.6109512, -106.0743052, 28.6037782, -106.086437, 28.6157645, -106.0661666, 35),
(217, 6, 'San Francisco del Oro', 'San Francisco del Oro', NULL, 0.0251333, 26.861545, -105.852693, 26.8466027, -105.8583201, 26.8791536, -105.8329795, 0),
(218, 6, 'Santa BÃ¡rbara', 'Santa Barbara', NULL, 0.147372, 26.802297, -105.818849, 26.7918371, -105.830592, 26.8163388, -105.8112607, 124),
(219, 6, 'Santa Isabel', 'Santa Isabel', NULL, 0.063214, 28.3430077, -106.3664096, 0, 0, 0, 0, 45),
(221, 6, 'Saucillo', 'Saucillo', NULL, 0.0708302, 28.0304503, -105.2918467, 28.019971, -105.3051463, 28.0460138, -105.2830298, 0),
(222, 6, 'TemÃ³sachi', 'Temosachi', NULL, 0.000761615, 28.953, -107.829178, 0, 0, 0, 0, 79),
(223, 6, 'Urique', 'Urique', NULL, 0.0773039, 27.2104669, -107.9175444, 0, 0, 0, 0, 3),
(228, 7, 'Allende', 'Allende', NULL, 0.0571211, 28.34407, -100.851898, 28.3243001, -100.8815008, 28.3615633, -100.8315872, 38),
(229, 7, 'Arteaga', 'Arteaga', NULL, 0.166032, 25.4501332, -100.8490524, 25.4201633, -100.8931703, 25.4779127, -100.8058966, 33),
(230, 7, 'Candela', 'Candela', NULL, 0.149657, 26.8388667, -100.6658581, 0, 0, 0, 0, 49),
(232, 7, 'CuatrociÃ©negas', 'Cuatrocienegas', NULL, 0.0864433, 26.9865592, -102.0636864, 26.9725589, -102.0760286, 27.0008123, -102.048404, 0),
(233, 7, 'Escobedo', 'Escobedo', NULL, 0.14128, 27.2353087, -101.4129446, 27.2251804, -101.4187571, 27.2429484, -101.4060874, 54),
(234, 7, 'Francisco I. Madero', 'Francisco I. Madero', NULL, 0.0418888, 25.7722629, -103.2694309, 25.7425081, -103.2922043, 25.8228244, -103.2301965, 20),
(235, 7, 'Frontera', 'Frontera', NULL, 0.114623, 26.9279782, -101.4583701, 26.8960738, -101.4853706, 26.9801213, -101.4367733, 61),
(236, 7, 'General Cepeda', 'General Cepeda', NULL, 0.0742574, 25.3751299, -101.4739959, 25.3689414, -101.4818164, 25.3866277, -101.4664996, 0),
(237, 7, 'Guerrero', 'Guerrero', NULL, 0.0891089, 28.3089889, -100.3807826, 0, 0, 0, 0, 53),
(238, 7, 'Hidalgo', 'Hidalgo', NULL, 0.0662605, 27.7881397, -99.8741126, 27.7776807, -99.8855741, 27.7994214, -99.8593304, 25),
(239, 7, 'JimÃ©nez', 'Jimenez', NULL, 0.0205636, 29.0693962, -100.6771871, 29.0555921, -100.6869653, 29.0753082, -100.6681375, 28),
(240, 7, 'JuÃ¡rez', 'Juarez', NULL, 0.0251333, 27.6071402, -100.7263494, 27.5974229, -100.7336834, 27.6169914, -100.7210819, 74),
(241, 7, 'Lamadrid', 'Lamadrid', NULL, 0.0872049, 27.0505964, -101.7932329, 27.0446452, -101.8011531, 27.0609397, -101.7856544, 0),
(242, 7, 'Matamoros', 'Matamoros', NULL, 0.0674029, 25.5291939, -103.2245696, 25.5076786, -103.3145291, 25.5498145, -103.2116832, 62),
(243, 7, 'Monclova', 'Monclova', NULL, 0.153846, 26.9102778, -101.4222222, 26.833108, -101.4773008, 26.9824767, -101.3706325, 40),
(244, 7, 'Morelos', 'Morelos', NULL, 0.0281797, 28.4070929, -100.8850709, 28.3939947, -100.9008849, 28.4185839, -100.8752171, 76),
(245, 7, 'MÃºzquiz', 'Muzquiz', NULL, 0.0807312, 27.87549, -101.5177, 0, 0, 0, 0, 23),
(246, 7, 'Nadadores', 'Nadadores', NULL, 0.119573, 27.0253414, -101.5922319, 27.0150127, -101.6011944, 27.0357234, -101.5828959, 8),
(247, 7, 'Nava', 'Nava', NULL, 0.159939, 28.4212302, -100.7638814, 28.4070454, -100.7809629, 28.4340157, -100.7467294, 63),
(248, 7, 'Ocampo', 'Ocampo', NULL, 0.00380807, 27.3156234, -102.3965211, 27.3061152, -102.4019229, 27.3249409, -102.3901504, 22),
(249, 7, 'Parras', 'Parras', NULL, 0.133283, 25.441401, -102.174698, 25.4208054, -102.2172929, 25.4877001, -102.1416493, 16),
(250, 7, 'Piedras Negras', 'Piedras Negras', NULL, 0.163747, 28.6978762, -100.5246969, 28.6395989, -100.5892409, 28.7427731, -100.5002422, 163),
(251, 7, 'Progreso', 'Progreso', NULL, 0.13671, 27.4280199, -100.9877821, 27.4192144, -101.0007651, 27.4339259, -100.9766559, 21),
(252, 7, 'Ramos Arizpe', 'Ramos Arizpe', NULL, 0.137852, 25.540921, -100.943102, 25.4867236, -100.9873077, 25.6014494, -100.8922501, 23),
(253, 7, 'Sabinas', 'Sabinas', NULL, 0.153846, 27.86, -101.12, 27.8234286, -101.1760663, 27.908012, -101.0768877, 74),
(254, 7, 'Sacramento', 'Sacramento', NULL, 0.203732, 27.0033867, -101.7247054, 0, 0, 0, 0, 59),
(255, 7, 'Saltillo', 'Saltillo', NULL, 0.212871, 25.4333333, -100.9833333, 25.3333468, -101.0765134, 25.5228974, -100.8758674, 108),
(256, 7, 'San Buenaventura', 'San Buenaventura', NULL, 0.0430312, 27.060027, -101.546624, 27.0401443, -101.5629458, 27.0790888, -101.5229979, 61),
(258, 7, 'San Pedro', 'San Pedro', NULL, 0.152704, 25.75878, -102.977996, 25.7299804, -103.0171548, 25.7963196, -102.9522741, 63),
(260, 7, 'TorreÃ³n', 'Torreon', NULL, 0.1508, 25.5428443, -103.4067861, 25.476542, -103.4956784, 25.6313863, -103.3182547, 318),
(261, 7, 'Viesca', 'Viesca', NULL, 0.0498858, 25.3384294, -102.7998254, 25.3256327, -102.8099274, 25.3496804, -102.7926499, 0),
(262, 7, 'Villa UniÃ³n', 'Villa Union', NULL, 0.0125666, 28.2237682, -100.7255689, 28.2100344, -100.7411971, 28.2359849, -100.7135581, 0),
(263, 7, 'Zaragoza', 'Zaragoza', NULL, 0.135948, 28.4914094, -100.9195059, 28.4745531, -100.9444126, 28.5143227, -100.8998365, 135),
(264, 8, 'ArmerÃa', 'Armeria', NULL, 0.142041, 18.93372, -103.953201, 0, 0, 0, 0, 35),
(265, 8, 'Colima', 'Colima', NULL, 0.333968, 19.2433333, -103.7247222, 19.1987996, -103.7807025, 19.2802759, -103.6734973, 333),
(266, 8, 'Comala', 'Comala', NULL, 0.118812, 19.321304, -103.760888, 19.3015937, -103.769621, 19.3364678, -103.7428612, 0),
(267, 8, 'CoquimatlÃ¡n', 'Coquimatlan', NULL, 0.105103, 19.2049051, -103.8094057, 19.191574, -103.8219902, 19.2200645, -103.7987721, 0),
(268, 8, 'CuauhtÃ©moc', 'Cuauhtemoc', NULL, 0.0548363, 19.327951, -103.60181, 19.3118414, -103.6126875, 19.3388389, -103.5855994, 55),
(270, 8, 'Manzanillo', 'Manzanillo', NULL, 0.166032, 19.0522222, -104.3158333, 19.0150916, -104.4045596, 19.1403383, -104.2708589, 485),
(271, 8, 'MinatitlÃ¡n', 'Minatitlan', NULL, 0.0753998, 19.385179, -104.0503153, 0, 0, 0, 0, 26),
(272, 8, 'TecomÃ¡n', 'Tecoman', NULL, 0.107007, 18.91423, -103.875198, 18.8845321, -103.8997024, 18.9418914, -103.8554751, 63),
(273, 8, 'Villa de Alvarez', 'Villa de Alvarez', NULL, 0.049505, 19.2637632, -103.7460904, 19.2417148, -103.7642652, 19.3041988, -103.7155471, 22),
(274, 9, 'Ãlvaro ObregÃ³n', 'Alvaro Obregon', NULL, 0.140518, 19.3699466, -99.2231387, 19.3025226, -99.2987814, 19.4037577, -99.1718642, 134),
(275, 9, 'Azcapotzalco', 'Azcapotzalco', NULL, 0.150038, 19.482744, -99.183728, 19.4563572, -99.2211084, 19.515159, -99.1430547, 162),
(276, 9, 'Benito JuÃ¡rez', 'Benito Juarez', NULL, 0.167555, 19.3719833, -99.1578833, 19.3563837, -99.1919902, 19.4038457, -99.1309419, 53),
(277, 9, 'CoyoacÃ¡n', 'Coyoacan', NULL, 0.193831, 19.3494444, -99.1616667, 19.2967342, -99.2057979, 19.3594242, -99.0987905, 61),
(278, 9, 'Cuajimalpa', 'Cuajimalpa', NULL, 0.134806, 19.3578111, -99.2996694, 19.3495954, -99.3063271, 19.3649608, -99.285463, 42),
(279, 9, 'CuauhtÃ©moc', 'Cuauhtemoc', NULL, 0.0708302, 19.4204501, -99.1566855, 19.3995774, -99.1843743, 19.4657985, -99.1223088, 31),
(280, 9, 'Gustavo A. Madero', 'Gustavo A. Madero', NULL, 0.149657, 19.4822222, -99.1125, 19.4447905, -99.180424, 19.592743, -99.0509179, 156),
(281, 9, 'Iztacalco', 'Iztacalco', NULL, 0.161843, 19.3952778, -99.0977778, 19.375639, -99.1370669, 19.4221551, -99.0557688, 68),
(282, 9, 'Iztapalapa', 'Iztapalapa', NULL, 0.169459, 19.358065, -99.093647, 19.2847287, -99.1398969, 19.4007358, -98.9606166, 52),
(283, 9, 'La Magdalena Contreras', 'La Magdalena Contreras', NULL, 0.0795887, 19.316085, -99.2397606, 19.2806193, -99.2721087, 19.3378771, -99.2065878, 5),
(284, 9, 'Miguel Hidalgo', 'Miguel Hidalgo', NULL, 0.147372, 19.4182057, -99.2009815, 19.3859336, -99.2597294, 19.4732391, -99.1636556, 168),
(286, 9, 'TlÃ¡huac', 'Tlahuac', NULL, 0.175552, 19.268709, -99.005013, 19.2373517, -99.0690276, 19.3153998, -98.9845908, 47),
(287, 9, 'Tlalpan', 'Tlalpan', NULL, 0.176314, 19.308575, -99.224938, 19.2204621, -99.2469544, 19.3119399, -99.1010043, 74),
(288, 9, 'Venustiano Carranza', 'Venustiano Carranza', NULL, 0.0578827, 19.4395911, -99.1131054, 19.4374814, -99.1143699, 19.4405295, -99.1068025, 50),
(289, 9, 'Xochimilco', 'Xochimilco', NULL, 0.221249, 19.274285, -99.138374, 19.1887218, -99.1449214, 19.3188075, -99.0033005, 74),
(294, 10, 'Durango', 'Durango', NULL, 0.544554, 24.0277202, -104.6531759, 23.9633542, -104.7151846, 24.094567, -104.5754013, 183),
(295, 10, 'El Oro', 'El Oro', NULL, 0.143184, 25.5556493, -103.5399271, 25.5555815, -103.5399271, 25.5557973, -103.5390439, 142),
(296, 10, 'GÃ³mez Palacio', 'Gomez Palacio', NULL, 0.0552171, 25.56815, -103.491798, 25.5378936, -103.5423702, 25.6285341, -103.4427213, 57),
(298, 10, 'Guadalupe Victoria', 'Guadalupe Victoria', NULL, 0.0323686, 24.4429859, -104.1218422, 24.4262287, -104.1371406, 24.4598738, -104.1028629, 0),
(300, 10, 'Hidalgo', 'Hidalgo', NULL, 0.0894897, 24.0288096, -104.6742277, 24.018375, -104.6785733, 24.0405988, -104.6640533, 33),
(301, 10, 'IndÃ©', 'Inde', NULL, 0.119193, 25.9104779, -105.2214354, 0, 0, 0, 0, 30),
(302, 10, 'Lerdo', 'Lerdo', NULL, 0.153465, 24.0140976, -104.672363, 24.0100285, -104.6819638, 24.0182635, -104.6626527, 59),
(303, 10, 'MapimÃ', 'Mapimi', NULL, 0.0639756, 25.833708, -103.8487392, 25.8266717, -103.8562084, 25.8370202, -103.8389585, 0),
(307, 10, 'Nuevo Ideal', 'Nuevo Ideal', NULL, 0.00266565, 24.8874532, -105.0707236, 24.8731227, -105.0871754, 24.8973892, -105.0644156, 0),
(308, 10, 'Ocampo', 'Ocampo', NULL, 0.041508, 24.0072255, -104.6662523, 24.0069262, -104.6672678, 24.0078736, -104.6654787, 0),
(309, 10, 'OtÃ¡ez', 'Otaez', NULL, 0.0651181, 25.5862681, -103.5130326, 25.5857636, -103.5147646, 25.5865602, -103.5119569, 0),
(312, 10, 'Poanas', 'Poanas', NULL, 0.063214, 24.0754582, -104.586219, 24.0746983, -104.586219, 24.0754582, -104.5860796, 0),
(313, 10, 'Pueblo Nuevo', 'Pueblo Nuevo', NULL, 0.0773039, 25.2934687, -103.9984108, 25.289327, -104.0052509, 25.2977856, -103.9922047, 21),
(314, 10, 'Rodeo', 'Rodeo', NULL, 0.177837, 25.1809719, -104.5557836, 25.1715184, -104.5682259, 25.1872452, -104.5521404, 36),
(315, 10, 'San Bernardo', 'San Bernardo', NULL, 0.0190404, 26.0033309, -105.5233311, 0, 0, 0, 0, 15),
(318, 10, 'San Juan del RÃo', 'San Juan del Rio', NULL, 0.00190404, 24.7825839, -104.4575171, 24.7730659, -104.4769608, 24.7915573, -104.4494828, 0),
(319, 10, 'San Luis del Cordero', 'San Luis del Cordero', NULL, 0, 25.417115, -104.275006, 25.4082368, -104.2854881, 25.4221136, -104.2660904, 0),
(321, 10, 'Santa Clara', 'Santa Clara', NULL, 0.0194212, 24.4756229, -103.3568246, 24.4663889, -103.3726941, 24.4814902, -103.3476056, 49),
(322, 10, 'Santiago Papasquiaro', 'Santiago Papasquiaro', NULL, 0.0140899, 25.0438889, -105.4191667, 25.0250235, -105.4431759, 25.0725309, -105.3792211, 0),
(323, 10, 'SÃºchil', 'Suchil', NULL, 0.0552171, 23.626745, -103.921106, 23.6121266, -103.9397621, 23.6352461, -103.9116096, 38),
(328, 10, 'Vicente Guerrero', 'Vicente Guerrero', NULL, 0.0883473, 23.7310992, -103.9827511, 23.7178438, -104.0000465, 23.7470169, -103.9669616, 44),
(329, 11, 'Abasolo', 'Abasolo', NULL, 0.0213252, 20.4533454, -101.5312631, 20.4382332, -101.5477244, 20.4719843, -101.505761, 0),
(330, 11, 'Acambaro', 'Acambaro', NULL, 0.0677837, 20.0319362, -100.7205774, 19.9913418, -100.7436034, 20.0572029, -100.6786505, 140),
(331, 11, 'Apaseo el Alto', 'Apaseo el Alto', NULL, 0.0727342, 20.4571377, -100.6230181, 20.4434931, -100.6459834, 20.4719991, -100.602023, 59),
(332, 11, 'Apaseo el Grande', 'Apaseo el Grande', NULL, 0.0350343, 20.547963, -100.686923, 20.5343969, -100.701585, 20.5669523, -100.6609395, 39),
(334, 11, 'Celaya', 'Celaya', NULL, 0.152704, 20.5222222, -100.8122222, 20.4752186, -100.8633632, 20.5819439, -100.7730818, 629),
(335, 11, 'Comonfort', 'Comonfort', NULL, 0.0921554, 20.721002, -100.762027, 20.6880509, -100.7654188, 20.7437444, -100.7471446, 0),
(337, 11, 'Cortazar', 'Cortazar', NULL, 0.14166, 20.4827778, -100.9611111, 20.4626994, -100.9791004, 20.494315, -100.9390631, 152),
(338, 11, 'Cueramaro', 'Cueramaro', NULL, 0.0464585, 20.6267104, -101.6717014, 20.6106057, -101.6900781, 20.6409838, -101.6616442, 0),
(340, 11, 'Dolores Hidalgo', 'Dolores Hidalgo', NULL, 0.107388, 21.157049, -100.9347, 21.1393627, -100.9741008, 21.1783003, -100.8969771, 5),
(341, 11, 'Guanajuato', 'Guanajuato', NULL, 0.335491, 21.018111, -101.25832, 20.9985942, -101.2801804, 21.0516361, -101.2355382, 275),
(343, 11, 'Irapuato', 'Irapuato', NULL, 0.176695, 20.6786652, -101.3544964, 20.6455952, -101.3888124, 20.7096967, -101.3107281, 134),
(344, 11, 'Jaral del Progreso', 'Jaral del Progreso', NULL, 0.0715918, 20.375717, -101.066792, 20.3625266, -101.0847283, 20.3824368, -101.0534871, 0),
(345, 11, 'Jerecuaro', 'Jerecuaro', NULL, 0.0171363, 20.149719, -100.510002, 20.1310628, -100.5210288, 20.1649699, -100.5006665, 0),
(346, 11, 'LeÃ³n', 'Leon', NULL, 0.223153, 21.123619, -101.680496, 21.0303351, -101.7664194, 21.2130529, -101.5618105, 518),
(347, 11, 'Manuel Doblado', 'Manuel Doblado', NULL, 0.029703, 21.0140676, -101.2514445, 21.0134746, -101.2521337, 21.0144497, -101.2509143, 0),
(348, 11, 'Moroleon', 'Moroleon', NULL, 0.0971059, 20.131821, -101.202202, 20.1083216, -101.2154961, 20.1424674, -101.1780201, 61),
(349, 11, 'Ocampo', 'Ocampo', NULL, 0.00380807, 21.650021, -101.478092, 21.6342625, -101.4956193, 21.6589905, -101.4654135, 0),
(350, 11, 'Penjamo', 'Penjamo', NULL, 0.0853008, 20.4311111, -101.7222222, 20.4085676, -101.7417596, 20.445673, -101.6964464, 90),
(353, 11, 'Romita', 'Romita', NULL, 0.111577, 20.8751029, -101.5180731, 20.8585562, -101.5292944, 20.8852825, -101.5017029, 58),
(354, 11, 'Salamanca', 'Salamanca', NULL, 0.210206, 20.570391, -101.195646, 20.5275156, -101.2281405, 20.6054769, -101.1562111, 236),
(355, 11, 'Salvatierra', 'Salvatierra', NULL, 0.143184, 20.2133542, -100.8903986, 20.1879376, -100.9015389, 20.2408018, -100.8509143, 140),
(356, 11, 'San Diego de la Union', 'San Diego de la Union', NULL, 0.041508, 21.4655391, -100.8729354, 21.4557336, -100.8818988, 21.4763331, -100.8631863, 29),
(357, 11, 'San Felipe', 'San Felipe', NULL, 0.0270373, 21.482182, -101.214363, 21.4622241, -101.2351617, 21.4974555, -101.1947904, 49),
(358, 11, 'San Francisco del Rincon', 'San Francisco del Rincon', NULL, 0.0384615, 21.0205039, -101.8538614, 20.9942305, -101.8741439, 21.0473102, -101.8256629, 18),
(359, 11, 'San Jose Iturbide', 'San Jose Iturbide', NULL, 0.0319878, 20.998967, -100.385334, 20.9828055, -100.401361, 21.0213164, -100.372892, 133),
(360, 11, 'San Luis de la Paz', 'San Luis de la Paz', NULL, 0.0312262, 21.2959574, -100.5175346, 21.2759224, -100.5420578, 21.3103223, -100.4947232, 36),
(361, 11, 'San Miguel de Allende', 'San Miguel de Allende', NULL, 0.0696877, 20.9141667, -100.7441667, 20.8882407, -100.7729226, 20.9348625, -100.7138237, 82),
(363, 11, 'Santa Cruz de Juventino Rosas', 'Santa Cruz de Juventino Rosas', NULL, 0.0251333, 20.6423214, -100.9925574, 20.6350134, -101.0040136, 20.6487664, -100.9824604, 0),
(365, 11, 'Silao', 'Silao', NULL, 0.0932978, 20.952169, -101.426697, 20.9258477, -101.4480349, 20.9675281, -101.4076591, 51),
(366, 11, 'Tarandacuao', 'Tarandacuao', NULL, 0.0163747, 20, -100.5333333, 19.9922812, -100.5430241, 20.0159012, -100.4971851, 0),
(367, 11, 'Tarimoro', 'Tarimoro', NULL, 0.0468393, 20.2838509, -100.7566279, 20.2717743, -100.7697293, 20.3008553, -100.7390872, 62),
(368, 11, 'Tierra Blanca', 'Tierra Blanca', NULL, 0.053313, 21.0996872, -100.1584904, 0, 0, 0, 0, 11),
(369, 11, 'Uriangato', 'Uriangato', NULL, 0.0689261, 20.141043, -101.181179, 20.1049354, -101.1992613, 20.1649069, -101.1571277, 187),
(370, 11, 'Valle de Santiago', 'Valle de Santiago', NULL, 0.029703, 20.39411, -101.192902, 20.3696675, -101.2170163, 20.4181348, -101.1702037, 36),
(371, 11, 'Victoria', 'Victoria', NULL, 0.181645, 21.2114596, -100.2160835, 0, 0, 0, 0, 47),
(372, 11, 'Villagran', 'Villagran', NULL, 0.134425, 20.5110332, -100.9966166, 20.5083252, -101.0112585, 20.5245586, -100.98146, 19),
(374, 11, 'Yuriria', 'Yuriria', NULL, 0.0700685, 20.211951, -101.133287, 20.1990976, -101.1480933, 20.2225012, -101.1051218, 0),
(375, 12, 'Acapulco de JuÃ¡rez', 'Acapulco', NULL, 0.105103, 16.863794, -99.881614, 16.7386273, -100.0021797, 16.9284774, -99.7232419, 265),
(378, 12, 'AjuchitlÃ¡n del Progreso', 'Ajuchitlan del Progreso', NULL, 0.0293222, 18.154182, -100.499655, 18.1395268, -100.5207715, 18.1740226, -100.4910894, 0),
(381, 12, 'Apaxtla', 'Apaxtla', NULL, 0.0498858, 16.9014448, -99.8210806, 16.9010145, -99.8213376, 16.9014448, -99.8210806, 0),
(382, 12, 'Arcelia', 'Arcelia', NULL, 0.0327494, 18.3155367, -100.2823644, 18.2864038, -100.2971642, 18.340407, -100.2676408, 0),
(386, 12, 'Atoyac de Alvarez', 'Atoyac de Alvarez', NULL, 0.0175171, 17.2079518, -100.4326871, 17.1850387, -100.4473144, 17.2284054, -100.4177509, 23),
(387, 12, 'Ayutla de los Libres', 'Ayutla de los Libres', NULL, 0.000761615, 16.964797, -99.097161, 16.9531055, -99.1117102, 16.9811569, -99.0839543, 0),
(389, 12, 'Benito JuÃ¡rez', 'Benito Juarez', NULL, 0.00418888, 17.6944142, -99.3573149, 17.6525049, -99.3730555, 17.7374127, -99.335817, 34),
(391, 12, 'Chilapa de Alvarez', 'Chilapa de Alvarez', NULL, 0.00456969, 17.59629, -99.177056, 17.5827689, -99.1929937, 17.6141611, -99.1584625, 0),
(392, 12, 'Chilpancingo de los Bravo', 'Chilpancingo de los Bravo', NULL, 0.0357959, 17.55, -99.5, 17.502045, -99.5323081, 17.5971949, -99.4661663, 0),
(396, 12, 'Copala', 'Copala', NULL, 0.00304646, 16.604531, -98.975246, 16.5937095, -98.9885303, 16.6187754, -98.9587144, 0),
(400, 12, 'Coyuca de CatalÃ¡n', 'Coyuca de Catalan', NULL, 0.0152323, 18.3255556, -100.6991667, 18.3098162, -100.7157117, 18.3404982, -100.6885557, 0),
(401, 12, 'Cuajinicuilapa', 'Cuajinicuilapa', NULL, 0.00190404, 16.469833, -98.413802, 16.4563918, -98.4312799, 16.4855104, -98.393623, 0),
(406, 12, 'Eduardo Neri', 'Eduardo Neri', NULL, 0.0346535, 16.8929556, -99.825239, 16.8901806, -99.8269319, 16.8964297, -99.8229549, 0),
(407, 12, 'Florencio Villarreal', 'Florencio Villarreal', NULL, 0.000761615, 16.7293446, -99.126048, 16.7242535, -99.1287894, 16.7338874, -99.1238428, 0),
(411, 12, 'Huitzuco de los Figueroa', 'Huitzuco de los Figueroa', NULL, 0.00266565, 18.3107676, -99.3298504, 18.3103902, -99.3304233, 18.3110766, -99.3291504, 0),
(412, 12, 'Iguala de la Independencia', 'Iguala de la Independencia', NULL, 0.039604, 18.35, -99.5333333, 18.3079826, -99.5869989, 18.3883979, -99.4585019, 11),
(415, 12, 'JosÃ© Azueta', 'Jose Azueta', NULL, 0.0213252, 18.3700762, -99.8732634, 18.3692733, -99.8733753, 18.3702701, -99.8728983, 0),
(416, 12, 'JosÃ© Joaquin de Herrera', 'Jose Joaquin de Herrera', NULL, 0.0540746, 19.4388687, -99.126615, 19.4385655, -99.1296048, 19.4391119, -99.1236237, 58),
(417, 12, 'Juan R. Escudero', 'Juan R. Escudero', NULL, 0.0342727, 16.8979148, -99.8254311, 16.8960493, -99.8295205, 16.9036132, -99.8193743, 0),
(419, 12, 'Leonardo Bravo', 'Leonardo Bravo', NULL, 0.00761615, 18.2963074, -99.3377104, 18.2951446, -99.3382635, 18.297525, -99.3371467, 0),
(421, 12, 'Marquelia', 'Marquelia', NULL, 0.0114242, 16.5833333, -98.8166667, 16.5731017, -98.8241706, 16.6036023, -98.7961559, 44),
(422, 12, 'MÃ¡rtir de Cuilapan', 'Martir de Cuilapan', NULL, 0.0251333, 17.5744968, -99.3999284, 17.5736511, -99.40169, 17.574641, -99.3983045, 0),
(426, 12, 'Ometepec', 'Ometepec', NULL, 0.000761615, 16.6854532, -98.4054066, 16.6735561, -98.436071, 16.7075841, -98.3900768, 0),
(427, 12, 'Pedro Ascencio Alquisiras', 'Pedro Ascencio Alquisiras', NULL, 0.00418888, 17.5758542, -99.3928478, 17.5753615, -99.3948159, 17.5766679, -99.3908077, 0),
(428, 12, 'PetatlÃ¡n', 'Petatlan', NULL, 0.00228484, 17.5367232, -101.2668699, 17.5198971, -101.2930042, 17.5570078, -101.2452961, 0),
(430, 12, 'Pungarabato', 'Pungarabato', NULL, 0.00418888, 18.3540989, -100.6570927, 18.3467045, -100.6661283, 18.3611441, -100.648209, 0),
(432, 12, 'San Luis AcatlÃ¡n', 'San Luis Acatlan', NULL, 0.000380807, 16.8070694, -98.7350079, 16.8025729, -98.7450169, 16.8154159, -98.7233444, 0),
(433, 12, 'San Marcos', 'San Marcos', NULL, 0.0121858, 16.7949714, -99.3883874, 16.7874437, -99.3955909, 16.8017384, -99.3809521, 40),
(435, 12, 'Taxco de AlarcÃ³n', 'Taxco de Alarcon', NULL, 0.0312262, 18.5563889, -99.605, 18.5320447, -99.6272564, 18.5799773, -99.5906178, 15),
(437, 12, 'TÃ©cpan de Galeana', 'Tecpan de Galeana', NULL, 0.0125666, 17.2195397, -100.6297054, 17.1895764, -100.6395958, 17.2369436, -100.6187729, 0),
(438, 12, 'Teloloapan', 'Teloloapan', NULL, 0.0224676, 18.3663079, -99.8736474, 18.3444591, -99.8844282, 18.3849525, -99.8504707, 65),
(439, 12, 'Tepecoacuilco de Trujano', 'Tepecoacuilco de Trujano', NULL, 0.000761615, 18.2856297, -99.4645799, 18.2736877, -99.4735994, 18.2928904, -99.4565806, 0),
(441, 12, 'Tixtla de Guerrero', 'Tixtla de Guerrero', NULL, 0.0354151, 17.5666667, -99.4, 17.5498673, -99.4142215, 17.5815417, -99.3835759, 18),
(446, 12, 'Tlapa de Comonfort', 'Tlapa de Comonfort', NULL, 0.00495049, 17.5464224, -98.5745759, 17.5228705, -98.6026984, 17.5796525, -98.5383352, 0),
(447, 12, 'Tlapehuala', 'Tlapehuala', NULL, 0.000761615, 18.242478, -100.535384, 18.2276541, -100.5529301, 18.2544052, -100.5201356, 0),
(454, 13, 'AcatlÃ¡n', 'Acatlan', NULL, 0.043412, 20.1507392, -98.4472959, 20.1349246, -98.458786, 20.1594206, -98.4217072, 0),
(456, 13, 'Actopan', 'Actopan', NULL, 0.0346535, 20.2689007, -98.9492994, 20.254372, -98.9745831, 20.2927099, -98.9253939, 49),
(457, 13, 'Agua Blanca de Iturbide', 'Agua Blanca de Iturbide', NULL, 0.0342727, 17.0657117, -96.7391997, 17.0653079, -96.7394635, 17.0659892, -96.7390999, 0),
(458, 13, 'Ajacuba', 'Ajacuba', NULL, 0.00418888, 20.092443, -99.119489, 20.0761043, -99.1340213, 20.1083018, -99.1072767, 0),
(461, 13, 'Apan', 'Apan', NULL, 0.0270373, 19.707681, -98.449238, 19.6942216, -98.4791094, 19.7263315, -98.4367238, 53),
(462, 13, 'Atitalaquia', 'Atitalaquia', NULL, 0.0331302, 20.0573086, -99.2212804, 20.0389824, -99.2261511, 20.0686593, -99.2068753, 71),
(464, 13, 'Atotonilco de Tula', 'Atotonilco de Tula', NULL, 0.031607, 20.008329, -99.2197717, 19.9892363, -99.2364515, 20.023948, -99.209357, 0),
(465, 13, 'Atotonilco el Grande', 'Atotonilco el Grande', NULL, 0.0228484, 20.286942, -98.66792, 20.2696725, -98.6787213, 20.2980872, -98.6417948, 0),
(471, 13, 'Cuautepec de Hinojosa', 'Cuautepec de Hinojosa', NULL, 0.0300838, 20.0342177, -98.3100324, 20.0084795, -98.3484251, 20.0664768, -98.2948939, 0),
(474, 13, 'Emiliano Zapata', 'Emiliano Zapata', NULL, 0.0205636, 19.653763, -98.545831, 19.6395509, -98.5582495, 19.6679772, -98.5351187, 0),
(476, 13, 'Francisco I. Madero', 'Francisco I. Madero', NULL, 0.000761615, 25.8150702, -103.2879936, 25.8127593, -103.2922043, 25.8228244, -103.2744176, 0),
(478, 13, 'Huautla', 'Huautla', NULL, 0.000380807, 21.0331566, -98.2862664, 21.0213802, -98.2939911, 21.0449331, -98.2785416, 0),
(481, 13, 'Huejutla de Reyes', 'Huejutla de Reyes', NULL, 0.0312262, 21.143739, -98.418111, 21.1208351, -98.4347582, 21.1638545, -98.3792096, 0),
(482, 13, 'Huichapan', 'Huichapan', NULL, 0.0304646, 20.3733333, -99.6488889, 20.3565614, -99.6652493, 20.3923674, -99.6337494, 63),
(483, 13, 'Ixmiquilpan', 'Ixmiquilpan', NULL, 0.0399848, 20.4831412, -99.2171174, 20.4574357, -99.2484434, 20.5203529, -99.1949713, 59),
(489, 13, 'Metepec', 'Metepec', NULL, 0.0201828, 20.2402534, -98.3256119, 0, 0, 0, 0, 28),
(492, 13, 'Mineral del Chico', 'Mineral del Chico', NULL, 0.0308454, 20.2156264, -98.7301399, 0, 0, 0, 0, 52),
(493, 13, 'Mineral del Monte', 'Mineral del Monte', NULL, 0.0319878, 20.1382299, -98.6735591, 20.130143, -98.6924163, 20.1508379, -98.6631563, 0),
(494, 13, 'Mixquiahuala de JuÃ¡rez', 'Mixquiahuala de Juarez', NULL, 0.0346535, 20.2311111, -99.2130556, 20.1929909, -99.2530167, 20.2522176, -99.1953016, 0),
(499, 13, 'Pachuca de Soto', 'Pachuca de Soto', NULL, 0.0403656, 20.1153012, -98.7458874, 20.0371324, -98.8029967, 20.1415995, -98.7109342, 0),
(502, 13, 'Progreso de ObregÃ³n', 'Progreso de Obregon', NULL, 0.0346535, 20.247297, -99.189869, 20.2304305, -99.2024561, 20.2652927, -99.17261, 0),
(506, 13, 'San Felipe OrizatlÃ¡n', 'San Felipe Orizatlan', NULL, 0.00190404, 21.171375, -98.607848, 21.1608024, -98.6242631, 21.1773846, -98.5898054, 0),
(507, 13, 'San Salvador', 'San Salvador', NULL, 0.0426504, 20.2855429, -99.0131349, 0, 0, 0, 0, 40),
(509, 13, 'Santiago Tulantepec de Lugo Guerre', 'Santiago Tulantepec de Lugo Guer', NULL, 0.0304646, 20.0388854, -98.3572539, 20.0385337, -98.3593705, 20.0392458, -98.3551097, 0),
(512, 13, 'Tecozautla', 'Tecozautla', NULL, 0.0140899, 20.5326359, -99.6323321, 20.5221262, -99.6531126, 20.5452047, -99.6271769, 0),
(514, 13, 'Tepeapulco', 'Tepeapulco', NULL, 0.0319878, 19.7855995, -98.5530769, 19.7674398, -98.5689202, 19.8010005, -98.5331217, 0),
(516, 13, 'Tepeji del RÃo de Ocampo', 'Tepeji del Rio de Ocampo', NULL, 0.029703, 19.9001205, -99.3416352, 19.881303, -99.3600032, 19.9142954, -99.3272203, 43),
(518, 13, 'Tetepango', 'Tetepango', NULL, 0.0338918, 20.102373, -99.156524, 20.0865124, -99.1668968, 20.1248731, -99.1287868, 0),
(519, 13, 'Tezontepec de Aldama', 'Tezontepec de Aldama', NULL, 0.00152323, 20.18403, -99.2702429, 20.1753487, -99.2841189, 20.1946137, -99.2613181, 0),
(521, 13, 'Tizayuca', 'Tizayuca', NULL, 0.0418888, 19.8333333, -98.9833333, 19.8120839, -99.0031477, 19.8621118, -98.9495386, 102),
(522, 13, 'Tlahuelilpan', 'Tlahuelilpan', NULL, 0.0342727, 20.1302, -99.2301827, 20.1184878, -99.242682, 20.1454853, -99.2184555, 0),
(524, 13, 'Tlanalapa', 'Tlanalapa', NULL, 0.0331302, 19.8180843, -98.6031978, 19.802682, -98.6142154, 19.8327017, -98.5910516, 0),
(526, 13, 'Tlaxcoapan', 'Tlaxcoapan', NULL, 0.0327494, 20.0952778, -99.22, 20.0751335, -99.2345431, 20.1029199, -99.1999987, 43),
(527, 13, 'Tolcayuca', 'Tolcayuca', NULL, 0.0300838, 19.9552354, -98.9201124, 19.946631, -98.9328291, 19.9679599, -98.9055686, 0),
(528, 13, 'Tula de Allende', 'Tula de Allende', NULL, 0.033511, 20.0517122, -99.3451227, 20.0365662, -99.3624898, 20.072993, -99.3238856, 29),
(529, 13, 'Tulancingo de Bravo', 'Tulancingo de Bravo', NULL, 0.0331302, 20.0815169, -98.3672781, 20.0692134, -98.3801834, 20.0970832, -98.3428326, 0),
(530, 13, 'Villa de Tezontepec', 'Villa de Tezontepec', NULL, 0.00190404, 19.8909317, -98.8173995, 19.8907202, -98.818311, 19.8911853, -98.8165135, 0),
(535, 13, 'ZapotlÃ¡n de JuÃ¡rez', 'Zapotlan de Juarez', NULL, 0.00342727, 19.9718701, -98.8611324, 19.9655006, -98.8798464, 20.001612, -98.8526858, 0),
(536, 13, 'Zempoala', 'Zempoala', NULL, 0.0281797, 19.9169605, -98.6696977, 19.8967771, -98.6951099, 19.9241528, -98.6428191, 68),
(537, 13, 'ZimapÃ¡n', 'Zimapan', NULL, 0.00799695, 20.739149, -99.383438, 20.7255356, -99.3983498, 20.753401, -99.3627736, 0),
(538, 14, 'Acatic', 'Acatic', NULL, 0.0121858, 20.7807144, -102.9096364, 20.7665058, -102.9227817, 20.7973499, -102.8974442, 0),
(539, 14, 'AcatlÃ¡n de JuÃ¡rez', 'Acatlan de Juarez', NULL, 0.0266565, 20.4230629, -103.5890464, 20.4070999, -103.6103843, 20.4338356, -103.5813068, 0),
(540, 14, 'Ahualulco de Mercado', 'Ahualulco de Mercado', NULL, 0.00875857, 20.7020397, -103.9737251, 20.6850663, -103.9916744, 20.7159484, -103.9469034, 0),
(542, 14, 'AmatitÃ¡n', 'Amatitan', NULL, 0.0247525, 20.8331927, -103.7316526, 20.8232769, -103.7442236, 20.8489973, -103.7195498, 87),
(543, 14, 'Ameca', 'Ameca', NULL, 0.029703, 20.5469307, -104.0474574, 20.5172975, -104.0729998, 20.5601001, -104.0215189, 19),
(544, 14, 'San Juanito de Escobedo', 'San Juanito de Escobedo', NULL, 0.00990099, 20.7986229, -104.0030594, 20.7836728, -104.0124769, 20.8084452, -103.9922702, 0),
(545, 14, 'Arandas', 'Arandas', NULL, 0.0361767, 20.7042032, -102.3460299, 20.6816798, -102.3624863, 20.7244482, -102.3183317, 51),
(546, 14, 'El Arenal', 'El Arenal', NULL, 0.0460777, 20.77898, -103.691239, 20.7560815, -103.7071644, 20.7854096, -103.6845803, 0),
(547, 14, 'Atemajac de Brizuela', 'Atemajac de Brizuela', NULL, 0.0133283, 20.1386377, -103.7263471, 20.1284869, -103.7356499, 20.1462299, -103.7174569, 0),
(550, 14, 'Atotonilco el Alto', 'Atotonilco el Alto', NULL, 0.0277989, 20.5526932, -102.5081071, 20.5366074, -102.539076, 20.5694717, -102.4892681, 0),
(551, 14, 'Atoyac', 'Atoyac', NULL, 0.0224676, 20.010138, -103.519033, 20.0019103, -103.5308375, 20.0174813, -103.5061482, 17),
(552, 14, 'AutlÃ¡n de Navarro', 'Autlan de Navarro', NULL, 0.0369383, 19.7670869, -104.3660951, 19.7366177, -104.3855179, 19.7996583, -104.3452395, 0),
(553, 14, 'AyotlÃ¡n', 'Ayotlan', NULL, 0.0194212, 20.5289932, -102.3258256, 20.5215736, -102.3432151, 20.5460457, -102.3210564, 0),
(554, 14, 'Ayutla', 'Ayutla', NULL, 0.00304646, 20.1281719, -104.3440726, 20.1195951, -104.355793, 20.1438186, -104.3318785, 0),
(555, 14, 'La Barca', 'La Barca', NULL, 0.053313, 20.2908132, -102.5458454, 20.2611731, -102.5631091, 20.3152988, -102.5205079, 113),
(556, 14, 'BolaÃ±os', 'Bolaños', NULL, 0.00952018, 0, 0, 0, 0, 0, 0, 15),
(558, 14, 'Casimiro Castillo', 'Casimiro Castillo', NULL, 0.00418888, 19.6041227, -104.4345056, 19.5954207, -104.4455276, 19.6111107, -104.4262626, 0),
(559, 14, 'CihuatlÃ¡n', 'Cihuatlan', NULL, 0.0247525, 19.2369632, -104.5655654, 19.2291248, -104.581206, 19.2495864, -104.5488282, 42),
(561, 14, 'Cocula', 'Cocula', NULL, 0.0175171, 20.3644174, -103.8235871, 20.347237, -103.8427061, 20.37966, -103.8107059, 0),
(562, 14, 'ColotlÃ¡n', 'Colotlan', NULL, 0.0156131, 22.111411, -103.263544, 22.0979013, -103.2822678, 22.1276099, -103.2498612, 0),
(565, 14, 'Cuautla', 'Cuautla', NULL, 0.0114242, 20.2028479, -104.4051706, 0, 0, 0, 0, 50),
(567, 14, 'Chapala', 'Chapala', NULL, 0.0445545, 20.2970595, -103.188891, 20.284285, -103.2072895, 20.3097521, -103.1761418, 72),
(570, 14, 'Degollado', 'Degollado', NULL, 0.00418888, 20.4477559, -102.1328381, 20.4370763, -102.1482702, 20.4606377, -102.1211913, 0),
(572, 14, 'EncarnaciÃ³n de DÃaz', 'Encarnacion de Diaz', NULL, 0.0251333, 21.5166667, -102.2333333, 21.5049737, -102.2523371, 21.5385772, -102.2210034, 50),
(573, 14, 'EtzatlÃ¡n', 'Etzatlan', NULL, 0.0102818, 20.7647052, -104.0792844, 20.7572093, -104.0959673, 20.7796816, -104.059415, 0),
(574, 14, 'El Grullo', 'El Grullo', NULL, 0.0319878, 19.805681, -104.217331, 19.7947242, -104.2342784, 19.8211927, -104.1980038, 0),
(576, 14, 'Guadalajara', 'Guadalajara', NULL, 0.313785, 20.67359, -103.343803, 20.6037373, -103.4070646, 20.7438465, -103.2637617, 490),
(580, 14, 'La Huerta', 'La Huerta', NULL, 0.0205636, 19.4811052, -104.6442073, 19.4718265, -104.6578934, 19.4920162, -104.6271899, 0),
(581, 14, 'IxtlahuacÃ¡n de los Membrillos', 'Ixtlahuacan de los Membrillos', NULL, 0.0312262, 20.3484379, -103.193002, 20.3393201, -103.2071988, 20.359887, -103.1829828, 0),
(582, 14, 'IxtlahuacÃ¡n del RÃo', 'Ixtlahuacan del Rio', NULL, 0.00190404, 20.8638517, -103.2410048, 20.8526469, -103.2524277, 20.8722724, -103.2268543, 0),
(583, 14, 'JalostotitlÃ¡n', 'Jalostotitlan', NULL, 0.0175171, 21.1678232, -102.4673749, 21.1539735, -102.4843621, 21.1843331, -102.4499163, 0),
(584, 14, 'Jamay', 'Jamay', NULL, 0.0323686, 20.294439, -102.711197, 20.2828523, -102.7233256, 20.3046856, -102.6964763, 0),
(585, 14, 'JesÃºs MarÃa', 'Jesus Maria', NULL, 0.00990099, 20.609455, -102.216766, 20.5959777, -102.2291297, 20.6173183, -102.2095525, 28),
(587, 14, 'Jocotepec', 'Jocotepec', NULL, 0.0357959, 20.2856051, -103.4279703, 20.2686503, -103.4518645, 20.2934181, -103.4104335, 0),
(588, 14, 'JuanacatlÃ¡n', 'Juanacatlan', NULL, 0.0346535, 20.5084132, -103.1684561, 20.4924118, -103.1760929, 20.5229444, -103.159173, 0),
(590, 14, 'Lagos de Moreno', 'Lagos de Moreno', NULL, 0.0407464, 21.3579529, -101.9303604, 21.3309694, -101.9695127, 21.3807217, -101.8696549, 0),
(591, 14, 'El LimÃ³n', 'El Limon', NULL, 0.0426504, 19.8253592, -104.1551981, 0, 0, 0, 0, 133),
(592, 14, 'Magdalena', 'Magdalena', NULL, 0.0239909, 20.9083749, -103.9798274, 20.8967428, -103.9978131, 20.925481, -103.954703, 38),
(593, 14, 'Santa MarÃa del Oro', 'Santa Maria del Oro', NULL, 0.000761615, 25.9486904, -105.3650805, 25.9462038, -105.3725841, 25.950522, -105.3633612, 0),
(595, 14, 'Mascota', 'Mascota', NULL, 0.0304646, 20.5260029, -104.7892254, 20.5140515, -104.810753, 20.5429486, -104.7783794, 0),
(596, 14, 'Mazamitla', 'Mazamitla', NULL, 0.0453161, 19.9143297, -103.0203341, 19.9063346, -103.0340021, 19.9326895, -103.0102284, 41),
(600, 14, 'San Ignacio Cerro Gordo', 'San Ignacio Cerro Gordo', NULL, 0.0053313, 20.7456929, -102.5353526, 20.7316086, -102.5461351, 20.7522228, -102.5243684, 0),
(601, 14, 'OcotlÃ¡n', 'Ocotlan', NULL, 0.0411272, 20.34881, -102.770203, 20.296374, -102.7879828, 20.3803216, -102.7510764, 76),
(603, 14, 'Pihuamo', 'Pihuamo', NULL, 0.00190404, 19.2532297, -103.3784301, 19.2422333, -103.3944412, 19.2651774, -103.3692772, 0),
(604, 14, 'PoncitlÃ¡n', 'Poncitlan', NULL, 0.00418888, 20.3793509, -102.9261621, 20.3735599, -102.9336221, 20.3877992, -102.9163454, 0),
(605, 14, 'Puerto Vallarta', 'Puerto Vallarta', NULL, 0.145468, 20.6220182, -105.2284566, 20.5814442, -105.2710005, 20.6995918, -105.1786187, 387),
(608, 14, 'El Salto', 'El Salto', NULL, 0.0491241, 20.5174767, -103.1810881, 20.5045798, -103.2018916, 20.5340265, -103.1714189, 0),
(611, 14, 'San Juan de los Lagos', 'San Juan de los Lagos', NULL, 0.0453161, 21.2474689, -102.3316999, 21.2261043, -102.356412, 21.274831, -102.3026574, 51),
(612, 14, 'San JuliÃ¡n', 'San Julian', NULL, 0.00990099, 21.010776, -102.179945, 20.9873514, -102.2012415, 21.0227317, -102.1646024, 0),
(615, 14, 'San MartÃn de Hidalgo', 'San Martin de Hidalgo', NULL, 0, 20.4589781, -103.8911999, 20.3164174, -104.0414715, 20.5877954, -103.7899017, 0),
(616, 14, 'San Miguel el Alto', 'San Miguel el Alto', NULL, 0.0243717, 21.0297575, -102.4040252, 21.0173476, -102.4195533, 21.0539135, -102.3868244, 0),
(619, 14, 'Santa MarÃa de los Ãngeles', 'Santa Maria de los Angeles', NULL, 0.00190404, 22.1736132, -103.2249659, 22.1622427, -103.2379891, 22.1815684, -103.2199491, 10),
(620, 14, 'Sayula', 'Sayula', NULL, 0.0304646, 19.8828604, -103.5998064, 19.8655013, -103.6116002, 19.8961222, -103.5793341, 65),
(621, 14, 'Tala', 'Tala', NULL, 0.0338918, 20.651469, -103.707459, 20.6382711, -103.7191307, 20.672116, -103.6859102, 150),
(622, 14, 'Talpa de Allende', 'Talpa de Allende', NULL, 0.00456969, 20.3805556, -104.8222222, 20.3673924, -104.8306536, 20.4000438, -104.8077745, 0),
(623, 14, 'Tamazula de Gordiano', 'Tamazula de Gordiano', NULL, 0.0274181, 19.6801429, -103.2490716, 19.6617052, -103.2686033, 19.7132105, -103.2143989, 0);
INSERT INTO `ciudad` (`id_ciudad`, `id_estado`, `nombre`, `nombre_coloquial`, `tags`, `popularidad`, `lat`, `lng`, `bsw_lat`, `bsw_lng`, `bne_lat`, `bne_lng`, `vistas`) VALUES
(624, 14, 'Tapalpa', 'Tapalpa', NULL, 0.0346535, 19.945419, -103.759399, 19.9334406, -103.7788775, 19.9572838, -103.7476747, 0),
(625, 14, 'TecalitlÃ¡n', 'Tecalitlan', NULL, 0.00456969, 19.470046, -103.306022, 19.4553497, -103.3191415, 19.4828533, -103.296128, 0),
(626, 14, 'TecolotlÃ¡n', 'Tecolotlan', NULL, 0.0163747, 20.2006949, -104.0451326, 20.1842393, -104.0650704, 20.2147397, -104.0265124, 0),
(629, 14, 'Teocaltiche', 'Teocaltiche', NULL, 0.0053313, 21.4358077, -102.5749559, 21.4115778, -102.5891501, 21.4540239, -102.5575333, 0),
(631, 14, 'TepatitlÃ¡n de Morelos', 'Tepatitlan de Morelos', NULL, 0.0312262, 20.81024, -102.761703, 20.7829101, -102.7923169, 20.8356893, -102.7342532, 0),
(632, 14, 'Tequila', 'Tequila', NULL, 0.0540746, 20.8827778, -103.8366667, 20.8634786, -103.84829, 20.9040415, -103.8057165, 30),
(634, 14, 'TizapÃ¡n el Alto', 'Tizapan el Alto', NULL, 0.00304646, 20.1583159, -103.0456479, 20.1412344, -103.0656689, 20.1755459, -103.0315018, 0),
(636, 14, 'Tlaquepaque', 'Tlaquepaque', NULL, 0.0472201, 20.6333333, -103.3166667, 20.5627918, -103.4309392, 20.6467177, -103.2561279, 72),
(638, 14, 'TomatlÃ¡n', 'Tomatlan', NULL, 0.00266565, 19.941353, -105.249539, 19.9265045, -105.2603843, 19.9469659, -105.2388244, 0),
(639, 14, 'TonalÃ¡', 'Tonala', NULL, 0.0403656, 20.6815855, -103.2656264, 20.6772781, -103.2683873, 20.6848637, -103.2624597, 27),
(642, 14, 'Totatiche', 'Totatiche', NULL, 0.000380807, 21.9303774, -103.4427766, 21.9237906, -103.4510422, 21.9364103, -103.4317732, 0),
(643, 14, 'TototlÃ¡n', 'Tototlan', NULL, 0.0140899, 20.5422584, -102.7933826, 20.5304873, -102.8064156, 20.550783, -102.7815825, 0),
(646, 14, 'Tuxpan', 'Tuxpan', NULL, 0.0323686, 19.5549937, -103.3756781, 19.5429519, -103.3947977, 19.5749809, -103.361007, 47),
(647, 14, 'UniÃ³n de San Antonio', 'Union de San Antonio', NULL, 0.00190404, 21.128, -102.006, 21.1178692, -102.0185603, 21.1392988, -101.9953226, 0),
(648, 14, 'UniÃ³n de Tula', 'Union de Tula', NULL, 0.00456969, 19.9560674, -104.2686501, 19.9468962, -104.2795679, 19.9668857, -104.2565674, 0),
(649, 14, 'Valle de Guadalupe', 'Valle de Guadalupe', NULL, 0.00418888, 21.013311, -102.61511, 21.001209, -102.6264453, 21.017915, -102.6115108, 0),
(652, 14, 'Villa Corona', 'Villa Corona', NULL, 0.0308454, 20.4163682, -103.6646399, 20.4060268, -103.6851694, 20.4280962, -103.6542789, 0),
(653, 14, 'Villa Guerrero', 'Villa Guerrero', NULL, 0.00114242, 21.9805843, -103.5928664, 21.9738875, -103.6059237, 21.9900842, -103.5821915, 0),
(654, 14, 'Villa Hidalgo', 'Villa Hidalgo', NULL, 0.0140899, 21.6730624, -102.5871979, 21.6640534, -102.6014131, 21.6897802, -102.5736991, 69),
(655, 14, 'CaÃ±adas de ObregÃ³n', 'Cañadas de Obregon', NULL, 0.00152323, 36.778261, -119.4179324, 32.528832, -124.482003, 42.0095169, -114.131211, 6),
(656, 14, 'Yahualica de GonzÃ¡lez Gallo', 'Yahualica de Gonzalez Gallo', NULL, 0.00190404, 21.1801499, -102.8866136, 21.1619166, -102.9045387, 21.1922599, -102.8706737, 0),
(657, 14, 'Zacoalco de Torres', 'Zacoalco de Torres', NULL, 0.0190404, 20.226604, -103.570722, 20.2095968, -103.5884055, 20.2371741, -103.549264, 0),
(658, 14, 'Zapopan', 'Zapopan', NULL, 0.118431, 20.7166667, -103.4, 20.5847884, -103.4809116, 20.7780678, -103.3218399, 69),
(659, 14, 'Zapotiltic', 'Zapotiltic', NULL, 0.0236101, 19.628684, -103.420345, 19.6125719, -103.4532923, 19.6446606, -103.4003396, 0),
(662, 14, 'Zapotlanejo', 'Zapotlanejo', NULL, 0.0262757, 20.6237846, -103.0671517, 20.6097064, -103.0853692, 20.6386779, -103.0437332, 17),
(665, 15, 'Aculco', 'Aculco', NULL, 0.0338918, 19.3737105, -99.1048072, 19.3698859, -99.1084395, 19.3783224, -99.1015834, 0),
(667, 15, 'Almoloya de JuÃ¡rez', 'Almoloya de Juarez', NULL, 0.00266565, 31.7147467, -106.5200775, 31.7099839, -106.5220813, 31.7154923, -106.5092264, 0),
(668, 15, 'Almoloya del RÃo', 'Almoloya del Rio', NULL, 0.033511, 19.15901, -99.487808, 19.1471086, -99.4941587, 19.1711101, -99.4728904, 0),
(669, 15, 'Amanalco', 'Amanalco', NULL, 0.0384615, 19.5489393, -99.1933933, 19.5440742, -99.1937677, 19.5536044, -99.1930878, 0),
(671, 15, 'Amecameca', 'Amecameca', NULL, 0.0373191, 19.1223754, -98.7667481, 19.1067672, -98.7824996, 19.1442192, -98.7499084, 43),
(672, 15, 'Apaxco', 'Apaxco', NULL, 0.031607, 19.983333, -99.166667, 0, 0, 0, 0, 26),
(674, 15, 'AtizapÃ¡n', 'Atizapan', NULL, 0.0803503, 19.3023305, -99.1368098, 19.3010062, -99.1370698, 19.3035137, -99.1365582, 56),
(675, 15, 'AtizapÃ¡n de Zaragoza', 'Atizapan de Zaragoza', NULL, 0.0418888, 19.559495, -99.24672, 19.5179844, -99.3300357, 19.6122808, -99.2117737, 51),
(676, 15, 'Atlacomulco', 'Atlacomulco', NULL, 0.0422696, 19.3976544, -99.0384522, 19.3924511, -99.0418229, 19.4012424, -99.0357369, 0),
(678, 15, 'Axapusco', 'Axapusco', NULL, 0.0323686, 19.7233472, -98.7580254, 0, 0, 0, 0, 22),
(680, 15, 'Calimaya', 'Calimaya', NULL, 0.0350343, 19.161779, -99.6129104, 19.1610011, -99.6160494, 19.1623438, -99.6117892, 0),
(682, 15, 'Chalco', 'Chalco', NULL, 0.0521706, 19.3323903, -99.3264841, 19.3318626, -99.3267174, 19.3329461, -99.3259033, 38),
(684, 15, 'Chapultepec', 'Chapultepec', NULL, 0.0944402, 19.200338, -99.560349, 19.1959628, -99.5685791, 19.2082321, -99.5410393, 40),
(685, 15, 'Chiautla', 'Chiautla', NULL, 0.0342727, 19.5494361, -98.8827889, 19.5420657, -98.8945486, 19.5609103, -98.8684341, 0),
(686, 15, 'Chicoloapan', 'Chicoloapan', NULL, 0.0327494, 19.412609, -98.902687, 19.37994, -98.9424054, 19.4303098, -98.8715752, 28),
(687, 15, 'Chiconcuac', 'Chiconcuac', NULL, 0.0346535, 19.5585722, -98.8957734, 19.5504628, -98.9112438, 19.5682297, -98.8791099, 0),
(688, 15, 'ChimalhuacÃ¡n', 'Chimalhuacan', NULL, 0.0399848, 19.4207517, -98.9489571, 19.3732869, -98.9923952, 19.4519806, -98.9199459, 107),
(689, 15, 'Coacalco de BerriozÃ¡bal', 'Coacalco de Berriozabal', NULL, 0.0346535, 19.6326046, -99.1090105, 0, 0, 0, 0, 72),
(690, 15, 'Coatepec Harinas', 'Coatepec Harinas', NULL, 0.00114242, 18.9238627, -99.7679479, 18.907468, -99.7765506, 18.9355768, -99.7596264, 0),
(691, 15, 'CocotitlÃ¡n', 'Cocotitlan', NULL, 0.0323686, 19.2312464, -98.8639816, 19.2221342, -98.8766323, 19.2412114, -98.8513033, 0),
(692, 15, 'Coyotepec', 'Coyotepec', NULL, 0.0323686, 19.7763839, -99.2082441, 19.7498258, -99.2402434, 19.8158111, -99.1853783, 0),
(693, 15, 'CuautitlÃ¡n', 'Cuautitlan', NULL, 0.0517898, 19.6721809, -99.1809685, 19.6434043, -99.1925251, 19.6916448, -99.1401233, 157),
(694, 15, 'CuautitlÃ¡n Izcalli', 'Cuautitlan Izcalli', NULL, 0.0723534, 19.645378, -99.211222, 19.58568, -99.2767047, 19.7303314, -99.1749563, 257),
(695, 15, 'Donato Guerra', 'Donato Guerra', NULL, 0.033511, 19.3080667, -100.1435669, 0, 0, 0, 0, 17),
(696, 15, 'Ecatepec de Morelos', 'Ecatepec de Morelos', NULL, 0.0327494, 19.601841, -99.0506744, 19.4845281, -99.0993718, 19.6591814, -98.9738216, 0),
(697, 15, 'Ecatzingo', 'Ecatzingo', NULL, 0.000380807, 18.95, -98.75, 18.9478746, -98.7639678, 18.973594, -98.7204456, 0),
(698, 15, 'El Oro', 'El Oro', NULL, 0.0403656, 19.802839, -100.138199, 0, 0, 0, 0, 31),
(699, 15, 'Huehuetoca', 'Huehuetoca', NULL, 0.033511, 19.8341667, -99.2033333, 19.8127881, -99.2109872, 19.8394488, -99.1941674, 0),
(700, 15, 'Hueypoxtla', 'Hueypoxtla', NULL, 0.00418888, 19.9106243, -99.0755197, 19.9041553, -99.0814452, 19.9162872, -99.064816, 0),
(701, 15, 'Huixquilucan', 'Huixquilucan', NULL, 0.0350343, 19.361923, -99.35048, 19.3472226, -99.3629262, 19.3689112, -99.331984, 44),
(702, 15, 'Isidro Fabela', 'Isidro Fabela', NULL, 0.033511, 19.3003718, -99.1719095, 19.2976822, -99.1793275, 19.3031503, -99.1666048, 0),
(703, 15, 'Ixtapaluca', 'Ixtapaluca', NULL, 0.049505, 19.3138911, -98.8859856, 19.2890411, -98.9538589, 19.3462445, -98.8655878, 99),
(704, 15, 'Ixtapan de la Sal', 'Ixtapan de la Sal', NULL, 0.0418888, 18.8437564, -99.6755346, 18.8230263, -99.7005718, 18.8607554, -99.6649513, 33),
(705, 15, 'Ixtapan del Oro', 'Ixtapan del Oro', NULL, 0.00114242, 19.2717523, -100.2679517, 0, 0, 0, 0, 3),
(706, 15, 'Ixtlahuaca', 'Ixtlahuaca', NULL, 0.0323686, 19.5688889, -99.7669444, 19.5599201, -99.7738603, 19.5807038, -99.7516348, 0),
(707, 15, 'Jaltenco', 'Jaltenco', NULL, 0.0350343, 19.7510112, -99.0941041, 19.7444282, -99.1045652, 19.7639712, -99.0804447, 0),
(709, 15, 'Jilotzingo', 'Jilotzingo', NULL, 0.0373191, 19.8699056, -99.0567324, 19.858359, -99.0716111, 19.880942, -99.0426671, 0),
(711, 15, 'JocotitlÃ¡n', 'Jocotitlan', NULL, 0.031607, 19.7076624, -99.7882799, 19.6967207, -99.8012552, 19.7218746, -99.7762865, 0),
(714, 15, 'La Paz', 'La Paz', NULL, 0.0620716, 24.1333333, -110.3, 24.0461446, -110.3528374, 24.1867914, -110.253753, 91),
(715, 15, 'Lerma', 'Lerma', NULL, 0.0464585, 19.8060959, -90.6011152, 0, 0, 0, 0, 38),
(717, 15, 'Malinalco', 'Malinalco', NULL, 0.0342727, 18.9445694, -99.4953884, 18.9317108, -99.507663, 18.9607066, -99.4855781, 34),
(718, 15, 'Melchor Ocampo', 'Melchor Ocampo', NULL, 0.0346535, 19.7083333, -99.1444444, 19.6898808, -99.1558001, 19.7276742, -99.1210656, 0),
(719, 15, 'Metepec', 'Metepec', NULL, 0.0403656, 19.2563509, -99.6047904, 19.2346561, -99.6453965, 19.2874978, -99.5521047, 57),
(720, 15, 'Mexicaltzingo', 'Mexicaltzingo', NULL, 0.0357959, 19.20951, -99.585431, 19.2043103, -99.5919553, 19.2189081, -99.5768576, 0),
(721, 15, 'Morelos', 'Morelos', NULL, 0.0357959, 18.6813049, -99.1013498, 18.3315949, -99.4939424, 19.1321979, -98.6327839, 167),
(722, 15, 'Naucalpan de JuÃ¡rez', 'Naucalpan de Juarez', NULL, 0.0453161, 19.475048, -99.237386, 19.4119686, -99.3028363, 19.5274193, -99.2068391, 81),
(723, 15, 'Nextlalpan', 'Nextlalpan', NULL, 0.0342727, 19.2269386, -98.2390723, 19.2186638, -98.2424253, 19.2327137, -98.2328372, 0),
(724, 15, 'NezahualcÃ³yotl', 'Nezahualcoyotl', NULL, 0.0502666, 19.4166667, -99.0333333, 19.3662035, -99.0681455, 19.4985239, -98.9658942, 60),
(725, 15, 'NicolÃ¡s Romero', 'Nicolas Romero', NULL, 0.0376999, 19.6197996, -99.3114344, 19.5822626, -99.3487173, 19.650615, -99.2660629, 38),
(727, 15, 'Ocoyoacac', 'Ocoyoacac', NULL, 0.033511, 19.272695, -99.459661, 19.2605022, -99.4809137, 19.281957, -99.4342084, 34),
(729, 15, 'Otumba', 'Otumba', NULL, 0.0251333, 19.698481, -98.753911, 19.6874925, -98.7684818, 19.7125248, -98.7380646, 40),
(731, 15, 'Otzolotepec', 'Otzolotepec', NULL, 0.0342727, 19.3643069, -99.6080859, 19.3626982, -99.6120152, 19.3643069, -99.6080859, 0),
(732, 15, 'Ozumba', 'Ozumba', NULL, 0.033511, 19.0391667, -98.7936111, 19.0299277, -98.8094855, 19.0417897, -98.793234, 0),
(733, 15, 'Papalotla', 'Papalotla', NULL, 0.0312262, 19.5622222, -98.8577778, 19.5481557, -98.8701251, 19.5677339, -98.846274, 0),
(735, 15, 'RayÃ³n', 'Rayon', NULL, 0.00609292, 21.8413104, -99.6444181, 21.8362488, -99.6660924, 21.8543251, -99.6281845, 0),
(736, 15, 'San Antonio la Isla', 'San Antonio la Isla', NULL, 0.0373191, 19.162641, -99.566481, 19.1537886, -99.5764976, 19.1702134, -99.557138, 0),
(737, 15, 'San Felipe del Progreso', 'San Felipe del Progreso', NULL, 0.0380807, 19.7129957, -99.9515474, 0, 0, 0, 0, 33),
(739, 15, 'San MartÃn de las PirÃ¡mides', 'San Martin de las Piramides', NULL, 0.0354151, 19.705756, -98.837456, 19.693395, -98.845059, 19.7133505, -98.8189741, 39),
(740, 15, 'San Mateo Atenco', 'San Mateo Atenco', NULL, 0.039604, 19.27035, -99.533133, 19.237981, -99.5705616, 19.3202395, -99.5208771, 48),
(742, 15, 'Santo TomÃ¡s', 'Santo Tomas', NULL, 0.0178979, 18.8441259, -100.0177997, 0, 0, 0, 0, 36),
(743, 15, 'Soyaniquilpan de JuÃ¡rez', 'Soyaniquilpan de Juarez', NULL, 0.0346535, 19.9912367, -102.7175569, 19.9751119, -102.738771, 20.0081292, -102.6903012, 0),
(745, 15, 'TecÃ¡mac', 'Tecamac', NULL, 0.0666413, 19.3363322, -99.1646889, 19.3356527, -99.1647797, 19.3363954, -99.1641152, 36),
(746, 15, 'Tejupilco', 'Tejupilco', NULL, 0.0270373, 18.9075097, -100.1509731, 18.8866454, -100.1624615, 18.9250197, -100.1339984, 67),
(747, 15, 'Temamatla', 'Temamatla', NULL, 0.0350343, 19.2027778, -98.87, 19.1922304, -98.8862658, 19.2150473, -98.8594007, 0),
(748, 15, 'Temascalapa', 'Temascalapa', NULL, 0.0373191, 19.8257589, -98.9001316, 19.8123236, -98.9185812, 19.8400916, -98.8853009, 0),
(749, 15, 'Temascalcingo', 'Temascalcingo', NULL, 0.0186596, 19.9147222, -100.0036111, 19.9069006, -100.0166279, 19.9261393, -99.992782, 32),
(751, 15, 'Temoaya', 'Temoaya', NULL, 0.0331302, 19.4653884, -99.5940417, 0, 0, 0, 0, 3),
(752, 15, 'Tenancingo', 'Tenancingo', NULL, 0.0323686, 18.9608333, -99.5905556, 18.9531394, -99.5999954, 18.9671789, -99.5805509, 50),
(753, 15, 'Tenango del Aire', 'Tenango del Aire', NULL, 0.031607, 19.1576292, -98.8599372, 0, 0, 0, 0, 35),
(754, 15, 'Tenango del Valle', 'Tenango del Valle', NULL, 0.0384615, 19.6365352, -99.2163639, 19.6355823, -99.2201954, 19.6386083, -99.2130714, 29),
(755, 15, 'TeoloyucÃ¡n', 'Teoloyucan', NULL, 0.0338918, 19.7441667, -99.1811111, 19.7312809, -99.2003058, 19.7799759, -99.1424214, 80),
(756, 15, 'TeotihuacÃ¡n', 'Teotihuacan', NULL, 0.0540746, 19.3538566, -99.2413009, 19.352429, -99.2419562, 19.3545925, -99.2403679, 88),
(758, 15, 'Tepetlixpa', 'Tepetlixpa', NULL, 0.033511, 19.0247002, -98.8199302, 19.0183694, -98.8314589, 19.0417547, -98.8069621, 0),
(759, 15, 'TepotzotlÃ¡n', 'Tepotzotlan', NULL, 0.0407464, 19.716629, -99.223113, 19.7005825, -99.2400931, 19.7378532, -99.1953648, 86),
(760, 15, 'Tequixquiac', 'Tequixquiac', NULL, 0.0342727, 19.9080343, -99.1456813, 19.8818204, -99.1706712, 19.9266631, -99.113824, 0),
(763, 15, 'Texcoco', 'Texcoco', NULL, 0.0978675, 19.4194444, -99.1333333, 0, 0, 0, 0, 115),
(764, 15, 'Tezoyuca', 'Tezoyuca', NULL, 0.0365575, 19.59142, -98.91313, 19.5863102, -98.920735, 19.6097064, -98.8998239, 0),
(767, 15, 'Tlalmanalco', 'Tlalmanalco', NULL, 0.0308454, 19.2044444, -98.8025, 19.1942, -98.8176148, 19.2167042, -98.7845675, 0),
(768, 15, 'Tlalnepantla de Baz', 'Tlalnepantla de Baz', NULL, 0.0388423, 19.538988, -99.193281, 19.4976522, -99.2492987, 19.59595, -99.151067, 0),
(770, 15, 'Toluca', 'Toluca', NULL, 0.168698, 19.287867, -99.646761, 19.2431412, -99.7070063, 19.3457262, -99.5724077, 496),
(772, 15, 'Tonatico', 'Tonatico', NULL, 0.0331302, 18.8027964, -99.6700236, 18.7961696, -99.6760557, 18.8184225, -99.662454, 0),
(773, 15, 'Tultepec', 'Tultepec', NULL, 0.0373191, 19.685, -99.1280556, 19.6708394, -99.1442411, 19.7061386, -99.1022441, 147),
(774, 15, 'TultitlÃ¡n', 'Tultitlan', NULL, 0.0487433, 19.645565, -99.1689269, 19.6218537, -99.1847828, 19.6611026, -99.1453771, 51),
(775, 15, 'Valle de Bravo', 'Valle de Bravo', NULL, 0.0437928, 19.1925, -100.1305556, 19.1435628, -100.1592717, 19.2170104, -100.1047911, 28),
(776, 15, 'Valle de Chalco Solidaridad', 'Valle de Chalco Solidaridad', NULL, 0.00456969, 20.8645538, -101.5113189, 20.8644794, -101.5125734, 20.8645538, -101.5113189, 0),
(778, 15, 'Villa del CarbÃ³n', 'Villa del Carbon', NULL, 0.033511, 19.7223442, -99.4615786, 19.7137847, -99.4858274, 19.7474039, -99.446818, 32),
(779, 15, 'Villa Guerrero', 'Villa Guerrero', NULL, 0.0304646, 18.96, -99.64, 18.9508002, -99.6479145, 18.9684649, -99.6274499, 0),
(780, 15, 'Villa Victoria', 'Villa Victoria', NULL, 0.0148515, 19.4376729, -99.9954161, 0, 0, 0, 0, 71),
(781, 15, 'Xalatlaco', 'Xalatlaco', NULL, 0.00342727, 19.1796452, -99.4159979, 19.1639239, -99.4326728, 19.1879233, -99.4067449, 0),
(782, 15, 'XonacatlÃ¡n', 'Xonacatlan', NULL, 0.00342727, 19.4041129, -99.5292989, 19.3962164, -99.5365331, 19.4110789, -99.5203149, 0),
(785, 15, 'Zinacantepec', 'Zinacantepec', NULL, 0.0350343, 19.2833333, -99.7333333, 19.2557076, -99.7552119, 19.3078317, -99.6958232, 75),
(787, 15, 'Zumpango', 'Zumpango', NULL, 0.0388423, 19.797112, -99.098933, 19.7719529, -99.11913, 19.8277336, -99.0598064, 107),
(788, 16, 'Acuitzio', 'Acuitzio', NULL, 0.00114242, 20.3469265, -101.9761803, 20.3403214, -101.9831657, 20.3498578, -101.9698191, 0),
(789, 16, 'Aguililla', 'Aguililla', NULL, 0.000380807, 18.737714, -102.788323, 18.7299176, -102.8035438, 18.7480262, -102.7715746, 0),
(790, 16, 'Alvaro ObregÃ³n', 'Alvaro Obregon', NULL, 0.0190404, 19.8232369, -101.0394356, 19.8108963, -101.0573045, 19.8329955, -101.0327046, 0),
(791, 16, 'Angamacutiro', 'Angamacutiro', NULL, 0.0323686, 19.4164672, -102.1312209, 19.4049449, -102.1427417, 19.4301385, -102.1116689, 0),
(793, 16, 'ApatzingÃ¡n', 'Apatzingan', NULL, 0.0354151, 19.0833333, -102.35, 19.0517785, -102.3844439, 19.1205937, -102.3149097, 59),
(796, 16, 'Ario', 'Ario', NULL, 0.0380807, 18.0228826, -102.2124912, 18.0227677, -102.2139805, 18.0229058, -102.2110029, 0),
(797, 16, 'Arteaga', 'Arteaga', NULL, 0.00456969, 18.3588767, -102.2890696, 18.3443858, -102.305687, 18.3721629, -102.2777536, 12),
(800, 16, 'CarÃ¡cuaro', 'Caracuaro', NULL, 0.0357959, 20.3334303, -102.0341814, 20.329704, -102.035331, 20.3372218, -102.0329926, 0),
(801, 16, 'Charapan', 'Charapan', NULL, 0.00837776, 19.6491177, -102.2504469, 19.6439779, -102.2595949, 19.6554607, -102.2432241, 0),
(802, 16, 'Charo', 'Charo', NULL, 0.0449353, 19.7467384, -101.0442269, 0, 0, 0, 0, 58),
(803, 16, 'Chavinda', 'Chavinda', NULL, 0.0106626, 20.0069179, -102.4587426, 19.9894618, -102.4760698, 20.0184397, -102.4446825, 39),
(804, 16, 'CherÃ¡n', 'Cheran', NULL, 0.0133283, 19.685608, -101.956341, 19.6717062, -101.9688585, 19.6980576, -101.9382109, 0),
(805, 16, 'Chilchota', 'Chilchota', NULL, 0.00418888, 19.8464674, -102.1176991, 19.8367386, -102.1304172, 19.8534898, -102.1072242, 0),
(806, 16, 'Chinicuila', 'Chinicuila', NULL, 0.0331302, 18.0252409, -102.2135865, 18.025004, -102.2147281, 18.0253786, -102.2128386, 0),
(809, 16, 'Churumuco', 'Churumuco', NULL, 0.0274181, 19.0670093, -102.352972, 19.0666832, -102.352972, 19.0670093, -102.3524488, 0),
(811, 16, 'CoalcomÃ¡n de VÃ¡zquez Pallares', 'Coalcoman de Vazquez Pallares', NULL, 0.00342727, 18.7782432, -103.1604396, 18.7662582, -103.1808331, 18.7922906, -103.1503436, 0),
(813, 16, 'CojumatlÃ¡n de RÃ©gules', 'Cojumatlan de Regules', NULL, 0.00342727, 20.117721, -102.851324, 20.1063509, -102.8624702, 20.1274423, -102.8380641, 0),
(814, 16, 'Contepec', 'Contepec', NULL, 0.0114242, 19.9521591, -100.1619222, 19.9421675, -100.1755714, 19.963507, -100.1523113, 0),
(815, 16, 'CopÃ¡ndaro', 'Copandaro', NULL, 0.00114242, 19.9333301, -101.5999994, 0, 0, 0, 0, 2),
(816, 16, 'Cotija', 'Cotija', NULL, 0.0114242, 19.8071529, -102.7017979, 19.796318, -102.7203823, 19.8220806, -102.6792176, 0),
(817, 16, 'Cuitzeo', 'Cuitzeo', NULL, 0.0144707, 19.9691667, -101.14, 19.9569965, -101.1589958, 19.981145, -101.1280812, 0),
(821, 16, 'Gabriel Zamora', 'Gabriel Zamora', NULL, 0.0369383, 19.4102243, -102.0721851, 19.4090763, -102.0733275, 19.4110756, -102.0704163, 0),
(822, 16, 'Hidalgo', 'Hidalgo', NULL, 0.0327494, 20.2500784, -102.472457, 20.233452, -102.475918, 20.2727564, -102.4648926, 33),
(823, 16, 'Huandacareo', 'Huandacareo', NULL, 0.00456969, 19.99, -101.2755556, 19.9784104, -101.2894466, 19.9993654, -101.2619354, 0),
(827, 16, 'Indaparapeo', 'Indaparapeo', NULL, 0.00152323, 19.7871284, -100.9681992, 19.7743274, -100.9860583, 19.8006138, -100.9545346, 0),
(830, 16, 'Jacona', 'Jacona', NULL, 0.0388423, 19.9405957, -102.3137059, 19.9399756, -102.316057, 19.9413917, -102.3118075, 0),
(831, 16, 'JimÃ©nez', 'Jimenez', NULL, 0.0342727, 19.8611324, -100.8232845, 19.8595799, -100.8251558, 19.8632525, -100.8226749, 50),
(832, 16, 'Jiquilpan', 'Jiquilpan', NULL, 0.0369383, 19.9912367, -102.7175569, 19.9751119, -102.738771, 20.0081292, -102.6903012, 0),
(833, 16, 'JosÃ© Sixto Verduzco', 'Jose Sixto Verduzco', NULL, 0.0319878, 19.0744, -102.3577388, 19.0730889, -102.3601019, 19.0759977, -102.355654, 0),
(834, 16, 'JuÃ¡rez', 'Juarez', NULL, 0.0384615, 31.6510468, -106.3703684, 31.6471091, -106.3717237, 31.6548427, -106.368661, 16),
(836, 16, 'La Huacana', 'La Huacana', NULL, 0.000380807, 18.964542, -101.808291, 18.9495917, -101.8192475, 18.9757513, -101.7942037, 0),
(838, 16, 'Lagunillas', 'Lagunillas', NULL, 0.00228484, 19.5633686, -101.4166725, 19.5535827, -101.4282274, 19.5731546, -101.4051175, 0),
(839, 16, 'LÃ¡zaro CÃ¡rdenas', 'Lazaro Cardenas', NULL, 0.0369383, 17.9574888, -102.1922321, 17.9111225, -102.8011322, 18.2498939, -102.1115685, 85),
(840, 16, 'Los Reyes', 'Los Reyes', NULL, 0.0171363, 19.7333329, -100.2666671, 0, 0, 0, 0, 40),
(841, 16, 'Madero', 'Madero', NULL, 0.112719, 22.2614689, -97.8465586, 22.2598651, -97.8499251, 22.2630362, -97.8431051, 71),
(842, 16, 'MaravatÃo', 'Maravatio', NULL, 0.0453161, 21.1348948, -101.6731205, 21.13446, -101.6768957, 21.1356782, -101.6696583, 0),
(843, 16, 'Marcos Castellanos', 'Marcos Castellanos', NULL, 0.0323686, 20.051689, -102.7071278, 20.0478405, -102.7073237, 20.0553249, -102.7065811, 0),
(844, 16, 'Morelia', 'Morelia', NULL, 0.158416, 19.700593, -101.186421, 19.6499308, -101.2920819, 19.7579979, -101.1250609, 95),
(845, 16, 'Morelos', 'Morelos', NULL, 0.0342727, 19.6453794, -101.2367401, 19.6324276, -101.2611132, 19.6565509, -101.2205497, 50),
(846, 16, 'MÃºgica', 'Mugica', NULL, 0.0312262, 19.8501194, -102.0327648, 19.8492545, -102.0329141, 19.8509756, -102.0326969, 0),
(847, 16, 'Nahuatzen', 'Nahuatzen', NULL, 0.000380807, 19.654519, -101.917543, 19.6449663, -101.9309378, 19.6654008, -101.9063188, 0),
(849, 16, 'Nuevo Parangaricutiro', 'Nuevo Parangaricutiro', NULL, 0.0331302, 19.4173519, -102.0822347, 19.4158823, -102.0851479, 19.4185764, -102.0791829, 0),
(853, 16, 'PajacuarÃ¡n', 'Pajacuaran', NULL, 0.00342727, 20.1188549, -102.5655301, 20.1112781, -102.5833558, 20.1300704, -102.5482227, 0),
(854, 16, 'PanindÃcuaro', 'Panindicuaro', NULL, 0.00342727, 19.9830872, -101.7607298, 19.9715766, -101.7742404, 19.9956449, -101.7471264, 0),
(855, 16, 'Paracho', 'Paracho', NULL, 0.00304646, 19.6438889, -102.0483333, 19.6294136, -102.0656022, 19.6604834, -102.0336679, 0),
(857, 16, 'PÃ¡tzcuaro', 'Patzcuaro', NULL, 0.0456969, 19.5163889, -101.6097222, 19.4876684, -101.6287751, 19.5501075, -101.5857566, 89),
(860, 16, 'PurÃ©pero', 'Purepero', NULL, 0.0464585, 21.1318432, -101.6749079, 21.1308232, -101.6779573, 21.1329685, -101.6721478, 0),
(861, 16, 'PuruÃ¡ndiro', 'Puruandiro', NULL, 0.0437928, 20.0883727, -101.5158874, 20.0726735, -101.5387015, 20.10614, -101.4884142, 79),
(862, 16, 'QuerÃ©ndaro', 'Querendaro', NULL, 0.0224676, 19.8103184, -100.8918041, 19.8001263, -100.906023, 19.8226967, -100.8732384, 0),
(863, 16, 'Quiroga', 'Quiroga', NULL, 0.041508, 19.6637774, -101.5248521, 19.6480146, -101.5370976, 19.6766186, -101.5105876, 21),
(864, 16, 'Sahuayo', 'Sahuayo', NULL, 0.0373191, 20.0586847, -102.7146904, 20.0319799, -102.7479615, 20.0919491, -102.6976686, 126),
(865, 16, 'Salvador Escalante', 'Salvador Escalante', NULL, 0.0392232, 19.4063827, -101.6400141, 19.3787102, -101.6596591, 19.4180072, -101.6266618, 0),
(866, 16, 'San Lucas', 'San Lucas', NULL, 0.0163747, 18.5769499, -100.7854866, 0, 0, 0, 0, 41),
(867, 16, 'Santa Ana Maya', 'Santa Ana Maya', NULL, 0.00380807, 20.007989, -101.022252, 19.9985119, -101.0387899, 20.018521, -101.0099277, 0),
(869, 16, 'Susupuato', 'Susupuato', NULL, 0.0266565, 18.0146222, -102.2202137, 18.0129581, -102.2214261, 18.0167084, -102.218718, 0),
(871, 16, 'TancÃtaro', 'Tancitaro', NULL, 0.000761615, 19.337023, -102.363872, 19.3126121, -102.3743156, 19.3485686, -102.3526965, 0),
(873, 16, 'TangancÃcuaro', 'Tangancicuaro', NULL, 0.0350343, 19.7056166, -101.2446615, 19.7036167, -101.2469871, 19.7074835, -101.2426368, 40),
(876, 16, 'TarÃmbaro', 'Tarimbaro', NULL, 0.0327494, 19.7937912, -101.1773031, 19.7848839, -101.189787, 19.8036986, -101.1589952, 0),
(877, 16, 'Tepalcatepec', 'Tepalcatepec', NULL, 0.000761615, 19.1833333, -102.85, 19.1696859, -102.8687751, 19.1998347, -102.8294083, 0),
(879, 16, 'Tingambato', 'Tingambato', NULL, 0.000761615, 19.50174, -101.8535609, 19.4880419, -101.8656943, 19.5129607, -101.8394739, 0),
(883, 16, 'Tocumbo', 'Tocumbo', NULL, 0.0201828, 19.7020667, -102.5225624, 19.6925149, -102.5309408, 19.7074638, -102.5173917, 0),
(890, 16, 'Uruapan', 'Uruapan', NULL, 0.0426504, 19.4172134, -102.0503611, 19.3627854, -102.0910992, 19.4506058, -101.9950413, 45),
(891, 16, 'Venustiano Carranza', 'Venustiano Carranza', NULL, 0.0319878, 20.1147702, -102.6539876, 20.100918, -102.6764537, 20.1241139, -102.6360545, 0),
(893, 16, 'Vista Hermosa', 'Vista Hermosa', NULL, 0.000761615, 19.4176028, -101.6034265, 19.415832, -101.6045352, 19.4200623, -101.6021945, 0),
(894, 16, 'YurÃ©cuaro', 'Yurecuaro', NULL, 0.00266565, 20.3359267, -102.2842134, 20.3162431, -102.3059179, 20.3538743, -102.2504363, 0),
(895, 16, 'Zacapu', 'Zacapu', NULL, 0.0323686, 19.8166667, -101.7908333, 19.7889025, -101.8103653, 19.8589939, -101.7576423, 54),
(896, 16, 'Zamora', 'Zamora', NULL, 0.053313, 19.988688, -102.285608, 19.9598729, -102.3260376, 20.0225735, -102.2385728, 107),
(900, 16, 'ZitÃ¡cuaro', 'Zitacuaro', NULL, 0.0300838, 19.433959, -100.3519052, 19.412297, -100.390905, 19.4545131, -100.3118379, 19),
(901, 17, 'Amacuzac', 'Amacuzac', NULL, 0.00304646, 18.599086, -99.369607, 18.5924425, -99.3910908, 18.6109973, -99.3610239, 0),
(902, 17, 'Atlatlahucan', 'Atlatlahucan', NULL, 0.0338918, 18.933682, -98.897503, 18.9198165, -98.9057654, 18.950313, -98.8876274, 17),
(903, 17, 'Axochiapan', 'Axochiapan', NULL, 0.00342727, 18.500239, -98.749734, 18.486446, -98.7688093, 18.5172033, -98.7334699, 0),
(904, 17, 'Ayala', 'Ayala', NULL, 0.0243717, 18.710304, -98.99001, 0, 0, 0, 0, 49),
(905, 17, 'CoatlÃ¡n del RÃo', 'Coatlan del Rio', NULL, 0.0270373, 18.7438102, -99.4352529, 18.7369544, -99.4693829, 18.7747802, -99.4229251, 0),
(906, 17, 'Cuautla', 'Cuautla', NULL, 0.0453161, 18.8126047, -98.9548261, 18.7848562, -98.9703337, 18.8832798, -98.8986635, 441),
(907, 17, 'Cuernavaca', 'Cuernavaca', NULL, 0.147753, 18.9340199, -99.2314826, 18.8621896, -99.3006592, 19.0010525, -99.1804161, 482),
(908, 17, 'Emiliano Zapata', 'Emiliano Zapata', NULL, 0.0327494, 18.8387007, -99.1840281, 18.8136168, -99.2018324, 18.8701641, -99.1667913, 27),
(909, 17, 'Huitzilac', 'Huitzilac', NULL, 0.031607, 19.0282112, -99.2679119, 0, 0, 0, 0, 39),
(910, 17, 'Jantetelco', 'Jantetelco', NULL, 0.0289414, 18.7162064, -98.7775536, 0, 0, 0, 0, 33),
(911, 17, 'Jiutepec', 'Jiutepec', NULL, 0.0327494, 18.8833333, -99.1833333, 18.8554561, -99.2171108, 18.9367342, -99.1497938, 39),
(912, 17, 'Jojutla', 'Jojutla', NULL, 0.0361767, 18.6156338, -99.181599, 18.6029214, -99.191932, 18.6272085, -99.167671, 51),
(913, 17, 'Jonacatepec', 'Jonacatepec', NULL, 0.0270373, 18.6833333, -98.8, 18.6675462, -98.8171592, 18.7005846, -98.7883206, 41),
(915, 17, 'MiacatlÃ¡n', 'Miacatlan', NULL, 0.0247525, 18.771608, -99.353729, 18.751796, -99.3665022, 18.7803938, -99.334758, 0),
(917, 17, 'Puente de Ixtla', 'Puente de Ixtla', NULL, 0.0232292, 18.6168, -99.3198, 18.6037274, -99.3338198, 18.6348617, -99.3088074, 30),
(918, 17, 'Temixco', 'Temixco', NULL, 0.0380807, 18.85, -99.2333333, 18.8067593, -99.2635604, 18.8820385, -99.2083328, 41),
(920, 17, 'Tepalcingo', 'Tepalcingo', NULL, 0.0152323, 18.594729, -98.844539, 18.5833924, -98.8577477, 18.60833, -98.8342656, 0),
(921, 17, 'TepoztlÃ¡n', 'Tepoztlan', NULL, 0.0521706, 18.985, -99.1, 18.9690646, -99.1155842, 19.0009386, -99.0694284, 62),
(923, 17, 'Tetela del VolcÃ¡n', 'Tetela del Volcan', NULL, 0.00380807, 18.8930556, -98.7291667, 18.8798826, -98.7441747, 18.9136256, -98.7105304, 0),
(924, 17, 'Tlalnepantla', 'Tlalnepantla', NULL, 0.0529322, 19.0094874, -98.9982534, 0, 0, 0, 0, 58),
(925, 17, 'TlaltizapÃ¡n', 'Tlaltizapan', NULL, 0.0239909, 18.689144, -99.118605, 18.6733928, -99.1332206, 18.7120992, -99.1086415, 0),
(926, 17, 'Tlaquiltenango', 'Tlaquiltenango', NULL, 0.031607, 18.6325574, -99.1629666, 18.6178093, -99.1737439, 18.6561528, -99.1530844, 38),
(927, 17, 'Tlayacapan', 'Tlayacapan', NULL, 0.0369383, 18.9555556, -98.9811111, 18.9467733, -98.9944102, 18.9683594, -98.9698597, 39),
(928, 17, 'Totolapan', 'Totolapan', NULL, 0.0350343, 18.9873895, -98.9206188, 18.9745798, -98.9293905, 18.9933265, -98.9108353, 20),
(929, 17, 'Xochitepec', 'Xochitepec', NULL, 0.0361767, 18.780751, -99.231608, 18.7717982, -99.2500897, 18.8268758, -99.2208295, 0),
(930, 17, 'Yautepec', 'Yautepec', NULL, 0.0384615, 18.8833333, -99.0666667, 18.8516886, -99.0851374, 18.914855, -99.0381613, 73),
(931, 17, 'Yecapixtla', 'Yecapixtla', NULL, 0.0369383, 18.8828447, -98.8651434, 18.8658057, -98.8828596, 18.8938725, -98.8366146, 29),
(932, 17, 'Zacatepec de Hidalgo', 'Zacatepec de Hidalgo', NULL, 0.0338918, 18.659, -99.195, 18.6441894, -99.2131112, 18.6724683, -99.1808207, 0),
(933, 17, 'Zacualpan de Amilpas', 'Zacualpan de Amilpas', NULL, 0.00228484, 18.7836111, -98.7594444, 18.7785101, -98.778677, 18.8002056, -98.7533569, 0),
(934, 18, 'Acaponeta', 'Acaponeta', NULL, 0.0175171, 22.4937372, -105.3609484, 22.4817194, -105.3803978, 22.5135376, -105.348567, 0),
(935, 18, 'Ahuacatlan', 'Ahuacatlan', NULL, 0.0220868, 21.0529847, -104.4841521, 21.0447616, -104.4977474, 21.0632287, -104.4698388, 0),
(937, 18, 'BahÃa de Banderas', 'Bahia de Banderas', NULL, 0.00304646, 20.673459, -105.3248269, 20.6364792, -105.3508186, 20.7346232, -105.2589798, 0),
(938, 18, 'Compostela', 'Compostela', NULL, 0.0853008, 21.2379529, -104.8999874, 21.2228258, -104.9248203, 21.2559906, -104.8796679, 68),
(939, 18, 'El Nayar', 'El Nayar', NULL, 0.0323686, 21.5255417, -104.9322458, 21.5241344, -104.9340703, 21.5272779, -104.9318409, 0),
(941, 18, 'IxtlÃ¡n del RÃo', 'Ixtlan del Rio', NULL, 0.0255141, 21.0362577, -104.3718334, 21.0267368, -104.3957174, 21.0469462, -104.3468649, 0),
(942, 18, 'Jala', 'Jala', NULL, 0.0331302, 21.1038387, -104.4352124, 21.0944503, -104.452142, 21.1130592, -104.4164241, 0),
(945, 18, 'Ruiz', 'Ruiz', NULL, 0.00418888, 21.9519444, -105.1416667, 21.9389446, -105.1611078, 21.9663318, -105.118715, 0),
(946, 18, 'San Blas', 'San Blas', NULL, 0.0392232, 21.5412514, -105.2842991, 21.5226375, -105.2960197, 21.5559979, -105.2668406, 54),
(949, 18, 'Santiago Ixcuintla', 'Santiago Ixcuintla', NULL, 0.0224676, 21.813351, -105.207603, 21.8023858, -105.2257797, 21.8240822, -105.1871468, 0),
(950, 18, 'Tecuala', 'Tecuala', NULL, 0.0182788, 22.3982422, -105.4569464, 22.3841638, -105.4735008, 22.4137342, -105.4441022, 0),
(951, 18, 'Tepic', 'Tepic', NULL, 0.0590251, 21.5038734, -104.8945796, 21.455953, -104.9391791, 21.5453616, -104.8279469, 84),
(952, 18, 'Tuxpan', 'Tuxpan', NULL, 0.00952018, 21.942789, -105.2994, 21.9309579, -105.3170866, 21.9527461, -105.2674439, 26),
(953, 18, 'Xalisco', 'Xalisco', NULL, 0.0342727, 21.448144, -104.8999467, 21.4296563, -104.9112719, 21.4669209, -104.8850221, 0),
(955, 19, 'Agualeguas', 'Agualeguas', NULL, 0.000380807, 26.3127579, -99.5390776, 26.3078637, -99.5480553, 26.3181941, -99.5286173, 0),
(956, 19, 'Allende', 'Allende', NULL, 0.0365575, 25.2836111, -100.0202778, 25.2569861, -100.0490807, 25.3095638, -99.992486, 53),
(957, 19, 'AnÃ¡huac', 'Anahuac', NULL, 0.0243717, 27.232639, -100.134399, 27.2173983, -100.1648111, 27.2567697, -100.1181034, 22),
(958, 19, 'Apodaca', 'Apodaca', NULL, 0.0365575, 25.7815621, -100.1875974, 25.7017884, -100.2700371, 25.8315081, -100.1396922, 80),
(960, 19, 'Bustamante', 'Bustamante', NULL, 0.00990099, 26.5343082, -100.5055369, 26.5175849, -100.5232716, 26.5417782, -100.4953324, 0),
(961, 19, 'Cadereyta JimÃ©nez', 'Cadereyta Jimenez', NULL, 0.0312262, 25.5935169, -99.9901811, 25.5577435, -100.0451069, 25.6213352, -99.9233724, 0),
(962, 19, 'Carmen', 'Carmen', NULL, 0.0677837, 25.92588, -100.358803, 25.9166148, -100.374716, 25.9523025, -100.3402595, 93),
(963, 19, 'Cerralvo', 'Cerralvo', NULL, 0.00342727, 26.0842699, -99.6156011, 26.0624182, -99.6485774, 26.1000921, -99.5933666, 0),
(964, 19, 'China', 'China', NULL, 0.019802, 25.7033306, -99.2365222, 25.6856452, -99.2607859, 25.7191163, -99.2165334, 31),
(965, 19, 'CiÃ©nega de Flores', 'Cienega de Flores', NULL, 0.0342727, 25.955113, -100.163749, 25.9430589, -100.1874764, 25.9722033, -100.1515741, 0),
(967, 19, 'Dr. Arroyo', 'Dr. Arroyo', NULL, 0.00456969, 23.6730556, -100.18, 23.6604033, -100.1966334, 23.6840777, -100.1663819, 0),
(969, 19, 'Galeana', 'Galeana', NULL, 0.00152323, 24.822924, -100.074472, 24.8060741, -100.0904836, 24.8350401, -100.063976, 0),
(970, 19, 'GarcÃa', 'Garcia', NULL, 0.053313, 25.8089212, -100.5979229, 25.7838358, -100.6341632, 25.8274468, -100.5754855, 62),
(972, 19, 'Gral. TerÃ¡n', 'Gral. Teran', NULL, 0.00418888, 25.2538199, -99.6780766, 25.2435501, -99.705263, 25.2716826, -99.6611536, 0),
(973, 19, 'Gral. TreviÃ±o', 'Gral. Treviño', NULL, 0.0331302, 25.7873371, -100.3129204, 25.7867509, -100.3164158, 25.787734, -100.3104921, 0),
(974, 19, 'Gral. Zaragoza', 'Gral. Zaragoza', NULL, 0.0323686, 25.1706899, -99.8204943, 25.1706157, -99.8215742, 25.1709064, -99.818992, 0),
(976, 19, 'Gral. Bravo', 'Gral. Bravo', NULL, 0.00114242, 25.7925759, -99.1786289, 25.7777727, -99.1905887, 25.8124216, -99.1659509, 0),
(977, 19, 'Guadalupe', 'Guadalupe', NULL, 0.0483625, 25.684139, -100.250999, 25.6206256, -100.2760887, 25.7320569, -100.1295936, 76),
(978, 19, 'Hidalgo', 'Hidalgo', NULL, 0.0247525, 25.9722174, -100.4506976, 25.9465533, -100.4821821, 25.9987426, -100.4253846, 47),
(980, 19, 'Hualahuises', 'Hualahuises', NULL, 0.0270373, 24.8838082, -99.6751701, 24.8719145, -99.6957243, 24.8952154, -99.657343, 0),
(981, 19, 'Iturbide', 'Iturbide', NULL, 0.00418888, 24.7235984, -99.9008836, 0, 0, 0, 0, 28),
(982, 19, 'JuÃ¡rez', 'Juarez', NULL, 0.0403656, 25.6473257, -100.0945282, 25.6264622, -100.1246083, 25.6667269, -100.075758, 50),
(983, 19, 'Lampazos de Naranjo', 'Lampazos de Naranjo', NULL, 0.000761615, 27.0244594, -100.5080126, 27.0135904, -100.5187616, 27.0375437, -100.4910566, 0),
(984, 19, 'Linares', 'Linares', NULL, 0.039604, 24.8578699, -99.5663284, 24.8282818, -99.592631, 24.8927091, -99.5212694, 23),
(986, 19, 'Los Herreras', 'Los Herreras', NULL, 0.000380807, 25.9057049, -99.4064424, 25.8963154, -99.4212354, 25.9150982, -99.3937159, 0),
(987, 19, 'Los Ramones', 'Los Ramones', NULL, 0.00152323, 25.698735, -99.624754, 25.6910531, -99.6359318, 25.7086591, -99.6124272, 0),
(988, 19, 'MarÃn', 'Marin', NULL, 0.0285605, 25.8765202, -100.0275366, 0, 0, 0, 0, 22),
(990, 19, 'Mier y Noriega', 'Mier y Noriega', NULL, 0, 23.425215, -100.116902, 23.4155336, -100.1269877, 23.4330922, -100.1090325, 0),
(991, 19, 'Mina', 'Mina', NULL, 0.0224676, 26.00286, -100.535083, 25.989259, -100.5542482, 26.0100468, -100.5130635, 0),
(992, 19, 'Montemorelos', 'Montemorelos', NULL, 0.0369383, 25.1834959, -99.8296789, 25.1574635, -99.86332, 25.2057994, -99.7993345, 39),
(993, 19, 'Monterrey', 'Monterrey', NULL, 0.276085, 25.673211, -100.309201, 25.5003875, -100.4219686, 25.7972379, -100.184189, 554),
(995, 19, 'PesquerÃa', 'Pesqueria', NULL, 0.0380807, 25.785, -100.0511111, 25.7809767, -100.0616302, 25.8044445, -100.0357595, 31),
(997, 19, 'Sabinas Hidalgo', 'Sabinas Hidalgo', NULL, 0.0106626, 26.5069047, -100.1794529, 26.46545, -100.2248746, 26.5492542, -100.1333807, 0),
(998, 19, 'Salinas Victoria', 'Salinas Victoria', NULL, 0.0342727, 25.9638922, -100.2942166, 25.9512481, -100.3207817, 25.9807917, -100.2767249, 0),
(999, 19, 'San NicolÃ¡s de los Garza', 'San Nicolas de los Garza', NULL, 0.0388423, 25.75, -100.2833333, 25.7012885, -100.3368608, 25.7703826, -100.2037846, 0),
(1000, 19, 'San Pedro Garza GarcÃa', 'San Pedro Garza Garcia', NULL, 0.0418888, 25.6573447, -100.4017501, 25.6116491, -100.4227757, 25.6903946, -100.3127058, 0),
(1001, 19, 'Santa Catarina', 'Santa Catarina', NULL, 0.0437928, 25.6737633, -100.4605976, 25.6492117, -100.5182646, 25.7134771, -100.4159514, 0),
(1002, 19, 'Santiago', 'Santiago', NULL, 0.043412, 25.4269639, -100.1516828, 25.33704, -100.2084334, 25.5210883, -100.0725811, 51),
(1004, 19, 'Villaldama', 'Villaldama', NULL, 0.00266565, 26.5008192, -100.4259596, 26.4910544, -100.4386004, 26.5066392, -100.4189681, 0),
(1005, 20, 'Abejones', 'Abejones', NULL, 0.000761615, 17.4369187, -96.6015104, 0, 0, 0, 0, 21),
(1007, 20, 'Animas Trujano', 'Animas Trujano', NULL, 0.0346535, 16.988687, -96.7138522, 16.982456, -96.7212539, 16.9985879, -96.7085685, 0),
(1010, 20, 'AsunciÃ³n Ixtaltepec', 'Asuncion Ixtaltepec', NULL, 0.00380807, 16.5033247, -95.0551056, 16.4964166, -95.0668885, 16.5232108, -95.0430913, 0),
(1011, 20, 'AsunciÃ³n NochixtlÃ¡n', 'Asuncion Nochixtlan', NULL, 0.00456969, 17.4580238, -97.2243386, 17.4399902, -97.2490317, 17.4785339, -97.2032728, 0),
(1014, 20, 'Ayoquezco de Aldama', 'Ayoquezco de Aldama', NULL, 0, 16.6813409, -96.8430719, 16.6732772, -96.8503462, 16.6974057, -96.8353878, 0),
(1019, 20, 'Chahuites', 'Chahuites', NULL, 0, 16.2865309, -94.1929799, 16.2777767, -94.2019239, 16.2991897, -94.1847156, 0),
(1022, 20, 'CiÃ©nega de ZimatlÃ¡n', 'Cienega de Zimatlan', NULL, 0.000380807, 16.8911771, -96.7682489, 16.8838041, -96.7735254, 16.9001633, -96.7586597, 0),
(1023, 20, 'Ciudad Ixtepec', 'Ciudad Ixtepec', NULL, 0.0201828, 16.5612549, -95.0973974, 16.5330853, -95.1204414, 16.5807265, -95.0699231, 0),
(1029, 20, 'Cosolapa', 'Cosolapa', NULL, 0.0178979, 18.5999277, -96.6845126, 18.5863902, -96.6940368, 18.6062445, -96.6647086, 0),
(1031, 20, 'CuilÃ¡pam de Guerrero', 'Cuilapam de Guerrero', NULL, 0.033511, 16.995719, -96.77968, 16.9653246, -96.8021013, 17.0171812, -96.7634127, 0),
(1034, 20, 'El Espinal', 'El Espinal', NULL, 0.0365575, 16.4842052, -95.0409526, 16.4695715, -95.0477391, 16.4966019, -95.0312585, 0),
(1041, 20, 'Heroica Ciudad de Ejutla de Crespo', 'Heroica Ciudad de Ejutla de Cres', NULL, 0.00114242, 16.5647494, -96.7306673, 16.5379277, -96.7460596, 16.5861519, -96.7135911, 0),
(1043, 20, 'Heroica Ciudad de Tlaxiaco', 'Heroica Ciudad de Tlaxiaco', NULL, 0.0312262, 17.268169, -97.679329, 17.2510371, -97.690842, 17.283892, -97.6637394, 0),
(1045, 20, 'Huautla de JimÃ©nez', 'Huautla de Jimenez', NULL, 0.000761615, 18.1315007, -96.8408526, 18.1185507, -96.8565666, 18.1410175, -96.8186696, 0),
(1048, 20, 'JuchitÃ¡n de Zaragoza', 'Juchitan de Zaragoza', NULL, 0.0293222, 16.4329097, -95.0180514, 16.412326, -95.0402414, 16.4679661, -94.9955876, 0),
(1051, 20, 'La Reforma', 'La Reforma', NULL, 0.108911, 16.6240684, -97.846607, 0, 0, 0, 0, 51),
(1053, 20, 'Loma Bonita', 'Loma Bonita', NULL, 0.00380807, 18.108474, -95.881955, 18.0849625, -95.8994123, 18.1244054, -95.8612409, 0),
(1064, 20, 'Mariscala de JuÃ¡rez', 'Mariscala de Juarez', NULL, 0, 17.8608693, -98.1395347, 17.8557896, -98.1485084, 17.8660285, -98.1324496, 0),
(1066, 20, 'MatÃas Romero AvendaÃ±o', 'Matias Romero Avendaño', NULL, 0.0163747, 16.8890092, -95.030368, 16.8873954, -95.0312283, 16.8900612, -95.0284737, 0),
(1069, 20, 'MiahuatlÃ¡n de Porfirio DÃaz', 'Miahuatlan de Porfirio Diaz', NULL, 0.00152323, 16.328809, -96.596038, 16.3090265, -96.6199038, 16.3534364, -96.5729449, 0),
(1070, 20, 'MixistlÃ¡n de la Reforma', 'Mixistlan de la Reforma', NULL, 0.00495049, 17.454944, -97.2249243, 17.4514293, -97.2250462, 17.4582462, -97.2238217, 0),
(1071, 20, 'Monjas', 'Monjas', NULL, 0.0243717, 16.3679709, -96.6367229, 0, 0, 0, 0, 19),
(1072, 20, 'Natividad', 'Natividad', NULL, 0.0102818, 17.2970261, -96.4299022, 0, 0, 0, 0, 65),
(1076, 20, 'Oaxaca de JuÃ¡rez', 'Oaxaca de Juarez', NULL, 0.0464585, 17.0669444, -96.7202778, 17.029332, -96.7806766, 17.1332787, -96.6907848, 2),
(1077, 20, 'OcotlÃ¡n de Morelos', 'Ocotlan de Morelos', NULL, 0.0285605, 16.7913889, -96.675, 16.7696036, -96.6935899, 16.817452, -96.6502339, 0),
(1080, 20, 'Putla Villa de Guerrero', 'Putla Villa de Guerrero', NULL, 0.0121858, 17.0266617, -97.9271819, 17.0162998, -97.9367223, 17.0427941, -97.9172311, 0),
(1081, 20, 'Reforma de Pineda', 'Reforma de Pineda', NULL, 0, 16.3985129, -94.4586566, 16.3929299, -94.4633821, 16.4062469, -94.4515106, 0),
(1084, 20, 'Salina Cruz', 'Salina Cruz', NULL, 0.0373191, 16.1862509, -95.1924471, 16.1602344, -95.2295054, 16.2327358, -95.1640606, 64),
(1088, 20, 'San AgustÃn de las Juntas', 'San Agustin de las Juntas', NULL, 0.0357959, 17.010985, -96.708268, 16.9984524, -96.718711, 17.0180718, -96.6983519, 0),
(1092, 20, 'San AgustÃn Yatareni', 'San Agustin Yatareni', NULL, 0.0342727, 17.0770782, -96.6672326, 17.0671949, -96.6959244, 17.090032, -96.6607642, 0),
(1096, 20, 'San AndrÃ©s Huayapam', 'San Andres Huayapam', NULL, 0.0361767, 17.1, -96.6666667, 17.0858843, -96.688412, 17.1055621, -96.6601182, 0),
(1109, 20, 'San Antonino el Alto', 'San Antonino el Alto', NULL, 0.0361767, 19.3160974, -98.2073664, 19.3156742, -98.2078768, 19.3163798, -98.2066158, 0),
(1112, 20, 'San Antonio de la Cal', 'San Antonio de la Cal', NULL, 0.033511, 17.0263137, -96.7023761, 17.0142702, -96.7175357, 17.0507881, -96.6849546, 0),
(1117, 20, 'San Baltazar ChichicÃ¡pam', 'San Baltazar Chichicapam', NULL, 0.000380807, 16.7608239, -96.4915466, 16.7526054, -96.5001297, 16.7690425, -96.4829636, 0),
(1120, 20, 'San Bartolo Coyotepec', 'San Bartolo Coyotepec', NULL, 0.0357959, 16.9566138, -96.7063457, 16.9452985, -96.7164695, 16.9634947, -96.6976332, 0),
(1124, 20, 'San BartolomÃ© Loxicha', 'San Bartolome Loxicha', NULL, 0.00342727, 15.971154, -96.7091918, 15.9671158, -96.7149317, 15.9751922, -96.7034519, 0),
(1129, 20, 'San Blas Atempa', 'San Blas Atempa', NULL, 0.0213252, 16.3296269, -95.2253799, 16.3213879, -95.2339579, 16.3394117, -95.2173014, 0),
(1148, 20, 'San Francisco IxhuatÃ¡n', 'San Francisco Ixhuatan', NULL, 0.000380807, 16.35, -94.4833333, 16.3395616, -94.4915032, 16.360985, -94.4736573, 0),
(1152, 20, 'San Francisco NuxaÃ±o', 'San Francisco Nuxaño', NULL, 0.0251333, 37.7749295, -122.4194155, 37.7034, -122.527, 37.812, -122.3482, 5),
(1155, 20, 'San Francisco Telixtlahuaca', 'San Francisco Telixtlahuaca', NULL, 0.00266565, 17.3, -96.9, 17.2840072, -96.9296077, 17.3165917, -96.8958002, 0),
(1162, 20, 'San Jacinto Amilpas', 'San Jacinto Amilpas', NULL, 0.0369383, 17.1047489, -96.7644394, 17.0727123, -96.7673747, 17.1140428, -96.7449434, 0),
(1175, 20, 'San JosÃ© Estancia Grande', 'San Jose Estancia Grande', NULL, 0, 16.3698514, -98.2461361, 16.3581859, -98.2598461, 16.3768389, -98.2365689, 0),
(1191, 20, 'San Juan Bautista Tuxtepec', 'San Juan Bautista Tuxtepec', NULL, 0.0369383, 18.0859, -96.133986, 18.0263626, -96.1781446, 18.1113919, -96.1000174, 0),
(1192, 20, 'San Juan Bautista Valle Nacional', 'San Juan Bautista Valle Nacional', NULL, 0.000380807, 17.774981, -96.3034457, 17.7607918, -96.3250104, 17.7819288, -96.2887973, 0),
(1193, 20, 'San Juan Cacahuatepec', 'San Juan Cacahuatepec', NULL, 0, 16.615974, -98.15664, 16.6029134, -98.164891, 16.6235885, -98.1447315, 0),
(1216, 20, 'San Juan Mixtepec', 'San Juan Mixtepec', NULL, 0, 17.3321436, -97.8786228, 17.3292901, -97.880483, 17.3389992, -97.8760199, 0),
(1217, 20, 'San Juan Mixtepec', 'San Juan Mixtepec', NULL, 0.000380807, 17.3321436, -97.8786228, 17.3292901, -97.880483, 17.3389992, -97.8760199, 0),
(1228, 20, 'San Juan Teposcolula', 'San Juan Teposcolula', NULL, 0.000761615, 17.5504325, -97.4246158, 17.5428927, -97.4334555, 17.5592597, -97.4162894, 0),
(1232, 20, 'San Lorenzo', 'San Lorenzo', NULL, 0.0140899, 16.3927547, -97.8741304, 0, 0, 0, 0, 16),
(1234, 20, 'San Lorenzo Cacaotepec', 'San Lorenzo Cacaotepec', NULL, 0.0365575, 17.128062, -96.803782, 17.1113261, -96.8239529, 17.1378061, -96.784316, 0),
(1249, 20, 'San MartÃn Peras', 'San Martin Peras', NULL, 0, 17.359898, -98.241094, 17.3481806, -98.2500029, 17.3688249, -98.2253695, 0),
(1278, 20, 'San Miguel Panixtlahuaca', 'San Miguel Panixtlahuaca', NULL, 0, 16.2591741, -97.3776626, 16.2426942, -97.3948288, 16.2756541, -97.3604965, 0),
(1283, 20, 'San Miguel Soyaltepec', 'San Miguel Soyaltepec', NULL, 0, 18.2457545, -96.5143087, 18.1127814, -96.6671336, 18.3743989, -96.3511011, 0),
(1287, 20, 'San Miguel Tequixtepec', 'San Miguel Tequixtepec', NULL, 0.000761615, 17.459541, -98.003233, 17.4442549, -98.0144405, 17.4655024, -97.9956007, 0),
(1290, 20, 'San Miguel Tlacotepec', 'San Miguel Tlacotepec', NULL, 0, 17.459541, -98.003233, 17.4442549, -98.0144405, 17.4655024, -97.9956007, 0),
(1293, 20, 'San NicolÃ¡s', 'San Nicolas', NULL, 0.0102818, 16.4248167, -96.7426179, 0, 0, 0, 0, 15),
(1297, 20, 'San Pablo Etla', 'San Pablo Etla', NULL, 0.0247525, 17.146462, -96.761853, 17.1332008, -96.7709833, 17.1665584, -96.7435227, 0),
(1299, 20, 'San Pablo Huixtepec', 'San Pablo Huixtepec', NULL, 0.00342727, 16.8181512, -96.7828273, 16.8029808, -96.8034445, 16.8394023, -96.7722966, 0),
(1302, 20, 'San Pablo Villa de Mitla', 'San Pablo Villa de Mitla', NULL, 0.0171363, 16.9211809, -96.3625098, 16.9083677, -96.4008885, 16.9326516, -96.3382853, 0),
(1308, 20, 'San Pedro Comitancillo', 'San Pedro Comitancillo', NULL, 0.000380807, 16.4899209, -95.1548174, 16.4848737, -95.1654989, 16.4944997, -95.1430279, 0),
(1328, 20, 'San Pedro Pochutla', 'San Pedro Pochutla', NULL, 0.031607, 15.7489259, -96.4672856, 15.7413789, -96.4760471, 15.7601442, -96.4622709, 0),
(1331, 20, 'San Pedro Tapanatepec', 'San Pedro Tapanatepec', NULL, 0.00114242, 16.3693859, -94.1944784, 16.3609104, -94.2038876, 16.3774529, -94.1851939, 0),
(1357, 20, 'San Vicente NuÃ±Ãº', 'San Vicente Nuñu', NULL, 0.0247525, 43.3859325, -4.3980912, 43.3200184, -4.4911719, 43.4058683, -4.3324972, 0),
(1358, 20, 'Santa Ana', 'Santa Ana', NULL, 0.0270373, 16.9919701, -96.4694469, 0, 0, 0, 0, 25),
(1381, 20, 'Santa Cruz Amilpas', 'Santa Cruz Amilpas', NULL, 0.0380807, 17.0574789, -96.6819185, 17.0516937, -96.6886141, 17.0642765, -96.6781423, 0),
(1391, 20, 'Santa Cruz XoxocotlÃ¡n', 'Santa Cruz Xoxocotlan', NULL, 0.0342727, 17.0262131, -96.7327033, 16.9969989, -96.7781844, 17.0469957, -96.7149236, 0),
(1397, 20, 'Santa LucÃa del Camino', 'Santa Lucia del Camino', NULL, 0.0338918, 17.0624715, -96.6956715, 17.0404953, -96.7107607, 17.0820822, -96.6849748, 0),
(1404, 20, 'Santa MarÃa Atzompa', 'Santa Maria Atzompa', NULL, 0.0365575, 17.101676, -96.772527, 17.0713868, -96.7864955, 17.1069194, -96.756724, 0),
(1406, 20, 'Santa MarÃa ChachoÃ¡pam', 'Santa Maria Chachoapam', NULL, 0.0312262, 19.0604905, -98.1322374, 19.0585056, -98.1327462, 19.062617, -98.131215, 0),
(1411, 20, 'Santa MarÃa Coyotepec', 'Santa Maria Coyotepec', NULL, 0.0354151, 16.966201, -96.7062954, 16.9618565, -96.711351, 16.980252, -96.6952955, 0),
(1413, 20, 'Santa MarÃa del Tule', 'Santa Maria del Tule', NULL, 0.0342727, 17.0465834, -96.6336333, 17.0335855, -96.643252, 17.0544724, -96.6224974, 0),
(1417, 20, 'Santa MarÃa Huatulco', 'Huatulco', NULL, 0.00571211, 15.8308582, -96.3198966, 15.822217, -96.3310696, 15.8424597, -96.3089767, 0),
(1422, 20, 'Santa MarÃa Jalapa del MarquÃ©s', 'Santa Maria Jalapa del Marques', NULL, 0.00114242, 16.4399924, -95.4449791, 16.4334762, -95.4538421, 16.4464669, -95.4364389, 0),
(1442, 20, 'Santa MarÃa Tlahuitoltepec', 'Santa Maria Tlahuitoltepec', NULL, 0, 17.098284, -96.064383, 17.0885784, -96.068455, 17.1034375, -96.0556555, 0),
(1446, 20, 'Santa MarÃa Xadani', 'Santa Maria Xadani', NULL, 0.00418888, 16.358804, -95.017081, 16.3514922, -95.0262807, 16.3699043, -95.0108266, 0),
(1472, 20, 'Santiago Jamiltepec', 'Santiago Jamiltepec', NULL, 0.00228484, 16.2816858, -97.8209344, 16.2680753, -97.8367549, 16.2932639, -97.8092027, 0),
(1474, 20, 'Santiago Juxtlahuaca', 'Santiago Juxtlahuaca', NULL, 0.000380807, 17.3330264, -98.0112816, 17.3167566, -98.0194712, 17.3509553, -98.0011381, 0),
(1485, 20, 'Santiago Niltepec', 'Santiago Niltepec', NULL, 0.000380807, 16.5611537, -94.6138639, 16.5523737, -94.6173149, 16.5705472, -94.6051789, 0),
(1488, 20, 'Santiago Pinotepa Nacional', 'Santiago Pinotepa Nacional', NULL, 0.0175171, 16.341345, -98.053625, 16.3273393, -98.0820557, 16.3612706, -98.0376114, 0),
(1489, 20, 'Santiago Suchilquitongo', 'Santiago Suchilquitongo', NULL, 0.000761615, 17.2463779, -96.8701474, 17.2353746, -96.888454, 17.2660113, -96.8528361, 0),
(1497, 20, 'Santiago Tilantongo', 'Santiago Tilantongo', NULL, 0, 17.282364, -97.3394612, 17.2822027, -97.3395648, 17.2824588, -97.3392966, 0),
(1513, 20, 'Santo Domingo Ingenio', 'Santo Domingo Ingenio', NULL, 0, 16.5881717, -94.7659139, 16.5814947, -94.7720264, 16.5942372, -94.7599496, 0),
(1519, 20, 'Santo Domingo Tehuantepec', 'Santo Domingo Tehuantepec', NULL, 0.0247525, 16.3202909, -95.2411554, 16.2913756, -95.2680625, 16.3518654, -95.2122097, 0),
(1523, 20, 'Santo Domingo Tomaltepec', 'Santo Domingo Tomaltepec', NULL, 0.0350343, 17.059875, -96.6220655, 17.0520145, -96.6291613, 17.0671377, -96.6143125, 0),
(1529, 20, 'Santo Domingo Zanatepec', 'Santo Domingo Zanatepec', NULL, 0.000380807, 16.4794342, -94.3519394, 16.4711482, -94.3642941, 16.4879687, -94.3414674, 0),
(1546, 20, 'TeotitlÃ¡n de Flores MagÃ³n', 'Teotitlan de Flores Magon', NULL, 0.00190404, 18.1289417, -97.0720314, 18.1199912, -97.0838026, 18.1507, -97.0616966, 0),
(1547, 20, 'TeotitlÃ¡n del Valle', 'Teotitlan del Valle', NULL, 0.0285605, 17.031004, -96.520541, 17.0068883, -96.5338612, 17.044558, -96.496954, 0),
(1551, 20, 'Tlacolula de Matamoros', 'Tlacolula de Matamoros', NULL, 0.0289414, 16.953737, -96.4758428, 16.9373056, -96.490339, 16.9716933, -96.4599662, 0),
(1553, 20, 'Tlalixtac de Cabrera', 'Tlalixtac de Cabrera', NULL, 0.0338918, 17.0666667, -96.65, 17.0504159, -96.6637864, 17.0921157, -96.6335222, 0),
(1556, 20, 'UniÃ³n Hidalgo', 'Union Hidalgo', NULL, 0.000761615, 16.4720792, -94.8311109, 16.4616269, -94.845151, 16.4933588, -94.8205265, 0),
(1559, 20, 'Villa de Etla', 'Villa de Etla', NULL, 0.00418888, 17.2065497, -96.7981239, 17.1838377, -96.8105321, 17.2152791, -96.7909601, 0),
(1560, 20, 'Villa de TamazulÃ¡pam del Progreso', 'Villa de Tamazulapam del Progres', NULL, 0.00190404, 17.6724247, -97.5720481, 17.6664286, -97.5777758, 17.6836354, -97.5642025, 0),
(1562, 20, 'Villa de Zaachila', 'Villa de Zaachila', NULL, 0.0342727, 16.9485476, -96.7518787, 16.936629, -96.7692231, 16.9640514, -96.7391059, 0),
(1574, 20, 'ZimatlÃ¡n de Alvarez', 'Zimatlan de Alvarez', NULL, 0.0354151, 16.8666667, -96.7833333, 16.8514937, -96.7968992, 16.879953, -96.7688864, 0),
(1575, 21, 'Acajete', 'Acajete', NULL, 0.00418888, 19.1062912, -97.9524076, 19.0918052, -97.969294, 19.1346403, -97.920382, 0),
(1576, 21, 'Acateno', 'Acateno', NULL, 0, 20.129878, -97.20855, 20.1219096, -97.2213864, 20.1400014, -97.2001648, 0),
(1584, 21, 'Ajalpan', 'Ajalpan', NULL, 0.00228484, 18.3781582, -97.2591254, 18.3574568, -97.2997184, 18.3905353, -97.2414382, 0),
(1587, 21, 'Altepexi', 'Altepexi', NULL, 0, 18.3693057, -97.2983326, 18.3570647, -97.3067127, 18.380094, -97.2875367, 0);
INSERT INTO `ciudad` (`id_ciudad`, `id_estado`, `nombre`, `nombre_coloquial`, `tags`, `popularidad`, `lat`, `lng`, `bsw_lat`, `bsw_lng`, `bne_lat`, `bne_lng`, `vistas`) VALUES
(1589, 21, 'Amozoc', 'Amozoc', NULL, 0.029703, 19.04077, -98.045937, 19.0260982, -98.1327408, 19.0729616, -98.0170638, 0),
(1590, 21, 'Aquixtla', 'Aquixtla', NULL, 0, 19.7960219, -97.9337844, 0, 0, 0, 0, 7),
(1594, 21, 'Atlixco', 'Atlixco', NULL, 0.043412, 18.902286, -98.439208, 18.8565888, -98.4849963, 18.9523396, -98.4082969, 41),
(1595, 21, 'Atoyatempan', 'Atoyatempan', NULL, 0.0175171, 18.8210292, -97.9132021, 18.8087914, -97.9277511, 18.8326454, -97.9034182, 0),
(1597, 21, 'AtzitzihuacÃ¡n', 'Atzitzihuacan', NULL, 0.0308454, 18.9176085, -98.4161645, 18.9165606, -98.4163603, 18.9186549, -98.4158708, 0),
(1606, 21, 'Chalchicomula de Sesma', 'Chalchicomula de Sesma', NULL, 0.00228484, 19.0038141, -97.4580818, 19.0013907, -97.4603309, 19.007271, -97.4554584, 0),
(1612, 21, 'Chietla', 'Chietla', NULL, 0.00304646, 18.5206314, -98.5782426, 18.5117775, -98.5851768, 18.5278151, -98.5652744, 0),
(1614, 21, 'Chignahuapan', 'Chignahuapan', NULL, 0.0323686, 19.8386111, -98.0313889, 19.8199517, -98.0567205, 19.8554951, -98.0114047, 22),
(1615, 21, 'Chignautla', 'Chignautla', NULL, 0.033511, 19.8126139, -97.3888194, 19.7997737, -97.4000763, 19.8253068, -97.3812353, 53),
(1624, 21, 'Coronango', 'Coronango', NULL, 0.033511, 19.076861, -98.2912215, 19.0762737, -98.2927802, 19.0774288, -98.2895164, 0),
(1625, 21, 'CoxcatlÃ¡n', 'Coxcatlan', NULL, 0.000380807, 18.264272, -97.152333, 18.257041, -97.1708328, 18.2769842, -97.136549, 0),
(1627, 21, 'Coyotepec', 'Coyotepec', NULL, 0.0338918, 19.7763584, -99.2211956, 19.7708144, -99.2223022, 19.7801719, -99.2203079, 0),
(1628, 21, 'Cuapiaxtla de Madero', 'Cuapiaxtla de Madero', NULL, 0.0327494, 18.914272, -97.823801, 18.9044184, -97.8394469, 18.9267052, -97.8112228, 0),
(1629, 21, 'Cuautempan', 'Cuautempan', NULL, 0.0350343, 19.3055642, -98.206471, 19.3051065, -98.2071638, 19.3059857, -98.2055748, 0),
(1631, 21, 'Cuautlancingo', 'Cuautlancingo', NULL, 0.0350343, 19.1044894, -98.2765151, 19.1027321, -98.2776957, 19.1059799, -98.2756206, 0),
(1632, 21, 'Cuayuca de Andrade', 'Cuayuca de Andrade', NULL, 0.0502666, 19.0412967, -98.2061996, 18.9443809, -98.2825047, 19.1381978, -98.1035012, 0),
(1635, 21, 'Domingo Arenas', 'Domingo Arenas', NULL, 0.00304646, 19.139428, -98.459528, 19.1288353, -98.4699861, 19.148243, -98.4366001, 0),
(1637, 21, 'EpatlÃ¡n', 'Epatlan', NULL, 0.0346535, 19.9350819, -97.9611534, 19.9129879, -97.9848458, 19.9763799, -97.9391484, 0),
(1638, 21, 'Esperanza', 'Esperanza', NULL, 0.031607, 18.8579982, -97.3735416, 18.8514776, -97.3890138, 18.8651842, -97.3683804, 52),
(1639, 21, 'Francisco Z. Mena', 'Francisco Z. Mena', NULL, 0.0536938, 19.0412967, -98.2061996, 18.9443809, -98.2825047, 19.1381978, -98.1035012, 0),
(1640, 21, 'General Felipe ?ngeles', 'General Felipe ?ngeles', NULL, 0.0342727, 19.0412967, -98.2061996, 18.9443809, -98.2825047, 19.1381978, -98.1035012, 0),
(1641, 21, 'Guadalupe', 'Guadalupe', NULL, 0.0441736, 19.0755999, -98.242491, 19.0736638, -98.2439076, 19.0789857, -98.2396793, 45),
(1642, 21, 'Guadalupe Victoria', 'Guadalupe Victoria', NULL, 0.000380807, 19.290403, -97.3409, 19.2790758, -97.3517322, 19.2991643, -97.3305665, 0),
(1643, 21, 'Hermenegildo Galeana', 'Hermenegildo Galeana', NULL, 0.0285605, 19.8473132, -98.0212939, 19.8412441, -98.0274511, 19.8538087, -98.018206, 0),
(1647, 21, 'Huauchinango', 'Huauchinango', NULL, 0.0338918, 20.1735104, -98.0587744, 20.1563999, -98.0870878, 20.1957539, -98.0298432, 0),
(1651, 21, 'Huejotzingo', 'Huejotzingo', NULL, 0.0369383, 19.15, -98.4, 19.1316984, -98.4246462, 19.1756382, -98.3843509, 28),
(1652, 21, 'Hueyapan', 'Hueyapan', NULL, 0.00190404, 18.8860004, -98.6908754, 18.864462, -98.7059124, 18.9021218, -98.6634635, 0),
(1655, 21, 'Huitzilan de SerdÃ¡n', 'Huitzilan de Serdan', NULL, 0.0373191, 19.0338977, -98.2488935, 19.0338164, -98.2489367, 19.0343941, -98.2485059, 0),
(1656, 21, 'Huitziltepec', 'Huitziltepec', NULL, 0.0327494, 19.683737, -99.137352, 19.6831939, -99.1374668, 19.6843626, -99.1372144, 0),
(1657, 21, 'Ixcamilpa de Guerrero', 'Ixcamilpa de Guerrero', NULL, 0, 18.028998, -98.69548, 18.0248127, -98.7046695, 18.0341169, -98.6869884, 0),
(1658, 21, 'Ixcaquixtla', 'Ixcaquixtla', NULL, 0.000380807, 18.4596474, -97.8314651, 18.4534147, -97.8379014, 18.4685502, -97.8240556, 0),
(1661, 21, 'IzÃºcar de Matamoros', 'Izucar de Matamoros', NULL, 0.0209444, 18.6, -98.4666667, 18.5667781, -98.502604, 18.6293628, -98.4427105, 0),
(1663, 21, 'Jolalpan', 'Jolalpan', NULL, 0, 18.3219444, -98.8444444, 18.3156491, -98.8517788, 18.3314101, -98.836437, 0),
(1666, 21, 'Juan C. Bonilla', 'Juan C. Bonilla', NULL, 0.0357959, 19.0211845, -98.1824786, 19.0203768, -98.1838294, 19.0219153, -98.1812084, 0),
(1667, 21, 'Juan Galindo', 'Juan Galindo', NULL, 0, 20.177413, -98.0464796, 20.1764384, -98.0507452, 20.1779865, -98.0426995, 0),
(1668, 21, 'Juan N. MÃ©ndez', 'Juan N. Mendez', NULL, 0.0338918, 19.0692582, -98.1335466, 19.0682888, -98.135305, 19.0700535, -98.1319298, 0),
(1670, 21, 'Lafragua', 'Lafragua', NULL, 0.031607, 20.1759215, -98.0597391, 20.1746919, -98.0600702, 20.177567, -98.0597078, 0),
(1671, 21, 'Libres', 'Libres', NULL, 0.0258949, 19.4645849, -97.6850784, 19.4555207, -97.6923189, 19.4737509, -97.6777954, 49),
(1672, 21, 'Los Reyes de JuÃ¡rez', 'Los Reyes de Juarez', NULL, 0.00152323, 18.9463397, -97.8060092, 18.9266612, -97.8339128, 18.9739134, -97.7896338, 0),
(1674, 21, 'Mixtla', 'Mixtla', NULL, 0.0338918, 19.0267194, -98.3063895, 19.0264082, -98.3071647, 19.0271874, -98.3055997, 0),
(1680, 21, 'Nopalucan', 'Nopalucan', NULL, 0.0506474, 19.0515137, -98.2246387, 19.0507126, -98.2248455, 19.0522711, -98.2237601, 0),
(1682, 21, 'Ocoyucan', 'Ocoyucan', NULL, 0.0262757, 18.9510376, -98.2418579, 18.9504265, -98.2468222, 18.9519164, -98.2377813, 0),
(1684, 21, 'Oriental', 'Oriental', NULL, 0.144326, 19.376774, -97.619444, 19.3700638, -97.6284867, 19.3846372, -97.6082776, 43),
(1685, 21, 'PahuatlÃ¡n', 'Pahuatlan', NULL, 0.0361767, 19.0802207, -98.3061988, 19.079523, -98.3064853, 19.0811239, -98.3056035, 49),
(1690, 21, 'Puebla', 'Puebla', NULL, 0.722772, 19.0412967, -98.2061996, 18.9443809, -98.2824308, 19.1381978, -98.1035012, 356),
(1691, 21, 'Quecholac', 'Quecholac', NULL, 0, 18.9567807, -97.6577564, 18.9398187, -97.6704197, 18.9684934, -97.6456107, 0),
(1694, 21, 'San AndrÃ©s Cholula', 'San Andres Cholula', NULL, 0.0365575, 19.05, -98.3, 19.0046196, -98.3271112, 19.068516, -98.2596571, 6),
(1697, 21, 'San Felipe Teotlalcingo', 'San Felipe Teotlalcingo', NULL, 0, 19.236583, -98.501544, 19.2201831, -98.5123289, 19.2536317, -98.4884919, 0),
(1699, 21, 'San Gabriel Chilac', 'San Gabriel Chilac', NULL, 0.00152323, 18.33226, -97.347214, 18.3129519, -97.3605185, 18.3530591, -97.3315445, 0),
(1700, 21, 'San Gregorio Atzompa', 'San Gregorio Atzompa', NULL, 0.0266565, 19.0216769, -98.3501646, 19.0104898, -98.3605809, 19.0331012, -98.3348289, 0),
(1702, 21, 'San JerÃ³nimo XayacatlÃ¡n', 'San Jeronimo Xayacatlan', NULL, 0.00342727, 18.2205462, -97.9132461, 18.2042404, -97.9304123, 18.2368521, -97.89608, 0),
(1703, 21, 'San JosÃ© Chiapa', 'San Jose Chiapa', NULL, 0.011805, 19.2388424, -97.7677154, 19.2300009, -97.7771349, 19.2476917, -97.7574269, 0),
(1704, 21, 'San JosÃ© MiahuatlÃ¡n', 'San Jose Miahuatlan', NULL, 0.00342727, 18.2902132, -97.2893926, 18.2817087, -97.2972303, 18.2982459, -97.2779249, 0),
(1707, 21, 'San MartÃn Texmelucan', 'San Martin Texmelucan', NULL, 0.0342727, 19.2833333, -98.4333333, 19.266203, -98.458516, 19.3112315, -98.410955, 44),
(1709, 21, 'San MatÃas Tlalancaleca', 'San Matias Tlalancaleca', NULL, 0.0361767, 19.3241584, -98.5309068, 19.3145279, -98.5398012, 19.3382891, -98.5211978, 0),
(1711, 21, 'San Miguel Xoxtla', 'San Miguel Xoxtla', NULL, 0.0053313, 19.1669422, -98.3072771, 19.1543997, -98.3237744, 19.1823288, -98.2969347, 0),
(1712, 21, 'San NicolÃ¡s Buenos Aires', 'San Nicolas Buenos Aires', NULL, 0.0338918, 18.4902637, -97.4014738, 18.4899274, -97.4025186, 18.4904088, -97.4003569, 0),
(1713, 21, 'San NicolÃ¡s de los Ranchos', 'San Nicolas de los Ranchos', NULL, 0.000380807, 19.0666667, -98.4833333, 19.0626479, -98.4981108, 19.0765693, -98.4767644, 0),
(1714, 21, 'San Pablo Anicano', 'San Pablo Anicano', NULL, 0, 19.0412967, -98.2061996, 18.9443809, -98.2825047, 19.1381978, -98.1035012, 0),
(1715, 21, 'San Pedro Cholula', 'San Pedro Cholula', NULL, 0.019802, 19.0869031, -98.1409389, 19.0859208, -98.1409389, 19.0869031, -98.1389575, 0),
(1717, 21, 'San Salvador el Seco', 'San Salvador el Seco', NULL, 0.00152323, 19.1361111, -97.6405556, 19.1184269, -97.6540338, 19.1559369, -97.6256712, 0),
(1719, 21, 'San Salvador Huixcolotla', 'San Salvador Huixcolotla', NULL, 0.00114242, 18.9196356, -97.7708493, 18.8996193, -97.7889921, 18.9326362, -97.7606441, 0),
(1724, 21, 'Santiago MiahuatlÃ¡n', 'Santiago Miahuatlan', NULL, 0.000761615, 18.5472762, -97.4393864, 18.5224531, -97.4560437, 18.5612989, -97.4261748, 0),
(1725, 21, 'Santo TomÃ¡s Hueyotlipan', 'Santo Tomas Hueyotlipan', NULL, 0, 18.8904645, -97.8663935, 18.8804983, -97.8737663, 18.897644, -97.8584716, 0),
(1727, 21, 'Tecali de Herrera', 'Tecali de Herrera', NULL, 0.00266565, 18.9022377, -97.9742086, 18.8930827, -97.9829261, 18.9130859, -97.9624789, 0),
(1728, 21, 'Tecamachalco', 'Tecamachalco', NULL, 0.0304646, 18.8812454, -97.7328786, 18.8643501, -97.7671159, 18.8997406, -97.7103892, 0),
(1730, 21, 'TehuacÃ¡n', 'Tehuacan', NULL, 0.0601676, 18.4625, -97.3927778, 18.4141407, -97.4591264, 18.5091885, -97.3576741, 104),
(1731, 21, 'Tehuitzingo', 'Tehuitzingo', NULL, 0.000761615, 18.3319444, -98.2755556, 18.3189334, -98.2886692, 18.3439969, -98.256869, 0),
(1735, 21, 'Tepanco de LÃ³pez', 'Tepanco de Lopez', NULL, 0.00228484, 18.5537917, -97.5605324, 18.5486082, -97.5723489, 18.5622417, -97.5532054, 0),
(1737, 21, 'Tepatlaxco de Hidalgo', 'Tepatlaxco de Hidalgo', NULL, 0, 19.0794879, -97.9712704, 19.0649574, -97.9858093, 19.0964326, -97.9583326, 0),
(1738, 21, 'Tepeaca', 'Tepeaca', NULL, 0.0304646, 18.9647299, -97.9031366, 18.94116, -97.9305221, 19.0001433, -97.8750584, 0),
(1741, 21, 'Tepetzintla', 'Tepetzintla', NULL, 0, 19.0920669, -98.2370212, 19.0903915, -98.2394689, 19.0948717, -98.2352441, 0),
(1745, 21, 'Tepeyahualco de CuauhtÃ©moc', 'Tepeyahualco de Cuauhtemoc', NULL, 0.000380807, 18.8190533, -97.9089346, 18.8171365, -97.9137122, 18.8209887, -97.9038142, 0),
(1748, 21, 'TeziutlÃ¡n', 'Teziutlan', NULL, 0.0380807, 19.8169087, -97.3590531, 19.7882015, -97.3814305, 19.8438241, -97.3414291, 36),
(1751, 21, 'Tlachichuca', 'Tlachichuca', NULL, 0, 19.1150587, -97.4170531, 19.1060609, -97.4307957, 19.1239413, -97.4104281, 0),
(1752, 21, 'Tlacotepec de Benito JuÃ¡rez', 'Tlacotepec de Benito Juarez', NULL, 0.000761615, 18.6802637, -97.6522884, 18.6408369, -97.6756405, 18.7059707, -97.627998, 0),
(1755, 21, 'Tlaltenango', 'Tlaltenango', NULL, 0.000761615, 19.1705854, -98.3422856, 19.1575213, -98.3595196, 19.1920142, -98.3292523, 0),
(1756, 21, 'Tlanepantla', 'Tlanepantla', NULL, 0.0300838, 18.95, -98.2333333, 0, 0, 0, 0, 22),
(1760, 21, 'Tlatlauquitepec', 'Tlatlauquitepec', NULL, 0.033511, 19.852314, -97.495534, 19.8341505, -97.5059266, 19.8657852, -97.4859156, 72),
(1763, 21, 'Tochtepec', 'Tochtepec', NULL, 0, 18.840967, -97.82265, 18.8282942, -97.8322764, 18.8482268, -97.8066757, 0),
(1764, 21, 'Totoltepec de Guerrero', 'Totoltepec de Guerrero', NULL, 0.00266565, 18.2234824, -97.8554479, 0, 0, 0, 0, 66),
(1768, 21, 'Venustiano Carranza', 'Venustiano Carranza', NULL, 0.0121858, 20.5077822, -97.6711959, 20.5001924, -97.6841297, 20.5132662, -97.6575664, 39),
(1769, 21, 'Vicente Guerrero', 'Vicente Guerrero', NULL, 0.0392232, 19.0068428, -98.2301846, 19.0009502, -98.2347457, 19.0111178, -98.2245496, 0),
(1771, 21, 'Xicotepec', 'Xicotepec', NULL, 0.0266565, 18.9498844, -98.2443364, 18.9496644, -98.2472203, 18.9505122, -98.2412397, 56),
(1773, 21, 'Xiutetelco', 'Xiutetelco', NULL, 0.0327494, 19.4287618, -99.0569507, 19.4286039, -99.0571882, 19.4289197, -99.0567131, 25),
(1774, 21, 'Xochiapulco', 'Xochiapulco', NULL, 0.0327494, 19.0177756, -98.3098548, 19.0159989, -98.3135196, 19.0199956, -98.3068772, 38),
(1775, 21, 'Xochiltepec', 'Xochiltepec', NULL, 0.000380807, 18.652394, -98.340592, 18.6133458, -98.3646297, 18.6794227, -98.2783699, 0),
(1776, 21, 'XochitlÃ¡n de Vicente SuÃ¡rez', 'Xochitlan de Vicente Suarez', NULL, 0.0369383, 19.0210671, -98.1755144, 19.0173917, -98.1782423, 19.024988, -98.1735748, 0),
(1777, 21, 'XochitlÃ¡n Todos Santos', 'Xochitlan Todos Santos', NULL, 0.0540746, 16.7938692, -93.1017749, 16.7927193, -93.1019142, 16.794965, -93.1016401, 0),
(1779, 21, 'Yehualtepec', 'Yehualtepec', NULL, 0.000761615, 18.7913619, -97.6647084, 18.7802779, -97.675199, 18.8037671, -97.6509951, 0),
(1781, 21, 'Zacapoaxtla', 'Zacapoaxtla', NULL, 0.0308454, 19.876261, -97.587624, 19.8574509, -97.5967983, 19.8941047, -97.583644, 54),
(1782, 21, 'ZacatlÃ¡n', 'Zacatlan', NULL, 0.033511, 19.9350819, -97.9611534, 19.9129879, -97.9848458, 19.9763799, -97.9391484, 48),
(1785, 21, 'Zaragoza', 'Zaragoza', NULL, 0.0403656, 19.7708754, -97.5521226, 19.7579032, -97.5630143, 19.7802761, -97.5443217, 40),
(1788, 21, 'Zinacatepec', 'Zinacatepec', NULL, 0, 18.3346414, -97.2471439, 18.3271604, -97.2558241, 18.3447114, -97.2379511, 0),
(1792, 22, 'Amealco de Bonfil', 'Amealco de Bonfil', NULL, 0.0133283, 20.1880556, -100.1438889, 20.1780988, -100.1609863, 20.1976066, -100.1347696, 0),
(1794, 22, 'Cadereyta de Montes', 'Cadereyta de Montes', NULL, 0.0293222, 20.692759, -99.818149, 20.6755782, -99.8410815, 20.7084759, -99.8035218, 0),
(1795, 22, 'ColÃ³n', 'Colon', NULL, 0.0220868, 20.7833333, -100.05, 20.7690222, -100.0591283, 20.7937966, -100.0367149, 46),
(1796, 22, 'Corregidora', 'Corregidora', NULL, 0.0411272, 20.5365909, -100.4411011, 0, 0, 0, 0, 41),
(1797, 22, 'El MarquÃ©s', 'El Marques', NULL, 0.0555979, 20.5835963, -100.3729496, 20.5794625, -100.3751172, 20.5878618, -100.3697507, 25),
(1798, 22, 'Ezequiel Montes', 'Ezequiel Montes', NULL, 0.0350343, 20.6633242, -99.8983554, 20.6451803, -99.9102657, 20.6831626, -99.8876053, 0),
(1800, 22, 'Jalpan de Serra', 'Jalpan de Serra', NULL, 0.0224676, 21.2164112, -99.4748416, 21.2046295, -99.4828635, 21.2298595, -99.4564987, 25),
(1802, 22, 'Pedro Escobedo', 'Pedro Escobedo', NULL, 0.0255141, 20.4997867, -100.1433006, 20.4906873, -100.1591816, 20.5149946, -100.1303415, 37),
(1805, 22, 'QuerÃ©taro', 'Queretaro', NULL, 0.557121, 20.5930556, -100.3922222, 20.5434422, -100.4783277, 20.6854033, -100.3285435, 591),
(1806, 22, 'San JoaquÃn', 'San Joaquin', NULL, 0.0159939, 20.9141054, -99.5622579, 0, 0, 0, 0, 28),
(1807, 22, 'San Juan del RÃo', 'San Juan del Rio', NULL, 0.0460777, 20.391528, -99.981438, 20.357458, -100.0205741, 20.4488799, -99.9262448, 163),
(1808, 22, 'Tequisquiapan', 'Tequisquiapan', NULL, 0.0384615, 20.5223037, -99.8882794, 20.5020111, -99.9120887, 20.5670982, -99.8739712, 39),
(1810, 23, 'Benito JuÃ¡rez', 'Benito Juarez', NULL, 0.0319878, 22.2099928, -97.8345229, 22.2093539, -97.8352793, 22.2114948, -97.8334925, 0),
(1811, 23, 'Cozumel', 'Cozumel', NULL, 0.0693069, 20.510071, -86.948914, 0, 0, 0, 0, 185),
(1812, 23, 'Felipe Carrillo Puerto', 'Felipe Carrillo Puerto', NULL, 0.0304646, 19.5775094, -88.0454061, 19.5611418, -88.0699761, 19.5957051, -88.0273308, 0),
(1813, 23, 'Isla Mujeres', 'Isla Mujeres', NULL, 0.0365575, 21.233782, -86.733112, 21.2205627, -86.7545287, 21.2666166, -86.7240489, 36),
(1814, 23, 'JosÃ© MarÃa Morelos', 'Jose Maria Morelos', NULL, 0.00571211, 19.74538, -88.712678, 19.728376, -88.7234766, 19.7650653, -88.6951606, 0),
(1815, 23, 'LÃ¡zaro CÃ¡rdenas', 'Lazaro Cardenas', NULL, 0.0308454, 19.5816169, -88.0485731, 19.5770382, -88.062992, 19.5860079, -88.0334876, 22),
(1816, 23, 'OthÃ³n P. Blanco', 'Othon P. Blanco', NULL, 0.0323686, 21.2369646, -86.7350153, 21.2366651, -86.7357903, 21.2372624, -86.7342109, 0),
(1817, 23, 'Solidaridad', 'Solidaridad', NULL, 0.0529322, 21.0750369, -86.8609129, 21.0738807, -86.8691035, 21.0761133, -86.852398, 28),
(1822, 24, 'Axtla de Terrazas', 'Axtla de Terrazas', NULL, 0.00418888, 21.4357319, -98.8750694, 21.4271904, -98.8834521, 21.4485501, -98.8626363, 0),
(1823, 24, 'CÃ¡rdenas', 'Cardenas', NULL, 0.00380807, 22.0043514, -99.6414554, 21.9842447, -99.6535749, 22.0148484, -99.6257456, 0),
(1825, 24, 'Cedral', 'Cedral', NULL, 0.011805, 23.8217164, -100.7217911, 23.8049452, -100.7438272, 23.8304726, -100.7042148, 38),
(1826, 24, 'Cerritos', 'Cerritos', NULL, 0.0148515, 22.4310187, -100.2825116, 22.4163203, -100.2980267, 22.4483341, -100.2676291, 0),
(1828, 24, 'Charcas', 'Charcas', NULL, 0.00495049, 23.130631, -101.11137, 23.1147144, -101.1317171, 23.1417519, -101.0991292, 0),
(1829, 24, 'Ciudad del MaÃz', 'Ciudad del Maiz', NULL, 0.00418888, 22.399851, -99.602943, 22.3898924, -99.6214067, 22.4123587, -99.5917556, 0),
(1830, 24, 'Ciudad FernÃ¡ndez', 'Ciudad Fernandez', NULL, 0.0350343, 21.9368487, -100.0303723, 21.9060697, -100.0618003, 21.9689681, -100.0004893, 0),
(1831, 24, 'Ciudad Valles', 'Ciudad Valles', NULL, 0.0388423, 21.994665, -99.01074, 21.9466696, -99.0652491, 22.0385789, -98.9581262, 0),
(1833, 24, 'Ebano', 'Ebano', NULL, 0.0201828, 22.2134289, -98.3811276, 22.200451, -98.4052338, 22.2369302, -98.3552702, 0),
(1834, 24, 'El Naranjo', 'El Naranjo', NULL, 0.0114242, 22.5224, -99.330138, 22.5105666, -99.3431818, 22.5419888, -99.314834, 30),
(1838, 24, 'Matehuala', 'Matehuala', NULL, 0.031607, 23.6527492, -100.6438906, 23.5999391, -100.6659064, 23.6896796, -100.6115678, 16),
(1840, 24, 'Mexquitic de Carmona', 'Mexquitic de Carmona', NULL, 0.0338918, 22.1890639, -101.0155704, 22.1838578, -101.0239386, 22.1933899, -101.0078886, 0),
(1841, 24, 'Moctezuma', 'Moctezuma', NULL, 0.00380807, 22.7480469, -101.0806491, 22.7430409, -101.0950914, 22.7643434, -101.0674226, 0),
(1842, 24, 'RayÃ³n', 'Rayon', NULL, 0.00418888, 21.8413104, -99.6444181, 21.8362488, -99.6660924, 21.8543251, -99.6281845, 0),
(1843, 24, 'Rioverde', 'Rioverde', NULL, 0.0312262, 21.9317954, -99.9917266, 21.8762927, -100.0149282, 21.9570544, -99.9600032, 0),
(1844, 24, 'Salinas', 'Salinas', NULL, 0.0243717, 22.6204243, -101.7153697, 22.6009484, -101.7295676, 22.6412207, -101.6958622, 33),
(1845, 24, 'San Antonio', 'San Antonio', NULL, 0.0483625, 22.1561019, -100.9573884, 22.1546931, -100.961349, 22.1572475, -100.9561825, 146),
(1846, 24, 'San Ciro de Acosta', 'San Ciro de Acosta', NULL, 0, 21.6521532, -99.8174976, 21.6318332, -99.8318907, 21.6665906, -99.8063343, 0),
(1847, 24, 'San Luis PotosÃ', 'San Luis Potosi', NULL, 0.270373, 22.1564699, -100.9855409, 22.0620884, -101.0400471, 22.2092432, -100.8747596, 2076),
(1850, 24, 'San Vicente Tancuayalab', 'San Vicente Tancuayalab', NULL, 0, 21.717905, -98.58744, 21.7107476, -98.5993622, 21.7314841, -98.5723293, 0),
(1851, 24, 'Santa Catarina', 'Santa Catarina', NULL, 0.00609292, 21.6687834, -99.4864624, 0, 0, 0, 0, 15),
(1852, 24, 'Santa MarÃa del RÃo', 'Santa Maria del Rio', NULL, 0.0053313, 21.8001154, -100.7289786, 21.7884178, -100.7577523, 21.8228001, -100.7177753, 0),
(1854, 24, 'Soledad de Graciano SÃ¡nchez', 'Soledad de Graciano Sanchez', NULL, 0.0312262, 22.1833333, -100.9333333, 22.1379215, -100.9679879, 22.2123362, -100.8907797, 0),
(1856, 24, 'Tamazunchale', 'Tamazunchale', NULL, 0.0148515, 21.25423, -98.788017, 21.2416291, -98.8022205, 21.2676053, -98.7664547, 0),
(1859, 24, 'TamuÃn', 'Tamuin', NULL, 0.0163747, 22.0058394, -98.7843326, 21.9970457, -98.801264, 22.0189039, -98.7523271, 0),
(1862, 24, 'TanquiÃ¡n de Escobedo', 'Tanquian de Escobedo', NULL, 0, 21.6, -98.6666667, 21.5924803, -98.6813483, 21.6158367, -98.6456873, 0),
(1863, 24, 'Tierra Nueva', 'Tierra Nueva', NULL, 0.00990099, 21.6684354, -100.5760293, 21.6551244, -100.5865981, 21.6818786, -100.5656561, 11),
(1865, 24, 'Venado', 'Venado', NULL, 0.0167555, 22.9311602, -101.0930134, 22.9261124, -101.1016556, 22.9376959, -101.0836776, 27),
(1866, 24, 'Villa de Arista', 'Villa de Arista', NULL, 0.000761615, 22.6435897, -100.8489466, 22.6330373, -100.8568639, 22.6524431, -100.8365108, 0),
(1867, 24, 'Villa de Arriaga', 'Villa de Arriaga', NULL, 0.00152323, 21.9075889, -101.3817949, 21.9021182, -101.3902076, 21.9154472, -101.3752146, 0),
(1869, 24, 'Villa de la Paz', 'Villa de la Paz', NULL, 0.0304646, 22.1335057, -101.032691, 22.1330237, -101.0327883, 22.1338802, -101.0323311, 32),
(1871, 24, 'Villa de Reyes', 'Villa de Reyes', NULL, 0.0114242, 21.807409, -100.937798, 21.788867, -100.9520297, 21.8380173, -100.9181046, 0),
(1873, 24, 'Villa JuÃ¡rez', 'Villa Juarez', NULL, 0, 22.3250792, -100.2668184, 22.3161949, -100.2742144, 22.3330394, -100.2548204, 0),
(1874, 24, 'Xilitla', 'Xilitla', NULL, 0.0289414, 21.383169, -98.991173, 21.3770532, -99.0019172, 21.3929182, -98.9833544, 0),
(1875, 24, 'Zaragoza', 'Zaragoza', NULL, 0.0891089, 22.1930212, -100.9377082, 22.1878736, -100.9389189, 22.198859, -100.9365597, 43),
(1876, 25, 'Ahome', 'Ahome', NULL, 0.0163747, 25.91194, -109.1735, 25.9064536, -109.1942902, 25.9363042, -109.1559852, 24),
(1877, 25, 'Angostura', 'Angostura', NULL, 0.0137091, 25.3679709, -108.1591316, 25.3591299, -108.1696574, 25.3724954, -108.1514456, 0),
(1879, 25, 'Choix', 'Choix', NULL, 0.0175171, 26.7075, -108.325, 26.6972825, -108.3372326, 26.721981, -108.3154138, 24),
(1880, 25, 'Concordia', 'Concordia', NULL, 0.029703, 23.2880556, -106.0677778, 23.2778021, -106.0770284, 23.3001812, -106.0507827, 0),
(1881, 25, 'CosalÃ¡', 'Cosala', NULL, 0.00418888, 24.4125, -106.6908333, 24.4026565, -106.708276, 24.4298363, -106.6762244, 16),
(1882, 25, 'CuliacÃ¡n', 'Culiacan', NULL, 0.0780655, 24.8041667, -107.4311111, 24.7322684, -107.5189122, 24.8775659, -107.327716, 148),
(1883, 25, 'El Fuerte', 'El Fuerte', NULL, 0.0354151, 26.4147974, -108.6192749, 26.4038516, -108.6303585, 26.4286927, -108.6036906, 0),
(1885, 25, 'Escuinapa', 'Escuinapa', NULL, 0.0220868, 22.8333333, -105.7833333, 22.816684, -105.7976805, 22.8500746, -105.7639317, 2),
(1886, 25, 'Guasave', 'Guasave', NULL, 0.0361767, 25.5744444, -108.4705556, 25.539789, -108.496542, 25.6020295, -108.4509467, 46),
(1887, 25, 'MazatlÃ¡n', 'Mazatlan', NULL, 0.0780655, 23.2266877, -106.4076183, 23.1759127, -106.4939668, 23.3175954, -106.3503134, 223),
(1888, 25, 'Mocorito', 'Mocorito', NULL, 0.00571211, 25.4833333, -107.9166667, 25.4749799, -107.9334889, 25.4907617, -107.9080327, 0),
(1889, 25, 'Navolato', 'Navolato', NULL, 0.00495049, 24.7652778, -107.7016667, 24.7426994, -107.7311547, 24.7771378, -107.6732018, 0),
(1890, 25, 'Rosario', 'Rosario', NULL, 0.0114242, 26.9448579, -108.4620131, 0, 0, 0, 0, 24),
(1891, 25, 'Salvador Alvarado', 'Salvador Alvarado', NULL, 0.0300838, 24.8320824, -107.4166432, 24.8218337, -107.4217339, 24.8433637, -107.4132891, 0),
(1892, 25, 'San Ignacio', 'San Ignacio', NULL, 0.0152323, 23.9420684, -106.4280389, 0, 0, 0, 0, 64),
(1893, 25, 'Sinaloa', 'Sinaloa', NULL, 0.159939, 25.825701, -108.214302, 0, 0, 0, 0, 110),
(1894, 26, 'Aconchi', 'Aconchi', NULL, 0.00495049, 29.8228856, -110.2257014, 29.8159232, -110.2325034, 29.829848, -110.2188993, 0),
(1895, 26, 'Agua Prieta', 'Agua Prieta', NULL, 0.0338918, 31.3221203, -109.5413631, 31.2946275, -109.5761944, 31.3341495, -109.5105865, 0),
(1896, 26, 'Alamos', 'Alamos', NULL, 0.0361767, 27.0275, -108.94, 27.0073158, -108.9607366, 27.0441518, -108.9199689, 30),
(1897, 26, 'Altar', 'Altar', NULL, 0.0178979, 30.7166667, -111.8333333, 30.701091, -111.8549113, 30.7269988, -111.8159279, 29),
(1909, 26, 'Benito JuÃ¡rez', 'Benito Juarez', NULL, 0.0327494, 22.2135544, -97.8334663, 22.2118583, -97.8342917, 22.2157673, -97.8318494, 0),
(1910, 26, 'BenjamÃn Hill', 'Benjamin Hill', NULL, 0.00190404, 30.171678, -111.110581, 30.1557258, -111.1285043, 30.1798614, -111.0955869, 0),
(1911, 26, 'Caborca', 'Caborca', NULL, 0.0350343, 30.7150077, -112.1573009, 30.6860827, -112.1858131, 30.7386597, -112.1288464, 23),
(1913, 26, 'Cananea', 'Cananea', NULL, 0.0270373, 30.9833333, -110.3013889, 30.9642052, -110.3180625, 31.0100476, -110.2498678, 38),
(1914, 26, 'CarbÃ³', 'Carbo', NULL, 0.0182788, 29.6868582, -110.951829, 29.6696337, -110.9780502, 29.7040828, -110.9256077, 0),
(1918, 26, 'Empalme', 'Empalme', NULL, 0.0346535, 27.9640614, -110.8086114, 27.9440049, -110.8297889, 27.9802475, -110.7622609, 0),
(1919, 26, 'Etchojoa', 'Etchojoa', NULL, 0.0300838, 26.9114634, -109.6271746, 26.9032992, -109.6353216, 26.9183264, -109.6179351, 0),
(1920, 26, 'Fronteras', 'Fronteras', NULL, 0.0140899, 30.7809532, -109.5797899, 0, 0, 0, 0, 24),
(1921, 26, 'General Plutarco ElÃas Calles', 'General Plutarco Elias Calles', NULL, 0.0300838, 27.4938111, -109.9203494, 27.4844677, -109.9204965, 27.5023794, -109.920058, 0),
(1922, 26, 'Granados', 'Granados', NULL, 0.0156131, 29.8613677, -109.3104516, 0, 0, 0, 0, 30),
(1923, 26, 'Guaymas', 'Guaymas', NULL, 0.0365575, 27.9139609, -110.9020749, 27.8708401, -110.9577246, 27.9585812, -110.8526565, 70),
(1924, 26, 'Hermosillo', 'Hermosillo', NULL, 0.0841584, 29.0891857, -110.9613299, 28.9918781, -111.0733537, 29.1650741, -110.8853876, 214),
(1925, 26, 'Heroica Nogales', 'Heroica Nogales', NULL, 0.0285605, 31.3085642, -110.9434486, 31.2489484, -110.980992, 31.3328981, -110.9097212, 0),
(1928, 26, 'Huatabampo', 'Huatabampo', NULL, 0.029703, 26.8271492, -109.6418609, 26.8097352, -109.6625753, 26.8481115, -109.6192792, 21),
(1930, 26, 'Imuris', 'Imuris', NULL, 0, 30.783123, -110.85375, 30.7746892, -110.8638939, 30.8018996, -110.8259451, 0),
(1932, 26, 'Magdalena', 'Magdalena', NULL, 0.0258949, 30.6268599, -110.9625021, 30.610347, -110.9962778, 30.6451982, -110.9465293, 42),
(1934, 26, 'Moctezuma', 'Moctezuma', NULL, 0.00990099, 29.8034924, -109.6803106, 0, 0, 0, 0, 25),
(1935, 26, 'Naco', 'Naco', NULL, 0.0338918, 31.3353801, -109.9481297, 31.333518, -109.964146, 31.350851, -109.89388, 0),
(1937, 26, 'Nacozari de GarcÃa', 'Nacozari de Garcia', NULL, 0.00418888, 30.3753424, -109.6875376, 30.3643755, -109.7042554, 30.3834914, -109.6729028, 0),
(1938, 26, 'Navojoa', 'Navojoa', NULL, 0.0365575, 27.0715397, -109.4442284, 27.0295259, -109.5022657, 27.1062332, -109.4041143, 54),
(1939, 26, 'Onavas', 'Onavas', NULL, 0.0300838, 29.0808456, -110.9400477, 29.0794512, -110.9404087, 29.0823108, -110.9396147, 0),
(1943, 26, 'Puerto PeÃ±asco', 'Puerto Peñasco', NULL, 0.00723534, 0, 0, 0, 0, 0, 0, 21),
(1946, 26, 'Rosario', 'Rosario', NULL, 0.00685453, 27.8439632, -109.3710009, 0, 0, 0, 0, 16),
(1949, 26, 'San Ignacio RÃo Muerto', 'San Ignacio Rio Muerto', NULL, 0.000761615, 27.4122503, -110.2445002, 27.4026204, -110.2504592, 27.4287856, -110.2372362, 0),
(1951, 26, 'San Luis RÃo Colorado', 'San Luis Rio Colorado', NULL, 0.0388423, 32.4518879, -114.7716836, 32.4032533, -114.827989, 32.4935036, -114.6893926, 378),
(1954, 26, 'Santa Ana', 'Santa Ana', NULL, 0.0293222, 30.5398369, -111.1196424, 30.5232536, -111.138901, 30.5535595, -111.1057472, 29),
(1955, 26, 'Santa Cruz', 'Santa Cruz', NULL, 0.0289414, 31.5986127, -110.8076084, 31.332177, -111.36689, 31.731819, -110.45172, 0),
(1962, 26, 'Ures', 'Ures', NULL, 0.0175171, 29.4274354, -110.3867314, 29.4195814, -110.3975954, 29.4316282, -110.3719806, 0),
(1966, 27, 'BalancÃ¡n', 'Balancan', NULL, 0.0140899, 17.8047222, -91.5358333, 17.78585, -91.5473557, 17.8306176, -91.521821, 0),
(1967, 27, 'CÃ¡rdenas', 'Cardenas', NULL, 0.0399848, 18.001342, -93.371284, 17.9622789, -93.4052314, 18.0236781, -93.3432116, 52),
(1968, 27, 'Centla', 'Centla', NULL, 0.0346535, 18.0305442, -92.8984926, 18.0295839, -92.8994559, 18.0313959, -92.8975614, 32),
(1969, 27, 'Centro', 'Centro', NULL, 0.0586443, 21.8647868, -102.916213, 21.858302, -102.9198539, 21.8757806, -102.903028, 239),
(1970, 27, 'Comalcalco', 'Comalcalco', NULL, 0.043412, 18.261156, -93.2216864, 18.2391331, -93.2450156, 18.2924677, -93.1994494, 55),
(1971, 27, 'CunduacÃ¡n', 'Cunduacan', NULL, 0.0213252, 18.0721544, -93.1712486, 18.0533563, -93.1893792, 18.0942904, -93.1580399, 42),
(1972, 27, 'Emiliano Zapata', 'Emiliano Zapata', NULL, 0.0327494, 17.7422124, -91.7638526, 17.728508, -91.7876506, 17.7485904, -91.7498815, 0),
(1973, 27, 'Huimanguillo', 'Huimanguillo', NULL, 0.0140899, 17.8302778, -93.3913889, 17.8084033, -93.4027234, 17.8471327, -93.3775652, 0),
(1974, 27, 'Jalapa', 'Jalapa', NULL, 0.0209444, 17.7192799, -92.8111934, 0, 0, 0, 0, 28),
(1975, 27, 'Jalpa de MÃ©ndez', 'Jalpa de Mendez', NULL, 0.0308454, 18.1760279, -93.0623866, 18.1593757, -93.089113, 18.1870282, -93.0470812, 0),
(1976, 27, 'Jonuta', 'Jonuta', NULL, 0.00875857, 18.0902778, -92.1366667, 18.0857086, -92.146456, 18.1070792, -92.1221764, 24),
(1977, 27, 'Macuspana', 'Macuspana', NULL, 0.0361767, 17.7607017, -92.5936096, 17.7398999, -92.6097677, 17.7786451, -92.576411, 41),
(1978, 27, 'Nacajuca', 'Nacajuca', NULL, 0.0350343, 18.1678434, -93.0178221, 18.1559504, -93.0286799, 18.1820173, -93.0011513, 0),
(1979, 27, 'ParaÃso', 'Paraiso', NULL, 0.0563595, 18.4006144, -93.2127162, 18.3830577, -93.2265612, 18.4161786, -93.1915797, 71),
(1980, 27, 'Tacotalpa', 'Tacotalpa', NULL, 0.00875857, 17.593285, -92.825979, 17.5864914, -92.833239, 17.6014024, -92.8196744, 14),
(1981, 27, 'Teapa', 'Teapa', NULL, 0.0312262, 17.55054, -92.953326, 17.5410442, -92.9707101, 17.5749724, -92.9344508, 0),
(1983, 28, 'Abasolo', 'Abasolo', NULL, 0.00495049, 24.0558662, -98.3733439, 24.0447573, -98.4001289, 24.0688635, -98.3554632, 0),
(1984, 28, 'Aldama', 'Aldama', NULL, 0.0137091, 22.9206619, -98.0729846, 22.8985387, -98.0909671, 22.9377951, -98.0627356, 0),
(1985, 28, 'Altamira', 'Altamira', NULL, 0.0548363, 22.4019807, -97.936707, 22.3835822, -97.9589246, 22.4323854, -97.8789482, 61),
(1989, 28, 'Camargo', 'Camargo', NULL, 0.0399848, 27.4788718, -99.5047008, 27.4627003, -99.5056683, 27.4960563, -99.5038015, 0),
(1990, 28, 'Casas', 'Casas', NULL, 0.021706, 23.7277847, -98.7401866, 0, 0, 0, 0, 56),
(1991, 28, 'Ciudad Madero', 'Ciudad Madero', NULL, 0.00342727, 22.2755598, -97.8395151, 22.2301372, -97.8594465, 22.3295587, -97.7841109, 0),
(1996, 28, 'GonzÃ¡lez', 'Gonzalez', NULL, 0.0175171, 22.8283333, -98.4294444, 22.8113083, -98.4446221, 22.8406591, -98.4122694, 18),
(1997, 28, 'Guerrero', 'Guerrero', NULL, 0.0114242, 26.763741, -99.455914, 0, 0, 0, 0, 31),
(1998, 28, 'Gustavo DÃaz Ordaz', 'Gustavo Diaz Ordaz', NULL, 0.00418888, 26.222696, -98.5896062, 26.2036525, -98.6234271, 26.2467998, -98.573265, 0),
(1999, 28, 'Hidalgo', 'Hidalgo', NULL, 0.0354151, 26.4656319, -98.2212979, 26.0363379, -98.586737, 26.783081, -97.8616749, 40),
(2001, 28, 'JimÃ©nez', 'Jimenez', NULL, 0.0376999, 22.2695019, -97.8285388, 22.2615781, -97.834279, 22.2769517, -97.8208293, 23),
(2002, 28, 'Llera', 'Llera', NULL, 0.0220868, 24.8347002, -98.1334665, 24.8344739, -98.1386366, 24.834865, -98.1259245, 0),
(2004, 28, 'Matamoros', 'Matamoros', NULL, 0.0247525, 25.86117, -97.50219, 25.7716587, -97.6114709, 25.9164041, -97.4252932, 26),
(2005, 28, 'MÃ©ndez', 'Mendez', NULL, 0.0129474, 25.1185964, -98.5877094, 0, 0, 0, 0, 22),
(2006, 28, 'Mier', 'Mier', NULL, 0.0285605, 26.430077, -99.146891, 26.4143711, -99.1661394, 26.451865, -99.1407387, 28),
(2007, 28, 'Miguel AlemÃ¡n', 'Miguel Aleman', NULL, 0.00495049, 26.0926824, -98.2720298, 26.0914096, -98.2731285, 26.094417, -98.2709891, 0),
(2009, 28, 'Nuevo Laredo', 'Nuevo Laredo', NULL, 0.0517898, 27.4800237, -99.5105349, 27.3572653, -99.6137462, 27.5461368, -99.4787645, 22),
(2011, 28, 'Ocampo', 'Ocampo', NULL, 0.00571211, 22.8452259, -99.3361544, 22.8302442, -99.3501788, 22.8543921, -99.324273, 0),
(2012, 28, 'Padilla', 'Padilla', NULL, 0.0114242, 24.0062281, -98.7745825, 0, 0, 0, 0, 52),
(2013, 28, 'Palmillas', 'Palmillas', NULL, 0.00380807, 23.3033449, -99.5572101, 0, 0, 0, 0, 25),
(2014, 28, 'Reynosa', 'Reynosa', NULL, 0.0544554, 26.0712222, -98.2973651, 25.9947586, -98.4009005, 26.1227282, -98.1728245, 0),
(2015, 28, 'RÃo Bravo', 'Rio Bravo', NULL, 0.0403656, 27.3641887, -99.4800415, 27.362727, -99.50415, 27.366975, -99.4599569, 0),
(2016, 28, 'San Carlos', 'San Carlos', NULL, 0.0175171, 24.5821302, -98.9418396, 0, 0, 0, 0, 42),
(2017, 28, 'San Fernando', 'San Fernando', NULL, 0.0201828, 24.8495842, -98.1465444, 24.8245402, -98.1788948, 24.8646266, -98.1156137, 0),
(2018, 28, 'San NicolÃ¡s', 'San Nicolas', NULL, 0.0114242, 24.6926254, -98.8291124, 0, 0, 0, 0, 36),
(2019, 28, 'Soto la Marina', 'Soto la Marina', NULL, 0.00418888, 23.7697282, -98.2054911, 23.7541814, -98.2168341, 23.7816597, -98.1973875, 0),
(2020, 28, 'Tampico', 'Tampico', NULL, 0.0567403, 22.2552778, -97.8686111, 22.2065357, -97.9856003, 22.3330468, -97.8363749, 116),
(2021, 28, 'Tula', 'Tula', NULL, 0.0194212, 23.0000612, -99.7145161, 22.9928347, -99.7161229, 23.0085129, -99.7003789, 0),
(2022, 28, 'Valle Hermoso', 'Valle Hermoso', NULL, 0.029703, 25.6700867, -97.8133684, 25.6326789, -97.8584382, 25.6960787, -97.7665132, 0),
(2023, 28, 'Victoria', 'Victoria', NULL, 0.0491241, 23.7369164, -99.1411154, 23.6983819, -99.1877014, 23.7733549, -99.1007309, 61),
(2025, 28, 'XicotÃ©ncatl', 'Xicotencatl', NULL, 0.0102818, 22.9958333, -98.9447222, 22.9804657, -98.958347, 23.0066943, -98.9260801, 0),
(2026, 29, 'Acuamanala de Miguel Hidalgo', 'Acuamanala de Miguel Hidalgo', NULL, 0.0388423, 19.1923454, -98.2393016, 19.1917044, -98.2403819, 19.1929863, -98.2382214, 0),
(2028, 29, 'Amaxac de Guerrero', 'Amaxac de Guerrero', NULL, 0.00418888, 19.3488152, -98.1680579, 19.3384418, -98.1848576, 19.3739879, -98.1493235, 0),
(2029, 29, 'ApetatitlÃ¡n de Antonio Carvajal', 'Apetatitlan de Antonio Carvajal', NULL, 0.0365575, 19.2964603, -98.2299686, 19.2962681, -98.2308225, 19.2966078, -98.2289049, 0),
(2030, 29, 'Apizaco', 'Apizaco', NULL, 0.0319878, 19.4147184, -98.1422576, 19.3848137, -98.1577039, 19.4331296, -98.1215647, 90),
(2033, 29, 'Calpulalpan', 'Calpulalpan', NULL, 0.0255141, 19.5833333, -98.5666667, 19.5644994, -98.5896054, 19.6004343, -98.5372604, 47),
(2034, 29, 'Chiautempan', 'Chiautempan', NULL, 0.0411272, 19.3137127, -98.1941301, 19.2923583, -98.2186541, 19.3291642, -98.1600793, 0),
(2035, 29, 'Contla de Juan Cuamatzi', 'Contla de Juan Cuamatzi', NULL, 0.0380807, 19.3339128, -98.1812698, 19.3331462, -98.1916473, 19.3356308, -98.170265, 0),
(2036, 29, 'Cuapiaxtla', 'Cuapiaxtla', NULL, 0.00418888, 19.297559, -97.769351, 19.2840221, -97.787261, 19.3082473, -97.7525807, 0),
(2037, 29, 'Cuaxomulco', 'Cuaxomulco', NULL, 0.0350343, 19.35, -98.1, 19.3405279, -98.1226784, 19.3669991, -98.0809445, 0),
(2038, 29, 'El Carmen Tequexquitla', 'El Carmen Tequexquitla', NULL, 0.00342727, 19.3230993, -97.6389242, 19.319906, -97.6406711, 19.3258231, -97.6374341, 0),
(2040, 29, 'EspaÃ±ita', 'Españita', NULL, 0.0357959, 24.0109674, -104.6283058, 24.0101054, -104.6333712, 24.0121316, -104.6232349, 0),
(2041, 29, 'Huamantla', 'Huamantla', NULL, 0.041508, 19.31269, -97.923862, 19.290087, -97.9641937, 19.3492261, -97.8899854, 67),
(2043, 29, 'Ixtacuixtla de Mariano Matamoros', 'Ixtacuixtla de Mariano Matamoros', NULL, 0.00304646, 19.3376931, -98.3663526, 19.3233408, -98.3712809, 19.348434, -98.3570793, 0),
(2044, 29, 'Ixtenco', 'Ixtenco', NULL, 0.0399848, 19.2500847, -97.8938829, 19.2379886, -97.9084717, 19.2657669, -97.8811746, 0),
(2045, 29, 'La Magdalena Tlaltelulco', 'La Magdalena Tlaltelulco', NULL, 0.0236101, 19.2780524, -98.1862331, 19.2577196, -98.2133253, 19.3039934, -98.1609489, 0),
(2046, 29, 'LÃ¡zaro CÃ¡rdenas', 'Lazaro Cardenas', NULL, 0.0129474, 19.5385014, -97.9841676, 0, 0, 0, 0, 66),
(2048, 29, 'MuÃ±oz de Domingo Arenas', 'Muñoz de Domingo Arenas', NULL, 0.0255141, 19.290599, -98.2805509, 19.2865354, -98.2857098, 19.2947529, -98.2748273, 0),
(2049, 29, 'Nanacamilpa de Mariano Arista', 'Nanacamilpa de Mariano Arista', NULL, 0.0350343, 19.3122222, -98.2394444, 19.2613148, -98.2944518, 19.3521727, -98.1939906, 0),
(2050, 29, 'NatÃvitas', 'Nativitas', NULL, 0.00571211, 19.2312727, -98.3178956, 19.2092929, -98.345845, 19.2400616, -98.3049148, 0),
(2051, 29, 'Panotla', 'Panotla', NULL, 0.0369383, 19.316944, -98.26856, 19.2932823, -98.2880412, 19.3300358, -98.2556042, 0),
(2052, 29, 'Papalotla de XicohtÃ©ncatl', 'Papalotla de Xicohtencatl', NULL, 0.0338918, 19.1728385, -98.1963618, 19.1718348, -98.1969306, 19.1738942, -98.1954141, 0),
(2053, 29, 'San DamiÃ¡n Texoloc', 'San Damian Texoloc', NULL, 0.00304646, 19.2779222, -98.2860606, 19.2662679, -98.2969513, 19.2862653, -98.2734736, 0),
(2054, 29, 'San Francisco Tetlanohcan', 'San Francisco Tetlanohcan', NULL, 0.0376999, 19.2586652, -98.1631999, 19.2520635, -98.1887911, 19.2739193, -98.1452732, 0),
(2057, 29, 'San Juan Huactzinco', 'San Juan Huactzinco', NULL, 0.0380807, 19.2320402, -98.2526081, 19.2245665, -98.2695936, 19.2533738, -98.240458, 0),
(2058, 29, 'San Lorenzo Axocomanitla', 'San Lorenzo Axocomanitla', NULL, 0.0376999, 19.2243413, -98.2490377, 19.2165399, -98.2603842, 19.2312063, -98.2418757, 0),
(2060, 29, 'San Pablo del Monte', 'San Pablo del Monte', NULL, 0.0388423, 19.1010212, -98.1827115, 19.0972498, -98.183693, 19.1053571, -98.1812789, 0),
(2061, 29, 'SanctÃ³rum de LÃ¡zaro CÃ¡rdenas', 'Sanctorum de Lazaro Cardenas', NULL, 0.00228484, 19.0916996, -98.245226, 19.0881726, -98.2488047, 19.0944747, -98.2424908, 0),
(2062, 29, 'Santa Ana Nopalucan', 'Santa Ana Nopalucan', NULL, 0.0388423, 19.3013007, -98.3353284, 19.2858471, -98.3564573, 19.3139597, -98.3207588, 0),
(2064, 29, 'Santa Catarina Ayometla', 'Santa Catarina Ayometla', NULL, 0.00342727, 19.1964279, -98.2177009, 19.1744517, -98.2318795, 19.2118724, -98.1954376, 0),
(2065, 29, 'Santa Cruz Quilehtla', 'Santa Cruz Quilehtla', NULL, 0.0373191, 19.2130017, -98.2217044, 19.2061791, -98.2324739, 19.22119, -98.2047187, 0),
(2066, 29, 'Santa Cruz Tlaxcala', 'Santa Cruz Tlaxcala', NULL, 0.0236101, 19.3539314, -98.1514914, 0, 0, 0, 0, 38),
(2067, 29, 'Santa Isabel Xiloxoxtla', 'Santa Isabel Xiloxoxtla', NULL, 0.00304646, 19.2668764, -98.2138546, 19.2465454, -98.2211547, 19.2789898, -98.187947, 0),
(2068, 29, 'Tenancingo', 'Tenancingo', NULL, 0.0354151, 19.146021, -98.200965, 19.1326298, -98.2242858, 19.1591006, -98.1864069, 0),
(2069, 29, 'Teolocholco', 'Teolocholco', NULL, 0, 19.2420642, -98.1904179, 19.227229, -98.2149581, 19.2582297, -98.1505786, 0),
(2070, 29, 'Tepetitla de LardizÃ¡bal', 'Tepetitla de Lardizabal', NULL, 0, 19.2663845, -98.3773116, 19.249852, -98.390168, 19.2784755, -98.3577917, 0),
(2071, 29, 'Tepeyanco', 'Tepeyanco', NULL, 0.0327494, 19.244846, -98.234322, 19.2351773, -98.2447982, 19.2561864, -98.2225906, 0),
(2073, 29, 'Tetla de la Solidaridad', 'Tetla de la Solidaridad', NULL, 0.0331302, 19.4339372, -98.0994865, 19.4330048, -98.1008125, 19.4348407, -98.0988697, 0),
(2074, 29, 'Tetlatlahuca', 'Tetlatlahuca', NULL, 0.00190404, 19.2342262, -98.2971251, 19.2243927, -98.3023652, 19.2592304, -98.2727352, 0),
(2075, 29, 'Tlaxcala', 'Tlaxcala', NULL, 0.140137, 19.3122222, -98.2394444, 19.2613148, -98.2944518, 19.3521727, -98.1939906, 436),
(2076, 29, 'Tlaxco', 'Tlaxco', NULL, 0.0159939, 19.6167, -98.1167, 19.5950922, -98.1375181, 19.6473135, -98.1003876, 0),
(2077, 29, 'TocatlÃ¡n', 'Tocatlan', NULL, 0, 19.3884422, -98.0302174, 19.3754987, -98.0422373, 19.4025383, -98.0083463, 0),
(2078, 29, 'Totolac', 'Totolac', NULL, 0.0354151, 19.3241724, -98.2578748, 19.3193654, -98.2679111, 19.3332053, -98.2445354, 34),
(2079, 29, 'Tzompantepec', 'Tzompantepec', NULL, 0, 19.3765844, -98.0923404, 19.3599792, -98.1005959, 19.3836463, -98.0807245, 0),
(2080, 29, 'Xaloztoc', 'Xaloztoc', NULL, 0.0220868, 19.4021122, -98.0482721, 19.3758958, -98.0835855, 19.4365591, -98.0263088, 0),
(2082, 29, 'Xicohtzinco', 'Xicohtzinco', NULL, 0.0236101, 19.1666667, -98.2333333, 19.1576059, -98.2622384, 19.1870232, -98.2188661, 0),
(2083, 29, 'Yauhquemecan', 'Yauhquemecan', NULL, 0.0270373, 19.4139157, -98.1830291, 19.3858494, -98.1930049, 19.4330917, -98.1632059, 0),
(2084, 29, 'Zacatelco', 'Zacatelco', NULL, 0.0376999, 19.2093342, -98.2410244, 19.1740092, -98.2638417, 19.2327137, -98.230237, 42),
(2085, 29, 'Zitlaltepec de Trinidad SÃ¡nchez', 'Zitlaltepec de Trinidad Sanchez', NULL, 0, 19.2696307, -98.2359944, 19.2694659, -98.2360696, 19.2696307, -98.2359944, 0),
(2086, 30, 'Acajete', 'Acajete', NULL, 0.0300838, 19.586757, -97.009169, 19.5839505, -97.0136762, 19.591491, -97.0051682, 0),
(2088, 30, 'Acayucan', 'Acayucan', NULL, 0.0346535, 17.9486907, -94.9149486, 17.9319304, -94.9358457, 17.970182, -94.8905273, 77),
(2089, 30, 'Actopan', 'Actopan', NULL, 0.00761615, 19.5040009, -96.6093921, 0, 0, 0, 0, 26),
(2091, 30, 'Acultzingo', 'Acultzingo', NULL, 0.000380807, 18.7153272, -97.3093286, 18.7025195, -97.3303791, 18.7343897, -97.2755602, 0),
(2092, 30, 'Agua Dulce', 'Agua Dulce', NULL, 0.0357959, 18.1423129, -94.1438174, 18.1088123, -94.1669302, 18.1774761, -94.1195172, 82),
(2093, 30, 'AlpatlÃ¡huac', 'Alpatlahuac', NULL, 0.0293222, 18.8118447, -96.7228574, 18.8049904, -96.7414686, 18.8242706, -96.7111363, 0),
(2094, 30, 'Alto Lucero de GutiÃ©rrez Barrios', 'Alto Lucero de Gutierrez Barrios', NULL, 0.029703, 20.9510507, -97.4365755, 20.9510497, -97.4371445, 20.9511106, -97.4360721, 0),
(2095, 30, 'Altotonga', 'Altotonga', NULL, 0.000380807, 19.7658664, -97.2422429, 19.7429641, -97.2624446, 19.7819163, -97.2369038, 0),
(2096, 30, 'Alvarado', 'Alvarado', NULL, 0.0365575, 18.77405, -95.760017, 18.7650681, -95.7770271, 18.7870234, -95.7519611, 0),
(2098, 30, 'AmatlÃ¡n de los Reyes', 'Amatlan de los Reyes', NULL, 0, 18.844732, -96.915769, 18.8346727, -96.9256898, 18.8646852, -96.9062613, 0),
(2099, 30, 'Angel R. Cabada', 'Angel R. Cabada', NULL, 0.00495049, 18.5966602, -95.4452049, 18.5844167, -95.4679921, 18.6039679, -95.4271481, 0),
(2105, 30, 'Atzacan', 'Atzacan', NULL, 0.00114242, 18.9054374, -97.0825826, 18.8925489, -97.0961481, 18.9188773, -97.0750967, 0),
(2108, 30, 'Banderilla', 'Banderilla', NULL, 0, 19.5907529, -96.9437149, 19.5755148, -96.9716143, 19.601722, -96.9244066, 0),
(2109, 30, 'Benito JuÃ¡rez', 'Benito Juarez', NULL, 0.00380807, 20.8853944, -98.2052774, 0, 0, 0, 0, 27),
(2110, 30, 'Boca del RÃo', 'Boca del Rio', NULL, 0.0521706, 19.1400064, -96.1155932, 19.1104553, -96.1411096, 19.1716953, -96.0930269, 94),
(2112, 30, 'CamarÃ³n de Tejeda', 'Camaron de Tejeda', NULL, 0.0373191, 19.1727167, -96.1332689, 19.1309431, -96.206622, 19.2266685, -96.1180802, 0),
(2113, 30, 'Camerino Z. Mendoza', 'Camerino Z. Mendoza', NULL, 0.0365575, 18.8489199, -97.075379, 18.8487678, -97.0805967, 18.8498109, -97.0691905, 0),
(2114, 30, 'Carlos A. Carrillo', 'Carlos A. Carrillo', NULL, 0.0380807, 18.3734759, -95.7433656, 18.3606509, -95.7742842, 18.3839541, -95.7181627, 0),
(2117, 30, 'Catemaco', 'Catemaco', NULL, 0.0384615, 18.4217237, -95.1112161, 18.4142852, -95.1281943, 18.4363722, -95.0979183, 36),
(2119, 30, 'Cerro Azul', 'Cerro Azul', NULL, 0.0232292, 21.1879652, -97.7419439, 21.1655131, -97.761156, 21.2085293, -97.7242513, 0),
(2121, 30, 'Chalma', 'Chalma', NULL, 0.0255141, 21.2074569, -98.3977699, 0, 0, 0, 0, 30),
(2125, 30, 'Chinameca', 'Chinameca', NULL, 0.0338918, 18.0207847, -94.6712464, 18.0009766, -94.6975419, 18.0347695, -94.6687046, 0),
(2127, 30, 'ChocamÃ¡n', 'Chocaman', NULL, 0.0190404, 19.011477, -97.029049, 18.9969153, -97.0444405, 19.0289711, -97.0151531, 0),
(2132, 30, 'CoahuitlÃ¡n', 'Coahuitlan', NULL, 0, 20.2071991, -97.6995223, 20.2064033, -97.7014717, 20.207814, -97.6979232, 0),
(2133, 30, 'Coatepec', 'Coatepec', NULL, 0.0388423, 19.4535812, -96.9587734, 19.4373771, -96.9830947, 19.4728193, -96.9365685, 40),
(2134, 30, 'Coatzacoalcos', 'Coatzacoalcos', NULL, 0.0502666, 18.1377778, -94.4352778, 18.1024412, -94.5133526, 18.1649192, -94.4104837, 103),
(2135, 30, 'Coatzintla', 'Coatzintla', NULL, 0.0293222, 20.4864642, -97.4666919, 20.4698069, -97.480119, 20.5013611, -97.439279, 0),
(2139, 30, 'CÃ³rdoba', 'Cordoba', NULL, 0.0483625, 18.8941667, -96.9347222, 18.8601269, -96.9834488, 18.918483, -96.896752, 168),
(2140, 30, 'Cosamaloapan de Carpio', 'Cosamaloapan de Carpio', NULL, 0.033511, 18.3667399, -95.7973189, 18.3587512, -95.8078074, 18.3765589, -95.7819276, 5),
(2142, 30, 'Coscomatepec', 'Coscomatepec', NULL, 0.00495049, 19.06946, -97.048866, 19.0560784, -97.0609822, 19.0838563, -97.0330998, 0),
(2143, 30, 'Cosoleacaque', 'Cosoleacaque', NULL, 0.0255141, 17.9952778, -94.6369444, 17.9863237, -94.6526309, 18.0113127, -94.6220349, 40),
(2146, 30, 'Coyutla', 'Coyutla', NULL, 0, 20.2455937, -97.6560906, 20.2395117, -97.6698916, 20.2546957, -97.6457912, 0),
(2147, 30, 'Cuichapa', 'Cuichapa', NULL, 0, 17.9356458, -94.2805373, 17.9258765, -94.2909119, 17.9536141, -94.2688856, 0),
(2148, 30, 'CuitlÃ¡huac', 'Cuitlahuac', NULL, 0.031607, 18.8118447, -96.7228574, 18.8049904, -96.7414686, 18.8242706, -96.7111363, 0),
(2149, 30, 'El Higo', 'El Higo', NULL, 0.00342727, 21.7666667, -98.45, 21.7527558, -98.4624092, 21.7828232, -98.4421632, 0),
(2152, 30, 'Filomeno Mata', 'Filomeno Mata', NULL, 0.000380807, 20.1978107, -97.7025012, 20.1922291, -97.7091342, 20.207814, -97.6979492, 0),
(2153, 30, 'FortÃn', 'Fortin', NULL, 0.043412, 18.9, -97, 18.8876047, -97.0210913, 18.9280098, -96.9822317, 0),
(2154, 30, 'GutiÃ©rrez Zamora', 'Gutierrez Zamora', NULL, 0.0232292, 20.4526427, -97.0864591, 20.4365087, -97.0969928, 20.4703004, -97.0799041, 0),
(2162, 30, 'Isla', 'Isla', NULL, 0.0236101, 18.0333333, -95.5333333, 18.0138559, -95.5400755, 18.044914, -95.5127315, 135),
(2166, 30, 'IxhuatlÃ¡n del CafÃ©', 'Ixhuatlan del Cafe', NULL, 0.0274181, 19.0506484, -96.9840844, 19.0404583, -96.9940138, 19.0577606, -96.9703442, 0),
(2167, 30, 'IxhuatlÃ¡n del Sureste', 'Ixhuatlan del Sureste', NULL, 0.00266565, 18.0250937, -94.3899227, 18.0119632, -94.4032188, 18.032919, -94.3783203, 0),
(2170, 30, 'IxtaczoquitlÃ¡n', 'Ixtaczoquitlan', NULL, 0.0327494, 18.8520797, -97.0616876, 18.8392057, -97.0739944, 18.8862283, -97.0361291, 0),
(2171, 30, 'Jalacingo', 'Jalacingo', NULL, 0.0346535, 19.8049509, -97.3076199, 19.7894538, -97.316631, 19.8284287, -97.290822, 0),
(2172, 30, 'Jalcomulco', 'Jalcomulco', NULL, 0.0236101, 19.3323837, -96.7617569, 0, 0, 0, 0, 29),
(2177, 30, 'JosÃ© Azueta', 'Jose Azueta', NULL, 0.0323686, 19.1887681, -96.1300314, 19.1872109, -96.1369192, 19.1926379, -96.1241778, 0),
(2178, 30, 'Juan RodrÃguez Clara', 'Juan Rodriguez Clara', NULL, 0.00114242, 17.9919444, -95.4033333, 17.9783891, -95.4132009, 18.0097825, -95.3889652, 0),
(2180, 30, 'La Antigua', 'La Antigua', NULL, 0.0502666, 19.2058331, -96.1678578, 19.205576, -96.1678578, 19.2058331, -96.1678001, 41),
(2181, 30, 'La Perla', 'La Perla', NULL, 0.0449353, 18.9283614, -97.1328424, 0, 0, 0, 0, 30),
(2183, 30, 'Las Choapas', 'Las Choapas', NULL, 0.0167555, 17.90966, -94.093086, 17.8577566, -94.1186152, 17.9453748, -94.0794544, 23),
(2185, 30, 'Las Vigas de RamÃrez', 'Las Vigas de Ramirez', NULL, 0.0140899, 19.639723, -97.1063305, 19.6243708, -97.1347573, 19.6544793, -97.0858541, 0),
(2186, 30, 'Lerdo de Tejada', 'Lerdo de Tejada', NULL, 0.00228484, 18.6260484, -95.514493, 18.606209, -95.534138, 18.6417643, -95.4949556, 0),
(2187, 30, 'Los Reyes', 'Los Reyes', NULL, 0.0125666, 18.6710069, -97.0429161, 0, 0, 0, 0, 45),
(2188, 30, 'Magdalena', 'Magdalena', NULL, 0.0251333, 18.7579049, -97.0477301, 0, 0, 0, 0, 28),
(2189, 30, 'Maltrata', 'Maltrata', NULL, 0.00342727, 18.8091007, -97.2729974, 18.7987067, -97.2945906, 18.8245521, -97.2581204, 0),
(2192, 30, 'MartÃnez de la Torre', 'Martinez de la Torre', NULL, 0.0289414, 20.0617775, -97.0519584, 20.0461722, -97.095215, 20.0908688, -97.0150985, 0),
(2195, 30, 'MedellÃn', 'Medellin', NULL, 0.0498858, 19.2087759, -96.156184, 19.2081428, -96.1570889, 19.2087759, -96.156184, 0),
(2197, 30, 'MinatitlÃ¡n', 'Minatitlan', NULL, 0.041508, 17.9888889, -94.5586111, 17.9700695, -94.5914284, 18.0347587, -94.5095536, 84),
(2198, 30, 'Misantla', 'Misantla', NULL, 0.011805, 19.9321559, -96.8508841, 19.9111993, -96.871646, 19.953306, -96.8380418, 0),
(2201, 30, 'Nanchital de LÃ¡zaro CÃ¡rdenas del R', 'Nanchital de Lazaro Cardenas del', NULL, 0.0342727, 18.0652743, -94.411136, 18.0629616, -94.4137901, 18.0683353, -94.4070571, 0),
(2204, 30, 'Naranjos AmatlÃ¡n', 'Naranjos Amatlan', NULL, 0.0148515, 21.3574717, -97.6858615, 21.3555578, -97.686524, 21.3596103, -97.6851104, 0),
(2206, 30, 'Nogales', 'Nogales', NULL, 0.0453161, 18.8166667, -97.1666667, 18.8063749, -97.1773081, 18.8341323, -97.1522762, 25),
(2207, 30, 'Oluta', 'Oluta', NULL, 0.0331302, 17.9298564, -94.8924514, 17.9195151, -94.9050681, 17.9367232, -94.8825495, 0),
(2209, 30, 'Orizaba', 'Orizaba', NULL, 0.0540746, 18.85, -97.1, 18.8320002, -97.1255442, 18.8861695, -97.0686277, 184),
(2211, 30, 'Oteapan', 'Oteapan', NULL, 0.00152323, 18.0062177, -94.6701351, 17.975579, -94.6895118, 18.0173889, -94.6493047, 0),
(2212, 30, 'Ozuluama de MascareÃ±as', 'Ozuluama de Mascareñas', NULL, 0.0338918, 19.1727167, -96.1332689, 19.1309431, -96.206622, 19.2266685, -96.1180802, 0),
(2213, 30, 'Pajapan', 'Pajapan', NULL, 0, 18.2553119, -94.6894681, 18.2525566, -94.7004945, 18.2726179, -94.6831901, 0),
(2214, 30, 'PÃ¡nuco', 'Panuco', NULL, 0.0300838, 22.05, -98.1833333, 22.0116945, -98.2099904, 22.0773983, -98.1664314, 0),
(2215, 30, 'Papantla', 'Papantla', NULL, 0.0319878, 20.4566709, -97.3156131, 0, 0, 0, 0, 78),
(2216, 30, 'Paso de Ovejas', 'Paso de Ovejas', NULL, 0.0129474, 19.2835389, -96.4405789, 19.2748039, -96.4539296, 19.2940566, -96.4254964, 21),
(2217, 30, 'Paso del Macho', 'Paso del Macho', NULL, 0.00152323, 18.9666667, -96.7166667, 18.9605454, -96.7355171, 18.9816119, -96.7114116, 0),
(2218, 30, 'Perote', 'Perote', NULL, 0.0255141, 19.5610169, -97.2440699, 19.5346812, -97.2701353, 19.5803736, -97.2245728, 0),
(2219, 30, 'PlatÃ³n SÃ¡nchez', 'Platon Sanchez', NULL, 0.00266565, 21.2778909, -98.3737051, 21.2622099, -98.388666, 21.2863267, -98.361856, 0),
(2220, 30, 'Playa Vicente', 'Playa Vicente', NULL, 0.00228484, 17.8242544, -95.8150579, 17.8171954, -95.8233408, 17.8390611, -95.801016, 0),
(2221, 30, 'Poza Rica de Hidalgo', 'Poza Rica de Hidalgo', NULL, 0.0338918, 20.5333333, -97.45, 20.4882195, -97.4881379, 20.5690854, -97.4190008, 0),
(2224, 30, 'Rafael Delgado', 'Rafael Delgado', NULL, 0.00418888, 18.8106854, -97.0721359, 18.8015769, -97.0803836, 18.8255099, -97.061851, 0),
(2226, 30, 'RÃo Blanco', 'Rio Blanco', NULL, 0.0361767, 18.8359564, -97.1397234, 18.8251093, -97.1648629, 18.854912, -97.1100366, 0);
INSERT INTO `ciudad` (`id_ciudad`, `id_estado`, `nombre`, `nombre_coloquial`, `tags`, `popularidad`, `lat`, `lng`, `bsw_lat`, `bsw_lng`, `bne_lat`, `bne_lng`, `vistas`) VALUES
(2228, 30, 'San AndrÃ©s Tenejapan', 'San Andres Tenejapan', NULL, 0.0312262, 18.4505453, -95.2217739, 18.4493455, -95.2236222, 18.4519766, -95.2197334, 0),
(2229, 30, 'San AndrÃ©s Tuxtla', 'San Andres Tuxtla', NULL, 0.0274181, 18.4440354, -95.2132694, 18.4187589, -95.2368516, 18.465177, -95.1889674, 79),
(2231, 30, 'San Rafael', 'San Rafael', NULL, 0.031607, 20.1885902, -96.8674581, 20.1790305, -96.8816124, 20.1993075, -96.8607596, 0),
(2232, 30, 'Santiago Sochiapan', 'Santiago Sochiapan', NULL, 0.0373191, 19.1727167, -96.1332689, 19.1309431, -96.206622, 19.2266685, -96.1180802, 0),
(2233, 30, 'Santiago Tuxtla', 'Santiago Tuxtla', NULL, 0.0327494, 18.4666667, -95.3, 18.4538992, -95.3155903, 18.4774191, -95.2904616, 78),
(2234, 30, 'Sayula de AlemÃ¡n', 'Sayula de Aleman', NULL, 0.00418888, 17.8812332, -94.9607461, 17.869713, -94.9720533, 17.8950426, -94.9488557, 0),
(2238, 30, 'Soledad de Doblado', 'Soledad de Doblado', NULL, 0.000761615, 19.045108, -96.418227, 19.035781, -96.4385538, 19.0568171, -96.4098659, 0),
(2241, 30, 'Tamiahua', 'Tamiahua', NULL, 0.00228484, 21.2780556, -97.4455556, 21.2577674, -97.450576, 21.2932873, -97.4401116, 0),
(2242, 30, 'Tampico Alto', 'Tampico Alto', NULL, 0.0323686, 22.1114627, -97.8011454, 0, 0, 0, 0, 36),
(2245, 30, 'Tantoyuca', 'Tantoyuca', NULL, 0.0137091, 21.348539, -98.229393, 21.3334504, -98.2466936, 21.369086, -98.2086625, 0),
(2246, 30, 'Tatahuicapan de JuÃ¡rez', 'Tatahuicapan de Juarez', NULL, 0, 18.2465705, -94.7588279, 18.2412793, -94.7591614, 18.2508748, -94.7586159, 0),
(2248, 30, 'Tecolutla', 'Tecolutla', NULL, 0.0392232, 20.4795519, -97.0101271, 0, 0, 0, 0, 88),
(2254, 30, 'Teocelo', 'Teocelo', NULL, 0.0331302, 19.3833333, -96.9666667, 19.3773855, -96.9834931, 19.3969624, -96.9615761, 0),
(2257, 30, 'Tepetzintla', 'Tepetzintla', NULL, 0.000380807, 21.1643752, -97.8510171, 21.1554207, -97.8588816, 21.1743354, -97.8458869, 0),
(2258, 30, 'Tequila', 'Tequila', NULL, 0.0399848, 18.7295682, -97.0711071, 0, 0, 0, 0, 62),
(2261, 30, 'Texistepec', 'Texistepec', NULL, 0.000380807, 17.8895974, -94.8127169, 17.8813959, -94.8311597, 17.9130731, -94.7904522, 0),
(2263, 30, 'Tierra Blanca', 'Tierra Blanca', NULL, 0.0323686, 18.447241, -96.356377, 18.4312013, -96.3773374, 18.4679172, -96.3385677, 34),
(2264, 30, 'TihuatlÃ¡n', 'Tihuatlan', NULL, 0.00342727, 20.7218454, -97.5395019, 20.699112, -97.5463383, 20.7291091, -97.5252751, 0),
(2268, 30, 'Tlacotalpan', 'Tlacotalpan', NULL, 0.0239909, 18.6134239, -95.6613511, 0, 0, 0, 0, 27),
(2273, 30, 'Tlapacoyan', 'Tlapacoyan', NULL, 0.0144707, 19.9614692, -97.2125214, 19.9469024, -97.2257125, 19.9785765, -97.1995924, 15),
(2279, 30, 'Tres Valles', 'Tres Valles', NULL, 0.00418888, 18.2347867, -96.1335356, 18.2220326, -96.1529671, 18.2527611, -96.1221422, 0),
(2282, 30, 'Ursulo GalvÃ¡n', 'Ursulo Galvan', NULL, 0.00152323, 19.4037192, -96.3553962, 19.3953343, -96.3729011, 19.4181612, -96.3520571, 0),
(2283, 30, 'Uxpanapa', 'Uxpanapa', NULL, 0.000380807, 42.3823798, 0.610943, 42.3287079, 0.5426979, 42.4237663, 0.6697109, 0),
(2284, 30, 'Vega de Alatorre', 'Vega de Alatorre', NULL, 0.0190404, 20.0286539, -96.6486726, 20.0150716, -96.6646295, 20.0371972, -96.6369904, 0),
(2285, 30, 'Veracruz', 'Veracruz', NULL, 0.289033, 19.1727167, -96.1332689, 19.1309431, -96.206622, 19.2266685, -96.1180802, 189),
(2287, 30, 'Xalapa', 'Xalapa', NULL, 0.0552171, 19.5426237, -96.9137441, 19.4909818, -96.9604434, 19.5800077, -96.8596995, 214),
(2288, 30, 'Xico', 'Xico', NULL, 0.0388423, 19.417, -97, 19.4110261, -97.0230148, 19.4335124, -96.9870657, 0),
(2290, 30, 'Yanga', 'Yanga', NULL, 0.0365575, 18.8302259, -96.7993059, 18.8231307, -96.8100587, 18.8389637, -96.7898051, 0),
(2293, 30, 'Zaragoza', 'Zaragoza', NULL, 0.0304646, 17.9590794, -94.6413699, 17.9421316, -94.6518419, 17.9638005, -94.6301972, 36),
(2294, 30, 'Zentla', 'Zentla', NULL, 0.0220868, 19.1727167, -96.1332689, 19.1309431, -96.206622, 19.2266685, -96.1180802, 0),
(2295, 30, 'Zongolica', 'Zongolica', NULL, 0.00799695, 18.6666667, -97, 18.6566389, -97.0085507, 18.6717763, -96.9934111, 0),
(2299, 31, 'Acanceh', 'Acanceh', NULL, 0.0190404, 20.8124549, -89.4507416, 20.7976236, -89.470011, 20.8252554, -89.4375056, 0),
(2300, 31, 'Akil', 'Akil', NULL, 0.0281797, 20.265087, -89.346821, 20.2475872, -89.3612876, 20.2741612, -89.3361424, 0),
(2301, 31, 'Baca', 'Baca', NULL, 0.0319878, 21.1086429, -89.3974147, 0, 0, 0, 0, 40),
(2303, 31, 'Buctzotz', 'Buctzotz', NULL, 0.000380807, 21.203034, -88.793859, 21.1924005, -88.8116958, 21.2145879, -88.7783994, 0),
(2304, 31, 'CacalchÃ©n', 'Cacalchen', NULL, 0.0137091, 20.983139, -89.227311, 20.9741939, -89.2399285, 20.9956187, -89.2134627, 0),
(2308, 31, 'CelestÃºn', 'Celestun', NULL, 0.0148515, 20.8608333, -90.3925, 20.8455722, -90.4071896, 20.8765142, -90.3884266, 0),
(2309, 31, 'Cenotillo', 'Cenotillo', NULL, 0, 20.9685327, -88.6005971, 20.9586727, -88.6137069, 20.9735777, -88.5944486, 0),
(2313, 31, 'Chemax', 'Chemax', NULL, 0.00228484, 20.6564494, -87.9360261, 20.6477264, -87.9456006, 20.6646457, -87.9285576, 0),
(2319, 31, 'Conkal', 'Conkal', NULL, 0.0312262, 21.0733333, -89.5208333, 21.0559399, -89.5314928, 21.0886753, -89.5011874, 52),
(2324, 31, 'DzidzantÃºn', 'Dzidzantun', NULL, 0.000380807, 21.2472222, -89.0416667, 21.2359439, -89.0542892, 21.2602312, -89.0168348, 0),
(2326, 31, 'Dzilam GonzÃ¡lez', 'Dzilam Gonzalez', NULL, 0.000380807, 21.2817192, -88.9272134, 21.2669481, -88.940299, 21.2922, -88.913888, 0),
(2329, 31, 'Espita', 'Espita', NULL, 0.000761615, 21.0127778, -88.3047222, 20.9933092, -88.3174659, 21.0280795, -88.2928352, 0),
(2330, 31, 'HalachÃ³', 'Halacho', NULL, 0.000380807, 20.4777845, -90.0797756, 20.459586, -90.0985638, 20.5047565, -90.0629804, 0),
(2333, 31, 'HomÃºn', 'Homun', NULL, 0.00228484, 20.7386591, -89.2837509, 20.7247767, -89.3013923, 20.7561975, -89.264775, 0),
(2335, 31, 'HunucmÃ¡', 'Hunucma', NULL, 0.0201828, 21.0181394, -89.8753354, 20.9935421, -89.9029629, 21.0371022, -89.8520249, 0),
(2337, 31, 'Izamal', 'Izamal', NULL, 0.0277989, 20.934548, -89.018234, 20.9184266, -89.0442283, 20.9495109, -88.9967458, 0),
(2338, 31, 'KanasÃn', 'Kanasin', NULL, 0.033511, 20.9333333, -89.5666667, 20.9069795, -89.5954211, 20.981285, -89.5378892, 0),
(2341, 31, 'Kinchil', 'Kinchil', NULL, 0.00266565, 20.9163452, -89.9484471, 20.9023021, -89.9645692, 20.9288273, -89.9371767, 0),
(2345, 31, 'MaxcanÃº', 'Maxcanu', NULL, 0.00342727, 20.585761, -90.002427, 20.5719344, -90.0210758, 20.5978789, -89.9823951, 0),
(2347, 31, 'MÃ©rida', 'Merida', NULL, 0.0936786, 20.97, -89.62, 20.8729168, -89.7136744, 21.0690449, -89.5430335, 439),
(2349, 31, 'Motul', 'Motul', NULL, 0.0323686, 21.1002409, -89.2775271, 21.0741226, -89.3059042, 21.1201194, -89.260718, 41),
(2350, 31, 'Muna', 'Muna', NULL, 0.0159939, 20.486706, -89.712952, 20.4748678, -89.7274357, 20.510022, -89.6910191, 0),
(2353, 31, 'Oxkutzcab', 'Oxkutzcab', NULL, 0.0251333, 20.3010922, -89.4186014, 20.2941939, -89.4301429, 20.3165734, -89.4022421, 0),
(2354, 31, 'PanabÃ¡', 'Panaba', NULL, 0.00495049, 21.2962949, -88.2702809, 21.2862556, -88.2786181, 21.3025291, -88.2619582, 0),
(2355, 31, 'Peto', 'Peto', NULL, 0.0190404, 20.1262672, -88.9228321, 20.1150477, -88.9325864, 20.1367029, -88.9135734, 0),
(2356, 31, 'Progreso', 'Progreso', NULL, 0.0464585, 21.28, -89.67, 21.264106, -89.714691, 21.3488689, -89.6244264, 37),
(2357, 31, 'Quintana Roo', 'Quintana Roo', NULL, 0.0129474, 20.8683377, -88.6317336, 0, 0, 0, 0, 65),
(2361, 31, 'San Felipe', 'San Felipe', NULL, 0.0148515, 21.5666222, -88.2331341, 0, 0, 0, 0, 29),
(2364, 31, 'SeyÃ©', 'Seye', NULL, 0.00266565, 20.8371769, -89.3705719, 20.8301627, -89.3777959, 20.8420157, -89.3621791, 0),
(2366, 31, 'Sotuta', 'Sotuta', NULL, 0.000380807, 20.5971484, -89.0081646, 20.5868672, -89.0170384, 20.6031177, -89.0021029, 0),
(2370, 31, 'TahdziÃº', 'Tahdziu', NULL, 0, 20.2024099, -88.9433598, 20.1950497, -88.9505911, 20.2097702, -88.9361286, 0),
(2372, 31, 'Teabo', 'Teabo', NULL, 0.00228484, 20.4031442, -89.2842216, 20.3912769, -89.2888001, 20.4074654, -89.2755124, 0),
(2373, 31, 'Tecoh', 'Tecoh', NULL, 0.0133283, 20.741988, -89.473883, 20.7285635, -89.4892343, 20.7553393, -89.4610365, 0),
(2377, 31, 'Tekit', 'Tekit', NULL, 0.00266565, 20.5328824, -89.3313674, 20.5247138, -89.3488232, 20.5478222, -89.3218896, 0),
(2380, 31, 'Telchac Puerto', 'Telchac Puerto', NULL, 0.0205636, 21.3421022, -89.2624626, 21.3372349, -89.2813866, 21.3445574, -89.2507211, 0),
(2381, 31, 'Temax', 'Temax', NULL, 0.00152323, 21.1505259, -88.9385184, 21.1372253, -88.9545576, 21.1611524, -88.9245819, 0),
(2382, 31, 'TemozÃ³n', 'Temozon', NULL, 0.021706, 20.8019969, -88.2007654, 20.7932376, -88.2099231, 20.8131824, -88.1927574, 0),
(2384, 31, 'Tetiz', 'Tetiz', NULL, 0.000380807, 20.9626882, -89.9345214, 20.9544789, -89.9412206, 20.9705402, -89.9244876, 0),
(2386, 31, 'Ticul', 'Ticul', NULL, 0.0228484, 20.3984894, -89.5379091, 20.3796259, -89.5601617, 20.4141218, -89.5152427, 0),
(2390, 31, 'Tixkokob', 'Tixkokob', NULL, 0.0228484, 21.0022222, -89.3936111, 20.982995, -89.4152066, 21.0156358, -89.3736623, 0),
(2393, 31, 'TizimÃn', 'Tizimin', NULL, 0.0388423, 21.1457777, -88.1498801, 21.1027465, -88.1805154, 21.1656591, -88.1145943, 29),
(2395, 31, 'Tzucacab', 'Tzucacab', NULL, 0.00190404, 20.0715949, -89.0495866, 20.0596954, -89.0590956, 20.0842527, -89.0376574, 0),
(2397, 31, 'UcÃº', 'Ucu', NULL, 0.0430312, 21.0311039, -89.7441766, 0, 0, 0, 0, 23),
(2398, 31, 'UmÃ¡n', 'Uman', NULL, 0.0445545, 20.881828, -89.746846, 20.8635704, -89.7664635, 20.9123232, -89.712561, 0),
(2399, 31, 'Valladolid', 'Valladolid', NULL, 0.0472201, 20.6886097, -88.1997174, 20.6764532, -88.2203244, 20.7045442, -88.1801609, 44),
(2408, 32, 'Calera', 'Calera', NULL, 0.0365575, 22.9512648, -102.7177389, 22.9484301, -102.7194067, 22.9541053, -102.7160477, 54),
(2409, 32, 'CaÃ±itas de Felipe Pescador', 'Cañitas de Felipe Pescador', NULL, 0.00152323, 36.778261, -119.4179324, 32.528832, -124.482003, 42.0095169, -114.131211, 0),
(2411, 32, 'ConcepciÃ³n del Oro', 'Concepcion del Oro', NULL, 0.00875857, 24.6128544, -101.4183831, 24.6027467, -101.4299655, 24.6213178, -101.411196, 0),
(2412, 32, 'CuauhtÃ©moc', 'Cuauhtemoc', NULL, 0.0437928, 22.7577894, -102.5833992, 22.756988, -102.5841084, 22.759384, -102.5831393, 28),
(2414, 32, 'El Salvador', 'El Salvador', NULL, 0.0201828, 24.5201999, -100.8671019, 0, 0, 0, 0, 103),
(2415, 32, 'Fresnillo', 'Fresnillo', NULL, 0.0460777, 23.1719444, -102.8608333, 23.1528023, -102.915019, 23.2146712, -102.83078, 116),
(2418, 32, 'General Francisco R. MurguÃa', 'General Francisco R. Murguia', NULL, 0.00190404, 23.9975563, -103.0212924, 23.9868668, -103.030441, 24.0092957, -103.0004075, 0),
(2420, 32, 'Guadalupe', 'Guadalupe', NULL, 0.043412, 22.753223, -102.509537, 22.7223823, -102.5456936, 22.7872066, -102.4852275, 66),
(2422, 32, 'Jalpa', 'Jalpa', NULL, 0.0167555, 21.6327114, -102.9849261, 21.6217943, -102.9945749, 21.6595133, -102.9615233, 0),
(2423, 32, 'Jerez', 'Jerez', NULL, 0.0392232, 22.6468746, -102.9876221, 22.6180005, -103.0138625, 22.673999, -102.9592088, 77),
(2425, 32, 'Juan Aldama', 'Juan Aldama', NULL, 0.00418888, 24.291, -103.394, 24.2652969, -103.4153161, 24.3148034, -103.3741928, 0),
(2426, 32, 'Juchipila', 'Juchipila', NULL, 0.00913938, 21.4121021, -103.1175436, 21.3814774, -103.1238753, 21.4226469, -103.1075705, 0),
(2427, 32, 'Loreto', 'Loreto', NULL, 0.0194212, 22.2697664, -101.9848631, 22.257526, -102.0025051, 22.2843017, -101.9689247, 41),
(2428, 32, 'Luis Moya', 'Luis Moya', NULL, 0.00456969, 22.4338959, -102.2492261, 22.4224039, -102.2604976, 22.4435568, -102.2398687, 0),
(2431, 32, 'Mezquital del Oro', 'Mezquital del Oro', NULL, 0, 21.216348, -103.361997, 21.2081789, -103.3666277, 21.2226214, -103.3586454, 0),
(2432, 32, 'Miguel Auza', 'Miguel Auza', NULL, 0.00418888, 24.2937692, -103.4503404, 24.2755498, -103.4657242, 24.3044752, -103.4296253, 0),
(2435, 32, 'Morelos', 'Morelos', NULL, 0.0312262, 22.8971999, -102.6853001, 22.8803129, -102.6965548, 22.9110224, -102.6749266, 37),
(2437, 32, 'NochistlÃ¡n de MejÃa', 'Nochistlan de Mejia', NULL, 0.00228484, 21.362813, -102.8428557, 21.3501787, -102.8582732, 21.3835881, -102.8226734, 0),
(2465, 36, 'Barranquilla', 'Barranquilla', NULL, 0.2, 10.987778, -74.788889, 10.91627, -74.91996, 11.1075611, -74.75827, 63),
(2439, 32, 'Ojocaliente', 'Ojocaliente', NULL, 0.0152323, 22.5706028, -102.2546666, 22.5558679, -102.2702728, 22.5889142, -102.2408209, 0),
(2441, 32, 'Pinos', 'Pinos', NULL, 0.0114242, 22.2972779, -101.5747236, 0, 0, 0, 0, 27),
(2442, 32, 'RÃo Grande', 'Rio Grande', NULL, 0.0346535, 23.8225, -103.0363889, 23.8057151, -103.0696279, 23.8466646, -103.0109449, 53),
(2443, 32, 'Sain Alto', 'Sain Alto', NULL, 0.000380807, 23.5818229, -103.2521209, 23.5666842, -103.2574246, 23.5859509, -103.2382576, 0),
(2463, 33, 'Bogota', 'Bogota', 'cafe', 1, 4.5968351, -74.0730641, 3.72977, -74.45177, 4.8371, -73.99631, 82),
(2445, 32, 'Sombrerete', 'Sombrerete', NULL, 0.0220868, 23.6345012, -103.6401136, 23.608724, -103.6551067, 23.6514104, -103.6203753, 21),
(2447, 32, 'Tabasco', 'Tabasco', NULL, 0.019802, 21.8643824, -102.9130144, 21.8525977, -102.9279567, 21.8770117, -102.9023655, 48),
(2450, 32, 'Teul de GonzÃ¡lez Ortega', 'Teul de Gonzalez Ortega', NULL, 0.00152323, 21.4619444, -103.4605556, 21.4575221, -103.4689593, 21.4742963, -103.4499693, 0),
(2451, 32, 'Tlaltenango de SÃ¡nchez RomÃ¡n', 'Tlaltenango de Sanchez Roman', NULL, 0.0148515, 21.7833333, -103.3, 21.7657327, -103.3179278, 21.7985808, -103.2821563, 0),
(2452, 32, 'Trancoso', 'Trancoso', NULL, 0.019802, 22.731393, -102.364989, 22.7267281, -102.3852793, 22.7493119, -102.3456824, 0),
(2453, 32, 'Trinidad GarcÃa de la Cadena', 'Trinidad Garcia de la Cadena', NULL, 0.0323686, 22.7676866, -102.5779621, 22.7672625, -102.5787518, 22.7689086, -102.5778089, 0),
(2454, 32, 'ValparaÃso', 'Valparaiso', NULL, 0.0156131, 22.772275, -103.568396, 22.7494091, -103.5891673, 22.7983294, -103.540481, 0),
(2457, 32, 'Villa GarcÃa', 'Villa Garcia', NULL, 0.00152323, 22.16609, -101.955803, 22.1532466, -101.9627056, 22.1784217, -101.9422533, 0),
(2458, 32, 'Villa GonzÃ¡lez Ortega', 'Villa Gonzalez Ortega', NULL, 0, 22.5127494, -101.9134491, 22.5028017, -101.9225044, 22.5301131, -101.9027963, 0),
(2459, 32, 'Villa Hidalgo', 'Villa Hidalgo', NULL, 0, 22.3538861, -101.7126938, 22.3459613, -101.7189932, 22.3602883, -101.7075979, 0),
(2460, 32, 'Villanueva', 'Villanueva', NULL, 0.0125666, 22.3536111, -102.8830556, 22.3375671, -102.8992215, 22.3739965, -102.8677165, 28),
(2461, 32, 'Zacatecas', 'Zacatecas', NULL, 0.18393, 22.7709249, -102.5832539, 22.7380445, -102.6257741, 22.789332, -102.540693, 314),
(2462, 23, 'Cancun', 'Cancun', 'playa', 0.112338, 21.158964, -86.845937, 21.0302551, -86.9137291, 21.2139108, -86.7408201, 235),
(2464, 35, 'Medellín', 'Medellin', NULL, 0, 6.235925, -75.566667, 6.16711, -75.71859, 6.37325, -75.4776, 59);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;