home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

7,621 rows where Source Zipcode = 35

View and edit SQL

Suggested facets: City, State, NAICS Code Description, Parking Tax, Transient Occupancy Tax, Supervisor District, Neighborhoods - Analysis Boundaries

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
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)
190 0140625-05-001 Davanloo Hooshang Contempo Hair Design 4 Embarcadero Center San Francisco 1 CA 1 94111 35 04/02/1983   12/02/2012   163 Prince Royal Drive Corte Madera 28 94925 53 CA     0 0           4 EMBARCADERO CENTER San Francisco, CA 94111 (37.795106, -122.396158)
202 0026325-01-001 Skidmore Owings & Merrill Llp Skidmore Owings & Merrill 1 Front St San Francisco 1 CA 1 94111 35 10/01/1968   04/07/1997   1 Front St 24th Flr San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0 D03 Portable Containers 6 3 Financial District/South Beach 1   1 FRONT ST San Francisco, CA 94111 (37.791868, -122.398473)
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)
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)
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)
245 0071475-03-001 Wedbush Morgan Securities Inc Wedbush Securities Inc 2 Embarcadero Ctr 600 San+francisco 8 CA 1 94111 35 01/01/1971   12/01/2013   1000 Wilshire Blvd Los Angeles 3 90017 51 CA 5210-5239 11 Financial Services 11 0 0           2 EMBARCADERO CTR San Francisco, CA 94111 (37.794812, -122.398499)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
436 0113313-01-001 Folger Levin & Kahn Llp Folger Levin & Kahn Llp 275 Battery St 2300 San Francisco 1 CA 1 94111 35 12/01/2009   12/01/2009   3 Embarcadero Center 26 Fl San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   275 BATTERY ST San Francisco, CA 94111 (37.793915, -122.400111)
458 0127095-01-002 22 Battery St Inc 22 Battery St Inc 98 Battery St San Francisco 1 CA 1 94111 35 01/01/1980   01/01/1991   98 Battery Street # 600 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   98 BATTERY ST San Francisco, CA 94111 (37.792011, -122.399722)
524 0018725-01-001 Mcmicking And Company Llc Mcmicking & Co 500 Sansome St 608 San Francisco 1 CA 1 94111 35 01/01/2000 12/31/2014 01/01/2004 12/31/2014             0 0     3 1 Chinatown 7   500 SANSOME ST San Francisco, CA 94111 (37.795069, -122.401553)
535 0127162-01-001 Oneill Dennis V Oneill Software 440 Davis Ct 1822 San Francisco 1 CA 1 94111 35 12/01/1980   12/01/1980   440 Davis Ct #1822 San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   440 DAVIS CT San Francisco, CA 94111 (37.796745, -122.398278)
561 0000368-01-001 Acoustical Consultants Inc Acoustical Consultants Inc 150 California St 3rd Flr San Francisco 1 CA 1 94111 35 10/01/1968   08/16/2004   150 California St #3rd Flr San Francisco 1 94111 11 CA     0 0     3 1 Financial District/South Beach 1   150 CALIFORNIA ST FLR San Francisco, CA 94111 (37.793407, -122.398442)
621 0012293-01-001 Harringtons Inc Harringtons Bar & Grill 245 Front St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   245 Front St San Francisco 1 94111 11 CA 4400-4599 3 Retail Trade 3 0 0 H26 H31 P23 Multiple 3 1 Financial District/South Beach 1   245 FRONT ST San Francisco, CA 94111 (37.794046, -122.398926)
693 0000482-02-001 Fugazi Travel Agency, Inc. La Collezione 400 Sansome St San Francisco 1 CA 1 94111 35 10/01/1968   07/01/1997 08/31/2015 345 California Street 160 Ste San Francisco 1 94104 1 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   400 SANSOME ST San Francisco, CA 94111 (37.793982, -122.40134)
697 0000482-03-001 Fugazi Travel Agency, Inc. Anaconda Adventures 400 Sansome St San Francisco 1 CA 1 94111 35 10/01/1968   07/01/1997 08/31/2015 345 California Street 160 Ste San Francisco 1 94104 1 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   400 SANSOME ST San Francisco, CA 94111 (37.793982, -122.40134)
698 0012554-01-001 Heidrick & Struggles Heidrick & Struggles 1 California St 2400 San Francisco 1 CA 1 94111 35 10/01/1968   04/01/2000   233 S Wacker Dr 4900 Chicago 65 60606 104 IL 5600-5699 16 Administrative and Support Services 16 0 0     3 1 Financial District/South Beach 1   1 CALIFORNIA ST San Francisco, CA 94111 (37.793534, -122.397317)
701 0113996-03-001 Jackson Lewis Llp Jackson Lewis Llp 50 California St 9th San Francisco 1 CA 1 94111 35 05/15/1978 12/01/2013 05/15/1978 12/01/2013             0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST SAN FRANCISCO, CA 94111 (37.793604, -122.397307)
718 0000482-04-001 Fugazi Travel Agency, Inc. Radio Travel 400 Sansome St San Francisco 1 CA 1 94111 35 10/01/1968   11/01/1998 08/31/2015 345 California Street 160 Ste San Francisco 1 94104 1 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   400 SANSOME ST San Francisco, CA 94111 (37.793982, -122.40134)
719 0027688-03-001 Sunset Scavenger Co Recology Sunset Scavenger 50 California St 24th Fl San Francisco 1 CA 1 94111 35 10/01/1968   09/15/2009   250 Executive Park Blvd., Ste 2100 San Francisco 1 94134 23 CA     0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)
721 0114039-01-001 Sugarman & Company Llp Sugarman & Company Llp 500 Sansome St 600 San Francisco 1 CA 1 94111 35 05/01/1978   05/19/2009   500 Sansome Street Ste 600 San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Chinatown 7   500 SANSOME ST San Francisco, CA 94111 (37.795069, -122.401553)
739 0000482-05-001 Fugazi Travel Agency, Inc. Sea Level 400 Sansome St San Francisco 1 CA 1 94111 35 10/01/1968   05/04/1999 08/31/2015 345 California Street 160 Ste San Francisco 1 94104 1 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   400 SANSOME ST San Francisco, CA 94111 (37.793982, -122.40134)
747 0027875-01-001 Swett & Crawford Swett & Crawford 1 California St #1200 San+francisco 8 CA 1 94111 35 01/01/2002   08/04/2006   515 S Figueroa St., Ste 600 Los Angeles 3 90071 109 CA 5240-5249 20 Insurance 17 0 0           1 CALIFORNIA ST SAN FRANCISCO, CA 94111 (37.793534, -122.397317)
803 0027948-01-001 Tadich Grill Inc Tadich Grill Inc 240 California St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   240 California St San Francisco 1 94111 11 CA 7220-7229 8 Food Services 8 0 0 H26 Restaurant Greater Than 2,000 Sqft 3 1 Financial District/South Beach 1   240 CALIFORNIA ST San Francisco, CA 94111 (37.793283, -122.399448)
836 0049845-01-001 Sf Bar Pilots Sf Bar Pilots Pier 9 San Francisco 1 CA 1 94111 35 01/01/1969   01/01/1969   9 Pier East End San Francisco 1 94111 11 CA 4800-4999 12 Transportation and Warehousing 12 0 0           9 San Francisco, CA 94111 (37.732211, -122.464503)
882 0114128-10-001 Rj Pesusic Inc Rj's Market @ Levi Plaza 1425 Sansome St San Francisco 1 CA 1 94111 35 10/01/1978   05/29/2001   98 Howard St San Francisco 1 94105 5 CA 4400-4599 3 Retail Trade 3 0 0 H07 H31 H73 Multiple 3 1 Financial District/South Beach 1   1425 SANSOME ST San Francisco, CA 94111 (37.803625, -122.403278)
898 0061585-01-001 Carl James & Campbell J 716-720 Montgomery Bldg 716 Montgomery St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   27 Hotaling Pl San Francisco 1 94111 11 CA     0 0     3 1 Chinatown 7   716 MONTGOMERY ST San Francisco, CA 94111 (37.79593, -122.403392)
910 0000780-01-001 Allied Administrators Inc Allied Administrators Inc 633 Battery St 3rd Fl San Francisco 1 CA 1 94111 35 10/01/1968   05/01/2007   Po Box 150759 San Rafael 20 94915 130 CA 5240-5249 20 Insurance 17 0 0     3 1 Chinatown 7   633 BATTERY ST San Francisco, CA 94111 (37.79728, -122.400802)
911 0114279-01-001 Keker & Van Nest Keker & Van Nest 633 Battery St San Francisco 1 CA 1 94111 35 10/15/1978   08/01/2011   633 Battery St San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0 D04 Places Of Public Assembly & Open-Air Assembly 3 1 Chinatown 7   633 BATTERY ST San Francisco, CA 94111 (37.79728, -122.400802)
935 0061699-03-001 Leemah Electronics Inc Leemah Electronics 1088 Sansome St San Francisco 1 CA 1 94111 35 03/01/1971 09/30/2014 10/01/1992 09/30/2014             0 0     3 1 Financial District/South Beach 1   1088 SANSOME ST San Francisco, CA 94111 (37.800208, -122.402585)
978 0114719-03-001 S L Pemberton Inc S L Pemberton Inc 414 Jackson St 302 San Francisco 1 CA 1 94111 35 02/01/2012 04/01/2016 02/01/2012 04/01/2016         4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   414 JACKSON ST San Francisco, CA 94111 (37.796584, -122.402307)
1051 0001072-01-001 Basic American Inc Basic American Inc 600 Montgomery St 28th Flr San Francisco 1 CA 1 94111 35 10/01/1968   03/07/2005 04/30/2017 2999 Oak Rd 800 Ste Walnut Creek 4 94597 140 CA 3100-3399 10 Manufacturing 10 0 0     3 1 Chinatown 7   600 MONTGOMERY ST FLR San Francisco, CA 94111 (37.795131, -122.403236)
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)
1084 0127604-01-001 Honorway Investment Corp 388 Market St Bldgs & Apts 388 Market St San Francisco 1 CA 1 94111 35 01/01/1973   01/01/1973   388 Market St 1568 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   388 MARKET ST San Francisco, CA 94111 (37.792, -122.397945)
1087 0127604-02-001 Honorway Investment Corp Honorway Investment Corp 388 Market St 300 San Francisco 1 CA 1 94111 35 01/01/1973   02/11/1987   388 Market St 1568 San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 D26 Station Tanks - Above Ground 3 1 Financial District/South Beach 1   388 MARKET ST San Francisco, CA 94111 (37.792, -122.397945)
1092 0012905-01-001 Hirsch Ephraim G Etal Hirsch Associates Pier 1a San+francisco 8 CA 1 94111 35 10/01/1968   10/01/1968   370 Francisco St San Francisco 1 94133 9 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           1A San Francisco, CA 94111 (37.799425, -122.406046)
1128 0115022-01-001 Metropolitan Food & Bev Co In Holding Company The 2 Embarcadero Ctr San Francisco 1 CA 1 94111 35 01/01/1978 03/01/2014 01/01/1978 03/01/2014             0 0           2 EMBARCADERO CTR San Francisco, CA 94111 (37.794812, -122.398499)
1140 0127604-04-001 Honorway Investment Corp Summum Executive Suites 388 Market St 400 San Francisco 1 CA 1 94111 35 01/01/1973   12/16/1992   388 Market St 1568 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   388 MARKET ST San Francisco, CA 94111 (37.792, -122.397945)
1223 0100831-01-001 Auerbach + Associates,inc Auerbach & Associates 225 Green St San Francisco 1 CA 1 94111 35 11/30/1994   01/01/1999   225 Green St San Francisco 1 94111 11 CA     0 0     3 1 North Beach 6   225 GREEN ST San Francisco, CA 94111 (37.80024, -122.403149)
1235 0100831-04-001 Auerbach + Associates,inc Auerbach Pollock Friedlander 225 Green St San Francisco 1 CA 1 94111 35 11/30/1994   10/11/2002   225 Green St San Francisco 1 94111 11 CA     0 0     3 1 North Beach 6   225 GREEN ST San Francisco, CA 94111 (37.80024, -122.403149)
1248 0100831-08-001 Auerbach + Associates,inc Auerbach Glasow French 225 Green St San Francisco 1 CA 1 94111 35 11/30/1994   12/06/2007 01/23/2017 225 Green St San Francisco 1 94111 11 CA     0 0     3 1 North Beach 6   225 GREEN ST San Francisco, CA 94111 (37.80024, -122.403149)
1295 0028500-01-001 Time Inc Magazine Co Time Inc 2 Embarcadero Ctr San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968 09/30/2015 225 Liberty St Tax Dept Attn: New York 49 10281 154 NY     0 0           2 EMBARCADERO CTR San Francisco, CA 94111 (37.794812, -122.398499)
1332 0087062-01-001 Henry & Diana Chung Co Inc Hunan Restaurant 924 Sansome St San Francisco 1 CA 1 94111 35 02/01/1974 05/12/2017 02/01/1974 05/12/2017         7220-7229 8 Food Services 8 0 0 H26 Restaurant Greater Than 2,000 Sqft 3 1 Financial District/South Beach 1   924 SANSOME ST San Francisco, CA 94111 (37.798974, -122.402345)
1363 0028703-02-001 Vericlaim Inc Vericlaim Inc 500 Sansome St 614 San Francisco 1 CA 1 94111 35 10/01/1968   09/24/2007   1100 Ridgeway Loop Road Memphis 103 38120 157 TN 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Chinatown 7   500 SANSOME ST San Francisco, CA 94111 (37.795069, -122.401553)
1375 0050280-01-001 Eli Lilly & Company Eli Lilly & Company 100 California St San Francisco 1 CA 1 94111 35 01/01/2005   01/01/2005   Lilly Corporate Ctr Maildrop Code 1803 Indianapolis 105 46285 159 IN 3100-3399 10 Manufacturing 10 0 0           100 CALIFORNIA ST San Francisco, CA 94111 (37.793501, -122.398002)
1389 0101127-01-001 Mercer Inc Mercer Inc 3 Embarcadero Ctr San Francisco 1 CA 1 94111 35 02/01/1976   02/01/1976 03/31/2008 400 West Market St., Suite 700 Louisville 107 40202 162 KY 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           3 EMBARCADERO CTR San Francisco, CA 94111 (37.794966, -122.397302)
1394 0050318-01-001 Mckenna Long & Aldridge Llp Mckenna Long & Aldridge Llp 101 California St 4100 San Francisco 1 CA 1 94111 35 01/01/1969 06/30/2015 10/15/2007 06/30/2015         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   101 CALIFORNIA ST San Francisco, CA 94111 (37.793416, -122.397991)
1463 0013436-01-001 Gogma Joseph A Italian American Hotel 838 Sansome St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   838 Sansome St San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 1     3 1 Financial District/South Beach 1   838 SANSOME ST San Francisco, CA 94111 (37.798004, -122.402149)
1469 0013436-02-001 Gogma Joseph A 838 Sansome Bldg 838 Sansome St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   838 Sansome St 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   838 SANSOME ST San Francisco, CA 94111 (37.798004, -122.402149)
1522 0142072-02-001 Chemoil Corporation Oceanconnect Marine 4 Embarcadero Ctr 34th Flr San Francisco 1 CA 1 94111 35 09/01/1981 01/01/2017 09/24/2013 08/16/2014         4200-4299 7 Wholesale Trade 7 0 0           4 EMBARCADERO CTR FLR San Francisco, CA 94111 (37.795106, -122.396158)
1538 0001219-02-001 Ow Andrew Lansing Mfg Co 642 Washington St San Francisco 1 CA 1 94111 35 10/01/1968 12/31/2013 07/01/1974 12/31/2013             0 0     3 1 Chinatown 7   642 WASHINGTON ST San Francisco, CA 94111 (37.795424, -122.404233)
1563 0128161-02-001 Carpet Of The Inner Circle Inc Carpet Of The Inner Circle Inc 495 Jackson St San Francisco 1 CA 1 94111 35 03/01/1981   05/01/2011   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     3 1 Chinatown 7   495 JACKSON ST San Francisco, CA 94111 (37.796438, -122.403434)
1588 0142252-03-002 Godiva Chocolatier Inc Godiva Chocolatier 2 Embarcadero Cntr Str Lvl San+francisco 8 CA 1 94111 35 01/01/1983   02/10/1999 05/01/2016 1 Meridian Blvd 3c-1 Ste Wyomissing 119 19610 178 PA 7220-7229 8 Food Services 8 0 0           2 EMBARCADERO CNTR STR LVL San Francisco, CA 94111 (37.794812, -122.398499)
1607 0087393-01-001 Bagnatori Joseph & Paola Etal 415 Sansome Bldg 415 Sansome St San Francisco 1 CA 1 94111 35 07/01/1974   07/01/1974   551 Pacific Avenue San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   415 SANSOME ST San Francisco, CA 94111 (37.794309, -122.401406)
1642 0013799-01-001 Arnold & Porter Pc Arnold & Porter Pc 3 Embarcadero Ctr 700 San+francisco 8 CA 1 94111 35 01/01/2010 02/29/2016 12/31/2011 02/29/2016         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           3 EMBARCADERO CTR San Francisco, CA 94111 (37.794966, -122.397302)
1653 0087520-01-001 Gordon Stuart M-Rees Donald Gordon & Rees 275 Battery St 2000 San Francisco 1 CA 1 94111 35 10/01/1974   10/01/1974   275 Battery St #20fl San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   275 BATTERY ST San Francisco, CA 94111 (37.793915, -122.400111)
1656 0116615-02-001 Schainbaum Martin A Inc Martin A Schainbaum Inc 601 Montgomery St 688 San Francisco 1 CA 1 94111 35 08/28/1978   12/24/2013   601 Montgomery Street Suite 688 San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Chinatown 7   601 MONTGOMERY ST San Francisco, CA 94111 (37.794906, -122.403189)
1754 0462030-01-001 Brown Theodore W Theodore Brown 1620 Montgomery St San Francisco 1 CA 1 94111 35 04/28/1992   08/18/2011   1620 Montgomery St Ste 300 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   1620 MONTGOMERY ST San Francisco, CA 94111 (37.804073, -122.405018)
1777 0128315-01-001 Westchester Splty Ins Serv Inc Westchester Splty Ins Serv Inc 275 Battery St San Francisco 1 CA 1 94111 35 04/01/1980   01/01/1995   510 Walnut St Wb12a Philadelphia 85 19106 191 PA     0 0     3 1 Financial District/South Beach 1   275 BATTERY ST San Francisco, CA 94111 (37.793915, -122.400111)
1793 0041466-01-001 Hoy Yen Assn F S F Inc 57/67 Columbus Rentals 57 Columbus Ave San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   57 Columbus Av San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   57 COLUMBUS AVE San Francisco, CA 94111 (37.796226, -122.404302)
1837 0378329-03-001 Doyle Seamus Brandon 360 Skin 21 Columbus St 211 San+francisco 8 CA 1 94111 35 04/05/2012   04/05/2012 12/31/2012 21 Columbus Ave #208 San Francisco 1 94111 11 CA     0 0           21 COLUMBUS ST San Francisco, CA 94111 (37.795587, -122.403376)
1846 0128328-07-001 Nossaman Llp Nossaman Llp 50 California St #3400 San+francisco 8 CA 1 94111 35 04/01/1980   07/28/2008   777 South Figueroa Street Suite #3400 Los Angeles 3 90017 51 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           50 CALIFORNIA ST SAN FRANCISCO, CA 94111 (37.793604, -122.397307)
1848 0087755-04-001 Sheldon R Meyer Trustee Of The 825 Sansome Bldg 825 Sansome St San Francisco 1 CA 1 94111 35 05/17/1974   01/16/1981 01/01/2013 402 Jackson St 3rd Fl San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           825 SANSOME ST SAN FRANCISCO, CA 94111 (37.797909, -122.402129)
1882 0117118-03-001 Edmondson James P 750 Battery St Building 750 Battery St San Francisco 1 CA 1 94111 35 04/21/1979   01/01/1988   1380 S Harbor Blvd Anaheim 133 92802 197 CA 7210-7219 9 Accommodations 9 0 0     3 1 Financial District/South Beach 1   750 BATTERY ST San Francisco, CA 94111 (37.798255, -122.400991)
1885 0117118-04-001 Edmondson James P 720 Battery St Parking Lot 720 Battery St San Francisco 1 CA 1 94111 35 04/21/1979   04/21/1979   1380 S Harbor Blvd Anaheim 133 92802 197 CA 7210-7219 9 Accommodations 9 0 0     3 1 Financial District/South Beach 1   720 BATTERY ST San Francisco, CA 94111 (37.797914, -122.400925)
1897 0062121-01-001 Freinkel Robert Md Inc Freinkel Robert Md Inc 22 Battery St 914 San Francisco 1 CA 1 94111 35 07/01/1970 11/18/2015 07/01/1970 11/18/2015             0 0     3 1 Financial District/South Beach 1   22 BATTERY ST San Francisco, CA 94111 (37.791547, -122.399629)
1901 0128369-01-001 Harada Stephen D Harada Stephen D Dr 500 Sansome St 604 San Francisco 1 CA 1 94111 35 03/02/1981   05/20/1997   500 Sansome St #604 San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Chinatown 7   500 SANSOME ST San Francisco, CA 94111 (37.795069, -122.401553)
1908 0050864-01-001 Scatena Biago Etal 200/210 Green Bldg 200 Green St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   551 Pacific Avenue San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   200 GREEN ST San Francisco, CA 94111 (37.800269, -122.402894)
1968 0014539-02-001 Coblentz Etal Coblentz,patch,duffy & Bass One Ferry Building 200 San+francisco 8 CA 1 94111 35 10/01/1968   09/01/2003   One One Montgomery Street Suite 3000 San Francisco 1 94104 1 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           ONE FERRY San Francisco, CA 94111
2077 0142768-01-002 Mackenzie Communications Inc Mackenzie Communications Inc 847 Sansome St 250 San Francisco 1 CA 1 94111 35 07/05/1983   12/15/2011 01/01/2016 275 Battery Street 900 Ste. San Francisco 1 94111 11 CA     0 0     3 1 North Beach 6   847 SANSOME ST San Francisco, CA 94111 (37.798086, -122.402166)
2104 0050967-01-001 One California St. Partners One California Partners 1 California St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   1 California St Ste 225 San Francisco 1 94111 11 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0 D03 D26 Multiple 3 1 Financial District/South Beach 1   1 CALIFORNIA ST San Francisco, CA 94111 (37.793534, -122.397317)
2106 0117524-01-001 Cronos Capital Corp. Cronos Capital Corp. 1 Front St 925 San Francisco 1 CA 1 94111 35 12/31/1997   07/09/2001   7200 Nw 19th St Ste 500 Miami 145 33126 212 FL     0 0     6 3 Financial District/South Beach 1   1 FRONT ST San Francisco, CA 94111 (37.791868, -122.398473)
2162 0015229-01-001 Kaplan Mclaughlin Diaz Kaplan Mclaughlin Diaz 222 Vallejo St San Francisco 1 CA 1 94111 35 10/01/1968   10/01/1968   222 Vallejo St San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   222 VALLEJO ST San Francisco, CA 94111 (37.799467, -122.401728)
2165 0015229-04-001 Kaplan Mclaughlin Diaz Kmd 222 Vallejo St San Francisco 1 CA 1 94111 35 10/01/1968   12/22/1995   222 Vallejo St San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   222 VALLEJO ST San Francisco, CA 94111 (37.799467, -122.401728)
2166 0050967-02-001 One California St. Partners 1 California Garage 1 California St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/1970   1 California St Ste 225 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   1 CALIFORNIA ST San Francisco, CA 94111 (37.793534, -122.397317)
2169 0015229-05-001 Kaplan Mclaughlin Diaz Kmd Justice 222 Vallejo St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/1997   222 Vallejo St San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   222 VALLEJO ST San Francisco, CA 94111 (37.799467, -122.401728)
2172 0130295-01-005 Verizon Business Network Srvcs Mci Telecommunications Corp 444 Market St San Francisco 1 CA 1 94111 35 01/01/1979   03/31/2013   899 Heathrow Park Ln Lake Mary 148 32746 219 FL     0 0     3 1 Financial District/South Beach 1   444 MARKET ST SAN FRANCISCO, CA 94111 (37.791431, -122.398665)
2178 0130295-05-002 Verizon Business Network Srvcs Verizon Business Network Srvcs 274 Brannan Street #200 San+francisco 8 CA 1 94111 35 01/01/1979   03/31/2013   899 Heathrow Park Ln Lake Mary 148 32746 219 FL     0 0           274 BRANNAN STREET SAN FRANCISCO, CA 94111 (37.782345, -122.391471)
2179 0002289-01-001 Dryden Margoles Etal Dryden Margoles Etal 555 Montgomery St 750 San Francisco 1 CA 1 94111 35 10/01/1968   05/01/2011 04/30/2014 58 West Portal Ave #136 San Francisco 1 94127 46 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Chinatown 7   555 MONTGOMERY ST San Francisco, CA 94111 (37.794454, -122.403102)
2185 0130295-12-002 Verizon Business Network Srvcs Verizon Business Network Srvcs 1 Front Street San Francisco 1 CA 1 94111 35 01/01/1979   03/31/2013   899 Heathrow Park Ln Lake Mary 148 32746 219 FL     0 0     6 3 Financial District/South Beach 1   1 FRONT STREET SAN FRANCISCO, CA 94111 (37.791868, -122.398473)
2212 0128919-02-001 Kodama Diseno, Inc Kodama Diseno, Inc. 619 Sansome St San Francisco 1 CA 1 94111 35 03/01/1981   01/01/2012 05/31/2015 570 Tenth Street 2 Oakland 27 94607 223 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           619 SANSOME ST San Francisco, CA 94111 (37.796094, -122.401755)
2221 0015229-06-001 Kaplan Mclaughlin Diaz Kmd Architects 222 Vallejo St San Francisco 1 CA 1 94111 35 10/01/1968   01/01/2004   222 Vallejo St San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   222 VALLEJO ST San Francisco, CA 94111 (37.799467, -122.401728)
2263 0030032-01-039 Walgreen Co Walgreen Co 275 Sacramento St San Francisco 1 CA 1 94111 35 10/01/1968   06/02/2002   300 Wilmot Road Mail Stop 3301 Deerfield 135 60015 200 IL 4400-4599 3 Retail Trade 3 0 0 H08 Retail Food Market W/food Prep 10,001 - 20,000 Sqft 3 1 Financial District/South Beach 1   275 SACRAMENTO ST San Francisco, CA 94111 (37.794327, -122.398627)
2305 0128992-02-001 Berry Appleman & Leiden Llp Berry Appleman & Leiden Llp 353 Sacramento St 1300 San Francisco 1 CA 1 94111 35 11/07/1997   11/07/1997   353 Sacramento St #1300 San Francisco 1 94111 11 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   353 SACRAMENTO ST San Francisco, CA 94111 (37.79419, -122.399762)
2336 0428866-24-002 Bay Equity Llc Emac Home Loans 100 California St 1100 San Francisco 1 CA 1 94111 35 04/29/2008 11/01/2015 04/27/2012 11/01/2015 28 Liberty Ship Way Suite 2800 Sausalito 84 94965 125 CA 5210-5239 11 Financial Services 11 0 0     3 1 Financial District/South Beach 1   100 CALIFORNIA ST San Francisco, CA 94111 (37.793501, -122.398002)
2463 0147009-01-001 Foster-Gwin Inc Foster-Gwin Inc 38 Hotaling Place San Francisco 1 CA 1 94111 35 07/15/1984   07/15/1984 12/31/2011 38 Hotaling Place San Francisco 1 94111 11 CA 4200-4299 4400-4599 13 Multiple 13 0 0     3 1 Chinatown 7   38 HOTALING PLACE SAN FRANCISCO, CA 94111 (37.796093, -122.402842)
2464 0015408-01-005 Kelly Services Inc Kelly Temp Services 50 California St 2320 San Francisco 1 CA 1 94111 35 10/01/1968   01/01/1995   Po Box 331179 Detroit 162 48266 237 MI 5600-5699 16 Administrative and Support Services 16 0 0     3 1 Financial District/South Beach 1   50 CALIFORNIA ST San Francisco, CA 94111 (37.793604, -122.397307)

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