home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Mail City

View and edit SQL

Suggested facets: NAICS Code Description, Supervisor District

Business Corridor

Link rowid Location Id Ownership Name DBA Name Street Address City State Source Zipcode Business Start Date Business End Date Location Start Date Location End Date Mail Address Mail City ▼ Mail Zipcode Mail State NAICS Code NAICS Code Description Parking Tax Transient Occupancy Tax LIC Code LIC Code Description Supervisor District Neighborhoods - Analysis Boundaries Business Corridor Business Location
2 0012758-02-999 Hexol Inc Hexol Inc 19217 Willow Lane Sonoma 2 CA 1 95476 2 10/01/1968 11/30/2014 01/01/2006 11/30/2014             0 0           19217 WILLOW LANE SONOMA, CA 95476 (38.291744, -122.500337)
3 0028304-01-001 Thele William R Jr Thele William Jr 2265 Union St San Francisco 1 CA 1 94123 3 10/01/1968 06/30/2011 10/01/1968 06/30/2011             0 0     2 Marina 2   2265 UNION ST San Francisco, CA 94123 (37.79695, -122.436551)
15 0051691-01-999 Levin Jos Realty Corp Of Sf Levin Jos Realty Corp Of Sf 170 Alpine Way San+bruno 6 CA 1 94066 13 10/01/1968 06/07/2016 01/01/2005 06/07/2016             0 0           170 ALPINE WAY SAN BRUNO, CA 94066 (37.618514, -122.438594)
16 0140239-01-001 Campbell Melvin C & M Roofing 10 Hiliritas Ave San Francisco 1 CA 1 94131 14 04/06/1983 08/11/2015 04/06/1983 08/11/2015             0 0     8 5 Glen Park 8   10 HILIRITAS AVE San Francisco, CA 94131 (37.737848, -122.437263)
18 0043291-04-001 Law William T Law William T 780 19th Ave San Francisco 1 CA 1 94121 15 10/01/1968 12/31/2013 10/01/1968 12/31/2013             0 0     1 6 Outer Richmond 9   780 19TH AVE San Francisco, CA 94121 (37.773191, -122.477811)
24 0089968-02-001 Saito Yuko Lyon Street Salon 2900 Lyon St San Francisco 1 CA 1 94123 3 11/20/2013 11/21/2013 11/20/2013 11/21/2013             0 0     2 Marina 2   2900 LYON ST San Francisco, CA 94123 (37.797529, -122.447175)
25 0043960-01-002 Ampco System Parking 4415-4287 Ampco Pkg-Lot 4287 220 Bush St San Francisco 1 CA 1 94104 1 01/01/1995 12/31/2013 11/01/1988 12/31/2013             0 0           220 BUSH ST San Francisco, CA 94104 (37.791124, -122.401272)
26 0103059-01-001 Woo Jung & Pyong Soon Sim Samys Liquor 2847 24th St San Francisco 1 CA 1 94110 18 12/01/1976 05/15/2012 12/01/1976 05/15/2012             0 0     9 8 Mission 12   2847 24TH ST San Francisco, CA 94110 (37.752805, -122.40909)
33 0019494-02-001 Tuccori Alma Almas Alterations 444 Union St San Francisco 1 CA 1 94133 11 05/01/2009 01/30/2014 05/07/2009 01/30/2014             0 0     3 1 North Beach 6   444 UNION ST San Francisco, CA 94133 (37.800732, -122.406904)
37 0021420-01-999 Marchetti Construction Inc Marchetti Construction Inc 184 Harbor Way S+san+fran 9 CA 1 94080 17 10/01/1968 12/31/2014 10/01/1968 12/31/2014             0 0           184 HARBOR WAY S SAN FRAN, CA 94080 (37.651916, -122.400113)
43 0067460-01-001 William Johnston Assoc Inc Johnston Group 923 Harrison St San Francisco 1 CA 1 94107 22 07/01/1971 12/31/2014 11/29/2006 12/31/2014             0 0     6 3 South of Market 15   923 HARRISON ST San Francisco, CA 94107 (37.778609, -122.402393)
44 0038509-02-001 Vennemeyer Henry 3039 Anza Apts 3039 Anza St San Francisco 1 CA 1 94121 15 10/01/1968 11/05/2014 10/01/1968 11/05/2014             0 0     1 6 Outer Richmond 9   3039 ANZA ST San Francisco, CA 94121 (37.778341, -122.481006)
47 0145742-01-001 Kin F Yee Dds Kin F Yee Dds 760 Market St 722 San Francisco 1 CA 1 94102 16 04/01/1984 07/31/2013 04/01/1984 07/31/2013             0 0     3 1 Financial District/South Beach 1   760 MARKET ST San Francisco, CA 94102 (37.786173, -122.40532)
48 0033262-21-001 Woo Family Trust 1700 Broadway Parking 1700 Broadway San Francisco 1 CA 1 94109 24 10/01/1968 01/01/2015 06/26/2011 01/01/2015             0 0     2 Pacific Heights 16   1700 BROADWAY San Francisco, CA 94109 (37.795504, -122.425314)
54 0057473-02-001 Louie Sinclair & May C 616 Grant Bldg 616 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968 06/02/2014 10/01/1968 06/02/2014             0 0     3 1 Chinatown 7   616 GRANT AVE San Francisco, CA 94108 (37.793055, -122.406061)
55 0031770-03-001 Caristi Helen 1012 Guerrero Apts 1012 Guerrero St San Francisco 1 CA 1 94110 18 10/01/1968 12/05/2012 10/01/1968 12/05/2012             0 0     8 5 Mission 12   1012 GUERRERO ST San Francisco, CA 94110 (37.754888, -122.423199)
60 0031770-04-001 Caristi Helen 1148-1152 Guerrero Apartments 1148 Guerrero St San Francisco 1 CA 1 94110 18 10/01/1968 12/05/2012 07/09/1980 12/05/2012             0 0     8 5 Mission 12   1148 GUERRERO ST San Francisco, CA 94110 (37.752691, -122.422988)
61 0040053-01-001 Scatena Gino,jr. 4042/4048 Fulton Apts 4042 Fulton St San Francisco 1 CA 1 94118 6 10/01/1968 03/29/2017 10/01/1968 03/29/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   4042 FULTON ST San Francisco, CA 94118 (37.772952, -122.475376)
62 0097229-02-001 Concon Hale T & Nancy Acacia Home Caregivers 677 19th Ave San Francisco 1 CA 1 94121 15 01/01/1976 01/20/2010 08/20/2008 01/20/2010             0 0     1 6 Outer Richmond 9   677 19TH AVE San Francisco, CA 94121 (37.775132, -122.47794)
64 0025733-01-092 San Francisco Parking Inc City Park 1600 Egbert Ave San+francisco 8 CA 1 94124 8 10/01/1968 12/31/2015 08/12/2011 08/31/2014         8100-8139 5 Certain Services 5 0 0           1600 EGBERT AVE San Francisco, CA 94124
65 0031770-05-001 Caristi Helen 1181-1185 Guerrero Apartments 1181 Guerrero St San Francisco 1 CA 1 94110 18 10/01/1968 12/05/2012 07/09/1980 12/05/2012             0 0     8 5 Mission 12   1181 GUERRERO ST San Francisco, CA 94110 (37.752241, -122.422852)
66 0040056-02-001 Sweet Antonia & Adrienne 405 Union Rentals Etal 405 Union St San Francisco 1 CA 1 94133 11 10/01/1968 09/30/2014 10/01/1968 09/30/2014             0 0     3 1 North Beach 6   405 UNION ST San Francisco, CA 94133 (37.800812, -122.406252)
71 0050608-06-001 Sharp Kenneth J & Wendy Bmw Auto Repair 280 14th St San Francisco 1 CA 1 94103 25 10/01/1968 04/24/2015 01/31/2007 04/24/2015             0 0     9 8 Mission 12   280 14TH ST San Francisco, CA 94103 (37.76832, -122.419475)
73 0060940-01-001 Zachariah Family Trust 980-984 Capp Apts 980 Capp St San Francisco 1 CA 1 94110 18 10/01/1968 01/17/2017 10/01/1968 01/17/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   980 CAPP ST San Francisco, CA 94110 (37.751069, -122.417234)
75 0031770-06-001 Caristi Helen 487-489 Fair Oaks Apartments 487 Fair Oaks St San Francisco 1 CA 1 94110 18 10/01/1968 12/05/2012 09/30/1986 12/05/2012             0 0     8 5 Mission 12   487 FAIR OAKS ST San Francisco, CA 94110 (37.748956, -122.42371)
77 0040056-03-001 Sweet Antonia & Adrienne 472 Union Rental 472 Union St San Francisco 1 CA 1 94133 11 10/01/1968 09/30/2014 10/01/1968 09/30/2014             0 0     3 1 North Beach 6   472 UNION ST San Francisco, CA 94133 (37.800694, -122.407239)
81 0031770-07-001 Caristi Helen 177 Fair Oaks St Apts 260 Fair Oaks St San Francisco 1 CA 1 94110 18 10/01/1968 12/05/2012 01/01/1986 12/05/2012             0 0     8 5 Mission 12   260 FAIR OAKS ST San Francisco, CA 94110 (37.75252, -122.424043)
84 0040056-04-001 Sweet Antonia & Adrienne 480 Union St Apt 480 Union St San Francisco 1 CA 1 94133 11 10/01/1968 09/30/2014 03/20/1992 09/30/2014             0 0     3 1 North Beach 6   480 UNION ST San Francisco, CA 94133 (37.800682, -122.407336)
91 0060940-03-001 Zachariah Family Trust 2749-2751 Mission St Bldg 2749 Mission St San Francisco 1 CA 1 94110 18 10/01/1968 01/17/2017 02/28/1969 05/03/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Mission 12   2749 MISSION ST San Francisco, CA 94110 (37.753018, -122.418514)
97 0025733-74-001 San Francisco Parking Inc City Park Cnet 235 Second St San Francisco 1 CA 1 94107 22 10/01/1968 12/31/2015 01/01/2009 12/31/2015         8100-8139 5 Certain Services 5 0 0     6 3 Financial District/South Beach 1   235 SECOND ST San Francisco, CA 94107 (37.786079, -122.39736)
103 0034361-01-001 Owyang Sherwin & Jennette 1540 Hyde Apts 1540 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968 03/14/2014 10/01/1968 03/14/2014             0 0     3 1 Russian Hill 5   1540 HYDE ST San Francisco, CA 94109 (37.795043, -122.41822)
104 0034381-01-001 Micheli Julie & Mcginty A 1545 Filbert Apts 1545 Filbert St San Francisco 1 CA 1 94123 3 10/01/1968 01/01/2011 10/01/1968 01/01/2011             0 0     2 Marina 2   1545 FILBERT ST San Francisco, CA 94123 (37.799376, -122.425049)
105 0140473-01-001 Keung Walter L Dragon Seed Advertising 228 Chicago Way San Francisco 1 CA 1 94112 28 03/30/1983 06/30/2015 03/30/1983 06/30/2015             0 0     11 Excelsior 23   228 CHICAGO WAY San Francisco, CA 94112 (37.710235, -122.431824)
122 0025753-01-001 Chait Robert R Etal Sf Provident Loan Assn 932 Mission St San Francisco 1 CA 1 94103 25 10/01/1968 06/30/2013 10/01/1968 06/30/2013             0 0     6 3 South of Market 15   932 MISSION ST SAN FRANCISCO, CA 94103 (37.782021, -122.407389)
123 0060940-04-001 Zachariah Family Trust 1444 Market St Building 1444 Market St San Francisco 1 CA 1 94102 16 10/01/1968 01/17/2017 03/04/1987 05/03/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Tenderloin 11   1444 MARKET ST San Francisco, CA 94102 (37.775967, -122.418233)
124 0140498-02-001 Kang Yung Dae Etal Printing Usa Co 3421 Geary Blvd San Francisco 1 CA 1 94118 6 05/30/1990 12/31/2014 04/01/1983 12/31/2014             0 0     1 6 Lone Mountain/USF 24   3421 GEARY BLVD San Francisco, CA 94118 (37.781358, -122.455651)
126 0034389-01-001 Kirkham Associates 1530 5th Av Apts 1530 5th Ave San Francisco 1 CA 1 94122 19 10/01/1968 04/08/2014 10/01/1968 04/08/2014             0 0     7 9 Inner Sunset 13   1530 5TH AVE San Francisco, CA 94122 (37.759806, -122.46143)
130 0112490-01-001 Gigler Richard A Giglers Body Shop 3252 19th St San Francisco 1 CA 1 94110 18 06/16/1976 11/15/2013 06/16/1976 11/15/2013             0 0     9 8 Mission 12   3252 19TH ST San Francisco, CA 94110 (37.760426, -122.416086)
159 0083808-01-001 Crisera Robert A Crisera Robert A Phd-Cnslt Mgt 155 Yerba Buena Ave San Francisco 1 CA 1 94127 31 02/01/1974 01/01/2015 02/11/2010 01/01/2015             0 0     7 9 West of Twin Peaks 26   155 YERBA BUENA AVE San Francisco, CA 94127 (37.736207, -122.461848)
161 0158585-02-001 Chu Chin Jung & Kuo Fong San Tung Restaurant #2 1031 Irving St San Francisco 1 CA 1 94122 19 09/01/1986 07/01/2011 10/02/1996 07/01/2011             0 0     5 7 Inner Sunset 13   1031 IRVING ST San Francisco, CA 94122 (37.763931, -122.468904)
180 0099698-01-001 Dinelli Robert R Dinelli Robert Studio 2546 Bryant St San Francisco 1 CA 1 94110 18 09/01/1975 09/11/2013 09/01/1975 09/11/2013             0 0     9 8 Mission 12   2546 BRYANT ST San Francisco, CA 94110 (37.75363, -122.409186)
193 0099749-04-001 Robertson Wm D & B A Etal 50-54 Webster St Apts 50 Webster St San Francisco 1 CA 1 94117 33 10/01/1976 12/15/2014 10/01/1976 12/15/2014             0 0     5 7 Hayes Valley 10   50 WEBSTER ST San Francisco, CA 94117 (37.770577, -122.428456)
194 0112736-01-002 Doyle Richard Jr Dds Inc Doyle Richard Jr-Dds 1 Daniel Burnham Ct Lobby Level 120c San Francisco 1 CA 1 94109 24 01/01/2002 01/02/2014 01/01/2002 01/02/2014             0 0     2 Western Addition 29   1 DANIEL BURNHAM CT San Francisco, CA 94109 (37.786987, -122.422537)
195 0083946-01-001 Toy Kan L Toy Kan L Dds 450 Sutter St 2340 San Francisco 1 CA 1 94108 9 08/01/1974 11/01/2017 08/01/1974 11/01/2017         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   450 SUTTER ST San Francisco, CA 94108 (37.789331, -122.407788)
196 0112776-01-001 Barkhordarian George 533 Sutter St Building 533 Sutter St San Francisco 1 CA 1 94102 16 08/01/1976 12/15/2012 08/01/1976 12/15/2012             0 0     3 1 Nob Hill 17   533 SUTTER ST San Francisco, CA 94102 (37.789178, -122.409117)
208 0083973-01-001 Wong James Kay Dds Inc Apc Wong James Kay Dds Inc 644 Broadway St 403b San+francisco 8 CA 1 94133 11 08/08/1974 06/27/2017 08/08/1974 06/27/2017         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0           644 BROADWAY ST San Francisco, CA 94133 (37.797724, -122.40782)
211 0140807-01-001 Sfh Associates Lp Mark Hopkins Hotel 999 California St San Francisco 1 CA 1 94108 9 04/15/1983 03/27/2014 04/15/1983 03/27/2014             0 0     3 1 Nob Hill 17   999 CALIFORNIA ST San Francisco, CA 94108 (37.791791, -122.411265)
218 0031787-01-001 Ronald Fung 1017 Hyde Apts 1017 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968 05/16/2017 10/01/1968 05/16/2017         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1017 HYDE ST San Francisco, CA 94109 (37.790359, -122.417276)
224 0031796-01-001 Chen Richard Y 962-968 Greenwich St Apts 962 Greenwich St San Francisco 1 CA 1 94133 11 01/01/1973 06/30/2015 01/01/1973 06/30/2015             0 0     3 1 Russian Hill 5   962 GREENWICH ST San Francisco, CA 94133 (37.801561, -122.415506)
229 0031796-02-001 Chen Richard Y 811-815 Clement Apts 811 Clement St San Francisco 1 CA 1 94118 6 01/01/1973 06/30/2015 01/01/1973 06/30/2015             0 0     1 6 Inner Richmond 21   811 CLEMENT ST San Francisco, CA 94118 (37.782791, -122.46798)
240 0031796-04-001 Chen Richard Y 14-26 Geary Bldg 14 Geary St San Francisco 1 CA 1 94108 9 01/01/1973 06/30/2015 06/30/1976 06/30/2015             0 0     3 1 Financial District/South Beach 1   14 GEARY ST San Francisco, CA 94108 (37.78794, -122.403678)
247 0181498-03-999 Drayer Charles B Signs Of All Kind 11573 Bodega Hwy Sebastopol 17 CA 1 95472 38 02/20/2008 01/01/2015 02/20/2008 01/01/2015             0 0           11573 BODEGA HWY SEBASTOPOL, CA 95472 (38.381858, -122.89415)
258 0071565-02-001 Maloney Silke Silke's Coiffures 124 Sutter St 3rd Fl San Francisco 1 CA 1 94104 1 07/03/1972 06/26/2015 09/01/2012 06/26/2015             0 0     3 1 Financial District/South Beach 1   124 SUTTER ST San Francisco, CA 94104 (37.789958, -122.402864)
277 0049192-01-002 Cooper & Robinson Inc Cooper & Robinson Inc 265 Eddy St San Francisco 1 CA 1 94102 16 06/01/1969 11/30/2007 01/01/2007 11/30/2007             0 0     6 3 Tenderloin 11   265 EDDY ST San Francisco, CA 94102 (37.784016, -122.411986)
301 0113142-01-001 Tauber Harold L & Susan W Glen Park Hardware 685 Chenery St San Francisco 1 CA 1 94131 14 08/15/1978 11/03/2016 08/15/1978 09/07/2016         4400-4599 3 Retail Trade 3 0 0     8 5 Glen Park 8   685 CHENERY ST San Francisco, CA 94131 (37.734516, -122.433623)
303 0126813-01-001 Febronio Felix & Gloria H Casa Lucas Market 2934 24th St San Francisco 1 CA 1 94110 18 10/25/1980 12/31/1991 10/25/1980 12/31/1991             0 0     9 8 Mission 12   2934 24TH ST San Francisco, CA 94110 (37.752716, -122.410607)
318 0040306-01-001 Chan David 427 Arguello Apts 427 Arguello Blvd San Francisco 1 CA 1 94118 6 10/01/1968 07/21/2016 10/01/1968 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   427 ARGUELLO BLVD San Francisco, CA 94118 (37.78263, -122.458978)
320 0140937-01-001 Weaver Peter C-Ito Jonathan M Animal Connection The 2550 Judah St San Francisco 1 CA 1 94122 19 01/25/1983 12/31/2013 01/25/1983 12/31/2013             0 0     4 10 Sunset/Parkside 14   2550 JUDAH ST San Francisco, CA 94122 (37.761162, -122.489354)
331 0040306-02-001 Chan David 1208-1216 Powell Apts 1208 Powell St San Francisco 1 CA 1 94133 11 10/01/1968 07/21/2016 01/01/1970 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   1208 POWELL ST San Francisco, CA 94133 (37.795827, -122.409933)
347 0040306-03-001 Chan David David & Pauline Chan 2240 Northpoint St San Francisco 1 CA 1 94123 3 10/01/1968 07/21/2016 02/01/2005 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           2240 NORTHPOINT ST San Francisco, CA 94123 (37.802665, -122.444224)
353 0040306-04-001 Chan David David Chan 2240 Northpoint St San+francisco 8 CA 1 94123 3 10/01/1968 07/21/2016 02/01/2005 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           2240 NORTHPOINT ST San Francisco, CA 94123 (37.802665, -122.444224)
354 0141027-03-999 Grundy Michael W Grundy Construction Co 370 Channing Wy 27 San+rafael 22 CA 1 94901 44 06/18/2001 12/31/2014 09/16/2008 12/31/2014         2300-2399 6 Construction 6 0 0           370 CHANNING WY SAN RAFAEL, CA 94901 (38.011831, -122.53754)
366 0040306-05-001 Chan David Powell Street 1208 Powell St San Francisco 1 CA 1 94133 11 10/01/1968 07/21/2016 03/01/2007 07/21/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   1208 POWELL ST San Francisco, CA 94133 (37.795827, -122.409933)
380 0113236-01-001 Sutter Furniture Mfg Inc Sutter Furniture Mfg Inc 275 Capp St San Francisco 1 CA 1 94110 18 07/01/1978 12/19/2014 07/01/1978 12/19/2014             0 0     9 8 Mission 12   275 CAPP ST San Francisco, CA 94110 (37.763111, -122.418387)
427 0040422-01-001 Gordon Walter 430 Castro Rentals 430 Castro St San Francisco 1 CA 1 94114 34 10/01/1968 12/31/2014 10/01/1968 12/31/2014             0 0     8 5 Castro/Upper Market 30   430 CASTRO ST San Francisco, CA 94114 (37.761992, -122.435105)
429 0040422-02-001 Gordon Walter 436 Castro Rentals 436 Castro St San Francisco 1 CA 1 94114 34 10/01/1968 12/31/2014 10/01/1968 12/31/2014             0 0     8 5 Castro/Upper Market 30   436 CASTRO ST San Francisco, CA 94114 (37.761832, -122.435089)
434 0127001-02-999 Calabresi Robert L Rlc Construction 1052 Monterey Ave Foster+city 27 CA 1 94404 30 10/10/1980 04/01/2013 10/01/1993 04/01/2013             0 0           1052 MONTEREY AVE FOSTER CITY, CA 94404 (37.539708, -122.269505)
437 0072015-01-001 Czember Jerry 1782 Union Bldg 1782 Union St San Francisco 1 CA 1 94123 3 07/01/1971 10/14/2016 07/01/1971 10/14/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1782 UNION ST San Francisco, CA 94123 (37.797977, -122.428566)
440 0084731-01-001 Klein Henry Bridge Realty 1454 9th Ave San Francisco 1 CA 1 94122 19 01/01/1973 12/26/2012 01/01/1973 12/26/2012             0 0     5 7 Inner Sunset 13   1454 9TH AVE San Francisco, CA 94122 (37.761129, -122.466104)
441 0201466-01-001 Sibbet Susan H White Mountain Press 762 16th Ave San Francisco 1 CA 1 94118 6 12/06/1990 09/01/2013 12/06/1990 09/01/2013             0 0     1 6 Outer Richmond 9   762 16TH AVE San Francisco, CA 94118 (37.773678, -122.474606)
442 0084731-03-001 Klein Henry 3335-3341 Clement St 3335 Clement St San Francisco 1 CA 1 94121 15 01/01/1973 12/26/2012 03/01/2007 12/26/2012             0 0     1 6 Outer Richmond 9   3335 CLEMENT ST San Francisco, CA 94121 (37.781548, -122.495178)
468 0027235-01-001 Stein H Thomas Stein H Thomas Md 2186 Geary Blvd #211 San+francisco 8 CA 1 94115 4 10/01/1968 07/31/2014 10/01/1968 07/31/2014             0 0           2186 GEARY BLVD San Francisco, CA 94115 (37.783404, -122.439253)
470 0072015-02-001 Czember Jerry Czember Studio 1782 Union St San Francisco 1 CA 1 94123 3 07/01/1971 10/14/2016 01/01/1997 10/14/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1782 UNION ST San Francisco, CA 94123 (37.797977, -122.428566)
477 0027256-01-999 Steiny & Co Inc Steiny & Co Inc 27 Sheridan St Mexico 28   0 5 10/01/1968 12/31/2014 10/01/1968 12/31/2014             0 0           27 SHERIDAN ST MEXICO 00000
491 0113373-01-001 Ort Brent C Ort Brent C Dds 490 Post St 412 San Francisco 1 CA 1 94102 16 06/01/1977 06/30/2017 12/18/2002 06/30/2017         5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Nob Hill 17   490 POST ST San Francisco, CA 94102 (37.788129, -122.409722)
492 0113376-01-001 Colotti Linda M Bay Blossoms Pier 70 San+francisco 8 CA 1 94107 22 04/01/1991 06/28/2016 01/02/2000 06/28/2016             0 0           70 SAN FRANCISCO, CA 94107
499 0209863-02-001 Gady Cecile Cupcakework 613 York St San Francisco 1 CA 1 94110 18 04/01/1990 08/04/2014 06/01/2010 08/04/2014             0 0     10 4 Mission 12   613 YORK ST San Francisco, CA 94110 (37.761413, -122.409124)
502 0049509-01-001 Wong Sydney S & Dora Y Est Of 840-846 Jackson St Bldg 840 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968 12/31/2013 10/01/1968 12/31/2013         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   840 JACKSON ST San Francisco, CA 94133 (37.795728, -122.408992)
507 0300291-01-001 Mcnabb Michael D Mcnabb Software Arts 245 Upper Terrace San Francisco 1 CA 1 94117 33 03/02/1999 01/01/2016 05/01/2002 01/01/2016             0 0     8 5 Castro/Upper Market 30   245 UPPER TERRACE San Francisco, CA 94117 (37.762808, -122.445211)
513 0049509-04-001 Wong Sydney S & Dora Y Est Of 49 Varennes St Apartments 49 Varennes St San Francisco 1 CA 1 94133 11 10/01/1968 12/31/2013 04/13/1981 12/31/2013         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   49 VARENNES ST San Francisco, CA 94133 (37.800431, -122.406752)
514 0049509-05-001 Wong Sydney S & Dora Y Est Of 251 27th Av Apartments 251 27th Ave San Francisco 1 CA 1 94121 15 10/01/1968 12/31/2013 02/26/1981 12/31/2013         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Seacliff 36   251 27TH AVE San Francisco, CA 94121 (37.78466, -122.487215)
518 0301324-01-001 Indig Steve E New Wave Marketing 2572 Alemany Blvd San Francisco 1 CA 1 94112 28 01/01/1997 05/01/2014 01/01/2008 05/01/2014             0 0     11 Outer Mission 35   2572 ALEMANY BLVD San Francisco, CA 94112 (37.714826, -122.446994)
522 0049509-06-001 Wong Sydney S & Dora Y Est Of 205 8th Av Apartments 205 8th Ave San Francisco 1 CA 1 94118 6 10/01/1968 12/31/2013 04/13/1981 12/31/2013         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   205 8TH AVE San Francisco, CA 94118 (37.784515, -122.466702)
523 0141226-01-001 Pioneer Int'l Forwarding Inc Pioneer Intl Forwarding Co 235 Montgomery St 939 San Francisco 1 CA 1 94104 1 02/01/1983 02/28/2014 01/31/2006 02/28/2014             0 0     3 1 Financial District/South Beach 1   235 MONTGOMERY ST San Francisco, CA 94104 (37.791462, -122.402497)
524 0018725-01-001 Mcmicking And Company Llc Mcmicking & Co 500 Sansome St 608 San Francisco 1 CA 1 94111 35 01/01/2000 12/31/2014 01/01/2004 12/31/2014             0 0     3 1 Chinatown 7   500 SANSOME ST San Francisco, CA 94111 (37.795069, -122.401553)
525 0049509-07-001 Wong Sydney S & Dora Y Est Of 840 Jackson St Apartments 840 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968 12/31/2013 04/13/1981 12/31/2013         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   840 JACKSON ST San Francisco, CA 94133 (37.795728, -122.408992)
533 0085382-01-001 Barras Gabriel G Barras Gabriel G Cpa 1388 Sutter St 710 San Francisco 1 CA 1 94109 24 01/01/1974 12/31/2015 01/01/2010 12/31/2015             0 0     2 Western Addition 29   1388 SUTTER ST San Francisco, CA 94109 (37.787397, -122.423011)
538 0127320-04-001 Lee Stephen K 629 Chestnut St 629 Chestnut St San Francisco 1 CA 1 94133 11 01/12/1981 04/01/2015 01/12/1981 04/01/2015             0 0     3 1 North Beach 6   629 CHESTNUT ST San Francisco, CA 94133 (37.803702, -122.413736)
555 0034456-01-001 Mirkovich Kuzma 1560 Green Apts 1560 Green St San Francisco 1 CA 1 94123 3 10/01/1968 05/28/2015 10/01/1968 05/28/2015             0 0     2 Marina 2   1560 GREEN ST San Francisco, CA 94123 (37.797483, -122.424867)
558 0127320-06-001 Lee Stephen K 1750 Grant Ave 1750 Grant Ave San Francisco 1 CA 1 94133 11 01/12/1981 04/01/2015 12/31/2000 04/01/2015             0 0     3 1 North Beach 6   1750 GRANT AVE San Francisco, CA 94133 (37.803069, -122.408083)
567 0034465-02-001 Walter Pang Etal 1563 Hyde Apts 1563 Hyde St San Francisco 1 CA 1 94109 24 10/01/1968 02/11/2015 10/01/1968 02/11/2015             0 0     3 1 Russian Hill 5   1563 HYDE ST San Francisco, CA 94109 (37.795336, -122.418278)
573 0085710-01-001 Bruschera A E & Carmen E 445 Hampshire Bldg 445 Hampshire St San Francisco 1 CA 1 94110 18 04/26/1971 11/26/2014 04/26/1971 11/26/2014             0 0     10 4 Potrero Hill 28   445 HAMPSHIRE ST San Francisco, CA 94110 (37.763678, -122.408393)
575 0304996-00-000 Milarepa Foundation Inc Milarepa Foundation Inc 1880 Century Park E 16th Fl Los+angeles 33 CA 1 90067 56 04/01/1995 09/21/2004 04/01/1995 09/21/2004             0 0           1880 CENTURY PARK E LOS ANGELES, CA 90067 (34.061482, -118.414635)
579 0034472-01-001 Lombardini Elsie A 1565 Greenwich Apts 1565 Greenwich St San Francisco 1 CA 1 94123 3 10/01/1968 01/13/2016 10/01/1968 01/13/2016         5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1565 GREENWICH ST San Francisco, CA 94123 (37.800281, -122.425487)
581 0302034-01-001 Gomez Marcelo Caffe Cozzolino 300 Precita Ave San Francisco 1 CA 1 94110 18 01/02/1997 01/08/2013 01/02/1997 01/07/2013             0 0     9 8 Bernal Heights 19   300 PRECITA AVE San Francisco, CA 94110 (37.746792, -122.413309)
584 0085710-02-001 Bruschera A E & Carmen E Trala Bldg 445 Hampshire St San Francisco 1 CA 1 94110 18 04/26/1971 11/26/2014 08/09/2005 11/26/2014             0 0     10 4 Potrero Hill 28   445 HAMPSHIRE ST San Francisco, CA 94110 (37.763678, -122.408393)
587 0049670-01-001 Ellis Kelly Lion Pub The 2062 Divisadero St San Francisco 1 CA 1 94115 4 07/01/1969 09/11/2016 07/01/1969 09/11/2016         7220-7229 8 Food Services 8 0 0     2 Pacific Heights 16   2062 DIVISADERO ST San Francisco, CA 94115 (37.788674, -122.440568)
593 0040573-02-001 Rizzo Adeline 842 Guerrero St Apartments 842 Guerrero St San Francisco 1 CA 1 94110 18 01/01/1970 01/01/2014 01/01/1970 01/01/2014             0 0     8 5 Mission 12   842 GUERRERO ST San Francisco, CA 94110 (37.757702, -122.423469)
600 0085878-01-001 Zane Kaplan-Estelle Cornick 1053-1055 Market Bldg 1053 Market St San Francisco 1 CA 1 94103 25 01/01/1974 12/11/2013 01/01/1974 12/11/2013             0 0     6 3 South of Market 15   1053 MARKET ST San Francisco, CA 94103 (37.781349, -122.411422)
601 0086002-01-001 West Richard P Dds West Richard P Dds 909 Hyde St 228 San Francisco 1 CA 1 94109 24 09/01/1974 08/31/2015 09/01/1974 08/31/2015             0 0     3 1 Nob Hill 17   909 HYDE ST San Francisco, CA 94109 (37.789609, -122.417122)

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