r/civictech

I made a searchable database of public lead service line inventory records

I built a free site that aggregates public lead service line inventory records from across the US into one searchable place:

https://leadserviceline.org/

You can search by address, water system, city, or state. The source data is public, but it is often scattered across state, city, utility, spreadsheet, and PDF sources.

Important caveat: this is not a water test and it is not a replacement for checking with a local utility. The records are only as good as the public inventories they come from, so they can be incomplete, outdated, or wrong.

If there is demand, I may add an API so people can pull the data directly.

reddit.com
u/maximooth — 2 days ago

GovTech Prospect/CRM Database Buildout

Software investor who is on the board of a few GovTech companies($5m-$40m of ARR) selling into local cities and municipalities (<50k population).

I continue to question if we are doing our best at building and maintaining a clean prospect database for our CRM.

We lean on census data + web scraping to pull department-level contacts (clerks, public works, finance, IT, etc.) and it seems to get us 70-80% there but the janitorial work is intermittent so worth we are working stale data.

Curious what’s working for folks here:

  • Any go-to databases (paid or free) for muni contacts and org charts?
  • Workflows for keeping data fresh as people change roles?
  • Sources that are easy to overlook - associations, conferences, FOIA-style pulls, state-level directories?

Happy to share back anything useful that surfaces. Hoping responses will help me + the other entrepreneurs here building their companies. Thanks in advance.

reddit.com
u/PieLearnings — 3 days ago
▲ 241 r/civictech+7 crossposts

If you could choose: Civic TypeR or Mugen?

Honda Civic Si Mugen

r/Honda

u/Cris_1984 — 7 days ago
▲ 44 r/civictech+2 crossposts

[OC] In the last 90 days, 144/435 House members and 59/100 U.S. senators have mentioned "gas prices" in a press release — interactive archive of every release from all 535 members of Congress

I'm a journalist turned web developer with 15+ years in reporting. I built Capitol Releases — an interactive archive of every press release from every U.S. senator and representative since January 2025. 85,242 records across all 535 members, updated four times a day from each member's official .gov site.

The chamber view (slides 1 & 2) shows every member colored by party. Pick any search term and the chamber re-colors by who's mentioned it. Both slides here show "gas prices" as a matched pair — same term, both chambers, last 90 days:

Senate: 59 of 100 senators mentioned gas prices (Schiff leads with 16)

House: 144 of 435 voting members mentioned gas prices (Jeffries leads with 31)

Try other terms and the numbers shift hard. In the last 90 days:

Trump — 99 of 100 senators, 380 of 435 House members

Iran — 86 of 100 senators, 268 of 435 House members

Tariffs — 63 of 100 senators, 164 of 435 House members

Ukraine — 43 of 100 senators, only 39 of 435 House members

The trending view (slide 3) ranks every word stem in release titles by 30-day count and shows a weekly time series across all members — pick any combination of terms and compare them over time.

Member detail (slide 4): each member gets a page with release cadence as a calendar heatmap, what they're talking about lately with week-over-week word deltas, and "topics they own" — words they use disproportionately compared to peers.

Go to capitolreleases.com and search any term yourself — your representative's name, your district's issue, anything that's been in a press release since January 2025. Also in there: a daily AI-generated brief, deletion detection (tombstones for anything pulled from a member's site after publication), Congressional Record floor speeches, and a feed of 44 verified senate Bluesky accounts.

Site: capitolreleases.com

Github: github.com/tbrown034/capitol-releases

Source: Each member's official .gov press page (e.g. durbin.senate.gov/news, jeffries.house.gov/media), collected via scraping and updated daily via GitHub Actions

Tools: Python (httpx, BeautifulSoup, Playwright), PostgreSQL (Neon), Next.js 16, React 19, Tailwind 4, D3, TypeScript. Claude Haiku 4.5 for post-collection quality checks (advisory, not editorial).

u/trevorthewebdev — 8 days ago
▲ 431 r/civictech+3 crossposts

CM Siddaramaiah just approved 11 elevated corridors covering 75.6 km across Bengaluru. ₹13,262 crore. why it's going to be a disaster

Adding more roads leads to more vehicles — this is the most basic common sense our policy makers fail to understand.

Bengaluru has beefed up infrastructure with the Outer Ring Road, elevated flyovers, double deckers, metro and more flyovers — and still the traffic issue is persistent and ever increasing.

What happened to Silk Board? The signal just got shifted to Ragigudda. That's it. That's the fix.

Hosur Road has every kind of connectivity imaginable — and still traffic is always at peak. Always.

Traffic can only be solved by encouraging people to use more public transit. Slash prices. Increase frequency. Build more pathways and public infrastructure.

Instead the government completely fails to do any of this — they collect taxes and put civilians into never ending problems.

What are we paying for? Whom are we paying?

Look at South Korea. Seoul demolished a 6-lane elevated highway and replaced it with a walkway and stream. To everyone's surprise — property prices went up, traffic reduced by 15%. Less road. Less traffic. Better city.

We are doing the exact opposite.

We built pathwatch.in to make Indian cities commutable — starting with Bengaluru as a case study.

let me know your thoughts.

u/uncanny_narrator786 — 11 days ago
▲ 6 r/civictech+1 crossposts

Background: I've been thinking about this for a while, and came up with a proposal for a participatory parallel governance platform including an incentive layer.

I honestly believe this (or something similar) is a really good and relatively easy shot at solving a lot of our problems, starting from reducing political apathy, increasing community cohesion to solving AI alignment & global BioSec threats.

However - While I have been able to get a few people to look into it a bit more, and did receive good feedback from them - most others that I show this to just seem to glance at it and discard the idea (or don't even look at it at all. I don't know, as most of this communication is online async).
This makes me think that either I'm living in my bubble and this proposal isn't good, there are some fundamental flaws that I can't see, etc...
Or I'm just promoting it wrong, writing about it wrong, don't make it accessible enough, ...

Before I go and build a nice explainer website or prototype etc to try to get more interest, I wanted to check with this community to critique it and tell me why this legitimately might not work (kind of like CMV). Or where else the flaws are (better writing, explanations, etc).

Note that the document has multiple tabs, each one offering an increasingly detailed explanation.

Appreciate all honest feedback 🙏

u/derjogi83 — 8 days ago