Land use categories for every parcel in San Francisco. The land use categories are derived from a range of City and commercial databases. Where building square footages were missing from these databases they were derived from a LIDAR survey flown in 2007.<br><br>Land use categories are as follows (units are square feet):<br> CIE = Cultural, Institutional, Educational<br>MED = Medical<br>MIPS = Office (Management, Information, Professional Services)<br>MIXED = Mixed Uses (Without Residential)<br>MIXRES = Mixed Uses (With Residential)<br>PDR = Industrial (Production, Distribution, Repair)<br>RETAIL/ENT = Retail, Entertainment<br>RESIDENT = Residential<br>VISITOR = Hotels, Visitor Services<br>VACANT = Vacant<br>ROW = Right-of-Way<br>OPENSPACE = Open Space<br><br>Other attributes are:<br>RESUNITS = Residential Units<br>BLDGSQFT = Square footage data<br>YRBUILT = year built<br>TOTAL_USES = Business points from Dun & Bradstreet were spatially aggregated to the closest parcel, and this field is the sum of the square footage fields<br>The subsequent fields (CIE, MED, MIPS, RETAIL, PDER & VISITOR) were derived using the NAICS codes supplied in the Dun & Bradstreet dataset, and the previous TOTAL_USES column.<br><br>The determining factor for a parcel's LANDUSE is if the square footage of any non-residential use is 80% or more of its total uses. Otherwise it becomes MIXED.<br><br>In the case where RESIDENT use has some square footage of non-residential use, this is mainly accessory uses such as home businesses, freelancers, etc.
Last updated: March, 2016
Publishing Department: Planning
Dataset Link: https://data.sfgov.org/d/us3s-fp9q
| Field Name (opt. alias) | Field Definition | API Key |
|---|---|---|
| BLDGSQFT (Building Square Footage) | Building square feet at this parcel | bldgsqft |
| 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 |
| BLOCK_NUM (Assessor Block Number) | The full assessor's parcel number is comprised of two parts, the first being the block number. Blocks are assigned by the Office of the Assessor Recorder. You can see a block map here: https://data.sfgov.org/d/ndp2-nsue Blocks are officially recorded in physical block maps. You can find PDFs of those here: https://data.sfgov.org/d/2367-5au8 | block_num |
| CIE (Cultural, Institutional, Educational Sq Feet) | Total cultural, institutional or educational uses gross square feet at this parcel | cie |
| FROM_ST (From Street) | First number in the address range for the parcel | from_st |
| LANDUSE | Categorical land use | landuse |
| LOT_NUM (Assessor Lot Number) | The full assessor's parcel number is comprised of two parts, the second being the lot number. Lots are assigned by the Office of the Assessor Recorder and are captured within blocks. You can find a map of the lots here: https://data.sfgov.org/d/45et-ht7c | lot_num |
| MAPBLKLOT | Standard SF land parcel ID (not necessarily unique in most cases, should be here though) | mapblklot |
| MED (Medical Sq Feet) | Medical uses include hospitals and medical clinics. | med |
| MIPS (Office (Management, Information, Professional Services) Sq Feet) | Total management, information, or professional services (office) uses square feet at this parcel | mips |
| OBJECTID (ObjectID) | The system ID generated by Esri ArcGIS software. Not an administrative ID. | objectid |
| PDR (Production, Distribution, Repair Sq Feet) | Total production, distribution or repair (light industrial) uses gross square feet at this parcel | pdr |
| RESUNITS (Residential Units) | Number of residential units at this parcel | resunits |
| RETAIL (Retail/Entertainment Sq Feet) | Retail Includes retail trade, amusement and recreation services, and personal services located throughout the City. | retail |
| SHAPE_Area | ESRI supplied polygon area in square feet | shape_area |
| SHAPE_Leng | ESRI supplied polygon perimeter in feet | shape_leng |
| ST_TYPE | Street type (i.e. Ave, St, Blvd, Cir, etc.) | st_type |
| STREET (Street) | The name of the street without the type (e.g. Market) | street |
| the_geom (Geometry) | Contains the geometry of the record in Well Known Text (WKT) format. | the_geom |
| TO_ST (To Street) | Last number in the address range for the parcel | to_st |
| TOTAL_USES (Total Uses) | Total non-residential gross square feet (GSF) at this parcel | total_uses |
| VISITOR | Total visitor (hotel) uses gross square feet at this parcel | visitor |
| YRBUILT (Year Built) | Year built | yrbuilt |