The dataset for this study was collected from various sources including Affordable Housing Communities Data, demographic information from the American Community Survey, OpenStreetMap road network, Points of Interest (POIs) data, General Transit Feed Specification (GTFS) data, and Longitudinal Employer-Household Dynamics (LEHD) data. You will need to download all the data from their sources except for the LEHD data.
The data was collected from the Sacramento Housing and Redevelopment Agency and the office of the State Treasurer which maintains a list of affordable housing projects. The data was then processed to identify and eliminate duplicates and old projects that were scrapped. The final list consisted of 149 affordable housing projects spread across the city. Demographic information like household income, number of family and non-family households, and number of occupied and vacant housing units were sourced from the 5-year estimates of 2020 American Community Survey data. The LEHD Origin-Destination Employment Statistics or LODES data were used to identify origin-destination matrix with census blocks with residences/homes as the origin and the census blocks with workplaces/ offices as the destination. Bike and Walk Network Data from OpenStreetMap and POIs Data from OpenStreetMap were also used in the study.