Nexa Intelligence Docs
Dashboard

Regulatory Intelligence

Spesifikasi teknis, fungsi operasional, dan pemetaan database PostgreSQL, indeks Elasticsearch, dan topik Kafka untuk modul Regulatory Intelligence.

Regulasi

Kelompok menu Regulasi memfasilitasi pemantauan produk perundang-undangan nasional, evaluasi otomatis potensi tumpang tindih regulasi (Regulatory Conflict & Overlap), penelusuran amar putusan peradilan, serta pencarian data Tempat Pemungutan Suara (TPS).


1. Tabel Pemetaan Database & Event Pipeline

Komponen / Menu UIPostgreSQL (Tabel & Kolom Kunci)Elasticsearch (Indeks & Field Kunci)Kafka (Topik & Arah)
Regulatory Intelligence (/dashboard/regulasi)static_datasets (id, file_sha256, dataset_kind = 'regulasi', status)
static_dataset_records (dataset_id, raw_payload->nomor_uu, raw_payload->tentang, raw_payload->tahun, raw_payload->status_keberlakuan)
master_sectors (id, sector_name)
regulations (regulation_id, title, category, year, content_text, pasal_list, status_hukum, related_sectors)queue-regulation-ingest
queue-regulation-ai
(NLP Harmonizer)
Judicial Intelligence (/dashboard/judicial)static_datasets (id, file_sha256, dataset_kind = 'judicial')
static_dataset_records (dataset_id, raw_payload->nomor_perkara, raw_payload->lembaga_peradilan, raw_payload->amar_putusan, raw_payload->terdakwa, raw_payload->pidana_penjara)
judicial_records (case_number, court_name, case_type, verdict_summary, punishment_years, defendant_names, verdict_date)queue-judicial-raw
queue-judicial-nlp
(Court Ingest)
Electoral TPS Lookup (/dashboard/tps-lookup)master_regions (id, region_name, region_level, parent_id)
static_datasets (id, dataset_kind = 'tps_dpt')
static_dataset_records (dataset_id, region_id, raw_payload->nomor_tps, raw_payload->dpt_pria, raw_payload->dpt_wanita, raw_payload->alamat_tps)
tps_directory (tps_id, province_name, city_name, district_name, village_name, tps_number, dpt_total, geo_point)queue-tps-sync
(KPU Ingestion)

2. Rincian Endpoint & Alur Data Per Komponen

Regulatory Intelligence (/dashboard/regulasi)

  • Fungsi UI: Direktori produk hukum perundang-undangan (UU, Perppu, PP, Perpres, Permen), analisis konflik antarpasal via semantic embeddings, dan status pencabutan/perubahan.
  • Endpoint: GET /api/v1/regulations, GET /api/v1/regulations/{id}, GET /api/v1/regulations/{id}/harmonies.
  • Database: PostgreSQL tabel static_dataset_records menyimpan JSON naskah lengkap per pasal; Elasticsearch indeks regulations melayani pencarian frasa hukum instan.

Judicial Intelligence (/dashboard/judicial)

  • Fungsi UI: Penelusuran perkara Tipikor, Perdata, Pidana Umum dari Direktori Putusan Mahkamah Agung, statistik rata-rata vonis hukuman, dan profil terdakwa.
  • Endpoint: GET /api/v1/judicial/cases, GET /api/v1/judicial/cases/{id}.
  • Database: PostgreSQL static_dataset_records menyimpan struktur amar putusan; Elasticsearch indeks judicial_records mendukung pencarian nama pihak dan pasal dakwaan.

Electoral TPS Lookup (/dashboard/tps-lookup)

  • Fungsi UI: Pencarian instan 820.000+ titik TPS nasional, jumlah DPT per TPS, dan drill-down administratif dari Provinsi hingga Desa/Kelurahan.
  • Endpoint: GET /api/v1/tps-lookup, GET /api/v1/tps-lookup/regions.
  • Database: PostgreSQL master_regions memetakan batas administrasi; Elasticsearch tps_directory melayani pencarian autocomplete dengan response time < 50ms.

On this page