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
Location IdttxidttxidtextLocation identifier
Business Account Numbercertificate_numbercertificate_numbertextSeven digit number assigned to registered business accounts
Ownership Nameownership_nameownership_nametextBusiness owner(s) name
DBA Namedba_namedba_nametextDoing Business As Name or Location Name
Street Addressfull_business_addressfull_business_addresstextBusiness location street address
CitycitycitytextBusiness location city
StatestatestatetextBusiness location state
Source Zipcodebusiness_zipbusiness_ziptextBusiness location zip code
Business Start Datedba_start_datedba_start_datecalendar_dateStart date of the business
Business End Datedba_end_datedba_end_datecalendar_dateEnd date of the business
Location Start Datelocation_start_datelocation_start_datecalendar_dateStart date at the location
Location End Datelocation_end_datelocation_end_datecalendar_dateEnd date at the location, if closed
Mail Addressmailing_address_1mailing_address_1textAddress for mailing
Mail Citymail_citymail_citytextMailing address city
Mail Zipcodemail_zipcodemail_zipcodetext
Mail Statemail_statemail_statetextMailing address state
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.
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).
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
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)
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
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
Business LocationlocationlocationpointThe latitude and longitude of the business location for mapping purposes.
UniqueIDuniqueiduniqueidtextUnique formula: @Value(ttxid)-@Value(certificate_number)-@Value(naic_code)-@Value(location_start_date)
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 (choropleths) 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 (choropleths) 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 (choropleths) in the visualization canvas and data lens.
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 (choropleths) 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 (choropleths) in the visualization canvas and data lens.

Upstream Metadata