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.
Publishing Department: Planning
Dataset Link: https://data.sfgov.org/d/k7mk-w2pq
| Field Name (opt. alias) | Field Definition | API Key |
|---|---|---|
| AFF_UNITS (Affordable Units) | affordable | |
| Alias | alias | |
| APN (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 | apn |
| APPLICANT (Sponsor Name) | sponsor | |
| 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 |
| BP_APPLNO (Building Permit Application Number) | bpapplno | |
| BP_DESC (DBI Project Description) | dbidesc | |
| CIE (Cultural, Institutional, Educational Sq Feet) | cie | |
| CONTACT (Contact) | contact | |
| CONTACTPH (Contact Phone) | contactph | |
| COST (Cost) | cost | |
| Entitlement (Entitlement Status) | entitlement | |
| FirstFiled (First Filed) | firstfiled | |
| HEIGHT_DISTRICT (Height and Bulk District) | height | |
| Location (Geometry) | Contains the geometry of the record in Well Known Text (WKT) format. | location |
| MED (Medical Sq Feet) | Medical uses include hospitals and medical clinics. | med |
| MIPS (Office (Management, Information, Professional Services) Sq Feet) | mips | |
| NAMEADDR (NAMEADDR??) | nameaddr | |
| NEIGHBORHOOD (Neighborhood?) | plnneighborhood | |
| NET_AFF_UNITS (Net Affordable Units) | affordablenet | |
| NET_CIE (Net Cultural, Institutional, Educational Sq Feet) | cienet | |
| 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 |
| NET_MED (Net Medical Sq Feet) | mednet | |
| NET_MIPS (Net Office (Management, Information, Professional Services) Sq Feet) | mipsnet | |
| NET_PDR (Net Production, Distribution, Repair Sq Feet) | pdrnet | |
| NET_RET (Net Retail/Entertainment) | retnet | |
| NET_UNITS (Net Units) | unitsnet | |
| NET_VISIT (Net Visitor Sq Feet) | visitnet | |
| PDR (Production, Distribution, Repair Sq Feet) | pdr | |
| PLAN_AREA | plnarea | |
| PLANNER (Planner) | planner | |
| PLN_CASENO (Planning Case Number) | The unique case number used to identify projects moving through the Planning Department. | plncaseno |
| PLN_DESC (Planning Project Description) | plndesc | |
| PLN_DISTRICT (Planning District) | plndistrict | |
| PROJECT_TYPE | projtype | |
| PROPUSE (Proposed Use) | bldguse | |
| RET (Retail/Entertainment Sq Feet) | Retail Includes retail trade, amusement and recreation services, and personal services located throughout the City. | ret |
| SECTION415 (Section 415 (Inclusionary) Units) | section415 | |
| SUPE_DISTRICT (Supervisor District) | supedist | |
| TENURE_TYPE (Section 415 (Inclusionary) Units) | sec415_tenure | |
| TOTAL_GSF (Gross Square Footage) | total_gsf | |
| UNITS | units | |
| VISIT (Visitor Sq Feet) | Visitor (or Hotel) includes hotels and other lodging located throughout the City. | visit |
| ZONING_DISTRICT | zoningdistname | |
| ZONING_GEN (Zoning Generalized) | zoninggen | |
| 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 |