home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Location Id

View and edit SQL

Suggested facets: 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
10588 0000024-02-999 Eastman Kodak Co Eastman Kodak Co 343 State St Rochester 227 NY 4 14650 351 01/01/2003   01/01/2003   343 State Street Rochester 207 14650 639 NY 3100-3399 10 Manufacturing 10 0 0           343 STATE ST ROCHESTER, NY 14650 (43.161276, -77.619386)
6 0000028-02-001 Ferrando Louise 3101 Laguna Apts 3101 Laguna St San Francisco 1 CA 1 94123 3 09/30/1993   09/30/1993   2799 California St San Francisco 1 94115 2 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3101 LAGUNA ST San Francisco, CA 94123 (37.799823, -122.430996)
5593 0000052-01-001 Ideal Novak Corp Ideal Novak Corp 8 Mendosa Ave San Francisco 1 CA 1 94116 23 10/01/1968   10/01/1968   8 Mendosa Ave San Francisco 1 94116 45 CA 4400-4599 3 Retail Trade 3 0 0     7 9 West of Twin Peaks 26   8 MENDOSA AVE San Francisco, CA 94116 (37.748926, -122.465074)
12069 0000071-01-001 Tournahu George L Tournahu Arms 1842 Jefferson St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968 12/31/2013 4444 Geary Blvd. 100 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1842 JEFFERSON ST San Francisco, CA 94123 (37.804734, -122.442997)
214847 0000071-02-001 Tournahu George L 3301 Broderick Apartments 3301 Broderick St San Francisco 1 CA 1 94123 3 10/01/1968   05/01/1988 12/31/2013 4444 Geary Blvd. 100 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3301 BRODERICK ST San Francisco, CA 94123 (37.800876, -122.444757)
214848 0000071-02-003 Tournahu George L 3301 Broderick Apartments 3301 Broderick St San Francisco 1 CA 1 94123 3 10/01/1968   05/01/1988 12/31/2013 4444 Geary Blvd. 100 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   3301 BRODERICK ST San Francisco, CA 94123 (37.800876, -122.444757)
214849 0000071-03-001 Tournahu George L 1840-42 Jefferson St 1840-42 Jefferson St San Francisco 1 CA 1 94109 24 10/01/1968   10/07/1991   4444 Geary Blvd. 100 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0     2 Marina 2   1840 42 JEFFERSON ST San Francisco, CA 94109 (37.804759, -122.442794)
214850 0000086-01-001 Harry D Som Living Trust 1601 Grant Apts 1601 Grant Ave San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   714 Van Ness Ave San Francisco 1 94102 16 CA     0 0     3 1 North Beach 6   1601 GRANT AVE San Francisco, CA 94133 (37.801724, -122.407812)
214851 0000086-02-002 Harry D Som Living Trust 1601 Grant Parking 1601 Grant Ave San Francisco 1 CA 1 94133 11 10/01/1968   01/01/2013   714 Van Ness Ave San Francisco 1 94102 16 CA     1 0     3 1 North Beach 6   1601 GRANT AVE San Francisco, CA 94133 (37.801724, -122.407812)
12209 0000188-01-001 Abbett Elec Corp Abbett Elec Corp 1850 Bryant St San Francisco 1 CA 1 94110 18 10/01/1968   10/01/1968   1850 Bryant St San Francisco 1 94110 37 CA 2300-2399 6 Construction 6 0 0 D26 Station Tanks - Above Ground 9 8 Mission 12   1850 BRYANT ST San Francisco, CA 94110 (37.76378, -122.410307)
13004 0000189-02-001 Tc Mcmechen Inc Abbey Carpet 2900 Geary Blvd San Francisco 1 CA 1 94118 6 10/01/1968   07/27/2012   2900 Geary Blvd San Francisco 1 94118 28 CA 4400-4599 3 Retail Trade 3 0 0     2 Presidio Heights 3   2900 GEARY BLVD San Francisco, CA 94118 (37.782133, -122.450433)
13542 0000189-03-001 Tc Mcmechen Inc Abbey Carpet Of San Francisco 2900 Geary Blvd San Francisco 1 CA 1 94118 6 10/01/1968   10/01/2013   2900 Geary Blvd San Francisco 1 94118 28 CA 4400-4599 3 Retail Trade 3 0 0     2 Presidio Heights 3   2900 GEARY BLVD San Francisco, CA 94118 (37.782133, -122.450433)
26664 0000205-01-001 Abc Auto Parts Abc Auto Parts 1650 Davidson Ave San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   1650 Davidson Av San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0 D02 D03 D20 P19 P52 Multiple 10 4 Bayview Hunters Point 4   1650 DAVIDSON AVE San Francisco, CA 94124 (37.746192, -122.392421)
26719 0000216-01-001 Sasser Jr Jake Abc Insurance 1727 Oakdale Ave San Francisco 1 CA 1 94124 8 10/01/1968   10/24/2002   1727 Oakdale Av San Francisco 1 94124 6 CA     0 0     10 4 Bayview Hunters Point 4   1727 OAKDALE AVE San Francisco, CA 94124 (37.736139, -122.393059)
27211 0000216-02-001 Sasser Jr Jake J & E Construction 1727 Oakdale Ave San Francisco 1 CA 1 94124 8 10/01/1968   08/27/1999   1727 Oakdale Av San Francisco 1 94124 6 CA     0 0     10 4 Bayview Hunters Point 4   1727 OAKDALE AVE San Francisco, CA 94124 (37.736139, -122.393059)
184105 0000224-01-001 Abc Window Contractors Inc Abc Window Contractors Inc 811 Cesar Chavez St San Francisco 1 CA 1 94124 8 10/01/1968   09/29/1997 10/31/2015 803 Vaca Valley Parkway Vacaville 229 95688 1080 CA     0 0     10 4 Bayview Hunters Point 4   811 CESAR CHAVEZ ST San Francisco, CA 94124 (37.75034, -122.386099)
184106 0000244-01-001 Crown Building Maintenance Co Able Building Maintenance Co 868 Folsom St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   868 Folsom St San Francisco 1 94107 47 CA 5600-5699 16 Administrative and Support Services 16 0 0     6 3 South of Market 15   868 FOLSOM ST San Francisco, CA 94107 (37.780746, -122.402797)
184107 0000244-02-001 Crown Building Maintenance Co Able Services 868 Folsom St San Francisco 1 CA 1 94107 22 10/01/1968   04/01/2005   868 Folsom St San Francisco 1 94107 47 CA 5600-5699 16 Administrative and Support Services 16 0 0     6 3 South of Market 15   868 FOLSOM ST San Francisco, CA 94107 (37.780746, -122.402797)
8 0000265-01-001 Stephens Institute Inc Academy Of Art University 79 New Montgomery St 3rd Fl San Francisco 1 CA 1 94105 7 10/01/1968   03/01/2004   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D03 Portable Containers 6 3 Financial District/South Beach 1   79 NEW MONTGOMERY ST San Francisco, CA 94105 (37.7877, -122.400776)
32 0000265-04-001 Stephens Institute Inc Acad Art College Supply Store 79 New Montgomery St San Francisco 1 CA 1 94105 7 10/01/1968   02/01/1993   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     6 3 Financial District/South Beach 1   79 NEW MONTGOMERY ST San Francisco, CA 94105 (37.7877, -122.400776)
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)
93 0000265-06-002 Stephens Institute Inc Academy Of Art University 2225 Jerrold Ave San Francisco 1 CA 1 94124 8 10/01/1968   05/29/2009   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D14 D18 D19 D26 Multiple 10 4 Bayview Hunters Point 4   2225 JERROLD AVE San Francisco, CA 94124 (37.74525, -122.400812)
112 0000265-06-003 Stephens Institute Inc Academy Of Art University 180 New Montgomery St San Francisco 1 CA 1 94105 7 10/01/1968   04/28/1995   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D03 D04 D39 Multiple 6 3 Financial District/South Beach 1   180 NEW MONTGOMERY ST San Francisco, CA 94105 (37.786634, -122.399502)
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)
125 0000265-06-005 Stephens Institute Inc Academy Of Art University 460 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   10/02/2009   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     6 3 Mission Bay 25   460 TOWNSEND ST San Francisco, CA 94107 (37.774234, -122.398633)
150 0000265-06-006 Stephens Institute Inc Academy Of Art University 1835-49 Van Ness Ave San Francisco 1 CA 1 94109 24 10/01/1968   06/09/1998   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D03 D05 D10 D19 D31 Multiple 2 Pacific Heights 16   1835 49 VAN NESS AVE San Francisco, CA 94109 (37.792972, -122.422943)
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)
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)
204 0000265-08-001 Stephens Institute Inc Academy Of Art University 121 Wisconsin St San Francisco 1 CA 1 94107 22 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     10 4 Mission Bay 25   121 WISCONSIN ST San Francisco, CA 94107 (37.765733, -122.39975)
10601 0000265-09-001 Stephens Institute Inc Academy Of Art University 150 Hayes St San Francisco 1 CA 1 94102 16 10/01/1968   01/01/2012   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     6 3 Tenderloin 11   150 HAYES ST SAN FRANCISCO, CA 94102 (37.777396, -122.418822)
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)
270 0000265-11-001 Stephens Institute Inc Academy Of Art University 2801 Leavenworth St San Francisco 1 CA 1 94133 11 10/01/1968   05/23/2011   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D03 D19 D39 Multiple 2 Russian Hill 5   2801 LEAVENWORTH ST San Francisco, CA 94133 (37.807088, -122.418926)
278 0000265-12-001 Stephens Institute Inc Academy Of Art University 466 Townsend St San Francisco 1 CA 1 94107 22 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 D26 Station Tanks - Above Ground 6 3 Mission Bay 25   466 TOWNSEND ST San Francisco, CA 94107 (37.773883, -122.399076)
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)
328 0000265-14-001 Stephens Institute Inc Academy Of Art University 601 Brannan St San Francisco 1 CA 1 94107 22 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 D03 D26 Multiple 6 3 Mission Bay 25   601 BRANNAN ST San Francisco, CA 94107 (37.776302, -122.399103)
214871 0000265-15-001 Stephens Institute Inc Academy Of Art University 625 Polk St San Francisco 1 CA 1 94102 16 10/01/1968   08/15/2011   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D03 D31 Multiple 6 3 Tenderloin 11   625 POLK ST San Francisco, CA 94102 (37.782393, -122.419041)
355 0000265-16-001 Stephens Institute Inc Academy Of Art University 631 Howard St San Francisco 1 CA 1 94105 7 10/01/1968   01/02/2011 08/31/2013 79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     6 3 Financial District/South Beach 1   631 HOWARD ST San Francisco, CA 94105 (37.786347, -122.398792)
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)
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)
404 0000265-19-001 Stephens Institute Inc Academy Of Art University 701 Chestnut St San Francisco 1 CA 1 94133 11 10/01/1968   02/11/2011   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     3 1 Russian Hill 5   701 CHESTNUT ST San Francisco, CA 94133 (37.803547, -122.41492)
413 0000265-20-001 Stephens Institute Inc Academy Of Art University 860 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   860 SUTTER ST San Francisco, CA 94102 (37.788878, -122.411407)
455 0000265-21-001 Stephens Institute Inc Academy Of Art University 60 Federal St San Francisco 1 CA 1 94107 22 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 D26 Station Tanks - Above Ground 6 3 Financial District/South Beach 1   60 FEDERAL ST San Francisco, CA 94107 (37.783211, -122.392413)
541 0000265-22-001 Stephens Institute Inc Academy Of Art University 740 Taylor St San Francisco 1 CA 1 94108 9 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   740 TAYLOR ST San Francisco, CA 94108 (37.789316, -122.41202)
552 0000286-01-001 Ace Boiler & Welding Co Inc Ace Boiler & Welding Co Inc 601 19th St San Francisco 1 CA 1 94107 22 10/01/1968   01/01/1995   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     10 4 Potrero Hill 28   601 19TH ST San Francisco, CA 94107 (37.761755, -122.388981)
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)
563 0000422-01-001 Kurt S. Adler Inc. Adler Kurt S Inc 680 Eighth Street 157 San Francisco 1 CA 1 94103 25 10/01/1968   01/01/2011   122 E 42 St New York 49 10168 96 NY 4200-4299 7 Wholesale Trade 7 0 0     6 3 South of Market 15   680 EIGHTH STREET San Francisco, CA 94103 (37.770475, -122.404476)
577 0000424-01-001 Ebk Enterprise Et Al Floral Supply Syndicate 670 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   Po Box 1305 Camarillo 62 93011 97 CA 4200-4299 7 Wholesale Trade 7 0 0     6 3 South of Market 15   670 BRANNAN ST San Francisco, CA 94107 (37.775325, -122.400344)
589 0000424-01-002 Ebk Enterprise Et Al Floral Supply Syndicate 649 Brannan St San Francisco 1 CA 1 94158 58 10/01/1968   09/16/2011   Po Box 1305 Camarillo 62 93011 97 CA 4200-4299 7 Wholesale Trade 7 0 0     6 3 Mission Bay 25   649 BRANNAN ST San Francisco, CA 94158 (37.775573, -122.40003)
627 0000429-01-001 Federal Auto Parks Inc Federal Auto Parks Inc 530 Turk St San Francisco 1 CA 1 94102 16 10/01/1968 06/15/2014 10/01/1968 06/15/2014             0 0     6 3 Tenderloin 11   530 TURK ST San Francisco, CA 94102 (37.782293, -122.417994)
628 0000481-01-001 Agentours Inc Agentours Inc 126 West Portal Ave San Francisco 1 CA 1 94127 31 10/01/1968   10/01/1968   126 West Portal Av San Francisco 1 94127 46 CA 4200-4299 7 Wholesale Trade 7 0 0     7 9 West of Twin Peaks 26   126 WEST PORTAL AVE San Francisco, CA 94127 (37.739525, -122.46731)
657 0000482-01-001 Fugazi Travel Agency, Inc. Fugazi Travel Agency, Inc. 170 Grant Ave 4th Fl San Francisco 1 CA 1 94108 9 10/01/1968   02/01/2009 08/31/2015 345 California Street 160 Ste San Francisco 1 94104 1 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Financial District/South Beach 1   170 GRANT AVE San Francisco, CA 94108 (37.788511, -122.405174)
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)
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)
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)
759 0000484-01-001 Agid Hyman D Agid Hyman D 452 Gellert Dr San Francisco 1 CA 1 94132 32 10/01/1968 05/06/2017 10/01/1968 05/06/2017         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     7 9 Sunset/Parkside 14   452 GELLERT DR San Francisco, CA 94132 (37.730494, -122.48987)
766 0000553-01-001 Wong William V Etal Akron Meat Market 3325 20th St San Francisco 1 CA 1 94110 18 10/01/1968   10/01/1968   3325 20th St San Francisco 1 94110 37 CA 4400-4599 3 Retail Trade 3 0 0 H07 Retail Food Market W/food Prep. Lt 5001 Sqft 9 8 Mission 12   3325 20TH ST San Francisco, CA 94110 (37.758859, -122.415292)
773 0000631-03-001 Aon Risk Services Inc Of N Cal Aon Risk Services Inc Of N Cal 199 Fremont St 1500 San Francisco 1 CA 1 94105 7 10/01/1968   07/28/2009   1100 Reynolds Blvd Winston Salem 71 27105 112 NC     0 0     6 3 Financial District/South Beach 1   199 FREMONT ST San Francisco, CA 94105 (37.789371, -122.395309)
778 0000668-01-001 Alioto F Co Inc F Alioto Fish Co 440 Jefferson St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   440 Jefferson St San Francisco 1 94109 7 CA 4200-4299 7 Wholesale Trade 7 0 0     2 Russian Hill 5   440 JEFFERSON ST San Francisco, CA 94109 (37.807739, -122.419621)
802 0000670-01-001 F & A Properties Alioto Frank & Anthony 155 Jefferson St 100 San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   155 Jefferson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   155 JEFFERSON ST San Francisco, CA 94133 (37.8083, -122.415103)
815 0000671-01-001 Alioto Fish Co Ltd Aliotos 360a Jefferson St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   360a Jefferson St. San Francisco 1 94133 9 CA 7220-7229 8 Food Services 8 0 0 H33 Commissary 3 1 North Beach 6   360A JEFFERSON ST San Francisco, CA 94133 (37.807882, -122.418442)
833 0000671-01-002 Alioto Fish Co Ltd Aliotos 8 Fishermanswharf San+francisco 8 CA 1 94133 11 10/01/1968   10/01/1968   360a Jefferson St. San Francisco 1 94133 9 CA 7220-7229 8 Food Services 8 0 0 H26 H73 Multiple       8 FISHERMANSWHARF San Francisco, CA 94133 (37.809302, -122.41656)
937 0000671-08-001 Alioto Fish Co Ltd Nonna Rose Restaurant Inc 8 Fisherman's Wharf San Francisco 1 CA 1 94133 11 10/01/1968   04/28/2008   360a Jefferson St. San Francisco 1 94133 9 CA 7220-7229 8 Food Services 8 0 0 H25 Restaurant 1,000 - 2,000 Sqft       8 FISHERMAN S WHARF San Francisco, CA 94133
850 0000671-09-001 Alioto Fish Co Ltd Afc Cafe 8 Inc 8 Fisherman's Wharf San+francisco 8 CA 1 94133 11 10/01/1968   04/28/2008   360a Jefferson St. San Francisco 1 94133 9 CA 7220-7229 8 Food Services 8 0 0           8 FISHERMAN S WHARF San Francisco, CA 94133
857 0000671-10-001 Alioto Fish Co Ltd Afc Crabstand Inc 8 Fisherman's Wharf San Francisco 1 CA 1 94133 11 10/01/1968   04/28/2008   360a Jefferson St. San Francisco 1 94133 9 CA 7220-7229 8 Food Services 8 0 0           8 FISHERMAN S WHARF San Francisco, CA 94133
214875 0000675-02-001 Nunzio Corp The 2653/2683 Taylor Bldg 2653 Taylor St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   155 Jefferson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   2653 TAYLOR ST San Francisco, CA 94133 (37.807021, -122.415569)
870 0000675-03-001 Nunzio Corp The Nunzio Corp The 155 Jefferson St San Francisco 1 CA 1 94133 11 10/01/1968   01/01/2005   155 Jefferson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   155 JEFFERSON ST San Francisco, CA 94133 (37.8083, -122.415103)
875 0000707-01-999 Allan Auto Sprinkler Corp Allan Auto Sprinkler Corp 20303 Mack St Hayward Hayward 38 CA 1 94545 64 10/01/1968   10/01/1968   20303 Mack St Hayward 82 94545 123 CA 2300-2399 6 Construction 6 0 0           20303 MACK ST HAYWARD HAYWARD, CA 94545 (37.654301, -122.13198)
883 0000742-01-001 Mccombs John N Allens Press Clip Bureau 657 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   10/01/1968   657 Mission St Rm 602 San Francisco 1 94105 5 CA 5100-5199 15 Information 15 0 0     6 3 Financial District/South Beach 1   657 MISSION ST San Francisco, CA 94105 (37.787005, -122.40107)
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)
923 0000817-01-001 Felton Donald & Nancy Almac Camera Shop 445 Stockton St San Francisco 1 CA 1 94108 9 10/01/1968   07/01/1996   445 Stockton St San Francisco 1 94108 22 CA     0 0     3 1 Financial District/South Beach 1   445 STOCKTON ST San Francisco, CA 94108 (37.789827, -122.407056)
926 0000817-02-001 Felton Donald & Nancy Almac Camera Store 445 Stockton St San Francisco 1 CA 1 94108 9 10/01/1968   07/01/1996   445 Stockton St San Francisco 1 94108 22 CA     0 0     3 1 Financial District/South Beach 1   445 STOCKTON ST San Francisco, CA 94108 (37.789827, -122.407056)
943 0000822-01-001 Alouis Auto Radiator Inc Alouis Auto Radiator Inc 650 Divisadero St San Francisco 1 CA 1 94117 33 10/01/1968   10/01/1968 09/30/2014 1970 Mcallister St San Francisco 1 94115 2 CA 4400-4599 3 Retail Trade 3 0 0     5 7 Hayes Valley 10   650 DIVISADERO ST San Francisco, CA 94117 (37.775675, -122.437902)
992 0000912-01-001 Ambassador Tours Inc Ambassador Tours Inc 50 1st Street 610 San Francisco 1 CA 1 94105 7 10/01/1968   10/01/1997 09/12/2017 300 Montgomery Street 424 San Francisco 1 94104 1 CA     0 0     6 3 Financial District/South Beach 1   50 1ST STREET San Francisco, CA 94105 (37.790463, -122.398419)
1000 0000912-02-001 Ambassador Tours Inc Am Media Services 50 1st Street 610 San Francisco 1 CA 1 94105 7 10/01/1968   01/01/1999 09/12/2017 300 Montgomery Street 424 San Francisco 1 94104 1 CA     0 0     6 3 Financial District/South Beach 1   50 1ST STREET San Francisco, CA 94105 (37.790463, -122.398419)
1010 0000962-01-001 Amer Canvas Products Amer Canvas Products 1600 Cortland Ave San Francisco 1 CA 1 94110 18 10/01/1968   10/01/1968   1600 Cortland Av San Francisco 1 94110 37 CA 2300-2399 6 Construction 6 0 0     9 8 Bernal Heights 19   1600 CORTLAND AVE San Francisco, CA 94110 (37.739673, -122.408879)
1020 0000962-02-001 Amer Canvas Products American Canvas & Awning 1600 Cortland Ave San Francisco 1 CA 1 94110 18 10/01/1968   07/01/2010   1600 Cortland Av San Francisco 1 94110 37 CA 2300-2399 6 Construction 6 0 0     9 8 Bernal Heights 19   1600 CORTLAND AVE San Francisco, CA 94110 (37.739673, -122.408879)
1039 0000962-03-001 Amer Canvas Products San Francisco Awnings 1600 Cortland Ave San Francisco 1 CA 1 94110 18 10/01/1968   07/01/2010   1600 Cortland Av San Francisco 1 94110 37 CA 2300-2399 6 Construction 6 0 0     9 8 Bernal Heights 19   1600 CORTLAND AVE San Francisco, CA 94110 (37.739673, -122.408879)
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)
1052 0001106-01-001 Amer Terrazzo Co-A Corp Amer Terrazzo Co-A Corp 36 Wood St San Francisco 1 CA 1 94118 6 10/01/1968   01/01/2012   36 Wood St San Francisco 1 94118 28 CA 2300-2399 6 Construction 6 0 0 D03 D19 D31 Multiple 2 Presidio Heights 3   36 WOOD ST San Francisco, CA 94118 (37.783387, -122.449292)
1060 0001132-01-001 Amore Robert Amore & Co. Realtors 1958 Union St San Francisco 1 CA 1 94123 3 05/31/2013   05/31/2013   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     2 Marina 2   1958 UNION ST San Francisco, CA 94123 (37.797589, -122.431571)
1062 0001155-03-002 Campana A E 745 14th St Parking Lot 745 14th St San Francisco 1 CA 1 94114 34 01/01/1968   01/01/1977   2120 Market St #100 San Francisco 1 94114 43 CA     0 0     8 5 Castro/Upper Market 30   745 14TH ST San Francisco, CA 94114 (37.767664, -122.430039)
1069 0001155-05-001 Campana A E 2120-2122 Market Bldg 2120 Market St San Francisco 1 CA 1 94114 34 01/01/1968   10/01/1968   2120 Market St #100 San Francisco 1 94114 43 CA     0 0     8 5 Castro/Upper Market 30   2120 MARKET ST San Francisco, CA 94114 (37.76718, -122.429469)
1078 0001155-07-001 Campana A E 3643-3647 17th St Building 3643 17th St San Francisco 1 CA 1 94114 34 01/01/1968   02/16/1990   2120 Market St #100 San Francisco 1 94114 43 CA     0 0     8 5 Castro/Upper Market 30   3643 17TH ST San Francisco, CA 94114 (37.762976, -122.427321)
1079 0001163-02-001 Cal Parlor Car Tours Inc Cal Parlor Car Tours Inc 500 Sutter St 401 San Francisco 1 CA 1 94102 16 10/01/1968   03/16/2010   500 Sutter St Ste 401 San Francisco 1 94102 16 CA     0 0     3 1 Nob Hill 17   500 SUTTER ST San Francisco, CA 94102 (37.789211, -122.408868)
1098 0001181-01-001 Anderson Enterprises Inc Royal Motor Sales 285 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0 D10 D23 Multiple 9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1100 0001181-02-001 Anderson Enterprises Inc Royal Audi 300 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1107 0001181-04-001 Anderson Enterprises Inc San Francisco Volvo 285 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1129 0001181-06-001 Anderson Enterprises Inc San Francisco Mazda 280 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1133 0001181-07-001 Anderson Enterprises Inc Royal Volkswagen 280 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1160 0001181-08-001 Anderson Enterprises Inc Royal Motors Volvo 285 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1165 0001181-09-001 Anderson Enterprises Inc Royal Motors Volkswagen 280 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1202 0001181-10-001 Anderson Enterprises Inc Royal Motors Audi 300 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1213 0001181-11-001 Anderson Enterprises Inc Royal Motors 285 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1227 0001181-12-001 Anderson Enterprises Inc Royal Volvo 285 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1234 0001181-13-001 Anderson Enterprises Inc Royal Mazda 280 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1253 0001181-15-001 Anderson Enterprises Inc Royal Motors Mazda 280 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1258 0001181-16-001 Anderson Enterprises Inc San Francisco Audi 300 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)
1265 0001181-17-001 Anderson Enterprises Inc San Francisco Volkswagen 280 S Van Ness Ave San Francisco 1 CA 1 94103 25 10/01/1968   01/02/1997   285 S Van Ness Ave San Francisco 1 94103 32 CA 4400-4599 3 Retail Trade 3 0 0     9 8 Mission 12   285 S VAN NESS AVE San Francisco, CA 94103 (37.768642, -122.417827)

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