Friday, November 30, 2012

Healthy Housing Code Violations, San Francisco, CA

Several months of mindless toil pays off. I have an employment affiliation with the San Francisco Department of Public Health, Environmental Health Section. Yesterday we released our first batch of data from the Sustainable Communities Index (SCI) as part of our open data initiative. This release is the culmination of a seemingly endless process of searching for, cataloging, cleaning, and writing metadata for data we use for health equity analyses.... a process I have participated in and that will continue through the end of the year. If I may request, next time you feel like decrying the faceless government bureaucrats with access to all the government data you want and can't find, have some pity. Their offices may not have any windows. To view all the data released to date, check the public health category on DataSF.

The healthy housing code violations dataset visualized below was part of yesterday's release, covering violations cited between 2009 and 2011. Geocoded violations are very heavily concentrated in the Tenderloin, Chinatown, and 6th Street. Many of the addresses have been cited multiple times, most commonly for insanitary conditions, but also for other housing violations.

Building code violations, issued by the department of building inspections for violations of the fire, plumbing, electrical and other safety codes, are also high in these areas, but the overall distribution of building code violations across the city is much more diffuse. I'll tackle that visualization at another date.

Zoom in on the map to see violations geocoded to individual addresses. Hover to see the number of violations, and which types, and click to see the address cited.

Property owners are required to provide: Buildings free of lead hazard and mold; safe sources of heating systems; effective weatherproofing of windows, exterior walls, and roofs; housing free of garbage, waste rats, vermin, and bedbugs; plumbing and gas facilities in good order; hot and cold running water; adequate electrical plugs and phone jacks; and, well-maintained stairs floors, and common areas. For more information on code enforcement, visit the San Francisco Department of Public Health Code Enforcement Complaints Program.
Template developed by Confluent Forms LLC