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 |
|---|---|---|---|---|
| Location Id | ttxid | ttxid | text | Location identifier |
| Business Account Number | certificate_number | certificate_number | text | Seven digit number assigned to registered business accounts |
| Ownership Name | ownership_name | ownership_name | text | Business owner(s) name |
| DBA Name | dba_name | dba_name | text | Doing Business As Name or Location Name |
| Street Address | full_business_address | full_business_address | text | Business location street address |
| City | city | city | text | Business location city |
| State | state | state | text | Business location state |
| Source Zipcode | business_zip | business_zip | text | Business location zip code |
| Business Start Date | dba_start_date | dba_start_date | calendar_date | Start date of the business |
| Business End Date | dba_end_date | dba_end_date | calendar_date | End date of the business |
| Location Start Date | location_start_date | location_start_date | calendar_date | Start date at the location |
| Location End Date | location_end_date | location_end_date | calendar_date | End date at the location, if closed |
| Mail Address | mailing_address_1 | mailing_address_1 | text | Address for mailing |
| Mail City | mail_city | mail_city | text | Mailing address city |
| Mail Zipcode | mail_zipcode | mail_zipcode | text | |
| Mail State | mail_state | mail_state | text | Mailing address state |
| 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. |
| 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). |
| 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 |
| 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) |
| 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 |
| 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 |
| Business Location | location | location | point | The latitude and longitude of the business location for mapping purposes. |
| UniqueID | uniqueid | uniqueid | text | Unique formula: @Value(ttxid)-@Value(certificate_number)-@Value(naic_code)-@Value(location_start_date) |
| 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 (choropleths) 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 (choropleths) 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 (choropleths) in the visualization canvas and data lens. |
| 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 (choropleths) 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 (choropleths) in the visualization canvas and data lens. |