[data] sfddata: data from the SFD project on nearly 300 cities  #12

Activity

1. larnsce commented on Jul 18, 2026

   

   larnsce

   on Jul 18, 2026 – with Claude

   ContributorAuthor

   More actions

   Package repository created: https://github.com/openwashdata/shitflowdiagram

   Key starting info:

   Source

   • SFD portal: https://sfd.susana.org/about/sfd-data — data on nearly 300 city-level shit-flow diagrams, available as JSON (machine-readable, no PDF extraction needed)
   • Maintained by the SuSanA / SFD Promotion Initiative

   First tasks

   • Confirm license / permission to republish with SuSanA-SFD (main open question — data access itself is not a blocker)
   • Explore the JSON structure: what does one city record contain (SFD graph percentages, service delivery context, report level/quality)?
   • Write download + tidy script (JSON → tidy dataframes; likely one table for SFD outcome variables per city, one for metadata)
   • Set up the standard openwashdata package structure with washr (DESCRIPTION, data-raw/, dictionary, README, pkgdown site)
   • Decide refresh strategy: the portal adds/updates city reports over time — a re-runnable data-raw script (or scheduled GitHub Actions, as in unhcrwash) would keep the package current

   This is one of the better-bounded items in the tracker (see #59): tidy-friendly source format, clear scope, high reuse value for teaching and research.

   ---

   Generated by Claude Code