Programming & Development / April 11, 2025

How to Represent Australia’s States and Territories in Java and SQL Using ISO 3166-2 Codes

Australia states Java enum Australia ISO 3166-2 AU SQL Australia regions Australia administrative divisions Spring Boot enum Australian states list AU region codes Australian territories states and territories of Australia

🇦🇺 Java Enum: Australia’s States and Territories

Australia consists of 6 states and 2 territories. Here’s the Java enum using the ISO 3166-2:AU codes.

java

public enum AustraliaStateTerritory {
    NEW_SOUTH_WALES("AU-NSW"),
    QUEENSLAND("AU-QLD"),
    SOUTH_AUSTRALIA("AU-SA"),
    TASMANIA("AU-TAS"),
    VICTORIA("AU-VIC"),
    WESTERN_AUSTRALIA("AU-WA"),
    AUSTRALIAN_CAPITAL_TERRITORY("AU-ACT"),
    NORTHERN_TERRITORY("AU-NT");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

CREATE TABLE australia_states_territories (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code VARCHAR(8) NOT NULL UNIQUE
);

INSERT INTO australia_states_territories (name, code) VALUES
('New South Wales', 'AU-NSW'),
('Queensland', 'AU-QLD'),
('South Australia', 'AU-SA'),
('Tasmania', 'AU-TAS'),
('Victoria', 'AU-VIC'),
('Western Australia', 'AU-WA'),
('Australian Capital Territory', 'AU-ACT'),
('Northern Territory', 'AU-NT');

✅ Summary

This setup covers Australia’s 6 states and 2 territories using ISO 3166-2:AU codes. It’s perfect for managing region-specific data, geolocation, or administrative applications.


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