Skip to content

Instantly share code, notes, and snippets.

@CaterinMorales

CaterinMorales/MySQL:regiones-provincias-comunas-chile.sql

Forked from Raulebc/MySQL:regiones-provincias-comunas-chile.sql
Created February 11, 2023 14:52
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save CaterinMorales/b6bcbc3915d7083a5c61543bd1133b41 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save CaterinMorales/b6bcbc3915d7083a5c61543bd1133b41 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL-Chile:regiones-provincias-comunas
Raw
MySQL:regiones-provincias-comunas-chile.sql
DROP TABLE IF EXISTS `comunas`;
CREATE TABLE `comunas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`comuna` varchar(64) NOT NULL,
`provincia_id` int(11) NOT NULL,
PRIMARY KEY (`comuna_id`)
) ENGINE=MyISAM AUTO_INCREMENT=346 DEFAULT CHARSET=utf8;
INSERT INTO `comunas` (`id`,`comuna`,`provincia_id`)
VALUES
(1,'Arica',1),
(2,'Camarones',1),
(3,'General Lagos',2),
(4,'Putre',2),
(5,'Alto Hospicio',3),
(6,'Iquique',3),
(7,'Camiña',4),
(8,'Colchane',4),
(9,'Huara',4),
(10,'Pica',4),
(11,'Pozo Almonte',4),
(12,'Tocopilla',5),
(13,'María Elena',5),
(14,'Calama',6),
(15,'Ollague',6),
(16,'San Pedro de Atacama',6),
(17,'Antofagasta',7),
(18,'Mejillones',7),
(19,'Sierra Gorda',7),
(20,'Taltal',7),
(21,'Chañaral',8),
(22,'Diego de Almagro',8),
(23,'Copiapó',9),
(24,'Caldera',9),
(25,'Tierra Amarilla',9),
(26,'Vallenar',10),
(27,'Alto del Carmen',10),
(28,'Freirina',10),
(29,'Huasco',10),
(30,'La Serena',11),
(31,'Coquimbo',11),
(32,'Andacollo',11),
(33,'La Higuera',11),
(34,'Paihuano',11),
(35,'Vicuña',11),
(36,'Ovalle',12),
(37,'Combarbalá',12),
(38,'Monte Patria',12),
(39,'Punitaqui',12),
(40,'Río Hurtado',12),
(41,'Illapel',13),
(42,'Canela',13),
(43,'Los Vilos',13),
(44,'Salamanca',13),
(45,'La Ligua',14),
(46,'Cabildo',14),
(47,'Zapallar',14),
(48,'Papudo',14),
(49,'Petorca',14),
(50,'Los Andes',15),
(51,'San Esteban',15),
(52,'Calle Larga',15),
(53,'Rinconada',15),
(54,'San Felipe',16),
(55,'Llaillay',16),
(56,'Putaendo',16),
(57,'Santa María',16),
(58,'Catemu',16),
(59,'Panquehue',16),
(60,'Quillota',17),
(61,'La Cruz',17),
(62,'La Calera',17),
(63,'Nogales',17),
(64,'Hijuelas',17),
(65,'Valparaíso',18),
(66,'Viña del Mar',18),
(67,'Concón',18),
(68,'Quintero',18),
(69,'Puchuncaví',18),
(70,'Casablanca',18),
(71,'Juan Fernández',18),
(72,'San Antonio',19),
(73,'Cartagena',19),
(74,'El Tabo',19),
(75,'El Quisco',19),
(76,'Algarrobo',19),
(77,'Santo Domingo',19),
(78,'Isla de Pascua',20),
(79,'Quilpué',21),
(80,'Limache',21),
(81,'Olmué',21),
(82,'Villa Alemana',21),
(83,'Colina',22),
(84,'Lampa',22),
(85,'Tiltil',22),
(86,'Santiago',23),
(87,'Vitacura',23),
(88,'San Ramón',23),
(89,'San Miguel',23),
(90,'San Joaquín',23),
(91,'Renca',23),
(92,'Recoleta',23),
(93,'Quinta Normal',23),
(94,'Quilicura',23),
(95,'Pudahuel',23),
(96,'Providencia',23),
(97,'Peñalolén',23),
(98,'Pedro Aguirre Cerda',23),
(99,'Ñuñoa',23),
(100,'Maipú',23),
(101,'Macul',23),
(102,'Lo Prado',23),
(103,'Lo Espejo',23),
(104,'Lo Barnechea',23),
(105,'Las Condes',23),
(106,'La Reina',23),
(107,'La Pintana',23),
(108,'La Granja',23),
(109,'La Florida',23),
(110,'La Cisterna',23),
(111,'Independencia',23),
(112,'Huechuraba',23),
(113,'Estación Central',23),
(114,'El Bosque',23),
(115,'Conchalí',23),
(116,'Cerro Navia',23),
(117,'Cerrillos',23),
(118,'Puente Alto',24),
(119,'San José de Maipo',24),
(120,'Pirque',24),
(121,'San Bernardo',25),
(122,'Buin',25),
(123,'Paine',25),
(124,'Calera de Tango',25),
(125,'Melipilla',26),
(126,'Alhué',26),
(127,'Curacaví',26),
(128,'María Pinto',26),
(129,'San Pedro',26),
(130,'Isla de Maipo',27),
(131,'El Monte',27),
(132,'Padre Hurtado',27),
(133,'Peñaflor',27),
(134,'Talagante',27),
(135,'Codegua',28),
(136,'Coínco',28),
(137,'Coltauco',28),
(138,'Doñihue',28),
(139,'Graneros',28),
(140,'Las Cabras',28),
(141,'Machalí',28),
(142,'Malloa',28),
(143,'Mostazal',28),
(144,'Olivar',28),
(145,'Peumo',28),
(146,'Pichidegua',28),
(147,'Quinta de Tilcoco',28),
(148,'Rancagua',28),
(149,'Rengo',28),
(150,'Requínoa',28),
(151,'San Vicente de Tagua Tagua',28),
(152,'Chépica',29),
(153,'Chimbarongo',29),
(154,'Lolol',29),
(155,'Nancagua',29),
(156,'Palmilla',29),
(157,'Peralillo',29),
(158,'Placilla',29),
(159,'Pumanque',29),
(160,'San Fernando',29),
(161,'Santa Cruz',29),
(162,'La Estrella',30),
(163,'Litueche',30),
(164,'Marchigüe',30),
(165,'Navidad',30),
(166,'Paredones',30),
(167,'Pichilemu',30),
(168,'Curicó',31),
(169,'Hualañé',31),
(170,'Licantén',31),
(171,'Molina',31),
(172,'Rauco',31),
(173,'Romeral',31),
(174,'Sagrada Familia',31),
(175,'Teno',31),
(176,'Vichuquén',31),
(167,'Cauquenes',30),
(168,'Chanco',30),
(169,'Pelluhue',30),
(179,'Colbún',32),
(180,'Linares',32),
(181,'Longaví',32),
(182,'Parral',32),
(183,'Retiro',32),
(184,'San Javier',32),
(185,'Villa Alegre',32),
(186,'Yerbas Buenas',32),
(187,'Constitución',33),
(188,'Curepto',33),
(189,'Empedrado',33),
(190,'Maule',33),
(191,'Pelarco',33),
(192,'Pencahue',33),
(193,'Río Claro',33),
(194,'San Clemente',33),
(195,'San Rafael',33),
(196,'Talca',33),
(197,'Arauco',34),
(198,'Cañete',34),
(199,'Contulmo',34),
(200,'Curanilahue',34),
(201,'Lebu',34),
(202,'Los Álamos',34),
(203,'Tirúa',34),
(204,'Alto Biobío',35),
(205,'Antuco',35),
(206,'Cabrero',35),
(207,'Laja',35),
(208,'Los Ángeles',35),
(209,'Mulchén',35),
(210,'Nacimiento',35),
(211,'Negrete',35),
(212,'Quilaco',35),
(213,'Quilleco',35),
(214,'San Rosendo',35),
(215,'Santa Bárbara',35),
(216,'Tucapel',35),
(217,'Yumbel',35),
(218,'Chiguayante',36),
(219,'Concepción',36),
(220,'Coronel',36),
(221,'Florida',36),
(222,'Hualpén',36),
(223,'Hualqui',36),
(224,'Lota',36),
(225,'Penco',36),
(226,'San Pedro de La Paz',36),
(227,'Santa Juana',36),
(228,'Talcahuano',36),
(229,'Tomé',36),
(230,'Bulnes',37),
(231,'Chillán',37),
(232,'Chillán Viejo',37),
(233,'Cobquecura',37),
(234,'Coelemu',37),
(235,'Coihueco',37),
(236,'El Carmen',37),
(237,'Ninhue',37),
(238,'Ñiquen',37),
(239,'Pemuco',37),
(240,'Pinto',37),
(241,'Portezuelo',37),
(242,'Quillón',37),
(243,'Quirihue',37),
(244,'Ránquil',37),
(245,'San Carlos',37),
(246,'San Fabián',37),
(247,'San Ignacio',37),
(248,'San Nicolás',37),
(249,'Treguaco',37),
(250,'Yungay',37),
(251,'Carahue',38),
(252,'Cholchol',38),
(253,'Cunco',38),
(254,'Curarrehue',38),
(255,'Freire',38),
(256,'Galvarino',38),
(257,'Gorbea',38),
(258,'Lautaro',38),
(259,'Loncoche',38),
(260,'Melipeuco',38),
(261,'Nueva Imperial',38),
(262,'Padre Las Casas',38),
(263,'Perquenco',38),
(264,'Pitrufquén',38),
(265,'Pucón',38),
(266,'Saavedra',38),
(267,'Temuco',38),
(268,'Teodoro Schmidt',38),
(269,'Toltén',38),
(270,'Vilcún',38),
(271,'Villarrica',38),
(272,'Angol',39),
(273,'Collipulli',39),
(274,'Curacautín',39),
(275,'Ercilla',39),
(276,'Lonquimay',39),
(277,'Los Sauces',39),
(278,'Lumaco',39),
(279,'Purén',39),
(280,'Renaico',39),
(281,'Traiguén',39),
(282,'Victoria',39),
(283,'Corral',40),
(284,'Lanco',40),
(285,'Los Lagos',40),
(286,'Máfil',40),
(287,'Mariquina',40),
(288,'Paillaco',40),
(289,'Panguipulli',40),
(290,'Valdivia',40),
(291,'Futrono',41),
(292,'La Unión',41),
(293,'Lago Ranco',41),
(294,'Río Bueno',41),
(295,'Ancud',42),
(296,'Castro',42),
(297,'Chonchi',42),
(298,'Curaco de Vélez',42),
(299,'Dalcahue',42),
(300,'Puqueldón',42),
(301,'Queilén',42),
(302,'Quemchi',42),
(303,'Quellón',42),
(304,'Quinchao',42),
(305,'Calbuco',43),
(306,'Cochamó',43),
(307,'Fresia',43),
(308,'Frutillar',43),
(309,'Llanquihue',43),
(310,'Los Muermos',43),
(311,'Maullín',43),
(312,'Puerto Montt',43),
(313,'Puerto Varas',43),
(314,'Osorno',44),
(315,'Puero Octay',44),
(316,'Purranque',44),
(317,'Puyehue',44),
(318,'Río Negro',44),
(319,'San Juan de la Costa',44),
(320,'San Pablo',44),
(321,'Chaitén',45),
(322,'Futaleufú',45),
(323,'Hualaihué',45),
(324,'Palena',45),
(325,'Aisén',46),
(326,'Cisnes',46),
(327,'Guaitecas',46),
(328,'Cochrane',47),
(329,'O\'higgins',47),
(330,'Tortel',47),
(331,'Coihaique',48),
(332,'Lago Verde',48),
(333,'Chile Chico',49),
(334,'Río Ibáñez',49),
(335,'Antártica',50),
(336,'Cabo de Hornos',50),
(337,'Laguna Blanca',51),
(338,'Punta Arenas',51),
(339,'Río Verde',51),
(340,'San Gregorio',51),
(341,'Porvenir',52),
(342,'Primavera',52),
(343,'Timaukel',52),
(344,'Natales',53),
(345,'Torres del Paine',53);
DROP TABLE IF EXISTS `provincias`;
CREATE TABLE `provincias` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`provincia` varchar(64) NOT NULL,
`region_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;
INSERT INTO `provincias` (`id`,`provincia`,`region_id`)
VALUES
(1,'Arica',1),
(2,'Parinacota',1),
(3,'Iquique',2),
(4,'El Tamarugal',2),
(5,'Tocopilla',3),
(6,'El Loa',3),
(7,'Antofagasta',3),
(8,'Chañaral',4),
(9,'Copiapó',4),
(10,'Huasco',4),
(11,'Elqui',5),
(12,'Limarí',5),
(13,'Choapa',5),
(14,'Petorca',6),
(15,'Los Andes',6),
(16,'San Felipe de Aconcagua',6),
(17,'Quillota',6),
(18,'Valparaiso',6),
(19,'San Antonio',6),
(20,'Isla de Pascua',6),
(21,'Marga Marga',6),
(22,'Chacabuco',7),
(23,'Santiago',7),
(24,'Cordillera',7),
(25,'Maipo',7),
(26,'Melipilla',7),
(27,'Talagante',7),
(28,'Cachapoal',8),
(29,'Colchagua',8),
(30,'Cardenal Caro',8),
(31,'Curicó',9),
(32,'Talca',9),
(33,'Linares',9),
(34,'Cauquenes',9),
(35,'Diguillín',10),
(36,'Itata',10),
(37,'Punilla',10),
(38,'Bio Bío',11),
(39,'Concepción',11),
(40,'Arauco',11),
(41,'Malleco',12),
(42,'Cautín',12),
(43,'Valdivia',13),
(44,'Ranco',13),
(45,'Osorno',14),
(47,'Llanquihue',14),
(48,'Chiloé',14),
(49,'Palena',14),
(50,'Coyhaique',15),
(51,'Aysén',15),
(52,'General Carrera',15),
(53,'Capitán Prat',15),
(54,'Última Esperanza',16),
(55,'Magallanes',16),
(56,'Tierra del Fuego',16),
(57,'Antártica Chilena',16);
DROP TABLE IF EXISTS `regiones`;
CREATE TABLE `regiones` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`region` varchar(64) NOT NULL,
`abreviatura` varchar(4) NOT NULL,
`capital` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
INSERT INTO `regiones` (`id`,`region`,`abreviatura`,`capital`)
VALUES
(1,'Arica y Parinacota','AP','Arica'),
(2,'Tarapacá','TA','Iquique'),
(3,'Antofagasta','AN','Antofagasta'),
(4,'Atacama','AT','Copiapó'),
(5,'Coquimbo','CO','La Serena'),
(6,'Valparaiso','VA','valparaíso'),
(7,'Metropolitana de Santiago','RM','Santiago'),
(8,'Libertador General Bernardo O´Higgins','OH','Rancagua'),
(9,'Maule','MA','Talca'),
(10,'Ñuble','NB','Chillán'),
(11,'Biobío','BI','Concepción'),
(12,'La Araucanía','IAR','Temuco'),
(13,'Los Ríos','LR','Valdivia'),
(14,'Los Lagos','LL','Puerto Montt'),
(15,'Aysén del General Carlos Ibáñez del Campo','AI','Coyhaique'),
(16,'Magallanes y de la Antártica Chilena','MG','Punta Arenas');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment