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.
Two model files are included: one is the main sculpture, which I printed/painted white, and the second is a stand for the sculpture, which is printed/painted black.
For the full writeup: http://dougmccune.com/blog/2016/07/21/sculpture-of-housing-prices-ripping-san-francisco-apart/
Printing of main sculpture print took approximately 36 hours. I used Cura for slicing.
The print was sanded and finished with a few coats of XTC-3D. Then primed with Montana Gold primer spray pain, then painted with Montana Gold Shock White, and finally sealed with Montana Varnish.
Lot of sanding between each of those steps/coats.
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.
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.
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.