Soft Story Buildings

This Indicator measures the residential parcels that required a Level 1 or Level 2 evaluation of the group floor for a soft-story retrofit. Potential soft story buildings were identified through a 2008 screening of buildings permitted for construction before January 1, 1991, with parking or commercial on the ground floor, with five or more residential units, without previous soft story retrofits, and at least two stories. Some of these buildings were marked exempt or had incomplete evaluations, so this Indicator only measures those that were officially identified as soft story in 2014. In future years, we hope to measure the percent of identified soft story buildings that have been retrofitted.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"oaklandca-gov/soft-story-buildings-q5mn-iahk\".\"soft_story_buildings\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.