story

Visualizing Safety in Palo Alto: Police Log Mapper for House Hunting (opens in new tab)

sourya.co

4 pointssourya41y ago5 comments

5 comments

Built a tool to help my family find a safe neighborhood while moving to Palo Alto. It scrapes daily police reports (PDFs), extracts locations, plots events on Google Maps, and helped us finalize a place.

Try it at: https://palo-alto-police-log-visualizer.vercel.app/

billconan1y ago

do you see the crime rate drop in the Bay area?

sourya4OP1y ago

honestly, i don't have a good baseline to really say.

i spent 1 month in SF recently and it was kind of similar to NYC tbh. mostly safe but you gotta watch out during late nights in some areas.

i could be ignorant here since i am pretty new to the bay. wdyt?

chw9e1y ago

How good were LLMs at building code that uses LLMs? This used to be a pain in previous versions because the LLM didn't have any LLM-using code in its training data. And what was the rough breakdown of LLM usage in coding? (looking for something like 20% claude code, 30% gemini 2.5, the rest manual)

sourya4OP1y ago

Great questions! gemin-2.5-pro was pretty good in writing code that uses 3.7-sonnet! It drafted all the prompts and the pipeline.

You kind of called it. I had to tweak some minor SDK use details by sharing it the latest documentation docs in the second go.

I would say 30% Claude Code, 65% Cursor (gemini-2.5-pro), 5% manual.

j / k navigate · click thread line to collapse

5 comments

sourya4OP1y ago

Try it at: https://palo-alto-police-log-visualizer.vercel.app/

billconan1y ago

do you see the crime rate drop in the Bay area?

sourya4OP1y ago

honestly, i don't have a good baseline to really say.

i spent 1 month in SF recently and it was kind of similar to NYC tbh. mostly safe but you gotta watch out during late nights in some areas.

i could be ignorant here since i am pretty new to the bay. wdyt?

chw9e1y ago

sourya4OP1y ago

Great questions! gemin-2.5-pro was pretty good in writing code that uses 3.7-sonnet! It drafted all the prompts and the pipeline.

You kind of called it. I had to tweak some minor SDK use details by sharing it the latest documentation docs in the second go.

I would say 30% Claude Code, 65% Cursor (gemini-2.5-pro), 5% manual.

j / k navigate · click thread line to collapse