Registered Business Locations - San Francisco (from DataSF, pulled daily)

NEW!: Use the new Business Account Number lookup tool. SUMMARY 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. Business locations marked as “Administratively Closed” have not filed or communicated with TTX for 3 years, or were marked as closed following a notification from another City and County Department. 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. HOW TO USE THIS DATASET System migration in 2014: When the City transitioned to a new system in 2014, only active business accounts were migrated. As a result, any businesses that had already closed by that point were not included in the current dataset. 2018 account cleanup: In 2018, TTX did a major cleanup of dormant and unresponsive accounts and closed approximately 40,000 inactive businesses. To learn more about using this dataset watch this video. To update your listing or look up your BAN see this FAQ: Registered Business Locations Explainer Data pushed to ArcGIS Online on September 2, 2026 at 6:16 AM by SFGIS. Data from: https://data.sfgov.org/d/g8m3-pdis Description of dataset columns: UniqueID Unique formula: @Value(ttxid)-@Value(certificate_number) Business Account Number Seven digit number assigned to registered business accounts Location Id Location identifier Ownership Name Business owner(s) name DBA Name Doing Business As Name or Location Name Street Address Business location street address City Business location city State Business location state Source Zipcode Business location zip code Business Start Date Start date of the business Business End Date End date of the business Location Start Date Start date at the location Location End Date End date at the location, if closed Administratively Closed Business locations marked as “Administratively Closed” have not filed or communicated with TTX for 3 years, or were marked as closed following a notification from another City and County Department. Mail Address Address for mailing Mail City Mailing address city\n Mail State Mailing address state\n Mail Zipcode Mailing address zipcode Self-Reported NAICS Code Self-Reported NAICS Code (up to 6 digit) LIC Code The LIC code of the business, if multiple, separated by spaces LIC Code Description The LIC code description ("Multiple" if there are multiple codes for a business) LIC Code Descriptions List A list of all LIC code descriptions separated by semi-colon Parking Tax Whether or not this business pays the parking tax Transient Occupancy Tax Whether or not this business pays the transient occupancy tax Business Location The latitude and longitude of the business location for mapping purposes. Business Corridor The Business Corridor in which the the business location falls, if it is in one. Not all business locations are in a corridor.\n\nBoundary reference: https://data.sfgov.org/d/h7xa-2xwk\n Supervisor District The Supervisor District in which the business location falls. Not applicable outside of San Francisco. Boundary reference: https://data.sfgov.org/d/xz9b-wyfc Community Benefit District The Community Benefit District in which the business location falls. Not applicable outside of San Francisco. Boundary reference: https://data.sfgov.org/d/c28a-f6gs Neighborhoods - Analysis Boundaries The Analysis Neighborhood in which the business location falls. Not applicable outside of San Francisco.\n\nBoundary reference: https://data.sfgov.org/d/p5b7-5n3h\n data_as_of Timestamp when the record (row) was last updated in the source system. data_loaded_at Timestamp the data was loaded here (open data portal) Current Supervisor Districts This column was automatically created in order to record in what polygon from the dataset 'Current Supervisor Districts' (26cr-cadq) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. Analysis Neighborhoods This column was automatically created in order to record in what polygon from the dataset 'Analysis Neighborhoods' (ajp5-b2md) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. Neighborhoods This column was automatically created in order to record in what polygon from the dataset 'Neighborhoods' (jwn9-ihcz) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. SF Find Neighborhoods This column was automatically created in order to record in what polygon from the dataset 'SF Find Neighborhoods' (6qbp-sg9q) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. Current Police Districts This column was automatically created in order to record in what polygon from the dataset 'Current Police Districts' (qgnn-b9vv) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. Note: If no description was provided by DataSF, the cell is left blank. See the source data for more information.