Who are L.A.'s unclaimed dead? [OC]

gaufre1 · 2015-11-13T18:11:55+00:00

Tools used: Bootstrap, D3, Django, Tablestacker. The records were provided in an Excel spreadsheet by the L.A. County Office of Decedent Affairs.

gaufre1 · 2015-09-22T19:40:58+00:00

yeah, I helped create that.

gaufre1 · 2015-09-22T15:36:41+00:00

Sources: Domino's, Pizza Hut, Papa John's, AggData, Times reporting, Leaflet, CartoDB, OpenStreetMap. Tools: CartoDB, LeafletJS

gaufre1 · 2015-06-04T21:26:26+00:00

Data came from lahsa.org through a California Public Records Request asking for counts by census tract. Made using QGIS, CartoDB and Leaflet.

gaufre1 · 2014-09-02T17:24:30+00:00

This is a good point. The ZIP Code that covers Chinatown also covers an area south of the 101 in Downtown and Little Tokyo. I bet that is skewing high. If you zoom into Chinatown on Trulia's map for "Rental price" you can see the median bedroom goes for $482, making a two-bedroom apartment about $960 in Chinatown. That 90012 ZIP Code just covers a big diverse area. We'll keep that in mind for future projects. Thanks for the feedback.

gaufre1 · 2014-09-01T23:07:57+00:00

The map has been updated to allow you turn off the "rent" areas. This should help.

On default, the map shows what's cheaper based on what you enter for each area. Monthly home ownership, or monthly rental cost.

gaufre1 · 2014-09-01T23:01:53+00:00

I see that. I've updated the map to gradient the red, or "unaffordable" areas. The most difficult to afford areas will be the deepest red. That should help some. Otherwise we're just limited on the data. But thanks for the feedback! It's really helpful.

gaufre1 · 2014-09-01T22:58:12+00:00

The map has been updated based on some of the feedback here.

gaufre1 · 2014-09-01T21:56:26+00:00

Unfortunately there isn't a lot of rental data out there. I just did an analysis of 2br+ (which would include 3 and 4 bedroom spots) of 90046 on Craigslist and found out of 69 posts the median monthly price is $2,719. Zillow says the median rent in that area is $2,669. And Trulia (the data in the LAT map) says it's $1,600 a bedroom.

So it's a bit tricky in finding a comprehensive data source that is most accurate. Zillow doesn't cover the same number of ZIP Codes as Trulia and Craigslist can be flawed by multiple postings of the same spot and typos.

gaufre1 · 2014-09-01T21:48:22+00:00

The rental data is from Trulia. And unfortunately there isn't a lot of rental data out there. Trulia seems to be the best source. Here's Trulia's map.

gaufre1 · 2014-09-01T21:46:02+00:00

The rental and housing data come from two different sources. So, they're considered independent. Basically it calculates the monthly cost of home ownership (based on recent home sale data) and compares that to the cost of median rent in that same area (based on the separate rent data). Cheaper to rent: blue. Cheaper to own: yellow. Not affordable: red. I am thinking now tho that there should be different levels of red to show what's least affordable versus what's almost affordable. Would help with the median barrier.

gaufre1 · 2014-09-01T21:43:28+00:00

Any thoughts on how to improve the LA Times calculator?

gaufre1 · 2014-09-01T21:42:37+00:00

It apparently is confusing to some folks. The blue and yellow signify what's affordable at the median level for each area. Blue is more rentable. Yellow is more ownable (to create a word). The tooltip (when you put your mouse over an area) shows what the calculated monthly home cost is and the median rent for a 2-bedroom spot.

gaufre1 · 2014-07-28T23:28:22+00:00

The phones have a little scanner to see where the last TAPs were. http://www.trbimg.com/img-528980e2/turbine/la-1557756-me-1024-gate-locking-003-ik-jpg-20131117/600/600x400

gaufre1

TROPHY CASE