About this Dataset

Building Footprints

These footprint extents are collapsed from an earlier 3D building model provided by Pictometry of 2010, and have been refined from a version of building masses publicly available on the open data portal for over two years.The building masses were manually split with reference to parcel lines, but using vertices from the building mass wherever possible.These split footprints correspond closely to individual structures even where there are common walls; the goal of the splitting process was to divide the building mass wherever there was likely to be a firewall.
An arbitrary identifier was assigned based on a descending sort of building area for 177,023 footprints. The centroid of each footprint was used to join a property identifier from a draft of the San Francisco Enterprise GIS Program's cartographic base, which provides continuous coverage with distinct right-of-way areas as well as selected nearby parcels from adjacent counties. See accompanying document SF_BldgFoot_2017-05_description.pdf for more on methodology and motivation
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:07.285910
Tags: building

Tables

Table 1

@usgov.city_of_san_francisco_building_footprints.table_1

77.42 MB
177023 rows
45 columns


CREATE TABLE table_1 (
  "sf16_bldgid" DOUBLE,
  "area_id" BIGINT,
  "mblr" VARCHAR,
  "p2010_name" VARCHAR,
  "p2010_zminn88ft" DOUBLE,
  "p2010_zmaxn88ft" DOUBLE,
  "gnd_cells50cm" BIGINT,
  "gnd_mincm" BIGINT,
  "gnd_maxcm" BIGINT,
  "gnd_rangecm" BIGINT,
  "gnd_meancm" DOUBLE,
  "gnd_stdcm" DOUBLE,
  "gnd_varietycm" BIGINT,
  "gnd_majoritycm" BIGINT,
  "gnd_minoritycm" BIGINT,
  "gnd_mediancm" BIGINT,
  "cells50cm_1st" BIGINT,
  "mincm_1st" BIGINT,
  "maxcm_1st" BIGINT,
  "rangecm_1st" BIGINT,
  "meancm_1st" DOUBLE,
  "stdcm_1st" DOUBLE,
  "varietycm_1st" BIGINT,
  "majoritycm_1st" BIGINT,
  "minoritycm_1st" BIGINT,
  "mediancm_1st" BIGINT,
  "hgt_cells50cm" BIGINT,
  "hgt_mincm" BIGINT,
  "hgt_maxcm" BIGINT,
  "hgt_rangecm" BIGINT,
  "hgt_meancm" DOUBLE,
  "hgt_stdcm" DOUBLE,
  "hgt_varietycm" BIGINT,
  "hgt_majoritycm" BIGINT,
  "hgt_minoritycm" BIGINT,
  "hgt_mediancm" BIGINT,
  "gnd_min_m" DOUBLE,
  "median_1st_m" DOUBLE,
  "hgt_median_m" DOUBLE,
  "gnd1st_delta" DOUBLE,
  "peak_1st_m" DOUBLE,
  "globalid" VARCHAR,
  "shape" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);