Registered Business Locations - San Francisco
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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Parking Tax | parking_tax | parking_tax | Checkbox | Whether or not this business pays the parking tax |
| Transient Occupancy Tax | transient_occupancy_tax | transient_occupancy_tax | Checkbox | Whether or not this business pays the transient occupancy tax |
| Analysis Neighborhoods | :@computed_region_ajp5_b2md | :@computed_region_ajp5_b2md | Number | 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 (cloropleths) in the visualization canvas and data lens. |
| Neighborhoods | :@computed_region_jwn9_ihcz | :@computed_region_jwn9_ihcz | Number | 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 (cloropleths) in the visualization canvas and data lens. |
| SF Find Neighborhoods | :@computed_region_6qbp_sg9q | :@computed_region_6qbp_sg9q | Number | 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 (cloropleths) in the visualization canvas and data lens. |
| Current Supervisor Districts | :@computed_region_26cr_cadq | :@computed_region_26cr_cadq | Number | 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 (cloropleths) in the visualization canvas and data lens. |
| Current Police Districts | :@computed_region_qgnn_b9vv | :@computed_region_qgnn_b9vv | Number | 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 (cloropleths) in the visualization canvas and data lens. |
| Mail Zipcode | mail_zipcode | mail_zipcode | Text | |
| Location End Date | location_end_date | location_end_date | Calendar date | End date at the location, if closed |
| Business End Date | dba_end_date | dba_end_date | Calendar date | End date of the business |
| Business Start Date | dba_start_date | dba_start_date | Calendar date | Start date of the business |
| Source Zipcode | business_zip | business_zip | Text | Business location zip code |
| NAICS Code | naic_code | naic_code | Text | The 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 Code | lic | lic | Text | The LIC code of the business, if multiple, separated by spaces |
| LIC Code Description | lic_code_description | lic_code_description | Text | The LIC code description ("multiple" if there are multiple codes for a business) |
| Neighborhoods - Analysis Boundaries | neighborhoods_analysis_boundaries | neighborhoods_analysis_boundaries | Text | The Analysis Neighborhood in which the business location falls. Not applicable outside of San Francisco. Boundary reference: https://data.sfgov.org/d/p5b7-5n3h |
| Business Corridor | business_corridor | business_corridor | Text | The 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 |
| State | state | state | Text | Business location state |
| City | city | city | Text | Business location city |
| Street Address | full_business_address | full_business_address | Text | Business location street address |
| DBA Name | dba_name | dba_name | Text | Doing Business As Name or Location Name |
| Ownership Name | ownership_name | ownership_name | Text | Business owner(s) name |
| Location Id | ttxid | ttxid | Text | Unique identifier that combines certificate number, business number and location number. |
| Mail State | mail_state | mail_state | Text | Mailing address state |
| Mail Address | mailing_address_1 | mailing_address_1 | Text | Address for mailing |
| Business Account Number | certificate_number | certificate_number | Text | Seven digit number assigned to registered business accounts |
| NAICS Code Description | naic_code_description | naic_code_description | Text | The Business Activity that the NAICS code maps on to (multiple if there are multiple codes indicated for the business). |
| Location Start Date | location_start_date | location_start_date | Calendar date | Start date at the location |
| Business Location | location | location | Point | The latitude and longitude of the business location for mapping purposes. |
| Supervisor District | supervisor_district | supervisor_district | Text | The Supervisor District in which the business location falls. Not applicable outside of San Francisco. Boundary reference: https://data.sfgov.org/d/xz9b-wyfc |
| Mail City | mail_city | mail_city | Text | Mailing address city |