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
A data dictionary can be downloaded from here:http://layers.sfplanning.org/PipelineDataDictionary.xlsx
Publishing Department: Planning
Dataset Link: https://data.sfgov.org/d/eduu-fkrk
| Field Name (opt. alias) | Field Definition | API Key |
|---|---|---|
| AFF_TARGET | 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 | cie | |
| CIE_EXIST | cie_exist | |
| CIENET | cienet | |
| CONTACT (Contact) | contact | |
| CONTACTPH (Contact Phone) | contactph | |
| DBIDESC (DBI Project Description) | dbidesc | |
| DESCRIPT (Planning Project Description) | descript | |
| ENTITLED | entitled | |
| HOTEL_ROOM_EXIST | hotel_room_exist | |
| HOTEL_ROOM_NET | hotel_room_net | |
| HOTEL_ROOM_PROP | hotel_room_prop | |
| Latitude | A geographic coordinate expressed in decimal degrees that specifies the north-south position of a point on the Earth's surface and assuming a WGS84 coordinate system. | latitude |
| Location (Geometry) | Contains the geometry of the record in Well Known Text (WKT) format. | location |
| Longitude | A geographic coordinate expressed in decimal degrees that specifies the east-west position of a point on the Earth's surface and assuming a WGS84 coordinate system. | longitude |
| MED (Medical Sq Feet) | Medical uses include hospitals and medical clinics. | med |
| MED_EXIST | med_exist | |
| MEDNET (Net Medical Sq Feet) | mednet | |
| MIPS | mips | |
| MIPS_EXIST | mips_exist | |
| MIPSNET | mipsnet | |
| NAMEADDR (NAMEADDR??) | nameaddr | |
| 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 |
| PD | pd | |
| PDR | pdr | |
| PDR_EXIST | pdr_exist | |
| PDRNET | pdrnet | |
| PLANAREA (Planning Area) | planarea | |
| PLANNER (Planner) | planner | |
| PROJECT_TYPE | project_type | |
| QTR | qtr | |
| RESTAURANT | restaurant | |
| RESTAURANTNET | restaurantnet | |
| RET (Retail/Entertainment Sq Feet) | Retail Includes retail trade, amusement and recreation services, and personal services located throughout the City. | ret |
| RET_EXIST | ret_exist | |
| RETNET (Net Retail/Entertainment) | retnet | |
| SECTION415 (Section 415 (Inclusionary) Units) | section415 | |
| SPONSOR (Sponsor Name) | sponsor | |
| SUPEDIST (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 | supedist |
| TENURE_TYPE | tenure_type | |
| TOTAL_GSF (Gross Square Footage) | total_gsf | |
| 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 | visit_exist | |
| VISITNET (Net Visitor Sq Feet) | visitnet | |
| YEAR | year | |
| YEAR_QTR | year_qtr |