Document elements · 01
Six table patterns for technical proposals, statistical reports, and project documents. Hairline borders, tabular numerals in the mono face, uppercase column heads with wide tracking — the same vocabulary as the slide system, translated to the page.
01 — Standard data table · zebra rows · totals row
| Source system | Owner | Ingestion method | Records / day | Latency (min) |
|---|---|---|---|---|
| CPI submissions | STATIN — Prices | NiFi SFTP listener | 14,820 | 5 |
| Customs declarations | Jamaica Customs | NiFi REST poll | 9,610 | 15 |
| Population estimates | STATIN — Demography | Manual upload | 240 | 1,440 |
| Labour force survey | STATIN — Social | NiFi SMTP watcher | 3,400 | 60 |
| Trade statistics | Min. of Industry | JDBC pull · MariaDB | 22,180 | 10 |
| Daily total — all ingestion streams | 50,250 | — | ||
02 — Compact table · status pills
| Pipeline | Last run | Records | Quality | Status |
|---|---|---|---|---|
| cpi-monthly | 2026-05-13 06:00 | 14,820 | 99.4% | OK |
| customs-rest | 2026-05-13 06:15 | 9,610 | 97.1% | Drift |
| lfs-smtp | 2026-05-13 04:00 | 3,400 | 100% | OK |
| trade-jdbc | 2026-05-13 06:30 | 22,180 | 86.2% | Failed |
| pop-manual | 2026-05-09 09:42 | 240 | — | Pending review |
03 — Bordered grid · medallion zone tags
| Bucket | Zone | Retention | Access | Size |
|---|---|---|---|---|
| s3://lake/raw/cpi/ | Raw | 90 days | NiFi service only | 1.4 TB |
| s3://lake/anon/cpi/ | Anonymized | 2 years | Analyst pool | 980 GB |
| s3://lake/staging/cpi/ | Staging | 180 days | Statistician group | 320 GB |
| s3://lake/agg/cpi/ | Aggregated | 10 years | Public dashboards | 48 GB |
| s3://lake/archive/cpi/ | Archive | Indefinite | Veeam only | 6.2 TB |
04 — Comparison table · today vs tomorrow
| Workflow | Today | Tomorrow |
|---|---|---|
| CPI ingestion | Admin downloads CSVs from SFTP, renames files, drops into shared folder. | NiFi listens to SFTP, validates schema, lands in raw bucket — full audit trail. |
| Cross-source query | Export to Excel, vlookup against three workbooks, send to statistician. | Single SELECT in Trino — federates SQL Server, MariaDB, MinIO at once. |
| Quarterly report | Six analysts copy-paste from PDFs; numbers reconciled by hand. | JupyterHub notebook reads the aggregated zone — same numbers every time. |
| Backup | USB drive in director's office. Sometimes. | Veeam versioning over MinIO buckets — point-in-time restore. |
05 — Key / value · document metadata
| Document ID | D4N-STATIN-ARCH-002 |
|---|---|
| Prepared for | Statistical Institute of Jamaica (STATIN) |
| Prepared by | Data4Now · Architecture practice |
| Classification | Internal — client & partner distribution |
| Version | 2.1 · supersedes 2.0 (2026-04-18) |
| Review window | 14 May 2026 — 04 June 2026 |
| Approvers | STATIN CIO · D4N principal architect · UN DESA observer |
06 — Emphasis table · navy fill for hero stats
| Indicator | Baseline 2025 | Year 1 | Year 3 target |
|---|---|---|---|
| Manual data handling — hours/month | 412 | 189 | 110 |
| Federated queries — per week | 0 | 340 | 1,200 |
| Datasets in single source of truth | 3 | 24 | 58 |
| Time to publish quarterly report | 14d | 6d | 2d |