About this Dataset

City Facilities

City-owned and leased facilities maintained in the City's Facility System of Record (FSR). Does not include the following agencies which are not part of the City and County of San Francisco: SFHA, OCII and City College.
This dataset was developed through a process involving some of the primary stewards for the facility data and their stakeholders. It is meant to be a living reference and will be maintained and updated through established workflows and processes over time. You can access the attached User Guide for more detail by clicking the red About button and scrolling to attachments.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:46.619338
Tags: facility, public-buildings, public-facilities

Tables

Table 1

@usgov.city_of_san_francisco_city_facilities.table_1

179.09 KB
1736 rows
29 columns


CREATE TABLE table_1 (
  "facility_id" BIGINT,
  "common_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "block_lot" VARCHAR,
  "owned_leased" VARCHAR,
  "dept_id_for_jurisdiction" BIGINT,
  "jurisdiction" VARCHAR,
  "gross_sq_ft" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "supervisor_district" DOUBLE,
  "city_tenants" VARCHAR,
  "land_id" DOUBLE,
  "geom" VARCHAR,
  "data_last_updated" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhoods" DOUBLE,
  "delete_neighborhoods_from_fyvs_ahh9" DOUBLE,
  "delete_supervisor_districts" DOUBLE,
  "delete_current_police_districts" DOUBLE,
  "delete_fire_prevention_districts" DOUBLE,
  "delete_zip_codes" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE
);