Loading...
Loading...
On the OCII Western Addition-Area 2 renewal footprint there are now about 21 subsidized developments and 914 units built mostly decades after 1950s-60
The real public data behind Forty Years of Public Subsidy on San Francisco's Western Addition Renewal Footprint. SF MOHCD Affordable Housing Portfolio, filtered to former-SFRA OCII project areas (Western Addition / Fillmore). Files are hosted here directly so the analysis is reproducible; analysis.py reads only these files and prints the figures the paper reports.
These files are hosted directly on Rooted Forward and load below as live spreadsheets. Sort by clicking a column header, filter rows with the search box, change page size, or use Export current view in any spreadsheet toolbar to save your filtered view in CSV, TSV, or JSON.
analysis.py
Reproducible pandas script. Verifies the developments file is a subset of the portfolio, isolates OCII Western Addition-Area 2 (21 developments / 914 units / 821 income-restricted), tabulates tenure a
Source: City and County of San Francisco, Mayor's Office of Housing and Community Development (MOHCD) / Office of Community Investment and Infrastructure (OCII), via DataSF
This file is not a tabular CSV. Use the download button above to save it locally.
fillmore-western-addition-developments.csv
Former-SFRA / OCII project-area slice of the SF MOHCD/OCII Affordable Housing Portfolio (DataSF aaxw-2cb8). Each row tagged with ocii_project_area; the OCII Western Addition-Area 2 footprint is 21 of
Source: City and County of San Francisco, Mayor's Office of Housing and Community Development (MOHCD) / Office of Community Investment and Infrastructure (OCII), via DataSF
License
Code MIT, derived data CC BY-NC 4.0 (DataSF MOHCD terms).
Public sources
What the cleaned archive will contain when complete. Column names and types may evolve until the archive ships.
| Column | Type | Description |
|---|---|---|
| mohcd_development_id | text | |
| development_name | text | |
| marketing_address | text | |
| marketing_zip_code | text | |
| supervisor_district | text | |
| city_analysis_marketing | text |
sf-mohcd-affordable-housing-portfolio.csv
Citywide SF MOHCD/OCII Affordable Housing Portfolio (DataSF aaxw-2cb8). The 325 developments-file rows are a strict subset of these 849 rows, so this file serves as the citywide comparison universe. C
Source: City and County of San Francisco, Mayor's Office of Housing and Community Development (MOHCD) / Office of Community Investment and Infrastructure (OCII), via DataSF
| planning_neighborhood | text |
| ocii_project_area | text |
| lead_agency_account_name | text |
| tenure | text |
| project_status | text |
| development_type | text |
| general_housing_program | text |
| housing_program_program_name | text |