Home › Sources › datasf_assessor_property_tax_context
DataSF Assessor-Recorder Secured Property Tax Roll Context
Source ID datasf_assessor_property_tax_context. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_assessor_property_tax_context |
| Name | DataSF Assessor-Recorder Secured Property Tax Roll Context |
| Owner | DataSF / San Francisco Office of the Assessor-Recorder |
| Layer | parcel_property_tax_context |
| Coverage | Assessor secured property tax roll has 3,722,920 rows for closed roll years 2007 through 2024, latest observed data_as_of 2025-06-09T00:00:00.000 and data_loaded_at 2025-09-25T14:31:23.000. A bounded 2024 extract now materializes 500 property_assessment rows across 3 neighborhoods and 38 blocks, plus 255 full reference-code rows (145 property class/use, 17 exemption, 93 assessor neighborhood). |
| Formats | JSON API, CSV, GeoJSON |
| Join keys | closed_roll_year, parcel_number, block, lot, property_location, row_id, use_code, property_class_code, exemption_code, assessor_neighborhood_code, analysis_neighborhood, supervisor_district, the_geom |
| Caveats | Assessor secured-roll records are property context only; do not treat them as proof of court ownership, party identity, or case outcome., Valuation, exemption, percent ownership, and sales-date fields must remain source-labeled and date-scoped. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | datasf_assessor_property_tax_context | assessor_property_assessment_and_reference_extract | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | annual after the secured roll is closed and certified |
| Coverage | Assessor secured property tax roll has 3,722,920 rows for closed roll years 2007 through 2024, latest observed data_as_of 2025-06-09T00:00:00.000 and data_loaded_at 2025-09-25T14:31:23.000. A bounded 2024 extract now materializes 500 property_assessment rows across 3 neighborhoods and 38 blocks, plus 255 full reference-code rows (145 property class/use, 17 exemption, 93 assessor neighborhood). |
| Government Level | local_assessor_recorder |
| ID | datasf_assessor_property_tax_context |
| Layer | parcel_property_tax_context |
| Name | DataSF Assessor-Recorder Secured Property Tax Roll Context |
| Owner | DataSF / San Francisco Office of the Assessor-Recorder |
| Profile Status | implemented_checkpointed_property_assessment_sync |
| Canonical Records | property_assessment, property_code_reference, place_context, source_record |
| Caveats | Assessor secured-roll records are property context only; do not treat them as proof of court ownership, party identity, or case outcome., Valuation, exemption, percent ownership, and sales-date fields must remain source-labeled and date-scoped. |
| Evidence | artifacts/source-discovery/datasf-assessor-property-context.profile.json, artifacts/source-discovery/datasf-assessor-property-context.extract.profile.json, artifacts/source-discovery/datasf-assessor-secured-rolls-wv5m-vpq2.view.json, artifacts/source-discovery/datasf-assessor-secured-rolls-wv5m-vpq2.sample.json, artifacts/source-discovery/datasf-assessor-secured-rolls-wv5m-vpq2.profile-query.json, artifacts/source-discovery/datasf-assessor-property-class-codes-pa56-ek2h.sample.json, artifacts/source-discovery/datasf-assessor-exemption-codes-g77e-ikb4.sample.json, artifacts/source-discovery/datasf-assessor-neighborhood-codes-dx7g-zwbx.sample.json, data/property_assessment_raw/datasf-assessor-property-context.json, data/property_assessment_raw/datasf-assessor-property-context.manifest.json, scripts/parse_datasf_assessor_property_context.py, scripts/sync_datasf_assessor_property_context.py |
| Formats | JSON API, CSV, GeoJSON |
| Join Keys | closed_roll_year, parcel_number, block, lot, property_location, row_id, use_code, property_class_code, exemption_code, assessor_neighborhood_code, analysis_neighborhood, supervisor_district, the_geom |
| Known Endpoints | Socrata /resource/wv5m-vpq2.json, Socrata /resource/pa56-ek2h.json, Socrata /resource/g77e-ikb4.json, Socrata /resource/dx7g-zwbx.json |
| Rate Limit Notes | Full sync should page by closed_roll_year and parcel_number with annual checkpoints., Normalize property_location before address joins; do not reverse assessor rows into person identity. |
| Source Urls | https://data.sfgov.org/Housing-and-Buildings/Assessor-Historical-Secured-Property-Tax-Rolls/wv5m-vpq2, https://data.sfgov.org/Housing-and-Buildings/Reference-Assessor-Recorder-Property-Class-Codes/pa56-ek2h, https://data.sfgov.org/Housing-and-Buildings/Reference-Assessor-Recorder-Exemption-Codes/g77e-ikb4, https://data.sfgov.org/Housing-and-Buildings/Reference-Assessor-Recorder-Neighborhood-Codes/dx7g-zwbx, https://data.sfgov.org/resource/wv5m-vpq2.json |
Get this page with API
Rendered from the bluedoor SF Superior Court API. Reproduce it:
GET https://api.bluedoor.sh/sf-superior-court/v1/sources/datasf_assessor_property_tax_contextJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_assessor_property_tax_context&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON