🇧🇸 Java Enum: The Bahamas’ Islands and Districts
The Bahamas is divided into 14 administrative districts. Here’s the Java enum using the ISO 3166-2:BS codes.
java
public enum BahamasDistrict {
ABACO("BS-01"),
ACKLINS("BS-02"),
BERRY_ISLANDS("BS-03"),
BIMINI("BS-04"),
BAHAMA_CAYS("BS-05"),
EXUMA("BS-06"),
GRAND_BAHAMA("BS-07"),
LONG_ISLAND("BS-08"),
MAYAGUANA("BS-09"),
NEW_PROVIDENCE("BS-10"),
RAGGED_ISLAND("BS-11"),
SAN_SALVADOR("BS-12"),
ANDROS("BS-13"),
CAT_ISLAND("BS-14");
private final String code;
BahamasDistrict(String code) {
this.code = code;
}
public String getCode() {
return code;
}
}
🗃️ SQL Table and Insert Statements
sql
CREATE TABLE bahamas_districts (
id SERIAL PRIMARY KEY,
name VARCHAR(64) NOT NULL,
code VARCHAR(8) NOT NULL UNIQUE
);
INSERT INTO bahamas_districts (name, code) VALUES
('Abaco', 'BS-01'),
('Acklins', 'BS-02'),
('Berry Islands', 'BS-03'),
('Bimini', 'BS-04'),
('Bahama Cays', 'BS-05'),
('Exuma', 'BS-06'),
('Grand Bahama', 'BS-07'),
('Long Island', 'BS-08'),
('Mayaguana', 'BS-09'),
('New Providence', 'BS-10'),
('Ragged Island', 'BS-11'),
('San Salvador', 'BS-12'),
('Andros', 'BS-13'),
('Cat Island', 'BS-14');
✅ Summary
This setup represents The Bahamas' 14 administrative districts using the ISO 3166-2:BS codes. This structure is ideal for geographical data handling, address validation, or managing location-based operations in your applications.