New York City Housing Authority
At a Glance
Industry
Public Housing Authority
Project Type
Engagement and Behavior Change
Year
2017
Location
New York, NY
Summary
Jane Chu created a fully automated SQL platform with streaming capability for all of NYCHA’s energy data.
Goals
The New York City Housing Authority (NYCHA), the nation’s largest public housing authority has committed to reduce its energy use by 20% over 10 years and its greenhouse gas (GHG) emissions by 30% over 10 years as part of its NextGeneration NYCHA Sustainability Agenda. NYCHA, which is currently implementing various energy efficiency measures in its buildings, hired EDF Climate Corps fellow Jane Chu to streamline its energy data collection process.
Solutions
Chu turned NYCHA’s manual data collection process into a fully automated SQL platform with streaming capability. First, Chu mapped the existing database schema and interviewed Energy & Sustainability staff to create a metadata repository. She then normalized and optimized the existing database to create a new schema that presents all NYCHA's energy data in 1/4 the space, using fully automated connectors. In addition to automating connectors, Chu recommended alleviating bloat and migrating the old paper-and-spreadsheets database onto a SQL platform to save time from manual inputs and reporting errors. To develop a timeline for deploying the new schema as an automated SQL database, she met with NYCHA's Information Technology and Performance Analytics departments.
Potential Impact
The new database now meets the technical criteria for tools NYCHA could not access before, like data streaming. This is critical for energy saving measures (like smart meters) that depend on timely insights and feedback. Chu's work will allow NYCHA to manage its utilities at a much more granular level, improving energy and water efficiency of its buildings over time.