de:wasserversorger-enrich

Enriched 45 German water suppliers (wv-de-3792…wv-de-3816 range plus VG/Verband entries) — enrichment.jsonl grew 1439→1484, 272 new municipality links, 43/45 got an analysis URL/fallback, 40/45 full contact details, no contact made and no captchas touched. Merged cleanly through the full pipeline (map_roster → consolidate_roster → coverage); population coverage holds at 99.99% (24 residual municipalities, 11,023 people), as expected for an enrich-only pass with 0 new roster companies. Flagged for human follow-up: Stadtwerke Sinzig has merged into "Stadtwerke Rhein-Ahr AöR" (materially larger supply area), and two new TLS-chain host traps (kelsterbach.de, stadtwerke-kronach.de) — details and full open-items list in the journal.

Picked up cleanly where the 00:30 run left off (enrichment.jsonl 1439, roster.jsonl 3375, roster-links.jsonl 17975 — matched the prior entry's reported finish exactly).

Batch build: build_enrich_batch_excl.mjs 45 enrich-20260903-0530 — 1961 pending (excluding 6 standing duplicate-mint pairs), 0 pending_domain (queue still empty). Split 23/22, dispatched to 2 synchronous general-purpose Agent subagents (run_in_background: false, both launched in one message, neither nested further sub-agents). Each wrote its own enrichment.part-shard{A,B}-enrich-20260903-0530.jsonl / roster-links.part-shard{A,B}-… shards.

Verified before merge: 0 malformed JSON across all 4 shard files, both shards' company_id sets matched their dispatched batch files exactly, 0 overlap between shard A and B, 0 overlap with the existing 1439-line enrichment.jsonl.

• Shard A (23): 20/23 full 5-core contact, 21/23 analysis_url (2 genuine misses, both recorded with fallback/notes), 11/23 multi_zone, 79 fetches / 29 searches, 110 municipality links.
• Shard B (22): 20/22 full 5-core contact, 21/22 emergency_phone_number, 19/22 analysis_url (3 without a direct URL still have index_url/notes), 10/22 multi_zone, 85 fetches / 13 searches, 162 municipality links.
• Combined: 45/45 researched, no contact made, no captchas touched, 272 raw municipality links written (37/45 emergency_phone_number, 43/45 analysis_url-or-fallback, 21/45 multi_zone, 164 fetches / 42 searches total).

Merge: enrichment.jsonl 1439 → 1484 lines / 1479 distinct company_id (+45 clean). map_roster.mjs ran clean over all historical shards (18247 raw link rows, 11712 preresolved + 3931 exact_norm + 366 land_scoped + 3 expanded_qualifier matched, 2100 unmatched — usual crop of Ortsteil/composite names, nothing new). consolidate_roster.mjs: 177 shards / 3617 rows, still 3375 distinct companies (no discovery this pass, so unchanged as expected); roster-links.csv 15578 distinct after dedup (+168 net vs the 00:30 run's 15410). coverage.mjs: population 99.99% → 99.99% (unchanged, expected for an enrich-only pass), 24 residual municipalities / 11,023 people, unchanged.

Findings, recorded in enrichment notes, not propagated to roster.jsonl (append-only; needs a future re-key/reconciliation pass):

• wv-de-3800 Stadtwerke Sinzig: stadtwerke-sinzig.de now 302-redirects to stadtwerke-rhein-ahr.de — operator has merged/rebranded into "Stadtwerke Rhein-Ahr AöR", now covering Sinzig + all of VG Bad Breisig + Remagen, materially larger than the row's seeded self_only status. Needs reconciliation against any existing Bad Breisig/Remagen entries.
• wv-de-3804 Wittenberge and wv-de-3807 Hünfeld: both seeded self_only but their own sites publish much larger multi-village supply areas (8 and 13 extra Ortsteile) — roster links expanded accordingly this pass.
• wv-de-827 Wasserversorgung Hoya: own site contradicts the roster's claimed 10-member list — 4 (Eystrup, Hassel, Gandesbergen, Hämelhausen) are explicitly supplied by a different bulk provider (Trinkwasserverband Verden). Links written only for the 6 actually retail-supplied.
• wv-de-3815 Stadtwerke Kronach: general kronach.de Impressum shows no HRB and frames Stadtwerke as part of city administration, contradicting a carried-over HRB 7627 figure — flagged low-confidence; the likely-authoritative stadtwerke-kronach.de hit a new TLS trap (below) before this could be resolved.
• New host issues (not in the known-traps list): kelsterbach.de and stadtwerke-kronach.de have incomplete TLS chains (same class as the existing bodensee-wasserversorgung.de trap) — WebFetch fails cert verification, curl -k works. nordpfaelzerland.de (plain-ASCII alt of xn--nordpflzerland-bib.de) times out on DNS, only the punycode form resolves.
• wv-de-3811 WBV Högling-Bruckmühl: no Impressum page exists anywhere on the site — a genuine legal-disclosure gap, not a guessed-path miss.
• No non-suppliers or roster-defect Verbände found in this batch — all 45 are genuine, currently active drinking-water suppliers with real Trinkwasser content.
• No pdftotext/python3 in this environment again; shard A wrote a small comment-free node+zlib FlateDecode PDF-text extractor at .pdftext.mjs (repo root, not campaign dir) — worked on several PDFs (Forst, Kelheim, Leopoldshöhe, Traben-Trarbach, NUWA), failed on others (VG Nahe-Glan is a genuine scan; Nidda/Finnentrop use an unparsed structure) — recorded as extraction limits, not as "not published".

Still stale: export_csv.mjs still reads the dead legacy companies.jsonl/links.jsonl pair, not roster.jsonl/roster-links.jsonl — skipped again in favor of the live map_roster.mjs → consolidate_roster.mjs → coverage.mjs pipeline, as every recent run has done. Still worth a maintainer fixing rather than each run re-discovering it (7+ consecutive runs now).

For next run: continue with build_enrich_batch_excl.mjs 45. 0 pending_domain. Open human follow-ups (compounding across runs, none touched this pass unless noted): (1) wv-de-20661 Gauting → Würmtal-Zweckverband re-key; (2) wv-de-20662/wv-de-3587 Gilching duplicate; (3) wv-de-3751 Heilbad Heiligenstadt likely non-supplier / EW Wasser GmbH may be the real operator; (4) export_csv.mjs pointed at dead source files; (5) wv-de-16016 Ainring and wv-de-3724 Prenzlau self_only roster flags contradicted by their own sites; (6) wv-de-3763 Oberasbach RangauWerke freshness gap; (7) stadtwerke.freilassing.de HTTP 500 — retry, don't trap yet; (8) wv-de-3800 Sinzig → Stadtwerke Rhein-Ahr AöR merger (new this run); (9) wv-de-3815 Kronach HRB conflict, blocked on the new stadtwerke-kronach.de TLS trap (new this run).