My wife and I have two young kids so we wanted to optimize our property search for:
- Homes in our price range
- With good schools nearby
- That are not too far from the office
I made a few small tools to help us do that, and I’m sharing them here for any other parents or families new to the area who may have similar questions.
Context and Caveats
Previously finding where to live was a fairly straightforward in my case: my job would link me to a given city and I’d find an affordable apartment near the best coffee shops (which, anecdotally, tended to be a leading indicator of trendy neighborhoods). Now that we have a couple of miniature humans depending on us, we found ourselves with different criteria. We wanted to prioritize quality of local schools, access to good daycares and playgrounds. We wanted more space than our old studio apartments and ideally more green space. And as we looked for these things, we had to consider locations that were further away, trading off against our commute time to work! Lastly, it has become more important for us to get this decision right since the cost of change is now higher. Uprooting and changing locations will now also involve kids changing schools, potentially losing friends and local familiarity and so on. So I nerded out on some data to help us figure this out.
While there is an abundance of websites/apps/tools for finding homes, most of these work well after you know which neighborhood/area you care about. But our use case was different: we were happy to vary the location, and consider unusual/unpopular locations, to find the location that met our criteria.
This is not intended to be an exhaustive analysis. These maps are a subset of all our research and were most valuable right at the beginning of our process. They were intended to help us get our bearings on the Bay Area and identify locations we may not have known to consider in our search.
This will likely not work well for people with color vision deficiency, sorry. I can go back and adjust colors to something more universal if this becomes a serious issue.
This is a heat map of home prices in the Bay Area. Move the slider to set your budget. The cost of an area is generated by the average sale price of a home in that area:
- Pink: average price is beyond your budget
- Red: high end of your budget
- Green: easily affordable
This lets you know where you could afford on your ideal budget, and how that would change if you stretch your budget.
- Home Prices are from Zillow Research and use the Zillow Home Value Index (ZHVI) for single family and condo properties which represents the typical value for homes in the 35th to 65th percentile range. Dataset.
- Zip boundaries from Open Data Delaware. Dataset.
- This is ZIP code level because neighbourhood boundary data doesn’t seem to be freely available. Zip boundaries are heavily compressed (simplified to ~2%) using mapshaper.org to reduce data size which distorts the shapes slightly.
This map distinguishes areas based on school quality. It identifies areas with decent public and public-charter schools, while also distinguishing areas with almost entirely lower-quality public schools (that suggests private schools may be necessary if you live there).
(A note on colors: Distinguishable colors are necessary for this view, but also using a single score to represent a school quality is obviously imperfect and fallible, so this is intended to only be coarsely illustrative).
- Green = GreatSchools score 7 and higher
- Yellow = 6
- Orange = 5
- Red = 4 and lower
- School data is based on GreatSchools.org. The score reflects the single aggregate score for that school. Here you can read about GS scoring methodology. GreatSchools has more detailed metrics for each school, and clicking the link in the popup on any school marker will take you to the GreatSchools page to read more. Dataset not publicly available (thanks to GreatSchools team for letting me use their API and data for this non-commercial use).
- This does not include Private or Private-Charter schools, as I couldn’t find a dataset scoring these schools.
- Another tool you may want to look at is Stanford University’s Educational Opportunity Project, which visualizes test scores and learning rates across the whole country and is far more comprehensive than this.
This table shows the commute times to a some of the main tech hubs in the area. It also shows how much the commute time will vary if you leave earlier/later.
Change the Home Location to yours, and the table will update with commute times. Change the morning and evening departure times in the dropdowns to see how much your commute changes by leaving earlier/later.
510 Townsend St, San Francisco
2100 Franklin St, Oakland
1 Hacker Way, Menlo Park
156 University Ave, Palo Alto
1600 Amphitheatre Pkwy, Mountain View
1 Infinite Loop, Cupertino
Change Home Location
- This uses Google Maps Directions API to calculate the driving time with traffic between these points. It calculates for Monday next week, assuming usual traffic for that time.
- Per their terms I should also include this…
- Because I have to pay per API request after a limited free volume, I’ve limited it to a few of the common work locations and you can only adjust the home location.
- This is admittedly very incomplete, and obviously doesn’t consider things like public transport, cycling, flights. I think much more could be done here but as a v1, it helps give a quick general view and let’s see what’s most needed from here.
My wife is terrified of earthquakes, and we wanted to understand if some locations were better or worse than others. This is a simplified visualization that shows the fault lines and where the epicenters of magnitude 5+ quakes have historically occurred.
The thickness of the line represents the slip rate of the faults (how much it moves each year, which correlates with earthquake frequency). The circles are the historic quakes, fainter circles were longer ago, colored by magnitude on Richter scale.
- Red = Magnitude 7 and higher
- Orange = 6
- Yellow = 5 (less than 5 not shown)
- This uses the publicly available seismic hazard data from California Department of Conservation’s APIs
- This visualization is really simplified. To consider the seismic risk of an area, you’ll want to consider the shake velocity of the ground (here), the landslide risk (here), and the liquefaction risk (here).
- A good 1-page (42MB PDF) overview of the risk is here: Branum, D. et al. Earthquake Shaking Potential for California, 2016. California Geological Survey and USGS (MS_48)
Let me know what you think
I’m curious if other people also find these helpful or are working on anything more comprehensive.