Dataset: San Francisco Privately Owned Public Spaces

About this Dataset

San Francisco Privately Owned Public Spaces

From San Francisco's description: Privately-owned public open spaces (POPOS) are publicly accessible spaces in forms of plazas, terraces, atriums, small parks, and even snippets which are provided and maintained by private developers. In San Francisco, POPOS mostly appear in the Downtown office district area. Prior to 1985, developers provided POPOS under three general circumstances: voluntarily, in exchange for a density bonus, or as a condition of approval. The 1985 Downtown Plan created the first systemic requirements for developers to provide publicly accessible open space as a part of projects in C-3 Districts. The goal was to “provide in the downtown quality open space in sufficient quantity and variety to meet the needs of downtown workers, residents and visitors.” (See Planning Code Section 138 for regulations). Since then, project sponsors for residential projects may provide POPOS instead of their required open spaces in the Downtown Residential (DTR) and Eastern Neighborhoods (Section 135 of the Planning Code). Learn more at http://sf-planning.org/privately-owned-public-open-space-and-public-art-popos
Less

Tables

Privately Owned Public Open Spaces

@kaggle.narnaoot_san_francisco_privately_owned_public_spaces.privately_owned_public_open_spaces

46.3 KB
78 rows
38 columns


CREATE TABLE privately_owned_public_open_spaces (
  "name" VARCHAR,
  "popos_address" VARCHAR,
  "hours" VARCHAR,
  "type" VARCHAR,
  "landscaping" VARCHAR,
  "seating_no" VARCHAR,
  "food_service" VARCHAR,
  "art" VARCHAR,
  "restrooms" VARCHAR,
  "accessibility" VARCHAR,
  "location" VARCHAR,
  "year" VARCHAR,
  "source" VARCHAR,
  "food" VARCHAR,
  "seating" VARCHAR,
  "description" VARCHAR,
  "seating_and_tables" VARCHAR,
  "hours_type" VARCHAR,
  "subject_to_downtown_pln" VARCHAR,
  "signage" VARCHAR,
  "amenities" VARCHAR,
  "block_num" BIGINT,
  "lot_num" BIGINT,
  "parcel_num" BIGINT,
  "restroom" VARCHAR,
  "indoor" VARCHAR,
  "special_amenities" VARCHAR,
  "map_id" VARCHAR,
  "the_geom" VARCHAR,
  "sf_find_neighborhoods" BIGINT,
  "current_police_districts" BIGINT,
  "current_supervisor_districts" BIGINT,
  "analysis_neighborhoods" BIGINT,
  "delete_supervisor_districts" BIGINT,
  "delete_fire_prevention_districts" BIGINT,
  "delete_current_police_districts" BIGINT,
  "delete_zip_codes" BIGINT,
  "neighborhoods" BIGINT
);