Comparing LACITY Open Data with Official Reports
- This exploration looks at data reported in the Aug 25, 2016 Quarterly Status Report of Mayor Garcetti's Executive Directive 13, Support for Affordable Housing.
- The status report, addresses the Mayor's goal of permitting 100,000 new housing units by 2021 as there are not enough housing to keep up with the demand in one of the nation's most expensive metropolitan regions.
- Can open data be used to reach the numbers as reported by the Mayor's Office?
- Open data can only go so far in analysis due to the limited information municipal goverments are willing to give in the public datasets. This may be due to an issuing department's concerns of the quality of the data, or their unawareness of the need for more detailed datasets.
- The methods outlined here may or may not arrive to the official numbers, and documenting them here on github invites others to participate in testing out alternative ways and try other datasets that could reach a more accurate representation of the housing status in the City of Los Angeles.
- In the end, it's not about the results but to see if citizens, academics and professionals can use open data in support of improving the quality of information published by municipal governments.
##Open Data Sources
- Building and Safety Permit Information from the LACITY Open Data Portal | Issued by the Department of Building and Safety | Last Updated Aug 15, 2016 | Link to full permit dataset
- Note: Permit issue dates start at 1/01/2013 to 8/11/2016
- This dataset contains building permits, electrical permits, and mechanical permits.
- Copy of full dataset from this update can be downloaded in this repo.
##Reports and other prepared datasets
- US Census Building Permits Survey | The data provides the number of housing units authorized by building permits
- Data for LA city can be found on this repo.
- Los Angeles Department of Building and Safety Newsletters
- Annual Element Progress Report, Housing Element Implementation |
- 2010 | 2011 | 2012 | 2013 | 2014
- Previous years can be found at the California Department of Housing and Community Development
##Explorations and methods ###Total Dwelling Units reported in Building Permits
The mayor's office published status report on 8.25.2016 indicated that since July 1, 2013 to June 30th 2016, the city has issued permits for 40,805 dwelling units. Further research with other reports data sources come close to the reported total, this includes:
- 40,911 - LADBS Newsletters
- 40,100 - Census Building Permits Survey
Raw permit data is published on the city's data portal, which has a terrific detailed breakdown of permits by address, permit type, description and it also includes geocoordinates for mapping. There is opportunities for further analysis on a local level which can include totals by Council District, Community Plan, Neighborhood Council. The geocoordinates can be used to generate maps for additional inquiry.
The raw data is filtered by Fiscal Year, so its consistent with the reports. Using the socrata platform, the data was filtered using:
Issue Dateis after
End Fiscal Year
Issue Dateis before
Start Fiscal Year
# of Residential Dwelling Unitsis greater than
Filtered results in comparison to reported totals. Also included is the number of building permits (All types) issued. Links to raw results.
|Data Comparison of LACITY Reports with Open Data|
|Note: A fiscal year (FY) begins in July 1st - June 30th|
|Dwelling Units||Dwelling Units||Permits Issued||Permits Issued||Dwelling Units|
|8/2016 Status Report||LADBS Newsletter||LADBS Newsletter||LACITY Data Portal||LACITY Data Portal|
|2014 Fiscal Year|
|2015 Fiscal Year|
|2016 Fiscal Year|
This exploration is part of [section.la] (https://github.com/cityhubla/sectionla/blob/master/README.md), a collection of maps and data visualizations exploring Southern California, one section at a time.
The analysis, maps and code behind the explorations contribute to the services I offer as a consultant developing analog and digital tools and visualizations for Civic Engagement, Planning, Land Use Development and Public Policy. Think you could use my services?