About this Dataset

Assessor Historical Secured Property Tax Rolls

Note: Due to the large file size the Shapefile export option does not work. To access geospatial data please select GeoJSON from the export menu This data set includes the Office of the Assessor-Recorder’s secured property tax roll spanning from July 1, 2007 to June 30, 2024. It includes all legally disclosable information, including location of property, value of property, the unique property identifier, and specific property characteristics. The data is used to accurately and fairly appraise all taxable property in the City and County of San Francisco. The Office of the Assessor-Recorder makes no representation or warranty that the information provided is accurate and/or has no errors or omissions. This dataset is updated annually after the roll is closed and certified. This typically happens by August of each year.
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:04.096525
Tags: property, property-tax, property-value, valuation

Tables

Table 1

@usgov.city_of_san_francisco_assessor_historical_secured_prop_dc637efd.table_1

149.63 MB
3,510,267 rows
46 columns

CREATE TABLE table_1 (
  "closed_roll_year" BIGINT,
  "property_location" VARCHAR,
  "parcel_number" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "volume_number" BIGINT,
  "use_code" VARCHAR,
  "use_definition" VARCHAR,
  "property_class_code" VARCHAR,
  "property_class_code_definition" VARCHAR,
  "year_property_built" DOUBLE,
  "number_of_bathrooms" BIGINT,
  "number_of_bedrooms" BIGINT,
  "number_of_rooms" DOUBLE,
  "number_of_stories" DOUBLE,
  "number_of_units" DOUBLE,
  "zoning_code" VARCHAR,
  "construction_type" VARCHAR,
  "lot_depth" DOUBLE,
  "lot_frontage" DOUBLE,
  "property_area" DOUBLE,
  "basement_area" DOUBLE,
  "lot_area" DOUBLE,
  "lot_code" VARCHAR,
  "tax_rate_area_code" VARCHAR,
  "percent_of_ownership" DOUBLE,
  "exemption_code" VARCHAR,
  "exemption_code_definition" VARCHAR,
  "status_code" VARCHAR,
  "misc_exemption_value" BIGINT,
  "homeowner_exemption_value" BIGINT,
  "current_sales_date" TIMESTAMP,
  "assessed_fixtures_value" DOUBLE,
  "assessed_improvement_value" DOUBLE,
  "assessed_land_value" DOUBLE,
  "assessed_personal_property_value" DOUBLE,
  "assessor_neighborhood_district" DOUBLE,
  "assessor_neighborhood_code" VARCHAR,
  "assessor_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "supervisor_district_2012" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "the_geom" VARCHAR,
  "row_id" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);