About this Dataset

Parcels – Active And Retired

Note 3/13/2024: This data pipeline was recently updated. If you notice any issues, please email support@datasf.org, or fill out the form located at Actions->Contact dataset owner. Recorded parcel geography, both active and retired, with date recorded parcel was added, date recorded parcel was dropped/retired, date was added, dropped or altered re map layer. Contains geography created since the inception of the basemap in 1995, with some exceptions. Zoning District columns reflect current zoning, which can be found here: https://data.sfgov.org/d/xvjh-uu28
Organization: City of San Francisco
Last updated: 2021-08-07T18:36:42.373021
Tags: assessor, citylots, current-zoning, parcels

Tables

Table 1

@usgov.city_of_san_francisco_parcels_active_and_retired.table_1

52.6 MB
235,682 rows
37 columns

CREATE TABLE table_1 (
  "mapblklot" VARCHAR,
  "blklot" VARCHAR,
  "block_num" VARCHAR,
  "lot_num" VARCHAR,
  "from_address_num" DOUBLE,
  "to_address_num" DOUBLE,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "odd_even" VARCHAR,
  "in_asr_secured_roll" BOOLEAN,
  "pw_recorded_map" BOOLEAN,
  "zoning_code" VARCHAR,
  "zoning_district" VARCHAR,
  "date_rec_add" TIMESTAMP,
  "date_rec_drop" TIMESTAMP,
  "date_map_add" TIMESTAMP,
  "date_map_drop" TIMESTAMP,
  "date_map_alt" TIMESTAMP,
  "project_id_add" VARCHAR,
  "project_id_drop" VARCHAR,
  "project_id_alt" VARCHAR,
  "active" BOOLEAN,
  "shape" VARCHAR,
  "centroid_latitude" DOUBLE,
  "centroid_longitude" DOUBLE,
  "supdist" VARCHAR,
  "supervisor_district" DOUBLE,
  "supdistpad" DOUBLE,
  "numbertext" VARCHAR,
  "supname" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "police_district" VARCHAR,
  "police_company" VARCHAR,
  "planning_district" VARCHAR,
  "planning_district_number" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);