HomeMy WorkHousing Database
Housing Database
I designed an application that helps users evaluate the quality of a rental apartment before they sign a lease.
Image 1: The home screen of the housing database I created, on desktop and mobile.
Overview
Project Description
I designed an application that helps users evaluate the quality of a rental apartment before they sign a lease.
About the Client
The NYC Department of Housing Preservation and Development would make business decisions. However, this is a personal project.
How Problems Were Identified
Problems were defined based on the experience of viewing apartments and data collected by the NYC Department of Housing.
Timing
I worked on this project for three months.
Tools
Figma, Sketch, Invision, Photoshop, Illustrator.
Deliverables
User flows, information architecture diagrams,  wireframes, mockups, a clickable prototype, visual designs.
Image 2: The city of New York is home to more than 8 million people. 68% of households are renter-occupied. Image credit: Pedro Lastra on Unsplash.
Project Structure
My Role, Responsibilities, and Skills
I was in charge of and executed research, information architecture,  flow diagrams, wireframes, usability testing, and final designs for this digital product.
The Team
Michael Walker, Product Designer
The Opportunity
Opportunity for Users
How might we help users evaluate the quality of a rental apartment before signing a lease?
Business Opportunity
How might we leverage data collected by the NYC Department of Housing Preservation to reduce housing complaints, and resulting city operations costs?
Image 3: An example flow diagram I created to map user journeys through the product.
Process & Deliverables
1. Research
I drafted a research plan that included interviewing NYC representatives, brokers, landlords, and renters. The plan incorporated quantitative data from public housing records databases and polls posted in housing groups on Facebook and other social platforms. I also completed a usability audit of a portal the NYC Department of Housing uses to share building and unit information.
2. Competitor Analysis
I identified resources and platforms people could use to evaluate apartment quality. I evaluated the pros and cons of these platforms and how they might be used to meet user needs. You can read a summary of the top resources I discovered in this article I wrote for the benefit of people moving to New York City for the first time.
Image 4: I used a white board to explore different ways to meet user and business needs.
3. White Board Exploration
I quickly evaluated the problem at hand and possible solutions by diagramming information on a whiteboard.
Image 5: I did fast, very rough sketches to work through key screens and user decision points.
4. Sketches
I used my whiteboard exploration as a starting point for drafting very quick sketches of interfaces that would help users accomplish their goals.
5. Flow Diagrams
I designed user flow diagrams based on my sketches. You can see a first flow draft and second flow draft. I used these flow diagrams to establish the underlying architecture of the housing app.
Image 6: I created low- and mid-fidelity wireframes to identify potential issues before creating high-fidelity mockups.
6. Wireframes
I referenced flow diagrams and sketches to create wireframes that describe the process of (1) looking up violations for an apartment unit and (2) finding a building and accessing saved listings.
7. Testing Designs
I tested mid-fidelity designs with members of my target audience.
8. High-fidelity Designs
I created high-fidelity designs that reflected branding used by the NYC Department of Housing.
Problems Solved
Problem 1: Evaluating Quality
It is difficult to evaluate the condition, location, and history of an apartment.
Problem 2: Data Access
NYC Housing department data is useful but difficult to access because of the way it is presented.
Problem 3: Encouraging Landlords
Landlords are penalized if tenants complain about building conditions, but nothing encourages landlords to take action before conditions arise.
Image 7-8: Search suggestions on desktop and mobile. Shown on the right of each suggestion list are color-coded indicators that allow users to understand the violation status of a property at a glance, before even fully entering a query. Location data is also shown to help users who are at a unit viewing verify that they select the proper building.
Outcome 1: Evaluating Quality
Problem
It is difficult to evaluate the condition, location, and history of an apartment.
Exploration
I created a research plan to better understand the problem. It includes: interviews with renters, landlords, brokers, and housing authority personnel; competitive analysis of housing apps; polls posted in online housing groups; and observational studies of apartment viewings.
Solution
I created an application that can be used to access information about apartment quality quickly during an apartment viewing.  The information architecture reflects the way users would search for and evaluate units.
Image 9-10: Building overview shown on desktop and mobile. Iconography is used to make it faster and easier for users to scan lists of open building violations. Icons also make the database easier to use for people with different levels of reading ability, and for people who speak English as a second or other language- something that is especially relevant in a city as diverse as New York.
Outcome 2: Data Access
Problem
NYC Housing department data is useful but difficult to access because of the way it is presented.
Exploration
I conducted a usability audit of the current database and completed a competitor analysis. I created a research plan that involved observing users navigate the site and reviewing site usage analytics.
Solution
I redesigned the database from the perspective of a user who is viewing an apartment. I paired data with images and features that provide users with more context about a unit.
Image 11-12: Empty state for a building, on desktop and mobile. The empty state design frames a lack of violations as a sought-after positive by borrowing from design language used to represent email inbox empty states and social media verification status. A link to report violations is also featured for renters. This link highlights the ephemeral nature of "zero violation status" and streamlines the reporting process.
Outcome 3: Encouraging Landlords
Problem
Landlords are penalized if tenants complain about building conditions, but nothing encourages landlords to take action proactively before building issues occur.
Exploration
I created a research plan that includes interviews with landlords and a review of housing database analytics (in order to identify action taken on claims.)
Solution
I proposed creating features for the database that reinforce positive results, such as an empty state that frames a lack of violations as something to be desired. I framed this as a way to evaluate the return on investment of further work, such as management tools that let landlords and building staff monitor monitor violations and participate in social activity surrounding units.
Image 13-14: If there are multiple matches for search users are taken to a map view that can help them choose the correct building. Violation status is visible throughout the entire user journey.
Reflection
Project Status
This is a personal project. It is complete, but I occasionally revise and add to it in order to better illustrate my design process.
What I Learned
This project allowed me to explore different ways that task-focused interfaces can be used to distill complex data into insights that are sensible and actionable for end users.
What I Would Do Differently
Because this is a personal project, I made an extensive research plan but did not get to execute it; I read existing research on housing instead. I would like to have worked with landlords, renters, and housing officials to learn more about the complexities of the problem. I would have also liked to test the product on-site to better understand the context a user is operating in.
Next Steps
I have finished this project. I am sharing results and a prototype of the database with others.
Image 15: I conceptualized a product promotion campaign that would highlight buildings with zero violations on existing digital billboards across New York City. Advertisements would be personalized to show the building in question and would run on the same block as the building. This creates visibility for the product and raises awareness of building violation status.
Bonus: Positive Incentives for Change
Taking it Further
To further incentivize change I conceptualized a product promotion campaign that would leverage location data to advertise the status of buildings without violations. Advertisements would run on digital billboards used by the city to showcase public service announcements. Advertisements would be personalized to show the building in question and would run on the same block as the building. This level of personalization would drive resident awareness of the product and would encourage New Yorkers to look up buildings and log complaints. The visibility of such a campaign, if run often, would elevate lack of violations as a measure of quality that landlords could use to promote properties in their portfolio.
Image and reference credits:  [NYC branding] The City of New York. [NYC logo] Wolff Olins. [Images of buildings]  Google Maps. [95 Horatio] tfc.com. [LinkNYC] Crain's.