Skip to content

PCT/LCWIP data ingest 2026 (England)

Latest

Choose a tag to compare

@Robinlovelace Robinlovelace released this 21 Jul 00:49

2026 re-run of the PCT/LCWIP evidence collection (England proof-of-concept).

Key findings

  • 117 documents discovered (90 seeds from existing 94-entry DB + 27 new England LCWIPs/related docs)
  • 107 downloaded and extracted; 111 unique merged records (2026 + existing 94, deduped)
  • 77 documents mention the Propensity to Cycle Tool (69% of those with content)
  • doc_type distinction: 85 LCWIP, 10 LCWIP-related, 1 other
  • PCT scenarios referenced: Go Dutch (29), Government Target (20), E-bike (13), Go Cambridge (2)
  • £11.7bn stated investment, 6,852 km stated network length

Extraction engine

Local Ollama (gemma4-12b-hermes) — fully reproducible, no paid API credits required.
Engine selection journey documented in 2026-notes.md.

Contents

  • data-govuk-2026-raw.zip — 112 raw PDF/HTML files
  • data-govuk-2026-md.zip — 118 markdown text extracts
  • results.json — 111 merged records (2026 schema)
  • results.csv — flat table
  • results_2026_only.json — 2026 extraction only
  • 2026-analysis.md — exploratory data analysis (rendered to gfm)
  • 2026-notes.md — engine notes, limits, decisions
  • schema_2026.json — extended 21-field extraction schema