Home › Sources › datasf_property_code_fire_enforcement_context
DataSF Property, Code, and Fire Enforcement Context
Source ID datasf_property_code_fire_enforcement_context. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | datasf_property_code_fire_enforcement_context |
| Name | DataSF Property, Code, and Fire Enforcement Context |
| Owner | DataSF / San Francisco Department of Building Inspection / San Francisco Fire Department |
| Layer | building_fire_code_enforcement_context |
| Coverage | Six DataSF DBI/fire enforcement datasets profiled with current metadata, count/date probes, and 5-row samples: 331,038 DBI complaints, 513,017 DBI NOV rows, 687,815 building inspections, 77,061 fire-safety complaints, 52,831 fire violations, and 436,008 fire inspections. Latest observed dates reach 2026-05-29 for DBI/fire complaints and violations, 2026-05-30 for fire inspections, and 2026-06-02 scheduled building inspections; 30 bounded rows now load into property_enforcement_events. |
| Formats | JSON API, CSV, GeoJSON |
| Join keys | complaint_number, primary_key, inspection_number, violation_id, violation_number, permit_number, dbi_application_number, _311_case_number, parcel_number, block, lot, address, street_number, street_name, zipcode, analysis_neighborhood, neighborhood_district |
| Caveats | DBI/fire complaints, violations, and inspections are enforcement and property-condition context, not court outcomes or criminal facts., Source dates include dirty historical outliers such as year 0200 in DBI complaint/NOV date fields; production sync must quarantine impossible dates., Inspector, permit-contact, fee, lien, and penalty fields need policy labels before person/org-facing display. |
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_property_code_fire_enforcement_context | socrata_dataset_group_profile | - | - | - |
| - | datasf_property_code_fire_enforcement_context | socrata_checkpointed_sync_manifest | - | - | - |
Full source record
| Access Mode | socrata_api |
| Cadence | open-data refresh; profile probes observed data_loaded_at values on 2026-05-30 |
| Coverage | Six DataSF DBI/fire enforcement datasets profiled with current metadata, count/date probes, and 5-row samples: 331,038 DBI complaints, 513,017 DBI NOV rows, 687,815 building inspections, 77,061 fire-safety complaints, 52,831 fire violations, and 436,008 fire inspections. Latest observed dates reach 2026-05-29 for DBI/fire complaints and violations, 2026-05-30 for fire inspections, and 2026-06-02 scheduled building inspections; 30 bounded rows now load into property_enforcement_events. |
| Government Level | local_city |
| ID | datasf_property_code_fire_enforcement_context |
| Layer | building_fire_code_enforcement_context |
| Name | DataSF Property, Code, and Fire Enforcement Context |
| Owner | DataSF / San Francisco Department of Building Inspection / San Francisco Fire Department |
| Profile Status | promoted_bounded_property_enforcement_extract |
| Canonical Records | property_enforcement_event, place_context, civic_service_request, source_record |
| Caveats | DBI/fire complaints, violations, and inspections are enforcement and property-condition context, not court outcomes or criminal facts., Source dates include dirty historical outliers such as year 0200 in DBI complaint/NOV date fields; production sync must quarantine impossible dates., Inspector, permit-contact, fee, lien, and penalty fields need policy labels before person/org-facing display. |
| Evidence | artifacts/source-discovery/datasf-property-code-fire-enforcement.profile.json, artifacts/source-discovery/datasf-property-code-fire-enforcement.catalog.json, artifacts/source-discovery/datasf-dbi-complaints-gm2e-bten.sample.json, artifacts/source-discovery/datasf-dbi-notices-violation-nbtm-fbw5.sample.json, artifacts/source-discovery/datasf-building-inspections-vckc-dh2h.sample.json, artifacts/source-discovery/datasf-fire-safety-complaints-2wsq-7wmv.sample.json, artifacts/source-discovery/datasf-fire-violations-4zuq-2cbe.sample.json, artifacts/source-discovery/datasf-fire-inspections-wb4c-6hwj.sample.json, scripts/profile_datasf_property_enforcement_context.py, data/property_enforcement_raw/manifest.json, scripts/sync_datasf_property_enforcement_context.py |
| Formats | JSON API, CSV, GeoJSON |
| Join Keys | complaint_number, primary_key, inspection_number, violation_id, violation_number, permit_number, dbi_application_number, _311_case_number, parcel_number, block, lot, address, street_number, street_name, zipcode, analysis_neighborhood, neighborhood_district |
| Known Endpoints | Socrata /resource/gm2e-bten.json, Socrata /resource/nbtm-fbw5.json, Socrata /resource/vckc-dh2h.json, Socrata /resource/2wsq-7wmv.json, Socrata /resource/4zuq-2cbe.json, Socrata /resource/wb4c-6hwj.json |
| Rate Limit Notes | Use checkpointed Socrata paging by source date and stable source id; do not call upstream live per API request., Materialize address, parcel, block/lot, and 311 joins offline with explicit confidence/provenance. |
| Source Urls | https://data.sfgov.org/Housing-and-Buildings/Department-of-Building-Inspection-Complaints-All-Div/gm2e-bten, https://data.sfgov.org/Housing-and-Buildings/Notices-of-Violation-issued-by-the-Department-of-Bu/nbtm-fbw5, https://data.sfgov.org/Housing-and-Buildings/Building-Inspections/vckc-dh2h, https://data.sfgov.org/Public-Safety/Fire-Safety-Complaints/2wsq-7wmv, https://data.sfgov.org/Public-Safety/Fire-Violations/4zuq-2cbe, https://data.sfgov.org/Public-Safety/Fire-Inspections/wb4c-6hwj |
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_property_code_fire_enforcement_contextJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=datasf_property_code_fire_enforcement_context&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON