About this Dataset

Tall Building Inventory

Inventory of tall buildings in San Francisco, focusing on attributes that are relevant to building performance during an earthquake or to post-earthquake recovery. Where possible, the attributes were collected from permitting documents at the Department of Building Inspections. As of October 1, 2018, this database includes a complete list of the 156 buildings taller than 240 ft, as well as another 24 buildings over 160 ft. For more information on the Tall Building Safety Strategy, see http://OneSanFrancisco.org/Resilient-SF. If you find any errors or emissions in this database, please contact us at [cpp@sfgov.org](mailto:cpp@sfgov.org?subject=Tall Buildings Database). For any other issues, please scroll down to "contact the dataset owner" on this page.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:12.420775
Tags: recovery, resilience

Tables

Table 1

@usgov.city_of_san_francisco_tall_building_inventory.table_1

178.82 kB
180 rows
45 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "polygon" VARCHAR,
  "name" VARCHAR,
  "address" VARCHAR,
  "mapblocklot" VARCHAR,
  "mbl_unique" VARCHAR,
  "date" BIGINT,
  "retrofit_date" DOUBLE,
  "description" VARCHAR,
  "height_ft" DOUBLE,
  "stories_above_grade" DOUBLE,
  "stories_below_grade" DOUBLE,
  "occupancy" VARCHAR,
  "structural_material" VARCHAR,
  "structural_system" VARCHAR,
  "structural_types" VARCHAR,
  "facade_material" VARCHAR,
  "foundation_system" VARCHAR,
  "borp_report" VARCHAR,
  "instrumented" VARCHAR,
  "square_footage" DOUBLE,
  "fire_resistence_type" VARCHAR,
  "percent_sprinklered" DOUBLE,
  "liquefaction_potential" VARCHAR,
  "bedrockdepth_mean" DOUBLE,
  "bedrockdepth_max" DOUBLE,
  "bedrockdepth_min" DOUBLE,
  "permit_date_1" DOUBLE,
  "permit_date_2" DOUBLE,
  "permit_date_3" DOUBLE,
  "completion_date" DOUBLE,
  "building_code_year" VARCHAR,
  "base_plan_size" VARCHAR,
  "tower_plan_size" VARCHAR,
  "typ_story_height" VARCHAR,
  "attyp_story_height" VARCHAR,
  "architectural_notes" VARCHAR,
  "atrium_location" VARCHAR,
  "mep_levels" VARCHAR,
  "site_class" VARCHAR,
  "foundation_info" VARCHAR,
  "collected_on" TIMESTAMP,
  "primary_source" VARCHAR,
  "shape_length" DOUBLE,
  "shape_area" DOUBLE
);