SF Residential Building Permits and Unit Changes

Columns

• building_permit_application_number: Unique identifier for the building permit application.
• permit_address: Physical address associated with the permit.
• permit_description: Textual description of the work, such as "ERECT 3-STORY... SINGLE FAMILY DWELLING".
• existing_units_in_PTS_database: Number of units existing prior to the permit work.
• proposed_units_in_PTS_database: Number of units proposed in the permit application.
• net_units: The net change in unit count resulting from the permit.
• net_units_completed: The number of units actually completed.
• first_completion_date: Date of the initial Certificate of Final Completion (CFC) or Temporary Certificate of Occupancy (TCO).
• latest_completion_date: Most recent completion date recorded.
• extremely_low_income_units: Count of units designated for extremely low-income households.
• very_low_income_units: Count of units designated for very low-income households.
• low_income_units: Count of units designated for low-income households.
• moderate_income_units: Count of units designated for moderate-income households.
• non_deed_restricted_moderate_income_units: Moderate-income units without deed restrictions.
• affordable_units: Total count of affordable units associated with the project.
• market_rate_units: Total count of market-rate units.
• estimated_affordable_units: Boolean indicator if affordability levels were estimated based on similar projects.
• supervisor_district: The distinct district number for the location.
• analysis_neighborhood: The specific neighbourhood name (e.g., Bayview Hunters Point, Mission).
• planning_district: The planning district classification (e.g., Richmond, South Central).
• plan_area: Specific planning area designation.
• permit_form_number: Form number classification.
• permit_type: Classification such as "Full BP" (Building Permit) or "Site Permit".
• issued_date: Date the permit was issued.
• authorization_date: Date the permit was authorised.
• zoning_district: Zoning classification code (e.g., RH-2, RH-1).
• project_affordability_type: Program type for affordability (e.g., Inclu: On-Site BMR).
• block_lot: Parcel identification number.
• project_id: Unique project identifier.
• actual_proposed_units: The validated count of proposed units.

Distribution

• Format: CSV (Comma Separated Values)
• Size: 1.55 MB
• Rows: Approximately 5,188 records (based on valid counts for key columns).
• Columns: 30 columns
• Update Frequency: Annually (typically on 1 April).

Usage

• Housing Policy Analysis: Tracking the growth or decline of housing stock to inform municipal policy.
• Affordability Studies: monitoring the production of units across different income brackets (AMI levels).
• Urban Planning: Analysing development trends across different supervisor districts and neighbourhoods.
• Real Estate Market Research: Understanding market-rate versus affordable housing construction ratios.

Coverage

• Geographic: San Francisco, California. Includes specific breakdowns by Supervisor District, Analysis Neighbourhood, and Planning District.
• Time Range: 2005 to Present. (Historical permit dates in the dataset range back to 1982, but the production tracking focus is post-2005).
• Demographic Scope: Covers various housing affordability levels including extremely low, very low, low, and moderate income.

License

Who Can Use It

• Urban Planners: For assessing neighbourhood density and zoning impact.
• Housing Advocates: To monitor the delivery of below-market-rate units.
• Data Journalists: For reporting on construction trends and housing crises.
• Local Government Analysts: To prepare reports on housing inventory and permit completion rates.

Dataset Name Suggestions

• San Francisco Housing Production & Affordability Since 2005
• SF Residential Building Permits and Unit Changes
• San Francisco Net Housing Units and Demographics
• SF Completed Housing Construction 2005-Present

Attributes