Assessor Historical Secured Property Tax Rolls

data.sfgov.org | Last Updated 30 Jan 2019

This data set includes the Office of the Assessor-Recorder’s secured property tax roll spanning from July 1, 2007 to June 30, 2018. 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.

Tags: valuation, property, property tax, property value

This dataset has the following 43 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Closed Roll Yearclosed_roll_yeartextThe year listed represents the leading year of the fiscal year that the assessed value is effective for taxation purposes. For example, 2009 represents the 2009-2010 fiscal year during which the assessed values listed were effective (i.e. billed and collected). Note that a fiscal year starts July 1st and ends June 30th so that 2009 would start on July 1st, 2009 and end on June 30th 2010.
Property Locationproperty_locationtextSitus/Location, as well as room/unit number
Parcel Numberparcel_numbertextBlock and Lot Number (Full Assessor Parcel Number)
BlockblocktextThe block portion of the parcel number broken out.
LotlottextThe lot portion of the parcel number broken out.
Volume Numbervolume_numbernumberVolume number
Use Codeuse_codetextUse Codes group together related property class codes. They are defined by the field Use Definition. See also the field "Property Class Code." Property class codes and their related use codes are defined in the reference dataset: https://data.sfgov.org/d/pa56-ek2h
Use Definitionuse_definitiontextThe definition for the field "Use Code." Property class codes and their related use codes are defined in the reference dataset: https://data.sfgov.org/d/pa56-ek2h
Property Class Codeproperty_class_codetextProperty type code defined in the field "Property Class Code Definition." Property class codes and their related use codes are defined in the reference dataset: https://data.sfgov.org/d/pa56-ek2h Please note, VCIX was truncated in the source and at the time records marked VCI could be VCIX. This is a rare code and indicates vacant land with restrictions as opposed to without.
Property Class Code Definitionproperty_class_code_definitiontextProperty type definition (name) based that defines the code in the field "Property Class Code." Property class codes and their related use codes are defined in the reference dataset: https://data.sfgov.org/d/pa56-ek2h Please note, the property use code VCIX was truncated in the source and at the time records marked VCI could be VCIX. This is a rare code and indicates vacant land with restrictions as opposed to without.
Year Property Builtyear_property_builttextYear improvement was built (can be blend of original and newer construction)
Number of Bathroomsnumber_of_bathroomsnumberNumber of bathrooms (BA with no shower or tub is 1/2 bathroom)
Number of Bedroomsnumber_of_bedroomsnumberNumber of bedrooms (bedrooms have a closet)
Number of Roomsnumber_of_roomsnumberNumber of rooms, excluding bathrooms, halls, closets, etc.
Number of Storiesnumber_of_storiesnumberNumber of stories
Number of Unitsnumber_of_unitsnumberNumber of units
Zoning Codezoning_codetextZoning code of property as of last sale.
Construction Typeconstruction_typetextGenerally type of construction. See code book for construction type definitions.
Lot Depthlot_depthnumberDepth of lot in linear feet
Lot Frontagelot_frontagenumberLinear footage of front facing side of lot (front foot)
Property Areaproperty_areanumberSquare footage of lot
Basement Areabasement_areanumberSquare footage of basement
Lot Arealot_areanumberSquare footage of lot
Lot Codelot_codetextLot shapes, could be Rectangle, Square or Other
Tax Rate Area Codetax_rate_area_codetextTax rate dependent on location within the City
Percent of Ownershippercent_of_ownershipnumberPercent of ownership
Exemption Codeexemption_codetextExemption code if applicable, see the reference of exemption codes here: https://data.sfgov.org/d/g77e-ikb4
Exemption Code Definitionexemption_code_definitiontextName associated with the exemption code, see reference of exemption codes here: https://data.sfgov.org/d/g77e-ikb4
Status Codestatus_codetexti.e. Taxable, Non-Taxable, SBE, etc.
Misc Exemption Valuemisc_exemption_valuenumberExemption value for misc. exemptions such as Welfare
Homeowner Exemption Valuehomeowner_exemption_valuenumberHomeowner's exemption value
Current Sales Datecurrent_sales_datecalendar_dateDate in which the current sale (most recent) for this period was recorded.
Assessed Fixtures Valueassessed_fixtures_valuenumberAssessed value of fixtures
Assessed Improvement Valueassessed_improvement_valuenumberAssessed value of improvements
Assessed Land Valueassessed_land_valuenumberAssessed value of land
Assessed Personal Property Valueassessed_personal_property_valuenumberAssessed value of personal property
Assessor Neighborhood Districtassessor_neighborhood_districttextAssessor-Recorder neighborhood district. A district encapsulates a subset of neighborhoods defined by a code and related name. See the field "Assessor Neighborhood Code" and "Assessor Neighborhood" for the neighborhoods that fall within the district. Also see the reference data for Assessor Neighborhoods at: https://data.sfgov.org/d/dx7g-zwbx
Assessor Neighborhood Codeassessor_neighborhood_codetextAssessor-Recorder neighborhood code. See the field "Assessor Neighborhood" for the name associated with the code. Also see the reference data for Assessor Neighborhoods at: https://data.sfgov.org/d/dx7g-zwbx
Assessor Neighborhoodassessor_neighborhoodtextAssessor-Recorder neighborhood name. See the field "Assessor Neighborhood Code" for the associated code. Also see the reference data for Assessor Neighborhoods at: https://data.sfgov.org/d/dx7g-zwbx
Supervisor Districtsupervisor_districttextThe supervisor district the parcel falls within. This field is automatically computed from the latitude and longitude in the Location field. Blank if no location available or location did not match a district.
Analysis Neighborhoodanalysis_neighborhoodtextAnalysis neighborhoods corresponding to census boundaries. You can see these boundaries here: https://data.sfgov.org/d/p5b7-5n3h These are computed based on the latitude and longitude in the Location field. Blank if there's no location or the location did not match one of the neighborhoods.
the_geomthe_geomlocationThe centroid point (latitude, longitude) of the parcel. This is automated. In some cases this may be blank if the block and lot number did not result in a successful geographic match.
Row IDrow_idtextThis is an identifier unique to each row for the purposes of managing updates to the dataset. It is the concatenation of YYYYMMDD corresponding to the January 1 of the roll year for the record and Parcel Number.