sfgov/registered-business-locations-san-francisco-g8m3-pdis

 
External

Registered Business Locations - San Francisco

  • business

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

To update your listing or look up your BAN see this FAQ: https://support.datasf.org/help/registered-business-faqs

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Parking Taxparking_taxparking_taxCheckboxWhether or not this business pays the parking tax
Transient Occupancy Taxtransient_occupancy_taxtransient_occupancy_taxCheckboxWhether or not this business pays the transient occupancy tax
Analysis Neighborhoods:@computed_region_ajp5_b2md:@computed_region_ajp5_b2mdNumberThis 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 (cloropleths) in the visualization canvas and data lens.
Neighborhoods:@computed_region_jwn9_ihcz:@computed_region_jwn9_ihczNumberThis 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 (cloropleths) in the visualization canvas and data lens.
SF Find Neighborhoods:@computed_region_6qbp_sg9q:@computed_region_6qbp_sg9qNumberThis 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 (cloropleths) in the visualization canvas and data lens.
Current Supervisor Districts:@computed_region_26cr_cadq:@computed_region_26cr_cadqNumberThis 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 (cloropleths) in the visualization canvas and data lens.
Current Police Districts:@computed_region_qgnn_b9vv:@computed_region_qgnn_b9vvNumberThis 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 (cloropleths) in the visualization canvas and data lens.
Mail Zipcodemail_zipcodemail_zipcodeText
Location End Datelocation_end_datelocation_end_dateCalendar dateEnd date at the location, if closed
Business End Datedba_end_datedba_end_dateCalendar dateEnd date of the business
Business Start Datedba_start_datedba_start_dateCalendar dateStart date of the business
Source Zipcodebusiness_zipbusiness_zipTextBusiness location zip code
NAICS Codenaic_codenaic_codeTextThe 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. See NAICS Codes tab in the attached data dictionary under About > Attachments.
LIC CodeliclicTextThe LIC code of the business, if multiple, separated by spaces
LIC Code Descriptionlic_code_descriptionlic_code_descriptionTextThe LIC code description ("multiple" if there are multiple codes for a business)
Neighborhoods - Analysis Boundariesneighborhoods_analysis_boundariesneighborhoods_analysis_boundariesTextThe Analysis Neighborhood in which the business location falls. Not applicable outside of San Francisco. Boundary reference: https://data.sfgov.org/d/p5b7-5n3h
Business Corridorbusiness_corridorbusiness_corridorTextThe Business Corridor in which the the business location falls, if it is in one. Not all business locations are in a corridor. Boundary reference: https://data.sfgov.org/d/h7xa-2xwk
StatestatestateTextBusiness location state
CitycitycityTextBusiness location city
Street Addressfull_business_addressfull_business_addressTextBusiness location street address
DBA Namedba_namedba_nameTextDoing Business As Name or Location Name
Ownership Nameownership_nameownership_nameTextBusiness owner(s) name
Location IdttxidttxidTextUnique identifier that combines certificate number, business number and location number.
Mail Statemail_statemail_stateTextMailing address state
Mail Addressmailing_address_1mailing_address_1TextAddress for mailing
Business Account Numbercertificate_numbercertificate_numberTextSeven digit number assigned to registered business accounts
NAICS Code Descriptionnaic_code_descriptionnaic_code_descriptionTextThe Business Activity that the NAICS code maps on to (multiple if there are multiple codes indicated for the business).
Location Start Datelocation_start_datelocation_start_dateCalendar dateStart date at the location
Business LocationlocationlocationPointThe latitude and longitude of the business location for mapping purposes.
Supervisor Districtsupervisor_districtsupervisor_districtTextThe Supervisor District in which the business location falls. Not applicable outside of San Francisco. Boundary reference: https://data.sfgov.org/d/xz9b-wyfc
Mail Citymail_citymail_cityTextMailing address city

Upstream Metadata