home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

5,790 rows where Mail Zipcode = 47

View and edit SQL

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
6972 1022449-03-151 Depict Inc Depict Inc 360 Ritch St 300 San Francisco 1 CA 1 94107 22 12/31/2013   06/01/2014   2019 19th St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0           360 RITCH ST SAN FRANCISCO, CA 94107 (37.778963, -122.393957)
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)
7299 0135637-01-001 Lyon Daniel James Plectric 1002 Pennsylvania Ave San Francisco 1 CA 1 94107 22 05/18/1982   05/18/1982   1002 Pennsylvania Av San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Potrero Hill 28   1002 PENNSYLVANIA AVE San Francisco, CA 94107 (37.753657, -122.392806)
7466 0136037-01-001 Cal Model & Design Group Inc Cal Model & Design Group Inc 1450 Mariposa St San Francisco 1 CA 1 94107 22 01/01/1982   01/01/1982   1450 Mariposa St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0 D03 D10 Multiple 10 4 Potrero Hill 28   1450 MARIPOSA ST San Francisco, CA 94107 (37.763779, -122.398084)
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)
7701 1010960-11-141 Fubarbell Diane Fu 2129 24th St San Francisco 1 CA 1 94107 22 07/01/2014   07/01/2014   2129 24th St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           2129 24TH ST SAN FRANCISCO, CA 94107 (37.753328, -122.401113)
7784 0057392-01-002 Hill & Knowlton Inc Hill & Knowlton Inc 60 Green St San Francisco 1 CA 1 94111 35 01/01/2010 11/06/2017 12/31/2010 11/06/2017   San Francisco 1 94107 47   5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   60 GREEN ST San Francisco, CA 94111 (37.80058, -122.400545)
7929 0137065-02-001 Arroyo Carlos M Carlos Arroyo & Sons 980 Folsom St San Francisco 1 CA 1 94107 22 01/01/1997   07/23/2001   980 Folsom St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 D10 D23 Multiple       980 FOLSOM ST San Francisco, CA 94107 (37.778831, -122.405216)
7955 0023483-02-001 Rapid Typographers Co Inc Rapid 836 Harrison St San Francisco 1 CA 1 94107 22 10/01/1968   05/01/2010   836 Harrison St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0           836 HARRISON ST San Francisco, CA 94107 (37.780029, -122.4006)
7956 0023483-03-001 Rapid Typographers Co Inc Rapid Lasergraphics 836 Harrison St San Francisco 1 CA 1 94107 22 10/01/1968   05/01/2010   836 Harrison St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     6 3 South of Market 15   836 HARRISON ST SAN FRANCISCO, CA 94107 (37.780029, -122.4006)
7964 0149883-01-001 Dppm Inc Zephyr Real Estate 4200 17th St San Francisco 1 CA 1 94114 34 01/23/1979   01/23/1979 01/01/2015 850 7th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Castro/Upper Market 30   4200 17TH ST San Francisco, CA 94114 (37.762217, -122.439665)
7970 0023483-04-001 Rapid Typographers Co Inc Rapid Giclee 505 Beach St San Francisco 1 CA 1 94133 11 10/01/1968   07/01/2008   836 Harrison St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     3 1 North Beach 6   505 BEACH ST San Francisco, CA 94133 (37.807034, -122.417619)
7971 0149883-01-004 Dppm Inc Zephyr Real Estate 215 West Portal Ave San Francisco 1 CA 1 94127 31 01/23/1979   03/01/2003   850 7th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   215 WEST PORTAL AVE San Francisco, CA 94127 (37.738969, -122.467822)
7978 0149883-01-005 Dppm Inc Zephyr Real Estate 2523 California St San Francisco 1 CA 1 94115 4 01/23/1979   03/01/2007   850 7th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Pacific Heights 16   2523 CALIFORNIA ST San Francisco, CA 94115 (37.788649, -122.435857)
8009 0057823-01-001 Peterson Robert L Chase Auto Service 911 Harrison St San Francisco 1 CA 1 94107 22 07/01/1969   02/21/1999   911 Harrison St San Francisco 1 94107 47 CA 8100-8139 5 Certain Services 5 0 0 D23 Vehicle Repair Garage - Major 6 3 South of Market 15   911 HARRISON ST San Francisco, CA 94107 (37.778757, -122.402205)
8021 0149883-04-001 Dppm Inc Ford Real Estate 1542 20th St San Francisco 1 CA 1 94107 22 01/23/1979   09/01/2004   850 7th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   1542 20TH ST San Francisco, CA 94107 (37.760006, -122.396694)
8026 0149883-08-001 Dppm Inc Zephyr Commercial 209 West Portal Ave San Francisco 1 CA 1 94127 31 01/23/1979   03/01/2012   850 7th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 West of Twin Peaks 26   209 WEST PORTAL AVE San Francisco, CA 94127 (37.738915, -122.467885)
8051 0362056-04-001 Nerve Net Inc Rome101 200 Brannan St 503 San Francisco 1 CA 1 94107 22 01/01/2003   08/15/2013   200 Brannan St Apt 503 San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   200 BRANNAN ST San Francisco, CA 94107 (37.783191, -122.390388)
8063 0149883-09-001 Dppm Inc Zephyr Real Estate 850 7th St San Francisco 1 CA 1 94107 22 01/23/1979   12/03/2012   850 7th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           850 7TH ST San Francisco, CA 94107 (37.770652, -122.400225)
8070 0149883-10-001 Dppm Inc Zephyr Commercial 850 7th St San Francisco 1 CA 1 94107 22 01/23/1979   12/03/2012   850 7th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           850 7TH ST San Francisco, CA 94107 (37.770652, -122.400225)
8079 0149883-11-001 Dppm Inc Westwind Referral Network 850 7th St San Francisco 1 CA 1 94107 22 01/23/1979   08/23/2013   850 7th St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           850 7TH ST San Francisco, CA 94107 (37.770652, -122.400225)
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)
8158 0095807-01-001 Golden Gate Equipment Co Golden Gate Equipment Co 51 Federal St 202 San Francisco 1 CA 1 94107 22 08/01/1975   06/01/2005   51 Federal St #202 San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   51 FEDERAL ST San Francisco, CA 94107 (37.783654, -122.391823)
8180 0067808-01-001 Grenier Wholesale Liquors Inc Grenier Wholesale Liquors Inc 1500 Tennessee St San Francisco 1 CA 1 94107 22 10/01/1971   10/01/1971   1500 Tennessee St San Francisco 1 94107 47 CA 4200-4299 7 Wholesale Trade 7 0 0 D19 H21 H73 Multiple 10 4 Bayview Hunters Point 4   1500 TENNESSEE ST San Francisco, CA 94107 (37.75229, -122.388725)
8228 0081405-01-001 Baker Frederic Law Corp Baker Frederic Law Corp 2 Henry Adams St M-71 San Francisco 1 CA 1 94103 25 01/01/1972   01/01/1972 10/01/2015 1459 18th St #339 San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Mission Bay 25   2 HENRY ADAMS ST San Francisco, CA 94103 (37.769163, -122.403954)
8236 0009552-01-001 Fiore Richard A Fiore & Co 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   12/30/1990   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8240 0009552-03-001 Fiore Richard A 987 Rhode Island Apts 987 Rhode Island St San Francisco 1 CA 1 94107 22 10/01/1968   02/18/1972   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   987 RHODE ISLAND ST San Francisco, CA 94107 (37.757346, -122.40187)
8252 0009552-04-001 Fiore Richard A 272-276 Connecticut Apts 272 Connecticut St San Francisco 1 CA 1 94107 22 10/01/1968   06/02/1975   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Potrero Hill 28   272 CONNECTICUT ST San Francisco, CA 94107 (37.762845, -122.397524)
8255 0009552-13-001 Fiore Richard A 89-91 Stillman St Building 89 Stillman St San Francisco 1 CA 1 94107 22 10/01/1968   05/07/1973   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   89 STILLMAN ST San Francisco, CA 94107 (37.78206, -122.396005)
8277 0009552-14-001 Fiore Richard A 228-242 Townsend St Building 228 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   06/22/1984   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   228 TOWNSEND ST San Francisco, CA 94107 (37.778094, -122.393738)
8285 0009552-15-001 Fiore Richard A First California Loans 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   10/02/1968   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8300 0009552-16-001 Fiore Richard A First California Loan Co 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   04/04/1998   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8355 0009552-19-001 Fiore Richard A Townsend Place 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   04/03/1998   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8394 0009552-20-001 Fiore Richard A Townsend Square 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   04/03/1998   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8411 0009552-21-001 Fiore Richard A Fiore And Company 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   10/01/1968   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8452 0103718-01-001 Frankel Thomas Samson John Monterey Arms Apartments 2200 Francisco St San Francisco 1 CA 1 94123 3 04/23/1976   04/23/1976   695 Fifth St #13 San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   2200 FRANCISCO ST San Francisco, CA 94123 (37.801088, -122.441637)
8463 0009552-23-001 Fiore Richard A R.a.f. Development Company 510 Mission St San Francisco 1 CA 1 94105 7 10/01/1968   10/01/1968   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Financial District/South Beach 1   510 MISSION ST San Francisco, CA 94105 (37.790207, -122.397011)
8472 0009552-24-001 Fiore Richard A 987 Rhode Island Apts 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
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)
8482 0009552-25-001 Fiore Richard A First California Loan Co 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8488 0103718-02-001 Frankel Thomas Samson John Monterey Arms 2200 Francisco St San Francisco 1 CA 1 94123 3 04/23/1976   04/23/1976   695 Fifth St #13 San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 1 0     2 Marina 2   2200 FRANCISCO ST San Francisco, CA 94123 (37.801088, -122.441637)
8491 0009552-26-001 Fiore Richard A First California Loans 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8496 0009552-27-001 Fiore Richard A Fiore & Co 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8508 0009552-30-001 Fiore Richard A Raf Properties 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8518 0009552-31-001 Fiore Richard A Townsend Place 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8543 0009552-32-001 Fiore Richard A 228-242 Townsend St Building 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8551 0009552-33-001 Fiore Richard A 272-276 Connecticut Apts 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8583 0009552-34-001 Fiore Richard A 1301-1307 Hampshire Apts 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8605 0009552-35-001 Fiore Richard A 586 6th St Rentals 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8620 0009552-36-001 Fiore Richard A R.a.f. Development Company 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8631 0009552-37-001 Fiore Richard A Townsend Square 238 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   03/01/2014   238 Townsend St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   238 TOWNSEND ST San Francisco, CA 94107 (37.778092, -122.393741)
8658 1031415-06-151 Alan Roger A Motion Studio 440 Brannan St San Francisco 1 CA 1 94107 22 06/23/2015   06/23/2015   440 Brannan St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0           440 BRANNAN ST SAN FRANCISCO, CA 94107 (37.779179, -122.395457)
8714 1032546-07-151 Metabase Inc Metabase Inc 555 Mission St #2700 San Francisco 1 CA 1 94105 7 10/10/2014   10/10/2014 08/28/2017 660 4th Street Unit 193 San Francisco 1 94107 47 CA 5100-5199 15 Information 15 0 0           555 MISSION ST SAN FRANCISCO, CA 94105 (37.788692, -122.398938)
8798 0033855-01-001 Gee Edward & Louie & Amy L 1435 Pacific Apts 1435 Pacific Ave San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   165 Texas St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1435 PACIFIC AVE San Francisco, CA 94109 (37.795393, -122.418912)
8808 0104709-01-001 Goat Hill Inc Goat Hill 300 Connecticut St San Francisco 1 CA 1 94107 22 11/14/1975   11/14/1975   300 Connecticut St San Francisco 1 94107 47 CA 7220-7229 8 Food Services 8 0 0 H25 Restaurant 1,000 - 2,000 Sqft 10 4 Potrero Hill 28   300 CONNECTICUT ST San Francisco, CA 94107 (37.762371, -122.397486)
8816 0104709-05-001 Goat Hill Inc Goat Hill Pizza 170 West Portal Ave San Francisco 1 CA 1 94127 31 11/14/1975   08/01/2012   300 Connecticut St San Francisco 1 94107 47 CA 7220-7229 8 Food Services 8 0 0 H25 Restaurant 1,000 - 2,000 Sqft 7 9 West of Twin Peaks 26   170 WEST PORTAL AVE San Francisco, CA 94127 (37.7391, -122.467804)
8831 0150792-01-001 Grossman John Grossman Design Group 326 Ritch St San Francisco 1 CA 1 94107 22 03/15/1985   05/21/1999   77 Falmouth St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 South of Market 15   326 RITCH ST San Francisco, CA 94107 (37.779223, -122.394274)
8847 0150883-01-001 Cal Sterling Properties Inc Golden West Construction Co 1089 Tennessee St San Francisco 1 CA 1 94107 22 04/30/1982   04/30/1982   1089 Tennessee St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Potrero Hill 28   1089 TENNESSEE ST San Francisco, CA 94107 (37.758086, -122.389272)
8879 1035031-07-151 Datafox Intelligence Inc Datafox Intelligence Inc 324 5th St San Francisco 1 CA 1 94107 22 10/01/2014   06/29/2015 06/29/2015 324 5th St San Francisco 1 94107 47 CA 5100-5199 15 Information 15 0 0           324 5TH ST SAN FRANCISCO, CA 94107 (37.779962, -122.403019)
8887 0009586-01-001 First Spice Mixing Co Inc First Spice Mixing & Mfg Co 195 Arkansas St San Francisco 1 CA 1 94107 22 10/01/1968   10/01/1968   195 Arkansas St San Francisco 1 94107 47 CA 3100-3399 10 Manufacturing 10 0 0     10 4 Potrero Hill 28   195 ARKANSAS ST San Francisco, CA 94107 (37.763797, -122.398561)
8900 0371531-05-001 Conolly Morgan A Morgan Conolly Architect 524 Second St San Francisco 1 CA 1 94107 22 07/14/2003   07/16/2013   524 Second St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   524 SECOND ST San Francisco, CA 94107 (37.782723, -122.393191)
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)
8970 0024944-01-001 Santa Rosa Wholesale Flrst Inc Santa Rosa Wholesale Flrst Inc 674 Brannan St San Francisco 1 CA 1 94107 22 10/01/1968   08/29/1998   674 Brannan St San Francisco 1 94107 47 CA 4200-4299 4400-4599 13 Multiple 13 0 0     6 3 South of Market 15   674 BRANNAN ST San Francisco, CA 94107 (37.775282, -122.400398)
9007 0010041-01-001 Frankel Thomas L Frankel Thomas L 695 5th St 13 San Francisco 1 CA 1 94107 22 10/01/1968   08/02/1999   695 5th St #13 San Francisco 1 94107 47 CA 5600-5699 16 Administrative and Support Services 16 0 0     6 3 South of Market 15   695 5TH ST San Francisco, CA 94107 (37.775481, -122.397403)
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            
9201 1084753-07-161 Keith Bodziak Keith Bodziak Photography 50 Capra Way Apt 10 San Francisco 1 CA 1 94123 3 01/01/2016   01/01/2016   548 Brannan St 309 Apt San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     2 Marina 2    
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    
9227 0151043-01-001 Angotti & Reilly Inc Angotti & Reilly Inc 1000 Mariposa St San Francisco 1 CA 1 94107 22 05/01/1985   10/20/2001   1000 Mariposa St San Francisco 1 94107 47 CA 2300-2399 6 Construction 6 0 0     10 4 Potrero Hill 28   1000 MARIPOSA ST San Francisco, CA 94107 (37.764017, -122.394039)
9284 0138801-01-001 T Heffernan/light Language Inc Heffernan Films 991 Tennessee St San Francisco 1 CA 1 94107 22 12/03/2003   12/03/2003   991 Tennessee St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Potrero Hill 28   991 TENNESSEE ST San Francisco, CA 94107 (37.759826, -122.38943)
9296 0138801-02-001 T Heffernan/light Language Inc Dogpatchstudios 991 Tennessee St San Francisco 1 CA 1 94107 22 12/03/2003   06/05/2007   991 Tennessee St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Potrero Hill 28   991 TENNESSEE ST San Francisco, CA 94107 (37.759826, -122.38943)
9322 0096659-01-001 Yee Robert W Etal 670-672 Broadway Bldg 670 Broadway St San+francisco 8 CA 1 94133 11 08/01/1975   08/01/1975   Po Box 77263 San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           670 BROADWAY ST San Francisco, CA 94133 (37.79769, -122.408093)
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
9645 0125803-01-001 Bernstein Douglas M 518 Brannan Bldg 518 Brannan St San Francisco 1 CA 1 94107 22 01/01/1980   01/01/1980   123 Freelon St San Francisco 1 94107 47 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 South of Market 15   518 BRANNAN ST San Francisco, CA 94107 (37.777873, -122.397105)
9732 0152269-01-001 Anding Keith & Nancy Ska Architecture & Design 818 Brannan St 203 San Francisco 1 CA 1 94103 25 08/08/1985   08/08/1985   168 Missouri St San Francisco 1 94107 47 CA 6100-6299 4 Private Education and Health Services 4 0 0     6 3 South of Market 15   818 BRANNAN ST San Francisco, CA 94103 (37.772613, -122.403773)
9771 0152269-02-001 Anding Keith & Nancy 77-83 Colton St Apts 77 Colton St San Francisco 1 CA 1 94103 25 08/08/1985   02/19/1988   168 Missouri St San Francisco 1 94107 47 CA 6100-6299 4 Private Education and Health Services 4 0 0     6 3 Mission 12   77 COLTON ST San Francisco, CA 94103 (37.773072, -122.420184)
9776 0152269-03-001 Anding Keith & Nancy Civic South International 168 Missouri St San Francisco 1 CA 1 94107 22 08/08/1985   01/01/1989   168 Missouri St San Francisco 1 94107 47 CA 6100-6299 4 Private Education and Health Services 4 0 0     10 4 Potrero Hill 28   168 MISSOURI ST San Francisco, CA 94107 (37.764211, -122.396684)
9956 0139599-01-001 Mclean John B Mclean John Architect 24 Scott Aly San Francisco 1 CA 1 94107 22 01/01/1983   08/03/2010   24 Scott Aly San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 South of Market 15   24 SCOTT ALY San Francisco, CA 94107 (37.779969, -122.40201)
10160 1133666-01-171 Palmore Hoyt Dba Palmore Hoyt 1409 20th St San Francisco 1 CA 1 94107 22 01/22/2017   01/22/2017   1409 20th St San Francisco 1 94107 47 CA 7210-7219 9 Accommodations 9 0 1     10 4 Potrero Hill 28    
10999 0157989-01-001 Shuirman Susan T Shuirman Susan Tilya Cpa 789 Wisconsin St San Francisco 1 CA 1 94107 22 01/01/1986   01/01/1986   789 Wisconsin St San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     10 4 Potrero Hill 28   789 WISCONSIN ST San Francisco, CA 94107 (37.757492, -122.39894)
11020 0158321-02-001 Vos Barbara E Barbara Vos 228 Prague St San Francisco 1 CA 1 94112 28 07/06/2005   07/06/2005   Noonan Pier 70 San Francisco 1 94107 47 CA 6100-6299 4 Private Education and Health Services 4 0 0     11 Excelsior 23   228 PRAGUE ST San Francisco, CA 94112 (37.71839, -122.427645)
11090 0159028-01-001 Bava Toni J Bava Antonia Landscape Archit 490 2nd St #104 San+francisco 8 CA 1 94107 22 01/01/1986   05/07/2005   480 2nd St #200 San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           490 2ND ST San Francisco, CA 94107 (37.783277, -122.393887)
11092 0159028-02-001 Bava Toni J Antonia Bava Landscape Archite 480 2nd St 200 San Francisco 1 CA 1 94107 22 01/01/1986   01/01/2013   480 2nd St #200 San Francisco 1 94107 47 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     6 3 Financial District/South Beach 1   480 2ND ST San Francisco, CA 94107 (37.783424, -122.394075)
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)
11313 0161185-01-001 The Good Life Grocery Good Life Grocery The 1524 20th St San Francisco 1 CA 1 94107 22 01/01/1987   01/01/1987   1524 20th St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 H07 Retail Food Market W/food Prep. Lt 5001 Sqft 10 4 Potrero Hill 28   1524 20TH ST San Francisco, CA 94107 (37.76, -122.39682)
11314 0161185-01-002 The Good Life Grocery Good Life Grocery The 448 Cortland Ave San Francisco 1 CA 1 94110 18 01/01/1987   01/01/1991   1524 20th St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0 H28 H73 Multiple 9 8 Bernal Heights 19   448 CORTLAND AVE San Francisco, CA 94110 (37.73909, -122.416702)
11339 0151178-01-001 Akinai Moshi Moshi 2092 3rd St San Francisco 1 CA 1 94107 22 06/01/1985   06/01/1985 12/31/2013 2092 3rd St San Francisco 1 94107 47 CA 7220-7229 8 Food Services 8 0 0     10 4 Potrero Hill 28   2092 3RD ST SAN FRANCISCO, CA 94107 (37.76322, -122.388835)
11370 0161433-01-001 Okls Inc Okells Fireplace 1300 17th St San Francisco 1 CA 1 94107 22 01/01/1987   10/23/1996   1300 17th St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0     10 4 Mission Bay 25   1300 17TH ST San Francisco, CA 94107 (37.765186, -122.396773)
11371 0161433-02-999 Okls Inc Aba Hearth & Home 1494 Laurel St San+carlos 34 CA 1 94070 60 01/01/1987   12/18/2012   1300 17th St San Francisco 1 94107 47 CA 4400-4599 3 Retail Trade 3 0 0           1494 LAUREL ST SAN CARLOS, CA 94070 (37.496118, -122.248654)
11519 0162644-01-001 Berry Timothy F Teaberry Press 2325 3rd St 321 San Francisco 1 CA 1 94107 22 09/01/1984   09/01/1995   2325 3rd St #321 San Francisco 1 94107 47 CA 7100-7199 14 Arts, Entertainment, and Recreation 14 0 0     10 4 Potrero Hill 28   2325 3RD ST San Francisco, CA 94107 (37.760245, -122.38843)

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