home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

25,259 rows where Supervisor District = 1

View and edit SQL

Suggested facets: City, NAICS Code Description, Parking Tax, Transient Occupancy Tax, Neighborhoods - Analysis Boundaries, Business Corridor

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
1 0126694-01-001 Andreani Carlo Andreani Carlo 582 Market St 811 San Francisco 1 CA 1 94104 1 12/31/1995   12/31/1995   582 Market St #811 San Francisco 1 94104 1 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   582 MARKET ST San Francisco, CA 94104 (37.78926, -122.401407)
10 0015092-01-001 Jug Shop Inc Jug Shop Inc 1590 Pacific Ave San Francisco 1 CA 1 94108 9 10/01/1968   08/28/2006   1590 Pacific Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0 H31 H73 H87 Multiple 3 1 Russian Hill 5   1590 PACIFIC AVE San Francisco, CA 94108 (37.79504, -122.421452)
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)
14 0063039-01-001 Lee Sing Yee Assn 1060-1064 Stockton St Apts 1060 Stockton St San Francisco 1 CA 1 94108 9 11/01/1970   11/01/1970   500 Sansome St Ste 502 San Francisco 1 94111 11 CA     0 0     3 1 Chinatown 7   1060 STOCKTON ST San Francisco, CA 94108 (37.795552, -122.408216)
17 0030053-01-001 Walker John & Co Walker John & Co 175 Sutter St San Francisco 1 CA 1 94104 1 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     3 1 Financial District/South Beach 1   175 SUTTER ST San Francisco, CA 94104 (37.789857, -122.403613)
33 0019494-02-001 Tuccori Alma Almas Alterations 444 Union St San Francisco 1 CA 1 94133 11 05/01/2009 01/30/2014 05/07/2009 01/30/2014             0 0     3 1 North Beach 6   444 UNION ST San Francisco, CA 94133 (37.800732, -122.406904)
47 0145742-01-001 Kin F Yee Dds Kin F Yee Dds 760 Market St 722 San Francisco 1 CA 1 94102 16 04/01/1984 07/31/2013 04/01/1984 07/31/2013             0 0     3 1 Financial District/South Beach 1   760 MARKET ST San Francisco, CA 94102 (37.786173, -122.40532)
49 0038695-05-001 Lam Fong Shiu Yuen Shiu Yuen L. Fong 917-921 Pacific Ave San Francisco 1 CA 1 94133 11 10/01/1968   12/31/2000   2026 Clement St #1 San Francisco 1 94121 17 CA     0 0     3 1 Chinatown 7   917 921 PACIFIC AVE San Francisco, CA 94133 (37.796451, -122.410454)
51 0056557-04-001 Chan Tane Www.wokshop.com 718 Grant Ave San Francisco 1 CA 1 94108 9 07/01/1969   01/01/1997   718 Grant Ave San Francisco 1 94108 22 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   718 GRANT AVE San Francisco, CA 94108 (37.793617, -122.406185)
54 0057473-02-001 Louie Sinclair & May C 616 Grant Bldg 616 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968 06/02/2014 10/01/1968 06/02/2014             0 0     3 1 Chinatown 7   616 GRANT AVE San Francisco, CA 94108 (37.793055, -122.406061)
66 0040056-02-001 Sweet Antonia & Adrienne 405 Union Rentals Etal 405 Union St San Francisco 1 CA 1 94133 11 10/01/1968 09/30/2014 10/01/1968 09/30/2014             0 0     3 1 North Beach 6   405 UNION ST San Francisco, CA 94133 (37.800812, -122.406252)
67 0034315-01-001 Wong Lonnie 1533 Larkin Rentals 1533 Larkin St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1533 Larkin St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1533 LARKIN ST San Francisco, CA 94109 (37.792189, -122.419341)
77 0040056-03-001 Sweet Antonia & Adrienne 472 Union Rental 472 Union St San Francisco 1 CA 1 94133 11 10/01/1968 09/30/2014 10/01/1968 09/30/2014             0 0     3 1 North Beach 6   472 UNION ST San Francisco, CA 94133 (37.800694, -122.407239)
80 0000265-06-001 Stephens Institute Inc Academy Of Art University 410 Bush St San Francisco 1 CA 1 94108 9 10/01/1968   01/28/1994   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D02 D03 D19 Multiple 3 1 Financial District/South Beach 1   410 BUSH ST San Francisco, CA 94108 (37.790697, -122.404484)
82 0099497-01-001 Edmund Y K & Lorraine T Dun 1462 California Apts 1462 California St San Francisco 1 CA 1 94109 24 06/16/1976   06/16/1976   6507 Hagen Bl El Cerrito 15 94530 31 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1462 CALIFORNIA ST San Francisco, CA 94109 (37.790863, -122.418424)
83 0034320-01-001 Mah King Min 1534 Jackson Apts 1534 Jackson St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1534 Jackson St #3 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1534 JACKSON ST San Francisco, CA 94109 (37.794276, -122.420367)
84 0040056-04-001 Sweet Antonia & Adrienne 480 Union St Apt 480 Union St San Francisco 1 CA 1 94133 11 10/01/1968 09/30/2014 03/20/1992 09/30/2014             0 0     3 1 North Beach 6   480 UNION ST San Francisco, CA 94133 (37.800682, -122.407336)
92 0140436-01-001 Console Anthony Tonys Hair Studio 847 Columbus Ave San Francisco 1 CA 1 94133 11 03/28/1983   03/28/1983   845 Columbus Ave San Francisco 1 94133 9 CA     0 0     3 1 Russian Hill 5   847 COLUMBUS AVE SAN FRANCISCO, CA 94133 (37.802539, -122.41342)
95 0048893-01-001 Toms Investments Co Inc 855 Grant Av Bldg 855 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   855 GRANT AVE San Francisco, CA 94108 (37.794746, -122.406403)
99 0140436-02-001 Console Anthony 845 Columbus Ave Bldg 845 Columbus Ave San Francisco 1 CA 1 94133 11 03/28/1983   01/01/1994   845 Columbus Ave San Francisco 1 94133 9 CA     0 0     3 1 Russian Hill 5   845 COLUMBUS AVE San Francisco, CA 94133 (37.802554, -122.413441)
100 0048894-01-001 Chong Hing Co Inc 740/742 Jackson Bldg 740 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   740 JACKSON ST San Francisco, CA 94133 (37.795931, -122.407385)
103 0034361-01-001 Owyang Sherwin & Jennette 1540 Hyde Apts 1540 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968 03/14/2014 10/01/1968 03/14/2014             0 0     3 1 Russian Hill 5   1540 HYDE ST San Francisco, CA 94109 (37.795043, -122.41822)
106 0048894-02-001 Chong Hing Co Inc 848 Grant Bldg 848 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   848 GRANT AVE San Francisco, CA 94108 (37.794872, -122.406426)
118 0112362-01-001 Lee Dale Innovations 182 Bernard St San Francisco 1 CA 1 94109 24 06/27/1978   06/27/1978 06/01/2015 1835 30th Ave San Francisco 1 94122 15 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Nob Hill 17   182 BERNARD ST San Francisco, CA 94109 (37.796169, -122.416489)
119 0000265-06-004 Stephens Institute Inc Academy Of Art University 540 Powell St San Francisco 1 CA 1 94108 9 10/01/1968   01/28/1994   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D04 Places Of Public Assembly & Open-Air Assembly 3 1 Financial District/South Beach 1   540 POWELL ST San Francisco, CA 94108 (37.789736, -122.408673)
120 0048894-03-001 Chong Hing Co Inc 933-939 Grant Av Bldg 933 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   933 GRANT AVE San Francisco, CA 94108 (37.795646, -122.406581)
121 0048894-04-001 Chong Hing Co Inc 740 Jackson St Apts 740 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   740 JACKSON ST San Francisco, CA 94133 (37.795931, -122.407385)
127 0040069-01-001 Pezzi A Co 407 Greenwich Apts 407-411 Greenwich St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   331 Orchard Avenue Redwood City 21 94061 39 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   407 411 GREENWICH ST SAN FRANCISCO, CA 94133 (37.802632, -122.406779)
131 0048894-05-001 Chong Hing Co Inc 742 Jackson Rentals 742 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968   12/31/1988   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   742 JACKSON ST San Francisco, CA 94133 (37.795927, -122.407415)
133 0011650-01-001 Dare Rose Dare Rose 966 Pine St San Francisco 1 CA 1 94108 9 09/17/1973   09/17/1973   966 Pine St San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   966 PINE ST San Francisco, CA 94108 (37.790728, -122.411831)
135 0140506-01-001 Liang Hsung Ying Liang Dr Medical Office 2000 Van Ness Ave 607 San Francisco 1 CA 1 94109 24 04/01/1983   05/01/2008   2000 Van Ness Ave Ste 607 San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Russian Hill 5   2000 VAN NESS AVE San Francisco, CA 94109 (37.794086, -122.423016)
137 0048894-06-001 Chong Hing Co Inc 933-939 Grant Av Rentals 933 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   12/31/1988   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   933 GRANT AVE San Francisco, CA 94108 (37.795646, -122.406581)
147 0061067-01-001 Fortuin Floyd D Fortuin Floyd D 909 Hyde St 609 San Francisco 1 CA 1 94109 24 11/01/1970   02/09/2000   909 Hyde St #620 San Francisco 1 94109 7 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   909 HYDE ST San Francisco, CA 94109 (37.789609, -122.417122)
154 0038303-01-001 Rodriguez Pearl 296 Union St Apts 296 Union St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1800 Atrium Pkwy Apt 414 Napa 24 94559 44 CA     0 0     3 1 North Beach 6   296 UNION ST San Francisco, CA 94133 (37.801061, -122.404195)
156 0112536-01-001 Inter World Trading Co Inc Inter World Trading Co Inc 760 Market St 365 San Francisco 1 CA 1 94102 16 01/01/1978   01/01/1978 09/30/2013 833 Market St Ste 505 San Francisco 1 94103 32 CA 4200-4299 7 Wholesale Trade 7 0 0     3 1 Financial District/South Beach 1   760 MARKET ST San Francisco, CA 94102 (37.786173, -122.40532)
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)
158 0061092-01-001 Hall Association Nsgw 414 Mason Bldg 414 Mason St San Francisco 1 CA 1 94102 16 01/01/1970   01/01/1970   414 Mason St San Francisco 1 94102 16 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Tenderloin 11   414 MASON ST San Francisco, CA 94102 (37.787472, -122.409946)
162 0000265-06-007 Stephens Institute Inc Academy Of Art University 620 Sutter St San Francisco 1 CA 1 94102 16 10/01/1968   08/11/2005   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 H56 Swimming Pools (Year-Round) 3 1 Nob Hill 17   620 SUTTER ST San Francisco, CA 94102 (37.788972, -122.410677)
166 0000265-06-008 Stephens Institute Inc Academy Of Art University 655 Sutter St San Francisco 1 CA 1 94102 16 10/01/1968   03/01/1999   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   655 SUTTER ST San Francisco, CA 94102 (37.788919, -122.41109)
169 0007393-51-001 Del Camp Investments Inc 1461 California Street 1461 California St San Francisco 1 CA 1 94114 34 10/01/1968   01/01/2000   2120 Market St #100 San Francisco 1 94114 43 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1461 CALIFORNIA ST San Francisco, CA 94114 (37.790868, -122.418392)
173 0034402-01-001 Golden Gateway Center Golden Gateway Center 460 Davis Ct San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   460 Davis Ct San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   460 DAVIS CT San Francisco, CA 94111 (37.796577, -122.398248)
178 0000265-07-001 Stephens Institute Inc Academy Of Art University 1055 Pine St San Francisco 1 CA 1 94109 24 10/01/1968   01/02/2011   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   1055 PINE ST San Francisco, CA 94109 (37.790564, -122.413156)
181 0071475-01-001 Wedbush Morgan Securities Inc Wedbush Morgan Securities Inc 601 California St 500 San Francisco 1 CA 1 94108 9 01/01/1971   04/28/2006   1000 Wilshire Blvd Los Angeles 3 90017 51 CA 5210-5239 11 Financial Services 11 0 0     3 1 Financial District/South Beach 1   601 CALIFORNIA ST San Francisco, CA 94108 (37.792606, -122.404716)
195 0083946-01-001 Toy Kan L Toy Kan L Dds 450 Sutter St 2340 San Francisco 1 CA 1 94108 9 08/01/1974 11/01/2017 08/01/1974 11/01/2017         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   450 SUTTER ST San Francisco, CA 94108 (37.789331, -122.407788)
196 0112776-01-001 Barkhordarian George 533 Sutter St Building 533 Sutter St San Francisco 1 CA 1 94102 16 08/01/1976 12/15/2012 08/01/1976 12/15/2012             0 0     3 1 Nob Hill 17   533 SUTTER ST San Francisco, CA 94102 (37.789178, -122.409117)
197 0011795-01-001 Guardinos Souvenir & Gift Sho Guardinos Souvenir & Gift Shop 2801 Taylor St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   2801 Taylor St San Francisco 1 94133 9 CA 4400-4599 3 Retail Trade 3 0 0 H28 H73 Multiple 3 1 North Beach 6   2801 TAYLOR ST San Francisco, CA 94133 (37.80831, -122.415795)
201 0026320-01-001 Kim Oy Lee Kim Oy Lee 801 Pacific Ave San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   Po Box 330568 San Francisco 1 94133 9 CA 7210-7219 9 Accommodations 9 0 1     3 1 Chinatown 7   801 PACIFIC AVE San Francisco, CA 94133 (37.79672, -122.408311)
203 0034402-01-002 Golden Gateway Center Golden Gateway Center 550 Battery St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968 12/31/2013 460 Davis Ct San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   550 BATTERY ST San Francisco, CA 94111 (37.796292, -122.400604)
205 0034402-01-003 Golden Gateway Center Golden Gateway Center 155 Jackson St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968 12/31/2013 460 Davis Ct San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   155 JACKSON ST San Francisco, CA 94111 (37.79706, -122.398563)
209 0099771-03-001 Jweinat John & Maha S Sutter Fine Foods 988 Sutter St San Francisco 1 CA 1 94109 24 07/01/1989   07/01/1989 10/31/2013 29a Cambon Dr San Francisco 1 94132 56 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   988 SUTTER ST SAN FRANCISCO, CA 94109 (37.788203, -122.416657)
211 0140807-01-001 Sfh Associates Lp Mark Hopkins Hotel 999 California St San Francisco 1 CA 1 94108 9 04/15/1983 03/27/2014 04/15/1983 03/27/2014             0 0     3 1 Nob Hill 17   999 CALIFORNIA ST San Francisco, CA 94108 (37.791791, -122.411265)
212 0000265-10-001 Stephens Institute Inc Academy Of Art University 2300 Stockton St San Francisco 1 CA 1 94133 11 10/01/1968   01/02/2011   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 North Beach 6   2300 STOCKTON ST San Francisco, CA 94133 (37.807161, -122.410549)
218 0031787-01-001 Ronald Fung 1017 Hyde Apts 1017 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968 05/16/2017 10/01/1968 05/16/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1017 HYDE ST San Francisco, CA 94109 (37.790359, -122.417276)
223 0034402-01-004 Golden Gateway Center Golden Gateway Center 405 Davis Ct San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968 12/31/2013 460 Davis Ct San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   405 DAVIS CT San Francisco, CA 94111 (37.79635, -122.39821)
224 0031796-01-001 Chen Richard Y 962-968 Greenwich St Apts 962 Greenwich St San Francisco 1 CA 1 94133 11 01/01/1973 06/30/2015 01/01/1973 06/30/2015             0 0     3 1 Russian Hill 5   962 GREENWICH ST San Francisco, CA 94133 (37.801561, -122.415506)
230 0034402-01-005 Golden Gateway Center Golden Gateway Center 440 Davis Ct San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968 12/31/2013 460 Davis Ct San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   440 DAVIS CT San Francisco, CA 94111 (37.796745, -122.398278)
236 0009619-01-001 Geraldi Nino L Etal Fishermans Grotto #9 2847 Taylor St San Francisco 1 CA 1 94133 11 10/01/1968 09/25/2016 10/01/1968 12/31/2013 4831 Indian Valley Rd Novato 22 94947 40 CA 7220-7229 8 Food Services 8 0 0     3 1 North Beach 6   2847 TAYLOR ST SAN FRANCISCO, CA 94133 (37.808882, -122.415838)
237 0040263-01-001 Chen George K & Nancy 423 Lombard Apts 423 Lombard St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968 12/31/2013 972 Greenwich St #A San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   423 LOMBARD ST San Francisco, CA 94133 (37.80339, -122.40857)
239 0052887-03-001 Petersen Adele Etal 570 Green St 570-574 Green St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1320 Poplar Ave Pacifica 34 94044 60 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   570 574 GREEN ST San Francisco, CA 94133 (37.79958, -122.408532)
240 0031796-04-001 Chen Richard Y 14-26 Geary Bldg 14 Geary St San Francisco 1 CA 1 94108 9 01/01/1973 06/30/2015 06/30/1976 06/30/2015             0 0     3 1 Financial District/South Beach 1   14 GEARY ST San Francisco, CA 94108 (37.78794, -122.403678)
246 0011867-01-001 J. C. Simpson Rpt Inc Gustafson B L & Assoc Phys Etc 450 Sutter St 1003 San Francisco 1 CA 1 94108 9 10/01/1968   07/01/1999   450 Sutter St #1003 San Francisco 1 94108 22 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Financial District/South Beach 1   450 SUTTER ST San Francisco, CA 94108 (37.789331, -122.407788)
249 0052914-01-001 Lee Way Koon 1401-1411 Grant Rentals 1401 Grant Ave San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   5040 Anza St San Francisco 1 94121 17 CA     0 0     3 1 North Beach 6   1401 GRANT AVE San Francisco, CA 94133 (37.799874, -122.40744)
258 0071565-02-001 Maloney Silke Silke's Coiffures 124 Sutter St 3rd Fl San Francisco 1 CA 1 94104 1 07/03/1972 06/26/2015 09/01/2012 06/26/2015             0 0     3 1 Financial District/South Beach 1   124 SUTTER ST San Francisco, CA 94104 (37.789958, -122.402864)
261 0071613-01-001 Suess Frank R Downtown Watch Repair 210 Post St 304 San Francisco 1 CA 1 94108 9 04/01/1972   04/01/1972   210 Post St #304 San Francisco 1 94108 22 CA     0 0     3 1 Financial District/South Beach 1   210 POST ST San Francisco, CA 94108 (37.788678, -122.405371)
265 0034402-02-001 Golden Gateway Center 560 Battery Bldg 560 Battery St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   460 Davis Ct San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   560 BATTERY ST San Francisco, CA 94111 (37.796338, -122.400614)
267 0140878-01-001 Travelfast Intl Inc Travelfast Intl Inc 870 Market St 611 San Francisco 1 CA 1 94102 16 01/01/1983   01/01/1983   870 Market St 607 Ste San Francisco 1 94102 16 CA     0 0     3 1 Financial District/South Beach 1   870 MARKET ST San Francisco, CA 94102 (37.784761, -122.407108)
269 0049108-01-001 Chen Erwin/chen Walter/g&b Llc Waverly Grant Properties 124 Waverly Pl San Francisco 1 CA 1 94108 9 01/01/1991   01/01/1991 03/21/2017 3133 Geary Blvd San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7 Chinatown 1 124 WAVERLY PL San Francisco, CA 94108 (37.794597, -122.406929)
272 0034402-03-001 Golden Gateway Center The Gateway 460 Davis Ct San Francisco 1 CA 1 94111 35 10/01/1968   11/12/2008   460 Davis Ct San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Financial District/South Beach 1   460 DAVIS CT San Francisco, CA 94111 (37.796577, -122.398248)
276 0112931-04-001 Leix Construction Co Inc Leix Construction Co 1465 Pine St San Francisco 1 CA 1 94109 24 02/10/1992   01/15/2014   1465 Pine Street San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1465 PINE ST San Francisco, CA 94109 (37.789694, -122.419865)
281 0140878-03-001 Travelfast Intl Inc Mango Communications 870 Market St 607 San Francisco 1 CA 1 94102 16 01/01/1983   11/03/1999   870 Market St 607 Ste San Francisco 1 94102 16 CA     0 0     3 1 Financial District/South Beach 1   870 MARKET ST San Francisco, CA 94102 (37.784761, -122.407108)
283 0011867-02-001 J. C. Simpson Rpt Inc Bert's Conditioning Clinic 450 Sutter St 1003 San Francisco 1 CA 1 94108 9 10/01/1968   01/01/2011   450 Sutter St #1003 San Francisco 1 94108 22 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Financial District/South Beach 1   450 SUTTER ST San Francisco, CA 94108 (37.789331, -122.407788)
291 0113100-01-001 Chow Frank & Chow Roy Pinecrest Cleaners 1176 Pine St San Francisco 1 CA 1 94109 24 06/01/1973   06/01/1973   1176 Pine St San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0 D30 Dry Cleaning Plant 3 1 Nob Hill 17   1176 PINE ST San Francisco, CA 94109 (37.790313, -122.415145)
309 0084336-01-001 Adams Geoffrey C Adams Geoffrey 870 Market St 916 San Francisco 1 CA 1 94102 16 01/01/1973   01/26/2004   870 870 Market St 1177 St San Francisco 1 94102 16 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   870 MARKET ST San Francisco, CA 94102 (37.784761, -122.407108)
313 0012011-01-001 Robert Half International Inc Robert Half International Inc 50 California St 10th Fl 10th Fl San Francisco 1 CA 1 94111 35 10/01/1968   01/01/1997   2613 Camino Ramon San Ramon 41 94583 67 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST FL San Francisco, CA 94111 (37.793604, -122.397307)
315 0113146-01-003 Japanese Weekend Inc Japanese Weekend Inc 500 Sutter St San Francisco 1 CA 1 94102 16 08/15/1978   11/01/1996 06/30/2013 0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     3 1 Nob Hill 17   500 SUTTER ST San Francisco, CA 94102 (37.789211, -122.408868)
317 0084362-01-001 Lee Gary Lee Gary Dds 1259 Mason St San Francisco 1 CA 1 94108 9 09/03/1974   09/03/1974   1259 Mason St San Francisco 1 94108 22 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Nob Hill 17   1259 MASON ST San Francisco, CA 94108 (37.795256, -122.411525)
321 0000265-13-001 Stephens Institute Inc Academy Of Art University 491 Post St San Francisco 1 CA 1 94102 16 10/01/1968   01/02/2011   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D04 Places Of Public Assembly & Open-Air Assembly 3 1 Tenderloin 11   491 POST ST San Francisco, CA 94102 (37.788127, -122.409734)
323 0012011-03-001 Robert Half International Inc Affiliates The 50 California St 10th Fl San Francisco 1 CA 1 94111 35 10/01/1968   01/01/1997   2613 Camino Ramon San Ramon 41 94583 67 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)
329 0012011-04-001 Robert Half International Inc Office Team 50 California St 10th Fl San Francisco 1 CA 1 94111 35 10/01/1968   01/01/1997   2613 Camino Ramon San Ramon 41 94583 67 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)
331 0040306-02-001 Chan David 1208-1216 Powell Apts 1208 Powell St San Francisco 1 CA 1 94133 11 10/01/1968 07/21/2016 01/01/1970 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   1208 POWELL ST San Francisco, CA 94133 (37.795827, -122.409933)
334 0012011-05-001 Robert Half International Inc Robert Half Finance & Accnting 50 California St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/2007   2613 Camino Ramon San Ramon 41 94583 67 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)
337 0049309-01-001 F E Jordan Associates Inc Fe Jordan Asscs Inc 490 Post St 1607 San Francisco 1 CA 1 94102 16 11/29/2000   09/01/2007   490 Post St 1607 San Francisco 1 94102 16 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Nob Hill 17   490 POST ST San Francisco, CA 94102 (37.788129, -122.409722)
339 0012011-06-001 Robert Half International Inc Robert Half Mgmt Resources 50 California St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/2007   2613 Camino Ramon San Ramon 41 94583 67 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)
340 0071907-01-001 Yick Electric Co Inc Yick Electric Co Inc 1235 Stockton St San Francisco 1 CA 1 94133 11 07/01/1972   07/01/1972   1235 Stockton St San Francisco 1 94133 9 CA 2300-2399 6 Construction 6 0 0     3 1 Chinatown 7   1235 STOCKTON ST San Francisco, CA 94133 (37.797188, -122.408541)
341 0071948-03-001 Robert Grison-Living Trust 712-714 Montgomery Bldg 712 Montgomery St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   1333 Jones St #908 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   712 MONTGOMERY ST San Francisco, CA 94111 (37.795847, -122.403378)
342 0140983-01-001 Golden City Enterprise Inc Golden City Building Supply 1279 Pacific Ave San Francisco 1 CA 1 94109 24 02/12/1982   01/02/2002   1279 Pacific Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Nob Hill 17   1279 PACIFIC AVE San Francisco, CA 94109 (37.795731, -122.416224)
346 0012011-07-001 Robert Half International Inc Robert Half Technology 50 California St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/2007   2613 Camino Ramon San Ramon 41 94583 67 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)
351 0012011-08-001 Robert Half International Inc Robert Half Legal 50 California St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/2007   2613 Camino Ramon San Ramon 41 94583 67 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)
352 0026883-18-001 Chevron Texaco Corp Chevron 101 Bay St San Francisco 1 CA 1 94133 11 10/01/1968   01/01/1999   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     3 1 North Beach 6   101 BAY ST San Francisco, CA 94133 (37.806184, -122.409039)
360 0000265-17-001 Stephens Institute Inc Academy Of Art University 688 Sutter St San Francisco 1 CA 1 94102 16 10/01/1968   01/02/2011   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   688 SUTTER ST San Francisco, CA 94102 (37.788834, -122.411745)
362 0113164-01-001 Liu Annie Y Liu Annie Y Cpa 201 California St 411 San Francisco 1 CA 1 94111 35 03/15/1978   10/01/2005   201 California St #411 San Francisco 1 94111 11 CA 5210-5239 11 Financial Services 11 0 0     3 1 Financial District/South Beach 1   201 CALIFORNIA ST San Francisco, CA 94111 (37.793328, -122.399087)
363 0071960-02-001 Yang Mary W 1400-1404 Hyde Apartments 1400 Hyde St San Francisco 1 CA 1 94109 24 08/01/1971   01/20/1975 12/31/2013 1171 Pacific Av San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1400 HYDE ST San Francisco, CA 94109 (37.79377, -122.417959)
366 0040306-05-001 Chan David Powell Street 1208 Powell St San Francisco 1 CA 1 94133 11 10/01/1968 07/21/2016 03/01/2007 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   1208 POWELL ST San Francisco, CA 94133 (37.795827, -122.409933)
371 0012011-09-001 Robert Half International Inc The Creative Group 50 California St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/2007   2613 Camino Ramon San Ramon 41 94583 67 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)
373 0442135-03-001 Center For Entrepreneurship In Impact Carbon 47 Kearny St 600 San Francisco 1 CA 1 94108 9 02/01/2012   02/01/2012   582 Market St #1204 San Francisco 1 94104 1 CA     0 0     3 1 Financial District/South Beach 1   47 KEARNY ST San Francisco, CA 94108 (37.788551, -122.403604)
374 0113213-01-001 Jones Hall,a Professional Corp Jones Hall,a Professional Corp 650 California Street 18th Fl San Francisco 1 CA 1 94108 9 03/15/1978   03/15/1978 07/31/2014 475 Sansome St 17th Fl San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Chinatown 7   650 CALIFORNIA STREET San Francisco, CA 94108 (37.792512, -122.405421)
381 0141107-01-001 Scheidegger Trading Co Inc Scheidegger Trading Co Inc 351 California St 1400 San Francisco 1 CA 1 94104 1 01/01/1981   12/01/2007   351 California #1400 San Francisco 1 94104 1 CA 4200-4299 7 Wholesale Trade 7 0 0     3 1 Financial District/South Beach 1   351 CALIFORNIA ST San Francisco, CA 94104 (37.793114, -122.400779)
385 0113255-01-001 Clark Ronald A Md Inc Clark Ronald Arthur-Md 909 Hyde St San Francisco 1 CA 1 94109 24 08/10/1978   10/12/1995   27335 Po Box San Francisco 1 94127 46 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Nob Hill 17   909 HYDE ST San Francisco, CA 94109 (37.789609, -122.417122)
390 0000265-18-001 Stephens Institute Inc Academy Of Art University 700 Montgomery St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/2013   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Chinatown 7   700 MONTGOMERY ST San Francisco, CA 94111 (37.795699, -122.40335)
393 0084492-05-001 Patel Mangiben & Ramesh Trust Nob Hill Motor Inn 1630 Pacific Ave San Francisco 1 CA 1 94109 24 06/01/1972   03/30/2000   1630 Pacific Ave San Francisco 1 94109 7 CA 7210-7219 9 Accommodations 9 0 1     3 1 Russian Hill 5   1630 PACIFIC AVE San Francisco, CA 94109 (37.794944, -122.422194)

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 344.985ms · Data source: data.sfgov.org