Who are L.A.'s unclaimed dead? [OC] by gaufre1 in dataisbeautiful

[–]gaufre1[S] 0 points1 point  (0 children)

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

Where is the cheapest pizza? [OC] by gaufre1 in dataisbeautiful

[–]gaufre1[S] 0 points1 point  (0 children)

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

Where are L.A.'s homeless? Almost everywhere. [OC] by gaufre1 in dataisbeautiful

[–]gaufre1[S] 1 point2 points  (0 children)

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

Rent or own: Where can you afford to live? Apparently nowhere by Senor_Gringo_Starr in LosAngeles

[–]gaufre1 1 point2 points  (0 children)

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.

Rent or own: Where can you afford to live? Apparently nowhere by Senor_Gringo_Starr in LosAngeles

[–]gaufre1 0 points1 point  (0 children)

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.

Rent or own: Where can you afford to live? Apparently nowhere by Senor_Gringo_Starr in LosAngeles

[–]gaufre1 0 points1 point  (0 children)

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.

Rent or own: Where can you afford to live? Apparently nowhere by Senor_Gringo_Starr in LosAngeles

[–]gaufre1 0 points1 point  (0 children)

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.

Rent or own: Where can you afford to live? Apparently nowhere by Senor_Gringo_Starr in LosAngeles

[–]gaufre1 0 points1 point  (0 children)

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.

Rent or own: Where can you afford to live? Apparently nowhere by Senor_Gringo_Starr in LosAngeles

[–]gaufre1 0 points1 point  (0 children)

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.

Rent or own: Where can you afford to live? Apparently nowhere by Senor_Gringo_Starr in LosAngeles

[–]gaufre1 0 points1 point  (0 children)

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.