Programming & Development / April 12, 2025

Enum Representation of Regions in Trinidad and Tobago and SQL Table for Storing Administrative Data

Enum Trinidad and Tobago Regions Java SQL Port of Spain Tobago Municipal Corporations Administrative Division Region Code Caribbean

✅ Enum Representation in Java

Trinidad and Tobago is divided into 15 regional administrative areas, consisting of:

  • 9 regions
  • 2 cities
  • 3 boroughs
  • 1 ward (Tobago House of Assembly)

Here’s the Java enum representing all of them, with standard region codes:

java

public enum TrinidadAndTobagoRegion {
    ARIMA("ARI"),         // Borough
    CHAGUANAS("CHA"),     // Borough
    COUVA_TABAQUITE_TALPARO("CTT"),
    DIEGO_MARTIN("DM"),
    MAYARO_RIO_CLARO("MRC"),
    PENAL_DEBE("PD"),
    POINT_FORTIN("PF"),   // Borough
    PORT_OF_SPAIN("POS"), // City
    PRINCES_TOWN("PT"),
    SAN_FERNANDO("SF"),   // City
    SAN_JUAN_LAVENTILLE("SJL"),
    SANGRE_GRANDE("SG"),
    SIPARIA("SIP"),
    TOBAGO("TOB"),        // Tobago House of Assembly
    TUNAPUNA_PIARCO("TP");

    private final String code;

    TrinidadAndTobagoRegion(String code) {
        this.code = code;
    }

    public String getCode() {
        return this.code;
    }
}

✅ SQL Representation for Trinidad and Tobago's Administrative Areas

Here’s a SQL schema and insert statements for all 15 divisions:

sql

-- Table for Trinidad and Tobago administrative areas
CREATE TABLE trinidad_tobago_regions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    code VARCHAR(5) NOT NULL
);

-- Insert regional corporations, boroughs, cities, and Tobago
INSERT INTO trinidad_tobago_regions (name, code) VALUES
('Arima', 'ARI'),
('Chaguanas', 'CHA'),
('Couva–Tabaquite–Talparo', 'CTT'),
('Diego Martin', 'DM'),
('Mayaro–Rio Claro', 'MRC'),
('Penal–Debe', 'PD'),
('Point Fortin', 'PF'),
('Port of Spain', 'POS'),
('Princes Town', 'PT'),
('San Fernando', 'SF'),
('San Juan–Laventille', 'SJL'),
('Sangre Grande', 'SG'),
('Siparia', 'SIP'),
('Tobago', 'TOB'),
('Tunapuna–Piarco', 'TP');

This enum and SQL setup is ideal for applications handling local governance, public records, GIS systems, or demographic analytics in Trinidad and Tobago.



Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex