Data quality
This Internal centre combines reproducible database, relation, chart, link, publication and map evidence. Critical logical checks block publication; operational status cards show the most recently completed run and its UTC time.
Logical integrityPassed19 of 20 checks passed; 1 warnings remain.
Public link auditpassed2026-08-30T19:00:05.707703+00:00
Publicationcomplete2026-10-14T08:43:40.932814+00:00
Station mapscompleteMap gaps remain explicitly listed rather than inferred.
WAMO relationsEvidenceMissing mappings and timestamp anomalies are retained in full.
Automated logical integrity checks
| Check | Status | Observed | Expected | Meaning / action |
|---|---|---|---|---|
| SQLite journal mode | pass | delete | delete | Project policy forbids WAL mode. |
| SQLite quick check | pass |
|
| Verified unchanged database revision; weekly full check. |
| SQLite foreign keys | pass | 0 | 0 | All foreign keys, or a validated unchanged database revision. |
| Unique MPEC numbers | pass | 72954 | 72954 | Every MPEC number must identify one row. |
| Complete MPEC summaries | pass | — | — | Every MPEC needs object and station summaries. Run the database update to repair the listed MPECs; missing summaries must never be published as zero. |
| mpec_station to MPEC | pass | 0 | 0 | Declared SQLite foreign key checked on the validated revision; undeclared relationships are checked by an explicit join. |
| mpec_station to station | pass | 0 | 0 | Declared SQLite foreign key checked on the validated revision; undeclared relationships are checked by an explicit join. |
| occurrence to MPEC | pass | 0 | 0 | Declared SQLite foreign key checked on the validated revision; undeclared relationships are checked by an explicit join. |
| occurrence to station | pass | 0 | 0 | Declared SQLite foreign key checked on the validated revision; undeclared relationships are checked by an explicit join. |
| person relation to person | pass | 0 | 0 | Declared SQLite foreign key checked on the validated revision; undeclared relationships are checked by an explicit join. |
| telescope relation to telescope | pass | 0 | 0 | Declared SQLite foreign key checked on the validated revision; undeclared relationships are checked by an explicit join. |
| Discovery chart count | pass | 45338 | 45338 | Serialized records and displayed statistics must agree. |
| Submission chart count | pass | 44191 | 44191 | Serialized records and displayed statistics must agree. |
| Wamo chart count | pass | 44191 | 44191 | Serialized records and displayed statistics must agree. |
| Delay identity coverage | pass | 0 | 0 | Every matched interval needs its full discovery delay. |
| Delay arithmetic identity | pass | 0 | 0 | Discovery delay must equal submission plus WAMO delay. |
| MPEC list/database count | pass | 72945 | 72945 | The browser list must match the database after documented listing notices are excluded. |
| Station page coverage | pass | — | — | Every database station must have one Stations-by-code page. |
| Obsolete station pages | fail |
| — | Unreferenced station pages are removed by stale-file publication cleanup. Affected page(s): XXX-stat.html. They are absent from the database-backed station directory and therefore excluded from the active public file graph. A successful publication with stale-file cleanup removes any remaining remote copy before release activation. The local file is retained as explicit audit evidence; this check does not silently claim that it was deleted locally. |
| Required generated pages | pass | — | — | Key public and Internal pages must exist. |