PENDING: Epic: Master data wilayah administratif Indonesia dari cahyadsn/wilayah #654

Context

AWCMS-Mini needs reusable Indonesia administrative region master data for derived applications. This epic introduces idn_admin_regions as a base/reference module using the public cahyadsn/wilayah repository as a third-party packaged dataset source.

Source

• Repository: https://github.com/cahyadsn/wilayah
• Source folder: https://github.com/cahyadsn/wilayah/tree/master/db
• License: MIT
• Upstream dataset statement: Kode dan Data Wilayah Administrasi Pemerintahan dan Kode Pulau Indonesia sesuai Kepmendagri No. 300.2.2-2430 Tahun 2025.

Objective

Provide versioned, validated, auditable, and reusable Indonesia administrative region master data in AWCMS-Mini.

Scope

• Add idn_admin_regions module.
• Vendor selected source files from cahyadsn/wilayah/tree/master/db.
• Preserve MIT license and attribution.
• Add source provenance metadata.
• Normalize SQL dataset into PostgreSQL-friendly AWCMS-Mini tables.
• Add validation gate for committed dataset files.
• Add read-only lookup API.
• Add admin UI for browsing datasets and validation status.

Out of scope

• Scraping Kemendagri websites.
• Claiming the vendored dataset is a direct official Kemendagri export.
• Replacing official Kemendagri legal references.
• Storing personal data.
• Adding boundary polygons or geospatial shapes in MVP.
• Building new auth, tenant, audit, or sync systems.

Compliance note

The upstream repository is MIT licensed. AWCMS-Mini must include upstream copyright and license notice, preserve source URL and imported commit SHA, and clearly label the dataset as a third-party packaged dataset.

Proposed implementation issues

• Scaffold idn_admin_regions module.
• Vendor source metadata and license.
• Add versioned PostgreSQL schema.
• Add SQL parser and normalizer.
• Add repository validation gate.
• Add PostgreSQL import pipeline.
• Add activation, rollback, and diff.
• Add read-only lookup API.
• Add admin UI.
• Add SOP, docs, and security review.

Acceptance criteria

• All child issues are created and linked to this epic.
• Implementation preserves AWCMS-Mini modular architecture.
• Dataset provenance, license, commit SHA, checksums, and validation status are documented.
• No personal data, secrets, or uncontrolled official login exports are committed.
• OpenAPI, tests, docs, and security notes are updated before completion.