Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Department of Building Inspection's Permit Tracking and the Planning Department's Project & Permit Tracking System, processed quarterly. For more information please see http://sf-planning.org/pipeline-report
Publishing Department: Planning
Dataset Link: https://data.sfgov.org/d/ua32-eewd
| Field Name (opt. alias) | Field Definition | API Key |
|---|---|---|
| AFF_TARGET | Affordable Units Target Household Income Category | aff_target |
| AFFORDABLE (Affordable Units) | affordable | |
| AFFORDABLENET (Net Affordable Units) | affordablenet | |
| BESTDATE (Best Date) | The date of the most recent action leading to the best known status value, i.e. a project's current pipeline status. For example, would be the date building permit application is filed if the best known status is equal to BP Filed) | bestdate |
| BESTSTAT (Best Status) | This is the best known status of the project, it can be one of the following: BP Approved - DBI approved building permit BP Issued - Project sponsor has picked up approved building permit (proxy measure for under construction) BP Reinstated - DBI reinstates a lapsed building permit (lapses after 1 year with no activity) BP Filed - Application for building permit filed with DBI PL Approved - All Planning actions approved PL Filed - Project application filed with the Planning Department Construction - Project is under construction | beststat |
| BLKLOT (Assessor Parcel Number) | An asessor's parcel number, or APN, is a number assigned to parcels of real property by the Office of the Assessor Recorder for purposes of identification and record-keeping. It is sometimes referred to as the blocklot in City data. It is made up of two parts, the Assessor Block Number and the Assessor Lot Number. You can find a map of the lots here: https://data.sfgov.org/d/45et-ht7c | blklot |
| CASENO (Planning Case Number) | The unique case number used to identify projects moving through the Planning Department. | caseno |
| CIE (Cultural, Institutional, Educational Sq Feet) | Proposed Cultural, Institutional or Educational square footage | cie |
| CIE_EXIST | Existing Cultural, Institutional or Educational square footage | cie_exist |
| CIENET (Net Cultural, Institutional, Educational Sq Feet) | Net additional Cultural, Institutional or Educational square footage | cienet |
| CONTACT (Contact) | contact | |
| CONTACTPH (Contact Phone) | contactph | |
| DBIDESC (DBI Project Description) | dbidesc | |
| DESCRIPT (Planning Project Description) | descript | |
| Entitled (Entitlement Status) | entitled | |
| HOTEL_ROOM_EXIST | Existing Hotel Rooms | hotel_room_exist |
| HOTEL_ROOM_NET | Net Additional Hotel Rooms | hotel_room_net |
| HOTEL_ROOM_PROP | Proposed Total Hotel Rooms | hotel_room_prop |
| Location 1 (Geometry) | Contains the geometry of the record in Well Known Text (WKT) format. | location_1 |
| MED (Medical Sq Feet) | Medical uses include hospitals and medical clinics. | med |
| MED_EXIST | Existing Medical square footage | med_exist |
| MEDNET (Net Medical Sq Feet) | mednet | |
| MIPS (Office (Management, Information, Professional Services) Sq Feet) | Proposed Office/MIPS total square footage | mips |
| MIPS_EXIST | Existing Office/MIPS gross square footage | mips_exist |
| MIPSNET (Net Office (Management, Information, Professional Services) Sq Feet) | Net added Office/MIPS square footage | mipsnet |
| NAMEADDR (NAMEADDR??) | nameaddr | |
| NEIGHBORHOOD (Neighborhood?) | neighborhood | |
| NET_GSF (Net Gross Square Footage) | Best interpreted as net new useable GSF with demolition of existing space subtracted (not total project gsf). | net_gsf |
| PDR (Production, Distribution, Repair Sq Feet) | Proposed Production, Distribution, Repair total square footage | pdr |
| PDR_EXIST | Existing Production, Distribution Repair gross square footage | pdr_exist |
| PDRNET (Net Production, Distribution, Repair Sq Feet) | Net added Production, Distribution, Repair square footage | pdrnet |
| PLAN_AREA | Planning Areas | plan_area |
| PLAN_DISTRICT | Planning Department Districts | plan_district |
| PLANNER (Planner) | planner | |
| PROJECT_TYPE | Project Land Use Type | project_type |
| RESTAURANT | Existing Restaurant gross square footage | restaurant |
| RESTAURANTNET | Proposed Restaurant Total square footage | restaurantnet |
| RET (Retail/Entertainment Sq Feet) | Retail Includes retail trade, amusement and recreation services, and personal services located throughout the City. | ret |
| RET_EXIST | Existing Retail gross square footage | ret_exist |
| RETNET (Net Retail/Entertainment) | retnet | |
| SECTION415 (Section 415 (Inclusionary) Units) | section415 | |
| SPONSOR (Sponsor Name) | sponsor | |
| supervisor (Supervisor District) | There are 11 members of the Board of Supervisors in San Francisco, each representing a geographic district. These are numbered 1 through 11. See the district boundaries here: https://data.sfgov.org/d/xz9b-wyfc | supervisor |
| TENURE_TYPE | Residential Tenure Type | tenure_type |
| TOTAL_GSF (Gross Square Footage) | total_gsf | |
| UNITS | Number of Dwelling Units | units |
| UNITSNET (Net Units) | Net dwelling units. The total number of units less any unit removals. | unitsnet |
| VISIT (Visitor Sq Feet) | Visitor (or Hotel) includes hotels and other lodging located throughout the City. | visit |
| VISIT_EXIST | Existing Hotel gross square footage | visit_exist |
| VISITNET (Net Visitor Sq Feet) | visitnet | |
| ZONING_DISTRICT | Zoning District | zoning_district |
| ZONING_GEN (Zoning Generalized) | zoning_gen | |
| ZONING_SIM (Zoning Use District) | Zoning regulations govern how land can be used in various geographic areas of San Francisco called "zoning use districts" (also known as "zoning," "zones" or "use districts"). For example, zoning regulations might: govern sizes and shapes of buildings; limit the number of units or apartments that can exists on a property; require the accommodation of car parking off of the street; set controls on planting street trees under certain circumstances; specify how late a business can remain open at night. For each use of land (also known as "land uses" or "uses") in any given zone, zoning regulations are specified in detail in a legislative policy document called the [San Francisco Planning Code](http://library.amlegal.com/nxt/gateway.dll/California/planning/planningcode?f=templates$fn=default.htm$3.0$vid=amlegal:sanfrancisco_ca$sync=1) You can access the districts data here: https://data.sfgov.org/d/8br2-hhp3 | zoning_sim |