Tall Building Inventory by US Government | Ecommerce and Consumer Trends

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

174.63 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
);