home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

5,790 rows where Mail Zipcode = 47 sorted by NAICS Code

View and edit SQL

Suggested facets: State, Mail City, NAICS Code Description, Parking Tax, Transient Occupancy Tax, Supervisor District

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
1353 0050253-01-001 Maillard John & Laiola, Et Al 53-69 Bluxome Bldg 63 Bluxome St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   63 Bluxome San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   63 BLUXOME ST San Francisco, CA 94107 (37.776606, -122.39717)
1683 0128314-01-001 Martin M Ron Associates Inc Martin M Ron Associates Inc 859 Harrison St #200 San+francisco 8 CA 1 94107 22 10/01/1999   10/01/1999   859 Harrison St Ste #200 San Francisco 1 94107 47 CA     0 0           859 HARRISON ST San Francisco, CA 94107 (37.779705, -122.401009)
1820 0029694-01-001 Venetian Natural Marble Co In Venetian Natural Marble Co Inc 991 Harrison St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   991 Harrison St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   991 HARRISON ST San Francisco, CA 94107 (37.777614, -122.40366)
2058 0387854-02-001 Pyramind Inc Pyramind Music 880 Folsom St San Francisco 1 CA 1 94107 22 01/27/2004   01/27/2004   880 Folsom St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   880 FOLSOM ST San Francisco, CA 94107 (37.780658, -122.402909)
2156 0128910-01-001 Cheung Chi-Kong Hong Kong Printing 755 Pennsylvania Ave San Francisco 1 CA 1 94107 22 03/15/1981   02/18/1997   755 Pennsylvania Ave San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   755 PENNSYLVANIA AVE San Francisco, CA 94107 (37.756388, -122.392995)
2961 0118683-01-001 Lam Emilio & Felisa Patricia Trans Bay Printing 555 Bryant St San Francisco 1 CA 1 94107 22 07/09/1979   07/09/1979   Po Box 77265 San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   555 BRYANT ST San Francisco, CA 94107 (37.780242, -122.397187)
3537 0016922-01-001 Lewis & Taylor, Llc Lewis & Taylor Inc 440 Bryant St San Francisco 1 CA 1 94107 22 12/31/2008   12/31/2008   440 Bryant St San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   440 BRYANT ST San Francisco, CA 94107 (37.782295, -122.394584)
3991 0432672-02-001 Zheng Xiaojie New Era Art 1250 Missouri St 201 San Francisco 1 CA 1 94107 22 09/26/2008   01/09/2012   1250 Missouri St #201 San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1250 MISSOURI ST San Francisco, CA 94107 (37.750616, -122.395346)
4017 0063320-01-001 Mitchell-Michael Properties 1051 26th St Bldg 1051 26th St San Francisco 1 CA 1 94107 22 04/01/1974   04/01/1974 10/26/2014 1580 Indiana St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1051 26TH ST San Francisco, CA 94107 (37.751434, -122.389901)
4021 0063320-02-001 Mitchell-Michael Properties 1500-1580 Indiana Bldg 1580 Indiana St San Francisco 1 CA 1 94107 22 04/01/1974   04/01/1974   1580 Indiana St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1580 INDIANA ST San Francisco, CA 94107 (37.750349, -122.390464)
4401 0075867-01-001 Cal Pac Bulletins Cal Pac Bulletins/media 476 5th St San Francisco 1 CA 1 94107 22 03/01/1972   03/01/1972   476 5th St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   476 5TH ST San Francisco, CA 94107 (37.778127, -122.400714)
4439 0455152-01-001 Prosetta Inc Prosetta Inc 6705 5th St San+francisco 8 CA 1 94107 22 01/04/2011   01/04/2011   670 5th St San Francisco 1 94107 47 CA     0 0           6705 5TH ST San Francisco, CA 94107
4613 0036833-01-001 Speyer Stanley A 720 Haight St Apts 720 Haight St San Francisco 1 CA 1 94117 33 10/01/1968   10/01/1968   665 3rd St #408 San Francisco 1 94107 47 CA     0 0     5 7 Haight Ashbury 32   720 HAIGHT ST San Francisco, CA 94117 (37.771619, -122.434251)
5054 0064300-01-001 Edmondson John R Inc Ciarlo Bros 765 Bryant St San Francisco 1 CA 1 94107 22 06/01/1971   06/01/1971   765 Bryant St San Francisco 1 94107 47 CA     0 0 D10 Application Of Flammable Finishes 6 3 South of Market 15   765 BRYANT ST San Francisco, CA 94107 (37.776742, -122.401642)
5071 0131999-01-001 Hoctel Patrick-Elhauge Edward Lever Industries 1100 Tennessee St San Francisco 1 CA 1 94107 22 09/01/2007   09/01/2007   1100 Tennessee St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1100 TENNESSEE ST San Francisco, CA 94107 (37.757768, -122.389214)
5148 0092537-03-001 Jomira Advance Corp Haverhills 470 3rd St 211 San Francisco 1 CA 1 94107 22 10/09/2012   10/10/2012   470 3rd St 211 San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   470 3RD ST San Francisco, CA 94107 (37.78166, -122.396243)
5570 0325688-04-001 Cunningham David A David Cunningham Projects 855 Folsom St 126 San Francisco 1 CA 1 94107 22 08/01/2003 08/30/2015 08/24/2007 08/30/2015 855 Folsom St #126 San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   855 FOLSOM ST San Francisco, CA 94107 (37.781073, -122.402384)
5731 0478322-01-001 Hind Nicola Bateau Hair Salon 2 Townsend 4b San+francisco 8 CA 1 94107 22 05/01/2013   05/01/2013   2 Townsend #4b San Francisco 1 94107 47 CA     0 0           2 TOWNSEND San Francisco, CA 94107 (37.78163, -122.389225)
6869 0108040-01-001 Wine House Ltd Wine House The 129 Carolina St San Francisco 1 CA 1 94103 25 12/31/2013   02/28/2001 03/25/2014 829 26th Street San Francisco 1 94107 47 CA     0 0     10 4 Mission Bay 25   129 CAROLINA ST San Francisco, CA 94103 (37.765506, -122.400626)
6873 0108040-02-001 Wine House Ltd Wine House The 829 26th St San Francisco 1 CA 1 94107 22 12/31/2013   03/26/2014   829 26th Street San Francisco 1 94107 47 CA     0 0 H03 H73 Multiple 10 4 Bayview Hunters Point 4   829 26TH ST San Francisco, CA 94107 (37.75153, -122.388647)
7132 0108491-01-001 Yellow Cab Cooperative Inc Yellow Cab Co 1200 Mississippi St San Francisco 1 CA 1 94107 22 11/09/1977   11/09/1977   1200 Mississippi St San Francisco 1 94107 47 CA     0 0 D23 Vehicle Repair Garage - Major       1200 MISSISSIPPI ST San Francisco, CA 94107 (37.750084, -122.39339)
7140 0108491-02-001 Yellow Cab Cooperative Inc Yellow Cab Co 1200 Mississippi St San Francisco 1 CA 1 94107 22 11/09/1977   01/03/2004   1200 Mississippi St San Francisco 1 94107 47 CA     1 0 D08 D10 D19 D39 Multiple       1200 MISSISSIPPI ST San Francisco, CA 94107 (37.750084, -122.39339)
7183 0108491-03-001 Yellow Cab Cooperative Inc All Taxi Electronics 1760 Cesar Chavez St Unit N San Francisco 1 CA 1 94124 8 11/09/1977   02/01/2013   1200 Mississippi St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1760 CESAR CHAVEZ ST UNIT N San Francisco, CA 94124
7213 0135252-01-001 Mcgary John H Real Estate Service 980 Minnesota St D San Francisco 1 CA 1 94107 22 04/15/1982   04/15/1982   980 Minnesota St #D San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   980 MINNESOTA ST D San Francisco, CA 94107 (37.758061, -122.390222)
7215 0135252-02-001 Mcgary John H Real Estate & Insurance Srvcs 980 Minnesota St C San Francisco 1 CA 1 94107 22 04/15/1982   03/22/2013   980 Minnesota St #D San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   980 MINNESOTA ST C San Francisco, CA 94107 (37.758061, -122.390222)
7527 1027594-05-151 Bitter Blue Llc Voisin 900 22nd St San Francisco 1 CA 1 94107 22 04/08/2015   05/06/2015 05/06/2015 900 22nd St San Francisco 1 94107 47 CA     0 0           900 22ND ST SAN FRANCISCO, CA 94107 (37.757811, -122.390391)
8086 0009722-01-001 Florindo Cimino Flos Barber Shop 1532 20th St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   1532 20th St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1532 20TH ST San Francisco, CA 94107 (37.759991, -122.396998)
8474 1025581-04-151 Puma Power Wash Inc Puma Power Wash Inc 435 23rd St San Francisco 1 CA 1 94107 22 01/08/2014   01/08/2014   435 23rd St San Francisco 1 94107 47 CA     0 0           435 23RD ST SAN FRANCISCO, CA 94107 (37.75566, -122.38418)
8928 1035250-07-151 Honeybook Inc Honeybook Inc 539 Bryant St #210 San+francisco 8 CA 1 94107 22 11/13/2013   06/08/2015   539 Bryant St Unit 210 San Francisco 1 94107 47 CA     0 0           539 BRYANT ST SAN FRANCISCO, CA 94107 (37.78042, -122.396972)
8937 0150923-01-001 H & P Auto Repair Inc H & P Auto Repair & Towing 943 Harrison St San Francisco 1 CA 1 94107 22 04/01/1985   04/01/1985   943 Harrison St San Francisco 1 94107 47 CA     0 0 D23 Vehicle Repair Garage - Major 6 3 South of Market 15   943 HARRISON ST San Francisco, CA 94107 (37.77831, -122.402773)
8966 0373601-04-001 Morsch Six N Six Morsch Gardening 114 Trumbull St San Francisco 1 CA 1 94112 28 01/22/2004   04/21/2009   1459 18th St # 224 San Francisco 1 94107 47 CA     0 0     11 Excelsior 23   114 TRUMBULL ST San Francisco, CA 94112 (37.730816, -122.427992)
9132 0387109-04-001 Martin Larry W Robollo Home 1776 18th St San Francisco 1 CA 1 94107 22 07/01/2005   07/16/2007   1776 18th St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1776 18TH ST San Francisco, CA 94107 (37.762375, -122.400037)
9143 0048017-01-001 Sheedy Drayage Co Sheedy Drayage Co 1215 Michigan St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   Po Box 77004 San Francisco 1 94107 47 CA     0 0 D03 D19 D23 D39 Multiple 10 4 Potrero Hill 28   1215 MICHIGAN ST San Francisco, CA 94107 (37.753109, -122.385897)
9189 0048017-03-999 Sheedy Drayage Co Sheedy Hoist 12536 Clark St Santa+fe+springs 21 CA 1 90670 43 10/01/1968   01/01/2008   Po Box 77004 San Francisco 1 94107 47 CA     0 0           12536 CLARK ST SANTA FE SPRINGS, CA 90670 (33.938959, -118.064876)
9190 1081369-07-161 Lasdos Llc Lasdos 840 Wisconsin St San Francisco 1 CA 1 94107 22 06/20/2016   06/20/2016   840 Wisconsin St San Francisco 1 94107 47 CA     0 0            
9206 1082617-07-161 Vocate, Inc. Vocate 415 Jackson St Ste B San Francisco 1 CA 1 94111 35 01/01/2016   01/01/2016   655 4th St 1 Fl San Francisco 1 94107 47 CA     0 0     3 1 Chinatown 7    
9327 0048017-05-999 Sheedy Drayage Co Sheedy Dryage 515 Port Rd 21 Stockton 115 CA 1 95203 202 10/01/1968   01/01/2008   Po Box 77004 San Francisco 1 94107 47 CA     0 0           515 PORT RD STOCKTON, CA 95203 (37.941456, -121.320843)
9362 0151601-01-001 Garcia Douglas & Madeline Lun On Co 2565 3rd St 329 San Francisco 1 CA 1 94107 22 06/17/1985   06/17/1985   2565 3rd St #329 San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   2565 3RD ST San Francisco, CA 94107 (37.757073, -122.388101)
9491 0048017-06-999 Sheedy Drayage Co Sheedy Drayage Co 943 East Hedding San+jose 26 CA 1 95133 311 10/01/1968   09/01/2011   Po Box 77004 San Francisco 1 94107 47 CA     0 0           943 EAST HEDDING SAN JOSE, CA 95133
11123 0159398-01-001 Mathau Samuel N Mathau Roche Design Group 1790 Yosemite Ave 100 San Francisco 1 CA 1 94124 8 02/15/1995   03/02/2001   1278 Indiana St Unit 401 San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1790 YOSEMITE AVE San Francisco, CA 94124 (37.728722, -122.394974)
12246 0168509-01-001 Beals Terry Human Resources West Inc 1139 Rhode Island St San Francisco 1 CA 1 94107 22 12/01/1975   03/01/1999   1139 Rhode Island St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1139 RHODE ISLAND ST San Francisco, CA 94107 (37.755378, -122.401663)
12451 0170306-01-001 Worldwide Piano Industries Worldwide Piano Industries 760 Tennessee San+francisco 8 CA 1 94107 22 06/01/1985   01/01/2004   760 Tennessee St San Francisco 1 94107 47 CA     0 0           760 TENNESSEE San Francisco, CA 94107 (37.762175, -122.389647)
13078 0181506-01-001 Talmadge & Talmadge, Inc. World Gym Showplace Square 260 Deharo St San Francisco 1 CA 1 94103 25 12/31/2003   12/31/2003   1459 18th St 129 San Francisco 1 94107 47 CA     0 0 D04 H01 Multiple 10 4 Mission Bay 25   260 DEHARO ST San Francisco, CA 94103 (37.765914, -122.401701)
13161 0182209-02-001 Yuo Sang H U & I Auto Safety Center 758 Bryant St San Francisco 1 CA 1 94107 22 12/01/1988   11/01/2011   758 Bryant St San Francisco 1 94107 47 CA     0 0 D23 Vehicle Repair Garage - Major 6 3 South of Market 15   758 BRYANT ST San Francisco, CA 94107 (37.776642, -122.401768)
13270 0182843-01-001 Murphy Robert & Margaret Trs Murphy Robert & Margaret Trs 424 Bryant St San Francisco 1 CA 1 94107 22 01/01/1988   01/01/1988   424 Bryant St San Francsico 387 94107 47 CA     0 0     6 3 Financial District/South Beach 1   424 BRYANT ST San Francisco, CA 94107 (37.782509, -122.394309)
13335 0183200-01-001 Hacker Harvey J Harvey Hacker Architects 528 Bryant St San Francisco 1 CA 1 94107 22 01/01/1988   01/01/1988   528 Bryant St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   528 BRYANT ST San Francisco, CA 94107 (37.780716, -122.396588)
13459 0183971-01-001 Damato Anthony J Damato Construction 272 Clara St San Francisco 1 CA 1 94107 22 12/31/1994   12/31/1994 01/13/2009 1400 De Haro St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   272 CLARA ST San Francisco, CA 94107 (37.778193, -122.404006)
13553 0172366-01-001 Sbma Ltd South Beach Marina Apartments 2 Townsend St San Francisco 1 CA 1 94107 22 08/20/1988   08/20/1988   #2 Townsend St San Francisco 1 94107 47 CA     0 0 D03 D19 D26 Multiple 6 3 Financial District/South Beach 1   2 TOWNSEND ST San Francisco, CA 94107 (37.78163, -122.389225)
13584 0184660-02-001 Perry Shireen I Shireen Irvine Perry 1010 Tennessee St San Francisco 1 CA 1 94107 22 02/01/2013   02/01/2013   1010 Tennessee St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1010 TENNESSEE ST San Francisco, CA 94107 (37.759148, -122.389372)
13658 0185091-01-001 Watermark Press Ltd Watermark Graphics 950 Tennessee St San Francisco 1 CA 1 94107 22 02/20/1989   02/20/1989   950 Tennessee St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   950 TENNESSEE ST San Francisco, CA 94107 (37.759824, -122.38943)
13659 0185091-02-001 Watermark Press Ltd Watermark Press 950 Tennessee St San Francisco 1 CA 1 94107 22 02/20/1989   11/01/2002   950 Tennessee St San Francisco 1 94107 47 CA     0 0 D03 D19 Multiple 10 4 Potrero Hill 28   950 TENNESSEE ST San Francisco, CA 94107 (37.759824, -122.38943)
15545 0196449-01-001 Mandoli Marie Balloon Lady The 750 24th St San Francisco 1 CA 1 94107 22 01/01/1989   07/10/2001   750 24th St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   750 24TH ST San Francisco, CA 94107 (37.754145, -122.387475)
15719 0197684-01-001 Fried Helene M Helene Fried Associates 1233 De Haro St San Francisco 1 CA 1 94107 22 01/01/1990   04/03/2008   1233 De Haro St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1233 DE HARO ST San Francisco, CA 94107 (37.754214, -122.400609)
15817 0198516-01-001 General Crating Inc General Crating Inc 1031 25th St San Francisco 1 CA 1 94107 22 07/16/1990   07/16/1990   1031 25th St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   1031 25TH ST San Francisco, CA 94107 (37.752724, -122.38939)
15845 0198894-01-001 Sports Channel Pacific Asso. Sports Channel Pacific Asso. 901 Battery St San Francisco 1 CA 1 94111 35 05/31/2013   05/31/2013   360 3rd St Ste 200 San Francisco 1 94107 47 CA     0 0     3 1 Financial District/South Beach 1   901 BATTERY ST San Francisco, CA 94111 (37.799834, -122.401312)
15867 0199014-01-001 Wagner Bernie Promotions West 2002 3rd St 207 San Francisco 1 CA 1 94107 22 06/01/1990   05/01/2003   2002 3rd St #207 San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   2002 3RD ST San Francisco, CA 94107 (37.764018, -122.388926)
16439 0433256-05-001 Cirios Real Estate Inc Cirios Real Estate 1433 17th St San Francisco 1 CA 1 94107 22 10/15/2008 06/30/2016 01/01/2010 06/30/2016 1822 20th St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   1433 17TH ST San Francisco, CA 94107 (37.765106, -122.398057)
16589 0204478-01-001 Stensland Erik Bayside Security 329 Bryant St 213 San Francisco 1 CA 1 94107 22 04/13/1991   04/13/1991   329 Bryant St #2 B San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   329 BRYANT ST San Francisco, CA 94107 (37.78442, -122.39184)
17300 0209831-03-001 Ghassan G/ El Maalouf N The Gifted Basket 2200 Jerrold Ave G San Francisco 1 CA 1 94124 8 03/22/2006   03/10/2009   1201 Minnesota St San Francisco 1 94107 47 CA     0 0 H73 Deemed Approved Off-Sale Alcohol Use 10 4 Bayview Hunters Point 4   2200 JERROLD AVE G San Francisco, CA 94124 (37.744452, -122.399369)
17545 0205540-01-001 Watson Maria European Skin Care By Maria 166 Geary St 1505 San Francisco 1 CA 1 94108 9 06/18/1991   05/15/2006   239 Brannan St 14j Unit San Francisco 1 94107 47 CA     0 0     3 1 Financial District/South Beach 1   166 GEARY ST San Francisco, CA 94108 (37.787634, -122.406098)
17814 0302161-01-001 Clark Elaine A Voice One 665 3rd St 227 San Francisco 1 CA 1 94107 22 01/21/1997   01/01/2004   665 3rd St #227 San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   665 3RD ST San Francisco, CA 94107 (37.779256, -122.393278)
18096 0209831-04-001 Ghassan G/ El Maalouf N Baskettes 2200 Jerrold Ave G San Francisco 1 CA 1 94124 8 03/22/2006   03/10/2009   1201 Minnesota St San Francisco 1 94107 47 CA     0 0     10 4 Bayview Hunters Point 4   2200 JERROLD AVE G San Francisco, CA 94124 (37.744452, -122.399369)
18438 0304163-01-001 Greenworks, Inc Greenworks, Inc 690 Brannan St San Francisco 1 CA 1 94107 22 08/28/1987   09/01/2001   690 Brannan St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   690 BRANNAN ST San Francisco, CA 94107 (37.774848, -122.400949)
18439 0304163-02-001 Greenworks, Inc Tasaca Wholesale 690 Brannan St San Francisco 1 CA 1 94107 22 08/28/1987   09/01/2001   690 Brannan St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   690 BRANNAN ST San Francisco, CA 94107 (37.774848, -122.400949)
18440 0304163-03-001 Greenworks, Inc Toscana Gardens 652 Brannan St San Francisco 1 CA 1 94107 22 08/28/1987   01/01/2009   690 Brannan St San Francisco 1 94107 47 CA     0 0 H03 Retail Mkts W/o Prep (Under 5,001) 6 3 South of Market 15   652 BRANNAN ST San Francisco, CA 94107 (37.775514, -122.400104)
18515 0304504-01-001 Tobeler John T John Tobeler Design 589 Vermont St San Francisco 1 CA 1 94107 22 01/01/1996   09/01/2003   589 Vermont St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   589 VERMONT ST San Francisco, CA 94107 (37.762251, -122.404268)
18516 0304504-03-001 Tobeler John T Plum Antiquities & Decorat Art 589 Vermont St San Francisco 1 CA 1 94107 22 01/01/1996   01/02/2008   589 Vermont St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   589 VERMONT ST San Francisco, CA 94107 (37.762251, -122.404268)
18712 0305470-01-001 Golden State Auto Discount Golden State Auto Discount 645 Bryant St San Francisco 1 CA 1 94107 22 05/01/1997   05/01/1997   645 Bryant St San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   645 BRYANT ST San Francisco, CA 94107 (37.77869, -122.399176)
18873 0306133-02-001 Deliverex Acquisition Corp Sourcecorp Deliverex 950 23rd St San Francisco 1 CA 1 94107 22 02/01/1997   08/15/2004   950 23rd St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   950 23RD ST San Francisco, CA 94107 (37.75525, -122.390003)
18951 0306505-02-001 Vaughan & Company Inc Vaughan & Company Inc 681 Arkansas St San Francisco 1 CA 1 94107 22 01/01/1995   06/01/2001   681 Arkansas St San Francisco 1 94107 47 CA     0 1     10 4 Potrero Hill 28   681 ARKANSAS ST San Francisco, CA 94107 (37.757661, -122.398012)
19545 0309371-01-001 Studio Lab Llc Studio Lab 461 2nd St 231 San Francisco 1 CA 1 94107 22 09/01/1997   09/01/1997   461 2nd St #231 San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   461 2ND ST San Francisco, CA 94107 (37.783288, -122.393902)
19546 0309371-02-001 Studio Lab Llc Studio/lab 461 2nd St 231 San Francisco 1 CA 1 94107 22 09/01/1997   09/03/2002   461 2nd St #231 San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   461 2ND ST San Francisco, CA 94107 (37.783288, -122.393902)
19849 0310681-01-003 American Forklift Rentals American Forklift Rentals Inc 435 23rd St 2nd Fl San Francisco 1 CA 1 94107 22 10/27/1997   08/03/2011   435 23rd St 2nd Fl San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   435 23RD ST San Francisco, CA 94107 (37.75566, -122.38418)
20185 0312410-01-001 Schatten Deborah R Schatten Creative 500 Bryant St 105 San Francisco 1 CA 1 94107 22 01/01/1998   02/05/2004   500 Bryant St Ste 105 San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   500 BRYANT ST San Francisco, CA 94107 (37.781128, -122.39607)
20186 0312410-02-001 Schatten Deborah R Brandese 500 Bryant St #105 San+francisco 8 CA 1 94107 22 01/01/1998   09/28/2006   500 Bryant St Ste 105 San Francisco 1 94107 47 CA     0 0           500 BRYANT ST San Francisco, CA 94107 (37.781128, -122.39607)
20187 0312410-03-001 Schatten Deborah R The Year In Words 500 Bryant St 105 San Francisco 1 CA 1 94107 22 01/01/1998   04/19/2010   500 Bryant St Ste 105 San Francisco 1 94107 47 CA     0 0     6 3 South of Market 15   500 BRYANT ST San Francisco, CA 94107 (37.781128, -122.39607)
21353 0189235-03-001 Blum Cathryn M Catbird 928 Carolina St San Francisco 1 CA 1 94107 22 12/02/2003   12/02/2003   928 Carolina St San Francisco 1 94107 47 CA     0 0           928 CAROLINA ST San Francisco, CA 94107 (37.756767, -122.39995)
21685 0318872-04-001 Dos Santos David Manuel Potrero Hill Coin Laundry 1310 18th St San Francisco 1 CA 1 94107 22 12/03/2004   12/03/2004   1310 18th St San Francisco 1 94107 47 CA     0 0 H46 Auto Laundry Mech/pay-To-Operate Washing/dyeing 10 4 Potrero Hill 28   1310 18TH ST San Francisco, CA 94107 (37.762618, -122.395913)
21742 0319126-01-001 Young & Rubicam Inc Landor Associates 1001 Front St San Francisco 1 CA 1 94111 35 06/01/1998   12/31/2003   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0           1001 FRONT ST San Francisco, CA 94111 (37.800618, -122.400263)
21743 0319126-04-001 Young & Rubicam Inc Cohn & Wolfe 60 Green St San Francisco 1 CA 1 94111 35 06/01/1998   09/01/2003   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0     3 1 Financial District/South Beach 1   60 GREEN ST San Francisco, CA 94111 (37.80058, -122.400545)
21744 0319126-06-001 Young & Rubicam Inc Young & Rubicam Inc 303 2nd St South Tower 8th Fl San Francisco 1 CA 1 94107 22 06/01/1998   01/01/2005   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0           303 2ND ST SOUTH FL San Francisco, CA 94107 (37.784886, -122.395892)
21745 0319126-07-001 Young & Rubicam Inc Sudler & Hennessey 1001 Front St San Francisco 1 CA 1 94107 22 06/01/1998   01/01/2005   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0     3 1 Financial District/South Beach 1   1001 FRONT ST San Francisco, CA 94107 (37.800618, -122.400263)
21746 0319126-09-001 Young & Rubicam Inc Bravo Group The 303 2nd St 9th Fl San Francisco 1 CA 1 94107 22 06/01/1998   01/01/2007   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   303 2ND ST San Francisco, CA 94107 (37.784886, -122.395892)
21747 0319126-10-001 Young & Rubicam Inc Axicom 303 2rd St 9th Fl South Tower 9th San+francisco 8 CA 1 94107 22 06/01/1998   01/01/2010   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0           303 2RD ST San Francisco, CA 94107 (37.784886, -122.395892)
21748 0319126-11-001 Young & Rubicam Inc Young & Rubicam Group 303 2nd St 8 Fl San Francisco 1 CA 1 94107 22 06/01/1998   12/08/2011   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   303 2ND ST FL San Francisco, CA 94107 (37.784886, -122.395892)
21749 0319126-12-001 Young & Rubicam Inc Wpp Team Dell Pr 303 2nd St South Twr 8th Flr San Francisco 1 CA 1 94107 22 06/01/1998   03/13/2012   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0           303 2ND ST SOUTH FLR San Francisco, CA 94107 (37.784886, -122.395892)
21750 0319126-13-001 Young & Rubicam Inc North Of Nine Communications 303 2nd St South Twr 8th Flr San+francisco 8 CA 1 94107 22 06/01/1998   03/08/2012   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0           303 2ND ST SOUTH FLR San Francisco, CA 94107 (37.784886, -122.395892)
21752 0319126-14-001 Young & Rubicam Inc Y&r:california 303 2nd St 8th Fl San Francisco 1 CA 1 94107 22 06/01/1998   04/02/2012   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   303 2ND ST San Francisco, CA 94107 (37.784886, -122.395892)
21753 0319126-15-001 Young & Rubicam Inc Y & R Midwest 303 2nd St 8th Fl San Francisco 1 CA 1 94107 22 06/01/1998   04/11/2012   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   303 2ND ST San Francisco, CA 94107 (37.784886, -122.395892)
21754 0319126-16-001 Young & Rubicam Inc Y & R Chicago 303 2nd St 8th Fl San Francisco 1 CA 1 94107 22 06/01/1998   04/11/2012   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   303 2ND ST San Francisco, CA 94107 (37.784886, -122.395892)
21755 0319126-17-001 Young & Rubicam Inc Bav Consulting 303 2nd St South Tower 8th Fl San+francisco 8 CA 1 94107 22 06/01/1998   09/26/2012   303 2nd Street, S Tower, 8th F San Francisco 1 94107 47 CA     0 0           303 2ND ST SOUTH FL San Francisco, CA 94107 (37.784886, -122.395892)
21764 0319215-01-001 Makanna Philip & Jean Ghosts 665 Arkansas St San Francisco 1 CA 1 94107 22 01/01/1998   01/01/1998   665 Arkansas St San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   665 ARKANSAS ST San Francisco, CA 94107 (37.7578, -122.398025)
21788 0319312-01-001 Canyon Pacific Pro Mgnt Co Inc Canyon Pacific Management 665 3rd St 408 San Francisco 1 CA 1 94107 22 01/21/1998   05/15/2007   665 3rd St St 408 San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   665 3RD ST San Francisco, CA 94107 (37.779256, -122.393278)
21789 0319312-04-001 Canyon Pacific Pro Mgnt Co Inc 720 Haight St 720 Haight St San Francisco 1 CA 1 94117 33 01/21/1998   01/01/2007   665 3rd St St 408 San Francisco 1 94107 47 CA     1 0     5 7 Haight Ashbury 32   720 HAIGHT ST San Francisco, CA 94117 (37.771619, -122.434251)
23110 0324417-01-001 Mandalmed Incorporated Mandalmed Incorporated 665 3rd St 250 San Francisco 1 CA 1 94107 22 06/01/1998   03/22/2007   665 3rd St Ste 250 San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   665 3RD ST San Francisco, CA 94107 (37.779256, -122.393278)
23111 0324417-02-002 Mandalmed Incorporated Bioscience Laboratories 665 3rd St 250 San Francisco 1 CA 1 94107 22 06/01/1998   01/01/2009   665 3rd St Ste 250 San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   665 3RD ST San Francisco, CA 94107 (37.779256, -122.393278)
23112 0324417-02-003 Mandalmed Incorporated Bioscience Laboratories 665 3rd St 280 San Francisco 1 CA 1 94107 22 06/01/1998   01/01/2009   665 3rd St Ste 250 San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   665 3RD ST San Francisco, CA 94107 (37.779256, -122.393278)
23140 0324528-01-001 Barrango Gary J Park Presidio Marine 1300 25th St A San Francisco 1 CA 1 94107 22 01/01/1999   01/01/1999   1300 25th St, Ste A San Francisco 1 94107 47 CA     0 0 D19 D24 Multiple 10 4 Potrero Hill 28   1300 25TH ST A San Francisco, CA 94107 (37.75259, -122.391968)
23256 0324927-01-001 Prana Capital Llc Prana Capital Llc 665 3rd St 450 San Francisco 1 CA 1 94107 22 01/01/1997   01/01/1997   665 3rd St #450 San Francisco 1 94107 47 CA     0 0     6 3 Financial District/South Beach 1   665 3RD ST San Francisco, CA 94107 (37.779256, -122.393278)
23305 0325197-01-001 Jck Company Jck Company 2415 3rd St 269 San Francisco 1 CA 1 94107 22 03/30/1999   02/19/2002   2415 3rd St 269 San Francisco 1 94107 47 CA     0 0     10 4 Potrero Hill 28   2415 3RD ST San Francisco, CA 94107 (37.759449, -122.388365)

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