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

Revisions

  1. @Raulebc Raulebc revised this gist Jun 30, 2022. 1 changed file with 52 additions and 56 deletions.
    108 changes: 52 additions & 56 deletions MySQL:regiones-provincias-comunas-chile.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,4 @@
    Script comunas, regiones, provincias Febrero 2019

    Script comunas, regiones, provincias Junio 2022

    DROP TABLE IF EXISTS `comunas`;

    @@ -307,62 +306,59 @@ VALUES
    (293,'Futrono',44),
    (294,'Lago Ranco',44),
    (295,'Río Bueno',44),
    (297,'Osorno',45),
    (298,'Puerto Octay',45),
    (299,'Purranque',45),
    (300,'Puyehue',45),
    (301,'Río Negro',45),
    (302,'San Juan de la Costa',45),
    (303,'San Pablo',45),
    (304,'Calbuco',46),
    (305,'Cochamó',46),
    (306,'Fresia',46),
    (307,'Frutillar',46),
    (308,'Llanquihue',46),
    (309,'Los Muermos',46),
    (310,'Maullín',46),
    (311,'Puerto Montt',46),
    (312,'Puerto Varas',46),
    (313,'Ancud',47),
    (314,'Castro',47),
    (315,'Chonchi',47),
    (316,'Curaco de Vélez',47),
    (317,'Dalcahue',47),
    (318,'Puqueldón',47),
    (319,'Queilén',47),
    (320,'Quellón',47),
    (321,'Quemchi',47),
    (322,'Quinchao',47),
    (323,'Chaitén',48),
    (324,'Futaleufú',48),
    (325,'Hualaihué',48),
    (326,'Palena',48),
    (327,'Lago Verde',49),
    (328,'Coihaique',49),
    (329,'Aysén',50),
    (330,'Cisnes',50),
    (331,'Guaitecas',50),
    (332,'Río Ibáñez',51),
    (333,'Chile Chico',51),
    (334,'Cochrane',52),
    (335,'O\'Higgins',52),
    (336,'Tortel',52),
    (337,'Natales',53),
    (338,'Torres del Paine',53),
    (339,'Laguna Blanca',54),
    (340,'Punta Arenas',54),
    (341,'Río Verde',54),
    (342,'San Gregorio',54),
    (343,'Porvenir',55),
    (344,'Primavera',55),
    (345,'Timaukel',55),
    (346,'Cabo de Hornos',56),
    (347,'Antártica',56);
    (296,'Osorno',45),
    (297,'Puerto Octay',45),
    (298,'Purranque',45),
    (299,'Puyehue',45),
    (300,'Río Negro',45),
    (301,'San Juan de la Costa',45),
    (302,'San Pablo',45),
    (303,'Calbuco',46),
    (304,'Cochamó',46),
    (305,'Fresia',46),
    (306,'Frutillar',46),
    (307,'Llanquihue',46),
    (308,'Los Muermos',46),
    (309,'Maullín',46),
    (310,'Puerto Montt',46),
    (311,'Puerto Varas',46),
    (312,'Ancud',47),
    (313,'Castro',47),
    (314,'Chonchi',47),
    (315,'Curaco de Vélez',47),
    (316,'Dalcahue',47),
    (317,'Puqueldón',47),
    (318,'Queilén',47),
    (319,'Quellón',47),
    (320,'Quemchi',47),
    (321,'Quinchao',47),
    (322,'Chaitén',48),
    (323,'Futaleufú',48),
    (324,'Hualaihué',48),
    (325,'Palena',48),
    (326,'Lago Verde',49),
    (327,'Coihaique',49),
    (328,'Aysén',50),
    (329,'Cisnes',50),
    (330,'Guaitecas',50),
    (331,'Río Ibáñez',51),
    (332,'Chile Chico',51),
    (333,'Cochrane',52),
    (334,'O\'Higgins',52),
    (335,'Tortel',52),
    (336,'Natales',53),
    (337,'Torres del Paine',53),
    (338,'Laguna Blanca',54),
    (339,'Punta Arenas',54),
    (340,'Río Verde',54),
    (341,'San Gregorio',54),
    (342,'Porvenir',55),
    (343,'Primavera',55),
    (344,'Timaukel',55),
    (345,'Cabo de Hornos',56),
    (346,'Antártica',56);





    DROP TABLE IF EXISTS `provincias`;

    CREATE TABLE `provincias` (
  2. @Raulebc Raulebc revised this gist Feb 21, 2019. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions MySQL:regiones-provincias-comunas-chile.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -345,7 +345,7 @@ VALUES
    (332,'Río Ibáñez',51),
    (333,'Chile Chico',51),
    (334,'Cochrane',52),
    (335,'O´Higgins',52),
    (335,'O\'Higgins',52),
    (336,'Tortel',52),
    (337,'Natales',53),
    (338,'Torres del Paine',53),
    @@ -451,7 +451,7 @@ VALUES
    (5,'Coquimbo','CO','La Serena'),
    (6,'Valparaiso','VA','valparaíso'),
    (7,'Metropolitana de Santiago','RM','Santiago'),
    (8,'Libertador General Bernardo O´Higgins','OH','Rancagua'),
    (8,'Libertador General Bernardo O\'Higgins','OH','Rancagua'),
    (9,'Maule','MA','Talca'),
    (10,'Ñuble','NB','Chillán'),
    (11,'Biobío','BI','Concepción'),
  3. @Raulebc Raulebc revised this gist Feb 20, 2019. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions MySQL:regiones-provincias-comunas-chile.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,6 @@
    Script comunas, regiones, provincias Febrero 2019


    DROP TABLE IF EXISTS `comunas`;

    CREATE TABLE `comunas` (
  4. @Raulebc Raulebc revised this gist Feb 20, 2019. 1 changed file with 2 additions and 3 deletions.
    5 changes: 2 additions & 3 deletions MySQL:regiones-provincias-comunas-chile.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@ 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`)
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=346 DEFAULT CHARSET=utf8;

    INSERT INTO `comunas` (`id`,`comuna`,`provincia_id`)
    @@ -271,7 +271,6 @@ VALUES
    (260,'Renaico',41),
    (261,'Traiguén',41),
    (262,'Victoria',41),

    (263,'Temuco',42),
    (264,'Carahue',42),
    (265,'Cholchol',42),
    @@ -288,7 +287,7 @@ VALUES
    (276,'Perquenco',42),
    (277,'Pitrufquén',42),
    (278,'Pucón',42),
    (279,'Saavedra'428),
    (279,'Saavedra',42),
    (280,'Teodoro Schmidt',42),
    (281,'Toltén',42),
    (282,'Vilcún',42),
  5. @Raulebc Raulebc revised this gist Feb 20, 2019. 1 changed file with 163 additions and 173 deletions.
    336 changes: 163 additions & 173 deletions MySQL:regiones-provincias-comunas-chile.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -167,7 +167,7 @@ VALUES
    (156,'Palmilla',29),
    (157,'Peralillo',29),
    (158,'Placilla',29),
    (159,'Pumanque',29),
    (159,'Pumanque',29),
    (160,'San Fernando',29),
    (161,'Santa Cruz',29),
    (162,'La Estrella',30),
    @@ -206,170 +206,160 @@ VALUES
    (195,'Cauquenes',34),
    (196,'Chanco',34),
    (197,'Pelluhue',34),




    (198,'Bulnes',35),
    (199,'Chillán',35),
    (200,'Chillán Viejo',35),
    (201,'El Carmen',35),
    (202,'Pemuco',35),
    (203,'Pinto',35),
    (204,'Quillón',35),
    (205,'San Ignacio',35),
    (206,'Yungay',35),
    (207,'Cobquecura',36),
    (208,'Coelemu',36),
    (209,'Ninhue',36),
    (210,'Portezuelo',36),
    (211,'Quirihue',36),
    (212,'Ránquil',36),
    (213,'Treguaco',36),
    (214,'San Carlos',37),
    (215,'Coihueco',37),
    (216,'San Nicolás',37),
    (217,'Ñiquén',37),
    (218,'San Fabián',37),
    (219,'Alto Biobío',38),
    (220,'Antuco',38),
    (221,'Cabrero',38),
    (222,'Laja',38),
    (223,'Los Ángeles',38),
    (224,'Mulchén',38),
    (225,'Nacimiento',38),
    (226,'Negrete',38),
    (227,'Quilaco',38),
    (228,'Quilleco',38),
    (229,'San Rosendo',38),
    (230,'Santa Bárbara',38),
    (231,'Tucapel',38),
    (232,'Yumbel',38),
    (233,'Concepción',39),
    (234,'Coronel',39),
    (235,'Chiguayante',39),
    (236,'Florida',39),
    (237,'Hualpén',39),
    (238,'Hualqui',39),
    (239,'Lota',39),
    (240,'Penco',39),
    (241,'San Pedro de La Paz',39),
    (242,'Santa Juana',39),
    (243,'Talcahuano',39),
    (244,'Tomé',39),
    (245,'Arauco',40),
    (246,'Cañete',40),
    (247,'Contulmo',40),
    (248,'Curanilahue',40),
    (249,'Lebu',40),
    (250,'Los Álamos',40),
    (251,'Tirúa',40),
    (252,'Angol',41),
    (253,'Collipulli',41),
    (254,'Curacautín',41),
    (255,'Ercilla',41),
    (256,'Lonquimay',41),
    (257,'Los Sauces',41),
    (258,'Lumaco',41),
    (259,'Purén',41),
    (260,'Renaico',41),
    (261,'Traiguén',41),
    (262,'Victoria',41),

    (263,'Temuco',42),
    (264,'Carahue',42),
    (265,'Cholchol',42),
    (266,'Cunco',42),
    (267,'Curarrehue',42),
    (268,'Freire',42),
    (269,'Galvarino',42),
    (270,'Gorbea',42),
    (271,'Lautaro',42),
    (272,'Loncoche',42),
    (273,'Melipeuco',42),
    (274,'Nueva Imperial',42),
    (275,'Padre Las Casas',42),
    (276,'Perquenco',42),
    (277,'Pitrufquén',42),
    (278,'Pucón',42),
    (279,'Saavedra'428),
    (280,'Teodoro Schmidt',42),
    (281,'Toltén',42),
    (282,'Vilcún',42),
    (283,'Villarrica',42),
    (284,'Valdivia',43),
    (285,'Corral',43),
    (286,'Lanco',43),
    (287,'Los Lagos',43),
    (288,'Máfil',43),
    (289,'Mariquina',43),
    (290,'Paillaco',43),
    (291,'Panguipulli',43),
    (292,'La Unión',44),
    (293,'Futrono',44),
    (294,'Lago Ranco',44),
    (295,'Río Bueno',44),
    (297,'Osorno',45),
    (298,'Puerto Octay',45),
    (299,'Purranque',45),
    (300,'Puyehue',45),
    (301,'Río Negro',45),
    (302,'San Juan de la Costa',45),
    (303,'San Pablo',45),
    (304,'Calbuco',46),
    (305,'Cochamó',46),
    (306,'Fresia',46),
    (307,'Frutillar',46),
    (308,'Llanquihue',46),
    (309,'Los Muermos',46),
    (310,'Maullín',46),
    (311,'Puerto Montt',46),
    (312,'Puerto Varas',46),
    (313,'Ancud',47),
    (314,'Castro',47),
    (315,'Chonchi',47),
    (316,'Curaco de Vélez',47),
    (317,'Dalcahue',47),
    (318,'Puqueldón',47),
    (319,'Queilén',47),
    (320,'Quellón',47),
    (321,'Quemchi',47),
    (322,'Quinchao',47),
    (323,'Chaitén',48),
    (324,'Futaleufú',48),
    (325,'Hualaihué',48),
    (326,'Palena',48),
    (327,'Lago Verde',49),
    (328,'Coihaique',49),
    (329,'Aysén',50),
    (330,'Cisnes',50),
    (331,'Guaitecas',50),
    (332,'Río Ibáñez',51),
    (333,'Chile Chico',51),
    (334,'Cochrane',52),
    (335,'O´Higgins',52),
    (336,'Tortel',52),
    (337,'Natales',53),
    (338,'Torres del Paine',53),
    (339,'Laguna Blanca',54),
    (340,'Punta Arenas',54),
    (341,'Río Verde',54),
    (342,'San Gregorio',54),
    (343,'Porvenir',55),
    (344,'Primavera',55),
    (345,'Timaukel',55),
    (346,'Cabo de Hornos',56),
    (347,'Antártica',56);










    (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`;

    @@ -427,17 +417,17 @@ VALUES
    (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);
    (46,'Llanquihue',14),
    (47,'Chiloé',14),
    (48,'Palena',14),
    (49,'Coyhaique',15),
    (50,'Aysén',15),
    (51,'General Carrera',15),
    (52,'Capitán Prat',15),
    (53,'Última Esperanza',16),
    (54,'Magallanes',16),
    (55,'Tierra del Fuego',16),
    (56,'Antártica Chilena',16);


    DROP TABLE IF EXISTS `regiones`;
    @@ -461,7 +451,7 @@ VALUES
    (7,'Metropolitana de Santiago','RM','Santiago'),
    (8,'Libertador General Bernardo O´Higgins','OH','Rancagua'),
    (9,'Maule','MA','Talca'),
    (10,'Ñuble','NB','Chillán'),
    (10,'Ñuble','NB','Chillán'),
    (11,'Biobío','BI','Concepción'),
    (12,'La Araucanía','IAR','Temuco'),
    (13,'Los Ríos','LR','Valdivia'),
  6. @Raulebc Raulebc revised this gist Feb 20, 2019. 1 changed file with 95 additions and 91 deletions.
    186 changes: 95 additions & 91 deletions MySQL:regiones-provincias-comunas-chile.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -20,68 +20,68 @@ VALUES
    (9,'Huara',4),
    (10,'Pica',4),
    (11,'Pozo Almonte',4),
    (12,'Tocopilla',5),
    (13,'María Elena',5),
    (12,'Tocopilla',5),
    (13,'María Elena',5),
    (14,'Calama',6),
    (15,'Ollague',6),
    (16,'San Pedro de Atacama',6),
    (17,'Antofagasta',7),
    (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),
    (23,'Copiapó',9),
    (24,'Caldera',9),
    (25,'Tierra Amarilla',9),
    (26,'Vallenar',10),
    (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),
    (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),
    (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),
    (46,'Cabildo',14),
    (47,'Zapallar',14),
    (48,'Papudo',14),
    (48,'Papudo',14),
    (49,'Petorca',14),
    (50,'Los Andes',15),
    (51,'San Esteban',15),
    (52,'Calle Larga',15),
    (53,'Rinconada',15),
    (52,'Calle Larga',15),
    (53,'Rinconada',15),
    (54,'San Felipe',16),
    (55,'Llaillay',16),
    (56,'Putaendo',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),
    (60,'Quillota',17),
    (61,'La Cruz',17),
    (62,'La Calera',17),
    (63,'Nogales',17),
    (64,'Hijuelas',17),
    (64,'Hijuelas',17),
    (65,'Valparaíso',18),
    (66,'Viña del Mar',18),
    (66,'Viña del Mar',18),
    (67,'Concón',18),
    (68,'Quintero',18),
    (69,'Puchuncaví',18),
    (69,'Puchuncaví',18),
    (70,'Casablanca',18),
    (71,'Juan Fernández',18),
    (72,'San Antonio',19),
    (73,'Cartagena',19),
    (73,'Cartagena',19),
    (74,'El Tabo',19),
    (75,'El Quisco',19),
    (76,'Algarrobo',19),
    @@ -94,20 +94,19 @@ VALUES
    (83,'Colina',22),
    (84,'Lampa',22),
    (85,'Tiltil',22),

    (86,'Santiago',23),
    (87,'Vitacura',23),
    (88,'San Ramón',23),
    (88,'San Ramón',23),
    (89,'San Miguel',23),
    (90,'San Joaquín',23),
    (91,'Renca',23),
    (91,'Renca',23),
    (92,'Recoleta',23),
    (93,'Quinta Normal',23),
    (93,'Quinta Normal',23),
    (94,'Quilicura',23),
    (95,'Pudahuel',23),
    (96,'Providencia',23),
    (95,'Pudahuel',23),
    (96,'Providencia',23),
    (97,'Peñalolén',23),
    (98,'Pedro Aguirre Cerda',23),
    (98,'Pedro Aguirre Cerda',23),
    (99,'Ñuñoa',23),
    (100,'Maipú',23),
    (101,'Macul',23),
    @@ -119,28 +118,28 @@ VALUES
    (107,'La Pintana',23),
    (108,'La Granja',23),
    (109,'La Florida',23),
    (110,'La Cisterna',23),
    (111,'Independencia',23),
    (112,'Huechuraba',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),
    (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),
    (120,'Pirque',24),
    (121,'San Bernardo',25),
    (122,'Buin',25),
    (123,'Paine',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),
    (131,'El Monte',27),
    (132,'Padre Hurtado',27),
    (133,'Peñaflor',27),
    (134,'Talagante',27),
    @@ -164,11 +163,11 @@ VALUES
    (152,'Chépica',29),
    (153,'Chimbarongo',29),
    (154,'Lolol',29),
    (155,'Nancagua',29),
    (156,'Palmilla',29),
    (157,'Peralillo',29),
    (155,'Nancagua',29),
    (156,'Palmilla',29),
    (157,'Peralillo',29),
    (158,'Placilla',29),
    (159,'Pumanque',29),
    (159,'Pumanque',29),
    (160,'San Fernando',29),
    (161,'Santa Cruz',29),
    (162,'La Estrella',30),
    @@ -179,44 +178,49 @@ VALUES
    (167,'Pichilemu',30),
    (168,'Curicó',31),
    (169,'Hualañé',31),
    (170,'Licantén',31),
    (171,'Molina',31),
    (170,'Licantén',31),
    (171,'Molina',31),
    (172,'Rauco',31),
    (173,'Romeral',31),
    (174,'Sagrada Familia',31),
    (174,'Sagrada Familia',31),
    (175,'Teno',31),
    (176,'Vichuquén',31),
    (177,'Talca',32),
    (178,'San Clemente',32),
    (179,'Pelarco',32),
    (180,'Pencahue',32),
    (181,'Maule',32),
    (182,'San Rafael',32),
    (183,'Curepto',33),
    (184,'Constitución',32),
    (185,'Empedrado',32),
    (186,'Río Claro',32),
    (187,'Linares',33),
    (188,'San Javier',33),
    (189,'Parral',33),
    (190,'Villa Alegre',33),
    (191,'Longaví',33),
    (192,'Colbún',33),
    (193,'Retiro',33),
    (194,'Yerbas Buenas',33),
    (195,'Cauquenes',34),
    (196,'Chanco',34),
    (197,'Pelluhue',34),









    (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),
    @@ -382,57 +386,57 @@ VALUES
    (2,'Parinacota',1),
    (3,'Iquique',2),
    (4,'El Tamarugal',2),
    (5,'Tocopilla',3),
    (6,'El Loa',3),
    (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),
    (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),
    (20,'Isla de Pascua',6),
    (21,'Marga Marga',6),
    (22,'Chacabuco',7),
    (23,'Santiago',7),
    (23,'Santiago',7),
    (24,'Cordillera',7),
    (25,'Maipo',7),
    (26,'Melipilla',7),
    (27,'Talagante',7),
    (28,'Cachapoal',8),
    (29,'Colchagua',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),
    (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),
    (41,'Malleco',12),
    (42,'Cautín',12),
    (43,'Valdivia',13),
    (44,'Ranco',13),
    (45,'Osorno',14),
    (47,'Llanquihue',14),
    (45,'Osorno',14),
    (47,'Llanquihue',14),
    (48,'Chiloé',14),
    (49,'Palena',14),
    (50,'Coyhaique',15),
    (50,'Coyhaique',15),
    (51,'Aysén',15),
    (52,'General Carrera',15),
    (52,'General Carrera',15),
    (53,'Capitán Prat',15),
    (54,'Última Esperanza',16),
    (55,'Magallanes',16),
    (56,'Tierra del Fuego',16),
    (55,'Magallanes',16),
    (56,'Tierra del Fuego',16),
    (57,'Antártica Chilena',16);


  7. @Raulebc Raulebc created this gist Feb 20, 2019.
    466 changes: 466 additions & 0 deletions MySQL:regiones-provincias-comunas-chile.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,466 @@
    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');