About this Dataset

Parcel Change Log

A. SUMMARY Lookup table for City lots (Parcels), which enables the tracking which lots were the successor lots for the new lots created. The data is in changelog format, meaning each row is a change of parcel_id -- containing both the old parcel id and the new parcel_id. B. HOW THE DATASET IS CREATED This dataset is extracted from the SFGIS database C. UPDATE PROCESS This dataset will update daily D. HOW TO USE THIS DATASET Use this dataset to track and analyze how parcels have changed over time. E. RELATED DATASETS Parcels Active and Retired Map of Active Parcels
Organization: City of San Francisco
Last updated: 2023-12-09T05:50:28.015275

Tables

Table 1

@usgov.city_of_san_francisco_citylots_newold_lookup.table_1

22.59 MB
119,918 rows
7 columns

CREATE TABLE table_1 (
  "blklot" VARCHAR,
  "oldblklot" VARCHAR,
  "recordeddate" TIMESTAMP,
  "recordedid" VARCHAR,
  "geometry" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);