San Francisco Data

Close
Author
OpenData
Description
These records indicate the actual violations and comments by the inspector found during the inspection. The data should be sorted on the Complaint Number field and the Item Sequence Number field. The user should be able to link this file with the Building Complaints dataset (https://data.sfgov.org/d/gm2e-bten) to get a more accurate picture of the violations.
Category
Housing and Buildings
Tags
code violations
Rating
Current value: 0 out of 5
License
Public Domain Dedication and License
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Complaint Number
complaint_number
Item Sequence Number
item_sequence_number
Date Filed
date_filed
Block
block
Lot
lot
Street Number
street_number
Street Name
street_name
Street Suffix
street_suffix
Unit
unit
Status
status
Receiving Division
receiving_division
Assigned Division
assigned_division
NOV Category Description
nov_category_description
Item
item
NOV Item Description
nov_item_description
Neighborhoods - Analysis Boundaries
neighborhoods_analysis_boundaries
Supervisor District
supervisor_district
Zipcode
zipcode
Location
location
Supervisor Districts 2
:@computed_region_rxqg_mtj9
Fire Prevention Districts 2
:@computed_region_yftq_j783
Current Police Districts 2
:@computed_region_jx4q_fizf
Neighborhoods - Analysis Boundaries 2 2
:@computed_region_ajp5_b2md
Zip Codes 2
:@computed_region_bh8s_q3mv
Central Market/Tenderloin Boundary 2
:@computed_region_6ezc_tdp2
Central Market/Tenderloin Boundary Polygon - Updated 2
:@computed_region_h4ep_8xdi
Neighborhoods
:@computed_region_jwn9_ihcz
SF Find Neighborhoods
:@computed_region_6qbp_sg9q
Current Police Districts 3
:@computed_region_qgnn_b9vv
Current Supervisor Districts
:@computed_region_26cr_cadq

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.