About this Dataset

Parklet Permits

A list of all permitted parklets in San Francisco. A parklet is a sidewalk extension that provides more space and amenities for people using the street. Usually parklets are installed on parking lanes and use several parking spaces.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:41.187501
Tags: narrow, of, open, parking, parklet, permit, permits, right, sidewalk, space, way

Tables

Table 1

@usgov.city_of_san_francisco_parklet_permits.table_1

37.05 KB
77 rows
29 columns


CREATE TABLE table_1 (
  "permit_number" VARCHAR,
  "permit_address" VARCHAR,
  "street_name" VARCHAR,
  "cross_street_1" VARCHAR,
  "cross_street_2" VARCHAR,
  "permit_zipcode" DOUBLE,
  "applicant" VARCHAR,
  "permit_purpose" VARCHAR,
  "permit_approval_date" TIMESTAMP,
  "permit_end_date" TIMESTAMP,
  "permit_status" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "cnn" BIGINT,
  "envista_project_id" VARCHAR,
  "envista_project_name_full" VARCHAR,
  "envista_facility_type" VARCHAR,
  "envista_start_date" TIMESTAMP,
  "envista_end_date" TIMESTAMP,
  "envista_description" VARCHAR,
  "envista_moratoriums_opportunities" VARCHAR,
  "envista_facility_indicator" VARCHAR,
  "envista_facility_subindicator" VARCHAR,
  "envista_project_type" VARCHAR,
  "envista_location_type" VARCHAR,
  "envista_intermediate_location_text" VARCHAR,
  "location" VARCHAR
);