home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by NAICS Code

✎ View and edit SQL

This data as JSON, CSV (advanced)

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 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 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 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 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)
11 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)
14 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 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 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 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 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 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)
21 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)
23 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 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 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 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)
28 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)
30 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)
33 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 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)
37 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)
41 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)
43 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 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)
46 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 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 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 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 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)
52 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 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 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 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 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)
60 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)
62 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)
65 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 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 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)
75 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 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 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 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)
92 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)
99 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)
102 102 0099555-01-001 Collins Edward J Md Inc Collins Edward J Md Inc 1635 Divisadero St 525 San Francisco 1 CA 1 94115 4 10/01/1976   10/01/1976   2100 Webster St Ste 222 San Francisco 1 94115 2 CA     0 0     5 7 Japantown 22   1635 DIVISADERO ST San Francisco, CA 94115 (37.784843, -122.439845)
103 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 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 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)
110 110 0031779-01-002 Papazian Emmy 2847 Fillmore Apts 320 Judah St San Francisco 1 CA 1 94122 19 10/01/1968   10/26/1993   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     5 7 Inner Sunset 13   320 JUDAH ST San Francisco, CA 94122 (37.762213, -122.465718)
114 114 0099583-01-001 Relos Apolinar D Relos Dental Office 2460 Mission St. 202 San Francisco 1 CA 1 94110 18 10/01/1976   04/01/1998   2460 Mission St #202 San Francisco 1 94110 37 CA     0 0     9 8 Mission 12   2460 MISSION ST San Francisco, CA 94110 (37.757692, -122.418961)
117 117 0034382-02-001 Mecham Woodrow J & Sally 75 Capra Way Apts 75 Capra Way San Francisco 1 CA 1 94123 3 10/01/1968   05/21/1996   400 Montgomery St Ste 1110 San Francisco 1 94104 1 CA     0 0     2 Marina 2   75 CAPRA WAY San Francisco, CA 94123 (37.802792, -122.43969)
122 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)
124 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 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 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)
134 134 0031779-02-001 Papazian Emmy 688 Teresita Blvd Apts 688 Teresita Blvd San Francisco 1 CA 1 94127 31 10/01/1968   09/25/1992   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     7 9 West of Twin Peaks 26   688 TERESITA BLVD San Francisco, CA 94127 (37.735795, -122.446376)
138 138 0031779-03-001 Papazian Emmy 1379 30th Ave Apts 1379 30th Ave San Francisco 1 CA 1 94122 19 10/01/1968   11/17/1986   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     4 10 Sunset/Parkside 14   1379 30TH AVE San Francisco, CA 94122 (37.761664, -122.488846)
140 140 0071434-01-001 Williams Marion & Geraldine 190 Victoria Apts 190 Victoria St San Francisco 1 CA 1 94132 32 01/01/1972   01/01/1972   35 Grove St Ste 108 San Francisco 1 94102 16 CA     0 0     11 Oceanview/Merced/Ingleside 27   190 VICTORIA ST San Francisco, CA 94132 (37.714068, -122.46531)
154 154 0038303-01-001 Rodriguez Pearl 296 Union St Apts 296 Union St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   1800 Atrium Pkwy Apt 414 Napa 24 94559 44 CA     0 0     3 1 North Beach 6   296 UNION ST San Francisco, CA 94133 (37.801061, -122.404195)
159 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)
160 160 0140577-01-001 Vogel Richard J Vogel Sales 90 Loomis St San Francisco 1 CA 1 94124 8 02/01/1983   01/05/1993   Po Box 27674 San Francisco 1 94127 46 CA     0 0     10 4 Bayview Hunters Point 4   90 LOOMIS ST San Francisco, CA 94124 (37.742835, -122.404102)
161 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)
175 175 0166489-02-001 Tucker Suzanne Marketing Solutions 211 14th Ave San Francisco 1 CA 1 94118 6 01/01/2001   01/01/2001   211 14th Ave San Francisco 1 94118 28 CA     0 0     1 6 Outer Richmond 9   211 14TH AVE San Francisco, CA 94118 (37.784145, -122.473119)
180 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)
188 188 0011673-01-001 Stauffacher Jack W Greenwood Press 300 Broadway St 300 San+francisco 8 CA 1 94133 11 10/01/1968   10/01/1968   1945 Broadway #305 San Francisco 1 94109 7 CA     0 0           300 BROADWAY ST San Francisco, CA 94133 (37.798383, -122.4026)
190 190 0140625-05-001 Davanloo Hooshang Contempo Hair Design 4 Embarcadero Center San Francisco 1 CA 1 94111 35 04/02/1983   12/02/2012   163 Prince Royal Drive Corte Madera 28 94925 53 CA     0 0           4 EMBARCADERO CENTER San Francisco, CA 94111 (37.795106, -122.396158)
193 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 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)
196 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)
210 210 0112785-02-001 Louie Hung Yue 531-533 5th Av Apts 533 5th Ave San Francisco 1 CA 1 94118 6 05/01/1974   05/01/1974   654 Grant Av #11 San Francisco 1 94108 22 CA     0 0     1 6 Inner Richmond 21   533 5TH AVE San Francisco, CA 94118 (37.778533, -122.463032)
211 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)
213 213 0040106-01-001 Ng May L 41 Terra Vista Apts 41 Terra Vista Ave San Francisco 1 CA 1 94115 4 10/01/1968   10/01/1968   41 Terra Vista Av San Francisco 1 94115 2 CA     0 0     2 Lone Mountain/USF 24   41 TERRA VISTA AVE San Francisco, CA 94115 (37.781532, -122.442349)
217 217 0140848-01-001 Uomini Christine Uomini Christine Photographer 3055 Gough St 304 San Francisco 1 CA 1 94123 3 04/01/1983   04/01/1983   1 Mastick Ct Alameda 31 94501 57 CA     0 0     2 Marina 2   3055 GOUGH ST San Francisco, CA 94123 (37.801651, -122.427983)
224 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)
226 226 0140848-02-001 Uomini Christine You & Eye Health Consultations 3055 Gough St 304 San Francisco 1 CA 1 94123 3 04/01/1983   01/24/2007   1 Mastick Ct Alameda 31 94501 57 CA     0 0     2 Marina 2   3055 GOUGH ST San Francisco, CA 94123 (37.801651, -122.427983)
227 227 0112884-02-001 Creighton Inc Donahues Marina Lounge 2138 Chestnut St San Francisco 1 CA 1 94123 3 07/01/1978   01/01/1996   2138 Chestnut St San Francisco 1 94123 48 CA     0 0 H86 Bars/taverns W/o Food Prep 2 Marina 2   2138 CHESTNUT ST San Francisco, CA 94123 (37.800507, -122.438655)
229 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 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 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)
249 249 0052914-01-001 Lee Way Koon 1401-1411 Grant Rentals 1401 Grant Ave San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   5040 Anza St San Francisco 1 94121 17 CA     0 0     3 1 North Beach 6   1401 GRANT AVE San Francisco, CA 94133 (37.799874, -122.40744)
253 253 0182193-01-999 Muncie Reclamation And Supply Company Muncie Reclamation And Supply Co 3720 S Madison St Brisbane+q4068 3   0 5 01/01/1988   01/01/1988   3720 South Madison St Muncie 38 47302 64 IN     0 0           3720 S MADISON ST 00000 (40.159438, -85.381701)
257 257 0052914-03-001 Lee Way Koon 647 Irving St 647 Irving St San Francisco 1 CA 1 94122 19 10/01/1968   01/01/1994   5040 Anza St San Francisco 1 94121 17 CA     0 0     5 7 Inner Sunset 13   647 IRVING ST San Francisco, CA 94122 (37.764103, -122.464968)
258 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)
261 261 0071613-01-001 Suess Frank R Downtown Watch Repair 210 Post St 304 San Francisco 1 CA 1 94108 9 04/01/1972   04/01/1972   210 Post St #304 San Francisco 1 94108 22 CA     0 0     3 1 Financial District/South Beach 1   210 POST ST San Francisco, CA 94108 (37.788678, -122.405371)
262 262 0183884-02-999 Micro Motion Inc Micro Motion Inc 7070 Winchester Cir Boulder 19 CO 3 80301 40 01/01/1994   01/01/1994   7070 Winchester Cir Boulder 39 80301 65 CO     0 0           7070 WINCHESTER CIR BOULDER, CO 80301 (40.077338, -105.192054)
267 267 0140878-01-001 Travelfast Intl Inc Travelfast Intl Inc 870 Market St 611 San Francisco 1 CA 1 94102 16 01/01/1983   01/01/1983   870 Market St 607 Ste San Francisco 1 94102 16 CA     0 0     3 1 Financial District/South Beach 1   870 MARKET ST San Francisco, CA 94102 (37.784761, -122.407108)
274 274 0026883-01-001 Chevron Texaco Corp Chevron Texaco Corp 575 Market Street San Francisco 1 CA 1 94105 7 10/01/1968   02/14/2002   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     6 3 Financial District/South Beach 1   575 MARKET STREET San Francisco, CA 94105 (37.789897, -122.4006)
275 275 0026883-01-004 Chevron Texaco Corp Chevron Texaco Corp 2399 Market St San Francisco 1 CA 1 94114 34 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     8 5 Castro/Upper Market 30   2399 MARKET ST San Francisco, CA 94114 (37.762674, -122.435056)
277 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)
279 279 0026883-01-005 Chevron Texaco Corp Chevron Texaco Corp 1601 Mission St San Francisco 1 CA 1 94103 25 10/01/1968   01/01/2000   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     6 3 Mission 12   1601 MISSION ST San Francisco, CA 94103 (37.772239, -122.419028)
280 280 0026883-04-001 Chevron Texaco Corp 512 Arguello Bldg 512 Arguello Blvd San Francisco 1 CA 1 94118 6 10/01/1968   01/01/1972   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     1 6 Lone Mountain/USF 24   512 ARGUELLO BLVD San Francisco, CA 94118 (37.780725, -122.458848)
281 281 0140878-03-001 Travelfast Intl Inc Mango Communications 870 Market St 607 San Francisco 1 CA 1 94102 16 01/01/1983   11/03/1999   870 Market St 607 Ste San Francisco 1 94102 16 CA     0 0     3 1 Financial District/South Beach 1   870 MARKET ST San Francisco, CA 94102 (37.784761, -122.407108)
282 282 0026883-05-002 Chevron Texaco Corp Chevron 1501 Van Ness Ave 30 San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     2 Western Addition 29   1501 VAN NESS AVE San Francisco, CA 94109 (37.78968, -122.422274)
285 285 0026883-05-006 Chevron Texaco Corp Chevron 1790 Lombard St 3535 San Francisco 1 CA 1 94123 3 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     2 Marina 2   1790 LOMBARD ST San Francisco, CA 94123 (37.800547, -122.43087)
286 286 0049213-01-001 Wirth Anthony C 5907 Geary Apts 5907 Geary Blvd San Francisco 1 CA 1 94121 15 01/13/1969   01/13/1969   1878 15th Ave San Francisco 1 94122 15 CA     0 0     1 6 Outer Richmond 9   5907 GEARY BLVD San Francisco, CA 94121 (37.780117, -122.482664)
290 290 0052928-01-001 Alberici Pauline 2360/2362 Folsom Apts 2360 Folsom St San Francisco 1 CA 1 94110 18 10/01/1968   10/01/1968   0000 Undeliverable Mail San Francisco 1 99999 12 CA     0 0     9 8 Mission 12   2360 FOLSOM ST San Francisco, CA 94110 (37.759544, -122.414751)
292 292 0026883-05-007 Chevron Texaco Corp Chevron 2465 Van Ness Ave 34 San Francisco 1 CA 1 94109 24 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     2 Marina 2   2465 VAN NESS AVE San Francisco, CA 94109 (37.798289, -122.424012)
295 295 0026883-05-010 Chevron Texaco Corp Chevron 2000 Market St San Francisco 1 CA 1 94114 34 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     8 5 Hayes Valley 10   2000 MARKET ST San Francisco, CA 94114 (37.769482, -122.426563)
296 296 0026883-05-011 Chevron Texaco Corp Chevron 6000 Geary Blvd San Francisco 1 CA 1 94121 15 10/01/1968   10/01/1968   6001 Bollinger Canyon Rd V2002 San Ramon 41 94583 67 CA     0 0     1 6 Outer Richmond 9   6000 GEARY BLVD San Francisco, CA 94121 (37.780194, -122.48394)

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