Quiet Trouble

Photo compiled by Dall-E
Photo compiled by Dall-E

Introduction:

The Topic and the Data:

The Topic:

This presentation will build on my previous investigation of troubled housing in Montgomery County (which was gathered by the Department of Housing and Community Affairs). This investigation aims to use the much more expansive data gathered from resolved and unresolved complaints made to the Office of Landlord-Tenant Affairs(within DHCA) to see if there is a connection between the complaints and the Department of Housing and Community Affairs findings.

The Data:

The DHCA and their investigators gathered the troubled housing data directly, while the OLTA “Complaints” data is a mix. For example, the “complaints” data is likely geotagged by the complainant and varies in accuracy. DHCA likely gathered the “Complaints” data almost entirely from the submissions of the “Landlord-Tenant Complaint Form,” found on DHCA’s pages. Importantly, these two datasets do not appear to have been linked, and the categories differ. However, both the “Troubled housing” dataset and the “Complaints” dataset have added location data, and it is by the location data and the ZIP code that I have decided to join these two datasets.

The variables I will be using are the number of complaints from tenants and landlords in relation to time. I will also look closer at possible correlations between the location of the mold, infestations, and eviction complaints from the “Complaints” data against the percentages of mold found, infestations, and severity ratings found in the “Troubled housing data.”

My motivation for taking a closer look at this datasset is partially out of an interest in two datasets that are surprisingly rich and have been underinvestigated (among the least downloaded datasets on DataMontgomery), but also becasue I believe tha decent housing/surroundings should be universal as it is essential for a flourishing life.

Tenants and Landlords:

Landlord-Tenant complaints vs Troubled Housing

Suspicous Absence: Complaints Data and the Troubled housing dataset

Explainer

MAP: The leaflet plot to the right displays, in blue, the location of troubled housing, in green the locations of complaints made by tenants and in red locations of complaints made by landlords.

The two blue markers point to two notable locations. Firstly, the housing complex known as “The Enclave” which was the subject of my last project and a good point of comparison. Secondly, “Kings View Apartments”, the place in Montgomery County with the highest proportion of landlord to tenant complaints, by at least a magnitude.

These markers also highlight a key challenge with this project, which was that none of the locations actually mapped onto each other directly from the troubled housing dataset to the complaints dataset. It is therefore not guaranteed that there were any complaints from locations named in the “troubled housing” data, which would be fairly unlikely. There are however one glaring absence from the complaints dataset, namely the area around “The Enclave”.

RIGHT:

Below we have two graphs, both graphing the relationship between time and complaints.

In the first graph we see how the process length has ballooned for certain cases, and how the backlog is periodically purged. It is also fairly easy to see how the pandemic may have led to an increase in this backlog.

In the second graph, we see how the number of complaints have in both cases remained fairly stable. However the number of tenant cases appear to be experiencing more month to month variance. I would be very interesting in hearing ideas for why that may be happening.

Wait Times

Wait times

Landlord complaints are stable, Tenant complaints merit investigation:

Do the troubled not complain?

Zip Map

Troubled Housing vs Tenant Complaints vs Landlord Complaints locations

Zip Map

The odd ones out:

With this map I hope to see how the severity rating from the “Troubled Housing” dataset’s geographic distribution would compare against the geographic distribution of the “Complaints” data.

Feel free to leaf through the four categories I have chosen to include here.

The severity rating is the average rating for the housing mentioned in the “Troubled Housing” data. It is therefore better as an indicator that there is troubled housing in that area. The popup however does include the number of designated units of both “troubled” housing and “at-risk” housing.

The median time in process is the median number of days it took to solve cases originating from that particular zip.

The percentage of cases relating to deposits describes the geografic distribution of security deposit complaints in the county. The darker the colour the higher the proportion of overall complaints about security deposits originated from that zip.

The final number here, percentage settled, is potentially the most flawed category. I attempted to create a category that represented the number of cases won my tenants. However in retrospect my approach was flawed.

Statistical Approaches

Wait Times

Analysis of Causes and the Troubled Housing Severity Rating

Explainer

Explainer

This is an attempt to find which variables from the complaints dataset might map well onto the severity rate dataset.

All the categories apart from severity rate and troubled units, come from the complaints data set.

Conclusion

A very positive result of this project was that I found out that DataMontgomery is pretty quick at responding to requests for explanations. A very important part of my dataset involved figuring out which cases belonged to tenants and which to landlords, however this was stored in acronyms that were not explained in the online README. While I made an educated guess, I was delighted to recieve a very promt email from dataMontgomery confirming my supsicions and providing me with a more detailed README. Delightful.

Yet this investigation did not yield any provable relationships in this dataset. However it does give an indication of interesting avenues to be explored in the future.

The next step for the joined dataset is to compare it to overall population levels, a direction I should have gone at the very start. By doing so it would be much simpler to determine the degree to which my results were the product of population density or poverty. There does appear to be some things going on in the scatterplots. For example wile the number of cases appear stable, the variance in new cases month over month is interesting. IN addition, it is easy to see when the office has decided to close cases that have been on the books for a long time, and it would be interesting to find out why that is such a sporadic and increasing practice.

Sources

Data cleaning documentation:

For the Housing complaints dataset:

https://rpubs.com/TheASM/1183121

For the troubled housing dataset:

https://rpubs.com/TheASM/1173865

Data Sources:

The Inverse Care Law: The Lancet. (1971). The Inverse Care Law. https://www.thelancet.com/journals/lancet/article/PIIS0140-6736(71)92410-X/fulltext

Rent Court Eviction (People’s Law):People’s Law. (n.d.). Rent Court/Eviction. https://www.peoples-law.org/rent-court-eviction

Montgomery County DHCA-OLTA:Montgomery County Department of Housing and Community Affairs (DHCA). (2024). DHCA Office of Landlord-Tenant Affairs. https://apps.montgomerycountymd.gov/DHCA-OLTA/

Montgomery County Landlord-Tenant Handbook:Montgomery County Department of Housing and Community Affairs (DHCA). (2024). Landlord-Tenant Handbook. https://www.montgomerycountymd.gov/DHCA/housing/landlordtenant/publications_forms.html#Landlord-Tenant%20Handbook

Housing Landlord-Tenant Disputes Data: Montgomery County. (2024). Housing Landlord-Tenant Disputes. https://data.montgomerycountymd.gov/Consumer-Housing/Housing-Landlord-Tenant-Disputes/a7k3-gmfn/about_data

Troubled Properties Analysis Data:Montgomery County. (2024). Troubled Properties Analysis. https://data.montgomerycountymd.gov/Consumer-Housing/Troubled-Properties-Analysis/bw2r-araf/about_data

Link to a memorandum from the Department of Housing and Commmunity Affairs regarding the state of housing and troubled properties in Montgomery County from September 15, 2023:

https://www.montgomerycountymd.gov/DHCA/Resources/Files/director/FY23%20Troubled%20Property%20Report-Final.pdf

Also I used Google’s API services to find and download missing location data.