[P1] Investigate SafeNotes data collection for transaction annotations

[Rashmi-278]

Problem

SafeNotes (https://safenotes.xyz/ens) provides detailed ENS working group transaction
tagging — annotations on treasury transactions that label spending categories, recipients,
and purposes. This data is critical for H7 (treasury/resource allocation analysis) but
is NOT currently in the pipeline at all.

Data Source Details

From the internal data sources sheet:

"GitHub Repo isn't public anymore. Worst case, will need to scrape ~90 pages."

• URL: https://safenotes.xyz/ens
• Content: Detailed ENS WG transaction tagging (Ecosystem, Metagov, Public Goods wallets)
• Type: Raw Data Source
• Status: TBD
• Challenge: Original GitHub repo is no longer public

Investigation Needed

1. Check if SafeNotes has an API (check network requests on the site)
2. Assess scraping feasibility (~90 pages of transaction annotations)
3. Determine data schema (tx_hash, category, description, working_group, amount, etc.)
4. Check if WG Spending Reports on the forum duplicate this data
5. Evaluate whether Etherscan data + manual categorization could substitute

If Collection Is Feasible

1. Create infra/ingest/safenotes_scraper.py — web scraping module
2. Add new bronze domain or extend bronze/financial/
3. Create new Dagster asset safenotes_transactions
4. Add DBT source, staging model, and silver model
5. Integrate into treasury_summary gold model

Dependencies

• Blocked by: [P0] Sync local main with remote and verify end-to-end pipeline #7 (sync local main)
• Related: Etherscan ingestion ([P1] Build Etherscan ingestion for on-chain data (delegations, token distribution, treasury flows) #9) — SafeNotes annotations enrich raw treasury data

Priority

P1 — Investigation phase. Actual implementation depends on findings.