home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows

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
1 0126694-01-001 Andreani Carlo Andreani Carlo 582 Market St 811 San Francisco 1 CA 1 94104 1 12/31/1995   12/31/1995   582 Market St #811 San Francisco 1 94104 1 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Financial District/South Beach 1   582 MARKET ST San Francisco, CA 94104 (37.78926, -122.401407)
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)
4 0062143-01-001 King Bertha A Parker 1563 Lyon Apts 1563 Lyon St San Francisco 1 CA 1 94115 4 10/01/1968   10/01/1968   1563 Lyon St San Francisco 1 94115 2 CA     0 0     2 Presidio Heights 3   1563 LYON ST San Francisco, CA 94115 (37.785323, -122.444977)
5 0074024-01-999 Western Shower Door Co., Inc. Western Shower Door Co., Inc. 99 Menlo Park Ca Brisbane+q4068 3   0 5 01/01/1973   01/01/1973   47000 Warm Springs Blvd Ste 1 Fremont 2 94539 3 CA     0 0           99 MENLO PARK 00000 (40.367952, -75.294567)
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)
7 0011436-01-001 Ono Margaret Gosha Do Co 53 Blake St San Francisco 1 CA 1 94118 6 10/01/1968   12/01/1999   Po Box 590431 San Francisco 1 94159 4 CA 4400-4599 3 Retail Trade 3 0 0     2 Presidio Heights 3   53 BLAKE ST San Francisco, CA 94118 (37.782911, -122.451313)
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)
9 0126717-02-001 Legallet Properties Llc 1099 Quesada Property 1099 Quesada Ave San Francisco 1 CA 1 94124 8 10/01/1968   06/18/2009   1401 Griffith St San Francisco 1 94124 6 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   1099 QUESADA AVE San Francisco, CA 94124 (37.727009, -122.380286)
10 0015092-01-001 Jug Shop Inc Jug Shop Inc 1590 Pacific Ave San Francisco 1 CA 1 94108 9 10/01/1968   08/28/2006   1590 Pacific Av San Francisco 1 94109 7 CA 4400-4599 3 Retail Trade 3 0 0 H31 H73 H87 Multiple 3 1 Russian Hill 5   1590 PACIFIC AVE San Francisco, CA 94108 (37.79504, -122.421452)
11 0087962-03-999 Jack Nadel Inc Jack Nadel International 2335 American River Dr 301 Sacramento 4 CA 1 95825 10 10/17/2006   10/24/2006   8701 Bellanca Ave Los Angeles 3 90045 8 CA     0 0           2335 AMERICAN RIVER DR SACRAMENTO, CA 95825 (38.569605, -121.409084)
12 0005879-01-002 Clean A Rama Maintenance Servi Clean A Rama Maintenance Co 526 Columbus Ave 2nd Fl San Francisco 1 CA 1 94133 11 10/01/1968   10/01/2011   526 Columbus Ave 2nd Floor San Francisco 1 94133 9 CA 8100-8139 5 Certain Services 5 0 0     3 1 North Beach 6   526 COLUMBUS AVE San Francisco, CA 94133 (37.799794, -122.4094)
13 0042500-08-999 Brondello A & Crespi V Bbc Investments 251 Layayette Cir 250 Yountville 5 CA 1 94599 12 10/01/1968   01/02/2002   700 Ygnacio Valley Rd #120 Walnut Creek 4 94596 10 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0           251 LAYAYETTE CIR YOUNTVILLE, CA 94599
14 0063039-01-001 Lee Sing Yee Assn 1060-1064 Stockton St Apts 1060 Stockton St San Francisco 1 CA 1 94108 9 11/01/1970   11/01/1970   500 Sansome St Ste 502 San Francisco 1 94111 11 CA     0 0     3 1 Chinatown 7   1060 STOCKTON ST San Francisco, CA 94108 (37.795552, -122.408216)
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)
17 0030053-01-001 Walker John & Co Walker John & Co 175 Sutter St San Francisco 1 CA 1 94104 1 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     3 1 Financial District/South Beach 1   175 SUTTER ST San Francisco, CA 94104 (37.789857, -122.403613)
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)
19 0036027-01-001 Jack A. Price 201 Waller St Apts 201 Waller St San Francisco 1 CA 1 94102 16 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     5 7 Hayes Valley 10   201 WALLER ST San Francisco, CA 94102 (37.771559, -122.427239)
20 0130792-05-999 Wang Joe Jw Flooring 116 Starlite St A S San Fran 7 CA 1 94080 17 11/26/1997   01/02/2006   483 Victory Ave So San Fran 5 94080 13 CA 2300-2399 6 Construction 6 0 0           116 STARLITE ST A S SAN FRAN, CA 94080 (37.650321, -122.416416)
21 0144569-01-002 Malouf Rachid Cheese Boutique 666 Chenery St San Francisco 1 CA 1 94131 14 01/01/1984   04/01/1993 06/13/2012 660a Chenery St San Francisco 1 94131 14 CA     0 0     8 5 Glen Park 8   666 CHENERY ST SAN FRANCISCO, CA 94131 (37.734525, -122.433373)
22 0011460-01-001 Gow Supply Co Gow Supply Company 1492 Egbert Ave San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   Po Box 24160 San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids 10 4 Bayview Hunters Point 4   1492 EGBERT AVE San Francisco, CA 94124 (37.7237, -122.394428)
23 0075434-01-001 21 Taylor Inc 21 Taylor Club 98 Turk St San Francisco 1 CA 1 94102 16 01/01/1972   01/01/1972   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     6 3 Tenderloin 11   98 TURK ST San Francisco, CA 94102 (37.78322, -122.410771)
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)
27 0011460-05-001 Gow Supply Co Gow Supply Company 1478-80 Egbert Ave San Francisco 1 CA 1 94124 8 10/01/1968   04/09/1975   Po Box 24160 San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1478 80 EGBERT AVE San Francisco, CA 94124 (37.723488, -122.394058)
28 0031779-01-001 Papazian Emmy 2847 Fillmore Apts 2847 Fillmore St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     2 Marina 2   2847 FILLMORE ST San Francisco, CA 94123 (37.795916, -122.435252)
29 0126717-03-001 Legallet Properties Llc 1100 Shafter Bldg 1100 Shafter Ave San Francisco 1 CA 1 94124 8 10/01/1968   06/18/2009   1401 Griffith St San Francisco 1 94124 6 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   1100 SHAFTER AVE San Francisco, CA 94124 (37.725807, -122.381491)
30 0145642-01-001 Biscay Jacques & Leonie 414-416 Warren Apts 414 Warren Dr San Francisco 1 CA 1 94131 14 01/01/1984   01/01/1984   14 Forest Knolls Dr San Francisco 1 94131 14 CA     0 0     7 9 Inner Sunset 13   414 WARREN DR San Francisco, CA 94131 (37.757056, -122.46168)
31 0091345-01-001 Heard Marjorie A Last Straw The 4540 Irving St San Francisco 1 CA 1 94122 19 09/01/1975   09/01/1975   4540 Irving St San Francisco 1 94122 15 CA 4400-4599 3 Retail Trade 3 0 0     4 10 Sunset/Parkside 14   4540 IRVING ST San Francisco, CA 94122 (37.762281, -122.506493)
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)
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)
34 0146534-03-001 Tran Xien Vuong Ten 393-399 Eddy St Building 393 Eddy St San Francisco 1 CA 1 94102 16 05/01/1984   01/01/1987   395 Eddy St San Francisco 1 94102 16 CA     0 0     6 3 Tenderloin 11   393 EDDY ST San Francisco, CA 94102 (37.783757, -122.414039)
35 0011460-06-001 Gow Supply Co Gow Supply Company 1490 Egbert St San+francisco 8 CA 1 94124 8 10/01/1968   04/09/1975   Po Box 24160 San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0           1490 EGBERT ST San Francisco, CA 94124 (37.723609, -122.394268)
36 0075634-01-001 Boiko Maria A 4434 Fulton Apts 4434 Fulton St San Francisco 1 CA 1 94121 15 01/01/1972   01/01/1972   462 17th Av San Francisco 1 94121 17 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   4434 FULTON ST San Francisco, CA 94121 (37.772769, -122.479442)
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)
38 0046324-21-999 Compass Group Usa Inc Imageworks 9050 W Washington Blvd Culver+city 10 CA 1 90232 20 10/01/1968   11/01/2011   2400 Yorkmont Rd Charlotte 6 28217 18 NC 7220-7229 8 Food Services 8 0 0           9050 W WASHINGTON BLVD CULVER CITY, CA 90232
39 0126717-04-001 Legallet Properties Llc 1001-58 Quesada Ave Bldg 1160 Quesada Ave San Francisco 1 CA 1 94124 8 10/01/1968   10/01/1968   1401 Griffith St San Francisco 1 94124 6 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     10 4 Bayview Hunters Point 4   1160 QUESADA AVE San Francisco, CA 94124 (37.727675, -122.38143)
40 0145700-01-999 Koledo Patricia S Vitalsigns 801 Middlefield Rd 11 Palo+alto 11 CA 1 94301 21 04/15/1984   04/02/1999   801 Middlefield Rd #11 Palo Alto 7 94301 19 CA 6100-6299 4 Private Education and Health Services 4 0 0           801 MIDDLEFIELD RD PALO ALTO, CA 94301 (37.44816, -122.152714)
41 0033127-01-001 Wong David 3421 20th St Rentals 3421 20th St San Francisco 1 CA 1 94110 18 10/01/1968   10/01/1968   835 Excelsior Av San Francisco 1 94112 20 CA     0 0     9 8 Mission 12   3421 20TH ST San Francisco, CA 94110 (37.758732, -122.417492)
42 0040050-04-001 Arsanis Lynn/speizer Lee Etal 5541-5549 Geary Bldg 5541 Geary Blvd San Francisco 1 CA 1 94121 15 10/01/1968   08/01/1969   Po Box 591540 San Francisco 1 94159 4 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   5541 GEARY BLVD San Francisco, CA 94121 (37.780297, -122.478746)
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)
45 0046744-01-001 Giovanni Albert & Eleanor Etc 918 Taraval Bldg 918 Taraval St San Francisco 1 CA 1 94116 23 10/01/1968   10/01/1968   400 Light Springs Rd Aptos 8 95003 21 CA 7210-7219 9 Accommodations 9 0 0     4 10 Sunset/Parkside 14   918 TARAVAL ST San Francisco, CA 94116 (37.743048, -122.476)
46 0056200-02-001 Central City Hospitality Hous Central City Hospitality House 290 Turk St San Francisco 1 CA 1 94102 16 08/06/2004   08/06/2004   288 Turk St San Francisco 1 94102 16 CA     0 0     6 3 Tenderloin 11   290 TURK ST San Francisco, CA 94102 (37.782819, -122.413926)
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)
49 0038695-05-001 Lam Fong Shiu Yuen Shiu Yuen L. Fong 917-921 Pacific Ave San Francisco 1 CA 1 94133 11 10/01/1968   12/31/2000   2026 Clement St #1 San Francisco 1 94121 17 CA     0 0     3 1 Chinatown 7   917 921 PACIFIC AVE San Francisco, CA 94133 (37.796451, -122.410454)
50 0039003-01-001 Gapirio Enez Etal 3316 Laguna Apts 3316 Laguna St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     2 Marina 2   3316 LAGUNA ST San Francisco, CA 94123 (37.801723, -122.43137)
51 0056557-04-001 Chan Tane Www.wokshop.com 718 Grant Ave San Francisco 1 CA 1 94108 9 07/01/1969   01/01/1997   718 Grant Ave San Francisco 1 94108 22 CA 4400-4599 3 Retail Trade 3 0 0     3 1 Chinatown 7   718 GRANT AVE San Francisco, CA 94108 (37.793617, -122.406185)
52 0039450-01-001 Schiariti Anthony 3570 Pierce St Apts 3570 Pierce St San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     2 Marina 2   3570 PIERCE ST San Francisco, CA 94123 (37.803509, -122.440133)
53 0047749-07-001 Recology San Francisco Recology San Francisco 94 Pier 94 San+francisco 8 CA 1 94124 8 10/01/1968   01/01/2013   250 Executive Park Blvd Suite 2100 San Francisco 1 94134 23 CA     0 0           94 PIER San Francisco, CA 94124 (37.793776, -122.392656)
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)
56 0149901-05-001 Idg Consumer & Smb Inc Pc World 501 2nd St San Francisco 1 CA 1 94110 18 11/27/1982   06/01/2012   5 Speen St Framingham 9 01701 24 MA     0 0     6 3 Financial District/South Beach 1   501 2ND ST San Francisco, CA 94110 (37.782757, -122.393234)
57 0082044-01-999 Tera-Lite Inc Tera-Lite Inc 1631 So. 10th St Brisbane+q4068 3   0 5 08/01/1974   08/01/1974   1631 So 10th St San Jose 10 95112 25 CA 2300-2399 6 Construction 6 0 0           1631 SO 10TH ST 00000 (38.276861, -104.581499)
58 0059503-01-001 Giusto Enterprises Inc Town House Motel 1650 Lombard St San Francisco 1 CA 1 94123 3 06/01/1970   06/01/1970   7525 Mission St Daly City 11 94014 26 CA 7210-7219 9 Accommodations 9 0 1     2 Marina 2   1650 LOMBARD ST San Francisco, CA 94123 (37.800837, -122.428629)
59 0150975-01-999 Dulberg Bernard M Bernies Repairs 2130 Rosewood Dr Brisbane+q4068 3   0 5 05/02/1985   05/02/1985   2130 Rosewood Dr San Bruno 12 94066 27 CA 2300-2399 6 Construction 6 0 0           2130 ROSEWOOD DR 00000 (34.977529, -81.008222)
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)
63 0011460-07-001 Gow Supply Co Gow Supply Company 5945 3rd St A San Francisco 1 CA 1 94124 8 10/01/1968   02/18/2014   Po Box 24160 San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   5945 3RD ST A San Francisco, CA 94124 (37.724364, -122.394681)
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)
67 0034315-01-001 Wong Lonnie 1533 Larkin Rentals 1533 Larkin St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1533 Larkin St San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1533 LARKIN ST San Francisco, CA 94109 (37.792189, -122.419341)
68 0112212-01-001 Yamagami Dick N Dickey & Dickey Co 2252 Clement St San Francisco 1 CA 1 94121 15 06/15/1978   06/15/1978   42 Commonwealth Ave San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Outer Richmond 9   2252 CLEMENT ST San Francisco, CA 94121 (37.782064, -122.483655)
69 0152271-01-999 Decisionone Corp. Decisionone Inc. Po 3004 Frazer Pa Brisbane+q4068 3   0 5 01/29/1985   01/29/1985   426 W Lancaster Ave Devon 13 19333 29 PA 8100-8139 5 Certain Services 5 0 0            
70 0140430-01-001 3119 Jackson St Assocs 3119 Jackson St Apartments 3119 Jackson St San Francisco 1 CA 1 94115 4 01/01/1978   01/01/1978   Po Box 15746 San Francisco 1 94115 2 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Presidio Heights 3   3119 JACKSON ST San Francisco, CA 94115 (37.79095, -122.446523)
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)
72 0099397-01-001 Wong Louis K C Dot Printing & Stationery 828 Stockton St San Francisco 1 CA 1 94108 9 09/22/1976   09/22/1976 12/07/2015 828 Stockton St San Francisco 1 94108 22 CA 8100-8139 5 Certain Services 5 0 0           828 STOCKTON ST San Francisco, CA 94108 (37.793485, -122.407792)
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)
74 0071073-02-001 Fabiano Frank Franks Shoe Reparing 2609 San Bruno Ave San Francisco 1 CA 1 94134 26 11/04/1969   04/10/1972   2609 San Bruno Ave San Francisco 1 94134 23 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Portola 18   2609 SAN BRUNO AVE San Francisco, CA 94134 (37.728574, -122.403997)
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)
76 0140430-02-001 3119 Jackson St Assocs 3119 Jackson St Assocs-Csbd 3119 Jackson St San Francisco 1 CA 1 94115 4 01/01/1978   01/01/1983   Po Box 15746 San Francisco 1 94115 2 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Presidio Heights 3   3119 JACKSON ST San Francisco, CA 94115 (37.79095, -122.446523)
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)
78 0099404-01-001 Ofer Ben & Miriam 981 Folsom St Bldg 981 Folsom St San Francisco 1 CA 1 94107 22 01/30/1975   01/01/1988   35 Almaden Ct San Francisco 1 94118 28 CA 2300-2399 6 Construction 6 0 0     6 3 South of Market 15   981 FOLSOM ST San Francisco, CA 94107 (37.778947, -122.405071)
79 0099472-03-999 Hardwoods Uslp Hardwoods Inc Northern Califor 5621 Skylane Blvd Livermore 12 CA 1 94550 27 06/25/1998   06/25/1998   Po Box 157 Blaine 14 98231 30 WA 4200-4299 7 Wholesale Trade 7 0 0           5621 SKYLANE BLVD LIVERMORE, CA 94550
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)
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)
82 0099497-01-001 Edmund Y K & Lorraine T Dun 1462 California Apts 1462 California St San Francisco 1 CA 1 94109 24 06/16/1976   06/16/1976   6507 Hagen Bl El Cerrito 15 94530 31 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   1462 CALIFORNIA ST San Francisco, CA 94109 (37.790863, -122.418424)
83 0034320-01-001 Mah King Min 1534 Jackson Apts 1534 Jackson St San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   1534 Jackson St #3 San Francisco 1 94109 7 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Russian Hill 5   1534 JACKSON ST San Francisco, CA 94109 (37.794276, -122.420367)
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)
85 0071073-03-001 Fabiano Frank 2611 San Bruno Apts 2611 San Bruno Ave San Francisco 1 CA 1 94134 26 11/04/1969   03/01/1976   2609 San Bruno Ave San Francisco 1 94134 23 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Portola 18   2611 SAN BRUNO AVE San Francisco, CA 94134 (37.72871, -122.404054)
86 0034352-01-001 Hurd Henry A & Sarah L Trustee 871 San Jose Apts 871 San Jose Ave San Francisco 1 CA 1 94110 18 10/01/1968   10/01/1968   4444 Geary Blvd #105 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     9 8 Bernal Heights 19   871 SAN JOSE AVE San Francisco, CA 94110 (37.741268, -122.423613)
87 0112259-01-001 Lee Vincent & Sylvia 1571 9th Av Apts 1571 9th Ave San Francisco 1 CA 1 94122 19 08/20/1976   08/20/1976   2928 Fulton St San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     7 9 Inner Sunset 13   1571 9TH AVE San Francisco, CA 94122 (37.759028, -122.465959)
88 0140431-01-001 Andrew L Gescheidt Etal Popular Mechanix 252 14th St San Francisco 1 CA 1 94103 25 03/28/1983   03/28/1983   252 14th St San Francisco 1 94103 32 CA 8100-8139 5 Certain Services 5 0 0 D23 Vehicle Repair Garage - Major 9 8 Mission 12   252 14TH ST San Francisco, CA 94103 (37.76835, -122.418982)
89 0011579-01-001 Graybar Electric Co Graybar Electric Co 1760 Cesar Chavez St A San Francisco 1 CA 1 94124 8 12/30/1998   03/02/2006   1370 Valley Vista Dr Suite 100 Vendor 9976101 Diamond Bar 16 91765 33 CA 4200-4299 7 Wholesale Trade 7 0 0     10 4 Bayview Hunters Point 4   1760 CESAR CHAVEZ ST A San Francisco, CA 94124
90 0025733-73-001 San Francisco Parking Inc Millennium Towers 301 Mission St San Francisco 1 CA 1 94105 7 10/01/1968 12/31/2015 06/01/2011 12/31/2015   San Francisco 1 99999 12   8100-8139 5 Certain Services 5 0 0     6 3 Financial District/South Beach 1   301 MISSION ST San Francisco, CA 94105 (37.790753, -122.396321)
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)
92 0140436-01-001 Console Anthony Tonys Hair Studio 847 Columbus Ave San Francisco 1 CA 1 94133 11 03/28/1983   03/28/1983   845 Columbus Ave San Francisco 1 94133 9 CA     0 0     3 1 Russian Hill 5   847 COLUMBUS AVE SAN FRANCISCO, CA 94133 (37.802539, -122.41342)
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)
94 0034352-02-001 Hurd Henry A & Sarah L Trustee 2160 Leavenworth St 2160 Leavenworth St San Francisco 1 CA 1 94133 11 10/01/1968   12/31/2010   4444 Geary Blvd #105 San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Russian Hill 5   2160 LEAVENWORTH ST San Francisco, CA 94133 (37.801116, -122.417781)
95 0048893-01-001 Toms Investments Co Inc 855 Grant Av Bldg 855 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   855 GRANT AVE San Francisco, CA 94108 (37.794746, -122.406403)
96 0034354-01-001 Ternullo Eugenia 154 Portola Apts 154 Portola Dr San Francisco 1 CA 1 94131 14 10/01/1968   10/01/1968   710 Laurel Ave Millbrae 17 94030 34 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     8 5 Twin Peaks 20   154 PORTOLA DR San Francisco, CA 94131 (37.748417, -122.444236)
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)
98 0040064-01-001 Chin F Chin J Louie L 405 6th Av Apts 405 6th Ave San Francisco 1 CA 1 94118 6 10/01/1968   10/01/1968   551 Pacific Ave San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   405 6TH AVE San Francisco, CA 94118 (37.780882, -122.464281)
99 0140436-02-001 Console Anthony 845 Columbus Ave Bldg 845 Columbus Ave San Francisco 1 CA 1 94133 11 03/28/1983   01/01/1994   845 Columbus Ave San Francisco 1 94133 9 CA     0 0     3 1 Russian Hill 5   845 COLUMBUS AVE San Francisco, CA 94133 (37.802554, -122.413441)
100 0048894-01-001 Chong Hing Co Inc 740/742 Jackson Bldg 740 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   740 Jackson St San Francisco 1 94133 9 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Chinatown 7   740 JACKSON ST San Francisco, CA 94133 (37.795931, -122.407385)

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