home / registered-business-locations

Registered_Business_Locations_-_San_Francisco

Data source: data.sfgov.org

226,184 rows sorted by Business End Date

View and edit SQL

Suggested facets: Supervisor District, Business Corridor

NAICS Code Description

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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
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)
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)
101 0140437-01-001 Cake Gallery Inc The Cake Gallery Inc The 290 9th St San Francisco 1 CA 1 94103 25 03/17/1983   03/17/1983   290 9th St San Francisco 1 94103 32 CA 7220-7229 8 Food Services 8 0 0 H88 Retail Bakeries With Food Prep 6 3 South of Market 15   290 9TH ST San Francisco, CA 94103 (37.773836, -122.411676)
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)
106 0048894-02-001 Chong Hing Co Inc 848 Grant Bldg 848 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   848 GRANT AVE San Francisco, CA 94108 (37.794872, -122.406426)
107 0083768-02-999 Armstrong Installation Ser In Armstrong Painting Roof & Wind 4575 San Pablo Ave Emeryville Emeryville 13 CA 1 94608 29 02/01/1973   07/01/2003   4575 San Pablo Ave Emeryville 18 94608 35 CA 2300-2399 6 Construction 6 0 0 D19 Storage & Use Of Flammable Or Combustible Liquids       4575 SAN PABLO AVE EMERYVILLE EMERYVILLE, CA 94608 (37.835404, -122.281343)
108 0126717-05-001 Legallet Properties Llc 1001 Quesada Av 1001 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   1001 QUESADA AVE San Francisco, CA 94124 (37.726154, -122.378767)
109 0005037-04-999 Honeywell International Inc Honeywell International Inc 353a Vintage Park Dr Foster City 14 CA 1 94404 30 10/01/1968   06/12/2006   Po Box 524 Mn10 182a Minneapolis 19 55440 36 MN 3100-3399 10 Manufacturing 10 0 0           353A VINTAGE PARK DR FOSTER CITY, CA 94404 (37.565365, -122.278755)
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)
111 0083797-01-001 Chambers & Chambers Inc Chambers & Chambers 2140 Palou Ave San Francisco 1 CA 1 94124 8 01/01/1974   09/21/1998   2140 Palou Ave San Francisco 1 94124 6 CA 4200-4299 7 Wholesale Trade 7 0 0 H73 Deemed Approved Off-Sale Alcohol Use 10 4 Bayview Hunters Point 4   2140 PALOU AVE San Francisco, CA 94124 (37.739787, -122.401031)
112 0000265-06-003 Stephens Institute Inc Academy Of Art University 180 New Montgomery St San Francisco 1 CA 1 94105 7 10/01/1968   04/28/1995   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0 D03 D04 D39 Multiple 6 3 Financial District/South Beach 1   180 NEW MONTGOMERY ST San Francisco, CA 94105 (37.786634, -122.399502)
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)
115 0040064-02-001 Chin F Chin J Louie L Payne-Fong Building 405 6th Ave. San Francisco 1 CA 1 94118 6 10/01/1968   10/13/2000   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)
116 0071179-01-001 Deluca Anthony C & Michael 1801 Greenwich Apts 1801 Greenwich St San Francisco 1 CA 1 94123 3 01/01/1970   01/01/1970   51 Lunada Ct San Rafael 20 94901 38 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     2 Marina 2   1801 GREENWICH ST San Francisco, CA 94123 (37.799755, -122.42957)
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)
118 0112362-01-001 Lee Dale Innovations 182 Bernard St San Francisco 1 CA 1 94109 24 06/27/1978   06/27/1978 06/01/2015 1835 30th Ave San Francisco 1 94122 15 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Nob Hill 17   182 BERNARD ST San Francisco, CA 94109 (37.796169, -122.416489)
119 0000265-06-004 Stephens Institute Inc Academy Of Art University 540 Powell 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 D04 Places Of Public Assembly & Open-Air Assembly 3 1 Financial District/South Beach 1   540 POWELL ST San Francisco, CA 94108 (37.789736, -122.408673)
120 0048894-03-001 Chong Hing Co Inc 933-939 Grant Av Bldg 933 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   933 GRANT AVE San Francisco, CA 94108 (37.795646, -122.406581)
121 0048894-04-001 Chong Hing Co Inc 740 Jackson St Apts 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)
125 0000265-06-005 Stephens Institute Inc Academy Of Art University 460 Townsend St San Francisco 1 CA 1 94107 22 10/01/1968   10/02/2009   79 New Montgomery St San Francisco 1 94105 5 CA 6100-6299 4 Private Education and Health Services 4 0 0     6 3 Mission Bay 25   460 TOWNSEND ST San Francisco, CA 94107 (37.774234, -122.398633)
127 0040069-01-001 Pezzi A Co 407 Greenwich Apts 407-411 Greenwich St San Francisco 1 CA 1 94133 11 10/01/1968   10/01/1968   331 Orchard Avenue Redwood City 21 94061 39 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 North Beach 6   407 411 GREENWICH ST SAN FRANCISCO, CA 94133 (37.802632, -122.406779)
128 0161414-02-001 Wilkinson George F G F Wilkinson Books 34 Trinity Pl San Francisco 1 CA 1 94104 1 01/01/1987   10/01/2011   782 30th Ave San Francisco 1 94121 17 CA 4400-4599 3 Retail Trade 3 0 0           34 TRINITY PL San Francisco, CA 94104 (37.79031, -122.402557)
129 0112474-01-002 Rafaels Boutique Inc The Rafaels Boutique Inc The 643 Market St San Francisco 1 CA 1 94105 7 07/07/1978   03/13/2000   643 Market St San Francisco 1 94105 5 CA 4400-4599 3 Retail Trade 3 0 0     6 3 Financial District/South Beach 1   643 MARKET ST San Francisco, CA 94105 (37.78848, -122.402395)
131 0048894-05-001 Chong Hing Co Inc 742 Jackson Rentals 742 Jackson St San Francisco 1 CA 1 94133 11 10/01/1968   12/31/1988   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   742 JACKSON ST San Francisco, CA 94133 (37.795927, -122.407415)
132 0061015-01-001 Wong Ngao Ngen & Fay 4600-4604 California Apts 4600 California St San Francisco 1 CA 1 94118 6 05/01/1969   05/01/1969   183 8th Av San Francisco 1 94118 28 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     1 6 Inner Richmond 21   4600 CALIFORNIA ST San Francisco, CA 94118 (37.784723, -122.466718)
133 0011650-01-001 Dare Rose Dare Rose 966 Pine St San Francisco 1 CA 1 94108 9 09/17/1973   09/17/1973   966 Pine St San Francisco 1 94108 22 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     3 1 Nob Hill 17   966 PINE ST San Francisco, CA 94108 (37.790728, -122.411831)
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)
135 0140506-01-001 Liang Hsung Ying Liang Dr Medical Office 2000 Van Ness Ave 607 San Francisco 1 CA 1 94109 24 04/01/1983   05/01/2008   2000 Van Ness Ave Ste 607 San Francisco 1 94109 7 CA 5400-5499 1 Professional, Scientific, and Technical Services 1 0 0     3 1 Russian Hill 5   2000 VAN NESS AVE San Francisco, CA 94109 (37.794086, -122.423016)
136 0126717-06-001 Legallet Properties Llc 1031 Quesada Av 1031 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   1031 QUESADA AVE San Francisco, CA 94124 (37.726629, -122.379611)
137 0048894-06-001 Chong Hing Co Inc 933-939 Grant Av Rentals 933 Grant Ave San Francisco 1 CA 1 94108 9 10/01/1968   12/31/1988   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   933 GRANT AVE San Francisco, CA 94108 (37.795646, -122.406581)
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)
139 0011651-01-001 Greene Howard C Inc Greene Howard C Inc 276 11th St San Francisco 1 CA 1 94103 25 10/01/1968   10/01/1968   30 Daryl Ave Novato 22 94947 40 CA 5300-5399 2 Real Estate and Rental and Leasing Services 2 0 0     6 3 Mission 12   276 11TH ST San Francisco, CA 94103 (37.77228, -122.414562)
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)

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