🇲🇹 Java Enum: Malta’s Local Councils (Selected)
Malta is divided into 68 local councils, each assigned an ISO 3166-2:MT code. Below is a representative selection (you can expand it as needed):
java
public enum MaltaLocalCouncil {
ATTARD("MT-01"),
BALZAN("MT-02"),
BIRKIRKARA("MT-03"),
BIRZEBBUGA("MT-04"),
BORMLA("MT-05"),
DINGLI("MT-06"),
FLORIANA("MT-07"),
FGURA("MT-08"),
GZIRA("MT-09"),
GHARGHUR("MT-10"),
GOZO("MT-GO"), // Gozo as a general region
HAMRUN("MT-11"),
LUQA("MT-18"),
MARSASKALA("MT-20"),
MOSTA("MT-23"),
MSIDA("MT-24"),
NAXXAR("MT-27"),
PAOLA("MT-28"),
QORMI("MT-29"),
RABAT("MT-30"),
SAN_GWANN("MT-35"),
SLIEMA("MT-38"),
ST_JULIANS("MT-39"),
VICTORIA("MT-45"),
VALLETTA("MT-44"),
ZABBAR("MT-46"),
ZEBBUG("MT-48");
private final String code;
MaltaLocalCouncil(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE malta_local_councils (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO malta_local_councils (name, code) VALUES
('Attard', 'MT-01'),
('Balzan', 'MT-02'),
('Birkirkara', 'MT-03'),
('Birzebbuga', 'MT-04'),
('Bormla', 'MT-05'),
('Dingli', 'MT-06'),
('Floriana', 'MT-07'),
('Fgura', 'MT-08'),
('Gzira', 'MT-09'),
('Gharghur', 'MT-10'),
('Gozo', 'MT-GO'),
('Hamrun', 'MT-11'),
('Luqa', 'MT-18'),
('Marsaskala', 'MT-20'),
('Mosta', 'MT-23'),
('Msida', 'MT-24'),
('Naxxar', 'MT-27'),
('Paola', 'MT-28'),
('Qormi', 'MT-29'),
('Rabat', 'MT-30'),
('San Gwann', 'MT-35'),
('Sliema', 'MT-38'),
('St. Julian\'s', 'MT-39'),
('Victoria', 'MT-45'),
('Valletta', 'MT-44'),
('Zabbar', 'MT-46'),
('Zebbug', 'MT-48');
✅ Summary
This setup includes a subset of Malta’s local councils with their ISO codes, perfect for use in Java applications and SQL databases. You can expand the list to include all 68 councils as needed.