Art, Maps, Portfolio

Sculpture of Housing Prices Ripping San Francisco Apart

This data sculpture depicts a map of housing prices in San Francisco. It’s a map of the city, torn at the seams. The height of each area represents the average price per square foot for recent home sales. Where neighboring areas are close in value they are connected, but if neighboring areas are too far from each other I allow them to split, tearing the city along its most severe economic divides.

IMG_9454

IMG_9476

IMG_9479

IMG_9474

IMG_9481

Data from Redfin

The data is records of approximately 5,000 recent home sales, downloaded from Redfin. The dataset itself can be downloaded here. The map below shows each sale color coded by the price per square foot.

Screen Shot 2016-07-12 at 11.00.35 AM

I binned the data into hexagons and calculated the average price per square foot for each hexagon region. The map below shows these hexagons colored by and labeled with the price per square foot values for each region. You can start seeing the various relative differences between areas of the city. The lowest prices are in Bayview/Hunters Point in the southeast quadrant of the city, and then prices increase as you move northwest, and then the general trend is that things get more expensive as you get closer to the Marina, Embarcadero, and all areas generally along the northeast. You also see the little island of Noe Valley and the areas around Twin Peaks stand out as more expensive than their neighbors.

Screen Shot 2016-07-12 at 10.59.46 AM

The data was then turned into a 3D model using a slightly modified version of shp2stl. I defined a threshold for how close together neighboring regions need to be to be connected, and any neighboring regions that exceed that delta are allowed to split from each other. That organically produced the spiral pattern through the city.

Screen Shot 2016-07-12 at 8.29.50 AM

animated_sculpture

If you could take a photo from far enough away from straight above you’d see all the pieces line up to form the cohesive outline of the city. Since I don’t have a ladder that tall (or zoom lens that powerful), here are a few images of the model from straight above then rotating to see the breaks start appearing.

top_down

Printing

The model was then printed on a 3D printer (Type A Machines Series 1). It measures approximately 12″ high and took 36 hours to print. The vertical line structure you see below is the support material required for printing that was then removed.

IMG_20160712_080800

IMG_20160712_174248

The Stand

Once I had the sculpture I had to solve the problem of how to keep it from falling over. I ended up printing a base that used the the mesh of the bottom of the sculpture model to form the top of the base. The sculpture fits snugly on top of the base.

IMG_9510

IMG_9511

IMG_9512

Print Your Own

You can download the raw data, the 3D model of the main sculpture, or the 3D model for the stand. Feel free to print your own, or remix the model in any way you like. All images and models are licensed under CC-BY.



Related:

  • I've been working on a utility called shp2stl that converts geographic data in shapefiles to 3D models, suitable for 3D printing. The code is published as a NodeJS package, available on npm and GitHub. You can control the height of each shape by specifying an attribute of your data to…
  • Two weeks ago on the night of August 24, 2014 I was shaken awake by the 6.0 magnitude earthquake that struck Napa, CA. It was the largest earthquake to hit the Bay Area since the 1989 World Series quake. Where I was in San Francisco wasn't close enough to the…
  • This is a map of murders throughout the Bay Area. Constellations are formed by connecting homicides from 2013 that are in close geographic proximity to each other. Homicides from 2014 are also layered on to provide a bit more context, although not used to form the constellations. "Perhaps they are…
Standard

11 thoughts on “Sculpture of Housing Prices Ripping San Francisco Apart

  1. Chris says:

    Very interesting. Can you please post a direct-overhead photo so we can see the outline of the city?

  2. This is very nice. Now I’m all enthused to make my forays into 3d printing.
    Would you share the shape file and how you produce a shape file?

    Kind Regards

  3. Daniel S. Wilkerson says:

    Could you print an overhead photo of the city onto it? Or at least a few landmarks? It is a map. I’ve never seen someone make a map and then omit any and all landmarks.

  4. Joe Eagar says:

    This guy should get a medal for calling attention to the crazy situation down there in the Bay. Anyone who lives there should show up at town meetings and hand these things out.

Comments are closed.