🇪🇨 Java Enum: Ecuador’s Provinces
Ecuador is divided into 24 provinces, each with its own ISO 3166-2:EC code. Here's the Java enum:
java
public enum EcuadorProvince {
AZUAY("EC-A"),
BOLIVAR("EC-B"),
CAÑAR("EC-U"),
CARCHI("EC-C"),
CHIMBORAZO("EC-H"),
COTOPAXI("EC-X"),
EL_ORO("EC-O"),
ESMERALDAS("EC-E"),
GALAPAGOS("EC-W"),
GUAYAS("EC-G"),
IMBABURA("EC-I"),
LOJA("EC-L"),
LOS_RIOS("EC-R"),
MANABI("EC-M"),
MORONA_SANTIAGO("EC-S"),
NAPO("EC-N"),
ORELLANA("EC-D"),
PASTAZA("EC-Y"),
PICHINCHA("EC-P"),
SANTA_ELENA("EC-SE"),
SANTO_DOMINGO_DE_LOS_TSACHILAS("EC-SD"),
SUCUMBIOS("EC-U"),
TUNGURAHUA("EC-T"),
ZAMORA_CHINCHIPE("EC-Z");
private final String code;
EcuadorProvince(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
📝 Note: Ecuador's ISO codes follow the pattern EC-<Letter(s)>, though some provinces like Santa Elena (SE) and Santo Domingo de los Tsáchilas (SD) use two-letter codes.
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE ecuador_provinces (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO ecuador_provinces (name, code) VALUES
('Azuay', 'EC-A'),
('Bolívar', 'EC-B'),
('Cañar', 'EC-U'),
('Carchi', 'EC-C'),
('Chimborazo', 'EC-H'),
('Cotopaxi', 'EC-X'),
('El Oro', 'EC-O'),
('Esmeraldas', 'EC-E'),
('Galápagos', 'EC-W'),
('Guayas', 'EC-G'),
('Imbabura', 'EC-I'),
('Loja', 'EC-L'),
('Los Ríos', 'EC-R'),
('Manabí', 'EC-M'),
('Morona Santiago', 'EC-S'),
('Napo', 'EC-N'),
('Orellana', 'EC-D'),
('Pastaza', 'EC-Y'),
('Pichincha', 'EC-P'),
('Santa Elena', 'EC-SE'),
('Santo Domingo de los Tsáchilas', 'EC-SD'),
('Sucumbíos', 'EC-U'),
('Tungurahua', 'EC-T'),
('Zamora Chinchipe', 'EC-Z');
✅ Summary
This setup provides full support for all 24 provinces of Ecuador, with both a clean Java enum and SQL INSERT statements, following ISO 3166-2:EC standard codes.