home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

3,496 rows where NAICS Code Description = 5

View and edit SQL

Suggested facets: State, Mail State, NAICS Code, Parking Tax, Transient Occupancy Tax, LIC Code Description, Supervisor District, Business Corridor

NAICS Code Description

Link rowid Location Id Ownership Name DBA Name Street Address City State Source Zipcode Business Start Date Business End Date Location Start Date Location End Date Mail Address Mail City Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location
12 0005879-01-002 Clean A Rama Maintenance Servi Clean A Rama Maintenance Co 526 Columbus Ave 2nd Fl San Francisco 1 CA 1 94133 11 10/01/1968   10/01/2011   526 Columbus Ave 2nd Floor San Francisco 1 94133 9 CA 8100-8139 5 Certain Services 5 0 0     3 1 North Beach 6   526 COLUMBUS AVE San Francisco, CA 94133 (37.799794, -122.4094)
64 0025733-01-092 San Francisco Parking Inc City Park 1600 Egbert Ave San+francisco 8 CA 1 94124 8 10/01/1968 12/31/2015 08/12/2011 08/31/2014         8100-8139 5 Certain Services 5 0 0           1600 EGBERT AVE San Francisco, CA 94124
69 0152271-01-999 Decisionone Corp. Decisionone Inc. Po 3004 Frazer Pa Brisbane+q4068 3   0 5 01/29/1985   01/29/1985   426 W Lancaster Ave Devon 13 19333 29 PA 8100-8139 5 Certain Services 5 0 0            
72 0099397-01-001 Wong Louis K C Dot Printing & Stationery 828 Stockton St San Francisco 1 CA 1 94108 9 09/22/1976   09/22/1976 12/07/2015 828 Stockton St San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0           828 STOCKTON ST San Francisco, CA 94108 (37.793485, -122.407792)
88 0140431-01-001 Andrew L Gescheidt Etal Popular Mechanix 252 14th St San Francisco 1 CA 1 94103 25 03/28/1983   03/28/1983   252 14th St San Francisco 1 94103 32 CA 8100-8139 5 Certain Services 5 0 0 D23 Vehicle Repair Garage - Major 9 8 Mission 12   252 14TH ST San Francisco, CA 94103 (37.76835, -122.418982)
90 0025733-73-001 San Francisco Parking Inc Millennium Towers 301 Mission St San Francisco 1 CA 1 94105 7 10/01/1968 12/31/2015 06/01/2011 12/31/2015   San Francisco 1 99999 12   8100-8139 5 Certain Services 5 0 0     6 3 Financial District/South Beach 1   301 MISSION ST San Francisco, CA 94105 (37.790753, -122.396321)
97 0025733-74-001 San Francisco Parking Inc City Park Cnet 235 Second St San Francisco 1 CA 1 94107 22 10/01/1968 12/31/2015 01/01/2009 12/31/2015         8100-8139 5 Certain Services 5 0 0     6 3 Financial District/South Beach 1   235 SECOND ST San Francisco, CA 94107 (37.786079, -122.39736)
113 0025733-77-001 San Francisco Parking Inc City Park 923 Folsom St San Francisco 1 CA 1 94107 22 10/01/1968 12/31/2015 08/01/2013 09/30/2014   San Francisco 1 99999 12   8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   923 FOLSOM ST San Francisco, CA 94107 (37.780026, -122.403712)
157 0140525-01-001 Ko Kim Ping & Karen Ko Dry Cleaner & Tailoring 333 Columbus Ave San Francisco 1 CA 1 94133 11 04/01/1983   04/01/1983   333 Columbus Av San Francisco 1 94133 9 CA 8100-8139 5 Certain Services 5 0 0     3 1 Chinatown 7   333 COLUMBUS AVE San Francisco, CA 94133 (37.798348, -122.407444)
703 0086264-01-001 Lee Kelly Fung & Chow Charlie Hair Design 2539 Balboa St San Francisco 1 CA 1 94121 15 01/04/1975 09/12/2017 01/04/1975 09/12/2017         8100-8139 5 Certain Services 5 0 0     1 6 Outer Richmond 9   2539 BALBOA ST San Francisco, CA 94121 (37.776208, -122.486252)
756 0114067-01-001 Ng Lung Wah & William Ngs Cleaners 318 Divisadero St San Francisco 1 CA 1 94117 33 10/06/1978   10/06/1978   318 Divisadero St San Francisco 1 94117 80 CA 8100-8139 5 Certain Services 5 0 0     5 7 Haight Ashbury 32   318 DIVISADERO ST San Francisco, CA 94117 (37.772517, -122.437262)
915 0114489-02-001 Aristakessian Panos & Salpie Peter Panos 107 Geary St San Francisco 1 CA 1 94108 9 11/03/1978   10/31/2005   109 Geary St Floor 2 San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0     3 1 Financial District/South Beach 1   107 GEARY ST San Francisco, CA 94108 (37.787754, -122.405122)
928 0100185-02-001 Arcenio Rufo & Gloria Arcebie Coin Laundry 4000 Mission St San Francisco 1 CA 1 94112 28 08/18/1976   06/01/1999   550 Justin Dr San Francisco 1 94112 20 CA 8100-8139 5 Certain Services 5 0 0 H46 Auto Laundry Mech/pay-To-Operate Washing/dyeing 8 5 Outer Mission 35   4000 MISSION ST San Francisco, CA 94112 (37.733387, -122.426679)
929 0114489-03-001 Aristakessian Panos & Salpie San Francisco Tailors 109 Geary St #M San+francisco 8 CA 1 94108 9 11/03/1978   05/01/2006   109 Geary St Floor 2 San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0           109 GEARY ST M San Francisco, CA 94108 (37.787751, -122.405145)
1036 0114883-01-001 Jungmann Erwin Jungmanns Appliance 1018 Valencia St San Francisco 1 CA 1 94110 18 10/01/1978   10/01/1978 05/23/2017 1009 Valencia St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0     8 5 Mission 12   1018 VALENCIA ST San Francisco, CA 94110 (37.756546, -122.421092)
1080 0061811-01-001 Speedway Copy Systems Inc Speedway Copy Systems Inc 227 Front St San Francisco 1 CA 1 94111 35 04/21/1970   04/21/1970   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     3 1 Financial District/South Beach 1   227 FRONT ST San Francisco, CA 94111 (37.793841, -122.398886)
1091 0061811-01-002 Speedway Copy Systems Inc Speedway Copy Systems Inc 475 4th St San Francisco 1 CA 1 94107 22 04/21/1970   01/01/1985   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   475 4TH ST San Francisco, CA 94107 (37.779819, -122.398409)
1095 0061811-01-013 Speedway Copy Systems Inc Speedway Copy Systems Inc 300 Pine St San Francisco 1 CA 1 94104 1 04/21/1970   05/06/2011   475 4th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     3 1 Financial District/South Beach 1   300 PINE ST San Francisco, CA 94104 (37.792105, -122.400958)
1313 0349959-02-999 D & D Compressor Inc D & D Compressor Inc 258 Kinney Dr San+jose 26 CA 1 95112 49 10/26/2001   01/01/2013   258 Kinney Dr San Jose 10 95112 25 CA 8100-8139 5 Certain Services 5 0 0           258 KINNEY DR SAN JOSE, CA 95112 (37.359009, -121.900826)
1774 0029519-01-001 Valente Marini Perata Co Corp Valente Marini Perata Co Corp 4840 Mission St San Francisco 1 CA 1 94112 28 10/01/1968   10/01/1968   4840 Mission St San Francisco 1 94112 20 CA 8100-8139 5 Certain Services 5 0 0     11 Outer Mission 35   4840 MISSION ST San Francisco, CA 94112 (37.720366, -122.438075)
1997 0385475-01-003 Zenanli Parking Inc Zenanli Parking Inc 61 Oak Grove St San Francisco 1 CA 1 94107 22 03/15/2005   08/01/2012   344 14th St San Francisco 1 94103 32 CA 8100-8139 5 Certain Services 5 1 0     6 3 South of Market 15   61 OAK GROVE ST San Francisco, CA 94107 (37.777532, -122.402179)
2083 0087987-01-001 Lee Irene Lee Irene Decorator Service 31-1/2 Wavery Pl San+francisco 8 CA 1 94108 9 07/01/1974   12/31/2003   31-1/2 Waverly Pl San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0           31 1 2 WAVERY PL San Francisco, CA 94108
2392 0398630-01-999 Abbott Kerry Kerry Abbott 41 Calvert Ct Oakland 16 CA 1 94611 105 05/15/2006   05/15/2006   41 Calvert Ct Piedmont 83 94611 124 CA 8100-8139 5 Certain Services 5 0 0           41 CALVERT CT OAKLAND, CA 94611 (37.826205, -122.221888)
2419 0143285-02-001 Thomas I Pendergast Inc Coast Truck Rental 2955 3rd St San Francisco 1 CA 1 94107 22 05/01/1983   05/01/1983   2955 3rd St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     10 4 Bayview Hunters Point 4   2955 3RD ST San Francisco, CA 94107 (37.752045, -122.387607)
2434 0143285-03-001 Thomas I Pendergast Inc Rent-A-Wreck Of Sf 2955 3rd St San Francisco 1 CA 1 94107 22 05/01/1983   10/01/1992   2955 3rd St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0 P02 Driverless Auto Rent 10 4 Bayview Hunters Point 4   2955 3RD ST San Francisco, CA 94107 (37.752045, -122.387607)
2466 0143285-07-001 Thomas I Pendergast Inc Coast Truck And Auto Rental 2955 3rd St San Francisco 1 CA 1 94107 22 05/01/1983   10/01/2004   2955 3rd St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     10 4 Bayview Hunters Point 4   2955 3RD ST San Francisco, CA 94107 (37.752045, -122.387607)
2730 0015455-01-001 Arden Wood Inc Arden Wood Inc 400 West Portal Ave San Francisco 1 CA 1 94127 31 04/21/1975   04/21/1975   445 Wawona St San Francisco 1 94116 45 CA 8100-8139 5 Certain Services 5 0 0     7 9 West of Twin Peaks 26   400 WEST PORTAL AVE San Francisco, CA 94127 (37.736636, -122.470664)
2839 0144123-01-001 Siem Frank Tt Auto Sports Haus 632 Ellis St San Francisco 1 CA 1 94109 24 01/15/1984   09/01/2008   632 Ellis St San Francisco 1 94109 7 CA 8100-8139 5 Certain Services 5 0 0 D23 Vehicle Repair Garage - Major       632 ELLIS ST San Francisco, CA 94109 (37.784375, -122.416713)
3308 0063107-01-011 California Parking Company Cal Parking Co 400 Taylor St San Francisco 1 CA 1 94102 16 01/01/1972   01/01/1972   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     3 1 Tenderloin 11   400 TAYLOR ST San Francisco, CA 94102 (37.786005, -122.411337)
3315 0063107-01-016 California Parking Company Cal Parking Co 1 Franklin St San Francisco 1 CA 1 94102 16 01/01/1972   01/01/1988 02/28/2015 Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 0 0     5 7 Hayes Valley 10   1 FRANKLIN ST San Francisco, CA 94102 (37.774489, -122.420816)
3338 0063107-01-017 California Parking Company Cal Parking Co 15 Oak St San Francisco 1 CA 1 94102 16 01/01/1972   01/01/1988 01/01/2011 Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 0 0     5 7 Hayes Valley 10   15 OAK ST San Francisco, CA 94102 (37.775382, -122.419612)
3370 0063107-01-020 California Parking Company Cal Parking Co 110 Franklin St San Francisco 1 CA 1 94102 16 01/01/1972   01/01/1989   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     5 7 Hayes Valley 10   110 FRANKLIN ST San Francisco, CA 94102 (37.77546, -122.421026)
3371 0063107-01-031 California Parking Company Cal Parking Co 690 Harrison St San Francisco 1 CA 1 94107 22 01/01/1972   12/01/1999   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 Financial District/South Beach 1   690 HARRISON ST San Francisco, CA 94107 (37.78271, -122.397223)
3373 0063107-01-034 California Parking Company Cal Parking Co 625 Minna St San Francisco 1 CA 1 94103 25 01/01/1972   08/01/1997   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 South of Market 15   625 MINNA ST San Francisco, CA 94103 (37.778313, -122.410997)
3390 0063107-01-035 California Parking Company Cal Parking Co 645 Minna St San Francisco 1 CA 1 94103 25 01/01/1972   08/01/1997   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 South of Market 15   645 MINNA ST San Francisco, CA 94103 (37.777987, -122.411418)
3396 0063107-01-045 California Parking Company Cal Parking Co 470 Brannan St San Francisco 1 CA 1 94107 22 01/01/1972   01/01/1999   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 South of Market 15   470 BRANNAN ST San Francisco, CA 94107 (37.778762, -122.395982)
3423 0063107-01-047 California Parking Company Cal Parking Co 730 Harrison St San Francisco 1 CA 1 94110 18 01/01/1972   01/01/1999 05/15/2015 Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   730 HARRISON ST San Francisco, CA 94110 (37.781897, -122.398229)
3429 0063107-01-049 California Parking Company Cal Parking Co 1266 Market St San Francisco 1 CA 1 94102 16 01/01/1972   01/01/1999   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 Tenderloin 11   1266 MARKET ST San Francisco, CA 94102 (37.778115, -122.415525)
3442 0063107-01-050 California Parking Company Cal Parking Co 550 North Point San+francisco 8 CA 1 94133 11 01/01/1972   10/01/2002   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0           550 NORTH POINT San Francisco, CA 94133 (37.806253, -122.416227)
3445 0063107-01-055 California Parking Company Cal Parking Co 200 Hyde St San Francisco 1 CA 1 94102 16 01/01/1972   11/01/2012   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 Tenderloin 11   200 HYDE ST San Francisco, CA 94102 (37.782772, -122.415745)
3476 0063107-01-056 California Parking Company Cal Parking Co 635 Sansome St San Francisco 1 CA 1 94111 35 01/01/1972   01/01/2013   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     3 1 Chinatown 7   635 SANSOME ST San Francisco, CA 94111 (37.796203, -122.401777)
3486 0063107-01-057 California Parking Company Cal Parking Co 180 Jones St San Francisco 1 CA 1 94102 16 01/01/1972   07/15/2013   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 Tenderloin 11   180 JONES ST San Francisco, CA 94102 (37.782881, -122.412397)
3531 0063107-03-006 California Parking Company Cal Parking Co - Valet 525 Market St San Francisco 1 CA 1 94105 7 01/01/1972   01/01/2003   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 Financial District/South Beach 1   525 MARKET ST San Francisco, CA 94105 (37.790742, -122.399546)
3559 0063107-05-001 California Parking Company California Parking Co 660 Sutter Street San Francisco 1 CA 1 94104 1 01/01/1972   07/01/2005   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     3 1 Nob Hill 17   660 SUTTER STREET San Francisco, CA 94104 (37.788895, -122.411276)
3581 0063107-06-001 California Parking Company California Parking 665 Sutter St San Francisco 1 CA 1 94104 1 01/01/1972   07/01/2006   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     3 1 Nob Hill 17   665 SUTTER ST San Francisco, CA 94104 (37.788886, -122.411343)
3595 0063107-07-001 California Parking Company Cal Parking 2351 Mission St San Francisco 1 CA 1 94110 18 01/01/1972   11/01/2006   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     9 8 Mission 12   2351 MISSION ST San Francisco, CA 94110 (37.759172, -122.4191)
3608 0063107-08-001 California Parking Company Cal Parking 24 Florida St San Francisco 1 CA 1 94103 25 01/01/1972   09/01/2006   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     9 8 Mission 12   24 FLORIDA ST San Francisco, CA 94103 (37.768615, -122.411784)
3615 0063107-10-001 California Parking Company California Parking Company 501 Filbert San+francisco 8 CA 1 94126 144 01/01/1972   08/01/2009   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0           501 FILBERT San Francisco, CA 94126 (37.801557, -122.407957)
3626 0063107-13-001 California Parking Company Cal Parking Co 201 Alabama San+francisco 8 CA 1 94103 25 01/01/1972   01/13/2011   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0           201 ALABAMA San Francisco, CA 94103 (37.767649, -122.412554)
3629 0063107-13-003 California Parking Company Cal Parking Co 801 Bryant St San Francisco 1 CA 1 94103 25 01/01/1972   07/01/2012   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0     6 3 South of Market 15   801 BRYANT ST San Francisco, CA 94103 (37.776043, -122.402539)
3632 0063107-15-001 California Parking Company California Parking Company 2620 Jones St San Francisco 1 CA 1 94133 11 01/01/1972   01/01/1972 09/08/2013 Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 0 0           2620 JONES ST SAN FRANCISCO, CA 94133 (37.805223, -122.416883)
3640 0145209-01-001 Schultz Len Co Len Schultz Co 166 Geary St 609 San Francisco 1 CA 1 94108 9 02/01/1984   03/18/2009 09/15/2016 166 Geary St Ste 609 San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0           166 GEARY ST San Francisco, CA 94108 (37.787634, -122.406098)
3642 0063107-16-001 California Parking Company California Parking Co 25 Lusk St San Francisco 1 CA 1 94107 22 01/01/1972   07/01/2013 08/31/2014 Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   25 LUSK ST San Francisco, CA 94107 (37.778396, -122.394416)
3643 0145209-02-001 Schultz Len Co I Hair Salon 166 Geary St 609 San Francisco 1 CA 1 94108 9 02/01/1984   03/18/2009 09/15/2016 166 Geary St Ste 609 San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0           166 GEARY ST San Francisco, CA 94108 (37.787634, -122.406098)
3660 0063107-17-001 California Parking Company Cal Parking - Valet 201 Alabama St San Francisco 1 CA 1 94103 25 01/01/1972   02/28/2014   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 0 0           201 ALABAMA ST SAN FRANCISCO, CA 94103 (37.767649, -122.412554)
4354 0131015-01-002 Weight Watchers North Amer In Weight Watchers 577 Buckingham Way San Francisco 1 CA 1 94132 32 03/01/1998   03/01/1998 05/17/2013 999 Stewart Avenue Ste 215 Bethpage 238 11714 342 NY 8100-8139 5 Certain Services 5 0 0     7 9 Lakeshore 31   577 BUCKINGHAM WAY SAN FRANCISCO, CA 94132 (37.730141, -122.476618)
4368 0131015-03-001 Weight Watchers North Amer In Weight Watchers North America 555 Buckingham Way San Francisco 1 CA 1 94132 32 03/01/1998   05/17/2013 02/05/2015 999 Stewart Avenue Ste 215 Bethpage 238 11714 342 NY 8100-8139 5 Certain Services 5 0 0     7 9 Lakeshore 31   555 BUCKINGHAM WAY San Francisco, CA 94132 (37.730129, -122.477147)
4373 0131015-04-001 Weight Watchers North Amer In Weight Watchers North America Inc 50 Post St 19 San Francisco 1 CA 1 94104 1 03/01/1998   05/28/2013   999 Stewart Avenue Ste 215 Bethpage 238 11714 342 NY 8100-8139 5 Certain Services 5 0 0 H03 Retail Mkts W/o Prep (Under 5,001) 3 1 Financial District/South Beach 1   50 POST ST San Francisco, CA 94104 (37.788992, -122.402927)
4383 0303711-01-014 Pitney Bowes Management Svcs Pitney Bowes Management Svcs 600 Montgomery St San Francisco 1 CA 1 94111 35 12/31/2013   01/01/2011 01/01/2014 8000 Po Box Monsey 241 10952 345 NY 8100-8399 38 Certain Services 5 0 0     3 1 Chinatown 7   600 MONTGOMERY ST San Francisco, CA 94111 (37.795131, -122.403236)
4386 0303711-01-021 Pitney Bowes Management Svcs Pitney Bowes Management Svcs 101 California St San Francisco 1 CA 1 94111 35 12/31/2013   01/01/2011 01/01/2014 8000 Po Box Monsey 241 10952 345 NY 8100-8399 38 Certain Services 5 0 0     3 1 Financial District/South Beach 1   101 CALIFORNIA ST San Francisco, CA 94111 (37.793416, -122.397991)
4428 0145839-01-999 Gottschalk Peter J Peters Repair Service 631 No San Pedro Rd San+rafael 22 CA 1 94903 79 01/01/1984   10/01/1997   631 North San Pedro San Rafael 20 94903 69 CA 8100-8139 5 Certain Services 5 0 0           631 NO SAN PEDRO RD SAN RAFAEL, CA 94903 (38.012726, -122.506021)
4677 0119930-01-001 Smith David W One Of A Kind Hair Designers 1715 Noriega St San Francisco 1 CA 1 94122 19 09/05/1979   09/05/1979   1715 Noriega St San Francisco 1 94122 15 CA 8100-8139 5 Certain Services 5 0 0           1715 NORIEGA ST SAN FRANCISCO, CA 94122 (37.753999, -122.481978)
5008 0092020-01-001 Shinazy Enterprises Inc Dons Auto Body-Various 1267 Bush St San Francisco 1 CA 1 94109 24 08/01/1975   08/01/1975   1270 Bush St San Francisco 1 94109 7 CA 8100-8139 5 Certain Services 5 0 0 D10 D23 Multiple 3 1 Nob Hill 17   1267 BUSH ST San Francisco, CA 94109 (37.788975, -122.418135)
5032 0092020-01-002 Shinazy Enterprises Inc Dons Auto Body-Various 1270 Bush St San Francisco 1 CA 1 94109 24 08/01/1975   01/01/1991   1270 Bush St San Francisco 1 94109 7 CA 8100-8139 5 Certain Services 5 0 0 D23 Vehicle Repair Garage - Major 3 1 Nob Hill 17   1270 BUSH ST San Francisco, CA 94109 (37.788978, -122.418109)
5043 0092020-07-001 Shinazy Enterprises Inc Dons Auto Body On Clement St 2535 Clement St San Francisco 1 CA 1 94122 19 08/01/1975   10/01/1999   1270 Bush St San Francisco 1 94109 7 CA 8100-8139 5 Certain Services 5 0 0 D10 D23 Multiple 1 6 Outer Richmond 9   2535 CLEMENT ST San Francisco, CA 94122 (37.781933, -122.486521)
5081 0006977-01-001 D & J Parking Inc D & J Parking Inc 768 Sansome St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   Po Box 2882 San Francisco 1 94126 285 CA 8100-8139 5 Certain Services 5 1 0           768 SANSOME ST San Francisco, CA 94111 (37.79729, -122.402002)
5089 0092020-08-001 Shinazy Enterprises Inc Botta's Auto Body 3536 Sacramento St San Francisco 1 CA 1 94118 6 08/01/1975   01/01/1994   1270 Bush St San Francisco 1 94109 7 CA 8100-8139 5 Certain Services 5 0 0 D10 D23 Multiple       3536 SACRAMENTO ST San Francisco, CA 94118 (37.787683, -122.450918)
5097 0092020-09-999 Shinazy Enterprises Inc Dons Of San Mateo 130 S Amphlett San+mateo 61 CA 1 94401 178 08/01/1975   01/15/2004   1270 Bush St San Francisco 1 94109 7 CA 8100-8139 5 Certain Services 5 0 0           130 S AMPHLETT SAN MATEO, CA 94401 (37.572344, -122.31606)
5181 0092741-01-001 F Lofrano & Son Inc Lofrano F & Son Inc 1745 Divisadero St San Francisco 1 CA 1 94115 4 06/01/1975   06/01/1975   3355 17th St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0 D10 D23 Multiple 2 Pacific Heights 16   1745 DIVISADERO ST San Francisco, CA 94115 (37.785661, -122.440008)
5187 0092741-01-002 F Lofrano & Son Inc Lofrano F & Son Inc 1355 Fulton St San Francisco 1 CA 1 94117 33 06/01/1975   07/01/1995   3355 17th St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0 D10 D23 Multiple 5 7 Hayes Valley 10   1355 FULTON ST San Francisco, CA 94117 (37.776756, -122.439094)
5190 0120311-01-001 Santana Dolores R Eves Garden Of Beauty 966 Geneva Ave San Francisco 1 CA 1 94112 28 10/01/1979   10/01/1979   966 Geneva Av San Francisco 1 94112 20 CA 8100-8139 5 Certain Services 5 0 0     11 Excelsior 23   966 GENEVA AVE San Francisco, CA 94112 (37.715911, -122.440091)
5193 0092741-01-003 F Lofrano & Son Inc Lofrano F & Son Inc 3355 17th St San Francisco 1 CA 1 94110 18 06/01/1975   05/11/1994   3355 17th St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0 D10 D23 Multiple 9 8 Mission 12   3355 17TH ST San Francisco, CA 94110 (37.76337, -122.420746)
5477 0120586-01-999 Bowen H A Electric Inc Bowen H A Electric Inc 2055 Williams St San+leandro 15 CA 1 94577 36 10/15/1979   10/15/1979   2055 Williams St San Leandro 25 94577 49 CA 8100-8139 5 Certain Services 5 0 0           2055 WILLIAMS ST SAN LEANDRO, CA 94577 (37.709987, -122.178136)
5634 0147106-01-001 Tu Nu Nhi Sakura Hair Design 855 Washington St 200 San Francisco 1 CA 1 94108 9 06/13/1984   06/13/1984   855 Washington St #2fl San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0     3 1 Chinatown 7   855 WASHINGTON ST San Francisco, CA 94108 (37.795013, -122.407536)
5702 0045018-01-999 Aramark Unif Career Apprl Llc Aramark Service Inc 440 N Canal St S+san+fran 9 CA 1 94080 17 10/01/1968 07/28/2017 01/01/1996 07/28/2017         8100-8139 5 Certain Services 5 0 0           440 N CANAL ST S SAN FRAN, CA 94080 (37.651179, -122.415926)
5709 0045018-02-001 Aramark Unif Career Apprl Llc Galls/long Beach Uniform 1740 Cesar Chavez St. San Francisco 1 CA 1 94124 8 10/01/1968 07/28/2017 02/01/2005 07/28/2017         8100-8139 5 Certain Services 5 0 0     10 4 Bayview Hunters Point 4   1740 CESAR CHAVEZ ST San Francisco, CA 94124
5716 0147384-01-001 Yi Son Chae Fortune Cleaner 2751 21st St San Francisco 1 CA 1 94110 18 01/01/1993   01/01/1993   2751 21st St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0 D30 Dry Cleaning Plant 9 8 Mission 12   2751 21ST ST San Francisco, CA 94110 (37.757576, -122.4099)
5732 0045018-03-999 Aramark Unif Career Apprl Llc Aramark Uniform Services 115 N First St Burbank 131 CA 1 91502 207 10/01/1968 07/28/2017 02/04/2008 07/28/2017         8100-8139 5 Certain Services 5 0 0           115 N FIRST ST BURBANK, CA 91502 (34.180265, -118.310817)
5735 0147384-03-001 Yi Son Chae Mimis Cleaners 410 Dewey Blvd San Francisco 1 CA 1 94116 23 01/01/1993   05/17/1999   2751 21st St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0     7 9 West of Twin Peaks 26   410 DEWEY BLVD San Francisco, CA 94116 (37.747097, -122.459426)
6062 0121453-02-001 Dubinovsky Isaak Babylon Beauty Salon 5842 Geary Blvd San Francisco 1 CA 1 94121 15 12/15/1979   04/19/2008   5842 Geary Boulevard San Francisco 1 94121 17 CA 8100-8139 5 Certain Services 5 0 0     1 6 Outer Richmond 9   5842 GEARY BLVD San Francisco, CA 94121 (37.780271, -122.482213)
6133 0147970-01-001 Debbane Eric P Smile Center The 2515a Mission St San Francisco 1 CA 1 94110 18 03/01/1984   08/01/2011   2515a Mission St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0     9 8 Mission 12   2515A MISSION ST San Francisco, CA 94110 (37.7567, -122.418868)
6135 0147972-04-001 Chan Victor Sik Chau Celebrity Cleaners & Alter Ser 123 Mission St San Francisco 1 CA 1 94105 7 06/01/1984   10/02/2003   1749 Ofarrell Street Ground Floor San Francisco 1 94115 2 CA 8100-8139 5 Certain Services 5 0 0     6 3 Financial District/South Beach 1   123 MISSION ST San Francisco, CA 94105 (37.792099, -122.39462)
6241 0021489-01-001 Pac Auxiliary Fire Alarm Co Pac Auxiliary Fire Alarm Co 95 Boutwell St San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   95 Boutwell St San Francisco 1 94124 6 CA 8100-8139 5 Certain Services 5 0 0     10 4 Bayview Hunters Point 4   95 BOUTWELL ST San Francisco, CA 94124 (37.736663, -122.405767)
6813 0134460-01-001 Waterfront Automobili Inc Waterfront Automobili Inc 1127 Mission St San Francisco 1 CA 1 94103 25 01/01/1981   01/01/1981 01/05/2015 1301 17th St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   1127 MISSION ST San Francisco, CA 94103 (37.778737, -122.411537)
6921 0134599-03-001 Macdonald Roderick 1200 Howard St Bldg 1200 Howard St San Francisco 1 CA 1 94103 25 09/15/1980   09/15/1980   1200a Howard St San Francisco 1 94103 32 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   1200 HOWARD ST San Francisco, CA 94103 (37.776223, -122.411611)
6986 0934818-09-001 Wong Kevin Abc Parking 1399 Bush St San Francisco 1 CA 1 94109 24 10/02/1994   05/01/2010 01/31/2012 225 2nd Ave #1 San Francisco 1 94118 28 CA 8100-8139 5 Certain Services 5 0 0           1399 BUSH ST SAN FRANCISCO, CA 94109 (37.788698, -122.420312)
7255 0351396-02-001 Huang Wei Hsuan Vcd Zone 2002 2004 Irving St San Francisco 1 CA 1 94122 19 01/01/2002   01/01/2005   2004 Irving St San Francisco 1 94122 15 CA 8100-8399 38 Certain Services 5 0 0     4 10 Sunset/Parkside 14   2004 IRVING ST San Francisco, CA 94122 (37.763476, -122.479317)
7297 0122910-01-001 Guajardo Valentine L Guajardos 1134a Geneva Ave San Francisco 1 CA 1 94112 28 03/07/1980   03/07/1980   1134 Geneva Ave #A San Francisco 1 94112 20 CA 8100-8139 5 Certain Services 5 0 0     11 Excelsior 23   1134A GENEVA AVE San Francisco, CA 94112 (37.71466, -122.437295)
7458 0136032-01-001 Butler Henry A Valesco Complete Janitor Serv 10 Augusta St San Francisco 1 CA 1 94124 8 01/01/1982   01/01/1997   10 Augusta St San Francisco 1 94124 6 CA 8100-8139 5 Certain Services 5 0 0     10 4 Bayview Hunters Point 4   10 AUGUSTA ST San Francisco, CA 94124 (37.734478, -122.402412)
7464 0108871-01-001 Nihonmachi Parking Corp Nihonmachi Parking Corp. 1650 Webster St San Francisco 1 CA 1 94115 4 01/01/1975   01/01/1975   1832 Buchanan St #202 San Francisco 1 94115 2 CA 8100-8139 5 Certain Services 5 1 0     5 7 Japantown 22   1650 WEBSTER ST San Francisco, CA 94115 (37.786451, -122.431517)
7479 0108871-01-002 Nihonmachi Parking Corp Nihonmachi Parking Corp. 616 Hemlock St San Francisco 1 CA 1 94115 4 01/01/1975   01/01/1975   1832 Buchanan St #202 San Francisco 1 94115 2 CA 8100-8139 5 Certain Services 5 1 0     5 7 Japantown 22   616 HEMLOCK ST San Francisco, CA 94115 (37.786175, -122.428915)
7676 0109361-01-001 Biro & Sons Inc Biro & Sons Inc 1160 Folsom St San Francisco 1 CA 1 94103 25 01/01/1978   01/01/1978   1160 Folsom St San Francisco 1 94103 32 CA 8100-8139 5 Certain Services 5 0 0     6 3 South of Market 15   1160 FOLSOM ST San Francisco, CA 94103 (37.775675, -122.409208)
7958 1014593-12-141 Barkoren Burak Render To Render Po Box 7775 San Francisco 1 CA 1 94120 138 12/01/2014   12/01/2014 01/28/2015 51 Ocean Grove Ave Daly City 11 94015 119 CA 8100-8139 5 Certain Services 5 0 0            
8009 0057823-01-001 Peterson Robert L Chase Auto Service 911 Harrison St San Francisco 1 CA 1 94107 22 07/01/1969   02/21/1999   911 Harrison St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0 D23 Vehicle Repair Garage - Major 6 3 South of Market 15   911 HARRISON ST San Francisco, CA 94107 (37.778757, -122.402205)
8038 0008978-01-001 Villaroman Antonio Evs Repair Service 3417 16th St San Francisco 1 CA 1 94114 34 10/01/1968   10/01/1968   3417 16th St San Francisco 1 94114 43 CA 8100-8139 5 Certain Services 5 0 0     8 5 Castro/Upper Market 30   3417 16TH ST San Francisco, CA 94114 (37.764474, -122.429539)
8044 0057833-01-001 Cashman Raymond Erie Auto Repair 3014 18th St San Francisco 1 CA 1 94110 18 07/01/1969   07/01/1969   3014 18th St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0 D23 Vehicle Repair Garage - Major 9 8 Mission 12   3014 18TH ST San Francisco, CA 94110 (37.761629, -122.41253)
8046 0057833-02-001 Cashman Raymond Cashman Family Trust 3014 18th St San Francisco 1 CA 1 94110 18 07/01/1969   12/01/2012   3014 18th St San Francisco 1 94110 37 CA 8100-8139 5 Certain Services 5 0 0     9 8 Mission 12   3014 18TH ST San Francisco, CA 94110 (37.761629, -122.41253)
8104 0149905-03-999 Pac Coast Sales & Service Inc Pacific Coast Trane Company 310 Soquel Wy Sunnyvale 135 CA 1 94086 265 08/01/1984   10/22/1994   310 Soquel Way Sunnyvale 36 94085 502 CA 8100-8139 5 Certain Services 5 0 0           310 SOQUEL WY SUNNYVALE, CA 94086 (37.385529, -122.033782)
8119 0149905-04-999 Pac Coast Sales & Service Inc Pacific Coast Trane Service Co 310 Soquel Wy Sunnyvale 135 CA 1 94086 265 08/01/1984   10/22/1994   310 Soquel Way Sunnyvale 36 94085 502 CA 8100-8139 5 Certain Services 5 0 0           310 SOQUEL WY SUNNYVALE, CA 94086 (37.385529, -122.033782)
8276 0110093-01-001 Ross James & Virginia J & G Upholstery 3231 Balboa St San Francisco 1 CA 1 94121 15 03/01/1978   03/01/1978   3231 Balboa St San Francisco 1 94121 17 CA 8100-8139 5 Certain Services 5 0 0     1 6 Outer Richmond 9   3231 BALBOA ST San Francisco, CA 94121 (37.775878, -122.493605)

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "Registered_Business_Locations_-_San_Francisco" (
"Location Id" TEXT,
  "Business Account Number" INTEGER,
  "Ownership Name" TEXT,
  "DBA Name" TEXT,
  "Street Address" TEXT,
  "City" INTEGER,
  "State" INTEGER,
  "Source Zipcode" INTEGER,
  "Business Start Date" TEXT,
  "Business End Date" REAL,
  "Location Start Date" TEXT,
  "Location End Date" REAL,
  "Mail Address" TEXT,
  "Mail City" INTEGER,
  "Mail Zipcode" INTEGER,
  "Mail State" TEXT,
  "NAICS Code" INTEGER,
  "NAICS Code Description" INTEGER,
  "Parking Tax" INTEGER,
  "Transient Occupancy Tax" INTEGER,
  "LIC Code" REAL,
  "LIC Code Description" REAL,
  "Supervisor District" INTEGER,
  "Neighborhoods - Analysis Boundaries" INTEGER,
  "Business Corridor" INTEGER,
  "Business Location" TEXT
,
FOREIGN KEY ("Neighborhoods - Analysis Boundaries") REFERENCES [Neighborhoods - Analysis Boundaries](id),
    FOREIGN KEY ("NAICS Code Description") REFERENCES [NAICS Code Description](id),
    FOREIGN KEY ("NAICS Code") REFERENCES [NAICS Code](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("Mail Zipcode") REFERENCES [Mail Zipcode](id),
    FOREIGN KEY ("Source Zipcode") REFERENCES [Source Zipcode](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("Supervisor District") REFERENCES [Supervisor District](id),
    FOREIGN KEY ("Business Corridor") REFERENCES [Business Corridor](id),
    FOREIGN KEY ("Mail City") REFERENCES [Mail City](id))
Powered by Datasette · Query took 102.117ms · Data source: data.sfgov.org