Registered Business Locations - San Francisco

This dataset includes the locations of businesses that pay taxes to the City and County of San Francisco. Each registered business may have multiple locations and each location is a single row. The Treasurer & Tax Collector’s Office collects this data through business registration applications, account update/closure forms, and taxpayer filings. The data is collected to help enforce the Business and Tax Regulations Code including, but not limited to: Article 6, Article 12, Article 12-A, and Article 12-A-1. http://sftreasurer.org/registration


Publishing Department: Treasurer-Tax Collector

Dataset Link: https://data.sfgov.org/d/g8m3-pdis

  • TTX-0013_DataDictionary_registered-businesses.xlsx
  • Field Name (opt. alias)Field DefinitionAPI Key
    Business Account NumberSeven digit number assigned to registered business accountscertificate_number
    Business CorridorThe Business Corridor in which the the business location falls, if it is in one. Not all business locations are in a corridor.business_corridor
    Business End DateEnd date of the businessdba_end_date
    Business LocationThe latitude and longitude of the business location for mapping purposes.location
    Business Start DateStart date of the businessdba_start_date
    CityBusiness location citycity
    DBA NameDoing Business As Name or Location Namedba_name
    LIC CodeThe LIC code of the business, if multiple, separated by spaceslic
    LIC Code DescriptionThe LIC code description ("multiple" if there are multiple codes for a business)lic_code_description
    Location End DateEnd date at the locationlocation_end_date
    Location IdLocation Identification Number. Each DBA has a unique LIN for location specific tax filingsttxid
    Location Start DateStart date at the locationlocation_start_date
    Mail AddressAddress for mailingmailing_address_1
    Mail CityMailing address citymail_city
    Mail StateMailing address statemail_state
    Mail ZipcodeMailing address zipcodemail_zipcode
    NAICS CodeThe North American Industry Classification System (NAICS) is a standard used by Federal statistical agencies for the purpose of collecting, analyzing and publishing statistical data related to the U.S. business economy. A subset of these are options on the business registration form used in the administration of the City and County's tax code. The registrant indicates the business activity on the City and County's tax registration forms. If multiple, separated by spaces.naic_code
    NAICS Code DescriptionThe NAICS code description (multiple if there are multiple codes indicated for the business). naic_code_description
    Neighborhoods - Analysis BoundariesThe Department of Public Health and the Mayor’s Office of Housing and Community Development, with support from the Planning Department, created 41 neighborhoods by grouping 2010 Census tracts, using common real estate and residents’ definitions for the purpose of providing consistency in the analysis and reporting of socio-economic, demographic, and environmental data, and data on City-funded programs and services. They are not codified in Planning Code nor Administrative Code. This boundary is produced by assigning Census tracts to neighborhoods based on existing neighborhood definitions used by Planning and MOHCD. A qualitative assessment was made to identify the appropriate neighborhood for a given tract based on understanding of population distribution and significant landmarks. Once all tracts have been assigned a neighborhood, the tracts were dissolved to produce these boundaries. You can see them at: https://data.sfgov.org/d/p5b7-5n3hneighborhoods_analysis_boundaries
    Ownership NameBusiness owner(s) nameownership_name
    Parking TaxWhether or not this business pays the parking taxparking_tax
    Source ZipcodeBusiness location zip codebusiness_zip
    StateBusiness location statestate
    Street AddressBusiness location street addressfull_business_address
    Supervisor DistrictThere 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-wyfcsupervisor_district
    Transient Occupancy TaxWhether or not this business pays the transient occupancy taxtransient_occupancy_tax