Code Enforcement Violations

Development Services Updated Jan 19, 2018 As needed

About this dataset

Code enforcement cases that were reported to the Development Services Department prior to January 2018 and were closed out between 2015 and 2018.

For more recent data on code enforcement violations, please visit OpenDSD.

Get the data

Browse the table below for all files available for this dataset

Data Downloads

File name Download actions File Format File size
Code Enforcement Cases 2015 through 2018 Download

Copy URL

CSV

6.01 MB

View a data sample

Showing 1 transposed sample row. Download the full dataset or a view to get the data.

Data Sample

Data preview - first row of dataset transposed
Field Sample Value
apn3100804300
address_street3346 INDUSTRIAL CT
case_sourceCitizen Complaint
descriptionThis property is abandoned with transient, drugs, and prostitution. The fence has been cut in several locations. There are mattresses, chairs, tables, and food being stored also.
date_open2016-08-29
date_closed2017-02-28
close_reasonNo Violation
close_noteInspected the site. Contractors are working on site. See case file notes.
lat32.916538
lng-117.234921
nad83_northing1914687
nad83_easting6259412
workgroupZoning
investigator_nameTryon, Tracy
investigator_phone_number(619)236-6833
investigator_email_addressTTRYON@sandiego.gov
investigator_activeY
last_actionAdministrative Abatement - Inspection
date_last_action_due2017-03-01
remedy_msgInspected the site on 2/24/17. Contractors are working onsite. See case file notes.

Understand the data

Each field in the data is defined in the table below. Use this information to inform usage of the data.

Download dictionary

Data Dictionary

Data dictionary - field definitions for this dataset
FieldDescriptionPossible_values
APNParcel Number
case_idCode Enforcement Case Number
case_sourceSource of complaint
close_datedate the case was closed
close_noteNote about the closure
close_reasonWhy the case was closed
descriptionDescription of violation
complaint_typeType of Complaint
complaint_type_idID of type of complaint
investigator_activeIs the investigator actively researching this complaint
investigator_email_addressEmail Address of the Investigator
investigator_nameName of investigator
investigator_phone_numberPhone # of investigator
last_actionLast action taken
last_action_due_dateWhen the last action is due
latitudeLatitude of complaint location
longitudeLongitude of complaint location
open_dateWhen the complaint was filed
remedy_msgHow the complaint was remedied
street_addressStreet Address of complaint
workgroupGroup that worked on this

Data & Analytics

data@sandiego.gov